作业

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for userrole
-- ----------------------------
DROP TABLE IF EXISTS `userrole`;
CREATE TABLE `userrole` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_id` (`role_id`),
  CONSTRAINT `userrole_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `userrole_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userrole
-- ----------------------------
INSERT INTO `userrole` VALUES ('1', '1');
INSERT INTO `userrole` VALUES ('5', '1');
INSERT INTO `userrole` VALUES ('6', '1');
INSERT INTO `userrole` VALUES ('7', '1');
INSERT INTO `userrole` VALUES ('1', '2');
INSERT INTO `userrole` VALUES ('2', '2');
INSERT INTO `userrole` VALUES ('3', '2');
INSERT INTO `userrole` VALUES ('5', '2');
INSERT INTO `userrole` VALUES ('6', '2');
INSERT INTO `userrole` VALUES ('7', '2');
INSERT INTO `userrole` VALUES ('2', '3');
INSERT INTO `userrole` VALUES ('5', '3');
INSERT INTO `userrole` VALUES ('6', '3');
INSERT INTO `userrole` VALUES ('7', '3');