aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre003761-1-intezmeny.sql
blob: 8cfc7f95f30ed9e396dd585d06ef5e46b22862c2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_3761 $$
CREATE PROCEDURE upgrade_database_3761()
BEGIN
IF NOT EXISTS (
    SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='tovabbkepzesKeret'
) THEN
    CREATE TABLE `tovabbkepzesKeret` (naptariEv YEAR NOT NULL PRIMARY KEY, keretOsszeg int unsigned not null);
END IF;

END $$
DELIMITER ; $$
CALL upgrade_database_3761();