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
|
-- 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.CONFIG_MODEL (
config_model_id INT(11) NOT NULL AUTO_INCREMENT,
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_CONFIG_MODEL (config_model_id),
UNIQUE KEY UK_CONFIG_MODEL (artifact_name , artifact_version)
) ENGINE=InnoDB;
-- -----------------------------------------------------
-- table CONFIG_MODEL_CONTENT
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_MODEL_CONTENT (
config_model_content_id INT(11) NOT NULL AUTO_INCREMENT,
config_model_id INT 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 LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY PK_CONFIG_MODEL_CONTENT (config_model_content_id),
UNIQUE KEY UK_CONFIG_MODEL_CONTENT (config_model_id, name, content_type),
FOREIGN KEY FK_CONFIG_MODEL_CONTENT (config_model_id) REFERENCES sdnctl.CONFIG_MODEL(config_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;
|
