--- shema.sql	2001/06/12 07:38:52	1.1
+++ shema.sql	2001/06/12 10:11:24	1.2
@@ -1,5 +1,4 @@
 
-DROP TABLE vodeca;
 DROP TABLE lijekovi;
 DROP TABLE nacin_izdavanja;
 DROP TABLE list_fond;
@@ -12,11 +11,6 @@
 DROP TABLE proizvodjaci;
 
 
-CREATE TABLE vodeca (
-	sifra CHAR VARYING(20) NOT NULL PRIMARY KEY,
-	naziv TEXT
-);
-
 CREATE TABLE lijekovi (
 	sifra INTEGER NOT NULL PRIMARY KEY,
 	naziv CHAR VARYING(100) NOT NULL,
@@ -26,12 +20,12 @@
 	pakovanje TEXT NOT NULL,
 	sastav_1 TEXT NOT NULL,
 	sastav_2 TEXT NOT NULL,
-	sif_nacin_izdavanja INTEGER,
-	sif_list_fond INTEGER,
-	sif_trudnoca INTEGER,
-	sif_dojencad INTEGER,
-	sif_vozac INTEGER,
-	sif_droga INTEGER,
+	sif_nacin_izdavanja CHAR VARYING(5),
+	sif_list_fond CHAR VARYING(5),
+	sif_trudnoca CHAR VARYING(5),
+	sif_dojencad CHAR VARYING(5),
+	sif_vozac CHAR VARYING(5),
+	sif_droga CHAR VARYING(5),
 	cijena CHAR VARYING(16) NOT NULL,
 	sif_med INTEGER NOT NULL,
 	razno TEXT,
@@ -42,32 +36,32 @@
 );
 
 CREATE TABLE nacin_izdavanja (
-	sifra INTEGER NOT NULL,
+	sifra CHAR VARYING(5) NOT NULL,
 	opis TEXT
 );
 
 CREATE TABLE list_fond (
-	sifra INTEGER NOT NULL,
+	sifra CHAR VARYING(5) NOT NULL,
 	opis TEXT
 );
 
 CREATE TABLE trudnoca (
-	sifra INTEGER NOT NULL,
+	sifra CHAR VARYING(5) NOT NULL,
 	opis TEXT
 );
 
 CREATE TABLE dojencad (
-	sifra INTEGER NOT NULL,
+	sifra CHAR VARYING(5) NOT NULL,
 	opis TEXT
 );
 
 CREATE TABLE vozac (
-	sifra INTEGER NOT NULL,
+	sifra CHAR VARYING(5) NOT NULL,
 	opis TEXT
 );
 
 CREATE TABLE droga (
-	sifra INTEGER NOT NULL,
+	sifra CHAR VARYING(5) NOT NULL,
 	opis TEXT
 );
 
@@ -97,7 +91,7 @@
 	zip CHAR VARYING(10) NOT NULL,
 	ulica_i_broj CHAR VARYING(50) NOT NULL,
 	razno TEXT,
-	telefon CHAR VARYING(15),
-	fax CHAR VARYING(15)
+	telefon CHAR VARYING(20),
+	fax CHAR VARYING(20)
 );