/* Navicat Premium Data Transfer Source Server : 本机 Source Server Type : MySQL Source Server Version : 50717 Source Host : localhost Source Database : ci Target Server Type : MySQL Target Server Version : 50717 File Encoding : utf-8 Date: 05/19/2017 21:12:46 PM */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `s_ads` -- ---------------------------- DROP TABLE IF EXISTS `s_ads`; CREATE TABLE `s_ads` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `type` char(60) NOT NULL DEFAULT '', `name` char(60) NOT NULL DEFAULT '', `url` char(100) NOT NULL DEFAULT '', `pic` char(100) NOT NULL DEFAULT '', `sort` tinyint(4) unsigned NOT NULL DEFAULT '1', `isshow` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Table structure for `s_articles` -- ---------------------------- DROP TABLE IF EXISTS `s_articles`; CREATE TABLE `s_articles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `catalog_id` int(10) unsigned NOT NULL COMMENT '栏目ID', `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '标题', `shorttitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '小标题', `pic` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '图片', `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '作者', `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '来源', `published_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间', `click_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数', `is_top` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '置顶', `is_recommend` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '推荐', `is_bold` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '加粗', `is_slide` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '幻灯片', `is_link` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '链接', `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '链接地扯', `color` char(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '颜色', `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '描述文字', `audit` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '审核', `body` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '内容', `gallery` text COLLATE utf8_unicode_ci, `gallery_info` text COLLATE utf8_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Table structure for `s_catalogs` -- ---------------------------- DROP TABLE IF EXISTS `s_catalogs`; CREATE TABLE `s_catalogs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catalog_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属栏目', `is_nav` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '是否导航显示k', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `typename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '栏目名称', `typename_en` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `typeurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '栏目链接', `typepic` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '栏目图片', `channltype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '频道类型', `pagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '页面类型', `tempindex` char(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '单页模板', `templist` char(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '列表页模板', `temparticle` char(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '内容页模板', `seotitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'SEO标题', `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'SEO关键词', `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'SEO描述', `content` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '文章内容', `pagesnum` tinyint(3) unsigned NOT NULL DEFAULT '15' COMMENT '文章分页数', `gallery` text COLLATE utf8_unicode_ci, `gallery_info` text COLLATE utf8_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Table structure for `s_flinks` -- ---------------------------- DROP TABLE IF EXISTS `s_flinks`; CREATE TABLE `s_flinks` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `typeid` smallint(5) unsigned NOT NULL DEFAULT '0', `name` char(60) NOT NULL DEFAULT '', `url` char(100) NOT NULL DEFAULT '', `pic` char(100) NOT NULL DEFAULT '', `sort` tinyint(4) unsigned NOT NULL DEFAULT '1', `isshow` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Table structure for `s_gbooks` -- ---------------------------- DROP TABLE IF EXISTS `s_gbooks`; CREATE TABLE `s_gbooks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '', `nickname` varchar(255) NOT NULL DEFAULT '', `phone` char(15) NOT NULL DEFAULT '', `email` char(60) NOT NULL DEFAULT '', `qq` char(15) NOT NULL DEFAULT '', `company` varchar(255) NOT NULL DEFAULT '', `msg` text, `reply` text, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Table structure for `s_members` -- ---------------------------- DROP TABLE IF EXISTS `s_members`; CREATE TABLE `s_members` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mobile` char(30) NOT NULL DEFAULT '', `password` char(32) NOT NULL DEFAULT '', `nickname` char(30) NOT NULL DEFAULT '', `avatar` varchar(255) NOT NULL DEFAULT '', `birthday` date DEFAULT NULL, `sex` enum('2','1','0') NOT NULL DEFAULT '2' COMMENT '0女,1男,2保密', `status` enum('1','0') NOT NULL DEFAULT '1' COMMENT '0禁用,正常', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Table structure for `s_menu_role` -- ---------------------------- DROP TABLE IF EXISTS `s_menu_role`; CREATE TABLE `s_menu_role` ( `menu_id` int(10) unsigned NOT NULL, `role_id` int(10) unsigned NOT NULL, PRIMARY KEY (`menu_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of `s_menu_role` -- ---------------------------- BEGIN; INSERT INTO `s_menu_role` VALUES ('1', '1'), ('1', '2'), ('2', '2'), ('3', '2'), ('4', '2'), ('5', '2'), ('6', '2'), ('7', '2'), ('8', '2'), ('9', '2'), ('10', '2'), ('11', '2'), ('12', '2'), ('13', '2'), ('14', '2'), ('15', '2'), ('16', '2'), ('17', '2'), ('18', '2'), ('19', '2'), ('20', '1'), ('20', '2'), ('21', '1'), ('21', '2'), ('22', '1'), ('22', '2'), ('23', '1'), ('23', '2'), ('24', '1'), ('24', '2'), ('25', '1'), ('25', '2'), ('26', '1'), ('26', '2'), ('27', '1'), ('27', '2'), ('28', '2'), ('29', '2'), ('30', '2'), ('31', '2'), ('32', '2'), ('33', '2'), ('34', '2'), ('35', '2'), ('36', '2'), ('37', '2'), ('38', '2'), ('39', '2'), ('40', '2'), ('41', '2'), ('42', '2'), ('43', '2'), ('44', '2'); COMMIT; -- ---------------------------- -- Table structure for `s_menus` -- ---------------------------- DROP TABLE IF EXISTS `s_menus`; CREATE TABLE `s_menus` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `menu_id` int(11) NOT NULL, `name` char(30) NOT NULL DEFAULT '', `route` char(30) NOT NULL DEFAULT '', `sort` tinyint(4) unsigned NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; -- ---------------------------- -- Records of `s_menus` -- ---------------------------- BEGIN; INSERT INTO `s_menus` VALUES ('1', '0', '内容管理', 'icon-list-alt', '0', '2017-05-19 10:47:43', '2017-05-19 10:47:43', null), ('2', '0', '电商管理', 'icon-briefcase', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('3', '0', '会员管理', 'icon-certificate', '1', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('4', '0', '模块管理', 'icon-th', '1', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('5', '0', '账户管理', 'icon-user', '5', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('6', '0', '系统设置', 'icon-cog', '10', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('7', '6', '系统配置', 'sysconfig.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('8', '6', '菜单管理', 'menu.index', '1', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('9', '8', '创建菜单', 'menu.create', '1', '2017-05-18 15:44:09', '2017-05-18 15:41:57', null), ('10', '8', '编辑菜单', 'menu.edit', '1', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('11', '8', '删除菜单', 'menu.destroy', '1', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('12', '5', '角色管理', 'role.index', '1', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('13', '12', '增加角色', 'role.create', '4', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('14', '12', '编辑角色', 'role.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('15', '12', '删除角色', 'role.destroy', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('16', '5', '用户管理', 'user.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('17', '16', '增加用户', 'user.create', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('18', '16', '编辑用户', 'user.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('19', '16', '删除用户', 'user.destroy', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('20', '1', '栏目管理', 'catalog.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('21', '20', '增加栏目', 'catalog.create', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('22', '20', '编辑栏目', 'catalog.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('23', '20', '删除栏目', 'catalog.destroy', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('24', '1', '信息管理', 'article.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('25', '24', '增加信息', 'article.create', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('26', '24', '编辑信息', 'article.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('27', '24', '删除信息', 'article.destroy', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('28', '4', '友情链接', 'flink.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('29', '28', '增加链接', 'flink.create', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('30', '28', '编辑链接', 'flink.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('31', '28', '删除链接', 'flink.destroy', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('32', '12', '菜单权限', 'role.menu', '0', '2017-05-19 16:34:10', '2017-05-19 16:34:10', null), ('33', '3', '会员列表', 'member.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('34', '4', '留言管理', 'gbook.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('35', '34', '编辑留言', 'gbook.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('36', '34', '删除留言', 'gbook.destroy', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('37', '4', '广告管理', 'ad.index', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('38', '37', '增加广告', 'ad.create', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null), ('39', '37', '编辑广告', 'ad.edit', '0', '2017-05-18 15:25:14', '2017-05-18 15:25:14', null); COMMIT; -- ---------------------------- -- Table structure for `s_role_user` -- ---------------------------- DROP TABLE IF EXISTS `s_role_user`; CREATE TABLE `s_role_user` ( `user_id` int(10) unsigned NOT NULL, `role_id` int(10) unsigned NOT NULL, PRIMARY KEY (`user_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of `s_role_user` -- ---------------------------- BEGIN; INSERT INTO `s_role_user` VALUES ('1', '1'), ('9', '1'), ('9', '2'), ('10', '1'), ('10', '2'), ('11', '1'), ('11', '2'); COMMIT; -- ---------------------------- -- Table structure for `s_roles` -- ---------------------------- DROP TABLE IF EXISTS `s_roles`; CREATE TABLE `s_roles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of `s_roles` -- ---------------------------- BEGIN; INSERT INTO `s_roles` VALUES ('1', '系统管理员组', '', '2017-05-18 16:22:29', null, null), ('2', 'sdfasfasdf', 'sdf', '2017-05-18 16:31:15', '2017-05-19 09:30:42', null); COMMIT; -- ---------------------------- -- Table structure for `s_sysconfigs` -- ---------------------------- DROP TABLE IF EXISTS `s_sysconfigs`; CREATE TABLE `s_sysconfigs` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `name` char(30) NOT NULL DEFAULT '' COMMENT '配置名称', `field_name` char(30) NOT NULL DEFAULT '' COMMENT '配置字段名称', `type` char(10) NOT NULL DEFAULT '' COMMENT '类型', `value` varchar(255) NOT NULL DEFAULT '' COMMENT '名称值', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of `s_sysconfigs` -- ---------------------------- BEGIN; INSERT INTO `s_sysconfigs` VALUES ('1', '网站名称', 'site_name', 'text', ''), ('2', '网站关键字', 'site_keywords', 'textarea', ''), ('3', '网站描述文字', 'site_description', 'textarea', ''), ('4', '网站版权信息', 'site_copyright', 'text', ''), ('5', '网站ICP备案号', 'site_approve', 'text', ''); COMMIT; -- ---------------------------- -- Table structure for `s_users` -- ---------------------------- DROP TABLE IF EXISTS `s_users`; CREATE TABLE `s_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户名', `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户密码', `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `nickname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称', `logined_at` timestamp NULL DEFAULT NULL COMMENT '登录时间', `logined_ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '登录IP', `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_username_unique` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of `s_users` -- ---------------------------- BEGIN; INSERT INTO `s_users` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 'jklklljklsdf', '2017-05-19 20:05:48', '127.0.0.1', null, null, '2017-05-19 20:28:46', null), ('2', 'wwww', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:12:44', '2017-05-19 17:12:44', null), ('3', 'asfasdfsdfsdf', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:13:43', '2017-05-19 17:13:43', null), ('4', 'asfasdfsdfsdfsdasdfasdf', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:14:11', '2017-05-19 20:21:06', '2017-05-19 20:21:06'), ('5', 'a', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:14:46', '2017-05-19 20:21:09', '2017-05-19 20:21:09'), ('6', 'ab', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:16:02', '2017-05-19 17:16:02', null), ('7', 'aa', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:16:19', '2017-05-19 17:16:19', null), ('8', 'c', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:16:48', '2017-05-19 17:16:48', null), ('9', 'ccc', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:17:13', '2017-05-19 20:21:15', '2017-05-19 20:21:15'), ('10', 'cccc', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:17:24', '2017-05-19 17:17:24', null), ('11', 'cccd', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 17:17:47', '2017-05-19 17:17:47', null), ('12', '111111111', 'e10adc3949ba59abbe56e057f20f883e', '', '', null, '', null, '2017-05-19 20:42:32', '2017-05-19 20:42:32', null); COMMIT; SET FOREIGN_KEY_CHECKS = 1;