--- .data/sql/plivasi.sql 2001/07/03 12:41:05 1.3 +++ .data/sql/plivasi.sql 2001/07/22 18:04:34 1.6 @@ -20,7 +20,7 @@ \connect - dpavlin -- --- TOC Entry ID 2 (OID 784158) +-- TOC Entry ID 2 (OID 108747) -- -- Name: news_id_seq Type: SEQUENCE Owner: dpavlin -- @@ -28,7 +28,7 @@ CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 8 (OID 784177) +-- TOC Entry ID 8 (OID 108766) -- -- Name: news Type: TABLE Owner: dpavlin -- @@ -49,7 +49,7 @@ ); -- --- TOC Entry ID 9 (OID 784216) +-- TOC Entry ID 9 (OID 108805) -- -- Name: menu Type: TABLE Owner: dpavlin -- @@ -67,7 +67,7 @@ ); -- --- TOC Entry ID 10 (OID 784252) +-- TOC Entry ID 10 (OID 108841) -- -- Name: countries Type: TABLE Owner: dpavlin -- @@ -78,7 +78,7 @@ ); -- --- TOC Entry ID 11 (OID 784278) +-- TOC Entry ID 11 (OID 108867) -- -- Name: emails Type: TABLE Owner: dpavlin -- @@ -89,7 +89,7 @@ ); -- --- TOC Entry ID 4 (OID 784304) +-- TOC Entry ID 4 (OID 108893) -- -- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin -- @@ -97,7 +97,7 @@ CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 12 (OID 784323) +-- TOC Entry ID 12 (OID 108912) -- -- Name: zaposleni Type: TABLE Owner: dpavlin -- @@ -115,7 +115,7 @@ ); -- --- TOC Entry ID 6 (OID 786793) +-- TOC Entry ID 6 (OID 108946) -- -- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin -- @@ -123,22 +123,24 @@ CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 13 (OID 786812) +-- TOC Entry ID 13 (OID 108965) -- -- Name: multi Type: TABLE Owner: dpavlin -- CREATE TABLE "multi" ( "id" integer DEFAULT nextval('"multi_id_seq"'::text) NOT NULL, - "menu_num" int4 NOT NULL, + "menu_num" integer NOT NULL, "name" text, "num" integer, "html" text NOT NULL, - "visible" boolean DEFAULT 't'::bool + "visible" boolean DEFAULT 't', + "path" text, + "type" character varying(1) ); -- --- Data for TOC Entry ID 21 (OID 784177) +-- Data for TOC Entry ID 21 (OID 108766) -- -- Name: news Type: TABLE DATA Owner: dpavlin -- @@ -146,25 +148,25 @@ COPY "news" FROM stdin; 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. \ -

misc: Nasveti

2001-06-28 mn_ \N t 0 +

misc: Nasveti

28.06.2001 mn_ \N t 0 3 Tarzan, kommt hier! Kuala Lumpur, 1938 Tarzan! Tarzan! \ -

misc: Smernice O-m

2001-06-29 msx \N t 0 +

misc: Smernice O-m

29.06.2001 msx \N t 0 2 Vrag Vas odnio Vrag Vas odnio Heto radim tu nesto, nesto. Testiranje i tako to. \ -

evnt: Pliva.si dogotki

TestSI.htm 2001-06-29 ep_ \N t 0 +

evnt: Pliva.si dogotki

TestSI.htm 29.06.2001 ep_ \N t 0 5 Gotovo je Ljubljana, 25 Juni 2001. Gotovo je - nema više. \ -

news: Strokovne novice O-m

2001-06-25 ndx \N t 0 +

news: Strokovne novice O-m

25.06.2001 ndx \N t 0 1 Početak izrade pliva.si dinamičkog web-a 28.6.2001. join us and share the joy! \ -

news: Novice

PR_loan_extension-25_06_01a.pdf 2001-06-28 nn_ \N t 0 +

news: Novice

PR_loan_extension-25_06_01a.pdf 28.06.2001 nn_ \N t 0 6 A-ha! Ljubljana, 29 Juni 2001. A-ha! koncert u Ljubljani. Za sve ljubitelje švedskih "slavuja". \ -

evnt: Dogotki O-m

Test-2.htm 2001-06-29 epx \N t 5 -9 KusKus Ljubljana, 29 Juni 2001. misc: Medicus O-m Medikus01_2001.pdf 2001-06-29 mcx \N t 0 +

evnt: Dogotki O-m

Test-2.htm 29.06.2001 epx \N t 5 +9 KusKus Ljubljana, 29 Juni 2001. misc: Medicus O-m Medikus01_2001.pdf 29.06.2001 mcx \N t 0 7 Bikerski koncert za zdravnike Kuala Lumpur, 1938 Wrooom!!!! \ -

misc: Kongresi O-m

Test-3slika.htm 2001-06-21 mkx snjesko.gif \N t 0 -8 Pharma Info Zagreb, 20 June 2001. misc: Pharma info O-m 2001-06-20 mpx \N t 0 -10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0 +

misc: Kongresi O-m

Test-3slika.htm 21.06.2001 mkx snjesko.gif \N t 0 +8 Pharma Info Zagreb, 20 June 2001. misc: Pharma info O-m 20.06.2001 mpx \N t 0 +10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 27.06.2001 mix \N t 0 \. -- --- Data for TOC Entry ID 22 (OID 784216) +-- Data for TOC Entry ID 22 (OID 108805) -- -- Name: menu Type: TABLE DATA Owner: dpavlin -- @@ -172,13 +174,8 @@ COPY "menu" FROM stdin; sladkorna 1 Mali leksikon \N mali_leksikon.gif 200 t 125 13 -o_nas 3 V svetu \N v_svetu.gif 45 t 125 13 +o_nas 1 Zaposleni o_nas.php?p=zaposleni zaposleni.gif 10 t 125 13 o_nas 3 Sporočila za javnost \N sporo_ila_za_javnost.gif 35 t 125 13 -o_nas 3 Raziskovne in\\nrazvoj \N raziskovne_in_nrazvoj.gif 40 t 125 26 -o_nas 1 Zaposleni o_nas.php?h=zaposleni zaposleni.gif 10 t 125 13 -izdelki 1 Zdravila brez recepta \N zdravila_brez_recepta.gif 50 t 125 13 -izdelki 1 Raskužila \N rasku_ila.gif 55 t 125 13 -izdelki 1 Diagnostika \N diagnostika.gif 60 t 125 13 izdelki 1 Veterina \N veterina.gif 65 t 125 13 nasveti 1 Izobraževalni kotiček \N izobra_evalni_koti_ek.gif 70 t 125 13 nasveti 1 Mali leksikon \N mali_leksikon.gif 75 t 125 13 @@ -188,15 +185,20 @@ sladkorna 2 Učna Ura \N u_na_ura.gif 205 t 125 13 za_zdravnike 2 Publikacije \N publikacije.gif 90 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 o_nas 3 PLIVA Magazin \N pliva_magazin.gif 30 t 125 13 za_zdravnike 3 Medicus za_zdravnike.php?p=publikacije&type=mcx medicus.gif 100 t 125 13 za_zdravnike 3 Pharma Info za_zdravnike.php?p=publikacije&type=mpx pharma_info.gif 95 t 125 13 za_zdravnike 3 Medinfo za_zdravnike.php?p=publikacije&type=mix medinfo.gif 105 t 125 13 o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13 +o_nas 3 Letno Poročilo o_nas.php?p=annual letno_poro_ilo.gif 25 t 125 13 +o_nas 3 Raziskovne in\\nrazvoj multi.php?p=1 raziskovne_in_nrazvoj.gif 40 t 125 26 +o_nas 3 V svetu o_nas.php?p=worldwide v_svetu.gif 45 t 125 13 +izdelki 1 Diagnostika multi.php?p=19 diagnostika.gif 60 t 125 13 +izdelki 1 Raskužila izdelki.php?static=Raskuzila rasku_ila.gif 55 t 125 13 +izdelki 1 Zdravila brez recepta multi.php?p=23 zdravila_brez_recepta.gif 50 t 125 13 \. -- --- Data for TOC Entry ID 23 (OID 784252) +-- Data for TOC Entry ID 23 (OID 108841) -- -- Name: countries Type: TABLE DATA Owner: dpavlin -- @@ -315,7 +317,7 @@ ZZ Other \. -- --- Data for TOC Entry ID 24 (OID 784278) +-- Data for TOC Entry ID 24 (OID 108867) -- -- Name: emails Type: TABLE DATA Owner: dpavlin -- @@ -325,7 +327,7 @@ o_nas pliva-si-info@pliva.si \. -- --- Data for TOC Entry ID 25 (OID 784323) +-- Data for TOC Entry ID 25 (OID 108912) -- -- Name: zaposleni Type: TABLE DATA Owner: dpavlin -- @@ -337,7 +339,6 @@ 11 Finance Milan Vujinovič, dipl. oec. \N 01 436 95 76 milan.vujinovic@pliva.si r t 12 Višja medicinska svetovalka Barbara Marolt Žužek, dr. med. \N 01 436 86 18 barbara.marolt@pliva.si l t 10 Vodja marketinga in prodaje farmacevtike Urška Oblak, mag. farm. \N 01 436 86 18 urska.oblak@pliva.si l t -1 \N Predstavništvo PLIVE d.d. v Ljubljani registrirano od 1.5. 2000. \N \N l t 13 Vodja registracijskega in medicinskega oddelka Nataša Andročec-Robič, mag. farm. \N 01 436 86 18 natasa.androcec@pliva.si r t 14 Poslovna korespondentka Tanja Slobodnjak \N 01 436 86 18 tanja.slobodnjak@pliva.si l t 15 Medicinska svetovalka Radmila Lučič, dr. med. \N 01 436 86 18 radmila.lucic@pliva.si r t @@ -360,20 +361,38 @@ 32 Veterinarski izdelki Darja Brišnik, dr. vet. med. \N 01 436 92 22 darja.brisnik@pliva.si l t 33 \N Sandra Giovani, dr. vet. med. \N 01 436 92 22 sandra.giovani@pliva.si l t 34 Splošne informacije \N \N \N info@pliva.si l t +1 \N Predstavništvo PLIVE d.d. v Ljubljani registrirano od 1.5. 2000. \N \N l t \. -- --- Data for TOC Entry ID 26 (OID 786812) +-- Data for TOC Entry ID 26 (OID 108965) -- -- Name: multi Type: TABLE DATA Owner: dpavlin -- COPY "multi" FROM stdin; -1 40 proba multi stranice \N Profile-antiinfectives1.htm t -7 40 bla2 \N Profile-antiinfectives2.htm t +1 40 R&D 1 Profile-antiinfectives1.htm t /data/corp_html/html/RnD-Main.htm p +7 40 Profile 2 Profile-antiinfectives2.htm t /data/corp_html/html/Profile-antiinfectives1.htm p +9 40 Profile (cont...) 3 t /data/corp_html/html/Profile-antiinfectives2.htm p +10 40 Technology : High Throughput Screening 10 t /data/corp_html/html/Technology-HighThroughput.htm p +11 40 Technology : Microarrays 11 t /data/corp_html/html/Technology-Microarrays.htm p +12 40 Mixis 15 t /data/corp_html/html/MIXIS-HomePR.htm p +13 40 Mixis : Scientific Background 16 t /data/corp_html/html/MIXIS-Sci-TechPR.htm p +14 40 Pipeline 20 t /data/corp_html/html/Pipeline.htm p +18 40 Azithromycin : The Research 25 t /data/corp_html/html/Azithromycin1.htm p +16 40 Azithromycin : The Partnership 26 t /data/corp_html/html/Azithromycin2.htm p +17 40 Azithromycin : The Application 27 t /data/corp_html/html/Azithromycin3.htm p +19 60 Intim Plus 1 t /data/pliva-si/static/Diagnostika/Intim_Plus-1.htm p +20 60 Uporaba 2 t /data/pliva-si/static/Diagnostika/Uporaba-2.htm p +21 60 Potek testiranja 3 t /data/pliva-si/static/Diagnostika/Potek_Testiranja-3.htm p +22 60 Razlaga izvida 4 t /data/pliva-si/static/Diagnostika/Razlaga_Izvida-4.htm p +23 50 Andol 1 t static/Zdravila_brez_recepta/Andol.htm p +24 50 Gastal 2 t /data/pliva-si/static/Zdravila_brez_recepta/Gastal.htm p +25 50 Plivit C 3 t /data/pliva-si/static/Zdravila_brez_recepta/Plivit_C.htm p +26 50 Voltaren 4 t /data/pliva-si/static/Zdravila_brez_recepta/Voltaren.htm p \. -- --- TOC Entry ID 14 (OID 784177) +-- TOC Entry ID 14 (OID 108766) -- -- Name: "news_id_key" Type: INDEX Owner: dpavlin -- @@ -381,7 +400,7 @@ CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 15 (OID 784216) +-- TOC Entry ID 15 (OID 108805) -- -- Name: "menu_num" Type: INDEX Owner: dpavlin -- @@ -389,7 +408,7 @@ CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); -- --- TOC Entry ID 16 (OID 784252) +-- TOC Entry ID 16 (OID 108841) -- -- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin -- @@ -397,7 +416,7 @@ CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" ); -- --- TOC Entry ID 17 (OID 784323) +-- TOC Entry ID 17 (OID 108912) -- -- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin -- @@ -405,7 +424,7 @@ CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 18 (OID 786812) +-- TOC Entry ID 18 (OID 108965) -- -- Name: "multi_id_key" Type: INDEX Owner: dpavlin -- @@ -413,7 +432,7 @@ CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 3 (OID 784158) +-- TOC Entry ID 3 (OID 108747) -- -- Name: news_id_seq Type: SEQUENCE SET Owner: -- @@ -421,7 +440,7 @@ SELECT setval ('"news_id_seq"', 10, 't'); -- --- TOC Entry ID 5 (OID 784304) +-- TOC Entry ID 5 (OID 108893) -- -- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: -- @@ -429,10 +448,10 @@ SELECT setval ('"zaposleni_id_seq"', 34, 't'); -- --- TOC Entry ID 7 (OID 786793) +-- TOC Entry ID 7 (OID 108946) -- -- Name: multi_id_seq Type: SEQUENCE SET Owner: -- -SELECT setval ('"multi_id_seq"', 8, 't'); +SELECT setval ('"multi_id_seq"', 26, 't');