Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 5915:4fafe8d147b2
Schema change: named_main_values.name is not unique, as we can have the same name for different types
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 07 May 2013 18:19:57 +0200 |
| parents | 62e6598a2c4b |
| children | 131f5f58ff7d |
comparison
equal
deleted
inserted
replaced
| 5914:1058b3436dad | 5915:4fafe8d147b2 |
|---|---|
| 109 -- Named type of a Hauptwert (eg. HQ100) | 109 -- Named type of a Hauptwert (eg. HQ100) |
| 110 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; | 110 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; |
| 111 | 111 |
| 112 CREATE TABLE named_main_values ( | 112 CREATE TABLE named_main_values ( |
| 113 id int PRIMARY KEY NOT NULL, | 113 id int PRIMARY KEY NOT NULL, |
| 114 name VARCHAR(256) NOT NULL UNIQUE, | 114 name VARCHAR(256) NOT NULL, |
| 115 type_id int NOT NULL REFERENCES main_value_types(id) | 115 type_id int NOT NULL REFERENCES main_value_types(id) |
| 116 ); | 116 ); |
| 117 | 117 |
| 118 -- Table for time intervals | 118 -- Table for time intervals |
| 119 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; | 119 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; |