mayor-orig/mayor-naplo/update/pre003253-1-intezmeny.sql


1
2
3
4
5
6
7
8
9

CREATE TABLE `csengetesiRend` (
  `nap` tinyint(3) unsigned DEFAULT NULL,
  `ora` tinyint(3) unsigned NOT NULL,
  `tolTime` time DEFAULT NULL,
  `igTime` time DEFAULT NULL,
  `telephelyId` tinyint(3) unsigned DEFAULT NULL,
  KEY `csengetesiRend_telephely` (`telephelyId`),
  CONSTRAINT `csengetesiRend_telephely` FOREIGN KEY (`telephelyId`) REFERENCES `telephely` (`telephelyId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;