app/db/migrations/20200526041323-create-vote.cjs
'use strict'
module.exports = {
up: (queryInterface, Sequelize) => {
return queryInterface.createTable('Votes', {
id: {
allowNull: false,
primaryKey: true,
type: Sequelize.STRING
},
data: {
type: Sequelize.JSON
},
created_at: {
allowNull: false,
type: Sequelize.DATE
},
updated_at: {
allowNull: false,
type: Sequelize.DATE
},
score: {
type: Sequelize.DOUBLE,
defaultValue: 0
},
street_id: {
type: Sequelize.STRING
},
voter_id: {
type: Sequelize.STRING
}
})
},
down: (queryInterface, Sequelize) => {
return queryInterface.dropTable('Votes')
}
}