aboutsummaryrefslogtreecommitdiffstats
path: root/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql
blob: b6df3ae15a6b1a34df7567fccb93f4e6746bf1e7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- --------------------------------------------------------------
-- DROP ALL OF THE INTENGER IDs
-- --------------------------------------------------------------
ALTER TABLE SCHEDULES DROP COLUMN id;
ALTER TABLE DOMAIN_DATA DROP COLUMN id;
ALTER TABLE DOMAIN_DATA DROP COLUMN schedules_id;
ALTER TABLE APPROVAL_TYPES DROP COLUMN id;
ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN id;
ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN schedules_id;
ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN approval_type_id;
ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP COLUMN id;
ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP COLUMN schedules_id;
ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP COLUMN id;
ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP COLUMN change_management_groups_id;
ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP COLUMN id;
ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP COLUMN change_management_groups_id;