aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-naplo/update/pre003391-1-intezmeny.sql
blob: 8009279456d66c2b23b10df3b2bee5d0148be4ca (plain)
1
2
3
4
5
6
7
8
9
10
11
DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_3391 $$
CREATE PROCEDURE upgrade_database_3391()
BEGIN
IF NOT EXISTS (
    SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='tankorDiakFelmentes' AND COLUMN_NAME='iktatoszam'
) THEN
    ALTER TABLE tankorDiakFelmentes ADD iktatoszam VARCHAR(60) not null default '';
END IF;
END $$
CALL upgrade_database_3391();