diff options
Diffstat (limited to 'mayor-orig/update/pre002492-1-naplo.sql')
| -rw-r--r-- | mayor-orig/update/pre002492-1-naplo.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/mayor-orig/update/pre002492-1-naplo.sql b/mayor-orig/update/pre002492-1-naplo.sql deleted file mode 100644 index ebb8d121..00000000 --- a/mayor-orig/update/pre002492-1-naplo.sql +++ /dev/null @@ -1,13 +0,0 @@ -alter table `nap` add munkatervId tinyint unsigned default null; -CREATE TABLE `munkaterv` ( - `munkatervId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, - `munkatervNev` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL, - `tanitasiNap` smallint(6) DEFAULT NULL, - `vegzosZarasDt` date DEFAULT NULL, - `tanitasNelkuliMunkanap` smallint(6) DEFAULT NULL, - PRIMARY KEY (`munkatervId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; -alter table nap add foreign key IBFK_munkatervId (munkatervId) REFERENCES munkaterv (munkatervId) ON DELETE CASCADE ON UPDATE CASCADE ; -create table munkatervOsztaly (munkatervId tinyint not null, osztalyId int(10) unsigned not null, PRIMARY KEY (munkatervId,osztalyId)) ENGINE=InnoDB default CHARSET=utf8 COLLATE=utf8_hungarian_ci; -alter table munkatervOsztaly add foreign key IBFK_osztalyId (osztalyId) REFERENCES %INTEZMENYDB%.osztaly (osztalyId) ON DELETE CASCADE ON UPDATE CASCADE ; --- alter table munkatervOsztaly add foreign key IBFK_munkatervId (munkatervId) REFERENCES munkaterv (munkatervId) ON DELETE CASCADE ON UPDATE CASCADE ; |