-- To make it a bit easier to understand:
-- 'Lancea' is the character name
-- 'bloody' is the account name
-- '45' is the CharacterID
-- '23' is the AccountID
INSERT INTO DNMembership.dbo.Characters(AccountID,CharacterName,WorldID,CreateDate,DeleteFlag) VALUES ('23',N'Lancea','1',GETDATE(),'0')
INSERT INTO DNWorld.dbo.Characters(CharacterID,AccountID,AccountName,AccountLevelCode,CharacterName,CharacterClassCode,CharacterIndex,VillageFirstVisitFlag,DefaultBody,DefaultLeg,DefaultHand,DefaultFoot,DeleteFlag,SkillResetFlag,WorldID) VALUES ('45','23','bloody','0','Lancea','8','8','0','291701','292701','293703','294703','0','0','1')
INSERT INTO DNWorld.dbo.CharacterStatus(CharacterID,CharacterLevel,CharacterExp,MissionScore,JobCode,HairColor,EyeColor,SkinColor,LastMapID,LastVillageMapID,LastVillageGateNumber,PositionX,PositionY,PositionZ,Rotate,Coin,WarehouseCoin,LastRebirthCoinDate,RebirthCoin,PCRoomRebirthCoin,SkillPoint,LastFatigueDate,Fatigue,PCRoomFatigue,WeeklyFatigue,CheckSumBin,LastDarkLairVillageMapID,ViewCashEquip1Flag,ViewCashEquip2Flag,ViewCashEquipmentBitmap) VALUES
('45',1,0,0,8,210987129,173212840,-8421505,5,5,0,0,46000,0,894000,0,0,0,0,0,0,1900-01-01,0,0,0,0,0,0,0,65535),
('45',1,0,0,8,210987129,173212840,-8421505,5,5,0,0,46000,0,894000,0,0,0,0,0,0,1900-01-01,0,0,0,0,0,0,0,65535);
INSERT INTO DNWorld.dbo.JobChangeLogs(CharacterID,JobCode,LogDate) VALUES ('45','8',GETDATE())
INSERT INTO DNWorld.dbo.MaterializedItems(ItemSerial,ItemID,ItemRemainCount,PayMethodCode,SenderCharacterID,ItemMaterializeCode,ItemMaterializeFKey,ItemDurability,RandomSeed,CoolTime,ItemLevel,ItemPotential,SoulBoundFlag,SealCount,ItemOption,ItemMaterializeDate,OwnerCharacterID,ItemLocationCode,ItemLocationIndex) VALUES
(142174292639824805,295701,1,0,17,0,10000,7692,0,0,0,0,0,0,0,SYSDATETIME(),45,1,0),
(113174303289822610,296701,1,0,17,0,10000,7692,0,0,0,0,0,0,0,SYSDATETIME(),45,1,1),
(147174307859820059,291703,1,0,17,0,10000,10000,0,0,0,0,0,0,0,SYSDATETIME(),45,1,3),
(145174316999847725,292701,1,0,17,0,10000,7692,0,0,0,0,0,0,0,SYSDATETIME(),45,1,4),
(127174326929838440,293702,1,0,17,0,10000,7692,0,0,0,0,0,0,0,SYSDATETIME(),45,1,5),
(147174338419820791,294702,1,0,17,0,10000,10000,0,0,0,0,0,0,0,SYSDATETIME(),45,1,6),
(129174344689820101,5109,1,0,17,0,10000,10000,0,0,0,0,0,0,0,SYSDATETIME(),45,1,11),
(110174348869819641,5110,1,0,17,0,10000,10000,0,0,0,0,0,0,0,SYSDATETIME(),45,1,12),
(132174357229818721,302394376,1,0,17,0,10000,10000,0,0,0,0,0,0,0,SYSDATETIME(),45,2,0),
(140174366079847955,302396424,1,0,17,0,10000,0,0,0,0,0,0,0,0,SYSDATETIME(),45,2,1),
(117174374929844422,1073842837,1,17,0,0,0,0,0,0,0,0,SYSDATETIME(),45,2,4,1);
INSERT INTO DNWorld.dbo.Skills(CharacterID,SkillID,SkillLevel,CoolTime,UsedSkillPoint,DefaultSkillLevel,SkillCode) VALUES
(45,7001,1,0,0,1,1),
(45,7002,1,0,0,1,1),
(45,7003,1,0,0,1,1),
(45,7004,1,0,0,1,1),
(45,7005,1,0,0,1,1),
(45,7006,1,0,0,1,1),
(45,7252,1,0,0,1,1);
INSERT INTO DNWorld.dbo.MissionBinaries(CharacterID,GainMissionBin) VALUES
(45,0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000)
INSERT INTO DNWorld.dbo.Quests(CharacterID,QuestIndex,QuestID,QuestStatusCode,QuestStep,QuestJournal,QuestExtra,Memo1,Memo2,Memo3,Memo4,Memo5,Memo6,Memo7,Memo8,Memo9,Memo10,QuestCode,RegisterDate) VALUES
('45','0','9461','1','1','1',0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,'0','0','0','0','0','0','0','0','0','0','1',GETDATE())