

CREATE TABLE hero (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(20) NOT NULL,
    title VARCHAR(30),
    position VARCHAR(10),
    gold_price INT,
    hp INT,
    attack INT
);


CREATE TABLE skill (
    id INT PRIMARY KEY AUTO_INCREMENT,
    hero_id INT NOT NULL,
    skill_name VARCHAR(30),
    skill_desc VARCHAR(100),
    FOREIGN KEY (hero_id) REFERENCES hero(id) ON DELETE CASCADE
);


CREATE TABLE item (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    price INT,
    attack_bonus INT DEFAULT 0,
    hp_bonus INT DEFAULT 0,
    cd_reduction INT DEFAULT 0
);


CREATE TABLE hero_item (
    hero_id INT NOT NULL,
    item_id INT NOT NULL,
    is_core TINYINT DEFAULT 0,
    PRIMARY KEY (hero_id, item_id),
    FOREIGN KEY (hero_id) REFERENCES hero(id) ON DELETE CASCADE,
    FOREIGN KEY (item_id) REFERENCES item(id) ON DELETE CASCADE
);


INSERT INTO hero (name, title, position, gold_price, hp, attack) VALUES
('亚瑟', '圣骑士', '战士', 8888, 3622, 168),
('妲己', '魅惑之狐', '法师', 8888, 3289, 162),
('鲁班七号', '机关造物', '射手', 8888, 3401, 175),
('李白', '青莲剑仙', '刺客', 18888, 3268, 172),
('王昭君', '冰雪之华', '法师', 8888, 3323, 159),
('典韦', '狂战士', '战士', 13888, 3728, 181),
('孙悟空', '齐天大圣', '刺客', 18888, 3293, 167),
('蔡文姬', '天籁弦音', '辅助', 13888, 3361, 150),
('吕布', '战神', '战士', 18888, 3749, 178),
('诸葛亮', '星之闪耀', '法师', 18888, 3255, 165);


INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(1, '圣光守护', '被动：每2秒回复2%最大生命值'),
(1, '誓约之盾', '强化普攻，沉默目标1秒'),
(1, '圣剑裁决', '举盾跳斩，造成范围伤害并击飞');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(2, '失心', '被动：技能命中减少目标魔抗'),
(2, '灵魂冲击', '发射冲击波，造成法术伤害'),
(2, '女王崇拜', '自动攻击附近敌人，最多5次');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(3, '火力压制', '第5次普攻变为扫射，造成3次伤害'),
(3, '河豚手雷', '投掷手雷，减速并造成物理伤害'),
(3, '空中支援', '召唤飞艇轰炸，造成范围伤害');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(4, '侠客行', '连续4次普攻解锁大招，增加攻击力'),
(4, '将进酒', '向指定方向突进，造成眩晕'),
(4, '青莲剑歌', '对范围内敌人造成5次斩击');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(5, '冰霜之心', '获得护盾，护盾破裂时对附近敌人造成冰冻'),
(5, '凋零冰晶', '造成法术伤害并减速'),
(5, '禁锢寒霜', '冰冻范围内敌人2.5秒');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(6, '激怒', '击杀或助攻永久增加攻击力'),
(6, '红眼', '移除控制效果，增加移速和攻速'),
(6, '嗜血', '对目标造成真实伤害并减速');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(7, '强击', '释放技能后强化下一次普攻'),
(7, '护身咒', '抵挡一次技能，成功则获得护盾'),
(7, '如意金箍', '旋转金箍棒，对周围敌人造成伤害');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(8, '长歌行', '每次技能命中回复友军生命值'),
(8, '思无邪', '弹奏乐曲，回复周围友军生命值'),
(8, '忘忧曲', '增加友军双抗并持续回复');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(9, '饕餮血统', '普攻和技能附带真实伤害并回复生命'),
(9, '方天画斩', '挥动方天画戟，造成范围真实伤害'),
(9, '魔神降世', '跳跃至指定区域，击飞敌人并减速');

INSERT INTO skill (hero_id, skill_name, skill_desc) VALUES
(10, '策谋之刻', '技能命中敌人叠加刻印，5层触发法球'),
(10, '东风破袭', '发射三颗法球，造成法术伤害'),
(10, '时空穿梭', '位移并产生法力场，造成减速');


INSERT INTO item (name, price, attack_bonus, hp_bonus, cd_reduction) VALUES
('暗影战斧', 2090, 85, 500, 15),
('无尽战刃', 2140, 130, 0, 0),
('破军', 2950, 180, 0, 0),
('贤者之书', 2990, 0, 0, 0),     
('极寒风暴', 2100, 0, 0, 20),  
('魔女斗篷', 2080, 0, 1000, 0),
('宗师之力', 2100, 80, 500, 0),
('闪电匕首', 1840, 40, 0, 0),
('不祥征兆', 2180, 0, 1200, 0),
('贤者的庇护', 2080, 0, 0, 0);  



INSERT INTO hero_item VALUES (1,1,1), (1,5,1), (1,7,0), (1,9,0);

INSERT INTO hero_item VALUES (2,4,1), (2,5,0);

INSERT INTO hero_item VALUES (3,2,1), (3,3,0), (3,8,1);

INSERT INTO hero_item VALUES (4,1,1), (4,3,1), (4,7,0);

INSERT INTO hero_item VALUES (5,4,1), (5,5,0);

INSERT INTO hero_item VALUES (6,1,1), (6,2,0), (6,7,1);

INSERT INTO hero_item VALUES (7,2,1), (7,7,1), (7,3,0);

INSERT INTO hero_item VALUES (8,5,0), (8,6,1), (8,10,0);

INSERT INTO hero_item VALUES (9,3,1), (9,5,0), (9,9,1);

INSERT INTO hero_item VALUES (10,4,1), (10,5,0);

INSERT INTO hero_item VALUES (1,2,0), (3,1,0), (5,10,0), (9,2,0), (10,6,0);