1 -- drop table sdnctl.MODEL_TYPE;
\r
2 -- drop table sdnctl.RESOURCE_DICTIONARY;
\r
3 -- drop table sdnctl.CONFIG_MODEL_CONTENT;
\r
4 -- drop table sdnctl.CONFIG_MODEL;
\r
6 -- -----------------------------------------------------
\r
7 -- table CONFIG_MODEL
\r
8 -- -----------------------------------------------------
\r
9 CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_MODEL (
\r
10 config_model_id VARCHAR(100) NOT NULL,
\r
11 service_uuid VARCHAR(50) NULL DEFAULT NULL,
\r
12 distribution_id VARCHAR(50) NULL DEFAULT NULL,
\r
13 service_name VARCHAR(255) NULL DEFAULT NULL,
\r
14 service_description VARCHAR(255) NULL DEFAULT NULL,
\r
15 resource_uuid VARCHAR(255) NULL DEFAULT NULL,
\r
16 resource_instance_name VARCHAR(255) NULL DEFAULT NULL,
\r
17 resource_name varchar(255) null default null,
\r
18 resource_version varchar(50) null default null,
\r
19 resource_type varchar(50) null default null,
\r
20 artifact_uuid varchar(50) null default null,
\r
21 artifact_type varchar(50) not null,
\r
22 artifact_version varchar(25) not null,
\r
23 artifact_description longtext null default null,
\r
24 internal_version int(11) null default null,
\r
25 creation_date datetime not null default current_timestamp,
\r
26 artifact_name varchar(100) not null,
\r
27 published varchar(1) not null,
\r
28 updated_by varchar(100) not null,
\r
29 tags longtext null default null,
\r
30 primary key PK_CONFIG_MODEL (config_model_id),
\r
31 UNIQUE KEY UK_CONFIG_MODEL (artifact_name , artifact_version)
\r
35 -- -----------------------------------------------------
\r
36 -- table CONFIG_MODEL_CONTENT
\r
37 -- -----------------------------------------------------
\r
38 CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_MODEL_CONTENT (
\r
39 config_model_content_id VARCHAR(100) NOT NULL,
\r
40 config_model_id INT NOT NULL,
\r
41 name VARCHAR(100) NOT NULL,
\r
42 content_type VARCHAR(50) NOT NULL,
\r
43 description LONGTEXT NULL DEFAULT NULL,
\r
44 updated_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
45 content LONGTEXT NULL DEFAULT NULL,
\r
46 PRIMARY KEY PK_CONFIG_MODEL_CONTENT (config_model_content_id),
\r
47 UNIQUE KEY UK_CONFIG_MODEL_CONTENT (config_model_id, name, content_type),
\r
48 FOREIGN KEY FK_CONFIG_MODEL_CONTENT (config_model_id) REFERENCES sdnctl.CONFIG_MODEL(config_model_id) ON DELETE CASCADE
\r
51 -- -----------------------------------------------------
\r
53 -- -----------------------------------------------------
\r
54 CREATE TABLE IF NOT EXISTS sdnctl.MODEL_TYPE (
\r
55 model_name VARCHAR(100) NOT NULL,
\r
56 derived_from VARCHAR(100) NOT NULL,
\r
57 definition_type VARCHAR(100) NOT NULL,
\r
58 definition LONGTEXT NOT NULL,
\r
59 version VARCHAR(10) NOT NULL,
\r
60 description LONGTEXT NOT NULL,
\r
61 tags LONGTEXT NULL DEFAULT NULL,
\r
62 creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
63 updated_by VARCHAR(100) NOT NULL,
\r
64 PRIMARY KEY PK_MODEL_TYPE (model_name),
\r
65 INDEX IX_MODEL_TYPE (model_name)
\r
69 -- -----------------------------------------------------
\r
70 -- table RESOURCE_DICTIONARY
\r
71 -- -----------------------------------------------------
\r
72 CREATE TABLE IF NOT EXISTS sdnctl.RESOURCE_DICTIONARY (
\r
73 name VARCHAR(100) NOT NULL,
\r
74 data_type VARCHAR(100) NOT NULL,
\r
75 entry_schema VARCHAR(100) NULL DEFAULT NULL,
\r
76 definition LONGTEXT NOT NULL,
\r
77 description LONGTEXT NOT NULL,
\r
78 tags LONGTEXT NOT NULL,
\r
79 creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
80 updated_by VARCHAR(100) NOT NULL,
\r
81 primary key PK_RESOURCE_DICTIONARY (name),
\r
82 INDEX IX_RESOURCE_DICTIONARY (name)
\r