QNy1LuPW

1select entity_type_id from eav_entity_type WHERE entity_type_code = 'catalog_category';
2
3select attribute_id from eav_attribute WHERE entity_type_id = [value from above query] AND attribute_code = 'page_layout'; 
4     
5SELECT * FROM catalog_category_entity_varchar WHERE attribute_id = [value from attribute query]; 
6     
7INSERT into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) VALUES ([entity_type_id], [attribute_id], [store ID], [subcategory_id], '[layout name]'; 
8     
9RENAME TABLE `catalog_category_entity_varchar` TO `catalog_category_entity_varchar-old`;
10CREATE TABLE IF NOT EXISTS `catalog_category_entity_varchar` LIKE `catalog_category_entity_varchar-old`; 
11     
12INSERT `catalog_category_entity_varchar` SELECT * FROM `catalog_category_entity_varchar-old`; 
13     
14UPDATE catalog_category_entity_varchar 
15SET 
16    value = '1column'
17    WHERE
18    attribute_id = 61 &&
19    entity_id in (SELECT entity_id FROM catalog_category_entity WHERE level = 2)