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=d7f3b463c9f0f11ceb0aad255f564b02c22ab978;hp=024f067e1ad6282cc84cd23973c5587dd627a3bf;hpb=0f32f237134aa2c455f30ad0d3ecb6ddfcea4d21;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,