blob: 704b4782be9afa8e533c6549b9c1f89d2894dba2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_4250 $$
CREATE PROCEDURE upgrade_database_4250()
BEGIN
SET NAMES utf8 COLLATE utf8_hungarian_ci;
IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='hirnokFeliratkozas' AND COLUMN_NAME='hirnokFeliratkozasId') THEN
ALTER TABLE hirnokFeliratkozas ADD COLUMN `hirnokFeliratkozasId` int(11) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
END IF;
END $$
DELIMITER ;
CALL upgrade_database_4250();
|
