Mercurial > dive4elements > river
comparison backend/doc/schema/oracle_migrations/update_nachtrag_20.sql @ 9639:df668014016e
Merge
| author | dnt_bjoernsen <d.tironi@bjoernsen.de> |
|---|---|
| date | Tue, 12 Nov 2019 09:24:07 +0100 |
| parents | eb32f75c65c3 |
| children |
comparison
equal
deleted
inserted
replaced
| 9638:6c1ebf2220f5 | 9639:df668014016e |
|---|---|
| 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; |