-- ---------------------------
-- 数据导出任务表
-- ---------------------------
CREATE TABLE IF NOT EXISTS `__PREFIX__fastexport` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '导出人',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '任务名称',
  `main_table` varchar(50) NOT NULL DEFAULT '' COMMENT '数据源表',
  `field_config` text COMMENT '字段配置',
  `join_table` text COMMENT '关联表配置',
  `where_field` text COMMENT '筛选规则',
  `order_field` varchar(50) NOT NULL DEFAULT '' COMMENT '排序字段',
  `order_type` varchar(4) NOT NULL DEFAULT '' COMMENT '排序方式',
  `xls_max_number` int(7) unsigned NOT NULL DEFAULT '10000' COMMENT '单个xls最大记录数',
  `xls_create_concurrent` tinyint(3) unsigned NOT NULL DEFAULT '3' COMMENT 'xls创建并发',
  `memory_limit` decimal(8,0) unsigned NOT NULL DEFAULT '128' COMMENT '脚本内存限制(Mb)',
  `export_number` int(10) unsigned DEFAULT NULL COMMENT '导出记录数',
  `subtask` text COMMENT '子任务资料',
  `progress` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '导出进度',
  `file` varchar(255) NOT NULL DEFAULT '' COMMENT '文件包',
  `createtime` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据导出表';