奇迹muonline数据库基础库分析 |
一、表的组成: baj1mD http://blog.numino.net/ 1、AccountCharacter Baeha1 http://blog.numino.net/ 用来存放帐号的角色。 nAa8Qp http://blog.numino.net/ 2、Character t0KO6q http://blog.numino.net/ 用来存放每个角色的详细数据。 A94U5i http://blog.numino.net/ 3、MEMB_INFO DddLi8 http://blog.numino.net/ 帐号信息 mJj9zC http://blog.numino.net/ 4、MEMB_STAT TAu4md http://blog.numino.net/ 帐号状态 Qx887i http://blog.numino.net/ 5、warehouse JGMq3U http://blog.numino.net/ 仓库 MDpuC9 http://blog.numino.net/ 6、VI_CURR_INFO 24S6ga http://blog.numino.net/ 帐号费用 yQqIEW http://blog.numino.net/ 7、WEB_ZS CVsnFp http://blog.numino.net/ PL 网站的转生数据 w99KH4 http://blog.numino.net/ 二、各表说明 VgRl62 http://blog.numino.net/ 1、AccountCharacter 表 Ar12o1 http://blog.numino.net/ 列名 类型 长 是否空 说明 24x47J http://blog.numino.net/ Number int 4 0 自动增加的序数 6fe8eN http://blog.numino.net/ Id varchar 10 0 帐号 naO10s http://blog.numino.net/ GameID1 varchar 10 1 角色1 5Couo4 http://blog.numino.net/ GameID2 varchar 10 1 角色2 U91tTR http://blog.numino.net/ GameID3 varchar 10 1 0cKZfp http://blog.numino.net/ GameID4 varchar 10 1 i676C2 http://blog.numino.net/ GameID5 varchar 10 1 hyPeZB http://blog.numino.net/ GameIDC varchar 10 1 w6niUi http://blog.numino.net/ 2、Character 表 SL3KPh http://blog.numino.net/ 列名 类型 长 是否空 说明 1JI8fC http://blog.numino.net/ AccountID varchar 10 0 --------帐号 99BAHX http://blog.numino.net/ Name nvarchar 10 0 --------角色名 am9Jhq http://blog.numino.net/ cLevel smallint 2 1 --------等级 XRvzqJ http://blog.numino.net/ LevelUpPoint int 4 1 --------升级点 W3qc6E http://blog.numino.net/ Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导 i5735G http://blog.numino.net/ Experience int 4 1 --------经验 TbhMtG http://blog.numino.net/ Strength smallint 2 1 --------力量 w2zLm9 http://blog.numino.net/ Dexterity smallint 2 1 --------敏捷 O1OpYk http://blog.numino.net/ Vitality smallint 2 1 --------体力 3BwonF http://blog.numino.net/ Energy smallint 2 1 --------智力 wKeQ65 http://blog.numino.net/ Inventory varbinary 760 1 --------身上仓库 390H7y http://blog.numino.net/ MagicList varbinary 60 1 --------技能 8B8o8x http://blog.numino.net/ Money int 4 1 --------钱 IEkEv1 http://blog.numino.net/ Life real 4 1 -------- XBf4Vh http://blog.numino.net/ MaxLife real 4 1 -------- M6Z0c3 http://blog.numino.net/ Mana real 4 1 -------- T0jI4d http://blog.numino.net/ MaxMana real 4 1 -------- jYtuFT http://blog.numino.net/ MapNumber smallint 2 1 --------所在地图号 vBWJh8 http://blog.numino.net/ MapPosX smallint 2 1 --------X坐标 Gltaro http://blog.numino.net/ MapPosY smallint 2 1 --------Y坐标 IYEdpb http://blog.numino.net/ MapDir tinyint 1 1 -------- mDs991 http://blog.numino.net/ PkCount int 4 1 -------- 71Y7i6 http://blog.numino.net/ PkLevel int 4 1 --------PK状态:0大侠 1英雄 2好人 3普 4无赖 5魔头 232k5s http://blog.numino.net/ PkTime int 4 1 t466zp http://blog.numino.net/ MDate smalldatetime 4 1 a4LK5L http://blog.numino.net/ LDate smalldatetime 4 1 wXoUsa http://blog.numino.net/ CtlCode tinyint 1 1 --------0 普通角色 8GM 15yTJl http://blog.numino.net/ DbVersion tinyint 1 1 ANkid7 http://blog.numino.net/ Quest varbinary 50 1 Kg5Fk0 http://blog.numino.net/ LINZB bit 1 0 QNNJTL http://blog.numino.net/ XDTIME datetime 8 0 AmeASy http://blog.numino.net/ STOPINFO nvarchar 100 1 R0ml9u http://blog.numino.net/ STOPTIME datetime 8 0 nj9fLk http://blog.numino.net/ zs_count int 4 1 wOTIW3 http://blog.numino.net/ zs_point int 4 1 b61tSV http://blog.numino.net/ bs_count int 4 1 Vy5f53 http://blog.numino.net/ bs_point int 4 1 40VYlF http://blog.numino.net/ shiji smalldatetime 4 1 d91wym http://blog.numino.net/ banl nvarchar 10 1 85tDTC http://blog.numino.net/ lv_time datetime 8 1 RwxyNf http://blog.numino.net/ ex_ok int 4 1 oj7auT http://blog.numino.net/ ex_total int 4 1 xmyRbA http://blog.numino.net/ rb_count int 4 1 aW2Aq4 http://blog.numino.net/ rb_time datetime 8 1 jEBDBf http://blog.numino.net/ pz_time datetime 8 1 zlM8By http://blog.numino.net/ 3、MEMB_INFO 15MQ6c http://blog.numino.net/ 列名 类型 长 是否空 说明 b784VR http://blog.numino.net/ memb_guid int 4 0 -------- 1(系统自动生成) 6H50Bw http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 crJyXc http://blog.numino.net/ memb__pwd nvarchar 10 0 --------密码 k3v75e http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 (1) 8rv3cV http://blog.numino.net/ sno__numb nvarchar 18 0 --------1 m9z4H5 http://blog.numino.net/ post_code nvarchar 6 1 --------1234 8sq5yg http://blog.numino.net/ addr_info nvarchar 50 1 --------XXXXXXXXXXX WG0h5U http://blog.numino.net/ addr_deta nvarchar 50 1 --------XXXXXXXXXXX bY7ZsI http://blog.numino.net/ tel__numb nvarchar 20 1 --------XXXXXXXXXXX O36h6r http://blog.numino.net/ phon_numb nvarchar 15 1 --------XXXXXXXXXXX 4xnUQ4 http://blog.numino.net/ mail_addr nvarchar 50 1 --------邮件地址 954sU2 http://blog.numino.net/ fpas_ques nvarchar 50 1 --------密码提示问题 162gTb http://blog.numino.net/ fpas_answ nvarchar 50 1 --------答案 53yh65 http://blog.numino.net/ job__code nvarchar 2 1 --------XXXXXXXXXXXX 3V5DC9 http://blog.numino.net/ appl_days smalldatetime 4 1 --------2005-6-6 23:00:00 fu8a8L http://blog.numino.net/ modi_days smalldatetime 4 1 --------2005-6-6 23:00:00 4n6LiV http://blog.numino.net/ out__days smalldatetime 4 1 --------2005-6-6 23:00:00 mabCj5 http://blog.numino.net/ true_days smalldatetime 4 1 --------2005-6-6 23:00:00 3zb22k http://blog.numino.net/ mail_chek nvarchar 1 1 -------- 0 或 1 3mZDxS http://blog.numino.net/ bloc_code nvarchar 1 0 --------0 正常 >0封号 JB0xJy http://blog.numino.net/ ctl1_code nvarchar 1 0 --------0 CJ4hzk http://blog.numino.net/ LINZBSJ datetime 8 1 --------NULL Z7y5R4 http://blog.numino.net/ LGONGZHISJ datetime 8 1 --------NULL 2fM98u http://blog.numino.net/ STOPINFO nvarchar 100 1 --------NULL 1JgO2x http://blog.numino.net/ STOPTIME datetime 8 1 --------NULL h3qP32 http://blog.numino.net/ QX char 1 1 --------B lW5OpX http://blog.numino.net/ JF int 4 0 --------0 N609gO http://blog.numino.net/ huiy int 4 1 --------0 atJPa6 http://blog.numino.net/ hysj smalldatetime 4 1 --------NULL 5t3Bvq http://blog.numino.net/ lqsj smalldatetime 4 1 --------NULL aJ4Dnm http://blog.numino.net/ FDB int 4 1 --------0 9gGQCr http://blog.numino.net/ vip tinyint 1 1 --------0 Po7QWX http://blog.numino.net/ Expired datetime 8 1 --------2005-6-6 23:00:05 t6J46x http://blog.numino.net/ 4、MEMB_STAT t9r3w0 http://blog.numino.net/ 列名 类型 长 是否空 说明 QdR9S4 http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 Gq5K9f http://blog.numino.net/ ConnectStat tinyint 1 1 --------是否在线 0:不在线 yFvQNQ http://blog.numino.net/ ServerName nvarchar 20 1 --------连接的线名 4XhMSQ http://blog.numino.net/ IP nvarchar 15 1 --------IP地址 Dge6xK http://blog.numino.net/ ConnectTM smalldatetime 4 1 --------上线日期、时间 ojthH4 http://blog.numino.net/ DisConnectTM smalldatetime 4 1 --------下线日期、时间 1SE6g4 http://blog.numino.net/ 5、warehouse 12WaIu http://blog.numino.net/ 列名 类型 长 是否空 说明 F82zp3 http://blog.numino.net/ AccountID varchar 10 0 --------帐号 302FCp http://blog.numino.net/ Items varbinary 1200 1 --------仓库物品 dQm9zR http://blog.numino.net/ Money int 4 1 --------钱 Z29Cye http://blog.numino.net/ EndUseDate smalldatetime 4 1 --------最后使用日期、时间 ZxcK4N http://blog.numino.net/ DbVersion tinyint 1 1 --------1 heIery http://blog.numino.net/ pw smallint 2 1 --------密码 0 PjC316 http://blog.numino.net/ lastpw smallint 2 0 --------最后密码 0 lQ4hKn http://blog.numino.net/ ExtCKNum int 4 0 --------0 Tfu7GC http://blog.numino.net/ NeedExtCK int 4 0 --------0 a79VlE http://blog.numino.net/ 6、VI_CURR_INFO ZPBh4G http://blog.numino.net/ 列名 类型 长 是否空 说明 IZMwRf http://blog.numino.net/ ends_days nvarchar 8 1 --------20081111 3v5WtS http://blog.numino.net/ chek_code nvarchar 1 0 --------1 5IlVQN http://blog.numino.net/ used_time int 4 1 --------1234 LG7J7q http://blog.numino.net/ memb___id nvarchar 10 0 --------帐号 K11LfR http://blog.numino.net/ memb_name nvarchar 10 0 --------昵称 Dfd86w http://blog.numino.net/ memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应 BgeDIY http://blog.numino.net/ sno__numb nvarchar 18 0 --------123456 LV3x5C http://blog.numino.net/ Bill_Section int 4 1 --------6 2A4au2 http://blog.numino.net/ Bill_Value int 4 1 --------3 uB4Je0 http://blog.numino.net/ Bill_Hour int 4 1 --------0 TZPd0m http://blog.numino.net/ Surplus_Point int 4 1 --------0 sI67D9 http://blog.numino.net/ Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05 X7uJ4X http://blog.numino.net/ Increase_Days datetime 8 1 --------2005-6-6 23:00:05 VGT1gc http://blog.numino.net/ 7、WEB_ZS 9e0B2e http://blog.numino.net/ 列名 类型 长 是否空 说明 7mIwZc http://blog.numino.net/ ID bigint 8 0 k7lkxl http://blog.numino.net/ ACC char 10 1 9Gw60h http://blog.numino.net/ NAME char 10 1 D6427t http://blog.numino.net/ ZSTIME datetime 8 1 X3nazr http://blog.numino.net/ ZSCLEVEL smallint 2 1 k49A65 http://blog.numino.net/ ZSCS smallint 2 0 cG17W7 http://blog.numino.net/ CZCS smallint 2 0 t11m4t http://blog.numino.net/ CZTIME datetime 8 0 o5PTb3 http://blog.numino.net/ ZJZSCS smallint 2 0 3jYNKX http://blog.numino.net/ GJZSCS smallint 2 0 Ekl4Lr http://blog.numino.net/ CJZSCS smallint 2 0 fBC22Y http://blog.numino.net/ BSCS smallint 2 0 pbEVPz http://blog.numino.net/ BSTIME datetime 8 0 yRDnRF http://blog.numino.net/ LEVELUPPOINT int 4 0 cAo934 http://blog.numino.net/ GDDS int 4 0
|
|