20180104141055-create-session-table.js 482 B

1234567891011121314151617181920212223
  1. 'use strict';
  2. module.exports = {
  3. up: (queryInterface, Sequelize) => {
  4. return queryInterface.createTable('sessions', {
  5. createdAt: Sequelize.DATE,
  6. updatedAt: Sequelize.DATE,
  7. sid: {
  8. type: Sequelize.STRING(32),
  9. primaryKey: true
  10. },
  11. expires: Sequelize.DATE,
  12. data: Sequelize.TEXT
  13. }, {
  14. charset: 'utf8mb4'
  15. })
  16. },
  17. down: (queryInterface, Sequelize) => {
  18. return queryInterface.dropTable('sessions');
  19. }
  20. };