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

alter table merchant_lease_items change player_id owner_id int;
alter table merchant_lease_items add enchant_level decimal(2,0) after count;
alter table merchant_lease_items add loc varchar(10) after enchant_level;
alter table merchant_lease_items add loc_data decimal(10,0) after loc;    
update merchant_lease_items set loc="LEASE";
update merchant_lease_items set loc_data=merchant_id;
alter table merchant_lease_items change sell price_sell int;
alter table merchant_lease_items change buy price_buy int;
alter table merchant_lease_items drop max;
alter table merchant_lease_items drop merchant_id;

insert items select * from character_inventory;
insert items select * from character_warehouse;
insert items select * from clan_warehouse;
insert items select * from pet_inventory;
insert items select * from merchant_lease_items;