CREATE TABLE [dbo].[RoleData] (
[IsDelete] bit DEFAULT ((0)) NOT NULL,
[IsGM] bit DEFAULT ((0)) NOT NULL,
[IsEnterWorld] bit DEFAULT ((0)) NOT NULL,
[CharField] int NOT NULL,
[DBID] int IDENTITY(1,1) NOT NULL,
[Account_ID] varchar(65) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateTime] datetime DEFAULT ((0)) NOT NULL,
[LogoutTime] int DEFAULT ((0)) NOT NULL,
[Type] int DEFAULT ((0)) NOT NULL,
[Mode] int DEFAULT ((0)) NOT NULL,
[RoleName] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[ZoneID] int DEFAULT ((0)) NOT NULL,
[X] real DEFAULT ((0)) NOT NULL,
[Y] real DEFAULT ((0)) NOT NULL,
[Z] real DEFAULT ((0)) NOT NULL,
[Dir] real DEFAULT ((0)) NOT NULL,
[RoomID] int DEFAULT ((0)) NOT NULL,
[Race] int DEFAULT ((0)) NOT NULL,
[Voc] int DEFAULT ((0)) NOT NULL,
[Voc_Sub] int DEFAULT ((-1)) NOT NULL,
[Sex] int DEFAULT ((0)) NOT NULL,
[LV] int DEFAULT ((0)) NOT NULL,
[LV_Sub] int DEFAULT ((0)) NOT NULL,
[TitleID] int DEFAULT ((0)) NOT NULL,
[HP] real NOT NULL,
[MP] real DEFAULT ((0)) NOT NULL,
[StomachPoint] int DEFAULT ((100)) NOT NULL,
[BodyCount] int DEFAULT ((0)) NOT NULL,
[BankCount] int DEFAULT ((0)) NOT NULL,
[RevX] real DEFAULT ((0)) NOT NULL,
[RevY] real DEFAULT ((0)) NOT NULL,
[RevZ] real NOT NULL,
[RevDir] real DEFAULT ((0)) NOT NULL,
[RevZoneID] int DEFAULT ((0)) NOT NULL,
[FaceID] int DEFAULT ((0)) NOT NULL,
[HairID] int DEFAULT ((0)) NOT NULL,
[HairColor] int DEFAULT ((0)) NOT NULL,
[BodyColor] int DEFAULT ((0)) NOT NULL,
[OrgObjID] int DEFAULT ((1000)) NOT NULL,
[Card] varbinary(256) DEFAULT ((0)) NOT NULL,
[KeyItem] varbinary(2000) DEFAULT ((0)) NOT NULL,
[Title] varbinary(256) DEFAULT ((0)) NOT NULL,
[QuestHistory] varbinary(1024) DEFAULT ((0)) NOT NULL,
[QuestKillCount] varbinary(100) DEFAULT ((0)) NOT NULL,
[QuestDaily] varbinary(1024) DEFAULT ((0)) NOT NULL,
[QuestGroup] varbinary(80) DEFAULT ((0)) NOT NULL,
[LastCompleteTime] int DEFAULT ((0)) NOT NULL,
[QuestLog] varbinary(360) DEFAULT ((0)) NOT NULL,
[SkillValue1] real DEFAULT ((0)) NOT NULL,
[SkillValue2] real DEFAULT ((0)) NOT NULL,
[SkillValue3] real DEFAULT ((0)) NOT NULL,
[SkillValue4] real DEFAULT ((0)) NOT NULL,
[SkillValue5] real DEFAULT ((0)) NOT NULL,
[SkillValue6] real DEFAULT ((0)) NOT NULL,
[SkillValue7] real DEFAULT ((0)) NOT NULL,
[SkillValue8] real DEFAULT ((0)) NOT NULL,
[SkillValue9] real DEFAULT ((0)) NOT NULL,
[SkillValue10] real DEFAULT ((0)) NOT NULL,
[SkillValue11] real DEFAULT ((0)) NOT NULL,
[SkillValue12] real DEFAULT ((0)) NOT NULL,
[SkillValue13] real DEFAULT ((0)) NOT NULL,
[SkillValue14] real DEFAULT ((0)) NOT NULL,
[SkillValue15] real DEFAULT ((0)) NOT NULL,
[SkillValue16] real DEFAULT ((0)) NOT NULL,
[SkillValue17] real DEFAULT ((0)) NOT NULL,
[SkillValue18] real DEFAULT ((0)) NOT NULL,
[SkillValue19] real DEFAULT ((0)) NOT NULL,
[SkillValue20] real DEFAULT ((0)) NOT NULL,
[SkillValue21] real DEFAULT ((0)) NOT NULL,
[SkillValue22] real DEFAULT ((0)) NOT NULL,
[SkillValue23] real DEFAULT ((0)) NOT NULL,
[SkillValue24] real DEFAULT ((0)) NOT NULL,
[SkillValue25] real DEFAULT ((0)) NOT NULL,
[SkillValue26] real DEFAULT ((0)) NOT NULL,
[SkillValue27] real DEFAULT ((0)) NOT NULL,
[SkillValue28] real DEFAULT ((0)) NOT NULL,
[SkillValue29] real DEFAULT ((0)) NOT NULL,
[SkillValue30] real DEFAULT ((0)) NOT NULL,
[Buff] varbinary(1404) DEFAULT ((0)) NOT NULL,
[DeadCountDown] int DEFAULT ((0)) NOT NULL,
[Coldown] varbinary(3680) DEFAULT ((0)) NOT NULL,
[RefineColdown] varbinary(164) DEFAULT ((0)) NOT NULL,
[BodyMoney] int DEFAULT ((0)) NOT NULL,
[BankMoney] int DEFAULT ((0)) NOT NULL,
[PartyID] int DEFAULT ((-1)) NOT NULL,
[FriendNote] nvarchar(300) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[GuildID] int DEFAULT ((0)) NOT NULL,
[GuildRank] int DEFAULT ((0)) NOT NULL,
[GuildGroupID] int DEFAULT ((0)) NOT NULL,
[GuildRankTime] int DEFAULT ((0)) NOT NULL,
[GuildSelfNote] nvarchar(256) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[GuildLeaderNote] nvarchar(256) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[PlayTime] int DEFAULT ((0)) NOT NULL,
[BoneScale] varbinary(15) DEFAULT ((1)) NOT NULL,
[vX] real DEFAULT ((0)) NOT NULL,
[vY] real DEFAULT ((0)) NOT NULL,
[vZ] real DEFAULT ((0)) NOT NULL,
[IsBillboardAnonymous] bit DEFAULT ((0)) NOT NULL,
[PKScore] int DEFAULT ((0)) NOT NULL,
[TitleCount] int DEFAULT ((0)) NOT NULL,
[ClientFlag] varbinary(50) DEFAULT ((0)) NOT NULL,
[TitleStr] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[IsShowTitle] bit DEFAULT ((0)) NOT NULL,
[ReturnX] float(53) DEFAULT ((0)) NOT NULL,
[ReturnY] float(53) DEFAULT ((0)) NOT NULL,
[ReturnZ] float(53) DEFAULT ((0)) NOT NULL,
[ReturnDir] float(53) DEFAULT ((0)) NOT NULL,
[ReturnZoneID] float(53) DEFAULT ((0)) NOT NULL,
[Famous10] int DEFAULT ((0)) NOT NULL,
[Famous9] int DEFAULT ((0)) NOT NULL,
[Famous8] int DEFAULT ((0)) NOT NULL,
[Famous7] int DEFAULT ((0)) NOT NULL,
[Famous6] int DEFAULT ((0)) NOT NULL,
[Famous5] int DEFAULT ((0)) NOT NULL,
[Famous4] int DEFAULT ((0)) NOT NULL,
[Famous3] int DEFAULT ((0)) NOT NULL,
[Famous2] int DEFAULT ((0)) NOT NULL,
[Famous1] int DEFAULT ((0)) NOT NULL,
[DestroyTime] int DEFAULT ((-1)) NOT NULL,
[RentFunction] varbinary(200) DEFAULT ((0)) NOT NULL,
[MaxLv] int DEFAULT ((50)) NOT NULL,
[ShowEQ] int DEFAULT ((-1)) NOT NULL,
[HouseDBID] int DEFAULT ((-1)) NOT NULL,
[ClientData] varbinary(256) DEFAULT ((0)) NOT NULL,
[SysFlag] int DEFAULT ((0)) NOT NULL,
[GoodEvil] real DEFAULT ((0)) NOT NULL,
[FriendClientData] varbinary(1920) DEFAULT ((0)) NOT NULL,
[FriendGroupSortID] varbinary(50) DEFAULT ((0)) NOT NULL,
[MonsterHunter] varbinary(816) DEFAULT ((0)) NOT NULL,
[VocCount] int DEFAULT ((0)) NOT NULL,
[BoxEnergy] int DEFAULT ((3)) NOT NULL,
[LocationSave] varbinary(4200) DEFAULT ((0)) NOT NULL,
[RealTimeFlag] varbinary(400) DEFAULT ((0)) NOT NULL,
[PlayTimeFlag] varbinary(400) DEFAULT ((0)) NOT NULL,
[MedalCount] int DEFAULT ((0)) NOT NULL,
[LuaValueFlag] varbinary(4000) DEFAULT ((0)) NOT NULL,
[Money_Bonus] int DEFAULT ((0)) NOT NULL,
[HorseColor] binary(16) DEFAULT ((0)) NOT NULL,
[RaiseMode] int DEFAULT ((0)) NOT NULL,
[RaiseExpRate] int DEFAULT ((0)) NOT NULL,
[RaiseZoneID] int DEFAULT ((0)) NOT NULL,
[RaiseRevX] real DEFAULT ((0)) NOT NULL,
[RaiseRevY] real DEFAULT ((0)) NOT NULL,
[RaiseRevZ] real DEFAULT ((0)) NOT NULL,
[TombItemGUID] int DEFAULT ((0)) NOT NULL,
[TombCreateTime] int DEFAULT ((0)) NOT NULL,
[TombZoneID] int DEFAULT ((0)) NOT NULL,
[TombX] real DEFAULT ((0)) NOT NULL,
[TombY] real DEFAULT ((0)) NOT NULL,
[TombZ] real DEFAULT ((0)) NOT NULL,
[TombDebtExp] int DEFAULT ((0)) NOT NULL,
[TombDebtTp] int DEFAULT ((0)) NOT NULL,
[TombExp] int DEFAULT ((0)) NOT NULL,
[GoodEvilBonus] real DEFAULT ((10)) NOT NULL,
[LockAccountMoney] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney1] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney2] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney3] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney4] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney5] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney6] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney7] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney8] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney9] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney10] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney11] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney12] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney13] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney14] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney15] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney16] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney17] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney18] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney19] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney20] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney21] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney22] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney23] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney24] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney25] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney26] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney27] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney28] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney29] int DEFAULT ((0)) NOT NULL,
[LockAccountMoney30] int DEFAULT ((0)) NOT NULL,
[LockAccountTime] int DEFAULT ((0)) NOT NULL,
[Honor] real DEFAULT ((0)) NOT NULL,
[HonorWorth] real DEFAULT ((50)) NOT NULL,
[LastBeHonorKilledTime] int DEFAULT ((0)) NOT NULL,
[MaxPlantCount] int DEFAULT ((0)) NOT NULL,
[MoneyTraderCount] real DEFAULT ((0)) NOT NULL,
[AutoBotCount] real DEFAULT ((0)) NOT NULL,
[BotReportDBID] int DEFAULT ((0)) NOT NULL,
[BotReportTime] int DEFAULT ((0)) NOT NULL,
[BotReportProtectTime] int DEFAULT ((0)) NOT NULL,
[InstanceSetting] varbinary(800) DEFAULT ((0)) NOT NULL,
[ExpDownRate] int DEFAULT ((0)) NOT NULL,
[DebtExpRate] int DEFAULT ((0)) NOT NULL,
[DebtTpRate] int DEFAULT ((0)) NOT NULL,
[RoomKey] int DEFAULT ((0)) NOT NULL,
[SuitSkill_LearnCount] int DEFAULT ((0)) NOT NULL,
[SuitSkill_MaxEqCount] int DEFAULT ((0)) NOT NULL,
[SuitSkill_Learn] varbinary(800) DEFAULT ((0)) NOT NULL,
[SuitSkill_EQ] varbinary(40) DEFAULT ((0)) NOT NULL,
[InstanceSetting_KeyID] varbinary(400) DEFAULT ((0)) NOT NULL,
[InstanceSetting_LiveTime] varbinary(400) DEFAULT ((0)) NOT NULL,
[InstanceSetting_ExtendTime] varbinary(400) DEFAULT ((0)) NOT NULL,
[Pet_NextMergeResetTime] int DEFAULT ((0)) NOT NULL,
[Pet_Money] int DEFAULT ((0)) NOT NULL,
[CoolSuitList] varbinary(1120) DEFAULT ((0)) NOT NULL,
[CoolClothList] varbinary(2000) DEFAULT ((0)) NOT NULL,
[CoolSuitID] int DEFAULT ((-1)) NOT NULL,
[PetExBag] varbinary(404) DEFAULT ((0)) NOT NULL,
[HorseExBag] varbinary(2004) DEFAULT ((0)) NOT NULL,
[GuildLeaveTime] smalldatetime DEFAULT ((0)) NOT NULL,
[IncursivePoint] int DEFAULT ((0)) NOT NULL,
[TitleSys_Famous] float(53) DEFAULT ((0)) NOT NULL,
[TitleSys_TitleID1] int DEFAULT ((0)) NOT NULL,
[TitleSys_TitleID2] int DEFAULT ((0)) NOT NULL,
[TitleSys_TitleID3] int DEFAULT ((0)) NOT NULL,
[TitleSys_TitleID4] int DEFAULT ((0)) NOT NULL,
[TitleSys_Lv] int DEFAULT ((0)) NOT NULL,
[TitleSys_Exp] int DEFAULT ((0)) NOT NULL,
[SerialCode] int DEFAULT ((0)) NOT NULL,
[SerialCode1] int DEFAULT ((0)) NOT NULL,
[SerialCode_All] int DEFAULT ((0)) NOT NULL,
[SlotMachine_History] varbinary(max) DEFAULT ((0)) NOT NULL,
[SlotMachine_RandSeed] varbinary(max) DEFAULT ((0)) NOT NULL,
[SlotMachine_FreeCount] int DEFAULT ((0)) NOT NULL,
[DuelistReward] int DEFAULT ((0)) NOT NULL,
[PetCard] varbinary(max) DEFAULT ((0)) NOT NULL,
[DreamlandCoin] int DEFAULT ((0)) NOT NULL,
[PhiriusShellCoin] int DEFAULT ((0)) NOT NULL,
[EnergyJusticeCoin] int DEFAULT ((0)) NOT NULL,
[ProofLegendCoin] int DEFAULT ((0)) NOT NULL,
[TrialBadgeCoin] int DEFAULT ((0)) NOT NULL,
[RelicsCoin] int DEFAULT ((0)) NOT NULL,
[mirrorcoin] int NULL,
[phantom] int NULL,
[weekinstance] binary(20) NULL,
[weekinstday] int NULL,
[weekresetcount] int NULL
)
GO