CREATE TABLE BASE_ITEM
([Wgt] int NOT NULL,
[Mac] int NOT NULL,
[Contime] int NOT NULL,
[SpecialMac] int NOT NULL,
[Avo] int NOT NULL,
[Hr] int NOT NULL,
[Dmr] int NOT NULL,
[Amr] int NOT NULL,
[Ac] int NULL,
[DMat] int NOT NULL,
[AMat] int NOT NULL,
[Dis] int NOT NULL,
[DatMax] int NOT NULL,
[DatMin] int NOT NULL,
[AatMax] int NOT NULL,
[AatMin] int NOT NULL,
[Pot] int NOT NULL,
[PotType] int NOT NULL,
[Price] int NOT NULL,
[ItemPos] int NOT NULL,
[Class] int NULL,
[Gen] int NOT NULL,
[Type] int NOT NULL,
[Group] int NOT NULL,
[strName] int NoT NULL,
[strCode] int NOT NULL,
[Num] int NULL,)
CREATE TABLE CRM_DATA_MONSTER_ITEM
([nMonsterItemID] int NOT NULL,
[GameServer Connect - %d] int NOT NULL,)
CREATE TABLE MAKE_DEFENSIVE
([sClass_7] int NOT NULL,
[sClass_6] int NOT NULL,
[sClass_5] int NOT NULL,
[sClass_4] int NOT NULL,
[sClass_3] int NOT NULL,
[sClass_2] int NOT NULL,
[sClass_1] int NOT NULL,
[byLevel] int NOT NULL,)
CREATE TABLE MAKE_ITEM_GRADECODE
([byGrade_9] int NOT NULL,
[byGrade_8] int NOT NULL,
[byGrade_7] int NOT NULL,
[byGrade_6] int NOT NULL,
[byGrade_5] int NOT NULL,
[byGrade_4] int NOT NULL,
[byGrade_3] int NOT NULL,
[byGrade_2] int NOT NULL,
[byGrade_1] int NOT NULL,
[byItemIndex] int NOT NULL,)
CREATE TABLE MAKE_ITEM_GROUP
([iItem_30] int NOT NULL,
[iItem_29] int NOT NULL,
[iItem_28] int NOT NULL,
[iItem_27] int NOT NULL,
[iItem_26] int NOT NULL,
[iItem_25] int NOT NULL,
[iItem_24] int NOT NULL,
[iItem_23] int NOT NULL,
[iItem_22] int NOT NULL,
[iItem_21] int NOT NULL,
[iItem_20] int NOT NULL,
[iItem_19] int NOT NULL,
[iItem_18] int NOT NULL,
[iItem_17] int NOT NULL,
[iItem_16] int NOT NULL,
[iItem_15] int NOT NULL,
[iItem_14] int NOT NULL,
[iItem_13] int NOT NULL,
[iItem_12] int NOT NULL,
[iItem_11] int NOT NULL,
[iItem_10] int NOT NULL,
[iItem_9] int NOT NULL,
[iItem_8] int NOT NULL,
[iItem_7] int NOT NULL,
[iItem_6] int NOT NULL,
[iItem_5] int NOT NULL,
[iItem_4] int NOT NULL,
[iItem_3] int NOT NULL,
[iItem_2] int NOT NULL,
[iItem_1] int NOT NULL,
[iItemGroupNum] int NOT NULL,)
CREATE TABLE MAKE_ITEM_LARECODE
([sGereralItem] int NOT NULL,
[sMagicItem] int NOT NULL,
[sLareItem] int NOT NULL,
[sUpgradeItem] int NOT NULL,
[byLevelGrade] int NOT NULL,)
CREATE TABLE MAKE_WEAPON
([sClass_12] int NOT NULL,
[sClass_11] int NOT NULL,
[sClass_10] int NOT NULL,
[sClass_9] int NOT NULL,
[sClass_8] int NOT NULL,)
CREATE TABLE MONSTER_SUMMON_LIST
([bType] int NOT NULL,
[sProbability] int NOT NULL,
[sLevel] int NOT NULL,
[sSid] int NOT NULL,)
CREATE TABLE K_MONSTER
([byMoneyType] int NOT NULL,
[byMagicAttack] int NOT NULL,
[byDirectAttack] int NOT NULL,
[sItem] int NOT NULL,
[iMoney] int NOT NULL,
[byTracingRange] int NOT NULL,
[bySearchRange] int NOT NULL,
[byAttackRange] int NOT NULL,
[sBulk] int NOT NULL,
[sLightR] int NOT NULL,
[sPoisonR] int NOT NULL,
[sDiseaseR] int NOT NULL,
[sMagicR] int NOT NULL,
[sLightningR] int NOT NULL,
[sColdR] int NOT NULL,
[sFireR] int NOT NULL,
[iMagic3] int NOT NULL,
[iMagic2] int NOT NULL,
[iMagic1] int NOT NULL,
[sStandtime] int NOT NULL,
[bySpeed2] int NOT NULL,
[bySpeed1] int NOT NULL,
[sAttackDelay] int NOT NULL,
[sDamage] int NOT NULL,
[sEvadeRate] int NOT NULL,
[sHitRate] int NOT NULL,
[sAc] int NOT NULL,
[sAtk] int NOT NULL,
[sMpPoint] int NOT NULL,
[iHpPoint] int NOT NULL,
[iLoyalty] int NOT NULL,
[iExp] int NOT NULL,
[iSellingGroup] int NOT NULL,
[byTitle] int NOT NULL,
[byRank] int NOT NULL,
[byFamily] int NOT NULL,
[byType] int NOT NULL,
[byActType] int NOT NULL,
[byGroup] int NOT NULL,
[iWeapon2] int NOT NULL,
[iWeapon1] int NOT NULL,
[sSize] int NOT NULL,
[sPid] int NOT NULL,)
CREATE TABLE K_MONSTER_ITEM
([sPersent05] int NOT NULL,
[iItem05] int NOT NULL,
[sPersent04] int NOT NULL,
[iItem04] int NOT NULL,
[sPersent03] int NOT NULL,
[iItem03] int NOT NULL,
[sPersent02] int NOT NULL,
[iItem02] int NOT NULL,
[sPersent01] int NOT NULL,
[iItem01] int NOT NULL,
[sIndex] int NOT NULL,)
CREATE TABLE K_NPC_MOVE_ITEM
([sMoveMaxY] int NOT NULL,
[sMoveMaxX] int NOT NULL,
[sMoveMinY] int NOT NULL,
[sMoveMinX] int NOT NULL,
[byMoveItem] int NOT NULL,
[sChangeSid] int NOT NULL,
[byChangeItem] int NOT NULL,
[sCastleIndex] int NOT NULL,)
CREATE TABLE K_NPCPOS
([path] int NOT NULL,
[DotCnt] int NOT NULL,
[byDirection] int NOT NULL,
[RegTime] int NOT NULL,
[NumNPC] int NOT NULL,
[LimitMaxZ] int NOT NULL,
[LimitMaxX] int NOT NULL,
[LimitMinZ] int NOT NULL,
[LimitMinX] int NOT NULL,
[BottomZ] int NOT NULL,
[RightX] int NOT NULL,
[TopZ] int NOT NULL,
[LeftX] int NOT NULL,
[TrapNumber] int NOT NULL,
[SpecialType] int NOT NULL,
[DungeonFamily] int NOT NULL,
[RegenType] int NOT NULL,
[ActType] int NOT NULL,
[NpcID] int NOT NULL,
[ZoneID] int NOT NULL,)
CREATE TABLE K_NPC
([HP] int NOT NULL,
[RANGE] int NOT NULL,)
CREATE TABLE NPC_POS
([HP] int NOT NULL,
[RANGE] int NOT NULL,)
CREATE TABLE CRM_DATA_MONSTER_ITEM
([nMonsterItemID] int NOT NULL,
[GameServer Connect - %d] int NOT NULL,)
CREATE TABLE MAKE_DEFENSIVE
([sClass_7] int NOT NULL,
[sClass_6] int NOT NULL,
[sClass_5] int NOT NULL,
[sClass_4] int NOT NULL,
[sClass_3] int NOT NULL,
[sClass_2] int NOT NULL,
[sClass_1] int NOT NULL,
[byLevel] int NOT NULL,)
CREATE TABLE MAKE_ITEM_GRADECODE
([byGrade_9] int NOT NULL,
[byGrade_8] int NOT NULL,
[byGrade_7] int NOT NULL,
[byGrade_6] int NOT NULL,
[byGrade_5] int NOT NULL,
[byGrade_4] int NOT NULL,
[byGrade_3] int NOT NULL,
[byGrade_2] int NOT NULL,
[byGrade_1] int NOT NULL,
[byItemIndex] int NOT NULL,)
CREATE TABLE MAKE_ITEM_GROUP
([iItem_30] int NOT NULL,
[iItem_29] int NOT NULL,
[iItem_28] int NOT NULL,
[iItem_27] int NOT NULL,
[iItem_26] int NOT NULL,
[iItem_25] int NOT NULL,
[iItem_24] int NOT NULL,
[iItem_23] int NOT NULL,
[iItem_22] int NOT NULL,
[iItem_21] int NOT NULL,
[iItem_20] int NOT NULL,
[iItem_19] int NOT NULL,
[iItem_18] int NOT NULL,
[iItem_17] int NOT NULL,
[iItem_16] int NOT NULL,
[iItem_15] int NOT NULL,
[iItem_14] int NOT NULL,
[iItem_13] int NOT NULL,
[iItem_12] int NOT NULL,
[iItem_11] int NOT NULL,
[iItem_10] int NOT NULL,
[iItem_9] int NOT NULL,
[iItem_8] int NOT NULL,
[iItem_7] int NOT NULL,
[iItem_6] int NOT NULL,
[iItem_5] int NOT NULL,
[iItem_4] int NOT NULL,
[iItem_3] int NOT NULL,
[iItem_2] int NOT NULL,
[iItem_1] int NOT NULL,
[iItemGroupNum] int NOT NULL,)
CREATE TABLE MAKE_ITEM_LARECODE
([sGereralItem] int NOT NULL,
[sMagicItem] int NOT NULL,
[sLareItem] int NOT NULL,
[sUpgradeItem] int NOT NULL,
[byLevelGrade] int NOT NULL,)
CREATE TABLE MAKE_WEAPON
([sClass_12] int NOT NULL,
[sClass_11] int NOT NULL,
[sClass_10] int NOT NULL,
[sClass_9] int NOT NULL,
[sClass_8] int NOT NULL,)
CREATE TABLE MONSTER_SUMMON_LIST
([bType] int NOT NULL,
[sProbability] int NOT NULL,
[sLevel] int NOT NULL,
[sSid] int NOT NULL,)
CREATE TABLE K_MONSTER
([byMoneyType] int NOT NULL,
[byMagicAttack] int NOT NULL,
[byDirectAttack] int NOT NULL,
[sItem] int NOT NULL,
[iMoney] int NOT NULL,
[byTracingRange] int NOT NULL,
[bySearchRange] int NOT NULL,
[byAttackRange] int NOT NULL,
[sBulk] int NOT NULL,
[sLightR] int NOT NULL,
[sPoisonR] int NOT NULL,
[sDiseaseR] int NOT NULL,
[sMagicR] int NOT NULL,
[sLightningR] int NOT NULL,
[sColdR] int NOT NULL,
[sFireR] int NOT NULL,
[iMagic3] int NOT NULL,
[iMagic2] int NOT NULL,
[iMagic1] int NOT NULL,
[sStandtime] int NOT NULL,
[bySpeed2] int NOT NULL,
[bySpeed1] int NOT NULL,
[sAttackDelay] int NOT NULL,
[sDamage] int NOT NULL,
[sEvadeRate] int NOT NULL,
[sHitRate] int NOT NULL,
[sAc] int NOT NULL,
[sAtk] int NOT NULL,
[sMpPoint] int NOT NULL,
[iHpPoint] int NOT NULL,
[iLoyalty] int NOT NULL,
[iExp] int NOT NULL,
[iSellingGroup] int NOT NULL,
[byTitle] int NOT NULL,
[byRank] int NOT NULL,
[byFamily] int NOT NULL,
[byType] int NOT NULL,
[byActType] int NOT NULL,
[byGroup] int NOT NULL,
[iWeapon2] int NOT NULL,
[iWeapon1] int NOT NULL,
[sSize] int NOT NULL,
[sPid] int NOT NULL,)
CREATE TABLE K_MONSTER_ITEM
([sPersent05] int NOT NULL,
[iItem05] int NOT NULL,
[sPersent04] int NOT NULL,
[iItem04] int NOT NULL,
[sPersent03] int NOT NULL,
[iItem03] int NOT NULL,
[sPersent02] int NOT NULL,
[iItem02] int NOT NULL,
[sPersent01] int NOT NULL,
[iItem01] int NOT NULL,
[sIndex] int NOT NULL,)
CREATE TABLE K_NPC_MOVE_ITEM
([sMoveMaxY] int NOT NULL,
[sMoveMaxX] int NOT NULL,
[sMoveMinY] int NOT NULL,
[sMoveMinX] int NOT NULL,
[byMoveItem] int NOT NULL,
[sChangeSid] int NOT NULL,
[byChangeItem] int NOT NULL,
[sCastleIndex] int NOT NULL,)
CREATE TABLE K_NPCPOS
([path] int NOT NULL,
[DotCnt] int NOT NULL,
[byDirection] int NOT NULL,
[RegTime] int NOT NULL,
[NumNPC] int NOT NULL,
[LimitMaxZ] int NOT NULL,
[LimitMaxX] int NOT NULL,
[LimitMinZ] int NOT NULL,
[LimitMinX] int NOT NULL,
[BottomZ] int NOT NULL,
[RightX] int NOT NULL,
[TopZ] int NOT NULL,
[LeftX] int NOT NULL,
[TrapNumber] int NOT NULL,
[SpecialType] int NOT NULL,
[DungeonFamily] int NOT NULL,
[RegenType] int NOT NULL,
[ActType] int NOT NULL,
[NpcID] int NOT NULL,
[ZoneID] int NOT NULL,)
CREATE TABLE K_NPC
([HP] int NOT NULL,
[RANGE] int NOT NULL,)
CREATE TABLE NPC_POS
([HP] int NOT NULL,
[RANGE] int NOT NULL,) |
看不懂，太深奥了
