mysql_xlob.sql

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

--
-- mysql db schema
--

-- 
--        A way of using this :
-- 
-- $ mysql -u root -p mysql
-- Enter password: xxxxx
-- 
-- Welcome to the MySQL monitor.  Commands end with ; or \g.
-- Your MySQL connection id is 3 to server version: 4.0.13-log
-- 
-- Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
-- 
-- mysql> create database xlob;
-- Query OK, 1 row affected (0.07 sec)
-- 
-- mysql> grant select, insert, update, delete on xlob.* to xlob@localhostname;
-- Query OK, 2 rows affected (0.02 sec)
--
-- mysql> update user set password=password('xlob') where user='xlob';
-- Query OK, 1 row affected (0.07 sec)
-- 
-- mysql> flush privileges;
-- Query OK, 0 rows affected (0.00 sec)
-- 
-- mysql> quit
-- Bye
-- 
-- $ cat sql/xlob/mysql_xlob.sql | mysql -u root -p xlob
-- Enter password: xxxxx
-- $
-- 

--
-- Warning :
--
-- Don't forget to enable TCP listening in your MySQL configuration, else
-- the JDBC driver will not be able to connect to the DB and OpenWFE will
-- thus not be able to use Xdbc.
--

--
-- $Id: mysql_xlob.sql,v 1.3 2005/07/17 20:12:00 jmettraux Exp $
--

create table xldocument
(

    prefix varchar(30) not null,

    engineId varchar(40) not null,
    initialEngineId varchar(40) not null,
    wfdUrl varchar(255) not null,
    wfdName varchar(50) not null,
    wfdRevision varchar(40) not null,
    wfInstanceId varchar(40) not null,
    expressionName varchar(40) not null,
    expressionId varchar(50) not null,

    xldoc text not null,

    primary key (prefix, engineId, initialEngineId, wfdName, wfdRevision, wfInstanceId, expressionId),

    index wfid_index (wfInstanceId),
    index exid_index (expressionId)
);