magento-2-add-category-seo-description-attribute-using-sql.sql

gistfile1.txt

INSERT INTO `eav_attribute` (`entity_type_id`, `attribute_code`, `attribute_model`, `backend_model`, `backend_type`, `backend_table`, `frontend_model`, `frontend_input`, `frontend_label`, `frontend_class`, `source_model`, `is_required`, `is_user_defined`, `default_value`, `is_unique`, `note`)
VALUES
	(3, 'description', NULL, NULL, 'text', NULL, NULL, 'textarea', 'Footer Description', NULL, NULL, 0, 0, NULL, 0, NULL);

INSERT INTO `catalog_eav_attribute` (`attribute_id`, `frontend_input_renderer`, `is_global`, `is_visible`, `is_searchable`, `is_filterable`, `is_comparable`, `is_visible_on_front`, `is_html_allowed_on_front`, `is_used_for_price_rules`, `is_filterable_in_search`, `used_in_product_listing`, `used_for_sort_by`, `apply_to`, `is_visible_in_advanced_search`, `position`, `is_wysiwyg_enabled`, `is_used_for_promo_rules`, `is_required_in_admin_store`, `is_used_in_grid`, `is_visible_in_grid`, `is_filterable_in_grid`, `search_weight`, `additional_data`, `is_visible_on_checkout`, `is_displayed_in_autocomplete`, `is_used_in_spellcheck`, `facet_min_coverage_rate`, `facet_max_size`, `facet_sort_order`, `display_pattern`, `display_precision`, `sort_order_asc_missing`, `sort_order_desc_missing`, `is_pagebuilder_enabled`)
VALUES
	(268, NULL, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, NULL, 0, 0, 1, 0, 0, 0, 0, 0, 1, NULL, 0, 0, 1, 90, 10, '_count', NULL, 0, '_last', '_first', 0);
  
INSERT INTO `eav_entity_attribute` (`entity_type_id`, `attribute_set_id`, `attribute_group_id`, `attribute_id`, `sort_order`)
VALUES
	(3, 3, 4, 268, 4);