1-- Drop indexes
2DROP INDEX IF EXISTS idx_commits_created_at;
3DROP INDEX IF EXISTS idx_commits_sha;
4DROP INDEX IF EXISTS idx_commits_repo_id;
5DROP INDEX IF EXISTS idx_commits_author_id;
6
7-- Drop commits table
8DROP TABLE IF EXISTS commits;
9

1-- Create commits table
2CREATE TABLE IF NOT EXISTS commits (
3    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
4    author_id UUID NOT NULL REFERENCES users(id),
5    repo_id UUID NOT NULL REFERENCES repositories(id),
6    sha VARCHAR(40) NOT NULL,
7    message TEXT NOT NULL,
8    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
9    UNIQUE(repo_id, sha)
10);
11
12-- Create indexes for better query performance
13CREATE INDEX idx_commits_author_id ON commits(author_id);
14CREATE INDEX idx_commits_repo_id ON commits(repo_id);
15CREATE INDEX idx_commits_sha ON commits(sha);
16CREATE INDEX idx_commits_created_at ON commits(created_at);
17