-- 1. 创建 users 表
CREATE TABLE IF NOT EXISTS public.users (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT,
    role TEXT,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) NOT NULL
);

-- 2. 开启行级安全 (RLS)
ALTER TABLE public.users ENABLE ROW LEVEL SECURITY;

-- 3. 创建允许所有操作的策略 (注意：仅供开发测试使用)
-- 允许匿名用户(anon)进行 SELECT, INSERT, UPDATE, DELETE
CREATE POLICY "Enable all operations for anon users" ON public.users
    FOR ALL 
    TO anon
    USING (true) 
    WITH CHECK (true);

-- 4. 插入一些测试数据
INSERT INTO public.users (name, email, role)
VALUES 
    ('Alice', 'alice@example.com', 'Admin'),
    ('Bob', 'bob@example.com', 'User'),
    ('Charlie', 'charlie@example.com', 'Editor');