赞
踩
有管理员,策划师,用户三个角色。
管理员功能有个人中心,用户管理,策划师管理,婚庆策划管理,类型管理,婚纱照管理,定制信息管理,婚庆预约管理,拍摄预约管理,衣服定制管理,系统管理等。策划师主要负责婚庆相关的策划工作,用户可以注册登录,可以婚庆预约,拍摄预约,衣服定制,收藏相关信息等。
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm48yhg` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssm48yhg`;
--
-- Table structure for table `cehuashi`
--
DROP TABLE IF EXISTS `cehuashi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cehuashi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`cehuazhanghao` varchar(200) NOT NULL COMMENT '策划账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`cehuaxingming` varchar(200) NOT NULL COMMENT '策划姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',
PRIMARY KEY (`id`),
UNIQUE KEY `cehuazhanghao` (`cehuazhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552853837 DEFAULT CHARSET=utf8 COMMENT='策划师';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cehuashi`
--
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/1646552887380.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dingzhixinxi`
--
DROP TABLE IF EXISTS `dingzhixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dingzhixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingzhimingcheng` varchar(200) NOT NULL COMMENT '定制名称',
`dingzhixiaoguo` varchar(200) DEFAULT NULL COMMENT '定制效果',
`dingzhileixing` varchar(200) DEFAULT NULL COMMENT '定制类型',
`dingzhijiage` int(11) DEFAULT NULL COMMENT '定制价格',
`dingzhixiangqing` longtext COMMENT '定制详情',
`cehuazhanghao` varchar(200) DEFAULT NULL COMMENT '策划账号',
`cehuaxingming` varchar(200) DEFAULT NULL COMMENT '策划姓名',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646553127127 DEFAULT CHARSET=utf8 COMMENT='定制信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `discussdingzhixinxi`
--
DROP TABLE IF EXISTS `discussdingzhixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdingzhixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT='定制信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `discusshunqingcehua`
--
DROP TABLE IF EXISTS `discusshunqingcehua`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusshunqingcehua` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552636455 DEFAULT CHARSET=utf8 COMMENT='婚庆策划评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `discusshunshazhao`
--
DROP TABLE IF EXISTS `discusshunshazhao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusshunshazhao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='婚纱照评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `hunqingcehua`
--
DROP TABLE IF EXISTS `hunqingcehua`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hunqingcehua` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`hunqingbiaoti` varchar(200) NOT NULL COMMENT '婚庆标题',
`hunqingfengmian` varchar(200) DEFAULT NULL COMMENT '婚庆封面',
`leixing` varchar(200) DEFAULT NULL COMMENT '类型',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`feiyong` int(11) DEFAULT NULL COMMENT '费用',
`liuchengjianjie` longtext COMMENT '流程简介',
`hunqingxiangqing` longtext COMMENT '婚庆详情',
`cehuazhanghao` varchar(200) DEFAULT NULL COMMENT '策划账号',
`cehuaxingming` varchar(200) DEFAULT NULL COMMENT '策划姓名',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646553029230 DEFAULT CHARSET=utf8 COMMENT='婚庆策划';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hunqingcehua`
--
--
-- Table structure for table `hunqingyuyue`
--
DROP TABLE IF EXISTS `hunqingyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hunqingyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`hunqingbiaoti` varchar(200) DEFAULT NULL COMMENT '婚庆标题',
`hunqingfengmian` varchar(200) DEFAULT NULL COMMENT '婚庆封面',
`leixing` varchar(200) DEFAULT NULL COMMENT '类型',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`feiyong` varchar(200) DEFAULT NULL COMMENT '费用',
`cehuazhanghao` varchar(200) DEFAULT NULL COMMENT '策划账号',
`cehuaxingming` varchar(200) DEFAULT NULL COMMENT '策划姓名',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`yuyueriqi` date DEFAULT NULL COMMENT '预约日期',
`beizhu` longtext COMMENT '备注',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552666136 DEFAULT CHARSET=utf8 COMMENT='婚庆预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hunqingyuyue`
--
--
-- Table structure for table `hunshazhao`
--
DROP TABLE IF EXISTS `hunshazhao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hunshazhao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`taocanmingcheng` varchar(200) NOT NULL COMMENT '套餐名称',
`taocanfengmian` varchar(200) DEFAULT NULL COMMENT '套餐封面',
`sheyingdidian` varchar(200) DEFAULT NULL COMMENT '摄影地点',
`taocanjiage` int(11) DEFAULT NULL COMMENT '套餐价格',
`taocanjianjie` longtext COMMENT '套餐简介',
`taocanxiangqing` longtext COMMENT '套餐详情',
`cehuazhanghao` varchar(200) DEFAULT NULL COMMENT '策划账号',
`cehuaxingming` varchar(200) DEFAULT NULL COMMENT '策划姓名',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646553081317 DEFAULT CHARSET=utf8 COMMENT='婚纱照';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `leixing`
--
DROP TABLE IF EXISTS `leixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`leixing` varchar(200) NOT NULL COMMENT '类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552863160 DEFAULT CHARSET=utf8 COMMENT='类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552919004 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `paisheyuyue`
--
DROP TABLE IF EXISTS `paisheyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paisheyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`taocanmingcheng` varchar(200) NOT NULL COMMENT '套餐名称',
`taocanfengmian` varchar(200) DEFAULT NULL COMMENT '套餐封面',
`sheyingdidian` varchar(200) DEFAULT NULL COMMENT '摄影地点',
`taocanjiage` int(11) DEFAULT NULL COMMENT '套餐价格',
`cehuazhanghao` varchar(200) DEFAULT NULL COMMENT '策划账号',
`cehuaxingming` varchar(200) DEFAULT NULL COMMENT '策划姓名',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`xiadanshijian` date DEFAULT NULL COMMENT '下单时间',
`beizhu` longtext COMMENT '备注',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552687174 DEFAULT CHARSET=utf8 COMMENT='拍摄预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552607709 DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `yifudingzhi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yifudingzhi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingzhimingcheng` varchar(200) NOT NULL COMMENT '定制名称',
`dingzhixiaoguo` varchar(200) DEFAULT NULL COMMENT '定制效果',
`dingzhileixing` varchar(200) DEFAULT NULL COMMENT '定制类型',
`dingzhijiage` int(11) DEFAULT NULL COMMENT '定制价格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`jine` int(11) DEFAULT NULL COMMENT '金额',
`cehuazhanghao` varchar(200) DEFAULT NULL COMMENT '策划账号',
`cehuaxingming` varchar(200) DEFAULT NULL COMMENT '策划姓名',
`lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
`xiadanriqi` date DEFAULT NULL COMMENT '下单日期',
`beizhu` longtext COMMENT '备注',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552714204 DEFAULT CHARSET=utf8 COMMENT='衣服定制';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) NOT NULL COMMENT '账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646552442341 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。