Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6871:5ce6a3d7d632 double-precision
Undo misguided schema change from r5207
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 19 Aug 2013 17:29:52 +0200 |
| parents | 839f1a889c4a |
| children | dddf633fec05 |
comparison
equal
deleted
inserted
replaced
| 6825:3aff1b00618a | 6871:5ce6a3d7d632 |
|---|---|
| 122 aeo NUMBER(38,2) NOT NULL, | 122 aeo NUMBER(38,2) NOT NULL, |
| 123 datum NUMBER(38,2) NOT NULL, | 123 datum NUMBER(38,2) NOT NULL, |
| 124 name VARCHAR2(255) NOT NULL, | 124 name VARCHAR2(255) NOT NULL, |
| 125 station NUMBER(38,2) NOT NULL, | 125 station NUMBER(38,2) NOT NULL, |
| 126 official_number NUMBER(38,0), | 126 official_number NUMBER(38,0), |
| 127 range_id NUMBER(38,0) NOT NULL, | 127 range_id NUMBER(38,0), |
| 128 -- TODO: remove river id here because range_id references river already | 128 -- TODO: remove river id here because range_id references river already |
| 129 river_id NUMBER(38,0) NOT NULL, | 129 river_id NUMBER(38,0) NOT NULL, |
| 130 PRIMARY KEY (id), | 130 PRIMARY KEY (id), |
| 131 UNIQUE (name, river_id), | 131 UNIQUE (name, river_id), |
| 132 UNIQUE (official_number, river_id), | 132 UNIQUE (official_number, river_id), |