日期:2014-05-16  浏览次数:21147 次

利用maven部署apache的jetspeed门户二

导入数据库表的脚本如下;

?

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

# --------