diff options
Diffstat (limited to 'examples3/SQL/testdb_pg.sql')
| -rw-r--r-- | examples3/SQL/testdb_pg.sql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/examples3/SQL/testdb_pg.sql b/examples3/SQL/testdb_pg.sql index ef0479f..73a4270 100644 --- a/examples3/SQL/testdb_pg.sql +++ b/examples3/SQL/testdb_pg.sql @@ -93,34 +93,34 @@ CREATE TABLE "invoiceitem" ( -- -- TOC Entry ID 2 (OID 17351) -- --- Name: people_id_seq Type: SETQUENCE Owner: postgres +-- Name: people_id_seq Type: SEQUENCE Owner: postgres -- -CREATE SETQUENCE "people_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SEQUENCE "people_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- TOC Entry ID 4 (OID 17353) -- --- Name: staff_id_seq Type: SETQUENCE Owner: postgres +-- Name: staff_id_seq Type: SEQUENCE Owner: postgres -- -CREATE SETQUENCE "staff_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SEQUENCE "staff_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- TOC Entry ID 6 (OID 17355) -- --- Name: creditors_id_seq Type: SETQUENCE Owner: postgres +-- Name: creditors_id_seq Type: SEQUENCE Owner: postgres -- -CREATE SETQUENCE "creditors_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SEQUENCE "creditors_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- TOC Entry ID 8 (OID 17357) -- --- Name: invoice_id_seq Type: SETQUENCE Owner: postgres +-- Name: invoice_id_seq Type: SEQUENCE Owner: postgres -- -CREATE SETQUENCE "invoice_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SEQUENCE "invoice_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- Data for TOC Entry ID 28 (OID 17332) @@ -201,7 +201,7 @@ COPY "invoiceitem" FROM stdin; -- -- TOC Entry ID 3 (OID 17351) -- --- Name: people_id_seq Type: SETQUENCE SET Owner: postgres +-- Name: people_id_seq Type: SEQUENCE SET Owner: postgres -- SELECT setval ('"people_id_seq"', 1, false); @@ -209,7 +209,7 @@ SELECT setval ('"people_id_seq"', 1, false); -- -- TOC Entry ID 5 (OID 17353) -- --- Name: staff_id_seq Type: SETQUENCE SET Owner: postgres +-- Name: staff_id_seq Type: SEQUENCE SET Owner: postgres -- SELECT setval ('"staff_id_seq"', 8, true); @@ -217,7 +217,7 @@ SELECT setval ('"staff_id_seq"', 8, true); -- -- TOC Entry ID 7 (OID 17355) -- --- Name: creditors_id_seq Type: SETQUENCE SET Owner: postgres +-- Name: creditors_id_seq Type: SEQUENCE SET Owner: postgres -- SELECT setval ('"creditors_id_seq"', 1, false); @@ -225,7 +225,7 @@ SELECT setval ('"creditors_id_seq"', 1, false); -- -- TOC Entry ID 9 (OID 17357) -- --- Name: invoice_id_seq Type: SETQUENCE SET Owner: postgres +-- Name: invoice_id_seq Type: SEQUENCE SET Owner: postgres -- SELECT setval ('"invoice_id_seq"', 1, false); |