奇迹mu 数据库分析

奇迹mu 数据库 5s21gb4fwt6g Ò????íµÄ×é?É?º 1??AccountCharacter ÓÃÀ??æ?ÅÕʺŵÄ?ÇÉ??? 2??Character ÓÃÀ??æ?ÅÃ??ö?ÇÉ?µÄÏêÏ?Êý?Ý?? 3??MEMB_INFO ÕʺÅÐÅÏ? 4??MEMB_STAT ÕʺÅ×?Ì? 5??warehouse ?Ö?â 6??VI_CURR_INFO ÕʺÅ?ÑÓà 7??WEB_ZS PL ÍøÕ?µÄתÉúÊý?Ý ?þ?????í˵Ã? 1??AccountCharacter ?í ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? Number int 4 0 ×Ô??Ôö?ÓµÄÐòÊý Id varchar 10 0 ÕʺŠGameID1 varchar 10 1 ?ÇÉ?1 GameID2 varchar 10 1 ?ÇÉ?2 GameID3 varchar 10 1 GameID4 varchar 10 1 GameID5 varchar 10 1 GameIDC varchar 10 1 2??Character ?í ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? AccountID varchar 10 0 --------ÕʺŠName nvarchar 10 0 --------?ÇÉ?Ãû cLevel smallint 2 1 --------µÈ?? LevelUpPoint int 4 1 --------Éý??µã Class tinyint 1 1 --------Ö?Òµ 0?? 1Ä?µ? 32?? 33Ê? 16Õ? 17Æï 48Ä? 64Ê?µ? Experience int 4 1 --------?,Ñé Strength smallint 2 1 --------Á?Á? Dexterity smallint 2 1 --------Ãô?Ý Vitality smallint 2 1 --------ÌåÁ? Energy smallint 2 1 --------ÖÇÁ? Inventory varbinary 760 1 --------ÉíÉÏ?Ö?â MagicList varbinary 60 1 --------??ÄÜ Money int 4 1 --------Ç? Life real 4 1 -------- MaxLife real 4 1 -------- Mana real 4 1 -------- MaxMana real 4 1 -------- MapNumber smallint 2 1 --------ËùÔÚµØÍ?ºÅ MapPosX smallint 2 1 --------X×ø?ê MapPosY smallint 2 1 --------Y×ø?ê MapDir tinyint 1 1 -------- PkCount int 4 1 -------- PkLevel int 4 1 --------PK×?Ì??º0?óÏÀ 1Ó?ÐÛ 2ºÃÈË 3ÆÕ 4ÎÞÀµ 5Ä?Í? PkTime int 4 1 MDate smalldatetime 4 1 LDate smalldatetime 4 1 CtlCode tinyint 1 1 --------0 ÆÕÍ??ÇÉ? 8GM DbVersion tinyint 1 1 Quest varbinary 50 1 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_time datetime 8 1 3??MEMB_INFO ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? memb_guid int 4 0 -------- 1(ϵÍ?×Ô??Éú?É) memb___id nvarchar 10 0 --------ÕʺŠmemb__pwd nvarchar 10 0 --------ÃÜÂë memb_name nvarchar 10 0 --------êÇ?Æ (1) sno__numb nvarchar 18 0 --------1 post_code nvarchar 6 1 --------1234 addr_info nvarchar 50 1 --------XXXXXXXXXXX addr_deta nvarchar 50 1 --------XXXXXXXXXXX tel__numb nvarchar 20 1 --------XXXXXXXXXXX phon_numb nvarchar 15 1 --------XXXXXXXXXXX mail_addr nvarchar 50 1 --------ÓÊ?þµØÖ? fpas_ques nvarchar 50 1 --------ÃÜÂëÌáÊ?ÎÊÌâ fpas_answ nvarchar 50 1 --------?ð?? job__code nvarchar 2 1 --------XXXXXXXXXXXX appl_days smalldatetime 4 1 --------2005-6-6 23:00:00 modi_days smalldatetime 4 1 --------2005-6-6 23:00:00 out__days smalldatetime 4 1 --------2005-6-6 23:00:00 true_days smalldatetime 4 1 --------2005-6-6 23:00:00 mail_chek nvarchar 1 1 -------- 0 ?ò 1 bloc_code nvarchar 1 0 --------0 Õý?? >0?âºÅ ctl1_code nvarchar 1 0 --------0 LINZBSJ datetime 8 1 --------NULL LGONGZHISJ datetime 8 1 --------NULL STOPINFO nvarchar 100 1 --------NULL STOPTIME datetime 8 1 --------NULL QX char 1 1 --------B JF int 4 0 --------0 huiy int 4 1 --------0 hysj smalldatetime 4 1 --------NULL lqsj smalldatetime 4 1 --------NULL FDB int 4 1 --------0 vip tinyint 1 1 --------0 Expired datetime 8 1 --------2005-6-6 23:00:05 4??MEMB_STAT ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? memb___id nvarchar 10 0 --------ÕʺŠConnectStat tinyint 1 1 --------ÊÇ?ñÔÚÏß 0?º??ÔÚÏß ServerName nvarchar 20 1 --------Á??ÓµÄÏßÃû IP nvarchar 15 1 --------IPµØÖ? ConnectTM smalldatetime 4 1 --------ÉÏÏßÈÕÆÚ??Ê??ä DisConnectTM smalldatetime 4 1 --------ÏÂÏßÈÕÆÚ??Ê??ä 5??warehouse ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? AccountID varchar 10 0 --------ÕʺŠItems varbinary 1200 1 --------?Ö?âÎïÆ? Money int 4 1 --------Ç? EndUseDate smalldatetime 4 1 --------×îºóÊ?ÓÃÈÕÆÚ??Ê??ä DbVersion tinyint 1 1 --------1 pw smallint 2 1 --------ÃÜÂë 0 lastpw smallint 2 0 --------×îºóÃÜÂë 0 ExtCKNum int 4 0 --------0 NeedExtCK int 4 0 --------0 6??VI_CURR_INFO ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? ends_days nvarchar 8 1 --------20081111 chek_code nvarchar 1 0 --------1 used_time int 4 1 --------1234 memb___id nvarchar 10 0 --------ÕʺŠmemb_name nvarchar 10 0 --------êÇ?Æ memb_guid int 4 0 --------GUID Óë MEMB_INFO ÀïµÄ?ÔÓ? sno__numb nvarchar 18 0 --------123456 Bill_Section int 4 1 --------6 Bill_Value int 4 1 --------3 Bill_Hour int 4 1 --------0 Surplus_Point int 4 1 --------0 Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05 Increase_Days datetime 8 1 --------2005-6-6 23:00:05 7??WEB_ZS ÁÐÃû ÀàÐÍ ?? ÊÇ?ñ?Õ ËµÃ? ID bigint 8 0 ACC char 10 1 NAME char 10 1 ZSTIME datetime 8 1 ZSCLEVEL smallint 2 1 ZSCS smallint 2 0 CZCS smallint 2 0 CZTIME datetime 8 0 ZJZSCS smallint 2 0 GJZSCS smallint 2 0 CJZSCS smallint 2 0 BSCS smallint 2 0 BSTIME datetime 8 0 LEVELUPPOINT int 4 0 GDDS int 4 0