基于SpringBoot的资讯分享问答网站源码.zip

/* SQLyog Ultimate v11.33 (64 bit) MySQL - 5.7.18 : Database - ssm-news ********************************************************************* */ /*!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*/`ssm-news` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `ssm-news`; /*Table structure for table `comment` */ DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` text NOT NULL, `user_id` int(11) NOT NULL, `entity_id` int(11) NOT NULL, `entity_type` int(11) NOT NULL, `created_date` datetime NOT NULL, `status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `entity_index` (`entity_id`,`entity_type`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `comment` */ insert into `comment`(`id`,`content`,`user_id`,`entity_id`,`entity_type`,`created_date`,`status`) values (1,' 黑黑',1,1,1,'2019-01-23 20:47:59',0); insert into `comment`(`id`,`content`,`user_id`,`entity_id`,`entity_type`,`created_date`,`status`) values (2,'一点云头条，我来试试哈！！！',1,1,1,'2020-08-23 22:46:49',0); /*Table structure for table `login_ticket` */ DROP TABLE IF EXISTS `login_ticket`; CREATE TABLE `login_ticket` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `ticket` varchar(45) NOT NULL, `expired` datetime NOT NULL, `status` int(11) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `ticket_unique` (`ticket`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `login_ticket` */ insert into `login_ticket`(`id`,`user_id`,`ticket`,`expired`,`status`) values (1,1,'3084fa843ed7418882d35a4e38eeec8d','2019-01-24 20:45:45',1); insert into `login_ticket`(`id`,`user_id`,`ticket`,`expired`,`status`) values (2,1,'cb72d788753049c2bb0f3ef0f9544806','2020-08-24 22:46:00',1); insert into `login_ticket`(`id`,`user_id`,`ticket`,`expired`,`status`) values (3,2,'a5e457bd08c743a4adc7dc0957eaefde','2020-08-24 23:04:05',0); /*Table structure for table `message` */ DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `from_id` int(11) NOT NULL, `to_id` int(11) NOT NULL, `content` text NOT NULL, `created_date` datetime NOT NULL, `has_read` int(11) NOT NULL, `conversation_id` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `conversation_index` (`conversation_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `message` */ /*Table structure for table `news` */ DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(128) NOT NULL DEFAULT '', `link` varchar(256) NOT NULL DEFAULT '', `image` varchar(256) NOT NULL DEFAULT '', `like_count` int(11) NOT NULL, `comment_count` int(11) NOT NULL, `create_date` datetime NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `news` */ insert into `news`(`id`,`title`,`link`,`image`,`like_count`,`comment_count`,`create_date`,`user_id`) values (1,'一点云网站','http://www.yiidian.com','http://ssm-news.oss-cn-beijing.aliyuncs.com/f5c190a262544b3dac253c2ea78bade7.jpg',0,2,'2020-06-13 20:46:28',1); insert into `news`(`id`,`title`,`link`,`image`,`like_count`,`comment_count`,`create_date`,`user_id`) values (2,'百度网站','http://www.baidu.com','http://ssm-news.oss-cn-beijing.aliyuncs.com/f5c190a262544b3dac253c2ea78bade7.jpg',0,0,'2020-08-22 20:46:28',1); /*Table structure for table `user` */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL DEFAULT '', `password` varchar(128) NOT NULL DEFAULT '', `salt` varchar(32) NOT NULL DEFAULT '', `head_url` varchar(256) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `user` */ insert into `user`(`id`,`name`,`password`,`salt`,`head_url`) values (1,'admin','96628F3FCADF74496F679B43CE5D8EE6','4b28c','http://images.nowcoder.com/head/844t.png'); insert into `user`(`id`,`name`,`password`,`salt`,`head_url`) values (2,'xiaofeifei','EA45CEDF923B8377509301419B821A85','f62ec','http://images.nowcoder.com/head/321t.png'); /*!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 */;