1 files changed, 33 insertions, 0 deletions
diff --git a/ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql b/ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql
new file mode 100644
index 0000000..5f0548a
--- /dev/null
+++ b/ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql
@@ -0,0 +1,33 @@
+/*-
+* ============LICENSE_START=======================================================
+* Ransim Controller DB
+* ================================================================================
+* Copyright (C) 2020 Wipro Limited 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=========================================================
+*/
+
+CREATE DATABASE IF NOT EXISTS `ransim_db`;
+
+USE `ransim_db`;
+set foreign_key_checks=0;
+
+--
+-- Increasing the Database variable timeouts
+--
+
+set wait_timeout=2147483;
+set interactive_timeout=2147483;
+
+-- drop table if exists `constrainttype`;