aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-naplo/update/pre002515-1-naplo.sql
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;