readerware.create

CREATE CACHED TABLE READERWARE(ROWKEY BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,TITLE VARCHAR_IGNORECASE(255) NOT NULL,ALT_TITLE VARCHAR_IGNORECASE(255),SUBTITLE VARCHAR_IGNORECASE(255),AUTHOR BIGINT,AUTHOR2 BIGINT,AUTHOR3 BIGINT,AUTHOR4 BIGINT,AUTHOR5 BIGINT,AUTHOR6 BIGINT,ILLUSTRATOR BIGINT,TRANSLATOR BIGINT,EDITOR BIGINT,PUBLISHER BIGINT,PUB_PLACE BIGINT,RELEASE_DATE DATE,COPYRIGHT_DATE DATE,PAGES INTEGER,EDITION BIGINT,CONTENT_LANGUAGE BIGINT,SIGNED BIGINT,DIMENSIONS VARCHAR_IGNORECASE(32),READING_LEVEL BIGINT,LEXILE_LEVEL CHAR(14),COPIES INTEGER NOT NULL,BARCODE VARCHAR_IGNORECASE(128),ISBN CHAR(14),ISSN CHAR(16),LCCN VARCHAR_IGNORECASE(16),DEWEY VARCHAR_IGNORECASE(32),CALL_NUMBER VARCHAR_IGNORECASE(32),USER_NUMBER VARCHAR_IGNORECASE(32),TYPE BIGINT,FORMAT BIGINT,SERIES BIGINT,SERIES_NUMBER INTEGER,MY_RATING BIGINT,ITEM_CONDITION BIGINT,COVER_CONDITION BIGINT,CATEGORY1 BIGINT,CATEGORY2 BIGINT,CATEGORY3 BIGINT,LOCATION BIGINT,KEYWORDS VARCHAR_IGNORECASE(255),READ_COUNT INTEGER NOT NULL,DATE_LAST_READ DATE,PRODUCT_INFO VARCHAR_IGNORECASE(65536),MY_COMMENTS VARCHAR_IGNORECASE(65536),DATE_ENTERED DATE NOT NULL,DATE_LAST_UPDATED DATE NOT NULL,SOURCE BIGINT,PURCHASE_PRICE DECIMAL(12,2) NOT NULL,PURCHASE_DATE DATE,PURCHASE_PLACE BIGINT,LIST_PRICE DECIMAL(12,2) NOT NULL,ITEM_VALUE DECIMAL(12,2) NOT NULL,VALUATION_DATE DATE,CURRENCY_SYMBOL VARCHAR_IGNORECASE(5),FAVORITE BOOLEAN NOT NULL,OUT_OF_PRINT BOOLEAN NOT NULL,MEDIA_URL VARCHAR_IGNORECASE(255),OWNER BIGINT,STATUS BIGINT,EXTERNAL_ID VARCHAR_IGNORECASE(32),INVENTORY INTEGER NOT NULL,IMAGE1_DATA VARBINARY(65536),IMAGE2_DATA VARBINARY(65536),IMAGE1_LARGE_DATA VARBINARY(262144),IMAGE2_LARGE_DATA VARBINARY(262144),IN_LAST_BATCH BOOLEAN NOT NULL,AM_ASIN CHAR(14),SALE_PRICE DECIMAL(12,2),SALE_DATE DATE,NEW_VALUE DECIMAL(12,2),NEW_COUNT INTEGER,USED_VALUE DECIMAL(12,2),USED_COUNT INTEGER,COLLECTIBLE_VALUE DECIMAL(12,2),COLLECTIBLE_COUNT INTEGER,BUYER_WAITING BOOLEAN,WEIGHT VARCHAR_IGNORECASE(32),SALES_RANK INTEGER NOT NULL,USER1 VARCHAR_IGNORECASE(255),USER2 VARCHAR_IGNORECASE(255),USER3 VARCHAR_IGNORECASE(255),USER4 VARCHAR_IGNORECASE(255),USER5 VARCHAR_IGNORECASE(255),USER6 VARCHAR_IGNORECASE(255),USER7 VARCHAR_IGNORECASE(255),USER8 VARCHAR_IGNORECASE(255),USER9 VARCHAR_IGNORECASE(255),USER10 VARCHAR_IGNORECASE(255),FILLER1 VARCHAR_IGNORECASE(255),FILLER2 VARCHAR_IGNORECASE(255),FILLER3 VARCHAR_IGNORECASE(255),FILLER4 VARCHAR_IGNORECASE(255),FILLER5 VARCHAR_IGNORECASE(255),FILLER6 VARCHAR_IGNORECASE(255),FILLER7 VARCHAR_IGNORECASE(255),FILLER8 VARCHAR_IGNORECASE(255),FILLER9 VARCHAR_IGNORECASE(255),FILLER10 VARCHAR_IGNORECASE(255))