/*
SQLyog Community v13.1.6 (64 bit)
MySQL - 5.7.26 : Database - cs2104
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`cs2104` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `cs2104`;

/*Table structure for table `userinfo` */

DROP TABLE IF EXISTS `userinfo`;

CREATE TABLE `userinfo` (
  `uPhone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `uName` varchar(20) NOT NULL COMMENT '用户名',
  `uPwd` varchar(50) NOT NULL COMMENT '用户名密码',
  `uStatus` varchar(1) DEFAULT '1' COMMENT '1可用,0禁用',
  UNIQUE KEY `uName` (`uName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `userinfo` */

insert  into `userinfo`(`uPhone`,`uName`,`uPwd`,`uStatus`) values 
('12312312312','123321','35d58d9154ed1a4fef09b619162379c3','1'),
('12345678901','12345','68fc54966cf1c28f4c87f4bdfa5d36cf','1'),
('13812345678','abc1231','0f9136edc7f63abb6a49fbb842d4539e','1'),
('12345678901','abc12345','193425128cd4058f5959accdddd58381','1'),
('12345678901','abc123456','2305d3e4ab32fd72c08fe09a59b5d5b7','1'),
('13812345678','admin','0f9136edc7f63abb6a49fbb842d4539e','1'),
('12355667788','admin168','193425128cd4058f5959accdddd58381','1');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;