jeesite_mssql.sql
2.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
/* Drop Tables*/
DROP TABLE gen_scheme;
DROP TABLE gen_table_column;
DROP TABLE gen_table;
DROP TABLE gen_template;
/* Create Tables */
CREATE TABLE gen_scheme
(
id varchar(64) NOT NULL,
name varchar(200),
category varchar(2000),
package_name varchar(500),
module_name varchar(30),
sub_module_name varchar(30),
function_name varchar(500),
function_name_simple varchar(100),
function_author varchar(100),
gen_table_id varchar(200),
create_by varchar(64),
create_date datetime,
update_by varchar(64),
update_date datetime,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE gen_table
(
id varchar(64) NOT NULL,
name varchar(200),
comments varchar(500),
class_name varchar(100),
parent_table varchar(200),
parent_table_fk varchar(100),
create_by varchar(64),
create_date datetime,
update_by varchar(64),
update_date datetime,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE gen_table_column
(
id varchar(64) NOT NULL,
gen_table_id varchar(64),
name varchar(200),
comments varchar(500),
jdbc_type varchar(100),
java_type varchar(500),
java_field varchar(200),
is_pk char(1),
is_null char(1),
is_insert char(1),
is_edit char(1),
is_list char(1),
is_query char(1),
query_type varchar(200),
show_type varchar(200),
dict_type varchar(200),
settings varchar(2000),
sort decimal,
create_by varchar(64),
create_date datetime,
update_by varchar(64),
update_date datetime,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE gen_template
(
id varchar(64) NOT NULL,
name varchar(200),
category varchar(2000),
file_path varchar(500),
file_name varchar(200),
content text,
create_by varchar(64),
create_date datetime,
update_by varchar(64),
update_date datetime,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
/* Create Indexes */
CREATE INDEX gen_scheme_del_flag ON gen_scheme (del_flag ASC);
CREATE INDEX gen_table_name ON gen_table (name ASC);
CREATE INDEX gen_table_del_flag ON gen_table (del_flag ASC);
CREATE INDEX gen_table_column_table_id ON gen_table_column (gen_table_id ASC);
CREATE INDEX gen_table_column_name ON gen_table_column (name ASC);
CREATE INDEX gen_table_column_sort ON gen_table_column (sort ASC);
CREATE INDEX gen_table_column_del_flag ON gen_table_column (del_flag ASC);
CREATE INDEX gen_template_del_falg ON gen_template (del_flag ASC);