 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `users` (
   `username` varchar(15) NOT NULL,
-  `password` varchar(45) DEFAULT NULL,
+  `password` varchar(45) NOT NULL,
   `email` varchar(45) DEFAULT NULL,
-  PRIMARY KEY (`username`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  `nickname` varchar(45) DEFAULT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `filePath` varchar(45) DEFAULT NULL,
+  `avatar` varchar(45) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost    Database: share
-- ------------------------------------------------------


LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('aa','a','',NULL,1,NULL,NULL),('admin','admin',NULL,NULL,2,NULL,NULL),('b','bb','',NULL,3,NULL,NULL),('lsf','1','1@qq.com',NULL,4,NULL,NULL),('susu','123','susu@qq.com',NULL,5,NULL,NULL),('lsf','19921016','lsf921016@126.com','shuishui',6,NULL,'/dinosaur/resource/avatar.jpg'),('aaaa','aaaa','aaaa','aaaa',9,NULL,'/dinosaur/resource/avatar.jpg'),('qqqq','qqqq','qqqq','qqqq',10,NULL,'/dinosaur/resource/avatar.jpg'),('ccc','ccc','ccc','cccc',11,NULL,'/dinosaur/resource/avatar.jpg');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
