BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.GoldLog
	(
	ID bigint NOT NULL IDENTITY (1, 1),
	AccountName nvarchar(50) NOT NULL,
	[Where] int NOT NULL,
	Gold int NOT NULL,
	InventoryGold int NOT NULL,
	Str varchar(200) NOT NULL,
	Date varchar(50) NOT NULL,
	IsGameServer int NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.GoldLog ADD CONSTRAINT
	PK_GoldLog PRIMARY KEY CLUSTERED
	(
	ID
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.GoldLog SET (LOCK_ESCALATION = TABLE)
GO
COMMIT