开发语言：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 */;
