下载x1.2用navicat 导入数据库报错
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT N' at line 7
[Err] INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_info', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_material', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_menu', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_menu_group', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_reply_click', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_reply_content', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_reply_keyword', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_send', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_send_article', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_wechat_token', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_weibo_app_config', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_weibo_article_push', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_weibo_fans', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_weibo_info', 50);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow_action_record', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow_line', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow_node', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow_node_action', 20);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow_node_flow', 10);
INSERT INTO `hibernate_sequences` VALUES ('jc_workflow_task', 10);
INSERT INTO `hibernate_sequences` VALUES ('js_user_collection', 271);
INSERT INTO `hibernate_sequences` VALUES ('test_webmagic', 101);
-- ----------------------------
-- Table structure for jc_audit_channel_set
-- ----------------------------
DROP TABLE IF EXISTS `jc_audit_channel_set`;
CREATE TABLE `jc_audit_channel_set` (
`id` int(11) NOT NULL COMMENT '唯一标识符',
`channel_id` int(11) NOT NULL COMMENT '栏目ID',
`strategy_id` int(11) NOT NULL COMMENT '审核策略id',
`is_compel` tinyint(1) NOT NULL COMMENT '是否强制通过，true是，false否',
`status` tinyint(1) NOT NULL COMMENT '状态,true开启false关闭',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_user` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '创建者',
`update_user` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '修改者',
`deleted_flag` tinyint(1) NOT NULL COMMENT '删除标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '审核栏目设置' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for jc_audit_model_item
-- ----------------------------
DROP TABLE IF EXISTS `jc_audit_model_item`;
CREATE TABLE `jc_audit_model_item` (
`id` int(11) NOT NULL COMMENT '全局唯一标识符',
`audit_model_id` int(11) NOT NULL COMMENT '审核模型主键ID',
`model_item_field` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '模型字段ID',
`model_item_id` int(11) NOT NULL COMMENT '模型字段ID',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_user` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '创建者',
`update_user` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '修改者',
`deleted_flag` tinyint(1) NOT NULL COMMENT '删除标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '审核模型设置字段表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for jc_audit_model_set
-- ----------------------------
DROP TABLE IF EXISTS `jc_audit_model_set`;
CREATE TABLE `jc_audit_model_set` (
`id` int(11) NOT NULL COMMENT '唯一标识符',
`site_id` int(11) NOT NULL COMMENT '站点ID',
`model_id` int(11) NOT NULL COMMENT '模型ID',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_user` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '
[Err] 1146 - Table 'jeecms.jc_channel_content_tpl' doesn't exist
[Err] INSERT INTO `jc_channel_content_tpl` VALUES (2448, 1906, 913, 'content/demo.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2449, 1906, 912, 'content/news.html', 'content/demo.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2483, 1749, 963, 'content/videodetails.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2484, 1749, 962, 'content/downloadDetails.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2485, 1749, 961, 'content/libraryDetails.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2486, 1749, 913, 'content/pageDetails.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2487, 1749, 912, 'content/news.html', 'content/demo.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2648, 2063, 962, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2649, 2063, 963, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2650, 2063, 961, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2651, 2063, 913, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2652, 2063, 912, 'content/news.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2695, 1907, 963, 'content/demo.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2696, 1907, 962, 'content/downloadDetails.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2698, 1907, 961, 'content/demo.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2699, 1907, 913, 'content/demo.html', 'content/commentList.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2700, 1907, 912, 'content/news.html', 'content/demo.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2793, 1750, 912, 'content/news.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2872, 1908, 962, 'content/downloadList.html', 'content/downloaddetails.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2873, 1908, 963, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2874, 1908, 961, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2875, 1908, 913, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2876, 1908, 912, 'content/demo.html', 'content/newsdetails.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2882, 1751, 912, 'content/news.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2893, 2122, 962, 'content/downloadDetails.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2894, 2122, 963, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2895, 2122, 961, 'content/libraryDetails.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2896, 2122, 913, 'content/demo.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (2897, 2122, 912, 'content/newsAlone.html', 'content/newsdetails.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (4021, 1747, 1071, 'content/newsAlone.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (4022, 1747, 1061, 'content/newsAlone.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (4023, 1747, 962, 'content/commentList.html', 'content/downloaddetails.html', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (4024, 1747, 963, 'content/commentList.html', '', 10, 0);
INSERT INTO `jc_channel_content_tpl` VALUES (4025, 1747, 961, 'content/newsDetails.html', |
|
