createtables.sql

数据仓库工具

create table BOOKLINKS
(
    BOOKOID DECIMAL(19,0) NOT NULL ,
    BOOKLINENUMBER DECIMAL(10,0) NOT NULL   ,
    KEYVALUE VARCHAR(254) NOT NULL   ,
    XMLNAME VARCHAR(30) NOT NULL   ,
    BOOKLINKSOID DECIMAL(19,0)  ,
    URLSTRING01 VARCHAR(254)    ,
    URLSTRING02 VARCHAR(254)    ,
    URLSTRING03 VARCHAR(254)    ,
    URLSTRING04 VARCHAR(254)    ,
    URLSTRING05 VARCHAR(254)    ,
    URLSTRING06 VARCHAR(254)    ,
    URLSTRING07 VARCHAR(254)    ,
    URLSTRING08 VARCHAR(254)    ,
    URLSTRING09 VARCHAR(254)    ,
    URLSTRING10 VARCHAR(254)    ,
    oid DECIMAL(19,0) PRIMARY KEY ,
    version INTEGER NOT NULL
);


create table BOOKS
(
    BOOKNAME VARCHAR(100) NOT NULL   ,
    LANGUAGE VARCHAR(12) NOT NULL   ,
    KEYVALUE VARCHAR(254) NOT NULL   ,
    XMLNAME VARCHAR(30) NOT NULL   ,
    CHAPTER01DESC VARCHAR(254)    ,
    CHAPTER02DESC VARCHAR(254)    ,
    CHAPTER03DESC VARCHAR(254)    ,
    CHAPTER04DESC VARCHAR(254)    ,
    CHAPTER05DESC VARCHAR(254)    ,
    CHAPTER06DESC VARCHAR(254)    ,
    CHAPTER07DESC VARCHAR(254)    ,
    CHAPTER08DESC VARCHAR(254)    ,
    CHAPTER09DESC VARCHAR(254)    ,
    CHAPTER10DESC VARCHAR(254)    ,
    oid DECIMAL(19,0) PRIMARY KEY ,
    version INTEGER NOT NULL
);