
CREATE DATABASE `yingjiziyuan`;

USE `yingjiziyuan`;

-- ----------------------------
-- Table structure for apply
-- ----------------------------
DROP TABLE IF EXISTS `apply`;
CREATE TABLE `apply`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户',
  `fid` int(11) NULL DEFAULT NULL COMMENT '资源',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '说明',
  `status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目前状态',
  `pubtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of apply
-- ----------------------------
INSERT INTO `apply` VALUES (5, '申请11', 31, 2, '111', '拒绝', '2024-04-21 19:01:24');
INSERT INTO `apply` VALUES (6, '申请18', 32, 2, '申请的具体原因11', '通过', '2024-04-21 19:52:57');

-- ----------------------------
-- Table structure for bbs
-- ----------------------------
DROP TABLE IF EXISTS `bbs`;
CREATE TABLE `bbs`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `note2` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
  `htime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复时间',
  `status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目前状态',
  `pubtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '留言' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bbs
-- ----------------------------
INSERT INTO `bbs` VALUES (1, '标题11', 31, '留言的内容111', '121212', '2024-04-21 19:08:48', '已回复', '2024-04-21 19:01:08');
INSERT INTO `bbs` VALUES (2, '留言11232', 32, '留言的内容12121', '回复的内容111', '2024-04-21 19:55:50', '已回复', '2024-04-21 19:53:11');
INSERT INTO `bbs` VALUES (3, '1111', 15, '1111', NULL, NULL, '待回复', '2024-05-12 22:08:50');

-- ----------------------------
-- Table structure for capital
-- ----------------------------
DROP TABLE IF EXISTS `capital`;
CREATE TABLE `capital`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `price` int(11) NULL DEFAULT NULL COMMENT '价格',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '应急资金管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of capital
-- ----------------------------
INSERT INTO `capital` VALUES (1, '搜救', 'apple.jpg', 121, '测试');
INSERT INTO `capital` VALUES (2, '衣服', '20180112042214299889.jpg', 50000, '生活用品');
INSERT INTO `capital` VALUES (3, '1111', 'rmb.png', 123, '111');
INSERT INTO `capital` VALUES (4, '11111', 'hj.png', 190, '111');

-- ----------------------------
-- Table structure for donation_data
-- ----------------------------
DROP TABLE IF EXISTS `donation_data`;
CREATE TABLE `donation_data`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `btype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `fid` int(11) NULL DEFAULT NULL COMMENT '分类',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '说明',
  `pubtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '捐赠信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of donation_data
-- ----------------------------
INSERT INTO `donation_data` VALUES (1, '资金捐赠', '黄金', 2, 'hj.png', '说明111', '2024-04-21 19:11:44');
INSERT INTO `donation_data` VALUES (2, '捐赠物资2', '资源类型', 3, 'yfmb.png', '说明如下', '2024-04-21 19:11:44');
INSERT INTO `donation_data` VALUES (3, '捐赠物资测试', '物资类型', 3, 'yjs.png', '说明如下其11', '2024-04-21 19:11:44');
INSERT INTO `donation_data` VALUES (4, '资金捐赠测试', '资金', 2, 'rmb.png', '<p>\r\n	详细的介绍如下\r\n</p>\r\n<p>\r\n	<img src=\"/yingjiziyuan/attached/image/20240421/20240421195654_719.webp\" alt=\"\" /> \r\n</p>\r\n<p>\r\n	<br />\r\n</p>', '2024-04-21 19:55:25');

-- ----------------------------
-- Table structure for donation_type
-- ----------------------------
DROP TABLE IF EXISTS `donation_type`;
CREATE TABLE `donation_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '捐赠分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of donation_type
-- ----------------------------
INSERT INTO `donation_type` VALUES (1, '其它捐赠');
INSERT INTO `donation_type` VALUES (2, '资金捐赠');
INSERT INTO `donation_type` VALUES (3, '捐赠物资');

-- ----------------------------
-- Table structure for early_warning
-- ----------------------------
DROP TABLE IF EXISTS `early_warning`;
CREATE TABLE `early_warning`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `btype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类',
  `uid` int(11) NULL DEFAULT NULL COMMENT '用户',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目前状态',
  `pubtime` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '预警' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of early_warning
-- ----------------------------
INSERT INTO `early_warning` VALUES (1, '搜救队伍1', '搜救', 1, '主要的内容1', '正常', '2024-04-21 19:10:16');
INSERT INTO `early_warning` VALUES (2, '队伍1', '救援', 1, '具体的内容111', '正常', '2024-04-21 19:10:40');
INSERT INTO `early_warning` VALUES (3, '队伍2', '物资', 1, '<p>\r\n	具体的内容111\r\n</p>\r\n<p>\r\n	<img src=\"/yingjiziyuan/attached/image/20240421/20240421195720_428.webp\" width=\"800\" height=\"514\" alt=\"\" /> \r\n</p>\r\n<p>\r\n	<br />\r\n</p>', '正常', '2024-04-21 19:54:09');

-- ----------------------------
-- Table structure for emergency_resources
-- ----------------------------
DROP TABLE IF EXISTS `emergency_resources`;
CREATE TABLE `emergency_resources`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `btype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `fid` int(11) NULL DEFAULT NULL COMMENT '分类',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '说明',
  `pubtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '应急资源' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of emergency_resources
-- ----------------------------
INSERT INTO `emergency_resources` VALUES (1, '测绘资源', '日常', 2, '测绘.png', '说明111', '2024-04-21 19:11:44');
INSERT INTO `emergency_resources` VALUES (2, '山东大棚蔬菜', '重要资源', 4, 'guoshu.png', '说明如下', '2024-04-21 19:11:44');
INSERT INTO `emergency_resources` VALUES (3, '京东快递', '储备物资', 4, 'qc.jpg', '说明如下其11', '2024-04-21 19:11:44');
INSERT INTO `emergency_resources` VALUES (4, '华北电力公司', '重要', 2, 'airplane.jpg', '<p>\r\n	详细的介绍如下\r\n</p>\r\n<p>\r\n	<img src=\"/yingjiziyuan/attached/image/20240421/20240421195654_719.webp\" alt=\"\" /> \r\n</p>\r\n<p>\r\n	<br />\r\n</p>', '2024-04-21 19:55:25');
INSERT INTO `emergency_resources` VALUES (5, '阿里云', '资金', 4, '20180112042214299889.jpg', '资金资源', '2024-05-23 20:13:48');
INSERT INTO `emergency_resources` VALUES (6, '拼多多', '物品', 4, 'pdd.png', '提供 水，泡面，面包等物资', '2024-05-23 20:15:58');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `btype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `pubtime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '新闻' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (13, 'u=2094129979,1263236989&fm=253&fmt=auto&app=120&f=JPEG.webp', '新闻78', '<p>\r\n	新闻的内容\r\n</p>\r\n<p>\r\n	<img src=\"/ershoushangpin/attached/image/20210404/20210404012346_262.jpg\" alt=\"\" /> \r\n</p>', '新闻资讯', '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (15, 'u=1807024830,2927606381&fm=253&fmt=auto&app=138&f=JPEG.webp', '公告1', '公告的内容11', '新闻资讯', '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (16, 'u=1749118048,3368305237&fm=253&fmt=auto&app=138&f=JPEG.webp', '案例资讯', '具体的内容11', '新闻资讯', '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (17, 'apple.jpg', '农业救援案例', '具体的内容11', '新闻资讯', '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (19, '48.png', '雾天救援案例', '新闻的内容11', '新闻资讯', '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (20, '53.png', '洪水救援案例', '新闻的内容111', NULL, '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (21, '43.png', '雪天救援案例', '公告的内容11', NULL, '2024-04-21 19:11:44');
INSERT INTO `news` VALUES (22, '8.png', '应急救援案例', '<p>\r\n	案例的内容如下111\r\n</p>\r\n<p>\r\n	<img src=\"/yingjiziyuan/attached/image/20240421/20240421195756_129.webp\" alt=\"\" /> \r\n</p>', NULL, '2024-04-21 19:54:46');
INSERT INTO `news` VALUES (23, '防火.png', '应急案例防火', '1111111111111111', NULL, '2024-05-18 21:22:32');

-- ----------------------------
-- Table structure for place
-- ----------------------------
DROP TABLE IF EXISTS `place`;
CREATE TABLE `place`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场所管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of place
-- ----------------------------
INSERT INTO `place` VALUES (1, '疫情庇护场所', 'yjdc.png', '测试');
INSERT INTO `place` VALUES (2, '应急庇护场所', 'yjpl.png', '场所二');
INSERT INTO `place` VALUES (5, '自然灾害庇护场所', '1.png', '2222');
INSERT INTO `place` VALUES (6, '地震庇护场所', 'dz.png', '场所四');

-- ----------------------------
-- Table structure for resources_type
-- ----------------------------
DROP TABLE IF EXISTS `resources_type`;
CREATE TABLE `resources_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of resources_type
-- ----------------------------
INSERT INTO `resources_type` VALUES (2, '救援队伍');
INSERT INTO `resources_type` VALUES (3, '储备物资');
INSERT INTO `resources_type` VALUES (4, '其它资源');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `uname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `pwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `utype` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色',
  `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `age` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年龄',
  `email` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `pubtime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
  `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '介绍',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, '管理员', 'admin', '123456', 'avatar.png', '男', '街道7894', '管理员', '17556212314', '23', '815657032@qq.com', '2024-04-21 19:00:47', '12111');
INSERT INTO `users` VALUES (6, '用户02', 'yh02', '123456', '20170915112700292.jpg', '男', '武汉12号', '普通用户', '13568756122', '25', '11', '2024-04-21 19:00:47', '');
INSERT INTO `users` VALUES (15, '用户01', 'yh01', '123456', '20180716022205817.jpg', '女', '地址11', '普通用户', '13628796354', '20', '815657032@qq.com', '2024-04-21 19:00:47', '');
INSERT INTO `users` VALUES (27, '用户03', 'yh03', '123456', '20170915113845579.jpg', '女', '地址11', '普通用户', '15632145698', '20', '815657032@qq.com', '2024-04-21 19:00:47', '');
INSERT INTO `users` VALUES (31, '用户014', 'yh14', '123456', '20170915112700292.jpg', '男', '', '普通用户', '15632145698', '', '815657032@qq.com', '2024-04-21 19:00:47', '');
INSERT INTO `users` VALUES (32, '用户15', 'yh15', '123456', '20170915112433524.jpg', '女', '地址11', '普通用户', '15632145698', '', '815657032@qq.com', '2024-04-21 19:52:05', NULL);
INSERT INTO `users` VALUES (35, '用户0122', 'yh011', '123456', '20170910095708668.jpg', '男', '地址11', '普通用户', '15632145698', '20', '815657032@qq.com', '2024-04-21 20:02:29', '11');


