基于SSM框架的宠物领养宠物疾病救助网站源码+sql数据库+项目说明(高分毕设).zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50529 Source Host : localhost:3306 Source Database : pethouse Target Server Type : MYSQL Target Server Version : 50529 File Encoding : 65001 Date: 2017-04-07 17:37:46 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for t_adopt -- ---------------------------- DROP TABLE IF EXISTS `t_adopt`; CREATE TABLE `t_adopt` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pet_id` varchar(128) NOT NULL COMMENT '需领养宠物', `user_id` int(11) NOT NULL COMMENT '领养账号', `contacts` varchar(64) NOT NULL COMMENT '联系人', `phone` varchar(64) NOT NULL COMMENT '联系电话', `id_card` varchar(32) DEFAULT NULL, `address` varchar(256) NOT NULL COMMENT '收货地址', `work` varchar(128) DEFAULT NULL, `statue` int(255) DEFAULT NULL COMMENT '1.待处理 2 申请通过 3 申请未通过', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '购买时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='领养记录表'; -- ---------------------------- -- Records of t_adopt -- ---------------------------- INSERT INTO `t_adopt` VALUES ('1', '1', '2', '孙先生', '13512545124', '321548454845414', '中国', '工程师', '2', '2017-03-24 10:56:24'); INSERT INTO `t_adopt` VALUES ('2', '3', '2', '何先生', '13812548454', '315412451545215412', '中国', '工程师', '2', '2017-03-28 16:21:22'); INSERT INTO `t_adopt` VALUES ('3', '5', '2', '李先生', '13912545654', '321541254125125621', '中国', '工程师', '2', '2017-03-28 16:24:05'); -- ---------------------------- -- Table structure for t_back -- ---------------------------- DROP TABLE IF EXISTS `t_back`; CREATE TABLE `t_back` ( `id` int(11) NOT NULL AUTO_INCREMENT, `maid_id` int(11) NOT NULL COMMENT '救助账号', `staff_id` varchar(64) NOT NULL COMMENT '医护人员', `statue` int(255) DEFAULT NULL COMMENT '1.待处理 2 申请通过 3 申请未通过', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '购买时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='领养记录表'; -- ---------------------------- -- Records of t_back -- ---------------------------- INSERT INTO `t_back` VALUES ('5', '2', '4', '1', '2017-03-27 18:29:35'); INSERT INTO `t_back` VALUES ('6', '2', '4', '1', '2017-03-27 18:31:15'); INSERT INTO `t_back` VALUES ('7', '2', '4', '2', '2017-03-27 18:31:38'); -- ---------------------------- -- Table structure for t_log -- ---------------------------- DROP TABLE IF EXISTS `t_log`; CREATE TABLE `t_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志id', `user_id` int(11) DEFAULT NULL COMMENT '用户id', `user_account` varchar(256) DEFAULT NULL COMMENT '用户帐号', `user_name` varchar(256) DEFAULT NULL COMMENT '用户姓名', `client_ip` varchar(16) DEFAULT NULL COMMENT '客户端ip', `type` int(11) NOT NULL DEFAULT '1' COMMENT '1,操作日志；2其他日志', `idx` int(11) DEFAULT NULL COMMENT '1,新增；2,修改；3,删除；4,查看；5,发布；6,导入；7,导出', `verb` varchar(16) DEFAULT NULL COMMENT '日志动词', `noun` varchar(64) DEFAULT NULL COMMENT '描述信息', `log_time` datetime DEFAULT NULL COMMENT '日志时间：Y-m-d H:i:S', `db_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间：Y-m-d H:i:S', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6108 DEFAULT CHARSET=utf8 COMMENT='日志'; -- ---------------------------- -- Records of t_log -- ---------------------------- INSERT INTO `t_log` VALUES ('6060', '1', 'admin', '2124512@126.com', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-23 20:13:50', '2017-03-23 20:13:52'); INSERT INTO `t_log` VALUES ('6061', '1', 'admin', '2124512@126.com', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-23 20:14:46', '2017-03-23 20:14:49'); INSERT INTO `t_log` VALUES ('6062', '1', 'admin', '2124512@126.com', '127.0.0.1', '1', '1', '新增', '新增用户', '2017-03-23 20:14:46', '2017-03-23 20:14:52'); INSERT INTO `t_log` VALUES ('6063', '1', 'admin', '2124512@126.com', '127.0.0.1', '1', '1', '新增', '新增宠物', '2017-03-23 20:31:57', '2017-03-23 20:31:58'); INSERT INTO `t_log` VALUES ('6064', '1', 'admin', '2124512@126.com', '127.0.0.1', '1', '2', '修改', '修改宠物信息', '2017-03-23 20:36:37', '2017-03-23 20:36:37'); INSERT INTO `t_log` VALUES ('6065', '1', 'admin', '2124512@126.com', '127.0.0.1', '1', '2', '修改', '医治宠物信息', '2017-03-24 15:43:34', '2017-03-24 15:43:36'); INSERT INTO `t_log` VALUES ('6066', '4', 'staff1', 'staff1@126.com', '127.0.0.1', '1', '2', '修改', '医治宠物信息', '2017-03-27 16:52:36', '2017-03-27 16:52:38'); INSERT INTO `t_log` VALUES ('6067', '4', 'staff1', 'staff1@126.com', '127.0.0.1', '1', '2', '修改', '医治宠物信息', '2017-03-27 18:21:54', '2017-03-27 18:21:56'); INSERT INTO `t_log` VALUES ('6068', '4', 'staff1', 'staff1@126.com', '127.0.0.1', '1', '1', '新增', '新增宠物领回申请', '2017-03-27 18:29:35', '2017-03-27 18:29:37'); INSERT INTO `t_log` VALUES ('6069', '4', 'staff1', 'staff1@126.com', '127.0.0.1', '1', '1', '新增', '新增宠物领回申请', '2017-03-27 18:31:15', '2017-03-27 18:31:16'); INSERT INTO `t_log` VALUES ('6070', '4', 'staff1', 'staff1@126.com', '127.0.0.1', '1', '1', '新增', '新增宠物领回申请', '2017-03-27 18:31:38', '2017-03-27 18:31:40'); INSERT INTO `t_log` VALUES ('6071', '0', '', '', '127.0.0.1', '1', '1', '新增', '新增宠物', '2017-03-28 16:21:22', '2017-03-28 16:21:24'); INSERT INTO `t_log` VALUES ('6072', '0', '', '', '127.0.0.1', '1', '1', '新增', '新增宠物', '2017-03-28 16:24:05', '2017-03-28 16:24:06'); INSERT INTO `t_log` VALUES ('6073', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:17', '2017-03-28 16:44:17'); INSERT INTO `t_log` VALUES ('6074', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:19', '2017-03-28 16:44:20'); INSERT INTO `t_log` VALUES ('6075', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:23', '2017-03-28 16:44:23'); INSERT INTO `t_log` VALUES ('6076', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:23', '2017-03-28 16:44:26'); INSERT INTO `t_log` VALUES ('6077', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:24', '2017-03-28 16:44:30'); INSERT INTO `t_log` VALUES ('6078', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:24', '2017-03-28 16:44:33'); INSERT INTO `t_log` VALUES ('6079', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:24', '2017-03-28 16:44:36'); INSERT INTO `t_log` VALUES ('6080', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:25', '2017-03-28 16:44:39'); INSERT INTO `t_log` VALUES ('6081', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:26', '2017-03-28 16:44:42'); INSERT INTO `t_log` VALUES ('6082', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:30', '2017-03-28 16:44:45'); INSERT INTO `t_log` VALUES ('6083', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:35', '2017-03-28 16:44:48'); INSERT INTO `t_log` VALUES ('6084', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:35', '2017-03-28 16:44:51'); INSERT INTO `t_log` VALUES ('6085', '0', '', '', '127.0.0.1', '1', '2', '修改', '校验账号是否唯一', '2017-03-28 16:44:53', '2017-03-28 16:44:54');