MIGRATIONS

# This file is a quick reminder on how to update the database schema of the
# codebase. If you just want to upgrade the installed database, see UPGRADE.

* Edit Schema.pm and increment version number

* Make required changes to lib/GADS/Schema/Result/*

* Run dbic-migration prepare:

  DBIC_MIGRATION_USERNAME=xxx DBIC_MIGRATION_PASSWORD=xxx \
    dbic-migration -Ilib --schema_class='GADS::Schema' \
    --dsn='xxx' --force_overwrite --database MySQL \
    --database PostgreSQL --dbic_connect_attrs quote_names=1 prepare

* Change following text => citext columns in share/migrations/PostgreSQL/deploy/

calcval.value_text citext
calc_unique.value_text citext
daterange.value citext
enumval.value citext
string.value citext
user.email citext
user.username citext
user.value citext
team.name citext
organisation.name citext
department.name citext

* Copy permissions fixtures to new schema version

* Run dbic-migration upgrade or upgrade script:

  bin/migrate-db.pl