upgrade.sql 1.2 KB

12345678910111213
  1. ALTER TABLE `site_shop` MODIFY COLUMN `business_license` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '营业执照' AFTER `alipay_account_no`;
  2. ALTER TABLE `site_shop_apply` MODIFY COLUMN `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商户名称' AFTER `member_id`;
  3. ALTER TABLE `site_shop_apply` MODIFY COLUMN `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户姓名' AFTER `site_name`;
  4. ALTER TABLE `site_shop_apply` MODIFY COLUMN `user_mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户手机号' AFTER `user_name`;
  5. ALTER TABLE `site_shop_apply` MODIFY COLUMN `business_license` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '营业执照图片路径' AFTER `group_id`;
  6. ALTER TABLE `sys_poster` ADD COLUMN `is_default` int NOT NULL DEFAULT 0 COMMENT '是否默认' AFTER `addon`;
  7. ALTER TABLE `weapp_version` ADD COLUMN `from_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'cloud_build' AFTER `task_key`;