3 CREATE TABLE IF NOT EXISTS `JOB` (
4 `JOB_ID` varchar(255) PRIMARY KEY NOT NULL,
5 `JOB_TYPE` varchar(255) NOT NULL,
6 `JOB_ACTION` varchar(255) NOT NULL,
7 `RESOURCE_ID` varchar(255) NOT NULL,
8 `RESOURCE_NAME` varchar(255) DEFAULT NULL,
9 `STATUS` varchar(255) NOT NULL,
10 `START_TIME` DATETIME DEFAULT NULL,
11 `END_TIME` DATETIME DEFAULT NULL,
12 `PROGRESS` int(11) DEFAULT NULL,
13 `PROCESS_INSTANCE_ID` varchar(255) DEFAULT NULL
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18 CREATE TABLE IF NOT EXISTS `JOB_STATUS` (
19 `ID` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
20 `UPDATED_TIME` DATETIME NOT NULL,
21 `DESCRIPTION` longtext DEFAULT NULL,
22 `STATUS` varchar(255) NOT NULL,
23 `JOB_ID` varchar(255) NOT NULL,
25 REFERENCES JOB(JOB_ID)
26 ON UPDATE CASCADE ON DELETE CASCADE
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29 CREATE TABLE IF NOT EXISTS `NS_INST` (
30 `NS_INST_ID` varchar(255) PRIMARY KEY NOT NULL,
31 `NAME` varchar(255) NOT NULL,
32 `NS_PACKAGE_ID` varchar(255) DEFAULT NULL,
33 `NSD_ID` varchar(255) NOT NULL,
34 `NSD_INVARIANT_ID` varchar(255) NOT NULL,
35 `DESCRIPTION` longtext DEFAULT NULL,
36 `STATUS` varchar(255) NOT NULL,
37 `STATUS_UPDATED_TIME` DATETIME NOT NULL,
38 `GLOBAL_CUSTOMER_ID` varchar(255) DEFAULT NULL,
39 `SERVICE_TYPE` varchar(255) DEFAULT NULL
40 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
42 CREATE TABLE IF NOT EXISTS `NF_INST` (
43 `NF_INST_ID` varchar(255) PRIMARY KEY NOT NULL,
44 `NAME` varchar(255) DEFAULT NULL,
45 `VNFD_ID` varchar(255) DEFAULT NULL,
46 `PACKAGE_ID` varchar(255) DEFAULT NULL,
47 `NS_INST_ID` varchar(255) NOT NULL,
48 `STATUS` varchar(255) NOT NULL,
49 `CREATE_TIME` DATETIME DEFAULT NULL,
50 `LAST_UPDATE_TIME` DATETIME DEFAULT NULL,
51 FOREIGN KEY (NS_INST_ID)
52 REFERENCES NS_INST(NS_INST_ID)
53 ON UPDATE CASCADE ON DELETE CASCADE
54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56 CREATE TABLE IF NOT EXISTS `NS_LCM_OP_OCCS` (
57 `ID` varchar(255) PRIMARY KEY NOT NULL,
58 `OPERATION_STATE` varchar(255) NOT NULL,
59 `STATE_ENTERED_TIME` DATETIME DEFAULT NULL,
60 `START_TIME` DATETIME DEFAULT NULL,
61 `NS_INST_ID` varchar(255) NOT NULL,
62 `OPERATION` varchar(255) NOT NULL,
63 `IS_AUTO_INVOCATION` varchar(255) NOT NULL,
64 `OPERATION_PARAMS` longtext NOT NULL,
65 `IS_CANCEL_PENDING` varchar(255) NOT NULL,
66 `CANCEL_MODE` varchar(255) DEFAULT NULL,
67 FOREIGN KEY (NS_INST_ID)
68 REFERENCES NS_INST(NS_INST_ID)
69 ON UPDATE CASCADE ON DELETE CASCADE
70 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;