646 lines
21 KiB
SQL
646 lines
21 KiB
SQL
-- phpMyAdmin SQL Dump
|
||
-- version 4.9.1
|
||
-- https://www.phpmyadmin.net/
|
||
--
|
||
-- 主机： localhost
|
||
-- 生成日期： 2020-06-09 10:35:42
|
||
-- 服务器版本： 8.0.13
|
||
-- PHP 版本： 7.3.11
|
||
|
||
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
||
SET AUTOCOMMIT = 0;
|
||
START TRANSACTION;
|
||
SET time_zone = "+00:00";
|
||
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
/*!40101 SET NAMES utf8mb4 */;
|
||
|
||
--
|
||
-- 数据库： `vote`
|
||
--
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_config`
|
||
--
|
||
|
||
CREATE TABLE `admin_config` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_config`
|
||
--
|
||
|
||
INSERT INTO `admin_config` (`id`, `name`, `value`, `description`, `created_at`, `updated_at`) VALUES
|
||
(1, 'open_sign', '1', NULL, '2020-05-06 07:14:18', '2020-05-06 07:27:52'),
|
||
(2, 'dested', '0', NULL, '2020-05-07 09:09:24', '2020-05-08 06:45:13');
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_menu`
|
||
--
|
||
|
||
CREATE TABLE `admin_menu` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`parent_id` int(11) 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 NOT NULL,
|
||
`uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_menu`
|
||
--
|
||
|
||
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `permission`, `created_at`, `updated_at`) VALUES
|
||
(1, 0, 1, '看板', 'fa-bar-chart', '/', NULL, NULL, NULL),
|
||
(2, 0, 7, '系统管理', 'fa-tasks', '', NULL, NULL, '2020-05-04 07:41:37'),
|
||
(3, 2, 8, '用户', 'fa-users', 'auth/users', NULL, NULL, '2020-05-04 07:41:37'),
|
||
(4, 2, 9, '角色', 'fa-user', 'auth/roles', NULL, NULL, '2020-05-04 07:41:37'),
|
||
(5, 2, 10, '权限', 'fa-ban', 'auth/permissions', NULL, NULL, '2020-05-04 07:41:37'),
|
||
(6, 2, 11, '菜单', 'fa-bars', 'auth/menu', NULL, NULL, '2020-05-04 07:41:37'),
|
||
(7, 2, 12, '日志', 'fa-history', 'auth/logs', NULL, NULL, '2020-05-04 07:41:37'),
|
||
(8, 0, 5, '投票管理', 'fa-bars', NULL, NULL, '2020-05-01 08:52:04', '2020-05-04 07:41:37'),
|
||
(9, 8, 6, '投票轮次', 'fa-bars', 'votes', NULL, '2020-05-01 08:52:17', '2020-05-04 07:41:37'),
|
||
(10, 0, 3, '用户管理', 'fa-group', NULL, NULL, '2020-05-02 09:04:15', '2020-05-04 07:41:37'),
|
||
(11, 10, 4, '用户列表', 'fa-user', 'users', NULL, '2020-05-02 09:04:31', '2020-05-04 07:41:37'),
|
||
(12, 0, 2, '内容管理', 'fa-bars', NULL, NULL, '2020-05-04 07:41:35', '2020-05-04 07:41:37'),
|
||
(13, 12, 0, '文件审阅', 'fa-bars', 'articles', NULL, '2020-05-04 07:41:44', '2020-05-04 07:41:51'),
|
||
(14, 0, 13, 'Config', 'fa-toggle-on', 'config', NULL, '2020-05-06 07:13:52', '2020-05-06 07:13:52');
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_operation_log`
|
||
--
|
||
|
||
CREATE TABLE `admin_operation_log` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`user_id` int(11) NOT NULL,
|
||
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`input` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_permissions`
|
||
--
|
||
|
||
CREATE TABLE `admin_permissions` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`http_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_permissions`
|
||
--
|
||
|
||
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `created_at`, `updated_at`) VALUES
|
||
(1, 'All permission', '*', '', '*', NULL, NULL),
|
||
(2, 'Dashboard', 'dashboard', 'GET', '/', NULL, NULL),
|
||
(3, 'Login', 'auth.login', '', '/auth/login\r\n/auth/logout', NULL, NULL),
|
||
(4, 'User setting', 'auth.setting', 'GET,PUT', '/auth/setting', NULL, NULL),
|
||
(5, 'Auth management', 'auth.management', '', '/auth/roles\r\n/auth/permissions\r\n/auth/menu\r\n/auth/logs', NULL, NULL),
|
||
(6, 'Admin Config', 'ext.config', '', '/config*', '2020-05-06 07:13:52', '2020-05-06 07:13:52');
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_roles`
|
||
--
|
||
|
||
CREATE TABLE `admin_roles` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`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 NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_roles`
|
||
--
|
||
|
||
INSERT INTO `admin_roles` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
|
||
(1, 'Administrator', 'administrator', '2020-05-01 00:45:21', '2020-05-01 00:45:21');
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_role_menu`
|
||
--
|
||
|
||
CREATE TABLE `admin_role_menu` (
|
||
`role_id` int(11) NOT NULL,
|
||
`menu_id` int(11) NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_role_menu`
|
||
--
|
||
|
||
INSERT INTO `admin_role_menu` (`role_id`, `menu_id`, `created_at`, `updated_at`) VALUES
|
||
(1, 2, NULL, NULL);
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_role_permissions`
|
||
--
|
||
|
||
CREATE TABLE `admin_role_permissions` (
|
||
`role_id` int(11) NOT NULL,
|
||
`permission_id` int(11) NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_role_permissions`
|
||
--
|
||
|
||
INSERT INTO `admin_role_permissions` (`role_id`, `permission_id`, `created_at`, `updated_at`) VALUES
|
||
(1, 1, NULL, NULL);
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_role_users`
|
||
--
|
||
|
||
CREATE TABLE `admin_role_users` (
|
||
`role_id` int(11) NOT NULL,
|
||
`user_id` int(11) NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_role_users`
|
||
--
|
||
|
||
INSERT INTO `admin_role_users` (`role_id`, `user_id`, `created_at`, `updated_at`) VALUES
|
||
(1, 1, NULL, NULL);
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_users`
|
||
--
|
||
|
||
CREATE TABLE `admin_users` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`username` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`password` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `admin_users`
|
||
--
|
||
|
||
INSERT INTO `admin_users` (`id`, `username`, `password`, `name`, `avatar`, `remember_token`, `created_at`, `updated_at`) VALUES
|
||
(1, 'admin', '$2y$10$zhYMMnQtsf9dX8JCkn8JreARKFrnhDKFab1EJ6cMUtmZ88Rt4dq5m', 'Administrator', NULL, 'z9P5PsRgh47FRo9TMFpa6IkmcxdZnCt8g8NIx82FnYz8e3H1FTlBaJZ3YYDm', '2020-05-01 00:45:21', '2020-05-08 10:51:14');
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `admin_user_permissions`
|
||
--
|
||
|
||
CREATE TABLE `admin_user_permissions` (
|
||
`user_id` int(11) NOT NULL,
|
||
`permission_id` int(11) NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `articles`
|
||
--
|
||
|
||
CREATE TABLE `articles` (
|
||
`id` bigint(20) UNSIGNED NOT NULL,
|
||
`category_id` int(10) UNSIGNED NOT NULL,
|
||
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`sort` int(10) UNSIGNED DEFAULT '0' COMMENT '倒序',
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL,
|
||
`deleted_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `articles`
|
||
--
|
||
|
||
INSERT INTO `articles` (`id`, `category_id`, `title`, `desc`, `content`, `sort`, `created_at`, `updated_at`, `deleted_at`) VALUES
|
||
(1, 1, '会员代表承诺书', '会员代表承诺书', '<p style=\"text-align: center;\">中国狮子联会心连心服务队2020-2021年度队长及队长团队成员推举会议</p><p style=\"text-align: center;\">会员代表承诺书</p><p>本人作为本次推举会议成员，郑重做出如下承诺：</p><p>一、严格遵守会议纪律要求，保证全程参会，认真履行会员代表权利义务。</p><p>二、认真履行会员代表职责，公平公正行使推举权。</p><p>三、本人愿意接受大会监督。</p><p style=\"text-align: right;\">承 诺 人：{username}</p><p style=\"text-align: right;\">手机号码：{mobile}</p><p style=\"text-align: right;\">承诺日期：2020年6月7日</p>', 0, '2020-05-03 23:45:44', '2020-06-05 02:41:11', NULL);
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `article_audits`
|
||
--
|
||
|
||
CREATE TABLE `article_audits` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`article_id` int(10) UNSIGNED NOT NULL,
|
||
`user_id` int(10) UNSIGNED NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `failed_jobs`
|
||
--
|
||
|
||
CREATE TABLE `failed_jobs` (
|
||
`id` bigint(20) UNSIGNED 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 NOT NULL DEFAULT CURRENT_TIMESTAMP
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `items`
|
||
--
|
||
|
||
CREATE TABLE `items` (
|
||
`id` bigint(20) UNSIGNED NOT NULL,
|
||
`vote_id` int(10) UNSIGNED NOT NULL,
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`desc2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
||
`sort` int(10) UNSIGNED NOT NULL DEFAULT '99',
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL,
|
||
`deleted_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `item_logs`
|
||
--
|
||
|
||
CREATE TABLE `item_logs` (
|
||
`id` bigint(20) UNSIGNED NOT NULL,
|
||
`vote_id` int(10) UNSIGNED NOT NULL,
|
||
`item_id` bigint(20) UNSIGNED NOT NULL,
|
||
`user_id` bigint(20) UNSIGNED NOT NULL,
|
||
`result` int(10) UNSIGNED NOT NULL,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `migrations`
|
||
--
|
||
|
||
CREATE TABLE `migrations` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`batch` int(11) NOT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
--
|
||
-- 转存表中的数据 `migrations`
|
||
--
|
||
|
||
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
|
||
(1, '2014_10_12_000000_create_users_table', 1),
|
||
(2, '2019_08_19_000000_create_failed_jobs_table', 1),
|
||
(3, '2016_01_04_173148_create_admin_tables', 2),
|
||
(4, '2020_05_01_235031_create_items_table', 3),
|
||
(5, '2020_05_01_235326_create_item_logs_table', 4),
|
||
(6, '2018_11_07_000000_create_sms_table', 5),
|
||
(7, '2017_07_17_040159_create_config_table', 6);
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `sms`
|
||
--
|
||
|
||
CREATE TABLE `sms` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`channel` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`used` tinyint(1) NOT NULL DEFAULT '0',
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `users`
|
||
--
|
||
|
||
CREATE TABLE `users` (
|
||
`id` bigint(20) UNSIGNED NOT NULL,
|
||
`parent_id` int(10) UNSIGNED NOT NULL,
|
||
`mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`sign` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
|
||
`type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
-- --------------------------------------------------------
|
||
|
||
--
|
||
-- 表的结构 `votes`
|
||
--
|
||
|
||
CREATE TABLE `votes` (
|
||
`id` int(10) UNSIGNED NOT NULL,
|
||
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
||
`type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
||
`max` int(10) UNSIGNED DEFAULT '0',
|
||
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
|
||
`rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
|
||
`archives` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
|
||
`created_at` timestamp NULL DEFAULT NULL,
|
||
`updated_at` timestamp NULL DEFAULT NULL,
|
||
`deleted_at` timestamp NULL DEFAULT NULL
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
||
|
||
--
|
||
-- 转储表的索引
|
||
--
|
||
|
||
--
|
||
-- 表的索引 `admin_config`
|
||
--
|
||
ALTER TABLE `admin_config`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD UNIQUE KEY `admin_config_name_unique` (`name`);
|
||
|
||
--
|
||
-- 表的索引 `admin_menu`
|
||
--
|
||
ALTER TABLE `admin_menu`
|
||
ADD PRIMARY KEY (`id`);
|
||
|
||
--
|
||
-- 表的索引 `admin_operation_log`
|
||
--
|
||
ALTER TABLE `admin_operation_log`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD KEY `admin_operation_log_user_id_index` (`user_id`);
|
||
|
||
--
|
||
-- 表的索引 `admin_permissions`
|
||
--
|
||
ALTER TABLE `admin_permissions`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD UNIQUE KEY `admin_permissions_name_unique` (`name`),
|
||
ADD UNIQUE KEY `admin_permissions_slug_unique` (`slug`);
|
||
|
||
--
|
||
-- 表的索引 `admin_roles`
|
||
--
|
||
ALTER TABLE `admin_roles`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD UNIQUE KEY `admin_roles_name_unique` (`name`),
|
||
ADD UNIQUE KEY `admin_roles_slug_unique` (`slug`);
|
||
|
||
--
|
||
-- 表的索引 `admin_role_menu`
|
||
--
|
||
ALTER TABLE `admin_role_menu`
|
||
ADD KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`);
|
||
|
||
--
|
||
-- 表的索引 `admin_role_permissions`
|
||
--
|
||
ALTER TABLE `admin_role_permissions`
|
||
ADD KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`);
|
||
|
||
--
|
||
-- 表的索引 `admin_role_users`
|
||
--
|
||
ALTER TABLE `admin_role_users`
|
||
ADD KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`);
|
||
|
||
--
|
||
-- 表的索引 `admin_users`
|
||
--
|
||
ALTER TABLE `admin_users`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD UNIQUE KEY `admin_users_username_unique` (`username`);
|
||
|
||
--
|
||
-- 表的索引 `admin_user_permissions`
|
||
--
|
||
ALTER TABLE `admin_user_permissions`
|
||
ADD KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`);
|
||
|
||
--
|
||
-- 表的索引 `articles`
|
||
--
|
||
ALTER TABLE `articles`
|
||
ADD PRIMARY KEY (`id`);
|
||
|
||
--
|
||
-- 表的索引 `article_audits`
|
||
--
|
||
ALTER TABLE `article_audits`
|
||
ADD PRIMARY KEY (`id`);
|
||
|
||
--
|
||
-- 表的索引 `failed_jobs`
|
||
--
|
||
ALTER TABLE `failed_jobs`
|
||
ADD PRIMARY KEY (`id`);
|
||
|
||
--
|
||
-- 表的索引 `items`
|
||
--
|
||
ALTER TABLE `items`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD KEY `vote_id` (`vote_id`);
|
||
|
||
--
|
||
-- 表的索引 `item_logs`
|
||
--
|
||
ALTER TABLE `item_logs`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD KEY `item_id` (`item_id`),
|
||
ADD KEY `user_id` (`user_id`),
|
||
ADD KEY `vote_id` (`vote_id`);
|
||
|
||
--
|
||
-- 表的索引 `migrations`
|
||
--
|
||
ALTER TABLE `migrations`
|
||
ADD PRIMARY KEY (`id`);
|
||
|
||
--
|
||
-- 表的索引 `sms`
|
||
--
|
||
ALTER TABLE `sms`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD KEY `sms_mobile_channel_index` (`mobile`,`channel`);
|
||
|
||
--
|
||
-- 表的索引 `users`
|
||
--
|
||
ALTER TABLE `users`
|
||
ADD PRIMARY KEY (`id`),
|
||
ADD UNIQUE KEY `mobile` (`mobile`);
|
||
|
||
--
|
||
-- 表的索引 `votes`
|
||
--
|
||
ALTER TABLE `votes`
|
||
ADD PRIMARY KEY (`id`);
|
||
|
||
--
|
||
-- 在导出的表使用AUTO_INCREMENT
|
||
--
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `admin_config`
|
||
--
|
||
ALTER TABLE `admin_config`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `admin_menu`
|
||
--
|
||
ALTER TABLE `admin_menu`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `admin_operation_log`
|
||
--
|
||
ALTER TABLE `admin_operation_log`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `admin_permissions`
|
||
--
|
||
ALTER TABLE `admin_permissions`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `admin_roles`
|
||
--
|
||
ALTER TABLE `admin_roles`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `admin_users`
|
||
--
|
||
ALTER TABLE `admin_users`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `articles`
|
||
--
|
||
ALTER TABLE `articles`
|
||
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `article_audits`
|
||
--
|
||
ALTER TABLE `article_audits`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `failed_jobs`
|
||
--
|
||
ALTER TABLE `failed_jobs`
|
||
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `items`
|
||
--
|
||
ALTER TABLE `items`
|
||
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `item_logs`
|
||
--
|
||
ALTER TABLE `item_logs`
|
||
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `migrations`
|
||
--
|
||
ALTER TABLE `migrations`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `sms`
|
||
--
|
||
ALTER TABLE `sms`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `users`
|
||
--
|
||
ALTER TABLE `users`
|
||
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
|
||
--
|
||
-- 使用表AUTO_INCREMENT `votes`
|
||
--
|
||
ALTER TABLE `votes`
|
||
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
|
||
COMMIT;
|
||
|
||
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|