1 |
-- |
-- |
2 |
-- Selected TOC Entries: |
-- Selected TOC Entries: |
3 |
-- |
-- |
|
\connect - dpavlin |
|
4 |
DROP TABLE "user_product"; |
DROP TABLE "user_product"; |
5 |
DROP TABLE "products"; |
DROP TABLE "products"; |
6 |
DROP SEQUENCE "products_product_id_seq"; |
DROP SEQUENCE "products_product_id_seq"; |
8 |
DROP PROCEDURAL LANGUAGE 'plpgsql'; |
DROP PROCEDURAL LANGUAGE 'plpgsql'; |
9 |
DROP FUNCTION "plpgsql_call_handler" (); |
DROP FUNCTION "plpgsql_call_handler" (); |
10 |
-- |
-- |
11 |
-- TOC Entry ID 7 (OID 93059) |
-- TOC Entry ID 6 (OID 93059) |
12 |
-- |
-- |
13 |
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin |
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin |
14 |
-- |
-- |
16 |
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; |
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; |
17 |
|
|
18 |
-- |
-- |
19 |
-- TOC Entry ID 8 (OID 93060) |
-- TOC Entry ID 7 (OID 93060) |
20 |
-- |
-- |
21 |
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: |
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: |
22 |
-- |
-- |
24 |
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; |
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; |
25 |
|
|
26 |
-- |
-- |
27 |
-- TOC Entry ID 4 (OID 93061) |
-- TOC Entry ID 3 (OID 93061) |
28 |
-- |
-- |
29 |
-- Name: users Type: TABLE Owner: dpavlin |
-- Name: users Type: TABLE Owner: dpavlin |
30 |
-- |
-- |
46 |
CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
47 |
|
|
48 |
-- |
-- |
49 |
-- TOC Entry ID 5 (OID 93096) |
-- TOC Entry ID 4 (OID 93096) |
50 |
-- |
-- |
51 |
-- Name: products Type: TABLE Owner: dpavlin |
-- Name: products Type: TABLE Owner: dpavlin |
52 |
-- |
-- |
98 |
); |
); |
99 |
|
|
100 |
-- |
-- |
101 |
-- TOC Entry ID 6 (OID 93195) |
-- TOC Entry ID 5 (OID 93195) |
102 |
-- |
-- |
103 |
-- Name: user_product Type: TABLE Owner: dpavlin |
-- Name: user_product Type: TABLE Owner: dpavlin |
104 |
-- |
-- |
122 |
Constraint "user_product_pkey" Primary Key ("login", "product_id") |
Constraint "user_product_pkey" Primary Key ("login", "product_id") |
123 |
); |
); |
124 |
|
|
|
-- |
|
|
-- 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'); |
|
|
|
|