-- ----------------------------
-- Table structure for td_Market
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[td_Market]') AND type IN ('U'))
DROP TABLE [dbo].[td_Market]
GO
CREATE TABLE [dbo].[td_Market] (
[TransactionNum] bigint IDENTITY(1,1) NOT NULL,
[SellingItemUID] bigint NULL,
[AccountUID] int NULL,
[SellerCharUID] int NULL,
[TradeItemKind] tinyint NULL,
[ItemName] varchar(140) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemNum] int NULL,
[Count] int NULL,
[PrefixCodeNum] int NULL,
[SuffixCodeNum] int NULL,
[EnchantCount] tinyint NULL,
[ShapeItemNum] int NULL,
[ColorCode] int NULL,
[ReqMinLevel] tinyint NULL,
[ReqUnitKind] int NULL,
[RegistrationTime] datetime DEFAULT getdate() NULL,
[TypeOfMoney] tinyint NULL,
[Price] int NULL,
[TradeStatus] tinyint NULL,
[BuyerUID] int DEFAULT 0 NULL,
[BuyingTime] datetime DEFAULT 0 NULL,
[InfluenceType] tinyint DEFAULT 0 NULL
)
GO
ALTER TABLE [dbo].[td_Market] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Auto increment value for td_Market
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[td_Market]', RESEED, 2)
GO