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 `type` VARCHAR(20) NOT NULL,
\r
565 `action` VARCHAR(20) NOT NULL,
\r
566 PRIMARY KEY (`FUNCTION_CD`),
\r
567 CONSTRAINT `function` UNIQUE (FUNCTION_CD,TYPE,ACTION))
\r
569 DEFAULT CHARACTER SET = utf8;
\r
571 -- ----------------------------------------------------------------------------
\r
572 -- Table vid_openecomp_epsdk.fn_license
\r
573 -- ----------------------------------------------------------------------------
\r
574 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license` (
\r
575 `id` DECIMAL(11,0) NOT NULL,
\r
576 `app_id` DECIMAL(11,0) NOT NULL,
\r
577 `ip_address` VARCHAR(100) NOT NULL,
\r
578 `quantum_version_id` DECIMAL(11,0) NOT NULL,
\r
579 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
580 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
581 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
582 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
583 `end_date` TIMESTAMP NOT NULL DEFAULT '2036-01-19 03:14:07',
\r
584 PRIMARY KEY (`id`),
\r
585 INDEX `fn_license_r02` (`quantum_version_id` ASC),
\r
586 CONSTRAINT `fn_license_r02`
\r
587 FOREIGN KEY (`quantum_version_id`)
\r
588 REFERENCES `vid_openecomp_epsdk`.`fn_license_version` (`id`))
\r
590 DEFAULT CHARACTER SET = utf8;
\r
592 -- ----------------------------------------------------------------------------
\r
593 -- Table vid_openecomp_epsdk.fn_license_app
\r
594 -- ----------------------------------------------------------------------------
\r
595 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_app` (
\r
596 `id` DECIMAL(11,0) NOT NULL,
\r
597 `app_name` VARCHAR(100) NOT NULL,
\r
598 `ctxt_name` VARCHAR(100) NULL DEFAULT NULL,
\r
599 INDEX `fn_license_app_ID` (`id` ASC))
\r
601 DEFAULT CHARACTER SET = utf8;
\r
603 -- ----------------------------------------------------------------------------
\r
604 -- Table vid_openecomp_epsdk.fn_license_contact
\r
605 -- ----------------------------------------------------------------------------
\r
606 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_contact` (
\r
607 `id` INT(11) NOT NULL,
\r
608 `license_id` INT(11) NULL DEFAULT NULL,
\r
609 `sbcid` VARCHAR(20) NULL DEFAULT NULL,
\r
610 PRIMARY KEY (`id`))
\r
612 DEFAULT CHARACTER SET = utf8;
\r
614 -- ----------------------------------------------------------------------------
\r
615 -- Table vid_openecomp_epsdk.fn_license_history
\r
616 -- ----------------------------------------------------------------------------
\r
617 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_history` (
\r
618 `license_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
619 `app_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
620 `ip_address` VARCHAR(100) NULL DEFAULT NULL,
\r
621 `quantum_version_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
622 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
623 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
624 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
625 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
626 `id` DECIMAL(11,0) NOT NULL,
\r
627 PRIMARY KEY (`id`))
\r
629 DEFAULT CHARACTER SET = utf8;
\r
631 -- ----------------------------------------------------------------------------
\r
632 -- Table vid_openecomp_epsdk.fn_license_version
\r
633 -- ----------------------------------------------------------------------------
\r
634 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_version` (
\r
635 `id` DECIMAL(11,0) NOT NULL,
\r
636 `quantum_version` VARCHAR(25) NULL DEFAULT NULL,
\r
637 PRIMARY KEY (`id`))
\r
639 DEFAULT CHARACTER SET = utf8;
\r
641 -- ----------------------------------------------------------------------------
\r
642 -- Table vid_openecomp_epsdk.fn_lu_activity
\r
643 -- ----------------------------------------------------------------------------
\r
644 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_activity` (
\r
645 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
\r
646 `ACTIVITY` VARCHAR(50) NOT NULL,
\r
647 PRIMARY KEY (`ACTIVITY_CD`))
\r
649 DEFAULT CHARACTER SET = utf8;
\r
651 -- ----------------------------------------------------------------------------
\r
652 -- Table vid_openecomp_epsdk.fn_lu_alert_method
\r
653 -- ----------------------------------------------------------------------------
\r
654 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_alert_method` (
\r
655 `ALERT_METHOD_CD` VARCHAR(10) NOT NULL,
\r
656 `ALERT_METHOD` VARCHAR(50) NOT NULL,
\r
657 PRIMARY KEY (`ALERT_METHOD_CD`))
\r
659 DEFAULT CHARACTER SET = utf8;
\r
661 -- ----------------------------------------------------------------------------
\r
662 -- Table vid_openecomp_epsdk.fn_lu_broadcast_site
\r
663 -- ----------------------------------------------------------------------------
\r
664 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_broadcast_site` (
\r
665 `BROADCAST_SITE_CD` VARCHAR(50) NOT NULL,
\r
666 `BROADCAST_SITE_DESCR` VARCHAR(100) NULL DEFAULT NULL,
\r
667 PRIMARY KEY (`BROADCAST_SITE_CD`))
\r
669 DEFAULT CHARACTER SET = utf8;
\r
671 -- ----------------------------------------------------------------------------
\r
672 -- Table vid_openecomp_epsdk.fn_lu_call_times
\r
673 -- ----------------------------------------------------------------------------
\r
674 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_call_times` (
\r
675 `CALL_TIME_ID` DECIMAL(10,0) NOT NULL,
\r
676 `CALL_TIME_AMOUNT` DECIMAL(10,0) NOT NULL,
\r
677 `CALL_TIME_DISPLAY` VARCHAR(50) NOT NULL,
\r
678 PRIMARY KEY (`CALL_TIME_ID`))
\r
680 DEFAULT CHARACTER SET = utf8;
\r
682 -- ----------------------------------------------------------------------------
\r
683 -- Table vid_openecomp_epsdk.fn_lu_city
\r
684 -- ----------------------------------------------------------------------------
\r
685 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_city` (
\r
686 `CITY_CD` VARCHAR(2) NOT NULL,
\r
687 `CITY` VARCHAR(100) NOT NULL,
\r
688 `STATE_CD` VARCHAR(2) NOT NULL,
\r
689 PRIMARY KEY (`CITY_CD`, `STATE_CD`))
\r
691 DEFAULT CHARACTER SET = utf8;
\r
693 -- ----------------------------------------------------------------------------
\r
694 -- Table vid_openecomp_epsdk.fn_lu_country
\r
695 -- ----------------------------------------------------------------------------
\r
696 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_country` (
\r
697 `COUNTRY_CD` VARCHAR(3) NOT NULL,
\r
698 `COUNTRY` VARCHAR(100) NOT NULL,
\r
699 `FULL_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
700 `WEBPHONE_COUNTRY_LABEL` VARCHAR(30) NULL DEFAULT NULL,
\r
701 PRIMARY KEY (`COUNTRY_CD`))
\r
703 DEFAULT CHARACTER SET = utf8;
\r
705 -- ----------------------------------------------------------------------------
\r
706 -- Table vid_openecomp_epsdk.fn_lu_menu_set
\r
707 -- ----------------------------------------------------------------------------
\r
708 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_menu_set` (
\r
709 `MENU_SET_CD` VARCHAR(10) NOT NULL,
\r
710 `MENU_SET_NAME` VARCHAR(50) NOT NULL,
\r
711 PRIMARY KEY (`MENU_SET_CD`))
\r
713 DEFAULT CHARACTER SET = utf8;
\r
715 -- ----------------------------------------------------------------------------
\r
716 -- Table vid_openecomp_epsdk.fn_lu_priority
\r
717 -- ----------------------------------------------------------------------------
\r
718 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_priority` (
\r
719 `PRIORITY_ID` DECIMAL(11,0) NOT NULL,
\r
720 `PRIORITY` VARCHAR(50) NOT NULL,
\r
721 `ACTIVE_YN` CHAR(1) NOT NULL,
\r
722 `SORT_ORDER` DECIMAL(5,0) NULL DEFAULT NULL,
\r
723 PRIMARY KEY (`PRIORITY_ID`))
\r
725 DEFAULT CHARACTER SET = utf8;
\r
727 -- ----------------------------------------------------------------------------
\r
728 -- Table vid_openecomp_epsdk.fn_lu_role_type
\r
729 -- ----------------------------------------------------------------------------
\r
730 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_role_type` (
\r
731 `ROLE_TYPE_ID` DECIMAL(11,0) NOT NULL,
\r
732 `ROLE_TYPE` VARCHAR(50) NOT NULL,
\r
733 PRIMARY KEY (`ROLE_TYPE_ID`))
\r
735 DEFAULT CHARACTER SET = utf8;
\r
737 -- ----------------------------------------------------------------------------
\r
738 -- Table vid_openecomp_epsdk.fn_lu_state
\r
739 -- ----------------------------------------------------------------------------
\r
740 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_state` (
\r
741 `STATE_CD` VARCHAR(2) NOT NULL,
\r
742 `STATE` VARCHAR(100) NOT NULL,
\r
743 PRIMARY KEY (`STATE_CD`))
\r
745 DEFAULT CHARACTER SET = utf8;
\r
747 -- ----------------------------------------------------------------------------
\r
748 -- Table vid_openecomp_epsdk.fn_lu_tab_set
\r
749 -- ----------------------------------------------------------------------------
\r
750 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_tab_set` (
\r
751 `TAB_SET_CD` VARCHAR(30) NOT NULL,
\r
752 `TAB_SET_NAME` VARCHAR(50) NOT NULL,
\r
753 PRIMARY KEY (`TAB_SET_CD`))
\r
755 DEFAULT CHARACTER SET = utf8;
\r
757 -- ----------------------------------------------------------------------------
\r
758 -- Table vid_openecomp_epsdk.fn_lu_timezone
\r
759 -- ----------------------------------------------------------------------------
\r
760 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_timezone` (
\r
761 `TIMEZONE_ID` INT(11) NOT NULL,
\r
762 `TIMEZONE_NAME` VARCHAR(100) NOT NULL,
\r
763 `TIMEZONE_VALUE` VARCHAR(100) NOT NULL,
\r
764 PRIMARY KEY (`TIMEZONE_ID`))
\r
766 DEFAULT CHARACTER SET = utf8;
\r
768 -- ----------------------------------------------------------------------------
\r
769 -- Table vid_openecomp_epsdk.fn_menu
\r
770 -- ----------------------------------------------------------------------------
\r
771 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_menu` (
\r
772 `MENU_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
773 `LABEL` VARCHAR(100) NULL DEFAULT NULL,
\r
774 `PARENT_ID` INT(11) NULL DEFAULT NULL,
\r
775 `SORT_ORDER` DECIMAL(4,0) NULL DEFAULT NULL,
\r
776 `ACTION` VARCHAR(200) NULL DEFAULT NULL,
\r
777 `FUNCTION_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
778 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
779 `SERVLET` VARCHAR(50) NULL DEFAULT NULL,
\r
780 `QUERY_STRING` VARCHAR(200) NULL DEFAULT NULL,
\r
781 `EXTERNAL_URL` VARCHAR(200) NULL DEFAULT NULL,
\r
782 `TARGET` VARCHAR(25) NULL DEFAULT NULL,
\r
783 `MENU_SET_CD` VARCHAR(10) NULL DEFAULT 'APP',
\r
784 `SEPARATOR_YN` CHAR(1) NULL DEFAULT 'N',
\r
785 `IMAGE_SRC` VARCHAR(100) NULL DEFAULT NULL,
\r
786 PRIMARY KEY (`MENU_ID`),
\r
787 INDEX `FK_FN_MENU_REF_196_FN_MENU` (`PARENT_ID` ASC),
\r
788 INDEX `FK_FN_MENU_MENU_SET_CD` (`MENU_SET_CD` ASC),
\r
789 INDEX `FN_MENU_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
790 CONSTRAINT `FK_FN_MENU_MENU_SET_CD`
\r
791 FOREIGN KEY (`MENU_SET_CD`)
\r
792 REFERENCES `vid_openecomp_epsdk`.`fn_lu_menu_set` (`MENU_SET_CD`),
\r
793 CONSTRAINT `FK_FN_MENU_REF_196_FN_MENU`
\r
794 FOREIGN KEY (`PARENT_ID`)
\r
795 REFERENCES `vid_openecomp_epsdk`.`fn_menu` (`MENU_ID`),
\r
796 CONSTRAINT `FK_FN_MENU_REF_223_FN_FUNCT`
\r
797 FOREIGN KEY (`FUNCTION_CD`)
\r
798 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
800 AUTO_INCREMENT = 150029
\r
801 DEFAULT CHARACTER SET = utf8;
\r
803 -- ----------------------------------------------------------------------------
\r
804 -- Table vid_openecomp_epsdk.fn_org
\r
805 -- ----------------------------------------------------------------------------
\r
806 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_org` (
\r
807 `ORG_ID` INT(11) NOT NULL,
\r
808 `ORG_NAME` VARCHAR(50) NOT NULL,
\r
809 `ACCESS_CD` VARCHAR(10) NULL DEFAULT NULL,
\r
810 PRIMARY KEY (`ORG_ID`),
\r
811 INDEX `FN_ORG_ACCESS_CD` (`ACCESS_CD` ASC))
\r
813 DEFAULT CHARACTER SET = utf8;
\r
815 -- ----------------------------------------------------------------------------
\r
816 -- Table vid_openecomp_epsdk.fn_qz_blob_triggers
\r
817 -- ----------------------------------------------------------------------------
\r
818 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_blob_triggers` (
\r
819 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
820 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
821 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
822 `BLOB_DATA` BLOB NULL DEFAULT NULL,
\r
823 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
824 INDEX `SCHED_NAME` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
825 CONSTRAINT `fn_qz_blob_triggers_ibfk_1`
\r
826 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
827 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
829 DEFAULT CHARACTER SET = utf8;
\r
831 -- ----------------------------------------------------------------------------
\r
832 -- Table vid_openecomp_epsdk.fn_qz_calendars
\r
833 -- ----------------------------------------------------------------------------
\r
834 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_calendars` (
\r
835 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
836 `CALENDAR_NAME` VARCHAR(200) NOT NULL,
\r
837 `CALENDAR` BLOB NOT NULL,
\r
838 PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`))
\r
840 DEFAULT CHARACTER SET = utf8;
\r
842 -- ----------------------------------------------------------------------------
\r
843 -- Table vid_openecomp_epsdk.fn_qz_cron_triggers
\r
844 -- ----------------------------------------------------------------------------
\r
845 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_cron_triggers` (
\r
846 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
847 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
848 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
849 `CRON_EXPRESSION` VARCHAR(120) NOT NULL,
\r
850 `TIME_ZONE_ID` VARCHAR(80) NULL DEFAULT NULL,
\r
851 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
852 CONSTRAINT `fn_qz_cron_triggers_ibfk_1`
\r
853 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
854 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
856 DEFAULT CHARACTER SET = utf8;
\r
858 -- ----------------------------------------------------------------------------
\r
859 -- Table vid_openecomp_epsdk.fn_qz_fired_triggers
\r
860 -- ----------------------------------------------------------------------------
\r
861 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_fired_triggers` (
\r
862 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
863 `ENTRY_ID` VARCHAR(95) NOT NULL,
\r
864 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
865 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
866 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
\r
867 `FIRED_TIME` BIGINT(13) NOT NULL,
\r
868 `SCHED_TIME` BIGINT(13) NOT NULL,
\r
869 `PRIORITY` INT(11) NOT NULL,
\r
870 `STATE` VARCHAR(16) NOT NULL,
\r
871 `JOB_NAME` VARCHAR(200) NULL DEFAULT NULL,
\r
872 `JOB_GROUP` VARCHAR(200) NULL DEFAULT NULL,
\r
873 `IS_NONCONCURRENT` VARCHAR(1) NULL DEFAULT NULL,
\r
874 `REQUESTS_RECOVERY` VARCHAR(1) NULL DEFAULT NULL,
\r
875 PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`),
\r
876 INDEX `IDX_FN_QZ_FT_TRIG_INST_NAME` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC),
\r
877 INDEX `IDX_FN_QZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC),
\r
878 INDEX `IDX_FN_QZ_FT_J_G` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
\r
879 INDEX `IDX_FN_QZ_FT_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
\r
880 INDEX `IDX_FN_QZ_FT_T_G` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
881 INDEX `IDX_FN_QZ_FT_TG` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC))
\r
883 DEFAULT CHARACTER SET = utf8;
\r
885 -- ----------------------------------------------------------------------------
\r
886 -- Table vid_openecomp_epsdk.fn_qz_job_details
\r
887 -- ----------------------------------------------------------------------------
\r
888 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_job_details` (
\r
889 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
890 `JOB_NAME` VARCHAR(200) NOT NULL,
\r
891 `JOB_GROUP` VARCHAR(200) NOT NULL,
\r
892 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
\r
893 `JOB_CLASS_NAME` VARCHAR(250) NOT NULL,
\r
894 `IS_DURABLE` VARCHAR(1) NOT NULL,
\r
895 `IS_NONCONCURRENT` VARCHAR(1) NOT NULL,
\r
896 `IS_UPDATE_DATA` VARCHAR(1) NOT NULL,
\r
897 `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL,
\r
898 `JOB_DATA` BLOB NULL DEFAULT NULL,
\r
899 PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`),
\r
900 INDEX `IDX_FN_QZ_J_REQ_RECOVERY` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC),
\r
901 INDEX `IDX_FN_QZ_J_GRP` (`SCHED_NAME` ASC, `JOB_GROUP` ASC))
\r
903 DEFAULT CHARACTER SET = utf8;
\r
905 -- ----------------------------------------------------------------------------
\r
906 -- Table vid_openecomp_epsdk.fn_qz_locks
\r
907 -- ----------------------------------------------------------------------------
\r
908 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_locks` (
\r
909 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
910 `LOCK_NAME` VARCHAR(40) NOT NULL,
\r
911 PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`))
\r
913 DEFAULT CHARACTER SET = utf8;
\r
915 -- ----------------------------------------------------------------------------
\r
916 -- Table vid_openecomp_epsdk.fn_qz_paused_trigger_grps
\r
917 -- ----------------------------------------------------------------------------
\r
918 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_paused_trigger_grps` (
\r
919 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
920 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
921 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`))
\r
923 DEFAULT CHARACTER SET = utf8;
\r
925 -- ----------------------------------------------------------------------------
\r
926 -- Table vid_openecomp_epsdk.fn_qz_scheduler_state
\r
927 -- ----------------------------------------------------------------------------
\r
928 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_scheduler_state` (
\r
929 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
930 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
\r
931 `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL,
\r
932 `CHECKIN_INTERVAL` BIGINT(13) NOT NULL,
\r
933 PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`))
\r
935 DEFAULT CHARACTER SET = utf8;
\r
937 -- ----------------------------------------------------------------------------
\r
938 -- Table vid_openecomp_epsdk.fn_qz_simple_triggers
\r
939 -- ----------------------------------------------------------------------------
\r
940 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simple_triggers` (
\r
941 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
942 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
943 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
944 `REPEAT_COUNT` BIGINT(7) NOT NULL,
\r
945 `REPEAT_INTERVAL` BIGINT(12) NOT NULL,
\r
946 `TIMES_TRIGGERED` BIGINT(10) NOT NULL,
\r
947 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
948 CONSTRAINT `fn_qz_simple_triggers_ibfk_1`
\r
949 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
950 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
952 DEFAULT CHARACTER SET = utf8;
\r
954 -- ----------------------------------------------------------------------------
\r
955 -- Table vid_openecomp_epsdk.fn_qz_simprop_triggers
\r
956 -- ----------------------------------------------------------------------------
\r
957 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simprop_triggers` (
\r
958 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
959 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
960 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
961 `STR_PROP_1` VARCHAR(512) NULL DEFAULT NULL,
\r
962 `STR_PROP_2` VARCHAR(512) NULL DEFAULT NULL,
\r
963 `STR_PROP_3` VARCHAR(512) NULL DEFAULT NULL,
\r
964 `INT_PROP_1` INT(11) NULL DEFAULT NULL,
\r
965 `INT_PROP_2` INT(11) NULL DEFAULT NULL,
\r
966 `LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL,
\r
967 `LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL,
\r
968 `DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL,
\r
969 `DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL,
\r
970 `BOOL_PROP_1` VARCHAR(1) NULL DEFAULT NULL,
\r
971 `BOOL_PROP_2` VARCHAR(1) NULL DEFAULT NULL,
\r
972 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
973 CONSTRAINT `fn_qz_simprop_triggers_ibfk_1`
\r
974 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
975 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
977 DEFAULT CHARACTER SET = utf8;
\r
979 -- ----------------------------------------------------------------------------
\r
980 -- Table vid_openecomp_epsdk.fn_qz_triggers
\r
981 -- ----------------------------------------------------------------------------
\r
982 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_triggers` (
\r
983 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
984 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
985 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
986 `JOB_NAME` VARCHAR(200) NOT NULL,
\r
987 `JOB_GROUP` VARCHAR(200) NOT NULL,
\r
988 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
\r
989 `NEXT_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
990 `PREV_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
991 `PRIORITY` INT(11) NULL DEFAULT NULL,
\r
992 `TRIGGER_STATE` VARCHAR(16) NOT NULL,
\r
993 `TRIGGER_TYPE` VARCHAR(8) NOT NULL,
\r
994 `START_TIME` BIGINT(13) NOT NULL,
\r
995 `END_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
996 `CALENDAR_NAME` VARCHAR(200) NULL DEFAULT NULL,
\r
997 `MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL,
\r
998 `JOB_DATA` BLOB NULL DEFAULT NULL,
\r
999 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
1000 INDEX `IDX_FN_QZ_T_J` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
\r
1001 INDEX `IDX_FN_QZ_T_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
\r
1002 INDEX `IDX_FN_QZ_T_C` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC),
\r
1003 INDEX `IDX_FN_QZ_T_G` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
1004 INDEX `IDX_FN_QZ_T_STATE` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC),
\r
1005 INDEX `IDX_FN_QZ_T_N_STATE` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1006 INDEX `IDX_FN_QZ_T_N_G_STATE` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1007 INDEX `IDX_FN_QZ_T_NEXT_FIRE_TIME` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC),
\r
1008 INDEX `IDX_FN_QZ_T_NFT_ST` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC),
\r
1009 INDEX `IDX_FN_QZ_T_NFT_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC),
\r
1010 INDEX `IDX_FN_QZ_T_NFT_ST_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC),
\r
1011 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
1012 CONSTRAINT `fn_qz_triggers_ibfk_1`
\r
1013 FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`)
\r
1014 REFERENCES `vid_openecomp_epsdk`.`fn_qz_job_details` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`))
\r
1016 DEFAULT CHARACTER SET = utf8;
\r
1018 -- ----------------------------------------------------------------------------
\r
1019 -- Table vid_openecomp_epsdk.fn_restricted_url
\r
1020 -- ----------------------------------------------------------------------------
\r
1021 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_restricted_url` (
\r
1022 `RESTRICTED_URL` VARCHAR(250) NOT NULL,
\r
1023 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1024 PRIMARY KEY (`RESTRICTED_URL`, `FUNCTION_CD`),
\r
1025 INDEX `FK_RESTRICTED_URL_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1026 CONSTRAINT `FK_RESTRICTED_URL_FUNCTION_CD`
\r
1027 FOREIGN KEY (`FUNCTION_CD`)
\r
1028 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
1030 DEFAULT CHARACTER SET = utf8;
\r
1032 -- ----------------------------------------------------------------------------
\r
1033 -- Table vid_openecomp_epsdk.fn_role
\r
1034 -- ----------------------------------------------------------------------------
\r
1035 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role` (
\r
1036 `ROLE_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1037 `ROLE_NAME` VARCHAR(255) NOT NULL,
\r
1038 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
1039 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
\r
1040 PRIMARY KEY (`ROLE_ID`))
\r
1042 AUTO_INCREMENT = 17
\r
1043 DEFAULT CHARACTER SET = utf8;
\r
1045 ALTER TABLE `vid_openecomp_epsdk`.`fn_role` MODIFY `ROLE_NAME` VARCHAR (255);
\r
1048 -- ----------------------------------------------------------------------------
\r
1049 -- Table vid_openecomp_epsdk.fn_role_composite
\r
1050 -- ----------------------------------------------------------------------------
\r
1051 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_composite` (
\r
1052 `PARENT_ROLE_ID` INT(11) NOT NULL,
\r
1053 `CHILD_ROLE_ID` INT(11) NOT NULL,
\r
1054 PRIMARY KEY (`PARENT_ROLE_ID`, `CHILD_ROLE_ID`),
\r
1055 INDEX `FK_FN_ROLE_COMPOSITE_CHILD` (`CHILD_ROLE_ID` ASC),
\r
1056 CONSTRAINT `FK_FN_ROLE_COMPOSITE_CHILD`
\r
1057 FOREIGN KEY (`CHILD_ROLE_ID`)
\r
1058 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1059 CONSTRAINT `FK_FN_ROLE_COMPOSITE_PARENT`
\r
1060 FOREIGN KEY (`PARENT_ROLE_ID`)
\r
1061 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`))
\r
1063 DEFAULT CHARACTER SET = utf8;
\r
1065 -- ----------------------------------------------------------------------------
\r
1066 -- Table vid_openecomp_epsdk.fn_role_function
\r
1067 -- ----------------------------------------------------------------------------
\r
1068 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_function` (
\r
1069 `ROLE_ID` INT(11) NOT NULL,
\r
1070 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1071 PRIMARY KEY (`ROLE_ID`, `FUNCTION_CD`),
\r
1072 INDEX `FN_ROLE_FUNCTION_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1073 INDEX `FN_ROLE_FUNCTION_ROLE_ID` (`ROLE_ID` ASC),
\r
1074 CONSTRAINT `FK_FN_ROLE__REF_198_FN_ROLE`
\r
1075 FOREIGN KEY (`ROLE_ID`)
\r
1076 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1077 CONSTRAINT `FK_FN_ROLE__REF_201_FN_FUNCT`
\r
1078 FOREIGN KEY (`FUNCTION_CD`)
\r
1079 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
1081 DEFAULT CHARACTER SET = utf8;
\r
1083 -- ----------------------------------------------------------------------------
\r
1084 -- Table vid_openecomp_epsdk.fn_schedule_workflows
\r
1085 -- ----------------------------------------------------------------------------
\r
1086 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_schedule_workflows` (
\r
1087 `id_schedule_workflows` BIGINT(25) NOT NULL AUTO_INCREMENT,
\r
1088 `workflow_server_url` VARCHAR(45) NULL DEFAULT NULL,
\r
1089 `workflow_key` VARCHAR(45) NOT NULL,
\r
1090 `workflow_arguments` VARCHAR(45) NULL DEFAULT NULL,
\r
1091 `startDateTimeCron` VARCHAR(45) NULL DEFAULT NULL,
\r
1092 `endDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1093 `start_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1094 `recurrence` VARCHAR(45) NULL DEFAULT NULL,
\r
1095 PRIMARY KEY (`id_schedule_workflows`))
\r
1097 DEFAULT CHARACTER SET = utf8;
\r
1099 -- ----------------------------------------------------------------------------
\r
1100 -- Table vid_openecomp_epsdk.fn_tab
\r
1101 -- ----------------------------------------------------------------------------
\r
1102 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab` (
\r
1103 `TAB_CD` VARCHAR(30) NOT NULL,
\r
1104 `TAB_NAME` VARCHAR(50) NOT NULL,
\r
1105 `TAB_DESCR` VARCHAR(100) NULL DEFAULT NULL,
\r
1106 `ACTION` VARCHAR(100) NOT NULL,
\r
1107 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1108 `ACTIVE_YN` CHAR(1) NOT NULL,
\r
1109 `SORT_ORDER` DECIMAL(11,0) NOT NULL,
\r
1110 `PARENT_TAB_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
1111 `TAB_SET_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
1112 PRIMARY KEY (`TAB_CD`),
\r
1113 INDEX `FK_FN_TAB_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1114 INDEX `FK_FN_TAB_SET_CD` (`TAB_SET_CD` ASC),
\r
1115 CONSTRAINT `FK_FN_TAB_FUNCTION_CD`
\r
1116 FOREIGN KEY (`FUNCTION_CD`)
\r
1117 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`),
\r
1118 CONSTRAINT `FK_FN_TAB_SET_CD`
\r
1119 FOREIGN KEY (`TAB_SET_CD`)
\r
1120 REFERENCES `vid_openecomp_epsdk`.`fn_lu_tab_set` (`TAB_SET_CD`))
\r
1122 DEFAULT CHARACTER SET = utf8;
\r
1124 -- ----------------------------------------------------------------------------
\r
1125 -- Table vid_openecomp_epsdk.fn_tab_selected
\r
1126 -- ----------------------------------------------------------------------------
\r
1127 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab_selected` (
\r
1128 `SELECTED_TAB_CD` VARCHAR(30) NOT NULL,
\r
1129 `TAB_URI` VARCHAR(40) NOT NULL,
\r
1130 PRIMARY KEY (`SELECTED_TAB_CD`, `TAB_URI`),
\r
1131 CONSTRAINT `FK_FN_TAB_SELECTED_TAB_CD`
\r
1132 FOREIGN KEY (`SELECTED_TAB_CD`)
\r
1133 REFERENCES `vid_openecomp_epsdk`.`fn_tab` (`TAB_CD`))
\r
1135 DEFAULT CHARACTER SET = utf8;
\r
1137 -- ----------------------------------------------------------------------------
\r
1138 -- Table vid_openecomp_epsdk.fn_user
\r
1139 -- ----------------------------------------------------------------------------
\r
1140 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user` (
\r
1141 `USER_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1142 `ORG_ID` INT(11) NULL DEFAULT NULL,
\r
1143 `MANAGER_ID` INT(11) NULL DEFAULT NULL,
\r
1144 `FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1145 `MIDDLE_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1146 `LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1147 `PHONE` VARCHAR(25) NULL DEFAULT NULL,
\r
1148 `FAX` VARCHAR(25) NULL DEFAULT NULL,
\r
1149 `CELLULAR` VARCHAR(25) NULL DEFAULT NULL,
\r
1150 `EMAIL` VARCHAR(50) NULL DEFAULT NULL,
\r
1151 `ADDRESS_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
1152 `ALERT_METHOD_CD` VARCHAR(10) NULL DEFAULT NULL,
\r
1153 `HRID` VARCHAR(20) NULL DEFAULT NULL,
\r
1154 `ORG_USER_ID` VARCHAR(20) NULL DEFAULT NULL,
\r
1155 `ORG_CODE` VARCHAR(30) NULL DEFAULT NULL,
\r
1156 `LOGIN_ID` VARCHAR(25) NULL DEFAULT NULL,
\r
1157 `LOGIN_PWD` VARCHAR(25) NULL DEFAULT NULL,
\r
1158 `LAST_LOGIN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
1159 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
1160 `CREATED_ID` INT(11) NULL DEFAULT NULL,
\r
1161 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1162 `MODIFIED_ID` INT(11) NULL DEFAULT NULL,
\r
1163 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1164 `IS_INTERNAL_YN` CHAR(1) NOT NULL DEFAULT 'N',
\r
1165 `ADDRESS_LINE_1` VARCHAR(100) NULL DEFAULT NULL,
\r
1166 `ADDRESS_LINE_2` VARCHAR(100) NULL DEFAULT NULL,
\r
1167 `CITY` VARCHAR(50) NULL DEFAULT NULL,
\r
1168 `STATE_CD` VARCHAR(3) NULL DEFAULT NULL,
\r
1169 `ZIP_CODE` VARCHAR(11) NULL DEFAULT NULL,
\r
1170 `COUNTRY_CD` VARCHAR(3) NULL DEFAULT NULL,
\r
1171 `LOCATION_CLLI` VARCHAR(8) NULL DEFAULT NULL,
\r
1172 `ORG_MANAGER_USERID` VARCHAR(20) NULL DEFAULT NULL,
\r
1173 `COMPANY` VARCHAR(100) NULL DEFAULT NULL,
\r
1174 `DEPARTMENT_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
1175 `JOB_TITLE` VARCHAR(100) NULL DEFAULT NULL,
\r
1176 `TIMEZONE` INT(11) NULL DEFAULT NULL,
\r
1177 `DEPARTMENT` VARCHAR(25) NULL DEFAULT NULL,
\r
1178 `BUSINESS_UNIT` VARCHAR(25) NULL DEFAULT NULL,
\r
1179 `BUSINESS_UNIT_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
1180 `COST_CENTER` VARCHAR(25) NULL DEFAULT NULL,
\r
1181 `FIN_LOC_CODE` VARCHAR(10) NULL DEFAULT NULL,
\r
1182 `SILO_STATUS` VARCHAR(10) NULL DEFAULT NULL,
\r
1183 PRIMARY KEY (`USER_ID`),
\r
1184 UNIQUE INDEX `FN_USER_HRID` (`HRID` ASC),
\r
1185 UNIQUE INDEX `FN_USER_LOGIN_ID` (`LOGIN_ID` ASC),
\r
1186 INDEX `FN_USER_ADDRESS_ID` (`ADDRESS_ID` ASC),
\r
1187 INDEX `FN_USER_ALERT_METHOD_CD` (`ALERT_METHOD_CD` ASC),
\r
1188 INDEX `FN_USER_ORG_ID` (`ORG_ID` ASC),
\r
1189 INDEX `FK_FN_USER_REF_197_FN_USER` (`MANAGER_ID` ASC),
\r
1190 INDEX `FK_FN_USER_REF_198_FN_USER` (`CREATED_ID` ASC),
\r
1191 INDEX `FK_FN_USER_REF_199_FN_USER` (`MODIFIED_ID` ASC),
\r
1192 INDEX `FK_TIMEZONE` (`TIMEZONE` ASC),
\r
1193 CONSTRAINT `FK_FN_USER_REF_110_FN_ORG`
\r
1194 FOREIGN KEY (`ORG_ID`)
\r
1195 REFERENCES `vid_openecomp_epsdk`.`fn_org` (`ORG_ID`),
\r
1196 CONSTRAINT `FK_FN_USER_REF_123_FN_LU_AL`
\r
1197 FOREIGN KEY (`ALERT_METHOD_CD`)
\r
1198 REFERENCES `vid_openecomp_epsdk`.`fn_lu_alert_method` (`ALERT_METHOD_CD`),
\r
1199 CONSTRAINT `FK_FN_USER_REF_197_FN_USER`
\r
1200 FOREIGN KEY (`MANAGER_ID`)
\r
1201 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1202 CONSTRAINT `FK_FN_USER_REF_198_FN_USER`
\r
1203 FOREIGN KEY (`CREATED_ID`)
\r
1204 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1205 CONSTRAINT `FK_FN_USER_REF_199_FN_USER`
\r
1206 FOREIGN KEY (`MODIFIED_ID`)
\r
1207 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1208 CONSTRAINT `FK_TIMEZONE`
\r
1209 FOREIGN KEY (`TIMEZONE`)
\r
1210 REFERENCES `vid_openecomp_epsdk`.`fn_lu_timezone` (`TIMEZONE_ID`))
\r
1212 AUTO_INCREMENT = 3
\r
1213 DEFAULT CHARACTER SET = utf8;
\r
1216 -- ----------------------------------------------------------------------------
\r
1217 -- Table vid_openecomp_epsdk.fn_user_pseudo_role
\r
1218 -- ----------------------------------------------------------------------------
\r
1219 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_pseudo_role` (
\r
1220 `PSEUDO_ROLE_ID` INT(11) NOT NULL,
\r
1221 `USER_ID` INT(11) NOT NULL,
\r
1222 PRIMARY KEY (`PSEUDO_ROLE_ID`, `USER_ID`),
\r
1223 INDEX `FK_PSEUDO_ROLE_USER_ID` (`USER_ID` ASC),
\r
1224 CONSTRAINT `FK_PSEUDO_ROLE_PSEUDO_ROLE_ID`
\r
1225 FOREIGN KEY (`PSEUDO_ROLE_ID`)
\r
1226 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1227 CONSTRAINT `FK_PSEUDO_ROLE_USER_ID`
\r
1228 FOREIGN KEY (`USER_ID`)
\r
1229 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
1231 DEFAULT CHARACTER SET = utf8;
\r
1233 -- ----------------------------------------------------------------------------
\r
1234 -- Table vid_openecomp_epsdk.fn_user_role
\r
1235 -- ----------------------------------------------------------------------------
\r
1236 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_role` (
\r
1237 `USER_ID` INT(10) NOT NULL,
\r
1238 `ROLE_ID` INT(10) NOT NULL,
\r
1239 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
\r
1240 `APP_ID` INT(11) NOT NULL DEFAULT '1',
\r
1241 PRIMARY KEY (`USER_ID`, `ROLE_ID`, `APP_ID`),
\r
1242 INDEX `FN_USER_ROLE_ROLE_ID` (`ROLE_ID` ASC),
\r
1243 INDEX `FN_USER_ROLE_USER_ID` (`USER_ID` ASC),
\r
1244 INDEX `FK_FN_USER__REF_178_FN_APP_idx` (`APP_ID` ASC),
\r
1245 CONSTRAINT `FK_FN_USER__REF_172_FN_USER`
\r
1246 FOREIGN KEY (`USER_ID`)
\r
1247 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1248 CONSTRAINT `FK_FN_USER__REF_175_FN_ROLE`
\r
1249 FOREIGN KEY (`ROLE_ID`)
\r
1250 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1251 CONSTRAINT `FK_FN_USER__REF_178_FN_APP`
\r
1252 FOREIGN KEY (`APP_ID`)
\r
1253 REFERENCES `vid_openecomp_epsdk`.`fn_app` (`APP_ID`))
\r
1255 DEFAULT CHARACTER SET = utf8;
\r
1257 -- ----------------------------------------------------------------------------
\r
1258 -- Table vid_openecomp_epsdk.fn_workflow
\r
1259 -- ----------------------------------------------------------------------------
\r
1260 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_workflow` (
\r
1261 `id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
\r
1262 `name` VARCHAR(20) NOT NULL,
\r
1263 `description` VARCHAR(500) NULL DEFAULT NULL,
\r
1264 `run_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1265 `suspend_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1266 `modified_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1267 `active_yn` VARCHAR(300) NULL DEFAULT NULL,
\r
1268 `created` VARCHAR(300) NULL DEFAULT NULL,
\r
1269 `created_by` INT(11) NULL DEFAULT NULL,
\r
1270 `modified` VARCHAR(300) NULL DEFAULT NULL,
\r
1271 `modified_by` INT(11) NULL DEFAULT NULL,
\r
1272 `workflow_key` VARCHAR(50) NULL DEFAULT NULL,
\r
1273 PRIMARY KEY (`id`),
\r
1274 UNIQUE INDEX `name` (`name` ASC))
\r
1276 DEFAULT CHARACTER SET = utf8;
\r
1278 -- ----------------------------------------------------------------------------
\r
1279 -- Table vid_openecomp_epsdk.fn_xmltype
\r
1280 -- ----------------------------------------------------------------------------
\r
1281 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_xmltype` (
\r
1282 `ID` DECIMAL(10,0) NOT NULL,
\r
1283 `XML_DOCUMENT` TEXT NULL DEFAULT NULL,
\r
1284 UNIQUE INDEX `FN_XMLTYPE_ID` (`ID` ASC))
\r
1286 DEFAULT CHARACTER SET = utf8;
\r
1288 -- ----------------------------------------------------------------------------
\r
1289 -- Table vid_openecomp_epsdk.schema_info
\r
1290 -- ----------------------------------------------------------------------------
\r
1291 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`schema_info` (
\r
1292 `SCHEMA_ID` VARCHAR(25) NOT NULL,
\r
1293 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
\r
1294 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
\r
1295 `CONNECTION_URL` VARCHAR(200) NOT NULL,
\r
1296 `USER_NAME` VARCHAR(45) NOT NULL,
\r
1297 `PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
\r
1298 `DRIVER_CLASS` VARCHAR(100) NOT NULL,
\r
1299 `MIN_POOL_SIZE` INT(11) NOT NULL,
\r
1300 `MAX_POOL_SIZE` INT(11) NOT NULL,
\r
1301 `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
\r
1303 DEFAULT CHARACTER SET = utf8;
\r
1304 -- ----------------------------------------------------------------------------
\r
1305 -- Table vid_openecomp_epsdk.vid_vnf
\r
1306 -- ----------------------------------------------------------------------------
\r
1308 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf` (
\r
1309 `VNF_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
\r
1310 `VNF_APP_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\r
1311 `VNF_APP_INVARIANT_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\r
1312 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1313 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1314 PRIMARY KEY (`VNF_DB_ID`),
\r
1315 UNIQUE KEY `vid_vnf_VNF_ID_uindex` (`VNF_APP_UUID`,`VNF_APP_INVARIANT_UUID`)
\r
1316 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
\r
1318 -- ----------------------------------------------------------------------------
\r
1319 -- Table vid_openecomp_epsdk.vid_workflow
\r
1320 -- ----------------------------------------------------------------------------
\r
1322 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_workflow` (
\r
1323 `WORKFLOW_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
\r
1324 `WORKFLOW_APP_NAME` varchar(50) COLLATE utf8_bin NOT NULL,
\r
1325 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1326 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1327 PRIMARY KEY (`WORKFLOW_DB_ID`),
\r
1328 UNIQUE KEY `vid_workflow_workflow_uuid_uindex` (`WORKFLOW_APP_NAME`),
\r
1329 UNIQUE KEY `vid_workflow_WORKFLOW_ID_uindex` (`WORKFLOW_DB_ID`)
\r
1330 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1332 -- ----------------------------------------------------------------------------
\r
1333 -- Table vid_openecomp_epsdk.vid_vnf_workflow
\r
1334 -- ----------------------------------------------------------------------------
\r
1337 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf_workflow` (
\r
1338 `VNF_DB_ID` int(11) NOT NULL,
\r
1339 `WORKFLOW_DB_ID` int(11) NOT NULL,
\r
1340 KEY `vid_vnf_workflow_vid_vnf_VND_ID_fk` (`VNF_DB_ID`),
\r
1341 KEY `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` (`WORKFLOW_DB_ID`),
\r
1342 CONSTRAINT `vid_vnf_workflow_vid_vnf_VND_ID_fk` FOREIGN KEY (`VNF_DB_ID`) REFERENCES `vid_vnf` (`VNF_DB_ID`),
\r
1343 CONSTRAINT `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` FOREIGN KEY (`WORKFLOW_DB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_workflow` (`WORKFLOW_DB_ID`)
\r
1344 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1347 -- ----------------------------------------------------------------------------
\r
1348 -- Table vid_openecomp_epsdk.vid_category_parameter
\r
1349 -- ----------------------------------------------------------------------------
\r
1352 CREATE TABLE IF NOT EXISTS `vid_category_parameter` (
\r
1353 `CATEGORY_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1354 `NAME` VARCHAR(255) NULL COLLATE 'utf8_bin',
\r
1355 `ID_SUPPORTED` TINYINT(1) NOT NULL DEFAULT '0',
\r
1356 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1357 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1358 PRIMARY KEY (`CATEGORY_ID`)
\r
1359 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=5;
\r
1361 -------------------------------------------------------------------------------
\r
1363 ALTER TABLE `vid_category_parameter`
\r
1364 ADD COLUMN if not exists `FAMILY` ENUM('PARAMETER_STANDARDIZATION','TENANT_ISOLATION') NOT NULL DEFAULT 'PARAMETER_STANDARDIZATION' AFTER `ID_SUPPORTED`;
\r
1365 -- ----------------------------------------------------------------------------
\r
1366 -- Table vid_openecomp_epsdk.vid_category_parameter
\r
1367 -- ----------------------------------------------------------------------------
\r
1368 CREATE TABLE IF NOT EXISTS `vid_category_parameter_option` (
\r
1369 `CATEGORY_OPT_DB_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1370 `CATEGORY_OPT_APP_ID` VARCHAR(50) NOT NULL COLLATE 'utf8_bin',
\r
1371 `NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1372 `CATEGORY_ID` INT(11) NOT NULL DEFAULT '0',
\r
1373 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1374 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1375 PRIMARY KEY (`CATEGORY_OPT_DB_ID`),
\r
1376 UNIQUE INDEX `APP_ID_CATEGORY_UNIQUE` (`CATEGORY_ID`, `CATEGORY_OPT_APP_ID`),
\r
1377 UNIQUE INDEX `NAME_CATEGORY_UNIQUE` (`CATEGORY_ID`, `NAME`),
\r
1378 CONSTRAINT `FK_OWNING_ENTITY_OPTIONS_TO_OE` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_category_parameter` (`CATEGORY_ID`)
\r
1379 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=25;
\r
1381 CREATE TABLE IF NOT EXISTS `vid_job` (
\r
1382 `JOB_ID` BINARY(16) NOT NULL PRIMARY KEY,
\r
1383 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1384 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1385 `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1386 `JOB_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1387 `JOB_DATA` MEDIUMTEXT NULL COLLATE 'utf8_bin',
\r
1388 `PARENT_JOB_ID` BINARY(16) NULL,
\r
1389 `TAKEN_BY` VARCHAR(100) NULL COLLATE 'utf8_bin',
\r
1390 CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)
\r
1391 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1393 ALTER TABLE `vid_job`
\r
1394 ADD COLUMN if NOT EXISTS `TAKEN_BY` VARCHAR (100) COLLATE 'utf8_bin';
\r
1395 -- ----------------------------------------------------------------------------
\r
1396 -- View vid_openecomp_epsdk.v_url_access
\r
1397 -- ----------------------------------------------------------------------------
\r
1398 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
1399 SET FOREIGN_KEY_CHECKS = 1;