#查询索引showindexfromuser;#删除索引dropindex mobile on shop_user;#创建索引,unique index是唯一索引,不写unique默认为normal BTREE索引createuniqueindex shop_id_mobile on shop_user(shop_id,mobile);
alter table shop_user add column shop_id bigint(64) COMMENT '门店id';#特殊情况:用户是A门店的管理员,B门店的普通用户,手机号会重复drop index mobile on shop_user;create unique index shop_id_mobile on shop_user(shop_id,mobile);#之前的老用户都给管理员alter table shop_user add column role int(11)