ALTER TABLE `base_info` ADD `shop_id` INT(11) NOT NULL AFTER `user_id`; ALTER TABLE `management_info` ADD `shop_id` INT(11) NOT NULL AFTER `user_id`; ALTER TABLE `honor_information` ADD `shop_id` INT(11) NOT NULL AFTER `user_id`;