You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
53 lines
2.7 KiB
53 lines
2.7 KiB
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : he
|
|
Source Server Version : 50636
|
|
Source Host : localhost:3306
|
|
Source Database : hlb
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50636
|
|
File Encoding : 65001
|
|
|
|
Date: 2024-06-28 13:13:51
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user`;
|
|
CREATE TABLE `user` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`userName` varchar(20) NOT NULL,
|
|
`password` varchar(30) NOT NULL,
|
|
`sex` varchar(2) DEFAULT NULL COMMENT '性别',
|
|
`age` int(11) DEFAULT NULL COMMENT '年龄',
|
|
`telephone` varchar(20) DEFAULT NULL COMMENT '电话',
|
|
`Email` varchar(30) DEFAULT NULL COMMENT 'Email',
|
|
`address` varchar(50) DEFAULT NULL COMMENT '地址',
|
|
`pic` varchar(100) DEFAULT 't0.jpg',
|
|
`state` int(11) DEFAULT '0' COMMENT '有无领养宠物的经历 0 是没有 1 是由',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Records of user
|
|
-- ----------------------------
|
|
INSERT INTO `user` VALUES ('1', 'tzp', '11', '男', '10', '13809182091', '', '攀枝花', 't1.jpg', '3');
|
|
INSERT INTO `user` VALUES ('2', '打瞌睡', '11', '男', '50', '13908457344', '', '泸州', 't2.jpg', '0');
|
|
INSERT INTO `user` VALUES ('3', '能理解', '11', '男', '45', '13903827601', '132121129281@qq.com', '泸州', 't3.jpg', '1');
|
|
INSERT INTO `user` VALUES ('4', '云集了', '11', '男', '43', '13903822001', '', '泸州', 't4.jpg', '1');
|
|
INSERT INTO `user` VALUES ('5', '洋溢', '11', '女', '23', '13903810621', '121212549281@qq.com', '泸州', 't5.jpg', '1');
|
|
INSERT INTO `user` VALUES ('6', '陈一', '11', '男', '40', '13903819146', '12121212181@qq.com', '泸州', 't6.jpg', '0');
|
|
INSERT INTO `user` VALUES ('8', '陈二', '11', '女', '35', '13123819301', '12121212112@qq.com', '泸州', 't8.jpg', '0');
|
|
INSERT INTO `user` VALUES ('17', '陈三', '11', '女', '32', '15797959509', '21111111111@qq.com', '泸州', 't17.jpg', '0');
|
|
INSERT INTO `user` VALUES ('33', '沉思', '11', '男', '22', '1456879876', '1111111118@163.com', '泸州', 'xq1.jpg', '1');
|
|
INSERT INTO `user` VALUES ('34', '晨雾', '11', '男', '22', '1456879876', '1111111118@163.com', '泸州', 'xq2.jpg', '0');
|
|
INSERT INTO `user` VALUES ('35', 'eqw', '123456', '男', '123', 'ewqeqwe', 'qeweqw', 'qeweqw', 't0.jpg', '0');
|
|
INSERT INTO `user` VALUES ('36', '123', '123', '男', '12', '16565', '257451', '好几个', 't0.jpg', '0');
|
|
INSERT INTO `user` VALUES ('37', '1', '1', '男', '2', '23124', '21', '123', 't0.jpg', '0');
|
|
INSERT INTO `user` VALUES ('38', 'lll', '1234', '男', '22', '15281210084', '2802045328@qq.cpm', '孝泉', 't0.jpg', '0');
|