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