summaryrefslogtreecommitdiffstats
path: root/ecomp-portal-DB-common
diff options
context:
space:
mode:
authorshentao999 <shentao@chinamobile.com>2019-04-02 10:07:27 +0800
committershentao999 <shentao@chinamobile.com>2019-04-02 10:07:28 +0800
commit498b428a661aabf16f288bc8c3dffded35becef6 (patch)
tree9cd8045bf183780f706a5463f437a399fb234950 /ecomp-portal-DB-common
parent45d2f704aca7076d510749985d1f7a5f111f73d5 (diff)
Add language tables and init data into DB-common
Change-Id: I0a20395435cc600f8b710e9879bea60fea9abc9d Issue-ID: PORTAL-376 Signed-off-by: shentao999 <shentao@chinamobile.com>
Diffstat (limited to 'ecomp-portal-DB-common')
-rw-r--r--ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql17
-rw-r--r--ecomp-portal-DB-common/PortalDMLMySql_2_1_Common.sql30
2 files changed, 46 insertions, 1 deletions
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
diff --git a/ecomp-portal-DB-common/PortalDMLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDMLMySql_2_1_Common.sql
index 6cd767b4..c3234d0a 100644
--- a/ecomp-portal-DB-common/PortalDMLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDMLMySql_2_1_Common.sql
@@ -5,6 +5,36 @@ USE portal;
set foreign_key_checks=1;
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,2,'Home');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,3,'Application Catalog');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,4,'Widget Catalog');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,5,'Admins');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,6,'Roles');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,7,'Users');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,8,'Portal Admins');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,9,'Application Onboarding');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,10,'Widget Onboarding');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,11,'Edit Functional Menu');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,12,'User Notifications');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,13,'Microservice Onboarding');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (1,15,'App Account Management');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,2,'主页');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,3,'应用目录');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,4,'部件目录');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,5,'管理员');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,6,'角色');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,7,'用户');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,8,'门户管理员');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,9,'应用管理');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,10,'部件管理');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,11,'编辑功能菜单');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,12,'用户通知');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,13,'微服务管理');
+INSERT INTO fn_display_text (language_id,text_id,text_label) VALUES (2,15,'应用账户管理');
+
+INSERT INTO fn_language (language_name,language_alias) VALUES ('English','EN');
+INSERT INTO fn_language (language_name,language_alias) VALUES ('简体中文','CN');
+
-- FN_FUNCTION
Insert into fn_function (FUNCTION_CD,FUNCTION_NAME) values ('menu_process','Process List');
Insert into fn_function (FUNCTION_CD,FUNCTION_NAME) values ('menu_job','Job Menu');