日期:2014-05-16 浏览次数:21582 次
导入数据库表的脚本如下;
?
# -----------------------------------
# OJB_HL_SEQ
# -----------------------------------
CREATE TABLE OJB_HL_SEQ
(
TABLENAME VARCHAR(175) NOT NULL,
FIELDNAME VARCHAR(70) NOT NULL,
MAX_KEY INTEGER,
GRAB_SIZE INTEGER,
VERSION INTEGER,
PRIMARY KEY (TABLENAME, FIELDNAME)
) ;
# -----------------------------------
# OJB_LOCKENTRY
# -----------------------------------
CREATE TABLE OJB_LOCKENTRY
(
OID_ VARCHAR(250) NOT NULL,
TX_ID VARCHAR(50) NOT NULL,
TIMESTAMP_ DATETIME,
ISOLATIONLEVEL INTEGER,
LOCKTYPE INTEGER,
PRIMARY KEY (OID_, TX_ID)
) ;
# -----------------------------------
# OJB_NRM
# -----------------------------------
CREATE TABLE OJB_NRM
(
NAME VARCHAR(250) NOT NULL,
OID_ MEDIUMBLOB NULL,
PRIMARY KEY (NAME)
) ;
# -----------------------------------
# OJB_DLIST
# -----------------------------------
CREATE TABLE OJB_DLIST
(
ID INTEGER NOT NULL,
SIZE_ INTEGER,
PRIMARY KEY (ID)
) ;
# -----------------------------------
# OJB_DLIST_ENTRIES
# -----------------------------------
CREATE TABLE OJB_DLIST_ENTRIES
(
ID INTEGER NOT NULL,
DLIST_ID INTEGER,
POSITION_ INTEGER,
OID_ MEDIUMBLOB NULL,
PRIMARY KEY (ID)
) ;
# -----------------------------------
# OJB_DSET
# -----------------------------------
CREATE TABLE OJB_DSET
(
ID INTEGER NOT NULL,
SIZE_ INTEGER,
PRIMARY KEY (ID)
) ;
# -----------------------------------
# OJB_DSET_ENTRIES
# -----------------------------------
CREATE TABLE OJB_DSET_ENTRIES
(
ID INTEGER NOT NULL,
DLIST_ID INTEGER,
POSITION_ INTEGER,
OID_ MEDIUMBLOB NULL,
PRIMARY KEY (ID)
) ;
# -----------------------------------
# OJB_DMAP
# -----------------------------------
CREATE TABLE OJB_DMAP
(
ID INTEGER NOT NULL,
SIZE_ INTEGER,
PRIMARY KEY (ID)
) ;
# -----------------------------------
# MEDIA_TYPE
# -----------------------------------
CREATE TABLE MEDIA_TYPE
(
MEDIATYPE_ID INTEGER NOT NULL,
NAME VARCHAR(80) NOT NULL,
CHARACTER_SET VARCHAR(40) NULL,
TITLE VARCHAR(80) NULL,
DESCRIPTION MEDIUMTEXT NULL,
PRIMARY KEY (MEDIATYPE_ID)
) ;
# -----------------------------------
# CLIENT
# -----------------------------------
CREATE TABLE CLIENT
(
CLIENT_ID INTEGER NOT NULL,
EVAL_ORDER INTEGER NOT NULL,
NAME VARCHAR(80) NOT NULL,
USER_AGENT_PATTERN VARCHAR(128) NULL,
MANUFACTURER VARCHAR(80) NULL,
MODEL VARCHAR(80) NULL,
VERSION VARCHAR(40) NULL,
PREFERRED_MIMETYPE_ID INTEGER NOT NULL,
PRIMARY KEY (CLIENT_ID)
) ;
# -----------------------------------
# MIMETYPE
# -----------------------------------
CREATE TABLE MIMETYPE
(
MIMETYPE_ID INTEGER NOT NULL,
NAME VARCHAR(80) NOT NULL,
PRIMARY KEY (MIMETYPE_ID)
) ;
# -----------------------------------
# CAPABILITY
# -----------------------------------
CREATE TABLE CAPABILITY
(
CAPABILITY_ID INTEGER NOT NULL,
CAPABILITY VARCHAR(80) NOT NULL,
PRIMARY KEY (CAPABILITY_ID)
) ;
# -----------------------------------
# CLIENT_TO_CAPABILITY
# -----------------------------------
CREATE TABLE CLIENT_TO_CAPABILITY
(
CLIENT_ID INTEGER NOT NULL,
CAPABILITY_ID INTEGER NOT NULL
) ;
# -----------------------------------
# CLIENT_TO_MIMETYPE
# -----------------------------------
CREATE TABLE CLIENT_TO_MIMETYPE
(
CLIENT_ID INTEGER NOT NULL,
MIMETYPE_ID INTEGER NOT NULL
) ;
# -----------------------------------
# MEDIATYPE_TO_CAPABILITY
# -----------------------------------
CREATE TABLE MEDIATYPE_TO_CAPABILITY
(
MEDIATYPE_ID INTEGER NOT NULL,
CAPABILITY_ID INTEGER NOT NULL
) ;
# -----------------------------------
# MEDIATYPE_TO_MIMETYPE
# -----------------------------------
CREATE TABLE MEDIATYPE_TO_MIMETYPE
(
MEDIATYPE_ID INTEGER NOT NULL,
MIMETYPE_ID INTEGER NOT NULL
) ;
# --------