CREATE TABLE IF NOT EXISTS  "tk_filter_cloud" (
"id"  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"wordText"  TEXT,
"wordCount"  INTEGER
);

CREATE TABLE IF NOT EXISTS  "tk_filter_native" (
"id"  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"wordText"  TEXT,
"originId"  INTEGER DEFAULT 0,
"validFlag"  BOOLEAN DEFAULT 1
);


CREATE TABLE IF NOT EXISTS "tk_mainorder_search" (
"id"  INTEGER NOT NULL,
"expressId"  TEXT,
"expressName"  TEXT,
"address"  TEXT,
PRIMARY KEY ("id" ASC)
);
CREATE TABLE IF NOT EXISTS  "tk_filter_tpcloud" (
"id"  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"wordText"  TEXT,
"wordCount"  INTEGER
);

CREATE TABLE IF NOT EXISTS  "tk_repertory_auction_list" (
"id"  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"auctionId"  INTEGER,
"myPrice"  REAL DEFAULT 0,
"zkPrice"  REAL DEFAULT 0,
"tkCommFee"  REAL DEFAULT 0,
"tkRate"  REAL DEFAULT 0,
"auctionUrl"  TEXT,
"checkStatus"  INTEGER DEFAULT 0,
"checkResult"  INTEGER DEFAULT 0,
"fromAuctionId"  INTEGER DEFAULT 0,
"title"  TEXT,
"publishTime"  DATETIME,
"checkMemo"  TEXT,
"dayLeft"  INTEGER DEFAULT 0,
"goods_num_id"  INTEGER DEFAULT 0,
"stuff_status"  INTEGER,
"autoEnd"  boolean,
"prepayCat"  boolean
);