1 -- -----------------------------------------------------
2 -- Dropping tables ( One time )
3 -- -----------------------------------------------------
5 DROP TABLE sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA;
6 DROP TABLE sdnctl.CONFIG_RESOURCE;
7 DROP TABLE sdnctl.CONFIG_RESOURCE_RELATION;
8 DROP TABLE sdnctl.CONFIG_TRANSACTION_LOG
11 -- -----------------------------------------------------
12 -- table sdnctl.CONFIG_TRANSACTION_LOG
13 -- -----------------------------------------------------
14 CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_TRANSACTION_LOG (
15 config_transaction_log_id VARCHAR(50) NOT NULL,
16 request_id VARCHAR(50) NULL DEFAULT NULL,
17 message_type VARCHAR(100) NULL DEFAULT NULL,
18 creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
19 message LONGTEXT NULL DEFAULT NULL,
20 PRIMARY KEY PK_CONFIG_TRANSACTION_LOG (config_transaction_log_id)
21 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
24 -- -----------------------------------------------------
25 -- table sdnctl.CONFIG_RESOURCE
26 -- -----------------------------------------------------
27 CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_RESOURCE (
28 config_resource_id VARCHAR(50) NOT NULL,
29 resource_id VARCHAR(50) NOT NULL,
30 resource_type VARCHAR(50) NOT NULL,
31 service_template_name VARCHAR(50) NULL DEFAULT NULL,
32 service_template_version VARCHAR(50) NULL DEFAULT NULL,
33 template_name VARCHAR(50) NOT NULL,
34 recipe_name VARCHAR(50) NOT NULL,
35 request_id VARCHAR(50) NOT NULL,
36 resource_data LONGTEXT NULL DEFAULT NULL,
37 mask_data LONGTEXT NULL DEFAULT NULL,
38 created_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
39 status VARCHAR(20) NOT NULL,
40 updated_by VARCHAR(50) NOT NULL,
41 PRIMARY KEY PK_CONFIG_RESOURCE (config_resource_id),
42 INDEX IX_CONFIG_RESOURCE (created_date desc)
43 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
46 -- -----------------------------------------------------
47 -- table sdnctl.CONFIG_RESOURCE_RELATION
48 -- -----------------------------------------------------
49 CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_RESOURCE_RELATION (
50 config_resource_relation_id VARCHAR(50) NOT NULL,
51 resource_id VARCHAR(50) NOT NULL,
52 related_resource_id VARCHAR(50) NOT NULL,
53 relation_type VARCHAR(50) NOT NULL DEFAULT 'children',
54 created_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
55 updated_by VARCHAR(50) NOT NULL,
56 PRIMARY KEY PK_CONFIG_RESOURCE_RELATION (config_resource_relation_id),
57 INDEX IX_CONFIG_RESOURCE_RELATION (created_date desc),
58 CONSTRAINT FK_CONFIG_RESOURCE_RELATION_TO_CONFIG_RESOURCE1
59 FOREIGN KEY (resource_id)
60 REFERENCES sdnctl.CONFIG_RESOURCE (config_resource_id)
63 CONSTRAINT FK_CONFIG_RESOURCE_RELATION_TO_CONFIG_RESOURCE2
64 FOREIGN KEY (related_resource_id)
65 REFERENCES sdnctl.CONFIG_RESOURCE (config_resource_id)
68 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71 -- -----------------------------------------------------
72 -- table sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA
73 -- -----------------------------------------------------
74 CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA (
75 config_resource_assignment_data_id VARCHAR(50) NOT NULL,
76 config_resource_id VARCHAR(50) NOT NULL,
77 version INT(11) NOT NULL,
78 updated_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
79 updated_by VARCHAR(50) NOT NULL,
80 template_key_name VARCHAR(50) NOT NULL,
81 resource_name VARCHAR(50) NOT NULL,
82 data_type VARCHAR(100) NOT NULL,
83 entry_schema VARCHAR(100) NULL DEFAULT NULL,
84 resource_value LONGTEXT NOT NULL,
85 source VARCHAR(50) NOT NULL,
86 status VARCHAR(50) NOT NULL,
87 message LONGTEXT NOT NULL,
88 PRIMARY KEY PK_CONFIG_RESOURCE (config_resource_assignment_data_id),
89 INDEX IX_CONFIG_RESOURCE (updated_date desc),
90 CONSTRAINT FK_CONFIG_RESOURCE_ASSIGNMENT_DATA
91 FOREIGN KEY (config_resource_id)
92 REFERENCES sdnctl.CONFIG_RESOURCE (config_resource_id)
95 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;