diff options
author | Manoop Talasila <talasila@research.att.com> | 2019-04-11 13:44:23 +0000 |
---|---|---|
committer | Gerrit Code Review <gerrit@onap.org> | 2019-04-11 13:44:23 +0000 |
commit | d350340d41cc5e53d0b212c3fd2c3f80cae60a51 (patch) | |
tree | ca45dfb306ae9a82c346a7d549071351883f819b /ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | |
parent | f4da16d901833464b5d572dcc335e6888d0d8d45 (diff) | |
parent | 498b428a661aabf16f288bc8c3dffded35becef6 (diff) |
Merge "Add language tables and init data into DB-common"
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 |