ALTER TABLE posts
ADD COLUMN reposted_id INTEGER NULL REFERENCES posts(id) ON DELETE SET NULL;