diff options
| author | M.Gergo | 2024-09-29 04:30:59 +0200 |
|---|---|---|
| committer | M.Gergo | 2024-09-29 04:30:59 +0200 |
| commit | f55bad6878c678ce5aed406a5d2b31a6b3a523eb (patch) | |
| tree | 27e7421dd8a7b65f4a1af3bc0a7f1ae073d97e78 /mayor-orig/mayor-naplo/update/pre004856-1-naplo.sql | |
| parent | 3d2ab46cef4f29a500f9a125460bb2993613c67e (diff) | |
| parent | 8ba4eb09ddb764eaf01fabe30bdd49a202858d4d (diff) | |
| download | mayor-master.tar.gz mayor-master.zip | |
Diffstat (limited to 'mayor-orig/mayor-naplo/update/pre004856-1-naplo.sql')
| -rw-r--r-- | mayor-orig/mayor-naplo/update/pre004856-1-naplo.sql | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/mayor-orig/mayor-naplo/update/pre004856-1-naplo.sql b/mayor-orig/mayor-naplo/update/pre004856-1-naplo.sql new file mode 100644 index 00000000..20b244f6 --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004856-1-naplo.sql @@ -0,0 +1,48 @@ + +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_4856 $$ + +CREATE PROCEDURE upgrade_database_4856() +BEGIN +SET NAMES utf8 COLLATE utf8_hungarian_ci; + +DROP TABLE IF EXISTS felveteli_eredmeny; +CREATE TABLE `felveteli_eredmeny` ( + `nev` varchar(50) COLLATE utf8_hungarian_ci DEFAULT NULL, + `oId` bigint(20) NOT NULL, + `evfolyam` enum('4','5','6','8','') COLLATE utf8_hungarian_ci DEFAULT NULL, + `szulhely` varchar(255) CHARACTER SET utf8 DEFAULT NULL, + `szuldt` date DEFAULT NULL, + `an` varchar(50) CHARACTER SET utf8 DEFAULT NULL, + `lakcim_irsz` varchar(5) CHARACTER SET utf8 DEFAULT NULL, + `lakcim_telepules` varchar(40) CHARACTER SET utf8 DEFAULT NULL, + `lakcim_utcahazszam` varchar(128) CHARACTER SET utf8 DEFAULT NULL, + `ert_nev` varchar(50) COLLATE utf8_hungarian_ci DEFAULT NULL, + `ert_irsz` varchar(5) CHARACTER SET utf8 DEFAULT NULL, + `ert_telepules` varchar(40) CHARACTER SET utf8 DEFAULT NULL, + `ert_utcahazszam` varchar(128) CHARACTER SET utf8 DEFAULT NULL, + `allampolgarsag` varchar(40) CHARACTER SET utf8 DEFAULT 'magyar', + `email` varchar(128) CHARACTER SET utf8 DEFAULT NULL, + `omkod` varchar(6) CHARACTER SET utf8 DEFAULT NULL, + `isk_nev` varchar(128) CHARACTER SET utf8 DEFAULT NULL, + `isk_irsz` varchar(5) CHARACTER SET utf8 DEFAULT NULL, + `isk_telepules` varchar(40) CHARACTER SET utf8 DEFAULT NULL, + `isk_utcahazszam` varchar(128) CHARACTER SET utf8 DEFAULT NULL, + `isk_tel` varchar(32) CHARACTER SET utf8 DEFAULT NULL, + `isk_email` varchar(128) CHARACTER SET utf8 DEFAULT NULL, + `felvett` varchar(5) CHARACTER SET utf8 DEFAULT NULL, + `mashova` varchar(50) CHARACTER SET utf8 DEFAULT NULL, + `helyhiany` varchar(50) CHARACTER SET utf8 DEFAULT NULL, + `elutasitott` varchar(50) CHARACTER SET utf8 DEFAULT NULL, + `eredmenyId` int(10) unsigned NOT NULL AUTO_INCREMENT, + UNIQUE KEY `idx_eredmenyId` (`eredmenyId`), + PRIMARY KEY (`oId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; + +ALTER TABLE `felveteli` ADD COLUMN `szulhely` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL AFTER `omkod`; + + +END $$ +DELIMITER ; +CALL upgrade_database_4856(); + |