Add limit_count and offset_count columns to query.stored_query table.

[working/Evergreen.git] / Open-ILS / src / sql / Pg / 008.schema.query.sql

diff --git a/Open-ILS/src/sql/Pg/008.schema.query.sql b/Open-ILS/src/sql/Pg/008.schema.query.sql
index 6fef65e..8c511f4 100644 (file)
--- a/Open-ILS/src/sql/Pg/008.schema.query.sql
+++ b/Open-ILS/src/sql/Pg/008.schema.query.sql
@@ -38,8 +38,10 @@ CREATE TABLE  query.stored_query (
                                     --DEFERRABLE INITIALLY DEFERRED,
        where_clause  INT,           --REFERENCES query.expression
                                     --DEFERRABLE INITIALLY DEFERRED,
                                     --DEFERRABLE INITIALLY DEFERRED,
        where_clause  INT,           --REFERENCES query.expression
                                     --DEFERRABLE INITIALLY DEFERRED,

-       having_clause INT            --REFERENCES query.expression
+       having_clause INT,           --REFERENCES query.expression

                                     --DEFERRABLE INITIALLY DEFERRED
                                     --DEFERRABLE INITIALLY DEFERRED

+       limit_count   INT,
+       offset_count  INT

 );
 
 -- (Foreign keys to be defined later after other tables are created)
 );
 
 -- (Foreign keys to be defined later after other tables are created)