master

分支 (1)

管理

管理

master

auction-system
/
test_01.sql

/*
Navicat MySQL Data Transfer

Source Server         : 本机
Source Server Version : 80021
Source Host           : localhost:3306
Source Database       : test_01

Target Server Type    : MYSQL
Target Server Version : 80021
File Encoding         : 65001

Date: 2022-06-15 21:33:25
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for auction
-- ----------------------------
DROP TABLE IF EXISTS `auction`;
CREATE TABLE `auction` (
  `auctionId` int NOT NULL AUTO_INCREMENT,
  `auctionName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `auctionStartPrice` decimal(9,2) NOT NULL,
  `auctionUpset` decimal(9,2) NOT NULL,
  `auctionStartTime` datetime NOT NULL,
  `auctionEndTime` datetime NOT NULL,
  `auctionPic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `auctionPicType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `auctionDesc` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`auctionId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of auction
-- ----------------------------
INSERT INTO `auction` VALUES ('2', '旧电脑', '100.00', '100.00', '2017-04-20 00:00:00', '2018-07-20 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', '差价');
INSERT INTO `auction` VALUES ('4', '旧电脑2', '100.00', '100.00', '2017-04-20 00:00:00', '2018-07-19 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', 'very good');
INSERT INTO `auction` VALUES ('5', '旧桌子', '200.00', '200.00', '2017-04-20 00:00:00', '2017-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'jpg', 'very good');
INSERT INTO `auction` VALUES ('7', '旧电脑5', '100.00', '100.00', '2017-04-20 00:00:00', '2017-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', 'very good');
INSERT INTO `auction` VALUES ('8', '旧桌子2', '200.00', '200.00', '2017-04-20 00:00:00', '2017-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', 'very good');
INSERT INTO `auction` VALUES ('9', '旧桌子3', '200.00', '200.00', '2017-04-20 00:00:00', '2017-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', 'very good');
INSERT INTO `auction` VALUES ('11', '花瓶', '1000.00', '1000.00', '2017-04-23 00:00:00', '2017-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', '差评');
INSERT INTO `auction` VALUES ('13', '旧碗', '56.00', '56.00', '2017-04-23 00:00:00', '2017-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'jpg', 'sss');
INSERT INTO `auction` VALUES ('14', '显示器', '1222.00', '1222.00', '2017-04-24 00:00:00', '2018-04-28 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', 'dsds');
INSERT INTO `auction` VALUES ('16', '旧拖鞋', '10.00', '10.00', '2017-06-14 00:00:00', '2017-06-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', '标杆');
INSERT INTO `auction` VALUES ('19', '牛角杯888', '100.00', '100.00', '2017-07-15 00:00:00', '2017-07-29 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'gif', 'very good');
INSERT INTO `auction` VALUES ('20', 'AK74', '100.00', '100.00', '2017-07-22 00:00:00', '2017-07-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'gif', '好');
INSERT INTO `auction` VALUES ('21', '二手尿壶99', '100.00', '100.00', '2018-03-13 00:00:00', '2018-03-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', '好用!');
INSERT INTO `auction` VALUES ('22', '二手宝马444', '10000.00', '10000.00', '2018-03-10 00:00:00', '2018-03-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'ssss');
INSERT INTO `auction` VALUES ('23', '二手尿壶82', '500.00', '100.00', '2018-03-08 00:00:00', '2018-03-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/gif', 'sss');
INSERT INTO `auction` VALUES ('25', '显示器007', '100.00', '100.00', '2018-04-08 00:00:00', '2018-04-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '非常好');
INSERT INTO `auction` VALUES ('29', '杯子10000', '100.00', '100.00', '2018-05-08 00:00:00', '2018-05-29 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '差评');
INSERT INTO `auction` VALUES ('31', '二手尿壶777', '1000.00', '1000.00', '2018-06-10 00:00:00', '2018-06-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '好用');
INSERT INTO `auction` VALUES ('32', '二手古董尿壶008', '2000.00', '2000.00', '2018-06-22 00:00:00', '2018-06-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '好用');
INSERT INTO `auction` VALUES ('33', '二手古董尿壶11111', '90.00', '90.00', '2018-06-30 00:00:00', '2018-07-21 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '好用');
INSERT INTO `auction` VALUES ('34', '宝马0900', '2000.00', '2000.00', '2018-07-01 00:00:00', '2018-07-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'ssss');
INSERT INTO `auction` VALUES ('35', '二手古董尿壶0000', '2000.00', '2000.00', '2018-07-02 00:00:00', '2018-11-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'sss');
INSERT INTO `auction` VALUES ('36', 'iphone8', '8000.00', '8000.00', '2018-07-05 10:33:13', '2018-11-30 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'jpg', '好用');
INSERT INTO `auction` VALUES ('38', '二手古董尿壶007', '90.00', '90.00', '2018-07-08 00:00:00', '2018-12-01 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '好用');
INSERT INTO `auction` VALUES ('40', '旧中华字典008', '10.00', '10.00', '2018-12-04 00:00:00', '2019-02-01 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'very good');
INSERT INTO `auction` VALUES ('42', '花瓶8888', '1000.00', '1000.00', '2019-01-18 00:00:00', '2019-01-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'sssafds');
INSERT INTO `auction` VALUES ('43', '三手电脑1', '1111.00', '1111.00', '2019-03-23 00:00:00', '2019-03-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'ddd');
INSERT INTO `auction` VALUES ('44', '三手电脑2', '1111.00', '1111.00', '2019-03-09 00:00:00', '2019-03-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '大哥大');
INSERT INTO `auction` VALUES ('45', '三手电脑8888', '1111.00', '1111.00', '2019-03-29 00:00:00', '2019-03-31 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'dssafs');
INSERT INTO `auction` VALUES ('46', 'AK74', '111.00', '111.00', '2019-03-31 16:00:00', '2019-04-29 16:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'aaaa');
INSERT INTO `auction` VALUES ('47', 'abck', '50.00', '30.00', '2019-04-06 16:00:00', '2019-04-06 16:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '333');
INSERT INTO `auction` VALUES ('49', '四手电脑', '111.00', '111.00', '2019-04-05 16:00:00', '2019-04-05 16:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'sss');
INSERT INTO `auction` VALUES ('50', '四手电脑22', '111.00', '111.00', '2019-04-02 16:00:00', '2059-04-26 16:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '111');
INSERT INTO `auction` VALUES ('51', '三手电脑3', '1111.00', '1111.00', '2019-04-05 00:00:00', '2019-04-26 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'dfsa');
INSERT INTO `auction` VALUES ('52', '三手电脑888', '1111.00', '1111.00', '2019-01-01 00:00:00', '2049-01-01 00:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'good');
INSERT INTO `auction` VALUES ('53', '旧olll', '111.00', '9090.00', '2019-01-03 00:00:00', '2019-01-28 14:50:56', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', 'klklk');
INSERT INTO `auction` VALUES ('62', '测试001', '100.00', '100.00', '2022-06-05 16:00:00', '2022-06-05 16:00:00', '16552099637255fa3f6264c0f71faf4dc9c639e220b4d.jpg', 'image/jpeg', 'awfe');
INSERT INTO `auction` VALUES ('63', '测试002', '100.00', '100.00', '2022-06-04 16:00:00', '2022-06-04 16:00:00', '16552148632705fa3f6264c0f71faf4dc9c639e220b4d.jpg', 'image/jpeg', 'awfe');
INSERT INTO `auction` VALUES ('65', 'ces004', '100.00', '100.00', '2022-06-05 16:00:00', '2022-06-05 16:00:00', '16552146825327c37f209b6a696a58d6a5a52b2833d1d.jpg', 'image/jpeg', 're');
INSERT INTO `auction` VALUES ('66', '测试005', '100.00', '1300.00', '2022-06-09 16:00:00', '2022-06-29 16:00:00', '16552175015883bb6c645c7922a9027dac1e08fd3777e.jpg', 'image/jpeg', '好东西');

-- ----------------------------
-- Table structure for auctionrecord
-- ----------------------------
DROP TABLE IF EXISTS `auctionrecord`;
CREATE TABLE `auctionrecord` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int DEFAULT NULL,
  `auctionId` int NOT NULL,
  `auctionTime` datetime NOT NULL,
  `auctionPrice` decimal(9,2) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK_rec_REF_user` (`userId`) USING BTREE,
  KEY `FK_rec_REF_AUC` (`auctionId`) USING BTREE,
  CONSTRAINT `FK_rec_REF_AUC` FOREIGN KEY (`auctionId`) REFERENCES `auction` (`auctionId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_rec_REF_user` FOREIGN KEY (`userId`) REFERENCES `user` (`userId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of auctionrecord
-- ----------------------------
INSERT INTO `auctionrecord` VALUES ('5', null, '2', '2018-06-30 09:36:04', '127.00');
INSERT INTO `auctionrecord` VALUES ('6', '5', '2', '2017-04-25 09:27:40', '123.00');
INSERT INTO `auctionrecord` VALUES ('9', '5', '16', '2017-06-14 20:45:57', '19.00');
INSERT INTO `auctionrecord` VALUES ('10', '5', '20', '2017-07-18 15:33:10', '110.00');
INSERT INTO `auctionrecord` VALUES ('11', '5', '20', '2017-07-18 15:33:45', '120.00');
INSERT INTO `auctionrecord` VALUES ('12', '9', '21', '2018-03-13 16:18:19', '110.00');
INSERT INTO `auctionrecord` VALUES ('13', '5', '21', '2018-03-13 16:19:03', '120.00');
INSERT INTO `auctionrecord` VALUES ('14', '10', '14', '2018-03-14 08:47:43', '1555.00');
INSERT INTO `auctionrecord` VALUES ('16', '10', '21', '2018-03-14 08:48:20', '130.00');
INSERT INTO `auctionrecord` VALUES ('17', '5', '21', '2018-03-24 09:36:27', '145.00');
INSERT INTO `auctionrecord` VALUES ('24', '5', '29', '2018-05-10 14:29:42', '110.00');
INSERT INTO `auctionrecord` VALUES ('25', '5', '29', '2018-05-10 14:30:05', '120.00');
INSERT INTO `auctionrecord` VALUES ('28', '5', '31', '2018-06-14 14:52:51', '1100.00');
INSERT INTO `auctionrecord` VALUES ('29', '5', '31', '2018-06-19 09:19:55', '1200.00');
INSERT INTO `auctionrecord` VALUES ('30', '5', '31', '2018-06-21 09:30:30', '1300.00');
INSERT INTO `auctionrecord` VALUES ('31', '5', '32', '2018-06-26 19:41:06', '2100.00');
INSERT INTO `auctionrecord` VALUES ('32', '5', '34', '2018-07-01 09:16:56', '2400.00');
INSERT INTO `auctionrecord` VALUES ('33', '5', '35', '2018-07-02 19:57:20', '2200.00');
INSERT INTO `auctionrecord` VALUES ('34', '5', '33', '2018-07-07 10:37:17', '100.00');
INSERT INTO `auctionrecord` VALUES ('35', '5', '33', '2018-07-07 10:37:36', '120.00');
INSERT INTO `auctionrecord` VALUES ('38', '5', '38', '2018-10-21 10:13:30', '100.00');
INSERT INTO `auctionrecord` VALUES ('45', '5', '40', '2018-12-05 09:35:27', '11.00');
INSERT INTO `auctionrecord` VALUES ('46', '5', '40', '2018-12-05 09:35:51', '12.00');
INSERT INTO `auctionrecord` VALUES ('47', '10', '43', '2019-03-26 16:52:24', '1200.00');
INSERT INTO `auctionrecord` VALUES ('48', '10', '43', '2019-03-26 17:20:47', '1377.00');
INSERT INTO `auctionrecord` VALUES ('49', '10', '45', '2019-03-28 16:32:35', '1211.00');
INSERT INTO `auctionrecord` VALUES ('50', '10', '45', '2019-03-28 16:34:38', '1250.00');
INSERT INTO `auctionrecord` VALUES ('51', '10', '46', '2019-04-02 06:31:09', '112.00');
INSERT INTO `auctionrecord` VALUES ('52', '10', '50', '2019-04-02 08:37:59', '122.00');
INSERT INTO `auctionrecord` VALUES ('53', '10', '47', '2019-04-13 14:33:16', '23.00');
INSERT INTO `auctionrecord` VALUES ('54', '10', '52', '2019-04-20 15:00:19', '1200.00');
INSERT INTO `auctionrecord` VALUES ('55', '10', '52', '2019-01-02 09:52:50', '1300.00');
INSERT INTO `auctionrecord` VALUES ('56', '10', '49', '2022-06-14 06:11:24', '112.00');
INSERT INTO `auctionrecord` VALUES ('57', '10', '49', '2022-06-14 06:11:54', '113.00');
INSERT INTO `auctionrecord` VALUES ('58', '10', '49', '2022-06-14 06:17:27', '150.00');
INSERT INTO `auctionrecord` VALUES ('59', '10', '50', '2022-06-14 06:18:55', '130.00');
INSERT INTO `auctionrecord` VALUES ('60', '10', '50', '2022-06-14 06:18:58', '140.00');
INSERT INTO `auctionrecord` VALUES ('61', '10', '66', '2022-06-14 15:44:10', '300.00');
INSERT INTO `auctionrecord` VALUES ('62', '10', '66', '2022-06-14 15:51:37', '301.00');
INSERT INTO `auctionrecord` VALUES ('63', '10', '66', '2022-06-14 15:52:46', '302.00');
INSERT INTO `auctionrecord` VALUES ('64', '10', '66', '2022-06-14 16:10:20', '303.00');
INSERT INTO `auctionrecord` VALUES ('65', '10', '66', '2022-06-14 16:22:10', '304.00');
INSERT INTO `auctionrecord` VALUES ('66', '10', '66', '2022-06-14 16:23:54', '305.00');
INSERT INTO `auctionrecord` VALUES ('67', '10', '66', '2022-06-14 16:25:43', '306.00');
INSERT INTO `auctionrecord` VALUES ('68', '10', '66', '2022-06-14 16:29:25', '307.00');
INSERT INTO `auctionrecord` VALUES ('69', '10', '66', '2022-06-14 16:33:01', '308.00');
INSERT INTO `auctionrecord` VALUES ('70', '10', '66', '2022-06-14 16:39:04', '309.00');
INSERT INTO `auctionrecord` VALUES ('71', '10', '66', '2022-06-14 16:39:19', '310.00');
INSERT INTO `auctionrecord` VALUES ('72', '10', '66', '2022-06-14 16:42:09', '320.00');
INSERT INTO `auctionrecord` VALUES ('73', '10', '66', '2022-06-14 16:44:31', '330.00');
INSERT INTO `auctionrecord` VALUES ('74', '10', '66', '2022-06-14 16:45:49', '340.00');
INSERT INTO `auctionrecord` VALUES ('75', '10', '66', '2022-06-15 08:26:33', '350.00');
INSERT INTO `auctionrecord` VALUES ('76', '10', '66', '2022-06-15 08:31:42', '360.00');
INSERT INTO `auctionrecord` VALUES ('77', '10', '66', '2022-06-15 08:32:31', '400.00');
INSERT INTO `auctionrecord` VALUES ('78', '10', '66', '2022-06-15 08:34:07', '410.00');
INSERT INTO `auctionrecord` VALUES ('79', '10', '66', '2022-06-15 08:34:46', '420.00');
INSERT INTO `auctionrecord` VALUES ('80', '10', '66', '2022-06-15 08:46:35', '430.00');
INSERT INTO `auctionrecord` VALUES ('81', '10', '66', '2022-06-15 09:46:42', '440.00');
INSERT INTO `auctionrecord` VALUES ('82', '10', '66', '2022-06-15 10:02:28', '480.00');
INSERT INTO `auctionrecord` VALUES ('83', '10', '66', '2022-06-15 10:15:59', '490.00');
INSERT INTO `auctionrecord` VALUES ('84', '10', '66', '2022-06-15 10:17:19', '500.00');
INSERT INTO `auctionrecord` VALUES ('85', '10', '66', '2022-06-15 10:23:50', '501.00');
INSERT INTO `auctionrecord` VALUES ('86', '10', '66', '2022-06-15 10:27:28', '502.00');
INSERT INTO `auctionrecord` VALUES ('87', '10', '66', '2022-06-15 10:29:18', '503.00');
INSERT INTO `auctionrecord` VALUES ('88', '10', '66', '2022-06-15 10:43:37', '510.00');
INSERT INTO `auctionrecord` VALUES ('89', '10', '66', '2022-06-15 10:43:42', '520.00');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userId` int NOT NULL AUTO_INCREMENT COMMENT '用户表',
  `userName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `userPassword` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `userCardNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userTel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userPostNumber` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userIsadmin` int DEFAULT '0',
  `userQuestion` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `userAnswer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '旺财', '8888', null, null, null, null, '0', null, null);
INSERT INTO `user` VALUES ('4', 'Mike', '00000', null, null, null, null, '1', null, null);
INSERT INTO `user` VALUES ('5', 'test1', '999', '123456789012345678', '8787878', '广东省广州', '600600', '0', '', '');
INSERT INTO `user` VALUES ('7', '张三', '0000', null, null, null, null, '1', null, null);
INSERT INTO `user` VALUES ('8', '李四', '10000', '123456789012345678', null, null, '511500', '0', null, null);
INSERT INTO `user` VALUES ('9', 'Jack', '99999', '12345646456464', '99999999', 'gangdong', '599599', '0', '', '');
INSERT INTO `user` VALUES ('10', 'kk', '11', '123456789012345', '12234', 'sadfsaf', '23443', '0', '', '');
INSERT INTO `user` VALUES ('11', 'kkkkkk', '1231313', '123456789012345678', '3234444', 'ewqeqe', '122122', '0', null, null);
INSERT INTO `user` VALUES ('12', 'mike', '1234567', 'asdadad', '1234567', 'werwrewr', '323', null, null, null);
INSERT INTO `user` VALUES ('13', 'jason', '1234567', '32131313', '12345678', 'dsfas', '324234', null, null, null);
INSERT INTO `user` VALUES ('14', 'jack', '1234567', '123456789012345678', '120', 'sdfsaf', '332333', null, null, null);
INSERT INTO `user` VALUES ('15', 'mikd', '12345678', '123456789012345678', '120', 'sss', '324234', null, null, null);
INSERT INTO `user` VALUES ('16', 'jack', '1234', '123456789012345678', '23233', 'dfsf', '122122', null, null, null);
INSERT INTO `user` VALUES ('17', 'kate', '123', '123456789012345678', '2222', 'asdad', '324234', '0', null, null);
INSERT INTO `user` VALUES ('18', 'mike', '1223', '123456789012345678', '110', 'fsfs', '324234', null, null, null);
INSERT INTO `user` VALUES ('19', 'Mike', '123456', '123456789012345678', '110', 'sss', '511500', '0', null, null);
INSERT INTO `user` VALUES ('20', '张三11', '123', '23244', '21212', '广州', '1001', '0', null, null);
INSERT INTO `user` VALUES ('21', 'kk_2w1231', '1212', '12123', '3q1231', 'ajska', '11', '0', null, null);
INSERT INTO `user` VALUES ('22', 'ou', '1111', '444', '44', '44', '4', '0', null, null);
INSERT INTO `user` VALUES ('23', 'eawf', 'faew', 'faew', 'awfe', 'awfe', 'eawf', '0', null, null);