mysql_history.sql

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

--
-- mysql db schema for SqlHistory
--

-- 
--        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 owfe;
-- Query OK, 1 row affected (0.07 sec)
-- 
-- mysql> grant select, insert, update, delete on owfe.* to owfe@localhostname;
-- Query OK, 2 rows affected (0.02 sec)
-- 
-- mysql> flush privileges;
-- Query OK, 0 rows affected (0.00 sec)
-- 
-- mysql> quit
-- Bye
-- 
-- $ cat sql/mysql.sql | mysql -u root -p owfe
-- Enter password: xxxxx
-- $
-- 

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

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

create table owfehistory
(
    id bigint not null auto_increment,
    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 (id),
    index wfdname_index (wfdname),
    index wfdid_index (wfdid),
    index eventcode_index (eventcode)
);