-- 创建玩家表
CREATE TABLE IF NOT EXISTS players (
id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
name TEXT NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 创建惩罚任务表
CREATE TABLE IF NOT EXISTS punishments (
id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
task TEXT NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- 启用行级安全
ALTER TABLE players ENABLE ROW LEVEL SECURITY;
ALTER TABLE punishments ENABLE ROW LEVEL SECURITY;
-- 允许匿名访问
CREATE POLICY "Allow all on players" ON players FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "Allow all on punishments" ON punishments FOR ALL USING (true) WITH CHECK (true);
-- 刷新 API 缓存（重要！建表后必须执行）
NOTIFY pgrst, 'reload schema';