--- fcproducts.sql 2001/06/06 09:04:28 1.1 +++ fcproducts.sql 2001/06/06 09:24:26 1.2 @@ -1,7 +1,6 @@ -- -- Selected TOC Entries: -- -\connect - dpavlin DROP TABLE "user_product"; DROP TABLE "products"; DROP SEQUENCE "products_product_id_seq"; @@ -9,7 +8,7 @@ DROP PROCEDURAL LANGUAGE 'plpgsql'; DROP FUNCTION "plpgsql_call_handler" (); -- --- TOC Entry ID 7 (OID 93059) +-- TOC Entry ID 6 (OID 93059) -- -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin -- @@ -17,7 +16,7 @@ CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; -- --- TOC Entry ID 8 (OID 93060) +-- TOC Entry ID 7 (OID 93060) -- -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: -- @@ -25,7 +24,7 @@ CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; -- --- TOC Entry ID 4 (OID 93061) +-- TOC Entry ID 3 (OID 93061) -- -- Name: users Type: TABLE Owner: dpavlin -- @@ -47,7 +46,7 @@ CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 5 (OID 93096) +-- TOC Entry ID 4 (OID 93096) -- -- Name: products Type: TABLE Owner: dpavlin -- @@ -99,7 +98,7 @@ ); -- --- TOC Entry ID 6 (OID 93195) +-- TOC Entry ID 5 (OID 93195) -- -- Name: user_product Type: TABLE Owner: dpavlin -- @@ -123,52 +122,3 @@ Constraint "user_product_pkey" Primary Key ("login", "product_id") ); --- --- Data for TOC Entry ID 9 (OID 93061) --- --- Name: users Type: TABLE DATA Owner: dpavlin --- - - -COPY "users" FROM stdin; -dpavlin pero99 Dobrica Pavlinusic dpavlin@pliva.hr -test test -test2 -\. --- --- Data for TOC Entry ID 10 (OID 93096) --- --- Name: products Type: TABLE DATA Owner: dpavlin --- - - -COPY "products" FROM stdin; -2 New \N \N \N \N \N \N \N \N \N \N \N -1 Acetazolamid http://fcproducts.pliva.hr/.index.php?A=V&F=ACETAZ Mud171t4.gif Tralala... \ -Komentar. \ - \ - \ - \ - \ -ITD. TEST 8c61cc3d3cad45ac4c747089a1665ec7.gif -\. --- --- Data for TOC Entry ID 11 (OID 93195) --- --- Name: user_product Type: TABLE DATA Owner: dpavlin --- - - -COPY "user_product" FROM stdin; -dpavlin 1 t t t t \N f \N f f t t \N t -test2 1 t t t t t t t t t t t t t -test 1 \N \N \N \N \N \N \N \N \N \N \N \N \N -\. --- --- TOC Entry ID 3 (OID 93077) --- --- Name: products_product_id_seq Type: SEQUENCE SET Owner: --- - -SELECT setval ('"products_product_id_seq"', 1, 't'); -