zero-downtime-02-new-column

'use strict';
 
const COLUMNS_TO_CHANGE = [
 ['table1',json_col],
 [table2,json_col],
 [table3,json_col],
 [table4,json_col],
];
 
 
exports.up = async (Knex) => {
 for (const tableColumnPair of COLUMNS_TO_CHANGE) {
   await Knex.schema.table(tableColumnPair[0], (table) => {
     table.jsonb(tableColumnPair[1] + '_jsonb');
   });
 }
};
 
exports.down = async (Knex) => {
 for (const tableColumnPair of COLUMNS_TO_CHANGE) {
   await Knex.schema.table(tableColumnPair[0], (table) => {
     table.dropColumn(tableColumnPair[1] + '_jsonb');
   });
 }
};
 
exports.config = {
 transaction: true
};