workflow.sql

一 安装MYSQL..建立workflow库,将包中的WORKFLOW.SQL数据导入库1:首先确定系统中安装了JRE1.4.2以上的JAVA运行环境2:然后将该RAR包解压到本地磁盘上3:修改数据库

INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("1", "edge0", "node0", "node1", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("1", "edge1", "node6", "node0", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("1", "edge2", "node2", "node4", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("1", "edge3", "node1", "node4", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("1", "edge4", "node3", "node5", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("2", "edge5", "node0", "node2", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("1", "edge6", "node4", "node3", "0", "test");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("2", "edge0", "node1", "node0", "0", "abc");
INSERT INTO edge_control (id, edge_id, from_step, to_step, flow_master_id, graph_id) VALUES("3", "edge1", "node0", "node2", "0", "abc");


#
# Table structure for table 'flow_manager'
#

CREATE TABLE flow_manager (
  id tinyint(3) unsigned NOT NULL auto_increment,
  graph_id int(11) unsigned NOT NULL default '0',
  flow_name varchar(30) NOT NULL default '',
  flow_status tinyint(3) unsigned default '0',
  docid varchar(60) NOT NULL default '0',
  flow_startup_time varchar(30) default NULL,
  flow_end_time varchar(30) default NULL,
  flow_runtime_limit varchar(30) default NULL,
  flow_create_time varchar(30) default NULL,
  Department_id int(3) unsigned default NULL,
  PRIMARY KEY  (id,docid,flow_name)
) TYPE=MyISAM;



#
# Dumping data for table 'flow_manager'
#

INSERT INTO flow_manager (id, graph_id, flow_name, flow_status, docid, flow_startup_time, flow_end_time, flow_runtime_limit, flow_create_time, Department_id) VALUES("9", "0", "test", "1", "z20041230", "2004-12-30 10:12:41", "", "", "2004-12-30 10:11:22", "0");
INSERT INTO flow_manager (id, graph_id, flow_name, flow_status, docid, flow_startup_time, flow_end_time, flow_runtime_limit, flow_create_time, Department_id) VALUES("11", "0", "abc", "0", "无文件", "", "", "", "2004-01-12 11:01:27", "4");


#
# Table structure for table 'route_control'
#

CREATE TABLE route_control (
  route_id tinyint(3) unsigned NOT NULL default '0',
  route_name tinyint(3) unsigned default '0',
  step_id tinyint(3) unsigned NOT NULL default '0',
  route_stepid tinyint(3) unsigned NOT NULL default '0',
  graph_id tinyint(3) unsigned default NULL,
  PRIMARY KEY  (route_id,step_id)
) TYPE=MyISAM;



#
# Dumping data for table 'route_control'
#



#
# Table structure for table 'step_detail'
#

CREATE TABLE step_detail (
  id int(11) unsigned NOT NULL auto_increment,
  flow_id varchar(11) NOT NULL default '0',
  step_id varchar(11) NOT NULL default '0',
  user_id int(11) NOT NULL default '0',
  action_type varchar(11) default '0',
  action_result varchar(11) default '0',
  action_time varchar(30) default NULL,
  action_record varchar(60) default NULL,
  action_status varchar(11) default NULL,
  time_limit varchar(30) default NULL,
  action_startup_time varchar(30) default NULL,
  action_end_time varchar(30) default NULL,
  route_node varchar(12) default NULL,
  PRIMARY KEY  (id,flow_id,step_id)
) TYPE=MyISAM;



#
# Dumping data for table 'step_detail'
#

INSERT INTO step_detail (id, flow_id, step_id, user_id, action_type, action_result, action_time, action_record, action_status, time_limit, action_startup_time, action_end_time, route_node) VALUES("38", "test", "node0", "3001", "1", "1", NULL, "", "1", NULL, NULL, NULL, "1");


#
# Table structure for table 'step_main'
#

CREATE TABLE step_main (
  id tinyint(3) unsigned NOT NULL auto_increment,
  step_name char(30) NOT NULL default '',
  graph_id char(30) NOT NULL default '',
  is_active tinyint(3) unsigned NOT NULL default '0',
  step_id char(30) NOT NULL default '',
  is_routed tinyint(3) unsigned default '0',
  visited int(3) unsigned default '0',
  allow_toback int(3) default '0',
  PRIMARY KEY  (id,step_id,graph_id,is_active),
  KEY step_name (step_name)
) TYPE=MyISAM;



#
# Dumping data for table 'step_main'
#

INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "1", "test", "1", "node0", "0", "0", "1");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "工作结束", "test", "0", "node5", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "3", "test", "0", "node2", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "2", "test", "0", "node1", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "工作开始", "test", "0", "node6", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "5", "test", "0", "node3", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "4", "test", "0", "node4", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "新节点", "abc", "0", "node0", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "工作结束", "abc", "0", "node2", "0", "0", "0");
INSERT INTO step_main (id, step_name, graph_id, is_active, step_id, is_routed, visited, allow_toback) VALUES("255", "工作开始", "abc", "0", "node1", "0", "0", "0");


#
# Table structure for table 'user'
#

CREATE TABLE user (
  id int(11) default NULL,
  loginname varchar(20) default NULL,
  username varchar(20) default NULL,
  pass varchar(12) default NULL,
  userhomepage varchar(50) default NULL,
  hometel varchar(50) default NULL,
  officetel varchar(50) default NULL,
  mobile varchar(50) default NULL,
  useremail varchar(30) default NULL,
  department_id smallint(6) default NULL,
  department_level smallint(6) default NULL,
  enable tinyint(1) NOT NULL default '0',
  lastlogin varchar(50) default NULL,
  isflow tinyint(1) NOT NULL default '0',
  usernote varchar(120) default NULL,
  userclass int(11) default NULL,
  userbirthday datetime default NULL,
  usersex varchar(10) default NULL,
  comefrom varchar(20) default NULL,
  usersign varchar(50) default NULL,
  dateandtime datetime default NULL,
  master double default NULL,
  hpname varchar(20) default NULL,
  online tinyint(1) default NULL,
  KEY id (id),
  KEY idd (loginname),
  KEY iddd (online)
) TYPE=MyISAM;



#
# Dumping data for table 'user'
#

INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3001", "administrator", "管理员", "49", "http://www.cdxw.com", "86-28-8967****", "86-28-87365022", "133080******", "[e-mail]", "4", "37", "1", "2004-4-08 10:42", "1", "SB!呵呵~~~~~~~~~~~", "47", "1977-06-16 00:00:00", "男", "中国四川", "0", "2002-03-02 15:33:33", "300", NULL, "1");
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3006", "test1", "test1", "49", "http://", "86-28-85012345", "86-20-84655520", "13308066666", "[e-mail]", "11", "-1", "1", "2004-6-22 16:04", "1", "说啥子哦~~~~~~~~~", "0", "1960-02-14 00:00:00", "男", "成都市锦江取", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3007", "test2", "test2", "49", "http://", "86-28-85012345", "86-20-84655520", "13308066666", "[e-mail]", "12", "-1", "1", "2004-6-22 16:05", "1", "SB", "0", "1965-04-01 00:00:00", "男", "成都市锦江区", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3003", "rjt", "任静", "49", "http://www.cdxw.com", "86-28-85012345", "86-28-87365022", "13308066666", "[e-mail]", "9", "47", "1", "2004-4-21 13:40", "1", "", "3", "1988-10-01 00:00:00", "女", "四川省成都市", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3004", "rjj", "任刚", "49", "http://www.rjt-rjj4795.com", "86-825-6684888", "86-20-84655520", "13988088888", "[e-mail]", "8", "52", "1", "2004-4-08 11:42", "1", "呵呵~~~~~~~~~~~~", "1", "1985-03-21 00:00:00", "男", "中国四川省", NULL, NULL, "200", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3002", "beyond", "尧庆宇", "49", "http://www.517love.com", "86-28-87362440", "86-28-87365022", "13688088888", "[e-mail]", "7", "54", "1", "2004-7-02 14:13", "1", "", "0", "1980-10-11 00:00:00", "男", "成都市武侯区", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3009", "super", "superman", "49", "http://", "", "", "", "", "5", "58", "1", "2004-7-06 10:56", "1", "", "0", "1900-01-01 00:00:00", "男", "sadfas", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3005", "rj", "王语嫣", "49", "http://www.cdxw.com", "86-28-87362440", "86-20-84655520", "13308066666", "[e-mail]", "7", "57", "1", "2004-6-28 09:42", "1", "呵呵~~~~~~~~~~~~~~~", "0", "1986-03-20 00:00:00", "女", "四川省", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3008", "test", "test", "3556498", "http://", "", "", "", "", "15", "60", "1", "2004-7-01 17:03", "1", "", "0", "1900-01-01 00:00:00", "男", "", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3010", "sdf", "sfd", "49", "http://", "", "", "", "", "7", "3002", "1", "2004-7-07 11:38", "1", "", "0", "1900-01-01 00:00:00", "男", "sdf", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3011", "asdf", "sdf", "49", "http://", "", "", "", "", "13", "0", "1", "2004-7-08 14:24", "1", "sdf", "0", "1900-01-01 00:00:00", "男", "sdf", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3012", "ytuty", "tyu", "49", "http://", "", "", "", "", "13", "3011", "1", "2004-7-08 14:25", "1", "", "0", "1900-01-01 00:00:00", "男", "tyu", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3013", "atest", "test1", "49", "http://", "", "", "", "", "12", "63", "1", "2004-7-30 09:42", "1", "", "0", "1900-01-01 00:00:00", "男", "", NULL, NULL, "0", NULL, NULL);
INSERT INTO user (id, loginname, username, pass, userhomepage, hometel, officetel, mobile, useremail, department_id, department_level, enable, lastlogin, isflow, usernote, userclass, userbirthday, usersex, comefrom, usersign, dateandtime, master, hpname, online) VALUES("3014", "sdfss", "sadfss", "49", "http://", "", "", "", "", "10", "42", "1", "2004-7-30 09:46", "1", "", "0", "1900-01-01 00:00:00", "男", "", NULL, NULL, "0", NULL, NULL);