From c3abbb5e2daeec07d03f1addd4a6c905af7a02ac Mon Sep 17 00:00:00 2001 From: eta Date: Mon, 15 Jun 2020 21:03:40 +0100 Subject: feat(tvldb): Import the tvldb/paroxysm source, add a Nix derivation - 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 --- fun/tvldb/migrations/20181209140247_initial/down.sql | 2 ++ fun/tvldb/migrations/20181209140247_initial/up.sql | 15 +++++++++++++++ 2 files changed, 17 insertions(+) create mode 100644 fun/tvldb/migrations/20181209140247_initial/down.sql create mode 100644 fun/tvldb/migrations/20181209140247_initial/up.sql (limited to 'fun/tvldb/migrations/20181209140247_initial') 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 +); -- cgit 1.4.1