| 文章来源：魔域私服｜新开魔域私服｜最新魔域私服下载 发布时间：2008-5-31 8:15:10 |
##############################################################
#itemtype表针对物品的字段转义：
#req_level：人物等级
#attack_max：貌似是BB原始成长率
#attack_min：貌似是BB升级到下一级需要的经验值
##############################################################
#
#req_weaponskill字段无用，改名为level：物品等级
#
##############################################################
#
#Tablestructurefortablecq_friend
#
CREATETABLEcq_friend(
idint(4)unsignedzerofillNOTNULLauto_increment,
useridint(4)unsignedzerofillNOTNULLdefault0000,
friendint(4)unsignedzerofillNOTNULLdefault0,
friendnamevarchar(15)NOTNULLdefault无,
PRIMARYKEY(id),
KEYuserid(userid)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_enemy
#
DROPTABLEIFEXISTScq_enemy;
CREATETABLEcq_enemy(
idint(4)unsignedzerofillNOTNULLauto_increment,
useridint(4)unsignedzerofillNOTNULLdefault0000,
enemyint(4)unsignedzerofillNOTNULLdefault0,
enemynamevarchar(15)NOTNULLdefault无,
timeint(4)unsignedzerofillNOTNULLdefault0,
PRIMARYKEY(id),
KEYuserid(userid,enemy)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_generator
#
DROPTABLEIFEXISTScq_generator;
CREATETABLEcq_generator(
idint(4)unsignedzerofillNOTNULLauto_increment,
mapidint(4)unsignedzerofillNOTNULLdefault0000,
bound_xint(4)unsignedzerofillNOTNULLdefault0000,
bound_yint(4)unsignedzerofillNOTNULLdefault0000,
bound_cxint(4)unsignedzerofillNOTNULLdefault0000,
bound_cyint(4)unsignedzerofillNOTNULLdefault0000,
gridint(4)unsignedzerofillNOTNULLdefault0009,
rest_secsint(4)unsignedzerofillNOTNULLdefault0000,
max_per_genint(4)unsignedzerofillNOTNULLdefault0000,
npctypeint(4)unsignedzerofillNOTNULLdefault0000,
timer_beginint(4)unsignedzerofillNOTNULLdefault0000,
timer_endint(4)unsignedzerofillNOTNULLdefault0000,
born_xint(4)unsignedzerofillNOTNULLdefault0000,
born_yint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
KEYmapid(mapid)
)TYPE=MyISAM;
#max_per_gen-0:generatbygameserver
#npctype-onlyuseformonsterbutpet
#(bound_x==0&&bound_y==0):dynamicboundforpet
#timer_begin,timer_end-format:DDWWHHMMSS,DD:dayofmonth(1-31),WW:dayofweek(1-7),HHMMSS:hour,minute,second.WWmast00whenDDisnot00.
#born_x,born_y-bornfromboundwhendefault0,elseborntocorrd(x,y)
#
#Tablestructurefortablecq_monstertype
#
DROPTABLEIFEXISTScq_monstertype;
CREATETABLEcq_monstertype(
idINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
nameCHAR(15)NOTNULLDEFAULT无,
typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
lookfaceINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
lengthtinyint(4)NOTNULLDEFAULT0,
fattinyint(4)NOTNULLDEFAULT0,
lifeSMALLINT(2)UNSIGNEDZEROFILLNOTNULLDEFAULT00,
manaSMALLINT(2)UNSIGNEDZEROFILLNOTNULLDEFAULT00,
attack_maxINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
attack_minINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
defenceINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
dexterityINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
dodgeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
helmet_typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
armor_typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
weaponr_typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
weaponl_typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
attack_rangeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
view_rangeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
escape_lifeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
attack_speedINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
move_speedINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
levelINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
attack_userINTEGER(1)UNSIGNEDNOTNULLDEFAULT3,
drop_money_minINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
drop_money_maxINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
size_addINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
actionINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
run_speedINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
drop_armettinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_necklacetinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_armortinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_ringtinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_weapontinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_shieldtinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_shoestinyint(3)UNSIGNEDZEROFILLNOTNULLDEFAULT000,
drop_money_chanceINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
drop_item_chanceINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
magic_typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
magic_defINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
magic_hitrateINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0100,
atk_hitrateINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
ai_typeINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
defence2INTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT10000,
explode_item_chance1INTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
explode_item_chance2INTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
explode_item_chance3INTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
drop_item_ruleINTEGER(4)UNSIGNEDZEROFILLNOTNULLDEFAULT0000,
PRIMARYKEY(id)
)TYPE=MyISAM;
#attack_user-0:escapeonly;
1:passive;//被动攻击
2:active;//主动攻击
4:good;//正义的(卫兵或玩家召唤和控制的怪物)
8:guard;//卫兵
16:pk_killer;//追杀黑名
32:jump;//会跳
64:fixed//不会动的
128:fastback,//速归
256:lockuser(auto_die),fortaskmonster//锁定攻击指定玩家，玩家离开自动消失
512:lockone,//锁定攻击首先攻击自己的玩家
1024:add_life,//自动加血
2048:evil_killer,//白名杀手
4096:wing,//飞行状态
8192:neutral,//中立的
16384:roar,//出生时全地图怒吼
32768:noescape,//不会逃跑
65536:equality,//不藐视
#attack_max/attack_min-attackwithweapon,orpowerofmagicwhenmagic_type
#magic_type-sendtoclienttype,neednotcq_magictype.
#recruitmagicnpc-magic_type=1020,magic_hitrate=percent(10->10%)
#ai_type-forcallpetai,usebyclientonly
#defence2-danage=danage*defence2/10000
#
#Tablestructurefortablecq_pet
#
DROPTABLEIFEXISTScq_pet;
CREATETABLEcq_pet(
idint(4)unsignedzerofillNOTNULLauto_increment,
owneridint(4)unsignedzerofillNOTNULLdefault0000,
ownertypetinyint(3)unsignedzerofillNOTNULLdefault000,
generatoridint(4)unsignedzerofillNOTNULLdefault0000,
typeidint(4)unsignedzerofillNOTNULLdefault0000,
namechar(15)binaryNOTNULLdefault无,
lifesmallint(2)unsignedzerofillNOTNULLdefault0000,
manasmallint(2)unsignedzerofillNOTNULLdefault0000,
recordmap_idint(4)unsignedNOTNULLdefault0000,
recordxsmallint(2)unsignedNOTNULLdefault0000,
recordysmallint(2)unsignedNOTNULLdefault0000,
dataint(4)unsignedNOTNULLdefault0000,
PRIMARYKEY(id)
)TYPE=MyISAM;
#ownertype-1:user,2:syndicate,3:npc
#typeid-idofcq_monstertype
#
#Tablestructurefortablecq_map
#
DROPTABLEIFEXISTScq_map;
CREATETABLEcq_map(
idint(4)unsignedNOTNULLdefault0,
namevarchar(15)binaryNOTNULLdefault未命名,
describe_textvarchar(127)binaryNOTNULLdefault,
mapdocint(4)unsignedNOTNULLdefault0,
typeint(4)unsignedzerofillNOTNULLdefault0,
owner_idint(4)unsignedNOTNULLdefault0,
mapgroupint(4)unsignedzerofillNOTNULLdefault0,
idxserverint(4)NOTNULLdefault-1,
weatherint(4)unsignedzerofillNOTNULLdefault0,
bgmusicint(4)unsignedzerofillNOTNULLdefault0,
bgmusic_showint(4)unsignedzerofillNOTNULLdefault0,
portal0_xint(4)unsignedzerofillNOTNULLdefault0000,
portal0_yint(4)unsignedzerofillNOTNULLdefault0000,
reborn_mapidint(4)unsignedzerofillNOTNULLdefault0000,
reborn_portalint(4)unsignedzerofillNOTNULLdefault0000,
res_levtinyint(3)unsignedNOTNULLdefault0,
owner_typetinyint(3)unsignedNOTNULLdefault0,
link_mapint(4)unsignedzerofillNOTNULLdefault0000,
link_xsmallint(2)unsignedzerofillNOTNULLdefault0000,
link_ysmallint(2)unsignedzerofillNOTNULLdefault0000,
del_flagtinyint(1)unsignedNOTNULLdefault0,
PRIMARYKEY(id),
KEYidx(idxserver,mapgroup)
)TYPE=MyISAM;
DROPTABLEIFEXISTScq_dynamap;
CREATETABLEcq_dynamap(
idint(4)unsignedNOTNULLdefault0auto_increment,
namevarchar(15)binaryNOTNULLdefault未命名,
describe_textvarchar(127)binaryNOTNULLdefault,
mapdocsmallint(4)unsignedNOTNULLdefault0,
typeint(4)unsignedzerofillNOTNULLdefault0,
owner_idint(4)unsignedNOTNULLdefault0,
mapgrouptinyint(4)unsignedzerofillNOTNULLdefault0,
idxservertinyint(4)NOTNULLdefault-1,
weathertinyint(4)unsignedzerofillNOTNULLdefault0,
bgmusictinyint(4)unsignedzerofillNOTNULLdefault0,
bgmusic_showtinyint(4)unsignedzerofillNOTNULLdefault0,
portal0_xsmallint(4)unsignedzerofillNOTNULLdefault0000,
portal0_ysmallint(4)unsignedzerofillNOTNULLdefault0000,
reborn_mapidint(4)unsignedzerofillNOTNULLdefault0000,
reborn_portaltinyint(4)unsignedzerofillNOTNULLdefault0000,
res_levsmallint(4)unsignedNOTNULLdefault0,
owner_typetinyint(3)unsignedNOTNULLdefault0,
link_mapint(4)unsignedzerofillNOTNULLdefault0000,
link_xsmallint(2)unsignedzerofillNOTNULLdefault0000,
link_ysmallint(2)unsignedzerofillNOTNULLdefault0000,
del_flagtinyint(1)unsignedNOTNULLdefault0,
PRIMARYKEY(id)
)TYPE=MyISAM;
INSERTcq_dynamapSETid=1000000,name=RESERVE_ID_SPACE;
#enumENUM_MAPTYPE{
MAPTYPE_NORMAL=0x0000,
MAPTYPE_PKFIELD=0x0001,
MAPTYPE_CHGMAP_DISABLE=0x0002,
MAPTYPE_RECORD_DISABLE=0x0004,
MAPTYPE_PK_DISABLE=0x0008,
};
#
#Tablestructurefortablecq_portal
#
DROPTABLEIFEXISTScq_portal;
CREATETABLEcq_portal(
idint(4)unsignedzerofillNOTNULLauto_increment,
mapidint(4)unsignedzerofillNOTNULLdefault0000,
portal_idxint(4)unsignedzerofillNOTNULLdefault0000,
pos_xint(4)unsignedzerofillNOTNULLdefault0000,
pos_yint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
KEYmapid(mapid)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_passway
#
DROPTABLEIFEXISTScq_passway;
CREATETABLEcq_passway(
idint(4)unsignedzerofillNOTNULLauto_increment,
mapidint(4)unsignedzerofillNOTNULLdefault0000,
passway_idxint(4)unsignedzerofillNOTNULLdefault0000,
target_mapidint(4)unsignedzerofillNOTNULLdefault0000,
target_mapportalint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
KEYmapid(mapid)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_region
#
DROPTABLEIFEXISTScq_region;
CREATETABLEcq_region(
idint(4)unsignedzerofillNOTNULLauto_increment,
mapidint(4)unsignedzerofillNOTNULLdefault0000,
typeint(4)unsignedzerofillNOTNULLdefault0000,
bound_xint(4)unsignedzerofillNOTNULLdefault0000,
bound_yint(4)unsignedzerofillNOTNULLdefault0000,
bound_cxint(4)unsignedzerofillNOTNULLdefault0000,
bound_cyint(4)unsignedzerofillNOTNULLdefault0000,
datastrvarchar(15)binaryNOTNULLdefault,
data0int(4)unsignedzerofillNOTNULLdefault0000,
data1int(4)unsignedzerofillNOTNULLdefault0000,
data2int(4)unsignedzerofillNOTNULLdefault0000,
data3int(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
KEYmapid(mapid)
)TYPE=MyISAM;
#mapid-ismapdoc
#type：
#1-city.recordpositiondisable,magiccallplayerdisable.
#2-weather.data0(2):Type,data1(200):Intensity(0-999),data2(10):dir(0-359),data3(0x00ffffff):nColor,data1<0:fastchange.
#type-enum{WEATHER_NONE=0,WEATHER_FINE,
#WEATHER_RAINY,WEATHER_SNOWY,WEATHER_SANDS,
#WEATHER_LEAF,WEATHER_BAMBOO,WEATHER_FLOWER,
#WEATHER_FLYING,WEATHER_DANDELION,WEATHER_WORM,WEATHER_CLOUDY,
#WEATHER_ALL};
#
#Tablestructurefortablecq_magictype
#
DROPTABLEIFEXISTScq_magictype;
CREATETABLEcq_magictype(
idint(4)unsignedzerofillNOTNULLauto_increment,
typeint(4)unsignedzerofillNOTNULLdefault0000,
sortint(4)unsignedzerofillNOTNULLdefault0000,
namevarchar(15)binaryNOTNULLdefault,
crimetinyint(1)unsignedzerofillNOTNULLdefault0,
groundtinyint(1)unsignedzerofillNOTNULLdefault0,
multitinyint(1)unsignedzerofillNOTNULLdefault0,
targetint(4)unsignedzerofillNOTNULLdefault0000,
levelint(4)unsignedzerofillNOTNULLdefault0000,
use_mpint(4)unsignedzerofillNOTNULLdefault0000,
powerint(4)NOTNULLdefault0000,
intone_speedint(4)unsignedzerofillNOTNULLdefault0000,
percentint(4)unsignedzerofillNOTNULLdefault0000,
step_secsint(4)unsignedzerofillNOTNULLdefault0000,
rangeint(4)unsignedzerofillNOTNULLdefault0000,
distanceint(4)unsignedzerofillNOTNULLdefault0000,
statusint(4)unsignedzerofillNOTNULLdefault0000,
need_profint(4)unsignedzerofillNOTNULLdefault0000,
need_expint(4)NOTNULLdefault0000,
need_levelint(4)unsignedzerofillNOTNULLdefault0000,
use_xptinyint(3)unsignedzerofillNOTNULLdefault000,
weapon_subtypeint(4)unsignedzerofillNOTNULLdefault0000,
active_timesint(4)unsignedzerofillNOTNULLdefault0000,
auto_activetinyint(3)unsignedzerofillNOTNULLdefault000,
floor_attrint(4)unsignedzerofillNOTNULLdefault0000,
auto_learntinyint(1)unsignedzerofillNOTNULLdefault0,
learn_levelint(4)unsignedzerofillNOTNULLdefault0000,
drop_weapontinyint(1)unsignedzerofillNOTNULLdefault0,
use_epint(4)unsignedzerofillNOTNULLdefault0000,
weapon_hittinyint(1)unsignedzerofillNOTNULLdefault0,
use_itemint(4)unsignedzerofillNOTNULLdefault0000,
next_magicint(4)unsignedzerofillNOTNULLdefault0000,
delay_msint(4)unsignedzerofillNOTNULLdefault0000,
use_item_numint(4)unsignedzerofillNOTNULLdefault0001,
widthint(4)unsignedzerofillNOTNULLdefault0000,
durabilityint(4)unsignedzerofillNOTNULLdefault0001,
PRIMARYKEY(id)
)TYPE=MyISAM;
#type:类型
#10000~10255-武器魔法，即cq_itemtype中的magic1+10000
#sort:行为分类。
#1-攻击单人，对方去血,checkfloorattr,supportdrop_weaponinweaponskill。(supportxpskill)
#2-回复，加血。(supportautoactive),(supportteammemberwithmultiflag)
#3-十字型区域目标去血。
#4-扇形区域目标去血。(supportxpskill)(SizeAddeffective)(supportautoactiveofrandommode)
#5-圆形区域目标去血。(supportgroundtype)
#6-攻击单人，对方加状态。
#7-回复单人，对方去状态。
#8-rangeofsquare,multitarget,(supportxpskill)(supportgroundtype)(SizeAddeffective)
#9-jump&attack,singletarget,(supportxpskill)(supportgroundtype)
#10-randomtransmit,powerismaxdistance.
#11-dispatchxp
#12-collide,(supportxpskillonly)
#13-serialcut,groundtypeonly.(autoactive,supportxpskill&weaponskill)
#14-line,(supportweaponskill,powerisnumberoflifeexpended)(supportautoactiveofrandommode)
#15-addattackrange,(autoactiveonly,forevereffect)
#16-attackwithtempstatus,weaponskillonly
#supportstatus:attack|defence|bedamagewithweapon|attackrate|stop|vampire(otherstatusisattacktargetandattachthisstatus),
#supportautoactiveofrandommode,onlyforweapon_hit=0
#17-callteammember.
#18-recordmappositiontotransspell.
#19-transformtomonster,(monster_type==power)
#20-addmana,(powerisaddnumber,supportselftargetonly)
#21-laytrap,poweristrap_type.
#22-dance,(useforclient)
#23-callpet,powerismonstertype.step_secsisalivesecsforpet,0forkeepalive.
#24-VAMPIRE.useforcallpet.
#25-INSTEAD.useforcallpet.
#26-decrementlife.powerisdataorpercentofcurrentlife.
#27-groundsting.
#range:
#106-表示主方向为6，次方向为1
#power:
#(-29999)-29999-addorsub
#30000-32767-addorsubbypercentof(num-30000)
#-32768-settofull
#(-30000)-(-32767)-setto(-1*num-30000)
#0-mastbezerowhendetach
#status:
#2-detachbadlystatus.(supportdetachonly)
#4-poison
#8-detachallstatusofmagic.(supportdetachonly)
#16-vampire(onlysupportsort16)
#32-HitRate
#64-defence
#128-attack
#512-magicdefence
#1024-bowdefence
#2048-attackrange
#4096-reflectweapon
#8192-supermanstatus,withhalfofdefence.
#16384-bedamagewithweapon,detachwhenmoveorattackinkeepeffect
#32768-bedamagewithmagic
#65536-attackrate
#131072-invisibleformonster
#262144-TORNADO
#1048576-reflectmagic
#2097152-dodge
#4194304-wing
#8388608-keep_bow,addattack,cancelwhenmove
#16777216-stopmillisecsinpower,havenotkeepeffect.monstervalid.(believe:powerisadddamage,step_secsiskeepmillisecs.)
#need_prof:有多种职业要求时，值相加即可。最高级填0，表示没有一种职业可以再升级了。
#1-魔法师
#2-魔法师转职
#4-战士
#8-战士转职
#16-弓箭手
#32-弓箭手转职
#need_exp:
#0-不升级(或通过任务系统升级)
#-1-自动升级。
#target:
#0-敌人
#1-允许对自己
#2-notarget
#use_xp:
#0-法术
#1-XP技
#2-武器技(supportuplevelwithauto_uplevel&weaponskill_level,donotsupportuplevelwithneed_expnumber)
#active_times:
#0-oncetimesstatusclass(usefordefence/hitrate)
#1-x-moretimesstatusclass(useforpoison)
#auto_active:
#0-noneautoactive
#1-activewhenkilltarget,enablesort2,13
#2-activewhenequipment,enablesort15
#4-activeinrandom,enablesort4,5,14,16
#learn_level:
#1-99-automaticlearnweaponskillatthislevel.
#nnmm-automaticlearnweaponskillbetweenmm-nnlevel.
#drop_weapon:
#1-throwweapon_rtotargetaround.
#weapon_hit:
#0-hitbyweapon
#1-hitbymagic
#2-hitmodebyarrow
#use_item-useequipitembysub_type,0fornouse.
#use_item_num-useequipitemnumber,0forcheckitemonly.
#delay_ms-0:fordefaultdelay.
#width-widthofmagic.0-180fordegreeoffan(sort4),0fordefault.
#
#Tablestructurefortablecq_magic
#
CREATETABLEcq_magic(
idint(4)unsignedzerofillNOTNULLauto_increment,
owneridint(4)unsignedzerofillNOTNULLdefault0000,
typesmallint(4)unsignedzerofillNOTNULLdefault0000,
levelsmallint(4)unsignedzerofillNOTNULLdefault0000,
expint(4)unsignedzerofillNOTNULLdefault0000,
unlearntinyint(1)unsignedzerofillNOTNULLdefault0,
old_levelsmallint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
KEYuser_magic(ownerid)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_syndicate
#
CREATETABLEcq_syndicate(
idint(4)unsignedzerofillNOTNULLauto_increment,
namevarchar(15)binaryNOTNULLdefault,
announcevarchar(255)binaryNOTNULLdefault,
tenetvarchar(255)binaryNOTNULLdefault,
member_titlevarchar(15)binaryNOTNULLdefault弟子,
leader_idint(4)unsignedzerofillNOTNULLdefault0000,
leader_namevarchar(15)binaryNOTNULLdefault,
moneyint(4)zerofillNOTNULLdefault0000,
fealty_synint(4)unsignedzerofillNOTNULLdefault0000,
del_flagtinyint(1)unsignedzerofillNOTNULLdefault0,
amountint(4)unsignedzerofillNOTNULLdefault0000,
enemy0int(4)unsignedzerofillNOTNULLdefault0000,
enemy1int(4)unsignedzerofillNOTNULLdefault0000,
enemy2int(4)unsignedzerofillNOTNULLdefault0000,
enemy3int(4)unsignedzerofillNOTNULLdefault0000,
enemy4int(4)unsignedzerofillNOTNULLdefault0000,
ally0int(4)unsignedzerofillNOTNULLdefault0000,
ally1int(4)unsignedzerofillNOTNULLdefault0000,
ally2int(4)unsignedzerofillNOTNULLdefault0000,
ally3int(4)unsignedzerofillNOTNULLdefault0000,
ally4int(4)unsignedzerofillNOTNULLdefault0000,
ranktinyint(1)unsignedzerofillNOTNULLdefault0,
sainttinyint(1)unsignedzerofillNOTNULLdefault0,
mantletinyint(1)unsignedzerofillNOTNULLdefault0,
distimeint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
UNIQUEKEYname(name)
)TYPE=MyISAM;
#del_flag:deletebysyndicateleader
#
#Tablestructurefortablecq_synattr
#
CREATETABLEcq_synattr(
idint(4)unsignedzerofillNOTNULL,
syn_idint(4)unsignedzerofillNOTNULLdefault0000,
rankint(4)unsignedzerofillNOTNULLdefault0000,
profferint(4)unsignedzerofillNOTNULLdefault0000,
titleint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_leaveword
#
DROPTABLEIFEXISTScq_leaveword;
CREATETABLEcq_leaveword(
idint(4)unsignedzerofillNOTNULLauto_increment,
user_namechar(15)binaryNOTNULLdefault未知,
send_namechar(15)binaryNOTNULLdefault未知,
timechar(15)binaryNOTNULLdefault00000000000000,
wordschar(255)binaryNOTNULLdefault未命名,
PRIMARYKEY(id),
KEYuser_name(user_name)
)TYPE=MyISAM;
如果喜欢www.885mu.com请告诉你身边的朋友，谢谢对本站支持！ |
|