奇迹muonline数据库基础库分析 |
一、表的组成: S1IKd4 http://blog.numino.net/ 1、AccountCharacter MrV8OP http://blog.numino.net/ 用来存放帐号的角色。 vaNaGp http://blog.numino.net/ 2、Character CTPVBt http://blog.numino.net/ 用来存放每个角色的详细数据。 1545nt http://blog.numino.net/ 3、MEMB_INFO xCN1ZR http://blog.numino.net/ 帐号信息 3O387o http://blog.numino.net/ 4、MEMB_STAT qTgyKo http://blog.numino.net/ 帐号状态 rII6ui http://blog.numino.net/ 5、warehouse inXUUZ http://blog.numino.net/ 仓库 nhq9Ic http://blog.numino.net/ 6、VI_CURR_INFO 8jBU47 http://blog.numino.net/ 帐号费用 Af0ovb http://blog.numino.net/ 7、WEB_ZS V6MG75 http://blog.numino.net/ PL 网站的转生数据 4WjV6h http://blog.numino.net/ 二、各表说明 GF6Fu8 http://blog.numino.net/ 1、AccountCharacter 表 HJr3tz http://blog.numino.net/ 列名 类型 长 是否空 说明 WJrk6V http://blog.numino.net/ Number int 4 0 自动增加的序数 4192Mg http://blog.numino.net/ Id varchar 10 0 帐号 0Ml5un http://blog.numino.net/ GameID1 varchar 10 1 角色1 yMzK3a http://blog.numino.net/ GameID2 varchar 10 1 角色2 QWJucC http://blog.numino.net/ GameID3 varchar 10 1 vX8K9F http://blog.numino.net/ GameID4 varchar 10 1 6PPhBg http://blog.numino.net/ GameID5 varchar 10 1 dpYEk5 http://blog.numino.net/ GameIDC varchar 10 1 wMhZ33 http://blog.numino.net/ 2、Character 表 2ab5Tf http://blog.numino.net/ 列名 类型 长 是否空 说明 SHoo5p http://blog.numino.net/ AccountID varchar 10 0 --------帐号 Q1N1RC http://blog.numino.net/ Name nvarchar 10 0 --------角色名 yxC99B http://blog.numino.net/ cLevel smallint 2 1 --------等级 9qxawG http://blog.numino.net/ LevelUpPoint int 4 1 --------升级点 je5Tn1 http://blog.numino.net/ Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导 OU1f35 http://blog.numino.net/ Experience int 4 1 --------经验 EGrIZd http://blog.numino.net/ Strength smallint 2 1 --------力量 Zw93On http://blog.numino.net/ Dexterity smallint 2 1 --------敏捷 b81o4r http://blog.numino.net/ Vitality smallint 2 1 --------体力 lvF8qy http://blog.numino.net/ Energy smallint 2 1 --------智力 VRYC0t http://blog.numino.net/ Inventory varbinary 760 1 --------身上仓库 AP5S4m http://blog.numino.net/ MagicList varbinary 60 1 --------技能 JKRO4w http://blog.numino.net/ Money int 4 1 --------钱 MjhzAz http://blog.numino.net/ Life real 4 1 -------- CZF3vQ http://blog.numino.net/ MaxLife real 4 1 -------- V8a86Q http://blog.numino.net/ Mana real 4 1 -------- UlK4aX http://blog.numino.net/ MaxMana real 4 1 -------- CQ792P http://blog.numino.net/ MapNumber smallint 2 1 --------所在地图号 1Z7dUV http://blog.numino.net/ MapPosX smallint 2 1 --------X坐标 3Ww63h http://blog.numino.net/ MapPosY smallint 2 1 --------Y坐标 O4GN3I http://blog.numino.net/ MapDir tinyint 1 1 -------- zLvYlk http://blog.numino.net/ PkCount int 4 1 -------- eKWffh http://blog.numino.net/ PkLevel int 4 1 --------PK状态:0大侠 1英雄 2好人 3普 4无赖 5魔头 LO8I32 http://blog.numino.net/ PkTime int 4 1 7L49Ox http://blog.numino.net/ MDate smalldatetime 4 1 sZBJSR http://blog.numino.net/ LDate smalldatetime 4 1 u1hl2t http://blog.numino.net/ CtlCode tinyint 1 1 --------0 普通角色 8GM 5byN5C http://blog.numino.net/ DbVersion tinyint 1 1 p8Yo44 http://blog.numino.net/ Quest varbinary 50 1 9V03yu http://blog.numino.net/ LINZB bit 1 0 CMJT2n http://blog.numino.net/ XDTIME datetime 8 0 0uLQIK http://blog.numino.net/ STOPINFO nvarchar 100 1 w3rXmq http://blog.numino.net/ STOPTIME datetime 8 0 2TQBw6 http://blog.numino.net/ zs_count int 4 1 zsjfsP http://blog.numino.net/ zs_point int 4 1 1tq2GZ http://blog.numino.net/ bs_count int 4 1 1Hq4dJ http://blog.numino.net/ bs_point int 4 1 0GFsIU http://blog.numino.net/ shiji smalldatetime 4 1 28rLgV http://blog.numino.net/ banl nvarchar 10 1 yr39Q4 http://blog.numino.net/ lv_time datetime 8 1 AvG2z5 http://blog.numino.net/ ex_ok int 4 1 TD2gAp http://blog.numino.net/ ex_total int 4 1 w2eR6y http://blog.numino.net/ rb_count int 4 1 TY7xMF http://blog.numino.net/ rb_time datetime 8 1 tCZzCP http://blog.numino.net/ pz_time datetime 8 1 suUv0Z http://blog.numino.net/ 3、MEMB_INFO Bq0TD2 http://blog.numino.net/ 列名 类型 长 是否空 说明 z1AfDV http://blog.numino.net/ memb_guid int 4 0 -------- 1(系统自动生成) dxFB9N http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 OrPCDh http://blog.numino.net/ memb__pwd nvarchar 10 0 --------密码 Z11yCX http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 (1) 8sT1QK http://blog.numino.net/ sno__numb nvarchar 18 0 --------1 xTsYfw http://blog.numino.net/ post_code nvarchar 6 1 --------1234 SGG5U8 http://blog.numino.net/ addr_info nvarchar 50 1 --------XXXXXXXXXXX 7hwhqI http://blog.numino.net/ addr_deta nvarchar 50 1 --------XXXXXXXXXXX 2zJyl2 http://blog.numino.net/ tel__numb nvarchar 20 1 --------XXXXXXXXXXX Tzzsp0 http://blog.numino.net/ phon_numb nvarchar 15 1 --------XXXXXXXXXXX tV14po http://blog.numino.net/ mail_addr nvarchar 50 1 --------邮件地址 0627A7 http://blog.numino.net/ fpas_ques nvarchar 50 1 --------密码提示问题 JJnqEy http://blog.numino.net/ fpas_answ nvarchar 50 1 --------答案 t8ULel http://blog.numino.net/ job__code nvarchar 2 1 --------XXXXXXXXXXXX uzHmm1 http://blog.numino.net/ appl_days smalldatetime 4 1 --------2005-6-6 23:00:00 a1on3S http://blog.numino.net/ modi_days smalldatetime 4 1 --------2005-6-6 23:00:00 KwgLzX http://blog.numino.net/ out__days smalldatetime 4 1 --------2005-6-6 23:00:00 oqRQrC http://blog.numino.net/ true_days smalldatetime 4 1 --------2005-6-6 23:00:00 wipi7p http://blog.numino.net/ mail_chek nvarchar 1 1 -------- 0 或 1 oQqv3Q http://blog.numino.net/ bloc_code nvarchar 1 0 --------0 正常 >0封号 pzLPZx http://blog.numino.net/ ctl1_code nvarchar 1 0 --------0 PmeqYS http://blog.numino.net/ LINZBSJ datetime 8 1 --------NULL SaVPEv http://blog.numino.net/ LGONGZHISJ datetime 8 1 --------NULL 4r6fCK http://blog.numino.net/ STOPINFO nvarchar 100 1 --------NULL 2x20o0 http://blog.numino.net/ STOPTIME datetime 8 1 --------NULL gAoDE2 http://blog.numino.net/ QX char 1 1 --------B F4VBUv http://blog.numino.net/ JF int 4 0 --------0 o4Nd3v http://blog.numino.net/ huiy int 4 1 --------0 8dCr4C http://blog.numino.net/ hysj smalldatetime 4 1 --------NULL fxI51F http://blog.numino.net/ lqsj smalldatetime 4 1 --------NULL kYPG46 http://blog.numino.net/ FDB int 4 1 --------0 WBB3pS http://blog.numino.net/ vip tinyint 1 1 --------0 Z7F29e http://blog.numino.net/ Expired datetime 8 1 --------2005-6-6 23:00:05 1Uu1LU http://blog.numino.net/ 4、MEMB_STAT ffuD6m http://blog.numino.net/ 列名 类型 长 是否空 说明 vme7aK http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 spvZGK http://blog.numino.net/ ConnectStat tinyint 1 1 --------是否在线 0:不在线 uz00wP http://blog.numino.net/ ServerName nvarchar 20 1 --------连接的线名 0yhtfU http://blog.numino.net/ IP nvarchar 15 1 --------IP地址 43FUov http://blog.numino.net/ ConnectTM smalldatetime 4 1 --------上线日期、时间 kuaDiS http://blog.numino.net/ DisConnectTM smalldatetime 4 1 --------下线日期、时间 iX07H9 http://blog.numino.net/ 5、warehouse MsYn0A http://blog.numino.net/ 列名 类型 长 是否空 说明 kv1ht3 http://blog.numino.net/ AccountID varchar 10 0 --------帐号 LIJKUt http://blog.numino.net/ Items varbinary 1200 1 --------仓库物品 s4uNG9 http://blog.numino.net/ Money int 4 1 --------钱 1eIU5L http://blog.numino.net/ EndUseDate smalldatetime 4 1 --------最后使用日期、时间 JCpYo4 http://blog.numino.net/ DbVersion tinyint 1 1 --------1 obb7TL http://blog.numino.net/ pw smallint 2 1 --------密码 0 drtEY4 http://blog.numino.net/ lastpw smallint 2 0 --------最后密码 0 JG3myU http://blog.numino.net/ ExtCKNum int 4 0 --------0 ktBwyB http://blog.numino.net/ NeedExtCK int 4 0 --------0 l0koOs http://blog.numino.net/ 6、VI_CURR_INFO YdEOLW http://blog.numino.net/ 列名 类型 长 是否空 说明 724ylb http://blog.numino.net/ ends_days nvarchar 8 1 --------20081111 88z4Ss http://blog.numino.net/ chek_code nvarchar 1 0 --------1 40Bg4E http://blog.numino.net/ used_time int 4 1 --------1234 fRIoT3 http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 CK1Q0m http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 VQDA5d http://blog.numino.net/ memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应 wO2G4E http://blog.numino.net/ sno__numb nvarchar 18 0 --------123456 Soc5nK http://blog.numino.net/ Bill_Section int 4 1 --------6 427T3W http://blog.numino.net/ Bill_Value int 4 1 --------3 lmsFUG http://blog.numino.net/ Bill_Hour int 4 1 --------0 Uaj7oN http://blog.numino.net/ Surplus_Point int 4 1 --------0 FCfEBr http://blog.numino.net/ Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05 jm7l7P http://blog.numino.net/ Increase_Days datetime 8 1 --------2005-6-6 23:00:05 Ux73QU http://blog.numino.net/ 7、WEB_ZS wwCpcU http://blog.numino.net/ 列名 类型 长 是否空 说明 6vUsLF http://blog.numino.net/ ID bigint 8 0 sgOo90 http://blog.numino.net/ ACC char 10 1 o08grL http://blog.numino.net/ NAME char 10 1 5kg8bj http://blog.numino.net/ ZSTIME datetime 8 1 YhTNqk http://blog.numino.net/ ZSCLEVEL smallint 2 1 8UICTV http://blog.numino.net/ ZSCS smallint 2 0 PPiE7O http://blog.numino.net/ CZCS smallint 2 0 c055Nt http://blog.numino.net/ CZTIME datetime 8 0 2Q6t0B http://blog.numino.net/ ZJZSCS smallint 2 0 5TrM0v http://blog.numino.net/ GJZSCS smallint 2 0 nnspwa http://blog.numino.net/ CJZSCS smallint 2 0 GKqwl4 http://blog.numino.net/ BSCS smallint 2 0 Pk1VoC http://blog.numino.net/ BSTIME datetime 8 0 zO22yB http://blog.numino.net/ LEVELUPPOINT int 4 0 N9VFND http://blog.numino.net/ GDDS int 4 0
|
|