-- -----------------------------------------------------------------------------------------------------------------
set foreign_key_checks=1;
-create database portal_os;
+create database portal;
use portal;
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)
alter table fn_menu_favorites
add constraint sys_c0014619 foreign key (menu_id) references fn_menu_functional(menu_id);
-commit;
\ No newline at end of file
+commit;