USE MuOnline BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET TRANSACTION ISOLATION LEVEL SERIALIZABLE SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_cLevel GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_LevelUpPoint GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_Experience GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_Money GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_MapDir GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_PkCount GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_PkLevel GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_PkTime GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_CtlCode GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__DbVer__3A4CA8FD GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Quest__40F9A68C GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Leade__6FB49575 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__ChatL__70A8B9AE GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Fruit__44CA3770 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_ExtendedInvenCount GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Reset__3DF31CAF GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__reset__3EE740E8 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__reset__3FDB6521 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__reset__40CF895A GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__MRese__41C3AD93 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__PkCou__42B7D1CC GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__HeroC__43ABF605 GO CREATE TABLE dbo.Tmp_Character ( AccountID varchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL, Name varchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL, cLevel int NULL, LevelUpPoint int NULL, Class tinyint NULL, Experience int NULL, Strength smallint NULL, Dexterity smallint NULL, Vitality smallint NULL, Energy smallint NULL, Inventory varbinary(3776) NULL, MagicList varbinary(180) NULL, Money int NULL, Life real NULL, MaxLife real NULL, Mana real NULL, MaxMana real NULL, MapNumber smallint NULL, MapPosX smallint NULL, MapPosY smallint NULL, MapDir tinyint NULL, PkCount int NULL, PkLevel int NULL, PkTime int NULL, MDate smalldatetime NULL, LDate smalldatetime NULL, CtlCode tinyint NOT NULL, DbVersion tinyint NULL, Quest varbinary(50) NULL, Leadership smallint NULL, ChatLimitTime smallint NULL, FruitPoint int NULL, JHDX varchar(10) COLLATE Chinese_PRC_CI_AS NULL, JHtype tinyint NULL, ExtendedInvenCount tinyint NOT NULL, CTM_Image varchar(50) NULL, Resets int NOT NULL, resetsDay int NOT NULL, resetsWeek int NOT NULL, resetsMonth int NOT NULL, MResets int NOT NULL, PkCountWeb int NOT NULL, HeroCountWeb int NOT NULL, ExGameServerCode char(10) NULL ) ON [PRIMARY] GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_cLevel DEFAULT (1) FOR cLevel GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_LevelUpPoint DEFAULT (0) FOR LevelUpPoint GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_Experience DEFAULT (0) FOR Experience GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_Money DEFAULT (0) FOR Money GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_MapDir DEFAULT (0) FOR MapDir GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_PkCount DEFAULT (0) FOR PkCount GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_PkLevel DEFAULT (3) FOR PkLevel GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_PkTime DEFAULT (0) FOR PkTime GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_CtlCode DEFAULT (0) FOR CtlCode GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__DbVer__3A4CA8FD DEFAULT (0) FOR DbVersion GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Quest__40F9A68C DEFAULT (0) FOR Quest GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Leade__6FB49575 DEFAULT (0) FOR Leadership GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__ChatL__70A8B9AE DEFAULT (0) FOR ChatLimitTime GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Fruit__44CA3770 DEFAULT (0) FOR FruitPoint GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_ExtendedInvenCount DEFAULT (0) FOR ExtendedInvenCount GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Reset__3DF31CAF DEFAULT (0) FOR Resets GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__reset__3EE740E8 DEFAULT (0) FOR resetsDay GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__reset__3FDB6521 DEFAULT (0) FOR resetsWeek GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__reset__40CF895A DEFAULT (0) FOR resetsMonth GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__MRese__41C3AD93 DEFAULT (0) FOR MResets GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__PkCou__42B7D1CC DEFAULT (0) FOR PkCountWeb GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__HeroC__43ABF605 DEFAULT (0) FOR HeroCountWeb GO IF EXISTS(SELECT * FROM dbo.[Character]) EXEC('INSERT INTO dbo.Tmp_Character (AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest, Leadership, ChatLimitTime, FruitPoint, JHDX, JHtype, ExtendedInvenCount, CTM_Image, Resets, resetsDay, resetsWeek, resetsMonth, MResets, PkCountWeb, HeroCountWeb) SELECT AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest, Leadership, ChatLimitTime, FruitPoint, JHDX, JHtype, ExtendedInvenCount, CTM_Image, Resets, resetsDay, resetsWeek, resetsMonth, MResets, PkCountWeb, HeroCountWeb FROM dbo.[Character] TABLOCKX') GO DROP TABLE dbo.[Character] GO EXECUTE sp_rename N'dbo.Tmp_Character', N'Character', 'OBJECT' GO ALTER TABLE dbo.[Character] ADD CONSTRAINT PK_Character PRIMARY KEY NONCLUSTERED ( Name ) ON [PRIMARY] GO CREATE TRIGGER [kris] ON dbo.[Character] AFTER INSERT AS update character set inventory = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF from inserted where character.name = inserted.name and character.class = 96 GO COMMIT