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