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;
19 CREATE TABLE IF NOT EXISTS `JOB_STATUS` (
20 `ID` INT NOT NULL AUTO_INCREMENT,
21 `UPDATED_TIME` DATETIME NOT NULL,
22 `DESCRIPTION` longtext DEFAULT NULL,
23 `STATUS` varchar(255) NOT NULL,
24 `JOB_ID` varchar(255) NOT NULL,
27 REFERENCES JOB(JOB_ID)
28 ON UPDATE CASCADE ON DELETE CASCADE
29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31 CREATE TABLE IF NOT EXISTS `NS_INST` (
32 `NS_INST_ID` varchar(255) NOT NULL,
33 `NAME` varchar(255) NOT NULL,
34 `NS_PACKAGE_ID` varchar(255) DEFAULT NULL,
35 `NSD_ID` varchar(255) NOT NULL,
36 `NSD_INVARIANT_ID` varchar(255) NOT NULL,
37 `DESCRIPTION` longtext DEFAULT NULL,
38 `STATUS` varchar(255) NOT NULL,
39 `STATUS_UPDATED_TIME` DATETIME NOT NULL,
40 `GLOBAL_CUSTOMER_ID` varchar(255) DEFAULT NULL,
41 `SERVICE_TYPE` varchar(255) DEFAULT NULL,
42 PRIMARY KEY (`NS_INST_ID`)
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
45 CREATE TABLE IF NOT EXISTS `NF_INST` (
46 `NF_INST_ID` varchar(255) NOT NULL,
47 `NAME` varchar(255) DEFAULT NULL,
48 `VNFD_ID` varchar(255) DEFAULT NULL,
49 `PACKAGE_ID` varchar(255) DEFAULT NULL,
50 `NS_INST_ID` varchar(255) NOT NULL,
51 `STATUS` varchar(255) NOT NULL,
52 `CREATE_TIME` DATETIME DEFAULT NULL,
53 `LAST_UPDATE_TIME` DATETIME DEFAULT NULL,
54 PRIMARY KEY (`NF_INST_ID`),
55 FOREIGN KEY (NS_INST_ID)
56 REFERENCES NS_INST(NS_INST_ID)
57 ON UPDATE CASCADE ON DELETE CASCADE
58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60 CREATE TABLE IF NOT EXISTS `NS_LCM_OP_OCCS` (
61 `ID` varchar(255) NOT NULL,
62 `OPERATION_STATE` varchar(255) NOT NULL,
63 `STATE_ENTERED_TIME` DATETIME DEFAULT NULL,
64 `START_TIME` DATETIME DEFAULT NULL,
65 `NS_INST_ID` varchar(255) NOT NULL,
66 `OPERATION` varchar(255) NOT NULL,
67 `IS_AUTO_INNOVATION` varchar(255) NOT NULL,
68 `OPERATION_PARAMS` longtext NOT NULL,
69 `IS_CANCEL_PENDING` varchar(255) NOT NULL,
71 FOREIGN KEY (NS_INST_ID)
72 REFERENCES NS_INST(NS_INST_ID)
73 ON UPDATE CASCADE ON DELETE CASCADE
74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;