annotate backend/doc/schema/oracle_migrations/update_nachtrag_20.sql @ 9657:a79881a892c9
Importer (s/u-info) extensions: depth-evolution: corrected directory name Bezug_aktueller_GlW,
detecting and logging of wrong units, then cancelling,
various checks of the plausibility of the meta data year values and cancelling in case of errors,
detecting and logging missing change values, skipping those lines
| author |
mschaefer |
| date |
Mon, 23 Mar 2020 15:26:50 +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; |
