techinfo.books_sort.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table BOOKS_SORT;
CREATE TABLE "TECHINFO"."BOOKS_SORT" ("SORT_ID" NUMBER(10) NOT 
    NULL, "SORT_TITLE" VARCHAR2(50 byte) NOT NULL, 
    "SORT_DESCRIPTION" VARCHAR2(2000 byte) NOT NULL, 
    "CREATE_DATE" DATE NOT NULL, "SORT_ORDER" NUMBER(10), 
    "DELETED" VARCHAR2(1 byte), "RENT_DAYS" NUMBER(10), 
    "SORT_TYPE" VARCHAR2(1 byte), "SUB_FOLDER" VARCHAR2(30 byte),
    CONSTRAINT "PK_BS_ID" PRIMARY KEY("SORT_ID"), 
    CONSTRAINT "UN_BS_TITLE" UNIQUE("SORT_TITLE"))  
    TABLESPACE "TECHINFO" PCTFREE 10 PCTUSED 0 INITRANS 1 
    MAXTRANS 255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
;