20170925202651-create-pollquestions-table.js 576 B

123456789101112131415161718192021222324252627
  1. 'use strict';
  2. module.exports = {
  3. up: (queryInterface, Sequelize) => {
  4. return queryInterface.createTable('PollQuestions', {
  5. id: {
  6. type: Sequelize.INTEGER,
  7. primaryKey: true,
  8. autoIncrement: true
  9. },
  10. createdAt: Sequelize.DATE,
  11. updatedAt: Sequelize.DATE,
  12. question: {
  13. type: Sequelize.STRING,
  14. allowNull: false
  15. },
  16. UserId: Sequelize.INTEGER
  17. }, {
  18. charset: 'utf8mb4'
  19. })
  20. },
  21. down: (queryInterface, Sequelize) => {
  22. return queryInterface.dropTable('PollQuestions');
  23. }
  24. };