解决创建表时有联合主键问题,多个字段用``括起来,成为一个字段,报Key column 'CO_ITEM_CODE,CO_ITEM_FACTORY' doesn't exist in table错误
已修改1个文件
2 ■■■ 文件已修改
product-server-data-center/src/main/java/com/product/data/center/service/DataArchivingService.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
product-server-data-center/src/main/java/com/product/data/center/service/DataArchivingService.java
@@ -1081,7 +1081,7 @@
                for (String indexName : indexInfoObj.keySet()) {
                    singleFieldInfoObj = indexInfoObj.getJSONObject(indexName);
                    if (CmnConst.PRIMARY.equalsIgnoreCase(indexName) || CmnConst.PRIMARY.equalsIgnoreCase(singleFieldInfoObj.getString(CmnConst.TYPE))) {
                        sql.append("\n    PRIMARY KEY (`").append(singleFieldInfoObj.getString(CmnConst.COLUMN_NAME)).append("`) USING BTREE,");
                        sql.append("\n    PRIMARY KEY (").append(singleFieldInfoObj.getString(CmnConst.COLUMN_NAME)).append(") USING BTREE,");
                    } else if (CmnConst.UNIQUE.equalsIgnoreCase(singleFieldInfoObj.getString(CmnConst.TYPE))) {
                        sql.append("\n    UNIQUE INDEX `").append(indexName).append("`(").append(singleFieldInfoObj.getString(CmnConst.COLUMN_NAME)).append(") USING BTREE,");
                    } else if (CmnConst.NORMAL.equalsIgnoreCase(singleFieldInfoObj.getString(CmnConst.TYPE))) {