1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
|
-- drop table sdnctl.MODEL_TYPE;
-- drop table sdnctl.RESOURCE_DICTIONARY;
-- drop table sdnctl.CONFIG_MODEL_CONTENT;
-- drop table sdnctl.CONFIG_MODEL;
-- -----------------------------------------------------
-- table CONFIG_MODEL
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS sdnctl.BLUEPRINT_MODEL (
blueprint_model_id VARCHAR(50) NOT NULL,
service_uuid VARCHAR(50) NULL DEFAULT NULL,
distribution_id VARCHAR(50) NULL DEFAULT NULL,
service_name VARCHAR(255) NULL DEFAULT NULL,
service_description VARCHAR(255) NULL DEFAULT NULL,
resource_uuid VARCHAR(255) NULL DEFAULT NULL,
resource_instance_name VARCHAR(255) NULL DEFAULT NULL,
resource_name varchar(255) null default null,
resource_version varchar(50) null default null,
resource_type varchar(50) null default null,
artifact_uuid varchar(50) null default null,
artifact_type varchar(50) not null,
artifact_version varchar(25) not null,
artifact_description longtext null default null,
internal_version int(11) null default null,
creation_date datetime not null default current_timestamp,
artifact_name varchar(100) not null,
published varchar(1) not null,
updated_by varchar(100) not null,
tags longtext null default null,
primary key PK_BLUEPRINT_MODEL (blueprint_model_id),
UNIQUE KEY UK_BLUEPRINT_MODEL (artifact_name , artifact_version)
) ENGINE=InnoDB;
-- -----------------------------------------------------
-- table CONFIG_MODEL_CONTENT
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS sdnctl.BLUEPRINT_MODEL_CONTENT (
blueprint_model_content_id VARCHAR(50) NOT NULL,
blueprint_model_id VARCHAR(50) NOT NULL,
name VARCHAR(100) NOT NULL,
content_type VARCHAR(50) NOT NULL,
description LONGTEXT NULL DEFAULT NULL,
updated_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
content LONGBLOB NULL DEFAULT NULL,
PRIMARY KEY PK_BLUEPRINT_MODEL_CONTENT (blueprint_model_content_id),
UNIQUE KEY UK_BLUEPRINT_MODEL_CONTENT (blueprint_model_id, name, content_type),
FOREIGN KEY FK_BLUEPRINT_MODEL_CONTENT (blueprint_model_id) REFERENCES sdnctl.BLUEPRINT_MODEL(blueprint_model_id) ON DELETE CASCADE
) ENGINE=InnoDB;
-- -----------------------------------------------------
-- table MODEL_TYPE
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS sdnctl.MODEL_TYPE (
model_name VARCHAR(100) NOT NULL,
derived_from VARCHAR(100) NOT NULL,
definition_type VARCHAR(100) NOT NULL,
definition LONGTEXT NOT NULL,
version VARCHAR(10) NOT NULL,
description LONGTEXT NOT NULL,
tags LONGTEXT NULL DEFAULT NULL,
creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_by VARCHAR(100) NOT NULL,
PRIMARY KEY PK_MODEL_TYPE (model_name),
INDEX IX_MODEL_TYPE (model_name)
) ENGINE=InnoDB;
-- -----------------------------------------------------
-- table RESOURCE_DICTIONARY
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS sdnctl.RESOURCE_DICTIONARY (
name VARCHAR(100) NOT NULL,
data_type VARCHAR(100) NOT NULL,
entry_schema VARCHAR(100) NULL DEFAULT NULL,
definition LONGTEXT NOT NULL,
description LONGTEXT NOT NULL,
tags LONGTEXT NOT NULL,
creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_by VARCHAR(100) NOT NULL,
primary key PK_RESOURCE_DICTIONARY (name),
INDEX IX_RESOURCE_DICTIONARY (name)
) ENGINE=InnoDB;
-- -----------------------------------------------------
-- table BLUEPRINT_WORKFLOW_AUDIT_STATUS
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS sdnctl.BLUEPRINT_WORKFLOW_AUDIT_STATUS (
workflow_audit_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY,
workflow_task_content longtext NOT NULL,
originator_Id varchar(255) NOT NULL,
request_Id varchar(255) NOT NULL,
subRequest_Id varchar(255) NOT NULL,
workflow_name varchar(255) NOT NULL,
status varchar(255) NULL,
start_time datetime NULL,
end_time datetime NULL,
updated_date datetime NULL,
updated_by varchar(255) NULL,
blueprint_version varchar(255) NOT NULL,
blueprint_name varchar(255) NOT NULL,
request_mode varchar(255) NULL,
workflow_response_content longtext NULL,
blueprint_uuid varchar(255) NULL
) AUTO_INCREMENT = 1000 ENGINE=InnoDB;
|
