server/migrations/20170821170955-BorrowedBook.js
module.exports = {
up(queryInterface, Sequelize) {
return queryInterface.createTable('BorrowedBooks', {
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,
type: Sequelize.INTEGER,
},
bookId: {
type: Sequelize.INTEGER,
},
userId: {
type: Sequelize.INTEGER,
},
returned: {
type: Sequelize.BOOLEAN,
defaultValue: false,
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
}
});
},
down(queryInterface /* , Sequelize */) {
return queryInterface.dropTable('BorrowedBooks');
}
};