mysql_powfe_dump.sql

一个工作流设计及定义的系统,可以直接与数据库结合进行系统工作流程的定义及应用.

-- MySQL dump 9.10
--
-- Host: localhost    Database: powfe
-- ------------------------------------------------------
-- Server version	4.0.18-log

--
-- Table structure for table `pgrant`
--

CREATE TABLE pgrant (
  name varchar(100) NOT NULL default '',
  codebase varchar(255) NOT NULL default '',
  PRIMARY KEY  (name)
) TYPE=MyISAM;

--
-- Dumping data for table `pgrant`
--

INSERT INTO pgrant VALUES ('store.alpha','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('delegation.to.role-alpha','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('launch.default','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('delegation.to.email-notif-agent','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('store.all.guest','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('store.bravo','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('user-management','file:jars/openwfe-uman-actions.jar');
INSERT INTO pgrant VALUES ('launch.more','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('store.alpha.delegate','file:jars/openwfe-worklist-actions.jar');
INSERT INTO pgrant VALUES ('store.default','file:jars/openwfe-worklist-actions.jar');

--
-- Table structure for table `pgranted`
--

CREATE TABLE pgranted (
  username varchar(100) NOT NULL default '',
  grantname varchar(100) NOT NULL default '',
  PRIMARY KEY  (username,grantname)
) TYPE=MyISAM;

--
-- Dumping data for table `pgranted`
--

INSERT INTO pgranted VALUES ('admin','launch.more');
INSERT INTO pgranted VALUES ('admin','store.alpha');
INSERT INTO pgranted VALUES ('admin','store.bravo');
INSERT INTO pgranted VALUES ('admin','store.default');
INSERT INTO pgranted VALUES ('admin','user-management');
INSERT INTO pgranted VALUES ('alice','launch.default');
INSERT INTO pgranted VALUES ('alice','store.alpha');
INSERT INTO pgranted VALUES ('bob','delegation.to.email-notif-agent');
INSERT INTO pgranted VALUES ('bob','delegation.to.role-alpha');
INSERT INTO pgranted VALUES ('bob','launch.more');
INSERT INTO pgranted VALUES ('bob','store.alpha.delegate');
INSERT INTO pgranted VALUES ('bob','store.bravo');
INSERT INTO pgranted VALUES ('charly','launch.default');
INSERT INTO pgranted VALUES ('charly','store.default');
INSERT INTO pgranted VALUES ('guest','store.all.guest');

--
-- Table structure for table `pparameter`
--

CREATE TABLE pparameter (
  pid int(11) NOT NULL default '0',
  pgroup varchar(100) NOT NULL default '',
  pkey varchar(100) NOT NULL default '',
  pval varchar(255) NOT NULL default '',
  PRIMARY KEY  (pid,pgroup,pkey)
) TYPE=MyISAM;

--
-- Dumping data for table `pparameter`
--

INSERT INTO pparameter VALUES (1,'principal','password','[phone]+24+75-53-11-114-52-15+12-89-90+86+60');
INSERT INTO pparameter VALUES (1,'principal','name','alice');
INSERT INTO pparameter VALUES (1,'principal','class','openwfe.org.auth.BasicPrincipal');
INSERT INTO pparameter VALUES (2,'principal','password','-90-44-17+77-45-117+27-80+22-46+80-63+106+104+4+112');
INSERT INTO pparameter VALUES (2,'principal','name','charly');
INSERT INTO pparameter VALUES (2,'principal','class','openwfe.org.auth.BasicPrincipal');
INSERT INTO pparameter VALUES (3,'principal','password','-97-99+81-68+112-17+33-54+92+20-13+7-104+10+41-40');
INSERT INTO pparameter VALUES (3,'principal','name','bob');
INSERT INTO pparameter VALUES (3,'principal','class','openwfe.org.auth.BasicPrincipal');
INSERT INTO pparameter VALUES (4,'principal','password','+33+35+47+41+122+87-91-89+67-119+74+14+74-128+31-61');
INSERT INTO pparameter VALUES (4,'principal','name','admin');
INSERT INTO pparameter VALUES (4,'principal','class','openwfe.org.auth.BasicPrincipal');
INSERT INTO pparameter VALUES (5,'principal','password','+8+78+3+67-96+72+111-16+85+48-33+108+112+92-117-76');
INSERT INTO pparameter VALUES (5,'principal','name','guest');
INSERT INTO pparameter VALUES (5,'principal','class','openwfe.org.auth.BasicPrincipal');
INSERT INTO pparameter VALUES (6,'permission','grantname','store.alpha');
INSERT INTO pparameter VALUES (6,'permission','name','Store.alpha');
INSERT INTO pparameter VALUES (6,'permission','rights','read, write, delegate');
INSERT INTO pparameter VALUES (6,'permission','class','openwfe.org.worklist.auth.StorePermission');
INSERT INTO pparameter VALUES (7,'permission','grantname','delegation.to.role-alpha');
INSERT INTO pparameter VALUES (7,'permission','name','role-alpha');
INSERT INTO pparameter VALUES (7,'permission','class','openwfe.org.worklist.auth.DelegationPermission');
INSERT INTO pparameter VALUES (8,'permission','grantname','launch.default');
INSERT INTO pparameter VALUES (8,'permission','name','mainEngine::http://localhost:7079/launch-default.xml');
INSERT INTO pparameter VALUES (8,'permission','class','openwfe.org.worklist.auth.LaunchPermission');
INSERT INTO pparameter VALUES (9,'permission','grantname','delegation.to.email-notif-agent');
INSERT INTO pparameter VALUES (9,'permission','name','email-notif-agent');
INSERT INTO pparameter VALUES (9,'permission','class','openwfe.org.worklist.auth.DelegationPermission');
INSERT INTO pparameter VALUES (10,'permission','grantname','store.all.guest');
INSERT INTO pparameter VALUES (10,'permission','name','Store.default');
INSERT INTO pparameter VALUES (10,'permission','rights','read');
INSERT INTO pparameter VALUES (10,'permission','class','openwfe.org.worklist.auth.StorePermission');
INSERT INTO pparameter VALUES (11,'permission','grantname','store.all.guest');
INSERT INTO pparameter VALUES (11,'permission','name','Store.alpha');
INSERT INTO pparameter VALUES (11,'permission','rights','read');
INSERT INTO pparameter VALUES (11,'permission','class','openwfe.org.worklist.auth.StorePermission');
INSERT INTO pparameter VALUES (12,'permission','grantname','store.all.guest');
INSERT INTO pparameter VALUES (12,'permission','name','Store.bravo');
INSERT INTO pparameter VALUES (12,'permission','rights','read');
INSERT INTO pparameter VALUES (12,'permission','class','openwfe.org.worklist.auth.StorePermission');
INSERT INTO pparameter VALUES (13,'permission','grantname','store.bravo');
INSERT INTO pparameter VALUES (13,'permission','name','Store.bravo');
INSERT INTO pparameter VALUES (13,'permission','rights','read, write, delegate');
INSERT INTO pparameter VALUES (13,'permission','class','openwfe.org.worklist.auth.StorePermission');
INSERT INTO pparameter VALUES (14,'permission','grantname','user-management');
INSERT INTO pparameter VALUES (14,'permission','name','passwd');
INSERT INTO pparameter VALUES (14,'permission','rights','manage');
INSERT INTO pparameter VALUES (14,'permission','class','openwfe.org.auth.UmanPermission');
INSERT INTO pparameter VALUES (15,'permission','grantname','launch.more');
INSERT INTO pparameter VALUES (15,'permission','name','mainEngine::http://localhost:7079/flow-index.jsp');
INSERT INTO pparameter VALUES (15,'permission','class','openwfe.org.worklist.auth.LaunchPermission');
INSERT INTO pparameter VALUES (16,'permission','grantname','store.alpha.delegate');
INSERT INTO pparameter VALUES (16,'permission','name','Store.alpha');
INSERT INTO pparameter VALUES (16,'permission','rights','write, delegate');
INSERT INTO pparameter VALUES (16,'permission','class','openwfe.org.worklist.auth.StorePermission');
INSERT INTO pparameter VALUES (17,'permission','grantname','store.default');
INSERT INTO pparameter VALUES (17,'permission','name','Store.default');
INSERT INTO pparameter VALUES (17,'permission','rights','read, write, delegate');
INSERT INTO pparameter VALUES (17,'permission','class','openwfe.org.worklist.auth.StorePermission');