migrate-db-30e6d29.sh 273 B

12345678
  1. #!/bin/sh
  2. [ -z "$POSTGRES_USER" ] && POSTGRES_USER=kemal
  3. [ -z "$POSTGRES_DB" ] && POSTGRES_DB=invidious
  4. psql "$POSTGRES_DB" "$POSTGRES_USER" -c "ALTER TABLE channels ADD COLUMN deleted bool;"
  5. psql "$POSTGRES_DB" "$POSTGRES_USER" -c "UPDATE channels SET deleted = false;"