/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 100412
 Source Host           : localhost:3306
 Source Schema         : competition2

 Target Server Type    : MySQL
 Target Server Version : 100412
 File Encoding         : 65001

 Date: 03/10/2024 21:13:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cities
-- ----------------------------
DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `provinceid` int NOT NULL,
  `cityname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 353 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cities
-- ----------------------------
INSERT INTO `cities` VALUES (1, 1, '石家庄市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (2, 1, '唐山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (3, 1, '邯郸市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (4, 1, '邢台市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (5, 1, '保定市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (6, 1, '张家口市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (7, 1, '承德市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (8, 1, '沧州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (9, 1, '廊坊市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (10, 1, '衡水市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (11, 1, '秦皇岛市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (12, 2, '太原市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (13, 2, '大同市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (14, 2, '朔州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (15, 2, '忻州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (16, 2, '阳泉市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (17, 2, '晋中市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (18, 2, '长治市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (19, 2, '晋城市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (20, 2, '临汾市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (21, 2, '运城市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (22, 2, '吕梁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (23, 3, '沈阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (24, 3, '大连市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (25, 3, '鞍山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (26, 3, '抚顺市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (27, 3, '本溪市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (28, 3, '丹东市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (29, 3, '锦州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (30, 3, '营口市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (31, 3, '阜新市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (32, 3, '辽阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (33, 3, '盘锦市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (34, 3, '铁岭市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (35, 3, '朝阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (36, 3, '葫芦岛市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (37, 4, '长春市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (38, 4, '吉林市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (39, 4, '四平市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (40, 4, '辽源市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (41, 4, '通化市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (42, 4, '白山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (43, 4, '松原市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (44, 4, '白城市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (45, 4, '延边州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (46, 5, '哈尔滨市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (47, 5, '齐齐哈尔市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (48, 5, '鸡西市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (49, 5, '鹤岗市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (50, 5, '双鸭山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (51, 5, '大庆市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (52, 5, '伊春市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (53, 5, '佳木斯市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (54, 5, '七台河市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (55, 5, '牡丹江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (56, 5, '黑河市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (57, 5, '绥化市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (58, 5, '大兴安岭地区行署', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (59, 6, '南京市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (60, 6, '无锡市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (61, 6, '徐州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (62, 6, '常州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (63, 6, '苏州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (64, 6, '南通市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (65, 6, '连云港市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (66, 6, '淮安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (67, 6, '盐城市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (68, 6, '扬州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (69, 6, '镇江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (70, 6, '泰州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (71, 6, '宿迁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (72, 7, '杭州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (73, 7, '宁波市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (74, 7, '温州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (75, 7, '嘉兴市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (76, 7, '湖州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (77, 7, '绍兴市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (78, 7, '金华市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (79, 7, '衢州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (80, 7, '舟山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (81, 7, '台州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (82, 7, '丽水市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (83, 8, '合肥市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (84, 8, '芜湖市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (85, 8, '蚌埠市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (86, 8, '淮南市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (87, 8, '马鞍山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (88, 8, '淮北市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (89, 8, '铜陵市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (90, 8, '安庆市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (91, 8, '黄山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (92, 8, '阜阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (93, 8, '宿州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (94, 8, '滁州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (95, 8, '六安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (96, 8, '宣城市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (97, 8, '池州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (98, 8, '亳州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (99, 9, '福州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (100, 9, '厦门市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (101, 9, '漳州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (102, 9, '泉州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (103, 9, '三明市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (104, 9, '莆田市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (105, 9, '南平市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (106, 9, '龙岩市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (107, 9, '宁德市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (108, 10, '南昌市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (109, 10, '九江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (110, 10, '上饶市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (111, 10, '抚州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (112, 10, '宜春市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (113, 10, '吉安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (114, 10, '赣州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (115, 10, '景德镇市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (116, 10, '萍乡市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (117, 10, '新余市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (118, 10, '鹰潭市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (119, 11, '济南市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (120, 11, '青岛市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (121, 11, '淄博市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (122, 11, '枣庄市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (123, 11, '东营市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (124, 11, '烟台市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (125, 11, '潍坊市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (126, 11, '济宁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (127, 11, '泰安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (128, 11, '威海市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (129, 11, '日照市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (130, 11, '临沂市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (131, 11, '德州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (132, 11, '聊城市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (133, 11, '滨州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (134, 11, '菏泽市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (135, 12, '郑州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (136, 12, '开封市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (137, 12, '洛阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (138, 12, '平顶山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (139, 12, '安阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (140, 12, '鹤壁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (141, 12, '新乡市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (142, 12, '焦作市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (143, 12, '濮阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (144, 12, '许昌市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (145, 12, '漯河市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (146, 12, '三门峡市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (147, 12, '商丘市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (148, 12, '周口市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (149, 12, '驻马店市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (150, 12, '南阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (151, 12, '信阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (152, 13, '武汉市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (153, 13, '黄石市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (154, 13, '十堰市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (155, 13, '宜昌市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (156, 13, '襄阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (157, 13, '鄂州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (158, 13, '荆门市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (159, 13, '孝感市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (160, 13, '荆州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (161, 13, '黄冈市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (162, 13, '咸宁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (163, 13, '随州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (164, 13, '恩施土家族苗族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (165, 14, '长沙市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (166, 14, '株洲市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (167, 14, '湘潭市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (168, 14, '衡阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (169, 14, '邵阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (170, 14, '岳阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (171, 14, '常德市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (172, 14, '张家界市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (173, 14, '益阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (174, 14, '郴州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (175, 14, '永州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (176, 14, '怀化市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (177, 14, '怀化市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (178, 14, '湘西土家族苗族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (179, 15, '广州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (180, 15, '深圳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (181, 15, '珠海市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (182, 15, '汕头市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (183, 15, '佛山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (184, 15, '韶关市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (185, 15, '湛江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (186, 15, '肇庆市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (187, 15, '江门市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (188, 15, '茂名市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (189, 15, '惠州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (190, 15, '梅州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (191, 15, '汕尾市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (192, 15, '河源市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (193, 15, '阳江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (194, 15, '清远市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (195, 15, '东莞市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (196, 15, '中山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (197, 15, '潮州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (198, 15, '揭阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (199, 15, '云浮市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (200, 16, '海口市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (201, 16, '三亚市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (202, 16, '三沙市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (203, 16, '儋州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (204, 17, '成都市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (205, 17, '自贡市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (206, 17, '攀枝花市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (207, 17, '泸州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (208, 17, '德阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (209, 17, '广元市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (210, 17, '绵阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (211, 17, '遂宁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (212, 17, '内江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (213, 17, '乐山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (214, 17, '南充市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (215, 17, '宜宾市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (216, 17, '广安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (217, 17, '达州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (218, 17, '眉山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (219, 17, '雅安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (220, 17, '巴中市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (221, 17, '资阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (222, 17, '阿坝藏族羌族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (223, 17, '甘孜藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (224, 17, '凉山彝族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (225, 18, '贵阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (226, 18, '六盘水市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (227, 18, '遵义市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (228, 18, '安顺市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (229, 18, '铜仁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (230, 18, '毕节市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (231, 18, '黔西南布依族苗族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (232, 18, '黔东南苗族侗族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (233, 18, '黔南布依族苗族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (234, 19, '昆明市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (235, 19, '曲靖市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (236, 19, '玉溪市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (237, 19, '保山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (238, 19, '昭通市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (239, 19, '丽江市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (240, 19, '普洱市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (241, 19, '临沧市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (242, 19, '楚雄彝族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (243, 19, '红河哈尼族彝族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (244, 19, '文山壮族苗族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (245, 19, '西双版纳傣族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (246, 19, '大理白族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (247, 19, '德宏傣族景颇族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (248, 19, '怒江傈僳族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (249, 19, '迪庆藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (250, 20, '西安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (251, 20, '铜川市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (252, 20, '宝鸡市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (253, 20, '咸阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (254, 20, '渭南市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (255, 20, '延安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (256, 20, '延安市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (257, 20, '榆林市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (258, 20, '安康市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (259, 20, '商洛市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (260, 21, '兰州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (261, 21, '嘉峪关市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (262, 21, '金昌市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (263, 21, '白银市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (264, 21, '天水市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (265, 21, '武威市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (266, 21, '张掖市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (267, 21, '平凉市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (268, 21, '酒泉市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (269, 21, '庆阳市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (270, 21, '定西市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (271, 21, '陇南市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (272, 21, '临夏回族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (273, 21, '甘南藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (274, 22, '西宁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (275, 22, '海东市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (276, 22, '海北藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (277, 22, '黄南藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (278, 22, '海南藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (279, 22, '果洛藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (280, 22, '玉树藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (281, 22, '海西蒙古族藏族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (282, 24, '台北市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (283, 24, '新北市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (284, 24, '桃园市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (285, 24, '台中市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (286, 24, '台南市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (287, 24, '高雄市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (288, 24, '基隆市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (289, 24, '嘉义市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (290, 24, '新竹市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (291, 25, '花地玛堂区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (292, 25, '圣安多尼堂区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (293, 25, '嘉模堂区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (294, 25, '大堂区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (295, 25, '望德堂区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (296, 25, '风顺堂区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (297, 25, '路环岛', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (298, 26, '呼和浩特市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (299, 26, '包头市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (300, 26, '乌海市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (301, 26, '赤峰市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (302, 26, '通辽市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (303, 26, '鄂尔多斯市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (304, 26, '呼伦贝尔市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (305, 26, '巴彦淖尔市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (306, 26, '乌兰察布市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (307, 26, '兴安盟', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (308, 26, '锡林郭勒盟', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (309, 26, '阿拉善盟', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (310, 27, '南宁市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (311, 27, '柳州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (312, 27, '桂林市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (313, 27, '北海市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (314, 27, '防城港市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (315, 27, '钦州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (316, 27, '贵港市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (317, 27, '玉林市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (318, 27, '百色市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (319, 27, '贺州市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (320, 27, '河池市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (321, 27, '来宾市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (322, 27, '崇左市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (323, 28, '拉萨市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (324, 28, '日喀则市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (325, 28, '昌都市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (326, 28, '林芝市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (327, 28, '山南市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (328, 28, '那曲市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (329, 28, '阿里地区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (330, 29, '银川市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (331, 29, '石嘴山市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (332, 29, '吴忠市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (333, 29, '固原市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (334, 29, '中卫市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (335, 30, '乌鲁木齐市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (336, 30, '克拉玛依市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (337, 30, '吐鲁番市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (338, 30, '哈密市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (339, 30, '阿克苏地区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (340, 30, '喀什地区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (341, 30, '和田地区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (342, 30, '塔城地区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (343, 30, '阿勒泰地区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (344, 30, '巴音郭楞蒙古自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (345, 30, '昌吉回族自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (346, 30, '博尔塔拉蒙古自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (347, 30, '伊犁哈萨克自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (348, 30, '克孜勒苏柯尔克孜自治州', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (349, 31, '北京市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (350, 32, '天津市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (351, 33, '上海市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `cities` VALUES (352, 34, '重庆市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- ----------------------------
-- Table structure for homes
-- ----------------------------
DROP TABLE IF EXISTS `homes`;
CREATE TABLE `homes`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `defaultIcon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `selectIcon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `process` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of homes
-- ----------------------------
INSERT INTO `homes` VALUES (1, '报名首页', '/upload/tabbar/tabbar1.png', '/upload/tabbar/tabbar1s.png', NULL, NULL, '2024-08-13 22:21:10', '2024-08-13 22:21:13');
INSERT INTO `homes` VALUES (2, '团队信息', '/upload/tabbar/tabbar2.png', '/upload/tabbar/tabbar2s.png', NULL, NULL, '2024-08-13 22:21:26', '2024-08-13 22:21:32');
INSERT INTO `homes` VALUES (3, '人员管理', '/upload/tabbar/tabbar3.png', '/upload/tabbar/tabbar3s.png', NULL, NULL, '2024-08-13 22:21:47', '2024-08-13 22:21:51');
INSERT INTO `homes` VALUES (4, '单练报名', '/upload/tabbar/tabbar4.png', '/upload/tabbar/tabbar4s.png', NULL, NULL, '2024-08-13 22:22:09', '2024-08-13 22:22:13');
INSERT INTO `homes` VALUES (5, '对练报名', '/upload/tabbar/tabbar5.png', '/upload/tabbar/tabbar5s.png', NULL, '第三步', '2024-08-13 22:22:24', '2024-08-13 22:22:27');
INSERT INTO `homes` VALUES (6, '集体报名', '/upload/tabbar/tabbar6.png', '/upload/tabbar/tabbar6s.png', NULL, '第四步', '2024-08-13 22:22:39', '2024-08-13 22:22:41');
INSERT INTO `homes` VALUES (7, '对抗报名', '/upload/tabbar/tabbar7.png', '/upload/tabbar/tabbar7s.png', NULL, '第五步', '2024-08-13 22:22:51', '2024-08-13 22:22:54');
INSERT INTO `homes` VALUES (8, '对抗展示', '/upload/tabbar/tabbar8.png', '/upload/tabbar/tabbar8s.png', NULL, '第六步', '2024-08-13 22:23:03', '2024-08-13 22:23:05');
INSERT INTO `homes` VALUES (9, '统计分析', '/upload/tabbar/tabbar9.png', '/upload/tabbar/tabbar9s.png', NULL, '', '2024-08-13 22:23:15', '2024-08-13 22:23:17');

-- ----------------------------
-- Table structure for matches
-- ----------------------------
DROP TABLE IF EXISTS `matches`;
CREATE TABLE `matches`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `disabled` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `title`(`title`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of matches
-- ----------------------------
INSERT INTO `matches` VALUES (1, '2024年第十六届香港国际武术比赛', 0, '2024-08-13 06:03:02', '2024-08-13 06:03:02');
INSERT INTO `matches` VALUES (2, '2024年集美区第七届中小学报名系统生武术（套路）竞标赛报名系统', 0, '2024-08-13 06:03:19', '2024-08-13 06:03:19');
INSERT INTO `matches` VALUES (3, '第十四届华夏少林武术大赛报名系统', 0, '2024-08-13 06:03:31', '2024-08-13 06:03:31');
INSERT INTO `matches` VALUES (4, '2023年海峡两岸体育嘉年华第三届客家武术大赛报名系统', 0, '2024-08-13 06:03:40', '2024-08-13 06:03:40');
INSERT INTO `matches` VALUES (5, '2024年灯都古镇第七届传统武术精英大赛报名系统', 0, '2024-08-13 06:03:48', '2024-08-13 06:03:48');
INSERT INTO `matches` VALUES (6, '第二届潇湘武林大会报名系统报名系统', 0, '2024-08-13 06:03:56', '2024-08-13 06:03:56');

-- ----------------------------
-- Table structure for projectgroups
-- ----------------------------
DROP TABLE IF EXISTS `projectgroups`;
CREATE TABLE `projectgroups`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `projectId` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `projectId`(`projectId`) USING BTREE,
  CONSTRAINT `projectgroups_ibfk_1` FOREIGN KEY (`projectId`) REFERENCES `projects` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of projectgroups
-- ----------------------------
INSERT INTO `projectgroups` VALUES (1, '少年组', 1, '2024-08-13 14:08:02', '2024-08-13 14:08:02');

-- ----------------------------
-- Table structure for projects
-- ----------------------------
DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `projectname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `classificationId` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `projectname`(`projectname`) USING BTREE,
  INDEX `classificationId`(`classificationId`) USING BTREE,
  CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`classificationId`) REFERENCES `matches` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of projects
-- ----------------------------
INSERT INTO `projects` VALUES (1, '', 1, '2024-08-13 21:46:35', '2024-08-13 21:46:42');

-- ----------------------------
-- Table structure for provinces
-- ----------------------------
DROP TABLE IF EXISTS `provinces`;
CREATE TABLE `provinces`  (
  `provinceid` int NOT NULL,
  `provincename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of provinces
-- ----------------------------
INSERT INTO `provinces` VALUES (1, '河北省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (2, '山西省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (3, '辽宁省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (4, '吉林省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (5, '黑龙江省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (6, '江苏省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (7, '浙江省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (8, '安徽省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (9, '福建省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (10, '江西省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (11, '山东省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (12, '河南省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (13, '湖北省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (14, '湖南省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (15, '广东省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (16, '海南省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (17, '四川省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (18, '贵州省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (19, '云南省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (20, '陕西省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (21, '甘肃省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (22, '青海省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (23, '台湾省', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (24, '香港', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (25, '澳门', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (26, '内蒙古自治区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (27, '广西壮族自治区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (28, '西藏自治区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (29, '宁夏回族自治区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (30, '新疆维吾尔自治区', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (31, '北京市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (32, '天津市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (33, '上海市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `provinces` VALUES (34, '重庆市', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- ----------------------------
-- Table structure for staffgroups
-- ----------------------------
DROP TABLE IF EXISTS `staffgroups`;
CREATE TABLE `staffgroups`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '套路备注',
  `staffId` int NOT NULL,
  `groupId` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `staffId`(`staffId`) USING BTREE,
  INDEX `groupId`(`groupId`) USING BTREE,
  CONSTRAINT `staffgroups_ibfk_1` FOREIGN KEY (`staffId`) REFERENCES `staffs` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `staffgroups_ibfk_2` FOREIGN KEY (`groupId`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of staffgroups
-- ----------------------------
INSERT INTO `staffgroups` VALUES (1, NULL, 1, 1, '2024-08-13 14:14:24', '2024-08-13 14:14:24');

-- ----------------------------
-- Table structure for staffs
-- ----------------------------
DROP TABLE IF EXISTS `staffs`;
CREATE TABLE `staffs`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `statusname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '人员身份',
  `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '工作',
  `idcard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '省份证号码',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '姓名',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '性别',
  `birthday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '出生日期',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '邮箱',
  `vipdata` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'vipdata',
  `danxz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'danxz',
  `iddan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'iddan',
  `service` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'service',
  `danbk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'danbk',
  `association` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'association',
  `jiazhu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'jiazhu',
  `tour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'tour',
  `souvenir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'souvenir',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'img',
  `teamId` int NOT NULL,
  `userId` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idcard`(`idcard`) USING BTREE,
  INDEX `teamId`(`teamId`) USING BTREE,
  INDEX `userId`(`userId`) USING BTREE,
  CONSTRAINT `staffs_ibfk_1` FOREIGN KEY (`teamId`) REFERENCES `teams` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `staffs_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of staffs
-- ----------------------------
INSERT INTO `staffs` VALUES (1, '运动员', '学生', 'test09', 'test09', '男', 'test09', '12345678901', 'test09@', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '2024-08-13 19:02:30', '2024-08-13 19:02:33');
INSERT INTO `staffs` VALUES (62, '运动员', '学生', '12132123', '张三', '男', '1990-09-09', '12345678901', 'test@163.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '2024-08-13 11:05:53', '2024-08-13 11:05:53');
INSERT INTO `staffs` VALUES (70, '运动员5', '学生', '12132123212', '张三2', '男', '1990-09-09', '12345678901', 'test@163.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '2024-08-13 11:37:27', '2024-08-13 11:37:27');
INSERT INTO `staffs` VALUES (71, '运动员', NULL, 'werwer', 'tetet111', '男', 'werw', '12345678901', 'tetet111@', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, 2, '2024-08-14 10:59:43', '2024-08-14 10:59:43');

-- ----------------------------
-- Table structure for stafftypes
-- ----------------------------
DROP TABLE IF EXISTS `stafftypes`;
CREATE TABLE `stafftypes`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `typename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `typename`(`typename`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of stafftypes
-- ----------------------------
INSERT INTO `stafftypes` VALUES (1, '教练', '2024-08-13 15:51:02', '2024-08-13 15:51:04');
INSERT INTO `stafftypes` VALUES (2, '运动员', '2024-08-13 15:51:15', '2024-08-13 15:51:19');
INSERT INTO `stafftypes` VALUES (3, '领队', '2024-08-13 15:51:26', '2024-08-13 15:51:29');

-- ----------------------------
-- Table structure for teams
-- ----------------------------
DROP TABLE IF EXISTS `teams`;
CREATE TABLE `teams`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `teamname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '团队名称',
  `teamabbreviation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '团队简称',
  `englishname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '英文名称',
  `teamaward` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分类团队奖',
  `statelevel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '州级',
  `nation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '国家或地区',
  `provinciallevel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '省级',
  `citylevel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '市级',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
  `teamleader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '团队负责人',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '手机号码',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'email',
  `vxid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信号',
  `slogan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '团队口号',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '团队图片',
  `userId` int NOT NULL,
  `classificationId` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `teamname`(`teamname`) USING BTREE,
  INDEX `userId`(`userId`) USING BTREE,
  INDEX `classificationId`(`classificationId`) USING BTREE,
  CONSTRAINT `teams_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `teams_ibfk_2` FOREIGN KEY (`classificationId`) REFERENCES `matches` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teams
-- ----------------------------
INSERT INTO `teams` VALUES (1, '天下武林', '武林', 'Wuli', '奖项一', '亚洲', '中国', '江苏省', '徐州市', '雨花区', '王五', '15688238300', '', 'wx', 'gogogo', '未上传', 2, 1, '2024-08-13 15:44:07', '2024-08-13 15:44:10');
INSERT INTO `teams` VALUES (2, 'test', 'test', NULL, NULL, NULL, NULL, '河北省', '石家庄市', 'test', 'test', '12345678901', 'test@163.com', NULL, NULL, NULL, 2, 1, '2024-08-13 15:44:54', '2024-08-13 15:44:57');
INSERT INTO `teams` VALUES (55, '1', '队伍1', 'duiwu1', '优秀奖', '优秀奖', '中国', '浙江', '杭州', '天目山路111号', '李强', '12345678901', 'test@163.com', '12345678901', 'gogogo', 'test.jpg', 2, 1, '2024-08-13 11:20:29', '2024-08-13 11:20:29');
INSERT INTO `teams` VALUES (57, '梦之队', '队伍1', 'duiwu1', '优秀奖', '优秀奖', '中国', '浙江', '杭州', '天目山路111号', '李强', '12345678901', 'test@163.com', '12345678901', 'gogogo', 'test.jpg', 2, 1, '2024-08-13 11:21:28', '2024-08-13 11:21:28');
INSERT INTO `teams` VALUES (58, 'test33', 'test33', NULL, NULL, NULL, NULL, '辽宁省', '沈阳市', 'test33', 'test33', '12345678901', 'test33@', NULL, NULL, NULL, 2, 1, '2024-08-14 10:34:51', '2024-08-14 10:34:51');
INSERT INTO `teams` VALUES (59, 'test22', 'test22', NULL, NULL, NULL, NULL, '黑龙江省', '双鸭山市', 'test22', 'test22', '12345678901', 'test22@', NULL, NULL, NULL, 2, 1, '2024-08-14 10:38:08', '2024-08-14 10:38:08');
INSERT INTO `teams` VALUES (60, 'test44', 'test44', NULL, NULL, NULL, NULL, '山西省', '大同市', 'test44', 'test44', '12345678901', 'test44@', NULL, NULL, NULL, 2, 1, '2024-08-14 10:46:35', '2024-08-14 10:46:35');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '$2a$10$EIK0pxm4WU9i2qB1UvQb6eqC6ieysOghM4lsaxQuzIdjxFKm1SGBW', '管理员', '2024-08-13 01:27:37', '2024-08-13 01:27:37');
INSERT INTO `users` VALUES (2, 'zcy', '$2a$10$ygGcOznmuibvBtNL8a8I6uqK.QpfenLAI4PNrYyKyJHIKmzek/ftO', '普通用户', '2024-08-13 01:49:12', '2024-08-13 04:44:24');

SET FOREIGN_KEY_CHECKS = 1;