--- .data/sql/plivasi.sql 2001/06/29 22:43:27 1.1 +++ .data/sql/plivasi.sql 2001/07/02 21:13:21 1.2 @@ -3,7 +3,7 @@ -- \connect - postgres -- --- TOC Entry ID 8 (OID 18720) +-- TOC Entry ID 15 (OID 18720) -- -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres -- @@ -11,7 +11,7 @@ CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; -- --- TOC Entry ID 9 (OID 18721) +-- TOC Entry ID 16 (OID 18721) -- -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: -- @@ -28,7 +28,7 @@ CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 4 (OID 776766) +-- TOC Entry ID 6 (OID 776766) -- -- Name: news Type: TABLE Owner: dpavlin -- @@ -49,7 +49,7 @@ ); -- --- TOC Entry ID 5 (OID 776805) +-- TOC Entry ID 7 (OID 776805) -- -- Name: menu Type: TABLE Owner: dpavlin -- @@ -67,7 +67,55 @@ ); -- --- Data for TOC Entry ID 10 (OID 776766) +-- TOC Entry ID 8 (OID 783578) +-- +-- Name: countries Type: TABLE Owner: dpavlin +-- + +CREATE TABLE "countries" ( + "iso" character varying(2), + "name" text +); + +-- +-- TOC Entry ID 9 (OID 783717) +-- +-- Name: emails Type: TABLE Owner: dpavlin +-- + +CREATE TABLE "emails" ( + "referer" text, + "email" text +); + +-- +-- TOC Entry ID 4 (OID 783743) +-- +-- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin +-- + +CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; + +-- +-- TOC Entry ID 10 (OID 783762) +-- +-- Name: zaposleni Type: TABLE Owner: dpavlin +-- + +CREATE TABLE "zaposleni" ( + "id" integer DEFAULT nextval('"zaposleni_id_seq"'::text) NOT NULL, + "titula" text, + "ime" text, + "note" text, + "tel" text, + "email" text, + "pozicija" character(1), + "visible" boolean, + CONSTRAINT "zaposleni_pozicija" CHECK ((((pozicija = 'l'::bpchar) OR (pozicija = 'c'::bpchar)) OR (pozicija = 'r'::bpchar))) +); + +-- +-- Data for TOC Entry ID 17 (OID 776766) -- -- Name: news Type: TABLE DATA Owner: dpavlin -- @@ -93,7 +141,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 11 (OID 776805) +-- Data for TOC Entry ID 18 (OID 776805) -- -- Name: menu Type: TABLE DATA Owner: dpavlin -- @@ -125,7 +173,146 @@ o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13 \. -- --- TOC Entry ID 6 (OID 776766) +-- Data for TOC Entry ID 19 (OID 783578) +-- +-- Name: countries Type: TABLE DATA Owner: dpavlin +-- + + +COPY "countries" FROM stdin; +AG Antigua +AR Argentina +AU Australia +AT Austria +BS Bahamas +BH Bahrain +BD Bangladesh +BB Barbados +BY Belarus +BE Belgium +BM Bermuda +BO Bolivia +BA Bosnia +BR Brazil +IO Britain (UK) +BG Bulgaria +CA Canada +KY Cayman Islands +CL Chile +CN China +CO Colombia +HR Croatia +CU Cuba +CY Cyprus +CZ Czech Republic +DK Denmark +DO Dominican Republic +EC Ecuador +EG Egypt +SV El Salvador +EE Estonia +FI Finland +FR France +DE Germany +GI Gibraltar +GR Greece +GD Grenada +GY Guyana +HT Haiti +HN Honduras +HK Hong Kong +HU Hungary +IN India +ID Indonesia +IR Iran +IQ Iraq +IE Ireland +IL Israel +IT Italy +JM Jamaica +JP Japan +JO Jordan +KZ Kazakhstan +KE Kenya +KP Korea (South) +KW Kuwait +KG Kyrgyzstan +LV Latvia +LB Lebanon +LY Libya +LT Lithuania +MK Macedonia +MW Malawi +MY Malaysia +MT Malta +MX Mexico +MZ Mozambique +NL Netherlands +AN Netherlands Antilles +NZ New Zealand +NI Nicaragua +NG Nigeria +NO Norway +OM Oman +PK Pakistan +PA Panama +PY Paraguay +PE Peru +PH Philippines +PL Poland +PT Portugal +QA Qatar +RO Romania +RU Russian Federation +SA Saudi Arabia +SG Singapore +SK Slovak Republic +SI Slovenia +ZA South Africa +ES Spain +SD Sudan +SE Sweden +CH Switzerland +XX Switzerland (Basel) +SY Syria +TW Taiwan +TH Thailand +TT Trinidad and Tobago +TR Turkey +UA Ukraine +AE United Arab Emirates +US United States +UY Uruguay +VE Venezuela +VN Viet Nam +YE Yemen +YU Yugoslavia +ZM Zambia +ZW Zimbabwe +ZZ Other +\. +-- +-- Data for TOC Entry ID 20 (OID 783717) +-- +-- Name: emails Type: TABLE DATA Owner: dpavlin +-- + + +COPY "emails" FROM stdin; +\. +-- +-- Data for TOC Entry ID 21 (OID 783762) +-- +-- Name: zaposleni Type: TABLE DATA Owner: dpavlin +-- + + +COPY "zaposleni" FROM stdin; +1 \N Predstavni?tvo PLIVE d.d. v Ljubljani registrirano od 1.5. 2000. \N \N l t +3 Direktor mag. Ljiljana Zagorec, dipl. oec. \N 01 436 95 53 Fax: 01 436 86 36 ljiljana.zagorec@pliva.si c t +\. +-- +-- TOC Entry ID 11 (OID 776766) -- -- Name: "news_id_key" Type: INDEX Owner: dpavlin -- @@ -133,7 +320,7 @@ CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" ); -- --- TOC Entry ID 7 (OID 776805) +-- TOC Entry ID 12 (OID 776805) -- -- Name: "menu_num" Type: INDEX Owner: dpavlin -- @@ -141,6 +328,22 @@ CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); -- +-- TOC Entry ID 13 (OID 783578) +-- +-- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin +-- + +CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" ); + +-- +-- TOC Entry ID 14 (OID 783762) +-- +-- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin +-- + +CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" ); + +-- -- TOC Entry ID 3 (OID 776747) -- -- Name: news_id_seq Type: SEQUENCE SET Owner: @@ -148,3 +351,11 @@ SELECT setval ('"news_id_seq"', 10, 't'); +-- +-- TOC Entry ID 5 (OID 783743) +-- +-- Name: zaposleni_id_seq Type: SEQUENCE SET Owner: +-- + +SELECT setval ('"zaposleni_id_seq"', 3, 't'); +