From c0f2c43b2074a3ef76b40c45803ce788ec79dce6 Mon Sep 17 00:00:00 2001 From: Jerry Flood Date: Fri, 15 Mar 2019 01:08:05 -0400 Subject: 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 --- cmso-robot/robot/assets/sql/selectall.sql | 19 ++++++++++--------- 1 file changed, 10 insertions(+), 9 deletions(-) (limited to 'cmso-robot') 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; + -- cgit 1.2.3-korg