/* Navicat Premium Data Transfer Source Server : 192.168.0.110 Source Server Type : MySQL Source Server Version : 50737 Source Host : 127.0.0.1:3306 Source Schema : zhangsiye_db Target Server Type : MySQL Target Server Version : 50737 File Encoding : 65001 Date: 02/08/2022 20:41:50 */ 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 = 8 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', NULL); 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); -- ---------------------------- -- 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; -- ---------------------------- -- 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'); -- ---------------------------- -- 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 = 2 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'); -- ---------------------------- -- 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 = 2 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'); -- ---------------------------- -- 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.00 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '剧集分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- 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_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_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.00 COMMENT '订单价格', `discount_fee` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '优惠价格', `handling_fee` decimal(10, 2) NOT NULL DEFAULT 0.00 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.00 COMMENT '支付金额 1:1 金币', `gift` decimal(10, 2) NOT NULL DEFAULT 0.00 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_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.00 COMMENT '消费后记录', `change` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '消费金币', `current` decimal(10, 2) NOT NULL DEFAULT 0.00 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.00 COMMENT '支付金额 1:1 金币', `discount` decimal(10, 2) NOT NULL DEFAULT 0.00 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 '总金币', `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.00 COMMENT '支付金额 1:1 金币', `gift` decimal(10, 2) NOT NULL DEFAULT 0.00 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.00 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;