3 CREATE TABLE IF NOT EXISTS `catalogdb`.`workflow` (
4 `ID` INT(11) NOT NULL AUTO_INCREMENT,
5 `ARTIFACT_UUID` VARCHAR(200) NOT NULL,
6 `ARTIFACT_NAME` VARCHAR(200) NOT NULL,
7 `NAME` VARCHAR(200) NOT NULL,
8 `OPERATION_NAME` VARCHAR(200) NULL,
9 `VERSION` DOUBLE NOT NULL,
10 `DESCRIPTION` VARCHAR(1200) NULL,
12 `RESOURCE_TARGET` VARCHAR(200) NOT NULL,
13 `SOURCE` VARCHAR(200) NOT NULL,
14 `TIMEOUT_MINUTES` INT(11) NULL DEFAULT NULL,
15 `ARTIFACT_CHECKSUM` VARCHAR(200) NULL DEFAULT 'MANUAL RECORD',
16 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
18 UNIQUE INDEX `UK_workflow` (`ARTIFACT_UUID` ASC, `NAME` ASC, `VERSION` ASC, `SOURCE` ASC))
20 DEFAULT CHARACTER SET = latin1;
22 CREATE TABLE IF NOT EXISTS `catalogdb`.`vnf_resource_to_workflow` (
23 `ID` INT(11) NOT NULL AUTO_INCREMENT,
24 `VNF_RESOURCE_MODEL_UUID` VARCHAR(200) NOT NULL,
25 `WORKFLOW_ID` INT(11) NOT NULL,
27 UNIQUE INDEX `UK_vnf_resource_to_workflow` (`VNF_RESOURCE_MODEL_UUID` ASC, `WORKFLOW_ID` ASC),
28 INDEX `fk_vnf_resource_to_workflow__workflow1_idx` (`WORKFLOW_ID` ASC),
29 INDEX `fk_vnf_resource_to_workflow__vnf_res_mod_uuid_idx` (`VNF_RESOURCE_MODEL_UUID` ASC),
30 CONSTRAINT `fk_vnf_resource_to_workflow__vnf_resource1`
31 FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`)
32 REFERENCES `catalogdb`.`vnf_resource` (`MODEL_UUID`)
35 CONSTRAINT `fk_vnf_resource_to_workflow__workflow1`
36 FOREIGN KEY (`WORKFLOW_ID`)
37 REFERENCES `catalogdb`.`workflow` (`ID`)
41 DEFAULT CHARACTER SET = latin1;
43 CREATE TABLE IF NOT EXISTS `catalogdb`.`activity_spec` (
44 `ID` INT(11) NOT NULL AUTO_INCREMENT,
45 `NAME` VARCHAR(200) NOT NULL,
46 `DESCRIPTION` VARCHAR(1200) NOT NULL,
47 `VERSION` DOUBLE NOT NULL,
48 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
50 UNIQUE INDEX `UK_activity_spec` (`NAME` ASC, `VERSION` ASC))
52 DEFAULT CHARACTER SET = latin1;
54 CREATE TABLE IF NOT EXISTS `catalogdb`.`user_parameters` (
55 `ID` INT(11) NOT NULL AUTO_INCREMENT,
56 `NAME` VARCHAR(200) NOT NULL,
57 `PAYLOAD_LOCATION` VARCHAR(500) NULL,
58 `LABEL` VARCHAR(200) NOT NULL,
59 `TYPE` VARCHAR(200) NOT NULL,
60 `DESCRIPTION` VARCHAR(1200) NULL,
61 `IS_REQUIRED` TINYINT(1) NOT NULL,
62 `MAX_LENGTH` INT(11) NULL,
63 `ALLOWABLE_CHARS` VARCHAR(200) NULL,
64 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
66 UNIQUE INDEX `UK_user_parameters` (`NAME` ASC))
68 DEFAULT CHARACTER SET = latin1;
70 CREATE TABLE IF NOT EXISTS `catalogdb`.`workflow_activity_spec_sequence` (
71 `ID` INT(11) NOT NULL AUTO_INCREMENT,
72 `WORKFLOW_ID` INT(11) NOT NULL,
73 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
74 `SEQ_NO` INT(11) NOT NULL,
76 UNIQUE INDEX `UK_workflow_activity_spec_sequence` (`WORKFLOW_ID` ASC, `ACTIVITY_SPEC_ID` ASC, `SEQ_NO` ASC),
77 INDEX `fk_workflow_activity_spec_sequence__activity_spec_idx` (`ACTIVITY_SPEC_ID` ASC),
78 INDEX `fk_workflow_activity_spec_sequence__workflow_actifact_uuid_idx` (`WORKFLOW_ID` ASC),
79 CONSTRAINT `fk_workflow_activity_spec_sequence__activity_spec1`
80 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
81 REFERENCES `catalogdb`.`activity_spec` (`ID`)
84 CONSTRAINT `fk_workflow_activity_spec_sequence__workflow1`
85 FOREIGN KEY (`WORKFLOW_ID`)
86 REFERENCES `catalogdb`.`workflow` (`ID`)
90 DEFAULT CHARACTER SET = latin1;
92 CREATE TABLE IF NOT EXISTS `catalogdb`.`activity_spec_parameters` (
93 `ID` INT(11) NOT NULL AUTO_INCREMENT,
94 `NAME` VARCHAR(200) NOT NULL,
95 `TYPE` VARCHAR(200) NOT NULL,
96 `DIRECTION` VARCHAR(200) NULL,
97 `DESCRIPTION` VARCHAR(1200) NULL,
98 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
100 UNIQUE INDEX `UK_activity_spec_parameters` (`NAME` ASC, `DIRECTION` ASC))
102 DEFAULT CHARACTER SET = latin1;
104 CREATE TABLE IF NOT EXISTS `catalogdb`.`activity_spec_categories` (
105 `ID` INT(11) NOT NULL,
106 `NAME` VARCHAR(200) NOT NULL,
108 UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
110 DEFAULT CHARACTER SET = latin1;
112 CREATE TABLE IF NOT EXISTS `catalogdb`.`activity_spec_to_activity_spec_categories` (
113 `ID` INT(11) NOT NULL,
114 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
115 `ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
117 UNIQUE INDEX `UK_activity_spec_to_activity_spec_categories` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_CATEGORIES_ID` ASC),
118 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx` (`ACTIVITY_SPEC_CATEGORIES_ID` ASC),
119 INDEX `fk_activity_spec_to_activity_spec_categories__activity_spec_idx1` (`ACTIVITY_SPEC_ID` ASC),
120 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec1`
121 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
122 REFERENCES `catalogdb`.`activity_spec` (`ID`)
125 CONSTRAINT `fk_activity_spec_to_activity_spec_categories__activity_spec_c1`
126 FOREIGN KEY (`ACTIVITY_SPEC_CATEGORIES_ID`)
127 REFERENCES `catalogdb`.`activity_spec_categories` (`ID`)
131 DEFAULT CHARACTER SET = latin1;
133 CREATE TABLE IF NOT EXISTS `catalogdb`.`activity_spec_to_activity_spec_parameters` (
134 `ID` INT(11) NOT NULL AUTO_INCREMENT,
135 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
136 `ACTIVITY_SPEC_PARAMETERS_ID` INT(11) NOT NULL,
138 INDEX `fk_activity_spec_to_activity_spec_params__act_sp_param_id_idx` (`ACTIVITY_SPEC_PARAMETERS_ID` ASC),
139 UNIQUE INDEX `UK_activity_spec_to_activity_spec_parameters` (`ACTIVITY_SPEC_ID` ASC, `ACTIVITY_SPEC_PARAMETERS_ID` ASC),
140 INDEX `fk_activity_spec_to_activity_spec_parameters__act_spec_id_idx` (`ACTIVITY_SPEC_ID` ASC),
141 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activity_spec_1`
142 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
143 REFERENCES `catalogdb`.`activity_spec` (`ID`)
146 CONSTRAINT `fk_activity_spec_to_activity_spec_parameters__activ_spec_param1`
147 FOREIGN KEY (`ACTIVITY_SPEC_PARAMETERS_ID`)
148 REFERENCES `catalogdb`.`activity_spec_parameters` (`ID`)
152 DEFAULT CHARACTER SET = latin1;
154 CREATE TABLE IF NOT EXISTS `catalogdb`.`activity_spec_to_user_parameters` (
155 `ID` INT(11) NOT NULL,
156 `ACTIVITY_SPEC_ID` INT(11) NOT NULL,
157 `USER_PARAMETERS_ID` INT(11) NOT NULL,
159 UNIQUE INDEX `UK_activity_spec_to_user_parameters` (`ACTIVITY_SPEC_ID` ASC, `USER_PARAMETERS_ID` ASC),
160 INDEX `fk_activity_spec_to_user_parameters__user_parameters1_idx` (`USER_PARAMETERS_ID` ASC),
161 INDEX `fk_activity_spec_to_user_parameters__activity_spec1_idx` (`ACTIVITY_SPEC_ID` ASC),
162 CONSTRAINT `fk_activity_spec_to_user_parameters__activity_spec1`
163 FOREIGN KEY (`ACTIVITY_SPEC_ID`)
164 REFERENCES `catalogdb`.`activity_spec` (`ID`)
167 CONSTRAINT `fk_activity_spec_to_user_parameters__user_parameters1`
168 FOREIGN KEY (`USER_PARAMETERS_ID`)
169 REFERENCES `catalogdb`.`user_parameters` (`ID`)
173 DEFAULT CHARACTER SET = latin1;