20200424.sql 449 B

1234567
  1. -- 活动详情 视频字段
  2. ALTER TABLE `ac_activity_review`
  3. ADD COLUMN `has_video` tinyint(1) NULL DEFAULT 0 COMMENT '是否有视频' AFTER `is_draft`,
  4. ADD COLUMN `video_url` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频地址' AFTER `has_video`,
  5. ADD COLUMN `video_attachment_id` int(11) DEFAULT NULL COMMENT '视频附件uuid' AFTER `video_url`,
  6. DROP PRIMARY KEY,
  7. ADD PRIMARY KEY (`id`) USING BTREE;