2 * ============LICENSE_START=======================================================
\r
4 * ================================================================================
\r
5 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
\r
6 * ================================================================================
\r
7 * Licensed under the Apache License, Version 2.0 (the "License");
\r
8 * you may not use this file except in compliance with the License.
\r
9 * You may obtain a copy of the License at
\r
11 * http://www.apache.org/licenses/LICENSE-2.0
\r
13 * Unless required by applicable law or agreed to in writing, software
\r
14 * distributed under the License is distributed on an "AS IS" BASIS,
\r
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
16 * See the License for the specific language governing permissions and
\r
17 * limitations under the License.
\r
18 * ============LICENSE_END=========================================================
\r
20 -- ----------------------------------------------------------------------------
\r
21 -- MySQL Workbench Migration
\r
22 -- Migrated Schemata: vid_openecomp_epsdk
\r
23 -- Source Schemata: ecomp_sd
\r
24 -- Created: Sun Nov 13 08:58:53 2016
\r
25 -- Workbench Version: 6.3.6
\r
26 -- ----------------------------------------------------------------------------
\r
28 SET FOREIGN_KEY_CHECKS = 0;
\r
30 -- ----------------------------------------------------------------------------
\r
31 -- Schema vid_openecomp_epsdk
\r
32 -- ----------------------------------------------------------------------------
\r
33 CREATE SCHEMA IF NOT EXISTS `vid_openecomp_epsdk` ;
\r
35 USE vid_openecomp_epsdk;
\r
36 -- ----------------------------------------------------------------------------
\r
37 -- Table vid_openecomp_epsdk.cr_favorite_reports
\r
38 -- ----------------------------------------------------------------------------
\r
39 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_favorite_reports` (
\r
40 `USER_ID` INT(11) NOT NULL,
\r
41 `REP_ID` INT(11) NOT NULL,
\r
42 PRIMARY KEY (`USER_ID`, `REP_ID`))
\r
44 DEFAULT CHARACTER SET = utf8;
\r
46 -- ----------------------------------------------------------------------------
\r
47 -- Table vid_openecomp_epsdk.cr_filehist_log
\r
48 -- ----------------------------------------------------------------------------
\r
49 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_filehist_log` (
\r
50 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
51 `URL` VARCHAR(4000) NULL DEFAULT NULL,
\r
52 `NOTES` VARCHAR(3500) NULL DEFAULT NULL,
\r
53 `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
\r
55 DEFAULT CHARACTER SET = utf8;
\r
57 -- ----------------------------------------------------------------------------
\r
58 -- Table vid_openecomp_epsdk.cr_folder
\r
59 -- ----------------------------------------------------------------------------
\r
60 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_folder` (
\r
61 `FOLDER_ID` INT(11) NOT NULL,
\r
62 `FOLDER_NAME` VARCHAR(50) NOT NULL,
\r
63 `DESCR` VARCHAR(500) NULL DEFAULT NULL,
\r
64 `CREATE_ID` INT(11) NOT NULL,
\r
65 `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
66 `PARENT_FOLDER_ID` INT(11) NULL DEFAULT NULL,
\r
67 `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
68 PRIMARY KEY (`FOLDER_ID`),
\r
69 INDEX `FK_PARENT_KEY_CR_FOLDER` (`PARENT_FOLDER_ID` ASC),
\r
70 CONSTRAINT `FK_PARENT_KEY_CR_FOLDER`
\r
71 FOREIGN KEY (`PARENT_FOLDER_ID`)
\r
72 REFERENCES `vid_openecomp_epsdk`.`cr_folder` (`FOLDER_ID`))
\r
74 DEFAULT CHARACTER SET = utf8;
\r
76 -- ----------------------------------------------------------------------------
\r
77 -- Table vid_openecomp_epsdk.cr_folder_access
\r
78 -- ----------------------------------------------------------------------------
\r
79 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_folder_access` (
\r
80 `FOLDER_ACCESS_ID` DECIMAL(11,0) NOT NULL,
\r
81 `FOLDER_ID` DECIMAL(11,0) NOT NULL,
\r
82 `ORDER_NO` DECIMAL(11,0) NOT NULL,
\r
83 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
84 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
85 `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
86 PRIMARY KEY (`FOLDER_ACCESS_ID`))
\r
88 DEFAULT CHARACTER SET = utf8;
\r
90 -- ----------------------------------------------------------------------------
\r
91 -- Table vid_openecomp_epsdk.cr_hist_user_map
\r
92 -- ----------------------------------------------------------------------------
\r
93 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_hist_user_map` (
\r
94 `HIST_ID` INT(11) NOT NULL,
\r
95 `USER_ID` INT(11) NOT NULL,
\r
96 PRIMARY KEY (`HIST_ID`, `USER_ID`),
\r
97 INDEX `SYS_C0014617` (`USER_ID` ASC),
\r
98 CONSTRAINT `SYS_C0014616`
\r
99 FOREIGN KEY (`HIST_ID`)
\r
100 REFERENCES `vid_openecomp_epsdk`.`cr_report_file_history` (`HIST_ID`),
\r
101 CONSTRAINT `SYS_C0014617`
\r
102 FOREIGN KEY (`USER_ID`)
\r
103 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
105 DEFAULT CHARACTER SET = utf8;
\r
107 -- ----------------------------------------------------------------------------
\r
108 -- Table vid_openecomp_epsdk.cr_lu_file_type
\r
109 -- ----------------------------------------------------------------------------
\r
110 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_lu_file_type` (
\r
111 `LOOKUP_ID` DECIMAL(2,0) NOT NULL,
\r
112 `LOOKUP_DESCR` VARCHAR(255) NOT NULL,
\r
113 `ACTIVE_YN` CHAR(1) NULL DEFAULT 'Y',
\r
114 `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL,
\r
115 PRIMARY KEY (`LOOKUP_ID`))
\r
117 DEFAULT CHARACTER SET = utf8;
\r
119 -- ----------------------------------------------------------------------------
\r
120 -- Table vid_openecomp_epsdk.cr_raptor_action_img
\r
121 -- ----------------------------------------------------------------------------
\r
122 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_raptor_action_img` (
\r
123 `IMAGE_ID` VARCHAR(100) NOT NULL,
\r
124 `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL,
\r
125 PRIMARY KEY (`IMAGE_ID`))
\r
127 DEFAULT CHARACTER SET = utf8;
\r
129 -- ----------------------------------------------------------------------------
\r
130 -- Table vid_openecomp_epsdk.cr_raptor_pdf_img
\r
131 -- ----------------------------------------------------------------------------
\r
132 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_raptor_pdf_img` (
\r
133 `IMAGE_ID` VARCHAR(100) NOT NULL,
\r
134 `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL,
\r
135 PRIMARY KEY (`IMAGE_ID`))
\r
137 DEFAULT CHARACTER SET = utf8;
\r
139 -- ----------------------------------------------------------------------------
\r
140 -- Table vid_openecomp_epsdk.cr_remote_schema_info
\r
141 -- ----------------------------------------------------------------------------
\r
142 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_remote_schema_info` (
\r
143 `SCHEMA_PREFIX` VARCHAR(5) NOT NULL,
\r
144 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
\r
145 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
\r
146 PRIMARY KEY (`SCHEMA_PREFIX`))
\r
148 DEFAULT CHARACTER SET = utf8;
\r
150 -- ----------------------------------------------------------------------------
\r
151 -- Table vid_openecomp_epsdk.cr_report
\r
152 -- ----------------------------------------------------------------------------
\r
153 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report` (
\r
154 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
155 `TITLE` VARCHAR(100) NOT NULL,
\r
156 `DESCR` VARCHAR(255) NULL DEFAULT NULL,
\r
157 `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
158 `REPORT_XML` TEXT NULL DEFAULT NULL,
\r
159 `CREATE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
160 `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
161 `MAINT_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
162 `MAINT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
163 `MENU_ID` VARCHAR(500) NULL DEFAULT NULL,
\r
164 `MENU_APPROVED_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
165 `OWNER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
166 `FOLDER_ID` INT(11) NULL DEFAULT '0',
\r
167 `DASHBOARD_TYPE_YN` VARCHAR(1) NULL DEFAULT 'N',
\r
168 `DASHBOARD_YN` VARCHAR(1) NULL DEFAULT 'N',
\r
169 PRIMARY KEY (`REP_ID`),
\r
170 INDEX `CR_REPORT_CREATE_IDPUBLIC_YNTITLE` (`CREATE_ID` ASC, `PUBLIC_YN` ASC, `TITLE` ASC))
\r
172 DEFAULT CHARACTER SET = utf8;
\r
174 -- ----------------------------------------------------------------------------
\r
175 -- Table vid_openecomp_epsdk.cr_report_access
\r
176 -- ----------------------------------------------------------------------------
\r
177 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_access` (
\r
178 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
179 `ORDER_NO` DECIMAL(11,0) NOT NULL,
\r
180 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
181 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
182 `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
183 PRIMARY KEY (`REP_ID`, `ORDER_NO`),
\r
184 CONSTRAINT `FK_CR_REPOR_REF_8550_CR_REPOR`
\r
185 FOREIGN KEY (`REP_ID`)
\r
186 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
188 DEFAULT CHARACTER SET = utf8;
\r
190 -- ----------------------------------------------------------------------------
\r
191 -- Table vid_openecomp_epsdk.cr_report_dwnld_log
\r
192 -- ----------------------------------------------------------------------------
\r
193 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_dwnld_log` (
\r
194 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
195 `REP_ID` INT(11) NOT NULL,
\r
196 `FILE_NAME` VARCHAR(100) NOT NULL,
\r
197 `DWNLD_START_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
198 `RECORD_READY_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
199 `FILTER_PARAMS` VARCHAR(2000) NULL DEFAULT NULL)
\r
201 DEFAULT CHARACTER SET = utf8;
\r
203 -- ----------------------------------------------------------------------------
\r
204 -- Table vid_openecomp_epsdk.cr_report_email_sent_log
\r
205 -- ----------------------------------------------------------------------------
\r
206 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_email_sent_log` (
\r
207 `LOG_ID` INT(11) NOT NULL,
\r
208 `SCHEDULE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
209 `GEN_KEY` VARCHAR(25) NOT NULL,
\r
210 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
211 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
212 `SENT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
213 `ACCESS_FLAG` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
214 `TOUCH_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
215 PRIMARY KEY (`LOG_ID`),
\r
216 INDEX `FK_CR_REPORT_REP_ID` (`REP_ID` ASC),
\r
217 CONSTRAINT `FK_CR_REPORT_REP_ID`
\r
218 FOREIGN KEY (`REP_ID`)
\r
219 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
221 DEFAULT CHARACTER SET = utf8;
\r
223 -- ----------------------------------------------------------------------------
\r
224 -- Table vid_openecomp_epsdk.cr_report_file_history
\r
225 -- ----------------------------------------------------------------------------
\r
226 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_file_history` (
\r
227 `HIST_ID` INT(11) NOT NULL,
\r
228 `SCHED_USER_ID` DECIMAL(11,0) NOT NULL,
\r
229 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
230 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
231 `REP_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
232 `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
233 `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL,
\r
234 `FILE_TYPE_ID` DECIMAL(2,0) NULL DEFAULT NULL,
\r
235 `FILE_NAME` VARCHAR(80) NULL DEFAULT NULL,
\r
236 `FILE_BLOB` BLOB NULL DEFAULT NULL,
\r
237 `FILE_SIZE` DECIMAL(11,0) NULL DEFAULT NULL,
\r
238 `RAPTOR_URL` VARCHAR(4000) NULL DEFAULT NULL,
\r
239 `ERROR_YN` CHAR(1) NULL DEFAULT 'N',
\r
240 `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL,
\r
241 `DELETED_YN` CHAR(1) NULL DEFAULT 'N',
\r
242 `DELETED_BY` DECIMAL(38,0) NULL DEFAULT NULL,
\r
243 PRIMARY KEY (`HIST_ID`),
\r
244 INDEX `SYS_C0014614` (`FILE_TYPE_ID` ASC),
\r
245 INDEX `SYS_C0014615` (`REP_ID` ASC),
\r
246 CONSTRAINT `SYS_C0014614`
\r
247 FOREIGN KEY (`FILE_TYPE_ID`)
\r
248 REFERENCES `vid_openecomp_epsdk`.`cr_lu_file_type` (`LOOKUP_ID`),
\r
249 CONSTRAINT `SYS_C0014615`
\r
250 FOREIGN KEY (`REP_ID`)
\r
251 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
253 DEFAULT CHARACTER SET = utf8;
\r
255 -- ----------------------------------------------------------------------------
\r
256 -- Table vid_openecomp_epsdk.cr_report_log
\r
257 -- ----------------------------------------------------------------------------
\r
258 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_log` (
\r
259 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
260 `LOG_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
261 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
262 `ACTION` VARCHAR(2000) NOT NULL,
\r
263 `ACTION_VALUE` VARCHAR(50) NULL DEFAULT NULL,
\r
264 `FORM_FIELDS` VARCHAR(4000) NULL DEFAULT NULL,
\r
265 INDEX `FK_CR_REPOR_REF_17645_CR_REPOR` (`REP_ID` ASC),
\r
266 CONSTRAINT `FK_CR_REPOR_REF_17645_CR_REPOR`
\r
267 FOREIGN KEY (`REP_ID`)
\r
268 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
270 DEFAULT CHARACTER SET = utf8;
\r
272 -- ----------------------------------------------------------------------------
\r
273 -- Table vid_openecomp_epsdk.cr_report_schedule
\r
274 -- ----------------------------------------------------------------------------
\r
275 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_schedule` (
\r
276 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
277 `SCHED_USER_ID` DECIMAL(11,0) NOT NULL,
\r
278 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
279 `ENABLED_YN` VARCHAR(1) NOT NULL,
\r
280 `START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
281 `END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
282 `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
283 `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL,
\r
284 `CONDITIONAL_YN` VARCHAR(1) NOT NULL,
\r
285 `CONDITION_SQL` VARCHAR(4000) NULL DEFAULT NULL,
\r
286 `NOTIFY_TYPE` INT(11) NULL DEFAULT '0',
\r
287 `MAX_ROW` INT(11) NULL DEFAULT '1000',
\r
288 `INITIAL_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
\r
289 `PROCESSED_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
\r
290 `FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
\r
291 `CONDITION_LARGE_SQL` TEXT NULL DEFAULT NULL,
\r
292 `ENCRYPT_YN` CHAR(1) NULL DEFAULT 'N',
\r
293 `ATTACHMENT_YN` CHAR(1) NULL DEFAULT 'Y',
\r
294 PRIMARY KEY (`SCHEDULE_ID`),
\r
295 INDEX `FK_CR_REPOR_REF_14707_CR_REPOR` (`REP_ID` ASC),
\r
296 CONSTRAINT `FK_CR_REPOR_REF_14707_CR_REPOR`
\r
297 FOREIGN KEY (`REP_ID`)
\r
298 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
300 DEFAULT CHARACTER SET = utf8;
\r
302 -- ----------------------------------------------------------------------------
\r
303 -- Table vid_openecomp_epsdk.cr_report_schedule_users
\r
304 -- ----------------------------------------------------------------------------
\r
305 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_schedule_users` (
\r
306 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
307 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
308 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
309 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
310 `ORDER_NO` DECIMAL(11,0) NOT NULL,
\r
311 PRIMARY KEY (`SCHEDULE_ID`, `REP_ID`, `USER_ID`, `ORDER_NO`),
\r
312 CONSTRAINT `FK_CR_REPOR_REF_14716_CR_REPOR`
\r
313 FOREIGN KEY (`SCHEDULE_ID`)
\r
314 REFERENCES `vid_openecomp_epsdk`.`cr_report_schedule` (`SCHEDULE_ID`))
\r
316 DEFAULT CHARACTER SET = utf8;
\r
318 -- ----------------------------------------------------------------------------
\r
319 -- Table vid_openecomp_epsdk.cr_report_template_map
\r
320 -- ----------------------------------------------------------------------------
\r
321 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_template_map` (
\r
322 `REPORT_ID` INT(11) NOT NULL,
\r
323 `TEMPLATE_FILE` VARCHAR(200) NULL DEFAULT NULL,
\r
324 PRIMARY KEY (`REPORT_ID`))
\r
326 DEFAULT CHARACTER SET = utf8;
\r
328 -- ----------------------------------------------------------------------------
\r
329 -- Table vid_openecomp_epsdk.cr_schedule_activity_log
\r
330 -- ----------------------------------------------------------------------------
\r
331 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_schedule_activity_log` (
\r
332 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
333 `URL` VARCHAR(4000) NULL DEFAULT NULL,
\r
334 `NOTES` VARCHAR(2000) NULL DEFAULT NULL,
\r
335 `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
\r
337 DEFAULT CHARACTER SET = utf8;
\r
339 -- ----------------------------------------------------------------------------
\r
340 -- Table vid_openecomp_epsdk.cr_table_join
\r
341 -- ----------------------------------------------------------------------------
\r
342 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_table_join` (
\r
343 `SRC_TABLE_NAME` VARCHAR(30) NOT NULL,
\r
344 `DEST_TABLE_NAME` VARCHAR(30) NOT NULL,
\r
345 `JOIN_EXPR` VARCHAR(500) NOT NULL,
\r
346 INDEX `CR_TABLE_JOIN_DEST_TABLE_NAME` (`DEST_TABLE_NAME` ASC),
\r
347 INDEX `CR_TABLE_JOIN_SRC_TABLE_NAME` (`SRC_TABLE_NAME` ASC),
\r
348 CONSTRAINT `FK_CR_TABLE_REF_311_CR_TAB`
\r
349 FOREIGN KEY (`SRC_TABLE_NAME`)
\r
350 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`),
\r
351 CONSTRAINT `FK_CR_TABLE_REF_315_CR_TAB`
\r
352 FOREIGN KEY (`DEST_TABLE_NAME`)
\r
353 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`))
\r
355 DEFAULT CHARACTER SET = utf8;
\r
357 -- ----------------------------------------------------------------------------
\r
358 -- Table vid_openecomp_epsdk.cr_table_role
\r
359 -- ----------------------------------------------------------------------------
\r
360 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_table_role` (
\r
361 `TABLE_NAME` VARCHAR(30) NOT NULL,
\r
362 `ROLE_ID` DECIMAL(11,0) NOT NULL,
\r
363 PRIMARY KEY (`TABLE_NAME`, `ROLE_ID`),
\r
364 CONSTRAINT `FK_CR_TABLE_REF_32384_CR_TABLE`
\r
365 FOREIGN KEY (`TABLE_NAME`)
\r
366 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`))
\r
368 DEFAULT CHARACTER SET = utf8;
\r
370 -- ----------------------------------------------------------------------------
\r
371 -- Table vid_openecomp_epsdk.cr_table_source
\r
372 -- ----------------------------------------------------------------------------
\r
373 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_table_source` (
\r
374 `TABLE_NAME` VARCHAR(30) NOT NULL,
\r
375 `DISPLAY_NAME` VARCHAR(30) NOT NULL,
\r
376 `PK_FIELDS` VARCHAR(200) NULL DEFAULT NULL,
\r
377 `WEB_VIEW_ACTION` VARCHAR(50) NULL DEFAULT NULL,
\r
378 `LARGE_DATA_SOURCE_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
379 `FILTER_SQL` VARCHAR(4000) NULL DEFAULT NULL,
\r
380 `SOURCE_DB` VARCHAR(50) NULL DEFAULT NULL,
\r
381 PRIMARY KEY (`TABLE_NAME`))
\r
383 DEFAULT CHARACTER SET = utf8;
\r
385 -- ----------------------------------------------------------------------------
\r
386 -- Table vid_portal.fn_app
\r
387 -- ----------------------------------------------------------------------------
\r
388 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_app` (
\r
389 `APP_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
390 `APP_NAME` VARCHAR(100) NOT NULL DEFAULT '?',
\r
391 `APP_IMAGE_URL` VARCHAR(256) NULL DEFAULT NULL,
\r
392 `APP_DESCRIPTION` VARCHAR(512) NULL DEFAULT NULL,
\r
393 `APP_NOTES` VARCHAR(4096) NULL DEFAULT NULL,
\r
394 `APP_URL` VARCHAR(256) NULL DEFAULT NULL,
\r
395 `APP_ALTERNATE_URL` VARCHAR(256) NULL DEFAULT NULL,
\r
396 `APP_REST_ENDPOINT` VARCHAR(2000) NULL DEFAULT NULL,
\r
397 `ML_APP_NAME` VARCHAR(50) NOT NULL DEFAULT '?',
\r
398 `ML_APP_ADMIN_ID` VARCHAR(7) NOT NULL DEFAULT '?',
\r
399 `MOTS_ID` INT(11) NULL DEFAULT NULL,
\r
400 `APP_PASSWORD` VARCHAR(256) NOT NULL DEFAULT '?',
\r
401 `OPEN` CHAR(1) NULL DEFAULT 'N',
\r
402 `ENABLED` CHAR(1) NULL DEFAULT 'Y',
\r
403 `THUMBNAIL` MEDIUMBLOB NULL DEFAULT NULL,
\r
404 `APP_USERNAME` VARCHAR(50) NULL DEFAULT NULL,
\r
405 `UEB_KEY` VARCHAR(256) NULL DEFAULT NULL,
\r
406 `UEB_SECRET` VARCHAR(256) NULL DEFAULT NULL,
\r
407 `UEB_TOPIC_NAME` VARCHAR(256) NULL DEFAULT NULL,
\r
408 PRIMARY KEY (`APP_ID`))
\r
411 DEFAULT CHARACTER SET = utf8;
\r
413 -- ----------------------------------------------------------------------------
\r
414 -- Table vid_openecomp_epsdk.fn_app_mme_cpu
\r
415 -- ----------------------------------------------------------------------------
\r
416 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_app_mme_cpu` (
\r
417 `MME` VARCHAR(200) NULL DEFAULT NULL,
\r
418 `YEARMONTH` INT(11) NULL DEFAULT NULL,
\r
419 `SCTP_CPU` INT(11) NULL DEFAULT NULL,
\r
420 `AP_CPU` INT(11) NULL DEFAULT NULL,
\r
421 `DP_CPU` INT(11) NULL DEFAULT NULL,
\r
422 `ROUTER_CPU` INT(11) NULL DEFAULT NULL,
\r
423 `PEB_CPU` INT(11) NULL DEFAULT NULL,
\r
424 `SAU` INT(11) NULL DEFAULT NULL)
\r
426 DEFAULT CHARACTER SET = utf8;
\r
428 -- ----------------------------------------------------------------------------
\r
429 -- Table vid_openecomp_epsdk.fn_audit_action
\r
430 -- ----------------------------------------------------------------------------
\r
431 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_action` (
\r
432 `AUDIT_ACTION_ID` INT(11) NOT NULL,
\r
433 `CLASS_NAME` VARCHAR(500) NOT NULL,
\r
434 `METHOD_NAME` VARCHAR(50) NOT NULL,
\r
435 `AUDIT_ACTION_CD` VARCHAR(20) NOT NULL,
\r
436 `AUDIT_ACTION_DESC` VARCHAR(200) NULL DEFAULT NULL,
\r
437 `ACTIVE_YN` VARCHAR(1) NULL DEFAULT NULL,
\r
438 PRIMARY KEY (`AUDIT_ACTION_ID`))
\r
440 DEFAULT CHARACTER SET = utf8;
\r
442 -- ----------------------------------------------------------------------------
\r
443 -- Table vid_openecomp_epsdk.fn_audit_action_log
\r
444 -- ----------------------------------------------------------------------------
\r
445 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_action_log` (
\r
446 `AUDIT_LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
447 `AUDIT_ACTION_CD` VARCHAR(200) NULL DEFAULT NULL,
\r
448 `ACTION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
449 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
450 `CLASS_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
451 `METHOD_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
452 `SUCCESS_MSG` VARCHAR(20) NULL DEFAULT NULL,
\r
453 `ERROR_MSG` VARCHAR(500) NULL DEFAULT NULL,
\r
454 PRIMARY KEY (`AUDIT_LOG_ID`))
\r
456 DEFAULT CHARACTER SET = utf8;
\r
458 -- ----------------------------------------------------------------------------
\r
459 -- Table vid_openecomp_epsdk.fn_audit_log
\r
460 -- ----------------------------------------------------------------------------
\r
461 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_log` (
\r
462 `LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
463 `USER_ID` INT(11) NOT NULL,
\r
464 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
\r
465 `AUDIT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
466 `COMMENTS` VARCHAR(1000) NULL DEFAULT NULL,
\r
467 `AFFECTED_RECORD_ID_BK` VARCHAR(500) NULL DEFAULT NULL,
\r
468 `AFFECTED_RECORD_ID` VARCHAR(4000) NULL DEFAULT NULL,
\r
469 PRIMARY KEY (`LOG_ID`),
\r
470 INDEX `FN_AUDIT_LOG_ACTIVITY_CD` (`ACTIVITY_CD` ASC),
\r
471 INDEX `FN_AUDIT_LOG_USER_ID` (`USER_ID` ASC),
\r
472 CONSTRAINT `FK_FN_AUDIT_REF_205_FN_LU_AC`
\r
473 FOREIGN KEY (`ACTIVITY_CD`)
\r
474 REFERENCES `vid_openecomp_epsdk`.`fn_lu_activity` (`ACTIVITY_CD`),
\r
475 CONSTRAINT `FK_FN_AUDIT_REF_209_FN_USER`
\r
476 FOREIGN KEY (`USER_ID`)
\r
477 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
479 DEFAULT CHARACTER SET = utf8;
\r
481 -- ----------------------------------------------------------------------------
\r
482 -- Table vid_openecomp_epsdk.fn_broadcast_message
\r
483 -- ----------------------------------------------------------------------------
\r
484 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_broadcast_message` (
\r
485 `MESSAGE_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
486 `MESSAGE_TEXT` VARCHAR(1000) NOT NULL,
\r
487 `MESSAGE_LOCATION_ID` DECIMAL(11,0) NOT NULL,
\r
488 `BROADCAST_START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
489 `BROADCAST_END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
490 `ACTIVE_YN` CHAR(1) NOT NULL DEFAULT 'Y',
\r
491 `SORT_ORDER` DECIMAL(4,0) NOT NULL,
\r
492 `BROADCAST_SITE_CD` VARCHAR(50) NULL DEFAULT NULL,
\r
493 PRIMARY KEY (`MESSAGE_ID`))
\r
495 DEFAULT CHARACTER SET = utf8;
\r
497 -- ----------------------------------------------------------------------------
\r
498 -- Table vid_openecomp_epsdk.fn_chat_logs
\r
499 -- ----------------------------------------------------------------------------
\r
500 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_logs` (
\r
501 `CHAT_LOG_ID` INT(11) NOT NULL,
\r
502 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
\r
503 `USER_ID` INT(11) NULL DEFAULT NULL,
\r
504 `MESSAGE` VARCHAR(1000) NULL DEFAULT NULL,
\r
505 `MESSAGE_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
506 PRIMARY KEY (`CHAT_LOG_ID`))
\r
508 DEFAULT CHARACTER SET = utf8;
\r
510 -- ----------------------------------------------------------------------------
\r
511 -- Table vid_openecomp_epsdk.fn_chat_room
\r
512 -- ----------------------------------------------------------------------------
\r
513 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_room` (
\r
514 `CHAT_ROOM_ID` INT(11) NOT NULL,
\r
515 `NAME` VARCHAR(50) NOT NULL,
\r
516 `DESCRIPTION` VARCHAR(500) NULL DEFAULT NULL,
\r
517 `OWNER_ID` INT(11) NULL DEFAULT NULL,
\r
518 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
519 `UPDATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
520 PRIMARY KEY (`CHAT_ROOM_ID`))
\r
522 DEFAULT CHARACTER SET = utf8;
\r
524 -- ----------------------------------------------------------------------------
\r
525 -- Table vid_openecomp_epsdk.fn_chat_users
\r
526 -- ----------------------------------------------------------------------------
\r
527 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_users` (
\r
528 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
\r
529 `USER_ID` INT(11) NULL DEFAULT NULL,
\r
530 `LAST_ACTIVITY_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
531 `CHAT_STATUS` VARCHAR(20) NULL DEFAULT NULL,
\r
532 `ID` INT(11) NOT NULL,
\r
533 PRIMARY KEY (`ID`))
\r
535 DEFAULT CHARACTER SET = utf8;
\r
537 -- ----------------------------------------------------------------------------
\r
538 -- Table vid_openecomp_epsdk.fn_datasource
\r
539 -- ----------------------------------------------------------------------------
\r
540 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_datasource` (
\r
541 `ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
542 `NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
543 `DRIVER_NAME` VARCHAR(256) NULL DEFAULT NULL,
\r
544 `SERVER` VARCHAR(256) NULL DEFAULT NULL,
\r
545 `PORT` INT(11) NULL DEFAULT NULL,
\r
546 `USER_NAME` VARCHAR(256) NULL DEFAULT NULL,
\r
547 `PASSWORD` VARCHAR(256) NULL DEFAULT NULL,
\r
548 `URL` VARCHAR(256) NULL DEFAULT NULL,
\r
549 `MIN_POOL_SIZE` INT(11) NULL DEFAULT NULL,
\r
550 `MAX_POOL_SIZE` INT(11) NULL DEFAULT NULL,
\r
551 `ADAPTER_ID` INT(11) NULL DEFAULT NULL,
\r
552 `DS_TYPE` VARCHAR(20) NULL DEFAULT NULL,
\r
553 PRIMARY KEY (`ID`))
\r
556 DEFAULT CHARACTER SET = utf8;
\r
558 -- ----------------------------------------------------------------------------
\r
559 -- Table vid_openecomp_epsdk.fn_function
\r
560 -- ----------------------------------------------------------------------------
\r
561 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_function` (
\r
562 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
563 `FUNCTION_NAME` VARCHAR(50) NOT NULL,
\r
564 PRIMARY KEY (`FUNCTION_CD`))
\r
566 DEFAULT CHARACTER SET = utf8;
\r
568 -- ----------------------------------------------------------------------------
\r
569 -- Table vid_openecomp_epsdk.fn_license
\r
570 -- ----------------------------------------------------------------------------
\r
571 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license` (
\r
572 `id` DECIMAL(11,0) NOT NULL,
\r
573 `app_id` DECIMAL(11,0) NOT NULL,
\r
574 `ip_address` VARCHAR(100) NOT NULL,
\r
575 `quantum_version_id` DECIMAL(11,0) NOT NULL,
\r
576 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
577 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
578 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
579 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
580 `end_date` TIMESTAMP NOT NULL DEFAULT '2036-01-19 03:14:07',
\r
581 PRIMARY KEY (`id`),
\r
582 INDEX `fn_license_r02` (`quantum_version_id` ASC),
\r
583 CONSTRAINT `fn_license_r02`
\r
584 FOREIGN KEY (`quantum_version_id`)
\r
585 REFERENCES `vid_openecomp_epsdk`.`fn_license_version` (`id`))
\r
587 DEFAULT CHARACTER SET = utf8;
\r
589 -- ----------------------------------------------------------------------------
\r
590 -- Table vid_openecomp_epsdk.fn_license_app
\r
591 -- ----------------------------------------------------------------------------
\r
592 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_app` (
\r
593 `id` DECIMAL(11,0) NOT NULL,
\r
594 `app_name` VARCHAR(100) NOT NULL,
\r
595 `ctxt_name` VARCHAR(100) NULL DEFAULT NULL,
\r
596 INDEX `fn_license_app_ID` (`id` ASC))
\r
598 DEFAULT CHARACTER SET = utf8;
\r
600 -- ----------------------------------------------------------------------------
\r
601 -- Table vid_openecomp_epsdk.fn_license_contact
\r
602 -- ----------------------------------------------------------------------------
\r
603 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_contact` (
\r
604 `id` INT(11) NOT NULL,
\r
605 `license_id` INT(11) NULL DEFAULT NULL,
\r
606 `sbcid` VARCHAR(20) NULL DEFAULT NULL,
\r
607 PRIMARY KEY (`id`))
\r
609 DEFAULT CHARACTER SET = utf8;
\r
611 -- ----------------------------------------------------------------------------
\r
612 -- Table vid_openecomp_epsdk.fn_license_history
\r
613 -- ----------------------------------------------------------------------------
\r
614 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_history` (
\r
615 `license_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
616 `app_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
617 `ip_address` VARCHAR(100) NULL DEFAULT NULL,
\r
618 `quantum_version_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
619 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
620 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
621 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
622 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
623 `id` DECIMAL(11,0) NOT NULL,
\r
624 PRIMARY KEY (`id`))
\r
626 DEFAULT CHARACTER SET = utf8;
\r
628 -- ----------------------------------------------------------------------------
\r
629 -- Table vid_openecomp_epsdk.fn_license_version
\r
630 -- ----------------------------------------------------------------------------
\r
631 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_version` (
\r
632 `id` DECIMAL(11,0) NOT NULL,
\r
633 `quantum_version` VARCHAR(25) NULL DEFAULT NULL,
\r
634 PRIMARY KEY (`id`))
\r
636 DEFAULT CHARACTER SET = utf8;
\r
638 -- ----------------------------------------------------------------------------
\r
639 -- Table vid_openecomp_epsdk.fn_lu_activity
\r
640 -- ----------------------------------------------------------------------------
\r
641 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_activity` (
\r
642 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
\r
643 `ACTIVITY` VARCHAR(50) NOT NULL,
\r
644 PRIMARY KEY (`ACTIVITY_CD`))
\r
646 DEFAULT CHARACTER SET = utf8;
\r
648 -- ----------------------------------------------------------------------------
\r
649 -- Table vid_openecomp_epsdk.fn_lu_alert_method
\r
650 -- ----------------------------------------------------------------------------
\r
651 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_alert_method` (
\r
652 `ALERT_METHOD_CD` VARCHAR(10) NOT NULL,
\r
653 `ALERT_METHOD` VARCHAR(50) NOT NULL,
\r
654 PRIMARY KEY (`ALERT_METHOD_CD`))
\r
656 DEFAULT CHARACTER SET = utf8;
\r
658 -- ----------------------------------------------------------------------------
\r
659 -- Table vid_openecomp_epsdk.fn_lu_broadcast_site
\r
660 -- ----------------------------------------------------------------------------
\r
661 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_broadcast_site` (
\r
662 `BROADCAST_SITE_CD` VARCHAR(50) NOT NULL,
\r
663 `BROADCAST_SITE_DESCR` VARCHAR(100) NULL DEFAULT NULL,
\r
664 PRIMARY KEY (`BROADCAST_SITE_CD`))
\r
666 DEFAULT CHARACTER SET = utf8;
\r
668 -- ----------------------------------------------------------------------------
\r
669 -- Table vid_openecomp_epsdk.fn_lu_call_times
\r
670 -- ----------------------------------------------------------------------------
\r
671 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_call_times` (
\r
672 `CALL_TIME_ID` DECIMAL(10,0) NOT NULL,
\r
673 `CALL_TIME_AMOUNT` DECIMAL(10,0) NOT NULL,
\r
674 `CALL_TIME_DISPLAY` VARCHAR(50) NOT NULL,
\r
675 PRIMARY KEY (`CALL_TIME_ID`))
\r
677 DEFAULT CHARACTER SET = utf8;
\r
679 -- ----------------------------------------------------------------------------
\r
680 -- Table vid_openecomp_epsdk.fn_lu_city
\r
681 -- ----------------------------------------------------------------------------
\r
682 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_city` (
\r
683 `CITY_CD` VARCHAR(2) NOT NULL,
\r
684 `CITY` VARCHAR(100) NOT NULL,
\r
685 `STATE_CD` VARCHAR(2) NOT NULL,
\r
686 PRIMARY KEY (`CITY_CD`, `STATE_CD`))
\r
688 DEFAULT CHARACTER SET = utf8;
\r
690 -- ----------------------------------------------------------------------------
\r
691 -- Table vid_openecomp_epsdk.fn_lu_country
\r
692 -- ----------------------------------------------------------------------------
\r
693 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_country` (
\r
694 `COUNTRY_CD` VARCHAR(3) NOT NULL,
\r
695 `COUNTRY` VARCHAR(100) NOT NULL,
\r
696 `FULL_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
697 `WEBPHONE_COUNTRY_LABEL` VARCHAR(30) NULL DEFAULT NULL,
\r
698 PRIMARY KEY (`COUNTRY_CD`))
\r
700 DEFAULT CHARACTER SET = utf8;
\r
702 -- ----------------------------------------------------------------------------
\r
703 -- Table vid_openecomp_epsdk.fn_lu_menu_set
\r
704 -- ----------------------------------------------------------------------------
\r
705 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_menu_set` (
\r
706 `MENU_SET_CD` VARCHAR(10) NOT NULL,
\r
707 `MENU_SET_NAME` VARCHAR(50) NOT NULL,
\r
708 PRIMARY KEY (`MENU_SET_CD`))
\r
710 DEFAULT CHARACTER SET = utf8;
\r
712 -- ----------------------------------------------------------------------------
\r
713 -- Table vid_openecomp_epsdk.fn_lu_priority
\r
714 -- ----------------------------------------------------------------------------
\r
715 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_priority` (
\r
716 `PRIORITY_ID` DECIMAL(11,0) NOT NULL,
\r
717 `PRIORITY` VARCHAR(50) NOT NULL,
\r
718 `ACTIVE_YN` CHAR(1) NOT NULL,
\r
719 `SORT_ORDER` DECIMAL(5,0) NULL DEFAULT NULL,
\r
720 PRIMARY KEY (`PRIORITY_ID`))
\r
722 DEFAULT CHARACTER SET = utf8;
\r
724 -- ----------------------------------------------------------------------------
\r
725 -- Table vid_openecomp_epsdk.fn_lu_role_type
\r
726 -- ----------------------------------------------------------------------------
\r
727 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_role_type` (
\r
728 `ROLE_TYPE_ID` DECIMAL(11,0) NOT NULL,
\r
729 `ROLE_TYPE` VARCHAR(50) NOT NULL,
\r
730 PRIMARY KEY (`ROLE_TYPE_ID`))
\r
732 DEFAULT CHARACTER SET = utf8;
\r
734 -- ----------------------------------------------------------------------------
\r
735 -- Table vid_openecomp_epsdk.fn_lu_state
\r
736 -- ----------------------------------------------------------------------------
\r
737 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_state` (
\r
738 `STATE_CD` VARCHAR(2) NOT NULL,
\r
739 `STATE` VARCHAR(100) NOT NULL,
\r
740 PRIMARY KEY (`STATE_CD`))
\r
742 DEFAULT CHARACTER SET = utf8;
\r
744 -- ----------------------------------------------------------------------------
\r
745 -- Table vid_openecomp_epsdk.fn_lu_tab_set
\r
746 -- ----------------------------------------------------------------------------
\r
747 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_tab_set` (
\r
748 `TAB_SET_CD` VARCHAR(30) NOT NULL,
\r
749 `TAB_SET_NAME` VARCHAR(50) NOT NULL,
\r
750 PRIMARY KEY (`TAB_SET_CD`))
\r
752 DEFAULT CHARACTER SET = utf8;
\r
754 -- ----------------------------------------------------------------------------
\r
755 -- Table vid_openecomp_epsdk.fn_lu_timezone
\r
756 -- ----------------------------------------------------------------------------
\r
757 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_timezone` (
\r
758 `TIMEZONE_ID` INT(11) NOT NULL,
\r
759 `TIMEZONE_NAME` VARCHAR(100) NOT NULL,
\r
760 `TIMEZONE_VALUE` VARCHAR(100) NOT NULL,
\r
761 PRIMARY KEY (`TIMEZONE_ID`))
\r
763 DEFAULT CHARACTER SET = utf8;
\r
765 -- ----------------------------------------------------------------------------
\r
766 -- Table vid_openecomp_epsdk.fn_menu
\r
767 -- ----------------------------------------------------------------------------
\r
768 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_menu` (
\r
769 `MENU_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
770 `LABEL` VARCHAR(100) NULL DEFAULT NULL,
\r
771 `PARENT_ID` INT(11) NULL DEFAULT NULL,
\r
772 `SORT_ORDER` DECIMAL(4,0) NULL DEFAULT NULL,
\r
773 `ACTION` VARCHAR(200) NULL DEFAULT NULL,
\r
774 `FUNCTION_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
775 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
776 `SERVLET` VARCHAR(50) NULL DEFAULT NULL,
\r
777 `QUERY_STRING` VARCHAR(200) NULL DEFAULT NULL,
\r
778 `EXTERNAL_URL` VARCHAR(200) NULL DEFAULT NULL,
\r
779 `TARGET` VARCHAR(25) NULL DEFAULT NULL,
\r
780 `MENU_SET_CD` VARCHAR(10) NULL DEFAULT 'APP',
\r
781 `SEPARATOR_YN` CHAR(1) NULL DEFAULT 'N',
\r
782 `IMAGE_SRC` VARCHAR(100) NULL DEFAULT NULL,
\r
783 PRIMARY KEY (`MENU_ID`),
\r
784 INDEX `FK_FN_MENU_REF_196_FN_MENU` (`PARENT_ID` ASC),
\r
785 INDEX `FK_FN_MENU_MENU_SET_CD` (`MENU_SET_CD` ASC),
\r
786 INDEX `FN_MENU_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
787 CONSTRAINT `FK_FN_MENU_MENU_SET_CD`
\r
788 FOREIGN KEY (`MENU_SET_CD`)
\r
789 REFERENCES `vid_openecomp_epsdk`.`fn_lu_menu_set` (`MENU_SET_CD`),
\r
790 CONSTRAINT `FK_FN_MENU_REF_196_FN_MENU`
\r
791 FOREIGN KEY (`PARENT_ID`)
\r
792 REFERENCES `vid_openecomp_epsdk`.`fn_menu` (`MENU_ID`),
\r
793 CONSTRAINT `FK_FN_MENU_REF_223_FN_FUNCT`
\r
794 FOREIGN KEY (`FUNCTION_CD`)
\r
795 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
797 AUTO_INCREMENT = 150029
\r
798 DEFAULT CHARACTER SET = utf8;
\r
800 -- ----------------------------------------------------------------------------
\r
801 -- Table vid_openecomp_epsdk.fn_org
\r
802 -- ----------------------------------------------------------------------------
\r
803 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_org` (
\r
804 `ORG_ID` INT(11) NOT NULL,
\r
805 `ORG_NAME` VARCHAR(50) NOT NULL,
\r
806 `ACCESS_CD` VARCHAR(10) NULL DEFAULT NULL,
\r
807 PRIMARY KEY (`ORG_ID`),
\r
808 INDEX `FN_ORG_ACCESS_CD` (`ACCESS_CD` ASC))
\r
810 DEFAULT CHARACTER SET = utf8;
\r
812 -- ----------------------------------------------------------------------------
\r
813 -- Table vid_openecomp_epsdk.fn_qz_blob_triggers
\r
814 -- ----------------------------------------------------------------------------
\r
815 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_blob_triggers` (
\r
816 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
817 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
818 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
819 `BLOB_DATA` BLOB NULL DEFAULT NULL,
\r
820 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
821 INDEX `SCHED_NAME` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
822 CONSTRAINT `fn_qz_blob_triggers_ibfk_1`
\r
823 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
824 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
826 DEFAULT CHARACTER SET = utf8;
\r
828 -- ----------------------------------------------------------------------------
\r
829 -- Table vid_openecomp_epsdk.fn_qz_calendars
\r
830 -- ----------------------------------------------------------------------------
\r
831 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_calendars` (
\r
832 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
833 `CALENDAR_NAME` VARCHAR(200) NOT NULL,
\r
834 `CALENDAR` BLOB NOT NULL,
\r
835 PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`))
\r
837 DEFAULT CHARACTER SET = utf8;
\r
839 -- ----------------------------------------------------------------------------
\r
840 -- Table vid_openecomp_epsdk.fn_qz_cron_triggers
\r
841 -- ----------------------------------------------------------------------------
\r
842 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_cron_triggers` (
\r
843 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
844 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
845 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
846 `CRON_EXPRESSION` VARCHAR(120) NOT NULL,
\r
847 `TIME_ZONE_ID` VARCHAR(80) NULL DEFAULT NULL,
\r
848 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
849 CONSTRAINT `fn_qz_cron_triggers_ibfk_1`
\r
850 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
851 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
853 DEFAULT CHARACTER SET = utf8;
\r
855 -- ----------------------------------------------------------------------------
\r
856 -- Table vid_openecomp_epsdk.fn_qz_fired_triggers
\r
857 -- ----------------------------------------------------------------------------
\r
858 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_fired_triggers` (
\r
859 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
860 `ENTRY_ID` VARCHAR(95) NOT NULL,
\r
861 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
862 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
863 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
\r
864 `FIRED_TIME` BIGINT(13) NOT NULL,
\r
865 `SCHED_TIME` BIGINT(13) NOT NULL,
\r
866 `PRIORITY` INT(11) NOT NULL,
\r
867 `STATE` VARCHAR(16) NOT NULL,
\r
868 `JOB_NAME` VARCHAR(200) NULL DEFAULT NULL,
\r
869 `JOB_GROUP` VARCHAR(200) NULL DEFAULT NULL,
\r
870 `IS_NONCONCURRENT` VARCHAR(1) NULL DEFAULT NULL,
\r
871 `REQUESTS_RECOVERY` VARCHAR(1) NULL DEFAULT NULL,
\r
872 PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`),
\r
873 INDEX `IDX_FN_QZ_FT_TRIG_INST_NAME` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC),
\r
874 INDEX `IDX_FN_QZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC),
\r
875 INDEX `IDX_FN_QZ_FT_J_G` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
\r
876 INDEX `IDX_FN_QZ_FT_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
\r
877 INDEX `IDX_FN_QZ_FT_T_G` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
878 INDEX `IDX_FN_QZ_FT_TG` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC))
\r
880 DEFAULT CHARACTER SET = utf8;
\r
882 -- ----------------------------------------------------------------------------
\r
883 -- Table vid_openecomp_epsdk.fn_qz_job_details
\r
884 -- ----------------------------------------------------------------------------
\r
885 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_job_details` (
\r
886 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
887 `JOB_NAME` VARCHAR(200) NOT NULL,
\r
888 `JOB_GROUP` VARCHAR(200) NOT NULL,
\r
889 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
\r
890 `JOB_CLASS_NAME` VARCHAR(250) NOT NULL,
\r
891 `IS_DURABLE` VARCHAR(1) NOT NULL,
\r
892 `IS_NONCONCURRENT` VARCHAR(1) NOT NULL,
\r
893 `IS_UPDATE_DATA` VARCHAR(1) NOT NULL,
\r
894 `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL,
\r
895 `JOB_DATA` BLOB NULL DEFAULT NULL,
\r
896 PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`),
\r
897 INDEX `IDX_FN_QZ_J_REQ_RECOVERY` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC),
\r
898 INDEX `IDX_FN_QZ_J_GRP` (`SCHED_NAME` ASC, `JOB_GROUP` ASC))
\r
900 DEFAULT CHARACTER SET = utf8;
\r
902 -- ----------------------------------------------------------------------------
\r
903 -- Table vid_openecomp_epsdk.fn_qz_locks
\r
904 -- ----------------------------------------------------------------------------
\r
905 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_locks` (
\r
906 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
907 `LOCK_NAME` VARCHAR(40) NOT NULL,
\r
908 PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`))
\r
910 DEFAULT CHARACTER SET = utf8;
\r
912 -- ----------------------------------------------------------------------------
\r
913 -- Table vid_openecomp_epsdk.fn_qz_paused_trigger_grps
\r
914 -- ----------------------------------------------------------------------------
\r
915 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_paused_trigger_grps` (
\r
916 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
917 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
918 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`))
\r
920 DEFAULT CHARACTER SET = utf8;
\r
922 -- ----------------------------------------------------------------------------
\r
923 -- Table vid_openecomp_epsdk.fn_qz_scheduler_state
\r
924 -- ----------------------------------------------------------------------------
\r
925 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_scheduler_state` (
\r
926 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
927 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
\r
928 `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL,
\r
929 `CHECKIN_INTERVAL` BIGINT(13) NOT NULL,
\r
930 PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`))
\r
932 DEFAULT CHARACTER SET = utf8;
\r
934 -- ----------------------------------------------------------------------------
\r
935 -- Table vid_openecomp_epsdk.fn_qz_simple_triggers
\r
936 -- ----------------------------------------------------------------------------
\r
937 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simple_triggers` (
\r
938 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
939 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
940 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
941 `REPEAT_COUNT` BIGINT(7) NOT NULL,
\r
942 `REPEAT_INTERVAL` BIGINT(12) NOT NULL,
\r
943 `TIMES_TRIGGERED` BIGINT(10) NOT NULL,
\r
944 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
945 CONSTRAINT `fn_qz_simple_triggers_ibfk_1`
\r
946 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
947 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
949 DEFAULT CHARACTER SET = utf8;
\r
951 -- ----------------------------------------------------------------------------
\r
952 -- Table vid_openecomp_epsdk.fn_qz_simprop_triggers
\r
953 -- ----------------------------------------------------------------------------
\r
954 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simprop_triggers` (
\r
955 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
956 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
957 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
958 `STR_PROP_1` VARCHAR(512) NULL DEFAULT NULL,
\r
959 `STR_PROP_2` VARCHAR(512) NULL DEFAULT NULL,
\r
960 `STR_PROP_3` VARCHAR(512) NULL DEFAULT NULL,
\r
961 `INT_PROP_1` INT(11) NULL DEFAULT NULL,
\r
962 `INT_PROP_2` INT(11) NULL DEFAULT NULL,
\r
963 `LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL,
\r
964 `LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL,
\r
965 `DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL,
\r
966 `DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL,
\r
967 `BOOL_PROP_1` VARCHAR(1) NULL DEFAULT NULL,
\r
968 `BOOL_PROP_2` VARCHAR(1) NULL DEFAULT NULL,
\r
969 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
970 CONSTRAINT `fn_qz_simprop_triggers_ibfk_1`
\r
971 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
972 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
974 DEFAULT CHARACTER SET = utf8;
\r
976 -- ----------------------------------------------------------------------------
\r
977 -- Table vid_openecomp_epsdk.fn_qz_triggers
\r
978 -- ----------------------------------------------------------------------------
\r
979 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_triggers` (
\r
980 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
981 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
982 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
983 `JOB_NAME` VARCHAR(200) NOT NULL,
\r
984 `JOB_GROUP` VARCHAR(200) NOT NULL,
\r
985 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
\r
986 `NEXT_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
987 `PREV_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
988 `PRIORITY` INT(11) NULL DEFAULT NULL,
\r
989 `TRIGGER_STATE` VARCHAR(16) NOT NULL,
\r
990 `TRIGGER_TYPE` VARCHAR(8) NOT NULL,
\r
991 `START_TIME` BIGINT(13) NOT NULL,
\r
992 `END_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
993 `CALENDAR_NAME` VARCHAR(200) NULL DEFAULT NULL,
\r
994 `MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL,
\r
995 `JOB_DATA` BLOB NULL DEFAULT NULL,
\r
996 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
997 INDEX `IDX_FN_QZ_T_J` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
\r
998 INDEX `IDX_FN_QZ_T_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
\r
999 INDEX `IDX_FN_QZ_T_C` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC),
\r
1000 INDEX `IDX_FN_QZ_T_G` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
1001 INDEX `IDX_FN_QZ_T_STATE` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC),
\r
1002 INDEX `IDX_FN_QZ_T_N_STATE` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1003 INDEX `IDX_FN_QZ_T_N_G_STATE` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1004 INDEX `IDX_FN_QZ_T_NEXT_FIRE_TIME` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC),
\r
1005 INDEX `IDX_FN_QZ_T_NFT_ST` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC),
\r
1006 INDEX `IDX_FN_QZ_T_NFT_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC),
\r
1007 INDEX `IDX_FN_QZ_T_NFT_ST_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC),
\r
1008 INDEX `IDX_FN_QZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1009 CONSTRAINT `fn_qz_triggers_ibfk_1`
\r
1010 FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`)
\r
1011 REFERENCES `vid_openecomp_epsdk`.`fn_qz_job_details` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`))
\r
1013 DEFAULT CHARACTER SET = utf8;
\r
1015 -- ----------------------------------------------------------------------------
\r
1016 -- Table vid_openecomp_epsdk.fn_restricted_url
\r
1017 -- ----------------------------------------------------------------------------
\r
1018 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_restricted_url` (
\r
1019 `RESTRICTED_URL` VARCHAR(250) NOT NULL,
\r
1020 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1021 PRIMARY KEY (`RESTRICTED_URL`, `FUNCTION_CD`),
\r
1022 INDEX `FK_RESTRICTED_URL_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1023 CONSTRAINT `FK_RESTRICTED_URL_FUNCTION_CD`
\r
1024 FOREIGN KEY (`FUNCTION_CD`)
\r
1025 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
1027 DEFAULT CHARACTER SET = utf8;
\r
1029 -- ----------------------------------------------------------------------------
\r
1030 -- Table vid_openecomp_epsdk.fn_role
\r
1031 -- ----------------------------------------------------------------------------
\r
1032 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role` (
\r
1033 `ROLE_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1034 `ROLE_NAME` VARCHAR(255) NOT NULL,
\r
1035 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
1036 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
\r
1037 PRIMARY KEY (`ROLE_ID`))
\r
1039 AUTO_INCREMENT = 17
\r
1040 DEFAULT CHARACTER SET = utf8;
\r
1042 ALTER TABLE `vid_openecomp_epsdk`.`fn_role` MODIFY `ROLE_NAME` VARCHAR (255);
\r
1045 -- ----------------------------------------------------------------------------
\r
1046 -- Table vid_openecomp_epsdk.fn_role_composite
\r
1047 -- ----------------------------------------------------------------------------
\r
1048 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_composite` (
\r
1049 `PARENT_ROLE_ID` INT(11) NOT NULL,
\r
1050 `CHILD_ROLE_ID` INT(11) NOT NULL,
\r
1051 PRIMARY KEY (`PARENT_ROLE_ID`, `CHILD_ROLE_ID`),
\r
1052 INDEX `FK_FN_ROLE_COMPOSITE_CHILD` (`CHILD_ROLE_ID` ASC),
\r
1053 CONSTRAINT `FK_FN_ROLE_COMPOSITE_CHILD`
\r
1054 FOREIGN KEY (`CHILD_ROLE_ID`)
\r
1055 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1056 CONSTRAINT `FK_FN_ROLE_COMPOSITE_PARENT`
\r
1057 FOREIGN KEY (`PARENT_ROLE_ID`)
\r
1058 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`))
\r
1060 DEFAULT CHARACTER SET = utf8;
\r
1062 -- ----------------------------------------------------------------------------
\r
1063 -- Table vid_openecomp_epsdk.fn_role_function
\r
1064 -- ----------------------------------------------------------------------------
\r
1065 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_function` (
\r
1066 `ROLE_ID` INT(11) NOT NULL,
\r
1067 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1068 PRIMARY KEY (`ROLE_ID`, `FUNCTION_CD`),
\r
1069 INDEX `FN_ROLE_FUNCTION_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1070 INDEX `FN_ROLE_FUNCTION_ROLE_ID` (`ROLE_ID` ASC),
\r
1071 CONSTRAINT `FK_FN_ROLE__REF_198_FN_ROLE`
\r
1072 FOREIGN KEY (`ROLE_ID`)
\r
1073 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1074 CONSTRAINT `FK_FN_ROLE__REF_201_FN_FUNCT`
\r
1075 FOREIGN KEY (`FUNCTION_CD`)
\r
1076 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
1078 DEFAULT CHARACTER SET = utf8;
\r
1080 -- ----------------------------------------------------------------------------
\r
1081 -- Table vid_openecomp_epsdk.fn_schedule_workflows
\r
1082 -- ----------------------------------------------------------------------------
\r
1083 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_schedule_workflows` (
\r
1084 `id_schedule_workflows` BIGINT(25) NOT NULL AUTO_INCREMENT,
\r
1085 `workflow_server_url` VARCHAR(45) NULL DEFAULT NULL,
\r
1086 `workflow_key` VARCHAR(45) NOT NULL,
\r
1087 `workflow_arguments` VARCHAR(45) NULL DEFAULT NULL,
\r
1088 `startDateTimeCron` VARCHAR(45) NULL DEFAULT NULL,
\r
1089 `endDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1090 `start_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1091 `recurrence` VARCHAR(45) NULL DEFAULT NULL,
\r
1092 PRIMARY KEY (`id_schedule_workflows`))
\r
1094 DEFAULT CHARACTER SET = utf8;
\r
1096 -- ----------------------------------------------------------------------------
\r
1097 -- Table vid_openecomp_epsdk.fn_tab
\r
1098 -- ----------------------------------------------------------------------------
\r
1099 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab` (
\r
1100 `TAB_CD` VARCHAR(30) NOT NULL,
\r
1101 `TAB_NAME` VARCHAR(50) NOT NULL,
\r
1102 `TAB_DESCR` VARCHAR(100) NULL DEFAULT NULL,
\r
1103 `ACTION` VARCHAR(100) NOT NULL,
\r
1104 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1105 `ACTIVE_YN` CHAR(1) NOT NULL,
\r
1106 `SORT_ORDER` DECIMAL(11,0) NOT NULL,
\r
1107 `PARENT_TAB_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
1108 `TAB_SET_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
1109 PRIMARY KEY (`TAB_CD`),
\r
1110 INDEX `FK_FN_TAB_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1111 INDEX `FK_FN_TAB_SET_CD` (`TAB_SET_CD` ASC),
\r
1112 CONSTRAINT `FK_FN_TAB_FUNCTION_CD`
\r
1113 FOREIGN KEY (`FUNCTION_CD`)
\r
1114 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`),
\r
1115 CONSTRAINT `FK_FN_TAB_SET_CD`
\r
1116 FOREIGN KEY (`TAB_SET_CD`)
\r
1117 REFERENCES `vid_openecomp_epsdk`.`fn_lu_tab_set` (`TAB_SET_CD`))
\r
1119 DEFAULT CHARACTER SET = utf8;
\r
1121 -- ----------------------------------------------------------------------------
\r
1122 -- Table vid_openecomp_epsdk.fn_tab_selected
\r
1123 -- ----------------------------------------------------------------------------
\r
1124 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab_selected` (
\r
1125 `SELECTED_TAB_CD` VARCHAR(30) NOT NULL,
\r
1126 `TAB_URI` VARCHAR(40) NOT NULL,
\r
1127 PRIMARY KEY (`SELECTED_TAB_CD`, `TAB_URI`),
\r
1128 CONSTRAINT `FK_FN_TAB_SELECTED_TAB_CD`
\r
1129 FOREIGN KEY (`SELECTED_TAB_CD`)
\r
1130 REFERENCES `vid_openecomp_epsdk`.`fn_tab` (`TAB_CD`))
\r
1132 DEFAULT CHARACTER SET = utf8;
\r
1134 -- ----------------------------------------------------------------------------
\r
1135 -- Table vid_openecomp_epsdk.fn_user
\r
1136 -- ----------------------------------------------------------------------------
\r
1137 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user` (
\r
1138 `USER_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1139 `ORG_ID` INT(11) NULL DEFAULT NULL,
\r
1140 `MANAGER_ID` INT(11) NULL DEFAULT NULL,
\r
1141 `FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1142 `MIDDLE_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1143 `LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1144 `PHONE` VARCHAR(25) NULL DEFAULT NULL,
\r
1145 `FAX` VARCHAR(25) NULL DEFAULT NULL,
\r
1146 `CELLULAR` VARCHAR(25) NULL DEFAULT NULL,
\r
1147 `EMAIL` VARCHAR(50) NULL DEFAULT NULL,
\r
1148 `ADDRESS_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
1149 `ALERT_METHOD_CD` VARCHAR(10) NULL DEFAULT NULL,
\r
1150 `HRID` VARCHAR(20) NULL DEFAULT NULL,
\r
1151 `ORG_USER_ID` VARCHAR(20) NULL DEFAULT NULL,
\r
1152 `ORG_CODE` VARCHAR(30) NULL DEFAULT NULL,
\r
1153 `LOGIN_ID` VARCHAR(25) NULL DEFAULT NULL,
\r
1154 `LOGIN_PWD` VARCHAR(25) NULL DEFAULT NULL,
\r
1155 `LAST_LOGIN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
1156 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
1157 `CREATED_ID` INT(11) NULL DEFAULT NULL,
\r
1158 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1159 `MODIFIED_ID` INT(11) NULL DEFAULT NULL,
\r
1160 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1161 `IS_INTERNAL_YN` CHAR(1) NOT NULL DEFAULT 'N',
\r
1162 `ADDRESS_LINE_1` VARCHAR(100) NULL DEFAULT NULL,
\r
1163 `ADDRESS_LINE_2` VARCHAR(100) NULL DEFAULT NULL,
\r
1164 `CITY` VARCHAR(50) NULL DEFAULT NULL,
\r
1165 `STATE_CD` VARCHAR(3) NULL DEFAULT NULL,
\r
1166 `ZIP_CODE` VARCHAR(11) NULL DEFAULT NULL,
\r
1167 `COUNTRY_CD` VARCHAR(3) NULL DEFAULT NULL,
\r
1168 `LOCATION_CLLI` VARCHAR(8) NULL DEFAULT NULL,
\r
1169 `ORG_MANAGER_USERID` VARCHAR(20) NULL DEFAULT NULL,
\r
1170 `COMPANY` VARCHAR(100) NULL DEFAULT NULL,
\r
1171 `DEPARTMENT_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
1172 `JOB_TITLE` VARCHAR(100) NULL DEFAULT NULL,
\r
1173 `TIMEZONE` INT(11) NULL DEFAULT NULL,
\r
1174 `DEPARTMENT` VARCHAR(25) NULL DEFAULT NULL,
\r
1175 `BUSINESS_UNIT` VARCHAR(25) NULL DEFAULT NULL,
\r
1176 `BUSINESS_UNIT_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
1177 `COST_CENTER` VARCHAR(25) NULL DEFAULT NULL,
\r
1178 `FIN_LOC_CODE` VARCHAR(10) NULL DEFAULT NULL,
\r
1179 `SILO_STATUS` VARCHAR(10) NULL DEFAULT NULL,
\r
1180 PRIMARY KEY (`USER_ID`),
\r
1181 UNIQUE INDEX `FN_USER_HRID` (`HRID` ASC),
\r
1182 UNIQUE INDEX `FN_USER_LOGIN_ID` (`LOGIN_ID` ASC),
\r
1183 INDEX `FN_USER_ADDRESS_ID` (`ADDRESS_ID` ASC),
\r
1184 INDEX `FN_USER_ALERT_METHOD_CD` (`ALERT_METHOD_CD` ASC),
\r
1185 INDEX `FN_USER_ORG_ID` (`ORG_ID` ASC),
\r
1186 INDEX `FK_FN_USER_REF_197_FN_USER` (`MANAGER_ID` ASC),
\r
1187 INDEX `FK_FN_USER_REF_198_FN_USER` (`CREATED_ID` ASC),
\r
1188 INDEX `FK_FN_USER_REF_199_FN_USER` (`MODIFIED_ID` ASC),
\r
1189 INDEX `FK_TIMEZONE` (`TIMEZONE` ASC),
\r
1190 CONSTRAINT `FK_FN_USER_REF_110_FN_ORG`
\r
1191 FOREIGN KEY (`ORG_ID`)
\r
1192 REFERENCES `vid_openecomp_epsdk`.`fn_org` (`ORG_ID`),
\r
1193 CONSTRAINT `FK_FN_USER_REF_123_FN_LU_AL`
\r
1194 FOREIGN KEY (`ALERT_METHOD_CD`)
\r
1195 REFERENCES `vid_openecomp_epsdk`.`fn_lu_alert_method` (`ALERT_METHOD_CD`),
\r
1196 CONSTRAINT `FK_FN_USER_REF_197_FN_USER`
\r
1197 FOREIGN KEY (`MANAGER_ID`)
\r
1198 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1199 CONSTRAINT `FK_FN_USER_REF_198_FN_USER`
\r
1200 FOREIGN KEY (`CREATED_ID`)
\r
1201 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1202 CONSTRAINT `FK_FN_USER_REF_199_FN_USER`
\r
1203 FOREIGN KEY (`MODIFIED_ID`)
\r
1204 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1205 CONSTRAINT `FK_TIMEZONE`
\r
1206 FOREIGN KEY (`TIMEZONE`)
\r
1207 REFERENCES `vid_openecomp_epsdk`.`fn_lu_timezone` (`TIMEZONE_ID`))
\r
1209 AUTO_INCREMENT = 3
\r
1210 DEFAULT CHARACTER SET = utf8;
\r
1213 -- ----------------------------------------------------------------------------
\r
1214 -- Table vid_openecomp_epsdk.fn_user_pseudo_role
\r
1215 -- ----------------------------------------------------------------------------
\r
1216 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_pseudo_role` (
\r
1217 `PSEUDO_ROLE_ID` INT(11) NOT NULL,
\r
1218 `USER_ID` INT(11) NOT NULL,
\r
1219 PRIMARY KEY (`PSEUDO_ROLE_ID`, `USER_ID`),
\r
1220 INDEX `FK_PSEUDO_ROLE_USER_ID` (`USER_ID` ASC),
\r
1221 CONSTRAINT `FK_PSEUDO_ROLE_PSEUDO_ROLE_ID`
\r
1222 FOREIGN KEY (`PSEUDO_ROLE_ID`)
\r
1223 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1224 CONSTRAINT `FK_PSEUDO_ROLE_USER_ID`
\r
1225 FOREIGN KEY (`USER_ID`)
\r
1226 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
1228 DEFAULT CHARACTER SET = utf8;
\r
1230 -- ----------------------------------------------------------------------------
\r
1231 -- Table vid_openecomp_epsdk.fn_user_role
\r
1232 -- ----------------------------------------------------------------------------
\r
1233 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_role` (
\r
1234 `USER_ID` INT(10) NOT NULL,
\r
1235 `ROLE_ID` INT(10) NOT NULL,
\r
1236 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
\r
1237 `APP_ID` INT(11) NOT NULL DEFAULT '1',
\r
1238 PRIMARY KEY (`USER_ID`, `ROLE_ID`, `APP_ID`),
\r
1239 INDEX `FN_USER_ROLE_ROLE_ID` (`ROLE_ID` ASC),
\r
1240 INDEX `FN_USER_ROLE_USER_ID` (`USER_ID` ASC),
\r
1241 INDEX `FK_FN_USER__REF_178_FN_APP_idx` (`APP_ID` ASC),
\r
1242 CONSTRAINT `FK_FN_USER__REF_172_FN_USER`
\r
1243 FOREIGN KEY (`USER_ID`)
\r
1244 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1245 CONSTRAINT `FK_FN_USER__REF_175_FN_ROLE`
\r
1246 FOREIGN KEY (`ROLE_ID`)
\r
1247 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1248 CONSTRAINT `FK_FN_USER__REF_178_FN_APP`
\r
1249 FOREIGN KEY (`APP_ID`)
\r
1250 REFERENCES `vid_openecomp_epsdk`.`fn_app` (`APP_ID`))
\r
1252 DEFAULT CHARACTER SET = utf8;
\r
1254 -- ----------------------------------------------------------------------------
\r
1255 -- Table vid_openecomp_epsdk.fn_workflow
\r
1256 -- ----------------------------------------------------------------------------
\r
1257 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_workflow` (
\r
1258 `id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
\r
1259 `name` VARCHAR(20) NOT NULL,
\r
1260 `description` VARCHAR(500) NULL DEFAULT NULL,
\r
1261 `run_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1262 `suspend_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1263 `modified_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1264 `active_yn` VARCHAR(300) NULL DEFAULT NULL,
\r
1265 `created` VARCHAR(300) NULL DEFAULT NULL,
\r
1266 `created_by` INT(11) NULL DEFAULT NULL,
\r
1267 `modified` VARCHAR(300) NULL DEFAULT NULL,
\r
1268 `modified_by` INT(11) NULL DEFAULT NULL,
\r
1269 `workflow_key` VARCHAR(50) NULL DEFAULT NULL,
\r
1270 PRIMARY KEY (`id`),
\r
1271 UNIQUE INDEX `name` (`name` ASC))
\r
1273 DEFAULT CHARACTER SET = utf8;
\r
1275 -- ----------------------------------------------------------------------------
\r
1276 -- Table vid_openecomp_epsdk.fn_xmltype
\r
1277 -- ----------------------------------------------------------------------------
\r
1278 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_xmltype` (
\r
1279 `ID` DECIMAL(10,0) NOT NULL,
\r
1280 `XML_DOCUMENT` TEXT NULL DEFAULT NULL,
\r
1281 UNIQUE INDEX `FN_XMLTYPE_ID` (`ID` ASC))
\r
1283 DEFAULT CHARACTER SET = utf8;
\r
1285 -- ----------------------------------------------------------------------------
\r
1286 -- Table vid_openecomp_epsdk.schema_info
\r
1287 -- ----------------------------------------------------------------------------
\r
1288 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`schema_info` (
\r
1289 `SCHEMA_ID` VARCHAR(25) NOT NULL,
\r
1290 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
\r
1291 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
\r
1292 `CONNECTION_URL` VARCHAR(200) NOT NULL,
\r
1293 `USER_NAME` VARCHAR(45) NOT NULL,
\r
1294 `PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
\r
1295 `DRIVER_CLASS` VARCHAR(100) NOT NULL,
\r
1296 `MIN_POOL_SIZE` INT(11) NOT NULL,
\r
1297 `MAX_POOL_SIZE` INT(11) NOT NULL,
\r
1298 `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
\r
1300 DEFAULT CHARACTER SET = utf8;
\r
1301 -- ----------------------------------------------------------------------------
\r
1302 -- Table vid_openecomp_epsdk.vid_vnf
\r
1303 -- ----------------------------------------------------------------------------
\r
1305 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf` (
\r
1306 `VNF_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
\r
1307 `VNF_APP_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\r
1308 `VNF_APP_INVARIANT_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\r
1309 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1310 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1311 PRIMARY KEY (`VNF_DB_ID`),
\r
1312 UNIQUE KEY `vid_vnf_VNF_ID_uindex` (`VNF_APP_UUID`,`VNF_APP_INVARIANT_UUID`)
\r
1313 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
\r
1315 -- ----------------------------------------------------------------------------
\r
1316 -- Table vid_openecomp_epsdk.vid_workflow
\r
1317 -- ----------------------------------------------------------------------------
\r
1319 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_workflow` (
\r
1320 `WORKFLOW_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
\r
1321 `WORKFLOW_APP_NAME` varchar(50) COLLATE utf8_bin NOT NULL,
\r
1322 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1323 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1324 PRIMARY KEY (`WORKFLOW_DB_ID`),
\r
1325 UNIQUE KEY `vid_workflow_workflow_uuid_uindex` (`WORKFLOW_APP_NAME`),
\r
1326 UNIQUE KEY `vid_workflow_WORKFLOW_ID_uindex` (`WORKFLOW_DB_ID`)
\r
1327 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1329 -- ----------------------------------------------------------------------------
\r
1330 -- Table vid_openecomp_epsdk.vid_vnf_workflow
\r
1331 -- ----------------------------------------------------------------------------
\r
1334 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf_workflow` (
\r
1335 `VNF_DB_ID` int(11) NOT NULL,
\r
1336 `WORKFLOW_DB_ID` int(11) NOT NULL,
\r
1337 KEY `vid_vnf_workflow_vid_vnf_VND_ID_fk` (`VNF_DB_ID`),
\r
1338 KEY `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` (`WORKFLOW_DB_ID`),
\r
1339 CONSTRAINT `vid_vnf_workflow_vid_vnf_VND_ID_fk` FOREIGN KEY (`VNF_DB_ID`) REFERENCES `vid_vnf` (`VNF_DB_ID`),
\r
1340 CONSTRAINT `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` FOREIGN KEY (`WORKFLOW_DB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_workflow` (`WORKFLOW_DB_ID`)
\r
1341 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1344 -- ----------------------------------------------------------------------------
\r
1345 -- Table vid_openecomp_epsdk.vid_category_parameter
\r
1346 -- ----------------------------------------------------------------------------
\r
1349 CREATE TABLE IF NOT EXISTS `vid_category_parameter` (
\r
1350 `CATEGORY_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1351 `NAME` VARCHAR(255) NULL COLLATE 'utf8_bin',
\r
1352 `ID_SUPPORTED` TINYINT(1) NOT NULL DEFAULT '0',
\r
1353 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1354 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1355 PRIMARY KEY (`CATEGORY_ID`)
\r
1356 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=5;
\r
1358 -------------------------------------------------------------------------------
\r
1360 ALTER TABLE `vid_category_parameter`
\r
1361 ADD COLUMN if not exists `FAMILY` ENUM('PARAMETER_STANDARDIZATION','TENANT_ISOLATION') NOT NULL DEFAULT 'PARAMETER_STANDARDIZATION' AFTER `ID_SUPPORTED`;
\r
1362 -- ----------------------------------------------------------------------------
\r
1363 -- Table vid_openecomp_epsdk.vid_category_parameter
\r
1364 -- ----------------------------------------------------------------------------
\r
1365 CREATE TABLE IF NOT EXISTS `vid_category_parameter_option` (
\r
1366 `CATEGORY_OPT_DB_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1367 `CATEGORY_OPT_APP_ID` VARCHAR(50) NOT NULL COLLATE 'utf8_bin',
\r
1368 `NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1369 `CATEGORY_ID` INT(11) NOT NULL DEFAULT '0',
\r
1370 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1371 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1372 PRIMARY KEY (`CATEGORY_OPT_DB_ID`),
\r
1373 UNIQUE INDEX `APP_ID_CATEGORY_UNIQUE` (`CATEGORY_ID`, `CATEGORY_OPT_APP_ID`),
\r
1374 UNIQUE INDEX `NAME_CATEGORY_UNIQUE` (`CATEGORY_ID`, `NAME`),
\r
1375 CONSTRAINT `FK_OWNING_ENTITY_OPTIONS_TO_OE` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_category_parameter` (`CATEGORY_ID`)
\r
1376 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=25;
\r
1379 -- ----------------------------------------------------------------------------
\r
1380 -- View vid_openecomp_epsdk.v_url_access
\r
1381 -- ----------------------------------------------------------------------------
\r
1382 CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `v_url_access` AS select distinct `m`.`ACTION` AS `URL`,`m`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_menu` `m` where (`m`.`ACTION` is not null) union select distinct `t`.`ACTION` AS `URL`,`t`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_tab` `t` where (`t`.`ACTION` is not null) union select `r`.`RESTRICTED_URL` AS `URL`,`r`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_restricted_url` `r`;
\r
1383 SET FOREIGN_KEY_CHECKS = 1;
\r