/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.5.53 : Database - shitang
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`shitang` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `shitang`;

/*Table structure for table `t_food_order` */

DROP TABLE IF EXISTS `t_food_order`;

CREATE TABLE `t_food_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oid` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `oid` (`oid`),
  KEY `t_food_order_ibfk_2` (`fid`),
  CONSTRAINT `t_food_order_ibfk_2` FOREIGN KEY (`fid`) REFERENCES `t_foods` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `t_food_order_ibfk_1` FOREIGN KEY (`oid`) REFERENCES `t_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8;

/*Data for the table `t_food_order` */

insert  into `t_food_order`(`id`,`oid`,`fid`) values (123,37,11),(130,38,1),(131,38,6),(132,38,7),(157,40,1),(158,40,6),(159,40,34);

/*Table structure for table `t_food_rating` */

DROP TABLE IF EXISTS `t_food_rating`;

CREATE TABLE `t_food_rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户对食品的评价',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `rateType` int(11) NOT NULL COMMENT '评论类型',
  `text` varchar(255) DEFAULT NULL COMMENT '评论内容',
  `foodid` int(11) NOT NULL COMMENT '对应食品id',
  `rateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '发表时间',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `foodid` (`foodid`),
  CONSTRAINT `t_food_rating_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `t_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `t_food_rating_ibfk_2` FOREIGN KEY (`foodid`) REFERENCES `t_foods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

/*Data for the table `t_food_rating` */

insert  into `t_food_rating`(`id`,`userid`,`rateType`,`text`,`foodid`,`rateTime`) values (1,27,0,'这个面还可以',2,'2019-05-10 11:14:02'),(2,28,0,'这个菜还可以,五星',10,'2019-04-28 12:33:33'),(3,27,0,'这道菜还可以',6,'2019-04-28 16:03:22'),(4,29,0,'还可以',3,'2019-04-29 21:38:25'),(5,29,0,'真好吃',3,'2019-04-29 21:43:52'),(7,30,0,'味道不错,价格合适!以后还会再点的',3,'2019-05-10 10:58:54'),(8,30,0,'非常不错,赏心悦目,而且味道挺好的!',4,'2019-05-10 11:00:15'),(9,30,0,'一如既往的好吃--但是今天肉有点咸',8,'2019-05-10 11:02:28'),(10,26,0,'吃的时候有点冷了,最好帮忙加热一下',4,'2019-05-10 11:08:15'),(11,26,0,'又香又脆,推荐大家来吃.',5,'2019-05-10 11:09:36'),(12,27,0,'味道值得改进',9,'2019-05-10 11:13:30'),(13,27,0,'皮蛋瘦肉粥真的是我最喜欢点的菜了',1,'2019-05-10 11:14:54'),(14,29,0,'还可以',3,'2019-05-10 17:19:40');

/*Table structure for table `t_foods` */

DROP TABLE IF EXISTS `t_foods`;

CREATE TABLE `t_foods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '食品id goods只是对食品的一个分类',
  `name` varchar(255) NOT NULL COMMENT '食品名字',
  `price` double NOT NULL COMMENT '价钱',
  `oldPrice` double DEFAULT NULL COMMENT '打折前的价钱',
  `description` varchar(255) DEFAULT NULL COMMENT '食品的描述',
  `sellCount` int(11) DEFAULT NULL COMMENT '销售量',
  `rating` int(11) DEFAULT NULL COMMENT '好评率',
  `info` varchar(255) DEFAULT NULL COMMENT '食品信息',
  `icon` varchar(255) DEFAULT NULL COMMENT '食品小图标',
  `image` varchar(255) DEFAULT NULL COMMENT '食品大图',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

/*Data for the table `t_foods` */

insert  into `t_foods`(`id`,`name`,`price`,`oldPrice`,`description`,`sellCount`,`rating`,`info`,`icon`,`image`) values (1,'皮蛋瘦肉粥',10,9,'咸粥',229,98,'皮蛋瘦肉粥','','foodsImage/c12745ed8a5171e13b427dbc39401jpeg.jpeg'),(2,'扁豆焖面',14,NULL,'',188,96,'96','','foodsImage/29e3d29b0db63d36f7c500bca31d8jpeg.jpeg'),(3,'葱花饼',10,NULL,NULL,124,85,NULL,'','foodsImage/a51e7b18751bcdf871648a23fd3b4jpeg.jpeg'),(4,'牛肉馅饼',14,NULL,NULL,114,91,NULL,'','foodsImage/bcab0e8ad97758e65ae5a62b2664ejpeg.jpeg'),(5,'招牌猪肉白菜锅贴/10个',17,NULL,NULL,101,78,NULL,'','foodsImage/9a580c1462ca1e4d3c07e112bc035jpeg.jpeg'),(6,'南瓜粥',9,NULL,'甜粥',91,100,'南瓜粥','','foodsImage/453f65f16b1391942af11511b7a90jpeg.jpeg'),(7,'红豆薏米美肤粥',12,NULL,'甜粥',86,100,NULL,'','foodsImage/260bd78ee6ac6051136c5447fe307jpeg.jpeg'),(8,'八宝酱菜',4,NULL,NULL,84,100,NULL,'','foodsImage/469d8854f9a3a03797933fd01398bjpeg.jpeg'),(9,'红枣山药糙米粥',10,NULL,NULL,81,91,NULL,'','foodsImage/469d8854f9a3a03797933fd01398bjpeg.jpeg'),(10,'糊塌子',10,NULL,NULL,80,93,NULL,'','foodsImage/097a2a59fd2a2292d08067e16380cjpeg.jpeg'),(11,'红枣山药粥套餐',29,36,'红枣山药糙米粥,素材包,爽口莴笋丝,四川泡菜或八宝酱菜,配菜可备注',17,100,NULL,'','foodsImage/cb844f0bb60c502c6d5c05e0bddf5jpeg.jpeg'),(12,'VC无限橙果汁',8,10,NULL,15,100,NULL,'','foodsImage/f348e811772016ae24e968238bcbfjpeg.jpeg'),(13,'娃娃菜炖豆腐',17,NULL,NULL,43,92,NULL,'','foodsImage/b1eb45b305635d9dd04ddf157165fjpeg.jpeg'),(14,'手撕包菜',16,NULL,NULL,29,100,NULL,'','foodsImage/f3bc84468820121112e79583c24efjpeg.jpeg'),(15,'香酥黄金鱼/3条',11,NULL,NULL,15,100,NULL,'','foodsImage/8277a6a2ea0a2e97710290499fc41jpeg.jpeg'),(17,'拍黄瓜',9,NULL,NULL,28,100,NULL,'','foodsImage/f654985b4e185f06eb07f8fa2b2e8jpeg.jpeg'),(18,'红豆薏米粥套餐',37,NULL,'红豆薏米粥,三鲜干蒸烧卖,拍黄瓜',3,100,NULL,'','foodsImage/27f26ed00c025b2200a9ccbb7e67ejpeg.jpeg'),(19,'皮蛋瘦肉粥套餐',31,NULL,NULL,12,100,NULL,'','foodsImage/f444a8087f0e940ef264617f9d98ajpeg.jpeg'),(20,'蜜瓜圣女萝莉杯',6,NULL,NULL,1,NULL,NULL,'','foodsImage/b3b04c259d5ec9fa52e1856ee50dajpeg.jpeg'),(21,'加多宝',6,NULL,NULL,7,100,NULL,'','foodsImage/5e6c99c593cf65229225c5661bcdejpeg.jpeg'),(28,'鲜蔬菌菇粥',11,NULL,'咸粥',56,100,NULL,'','foodsImage/5317c68dd618929b6ac05804e429ajpeg.jpeg'),(29,'田园蔬菜粥',10,NULL,'咸粥',33,100,NULL,'','foodsImage/7371083792c19df00e546b29e344cjpeg.jpeg'),(34,'测试02',8,9,'测试',90,88,'测试',NULL,'foodsImage/f654985b4e185f06eb07f8fa2b2e8jpeg.jpeg');

/*Table structure for table `t_goods` */

DROP TABLE IF EXISTS `t_goods`;

CREATE TABLE `t_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `name` varchar(255) DEFAULT NULL COMMENT '对应商品的分类名字',
  `type` int(11) DEFAULT NULL COMMENT '商品的前面的小图标',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `t_goods` */

insert  into `t_goods`(`id`,`name`,`type`) values (1,'热销榜',0),(2,'单人精彩套餐',0),(3,'冰爽饮品限时特惠',1),(4,'精选热菜',2),(5,'爽口凉菜',-1),(6,'精选套餐',-1),(7,'果拼果汁',-1),(8,'小吃主食',-1),(9,'特色粥品',-1);

/*Table structure for table `t_goods_foods` */

DROP TABLE IF EXISTS `t_goods_foods`;

CREATE TABLE `t_goods_foods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '食品和商品的中间表',
  `foodid` int(11) NOT NULL COMMENT '食品id',
  `goodid` int(11) NOT NULL COMMENT '商品id',
  PRIMARY KEY (`id`),
  KEY `foodid` (`foodid`),
  KEY `t_goods_foods_ibfk_2` (`goodid`),
  CONSTRAINT `t_goods_foods_ibfk_2` FOREIGN KEY (`goodid`) REFERENCES `t_goods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `t_goods_foods_ibfk_1` FOREIGN KEY (`foodid`) REFERENCES `t_foods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;

/*Data for the table `t_goods_foods` */

insert  into `t_goods_foods`(`id`,`foodid`,`goodid`) values (3,3,1),(4,4,1),(5,5,1),(7,7,1),(8,8,1),(9,9,1),(10,10,1),(11,11,2),(12,12,3),(13,13,4),(14,14,4),(15,15,4),(17,17,5),(18,18,6),(19,19,6),(20,20,7),(21,21,7),(30,7,9),(31,9,9),(32,28,9),(33,29,9),(39,2,1),(46,6,1),(47,6,2),(48,6,9),(57,1,1),(58,1,2),(59,1,9),(65,34,1);

/*Table structure for table `t_manager` */

DROP TABLE IF EXISTS `t_manager`;

CREATE TABLE `t_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '后台管理用户表',
  `loginacct` varchar(255) NOT NULL,
  `userpswd` char(32) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginacct` (`loginacct`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

/*Data for the table `t_manager` */

insert  into `t_manager`(`id`,`loginacct`,`userpswd`,`username`,`email`,`createtime`) values (18,'123','4297f44b13955235245b2497399d7a93','xia','123123@qq.com','2019-04-20 10:09:13'),(29,'admin','e10adc3949ba59abbe56e057f20f883e','张山','admin@qq.com','2019-04-23 10:57:24'),(30,'982604781','05c5f5a3c3d73ee43e7d12c4c8ce58fb','阿拉垃圾君','982604781@qq.com','2019-04-28 16:31:15'),(41,'xia','2aefc34200a294a3cc7db81b43a81873','admin','982604781@qq.com','2019-05-10 11:56:58'),(43,'admins','e10adc3949ba59abbe56e057f20f883e','admins','92@qq0.com','2019-05-10 22:42:09');

/*Table structure for table `t_manager_role` */

DROP TABLE IF EXISTS `t_manager_role`;

CREATE TABLE `t_manager_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `rid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `t_manager_role_ibfk_2` (`rid`),
  KEY `t_manager_role_ibfk_1` (`uid`),
  CONSTRAINT `t_manager_role_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `t_manager` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `t_manager_role_ibfk_2` FOREIGN KEY (`rid`) REFERENCES `t_role` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

/*Data for the table `t_manager_role` */

insert  into `t_manager_role`(`id`,`uid`,`rid`) values (18,30,1),(19,29,1),(25,18,15),(34,41,15),(35,43,15);

/*Table structure for table `t_order` */

DROP TABLE IF EXISTS `t_order`;

CREATE TABLE `t_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sellerid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `createtime` datetime NOT NULL,
  `iscomplete` tinyint(1) NOT NULL,
  `state` int(11) NOT NULL COMMENT '接收订单的状态 从0开始',
  PRIMARY KEY (`id`),
  KEY `t_order_ibfk` (`userid`),
  CONSTRAINT `t_order_ibfk` FOREIGN KEY (`userid`) REFERENCES `t_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

/*Data for the table `t_order` */

insert  into `t_order`(`id`,`sellerid`,`userid`,`createtime`,`iscomplete`,`state`) values (37,1,30,'2019-05-10 10:49:31',0,1),(38,1,26,'2019-05-10 11:47:45',0,0),(40,1,29,'2019-05-10 21:40:21',0,1);

/*Table structure for table `t_permission` */

DROP TABLE IF EXISTS `t_permission`;

CREATE TABLE `t_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

/*Data for the table `t_permission` */

insert  into `t_permission`(`id`,`pid`,`name`,`icon`,`url`) values (1,0,'用户管理','',NULL),(2,0,'权限管理','',NULL),(3,0,'商家管理','',NULL),(4,0,'商品管理','',NULL),(5,0,'订单管理','',NULL),(6,1,'前端用户维护','','user/toList'),(7,2,'后台用户维护','','permission/manager/toList'),(8,2,'后台角色维护','','permission/role/toList'),(9,2,'后台许可维护',NULL,'permission/license/list'),(10,3,'移动食堂公告管理',NULL,NULL),(11,3,'移动食堂评论管理',NULL,'seller/rating/toList'),(12,3,'移动食堂活动管理',NULL,'seller/activity/toList'),(13,3,'移动食堂信息管理',NULL,'seller/info/toList'),(14,4,'商品分类管理',NULL,'foods/goods/toList'),(15,4,'商品评论管理',NULL,'foods/rating/toList'),(16,4,'商品信息管理',NULL,'foods/info/toList'),(17,5,'订单维护',NULL,'order/toList');

/*Table structure for table `t_role` */

DROP TABLE IF EXISTS `t_role`;

CREATE TABLE `t_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL COMMENT '角色职称描述',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

/*Data for the table `t_role` */

insert  into `t_role`(`id`,`name`,`description`) values (1,'PM-项目经理','拥有所有权限'),(2,'SE-软件工程师','拥有所有权限'),(5,'GL-组长','可以控制用户管理'),(8,'SA-软件架构师','拥有所有权限'),(9,'CMO/CMS-配置管理员','拥有所有权限'),(15,'测试人员','测试人员'),(16,'系统管理员','拥有一切权限'),(17,'订单维护员','只对订单进行管理');

/*Table structure for table `t_role_permission` */

DROP TABLE IF EXISTS `t_role_permission`;

CREATE TABLE `t_role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rid` (`rid`),
  KEY `t_role_permission_ibfk_2` (`pid`),
  CONSTRAINT `t_role_permission_ibfk_2` FOREIGN KEY (`pid`) REFERENCES `t_permission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `t_role_permission_ibfk_1` FOREIGN KEY (`rid`) REFERENCES `t_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=483 DEFAULT CHARSET=utf8;

/*Data for the table `t_role_permission` */

insert  into `t_role_permission`(`id`,`rid`,`pid`) values (243,5,1),(244,5,2),(245,5,3),(246,5,4),(247,5,5),(248,5,6),(249,5,7),(299,9,1),(300,9,2),(301,9,3),(302,9,4),(303,9,5),(304,9,6),(305,9,7),(306,9,8),(307,9,11),(308,9,12),(309,9,13),(310,9,14),(311,9,15),(312,9,16),(327,1,1),(328,1,2),(329,1,3),(330,1,4),(331,1,5),(332,1,6),(333,1,7),(334,1,8),(335,1,11),(336,1,12),(337,1,13),(338,1,14),(339,1,15),(340,1,16),(341,1,17),(342,2,1),(343,2,2),(344,2,3),(345,2,4),(346,2,5),(347,2,6),(348,2,7),(349,2,8),(350,2,11),(351,2,12),(352,2,13),(353,2,14),(354,2,15),(355,2,16),(396,8,1),(397,8,2),(398,8,3),(399,8,4),(400,8,5),(401,8,6),(402,8,7),(403,8,8),(404,8,11),(405,8,12),(406,8,13),(407,8,14),(408,8,15),(409,8,16),(410,8,17),(411,16,1),(412,16,2),(413,16,3),(414,16,4),(415,16,5),(416,16,6),(417,16,7),(418,16,8),(419,16,11),(420,16,12),(421,16,13),(422,16,14),(423,16,15),(424,16,16),(425,16,17),(426,17,1),(427,17,2),(428,17,3),(429,17,4),(430,17,5),(431,17,17),(473,15,1),(474,15,2),(475,15,3),(476,15,4),(477,15,5),(478,15,6),(479,15,12),(480,15,13),(481,15,16),(482,15,17);

/*Table structure for table `t_seller` */

DROP TABLE IF EXISTS `t_seller`;

CREATE TABLE `t_seller` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '商家名字',
  `description` varchar(255) DEFAULT NULL COMMENT '商家描述',
  `deliveryTime` double DEFAULT NULL COMMENT '配送时间',
  `score` double DEFAULT NULL COMMENT '商家分数',
  `serviceScore` double DEFAULT NULL COMMENT '商家服务分数',
  `foodScore` double DEFAULT NULL COMMENT '商家食品分数',
  `rankRate` double DEFAULT NULL COMMENT '高于平均商家百分之多少',
  `minPrice` double DEFAULT NULL COMMENT '最小起送价',
  `deliveryPrice` double DEFAULT NULL COMMENT '配送费',
  `ratingCount` int(11) DEFAULT NULL COMMENT '商家排名',
  `sellCount` int(11) DEFAULT NULL COMMENT '月销售量',
  `bulletin` varchar(255) DEFAULT NULL COMMENT '公告',
  `supports` varchar(255) DEFAULT NULL COMMENT '支持的活动',
  `avatar` varchar(255) NOT NULL COMMENT '头像',
  `pics` varchar(255) DEFAULT NULL COMMENT '背景图',
  `infos` varchar(255) DEFAULT NULL COMMENT '商家信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `t_seller` */

insert  into `t_seller`(`id`,`name`,`description`,`deliveryTime`,`score`,`serviceScore`,`foodScore`,`rankRate`,`minPrice`,`deliveryPrice`,`ratingCount`,`sellCount`,`bulletin`,`supports`,`avatar`,`pics`,`infos`) values (1,'移动食堂(moving canteen)','一键点餐,无需刷卡,避免排队',38,5,5,5,69.2,NULL,20,24,90,'重庆师范大学食堂范,便宜又实惠,欢迎大家来进行点餐',NULL,'sellerImg/canvas.png','','\"该商家支持发票,请下单写好发票抬头\" \"品类:所有品类\" \"重庆师范大学\" \"营业时间:10:00-20:30\"');

/*Table structure for table `t_seller_rating` */

DROP TABLE IF EXISTS `t_seller_rating`;

CREATE TABLE `t_seller_rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户对商家的评价',
  `rateTime` datetime NOT NULL COMMENT '发表时间',
  `score` double NOT NULL COMMENT '用户评分',
  `rateType` int(11) NOT NULL COMMENT '评论类型,好评还是差评',
  `text` varchar(255) DEFAULT NULL COMMENT '评论内容,可以为空',
  `recommend` varchar(255) DEFAULT NULL COMMENT '用户推荐菜',
  `deliveryTime` double DEFAULT NULL COMMENT '配送时间',
  `userid` int(11) NOT NULL COMMENT '对应用户id',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  CONSTRAINT `t_seller_rating_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `t_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

/*Data for the table `t_seller_rating` */

insert  into `t_seller_rating`(`id`,`rateTime`,`score`,`rateType`,`text`,`recommend`,`deliveryTime`,`userid`) values (1,'2019-04-27 00:00:00',5,0,'这个还可以 五星好评!!!','皮蛋瘦肉粥,稀饭',NULL,26),(2,'2019-04-27 23:56:01',5,0,'五星好评','皮蛋瘦肉粥',NULL,27),(3,'2019-04-28 16:02:45',5,0,'这家店还可以','移动食堂',NULL,27),(5,'2019-04-29 16:49:54',5,0,'五星好评',NULL,NULL,29),(7,'2019-04-29 21:07:11',5,0,'这家店还可以',NULL,NULL,27),(17,'2019-05-01 10:08:22',1,1,'不好吃',NULL,NULL,29),(18,'2019-05-01 10:43:22',5,0,'五星好评',NULL,NULL,29),(19,'2019-05-09 10:42:04',5,0,'还可以',NULL,NULL,29);

/*Table structure for table `t_seller_support` */

DROP TABLE IF EXISTS `t_seller_support`;

CREATE TABLE `t_seller_support` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商家支持的活动中间表',
  `supportid` int(11) NOT NULL COMMENT '活动id',
  `sellerid` int(11) NOT NULL COMMENT '商家id',
  PRIMARY KEY (`id`),
  KEY `supportid` (`supportid`),
  CONSTRAINT `t_seller_support_ibfk_1` FOREIGN KEY (`supportid`) REFERENCES `t_supports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `t_seller_support` */

insert  into `t_seller_support`(`id`,`supportid`,`sellerid`) values (1,1,1),(2,2,1),(3,3,1),(4,4,1);

/*Table structure for table `t_supports` */

DROP TABLE IF EXISTS `t_supports`;

CREATE TABLE `t_supports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(2) NOT NULL COMMENT '活动类型',
  `description` varchar(32) NOT NULL COMMENT '活动描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*Data for the table `t_supports` */

insert  into `t_supports`(`id`,`type`,`description`) values (1,1,'在线支付满25减5'),(2,2,'vc果汁全场8折'),(3,3,'单人精彩套餐'),(4,4,'新品买就送饮料'),(6,3,'测试活动');

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户表id',
  `username` varchar(255) NOT NULL COMMENT '用户名',
  `loginacct` varchar(255) NOT NULL COMMENT '用户登录账号',
  `email` varchar(255) DEFAULT NULL COMMENT '用户邮箱',
  `createtime` datetime DEFAULT NULL COMMENT '用户创建时间',
  `userpswd` char(32) DEFAULT NULL COMMENT '用户密码',
  `avatar` varchar(255) NOT NULL COMMENT '用户头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginacct` (`loginacct`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

/*Data for the table `t_user` */

insert  into `t_user`(`id`,`username`,`loginacct`,`email`,`createtime`,`userpswd`,`avatar`) values (26,'123456','123456','982604781@qq.com','2019-04-27 22:03:21','e10adc3949ba59abbe56e057f20f883e','userAvatar/5a22164c3a_file_default_header.png'),(27,'夏','12345','982604781@qq.com','2019-04-27 22:05:35','e10adc3949ba59abbe56e057f20f883e','userAvatar/666b1d21aa_file_touxiang.jpg'),(28,'夏天','982604781','982604781@qq.com','2019-04-27 22:30:43','e10adc3949ba59abbe56e057f20f883e','userAvatar/e77ff67ba5_file_timg2.jpg'),(29,'admin','admin','982604781@qq.com','2019-04-28 16:47:47','21232f297a57a5a743894a0e4a801fc3','userAvatar/5a22164c3a_file_default_header.png'),(30,'asdb1','asdb1','982604781@qq.com','2019-05-10 10:48:42','33fddb0f1bf96d5217cdf0f7b93dbb32','userAvatar/f7cf67e2e4_file_timg2.jpg');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;