aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-naplo/update/orev001530-1-naplo.sql
blob: a0e9e024d765b0d2f27411712fabd8b4f8f2958a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
alter table uzeno engine=InnoDB;
CREATE TABLE `uzenoFlagek` (
  `mId` int(10) unsigned NOT NULL,
  `Id` int(10) unsigned NOT NULL,
  `Tipus` enum('diak','szulo','tanar') default NULL,
  `flag` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`mId`,`Id`,`Tipus`),
  FOREIGN KEY(mId)
    REFERENCES uzeno(mId)
      ON DELETE CASCADE
      ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;