Feature

Players will be able to use a special location or skill (probably the latter) to give their items abilities. These abilities are, as of yet, undetermined, but will probably increase probabilities to hit, increase damage/effect, increase defense, add damage types (like setting an enemy ablaze), increase player hp or skills, or add skills (perhaps similar to regen or lifetap). The amount of an increase will be based on the strength of the enchantment lain on it, and may be affected by item 'experience' (how many times that weapon has hit, armour has been hit, etc).

Method

Three tinyint fields could be added to each item record. This would increase the record size by only three bytes, from the current 23 bytes. This would be an acceptable increase.

Alternately, a new table could be created linking items to their abilities. This would result in up to three 5 byte records for each item (15 total for each), but they would only exist for items with abilities. Additionally, this would decrease development and execution time.