登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
当前仓库属于暂停状态，部分功能使用受限，详情请查阅 仓库状态说明
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 1 Fork 7

黑米网络/Colin CMS
暂停

forked from Colin/yii2-admin 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
colin_cms.sql 30.74 KB
一键复制 编辑 原始数据 按行查看 历史
Colin 提交于 2019-07-15 13:30 . 修复sql文件menu的拼写错误
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441
/*

SQLyog Ultimate v13.1.1 (64 bit)

MySQL - 5.5.53 : Database - colin_cms

*********************************************************************

*/



/*!40101 SET NAMES utf8 */;



/*!40101 SET SQL_MODE=''*/;



/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

/*Table structure for table `colin_login_log` */



DROP TABLE IF EXISTS `colin_login_log`;



CREATE TABLE `colin_login_log` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '登陆日志',

  `user_id` int(11) DEFAULT NULL COMMENT '用户id',

  `ip` varchar(20) DEFAULT NULL COMMENT 'ip地址',

  `address` varchar(100) DEFAULT NULL COMMENT '位置',

  `browser` varchar(100) DEFAULT NULL COMMENT '浏览器',

  `os` varchar(50) DEFAULT NULL COMMENT '操作系统',

  `user_agent` varchar(255) DEFAULT NULL COMMENT '用户代理',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;



/*Data for the table `colin_login_log` */



insert  into `colin_login_log`(`id`,`user_id`,`ip`,`address`,`browser`,`os`,`user_agent`,`create_time`) values

(9,1,'127.0.0.1','北京市 北京市',NULL,NULL,NULL,1553440309),

(10,6,'127.0.0.1','北京市 北京市',NULL,NULL,NULL,1553440394),

(11,1,'127.0.0.1','北京市 北京市',NULL,NULL,NULL,1553440915),

(12,1,'127.0.0.1','北京市 北京市',NULL,NULL,NULL,1553440996),

(13,1,'127.0.0.1','安徽省 合肥市',NULL,NULL,NULL,1553441073),

(14,6,'127.0.0.1','安徽省 合肥市',NULL,NULL,NULL,1553441107),

(15,1,'127.0.0.1','北京市 北京市',NULL,NULL,NULL,1553559638),

(16,1,'127.0.0.1','北京市 北京市',NULL,NULL,NULL,1553590599),

(17,1,'::1','北京市 北京市',NULL,NULL,NULL,1555926498),

(18,1,'::1','北京市 北京市',NULL,NULL,NULL,1557297906),

(19,1,'::1','北京市 北京市','Chrome(74.0.3729.131)','Windows 7',NULL,1557298406),

(20,1,'::1','北京市 北京市','Chrome(74.0.3729.131)','Android5.0',NULL,1557303575),

(21,1,'::1','北京市 北京市','Safari(604.1)','iPhone 11.0',NULL,1557303646),

(22,1,'::1','北京市 北京市','Chrome(74.0.3729.131)','Windows 7','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36',1557309303);



/*Table structure for table `colin_member` */



DROP TABLE IF EXISTS `colin_member`;



CREATE TABLE `colin_member` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '前台用户表',

  `nickname` varchar(100) DEFAULT NULL COMMENT '昵称',

  `tel` varchar(15) DEFAULT NULL COMMENT '手机号',

  `password` varchar(100) DEFAULT NULL COMMENT '密码',

  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',

  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1:启用 2:禁用',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;



/*Data for the table `colin_member` */



insert  into `colin_member`(`id`,`nickname`,`tel`,`password`,`email`,`status`,`create_time`) values

(1,'Colin','17312341238','$2y$13$r7Tb8JB..LpxahNQEGfrAOwKcVZlXM73OEHn/nOMeZ3Zmn4PDWJwC','12345216@qq.com',1,1521768073),

(2,'Colin2','17312341235',NULL,'12345678@qq.com',1,1521768273),

(3,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(4,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(5,'Colin2','17312341235',NULL,'12345678@qq.com',1,1521768273),

(26,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(27,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(28,'Colin2','17312341235',NULL,'12345678@qq.com',2,1521768273),

(29,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(30,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(31,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(32,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(33,'张三','17300000000',NULL,'123456@qq.com',1,1521768073),

(34,'张三','17300000000',NULL,'123456@qq.com',1,1521768073),

(35,'张三','17300000000',NULL,'123456@qq.com',1,1521768073),

(36,'张三','17300000000',NULL,'123456@qq.com',2,1521768073),

(37,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(38,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(40,'Colin','17312341234',NULL,'123456@qq.com',2,1521768073),

(41,'张三','17300000000',NULL,'123456@qq.com',1,1521768073),

(42,'Colin','17312341234',NULL,'123456@qq.com',1,1521768073),

(43,'Colin','17312341234',NULL,'123456@qq.com',2,1521768073),

(56,'李四2','17812341234','$2y$13$FkGSqk0aX2QSsscvQhQm5.XnGK9EkL8vJb3Z1Niez2MStWcQkeAUW','lisi@qq.com',1,1552446687),

(57,'TEST','17352902344','$2y$13$s5Na35XAgm3Odq0QzT0uteLFPSWCgJ8PLE95sh1hP/q5JnvhOZWK2','123@qq.com',2,1552446738),

(58,'medoo','17312341200',NULL,'medoo@qq.com',1,NULL);



/*Table structure for table `colin_menu` */



DROP TABLE IF EXISTS `colin_menu`;



CREATE TABLE `colin_menu` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单表',

  `name` varchar(100) DEFAULT NULL COMMENT '菜单名',

  `icon` varchar(32) DEFAULT NULL COMMENT '图标',

  `sort` int(11) DEFAULT '10' COMMENT '排序',

  `is_show` tinyint(1) DEFAULT '1' COMMENT '是否显示 1:显示 2:隐藏',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;



/*Data for the table `colin_menu` */



insert  into `colin_menu`(`id`,`name`,`icon`,`sort`,`is_show`,`create_time`) values

(1,'会员管理','',20,1,1521768073),

(2,'管理员管理','',16,1,1521768073),

(3,'日志管理','',10,1,1521768073),

(4,'系统设置','',8,1,1521768073);



/*Table structure for table `colin_operate_log` */



DROP TABLE IF EXISTS `colin_operate_log`;



CREATE TABLE `colin_operate_log` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '操作日志表',

  `user_id` int(11) DEFAULT NULL COMMENT '用户id',

  `route_name` varchar(100) DEFAULT NULL COMMENT '路由名',

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

  `param` text COMMENT '参数',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8;



/*Data for the table `colin_operate_log` */



insert  into `colin_operate_log`(`id`,`user_id`,`route_name`,`route`,`param`,`create_time`) values

(5,1,'会员添加','member/create','[]',1553523661),

(6,1,'会员添加','member/create','{\"nickname\":\"1234545\",\"email\":\"12123232\",\"tel\":\"17352909090\",\"status\":\"1\",\"pwd\":\"123\"}',1553523684),

(7,1,'会员编辑','member/update','{\"id\":\"58\"}',1553523693),

(8,1,'会员编辑','member/update','{\"id\":\"58\",\"nickname\":\"1234545\",\"email\":\"12123232@qq.com\",\"tel\":\"17352909090\",\"status\":\"1\",\"pwd\":\"\"}',1553523699),

(9,1,'子菜单列表','menu/submenu','{\"id\":\"3\"}',1553525219),

(10,1,'路由列表','menu/route','{\"id\":\"6\"}',1553525223),

(11,1,'路由添加','menu/route-create','{\"submenu_id\":\"6\"}',1553525225),

(12,1,'路由添加','menu/route-create','{\"submenu_id\":\"6\"}',1553525274),

(13,1,'路由添加','menu/route-create','{\"submenu_id\":\"6\",\"route_name\":\"\\u64cd\\u4f5c\\u65e5\\u5fd7\\u67e5\\u770b\\u53c2\\u6570\",\"route\":\"operate-log\\/view\",\"status\":\"1\"}',1553525306),

(14,1,'路由列表','menu/route','{\"id\":\"6\"}',1553525308),

(15,1,'角色编辑','role/update','{\"id\":\"1\"}',1553525316),

(16,1,'角色编辑','role/update','{\"id\":\"1\",\"name\":\"\\u8d85\\u7ea7\\u7ba1\\u7406\\u5458\",\"description\":\"\\u62e5\\u6709\\u6240\\u6709\\u6743\\u9650\",\"ids\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"23\",\"24\",\"25\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"33\",\"34\",\"35\",\"36\",\"37\",\"41\",\"42\",\"43\",\"44\",\"12\",\"13\",\"14\",\"15\",\"16\",\"17\",\"38\",\"39\",\"40\",\"18\",\"19\",\"20\",\"21\",\"22\"]}',1553525327),

(17,1,'操作日志查看参数','operate-log/view','{\"id\":\"16\"}',1553525365),

(18,1,'操作日志查看参数','operate-log/view','{\"id\":\"17\"}',1553525837),

(19,1,'操作日志查看参数','operate-log/view','{\"id\":\"15\"}',1553525847),

(20,1,'操作日志查看参数','operate-log/view','{\"id\":\"17\"}',1553525862),

(21,1,'操作日志查看参数','operate-log/view','{\"id\":\"17\"}',1553525867),

(22,1,'操作日志查看参数','operate-log/view','{\"id\":\"13\"}',1553525875),

(23,1,'操作日志查看参数','operate-log/view','{\"id\":\"17\"}',1553525892),

(24,1,'操作日志查看参数','operate-log/view','{\"id\":\"23\"}',1553526068),

(25,1,'操作日志查看参数','operate-log/view','{\"id\":\"23\"}',1553526097),

(26,1,'操作日志查看参数','operate-log/view','{\"id\":\"25\"}',1553526182),

(27,1,'操作日志查看参数','operate-log/view','{\"id\":\"26\"}',1553526221),

(28,1,'操作日志查看参数','operate-log/view','{\"id\":\"26\"}',1553526337),

(29,1,'操作日志查看参数','operate-log/view','{\"id\":\"28\"}',1553526395),

(30,1,'管理员编辑','user/update','{\"id\":\"7\"}',1553526410),

(31,1,'操作日志查看参数','operate-log/view','{\"id\":\"28\"}',1553526422),

(32,1,'操作日志查看参数','operate-log/view','{\"id\":\"31\"}',1553526455),

(33,1,'操作日志查看参数','operate-log/view','{\"id\":\"30\"}',1553526482),

(34,1,'会员编辑','member/update','{\"id\":\"58\"}',1553528085),

(35,1,'会员编辑','member/update','{\"id\":\"58\",\"nickname\":\"12345451\",\"email\":\"12123232@qq.com\",\"tel\":\"17352909090\",\"status\":\"1\",\"pwd\":\"\"}',1553528091),

(36,1,'会员删除','member/del','{\"id\":\"58\"}',1553528100),

(37,1,'角色编辑','role/update','{\"id\":\"1\"}',1553528108),

(38,1,'角色编辑','role/update','{\"id\":\"15\"}',1553528121),

(39,1,'角色编辑','role/update','{\"id\":\"15\",\"name\":\"财务\",\"description\":\"财务权限\",\"ids\":{\"0\":\"1\",\"6\":\"23\",\"7\":\"24\",\"8\":\"25\",\"9\":\"26\",\"10\":\"27\",\"11\":\"28\",\"12\":\"29\",\"13\":\"30\",\"14\":\"31\",\"15\":\"32\",\"16\":\"33\",\"17\":\"34\",\"18\":\"35\",\"19\":\"36\",\"20\":\"37\",\"21\":\"41\",\"25\":\"12\",\"31\":\"38\",\"34\":\"18\"}}',1553528140),

(40,1,'子菜单添加','menu/submenu-create','{\"menu_id\":\"1\"}',1553559723),

(41,1,'角色编辑','role/update','{\"id\":\"1\"}',1553559843),

(42,1,'会员状态修改','member/change-status','{\"id\":\"56\",\"status\":\"2\"}',1553562837),

(43,1,'会员状态修改','member/change-status','{\"id\":\"40\",\"status\":\"1\"}',1553562840),

(44,1,'会员状态修改','member/change-status','{\"id\":\"28\",\"status\":\"1\"}',1553562872),

(45,1,'会员状态修改','member/change-status','{\"id\":\"28\",\"status\":\"1\"}',1553562873),

(46,1,'会员编辑','member/update','{\"id\":\"28\"}',1553562882),

(47,1,'管理员状态修改','user/change-status','{\"id\":\"6\",\"status\":\"1\"}',1553562913),

(48,1,'管理员编辑','user/update','{\"id\":\"6\"}',1553562915),

(49,1,'管理员状态修改','user/change-status','{\"id\":\"6\",\"status\":\"1\"}',1553562919),

(50,1,'管理员编辑','user/update','{\"id\":\"7\"}',1553563411),

(51,1,'管理员编辑','user/update','{\"id\":\"1\"}',1553595960),

(52,1,'管理员编辑','user/update','{\"id\":\"1\",\"name\":\"admin\",\"role_id\":\"1\",\"status\":\"1\",\"pwd\":\"123456\"}',1553595964),

(53,1,'子菜单添加','menu/submenu-create','{\"menu_id\":\"4\"}',1553599063),

(54,1,'子菜单添加','menu/submenu-create','{\"menu_id\":\"4\"}',1553599079),

(55,1,'子菜单添加','menu/submenu-create','{\"menu_id\":\"4\",\"route_name\":\"系统设置\",\"route\":\"set\\/index\",\"sort\":\"10\",\"is_show\":\"1\"}',1553599092),

(56,1,'路由添加','menu/route-create','{\"submenu_id\":\"7\"}',1553599100),

(57,1,'路由添加','menu/route-create','{\"submenu_id\":\"7\",\"route_name\":\"系统设置查看\",\"route\":\"set\\/index\",\"status\":\"1\"}',1553599121),

(58,1,'角色编辑','role/update','{\"id\":\"1\"}',1553599562),

(59,1,'角色编辑','role/update','{\"id\":\"1\",\"name\":\"超级管理员\",\"description\":\"拥有所有权限\",\"ids\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"23\",\"24\",\"25\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"33\",\"34\",\"35\",\"36\",\"37\",\"38\",\"39\",\"40\",\"12\",\"13\",\"14\",\"15\",\"16\",\"17\",\"18\",\"19\",\"20\",\"21\",\"22\",\"45\",\"41\",\"42\",\"43\",\"44\"]}',1553599565),

(60,1,'菜单编辑','menu/update','{\"id\":\"4\"}',1553599619),

(61,1,'菜单编辑','menu/update','{\"id\":\"4\",\"name\":\"系统设置\",\"icon\":\"\",\"sort\":\"12\",\"is_show\":\"1\"}',1553599622),

(62,1,'菜单编辑','menu/update','{\"id\":\"4\"}',1553599628),

(63,1,'菜单编辑','menu/update','{\"id\":\"4\",\"name\":\"系统设置\",\"icon\":\"\",\"sort\":\"8\",\"is_show\":\"1\"}',1553599631),

(64,1,'路由添加','menu/route-create','{\"submenu_id\":\"7\"}',1553603344),

(65,1,'路由添加','menu/route-create','{\"submenu_id\":\"7\",\"route_name\":\"系统网站设置修改\",\"route\":\"set\\/change-text\",\"status\":\"1\"}',1553603409),

(66,1,'路由添加','menu/route-create','{\"submenu_id\":\"7\"}',1553603412),

(67,1,'路由添加','menu/route-create','{\"submenu_id\":\"7\",\"route_name\":\"系统图片设置上传\",\"route\":\"set\\/change-img\",\"status\":\"1\"}',1553603448),

(68,1,'角色编辑','role/update','{\"id\":\"1\"}',1553603455),

(69,1,'角色编辑','role/update','{\"id\":\"1\",\"name\":\"超级管理员\",\"description\":\"拥有所有权限\",\"ids\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"23\",\"24\",\"25\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"33\",\"34\",\"35\",\"36\",\"37\",\"38\",\"39\",\"40\",\"12\",\"13\",\"14\",\"15\",\"16\",\"17\",\"45\",\"46\",\"47\",\"18\",\"19\",\"20\",\"21\",\"22\",\"41\",\"42\",\"43\",\"44\"]}',1553603459),

(70,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值\"}',1553603471),

(71,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值\"}',1553603473),

(72,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值\"}',1553603476),

(73,1,'系统网站设置修改','set/change-text','{\"id\":\"1\",\"val\":\"Colin CMS\"}',1553603482),

(74,1,'系统网站设置修改','set/change-text','{\"id\":\"1\",\"val\":\"Colin CMS2\"}',1553603483),

(75,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值2\"}',1553603485),

(76,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值\"}',1553603487),

(77,1,'系统网站设置修改','set/change-text','{\"id\":\"1\",\"val\":\"Colin CMS\"}',1553603489),

(78,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值\"}',1553603491),

(79,1,'系统网站设置修改','set/change-text','{\"id\":\"1\",\"val\":\"Colin CMS2\"}',1553603493),

(80,1,'系统网站设置修改','set/change-text','{\"id\":\"1\",\"val\":\"Colin CMS\"}',1553603511),

(81,1,'系统图片设置上传','set/change-img','[]',1553604397),

(82,1,'系统图片设置上传','set/change-img','[]',1553604785),

(83,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"D:\\\\softwares\\\\phpStudy\\\\PHPTutorial\\\\WWW\\\\cms\\/uploads\\/image\\/20190326\\/5c9a20b19e059.jpg\"}',1553604785),

(84,1,'系统图片设置上传','set/change-img','[]',1553604861),

(85,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"D:\\\\softwares\\\\phpStudy\\\\PHPTutorial\\\\WWW\\\\cms\\/uploads\\/image\\/20190326\\/5c9a20fdea485.jpg\"}',1553604862),

(86,1,'系统图片设置上传','set/change-img','[]',1553604942),

(87,1,'系统图片设置上传','set/change-img','[]',1553605006),

(88,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"D:\\\\softwares\\\\phpStudy\\\\PHPTutorial\\\\WWW\\\\cms\\/uploads\\/image\\/20190326\\/5c9a218e10d00.png\"}',1553605006),

(89,1,'系统图片设置上传','set/change-img','[]',1553605086),

(90,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"http:\\/\\/dev.xadmin.com\\/uploads\\/image\\/20190326\\/5c9a21de8fab5.png\"}',1553605086),

(91,1,'系统图片设置上传','set/change-img','[]',1553605307),

(92,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"http:\\/\\/dev.xadmin.com\\/uploads\\/image\\/20190326\\/5c9a22bbb1466.png\"}',1553605307),

(93,1,'系统图片设置上传','set/change-img','[]',1553605398),

(94,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"http:\\/\\/dev.xadmin.com\\/uploads\\/image\\/20190326\\/5c9a23165c9a7.jpg\"}',1553605398),

(95,1,'系统图片设置上传','set/change-img','[]',1553605454),

(96,1,'系统图片设置上传','set/change-img','[]',1553605520),

(97,1,'系统图片设置上传','set/change-img','[]',1553605572),

(98,1,'系统图片设置上传','set/change-img','[]',1553605655),

(99,1,'系统图片设置上传','set/change-img','[]',1553605730),

(100,1,'系统图片设置上传','set/change-img','[]',1553605758),

(101,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"uploads\\/image\\/20190326\\/5c9a247ee24cd.jpg\"}',1553605759),

(102,1,'系统图片设置上传','set/change-img','[]',1553605868),

(103,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a24ecb9d77.png\"}',1553605868),

(104,1,'系统图片设置上传','set/change-img','[]',1553605946),

(105,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a253a79fc6.jpg\"}',1553605946),

(106,1,'系统图片设置上传','set/change-img','[]',1553606082),

(107,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a25c27ae89.png\"}',1553606082),

(108,1,'系统图片设置上传','set/change-img','[]',1553606090),

(109,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a25ca36a82.gif\"}',1553606090),

(110,1,'系统图片设置上传','set/change-img','[]',1553606091),

(111,1,'系统图片设置上传','set/change-img','{\"id\":\"4\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a25cb35733.gif\"}',1553606091),

(112,1,'系统图片设置上传','set/change-img','[]',1553606146),

(113,1,'系统图片设置上传','set/change-img','{\"id\":\"4\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a2602dfe7d.png\"}',1553606147),

(114,1,'系统图片设置上传','set/change-img','[]',1553606152),

(115,1,'系统图片设置上传','set/change-img','{\"id\":\"4\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a2608871df.png\"}',1553606152),

(116,1,'系统图片设置上传','set/change-img','[]',1553606153),

(117,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26099450b.png\"}',1553606153),

(118,1,'系统图片设置上传','set/change-img','[]',1553606176),

(119,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a2620c2c82.png\"}',1553606176),

(120,1,'系统图片设置上传','set/change-img','[]',1553606180),

(121,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26249eb3e.jpg\"}',1553606180),

(122,1,'系统图片设置上传','set/change-img','[]',1553606181),

(123,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26259ff00.jpg\"}',1553606181),

(124,1,'系统图片设置上传','set/change-img','[]',1553606319),

(125,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26afd2739.png\"}',1553606319),

(126,1,'系统图片设置上传','set/change-img','[]',1553606323),

(127,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26b354090.gif\"}',1553606323),

(128,1,'系统图片设置上传','set/change-img','[]',1553606326),

(129,1,'系统图片设置上传','set/change-img','{\"id\":\"4\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26b6dd894.png\"}',1553606327),

(130,1,'系统图片设置上传','set/change-img','[]',1553606331),

(131,1,'系统图片设置上传','set/change-img','{\"id\":\"4\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26bb0e131.png\"}',1553606331),

(132,1,'系统图片设置上传','set/change-img','[]',1553606340),

(133,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a26c437f36.png\"}',1553606340),

(134,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值1\"}',1553606385),

(135,1,'系统网站设置修改','set/change-text','{\"id\":\"3\",\"val\":\"测试值\"}',1553606387),

(136,1,'系统图片设置上传','set/change-img','[]',1553606472),

(137,1,'系统图片设置上传','set/change-img','{\"id\":\"2\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a27484e4d9.png\"}',1553606472),

(138,1,'系统图片设置上传','set/change-img','[]',1553606475),

(139,1,'系统图片设置上传','set/change-img','{\"id\":\"4\",\"val\":\"\\/uploads\\/image\\/20190326\\/5c9a274b460b2.png\"}',1553606475),

(140,1,'路由添加','menu/route-create','{\"submenu_id\":\"1\"}',1555930906),

(141,1,'路由添加','menu/route-create','{\"submenu_id\":\"1\"}',1555930913),

(142,1,'路由添加','menu/route-create','{\"submenu_id\":\"1\",\"route_name\":\"member\\/export\",\"route\":\"数据导出\",\"status\":\"1\"}',1555930932),

(143,1,'路由编辑','menu/route-update','{\"id\":\"48\"}',1555930939),

(144,1,'路由编辑','menu/route-update','{\"id\":\"48\",\"route_name\":\"数据导出\",\"route\":\"member\\/export\",\"status\":\"1\"}',1555930949),

(145,1,'角色编辑','role/update','{\"id\":\"1\"}',1555930959),

(146,1,'角色编辑','role/update','{\"id\":\"1\",\"name\":\"超级管理员\",\"description\":\"拥有所有权限\",\"ids\":[\"45\",\"46\",\"47\",\"41\",\"42\",\"43\",\"44\",\"38\",\"39\",\"40\",\"23\",\"24\",\"25\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"33\",\"34\",\"35\",\"36\",\"37\",\"18\",\"19\",\"20\",\"21\",\"22\",\"12\",\"13\",\"14\",\"15\",\"16\",\"17\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"48\"],\"submenu_name\":{\"6\":\"on\"}}',1555930964),

(147,1,'数据导出','member/export','[]',1555930971),

(148,1,'数据导出','member/export','[]',1555931009),

(149,1,'数据导出','member/export','[]',1555931072),

(150,1,'数据导出','member/export','[]',1555931104),

(151,1,'数据导出','member/export','[]',1555931185),

(152,1,'数据导出','member/export','[]',1555931218),

(153,1,'数据导出','member/export','{\"search\":{\"nickname\":\"test\",\"tel\":\"\",\"b_time\":\"\",\"e_time\":\"\"}}',1555931276),

(154,1,'数据导出','member/export','{\"search\":{\"nickname\":\"test\",\"tel\":\"\",\"b_time\":\"\",\"e_time\":\"\"}}',1555931338),

(155,1,'数据导出','member/export','[]',1557297926),

(156,1,'路由添加','menu/route-create','{\"submenu_id\":\"5\"}',1557309331),

(157,1,'路由添加','menu/route-create','{\"submenu_id\":\"5\",\"route_name\":\"查看UA\",\"route\":\"login-log\\/view\",\"status\":\"1\"}',1557309365),

(158,1,'管理员编辑','user/update','{\"id\":\"1\"}',1557309377),

(159,1,'角色编辑','role/update','{\"id\":\"1\"}',1557309382),

(160,1,'角色编辑','role/update','{\"id\":\"1\",\"name\":\"超级管理员\",\"description\":\"拥有所有权限\",\"ids\":[\"45\",\"46\",\"47\",\"41\",\"42\",\"43\",\"44\",\"38\",\"39\",\"40\",\"49\",\"23\",\"24\",\"25\",\"26\",\"27\",\"28\",\"29\",\"30\",\"31\",\"32\",\"33\",\"34\",\"35\",\"36\",\"37\",\"18\",\"19\",\"20\",\"21\",\"22\",\"12\",\"13\",\"14\",\"15\",\"16\",\"17\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"48\"]}',1557309388);



/*Table structure for table `colin_role` */



DROP TABLE IF EXISTS `colin_role`;



CREATE TABLE `colin_role` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户角色表',

  `name` varchar(50) DEFAULT NULL COMMENT '角色名',

  `description` varchar(100) DEFAULT NULL COMMENT '角色描述',

  `permission` varchar(500) DEFAULT NULL COMMENT '权限',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;



/*Data for the table `colin_role` */



insert  into `colin_role`(`id`,`name`,`description`,`permission`,`create_time`) values

(1,'超级管理员','拥有所有权限','[45,46,47,41,42,43,44,38,39,40,49,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,18,19,20,21,22,12,13,14,15,16,17,1,2,3,4,5,6,48]',1557309388),

(4,'测试','测试人员权限','[1,23,12,13,14,38,18,19,20]',1553440441),

(7,'客服','客服权限','[1,12,13]',1553336925),

(15,'财务','财务权限','[1,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,41,12,38,18]',1553528140);



/*Table structure for table `colin_route` */



DROP TABLE IF EXISTS `colin_route`;



CREATE TABLE `colin_route` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '路由表',

  `submenu_id` int(11) DEFAULT NULL COMMENT '子菜单id',

  `route_name` varchar(100) DEFAULT NULL COMMENT '路由名',

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

  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1:启用 2:禁用',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;



/*Data for the table `colin_route` */



insert  into `colin_route`(`id`,`submenu_id`,`route_name`,`route`,`status`,`create_time`) values

(1,1,'会员列表','member/index',1,1521768073),

(2,1,'会员删除','member/del',1,1521768073),

(3,1,'会员批量删除','member/batch-del',1,1521768073),

(4,1,'会员添加','member/create',1,1521768073),

(5,1,'会员编辑','member/update',1,1521768073),

(6,1,'会员状态修改','member/change-status',1,1521768073),

(12,2,'管理员列表','user/index',1,1553244064),

(13,2,'管理员删除','user/del',1,1553244091),

(14,2,'管理员批量删除','user/batch-del',1,1553244124),

(15,2,'管理员添加','user/create',1,1553244151),

(16,2,'管理员编辑','user/update',1,1553244172),

(17,2,'管理员状态修改','user/change-status',1,1553244208),

(18,3,'角色列表','role/index',1,1553244281),

(19,3,'角色删除','role/del',1,1553244307),

(20,3,'角色批量删除','role/batch-del',1,1553244335),

(21,3,'角色添加','role/create',1,1553244359),

(22,3,'角色编辑','role/update',1,1553244392),

(23,4,'菜单列表','menu/index',1,1553245834),

(24,4,'菜单删除','menu/del',1,1553245871),

(25,4,'菜单批量删除','menu/batch-del',1,1553246089),

(26,4,' 菜单添加','menu/create',1,1553246123),

(27,4,'菜单编辑','menu/update',1,1553246169),

(28,4,'子菜单列表','menu/submenu',1,1553246215),

(29,4,'子菜单删除','menu/submenu-del',1,1553246313),

(30,4,'子菜单批量删除','menu/submenu-batch-del',1,1553246362),

(31,4,'子菜单添加','menu/submenu-create',1,1553246414),

(32,4,'子菜单更新','menu/submenu-update',1,1553246441),

(33,4,'路由列表','menu/route',1,1553246467),

(34,4,'路由删除','menu/route-del',1,1553246494),

(35,4,'路由批量删除','menu/route-batch-del',1,1553246527),

(36,4,'路由添加','menu/route-create',1,1553246558),

(37,4,'路由编辑','menu/route-update',1,1553246585),

(38,5,'登陆日志列表','login-log/index',1,1553436275),

(39,5,'登陆日志删除','login-log/del',1,1553436909),

(40,5,'登陆日志批量删除','login-log/batch-del',1,1553436940),

(41,6,'操作日志列表','operate-log/index',1,1553521420),

(42,6,'操作日志删除','operate-log/del',1,1553521445),

(43,6,'操作日志批量删除','operate-log/batch-del',1,1553521474),

(44,6,'操作日志查看参数','operate-log/view',1,1553525306),

(45,7,'系统设置查看','set/index',1,1553599121),

(46,7,'系统网站设置修改','set/change-text',1,1553603409),

(47,7,'系统图片设置上传','set/change-img',1,1553603448),

(48,1,'数据导出','member/export',1,1555930932),

(49,5,'查看UA','login-log/view',1,1557309365);



/*Table structure for table `colin_set` */



DROP TABLE IF EXISTS `colin_set`;



CREATE TABLE `colin_set` (

  `id` int(31) unsigned NOT NULL AUTO_INCREMENT COMMENT '系统设置表',

  `key` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '键',

  `desc` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '描述',

  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '值',

  `type` tinyint(1) DEFAULT '1' COMMENT '类型 1:文本 2:图片',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



/*Data for the table `colin_set` */



insert  into `colin_set`(`id`,`key`,`desc`,`value`,`type`) values

(1,'title','网站标题','Colin CMS',1),

(2,'logo','logo','/uploads/image/20190326/5c9a27484e4d9.png',2),

(3,'test','测试','测试值',1),

(4,'test_img','测试图片','/uploads/image/20190326/5c9a274b460b2.png',2);



/*Table structure for table `colin_submenu` */



DROP TABLE IF EXISTS `colin_submenu`;



CREATE TABLE `colin_submenu` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '子菜单表',

  `menu_id` int(11) DEFAULT NULL COMMENT '主菜单id',

  `route_name` varchar(100) DEFAULT NULL COMMENT '路由名',

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

  `sort` int(11) DEFAULT '10' COMMENT '排序',

  `is_show` tinyint(1) DEFAULT '1' COMMENT '是否显示 1:显示 2:隐藏',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;



/*Data for the table `colin_submenu` */



insert  into `colin_submenu`(`id`,`menu_id`,`route_name`,`route`,`sort`,`is_show`,`create_time`) values

(1,1,'会员管理','member/index',10,1,1521768073),

(2,2,'管理员管理','user/index',10,1,1521768073),

(3,2,'角色管理','role/index',10,1,1521768073),

(4,2,'菜单路由管理','menu/index',10,1,1521768073),

(5,3,'登陆日志','login-log/index',10,1,1553436248),

(6,3,'操作日志','operate-log/index',10,1,1553521325),

(7,4,'系统设置','set/index',10,1,1553599092);



/*Table structure for table `colin_user` */



DROP TABLE IF EXISTS `colin_user`;



CREATE TABLE `colin_user` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台用户表',

  `role_id` int(11) DEFAULT NULL COMMENT '角色id',

  `name` varchar(100) DEFAULT NULL COMMENT '用户名',

  `password` varchar(100) DEFAULT NULL COMMENT '密码',

  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1:启用 2:禁用',

  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;



/*Data for the table `colin_user` */



insert  into `colin_user`(`id`,`role_id`,`name`,`password`,`status`,`create_time`) values

(1,1,'admin','$2y$13$VVceeM3SXJJOIj8p9Pk4Be64mF56ajnArZEpM7557.zfAAgnc5KB.',1,1521768073),

(6,4,'test','$2y$13$Ln878YXekD23XBX8Xexyse3ys8dFBJRJf3CV5hoB3Uz.CDXgmYIn2',2,1521768073),

(7,7,'kefu','$2y$13$ZQWkdDxAeC7V0GxFisl3MOAXPcD3p9IIMeK3uwrG3vzRIeCK2dSui',1,1553323404);



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
PHP
1
https://gitee.com/Hei-Mi/cms.git
git@gitee.com:Hei-Mi/cms.git
Hei-Mi
cms
Colin CMS
master
点此查找更多帮助

搜索帮助

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