奇迹mu 数据库分析（国外英文资料）.doc

奇迹mu 数据库分析（国外英文资料） 5 s21gb4fwt6g The composition of the table: 1, AccountCharacter The role to store accounts. 2, Character, Detailed data to hold each role. 3, MEMB_INFO Account information 4, MEMB_STAT Account status 5, warehouse warehouse 6, VI_CURR_INFO Account cost 7, WEB_ZS The transfer data of the PL site Two, each table description 1, AccountCharacter table The name type length is empty Number int 4 0 automatically adds an ordinal Number Id varchar 100 account GameID1 varchar 10 1 role 1 GameID2 varchar 10 1 role 2 GameID3 varchar 10 1 GameID4 varchar 10 1 GameID5 varchar 10 1 GameIDC varchar 10 1 2, Character table The name type length is empty AccountID varchar 10 0 - - accounts Name nvarchar 10 0 - - character Name CLevel smallint 2 1 - - - class Level uppoint int 4 - - - upgrade point Class tinyint 1, 1 - - 1 magic 1, 1 magic 1, 1, 1, 3, 3, 3, 3, 3, 3, 3, 3, 6, 6, 16, 6, 6, 6, 6, 4, 6, 6, 4, 6, 6, 6, 6, 3, 6, 6, 6, 6, 6, 6 Experience is an Experience Strength smallint 2 1 - - Strength Dexterity smallint 2 1 -- -agile Vitality smallint 2 1 - -- -strength Energy smallint 2 1 -- -intelligence Inventory varbinary 760 1 - the warehouse MagicList varbinary 60 1 - - skills Money int 4 1 -- -money Life real 4, 1 -- -- -- MaxLife real 4, 1 - - Mana real 4 -- -- -- MaxMana real 4, 1 - - MapNumber smallint 2 1 - - the map number MapPosX smallint 2 1 -- -x coordinates MapPosY smallint 2 1 -- -y coordinates MapDir tinyint 1 -- -- -- PkCount int 4, 1 minus -- PkLevel int 4 1 - - -pk status: 0 hero 1 hero 2 good guy 3 p4 rascal 5 demon head PkTime int 4 1 MDate smalldatetime 4 1 LDate smalldatetime 4 1 CtlCode tinyint 1-0 common character 8GM DbVersion tinyint 1 1 Quest varbinary 50 one LINZB bit 1 0 XDTIME datetime 8 0 STOPINFO nvarchar 100 1 STOPTIME datetime 8, 0 Zs_count int 4 1 Zs_point int 4 1 Bs_count int 4 1 Bs_point int 4 1 Shiji smalldatetime 4 1 Banl nvarchar 10 1 Lv_time datetime 8 1 Ex_ok int 4 1 Ex_total int 4 1 Rb_count int 4, 1 Rb_time datetime 8 1 Pz_t