blob: 26869b6229c58217a8f2e3b425764e889f757a0b (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE cimple_repositories (
id INTEGER PRIMARY KEY,
url TEXT NOT NULL UNIQUE
) STRICT;
CREATE TABLE cimple_runs (
id INTEGER PRIMARY KEY,
result INTEGER NOT NULL,
output BLOB NOT NULL,
repo_id INTEGER NOT NULL,
FOREIGN KEY (repo_id) REFERENCES cimple_repositories(id)
ON DELETE CASCADE ON UPDATE CASCADE
) STRICT;
|
