1.9.16.sql
10.4 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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `p_is_top` int NULL DEFAULT 0 COMMENT '厂牌活动列表内是否置顶' AFTER `publish_at`;
ALTER TABLE `hi-sing`.`group_has_members` MODIFY COLUMN `is_top` int NOT NULL DEFAULT 0 COMMENT '是否置顶' AFTER `member_id`;
CREATE TABLE `hi-sing`.`job_batches` (
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`total_jobs` int NOT NULL,
`pending_jobs` int NOT NULL,
`failed_jobs` int NOT NULL,
`failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
`cancelled_at` int NULL DEFAULT NULL,
`created_at` int NOT NULL,
`finished_at` int NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
ALTER TABLE `hi-sing`.`notification_users` COMMENT = '系统通知对象';
ALTER TABLE `hi-sing`.`notification_users` ADD COLUMN `msg_key` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'MsgKey' AFTER `status`;
ALTER TABLE `hi-sing`.`notifications` COMMENT = '系统通知';
ALTER TABLE `hi-sing`.`notifications` ADD COLUMN `is_alert` tinyint UNSIGNED NULL DEFAULT 0 COMMENT '是否弹窗' AFTER `status`;
ALTER TABLE `hi-sing`.`notifications` MODIFY COLUMN `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态[-1:发送失败 0:待发送，1:发送中 2:发送成功, 3:撤回成功]' AFTER `publish_at`;
CREATE TABLE `hi-sing`.`project_dynamics` (
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
`project_id` bigint UNSIGNED NOT NULL DEFAULT 0,
`type` enum('image','audio','video') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'image' COMMENT '1:图片 2:视频 3:音频',
`intro` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述内容',
`properties` json NULL COMMENT '内容属性',
`is_top` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否置顶',
`created_at` datetime NULL DEFAULT NULL,
`updated_at` datetime NULL DEFAULT NULL,
`deleted_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
CREATE TABLE `hi-sing`.`project_has_members` (
`id` int NOT NULL AUTO_INCREMENT,
`invite_id` int NOT NULL DEFAULT 0 COMMENT '邀请人id',
`user_id` int NOT NULL DEFAULT 0 COMMENT '被邀请人id',
`project_id` int NOT NULL DEFAULT 0 COMMENT '厂牌id',
`status` int NOT NULL DEFAULT 0 COMMENT '0:待处理 1：成功 2：拒绝 3：申请退出 4:失效',
`is_top` int UNSIGNED NULL DEFAULT 0 COMMENT '是否置顶',
`created_at` datetime NULL DEFAULT NULL,
`updated_at` datetime NULL DEFAULT NULL,
`deleted_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
CREATE TABLE `hi-sing`.`project_visitors` (
`id` int NOT NULL AUTO_INCREMENT,
`project_id` int NOT NULL DEFAULT 0 COMMENT '厂牌id',
`user_id` int NOT NULL DEFAULT 0 COMMENT '用户id',
`created_at` datetime NULL DEFAULT NULL,
`updated_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
ALTER TABLE `hi-sing`.`projects` ADD COLUMN `head_cover` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头部封面' AFTER `name`;
ALTER TABLE `hi-sing`.`system_http_logs` MODIFY COLUMN `method` enum('GET','POST','PUT','DELETE','OPTIONS','HEAD') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GET' AFTER `user_id`;
ALTER TABLE `hi-sing`.`system_tags` ADD COLUMN `is_show` tinyint UNSIGNED NULL DEFAULT 1 COMMENT '是否显示' AFTER `user_id`;
ALTER TABLE `hi-sing`.`telescope_entries_tags` DROP FOREIGN KEY `telescope_entries_tags_entry_uuid_foreign`;
ALTER TABLE `hi-sing`.`telescope_entries_tags` ADD CONSTRAINT `telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `hi-sing`.`telescope_entries` (`uuid`) ON DELETE CASCADE ON UPDATE RESTRICT;
ALTER TABLE `hi-sing`.`tidings_has_reports` MODIFY COLUMN `type` tinyint NULL DEFAULT 1 COMMENT '1:广场动态类 2:评论类 3：用户举报 4：个人图片视频音频举报 5：厂牌图片视频音频举报' AFTER `user_id`;
ALTER TABLE `hi-sing`.`user_has_projects` DROP INDEX `user`;
ALTER TABLE `hi-sing`.`user_has_projects` ADD COLUMN `created_at` datetime NULL DEFAULT NULL AFTER `project_id`;
ALTER TABLE `hi-sing`.`user_has_projects` ADD COLUMN `updated_at` datetime NULL DEFAULT NULL AFTER `created_at`;
ALTER TABLE `hi-sing`.`user_has_projects` ADD UNIQUE INDEX `user`(`user_id` ASC, `project_id` ASC) USING BTREE;
SET FOREIGN_KEY_CHECKS=1;
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('127', '12', '0', '厂牌邀请限制时间', '7SrpXqHNr2mcnKGfZhfoK', '0.00001', '{\"type\": \"input\"}', '', '1', '0', '2023-08-18 14:15:25', '2023-08-22 10:58:50', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('128', '12', '0', '厂牌邀请处理时间限制', 'VnyE3PTXOUPDEb4WZLBjM', '7', '{\"type\": \"input\"}', '', '1', '0', '2023-08-21 11:55:57', '2023-08-21 11:55:57', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('129', '12', '0', '厂牌自动退出时间限制', 'i9V0wD_FitcGXR3HxUK5C', '7', '{\"type\": \"input\"}', '', '1', '0', '2023-08-23 15:07:07', '2023-08-23 15:07:07', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('130', '12', '0', '厂牌头部封面推荐', 'GXew2NTIasx-WcxHzAwNn', '', '{\"type\": \"none\"}', '', '1', '0', '2023-08-23 17:23:56', '2023-08-23 17:23:56', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('131', '12', '130', '1', 'JjJtbTUCdz75h_bj3AkfJ', 'https://hi-sing-cdn-dev.hikoon.com/file/20230823/xqz4dg21az1692782680942105fmgvyv5me.png', '{\"type\": \"image\"}', '', '1', '0', '2023-08-23 17:24:50', '2023-08-23 17:24:50', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('132', '12', '130', '2', 'z-uONCojnm2WtBiv6wIc8', 'https://hi-sing-cdn-dev.hikoon.com/file/20230823/zxp53ipd5gc16927827113731hx8yep549r.png', '{\"type\": \"image\"}', '', '1', '0', '2023-08-23 17:25:13', '2023-08-23 17:25:13', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('133', '12', '130', '3', 'T6FANNtK02E2kZxxrVLZp', 'https://hi-sing-cdn-dev.hikoon.com/file/20230823/sk4box3rad1692782725765qonvmx8axfo.png', '{\"type\": \"image\"}', '', '1', '0', '2023-08-23 17:25:28', '2023-08-23 17:25:28', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('134', '12', '0', '厂牌音频封面推荐', 'VnWgh0scPvzRMGDC-M0Xz', '', '{\"type\": \"none\"}', '', '1', '0', '2023-08-23 17:25:45', '2023-08-23 17:25:45', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('135', '12', '134', '1', '0YUiG1WGtJmMQIN3amTNz', 'https://hi-sing-cdn-dev.hikoon.com/file/20230823/638gplmjzyw16927827652905194onbfefu.jpg', '{\"type\": \"image\"}', '', '1', '0', '2023-08-23 17:26:07', '2023-08-23 17:26:07', NULL);
INSERT INTO `hi-sing`.`system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('136', '12', '134', '2', 'hizLulw-cs1apAP6b74pv', 'https://hi-sing-cdn-dev.hikoon.com/file/20230823/oxokr1qt8ms1692782779544aabiu1kqc66.jpg', '{\"type\": \"image\"}', '', '1', '0', '2023-08-23 17:26:21', '2023-08-23 17:26:21', NULL);