const db = require("../../middleware/db");
const Sequelize = require("sequelize");
// 菜单表
module.exports = sys_menu = db.define("sys_menu", {
  // 菜单名称
  name: {
    type: Sequelize.STRING(100),
    allowNull: false,
    defaultValue: "",
    comment: "菜单名称",
  },

  // 父id
  parent_id: {
    type: Sequelize.INTEGER(11).UNSIGNED,
    allowNull: true,
    defaultValue: 0,
    comment: "父id",
  },

  // 图标
  icon: {
    type: Sequelize.STRING(100),
    allowNull: false,
    defaultValue: "",
    comment: "图标",
  },
  path: {
    type: Sequelize.STRING(255),
    allowNull: false,
    defaultValue: "",
    comment: "路径",
  },

  // 菜单类型   "菜单", "页面", "外链", "功能"
  type: {
    type: Sequelize.STRING(255),
    allowNull: false,
    defaultValue: "页面",
    comment: "菜单类型",
  },
  //模型id
  model_id: {
    type: Sequelize.INTEGER(11).UNSIGNED,
    allowNull: true,
    defaultValue: 0,
    comment: "模型id",
  },
  // 组件地址
  component: {
    type: Sequelize.STRING(100),
    allowNull: false,
    defaultValue: "",
    comment: "组件地址",
  },

  // api地址
  api_path: {
    type: Sequelize.STRING(100),
    allowNull: false,
    defaultValue: "",
    comment: "api地址",
  },
  // 是否显示在菜单中
  is_show_menu: {
    type: Sequelize.INTEGER(1),
    allowNull: false,
    defaultValue: true,
    comment: "是否显示在菜单中",
  },
  is_show: {
    type: Sequelize.INTEGER(1),
    allowNull: false,
    defaultValue: true,
    comment: "是否展示",
  },

  // 菜单类型
  sort: {
    type: Sequelize.INTEGER(11),
    allowNull: false,
    defaultValue: "0",
    comment: "菜单类型",
  },
});

// sys_menu.sync({ force: true })