CREATE TABLE [dbo].[MARKET_ITEMS](
	[listing_id] [int] IDENTITY(1,1) NOT NULL,
	[seller_account] [varchar](20) NOT NULL,
	[seller_character] [varchar](20) NULL,
	[item_hex] [varchar](64) NOT NULL,
	[item_group] [int] NOT NULL,
	[item_index] [int] NOT NULL,
	[item_name] [varchar](120) NULL,
	[item_meta] [varchar](max) NULL,
	[item_size_x] [tinyint] NOT NULL DEFAULT 1,
	[item_size_y] [tinyint] NOT NULL DEFAULT 1,
	[warehouse_slot] [int] NOT NULL,
	[price] [bigint] NOT NULL,
	[currency_slug] [varchar](20) NOT NULL,
	[status] [varchar](20) NOT NULL DEFAULT 'listed',
	[featured] [tinyint] NOT NULL DEFAULT 0,
	[expires_at] [int] NOT NULL,
	[buyer_account] [varchar](20) NULL,
	[created_at] [int] NOT NULL,
	[updated_at] [int] NOT NULL,
	[sold_at] [int] NULL,
	[listing_description] [varchar](500) NULL,
	[listing_image] [varchar](255) NULL,
	CONSTRAINT [PK_MARKET_ITEMS] PRIMARY KEY CLUSTERED ([listing_id] ASC)
)
