From 498b428a661aabf16f288bc8c3dffded35becef6 Mon Sep 17 00:00:00 2001 From: shentao999 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 --- 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