annotate backend/doc/schema/oracle_migrations/update_nachtrag_20.sql @ 9650:a2a42a6bac6b
Importer (s/u-info) extensions:
outer try/catch for parse and log of line no,
catching parsing exception if not enough value fields,
parsing error and warning log messages with line number,
detecting and rejecting duplicate data series,
better differentiation between error and warning log messages
| author |
mschaefer |
| date |
Mon, 23 Mar 2020 14:57:03 +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; |
