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