X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=f80fb9a660c75c4ba7980508bbf12b0ed851f3b0;hb=83de9db899ebf7ec87220670d6f5cf35a10d087b;hp=fd3828a45eab8aca31feb7582f53483de3539941;hpb=21a8761f684745bb300e075c7e98ad897ace9eed;p=portal.git

diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index fd3828a4..f80fb9a6 100644
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -13,6 +13,12 @@ set foreign_key_checks=1;
 
 create database portal;
 
+SET GLOBAL character_set_client     = utf8;
+SET GLOBAL character_set_connection = utf8;
+SET GLOBAL character_set_database   = utf8;
+SET GLOBAL character_set_results    = utf8;
+SET GLOBAL character_set_server     = utf8;
+
 use portal;
 
 -- ------------------ create table section
@@ -308,6 +314,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) 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
 --
@@ -1124,7 +1145,7 @@ CREATE TABLE ep_microservice (
 	endpoint_url VARCHAR(200) NULL DEFAULT NULL,
 	security_type VARCHAR(50) NULL DEFAULT NULL,
 	username VARCHAR(50) NULL DEFAULT NULL,
-	password VARCHAR(50) NULL DEFAULT NULL,
+	password VARCHAR(50) NOT NULL,
 	active CHAR(1) NOT NULL DEFAULT 'Y',
 	PRIMARY KEY (id),
 	CONSTRAINT FK_FN_APP_EP_MICROSERVICE FOREIGN KEY (appId) REFERENCES fn_app (app_id)
@@ -1178,7 +1199,7 @@ create table ep_basic_auth_account (
 	id INT(11) NOT NULL AUTO_INCREMENT,
 	ext_app_name VARCHAR(50) NOT NULL,
 	username VARCHAR(50) NOT NULL,
-	password VARCHAR(50) NOT NULL,
+	password VARCHAR(50) null default null,
     active_yn char(1) NOT NULL default 'Y',
 	PRIMARY KEY (id)
 );
@@ -1280,7 +1301,7 @@ create table  ep_endpoints_basic_auth_account (
 CREATE TABLE ep_app_function (
 app_id INT(11) NOT NULL,
 function_cd VARCHAR(250) NOT NULL,
-function_name VARCHAR(50) NOT NULL,
+function_name VARCHAR(250) NOT NULL,
 PRIMARY KEY (function_cd, app_id),
 INDEX fk_ep_app_function_app_id (app_id),
 CONSTRAINT fk_ep_app_function_app_id FOREIGN KEY (app_id) REFERENCES fn_app (app_id)