zhumj/db/migrate004.sql

alter table individual_rent add column bed_name varchar(255);
alter table individual_rent add column name varchar(255);
alter table individual_rent add column room_name varchar(255);
alter table individual_rent add column store_name varchar(255);

update individual_rent join store_info on individual_rent.store_id = store_info.id
set individual_rent.store_name = store_info.store_name;

update individual_rent join room_info on individual_rent.room_id = room_info.id
set individual_rent.room_name = room_info.room_name;

update individual_rent join bed_info on individual_rent.bed_id = bed_info.id
set individual_rent.bed_name = bed_info.bed_name;

update individual_rent join checkin_info on individual_rent.checkin_id = checkin_info.id
set individual_rent.name = checkin_info.name;