java酒店管理系统

java酒店管理系统 数据库配置说明文件

-- ----------------------------
-- Table structure for fw
-- ----------------------------
DROP TABLE IF EXISTS `fw`;
CREATE TABLE `fw` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL,
  `other_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_g40v6yvmd6ex4wto7j6qp1ebh` (`other_id`),
  CONSTRAINT `FK_g40v6yvmd6ex4wto7j6qp1ebh` FOREIGN KEY (`other_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of fw
-- ----------------------------
INSERT INTO `fw` VALUES ('5', '4', '1');
INSERT INTO `fw` VALUES ('6', '3', '1');
INSERT INTO `fw` VALUES ('7', '3', '1');
INSERT INTO `fw` VALUES ('8', '3', '1');
INSERT INTO `fw` VALUES ('9', '3', '5');
INSERT INTO `fw` VALUES ('10', '3', '5');
INSERT INTO `fw` VALUES ('11', '3', '5');
INSERT INTO `fw` VALUES ('12', '5', '3');

-- ----------------------------
-- Table structure for t_advice
-- ----------------------------
DROP TABLE IF EXISTS `t_advice`;
CREATE TABLE `t_advice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `isXS` int(11) DEFAULT NULL,
  `senduser_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_sl3xsldfhj6u23qnfem2xx9i5` (`senduser_id`),
  CONSTRAINT `FK_sl3xsldfhj6u23qnfem2xx9i5` FOREIGN KEY (`senduser_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_advice
-- ----------------------------
INSERT INTO `t_advice` VALUES ('1', '这都是啥啊', '2017-03-06 21:26:08', '1', '1');
INSERT INTO `t_advice` VALUES ('2', '愁死我了', '2017-03-06 21:26:13', '1', '1');
INSERT INTO `t_advice` VALUES ('3', '社区外来人员公告', '2017-03-06 21:27:02', '1', '1');
INSERT INTO `t_advice` VALUES ('4', '外来人员注册要注意。。。', '2017-03-06 21:27:39', '1', '1');
INSERT INTO `t_advice` VALUES ('5', '我感觉不好', '2017-03-06 23:37:52', '1', '5');

-- ----------------------------
-- Table structure for t_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_comment`;
CREATE TABLE `t_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `comuser_id` int(11) DEFAULT NULL,
  `father_id` int(11) DEFAULT NULL,
  `sayMood_id` int(11) DEFAULT NULL,
  `sayuser_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_ewiban3bx8u7u6o5k7dhqxlwn` (`comuser_id`),
  KEY `FK_53uroixicwfdfqdyhmsgbgddl` (`father_id`),
  KEY `FK_73okwccwkkv4lps4ddmswks5l` (`sayMood_id`),
  KEY `FK_8ftxfgrrd86hv523r2njo10ek` (`sayuser_id`),
  CONSTRAINT `FK_53uroixicwfdfqdyhmsgbgddl` FOREIGN KEY (`father_id`) REFERENCES `t_comment` (`id`),
  CONSTRAINT `FK_73okwccwkkv4lps4ddmswks5l` FOREIGN KEY (`sayMood_id`) REFERENCES `t_saymood` (`id`),
  CONSTRAINT `FK_8ftxfgrrd86hv523r2njo10ek` FOREIGN KEY (`sayuser_id`) REFERENCES `t_user` (`id`),
  CONSTRAINT `FK_ewiban3bx8u7u6o5k7dhqxlwn` FOREIGN KEY (`comuser_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_comment
-- ----------------------------
INSERT INTO `t_comment` VALUES ('1', '真好看', '2017-03-06 21:39:15', '1', null, '1', '1');
INSERT INTO `t_comment` VALUES ('2', '好看啥', '2017-03-06 21:39:53', '1', '1', '1', '1');
INSERT INTO `t_comment` VALUES ('3', '就是好看', '2017-03-06 21:40:03', '1', '2', '1', '1');
INSERT INTO `t_comment` VALUES ('4', '自己恢复自己', '2017-03-06 21:51:02', '1', null, '13', '1');
INSERT INTO `t_comment` VALUES ('5', '我来了', '2017-03-06 21:51:09', '1', '4', '13', '1');
INSERT INTO `t_comment` VALUES ('6', '真好看', '2017-03-06 21:56:52', '3', null, '3', '1');
INSERT INTO `t_comment` VALUES ('7', '你做完做什么了啊', '2017-03-06 21:57:02', '3', null, '10', '1');
INSERT INTO `t_comment` VALUES ('8', '写代码了', '2017-03-06 21:57:16', '1', '7', '10', '3');
INSERT INTO `t_comment` VALUES ('9', '你的这个好漂亮', '2017-03-06 23:35:54', '3', null, '17', '5');
INSERT INTO `t_comment` VALUES ('10', '一般一般了', '2017-03-06 23:36:09', '5', '9', '17', '3');
INSERT INTO `t_comment` VALUES ('11', '真心不错', '2017-03-06 23:36:22', '3', '10', '17', '5');
INSERT INTO `t_comment` VALUES ('12', '好吧好吧再见了', '2017-03-06 23:36:34', '5', '11', '17', '3');

-- ----------------------------
-- Table structure for t_friend
-- ----------------------------
DROP TABLE IF EXISTS `t_friend`;
CREATE TABLE `t_friend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `beizhu` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `groups` int(11) NOT NULL,
  `isDelete` int(11) NOT NULL,
  `frienduser_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_39rrj2x2j68j8o826a9aym0sl` (`frienduser_id`),
  KEY `FK_4ynqy6bjqbgdqmuwpnw7fkfgc` (`user_id`),
  CONSTRAINT `FK_39rrj2x2j68j8o826a9aym0sl` FOREIGN KEY (`frienduser_id`) REFERENCES `t_user` (`id`),
  CONSTRAINT `FK_4ynqy6bjqbgdqmuwpnw7fkfgc` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_friend
-- ----------------------------
INSERT INTO `t_friend` VALUES ('1', null, '2017-03-06 21:52:10', '2', '2', '1', '3');
INSERT INTO `t_friend` VALUES ('2', null, '2017-03-06 23:07:22', '1', '1', '4', '1');
INSERT INTO `t_friend` VALUES ('3', null, '2017-03-06 23:09:29', '1', '2', '4', '1');
INSERT INTO `t_friend` VALUES ('4', null, '2017-03-06 23:32:13', '2', '2', '3', '5');
INSERT INTO `t_friend` VALUES ('5', null, '2017-03-06 23:32:21', '1', '2', '4', '5');
INSERT INTO `t_friend` VALUES ('6', null, '2017-03-06 23:32:34', '2', '2', '1', '5');