bicycle
/
bicycle.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : bicycle

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2018-05-03 15:43:16
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for by_article
-- ----------------------------
DROP TABLE IF EXISTS `by_article`;
CREATE TABLE `by_article` (
  `ar_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章id',
  `ar_title` varchar(100) DEFAULT NULL COMMENT '文章标题',
  `ar_keywords` varchar(100) DEFAULT NULL COMMENT '关键字',
  `ar_desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `ar_author` varchar(50) DEFAULT NULL COMMENT '作者',
  `ar_thumb` varchar(100) DEFAULT NULL COMMENT '缩略图，存放图片的地址',
  `ar_content` text COMMENT '内容',
  `ar_click` int(9) DEFAULT '0' COMMENT '点击次数',
  `ar_cateid` tinyint(4) DEFAULT NULL COMMENT '文章所属分类',
  `ar_isrec` tinyint(5) DEFAULT '0' COMMENT '是否轮播：0不是，1是',
  `create_time` datetime DEFAULT NULL COMMENT '文章创建时间',
  `create_user_id` mediumint(9) DEFAULT NULL COMMENT '文章创建人的id',
  `update_time` datetime DEFAULT NULL COMMENT '更改时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更改人',
  PRIMARY KEY (`ar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_article
-- ----------------------------

-- ----------------------------
-- Table structure for by_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `by_auth_group`;
CREATE TABLE `by_auth_group` (
  `g_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `g_title` char(100) NOT NULL DEFAULT '',
  `g_status` tinyint(1) NOT NULL DEFAULT '0',
  `g_rules` char(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`g_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_auth_group
-- ----------------------------
INSERT INTO `by_auth_group` VALUES ('6', '链接专员', '1', '21,22,23,24');

-- ----------------------------
-- Table structure for by_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `by_auth_group_access`;
CREATE TABLE `by_auth_group_access` (
  `uid` mediumint(8) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_auth_group_access
-- ----------------------------
INSERT INTO `by_auth_group_access` VALUES ('70', '6');

-- ----------------------------
-- Table structure for by_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `by_auth_rule`;
CREATE TABLE `by_auth_rule` (
  `r_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `r_name` char(80) NOT NULL DEFAULT '',
  `r_title` char(20) NOT NULL DEFAULT '',
  `r_type` tinyint(1) NOT NULL DEFAULT '1',
  `r_status` tinyint(1) NOT NULL DEFAULT '1',
  `r_condition` char(100) NOT NULL DEFAULT '',
  `r_pid` mediumint(9) DEFAULT NULL COMMENT '父权限',
  `r_level` mediumint(9) DEFAULT NULL COMMENT '权限等级',
  `r_sort` mediumint(9) DEFAULT '10' COMMENT '排序',
  PRIMARY KEY (`r_id`),
  UNIQUE KEY `r_name` (`r_name`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_auth_rule
-- ----------------------------
INSERT INTO `by_auth_rule` VALUES ('1', 'admin', '管理员管理', '1', '1', '', '0', '1', '10');
INSERT INTO `by_auth_rule` VALUES ('2', 'admin/add', '管理员添加', '1', '1', '', '1', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('3', 'admin/edit', '管理员修改', '1', '1', '', '1', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('4', 'admin/del', '管理员删除', '1', '1', '', '1', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('5', 'authgroup', '用户组管理', '1', '1', '', '0', '1', '10');
INSERT INTO `by_auth_rule` VALUES ('6', 'authgroup/add', '用户组添加', '1', '1', '', '5', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('7', 'authgroup/edit', '用户组修改', '1', '1', '', '5', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('8', 'authgroup/del', '用户组删除', '1', '1', '', '5', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('9', 'authrule', '权限管理', '1', '1', '', '0', '1', '10');
INSERT INTO `by_auth_rule` VALUES ('10', 'authrule/add', '权限添加', '1', '1', '', '9', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('11', 'authrule/edit', '权限修改', '1', '1', '', '9', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('12', 'authrule/del', '权限删除', '1', '1', '', '9', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('13', 'cate', '栏目管理', '1', '1', '', '0', '1', '10');
INSERT INTO `by_auth_rule` VALUES ('14', 'cate/add', '栏目添加', '1', '1', '', '13', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('15', 'cate/edit', '栏目修改', '1', '1', '', '13', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('16', 'cate/del', '栏目删除', '1', '1', '', '13', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('17', 'article', '文章管理', '1', '1', '', '0', '1', '10');
INSERT INTO `by_auth_rule` VALUES ('18', 'article/add', '文章添加', '1', '1', '', '17', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('19', 'article/edit', '文章修改', '1', '1', '', '17', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('20', 'article/del', '文章删除', '1', '1', '', '17', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('21', 'link', '链接管理', '1', '1', '', '0', '1', '10');
INSERT INTO `by_auth_rule` VALUES ('22', 'link/add', '链接增加', '1', '1', '', '21', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('23', 'link/edit', '链接修改', '1', '1', '', '21', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('24', 'link/del', '链接删除', '1', '1', '', '21', '2', '10');
INSERT INTO `by_auth_rule` VALUES ('25', 'conf/conf', '系统', '1', '1', '', '0', '1', '10');

-- ----------------------------
-- Table structure for by_cate
-- ----------------------------
DROP TABLE IF EXISTS `by_cate`;
CREATE TABLE `by_cate` (
  `cate_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '栏目id',
  `cate_name` varchar(50) DEFAULT NULL COMMENT '栏目名称',
  `cate_type` tinyint(1) DEFAULT NULL COMMENT '栏目类型：列表和单页、图片列表',
  `cate_pid` mediumint(9) DEFAULT NULL COMMENT '上级栏目id',
  `cate_level` tinyint(4) DEFAULT NULL COMMENT '栏目等级',
  `cate_sort` mediumint(9) DEFAULT '10' COMMENT '栏目排序号',
  `create_time` datetime DEFAULT NULL COMMENT '栏目创建时间',
  `create_user_id` mediumint(9) DEFAULT NULL COMMENT '栏目创建人',
  `update_time` datetime DEFAULT NULL COMMENT '栏目更改时间',
  `update_user_id` mediumint(9) DEFAULT NULL COMMENT '栏目更改人id',
  `cate_keywords` varchar(200) DEFAULT NULL COMMENT '关键词',
  `cate_desc` varchar(255) DEFAULT NULL COMMENT '栏目描述',
  `cate_content` text COMMENT '栏目内容',
  `cate_recpos` tinyint(4) DEFAULT '0' COMMENT '0默认（不推荐）1首页2底部',
  PRIMARY KEY (`cate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_cate
-- ----------------------------

-- ----------------------------
-- Table structure for by_conf
-- ----------------------------
DROP TABLE IF EXISTS `by_conf`;
CREATE TABLE `by_conf` (
  `cf_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置项id',
  `cf_name` varchar(100) DEFAULT NULL COMMENT '站点中文名称',
  `cf_value` varchar(100) DEFAULT NULL COMMENT '配置值',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建人id',
  `update_user_id` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`cf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_conf
-- ----------------------------

-- ----------------------------
-- Table structure for by_link
-- ----------------------------
DROP TABLE IF EXISTS `by_link`;
CREATE TABLE `by_link` (
  `lk_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '链接id',
  `lk_name` varchar(50) DEFAULT NULL COMMENT '链接名称',
  `lk_adress` varchar(100) DEFAULT NULL COMMENT '链接地址',
  `lk_desc` varchar(255) DEFAULT NULL COMMENT '链接描述',
  `create_time` datetime DEFAULT NULL COMMENT '链接创建时间',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '修改人',
  `lk_sort` mediumint(9) DEFAULT '10' COMMENT '链接排序',
  PRIMARY KEY (`lk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_link
-- ----------------------------
INSERT INTO `by_link` VALUES ('10', '淘宝', 'https://jxed.com', '', '2018-05-02 16:38:55', '66', null, null, '10');

-- ----------------------------
-- Table structure for by_user
-- ----------------------------
DROP TABLE IF EXISTS `by_user`;
CREATE TABLE `by_user` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_name` varchar(50) NOT NULL COMMENT '用户名',
  `login_name` varchar(50) NOT NULL COMMENT '登录名',
  `login_password` varchar(100) NOT NULL COMMENT '登录密码',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机',
  `last_login_time` varchar(50) DEFAULT NULL COMMENT '最后一次登录时间',
  `login_ip` varchar(100) DEFAULT NULL COMMENT '登录ip',
  `can_login` smallint(6) DEFAULT NULL COMMENT '是否能登录',
  `is_admin` tinyint(4) DEFAULT '0' COMMENT '是否超级管理员（系统默认用户）',
  `login_count` bigint(255) DEFAULT NULL COMMENT '登录次数',
  `user_head` varchar(100) DEFAULT NULL COMMENT '用户头像',
  `getpasstime` varchar(100) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user_id` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL COMMENT '更改时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of by_user
-- ----------------------------
INSERT INTO `by_user` VALUES ('66', '管理员', 'admin', '202cb962ac59075b964b07152d234b70', 'wjp9240@163.com', '13707028057', '2018-05-03 15:28:50', '0.0.0.0', '1', '1', '25', '/header/5ae97a968f3a7.jpg', '1524899828', '2018-04-02 10:30:11', '64', '2018-04-27 11:06:27', '64');
INSERT INTO `by_user` VALUES ('70', '测试账号', 'link', '202cb962ac59075b964b07152d234b70', '1477366708@qq.com', '', '2018-05-03 14:13:19', '0.0.0.0', '1', '0', '6', '/header/5aea856ee873f.JPG', '1525319558', '2018-05-02 16:50:19', '66', '2018-05-03 14:12:57', '66');
SET FOREIGN_KEY_CHECKS=1;