ALTER TABLE `pages` ADD IF NOT EXISTS `allow_url_segments` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `searchable`;
ALTER TABLE `pages` ADD IF NOT EXISTS `allow_url_query` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `allow_url_segments`;
UPDATE `pages` SET `allow_url_segments`=1 WHERE `content_type_id` IN(16,19,20,21) OR `url`="shop";
UPDATE `pages` SET `allow_url_query`=1 WHERE `content_type_id` IN(12,13,15,16,19,21,22,23,24) OR `url`="shop";
