| 1 |
CREATE TABLE IF NOT EXISTS pending_uploads ( |
| 2 |
id UUID PRIMARY KEY DEFAULT gen_random_uuid(), |
| 3 |
user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
| 4 |
s3_key TEXT NOT NULL, |
| 5 |
bucket TEXT NOT NULL DEFAULT 'main', |
| 6 |
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW() |
| 7 |
); |
| 8 |
|
| 9 |
CREATE INDEX idx_pending_uploads_created_at ON pending_uploads(created_at); |
| 10 |
|