alter table pets drop runSpd;
alter table pets drop walkSpd;
alter table pets drop heading;
alter table pets drop x;
alter table pets drop y;
alter table pets drop z;
alter table pets drop unk1;
alter table pets drop unk2;
alter table pets drop colRad;
alter table pets drop colHeight;
alter table pets drop pvpkills;
alter table pets drop npc_id;
-- update characters set clanid = "";
alter table accounts add lastIP varchar (20);
ALTER TABLE `character_shortcuts` ADD `page` decimal(3,0) DEFAULT '0' NOT NULL AFTER `slot`;
ALTER TABLE `characters` ADD `rec_have` INT( 3 ) DEFAULT '0' NOT NULL AFTER `allyId` , ADD `rec_left` INT( 3 ) DEFAULT '0' NOT NULL AFTER `rec_have`;
alter table `characters` add `maxCp` decimal(11,0) default NULL after `curHP` , add `curCp` decimal(18,0) default NULL after `maxCP`, add `newbie` decimal(1,0) default '1' after `char_slot`, add `lastAccess` decimal(20,0) default NULL after `newbie`;
UPDATE `characters` SET `rec_left`=3 WHERE `level` BETWEEN 10 AND 19;
UPDATE `characters` SET `rec_left`=6 WHERE `level` BETWEEN 20 AND 29;
UPDATE `characters` SET `rec_left`=8 WHERE `level` BETWEEN 30 AND 39;
UPDATE `characters` SET `rec_left`=10 WHERE `level` BETWEEN 40 AND 49;
UPDATE `characters` SET `rec_left`=13 WHERE `level` BETWEEN 50 AND 59;
UPDATE `characters` SET `rec_left`=18 WHERE `level` BETWEEN 60 AND 69;
UPDATE `characters` SET `rec_left`=25 WHERE `level` BETWEEN 70 AND 74;
UPDATE `characters` SET `rec_left`=34 WHERE `level` >= 75;
alter table character_inventory add temp int auto_increment after object_id, add primary key (temp), drop primary key;
update character_inventory set temp=temp+600000000;
alter table character_inventory drop object_id;
alter table character_inventory change temp object_id int;
alter table character_inventory change char_obj_id owner_id int;
alter table character_inventory drop name;
alter table character_inventory drop equipslot;
alter table character_inventory add loc varchar(10);
alter table character_inventory add loc_data decimal(10,0);
alter table character_inventory add price_sell decimal(10,0);
alter table character_inventory add price_buy decimal(10,0);
update character_inventory set loc="INVENTORY";
update character_inventory set loc_data=0;
update character_inventory set price_sell=0;
update character_inventory set price_buy=0;
alter table character_warehouse add temp int auto_increment after object_id, add primary key (temp), drop primary key;
update character_warehouse set temp=temp+800000000;
alter table character_warehouse drop object_id;
alter table character_warehouse change temp object_id int;
alter table character_warehouse change char_obj_id owner_id int;
alter table character_warehouse drop name;
alter table character_warehouse add loc varchar(10);
alter table character_warehouse add loc_data decimal(10,0);
alter table character_warehouse add price_sell decimal(10,0);
alter table character_warehouse add price_buy decimal(10,0);
update character_warehouse set loc="WAREHOUSE";
update character_warehouse set loc_data=0;
update character_warehouse set price_sell=0;
update character_warehouse set price_buy=0;
alter table clan_warehouse add owner_id decimal(10,0) first;
update clan_warehouse,clan_data set clan_warehouse.owner_id=clan_data.leader_id where clan_warehouse.clan_id=clan_data.clan_id;
alter table clan_warehouse drop name;
alter table clan_warehouse add loc varchar(10);
alter table clan_warehouse add loc_data decimal(10,0);
alter table clan_warehouse add price_sell decimal(10,0);
alter table clan_warehouse add price_buy decimal(10,0);
update clan_warehouse set loc="CLANWH";
update clan_warehouse set loc_data=clan_id;
update clan_warehouse set price_sell=0;
update clan_warehouse set price_buy=0;
alter table clan_warehouse drop clan_id;
alter table pet_inventory add owner_id decimal(10,0) first;
-- update pet_inventory,pets set pet_inventory.owner_id=pets.objid where pet_inventory.pet_obj_id=pets.objid; -- this is bad, needs to be done properly
alter table pet_inventory drop name;
alter table pet_inventory add loc varchar(10);
alter table pet_inventory add loc_data decimal(10,0);
alter table pet_inventory add price_sell decimal(10,0);
alter table pet_inventory add price_buy decimal(10,0);
update pet_inventory set loc="PET";
update pet_inventory set loc_data=pet_obj_id;
update pet_inventory set price_sell=0;
update pet_inventory set price_buy=0;
alter table pet_inventory drop pet_obj_id;
alter table pet_inventory drop equipslot;
insert items select * from character_inventory;
insert items select * from character_warehouse;
insert items select * from clan_warehouse;
insert items select * from pet_inventory;
alter table `items` add `time_of_use` INT after `price_buy`;
drop table character_inventory;
drop table character_warehouse;
drop table clan_warehouse;
drop table pet_inventory;