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
/* Drop Tables */
DROP TABLE oa_leave;
DROP TABLE oa_notify_record;
DROP TABLE oa_notify;
DROP TABLE OA_TEST_AUDIT;
/* Create Tables */
CREATE TABLE oa_leave
(
id varchar(64) NOT NULL,
process_instance_id varchar(64),
start_time datetime,
end_time datetime,
leave_type varchar(20),
reason varchar(255),
apply_time datetime,
reality_start_time datetime,
reality_end_time datetime,
create_by varchar(64) NOT NULL,
create_date datetime NOT NULL,
update_by varchar(64) NOT NULL,
update_date datetime NOT NULL,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE oa_notify
(
id varchar(64) NOT NULL,
type char(1),
title varchar(200),
content varchar(2000),
files varchar(2000),
status char(1),
create_by varchar(64) NOT NULL,
create_date datetime NOT NULL,
update_by varchar(64) NOT NULL,
update_date datetime NOT NULL,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE oa_notify_record
(
id varchar(64) NOT NULL,
oa_notify_id varchar(64),
user_id varchar(64),
read_flag char(1) DEFAULT '0',
read_date smalldatetime,
PRIMARY KEY (id)
);
CREATE TABLE OA_TEST_AUDIT
(
id varchar(64) NOT NULL,
PROC_INS_ID varchar(64),
USER_ID varchar(64),
OFFICE_ID varchar(64),
POST varchar(255),
AGE char(1),
EDU varchar(255),
CONTENT varchar(255),
OLDA varchar(255),
OLDB varchar(255),
OLDC varchar(255),
NEWA varchar(255),
NEWB varchar(255),
NEWC varchar(255),
ADD_NUM varchar(255),
EXE_DATE varchar(255),
HR_TEXT varchar(255),
LEAD_TEXT varchar(255),
MAIN_LEAD_TEXT varchar(255),
create_by varchar(64) NOT NULL,
create_date datetime NOT NULL,
update_by varchar(64) NOT NULL,
update_date datetime NOT NULL,
remarks varchar(255),
del_flag char(1) DEFAULT '0' NOT NULL,
CONSTRAINT SYS_C0016476 PRIMARY KEY (id)
);
/* Create Indexes */
CREATE INDEX oa_leave_create_by ON oa_leave (create_by ASC);
CREATE INDEX oa_leave_process_instance_id ON oa_leave (process_instance_id ASC);
CREATE INDEX oa_leave_del_flag ON oa_leave (del_flag ASC);
CREATE INDEX oa_notify_del_flag ON oa_notify (del_flag ASC);
CREATE INDEX oa_notify_record_notify_id ON oa_notify_record (oa_notify_id ASC);
CREATE INDEX oa_notify_record_user_id ON oa_notify_record (user_id ASC);
CREATE INDEX oa_notify_record_read_flag ON oa_notify_record (read_flag ASC);
CREATE INDEX OA_TEST_AUDIT_del_flag ON OA_TEST_AUDIT (del_flag ASC);