1 |
dpavlin |
1.1 |
-- |
2 |
|
|
-- Selected TOC Entries: |
3 |
|
|
-- |
4 |
|
|
\connect - postgres |
5 |
|
|
-- |
6 |
|
|
-- TOC Entry ID 8 (OID 18720) |
7 |
|
|
-- |
8 |
|
|
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres |
9 |
|
|
-- |
10 |
|
|
|
11 |
|
|
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; |
12 |
|
|
|
13 |
|
|
-- |
14 |
|
|
-- TOC Entry ID 9 (OID 18721) |
15 |
|
|
-- |
16 |
|
|
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: |
17 |
|
|
-- |
18 |
|
|
|
19 |
|
|
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; |
20 |
|
|
|
21 |
|
|
\connect - dpavlin |
22 |
|
|
-- |
23 |
|
|
-- TOC Entry ID 2 (OID 776747) |
24 |
|
|
-- |
25 |
|
|
-- Name: news_id_seq Type: SEQUENCE Owner: dpavlin |
26 |
|
|
-- |
27 |
|
|
|
28 |
|
|
CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
29 |
|
|
|
30 |
|
|
-- |
31 |
|
|
-- TOC Entry ID 4 (OID 776766) |
32 |
|
|
-- |
33 |
|
|
-- Name: news Type: TABLE Owner: dpavlin |
34 |
|
|
-- |
35 |
|
|
|
36 |
|
|
CREATE TABLE "news" ( |
37 |
|
|
"id" integer DEFAULT nextval('"news_id_seq"'::text) NOT NULL, |
38 |
|
|
"title" text NOT NULL, |
39 |
|
|
"town_date" text, |
40 |
|
|
"body" text, |
41 |
|
|
"more" text, |
42 |
|
|
"pdf" text, |
43 |
|
|
"date" date, |
44 |
|
|
"type" character(3), |
45 |
|
|
"pic" character varying(20), |
46 |
|
|
"origpic" character varying(20), |
47 |
|
|
"visible" boolean DEFAULT 't', |
48 |
|
|
"priority" integer DEFAULT 0 |
49 |
|
|
); |
50 |
|
|
|
51 |
|
|
-- |
52 |
|
|
-- TOC Entry ID 5 (OID 776805) |
53 |
|
|
-- |
54 |
|
|
-- Name: menu Type: TABLE Owner: dpavlin |
55 |
|
|
-- |
56 |
|
|
|
57 |
|
|
CREATE TABLE "menu" ( |
58 |
|
|
"section" text, |
59 |
|
|
"level" integer DEFAULT 1, |
60 |
|
|
"item" text, |
61 |
|
|
"url" text, |
62 |
|
|
"file" text, |
63 |
|
|
"num" integer DEFAULT 0, |
64 |
|
|
"visible" boolean DEFAULT 'f', |
65 |
|
|
"w" integer, |
66 |
|
|
"h" integer |
67 |
|
|
); |
68 |
|
|
|
69 |
|
|
-- |
70 |
|
|
-- Data for TOC Entry ID 10 (OID 776766) |
71 |
|
|
-- |
72 |
|
|
-- Name: news Type: TABLE DATA Owner: dpavlin |
73 |
|
|
-- |
74 |
|
|
|
75 |
|
|
|
76 |
|
|
COPY "news" FROM stdin; |
77 |
|
|
4 Veliki karavan Zagreb, ni na nebu ni na zemlji... PLIVA Ljubljana kreće na veliko i naporno putovanje prema Kini. Cilj - pronaći i dovući što više svile.
\ |
78 |
|
|
<p>misc: Nasveti</p> 2001-06-28 mn_ \N t 0 |
79 |
|
|
3 Tarzan, kommt hier! Kuala Lumpur, 1938 Tarzan! Tarzan!
\ |
80 |
|
|
<p>misc: Smernice O-m</p> 2001-06-29 msx \N t 0 |
81 |
|
|
2 Vrag Vas odnio Vrag Vas odnio Heto radim tu nesto, nesto. Testiranje i tako to.
\ |
82 |
|
|
<p>evnt: Pliva.si dogotki</p> TestSI.htm 2001-06-29 ep_ \N t 0 |
83 |
|
|
5 Gotovo je Ljubljana, 25 Juni 2001. Gotovo je - nema više.
\ |
84 |
|
|
<p>news: Strokovne novice O-m</p> 2001-06-25 ndx \N t 0 |
85 |
|
|
1 Početak izrade pliva.si dinamičkog web-a 28.6.2001. join us and share the joy!
\ |
86 |
|
|
<p>news: Novice</p> PR_loan_extension-25_06_01a.pdf 2001-06-28 nn_ \N t 0 |
87 |
|
|
6 A-ha! Ljubljana, 29 Juni 2001. A-ha! koncert u Ljubljani. Za sve ljubitelje švedskih "slavuja".
\ |
88 |
|
|
<p>evnt: Dogotki O-m</p> Test-2.htm 2001-06-29 epx \N t 5 |
89 |
|
|
9 KusKus Ljubljana, 29 Juni 2001. misc: Medicus O-m Medikus01_2001.pdf 2001-06-29 mcx \N t 0 |
90 |
|
|
7 Bikerski koncert za zdravnike Kuala Lumpur, 1938 Wrooom!!!!
\ |
91 |
|
|
<p>misc: Kongresi O-m</p> Test-3slika.htm 2001-06-21 mkx snjesko.gif \N t 0 |
92 |
|
|
8 Pharma Info Zagreb, 20 June 2001. misc: Pharma info O-m 2001-06-20 mpx \N t 0 |
93 |
|
|
10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0 |
94 |
|
|
\. |
95 |
|
|
-- |
96 |
|
|
-- Data for TOC Entry ID 11 (OID 776805) |
97 |
|
|
-- |
98 |
|
|
-- Name: menu Type: TABLE DATA Owner: dpavlin |
99 |
|
|
-- |
100 |
|
|
|
101 |
|
|
|
102 |
|
|
COPY "menu" FROM stdin; |
103 |
|
|
sladkorna 1 Mali leksikon \N mali_leksikon.gif 200 t 125 13 |
104 |
|
|
o_nas 3 V svetu \N v_svetu.gif 45 t 125 13 |
105 |
|
|
o_nas 3 Sporočila za javnost \N sporo_ila_za_javnost.gif 35 t 125 13 |
106 |
|
|
o_nas 3 Raziskovne in\\nrazvoj \N raziskovne_in_nrazvoj.gif 40 t 125 26 |
107 |
|
|
o_nas 1 Zaposleni o_nas.php?h=zaposleni zaposleni.gif 10 t 125 13 |
108 |
|
|
izdelki 1 Zdravila brez recepta \N zdravila_brez_recepta.gif 50 t 125 13 |
109 |
|
|
izdelki 1 Raskužila \N rasku_ila.gif 55 t 125 13 |
110 |
|
|
izdelki 1 Diagnostika \N diagnostika.gif 60 t 125 13 |
111 |
|
|
izdelki 1 Veterina \N veterina.gif 65 t 125 13 |
112 |
|
|
nasveti 1 Izobraževalni kotiček \N izobra_evalni_koti_ek.gif 70 t 125 13 |
113 |
|
|
nasveti 1 Mali leksikon \N mali_leksikon.gif 75 t 125 13 |
114 |
|
|
nasveti 1 Koristni nasveti \N koristni_nasveti.gif 80 t 125 13 |
115 |
|
|
za_zdravnike 1 Zdravilo \N zdravilo.gif 85 t 125 13 |
116 |
|
|
za_zdravnike 1 Zdravljenje XYZ \N zdravljenje_xyz.gif 110 t 125 13 |
117 |
|
|
sladkorna 2 Učna Ura \N u_na_ura.gif 205 t 125 13 |
118 |
|
|
za_zdravnike 2 Publikacije \N publikacije.gif 90 t 125 13 |
119 |
|
|
o_nas 2 PLIVA http://www.pliva.hr/ pliva.gif 20 t 125 13 |
120 |
|
|
o_nas 3 Letno Poročilo http://www.pliva.hr/results.php?type=a letno_poro_ilo.gif 25 t 125 13 |
121 |
|
|
o_nas 3 PLIVA Magazin \N pliva_magazin.gif 30 t 125 13 |
122 |
|
|
za_zdravnike 3 Medicus za_zdravnike.php?p=publikacije&type=mcx medicus.gif 100 t 125 13 |
123 |
|
|
za_zdravnike 3 Pharma Info za_zdravnike.php?p=publikacije&type=mpx pharma_info.gif 95 t 125 13 |
124 |
|
|
za_zdravnike 3 Medinfo za_zdravnike.php?p=publikacije&type=mix medinfo.gif 105 t 125 13 |
125 |
|
|
o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13 |
126 |
|
|
\. |
127 |
|
|
-- |
128 |
|
|
-- TOC Entry ID 6 (OID 776766) |
129 |
|
|
-- |
130 |
|
|
-- Name: "news_id_key" Type: INDEX Owner: dpavlin |
131 |
|
|
-- |
132 |
|
|
|
133 |
|
|
CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" ); |
134 |
|
|
|
135 |
|
|
-- |
136 |
|
|
-- TOC Entry ID 7 (OID 776805) |
137 |
|
|
-- |
138 |
|
|
-- Name: "menu_num" Type: INDEX Owner: dpavlin |
139 |
|
|
-- |
140 |
|
|
|
141 |
|
|
CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); |
142 |
|
|
|
143 |
|
|
-- |
144 |
|
|
-- TOC Entry ID 3 (OID 776747) |
145 |
|
|
-- |
146 |
|
|
-- Name: news_id_seq Type: SEQUENCE SET Owner: |
147 |
|
|
-- |
148 |
|
|
|
149 |
|
|
SELECT setval ('"news_id_seq"', 10, 't'); |
150 |
|
|
|