SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
– Table structure for job
DROP TABLE IF EXISTS job
;
CREATE TABLE job
(
id
int(11) NOT NULL,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of job
INSERT INTO job
VALUES (1, ‘温情’);
INSERT INTO job
VALUES (2, ‘奇幻’);
INSERT INTO job
VALUES (3, ‘动作’);
INSERT INTO job
VALUES (4, ‘科技’);
INSERT INTO job
VALUES (5, ‘剧情’);
INSERT INTO job
VALUES (6, ‘冒险’);
INSERT INTO job
VALUES (7, ‘爱情’);
INSERT INTO job
VALUES (8, ‘动画’);
INSERT INTO job
VALUES (9, ‘唱’);
INSERT INTO job
VALUES (10, ‘跳’);
INSERT INTO job
VALUES (11, ‘rap’);
INSERT INTO job
VALUES (12, ‘篮球’);
INSERT INTO job
VALUES (13, ‘Music’);
– Table structure for user
DROP TABLE IF EXISTS user
;
CREATE TABLE user
(
id
int(11) NOT NULL AUTO_INCREMENT,
user_id
varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
name
varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
img
varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
say
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
e_mail
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
tel
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
website
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
say_two
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
job
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of user
INSERT INTO user
VALUES (1, ‘11’, ‘娜乌西卡’, ‘33.jpg’, ‘最远的旅行,是从自己的身体到自己的心,是从一个人的心到另一个人的心。坚强不是面对悲伤不流一滴泪,而是擦干眼泪后微笑面对以后的生活。’, ‘123132131@163.com’, ‘1321213213’, ‘www.hingdlg.com’, ‘坚强,不是面对悲伤不流一滴泪,而是擦乾眼泪后微笑著面对以后的生活。’, ‘风之谷’);
INSERT INTO user
VALUES (2, ‘22’, ‘宗介’, ‘222.jpg’, ‘信仰到底是什么呢,就是纵身一跃,就是我们眼神之间的要给永远的约定,是舍弃旧的开始新的生活;信仰就是从今以后,再也不要放开你的手’, ‘32154512@qq.com’, ‘8596131’, ‘www.jlkj;asdf.com’, ‘你明明知道分开的后果,却还要跟一无所知一样全部付出?’, ‘悬崖上的金鱼姬’);
INSERT INTO user
VALUES (3, ‘33’, ‘吉冈春’, ‘1234.jpg’, ‘你应该学着做自己,面对真实的自我,只要做到这一点你就什么都不用惧怕。’, ‘64156413@163.com’, ‘985656210’, ‘www.sdgafsf.com’, ‘人是要长大的,有天你也会推着婴儿车幸福地在街上行走,而曾经的喜欢,不管曾经怎样,都会幻化成风,消失在时光的隧道。所以向前走,向前走,无须回头。’, ‘猫的报恩’);
INSERT INTO user
VALUES (4, ‘44’, ‘珊’, ‘12.jpg’, ‘到不了的地方都叫做远方,回不去的世界都叫做家乡,我一直向往的却是比远更远的地方’, ‘9865154156464@qq.com’, ‘8441316584621’, ‘www.sadfllllfll.com’, ‘不管你曾经被伤害得有多深,总会有一个人的出现,让你原谅之前生活对你所有的刁难。’, ‘幽灵公主’);
INSERT INTO user
VALUES (5, ‘55’, ‘蔡徐坤’, ‘111.jpg’, ‘大家好,我是练习时长两年半的个人练习生 蔡徐坤’, ‘12221331@163.com’, ‘45461324651’, ‘https://tieba.baidu.com/p/6092249316?red_tag=1504080137’, ‘向阳花木易为春 听说你爱蔡徐坤 \r\n用任何单一的名词定义我 我都是拒绝的 \r\n我是热爱舞台的坤坤 全民制作请多关照 \r\n对此本宝宝无观点 只觉得 \r\n文能放电颠倒众生 武能网眼穿出格调 \r\n如果你已经pick我的话 \r\n恭喜你 你眼光真好 \r\n如果你还在pick我的路上 \r\n亲 蔡徐坤了解一下’, ‘鸡你太美’);
– Table structure for user1
DROP TABLE IF EXISTS user1
;
CREATE TABLE user1
(
id
int(11) NOT NULL AUTO_INCREMENT,
user_id
varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
password
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
user_name
varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
head_img
varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
short_description
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
email
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
tel
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
web
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
x
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
xx
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
xxx
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
xxxx
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
xxxxx
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of user1
INSERT INTO user1
VALUES (1, ‘456789’, ‘123456’, ‘老王’, ‘456789.jpeg’, ‘我就是老王,你不懂我,但我熟掌你心,哈哈哈哈哈’, ‘123456@qq.com’, ‘123456456’, ‘安徽省’, ‘学习使我快乐1’, ‘学习使我快乐2’, ‘学习使我快乐3’, ‘学习使我快乐4’, ‘学习使我快乐5’);
INSERT INTO user1
VALUES (2, ‘123456’, ‘123456’, ‘老王1’, ‘123456.jpeg’, ‘我就是老王1,你不懂我,但我熟掌你心,哈哈哈哈哈’, ‘1123456@qq.com’, ‘1123456456’, ‘安徽省1’, ‘1学习使我快乐1’, ‘1学习使我快乐2’, ‘1学习使我快乐3’, ‘1学习使我快乐4’, ‘1学习使我快乐5’);
INSERT INTO user1
VALUES (3, ‘1060377319’, ‘123456’, ‘张三’, NULL, NULL, ‘1060377319@qq.com’, NULL, ‘www.baidu.com’, NULL, NULL, NULL, NULL, NULL);
INSERT INTO user1
VALUES (4, ‘111’, ‘123456’, ‘123456’, NULL, NULL, ‘111@qq.com’, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO user1
VALUES (5, ‘1060377320’, ‘123’, ‘小号’, NULL, NULL, ‘1060377320@qq.com’, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
– Table structure for user_to_job
DROP TABLE IF EXISTS user_to_job
;
CREATE TABLE user_to_job
(
id
int(11) NOT NULL AUTO_INCREMENT,
user_id
int(11) NULL DEFAULT NULL,
job_id
int(11) NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE,
INDEX user_id
(user_id
) USING BTREE,
INDEX job_id
(job_id
) USING BTREE,
CONSTRAINT user_to_job_ibfk_1
FOREIGN KEY (user_id
) REFERENCES user
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT user_to_job_ibfk_2
FOREIGN KEY (job_id
) REFERENCES job
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of user_to_job
INSERT INTO user_to_job
VALUES (1, 1, 1);
INSERT INTO user_to_job
VALUES (2, 1, 2);
INSERT INTO user_to_job
VALUES (3, 1, 3);
INSERT INTO user_to_job
VALUES (4, 1, 4);
INSERT INTO user_to_job
VALUES (5, 1, 6);
INSERT INTO user_to_job
VALUES (6, 2, 5);
INSERT INTO user_to_job
VALUES (7, 2, 8);
INSERT INTO user_to_job
VALUES (8, 2, 1);
INSERT INTO user_to_job
VALUES (9, 2, 6);
INSERT INTO user_to_job
VALUES (10, 2, 4);
INSERT INTO user_to_job
VALUES (11, 3, 1);
INSERT INTO user_to_job
VALUES (12, 3, 2);
INSERT INTO user_to_job
VALUES (13, 3, 4);
INSERT INTO user_to_job
VALUES (14, 3, 8);
INSERT INTO user_to_job
VALUES (15, 3, 6);
INSERT INTO user_to_job
VALUES (16, 4, 5);
INSERT INTO user_to_job
VALUES (17, 4, 6);
INSERT INTO user_to_job
VALUES (18, 4, 1);
INSERT INTO user_to_job
VALUES (19, 4, 2);
INSERT INTO user_to_job
VALUES (20, 4, 4);
INSERT INTO user_to_job
VALUES (21, 5, 9);
INSERT INTO user_to_job
VALUES (22, 5, 10);
INSERT INTO user_to_job
VALUES (23, 5, 11);
INSERT INTO user_to_job
VALUES (24, 5, 12);
INSERT INTO user_to_job
VALUES (25, 5, 13);
SET FOREIGN_KEY_CHECKS = 1;