日期:2014-05-16 浏览次数:21147 次
导入数据库表的脚本如下;
?
# ----------------------------------- # 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 ) ; # --------