JavaWeb校园宿舍管理系统JavaWeb校园宿舍管理系统
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for car
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`goodsId` int(11) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_pvkclq3v68c3acqo6ivqh2f92` (`goodsId`),
KEY `FK_ep0mtwg2w4rju18rk2wm153wg` (`userId`),
CONSTRAINT `FK_ep0mtwg2w4rju18rk2wm153wg` FOREIGN KEY (`userId`) REFERENCES `user` (`id`),
CONSTRAINT `FK_pvkclq3v68c3acqo6ivqh2f92` FOREIGN KEY (`goodsId`) REFERENCES `goods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of car
-- ----------------------------
-- ----------------------------
-- Table structure for dd
-- ----------------------------
DROP TABLE IF EXISTS `dd`;
CREATE TABLE `dd` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`goodsId` int(11) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_548toqb33aavwqnpti6to5fwv` (`goodsId`),
KEY `FK_ictbe1fmckey0v1blmqidtbbh` (`userId`),
CONSTRAINT `FK_548toqb33aavwqnpti6to5fwv` FOREIGN KEY (`goodsId`) REFERENCES `goods` (`id`),
CONSTRAINT `FK_ictbe1fmckey0v1blmqidtbbh` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dd
-- ----------------------------
INSERT INTO `dd` VALUES ('7', '7', '6', '17041521090001', '2017-04-15 21:09:02', null, ' 1测试', '12');
-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`isDelete` int(11) DEFAULT NULL,
`price` double NOT NULL,
`title` varchar(255) DEFAULT NULL,
`url1` varchar(255) DEFAULT NULL,
`url2` varchar(255) DEFAULT NULL,
`url3` varchar(255) DEFAULT NULL,
`url4` varchar(255) DEFAULT NULL,
`ppId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_m8jpxcm9wffl7vgvxeydquemp` (`ppId`),
CONSTRAINT `FK_m8jpxcm9wffl7vgvxeydquemp` FOREIGN KEY (`ppId`) REFERENCES `pp` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for manage
-- ----------------------------
DROP TABLE IF EXISTS `manage`;
CREATE TABLE `manage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`passWord` varchar(255) DEFAULT NULL,
`realName` varchar(255) DEFAULT NULL,
`type` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of manage
-- ----------------------------
INSERT INTO `manage` VALUES ('1', 'admin', '111111', '管理员', '1');
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` longtext,
`createTime` datetime DEFAULT NULL,
`introduction` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '122233', null, null, '测试公告');
-- ----------------------------
-- Table structure for pp
-- ----------------------------
DROP TABLE IF EXISTS `pp`;
CREATE TABLE `pp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cpUrl` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`lbId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_f1x00nmm3d4xdha0vvpccg1g7` (`lbId`),
CONSTRAINT `FK_f1x00nmm3d4xdha0vvpccg1g7` FOREIGN KEY (`lbId`) REFERENCES `lb` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;