create table tree (
 id int auto_increment,
 name varchar(200) not null,
 desc varchar(1024),
 type varchar(50) not null,
 parent_id int not null,
 index int not null,
 path varchar(1024) null,
 enable BOOLEAN not null,
 PRIMARY key (id)
);
create index idx_tree_pid on tree(parent_id);

create table param (
 id int auto_increment,
 name varchar(200) not null,
 tree_node_id int not null,
 category varchar(50) not null,
 index int not null,
 class_name varchar(256) not null,
 value varchar(1024) not null,
 desc varchar(1024) not null,
 PRIMARY key(id)
);
create index idx_param on param(tree_node_id);
create index udx_param on param(name, tree_node_id);

create table test_method (
 id int auto_increment,
 tree_node_id int not null,
 param_id int not null,
 class_name varchar(256) not null,
 method_name varchar(512) not null,
 instance_class_name varchar(100) not null,
 PRIMARY key(id)
);
create index idx_test_method on test_method(tree_node_id);

create table test_method_data (
 id int auto_increment,
 name varchar(200) not null,
 test_method_id int not null,
 data text not null,
 var_name varchar(200),
 PRIMARY key(id)
);
create index idx_test_method_data on test_method_data(test_method_id);

create table increment_var (
 id int auto_increment,
 name varchar(200) not null,
 value bigint not null,
 step int not null,
 PRIMARY key(id)
);
create UNIQUE index udx_name on increment_var(name);

create table bean_var (
 id int auto_increment,
 index int not null,
 tree_node_id int not null,
 name varchar(200) not null,
 type varchar(50) not null,
 database_param_id int,
 sql varchar(1024),
 args varchar(1024),
 package_param_id int,
 class_name varchar(512),
 instance_class_type varchar(100),
 method_name varchar(2048),
 PRIMARY key(id)
);
create index idx_tid_bean_var on bean_var(tree_node_id);
create index idx_name_bean_var on bean_var(name);

create table sql_check (
 id int auto_increment,
 tree_node_id int not null,
 name varchar(200) not null,
 sql varchar(1024) not null,
 database_param_id int not null,
 sql_struct varchar(1024) not null,
 args varchar(256) not null,
 PRIMARY key(id)
);
create index idx_tid_sql_check on sql_check(tree_node_id);
create index idx_name_sql_check on sql_check(name);

create table sql_check_data (
 id int auto_increment,
 sql_check_id int not null,
 content varchar(2048) not null,
 index int not null,
 PRIMARY key(id)
);
create index idx_scid_scd on sql_check_data(sql_check_id);

create table test_http (
 id int auto_increment,
 url varchar(1024) not null,
 method varchar(50) not null,
 tree_node_id int not null,
 PRIMARY key(id)
);
create index idx_tnid_test_http on test_http(tree_node_id);

create table test_http_param (
 id int auto_increment,
 test_http_id int not null,
 name varchar(100),
 content varchar(1024),
 type varchar(100),
 enable tinyint,
 PRIMARY key (id)
);
create index idx_thid_test_http_param on test_http_param(test_http_id);

create table test_http_body (
 id int auto_increment,
 test_http_id int not null,
 body varchar(2048),
 content_type varchar(100),
 PRIMARY key (id)
);
create index idx_thid_test_http_body on test_http_body(test_http_id);

create table test_http_result (
 id int auto_increment,
 test_http_id int not null,
 result varchar(2048),
 var_name varchar(100),
 PRIMARY key (id)
);
create index idx_thid_test_http_result on test_http_result(test_http_id);

create table test_log (
 id INT AUTO_INCREMENT,
 name VARCHAR(512) NOT NULL,
 create_time TIMESTAMP NOT NULL,
 success int NOT NULL,
 type VARCHAR(50) not null,
 parent_id int not null,
 success_num INT NOT NULL,
 failure_num INT NOT NULL
);
create index idx_tl_parent_id on test_log(parent_id);

create table test_log_data (
 id int auto_increment,
 test_log_id int not null,
 name varchar(512) not null,
 type VARCHAR(50) not null,
 content clob not null
);
create index idx_tld_log_id on test_log_data(test_log_id);

create table bean_check (
 id int auto_increment,
 tree_node_id int not null,
 check_name varchar(128) not null,
 other_info varchar(256),
 bean_type varchar(64) not null,
 columns varchar(512) not null,
 content clob not null
);
create unique index idx_bc_tnid on bean_check(tree_node_id);

create table common_fun (
 id int auto_increment,
 tree_node_id int not null,
 name varchar(200) not null,
 package_param_id int,
 class_name varchar(512),
 desc varchar(512),
 PRIMARY key(id)
);
create index idx_tid_common_fun on common_fun(tree_node_id);

create table sql_data (
 id int auto_increment,
 tree_node_id int not null,
 database_param_id int not null,
 handle_type varchar(56) not null,
 data_type varchar(56) not null,
 data clob not null
);
create index idx_tid_sql_data on sql_data(tree_node_id);

create table data_export (
 id int auto_increment,
 tree_node_id int not null,
 database_param_id int not null,
 dir varchar(256) not null,
 name varchar(256) not null,
 data clob not null
);
create index idx_tid_data_export on data_export(tree_node_id);

create table get_result_value (
 id int auto_increment,
 tree_node_id int not null,
 name varchar(256) not null,
 value varchar(256) not null,
 type varchar(256) not null
);
create index idx_tid_get_result_value on get_result_value(tree_node_id);