/[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.4 by dpavlin, Tue Jun 19 10:10:48 2001 UTC
# Line 6  DROP TABLE trudnoca; Line 6  DROP TABLE trudnoca;
6  DROP TABLE dojencad;  DROP TABLE dojencad;
7  DROP TABLE vozac;  DROP TABLE vozac;
8  DROP TABLE droga;  DROP TABLE droga;
9  DROP TABLE atk_inn;  DROP TABLE atk;
10    DROP TABLE inn;
11  DROP TABLE zupanije;  DROP TABLE zupanije;
12  DROP TABLE proizvodjaci;  DROP TABLE proizvodjaci;
13    
# Line 36  CREATE TABLE lijekovi ( Line 37  CREATE TABLE lijekovi (
37  );  );
38    
39  CREATE TABLE nacin_izdavanja (  CREATE TABLE nacin_izdavanja (
40          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
41          opis TEXT          opis TEXT
42  );  );
43    
44  CREATE TABLE list_fond (  CREATE TABLE list_fond (
45          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
46          opis TEXT          opis TEXT
47  );  );
48    
49  CREATE TABLE trudnoca (  CREATE TABLE trudnoca (
50          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
51          opis TEXT          opis TEXT
52  );  );
53    
54  CREATE TABLE dojencad (  CREATE TABLE dojencad (
55          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
56          opis TEXT          opis TEXT
57  );  );
58    
59  CREATE TABLE vozac (  CREATE TABLE vozac (
60          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
61          opis TEXT          opis TEXT
62  );  );
63    
64  CREATE TABLE droga (  CREATE TABLE droga (
65          sifra CHAR VARYING(5) NOT NULL,          sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
66          opis TEXT          opis TEXT
67  );  );
68    
69  CREATE TABLE atk_inn (  CREATE TABLE atk (
70          sifra CHAR VARYING(20) PRIMARY KEY NOT NULL,          sifra CHAR VARYING(20) PRIMARY KEY NOT NULL,
71          naziv CHAR VARYING(100) NOT NULL,          naziv CHAR VARYING(100) NOT NULL,
72          razno TEXT          razno TEXT
73  );  );
74    
75    CREATE TABLE inn (
76            sifra CHAR VARYING(20) PRIMARY KEY NOT NULL,
77            naziv CHAR VARYING(100) NOT NULL,
78            razno TEXT
79    );
80    
81    
82  CREATE TABLE zupanije (  CREATE TABLE zupanije (
83          broj INTEGER NOT NULL,          broj INTEGER NOT NULL,
84          naziv CHAR VARYING(30) NOT NULL,          naziv CHAR VARYING(30) NOT NULL,
85          centar CHAR VARYING(20) NOT NULL,          centar CHAR VARYING(20) NOT NULL,
86          pos_broj CHAR VARYING(7) NOT NULL,          pos_broj CHAR VARYING(7) NOT NULL PRIMARY KEY,
87          npos_broj CHAR VARYING(7) NOT NULL,          npos_broj CHAR VARYING(7) NOT NULL,
88          spos_broj CHAR VARYING(7) NOT NULL,          spos_broj CHAR VARYING(7) NOT NULL,
89          grad CHAR VARYING(20) NOT NULL,          grad CHAR VARYING(20) NOT NULL,
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.26