AkurAI-Build / migrations/012_git_parity_p2.sql

Latest change e8aa34a9be50d7d7ea72f66991ff82dfca7d23e1 - OLI-276: Git over SSH, forks and mirrors, code search through akurai-index, repository insights by Ólafur Búi Ólafsson

-- OLI-276: SSH keys per user, forks and mirrors.
CREATE TABLE ssh_keys (
    id INTEGER PRIMARY KEY,
    subject TEXT NOT NULL CHECK (length(subject) BETWEEN 1 AND 256),
    name TEXT NOT NULL CHECK (length(name) BETWEEN 1 AND 128),
    key_type TEXT NOT NULL CHECK (length(key_type) BETWEEN 1 AND 64),
    key_body TEXT NOT NULL UNIQUE CHECK (length(key_body) BETWEEN 1 AND 4096),
    fingerprint TEXT NOT NULL UNIQUE CHECK (length(fingerprint) BETWEEN 1 AND 128),
    created_at INTEGER NOT NULL DEFAULT (unixepoch()),
    last_used_at INTEGER
) STRICT;

CREATE INDEX ssh_keys_subject ON ssh_keys(subject);

ALTER TABLE repositories ADD COLUMN fork_of TEXT CHECK (fork_of IS NULL OR length(fork_of) BETWEEN 1 AND 64);
ALTER TABLE repositories ADD COLUMN mirror_of TEXT CHECK (mirror_of IS NULL OR length(mirror_of) BETWEEN 1 AND 2048);
ALTER TABLE repositories ADD COLUMN synced_at INTEGER;