X-Git-Url: https://git.evergreen-ils.org/?p=working%2FEvergreen.git;a=blobdiff_plain;f=Open-ILS%2Fsrc%2Fsql%2FPg%2F008.schema.query.sql;h=8c511f4e67355bbc106fdcda8dc85985ad123626;hp=6fef65ed8d1251237e8da9c011acc514e2fcce77;hb=db4a24f4face9716597bfe3593048b9709683516;hpb=bd2bbccc85833a69461275e29407e9cc00796703

diff --git a/Open-ILS/src/sql/Pg/008.schema.query.sql b/Open-ILS/src/sql/Pg/008.schema.query.sql
index 6fef65ed8d..8c511f4e67 100644
--- 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,
-	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)