postgresql_history.sql

来自「一个工作流设计及定义的系统,可以直接与数据库结合进行系统工作流程的定义及应用.」· SQL 代码 · 共 59 行

--
-- postgresql db schema
--

--
--        A way of using this :
-- 
-- $ su - postgres
-- postgres$ createuser owfe
-- 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 owfe
-- postgres$ psql owfe
-- owfe=# alter user owfe encrypted password 'owfe';
-- ALTER USER
-- owfe=# \i postgresql.sql
-- ...
-- 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
-- owfe=# grant insert,delete,update,select on owfehistory to owfe;
-- GRANT
-- owfe=# \q
--
-- replace 'owfe' with the name of the user that will run the openwfe 
-- binaries
--

--
-- $Id: postgresql_history.sql,v 1.2 2004/09/04 09:22:14 jmettraux Exp $
--

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------

create table owfehistory
(
    date_ timestamp not null,
    engineid varchar(255) not null,
    wfdname varchar(255) not null,
    wfdrevision varchar(255) not null,
    wfdid bigint not null,
    expression varchar(255) not null,
    eventcode char(7) not null,
    participantname varchar(255),
    message varchar(255) not null,

    primary key (date_, engineid, wfdid, expression)
);

create index wfdname_index on owfehistory (wfdname);
create index wfdid_index on owfehistory (wfdid);
create index eventcode_index on owfehistory (eventcode);


-- postgresql can handle larger keys than mysql :-)