# sql 变更记录 2021.12.8 =========lqh 2021.12.8 ALTER TABLE `xhXj` ADD COLUMN `shopId` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '门店ID' AFTER `status`, ADD INDEX `idx_shopId` (`shopId`) USING BTREE ;