0_create_accounts.js

export default (schema) => {
  return {
    ...schema,
    accounts: {
      columns: {
        id: {type: "uuid", primary: true, defaultTo: "uuid4"},
        fullName: {type: "text", nullable: false, defaultTo: "", index: true},
        email: {type: "text", nullable: false, unique: true},
        active: {type: "boolean", nullable: false, defaultTo: false}
      }
    },
    indexes: {
      ...schema.indexes,
      accountsEmailAndFullName: {unique: true},
      accountsInactive: {query: `WHERE "accounts"."active" IS FALSE`}
    }
  }
}

1_add_name_to_accounts.js

export default (schema) => {
  return {
    ...schema,
    accounts: {
      ...schema.accounts,
      name: schema.accounts.fullName
    }
    indexes: {
      ...schema.indexes,
      accountsEmailAndFullName: {unique: true}
    }
  }
}

2_remove_full_name_from_accounts.js

import {omit} from "ramda"

export default (schema) => {
  return {
    ...schema,
    accounts: omit("fullName", schema.accounts),
    indexes: omit("accountsEmailAndFullName", schema.accounts)
  }
}

schema.json

{
  "accounts": {
    "columns": {
      "id": {
        "type": "uuid",
        "primary": true,
        "defaultTo": "uuid4"
      },
      "name": {
        "type": "text",
        "nullable": false,
        "defaultTo": ""
      },
      "email": {
        "type": "text",
        "nullable": false
      },
      "active": {
        "type": "boolean",
        "nullable": false,
        "defaultTo": false
      }
    } 
  },
  "indexes": {
    "accountsName": true,
    "accountsEmail": {
      "unique": true
    },
    "accountsEmailAndFullName": {
      "unique": true
    },
    "accountsInactive": {
      "query": "WHERE \"accounts\".\"active\" IS FALSE"
    }
  }
}