CREATE TABLE [dbo].[WEBSHOP_ORDERS](
	[order_id] [int] IDENTITY(1,1) NOT NULL,
	[shop_item_id] [int] NOT NULL,
	[account] [varchar](20) NOT NULL,
	[character_name] [varchar](20) NULL,
	[item_hex] [varchar](64) NOT NULL,
	[item_name] [varchar](120) NOT NULL,
	[currency_slug] [varchar](20) NOT NULL,
	[price] [decimal](18,2) NOT NULL,
	[status] [varchar](20) NOT NULL DEFAULT 'completed',
	[warehouse_slot] [int] NULL,
	[client_ip] [varchar](45) NULL,
	[created_at] [int] NOT NULL,
	CONSTRAINT [PK_WEBSHOP_ORDERS] PRIMARY KEY CLUSTERED ([order_id] ASC)
)
