Skip to content

Instantly share code, notes, and snippets.

@bserem

bserem/drupal8_menu_item_clone.sql

Created April 27, 2018 10:34
Show Gist options
  • Save bserem/4b598d52d9ce001cabe0976aba5610f8 to your computer and use it in GitHub Desktop.
Save bserem/4b598d52d9ce001cabe0976aba5610f8 to your computer and use it in GitHub Desktop.
Download ZIP
Clone Drupal 8 menu items to another menu and change their language code.
Raw
drupal8_menu_item_clone.sql
INSERT INTO menu_link_content_data
(
id,
bundle,
langcode,
title,
description,
menu_name,
link__uri,
link__title,
link__options,
external,
rediscover,
weight,
expanded,
enabled,
parent,
changed,
default_langcode,
content_translation_source,
content_translation_outdated,
content_translation_uid,
content_translation_status,
content_translation_created
)
SELECT
id,
bundle,
"__NEW_LANGUAGE_RECORD__",
title,
description,
"__TARGET_MENU_MACHINE_NAME__",
link__uri,
link__title,
link__options,
external,
rediscover,
weight,
expanded,
enabled,
parent,
changed,
default_langcode,
content_translation_source,
content_translation_outdated,
content_translation_uid,
content_translation_status,
content_translation_created
FROM menu_link_content_data
WHERE menu_name = "__SOURCE_MENU_MACHINE_NAME__";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment