美女表-beauty

目的

　　描述的是美女和他们男朋友的关系

数据图

数据源

/*
Navicat MySQL Data TransferSource Server         : 135数据库
Source Server Version : 50650
Source Host           : 192.168.209.135:3306
Source Database       : girlsTarget Server Type    : MYSQL
Target Server Version : 50650
File Encoding         : 65001Date: 2020-12-28 16:47:12
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for beauty
-- ----------------------------
DROP TABLE IF EXISTS `beauty`;
CREATE TABLE `beauty` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) NOT NULL,`sex` char(1) DEFAULT '女',`borndate` datetime DEFAULT '1987-01-01 00:00:00',`phone` varchar(11) NOT NULL,`photo` blob,`boyfriend_id` int(11) DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of beauty
-- ----------------------------
INSERT INTO `beauty` VALUES ('1', '柳岩', '女', '1988-02-03 00:00:00', '18209876577', null, '8');
INSERT INTO `beauty` VALUES ('2', '苍老师', '女', '1987-12-30 00:00:00', '18219876577', null, '9');
INSERT INTO `beauty` VALUES ('3', 'Angelababy', '女', '1989-02-03 00:00:00', '18209876567', null, '3');
INSERT INTO `beauty` VALUES ('4', '热巴', '女', '1993-02-03 00:00:00', '18209876579', null, '2');
INSERT INTO `beauty` VALUES ('5', '周冬雨', '女', '1992-02-03 00:00:00', '18209179577', null, '9');
INSERT INTO `beauty` VALUES ('6', '周芷若', '女', '1988-02-03 00:00:00', '18209876577', null, '1');
INSERT INTO `beauty` VALUES ('7', '岳灵珊', '女', '1987-12-30 00:00:00', '18219876577', null, '9');
INSERT INTO `beauty` VALUES ('8', '小昭', '女', '1989-02-03 00:00:00', '18209876567', null, '1');
INSERT INTO `beauty` VALUES ('9', '双儿', '女', '1993-02-03 00:00:00', '18209876579', null, '9');
INSERT INTO `beauty` VALUES ('10', '王语嫣', '女', '1992-02-03 00:00:00', '18209179577', null, '4');
INSERT INTO `beauty` VALUES ('11', '夏雪', '女', '1993-02-03 00:00:00', '18209876579', null, '9');
INSERT INTO `beauty` VALUES ('12', '赵敏', '女', '1992-02-03 00:00:00', '18209179577', null, '1');-- ----------------------------
-- Table structure for boys
-- ----------------------------
DROP TABLE IF EXISTS `boys`;
CREATE TABLE `boys` (`id` int(11) NOT NULL AUTO_INCREMENT,`boyName` varchar(20) DEFAULT NULL,`userCP` int(11) DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of boys
-- ----------------------------
INSERT INTO `boys` VALUES ('1', '张无忌', '100');
INSERT INTO `boys` VALUES ('2', '鹿晗', '800');
INSERT INTO `boys` VALUES ('3', '黄晓明', '50');
INSERT INTO `boys` VALUES ('4', '段誉', '300');

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！