itemtable.sql

Soul的源代码,类似于劲舞团之类的游戏

_SttOption69 smallint, -- 胶泡 可记 2

_ItemDate70 int, -- Item 积己 锅龋
_ItemSN70 int, -- Item 捞 积己 揪府倔
_ItemNo70 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount70 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel70 tinyint, -- Item狼 泅犁 饭骇
_iSpOption70 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption70 smallint, -- 胶泡 可记 2
_ItemDate71 int, -- Item 积己 锅龋
_ItemSN71 int, -- Item 捞 积己 揪府倔
_ItemNo71 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount71 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel71 tinyint, -- Item狼 泅犁 饭骇
_iSpOption71 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption71 smallint, -- 胶泡 可记 2
_ItemDate72 int, -- Item 积己 锅龋
_ItemSN72 int, -- Item 捞 积己 揪府倔
_ItemNo72 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount72 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel72 tinyint, -- Item狼 泅犁 饭骇
_iSpOption72 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption72 smallint, -- 胶泡 可记 2
_ItemDate73 int, -- Item 积己 锅龋
_ItemSN73 int, -- Item 捞 积己 揪府倔
_ItemNo73 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount73 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel73 tinyint, -- Item狼 泅犁 饭骇
_iSpOption73 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption73 smallint, -- 胶泡 可记 2
_ItemDate74 int, -- Item 积己 锅龋
_ItemSN74 int, -- Item 捞 积己 揪府倔
_ItemNo74 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount74 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel74 tinyint, -- Item狼 泅犁 饭骇
_iSpOption74 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption74 smallint, -- 胶泡 可记 2
_ItemDate75 int, -- Item 积己 锅龋
_ItemSN75 int, -- Item 捞 积己 揪府倔
_ItemNo75 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount75 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel75 tinyint, -- Item狼 泅犁 饭骇
_iSpOption75 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption75 smallint, -- 胶泡 可记 2
_ItemDate76 int, -- Item 积己 锅龋
_ItemSN76 int, -- Item 捞 积己 揪府倔
_ItemNo76 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount76 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel76 tinyint, -- Item狼 泅犁 饭骇
_iSpOption76 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption76 smallint, -- 胶泡 可记 2
_ItemDate77 int, -- Item 积己 锅龋
_ItemSN77 int, -- Item 捞 积己 揪府倔
_ItemNo77 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount77 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel77 tinyint, -- Item狼 泅犁 饭骇
_iSpOption77 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption77 smallint, -- 胶泡 可记 2
)

create index ItemIX on dbo.InvenItem(_charIndex)
/*trigger 累己*/
create trigger  Inventrigger_delete on [dbo].[InvenItem] for Delete 
as
SET NOCOUNT ON
insert  BKInvenItem
select _charIndex,
_ItemDate0,_ItemSN0,_ItemNo0,_ItemCount0,_ItemLevel0,_iSpOption0,_SttOption0,
_ItemDate1,_ItemSN1,_ItemNo1,_ItemCount1,_ItemLevel1,_iSpOption1,_SttOption1,
_ItemDate2,_ItemSN2,_ItemNo2,_ItemCount2,_ItemLevel2,_iSpOption2,_SttOption2,
_ItemDate3,_ItemSN3,_ItemNo3,_ItemCount3,_ItemLevel3,_iSpOption3,_SttOption3,
_ItemDate4,_ItemSN4,_ItemNo4,_ItemCount4,_ItemLevel4,_iSpOption4,_SttOption4,
_ItemDate5,_ItemSN5,_ItemNo5,_ItemCount5,_ItemLevel5,_iSpOption5,_SttOption5,
_ItemDate6,_ItemSN6,_ItemNo6,_ItemCount6,_ItemLevel6,_iSpOption6,_SttOption6,
_ItemDate7,_ItemSN7,_ItemNo7,_ItemCount7,_ItemLevel7,_iSpOption7,_SttOption7,
_ItemDate8,_ItemSN8,_ItemNo8,_ItemCount8,_ItemLevel8,_iSpOption8,_SttOption8,
_ItemDate9,_ItemSN9,_ItemNo9,_ItemCount9,_ItemLevel9,_iSpOption9,_SttOption9,
_ItemDate10,_ItemSN10,_ItemNo10,_ItemCount10,_ItemLevel10,_iSpOption10,_SttOption10,
_ItemDate11,_ItemSN11,_ItemNo11,_ItemCount11,_ItemLevel11,_iSpOption11,_SttOption11,
_ItemDate12,_ItemSN12,_ItemNo12,_ItemCount12,_ItemLevel12,_iSpOption12,_SttOption12,
_ItemDate13,_ItemSN13,_ItemNo13,_ItemCount13,_ItemLevel13,_iSpOption13,_SttOption13,
_ItemDate14,_ItemSN14,_ItemNo14,_ItemCount14,_ItemLevel14,_iSpOption14,_SttOption14,
_ItemDate15,_ItemSN15,_ItemNo15,_ItemCount15,_ItemLevel15,_iSpOption15,_SttOption15,
_ItemDate16,_ItemSN16,_ItemNo16,_ItemCount16,_ItemLevel16,_iSpOption16,_SttOption16,
_ItemDate17,_ItemSN17,_ItemNo17,_ItemCount17,_ItemLevel17,_iSpOption17,_SttOption17,
_ItemDate18,_ItemSN18,_ItemNo18,_ItemCount18,_ItemLevel18,_iSpOption18,_SttOption18,
_ItemDate19,_ItemSN19,_ItemNo19,_ItemCount19,_ItemLevel19,_iSpOption19,_SttOption19,
_ItemDate20,_ItemSN20,_ItemNo20,_ItemCount20,_ItemLevel20,_iSpOption20,_SttOption20,
_ItemDate21,_ItemSN21,_ItemNo21,_ItemCount21,_ItemLevel21,_iSpOption21,_SttOption21,
_ItemDate22,_ItemSN22,_ItemNo22,_ItemCount22,_ItemLevel22,_iSpOption22,_SttOption22,
_ItemDate23,_ItemSN23,_ItemNo23,_ItemCount23,_ItemLevel23,_iSpOption23,_SttOption23,
_ItemDate24,_ItemSN24,_ItemNo24,_ItemCount24,_ItemLevel24,_iSpOption24,_SttOption24,
_ItemDate25,_ItemSN25,_ItemNo25,_ItemCount25,_ItemLevel25,_iSpOption25,_SttOption25,
_ItemDate26,_ItemSN26,_ItemNo26,_ItemCount26,_ItemLevel26,_iSpOption26,_SttOption26,
_ItemDate27,_ItemSN27,_ItemNo27,_ItemCount27,_ItemLevel27,_iSpOption27,_SttOption27,
_ItemDate28,_ItemSN28,_ItemNo28,_ItemCount28,_ItemLevel28,_iSpOption28,_SttOption28,
_ItemDate29,_ItemSN29,_ItemNo29,_ItemCount29,_ItemLevel29,_iSpOption29,_SttOption29,
_ItemDate30,_ItemSN30,_ItemNo30,_ItemCount30,_ItemLevel30,_iSpOption30,_SttOption30,
_ItemDate31,_ItemSN31,_ItemNo31,_ItemCount31,_ItemLevel31,_iSpOption31,_SttOption31,
_ItemDate32,_ItemSN32,_ItemNo32,_ItemCount32,_ItemLevel32,_iSpOption32,_SttOption32,
_ItemDate33,_ItemSN33,_ItemNo33,_ItemCount33,_ItemLevel33,_iSpOption33,_SttOption33,
_ItemDate34,_ItemSN34,_ItemNo34,_ItemCount34,_ItemLevel34,_iSpOption34,_SttOption34,
_ItemDate35,_ItemSN35,_ItemNo35,_ItemCount35,_ItemLevel35,_iSpOption35,_SttOption35,
_ItemDate36,_ItemSN36,_ItemNo36,_ItemCount36,_ItemLevel36,_iSpOption36,_SttOption36,
_ItemDate37,_ItemSN37,_ItemNo37,_ItemCount37,_ItemLevel37,_iSpOption37,_SttOption37,
_ItemDate38,_ItemSN38,_ItemNo38,_ItemCount38,_ItemLevel38,_iSpOption38,_SttOption38,
_ItemDate39,_ItemSN39,_ItemNo39,_ItemCount39,_ItemLevel39,_iSpOption39,_SttOption39,
_ItemDate40,_ItemSN40,_ItemNo40,_ItemCount40,_ItemLevel40,_iSpOption40,_SttOption40,
_ItemDate41,_ItemSN41,_ItemNo41,_ItemCount41,_ItemLevel41,_iSpOption41,_SttOption41,
_ItemDate42,_ItemSN42,_ItemNo42,_ItemCount42,_ItemLevel42,_iSpOption42,_SttOption42,
_ItemDate43,_ItemSN43,_ItemNo43,_ItemCount43,_ItemLevel43,_iSpOption43,_SttOption43,
_ItemDate44,_ItemSN44,_ItemNo44,_ItemCount44,_ItemLevel44,_iSpOption44,_SttOption44,
_ItemDate45,_ItemSN45,_ItemNo45,_ItemCount45,_ItemLevel45,_iSpOption45,_SttOption45,
_ItemDate46,_ItemSN46,_ItemNo46,_ItemCount46,_ItemLevel46,_iSpOption46,_SttOption46,
_ItemDate47,_ItemSN47,_ItemNo47,_ItemCount47,_ItemLevel47,_iSpOption47,_SttOption47,
_ItemDate48,_ItemSN48,_ItemNo48,_ItemCount48,_ItemLevel48,_iSpOption48,_SttOption48,
_ItemDate49,_ItemSN49,_ItemNo49,_ItemCount49,_ItemLevel49,_iSpOption49,_SttOption49,
_ItemDate50,_ItemSN50,_ItemNo50,_ItemCount50,_ItemLevel50,_iSpOption50,_SttOption50,
_ItemDate51,_ItemSN51,_ItemNo51,_ItemCount51,_ItemLevel51,_iSpOption51,_SttOption51,
_ItemDate52,_ItemSN52,_ItemNo52,_ItemCount52,_ItemLevel52,_iSpOption52,_SttOption52,
_ItemDate53,_ItemSN53,_ItemNo53,_ItemCount53,_ItemLevel53,_iSpOption53,_SttOption53,
_ItemDate54,_ItemSN54,_ItemNo54,_ItemCount54,_ItemLevel54,_iSpOption54,_SttOption54,
_ItemDate55,_ItemSN55,_ItemNo55,_ItemCount55,_ItemLevel55,_iSpOption55,_SttOption55,
_ItemDate56,_ItemSN56,_ItemNo56,_ItemCount56,_ItemLevel56,_iSpOption56,_SttOption56,
_ItemDate57,_ItemSN57,_ItemNo57,_ItemCount57,_ItemLevel57,_iSpOption57,_SttOption57,
_ItemDate58,_ItemSN58,_ItemNo58,_ItemCount58,_ItemLevel58,_iSpOption58,_SttOption58,
_ItemDate59,_ItemSN59,_ItemNo59,_ItemCount59,_ItemLevel59,_iSpOption59,_SttOption59,
_ItemDate60,_ItemSN60,_ItemNo60,_ItemCount60,_ItemLevel60,_iSpOption60,_SttOption60,
_ItemDate61,_ItemSN61,_ItemNo61,_ItemCount61,_ItemLevel61,_iSpOption61,_SttOption61,
_ItemDate62,_ItemSN62,_ItemNo62,_ItemCount62,_ItemLevel62,_iSpOption62,_SttOption62,
_ItemDate63,_ItemSN63,_ItemNo63,_ItemCount63,_ItemLevel63,_iSpOption63,_SttOption63,
_ItemDate64,_ItemSN64,_ItemNo64,_ItemCount64,_ItemLevel64,_iSpOption64,_SttOption64,
_ItemDate65,_ItemSN65,_ItemNo65,_ItemCount65,_ItemLevel65,_iSpOption65,_SttOption65,
_ItemDate66,_ItemSN66,_ItemNo66,_ItemCount66,_ItemLevel66,_iSpOption66,_SttOption66,
_ItemDate67,_ItemSN67,_ItemNo67,_ItemCount67,_ItemLevel67,_iSpOption67,_SttOption67,
_ItemDate68,_ItemSN68,_ItemNo68,_ItemCount68,_ItemLevel68,_iSpOption68,_SttOption68,
_ItemDate69,_ItemSN69,_ItemNo69,_ItemCount69,_ItemLevel69,_iSpOption69,_SttOption69,
_ItemDate70,_ItemSN70,_ItemNo70,_ItemCount70,_ItemLevel70,_iSpOption70,_SttOption70,
_ItemDate71,_ItemSN71,_ItemNo71,_ItemCount71,_ItemLevel71,_iSpOption71,_SttOption71,
_ItemDate72,_ItemSN72,_ItemNo72,_ItemCount72,_ItemLevel72,_iSpOption72,_SttOption72,
_ItemDate73,_ItemSN73,_ItemNo73,_ItemCount73,_ItemLevel73,_iSpOption73,_SttOption73,
_ItemDate74,_ItemSN74,_ItemNo74,_ItemCount74,_ItemLevel74,_iSpOption74,_SttOption74,
_ItemDate75,_ItemSN75,_ItemNo75,_ItemCount75,_ItemLevel75,_iSpOption75,_SttOption75,
_ItemDate76,_ItemSN76,_ItemNo76,_ItemCount76,_ItemLevel76,_iSpOption76,_SttOption76,
_ItemDate77,_ItemSN77,_ItemNo77,_ItemCount77,_ItemLevel77,_iSpOption77,_SttOption77
from deleted
go
--drop trigger  Inventrigger_delete

--drop table dbo.StoreItem
create table StoreItem
(
_iAccountID int, -- 拌沥狼 ID 蔼. 芒绊绰 拌沥俊 1俺促.

_ItemDate0 int, -- Item 积己 锅龋
_ItemSN0 int, -- Item 捞 积己 揪府倔
_ItemNo0 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount0 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel0 tinyint, -- Item狼 泅犁 饭骇
_iSpOption0 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption0 smallint, -- 胶泡 可记 2
_ItemDate1 int, -- Item 积己 锅龋
_ItemSN1 int, -- Item 捞 积己 揪府倔
_ItemNo1 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount1 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel1 tinyint, -- Item狼 泅犁 饭骇
_iSpOption1 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption1 smallint, -- 胶泡 可记 2
_ItemDate2 int, -- Item 积己 锅龋
_ItemSN2 int, -- Item 捞 积己 揪府倔
_ItemNo2 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount2 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel2 tinyint, -- Item狼 泅犁 饭骇
_iSpOption2 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption2 smallint, -- 胶泡 可记 2
_ItemDate3 int, -- Item 积己 锅龋
_ItemSN3 int, -- Item 捞 积己 揪府倔
_ItemNo3 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount3 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel3 tinyint, -- Item狼 泅犁 饭骇
_iSpOption3 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption3 smallint, -- 胶泡 可记 2
_ItemDate4 int, -- Item 积己 锅龋
_ItemSN4 int, -- Item 捞 积己 揪府倔
_ItemNo4 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount4 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel4 tinyint, -- Item狼 泅犁 饭骇
_iSpOption4 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption4 smallint, -- 胶泡 可记 2
_ItemDate5 int, -- Item 积己 锅龋
_ItemSN5 int, -- Item 捞 积己 揪府倔
_ItemNo5 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount5 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel5 tinyint, -- Item狼 泅犁 饭骇
_iSpOption5 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption5 smallint, -- 胶泡 可记 2
_ItemDate6 int, -- Item 积己 锅龋
_ItemSN6 int, -- Item 捞 积己 揪府倔
_ItemNo6 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount6 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel6 tinyint, -- Item狼 泅犁 饭骇
_iSpOption6 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption6 smallint, -- 胶泡 可记 2
_ItemDate7 int, -- Item 积己 锅龋
_ItemSN7 int, -- Item 捞 积己 揪府倔
_ItemNo7 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount7 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel7 tinyint, -- Item狼 泅犁 饭骇
_iSpOption7 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption7 smallint, -- 胶泡 可记 2
_ItemDate8 int, -- Item 积己 锅龋
_ItemSN8 int, -- Item 捞 积己 揪府倔
_ItemNo8 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount8 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel8 tinyint, -- Item狼 泅犁 饭骇
_iSpOption8 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption8 smallint, -- 胶泡 可记 2
_ItemDate9 int, -- Item 积己 锅龋
_ItemSN9 int, -- Item 捞 积己 揪府倔
_ItemNo9 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount9 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel9 tinyint, -- Item狼 泅犁 饭骇
_iSpOption9 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption9 smallint, -- 胶泡 可记 2

_ItemDate10 int, -- Item 积己 锅龋
_ItemSN10 int, -- Item 捞 积己 揪府倔
_ItemNo10 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount10 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel10 tinyint, -- Item狼 泅犁 饭骇
_iSpOption10 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption10 smallint, -- 胶泡 可记 2
_ItemDate11 int, -- Item 积己 锅龋
_ItemSN11 int, -- Item 捞 积己 揪府倔
_ItemNo11 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount11 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel11 tinyint, -- Item狼 泅犁 饭骇
_iSpOption11 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption11 smallint, -- 胶泡 可记 2
_ItemDate12 int, -- Item 积己 锅龋
_ItemSN12 int, -- Item 捞 积己 揪府倔
_ItemNo12 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount12 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)
_ItemLevel12 tinyint, -- Item狼 泅犁 饭骇
_iSpOption12 int, -- 漂荐可记3俺 酒捞袍 殿鞭
_SttOption12 smallint, -- 胶泡 可记 2
_ItemDate13 int, -- Item 积己 锅龋
_ItemSN13 int, -- Item 捞 积己 揪府倔
_ItemNo13 smallint, -- Item Table 郴俊辑狼 绊蜡 锅龋
_ItemCount13 tinyint, -- Item 狼 肮荐(荐樊屈老 版快)