20 |
|
|
21 |
\connect - dpavlin |
\connect - dpavlin |
22 |
-- |
-- |
23 |
-- TOC Entry ID 2 (OID 115229) |
-- TOC Entry ID 2 (OID 801263) |
24 |
-- |
-- |
25 |
-- Name: news_id_seq Type: SEQUENCE Owner: dpavlin |
-- Name: news_id_seq Type: SEQUENCE Owner: dpavlin |
26 |
-- |
-- |
28 |
CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
29 |
|
|
30 |
-- |
-- |
31 |
-- TOC Entry ID 8 (OID 115248) |
-- TOC Entry ID 8 (OID 801282) |
32 |
-- |
-- |
33 |
-- Name: news Type: TABLE Owner: dpavlin |
-- Name: news Type: TABLE Owner: dpavlin |
34 |
-- |
-- |
49 |
); |
); |
50 |
|
|
51 |
-- |
-- |
52 |
-- TOC Entry ID 9 (OID 115287) |
-- TOC Entry ID 9 (OID 801321) |
53 |
-- |
-- |
54 |
-- Name: menu Type: TABLE Owner: dpavlin |
-- Name: menu Type: TABLE Owner: dpavlin |
55 |
-- |
-- |
67 |
); |
); |
68 |
|
|
69 |
-- |
-- |
70 |
-- TOC Entry ID 10 (OID 115323) |
-- TOC Entry ID 10 (OID 801357) |
71 |
-- |
-- |
72 |
-- Name: countries Type: TABLE Owner: dpavlin |
-- Name: countries Type: TABLE Owner: dpavlin |
73 |
-- |
-- |
78 |
); |
); |
79 |
|
|
80 |
-- |
-- |
81 |
-- TOC Entry ID 11 (OID 115349) |
-- TOC Entry ID 11 (OID 801383) |
82 |
-- |
-- |
83 |
-- Name: emails Type: TABLE Owner: dpavlin |
-- Name: emails Type: TABLE Owner: dpavlin |
84 |
-- |
-- |
89 |
); |
); |
90 |
|
|
91 |
-- |
-- |
92 |
-- TOC Entry ID 4 (OID 115375) |
-- TOC Entry ID 4 (OID 801409) |
93 |
-- |
-- |
94 |
-- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin |
-- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin |
95 |
-- |
-- |
97 |
CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
98 |
|
|
99 |
-- |
-- |
100 |
-- TOC Entry ID 12 (OID 115394) |
-- TOC Entry ID 12 (OID 801428) |
101 |
-- |
-- |
102 |
-- Name: zaposleni Type: TABLE Owner: dpavlin |
-- Name: zaposleni Type: TABLE Owner: dpavlin |
103 |
-- |
-- |
115 |
); |
); |
116 |
|
|
117 |
-- |
-- |
118 |
-- TOC Entry ID 6 (OID 115428) |
-- TOC Entry ID 6 (OID 801462) |
119 |
-- |
-- |
120 |
-- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin |
-- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin |
121 |
-- |
-- |
123 |
CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
124 |
|
|
125 |
-- |
-- |
126 |
-- TOC Entry ID 13 (OID 115447) |
-- TOC Entry ID 13 (OID 801481) |
127 |
-- |
-- |
128 |
-- Name: multi Type: TABLE Owner: dpavlin |
-- Name: multi Type: TABLE Owner: dpavlin |
129 |
-- |
-- |
140 |
); |
); |
141 |
|
|
142 |
-- |
-- |
143 |
-- Data for TOC Entry ID 21 (OID 115248) |
-- Data for TOC Entry ID 21 (OID 801282) |
144 |
-- |
-- |
145 |
-- Name: news Type: TABLE DATA Owner: dpavlin |
-- Name: news Type: TABLE DATA Owner: dpavlin |
146 |
-- |
-- |
166 |
10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0 |
10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0 |
167 |
\. |
\. |
168 |
-- |
-- |
169 |
-- Data for TOC Entry ID 22 (OID 115287) |
-- Data for TOC Entry ID 22 (OID 801321) |
170 |
-- |
-- |
171 |
-- Name: menu Type: TABLE DATA Owner: dpavlin |
-- Name: menu Type: TABLE DATA Owner: dpavlin |
172 |
-- |
-- |
190 |
sladkorna 2 Učna Ura \N u_na_ura.gif 205 t 125 13 |
sladkorna 2 Učna Ura \N u_na_ura.gif 205 t 125 13 |
191 |
za_zdravnike 2 Publikacije \N publikacije.gif 90 t 125 13 |
za_zdravnike 2 Publikacije \N publikacije.gif 90 t 125 13 |
192 |
o_nas 2 PLIVA http://www.pliva.hr/ pliva.gif 20 t 125 13 |
o_nas 2 PLIVA http://www.pliva.hr/ pliva.gif 20 t 125 13 |
|
o_nas 3 Letno Poročilo http://www.pliva.hr/results.php?type=a letno_poro_ilo.gif 25 t 125 13 |
|
193 |
o_nas 3 PLIVA Magazin \N pliva_magazin.gif 30 t 125 13 |
o_nas 3 PLIVA Magazin \N pliva_magazin.gif 30 t 125 13 |
194 |
za_zdravnike 3 Medicus za_zdravnike.php?p=publikacije&type=mcx medicus.gif 100 t 125 13 |
za_zdravnike 3 Medicus za_zdravnike.php?p=publikacije&type=mcx medicus.gif 100 t 125 13 |
195 |
za_zdravnike 3 Pharma Info za_zdravnike.php?p=publikacije&type=mpx pharma_info.gif 95 t 125 13 |
za_zdravnike 3 Pharma Info za_zdravnike.php?p=publikacije&type=mpx pharma_info.gif 95 t 125 13 |
196 |
za_zdravnike 3 Medinfo za_zdravnike.php?p=publikacije&type=mix medinfo.gif 105 t 125 13 |
za_zdravnike 3 Medinfo za_zdravnike.php?p=publikacije&type=mix medinfo.gif 105 t 125 13 |
197 |
o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13 |
o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13 |
198 |
|
o_nas 3 Letno Poročilo o_nas.php?p=annual letno_poro_ilo.gif 25 t 125 13 |
199 |
\. |
\. |
200 |
-- |
-- |
201 |
-- Data for TOC Entry ID 23 (OID 115323) |
-- Data for TOC Entry ID 23 (OID 801357) |
202 |
-- |
-- |
203 |
-- Name: countries Type: TABLE DATA Owner: dpavlin |
-- Name: countries Type: TABLE DATA Owner: dpavlin |
204 |
-- |
-- |
317 |
ZZ Other |
ZZ Other |
318 |
\. |
\. |
319 |
-- |
-- |
320 |
-- Data for TOC Entry ID 24 (OID 115349) |
-- Data for TOC Entry ID 24 (OID 801383) |
321 |
-- |
-- |
322 |
-- Name: emails Type: TABLE DATA Owner: dpavlin |
-- Name: emails Type: TABLE DATA Owner: dpavlin |
323 |
-- |
-- |
327 |
o_nas pliva-si-info@pliva.si |
o_nas pliva-si-info@pliva.si |
328 |
\. |
\. |
329 |
-- |
-- |
330 |
-- Data for TOC Entry ID 25 (OID 115394) |
-- Data for TOC Entry ID 25 (OID 801428) |
331 |
-- |
-- |
332 |
-- Name: zaposleni Type: TABLE DATA Owner: dpavlin |
-- Name: zaposleni Type: TABLE DATA Owner: dpavlin |
333 |
-- |
-- |
364 |
34 Splošne informacije \N \N \N info@pliva.si l t |
34 Splošne informacije \N \N \N info@pliva.si l t |
365 |
\. |
\. |
366 |
-- |
-- |
367 |
-- Data for TOC Entry ID 26 (OID 115447) |
-- Data for TOC Entry ID 26 (OID 801481) |
368 |
-- |
-- |
369 |
-- Name: multi Type: TABLE DATA Owner: dpavlin |
-- Name: multi Type: TABLE DATA Owner: dpavlin |
370 |
-- |
-- |
371 |
|
|
372 |
|
|
373 |
COPY "multi" FROM stdin; |
COPY "multi" FROM stdin; |
374 |
7 40 bla2 \N Profile-antiinfectives2.htm t \N h |
1 40 R&D 1 Profile-antiinfectives1.htm t /data/corp_html/html/RnD-Main.htm p |
375 |
1 40 proba multi stranice \N Profile-antiinfectives1.htm t /data/corp_html/html/RnD-Main.htm u |
7 40 Profile 2 Profile-antiinfectives2.htm t /data/corp_html/html/Profile-antiinfectives1.htm p |
376 |
|
9 40 Profile (cont...) 3 t /data/corp_html/html/Profile-antiinfectives2.htm p |
377 |
|
10 40 Technology : High Throughput Screening 10 t /data/corp_html/html/Technology-HighThroughput.htm p |
378 |
|
11 40 Technology : Microarrays 11 t /data/corp_html/html/Technology-Microarrays.htm p |
379 |
|
12 40 Mixis 15 t /data/corp_html/html/MIXIS-HomePR.htm p |
380 |
|
13 40 Mixis : Scientific Background 16 t /data/corp_html/html/MIXIS-Sci-TechPR.htm p |
381 |
|
14 40 Pipeline 20 t /data/corp_html/html/Pipeline.htm p |
382 |
|
18 40 Azithromycin : The Research 25 t /data/corp_html/html/Azithromycin1.htm p |
383 |
|
16 40 Azithromycin : The Partnership 26 t /data/corp_html/html/Azithromycin2.htm p |
384 |
|
17 40 Azithromycin : The Application 27 t /data/corp_html/html/Azithromycin3.htm p |
385 |
\. |
\. |
386 |
-- |
-- |
387 |
-- TOC Entry ID 14 (OID 115248) |
-- TOC Entry ID 14 (OID 801282) |
388 |
-- |
-- |
389 |
-- Name: "news_id_key" Type: INDEX Owner: dpavlin |
-- Name: "news_id_key" Type: INDEX Owner: dpavlin |
390 |
-- |
-- |
392 |
CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" ); |
CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" ); |
393 |
|
|
394 |
-- |
-- |
395 |
-- TOC Entry ID 15 (OID 115287) |
-- TOC Entry ID 15 (OID 801321) |
396 |
-- |
-- |
397 |
-- Name: "menu_num" Type: INDEX Owner: dpavlin |
-- Name: "menu_num" Type: INDEX Owner: dpavlin |
398 |
-- |
-- |
400 |
CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); |
CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); |
401 |
|
|
402 |
-- |
-- |
403 |
-- TOC Entry ID 16 (OID 115323) |
-- TOC Entry ID 16 (OID 801357) |
404 |
-- |
-- |
405 |
-- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin |
-- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin |
406 |
-- |
-- |
408 |
CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" ); |
CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" ); |
409 |
|
|
410 |
-- |
-- |
411 |
-- TOC Entry ID 17 (OID 115394) |
-- TOC Entry ID 17 (OID 801428) |
412 |
-- |
-- |
413 |
-- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin |
-- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin |
414 |
-- |
-- |
416 |
CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" ); |
CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" ); |
417 |
|
|
418 |
-- |
-- |
419 |
-- TOC Entry ID 18 (OID 115447) |
-- TOC Entry ID 18 (OID 801481) |
420 |
-- |
-- |
421 |
-- Name: "multi_id_key" Type: INDEX Owner: dpavlin |
-- Name: "multi_id_key" Type: INDEX Owner: dpavlin |
422 |
-- |
-- |
424 |
CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" ); |
CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" ); |
425 |
|
|
426 |
-- |
-- |
427 |
-- TOC Entry ID 3 (OID 115229) |
-- TOC Entry ID 3 (OID 801263) |
428 |
-- |
-- |
429 |
-- Name: news_id_seq Type: SEQUENCE SET Owner: |
-- Name: news_id_seq Type: SEQUENCE SET Owner: |
430 |
-- |
-- |
432 |
SELECT setval ('"news_id_seq"', 10, 't'); |
SELECT setval ('"news_id_seq"', 10, 't'); |
433 |
|
|
434 |
-- |
-- |
435 |
-- TOC Entry ID 5 (OID 115375) |
-- TOC Entry ID 5 (OID 801409) |
436 |
-- |
-- |
437 |
-- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: |
-- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: |
438 |
-- |
-- |
440 |
SELECT setval ('"zaposleni_id_seq"', 34, 't'); |
SELECT setval ('"zaposleni_id_seq"', 34, 't'); |
441 |
|
|
442 |
-- |
-- |
443 |
-- TOC Entry ID 7 (OID 115428) |
-- TOC Entry ID 7 (OID 801462) |
444 |
-- |
-- |
445 |
-- Name: multi_id_seq Type: SEQUENCE SET Owner: |
-- Name: multi_id_seq Type: SEQUENCE SET Owner: |
446 |
-- |
-- |
447 |
|
|
448 |
SELECT setval ('"multi_id_seq"', 8, 't'); |
SELECT setval ('"multi_id_seq"', 18, 't'); |
449 |
|
|