X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=2cf5b75c449fd973e78f9ac3c29bf57eb330117e;hb=498b428a661aabf16f288bc8c3dffded35becef6;hp=3dabe92c2bb15ba19fbedafdc4bd40159af15b5a;hpb=45d2f704aca7076d510749985d1f7a5f111f73d5;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..2cf5b75c 100644
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -308,6 +308,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 +1770,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