毕设&课设&项目&实训-基于微信小程序的校园互助系统.zip

/* Navicat MySQL Data Transfer Source Server : 本地MySql Source Server Version : 50713 Source Host : localhost:3306 Source Database : mutualhelpsystem Target Server Type : MYSQL Target Server Version : 50713 File Encoding : 65001 Date: 2019-06-02 19:39:13 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tb_admin -- ---------------------------- DROP TABLE IF EXISTS `tb_admin`; CREATE TABLE `tb_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `phone` char(11) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `created` datetime DEFAULT NULL, `nickname` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tb_admin -- ---------------------------- INSERT INTO `tb_admin` VALUES ('1', '13420109611', 'aa@163.com', '123456', '2019-05-16 19:36:59', 'aa'); -- ---------------------------- -- Table structure for tb_express -- ---------------------------- DROP TABLE IF EXISTS `tb_express`; CREATE TABLE `tb_express` ( `express_id` int(11) NOT NULL AUTO_INCREMENT, `publish_id` char(11) DEFAULT NULL, `accept_id` char(11) DEFAULT NULL, `order_type` int(11) DEFAULT NULL, `order_status` int(11) DEFAULT NULL, `express_detail_id` char(30) DEFAULT NULL, PRIMARY KEY (`express_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tb_express -- ---------------------------- INSERT INTO `tb_express` VALUES ('9', '13420109679', '13420109677', '101', '1002', '1558080239096'); INSERT INTO `tb_express` VALUES ('10', '13420109679', null, '101', '1004', '1558080349277'); INSERT INTO `tb_express` VALUES ('11', '13420109679', '13713397457', '101', '1002', '1558080683881'); INSERT INTO `tb_express` VALUES ('12', '13420109677', null, '101', '1001', '1558081439202'); INSERT INTO `tb_express` VALUES ('13', '13420109677', null, '101', '1001', '1558082403288'); INSERT INTO `tb_express` VALUES ('14', '13420109670', null, '101', '1001', '1558082772509'); INSERT INTO `tb_express` VALUES ('15', '13420109670', null, '101', '1001', '1558082838617'); INSERT INTO `tb_express` VALUES ('16', '13713397456', null, '101', '1001', '1558315469117'); INSERT INTO `tb_express` VALUES ('17', '13713397456', '13713397457', '101', '1003', '1558315522156'); INSERT INTO `tb_express` VALUES ('18', '13713397456', null, '101', '1001', '1558315576689'); INSERT INTO `tb_express` VALUES ('19', '13713397457', null, '101', '1001', '1558316049187'); INSERT INTO `tb_express` VALUES ('20', '13713397457', null, '101', '1001', '1558316093167'); INSERT INTO `tb_express` VALUES ('21', '13420109679', null, '101', '1001', '1558316806177'); INSERT INTO `tb_express` VALUES ('22', '13420109679', null, '101', '1001', '1558316858760'); INSERT INTO `tb_express` VALUES ('23', '13420109678', null, '101', '1001', '1558317722929'); INSERT INTO `tb_express` VALUES ('24', '13420109678', null, '101', '1001', '1558317774439'); INSERT INTO `tb_express` VALUES ('25', '13420109679', '13411112222', '101', '1002', '1558341642430'); INSERT INTO `tb_express` VALUES ('26', '13420109679', '13420109678', '101', '1003', '1559292968364'); -- ---------------------------- -- Table structure for tb_expressdetail -- ---------------------------- DROP TABLE IF EXISTS `tb_expressdetail`; CREATE TABLE `tb_expressdetail` ( `express_detail_id` char(30) NOT NULL, `express_publishtime` datetime DEFAULT NULL, `express_campany` varchar(255) DEFAULT NULL, `express_message` varchar(255) DEFAULT NULL, `express_phone` char(11) DEFAULT NULL, `express_site` varchar(255) DEFAULT NULL, `express_reward` decimal(10,0) DEFAULT NULL, `express_contact` char(11) DEFAULT NULL, `express_note` varchar(255) DEFAULT NULL, `express_finishtime` datetime DEFAULT NULL, PRIMARY KEY (`express_detail_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tb_expressdetail -- ---------------------------- INSERT INTO `tb_expressdetail` VALUES ('1558080239096', '2019-05-17 16:03:59', '京东快递', '您好，您12月31日的快递已到达海大游泳池旁物流中心，请20点前到（小件货架）取件，电联：15361942449', '13420109679', '海湛B311', '3', '13420109679', '1234', null); INSERT INTO `tb_expressdetail` VALUES ('1558080349277', '2019-05-17 16:05:49', '圆通快递', '【妈妈驿站】取货码 0536032圆通快递广东海洋大学门口小食街超市隔壁暑假上班时间：10:00-18:30，18022632609。上门收件：18820438397（67）。', '13420109679', '海湛B210', '2', '13420109679', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558080683881', '2019-05-17 16:11:24', '顺丰速运', '【顺丰速运】亲，您有快件放置于面对校门左侧直走80米顺丰现已爆仓，货号75，请20:00前持有效证件取件，收派员18022662206。\n', '13420109679', '海湛A201', '2', '13420109679', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558081439202', '2019-05-17 16:23:59', '顺丰速运', '【顺丰速运】亲，您有快件放置于学校门口左侧益丰超市直走20米顺丰，货号513，请17:00前持有效证件取件，收派员18022662206。\n', '13420109677', '海湛B302', '2', '13420109677', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558082403288', '2019-05-17 16:40:03', '韵达快递', '【好递讯美】韵达快递海大对面飞宏商城楼，8日A架袋子件按号码尾数找请今天22点前取走，请尽快取件逾期不取退回，咨询18666712798\n', '13420109677', '海湛B101', '2', '13420109677', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558082772509', '2019-05-17 16:46:13', '韵达快递', '【好递讯美】韵达快递海大对面飞宏商城楼，8日A架袋子件按号码尾数找请今天22点前取走，请尽快取件逾期不取退回，咨询18666712798\n', '13420109670', '海湛A120', '2', '13420109670', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558082838617', '2019-05-17 16:47:19', '圆通快递', '【妈妈驿站】取货码 0536032圆通快递广东海洋大学门口小食街超市隔壁暑假上班时间：10:00-18:30，18022632609。上门收件：18820438397（67）.', '13420109670', '海湛A509', '1', '13420109670', '尽快', null); INSERT INTO `tb_expressdetail` VALUES ('1558315469117', '2019-05-20 09:24:29', '韵达快递', '【好递讯美】韵达快递海大对面飞宏商城楼，8日A架袋子件按号码尾数找请今天22点前取走，请尽快取件逾期不取退回，咨询18666712798\n', '13713397456', '海湛A101', '2', '13713397456', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558315522156', '2019-05-20 09:25:22', '圆通快递', '【妈妈驿站】取货码 0536032圆通快递广东海洋大学门口小食街超市隔壁暑假上班时间：10:00-18:30，18022632609。上门收件：18820438397（67）.\n', '13713397456', '海湛A210', '1', '13713397456', '', '2019-05-20 09:42:01'); INSERT INTO `tb_expressdetail` VALUES ('1558315576689', '2019-05-20 09:26:17', '顺丰速运', '【顺丰速运】亲，您有快件放置于面对校门左侧直走80米顺丰现已爆仓，货号75，请20:00前持有效证件取件，收派员18022662206。\n', '13713397456', '海蓝A101', '3', '13713397456', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558316049187', '2019-05-20 09:34:09', '申通快递', '【申通快递】2月27日(B1货架)您的快递已到达海大游泳池旁物流中心，请在当天21：00前尽快领取！系统显示签收不影响取件哈！\n', '13713397456', '海蓝B102', '2', '13713397456', '', null); INSERT INTO `tb_expressdetail` VALUES ('1558316093167', '2019-05-20 09:34:53', '京东快递', '【京东快递】您好，您12月31日的快递已到达海大游泳池旁物流中心，请20点前到（小件货架）取件，电联：15361942449\n', '13713397457', '海湛A310', '2', '137