summaryrefslogtreecommitdiffstats
path: root/server/migrations/20190413172133-change-externalid-type.js
blob: 665dcb0bb995ed3959decd76ad472ed45ee597c9 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.sequelize.transaction((t) => {
      return Promise.all([
        queryInterface.changeColumn('backend_x_client', 'externalId', {
          allowNull: false,
          type: Sequelize.STRING(128)
        }),
        queryInterface.changeColumn('backend_x_group', 'externalId', {
          allowNull: false,
          type: Sequelize.STRING(128)
        })
      ])
    })
  },

  down: (queryInterface, Sequelize) => {
    return queryInterface.sequelize.transaction((t) => {
      return Promise.all([
        queryInterface.changeColumn('backend_x_client', 'externalId', {
          allowNull: false,
          type: Sequelize.INTEGER
        }),
        queryInterface.changeColumn('backend_x_group', 'externalId', {
          allowNull: false,
          type: Sequelize.INTEGER
        })
      ])
    })
  }
}