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.
Code:
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='';