internal/store/migrations/0012_pins.up.sql

1CREATE TABLE repo_pins (
2    user_id  INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
3    repo_id  INTEGER NOT NULL REFERENCES repos(id) ON DELETE CASCADE,
4    pinned_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
5    PRIMARY KEY (user_id, repo_id)
6);