--  Table structure for `business_page_component`
-- ----------------------------
CREATE TABLE `business_page_component` (
  `app_client_id` int(11) NOT NULL DEFAULT '0',
  `no` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(64) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `remark` varchar(255) DEFAULT NULL,
  `designer` text COMMENT '组件的json',
  PRIMARY KEY (`app_client_id`,`no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='页面组件';

-- ----------------------------
--  Table structure for `business_page_export_setting`
-- ----------------------------
CREATE TABLE `business_page_export_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `business_id` binary(8) NOT NULL,
  `page_id` binary(8) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `business_page_solution`
-- ----------------------------
CREATE TABLE `business_page_solution` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'system preset field',
  `data_status` int(11) NOT NULL DEFAULT '2' COMMENT 'system preset field',
  `created_at` int(11) DEFAULT '0' COMMENT 'system preset field',
  `created_by` int(11) NOT NULL DEFAULT '0' COMMENT 'system preset field',
  `updated_at` int(11) DEFAULT '0' COMMENT 'system preset field',
  `updated_by` int(11) DEFAULT '0' COMMENT 'system preset field',
  `page_id` binary(8) DEFAULT NULL COMMENT '页面id',
  `name` varchar(128) DEFAULT NULL COMMENT '方案名称',
  `is_share` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否共享',
  `data` text COMMENT '数据配置:{"is_display_count":true,"condition":"[[{},{}],[{}]]","display_field":"[]","sort_field":"[]"}',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='页面方案';

-- ----------------------------
--  Table structure for `business_page_type`
-- ----------------------------
CREATE TABLE `business_page_type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `app_client_id` int(11) DEFAULT NULL,
  `app_client_no` varchar(255) DEFAULT NULL,
  `no` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `remark` varchar(255) DEFAULT NULL,
  `designer` varchar(255) DEFAULT NULL COMMENT '页面设计器,用于前端路由跳转参数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `business_page_type`
-- ----------------------------
BEGIN;
INSERT INTO `business_page_type` VALUES ('1', '1', 'AdminPC', 'List', '普通列表页', '1', null, 'admin-pc-list'), ('2', '1', 'AdminPC', 'CatList', '带分类列表', '0', null, null), ('3', '1', 'AdminPC', 'TreeList', '树形列表', '0', null, 'admin-pc-tree-list'), ('4', '1', 'AdminPC', 'Detail', '详情页', '1', null, 'admin-pc-detail'), ('6', '1', 'AdminPC', 'Edit', '表单编辑页面', '1', null, null), ('7', '1', 'AdminPC', 'SelectorAdvanced', '高级选择器', '0', null, 'admin-pc-selector-advanced'), ('8', '1', 'AdminPC', 'TreeCatList', '带树形分类列表', '0', null, 'admin-pc-tree-cat-list'), ('9', '1', 'AdminPC', 'FormInformation', '表单基本信息', '0', null, 'admin-pc-form-information'), ('10', '1', 'AdminPC', 'FormEntryTree', '表单分录树', '0', null, 'admin-pc-form-entry_tree'), ('11', '1', 'AdminPC', 'FormEntry', '表单分录', '0', null, 'admin-pc-form-entry'), ('12', '1', 'AdminPC', 'Print', '打印模版', '1', null, 'admin-pc-print');
COMMIT;

-- ----------------------------
--  Table structure for `business_plugin`
-- ----------------------------
CREATE TABLE `business_plugin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` binary(8) NOT NULL,
  `is_enable` tinyint(1) DEFAULT '1',
  `name` varchar(255) DEFAULT NULL,
  `no` varchar(255) DEFAULT NULL,
  `operation` varchar(255) DEFAULT NULL,
  `entity` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `target_id` int(11) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `business_print_template`
-- ----------------------------
CREATE TABLE `business_print_template` (
  `id` binary(8) NOT NULL,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `business_id` binary(8) NOT NULL,
  `table` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `describe` varchar(255) DEFAULT NULL,
  `content` text,
  `is_enable` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `business_service`
-- ----------------------------
CREATE TABLE `business_service` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `business_table`
-- ----------------------------
CREATE TABLE `business_table` (
  `table` varchar(255) NOT NULL,
  `form_entity_id` binary(8) NOT NULL,
  `business_id` binary(8) DEFAULT NULL,
  `engine` varchar(255) DEFAULT 'InnoDB',
  `charset` varchar(255) DEFAULT 'utf8',
  `collate` varchar(255) DEFAULT 'utf8_general_ci',
  `is_build` tinyint(1) DEFAULT '0',
  `build_at` int(11) DEFAULT NULL,
  `update_build_at` int(11) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `is_required` tinyint(1) DEFAULT '1',
  `sort_order` int(11) DEFAULT '0',
  PRIMARY KEY (`table`),
  KEY `business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `business_table`
-- ----------------------------
BEGIN;
INSERT INTO `business_table` VALUES ('assist_bank_account', 0x626f6e5070455657, 0x436b4d6763656a68, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1581486984', '1581486984', '1581486921', '1581486984', '1', '0'), ('assist_cat', 0x5246483373725267, 0x4d353942764d4141, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1576838248', '1576838248', '1576833740', '1576838248', '1', '0'), ('assist_item', 0x7a714957556e7372, 0x6b516b544e313454, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1576837837', '1576837837', '1576833762', '1576837837', '1', '0'), ('assist_software_product', 0x7676713434674145, 0x6d50634c4c4e7756, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1578526565', '1578526565', '1578526263', '1578526565', '1', '0'), ('assist_software_product_module', 0x51334f305943504a, 0x43797a3575424575, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1587369943', '1587369943', '1587369457', '1587369943', '1', '0'), ('assist_software_product_version', 0x7835737366323465, 0x6d50634c4c4e7756, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1578526566', '1578526566', '1578526387', '1578526566', '1', '0'), ('business', 0x454e3731366f5651, 0x6d78325669766272, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590142425', '1590142425', '1', '0'), ('business_entity', 0x6f3538544957574d, 0x4c79325068313744, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590142828', '1590142828', '1', '0'), ('business_group', 0x4f316e6871475337, 0x757a59716c584555, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590144122', '1590144122', '1', '0'), ('business_index', 0x43387a696c6e4457, 0x696c625a30336971, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590143252', '1590143252', '1', '0'), ('business_operation', 0x66756a346a494c44, 0x4d4f554e305a4659, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590142632', '1590142632', '1', '0'), ('business_page', 0x6f673544794b7670, 0x4a346339675a6451, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590143422', '1590143422', '1', '0'), ('business_page_solution', 0x4668483550744253, 0x6d326f5571457a34, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1617013723', '1617013723', '1617013722', '1617013723', '1', '10000'), ('business_page_type', 0x77766f6467596d59, 0x6443594b334a3234, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590143642', '1590143642', '1', '0'), ('business_plugin', 0x676f6261616e4666, 0x6a744e6672424854, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590143878', '1590143878', '1', '0'), ('business_print_template', 0x554b33333934354e, 0x4c33694c74684545, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1590107113', '1590107113', '1590106445', '1590107113', '1', '0'), ('corp', 0x6e416d3635317453, 0x74694a6a32487079, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590144268', '1590144268', '1', '0'), ('corp_department', 0x4758326e63773745, 0x724f734275646351, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590144640', '1590144640', '1', '0'), ('corp_department_store', 0x52384d7267366a68, 0x724f734275646351, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1622861165', '1622861170', '1622860615', '1622861170', '1', '-1'), ('system_app', 0x67737276526d3055, 0x484b38416d535450, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590139589', '1590139589', '1', '0'), ('system_app_client', 0x68506c324d567775, 0x4a5a4d6373674741, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590140374', '1590140374', '1', '0'), ('system_app_client_user', 0x4849614a716c4957, 0x4172574b5075314a, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590140755', '1590140755', '1', '0'), ('system_app_menu', 0x4e356a706b306251, 0x6b5339663667554d, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590109898', '1590109898', '1', '0'), ('system_media', 0x576d347734393477, 0x5530734b30334d76, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590141062', '1590141062', '1', '0'), ('system_operation_log', 0x774e446247554639, 0x546f4b4c48474934, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1614323815', '1614323815', '1', '10000'), ('system_perm', 0x5656786e6c6c756f, 0x6e545a4c4f356136, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590141366', '1590141366', '1', '0'), ('system_role', 0x6a46326357675037, 0x786a433150326f50, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590141566', '1590141566', '1', '0'), ('system_setting', 0x4e49753272556e5a, 0x6c34546257703456, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1622452363', '1622454078', '1622452363', '1622454078', '1', '10000'), ('system_user', 0x4643463268377448, 0x6578455844796479, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1590141784', '1590141784', '1', '0'), ('system_user_login', 0x6d35387534704431, 0x6439596a6e727964, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1601258908', '1601258908', '1601258167', '1601258908', '1', '10000'), ('system_user_profile', 0x52763439476f5841, 0x6578455844796479, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1607415009', '1607415009', '1', '-1'), ('system_wxwork_external_contact', 0x557739704677426d, 0x446933477166556b, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1606718731', '1606718731', '1', '10000'), ('system_wxwork_external_contact_follow_user', 0x416b684b79793974, 0x5a624b73614f7a71, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1606718839', '1606718839', '1', '10000'), ('system_wxwork_external_contact_follow_user_tag', 0x58654e6f6c56446f, 0x6a535a49674f7664, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1606874982', '1606874982', '1', '10000'), ('system_wxwork_external_contact_tag', 0x6b57323536637837, 0x51634f314d525333, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1606875006', '1606875006', '1', '10000'), ('system_wxwork_external_contact_tag_group', 0x59355944306b5656, 0x4375677a6b445963, 'InnoDB', 'utf8', 'utf8_general_ci', '0', null, null, '1606875029', '1606875029', '1', '10000'), ('system_wxwork_external_contact_user', 0x4f6e59444d517256, 0x6d654777534d6469, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1607924816', '1607924816', '1607924710', '1607924816', '1', '10000'), ('task_schedule', 0x7135774a64654f74, 0x4f72695141695546, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1600671185', '1600671185', '1600669993', '1600671185', '1', '10000'), ('task_schedule_item', 0x7138423535597338, 0x4c6f49425a345172, 'InnoDB', 'utf8', 'utf8_general_ci', '1', '1600671676', '1600671676', '1600671220', '1600671676', '1', '10000');
COMMIT;

-- ----------------------------
--  Table structure for `comment`
-- ----------------------------
CREATE TABLE `comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` binary(8) NOT NULL,
  `table` varchar(255) DEFAULT NULL,
  `data_id` int(11) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `media_id` varchar(255) DEFAULT NULL,
  `like` int(11) DEFAULT '0',
  `reply_to` int(11) DEFAULT '0',
  `create_task` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `business_id` (`business_id`,`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='企业';

-- ----------------------------
--  Table structure for `comment_at`
-- ----------------------------
CREATE TABLE `comment_at` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `at_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `comment_id` (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `corp`
-- ----------------------------
CREATE TABLE `corp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '企业名称',
  `description` varchar(255) DEFAULT NULL COMMENT '企业简介',
  `is_self` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否自营',
  `is_enable` tinyint(3) unsigned NOT NULL COMMENT '是否可用',
  `wxwork_corpid` varchar(64) DEFAULT NULL COMMENT '企业微信的企业id',
  `wxwork_book_secret` varchar(255) DEFAULT NULL COMMENT '企业微信通讯录秘钥',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=807 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='企业';

-- ----------------------------
--  Records of `corp`
-- ----------------------------
BEGIN;
INSERT INTO `corp` VALUES ('1', '广州市信晨科技有限公司', '信晨', '1', '0', null, null, '1577790842', '1577791212'), ('12', '广州市有料科技有限公司', '有料', '0', '1', null, null, '1583813326', '1583813326');
COMMIT;

-- ----------------------------
--  Table structure for `corp_app_menu`
-- ----------------------------
CREATE TABLE `corp_app_menu` (
  `corp_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `is_enable` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用',
  PRIMARY KEY (`corp_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `corp_department`
-- ----------------------------
CREATE TABLE `corp_department` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '部门名称',
  `parent_id` int(10) unsigned NOT NULL COMMENT '上级部门id',
  `sort_order` smallint(5) unsigned NOT NULL COMMENT '排序',
  `corp_id` int(10) unsigned NOT NULL COMMENT '企业id',
  `path` varchar(32) NOT NULL COMMENT '部门层级路径',
  `level` tinyint(3) unsigned NOT NULL COMMENT '部门层级',
  `is_enable` tinyint(3) unsigned NOT NULL COMMENT '是否可用',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `wx_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IDX_PARENT_ID` (`parent_id`),
  KEY `IDX_CORP_ID` (`corp_id`),
  KEY `IDX_CORP_ID_PATH` (`corp_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=431 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门';

-- ----------------------------
--  Records of `corp_department`
-- ----------------------------
BEGIN;
INSERT INTO `corp_department` VALUES ('1', '广州信晨', '0', '0', '1', '1', '1', '1', '1586934315', '1616740725', '1'), ('2', '销售部', '1', '0', '1', '1,2', '2', '0', '1586934315', '1604473802', '2'), ('3', '实施部', '8', '0', '1', '1,8,3', '3', '0', '1586934315', '1604473802', '3'), ('4', '开发一部', '7', '0', '1', '1,7,4', '3', '1', '1586934315', '1616740725', '4'), ('5', '总经办', '1', '0', '1', '1,5', '2', '1', '1586934315', '1616740725', '6'), ('6', '财务部', '1', '0', '1', '1,6', '2', '1', '1586934315', '1616740725', '7'), ('7', '研发中心', '1', '0', '1', '1,7', '2', '1', '1586934315', '1616740725', '8'), ('8', '交付中心', '1', '0', '1', '1,8', '2', '0', '1586934315', '1604473802', '10'), ('9', '行政运营部', '1', '0', '1', '1,9', '2', '1', '1586934315', '1616740725', '11'), ('10', '运营部', '1', '0', '1', '1,10', '2', '0', '1586934316', '1586934316', '12'), ('11', '销售一部', '2', '0', '1', '1,2,11', '3', '0', '1586934316', '1597824775', '13'), ('12', '销售二部', '2', '0', '1', '1,2,12', '3', '0', '1586934316', '1604473802', '14'), ('13', '技术服务中心', '1', '0', '1', '1,13', '2', '1', '1586934316', '1616740725', '15'), ('14', '服务运维组', '13', '0', '1', '1,13,14', '3', '1', '1586934316', '1616740725', '16'), ('15', '营销部', '13', '0', '1', '1,13,15', '3', '0', '1586934316', '1597824775', '17'), ('16', '销售三部', '2', '0', '1', '1,2,16', '3', '0', '1586934316', '1597824775', '18'), ('17', '项目部', '9', '0', '1', '1,9,17', '3', '1', '1586934316', '1616740725', '20'), ('18', '客户成功部', '13', '0', '1', '1,13,18', '3', '0', '1586934316', '1597824775', '21'), ('19', '开发二部', '7', '0', '1', '1,7,19', '3', '1', '1586934316', '1616740725', '22'), ('20', '项目部', '7', '0', '1', '1,7,20', '3', '1', '1586934316', '1616740725', '23');
COMMIT;

-- ----------------------------
--  Table structure for `corp_department_store`
-- ----------------------------
CREATE TABLE `corp_department_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'system preset field',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'system preset field',
  `seq` int(11) NOT NULL DEFAULT '0' COMMENT 'system preset field',
  `province_id` int(11) DEFAULT NULL COMMENT '省',
  `city_id` int(11) DEFAULT NULL COMMENT '市',
  `district_id` int(11) DEFAULT NULL COMMENT '区',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='门店';

-- ----------------------------
--  Table structure for `corp_department_user`
-- ----------------------------
CREATE TABLE `corp_department_user` (
  `department_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `is_leader` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否部门负责人',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`department_id`,`user_id`),
  KEY `IDX_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门成员关系';

-- ----------------------------
--  Records of `corp_department_user`
-- ----------------------------
BEGIN;
INSERT INTO `corp_department_user` VALUES ('4', '66', '1', '1618373245', '1618373245'), ('7', '66', '1', '1618373245', '1618373245'), ('19', '66', '1', '1618373245', '1618373245'), ('19', '73', '0', '1618373246', '1618373246'), ('20', '66', '1', '1618373245', '1618373245');
COMMIT;

-- ----------------------------
--  Table structure for `corp_user`
-- ----------------------------
CREATE TABLE `corp_user` (
  `corp_id` int(11) unsigned NOT NULL COMMENT '所属企业',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `name` varchar(32) NOT NULL COMMENT '姓名',
  `mobile` char(11) NOT NULL COMMENT '手机号',
  `position` varchar(32) NOT NULL COMMENT '职务',
  `position_id` int(11) DEFAULT '0',
  `gender` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别：0未知 1男 2女',
  `email` varchar(32) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `alias` varchar(128) DEFAULT NULL COMMENT '成员别名',
  `is_enable` tinyint(3) unsigned NOT NULL COMMENT '是否可用：1可用 0禁用',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `is_leader` tinyint(1) DEFAULT '0',
  `cal_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`corp_id`,`user_id`),
  KEY `IDX_MOBILE` (`mobile`),
  KEY `IDX_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='企业成员';

-- ----------------------------
--  Records of `corp_user`
-- ----------------------------
BEGIN;
INSERT INTO `corp_user` VALUES ('1', '66', '涂**', '159****1771', '研发中心总监', '254', '1', 'jin*******@thincent.com', 'http://wework.qpic.cn/wwhead/duc2TvpEgSSWiaVLaJnssabjGahrAWvs98ZByyd4iaVOX0CVUR8Gg5APJ6iauJwP7JgGmmSpdlY1H8/0', '*', '1', '1', '1618373246', '1', 'wc99wqCAAAGzlzVxuithf4DRam8QwJJw'), ('1', '73', '熊**', '137****0871', '技术经理', '253', '1', 'xio*******@thincent.com', 'https://wework.qpic.cn/wwhead/duc2TvpEgSSWiaVLaJnssaYjaBJtIW4WzBGpTTABz8LeLkdhgkJmiaPpwMibtQHiaqH36v6YST5GPFk/0', '*', '1', '1', '1618373246', '0', 'wc99wqCAAAqfZ9jVp4bAJIdmfA9LtoDA'), ('207', '66', '涂**', '159****1771', '', '0', '0', '*******', '', '涂**', '1', '1604301061', '1604301061', '1', null), ('724', '73', 'x**', '137****0871', '', '0', '0', '*******', '', 'x**', '1', '1618822900', '1618822900', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `corp_wxwork`
-- ----------------------------
CREATE TABLE `corp_wxwork` (
  `corp_id` int(10) unsigned NOT NULL COMMENT '企业id',
  `wxwork_corpid` varchar(100) NOT NULL COMMENT '企业微信的企业id',
  `wxwork_book_secret` varchar(255) DEFAULT NULL COMMENT '企业微信通讯录密钥',
  PRIMARY KEY (`corp_id`),
  KEY `IDX_WXWORK_CORPID` (`wxwork_corpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `notice`
-- ----------------------------
CREATE TABLE `notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `message` varchar(1000) DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `created_at` int(11) DEFAULT NULL,
  `read_at` int(11) DEFAULT NULL COMMENT '阅读时间',
  `read_client` varchar(255) DEFAULT NULL COMMENT '阅读终端设备',
  `level` tinyint(1) DEFAULT '2' COMMENT '通知等级 次要1:SECONDARY 正常2:NORMAL 重要3:IMPORTANT',
  `ref_domain` varchar(255) DEFAULT NULL COMMENT '消息详细信息 关联的领域 如:\\domain\\workflow\\instance\\notice\\InstanceDetail  需要开放两个方法 fullMessage=>array linkUrl=>string',
  `ref_data` varchar(1000) DEFAULT NULL COMMENT 'JSON 数据,根据每个领域模型要求不同',
  `from_domain` varchar(255) DEFAULT NULL,
  `from_event` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `system_app`
-- ----------------------------
CREATE TABLE `system_app` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `secret` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_app`
-- ----------------------------
BEGIN;
INSERT INTO `system_app` VALUES ('1', 'heshuo', '河硕商贸门店维修管理后台', '12345678'), ('2', 'heshuo', '移动端', '12345678');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client`
-- ----------------------------
CREATE TABLE `system_app_client` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL COMMENT '应用端类型：1PC 2移动端H5 3微信小程序 4APP',
  `name` varchar(32) NOT NULL,
  `intro` varchar(200) DEFAULT NULL,
  `logo_path` varchar(128) DEFAULT NULL,
  `is_enable` tinyint(4) NOT NULL DEFAULT '0',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_APP_ID` (`app_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_app_client`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client` VALUES ('1', '1', '1', '河硕运营系统管理后台', null, null, '1', '0', '1', '1'), ('2', '2', '2', '河硕运营系统门户', '个人微信小程序', '/jdjdjdj', '1', '0', '1576258205', '1576258277'), ('3', '2', '3', '企业微信端', '企业微信小程序', null, '1', '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_user`
-- ----------------------------
CREATE TABLE `system_app_client_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `client_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '应用端ID',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `IDX_USER_ID` (`user_id`),
  KEY `IDX_CLIENT_ID` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1139 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='微信小程序用户';

-- ----------------------------
--  Records of `system_app_client_user`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_user` VALUES ('315', '66', '3', '1586166870', '1586166870'), ('332', '73', '3', '1586166870', '1586166870'), ('520', '73', '2', '1587437708', '1621407791'), ('972', '66', '2', '1600853907', '1621416807'), ('1123', '66', '2', '1616750469', '1616750516');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_wxapp`
-- ----------------------------
CREATE TABLE `system_app_client_wxapp` (
  `client_id` int(10) unsigned NOT NULL,
  `origin_id` varchar(64) DEFAULT NULL COMMENT '原始ID',
  `account` varchar(64) NOT NULL COMMENT '小程序帐号',
  `qrcode_path` varchar(255) DEFAULT NULL COMMENT '二维码路径',
  `appid` varchar(32) DEFAULT NULL COMMENT '小程序APP ID',
  `appsecret` varchar(64) DEFAULT NULL COMMENT '小程序APP Secret',
  `token` varchar(32) DEFAULT NULL COMMENT '通知token',
  `mchid` varchar(32) DEFAULT NULL COMMENT '微信支付商户ID',
  `apikey` varchar(32) DEFAULT NULL COMMENT '微信支付API秘钥',
  `ssl_cert_content` text COMMENT '微信支付证书',
  `ssl_key_content` text COMMENT '微信支付证书秘钥',
  `is_verify` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否验证通过，默认：0',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`client_id`),
  KEY `IDX_APPID` (`appid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='微信小程序端';

-- ----------------------------
--  Records of `system_app_client_wxapp`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_wxapp` VALUES ('2', null, '1111', null, 'wx65d27643716eca46', '9cea3c5a873332840567b59e6cfebf3e', null, null, null, null, null, '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_wxapp_user`
-- ----------------------------
CREATE TABLE `system_app_client_wxapp_user` (
  `client_user_id` int(11) unsigned NOT NULL COMMENT '应用端用户id',
  `unionid` varchar(64) DEFAULT NULL COMMENT '微信unionid',
  `openid` varchar(64) DEFAULT NULL COMMENT '微信openid',
  `session_key` varchar(64) DEFAULT NULL COMMENT '会话密钥',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`client_user_id`),
  KEY `IDX_UNIONID` (`unionid`),
  KEY `IDX_OPEN_ID` (`openid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='微信小程序用户';

-- ----------------------------
--  Records of `system_app_client_wxapp_user`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_wxapp_user` VALUES ('520', null, 'o6ToL49skgqGab6mDOZAo3yOPEOY', 'wuP2wacuSgJBkA5iOwPkBQ==', '1587437708', '1621588083'), ('972', null, 'o6ToL4-dGRLUrZjk8Q9h4eaLNkrY', 'G20PviAdMgcVTIM2PmlL3g==', '1600853907', '1621416806'), ('1123', null, 'o6ToL46m--0um5OhwOl7IwK3U2rE', 'Fq8zhFMX9w3gEV7cQtvFSw==', '1616750469', '1618372637');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_wxwork_app`
-- ----------------------------
CREATE TABLE `system_app_client_wxwork_app` (
  `client_id` int(10) unsigned NOT NULL,
  `origin_id` varchar(64) DEFAULT NULL COMMENT '原始ID',
  `account` varchar(64) NOT NULL COMMENT '小程序帐号',
  `qrcode_path` varchar(255) DEFAULT NULL COMMENT '二维码路径',
  `appid` varchar(32) DEFAULT NULL COMMENT '小程序APP ID',
  `appsecret` varchar(64) DEFAULT NULL COMMENT '小程序APP Secret',
  `token` varchar(32) DEFAULT NULL COMMENT '通知token',
  `mchid` varchar(32) DEFAULT NULL COMMENT '微信支付商户ID',
  `apikey` varchar(32) DEFAULT NULL COMMENT '微信支付API秘钥',
  `ssl_cert_content` text COMMENT '微信支付证书',
  `ssl_key_content` text COMMENT '微信支付证书秘钥',
  `is_verify` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否验证通过，默认：0',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`client_id`),
  KEY `IDX_APPID` (`appid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='企业微信小程序端';

-- ----------------------------
--  Records of `system_app_client_wxwork_app`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_wxwork_app` VALUES ('3', null, '1111', null, 'wx65d27643716eca46', '9cea3c5a873332840567b59e6cfebf3e', null, null, null, null, null, '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_wxwork_corp`
-- ----------------------------
CREATE TABLE `system_app_client_wxwork_corp` (
  `client_id` int(10) unsigned NOT NULL COMMENT '应用端id',
  `corpid` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT '企业id',
  `agentid` int(10) unsigned NOT NULL COMMENT '应用id',
  `secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '应用秘钥',
  `msg_secret` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` int(10) unsigned NOT NULL,
  `updated_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`client_id`,`corpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_app_client_wxwork_corp`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_wxwork_corp` VALUES ('3', 'wx7b4ff590b6270bac', '1000025', '9us06MGT_ucDLrztjcUre-dFBEAcQIs2X-tT6H3QZi4', 'biggnLQ7dKTQK_vYHZxMX-J8vkxONLwbMLZImya5wls', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_wxwork_department`
-- ----------------------------
CREATE TABLE `system_app_client_wxwork_department` (
  `corp_id` int(11) DEFAULT '1',
  `id` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `parentid` int(11) DEFAULT '0',
  `order` varchar(255) DEFAULT '0',
  KEY `corp_id` (`corp_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_app_client_wxwork_department`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_wxwork_department` VALUES ('1', '1', '广州信晨', null, '0', '2147483447'), ('1', '7', '财务部', null, '1', '99998500'), ('1', '6', '总经办', null, '1', '99999000'), ('1', '4', '开发一部', null, '8', '99999500'), ('1', '8', '研发中心', null, '1', '100000000'), ('1', '11', '行政运营部', null, '1', '99998000'), ('1', '15', '技术服务中心', null, '1', '2147486447'), ('1', '16', '服务运维组', null, '15', '100000000'), ('1', '20', '项目部', null, '11', '100000000'), ('1', '22', '开发二部', null, '8', '100000000'), ('1', '23', '项目部', null, '8', '100001000'), ('1', '25', '齐讯平台搭建', null, '11', '100001000'), ('1', '26', '事业部', null, '1', '2147487447'), ('1', '27', '第一事业部', null, '26', '100000000'), ('1', '28', '第二事业部', null, '26', '99999000'), ('1', '29', '第三事业部', null, '26', '99998000'), ('1', '30', '人事部', null, '1', '99997250');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_client_wxwork_user`
-- ----------------------------
CREATE TABLE `system_app_client_wxwork_user` (
  `client_user_id` int(11) unsigned NOT NULL COMMENT '应用端用户id',
  `corpid` varchar(64) DEFAULT NULL COMMENT '企业微信的企业id',
  `userid` varchar(64) DEFAULT NULL COMMENT '企业微信的用户id',
  `mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
  `session_key` varchar(64) DEFAULT NULL COMMENT '会话密钥',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`client_user_id`),
  KEY `IDX_CORPID_USERID` (`corpid`,`userid`),
  KEY `IDX_MOBILE` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='微信小程序用户';

-- ----------------------------
--  Records of `system_app_client_wxwork_user`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_client_wxwork_user` VALUES ('315', 'wx7b4ff590b6270bac', '15989191771', '15989191771', 'IHIC4hJQQ5vqXz6Pu/Tzlg==', '1586166870', '1618565856'), ('332', 'wx7b4ff590b6270bac', 'XiongYongHui', '13719100871', 'vKXZYtT1VcMGvQUX+PLuRw==', '1586166870', '1618552891');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_menu`
-- ----------------------------
CREATE TABLE `system_app_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `level` tinyint(3) unsigned NOT NULL COMMENT '菜单级次',
  `path` varchar(32) NOT NULL COMMENT '菜单结构路径',
  `name` varchar(32) NOT NULL COMMENT '菜单名称',
  `route` varchar(255) DEFAULT NULL COMMENT '菜单跳转路由',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '排序号',
  `is_enable` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用',
  `icon` varchar(255) DEFAULT NULL,
  `icon_color` varchar(255) DEFAULT NULL,
  `is_open` tinyint(3) DEFAULT '0',
  `created_at` int(10) unsigned NOT NULL DEFAULT '1',
  `updated_at` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_APP_ID` (`app_id`),
  KEY `IDX_PARENT_ID` (`parent_id`),
  KEY `route` (`route`)
) ENGINE=InnoDB AUTO_INCREMENT=340 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='应用菜单';

-- ----------------------------
--  Records of `system_app_menu`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_menu` VALUES ('1', '1', '0', '1', '1', '开发者平台', null, '99', '1', null, null, '0', '1577185097', '1577185912'), ('2', '1', '1', '2', '1,2', '业务对象设计', '/business-build/list', '1', '1', null, null, '0', '1577185155', '1577186306'), ('3', '1', '0', '1', '3', '辅助资料管理', null, '97', '1', null, null, '0', '1577185204', '1577185205'), ('4', '1', '3', '2', '3,4', '辅助资料 - 列表', '/business-form/list/kQkTN14T/O2kq6P2y', '2', '1', null, null, '0', '1577185220', '1577185220'), ('5', '1', '3', '2', '3,5', '辅助资料分类 - 列表', '/business-form/list/M59BvMAA/etUAb13C', '4', '1', null, null, '0', '1577185227', '1577185227'), ('12', '1', '1', '2', '1,12', '工作流设计', '/workflow/list', '2', '1', null, null, '0', '1', '1'), ('13', '1', '0', '1', '13', '系统管理', null, '96', '1', null, null, '0', '1', '1'), ('26', '1', '3', '2', '3,26', '辅助资料 - 新增', '/system/assist/item/0', '1', '1', null, null, '0', '1', '1'), ('27', '1', '3', '2', '3,27', '辅助资料分类 - 新增', '/system/assist/cat/0', '3', '1', null, null, '0', '1', '1'), ('38', '1', '1', '2', '1,38', '工作流实例', '/workflow/instance', '3', '1', null, null, '0', '1', '1'), ('49', '1', '13', '2', '13,49', '企业用户', '/system/corp', '1', '1', null, null, '0', '1', '1'), ('82', '1', '13', '2', '13,82', '角色权限', '/system/role/list', '2', '1', null, null, '0', '1', '1'), ('300', '1', '13', '2', '13,300', '操作日志', '/business-form/list/ToKLHGI4/xFChyBdn', '1', '1', null, null, '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `system_app_user_menu`
-- ----------------------------
CREATE TABLE `system_app_user_menu` (
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
  `app_id` int(10) unsigned NOT NULL COMMENT '应用ID',
  `menu_id` int(10) unsigned NOT NULL COMMENT '菜单ID',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`user_id`,`app_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户应用菜单';

-- ----------------------------
--  Records of `system_app_user_menu`
-- ----------------------------
BEGIN;
INSERT INTO `system_app_user_menu` VALUES ('1', '1', '2', '1'), ('1', '1', '4', '4'), ('1', '1', '5', '3'), ('1', '1', '12', '2'), ('1', '1', '22', '0'), ('1', '1', '82', '7'), ('1', '1', '300', '5');
COMMIT;

-- ----------------------------
--  Table structure for `system_media`
-- ----------------------------
CREATE TABLE `system_media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '文件名',
  `save_name` varchar(255) NOT NULL COMMENT '存储文件名',
  `type` tinyint(3) unsigned NOT NULL COMMENT '素材类型：1图片 2语音 3视频 4普通文件',
  `content_type` varchar(8) NOT NULL COMMENT '文件类型：jpg、png、txt、pdf等',
  `path` varchar(255) NOT NULL COMMENT '存储路径',
  `weight` int(10) unsigned NOT NULL COMMENT '文件大小',
  `size` varchar(32) DEFAULT NULL COMMENT '尺寸',
  `created_at` int(10) unsigned NOT NULL,
  `updated_at` int(10) unsigned NOT NULL,
  `created_by` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统素材';

-- ----------------------------
--  Table structure for `system_media_setting`
-- ----------------------------
CREATE TABLE `system_media_setting` (
  `variable_type` tinyint(3) unsigned NOT NULL COMMENT '变量类型：1.string 2.int 3.float 4.bool 5. json',
  `variable_name` varchar(64) NOT NULL COMMENT '变量名称',
  `variable_value` text NOT NULL COMMENT '变量值',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  `describe` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`variable_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='云存储全局设置';

-- ----------------------------
--  Records of `system_media_setting`
-- ----------------------------
BEGIN;
INSERT INTO `system_media_setting` VALUES ('1', 'cos_access_key_id', 'AKIDJPGsFtlTP7aoESpBlEVpw0vYx61gMBYf', '1576849242', '1576849242', null), ('1', 'cos_access_key_secret', '2ooWAYibEc7RWMvFL9i3UeZ9UaPzJvHO', '1576849242', '1576849242', null), ('1', 'cos_bucket', 'doms-1256871622', '1576849242', '1576849242', null), ('1', 'cos_endpoint', 'doms-1256871622.cos.ap-guangzhou.myqcloud.com', '1576849242', '1576849242', null), ('1', 'cos_pipeline_id', '', '1576849242', '1576849242', null), ('1', 'cos_region', 'ap-guangzhou', '1576849242', '1576849242', null), ('1', 'cos_template_id', '', '1576849242', '1576849242', null), ('1', 'oss_access_key_id', 'LTAIK26wU9xxEbNs', '1524042192', '1524055473', null), ('1', 'oss_access_key_secret', '8lTPaWFKWSkq4QPrc4lwrHMntvLxS7', '1524042192', '1524055473', null), ('1', 'oss_bucket', 'coolmall-test', '1524042192', '1524055473', null), ('1', 'oss_endpoint', 'coolmall-test.oss-cn-shenzhen.aliyuncs.com', '1524042192', '1524055473', null), ('1', 'oss_pipeline_id', '12', '1532963041', '1571668921', null), ('1', 'oss_region', 'oss-cn-shenzhen', '1524042192', '1524055473', null), ('1', 'oss_template_id', '12', '1532963041', '1571668921', null), ('1', 'platform', 'COS', '1576849242', '1576849264', null);
COMMIT;

-- ----------------------------
--  Table structure for `system_message_send`
-- ----------------------------
CREATE TABLE `system_message_send` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` char(8) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '业务对象id',
  `data_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '业务数据id',
  `to_users` varchar(1000) CHARACTER SET utf8 NOT NULL COMMENT '接收者id集合（系统用户）',
  `template_id` int(10) unsigned NOT NULL COMMENT '模板id',
  `template_type` tinyint(3) unsigned NOT NULL COMMENT '模板类型',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '发送状态：10待发送；20已发送；30发送失败',
  `content` text CHARACTER SET utf8 NOT NULL COMMENT '消息内容',
  `errmsg` text CHARACTER SET utf8 COMMENT '失败信息',
  `created_at` int(10) unsigned NOT NULL,
  `updated_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_TEMPLATE_ID` (`template_id`),
  KEY `IDX_TEMPLATE_TYPE` (`template_type`),
  KEY `IDX_STATUS` (`status`),
  KEY `IDX_BUSINESS_ID_DATA_ID` (`business_id`,`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='消息发送记录';

-- ----------------------------
--  Table structure for `system_message_template`
-- ----------------------------
CREATE TABLE `system_message_template` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `no` int(10) unsigned NOT NULL COMMENT '模板编号',
  `name` varchar(128) CHARACTER SET utf8 NOT NULL COMMENT '模板名称',
  `type` tinyint(3) unsigned NOT NULL COMMENT '消息类型：1微信小程序；2企业微信；3短信；4邮件',
  `business_id` char(8) COLLATE utf8_bin NOT NULL COMMENT '业务对象id',
  `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '模板描述',
  `to_users` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '接收者，多个接收者用“|”隔开',
  `content` text CHARACTER SET utf8 NOT NULL COMMENT '模板内容',
  `is_enable` tinyint(3) unsigned NOT NULL COMMENT '是否启用',
  `created_at` int(10) unsigned NOT NULL,
  `updated_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_NO` (`no`),
  KEY `IDX_BUSINESS_ID` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='消息模板';

-- ----------------------------
--  Table structure for `system_message_wxapp_template`
-- ----------------------------
CREATE TABLE `system_message_wxapp_template` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `client_id` int(10) DEFAULT NULL,
  `tid` varchar(25) NOT NULL COMMENT '微信模板编码',
  `priTmplId` varchar(250) DEFAULT NULL COMMENT '微信模板ID',
  `title` varchar(50) DEFAULT NULL COMMENT '微信模板标题',
  `content` varchar(255) DEFAULT NULL COMMENT '微信模板内容',
  `created_at` int(10) NOT NULL,
  `updated_at` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `system_operation_log`
-- ----------------------------
CREATE TABLE `system_operation_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_status` int(10) unsigned NOT NULL DEFAULT '2' COMMENT '数据状态',
  `client_id` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '端应用id',
  `business_id` binary(8) DEFAULT NULL COMMENT '对象ID',
  `business_operation` varchar(32) DEFAULT NULL COMMENT '对象操作',
  `ip` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT 'ip',
  `url` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '请求地址不含域名',
  `url_alias` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '请求地址对应的别名/模块',
  `action` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '请求方法:post,delete,put...',
  `body` longtext COMMENT '请求的body',
  `header` text CHARACTER SET utf8 COMMENT '请求头',
  `response_result` longtext COMMENT '响应返回',
  `remark` varchar(255) NOT NULL COMMENT '主动写的说明',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
  `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改人',
  PRIMARY KEY (`id`),
  KEY `client_id` (`client_id`,`created_at`),
  KEY `business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='操作日志';

-- ----------------------------
--  Table structure for `system_perm`
-- ----------------------------
CREATE TABLE `system_perm` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '权限名称',
  `app_id` int(10) unsigned NOT NULL COMMENT '应用id',
  `business_id` binary(8) DEFAULT NULL,
  `operation_id` binary(8) DEFAULT NULL,
  `route` varchar(128) DEFAULT NULL COMMENT '路由',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序号',
  `created_at` int(10) unsigned NOT NULL,
  `updated_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_APP_ID_ROUTE` (`app_id`,`route`)
) ENGINE=InnoDB AUTO_INCREMENT=4355 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统权限';

-- ----------------------------
--  Records of `system_perm`
-- ----------------------------
BEGIN;
INSERT INTO `system_perm` VALUES ('2', '创建', '1', 0x4d353942764d4141, 0x73556b414e746536, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('3', '删除', '1', 0x4d353942764d4141, 0x664e5a773337736e, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('4', '更新', '1', 0x4d353942764d4141, 0x4133733852787959, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('5', '启用', '1', 0x4d353942764d4141, 0x5963564c65533175, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('6', '禁用', '1', 0x4d353942764d4141, 0x717a6c7274455967, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('7', '作废', '1', 0x4d353942764d4141, 0x41643479666d7677, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('8', '导出', '1', 0x4d353942764d4141, 0x57643939504e394f, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('9', '导入', '1', 0x4d353942764d4141, 0x5276794c78305534, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('10', '详情', '1', 0x4d353942764d4141, 0x456547483071684d, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('11', '搜索', '1', 0x4d353942764d4141, 0x674c435033334974, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('12', '创建', '1', 0x6b516b544e313454, 0x645a324d65506a52, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('13', '删除', '1', 0x6b516b544e313454, 0x4377355844503338, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('14', '更新', '1', 0x6b516b544e313454, 0x4271523535494731, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('15', '启用', '1', 0x6b516b544e313454, 0x696a644c536c4749, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('16', '禁用', '1', 0x6b516b544e313454, 0x4b476e6b724f6c77, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('17', '作废', '1', 0x6b516b544e313454, 0x414551426d6a764d, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('18', '导出', '1', 0x6b516b544e313454, 0x6f56616a6f454131, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('19', '导入', '1', 0x6b516b544e313454, 0x7042463356686a73, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('20', '详情', '1', 0x6b516b544e313454, 0x577630556b457034, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('21', '搜索', '1', 0x6b516b544e313454, 0x6246557731335462, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('142', '创建', '1', 0x6d50634c4c4e7756, 0x7536314f58507944, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('143', '删除', '1', 0x6d50634c4c4e7756, 0x55324f4f4e524476, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('144', '更新', '1', 0x6d50634c4c4e7756, 0x4142353152596b41, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('145', '启用', '1', 0x6d50634c4c4e7756, 0x5867505671485167, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('146', '禁用', '1', 0x6d50634c4c4e7756, 0x4a356b42444a4a56, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('147', '作废', '1', 0x6d50634c4c4e7756, 0x4e696b43634b4364, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('148', '导出', '1', 0x6d50634c4c4e7756, 0x526c38666950724a, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('149', '导入', '1', 0x6d50634c4c4e7756, 0x41374c5442393870, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('150', '详情', '1', 0x6d50634c4c4e7756, 0x63764638375a7838, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('151', '搜索', '1', 0x6d50634c4c4e7756, 0x6e514b4265667a35, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('162', '创建', '1', 0x436b4d6763656a68, 0x5a6f3443696c6553, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('163', '删除', '1', 0x436b4d6763656a68, 0x6c386278617a756e, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('164', '更新', '1', 0x436b4d6763656a68, 0x46526b4453355368, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('165', '启用', '1', 0x436b4d6763656a68, 0x444d656d76443543, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('166', '禁用', '1', 0x436b4d6763656a68, 0x72736e466d557731, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('167', '作废', '1', 0x436b4d6763656a68, 0x7841746e34567674, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('168', '导出', '1', 0x436b4d6763656a68, 0x4c415a74744c5135, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('169', '导入', '1', 0x436b4d6763656a68, 0x6f49796831634a34, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('170', '详情', '1', 0x436b4d6763656a68, 0x797a6e5941555133, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('171', '搜索', '1', 0x436b4d6763656a68, 0x6c325441475a3057, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('292', '创建', '1', 0x43797a3575424575, 0x426554684f575073, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('293', '删除', '1', 0x43797a3575424575, 0x626a334d59737869, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('294', '更新', '1', 0x43797a3575424575, 0x7562527338556345, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('295', '启用', '1', 0x43797a3575424575, 0x705867684a437069, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('296', '禁用', '1', 0x43797a3575424575, 0x50596863784a6172, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('297', '作废', '1', 0x43797a3575424575, 0x75454e6a4938614b, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('298', '导出', '1', 0x43797a3575424575, 0x5249564254547a45, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('299', '导入', '1', 0x43797a3575424575, 0x734f4f4c6b375331, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('300', '详情', '1', 0x43797a3575424575, 0x4b57344e58306635, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('301', '搜索', '1', 0x43797a3575424575, 0x423347726175696e, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('302', '创建', '2', 0x4d353942764d4141, 0x6e385a496e4b6331, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('303', '删除', '2', 0x4d353942764d4141, 0x46373377796a7738, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('304', '更新', '2', 0x4d353942764d4141, 0x6469757149356352, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('305', '启用', '2', 0x4d353942764d4141, 0x526d794f6c7a526b, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('306', '禁用', '2', 0x4d353942764d4141, 0x6a436d4869354d4f, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('307', '作废', '2', 0x4d353942764d4141, 0x7836477864706f56, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('308', '导出', '2', 0x4d353942764d4141, 0x616b514d68364678, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('309', '导入', '2', 0x4d353942764d4141, 0x5231486f4a554454, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('310', '详情', '2', 0x4d353942764d4141, 0x49564a4e416b565a, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('311', '搜索', '2', 0x4d353942764d4141, 0x50766a7168356f37, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('312', '创建', '2', 0x6b516b544e313454, 0x5656456c58347463, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('313', '删除', '2', 0x6b516b544e313454, 0x4f6a4a4e56794549, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('314', '更新', '2', 0x6b516b544e313454, 0x4643554c7965504d, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('315', '启用', '2', 0x6b516b544e313454, 0x7169374e5a4c3642, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('316', '禁用', '2', 0x6b516b544e313454, 0x624f6b526b4f4847, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('317', '作废', '2', 0x6b516b544e313454, 0x4a46575867475672, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('318', '导出', '2', 0x6b516b544e313454, 0x486774497553504f, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('319', '导入', '2', 0x6b516b544e313454, 0x576d3158334d7441, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('320', '详情', '2', 0x6b516b544e313454, 0x744c427530616c4c, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('321', '搜索', '2', 0x6b516b544e313454, 0x4f546c6c78687744, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('442', '创建', '2', 0x6d50634c4c4e7756, 0x546673414f6a6630, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('443', '删除', '2', 0x6d50634c4c4e7756, 0x4370754a33716c6e, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('444', '更新', '2', 0x6d50634c4c4e7756, 0x76376d395170444f, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('445', '启用', '2', 0x6d50634c4c4e7756, 0x5870654a736c3653, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('446', '禁用', '2', 0x6d50634c4c4e7756, 0x5a53513130497745, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('447', '作废', '2', 0x6d50634c4c4e7756, 0x6b726d426b436534, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('448', '导出', '2', 0x6d50634c4c4e7756, 0x61497734546e5034, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('449', '导入', '2', 0x6d50634c4c4e7756, 0x697462564e784b58, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('450', '详情', '2', 0x6d50634c4c4e7756, 0x796c52636252336c, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('451', '搜索', '2', 0x6d50634c4c4e7756, 0x7a706a4534396978, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('462', '创建', '2', 0x436b4d6763656a68, 0x415a7a4632664e4c, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('463', '删除', '2', 0x436b4d6763656a68, 0x46673673516e785a, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('464', '更新', '2', 0x436b4d6763656a68, 0x564252495a6e6942, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('465', '启用', '2', 0x436b4d6763656a68, 0x47515633414b504f, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('466', '禁用', '2', 0x436b4d6763656a68, 0x6750787a76334f61, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('467', '作废', '2', 0x436b4d6763656a68, 0x6f48596e4e764f56, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('468', '导出', '2', 0x436b4d6763656a68, 0x737446445569596f, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('469', '导入', '2', 0x436b4d6763656a68, 0x456b494456305564, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('470', '详情', '2', 0x436b4d6763656a68, 0x7558517969397357, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('471', '搜索', '2', 0x436b4d6763656a68, 0x6b7a4b6e33483738, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('592', '创建', '2', 0x43797a3575424575, 0x6a545437356d6178, 'business/instance/form/operation/create', '0', '1587379486', '1587379486'), ('593', '删除', '2', 0x43797a3575424575, 0x44337272385a427a, 'business/instance/form/operation/delete', '0', '1587379486', '1587379486'), ('594', '更新', '2', 0x43797a3575424575, 0x69754e5357335163, 'business/instance/form/operation/update', '0', '1587379486', '1587379486'), ('595', '启用', '2', 0x43797a3575424575, 0x5761585531556845, 'business/instance/form/operation/enable', '0', '1587379486', '1587379486'), ('596', '禁用', '2', 0x43797a3575424575, 0x45544c4647534e43, 'business/instance/form/operation/disable', '0', '1587379486', '1587379486'), ('597', '作废', '2', 0x43797a3575424575, 0x564371684a6a4c33, 'business/instance/form/operation/invalid', '0', '1587379486', '1587379486'), ('598', '导出', '2', 0x43797a3575424575, 0x7073567159724b6f, 'business/instance/form/operation/export', '0', '1587379486', '1587379486'), ('599', '导入', '2', 0x43797a3575424575, 0x42324b4f66694561, 'business/instance/form/operation/import', '0', '1587379486', '1587379486'), ('600', '详情', '2', 0x43797a3575424575, 0x786f544c75474878, 'business/instance/form/operation/find-one', '0', '1587379486', '1587379486'), ('601', '搜索', '2', 0x43797a3575424575, 0x634b695671716653, 'business/instance/form/operation/search', '0', '1587379486', '1587379486'), ('2085', '搜索', '1', 0x5530734b30334d76, 0x4b36644c384d357a, 'system/media/search', '0', '1', '1'), ('2086', '详情', '1', 0x5530734b30334d76, 0x6176523934546d49, 'system/media/detail', '0', '1', '1'), ('2087', '创建', '1', 0x5530734b30334d76, 0x717352756d626146, 'system/media/create', '0', '1', '1'), ('2088', '更新', '1', 0x5530734b30334d76, 0x52704c484939775a, 'system/media/update', '0', '1', '1'), ('2089', '删除', '1', 0x5530734b30334d76, 0x756239727a6b7734, 'system/media/delete', '0', '1', '1'), ('2090', '搜索分页', '1', 0x6578455844796479, 0x446c4367705a3837, 'system/user/search-page', '0', '1', '1'), ('2091', '详情', '1', 0x6578455844796479, 0x726e553348507548, 'system/user/detail', '0', '1', '1'), ('2092', '创建', '1', 0x6578455844796479, 0x4847324a4c37584e, 'system/user/create', '0', '1', '1'), ('2093', '更新', '1', 0x6578455844796479, 0x6f6e4f6939573651, 'system/user/update', '0', '1', '1'), ('2094', '启用', '1', 0x6578455844796479, 0x6548634b4c416643, 'system/user/enable', '0', '1', '1'), ('2095', '禁用', '1', 0x6578455844796479, 0x494b4f6246784e4f, 'system/user/disable', '0', '1', '1'), ('2096', '设置角色', '1', 0x6578455844796479, 0x6c436a786c616559, 'system/user/roles', '0', '1', '1'), ('2097', '分配角色', '1', 0x6578455844796479, 0x44556e646a744658, 'system/user/assign-roles', '0', '1', '1'), ('2098', '搜索', '1', 0x786a433150326f50, 0x704d79703235536a, 'system/role/search', '0', '1', '1'), ('2099', '详情', '1', 0x786a433150326f50, 0x51454f5659675070, 'system/role/detail', '0', '1', '1'), ('2100', '创建', '1', 0x786a433150326f50, 0x4a3837734b777671, 'system/role/create', '0', '1', '1'), ('2101', '更新', '1', 0x786a433150326f50, 0x4254495039566746, 'system/role/update', '0', '1', '1'), ('2102', '删除', '1', 0x786a433150326f50, 0x6e5a664c586b5139, 'system/role/delete', '0', '1', '1'), ('2103', '权限', '1', 0x786a433150326f50, 0x524764716b485862, 'system/role/perms', '0', '1', '1'), ('2104', '设置权限', '1', 0x786a433150326f50, 0x415645574f483968, 'system/role/assign-perms', '0', '1', '1'), ('2105', '搜索', '1', 0x74694a6a32487079, 0x55786f51644e4649, 'corp/corp/search', '0', '1', '1'), ('2106', '详情', '1', 0x74694a6a32487079, 0x4249665558656d72, 'corp/corp/detail', '0', '1', '1'), ('2107', '创建', '1', 0x74694a6a32487079, 0x43747436766d4256, 'corp/corp/create', '0', '1', '1'), ('2108', '更新', '1', 0x74694a6a32487079, 0x674d41484c394935, 'corp/corp/update', '0', '1', '1'), ('2109', '启用', '1', 0x74694a6a32487079, 0x66614f7277736541, 'corp/corp/enable', '0', '1', '1'), ('2110', '禁用', '1', 0x74694a6a32487079, 0x5342524e49597764, 'corp/corp/disable', '0', '1', '1'), ('2111', '部门树', '1', 0x724f734275646351, 0x447276423731524b, 'corp/corp-department/tree', '0', '1', '1'), ('2112', '搜索', '1', 0x724f734275646351, 0x646b345067317532, 'corp/corp-department/search', '0', '1', '1'), ('2113', '创建', '1', 0x724f734275646351, 0x413051446f764639, 'corp/corp-department/create', '0', '1', '1'), ('2114', '更新', '1', 0x724f734275646351, 0x5a7059754954594b, 'corp/corp-department/update', '0', '1', '1'), ('2115', '删除', '1', 0x724f734275646351, 0x443253663436686e, 'corp/corp-department/delete', '0', '1', '1'), ('2116', '更改部门', '1', 0x724f734275646351, 0x4c665a4353646e68, 'corp/corp-department/move', '0', '1', '1'), ('2117', '启用', '1', 0x724f734275646351, 0x4c72317233495461, 'corp/corp-department/enable', '0', '1', '1'), ('2118', '禁用', '1', 0x724f734275646351, 0x72586e7452656637, 'corp/corp-department/disable', '0', '1', '1'), ('2119', '获取用户菜单树', '1', 0x6b5339663667554d, 0x6f7844336f736566, 'user-menu/tree', '0', '1', '1'), ('2120', '获取用户菜单', '1', 0x6b5339663667554d, 0x5362457677624743, 'user-menu/index', '0', '1', '1'), ('2121', '创建用户菜单', '1', 0x6b5339663667554d, 0x746674735854716d, 'user-menu/create', '0', '1', '1'), ('2122', '删除用户菜单', '1', 0x6b5339663667554d, 0x687846517273385a, 'user-menu/delete', '0', '1', '1'), ('2123', '移动用户菜单', '1', 0x6b5339663667554d, 0x6b703650575a6750, 'user-menu/move', '0', '1', '1'), ('2124', '搜索企业用户', '1', 0x74694a6a32487079, 0x755968513554304b, 'corp/corp-user/search', '0', '1', '1'), ('2125', '企业用户详情', '1', 0x74694a6a32487079, 0x444d537a4b696550, 'corp/corp-user/detail', '0', '1', '1'), ('2126', '创建企业用户', '1', 0x74694a6a32487079, 0x546b525655743276, 'corp/corp-user/create', '0', '1', '1'), ('2127', '更新企业用户', '1', 0x74694a6a32487079, 0x514e62644c6d5558, 'corp/corp-user/update', '0', '1', '1'), ('2128', '启用企业用户', '1', 0x74694a6a32487079, 0x41736e424a4e7a4d, 'corp/corp-user/enable', '0', '1', '1'), ('2129', '禁用企业用户', '1', 0x74694a6a32487079, 0x4653487a3542444b, 'corp/corp-user/disable', '0', '1', '1'), ('2130', '变更企业用户部门', '1', 0x74694a6a32487079, 0x486250566d644446, 'corp/corp-user/move-in-department', '0', '1', '1'), ('2131', '移除企业用户部门', '1', 0x74694a6a32487079, 0x79536b4950343832, 'corp/corp-user/remove-from-department', '0', '1', '1'), ('2132', '搜索企业用户按部门', '1', 0x74694a6a32487079, 0x42395959734b504a, 'corp/corp-user/search-by-department', '0', '1', '1'), ('2133', '企业用户设置为部门领导', '1', 0x74694a6a32487079, 0x4e65396369413050, 'corp/corp-user/set-leader', '0', '1', '1'), ('2134', '初始化企业应用端菜单', '1', 0x74694a6a32487079, 0x6943786e39324d46, 'corp/corp-app-menu/init', '0', '1', '1'), ('2135', '企业应用端菜单树', '1', 0x74694a6a32487079, 0x677536334f555a73, 'corp/corp-app-menu/tree', '0', '1', '1'), ('2136', '同步企业微信企业用户', '1', 0x724f734275646351, 0x536f73514b4e6c4d, 'corp/corp-department/sync-user', '0', '1', '1'), ('2137', '同步企业微信企业部门', '1', 0x724f734275646351, 0x62776458475a6734, 'corp/corp-department/sync-department', '0', '1', '1'), ('2138', '系统设置', '1', 0x6578455844796479, 0x7a30376c58703766, 'system/setting/index', '0', '1', '1'), ('2139', '系统设置更新', '1', 0x6578455844796479, 0x573634586f627544, 'system/setting/update', '0', '1', '1'), ('2140', '系统媒体设置详情', '1', 0x5530734b30334d76, 0x5278567354324571, 'system/media-setting/index', '0', '1', '1'), ('2141', '更新系统媒体设置', '1', 0x5530734b30334d76, 0x71556c6d556b3351, 'system/media-setting/update', '0', '1', '1'), ('2142', '编辑系统媒体设置', '1', 0x5530734b30334d76, 0x4967376e38557476, 'system/media-setting/ueditor', '0', '1', '1'), ('2143', '系统短信设置详情', '1', 0x5530734b30334d76, 0x557a74516c5a7a59, 'system/sms-setting/index', '0', '1', '1'), ('2144', '更新系统短信设置', '1', 0x5530734b30334d76, 0x6333386f6a554744, 'system/sms-setting/update', '0', '1', '1'), ('2145', '搜索', '1', 0x6578455844796479, 0x6d4f674a6441676e, 'system/user/search', '0', '1', '1'), ('2146', '角色权限树', '1', 0x786a433150326f50, 0x64424c7a7a6b6266, 'system/role-perm/tree', '0', '1', '1'), ('2147', '查找角色权限', '1', 0x786a433150326f50, 0x6e646f5479424277, 'system/role-perm/find-role-perm', '0', '1', '1'), ('2148', '更新角色权限', '1', 0x786a433150326f50, 0x5633456e47677855, 'system/role-perm/update-role-perm', '0', '1', '1'), ('2149', '应用端搜索', '1', 0x484b38416d535450, 0x774f547a6e666c45, 'system/app/search', '0', '1', '1'), ('2150', '应用端详情', '1', 0x484b38416d535450, 0x746379634b66666c, 'system/app/detail', '0', '1', '1'), ('2151', '创建应用端', '1', 0x484b38416d535450, 0x7048793043393874, 'system/app/create', '0', '1', '1'), ('2152', '更新应用端', '1', 0x484b38416d535450, 0x686878534e764b66, 'system/app/update', '0', '1', '1'), ('2153', '应用客户端搜索', '1', 0x484b38416d535450, 0x656d34694268656e, 'system/app-client/search', '0', '1', '1'), ('2154', '应用客户端详情', '1', 0x484b38416d535450, 0x5a65387664675745, 'system/app-client/detail', '0', '1', '1'), ('2155', '创建应用客户端', '1', 0x484b38416d535450, 0x595a5354424f7169, 'system/app-client/create', '0', '1', '1'), ('2156', '更新应用客户端', '1', 0x484b38416d535450, 0x766961615366336b, 'system/app-client/update', '0', '1', '1'), ('2157', '应用菜单树', '1', 0x6b5339663667554d, 0x566a73497168664d, 'system/app-menu/tree', '0', '1', '1'), ('2158', '创建应用菜单', '1', 0x6b5339663667554d, 0x7a4a6d664f6a6357, 'system/app-menu/create', '0', '1', '1'), ('2159', '更新应用菜单', '1', 0x6b5339663667554d, 0x4654667352766658, 'system/app-menu/update', '0', '1', '1'), ('2160', '删除应用菜单', '1', 0x6b5339663667554d, 0x69384c536e637167, 'system/app-menu/delete', '0', '1', '1'), ('2161', '移动应用菜单', '1', 0x6b5339663667554d, 0x514a484945526568, 'system/app-menu/move', '0', '1', '1'), ('2386', '搜索', '2', 0x74694a6a32487079, 0x6e356a5137754646, 'corp/corp/search', '0', '1', '1'), ('2387', '详情', '2', 0x74694a6a32487079, 0x6f70633570654757, 'corp/corp/detail', '0', '1', '1'), ('2388', '创建', '2', 0x74694a6a32487079, 0x754d494168317757, 'corp/corp/create', '0', '1', '1'), ('2389', '更新', '2', 0x74694a6a32487079, 0x515a58594d6d6c35, 'corp/corp/update', '0', '1', '1'), ('2390', '启用', '2', 0x74694a6a32487079, 0x745741306a444669, 'corp/corp/enable', '0', '1', '1'), ('2391', '禁用', '2', 0x74694a6a32487079, 0x6647757535675748, 'corp/corp/disable', '0', '1', '1'), ('2392', '部门树', '2', 0x724f734275646351, 0x7236757966436349, 'corp/corp-department/tree', '0', '1', '1'), ('2393', '搜索', '2', 0x724f734275646351, 0x4d514e5459564930, 'corp/corp-department/search', '0', '1', '1'), ('2394', '创建', '2', 0x724f734275646351, 0x7477744a6f357061, 'corp/corp-department/create', '0', '1', '1'), ('2395', '更新', '2', 0x724f734275646351, 0x6c6f4f3679363945, 'corp/corp-department/update', '0', '1', '1'), ('2396', '删除', '2', 0x724f734275646351, 0x6a34506a52457078, 'corp/corp-department/delete', '0', '1', '1'), ('2397', '更改部门', '2', 0x724f734275646351, 0x766b4b6c344d3432, 'corp/corp-department/move', '0', '1', '1'), ('2398', '启用', '2', 0x724f734275646351, 0x6f56497467416450, 'corp/corp-department/enable', '0', '1', '1'), ('2399', '禁用', '2', 0x724f734275646351, 0x6e6e586271675464, 'corp/corp-department/disable', '0', '1', '1'), ('2400', '搜索企业用户', '2', 0x74694a6a32487079, 0x426d7977476e6c4d, 'corp/corp-user/search', '0', '1', '1'), ('2401', '企业用户详情', '2', 0x74694a6a32487079, 0x4a494e475473444c, 'corp/corp-user/detail', '0', '1', '1'), ('2402', '创建企业用户', '2', 0x74694a6a32487079, 0x42317a7a7679746d, 'corp/corp-user/create', '0', '1', '1'), ('2403', '更新企业用户', '2', 0x74694a6a32487079, 0x5143575458636d63, 'corp/corp-user/update', '0', '1', '1'), ('2404', '启用企业用户', '2', 0x74694a6a32487079, 0x4943494132415768, 'corp/corp-user/enable', '0', '1', '1'), ('2405', '禁用企业用户', '2', 0x74694a6a32487079, 0x784c55695475486e, 'corp/corp-user/disable', '0', '1', '1'), ('2406', '变更企业用户部门', '2', 0x74694a6a32487079, 0x56774266454d494e, 'corp/corp-user/move-in-department', '0', '1', '1'), ('2407', '移除企业用户部门', '2', 0x74694a6a32487079, 0x5458334b776f364b, 'corp/corp-user/remove-from-department', '0', '1', '1'), ('2408', '搜索企业用户按部门', '2', 0x74694a6a32487079, 0x736c677449484e5a, 'corp/corp-user/search-by-department', '0', '1', '1'), ('2409', '企业用户设置为部门领导', '2', 0x74694a6a32487079, 0x6b6837624b323348, 'corp/corp-user/set-leader', '0', '1', '1'), ('2410', '初始化企业应用端菜单', '2', 0x74694a6a32487079, 0x4367384962576b71, 'corp/corp-app-menu/init', '0', '1', '1'), ('2411', '企业应用端菜单树', '2', 0x74694a6a32487079, 0x656b464f777a7a4f, 'corp/corp-app-menu/tree', '0', '1', '1'), ('2412', '搜索', '2', 0x6578455844796479, 0x7061564541577a64, 'system/user/search', '0', '1', '1'), ('2413', '搜索分页', '2', 0x6578455844796479, 0x6132434b6e6b6a62, 'system/user/search-page', '0', '1', '1'), ('2414', '详情', '2', 0x6578455844796479, 0x6171466b6151495a, 'system/user/detail', '0', '1', '1'), ('2415', '创建', '2', 0x6578455844796479, 0x7369457576417877, 'system/user/create', '0', '1', '1'), ('2416', '更新', '2', 0x6578455844796479, 0x584a4a4971746735, 'system/user/update', '0', '1', '1'), ('2417', '启用', '2', 0x6578455844796479, 0x4a48373148464276, 'system/user/enable', '0', '1', '1'), ('2418', '禁用', '2', 0x6578455844796479, 0x6d4e546475744d41, 'system/user/disable', '0', '1', '1'), ('2419', '设置角色', '2', 0x6578455844796479, 0x697979614965714d, 'system/user/roles', '0', '1', '1'), ('2420', '分配角色', '2', 0x6578455844796479, 0x664c485464354534, 'system/user/assign-roles', '0', '1', '1'), ('2421', '搜索', '2', 0x5530734b30334d76, 0x7764717345533842, 'system/media/search', '0', '1', '1'), ('2422', '详情', '2', 0x5530734b30334d76, 0x6e6f6b76436b3876, 'system/media/detail', '0', '1', '1'), ('2423', '创建', '2', 0x5530734b30334d76, 0x56684f384b6b6852, 'system/media/create', '0', '1', '1'), ('2424', '更新', '2', 0x5530734b30334d76, 0x5277707541347536, 'system/media/update', '0', '1', '1'), ('2425', '删除', '2', 0x5530734b30334d76, 0x564937306d305457, 'system/media/delete', '0', '1', '1'), ('2426', '创建', '1', 0x4c33694c74684545, 0x66544b716c38676f, 'business/instance/form/operation/create', '0', '1', '1'), ('2427', '创建', '2', 0x4c33694c74684545, 0x786b723744497a36, 'business/instance/form/operation/create', '0', '1', '1'), ('2428', '删除', '1', 0x4c33694c74684545, 0x555753757a41336d, 'business/instance/form/operation/delete', '0', '1', '1'), ('2429', '删除', '2', 0x4c33694c74684545, 0x773565585a50345a, 'business/instance/form/operation/delete', '0', '1', '1'), ('2430', '更新', '1', 0x4c33694c74684545, 0x6e707276746f5a52, 'business/instance/form/operation/update', '0', '1', '1'), ('2431', '更新', '2', 0x4c33694c74684545, 0x555a4d6a386e7a38, 'business/instance/form/operation/update', '0', '1', '1'), ('2432', '启用', '1', 0x4c33694c74684545, 0x6f684271454f3056, 'business/instance/form/operation/enable', '0', '1', '1'), ('2433', '启用', '2', 0x4c33694c74684545, 0x6d546a35486a3338, 'business/instance/form/operation/enable', '0', '1', '1'), ('2434', '禁用', '1', 0x4c33694c74684545, 0x45576479364f3771, 'business/instance/form/operation/disable', '0', '1', '1'), ('2435', '禁用', '2', 0x4c33694c74684545, 0x516c4a5574487562, 'business/instance/form/operation/disable', '0', '1', '1'), ('2436', '作废', '1', 0x4c33694c74684545, 0x626f39357a6d4a52, 'business/instance/form/operation/invalid', '0', '1', '1'), ('2437', '作废', '2', 0x4c33694c74684545, 0x5149486e38747078, 'business/instance/form/operation/invalid', '0', '1', '1'), ('2438', '导出', '1', 0x4c33694c74684545, 0x6b6d35664b626e6c, 'business/instance/form/operation/export', '0', '1', '1'), ('2439', '导入', '1', 0x4c33694c74684545, 0x566849366d4e3969, 'business/instance/form/operation/import', '0', '1', '1'), ('2440', '导入', '2', 0x4c33694c74684545, 0x76573854524f7677, 'business/instance/form/operation/import', '0', '1', '1'), ('2441', '详情', '1', 0x4c33694c74684545, 0x5269313877756664, 'business/instance/form/operation/find-one', '0', '1', '1'), ('2442', '详情', '2', 0x4c33694c74684545, 0x7279794468576d66, 'business/instance/form/operation/find-one', '0', '1', '1'), ('2443', '搜索', '1', 0x4c33694c74684545, 0x4537474568706a7a, 'business/instance/form/operation/search', '0', '1', '1'), ('2444', '搜索', '2', 0x4c33694c74684545, 0x6d54787170396e45, 'business/instance/form/operation/search', '0', '1', '1'), ('2445', '导出', '2', 0x4c33694c74684545, 0x45586554306b326b, 'business/instance/form/operation/export', '0', '1', '1'), ('2881', '创建', '1', 0x6439596a6e727964, 0x664b367267473158, 'business/instance/form/operation/create', '0', '1601258168', '1601258168'), ('2882', '创建', '2', 0x6439596a6e727964, 0x7a75416d685a6771, 'business/instance/form/operation/create', '0', '1601258168', '1601258168'), ('2883', '删除', '1', 0x6439596a6e727964, 0x6c736c4f4b624469, 'business/instance/form/operation/delete', '0', '1601258168', '1601258168'), ('2884', '删除', '2', 0x6439596a6e727964, 0x5930456c62626a33, 'business/instance/form/operation/delete', '0', '1601258168', '1601258168'), ('2885', '更新', '1', 0x6439596a6e727964, 0x664347346e477858, 'business/instance/form/operation/update', '0', '1601258168', '1601258168'), ('2886', '更新', '2', 0x6439596a6e727964, 0x704561323141525a, 'business/instance/form/operation/update', '0', '1601258168', '1601258168'), ('2887', '启用', '1', 0x6439596a6e727964, 0x6d526c5176655676, 'business/instance/form/operation/enable', '0', '1601258168', '1601258168'), ('2888', '启用', '2', 0x6439596a6e727964, 0x4f53355846415341, 'business/instance/form/operation/enable', '0', '1601258168', '1601258168'), ('2889', '禁用', '1', 0x6439596a6e727964, 0x6151665247776262, 'business/instance/form/operation/disable', '0', '1601258168', '1601258168'), ('2890', '禁用', '2', 0x6439596a6e727964, 0x4c344f6551314442, 'business/instance/form/operation/disable', '0', '1601258168', '1601258168'), ('2891', '作废', '1', 0x6439596a6e727964, 0x7a6f636255734768, 'business/instance/form/operation/invalid', '0', '1601258168', '1601258168'), ('2892', '作废', '2', 0x6439596a6e727964, 0x6a6155626a54707a, 'business/instance/form/operation/invalid', '0', '1601258168', '1601258168'), ('2893', '导出', '1', 0x6439596a6e727964, 0x517568534e674577, 'business/instance/form/operation/export', '0', '1601258168', '1601258168'), ('2894', '导出', '2', 0x6439596a6e727964, 0x56315a7156426634, 'business/instance/form/operation/export', '0', '1601258168', '1601258168'), ('2895', '导入', '1', 0x6439596a6e727964, 0x4446614c6b556766, 'business/instance/form/operation/import', '0', '1601258168', '1601258168'), ('2896', '导入', '2', 0x6439596a6e727964, 0x476c787459766f37, 'business/instance/form/operation/import', '0', '1601258168', '1601258168'), ('2897', '详情', '1', 0x6439596a6e727964, 0x5177775465794673, 'business/instance/form/operation/find-one', '0', '1601258168', '1601258168'), ('2898', '详情', '2', 0x6439596a6e727964, 0x4b4c456451613447, 'business/instance/form/operation/find-one', '0', '1601258168', '1601258168'), ('2899', '搜索', '1', 0x6439596a6e727964, 0x613035646c786371, 'business/instance/form/operation/search', '0', '1601258169', '1601258169'), ('2900', '搜索', '2', 0x6439596a6e727964, 0x586f4b696b675a4a, 'business/instance/form/operation/search', '0', '1601258169', '1601258169'), ('2901', '重置密码', '1', 0x6578455844796479, 0x50596f6c764e6557, 'account/reset-password', '0', '1601452735', '1601452735'), ('2902', '重置密码', '2', 0x6578455844796479, 0x4244773241615671, 'account/reset-password', '0', '1601452735', '1601452735'), ('2903', '删除用户角色', '1', 0x6578455844796479, 0x723333664f354f39, 'system/user/remove-role', '0', '1601452864', '1601452864'), ('2904', '删除用户角色', '2', 0x6578455844796479, 0x5654683949575266, 'system/user/remove-role', '0', '1601452864', '1601452864'), ('2905', '添加用户角色', '1', 0x6578455844796479, 0x427169687237384c, 'system/user/add-role', '0', '1601452950', '1601452950'), ('2906', '添加用户角色', '2', 0x6578455844796479, 0x64496a6d6f583832, 'system/user/add-role', '0', '1601452950', '1601452950'), ('2907', '分配多用户到角色', '1', 0x6578455844796479, 0x6936557233796238, 'system/user/assign-users-role', '0', '1601453045', '1601453045'), ('2908', '分配多用户到角色', '2', 0x6578455844796479, 0x715a555352446578, 'system/user/assign-users-role', '0', '1601453045', '1601453045'), ('2909', '查询用户登录日志', '1', 0x6578455844796479, 0x5162316a5a4b4149, 'system/user/serach-user-login', '0', '1601454123', '1601454123'), ('2910', '查询用户登录日志', '2', 0x6578455844796479, 0x644c39666c626574, 'system/user/serach-user-login', '0', '1601454123', '1601454123'), ('2911', '查找角色下用户', '1', 0x6578455844796479, 0x746c6e514f547767, 'system/user/find-role-user', '0', '1601454231', '1601454231'), ('2912', '查找角色下用户', '2', 0x6578455844796479, 0x477a57485a593171, 'system/user/find-role-user', '0', '1601454231', '1601454231'), ('3512', '创建', '1', 0x446933477166556b, 0x79425743596e786d, 'business/instance/form/operation/create', '0', '1606718731', '1606718731'), ('3513', '创建', '2', 0x446933477166556b, 0x54414f7448326236, 'business/instance/form/operation/create', '0', '1606718731', '1606718731'), ('3514', '删除', '1', 0x446933477166556b, 0x47626e526d524631, 'business/instance/form/operation/delete', '0', '1606718731', '1606718731'), ('3515', '删除', '2', 0x446933477166556b, 0x71466b6b6956586c, 'business/instance/form/operation/delete', '0', '1606718731', '1606718731'), ('3516', '更新', '1', 0x446933477166556b, 0x446874457a423668, 'business/instance/form/operation/update', '0', '1606718731', '1606718731'), ('3517', '更新', '2', 0x446933477166556b, 0x4d6564737639584d, 'business/instance/form/operation/update', '0', '1606718731', '1606718731'), ('3518', '启用', '1', 0x446933477166556b, 0x6364475a36556352, 'business/instance/form/operation/enable', '0', '1606718731', '1606718731'), ('3519', '启用', '2', 0x446933477166556b, 0x57474f6472646a68, 'business/instance/form/operation/enable', '0', '1606718731', '1606718731'), ('3520', '禁用', '1', 0x446933477166556b, 0x4158483565415431, 'business/instance/form/operation/disable', '0', '1606718731', '1606718731'), ('3521', '禁用', '2', 0x446933477166556b, 0x45765a7055384f6f, 'business/instance/form/operation/disable', '0', '1606718731', '1606718731'), ('3522', '作废', '1', 0x446933477166556b, 0x7745435959755732, 'business/instance/form/operation/invalid', '0', '1606718731', '1606718731'), ('3523', '作废', '2', 0x446933477166556b, 0x6e6c6347644f5037, 'business/instance/form/operation/invalid', '0', '1606718731', '1606718731'), ('3524', '导出', '1', 0x446933477166556b, 0x50594d6f4c77396d, 'business/instance/form/operation/export', '0', '1606718731', '1606718731'), ('3525', '导出', '2', 0x446933477166556b, 0x4f416c3430633078, 'business/instance/form/operation/export', '0', '1606718731', '1606718731'), ('3526', '导入', '1', 0x446933477166556b, 0x7959524f326d4171, 'business/instance/form/operation/import', '0', '1606718731', '1606718731'), ('3527', '导入', '2', 0x446933477166556b, 0x4a41786c3655504a, 'business/instance/form/operation/import', '0', '1606718731', '1606718731'), ('3528', '详情', '1', 0x446933477166556b, 0x6579416653747172, 'business/instance/form/operation/find-one', '0', '1606718731', '1606718731'), ('3529', '详情', '2', 0x446933477166556b, 0x5636754553316272, 'business/instance/form/operation/find-one', '0', '1606718731', '1606718731'), ('3530', '搜索', '1', 0x446933477166556b, 0x5344795532375256, 'business/instance/form/operation/search', '0', '1606718731', '1606718731'), ('3531', '搜索', '2', 0x446933477166556b, 0x6f3132764b4c3932, 'business/instance/form/operation/search', '0', '1606718731', '1606718731'), ('3532', '创建', '1', 0x5a624b73614f7a71, 0x4f4f54796e6f4344, 'business/instance/form/operation/create', '0', '1606718839', '1606718839'), ('3533', '创建', '2', 0x5a624b73614f7a71, 0x6e3056594c633658, 'business/instance/form/operation/create', '0', '1606718839', '1606718839'), ('3534', '删除', '1', 0x5a624b73614f7a71, 0x6532463554713266, 'business/instance/form/operation/delete', '0', '1606718839', '1606718839'), ('3535', '删除', '2', 0x5a624b73614f7a71, 0x493379535956775a, 'business/instance/form/operation/delete', '0', '1606718839', '1606718839'), ('3536', '更新', '1', 0x5a624b73614f7a71, 0x6250416c504a4642, 'business/instance/form/operation/update', '0', '1606718840', '1606718840'), ('3537', '更新', '2', 0x5a624b73614f7a71, 0x68666262666d4169, 'business/instance/form/operation/update', '0', '1606718840', '1606718840'), ('3538', '启用', '1', 0x5a624b73614f7a71, 0x6863314f51466b61, 'business/instance/form/operation/enable', '0', '1606718840', '1606718840'), ('3539', '启用', '2', 0x5a624b73614f7a71, 0x4162547a344a6852, 'business/instance/form/operation/enable', '0', '1606718840', '1606718840'), ('3540', '禁用', '1', 0x5a624b73614f7a71, 0x5036344144715077, 'business/instance/form/operation/disable', '0', '1606718840', '1606718840'), ('3541', '禁用', '2', 0x5a624b73614f7a71, 0x514e6d696f556f49, 'business/instance/form/operation/disable', '0', '1606718840', '1606718840'), ('3542', '作废', '1', 0x5a624b73614f7a71, 0x6961625673587350, 'business/instance/form/operation/invalid', '0', '1606718840', '1606718840'), ('3543', '作废', '2', 0x5a624b73614f7a71, 0x7751736d496f7443, 'business/instance/form/operation/invalid', '0', '1606718840', '1606718840'), ('3544', '导出', '1', 0x5a624b73614f7a71, 0x6571726976686b59, 'business/instance/form/operation/export', '0', '1606718840', '1606718840'), ('3545', '导出', '2', 0x5a624b73614f7a71, 0x523238714b576172, 'business/instance/form/operation/export', '0', '1606718840', '1606718840'), ('3546', '导入', '1', 0x5a624b73614f7a71, 0x4f6f686d4f67454c, 'business/instance/form/operation/import', '0', '1606718840', '1606718840'), ('3547', '导入', '2', 0x5a624b73614f7a71, 0x51524e6c7a315a68, 'business/instance/form/operation/import', '0', '1606718840', '1606718840'), ('3548', '详情', '1', 0x5a624b73614f7a71, 0x6b683776786c5a42, 'business/instance/form/operation/find-one', '0', '1606718840', '1606718840'), ('3549', '详情', '2', 0x5a624b73614f7a71, 0x733461584d665145, 'business/instance/form/operation/find-one', '0', '1606718840', '1606718840'), ('3550', '搜索', '1', 0x5a624b73614f7a71, 0x6147597033787141, 'business/instance/form/operation/search', '0', '1606718840', '1606718840'), ('3551', '搜索', '2', 0x5a624b73614f7a71, 0x7872626479755370, 'business/instance/form/operation/search', '0', '1606718840', '1606718840'), ('3554', '创建', '1', 0x6a535a49674f7664, 0x4e46336430716530, 'business/instance/form/operation/create', '0', '1606874982', '1606874982'), ('3555', '创建', '2', 0x6a535a49674f7664, 0x6376415839753352, 'business/instance/form/operation/create', '0', '1606874982', '1606874982'), ('3556', '删除', '1', 0x6a535a49674f7664, 0x536a337938543139, 'business/instance/form/operation/delete', '0', '1606874982', '1606874982'), ('3557', '删除', '2', 0x6a535a49674f7664, 0x614f747749574e57, 'business/instance/form/operation/delete', '0', '1606874982', '1606874982'), ('3558', '更新', '1', 0x6a535a49674f7664, 0x7a736b364b634c49, 'business/instance/form/operation/update', '0', '1606874982', '1606874982'), ('3559', '更新', '2', 0x6a535a49674f7664, 0x737766796a716967, 'business/instance/form/operation/update', '0', '1606874982', '1606874982'), ('3560', '启用', '1', 0x6a535a49674f7664, 0x466c303235706937, 'business/instance/form/operation/enable', '0', '1606874982', '1606874982'), ('3561', '启用', '2', 0x6a535a49674f7664, 0x72746a4a57436265, 'business/instance/form/operation/enable', '0', '1606874982', '1606874982'), ('3562', '禁用', '1', 0x6a535a49674f7664, 0x716171684e765447, 'business/instance/form/operation/disable', '0', '1606874982', '1606874982'), ('3563', '禁用', '2', 0x6a535a49674f7664, 0x53434f4867347753, 'business/instance/form/operation/disable', '0', '1606874982', '1606874982'), ('3564', '作废', '1', 0x6a535a49674f7664, 0x6b486b3777666f44, 'business/instance/form/operation/invalid', '0', '1606874982', '1606874982'), ('3565', '作废', '2', 0x6a535a49674f7664, 0x744a4e4155713151, 'business/instance/form/operation/invalid', '0', '1606874982', '1606874982'), ('3566', '导出', '1', 0x6a535a49674f7664, 0x496e4d6636584178, 'business/instance/form/operation/export', '0', '1606874982', '1606874982'), ('3567', '导出', '2', 0x6a535a49674f7664, 0x4e784a4b44517459, 'business/instance/form/operation/export', '0', '1606874982', '1606874982'), ('3568', '导入', '1', 0x6a535a49674f7664, 0x4157304b37463355, 'business/instance/form/operation/import', '0', '1606874982', '1606874982'), ('3569', '导入', '2', 0x6a535a49674f7664, 0x77457375675a4f42, 'business/instance/form/operation/import', '0', '1606874982', '1606874982'), ('3570', '详情', '1', 0x6a535a49674f7664, 0x78686733574c534c, 'business/instance/form/operation/find-one', '0', '1606874982', '1606874982'), ('3571', '详情', '2', 0x6a535a49674f7664, 0x43514a6272476172, 'business/instance/form/operation/find-one', '0', '1606874982', '1606874982'), ('3572', '搜索', '1', 0x6a535a49674f7664, 0x4373425155346767, 'business/instance/form/operation/search', '0', '1606874982', '1606874982'), ('3573', '搜索', '2', 0x6a535a49674f7664, 0x577536714e555952, 'business/instance/form/operation/search', '0', '1606874982', '1606874982'), ('3574', '创建', '1', 0x51634f314d525333, 0x4a394b6764765a6b, 'business/instance/form/operation/create', '0', '1606875006', '1606875006'), ('3575', '创建', '2', 0x51634f314d525333, 0x793162306d726957, 'business/instance/form/operation/create', '0', '1606875006', '1606875006'), ('3576', '删除', '1', 0x51634f314d525333, 0x41465466684a6f4c, 'business/instance/form/operation/delete', '0', '1606875006', '1606875006'), ('3577', '删除', '2', 0x51634f314d525333, 0x4f37545276664d47, 'business/instance/form/operation/delete', '0', '1606875006', '1606875006'), ('3578', '更新', '1', 0x51634f314d525333, 0x5348575753306e57, 'business/instance/form/operation/update', '0', '1606875006', '1606875006'), ('3579', '更新', '2', 0x51634f314d525333, 0x644d506474344764, 'business/instance/form/operation/update', '0', '1606875006', '1606875006'), ('3580', '启用', '1', 0x51634f314d525333, 0x7061655351306f67, 'business/instance/form/operation/enable', '0', '1606875006', '1606875006'), ('3581', '启用', '2', 0x51634f314d525333, 0x4b394d385736756b, 'business/instance/form/operation/enable', '0', '1606875006', '1606875006'), ('3582', '禁用', '1', 0x51634f314d525333, 0x7066556930315832, 'business/instance/form/operation/disable', '0', '1606875006', '1606875006'), ('3583', '禁用', '2', 0x51634f314d525333, 0x627355794d454856, 'business/instance/form/operation/disable', '0', '1606875006', '1606875006'), ('3584', '作废', '1', 0x51634f314d525333, 0x47446e5766786348, 'business/instance/form/operation/invalid', '0', '1606875006', '1606875006'), ('3585', '作废', '2', 0x51634f314d525333, 0x5257703076646a68, 'business/instance/form/operation/invalid', '0', '1606875006', '1606875006'), ('3586', '导出', '1', 0x51634f314d525333, 0x5961566557313649, 'business/instance/form/operation/export', '0', '1606875006', '1606875006'), ('3587', '导出', '2', 0x51634f314d525333, 0x4262514c7633436d, 'business/instance/form/operation/export', '0', '1606875006', '1606875006'), ('3588', '导入', '1', 0x51634f314d525333, 0x4b31593543775950, 'business/instance/form/operation/import', '0', '1606875006', '1606875006'), ('3589', '导入', '2', 0x51634f314d525333, 0x5459434f43527a70, 'business/instance/form/operation/import', '0', '1606875006', '1606875006'), ('3590', '详情', '1', 0x51634f314d525333, 0x47324d7865686f58, 'business/instance/form/operation/find-one', '0', '1606875006', '1606875006'), ('3591', '详情', '2', 0x51634f314d525333, 0x566a377274594e42, 'business/instance/form/operation/find-one', '0', '1606875006', '1606875006'), ('3592', '搜索', '1', 0x51634f314d525333, 0x67524a45555a6877, 'business/instance/form/operation/search', '0', '1606875006', '1606875006'), ('3593', '搜索', '2', 0x51634f314d525333, 0x496a4532574c4e45, 'business/instance/form/operation/search', '0', '1606875006', '1606875006'), ('3594', '创建', '1', 0x4375677a6b445963, 0x4e626e6776576553, 'business/instance/form/operation/create', '0', '1606875030', '1606875030'), ('3595', '创建', '2', 0x4375677a6b445963, 0x775853374b6c4249, 'business/instance/form/operation/create', '0', '1606875030', '1606875030'), ('3596', '删除', '1', 0x4375677a6b445963, 0x7246366558726871, 'business/instance/form/operation/delete', '0', '1606875030', '1606875030'), ('3597', '删除', '2', 0x4375677a6b445963, 0x6e63304f4f347162, 'business/instance/form/operation/delete', '0', '1606875030', '1606875030'), ('3598', '更新', '1', 0x4375677a6b445963, 0x61316b6258586d33, 'business/instance/form/operation/update', '0', '1606875030', '1606875030'), ('3599', '更新', '2', 0x4375677a6b445963, 0x647665464e466c6f, 'business/instance/form/operation/update', '0', '1606875030', '1606875030'), ('3600', '启用', '1', 0x4375677a6b445963, 0x4d48707a4e397832, 'business/instance/form/operation/enable', '0', '1606875030', '1606875030'), ('3601', '启用', '2', 0x4375677a6b445963, 0x6a546a5775385347, 'business/instance/form/operation/enable', '0', '1606875030', '1606875030'), ('3602', '禁用', '1', 0x4375677a6b445963, 0x575a453955794d34, 'business/instance/form/operation/disable', '0', '1606875030', '1606875030'), ('3603', '禁用', '2', 0x4375677a6b445963, 0x4d5574656b413552, 'business/instance/form/operation/disable', '0', '1606875030', '1606875030'), ('3604', '作废', '1', 0x4375677a6b445963, 0x7874655362736834, 'business/instance/form/operation/invalid', '0', '1606875030', '1606875030'), ('3605', '作废', '2', 0x4375677a6b445963, 0x5a634a695544625a, 'business/instance/form/operation/invalid', '0', '1606875030', '1606875030'), ('3606', '导出', '1', 0x4375677a6b445963, 0x4235474a50414168, 'business/instance/form/operation/export', '0', '1606875030', '1606875030'), ('3607', '导出', '2', 0x4375677a6b445963, 0x50626f494551745a, 'business/instance/form/operation/export', '0', '1606875030', '1606875030'), ('3608', '导入', '1', 0x4375677a6b445963, 0x49586b4969614232, 'business/instance/form/operation/import', '0', '1606875030', '1606875030'), ('3609', '导入', '2', 0x4375677a6b445963, 0x74487a446c424c49, 'business/instance/form/operation/import', '0', '1606875030', '1606875030'), ('3610', '详情', '1', 0x4375677a6b445963, 0x744c423933377050, 'business/instance/form/operation/find-one', '0', '1606875030', '1606875030'), ('3611', '详情', '2', 0x4375677a6b445963, 0x7358584264466a41, 'business/instance/form/operation/find-one', '0', '1606875030', '1606875030'), ('3612', '搜索', '1', 0x4375677a6b445963, 0x796c573261715a4b, 'business/instance/form/operation/search', '0', '1606875030', '1606875030'), ('3613', '搜索', '2', 0x4375677a6b445963, 0x714a6f4a4e4d3062, 'business/instance/form/operation/search', '0', '1606875030', '1606875030'), ('3614', '创建', '1', 0x6d654777534d6469, 0x7253377a486f5767, 'business/instance/form/operation/create', '0', '1607924710', '1607924710'), ('3615', '创建', '2', 0x6d654777534d6469, 0x614a3376434d5559, 'business/instance/form/operation/create', '0', '1607924711', '1607924711'), ('3616', '删除', '1', 0x6d654777534d6469, 0x6e554c686f685932, 'business/instance/form/operation/delete', '0', '1607924711', '1607924711'), ('3617', '删除', '2', 0x6d654777534d6469, 0x74544b5461493272, 'business/instance/form/operation/delete', '0', '1607924711', '1607924711'), ('3618', '更新', '1', 0x6d654777534d6469, 0x72327a325a696338, 'business/instance/form/operation/update', '0', '1607924711', '1607924711'), ('3619', '更新', '2', 0x6d654777534d6469, 0x7a63336474336655, 'business/instance/form/operation/update', '0', '1607924711', '1607924711'), ('3620', '启用', '1', 0x6d654777534d6469, 0x4e42556c65724d71, 'business/instance/form/operation/enable', '0', '1607924711', '1607924711'), ('3621', '启用', '2', 0x6d654777534d6469, 0x714861526e385942, 'business/instance/form/operation/enable', '0', '1607924711', '1607924711'), ('3622', '禁用', '1', 0x6d654777534d6469, 0x703634487a454649, 'business/instance/form/operation/disable', '0', '1607924711', '1607924711'), ('3623', '禁用', '2', 0x6d654777534d6469, 0x4a53436c6a743936, 'business/instance/form/operation/disable', '0', '1607924711', '1607924711'), ('3624', '作废', '1', 0x6d654777534d6469, 0x474c634437523337, 'business/instance/form/operation/invalid', '0', '1607924711', '1607924711'), ('3625', '作废', '2', 0x6d654777534d6469, 0x7332493978346839, 'business/instance/form/operation/invalid', '0', '1607924711', '1607924711'), ('3626', '导出', '1', 0x6d654777534d6469, 0x5851323231575137, 'business/instance/form/operation/export', '0', '1607924711', '1607924711'), ('3627', '导出', '2', 0x6d654777534d6469, 0x726875684a493238, 'business/instance/form/operation/export', '0', '1607924711', '1607924711'), ('3628', '导入', '1', 0x6d654777534d6469, 0x5439473269563652, 'business/instance/form/operation/import', '0', '1607924711', '1607924711'), ('3629', '导入', '2', 0x6d654777534d6469, 0x7252536251376e55, 'business/instance/form/operation/import', '0', '1607924711', '1607924711'), ('3630', '详情', '1', 0x6d654777534d6469, 0x4a6151504a525a74, 'business/instance/form/operation/find-one', '0', '1607924711', '1607924711'), ('3631', '详情', '2', 0x6d654777534d6469, 0x4931646572733964, 'business/instance/form/operation/find-one', '0', '1607924711', '1607924711'), ('3632', '搜索', '1', 0x6d654777534d6469, 0x49516f554f326457, 'business/instance/form/operation/search', '0', '1607924711', '1607924711'), ('3633', '搜索', '2', 0x6d654777534d6469, 0x46453359684c374e, 'business/instance/form/operation/search', '0', '1607924711', '1607924711'), ('3656', '创建', '1', 0x546f4b4c48474934, 0x454e76366458664f, 'business/instance/form/operation/create', '0', '1614323815', '1614323815'), ('3657', '创建', '2', 0x546f4b4c48474934, 0x5a594c3070386e50, 'business/instance/form/operation/create', '0', '1614323815', '1614323815'), ('3658', '删除', '1', 0x546f4b4c48474934, 0x5947303071574f56, 'business/instance/form/operation/delete', '0', '1614323815', '1614323815'), ('3659', '删除', '2', 0x546f4b4c48474934, 0x504148334f4c5942, 'business/instance/form/operation/delete', '0', '1614323815', '1614323815'), ('3660', '更新', '1', 0x546f4b4c48474934, 0x6e3635747a6a3257, 'business/instance/form/operation/update', '0', '1614323815', '1614323815'), ('3661', '更新', '2', 0x546f4b4c48474934, 0x44544a5748364879, 'business/instance/form/operation/update', '0', '1614323815', '1614323815'), ('3662', '启用', '1', 0x546f4b4c48474934, 0x7768336464707058, 'business/instance/form/operation/enable', '0', '1614323815', '1614323815'), ('3663', '启用', '2', 0x546f4b4c48474934, 0x687365514f67464b, 'business/instance/form/operation/enable', '0', '1614323815', '1614323815'), ('3664', '禁用', '1', 0x546f4b4c48474934, 0x5637505a70707a4d, 'business/instance/form/operation/disable', '0', '1614323815', '1614323815'), ('3665', '禁用', '2', 0x546f4b4c48474934, 0x4467653061313637, 'business/instance/form/operation/disable', '0', '1614323815', '1614323815'), ('3666', '作废', '1', 0x546f4b4c48474934, 0x6b34483254363732, 'business/instance/form/operation/invalid', '0', '1614323815', '1614323815'), ('3667', '作废', '2', 0x546f4b4c48474934, 0x64526a707a6d6d36, 'business/instance/form/operation/invalid', '0', '1614323815', '1614323815'), ('3668', '导出', '1', 0x546f4b4c48474934, 0x5a42556e656e7433, 'business/instance/form/operation/export', '0', '1614323815', '1614323815'), ('3669', '导出', '2', 0x546f4b4c48474934, 0x4531704d394e6d30, 'business/instance/form/operation/export', '0', '1614323815', '1614323815'), ('3670', '导入', '1', 0x546f4b4c48474934, 0x5654384c79363569, 'business/instance/form/operation/import', '0', '1614323815', '1614323815'), ('3671', '导入', '2', 0x546f4b4c48474934, 0x6e5073646a4f6451, 'business/instance/form/operation/import', '0', '1614323816', '1614323816'), ('3672', '详情', '1', 0x546f4b4c48474934, 0x7551635336304a43, 'business/instance/form/operation/find-one', '0', '1614323816', '1614323816'), ('3673', '详情', '2', 0x546f4b4c48474934, 0x486f39513636736b, 'business/instance/form/operation/find-one', '0', '1614323816', '1614323816'), ('3674', '搜索', '1', 0x546f4b4c48474934, 0x5268666833506636, 'business/instance/form/operation/search', '0', '1614323816', '1614323816'), ('3675', '搜索', '2', 0x546f4b4c48474934, 0x524959414553764a, 'business/instance/form/operation/search', '0', '1614323816', '1614323816'), ('3762', '禁用', '1', 0x6d326f5571457a34, 0x426b42306f4d6766, 'business/instance/form/operation/disable', '1', '1618889671', '1618889671'), ('3763', '更新', '1', 0x6d326f5571457a34, 0x443065316c4f424a, 'business/instance/form/operation/update', '1', '1618889671', '1618889671'), ('3764', '启用', '1', 0x6d326f5571457a34, 0x45706431496b5057, 'business/instance/form/operation/enable', '1', '1618889671', '1618889671'), ('3765', '导入', '2', 0x6d326f5571457a34, 0x4634524242426836, 'business/instance/form/operation/import', '1', '1618889671', '1618889671'), ('3766', '搜索', '1', 0x6d326f5571457a34, 0x495248554638376f, 'business/instance/form/operation/search', '1', '1618889671', '1618889671'), ('3767', '禁用', '2', 0x6d326f5571457a34, 0x4e356e676f534a39, 'business/instance/form/operation/disable', '1', '1618889671', '1618889671'), ('3768', '作废', '2', 0x6d326f5571457a34, 0x5161505146745349, 'business/instance/form/operation/invalid', '1', '1618889671', '1618889671'), ('3769', '创建', '2', 0x6d326f5571457a34, 0x51795775457a4c54, 'business/instance/form/operation/create', '1', '1618889671', '1618889671'), ('3770', '删除', '1', 0x6d326f5571457a34, 0x53324c6b55533837, 'business/instance/form/operation/delete', '1', '1618889671', '1618889671'), ('3771', '搜索', '2', 0x6d326f5571457a34, 0x544f716d44475564, 'business/instance/form/operation/search', '1', '1618889671', '1618889671'), ('3772', '导出', '2', 0x6d326f5571457a34, 0x546875466c735068, 'business/instance/form/operation/export', '1', '1618889671', '1618889671'), ('3773', '详情', '2', 0x6d326f5571457a34, 0x55525a6165583353, 'business/build/form/page/detail', '1', '1618889671', '1618889671'), ('3774', '删除', '2', 0x6d326f5571457a34, 0x5964446d424c787a, 'business/instance/form/operation/delete', '1', '1618889671', '1618889671'), ('3775', '详情', '1', 0x6d326f5571457a34, 0x614664356530534e, 'business/build/form/page/detail', '1', '1618889671', '1618889671'), ('3776', '导入', '1', 0x6d326f5571457a34, 0x65664f7962723244, 'business/instance/form/operation/import', '1', '1618889671', '1618889671'), ('3777', '作废', '1', 0x6d326f5571457a34, 0x66666f395356626d, 'business/instance/form/operation/invalid', '1', '1618889671', '1618889671'), ('3778', '启用', '2', 0x6d326f5571457a34, 0x6a6d727858387573, 'business/instance/form/operation/enable', '1', '1618889671', '1618889671'), ('3779', '创建', '1', 0x6d326f5571457a34, 0x6f3341387a6f7568, 'business/instance/form/operation/create', '1', '1618889671', '1618889671'), ('3780', '更新', '2', 0x6d326f5571457a34, 0x6f76396965673659, 'business/instance/form/operation/update', '1', '1618889671', '1618889671'), ('3781', '导出', '1', 0x6d326f5571457a34, 0x755458496e686341, 'business/instance/form/operation/export', '1', '1618889671', '1618889671');
COMMIT;

-- ----------------------------
--  Table structure for `system_queue_failed_jobs`
-- ----------------------------
CREATE TABLE `system_queue_failed_jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(50) NOT NULL COMMENT '队列名称',
  `payload` text NOT NULL COMMENT '队列数据',
  `failed_at` int(10) unsigned NOT NULL COMMENT '失败时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='队列失败统计';

-- ----------------------------
--  Table structure for `system_role`
-- ----------------------------
CREATE TABLE `system_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '角色名称',
  `auth_apps` text COMMENT '授权应用，应用ID，逗号隔开。',
  `description` varchar(255) DEFAULT NULL COMMENT '权限描述',
  `is_preset` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '系统预设',
  `is_partial_auth` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许授权给其他人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统角色';

-- ----------------------------
--  Records of `system_role`
-- ----------------------------
BEGIN;
INSERT INTO `system_role` VALUES ('1', '超级管理员', null, 'null', '1', '1'), ('2', '基础权限', null, 'null', '1', '1'), ('3', '企业外部成员', null, 'null', '1', '1'), ('4', '系统运维', null, '', '0', '1'), ('11', '销售员', null, 'null', '0', '1'), ('12', '销售部门管理者', null, 'null', '0', '1'), ('13', '开发实施交付人员', null, 'null', '0', '1'), ('14', '开发实施经理', null, 'null', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `system_role_perm`
-- ----------------------------
CREATE TABLE `system_role_perm` (
  `role_id` int(10) unsigned NOT NULL,
  `app_id` int(10) unsigned NOT NULL,
  `perm_id` int(10) unsigned NOT NULL,
  `rule` varchar(1000) DEFAULT NULL COMMENT '权限规则',
  `created_at` int(10) unsigned NOT NULL,
  `updated_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`app_id`,`perm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色权限';

-- ----------------------------
--  Records of `system_role_perm`
-- ----------------------------
BEGIN;
INSERT INTO `system_role_perm` VALUES ('1', '1', '2', null, '1608196261', '1608196261'), ('1', '1', '3', null, '1608196261', '1608196261'), ('1', '1', '4', null, '1608196261', '1608196261'), ('1', '1', '5', null, '1608196261', '1608196261'), ('1', '1', '6', null, '1608196261', '1608196261'), ('1', '1', '7', null, '1608196261', '1608196261'), ('1', '1', '8', null, '1608196261', '1608196261'), ('1', '1', '9', null, '1608196261', '1608196261'), ('1', '1', '10', null, '1608196261', '1608196261'), ('1', '1', '11', null, '1608196261', '1608196261'), ('1', '1', '12', null, '1608196261', '1608196261'), ('1', '1', '13', null, '1608196261', '1608196261'), ('1', '1', '14', null, '1608196261', '1608196261'), ('1', '1', '15', null, '1608196261', '1608196261'), ('1', '1', '16', null, '1608196261', '1608196261'), ('1', '1', '17', null, '1608196261', '1608196261'), ('1', '1', '18', null, '1608196261', '1608196261'), ('1', '1', '19', null, '1608196261', '1608196261'), ('1', '1', '20', null, '1608196261', '1608196261'), ('1', '1', '21', null, '1608196261', '1608196261'), ('1', '1', '142', null, '1608196261', '1608196261'), ('1', '1', '143', null, '1608196261', '1608196261'), ('1', '1', '144', null, '1608196261', '1608196261'), ('1', '1', '145', null, '1608196261', '1608196261'), ('1', '1', '146', null, '1608196261', '1608196261'), ('1', '1', '147', null, '1608196261', '1608196261'), ('1', '1', '148', null, '1608196261', '1608196261'), ('1', '1', '149', null, '1608196261', '1608196261'), ('1', '1', '150', null, '1608196261', '1608196261'), ('1', '1', '151', null, '1608196261', '1608196261'), ('1', '1', '162', null, '1608196261', '1608196261'), ('1', '1', '163', null, '1608196261', '1608196261'), ('1', '1', '164', null, '1608196261', '1608196261'), ('1', '1', '165', null, '1608196261', '1608196261'), ('1', '1', '166', null, '1608196261', '1608196261'), ('1', '1', '167', null, '1608196261', '1608196261'), ('1', '1', '168', null, '1608196261', '1608196261'), ('1', '1', '169', null, '1608196261', '1608196261'), ('1', '1', '170', null, '1608196261', '1608196261'), ('1', '1', '171', null, '1608196261', '1608196261'), ('1', '1', '292', null, '1608196261', '1608196261'), ('1', '1', '293', null, '1608196261', '1608196261'), ('1', '1', '294', null, '1608196261', '1608196261'), ('1', '1', '295', null, '1608196261', '1608196261'), ('1', '1', '296', null, '1608196261', '1608196261'), ('1', '1', '297', null, '1608196261', '1608196261'), ('1', '1', '298', null, '1608196261', '1608196261'), ('1', '1', '299', null, '1608196261', '1608196261'), ('1', '1', '300', null, '1608196261', '1608196261'), ('1', '1', '301', null, '1608196261', '1608196261'), ('1', '1', '302', null, '1608196261', '1608196261'), ('1', '1', '303', null, '1608196261', '1608196261'), ('1', '1', '304', null, '1608196261', '1608196261'), ('1', '1', '305', null, '1608196261', '1608196261'), ('1', '1', '306', null, '1608196261', '1608196261'), ('1', '1', '307', null, '1608196261', '1608196261'), ('1', '1', '308', null, '1608196261', '1608196261'), ('1', '1', '309', null, '1608196261', '1608196261'), ('1', '1', '310', null, '1608196261', '1608196261'), ('1', '1', '311', null, '1608196261', '1608196261'), ('1', '1', '312', null, '1608196261', '1608196261'), ('1', '1', '313', null, '1608196261', '1608196261'), ('1', '1', '314', null, '1608196261', '1608196261'), ('1', '1', '315', null, '1608196261', '1608196261'), ('1', '1', '316', null, '1608196261', '1608196261'), ('1', '1', '317', null, '1608196261', '1608196261'), ('1', '1', '318', null, '1608196261', '1608196261'), ('1', '1', '319', null, '1608196261', '1608196261'), ('1', '1', '320', null, '1608196261', '1608196261'), ('1', '1', '321', null, '1608196261', '1608196261'), ('1', '1', '442', null, '1608196261', '1608196261'), ('1', '1', '443', null, '1608196261', '1608196261'), ('1', '1', '444', null, '1608196261', '1608196261'), ('1', '1', '445', null, '1608196261', '1608196261'), ('1', '1', '446', null, '1608196261', '1608196261'), ('1', '1', '447', null, '1608196261', '1608196261'), ('1', '1', '448', null, '1608196261', '1608196261'), ('1', '1', '449', null, '1608196261', '1608196261'), ('1', '1', '450', null, '1608196261', '1608196261'), ('1', '1', '451', null, '1608196261', '1608196261'), ('1', '1', '462', null, '1608196261', '1608196261'), ('1', '1', '463', null, '1608196261', '1608196261'), ('1', '1', '464', null, '1608196261', '1608196261'), ('1', '1', '465', null, '1608196261', '1608196261'), ('1', '1', '466', null, '1608196261', '1608196261'), ('1', '1', '467', null, '1608196261', '1608196261'), ('1', '1', '468', null, '1608196261', '1608196261'), ('1', '1', '469', null, '1608196261', '1608196261'), ('1', '1', '470', null, '1608196261', '1608196261'), ('1', '1', '471', null, '1608196261', '1608196261'), ('1', '1', '592', null, '1608196261', '1608196261'), ('1', '1', '593', null, '1608196261', '1608196261'), ('1', '1', '594', null, '1608196261', '1608196261'), ('1', '1', '595', null, '1608196261', '1608196261'), ('1', '1', '596', null, '1608196261', '1608196261'), ('1', '1', '597', null, '1608196261', '1608196261'), ('1', '1', '598', null, '1608196261', '1608196261'), ('1', '1', '599', null, '1608196261', '1608196261'), ('1', '1', '600', null, '1608196261', '1608196261'), ('1', '1', '601', null, '1608196261', '1608196261'), ('1', '1', '2085', null, '1608196262', '1608196262'), ('1', '1', '2086', null, '1608196262', '1608196262'), ('1', '1', '2087', null, '1608196262', '1608196262'), ('1', '1', '2088', null, '1608196262', '1608196262'), ('1', '1', '2089', null, '1608196262', '1608196262'), ('1', '1', '2090', null, '1608196262', '1608196262'), ('1', '1', '2091', null, '1608196262', '1608196262'), ('1', '1', '2092', null, '1608196262', '1608196262'), ('1', '1', '2093', null, '1608196262', '1608196262'), ('1', '1', '2094', null, '1608196262', '1608196262'), ('1', '1', '2095', null, '1608196262', '1608196262'), ('1', '1', '2096', null, '1608196262', '1608196262'), ('1', '1', '2097', null, '1608196262', '1608196262'), ('1', '1', '2098', null, '1608196262', '1608196262'), ('1', '1', '2099', null, '1608196262', '1608196262'), ('1', '1', '2100', null, '1608196262', '1608196262'), ('1', '1', '2101', null, '1608196262', '1608196262'), ('1', '1', '2102', null, '1608196262', '1608196262'), ('1', '1', '2103', null, '1608196262', '1608196262'), ('1', '1', '2104', null, '1608196262', '1608196262'), ('1', '1', '2105', null, '1608196262', '1608196262'), ('1', '1', '2106', null, '1608196262', '1608196262'), ('1', '1', '2107', null, '1608196262', '1608196262'), ('1', '1', '2108', null, '1608196262', '1608196262'), ('1', '1', '2109', null, '1608196262', '1608196262'), ('1', '1', '2110', null, '1608196262', '1608196262'), ('1', '1', '2111', null, '1608196262', '1608196262'), ('1', '1', '2112', null, '1608196262', '1608196262'), ('1', '1', '2113', null, '1608196262', '1608196262'), ('1', '1', '2114', null, '1608196262', '1608196262'), ('1', '1', '2115', null, '1608196262', '1608196262'), ('1', '1', '2116', null, '1608196262', '1608196262'), ('1', '1', '2117', null, '1608196262', '1608196262'), ('1', '1', '2118', null, '1608196262', '1608196262'), ('1', '1', '2119', null, '1608196262', '1608196262'), ('1', '1', '2120', null, '1608196262', '1608196262'), ('1', '1', '2121', null, '1608196262', '1608196262'), ('1', '1', '2122', null, '1608196262', '1608196262'), ('1', '1', '2123', null, '1608196262', '1608196262'), ('1', '1', '2124', null, '1608196262', '1608196262'), ('1', '1', '2125', null, '1608196262', '1608196262'), ('1', '1', '2126', null, '1608196262', '1608196262'), ('1', '1', '2127', null, '1608196262', '1608196262'), ('1', '1', '2128', null, '1608196262', '1608196262'), ('1', '1', '2129', null, '1608196262', '1608196262'), ('1', '1', '2130', null, '1608196262', '1608196262'), ('1', '1', '2131', null, '1608196262', '1608196262'), ('1', '1', '2132', null, '1608196262', '1608196262'), ('1', '1', '2133', null, '1608196262', '1608196262'), ('1', '1', '2134', null, '1608196262', '1608196262'), ('1', '1', '2135', null, '1608196262', '1608196262'), ('1', '1', '2136', null, '1608196262', '1608196262'), ('1', '1', '2137', null, '1608196262', '1608196262'), ('1', '1', '2138', null, '1608196262', '1608196262'), ('1', '1', '2139', null, '1608196262', '1608196262'), ('1', '1', '2140', null, '1608196262', '1608196262'), ('1', '1', '2141', null, '1608196262', '1608196262'), ('1', '1', '2142', null, '1608196262', '1608196262'), ('1', '1', '2143', null, '1608196262', '1608196262'), ('1', '1', '2144', null, '1608196262', '1608196262'), ('1', '1', '2145', null, '1608196262', '1608196262'), ('1', '1', '2146', null, '1608196262', '1608196262'), ('1', '1', '2147', null, '1608196262', '1608196262'), ('1', '1', '2148', null, '1608196262', '1608196262'), ('1', '1', '2149', null, '1608196262', '1608196262'), ('1', '1', '2150', null, '1608196262', '1608196262'), ('1', '1', '2151', null, '1608196262', '1608196262'), ('1', '1', '2152', null, '1608196262', '1608196262'), ('1', '1', '2153', null, '1608196262', '1608196262'), ('1', '1', '2154', null, '1608196262', '1608196262'), ('1', '1', '2155', null, '1608196262', '1608196262'), ('1', '1', '2156', null, '1608196262', '1608196262'), ('1', '1', '2157', null, '1608196262', '1608196262'), ('1', '1', '2158', null, '1608196262', '1608196262'), ('1', '1', '2159', null, '1608196262', '1608196262'), ('1', '1', '2160', null, '1608196262', '1608196262'), ('1', '1', '2161', null, '1608196262', '1608196262'), ('1', '1', '2386', null, '1608196262', '1608196262'), ('1', '1', '2387', null, '1608196262', '1608196262'), ('1', '1', '2388', null, '1608196262', '1608196262'), ('1', '1', '2389', null, '1608196262', '1608196262'), ('1', '1', '2390', null, '1608196262', '1608196262'), ('1', '1', '2391', null, '1608196262', '1608196262'), ('1', '1', '2392', null, '1608196262', '1608196262'), ('1', '1', '2393', null, '1608196262', '1608196262'), ('1', '1', '2394', null, '1608196262', '1608196262'), ('1', '1', '2395', null, '1608196262', '1608196262'), ('1', '1', '2396', null, '1608196262', '1608196262'), ('1', '1', '2397', null, '1608196262', '1608196262'), ('1', '1', '2398', null, '1608196262', '1608196262'), ('1', '1', '2399', null, '1608196262', '1608196262'), ('1', '1', '2400', null, '1608196262', '1608196262'), ('1', '1', '2401', null, '1608196262', '1608196262'), ('1', '1', '2402', null, '1608196262', '1608196262'), ('1', '1', '2403', null, '1608196262', '1608196262'), ('1', '1', '2404', null, '1608196262', '1608196262'), ('1', '1', '2405', null, '1608196262', '1608196262'), ('1', '1', '2406', null, '1608196262', '1608196262'), ('1', '1', '2407', null, '1608196262', '1608196262'), ('1', '1', '2408', null, '1608196262', '1608196262'), ('1', '1', '2409', null, '1608196262', '1608196262'), ('1', '1', '2410', null, '1608196262', '1608196262'), ('1', '1', '2411', null, '1608196262', '1608196262'), ('1', '1', '2412', null, '1608196262', '1608196262'), ('1', '1', '2413', null, '1608196262', '1608196262'), ('1', '1', '2414', null, '1608196262', '1608196262'), ('1', '1', '2415', null, '1608196262', '1608196262'), ('1', '1', '2416', null, '1608196262', '1608196262'), ('1', '1', '2417', null, '1608196262', '1608196262'), ('1', '1', '2418', null, '1608196262', '1608196262'), ('1', '1', '2419', null, '1608196262', '1608196262'), ('1', '1', '2420', null, '1608196262', '1608196262'), ('1', '1', '2421', null, '1608196262', '1608196262'), ('1', '1', '2422', null, '1608196262', '1608196262'), ('1', '1', '2423', null, '1608196262', '1608196262'), ('1', '1', '2424', null, '1608196262', '1608196262'), ('1', '1', '2425', null, '1608196262', '1608196262'), ('1', '1', '2426', null, '1608196262', '1608196262'), ('1', '1', '2427', null, '1608196262', '1608196262'), ('1', '1', '2428', null, '1608196262', '1608196262'), ('1', '1', '2429', null, '1608196262', '1608196262'), ('1', '1', '2430', null, '1608196262', '1608196262'), ('1', '1', '2431', null, '1608196262', '1608196262'), ('1', '1', '2432', null, '1608196262', '1608196262'), ('1', '1', '2433', null, '1608196262', '1608196262'), ('1', '1', '2434', null, '1608196262', '1608196262'), ('1', '1', '2435', null, '1608196262', '1608196262'), ('1', '1', '2436', null, '1608196262', '1608196262'), ('1', '1', '2437', null, '1608196262', '1608196262'), ('1', '1', '2438', null, '1608196262', '1608196262'), ('1', '1', '2439', null, '1608196262', '1608196262'), ('1', '1', '2440', null, '1608196262', '1608196262'), ('1', '1', '2441', null, '1608196262', '1608196262'), ('1', '1', '2442', null, '1608196262', '1608196262'), ('1', '1', '2443', null, '1608196262', '1608196262'), ('1', '1', '2444', null, '1608196262', '1608196262'), ('1', '1', '2445', null, '1608196262', '1608196262'), ('1', '1', '2881', null, '1608196262', '1608196262'), ('1', '1', '2882', null, '1608196262', '1608196262'), ('1', '1', '2883', null, '1608196262', '1608196262'), ('1', '1', '2884', null, '1608196262', '1608196262'), ('1', '1', '2885', null, '1608196262', '1608196262'), ('1', '1', '2886', null, '1608196262', '1608196262'), ('1', '1', '2887', null, '1608196262', '1608196262'), ('1', '1', '2888', null, '1608196262', '1608196262'), ('1', '1', '2889', null, '1608196262', '1608196262'), ('1', '1', '2890', null, '1608196262', '1608196262'), ('1', '1', '2891', null, '1608196262', '1608196262'), ('1', '1', '2892', null, '1608196262', '1608196262'), ('1', '1', '2893', null, '1608196262', '1608196262'), ('1', '1', '2894', null, '1608196262', '1608196262'), ('1', '1', '2895', null, '1608196262', '1608196262'), ('1', '1', '2896', null, '1608196262', '1608196262'), ('1', '1', '2897', null, '1608196262', '1608196262'), ('1', '1', '2898', null, '1608196262', '1608196262'), ('1', '1', '2899', null, '1608196262', '1608196262'), ('1', '1', '2900', null, '1608196262', '1608196262'), ('1', '1', '2901', null, '1608196262', '1608196262'), ('1', '1', '2902', null, '1608196262', '1608196262'), ('1', '1', '2903', null, '1608196262', '1608196262'), ('1', '1', '2904', null, '1608196262', '1608196262'), ('1', '1', '2905', null, '1608196262', '1608196262'), ('1', '1', '2906', null, '1608196262', '1608196262'), ('1', '1', '2907', null, '1608196262', '1608196262'), ('1', '1', '2908', null, '1608196262', '1608196262'), ('1', '1', '2909', null, '1608196262', '1608196262'), ('1', '1', '2910', null, '1608196262', '1608196262'), ('1', '1', '2911', null, '1608196262', '1608196262'), ('1', '1', '2912', null, '1608196262', '1608196262'), ('1', '1', '3512', null, '1608196262', '1608196262'), ('1', '1', '3513', null, '1608196262', '1608196262'), ('1', '1', '3514', null, '1608196262', '1608196262'), ('1', '1', '3515', null, '1608196262', '1608196262'), ('1', '1', '3516', null, '1608196262', '1608196262'), ('1', '1', '3517', null, '1608196262', '1608196262'), ('1', '1', '3518', null, '1608196262', '1608196262'), ('1', '1', '3519', null, '1608196262', '1608196262'), ('1', '1', '3520', null, '1608196262', '1608196262'), ('1', '1', '3521', null, '1608196262', '1608196262'), ('1', '1', '3522', null, '1608196262', '1608196262'), ('1', '1', '3523', null, '1608196262', '1608196262'), ('1', '1', '3524', null, '1608196262', '1608196262'), ('1', '1', '3525', null, '1608196262', '1608196262'), ('1', '1', '3526', null, '1608196262', '1608196262'), ('1', '1', '3527', null, '1608196262', '1608196262'), ('1', '1', '3528', null, '1608196262', '1608196262'), ('1', '1', '3529', null, '1608196262', '1608196262'), ('1', '1', '3530', null, '1608196262', '1608196262'), ('1', '1', '3531', null, '1608196262', '1608196262'), ('1', '1', '3532', null, '1608196262', '1608196262'), ('1', '1', '3533', null, '1608196262', '1608196262'), ('1', '1', '3534', null, '1608196262', '1608196262'), ('1', '1', '3535', null, '1608196262', '1608196262'), ('1', '1', '3536', null, '1608196262', '1608196262'), ('1', '1', '3537', null, '1608196262', '1608196262'), ('1', '1', '3538', null, '1608196262', '1608196262'), ('1', '1', '3539', null, '1608196262', '1608196262'), ('1', '1', '3540', null, '1608196262', '1608196262'), ('1', '1', '3541', null, '1608196262', '1608196262'), ('1', '1', '3542', null, '1608196262', '1608196262'), ('1', '1', '3543', null, '1608196262', '1608196262'), ('1', '1', '3544', null, '1608196262', '1608196262'), ('1', '1', '3545', null, '1608196262', '1608196262'), ('1', '1', '3546', null, '1608196262', '1608196262'), ('1', '1', '3547', null, '1608196262', '1608196262'), ('1', '1', '3548', null, '1608196262', '1608196262'), ('1', '1', '3549', null, '1608196262', '1608196262'), ('1', '1', '3550', null, '1608196262', '1608196262'), ('1', '1', '3551', null, '1608196262', '1608196262'), ('1', '1', '3554', null, '1608196262', '1608196262'), ('1', '1', '3555', null, '1608196262', '1608196262'), ('1', '1', '3556', null, '1608196262', '1608196262'), ('1', '1', '3557', null, '1608196262', '1608196262'), ('1', '1', '3558', null, '1608196262', '1608196262'), ('1', '1', '3559', null, '1608196262', '1608196262'), ('1', '1', '3560', null, '1608196262', '1608196262'), ('1', '1', '3561', null, '1608196262', '1608196262'), ('1', '1', '3562', null, '1608196262', '1608196262'), ('1', '1', '3563', null, '1608196262', '1608196262'), ('1', '1', '3564', null, '1608196262', '1608196262'), ('1', '1', '3565', null, '1608196262', '1608196262'), ('1', '1', '3566', null, '1608196262', '1608196262'), ('1', '1', '3567', null, '1608196262', '1608196262'), ('1', '1', '3568', null, '1608196262', '1608196262'), ('1', '1', '3569', null, '1608196262', '1608196262'), ('1', '1', '3570', null, '1608196262', '1608196262'), ('1', '1', '3571', null, '1608196262', '1608196262'), ('1', '1', '3572', null, '1608196262', '1608196262'), ('1', '1', '3573', null, '1608196262', '1608196262'), ('1', '1', '3574', null, '1608196262', '1608196262'), ('1', '1', '3575', null, '1608196262', '1608196262'), ('1', '1', '3576', null, '1608196262', '1608196262'), ('1', '1', '3577', null, '1608196262', '1608196262'), ('1', '1', '3578', null, '1608196262', '1608196262'), ('1', '1', '3579', null, '1608196262', '1608196262'), ('1', '1', '3580', null, '1608196262', '1608196262'), ('1', '1', '3581', null, '1608196262', '1608196262'), ('1', '1', '3582', null, '1608196262', '1608196262'), ('1', '1', '3583', null, '1608196262', '1608196262'), ('1', '1', '3584', null, '1608196262', '1608196262'), ('1', '1', '3585', null, '1608196262', '1608196262'), ('1', '1', '3586', null, '1608196262', '1608196262'), ('1', '1', '3587', null, '1608196262', '1608196262'), ('1', '1', '3588', null, '1608196262', '1608196262'), ('1', '1', '3589', null, '1608196262', '1608196262'), ('1', '1', '3590', null, '1608196262', '1608196262'), ('1', '1', '3591', null, '1608196262', '1608196262'), ('1', '1', '3592', null, '1608196262', '1608196262'), ('1', '1', '3593', null, '1608196262', '1608196262'), ('1', '1', '3594', null, '1608196262', '1608196262'), ('1', '1', '3595', null, '1608196262', '1608196262'), ('1', '1', '3596', null, '1608196262', '1608196262'), ('1', '1', '3597', null, '1608196262', '1608196262'), ('1', '1', '3598', null, '1608196262', '1608196262'), ('1', '1', '3599', null, '1608196262', '1608196262'), ('1', '1', '3600', null, '1608196262', '1608196262'), ('1', '1', '3601', null, '1608196262', '1608196262'), ('1', '1', '3602', null, '1608196262', '1608196262'), ('1', '1', '3603', null, '1608196262', '1608196262'), ('1', '1', '3604', null, '1608196262', '1608196262'), ('1', '1', '3605', null, '1608196262', '1608196262'), ('1', '1', '3606', null, '1608196262', '1608196262'), ('1', '1', '3607', null, '1608196262', '1608196262'), ('1', '1', '3608', null, '1608196262', '1608196262'), ('1', '1', '3609', null, '1608196262', '1608196262'), ('1', '1', '3610', null, '1608196262', '1608196262'), ('1', '1', '3611', null, '1608196262', '1608196262'), ('1', '1', '3612', null, '1608196262', '1608196262'), ('1', '1', '3613', null, '1608196262', '1608196262'), ('1', '1', '3614', null, '1608196262', '1608196262'), ('1', '1', '3615', null, '1608196262', '1608196262'), ('1', '1', '3616', null, '1608196262', '1608196262'), ('1', '1', '3617', null, '1608196262', '1608196262'), ('1', '1', '3618', null, '1608196262', '1608196262'), ('1', '1', '3619', null, '1608196262', '1608196262'), ('1', '1', '3620', null, '1608196262', '1608196262'), ('1', '1', '3621', null, '1608196262', '1608196262'), ('1', '1', '3622', null, '1608196262', '1608196262'), ('1', '1', '3623', null, '1608196262', '1608196262'), ('1', '1', '3624', null, '1608196262', '1608196262'), ('1', '1', '3625', null, '1608196262', '1608196262'), ('1', '1', '3626', null, '1608196262', '1608196262'), ('1', '1', '3627', null, '1608196262', '1608196262'), ('1', '1', '3628', null, '1608196262', '1608196262'), ('1', '1', '3629', null, '1608196262', '1608196262'), ('1', '1', '3630', null, '1608196262', '1608196262'), ('1', '1', '3631', null, '1608196262', '1608196262'), ('1', '1', '3632', null, '1608196262', '1608196262'), ('1', '1', '3633', null, '1608196262', '1608196262'), ('2', '1', '3762', null, '1620728330', '1620728330'), ('2', '1', '3763', null, '1620728330', '1620728330'), ('2', '1', '3764', null, '1620728330', '1620728330'), ('2', '1', '3765', null, '1620728330', '1620728330'), ('2', '1', '3766', null, '1620728330', '1620728330'), ('2', '1', '3770', null, '1620728330', '1620728330'), ('2', '1', '3775', null, '1620728330', '1620728330'), ('2', '1', '3776', null, '1620728330', '1620728330'), ('2', '1', '3777', null, '1620728330', '1620728330'), ('2', '1', '3779', null, '1620728330', '1620728330'), ('2', '1', '3781', null, '1620728330', '1620728330'), ('3', '1', '21', null, '1597211108', '1597211108'), ('3', '1', '2087', null, '1597211108', '1597211108'), ('3', '1', '2119', null, '1597211108', '1597211108'), ('3', '1', '2120', null, '1597211108', '1597211108'), ('3', '1', '2121', null, '1597211108', '1597211108'), ('3', '1', '2122', null, '1597211108', '1597211108'), ('3', '1', '2123', null, '1597211108', '1597211108'), ('3', '1', '2441', null, '1597211108', '1597211108'), ('3', '1', '2443', null, '1597211108', '1597211108'), ('14', '1', '3762', null, '1618889774', '1618889774'), ('14', '1', '3763', null, '1618889774', '1618889774'), ('14', '1', '3764', null, '1618889774', '1618889774'), ('14', '1', '3766', null, '1618889774', '1618889774'), ('14', '1', '3770', null, '1618889774', '1618889774'), ('14', '1', '3775', null, '1618889774', '1618889774'), ('14', '1', '3776', null, '1618889774', '1618889774'), ('14', '1', '3777', null, '1618889774', '1618889774'), ('14', '1', '3779', null, '1618889774', '1618889774'), ('14', '1', '3781', null, '1618889774', '1618889774');
COMMIT;

-- ----------------------------
--  Table structure for `system_setting`
-- ----------------------------
CREATE TABLE `system_setting` (
  `variable_type` tinyint(3) unsigned NOT NULL COMMENT '变量类型：1.string 2.int 3.float 4.bool 5. json',
  `variable_name` varchar(64) NOT NULL COMMENT '变量名称',
  `variable_value` text NOT NULL COMMENT '变量值',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  `describe` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`variable_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统全局设置';

-- ----------------------------
--  Records of `system_setting`
-- ----------------------------
BEGIN;
INSERT INTO `system_setting` VALUES ('1', 'budgetManager', '79', '1', '1', ''), ('1', 'budgetPaidAmountReportUser', '1,74,96', '1', '1', ''), ('1', 'copyright', '<strong>Copyright © 2008-2020 <a href=\"thincent.com\">信晨科技 </a>.</strong> All rights reserved.', '1530598495', '1576846858', null), ('2', 'defaultClueResponsibleBy', '96', '1', '1', ''), ('1', 'domain', 'scrm.93wj.com', '1524119267', '1576846788', null), ('2', 'installed_at', '0', '1524119267', '1524119267', null), ('2', 'isAllowWxAppAutoBindMobile', '1', '1', '1', null), ('1', 'name', 'SCRM', '1530598495', '1530598495', null), ('2', 'operation_log_max_day', '360', '1576846858', '1576846858', '保留最近多少天的记录，0不限制'), ('2', 'operation_log_max_record', '5000000', '1576846858', '1576846858', '最多保留多少条记录，0不限制'), ('2', 'upgraded_at', '0', '1524119267', '1524119267', null), ('1', 'version', '1.0', '1524119267', '1524119267', null), ('1', 'wps_appid', '8e3a57070c204e9fb61de8a94ddb9344', '1', '1', null), ('1', 'wps_appkey', 'd6e7bfb9dd634b779b95bc08aa3c090a', '1', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `system_sms_setting`
-- ----------------------------
CREATE TABLE `system_sms_setting` (
  `variable_type` tinyint(3) unsigned NOT NULL COMMENT '变量类型：1.string 2.int 3.float 4.bool 5. json',
  `variable_name` varchar(64) NOT NULL COMMENT '变量名称',
  `variable_value` text NOT NULL COMMENT '变量值',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  `updated_at` int(10) unsigned NOT NULL COMMENT '更新时间',
  `describe` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`variable_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_sms_setting`
-- ----------------------------
BEGIN;
INSERT INTO `system_sms_setting` VALUES ('1', 'aliyun_access_key_id', '', '1590717615', '1590717615', null, null), ('1', 'aliyun_access_key_secret', '', '1590717615', '1590717615', null, null), ('1', 'aliyun_code', '', '1590717615', '1590717615', null, null), ('1', 'aliyun_region_id', '', '1590717615', '1590717615', null, null), ('1', 'aliyun_sign', '', '1590717615', '1590717615', null, null), ('1', 'aliyun_template', '', '1590717615', '1590717615', null, null), ('1', 'platform', '', '1590717615', '1590717615', null, null), ('1', 'qcloud_appid', '1400405489', '1590717615', '1590717615', null, null), ('1', 'qcloud_appkey', '88b23360d3f62fc835b3ee8d8c958b60', '1590717615', '1590717615', null, null), ('1', 'qcloud_sign', '信晨科技', '1590717615', '1590717615', null, null), ('1', 'qcloud_template', '', '1590717615', '1590717615', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `system_sms_verifycode`
-- ----------------------------
CREATE TABLE `system_sms_verifycode` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '认证码ID',
  `mobile` varchar(25) NOT NULL COMMENT '手机号码',
  `verifycode` varchar(10) NOT NULL COMMENT '验证码',
  `client_ip` varchar(25) NOT NULL COMMENT '客户端IP',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未使用 1已使用',
  `expired_at` int(10) unsigned NOT NULL COMMENT '过期时间',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `IDX_MOBILE` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `system_user`
-- ----------------------------
CREATE TABLE `system_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `mobile` varchar(11) DEFAULT NULL,
  `password_hash` varchar(60) DEFAULT NULL,
  `jwt_access_token` varchar(1000) DEFAULT NULL,
  `auth_key` varchar(32) DEFAULT NULL,
  `wx_unionid` varchar(64) DEFAULT NULL COMMENT '微信unionid',
  `is_enable` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
  `created_at` int(11) unsigned NOT NULL DEFAULT '0',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0',
  `updated_at` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IDX_USERNAME` (`username`),
  KEY `IDX_MOBILE` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=1992 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_user`
-- ----------------------------
BEGIN;
INSERT INTO `system_user` VALUES ('1', 'admin', '88888888888', '$2y$10$Hi0n7m7e/ASyj./YH.c38OCSdUZpPkXCB80A9RK4E88F7xT/7ZHXO', '$2y$10$ONcj0BewpRGnsI7hgLcpHem6JylvQPMUtmimrulx/YRuSXWhkSQAi', 'wQpG-FLbmyb-yN2aXHhncJLKIVjTvhvg', null, '1', '1465196291', '1531970768', '1', '1606303603'), ('66', '15989191771', '15989191771', '$2y$10$Hi0n7m7e/ASyj./YH.c38OCSdUZpPkXCB80A9RK4E88F7xT/7ZHXO', null, 'wQpG-FLbmyb-yN2aXHhncJLKIVjTvhvg', null, '1', '1', '1583822381', '160', '1604301061'), ('73', '13719100871', '13719100871', '$2y$10$Hi0n7m7e/ASyj./YH.c38OCSdUZpPkXCB80A9RK4E88F7xT/7ZHXO', null, 'wQpG-FLbmyb-yN2aXHhncJLKIVjTvhvg', null, '1', '1', '1583822551', '66', '1618822900');
COMMIT;

-- ----------------------------
--  Table structure for `system_user_fund_account`
-- ----------------------------
CREATE TABLE `system_user_fund_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `balance` float(12,2) DEFAULT '0.00',
  `frozen` float(12,2) DEFAULT '0.00',
  `is_frozen` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `system_user_fund_bill`
-- ----------------------------
CREATE TABLE `system_user_fund_bill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `rev_exp_type` tinyint(1) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `amount` float(12,2) NOT NULL,
  `source_business_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `settle_at` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `system_user_fund_journal`
-- ----------------------------
CREATE TABLE `system_user_fund_journal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `bill_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `rev_exp_type` tinyint(1) DEFAULT '1',
  `comment` varchar(255) DEFAULT NULL,
  `initial_amount` float(12,2) DEFAULT '0.00',
  `amount` float(12,2) DEFAULT '0.00',
  `final_amount` float(12,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `system_user_login`
-- ----------------------------
CREATE TABLE `system_user_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT '0',
  `app_id` int(11) DEFAULT '0',
  `ip` varchar(255) DEFAULT '0',
  `user_agent` varchar(2555) DEFAULT NULL,
  `status` tinyint(3) DEFAULT NULL,
  `type` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_user_login`
-- ----------------------------
BEGIN;
INSERT INTO `system_user_login` VALUES ('1', '1623226476', '1', '1623226476', '1', '1', '1', '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', '1', '1'), ('2', '1623227289', '1', '1623227289', '1', '1', '1', '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', '1', '1'), ('3', '1623227309', '73', '1623227309', '73', '73', '1', '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', '1', '1'), ('4', '1623227332', '1', '1623227332', '1', '1', '1', '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `system_user_profile`
-- ----------------------------
CREATE TABLE `system_user_profile` (
  `user_id` int(11) NOT NULL,
  `nickname` varchar(32) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `thumb_avatar` varchar(255) DEFAULT NULL,
  `gender` tinyint(4) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `country` varchar(32) DEFAULT NULL,
  `province` varchar(32) DEFAULT NULL,
  `city` varchar(32) DEFAULT NULL,
  `realname` varchar(32) DEFAULT NULL,
  `email` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `system_user_profile`
-- ----------------------------
BEGIN;
INSERT INTO `system_user_profile` VALUES ('1', '超**', null, null, null, null, null, null, null, '超**', null), ('66', '涂**', 'http://wework.qpic.cn/wwhead/duc2TvpEgSSWiaVLaJnssabjGahrAWvs98ZByyd4iaVOX0CVUR8Gg5APJ6iauJwP7JgGmmSpdlY1H8/0', 'http://wework.qpic.cn/wwhead/duc2TvpEgSSWiaVLaJnssabjGahrAWvs98ZByyd4iaVOX0CVUR8Gg5APJ6iauJwP7JgGmmSpdlY1H8/100', '1', null, 'China', 'Guangdong', 'Guangzhou', '涂**', 'jin*******@thincent.com'), ('73', 'x**', 'https://wework.qpic.cn/wwhead/duc2TvpEgSSWiaVLaJnssaYjaBJtIW4WzBGpTTABz8LeLkdhgkJmiaPpwMibtQHiaqH36v6YST5GPFk/0', 'https://wework.qpic.cn/wwhead/duc2TvpEgSSWiaVLaJnssaYjaBJtIW4WzBGpTTABz8LeLkdhgkJmiaPpwMibtQHiaqH36v6YST5GPFk/100', '1', null, 'China', 'Guangdong', 'Guangzhou', 'x**', '*******');
COMMIT;

-- ----------------------------
--  Table structure for `system_user_role`
-- ----------------------------
CREATE TABLE `system_user_role` (
  `role_id` int(10) unsigned NOT NULL COMMENT '应用ID',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色';

-- ----------------------------
--  Records of `system_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `system_user_role` VALUES ('2', '1'), ('1', '66'), ('2', '66'), ('2', '73'), ('13', '73'), ('14', '73');
COMMIT;

-- ----------------------------
--  Table structure for `task`
-- ----------------------------
CREATE TABLE `task` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content` longtext,
  `handle_users` varchar(255) DEFAULT NULL,
  `cc_users` varchar(255) DEFAULT NULL,
  `notice_at` int(11) DEFAULT '0',
  `require_finish_at` int(11) DEFAULT '0',
  `handle_type` tinyint(1) DEFAULT '1',
  `status` tinyint(1) DEFAULT '1',
  `finish_at` int(11) DEFAULT '0',
  `source_entity` varchar(255) DEFAULT NULL,
  `source_data` varchar(255) DEFAULT NULL,
  `source_data_id` int(11) DEFAULT '0',
  `project_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',
  `create_mothod` varchar(255) DEFAULT NULL,
  `finish_mothod` varchar(255) DEFAULT NULL,
  `cancel_mothod` varchar(255) DEFAULT NULL,
  `priority` tinyint(1) DEFAULT '1',
  `effective_manhours` float(12,1) DEFAULT '0.0',
  `settle_manhours` float(12,1) DEFAULT '0.0',
  `report_manhours` float(12,1) DEFAULT '0.0',
  PRIMARY KEY (`id`),
  KEY `source_entity` (`source_entity`,`source_data_id`),
  KEY `project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_cc_user`
-- ----------------------------
CREATE TABLE `task_cc_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `task_id` (`task_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_handle_user`
-- ----------------------------
CREATE TABLE `task_handle_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `finish_at` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_media`
-- ----------------------------
CREATE TABLE `task_media` (
  `task_id` int(11) NOT NULL,
  `media_id` int(11) NOT NULL,
  PRIMARY KEY (`task_id`,`media_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_schedule`
-- ----------------------------
CREATE TABLE `task_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `schedule_at` int(11) DEFAULT '0',
  `handle_by` int(11) DEFAULT NULL,
  `settle_manhours` float(12,1) DEFAULT '0.0',
  `report_manhours` float(12,1) DEFAULT '0.0',
  `status` tinyint(3) DEFAULT NULL,
  `submit_at` int(11) DEFAULT '0',
  `report_at` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_schedule_item`
-- ----------------------------
CREATE TABLE `task_schedule_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `schedule_id` int(11) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `status` tinyint(3) DEFAULT NULL,
  `settle_manhours` float(12,1) DEFAULT '0.0',
  `report_manhours` float(12,1) DEFAULT '0.0',
  PRIMARY KEY (`id`),
  KEY `schedule_id` (`schedule_id`),
  KEY `task_id` (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_user_folder`
-- ----------------------------
CREATE TABLE `task_user_folder` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT '0',
  `path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `task_user_tag`
-- ----------------------------
CREATE TABLE `task_user_tag` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow`
-- ----------------------------
CREATE TABLE `workflow` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `version` int(5) unsigned zerofill NOT NULL COMMENT '版本号 00001',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '流程状态: 0禁用 1待发布 2已发布',
  `is_used` tinyint(1) DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '流程父ID 默认为0',
  `master_id` int(11) NOT NULL DEFAULT '0' COMMENT '流程源ID 默认为0',
  `group_id` int(11) NOT NULL COMMENT '流程分组',
  `start_event_type` varchar(255) NOT NULL DEFAULT 'form' COMMENT '流程发起事件类型:form->表单',
  `start_event_target` varchar(255) NOT NULL COMMENT '流程发起事件对象:表单ID 或其它关联类型数据ID',
  `start_event_bind` varchar(255) NOT NULL DEFAULT 'create' COMMENT '流程发起事件绑定到的方法:默认为create',
  `start_conditions` text COMMENT '流程发起的条件 JSON,由Helpers解析',
  `personnel_scope` text COMMENT '流程发起的人员范围 JSON,由Helpers解析',
  `describe` varchar(255) DEFAULT NULL COMMENT '描述',
  `created_at` int(11) DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_version` (`id`,`version`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_business_form`
-- ----------------------------
CREATE TABLE `workflow_business_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `form_id` binary(8) NOT NULL,
  `business_id` binary(8) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_edge`
-- ----------------------------
CREATE TABLE `workflow_edge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `describe` varchar(255) DEFAULT NULL,
  `condition` text,
  `source_node_id` int(11) DEFAULT NULL,
  `target_node_id` int(11) DEFAULT NULL,
  `source_dom_id` varchar(20) DEFAULT NULL,
  `target_dom_id` varchar(20) DEFAULT NULL,
  `dom_id` varchar(255) DEFAULT NULL,
  `source_anchor` varchar(255) DEFAULT NULL,
  `target_anchor` varchar(255) DEFAULT NULL,
  `parent` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `source_node_id` (`source_node_id`),
  KEY `target_node_id` (`target_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_group`
-- ----------------------------
CREATE TABLE `workflow_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `workflow_group`
-- ----------------------------
BEGIN;
INSERT INTO `workflow_group` VALUES ('1', '默认组', '0', '1', '1', '1'), ('2', '默认', '1', '1', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `workflow_inner_form`
-- ----------------------------
CREATE TABLE `workflow_inner_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `form_id` char(8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance`
-- ----------------------------
CREATE TABLE `workflow_instance` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `finish_at` int(11) DEFAULT NULL,
  `stop_at` int(11) DEFAULT NULL,
  `cancel_at` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `data_id` int(11) DEFAULT NULL COMMENT '关联的对象id',
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_business_form`
-- ----------------------------
CREATE TABLE `workflow_instance_business_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) DEFAULT NULL,
  `form_id` binary(8) DEFAULT NULL,
  `instance_id` int(11) DEFAULT NULL,
  `data_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_edge`
-- ----------------------------
CREATE TABLE `workflow_instance_edge` (
  `instance_id` int(11) NOT NULL,
  `edge_id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`instance_id`,`edge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_event_label`
-- ----------------------------
CREATE TABLE `workflow_instance_event_label` (
  `event` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `log_label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`event`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_log`
-- ----------------------------
CREATE TABLE `workflow_instance_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `instance_id` int(11) DEFAULT NULL,
  `node_id` int(11) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `variable` mediumtext,
  `node_variable` mediumtext,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `instance_id` (`instance_id`),
  KEY `node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_node`
-- ----------------------------
CREATE TABLE `workflow_instance_node` (
  `instance_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `plan_finish_at` int(11) DEFAULT NULL,
  `start_at` int(11) DEFAULT NULL,
  `finish_at` int(11) DEFAULT NULL,
  `form_data_id` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `start_user_id` int(11) DEFAULT NULL,
  `push_user_id` int(11) DEFAULT NULL,
  `handle_status` tinyint(1) DEFAULT '0',
  `approval_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`instance_id`,`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_node_group`
-- ----------------------------
CREATE TABLE `workflow_instance_node_group` (
  `instance_id` int(11) NOT NULL,
  `node_group_id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `plan_start_at` int(11) DEFAULT NULL,
  `plan_finish_at` int(11) DEFAULT NULL,
  `start_at` int(11) DEFAULT NULL,
  `finish_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`instance_id`,`node_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_node_personnel`
-- ----------------------------
CREATE TABLE `workflow_instance_node_personnel` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `instance_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_handle` tinyint(1) DEFAULT '0' COMMENT '是否已处理',
  `created_at` int(11) DEFAULT NULL,
  `handle_at` int(11) DEFAULT NULL,
  `approval_status` tinyint(1) DEFAULT '0' COMMENT '0-未处理 1审核通过 2审核不通过',
  `approval_remark` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_node_variable`
-- ----------------------------
CREATE TABLE `workflow_instance_node_variable` (
  `instance_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `variable_name` varchar(255) NOT NULL,
  `variable_id` int(11) NOT NULL,
  `variable_label` varchar(255) DEFAULT NULL,
  `variable_value` varchar(2500) DEFAULT NULL,
  `form_data_id` int(11) DEFAULT '0',
  PRIMARY KEY (`instance_id`,`node_id`,`variable_name`),
  KEY `variable_id` (`variable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_instance_variable`
-- ----------------------------
CREATE TABLE `workflow_instance_variable` (
  `instance_id` int(11) NOT NULL,
  `variable_id` int(11) NOT NULL,
  `variable_name` varchar(255) NOT NULL,
  `variable_value` varchar(2500) DEFAULT NULL,
  PRIMARY KEY (`instance_id`,`variable_id`),
  UNIQUE KEY `name` (`instance_id`,`variable_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_node`
-- ----------------------------
CREATE TABLE `workflow_node` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `describe` varchar(255) DEFAULT NULL,
  `is_master` tinyint(1) DEFAULT '1' COMMENT '是否为主线节点',
  `type` varchar(255) DEFAULT NULL COMMENT '已注册的节点组件名称',
  `data` text COMMENT '配置JSON',
  `group_id` int(11) DEFAULT '0',
  `is_attention` tinyint(1) DEFAULT '0',
  `personnel_scope` text,
  `dom_id` varchar(255) DEFAULT NULL,
  `position_x` float DEFAULT '0',
  `position_y` float DEFAULT '0',
  `is_verification` tinyint(1) DEFAULT '0' COMMENT '配置数据是否验证通过',
  `size` varchar(255) DEFAULT NULL,
  `shape` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `handle_status_type` tinyint(1) DEFAULT '1' COMMENT '1一个处理 2多数处理 3全部处理',
  `approval_status_type` tinyint(1) DEFAULT '1' COMMENT '1多数通过 2全部通过 3一票否决',
  `sort_order` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `workflow_id` (`workflow_id`),
  KEY `workflow_id_type` (`workflow_id`,`type`),
  KEY `dom_id` (`dom_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_node_after_action`
-- ----------------------------
CREATE TABLE `workflow_node_after_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `action_config` text,
  PRIMARY KEY (`id`),
  KEY `workflow_id` (`workflow_id`),
  KEY `node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_node_business_form`
-- ----------------------------
CREATE TABLE `workflow_node_business_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `form_id` binary(8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `node_id` (`node_id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_node_group`
-- ----------------------------
CREATE TABLE `workflow_node_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `describe` varchar(255) DEFAULT NULL,
  `workflow_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `dom_id` varchar(255) DEFAULT NULL,
  `position_x` float DEFAULT NULL,
  `position_y` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_node_inner_form`
-- ----------------------------
CREATE TABLE `workflow_node_inner_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `node_id` (`node_id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_node_variable`
-- ----------------------------
CREATE TABLE `workflow_node_variable` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `node_id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `is_entry` tinyint(1) DEFAULT '0' COMMENT '是否是重复新增的多行分录',
  `is_entity` tinyint(1) DEFAULT '1' COMMENT '是否为实体变量,如果是updateWorkflowForm 则不存储实体',
  `is_required` tinyint(1) DEFAULT '1',
  `is_visible` tinyint(1) DEFAULT '1',
  `is_system` tinyint(1) DEFAULT '0',
  `ref_type` varchar(255) DEFAULT NULL COMMENT 'form null',
  `ref_id` varchar(255) DEFAULT '0',
  `ref_data_id` int(11) DEFAULT '0',
  `ref_field_id` varchar(8) DEFAULT '0',
  `source_type` varchar(255) DEFAULT NULL COMMENT '源类型 null || flow  || node_??',
  `source_id` int(11) DEFAULT '0' COMMENT '源变量 ID',
  `source_data_id` int(11) DEFAULT '0' COMMENT '源数据 如果是一个多行变量元素??',
  `source_writeback` tinyint(1) DEFAULT '0' COMMENT '是否回写源变量',
  `source_allow_change` tinyint(1) DEFAULT '0' COMMENT '携带过去的数据是否允许修改',
  `into_global` tinyint(1) DEFAULT '0' COMMENT '是否写入到了全局变量',
  PRIMARY KEY (`id`),
  KEY `node_id` (`node_id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_variable`
-- ----------------------------
CREATE TABLE `workflow_variable` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `is_entry` tinyint(1) DEFAULT '0' COMMENT '是否是重复新增的多行分录',
  `is_entity` tinyint(1) DEFAULT '1' COMMENT '是否为实体变量,如果是updateWorkflowForm 则不存储实体',
  `is_required` tinyint(1) DEFAULT '0',
  `is_visible` tinyint(1) DEFAULT '1',
  `is_system` tinyint(1) DEFAULT '0' COMMENT '是否为系统预设的变量',
  `ref_type` varchar(255) DEFAULT NULL COMMENT 'form null',
  `ref_id` int(11) DEFAULT '0',
  `ref_data_id` int(11) DEFAULT '0',
  `ref_field_id` int(11) DEFAULT '0',
  `source_type` varchar(255) DEFAULT NULL COMMENT '源类型 null || flow  || node_??',
  `source_id` int(11) DEFAULT '0' COMMENT '源变量 ID',
  `source_data_id` int(11) DEFAULT '0' COMMENT '源数据 如果是一个多行变量元素??',
  `source_writeback` tinyint(1) DEFAULT '0' COMMENT '是否回写源变量',
  `source_allow_change` tinyint(1) DEFAULT '0' COMMENT '携带过去的数据是否允许修改',
  PRIMARY KEY (`id`),
  KEY `workflow_id` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `workflow_version`
-- ----------------------------
CREATE TABLE `workflow_version` (
  `workflow_id` int(11) NOT NULL,
  `version` int(5) unsigned zerofill NOT NULL,
  PRIMARY KEY (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

