Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6369:7fb0e755e4fa double-precision
Minimal schema change: allow longer names in discharge zones
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 18 Jun 2013 19:32:31 +0200 |
| parents | a3fb76cf79b6 |
| children | 97145ec4e33c |
comparison
equal
deleted
inserted
replaced
| 6366:cc21c197d204 | 6369:7fb0e755e4fa |
|---|---|
| 177 CREATE TABLE discharge_zone ( | 177 CREATE TABLE discharge_zone ( |
| 178 id NUMBER(38,0) NOT NULL, | 178 id NUMBER(38,0) NOT NULL, |
| 179 river_id NUMBER(38,0) NOT NULL, | 179 river_id NUMBER(38,0) NOT NULL, |
| 180 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance | 180 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance |
| 181 value NUMBER(38,3) NOT NULL, | 181 value NUMBER(38,3) NOT NULL, |
| 182 lower_discharge VARCHAR(16) NOT NULL, | 182 lower_discharge VARCHAR(64) NOT NULL, |
| 183 upper_discharge VARCHAR(16), | 183 upper_discharge VARCHAR(64), |
| 184 PRIMARY KEY(id), | 184 PRIMARY KEY(id), |
| 185 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE | 185 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE |
| 186 ); | 186 ); |
| 187 | 187 |
| 188 | 188 |