summaryrefslogtreecommitdiffstats
path: root/config/migrate-scripts/migrate-db-1eca969.sh
diff options
context:
space:
mode:
authorPerflyst <mail@perflyst.de>2020-11-12 17:06:38 +0100
committerGitHub <noreply@github.com>2020-11-12 17:06:38 +0100
commitbb7d8735cbad7916b354412f965d48d886d2365e (patch)
tree4def28c6e8de906565d73b0c337d47b6a416e35a /config/migrate-scripts/migrate-db-1eca969.sh
parent1fc9506442ae18c7c7f0a684a59714e679678a54 (diff)
parent557b0d76abe978cd8044a48f89313ef805954713 (diff)
downloadinvidious-bb7d8735cbad7916b354412f965d48d886d2365e.tar.gz
invidious-bb7d8735cbad7916b354412f965d48d886d2365e.tar.bz2
invidious-bb7d8735cbad7916b354412f965d48d886d2365e.zip
Merge branch 'master' into patch-1
Diffstat (limited to 'config/migrate-scripts/migrate-db-1eca969.sh')
-rwxr-xr-xconfig/migrate-scripts/migrate-db-1eca969.sh19
1 files changed, 19 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-1eca969.sh b/config/migrate-scripts/migrate-db-1eca969.sh
new file mode 100755
index 00000000..f840d924
--- /dev/null
+++ b/config/migrate-scripts/migrate-db-1eca969.sh
@@ -0,0 +1,19 @@
+#!/bin/sh
+
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN title CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN views CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN likes CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN dislikes CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN wilson_score CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN published CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN description CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN language CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN author CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN ucid CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN allowed_regions CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN is_family_friendly CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN genre CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN genre_url CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN license CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN sub_count_text CASCADE"
+psql invidious kemal -c "ALTER TABLE videos DROP COLUMN author_thumbnail CASCADE"