MySQL创建表报错信息：Row size too large (＞ 8126) 解决方案_row size too large (> 8126)

问题

1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
1

解决方案：

关闭InnoDB严格模式

set global innodb_strict_mode  = 0;
1

刷新配置

FLUSH PRIVILEGES 
1

再次导入即可

CREATE TABLE `accounting_rules` (
  `ID` bigint(20) NOT NULL COMMENT '主键ID',
  `BIZ_ID` bigint(20) NOT NULL COMMENT '业务信息表ID',
  `SOL_ID` bigint(20) NOT NULL COMMENT '业务应用方案ID',
  `DEPLOY_FORM_ID` bigint(20) NOT NULL COMMENT '自由表单发布ID',
  `MAIN_TABLE_ID` bigint(20) NOT NULL COMMENT '浮动表存储主表ID',
  `POST_ID` bigint(20) DEFAULT NULL COMMENT '岗位ID',
  `POST_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '岗位编码',
  `POST_NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '岗位名称',
  `DEPT_ID` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `DEPT_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '部门编码',
  `DEPT_NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '部门名称',
  `ORG_ID` bigint(20) DEFAULT NULL COMMENT '单位ID',
  `ORG_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '单位编码',
  `ORG_NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '单位名称',
  `DR` tinyint(4) DEFAULT NULL COMMENT '是否删除',
  `SORT` double(14,4) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `CREATE_USER_ID` bigint(20) DEFAULT NULL COMMENT '创建人ID',
  `CREATE_IDENTITY_ID` bigint(20) DEFAULT NULL COMMENT '创建人岗人ID',
  `TENANT_ID` bigint(20) DEFAULT NULL COMMENT '租户ID',
  `CREATE_USER_NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人名称',
  `UPDATE_TIME` bigint(20) DEFAULT NULL COMMENT '更新时间',
  `UPDATE_IDENTITY_ID` bigint(20) DEFAULT NULL COMMENT '更新人岗人ID',
  `DATADRIVE_RELATION_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '单据信息关联ID',
  `PAYMENT_ME_TLDT_` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '支付方式',
  `RECEIPT_TYPE_TLDT_` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '收款类型',
  `PAYMENT_METHOD_TLDT_` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '收款方式',
  `LEDGER_ACCOUNTS` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '会计科目',
  `PROJECT_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '项目_BIZ_SOL_ID',
  `PROJECT_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '项目_ID',
  `PROJECT_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '项目_CODE',
  `PROJECT` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '项目',
  `FUNC_SUBJECT_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '功能分类_BIZ_SOL_ID',
  `FUNC_SUBJECT_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '功能分类_ID',
  `FUNC_SUBJECT_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '功能分类_CODE',
  `FEATURE_CLASS` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '功能分类',
  `EXPENSE_CLASS` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '支出分类',
  `FRONT` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '前一位编码值',
  `PARENT_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '父ID',
  `ACCOUNT_SET_INFO` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '账套信息',
  `USED_YEAR` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '年度',
  `UNIT_INFORMATION` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '单位信息',
  `ECONOMIC_SUBJECT_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '经济分类_BIZ_SOL_ID',
  `ECONOMIC_SUBJECT_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '经济分类_ID',
  `ECONOMIC_SUBJECT_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '经济分类_CODE',
  `ECONOMIC_SUBJECTS` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '经济科目',
  `EXPENSE_ITEM` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '费用项',
  `EXPENSE_TYPE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '支出类型',
  `DOCUMENT_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '单据类型_BIZ_SOL_ID',
  `DOCUMENT_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '单据类型_ID',
  `DOCUMENT_COME` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'DOCUMENT_COME',
  `ACCOUNT_SET_INFO_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'ACCOUNT_SET_INFO_BIZ_SOL_ID',
  `ACCOUNT_SET_INFO­_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'ACCOUNT_SET_INFO­_ID',
  `ACCOUNT_SET_INFO_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'ACCOUNT_SET_INFO_CODE',
  `UNIT_INFORMATION_SOL_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'UNIT_INFORMATION_SOL_ID',
  `UNIT_INFORMATION_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'UNIT_INFORMATION­_ID',
  `UNIT_INFORMATION_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '单位信息_CODE',
  `LEDGER_ACCOUNTS_SOL_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'LEDGER_ACCOUNTS_SOL_ID',
  `LEDGER_ACCOUNTS_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'LEDGER_ACCOUNTS_ID',
  `LEDGER_ACCOUNTS_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'LEDGER_ACCOUNTS_CODE',
  `EXPENSE_TYPE_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'EXPENSE_TYPE_SOL_ID',
  `EXPENSE_TYPE_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '支出类型_ID',
  `EXPENSE_TYPE_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'EXPENSE_TYPE_CODE',
  `EXPENSE_ITEM_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'EXPENSE_ITEM_SOL_ID',
  `EXPENSE_ITEM_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '费用项_ID',
  `EXPENSE_ITEM_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '费用项_CODE',
  `ECONOMIC_SUBJECTS_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'ECONOMIC_SUBJECTS_SOL_ID',
  `ECONOMIC_SUBJECTS_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'ECONOMIC_SUBJECTS_ID',
  `ECONOMIC_SUBJECTS_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'ECONOMIC_SUBJECTS_CODE',
  `DOCUMENT_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '单据类型_CODE',
  `ACCOUNT_SET_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '账套信息_BIZ_SOL_ID',
  `ACCOUNT_SET_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '账套信息_ID',
  `ACCOUNT_SET_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '账套信息_CODE',
  `BASIC_DATA_SUBJECT_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '会计科目_BIZ_SOL_ID',
  `BASIC_DATA_SUBJECT_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '会计科目_ID',
  `BASIC_DATA_SUBJECT_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '会计科目_CODE',
  `BASIC_DATA_SUBJECT_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '会计科目',
  `PROJECT_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '项目',
  `FUNC_SUBJECT_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '功能分类',
  `ECONOMIC_SUBJECT_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '经济分类',
  `EXPENSE_TYPE_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '支出类型',
  `EXPENSE_ITEM_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '费用项',
  `NATURE_OF_EXPENDITURE_BIZ_SOL_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '支出性质_BIZ_SOL_ID',
  `NATURE_OF_EXPENDITURE_ID` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '支出性质_ID',
  `NATURE_OF_EXPENDITURE_CODE` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '支出性质_CODE',
  `NATURE_OF_EXPENDITURE_NAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '支出性质',
  `BIZ_STATUS` varchar(20) COLLATE utf8_bin DEFAULT '0' COMMENT '业务状态',
  `BORROWERS` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '借贷方',
  `BORROWERS_TLDT_` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '借贷方',
  `DOCUMENT_NAME` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '单据类型',
  `PAY_TYPE_BIZ_SOL_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'PAY_TYPE_BIZ_SOL_ID',
  `PAY_TYPE_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'PAY_TYPE_ID',
  `PAY_TYPE_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'PAY_TYPE_CODE',
  `PAY_TYPE_NAME` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '支出类型',
  `ACCOUNT_SET_NAME` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '账套信息',
  `SOURCE_OF_FUNDS_BIZ_SOL_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'SOURCE_OF_FUNDS_BIZ_SOL_ID',
  `SOURCE_OF_FUNDS_ID` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'SOURCE_OF_FUNDS_ID',
  `SOURCE_OF_FUNDS_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'SOURCE_OF_FUNDS_CODE',
  `SOURCE_OF_FUNDS_NAME` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '资金来源',
  `TITLE` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '业务标题',
  `DRAFT_USER_ID` bigint(20) DEFAULT NULL COMMENT '拟稿人ID',
  `DRAFT_USER_NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '拟稿人名称',
  `BIZ_SOL_NAME` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '业务方案名称',
  `PRESENT` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '当前编码数值',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `CMA_ACCOUNTING_RULES_BIZ_id` (`BIZ_ID`) USING BTREE COMMENT '业务信息ID索引',
  KEY `CMA_ACCOUNTING_RULES_SOL_id` (`SOL_ID`) USING BTREE COMMENT '业务应用方案ID索引',
  KEY `CMA_ACCOUNTING_RULES_MAIN_TABLE_ID` (`MAIN_TABLE_ID`) USING BTREE COMMENT '主表信息ID索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110