Ned db table structure forTrade sop and auction shop

[gaby001]

hello who can share table structure and procedures
for trade and auction shoop ned to upgrade db

Tancx

St34lth4ng3l

 

[xxradicaldxx]

for that you can create your own table and design it as you want

 

[St34lth4ng3l]

There you go, do whatever you want to do with it....i myself think it's retarded to save the ItemName but hey....blame it on the koreans

-- ----------------------------
-- 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

 

[xxradicaldxx]

I will add this table in the code of tc & auction. thanks for sharing

 

[PhatLA]

thanks for DB sharing ^^