Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6632:97145ec4e33c double-precision
Schema changes: fixed typos, syntax errors and missing or obsolete statements in Oracle schema
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 22 Jul 2013 18:06:23 +0200 |
| parents | 7fb0e755e4fa |
| children | c14e17dabf39 |
comparison
equal
deleted
inserted
replaced
| 6631:9aa1c946b87d | 6632:97145ec4e33c |
|---|---|
| 245 CREATE TABLE grain_fraction ( | 245 CREATE TABLE grain_fraction ( |
| 246 id NUMBER(38,0) NOT NULL, | 246 id NUMBER(38,0) NOT NULL, |
| 247 name VARCHAR(64) NOT NULL, | 247 name VARCHAR(64) NOT NULL, |
| 248 lower NUMBER(38,3), | 248 lower NUMBER(38,3), |
| 249 upper NUMBER(38,3), | 249 upper NUMBER(38,3), |
| 250 PRIMARY KEY (id), | 250 PRIMARY KEY (id) |
| 251 ); | 251 ); |
| 252 | 252 |
| 253 | 253 |
| 254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; | 254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; |
| 255 | 255 |