const db = require('../db');
const Sequelize = require('sequelize');

const User = db.define('users', {
  id: {
    type: Sequelize.INTEGER,
    allowNull: false,
    primaryKey: true,
    unique: true,
    autoIncrement: true,
  },
  email: {
    type: Sequelize.STRING,
    unique: true,
    validate: {
      isEmail: true,
    },
  },
  username: {
    type: Sequelize.STRING,
    unique: true,
  },
  name: {
    type: Sequelize.STRING,
  },
  password: {
    type: Sequelize.STRING,
  },
  role: {
    type: Sequelize.INTEGER,
  },
  trusted: {
    type: Sequelize.INTEGER,
  },
  avatar: {
    type: Sequelize.STRING,
  },
  googleID: {
    type: Sequelize.STRING,
    unique: true,
  },
  facebookID: {
    type: Sequelize.STRING,
    unique: true,
  },
  alias: {
    type: Sequelize.STRING,
  },
  subscription: {
    type: Sequelize.STRING,
  },
  created: {
    type: Sequelize.BIGINT,
  },
  modified: {
    type: Sequelize.BIGINT,
  }

});

module.exports = User;