--- .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');
+
