### 数据字典
```sql
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1_3306
Source Server Version : 50714
Source Host : 127.0.0.1:3306
Source Database : lipin
Target Server Type : MYSQL
Target Server Version : 50714
File Encoding : 65001
Date: 2017-3-31 02:58:32
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `lipin_user`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_user`;
CREATE TABLE `lipin_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵称',
`imei` varchar(250) NULL DEFAULT NULL COMMENT 'imei',
`avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '头像',
`qq` char(10) NOT NULL DEFAULT '' COMMENT 'qq号',
`password` char(40) NOT NULL DEFAULT '' COMMENT '用户密码',
`salt` char(32) NOT NULL DEFAULT '' COMMENT '用于保护用户密码安全的盐值',
-- 这个用户邮箱和手机是唯一的，但是有的人开始并没有绑定邮箱或手机，所以也不能为空串，不然唯一冲突，所以只能允许为空null了，并且默认为null
`email` char(32) NULL DEFAULT NULL COMMENT '用户邮箱',
`mobile` char(15) NULL DEFAULT NULL COMMENT '用户手机',
`score` mediumint(8) NOT NULL DEFAULT 0 COMMENT '用户积分',
`login` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '登录次数',
`create_ip` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '注册IP',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '注册时间',
`last_login_ip` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '最后登录IP',
`last_login_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '最后登录时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '状态',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`) USING BTREE,
UNIQUE KEY `mobile` (`mobile`) USING BTREE,
UNIQUE KEY `imei` (`imei`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of lipin_user
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_products_library`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_products_library`;
CREATE TABLE `lipin_products_library` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL DEFAULT '' COMMENT '产品名称',
`describe` longtext NULL COMMENT '产品描述/简介',
`price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '指导价格',
`img` varchar(500) NOT NULL DEFAULT '' COMMENT 'img，产品大图',
`min_img` varchar(500) NOT NULL DEFAULT '' COMMENT 'min_img，产品图标/小图',
`pic` text NULL COMMENT '产品相册，使用,分割多图',
`video` varchar(500) NOT NULL DEFAULT '' COMMENT '产品介绍视频',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '状态，0-停用，1-启用',
PRIMARY KEY (`id`),
KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='产品库表';
-- ----------------------------
-- Records of lipin_products_library
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_video_qrcode`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_video_qrcode`;
CREATE TABLE `lipin_video_qrcode` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`products_library_id` int(10) unsigned NOT NULL COMMENT '产品库ID',
`bind_user` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '绑定的用户ID，表示哪个用户为此产品添加小视屏',
`bind_user_note` varchar(250) NOT NULL DEFAULT '绑定的用户的备注' COMMENT '绑定的用户的备注',
`view_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '查看次数',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
`bind_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '绑定时间',
`active_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活跃时间',
`status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '状态，0-停用，1-启用',
PRIMARY KEY (`id`),
KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='小视屏二维码';
-- ----------------------------
-- Records of lipin_video_qrcode
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_track_qrcode`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_track_qrcode`;
CREATE TABLE `lipin_track_qrcode` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`products_library_id` int(10) unsigned NOT NULL COMMENT '产品库ID',
`track_user` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '监控的用户ID，表示哪个用户监控此产品',
`be_track_user` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '被监控的用户，也就是只监控一个人',
`track_user_note` varchar(250) NOT NULL DEFAULT '监控的用户的备注' COMMENT '监控的用户的备注',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
`track_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '监控时间',
`active_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活跃时间',
`status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '状态，0-停用，1-启用',
PRIMARY KEY (`id`),
KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='监控/定位二维码';
-- ----------------------------
-- Records of lipin_track_qrcode
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_mini_video`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_mini_video`;
CREATE TABLE `lipin_mini_video` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`video_qrcode_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属视频二维码ID',
`user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
-- 文本的要设置为允许为空，因为它不能设置默认值（实际上默认值就是NULL），如果插入数据时没有值会报错的（没有值时就用缺省值，而缺省值就是默认值）
`content` longtext NULL COMMENT 'content',
`main_img` varchar(500) NOT NULL DEFAULT '' COMMENT '主图，备用字段',
`pic` text NULL COMMENT '相册，使用,分割多图',
`video` varchar(500) NOT NULL DEFAULT '' COMMENT '视频',
`address` varchar(250) NOT NULL DEFAULT '' COMMENT '地址',
`longitude` varchar(250) NOT NULL DEFAULT '' COMMENT '经度',
`latitude` varchar(250) NOT NULL DEFAULT '' COMMENT '纬度',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='小视频';
-- ----------------------------
-- Records of lipin_mini_video
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_track_record`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_track_record`;
CREATE TABLE `lipin_track_record` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`track_qrcode_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '定位二维码ID',
`user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
`longitude` varchar(250) NULL DEFAULT '' COMMENT '经度',
`latitude` varchar(250) NULL DEFAULT '' COMMENT '纬度',
`address` varchar(250) NOT NULL DEFAULT '' COMMENT '地址',
`create_ip` bigint(20) unsigned NULL DEFAULT 0 COMMENT '请求IP',
`create_time` int(10) unsigned NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='礼物跟踪记录表';
-- ----------------------------
-- Records of lipin_track_record
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_tag`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_tag`;
CREATE TABLE `lipin_tag` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所属资料库ID',
`tagid` varchar(100) NOT NULL DEFAULT 0 COMMENT 'NFC标签ID',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(4) DEFAULT 0 COMMENT '状态，0-停用，1-启用',
PRIMARY KEY (`id`),
UNIQUE KEY `tagid` (`tagid`) USING BTREE,
KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='标签库表';
-- ----------------------------
-- Records of lipin_tag
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_device`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_device`;
CREATE TABLE `lipin_device` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`imei` varchar(250) NOT NULL DEFAULT '' COMMENT '设备imei',
`user_name` varchar(250) NULL DEFAULT '' COMMENT 'user_name',
`mobile` char(15) NULL COMMENT 'mobile',
`status` tinyint(4) DEFAULT 0 COMMENT '状态，0-禁止，1-允许',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
`active_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活跃时间',
PRIMARY KEY (`id`),
UNIQUE KEY `imei` (`imei`) USING BTREE,
KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='设备表';
-- ----------------------------
-- Records of lipin_device
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_validation_log`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_validation_log`;
CREATE TABLE `lipin_validation_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tagid` varchar(100) NOT NULL DEFAULT 0 COMMENT 'NFC标签ID',
`imei` varchar(100) NULL DEFAULT '' COMMENT '设备imei',
`mobile` char(15) NULL DEFAULT '' COMMENT 'mobile',
`longitude` varchar(250) NULL DEFAULT '' COMMENT '经度',
`latitude` varchar(250) NULL DEFAULT '' COMMENT '纬度',
`request_ip` bigint(20) NULL DEFAULT 0 COMMENT '请求IP',
`color` varchar(20) NULL DEFAULT 0 COMMENT 'color',
`result` varchar(250) NULL DEFAULT '' COMMENT 'result',
`create_time` int(10) unsigned NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='请求日志表';
-- ----------------------------
-- Records of lipin_validation_log
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_gps_log`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_gps_log`;
CREATE TABLE `lipin_gps_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`imei` varchar(100) NULL DEFAULT '' COMMENT '设备imei',
`longitude` varchar(250) NULL DEFAULT '' COMMENT '经度',
`latitude` varchar(250) NULL DEFAULT '' COMMENT '纬度',
`request_ip` bigint(20) NULL DEFAULT 0 COMMENT '请求IP',
`str` varchar(500) NULL DEFAULT '' COMMENT 'str',
`create_time` int(10) unsigned NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='gps日志表';
-- ----------------------------
-- Records of lipin_gps_log
-- ----------------------------
-- ----------------------------
-- Table structure for `lipin_release`
-- ----------------------------
DROP TABLE IF EXISTS `lipin_release`;
CREATE TABLE `lipin_release` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ver` varchar(250) NOT NULL DEFAULT '' COMMENT 'ver',
`url` varchar(250) NOT NULL DEFAULT '' COMMENT 'url',
`size` varchar(250) NOT NULL DEFAULT '' COMMENT 'size',
`md5` varchar(250) NOT NULL DEFAULT '' COMMENT 'md5',
`text` varchar(500) NOT NULL DEFAULT '' COMMENT 'text',
`type` tinyint(4) DEFAULT 0 COMMENT '类型，0-稳定版，1-测试版，2-重要版',
`downloads` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '下载次数',
`create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `type` (`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='软件发布表';
-- ----------------------------
-- Records of lipin_release
-- ----------------------------
```
update time: 2017-3-31 21:05:41
