Help Converting Items

[leslamarch]

This should get you to where you want to be, all tested fine on my end but just make sure to test it in case of copy paste errors.

ALTER TABLE `items` 
    CHANGE `color` `color` int(10) unsigned   NOT NULL DEFAULT '0' after `classes`, 
    CHANGE `norent` `norent` int(11)   NOT NULL DEFAULT '0' after `nodrop`, 
    ADD COLUMN `lorefile` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `UNK033`, 
    ADD COLUMN `UNK014` int(11)   NOT NULL DEFAULT '0' after `lorefile`, 
    ADD COLUMN `svcorruption` int(11)   NOT NULL DEFAULT '0' after `UNK014`, 
    ADD COLUMN `UNK038` int(11)   NOT NULL DEFAULT '0' after `svcorruption`, 
    ADD COLUMN `UNK060` int(11)   NOT NULL DEFAULT '0' after `UNK038`, 
    ADD COLUMN `augslot1unk2` int(11)   NOT NULL DEFAULT '0' after `UNK060`, 
    ADD COLUMN `augslot2unk2` int(11)   NOT NULL DEFAULT '0' after `augslot1unk2`, 
    ADD COLUMN `augslot3unk2` int(11)   NOT NULL DEFAULT '0' after `augslot2unk2`, 
    ADD COLUMN `augslot4unk2` int(11)   NOT NULL DEFAULT '0' after `augslot3unk2`, 
    ADD COLUMN `augslot5unk2` int(11)   NOT NULL DEFAULT '0' after `augslot4unk2`, 
    ADD COLUMN `UNK098` int(11)   NOT NULL DEFAULT '0' after `augslot5unk2`, 
    ADD COLUMN `UNK109` int(11)   NOT NULL DEFAULT '0' after `UNK098`, 
    ADD COLUMN `UNK120` int(11)   NOT NULL DEFAULT '0' after `UNK109`, 
    ADD COLUMN `UNK121` int(11)   NOT NULL DEFAULT '0' after `UNK120`, 
    ADD COLUMN `questitemflag` int(11)   NOT NULL DEFAULT '0' after `UNK121`, 
    ADD COLUMN `UNK131` int(11)   NOT NULL DEFAULT '0' after `questitemflag`, 
    ADD COLUMN `UNK132` text  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `UNK131`, 
    ADD COLUMN `clickunk5` int(11)   NOT NULL DEFAULT '0' after `UNK132`, 
    ADD COLUMN `clickunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `clickunk5`, 
    ADD COLUMN `clickunk7` int(11)   NOT NULL DEFAULT '0' after `clickunk6`, 
    ADD COLUMN `procunk1` int(11)   NOT NULL DEFAULT '0' after `clickunk7`, 
    ADD COLUMN `procunk2` int(11)   NOT NULL DEFAULT '0' after `procunk1`, 
    ADD COLUMN `procunk3` int(11)   NOT NULL DEFAULT '0' after `procunk2`, 
    ADD COLUMN `procunk4` int(11)   NOT NULL DEFAULT '0' after `procunk3`, 
    ADD COLUMN `procunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `procunk4`, 
    ADD COLUMN `procunk7` int(11)   NOT NULL DEFAULT '0' after `procunk6`, 
    ADD COLUMN `wornunk1` int(11)   NOT NULL DEFAULT '0' after `procunk7`, 
    ADD COLUMN `wornunk2` int(11)   NOT NULL DEFAULT '0' after `wornunk1`, 
    ADD COLUMN `wornunk3` int(11)   NOT NULL DEFAULT '0' after `wornunk2`, 
    ADD COLUMN `wornunk4` int(11)   NOT NULL DEFAULT '0' after `wornunk3`, 
    ADD COLUMN `wornunk5` int(11)   NOT NULL DEFAULT '0' after `wornunk4`, 
    ADD COLUMN `wornunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `wornunk5`, 
    ADD COLUMN `wornunk7` int(11)   NOT NULL DEFAULT '0' after `wornunk6`, 
    ADD COLUMN `focusunk1` int(11)   NOT NULL DEFAULT '0' after `wornunk7`, 
    ADD COLUMN `focusunk2` int(11)   NOT NULL DEFAULT '0' after `focusunk1`, 
    ADD COLUMN `focusunk3` int(11)   NOT NULL DEFAULT '0' after `focusunk2`, 
    ADD COLUMN `focusunk4` int(11)   NOT NULL DEFAULT '0' after `focusunk3`, 
    ADD COLUMN `focusunk5` int(11)   NOT NULL DEFAULT '0' after `focusunk4`, 
    ADD COLUMN `focusunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `focusunk5`, 
    ADD COLUMN `focusunk7` int(11)   NOT NULL DEFAULT '0' after `focusunk6`, 
    ADD COLUMN `scrollunk1` int(11)   NOT NULL DEFAULT '0' after `focusunk7`, 
    ADD COLUMN `scrollunk2` int(11)   NOT NULL DEFAULT '0' after `scrollunk1`, 
    ADD COLUMN `scrollunk3` int(11)   NOT NULL DEFAULT '0' after `scrollunk2`, 
    ADD COLUMN `scrollunk4` int(11)   NOT NULL DEFAULT '0' after `scrollunk3`, 
    ADD COLUMN `scrollunk5` int(11)   NOT NULL DEFAULT '0' after `scrollunk4`, 
    ADD COLUMN `scrollunk6` varchar(32)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `scrollunk5`, 
    ADD COLUMN `scrollunk7` int(11)   NOT NULL DEFAULT '0' after `scrollunk6`, 
    ADD COLUMN `UNK193` int(11)   NOT NULL DEFAULT '0' after `scrollunk7`, 
    ADD COLUMN `purity` int(11)   NOT NULL DEFAULT '0' after `UNK193`, 
    ADD COLUMN `evolvinglevel` int(11)   NOT NULL DEFAULT '0' after `purity`, 
    ADD COLUMN `UNK129` int(11)   NOT NULL DEFAULT '0' after `evolvinglevel`, 
    ADD COLUMN `clickname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `UNK129`, 
    ADD COLUMN `procname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `clickname`, 
    ADD COLUMN `wornname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `procname`, 
    ADD COLUMN `focusname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `wornname`, 
    ADD COLUMN `scrollname` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `focusname`, 
    ADD COLUMN `dsmitigation` smallint(6)   NOT NULL DEFAULT '0' after `scrollname`, 
    ADD COLUMN `heroic_str` smallint(6)   NOT NULL DEFAULT '0' after `dsmitigation`, 
    ADD COLUMN `heroic_int` smallint(6)   NOT NULL DEFAULT '0' after `heroic_str`, 
    ADD COLUMN `heroic_wis` smallint(6)   NOT NULL DEFAULT '0' after `heroic_int`, 
    ADD COLUMN `heroic_agi` smallint(6)   NOT NULL DEFAULT '0' after `heroic_wis`, 
    ADD COLUMN `heroic_dex` smallint(6)   NOT NULL DEFAULT '0' after `heroic_agi`, 
    ADD COLUMN `heroic_sta` smallint(6)   NOT NULL DEFAULT '0' after `heroic_dex`, 
    ADD COLUMN `heroic_cha` smallint(6)   NOT NULL DEFAULT '0' after `heroic_sta`, 
    ADD COLUMN `healamt` smallint(6)   NOT NULL DEFAULT '0' after `heroic_cha`, 
    ADD COLUMN `spelldmg` smallint(6)   NOT NULL DEFAULT '0' after `healamt`, 
    ADD COLUMN `clairvoyance` smallint(6)   NOT NULL DEFAULT '0' after `spelldmg`, 
    ADD COLUMN `backstabdmg` smallint(6)   NOT NULL DEFAULT '0' after `clairvoyance`, 
    ADD COLUMN `created` varchar(64)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `backstabdmg`, 
    ADD KEY `minstatus`(`minstatus`), COMMENT='';