litebb/migrations/20200426121741-reply.js

1'use strict'; 2 3module.exports = { 4 up: (queryInterface, Sequelize) => { 5 return queryInterface.createTable('Replies', { 6 id: { 7 allowNull: false, 8 autoIncrement: true, 9 primaryKey: true, 10 type: Sequelize.INTEGER 11 }, 12 content: { 13 type: Sequelize.TEXT, 14 allowNull: false, 15 }, 16 postId: { 17 allowNull: false, 18 type: Sequelize.INTEGER, 19 references: { 20 model: 'Posts', 21 key: 'id' 22 } 23 }, 24 createdByUser: { 25 allowNull: false, 26 type: Sequelize.INTEGER, 27 references: { 28 model: 'Users', 29 key: 'id' 30 } 31 }, 32 createdAt: { 33 allowNull: false, 34 type: Sequelize.DATE 35 }, 36 updatedAt: { 37 allowNull: false, 38 type: Sequelize.DATE 39 } 40 }); 41 }, 42 down: (queryInterface, Sequelize) => { 43 return queryInterface.dropTable('Replies'); 44 } 45};