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
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
--
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)
);
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