RecruitmentService/db/oa/jeesite_mssql.sql

/* 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);