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`;

alter `items` add `time_of_use` INT after `price_buy`; 

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; 

drop table character_inventory;
drop table character_warehouse;
drop table clan_warehouse;
drop table pet_inventory;