   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
   `create_by` int(11) NULL DEFAULT NULL COMMENT '创建人',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1313 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1321 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of system_log
+-- ----------------------------
+INSERT INTO `system_log` VALUES (1313, NULL, 'success', '{\n	\"result\":true,\n	\"code\":200,\n	\"data\":{\n		\"createBy\":0,\n		\"del\":0,\n		\"fieldMap\":{\n			\"phone\":\"phone\",\n			\"name\":\"name\",\n			\"words\":\"words\"\n		},\n		\"id\":\"41\",\n		\"modelAppId\":1,\n		\"modelCustomType\":\"post\",\n		\"modelField\":\"[\\r\\n{\\r\\n            \\\"model\\\":\\\"name\\\",\\r\\n            \\\"key\\\":\\\"name\\\",\\r\\n            \\\"javaType\\\":\\\"String\\\",\\r\\n            \\\"jdbcType\\\":\\\"VARCHAR\\\",\\r\\n            \\\"name\\\":\\\"姓名\\\",\\r\\n            \\\"type\\\":\\\"input\\\"\\r\\n            }\\r\\n            ,{\\r\\n            \\\"model\\\":\\\"phone\\\",\\r\\n            \\\"key\\\":\\\"phone\\\",\\r\\n            \\\"javaType\\\":\\\"String\\\",\\r\\n            \\\"jdbcType\\\":\\\"VARCHAR\\\",\\r\\n            \\\"name\\\":\\\"手机\\\",\\r\\n            \\\"type\\\":\\\"input\\\"\\r\\n            }\\r\\n            ,{\\r\\n            \\\"model\\\":\\\"words\\\",\\r\\n            \\\"key\\\":\\\"words\\\",\\r\\n            \\\"javaType\\\":\\\"String\\\",\\r\\n            \\\"jdbcType\\\":\\\"VARCHAR\\\",\\r\\n            \\\"name\\\":\\\"留言\\\",\\r\\n            \\\"type\\\":\\\"textarea\\\"\\r\\n            }\\r\\n]\",\n		\"modelJson\":\"{\\\"html\\\":\\\"<template id=\\\\\\\"custom-model\\\\\\\">\\\\r\\\\n    <el-form ref=\\\\\\\"form\\\\\\\" :model=\\\\\\\"form\\\\\\\" :rules=\\\\\\\"rules\\\\\\\" label-width=\\\\\\\"120px\\\\\\\" label-position=\\\\\\\"right\\\\\\\" size=\\\\\\\"small\\\\\\\">\\\\r\\\\n            <el-form-item  label=\\\\\\\"姓名\\\\\\\" prop=\\\\\\\"name\\\\\\\"\\\\r\\\\n>\\\\r\\\\n                <el-input v-model=\\\\\\\"form.name\\\\\\\"\\\\r\\\\n                          :disabled=\\\\\\\"false\\\\\\\"\\\\r\\\\n                          :style=\\\\\\\"{width:  \'100%\'}\\\\\\\"\\\\r\\\\n                          :clearable=\\\\\\\"true\\\\\\\"\\\\r\\\\n                          placeholder=\\\\\\\"请输入姓名\\\\\\\">\\\\r\\\\n                </el-input>\\\\r\\\\n            </el-form-item>\\\\r\\\\n            <el-form-item  label=\\\\\\\"手机\\\\\\\" prop=\\\\\\\"phone\\\\\\\"\\\\r\\\\n>\\\\r\\\\n                <el-input v-model=\\\\\\\"form.phone\\\\\\\"\\\\r\\\\n                          :disabled=\\\\\\\"false\\\\\\\"\\\\r\\\\n                          :style=\\\\\\\"{width:  \'100%\'}\\\\\\\"\\\\r\\\\n                          :clearable=\\\\\\\"true\\\\\\\"\\\\r\\\\n                          placeholder=\\\\\\\"请输入手机\\\\\\\">\\\\r\\\\n                </el-input>\\\\r\\\\n            </el-form-item>\\\\r\\\\n            <el-form-item  label=\\\\\\\"留言\\\\\\\" prop=\\\\\\\"words\\\\\\\"\\\\r\\\\n>\\\\r\\\\n                <el-input\\\\r\\\\n                        type=\\\\\\\"textarea\\\\\\\" :rows=\\\\\\\"5\\\\\\\"\\\\r\\\\n                        :disabled=\\\\\\\"false\\\\\\\"\\\\r\\\\n\\\\r\\\\n                        v-model=\\\\\\\"form.words\\\\\\\"\\\\r\\\\n                        :style=\\\\\\\"{width: \'100%\'}\\\\\\\"\\\\r\\\\n                        placeholder=\\\\\\\"请输入留言\\\\\\\">\\\\r\\\\n                </el-input>\\\\r\\\\n            </el-form-item>\\\\r\\\\n    </el-form>\\\\r\\\\n</template>\\\\r\\\\n\\\",\\\"script\\\":\\\"       var custom_model = Vue.component(\\\\\\\"custom-model\\\\\\\",{\\\\r\\\\n            el: \'#custom-model\',\\\\r\\\\n            data() {\\\\r\\\\n                return {\\\\r\\\\n                    modelId:0,\\\\r\\\\n                    //表单数据\\\\r\\\\n                    form: {\\\\r\\\\n                        linkId:0,\\\\r\\\\n                    // 姓名\\\\r\\\\n                    name:\'\',\\\\r\\\\n                    // 手机\\\\r\\\\n                    phone:\'\',\\\\r\\\\n                    // 留言\\\\r\\\\n                    words:\'\',\\\\r\\\\n                    },\\\\r\\\\n                    rules:{\\\\r\\\\n                    },\\\\r\\\\n\\\\r\\\\n                }\\\\r\\\\n            },\\\\r\\\\n            watch:{\\\\r\\\\n            },\\\\r\\\\n            computed:{\\\\r\\\\n            },\\\\r\\\\n            methods: {\\\\r\\\\n                validate(){\\\\r\\\\n                    var b = false\\\\r\\\\n                    this.$refs.form.validate((valid) => {\\\\r\\\\n                        b = valid;\\\\r\\\\n                    });\\\\r\\\\n                    return b;\\\\r\\\\n                },\\\\r\\\\n                save() {\\\\r\\\\n                    var that = this;\\\\r\\\\n                    var success = false;\\\\r\\\\n                    var url = ms.manager + \\\\\\\"/mdiy/model/data/save.do\\\\\\\"\\\\r\\\\n                    if (that.form.id > 0) {\\\\r\\\\n                    url = ms.manager + \\\\\\\"/mdiy/model/data/update.do\\\\\\\";\\\\r\\\\n                    }\\\\r\\\\n                    this.$refs.form.validate((valid) => {\\\\r\\\\n                        if (valid) {\\\\r\\\\n                            var data = JSON.parse(JSON.stringify(that.form));\\\\r\\\\n                            data.modelId = that.modelId;\\\\r\\\\n                            ms.http.post(url, data).then(function (res) {\\\\r\\\\n                                if (res.data.id > 0) {\\\\r\\\\n                                    success = true;\\\\r\\\\n                                }\\\\r\\\\n                            });\\\\r\\\\n                        } else {\\\\r\\\\n                            return false;\\\\r\\\\n                        }\\\\r\\\\n                    })\\\\r\\\\n                    return success;\\\\r\\\\n                },\\\\r\\\\n                //获取当前意见反馈\\\\r\\\\n                get(id) {\\\\r\\\\n                    var that = this;\\\\r\\\\n                    ms.http.get(ms.manager + \\\\\\\"/mdiy/model/data.do\\\\\\\", {modelId:this.modelId,linkId:id}).then(function (res) {\\\\r\\\\n                            if(res.result&&res.data){\\\\r\\\\n                            that.form = res.data;\\\\r\\\\n                        }\\\\r\\\\n                    }).catch(function (err) {\\\\r\\\\n                        console.log(err);\\\\r\\\\n                    });\\\\r\\\\n                },\\\\r\\\\n            },\\\\r\\\\n            created() {\\\\r\\\\n                this.get(this.form.linkId);\\\\r\\\\n            }\\\\r\\\\n        });\\\\r\\\\n\\\\r\\\\n\\\"}\",\n		\"modelName\":\"意见反馈\",\n		\"modelTableName\":\"mdiy_post_feedback\",\n		\"modelType\":\"\",\n		\"sqlWhereList\":[],\n		\"updateBy\":0\n	}\n}', '{\n	\"modelType\":[\"\"],\n	\"modelJson\":[\"{\\\"html\\\":\\\"<template id=\\\\\\\"custom-model\\\\\\\">\\\\r\\\\n    <el-form ref=\\\\\\\"form\\\\\\\" :model=\\\\\\\"form\\\\\\\" :rules=\\\\\\\"rules\\\\\\\" label-width=\\\\\\\"120px\\\\\\\" label-position=\\\\\\\"right\\\\\\\" size=\\\\\\\"small\\\\\\\">\\\\r\\\\n            <el-form-item  label=\\\\\\\"姓名\\\\\\\" prop=\\\\\\\"name\\\\\\\"\\\\r\\\\n>\\\\r\\\\n                <el-input v-model=\\\\\\\"form.name\\\\\\\"\\\\r\\\\n                          :disabled=\\\\\\\"false\\\\\\\"\\\\r\\\\n                          :style=\\\\\\\"{width:  \'100%\'}\\\\\\\"\\\\r\\\\n                          :clearable=\\\\\\\"true\\\\\\\"\\\\r\\\\n                          placeholder=\\\\\\\"请输入姓名\\\\\\\">\\\\r\\\\n                </el-input>\\\\r\\\\n            </el-form-item>\\\\r\\\\n            <el-form-item  label=\\\\\\\"手机\\\\\\\" prop=\\\\\\\"phone\\\\\\\"\\\\r\\\\n>\\\\r\\\\n                <el-input v-model=\\\\\\\"form.phone\\\\\\\"\\\\r\\\\n                          :disabled=\\\\\\\"false\\\\\\\"\\\\r\\\\n                          :style=\\\\\\\"{width:  \'100%\'}\\\\\\\"\\\\r\\\\n                          :clearable=\\\\\\\"true\\\\\\\"\\\\r\\\\n                          placeholder=\\\\\\\"请输入手机\\\\\\\">\\\\r\\\\n                </el-input>\\\\r\\\\n            </el-form-item>\\\\r\\\\n            <el-form-item  label=\\\\\\\"留言\\\\\\\" prop=\\\\\\\"words\\\\\\\"\\\\r\\\\n>\\\\r\\\\n                <el-input\\\\r\\\\n                        type=\\\\\\\"textarea\\\\\\\" :rows=\\\\\\\"5\\\\\\\"\\\\r\\\\n                        :disabled=\\\\\\\"false\\\\\\\"\\\\r\\\\n\\\\r\\\\n                        v-model=\\\\\\\"form.words\\\\\\\"\\\\r\\\\n                        :style=\\\\\\\"{width: \'100%\'}\\\\\\\"\\\\r\\\\n                        placeholder=\\\\\\\"请输入留言\\\\\\\">\\\\r\\\\n                </el-input>\\\\r\\\\n            </el-form-item>\\\\r\\\\n    </el-form>\\\\r\\\\n</template>\\\\r\\\\n\\\",\\\"field\\\":\\\"[\\\\r\\\\n{\\\\r\\\\n            \\\\\\\"model\\\\\\\":\\\\\\\"name\\\\\\\",\\\\r\\\\n            \\\\\\\"key\\\\\\\":\\\\\\\"name\\\\\\\",\\\\r\\\\n            \\\\\\\"javaType\\\\\\\":\\\\\\\"String\\\\\\\",\\\\r\\\\n            \\\\\\\"jdbcType\\\\\\\":\\\\\\\"VARCHAR\\\\\\\",\\\\r\\\\n            \\\\\\\"name\\\\\\\":\\\\\\\"姓名\\\\\\\",\\\\r\\\\n            \\\\\\\"type\\\\\\\":\\\\\\\"input\\\\\\\"\\\\r\\\\n            }\\\\r\\\\n            ,{\\\\r\\\\n            \\\\\\\"model\\\\\\\":\\\\\\\"phone\\\\\\\",\\\\r\\\\n            \\\\\\\"key\\\\\\\":\\\\\\\"phone\\\\\\\",\\\\r\\\\n            \\\\\\\"javaType\\\\\\\":\\\\\\\"String\\\\\\\",\\\\r\\\\n            \\\\\\\"jdbcType\\\\\\\":\\\\\\\"VARCHAR\\\\\\\",\\\\r\\\\n            \\\\\\\"name\\\\\\\":\\\\\\\"手机\\\\\\\",\\\\r\\\\n            \\\\\\\"type\\\\\\\":\\\\\\\"input\\\\\\\"\\\\r\\\\n            }\\\\r\\\\n            ,{\\\\r\\\\n            \\\\\\\"model\\\\\\\":\\\\\\\"words\\\\\\\",\\\\r\\\\n            \\\\\\\"key\\\\\\\":\\\\\\\"words\\\\\\\",\\\\r\\\\n            \\\\\\\"javaType\\\\\\\":\\\\\\\"String\\\\\\\",\\\\r\\\\n            \\\\\\\"jdbcType\\\\\\\":\\\\\\\"VARCHAR\\\\\\\",\\\\r\\\\n            \\\\\\\"name\\\\\\\":\\\\\\\"留言\\\\\\\",\\\\r\\\\n            \\\\\\\"type\\\\\\\":\\\\\\\"textarea\\\\\\\"\\\\r\\\\n            }\\\\r\\\\n]\\\",\\\"title\\\":\\\"意见反馈\\\",\\\"script\\\":\\\"       var custom_model = Vue.component(\\\\\\\"custom-model\\\\\\\",{\\\\r\\\\n            el: \'#custom-model\',\\\\r\\\\n            data() {\\\\r\\\\n                return {\\\\r\\\\n                    modelId:0,\\\\r\\\\n                    //表单数据\\\\r\\\\n                    form: {\\\\r\\\\n                        linkId:0,\\\\r\\\\n                    // 姓名\\\\r\\\\n                    name:\'\',\\\\r\\\\n                    // 手机\\\\r\\\\n                    phone:\'\',\\\\r\\\\n                    // 留言\\\\r\\\\n                    words:\'\',\\\\r\\\\n                    },\\\\r\\\\n                    rules:{\\\\r\\\\n                    },\\\\r\\\\n\\\\r\\\\n                }\\\\r\\\\n            },\\\\r\\\\n            watch:{\\\\r\\\\n            },\\\\r\\\\n            computed:{\\\\r\\\\n            },\\\\r\\\\n            methods: {\\\\r\\\\n                validate(){\\\\r\\\\n                    var b = false\\\\r\\\\n                    this.$refs.form.validate((valid) => {\\\\r\\\\n                        b = valid;\\\\r\\\\n                    });\\\\r\\\\n                    return b;\\\\r\\\\n                },\\\\r\\\\n                save() {\\\\r\\\\n                    var that = this;\\\\r\\\\n                    var success = false;\\\\r\\\\n                    var url = ms.manager + \\\\\\\"/mdiy/model/data/save.do\\\\\\\"\\\\r\\\\n                    if (that.form.id > 0) {\\\\r\\\\n                    url = ms.manager + \\\\\\\"/mdiy/model/data/update.do\\\\\\\";\\\\r\\\\n                    }\\\\r\\\\n                    this.$', '内网IP', '/ms-mcms/ms/mdiy/post/importJson.do', 'msopen', 'manage', 'POST', 'net.mingsoft.mdiy.action.PostAction.importJson()', 'insert', '127.0.0.1', '导入', 0, NULL, NULL, '2020-01-07 14:05:43', NULL);
+INSERT INTO `system_log` VALUES (1314, NULL, 'success', '{\n	\"result\":true,\n	\"code\":200\n}', '{\n	\"modelId\":[\"41\"],\n	\"ids\":[\"1\"]\n}', '内网IP', '/ms-mcms/ms/mdiy/post/data/delete.do', 'msopen', 'manage', 'POST', 'net.mingsoft.mdiy.action.PostAction.delete()', 'delete', '127.0.0.1', '批量删除自数据接口', 0, NULL, NULL, '2020-01-07 14:09:56', NULL);
+INSERT INTO `system_log` VALUES (1315, NULL, 'success', '{\n	\"result\":true,\n	\"code\":200,\n	\"data\":{\n		\"appId\":1,\n		\"contentAuthor\":\"\",\n		\"contentCategoryId\":\"149\",\n		\"contentDatetime\":\"2018-07-09 11:12:00\",\n		\"contentDescription\":\"x\",\n		\"contentDetails\":\"<p>洛龙区人民政府门户网作为洛阳市洛龙区电子政务（网上行政）建设的重要组成部分，是政府信息公开的法定载体，是政府面向社会服务的平台，是公众与政府交流互动的桥梁，是宣传洛龙的主要窗口，对于促进政府信息公开、推进依法行政、接受公众监督、改进行政管理、全面履行政府职能和建设阳光政府具有重要意义。</p>\",\n		\"contentDisplay\":\"0\",\n		\"contentHit\":0,\n		\"contentImg\":\"[{\\\"path\\\":\\\"/upload/1//article/1531105970322.jpg\\\",\\\"url\\\":\\\"/ms-mcms/upload/1//article/1531105970322.jpg\\\",\\\"uid\\\":1578390819577,\\\"status\\\":\\\"success\\\"}]\",\n		\"contentKeyword\":\"x\",\n		\"contentSort\":0,\n		\"contentSource\":\"http://www.luolong.gov.cn/ \",\n		\"contentTitle\":\"洛阳洛龙\",\n		\"contentType\":\"f\",\n		\"contentUrl\":\"/149\\\\222.html\",\n		\"createBy\":0,\n		\"del\":0,\n		\"id\":\"222\",\n		\"order\":\"\",\n		\"remarks\":\"\",\n		\"sqlWhereList\":[],\n		\"updateBy\":0,\n		\"updateDate\":\"2020-01-07 17:53:47\"\n	}\n}', '{\n	\"createDate\":[\"\"],\n	\"id\":[\"222\"],\n	\"remarks\":[\"\"],\n	\"updateDate\":[\"\"],\n	\"order\":[\"\"],\n	\"contentTitle\":[\"洛阳洛龙\"],\n	\"contentCategoryId\":[\"149\"],\n	\"contentType\":[\"f\"],\n	\"contentDisplay\":[\"0\"],\n	\"contentAuthor\":[\"\"],\n	\"contentSource\":[\"http://www.luolong.gov.cn/ \"],\n	\"contentDatetime\":[\"2018-07-09 11:12:00\"],\n	\"contentSort\":[\"0\"],\n	\"contentImg\":[\"[{\\\"path\\\":\\\"/upload/1//article/1531105970322.jpg\\\",\\\"url\\\":\\\"/ms-mcms/upload/1//article/1531105970322.jpg\\\",\\\"uid\\\":1578390819577,\\\"status\\\":\\\"success\\\"}]\"],\n	\"contentDescription\":[\"x\"],\n	\"contentKeyword\":[\"x\"],\n	\"contentDetails\":[\"<p>洛龙区人民政府门户网作为洛阳市洛龙区电子政务（网上行政）建设的重要组成部分，是政府信息公开的法定载体，是政府面向社会服务的平台，是公众与政府交流互动的桥梁，是宣传洛龙的主要窗口，对于促进政府信息公开、推进依法行政、接受公众监督、改进行政管理、全面履行政府职能和建设阳光政府具有重要意义。</p>\"],\n	\"contentUrl\":[\"/149\\\\222.html\"],\n	\"appId\":[\"1\"],\n	\"contentHit\":[\"0\"]\n}', '内网IP', '/ms-mcms/ms/cms/content/update.do', 'msopen', 'manage', 'POST', 'net.mingsoft.cms.action.ContentAction.update()', 'update', '127.0.0.1', '更新文章', 0, NULL, NULL, '2020-01-07 17:53:47', NULL);
+INSERT INTO `system_log` VALUES (1316, NULL, 'success', '{\n	\"result\":true,\n	\"code\":200,\n	\"data\":{\n		\"appId\":1,\n		\"contentAuthor\":\"\",\n		\"contentCategoryId\":\"149\",\n		\"contentDatetime\":\"2018-07-09 11:12:00\",\n		\"contentDescription\":\"\",\n		\"contentDetails\":\"<p>洛龙区人民政府门户网作为洛阳市洛龙区电子政务（网上行政）建设的重要组成部分，是政府信息公开的法定载体，是政府面向社会服务的平台，是公众与政府交流互动的桥梁，是宣传洛龙的主要窗口，对于促进政府信息公开、推进依法行政、接受公众监督、改进行政管理、全面履行政府职能和建设阳光政府具有重要意义。</p>\",\n		\"contentDisplay\":\"0\",\n		\"contentHit\":0,\n		\"contentImg\":\"[{\\\"path\\\":\\\"/upload/1//article/1531105970322.jpg\\\",\\\"url\\\":\\\"/ms-mcms/upload/1//article/1531105970322.jpg\\\",\\\"uid\\\":1578390819577,\\\"status\\\":\\\"success\\\"}]\",\n		\"contentKeyword\":\"\",\n		\"contentSort\":0,\n		\"contentSource\":\"http://www.luolong.gov.cn/ \",\n		\"contentTitle\":\"洛阳洛龙\",\n		\"contentType\":\"f\",\n		\"contentUrl\":\"/149\\\\222.html\",\n		\"createBy\":0,\n		\"del\":0,\n		\"id\":\"222\",\n		\"order\":\"\",\n		\"remarks\":\"\",\n		\"sqlWhereList\":[],\n		\"updateBy\":0,\n		\"updateDate\":\"2020-01-07 17:53:54\"\n	}\n}', '{\n	\"createDate\":[\"\"],\n	\"id\":[\"222\"],\n	\"remarks\":[\"\"],\n	\"updateDate\":[\"2020-01-07 17:53:47\"],\n	\"order\":[\"\"],\n	\"contentTitle\":[\"洛阳洛龙\"],\n	\"contentCategoryId\":[\"149\"],\n	\"contentType\":[\"f\"],\n	\"contentDisplay\":[\"0\"],\n	\"contentAuthor\":[\"\"],\n	\"contentSource\":[\"http://www.luolong.gov.cn/ \"],\n	\"contentDatetime\":[\"2018-07-09 11:12:00\"],\n	\"contentSort\":[\"0\"],\n	\"contentImg\":[\"[{\\\"path\\\":\\\"/upload/1//article/1531105970322.jpg\\\",\\\"url\\\":\\\"/ms-mcms/upload/1//article/1531105970322.jpg\\\",\\\"uid\\\":1578390819577,\\\"status\\\":\\\"success\\\"}]\"],\n	\"contentDescription\":[\"\"],\n	\"contentKeyword\":[\"\"],\n	\"contentDetails\":[\"<p>洛龙区人民政府门户网作为洛阳市洛龙区电子政务（网上行政）建设的重要组成部分，是政府信息公开的法定载体，是政府面向社会服务的平台，是公众与政府交流互动的桥梁，是宣传洛龙的主要窗口，对于促进政府信息公开、推进依法行政、接受公众监督、改进行政管理、全面履行政府职能和建设阳光政府具有重要意义。</p>\"],\n	\"contentUrl\":[\"/149\\\\222.html\"],\n	\"appId\":[\"1\"],\n	\"contentHit\":[\"0\"]\n}', '内网IP', '/ms-mcms/ms/cms/content/update.do', 'msopen', 'manage', 'POST', 'net.mingsoft.cms.action.ContentAction.update()', 'update', '127.0.0.1', '更新文章', 0, NULL, NULL, '2020-01-07 17:53:55', NULL);
+INSERT INTO `system_log` VALUES (1317, '\r\n### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'page_type\' in \'field list\'\r\n### The error may involve net.mingsoft.mdiy.dao.IPageDao.saveEntity-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into mdiy_page    ( page_app_id,   page_path,   page_title,   page_key,   page_type,   CREATE_DATE )     values ( ?,   ?,   ?,   ?,   ?,   ? )\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'page_type\' in \'field list\'\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'page_type\' in \'field list\'', 'error', 'null', '{\n	\"pageTitle\":[\"xxx\"],\n	\"pagePath\":[\"footer.htm\"],\n	\"pageKey\":[\"xxx\"],\n	\"pageType\":[\"cms\"]\n}', '内网IP', '/ms-mcms/ms/mdiy/page/save.do', 'msopen', 'manage', 'POST', 'net.mingsoft.mdiy.action.PageAction.save()', 'insert', '127.0.0.1', '保存自定义页面接口', 0, NULL, NULL, '2020-01-07 17:55:01', NULL);
+INSERT INTO `system_log` VALUES (1318, NULL, 'success', '{\n	\"result\":true,\n	\"code\":200,\n	\"data\":{\n		\"createBy\":0,\n		\"createDate\":\"2020-01-07 18:00:48\",\n		\"del\":0,\n		\"pageAppId\":1,\n		\"pageId\":5,\n		\"pageKey\":\"index\",\n		\"pagePath\":\"index.htm\",\n		\"pageTitle\":\"index\",\n		\"pageType\":\"cms\",\n		\"sqlWhereList\":[],\n		\"updateBy\":0\n	}\n}', '{\n	\"pageTitle\":[\"index\"],\n	\"pagePath\":[\"index.htm\"],\n	\"pageKey\":[\"index\"],\n	\"pageType\":[\"cms\"]\n}', '内网IP', '/ms-mcms/ms/mdiy/page/save.do', 'msopen', 'manage', 'POST', 'net.mingsoft.mdiy.action.PageAction.save()', 'insert', '127.0.0.1', '保存自定义页面接口', 0, NULL, NULL, '2020-01-07 18:00:49', NULL);
+INSERT INTO `system_log` VALUES (1319, '\r\n### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'UPDATE_DATE\' in \'field list\'\r\n### The error may involve net.mingsoft.mdiy.dao.IPageDao.updateEntity-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update mdiy_page    SET page_app_id=?,       page_path=?,       page_title=?,       page_key=?,    page_type=?,    CREATE_DATE=?,            UPDATE_DATE=?    where page_id = ?\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'UPDATE_DATE\' in \'field list\'\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'UPDATE_DATE\' in \'field list\'', 'error', 'null', '{\n	\"createDate\":[\"2020-01-07 18:00:49\"],\n	\"id\":[\"\"],\n	\"remarks\":[\"\"],\n	\"updateDate\":[\"\"],\n	\"order\":[\"\"],\n	\"pageId\":[\"5\"],\n	\"pageModelId\":[\"\"],\n	\"pageAppId\":[\"1\"],\n	\"pagePath\":[\"index.htm\"],\n	\"pageTitle\":[\"index\"],\n	\"pageKey\":[\"mcms\"],\n	\"pageType\":[\"cms\"]\n}', '内网IP', '/ms-mcms/ms/mdiy/page/update.do', 'msopen', 'manage', 'POST', 'net.mingsoft.mdiy.action.PageAction.update()', 'update', '127.0.0.1', '更新自定义页面接口', 0, NULL, NULL, '2020-01-07 18:01:03', NULL);
+INSERT INTO `system_log` VALUES (1320, '\r\n### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'del\' in \'where clause\'\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: delete from mdiy_page    WHERE page_id  in (?)    and del != 3\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'del\' in \'where clause\'\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'del\' in \'where clause\'', 'error', 'null', '[\n	{\n		\"createBy\":0,\n		\"createDate\":\"2020-01-07 18:00:49\",\n		\"del\":0,\n		\"pageAppId\":1,\n		\"pageId\":5,\n		\"pageKey\":\"index\",\n		\"pagePath\":\"index.htm\",\n		\"pageTitle\":\"index\",\n		\"pageType\":\"cms\",\n		\"sqlWhereList\":[],\n		\"updateBy\":0\n	}\n]', '内网IP', '/ms-mcms/ms/mdiy/page/delete.do', 'msopen', 'manage', 'POST', 'net.mingsoft.mdiy.action.PageAction.delete()', 'delete', '127.0.0.1', '批量删除自定义页面接口', 0, NULL, NULL, '2020-01-07 18:02:23', NULL);
 
 SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------
-- Records of role_model
-- ----------------------------
INSERT INTO `role_model` VALUES (NULL, NULL);
INSERT INTO `role_model` VALUES (23, 48);
INSERT INTO `role_model` VALUES (84, 48);
INSERT INTO `role_model` VALUES (86, 48);

 Target Server Version : 50725
 File Encoding         : 65001

 Date: 07/01/2020 18:38:10
*/

SET NAMES utf8mb4;
