java web网络相册管理系统

java web网络相册管理系统jsp eclipse

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
-- -----