/*
 Navicat MySQL Data Transfer

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

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

 Date: 05/10/2024 18:45:00
*/

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 NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `cityname`(`cityname`) USING BTREE,
  INDEX `provinceId`(`provinceId`) USING BTREE,
  CONSTRAINT `cities_ibfk_1` FOREIGN KEY (`provinceId`) REFERENCES `provinces` (`provinceid`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 351 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for homes
-- ----------------------------
DROP TABLE IF EXISTS `homes`;
CREATE TABLE `homes`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `defaultIcon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `selectIcon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `process` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of homes
-- ----------------------------

-- ----------------------------
-- Table structure for matches
-- ----------------------------
DROP TABLE IF EXISTS `matches`;
CREATE TABLE `matches`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `deadline` datetime NOT NULL,
  `telephone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `mem` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `disabled` int NOT NULL DEFAULT 0,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `title`(`title`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of matches
-- ----------------------------
INSERT INTO `matches` VALUES (1, '2024年第二届潇湘武林大会报名系统报名系统', '2024-11-30 00:00:00', '15116388119', '赛事备注信息', 0, '2024-10-04 13:46:36', '2024-10-04 13:47:00');
INSERT INTO `matches` VALUES (2, '2025年第二届潇湘武林大会报名系统报名系统', '2025-10-30 00:00:00', '15116388119', '赛事备注信息', 1, '2024-10-04 13:46:50', '2024-10-04 13:46:50');

-- ----------------------------
-- Table structure for matchgroups
-- ----------------------------
DROP TABLE IF EXISTS `matchgroups`;
CREATE TABLE `matchgroups`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `minBirthDay` datetime NOT NULL,
  `maxBirthDay` datetime NOT NULL,
  `matchId` int NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `matchId`(`matchId`) USING BTREE,
  CONSTRAINT `matchgroups_ibfk_1` FOREIGN KEY (`matchId`) REFERENCES `matches` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of matchgroups
-- ----------------------------
INSERT INTO `matchgroups` VALUES (1, '成人组', '1950-12-12 00:00:00', '2008-12-12 00:00:00', 1, '2024-10-04 14:40:02', '2024-10-04 14:40:02');
INSERT INTO `matchgroups` VALUES (2, '少年组', '2008-10-12 00:00:00', '2014-12-12 00:00:00', 1, '2024-10-04 14:40:38', '2024-10-04 14:49:34');

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

-- ----------------------------
-- Records of projects
-- ----------------------------
INSERT INTO `projects` VALUES (1, '单人长拳', 1, 1, '2024-10-04 13:57:11', '2024-10-04 14:19:58');
INSERT INTO `projects` VALUES (2, '南拳', 1, 1, '2024-10-04 13:57:35', '2024-10-04 13:57:35');
INSERT INTO `projects` VALUES (4, '两人对练刀', 2, 1, '2024-10-04 13:58:09', '2024-10-04 13:58:09');
INSERT INTO `projects` VALUES (5, '两人对练棒', 2, 1, '2024-10-04 14:23:06', '2024-10-04 14:23:06');

-- ----------------------------
-- Table structure for projectteams
-- ----------------------------
DROP TABLE IF EXISTS `projectteams`;
CREATE TABLE `projectteams`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `projectId` int NOT NULL COMMENT '赛项ID',
  `teamGroupId` int NOT NULL COMMENT '赛项队伍ID',
  `difficultDeclare` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '难度申报',
  `contentDecalare` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容申报',
  `projectTeamScore` int NULL DEFAULT NULL COMMENT '赛项队伍比赛成绩',
  `userId` int NOT NULL COMMENT '创建者ID',
  `matchId` int NOT NULL COMMENT '比赛ID',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `projectId`(`projectId`) USING BTREE,
  INDEX `teamGroupId`(`teamGroupId`) USING BTREE,
  INDEX `userId`(`userId`) USING BTREE,
  INDEX `matchId`(`matchId`) USING BTREE,
  CONSTRAINT `projectteams_ibfk_1` FOREIGN KEY (`projectId`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `projectteams_ibfk_2` FOREIGN KEY (`teamGroupId`) REFERENCES `teamgroups` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `projectteams_ibfk_3` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `projectteams_ibfk_4` FOREIGN KEY (`matchId`) REFERENCES `matches` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of projectteams
-- ----------------------------
INSERT INTO `projectteams` VALUES (1, 1, 1, '[{\"第一阶段\":[\"2.0\",\"2.0\"]},{\"第二阶段\":[\"1.1\",\"2.1\"]},{\"第三阶段\":[\"2.0\",\"2.4\"]}]', '[{\"第一阶段\":[\"跳跃1\",\"跳跃2\"]},{\"第二阶段\":[\"跳跃3\",\"跳跃4\"]},{\"第三阶段\":[\"跳跃5\",\"跳跃6\"]}]', 0, 2, 1, '2024-10-05 02:44:36', '2024-10-05 04:11:06');
INSERT INTO `projectteams` VALUES (2, 4, 1, '[{\"第一阶段\":[\"1.0\",\"2.0\"]},{\"第二阶段\":[\"1.1\",\"2.1\"]},{\"第三阶段\":[\"2.0\",\"2.4\"]}]', '[{\"第一阶段\":[\"跳跃1\",\"跳跃2\"]},{\"第二阶段\":[\"跳跃3\",\"跳跃4\"]},{\"第三阶段\":[\"跳跃5\",\"跳跃6\"]}]', NULL, 2, 1, '2024-10-05 02:44:36', '2024-10-05 02:44:36');
INSERT INTO `projectteams` VALUES (3, 2, 2, '[{\"第一阶段\":[\"1.0\",\"2.0\"]},{\"第二阶段\":[\"1.1\",\"2.1\"]},{\"第三阶段\":[\"2.0\",\"2.4\"]}]', '[{\"第一阶段\":[\"跳跃1\",\"跳跃2\"]},{\"第二阶段\":[\"跳跃3\",\"跳跃4\"]},{\"第三阶段\":[\"跳跃5\",\"跳跃6\"]}]', NULL, 3, 1, '2024-10-05 02:44:36', '2024-10-05 02:44:36');

-- ----------------------------
-- 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 NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`provinceid`) USING BTREE,
  UNIQUE INDEX `provincename`(`provincename`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for staffs
-- ----------------------------
DROP TABLE IF EXISTS `staffs`;
CREATE TABLE `staffs`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人员身份',
  `idcard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '省份证号码',
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
  `birthday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出生日期',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '队伍图片',
  `teamGroupId` int NOT NULL COMMENT '团队ID',
  `userId` int NOT NULL COMMENT '创建者ID',
  `matchesGroupId` int NOT NULL COMMENT '比赛组别编号',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `matchId` int NOT NULL COMMENT '比赛ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `teamGroupId`(`teamGroupId`) USING BTREE,
  INDEX `userId`(`userId`) USING BTREE,
  INDEX `matchesGroupId`(`matchesGroupId`) USING BTREE,
  INDEX `matchId`(`matchId`) USING BTREE,
  CONSTRAINT `staffs_ibfk_1` FOREIGN KEY (`teamGroupId`) REFERENCES `teamgroups` (`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,
  CONSTRAINT `staffs_ibfk_3` FOREIGN KEY (`matchId`) REFERENCES `matches` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `staffs_ibfk_4` FOREIGN KEY (`matchesGroupId`) REFERENCES `matchgroups` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of staffs
-- ----------------------------
INSERT INTO `staffs` VALUES (1, '运动员', '4308211981111909065', '李强', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:55:17', '2024-10-05 00:55:17', 1);
INSERT INTO `staffs` VALUES (2, '运动员', '4308211981111909025', '李强2', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:55:36', '2024-10-05 00:55:36', 1);
INSERT INTO `staffs` VALUES (5, '运动员', '4308211981111909014', '李强4', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:55:56', '2024-10-05 00:55:56', 1);
INSERT INTO `staffs` VALUES (6, '运动员', '4308211981111909054', '李强5', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:04', '2024-10-05 00:56:04', 1);
INSERT INTO `staffs` VALUES (7, '运动员', '4308211981111909057', '李强7', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:12', '2024-10-05 00:56:12', 1);
INSERT INTO `staffs` VALUES (8, '运动员', '4308211981111909056', '李强6', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:16', '2024-10-05 00:56:16', 1);
INSERT INTO `staffs` VALUES (9, '运动员', '4308211981111909058', '李强8', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:22', '2024-10-05 00:56:22', 1);
INSERT INTO `staffs` VALUES (10, '运动员', '4308211981111909059', '李强9', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:30', '2024-10-05 00:56:30', 1);
INSERT INTO `staffs` VALUES (11, '运动员', '4308211981111119059', '李强11', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:43', '2024-10-05 00:56:43', 1);
INSERT INTO `staffs` VALUES (12, '运动员', '4308211981111129059', '李强12', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:48', '2024-10-05 00:56:48', 1);
INSERT INTO `staffs` VALUES (13, '运动员', '4308211981111139059', '李强13', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:56:53', '2024-10-05 00:56:53', 1);
INSERT INTO `staffs` VALUES (14, '教练员', '4308211981111149059', '李强14', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:57:04', '2024-10-05 01:22:23', 1);
INSERT INTO `staffs` VALUES (15, '领队', '4308211981111149060', '领队1', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:57:04', '2024-10-05 00:57:04', 1);
INSERT INTO `staffs` VALUES (16, '队医', '4308211981111149061', '队医1', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:57:04', '2024-10-05 00:57:04', 1);
INSERT INTO `staffs` VALUES (17, '教练员', '4308211981111149062', '教练1', '男', '2009-09-09', '15116388219', 'liqiang@163.com', '/static/upload/images/file-1728058933057.jpg', 1, 2, 1, '2024-10-05 00:57:04', '2024-10-05 00:57:04', 1);

-- ----------------------------
-- Table structure for teamgroups
-- ----------------------------
DROP TABLE IF EXISTS `teamgroups`;
CREATE TABLE `teamgroups`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `teamName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '队伍名称',
  `teamAbbreviation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '队伍简称',
  `englishName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文名称',
  `nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家或地区',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省级',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市级',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详细地址',
  `teamLeader` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '团队负责人',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'email',
  `slogan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '团队口号',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '团队图片',
  `userId` int NOT NULL,
  `matchId` 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 `matchId`(`matchId`) USING BTREE,
  CONSTRAINT `teamgroups_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `teamgroups_ibfk_2` FOREIGN KEY (`matchId`) REFERENCES `matches` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teamgroups
-- ----------------------------
INSERT INTO `teamgroups` VALUES (1, '队伍1', '队伍1', 'duiwu1', '中国', '湖南', '长沙', '青园路168号', '张队', '15116388122', 'zhang@163.com', 'win win win', 'static/upload/images/file-1728058933057.jpg', 2, 1, '2024-10-04 16:32:57', '2024-10-05 00:18:17');
INSERT INTO `teamgroups` VALUES (2, '队伍2', '队伍2', 'duiwu2', '中国', '湖南', '长沙', '青园路168号', '张队长1', '15116388120', 'zhang@163.com', 'win win win', 'static/upload/images/file-1728058933057.jpg', 3, 1, '2024-10-04 16:35:04', '2024-10-04 16:35:04');
INSERT INTO `teamgroups` VALUES (3, '队伍3', '队伍3', 'duiwu3', '中国', '湖南', '长沙', '青园路168号', '张队长2', '15116388120', 'zhang@163.com', 'win win win', 'static/upload/images/file-1728058933057.jpg', 2, 1, '2024-10-04 16:35:04', '2024-10-04 16:35:04');

-- ----------------------------
-- Table structure for teamstaffs
-- ----------------------------
DROP TABLE IF EXISTS `teamstaffs`;
CREATE TABLE `teamstaffs`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `teamId` int NOT NULL COMMENT '赛项队伍ID',
  `userId` int NOT NULL,
  `staffId` int NOT NULL COMMENT '运动员ID',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `teamId`(`teamId`) USING BTREE,
  INDEX `userId`(`userId`) USING BTREE,
  INDEX `staffId`(`staffId`) USING BTREE,
  CONSTRAINT `teamstaffs_ibfk_1` FOREIGN KEY (`teamId`) REFERENCES `projectteams` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `teamstaffs_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `teamstaffs_ibfk_3` FOREIGN KEY (`staffId`) REFERENCES `staffs` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teamstaffs
-- ----------------------------
INSERT INTO `teamstaffs` VALUES (1, 1, 2, 1, '2024-10-05 04:28:01', '2024-10-05 04:28:01');
INSERT INTO `teamstaffs` VALUES (2, 2, 2, 1, '2024-10-05 04:28:01', '2024-10-05 04:28:01');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '$2a$10$tLYH2MtRqU0rE2pjT/UtvObhKOI2hxbeSTxwKnxEtKKfYk9D.UBVi', '管理员', '2024-10-04 13:45:49', '2024-10-04 13:45:49');
INSERT INTO `users` VALUES (2, 'group1', '$2a$10$I27IPrZolLcV3IYtrnR7VOHydiw9lgIb9CGgvwIL3KTex0ZpMnVMu', '普通用户', '2024-10-04 13:46:04', '2024-10-04 13:46:04');
INSERT INTO `users` VALUES (3, 'group2', '$2a$10$I27IPrZolLcV3IYtrnR7VOHydiw9lgIb9CGgvwIL3KTex0ZpMnVMu', '普通用户', '2024-10-04 13:46:04', '2024-10-04 13:46:04');
INSERT INTO `users` VALUES (4, 'group3', '$2a$10$I27IPrZolLcV3IYtrnR7VOHydiw9lgIb9CGgvwIL3KTex0ZpMnVMu', '普通用户', '2024-10-04 13:46:04', '2024-10-04 13:46:04');

SET FOREIGN_KEY_CHECKS = 1;