LP#1479953: Rename indexes to *_idx and add pgTAP test.
authorJason Stephenson <jstephenson@mvlc.org>
Thu, 6 Aug 2015 15:13:00 +0000 (11:13 -0400)
committerJason Stephenson <jstephenson@mvlc.org>
Thu, 6 Aug 2015 15:44:26 +0000 (11:44 -0400)
commit57d756fb33f225233fa73d3dffc6f1d32b4b31d1
treec26d057096e0de2f22225c9a724981570c3d8800
parent679578d86ecb56885e956ad07a864b2c96808295
LP#1479953: Rename indexes to *_idx and add pgTAP test.

To make the new index names more consistent with existing indices,
I took the liberty of adding _idx to the new index names.

We also add a pgTAP test to verify that the new indices exist in
the database.  The test would fail before running the upgrade
script and succeed after.

Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/201.acq.audit-functions.sql
Open-ILS/src/sql/Pg/t/regress/lp1479953_has_indexes.pg [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.index.queued_record.sql