]> git.evergreen-ils.org Git - working/Evergreen.git/commit
1. Add a boolean "negate" column to query.expression.
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 6 May 2010 16:00:37 +0000 (16:00 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 6 May 2010 16:00:37 +0000 (16:00 +0000)
commit0f73d47ad7faca68058619a0affc9e6575764e31
tree90fd354464891fa1d0e73a3ddae4207bad308218
parentb8d7c543ee2a2ed8a6e1c6beb8b4519ddace8e2d
1. Add a boolean "negate" column to query.expression.

2. Remove the valid values 'xnbet' (for NOT BETWEEN), 'xnex' (for
NOT EXIST) and 'xnin' (for NOT IN) for the column query.expression.type.
We will represent those types with 'xbet', 'xnex', and 'xin',
respectively, combined with negate = TRUE.

3. Eliminate the updatable views defined for the valid values
removed above.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
M    Open-ILS/src/sql/Pg/008.schema.query.sql
A    Open-ILS/src/sql/Pg/upgrade/0252.schema.query-negation.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16395 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/008.schema.query.sql
Open-ILS/src/sql/Pg/upgrade/0252.schema.query-negation.sql [new file with mode: 0644]