CREATE TABLE [dbo].[WEB_Market] (
[cat_id] [int] NULL,
[item_id] [int] NULL,
[item] [varchar] (32) NULL,
[item_serial] [varchar] (8) NULL,
[item_excellent] [smallint] NOT NULL DEFAULT 0,
[item_ancient] [smallint] NOT NULL DEFAULT 0,
[item_pvp] [smallint] NOT NULL DEFAULT 0,
[item_harmony] [smallint] NOT NULL DEFAULT 0,
[item_skill] [smallint] NOT NULL DEFAULT 0,
[item_luck] [smallint] NOT NULL DEFAULT 0,
[item_life] [int] NOT NULL DEFAULT 0,
[item_level] [int] NOT NULL DEFAULT 0,
[item_price] [varchar] (50) NULL,
[currency] [varchar] (50) NULL,
[seller] [varchar] (50) NULL,
[start_date] [varchar] (50) NULL,
[end_date] [varchar] (50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[WEB_MarketHistory] (
[cat_id] [int] NULL ,
[item] [varchar] (32) NULL,
[item_serial] [varchar] (50) NULL,
[item_price] [varchar] (50) NULL,
[currency] [varchar] (50) NULL,
[seller] [varchar] (50) NULL,
[start_date] [varchar] (50) NULL,
[end_date] [varchar] (50) NULL,
[sold_date] [varchar] (50) NULL,
[status] [smallint] NOT NULL DEFAULT 0,
[purchased_by] [varchar] (50) NULL
) ON [PRIMARY]