agent_inc_20220406_1.sql 1.3 KB

123456789101112131415161718192021222324252627
  1. ALTER TABLE `ag_app`
  2. MODIFY COLUMN `app_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'app包名';
  3. ALTER TABLE `ag_app_deduction_rule`
  4. MODIFY COLUMN `app_uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'app_uid';
  5. ALTER TABLE `ag_app_deduction_rule`
  6. MODIFY COLUMN `uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL;
  7. ALTER TABLE `ag_app_pack`
  8. MODIFY COLUMN `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'uid';
  9. ALTER TABLE `ag_app_pack`
  10. MODIFY COLUMN `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '代理UID';
  11. ALTER TABLE `ag_app_pack`
  12. MODIFY COLUMN `channel_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '渠UID';
  13. ALTER TABLE `ag_app_pack`
  14. MODIFY COLUMN `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '母包UID';
  15. ALTER TABLE `ag_app_pack`
  16. MODIFY COLUMN `mom_app_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '母包app包名';
  17. ALTER TABLE `ag_share_urls`
  18. MODIFY COLUMN `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '母包应用uid';