aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre003893-1-intezmeny.sql
blob: 74867a9437406158e1bd74c263e5b5ae6e330a76 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_3893 $$
CREATE PROCEDURE upgrade_database_3893()
BEGIN
IF NOT EXISTS (
    SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='tovabbkepzesTanulmanyiEgyseg' AND COLUMN_NAME='tavollet'
) THEN
ALTER TABLE tovabbkepzesTanulmanyiEgyseg ADD tavollet varchar(255) NOT NULL DEFAULT '';
END IF;
IF NOT EXISTS (
    SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='tovabbkepzesTanulmanyiEgyseg' AND COLUMN_NAME='helyettesitesRendje'
) THEN
ALTER TABLE tovabbkepzesTanulmanyiEgyseg ADD helyettesitesRendje varchar(255) NOT NULL DEFAULT '';
END IF;
IF NOT EXISTS (
    SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='tovabbkepzesTanulmanyiEgyseg' AND COLUMN_NAME='prioritas'
) THEN
ALTER TABLE tovabbkepzesTanulmanyiEgyseg ADD prioritas varchar(255) NOT NULL DEFAULT '';
END IF;
IF EXISTS (
    SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='tovabbkepzesTanulmanyiEgyseg' AND COLUMN_NAME='megjegyzes'
) THEN
IF EXISTS (
    SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='tovabbkepzesTanulmanyiEgyseg' AND COLUMN_NAME='tavollet'
) THEN
    UPDATE tovabbkepzesTanulmanyiEgyseg SET tavollet=megjegyzes;
    ALTER TABLE  tovabbkepzesTanulmanyiEgyseg  DROP megjegyzes;
END IF;
END IF;
END $$
DELIMITER ; $$
CALL upgrade_database_3893();