X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=f80fb9a660c75c4ba7980508bbf12b0ed851f3b0;hb=a3a04c5887779e9ca8024a3e87ece109b8d9b0c1;hp=024f067e1ad6282cc84cd23973c5587dd627a3bf;hpb=9c75bfe936c5deb4775ecef059d3fedbd5a96352;p=portal.git

diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index 024f067e..f80fb9a6 100644
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -11,14 +11,14 @@
 -- -----------------------------------------------------------------------------------------------------------------
 set foreign_key_checks=1; 
 
+create database portal;
+
 SET GLOBAL character_set_client     = utf8;
 SET GLOBAL character_set_connection = utf8;
 SET GLOBAL character_set_database   = utf8;
 SET GLOBAL character_set_results    = utf8;
 SET GLOBAL character_set_server     = utf8;
 
-create database portal;
-
 use portal;
 
 -- ------------------ create table section
@@ -315,7 +315,7 @@ create table fn_user (
     silo_status character varying(10)
 );
 
-alter table fn_user add column language_id int(2) not null default 1;
+alter table fn_user add column language_id int(2) default 1;
 
 create table fn_language(
     language_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,