 -- ----------------------------
 -- Records of manager
 -- ----------------------------
-INSERT INTO `manager` VALUES (52, 'test', 'test', 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, '2017-05-25 14:55:19', 0);
-INSERT INTO `manager` VALUES (53, 'kfm', 'kfm', '14dda7e9cc096397e851a3d71465511e', NULL, 0, '2017-05-25 14:59:48', 0);
 INSERT INTO `manager` VALUES (57, 'msopen', 'msopen', '9d8622060de5f24937b60585c3f4d66b', 48, 0, NULL, 0);
-INSERT INTO `manager` VALUES (58, 'adminms', NULL, '9d8622060de5f24937b60585c3f4d66b', 1, 0, '2019-11-20 09:01:33', 0);
-INSERT INTO `manager` VALUES (59, 'msopen1', '123456', 'e10adc3949ba59abbe56e057f20f883e', NULL, 0, NULL, 0);
-INSERT INTO `manager` VALUES (60, 'adnub', 'adnub', 'd41d8cd98f00b204e9800998ecf8427e', NULL, 0, NULL, 0);
 
 -- ----------------------------
 -- Table structure for mdiy_dict

  `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;

SET FOREIGN_KEY_CHECKS = 1;

  `page_model_id` int(11) NULL DEFAULT NULL COMMENT '模块id',
  `page_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义页面绑定模板的路径',
  `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义页面标题',
  `page_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典分类字段',
  `page_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义页面访问路径',
  `create_date` datetime(0) NULL DEFAULT NULL,
  `create_by` int(11) NULL DEFAULT NULL,
  `update_by` int(11) NULL DEFAULT NULL,
  `update_date` datetime(0) NULL DEFAULT NULL,
  `del` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`page_id`) USING BTREE,
  INDEX `index_page_key`(`page_key`) USING BTREE,
  INDEX `index_page_app_id`(`page_app_id`) USING BTREE,
  INDEX `index_page_model_id`(`page_model_id`) USING BTREE,
  CONSTRAINT `mdiy_page_ibfk_1` FOREIGN KEY (`page_app_id`) REFERENCES `app` (`app_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '自定义页面表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of mdiy_page
-- ----------------------------
INSERT INTO `mdiy_page` VALUES (1, 1, 0, 'people/register.htm', '注册', NULL, 'register', NULL, NULL, NULL, NULL, 0);
INSERT INTO `mdiy_page` VALUES (2, 1, 0, 'people/login.htm', '登入', NULL, 'login', NULL, NULL, NULL, NULL, 0);
INSERT INTO `mdiy_page` VALUES (3, 1, 0, 'people/center.htm', '个人中心', NULL, 'people/center', NULL, NULL, NULL, NULL, 0);
INSERT INTO `mdiy_page` VALUES (4, 1, 0, 'people/passworld-change.htm', '修改密码', NULL, 'people/password-change', NULL, NULL, NULL, NULL, 0);

-- ----------------------------
-- Table structure for mdiy_post_feedback
-- ----------------------------
DROP TABLE IF EXISTS `mdiy_post_feedback`;
CREATE TABLE `mdiy_post_feedback`  (
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
  `words` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '留言',
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '意见反馈' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mdiy_tag
