diff options
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 |