Subversion Repositories bacoAlunos

Rev

Rev 1306 | Blame | Compare with Previous | Last modification | View Log | RSS feed


DROP TABLE IF EXISTS `courseunitsummary`;
CREATE TABLE `courseunitsummary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `discrimitator` varchar(255) NOT NULL,
  `updateDate` datetime NOT NULL,
  `saveDate` datetime DEFAULT NULL,
  `dataAula` datetime DEFAULT NULL,
  `tipoAula` varchar(255) DEFAULT NULL,
  `codigoAula` varchar(255) DEFAULT NULL,
  `codigoSumario` varchar(255) DEFAULT NULL,
  `codigoSalaAula` varchar(255) DEFAULT NULL,
  `alunosPresentes` int(11) DEFAULT NULL,
  `numeroAula` int(11) DEFAULT NULL,
  `titulo` varchar(255) DEFAULT NULL,
  `descricao` text,
  `cEstado` varchar(255) DEFAULT NULL,
  `courseUnit` bigint(20) DEFAULT NULL,
  PRIMARY KEY  (`id`),
  KEY `tituloIndex` (`titulo`),
  KEY `FK4B6262A7DF034EA4` (`courseUnit`),
  CONSTRAINT `FK4B6262A7DF034EA4` FOREIGN KEY (`courseUnit`) REFERENCES `courseunit` (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;