annotate backend/doc/schema/oracle_migrations/update_nachtrag_20.sql @ 9658:d86c7cb68b41
Importer (s/u-info) extensions: daily discharge: detecting, logging and skipping lines with missing date or q, or duplicate date,
detecting wrong column titles and cancelling the import,
specific error message if gauge not found
| author |
mschaefer |
| date |
Mon, 23 Mar 2020 15:33:40 +0100 |
| parents |
eb32f75c65c3 |
| children |
|
| rev |
line source |
|
9637
|
1 --Neues Feld infrastructure.group_id |
|
|
2 |
|
|
3 SET AUTOCOMMIT ON; |
|
|
4 |
|
|
5 ALTER TABLE infrastructure ADD (group_id NUMBER(38,0)); |
|
|
6 |
|
|
7 UPDATE infrastructure SET group_id=annotation_type_id; |
|
|
8 |
|
|
9 ALTER TABLE infrastructure MODIFY (group_id NOT NULL); |
|
|
10 |
|
|
11 ALTER TABLE infrastructure ADD CONSTRAINT cInfrastructureGroupAnnoType |
|
|
12 FOREIGN KEY (group_id) REFERENCES annotation_types; |
|
|
13 |
|
|
14 COMMENT ON COLUMN infrastructure.group_id IS 'Reference to the infrastructure type group'; |
|
|
15 |
|
|
16 COMMIT; |
