about summary refs log tree commit diff
path: root/fun/tvldb/migrations
diff options
context:
space:
mode:
authorVincent Ambo <mail@tazj.in>2020-07-27T19·45+0100
committertazjin <mail@tazj.in>2020-07-27T23·54+0000
commit82ba28f1976305c1163adb5993745604ccb696cc (patch)
tree6d3887b3ffd1213461d8f612549bfaeda46a0657 /fun/tvldb/migrations
parentef54f5da9fa30b5c302f2a49595ee5d041f9706a (diff)
chore: Move //fun/tvldb -> //fun/paroxysm r/1496
Say ~my~ its name!

Change-Id: I7890318aef984af0f6bc011de32282f16e01cbb3
Reviewed-on: https://cl.tvl.fyi/c/depot/+/1483
Tested-by: BuildkiteCI
Reviewed-by: eta <eta@theta.eu.org>
Diffstat (limited to 'fun/tvldb/migrations')
-rw-r--r--fun/tvldb/migrations/20181209140247_initial/down.sql2
-rw-r--r--fun/tvldb/migrations/20181209140247_initial/up.sql15
-rw-r--r--fun/tvldb/migrations/20181218142013_fix_unique/down.sql1
-rw-r--r--fun/tvldb/migrations/20181218142013_fix_unique/up.sql1
4 files changed, 0 insertions, 19 deletions
diff --git a/fun/tvldb/migrations/20181209140247_initial/down.sql b/fun/tvldb/migrations/20181209140247_initial/down.sql
deleted file mode 100644
index aa02f4f63f92..000000000000
--- a/fun/tvldb/migrations/20181209140247_initial/down.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP TABLE entries;
-DROP TABLE keywords;
diff --git a/fun/tvldb/migrations/20181209140247_initial/up.sql b/fun/tvldb/migrations/20181209140247_initial/up.sql
deleted file mode 100644
index e8b52d5a9b91..000000000000
--- a/fun/tvldb/migrations/20181209140247_initial/up.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-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
deleted file mode 100644
index 291a97c5ce1f..000000000000
--- a/fun/tvldb/migrations/20181218142013_fix_unique/down.sql
+++ /dev/null
@@ -1 +0,0 @@
--- 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
deleted file mode 100644
index 4885ae5edefe..000000000000
--- a/fun/tvldb/migrations/20181218142013_fix_unique/up.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE keywords DROP CONSTRAINT IF EXISTS keywords_name_key;