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

BIGGRAYBEAR-HZK/dms

forked from zhaosheng/dms 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
man.sql 15.30 KB
一键复制 编辑 原始数据 按行查看 历史
zhaosheng 提交于 2017-09-03 22:19 . 开发完成，发布
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252
-- phpMyAdmin SQL Dump

-- version 4.7.3

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

--

-- Host: 127.0.0.1:3306

-- Generation Time: 2017-09-03 13:28:11

-- 服务器版本： 5.6.37

-- PHP Version: 5.6.31



SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;

START TRANSACTION;

SET time_zone = "+00:00";



--

-- Database: `man`

--



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



--

-- 表的结构 `admin_group`

--



CREATE TABLE `admin_group` (

  `group_id` int(3) NOT NULL,

  `group_name` varchar(10) DEFAULT NULL,

  `group_desc` varchar(64) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色组';



--

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

--



INSERT INTO `admin_group` (`group_id`, `group_name`, `group_desc`) VALUES

(1, '管理员', ''),

(2, '平台运营', ''),

(3, '测试组', ''),

(4, '产品组', '');



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



--

-- 表的结构 `admin_info`

--



CREATE TABLE `admin_info` (

  `admin_id` int(12) NOT NULL,

  `group_id` int(3) NOT NULL,

  `admin_user_name` varchar(16) DEFAULT NULL,

  `admin_pwd` varchar(32) DEFAULT NULL,

  `admin_real_name` varchar(30) DEFAULT NULL,

  `admin_phone` varchar(11) DEFAULT NULL,

  `admin_qq` varchar(15) DEFAULT NULL,

  `admin_weixin` varchar(15) NOT NULL,

  `admin_email` varchar(32) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员信息';



--

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

--



INSERT INTO `admin_info` (`admin_id`, `group_id`, `admin_user_name`, `admin_pwd`, `admin_real_name`, `admin_phone`, `admin_qq`, `admin_weixin`, `admin_email`) VALUES

(1, 1, 'admin', '14e1b600b1fd579f47433b88e8d85291', '超级管理员', '', '', 'fdasf', ''),

(251, 3, 'zhaosheng', '14e1b600b1fd579f47433b88e8d85291', 'yzs', '', '', '', ''),

(252, 4, 'test', '14e1b600b1fd579f47433b88e8d85291', 'test', '', '', '', ''),

(253, 1, 'test2', '14e1b600b1fd579f47433b88e8d85291', '', '', '', '', '');



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



--

-- 表的结构 `admin_log`

--



CREATE TABLE `admin_log` (

  `id` int(11) NOT NULL,

  `menu` varchar(8) NOT NULL COMMENT '管理',

  `oper` varchar(32) NOT NULL COMMENT '操作类型',

  `remark` varchar(1024) NOT NULL COMMENT '备注',

  `admin` varchar(32) NOT NULL COMMENT '管理员',

  `ip` varchar(15) NOT NULL,

  `uptime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志表';



--

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

--



INSERT INTO `admin_log` (`id`, `menu`, `oper`, `remark`, `admin`, `ip`, `uptime`) VALUES

(1, '菜单管理', '', '', '', '', '2017-08-31 13:27:49'),

(2, '登录', '登录成功', '', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 13:39:52'),

(3, '退出操作', '', '', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 13:47:01'),

(4, '登录操作', '登录成功', '', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 13:47:36'),

(5, '菜单管理', '更新操作', 'UPDATE menu_info SET `menu_name` = \'管理员列表\',`menu_link` = \'/admin/manager/admin.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'33\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'3\' WHERE 1 AND `menu_id`=\'3\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:25:05'),

(6, '菜单管理', '管理员列表-更新操作', 'UPDATE menu_info SET `menu_name` = \'管理员列表\',`menu_link` = \'/admin/manager/admin.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'3\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'3\' WHERE 1 AND `menu_id`=\'3\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:26:54'),

(7, '菜单管理', '权限管理-新增操作', 'INSERT INTO menu_info (`menu_name`,`menu_link`,`menu_level`,`menu_par_id`,`menu_order`,`menu_show`,`menu_system`) VALUES (\'权限管理\',\'admin/manager/auty.php\',\'2\',\'1\',\'0\',\'1\',\'管理后台系统\') ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:33:08'),

(8, '管理员管理', 'zhaosheng-新增操作', 'INSERT INTO admin_info (`admin_user_name`,`admin_pwd`,`group_id`,`admin_real_name`,`admin_phone`,`admin_qq`,`admin_weixin`,`admin_email`) VALUES (\'zhaosheng\',\'14e1b600b1fd579f47433b88e8d85291\',\'3\',\'yzs\',\'\',\'\',\'\',\'\') ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:35:05'),

(9, '菜单管理', '权限管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'权限管理\',`menu_link` = \'admin/manager/auty_edit.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'0\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'4\' WHERE 1 AND `menu_id`=\'4\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:35:48'),

(10, '退出操作', '', '', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:47:28'),

(11, '登录操作', '登录成功', '', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:47:35'),

(12, '菜单管理', '角色管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'角色管理\',`menu_link` = \'/admin/manager/admin.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'3\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'3\' WHERE 1 AND `menu_id`=\'3\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:58:47'),

(13, '菜单管理', '菜单管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'菜单管理\',`menu_link` = \'/admin/manager/menu.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'999\',`menu_show` = \'1\',`menu_system` = \'管理后台\',`menu_id` = \'2\' WHERE 1 AND `menu_id`=\'2\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:59:32'),

(14, '菜单管理', '菜单管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'菜单管理\',`menu_link` = \'/admin/manager/menu.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'999\',`menu_show` = \'1\',`menu_system` = \'管理后台\',`menu_id` = \'2\' WHERE 1 AND `menu_id`=\'2\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 14:59:36'),

(15, '菜单管理', '菜单管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'菜单管理\',`menu_link` = \'/admin/manager/menu.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'999\',`menu_show` = \'1\',`menu_system` = \'管理后台\',`menu_id` = \'2\' WHERE 1 AND `menu_id`=\'2\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 15:00:43'),

(16, '菜单管理', '操作日志-新增操作', 'INSERT INTO menu_info (`menu_name`,`menu_link`,`menu_level`,`menu_par_id`,`menu_order`,`menu_show`,`menu_system`) VALUES (\'操作日志\',\'/admin/manager/log.php\',\'2\',\'1\',\'0\',\'1\',\'管理后台系统\') ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 15:01:43'),

(17, '菜单管理', '系统管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'系统管理\',`menu_link` = \'\',`menu_level` = \'1\',`menu_par_id` = \'0\',`menu_order` = \'1\',`menu_show` = \'1\',`menu_system` = \'管理后台\',`menu_id` = \'1\' WHERE 1 AND `menu_id`=\'1\' ', 'admin[超级管理员]', '14.155.112.179', '2017-08-31 15:02:00'),

(18, '登录操作', '登录成功', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 10:35:05'),

(19, '管理员管理', 'test-新增操作', 'INSERT INTO admin_info (`admin_user_name`,`admin_pwd`,`group_id`,`admin_real_name`,`admin_phone`,`admin_qq`,`admin_weixin`,`admin_email`) VALUES (\'test\',\'14e1b600b1fd579f47433b88e8d85291\',\'4\',\'test\',\'\',\'\',\'\',\'\') ', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 10:39:17'),

(20, '菜单管理', '后台管理-新增操作', 'INSERT INTO menu_info (`menu_name`,`menu_link`,`menu_level`,`menu_par_id`,`menu_order`,`menu_show`,`menu_system`) VALUES (\'后台管理\',\'\',\'1\',\'0\',\'0\',\'1\',\'管理后台系统\') ', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 11:24:51'),

(21, '菜单管理', '角色管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'角色管理\',`menu_link` = \'/admin/manager/admin.php\',`menu_level` = \'2\',`menu_par_id` = \'6\',`menu_order` = \'3\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'3\' WHERE 1 AND `menu_id`=\'3\' ', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 11:25:02'),

(22, '管理员管理', '-更新操作', 'UPDATE admin_info SET `pers` = \'\' WHERE 1 AND `admin_id`=\'\' ', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 12:25:20'),

(23, '退出操作', '', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 13:43:21'),

(24, '登录操作', '登录成功', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 13:43:28'),

(25, '退出操作', '', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 13:52:30'),

(26, '登录操作', '登录成功', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 13:52:35'),

(27, '退出操作', '', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:24:22'),

(28, '登录操作', '登录成功', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:24:29'),

(29, '权限管理', '251', '{\"admin_id\":\"251\",\"action\":\"edit\",\"pers\":[\"4_1\"]}', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:52:37'),

(30, '权限管理', '251', '{\"admin_id\":\"251\",\"action\":\"edit\",\"pers\":[\"5_1\",\"4_1\"]}', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:53:03'),

(31, '权限管理', '251', '{\"admin_id\":\"251\",\"action\":\"edit\",\"pers\":[\"5_1\",\"4_1\"]}', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:53:22'),

(32, '权限管理', '251', '{\"admin_id\":\"251\",\"action\":\"edit\",\"pers\":[\"5_1\",\"4_1\"]}', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:54:04'),

(33, '权限管理', '251', '{\"admin_id\":\"251\",\"action\":\"edit\",\"pers\":[\"5_1\",\"4_1\"]}', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:54:35'),

(34, '权限管理', '251', '{\"admin_id\":\"251\",\"action\":\"edit\",\"pers\":[\"5_1\",\"4_1\"]}', 'admin[超级管理员]', '183.37.24.74', '2017-09-02 14:57:29'),

(35, '登录操作', '登录成功', '', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 06:10:02'),

(36, '菜单管理', '操作日志-更新操作', 'UPDATE menu_info SET `menu_name` = \'操作日志\',`menu_link` = \'/admin/manager/adminlog.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'0\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'5\' WHERE 1 AND `menu_id`=\'5\' ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 06:13:43'),

(37, '菜单管理', '其它业务-更新操作', 'UPDATE menu_info SET `menu_name` = \'其它业务\',`menu_link` = \'\',`menu_level` = \'1\',`menu_par_id` = \'0\',`menu_order` = \'0\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'6\' WHERE 1 AND `menu_id`=\'6\' ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 12:57:59'),

(38, '菜单管理', '角色管理-更新操作', 'UPDATE menu_info SET `menu_name` = \'角色管理\',`menu_link` = \'/admin/manager/admin.php\',`menu_level` = \'2\',`menu_par_id` = \'1\',`menu_order` = \'3\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'3\' WHERE 1 AND `menu_id`=\'3\' ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 12:58:09'),

(39, '菜单管理', '操作日志-更新操作', 'UPDATE menu_info SET `menu_name` = \'操作日志\',`menu_link` = \'/admin/manager/adminlog.php\',`menu_level` = \'2\',`menu_par_id` = \'6\',`menu_order` = \'0\',`menu_show` = \'1\',`menu_system` = \'管理后台系统\',`menu_id` = \'5\' WHERE 1 AND `menu_id`=\'5\' ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 12:58:25'),

(40, '菜单管理', 'test-新增操作', 'INSERT INTO menu_info (`menu_name`,`menu_link`,`menu_level`,`menu_par_id`,`menu_order`,`menu_show`,`menu_system`) VALUES (\'test\',\'\',\'1\',\'0\',\'0\',\'1\',\'管理后台系统\') ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 13:06:40'),

(41, '管理员管理', 'test2-新增操作', 'INSERT INTO admin_info (`admin_user_name`,`admin_pwd`,`group_id`,`admin_real_name`,`admin_phone`,`admin_qq`,`admin_weixin`,`admin_email`) VALUES (\'test2\',\'14e1b600b1fd579f47433b88e8d85291\',\'1\',\'\',\'\',\'\',\'\',\'\') ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 13:06:54'),

(42, '菜单管理', '7-删除操作', 'DELETE FROM menu_info WHERE 1 AND menu_id in (7) ', 'admin[超级管理员]', '183.37.24.74', '2017-09-03 13:07:20');



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



--

-- 表的结构 `admin_menu`

--



CREATE TABLE `admin_menu` (

  `admin_id` int(12) NOT NULL,

  `menu_id` int(3) NOT NULL,

  `menu_power_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1:查看 2:编辑'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员-后台功能关系';



--

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

--



INSERT INTO `admin_menu` (`admin_id`, `menu_id`, `menu_power_type`) VALUES

(1, 2, 1),

(1, 2, 2),

(1, 3, 1),

(1, 3, 2),

(1, 4, 1),

(1, 4, 2),

(1, 5, 1),

(1, 5, 2),

(251, 4, 1),

(251, 5, 1);



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



--

-- 表的结构 `menu_info`

--



CREATE TABLE `menu_info` (

  `menu_id` int(3) NOT NULL,

  `menu_name` varchar(30) DEFAULT NULL,

  `menu_link` varchar(64) DEFAULT NULL,

  `menu_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:显示 2:隐藏',

  `menu_level` tinyint(4) DEFAULT NULL,

  `menu_par_id` varchar(3) DEFAULT NULL,

  `menu_system` varchar(16) DEFAULT NULL COMMENT '系统',

  `menu_order` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台功能管理';



--

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

--



INSERT INTO `menu_info` (`menu_id`, `menu_name`, `menu_link`, `menu_show`, `menu_level`, `menu_par_id`, `menu_system`, `menu_order`) VALUES

(1, '系统管理', '', 1, 1, '0', '管理后台', 1),

(2, '菜单管理', '/admin/manager/menu.php', 1, 2, '1', '管理后台', 999),

(3, '角色管理', '/admin/manager/admin.php', 1, 2, '1', '管理后台系统', 3),

(4, '权限管理', 'admin/manager/auty_edit.php', 1, 2, '1', '管理后台系统', 0),

(5, '操作日志', '/admin/manager/adminlog.php', 1, 2, '6', '管理后台系统', 0),

(6, '其它业务', '', 1, 1, '0', '管理后台系统', 0);



--

-- Indexes for dumped tables

--



--

-- Indexes for table `admin_group`

--

ALTER TABLE `admin_group`

  ADD PRIMARY KEY (`group_id`);



--

-- Indexes for table `admin_info`

--

ALTER TABLE `admin_info`

  ADD PRIMARY KEY (`admin_id`),

  ADD UNIQUE KEY `admin_user_name` (`admin_user_name`),

  ADD KEY `FK_admin_group` (`group_id`);



--

-- Indexes for table `admin_log`

--

ALTER TABLE `admin_log`

  ADD PRIMARY KEY (`id`),

  ADD KEY `menu` (`menu`),

  ADD KEY `oper` (`oper`),

  ADD KEY `admin` (`admin`);



--

-- Indexes for table `admin_menu`

--

ALTER TABLE `admin_menu`

  ADD UNIQUE KEY `ad` (`admin_id`,`menu_id`,`menu_power_type`) USING BTREE;



--

-- Indexes for table `menu_info`

--

ALTER TABLE `menu_info`

  ADD PRIMARY KEY (`menu_id`);



--

-- 在导出的表使用AUTO_INCREMENT

--



--

-- 使用表AUTO_INCREMENT `admin_group`

--

ALTER TABLE `admin_group`

  MODIFY `group_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--

-- 使用表AUTO_INCREMENT `admin_info`

--

ALTER TABLE `admin_info`

  MODIFY `admin_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=254;

--

-- 使用表AUTO_INCREMENT `admin_log`

--

ALTER TABLE `admin_log`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--

-- 使用表AUTO_INCREMENT `menu_info`

--

ALTER TABLE `menu_info`

  MODIFY `menu_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;COMMIT;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
PHP
1
https://gitee.com/hzkdemo/dms.git
[email protected]:hzkdemo/dms.git
hzkdemo
dms
dms
master
点此查找更多帮助

搜索帮助

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