1'use strict';
2module.exports = {
3 up: (queryInterface, Sequelize) => {
4 return queryInterface.createTable('Users', {
5 id: {
6 allowNull: false,
7 autoIncrement: true,
8 primaryKey: true,
9 type: Sequelize.INTEGER
10 },
11 username: {
12 type: Sequelize.STRING,
13 allowNull: false,
14 unique: true,
15 },
16 email: {
17 type: Sequelize.STRING,
18 allowNull: false,
19 unique: true,
20 },
21 passwordHash: {
22 type: Sequelize.STRING,
23 allowNull: false,
24 },
25 createdAt: {
26 allowNull: false,
27 type: Sequelize.DATE
28 },
29 updatedAt: {
30 allowNull: false,
31 type: Sequelize.DATE
32 }
33 });
34 },
35 down: (queryInterface, Sequelize) => {
36 return queryInterface.dropTable('Users');
37 }
38};