diff options
| author | eta <eta@theta.eu.org> | 2020-06-15T20·03+0100 |
|---|---|---|
| committer | eta <eta@theta.eu.org> | 2020-06-16T13·30+0000 |
| commit | c3abbb5e2daeec07d03f1addd4a6c905af7a02ac (patch) | |
| tree | 416ba1be719dd3ebbd15ee41b6f8a2c1b944bd43 /fun/tvldb/migrations | |
| parent | 4c22cf316933613215e83f70a6bb2c556d42e02c (diff) | |
feat(tvldb): Import the tvldb/paroxysm source, add a Nix derivation r/993
- This imports the tvldb (actually a thing called 'paroxysm') code from https://git.theta.eu.org/eta/paroxysm into the monorepo. - Additionally, I did a nix thing, yay! \o/ (well, with tazjin's help) - 3p/default.nix needed modifying to whitelist pgsql. Change-Id: Icdf13ca221650dde376f632bd2dd8a087af451bf Reviewed-on: https://cl.tvl.fyi/c/depot/+/389 Reviewed-by: tazjin <mail@tazj.in>
Diffstat (limited to 'fun/tvldb/migrations')
4 files changed, 19 insertions, 0 deletions
diff --git a/fun/tvldb/migrations/20181209140247_initial/down.sql b/fun/tvldb/migrations/20181209140247_initial/down.sql new file mode 100644 index 000000000000..aa02f4f63f92 --- /dev/null +++ b/fun/tvldb/migrations/20181209140247_initial/down.sql @@ -0,0 +1,2 @@ +DROP TABLE entries; +DROP TABLE keywords; diff --git a/fun/tvldb/migrations/20181209140247_initial/up.sql b/fun/tvldb/migrations/20181209140247_initial/up.sql new file mode 100644 index 000000000000..e8b52d5a9b91 --- /dev/null +++ b/fun/tvldb/migrations/20181209140247_initial/up.sql @@ -0,0 +1,15 @@ +CREATE TABLE keywords ( + id SERIAL PRIMARY KEY, + name VARCHAR UNIQUE NOT NULL, + chan VARCHAR NOT NULL, + UNIQUE(name, chan) +); + +CREATE TABLE entries ( + id SERIAL PRIMARY KEY, + keyword_id INT NOT NULL REFERENCES keywords ON DELETE CASCADE, + idx INT NOT NULL, + text VARCHAR NOT NULL, + creation_ts TIMESTAMP NOT NULL, + created_by VARCHAR NOT NULL +); diff --git a/fun/tvldb/migrations/20181218142013_fix_unique/down.sql b/fun/tvldb/migrations/20181218142013_fix_unique/down.sql new file mode 100644 index 000000000000..291a97c5ce1f --- /dev/null +++ b/fun/tvldb/migrations/20181218142013_fix_unique/down.sql @@ -0,0 +1 @@ +-- This file should undo anything in `up.sql` \ No newline at end of file diff --git a/fun/tvldb/migrations/20181218142013_fix_unique/up.sql b/fun/tvldb/migrations/20181218142013_fix_unique/up.sql new file mode 100644 index 000000000000..4885ae5edefe --- /dev/null +++ b/fun/tvldb/migrations/20181218142013_fix_unique/up.sql @@ -0,0 +1 @@ +ALTER TABLE keywords DROP CONSTRAINT IF EXISTS keywords_name_key; |