mysql_xdbc.sql

来自「日常的办公系统 应用工作流框架等增加员工的基本信息、培训信息、奖罚信息、薪资信息」· SQL 代码 · 共 82 行

--
-- 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 xdbc;
-- Query OK, 1 row affected (0.07 sec)
-- 
-- mysql> grant select, insert, update, delete on xdbc.* to xdbc@localhostname;
-- Query OK, 2 rows affected (0.02 sec)
--
-- mysql> update user set password=password('xdbc') where user='xdbc';
-- Query OK, 1 row affected (0.07 sec)
-- 
-- mysql> flush privileges;
-- Query OK, 0 rows affected (0.00 sec)
-- 
-- mysql> quit
-- Bye
-- 
-- $ cat sql/xdbc/mysql_xdbc.sql | mysql -u root -p xdbc
-- 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_xdbc.sql,v 1.3 2005/05/14 11:35:07 jmettraux Exp $
--

create table xdocument
(
    id bigint not null,
    clientId varchar(255),
    isReady bool not null default 0,

    primary key (id)
);

create table xelement
(
    id bigint not null,
    documentId bigint not null,
    parentElementId bigint,
    eTagName varchar(255),
    eText longtext,
    eOrder bigint,
    eIsCdata bool not null default 0,

    primary key (id),
    index docid_index (documentId),
    index parentid_index (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)
);