Today, the friend of the AgileFlow project DGPCK@msn.com sent the Schedule script of AgileFlow's MySQL database. He built a table test. I grate on DGPCK@msN.com on behalf of the AgileFlow project group and represents him to him. Spiritual support is paying tribute.
******* Agile.sql: *************** USE Agile; Drop Table AgileActivity; Create Table AgileActivity (ActivityId Varchar (100) Default 'NOT NULL, ProcessInSid VARCHAR (100) Default '' NOT NULL, STATUS VARCHAR (100) DEFAULT NULL, AcceptUserid Varchar (100) Default Null; Create Unique Index AgileActivity_Key On AgileActivity (ActivityInSid);
DROP TABLE processInstance; CREATE TABLE processInstance (processInsId varchar (100) default '' NOT NULL, parentProcessInsId varchar (100) default '' NULL, parentActivityInsId varchar (100) default '' NULL); create unique index processInstance_key on processInstance (processInsId);
DROP TABLE driveTypeTable; CREATE TABLE driveTypeTable (fromActivityInsId varchar (100) default '' NOT NULL, nextActivityDefId varchar (100) default '' NOT NULL); create unique index driveTypeTable_key on driveTypeTable (fromActivityInsId, nextActivityDefId); ******* *********************************************************** ***********
************* RESQL ****************************************************** ************** use agile; / * delete the resource object table * / drop table res_object_relation; drop table res_role; drop table res_object_priv; drop table res_privilege_type; drop table res_user; drop table res_ou; drop Table res_Object; Drop Table Res_ID;
Create Table Res_ID (TableName Varchar (100) Not Null, Value Int Default 0 NULL); / * Initializing ID Table * / Insert INTO RES_ID VALUES ('RES_Object', 4); Insert Into Res_ID VALUES ('RES_Object_Priv', 3) ;
Create Table Res_Object (ID INT NULL, TYER INT NULL); INSERT INTO RES_OBJECT VALUES (1, 1, 0); Insert Into Res_Object Values (2, 2, 0); Insert Into Res_Object Values (3, 3, 3, 3 , 0); Create Table Res_ou (ID INT NOT NULL, NAME VARCHAR (100) Not Null, Description Varchar (255) null, is_deleted int default 0 null; / * Initialization Supreme Organization * / Insert Into Res_ou Values (1, ' AgileFlow ',' ', 0); Create Table Res_User (ID INT NOT NULL, NAME VARCHAR (100) Not Null, Loginname VARCHAR (100) NULL, Phone Varchar (20) Null, Email Varchar (100) null, password varchar (128) not null); insert into res_user values (2, 'the system administrator', 'hongsoft', '', '', '21232f297a57a5a743894a0e4a801fc3'); create table res_role (id int not null, name varchar (100) NOT NULL, DESCRIPTION VARCHAR (100) null; INSERT INTO RES_ROLE VALUES (3, 'System Management Role ",' System Management Role ');
create table res_object_relation (child_id int not null, parent_id int not null, is_extend int default 0 not null); / * Add the system administrator tissue AgileFlow * / insert into res_object_relation values (2,1,1); create table res_privilege_type (id int not null, name varchar (100) not null, description varchar (255) null); insert into res_privilege_type values (1, 'system management', 'administrative rights'); create table res_object_priv (id int not null, object_id int NOT NULL, PRIV_TYPE_ID INT NOT NULL; INSERT INTO RES_OBJECT_PRIV VALUES (1, 2, 1); Insert Into Res_Object_Priv Values (2, 3, 1); **************** *********************************************************** ******************
