/[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.3 by dpavlin, Tue Jun 19 09:27:25 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 65  CREATE TABLE droga ( Line 66  CREATE TABLE droga (
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,
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.26