1. CREATE TABLE `eav_attribute` (
  2.  `attribute_id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Attribute Id',
  3.  `entity_type_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  4.  `attribute_code` VARCHAR(255) NOT NULL COMMENT 'Attribute Code',
  5.  `attribute_model` VARCHAR(255) DEFAULT NULL COMMENT 'Attribute Model',
  6.  `backend_model` VARCHAR(255) DEFAULT NULL COMMENT 'Backend Model',
  7.  `backend_type` VARCHAR(8) NOT NULL DEFAULT 'static' COMMENT 'Backend Type',
  8.  `backend_table` VARCHAR(255) DEFAULT NULL COMMENT 'Backend Table',
  9.  `frontend_model` VARCHAR(255) DEFAULT NULL COMMENT 'Frontend Model',
  10.  `frontend_input` VARCHAR(50) DEFAULT NULL COMMENT 'Frontend Input',
  11.  `frontend_input_renderer` VARCHAR(255) DEFAULT NULL,
  12.  `frontend_label` VARCHAR(255) DEFAULT NULL COMMENT 'Frontend Label',
  13.  `frontend_class` VARCHAR(255) DEFAULT NULL COMMENT 'Frontend Class',
  14.  `source_model` VARCHAR(255) DEFAULT NULL COMMENT 'Source Model',
  15.  `is_global` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  16.  `is_visible` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  17.  `is_required` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Defines Is Required',
  18.  `is_user_defined` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Defines Is User Defined',
  19.  `default_value` text COMMENT 'Default Value',
  20.  `is_searchable` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  21.  `is_filterable` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  22.  `is_comparable` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  23.  `is_visible_on_front` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  24.  `is_html_allowed_on_front` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  25.  `is_unique` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Defines Is Unique',
  26.  `is_used_for_price_rules` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  27.  `is_filterable_in_search` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  28.  `used_in_product_listing` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  29.  `used_for_sort_by` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  30.  `is_configurable` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  31.  `apply_to` VARCHAR(255) NOT NULL,
  32.  `position` INT(11) NOT NULL,
  33.  `note` VARCHAR(255) DEFAULT NULL COMMENT 'Note',
  34.  `is_visible_in_advanced_search` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  35.  PRIMARY KEY (`attribute_id`),
  36.  UNIQUE KEY `UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`),
  37.  KEY `IDX_USED_FOR_SORT_BY` (`entity_type_id`,`used_for_sort_by`),
  38.  KEY `IDX_USED_IN_PRODUCT_LISTING` (`entity_type_id`,`used_in_product_listing`),
  39.  KEY `IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID` (`entity_type_id`)
  40. ) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute'