CREATE TABLE IF NOT EXISTS members (id uuid DEFAULT gen_random_uuid() PRIMARY KEY, name text, email text UNIQUE, tier text DEFAULT 'free', code text UNIQUE, joined_at timestamptz DEFAULT now(), last_login timestamptz);
CREATE TABLE IF NOT EXISTS tool_usage (id uuid DEFAULT gen_random_uuid() PRIMARY KEY, member_code text, tool_name text, used_at timestamptz DEFAULT now());
CREATE TABLE IF NOT EXISTS page_views (id uuid DEFAULT gen_random_uuid() PRIMARY KEY, page text, viewed_at timestamptz DEFAULT now());
ALTER TABLE members ENABLE ROW LEVEL SECURITY;
ALTER TABLE tool_usage ENABLE ROW LEVEL SECURITY;
ALTER TABLE page_views ENABLE ROW LEVEL SECURITY;
CREATE POLICY "pub_ins" ON members FOR INSERT WITH CHECK (true);
CREATE POLICY "pub_sel" ON members FOR SELECT USING (true);
CREATE POLICY "pub_upd" ON members FOR UPDATE USING (true);
CREATE POLICY "pub_ins_t" ON tool_usage FOR INSERT WITH CHECK (true);
CREATE POLICY "pub_sel_t" ON tool_usage FOR SELECT USING (true);
CREATE POLICY "pub_ins_v" ON page_views FOR INSERT WITH CHECK (true);
CREATE POLICY "pub_sel_v" ON page_views FOR SELECT USING (true);