diff options
Diffstat (limited to 'packages/base/src/files/install/mysql/data')
-rw-r--r-- | packages/base/src/files/install/mysql/data/171001_downgrade_script.sql | 21 | ||||
-rw-r--r-- | packages/base/src/files/install/mysql/data/171001_upgrade_script.sql | 29 |
2 files changed, 50 insertions, 0 deletions
diff --git a/packages/base/src/files/install/mysql/data/171001_downgrade_script.sql b/packages/base/src/files/install/mysql/data/171001_downgrade_script.sql new file mode 100644 index 000000000..c7c74284c --- /dev/null +++ b/packages/base/src/files/install/mysql/data/171001_downgrade_script.sql @@ -0,0 +1,21 @@ +/*- +* ============LICENSE_START======================================================= +* ECOMP Policy Engine +* ================================================================================ +* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. +* ================================================================================ +* Licensed under the Apache License, Version 2.0 (the "License"); +* you may not use this file except in compliance with the License. +* You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +* ============LICENSE_END========================================================= +*/ +use ecomp_sdk; +drop table if exists rainydaytreatments;
\ No newline at end of file diff --git a/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql b/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql new file mode 100644 index 000000000..6be2f25c5 --- /dev/null +++ b/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql @@ -0,0 +1,29 @@ +/*- +* ============LICENSE_START======================================================= +* ECOMP Policy Engine +* ================================================================================ +* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. +* ================================================================================ +* Licensed under the Apache License, Version 2.0 (the "License"); +* you may not use this file except in compliance with the License. +* You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +* ============LICENSE_END========================================================= +*/ +use ecomp_sdk; +drop table if exists `ecomp_sdk`.`rainydaytreatments`; + +CREATE TABLE `ecomp_sdk`.`rainydaytreatments` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `bbid` varchar(250) DEFAULT NULL, + `workstep` varchar(250) DEFAULT NULL, + `treatments` varchar(1024) DEFAULT NULL, + PRIMARY KEY (`id`) +);
\ No newline at end of file |