db/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

DROP DATABASE IF EXISTS jspmfz6u8;

CREATE DATABASE jspmfz6u8 default character set utf8mb4 collate utf8mb4_general_ci;

USE jspmfz6u8;

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`yonghuming` varchar(200) NOT NULL UNIQUE   COMMENT '用户名',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xingming` varchar(200) NOT NULL   COMMENT '姓名',
	`touxiang` varchar(200)    COMMENT '头像',
	`xingbie` varchar(200)    COMMENT '性别',
	`shoujihaoma` varchar(200)    COMMENT '手机号码',
	`youxiang` varchar(200)    COMMENT '邮箱',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

INSERT INTO yonghu(id,yonghuming,mima,xingming,touxiang,xingbie,shoujihaoma,youxiang) VALUES(11,'用户1','123456','姓名1','http://localhost:8080/jspmfz6u8/upload/yonghu_touxiang1.jpg','男','13823888881','773890001@qq.com');
INSERT INTO yonghu(id,yonghuming,mima,xingming,touxiang,xingbie,shoujihaoma,youxiang) VALUES(12,'用户2','123456','姓名2','http://localhost:8080/jspmfz6u8/upload/yonghu_touxiang2.jpg','男','13823888882','773890002@qq.com');
INSERT INTO yonghu(id,yonghuming,mima,xingming,touxiang,xingbie,shoujihaoma,youxiang) VALUES(13,'用户3','123456','姓名3','http://localhost:8080/jspmfz6u8/upload/yonghu_touxiang3.jpg','男','13823888883','773890003@qq.com');
INSERT INTO yonghu(id,yonghuming,mima,xingming,touxiang,xingbie,shoujihaoma,youxiang) VALUES(14,'用户4','123456','姓名4','http://localhost:8080/jspmfz6u8/upload/yonghu_touxiang4.jpg','男','13823888884','773890004@qq.com');
INSERT INTO yonghu(id,yonghuming,mima,xingming,touxiang,xingbie,shoujihaoma,youxiang) VALUES(15,'用户5','123456','姓名5','http://localhost:8080/jspmfz6u8/upload/yonghu_touxiang5.jpg','男','13823888885','773890005@qq.com');
INSERT INTO yonghu(id,yonghuming,mima,xingming,touxiang,xingbie,shoujihaoma,youxiang) VALUES(16,'用户6','123456','姓名6','http://localhost:8080/jspmfz6u8/upload/yonghu_touxiang6.jpg','男','13823888886','773890006@qq.com');

DROP TABLE IF EXISTS `qiye`;

CREATE TABLE `qiye` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`qiyehao` varchar(200) NOT NULL UNIQUE   COMMENT '企业号',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`qiyemingcheng` varchar(200) NOT NULL   COMMENT '企业名称',
	`tupian` varchar(200)    COMMENT '图片',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`dizhi` varchar(200)    COMMENT '地址',
	`youxiang` varchar(200)    COMMENT '邮箱',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业';

INSERT INTO qiye(id,qiyehao,mima,qiyemingcheng,tupian,lianxidianhua,dizhi,youxiang) VALUES(21,'企业1','123456','企业名称1','http://localhost:8080/jspmfz6u8/upload/qiye_tupian1.jpg','13823888881','地址1','773890001@qq.com');
INSERT INTO qiye(id,qiyehao,mima,qiyemingcheng,tupian,lianxidianhua,dizhi,youxiang) VALUES(22,'企业2','123456','企业名称2','http://localhost:8080/jspmfz6u8/upload/qiye_tupian2.jpg','13823888882','地址2','773890002@qq.com');
INSERT INTO qiye(id,qiyehao,mima,qiyemingcheng,tupian,lianxidianhua,dizhi,youxiang) VALUES(23,'企业3','123456','企业名称3','http://localhost:8080/jspmfz6u8/upload/qiye_tupian3.jpg','13823888883','地址3','773890003@qq.com');
INSERT INTO qiye(id,qiyehao,mima,qiyemingcheng,tupian,lianxidianhua,dizhi,youxiang) VALUES(24,'企业4','123456','企业名称4','http://localhost:8080/jspmfz6u8/upload/qiye_tupian4.jpg','13823888884','地址4','773890004@qq.com');
INSERT INTO qiye(id,qiyehao,mima,qiyemingcheng,tupian,lianxidianhua,dizhi,youxiang) VALUES(25,'企业5','123456','企业名称5','http://localhost:8080/jspmfz6u8/upload/qiye_tupian5.jpg','13823888885','地址5','773890005@qq.com');
INSERT INTO qiye(id,qiyehao,mima,qiyemingcheng,tupian,lianxidianhua,dizhi,youxiang) VALUES(26,'企业6','123456','企业名称6','http://localhost:8080/jspmfz6u8/upload/qiye_tupian6.jpg','13823888886','地址6','773890006@qq.com');

DROP TABLE IF EXISTS `zhiweileibie`;

CREATE TABLE `zhiweileibie` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`zhiweileibie` varchar(200) NOT NULL   COMMENT '职位类别',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='职位类别';

INSERT INTO zhiweileibie(id,zhiweileibie) VALUES(31,'职位类别1');