File size: 1,083 Bytes
81ff144 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | -- Audit Logs Table
CREATE TABLE IF NOT EXISTS audit_logs (
id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
user_id UUID REFERENCES auth.users(id),
agent_id UUID REFERENCES agents(id),
task_id UUID REFERENCES tasks(id),
action TEXT NOT NULL,
metadata JSONB,
created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Feedback Table for Fine-tuning
CREATE TABLE IF NOT EXISTS task_feedback (
id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
task_id UUID REFERENCES tasks(id) UNIQUE,
user_id UUID REFERENCES auth.users(id),
rating INT CHECK (rating IN (-1, 1)), -- -1 for dislike, 1 for like
comment TEXT,
created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Add RLS to new tables
ALTER TABLE audit_logs ENABLE ROW LEVEL SECURITY;
ALTER TABLE task_feedback ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Users can view their own audit logs" ON audit_logs
FOR SELECT USING (auth.uid() = user_id);
CREATE POLICY "Users can manage their own feedback" ON task_feedback
FOR ALL USING (auth.uid() = user_id);
|