-- -----------------------------------------------------------------------------------------------------------------
set foreign_key_checks=1;
-create database portal_os;
+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;
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
--
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)
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)
);
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)