/*
 Navicat Premium Data Transfer

 Source Server         : 本机
 Source Server Type    : MySQL
 Source Server Version : 50717 (5.7.17-log)
 Source Host           : localhost:3306
 Source Schema         : community_system

 Target Server Type    : MySQL
 Target Server Version : 50717 (5.7.17-log)
 File Encoding         : 65001

 Date: 18/08/2023 16:56:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `numbers` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `units` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `remarks` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES (1, '1栋', '1单元', NULL);
INSERT INTO `building` VALUES (2, '2栋', '2单元', NULL);
INSERT INTO `building` VALUES (3, '3栋', '3单元', NULL);
INSERT INTO `building` VALUES (4, '4栋', '4单元', NULL);
INSERT INTO `building` VALUES (5, '5栋', '5单元', NULL);
INSERT INTO `building` VALUES (6, '6栋', '1单元', NULL);
INSERT INTO `building` VALUES (7, '7栋', '2单元', NULL);
INSERT INTO `building` VALUES (8, '8栋', '3单元', NULL);
INSERT INTO `building` VALUES (9, '9栋', '4单元', NULL);
INSERT INTO `building` VALUES (10, '1栋', '5单元', NULL);
INSERT INTO `building` VALUES (11, '2栋', '1单元', NULL);
INSERT INTO `building` VALUES (12, '3栋', '2单元', NULL);
INSERT INTO `building` VALUES (13, '4栋', '3单元', NULL);
INSERT INTO `building` VALUES (14, '5栋', '4单元', NULL);
INSERT INTO `building` VALUES (15, '6栋', '5单元', NULL);
INSERT INTO `building` VALUES (16, '7栋', '1单元', NULL);
INSERT INTO `building` VALUES (17, '8栋', '2单元', NULL);
INSERT INTO `building` VALUES (18, '9栋', '3单元', NULL);
INSERT INTO `building` VALUES (19, '1栋', '4单元', NULL);
INSERT INTO `building` VALUES (20, '2栋', '5单元', NULL);
INSERT INTO `building` VALUES (21, '3栋', '1单元', NULL);
INSERT INTO `building` VALUES (22, '4栋', '2单元', NULL);
INSERT INTO `building` VALUES (23, '5栋', '3单元', NULL);
INSERT INTO `building` VALUES (24, '6栋', '4单元', NULL);
INSERT INTO `building` VALUES (25, '7栋', '5单元', NULL);
INSERT INTO `building` VALUES (26, '8栋', '1单元', NULL);
INSERT INTO `building` VALUES (27, '9栋', '2单元', NULL);
INSERT INTO `building` VALUES (28, '1栋', '3单元', NULL);
INSERT INTO `building` VALUES (29, '2栋', '4单元', NULL);
INSERT INTO `building` VALUES (30, '3栋', '5单元', NULL);

-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house`  (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `storey` int(5) NULL DEFAULT NULL COMMENT '楼层',
  `numbers` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房号',
  `status` int(5) NULL DEFAULT NULL,
  `into_date` datetime NULL DEFAULT NULL,
  `building_id` int(5) NULL DEFAULT NULL COMMENT '建筑的ID',
  `remarks` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `area` double(10, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES (1, 1, '101', 1, '2020-10-01 09:27:52', 1, NULL, 80.00);
INSERT INTO `house` VALUES (2, 8, '803', 1, '2020-11-04 16:00:00', 2, '', 90.00);
INSERT INTO `house` VALUES (3, 3, '303', 1, '2020-11-17 15:52:58', 3, NULL, 100.00);
INSERT INTO `house` VALUES (4, 5, '502', 0, '2021-05-05 16:00:00', 4, '', 75.00);
INSERT INTO `house` VALUES (5, 6, '666', 1, '2022-10-01 09:27:52', 1, NULL, 88.00);
INSERT INTO `house` VALUES (6, 3, '301', 1, '2018-10-17 15:52:58', 2, NULL, 102.00);
INSERT INTO `house` VALUES (7, 2, '202', 1, '2017-03-05 16:00:00', 3, '', 136.00);
INSERT INTO `house` VALUES (8, 8, '804', 1, '2000-11-11 08:00:00', 5, '1111', 99.00);
INSERT INTO `house` VALUES (9, 1, '111', 1, '2000-11-11 22:22:22', 1, '11', 111.00);
INSERT INTO `house` VALUES (10, 1, '123', 1, '2000-11-11 22:11:11', 3, '111', 111.00);
INSERT INTO `house` VALUES (11, 2, '222', 1, '2000-11-11 11:11:11', 3, NULL, 89.00);
INSERT INTO `house` VALUES (12, 4, '509', 0, '2022-12-03 13:56:23', 7, '上海市', 161.00);
INSERT INTO `house` VALUES (13, 25, '102', 0, '2019-09-12 13:44:39', 2, '上海市', 184.00);
INSERT INTO `house` VALUES (14, 29, '333', 0, '2010-05-19 13:17:19', 3, '广州市', 165.00);
INSERT INTO `house` VALUES (15, 21, '960', 0, '2010-07-04 11:44:11', 7, '上海市', 186.00);
INSERT INTO `house` VALUES (16, 27, '505', 0, '2016-02-15 14:24:40', 3, '广州市', 197.00);
INSERT INTO `house` VALUES (17, 17, '203', 0, '2005-06-08 09:57:54', 3, '中山', 170.00);
INSERT INTO `house` VALUES (18, 27, '822', 1, '2009-06-15 14:04:34', 1, '北京市', 175.00);
INSERT INTO `house` VALUES (19, 22, '284', 0, '2018-11-11 14:23:47', 7, '成都市', 196.00);
INSERT INTO `house` VALUES (20, 5, '038', 0, '2006-08-27 12:00:21', 2, '成都市', 91.00);
INSERT INTO `house` VALUES (21, 18, '016', 0, '2001-04-28 14:41:45', 6, '成都市', 130.00);
INSERT INTO `house` VALUES (22, 18, '919', 0, '2010-01-10 11:19:53', 5, '东莞', 191.00);
INSERT INTO `house` VALUES (23, 9, '262', 1, '2015-10-05 11:13:02', 1, '上海市', 126.00);
INSERT INTO `house` VALUES (24, 21, '467', 1, '2004-09-11 12:57:09', 2, '广州市', 152.00);
INSERT INTO `house` VALUES (25, 2, '741', 0, '2019-07-28 12:19:37', 4, '成都市', 128.00);
INSERT INTO `house` VALUES (26, 17, '293', 1, '2018-09-26 10:06:41', 7, '成都市', 152.00);
INSERT INTO `house` VALUES (27, 15, '613', 0, '2006-04-03 17:47:29', 4, '东莞', 125.00);
INSERT INTO `house` VALUES (28, 43, '748', 0, '2021-11-16 10:07:54', 3, '广州市', 190.00);
INSERT INTO `house` VALUES (29, 44, '895', 0, '2019-08-14 13:00:14', 2, '上海市', 176.00);
INSERT INTO `house` VALUES (30, 34, '686', 0, '2012-10-20 12:14:44', 7, '东莞', 111.00);
INSERT INTO `house` VALUES (31, 48, '636', 0, '2008-09-17 10:10:54', 6, '北京市', 178.00);
INSERT INTO `house` VALUES (32, 46, '032', 1, '2013-06-23 15:53:07', 2, '东莞', 97.00);
INSERT INTO `house` VALUES (33, 48, '436', 0, '2019-04-29 09:00:09', 4, '深圳', 176.00);
INSERT INTO `house` VALUES (34, 46, '156', 0, '2017-06-02 14:22:15', 3, '上海市', 170.00);
INSERT INTO `house` VALUES (35, 35, '175', 1, '2008-02-08 11:15:16', 4, '北京市', 97.00);
INSERT INTO `house` VALUES (36, 42, '759', 0, '2009-04-22 16:23:25', 3, '广州市', 131.00);
INSERT INTO `house` VALUES (37, 40, '678', 0, '2002-12-04 17:35:25', 2, '成都市', 146.00);
INSERT INTO `house` VALUES (38, 14, '198', 1, '2001-05-24 13:20:18', 3, '成都市', 96.00);
INSERT INTO `house` VALUES (39, 40, '308', 0, '2017-08-01 11:21:47', 5, '广州市', 151.00);
INSERT INTO `house` VALUES (40, 43, '033', 0, '2013-07-03 12:05:45', 6, '成都市', 167.00);
INSERT INTO `house` VALUES (41, 22, '562', 0, '2021-10-26 16:03:13', 6, '广州市', 95.00);
INSERT INTO `house` VALUES (42, 1, '852', 0, '2002-12-13 15:57:20', 1, '成都市', 106.00);
INSERT INTO `house` VALUES (43, 48, '562', 0, '2004-03-28 13:58:00', 5, '深圳', 109.00);
INSERT INTO `house` VALUES (44, 44, '510', 0, '2003-07-15 10:56:29', 5, '成都市', 170.00);
INSERT INTO `house` VALUES (45, 21, '913', 1, '2005-11-20 14:10:39', 5, '上海市', 160.00);
INSERT INTO `house` VALUES (46, 17, '330', 1, '2008-12-04 14:55:40', 6, '上海市', 123.00);
INSERT INTO `house` VALUES (47, 1, '019', 0, '2018-05-14 15:53:27', 2, '深圳', 144.00);
INSERT INTO `house` VALUES (48, 38, '520', 1, '2018-09-02 15:50:14', 3, '深圳', 166.00);
INSERT INTO `house` VALUES (49, 50, '945', 0, '2020-03-26 17:07:13', 6, '深圳', 194.00);
INSERT INTO `house` VALUES (50, 8, '727', 0, '2021-09-06 15:16:05', 4, '上海市', 135.00);
INSERT INTO `house` VALUES (51, 30, '053', 1, '2004-06-20 16:16:38', 4, '成都市', 151.00);
INSERT INTO `house` VALUES (52, 43, '399', 1, '2014-07-25 13:18:31', 2, '成都市', 138.00);
INSERT INTO `house` VALUES (53, 8, '256', 0, '2022-07-25 15:26:11', 5, '东莞', 117.00);
INSERT INTO `house` VALUES (54, 44, '018', 0, '2004-10-18 14:37:18', 1, '东莞', 182.00);
INSERT INTO `house` VALUES (55, 20, '996', 1, '2001-12-28 15:31:19', 4, '成都市', 108.00);
INSERT INTO `house` VALUES (56, 42, '763', 1, '2017-04-01 12:08:03', 6, '成都市', 192.00);
INSERT INTO `house` VALUES (57, 6, '510', 0, '2001-04-17 09:12:22', 3, '北京市', 186.00);
INSERT INTO `house` VALUES (58, 23, '699', 1, '2017-05-06 09:54:18', 6, '东莞', 197.00);
INSERT INTO `house` VALUES (59, 3, '805', 1, '2009-11-28 17:26:48', 5, '上海市', 195.00);
INSERT INTO `house` VALUES (60, 4, '953', 1, '2017-07-01 10:41:02', 6, '上海市', 184.00);
INSERT INTO `house` VALUES (61, 12, '378', 0, '2016-05-03 09:34:34', 6, '上海市', 180.00);
INSERT INTO `house` VALUES (62, 5, '549', 1, '2000-11-12 12:53:38', 2, '东莞', 114.00);
INSERT INTO `house` VALUES (63, 25, '706', 0, '2000-04-17 09:56:49', 4, '东莞', 110.00);
INSERT INTO `house` VALUES (64, 6, '695', 0, '2009-05-09 17:11:27', 2, '上海市', 196.00);
INSERT INTO `house` VALUES (65, 30, '228', 0, '2021-07-15 11:07:37', 6, '成都市', 132.00);
INSERT INTO `house` VALUES (66, 10, '565', 1, '2018-10-29 15:52:49', 2, '上海市', 114.00);
INSERT INTO `house` VALUES (67, 29, '570', 0, '2014-08-08 15:50:00', 6, '北京市', 195.00);
INSERT INTO `house` VALUES (68, 11, '041', 1, '2000-03-19 10:07:05', 2, '深圳', 104.00);
INSERT INTO `house` VALUES (69, 44, '451', 0, '2000-02-08 11:27:59', 5, '成都市', 142.00);
INSERT INTO `house` VALUES (70, 48, '379', 1, '2014-01-20 13:20:54', 4, '上海市', 161.00);
INSERT INTO `house` VALUES (71, 13, '101', 0, '2008-02-23 14:33:31', 1, '上海市', 91.00);
INSERT INTO `house` VALUES (72, 5, '610', 0, '2021-09-04 13:29:59', 2, '广州市', 128.00);
INSERT INTO `house` VALUES (73, 37, '758', 1, '2010-04-11 10:46:37', 6, '成都市', 122.00);
INSERT INTO `house` VALUES (74, 47, '593', 1, '2006-11-20 14:25:13', 1, '上海市', 102.00);
INSERT INTO `house` VALUES (75, 49, '152', 0, '2004-06-27 15:26:36', 7, '东莞', 105.00);
INSERT INTO `house` VALUES (76, 12, '757', 1, '2018-03-07 12:02:26', 2, '上海市', 163.00);
INSERT INTO `house` VALUES (77, 43, '730', 0, '2017-12-10 13:26:52', 1, '广州市', 113.00);
INSERT INTO `house` VALUES (78, 44, '248', 0, '2010-06-11 10:48:12', 3, '成都市', 176.00);
INSERT INTO `house` VALUES (79, 8, '125', 1, '2020-06-15 16:02:11', 2, '上海市', 197.00);
INSERT INTO `house` VALUES (80, 6, '086', 1, '2009-07-10 16:32:17', 4, '上海市', 177.00);
INSERT INTO `house` VALUES (81, 11, '016', 1, '2002-03-28 11:17:15', 5, '上海市', 134.00);
INSERT INTO `house` VALUES (82, 32, '211', 0, '2019-09-28 11:40:53', 2, '北京市', 178.00);
INSERT INTO `house` VALUES (83, 25, '990', 1, '2021-12-06 15:01:46', 1, '成都市', 97.00);
INSERT INTO `house` VALUES (84, 25, '273', 1, '2009-11-27 17:15:51', 4, '成都市', 161.00);
INSERT INTO `house` VALUES (85, 33, '395', 1, '2022-07-19 14:17:10', 5, '广州市', 176.00);
INSERT INTO `house` VALUES (86, 21, '948', 1, '2011-06-30 10:43:21', 2, '上海市', 95.00);
INSERT INTO `house` VALUES (87, 16, '572', 1, '2019-07-19 10:30:22', 4, '成都市', 112.00);
INSERT INTO `house` VALUES (88, 19, '207', 0, '2022-06-26 16:23:53', 5, '上海市', 95.00);
INSERT INTO `house` VALUES (89, 26, '494', 0, '2019-01-19 15:14:32', 5, '上海市', 137.00);
INSERT INTO `house` VALUES (90, 35, '891', 0, '2005-08-23 17:27:40', 1, '广州市', 92.00);
INSERT INTO `house` VALUES (91, 11, '659', 1, '2016-10-11 14:27:37', 3, '成都市', 127.00);
INSERT INTO `house` VALUES (92, 13, '197', 0, '2008-05-14 16:55:30', 3, '成都市', 135.00);
INSERT INTO `house` VALUES (93, 32, '739', 1, '2010-04-02 09:45:10', 7, '东莞', 127.00);
INSERT INTO `house` VALUES (94, 30, '205', 1, '2008-11-07 14:02:04', 4, '上海市', 136.00);
INSERT INTO `house` VALUES (95, 11, '604', 0, '2019-02-05 14:58:20', 3, '北京市', 138.00);
INSERT INTO `house` VALUES (96, 27, '392', 0, '2002-04-15 11:24:00', 6, '上海市', 185.00);
INSERT INTO `house` VALUES (97, 27, '530', 0, '2005-08-14 17:14:36', 4, '上海市', 137.00);
INSERT INTO `house` VALUES (98, 24, '351', 1, '2012-01-18 09:31:57', 6, '上海市', 158.00);
INSERT INTO `house` VALUES (99, 20, '075', 1, '2022-05-15 15:44:16', 5, '成都市', 149.00);
INSERT INTO `house` VALUES (100, 40, '765', 1, '2013-05-11 10:34:13', 7, '深圳', 134.00);
INSERT INTO `house` VALUES (101, 21, '638', 0, '2015-04-27 13:34:52', 4, '北京市', 193.00);
INSERT INTO `house` VALUES (102, 28, '040', 1, '2007-05-17 15:25:50', 6, '北京市', 111.00);
INSERT INTO `house` VALUES (103, 48, '118', 0, '2016-01-25 15:04:53', 4, '上海市', 169.00);
INSERT INTO `house` VALUES (104, 40, '653', 1, '2005-07-21 13:18:31', 5, '上海市', 190.00);
INSERT INTO `house` VALUES (105, 36, '165', 0, '2005-04-03 15:19:45', 1, '广州市', 94.00);
INSERT INTO `house` VALUES (106, 17, '799', 0, '2002-03-27 12:56:25', 4, '成都市', 92.00);
INSERT INTO `house` VALUES (107, 24, '363', 0, '2018-06-18 15:23:55', 6, '北京市', 143.00);
INSERT INTO `house` VALUES (108, 21, '252', 1, '2015-09-10 15:14:19', 3, '深圳', 131.00);
INSERT INTO `house` VALUES (109, 19, '231', 1, '2017-07-11 17:31:08', 5, '成都市', 90.00);
INSERT INTO `house` VALUES (110, 46, '332', 1, '2018-09-08 12:20:39', 4, '上海市', 149.00);
INSERT INTO `house` VALUES (111, 3, '321', 0, '2021-04-06 13:33:17', 4, '上海市', 190.00);

-- ----------------------------
-- Table structure for owner
-- ----------------------------
DROP TABLE IF EXISTS `owner`;
CREATE TABLE `owner`  (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tel` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` int(11) NULL DEFAULT NULL,
  `identity` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',
  `house_id` int(11) NULL DEFAULT NULL COMMENT '房屋外键',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `password` varchar(28) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 201 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of owner
-- ----------------------------
INSERT INTO `owner` VALUES (1, '王宇宁', '18909492860', 1, '530025199211265111', 278, '成都市', '12345');
INSERT INTO `owner` VALUES (2, '余岚', '15676763185', 0, '99731820681109571x', 186, '北京市', '12345');
INSERT INTO `owner` VALUES (3, '何璐', '18026035160', 0, '724730204607103305', 166, '成都市', '12345');
INSERT INTO `owner` VALUES (4, '林杰宏', '15238862636', 0, '935126206310211347', 51, '北京市', '12345');
INSERT INTO `owner` VALUES (5, '郭秀英', '14398054951', 0, '470170192304308360', 24, '北京市', '12345');
INSERT INTO `owner` VALUES (6, '孟云熙', '17298710129', 1, '69682220451230327X', 224, '成都市', '12345');
INSERT INTO `owner` VALUES (7, '徐杰宏', '15871550968', 0, '61341019031229378x', 99, '成都市', '12345');
INSERT INTO `owner` VALUES (8, '尹睿', '15916865881', 0, '425197200802017675', 61, '中山', '12345');
INSERT INTO `owner` VALUES (9, '宋云熙', '17235553213', 1, '182415202610315952', 20, '北京市', '12345');
INSERT INTO `owner` VALUES (10, '周安琪', '14622840103', 0, '25235219881108471X', 197, '成都市', '12345');
INSERT INTO `owner` VALUES (11, '任云熙', '18666490352', 1, '609084201804133339', 121, '中山', '12345');
INSERT INTO `owner` VALUES (12, '周璐', '15243010131', 0, '392082204601055216', 277, '北京市', '12345');
INSERT INTO `owner` VALUES (13, '段睿', '18716166633', 1, '304043197111313860', 30, '成都市', '12345');
INSERT INTO `owner` VALUES (14, '马震南', '17027234357', 0, '519051194403109766', 144, '北京市', '12345');
INSERT INTO `owner` VALUES (15, '郑秀英', '15343148711', 0, '738893200211301077', 288, '成都市', '12345');
INSERT INTO `owner` VALUES (16, '邓震南', '19424759528', 1, '139302206103280406', 4, '北京市', '12345');
INSERT INTO `owner` VALUES (17, '姚秀英', '14687581157', 1, '945101190512034420', 191, '成都市', '12345');
INSERT INTO `owner` VALUES (18, '胡璐', '17197273206', 1, '110481198612016096', 289, '北京市', '12345');
INSERT INTO `owner` VALUES (19, '陆致远', '16985373629', 0, '748671206012248783', 216, '北京市', '12345');
INSERT INTO `owner` VALUES (20, '张杰宏', '18575750004', 1, '17162819241116402X', 251, '上海市', '12345');
INSERT INTO `owner` VALUES (21, '孙震南', '15981990052', 1, '890290194702314269', 88, '东莞', '12345');
INSERT INTO `owner` VALUES (22, '廖致远', '19797589741', 1, '649540202204131030', 261, '成都市', '12345');
INSERT INTO `owner` VALUES (23, '谢睿', '15332229502', 1, '930139205709085662', 86, '深圳', '12345');
INSERT INTO `owner` VALUES (24, '段安琪', '17472939391', 0, '474725200410091781', 193, '成都市', '12345');
INSERT INTO `owner` VALUES (25, '任睿', '17416984515', 0, '179183200709302090', 29, '北京市', '12345');
INSERT INTO `owner` VALUES (26, '方云熙', '14619923767', 0, '397790196807014281', 183, '广州市', '12345');
INSERT INTO `owner` VALUES (27, '郝安琪', '13063785682', 0, '277749190704049845', 24, '成都市', '12345');
INSERT INTO `owner` VALUES (28, '孙睿', '14852450531', 1, '248531191309050762', 208, '深圳', '12345');
INSERT INTO `owner` VALUES (29, '谢睿', '14450340477', 1, '718825197910158494', 150, '上海市', '12345');
INSERT INTO `owner` VALUES (30, '马璐', '15302334164', 0, '111423203012074693', 21, '北京市', '12345');
INSERT INTO `owner` VALUES (31, '丁云熙', '15390297367', 0, '311780206010307529', 45, '东莞', '12345');
INSERT INTO `owner` VALUES (32, '马子异', '13830490573', 0, '574267190711093466', 71, '成都市', '12345');
INSERT INTO `owner` VALUES (33, '马璐', '18217531087', 0, '816951196201305459', 126, '广州市', '12345');
INSERT INTO `owner` VALUES (34, '熊子韬', '19350252643', 0, '520247191506216738', 153, '中山', '12345');
INSERT INTO `owner` VALUES (35, '黎秀英', '17585470368', 0, '241330209111052819', 286, '北京市', '12345');
INSERT INTO `owner` VALUES (36, '罗宇宁', '17923992718', 1, '701282209103309570', 87, '东莞', '12345');
INSERT INTO `owner` VALUES (37, '叶子韬', '16470575074', 0, '994752195601042218', 64, '深圳', '12345');
INSERT INTO `owner` VALUES (38, '袁秀英', '15864457489', 1, '41485819930722619X', 149, '东莞', '12345');
INSERT INTO `owner` VALUES (39, '潘詩涵', '16326452700', 0, '437459190512027712', 107, '成都市', '12345');
INSERT INTO `owner` VALUES (40, '刘杰宏', '16610748588', 1, '44525219830811755x', 248, '北京市', '12345');
INSERT INTO `owner` VALUES (41, '苏杰宏', '17044605502', 1, '436910191712311072', 34, '东莞', '12345');
INSERT INTO `owner` VALUES (42, '曾宇宁', '13968928052', 1, '444811200012310236', 52, '成都市', '12345');
INSERT INTO `owner` VALUES (43, '韦宇宁', '14315241756', 0, '941796196610138336', 19, '中山', '12345');
INSERT INTO `owner` VALUES (44, '汪晓明', '17295640245', 0, '45178819771125813x', 103, '成都市', '12345');
INSERT INTO `owner` VALUES (45, '谭震南', '15541276689', 1, '552220207510053814', 92, '成都市', '12345');
INSERT INTO `owner` VALUES (46, '崔子异', '15499670913', 0, '289455204611301689', 84, '东莞', '12345');
INSERT INTO `owner` VALUES (47, '唐岚', '15984770543', 0, '883614207903314461', 176, '深圳', '12345');
INSERT INTO `owner` VALUES (48, '余秀英', '19704046570', 0, '78719120011231460X', 168, '北京市', '12345');
INSERT INTO `owner` VALUES (49, '韦云熙', '14774832437', 1, '69766520550731723x', 179, '东莞', '12345');
INSERT INTO `owner` VALUES (50, '邱震南', '14349291017', 1, '215682196711096577', 263, '北京市', '12345');
INSERT INTO `owner` VALUES (51, '严宇宁', '16275930278', 1, '149045199412315744', 179, '成都市', '12345');
INSERT INTO `owner` VALUES (52, '韦子韬', '19429777493', 1, '93651319460310709x', 169, '成都市', '12345');
INSERT INTO `owner` VALUES (53, '郝震南', '14877589921', 0, '217762207210301911', 142, '北京市', '12345');
INSERT INTO `owner` VALUES (54, '谭詩涵', '15638042544', 0, '194309208206313861', 84, '成都市', '12345');
INSERT INTO `owner` VALUES (55, '熊子异', '13289720453', 1, '919701209712042139', 68, '成都市', '12345');
INSERT INTO `owner` VALUES (56, '杜杰宏', '14970395566', 1, '516428197308058454', 234, '成都市', '12345');
INSERT INTO `owner` VALUES (57, '常岚', '15450276611', 1, '897938199104075747', 28, '上海市', '12345');
INSERT INTO `owner` VALUES (58, '萧詩涵', '18728191877', 1, '850182201508317463', 4, '北京市', '12345');
INSERT INTO `owner` VALUES (59, '罗岚', '14503489286', 0, '550966204211266944', 27, '成都市', '12345');
INSERT INTO `owner` VALUES (60, '赵子韬', '19516515274', 1, '55582520061101134x', 62, '成都市', '12345');
INSERT INTO `owner` VALUES (61, '段杰宏', '19724302613', 1, '77391319300431165x', 85, '成都市', '12345');
INSERT INTO `owner` VALUES (62, '朱岚', '13962740142', 0, '645398202411085475', 114, '成都市', '12345');
INSERT INTO `owner` VALUES (63, '顾子韬', '13080100837', 0, '346006192508315043', 156, '成都市', '12345');
INSERT INTO `owner` VALUES (64, '雷子韬', '16385679327', 0, '47709819270901752X', 197, '北京市', '12345');
INSERT INTO `owner` VALUES (65, '陶安琪', '14709814779', 1, '621912198101316538', 150, '深圳', '12345');
INSERT INTO `owner` VALUES (66, '钟晓明', '17222827756', 0, '597743190007126217', 254, '东莞', '12345');
INSERT INTO `owner` VALUES (67, '汪安琪', '13228419713', 0, '102340208910301133', 3, '成都市', '12345');
INSERT INTO `owner` VALUES (68, '秦子韬', '15720935651', 1, '778740202501183064', 247, '东莞', '12345');
INSERT INTO `owner` VALUES (69, '曾岚', '17116304360', 0, '247773207504316322', 99, '北京市', '12345');
INSERT INTO `owner` VALUES (70, '谢岚', '14521950212', 1, '786580204107318457', 175, '深圳', '12345');
INSERT INTO `owner` VALUES (71, '薛璐', '17102002618', 1, '605327192411122362', 161, '北京市', '12345');
INSERT INTO `owner` VALUES (72, '吴安琪', '18373869395', 0, '214123200003215197', 4, '成都市', '12345');
INSERT INTO `owner` VALUES (73, '姜震南', '18504254450', 1, '878657193403170753', 248, '北京市', '12345');
INSERT INTO `owner` VALUES (74, '沈璐', '18471541333', 0, '258403191812304649', 278, '中山', '12345');
INSERT INTO `owner` VALUES (75, '王宇宁', '19868826188', 0, '819518192711114303', 52, '北京市', '12345');
INSERT INTO `owner` VALUES (76, '丁岚', '17801526244', 1, '706671194705316606', 112, '成都市', '12345');
INSERT INTO `owner` VALUES (77, '谭致远', '15089725484', 0, '224674193606272250', 85, '上海市', '12345');
INSERT INTO `owner` VALUES (78, '孔子异', '19221576920', 1, '795657209601235825', 13, '东莞', '12345');
INSERT INTO `owner` VALUES (79, '徐云熙', '15744822705', 0, '703540206908246411', 16, '东莞', '12345');
INSERT INTO `owner` VALUES (80, '段杰宏', '14527359877', 1, '530478196610216820', 230, '成都市', '12345');
INSERT INTO `owner` VALUES (81, '邵杰宏', '13250422328', 1, '435276191007026053', 123, '北京市', '12345');
INSERT INTO `owner` VALUES (82, '夏子异', '17538925283', 1, '975051201910307222', 166, '成都市', '12345');
INSERT INTO `owner` VALUES (83, '龙岚', '17474285373', 0, '722623192403053596', 266, '成都市', '12345');
INSERT INTO `owner` VALUES (84, '邓杰宏', '17912052326', 0, '390157195810302225', 175, '成都市', '12345');
INSERT INTO `owner` VALUES (85, '孟秀英', '16751849624', 1, '366503207704051560', 4, '北京市', '12345');
INSERT INTO `owner` VALUES (86, '何璐', '13176890904', 0, '414532193811114521', 295, '北京市', '12345');
INSERT INTO `owner` VALUES (87, '侯詩涵', '19979461438', 0, '767574202212313767', 24, '东莞', '12345');
INSERT INTO `owner` VALUES (88, '魏秀英', '16665078463', 0, '881856209312227661', 142, '东莞', '12345');
INSERT INTO `owner` VALUES (89, '毛杰宏', '13424366771', 0, '84339520290203198X', 164, '中山', '12345');
INSERT INTO `owner` VALUES (90, '石云熙', '18676723639', 0, '51787719141031250X', 277, '成都市', '12345');
INSERT INTO `owner` VALUES (91, '范安琪', '13089603247', 0, '660200191810079682', 88, '深圳', '12345');
INSERT INTO `owner` VALUES (92, '胡秀英', '18443244387', 0, '384287195412032339', 50, '成都市', '12345');
INSERT INTO `owner` VALUES (93, '薛宇宁', '17846647758', 0, '324309191610020824', 10, '深圳', '12345');
INSERT INTO `owner` VALUES (94, '袁云熙', '15356475400', 0, '967204209911089391', 99, '北京市', '12345');
INSERT INTO `owner` VALUES (95, '黄致远', '19447176063', 0, '469420207010114516', 97, '北京市', '12345');
INSERT INTO `owner` VALUES (96, '韦岚', '18048010997', 1, '21499620401030454x', 145, '成都市', '12345');
INSERT INTO `owner` VALUES (97, '萧子异', '13199628587', 1, '266432194404027132', 30, '东莞', '12345');
INSERT INTO `owner` VALUES (98, '龙安琪', '15342638339', 1, '214289197509254825', 217, '北京市', '12345');
INSERT INTO `owner` VALUES (99, '邱宇宁', '16583301633', 1, '254493195007206443', 243, '北京市', '12345');
INSERT INTO `owner` VALUES (100, '崔致远', '15871448993', 0, '72917320341204279X', 269, '深圳', '12345');
INSERT INTO `owner` VALUES (101, '陶杰宏', '15073042411', 0, '739590206509314356', 10, '上海市', '12345');
INSERT INTO `owner` VALUES (102, '孔子韬', '15644249607', 1, '894571197512306629', 31, '东莞', '12345');
INSERT INTO `owner` VALUES (103, '胡詩涵', '19216534512', 1, '31871019601104967x', 207, '成都市', '12345');
INSERT INTO `owner` VALUES (104, '陈震南', '18001502618', 1, '74217920321112294X', 224, '北京市', '12345');
INSERT INTO `owner` VALUES (105, '唐安琪', '15757749934', 1, '625418201712214598', 22, '东莞', '12345');
INSERT INTO `owner` VALUES (106, '毛璐', '16435617086', 0, '311837199512303537', 71, '广州市', '12345');
INSERT INTO `owner` VALUES (107, '高宇宁', '19850635495', 0, '97619019910822612X', 144, '中山', '12345');
INSERT INTO `owner` VALUES (108, '袁杰宏', '18946497719', 0, '224310199403308497', 208, '成都市', '12345');
INSERT INTO `owner` VALUES (109, '魏子异', '18615266972', 0, '871525195002262422', 61, '东莞', '12345');
INSERT INTO `owner` VALUES (110, '龚致远', '19342842514', 1, '338513192701053271', 135, '北京市', '12345');
INSERT INTO `owner` VALUES (111, '孟杰宏', '17244456769', 0, '252036191604310504', 180, '成都市', '12345');
INSERT INTO `owner` VALUES (112, '杨秀英', '19051208177', 0, '57388819211202854X', 57, '东莞', '12345');
INSERT INTO `owner` VALUES (113, '潘睿', '13644690572', 0, '954486194910254291', 252, '成都市', '12345');
INSERT INTO `owner` VALUES (114, '姚晓明', '15890935419', 0, '520040197410177877', 234, '东莞', '12345');
INSERT INTO `owner` VALUES (115, '邱安琪', '17942807816', 0, '44769120651203476X', 18, '成都市', '12345');
INSERT INTO `owner` VALUES (116, '钟安琪', '13376036357', 1, '977694195611305074', 73, '东莞', '12345');
INSERT INTO `owner` VALUES (117, '曹宇宁', '18829522912', 0, '270698197310311494', 24, '上海市', '12345');
INSERT INTO `owner` VALUES (118, '黄震南', '19468023558', 1, '465153197002029431', 143, '东莞', '12345');
INSERT INTO `owner` VALUES (119, '尹子异', '14686422040', 1, '266577208011315004', 30, '北京市', '12345');
INSERT INTO `owner` VALUES (120, '方秀英', '17931598719', 1, '671358204401186198', 243, '深圳', '12345');
INSERT INTO `owner` VALUES (121, '莫晓明', '17858051806', 0, '53498320870713386x', 41, '成都市', '12345');
INSERT INTO `owner` VALUES (122, '程睿', '18584280550', 1, '12647119451031232x', 274, '成都市', '12345');
INSERT INTO `owner` VALUES (123, '邱睿', '15626165348', 1, '148199209201307644', 212, '深圳', '12345');
INSERT INTO `owner` VALUES (124, '谢岚', '15355441699', 1, '332156209911072150', 48, '东莞', '12345');
INSERT INTO `owner` VALUES (125, '孙致远', '17430377114', 1, '585525193812304544', 259, '北京市', '12345');
INSERT INTO `owner` VALUES (126, '戴子异', '17529547639', 1, '234621205212078777', 197, '东莞', '12345');
INSERT INTO `owner` VALUES (127, '胡詩涵', '16601819996', 1, '528505206708208223', 172, '东莞', '12345');
INSERT INTO `owner` VALUES (128, '范子异', '13975058241', 0, '902345199512027283', 242, '广州市', '12345');
INSERT INTO `owner` VALUES (129, '韦致远', '16698797889', 1, '582262196110312490', 56, '成都市', '12345');
INSERT INTO `owner` VALUES (130, '戴杰宏', '13015696264', 0, '297392201904303707', 272, '北京市', '12345');
INSERT INTO `owner` VALUES (131, '常睿', '17443890352', 1, '370676191211311155', 138, '成都市', '12345');
INSERT INTO `owner` VALUES (132, '林子异', '14211672585', 1, '18055319281226573X', 197, '东莞', '12345');
INSERT INTO `owner` VALUES (133, '夏子韬', '19035417966', 1, '449730192607058088', 241, '成都市', '12345');
INSERT INTO `owner` VALUES (134, '袁云熙', '15599480134', 1, '743858191910244558', 291, '东莞', '12345');
INSERT INTO `owner` VALUES (135, '罗睿', '14025554519', 0, '930019190604055273', 46, '中山', '12345');
INSERT INTO `owner` VALUES (136, '林岚', '16116593432', 0, '770336201610311438', 23, '北京市', '12345');
INSERT INTO `owner` VALUES (137, '胡詩涵', '16986176249', 0, '359554207608068177', 159, '北京市', '12345');
INSERT INTO `owner` VALUES (138, '金宇宁', '15546412242', 0, '666641192810227347', 195, '成都市', '12345');
INSERT INTO `owner` VALUES (139, '赵岚', '16229285973', 1, '619610197407051089', 78, '成都市', '12345');
INSERT INTO `owner` VALUES (140, '丁子异', '19244643124', 0, '573531202609074560', 262, '东莞', '12345');
INSERT INTO `owner` VALUES (141, '胡詩涵', '13740353988', 1, '829399202012095261', 269, '北京市', '12345');
INSERT INTO `owner` VALUES (142, '袁安琪', '15620834988', 1, '910017195511317549', 12, '成都市', '12345');
INSERT INTO `owner` VALUES (143, '龙睿', '17256249761', 1, '670230207409301209', 45, '深圳', '12345');
INSERT INTO `owner` VALUES (144, '范詩涵', '18452489180', 0, '35779420961128316X', 46, '中山', '12345');
INSERT INTO `owner` VALUES (145, '韦詩涵', '17900714929', 1, '772586208003319235', 22, '成都市', '12345');
INSERT INTO `owner` VALUES (146, '曾詩涵', '19692431759', 1, '662263201309249555', 8, '成都市', '12345');
INSERT INTO `owner` VALUES (147, '叶震南', '17013579164', 1, '109539203106025560', 204, '成都市', '12345');
INSERT INTO `owner` VALUES (148, '郑云熙', '15273651012', 0, '381698190301202190', 115, '东莞', '12345');
INSERT INTO `owner` VALUES (149, '雷詩涵', '14058428975', 0, '550773190312311684', 247, '东莞', '12345');
INSERT INTO `owner` VALUES (150, '周睿', '13851712878', 1, '151983194112317257', 76, '成都市', '12345');
INSERT INTO `owner` VALUES (151, '石杰宏', '13109013593', 0, '796016197912167875', 223, '北京市', '12345');
INSERT INTO `owner` VALUES (152, '罗岚', '17816959111', 1, '85441220161015213x', 98, '成都市', '12345');
INSERT INTO `owner` VALUES (153, '阎睿', '14557839943', 1, '41431420240301004X', 296, '东莞', '12345');
INSERT INTO `owner` VALUES (154, '阎詩涵', '17161436819', 0, '877446194107047630', 122, '深圳', '12345');
INSERT INTO `owner` VALUES (155, '方杰宏', '17474165726', 0, '759746197206309070', 52, '东莞', '12345');
INSERT INTO `owner` VALUES (156, '许子异', '16533625875', 1, '840841193010017363', 263, '东莞', '12345');
INSERT INTO `owner` VALUES (157, '任震南', '15445771200', 1, '941218204511078597', 76, '东莞', '12345');
INSERT INTO `owner` VALUES (158, '袁子异', '14038724686', 1, '219628192310029290', 263, '成都市', '12345');
INSERT INTO `owner` VALUES (159, '高宇宁', '19388310986', 0, '807565205510113054', 27, '成都市', '12345');
INSERT INTO `owner` VALUES (160, '郝睿', '14712239293', 1, '73117820450631598x', 134, '成都市', '12345');
INSERT INTO `owner` VALUES (161, '李子异', '13908885669', 1, '206698192910253767', 108, '中山', '12345');
INSERT INTO `owner` VALUES (162, '贾睿', '17634158790', 1, '191904197612026520', 22, '成都市', '12345');
INSERT INTO `owner` VALUES (163, '邓宇宁', '13556951783', 1, '591819193706029451', 125, '成都市', '12345');
INSERT INTO `owner` VALUES (164, '毛云熙', '13126392621', 1, '981165206210121978', 104, '成都市', '12345');
INSERT INTO `owner` VALUES (165, '韦宇宁', '18974091967', 1, '544435194203315423', 184, '成都市', '12345');
INSERT INTO `owner` VALUES (166, '韦嘉伦', '19306725533', 1, '29965720380131653X', 140, '成都市', '12345');
INSERT INTO `owner` VALUES (167, '龙致远', '17177388142', 1, '730575191512301001', 272, '东莞', '12345');
INSERT INTO `owner` VALUES (168, '范云熙', '15288476394', 1, '94389720931224219X', 25, '北京市', '12345');
INSERT INTO `owner` VALUES (169, '陶致远', '17813970805', 0, '918798206911038807', 179, '成都市', '12345');
INSERT INTO `owner` VALUES (170, '罗詩涵', '17539749787', 0, '977447200007310422', 150, '东莞', '12345');
INSERT INTO `owner` VALUES (171, '许晓明', '18893382536', 0, '274286209611088148', 119, '东莞', '12345');
INSERT INTO `owner` VALUES (172, '朱云熙', '16863536914', 1, '68722120850822787x', 265, '北京市', '12345');
INSERT INTO `owner` VALUES (173, '戴宇宁', '19934616476', 0, '515404204906257516', 43, '中山', '12345');
INSERT INTO `owner` VALUES (174, '郭晓明', '16385089663', 0, '634493203406107582', 42, '北京市', '12345');
INSERT INTO `owner` VALUES (175, '黎震南', '16082035895', 1, '813898207411302734', 55, '北京市', '12345');
INSERT INTO `owner` VALUES (176, '曾杰宏', '16433889678', 1, '333434195204109468', 259, '成都市', '12345');
INSERT INTO `owner` VALUES (177, '史秀英', '15090609995', 0, '391748200807058937', 256, '东莞', '12345');
INSERT INTO `owner` VALUES (178, '黄詩涵', '18764184552', 0, '903666195312053543', 282, '成都市', '12345');
INSERT INTO `owner` VALUES (179, '曹詩涵', '13790370564', 1, '349490206006271900', 238, '深圳', '12345');
INSERT INTO `owner` VALUES (180, '陈子韬', '16819904552', 0, '455422195407298376', 115, '北京市', '12345');
INSERT INTO `owner` VALUES (181, '贾岚', '15290061569', 0, '824596190204175261', 149, '中山', '12345');
INSERT INTO `owner` VALUES (182, '严岚', '14470291620', 0, '419715204811077397', 115, '东莞', '12345');
INSERT INTO `owner` VALUES (183, '马子异', '13363001290', 1, '460606195610039754', 300, '北京市', '12345');
INSERT INTO `owner` VALUES (184, '刘晓明', '16425998347', 1, '386895203010309930', 261, '成都市', '12345');
INSERT INTO `owner` VALUES (185, '常璐', '13033680227', 0, '55082220331227959x', 295, '上海市', '12345');
INSERT INTO `owner` VALUES (186, '罗震南', '18327912104', 0, '25372119921222822x', 41, '成都市', '12345');
INSERT INTO `owner` VALUES (187, '傅秀英', '15117987861', 1, '792548198412196624', 22, '上海市', '12345');
INSERT INTO `owner` VALUES (188, '曾云熙', '16317525685', 1, '178378203511309107', 13, '成都市', '12345');
INSERT INTO `owner` VALUES (189, '阎震南', '14196159871', 0, '346367204112115451', 188, '成都市', '12345');
INSERT INTO `owner` VALUES (190, '曾岚', '17655971563', 0, '911697197411085550', 126, '东莞', '12345');
INSERT INTO `owner` VALUES (191, '潘晓明', '19308575432', 1, '736584207812016898', 280, '成都市', '12345');
INSERT INTO `owner` VALUES (192, '蒋安琪', '17377566267', 0, '814711209302059715', 233, '东莞', '12345');
INSERT INTO `owner` VALUES (193, '邱震南', '16555299143', 0, '972741203311017887', 285, '东莞', '12345');
INSERT INTO `owner` VALUES (194, '何云熙', '18671790242', 0, '600746200411275816', 212, '北京市', '12345');
INSERT INTO `owner` VALUES (195, '程嘉伦', '14262414014', 1, '433592206712317532', 235, '北京市', '12345');
INSERT INTO `owner` VALUES (196, '孟云熙', '14276140983', 0, '11033320211110588X', 119, '中山', '12345');
INSERT INTO `owner` VALUES (197, '崔安琪', '17210067295', 1, '352310203310288592', 168, '成都市', '12345');
INSERT INTO `owner` VALUES (198, '龚秀英', '17921817570', 1, '498483203011313862', 166, '成都市', '12345');
INSERT INTO `owner` VALUES (199, '潘睿', '17927369008', 1, '567898204805074714', 73, '成都市', '12345');
INSERT INTO `owner` VALUES (200, '贾致远', '19942921185', 0, '143234202408044073', 107, '深圳', '12345');

-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `numbers` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车位号',
  `status` int(11) NULL DEFAULT NULL COMMENT '状态 1使用 0未使用',
  `owner_id` int(11) NULL DEFAULT NULL COMMENT '业主编号',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 201 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of parking
-- ----------------------------
INSERT INTO `parking` VALUES (1, 'D4-660', 1, 180, '中国中山乐丰六路427号华润大厦10室');
INSERT INTO `parking` VALUES (2, 'C1-579', 1, 92, '中国东莞东泰五街569号24室');
INSERT INTO `parking` VALUES (3, 'B5-882', 1, 158, '中国广州市白云区小坪东路484号24栋');
INSERT INTO `parking` VALUES (4, 'B5-921', 0, 2, '中国北京市東城区東直門內大街933号华润大厦15室');
INSERT INTO `parking` VALUES (5, 'D3-453', 0, 181, '中国成都市锦江区红星路三段696号43栋');
INSERT INTO `parking` VALUES (6, 'E3-669', 1, 148, '中国东莞东泰五街822号17楼');
INSERT INTO `parking` VALUES (7, 'B5-267', 1, 33, '中国北京市朝阳区三里屯路166号25栋');
INSERT INTO `parking` VALUES (8, 'C3-427', 1, 115, '中国上海市浦东新区橄榄路308号40号楼');
INSERT INTO `parking` VALUES (9, 'D2-037', 0, 121, '中国北京市東城区東直門內大街510号华润大厦30室');
INSERT INTO `parking` VALUES (10, 'B4-981', 0, 107, '中国北京市朝阳区三里屯路747号31栋');
INSERT INTO `parking` VALUES (11, 'A2-192', 0, 192, '中国上海市浦东新区橄榄路555号华润大厦44室');
INSERT INTO `parking` VALUES (12, 'E5-719', 0, 143, '中国上海市浦东新区健祥路194号27栋');
INSERT INTO `parking` VALUES (13, 'A3-118', 0, 110, '中国东莞珊瑚路745号36楼');
INSERT INTO `parking` VALUES (14, 'A5-621', 1, 53, '中国深圳龙岗区学园一巷613号19楼');
INSERT INTO `parking` VALUES (15, 'E5-362', 0, 6, '中国深圳罗湖区田贝一路465号华润大厦50室');
INSERT INTO `parking` VALUES (16, 'E1-943', 0, 43, '中国深圳福田区深南大道559号48楼');
INSERT INTO `parking` VALUES (17, 'E4-164', 1, 34, '中国北京市海淀区清河中街68号296号26室');
INSERT INTO `parking` VALUES (18, 'C5-610', 0, 126, '中国深圳罗湖区田贝一路929号32室');
INSERT INTO `parking` VALUES (19, 'D3-511', 1, 15, '中国广州市天河区天河路49号22楼');
INSERT INTO `parking` VALUES (20, 'E3-118', 1, 173, '中国北京市西城区复兴门内大街26号27楼');
INSERT INTO `parking` VALUES (21, 'B3-871', 1, 33, '中国广州市海珠区江南西路26号45号楼');
INSERT INTO `parking` VALUES (22, 'C4-173', 0, 190, '中国上海市浦东新区橄榄路816号华润大厦38室');
INSERT INTO `parking` VALUES (23, 'C4-773', 1, 23, '中国北京市東城区東直門內大街721号14楼');
INSERT INTO `parking` VALUES (24, 'A1-615', 0, 136, '中国北京市东城区东单王府井东街428号23楼');
INSERT INTO `parking` VALUES (25, 'B2-500', 1, 38, '中国北京市海淀区清河中街68号584号9室');
INSERT INTO `parking` VALUES (26, 'A3-357', 1, 127, '中国深圳福田区深南大道110号4室');
INSERT INTO `parking` VALUES (27, 'C3-897', 0, 182, '中国成都市锦江区红星路三段655号36号楼');
INSERT INTO `parking` VALUES (28, 'C4-891', 0, 146, '中国上海市徐汇区虹桥路518号华润大厦46室');
INSERT INTO `parking` VALUES (29, 'C2-364', 0, 93, '中国深圳龙岗区布吉镇西环路999号17栋');
INSERT INTO `parking` VALUES (30, 'B3-008', 1, 187, '中国广州市越秀区中山二路715号38栋');
INSERT INTO `parking` VALUES (31, 'C4-763', 1, 196, '中国北京市东城区东单王府井东街325号37室');
INSERT INTO `parking` VALUES (32, 'B2-615', 0, 7, '中国深圳福田区景田东一街398号36室');
INSERT INTO `parking` VALUES (33, 'C2-194', 0, 144, '中国北京市房山区岳琉路361号11栋');
INSERT INTO `parking` VALUES (34, 'D3-972', 0, 96, '中国东莞坑美十五巷184号23室');
INSERT INTO `parking` VALUES (35, 'E4-890', 1, 59, '中国广州市天河区天河路673号20号楼');
INSERT INTO `parking` VALUES (36, 'C4-032', 1, 125, '中国深圳罗湖区清水河一路311号13楼');
INSERT INTO `parking` VALUES (37, 'D2-962', 0, 29, '中国成都市锦江区人民南路四段37号38号楼');
INSERT INTO `parking` VALUES (38, 'B5-664', 1, 36, '中国深圳龙岗区学园一巷103号47室');
INSERT INTO `parking` VALUES (39, 'B4-576', 0, 54, '中国北京市海淀区清河中街68号549号48室');
INSERT INTO `parking` VALUES (40, 'C4-699', 0, 94, '中国北京市朝阳区三里屯路596号14号楼');
INSERT INTO `parking` VALUES (41, 'A1-721', 0, 93, '中国中山乐丰六路432号10室');
INSERT INTO `parking` VALUES (42, 'A4-987', 0, 149, '中国北京市西城区西長安街60号21室');
INSERT INTO `parking` VALUES (43, 'C3-632', 1, 61, '中国深圳罗湖区蔡屋围深南东路424号50栋');
INSERT INTO `parking` VALUES (44, 'E3-165', 1, 34, '中国深圳罗湖区蔡屋围深南东路973号3栋');
INSERT INTO `parking` VALUES (45, 'A1-154', 1, 40, '中国上海市黄浦区淮海中路347号9室');
INSERT INTO `parking` VALUES (46, 'C1-304', 0, 64, '中国中山紫马岭商圈中山五路31号5楼');
INSERT INTO `parking` VALUES (47, 'A2-215', 0, 165, '中国上海市黄浦区淮海中路619号华润大厦4室');
INSERT INTO `parking` VALUES (48, 'E2-611', 1, 134, '中国上海市徐汇区虹桥路336号华润大厦22室');
INSERT INTO `parking` VALUES (49, 'A5-746', 0, 165, '中国中山紫马岭商圈中山五路560号华润大厦10室');
INSERT INTO `parking` VALUES (50, 'C2-939', 1, 192, '中国东莞坑美十五巷590号15楼');
INSERT INTO `parking` VALUES (51, 'D5-794', 0, 57, '中国北京市海淀区清河中街68号138号华润大厦10室');
INSERT INTO `parking` VALUES (52, 'D5-975', 1, 77, '中国深圳罗湖区田贝一路363号32楼');
INSERT INTO `parking` VALUES (53, 'B4-195', 0, 147, '中国北京市延庆区028县道262号24栋');
INSERT INTO `parking` VALUES (54, 'A3-424', 1, 165, '中国北京市东城区东单王府井东街918号49号楼');
INSERT INTO `parking` VALUES (55, 'D3-177', 1, 137, '中国成都市成华区二仙桥东三路767号华润大厦50室');
INSERT INTO `parking` VALUES (56, 'E5-540', 0, 183, '中国深圳福田区景田东一街494号华润大厦16室');
INSERT INTO `parking` VALUES (57, 'C5-312', 1, 39, '中国深圳龙岗区布吉镇西环路52号28号楼');
INSERT INTO `parking` VALUES (58, 'B5-508', 0, 54, '中国东莞坑美十五巷540号17栋');
INSERT INTO `parking` VALUES (59, 'D4-177', 1, 141, '中国成都市成华区二仙桥东三路815号28室');
INSERT INTO `parking` VALUES (60, 'E2-605', 0, 108, '中国深圳罗湖区田贝一路768号7楼');
INSERT INTO `parking` VALUES (61, 'B2-079', 0, 199, '中国深圳罗湖区田贝一路693号17楼');
INSERT INTO `parking` VALUES (62, 'C3-530', 0, 184, '中国北京市延庆区028县道689号16楼');
INSERT INTO `parking` VALUES (63, 'C1-372', 0, 70, '中国广州市天河区天河路525号45号楼');
INSERT INTO `parking` VALUES (64, 'E1-633', 0, 177, '中国深圳龙岗区布吉镇西环路637号22号楼');
INSERT INTO `parking` VALUES (65, 'C5-165', 0, 2, '中国深圳罗湖区清水河一路916号35室');
INSERT INTO `parking` VALUES (66, 'D4-553', 1, 160, '中国东莞环区南街二巷219号33栋');
INSERT INTO `parking` VALUES (67, 'E2-190', 0, 14, '中国广州市天河区天河路181号华润大厦7室');
INSERT INTO `parking` VALUES (68, 'D1-434', 1, 162, '中国广州市海珠区江南西路56号21室');
INSERT INTO `parking` VALUES (69, 'E1-385', 0, 138, '中国上海市浦东新区健祥路824号32号楼');
INSERT INTO `parking` VALUES (70, 'E1-294', 1, 36, '中国中山乐丰六路998号26楼');
INSERT INTO `parking` VALUES (71, 'C5-689', 0, 30, '中国上海市黄浦区淮海中路663号35号楼');
INSERT INTO `parking` VALUES (72, 'E4-492', 1, 67, '中国广州市天河区天河路591号17楼');
INSERT INTO `parking` VALUES (73, 'E2-410', 1, 110, '中国深圳罗湖区清水河一路709号11室');
INSERT INTO `parking` VALUES (74, 'E1-216', 0, 179, '中国广州市白云区机场路棠苑街五巷911号38室');
INSERT INTO `parking` VALUES (75, 'D2-104', 1, 150, '中国北京市朝阳区三里屯路635号42室');
INSERT INTO `parking` VALUES (76, 'C3-071', 1, 188, '中国广州市海珠区江南西路334号18室');
INSERT INTO `parking` VALUES (77, 'C3-784', 0, 11, '中国广州市白云区小坪东路610号华润大厦32室');
INSERT INTO `parking` VALUES (78, 'D3-612', 0, 39, '中国深圳龙岗区布吉镇西环路806号22号楼');
INSERT INTO `parking` VALUES (79, 'E3-185', 1, 118, '中国成都市成华区玉双路6号579号华润大厦23室');
INSERT INTO `parking` VALUES (80, 'A4-866', 1, 156, '中国北京市房山区岳琉路572号5栋');
INSERT INTO `parking` VALUES (81, 'C3-553', 1, 93, '中国深圳罗湖区田贝一路292号华润大厦20室');
INSERT INTO `parking` VALUES (82, 'A5-229', 0, 137, '中国深圳罗湖区蔡屋围深南东路736号30楼');
INSERT INTO `parking` VALUES (83, 'C4-844', 0, 32, '中国深圳罗湖区田贝一路558号华润大厦8室');
INSERT INTO `parking` VALUES (84, 'C3-116', 1, 169, '中国北京市海淀区清河中街68号791号华润大厦9室');
INSERT INTO `parking` VALUES (85, 'B1-920', 1, 70, '中国中山天河区大信商圈大信南路961号华润大厦34室');
INSERT INTO `parking` VALUES (86, 'E4-344', 0, 101, '中国上海市闵行区宾川路340号11楼');
INSERT INTO `parking` VALUES (87, 'A4-036', 1, 77, '中国中山紫马岭商圈中山五路956号41室');
INSERT INTO `parking` VALUES (88, 'B2-111', 0, 12, '中国中山京华商圈华夏街819号华润大厦23室');
INSERT INTO `parking` VALUES (89, 'C2-617', 0, 186, '中国东莞珊瑚路321号15室');
INSERT INTO `parking` VALUES (90, 'D3-027', 0, 139, '中国上海市浦东新区健祥路640号9楼');
INSERT INTO `parking` VALUES (91, 'B4-960', 0, 8, '中国北京市西城区复兴门内大街544号3室');
INSERT INTO `parking` VALUES (92, 'A1-306', 0, 92, '中国成都市锦江区红星路三段20号30栋');
INSERT INTO `parking` VALUES (93, 'B1-085', 0, 109, '中国深圳罗湖区蔡屋围深南东路269号35栋');
INSERT INTO `parking` VALUES (94, 'C4-681', 0, 108, '中国中山天河区大信商圈大信南路662号华润大厦10室');
INSERT INTO `parking` VALUES (95, 'E2-263', 0, 74, '中国广州市天河区天河路845号8室');
INSERT INTO `parking` VALUES (96, 'E4-094', 0, 86, '中国中山天河区大信商圈大信南路924号1楼');
INSERT INTO `parking` VALUES (97, 'E3-439', 0, 140, '中国东莞珊瑚路931号18室');
INSERT INTO `parking` VALUES (98, 'D2-278', 1, 110, '中国深圳罗湖区清水河一路158号41栋');
INSERT INTO `parking` VALUES (99, 'B5-956', 0, 48, '中国北京市西城区复兴门内大街908号15号楼');
INSERT INTO `parking` VALUES (100, 'B2-863', 1, 32, '中国广州市白云区机场路棠苑街五巷249号29号楼');
INSERT INTO `parking` VALUES (101, 'D3-616', 1, 165, '中国深圳龙岗区布吉镇西环路636号32楼');
INSERT INTO `parking` VALUES (102, 'E2-982', 0, 16, '中国深圳龙岗区学园一巷296号42号楼');
INSERT INTO `parking` VALUES (103, 'B2-572', 0, 105, '中国上海市黄浦区淮海中路133号5室');
INSERT INTO `parking` VALUES (104, 'C2-405', 1, 3, '中国东莞东泰五街571号44号楼');
INSERT INTO `parking` VALUES (105, 'A3-763', 1, 112, '中国广州市天河区天河路297号2室');
INSERT INTO `parking` VALUES (106, 'A5-839', 0, 88, '中国上海市黄浦区淮海中路145号12号楼');
INSERT INTO `parking` VALUES (107, 'E2-022', 0, 180, '中国成都市锦江区红星路三段917号41楼');
INSERT INTO `parking` VALUES (108, 'D3-966', 1, 162, '中国北京市房山区岳琉路310号43楼');
INSERT INTO `parking` VALUES (109, 'A4-678', 0, 8, '中国北京市東城区東直門內大街823号3栋');
INSERT INTO `parking` VALUES (110, 'D3-540', 1, 2, '中国上海市浦东新区健祥路64号38栋');
INSERT INTO `parking` VALUES (111, 'A4-831', 1, 124, '中国北京市海淀区清河中街68号668号48楼');
INSERT INTO `parking` VALUES (112, 'C3-277', 0, 151, '中国深圳福田区景田东一街584号29栋');
INSERT INTO `parking` VALUES (113, 'C2-654', 1, 41, '中国成都市成华区玉双路6号959号26号楼');
INSERT INTO `parking` VALUES (114, 'E4-081', 1, 155, '中国中山紫马岭商圈中山五路40号47室');
INSERT INTO `parking` VALUES (115, 'C5-605', 1, 129, '中国东莞坑美十五巷716号6楼');
INSERT INTO `parking` VALUES (116, 'D1-959', 1, 106, '中国深圳罗湖区清水河一路167号华润大厦21室');
INSERT INTO `parking` VALUES (117, 'D4-739', 0, 139, '中国广州市天河区天河路24号50室');
INSERT INTO `parking` VALUES (118, 'C1-060', 0, 57, '中国北京市西城区复兴门内大街845号19楼');
INSERT INTO `parking` VALUES (119, 'B3-171', 0, 11, '中国上海市浦东新区健祥路624号39楼');
INSERT INTO `parking` VALUES (120, 'A4-076', 0, 59, '中国深圳福田区深南大道505号36栋');
INSERT INTO `parking` VALUES (121, 'C1-115', 1, 181, '中国北京市延庆区028县道946号22楼');
INSERT INTO `parking` VALUES (122, 'B3-046', 1, 153, '中国深圳福田区深南大道315号华润大厦37室');
INSERT INTO `parking` VALUES (123, 'D2-762', 1, 179, '中国成都市锦江区人民南路四段259号13楼');
INSERT INTO `parking` VALUES (124, 'D3-546', 1, 47, '中国北京市东城区东单王府井东街161号35栋');
INSERT INTO `parking` VALUES (125, 'A3-641', 0, 152, '中国中山紫马岭商圈中山五路697号华润大厦4室');
INSERT INTO `parking` VALUES (126, 'D3-245', 1, 106, '中国北京市朝阳区三里屯路45号44号楼');
INSERT INTO `parking` VALUES (127, 'C3-830', 0, 177, '中国北京市延庆区028县道977号15楼');
INSERT INTO `parking` VALUES (128, 'B4-575', 1, 135, '中国上海市黄浦区淮海中路861号27栋');
INSERT INTO `parking` VALUES (129, 'E4-590', 1, 147, '中国成都市成华区双庆路806号11栋');
INSERT INTO `parking` VALUES (130, 'D4-611', 0, 124, '中国上海市浦东新区健祥路644号41栋');
INSERT INTO `parking` VALUES (131, 'D1-588', 1, 48, '中国上海市闵行区宾川路969号49号楼');
INSERT INTO `parking` VALUES (132, 'D5-539', 1, 62, '中国成都市成华区双庆路431号8栋');
INSERT INTO `parking` VALUES (133, 'C1-822', 0, 44, '中国广州市白云区机场路棠苑街五巷65号华润大厦48室');
INSERT INTO `parking` VALUES (134, 'D4-932', 0, 87, '中国东莞珊瑚路756号华润大厦35室');
INSERT INTO `parking` VALUES (135, 'A4-965', 1, 139, '中国上海市浦东新区健祥路90号40号楼');
INSERT INTO `parking` VALUES (136, 'A3-992', 1, 41, '中国成都市锦江区人民南路四段273号43楼');
INSERT INTO `parking` VALUES (137, 'A4-456', 1, 132, '中国成都市成华区双庆路972号45室');
INSERT INTO `parking` VALUES (138, 'B3-841', 1, 198, '中国东莞珊瑚路596号12栋');
INSERT INTO `parking` VALUES (139, 'D2-420', 1, 108, '中国北京市西城区复兴门内大街136号19号楼');
INSERT INTO `parking` VALUES (140, 'A3-067', 0, 183, '中国深圳龙岗区布吉镇西环路341号37楼');
INSERT INTO `parking` VALUES (141, 'E3-498', 0, 197, '中国深圳福田区深南大道374号33室');
INSERT INTO `parking` VALUES (142, 'D1-265', 0, 186, '中国上海市黄浦区淮海中路242号13栋');
INSERT INTO `parking` VALUES (143, 'E4-514', 0, 32, '中国东莞环区南街二巷860号9室');
INSERT INTO `parking` VALUES (144, 'B3-899', 0, 45, '中国中山天河区大信商圈大信南路886号27栋');
INSERT INTO `parking` VALUES (145, 'D3-970', 1, 50, '中国成都市成华区双庆路267号34室');
INSERT INTO `parking` VALUES (146, 'A5-952', 1, 186, '中国东莞坑美十五巷973号华润大厦5室');
INSERT INTO `parking` VALUES (147, 'D1-077', 1, 44, '中国北京市朝阳区三里屯路505号华润大厦41室');
INSERT INTO `parking` VALUES (148, 'C4-337', 1, 52, '中国中山天河区大信商圈大信南路414号21号楼');
INSERT INTO `parking` VALUES (149, 'B3-816', 0, 98, '中国上海市闵行区宾川路82号32号楼');
INSERT INTO `parking` VALUES (150, 'A2-877', 1, 51, '中国北京市東城区東直門內大街329号16号楼');
INSERT INTO `parking` VALUES (151, 'C3-080', 1, 184, '中国广州市白云区机场路棠苑街五巷627号9栋');
INSERT INTO `parking` VALUES (152, 'A1-216', 0, 186, '中国成都市成华区双庆路819号6栋');
INSERT INTO `parking` VALUES (153, 'D1-942', 1, 117, '中国深圳罗湖区清水河一路243号华润大厦9室');
INSERT INTO `parking` VALUES (154, 'A5-867', 1, 150, '中国上海市徐汇区虹桥路314号华润大厦46室');
INSERT INTO `parking` VALUES (155, 'A2-758', 1, 173, '中国东莞东泰五街568号42楼');
INSERT INTO `parking` VALUES (156, 'B5-009', 1, 25, '中国北京市海淀区清河中街68号42号36楼');
INSERT INTO `parking` VALUES (157, 'E4-403', 1, 117, '中国东莞环区南街二巷696号31号楼');
INSERT INTO `parking` VALUES (158, 'C1-256', 1, 35, '中国东莞环区南街二巷336号44号楼');
INSERT INTO `parking` VALUES (159, 'C4-604', 1, 58, '中国东莞环区南街二巷473号13楼');
INSERT INTO `parking` VALUES (160, 'E1-673', 0, 65, '中国上海市闵行区宾川路802号21楼');
INSERT INTO `parking` VALUES (161, 'A3-754', 1, 66, '中国成都市锦江区人民南路四段200号3楼');
INSERT INTO `parking` VALUES (162, 'C2-768', 1, 166, '中国东莞珊瑚路830号21楼');
INSERT INTO `parking` VALUES (163, 'C3-409', 0, 153, '中国北京市延庆区028县道679号29栋');
INSERT INTO `parking` VALUES (164, 'D5-878', 1, 145, '中国深圳罗湖区蔡屋围深南东路629号21室');
INSERT INTO `parking` VALUES (165, 'D4-791', 1, 68, '中国北京市延庆区028县道327号5室');
INSERT INTO `parking` VALUES (166, 'D4-911', 1, 197, '中国上海市浦东新区橄榄路459号华润大厦40室');
INSERT INTO `parking` VALUES (167, 'D5-158', 1, 31, '中国东莞东泰五街756号华润大厦30室');
INSERT INTO `parking` VALUES (168, 'D1-408', 1, 155, '中国北京市房山区岳琉路558号25栋');
INSERT INTO `parking` VALUES (169, 'D1-202', 1, 149, '中国上海市浦东新区橄榄路546号35楼');
INSERT INTO `parking` VALUES (170, 'B2-986', 0, 32, '中国深圳龙岗区布吉镇西环路513号华润大厦6室');
INSERT INTO `parking` VALUES (171, 'E2-533', 0, 137, '中国北京市西城区复兴门内大街310号44楼');
INSERT INTO `parking` VALUES (172, 'D2-782', 1, 191, '中国北京市西城区复兴门内大街729号华润大厦48室');
INSERT INTO `parking` VALUES (173, 'C2-118', 0, 117, '中国中山天河区大信商圈大信南路622号44栋');
INSERT INTO `parking` VALUES (174, 'B2-550', 0, 188, '中国广州市白云区机场路棠苑街五巷56号30楼');
INSERT INTO `parking` VALUES (175, 'D2-355', 1, 32, '中国北京市朝阳区三里屯路352号35栋');
INSERT INTO `parking` VALUES (176, 'D4-940', 0, 47, '中国中山京华商圈华夏街160号34室');
INSERT INTO `parking` VALUES (177, 'A3-459', 1, 187, '中国北京市西城区复兴门内大街787号12楼');
INSERT INTO `parking` VALUES (178, 'E1-035', 0, 98, '中国中山京华商圈华夏街479号40楼');
INSERT INTO `parking` VALUES (179, 'B3-924', 0, 55, '中国东莞环区南街二巷607号6号楼');
INSERT INTO `parking` VALUES (180, 'E5-060', 0, 16, '中国北京市延庆区028县道406号5栋');
INSERT INTO `parking` VALUES (181, 'D5-980', 0, 144, '中国北京市房山区岳琉路97号华润大厦50室');
INSERT INTO `parking` VALUES (182, 'E1-530', 0, 13, '中国成都市成华区玉双路6号518号9楼');
INSERT INTO `parking` VALUES (183, 'C1-504', 1, 188, '中国北京市西城区西長安街478号华润大厦45室');
INSERT INTO `parking` VALUES (184, 'E1-402', 0, 195, '中国东莞珊瑚路379号38室');
INSERT INTO `parking` VALUES (185, 'C5-396', 1, 177, '中国东莞珊瑚路672号华润大厦7室');
INSERT INTO `parking` VALUES (186, 'B2-124', 0, 108, '中国深圳罗湖区田贝一路996号12楼');
INSERT INTO `parking` VALUES (187, 'C1-154', 0, 22, '中国深圳福田区深南大道66号42楼');
INSERT INTO `parking` VALUES (188, 'B5-305', 1, 99, '中国广州市白云区机场路棠苑街五巷914号43楼');
INSERT INTO `parking` VALUES (189, 'B2-039', 1, 60, '中国东莞东泰五街408号华润大厦39室');
INSERT INTO `parking` VALUES (190, 'D4-581', 1, 160, '中国北京市朝阳区三里屯路545号27楼');
INSERT INTO `parking` VALUES (191, 'C3-489', 1, 127, '中国上海市黄浦区淮海中路742号13室');
INSERT INTO `parking` VALUES (192, 'E5-568', 0, 90, '中国深圳福田区深南大道481号19室');
INSERT INTO `parking` VALUES (193, 'C4-522', 0, 151, '中国上海市徐汇区虹桥路740号6楼');
INSERT INTO `parking` VALUES (194, 'D5-870', 0, 170, '中国深圳福田区景田东一街220号45栋');
INSERT INTO `parking` VALUES (195, 'C3-692', 1, 65, '中国深圳福田区景田东一街627号28楼');
INSERT INTO `parking` VALUES (196, 'B4-891', 0, 54, '中国广州市白云区机场路棠苑街五巷295号华润大厦50室');
INSERT INTO `parking` VALUES (197, 'E1-390', 0, 113, '中国上海市浦东新区橄榄路179号7室');
INSERT INTO `parking` VALUES (198, 'B2-289', 1, 123, '中国广州市海珠区江南西路552号12栋');
INSERT INTO `parking` VALUES (199, 'C4-360', 0, 167, '中国北京市延庆区028县道291号10栋');
INSERT INTO `parking` VALUES (200, 'B1-195', 0, 190, '中国北京市西城区西長安街182号华润大厦9室');

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` int(11) NULL DEFAULT NULL COMMENT '类型 1物业管理员 2系统管理员 3业主',
  `owner_id` int(11) NULL DEFAULT NULL COMMENT '业主的ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `owner_id`(`owner_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 151 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES (1, 'admin', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (2, 'NewBoy', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (3, 'Ernest', '12345', 2, 76);
INSERT INTO `userinfo` VALUES (4, 'Dorothy', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (5, 'Daniel', '12345', 1, 86);
INSERT INTO `userinfo` VALUES (6, 'Norman', '12345', 3, 97);
INSERT INTO `userinfo` VALUES (7, 'Maria', '12345', 2, 90);
INSERT INTO `userinfo` VALUES (8, 'Aaron', '12345', 1, 54);
INSERT INTO `userinfo` VALUES (9, 'Nicole', '12345', 1, 166);
INSERT INTO `userinfo` VALUES (10, 'Rita', '12345', 1, 12);
INSERT INTO `userinfo` VALUES (11, 'Herbert', '12345', 2, 171);
INSERT INTO `userinfo` VALUES (12, 'Lucille', '12345', 1, 68);
INSERT INTO `userinfo` VALUES (13, 'Monica', '12345', 1, 98);
INSERT INTO `userinfo` VALUES (14, 'Danielle', '12345', 1, 45);
INSERT INTO `userinfo` VALUES (15, 'Kenneth', '12345', 3, 33);
INSERT INTO `userinfo` VALUES (16, 'Bernard', '12345', 2, 62);
INSERT INTO `userinfo` VALUES (17, 'Ruby', '12345', 3, 138);
INSERT INTO `userinfo` VALUES (18, 'Jesse', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (19, 'Joe', '12345', 2, 39);
INSERT INTO `userinfo` VALUES (20, 'Emma', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (21, 'Nicholas', '12345', 2, 63);
INSERT INTO `userinfo` VALUES (22, 'Henry', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (23, 'Diane', '12345', 2, 18);
INSERT INTO `userinfo` VALUES (24, 'Jonathan', '12345', 2, 11);
INSERT INTO `userinfo` VALUES (25, 'Matthew', '12345', 2, 44);
INSERT INTO `userinfo` VALUES (26, 'Ronald', '12345', 3, 61);
INSERT INTO `userinfo` VALUES (27, 'Josephine', '12345', 1, 84);
INSERT INTO `userinfo` VALUES (28, 'Peggy', '12345', 3, 118);
INSERT INTO `userinfo` VALUES (29, 'Linda', '12345', 3, 17);
INSERT INTO `userinfo` VALUES (30, 'Bradley', '12345', 2, 27);
INSERT INTO `userinfo` VALUES (31, 'Jeff', '12345', 1, 150);
INSERT INTO `userinfo` VALUES (32, 'Irene', '12345', 3, 66);
INSERT INTO `userinfo` VALUES (33, 'Doris', '12345', 2, 180);
INSERT INTO `userinfo` VALUES (34, 'Brenda', '12345', 1, 42);
INSERT INTO `userinfo` VALUES (35, 'Victoria', '12345', 2, 188);
INSERT INTO `userinfo` VALUES (36, 'Cynthia', '12345', 3, 40);
INSERT INTO `userinfo` VALUES (37, 'Julie', '12345', 2, 52);
INSERT INTO `userinfo` VALUES (38, 'Donna', '12345', 1, 25);
INSERT INTO `userinfo` VALUES (39, 'Kevin', '12345', 2, 192);
INSERT INTO `userinfo` VALUES (40, 'Bobby', '12345', 3, 167);
INSERT INTO `userinfo` VALUES (41, 'Stephanie', '12345', 2, 77);
INSERT INTO `userinfo` VALUES (42, 'Victor', '12345', 1, 53);
INSERT INTO `userinfo` VALUES (43, 'Sheila', '12345', 3, 120);
INSERT INTO `userinfo` VALUES (44, 'Marcus', '12345', 2, 148);
INSERT INTO `userinfo` VALUES (45, 'Kathleen', '12345', 2, 153);
INSERT INTO `userinfo` VALUES (46, 'Marvin', '12345', 3, 159);
INSERT INTO `userinfo` VALUES (47, 'Wanda', '12345', 2, 83);
INSERT INTO `userinfo` VALUES (48, 'Thelma', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (49, 'Allen', '12345', 2, 142);
INSERT INTO `userinfo` VALUES (50, 'Richard', '12345', 3, 112);
INSERT INTO `userinfo` VALUES (51, 'Debbie', '12345', 2, 2);
INSERT INTO `userinfo` VALUES (52, 'Mildred', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (53, 'Pamela', '12345', 2, 161);
INSERT INTO `userinfo` VALUES (54, 'Patrick', '12345', 2, 136);
INSERT INTO `userinfo` VALUES (55, 'Mary', '12345', 2, 88);
INSERT INTO `userinfo` VALUES (56, 'Catherine', '12345', 3, 110);
INSERT INTO `userinfo` VALUES (57, 'Earl', '12345', 2, 87);
INSERT INTO `userinfo` VALUES (58, 'Alan', '12345', 1, 96);
INSERT INTO `userinfo` VALUES (59, 'Rose', '12345', 3, 126);
INSERT INTO `userinfo` VALUES (60, 'Ricky', '12345', 3, 157);
INSERT INTO `userinfo` VALUES (61, 'Grace', '12345', 3, 46);
INSERT INTO `userinfo` VALUES (62, 'Dawn', '12345', 3, 37);
INSERT INTO `userinfo` VALUES (63, 'April', '12345', 1, 173);
INSERT INTO `userinfo` VALUES (64, 'Bryan', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (65, 'Gladys', '12345', 1, 109);
INSERT INTO `userinfo` VALUES (66, 'Mike', '12345', 1, 10);
INSERT INTO `userinfo` VALUES (67, 'Melissa', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (68, 'Jeffrey', '12345', 2, 22);
INSERT INTO `userinfo` VALUES (69, 'Howard', '12345', 2, 80);
INSERT INTO `userinfo` VALUES (70, 'Kimberly', '12345', 1, 48);
INSERT INTO `userinfo` VALUES (71, 'Donald', '12345', 2, 34);
INSERT INTO `userinfo` VALUES (72, 'Gregory', '12345', 3, 60);
INSERT INTO `userinfo` VALUES (73, 'Justin', '12345', 2, 129);
INSERT INTO `userinfo` VALUES (74, 'Randy', '12345', 1, 182);
INSERT INTO `userinfo` VALUES (75, 'Debra', '12345', 2, 140);
INSERT INTO `userinfo` VALUES (76, 'Katherine', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (77, 'Ellen', '12345', 2, 177);
INSERT INTO `userinfo` VALUES (78, 'Kelly', '12345', 2, 72);
INSERT INTO `userinfo` VALUES (79, 'Janet', '12345', 3, 92);
INSERT INTO `userinfo` VALUES (80, 'Margaret', '12345', 2, 29);
INSERT INTO `userinfo` VALUES (81, 'Luis', '12345', 2, 124);
INSERT INTO `userinfo` VALUES (82, 'Leonard', '12345', 2, 49);
INSERT INTO `userinfo` VALUES (83, 'Marjorie', '12345', 1, 19);
INSERT INTO `userinfo` VALUES (84, 'Nathan', '12345', 1, 164);
INSERT INTO `userinfo` VALUES (85, 'Betty', '12345', 2, 5);
INSERT INTO `userinfo` VALUES (86, 'Mark', '12345', 3, NULL);
INSERT INTO `userinfo` VALUES (87, 'Esther', '12345', 1, 78);
INSERT INTO `userinfo` VALUES (88, 'Judy', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (89, 'Edith', '12345', 3, 35);
INSERT INTO `userinfo` VALUES (90, 'Shirley', '12345', 2, 146);
INSERT INTO `userinfo` VALUES (91, 'Chad', '12345', 3, 106);
INSERT INTO `userinfo` VALUES (92, 'Ann', '12345', 3, 133);
INSERT INTO `userinfo` VALUES (93, 'Rhonda', '12345', 3, 73);
INSERT INTO `userinfo` VALUES (94, 'Willie', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (95, 'Douglas', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (96, 'Jason', '12345', 1, 8);
INSERT INTO `userinfo` VALUES (97, 'Anthony', '12345', 2, 89);
INSERT INTO `userinfo` VALUES (98, 'Susan', '12345', 2, 9);
INSERT INTO `userinfo` VALUES (99, 'Rachel', '12345', 3, 71);
INSERT INTO `userinfo` VALUES (100, 'Alfred', '12345', 2, 55);
INSERT INTO `userinfo` VALUES (101, 'Carlos', '12345', 3, 170);
INSERT INTO `userinfo` VALUES (102, 'Jamie', '12345', 2, 94);
INSERT INTO `userinfo` VALUES (103, 'Gloria', '12345', 3, 74);
INSERT INTO `userinfo` VALUES (104, 'Alexander', '12345', 2, 23);
INSERT INTO `userinfo` VALUES (105, 'Danny', '12345', 2, 31);
INSERT INTO `userinfo` VALUES (106, 'Kathy', '12345', 3, 119);
INSERT INTO `userinfo` VALUES (107, 'Micheal', '12345', 3, 38);
INSERT INTO `userinfo` VALUES (108, 'Phyllis', '12345', 3, 26);
INSERT INTO `userinfo` VALUES (109, 'William', '12345', 3, 189);
INSERT INTO `userinfo` VALUES (110, 'Helen', '12345', 2, 184);
INSERT INTO `userinfo` VALUES (111, 'Sharon', '12345', 1, 103);
INSERT INTO `userinfo` VALUES (112, 'Joel', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (113, 'Jerry', '12345', 1, 139);
INSERT INTO `userinfo` VALUES (114, 'Amanda', '12345', 3, 6);
INSERT INTO `userinfo` VALUES (115, 'Alice', '12345', 3, 111);
INSERT INTO `userinfo` VALUES (116, 'Anita', '12345', 1, 132);
INSERT INTO `userinfo` VALUES (117, 'Steve', '12345', 2, 20);
INSERT INTO `userinfo` VALUES (118, 'Manuel', '12345', 2, 7);
INSERT INTO `userinfo` VALUES (119, 'Sandra', '12345', 1, 108);
INSERT INTO `userinfo` VALUES (120, 'Louis', '12345', 2, 101);
INSERT INTO `userinfo` VALUES (121, 'Ryan', '12345', 2, 13);
INSERT INTO `userinfo` VALUES (122, 'Deborah', '12345', 2, NULL);
INSERT INTO `userinfo` VALUES (123, 'Scott', '12345', 3, 169);
INSERT INTO `userinfo` VALUES (124, 'Tammy', '12345', 3, NULL);
INSERT INTO `userinfo` VALUES (125, 'Joyce', '12345', 2, 81);
INSERT INTO `userinfo` VALUES (126, 'Walter', '12345', 3, 64);
INSERT INTO `userinfo` VALUES (127, 'Arthur', '12345', 2, 151);
INSERT INTO `userinfo` VALUES (128, 'Juanita', '12345', 3, 122);
INSERT INTO `userinfo` VALUES (129, 'Roger', '12345', 2, 176);
INSERT INTO `userinfo` VALUES (130, 'Carolyn', '12345', 2, 24);
INSERT INTO `userinfo` VALUES (131, 'Leslie', '12345', 2, 163);
INSERT INTO `userinfo` VALUES (132, 'Eugene', '12345', 1, 143);
INSERT INTO `userinfo` VALUES (133, 'Johnny', '12345', 3, 174);
INSERT INTO `userinfo` VALUES (134, 'Kim', '12345', 2, 59);
INSERT INTO `userinfo` VALUES (135, 'Robert', '12345', 3, NULL);
INSERT INTO `userinfo` VALUES (136, 'Patricia', '12345', 1, 82);
INSERT INTO `userinfo` VALUES (137, 'Gary', '12345', 2, 158);
INSERT INTO `userinfo` VALUES (138, 'Carol', '12345', 2, 65);
INSERT INTO `userinfo` VALUES (139, 'Leroy', '12345', 3, 131);
INSERT INTO `userinfo` VALUES (140, 'Vincent', '12345', 2, 196);
INSERT INTO `userinfo` VALUES (141, 'Jennifer', '12345', 1, NULL);
INSERT INTO `userinfo` VALUES (142, 'Craig', '12345', 1, 144);
INSERT INTO `userinfo` VALUES (143, 'Ruth', '12345', 1, 194);
INSERT INTO `userinfo` VALUES (144, 'Edwin', '12345', 2, 51);
INSERT INTO `userinfo` VALUES (145, 'David', '12345', 3, NULL);
INSERT INTO `userinfo` VALUES (146, 'Dennis', '12345', 1, 127);
INSERT INTO `userinfo` VALUES (147, 'Christine', '12345', 2, 185);
INSERT INTO `userinfo` VALUES (148, 'Paul', '12345', 2, 4);
INSERT INTO `userinfo` VALUES (149, 'Amber', '12345', 2, 200);
INSERT INTO `userinfo` VALUES (150, 'Albert', '12345', 2, 67);

SET FOREIGN_KEY_CHECKS = 1;