Слияние кода завершено, страница обновится автоматически
/*
Navicat MySQL Data Transfer
Source Server : 本地服务器
Source Server Version : 50547
Source Host : localhost:3306
Source Database : tplay2
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2018-05-20 19:51:04
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tplay_admin`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_admin`;
CREATE TABLE `tplay_admin` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`salt` varchar(50) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1正常0禁止登录-1删除',
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`last_login_time` int(11) NOT NULL,
`login_num` int(11) NOT NULL DEFAULT '0',
`last_login_ip` varchar(100) NOT NULL,
`phone` bigint(11) DEFAULT NULL,
`nickname` varchar(255) DEFAULT NULL,
`sex` int(1) NOT NULL DEFAULT '1' COMMENT '1男0女',
`desc` text COMMENT '备注',
`delete_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`id`,`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='管理员';
-- ----------------------------
-- Records of tplay_admin
-- ----------------------------
INSERT INTO `tplay_admin` VALUES ('13', 'admin', '16e0d72b25badd00a86807699fdce1ec', 'JsvNF5', '1', '0', '1526795973', '1526795973', '69', '127.0.0.1', '12345678900', 'admin', '1', '管理员', null);
INSERT INTO `tplay_admin` VALUES ('21', 'demo', '5d186bde6db4b0c123a3775792573de4', '80zeYi', '1', '1522486512', '1525402712', '1525402712', '6', '127.0.0.1', '12345678900', 'demo', '0', '演示账户。', null);
-- ----------------------------
-- Table structure for `tplay_admin_group`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_admin_group`;
CREATE TABLE `tplay_admin_group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`rules` varchar(1000) DEFAULT NULL COMMENT '用户组拥有的规则id， 多个规则","隔开',
`desc` text COMMENT '备注',
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='权限分组';
-- ----------------------------
-- Records of tplay_admin_group
-- ----------------------------
INSERT INTO `tplay_admin_group` VALUES ('6', '超级管理员', '1', '2,4,7,8,9,11,12,13,14,15,16,17,18,19,20,21,22,23,24,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61', '最高权限。', '0', '1526633375');
INSERT INTO `tplay_admin_group` VALUES ('9', '演示组', '1', '4,14,15,18', '演示组，没有任何操作权限。', '1522484638', '1524899557');
-- ----------------------------
-- Table structure for `tplay_admin_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_admin_group_access`;
CREATE TABLE `tplay_admin_group_access` (
`uid` mediumint(11) unsigned DEFAULT NULL,
`group_id` mediumint(11) DEFAULT NULL,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
UNIQUE KEY `uid_group_id` (`uid`,`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限分组和管理员的关联表';
-- ----------------------------
-- Records of tplay_admin_group_access
-- ----------------------------
INSERT INTO `tplay_admin_group_access` VALUES ('2', '1', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('2', '2', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('11', '1', '1521793085', '1521793085');
INSERT INTO `tplay_admin_group_access` VALUES ('11', '2', '1521793085', '1521793085');
INSERT INTO `tplay_admin_group_access` VALUES ('1', '1', '1521793422', '1521793422');
INSERT INTO `tplay_admin_group_access` VALUES ('1', '2', '1521793422', '1521793422');
INSERT INTO `tplay_admin_group_access` VALUES ('12', '5', '1521861854', '1521861854');
INSERT INTO `tplay_admin_group_access` VALUES ('14', '6', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('15', '6', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('16', '6', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('17', '6', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('18', '6', '0', '0');
INSERT INTO `tplay_admin_group_access` VALUES ('19', '6', '1522458785', '1522458785');
INSERT INTO `tplay_admin_group_access` VALUES ('21', '9', '1522486512', '1522486512');
INSERT INTO `tplay_admin_group_access` VALUES ('13', '6', '1522489681', '1522489681');
INSERT INTO `tplay_admin_group_access` VALUES ('22', '9', '1524640228', '1524640228');
-- ----------------------------
-- Table structure for `tplay_admin_rule`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_admin_rule`;
CREATE TABLE `tplay_admin_rule` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`type` int(1) NOT NULL DEFAULT '1',
`condition` char(100) NOT NULL,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COMMENT='权限节点';
-- ----------------------------
-- Records of tplay_admin_rule
-- ----------------------------
INSERT INTO `tplay_admin_rule` VALUES ('2', 'admin/editPwd', '修改密码', '1', '', '0', '1524897843');
INSERT INTO `tplay_admin_rule` VALUES ('4', 'admin/index', '管理员列表', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('7', 'admin/add', '新增管理员', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('8', 'admin/edit', '修改管理员', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('9', 'admin/del', '删除管理员', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('11', 'admin/addGroup', '新增权限组', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('12', 'admin/editGroup', '修改权限组', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('13', 'admin/delGroup', '删除权限组', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('14', 'admin/groupList', '权限组列表', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('15', 'recycling/index', '回收站', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('16', 'recycling/del', '彻底删除', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('17', 'recycling/restore', '还原数据', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('18', 'system/index', '系统配置', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('19', 'system/edit', '修改系统配置', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('20', 'system/add', '新增系统配置', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('21', 'system/del', '删除系统配置', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('22', 'rule/index', '权限节点', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('23', 'rule/edit', '修改权限节点', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('24', 'rule/add', '新增权限节点', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('26', 'rule/del', '删除权限节点', '1', '', '1524898419', '1524898419');
INSERT INTO `tplay_admin_rule` VALUES ('27', 'portal/menu', '门户菜单列表', '1', '', '0', '0');
INSERT INTO `tplay_admin_rule` VALUES ('28', 'portal/editMenu', '修改门户菜单', '1', '', '1525916348', '1525916348');
INSERT INTO `tplay_admin_rule` VALUES ('29', 'portal/addMenu', '新增门户菜单', '1', '', '1525920857', '1525920857');
INSERT INTO `tplay_admin_rule` VALUES ('30', 'portal/delMenu', '删除门户菜单', '1', '', '1525922905', '1525922905');
INSERT INTO `tplay_admin_rule` VALUES ('31', 'portal/menuCate', '门户菜单组', '1', '', '1525937670', '1525937670');
INSERT INTO `tplay_admin_rule` VALUES ('32', 'portal/addMenuCate', '新增门户菜单组', '1', '', '1525938544', '1525938544');
INSERT INTO `tplay_admin_rule` VALUES ('33', 'portal/editMenuCate', '修改门户菜单组', '1', '', '1525938566', '1525938566');
INSERT INTO `tplay_admin_rule` VALUES ('34', 'portal/delMenuCate', '删除门户菜单组', '1', '', '1525938576', '1525938576');
INSERT INTO `tplay_admin_rule` VALUES ('35', 'portal/carousel', '轮播组图', '1', '', '1526006014', '1526006014');
INSERT INTO `tplay_admin_rule` VALUES ('36', 'portal/addCarousel', '新增轮播', '1', '', '1526006031', '1526006031');
INSERT INTO `tplay_admin_rule` VALUES ('37', 'portal/editCarousel', '修改轮播', '1', '', '1526006042', '1526006042');
INSERT INTO `tplay_admin_rule` VALUES ('38', 'portal/delCarousel', '删除轮播', '1', '', '1526006053', '1526006053');
INSERT INTO `tplay_admin_rule` VALUES ('39', 'portal/carouselCate', '轮播组', '1', '', '1526006073', '1526006073');
INSERT INTO `tplay_admin_rule` VALUES ('40', 'portal/addCarouselCate', '新增轮播组', '1', '', '1526006087', '1526006087');
INSERT INTO `tplay_admin_rule` VALUES ('41', 'portal/editCarouselCate', '修改轮播组', '1', '', '1526006100', '1526006100');
INSERT INTO `tplay_admin_rule` VALUES ('42', 'portal/delCarouselCate', '删除轮播组', '1', '', '1526006109', '1526006109');
INSERT INTO `tplay_admin_rule` VALUES ('43', 'portal/contentCate', '分类列表', '1', '', '1526090519', '1526090519');
INSERT INTO `tplay_admin_rule` VALUES ('44', 'portal/addContentCate', '新增分类', '1', '', '1526090537', '1526090537');
INSERT INTO `tplay_admin_rule` VALUES ('45', 'portal/editContentCate', '修改分类', '1', '', '1526090549', '1526090549');
INSERT INTO `tplay_admin_rule` VALUES ('46', 'portal/delContentCate', '删除分类', '1', '', '1526090560', '1526090560');
INSERT INTO `tplay_admin_rule` VALUES ('47', 'portal/contentCateGroup', '分类组列表', '1', '', '1526090578', '1526090578');
INSERT INTO `tplay_admin_rule` VALUES ('48', 'portal/addContentCateGroup', '新增分类组', '1', '', '1526090590', '1526090590');
INSERT INTO `tplay_admin_rule` VALUES ('49', 'portal/editContentCateGroup', '修改分类组', '1', '', '1526090600', '1526090600');
INSERT INTO `tplay_admin_rule` VALUES ('50', 'portal/delContentCateGroup', '删除分类组', '1', '', '1526090607', '1526090607');
INSERT INTO `tplay_admin_rule` VALUES ('51', 'portal/content', '文章/商品', '1', '', '1526094909', '1526094965');
INSERT INTO `tplay_admin_rule` VALUES ('52', 'portal/addContent', '新增文章/商品', '1', '', '1526094933', '1526094933');
INSERT INTO `tplay_admin_rule` VALUES ('53', 'portal/editContent', '修改文章/商品', '1', '', '1526094943', '1526094943');
INSERT INTO `tplay_admin_rule` VALUES ('54', 'portal/delContent', '删除文章/商品', '1', '', '1526094956', '1526094956');
INSERT INTO `tplay_admin_rule` VALUES ('55', 'user/index', '用户列表', '1', '', '1526626484', '1526626484');
INSERT INTO `tplay_admin_rule` VALUES ('56', 'user/shielding', '用户拉黑', '1', '', '1526626523', '1526626523');
INSERT INTO `tplay_admin_rule` VALUES ('57', 'user/message', '评论列表', '1', '', '1526631351', '1526631351');
INSERT INTO `tplay_admin_rule` VALUES ('58', 'user/shieldingMsg', '禁用评论', '1', '', '1526631422', '1526631422');
INSERT INTO `tplay_admin_rule` VALUES ('59', 'user/delMsg', '删除评论', '1', '', '1526631434', '1526631434');
INSERT INTO `tplay_admin_rule` VALUES ('60', 'user/contact', '留言列表', '1', '', '1526633353', '1526633353');
INSERT INTO `tplay_admin_rule` VALUES ('61', 'user/delContact', '删除留言', '1', '', '1526633366', '1526633366');
-- ----------------------------
-- Table structure for `tplay_carousel`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_carousel`;
CREATE TABLE `tplay_carousel` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`href` varchar(255) DEFAULT NULL,
`img` mediumtext NOT NULL COMMENT '图片地址',
`carousel_cate_id` int(11) NOT NULL DEFAULT '1',
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1可用-1禁用',
`is_target` int(1) NOT NULL DEFAULT '0' COMMENT '1新窗口打开0不是',
`order` int(11) NOT NULL DEFAULT '0' COMMENT '排序值越小越靠前',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_carousel
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_carousel_cate`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_carousel_cate`;
CREATE TABLE `tplay_carousel_cate` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`key` varchar(255) NOT NULL COMMENT '标识',
`is_main` int(1) NOT NULL DEFAULT '0' COMMENT '0非主轮播1主轮播',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='轮播分组';
-- ----------------------------
-- Records of tplay_carousel_cate
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_contact`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_contact`;
CREATE TABLE `tplay_contact` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`phone` bigint(11) NOT NULL,
`email` varchar(100) NOT NULL,
`contact` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_contact
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_content`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_content`;
CREATE TABLE `tplay_content` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`tag` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`content_cate_id` int(11) NOT NULL,
`img` text NOT NULL,
`content` text,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1' COMMENT '0不显示1显示',
`num` int(11) NOT NULL DEFAULT '0' COMMENT '阅读量',
PRIMARY KEY (`id`),
KEY `id` (`id`) USING BTREE,
KEY `article_cate_id` (`content_cate_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_content
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_content_cate`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_content_cate`;
CREATE TABLE `tplay_content_cate` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content_cate_group_id` int(11) NOT NULL DEFAULT '1',
`pid` int(11) NOT NULL DEFAULT '0' COMMENT '0顶级菜单',
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1正常-1删除',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_content_cate
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_content_cate_group`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_content_cate_group`;
CREATE TABLE `tplay_content_cate_group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`key` varchar(255) NOT NULL COMMENT '标识',
`is_main` int(1) NOT NULL DEFAULT '0' COMMENT '0非主分类1主分类',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='前台菜单分类';
-- ----------------------------
-- Records of tplay_content_cate_group
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_index_menu`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_index_menu`;
CREATE TABLE `tplay_index_menu` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`href` varchar(255) DEFAULT NULL,
`index_menu_cate_id` int(11) NOT NULL DEFAULT '1',
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1可用-1禁用',
`is_target` int(1) NOT NULL DEFAULT '0' COMMENT '1新窗口打开0不是',
`pid` int(11) NOT NULL DEFAULT '0' COMMENT '0顶级菜单',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_index_menu
-- ----------------------------
INSERT INTO `tplay_index_menu` VALUES ('6', '首页', '/', '1', '1', '0', '0', '1525934060', '1526696427');
INSERT INTO `tplay_index_menu` VALUES ('7', '列表页', 'index/article/index', '1', '1', '0', '0', '1525934452', '1526696449');
INSERT INTO `tplay_index_menu` VALUES ('8', '联系页', '/index/contact/contact', '1', '1', '0', '0', '1526712207', '1526712675');
-- ----------------------------
-- Table structure for `tplay_index_menu_cate`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_index_menu_cate`;
CREATE TABLE `tplay_index_menu_cate` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`key` varchar(255) NOT NULL COMMENT '标识',
`is_main` int(1) NOT NULL DEFAULT '0' COMMENT '0非主菜单1主菜单',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='前台菜单分类';
-- ----------------------------
-- Records of tplay_index_menu_cate
-- ----------------------------
INSERT INTO `tplay_index_menu_cate` VALUES ('1', '顶部公共菜单', 'tplay_index_main_menu', '1', null, '1525943138');
-- ----------------------------
-- Table structure for `tplay_message`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_message`;
CREATE TABLE `tplay_message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`ip` varchar(50) NOT NULL,
`message` text NOT NULL,
`update_time` int(11) NOT NULL,
`content_id` int(11) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1正常-1禁止显示',
`user_id` int(11) NOT NULL,
`to_user_id` int(11) DEFAULT NULL COMMENT '回复对象id',
`is_look` int(1) NOT NULL DEFAULT '0' COMMENT '0未读1已读',
PRIMARY KEY (`id`),
KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_message
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_system`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_system`;
CREATE TABLE `tplay_system` (
`name` varchar(100) NOT NULL,
`key` varchar(100) NOT NULL,
`value` text NOT NULL,
`type` int(1) NOT NULL DEFAULT '0' COMMENT '0单值1对象',
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1正常0禁用',
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
UNIQUE KEY `key` (`key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_system
-- ----------------------------
INSERT INTO `tplay_system` VALUES ('邮件配置', 'tplay_email_config', '[{\"id\":\"123\",\"key\":\"haha\"}]', '1', '-1', '1526628579', '1526694025');
INSERT INTO `tplay_system` VALUES ('网站描述', 'tplay_web_desc', '新版的Tplay采用了前后端完全分离的模式开发，且前端提供路由功能并非普通的iframe；此外，新版的前端和后端完全可分开作为独立的应用去使用。', '0', '-1', '1524883672', '1526694025');
INSERT INTO `tplay_system` VALUES ('网站名称', 'tplay_web_name', 'Easy Tp 2.0', '0', '-1', '0', '1526694025');
INSERT INTO `tplay_system` VALUES ('网站信息配置', 'web_config', '{\"name\":\"Easy Tp\",\"title\":\"Tplay内容管理框架\",\"tag\":\"Tplay,tp5,layui\",\"desc\":\"Tplay内容管理框架采用Layui+ThinkPHP5开发。\"}', '1', '1', '1526694190', '1526714757');
-- ----------------------------
-- Table structure for `tplay_user`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_user`;
CREATE TABLE `tplay_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`salt` varchar(100) DEFAULT NULL,
`openid` varchar(255) NOT NULL,
`gender` varchar(10) NOT NULL DEFAULT '',
`login_string` varchar(500) NOT NULL,
`create_time` int(11) NOT NULL,
`last_login_time` int(11) NOT NULL,
`last_login_ip` varchar(255) NOT NULL,
`login_num` int(11) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '1' COMMENT '1正常-1禁止登陆',
`thumb` varchar(500) NOT NULL DEFAULT '/static/index/img/msg.jpg' COMMENT '头像',
`update_time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_user
-- ----------------------------
-- ----------------------------
-- Table structure for `tplay_user_log`
-- ----------------------------
DROP TABLE IF EXISTS `tplay_user_log`;
CREATE TABLE `tplay_user_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL,
`num` int(11) NOT NULL DEFAULT '1',
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tplay_user_log
-- ----------------------------
Вы можете оставить комментарий после Вход в систему
Неприемлемый контент может быть отображен здесь и не будет показан на странице. Вы можете проверить и изменить его с помощью соответствующей функции редактирования.
Если вы подтверждаете, что содержание не содержит непристойной лексики/перенаправления на рекламу/насилия/вульгарной порнографии/нарушений/пиратства/ложного/незначительного или незаконного контента, связанного с национальными законами и предписаниями, вы можете нажать «Отправить» для подачи апелляции, и мы обработаем ее как можно скорее.
Опубликовать ( 0 )