diff options
Diffstat (limited to 'mayor-orig/mayor-fenntarto/update')
-rw-r--r-- | mayor-orig/mayor-fenntarto/update/pre003980-1-mayor_fenntarto.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mayor-orig/mayor-fenntarto/update/pre003980-1-mayor_fenntarto.sql b/mayor-orig/mayor-fenntarto/update/pre003980-1-mayor_fenntarto.sql new file mode 100644 index 00000000..88ae258e --- /dev/null +++ b/mayor-orig/mayor-fenntarto/update/pre003980-1-mayor_fenntarto.sql @@ -0,0 +1,19 @@ +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 rpcKerelem ADD CONSTRAINT `nodeId_login` FOREIGN KEY (`nodeId`) REFERENCES `mayor_login`.`mayorKeychain` (`nodeId`) ON DELETE CASCADE ON UPDATE CASCADE; + +END $$ +DELIMITER ; +CALL upgrade_database_3980(); + + |