-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        5.5.51 - MySQL Community Server (GPL)
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  9.4.0.5125
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE IF NOT EXISTS `cloud_favorite` /*!40100 DEFAULT CHARACTER SET latin1 */;
grant all privileges on cloud_favorite.* to cloud_favorite@'%' identified by 'cloud_favorite';
flush privileges;

USE `cloud_favorite`;


-- 导出 cloud_favorite 的数据库结构

-- 导出  表 cloud_favorite.t_category 结构
CREATE TABLE IF NOT EXISTS `t_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL COMMENT '链接名称',
  `cover` varchar(255) DEFAULT NULL COMMENT '链接分类',
  `description` varchar(4000) DEFAULT NULL COMMENT '链接描述',
  `parent_id` int(11) DEFAULT NULL COMMENT '父类别ID',
  `parent_name` varchar(64) DEFAULT NULL COMMENT '收藏者',
  `ancestors` varchar(4000) DEFAULT NULL COMMENT '链接路径',
  `ancestor_names` varchar(255) DEFAULT NULL COMMENT '父类别名称路径',
  `level` tinyint(1) DEFAULT NULL COMMENT '层级，0为私有，1为公有',
  `site_id` int(11) DEFAULT NULL COMMENT '站点Id',
  `priority` tinyint(5) DEFAULT '0',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章类别';

-- 正在导出表  cloud_favorite.t_category 的数据：~21 rows (大约)
/*!40000 ALTER TABLE `t_category` DISABLE KEYS */;
INSERT INTO `t_category` (`id`, `name`, `cover`, `description`, `parent_id`, `parent_name`, `ancestors`, `ancestor_names`, `level`, `site_id`, `priority`, `deleted`, `created`, `updated`) VALUES
	(46, '测试', '1', '', NULL, 'admin1', 'http://www.baidu.com', NULL, 1, NULL, 0, 0, '2018-03-30 17:08:01', '2018-03-30 17:08:01'),
	(60, 'baidu', '1', '2', NULL, 'admin', 'http://www.baidu.com', NULL, 0, NULL, 0, 0, '2018-03-31 17:46:30', '2018-03-31 17:46:30'),
	(61, 'bootstrap', '7', '2', NULL, 'admin', 'https://v3.bootcss.com/css/#images', NULL, 0, NULL, 0, 0, '2018-03-31 17:46:30', '2018-03-31 17:46:30');
/*!40000 ALTER TABLE `t_category` ENABLE KEYS */;

-- 导出  表 cloud_favorite.t_category_cover 结构
CREATE TABLE IF NOT EXISTS `t_category_cover` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `cover_name` varchar(32) NOT NULL COMMENT '分类名称',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '链接描述',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `Index 2` (`cover_name`, `user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- 正在导出表  cloud_favorite.t_category_cover 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `t_category_cover` DISABLE KEYS */;
INSERT INTO `t_category_cover` (`id`, `user_id`, `cover_name`, `created`, `updated`, `remark`) VALUES
	(1, 17, '军事', NULL, '2018-03-30 17:07:02', NULL),
	(7, 17, '历史', NULL, '2018-03-30 17:07:14', NULL);
/*!40000 ALTER TABLE `t_category_cover` ENABLE KEYS */;

-- 导出  表 cloud_favorite.t_user 结构
CREATE TABLE IF NOT EXISTS `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '用户名',
  `pass` varchar(32) DEFAULT NULL COMMENT '密码',
  `nick` varchar(32) DEFAULT NULL COMMENT '昵称姓名',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(13) DEFAULT NULL COMMENT '手机号',
  `role_id` int(11) NOT NULL DEFAULT '-1' COMMENT '角色ID',
  `department_id` int(11) DEFAULT NULL COMMENT '所属部门',
  `gender` int(11) DEFAULT '0' COMMENT '性别0-女,1-男',
  `status` tinyint(1) DEFAULT NULL COMMENT '用户状态',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `visited` datetime DEFAULT NULL COMMENT '最近访问时间',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_name` (`name`) USING BTREE,
  UNIQUE KEY `uk_email` (`email`) USING BTREE,
  UNIQUE KEY `uk_phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户';

-- 正在导出表  cloud_favorite.t_user 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
INSERT INTO `t_user` (`id`, `name`, `pass`, `nick`, `avatar`, `email`, `phone`, `role_id`, `department_id`, `gender`, `status`, `birthday`, `visited`, `created`, `updated`) VALUES
	(17, 'admin', 'F6FDFFE48C908DEB0F4C3BD36C032E72', '管理员', 'http://static.xuehu365.com/admin/img/2Q5U2FsG.png', 'hunan.me@gmail.com', '13412317173', -1, 18, 1, 1, '2015-08-31 00:00:00', '2017-06-07 00:33:34', '2014-07-15 09:57:39', '2017-06-07 23:23:12'),
	(18, 'test', 'F6FDFFE48C908DEB0F4C3BD36C032E72', '测试用户', 'http://static.xuehu365.com/admin/img/2Q9G0QAs.jpg', 'test@test.test', '1234567890', 0, 19, 0, 1, NULL, NULL, '2016-06-06 14:18:59', '2017-06-02 00:17:36');
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;