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