SQL to add a facet to Omeka Solr Search Plugin

insert-facet.sql

SET NAMES 'utf8' COLLATE 'utf8_unicode_ci';

SET @set_name     := 'Dublin Core';
SET @element_name := 'Coverage';
SET @label        := 'Greeting';
SET @facet        := 1;
SET @displayed    := 1;

INSERT INTO omeka_solr_search_facets
    (element_id, name, label, element_set_id, is_facet, is_displayed)
    SELECT e.id, CONCAT(e.id, '_s'), @label, es.id, @facet, @displayed
    FROM omeka_element_sets es, omeka_elements e
    WHERE es.name=@set_name AND e.name=@element_name AND es.id=e.element_set_id;