server/migrations/20170821170951-create migration for user table.js
module.exports = {
up(queryInterface, Sequelize) {
return queryInterface.createTable('Users', {
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,
type: Sequelize.INTEGER,
},
firstName: {
type: Sequelize.STRING,
},
lastName: {
type: Sequelize.STRING,
},
email: {
allowNull: false,
type: Sequelize.STRING,
unique: true,
},
username: {
allowNull: false,
type: Sequelize.STRING,
unique: true,
},
password: {
allowNull: false,
type: Sequelize.STRING,
},
isAdmin: {
type: Sequelize.BOOLEAN,
defaultValue: false,
},
membershipType: {
allowNull: false,
type: Sequelize.ENUM('bronze', 'silver', 'gold'),
defaultValue: 'bronze',
},
passwordResetToken: {
type: Sequelize.STRING,
},
authId: {
type: Sequelize.STRING,
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
}
});
},
down(queryInterface /* , Sequelize */) {
return queryInterface.dropTable('Users');
}
};