bc518174
 王天杨
提交两个项目文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
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`);
|
