summaryrefslogtreecommitdiffstats
path: root/cmso-robot
diff options
context:
space:
mode:
authorJerry Flood <jflood@att.com>2019-03-15 01:08:05 -0400
committerJerry Flood <jflood@att.com>2019-03-15 01:25:06 -0400
commitc0f2c43b2074a3ef76b40c45803ce788ec79dce6 (patch)
tree9ff130a3b71e35644d8bae31ac21bf8c174a17c8 /cmso-robot
parent58e3b7d27c6a577c425dc3cc3c39350d2aba4ca6 (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')
-rw-r--r--cmso-robot/robot/assets/sql/selectall.sql19
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;
+