INSERT INTO `shop_config` (`site_id`, `config_label`, `config_key`, `config_value`, `input_type`, `sort`) VALUES (1, 'Search View Filename', 'search_view_filename', 'search_default', 'text', 1);
ALTER TABLE `shop_routes` ADD IF NOT EXISTS `category_path_string` VARCHAR(255) NOT NULL AFTER `category_path`;
ALTER TABLE `shop_routes` DROP FOREIGN KEY `shop_routes_ibfk_1`;
ALTER TABLE `shop_routes` DROP KEY `site_id`;
ALTER TABLE `shop_routes` ADD UNIQUE KEY `url` (`url`);
ALTER TABLE `shop_routes` ADD CONSTRAINT `shop_routes_ibfk_1` FOREIGN KEY (`site_id`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `shop_layout_specific_data` ADD INDEX `data_name` (`data_name`);
ALTER TABLE `shop_layout_specific_data_values` ADD INDEX `data_value` (`data_value`(255));
