Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 5777:e95427ed80e5
Merged
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Sun, 21 Apr 2013 10:46:59 +0200 |
| parents | 88cbe798cbab |
| children | 153456f84602 |
comparison
equal
deleted
inserted
replaced
| 5776:1126b9e00378 | 5777:e95427ed80e5 |
|---|---|
| 109 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; | 109 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; |
| 110 | 110 |
| 111 CREATE TABLE named_main_values ( | 111 CREATE TABLE named_main_values ( |
| 112 id int PRIMARY KEY NOT NULL, | 112 id int PRIMARY KEY NOT NULL, |
| 113 name VARCHAR(256) NOT NULL UNIQUE, | 113 name VARCHAR(256) NOT NULL UNIQUE, |
| 114 type_id int NOT NULL REFERENCES main_value_types(id), | 114 type_id int NOT NULL REFERENCES main_value_types(id) |
| 115 UNIQUE (name, type_id) | |
| 116 ); | 115 ); |
| 117 | 116 |
| 118 -- Table for time intervals | 117 -- Table for time intervals |
| 119 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; | 118 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; |
| 120 | 119 |