--- .data/sql/plivasi.sql 2001/07/09 08:49:46 1.4 +++ .data/sql/plivasi.sql 2001/07/09 14:25:36 1.5 @@ -20,7 +20,7 @@ \connect - dpavlin -- --- TOC Entry ID 2 (OID 115229) +-- TOC Entry ID 2 (OID 801263) -- -- 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 115248) +-- TOC Entry ID 8 (OID 801282) -- -- Name: news Type: TABLE Owner: dpavlin -- @@ -49,7 +49,7 @@ ); -- --- TOC Entry ID 9 (OID 115287) +-- TOC Entry ID 9 (OID 801321) -- -- Name: menu Type: TABLE Owner: dpavlin -- @@ -67,7 +67,7 @@ ); -- --- TOC Entry ID 10 (OID 115323) +-- TOC Entry ID 10 (OID 801357) -- -- Name: countries Type: TABLE Owner: dpavlin -- @@ -78,7 +78,7 @@ ); -- --- TOC Entry ID 11 (OID 115349) +-- TOC Entry ID 11 (OID 801383) -- -- Name: emails Type: TABLE Owner: dpavlin -- @@ -89,7 +89,7 @@ ); -- --- TOC Entry ID 4 (OID 115375) +-- TOC Entry ID 4 (OID 801409) -- -- 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 115394) +-- TOC Entry ID 12 (OID 801428) -- -- Name: zaposleni Type: TABLE Owner: dpavlin -- @@ -115,7 +115,7 @@ ); -- --- TOC Entry ID 6 (OID 115428) +-- TOC Entry ID 6 (OID 801462) -- -- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin -- @@ -123,7 +123,7 @@ CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 13 (OID 115447) +-- TOC Entry ID 13 (OID 801481) -- -- Name: multi Type: TABLE Owner: dpavlin -- @@ -140,7 +140,7 @@ ); -- --- Data for TOC Entry ID 21 (OID 115248) +-- Data for TOC Entry ID 21 (OID 801282) -- -- Name: news Type: TABLE DATA Owner: dpavlin -- @@ -166,7 +166,7 @@ 10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0 \. -- --- Data for TOC Entry ID 22 (OID 115287) +-- Data for TOC Entry ID 22 (OID 801321) -- -- Name: menu Type: TABLE DATA Owner: dpavlin -- @@ -190,15 +190,15 @@ 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 \. -- --- Data for TOC Entry ID 23 (OID 115323) +-- Data for TOC Entry ID 23 (OID 801357) -- -- Name: countries Type: TABLE DATA Owner: dpavlin -- @@ -317,7 +317,7 @@ ZZ Other \. -- --- Data for TOC Entry ID 24 (OID 115349) +-- Data for TOC Entry ID 24 (OID 801383) -- -- Name: emails Type: TABLE DATA Owner: dpavlin -- @@ -327,7 +327,7 @@ o_nas pliva-si-info@pliva.si \. -- --- Data for TOC Entry ID 25 (OID 115394) +-- Data for TOC Entry ID 25 (OID 801428) -- -- Name: zaposleni Type: TABLE DATA Owner: dpavlin -- @@ -364,18 +364,27 @@ 34 Splošne informacije \N \N \N info@pliva.si l t \. -- --- Data for TOC Entry ID 26 (OID 115447) +-- Data for TOC Entry ID 26 (OID 801481) -- -- Name: multi Type: TABLE DATA Owner: dpavlin -- COPY "multi" FROM stdin; -7 40 bla2 \N Profile-antiinfectives2.htm t \N h -1 40 proba multi stranice \N Profile-antiinfectives1.htm t /data/corp_html/html/RnD-Main.htm u +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 \. -- --- TOC Entry ID 14 (OID 115248) +-- TOC Entry ID 14 (OID 801282) -- -- Name: "news_id_key" Type: INDEX Owner: dpavlin -- @@ -383,7 +392,7 @@ CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 15 (OID 115287) +-- TOC Entry ID 15 (OID 801321) -- -- Name: "menu_num" Type: INDEX Owner: dpavlin -- @@ -391,7 +400,7 @@ CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); -- --- TOC Entry ID 16 (OID 115323) +-- TOC Entry ID 16 (OID 801357) -- -- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin -- @@ -399,7 +408,7 @@ CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" ); -- --- TOC Entry ID 17 (OID 115394) +-- TOC Entry ID 17 (OID 801428) -- -- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin -- @@ -407,7 +416,7 @@ CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 18 (OID 115447) +-- TOC Entry ID 18 (OID 801481) -- -- Name: "multi_id_key" Type: INDEX Owner: dpavlin -- @@ -415,7 +424,7 @@ CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 3 (OID 115229) +-- TOC Entry ID 3 (OID 801263) -- -- Name: news_id_seq Type: SEQUENCE SET Owner: -- @@ -423,7 +432,7 @@ SELECT setval ('"news_id_seq"', 10, 't'); -- --- TOC Entry ID 5 (OID 115375) +-- TOC Entry ID 5 (OID 801409) -- -- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: -- @@ -431,10 +440,10 @@ SELECT setval ('"zaposleni_id_seq"', 34, 't'); -- --- TOC Entry ID 7 (OID 115428) +-- TOC Entry ID 7 (OID 801462) -- -- Name: multi_id_seq Type: SEQUENCE SET Owner: -- -SELECT setval ('"multi_id_seq"', 8, 't'); +SELECT setval ('"multi_id_seq"', 18, 't');