/* Navicat Premium Data Transfer Source Server : 192.168.1.8 Source Server Type : MySQL Source Server Version : 100233 Source Host : 127.0.0.1:3306 Source Schema : zhangsiye_db Target Server Type : MySQL Target Server Version : 100233 File Encoding : 65001 Date: 05/08/2022 16:39:42 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_admin_extension_histories -- ---------------------------- DROP TABLE IF EXISTS `t_admin_extension_histories`; CREATE TABLE `t_admin_extension_histories` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint(4) NOT NULL DEFAULT 1, `version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `t_admin_extension_histories_name_index`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_admin_extensions -- ---------------------------- DROP TABLE IF EXISTS `t_admin_extensions`; CREATE TABLE `t_admin_extensions` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `is_enabled` tinyint(4) NOT NULL DEFAULT 0, `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_admin_extensions_name_unique`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_admin_menu -- ---------------------------- DROP TABLE IF EXISTS `t_admin_menu`; CREATE TABLE `t_admin_menu` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) NOT NULL DEFAULT 0, `order` int(11) NOT NULL DEFAULT 0, `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `extension` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `show` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin_menu -- ---------------------------- INSERT INTO `t_admin_menu` VALUES (1, 0, 1, 'Index', 'feather icon-bar-chart-2', '/', '', 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_menu` VALUES (2, 0, 2, 'Admin', 'feather icon-settings', '', '', 1, '2022-07-28 19:42:42', '2022-08-03 17:34:21'); INSERT INTO `t_admin_menu` VALUES (3, 2, 3, 'Users', '', 'auth/users', '', 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_menu` VALUES (4, 2, 4, 'Roles', '', 'auth/roles', '', 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_menu` VALUES (5, 2, 5, 'Permission', '', 'auth/permissions', '', 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_menu` VALUES (6, 2, 6, 'Menu', '', 'auth/menu', '', 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_menu` VALUES (7, 2, 7, 'Extensions', '', 'auth/extensions', '', 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_menu` VALUES (8, 0, 8, '程序管理', 'fa-codepen', '/program', '', 1, '2022-08-03 12:00:14', '2022-08-03 12:00:14'); INSERT INTO `t_admin_menu` VALUES (9, 0, 13, '短剧管理', 'fa-video-camera', '/episodes', '', 1, '2022-08-03 17:19:43', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (10, 0, 16, '订单管理', 'fa-reorder', '/order', '', 1, '2022-08-03 17:22:38', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (11, 0, 19, '用户管理', 'fa-users', '/users', '', 1, '2022-08-03 17:23:21', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (12, 0, 20, '营销中心', 'fa-area-chart', '/market', '', 1, '2022-08-03 17:24:12', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (13, 12, 21, '会员', NULL, '/market/member', '', 1, '2022-08-03 17:26:08', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (14, 12, 22, '金币', NULL, '/market/glod', '', 1, '2022-08-03 17:26:51', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (15, 0, 23, '设置', 'fa-gears', '/setting', '', 1, '2022-08-03 17:31:55', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (16, 15, 24, '基础设置', NULL, '/setting/base', '', 1, '2022-08-03 17:32:16', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (17, 15, 25, '订单设置', NULL, '/setting/order', '', 1, '2022-08-03 17:32:39', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (18, 15, 26, '支付设置', NULL, '/setting/pay', '', 1, '2022-08-03 17:33:23', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (19, 15, 27, '消息提醒', NULL, '/setting/tips', '', 1, '2022-08-03 17:33:58', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (20, 10, 17, '充值订单', NULL, '/order/recharge', '', 1, '2022-08-03 21:49:57', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (21, 10, 18, '消费记录', NULL, '/order/episodes', '', 1, '2022-08-03 21:50:56', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (22, 9, 14, '分类', NULL, '/episodes/category', '', 1, '2022-08-03 22:00:35', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (23, 9, 15, '短剧', NULL, '/episodes/lists', '', 1, '2022-08-03 22:00:56', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (24, 8, 10, '导航图标', NULL, '/program/navbar', '', 1, '2022-08-05 15:21:07', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (25, 8, 11, '标签栏', NULL, '/program/tabbar', '', 1, '2022-08-05 15:22:03', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (26, 8, 12, '首页布局', NULL, '/program/home_column', '', 1, '2022-08-05 15:23:01', '2022-08-05 15:35:50'); INSERT INTO `t_admin_menu` VALUES (27, 8, 9, '轮播图', NULL, '/program/banner', '', 1, '2022-08-05 15:24:04', '2022-08-05 15:35:50'); -- ---------------------------- -- Table structure for t_admin_permission_menu -- ---------------------------- DROP TABLE IF EXISTS `t_admin_permission_menu`; CREATE TABLE `t_admin_permission_menu` ( `permission_id` bigint(20) NOT NULL, `menu_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, UNIQUE INDEX `t_admin_permission_menu_permission_id_menu_id_unique`(`permission_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_admin_permissions -- ---------------------------- DROP TABLE IF EXISTS `t_admin_permissions`; CREATE TABLE `t_admin_permissions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `http_method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `http_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `order` int(11) NOT NULL DEFAULT 0, `parent_id` bigint(20) NOT NULL DEFAULT 0, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_admin_permissions_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin_permissions -- ---------------------------- INSERT INTO `t_admin_permissions` VALUES (1, 'Auth management', 'auth-management', '', '', 1, 0, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_permissions` VALUES (2, 'Users', 'users', '', '/auth/users*', 2, 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_permissions` VALUES (3, 'Roles', 'roles', '', '/auth/roles*', 3, 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_permissions` VALUES (4, 'Permissions', 'permissions', '', '/auth/permissions*', 4, 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_permissions` VALUES (5, 'Menu', 'menu', '', '/auth/menu*', 5, 1, '2022-07-28 19:42:42', NULL); INSERT INTO `t_admin_permissions` VALUES (6, 'Extension', 'extension', '', '/auth/extensions*', 6, 1, '2022-07-28 19:42:42', NULL); -- ---------------------------- -- Table structure for t_admin_role_menu -- ---------------------------- DROP TABLE IF EXISTS `t_admin_role_menu`; CREATE TABLE `t_admin_role_menu` ( `role_id` bigint(20) NOT NULL, `menu_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, UNIQUE INDEX `t_admin_role_menu_role_id_menu_id_unique`(`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin_role_menu -- ---------------------------- INSERT INTO `t_admin_role_menu` VALUES (1, 8, '2022-08-03 12:00:14', '2022-08-03 12:00:14'); INSERT INTO `t_admin_role_menu` VALUES (1, 9, '2022-08-03 17:19:43', '2022-08-03 17:19:43'); INSERT INTO `t_admin_role_menu` VALUES (1, 11, '2022-08-03 17:23:21', '2022-08-03 17:23:21'); INSERT INTO `t_admin_role_menu` VALUES (1, 12, '2022-08-03 17:24:21', '2022-08-03 17:24:21'); INSERT INTO `t_admin_role_menu` VALUES (1, 13, '2022-08-03 17:26:08', '2022-08-03 17:26:08'); INSERT INTO `t_admin_role_menu` VALUES (1, 14, '2022-08-03 17:26:51', '2022-08-03 17:26:51'); INSERT INTO `t_admin_role_menu` VALUES (1, 15, '2022-08-03 17:31:55', '2022-08-03 17:31:55'); INSERT INTO `t_admin_role_menu` VALUES (1, 16, '2022-08-03 17:32:16', '2022-08-03 17:32:16'); INSERT INTO `t_admin_role_menu` VALUES (1, 17, '2022-08-03 17:32:39', '2022-08-03 17:32:39'); INSERT INTO `t_admin_role_menu` VALUES (1, 18, '2022-08-03 17:33:23', '2022-08-03 17:33:23'); INSERT INTO `t_admin_role_menu` VALUES (1, 19, '2022-08-03 17:33:58', '2022-08-03 17:33:58'); INSERT INTO `t_admin_role_menu` VALUES (1, 20, '2022-08-03 21:49:57', '2022-08-03 21:49:57'); INSERT INTO `t_admin_role_menu` VALUES (1, 21, '2022-08-03 21:50:56', '2022-08-03 21:50:56'); INSERT INTO `t_admin_role_menu` VALUES (1, 22, '2022-08-03 22:00:35', '2022-08-03 22:00:35'); INSERT INTO `t_admin_role_menu` VALUES (1, 23, '2022-08-03 22:00:56', '2022-08-03 22:00:56'); INSERT INTO `t_admin_role_menu` VALUES (1, 24, '2022-08-05 15:21:07', '2022-08-05 15:21:07'); INSERT INTO `t_admin_role_menu` VALUES (1, 25, '2022-08-05 15:22:03', '2022-08-05 15:22:03'); INSERT INTO `t_admin_role_menu` VALUES (1, 26, '2022-08-05 15:23:01', '2022-08-05 15:23:01'); INSERT INTO `t_admin_role_menu` VALUES (1, 27, '2022-08-05 15:24:04', '2022-08-05 15:24:04'); INSERT INTO `t_admin_role_menu` VALUES (2, 8, '2022-08-03 12:00:14', '2022-08-03 12:00:14'); INSERT INTO `t_admin_role_menu` VALUES (2, 9, '2022-08-03 17:19:43', '2022-08-03 17:19:43'); INSERT INTO `t_admin_role_menu` VALUES (2, 11, '2022-08-03 17:23:21', '2022-08-03 17:23:21'); INSERT INTO `t_admin_role_menu` VALUES (2, 12, '2022-08-03 17:24:21', '2022-08-03 17:24:21'); INSERT INTO `t_admin_role_menu` VALUES (2, 13, '2022-08-03 17:26:08', '2022-08-03 17:26:08'); INSERT INTO `t_admin_role_menu` VALUES (2, 14, '2022-08-03 17:26:51', '2022-08-03 17:26:51'); INSERT INTO `t_admin_role_menu` VALUES (2, 15, '2022-08-03 17:31:55', '2022-08-03 17:31:55'); INSERT INTO `t_admin_role_menu` VALUES (2, 16, '2022-08-03 17:32:16', '2022-08-03 17:32:16'); INSERT INTO `t_admin_role_menu` VALUES (2, 17, '2022-08-03 17:32:39', '2022-08-03 17:32:39'); INSERT INTO `t_admin_role_menu` VALUES (2, 18, '2022-08-03 17:33:23', '2022-08-03 17:33:23'); INSERT INTO `t_admin_role_menu` VALUES (2, 19, '2022-08-03 17:33:58', '2022-08-03 17:33:58'); INSERT INTO `t_admin_role_menu` VALUES (2, 20, '2022-08-03 21:49:57', '2022-08-03 21:49:57'); INSERT INTO `t_admin_role_menu` VALUES (2, 21, '2022-08-03 21:50:56', '2022-08-03 21:50:56'); INSERT INTO `t_admin_role_menu` VALUES (2, 22, '2022-08-03 22:00:35', '2022-08-03 22:00:35'); INSERT INTO `t_admin_role_menu` VALUES (2, 23, '2022-08-03 22:00:56', '2022-08-03 22:00:56'); INSERT INTO `t_admin_role_menu` VALUES (2, 24, '2022-08-05 15:21:07', '2022-08-05 15:21:07'); INSERT INTO `t_admin_role_menu` VALUES (2, 25, '2022-08-05 15:22:03', '2022-08-05 15:22:03'); INSERT INTO `t_admin_role_menu` VALUES (2, 26, '2022-08-05 15:23:01', '2022-08-05 15:23:01'); INSERT INTO `t_admin_role_menu` VALUES (2, 27, '2022-08-05 15:24:04', '2022-08-05 15:24:04'); -- ---------------------------- -- Table structure for t_admin_role_permissions -- ---------------------------- DROP TABLE IF EXISTS `t_admin_role_permissions`; CREATE TABLE `t_admin_role_permissions` ( `role_id` bigint(20) NOT NULL, `permission_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, UNIQUE INDEX `t_admin_role_permissions_role_id_permission_id_unique`(`role_id`, `permission_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_admin_role_users -- ---------------------------- DROP TABLE IF EXISTS `t_admin_role_users`; CREATE TABLE `t_admin_role_users` ( `role_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, UNIQUE INDEX `t_admin_role_users_role_id_user_id_unique`(`role_id`, `user_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin_role_users -- ---------------------------- INSERT INTO `t_admin_role_users` VALUES (1, 1, '2022-07-28 19:42:42', '2022-07-28 19:42:42'); INSERT INTO `t_admin_role_users` VALUES (2, 2, '2022-08-03 11:52:57', '2022-08-03 11:52:57'); -- ---------------------------- -- Table structure for t_admin_roles -- ---------------------------- DROP TABLE IF EXISTS `t_admin_roles`; CREATE TABLE `t_admin_roles` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_admin_roles_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin_roles -- ---------------------------- INSERT INTO `t_admin_roles` VALUES (1, 'Administrator', 'administrator', '2022-07-28 19:42:42', '2022-07-28 19:42:42'); INSERT INTO `t_admin_roles` VALUES (2, '管理员', 'manager', '2022-08-03 11:52:25', '2022-08-03 11:52:25'); -- ---------------------------- -- Table structure for t_admin_settings -- ---------------------------- DROP TABLE IF EXISTS `t_admin_settings`; CREATE TABLE `t_admin_settings` ( `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`slug`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_admin_users -- ---------------------------- DROP TABLE IF EXISTS `t_admin_users`; CREATE TABLE `t_admin_users` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `username` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_admin_users_username_unique`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin_users -- ---------------------------- INSERT INTO `t_admin_users` VALUES (1, 'admin', '$2y$10$/9vpLfzQknmBuNKTjYu4W.O7Ku7PUqdRGxbQ9/vlRxjkZJbiN8y.C', 'Administrator', NULL, 'CDOg1MmKgKnqmABURtuiewU8gjy14uj81hfC9sicUbsxfnkXJZYaKPfQGAO4', '2022-07-28 19:42:42', '2022-07-28 19:42:42'); INSERT INTO `t_admin_users` VALUES (2, 'manager', '$2y$10$8OdG5k211/DGzkBNsd5IfeUjKDqUIEhgxf/bhZoStmBsDaLMAheNO', '管理员', NULL, NULL, '2022-08-03 11:52:57', '2022-08-03 11:52:57'); -- ---------------------------- -- Table structure for t_banners -- ---------------------------- DROP TABLE IF EXISTS `t_banners`; CREATE TABLE `t_banners` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `status` tinyint(1) NOT NULL COMMENT '是否启用', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '首页导航' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_banners -- ---------------------------- INSERT INTO `t_banners` VALUES (1, '百度', 'golf/images/fd4e07abc88a143b8a1df3ced8e9c89a.jpg', 0, 1, '2022-08-05 16:20:03', '2022-08-05 16:20:03', '2022-08-05 16:06:50'); INSERT INTO `t_banners` VALUES (2, '百度', 'http://zhengda.oss-cn-chengdu.aliyuncs.com/zhangsiye/images/0ee910a57cb141d6980a77c9398e0682.png', 0, 1, '2022-08-05 16:19:43', NULL, '2022-08-05 16:19:43'); -- ---------------------------- -- Table structure for t_base_attachments -- ---------------------------- DROP TABLE IF EXISTS `t_base_attachments`; CREATE TABLE `t_base_attachments` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '附件名称', `md5` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'md5码', `path` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '附件路径', `url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '附件url', `class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '未分类' COMMENT '分类', `size` bigint(20) UNSIGNED NULL DEFAULT NULL, `file_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `download` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `klass` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联模型', `objid` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '关联id', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_md5`(`md5`) USING BTREE, INDEX `idx_klass_objid`(`klass`, `objid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_base_cache -- ---------------------------- DROP TABLE IF EXISTS `t_base_cache`; CREATE TABLE `t_base_cache` ( `key` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int(11) NOT NULL, UNIQUE INDEX `t_base_cache_key_unique`(`key`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_base_config -- ---------------------------- DROP TABLE IF EXISTS `t_base_config`; CREATE TABLE `t_base_config` ( `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置组名', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称', `key` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置名', `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '说明', `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '说明', `sort` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '排序', `expiration` int(11) NOT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_base_district -- ---------------------------- DROP TABLE IF EXISTS `t_base_district`; CREATE TABLE `t_base_district` ( `id` int(11) NOT NULL COMMENT '编号', `name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称', `pid` int(11) NOT NULL COMMENT '父级', `short_name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '简称', `grade` tinyint(4) NOT NULL COMMENT '层级关系', `city_code` smallint(6) NOT NULL COMMENT '区号', `zip_code` int(11) NOT NULL COMMENT '邮编', `merger_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '关系值', `lng` double(8, 2) NOT NULL COMMENT '精度', `lat` double(8, 2) NOT NULL COMMENT '维度', `pinyin` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '拼音', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_pid`(`pid`) USING BTREE, INDEX `idx_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_base_failed_jobs -- ---------------------------- DROP TABLE IF EXISTS `t_base_failed_jobs`; CREATE TABLE `t_base_failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0), PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_base_failed_jobs_uuid_unique`(`uuid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_base_migrations -- ---------------------------- DROP TABLE IF EXISTS `t_base_migrations`; CREATE TABLE `t_base_migrations` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_base_migrations -- ---------------------------- INSERT INTO `t_base_migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1); INSERT INTO `t_base_migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1); INSERT INTO `t_base_migrations` VALUES (3, '2016_01_04_173148_create_admin_tables', 1); INSERT INTO `t_base_migrations` VALUES (4, '2017_11_10_145204_create_cache_table', 1); INSERT INTO `t_base_migrations` VALUES (5, '2019_08_19_000000_create_failed_jobs_table', 1); INSERT INTO `t_base_migrations` VALUES (6, '2019_12_14_000001_create_personal_access_tokens_table', 1); INSERT INTO `t_base_migrations` VALUES (7, '2020_05_30_203523_create_base_attachments_table', 1); INSERT INTO `t_base_migrations` VALUES (8, '2020_05_30_203523_create_base_district_table', 1); INSERT INTO `t_base_migrations` VALUES (9, '2020_09_07_090635_create_admin_settings_table', 1); INSERT INTO `t_base_migrations` VALUES (10, '2020_09_22_015815_create_admin_extensions_table', 1); INSERT INTO `t_base_migrations` VALUES (11, '2020_11_01_083237_update_admin_menu_table', 1); INSERT INTO `t_base_migrations` VALUES (12, '2021_02_11_151843_create_base_config_table', 1); INSERT INTO `t_base_migrations` VALUES (13, '2021_02_11_151843_create_sms_records_table', 1); INSERT INTO `t_base_migrations` VALUES (14, '2022_07_14_101239_create_mail_codes_table', 1); INSERT INTO `t_base_migrations` VALUES (15, '2022_07_15_034727_create_settings_table', 1); INSERT INTO `t_base_migrations` VALUES (16, '2022_07_15_034921_create_regions_table', 1); INSERT INTO `t_base_migrations` VALUES (17, '2022_07_15_161023_create_helps_table', 1); INSERT INTO `t_base_migrations` VALUES (18, '2022_07_18_144400_create_user_feedbacks_table', 1); -- ---------------------------- -- Table structure for t_episodes -- ---------------------------- DROP TABLE IF EXISTS `t_episodes`; CREATE TABLE `t_episodes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `cover_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态 0-更新中 1-已完结', `is_opend` tinyint(4) NOT NULL DEFAULT 0 COMMENT '上架状态 0-下架 1-上架', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `is_vip_watch` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否限定VIP观看', `free_episodes` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '免费集数', `paid_episodes` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '付费集数', `episodes_price` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '单集价格设置', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短剧' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_episodes_category -- ---------------------------- DROP TABLE IF EXISTS `t_episodes_category`; CREATE TABLE `t_episodes_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父id', `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '路径', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序越大越靠前', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短剧分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_episodes_category -- ---------------------------- INSERT INTO `t_episodes_category` VALUES (2, '哈哈', 0, NULL, 0, '2022-08-04 17:46:09', NULL, '2022-08-04 17:46:09'); INSERT INTO `t_episodes_category` VALUES (3, '嘻嘻', 2, NULL, 0, '2022-08-04 17:46:18', NULL, '2022-08-04 17:46:18'); INSERT INTO `t_episodes_category` VALUES (4, '3121', 0, NULL, 0, '2022-08-04 17:56:29', NULL, '2022-08-04 17:56:29'); INSERT INTO `t_episodes_category` VALUES (5, '热舞热无', 4, NULL, 0, '2022-08-04 17:56:36', NULL, '2022-08-04 17:56:36'); -- ---------------------------- -- Table structure for t_episodes_lists -- ---------------------------- DROP TABLE IF EXISTS `t_episodes_lists`; CREATE TABLE `t_episodes_lists` ( `id` int(11) NOT NULL AUTO_INCREMENT, `episodes_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '短剧ID', `serial` int(11) NOT NULL DEFAULT 0 COMMENT '第几集', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '视频链接', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短剧列表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_helps -- ---------------------------- DROP TABLE IF EXISTS `t_helps`; CREATE TABLE `t_helps` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `answer` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `look_num` bigint(20) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_home_columns -- ---------------------------- DROP TABLE IF EXISTS `t_home_columns`; CREATE TABLE `t_home_columns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '类型', `status` tinyint(1) NOT NULL COMMENT '是否启用', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '首页栏目' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_home_columns -- ---------------------------- INSERT INTO `t_home_columns` VALUES (1, '短剧推荐', '', 0, 1, 1, NULL, NULL, '2022-08-05 15:19:06'); INSERT INTO `t_home_columns` VALUES (2, '今日推荐', '', 0, 2, 1, NULL, NULL, '2022-08-05 15:19:06'); INSERT INTO `t_home_columns` VALUES (3, '最新热剧', '', 0, 3, 1, NULL, NULL, '2022-08-05 15:19:06'); INSERT INTO `t_home_columns` VALUES (4, '排行版', '', 0, 4, 1, NULL, NULL, '2022-08-05 15:19:06'); -- ---------------------------- -- Table structure for t_mail_codes -- ---------------------------- DROP TABLE IF EXISTS `t_mail_codes`; CREATE TABLE `t_mail_codes` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_nav_bars -- ---------------------------- DROP TABLE IF EXISTS `t_nav_bars`; CREATE TABLE `t_nav_bars` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `type` tinyint(1) UNSIGNED NOT NULL COMMENT '类型', `status` tinyint(1) NOT NULL COMMENT '是否启用', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '顶部导航' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_nav_bars -- ---------------------------- INSERT INTO `t_nav_bars` VALUES (1, '排行榜', '', 0, 1, 1, '2022-08-05 15:47:08', NULL, '2022-08-05 15:19:06'); INSERT INTO `t_nav_bars` VALUES (2, '最新', '', 0, 2, 1, NULL, NULL, '2022-08-05 15:19:06'); INSERT INTO `t_nav_bars` VALUES (3, '会员', '', 0, 3, 1, NULL, NULL, '2022-08-05 15:19:06'); INSERT INTO `t_nav_bars` VALUES (4, '签到', '', 0, 4, 1, NULL, NULL, '2022-08-05 15:19:06'); INSERT INTO `t_nav_bars` VALUES (5, '充值', '', 0, 5, 1, NULL, NULL, '2022-08-05 15:19:06'); -- ---------------------------- -- Table structure for t_password_resets -- ---------------------------- DROP TABLE IF EXISTS `t_password_resets`; CREATE TABLE `t_password_resets` ( `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, INDEX `t_password_resets_email_index`(`email`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_pay -- ---------------------------- DROP TABLE IF EXISTS `t_pay`; CREATE TABLE `t_pay` ( `pay_id` bigint(20) UNSIGNED NOT NULL COMMENT '订单ID', `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID', `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '店铺ID', `pay_type` int(11) NOT NULL COMMENT '支付类型', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '订单状态', `pay_dt` datetime(0) NOT NULL COMMENT '支付时间', `order_fee` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '订单价格', `discount_fee` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '优惠价格', `handling_fee` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '手续费', `prepay_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微信支付预付单ID', `serial_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付流水', `pay_error` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '支付错误记录', `updated_at` datetime(0) NOT NULL COMMENT '删除时间', `deleted_at` datetime(0) NOT NULL COMMENT '删除时间', `created_at` datetime(0) NOT NULL COMMENT '创建时间', PRIMARY KEY (`pay_id`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '支付表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_personal_access_tokens -- ---------------------------- DROP TABLE IF EXISTS `t_personal_access_tokens`; CREATE TABLE `t_personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `last_used_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_personal_access_tokens_token_unique`(`token`) USING BTREE, INDEX `t_personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type`, `tokenable_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_recharge_combo -- ---------------------------- DROP TABLE IF EXISTS `t_recharge_combo`; CREATE TABLE `t_recharge_combo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '充值名称', `price` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '支付金额 1:1 金币', `gift` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '赠送金币', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '充值套餐' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_regions -- ---------------------------- DROP TABLE IF EXISTS `t_regions`; CREATE TABLE `t_regions` ( `id` int(11) NOT NULL COMMENT '编号', `code` int(11) NOT NULL COMMENT '地区代码', `parent_code` int(11) NOT NULL COMMENT '父级', `type` tinyint(4) NOT NULL COMMENT '类型：1省，2市，3区', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称', `full_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '全名' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_settings -- ---------------------------- DROP TABLE IF EXISTS `t_settings`; CREATE TABLE `t_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序名称', `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序logo', `contact` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系电话', `tips` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '小程序提示', `is_watch_auto_pay` tinyint(4) NOT NULL DEFAULT 0 COMMENT '观看自动支付', `recharge_bg_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '封面图', `recharge_button_txt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '按钮文案', `recharge_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '充值说明', `nav_seting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '导航栏设置 json', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_sms_records -- ---------------------------- DROP TABLE IF EXISTS `t_sms_records`; CREATE TABLE `t_sms_records` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `prefix` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '国际区号前缀', `event` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '事件 login register 等', `mobile` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机号', `verify_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '验证key 用于验证码校验', `sms_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机验证码', `sms_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '短信发送回调', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_tabbars -- ---------------------------- DROP TABLE IF EXISTS `t_tabbars`; CREATE TABLE `t_tabbars` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '类型', `status` tinyint(1) NOT NULL COMMENT '是否启用', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '底部导航' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_tabbars -- ---------------------------- INSERT INTO `t_tabbars` VALUES (1, '首页', 'golf/images/b5314304d9611e5dc09c4ab4cf1fa164.png', 2, 1, 1, '2022-08-05 15:41:01', NULL, '2022-08-05 15:19:06'); INSERT INTO `t_tabbars` VALUES (2, '追剧', '', 0, 2, 1, '2022-08-05 15:41:51', NULL, '2022-08-05 15:19:06'); INSERT INTO `t_tabbars` VALUES (3, '我的', '', 0, 3, 1, NULL, NULL, '2022-08-05 15:19:06'); -- ---------------------------- -- Table structure for t_user_consume_records -- ---------------------------- DROP TABLE IF EXISTS `t_user_consume_records`; CREATE TABLE `t_user_consume_records` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) UNSIGNED NOT NULL COMMENT 'user_id', `before` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '消费后记录', `change` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '消费金币', `current` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '消费后金币', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注', `order_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '订单', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户消费记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_episodes_records -- ---------------------------- DROP TABLE IF EXISTS `t_user_episodes_records`; CREATE TABLE `t_user_episodes_records` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` int(11) UNSIGNED NOT NULL COMMENT 'user_id', `episodes_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '短剧ID', `list_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '具体多少集集ID', `price` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '支付金额 1:1 金币', `discount` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '折扣金币', `updated_at` datetime(0) NOT NULL COMMENT '删除时间', `deleted_at` datetime(0) NOT NULL COMMENT '删除时间', `created_at` datetime(0) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户购买短剧记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_feedbacks -- ---------------------------- DROP TABLE IF EXISTS `t_user_feedbacks`; CREATE TABLE `t_user_feedbacks` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户', `content` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容', `file` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '图片可多张', `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态0待处理，1已处理', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_info -- ---------------------------- DROP TABLE IF EXISTS `t_user_info`; CREATE TABLE `t_user_info` ( `user_id` int(11) UNSIGNED NOT NULL COMMENT 'user_id', `integral` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '金币余额', `total_integral` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '总金币', `platform` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '用户平台 1-抖音 2-快手 ...', `is_vip` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否VIP', `start_at` date NOT NULL COMMENT 'VIP生效时间', `end_at` date NOT NULL COMMENT 'VIP失效时间', `opend_at` date NOT NULL COMMENT '开卡时间', `updated_at` datetime(0) NOT NULL COMMENT '删除时间', `deleted_at` datetime(0) NOT NULL COMMENT '删除时间', `created_at` datetime(0) NOT NULL COMMENT '创建时间', PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_recharge_records -- ---------------------------- DROP TABLE IF EXISTS `t_user_recharge_records`; CREATE TABLE `t_user_recharge_records` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` int(11) UNSIGNED NOT NULL COMMENT 'user_id', `combo_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '套餐ID', `price` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '支付金额 1:1 金币', `gift` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '赠送金币', `pay_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '支付ID', `updated_at` datetime(0) NOT NULL COMMENT '删除时间', `deleted_at` datetime(0) NOT NULL COMMENT '删除时间', `created_at` datetime(0) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户充值记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_sign_records -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_records`; CREATE TABLE `t_user_sign_records` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) UNSIGNED NOT NULL COMMENT 'user_id', `date` date NOT NULL COMMENT '签到时间', `award` int(11) NOT NULL DEFAULT 0 COMMENT '签到奖励', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户签到' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_vip_records -- ---------------------------- DROP TABLE IF EXISTS `t_user_vip_records`; CREATE TABLE `t_user_vip_records` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `combo_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '套餐ID', `valid_day` int(11) NOT NULL DEFAULT 0 COMMENT '有效天数', `pay_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '支付ID', `updated_at` datetime(0) NOT NULL COMMENT '删除时间', `deleted_at` datetime(0) NOT NULL COMMENT '删除时间', `created_at` datetime(0) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户VIP记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user_watch_records -- ---------------------------- DROP TABLE IF EXISTS `t_user_watch_records`; CREATE TABLE `t_user_watch_records` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) UNSIGNED NOT NULL COMMENT 'user_id', `episode_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '短剧ID', `list_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '具体集数ID', `updated_at` timestamp(0) NULL DEFAULT NULL, `deleted_at` timestamp(0) NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户观看记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_users -- ---------------------------- DROP TABLE IF EXISTS `t_users`; CREATE TABLE `t_users` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `nickname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `open_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `union_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `email_verified_at` timestamp(0) NULL DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `t_users_email_unique`(`email`) USING BTREE, UNIQUE INDEX `t_users_mobile_unique`(`mobile`) USING BTREE, UNIQUE INDEX `t_users_open_id_unique`(`open_id`) USING BTREE, UNIQUE INDEX `t_users_union_id_unique`(`union_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_vip_combo -- ---------------------------- DROP TABLE IF EXISTS `t_vip_combo`; CREATE TABLE `t_vip_combo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称', `price` decimal(10, 2) NOT NULL DEFAULT 0 COMMENT '价格', `valid_day` int(11) NOT NULL DEFAULT 0 COMMENT '有效天数', `desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述', `updated_at` datetime(0) NOT NULL COMMENT '删除时间', `deleted_at` datetime(0) NOT NULL COMMENT '删除时间', `created_at` datetime(0) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员套餐' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;