Java 汽車租賃管理系統 數據庫配置說明xmsql

?

?

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

總結

以上是生活随笔為你收集整理的Java 汽车租赁管理系统的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。