奇迹muonline数据库基础库分析 |
一、表的组成: gOI9VU http://blog.numino.net/ 1、AccountCharacter 9R8uuz http://blog.numino.net/ 用来存放帐号的角色。 ank80K http://blog.numino.net/ 2、Character O5RGuF http://blog.numino.net/ 用来存放每个角色的详细数据。 i6o1OG http://blog.numino.net/ 3、MEMB_INFO o1id7I http://blog.numino.net/ 帐号信息 87pKGo http://blog.numino.net/ 4、MEMB_STAT Kk1p63 http://blog.numino.net/ 帐号状态 yllCOT http://blog.numino.net/ 5、warehouse D2Ucxw http://blog.numino.net/ 仓库 TlHWq4 http://blog.numino.net/ 6、VI_CURR_INFO Ek5Yfm http://blog.numino.net/ 帐号费用 lS090M http://blog.numino.net/ 7、WEB_ZS 67HzTK http://blog.numino.net/ PL 网站的转生数据 zuZff0 http://blog.numino.net/ 二、各表说明 l7hrRt http://blog.numino.net/ 1、AccountCharacter 表 2orRno http://blog.numino.net/ 列名 类型 长 是否空 说明 9UyJJ5 http://blog.numino.net/ Number int 4 0 自动增加的序数 5vn7N1 http://blog.numino.net/ Id varchar 10 0 帐号 30N5q5 http://blog.numino.net/ GameID1 varchar 10 1 角色1 a6cDA5 http://blog.numino.net/ GameID2 varchar 10 1 角色2 W66Pj8 http://blog.numino.net/ GameID3 varchar 10 1 247h8X http://blog.numino.net/ GameID4 varchar 10 1 ar3mBu http://blog.numino.net/ GameID5 varchar 10 1 ZJqClz http://blog.numino.net/ GameIDC varchar 10 1 M9r9SK http://blog.numino.net/ 2、Character 表 6Z0Qem http://blog.numino.net/ 列名 类型 长 是否空 说明 MqH211 http://blog.numino.net/ AccountID varchar 10 0 --------帐号 VDEODc http://blog.numino.net/ Name nvarchar 10 0 --------角色名 8mSr40 http://blog.numino.net/ cLevel smallint 2 1 --------等级 ReTVG3 http://blog.numino.net/ LevelUpPoint int 4 1 --------升级点 cx0oGw http://blog.numino.net/ Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导 Z58IS9 http://blog.numino.net/ Experience int 4 1 --------经验 8ZZ4FO http://blog.numino.net/ Strength smallint 2 1 --------力量 hfbit8 http://blog.numino.net/ Dexterity smallint 2 1 --------敏捷 9Z30Zm http://blog.numino.net/ Vitality smallint 2 1 --------体力 2pjx15 http://blog.numino.net/ Energy smallint 2 1 --------智力 2LkBdk http://blog.numino.net/ Inventory varbinary 760 1 --------身上仓库 1t6njY http://blog.numino.net/ MagicList varbinary 60 1 --------技能 bC8v83 http://blog.numino.net/ Money int 4 1 --------钱 75Pa9M http://blog.numino.net/ Life real 4 1 -------- m8jhy3 http://blog.numino.net/ MaxLife real 4 1 -------- L2KMCd http://blog.numino.net/ Mana real 4 1 -------- 1v1pu8 http://blog.numino.net/ MaxMana real 4 1 -------- 3QDmbT http://blog.numino.net/ MapNumber smallint 2 1 --------所在地图号 P983dh http://blog.numino.net/ MapPosX smallint 2 1 --------X坐标 D6784q http://blog.numino.net/ MapPosY smallint 2 1 --------Y坐标 BakzLO http://blog.numino.net/ MapDir tinyint 1 1 -------- BHL0gY http://blog.numino.net/ PkCount int 4 1 -------- v2s34u http://blog.numino.net/ PkLevel int 4 1 --------PK状态:0大侠 1英雄 2好人 3普 4无赖 5魔头 qR47mX http://blog.numino.net/ PkTime int 4 1 f0OC6R http://blog.numino.net/ MDate smalldatetime 4 1 Gk7u7M http://blog.numino.net/ LDate smalldatetime 4 1 UOTvUW http://blog.numino.net/ CtlCode tinyint 1 1 --------0 普通角色 8GM z1sPjI http://blog.numino.net/ DbVersion tinyint 1 1 oEAD5S http://blog.numino.net/ Quest varbinary 50 1 EY5WST http://blog.numino.net/ LINZB bit 1 0 E1j9aH http://blog.numino.net/ XDTIME datetime 8 0 Jt8vh6 http://blog.numino.net/ STOPINFO nvarchar 100 1 C7d2XU http://blog.numino.net/ STOPTIME datetime 8 0 vCy8Oy http://blog.numino.net/ zs_count int 4 1 e2T7nw http://blog.numino.net/ zs_point int 4 1 F4oHjb http://blog.numino.net/ bs_count int 4 1 sq34RI http://blog.numino.net/ bs_point int 4 1 X0988V http://blog.numino.net/ shiji smalldatetime 4 1 Ky0p73 http://blog.numino.net/ banl nvarchar 10 1 A3gvWp http://blog.numino.net/ lv_time datetime 8 1 5X6zoZ http://blog.numino.net/ ex_ok int 4 1 Htcm92 http://blog.numino.net/ ex_total int 4 1 up3IhW http://blog.numino.net/ rb_count int 4 1 XWA3t2 http://blog.numino.net/ rb_time datetime 8 1 3JAr5n http://blog.numino.net/ pz_time datetime 8 1 Vzpciq http://blog.numino.net/ 3、MEMB_INFO WHlzcv http://blog.numino.net/ 列名 类型 长 是否空 说明 3UO53E http://blog.numino.net/ memb_guid int 4 0 -------- 1(系统自动生成) UY1rKR http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 Z8llzo http://blog.numino.net/ memb__pwd nvarchar 10 0 --------密码 Dr7QTB http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 (1) Asxg9K http://blog.numino.net/ sno__numb nvarchar 18 0 --------1 BSDe69 http://blog.numino.net/ post_code nvarchar 6 1 --------1234 Zz4Nyf http://blog.numino.net/ addr_info nvarchar 50 1 --------XXXXXXXXXXX 0WouC6 http://blog.numino.net/ addr_deta nvarchar 50 1 --------XXXXXXXXXXX qc6c2t http://blog.numino.net/ tel__numb nvarchar 20 1 --------XXXXXXXXXXX msHdCM http://blog.numino.net/ phon_numb nvarchar 15 1 --------XXXXXXXXXXX 37eZu5 http://blog.numino.net/ mail_addr nvarchar 50 1 --------邮件地址 el1NSf http://blog.numino.net/ fpas_ques nvarchar 50 1 --------密码提示问题 KjsuVd http://blog.numino.net/ fpas_answ nvarchar 50 1 --------答案 l45kW9 http://blog.numino.net/ job__code nvarchar 2 1 --------XXXXXXXXXXXX tGj8xD http://blog.numino.net/ appl_days smalldatetime 4 1 --------2005-6-6 23:00:00 12w2Od http://blog.numino.net/ modi_days smalldatetime 4 1 --------2005-6-6 23:00:00 2BMt1Z http://blog.numino.net/ out__days smalldatetime 4 1 --------2005-6-6 23:00:00 Mxse4T http://blog.numino.net/ true_days smalldatetime 4 1 --------2005-6-6 23:00:00 w39BeA http://blog.numino.net/ mail_chek nvarchar 1 1 -------- 0 或 1 RTtyuh http://blog.numino.net/ bloc_code nvarchar 1 0 --------0 正常 >0封号 1jGN10 http://blog.numino.net/ ctl1_code nvarchar 1 0 --------0 MdIClb http://blog.numino.net/ LINZBSJ datetime 8 1 --------NULL V56q8d http://blog.numino.net/ LGONGZHISJ datetime 8 1 --------NULL UTa5v4 http://blog.numino.net/ STOPINFO nvarchar 100 1 --------NULL rK5637 http://blog.numino.net/ STOPTIME datetime 8 1 --------NULL aE4Oq4 http://blog.numino.net/ QX char 1 1 --------B GXh7MG http://blog.numino.net/ JF int 4 0 --------0 Hg1hNl http://blog.numino.net/ huiy int 4 1 --------0 7hecR7 http://blog.numino.net/ hysj smalldatetime 4 1 --------NULL t9qLB2 http://blog.numino.net/ lqsj smalldatetime 4 1 --------NULL NYdRCr http://blog.numino.net/ FDB int 4 1 --------0 587zXS http://blog.numino.net/ vip tinyint 1 1 --------0 g1AHnl http://blog.numino.net/ Expired datetime 8 1 --------2005-6-6 23:00:05 59Oa8L http://blog.numino.net/ 4、MEMB_STAT X7470N http://blog.numino.net/ 列名 类型 长 是否空 说明 99qOZd http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 E4jV96 http://blog.numino.net/ ConnectStat tinyint 1 1 --------是否在线 0:不在线 Eo9Nd2 http://blog.numino.net/ ServerName nvarchar 20 1 --------连接的线名 av2s68 http://blog.numino.net/ IP nvarchar 15 1 --------IP地址 ZJvrs8 http://blog.numino.net/ ConnectTM smalldatetime 4 1 --------上线日期、时间 7xZD3D http://blog.numino.net/ DisConnectTM smalldatetime 4 1 --------下线日期、时间 aXr9Xq http://blog.numino.net/ 5、warehouse T6XxQs http://blog.numino.net/ 列名 类型 长 是否空 说明 0nGdwj http://blog.numino.net/ AccountID varchar 10 0 --------帐号 Is74SA http://blog.numino.net/ Items varbinary 1200 1 --------仓库物品 RRoait http://blog.numino.net/ Money int 4 1 --------钱 0y2vYK http://blog.numino.net/ EndUseDate smalldatetime 4 1 --------最后使用日期、时间 Ric074 http://blog.numino.net/ DbVersion tinyint 1 1 --------1 LAqGfj http://blog.numino.net/ pw smallint 2 1 --------密码 0 0360aO http://blog.numino.net/ lastpw smallint 2 0 --------最后密码 0 l3D1Cp http://blog.numino.net/ ExtCKNum int 4 0 --------0 kUAg9g http://blog.numino.net/ NeedExtCK int 4 0 --------0 42llyw http://blog.numino.net/ 6、VI_CURR_INFO AHfD1t http://blog.numino.net/ 列名 类型 长 是否空 说明 h78rEU http://blog.numino.net/ ends_days nvarchar 8 1 --------20081111 7f2G1h http://blog.numino.net/ chek_code nvarchar 1 0 --------1 thF9nX http://blog.numino.net/ used_time int 4 1 --------1234 7FUJjm http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 ULMB45 http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 lKapLn http://blog.numino.net/ memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应 3oGr4a http://blog.numino.net/ sno__numb nvarchar 18 0 --------123456 IHscm6 http://blog.numino.net/ Bill_Section int 4 1 --------6 D4pShY http://blog.numino.net/ Bill_Value int 4 1 --------3 Gm3WrP http://blog.numino.net/ Bill_Hour int 4 1 --------0 v2srW4 http://blog.numino.net/ Surplus_Point int 4 1 --------0 f075bj http://blog.numino.net/ Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05 dzmjmX http://blog.numino.net/ Increase_Days datetime 8 1 --------2005-6-6 23:00:05 Zp0tnD http://blog.numino.net/ 7、WEB_ZS 88YoL3 http://blog.numino.net/ 列名 类型 长 是否空 说明 dn1sgG http://blog.numino.net/ ID bigint 8 0 xACYqA http://blog.numino.net/ ACC char 10 1 IrRgnx http://blog.numino.net/ NAME char 10 1 kdcql3 http://blog.numino.net/ ZSTIME datetime 8 1 mvkEq5 http://blog.numino.net/ ZSCLEVEL smallint 2 1 FuMZ99 http://blog.numino.net/ ZSCS smallint 2 0 02sGoL http://blog.numino.net/ CZCS smallint 2 0 qPYQnk http://blog.numino.net/ CZTIME datetime 8 0 J073fL http://blog.numino.net/ ZJZSCS smallint 2 0 5aduSU http://blog.numino.net/ GJZSCS smallint 2 0 99YfNq http://blog.numino.net/ CJZSCS smallint 2 0 L177rh http://blog.numino.net/ BSCS smallint 2 0 D3KCzQ http://blog.numino.net/ BSTIME datetime 8 0 D9lyU3 http://blog.numino.net/ LEVELUPPOINT int 4 0 gGLOS7 http://blog.numino.net/ GDDS int 4 0
|
|