user.model.js 949 B

1234567891011121314151617181920212223
  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. year: {type: Sequelize.INTEGER},
  16. password: {allowNull: false, type: Sequelize.STRING(256)},
  17. salt: {allowNull: false, type: Sequelize.STRING(64)},
  18. active: {allowNull: false, default: true, type: Sequelize.BOOLEAN},
  19. admin: {allowNull: false, default: false, type: Sequelize.BOOLEAN},
  20. });
  21. return User;
  22. }