Code:
ALTER TABLE items CHANGE loreflag loregroup int NOT NULL;
ALTER TABLE items CHANGE UNK117 UNK123 int NOT NULL;
ALTER TABLE items CHANGE UNK150 UNK157 int NOT NULL;
ALTER TABLE items CHANGE UNK145 UNK152 int NOT NULL;
ALTER TABLE items CHANGE UNK140 UNK147 int NOT NULL;
ALTER TABLE items CHANGE UNK135 UNK142 int NOT NULL;
ALTER TABLE items CHANGE UNK130 UNK137 int NOT NULL;
ALTER TABLE items CHANGE UNK124 UNK130 int NOT NULL;
ALTER TABLE items CHANGE UNK121 UNK127 int NOT NULL;
ALTER TABLE items CHANGE UNK118 UNK124 int NOT NULL;
ALTER TABLE items ADD augslot1unk int NOT NULL AFTER augslot1type;
ALTER TABLE items ADD augslot2unk int NOT NULL AFTER augslot2type;
ALTER TABLE items ADD augslot3unk int NOT NULL AFTER augslot3type;
ALTER TABLE items ADD augslot4unk int NOT NULL AFTER augslot4type;
ALTER TABLE items ADD augslot5unk int NOT NULL AFTER augslot5type;
ALTER TABLE items ADD enduranceregen int NOT NULL AFTER manaregen;
ALTER TABLE items ADD notransfer int NOT NULL AFTER stacksize;
ALTER TABLE items ADD UNK133 int NOT NULL AFTER notransfer;
ALTER TABLE items ADD UNK134 varchar(255) NOT NULL AFTER UNK133;
ALTER TABLE items CHANGE UNK130 potionbeltslots int NOT NULL;
ALTER TABLE items CHANGE UNK133 stackable int NOT NULL;