import * as Sequelize from 'sequelize' ; async function up ( utils ) { { const data = { type : Sequelize . BOOLEAN , allowNull : true , defaultValue : null } ; await utils . queryInterface . addColumn ( 'thumbnail' , 'automaticallyGenerated' , data ) ; } { const query = 'UPDATE thumbnail SET "automaticallyGenerated" = true WHERE "videoPlaylistId" IN ' + '(SELECT id FROM "videoPlaylist" WHERE type = 2)' ; await utils . sequelize . query ( query ) ; } } function down ( options ) { throw new Error ( 'Not implemented.' ) ; } export { up , down } ;