diff options
Diffstat (limited to 'mayor-orig/update/orev001587-2-intezmeny.sql')
| -rw-r--r-- | mayor-orig/update/orev001587-2-intezmeny.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mayor-orig/update/orev001587-2-intezmeny.sql b/mayor-orig/update/orev001587-2-intezmeny.sql new file mode 100644 index 00000000..aa4dabba --- /dev/null +++ b/mayor-orig/update/orev001587-2-intezmeny.sql @@ -0,0 +1,4 @@ +ALTER TABLE kepzesOraterv ADD kepzesId smallint unsigned not null AFTER kepzesOratervId; +ALTER TABLE kepzesOraterv ADD FOREIGN KEY(kepzesId) REFERENCES kepzes(kepzesId) ON DELETE CASCADE ON UPDATE CASCADE; +alter table kepzes ADD kezdoEvfolyam tinyint unsigned null; +alter table kepzes ADD zaroEvfolyam tinyint unsigned null; |