CREATE PROCEDURE [dbo].[Local_CreateAuctionTable]
	@createtime		datetime
as
set nocount on

declare @year varchar(50)
declare @month varchar(50)

set @year	= convert(varchar, datepart(yy,@createtime))
set @month	= convert(varchar, datepart(mm,@createtime))

if OBJECT_ID( 'Auction_Log_'+ @year+'_'+@month )  IS  NULL
begin 
	declare @br varchar(2500)
	set @br='CREATE TABLE Auction_Log_'+ @year+'_'+@month+
	'(
	[log_id]				[bigint]	IDENTITY(1,1)	NOT NULL,
	[date]					[datetime]					NOT NULL CONSTRAINT [DF_Auction_Log_'+ @year+'_'+ @month+'_entry_date]  DEFAULT (getdate()),
	[log_type]				[int]						NOT NULL,
	[world_id]				[int]					NOT NULL,
	[auth_id]				[uniqueidentifier],
	[character_id]			[uniqueidentifier],
	[character_name]		[nvarchar]			(16)	NOT NULL,
	[item_guid]				[uniqueidentifier]			NOT NULL,
	[item_id]				[int]						NOT NULL,
	[item_header]			[int]						NOT NULL,
	[enchant_level]			[tinyint]					NOT NULL,
	[item_active]			[int]						NOT NULL,
	[socket_count]			[tinyint]					NOT NULL,
	[remain_recon]			[tinyint]					NOT NULL,
	[durability]			[int]						NOT NULL,
	[item_option1]			[int]						NOT NULL,
	[item_option2]			[int]						NOT NULL,
	[item_option3]			[int]						NOT NULL,
	[item_option_value1]    [int]						NOT NULL,
	[item_option_value2]    [int]						NOT NULL,
	[item_option_value3]    [int]						NOT NULL,
	[item_socket_option1]	[int]						NOT NULL,
	[item_socket_option2]	[int]						NOT NULL,
	[item_socket_option3]	[int]						NOT NULL,
	[item_socket_value1]    [int]						NOT NULL,
	[item_socket_value2]    [int]						NOT NULL,
	[item_socket_value3]    [int]						NOT NULL,
	[item_socket_color1]	[int]						NOT NULL,
	[item_socket_color2]	[int]						NOT NULL,
	[item_socket_color3]	[int]						NOT NULL,
	[item_count]			[int]						NOT NULL,
	[start_price]			[int]						NOT NULL,
	[before_price]			[int]						NOT NULL,
	[buy_price]				[int]						NOT NULL,
	[guarantee_price]		[int]						NOT NULL,
	[commission]			[int]						NOT NULL,
	[auction_period]		[int]						NOT NULL,
	[before_money]			[int]						NOT NULL,
	[after_money]			[int]						NOT NULL,
	[change_money]			[int]						NOT NULL,
	[target_name]			[nvarchar]			(16),
	[result]	            [int]						NOT NULL,

	)'
	exec(@br)
	-----

	set @br='ALTER TABLE [dbo].[Auction_Log_'+ @year+'_'+ @month+'] WITH NOCHECK ADD 
	CONSTRAINT [PK_log_id_Auction_Log_'+ @year+'_'+ @month+'] PRIMARY KEY  CLUSTERED 
	(
		[log_id] ASC
	)  ON [PRIMARY]' 
	exec(@br)
	-----
	set @br='CREATE NONCLUSTERED INDEX [IX_world_id_Auction_Log_'+ @year+'_'+ @month+'] ON [dbo].[Auction_Log_'+ @year+'_'+ @month+'] 
	(
		[world_id] ASC
	)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]'

	set @br='CREATE NONCLUSTERED INDEX [IX_character_name_Auction_Log_'+ @year+'_'+ @month+'] ON [dbo].[Auction_Log_'+ @year+'_'+ @month+'] 
	(
		[character_name] ASC
	)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]'
	exec(@br)	
	
	set @br='CREATE NONCLUSTERED INDEX [IX_date_Auction_Log_'+ @year+'_'+ @month+'] ON [dbo].[Auction_Log_'+ @year+'_'+ @month+'] 
	(
		[date] ASC
	)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]'
	exec(@br)	
	
end