blob: aec9990541f33acced199ce3d3f49c2132aedca3 (
plain)
1
2
3
4
5
6
7
8
|
DROP TABLE IF EXISTS `hianyzasHozott`;
CREATE TABLE `hianyzasHozott` (
`diakId` int(10) unsigned NOT NULL,
`statusz` enum('igazolt','igazolatlan') COLLATE utf8_hungarian_ci DEFAULT NULL,
`dbHianyzas` tinyint(3) unsigned DEFAULT NULL,
`dt` date DEFAULT NULL,
CONSTRAINT `hianyzasHozott_IBFK1` FOREIGN KEY (`diakId`) REFERENCES `%INTEZMENYDB%`.`diak` (`diakId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
|
