3 CREATE TABLE IF NOT EXISTS `JOB` (
4 `JOB_ID` varchar(255) 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 PRIMARY KEY (`JOB_ID`)
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17 CREATE TABLE IF NOT EXISTS `JOB_STATUS` (
18 `ID` INT NOT NULL AUTO_INCREMENT,
19 `UPDATED_TIME` DATETIME NOT NULL,
20 `DESCRIPTION` longtext DEFAULT NULL,
21 `STATUS` varchar(255) NOT NULL,
22 `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) 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 PRIMARY KEY (`NS_INST_ID`)
41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
43 CREATE TABLE IF NOT EXISTS `NF_INST` (
44 `NF_INST_ID` varchar(255) NOT NULL,
45 `NAME` varchar(255) DEFAULT NULL,
46 `VNFD_ID` varchar(255) DEFAULT NULL,
47 `PACKAGE_ID` varchar(255) DEFAULT NULL,
48 `NS_INST_ID` varchar(255) NOT NULL,
49 `STATUS` varchar(255) NOT NULL,
50 `CREATE_TIME` DATETIME DEFAULT NULL,
51 `LAST_UPDATE_TIME` DATETIME DEFAULT NULL,
52 PRIMARY KEY (`NF_INST_ID`),
53 FOREIGN KEY (NS_INST_ID)
54 REFERENCES NS_INST(NS_INST_ID)
55 ON UPDATE CASCADE ON DELETE CASCADE
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58 CREATE TABLE IF NOT EXISTS `NS_LCM_OP_OCCS` (
59 `ID` varchar(255) NOT NULL,
60 `OPERATION_STATE` varchar(255) NOT NULL,
61 `STATE_ENTERED_TIME` DATETIME DEFAULT NULL,
62 `START_TIME` DATETIME DEFAULT NULL,
63 `NS_INST_ID` varchar(255) NOT NULL,
64 `OPERATION` varchar(255) NOT NULL,
65 `IS_AUTO_INNOVATION` varchar(255) NOT NULL,
66 `OPERATION_PARAMS` longtext NOT NULL,
67 `IS_CANCEL_PENDING` varchar(255) NOT NULL,
69 FOREIGN KEY (NS_INST_ID)
70 REFERENCES NS_INST(NS_INST_ID)
71 ON UPDATE CASCADE ON DELETE CASCADE
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;