postgresql_xlob.sql

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

--
-- postgresql db schema
--

--
--        A way of using this :
-- 
-- $ su - postgres
-- postgres$ createuser xlob
-- Shall the new user be allowed to create databases? (y/n) n
-- Shall the new user be allowed to create more new users? (y/n) n
-- CREATE USER
-- postgres$ createdb xlob
-- postgres$ psql xlob
-- xlob=# alter user xlob encrypted password 'xlob';
-- ALTER USER
-- xlob=# \i postgresql_xlob.sql
-- (...)
-- xlob=# grant insert,delete,update,select on xldocument to xlob;
-- GRANT
-- xlob=# \q
--
-- replace 'username' with the name of the user that will run the openwfe 
-- binaries
--

--
-- $Id: postgresql_xlob.sql,v 1.1 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)
);

create index wfid_index on xldocument (wfInstanceId);
create index exid_index on xldocument (expressionId);