X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalMySql_3_2_Add_1.sql;fp=ecomp-portal-DB-common%2FPortalDMLMySql_3_1_Common.sql;h=a2483f23c375547d3a74c30b321d57aa36a2685f;hb=8886d15461f5003b7d81677570ee3f75946b1354;hp=cf238506aa189a4696ed4521e6b7293130623cc7;hpb=c8e0094ea4d8dfd232baacff4affcd2cefc9a5d8;p=portal.git

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 cf238506..a2483f23 100644
--- 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;