From 8a055d66f43592c257cece2eb8cc021808062917 Mon Sep 17 00:00:00 2001 From: Timothy Pearson Date: Tue, 29 Nov 2011 01:11:08 -0600 Subject: Initial TQt conversion --- examples3/SQL/testdb_pg.sql | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) (limited to 'examples3/SQL/testdb_pg.sql') diff --git a/examples3/SQL/testdb_pg.sql b/examples3/SQL/testdb_pg.sql index 73a4270..ef0479f 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: SEQUENCE Owner: postgres +-- Name: people_id_seq Type: SETQUENCE Owner: postgres -- -CREATE SEQUENCE "people_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SETQUENCE "people_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- TOC Entry ID 4 (OID 17353) -- --- Name: staff_id_seq Type: SEQUENCE Owner: postgres +-- Name: staff_id_seq Type: SETQUENCE Owner: postgres -- -CREATE SEQUENCE "staff_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SETQUENCE "staff_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- TOC Entry ID 6 (OID 17355) -- --- Name: creditors_id_seq Type: SEQUENCE Owner: postgres +-- Name: creditors_id_seq Type: SETQUENCE Owner: postgres -- -CREATE SEQUENCE "creditors_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SETQUENCE "creditors_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -- -- TOC Entry ID 8 (OID 17357) -- --- Name: invoice_id_seq Type: SEQUENCE Owner: postgres +-- Name: invoice_id_seq Type: SETQUENCE Owner: postgres -- -CREATE SEQUENCE "invoice_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SETQUENCE "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: SEQUENCE SET Owner: postgres +-- Name: people_id_seq Type: SETQUENCE 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: SEQUENCE SET Owner: postgres +-- Name: staff_id_seq Type: SETQUENCE 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: SEQUENCE SET Owner: postgres +-- Name: creditors_id_seq Type: SETQUENCE 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: SEQUENCE SET Owner: postgres +-- Name: invoice_id_seq Type: SETQUENCE SET Owner: postgres -- SELECT setval ('"invoice_id_seq"', 1, false); -- cgit v1.2.3