migrations/20171009122058_movies.js
exports.up = function (knex) {
return knex.schema.createTableIfNotExists('movies', table => {
table.increments()
table.string('imdb_id')
table.date('release_date')
table.integer('runtime')
table.text('synopsis')
table.text('tagline')
table.string('title').notNullable()
table.string('tmdb_id')
table.string('year')
table.boolean('wilhelm')
})
}
exports.down = function (knex) {
return knex.schema.table('movies', table => {
table.dropColumns(
'imdb_id',
'release_date',
'runtime',
'synopsis',
'tagline',
'title',
'tmdb_id',
'year',
'wilhelm'
)
})
}