CREATE TABLE IF NOT EXISTS `dc_download_asset` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(32) NOT NULL COMMENT 'certificate|guide',
  `image_url` varchar(512) NOT NULL DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='下载证书/攻略素材配置';

INSERT INTO `dc_download_asset` (`type`, `image_url`, `create_time`, `update_time`)
VALUES
('certificate', '/static/certificate-dialog-bg.png', NOW(), NOW()),
('guide', '/static/daocheng-yading-map.png', NOW(), NOW())
ON DUPLICATE KEY UPDATE
`image_url` = VALUES(`image_url`),
`update_time` = VALUES(`update_time`);

