登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

sys/laravel8-layui-zifengye

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
laravel_zifengye.sql 27.71 KB
一键复制 编辑 原始数据 按行查看 历史
sys 提交于 2022-04-28 22:29 . laravel8
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457
-- phpMyAdmin SQL Dump

-- version 5.0.4

-- https://www.phpmyadmin.net/

--

-- 主机： localhost

-- 生成日期： 2022-04-28 20:23:30

-- 服务器版本： 5.6.50-log

-- PHP 版本： 7.4.27



SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

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 */;



--

-- 数据库： `laravel_zifengye`

--



-- --------------------------------------------------------



--

-- 表的结构 `la_admins`

--



CREATE TABLE `la_admins` (

  `id` int(10) UNSIGNED NOT NULL,

  `created_id` int(10) NOT NULL DEFAULT '0',

  `created_at` int(10) NOT NULL DEFAULT '0',

  `updated_id` int(10) NOT NULL DEFAULT '0',

  `updated_at` int(10) NOT NULL DEFAULT '0',

  `deleted_id` int(10) NOT NULL DEFAULT '0',

  `deleted_at` int(10) DEFAULT '0',

  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `email` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `phone` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '手机号',

  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

  `apikey` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `auto_logout` int(10) NOT NULL DEFAULT '15',

  `last_login_time` int(10) DEFAULT NULL COMMENT '最后登录时间',

  `last_login_ip` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '最后登录ip',

  `type` tinyint(1) DEFAULT '2' COMMENT '类型 1=超级管理员 2=普通管理员',

  `status` tinyint(1) NOT NULL DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='管理员表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_admins`

--



INSERT INTO `la_admins` (`id`, `created_id`, `created_at`, `updated_id`, `updated_at`, `deleted_id`, `deleted_at`, `name`, `email`, `password`, `phone`, `remember_token`, `apikey`, `auto_logout`, `last_login_time`, `last_login_ip`, `type`, `status`) VALUES

(1, 0, 1461766664, 1, 1651142394, 0, NULL, 'Admin', 'admin', '$2y$10$loJxi.dSj/JmdKqkEKYuVOE5hTxP5GOyZgCaFEfpMBsrAx8YBF3Ly', '12378945', 'TUv3rNye9Pgq0Er0gURmWT0uTbtOn2Sr217mIMBdimrO5YvQE0JOrNXiix6V', '1df67884df69f2f0a5725aef243839ac', 15, 1651142394, '117.154.89.190', 1, 0),

(2, 1, 1608196877, 1, 1609128142, 0, 0, 'test', '', '$2y$10$JgMW6/EFSsG.rozV6xettO.vV17z7lXTUb0phRxcssLYhvg03bMLm', '13311111111', NULL, '', 15, NULL, NULL, 2, 1);



-- --------------------------------------------------------



--

-- 表的结构 `la_admin_logs`

--



CREATE TABLE `la_admin_logs` (

  `id` bigint(16) UNSIGNED NOT NULL,

  `created_id` int(11) DEFAULT '0',

  `created_at` int(11) DEFAULT '0',

  `updated_id` int(11) DEFAULT '0',

  `updated_at` int(11) DEFAULT '0',

  `deleted_id` int(11) DEFAULT '0',

  `deleted_at` int(11) DEFAULT '0',

  `admin_id` int(11) NOT NULL DEFAULT '1' COMMENT '管理员ID',

  `info` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '操作详细',

  `ip` varchar(30) DEFAULT NULL COMMENT '操作时的ip',

  `url` varchar(80) DEFAULT NULL COMMENT '日志访问的地址',

  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态 1：显示，2：隐藏，90：删除'

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员操作日志表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_admin_logs`

--



INSERT INTO `la_admin_logs` (`id`, `created_id`, `created_at`, `updated_id`, `updated_at`, `deleted_id`, `deleted_at`, `admin_id`, `info`, `ip`, `url`, `status`) VALUES

(1, 1, 1629690323, 0, 1629690323, 0, 0, 1, '管理员登录', '127.0.0.1', 'App\\Http\\Controllers\\Admin\\AuthController@authenticate', 1),

(2, 1, 1651142394, 0, 1651142394, 0, 0, 1, '管理员登录', '117.154.89.190', 'App\\Http\\Controllers\\Admin\\AuthController@authenticate', 1),

(3, 1, 1651142914, 0, 1651142914, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(4, 1, 1651142998, 0, 1651142998, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(5, 1, 1651143029, 0, 1651143029, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(6, 1, 1651143054, 0, 1651143054, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(7, 1, 1651143119, 0, 1651143119, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(8, 1, 1651143125, 0, 1651143125, 0, 0, 1, 'Admin删除了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@delete', 1),

(9, 1, 1651143194, 0, 1651143194, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(10, 1, 1651143321, 0, 1651143321, 0, 0, 1, 'Admin添加了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@add', 1),

(11, 1, 1651143378, 0, 1651143378, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(12, 1, 1651143448, 0, 1651143448, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(13, 1, 1651143463, 0, 1651143463, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(14, 1, 1651143495, 0, 1651143495, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(15, 1, 1651143521, 0, 1651143521, 0, 0, 1, 'Admin删除了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@delete', 1),

(16, 1, 1651143595, 0, 1651143595, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(17, 1, 1651143606, 0, 1651143606, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(18, 1, 1651143622, 0, 1651143622, 0, 0, 1, 'Admin删除了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@delete', 1),

(19, 1, 1651144380, 0, 1651144380, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(20, 1, 1651144709, 0, 1651144709, 0, 0, 1, 'Admin添加了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@add', 1),

(21, 1, 1651144745, 0, 1651144745, 0, 0, 1, 'Admin添加了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@add', 1),

(22, 1, 1651145107, 0, 1651145107, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(23, 1, 1651145126, 0, 1651145126, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(24, 1, 1651145200, 0, 1651145200, 0, 0, 1, 'Admin更新了一条Config数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\ConfigController@edit', 1),

(25, 1, 1651145555, 0, 1651145555, 0, 0, 1, 'Admin更新了一条Config数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\ConfigController@edit', 1),

(26, 1, 1651145932, 0, 1651145932, 0, 0, 1, 'Admin更新了一条Config数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\ConfigController@edit', 1),

(27, 1, 1651145971, 0, 1651145971, 0, 0, 1, 'Admin添加了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@add', 1),

(28, 1, 1651145982, 0, 1651145982, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1),

(29, 1, 1651145994, 0, 1651145994, 0, 0, 1, 'Admin更新了一条AdminMenu数据。', '117.154.89.190', '\\App\\Http\\Controllers\\Admin\\AdminMenuController@edit', 1);



-- --------------------------------------------------------



--

-- 表的结构 `la_admin_menu`

--



CREATE TABLE `la_admin_menu` (

  `id` int(10) UNSIGNED NOT NULL,

  `created_id` int(10) NOT NULL DEFAULT '0',

  `created_at` int(10) NOT NULL DEFAULT '0',

  `updated_id` int(10) NOT NULL DEFAULT '0',

  `updated_at` int(10) NOT NULL DEFAULT '0',

  `deleted_id` int(10) NOT NULL DEFAULT '0',

  `deleted_at` int(10) DEFAULT '0',

  `parent_id` int(10) NOT NULL DEFAULT '0',

  `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `app` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用名',

  `controller` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '控制器名',

  `action` varchar(100) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '操作名称',

  `route` varchar(100) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '路由',

  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型 1=模块 2=列表 3=操作',

  `sorting` int(10) NOT NULL DEFAULT '0',

  `target` varchar(20) COLLATE utf8_unicode_ci DEFAULT '_self',

  `icon` varchar(60) COLLATE utf8_unicode_ci DEFAULT '',

  `access` tinyint(4) DEFAULT '0',

  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1：显示 2：不显示'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='后台菜单表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_admin_menu`

--



INSERT INTO `la_admin_menu` (`id`, `created_id`, `created_at`, `updated_id`, `updated_at`, `deleted_id`, `deleted_at`, `parent_id`, `name`, `app`, `controller`, `action`, `route`, `type`, `sorting`, `target`, `icon`, `access`, `status`) VALUES

(1, 1, 1461766608, 1, 1651142914, 0, 0, 0, '系统概况', 'admin', 'Index', 'dashboard', 'dashboard', 1, 0, '_self', 'layui-icon-home', 0, 1),

(2, 1, 1461766608, 1, 1651143345, 0, 0, 0, '账号管理', NULL, NULL, NULL, NULL, 1, 4, '_self', 'layui-icon-user', 0, 1),

(7, 1, 1464080269, 1, 1651143332, 0, 0, 0, '内容管理', '', NULL, '', '', 1, 1, '_self', 'layui-icon-read', 0, 1),

(10, 1, 1462523669, 1, 1651143378, 0, 0, 0, '系统设置', NULL, NULL, NULL, NULL, 1, 20, '_self', 'layui-icon-set', 0, 1),

(11, 1, 1461766608, 1, 1462533871, 0, 0, 0, '个人中心', 'admin', 'Admin', 'profile', 'profile', 3, 0, '_self', '', 0, 1),

(12, 1, 1461766608, 1, 1462546137, 0, 0, 0, '重置密码', 'admin', 'Admin', 'resetPassword', 'resetPassword', 3, 0, '_self', '', 0, 1),

(13, 1, 1464080269, 1, 1651144380, 0, 0, 10, '菜单管理', 'admin', 'AdminMenu', 'index', 'adminmenu', 2, 0, '_self', NULL, 0, 1),

(14, 1, 1461766608, 1, 1608775493, 0, 0, 13, '添加', 'admin', 'AdminMenu', 'add', 'adminmenu/add', 3, 1, '_self', '', 0, 1),

(15, 1, 1461766608, 1, 1608775501, 0, 0, 13, '编辑', 'admin', 'AdminMenu', 'edit', 'adminmenu/edit/{id}', 3, 2, '_self', '', 0, 1),

(16, 1, 1461766608, 1, 1608775506, 0, 0, 13, '删除', 'admin', 'AdminMenu', 'delete', 'adminmenu/delete/{id}', 3, 3, '_self', '', 0, 1),

(18, 1, 1464080269, 1, 1651143029, 0, 0, 2, '角色管理', 'admin', 'AdminRole', 'index', 'adminrole', 2, 0, '_self', NULL, 0, 1),

(19, 1, 1464080269, 1, 1620193887, 0, 0, 18, '添加', 'admin', 'AdminRole', 'add', 'adminrole/add', 3, 0, '_self', '', 0, 1),

(20, 1, 1464080269, 1, 1478192928, 0, 0, 18, '编辑', 'admin', 'AdminRole', 'edit', 'adminrole/edit/{id}', 3, 0, '_self', '', 0, 1),

(21, 1, 1464080269, 1, 1478192928, 0, 0, 18, '删除', 'admin', 'AdminRole', 'delete', 'adminrole/delete/{id}', 3, 0, '_self', '', 0, 1),

(22, 1, 1462523752, 1, 1651143054, 0, 0, 2, '管理员', 'admin', 'Admin', 'index', 'admin', 2, 0, '_self', NULL, 0, 1),

(23, 1, 1462525036, 1, 1462525058, 0, 0, 22, '添加', 'admin', 'Admin', 'add', 'admin/add', 3, 0, '_self', '', 0, 1),

(24, 1, 1462525089, 1, 1464932528, 0, 0, 22, '编辑', 'admin', 'Admin', 'edit', 'admin/edit/{id}', 3, 0, '_self', '', 0, 1),

(25, 1, 1462525163, 1, 1462525170, 0, 0, 22, '删除', 'admin', 'Admin', 'delete', 'admin/delete/{id}', 3, 0, '_self', '', 0, 1),

(26, 1, 1464080269, 1, 1651143119, 0, 0, 2, '操作日志', 'admin', 'AdminLog', 'index', 'adminlog', 2, 0, '_self', NULL, 0, 1),

(27, 1, 1464080269, 1, 1478192928, 0, 0, 26, '删除', 'admin', 'AdminLog', 'delete', 'adminlog/delete/{id}', 3, 0, '_self', '', 0, 1),

(28, 1, 1464080269, 1, 1651145982, 0, 0, 50, '文章分类', 'admin', 'ArticleCate', 'index', 'articlecate', 2, 0, '_self', NULL, 0, 1),

(29, 1, 1464080269, 1, 1478192928, 0, 0, 28, '添加', 'admin', 'ArticleCate', 'add', 'articlecate/add', 3, 0, '_self', '', 0, 1),

(30, 1, 1464080269, 1, 1478192928, 0, 0, 28, '编辑', 'admin', 'ArticleCate', 'edit', 'articlecate/edit/{id}', 3, 0, '_self', '', 0, 1),

(31, 1, 1464080269, 1, 1478192928, 0, 0, 28, '删除', 'admin', 'ArticleCate', 'delete', 'articlecate/delete/{id}', 3, 0, '_self', '', 0, 1),

(32, 1, 1464080269, 1, 1651145994, 0, 0, 50, '文章列表', 'admin', 'Article', 'index', 'article', 2, 0, '_self', NULL, 0, 1),

(33, 1, 1464080269, 1, 1478192928, 0, 0, 32, '添加', 'admin', 'Article', 'add', 'article/add', 3, 0, '_self', '', 0, 1),

(34, 1, 1464080269, 1, 1478192928, 0, 0, 32, '编辑', 'admin', 'Article', 'edit', 'article/edit/{id}', 3, 0, '_self', '', 0, 1),

(35, 1, 1464080269, 1, 1478192928, 0, 0, 32, '删除', 'admin', 'Article', 'delete', 'article/delete/{id}', 3, 0, '_self', '', 0, 1),

(36, 1, 1464080269, 1, 1478192928, 0, 0, 32, '导出', 'admin', 'Article', 'export', 'article/export', 3, 0, '_self', '', 0, 1),

(37, 1, 1608775353, 1, 1608775539, 0, 0, 13, '排序', 'admin', 'AdminMenu', 'listOrders', 'adminmenu/listOrders', 3, 10, '_self', NULL, 0, 1),

(39, 1, 1464080269, 1, 1651143448, 0, 0, 47, '数据库备份', 'admin', 'Database', 'export', 'database/export', 2, 0, '_self', NULL, 0, 1),

(40, 1, 1464080269, 1, 1478192928, 0, 0, 39, '备份提交', 'admin', 'Database', 'exportPost', 'database/exportPost', 3, 0, '_self', '', 0, 1),

(41, 1, 1464080269, 1, 1651143463, 0, 0, 47, '数据库还原', 'admin', 'Database', 'import', 'database/import', 2, 0, '_self', NULL, 0, 1),

(42, 1, 1464080269, 1, 1478192928, 0, 0, 41, '还原提交', 'admin', 'Database', 'importPost', 'database/importPost', 3, 0, '_self', '', 0, 1),

(43, 1, 1464080269, 1, 1478192928, 0, 0, 39, '优化表', 'admin', 'Database', 'optimize', 'database/optimize', 3, 0, '_self', '', 0, 1),

(44, 1, 1464080269, 1, 1478192928, 0, 0, 39, '修复表', 'admin', 'Database', 'repair', 'database/repair', 3, 0, '_self', '', 0, 1),

(45, 1, 1464080269, 1, 1651143595, 0, 0, 47, '删除备份文件', 'admin', 'Database', 'delete', 'database/delete', 3, 0, '_self', NULL, 0, 1),

(46, 1, 1464080269, 1, 1651143606, 0, 0, 47, '下载', 'admin', 'Database', 'download', 'database/download', 3, 0, '_self', NULL, 0, 1),

(47, 1, 1651143321, 1, 1651143341, 0, 0, 0, '系统安全', NULL, NULL, NULL, NULL, 1, 10, '_self', 'layui-icon-vercode', 0, 1),

(48, 1, 1651144709, 1, 1651145107, 0, 0, 10, '基础配置', 'admin', 'Config', 'home', 'config', 1, 10, '_self', NULL, 0, 1),

(49, 1, 1651144745, 1, 1651145126, 0, 0, 48, '编辑', 'admin', 'Config', 'edit', 'config/edit/{id}', 3, 10, '_self', NULL, 0, 1),

(50, 1, 1651145971, 1, 1651145971, 0, 0, 7, '文章', NULL, NULL, NULL, NULL, 1, 10, '_self', NULL, 0, 1);



-- --------------------------------------------------------



--

-- 表的结构 `la_admin_roles`

--



CREATE TABLE `la_admin_roles` (

  `id` int(10) UNSIGNED NOT NULL,

  `created_id` int(10) DEFAULT '0',

  `created_at` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',

  `updated_id` int(10) DEFAULT '0',

  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',

  `deleted_id` int(10) DEFAULT '0',

  `deleted_at` int(255) DEFAULT '0',

  `parent_id` int(10) UNSIGNED DEFAULT '0' COMMENT '上级ID',

  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',

  `remark` varchar(255) DEFAULT '' COMMENT '备注',

  `access` text COMMENT '用户组拥有的规则ID，多个规则 , 隔开（rules）',

  `sorting` int(10) NOT NULL DEFAULT '0' COMMENT '排序',

  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态 1：正常，2：禁用'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台角色表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_admin_roles`

--



INSERT INTO `la_admin_roles` (`id`, `created_id`, `created_at`, `updated_id`, `updated_at`, `deleted_id`, `deleted_at`, `parent_id`, `name`, `remark`, `access`, `sorting`, `status`) VALUES

(1, 0, 1521983887, 1, 1531665598, 0, 0, 0, '超级管理员', '拥有网站最高管理员权限！', '1,2,3,5,7,160,159,166,172,179,178,181,183,10,9,13,12,154,155,14,15,22,39,16,184,41,210,42,48,54,60,66,69,70,71,72,74,73,76,75,77,79,78,80,82,81,83,84,86,85,88,87,158,91,90,89,93,92,97,96,95,94,99,98,100,101,105,104,103,102,107,106,108,111,110,109,113,112,114,115,118,117,116,120,119,121,122,123,267,266,265,269,268,270,272,271,126,125,124,128,127,129,131,130,132,133,275,274,273,277,276,278,281,280,279,283,282,284,138,136,135,134,137,139,142,141,140,144,143,145,148,147,146,150,149,151,187,186,185,189,188,190,192,191,194,193,195,196,202,216,217,226,229,232,234,237,236,235,239,238,240,243,242,241,245,244,246,249,248,247,251,250,252,255,254,253,257,256,258,261,260,259,263,262,264,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,', 1, 1),

(2, 0, 1521983887, 1, 1609128540, 0, 0, 0, '分类管理员', '权限由最高管理员分配！', '1,12,2,25,26,27,28,29,30,31,32,33,7,17,18,19,20,21,22,23,24,8,13,14', 15, 2),

(3, 0, 1521983887, 1, 1604362820, 0, 0, 0, '文章管理员', '权限由最高管理员分配！', '1,7,2,10,9,12,14,23,22,31,39,15,42,41,48,54,60,66,70,69,71,72,78,85,84,87,89,95,103,102,17,16,20', 20, 1);



-- --------------------------------------------------------



--

-- 表的结构 `la_admin_role_user`

--



CREATE TABLE `la_admin_role_user` (

  `id` int(10) UNSIGNED NOT NULL,

  `role_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID',

  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理员ID'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员角色对应表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_admin_role_user`

--



INSERT INTO `la_admin_role_user` (`id`, `role_id`, `admin_id`) VALUES

(1, 1, 1),

(2, 2, 1),

(3, 3, 1),

(5, 3, 3),

(7, 1, 2);



-- --------------------------------------------------------



--

-- 表的结构 `la_articles`

--



CREATE TABLE `la_articles` (

  `id` int(10) UNSIGNED NOT NULL,

  `created_id` int(10) NOT NULL DEFAULT '0',

  `created_at` int(10) NOT NULL DEFAULT '0',

  `updated_id` int(10) NOT NULL DEFAULT '0',

  `updated_at` int(10) NOT NULL DEFAULT '0',

  `deleted_id` int(10) NOT NULL DEFAULT '0',

  `deleted_at` int(10) DEFAULT '0',

  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',

  `cate_id` int(10) DEFAULT NULL COMMENT '分类ID',

  `cover_img` varchar(120) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '封面图',

  `source` varchar(60) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '来源',

  `keywords` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '关键字',

  `description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',

  `content` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '内容',

  `count_views` int(10) DEFAULT NULL COMMENT '浏览量',

  `sorting` int(10) NOT NULL DEFAULT '0' COMMENT '排序',

  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1=显示 2=不显示'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='文章表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_articles`

--



INSERT INTO `la_articles` (`id`, `created_id`, `created_at`, `updated_id`, `updated_at`, `deleted_id`, `deleted_at`, `name`, `cate_id`, `cover_img`, `source`, `keywords`, `description`, `content`, `count_views`, `sorting`, `status`) VALUES

(1, 1, 1461766664, 1, 1608192674, 0, 0, '测试文章', 1, '', '', '关键字', '描述', '文章内容123', NULL, 15, 1),

(2, 1, 1608192653, 1, 1608884104, 0, 0, '测试文章002', 3, 'http://img.xiaolekeji.cn/5fdd69f908437.png', NULL, NULL, '文章描述', '<p>&nbsp; &nbsp; 这里是内容</p>\n<pre class=\"language-markup\"><code>{\n	\"code\": 200,\n	\"msg\": \"成功\",\n	\"data\": [\n		{\n			\"unitPrice\": 150,\n			\"materialUrl\": \"http://item.jd.com/100008969320.html\",\n			\"endDate\": 32472115200000,\n			\"isFreeFreightRisk\": 0,\n			\"isFreeShipping\": 2,\n			\"commisionRatioWl\": 2,\n			\"commisionRatioPc\": 2,\n			\"imgUrl\": \"http://img14.360buyimg.com/n1/jfs/t1/133781/23/5967/64052/5f27dcf9Ee5efcfbc/dd5f42a6c5dceeae.jpg\",\n			\"vid\": 1000308441,\n			\"cidName\": \"母婴\",\n			\"wlUnitPrice\": 150,\n			\"cid2Name\": \"营养辅食\",\n			\"isSeckill\": 0,\n			\"cid2\": 1524,\n			\"cid3Name\": \"DHA\",\n			\"inOrderCount\": 8343,\n			\"cid3\": 7055,\n			\"shopId\": 1000308441,\n			\"isJdSale\": 1,\n			\"goodsName\": \"爷爷的农场法国原装进口食用油DHA营养核桃油250ml\",\n			\"skuId\": 100008969320,\n			\"startDate\": 1597248000000,\n			\"cid\": 1319\n		}\n	]\n}</code></pre>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 47.3699%;\">&nbsp;</td>\n<td style=\"width: 47.5479%;\">&nbsp;</td>\n</tr>\n<tr>\n<td style=\"width: 47.3699%;\">&nbsp;</td>\n<td style=\"width: 47.5479%;\">&nbsp;</td>\n</tr>\n</tbody>\n</table>\n<p><img src=\"http://img.xiaolekeji.cn/5fe43b3b61fa1.png\" width=\"491\" height=\"270\" /></p>\n<p>这里还是内容，这里还是内容。</p>', NULL, 10, 1),

(3, 1, 1608345961, 1, 1608684333, 0, 0, '测试003', 3, 'http://img.xiaolekeji.cn/5fdd6942d49b1.png', '本站', NULL, '描述', '<img src=\"http://img.xiaolekeji.cn/5fdd694c73299.png\" alt=\"\"><img src=\"http://img.xiaolekeji.cn/5fdd6951b04d2.png\" alt=\"\"><img src=\"http://manage.xlkj.cn/static/plugins/layui/images/face/63.gif\" alt=\"[给力]\">', NULL, 10, 1);



-- --------------------------------------------------------



--

-- 表的结构 `la_article_cate`

--



CREATE TABLE `la_article_cate` (

  `id` int(10) UNSIGNED NOT NULL,

  `created_id` int(10) NOT NULL DEFAULT '0',

  `created_at` int(10) NOT NULL DEFAULT '0',

  `updated_id` int(10) NOT NULL DEFAULT '0',

  `updated_at` int(10) NOT NULL DEFAULT '0',

  `deleted_id` int(10) NOT NULL DEFAULT '0',

  `deleted_at` int(10) DEFAULT '0',

  `parent_id` int(10) DEFAULT '0' COMMENT '上级ID',

  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',

  `sub_name` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '副标题',

  `icon` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'icon图标',

  `cover_img` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '封面图',

  `sorting` int(10) NOT NULL DEFAULT '0' COMMENT '排序',

  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1=显示 2=不显示'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='文章分类表' ROW_FORMAT=DYNAMIC;



--

-- 转存表中的数据 `la_article_cate`

--



INSERT INTO `la_article_cate` (`id`, `created_id`, `created_at`, `updated_id`, `updated_at`, `deleted_id`, `deleted_at`, `parent_id`, `name`, `sub_name`, `icon`, `cover_img`, `sorting`, `status`) VALUES

(1, 1, 1461766664, 1, 1608519330, 1, 1608519330, 0, '功能更新', '系统代码每日更新每周发布', '', NULL, 10, 1),

(2, 1, 1608188451, 1, 1608519309, 1, 1608519309, 0, '运营知识', '互联网运营知识分享', '', 'http://img.xiaolekeji.cn/5fdd97d5e1801.png', 10, 1),

(3, 1, 1608188911, 1, 1608519459, 1, 1608519208, 0, '行业动态', '最新互联网消息', '', 'http://img.xiaolekeji.cn/5fdda2012a4f4.png', 10, 1),

(4, 1, 1608365300, 1, 1620183623, 1, 1608519190, 0, '11', '111', '', NULL, 10, 2);



-- --------------------------------------------------------



--

-- 表的结构 `la_config`

--



CREATE TABLE `la_config` (

  `id` int(11) NOT NULL COMMENT '网站配置ID',

  `updated_id` int(10) NOT NULL COMMENT '更新者',

  `updated_at` int(10) NOT NULL COMMENT '更新时间',

  `logo` varchar(255) DEFAULT NULL COMMENT '网站LOGO',

  `name` varchar(200) NOT NULL COMMENT '网站名称',

  `slogan` varchar(255) DEFAULT NULL COMMENT '网站副标题',

  `domain` varchar(255) DEFAULT NULL COMMENT '网站域名',

  `keywords` varchar(255) DEFAULT NULL COMMENT '关键词',

  `description` text COMMENT '描述',

  `beian` varchar(255) DEFAULT NULL COMMENT '网站备案号',

  `favico` varchar(255) DEFAULT NULL COMMENT '网站IOC',

  `templatecolor` varchar(255) DEFAULT NULL COMMENT '模板主色调',

  `is_open` int(1) NOT NULL DEFAULT '1' COMMENT '1开启0关闭',

  `statistics` text COMMENT '统计代码',

  `customer` text COMMENT '自定义客服',

  `is_gray` int(1) DEFAULT '0' COMMENT '1首页灰色0关闭'

) ENGINE=MyISAM DEFAULT CHARSET=utf8;



--

-- 转存表中的数据 `la_config`

--



INSERT INTO `la_config` (`id`, `updated_id`, `updated_at`, `logo`, `name`, `slogan`, `domain`, `keywords`, `description`, `beian`, `favico`, `templatecolor`, `is_open`, `statistics`, `customer`, `is_gray`) VALUES

(1, 0, 1651145932, 'uploads/default/2022-04/28/626a7b505daf5.jpg', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx', 'uploads/default/2022-04/28/626a7ccaed46d.jpg', '#3555cc', 1, 'xxxxxxx', 'xxxxxxx', 1);



--

-- 转储表的索引

--



--

-- 表的索引 `la_admins`

--

ALTER TABLE `la_admins`

  ADD PRIMARY KEY (`id`) USING BTREE;



--

-- 表的索引 `la_admin_logs`

--

ALTER TABLE `la_admin_logs`

  ADD PRIMARY KEY (`id`) USING BTREE;



--

-- 表的索引 `la_admin_menu`

--

ALTER TABLE `la_admin_menu`

  ADD PRIMARY KEY (`id`) USING BTREE;



--

-- 表的索引 `la_admin_roles`

--

ALTER TABLE `la_admin_roles`

  ADD PRIMARY KEY (`id`) USING BTREE,

  ADD KEY `parentId` (`parent_id`) USING BTREE,

  ADD KEY `status` (`status`) USING BTREE;



--

-- 表的索引 `la_admin_role_user`

--

ALTER TABLE `la_admin_role_user`

  ADD PRIMARY KEY (`id`) USING BTREE,

  ADD KEY `group_id` (`role_id`) USING BTREE,

  ADD KEY `user_id` (`admin_id`) USING BTREE;



--

-- 表的索引 `la_articles`

--

ALTER TABLE `la_articles`

  ADD PRIMARY KEY (`id`) USING BTREE;



--

-- 表的索引 `la_article_cate`

--

ALTER TABLE `la_article_cate`

  ADD PRIMARY KEY (`id`) USING BTREE;



--

-- 表的索引 `la_config`

--

ALTER TABLE `la_config`

  ADD PRIMARY KEY (`id`),

  ADD KEY `web` (`id`) USING BTREE;



--

-- 在导出的表使用AUTO_INCREMENT

--



--

-- 使用表AUTO_INCREMENT `la_admins`

--

ALTER TABLE `la_admins`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;



--

-- 使用表AUTO_INCREMENT `la_admin_logs`

--

ALTER TABLE `la_admin_logs`

  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;



--

-- 使用表AUTO_INCREMENT `la_admin_menu`

--

ALTER TABLE `la_admin_menu`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;



--

-- 使用表AUTO_INCREMENT `la_admin_roles`

--

ALTER TABLE `la_admin_roles`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;



--

-- 使用表AUTO_INCREMENT `la_admin_role_user`

--

ALTER TABLE `la_admin_role_user`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;



--

-- 使用表AUTO_INCREMENT `la_articles`

--

ALTER TABLE `la_articles`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;



--

-- 使用表AUTO_INCREMENT `la_article_cate`

--

ALTER TABLE `la_article_cate`

  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;



--

-- 使用表AUTO_INCREMENT `la_config`

--

ALTER TABLE `la_config`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '网站配置ID', AUTO_INCREMENT=2;

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 */;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/syssys001/laravel8-layui-zifengye.git
[email protected]:syssys001/laravel8-layui-zifengye.git
syssys001
laravel8-layui-zifengye
laravel8-layui-zifengye
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部