CREATE TABLE `eav_attribute` (
 `attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Id',
 `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
 `attribute_code` varchar(255) NOT NULL COMMENT 'Attribute Code',
 `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
 `backend_model` varchar(255) DEFAULT NULL COMMENT 'Backend Model',
 `backend_type` varchar(8) NOT NULL DEFAULT 'static' COMMENT 'Backend Type',
 `backend_table` varchar(255) DEFAULT NULL COMMENT 'Backend Table',
 `frontend_model` varchar(255) DEFAULT NULL COMMENT 'Frontend Model',
 `frontend_input` varchar(50) DEFAULT NULL COMMENT 'Frontend Input',
 `frontend_input_renderer` varchar(255) DEFAULT NULL,
 `frontend_label` varchar(255) DEFAULT NULL COMMENT 'Frontend Label',
 `frontend_class` varchar(255) DEFAULT NULL COMMENT 'Frontend Class',
 `source_model` varchar(255) DEFAULT NULL COMMENT 'Source Model',
 `is_global` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `is_visible` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `is_required` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Required',
 `is_user_defined` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is User Defined',
 `default_value` text COMMENT 'Default Value',
 `is_searchable` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_filterable` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_comparable` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_visible_on_front` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_html_allowed_on_front` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_unique` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Unique',
 `is_used_for_price_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_filterable_in_search` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `used_in_product_listing` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `used_for_sort_by` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_configurable` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `apply_to` varchar(255) NOT NULL,
 `position` int(11) NOT NULL,
 `note` varchar(255) DEFAULT NULL COMMENT 'Note',
 `is_visible_in_advanced_search` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`attribute_id`),
 UNIQUE KEY `UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`),
 KEY `IDX_USED_FOR_SORT_BY` (`entity_type_id`,`used_for_sort_by`),
 KEY `IDX_USED_IN_PRODUCT_LISTING` (`entity_type_id`,`used_in_product_listing`),
 KEY `IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID` (`entity_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute'