diff options
| author | Egor Tensin <Egor.Tensin@gmail.com> | 2023-04-11 02:29:57 +0200 |
|---|---|---|
| committer | Egor Tensin <Egor.Tensin@gmail.com> | 2023-04-11 02:29:57 +0200 |
| commit | 85357ce9b82d595415f64c9ee3517627d158de2e (patch) | |
| tree | 56e29008040ae17d9a1756b3df1a7f0455b031e2 /src/sqlite | |
| parent | add .editorconfig (diff) | |
| download | cimple-85357ce9b82d595415f64c9ee3517627d158de2e.tar.gz cimple-85357ce9b82d595415f64c9ee3517627d158de2e.zip | |
actually create some tables in SQLite database
Diffstat (limited to 'src/sqlite')
| -rw-r--r-- | src/sqlite/v01.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/sqlite/v01.sql b/src/sqlite/v01.sql new file mode 100644 index 0000000..26869b6 --- /dev/null +++ b/src/sqlite/v01.sql @@ -0,0 +1,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; |