1-- 2-- Update Filters table to have a Concurrent Column 3-- 4 5SELECT 'Checking for Concurrent in Filters'; 6SET @s = (SELECT IF( 7 (SELECT COUNT(*) 8 FROM INFORMATION_SCHEMA.COLUMNS 9 WHERE table_name = 'Filters' 10 AND table_schema = DATABASE() 11 AND column_name = 'Concurrent' 12 ) > 0, 13"SELECT 'Column Concurrent already exists in Filters'", 14"ALTER TABLE Filters ADD COLUMN `Concurrent` tinyint(1) unsigned NOT NULL default '0' AFTER Background" 15)); 16 17PREPARE stmt FROM @s; 18EXECUTE stmt; 19