Mercurial > dive4elements > river
changeset 9637:eb32f75c65c3
Nachtrag Pos. 20: update script for oracle database
author | mschaefer |
---|---|
date | Mon, 11 Nov 2019 16:35:56 +0100 |
parents | ac41551a8e4d |
children | df668014016e |
files | backend/doc/schema/oracle_migrations/update_nachtrag_20.sql |
diffstat | 1 files changed, 16 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/backend/doc/schema/oracle_migrations/update_nachtrag_20.sql Mon Nov 11 16:35:56 2019 +0100 @@ -0,0 +1,16 @@ +--Neues Feld infrastructure.group_id + +SET AUTOCOMMIT ON; + +ALTER TABLE infrastructure ADD (group_id NUMBER(38,0)); + +UPDATE infrastructure SET group_id=annotation_type_id; + +ALTER TABLE infrastructure MODIFY (group_id NOT NULL); + +ALTER TABLE infrastructure ADD CONSTRAINT cInfrastructureGroupAnnoType + FOREIGN KEY (group_id) REFERENCES annotation_types; + +COMMENT ON COLUMN infrastructure.group_id IS 'Reference to the infrastructure type group'; + +COMMIT;