3 |
-- |
-- |
4 |
\connect - postgres |
\connect - postgres |
5 |
-- |
-- |
6 |
-- TOC Entry ID 15 (OID 18720) |
-- TOC Entry ID 19 (OID 18720) |
7 |
-- |
-- |
8 |
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres |
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres |
9 |
-- |
-- |
11 |
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'; |
12 |
|
|
13 |
-- |
-- |
14 |
-- TOC Entry ID 16 (OID 18721) |
-- TOC Entry ID 20 (OID 18721) |
15 |
-- |
-- |
16 |
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: |
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: |
17 |
-- |
-- |
20 |
|
|
21 |
\connect - dpavlin |
\connect - dpavlin |
22 |
-- |
-- |
23 |
-- TOC Entry ID 2 (OID 776747) |
-- TOC Entry ID 2 (OID 784158) |
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 6 (OID 776766) |
-- TOC Entry ID 8 (OID 784177) |
32 |
-- |
-- |
33 |
-- Name: news Type: TABLE Owner: dpavlin |
-- Name: news Type: TABLE Owner: dpavlin |
34 |
-- |
-- |
49 |
); |
); |
50 |
|
|
51 |
-- |
-- |
52 |
-- TOC Entry ID 7 (OID 776805) |
-- TOC Entry ID 9 (OID 784216) |
53 |
-- |
-- |
54 |
-- Name: menu Type: TABLE Owner: dpavlin |
-- Name: menu Type: TABLE Owner: dpavlin |
55 |
-- |
-- |
67 |
); |
); |
68 |
|
|
69 |
-- |
-- |
70 |
-- TOC Entry ID 8 (OID 783578) |
-- TOC Entry ID 10 (OID 784252) |
71 |
-- |
-- |
72 |
-- Name: countries Type: TABLE Owner: dpavlin |
-- Name: countries Type: TABLE Owner: dpavlin |
73 |
-- |
-- |
78 |
); |
); |
79 |
|
|
80 |
-- |
-- |
81 |
-- TOC Entry ID 9 (OID 783717) |
-- TOC Entry ID 11 (OID 784278) |
82 |
-- |
-- |
83 |
-- Name: emails Type: TABLE Owner: dpavlin |
-- Name: emails Type: TABLE Owner: dpavlin |
84 |
-- |
-- |
89 |
); |
); |
90 |
|
|
91 |
-- |
-- |
92 |
-- TOC Entry ID 4 (OID 783743) |
-- TOC Entry ID 4 (OID 784304) |
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 10 (OID 783762) |
-- TOC Entry ID 12 (OID 784323) |
101 |
-- |
-- |
102 |
-- Name: zaposleni Type: TABLE Owner: dpavlin |
-- Name: zaposleni Type: TABLE Owner: dpavlin |
103 |
-- |
-- |
115 |
); |
); |
116 |
|
|
117 |
-- |
-- |
118 |
-- Data for TOC Entry ID 17 (OID 776766) |
-- TOC Entry ID 6 (OID 786793) |
119 |
|
-- |
120 |
|
-- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin |
121 |
|
-- |
122 |
|
|
123 |
|
CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
124 |
|
|
125 |
|
-- |
126 |
|
-- TOC Entry ID 13 (OID 786812) |
127 |
|
-- |
128 |
|
-- Name: multi Type: TABLE Owner: dpavlin |
129 |
|
-- |
130 |
|
|
131 |
|
CREATE TABLE "multi" ( |
132 |
|
"id" integer DEFAULT nextval('"multi_id_seq"'::text) NOT NULL, |
133 |
|
"menu_num" int4 NOT NULL, |
134 |
|
"name" text, |
135 |
|
"num" integer, |
136 |
|
"html" text NOT NULL, |
137 |
|
"visible" boolean DEFAULT 't'::bool |
138 |
|
); |
139 |
|
|
140 |
|
-- |
141 |
|
-- Data for TOC Entry ID 21 (OID 784177) |
142 |
-- |
-- |
143 |
-- Name: news Type: TABLE DATA Owner: dpavlin |
-- Name: news Type: TABLE DATA Owner: dpavlin |
144 |
-- |
-- |
164 |
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 |
165 |
\. |
\. |
166 |
-- |
-- |
167 |
-- Data for TOC Entry ID 18 (OID 776805) |
-- Data for TOC Entry ID 22 (OID 784216) |
168 |
-- |
-- |
169 |
-- Name: menu Type: TABLE DATA Owner: dpavlin |
-- Name: menu Type: TABLE DATA Owner: dpavlin |
170 |
-- |
-- |
196 |
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 |
197 |
\. |
\. |
198 |
-- |
-- |
199 |
-- Data for TOC Entry ID 19 (OID 783578) |
-- Data for TOC Entry ID 23 (OID 784252) |
200 |
-- |
-- |
201 |
-- Name: countries Type: TABLE DATA Owner: dpavlin |
-- Name: countries Type: TABLE DATA Owner: dpavlin |
202 |
-- |
-- |
315 |
ZZ Other |
ZZ Other |
316 |
\. |
\. |
317 |
-- |
-- |
318 |
-- Data for TOC Entry ID 20 (OID 783717) |
-- Data for TOC Entry ID 24 (OID 784278) |
319 |
-- |
-- |
320 |
-- Name: emails Type: TABLE DATA Owner: dpavlin |
-- Name: emails Type: TABLE DATA Owner: dpavlin |
321 |
-- |
-- |
322 |
|
|
323 |
|
|
324 |
COPY "emails" FROM stdin; |
COPY "emails" FROM stdin; |
325 |
|
o_nas pliva-si-info@pliva.si |
326 |
\. |
\. |
327 |
-- |
-- |
328 |
-- Data for TOC Entry ID 21 (OID 783762) |
-- Data for TOC Entry ID 25 (OID 784323) |
329 |
-- |
-- |
330 |
-- Name: zaposleni Type: TABLE DATA Owner: dpavlin |
-- Name: zaposleni Type: TABLE DATA Owner: dpavlin |
331 |
-- |
-- |
332 |
|
|
333 |
|
|
334 |
COPY "zaposleni" FROM stdin; |
COPY "zaposleni" FROM stdin; |
335 |
1 \N Predstavni?tvo PLIVE d.d. v Ljubljani registrirano od 1.5. 2000. \N \N l t |
8 \N PLIVA Ljubljana d.o.o registrirano podjetje od 1.8. 1992 \N \N r t |
336 |
3 Direktor mag. Ljiljana Zagorec, dipl. oec. \N 01 436 95 53 Fax: 01 436 86 36 ljiljana.zagorec@pliva.si c t |
9 Direktor mag. Ljiljana Zagorec, dipl. oec. \N 01 436 95 53 Fax: 01 436 86 36 ljiljana.zagorec@pliva.si c t |
337 |
|
11 Finance Milan Vujinovič, dipl. oec. \N 01 436 95 76 milan.vujinovic@pliva.si r t |
338 |
|
12 Višja medicinska svetovalka Barbara Marolt Žužek, dr. med. \N 01 436 86 18 barbara.marolt@pliva.si l t |
339 |
|
10 Vodja marketinga in prodaje farmacevtike Urška Oblak, mag. farm. \N 01 436 86 18 urska.oblak@pliva.si l t |
340 |
|
1 \N Predstavništvo PLIVE d.d. v Ljubljani registrirano od 1.5. 2000. \N \N l t |
341 |
|
13 Vodja registracijskega in medicinskega oddelka Nataša Andročec-Robič, mag. farm. \N 01 436 86 18 natasa.androcec@pliva.si r t |
342 |
|
14 Poslovna korespondentka Tanja Slobodnjak \N 01 436 86 18 tanja.slobodnjak@pliva.si l t |
343 |
|
15 Medicinska svetovalka Radmila Lučič, dr. med. \N 01 436 86 18 radmila.lucic@pliva.si r t |
344 |
|
16 Strokovna sodelavka za registracije Manca Šef-Križanič, mag. farm. \N 01 436 86 18 manca.sef-krizanic@pliva.si l t |
345 |
|
17 Proizvodi za zaščito rastlin Darinka Bauman, dipl. ing. agrn \N \N darinka.bauman@pliva.si r t |
346 |
|
18 Psihofarmaki Irena Mastnak, mag. farm. \N 01 436 86 18 irena.mastnak@pliva.si l t |
347 |
|
20 Intim plus, dezinficijensi in diagnostika Andreja Kavšek, dipl. biol. \N 01 436 86 18 andreja.kavsek@pliva.si l t |
348 |
|
21 Zdravila, ki so na voljo brez recepta Tatjana Hribar, dipl. ing. živil. teh. \N 01 436 92 22 tatjana.hribar@pliva.si l t |
349 |
|
22 Področje antibiotikov Zdenka Ferenčak, dipl. univ. biol. \N 01 436 86 18 zdenka.ferencak@pliva.si l t |
350 |
|
23 Zdravila za uporabo v kardiologiji Erika Košir, mag. farm. \N 01 436 86 18 erika.kosir@pliva.si l t |
351 |
|
24 Višja strokovna sodelavka Danica Berce, mag. farm. \N 01 436 86 18 danica.berce@pliva.si l t |
352 |
|
25 Višja strokovna sodelavka Majda Marc, mag. farm. \N 01 436 86 18 majda.marc@pliva.si l t |
353 |
|
19 Zdravila za zdravljenje diabetesa Rosana Potokar, mag. farm. \N 01 436 86 18 rosana.potokar@pliva.si l t |
354 |
|
26 Poslovni sekretar Jelka Primožič \N 01 436 95 69 jelka.primozic@pliva.si l t |
355 |
|
27 Strokovna sodelavka Kristina Pahljina, dipl. ing. bioteh. \N 01 436 86 18 kristina.pahljina@pliva.si l t |
356 |
|
28 Strokovna sodelavka Maja Kovačič, uni. dipl. mikrobiolog \N 01 436 86 18 maja.kovacic@pliva.si l t |
357 |
|
29 Strokovna sodelavka Brigita Tepuš, dipl. ing. \N 01 436 86 18 brigita.tepus@pliva.si l t |
358 |
|
30 Strokovna sodelavka Andreja Podlogar, mag. farm. \N 01 436 86 18 andreja.podlogar@pliva.si l t |
359 |
|
31 Strokovni sodelavec Robert Pevec, mag. farm. \N 01 436 86 13 robert.pevec@pliva.si l t |
360 |
|
32 Veterinarski izdelki Darja Brišnik, dr. vet. med. \N 01 436 92 22 darja.brisnik@pliva.si l t |
361 |
|
33 \N Sandra Giovani, dr. vet. med. \N 01 436 92 22 sandra.giovani@pliva.si l t |
362 |
|
34 Splošne informacije \N \N \N info@pliva.si l t |
363 |
\. |
\. |
364 |
-- |
-- |
365 |
-- TOC Entry ID 11 (OID 776766) |
-- Data for TOC Entry ID 26 (OID 786812) |
366 |
|
-- |
367 |
|
-- Name: multi Type: TABLE DATA Owner: dpavlin |
368 |
|
-- |
369 |
|
|
370 |
|
|
371 |
|
COPY "multi" FROM stdin; |
372 |
|
1 40 proba multi stranice \N Profile-antiinfectives1.htm t |
373 |
|
7 40 bla2 \N Profile-antiinfectives2.htm t |
374 |
|
\. |
375 |
|
-- |
376 |
|
-- TOC Entry ID 14 (OID 784177) |
377 |
-- |
-- |
378 |
-- Name: "news_id_key" Type: INDEX Owner: dpavlin |
-- Name: "news_id_key" Type: INDEX Owner: dpavlin |
379 |
-- |
-- |
381 |
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" ); |
382 |
|
|
383 |
-- |
-- |
384 |
-- TOC Entry ID 12 (OID 776805) |
-- TOC Entry ID 15 (OID 784216) |
385 |
-- |
-- |
386 |
-- Name: "menu_num" Type: INDEX Owner: dpavlin |
-- Name: "menu_num" Type: INDEX Owner: dpavlin |
387 |
-- |
-- |
389 |
CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); |
CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); |
390 |
|
|
391 |
-- |
-- |
392 |
-- TOC Entry ID 13 (OID 783578) |
-- TOC Entry ID 16 (OID 784252) |
393 |
-- |
-- |
394 |
-- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin |
-- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin |
395 |
-- |
-- |
397 |
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" ); |
398 |
|
|
399 |
-- |
-- |
400 |
-- TOC Entry ID 14 (OID 783762) |
-- TOC Entry ID 17 (OID 784323) |
401 |
-- |
-- |
402 |
-- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin |
-- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin |
403 |
-- |
-- |
405 |
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" ); |
406 |
|
|
407 |
-- |
-- |
408 |
-- TOC Entry ID 3 (OID 776747) |
-- TOC Entry ID 18 (OID 786812) |
409 |
|
-- |
410 |
|
-- Name: "multi_id_key" Type: INDEX Owner: dpavlin |
411 |
|
-- |
412 |
|
|
413 |
|
CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" ); |
414 |
|
|
415 |
|
-- |
416 |
|
-- TOC Entry ID 3 (OID 784158) |
417 |
-- |
-- |
418 |
-- Name: news_id_seq Type: SEQUENCE SET Owner: |
-- Name: news_id_seq Type: SEQUENCE SET Owner: |
419 |
-- |
-- |
421 |
SELECT setval ('"news_id_seq"', 10, 't'); |
SELECT setval ('"news_id_seq"', 10, 't'); |
422 |
|
|
423 |
-- |
-- |
424 |
-- TOC Entry ID 5 (OID 783743) |
-- TOC Entry ID 5 (OID 784304) |
425 |
-- |
-- |
426 |
-- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: |
-- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: |
427 |
-- |
-- |
428 |
|
|
429 |
SELECT setval ('"zaposleni_id_seq"', 3, 't'); |
SELECT setval ('"zaposleni_id_seq"', 34, 't'); |
430 |
|
|
431 |
|
-- |
432 |
|
-- TOC Entry ID 7 (OID 786793) |
433 |
|
-- |
434 |
|
-- Name: multi_id_seq Type: SEQUENCE SET Owner: |
435 |
|
-- |
436 |
|
|
437 |
|
SELECT setval ('"multi_id_seq"', 8, 't'); |
438 |
|
|