/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50730 Source Host : localhost:3306 Source Database : socket Target Server Type : MYSQL Target Server Version : 50730 File Encoding : 65001 Date: 2020-12-22 08:27:06 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `is_online` int(255) unsigned NOT NULL, `port` int(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES ('1', 'aa', 'aa111111', '1', '18000'); INSERT INTO `users` VALUES ('2', 'bb', 'bb111111', '1', '18001'); INSERT INTO `users` VALUES ('3', 'cc', 'cc1111111', '0', '18002'); INSERT INTO `users` VALUES ('4', 'dd', 'dd111111', '0', '18003'); INSERT INTO `users` VALUES ('7', 'huawei', '123456', '0', '18004');