diff options
Diffstat (limited to 'mayor-orig/update/pre003980-1-mayor_naplo.sql')
-rw-r--r-- | mayor-orig/update/pre003980-1-mayor_naplo.sql | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/mayor-orig/update/pre003980-1-mayor_naplo.sql b/mayor-orig/update/pre003980-1-mayor_naplo.sql deleted file mode 100644 index 7e0a8d2f..00000000 --- a/mayor-orig/update/pre003980-1-mayor_naplo.sql +++ /dev/null @@ -1,20 +0,0 @@ -DELIMITER $$ -DROP PROCEDURE IF EXISTS upgrade_database_3980 $$ -CREATE PROCEDURE upgrade_database_3980() -BEGIN - -SET NAMES utf8 COLLATE utf8_hungarian_ci; - --- IF EXISTS ( --- SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='osztalyJelleg' AND COLUMN_NAME='erettsegizo' --- ) THEN --- END IF; - -ALTER TABLE rpcJogosultsag ADD CONSTRAINT `nodeId_login` FOREIGN KEY (`nodeId`) REFERENCES `mayor_login`.`mayorKeychain` (`nodeId`) ON DELETE CASCADE ON UPDATE CASCADE; - - -END $$ -DELIMITER ; -CALL upgrade_database_3980(); - - |