internal/store/migrations/0015_releases.up.sql

 1CREATE TABLE releases (
 2    id         INTEGER PRIMARY KEY,
 3    repo_id    INTEGER NOT NULL REFERENCES repos(id) ON DELETE CASCADE,
 4    tag        TEXT NOT NULL,
 5    title      TEXT NOT NULL DEFAULT '',
 6    notes      TEXT NOT NULL DEFAULT '',
 7    author_id  INTEGER REFERENCES users(id) ON DELETE SET NULL,
 8    created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
 9    UNIQUE (repo_id, tag)
10);
11CREATE TABLE release_assets (
12    id          INTEGER PRIMARY KEY,
13    release_id  INTEGER NOT NULL REFERENCES releases(id) ON DELETE CASCADE,
14    name        TEXT NOT NULL,
15    size        INTEGER NOT NULL,
16    sha256      TEXT NOT NULL,
17    uploaded_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
18    UNIQUE (release_id, name)
19);