20170925205649-create-userip-table.js 395 B

12345678910111213141516171819
  1. 'use strict';
  2. module.exports = {
  3. up: (queryInterface, Sequelize) => {
  4. return queryInterface.createTable('UserIp', {
  5. createdAt: Sequelize.DATE,
  6. updatedAt: Sequelize.DATE,
  7. IpId: Sequelize.INTEGER,
  8. UserId: Sequelize.INTEGER
  9. }, {
  10. charset: 'utf8mb4'
  11. })
  12. },
  13. down: (queryInterface, Sequelize) => {
  14. return queryInterface.dropTable('UserIp');
  15. }
  16. };