diff options
author | Andrei Karas <akaras@inbox.ru> | 2014-10-05 11:34:32 +0300 |
---|---|---|
committer | Andrei Karas <akaras@inbox.ru> | 2019-02-11 22:36:44 +0300 |
commit | 95f86d39a26edbcf52008ae76b87f950daa9978c (patch) | |
tree | f80ac4bd7e2ad991b8960dea59ee9aa1e47fa60a /sql-files/upgrades/2015-07-02--18-14.sql | |
parent | ade7959740ab029e717aef3f493bf1275dbf8477 (diff) | |
download | hercules-95f86d39a26edbcf52008ae76b87f950daa9978c.tar.gz hercules-95f86d39a26edbcf52008ae76b87f950daa9978c.tar.bz2 hercules-95f86d39a26edbcf52008ae76b87f950daa9978c.tar.xz hercules-95f86d39a26edbcf52008ae76b87f950daa9978c.zip |
Remove conf dir.
Diffstat (limited to 'sql-files/upgrades/2015-07-02--18-14.sql')
-rw-r--r-- | sql-files/upgrades/2015-07-02--18-14.sql | 74 |
1 files changed, 0 insertions, 74 deletions
diff --git a/sql-files/upgrades/2015-07-02--18-14.sql b/sql-files/upgrades/2015-07-02--18-14.sql deleted file mode 100644 index e4bbdc484..000000000 --- a/sql-files/upgrades/2015-07-02--18-14.sql +++ /dev/null @@ -1,74 +0,0 @@ -#1435860840 - --- This file is part of Hercules. --- http://herc.ws - http://github.com/HerculesWS/Hercules --- --- Copyright (C) 2015 Hercules Dev Team --- --- Hercules is free software: you can redistribute it and/or modify --- it under the terms of the GNU General Public License as published by --- the Free Software Foundation, either version 3 of the License, or --- (at your option) any later version. --- --- This program is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with this program. If not, see <http://www.gnu.org/licenses/>. - -DELIMITER $$ - -DROP PROCEDURE IF EXISTS alter_if_not_exists $$ -DROP PROCEDURE IF EXISTS alter_if_exists $$ - -CREATE PROCEDURE alter_if_not_exists(my_table TINYTEXT, my_column TINYTEXT, my_command TINYTEXT, my_predicate TEXT) -BEGIN - set @dbname = DATABASE(); - IF EXISTS ( - SELECT * FROM information_schema.TABLES - WHERE TABLE_SCHEMA = @dbname - AND TABLE_NAME = my_table - ) AND NOT EXISTS ( - SELECT * FROM information_schema.COLUMNS - WHERE TABLE_SCHEMA = @dbname - AND TABLE_NAME = my_table - AND COLUMN_NAME = my_column - ) - THEN - SET @q = CONCAT('ALTER TABLE ', @dbname, '.', my_table, ' ', - my_command, ' `', my_column, '` ', my_predicate); - PREPARE STMT FROM @q; - EXECUTE STMT; - END IF; - -END $$ - -CREATE PROCEDURE alter_if_exists(my_table TINYTEXT, my_column TINYTEXT, my_command TINYTEXT, my_predicate TEXT) -BEGIN - set @dbname = DATABASE(); - IF EXISTS ( - SELECT * FROM information_schema.COLUMNS - WHERE TABLE_SCHEMA = @dbname - AND TABLE_NAME = my_table - AND COLUMN_NAME = my_column - ) - THEN - SET @q = CONCAT('ALTER TABLE ', @dbname, '.', my_table, ' ', - my_command, ' `', my_column, '` ', my_predicate); - PREPARE STMT FROM @q; - EXECUTE STMT; - END IF; - -END $$ - -CALL alter_if_not_exists('item_db', 'forceserial', 'ADD COLUMN', 'TINYINT(1) UNSIGNED DEFAULT NULL AFTER `bindonequip`') $$ -CALL alter_if_not_exists('item_db2', 'forceserial', 'ADD COLUMN', 'TINYINT(1) UNSIGNED DEFAULT NULL AFTER `bindonequip`') $$ - -DROP PROCEDURE IF EXISTS alter_if_not_exists $$ -DROP PROCEDURE IF EXISTS alter_if_exists $$ - -DELIMITER ';' - -INSERT INTO `sql_updates` (`timestamp`) VALUES (1435860840); |