/*

Navicat MySQL Data Transfer

Source Server : Tencent

Source Server Type : MySQL

Source Server Version : 50628

Source Host : 5780e03864e11.sh.cdb.myqcloud.com:4201

Source Schema : multimedia

Target Server Type : MySQL

Target Server Version : 50628

File Encoding : 65001

Date: 23/09/2019 17:30:58

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for users

-- ----------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (

`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '11位手机号',

`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'MD5加密',

`createdtime` datetime(0) NOT NULL COMMENT '创建时间',

`group` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户组',

`salt` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '盐',

PRIMARY KEY (`phone`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账号信息' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;