mysql_xlob.sql

来自「这是一个关于工作流管理的系统」· SQL 代码 · 共 70 行

--
-- 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)
);