Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 2353:67e0371f6f40
Adjusted NUMBER format for units, positions and cross_section_points tables.
flys-backend/trunk@2986 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Mon, 17 Oct 2011 12:10:12 +0000 |
| parents | 8126ccb58f28 |
| children | 40093215061b |
comparison
equal
deleted
inserted
replaced
| 2352:8126ccb58f28 | 2353:67e0371f6f40 |
|---|---|
| 71 CREATE TABLE cross_section_points ( | 71 CREATE TABLE cross_section_points ( |
| 72 id NUMBER(38,0) NOT NULL, | 72 id NUMBER(38,0) NOT NULL, |
| 73 col_pos NUMBER(38,0), | 73 col_pos NUMBER(38,0), |
| 74 x NUMBER(38,2), | 74 x NUMBER(38,2), |
| 75 y NUMBER(38,2), | 75 y NUMBER(38,2), |
| 76 cross_section_line_id NUMBER(10,0), | 76 cross_section_line_id NUMBER(38,0), |
| 77 PRIMARY KEY (id) | 77 PRIMARY KEY (id) |
| 78 ); | 78 ); |
| 79 | 79 |
| 80 CREATE OR REPLACE TRIGGER cross_section_points_trigger BEFORE INSERT ON cross_section_points FOR each ROW | 80 CREATE OR REPLACE TRIGGER cross_section_points_trigger BEFORE INSERT ON cross_section_points FOR each ROW |
| 81 BEGIN | 81 BEGIN |
| 321 | 321 |
| 322 -- POSITIONS | 322 -- POSITIONS |
| 323 CREATE SEQUENCE POSITIONS_ID_SEQ; | 323 CREATE SEQUENCE POSITIONS_ID_SEQ; |
| 324 | 324 |
| 325 CREATE TABLE positions ( | 325 CREATE TABLE positions ( |
| 326 id NUMBER(10,0) NOT NULL, | 326 id NUMBER(38,0) NOT NULL, |
| 327 value VARCHAR2(255 char), | 327 value VARCHAR2(255 char), |
| 328 PRIMARY KEY (id) | 328 PRIMARY KEY (id) |
| 329 ); | 329 ); |
| 330 | 330 |
| 331 CREATE OR REPLACE TRIGGER positions_trigger BEFORE INSERT ON positions FOR each ROW | 331 CREATE OR REPLACE TRIGGER positions_trigger BEFORE INSERT ON positions FOR each ROW |
| 388 | 388 |
| 389 --- UNITS | 389 --- UNITS |
| 390 CREATE SEQUENCE UNITS_ID_SEQ; | 390 CREATE SEQUENCE UNITS_ID_SEQ; |
| 391 | 391 |
| 392 CREATE TABLE units ( | 392 CREATE TABLE units ( |
| 393 id NUMBER(10,0) NOT NULL, | 393 id NUMBER(38,0) NOT NULL, |
| 394 name VARCHAR2(255), | 394 name VARCHAR2(255), |
| 395 PRIMARY KEY (id) | 395 PRIMARY KEY (id) |
| 396 ); | 396 ); |
| 397 | 397 |
| 398 CREATE OR REPLACE TRIGGER units_trigger BEFORE INSERT ON units FOR each ROW | 398 CREATE OR REPLACE TRIGGER units_trigger BEFORE INSERT ON units FOR each ROW |