-- Структура таблицы `avtor`
--
 
CREATE TABLE IF NOT EXISTS `avtor` (
  `TeachId` int(11) NOT NULL AUTO_INCREMENT,
  `Login` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`TeachId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;
 
 
--
-- Структура таблицы `opros`
--
 
CREATE TABLE IF NOT EXISTS `opros` (
  `TestId` int(11) NOT NULL AUTO_INCREMENT,
  `TeachId` int(11) DEFAULT NULL,
  `TestName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `GroupName` int(11) NOT NULL,
  PRIMARY KEY (`TestId`),
  KEY `TeachId` (`TeachId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
 
--
-- Структура таблицы `qwestions`
--
 
CREATE TABLE IF NOT EXISTS `qwestions` (
  `QwestionsId` int(11) NOT NULL AUTO_INCREMENT,
  `TeachId` int(11) DEFAULT NULL,
  `TestId` int(11) DEFAULT NULL,
  `Text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`QwestionsId`),
  KEY `TestId` (`TestId`),
  KEY `TeachId` (`TeachId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
 
-- --------------------------------------------------------
 
--
-- Ограничения внешнего ключа таблицы `opros`
--
ALTER TABLE `opros`
  ADD CONSTRAINT `opros_ibfk_1` FOREIGN KEY (`TeachId`) REFERENCES `avtor` (`TeachId`);
 
--
-- Ограничения внешнего ключа таблицы `qwestions`
--
ALTER TABLE `qwestions`
  ADD CONSTRAINT `qwestions_ibfk_1` FOREIGN KEY (`TestId`) REFERENCES `opros` (`TestId`),
  ADD CONSTRAINT `qwestions_ibfk_2` FOREIGN KEY (`TeachId`) REFERENCES `opros` (`TeachId`) ON DELETE CASCADE ON UPDATE CASCADE;