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

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