--- shema.sql 2001/06/19 09:27:25 1.3 +++ shema.sql 2001/06/19 10:10:48 1.4 @@ -6,7 +6,8 @@ DROP TABLE dojencad; DROP TABLE vozac; DROP TABLE droga; -DROP TABLE atk_inn; +DROP TABLE atk; +DROP TABLE inn; DROP TABLE zupanije; DROP TABLE proizvodjaci; @@ -65,12 +66,19 @@ opis TEXT ); -CREATE TABLE atk_inn ( +CREATE TABLE atk ( sifra CHAR VARYING(20) PRIMARY KEY NOT NULL, naziv CHAR VARYING(100) NOT NULL, razno TEXT ); +CREATE TABLE inn ( + sifra CHAR VARYING(20) PRIMARY KEY NOT NULL, + naziv CHAR VARYING(100) NOT NULL, + razno TEXT +); + + CREATE TABLE zupanije ( broj INTEGER NOT NULL, naziv CHAR VARYING(30) NOT NULL,