Eye/scripts/updates/2-4-11/filter-uprades.sql

ALTER TABLE `Group_filters` ADD `action` BOOLEAN NOT NULL DEFAULT FALSE AFTER `order`;
UPDATE `Group_filters` as G set action = (SELECT action FROM Filter_list WHERE G.filter_id = id);
ALTER TABLE `Filter_list` DROP `action`;
DELETE FROM Group_filters WHERE filter_id NOT IN (SELECT id FROM Filter_list);
DELETE FROM Group_filters WHERE group_id NOT IN (SELECT id FROM Group_list);