Mercurial > dive4elements > river
annotate backend/doc/schema/oracle_migrations/update_nachtrag_20.sql @ 9652:dd93bb84561d
Importer (s/u-info) extensions: cancelling bed-mobility import if wrong mobility keywords
author | mschaefer |
---|---|
date | Mon, 23 Mar 2020 15:03:11 +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; |