1.9.10.sql
10 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `hi-sing`.`activity_has_users` MODIFY COLUMN `is_hide` tinyint NULL DEFAULT 1 COMMENT '是否隐藏：1是 0否' AFTER `sing_type`;
CREATE TABLE `hi-sing`.`activity_links` (
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
`activity_id` bigint UNSIGNED NOT NULL DEFAULT 0,
`type` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`) USING BTREE
) CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `lang` json NULL COMMENT '语种' AFTER `cover`;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `speed` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '语速要求' AFTER `lang`;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `sex` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '性别要求' AFTER `speed`;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `mark` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角标' AFTER `sex`;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `expand` json NULL COMMENT '扩展字段' AFTER `clip_lyric`;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `estimate_release_at` date NULL DEFAULT NULL COMMENT '预期发布时间' AFTER `send_at`;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `publish_at` datetime NULL DEFAULT NULL COMMENT '发布时间' AFTER `estimate_release_at`;
ALTER TABLE `hi-sing`.`activitys` MODIFY COLUMN `sub_title` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' AFTER `id`;
ALTER TABLE `hi-sing`.`activitys` MODIFY COLUMN `song_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '歌曲名称' AFTER `sub_title`;
ALTER TABLE `hi-sing`.`activitys` MODIFY COLUMN `weight` int UNSIGNED NOT NULL DEFAULT 30 COMMENT '权重' AFTER `send_url`;
CREATE TABLE `hi-sing`.`project_confirmation_times` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL DEFAULT 0 COMMENT '厂牌id',
`average_day` float(255, 2) NULL DEFAULT NULL,
`created_at` datetime NULL DEFAULT NULL,
`updated_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE `hi-sing`.`user_activity_collections` DROP INDEX `activity`;
ALTER TABLE `hi-sing`.`user_activity_collections` ADD UNIQUE INDEX `activity`(`activity_id` ASC, `user_id` ASC, `deleted_at` ASC) USING BTREE;
ALTER TABLE `hi-sing`.`user_view_activitys` DROP INDEX `activity`;
ALTER TABLE `hi-sing`.`user_view_activitys` ADD UNIQUE INDEX `activity`(`activity_id` ASC, `user_id` ASC, `deleted_at` ASC) USING BTREE;
ALTER TABLE `hi-sing`.`users` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`, `sex`) USING BTREE;
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (88, 12, 38, '语种', 'activity_lang', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 16:32:52', '2023-05-04 16:32:52', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (89, 12, 88, '普通话', 'mandarin', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:04:26', '2023-05-04 17:04:26', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (90, 12, 88, '粤语', 'cantonese', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:05:07', '2023-05-04 17:05:07', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (91, 12, 88, '外语', 'foreign', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:08:16', '2023-05-04 17:08:16', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (92, 12, 38, '语速', 'activity_speed', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:16:58', '2023-05-04 17:16:58', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (93, 12, 92, '慢', 'slow', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:17:43', '2023-05-04 17:17:43', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (94, 12, 92, '快', 'fast', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:17:54', '2023-05-04 17:17:54', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (95, 12, 92, '平均', 'medium', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:18:32', '2023-05-04 17:18:32', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (96, 12, 38, '角标', 'activity_mark', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:33:35', '2023-05-04 17:33:35', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (97, 12, 96, '优', 'excellent', 'https://hi-sing-cdn-dev.hikoon.com/file/20230515/w95l8z18c9168414979356950qd4chnrz.png', '{\"type\": \"image\"}', '', 1, 0, '2023-05-04 17:35:15', '2023-05-15 19:23:11', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (98, 12, 96, '急', 'urgent', 'https://hi-sing-cdn-dev.hikoon.com/file/20230515/1n8cxwmjq1r1684149800824wva9zrdwvx.png', '{\"type\": \"image\"}', '', 1, 0, '2023-05-04 17:35:41', '2023-05-15 19:23:18', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (99, 12, 38, '性别要求', 'activity_sex', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:58:04', '2023-05-04 17:58:04', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (100, 12, 99, '男', 'male', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:58:44', '2023-05-04 17:58:44', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (101, 12, 99, '女', 'female', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 17:59:04', '2023-05-04 17:59:04', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (102, 12, 99, '男女均可', 'unrestricted', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-04 18:00:30', '2023-05-04 18:00:30', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (103, 12, 38, '上传配置', 'activity_upload', '', '{\"type\": \"none\"}', '', 1, 0, '2023-05-06 16:06:51', '2023-05-06 16:06:51', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (104, 12, 103, '音频格式', 'activity_audio_accept', '.mp3,.mp4,.aac,.wav,.wma,.cda,.flac,.m4a,.mid,.mka,.mp2,.mpa,.mpc,.ape,.ofr,.ogg,.ra,.wv,.tta,.ac3,.dts', '{\"type\": \"textarea\"}', '', 1, 0, '2023-05-06 16:10:25', '2023-05-06 16:11:42', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (105, 12, 103, '分轨格式', 'activity_track_accept', '.zip,.rar,.7z', '{\"type\": \"input\"}', '', 1, 0, '2023-05-06 16:13:52', '2023-05-06 16:14:39', NULL);
INSERT INTO `hi-sing-dev`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (106, 12, 96, '钱', '8z_pXU9BSc4isQ-naCr5N', 'https://hi-sing-cdn-dev.hikoon.com/file/20230515/ghxow2z19xm1684149808360rma81ith38.png', '{\"type\": \"image\"}', '', 1, 0, '2023-05-15 14:48:38', '2023-05-15 19:23:25', NULL);
SET FOREIGN_KEY_CHECKS=1;