diff options
| -rw-r--r-- | ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | 17 | ||||
| -rw-r--r-- | ecomp-portal-DB-common/PortalDMLMySql_2_1_Common.sql | 30 |
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'); |