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;
-- need a command that sets owner id from clan_data --
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;
-- need a command that sets owner_id from pets --
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;

-- now insert all five tables into items --