init.sql

-- 1. 角色属性与招式帧数据表（驱动战斗数值）
CREATE TABLE fighter_moves (
    id SERIAL PRIMARY KEY,
    character_name VARCHAR(50) NOT NULL,
    move_name VARCHAR(50) NOT NULL,
    startup_frames INT NOT NULL,   -- 前摇帧
    active_frames INT NOT NULL,    -- 判定帧
    recovery_frames INT NOT NULL,  -- 后摇帧
    damage INT NOT NULL            -- 招式伤害
);

-- 2. 玩家战绩表（驱动胜率与战绩UI）
CREATE TABLE player_profiles (
    player_name VARCHAR(50) PRIMARY KEY,
    wins INT DEFAULT 0,
    losses INT DEFAULT 0
);

-- 插入测试招式数据 (Ryu 的重拳数据)
INSERT INTO fighter_moves (character_name, move_name, startup_frames, active_frames, recovery_frames, damage) 
VALUES ('Ryu', 'HeavyPunch', 5, 8, 12, 120);

-- 插入初始玩家战绩
INSERT INTO player_profiles (player_name, wins, losses) 
VALUES ('Player 1', 0, 0), ('Player 2', 0, 0)
ON CONFLICT DO NOTHING;