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;