Add limit_count and offset_count columns to query.stored_query table.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 008.schema.query.sql
index 6fef65e..8c511f4 100644 (file)
@@ -38,8 +38,10 @@ CREATE TABLE  query.stored_query (
                                     --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
+       limit_count   INT,
+       offset_count  INT
 );
 
 -- (Foreign keys to be defined later after other tables are created)