osworkflow_leaveApprove_mysql

drop table if exists OS_PROPERTYENTRY cascade; create table OS_PROPERTYENTRY ( GLOBAL_KEY varchar(250) NOT NULL, ITEM_KEY varchar(250) NOT NULL, ITEM_TYPE tinyint, STRING_VALUE varchar(255), DATE_VALUE datetime, DATA_VALUE blob, FLOAT_VALUE float, NUMBER_VALUE numeric, primary key (GLOBAL_KEY, ITEM_KEY) )TYPE=InnoDB; -- Beginning of Default OSUser tables drop table if exists OS_USER cascade; create table OS_USER ( USERNAME varchar(100) NOT NULL, PASSWORDHASH mediumtext, primary key (USERNAME), index(USERNAME) )TYPE=InnoDB; drop table if exists OS_GROUP cascade; create table OS_GROUP ( GROUPNAME varchar(20) NOT NULL, primary key (GROUPNAME) )TYPE=InnoDB; drop table if exists OS_MEMBERSHIP cascade; create table OS_MEMBERSHIP ( USERNAME varchar(20) NOT NULL, GROUPNAME varchar(20) NOT NULL, primary key (USERNAME, GROUPNAME), index (USERNAME), foreign key (USERNAME) references OS_USER(USERNAME), index (GROUPNAME), foreign key (GROUPNAME) references OS_GROUP(GROUPNAME) )TYPE=InnoDB; -- End of Default OSUser tables drop table if exists OS_WFENTRY cascade; create table OS_WFENTRY ( ID bigint NOT NULL, NAME varchar(60), STATE integer, primary key (ID) )TYPE=InnoDB; drop table if exists OS_CURRENTSTEP; create table OS_CURRENTSTEP ( ID bigint NOT NULL, ENTRY_ID bigint, STEP_ID integer, ACTION_ID integer, OWNER varchar(35), START_DATE datetime, FINISH_DATE datetime, DUE_DATE datetime, STATUS varchar(40), CALLER varchar(35), primary key (ID), index (ENTRY_ID), foreign key (ENTRY_ID) references OS_WFENTRY(ID), index (OWNER), foreign key (OWNER) references OS_USER(USERNAME), index (CALLER), foreign key (CALLER) references OS_USER(USERNAME) )TYPE=InnoDB; drop table if exists OS_HISTORYSTEP; create table OS_HISTORYSTEP ( ID bigint NOT NULL, ENTRY_ID bigint, STEP_ID integer, ACTION_ID integer, OWNER varchar(35), START_DATE datetime, FINISH_DATE datetime, DUE_DATE datetime, STATUS varchar(40), CALLER varchar(35), primary key (ID), index (ENTRY_ID), foreign key (ENTRY_ID) references OS_WFENTRY(ID), index (OWNER), foreign key (OWNER) references OS_USER(USERNAME), index (CALLER), foreign key (CALLER) references OS_USER(USERNAME) )TYPE=InnoDB; drop table if exists OS_CURRENTSTEP_PREV; create table OS_CURRENTSTEP_PREV ( ID bigint NOT NULL, PREVIOUS_ID bigint NOT NULL, primary key (ID, PREVIOUS_ID), index (ID), foreign key (ID) references OS_CURRENTSTEP(ID), index (PREVIOUS_ID), foreign key (PREVIOUS_ID) references OS_HISTORYSTEP(ID) )TYPE=InnoDB; drop table if exists OS_HISTORYSTEP_PREV; create table OS_HISTORYSTEP_PREV ( ID bigint NOT NULL, PREVIOUS_ID bigint NOT NULL, primary key (ID, PREVIOUS_ID), index (ID), foreign key (ID) references OS_HISTORYSTEP(ID), index (PREVIOUS_ID), foreign key (PREVIOUS_ID) references OS_HISTORYSTEP(ID) )TYPE=InnoDB; drop table if exists OS_STEPIDS; CREATE TABLE OS_STEPIDS ( ID bigint NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) )TYPE=InnoDB; drop table if exists OS_ENTRYIDS; CREATE TABLE OS_ENTRYIDS ( ID bigint NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) )TYPE=InnoDB; drop table if exists bus_leaveApply cascade; create table bus_leaveApply ( applyID bigint NOT NULL AUTO_INCREMENT, applicant varchar(50) NOT NULL, reason varchar(200), dayCount varchar(50), applyTime varchar(50), wfid bigint NOT NULL, primary key (applyID) )TYPE=InnoDB; drop table if exists bus_leaveApprove cascade; create table bus_leaveApprove ( approveID bigint NOT NULL AUTO_INCREMENT, applyID bigint NOT NULL, approver varchar(50) NOT NULL, approveTime varchar(50), opinion int NOT NULL, primary key (approveID) )TYPE=InnoDB; INSERT INTO OS_USER (USERNAME,PASSWORDHASH) VALUES ('employee1','7iaw3Ur350mqGo7jwQrpkj9hiYB3Lkc/iBml1JQODbJ6wYX4oOHV+E+IvIh/1nsUNzLDBMxfqa2Ob1f1ACio/w==') INSERT INTO OS_USER (USERNAME,PASSWORDHASH) VALUES ('hr1','7iaw3Ur350mqGo7jwQrpkj9hiYB3Lkc/iBml1JQODbJ6wYX4oOHV+E+IvIh/1nsUNzLDBMxfqa2Ob1f1ACio/w==') INSERT INTO OS_USER (USERNAME,PASSWORDHASH) VALUES ('manager1','7iaw3Ur350mqGo7jwQrpkj9hiYB3Lkc/iBml1JQODbJ6wYX4oOHV+E+IvIh/1nsUNzLDBMxfqa2Ob1f1ACio/w==') INSERT INTO OS_GROUP (GROUPNAME) VALUES ('employee') INSERT INTO OS_GROUP (GROUPNAME) VALUES ('hr') INSERT INTO OS_GROUP (GROUPNAME) VALUES ('manager') INSERT INTO OS_MEMBERSHIP (USERNAME,GROUPNAME) VALUES ('employee1','employee') INSERT INTO OS_MEMBERSHIP (USERNAME,GROUPNAME) VALUES ('hr1','hr') INSERT INTO OS_MEMBERSHIP (USERNAME,GROUPNAME) VALUES ('manager1','manager')