原神数据库
er 图DDL/DML 语句查询语句存储过程/触发器
er图
DDL/DML语句
设置名称utf8mb4；
设置FOREIGN_KEY_CHECKS=0;
如果存在任何“工件”，请删除该表。
创建表“工件”（
`id` int NOT NULL AUTO_INCRMENT,
`artifacts_name` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`set_bonus` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \’设置效果\’,
使用BTREE 的主键(`id`)
) 引擎=InnoDB 自动增量=52 字符集=utf8 COLLATE=utf8_general_ci ROW_FORMAT=动态；
插入“神器”值（1、“冒险家”、“打开各种宝箱后5秒内持续恢复30%生命值。”）；
INSERT INTO `artifacts` VALUES (2, \’Lucky One\’, \’当你拿起莫拉时，你会恢复300 点生命值。\’);
插入“神器”值（3，“流浪医生”，“释放元素爆发时，治疗20% 的生命值。”）；
INSERT INTO `artifacts` VALUES (4, “行者之心”, “强攻击暴击率增加30%。”);
INSERT INTO `artifacts` VALUES (5, \’奇迹\’, \’受到某种元素类型伤害后，相应抗性增加30%，持续10秒。该效果每10秒触发一次。\’);
INSERT INTO `artifacts` VALUES (6，“战争疯狂”，“当你的生命值低于70% 时，你的暴击率额外增加24%。”)；
INSERT INTO `artifacts` VALUES (7, \’导师\’, \’触发元素反应后，团队中所有角色的元素掌握度增加120点，持续8秒。\’);
INSERT INTO `artifacts` VALUES (8, \’放逐\’, \’施放元素爆发后，每2秒为你的团队中的每个角色（除了你自己）恢复2点元素能量。此效果持续6秒，不能叠加\’ ）；
INSERT INTO `artifacts` VALUES (9, \’守护之心\’, \’团队中具有不同元素类型的每个角色获得相应元素抗性的30%。\’);
插入“神器”值（10，“战士之心”，“对生命值超过50%的敌人造成30%额外伤害。”）；
INSERT INTO ‘artifacts’ VALUES (11, ‘武侠’，‘元素战斗技能解锁后8 秒内，普通攻击和暴击伤害提高25%。’);
INSERT INTO `artifacts` VALUES (12, \’赌徒\’, \’杀死敌人有100%几率清除元素战斗技能的冷却时间。该效果最多每15秒触发一次。\’);
INSERT INTO `artifacts` VALUES (13, \’学士\’, \’当你获得元素粒子或元素水晶球时，你的队伍中所有弓箭和魔法武器角色额外恢复3点元素能量。该效果只会触发一次在接下来的时间段内\’);
INSERT INTO `artifacts` VALUES (14, \”牺牲火\”, \”火附件效果的持续时间减少40%。\”);
INSERT INTO `artifacts` VALUES (15, \”水祭品\”, \”水属性附着效果持续时间减少40%。\”);
INSERT INTO `artifacts` VALUES (16, \’雷霆牺牲\’, \’闪电附着效果的持续时间减少40%。\’);
INSERT INTO `artifacts` VALUES (17, \’冰牺牲\’, \’冰附着效果的持续时间减少40%。\’);
INSERT INTO `artifacts` VALUES (18, \’冰冻失落的战士\’, \’攻击受冰属性影响的敌人时，暴击率增加20%。如果敌人被冰冻，暴击率增加20% % 增加）并额外增加20%。 \’）；
INSERT INTO ‘artifacts’ VALUES (19, “雷霆之王”, “在闪电属性影响下对敌人造成的伤害增加35%。”);
INSERT INTO `artifacts` VALUES (20, \”穿越火圣者\”, \”对受火元素影响的敌人造成的伤害增加35%。\”);
插入“神器”的数值（21、“心爱的女孩”、“激活元素战技或元素爆发10秒内，全队所有角色的治疗效果加成提高20%”）；
INSERT INTO `artifacts` VALUES (22, \’角斗士的最后仪式\’, \’如果装备这套遗物的角色是单手剑、双手剑或法杖武器角色，则该角色的普通攻击造成的伤害为\’ ）；
插入“神器”的值（23，“翡翠之影”），“扩散反应造成的伤害增加60%。根据扩散的元素类型，受影响的敌人相应的元素抗性增加10秒。它将减少40%。\’);
INSERT INTO `artifacts` VALUES (24, \’Wandering Lands\’, \’如果装备这套遗物的角色是魔法武器或弓箭角色，角色的暴击伤害增加35%。\’);
INSERT INTO `artifacts` VALUES (25，\’雷霆之怒\’，\’过载、电磁、超导和超级绽放反应造成的伤害增加40%，超强化反应造成的伤害增加20%。激活上述元素增强反应或反应使元素战斗技能的冷却时间减少1秒，最多每0.8秒触发一次。
INSERT INTO `artifacts` VALUES (26，\’火热女巫\’，\’过载、燃烧和绽放反应造成的伤害增加40%，蒸发和溶解反应的加成系数增加15%。元素战斗技能后施展2套效果10秒内增加50%，该效果最多可叠加3次’）；
INSERT INTO `artifacts` VALUES (27，《旧氏族仪式》，“释放元素爆裂后，我方所有角色的攻击力增加20%，持续12秒。此效果不可叠加。”)；
INSERT INTO `artifacts` VALUES (28，“血腥骑士精神”，“击败敌人后10秒内，暴击不消耗体力，暴击造成的伤害增加50%。”)；
INSERT INTO `artifacts` VALUES (29, \’远古岩石\’, \’当你获得结晶反应形成的芯片时，你的团队中的所有角色都会获得相应的35%元素伤害加成，持续10秒。同时，它只能通过属性伤害加成\’);来获得。
插入“神器”数值（30，“逆飞流星”，“在护盾保护下，普攻和暴击伤害加成额外增加40%。”）；
INSERT INTO `artifacts` VALUES (31, \’沉没之心\’, \’在激活你的元素战斗技能15秒内，普通攻击和暴击伤害增加30%。\’);
INSERT INTO `artifacts` VALUES (32, ‘千石’, ‘元素战斗技能击中敌人后，团队中所有附近角色的攻击力增加20%，护盾强度增加20 % 30%，持续3秒，最多每0.5秒激活一次，即使装备该遗物套装的角色在队伍后台也可以激活。
INSERT INTO `artifacts` VALUES (33, \’微弱之火\’, \’元素战斗技能击中敌人后，攻击力增加9%。此效果持续7秒，最多可叠加2次，并具有最多每0.3 秒触发一次。堆叠将提高2 组的效率100%。
INSERT INTO `artifacts` VALUES (34, \’回忆\’, \’解锁元素战斗技能时，如果角色拥有15个或更多元素能量星，则在接下来的10秒内将损失15点元素能量。 正常伤害攻击、重击、坠落攻击增加50%，且持续期间不会再次发动该效果。
INSERT INTO `artifacts` VALUES (35, \’绝缘旗帜\’, \’元素爆发造成的伤害基于元素充电效率的25% 增加。通过这种方式可以获得最多75% 的增加。\’);
INSERT INTO `artifacts` VALUES (36, \’花冠梦觉醒骷髅记录\’, \’装备该遗物套装的角色在下列情况下将获得“问答”效果。以：攻击敌人后，移除该层你获得的场上岩石属性攻击最多每0.3秒在你的队伍背景上触发一次，并且每3秒你可以获得一层，每层为你提供6%的防御力和6%的岩石属性伤害加成。第二个问答效果，丢了一层\’);
INSERT INTO `artifacts` VALUES (37, \’海染巨蛤\’, \’当配备此遗物套装的角色治愈其团队中的角色时，会产生一个持续3 秒的海染气泡并记录其数量。当治疗恢复的生命值（包括溢出值）结束时，海染气泡爆炸，对周围敌人造成累计恢复量90%的伤害（该伤害可以通过电磁、超导、伤害来解决）。其他元素反应不受元素掌握、等级或反应伤害加成效果的影响）。即使装备该遗物套装的角色在队伍后台，该效果也只能由队伍中最多一名角色同时激活。
INSERT INTO `artifacts` VALUES (38, \’朱砂轮回记录\’, \’施展元素爆发后，会产生“隐光”效果，持续16秒。点攻击力增加8%。另外，当角色生命值恢复，攻击力进一步提升10%，“潜能之光”效果最多激活4次，角色离开场时最多激活1次，移除原有的“潜能之光”。期间\’）;
INSERT INTO `artifacts` VALUES (39, \’来新御翔\’, \’普通攻击击中敌人时，有36%的几率启动‘山谷祭祀’：普通攻击伤害增加，并且伤害增加值为攻击力的70%，普通攻击造成伤害后0.05秒该效果取消，如果普通攻击未激活“山谷祭祀”，则下次激活概率增加20 %。判断是否触发最多0.2秒。
INSERT INTO `artifacts` VALUES (40, ‘森林深处的记忆’, ‘元素战斗技能或元素爆发击中敌人后，目标的草抗性降低30%，持续8 秒。如果佩戴者可以即使它在地面上也会被触发。
INSERT INTO `artifacts` VALUES (41, \’金色梦想\’, \’触发元素反应后8 秒内，佩戴者会根据团队中其他角色的元素类型而获得增益。 团队中的1 对于装备的每件物品，相同属性的角色攻击力增加14%，与佩戴者不同属性的角色属性熟练度增加50点该效果最多每8秒触发一次是的，以上列出的每个角色都可以触发。即使佩戴者位于团队的后台，也会产生这种效果。
INSERT INTO `artifacts` VALUES (42, \’沙上之家的历史\’, \’重击命中敌人后，角色的普通攻击速度增加10%，普通攻击、重击和坠落造成的伤害攻击力增加40%，持续15秒\’);
INSERT INTO `artifacts` VALUES (43, \’被遗忘的天堂之花\’\’, \’佩戴者因绽放、超级绽放和强烈绽放反应造成的伤害增加40%。此外，佩戴者触发绽放、超级绽放后，和强烈绽放，上述效果提供的加值增加25%，该效果持续10秒，最多可以叠加4次，并且佩戴者每秒最多可以叠加一次该效果即使在以下情况下也会激活。他是球队的幕后黑手。
INSERT INTO `神器` VALUES (44，\’水仙之梦\’，\’普通攻击、重击、坠落攻击、元素战技或元素爆发击中敌人时，会产生一层‘镜中水仙’效果。 8秒内，“镜中水仙”等级1/2/3以上时，攻击力提升7%/16%/25%，技能或属性产生的“镜中水仙”伤害加成增加。爆发增加4%/9%/15%。
INSERT INTO `神器` VALUES (45，\’甘露之光\’，\’元素战斗技能和元素爆发的伤害增加10%。佩戴者受到伤害后5秒内，上述伤害增加，增加的效果最多可叠加5次，每层持续时间也可以在团队后台时触发。
插入“神器”的数值（46，“追影者”，“当当前生命值增加或减少时，暴击几率增加12%。该效果持续5秒，最多可叠加3次。” ）；
INSERT INTO `artifacts` VALUES (47, \’黄金团\’, \’元素战斗技能的伤害增加25%。此外，如果你在队伍的后台，元素战斗技能的伤害会增加更多) 这个效果2秒后将出现在已删除的舞台上。
插入“神器”的值（48，《往事之歌》），“当佩戴者治疗队伍中的一个角色时，会出现持续6秒的干渴效果，并记录治疗恢复的生命值。（包括溢出）值）延续结束时，角色的普通攻击、强力攻击、坠落攻击、属性战技、属性爆发时，所向往的效果会转换为“彼时之波”效果。当前场上队伍击中敌人时，造成的伤害将根据所需效果增加记录恢复量的8%，该效果发动5次后，该次波数将被取消。或10 秒，欲望效果一次最多可记录15,000 点治疗点，但一次仅限一位拥有者。即使佩戴者创造了该效果，也可以激活该效果。我在团队的后台\’);
插入“神器”的数值（49，《回声森林的夜话》），“元素战斗技能发动后10秒内，岩石元素伤害加成增加20%。结晶生成的护盾受到保护时水晶护盾的效果，反应后，上述效果会增加150%，进一步增加的效果会在失去水晶护盾的保护后1秒消除。
INSERT INTO `artifacts` VALUES (50, \’和谐碎片\’, \’当生命契约值增加或减少时，角色造成的伤害增加18%。此效果持续6秒，最多可叠加3次。\’);
INSERT INTO `artifacts` VALUES (51, \’未完成的遐想\’, \’当你离开战斗状态3秒时，造成的伤害增加50%。在战斗状态下，如果附近没有燃烧的敌人超过6秒秒，以上如果装备着该遗物套装的角色在背景中，则伤害增加效果每秒减少10%，直到达到0%，并每秒增加10%，直到达到50%。 \’); 时触发。
如果“artifacts_select”存在，则删除该表。
创建表`artifacts_select` (
`id` int NOT NULL AUTO_INCRMENT,
`artifacts_id` int NOT NULL,
`user_id` int NULL 默认NULL,
`flower_of_life` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \’生命之花\’,
`plume_of_death` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \’死亡之羽\’,
`sands_of_eon` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \’Sands of Time\’,
`goblet_of_eonothem` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL Comment \’空杯子\’,
`circlet_of_logos` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \’Crown of Reason\’,
使用BTREE 的主键（`id`），
使用BTREE 索引`dacishuwang`(`artifacts_id`)，
使用BTREE索引`zhixingguansanbing`(`user_id`)，
约束`dacishuwang` 外键(`artifacts_id`) 引用`artifacts` (`id`) 删除限制更新限制，
约束`zhixingguansanbing` 外键(`user_id`) 引用`user` (`ID`) ON 删除限制ON 更新限制
) 引擎=InnoDB 自动增量=21 字符集=utf8 COLLATE=utf8_general_ci ROW_FORMAT=动态；
INSERT INTO `artifacts_select` value (1, 41, 68, \’4780\’, \’311\’, \’187 Mastery\’, \’46.6% Grass Damage\’, \’31.1% Violence Rate\’);
INSERT INTO `artifacts_select` 值(2, 18, 57, \’4780\’, \’311\’, \’46.6% Attack\’, \’46.6% Ice Cup\’, \’46.6% Health\’);
INSERT INTO `artifacts_select` 值（3, 19, 58, \’4780\’, \’311\’, \’51.8% Charge\’, \’46.6% Thunder Cup\’, \’31.1% Critical Chance\’）；
INSERT INTO `artifacts_select` 值（4, 35, 42, \’4780\’, \’311\’, \’51.8% 电荷\’, \’46.6% 水杯\’, \’62.2% 爆炸伤害\’）；
INSERT INTO `artifacts_select` value (5, 47, 76, \’4780\’, \’165\’, \’46.6% Health\’, \’46.6% Water Cup\’, \’31.1% Critical Chance\’);
INSERT INTO `artifacts_select` 值（6, 42, 69, \’4780\’, \’311\’, \’46.6% 攻击力\’, \’46.6% 风杯\’, \’31.1% 暴力率\’）；
INSERT INTO `artifacts_select` 值（7, 42, 56, \’4780\’, \’311\’, \’46.6% 攻击力\’, \’46.6% 风杯\’, \’62.2% 爆炸伤害\’）；
INSERT INTO `artifacts_select` value (8, 26, 65, \’4780\’, \’311\’, \’46.6% Health\’, \’46.6% 火焰杯\’, \’31.1% Critical Chance\’);
INSERT INTO `artifacts_select` value (9, 26, 53, \’4780\’, \’311\’, \’46.6% 攻击力\’, \’46.6% 火焰杯\’, \’31.1% 暴击率\’);
INSERT INTO `artifacts_select` value (10, 33, 33, \’4780\’, \’200\’, \’46.6% 攻击力\’, \’46.6% 物理伤害\’, \’31.1% 暴击率\’);
INSERT INTO `artifacts_select` 值（11, 31, 55, \’4780\’, \’311\’, \’46.6% 攻击力\’, \’46.6% 摇滚杯\’, \’31.1% 暴力率\’）；
INSERT INTO `artifacts_select` 值（12, 39, 84, \’4780\’, \’555\’, \’46.6% Health\’, \’46.6% Rock Cup\’, \’31.1% Critical Chance\’）；
INSERT INTO `artifacts_select` 值（13, 30, 54, \’4780\’, \’311\’, \’46.6% 治疗加成\’, \’46.6% 岩石杯\’, \’31.1% 暴击几率\’）;
INSERT INTO `artifacts_select` 值（14, 30, 67, \’4780\’, \’311\’, \’51.8% Charge\’, \’46.6% Rock Cup\’, \’31.1% Critical Chance\’）；
INSERT INTO `artifacts_select` 值（15, 26, 68, \’4780\’, \’311\’, \’51.8% Charge\’, \’46.6% Rock Cup\’, \’31.1% Critical Chance\’）；
INSERT INTO `artifacts_select` 值（16, 37, 77, \’4780\’, \’232\’, \’51.8% Charge\’, \’46.6% Rock Cup\’, \’31.1% Critical Chance\’）；
INSERT INTO `artifacts_select` 值（17, 27, 78, \’4780\’, \’311\’, \’187 精通\’, \’46.6% 摇滚杯\’, \’31.1% 暴力率\’）;
INSERT INTO `artifacts_select` 值（18, 37, 76, \’4780\’, \’311\’, \’46.6% 攻击力\’, \’46.6% 摇滚杯\’, \’31.1% 暴力率\’）；
INSERT INTO `artifacts_select` 值（19, 24, 85, \’4780\’, \’311\’, \’187 精通\’, \’46.6% 摇滚杯\’, \’31.1% 暴力率\’）;
INSERT INTO `artifacts_select` 值（20, 22, 77, \’4780\’, \’311\’, \’46.6% Health\’, \’46.6% Rock Cup\’, \’31.1% Critical Chance\’）；
如果“talent”存在，则删除该表。
创建表“人才”（
`user_id` int NOT NULL,
`normal_ Attack` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`E` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Q` varchar(255) 字符集utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
使用BTREE 的主键（`user_id`），
约束`qiyejun` 外键(`user_id`) 引用`user` (`ID`) 删除限制更新限制
) 引擎=InnoDB 字符集=utf8 COLLATE=utf8_general_ci ROW_FORMAT=动态；
普京
INTO `talent` VALUES (53, \’10\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (57, \’10\’, \’9\’, \’8\’);
INSERT INTO `talent` VALUES (58, \’9\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (68, \’10\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (69, \’10\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (76, \’9\’, \’9\’, \’9\’);
INSERT INTO `talent` VALUES (82, \’10\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (84, \’10\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (85, \’10\’, \’10\’, \’10\’);
INSERT INTO `talent` VALUES (86, \’10\’, \’10\’, \’10\’);
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`ID` int NOT NULL AUTO_INCREMENT,
`userName` varchar(255) NOT NULL COMMENT \’角色名\\r\\n\’,
`weapon_type_id` int NOT NULL COMMENT \’武器类型\’,
`dendro` varchar(255) NOT NULL COMMENT \’元素类型\’,
`rarity` varchar(255) NOT NULL COMMENT \’稀有度\’,
`weapon_id` int DEFAULT NULL COMMENT \’武器id\’,
`weapon_grade` int DEFAULT \’90\’ COMMENT \’武器等级\’,
`artifacts_id` int DEFAULT NULL COMMENT \’圣遗物id\’,
`user_level` int DEFAULT NULL COMMENT \’角色等级\’,
PRIMARY KEY (`ID`) USING BTREE,
UNIQUE KEY `weapon_id` (`weapon_id`,`artifacts_id`) USING BTREE,
KEY `bengbeng123` (`weapon_type_id`) USING BTREE,
CONSTRAINT `bengbeng123` FOREIGN KEY (`weapon_type_id`) REFERENCES `weapon_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
INSERT INTO `user` VALUES (1, \’安柏\’, 5, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (2, \’凯亚\’, 2, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (3, \’丽莎\’, 4, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (4, \’芭芭拉\’, 4, \’水\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (5, \’雷泽\’, 1, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (6, \’香菱\’, 3, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (7, \’北斗\’, 1, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (8, \’行秋\’, 2, \’水\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (9, \’凝光\’, 4, \’岩\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (10, \’菲谢尔\’, 5, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (11, \’班尼特\’, 2, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (12, \’诺艾尔\’, 1, \’岩\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (13, \’重云\’, 1, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (14, \’砂糖\’, 4, \’风\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (15, \’迪奥娜\’, 5, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (16, \’辛焱\’, 1, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (17, \’罗莎莉亚\’, 3, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (18, \’烟绯\’, 4, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (19, \’早柚\’, 1, \’风\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (20, \’九条裟罗\’, 5, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (21, \’托马\’, 3, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (22, \’五郎\’, 5, \’岩\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (23, \’云堇\’, 3, \’岩\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (24, \’久岐忍\’, 2, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (25, \’鹿野院平藏\’, 4, \’风\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (26, \’柯莱\’, 5, \’草\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (27, \’多莉\’, 1, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (28, \’坎蒂丝\’, 3, \’水\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (29, \’莱依拉\’, 2, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (30, \’珐露珊\’, 5, \’风\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (31, \’瑶瑶\’, 3, \’草\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (32, \’米卡\’, 3, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (33, \’卡维\’, 1, \’草\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (34, \’绮良良\’, 2, \’草\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (35, \’琳妮特\’, 2, \’风\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (36, \’菲米尼\’, 1, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (37, \’夏洛蒂\’, 4, \’冰\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (38, \’夏沃蕾\’, 3, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (39, \’嘉明\’, 1, \’火\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (40, \’赛索斯\’, 5, \’雷\’, \’4\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (41, \’琴\’, 2, \’风\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (42, \’迪卢克\’, 1, \’火\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (43, \’七七\’, 2, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (44, \’莫娜\’, 4, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (45, \’刻晴\’, 2, \’雷\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (46, \’温迪\’, 5, \’风\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (47, \’可莉\’, 4, \’火\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (48, \’达达利亚\’, 5, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (49, \’钟离\’, 3, \’岩\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (50, \’阿贝多\’, 2, \’岩\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (51, \’甘雨\’, 5, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (52, \’魈\’, 3, \’风\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (53, \’胡桃\’, 3, \’火\’, \’5\’, 99, 90, 9, 90);
INSERT INTO `user` VALUES (54, \’优菈\’, 1, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (55, \’枫原万叶\’, 2, \’风\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (56, \’神里绫华\’, 2, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (57, \’宵宫\’, 5, \’火\’, \’5\’, 169, 90, 2, 90);
INSERT INTO `user` VALUES (58, \’雷电将军\’, 3, \’雷\’, \’5\’, 100, 90, 3, 90);
INSERT INTO `user` VALUES (59, \’珊瑚宫心海\’, 4, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (60, \’荒泷一斗\’, 1, \’岩\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (61, \’申鹤\’, 3, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (62, \’八重神子\’, 4, \’雷\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (63, \’神里绫人\’, 2, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (64, \’夜兰\’, 5, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (65, \’提纳里\’, 5, \’草\’, \’5\’, NULL, NULL, 8, NULL);
INSERT INTO `user` VALUES (66, \’赛诺\’, 3, \’雷\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (67, \’妮露\’, 2, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (68, \’纳西妲\’, 4, \’草\’, \’5\’, 135, 90, 1, 90);
INSERT INTO `user` VALUES (69, \’流浪者\’, 4, \’风\’, \’5\’, 136, 90, 6, 90);
INSERT INTO `user` VALUES (70, \’艾尔海森\’, 2, \’草\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (71, \’迪希雅\’, 1, \’火\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (72, \’白术\’, 4, \’草\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (73, \’林尼\’, 5, \’火\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (74, \’那维莱特\’, 4, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (75, \’莱欧斯利\’, 4, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (76, \’芙宁娜\’, 2, \’水\’, \’5\’, 70, 90, 5, 90);
INSERT INTO `user` VALUES (77, \’娜维娅\’, 1, \’岩\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (78, \’闲云\’, 4, \’风\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (79, \’千织\’, 2, \’岩\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (80, \’阿蕾奇诺\’, 3, \’火\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (81, \’克洛琳德\’, 2, \’雷\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (82, \’希格雯\’, 5, \’水\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (83, \’埃洛伊\’, 5, \’冰\’, \’5\’, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (84, \’执行官散兵\’, 2, \’雷\’, \’6\’, 136, 90, 12, 90);
INSERT INTO `user` VALUES (85, \’倾奇者\’, 2, \’雷\’, \’7\’, 136, 90, NULL, 90);
INSERT INTO `user` VALUES (86, \’大慈树王\’, 4, \’草\’, \’7\’, NULL, NULL, 19, 90);
CREATE TABLE `weapon` (
`id` int NOT NULL AUTO_INCREMENT,
`weapon_type_id` int DEFAULT NULL,
`rarity` varchar(255) DEFAULT NULL,
`weapon_name` varchar(255) DEFAULT NULL,
`weapon_details` varchar(255) DEFAULT NULL,
`weapon_level` int unsigned DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `nahida66` (`weapon_type_id`) USING BTREE,
CONSTRAINT `nahida66` FOREIGN KEY (`weapon_type_id`) REFERENCES `weapon_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
INSERT INTO `weapon` VALUES (1, 1, \’1\’, \’训练大剑\’, \’185攻击力\’, NULL);
INSERT INTO `weapon` VALUES (2, 1, \’2\’, \’佣兵重剑\’, \’243攻击力\’, NULL);
INSERT INTO `weapon` VALUES (3, 1, \’3\’, \’铁影阔剑\’, \’401攻击力35.2%生命值\’, NULL);
INSERT INTO `weapon` VALUES (4, 1, \’3\’, \’白铁大剑\’, \’401攻击力43.9%防御力\’, NULL);
INSERT INTO `weapon` VALUES (5, 1, \’3\’, \’以理服人\’, \’401攻击力35.2%攻击力\’, NULL);
INSERT INTO `weapon` VALUES (6, 1, \’3\’, \’飞天大御剑\’, \’401攻击力43.9%物理伤害加成\’, NULL);
INSERT INTO `weapon` VALUES (7, 1, \’4\’, \’西风大剑\’, \’454攻击力61.3%充能\’, NULL);
INSERT INTO `weapon` VALUES (8, 1, \’4\’, \’钟剑\’, \’510攻击力41.3%生命\’, NULL);
INSERT INTO `weapon` VALUES (9, 1, \’4\’, \’祭礼大剑\’, \’565攻击力30.6%元素效率\’, NULL);
INSERT INTO `weapon` VALUES (10, 1, \’4\’, \’宗室大剑\’, \’565攻击力27.6%攻击力\’, NULL);
INSERT INTO `weapon` VALUES (11, 1, \’4\’, \’雨裁\’, \’510攻击力165精通\’, NULL);
INSERT INTO `weapon` VALUES (12, 1, \’4\’, \’试作古华\’, \’565攻击力27.6%攻击\’, NULL);
INSERT INTO `weapon` VALUES (13, 1, \’4\’, \’白影剑\’, \’510攻击力51.7%防御力\’, NULL);
INSERT INTO `weapon` VALUES (14, 1, \’4\’, \’黑岩斩刀\’, \’510攻击力55.1%暴伤\’, NULL);
INSERT INTO `weapon` VALUES (15, 1, \’4\’, \’螭骨剑\’, \’510攻击力27.6%暴率\’, NULL);
INSERT INTO `weapon` VALUES (16, 1, \’4\’, \’雪葬的星银\’, \’565攻击力34.5%物伤\’, NULL);
INSERT INTO `weapon` VALUES (17, 1, \’4\’, \’千岩古剑\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (18, 1, \’4\’, \’桂木斩长正\’, \’510攻击力45.9%充能\’, NULL);
INSERT INTO `weapon` VALUES (19, 1, \’4\’, \’恶王丸\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (20, 1, \’4\’, \’森林王器\’, \’565攻击力30.6%元素效率\’, NULL);
INSERT INTO `weapon` VALUES (21, 1, \’4\’, \’玛海菈的水色\’, \’510攻击力165精通\’, NULL);
INSERT INTO `weapon` VALUES (22, 1, \’4\’, \’饰铁之花\’, \’565攻击力110精通\’, NULL);
INSERT INTO `weapon` VALUES (23, 1, \’4\’, \’聊聊棒\’, \’565攻击力18.4暴率\’, NULL);
INSERT INTO `weapon` VALUES (24, 1, \’4\’, \’浪影阔剑\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (25, 1, \’4\’, \’便携动力锯\’, \’454攻击力55.1%生命\’, NULL);
INSERT INTO `weapon` VALUES (26, 1, \’4\’, \’究极霸王超级魔剑\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (27, 1, \’5\’, \’天空之傲\’, \’674攻击力36.8%充能\’, NULL);
INSERT INTO `weapon` VALUES (28, 1, \’5\’, \’狼的末路\’, \’608攻击力49.6%攻击力\’, NULL);
INSERT INTO `weapon` VALUES (29, 1, \’5\’, \’无工之剑\’, \’608攻击力49.6%攻击力\’, NULL);
INSERT INTO `weapon` VALUES (30, 1, \’5\’, \’松籁响起之时\’, \’741攻击力20.7物伤\’, NULL);
INSERT INTO `weapon` VALUES (31, 1, \’5\’, \’赤角石溃杵\’, \’542攻击力88.2爆伤\’, NULL);
INSERT INTO `weapon` VALUES (32, 1, \’5\’, \’苇海信标\’, \’608攻击力33.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (33, 1, \’5\’, \’裁断\’, \’674攻击力22.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (34, 2, \’1\’, \’无锋剑\’, \’185攻击力\’, NULL);
INSERT INTO `weapon` VALUES (35, 2, \’2\’, \’银剑\’, \’243攻击力\’, NULL);
INSERT INTO `weapon` VALUES (36, 2, \’3\’, \’冷刃\’, \’401攻击力35.2%攻击\’, NULL);
INSERT INTO `weapon` VALUES (37, 2, \’3\’, \’黎明神剑\’, \’401攻击力46.9%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (38, 2, \’3\’, \’旅行剑\’, \’448攻击力29.3%防御力\’, NULL);
INSERT INTO `weapon` VALUES (39, 2, \’3\’, \’吃虎鱼刀\’, \’401攻击力35.2%攻击\’, NULL);
INSERT INTO `weapon` VALUES (40, 2, \’3\’, \’飞天御剑\’, \’354攻击力52.1%充能\’, NULL);
INSERT INTO `weapon` VALUES (41, 2, \’4\’, \’西风剑\’, \’454攻击力61.3%充能\’, NULL);
INSERT INTO `weapon` VALUES (42, 2, \’4\’, \’笛剑\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (43, 2, \’4\’, \’祭礼剑\’, \’454攻击力61.3%充能\’, NULL);
INSERT INTO `weapon` VALUES (44, 2, \’4\’, \’宗室长剑\’, \’510攻击力41.3攻击\’, NULL);
INSERT INTO `weapon` VALUES (45, 2, \’4\’, \’匣里龙吟\’, \’510攻击力41.3攻击\’, NULL);
INSERT INTO `weapon` VALUES (46, 2, \’4\’, \’试作斩岩\’, \’565攻击力34.5%物伤\’, NULL);
INSERT INTO `weapon` VALUES (47, 2, \’4\’, \’铁蜂刺\’, \’510攻击力165精通\’, NULL);
INSERT INTO `weapon` VALUES (48, 2, \’4\’, \’黑岩长剑\’, \’565攻击力36.8%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (49, 2, \’4\’, \’黑剑\’, \’510攻击力27.6%暴率\’, NULL);
INSERT INTO `weapon` VALUES (50, 2, \’4\’, \’降临之剑\’, \’440攻击力35.2%攻击力\’, NULL);
INSERT INTO `weapon` VALUES (51, 2, \’4\’, \’暗巷闪光\’, \’620攻击力55精通\’, NULL);
INSERT INTO `weapon` VALUES (52, 2, \’4\’, \’天目影打刀\’, \’454攻击力55.1攻击\’, NULL);
INSERT INTO `weapon` VALUES (53, 2, \’4\’, \’笼钓瓶一心\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (54, 2, \’4\’, \’原木刀\’, \’565攻击力30.6%充能\’, NULL);
INSERT INTO `weapon` VALUES (55, 2, \’4\’, \’西福斯的月光\’, \’510攻击力165精通\’, NULL);
INSERT INTO `weapon` VALUES (56, 2, \’4\’, \’狼牙\’, \’510攻击力27.6%暴率\’, NULL);
INSERT INTO `weapon` VALUES (57, 2, \’4\’, \’海渊终曲\’, \’565攻击力27.6%攻击\’, NULL);
INSERT INTO `weapon` VALUES (58, 2, \’4\’, \’灰河渡手\’, \’510攻击力45.9%充能\’, NULL);
INSERT INTO `weapon` VALUES (59, 2, \’4\’, \’船坞长剑\’, \’510攻击力41.3%生命\’, NULL);
INSERT INTO `weapon` VALUES (60, 2, \’4\’, \’水仙十字圣剑\’, \’510攻击力41.3%攻击\’, NULL);
INSERT INTO `weapon` VALUES (61, 2, \’5\’, \’风鹰剑\’, \’674攻击力41.3%物伤\’, NULL);
INSERT INTO `weapon` VALUES (62, 2, \’5\’, \’天空之刃\’, \’608攻击力55.1%充能\’, NULL);
INSERT INTO `weapon` VALUES (63, 2, \’5\’, \’斫峰之刃\’, \’608攻击力49.6%攻击\’, NULL);
INSERT INTO `weapon` VALUES (64, 2, \’5\’, \’磐岩结绿\’, \’542攻击力44.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (65, 2, \’5\’, \’苍古自由之誓\’, \’608攻击力198精通\’, NULL);
INSERT INTO `weapon` VALUES (66, 2, \’5\’, \’雾切之回光\’, \’674攻击力44.1%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (67, 2, \’5\’, \’波乱月白经津\’, \’608攻击力33.1暴率\’, NULL);
INSERT INTO `weapon` VALUES (68, 2, \’5\’, \’圣显之钥\’, \’542攻击力66.2%生命\’, NULL);
INSERT INTO `weapon` VALUES (69, 2, \’5\’, \’裁叶萃光\’, \’542攻击力88.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (70, 2, \’5\’, \’静水流涌之辉\’, \’542攻击力88.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (71, 2, \’5\’, \’有乐御簾切\’, \’542攻击力88.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (72, 2, \’5\’, \’赦罪\’, \’674攻击力44.1%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (73, 3, \’1\’, \’新手长枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (74, 3, \’2\’, \’铁尖枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (75, 3, \’3\’, \’白缨枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (76, 3, \’3\’, \’钺矛\’, NULL, NULL);
INSERT INTO `weapon` VALUES (77, 3, \’3\’, \’黑缨枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (78, 3, \’4\’, \’匣里灭辰\’, NULL, NULL);
INSERT INTO `weapon` VALUES (79, 3, \’4\’, \’试作星镰\’, NULL, NULL);
INSERT INTO `weapon` VALUES (80, 3, \’4\’, \’流月针\’, NULL, NULL);
INSERT INTO `weapon` VALUES (81, 3, \’4\’, \’黑岩刺枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (82, 3, \’4\’, \’决斗之枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (83, 3, \’4\’, \’西风长枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (84, 3, \’4\’, \’宗室猎枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (86, 3, \’4\’, \’龙脊长枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (87, 3, \’4\’, \’千岩长枪\’, NULL, NULL);
INSERT INTO `weapon` VALUES (88, 3, \’4\’, \’喜多院十文字\’, NULL, NULL);
INSERT INTO `weapon` VALUES (89, 3, \’4\’, \’渔获\’, NULL, NULL);
INSERT INTO `weapon` VALUES (90, 3, \’4\’, \’断浪长鳍\’, NULL, NULL);
INSERT INTO `weapon` VALUES (91, 3, \’4\’, \’贯月矢\’, NULL, NULL);
INSERT INTO `weapon` VALUES (92, 3, \’4\’, \’峡湾长歌\’, NULL, NULL);
INSERT INTO `weapon` VALUES (93, 3, \’4\’, \’公义的报酬\’, NULL, NULL);
INSERT INTO `weapon` VALUES (94, 3, \’4\’, \’勘探钻机\’, NULL, NULL);
INSERT INTO `weapon` VALUES (95, 3, \’4\’, \’沙中伟贤的对答\’, NULL, NULL);
INSERT INTO `weapon` VALUES (96, 3, \’5\’, \’和璞鸢\’, \’674攻击力22.1暴率\’, NULL);
INSERT INTO `weapon` VALUES (97, 3, \’5\’, \’天空之脊\’, \’674攻击力36.8%充能\’, NULL);
INSERT INTO `weapon` VALUES (98, 3, \’5\’, \’贯虹之槊\’, \’608攻击力49.6%攻击\’, NULL);
INSERT INTO `weapon` VALUES (99, 3, \’5\’, \’护摩之杖\’, \’608攻击力66.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (100, 3, \’5\’, \’薙草之稻光\’, \’608攻击力55.1%充能\’, NULL);
INSERT INTO `weapon` VALUES (101, 3, \’5\’, \’息灾\’, \’741攻击力16.5%攻击\’, NULL);
INSERT INTO `weapon` VALUES (102, 3, \’5\’, \’赤沙之杖\’, \’542攻击力44.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (103, 3, \’5\’, \’赤月之形\’, \’674攻击力22.1暴率\’, NULL);
INSERT INTO `weapon` VALUES (104, 4, \’1\’, \’学徒笔记\’, NULL, NULL);
INSERT INTO `weapon` VALUES (105, 4, \’2\’, \’魔导绪论\’, NULL, NULL);
INSERT INTO `weapon` VALUES (106, 4, \’3\’, \’讨龙英杰谭\’, NULL, NULL);
INSERT INTO `weapon` VALUES (107, 4, \’3\’, \’异世界行记\’, NULL, NULL);
INSERT INTO `weapon` VALUES (108, 4, \’3\’, \’翡玉法球\’, NULL, NULL);
INSERT INTO `weapon` VALUES (109, 4, \’3\’, \’甲级宝钰\’, NULL, NULL);
INSERT INTO `weapon` VALUES (110, 4, \’4\’, \’西风秘典\’, NULL, NULL);
INSERT INTO `weapon` VALUES (111, 4, \’4\’, \’流浪乐章\’, NULL, NULL);
INSERT INTO `weapon` VALUES (114, 4, \’4\’, \’祭礼残章\’, NULL, NULL);
INSERT INTO `weapon` VALUES (115, 4, \’4\’, \’宗室秘法录\’, NULL, NULL);
INSERT INTO `weapon` VALUES (116, 4, \’4\’, \’匣里日月\’, NULL, NULL);
INSERT INTO `weapon` VALUES (117, 4, \’4\’, \’试作金珀\’, NULL, NULL);
INSERT INTO `weapon` VALUES (118, 4, \’4\’, \’万国诸海图谱\’, NULL, NULL);
INSERT INTO `weapon` VALUES (119, 4, \’4\’, \’黑岩绯玉\’, NULL, NULL);
INSERT INTO `weapon` VALUES (120, 4, \’4\’, \’昭心\’, NULL, NULL);
INSERT INTO `weapon` VALUES (121, 4, \’4\’, \’忍冬之果\’, NULL, NULL);
INSERT INTO `weapon` VALUES (122, 4, \’4\’, \’暗巷的酒与诗\’, NULL, NULL);
INSERT INTO `weapon` VALUES (123, 4, \’4\’, \’白辰之环\’, NULL, NULL);
INSERT INTO `weapon` VALUES (124, 4, \’4\’, \’盈满之实\’, NULL, NULL);
INSERT INTO `weapon` VALUES (125, 4, \’4\’, \’流浪的晚星\’, NULL, NULL);
INSERT INTO `weapon` VALUES (126, 4, \’4\’, \’遗祀玉珑\’, NULL, NULL);
INSERT INTO `weapon` VALUES (127, 4, \’4\’, \’纯水流华\’, NULL, NULL);
INSERT INTO `weapon` VALUES (128, 4, \’4\’, \’无垠蔚蓝之歌\’, NULL, NULL);
INSERT INTO `weapon` VALUES (129, 4, \’5\’, \’天空之卷\’, \’674攻击力33.1攻击\’, NULL);
INSERT INTO `weapon` VALUES (130, 4, \’5\’, \’四风原典\’, \’608攻击力33.1暴率\’, NULL);
INSERT INTO `weapon` VALUES (131, 4, \’5\’, \’尘世之锁\’, \’608攻击力49.6%攻击力\’, NULL);
INSERT INTO `weapon` VALUES (132, 4, \’5\’, \’不灭月华\’, \’608攻击力49.6%生命\’, NULL);
INSERT INTO `weapon` VALUES (134, 4, \’5\’, \’神乐之真意\’, \’608攻击力66.2爆伤\’, NULL);
INSERT INTO `weapon` VALUES (135, 4, \’5\’, \’千夜浮梦\’, \’542攻击力265精通\’, NULL);
INSERT INTO `weapon` VALUES (136, 4, \’5\’, \’图莱杜拉的回忆\’, \’674攻击力44.1爆伤\’, NULL);
INSERT INTO `weapon` VALUES (137, 4, \’5\’, \’碧落之珑\’, \’608攻击力49.6生命值\’, NULL);
INSERT INTO `weapon` VALUES (138, 4, \’5\’, \’金流监督\’, \’674攻击力22.1暴率\’, NULL);
INSERT INTO `weapon` VALUES (139, 4, \’5\’, \’万世涌流大典\’, \’542攻击力88.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (140, 4, \’5\’, \’鹤鸣余音\’, \’741攻击力16.5%攻击\’, NULL);
INSERT INTO `weapon` VALUES (141, 5, \’1\’, \’猎弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (142, 5, \’2\’, \’历练的猎弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (143, 5, \’3\’, \’鸦羽弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (144, 5, \’3\’, \’神射手之誓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (145, 5, \’3\’, \’反曲弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (146, 5, \’3\’, \’弹弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (147, 5, \’3\’, \’信使\’, NULL, NULL);
INSERT INTO `weapon` VALUES (148, 5, \’4\’, \’西风猎弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (149, 5, \’4\’, \’绝弦\’, NULL, NULL);
INSERT INTO `weapon` VALUES (150, 5, \’4\’, \’祭礼弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (151, 5, \’4\’, \’宗室长弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (152, 5, \’4\’, \’弓藏\’, NULL, NULL);
INSERT INTO `weapon` VALUES (153, 5, \’4\’, \’试作澹月\’, NULL, NULL);
INSERT INTO `weapon` VALUES (154, 5, \’4\’, \’钢轮弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (155, 5, \’4\’, \’黑岩战弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (156, 5, \’4\’, \’苍翠猎弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (157, 5, \’4\’, \’暗巷猎手\’, NULL, NULL);
INSERT INTO `weapon` VALUES (158, 5, \’4\’, \’幽夜华尔兹\’, NULL, NULL);
INSERT INTO `weapon` VALUES (159, 5, \’4\’, \’破魔之弓\’, NULL, NULL);
INSERT INTO `weapon` VALUES (160, 5, \’4\’, \’曚云之月\’, NULL, NULL);
INSERT INTO `weapon` VALUES (161, 5, \’4\’, \’王下近侍\’, NULL, NULL);
INSERT INTO `weapon` VALUES (162, 5, \’4\’, \’竭泽\’, NULL, NULL);
INSERT INTO `weapon` VALUES (163, 5, \’4\’, \’烈阳之嗣\’, NULL, NULL);
INSERT INTO `weapon` VALUES (164, 5, \’4\’, \’静谧之曲\’, NULL, NULL);
INSERT INTO `weapon` VALUES (165, 5, \’4\’, \’测距规\’, NULL, NULL);
INSERT INTO `weapon` VALUES (166, 5, \’5\’, \’天空之翼\’, \’674攻击力22.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (167, 5, \’5\’, \’阿莫斯之弓\’, \’608攻击力49.6%攻击\’, NULL);
INSERT INTO `weapon` VALUES (168, 5, \’5\’, \’终末嗟叹之弓\’, \’608攻击力55.1%充能\’, NULL);
INSERT INTO `weapon` VALUES (169, 5, \’5\’, \’飞雷之弦振\’, \’608攻击力66.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (170, 5, \’5\’, \’冬极白星\’, \’608攻击力33.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (171, 5, \’5\’, \’若水\’, \’542攻击力88.2%爆伤\’, NULL);
INSERT INTO `weapon` VALUES (172, 5, \’5\’, \’猎人之径\’, \’542攻击力44.1%暴率\’, NULL);
INSERT INTO `weapon` VALUES (173, 5, \’5\’, \’最初的大魔术\’, \’608攻击力66.2爆伤\’, NULL);
INSERT INTO `weapon` VALUES (174, 5, \’5\’, \’白雨心弦\’, NULL, NULL);
DROP TABLE IF EXISTS `weapon_type`;
CREATE TABLE `weapon_type` (
`id` int NOT NULL AUTO_INCREMENT,
`weapon_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \’武器类型\’,
PRIMARY KEY (`id`) USING BTREE,
INDEX `weapom_type`(`weapon_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
INSERT INTO `weapon_type` VALUES (2, \’单手剑\’);
INSERT INTO `weapon_type` VALUES (1, \’双手剑\’);
INSERT INTO `weapon_type` VALUES (5, \’弓\’);
INSERT INTO `weapon_type` VALUES (4, \’法器\’);
INSERT INTO `weapon_type` VALUES (3, \’长柄武器\’);
SET FOREIGN_KEY_CHECKS = 1;
查询语句
— 简单查询
— 查询每个角色的名称，等级，各项属性，武器，武器等级，武器类型，圣遗物，圣遗物相关属性
select u.userName \’角色名\’,u.rarity \’角色等级\’,u.dendro \’属性\’,w.weapon_name \’武器\’,w.rarity \’武器等级\’,
wt.weapon_type \’武器类型\’,a.artifacts_name \’圣遗物\’,ast.flower_of_life \’生之花\’,ast.plume_of_death \’死之羽\’,ast.sands_of_eon \’时之沙\’,ast.goblet_of_eonothem \’空之杯\’,ast.circlet_of_logos \’理之冠\’
from `user` u
left join weapon w on u.weapon_id=w.id
left join weapon_type wt on u.weapon_type_id=wt.id
left join artifacts a on u.artifacts_id = a.id
left join artifacts_select ast on u.ID = ast.user_id
— 索引 查询武器类型编号为2的角色
explain select * from `user` where weapon_type_id=\’2\’;
— 聚合函数 查询各元素角色数量
select dendro,count(*) \’各元素角色数量\’ from `user` group by dendro order by count(*) desc;
— 复杂查询
— 查询排除魈后的 五星 风系 使用法器或单手剑或长枪的 角色和角色的武器类型
select u.userName,wt.weapon_type from `user` u
join weapon_type wt
on u.weapon_type_id = wt.id
where u.rarity > 4
and u.dendro = \’风\’
and u.userName != \’魈\’
and wt.weapon_type in (\’法器\’,\’单手剑\’,\’长枪\’);
— 按元素分组查询各元素所有五星角色的死之羽圣遗物的总攻击力
select dendro \’元素\’,sum(a.plume_of_death) \’各元素所有五星角色的死之羽总攻击力\’ from `user` u
join artifacts_select a
on a.user_id =u.ID
where rarity >4
group by dendro
order by sum(a.plume_of_death) desc;
— 胡桃，宵宫组成的队伍的一套攻击的伤害
select sum(E)+sum(Q)+sum(normal_attack) as \’队伍伤害\’ from
talent
where user_id in (select ID from `user` where userName in (\’胡桃\’,\’宵宫\’));
存储过程/触发器
user表插入限制
drop procedure if exists insert_user;
DELIMITER $$
CREATE PROCEDURE insert_user(
in userName VARCHAR(255),
IN weapon_type INT,
IN dendro VARCHAR(255),
in rarity int,
in user_level int
)
BEGIN
if user_level>90 OR user_level<0 then
signal sqlstate \’45000\’ set message_text=\’等级错误\’;
end if;
INSERT INTO user (userName, weapon_type_id, dendro,rarity,user_level) VALUES (userName, weapon_type, dendro,rarity,user_level);
END$$
DELIMITER ;
call insert_user(\’胡桃\’,1,\’火\’,4,70);
#weapon武器表存储过程
drop procedure if exists insert_weapon;
DELIMITER $$
CREATE PROCEDURE insert_weapon(
in weapon_type_id int,
IN rarity INT,
IN weapon_name VARCHAR(255),
in weapon_details varchar(255)
)
BEGIN
if (weapon_type_id < 0 OR weapon_type_id > 5) OR (rarity < 0 OR rarity > 5) then
signal sqlstate \’45000\’ set message_text=\’超出类型id限制(1-5)\’;
end if;
INSERT INTO weapon (weapon_type_id,rarity,weapon_name,weapon_details) VALUES (weapon_type_id,rarity,weapon_name,weapon_details);
END$$
DELIMITER ;
call insert_weapon(1,4,\’测试1\’,\’测试1-1\’);
call insert_weapon(1,7,\’错误测试2\’,\’错误测试2-1\’);
— 圣遗物表存储过程
drop procedure if exists insert_artifacts;
DELIMITER $$
CREATE PROCEDURE insert_artifacts(
IN artifacts_name VARCHAR(255),
in set_bonus varchar(255)
)
BEGIN
INSERT INTO artifacts (artifacts_name,set_bonus) VALUES (artifacts_name,set_bonus);
END$$
DELIMITER ;
call insert_artifacts(\’测试1\’,\’测试1\’);
# 等级更新限制
drop trigger if exists before_update_user;
DELIMITER $$
CREATE TRIGGER before_update_user
BEFORE UPDATE ON `user`
FOR EACH ROW
BEGIN
IF new.user_level>90 OR new.user_level<0 THEN
SIGNAL SQLSTATE \’45000\’SET MESSAGE_TEXT = \’更新失败：用户等级不能大于90或小于0\’;
END IF;
END$$
DELIMITER ;
— 武器更新限制
drop trigger if exists before_update_weapon;
DELIMITER $$
CREATE TRIGGER before_update_weapon
BEFORE UPDATE ON `weapon`
FOR EACH ROW
BEGIN
IF new.weapon_level>90 OR new.weapon_level<0 THEN
— 如果大于100，则抛出错误
SIGNAL SQLSTATE \’45000\’
SET MESSAGE_TEXT = \’更新失败：武器等级不能大于90或小于0\’;
END IF;
END$$
DELIMITER ;
#以上关于MySQL实训的相关内容来源网络仅供参考，相关信息请以官方公告为准！
原创文章，作者：CSDN，如若转载，请注明出处：https://www.sudun.com/ask/92278.html
