postgresql_xdbc.sql

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

--
-- postgresql db schema
--

--
--        A way of using this :
-- 
-- $ su - postgres
-- postgres$ createuser xdbc
-- 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 xdbc
-- postgres$ psql xdbc
-- xdbc=# alter user xdbc encrypted password 'xdbc';
-- ALTER USER
-- xdbc=# \i postgresql.sql
-- psql:/home/jmettraux/poya/releases/openwfe-engine-worklist-and-webclient/sql/postgresql.sql:30: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'xdocument_pkey' for table 'xdocument'
-- CREATE TABLE
-- psql:/home/jmettraux/poya/releases/openwfe-engine-worklist-and-webclient/sql/postgresql.sql:44: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'xelement_pkey' for table 'xelement'
-- CREATE TABLE
-- psql:/home/jmettraux/poya/releases/openwfe-engine-worklist-and-webclient/sql/postgresql.sql:55: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'xattribute_pkey' for table 'xattribute'
-- CREATE TABLE
-- xdbc=# grant insert,delete,update,select on xdocument, xattribute, xelement to xdbc;
-- GRANT
-- xdbc=# \q
--
-- replace 'username' with the name of the user that will run the openwfe 
-- binaries
--

--
-- $Id: postgresql_xdbc.sql,v 1.2 2005/02/01 17:21:47 jmettraux Exp $
--

create table xdocument
(
    id bigint not null primary key,
    clientId varchar(255),
    isReady bool not null default FALSE
);

create table xelement
(
    id bigint not null primary key,
    documentId bigint not null,
    parentElementId bigint,
    eTagName varchar(255),
    eText text,
    eOrder bigint,
    eIsCdata bool not null default FALSE

--    index docid_index (documentId),
--    index parentid_index (parentElementId)
);

create index docid_index on xelement (documentId);
create index parentid_index on xelement (parentElementId);


create table xattribute
(
    documentId bigint not null,
    elementId bigint not null,
    attName varchar(255),
    attValue varchar(255),

    primary key (documentId, elementId, attName)
--    index attname_index (attname)
);

create index attname_index on xattribute (attname);