diff options
| author | Omar Roth <omarroth@protonmail.com> | 2020-06-15 18:20:31 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@protonmail.com> | 2020-06-15 18:20:31 -0500 |
| commit | 074497b0f66b055b663015e3ed4d674d24b5b9cd (patch) | |
| tree | cf73b4b98025e5f076412df95139d2c5c653724f /config | |
| parent | 1eca969cf6b4096789014619285c98d1def40ee3 (diff) | |
| download | invidious-074497b0f66b055b663015e3ed4d674d24b5b9cd.tar.gz invidious-074497b0f66b055b663015e3ed4d674d24b5b9cd.tar.bz2 invidious-074497b0f66b055b663015e3ed4d674d24b5b9cd.zip | |
Add migration script for polymer redesign
Diffstat (limited to 'config')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-1eca969.sh | 19 |
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" |