Create a schema named "query" instead of "sql" (which is a
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 30 Nov 2009 20:35:11 +0000 (20:35 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 30 Nov 2009 20:35:11 +0000 (20:35 +0000)
commit8d11e9235042f376e832771a8192c266cbc9472d
tree73662880a8da0a513e34527715b7e45f745ccc04
parent4be18f61c838ba232c6d4c5b5f0c9d5f70327a75
Create a schema named "query" instead of "sql" (which is a
reserved word).

Note that two previous upgrade scripts are being changed.  If you have
already run them, you can run them again after manually deleting two
entries from config.upgrade.log:

DELETE FROM config.upgrade.log
WHERE version in ( '0097', '0098' );

The 0097.schema.sql-datatype.sql will drop the misbegotten sql
schema if it exists.

A    Pg/008.schema.query.sql
M    Pg/upgrade/0098.schema.sql-stored-query.sql
M    Pg/upgrade/0097.schema.sql-datatype.sql
D    Pg/008.schema.sql.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@15047 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/008.schema.query.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/008.schema.sql.sql [deleted file]
Open-ILS/src/sql/Pg/upgrade/0097.schema.sql-datatype.sql
Open-ILS/src/sql/Pg/upgrade/0098.schema.sql-stored-query.sql