开发语言：Python
框架：flask
Python版本：python3.7.7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：PyCharm
浏览器：谷歌浏览器
DROP TABLE IF EXISTS `a6woc_zhaopinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `a6woc_zhaopinxinxi` (
`id` bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`chengshien` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘城市英文名’,
`fabuhao` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘发布号’,
`zhiwei` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘职位’,
`xueli` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘学历’,
`jingyan` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘经验’,
`xinzi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘薪资’,
`gongsi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘公司’,
`gongzuodidian` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘工作地点’,
`gongsileixing` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘公司类型’,
`detail` longtext CHARACTER SET utf8 COMMENT ‘职位描述’,
`fuli` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘福利’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `aboutus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aboutus` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`title` varchar(200) NOT NULL COMMENT ‘标题’,
`subtitle` varchar(200) DEFAULT NULL COMMENT ‘副标题’,
`content` longtext NOT NULL COMMENT ‘内容’,
`picture1` longtext COMMENT ‘图片1’,
`picture2` longtext COMMENT ‘图片2’,
`picture3` longtext COMMENT ‘图片3’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=’关于我们’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `aboutus`
—
LOCK TABLES `aboutus` WRITE;
/*!40000 ALTER TABLE `aboutus` DISABLE KEYS */;
INSERT INTO `aboutus` VALUES (1,’2023-02-08 03:51:23′,’关于我们’,’ABOUT US’,’不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢?\n你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。’,’upload/aboutus_picture1.jpg’,’upload/aboutus_picture2.jpg’,’upload/aboutus_picture3.jpg’);
/*!40000 ALTER TABLE `aboutus` ENABLE KEYS */;
UNLOCK TABLES;
—
— 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/picture1.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discusszhaopinxinxi`
—
DROP TABLE IF EXISTS `discusszhaopinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusszhaopinxinxi` (
`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’,
`avatarurl` longtext COMMENT ‘头像’,
`nickname` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`content` longtext NOT NULL COMMENT ‘评论内容’,
`reply` longtext COMMENT ‘回复内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’zhaopinxinxi评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discusszhaopinxinxi`
—
LOCK TABLES `discusszhaopinxinxi` WRITE;
/*!40000 ALTER TABLE `discusszhaopinxinxi` DISABLE KEYS */;
/*!40000 ALTER TABLE `discusszhaopinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— 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` longtext NOT NULL COMMENT ‘图片’,
`content` longtext NOT NULL COMMENT ‘内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT=’公告资讯’;
/*!40101 SET character_set_client = @saved_cs_client */;