blob: 39a27bec76abc59372ac166b6be47e7849d927bc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_3282 $$
CREATE PROCEDURE upgrade_database_3282()
BEGIN
IF NOT EXISTS (
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='mayor_naplo' and TABLE_NAME='osztalyJelleg' AND COLUMN_NAME='kovOsztalyJellegId'
) THEN
alter table osztalyJelleg add column `kovOsztalyJellegId` tinyint(3) unsigned DEFAULT NULL;
END IF;
update osztalyJelleg set kovOsztalyJellegId=3 where osztalyJellegId=10;
END $$
CALL upgrade_database_3282();
|
