/[registar]/shema.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /shema.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by ravilov, Tue Jun 12 10:11:24 2001 UTC revision 1.3 by dpavlin, Tue Jun 19 09:27:25 2001 UTC
# Line 36  CREATE TABLE lijekovi ( Line 36  CREATE TABLE lijekovi (
36  );  );
37    
38  CREATE TABLE nacin_izdavanja (  CREATE TABLE nacin_izdavanja (
39          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
40          opis TEXT          opis TEXT
41  );  );
42    
43  CREATE TABLE list_fond (  CREATE TABLE list_fond (
44          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
45          opis TEXT          opis TEXT
46  );  );
47    
48  CREATE TABLE trudnoca (  CREATE TABLE trudnoca (
49          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
50          opis TEXT          opis TEXT
51  );  );
52    
53  CREATE TABLE dojencad (  CREATE TABLE dojencad (
54          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
55          opis TEXT          opis TEXT
56  );  );
57    
58  CREATE TABLE vozac (  CREATE TABLE vozac (
59          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
60          opis TEXT          opis TEXT
61  );  );
62    
63  CREATE TABLE droga (  CREATE TABLE droga (
64          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
65          opis TEXT          opis TEXT
66  );  );
67    
# Line 75  CREATE TABLE zupanije ( Line 75  CREATE TABLE zupanije (
75          broj INTEGER NOT NULL,          broj INTEGER NOT NULL,
76          naziv CHAR VARYING(30) NOT NULL,          naziv CHAR VARYING(30) NOT NULL,
77          centar CHAR VARYING(20) NOT NULL,          centar CHAR VARYING(20) NOT NULL,
78          pos_broj CHAR VARYING(7) NOT NULL,          pos_broj CHAR VARYING(7) NOT NULL PRIMARY KEY,
79          npos_broj CHAR VARYING(7) NOT NULL,          npos_broj CHAR VARYING(7) NOT NULL,
80          spos_broj CHAR VARYING(7) NOT NULL,          spos_broj CHAR VARYING(7) NOT NULL,
81          grad CHAR VARYING(20) NOT NULL,          grad CHAR VARYING(20) NOT NULL,
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.26