From 498b428a661aabf16f288bc8c3dffded35becef6 Mon Sep 17 00:00:00 2001
From: shentao999 <shentao@chinamobile.com>
Date: Tue, 2 Apr 2019 10:07:27 +0800
Subject: Add language tables and init data into DB-common

Change-Id: I0a20395435cc600f8b710e9879bea60fea9abc9d
Issue-ID: PORTAL-376
Signed-off-by: shentao999 <shentao@chinamobile.com>
---
 ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | 17 ++++++++++++++++-
 1 file changed, 16 insertions(+), 1 deletion(-)

(limited to 'ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql')

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
-- 
cgit 1.2.3-korg

