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
38 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`schema_info` (
\r
39 `SCHEMA_ID` VARCHAR(25) NOT NULL,
\r
40 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
\r
41 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
\r
42 `CONNECTION_URL` VARCHAR(200) NOT NULL,
\r
43 `USER_NAME` VARCHAR(45) NOT NULL,
\r
44 `PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
\r
45 `DRIVER_CLASS` VARCHAR(100) NOT NULL,
\r
46 `MIN_POOL_SIZE` INT(11) NOT NULL,
\r
47 `MAX_POOL_SIZE` INT(11) NOT NULL,
\r
48 `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
\r
50 DEFAULT CHARACTER SET = utf8;
\r
52 -- ----------------------------------------------------------------------------
\r
53 -- Table vid_openecomp_epsdk.cr_favorite_reports
\r
54 -- ----------------------------------------------------------------------------
\r
55 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_favorite_reports` (
\r
56 `USER_ID` INT(11) NOT NULL,
\r
57 `REP_ID` INT(11) NOT NULL,
\r
58 PRIMARY KEY (`USER_ID`, `REP_ID`))
\r
60 DEFAULT CHARACTER SET = utf8;
\r
62 -- ----------------------------------------------------------------------------
\r
63 -- Table vid_openecomp_epsdk.cr_filehist_log
\r
64 -- ----------------------------------------------------------------------------
\r
65 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_filehist_log` (
\r
66 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
67 `URL` VARCHAR(4000) NULL DEFAULT NULL,
\r
68 `NOTES` VARCHAR(3500) NULL DEFAULT NULL,
\r
69 `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
\r
71 DEFAULT CHARACTER SET = utf8;
\r
73 -- ----------------------------------------------------------------------------
\r
74 -- Table vid_openecomp_epsdk.cr_folder
\r
75 -- ----------------------------------------------------------------------------
\r
76 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_folder` (
\r
77 `FOLDER_ID` INT(11) NOT NULL,
\r
78 `FOLDER_NAME` VARCHAR(50) NOT NULL,
\r
79 `DESCR` VARCHAR(500) NULL DEFAULT NULL,
\r
80 `CREATE_ID` INT(11) NOT NULL,
\r
81 `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
82 `PARENT_FOLDER_ID` INT(11) NULL DEFAULT NULL,
\r
83 `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
84 PRIMARY KEY (`FOLDER_ID`),
\r
85 INDEX `FK_PARENT_KEY_CR_FOLDER` (`PARENT_FOLDER_ID` ASC),
\r
86 CONSTRAINT `FK_PARENT_KEY_CR_FOLDER`
\r
87 FOREIGN KEY (`PARENT_FOLDER_ID`)
\r
88 REFERENCES `vid_openecomp_epsdk`.`cr_folder` (`FOLDER_ID`))
\r
90 DEFAULT CHARACTER SET = utf8;
\r
92 -- ----------------------------------------------------------------------------
\r
93 -- Table vid_openecomp_epsdk.cr_folder_access
\r
94 -- ----------------------------------------------------------------------------
\r
95 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_folder_access` (
\r
96 `FOLDER_ACCESS_ID` DECIMAL(11,0) NOT NULL,
\r
97 `FOLDER_ID` DECIMAL(11,0) NOT NULL,
\r
98 `ORDER_NO` DECIMAL(11,0) NOT NULL,
\r
99 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
100 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
101 `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
102 PRIMARY KEY (`FOLDER_ACCESS_ID`))
\r
104 DEFAULT CHARACTER SET = utf8;
\r
106 -- ----------------------------------------------------------------------------
\r
107 -- Table vid_openecomp_epsdk.cr_hist_user_map
\r
108 -- ----------------------------------------------------------------------------
\r
109 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_hist_user_map` (
\r
110 `HIST_ID` INT(11) NOT NULL,
\r
111 `USER_ID` INT(11) NOT NULL,
\r
112 PRIMARY KEY (`HIST_ID`, `USER_ID`),
\r
113 INDEX `SYS_C0014617` (`USER_ID` ASC),
\r
114 CONSTRAINT `SYS_C0014616`
\r
115 FOREIGN KEY (`HIST_ID`)
\r
116 REFERENCES `vid_openecomp_epsdk`.`cr_report_file_history` (`HIST_ID`),
\r
117 CONSTRAINT `SYS_C0014617`
\r
118 FOREIGN KEY (`USER_ID`)
\r
119 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
121 DEFAULT CHARACTER SET = utf8;
\r
123 -- ----------------------------------------------------------------------------
\r
124 -- Table vid_openecomp_epsdk.cr_lu_file_type
\r
125 -- ----------------------------------------------------------------------------
\r
126 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_lu_file_type` (
\r
127 `LOOKUP_ID` DECIMAL(2,0) NOT NULL,
\r
128 `LOOKUP_DESCR` VARCHAR(255) NOT NULL,
\r
129 `ACTIVE_YN` CHAR(1) NULL DEFAULT 'Y',
\r
130 `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL,
\r
131 PRIMARY KEY (`LOOKUP_ID`))
\r
133 DEFAULT CHARACTER SET = utf8;
\r
135 -- ----------------------------------------------------------------------------
\r
136 -- Table vid_openecomp_epsdk.cr_raptor_action_img
\r
137 -- ----------------------------------------------------------------------------
\r
138 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_raptor_action_img` (
\r
139 `IMAGE_ID` VARCHAR(100) NOT NULL,
\r
140 `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL,
\r
141 PRIMARY KEY (`IMAGE_ID`))
\r
143 DEFAULT CHARACTER SET = utf8;
\r
145 -- ----------------------------------------------------------------------------
\r
146 -- Table vid_openecomp_epsdk.cr_raptor_pdf_img
\r
147 -- ----------------------------------------------------------------------------
\r
148 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_raptor_pdf_img` (
\r
149 `IMAGE_ID` VARCHAR(100) NOT NULL,
\r
150 `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL,
\r
151 PRIMARY KEY (`IMAGE_ID`))
\r
153 DEFAULT CHARACTER SET = utf8;
\r
155 -- ----------------------------------------------------------------------------
\r
156 -- Table vid_openecomp_epsdk.cr_remote_schema_info
\r
157 -- ----------------------------------------------------------------------------
\r
158 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_remote_schema_info` (
\r
159 `SCHEMA_PREFIX` VARCHAR(5) NOT NULL,
\r
160 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
\r
161 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
\r
162 PRIMARY KEY (`SCHEMA_PREFIX`))
\r
164 DEFAULT CHARACTER SET = utf8;
\r
166 -- ----------------------------------------------------------------------------
\r
167 -- Table vid_openecomp_epsdk.cr_report
\r
168 -- ----------------------------------------------------------------------------
\r
169 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report` (
\r
170 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
171 `TITLE` VARCHAR(100) NOT NULL,
\r
172 `DESCR` VARCHAR(255) NULL DEFAULT NULL,
\r
173 `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
174 `REPORT_XML` TEXT NULL DEFAULT NULL,
\r
175 `CREATE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
176 `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
177 `MAINT_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
178 `MAINT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
179 `MENU_ID` VARCHAR(500) NULL DEFAULT NULL,
\r
180 `MENU_APPROVED_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
181 `OWNER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
182 `FOLDER_ID` INT(11) NULL DEFAULT '0',
\r
183 `DASHBOARD_TYPE_YN` VARCHAR(1) NULL DEFAULT 'N',
\r
184 `DASHBOARD_YN` VARCHAR(1) NULL DEFAULT 'N',
\r
185 PRIMARY KEY (`REP_ID`),
\r
186 INDEX `CR_REPORT_CREATE_IDPUBLIC_YNTITLE` (`CREATE_ID` ASC, `PUBLIC_YN` ASC, `TITLE` ASC))
\r
188 DEFAULT CHARACTER SET = utf8;
\r
190 -- ----------------------------------------------------------------------------
\r
191 -- Table vid_openecomp_epsdk.cr_report_access
\r
192 -- ----------------------------------------------------------------------------
\r
193 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_access` (
\r
194 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
195 `ORDER_NO` DECIMAL(11,0) NOT NULL,
\r
196 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
197 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
198 `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
199 PRIMARY KEY (`REP_ID`, `ORDER_NO`),
\r
200 CONSTRAINT `FK_CR_REPOR_REF_8550_CR_REPOR`
\r
201 FOREIGN KEY (`REP_ID`)
\r
202 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
204 DEFAULT CHARACTER SET = utf8;
\r
206 -- ----------------------------------------------------------------------------
\r
207 -- Table vid_openecomp_epsdk.cr_report_dwnld_log
\r
208 -- ----------------------------------------------------------------------------
\r
209 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_dwnld_log` (
\r
210 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
211 `REP_ID` INT(11) NOT NULL,
\r
212 `FILE_NAME` VARCHAR(100) NOT NULL,
\r
213 `DWNLD_START_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
214 `RECORD_READY_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
215 `FILTER_PARAMS` VARCHAR(2000) NULL DEFAULT NULL)
\r
217 DEFAULT CHARACTER SET = utf8;
\r
219 -- ----------------------------------------------------------------------------
\r
220 -- Table vid_openecomp_epsdk.cr_report_email_sent_log
\r
221 -- ----------------------------------------------------------------------------
\r
222 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_email_sent_log` (
\r
223 `LOG_ID` INT(11) NOT NULL,
\r
224 `SCHEDULE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
225 `GEN_KEY` VARCHAR(25) NOT NULL,
\r
226 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
227 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
228 `SENT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
229 `ACCESS_FLAG` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
230 `TOUCH_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
231 PRIMARY KEY (`LOG_ID`),
\r
232 INDEX `FK_CR_REPORT_REP_ID` (`REP_ID` ASC),
\r
233 CONSTRAINT `FK_CR_REPORT_REP_ID`
\r
234 FOREIGN KEY (`REP_ID`)
\r
235 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
237 DEFAULT CHARACTER SET = utf8;
\r
239 -- ----------------------------------------------------------------------------
\r
240 -- Table vid_openecomp_epsdk.cr_report_file_history
\r
241 -- ----------------------------------------------------------------------------
\r
242 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_file_history` (
\r
243 `HIST_ID` INT(11) NOT NULL,
\r
244 `SCHED_USER_ID` DECIMAL(11,0) NOT NULL,
\r
245 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
246 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
247 `REP_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
248 `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
249 `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL,
\r
250 `FILE_TYPE_ID` DECIMAL(2,0) NULL DEFAULT NULL,
\r
251 `FILE_NAME` VARCHAR(80) NULL DEFAULT NULL,
\r
252 `FILE_BLOB` BLOB NULL DEFAULT NULL,
\r
253 `FILE_SIZE` DECIMAL(11,0) NULL DEFAULT NULL,
\r
254 `RAPTOR_URL` VARCHAR(4000) NULL DEFAULT NULL,
\r
255 `ERROR_YN` CHAR(1) NULL DEFAULT 'N',
\r
256 `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL,
\r
257 `DELETED_YN` CHAR(1) NULL DEFAULT 'N',
\r
258 `DELETED_BY` DECIMAL(38,0) NULL DEFAULT NULL,
\r
259 PRIMARY KEY (`HIST_ID`),
\r
260 INDEX `SYS_C0014614` (`FILE_TYPE_ID` ASC),
\r
261 INDEX `SYS_C0014615` (`REP_ID` ASC),
\r
262 CONSTRAINT `SYS_C0014614`
\r
263 FOREIGN KEY (`FILE_TYPE_ID`)
\r
264 REFERENCES `vid_openecomp_epsdk`.`cr_lu_file_type` (`LOOKUP_ID`),
\r
265 CONSTRAINT `SYS_C0014615`
\r
266 FOREIGN KEY (`REP_ID`)
\r
267 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
269 DEFAULT CHARACTER SET = utf8;
\r
271 -- ----------------------------------------------------------------------------
\r
272 -- Table vid_openecomp_epsdk.cr_report_log
\r
273 -- ----------------------------------------------------------------------------
\r
274 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_log` (
\r
275 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
276 `LOG_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
277 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
278 `ACTION` VARCHAR(2000) NOT NULL,
\r
279 `ACTION_VALUE` VARCHAR(50) NULL DEFAULT NULL,
\r
280 `FORM_FIELDS` VARCHAR(4000) NULL DEFAULT NULL,
\r
281 INDEX `FK_CR_REPOR_REF_17645_CR_REPOR` (`REP_ID` ASC),
\r
282 CONSTRAINT `FK_CR_REPOR_REF_17645_CR_REPOR`
\r
283 FOREIGN KEY (`REP_ID`)
\r
284 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
286 DEFAULT CHARACTER SET = utf8;
\r
288 -- ----------------------------------------------------------------------------
\r
289 -- Table vid_openecomp_epsdk.cr_report_schedule
\r
290 -- ----------------------------------------------------------------------------
\r
291 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_schedule` (
\r
292 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
293 `SCHED_USER_ID` DECIMAL(11,0) NOT NULL,
\r
294 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
295 `ENABLED_YN` VARCHAR(1) NOT NULL,
\r
296 `START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
297 `END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
298 `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
299 `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL,
\r
300 `CONDITIONAL_YN` VARCHAR(1) NOT NULL,
\r
301 `CONDITION_SQL` VARCHAR(4000) NULL DEFAULT NULL,
\r
302 `NOTIFY_TYPE` INT(11) NULL DEFAULT '0',
\r
303 `MAX_ROW` INT(11) NULL DEFAULT '1000',
\r
304 `INITIAL_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
\r
305 `PROCESSED_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
\r
306 `FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
\r
307 `CONDITION_LARGE_SQL` TEXT NULL DEFAULT NULL,
\r
308 `ENCRYPT_YN` CHAR(1) NULL DEFAULT 'N',
\r
309 `ATTACHMENT_YN` CHAR(1) NULL DEFAULT 'Y',
\r
310 PRIMARY KEY (`SCHEDULE_ID`),
\r
311 INDEX `FK_CR_REPOR_REF_14707_CR_REPOR` (`REP_ID` ASC),
\r
312 CONSTRAINT `FK_CR_REPOR_REF_14707_CR_REPOR`
\r
313 FOREIGN KEY (`REP_ID`)
\r
314 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
\r
316 DEFAULT CHARACTER SET = utf8;
\r
318 -- ----------------------------------------------------------------------------
\r
319 -- Table vid_openecomp_epsdk.cr_report_schedule_users
\r
320 -- ----------------------------------------------------------------------------
\r
321 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_schedule_users` (
\r
322 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
323 `REP_ID` DECIMAL(11,0) NOT NULL,
\r
324 `USER_ID` DECIMAL(11,0) NOT NULL,
\r
325 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
326 `ORDER_NO` DECIMAL(11,0) NOT NULL,
\r
327 PRIMARY KEY (`SCHEDULE_ID`, `REP_ID`, `USER_ID`, `ORDER_NO`),
\r
328 CONSTRAINT `FK_CR_REPOR_REF_14716_CR_REPOR`
\r
329 FOREIGN KEY (`SCHEDULE_ID`)
\r
330 REFERENCES `vid_openecomp_epsdk`.`cr_report_schedule` (`SCHEDULE_ID`))
\r
332 DEFAULT CHARACTER SET = utf8;
\r
334 -- ----------------------------------------------------------------------------
\r
335 -- Table vid_openecomp_epsdk.cr_report_template_map
\r
336 -- ----------------------------------------------------------------------------
\r
337 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_report_template_map` (
\r
338 `REPORT_ID` INT(11) NOT NULL,
\r
339 `TEMPLATE_FILE` VARCHAR(200) NULL DEFAULT NULL,
\r
340 PRIMARY KEY (`REPORT_ID`))
\r
342 DEFAULT CHARACTER SET = utf8;
\r
344 -- ----------------------------------------------------------------------------
\r
345 -- Table vid_openecomp_epsdk.cr_schedule_activity_log
\r
346 -- ----------------------------------------------------------------------------
\r
347 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_schedule_activity_log` (
\r
348 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
\r
349 `URL` VARCHAR(4000) NULL DEFAULT NULL,
\r
350 `NOTES` VARCHAR(2000) NULL DEFAULT NULL,
\r
351 `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
\r
353 DEFAULT CHARACTER SET = utf8;
\r
355 -- ----------------------------------------------------------------------------
\r
356 -- Table vid_openecomp_epsdk.cr_table_join
\r
357 -- ----------------------------------------------------------------------------
\r
358 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_table_join` (
\r
359 `SRC_TABLE_NAME` VARCHAR(30) NOT NULL,
\r
360 `DEST_TABLE_NAME` VARCHAR(30) NOT NULL,
\r
361 `JOIN_EXPR` VARCHAR(500) NOT NULL,
\r
362 INDEX `CR_TABLE_JOIN_DEST_TABLE_NAME` (`DEST_TABLE_NAME` ASC),
\r
363 INDEX `CR_TABLE_JOIN_SRC_TABLE_NAME` (`SRC_TABLE_NAME` ASC),
\r
364 CONSTRAINT `FK_CR_TABLE_REF_311_CR_TAB`
\r
365 FOREIGN KEY (`SRC_TABLE_NAME`)
\r
366 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`),
\r
367 CONSTRAINT `FK_CR_TABLE_REF_315_CR_TAB`
\r
368 FOREIGN KEY (`DEST_TABLE_NAME`)
\r
369 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`))
\r
371 DEFAULT CHARACTER SET = utf8;
\r
373 -- ----------------------------------------------------------------------------
\r
374 -- Table vid_openecomp_epsdk.cr_table_role
\r
375 -- ----------------------------------------------------------------------------
\r
376 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_table_role` (
\r
377 `TABLE_NAME` VARCHAR(30) NOT NULL,
\r
378 `ROLE_ID` DECIMAL(11,0) NOT NULL,
\r
379 PRIMARY KEY (`TABLE_NAME`, `ROLE_ID`),
\r
380 CONSTRAINT `FK_CR_TABLE_REF_32384_CR_TABLE`
\r
381 FOREIGN KEY (`TABLE_NAME`)
\r
382 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`))
\r
384 DEFAULT CHARACTER SET = utf8;
\r
386 -- ----------------------------------------------------------------------------
\r
387 -- Table vid_openecomp_epsdk.cr_table_source
\r
388 -- ----------------------------------------------------------------------------
\r
389 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`cr_table_source` (
\r
390 `TABLE_NAME` VARCHAR(30) NOT NULL,
\r
391 `DISPLAY_NAME` VARCHAR(30) NOT NULL,
\r
392 `PK_FIELDS` VARCHAR(200) NULL DEFAULT NULL,
\r
393 `WEB_VIEW_ACTION` VARCHAR(50) NULL DEFAULT NULL,
\r
394 `LARGE_DATA_SOURCE_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
\r
395 `FILTER_SQL` VARCHAR(4000) NULL DEFAULT NULL,
\r
396 `SOURCE_DB` VARCHAR(50) NULL DEFAULT NULL,
\r
397 PRIMARY KEY (`TABLE_NAME`))
\r
399 DEFAULT CHARACTER SET = utf8;
\r
401 -- ----------------------------------------------------------------------------
\r
402 -- Table vid_portal.fn_app
\r
403 -- ----------------------------------------------------------------------------
\r
404 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_app` (
\r
405 `APP_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
406 `APP_NAME` VARCHAR(100) NOT NULL DEFAULT '?',
\r
407 `APP_IMAGE_URL` VARCHAR(256) NULL DEFAULT NULL,
\r
408 `APP_DESCRIPTION` VARCHAR(512) NULL DEFAULT NULL,
\r
409 `APP_NOTES` VARCHAR(4096) NULL DEFAULT NULL,
\r
410 `APP_URL` VARCHAR(256) NULL DEFAULT NULL,
\r
411 `APP_ALTERNATE_URL` VARCHAR(256) NULL DEFAULT NULL,
\r
412 `APP_REST_ENDPOINT` VARCHAR(2000) NULL DEFAULT NULL,
\r
413 `ML_APP_NAME` VARCHAR(50) NOT NULL DEFAULT '?',
\r
414 `ML_APP_ADMIN_ID` VARCHAR(7) NOT NULL DEFAULT '?',
\r
415 `MOTS_ID` INT(11) NULL DEFAULT NULL,
\r
416 `APP_PASSWORD` VARCHAR(256) NOT NULL DEFAULT '?',
\r
417 `OPEN` CHAR(1) NULL DEFAULT 'N',
\r
418 `ENABLED` CHAR(1) NULL DEFAULT 'Y',
\r
419 `THUMBNAIL` MEDIUMBLOB NULL DEFAULT NULL,
\r
420 `APP_USERNAME` VARCHAR(50) NULL DEFAULT NULL,
\r
421 `UEB_KEY` VARCHAR(256) NULL DEFAULT NULL,
\r
422 `UEB_SECRET` VARCHAR(256) NULL DEFAULT NULL,
\r
423 `UEB_TOPIC_NAME` VARCHAR(256) NULL DEFAULT NULL,
\r
424 PRIMARY KEY (`APP_ID`))
\r
427 DEFAULT CHARACTER SET = utf8;
\r
429 -- ----------------------------------------------------------------------------
\r
430 -- Table vid_openecomp_epsdk.fn_app_mme_cpu
\r
431 -- ----------------------------------------------------------------------------
\r
432 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_app_mme_cpu` (
\r
433 `MME` VARCHAR(200) NULL DEFAULT NULL,
\r
434 `YEARMONTH` INT(11) NULL DEFAULT NULL,
\r
435 `SCTP_CPU` INT(11) NULL DEFAULT NULL,
\r
436 `AP_CPU` INT(11) NULL DEFAULT NULL,
\r
437 `DP_CPU` INT(11) NULL DEFAULT NULL,
\r
438 `ROUTER_CPU` INT(11) NULL DEFAULT NULL,
\r
439 `PEB_CPU` INT(11) NULL DEFAULT NULL,
\r
440 `SAU` INT(11) NULL DEFAULT NULL)
\r
442 DEFAULT CHARACTER SET = utf8;
\r
444 -- ----------------------------------------------------------------------------
\r
445 -- Table vid_openecomp_epsdk.fn_audit_action
\r
446 -- ----------------------------------------------------------------------------
\r
447 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_action` (
\r
448 `AUDIT_ACTION_ID` INT(11) NOT NULL,
\r
449 `CLASS_NAME` VARCHAR(500) NOT NULL,
\r
450 `METHOD_NAME` VARCHAR(50) NOT NULL,
\r
451 `AUDIT_ACTION_CD` VARCHAR(20) NOT NULL,
\r
452 `AUDIT_ACTION_DESC` VARCHAR(200) NULL DEFAULT NULL,
\r
453 `ACTIVE_YN` VARCHAR(1) NULL DEFAULT NULL,
\r
454 PRIMARY KEY (`AUDIT_ACTION_ID`))
\r
456 DEFAULT CHARACTER SET = utf8;
\r
458 -- ----------------------------------------------------------------------------
\r
459 -- Table vid_openecomp_epsdk.fn_audit_action_log
\r
460 -- ----------------------------------------------------------------------------
\r
461 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_action_log` (
\r
462 `AUDIT_LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
463 `AUDIT_ACTION_CD` VARCHAR(200) NULL DEFAULT NULL,
\r
464 `ACTION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
465 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
466 `CLASS_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
467 `METHOD_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
468 `SUCCESS_MSG` VARCHAR(20) NULL DEFAULT NULL,
\r
469 `ERROR_MSG` VARCHAR(500) NULL DEFAULT NULL,
\r
470 PRIMARY KEY (`AUDIT_LOG_ID`))
\r
472 DEFAULT CHARACTER SET = utf8;
\r
474 -- ----------------------------------------------------------------------------
\r
475 -- Table vid_openecomp_epsdk.fn_audit_log
\r
476 -- ----------------------------------------------------------------------------
\r
477 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_log` (
\r
478 `LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
479 `USER_ID` INT(11) NOT NULL,
\r
480 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
\r
481 `AUDIT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
482 `COMMENTS` VARCHAR(1000) NULL DEFAULT NULL,
\r
483 `AFFECTED_RECORD_ID_BK` VARCHAR(500) NULL DEFAULT NULL,
\r
484 `AFFECTED_RECORD_ID` VARCHAR(4000) NULL DEFAULT NULL,
\r
485 PRIMARY KEY (`LOG_ID`),
\r
486 INDEX `FN_AUDIT_LOG_ACTIVITY_CD` (`ACTIVITY_CD` ASC),
\r
487 INDEX `FN_AUDIT_LOG_USER_ID` (`USER_ID` ASC),
\r
488 CONSTRAINT `FK_FN_AUDIT_REF_205_FN_LU_AC`
\r
489 FOREIGN KEY (`ACTIVITY_CD`)
\r
490 REFERENCES `vid_openecomp_epsdk`.`fn_lu_activity` (`ACTIVITY_CD`),
\r
491 CONSTRAINT `FK_FN_AUDIT_REF_209_FN_USER`
\r
492 FOREIGN KEY (`USER_ID`)
\r
493 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
495 DEFAULT CHARACTER SET = utf8;
\r
497 -- ----------------------------------------------------------------------------
\r
498 -- Table vid_openecomp_epsdk.fn_broadcast_message
\r
499 -- ----------------------------------------------------------------------------
\r
500 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_broadcast_message` (
\r
501 `MESSAGE_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
502 `MESSAGE_TEXT` VARCHAR(1000) NOT NULL,
\r
503 `MESSAGE_LOCATION_ID` DECIMAL(11,0) NOT NULL,
\r
504 `BROADCAST_START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
505 `BROADCAST_END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
506 `ACTIVE_YN` CHAR(1) NOT NULL DEFAULT 'Y',
\r
507 `SORT_ORDER` DECIMAL(4,0) NOT NULL,
\r
508 `BROADCAST_SITE_CD` VARCHAR(50) NULL DEFAULT NULL,
\r
509 PRIMARY KEY (`MESSAGE_ID`))
\r
511 DEFAULT CHARACTER SET = utf8;
\r
513 -- ----------------------------------------------------------------------------
\r
514 -- Table vid_openecomp_epsdk.fn_chat_logs
\r
515 -- ----------------------------------------------------------------------------
\r
516 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_logs` (
\r
517 `CHAT_LOG_ID` INT(11) NOT NULL,
\r
518 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
\r
519 `USER_ID` INT(11) NULL DEFAULT NULL,
\r
520 `MESSAGE` VARCHAR(1000) NULL DEFAULT NULL,
\r
521 `MESSAGE_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
522 PRIMARY KEY (`CHAT_LOG_ID`))
\r
524 DEFAULT CHARACTER SET = utf8;
\r
526 -- ----------------------------------------------------------------------------
\r
527 -- Table vid_openecomp_epsdk.fn_chat_room
\r
528 -- ----------------------------------------------------------------------------
\r
529 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_room` (
\r
530 `CHAT_ROOM_ID` INT(11) NOT NULL,
\r
531 `NAME` VARCHAR(50) NOT NULL,
\r
532 `DESCRIPTION` VARCHAR(500) NULL DEFAULT NULL,
\r
533 `OWNER_ID` INT(11) NULL DEFAULT NULL,
\r
534 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
535 `UPDATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
536 PRIMARY KEY (`CHAT_ROOM_ID`))
\r
538 DEFAULT CHARACTER SET = utf8;
\r
540 -- ----------------------------------------------------------------------------
\r
541 -- Table vid_openecomp_epsdk.fn_chat_users
\r
542 -- ----------------------------------------------------------------------------
\r
543 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_users` (
\r
544 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
\r
545 `USER_ID` INT(11) NULL DEFAULT NULL,
\r
546 `LAST_ACTIVITY_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
547 `CHAT_STATUS` VARCHAR(20) NULL DEFAULT NULL,
\r
548 `ID` INT(11) NOT NULL,
\r
549 PRIMARY KEY (`ID`))
\r
551 DEFAULT CHARACTER SET = utf8;
\r
553 -- ----------------------------------------------------------------------------
\r
554 -- Table vid_openecomp_epsdk.fn_datasource
\r
555 -- ----------------------------------------------------------------------------
\r
556 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_datasource` (
\r
557 `ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
558 `NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
559 `DRIVER_NAME` VARCHAR(256) NULL DEFAULT NULL,
\r
560 `SERVER` VARCHAR(256) NULL DEFAULT NULL,
\r
561 `PORT` INT(11) NULL DEFAULT NULL,
\r
562 `USER_NAME` VARCHAR(256) NULL DEFAULT NULL,
\r
563 `PASSWORD` VARCHAR(256) NULL DEFAULT NULL,
\r
564 `URL` VARCHAR(256) NULL DEFAULT NULL,
\r
565 `MIN_POOL_SIZE` INT(11) NULL DEFAULT NULL,
\r
566 `MAX_POOL_SIZE` INT(11) NULL DEFAULT NULL,
\r
567 `ADAPTER_ID` INT(11) NULL DEFAULT NULL,
\r
568 `DS_TYPE` VARCHAR(20) NULL DEFAULT NULL,
\r
569 PRIMARY KEY (`ID`))
\r
572 DEFAULT CHARACTER SET = utf8;
\r
574 -- ----------------------------------------------------------------------------
\r
575 -- Table vid_openecomp_epsdk.fn_function
\r
576 -- ----------------------------------------------------------------------------
\r
577 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_function` (
\r
578 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
579 `FUNCTION_NAME` VARCHAR(50) NOT NULL,
\r
580 `type` VARCHAR(20) NOT NULL,
\r
581 `action` VARCHAR(20) NOT NULL,
\r
582 PRIMARY KEY (`FUNCTION_CD`),
\r
583 CONSTRAINT `function` UNIQUE (FUNCTION_CD,TYPE,ACTION))
\r
585 DEFAULT CHARACTER SET = utf8;
\r
587 -- ----------------------------------------------------------------------------
\r
588 -- Table vid_openecomp_epsdk.fn_license
\r
589 -- ----------------------------------------------------------------------------
\r
590 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license` (
\r
591 `id` DECIMAL(11,0) NOT NULL,
\r
592 `app_id` DECIMAL(11,0) NOT NULL,
\r
593 `ip_address` VARCHAR(100) NOT NULL,
\r
594 `quantum_version_id` DECIMAL(11,0) NOT NULL,
\r
595 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
596 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
597 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
598 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
599 `end_date` TIMESTAMP NOT NULL DEFAULT '2036-01-19 03:14:07',
\r
600 PRIMARY KEY (`id`),
\r
601 INDEX `fn_license_r02` (`quantum_version_id` ASC),
\r
602 CONSTRAINT `fn_license_r02`
\r
603 FOREIGN KEY (`quantum_version_id`)
\r
604 REFERENCES `vid_openecomp_epsdk`.`fn_license_version` (`id`))
\r
606 DEFAULT CHARACTER SET = utf8;
\r
608 -- ----------------------------------------------------------------------------
\r
609 -- Table vid_openecomp_epsdk.fn_license_app
\r
610 -- ----------------------------------------------------------------------------
\r
611 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_app` (
\r
612 `id` DECIMAL(11,0) NOT NULL,
\r
613 `app_name` VARCHAR(100) NOT NULL,
\r
614 `ctxt_name` VARCHAR(100) NULL DEFAULT NULL,
\r
615 INDEX `fn_license_app_ID` (`id` ASC))
\r
617 DEFAULT CHARACTER SET = utf8;
\r
619 -- ----------------------------------------------------------------------------
\r
620 -- Table vid_openecomp_epsdk.fn_license_contact
\r
621 -- ----------------------------------------------------------------------------
\r
622 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_contact` (
\r
623 `id` INT(11) NOT NULL,
\r
624 `license_id` INT(11) NULL DEFAULT NULL,
\r
625 `sbcid` VARCHAR(20) NULL DEFAULT NULL,
\r
626 PRIMARY KEY (`id`))
\r
628 DEFAULT CHARACTER SET = utf8;
\r
630 -- ----------------------------------------------------------------------------
\r
631 -- Table vid_openecomp_epsdk.fn_license_history
\r
632 -- ----------------------------------------------------------------------------
\r
633 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_history` (
\r
634 `license_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
635 `app_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
636 `ip_address` VARCHAR(100) NULL DEFAULT NULL,
\r
637 `quantum_version_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
638 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
639 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
640 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
641 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
\r
642 `id` DECIMAL(11,0) NOT NULL,
\r
643 PRIMARY KEY (`id`))
\r
645 DEFAULT CHARACTER SET = utf8;
\r
647 -- ----------------------------------------------------------------------------
\r
648 -- Table vid_openecomp_epsdk.fn_license_version
\r
649 -- ----------------------------------------------------------------------------
\r
650 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_version` (
\r
651 `id` DECIMAL(11,0) NOT NULL,
\r
652 `quantum_version` VARCHAR(25) NULL DEFAULT NULL,
\r
653 PRIMARY KEY (`id`))
\r
655 DEFAULT CHARACTER SET = utf8;
\r
657 -- ----------------------------------------------------------------------------
\r
658 -- Table vid_openecomp_epsdk.fn_lu_activity
\r
659 -- ----------------------------------------------------------------------------
\r
660 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_activity` (
\r
661 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
\r
662 `ACTIVITY` VARCHAR(50) NOT NULL,
\r
663 PRIMARY KEY (`ACTIVITY_CD`))
\r
665 DEFAULT CHARACTER SET = utf8;
\r
667 -- ----------------------------------------------------------------------------
\r
668 -- Table vid_openecomp_epsdk.fn_lu_alert_method
\r
669 -- ----------------------------------------------------------------------------
\r
670 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_alert_method` (
\r
671 `ALERT_METHOD_CD` VARCHAR(10) NOT NULL,
\r
672 `ALERT_METHOD` VARCHAR(50) NOT NULL,
\r
673 PRIMARY KEY (`ALERT_METHOD_CD`))
\r
675 DEFAULT CHARACTER SET = utf8;
\r
677 -- ----------------------------------------------------------------------------
\r
678 -- Table vid_openecomp_epsdk.fn_lu_broadcast_site
\r
679 -- ----------------------------------------------------------------------------
\r
680 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_broadcast_site` (
\r
681 `BROADCAST_SITE_CD` VARCHAR(50) NOT NULL,
\r
682 `BROADCAST_SITE_DESCR` VARCHAR(100) NULL DEFAULT NULL,
\r
683 PRIMARY KEY (`BROADCAST_SITE_CD`))
\r
685 DEFAULT CHARACTER SET = utf8;
\r
687 -- ----------------------------------------------------------------------------
\r
688 -- Table vid_openecomp_epsdk.fn_lu_call_times
\r
689 -- ----------------------------------------------------------------------------
\r
690 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_call_times` (
\r
691 `CALL_TIME_ID` DECIMAL(10,0) NOT NULL,
\r
692 `CALL_TIME_AMOUNT` DECIMAL(10,0) NOT NULL,
\r
693 `CALL_TIME_DISPLAY` VARCHAR(50) NOT NULL,
\r
694 PRIMARY KEY (`CALL_TIME_ID`))
\r
696 DEFAULT CHARACTER SET = utf8;
\r
698 -- ----------------------------------------------------------------------------
\r
699 -- Table vid_openecomp_epsdk.fn_lu_city
\r
700 -- ----------------------------------------------------------------------------
\r
701 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_city` (
\r
702 `CITY_CD` VARCHAR(2) NOT NULL,
\r
703 `CITY` VARCHAR(100) NOT NULL,
\r
704 `STATE_CD` VARCHAR(2) NOT NULL,
\r
705 PRIMARY KEY (`CITY_CD`, `STATE_CD`))
\r
707 DEFAULT CHARACTER SET = utf8;
\r
709 -- ----------------------------------------------------------------------------
\r
710 -- Table vid_openecomp_epsdk.fn_lu_country
\r
711 -- ----------------------------------------------------------------------------
\r
712 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_country` (
\r
713 `COUNTRY_CD` VARCHAR(3) NOT NULL,
\r
714 `COUNTRY` VARCHAR(100) NOT NULL,
\r
715 `FULL_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
716 `WEBPHONE_COUNTRY_LABEL` VARCHAR(30) NULL DEFAULT NULL,
\r
717 PRIMARY KEY (`COUNTRY_CD`))
\r
719 DEFAULT CHARACTER SET = utf8;
\r
721 -- ----------------------------------------------------------------------------
\r
722 -- Table vid_openecomp_epsdk.fn_lu_menu_set
\r
723 -- ----------------------------------------------------------------------------
\r
724 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_menu_set` (
\r
725 `MENU_SET_CD` VARCHAR(10) NOT NULL,
\r
726 `MENU_SET_NAME` VARCHAR(50) NOT NULL,
\r
727 PRIMARY KEY (`MENU_SET_CD`))
\r
729 DEFAULT CHARACTER SET = utf8;
\r
731 -- ----------------------------------------------------------------------------
\r
732 -- Table vid_openecomp_epsdk.fn_lu_priority
\r
733 -- ----------------------------------------------------------------------------
\r
734 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_priority` (
\r
735 `PRIORITY_ID` DECIMAL(11,0) NOT NULL,
\r
736 `PRIORITY` VARCHAR(50) NOT NULL,
\r
737 `ACTIVE_YN` CHAR(1) NOT NULL,
\r
738 `SORT_ORDER` DECIMAL(5,0) NULL DEFAULT NULL,
\r
739 PRIMARY KEY (`PRIORITY_ID`))
\r
741 DEFAULT CHARACTER SET = utf8;
\r
743 -- ----------------------------------------------------------------------------
\r
744 -- Table vid_openecomp_epsdk.fn_lu_role_type
\r
745 -- ----------------------------------------------------------------------------
\r
746 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_role_type` (
\r
747 `ROLE_TYPE_ID` DECIMAL(11,0) NOT NULL,
\r
748 `ROLE_TYPE` VARCHAR(50) NOT NULL,
\r
749 PRIMARY KEY (`ROLE_TYPE_ID`))
\r
751 DEFAULT CHARACTER SET = utf8;
\r
753 -- ----------------------------------------------------------------------------
\r
754 -- Table vid_openecomp_epsdk.fn_lu_state
\r
755 -- ----------------------------------------------------------------------------
\r
756 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_state` (
\r
757 `STATE_CD` VARCHAR(2) NOT NULL,
\r
758 `STATE` VARCHAR(100) NOT NULL,
\r
759 PRIMARY KEY (`STATE_CD`))
\r
761 DEFAULT CHARACTER SET = utf8;
\r
763 -- ----------------------------------------------------------------------------
\r
764 -- Table vid_openecomp_epsdk.fn_lu_tab_set
\r
765 -- ----------------------------------------------------------------------------
\r
766 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_tab_set` (
\r
767 `TAB_SET_CD` VARCHAR(30) NOT NULL,
\r
768 `TAB_SET_NAME` VARCHAR(50) NOT NULL,
\r
769 PRIMARY KEY (`TAB_SET_CD`))
\r
771 DEFAULT CHARACTER SET = utf8;
\r
773 -- ----------------------------------------------------------------------------
\r
774 -- Table vid_openecomp_epsdk.fn_lu_timezone
\r
775 -- ----------------------------------------------------------------------------
\r
776 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_timezone` (
\r
777 `TIMEZONE_ID` INT(11) NOT NULL,
\r
778 `TIMEZONE_NAME` VARCHAR(100) NOT NULL,
\r
779 `TIMEZONE_VALUE` VARCHAR(100) NOT NULL,
\r
780 PRIMARY KEY (`TIMEZONE_ID`))
\r
782 DEFAULT CHARACTER SET = utf8;
\r
784 -- ----------------------------------------------------------------------------
\r
785 -- Table vid_openecomp_epsdk.fn_menu
\r
786 -- ----------------------------------------------------------------------------
\r
787 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_menu` (
\r
788 `MENU_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
789 `LABEL` VARCHAR(100) NULL DEFAULT NULL,
\r
790 `PARENT_ID` INT(11) NULL DEFAULT NULL,
\r
791 `SORT_ORDER` DECIMAL(4,0) NULL DEFAULT NULL,
\r
792 `ACTION` VARCHAR(200) NULL DEFAULT NULL,
\r
793 `FUNCTION_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
794 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
795 `SERVLET` VARCHAR(50) NULL DEFAULT NULL,
\r
796 `QUERY_STRING` VARCHAR(200) NULL DEFAULT NULL,
\r
797 `EXTERNAL_URL` VARCHAR(200) NULL DEFAULT NULL,
\r
798 `TARGET` VARCHAR(25) NULL DEFAULT NULL,
\r
799 `MENU_SET_CD` VARCHAR(10) NULL DEFAULT 'APP',
\r
800 `SEPARATOR_YN` CHAR(1) NULL DEFAULT 'N',
\r
801 `IMAGE_SRC` VARCHAR(100) NULL DEFAULT NULL,
\r
802 PRIMARY KEY (`MENU_ID`),
\r
803 INDEX `FK_FN_MENU_REF_196_FN_MENU` (`PARENT_ID` ASC),
\r
804 INDEX `FK_FN_MENU_MENU_SET_CD` (`MENU_SET_CD` ASC),
\r
805 INDEX `FN_MENU_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
806 CONSTRAINT `FK_FN_MENU_MENU_SET_CD`
\r
807 FOREIGN KEY (`MENU_SET_CD`)
\r
808 REFERENCES `vid_openecomp_epsdk`.`fn_lu_menu_set` (`MENU_SET_CD`),
\r
809 CONSTRAINT `FK_FN_MENU_REF_196_FN_MENU`
\r
810 FOREIGN KEY (`PARENT_ID`)
\r
811 REFERENCES `vid_openecomp_epsdk`.`fn_menu` (`MENU_ID`),
\r
812 CONSTRAINT `FK_FN_MENU_REF_223_FN_FUNCT`
\r
813 FOREIGN KEY (`FUNCTION_CD`)
\r
814 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
816 AUTO_INCREMENT = 150029
\r
817 DEFAULT CHARACTER SET = utf8;
\r
819 -- ----------------------------------------------------------------------------
\r
820 -- Table vid_openecomp_epsdk.fn_org
\r
821 -- ----------------------------------------------------------------------------
\r
822 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_org` (
\r
823 `ORG_ID` INT(11) NOT NULL,
\r
824 `ORG_NAME` VARCHAR(50) NOT NULL,
\r
825 `ACCESS_CD` VARCHAR(10) NULL DEFAULT NULL,
\r
826 PRIMARY KEY (`ORG_ID`),
\r
827 INDEX `FN_ORG_ACCESS_CD` (`ACCESS_CD` ASC))
\r
829 DEFAULT CHARACTER SET = utf8;
\r
831 -- ----------------------------------------------------------------------------
\r
832 -- Table vid_openecomp_epsdk.fn_qz_blob_triggers
\r
833 -- ----------------------------------------------------------------------------
\r
834 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_blob_triggers` (
\r
835 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
836 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
837 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
838 `BLOB_DATA` BLOB NULL DEFAULT NULL,
\r
839 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
840 INDEX `SCHED_NAME` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
841 CONSTRAINT `fn_qz_blob_triggers_ibfk_1`
\r
842 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
843 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
845 DEFAULT CHARACTER SET = utf8;
\r
847 -- ----------------------------------------------------------------------------
\r
848 -- Table vid_openecomp_epsdk.fn_qz_calendars
\r
849 -- ----------------------------------------------------------------------------
\r
850 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_calendars` (
\r
851 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
852 `CALENDAR_NAME` VARCHAR(200) NOT NULL,
\r
853 `CALENDAR` BLOB NOT NULL,
\r
854 PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`))
\r
856 DEFAULT CHARACTER SET = utf8;
\r
858 -- ----------------------------------------------------------------------------
\r
859 -- Table vid_openecomp_epsdk.fn_qz_cron_triggers
\r
860 -- ----------------------------------------------------------------------------
\r
861 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_cron_triggers` (
\r
862 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
863 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
864 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
865 `CRON_EXPRESSION` VARCHAR(120) NOT NULL,
\r
866 `TIME_ZONE_ID` VARCHAR(80) NULL DEFAULT NULL,
\r
867 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
868 CONSTRAINT `fn_qz_cron_triggers_ibfk_1`
\r
869 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
870 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
872 DEFAULT CHARACTER SET = utf8;
\r
874 -- ----------------------------------------------------------------------------
\r
875 -- Table vid_openecomp_epsdk.fn_qz_fired_triggers
\r
876 -- ----------------------------------------------------------------------------
\r
877 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_fired_triggers` (
\r
878 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
879 `ENTRY_ID` VARCHAR(95) NOT NULL,
\r
880 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
881 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
882 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
\r
883 `FIRED_TIME` BIGINT(13) NOT NULL,
\r
884 `SCHED_TIME` BIGINT(13) NOT NULL,
\r
885 `PRIORITY` INT(11) NOT NULL,
\r
886 `STATE` VARCHAR(16) NOT NULL,
\r
887 `JOB_NAME` VARCHAR(200) NULL DEFAULT NULL,
\r
888 `JOB_GROUP` VARCHAR(200) NULL DEFAULT NULL,
\r
889 `IS_NONCONCURRENT` VARCHAR(1) NULL DEFAULT NULL,
\r
890 `REQUESTS_RECOVERY` VARCHAR(1) NULL DEFAULT NULL,
\r
891 PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`),
\r
892 INDEX `IDX_FN_QZ_FT_TRIG_INST_NAME` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC),
\r
893 INDEX `IDX_FN_QZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC),
\r
894 INDEX `IDX_FN_QZ_FT_J_G` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
\r
895 INDEX `IDX_FN_QZ_FT_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
\r
896 INDEX `IDX_FN_QZ_FT_T_G` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
897 INDEX `IDX_FN_QZ_FT_TG` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC))
\r
899 DEFAULT CHARACTER SET = utf8;
\r
901 -- ----------------------------------------------------------------------------
\r
902 -- Table vid_openecomp_epsdk.fn_qz_job_details
\r
903 -- ----------------------------------------------------------------------------
\r
904 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_job_details` (
\r
905 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
906 `JOB_NAME` VARCHAR(200) NOT NULL,
\r
907 `JOB_GROUP` VARCHAR(200) NOT NULL,
\r
908 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
\r
909 `JOB_CLASS_NAME` VARCHAR(250) NOT NULL,
\r
910 `IS_DURABLE` VARCHAR(1) NOT NULL,
\r
911 `IS_NONCONCURRENT` VARCHAR(1) NOT NULL,
\r
912 `IS_UPDATE_DATA` VARCHAR(1) NOT NULL,
\r
913 `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL,
\r
914 `JOB_DATA` BLOB NULL DEFAULT NULL,
\r
915 PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`),
\r
916 INDEX `IDX_FN_QZ_J_REQ_RECOVERY` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC),
\r
917 INDEX `IDX_FN_QZ_J_GRP` (`SCHED_NAME` ASC, `JOB_GROUP` ASC))
\r
919 DEFAULT CHARACTER SET = utf8;
\r
921 -- ----------------------------------------------------------------------------
\r
922 -- Table vid_openecomp_epsdk.fn_qz_locks
\r
923 -- ----------------------------------------------------------------------------
\r
924 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_locks` (
\r
925 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
926 `LOCK_NAME` VARCHAR(40) NOT NULL,
\r
927 PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`))
\r
929 DEFAULT CHARACTER SET = utf8;
\r
931 -- ----------------------------------------------------------------------------
\r
932 -- Table vid_openecomp_epsdk.fn_qz_paused_trigger_grps
\r
933 -- ----------------------------------------------------------------------------
\r
934 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_paused_trigger_grps` (
\r
935 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
936 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
937 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`))
\r
939 DEFAULT CHARACTER SET = utf8;
\r
941 -- ----------------------------------------------------------------------------
\r
942 -- Table vid_openecomp_epsdk.fn_qz_scheduler_state
\r
943 -- ----------------------------------------------------------------------------
\r
944 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_scheduler_state` (
\r
945 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
946 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
\r
947 `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL,
\r
948 `CHECKIN_INTERVAL` BIGINT(13) NOT NULL,
\r
949 PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`))
\r
951 DEFAULT CHARACTER SET = utf8;
\r
953 -- ----------------------------------------------------------------------------
\r
954 -- Table vid_openecomp_epsdk.fn_qz_simple_triggers
\r
955 -- ----------------------------------------------------------------------------
\r
956 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simple_triggers` (
\r
957 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
958 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
959 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
960 `REPEAT_COUNT` BIGINT(7) NOT NULL,
\r
961 `REPEAT_INTERVAL` BIGINT(12) NOT NULL,
\r
962 `TIMES_TRIGGERED` BIGINT(10) NOT NULL,
\r
963 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
964 CONSTRAINT `fn_qz_simple_triggers_ibfk_1`
\r
965 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
966 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
968 DEFAULT CHARACTER SET = utf8;
\r
970 -- ----------------------------------------------------------------------------
\r
971 -- Table vid_openecomp_epsdk.fn_qz_simprop_triggers
\r
972 -- ----------------------------------------------------------------------------
\r
973 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simprop_triggers` (
\r
974 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
975 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
976 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
977 `STR_PROP_1` VARCHAR(512) NULL DEFAULT NULL,
\r
978 `STR_PROP_2` VARCHAR(512) NULL DEFAULT NULL,
\r
979 `STR_PROP_3` VARCHAR(512) NULL DEFAULT NULL,
\r
980 `INT_PROP_1` INT(11) NULL DEFAULT NULL,
\r
981 `INT_PROP_2` INT(11) NULL DEFAULT NULL,
\r
982 `LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL,
\r
983 `LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL,
\r
984 `DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL,
\r
985 `DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL,
\r
986 `BOOL_PROP_1` VARCHAR(1) NULL DEFAULT NULL,
\r
987 `BOOL_PROP_2` VARCHAR(1) NULL DEFAULT NULL,
\r
988 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
989 CONSTRAINT `fn_qz_simprop_triggers_ibfk_1`
\r
990 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
\r
991 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
\r
993 DEFAULT CHARACTER SET = utf8;
\r
995 -- ----------------------------------------------------------------------------
\r
996 -- Table vid_openecomp_epsdk.fn_qz_triggers
\r
997 -- ----------------------------------------------------------------------------
\r
998 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_triggers` (
\r
999 `SCHED_NAME` VARCHAR(120) NOT NULL,
\r
1000 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
\r
1001 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
\r
1002 `JOB_NAME` VARCHAR(200) NOT NULL,
\r
1003 `JOB_GROUP` VARCHAR(200) NOT NULL,
\r
1004 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
\r
1005 `NEXT_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
1006 `PREV_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
1007 `PRIORITY` INT(11) NULL DEFAULT NULL,
\r
1008 `TRIGGER_STATE` VARCHAR(16) NOT NULL,
\r
1009 `TRIGGER_TYPE` VARCHAR(8) NOT NULL,
\r
1010 `START_TIME` BIGINT(13) NOT NULL,
\r
1011 `END_TIME` BIGINT(13) NULL DEFAULT NULL,
\r
1012 `CALENDAR_NAME` VARCHAR(200) NULL DEFAULT NULL,
\r
1013 `MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL,
\r
1014 `JOB_DATA` BLOB NULL DEFAULT NULL,
\r
1015 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
\r
1016 INDEX `IDX_FN_QZ_T_J` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
\r
1017 INDEX `IDX_FN_QZ_T_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
\r
1018 INDEX `IDX_FN_QZ_T_C` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC),
\r
1019 INDEX `IDX_FN_QZ_T_G` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC),
\r
1020 INDEX `IDX_FN_QZ_T_STATE` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC),
\r
1021 INDEX `IDX_FN_QZ_T_N_STATE` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1022 INDEX `IDX_FN_QZ_T_N_G_STATE` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
\r
1023 INDEX `IDX_FN_QZ_T_NEXT_FIRE_TIME` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC),
\r
1024 INDEX `IDX_FN_QZ_T_NFT_ST` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC),
\r
1025 INDEX `IDX_FN_QZ_T_NFT_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC),
\r
1026 INDEX `IDX_FN_QZ_T_NFT_ST_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC),
\r
1027 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
1028 CONSTRAINT `fn_qz_triggers_ibfk_1`
\r
1029 FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`)
\r
1030 REFERENCES `vid_openecomp_epsdk`.`fn_qz_job_details` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`))
\r
1032 DEFAULT CHARACTER SET = utf8;
\r
1034 -- ----------------------------------------------------------------------------
\r
1035 -- Table vid_openecomp_epsdk.fn_restricted_url
\r
1036 -- ----------------------------------------------------------------------------
\r
1037 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_restricted_url` (
\r
1038 `RESTRICTED_URL` VARCHAR(250) NOT NULL,
\r
1039 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1040 PRIMARY KEY (`RESTRICTED_URL`, `FUNCTION_CD`),
\r
1041 INDEX `FK_RESTRICTED_URL_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1042 CONSTRAINT `FK_RESTRICTED_URL_FUNCTION_CD`
\r
1043 FOREIGN KEY (`FUNCTION_CD`)
\r
1044 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
1046 DEFAULT CHARACTER SET = utf8;
\r
1048 -- ----------------------------------------------------------------------------
\r
1049 -- Table vid_openecomp_epsdk.fn_role
\r
1050 -- ----------------------------------------------------------------------------
\r
1051 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role` (
\r
1052 `ROLE_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1053 `ROLE_NAME` VARCHAR(255) NOT NULL,
\r
1054 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
1055 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
\r
1056 PRIMARY KEY (`ROLE_ID`))
\r
1058 AUTO_INCREMENT = 17
\r
1059 DEFAULT CHARACTER SET = utf8;
\r
1061 ALTER TABLE `vid_openecomp_epsdk`.`fn_role` MODIFY `ROLE_NAME` VARCHAR (255);
\r
1064 -- ----------------------------------------------------------------------------
\r
1065 -- Table vid_openecomp_epsdk.fn_role_composite
\r
1066 -- ----------------------------------------------------------------------------
\r
1067 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_composite` (
\r
1068 `PARENT_ROLE_ID` INT(11) NOT NULL,
\r
1069 `CHILD_ROLE_ID` INT(11) NOT NULL,
\r
1070 PRIMARY KEY (`PARENT_ROLE_ID`, `CHILD_ROLE_ID`),
\r
1071 INDEX `FK_FN_ROLE_COMPOSITE_CHILD` (`CHILD_ROLE_ID` ASC),
\r
1072 CONSTRAINT `FK_FN_ROLE_COMPOSITE_CHILD`
\r
1073 FOREIGN KEY (`CHILD_ROLE_ID`)
\r
1074 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1075 CONSTRAINT `FK_FN_ROLE_COMPOSITE_PARENT`
\r
1076 FOREIGN KEY (`PARENT_ROLE_ID`)
\r
1077 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`))
\r
1079 DEFAULT CHARACTER SET = utf8;
\r
1081 -- ----------------------------------------------------------------------------
\r
1082 -- Table vid_openecomp_epsdk.fn_role_function
\r
1083 -- ----------------------------------------------------------------------------
\r
1084 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_function` (
\r
1085 `ROLE_ID` INT(11) NOT NULL,
\r
1086 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1087 PRIMARY KEY (`ROLE_ID`, `FUNCTION_CD`),
\r
1088 INDEX `FN_ROLE_FUNCTION_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1089 INDEX `FN_ROLE_FUNCTION_ROLE_ID` (`ROLE_ID` ASC),
\r
1090 CONSTRAINT `FK_FN_ROLE__REF_198_FN_ROLE`
\r
1091 FOREIGN KEY (`ROLE_ID`)
\r
1092 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1093 CONSTRAINT `FK_FN_ROLE__REF_201_FN_FUNCT`
\r
1094 FOREIGN KEY (`FUNCTION_CD`)
\r
1095 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
\r
1097 DEFAULT CHARACTER SET = utf8;
\r
1099 -- ----------------------------------------------------------------------------
\r
1100 -- Table vid_openecomp_epsdk.fn_schedule_workflows
\r
1101 -- ----------------------------------------------------------------------------
\r
1102 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_schedule_workflows` (
\r
1103 `id_schedule_workflows` BIGINT(25) NOT NULL AUTO_INCREMENT,
\r
1104 `workflow_server_url` VARCHAR(45) NULL DEFAULT NULL,
\r
1105 `workflow_key` VARCHAR(45) NOT NULL,
\r
1106 `workflow_arguments` VARCHAR(45) NULL DEFAULT NULL,
\r
1107 `startDateTimeCron` VARCHAR(45) NULL DEFAULT NULL,
\r
1108 `endDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1109 `start_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1110 `recurrence` VARCHAR(45) NULL DEFAULT NULL,
\r
1111 PRIMARY KEY (`id_schedule_workflows`))
\r
1113 DEFAULT CHARACTER SET = utf8;
\r
1115 -- ----------------------------------------------------------------------------
\r
1116 -- Table vid_openecomp_epsdk.fn_tab
\r
1117 -- ----------------------------------------------------------------------------
\r
1118 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab` (
\r
1119 `TAB_CD` VARCHAR(30) NOT NULL,
\r
1120 `TAB_NAME` VARCHAR(50) NOT NULL,
\r
1121 `TAB_DESCR` VARCHAR(100) NULL DEFAULT NULL,
\r
1122 `ACTION` VARCHAR(100) NOT NULL,
\r
1123 `FUNCTION_CD` VARCHAR(30) NOT NULL,
\r
1124 `ACTIVE_YN` CHAR(1) NOT NULL,
\r
1125 `SORT_ORDER` DECIMAL(11,0) NOT NULL,
\r
1126 `PARENT_TAB_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
1127 `TAB_SET_CD` VARCHAR(30) NULL DEFAULT NULL,
\r
1128 PRIMARY KEY (`TAB_CD`),
\r
1129 INDEX `FK_FN_TAB_FUNCTION_CD` (`FUNCTION_CD` ASC),
\r
1130 INDEX `FK_FN_TAB_SET_CD` (`TAB_SET_CD` ASC),
\r
1131 CONSTRAINT `FK_FN_TAB_FUNCTION_CD`
\r
1132 FOREIGN KEY (`FUNCTION_CD`)
\r
1133 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`),
\r
1134 CONSTRAINT `FK_FN_TAB_SET_CD`
\r
1135 FOREIGN KEY (`TAB_SET_CD`)
\r
1136 REFERENCES `vid_openecomp_epsdk`.`fn_lu_tab_set` (`TAB_SET_CD`))
\r
1138 DEFAULT CHARACTER SET = utf8;
\r
1140 -- ----------------------------------------------------------------------------
\r
1141 -- Table vid_openecomp_epsdk.fn_tab_selected
\r
1142 -- ----------------------------------------------------------------------------
\r
1143 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab_selected` (
\r
1144 `SELECTED_TAB_CD` VARCHAR(30) NOT NULL,
\r
1145 `TAB_URI` VARCHAR(40) NOT NULL,
\r
1146 PRIMARY KEY (`SELECTED_TAB_CD`, `TAB_URI`),
\r
1147 CONSTRAINT `FK_FN_TAB_SELECTED_TAB_CD`
\r
1148 FOREIGN KEY (`SELECTED_TAB_CD`)
\r
1149 REFERENCES `vid_openecomp_epsdk`.`fn_tab` (`TAB_CD`))
\r
1151 DEFAULT CHARACTER SET = utf8;
\r
1153 -- ----------------------------------------------------------------------------
\r
1154 -- Table vid_openecomp_epsdk.fn_user
\r
1155 -- ----------------------------------------------------------------------------
\r
1156 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user` (
\r
1157 `USER_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1158 `ORG_ID` INT(11) NULL DEFAULT NULL,
\r
1159 `MANAGER_ID` INT(11) NULL DEFAULT NULL,
\r
1160 `FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1161 `MIDDLE_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1162 `LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,
\r
1163 `PHONE` VARCHAR(25) NULL DEFAULT NULL,
\r
1164 `FAX` VARCHAR(25) NULL DEFAULT NULL,
\r
1165 `CELLULAR` VARCHAR(25) NULL DEFAULT NULL,
\r
1166 `EMAIL` VARCHAR(50) NULL DEFAULT NULL,
\r
1167 `ADDRESS_ID` DECIMAL(11,0) NULL DEFAULT NULL,
\r
1168 `ALERT_METHOD_CD` VARCHAR(10) NULL DEFAULT NULL,
\r
1169 `HRID` VARCHAR(20) NULL DEFAULT NULL,
\r
1170 `ORG_USER_ID` VARCHAR(20) NULL DEFAULT NULL,
\r
1171 `ORG_CODE` VARCHAR(30) NULL DEFAULT NULL,
\r
1172 `LOGIN_ID` VARCHAR(25) NULL DEFAULT NULL,
\r
1173 `LOGIN_PWD` VARCHAR(25) NULL DEFAULT NULL,
\r
1174 `LAST_LOGIN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
1175 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
\r
1176 `CREATED_ID` INT(11) NULL DEFAULT NULL,
\r
1177 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1178 `MODIFIED_ID` INT(11) NULL DEFAULT NULL,
\r
1179 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1180 `IS_INTERNAL_YN` CHAR(1) NOT NULL DEFAULT 'N',
\r
1181 `ADDRESS_LINE_1` VARCHAR(100) NULL DEFAULT NULL,
\r
1182 `ADDRESS_LINE_2` VARCHAR(100) NULL DEFAULT NULL,
\r
1183 `CITY` VARCHAR(50) NULL DEFAULT NULL,
\r
1184 `STATE_CD` VARCHAR(3) NULL DEFAULT NULL,
\r
1185 `ZIP_CODE` VARCHAR(11) NULL DEFAULT NULL,
\r
1186 `COUNTRY_CD` VARCHAR(3) NULL DEFAULT NULL,
\r
1187 `LOCATION_CLLI` VARCHAR(8) NULL DEFAULT NULL,
\r
1188 `ORG_MANAGER_USERID` VARCHAR(20) NULL DEFAULT NULL,
\r
1189 `COMPANY` VARCHAR(100) NULL DEFAULT NULL,
\r
1190 `DEPARTMENT_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
1191 `JOB_TITLE` VARCHAR(100) NULL DEFAULT NULL,
\r
1192 `TIMEZONE` INT(11) NULL DEFAULT NULL,
\r
1193 `DEPARTMENT` VARCHAR(25) NULL DEFAULT NULL,
\r
1194 `BUSINESS_UNIT` VARCHAR(25) NULL DEFAULT NULL,
\r
1195 `BUSINESS_UNIT_NAME` VARCHAR(100) NULL DEFAULT NULL,
\r
1196 `COST_CENTER` VARCHAR(25) NULL DEFAULT NULL,
\r
1197 `FIN_LOC_CODE` VARCHAR(10) NULL DEFAULT NULL,
\r
1198 `SILO_STATUS` VARCHAR(10) NULL DEFAULT NULL,
\r
1199 PRIMARY KEY (`USER_ID`),
\r
1200 UNIQUE INDEX `FN_USER_HRID` (`HRID` ASC),
\r
1201 UNIQUE INDEX `FN_USER_LOGIN_ID` (`LOGIN_ID` ASC),
\r
1202 INDEX `FN_USER_ADDRESS_ID` (`ADDRESS_ID` ASC),
\r
1203 INDEX `FN_USER_ALERT_METHOD_CD` (`ALERT_METHOD_CD` ASC),
\r
1204 INDEX `FN_USER_ORG_ID` (`ORG_ID` ASC),
\r
1205 INDEX `FK_FN_USER_REF_197_FN_USER` (`MANAGER_ID` ASC),
\r
1206 INDEX `FK_FN_USER_REF_198_FN_USER` (`CREATED_ID` ASC),
\r
1207 INDEX `FK_FN_USER_REF_199_FN_USER` (`MODIFIED_ID` ASC),
\r
1208 INDEX `FK_TIMEZONE` (`TIMEZONE` ASC),
\r
1209 CONSTRAINT `FK_FN_USER_REF_110_FN_ORG`
\r
1210 FOREIGN KEY (`ORG_ID`)
\r
1211 REFERENCES `vid_openecomp_epsdk`.`fn_org` (`ORG_ID`),
\r
1212 CONSTRAINT `FK_FN_USER_REF_123_FN_LU_AL`
\r
1213 FOREIGN KEY (`ALERT_METHOD_CD`)
\r
1214 REFERENCES `vid_openecomp_epsdk`.`fn_lu_alert_method` (`ALERT_METHOD_CD`),
\r
1215 CONSTRAINT `FK_FN_USER_REF_197_FN_USER`
\r
1216 FOREIGN KEY (`MANAGER_ID`)
\r
1217 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1218 CONSTRAINT `FK_FN_USER_REF_198_FN_USER`
\r
1219 FOREIGN KEY (`CREATED_ID`)
\r
1220 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1221 CONSTRAINT `FK_FN_USER_REF_199_FN_USER`
\r
1222 FOREIGN KEY (`MODIFIED_ID`)
\r
1223 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1224 CONSTRAINT `FK_TIMEZONE`
\r
1225 FOREIGN KEY (`TIMEZONE`)
\r
1226 REFERENCES `vid_openecomp_epsdk`.`fn_lu_timezone` (`TIMEZONE_ID`))
\r
1228 AUTO_INCREMENT = 3
\r
1229 DEFAULT CHARACTER SET = utf8;
\r
1232 -- ----------------------------------------------------------------------------
\r
1233 -- Table vid_openecomp_epsdk.fn_user_pseudo_role
\r
1234 -- ----------------------------------------------------------------------------
\r
1235 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_pseudo_role` (
\r
1236 `PSEUDO_ROLE_ID` INT(11) NOT NULL,
\r
1237 `USER_ID` INT(11) NOT NULL,
\r
1238 PRIMARY KEY (`PSEUDO_ROLE_ID`, `USER_ID`),
\r
1239 INDEX `FK_PSEUDO_ROLE_USER_ID` (`USER_ID` ASC),
\r
1240 CONSTRAINT `FK_PSEUDO_ROLE_PSEUDO_ROLE_ID`
\r
1241 FOREIGN KEY (`PSEUDO_ROLE_ID`)
\r
1242 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1243 CONSTRAINT `FK_PSEUDO_ROLE_USER_ID`
\r
1244 FOREIGN KEY (`USER_ID`)
\r
1245 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
\r
1247 DEFAULT CHARACTER SET = utf8;
\r
1249 -- ----------------------------------------------------------------------------
\r
1250 -- Table vid_openecomp_epsdk.fn_user_role
\r
1251 -- ----------------------------------------------------------------------------
\r
1252 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_role` (
\r
1253 `USER_ID` INT(10) NOT NULL,
\r
1254 `ROLE_ID` INT(10) NOT NULL,
\r
1255 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
\r
1256 `APP_ID` INT(11) NOT NULL DEFAULT '1',
\r
1257 PRIMARY KEY (`USER_ID`, `ROLE_ID`, `APP_ID`),
\r
1258 INDEX `FN_USER_ROLE_ROLE_ID` (`ROLE_ID` ASC),
\r
1259 INDEX `FN_USER_ROLE_USER_ID` (`USER_ID` ASC),
\r
1260 INDEX `FK_FN_USER__REF_178_FN_APP_idx` (`APP_ID` ASC),
\r
1261 CONSTRAINT `FK_FN_USER__REF_172_FN_USER`
\r
1262 FOREIGN KEY (`USER_ID`)
\r
1263 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
\r
1264 CONSTRAINT `FK_FN_USER__REF_175_FN_ROLE`
\r
1265 FOREIGN KEY (`ROLE_ID`)
\r
1266 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
\r
1267 CONSTRAINT `FK_FN_USER__REF_178_FN_APP`
\r
1268 FOREIGN KEY (`APP_ID`)
\r
1269 REFERENCES `vid_openecomp_epsdk`.`fn_app` (`APP_ID`))
\r
1271 DEFAULT CHARACTER SET = utf8;
\r
1273 -- ----------------------------------------------------------------------------
\r
1274 -- Table vid_openecomp_epsdk.fn_workflow
\r
1275 -- ----------------------------------------------------------------------------
\r
1276 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_workflow` (
\r
1277 `id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
\r
1278 `name` VARCHAR(20) NOT NULL,
\r
1279 `description` VARCHAR(500) NULL DEFAULT NULL,
\r
1280 `run_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1281 `suspend_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1282 `modified_link` VARCHAR(300) NULL DEFAULT NULL,
\r
1283 `active_yn` VARCHAR(300) NULL DEFAULT NULL,
\r
1284 `created` VARCHAR(300) NULL DEFAULT NULL,
\r
1285 `created_by` INT(11) NULL DEFAULT NULL,
\r
1286 `modified` VARCHAR(300) NULL DEFAULT NULL,
\r
1287 `modified_by` INT(11) NULL DEFAULT NULL,
\r
1288 `workflow_key` VARCHAR(50) NULL DEFAULT NULL,
\r
1289 PRIMARY KEY (`id`),
\r
1290 UNIQUE INDEX `name` (`name` ASC))
\r
1292 DEFAULT CHARACTER SET = utf8;
\r
1294 -- ----------------------------------------------------------------------------
\r
1295 -- Table vid_openecomp_epsdk.fn_xmltype
\r
1296 -- ----------------------------------------------------------------------------
\r
1297 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_xmltype` (
\r
1298 `ID` DECIMAL(10,0) NOT NULL,
\r
1299 `XML_DOCUMENT` TEXT NULL DEFAULT NULL,
\r
1300 UNIQUE INDEX `FN_XMLTYPE_ID` (`ID` ASC))
\r
1302 DEFAULT CHARACTER SET = utf8;
\r
1304 -- ----------------------------------------------------------------------------
\r
1305 -- Table vid_openecomp_epsdk.schema_info
\r
1306 -- ----------------------------------------------------------------------------
\r
1307 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`schema_info` (
\r
1308 `SCHEMA_ID` VARCHAR(25) NOT NULL,
\r
1309 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
\r
1310 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
\r
1311 `CONNECTION_URL` VARCHAR(200) NOT NULL,
\r
1312 `USER_NAME` VARCHAR(45) NOT NULL,
\r
1313 `PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
\r
1314 `DRIVER_CLASS` VARCHAR(100) NOT NULL,
\r
1315 `MIN_POOL_SIZE` INT(11) NOT NULL,
\r
1316 `MAX_POOL_SIZE` INT(11) NOT NULL,
\r
1317 `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
\r
1319 DEFAULT CHARACTER SET = utf8;
\r
1320 -- ----------------------------------------------------------------------------
\r
1321 -- Table vid_openecomp_epsdk.vid_vnf
\r
1322 -- ----------------------------------------------------------------------------
\r
1324 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf` (
\r
1325 `VNF_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
\r
1326 `VNF_APP_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\r
1327 `VNF_APP_INVARIANT_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\r
1328 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1329 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1330 PRIMARY KEY (`VNF_DB_ID`),
\r
1331 UNIQUE KEY `vid_vnf_VNF_ID_uindex` (`VNF_APP_UUID`,`VNF_APP_INVARIANT_UUID`)
\r
1332 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
\r
1334 -- ----------------------------------------------------------------------------
\r
1335 -- Table vid_openecomp_epsdk.vid_workflow
\r
1336 -- ----------------------------------------------------------------------------
\r
1338 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_workflow` (
\r
1339 `WORKFLOW_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
\r
1340 `WORKFLOW_APP_NAME` varchar(50) COLLATE utf8_bin NOT NULL,
\r
1341 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1342 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1343 PRIMARY KEY (`WORKFLOW_DB_ID`),
\r
1344 UNIQUE KEY `vid_workflow_workflow_uuid_uindex` (`WORKFLOW_APP_NAME`),
\r
1345 UNIQUE KEY `vid_workflow_WORKFLOW_ID_uindex` (`WORKFLOW_DB_ID`)
\r
1346 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1348 -- ----------------------------------------------------------------------------
\r
1349 -- Table vid_openecomp_epsdk.vid_vnf_workflow
\r
1350 -- ----------------------------------------------------------------------------
\r
1353 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf_workflow` (
\r
1354 `VNF_DB_ID` int(11) NOT NULL,
\r
1355 `WORKFLOW_DB_ID` int(11) NOT NULL,
\r
1356 KEY `vid_vnf_workflow_vid_vnf_VND_ID_fk` (`VNF_DB_ID`),
\r
1357 KEY `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` (`WORKFLOW_DB_ID`),
\r
1358 CONSTRAINT `vid_vnf_workflow_vid_vnf_VND_ID_fk` FOREIGN KEY (`VNF_DB_ID`) REFERENCES `vid_vnf` (`VNF_DB_ID`),
\r
1359 CONSTRAINT `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` FOREIGN KEY (`WORKFLOW_DB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_workflow` (`WORKFLOW_DB_ID`)
\r
1360 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1363 -- ----------------------------------------------------------------------------
\r
1364 -- Table vid_openecomp_epsdk.vid_category_parameter
\r
1365 -- ----------------------------------------------------------------------------
\r
1368 CREATE TABLE IF NOT EXISTS `vid_category_parameter` (
\r
1369 `CATEGORY_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1370 `NAME` VARCHAR(255) NULL COLLATE 'utf8_bin',
\r
1371 `ID_SUPPORTED` TINYINT(1) NOT NULL DEFAULT '0',
\r
1372 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1373 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1374 PRIMARY KEY (`CATEGORY_ID`)
\r
1375 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=5;
\r
1377 -------------------------------------------------------------------------------
\r
1379 ALTER TABLE `vid_category_parameter`
\r
1380 ADD COLUMN if not exists `FAMILY` ENUM('PARAMETER_STANDARDIZATION','TENANT_ISOLATION') NOT NULL DEFAULT 'PARAMETER_STANDARDIZATION' AFTER `ID_SUPPORTED`;
\r
1381 -- ----------------------------------------------------------------------------
\r
1382 -- Table vid_openecomp_epsdk.vid_category_parameter
\r
1383 -- ----------------------------------------------------------------------------
\r
1384 CREATE TABLE IF NOT EXISTS `vid_category_parameter_option` (
\r
1385 `CATEGORY_OPT_DB_ID` INT(11) NOT NULL AUTO_INCREMENT,
\r
1386 `CATEGORY_OPT_APP_ID` VARCHAR(50) NOT NULL COLLATE 'utf8_bin',
\r
1387 `NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1388 `CATEGORY_ID` INT(11) NOT NULL DEFAULT '0',
\r
1389 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1390 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1391 PRIMARY KEY (`CATEGORY_OPT_DB_ID`),
\r
1392 UNIQUE INDEX `APP_ID_CATEGORY_UNIQUE` (`CATEGORY_ID`, `CATEGORY_OPT_APP_ID`),
\r
1393 UNIQUE INDEX `NAME_CATEGORY_UNIQUE` (`CATEGORY_ID`, `NAME`),
\r
1394 CONSTRAINT `FK_OWNING_ENTITY_OPTIONS_TO_OE` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_category_parameter` (`CATEGORY_ID`)
\r
1395 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=25;
\r
1397 CREATE TABLE IF NOT EXISTS `vid_job` (
\r
1398 `JOB_ID` BINARY(16) NOT NULL PRIMARY KEY,
\r
1399 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1400 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
1401 `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1402 `JOB_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',
\r
1403 `JOB_DATA` MEDIUMTEXT NULL COLLATE 'utf8_bin',
\r
1404 `PARENT_JOB_ID` BINARY(16) NULL,
\r
1405 `TAKEN_BY` VARCHAR(100) NULL COLLATE 'utf8_bin',
\r
1406 CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)
\r
1407 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
\r
1409 ALTER TABLE `vid_job`
\r
1410 ADD COLUMN if NOT EXISTS `TAKEN_BY` VARCHAR (100) COLLATE 'utf8_bin';
\r
1411 -- ----------------------------------------------------------------------------
\r
1412 -- View vid_openecomp_epsdk.v_url_access
\r
1413 -- ----------------------------------------------------------------------------
\r
1414 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
1415 SET FOREIGN_KEY_CHECKS = 1;