【跑腿小程序】校园跑腿微信小程序源码，可做毕业设计

# Host: 129.28.89.58 (Version 5.5.57-log) # Date: 2019-03-27 12:29:46 # Generator: MySQL-Front 6.1 (Build 1.26) # # Structure for table "address_cate" # DROP TABLE IF EXISTS `address_cate`; CREATE TABLE `address_cate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) DEFAULT NULL, `sort` int(11) DEFAULT NULL, `is_delete` int(1) NOT NULL DEFAULT '0', `is_show` int(1) NOT NULL DEFAULT '1', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `a_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT; # # Data for table "address_cate" # # # Structure for table "address_info" # DROP TABLE IF EXISTS `address_info`; CREATE TABLE `address_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) DEFAULT NULL, `cate_id` int(11) DEFAULT NULL, `a_id` int(11) DEFAULT NULL, `sort` int(11) DEFAULT NULL, `sub_name` varchar(100) DEFAULT NULL, `is_delete` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT; # # Data for table "address_info" # # # Structure for table "address_user" # DROP TABLE IF EXISTS `address_user`; CREATE TABLE `address_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `address` varchar(100) DEFAULT NULL, `detail` varchar(100) DEFAULT NULL, `wx_id` int(11) DEFAULT NULL, `is_delete` int(1) NOT NULL DEFAULT '0', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT; # # Data for table "address_user" # # # Structure for table "area" # DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `pk_id` int(11) NOT NULL AUTO_INCREMENT, `atype` int(1) DEFAULT NULL COMMENT '1城市 2校园', `name` varchar(100) DEFAULT NULL COMMENT '地区名', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_delete` int(1) NOT NULL DEFAULT '0', `sort` int(11) DEFAULT NULL, PRIMARY KEY (`pk_id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='地区'; # # Data for table "area" # # # Structure for table "auth_cate" # DROP TABLE IF EXISTS `auth_cate`; CREATE TABLE `auth_cate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cate_name` varchar(30) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_delete` int(1) NOT NULL DEFAULT '0', `is_show` int(1) NOT NULL DEFAULT '1', `remarks` varchar(50) NOT NULL DEFAULT '', `sort` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='权限分类'; # # Data for table "auth_cate" # INSERT INTO `auth_cate` VALUES (1,'权限管理','2019-01-29 10:09:04',0,1,'只能超级管理员用',1),(2,'权限类目管理','2019-01-29 11:45:14',0,1,'1',2),(3,'角色管理','2019-01-29 14:44:14',0,1,'1',3),(4,'日志管理','2019-01-29 14:44:26',0,1,'1',4),(5,'用户管理','2019-01-29 14:45:28',0,1,'1',5),(6,'微信用户管理','2019-01-29 14:45:44',0,1,'1',6),(7,'数据分析管理','2019-01-29 14:46:51',0,1,'1',7),(8,'代理商管理','2019-01-29 14:47:59',0,1,'1',8),(9,'代理地区管理','2019-01-29 14:48:06',0,1,'1',9),(10,'订单管理','2019-01-29 14:48:20',0,1,'1',10),(11,'地址管理','2019-01-29 14:49:14',0,1,'1',11),(12,'微信地址管理','2019-01-30 00:07:30',0,1,'1',12),(13,'文件管理','2019-01-30 00:16:38',0,1,'1',13),(14,'账户管理','2019-02-14 10:52:50',0,1,'1',14),(15,'广告营销管理','2019-02-16 16:25:38',0,1,'1',15),(16,'文章管理','2019-02-17 17:53:11',0,1,'1',16); # # Structure for table "auths" # DROP TABLE IF EXISTS `auths`; CREATE TABLE `auths` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cate_id` int(11) NOT NULL DEFAULT '0', `auth_name` varchar(30) NOT NULL DEFAULT '', `auth_url` varchar(100) NOT NULL DEFAULT '' COMMENT '路径', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_delete` int(1) NOT NULL DEFAULT '0', `remarks` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COMMENT='权限表'; # # Data for table "auths" # INSERT INTO `auths` VALUES (1,1,'新增权限','/api/auth/add','2019-01-29 13:28:15',0,'超级管理员专属'),(2,1,'修改权限','/api/auth/update','2019-01-29 13:35:59',0,'超级管理员专属'),(3,1,'删除权限','/api/auth/del','2019-01-29 14:52:59',0,'超管专属'),(4,1,'查询权限','/api/auth/get','2019-01-29 14:53:26',0,'1'),(5,2,'新增权限类目','/api/auth/cate/add','2019-01-29 14:53:58',0,'超管专属'),(6,2,'修改权限类目','/api/auth/cate/update','2019-01-29 14:54:08',0,'超管专属'),(7,2,'删除权限类目','/api/auth/cate/del','2019-01-29 14:54:45',0,'超管专属'),(8,2,'查询权限类目','/api/auth/cate/get','2019-01-29 14:54:54',0,'超管专属'),(9,2,'修改权限类目显示','/api/auth/cate/update/onShow','2019-01-29 14:55:40',0,'超管专属'),(10,2,'修改权限类目关闭','/api/auth/cate/update/unShow','2019-01-29 14:55:49',0,'超管专属'),(11,3,'新增角色','/api/role/add','2019-01-29 14:57:29',0,'1'),(12,3,'删除角色','/api/role/del','2019-01-29 14:58:02',0,'1'),(13,3,'修改角色','/api/role/update','2019-01-29 14:58:11',0,'1'),(14,3,'查询角色','/api/role/get','2019-01-29 14:58:21',0,'1'),(15,3,'禁用角色','/api/role/disable','2019-01-29 14:59:09',0,'1'),(16,3,'启用角色','/api/role/avaliable','2019-01-29 14:59:27',0,'1'),(17,4,'查询所有用户日志','/api/user/log/get','2019-01-29 15:00:13',0,'1'),(18,5,'新增用户','/api/user/register','2019-01-29 15:02:19',0,'1'),(19,5,'查询用户','/api/user/get','2019-01-29 15:02:36',0,'1'),(20,5,'根据代理地查询用户','/api/user/get/aid','2019-01-29 15:03:43',0,'1'),(21,5,'获取用户个人信息','/api/user/info','2019-01-29 15:04:43',0,'1'),(22,5,'修改用户个人信息','/api/user/update','2019-01-29 15:05:18',0,'1'),(23,5,'修改用户个人密码','/api/user/update/pwd','2019-01-29 15:05:38',0,'1'),(24,5,'禁用用户','/api/user/state/disable','2019-01-29 15:06:10',0,'1'),(25,5,'启用用户','/api/user/state/available','2019-01-29 15:06:23',0,'1'),(26,6,'查询微信用户','/api/wx/user/get','2019-01-29 15:08:52',0,'1'),(27,6,'微信登录','/api/wx/user/login','2019-01-29 15:09:25',0,'1'),(28,6,'微信用户审核信息修改','/api/wx/user/update','2019-01-29 15:09:57',0,'1'),(29,6,'微信用户修改','/api/wx/user/update/wx','2019-01-29 15:11:15',0,'1'),(30,6,'修改默认地址','/api/wx/user/update/def/address','2019-01-29 15:11:58',0,'1'),(31,6,'删除微信用户','/api/wx/user/del','2019-01-29 15:12:35',0,'1'),(32,6,'根据ID获取微信用户','/api/wx/user/get/id','2019-01-29 15:14:38',0,'1'),(33,6,'根据WXID获取审核信息','/api/wx/user/get/info/wxid','2019-01-29 15:22:54',0,'1'),(34,6,'获取审核信息列表','/api/wx/user/get/info','2019-01-29 15:23:46',0,'1'),(35,6,'提交新的审核信息','/api/wx/user/regis','2019-01-29 15:24:24',0,'1'),(36,6,'修改审核信息','/api/wx/user/update/info','2019-01-29 15:24:42',0,'1'),(37,6,'审核通过操作','/api/wx/user/info/pass','2019-01-29 15:25:25',0,'1'),(38,6,'审核驳回操作','/api/wx/user/info/unpass','2019-01-29 15:25:37',0,'1'),(39,7,'获取平台数据','/api/anlysis/get','2019-01-29 15:26:44',0,'1'),(40,7,'获取代理数据','/api/anlysis/get/agent','2019-01-29 15:27:04',0,'1'),(41,7,'获取微信用户数据','/api/anlysis/get/wx','2019-01-29 15:27:30',0,'1'),(42,8,'新增服务项','/api/server/add','2019-01-29 15:28:50',0,'1'),(43,8,'修改服务项','/api/server/update','2019-01-29 15:29:17',0,'1'),(44,8,'删除服务项','/api/server/del','2019-01-29 15:29:24',0,'1'),(45,8,'查询服务项','/api/server/get','2019-01-29 15:29:48',0,'1'),(46,8,'根据服务项ID查询','/api/server/get/id','2019-01-29 15:30:28',0,'1'),(47,8,'根据代理ID查询','/api/server/get/uid','2019-01-29 15:30:41',0,'1'),(48,3,'赋予权限','/api/auth/grant','2019-01-29 16:36:58',0,'1