2.0.2.sql
5.53 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
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `hi-sing`.`system_http_logs` MODIFY COLUMN `method` enum('GET','POST','PUT','DELETE','OPTIONS','HEAD','PATCH') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GET' AFTER `user_id`;
CREATE TABLE `hi-sing`.`user_share` (
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
`from_id` bigint UNSIGNED NOT NULL DEFAULT 0,
`to_id` bigint UNSIGNED NOT NULL DEFAULT 0,
`subject_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`subject_id` bigint UNSIGNED NOT NULL DEFAULT 0,
`created_at` datetime NULL DEFAULT NULL,
`updated_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `from`(`from_id` ASC) USING BTREE,
INDEX `subject`(`subject_type` ASC, `subject_id` ASC) USING BTREE,
INDEX `to`(`to_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
INSERT INTO `system_config` (`id`, `creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`)
VALUES
(174, 12, 171, '电脑上传操作视频', 'upload_manual_pc', 'https://hi-sing-cdn-dev.hikoon.com/file/20231228/axbeas48len1703740712858p0cjy5yh2lk.mp4', '{\"type\": \"video\"}', NULL, 1, 0, '2023-12-27 11:10:10', '2023-12-28 13:18:34', NULL),
(173, 12, 171, 'iCloud上传操作视频', 'upload_manual_icloud', 'https://hi-sing-cdn-dev.hikoon.com/file/20231228/vkvgkhgo8u17037407917140u2xhqp29yzm.mp4', '{\"type\": \"video\"}', NULL, 1, 0, '2023-12-27 11:09:32', '2023-12-28 13:19:53', NULL),
(172, 12, 171, '微信上传操作视频', 'upload_manual_wechat', 'https://hi-sing-cdn-dev.hikoon.com/file/20231228/54gtgxykbzt1703740799965u7rlo3n7qzp.mp4', '{\"type\": \"video\"}', NULL, 1, 0, '2023-12-27 11:08:46', '2023-12-28 13:20:00', NULL),
(171, 12, 0, '音频上传操作视频', 'zV7FxR7xalrChowAY9_uY', '', '{\"type\": \"none\"}', NULL, 1, 0, '2023-12-27 11:00:30', '2023-12-27 11:00:30', NULL),
(170, 12, 169, '上传配置', 'D2U8DkGdJUK7YlTyLou8Q', '.mp3,.wav', '{\"type\": \"input\"}', '', 1, 0, '2023-12-20 17:07:55', '2023-12-20 17:08:18', NULL),
(169, 12, 0, 'Web上传页面', 'BQaTbejp1e3oOjFWukkSO', '', '{\"type\": \"none\"}', NULL, 1, 0, '2023-12-20 17:06:24', '2023-12-20 17:06:24', NULL),
(168, 12, 169, '客服二维码', 'mawujfMPKtRrRvzUOxvWM', 'https://hi-sing-cdn.hikoon.com/file/20231218/qonv00zdn61702879102246mq3v9f9ia49.png', '{\"type\": \"image\"}', NULL, 1, 0, '2023-12-20 16:59:06', '2023-12-20 16:59:06', NULL),
(167, 12, 0, 'LOGO', 'logo', 'https://hi-sing-cdn.hikoon.com/file/20231220/1h33on9f5oz17030629842443h73lp8ix3l.png', '{\"type\": \"image\"}', NULL, 1, 999, '2023-12-20 10:05:00', '2023-12-20 10:05:00', NULL);
INSERT INTO `system_permissions` (`id`, `guard`, `parent_id`, `name`, `label`, `type`, `icon`, `weight`, `is_show_line`, `created_at`, `updated_at`, `deleted_at`)
VALUES
(231, 'Admin', 173, 'audition-project-show-demo-delete', '删除', 'Button', '', 30, 0, '2023-11-06 15:35:23', '2023-11-06 15:35:24', NULL),
(230, 'Admin', 173, 'audition-project-show-demo-show', '详情', 'Button', '', 90, 0, '2023-11-06 15:37:08', '2023-11-06 15:37:10', NULL),
(229, 'Admin', 173, 'audition-project-show-demo-edit', '编辑', 'Button', '', 70, 0, '2023-11-06 15:35:23', '2023-11-06 15:35:24', NULL),
(228, 'Admin', 173, 'audition-project-show-demo-status', '上架/下架', 'Button', '', 60, 0, '2023-11-06 15:34:55', '2023-11-06 15:34:57', NULL),
(227, 'Admin', 173, 'audition-project-show-demo-export', '导出', 'Button', '', 10, 0, '2023-11-06 15:34:24', '2023-11-06 15:34:26', NULL),
(226, 'Admin', 173, 'audition-project-show-demo-create', '新增', 'Button', '', 80, 0, '2023-11-06 15:32:59', '2023-11-06 15:33:01', NULL),
(225, 'Admin', 79, 'audition-project-show-demo', 'Demo列表', 'Button', '', 85, 1, '2023-12-12 22:56:40', '2023-12-12 22:56:40', NULL),
(224, 'Admin', 216, 'audition-demo-edit', '编辑', 'Button', '', 70, 0, '2023-12-11 16:59:51', '2023-12-11 16:59:51', NULL),
(223, 'Admin', 216, 'audition-demo-status', '变更状态', 'Button', '', 60, 0, '2023-12-11 16:51:22', '2023-12-11 16:51:22', NULL),
(222, 'Admin', 216, 'audition-demo-create', '新增', 'Button', '', 80, 0, '2023-12-11 16:16:23', '2023-12-11 16:16:23', NULL),
(221, 'Admin', 216, 'audition-demo-export', '导出', 'Button', '', 40, 0, '2023-12-11 16:13:45', '2023-12-11 16:13:45', NULL),
(220, 'Admin', 217, 'audition-demo-show-like-user', '收藏用户', 'Button', '', 70, 0, '2023-12-11 15:31:13', '2023-12-11 15:31:13', NULL),
(219, 'Admin', 217, 'audition-demo-show-view-user', '试听用户', 'Button', '', 80, 0, '2023-12-11 15:30:33', '2023-12-11 15:30:33', NULL),
(218, 'Admin', 217, 'audition-demo-show-material', '物料列表', 'Button', '', 90, 0, '2023-12-11 15:29:26', '2023-12-11 15:29:26', NULL),
(217, 'Admin', 216, 'audition-demo-show', '详情', 'Button', '', 90, 1, '2023-12-11 15:26:52', '2023-12-11 15:26:52', NULL),
(216, 'Admin', 7, 'audition-demo', 'Demo管理', 'Menu', '', 60, 1, '2023-12-11 11:16:41', '2023-12-11 11:16:41', NULL);
SET FOREIGN_KEY_CHECKS=1;