Ned db table structure forTrade sop and auction shop

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

Tancx

Quote:

---

St34lth4ng3l

---

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

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

Code:

---

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

---

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

thanks for DB sharing ^^