


-- ----------------------------
-- Table structure for siger_project_dashboard_fixpath
-- ----------------------------
DROP TABLE IF EXISTS `siger_project_dashboard_fixpath`;
CREATE TABLE `siger_project_dashboard_fixpath` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '工位名称',
  `x` int NOT NULL,
  `y` int NOT NULL,
  `stationid` int NOT NULL DEFAULT '0' COMMENT '设备id',
  `guid` varchar(255) NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '1',
  `projectid` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
SET FOREIGN_KEY_CHECKS=1;



ALTER TABLE siger_project_dashboard_comb_page_condition ADD COLUMN lampStatus int(11) DEFAULT 0 COMMENT '灯的状态';
ALTER TABLE siger_project_dashboard_comb_page_condition ADD COLUMN layout varchar(250) DEFAULT 0 COMMENT '设备布局图';
ALTER TABLE siger_project_dashboard_comb_page_condition ADD COLUMN guid varchar(250) NOT NULL DEFAULT 'guid' ;

-- 大数据数据库
ALTER TABLE CNC_Production ADD COLUMN CycleTime double NULL ;


ALTER TABLE siger_project_working_machine_set ADD COLUMN station_id int(11) DEFAULT 0 COMMENT '工位id';

ALTER TABLE siger_level ADD COLUMN sorting int(11) DEFAULT 0 COMMENT '排序id';



--2020-10-15

CREATE TABLE `siger_tr_cjrf_today_alarm_top5` (
  `id` int NOT NULL AUTO_INCREMENT,
  `station` varchar(255) NOT NULL DEFAULT '' COMMENT '工位',
  `duration` int NOT NULL DEFAULT '0' COMMENT '持续时长',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;

CREATE TABLE `siger_tr_cjrf_time_efficiency_top10` (
  `id` int NOT NULL AUTO_INCREMENT,
  `station` varchar(255) NOT NULL DEFAULT '' COMMENT '工位',
  `percent` int NOT NULL DEFAULT '0' COMMENT '百分比',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;

CREATE TABLE `siger_tr_cjrf_time_efficiency` (
  `id` int NOT NULL AUTO_INCREMENT,
  `timeEfficiencyV` int NOT NULL DEFAULT '0' COMMENT '时间稼动率',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;

CREATE TABLE `siger_tr_cjrf_realtime_alarm` (
  `id` int NOT NULL AUTO_INCREMENT,
  `station` varchar(255) NOT NULL DEFAULT '' COMMENT '工位',
  `alarmContent` varchar(255) NOT NULL DEFAULT '' COMMENT '报警内容',
  `duration` int NOT NULL DEFAULT '0' COMMENT '持续时长',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;

CREATE TABLE `siger_tr_cjrf_device_status_summary_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `runNum` int NOT NULL DEFAULT '0' COMMENT '运行设备数量',
  `debugNum` int NOT NULL DEFAULT '0' COMMENT '调试设备数量',
  `freeNum` int NOT NULL DEFAULT '0' COMMENT '空闲设备数量',
  `errorNum` int NOT NULL DEFAULT '0' COMMENT '报警设备数量',
  `closeNum` int NOT NULL DEFAULT '0' COMMENT '关机设备数量',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;

CREATE TABLE `siger_tr_cjrf_device_status_distribute_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hour1` int NOT NULL DEFAULT '0' COMMENT '运行时长',
  `hour2` int NOT NULL DEFAULT '0' COMMENT '调试时长 ',
  `hour3` int NOT NULL DEFAULT '0' COMMENT '空闲时长',
  `hour4` int NOT NULL DEFAULT '0' COMMENT '报警时长',
  `hour5` int NOT NULL DEFAULT '0' COMMENT '关机时长',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;

CREATE TABLE `siger_tr_cjrf_device_real_time_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `station` varchar(255) NOT NULL DEFAULT '' COMMENT '工位',
  `deviceNo` varchar(255) NOT NULL DEFAULT '' COMMENT '设备编号',
  `deviceName` varchar(255) NOT NULL DEFAULT '' COMMENT '设备名称',
  `devicePurpose` varchar(255) NOT NULL DEFAULT '' COMMENT '设备用途',
  `deviceWarn` varchar(255) NOT NULL DEFAULT '' COMMENT '设备报警信息',
  `duration` int NOT NULL DEFAULT '0' COMMENT '持续时长',
  `x` int NOT NULL DEFAULT '0' COMMENT '横坐标',
  `y` int NOT NULL DEFAULT '0' COMMENT '纵坐标',
  `type` int NOT NULL DEFAULT '0' COMMENT '类型',
  `projectid` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `current_status` int NOT NULL DEFAULT '0' COMMENT '当前状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;



--SaaS监控大屏

CREATE TABLE `siger_tr_saas_monitor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) NOT NULL DEFAULT '' COMMENT '客户名称',
  `machine_quantity` int NOT NULL DEFAULT '0' COMMENT '设备数量',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '市',
  `area` varchar(255) NOT NULL DEFAULT '' COMMENT '区',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '用户详细地址',
  `longitude` varchar(255) NOT NULL DEFAULT '' COMMENT '经度',
  `latitude` varchar(255) NOT NULL DEFAULT '' COMMENT '纬度',
  `signing_time` datetime DEFAULT NULL COMMENT '签约时间',
  `projectid` int NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;


2020-12-23

ALTER TABLE siger_projectId_plan_machine_route ADD COLUMN debugEndTime int NOT NULL DEFAULT '0' ;

-- ----------------------------
-- 新增 字段 :应急维护，计划维护推送时间间隔按项目区分
-- 家伟
-- 日期20210111
-- ----------------------------

ALTER TABLE siger_project_repair_report ADD COLUMN repeat_time int(11) DEFAULT 5 COMMENT '应急维护推送间隔';
ALTER TABLE siger_project_plan_report ADD COLUMN repeat_time int(11) DEFAULT 5 COMMENT '计划维护推送间隔';




/*
 Navicat Premium Data Transfer

 -- ----------------------------
-- 徕斯 自动化生产线
-- 家伟
-- 日期20210119
-- ----------------------------

 Date: 19/01/2021 14:43:24
*/


SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 工装类型维护
-- Table structure for siger_automation_fixture_tools_category
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_fixture_tools_category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parent` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'siger_automation_fixture_tools_category.guid',
  `projectid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `createtime` datetime(0) NOT NULL,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 工装台账信息
-- Table structure for siger_automation_fixture_tools
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_fixture_tools`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `category` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装类别siger_automation_fixture_tools_category.guid',
  `managetype` int(11) NOT NULL DEFAULT 0 COMMENT '管理类型',
  `partnumber` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装料号',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装名称',
  `specification` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格型号',
  `number` int(11) NOT NULL DEFAULT 0 COMMENT '数量',
  `remark` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `attachment` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',
  `filename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件名称',
  `code` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装编号',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态',
  `createtime` datetime(0) NOT NULL,
  `creator` int(11) NOT NULL DEFAULT 0,
  `updator` int(11) NOT NULL DEFAULT 0,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 工装装配信息
-- Table structure for siger_automation_fixture_tools_assembly
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_fixture_tools_assembly`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parent` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父类工装GUID',
  `son` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装GUID',
  `attachment` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',
  `filename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件名称',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `creator` int(11) NOT NULL DEFAULT 0,
  `createtime` datetime(0) NOT NULL,
  `updator` int(11) NOT NULL DEFAULT 0,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 工装类型应产品
-- Table structure for siger_automation_fixture_tools_product
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_fixture_tools_product`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `fixturetools` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'siger_automation_fixture_tools.guid',
  `productid` int(11) NOT NULL DEFAULT 0 COMMENT '产品ID',
  `remark` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `creator` int(11) NOT NULL DEFAULT 0,
  `createtime` datetime(0) NOT NULL,
  `updator` int(11) NOT NULL DEFAULT 0,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 储位工装信息
-- Table structure for siger_automation_location
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_location`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `locationid` int(11) NOT NULL DEFAULT 0 COMMENT '储位位置',
  `fixturetools` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装GUID',
  `materialid` int(11) NOT NULL DEFAULT 0 COMMENT '物料ID',
  `processid` int(11) NOT NULL DEFAULT 0 COMMENT '工序ID',
  `materialstate` int(11) NOT NULL DEFAULT 0 COMMENT '物料状态',
  `attachment` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',
  `filename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件名称',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `updator` int(11) NOT NULL DEFAULT 0,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `projectid` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 工位属性
-- Table structure for siger_automation_section_property
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_section_property`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sectionid` int(11) NOT NULL DEFAULT 0 COMMENT '工位ID',
  `propertytype` int(11) NOT NULL DEFAULT 0 COMMENT '1:上下料工位2:加工工位3:检验工位4:装配工位5:存储工位',
  `upload` int(11) NOT NULL DEFAULT 0 COMMENT '0:不是上料1:是上料',
  `down` int(11) NOT NULL DEFAULT 0 COMMENT '0:不是下料1:是下料',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `createtime` datetime(0) NOT NULL,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 自动线路径
-- Table structure for siger_automation_section_route
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_section_route`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sectionid` int(11) NOT NULL DEFAULT 0 COMMENT '产线',
  `startsection` int(11) NOT NULL DEFAULT 0 COMMENT '开始工位',
  `endsection` int(11) NOT NULL DEFAULT 0 COMMENT '目标工位',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `createtime` datetime(0) NOT NULL,
  `updatetime` datetime(0) NULL DEFAULT NULL,
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 任务清单管理
-- Table structure for siger_automation_task_list
-- ----------------------------
CREATE TABLE IF NOT EXISTS `siger_automation_task_list`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sectionid` int(11) NOT NULL DEFAULT 0 COMMENT '工位ID',
  `trigger` int(1) NOT NULL DEFAULT 0 COMMENT '触发方',
  `tasktype` int(1)  NOT NULL DEFAULT 0 COMMENT '任务类型',
  `materialid` int(11) NOT NULL DEFAULT 0 COMMENT '工件ID',
  `ordercode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工单号',
  `productid` int(11) NOT NULL DEFAULT 0 COMMENT '产品ID',
  `processid` int(11) NOT NULL DEFAULT 0 COMMENT '工序ID',
  `programnumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '程序号',
  `locationid` int(11) NOT NULL COMMENT '储位位置',
  `fixturetools` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工装GUID',
  `action` int(1) NOT NULL DEFAULT 0 COMMENT '动作',
  `actiontype` int(11) NOT NULL DEFAULT 0 COMMENT '动作类型',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `send` int(1) NOT NULL DEFAULT 0 COMMENT '0:未下发 1:已下发',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '任务进度状态：0 取消 1待生产 2生产中 3生产完成',
  `triggertime` datetime(0) NOT NULL COMMENT '触发时间',
  `completetime` datetime(0) NULL DEFAULT NULL COMMENT '完成时间',
  `operater` int(11) NOT NULL DEFAULT 0 COMMENT '操作人',
  `operatetime` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `extend1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 设备可用状态
-- Table structure for siger_automation_task_list
-- ----------------------------
DROP TABLE IF EXISTS `siger_automation_machine_status`;
CREATE TABLE `siger_automation_machine_status`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` int(11) NOT NULL DEFAULT 0 COMMENT '工位ID',
  `machineid` int(11) NOT NULL DEFAULT 0 COMMENT '工位对应设备ID',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `enable` int(1) NOT NULL DEFAULT 1 COMMENT '设备可用状态 0:不可用 1:可用',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '完工状态 0：取消 1:待生产 2:生产中 3:生产完成 ',
  `updatetime` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;


-- ----------------------------
-- 生产线模式
-- Table structure for siger_automation_line_mode
DROP TABLE IF EXISTS `siger_automation_line_mode`;
CREATE TABLE `siger_automation_line_mode`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` int(11) NOT NULL DEFAULT 0 COMMENT '产线ID',
  `projectid` int(11) NOT NULL DEFAULT 0,
  `mode` int(1) NOT NULL DEFAULT 1 COMMENT '0:手动模式 1：自动模式',
  `inspect` int(1) NOT NULL DEFAULT 1 COMMENT '0:不需要检验 1：检验',
  `updatetime` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
