user.model.js 912 B

12345678910111213141516171819202122
  1. /**
  2. * @file Provides the model for users.
  3. * @author Inigo Valentin
  4. * @since 4.0.0
  5. */
  6. module.exports = (sequelize, Sequelize) => {
  7. User = sequelize.define("user", {
  8. id: {allowNull: false, autoIncrement: true, primaryKey: true, type: Sequelize.INTEGER},
  9. username: {allowNull: false, unique: true, type: Sequelize.STRING(32)},
  10. displayname: {allowNull: false, unique: true, type: Sequelize.STRING(32)},
  11. email: {allowNull: false, unique: true, type: Sequelize.STRING(128)},
  12. firstName: {type: Sequelize.STRING(128)},
  13. lastName: {type: Sequelize.STRING(128)},
  14. image: {type: Sequelize.STRING(64)},
  15. password: {allowNull: false, type: Sequelize.STRING(256)},
  16. salt: {allowNull: false, type: Sequelize.STRING(64)},
  17. active: {allowNull: false, default: true, type: Sequelize.BOOLEAN},
  18. admin: {allowNull: false, default: false, type: Sequelize.BOOLEAN},
  19. });
  20. return User;
  21. }