Contributing To AgileFlow(MySql DBinit Sql)
来源:互联网 发布:大数据预处理 编辑:程序博客网 时间:2024/05/16 09:11
今天,AgileFlow项目的朋友dgpck@msn.com发来了AgileFlow的Mysql
数据库的建表脚本,他建表测试成功,我代表AgileFlow项目组向
dgpck@msn.com表示感谢,并代表个人向他对开源精神的支持表示敬意.
*******agile.sql:****************
use agile;
DROP TABLE agileActivity;
CREATE TABLE agileActivity (
activityInsId varchar(100) default '' NOT NULL ,
processInsId varchar(100) default '' NOT NULL ,
status varchar(100) default NULL,
acceptedUserId 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);
********************************************************************
*************res.sql************************************************
use agile;
/*删除资源对象表*/
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;
commit;
create table res_id (
tableName varchar(100) not null,
value int default 0 not null
);
/*初始化ID表*/
insert into res_id values('res_object',4);
insert into res_id values('res_object_priv',3);
create table res_object (
id int not null,
type int null,
tier 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,0);
create table res_ou (
id int not null,
name varchar(100) not null,
description varchar(255) null,
is_deleted int default 0 null
);
/*初始化最高组织*/
insert into res_ou values(1,'AgileFlow','',0);
create table res_user (
id int not null,
name varchar(100) not null,
loginName varchar(100) not null,
phone varchar(20) null,
email varchar(100) null,
password varchar(128) not null
);
insert into res_user values(2,'系统管理员','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','系统管理角色');
create table res_object_relation (
child_id int not null,
parent_id int not null,
is_extend int default 0 not null
);
/*将系统管理员加入组织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,'系统管理','系统管理权限');
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);
************************************************************************************
- Contributing To AgileFlow(MySql DBinit Sql)
- Contributing To AgileFlow(MySql DBinit Sql)
- 简评《Contributing to Eclipse》
- Contributing to Eclipse 中文版
- 《Contributing to Eclipse中文版》书评摘录
- Contributing Code to uClinux-dist repository
- GitHub翻译之 ‘Contributing to Open Source’
- Contributing to Eclipse: Principles, Patterns, and Plug-Ins
- How To Set Up A Load-Balanced MySQL Cluster - Part 8
- How To Set Up A Load-Balanced MySQL Cluster - Part 7
- How To Set Up A Load-Balanced MySQL Cluster - Part 6
- How To Set Up A Load-Balanced MySQL Cluster - Part 5
- How To Set Up A Load-Balanced MySQL Cluster - Part 4
- How To Set Up A Load-Balanced MySQL Cluster - Part 3
- How To Set Up A Load-Balanced MySQL Cluster - Part 2
- How To Set Up A Load-Balanced MySQL Cluster --Part 1
- SQL Server connect to MySQL
- SQL Developer Connect to MySQL
- SQL Server存储过程编写和优化措施
- C#.NET 中的类型转换
- 看完了ejb3.0 early draft Review 2
- AgileFlow新的下载地址(终于在sourceforge发布了)
- Open Work Flow Engine 1.5 Released
- Contributing To AgileFlow(MySql DBinit Sql)
- 在.NET中产生随机密码字符串
- BPM的边界界定
- 根据调试信息学习jbpm(二):sessionFactory
- 根据调试信息学习jbpm(一):jbpmConfiguration
- JbpmServiceFactory与JbpmServices
- Fujitsu announces Interstage Business Process Manager 7铪铪
- C#中字符串的加密
- 企业解决方案平台(ESP)概念