1 files changed, 320 insertions, 0 deletions
diff --git a/epsdk-app-onap/src/main/resources/db.changelog-01.sql b/epsdk-app-onap/src/main/resources/db.changelog-01.sql
new file mode 100644
index 000000000..acc061796
--- /dev/null
+++ b/epsdk-app-onap/src/main/resources/db.changelog-01.sql
@@ -0,0 +1,320 @@
+--liquibase formatted sql
+
+--changeset da797d:1
+CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_service_info` (
+  `ID` INT(11) NOT NULL AUTO_INCREMENT,
+   `JOB_ID` BINARY(16) NOT NULL,
+  `USER_ID` INT(11),
+  `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `PAUSE` TINYINT(1) NULL,
+  `OWNING_ENTITY_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `OWNING_ENTITY_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `PROJECT` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `AIC_ZONE_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `AIC_ZONE_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `TENANT_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `TENANT_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `REGION_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `REGION_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SERVICE_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SUBSCRIBER_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SERVICE_INSTANCE_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SERVICE_INSTANCE_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SERVICE_MODEL_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SERVICE_MODEL_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SERVICE_MODEL_VERSION` VARCHAR(20) NULL COLLATE 'utf8_bin',
+  PRIMARY KEY (`ID`),
+  CONSTRAINT `vid_service_info_vid_job_JOB_ID_fk` FOREIGN KEY (`JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+--rollback drop table `vid_openecomp_epsdk`.`vid_service_info`;
+
+--changeset em088y:2
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+ADD COLUMN CREATED_BULK_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ADD COLUMN IS_HIDDEN BIT,
+ADD COLUMN IS_PAUSE BIT,
+ADD COLUMN STATUS_MODIFIED_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+DROP COLUMN PAUSE;
+--rollback alter `vid_openecomp_epsdk`.`vid_service_info` drop CREATED_BULK_DATE, drop IS_HIDDEN, drop IS_PAUSE, drop STATUS_MODIFIED_DATE;
+
+--changeset em088y:3
+delete from `vid_openecomp_epsdk`.`vid_service_info`;
+delete from `vid_openecomp_epsdk`.`vid_job`;
+
+alter table `vid_openecomp_epsdk`.`vid_service_info` drop foreign key vid_service_info_vid_job_JOB_ID_fk;
+
+alter table `vid_openecomp_epsdk`.`vid_job`
+drop index `FK_OWNING_VID_JOB_PARENT`,
+drop FOREIGN KEY `FK_OWNING_VID_JOB_PARENT`,
+drop primary key,
+modify JOB_ID CHAR(36),
+modify PARENT_JOB_ID CHAR(36),
+add PRIMARY KEY (`JOB_ID`);
+
+alter table `vid_openecomp_epsdk`.`vid_job`
+add CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_job` (`JOB_ID`);
+
+alter table `vid_openecomp_epsdk`.`vid_service_info`
+modify JOB_ID CHAR(36),
+add FOREIGN KEY `FK_SERVICE_INFO_VID_JOB_ID`(`JOB_ID`) REFERENCES `vid_job` (`JOB_ID`);
+
+--changeset rr155p:4
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+DROP FOREIGN KEY  `FK_OWNING_VID_JOB_PARENT`;
+
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+ CHANGE COLUMN `PARENT_JOB_ID` `TEMPLATE_ID` CHAR(36) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `JOB_DATA`;
+
+--changeset is9613:5
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+ADD COLUMN `TEMPLATE_ID` CHAR(36) NULL DEFAULT NULL;
+
+--changeset rr155p:6
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+ADD COLUMN `USER_ID` VARCHAR(50) NULL COLLATE 'utf8_bin';
+
+--changeset is9613:7
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+  ADD COLUMN `AGE` INT NOT NULL default '0';
+
+--changeset rr155p:8
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+ CHANGE COLUMN `USER_ID` `USER_ID` VARCHAR(50) NULL COLLATE 'utf8_bin';
+
+--changeset cl0627:9
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+  ADD COLUMN DELETED_AT TIMESTAMP NULL DEFAULT NULL;
+
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  ADD COLUMN DELETED_AT TIMESTAMP NULL DEFAULT NULL;
+
+--changeset em088y:10
+UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `SORT_ORDER` = 13 where MENU_ID=110;
+UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `SORT_ORDER` = 12 where MENU_ID=109;
+INSERT INTO `vid_openecomp_epsdk`.`fn_menu` (`MENU_ID`, `LABEL`, `PARENT_ID`, `SORT_ORDER`, `ACTION`, `FUNCTION_CD`, `ACTIVE_YN`, `SERVLET`, `QUERY_STRING`, `EXTERNAL_URL`, `TARGET`, `MENU_SET_CD`, `SEPARATOR_YN`, `IMAGE_SRC`) VALUES
+(111, 'Macro Instantiation Status', 1, 11, 'serviceModels.htm#/instantiationStatus', 'menu_searchexisting', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-location-pin');
+
+--changeset is9613:job_index_in_bulk
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+  ADD COLUMN `INDEX_IN_BULK` INT NOT NULL default '0';
+
+
+--changeset rr155:vid_job_audit_status
+CREATE TABLE `vid_openecomp_epsdk`.`vid_job_audit_status` (
+  `ID` INT(11) NOT NULL AUTO_INCREMENT,
+  `JOB_ID` CHAR(36) NOT NULL,
+  `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `SOURCE` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `REQUEST_ID` CHAR(36) NULL,
+  `ADDITIONAL_INFO` VARCHAR (255) NULL,
+  `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+   PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+--changeset em088y:name_counter
+CREATE TABLE `vid_openecomp_epsdk`.`vid_name_counter` (
+  `NAME` VARCHAR(100) NOT NULL COLLATE 'utf8_bin',
+  `COUNTER` INT NOT NULL,
+  PRIMARY KEY (`NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+--changeset em088y:increase_names_maxsize_500
+alter table `vid_openecomp_epsdk`.`vid_service_info`
+modify `OWNING_ENTITY_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
+modify `AIC_ZONE_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
+modify `TENANT_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
+modify `REGION_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
+modify `SUBSCRIBER_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
+modify `SERVICE_INSTANCE_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
+modify `SERVICE_MODEL_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin';
+
+alter table `vid_openecomp_epsdk`.`vid_name_counter`
+modify `NAME` VARCHAR(255) NOT NULL COLLATE 'utf8_bin';
+
+--changeset is9613:add_SUBSCRIBER_ID_to_vid_service_info
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  ADD COLUMN `SUBSCRIBER_ID` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `SUBSCRIBER_NAME`;
+
+--changeset em088y:additional_info_maxsize_2000
+alter table `vid_openecomp_epsdk`.`vid_job_audit_status`
+modify `ADDITIONAL_INFO` VARCHAR(2000) NULL COLLATE 'utf8_bin';
+
+--changeset er767y:change_'Macro Instantiation Status'_menu_item
+UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `LABEL` = 'Instantiation Status' WHERE `MENU_ID`=111;
+
+--changeset cl0627:add_MSO_REQUEST_ID_and_IS_A_LA_CARTE_to_vid_service_info
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  ADD COLUMN `MSO_REQUEST_ID` CHAR(36) NULL AFTER `USER_ID`,
+  ADD COLUMN `IS_A_LA_CARTE` BIT NULL AFTER `MSO_REQUEST_ID`;
+
+--changeset cl0627:change_IS_A_LA_CARTE_to_not_null_and_default_false
+UPDATE `vid_openecomp_epsdk`.`vid_service_info` SET `IS_A_LA_CARTE` = 0 WHERE ISNULL(`IS_A_LA_CARTE`);
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  MODIFY `IS_A_LA_CARTE` bit(1) NOT NULL DEFAULT 0;
+
+
+--changeset vid:add_Action_and_Type_to_fn_function
+ALTER TABLE `vid_openecomp_epsdk`.`fn_function`
+  ADD COLUMN IF NOT EXISTS `type` VARCHAR(50) NULL AFTER `function_name`,
+  ADD COLUMN IF NOT EXISTS `action` VARCHAR(100) NULL AFTER `type`;
+
+--changeset em088y:increase_ids_maxsize_500
+alter table `vid_openecomp_epsdk`.`vid_service_info`
+modify `USER_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `MSO_REQUEST_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `OWNING_ENTITY_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `PROJECT` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `AIC_ZONE_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `TENANT_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `REGION_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `SERVICE_TYPE` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `SUBSCRIBER_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `SERVICE_INSTANCE_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `SERVICE_MODEL_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
+modify `SERVICE_MODEL_VERSION` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin';
+
+--changeset ah0398:restrict_url_for_role_management
+INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('get_user_roles','menu_admin');
+INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('addRoleFunction','menu_admin');
+
+--changeset rs282j:add_ACTION_to_vid_service_info
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  ADD COLUMN `ACTION` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin';
+
+UPDATE `vid_openecomp_epsdk`.`vid_service_info` SET `ACTION` = 'INSTANTIATE' where ISNULL(ACTION);
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  MODIFY `ACTION` VARCHAR(50) NOT NULL;
+
+--changeset ag137v:welcome_page_used_by_epsdk_2_5_0
+INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('welcome','menu_home');
+
+--changeset ag137v:welcome_page_used_by_epsdk_2_5_0_fn_menu
+UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `ACTION` = 'welcome' WHERE `ACTION` = 'welcome.htm';
+
+--changeset em088y:remove_all_foreign_keys_from_fn_user
+alter table `vid_openecomp_epsdk`.`fn_user`
+drop foreign key FK_FN_USER_REF_110_FN_ORG,
+drop foreign key FK_FN_USER_REF_123_FN_LU_AL,
+drop foreign key FK_FN_USER_REF_197_FN_USER,
+drop foreign key FK_FN_USER_REF_198_FN_USER,
+drop foreign key FK_FN_USER_REF_199_FN_USER,
+drop foreign key FK_TIMEZONE;
+
+--changeset em088y:add_IS_RETRY_ENABLED_to_vid_service_info
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  ADD COLUMN `IS_RETRY_ENABLED` bit(1) NOT NULL DEFAULT 0 AFTER `IS_PAUSE`;
+
+--changeset em088y:create_table_vid_job_request
+CREATE TABLE `vid_openecomp_epsdk`.`vid_job_request` (
+  `JOB_ID` CHAR(36) NOT NULL COLLATE 'utf8_bin',
+  `REQUEST` MEDIUMTEXT NOT NULL COLLATE 'utf8_bin',
+  `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (`JOB_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+--changeset cp2122:vid_resource_info
+CREATE TABLE `vid_openecomp_epsdk`.`vid_resource_info` (
+  `ROOT_JOB_ID` CHAR(36) NOT NULL COLLATE 'utf8_bin',
+  `TRACK_BY_ID` CHAR(36) NOT NULL COLLATE 'utf8_bin',
+  `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `INSTANCE_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
+  `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (`TRACK_BY_ID`),
+  INDEX `ROOT_JOB_ID_IND` (`ROOT_JOB_ID` )
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+--changeset ag137v:welcome_page_used_by_epsdk_2_5_0
+INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('welcome','menu_home');
+
+--changeset er767y:add_error_message_to_vid_resource_info
+ALTER TABLE `vid_openecomp_epsdk`.`vid_resource_info`
+  ADD COLUMN `ERROR_MESSAGE` TEXT NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `INSTANCE_ID`;
+
+--changeset em088y:drop_foreign_key_from_service_info_to_jobs
+ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
+  DROP FOREIGN KEY `FK_SERVICE_INFO_VID_JOB_ID`;
+
+--changeset em088y:add_BUILD_to_vid_job
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
+  ADD COLUMN `BUILD` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_bin';
+
+--changeset eb7504:add_category_parameter_release
+INSERT IGNORE INTO vid_category_parameter (CATEGORY_ID, NAME, ID_SUPPORTED,FAMILY) VALUES (7,'release', 0, 'TENANT_ISOLATION');
+
+--changeset ah0398:restrict_url_for_role_functions
+INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('get_role_functions','menu_admin');
+
+--changeset ah0398:restrict_all_required_urls_according_to_sdk_2_5_0
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('admin','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('addRole','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('get_role','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('profile/*','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('post_search/process','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('post_search/search','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('post_search/search','menu_profile');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('role/saveRole.htm','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('role_list/*','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('role_function_list/*','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('removeRole','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('removeRoleFunction','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('samplePage','menu_sample');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows/list','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows/addWorkflow','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows/saveCronJob','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows/editWorkflow','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows/removeWorkflow','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('workflows/removeAllWorkflows','menu_admin');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/retrieve_def_tab_wise_data/*','menu_reports');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/retrieve_form_tab_wise_data/*','menu_reports');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/retrieve_sql_tab_wise_data/*','menu_reports');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/security/*','menu_reports');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/copy_report/*','menu_reports');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/save_def_tab_data/*','menu_reports');
+INSERT IGNORE INTO fn_restricted_url  (restricted_url, function_cd) VALUES('report/wizard/retrieve_data/true','menu_reports');
+
+--changeset is9613:add_ordinal_to_vid_job_audit_status
+ALTER TABLE `vid_openecomp_epsdk`.`vid_job_audit_status`
+  ADD COLUMN `ORDINAL` INT DEFAULT 0;
+
+--changeset vid:align_changes_from_ecomp
+INSERT INTO `vid_workflow` (`WORKFLOW_DB_ID`, `WORKFLOW_APP_NAME`) VALUES (6, 'VNF Scale Out') ON DUPLICATE KEY UPDATE WORKFLOW_DB_ID=6, WORKFLOW_APP_NAME='VNF Scale Out';
+INSERT INTO `vid_workflow` (`WORKFLOW_DB_ID`, `WORKFLOW_APP_NAME`) VALUES (4, 'VNF Config Update') ON DUPLICATE KEY UPDATE WORKFLOW_DB_ID=4, WORKFLOW_APP_NAME='VNF Config Update';
+
+UPDATE `vid_openecomp_epsdk`.`fn_function` SET `type` = 'menu', `action` = '*';
+UPDATE `vid_openecomp_epsdk`.`fn_function` SET `type` = 'url' WHERE `FUNCTION_NAME`='Login';
+
+UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `LABEL`='Browse SDC Service Models' WHERE `LABEL`='Browse ASDC Service Models';
+
+INSERT INTO `fn_role` VALUES (1,'System Administrator','Y',1) ON DUPLICATE KEY UPDATE ROLE_NAME='System Administrator', ACTIVE_YN='Y', PRIORITY=1;
+INSERT INTO `fn_role` VALUES (16,'Standard User','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Standard User', ACTIVE_YN='Y', PRIORITY=5;
+INSERT INTO `fn_role` VALUES (17,'Demonstration___vFWCL','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vFWCL', ACTIVE_YN='Y', PRIORITY=5;
+INSERT INTO `fn_role` VALUES (18,'Demonstration___vFW','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vFW', ACTIVE_YN='Y', PRIORITY=5;
+INSERT INTO `fn_role` VALUES (19,'Demonstration___vCPE','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vCPE', ACTIVE_YN='Y', PRIORITY=5;
+INSERT INTO `fn_role` VALUES (20,'Demonstration___vIMS','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vIMS', ACTIVE_YN='Y', PRIORITY=5;
+INSERT INTO `fn_role` VALUES (21,'Demonstration___vLB','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vLB', ACTIVE_YN='Y', PRIORITY=5;
+INSERT INTO `fn_role` VALUES (22,'Demonstration___gNB','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___gNB', ACTIVE_YN='Y', PRIORITY=5;
+
+INSERT IGNORE `fn_user` VALUES (1,null,null,'Demo',null,'User',null,null,null,null,null,null,null,'demo',null,'demo','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
+INSERT IGNORE `fn_user` VALUES (2,null,null,'vid1',null,'User',null,null,null,null,null,null,null,'vid1',null,'vid1','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
+INSERT IGNORE `fn_user` VALUES (3,null,null,'vid2',null,'User',null,null,null,null,null,null,null,'vid2',null,'vid2','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
+INSERT IGNORE `fn_user` VALUES (4,null,null,'vid3',null,'User',null,null,null,null,null,null,null,'vid3',null,'vid3','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
+INSERT IGNORE `fn_user` VALUES (5,null,null,'vid4',null,'User',null,null,null,null,null,null,null,'vid4',null,'vid4','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
+
+INSERT IGNORE `fn_user_role` VALUES (1,1,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (2,1,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (3,1,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (4,1,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (5,1,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (1,17,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (1,18,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (1,19,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (1,20,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (1,21,NULL,1);
+INSERT IGNORE `fn_user_role` VALUES (1,22,NULL,1);
+UPDATE `fn_app` SET `APP_IMAGE_URL`=null,`APP_URL`=null,`APP_ALTERNATE_URL`=null WHERE `APP_ID`=1;