奇迹muonline数据库基础库分析 |
一、表的组成: aM4R2d http://blog.numino.net/ 1、AccountCharacter 6SsA1i http://blog.numino.net/ 用来存放帐号的角色。 1fTkrF http://blog.numino.net/ 2、Character J2I4Ld http://blog.numino.net/ 用来存放每个角色的详细数据。 3ZsM07 http://blog.numino.net/ 3、MEMB_INFO bf418A http://blog.numino.net/ 帐号信息 c1QBG3 http://blog.numino.net/ 4、MEMB_STAT rCIM0R http://blog.numino.net/ 帐号状态 bp5BwX http://blog.numino.net/ 5、warehouse u2Hauj http://blog.numino.net/ 仓库 yk9TjJ http://blog.numino.net/ 6、VI_CURR_INFO 30d2IL http://blog.numino.net/ 帐号费用 283mzi http://blog.numino.net/ 7、WEB_ZS 7th1JV http://blog.numino.net/ PL 网站的转生数据 iM3g0V http://blog.numino.net/ 二、各表说明 8zFGog http://blog.numino.net/ 1、AccountCharacter 表 s42oEK http://blog.numino.net/ 列名 类型 长 是否空 说明 14a0bt http://blog.numino.net/ Number int 4 0 自动增加的序数 HeVV4A http://blog.numino.net/ Id varchar 10 0 帐号 o0w7mZ http://blog.numino.net/ GameID1 varchar 10 1 角色1 rpfqo6 http://blog.numino.net/ GameID2 varchar 10 1 角色2 xIX7Q1 http://blog.numino.net/ GameID3 varchar 10 1 i7Yku0 http://blog.numino.net/ GameID4 varchar 10 1 F2k0i3 http://blog.numino.net/ GameID5 varchar 10 1 480231 http://blog.numino.net/ GameIDC varchar 10 1 q3vwSy http://blog.numino.net/ 2、Character 表 WS94O8 http://blog.numino.net/ 列名 类型 长 是否空 说明 Ei8lJ0 http://blog.numino.net/ AccountID varchar 10 0 --------帐号 dAPXoz http://blog.numino.net/ Name nvarchar 10 0 --------角色名 rhl849 http://blog.numino.net/ cLevel smallint 2 1 --------等级 JoNZ6T http://blog.numino.net/ LevelUpPoint int 4 1 --------升级点 za9j2Z http://blog.numino.net/ Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导 p5752K http://blog.numino.net/ Experience int 4 1 --------经验 RtZa5C http://blog.numino.net/ Strength smallint 2 1 --------力量 l3BaUj http://blog.numino.net/ Dexterity smallint 2 1 --------敏捷 S9FBk6 http://blog.numino.net/ Vitality smallint 2 1 --------体力 e6gncF http://blog.numino.net/ Energy smallint 2 1 --------智力 pvqDGT http://blog.numino.net/ Inventory varbinary 760 1 --------身上仓库 QJ3CO0 http://blog.numino.net/ MagicList varbinary 60 1 --------技能 1WpySl http://blog.numino.net/ Money int 4 1 --------钱 916C8S http://blog.numino.net/ Life real 4 1 -------- CE72iG http://blog.numino.net/ MaxLife real 4 1 -------- WY1AQD http://blog.numino.net/ Mana real 4 1 -------- QFq7W2 http://blog.numino.net/ MaxMana real 4 1 -------- 5ACVwn http://blog.numino.net/ MapNumber smallint 2 1 --------所在地图号 uYb9Dd http://blog.numino.net/ MapPosX smallint 2 1 --------X坐标 nzDaeB http://blog.numino.net/ MapPosY smallint 2 1 --------Y坐标 kBXLaa http://blog.numino.net/ MapDir tinyint 1 1 -------- jA9KxU http://blog.numino.net/ PkCount int 4 1 -------- vciLY3 http://blog.numino.net/ PkLevel int 4 1 --------PK状态:0大侠 1英雄 2好人 3普 4无赖 5魔头 oagBwb http://blog.numino.net/ PkTime int 4 1 svm3wK http://blog.numino.net/ MDate smalldatetime 4 1 7qMAIK http://blog.numino.net/ LDate smalldatetime 4 1 8exTV1 http://blog.numino.net/ CtlCode tinyint 1 1 --------0 普通角色 8GM CaGK83 http://blog.numino.net/ DbVersion tinyint 1 1 u7sPbj http://blog.numino.net/ Quest varbinary 50 1 Hz5sT2 http://blog.numino.net/ LINZB bit 1 0 ioG66k http://blog.numino.net/ XDTIME datetime 8 0 iZ4qdE http://blog.numino.net/ STOPINFO nvarchar 100 1 JEMajp http://blog.numino.net/ STOPTIME datetime 8 0 6EZebw http://blog.numino.net/ zs_count int 4 1 B2U25o http://blog.numino.net/ zs_point int 4 1 lDyLwY http://blog.numino.net/ bs_count int 4 1 p45S8z http://blog.numino.net/ bs_point int 4 1 042i48 http://blog.numino.net/ shiji smalldatetime 4 1 QOIVTm http://blog.numino.net/ banl nvarchar 10 1 qQ8iDK http://blog.numino.net/ lv_time datetime 8 1 hY0UPS http://blog.numino.net/ ex_ok int 4 1 5X1h21 http://blog.numino.net/ ex_total int 4 1 QD4d4z http://blog.numino.net/ rb_count int 4 1 RGkGqn http://blog.numino.net/ rb_time datetime 8 1 JAbnS8 http://blog.numino.net/ pz_time datetime 8 1 6HoY6f http://blog.numino.net/ 3、MEMB_INFO CH91OF http://blog.numino.net/ 列名 类型 长 是否空 说明 22z5oE http://blog.numino.net/ memb_guid int 4 0 -------- 1(系统自动生成) ua78ns http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 85DgsC http://blog.numino.net/ memb__pwd nvarchar 10 0 --------密码 4oneoy http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 (1) 219Gn6 http://blog.numino.net/ sno__numb nvarchar 18 0 --------1 LOKNLK http://blog.numino.net/ post_code nvarchar 6 1 --------1234 Cbmu6Q http://blog.numino.net/ addr_info nvarchar 50 1 --------XXXXXXXXXXX g5FTJ8 http://blog.numino.net/ addr_deta nvarchar 50 1 --------XXXXXXXXXXX 4c9QgD http://blog.numino.net/ tel__numb nvarchar 20 1 --------XXXXXXXXXXX hluS6c http://blog.numino.net/ phon_numb nvarchar 15 1 --------XXXXXXXXXXX XBU9Kl http://blog.numino.net/ mail_addr nvarchar 50 1 --------邮件地址 REsRo2 http://blog.numino.net/ fpas_ques nvarchar 50 1 --------密码提示问题 6h068w http://blog.numino.net/ fpas_answ nvarchar 50 1 --------答案 pih1PI http://blog.numino.net/ job__code nvarchar 2 1 --------XXXXXXXXXXXX 5lty8u http://blog.numino.net/ appl_days smalldatetime 4 1 --------2005-6-6 23:00:00 Vh0g9V http://blog.numino.net/ modi_days smalldatetime 4 1 --------2005-6-6 23:00:00 IIhcKa http://blog.numino.net/ out__days smalldatetime 4 1 --------2005-6-6 23:00:00 0wNciZ http://blog.numino.net/ true_days smalldatetime 4 1 --------2005-6-6 23:00:00 s2FQ23 http://blog.numino.net/ mail_chek nvarchar 1 1 -------- 0 或 1 Zl1Oap http://blog.numino.net/ bloc_code nvarchar 1 0 --------0 正常 >0封号 j4M15z http://blog.numino.net/ ctl1_code nvarchar 1 0 --------0 DH00QG http://blog.numino.net/ LINZBSJ datetime 8 1 --------NULL KDDZQ3 http://blog.numino.net/ LGONGZHISJ datetime 8 1 --------NULL 7Gnx03 http://blog.numino.net/ STOPINFO nvarchar 100 1 --------NULL pktQCT http://blog.numino.net/ STOPTIME datetime 8 1 --------NULL kO7RdA http://blog.numino.net/ QX char 1 1 --------B n6osYR http://blog.numino.net/ JF int 4 0 --------0 8FpOGI http://blog.numino.net/ huiy int 4 1 --------0 6Z1FrO http://blog.numino.net/ hysj smalldatetime 4 1 --------NULL ReN8XH http://blog.numino.net/ lqsj smalldatetime 4 1 --------NULL a2EI2Z http://blog.numino.net/ FDB int 4 1 --------0 Rq8db1 http://blog.numino.net/ vip tinyint 1 1 --------0 4I1fFu http://blog.numino.net/ Expired datetime 8 1 --------2005-6-6 23:00:05 a2W6x9 http://blog.numino.net/ 4、MEMB_STAT mj4IUi http://blog.numino.net/ 列名 类型 长 是否空 说明 9k1HZI http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 onNgh1 http://blog.numino.net/ ConnectStat tinyint 1 1 --------是否在线 0:不在线 a5svX6 http://blog.numino.net/ ServerName nvarchar 20 1 --------连接的线名 tb0Qrx http://blog.numino.net/ IP nvarchar 15 1 --------IP地址 2PU008 http://blog.numino.net/ ConnectTM smalldatetime 4 1 --------上线日期、时间 PH9iED http://blog.numino.net/ DisConnectTM smalldatetime 4 1 --------下线日期、时间 M4iPXc http://blog.numino.net/ 5、warehouse 1jJ51H http://blog.numino.net/ 列名 类型 长 是否空 说明 1NkCSL http://blog.numino.net/ AccountID varchar 10 0 --------帐号 s1KxcJ http://blog.numino.net/ Items varbinary 1200 1 --------仓库物品 8eWB7k http://blog.numino.net/ Money int 4 1 --------钱 uzBusN http://blog.numino.net/ EndUseDate smalldatetime 4 1 --------最后使用日期、时间 6KoMwI http://blog.numino.net/ DbVersion tinyint 1 1 --------1 aVy3y8 http://blog.numino.net/ pw smallint 2 1 --------密码 0 9oGT5b http://blog.numino.net/ lastpw smallint 2 0 --------最后密码 0 702GIK http://blog.numino.net/ ExtCKNum int 4 0 --------0 q2ohLv http://blog.numino.net/ NeedExtCK int 4 0 --------0 Dy6z74 http://blog.numino.net/ 6、VI_CURR_INFO OQ2S4v http://blog.numino.net/ 列名 类型 长 是否空 说明 tyiJ0H http://blog.numino.net/ ends_days nvarchar 8 1 --------20081111 80dXS3 http://blog.numino.net/ chek_code nvarchar 1 0 --------1 l66S6e http://blog.numino.net/ used_time int 4 1 --------1234 8trj0v http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 TwP5F6 http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 xp2HPP http://blog.numino.net/ memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应 38S0OP http://blog.numino.net/ sno__numb nvarchar 18 0 --------123456 bc9RM4 http://blog.numino.net/ Bill_Section int 4 1 --------6 MAC0TI http://blog.numino.net/ Bill_Value int 4 1 --------3 z33GsK http://blog.numino.net/ Bill_Hour int 4 1 --------0 uWQ0yZ http://blog.numino.net/ Surplus_Point int 4 1 --------0 2AUZsx http://blog.numino.net/ Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05 z9D1GN http://blog.numino.net/ Increase_Days datetime 8 1 --------2005-6-6 23:00:05 Ad8abG http://blog.numino.net/ 7、WEB_ZS r2QvIq http://blog.numino.net/ 列名 类型 长 是否空 说明 w491QF http://blog.numino.net/ ID bigint 8 0 7C6wu9 http://blog.numino.net/ ACC char 10 1 nu5sBK http://blog.numino.net/ NAME char 10 1 mYrPZ1 http://blog.numino.net/ ZSTIME datetime 8 1 95ardv http://blog.numino.net/ ZSCLEVEL smallint 2 1 Kkx3wH http://blog.numino.net/ ZSCS smallint 2 0 N7O4up http://blog.numino.net/ CZCS smallint 2 0 t6xS3P http://blog.numino.net/ CZTIME datetime 8 0 R92h0A http://blog.numino.net/ ZJZSCS smallint 2 0 62j92W http://blog.numino.net/ GJZSCS smallint 2 0 JoqVl0 http://blog.numino.net/ CJZSCS smallint 2 0 jg7PDQ http://blog.numino.net/ BSCS smallint 2 0 GZx4v5 http://blog.numino.net/ BSTIME datetime 8 0 HYcL4b http://blog.numino.net/ LEVELUPPOINT int 4 0 H3CTU6 http://blog.numino.net/ GDDS int 4 0
|
|