workflow.sql

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

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: workflow
# --------------------------------------------------------
# Server version 4.0.20a-debug

USE workflow;


#
# Table structure for table 'department'
#

CREATE TABLE department (
  id int(11) default NULL,
  name varchar(30) default NULL,
  parent_id int(11) default NULL,
  isflow tinyint(1) NOT NULL default '0',
  UNIQUE KEY id (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;



#
# Dumping data for table 'department'
#

INSERT INTO department (id, name, parent_id, isflow) VALUES("5", "局级部门", "0", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("4", "系统维护", "0", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("12", "三级子部门", "11", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("10", "政协办公室", "5", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("9", "人大办公室", "5", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("8", "政府办公室", "5", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("7", "市委办公室", "5", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("11", "二级子部门", "10", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("13", "连队干部", "12", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("14", "团部", "13", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("15", "师部", "14", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("16", "新增部门", "0", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("17", "新增二级", "16", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("18", "测试部门", "0", "0");
INSERT INTO department (id, name, parent_id, isflow) VALUES("19", "软件测试", "18", "0");


#
# Table structure for table 'department_level'
#

CREATE TABLE department_level (
  id int(11) default NULL,
  department_id int(11) default NULL,
  level_name varchar(50) default NULL,
  KEY id (id,department_id)
) TYPE=MyISAM;



#
# Dumping data for table 'department_level'
#

INSERT INTO department_level (id, department_id, level_name) VALUES("37", "4", "系统管理员");


#
# Table structure for table 'departmentmember'
#

CREATE TABLE departmentmember (
  department_id int(11) NOT NULL default '0',
  user_id int(11) NOT NULL default '0',
  user_name varchar(20) default NULL,
  depart_level int(11) NOT NULL default '0',
  PRIMARY KEY  (user_id,department_id,depart_level),
  KEY id (department_id)
) TYPE=MyISAM;



#
# Dumping data for table 'departmentmember'
#

INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("4", "3001", "administrator", "37");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("25", "3029", "swenyu", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("10", "3002", "beyond", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("24", "3026", "nli", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("25", "3030", "yyan", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("7", "3028", "yli", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("24", "3027", "lwansu", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("31", "3003", "lyongkui", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("31", "3004", "zhai", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("31", "3005", "lsheng", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("31", "3006", "lzhiqiong", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("17", "3007", "lkaiqin", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("17", "3008", "hjing", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("31", "3041", "lzx", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("22", "3010", "lli", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("22", "3011", "shui", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("22", "3012", "jxu", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("20", "3013", "pdan", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("20", "3014", "ldeying", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("16", "3015", "ryun", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("13", "3016", "xlin", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("34", "3017", "hfei", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("21", "3018", "lchunhua", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("15", "3019", "ywenjian", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("8", "3020", "xyue", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("9", "3021", "wweijun", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("10", "3022", "hyi", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("10", "3023", "syongqiong", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("23", "3024", "ljia", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("23", "3025", "lxiaoyan", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("14", "3031", "wrui", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("29", "3032", "zjuan", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("5", "3033", "mjiacheng", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("26", "3034", "lzelun", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("12", "3035", "lyingxing", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("6", "3036", "wmin", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("28", "3037", "xchanyu", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("33", "3038", "fyuzheng", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("27", "3039", "lbin", "0");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("11", "3040", "xfdd", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("29", "3042", "test", "-1");
INSERT INTO departmentmember (department_id, user_id, user_name, depart_level) VALUES("5", "3043", "qqq", "-1");


#
# Table structure for table 'document'
#

CREATE TABLE document (
  docid int(30) NOT NULL auto_increment,
  hashcode float NOT NULL default '0',
  receiveid varchar(30) default NULL,
  secret_id varchar(30) default '0',
  sender_time varchar(30) default '0',
  writer varchar(60) default NULL,
  writer_time varchar(30) default NULL,
  doc_type varchar(40) default NULL,
  doc_head varchar(60) default NULL,
  doc_title varchar(60) default NULL,
  mainG_department varchar(60) default NULL,
  main_chars varchar(60) default NULL,
  main_sender varchar(60) default NULL,
  second_sender varchar(60) default NULL,
  typer varchar(20) default NULL,
  changer varchar(40) default NULL,
  doc_content text,
  doc_readers varchar(60) default NULL,
  PRIMARY KEY  (docid)
) TYPE=MyISAM;



#
# Dumping data for table 'document'
#

INSERT INTO document (docid, hashcode, receiveid, secret_id, sender_time, writer, writer_time, doc_type, doc_head, doc_title, mainG_department, main_chars, main_sender, second_sender, typer, changer, doc_content, doc_readers) VALUES("1", "748691", "z20041230", "普通文件", "test121", "test", "", "邛崃市人民政府", "常务会议文件", "开会", "", "", "", "", "", "", "\r\n                      开会", "各位领导:");


#
# Table structure for table 'edge_control'
#

CREATE TABLE edge_control (
  id int(20) unsigned NOT NULL auto_increment,
  edge_id char(30) NOT NULL default '0',
  from_step char(30) NOT NULL default '0',
  to_step char(30) NOT NULL default '0',
  flow_master_id int(30) unsigned default '0',
  graph_id char(30) NOT NULL default '0',
  PRIMARY KEY  (from_step,id,edge_id,to_step)
) TYPE=MyISAM;



#
# Dumping data for table 'edge_control'
#