text: 'use strict';
  /*
   * @Author: yurui 
   * @Date: 2021-06-01
   */
  
  module.exports = {
    // 在执行数据库升级时调用的函数，创建 users 表
    up: async (queryInterface, Sequelize) => {
      const { INTEGER, DATE, STRING } = Sequelize;
      await queryInterface.createTable('users', {
        id: {
          allowNull: false,
          autoIncrement: true,
          primaryKey: true,
          type: INTEGER
        },
        deptId: {
          allowNull: false,
          type: INTEGER,
          comment: '部门deptId'
        },
        userName: {
          allowNull: false,
          unique: true,
          type: STRING,
          comment: '用户名'
        },
        nickName: {
          type: STRING,
          defaultValue: null,
          comment: '昵称'
        },
        sex: {
          type: STRING,
          defaultValue: '1',
          comment: '性别（0代表女 1代表男）'
        },
        password: {
          allowNull: false,
          type: STRING,
          comment: '密码'
        },
        avatar: {
          allowNull: true,
          type: STRING,
          defaultValue: null,
          comment: '头像'
        },
        email: {
          allowNull: true,
          type: STRING,
          comment: '邮箱'
        },
        mobile: {
          allowNull: true,
          type: STRING,
          comment: '手机号'
        },
        isDelete: {
          type: STRING,
          defaultValue: '0',
          comment: '删除标志（0代表存在 1代表删除）'
        },
        status: {
          type: STRING,
          defaultValue: '1',
          comment: '帐号状态（1正常 0停用）'
        },
        remark: {
          type: STRING,
          comment: '备注'
        },
        createdAt: {
          allowNull: true,
          type: DATE,
          comment: '创建时间'
        },
        createdBy: {
          allowNull: true,
          type: STRING,
          comment: '创建者'
        },
        updatedAt: {
          allowNull: true,
          type: DATE,
          comment: '更新时间'
        },
        updatedBy: {
          allowNull: true,
          type: STRING,
          comment: '更新者'
        }
      });
    },
    // 在执行数据库降级时调用的函数，删除 users 表
    down: async queryInterface => {
      await queryInterface.dropTable('users');
    },
  };