aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre003253-1-intezmeny.sql
blob: 7298ae07a12e95d8ea0fc2200f6d75b6e64a27e0 (plain)
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;