summaryrefslogtreecommitdiffstats
path: root/config/migrate-scripts/migrate-db-1eca969.sh
blob: f840d924c5f0abdecfc0104e2a0eec847ebd4a12 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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"
lass='nohover-highlight'> 2021-04-16Fixes #173 - Instance list clicking issue.SimonBrazell 2021-04-16Prepare for release 1.1.47SimonBrazell 2021-04-10remove nitter.weaponizedhumiliation.comalefvanoon 2021-04-10add bird.trom.tfalefvanoon 2021-04-10add insta.trom.tfalefvanoon 2021-04-10add search.trom.tfalefvanoon 2021-04-09add searx.silkky.cloudalefvanoon 2021-04-09add libreddit.silkky.cloudalefvanoon 2021-04-09add some invidious insalefvanoon 2021-04-09add some invidious insalefvanoon 2021-04-09refactor: drop teddit image redirect supportJason Kim No longer redirect image links for teddit instances. Add a comment detailing the two issues I found. Now, the feature should be stable. 2021-04-09fix: don't redirect for rest of instancesJason Kim Unbreak old.reddit.com and i.reddit.com by ignoring image redirects for them. 2021-04-08fix: redirect teddit differentlyJason Kim Teddit image urls are different from libreddit. Handle each separately. Test manually: - libredd.it: pass - libreddit.spike.codes: pass - libreddit.kavin.rocks: pass - libreddit.insanity.wtf: fail (site doesn't work in general) - libreddit.dothq.co: pass - teddit.net: mostly fail - teddit.ggc-project.de: mostly fail - teddit.kavin.rocks: mostly fail - old.reddit.com: fail - i.reddit.com: fail - snew.notabug.io: fail (site doesn't work in general) Teddit image urls have two issues. First, the links almost never work (404) if the image url is visited directly before visiting the main page. Once the main page is visited, however, the image url starts working. I'm guessing this is an issue with teddit instances not fetching images unless the main page is accessed. Second, some image links are different/incompatible for some reason. For example, <https://i.redd.it/htg3owj12ok21.png> turns into <https://teddit.net/pics/w:null_TpEyuHnjif6578pV0lBuM-kNW1bXqxbvqbOHjhRZVr0.png>. Libreddit seems to not have this issue. 2021-04-08feat: add img prefix for i.redd.itJason Kim "i.redd.it/<imgfile>" redirects "libredd.it/<imgfile>". Make it redirect to "libredd.it/img/<imgfile>". Tested only for "libredd.it". 2021-04-08feat: add i.redd.it to reddit targetsJason Kim Add "i.redd.it" to list of urls to redirect for Reddit. Although the redirect works, the link should be invalid because it still needs an "img" path prefix. 2021-04-07Update Bibliogram instances listCadence Ember Set it to match the list of actually working instances. https://git.sr.ht/~cadence/bibliogram-docs/tree/master/docs/Instances.md 2021-04-05Update manifest.jsonHarsh Barsaiyan 2021-03-30Add ViewTubeHarsh Barsaiyan 2021-03-20Add Ecosia search engineCamille019 2021-03-11Add Whoogle SearchHarsh Barsaiyan 2021-03-02Disable SimplyTranslate redirects by defaultfattalion 2021-02-25Add SimplyTranslate supportfattalion 2021-02-24add invidious instanceAndrew Zhao