diff options
| author |   RamaPrasad Amaranarayana (ra5425) <ra5425@att.com> | 2018-09-19 17:40:40 -0400 |
|---|---|---|
| committer | RamaPrasad Amaranarayana (ra5425) <ra5425@att.com> | 2018-09-19 17:40:40 -0400 |
| commit | fbe4bb98345727d190cefcfb3ec54ad9075fba9d (patch) | |
| tree | f2e0c091a4c132c89dafb061c81eeebfb0e9a773 /cmso-robot/robot/assets/sql/clearthetable.sql | |
| parent | b031d50f82f8ca5b7fd0609a92c719f43a9f518d (diff) | |
Change Management Schedule Optimization
Adding Robot Test Scripts for Change Management Schedule Optimization
Change-Id: Id5edf9d3fb3c2390791362692c8b25f7607045c6
Issue-ID: OPTFRA-352
Signed-off-by: RamaPrasad Amaranarayana (ra5425) <ra5425@att.com>
Diffstat (limited to 'cmso-robot/robot/assets/sql/clearthetable.sql')
| -rw-r--r-- | cmso-robot/robot/assets/sql/clearthetable.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/cmso-robot/robot/assets/sql/clearthetable.sql b/cmso-robot/robot/assets/sql/clearthetable.sql new file mode 100644 index 0000000..e382222 --- /dev/null +++ b/cmso-robot/robot/assets/sql/clearthetable.sql @@ -0,0 +1,11 @@ +SET SQL_SAFE_UPDATES = 0; +delete from DOMAIN_DATA; +delete from CHANGE_MANAGEMENT_CHANGE_WINDOWS; +delete from CHANGE_MANAGEMENT_RELATED_ASSETS; +delete from CHANGE_MANAGEMENT_SCHEDULES; +delete from CHANGE_MANAGEMENT_GROUPS; +delete from SCHEDULE_APPROVALS; +delete from SCHEDULE_EVENTS; +delete from SCHEDULES; + +SET SQL_SAFE_UPDATES = 1; |