Updated DB scripts and Dockerfile.mariadb

[portal.git] / ecomp-portal-DB-common / PortalMySql_3_2_Add_1.sql

diff --git a/ecomp-portal-DB-common/PortalDMLMySql_3_1_Common.sql b/ecomp-portal-DB-common/PortalMySql_3_2_Add_1.sql
similarity index 74%
rename from ecomp-portal-DB-common/PortalDMLMySql_3_1_Common.sql
rename to ecomp-portal-DB-common/PortalMySql_3_2_Add_1.sql
index cf23850..a2483f2 100644 (file)
--- a/ecomp-portal-DB-common/PortalDMLMySql_3_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalMySql_3_2_Add_1.sql
@@ -1,6 +1,13 @@
--- --------------------------------------------------------------------------------------------
--- This is the common default data for 3.1.0 Version of Portal database called portal 
-
+-- ---------------------------------------------------------------------------------------------------------------
+-- This is add script #1 for the 3_1 Version of Ecomp Portal database called portal.
+-- It upgrades the database from the 1911 version.
+-- note to database admin: must set the mysql system variable called lower_case_table_names.
+-- it can be set 3 different ways: 
+--                      command-line options (cmd-line), 
+--                      options valid in configuration files (option file), or 
+--                      server system variables (system var). 
+-- it needs to be set to 1, then table names are stored in lowercase on disk and comparisons are not case sensitive. 
+-- -----------------------------------------------------------------------------------------------------------------
 use portal;
 
 set foreign_key_checks=1;