diff options
author | Jerry Flood <jflood@att.com> | 2019-03-15 01:08:05 -0400 |
---|---|---|
committer | Jerry Flood <jflood@att.com> | 2019-03-15 01:25:06 -0400 |
commit | c0f2c43b2074a3ef76b40c45803ce788ec79dce6 (patch) | |
tree | 9ff130a3b71e35644d8bae31ac21bf8c174a17c8 /cmso-robot/robot/assets/sql | |
parent | 58e3b7d27c6a577c425dc3cc3c39350d2aba4ca6 (diff) |
DB Schema update for Dublin
- Added optimizer schema
- updated cmso schema to use uuid PK
Issue-ID: OPTFRA-459
Change-Id: I1457b7d06b371298443a451af26e756d7b42f66c
Signed-off-by: Jerry Flood <jflood@att.com>
Diffstat (limited to 'cmso-robot/robot/assets/sql')
-rw-r--r-- | cmso-robot/robot/assets/sql/selectall.sql | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/cmso-robot/robot/assets/sql/selectall.sql b/cmso-robot/robot/assets/sql/selectall.sql index ba41595..4ffae93 100644 --- a/cmso-robot/robot/assets/sql/selectall.sql +++ b/cmso-robot/robot/assets/sql/selectall.sql @@ -1,9 +1,10 @@ -select * from DOMAINS; -select * from DOMAIN_DATA order by schedules_id desc; -select * from CHANGE_MANAGEMENT_SCHEDULES order by id desc; -select * from CHANGE_MANAGEMENT_CHANGE_WINDOWS; -select * from CHANGE_MANAGEMENT_GROUPS; -select * from SCHEDULES order by id desc; -select * from APPROVAL_TYPES; -select * from SCHEDULE_APPROVALS; -select * from SCHEDULE_EVENTS;
\ No newline at end of file +select DOMAINS.* from CMSO.DOMAINS; +select hex(uuid), hex(schedules_uuid), DOMAIN_DATA.* from CMSO.DOMAIN_DATA order by schedules_uuid; +select hex(uuid), hex(change_management_group_uuid), CHANGE_MANAGEMENT_SCHEDULES.* from CMSO.CHANGE_MANAGEMENT_SCHEDULES order by uuid desc; +select hex(uuid), hex(schedules_uuid), hex(change_management_group_uuid), CHANGE_MANAGEMENT_CHANGE_WINDOWS.* from CMSO.CHANGE_MANAGEMENT_CHANGE_WINDOWS; +select hex(uuid), hex(schedules_uuid), CHANGE_MANAGEMENT_GROUPS.* from CMSO.CHANGE_MANAGEMENT_GROUPS; +select hex(uuid), SCHEDULES.* from CMSO.SCHEDULES order by create_date_time desc; +select hex(uuid), APPROVAL_TYPES.* from CMSO.APPROVAL_TYPES; +select hex(uuid), hex(approval_types_uuid), hex(schedules_uuid), SCHEDULE_APPROVALS.* from CMSO.SCHEDULE_APPROVALS; +select hex(uuid), hex(change_management_schedules_uuid), ELEMENT_DATA.* from CMSO.ELEMENT_DATA; + |