deleted tblSpecialItemGrowthLog1, how to recreate?

Newbie Spellweaver
Joined
May 9, 2004
Messages
20
Reaction score
0
as the topic says I dropped the tblSpecialItemGrowthLog1 and now I dont know the correct query to recreate the table, if anyone knows it, please post it :)
Thanks.
 
that was stupid of you:

CREATE TABLE [dbo].[tblSpecialItemGrowthLog1] (
[Time] [datetime] NOT NULL ,
[LogKind] [int] NOT NULL ,
[ResultLog] [int] NOT NULL ,
[GameID] [varchar] (14) NOT NULL ,
[ItemKind] [int] NOT NULL ,
[ItemIndex] [int] NOT NULL ,
[ItemDurability] [int] NOT NULL ,
[ItemAttackGrade] [int] NOT NULL ,
[ItemStrengthGrade] [int] NOT NULL ,
[ItemSpiritGrade] [int] NOT NULL ,
[ItemDexterityGrade] [int] NOT NULL ,
[ItemPowerGrade] [int] NOT NULL ,
[UserExperience] [int] NOT NULL
) ON [PRIMARY]
GO
 
Thanks.
lol i know it was stupid, i was executing a different query, and accidentally put the drop query in there, so when it executed, boom gone :P
 
Back