1 --liquibase formatted sql
4 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_service_info` (
5 `ID` INT(11) NOT NULL AUTO_INCREMENT,
6 `JOB_ID` BINARY(16) NOT NULL,
8 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
9 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
10 `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
11 `PAUSE` TINYINT(1) NULL,
12 `OWNING_ENTITY_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
13 `OWNING_ENTITY_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
14 `PROJECT` VARCHAR(50) NULL COLLATE 'utf8_bin',
15 `AIC_ZONE_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
16 `AIC_ZONE_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
17 `TENANT_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
18 `TENANT_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
19 `REGION_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
20 `REGION_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
21 `SERVICE_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',
22 `SUBSCRIBER_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
23 `SERVICE_INSTANCE_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
24 `SERVICE_INSTANCE_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
25 `SERVICE_MODEL_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
26 `SERVICE_MODEL_NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
27 `SERVICE_MODEL_VERSION` VARCHAR(20) NULL COLLATE 'utf8_bin',
29 CONSTRAINT `vid_service_info_vid_job_JOB_ID_fk` FOREIGN KEY (`JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
31 --rollback drop table `vid_openecomp_epsdk`.`vid_service_info`;
34 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
35 ADD COLUMN CREATED_BULK_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
36 ADD COLUMN IS_HIDDEN BIT,
37 ADD COLUMN IS_PAUSE BIT,
38 ADD COLUMN STATUS_MODIFIED_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
40 --rollback alter `vid_openecomp_epsdk`.`vid_service_info` drop CREATED_BULK_DATE, drop IS_HIDDEN, drop IS_PAUSE, drop STATUS_MODIFIED_DATE;
43 delete from `vid_openecomp_epsdk`.`vid_service_info`;
44 delete from `vid_openecomp_epsdk`.`vid_job`;
46 alter table `vid_openecomp_epsdk`.`vid_service_info` drop foreign key vid_service_info_vid_job_JOB_ID_fk;
48 alter table `vid_openecomp_epsdk`.`vid_job`
49 drop index `FK_OWNING_VID_JOB_PARENT`,
50 drop FOREIGN KEY `FK_OWNING_VID_JOB_PARENT`,
52 modify JOB_ID CHAR(36),
53 modify PARENT_JOB_ID CHAR(36),
54 add PRIMARY KEY (`JOB_ID`);
56 alter table `vid_openecomp_epsdk`.`vid_job`
57 add CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_job` (`JOB_ID`);
59 alter table `vid_openecomp_epsdk`.`vid_service_info`
60 modify JOB_ID CHAR(36),
61 add FOREIGN KEY `FK_SERVICE_INFO_VID_JOB_ID`(`JOB_ID`) REFERENCES `vid_job` (`JOB_ID`);
64 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
65 DROP FOREIGN KEY `FK_OWNING_VID_JOB_PARENT`;
67 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
68 CHANGE COLUMN `PARENT_JOB_ID` `TEMPLATE_ID` CHAR(36) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `JOB_DATA`;
71 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
72 ADD COLUMN `TEMPLATE_ID` CHAR(36) NULL DEFAULT NULL;
75 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
76 ADD COLUMN `USER_ID` VARCHAR(50) NULL COLLATE 'utf8_bin';
79 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
80 ADD COLUMN `AGE` INT NOT NULL default '0';
83 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
84 CHANGE COLUMN `USER_ID` `USER_ID` VARCHAR(50) NULL COLLATE 'utf8_bin';
87 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
88 ADD COLUMN DELETED_AT TIMESTAMP NULL DEFAULT NULL;
90 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
91 ADD COLUMN DELETED_AT TIMESTAMP NULL DEFAULT NULL;
94 UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `SORT_ORDER` = 13 where MENU_ID=110;
95 UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `SORT_ORDER` = 12 where MENU_ID=109;
96 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
97 (111, 'Macro Instantiation Status', 1, 11, 'serviceModels.htm#/instantiationStatus', 'menu_searchexisting', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-location-pin');
99 --changeset is9613:job_index_in_bulk
100 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
101 ADD COLUMN `INDEX_IN_BULK` INT NOT NULL default '0';
104 --changeset rr155:vid_job_audit_status
105 CREATE TABLE `vid_openecomp_epsdk`.`vid_job_audit_status` (
106 `ID` INT(11) NOT NULL AUTO_INCREMENT,
107 `JOB_ID` CHAR(36) NOT NULL,
108 `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
109 `SOURCE` VARCHAR(50) NULL COLLATE 'utf8_bin',
110 `REQUEST_ID` CHAR(36) NULL,
111 `ADDITIONAL_INFO` VARCHAR (255) NULL,
112 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
113 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
117 --changeset em088y:name_counter
118 CREATE TABLE `vid_openecomp_epsdk`.`vid_name_counter` (
119 `NAME` VARCHAR(100) NOT NULL COLLATE 'utf8_bin',
120 `COUNTER` INT NOT NULL,
122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
124 --changeset em088y:increase_names_maxsize_500
125 alter table `vid_openecomp_epsdk`.`vid_service_info`
126 modify `OWNING_ENTITY_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
127 modify `AIC_ZONE_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
128 modify `TENANT_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
129 modify `REGION_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
130 modify `SUBSCRIBER_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
131 modify `SERVICE_INSTANCE_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin',
132 modify `SERVICE_MODEL_NAME` VARCHAR(500) NULL COLLATE 'utf8_bin';
134 alter table `vid_openecomp_epsdk`.`vid_name_counter`
135 modify `NAME` VARCHAR(255) NOT NULL COLLATE 'utf8_bin';
137 --changeset is9613:add_SUBSCRIBER_ID_to_vid_service_info
138 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
139 ADD COLUMN `SUBSCRIBER_ID` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `SUBSCRIBER_NAME`;
141 --changeset em088y:additional_info_maxsize_2000
142 alter table `vid_openecomp_epsdk`.`vid_job_audit_status`
143 modify `ADDITIONAL_INFO` VARCHAR(2000) NULL COLLATE 'utf8_bin';
145 --changeset er767y:change_'Macro Instantiation Status'_menu_item
146 UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `LABEL` = 'Instantiation Status' WHERE `MENU_ID`=111;
148 --changeset cl0627:add_MSO_REQUEST_ID_and_IS_A_LA_CARTE_to_vid_service_info
149 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
150 ADD COLUMN `MSO_REQUEST_ID` CHAR(36) NULL AFTER `USER_ID`,
151 ADD COLUMN `IS_A_LA_CARTE` BIT NULL AFTER `MSO_REQUEST_ID`;
153 --changeset cl0627:change_IS_A_LA_CARTE_to_not_null_and_default_false
154 UPDATE `vid_openecomp_epsdk`.`vid_service_info` SET `IS_A_LA_CARTE` = 0 WHERE ISNULL(`IS_A_LA_CARTE`);
155 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
156 MODIFY `IS_A_LA_CARTE` bit(1) NOT NULL DEFAULT 0;
159 --changeset vid:add_Action_and_Type_to_fn_function
160 ALTER TABLE `vid_openecomp_epsdk`.`fn_function`
161 ADD COLUMN IF NOT EXISTS `type` VARCHAR(50) NULL AFTER `function_name`,
162 ADD COLUMN IF NOT EXISTS `action` VARCHAR(100) NULL AFTER `type`;
164 --changeset em088y:increase_ids_maxsize_500
165 alter table `vid_openecomp_epsdk`.`vid_service_info`
166 modify `USER_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
167 modify `MSO_REQUEST_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
168 modify `OWNING_ENTITY_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
169 modify `PROJECT` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
170 modify `AIC_ZONE_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
171 modify `TENANT_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
172 modify `REGION_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
173 modify `SERVICE_TYPE` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
174 modify `SUBSCRIBER_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
175 modify `SERVICE_INSTANCE_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
176 modify `SERVICE_MODEL_ID` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin',
177 modify `SERVICE_MODEL_VERSION` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_bin';
179 --changeset ah0398:restrict_url_for_role_management
180 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('get_user_roles','menu_admin');
181 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('addRoleFunction','menu_admin');
183 --changeset rs282j:add_ACTION_to_vid_service_info
184 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
185 ADD COLUMN `ACTION` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin';
187 UPDATE `vid_openecomp_epsdk`.`vid_service_info` SET `ACTION` = 'INSTANTIATE' where ISNULL(ACTION);
188 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
189 MODIFY `ACTION` VARCHAR(50) NOT NULL;
191 --changeset ag137v:welcome_page_used_by_epsdk_2_5_0
192 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('welcome','menu_home');
194 --changeset ag137v:welcome_page_used_by_epsdk_2_5_0_fn_menu
195 UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `ACTION` = 'welcome' WHERE `ACTION` = 'welcome.htm';
197 --changeset em088y:remove_all_foreign_keys_from_fn_user
198 alter table `vid_openecomp_epsdk`.`fn_user`
199 drop foreign key FK_FN_USER_REF_110_FN_ORG,
200 drop foreign key FK_FN_USER_REF_123_FN_LU_AL,
201 drop foreign key FK_FN_USER_REF_197_FN_USER,
202 drop foreign key FK_FN_USER_REF_198_FN_USER,
203 drop foreign key FK_FN_USER_REF_199_FN_USER,
204 drop foreign key FK_TIMEZONE;
206 --changeset em088y:add_IS_RETRY_ENABLED_to_vid_service_info
207 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
208 ADD COLUMN `IS_RETRY_ENABLED` bit(1) NOT NULL DEFAULT 0 AFTER `IS_PAUSE`;
210 --changeset em088y:create_table_vid_job_request
211 CREATE TABLE `vid_openecomp_epsdk`.`vid_job_request` (
212 `JOB_ID` CHAR(36) NOT NULL COLLATE 'utf8_bin',
213 `REQUEST` MEDIUMTEXT NOT NULL COLLATE 'utf8_bin',
214 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
215 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
216 PRIMARY KEY (`JOB_ID`)
217 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
219 --changeset cp2122:vid_resource_info
220 CREATE TABLE `vid_openecomp_epsdk`.`vid_resource_info` (
221 `ROOT_JOB_ID` CHAR(36) NOT NULL COLLATE 'utf8_bin',
222 `TRACK_BY_ID` CHAR(36) NOT NULL COLLATE 'utf8_bin',
223 `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
224 `INSTANCE_ID` VARCHAR(50) NULL COLLATE 'utf8_bin',
225 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
226 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
227 PRIMARY KEY (`TRACK_BY_ID`),
228 INDEX `ROOT_JOB_ID_IND` (`ROOT_JOB_ID` )
229 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
231 --changeset ag137v:welcome_page_used_by_epsdk_2_5_0
232 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES ('welcome','menu_home');
234 --changeset er767y:add_error_message_to_vid_resource_info
235 ALTER TABLE `vid_openecomp_epsdk`.`vid_resource_info`
236 ADD COLUMN `ERROR_MESSAGE` TEXT NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `INSTANCE_ID`;
238 --changeset em088y:drop_foreign_key_from_service_info_to_jobs
239 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
240 DROP FOREIGN KEY `FK_SERVICE_INFO_VID_JOB_ID`;
242 --changeset em088y:add_BUILD_to_vid_job
243 ALTER TABLE `vid_openecomp_epsdk`.`vid_job`
244 ADD COLUMN `BUILD` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_bin';
246 --changeset eb7504:add_category_parameter_release
247 INSERT IGNORE INTO vid_category_parameter (CATEGORY_ID, NAME, ID_SUPPORTED,FAMILY) VALUES (7,'release', 0, 'TENANT_ISOLATION');
249 --changeset ah0398:restrict_url_for_role_functions
250 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('get_role_functions','menu_admin');
252 --changeset ah0398:restrict_all_required_urls_according_to_sdk_2_5_0
253 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('admin','menu_admin');
254 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('addRole','menu_admin');
255 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('get_role','menu_admin');
256 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('profile/*','menu_admin');
257 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('post_search/process','menu_admin');
258 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('post_search/search','menu_admin');
259 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('post_search/search','menu_profile');
260 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('role/saveRole.htm','menu_admin');
261 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('role_list/*','menu_admin');
262 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('role_function_list/*','menu_admin');
263 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('removeRole','menu_admin');
264 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('removeRoleFunction','menu_admin');
265 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('samplePage','menu_sample');
266 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows','menu_admin');
267 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows/list','menu_admin');
268 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows/addWorkflow','menu_admin');
269 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows/saveCronJob','menu_admin');
270 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows/editWorkflow','menu_admin');
271 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows/removeWorkflow','menu_admin');
272 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('workflows/removeAllWorkflows','menu_admin');
273 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/retrieve_def_tab_wise_data/*','menu_reports');
274 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/retrieve_form_tab_wise_data/*','menu_reports');
275 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/retrieve_sql_tab_wise_data/*','menu_reports');
276 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/security/*','menu_reports');
277 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/copy_report/*','menu_reports');
278 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/save_def_tab_data/*','menu_reports');
279 INSERT IGNORE INTO fn_restricted_url (restricted_url, function_cd) VALUES('report/wizard/retrieve_data/true','menu_reports');
281 --changeset is9613:add_ordinal_to_vid_job_audit_status
282 ALTER TABLE `vid_openecomp_epsdk`.`vid_job_audit_status`
283 ADD COLUMN `ORDINAL` INT DEFAULT 0;
285 --changeset vid:align_changes_from_ecomp
286 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';
287 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';
289 UPDATE `vid_openecomp_epsdk`.`fn_function` SET `type` = 'menu', `action` = '*';
290 UPDATE `vid_openecomp_epsdk`.`fn_function` SET `type` = 'url' WHERE `FUNCTION_NAME`='Login';
292 UPDATE `vid_openecomp_epsdk`.`fn_menu` SET `LABEL`='Browse SDC Service Models' WHERE `LABEL`='Browse ASDC Service Models';
294 INSERT INTO `fn_role` VALUES (1,'System Administrator','Y',1) ON DUPLICATE KEY UPDATE ROLE_NAME='System Administrator', ACTIVE_YN='Y', PRIORITY=1;
295 INSERT INTO `fn_role` VALUES (16,'Standard User','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Standard User', ACTIVE_YN='Y', PRIORITY=5;
296 INSERT INTO `fn_role` VALUES (17,'Demonstration___vFWCL','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vFWCL', ACTIVE_YN='Y', PRIORITY=5;
297 INSERT INTO `fn_role` VALUES (18,'Demonstration___vFW','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vFW', ACTIVE_YN='Y', PRIORITY=5;
298 INSERT INTO `fn_role` VALUES (19,'Demonstration___vCPE','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vCPE', ACTIVE_YN='Y', PRIORITY=5;
299 INSERT INTO `fn_role` VALUES (20,'Demonstration___vIMS','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vIMS', ACTIVE_YN='Y', PRIORITY=5;
300 INSERT INTO `fn_role` VALUES (21,'Demonstration___vLB','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___vLB', ACTIVE_YN='Y', PRIORITY=5;
301 INSERT INTO `fn_role` VALUES (22,'Demonstration___gNB','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Demonstration___gNB', ACTIVE_YN='Y', PRIORITY=5;
303 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);
304 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);
305 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);
306 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);
307 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);
309 INSERT IGNORE `fn_user_role` VALUES (1,1,NULL,1);
310 INSERT IGNORE `fn_user_role` VALUES (2,1,NULL,1);
311 INSERT IGNORE `fn_user_role` VALUES (3,1,NULL,1);
312 INSERT IGNORE `fn_user_role` VALUES (4,1,NULL,1);
313 INSERT IGNORE `fn_user_role` VALUES (5,1,NULL,1);
314 INSERT IGNORE `fn_user_role` VALUES (1,17,NULL,1);
315 INSERT IGNORE `fn_user_role` VALUES (1,18,NULL,1);
316 INSERT IGNORE `fn_user_role` VALUES (1,19,NULL,1);
317 INSERT IGNORE `fn_user_role` VALUES (1,20,NULL,1);
318 INSERT IGNORE `fn_user_role` VALUES (1,21,NULL,1);
319 INSERT IGNORE `fn_user_role` VALUES (1,22,NULL,1);
320 UPDATE `fn_app` SET `APP_IMAGE_URL`=null,`APP_URL`=null,`APP_ALTERNATE_URL`=null WHERE `APP_ID`=1;
323 --changeset vid:service_info_request_summary
324 ALTER TABLE `vid_openecomp_epsdk`.`vid_service_info`
325 ADD COLUMN `REQUEST_SUMMARY` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_bin';
327 --changeset vid:add_workflow_pnf_software_upgrade
328 INSERT INTO `vid_workflow` (`WORKFLOW_DB_ID`, `WORKFLOW_APP_NAME`) VALUES (7, 'PNF Software Upgrade');