/*
SQLyog Ultimate v11.33 (64 bit)
MySQL - 5.5.27 : Database - db_pet_manage
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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 */;
/*Table structure for table `t_config` */
CREATE TABLE `t_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain_name` varchar(100) DEFAULT NULL,
`web_site` varchar(200) DEFAULT NULL,
`headStr` text,
`layuiStr` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table `t_config` */
LOCK TABLES `t_config` WRITE;
insert into `t_config`(`id`,`domain_name`,`web_site`,`headStr`,`layuiStr`) values (1,'宠物管理系统','http://www.###.com','<!-- 强制 高速模式 渲染网页 -->\n<meta NAME=”renderer” content=”webkit”>\n<!-- 强制 高速模式 渲染网页 -->\n\n<link href=\"/static/favicon.ico\" rel=\"shortcut icon\" />\n\n<!--添加 jq 支持加载-->\n<script src=\"/static/easy-ui/jquery.min.js\"></script>\n<!--添加 jq 支持加载-->','<!--添加 layui 支持加载-->\n<link rel=\"stylesheet\" href=\"/static/layui-v2.2.5/layui/css/layui.css\">\n<script src=\"/static/layui-v2.2.5/layui/layui.js\"></script>\n<!--添加 layui 支持加载-->');
UNLOCK TABLES;
/*Table structure for table `t_my_pet` */
CREATE TABLE `t_my_pet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`healthy` int(11) DEFAULT NULL,
`shopId` int(11) DEFAULT NULL,
`createDateTime` datetime DEFAULT NULL,
`selectDateTime` datetime DEFAULT NULL,
`selectUserId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*Data for the table `t_my_pet` */
LOCK TABLES `t_my_pet` WRITE;
insert into `t_my_pet`(`id`,`name`,`state`,`healthy`,`shopId`,`createDateTime`,`selectDateTime`,`selectUserId`) values (3,'小王','玩耍',55,2,'2018-10-08 17:32:00','2018-10-08 17:32:16',9),(6,'12','玩耍',122,1,'2018-10-08 16:41:15','2018-10-08 17:53:01',10),(7,'小王','玩耍',99,2,'2018-10-08 17:32:00','2018-10-08 17:53:03',10);
UNLOCK TABLES;
/*Table structure for table `t_pet` */
CREATE TABLE `t_pet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`healthy` int(11) DEFAULT NULL,
`num` int(11) DEFAULT NULL,
`shopId` int(11) DEFAULT NULL,
`createDateTime` datetime DEFAULT NULL,
`selectDateTime` datetime DEFAULT NULL,
`selectUserId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*Data for the table `t_pet` */
LOCK TABLES `t_pet` WRITE;
insert into `t_pet`(`id`,`name`,`state`,`healthy`,`num`,`shopId`,`createDateTime`,`selectDateTime`,`selectUserId`) values (2,'12','玩耍',122,2,1,'2018-10-08 16:41:15',NULL,NULL),(3,'小王','玩耍',99,9,2,'2018-10-08 17:32:00',NULL,NULL);
UNLOCK TABLES;
/*Table structure for table `t_shop` */
CREATE TABLE `t_shop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`address` varchar(100) DEFAULT NULL,
`orderNo` int(11) DEFAULT NULL,
`createDateTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*Data for the table `t_shop` */
LOCK TABLES `t_shop` WRITE;
insert into `t_shop`(`id`,`name`,`address`,`orderNo`,`createDateTime`) values (1,'小明的店','中国路',1,'2018-10-07 18:00:02'),(2,'杂货店','中兴路',2,'2018-10-08 09:18:51');
UNLOCK TABLES;
/*Table structure for table `t_tree` */
CREATE TABLE `t_tree` (
`id` int(11) DEFAULT NULL,
`text` varchar(46) DEFAULT NULL,
`father` int(11) DEFAULT NULL,
`url` varchar(500) DEFAULT NULL,
`state` varchar(46) DEFAULT NULL,
`iconCls` varchar(46) DEFAULT NULL,
`permissions` varchar(100) DEFAULT NULL,
`dd_id` varchar(46) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `t_tree` */
LOCK TABLES `t_tree` WRITE;
insert into `t_tree`(`id`,`text`,`father`,`url`,`state`,`iconCls`,`permissions`,`dd_id`) values (6,'信息管理',-1,NULL,'close',NULL,NULL,NULL),(61010,'门店管理',6,'/houtai/shop/manage','opend','',NULL,'shop'),(61013,'宠物管理',6,'/houtai/pet/manage','opend','',NULL,'pet'),(61015,'我的宠物',6,'/houtai/my/pet/manage','opend','',NULL,'my_pet'),(61014,'宠物市场',6,'/houtai/pet/shop','opend','',NULL,'pet_shop'),(61006,'用户管理',6,'/houtai/user/manage','opend','',NULL,'user');
UNLOCK TABLES;
/*Table structure for table `t_user` */
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`num_` varchar(60) DEFAULT NULL,
`trueName` varchar(60) DEFAULT NULL,
`phone` varchar(100) DEFAULT NULL,
`sex_` varchar(10) DEFAULT NULL,
`menuIds` varchar(100) DEFAULT NULL,
`createDateTime` datetime DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
`type` int(5) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `weiyi` (`num_`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*Data for the table `t_user` */
LOCK TABLES `t_user` WRITE;
insert into `t_user`(`id`,`num_`,`trueName`,`phone`,`sex_`,`menuIds`,`createDateTime`,`password`,`remark`,`type`) values (9,'admin','管理员','18337537555','男','6,61010,61013,61017,61006','2018-06-23 15:50:59','0680d00353f3555fe7c01f11ed89bf8b','2',1),(10,'001','123','123456123','女','6,61015,61014','2018-10-08 15:20:49','32758081c6d66cdecfcd736128dea25d',NULL,2);
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
