Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement