master

分支 (1)

管理

管理

master

Ipet
/
newipet.sql

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 10.5.11-MariaDB : Database - newipet
*********************************************************************
*/

/*!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*/`newipet` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `newipet`;

/*Table structure for table `item` */

DROP TABLE IF EXISTS `item`;

CREATE TABLE `item` (
  `item_id` int(64) NOT NULL,
  `user_id` int(64) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_desc` varchar(512) DEFAULT NULL COMMENT '商品描述',
  `category` varchar(255) DEFAULT NULL COMMENT '商品类别',
  `image` varchar(255) DEFAULT NULL,
  `videourl` varchar(255) DEFAULT NULL COMMENT '视频',
  `orimoney` int(11) DEFAULT NULL COMMENT '商品价格,单位为分',
  `city` varchar(255) DEFAULT NULL,
  `item_status` int(10) DEFAULT NULL COMMENT '商品状态:0违规 1正常 2删除 3待审核 4已售出',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `item` */

insert  into `item`(`item_id`,`user_id`,`item_name`,`item_desc`,`category`,`image`,`videourl`,`orimoney`,`city`,`item_status`,`created`,`updated`) values (1,4,'三花猫',NULL,'猫/三花猫',NULL,NULL,500,NULL,1,NULL,NULL);

/*Table structure for table `item_cate` */

DROP TABLE IF EXISTS `item_cate`;

CREATE TABLE `item_cate` (
  `id` int(64) NOT NULL AUTO_INCREMENT,
  `parent_id` int(64) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` int(5) DEFAULT 1,
  `level` int(5) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `item_cate` */

insert  into `item_cate`(`id`,`parent_id`,`name`,`status`,`level`,`created`,`updated`) values (1,0,'宠物',1,1,NULL,NULL),(2,1,'狗',1,2,NULL,NULL),(3,2,'金毛',1,3,NULL,NULL),(4,2,'边牧',1,3,NULL,NULL),(5,2,'博美',1,3,NULL,NULL),(6,2,'柯基',1,3,NULL,NULL),(7,1,'猫',1,2,NULL,NULL),(8,7,'狸花猫',1,3,NULL,NULL),(9,7,'橘猫',1,3,NULL,NULL),(10,7,'金渐层',1,3,NULL,NULL),(11,7,'三花猫',1,3,NULL,NULL);

/*Table structure for table `item_desc` */

DROP TABLE IF EXISTS `item_desc`;

CREATE TABLE `item_desc` (
  `id` int(50) NOT NULL,
  `item_id` varchar(64) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `videourl` varchar(512) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `item_desc` */

insert  into `item_desc`(`id`,`item_id`,`image`,`videourl`,`created`,`updated`) values (1,'1',NULL,NULL,NULL,NULL);

/*Table structure for table `navigate` */

DROP TABLE IF EXISTS `navigate`;

CREATE TABLE `navigate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `path` varchar(50) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

/*Data for the table `navigate` */

insert  into `navigate`(`id`,`name`,`parent_id`,`path`,`level`,`created`,`updated`) values (1,'用户管理',0,NULL,1,NULL,NULL),(2,'用户列表',1,'/user',2,NULL,NULL),(3,'商品管理',0,NULL,1,NULL,NULL),(4,'商品列表',3,'/item',2,NULL,NULL),(5,'商品分类',3,'/itemCate',2,NULL,NULL),(6,'权限管理',0,NULL,1,NULL,NULL),(7,'角色列表',6,'/role',2,NULL,NULL),(8,'权限列表',6,'/rights',2,NULL,NULL),(9,'订单管理',0,NULL,1,NULL,NULL),(10,'订单列表',9,'/orders',2,NULL,NULL),(11,'日志管理',0,NULL,1,NULL,NULL),(12,'登录日志',11,'/loginLog',2,NULL,NULL),(13,'操作日志',11,'/operateLog',2,NULL,NULL);

/*Table structure for table `user_info` */

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (
  `user_id` int(50) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `uimage` varchar(255) DEFAULT NULL COMMENT '头像',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `sex` int(5) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `userstatus` tinyint(1) DEFAULT NULL COMMENT '用户是否在线',
  `status` tinyint(1) DEFAULT NULL COMMENT '账号是否正常',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `user_info` */

insert  into `user_info`(`user_id`,`username`,`password`,`phone`,`uimage`,`email`,`sex`,`city`,`userstatus`,`status`,`created`,`updated`) values (1,'admin','admin123','15272333333',NULL,'1234@qq.com',1,'锦江区',1,1,NULL,NULL),(2,'admin123','admin123456','15171111111',NULL,'2344444@qq.com',1,'高新区',1,1,NULL,NULL),(3,'张鑫宇','zxy123','13895226654',NULL,'68732167@qq.com',1,'金牛区',1,1,NULL,NULL),(4,'王小小','wxx123','11144587798',NULL,'12434@qq.com',0,NULL,1,1,NULL,NULL),(5,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `user_perm` */

DROP TABLE IF EXISTS `user_perm`;

CREATE TABLE `user_perm` (
  `role_id` int(11) DEFAULT NULL,
  `perms` varchar(255) DEFAULT NULL COMMENT '对应权限',
  `mean` varchar(255) DEFAULT NULL COMMENT '权限解释'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user_perm` */

insert  into `user_perm`(`role_id`,`perms`,`mean`) values (1,NULL,'不可登录后台'),(2,NULL,'仅审核信息'),(3,NULL,'可以修改其他用户权限');

/*Table structure for table `user_role` */

DROP TABLE IF EXISTS `user_role`;

CREATE TABLE `user_role` (
  `user_id` int(50) NOT NULL,
  `role_id` int(11) DEFAULT 1,
  `identity` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user_role` */

insert  into `user_role`(`user_id`,`role_id`,`identity`) values (1,3,'超级管理员'),(2,2,'管理员(审核信息)'),(3,1,'普通用户'),(4,1,'普通用户');

/*!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 */;