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'