aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre002492-1-naplo.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update/pre002492-1-naplo.sql')
-rw-r--r--mayor-orig/update/pre002492-1-naplo.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/mayor-orig/update/pre002492-1-naplo.sql b/mayor-orig/update/pre002492-1-naplo.sql
new file mode 100644
index 00000000..ebb8d121
--- /dev/null
+++ b/mayor-orig/update/pre002492-1-naplo.sql
@@ -0,0 +1,13 @@
+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 ;