X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=024f067e1ad6282cc84cd23973c5587dd627a3bf;hb=513d223fd12f3c1eb248ea6c164bc996141b0f18;hp=3dabe92c2bb15ba19fbedafdc4bd40159af15b5a;hpb=a70761c096192e38800bf38d6c7f61f52bf72007;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 3dabe92c..024f067e 100644
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -11,6 +11,12 @@
 -- -----------------------------------------------------------------------------------------------------------------
 set foreign_key_checks=1; 
 
+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;
@@ -308,6 +314,21 @@ create table fn_user (
     fin_loc_code character varying(10),
     silo_status character varying(10)
 );
+
+alter table fn_user add column language_id int(2) not null default 1;
+
+create table fn_language(
+    language_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
+    language_name VARCHAR(100) NOT NULL,
+    language_alias VARCHAR(100) NOT NULL
+);
+
+create table fn_display_text(
+    id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
+    language_id int(11) NOT NULL,
+    text_id int(11) NOT NULL,
+    text_label VARCHAR(100) NOT NULL
+);
 --
 -- name: fn_role; type: table
 --
@@ -1755,4 +1776,4 @@ add constraint sys_c0014618 foreign key (user_id) references fn_user(user_id);
 alter table fn_menu_favorites
 add constraint sys_c0014619 foreign key (menu_id) references fn_menu_functional(menu_id);
 
-commit;
+commit;
\ No newline at end of file