diff options
| author |   shentao999 <shentao@chinamobile.com> | 2019-04-02 10:07:27 +0800 |
|---|---|---|
| committer | shentao999 <shentao@chinamobile.com> | 2019-04-02 10:07:28 +0800 |
| commit | 498b428a661aabf16f288bc8c3dffded35becef6 (patch) | |
| tree | 9cd8045bf183780f706a5463f437a399fb234950 /ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | |
| parent | 45d2f704aca7076d510749985d1f7a5f111f73d5 (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/PortalDDLMySql_2_1_Common.sql')
| -rw-r--r-- | ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | 17 |
1 files changed, 16 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 |