PDA

View Full Version : Modified Item Table


Kayot
07-24-2008, 09:04 PM
I've been working on a side project for a while now and it has finally reached ready to deploy status.

DESC: I was tired of how the items table lacked comments and most data types where integers. So I set about changing that. After quite some work, I finished.

This works with PEQ's 1119 CVS. It adds comments and sets the datatypes to be more effective.

Without - 62266 in 16.6221s/19.2204s Data Length: 18.1 MB -- Index Length: 5.6 MB
With mods - 62266 in 16.7133s/16.9072s Data Length: 16.5 MB -- Index Length: 3.9 MB
Mem Saved 1.6 MB 1.7 MB

The SQL code, which is also in my Wiki Section and will be a requirement for my editor. Also, I finnaly choose my editors name EqDE (E-ku-dee) or Echo~De.

ALTER TABLE `peq`.`items`
MODIFY COLUMN `id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The ID number, this is a key and is used as such.',
MODIFY COLUMN `minstatus` tinyint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Minimum Status needed to weild this item.',
MODIFY COLUMN `Name` varchar(64) NOT NULL COMMENT 'The name of the item.',
MODIFY COLUMN `aagi` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The AGI stat on the item.',
MODIFY COLUMN `ac` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The AC of the item.',
MODIFY COLUMN `accuracy` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Accuracy of the item.',
MODIFY COLUMN `acha` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The CHA stat on the item.',
MODIFY COLUMN `adex` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The DEX stat on the item.',
MODIFY COLUMN `aint` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The INT stat on the item.',
MODIFY COLUMN `artifactflag` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'The Artifact Flag, 0 or 1',
MODIFY COLUMN `asta` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The STA stat on the item.',
MODIFY COLUMN `astr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The STR stat on the item.',
MODIFY COLUMN `attack` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Attack on the item.',
MODIFY COLUMN `augrestrict` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `augslot1type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The possible Augment Level that goes in this slot.',
MODIFY COLUMN `augslot1unk` enum('1') NOT NULL DEFAULT '1' COMMENT 'Always 1, Not sure what this does.',
MODIFY COLUMN `augslot2type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The possible Augment Level that goes in this slot.',
MODIFY COLUMN `augslot2unk` enum('1') NOT NULL DEFAULT '1' COMMENT 'Always 1, Not sure what this does.',
MODIFY COLUMN `augslot3type` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'The possible Augment Level that goes in this slot.',
MODIFY COLUMN `augslot3unk` enum('1') NOT NULL DEFAULT '1' COMMENT 'Always 1, Not sure what this does.',
MODIFY COLUMN `augslot4type` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'The possible Augment Level that goes in this slot.',
MODIFY COLUMN `augslot4unk` enum('1') NOT NULL DEFAULT '1' COMMENT 'Always 1, Not sure what this does.',
MODIFY COLUMN `augslot5type` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'The possible Augment Level that goes in this slot.',
MODIFY COLUMN `augslot5unk` enum('1') NOT NULL DEFAULT '1' COMMENT 'Always 1, Not sure what this does.',
MODIFY COLUMN `augtype` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Bitmask, Slots the augment can go into.',
MODIFY COLUMN `avoidance` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Avoidance Stat',
MODIFY COLUMN `awis` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Wis stat on the item.',
MODIFY COLUMN `bagsize` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The maximum size item the bag can hold. 1 = Tiny, 2 = Small, 3 = Medium, 4 = Large, 5 = Giant',
MODIFY COLUMN `bagslots` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The number of slots the bag has, 10 is max.',
MODIFY COLUMN `bagtype` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The type of combined the bag can do, see object.h in EQemu source for listing.',
MODIFY COLUMN `bagwr` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Bags weight reduction of contained items.',
MODIFY COLUMN `banedmgamt` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Amount of +Damage to banedmgbody',
MODIFY COLUMN `banedmgraceamt` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `banedmgbody` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The banedmgamt +Damage to this body type.',
MODIFY COLUMN `banedmgrace` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `bardtype` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Instrument type, a Bard Only field. 23 = Wind Instruments, 24 = Stringed Instruments, 25 = Brass Instruments, 26 = Percussion Instruments, 50 = Singing, 51 = All Instruments',
MODIFY COLUMN `bardvalue` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'How much bardtype adds to that skill.',
MODIFY COLUMN `book` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Not used on books, thats for sure.',
MODIFY COLUMN `casttime` mediumint(9) NOT NULL DEFAULT '0' COMMENT 'Usally handles the cast time of spells, Right-Clicky''s mainly.',
MODIFY COLUMN `casttime_` mediumint(9) NOT NULL DEFAULT '0' COMMENT 'Usally handles the cast time of spells, Right-Clicky''s mainly. Guess it''s a backup?',
MODIFY COLUMN `charmfile` varchar(32) NOT NULL DEFAULT '' COMMENT 'Unknown',
MODIFY COLUMN `charmfileid` varchar(32) NOT NULL DEFAULT '' COMMENT 'Unknown',
MODIFY COLUMN `classes` mediumint(8) UNSIGNED NOT NULL DEFAULT '65535' COMMENT 'Bitmask, Classes that can use this item.',
MODIFY COLUMN `color` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The color of the item, Alfa,Red,Gree,Blue in a Long',
MODIFY COLUMN `combateffects` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `extradmgskill` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `extradmgamt` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `price` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The price of the item in coppers.',
MODIFY COLUMN `cr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Cold Resist stat on the item.',
MODIFY COLUMN `damage` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Damage the item can do. Only used on weapons.',
MODIFY COLUMN `damageshield` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The amount the Damage shield is Boosted.',
MODIFY COLUMN `deity` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Deity Restriction (Only worshipers of this deity can wield this item)',
MODIFY COLUMN `delay` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Delay on the item. Only used on weapons.',
MODIFY COLUMN `augdistiller` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Augment Class Distiller. This is the minimum that will work.',
MODIFY COLUMN `dotshielding` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Shielding Boost against Damage over Time spells.',
MODIFY COLUMN `dr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Disease Resist stat on the item.',
MODIFY COLUMN `clicktype` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Right-Click Type. (Notes Later)',
MODIFY COLUMN `clicklevel2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Level the Right-Click will work.',
MODIFY COLUMN `elemdmgtype` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Elemental Class Damage Bonus',
MODIFY COLUMN `elemdmgamt` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'How much Damage the Elemental Class mitigates.',
MODIFY COLUMN `endur` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Endurance stat.',
MODIFY COLUMN `factionamt1` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Slot 1 - Amount the faction in factionmod1 is adjusted.',
MODIFY COLUMN `factionamt2` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Slot 2 - Amount the faction in factionmod2 is adjusted.',
MODIFY COLUMN `factionamt3` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Slot 3 - Amount the faction in factionmod3 is adjusted.',
MODIFY COLUMN `factionamt4` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Slot 4 - Amount the faction in factionmod4 is adjusted.',
MODIFY COLUMN `factionmod1` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Slot 1 - Modified faction ID',
MODIFY COLUMN `factionmod2` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Slot 2 - Modified faction ID',
MODIFY COLUMN `factionmod3` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Slot 3 - Modified faction ID',
MODIFY COLUMN `factionmod4` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Slot 4 - Modified faction ID',
MODIFY COLUMN `filename` varchar(32) NOT NULL DEFAULT '' COMMENT 'Unknown',
MODIFY COLUMN `focuseffect` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Spell ID of the Focus Effect',
MODIFY COLUMN `fr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Fire Resist stat on the item.',
MODIFY COLUMN `fvnodrop` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `haste` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Percentage Haste Boost',
MODIFY COLUMN `clicklevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Right-Click Level for the item',
MODIFY COLUMN `hp` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The HP stat',
MODIFY COLUMN `regen` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The HP Regen Rate',
MODIFY COLUMN `icon` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Icon ID Number',
MODIFY COLUMN `idfile` varchar(30) NOT NULL DEFAULT '' COMMENT 'Unknown',
MODIFY COLUMN `itemclass` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `itemtype` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `ldonprice` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Price in LDoN Points',
MODIFY COLUMN `ldontheme` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The LDoN Theme, Where it comes from?',
MODIFY COLUMN `ldonsold` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Is this sold via, LDoN Merchant',
MODIFY COLUMN `light` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The light amplitude addition.',
MODIFY COLUMN `lore` varchar(80) NOT NULL COMMENT 'The Lore Description of the Item',
MODIFY COLUMN `loregroup` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `magic` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'The Magic Tag on the item, 0 or 1',
MODIFY COLUMN `mana` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Mana stat on the item',
MODIFY COLUMN `manaregen` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The Mana Regeneration Stat on the Item',
MODIFY COLUMN `enduranceregen` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The Endurance Regeneration Stat on the Item',
MODIFY COLUMN `material` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The graphical appearance of the item.',
MODIFY COLUMN `maxcharges` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The number of charges on the item, -1 is infinate',
MODIFY COLUMN `mr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Magic Resistance',
MODIFY COLUMN `nodrop` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'The Nodrop Tag, Unused - Maybe No Trade, 0 = True, 1+ = False',
MODIFY COLUMN `norent` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'The Temporary Tag, 0 = True, 1+ = False',
MODIFY COLUMN `pendingloreflag` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Unknown, Always 0',
MODIFY COLUMN `pr` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Poison Resist on the Item',
MODIFY COLUMN `procrate` int(11) NOT NULL DEFAULT '0' COMMENT 'The rate a proc effect activates, not sure how it works.',
MODIFY COLUMN `races` mediumint(8) UNSIGNED NOT NULL DEFAULT '65535' COMMENT 'Races Bitmask -- 65535 = All, 131071 = Bag',
MODIFY COLUMN `range` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Range on the item',
MODIFY COLUMN `reclevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Recommended Level on the Item',
MODIFY COLUMN `recskill` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Recommended Skill, acts like Rec Level',
MODIFY COLUMN `reqlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Required Level on the Item',
MODIFY COLUMN `sellrate` float UNSIGNED NOT NULL DEFAULT '1' COMMENT 'The Adjusted Sell rate of an Item when buying from a Merchant. I don''t belive this is in use as of now',
MODIFY COLUMN `shielding` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Shielding Addition on the Item',
MODIFY COLUMN `size` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0' COMMENT 'The size of the item, 0 = Tiny, 1 = Small, 2 = Medium, 3 = Large, 4 = Giant, 5 = Giant+',
MODIFY COLUMN `skillmodtype` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Skill # that is modified by the Skillmodvalue',
MODIFY COLUMN `skillmodvalue` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The value skillmodtype is adjusted by',
MODIFY COLUMN `slots` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Slot Bitmask Field',
MODIFY COLUMN `clickeffect` smallint(6) NOT NULL DEFAULT '-1' COMMENT 'The SpellID that the Item Right-Click Activates',
MODIFY COLUMN `spellshield` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The additional Protection against Spells that this item provides',
MODIFY COLUMN `strikethrough` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Strikethrough chance, ignores armor',
MODIFY COLUMN `stunresist` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Chance to resist Stun, both from combat and spells',
MODIFY COLUMN `summonedflag` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Summoned Flag, Always 0. Probably not used',
MODIFY COLUMN `tradeskills` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Tradeskill Tag, this just adds the text "This item can be used in tradeskills." text to the items description.',
MODIFY COLUMN `favor` smallint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The amount of Favor generated when donating this item',
MODIFY COLUMN `weight` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The weight of an item. It is multiplied by .1 in game',
MODIFY COLUMN `unknown002` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown003` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown005` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown007` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown018` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown019` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown020` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `UNK012` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK013` enum('-1','0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `benefitflag` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `unknown061` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `UNK054` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `unknown067` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown069` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `UNK059` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK061` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `unknown081` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown105` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `booktype` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `unknown122` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown123` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `unknown124` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `recastdelay` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The amount of time needed between successive right clicks',
MODIFY COLUMN `recasttype` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Unknown - Deals with recast (Item 53267, 2147483647 this is way to big. I''m collapsing it)',
MODIFY COLUMN `guildfavor` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The Guild Favor generated when donated',
MODIFY COLUMN `unknown128` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `UNK123` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK124` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `attuneable` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Is this item attuneable, Flag',
MODIFY COLUMN `nopet` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Can a pet use this item, Flag',
MODIFY COLUMN `unknown133` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown - Deletable',
MODIFY COLUMN `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The date this item was last updated',
MODIFY COLUMN `comment` varchar(255) NOT NULL COMMENT 'A comment, only used by the user during edit in the DB',
MODIFY COLUMN `UNK127` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `pointtype` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1-5 the LDoN point type.',
MODIFY COLUMN `potionbelt` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Can this item be placed on a potionbelt, Flag',
MODIFY COLUMN `potionbeltslots` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Is this container a potionbelt, Flag',
MODIFY COLUMN `stacksize` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The max stacksize of this item.',
MODIFY COLUMN `notransfer` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Can this item be traded, Flat 1 = No Trade',
MODIFY COLUMN `stackable` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Can this item stack, Flag. Uses stacksize as charges if this is false.',
MODIFY COLUMN `UNK134` varchar(255) NOT NULL COMMENT 'Unknown',
MODIFY COLUMN `UNK137` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `proceffect` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The spell ID this item proc''s, -1 means no spell',
MODIFY COLUMN `proctype` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown, has something to do with the proc effect. Possibly a restriction.',
MODIFY COLUMN `proclevel2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Required Lv to use this item, such as throwing items.',
MODIFY COLUMN `proclevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Required Lv to use this items proc, such as a weapon.',
MODIFY COLUMN `UNK142` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `worneffect` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The spell ID this item grants when worn',
MODIFY COLUMN `worntype` enum('0','2') NOT NULL DEFAULT '0' COMMENT 'Worn Type restrictions, 0 and 2',
MODIFY COLUMN `wornlevel2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Required Lv added when this item is used as an augment',
MODIFY COLUMN `wornlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Required Lv to gain the Worn Effect',
MODIFY COLUMN `UNK147` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focustype` enum('0','6') NOT NULL DEFAULT '0' COMMENT 'The focus type, 0 and 6',
MODIFY COLUMN `focuslevel2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focuslevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The level required to gain this focus',
MODIFY COLUMN `UNK152` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrolleffect` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The spell ID this item adds to the spell book when Scribed',
MODIFY COLUMN `scrolltype` enum('0','7') NOT NULL DEFAULT '0' COMMENT 'Scroll Type, 0 and 7',
MODIFY COLUMN `scrolllevel2` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrolllevel` int(11) NOT NULL DEFAULT '0' COMMENT 'The Lv required to scribe this spell',
MODIFY COLUMN `UNK157` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `serialized` datetime DEFAULT NULL COMMENT 'Unknown',
MODIFY COLUMN `verified` datetime DEFAULT NULL COMMENT 'The date this item was verified',
MODIFY COLUMN `serialization` text COMMENT 'Unknown',
MODIFY COLUMN `source` varchar(20) NOT NULL COMMENT 'The source for this item',
MODIFY COLUMN `UNK033` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `lorefile` varchar(32) NOT NULL COMMENT 'Unknown',
MODIFY COLUMN `UNK014` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `svcorruption` smallint(6) NOT NULL DEFAULT '0' COMMENT 'The Corruption Resist stat on the item.',
MODIFY COLUMN `UNK038` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK060` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `augslot1unk2` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `augslot2unk2` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `augslot3unk2` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `augslot4unk2` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `augslot5unk2` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK098` enum('0','70') NOT NULL DEFAULT '70' COMMENT 'Unknown - 0 or 70',
MODIFY COLUMN `UNK109` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK120` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK121` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `questitemflag` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK131` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK132` text NOT NULL COMMENT 'Unknown - No changes due to anomaly',
MODIFY COLUMN `clickunk5` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `clickunk6` varchar(32) NOT NULL COMMENT 'Server Special Item, used in Contest (Unsupported)',
MODIFY COLUMN `clickunk7` mediumint(9) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `procunk1` enum('-1','0','1') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `procunk2` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `procunk3` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `procunk4` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `procunk6` varchar(32) NOT NULL COMMENT 'Unknown',
MODIFY COLUMN `procunk7` enum('-1','0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `wornunk1` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `wornunk2` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `wornunk3` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `wornunk4` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `wornunk5` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `wornunk6` varchar(32) NOT NULL COMMENT 'Unknown',
MODIFY COLUMN `wornunk7` enum('-1','0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focusunk1` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focusunk2` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focusunk3` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focusunk4` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focusunk5` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `focusunk6` varchar(32) NOT NULL COMMENT 'Unknown',
MODIFY COLUMN `focusunk7` enum('-1','0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrollunk1` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrollunk2` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrollunk3` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrollunk4` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrollunk5` enum('0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `scrollunk6` varchar(32) NOT NULL COMMENT 'Unknown',
MODIFY COLUMN `scrollunk7` enum('-1','0') NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `UNK193` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Unknown',
MODIFY COLUMN `purity` int(11) NOT NULL DEFAULT '0' COMMENT 'Unsure - May have something to do with corruption level',
MODIFY COLUMN `evolvinglevel` int(11) NOT NULL DEFAULT '0' COMMENT 'Unused - Something to do with Evolving Items...',
MODIFY COLUMN `UNK129` int(11) NOT NULL DEFAULT '0' COMMENT 'Unknown';

For the latest Release of Echo~De, go to my wiki listed in my sig.