aboutsummaryrefslogtreecommitdiffstats
path: root/ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql
diff options
context:
space:
mode:
authorPriyadharshini <priyadharshini.b96@wipro.com>2020-03-16 05:55:43 +0000
committerPriyadharshini <priyadharshini.b96@wipro.com>2020-03-23 09:11:55 +0530
commitcfb63b2c5c381434a6fdea794ad0c2e89a2be328 (patch)
tree586b997a0634198bf0b0ded5dbbde51ff7311b27 /ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql
parent44d8e15bda321936078b99f8222175a8ab016bc6 (diff)
Initial code check-in RANSim Controller and RANSim GUI
Issue-ID: INT-1485 Signed-off-by: Priyadharshini <priyadharshini.b96@wipro.com> Change-Id: I99fe693065072ff5c9b188f2177488a4cd93237d
Diffstat (limited to 'ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql')
-rw-r--r--ransim/ransimctrlr/packages/base/src/files/install/mysql/data/181010_upgrade_script.sql33
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`;