(82,'/cmf/snippets/footer/footer','/cmf/snippets/footer','footer','','default','07e1641d-f727-4178-a949-eab0c14f44c0','nt:unstructured','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"jcr:primaryType\" sv:type=\"Name\" sv:multi-valued=\"0\"><sv:value length=\"15\">nt:unstructured</sv:value></sv:property><sv:property sv:name=\"jcr:mixinTypes\" sv:type=\"Name\" sv:multi-valued=\"1\"><sv:value length=\"12\">sulu:snippet</sv:value></sv:property><sv:property sv:name=\"jcr:uuid\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">07e1641d-f727-4178-a949-eab0c14f44c0</sv:value></sv:property><sv:property sv:name=\"i18n:de-title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">Footer</sv:value></sv:property><sv:property sv:name=\"template\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">footer</sv:value></sv:property><sv:property sv:name=\"i18n:de-state\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-creator\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-changer\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-created\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2023-10-10T07:29:44.836+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:de-changed\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2023-10-13T09:23:12.187+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:de-published\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2023-10-10T07:29:44.877+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-description\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-keywords\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-canonicalUrl\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-noIndex\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-noFollow\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-hideInSitemap\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:de-excerpt-description\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-excerpt-categories\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:de-excerpt-tags\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:de-excerpt-icon\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"10\">{\"ids\":[]}</sv:value></sv:property><sv:property sv:name=\"i18n:de-excerpt-images\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"10\">{\"ids\":[]}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"8\">Treuhand</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_text#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"8\">Facebook</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_link#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"140\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/www.facebook.com\\/\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_text#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"9\">Instagram</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_link#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"141\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/www.instagram.com\\/\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_text#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"8\">Linkedin</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_link#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"176\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/www.linkedin.com\\/company\\/vitras-treuhand-ag\\/about\\/\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">4</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"7\">Steuern</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"ee00bd2c-e8b4-42b5-bfe1-cfa3248fbfc2\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"11\">Outsourcing</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"68c171a5-a15b-4d18-9094-ff7d5e967df0\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"19\">Business Protection</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"7ef3dfba-fe16-4406-ae1d-d688366cf691\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"11\">Unternehmen</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"b75138b7-7e1e-4484-9519-4cddfa335040\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_text#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"7\">Kontakt</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_link#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"95280904-9961-4e87-a886-278ded92198a\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_text#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"4\">Blog</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_link#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"4de61500-4ba8-4646-ae6a-4d7b424548bc\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"4\">Mehr</sv:value></sv:property><sv:property sv:name=\"i18n:de-third_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"14\">Sociale Medien</sv:value></sv:property><sv:property sv:name=\"i18n:de-form_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"51\">Abonnieren Sie, um die neuesten Updates zu erhalten</sv:value></sv:property><sv:property sv:name=\"i18n:de-sign_in_form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property></sv:node>\n','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"i18n:de-state\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-creator\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-changer\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">4</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-sign_in_form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property></sv:node>\n',4,1),(83,'/cmf/snippets/footer','/cmf/snippets','footer','','default_live','e6cb6393-46e1-46d7-b9d0-e623e8883f1b','nt:unstructured','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"jcr:primaryType\" sv:type=\"Name\" sv:multi-valued=\"0\"><sv:value length=\"15\">nt:unstructured</sv:value></sv:property><sv:property sv:name=\"jcr:mixinTypes\" sv:type=\"Name\" sv:multi-valued=\"1\"><sv:value length=\"17\">mix:referenceable</sv:value></sv:property><sv:property sv:name=\"jcr:uuid\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">e6cb6393-46e1-46d7-b9d0-e623e8883f1b</sv:value></sv:property></sv:node>\n',NULL,3,2),(84,'/cmf/snippets/footer/footer','/cmf/snippets/footer','footer','','default_live','07e1641d-f727-4178-a949-eab0c14f44c0','nt:unstructured','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"jcr:primaryType\" sv:type=\"Name\" sv:multi-valued=\"0\"><sv:value length=\"15\">nt:unstructured</sv:value></sv:property><sv:property sv:name=\"jcr:mixinTypes\" sv:type=\"Name\" sv:multi-valued=\"1\"><sv:value length=\"17\">mix:referenceable</sv:value><sv:value length=\"12\">sulu:snippet</sv:value></sv:property><sv:property sv:name=\"jcr:uuid\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">07e1641d-f727-4178-a949-eab0c14f44c0</sv:value></sv:property><sv:property sv:name=\"i18n:de-title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">Footer</sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-description\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-keywords\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-canonicalUrl\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-noIndex\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-noFollow\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:de-seo-hideInSitemap\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:de-excerpt-description\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:de-excerpt-categories\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:de-excerpt-tags\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:de-excerpt-icon\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"10\">{\"ids\":[]}</sv:value></sv:property><sv:property sv:name=\"i18n:de-excerpt-images\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"10\">{\"ids\":[]}</sv:value></sv:property><sv:property sv:name=\"template\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">footer</sv:value></sv:property><sv:property sv:name=\"i18n:de-state\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-published\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2023-10-10T07:29:44.877+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:de-creator\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-changer\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-created\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2023-10-10T07:29:44.836+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:de-changed\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2023-10-13T09:23:12.187+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"8\">Treuhand</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_text#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"8\">Facebook</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_link#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"140\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/www.facebook.com\\/\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_text#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"9\">Instagram</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_link#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"141\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/www.instagram.com\\/\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_text#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"8\">Linkedin</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-links_link#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"176\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/www.linkedin.com\\/company\\/vitras-treuhand-ag\\/about\\/\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">4</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"7\">Steuern</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"ee00bd2c-e8b4-42b5-bfe1-cfa3248fbfc2\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"11\">Outsourcing</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"68c171a5-a15b-4d18-9094-ff7d5e967df0\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"19\">Business Protection</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"7ef3dfba-fe16-4406-ae1d-d688366cf691\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-type#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-settings#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_text#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"11\">Unternehmen</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-links_link#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"b75138b7-7e1e-4484-9519-4cddfa335040\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_text#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"7\">Kontakt</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_link#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"95280904-9961-4e87-a886-278ded92198a\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">links_editor</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_text#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"4\">Blog</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-links_link#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"4de61500-4ba8-4646-ae6a-4d7b424548bc\",\"title\":null,\"rel\":null,\"locale\":\"de\"}</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"4\">Mehr</sv:value></sv:property><sv:property sv:name=\"i18n:de-third_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"14\">Sociale Medien</sv:value></sv:property><sv:property sv:name=\"i18n:de-form_title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"51\">Abonnieren Sie, um die neuesten Updates zu erhalten</sv:value></sv:property><sv:property sv:name=\"i18n:de-sign_in_form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property></sv:node>\n','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"i18n:de-state\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-creator\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-changer\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:de-social_media_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-first_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">4</sv:value></sv:property><sv:property sv:name=\"i18n:de-second_links_block-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:de-sign_in_form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:de-form\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property></sv:node>\n',4,2);

--
-- Table structure for table `phpcr_nodes_references`
--

CREATE TABLE `phpcr_nodes_references` (
  `source_id` int NOT NULL,
  `source_property_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` int NOT NULL,
  PRIMARY KEY (`source_id`,`source_property_name`,`target_id`),
  KEY `IDX_F3BF7E1158E0B66` (`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpcr_nodes_references`
--

INSERT INTO `phpcr_nodes_references` VALUES (7,'sulu:content',5),(12,'sulu:content',10),(39,'sulu:content',37),(47,'sulu:content',37),(43,'sulu:content',41),(48,'sulu:content',41),(50,'sulu:content',49),(52,'sulu:content',51),(54,'sulu:content',53),(56,'sulu:content',55),(58,'sulu:content',57),(60,'sulu:content',59),(62,'sulu:content',61),(64,'sulu:content',63),(66,'sulu:content',65),(68,'sulu:content',67),(70,'sulu:content',69),(72,'sulu:content',71),(74,'sulu:content',73),(76,'sulu:content',75),(78,'sulu:content',77),(80,'sulu:content',79),(37,'i18n:de-snippets',82),(49,'i18n:de-snippets',82),(53,'i18n:de-snippets',82),(57,'i18n:de-snippets',82),(61,'i18n:de-snippets',82),(65,'i18n:de-snippets',82),(69,'i18n:de-snippets',82),(73,'i18n:de-snippets',82),(77,'i18n:de-snippets',82),(41,'i18n:de-snippets',84),(51,'i18n:de-snippets',84),(55,'i18n:de-snippets',84),(59,'i18n:de-snippets',84),(63,'i18n:de-snippets',84),(67,'i18n:de-snippets',84),(71,'i18n:de-snippets',84),(75,'i18n:de-snippets',84),(79,'i18n:de-snippets',84);

--
-- Table structure for table `phpcr_nodes_weakreferences`
--

CREATE TABLE `phpcr_nodes_weakreferences` (
  `source_id` int NOT NULL,
  `source_property_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` int NOT NULL,
  PRIMARY KEY (`source_id`,`source_property_name`,`target_id`),
  KEY `IDX_F0E4F6FA158E0B66` (`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpcr_nodes_weakreferences`
--


--
-- Table structure for table `phpcr_type_childs`
--

CREATE TABLE `phpcr_type_childs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `node_type_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `protected` tinyint(1) NOT NULL,
  `auto_created` tinyint(1) NOT NULL,
  `mandatory` tinyint(1) NOT NULL,
  `on_parent_version` int NOT NULL,
  `primary_types` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpcr_type_childs`
--

INSERT INTO `phpcr_type_childs` VALUES (1,10,'*',0,0,0,1,'phpcrmig:version',NULL);

--
-- Table structure for table `phpcr_type_nodes`
--

CREATE TABLE `phpcr_type_nodes` (
  `node_type_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `supertypes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_abstract` tinyint(1) NOT NULL,
  `is_mixin` tinyint(1) NOT NULL,
  `queryable` tinyint(1) NOT NULL,
  `orderable_child_nodes` tinyint(1) NOT NULL,
  `primary_item` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`node_type_id`),
  UNIQUE KEY `UNIQ_34B0A8095E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpcr_type_nodes`
--

INSERT INTO `phpcr_type_nodes` VALUES (1,'sulu:base','mix:referenceable',1,1,0,0,NULL),(2,'sulu:path','sulu:base',0,1,0,0,NULL),(3,'sulu:content','sulu:base',0,1,0,0,NULL),(4,'sulu:snippet','sulu:content',0,1,0,0,NULL),(5,'sulu:page','sulu:content',0,1,0,0,NULL),(6,'sulu:home','sulu:content',0,1,0,0,NULL),(7,'sulu:custom_url','sulu:base',0,1,0,0,NULL),(8,'sulu:custom_url_route','sulu:base',0,1,0,0,NULL),(9,'phpcrmig:version','nt:base mix:created',0,0,1,0,NULL),(10,'phpcrmig:versions','nt:base',0,0,1,0,NULL);

--
-- Table structure for table `phpcr_type_props`
--

CREATE TABLE `phpcr_type_props` (
  `node_type_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `protected` tinyint(1) NOT NULL,
  `auto_created` tinyint(1) NOT NULL,
  `mandatory` tinyint(1) NOT NULL,
  `on_parent_version` int NOT NULL,
  `multiple` tinyint(1) NOT NULL,
  `fulltext_searchable` tinyint(1) NOT NULL,
  `query_orderable` tinyint(1) NOT NULL,
  `required_type` int NOT NULL,
  `query_operators` int NOT NULL,
  `default_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`node_type_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpcr_type_props`
--

INSERT INTO `phpcr_type_props` VALUES (2,'sulu:content',0,0,1,1,0,0,0,9,0,NULL),(2,'sulu:history',0,1,1,1,0,0,0,6,0,'');

--
-- Table structure for table `phpcr_workspaces`
--

CREATE TABLE `phpcr_workspaces` (
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpcr_workspaces`
--

INSERT INTO `phpcr_workspaces` VALUES ('default'),('default_live');

--
-- Table structure for table `ro_routes`
--

CREATE TABLE `ro_routes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `target_id` int DEFAULT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity_class` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `history` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `changed` datetime NOT NULL,
  `idUsersCreator` int DEFAULT NULL,
  `idUsersChanger` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_671DB7A4B548B0F4180C698` (`path`,`locale`),
  KEY `IDX_671DB7A4158E0B66` (`target_id`),
  KEY `IDX_671DB7A4DBF11E1D` (`idUsersCreator`),
  KEY `IDX_671DB7A430D07CD5` (`idUsersChanger`),
  KEY `IDX_671DB7A4B548B0F` (`path`),
  KEY `IDX_671DB7A44180C698` (`locale`),
  KEY `idx_resource` (`entity_id`,`entity_class`),
  KEY `idx_history` (`history`),
  CONSTRAINT `FK_671DB7A4158E0B66` FOREIGN KEY (`target_id`) REFERENCES `ro_routes` (`id`),
  CONSTRAINT `FK_671DB7A430D07CD5` FOREIGN KEY (`idUsersChanger`) REFERENCES `se_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_671DB7A4DBF11E1D` FOREIGN KEY (`idUsersCreator`) REFERENCES `se_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ro_routes`
--


--
-- Table structure for table `se_access_controls`
--

CREATE TABLE `se_access_controls` (
  `id` int NOT NULL AUTO_INCREMENT,
  `permissions` smallint NOT NULL,
  `entityId` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entityClass` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entityIdInteger` int DEFAULT NULL,
  `idRoles` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C526DC52A1FA6DDA` (`idRoles`),
  KEY `IDX_C526DC52F62829FC` (`entityId`),
  KEY `IDX_C526DC523963FFAB` (`entityClass`),
  KEY `IDX_C526DC524473BB7A` (`entityIdInteger`),
  CONSTRAINT `FK_C526DC52A1FA6DDA` FOREIGN KEY (`idRoles`) REFERENCES `se_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_access_controls`
--


--
-- Table structure for table `se_group_roles`
--

CREATE TABLE `se_group_roles` (
  `idGroups` int NOT NULL,
  `idRoles` int NOT NULL,
  PRIMARY KEY (`idGroups`,`idRoles`),
  KEY `IDX_9713F725937C91EA` (`idGroups`),
  KEY `IDX_9713F725A1FA6DDA` (`idRoles`),
  CONSTRAINT `FK_9713F725937C91EA` FOREIGN KEY (`idGroups`) REFERENCES `se_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_9713F725A1FA6DDA` FOREIGN KEY (`idRoles`) REFERENCES `se_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_group_roles`
--


--
-- Table structure for table `se_groups`
--

CREATE TABLE `se_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lft` int NOT NULL,
  `rgt` int NOT NULL,
  `depth` int NOT NULL,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `changed` datetime NOT NULL,
  `idGroupsParent` int DEFAULT NULL,
  `idUsersCreator` int DEFAULT NULL,
  `idUsersChanger` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_231E44ECBF274AB0` (`idGroupsParent`),
  KEY `IDX_231E44ECDBF11E1D` (`idUsersCreator`),
  KEY `IDX_231E44EC30D07CD5` (`idUsersChanger`),
  CONSTRAINT `FK_231E44EC30D07CD5` FOREIGN KEY (`idUsersChanger`) REFERENCES `se_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_231E44ECBF274AB0` FOREIGN KEY (`idGroupsParent`) REFERENCES `se_groups` (`id`),
  CONSTRAINT `FK_231E44ECDBF11E1D` FOREIGN KEY (`idUsersCreator`) REFERENCES `se_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_groups`
--


--
-- Table structure for table `se_permissions`
--

CREATE TABLE `se_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `context` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` smallint NOT NULL,
  `idRoles` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5CEC3EEAE25D857EC242628A1FA6DDA` (`context`,`module`,`idRoles`),
  KEY `IDX_5CEC3EEAA1FA6DDA` (`idRoles`),
  CONSTRAINT `FK_5CEC3EEAA1FA6DDA` FOREIGN KEY (`idRoles`) REFERENCES `se_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_permissions`
--

INSERT INTO `se_permissions` VALUES (1,'sulu.contact.people',NULL,127,1),(2,'sulu.contact.organizations',NULL,127,1),(3,'sulu.media.collections',NULL,127,1),(4,'sulu.media.system_collections',NULL,127,1),(5,'sulu.settings.categories',NULL,127,1),(6,'sulu.settings.tags',NULL,127,1),(7,'sulu.global.snippets',NULL,127,1),(8,'sulu.webspaces.example.default-snippets',NULL,0,1),(9,'sulu.webspaces.example',NULL,0,1),(10,'sulu.webspaces.example.analytics',NULL,0,1),(11,'sulu.webspaces.example.custom-urls',NULL,0,1),(12,'sulu.activities.activities',NULL,127,1),(13,'sulu.trash.trash',NULL,127,1),(14,'sulu.security.roles',NULL,127,1),(15,'sulu.security.users',NULL,127,1),(16,'sulu.webspaces.vitras',NULL,123,1),(17,'sulu.webspaces.vitras.analytics',NULL,120,1),(18,'sulu.webspaces.vitras.custom-urls',NULL,120,1),(19,'sulu.webspaces.vitras.default-snippets',NULL,80,1),(20,'sulu.form.forms',NULL,120,1);

--
-- Table structure for table `se_role_settings`
--

CREATE TABLE `se_role_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `settingKey` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` json NOT NULL,
  `roleId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_DAD1C8CB3AA9950BB8C2FD88` (`settingKey`,`roleId`),
  KEY `IDX_DAD1C8CBB8C2FD88` (`roleId`),
  KEY `IDX_DAD1C8CB3AA9950B` (`settingKey`),
  CONSTRAINT `FK_DAD1C8CBB8C2FD88` FOREIGN KEY (`roleId`) REFERENCES `se_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_role_settings`
--


--
-- Table structure for table `se_roles`
--

CREATE TABLE `se_roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_key` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `securitySystem` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `changed` datetime NOT NULL,
  `idSecurityTypes` int DEFAULT NULL,
  `idUsersCreator` int DEFAULT NULL,
  `idUsersChanger` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_13B749A05E237E06` (`name`),
  UNIQUE KEY `UNIQ_13B749A03EF22FDB` (`role_key`),
  KEY `IDX_13B749A0D02106C0` (`idSecurityTypes`),
  KEY `IDX_13B749A0DBF11E1D` (`idUsersCreator`),
  KEY `IDX_13B749A030D07CD5` (`idUsersChanger`),
  CONSTRAINT `FK_13B749A030D07CD5` FOREIGN KEY (`idUsersChanger`) REFERENCES `se_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_13B749A0D02106C0` FOREIGN KEY (`idSecurityTypes`) REFERENCES `se_security_types` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_13B749A0DBF11E1D` FOREIGN KEY (`idUsersCreator`) REFERENCES `se_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_roles`
--

INSERT INTO `se_roles` VALUES (1,'User',NULL,'Sulu',0,'2023-10-03 10:38:22','2023-10-03 10:38:22',NULL,NULL,NULL),(2,'Visitor',NULL,'Sulu',0,'2023-10-13 09:44:07','2023-10-13 09:44:07',NULL,1,1);

--
-- Table structure for table `se_security_types`
--

CREATE TABLE `se_security_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_security_types`
--


--
-- Table structure for table `se_user_groups`
--

CREATE TABLE `se_user_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `locale` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `idGroups` int DEFAULT NULL,
  `idUsers` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E43ED0C8937C91EA` (`idGroups`),
  KEY `IDX_E43ED0C8347E6F4` (`idUsers`),
  CONSTRAINT `FK_E43ED0C8347E6F4` FOREIGN KEY (`idUsers`) REFERENCES `se_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E43ED0C8937C91EA` FOREIGN KEY (`idGroups`) REFERENCES `se_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_user_groups`
--


--
-- Table structure for table `se_user_roles`
--

CREATE TABLE `se_user_roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `locale` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `idUsers` int DEFAULT NULL,
  `idRoles` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E48BD9DB347E6F4` (`idUsers`),
  KEY `IDX_E48BD9DBA1FA6DDA` (`idRoles`),
  CONSTRAINT `FK_E48BD9DB347E6F4` FOREIGN KEY (`idUsers`) REFERENCES `se_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E48BD9DBA1FA6DDA` FOREIGN KEY (`idRoles`) REFERENCES `se_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_user_roles`
--

INSERT INTO `se_user_roles` VALUES (1,'[\"en\",\"de\"]',1,1);

--
-- Table structure for table `se_user_settings`
--

CREATE TABLE `se_user_settings` (
  `settingsValue` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `settingsKey` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idUsers` int NOT NULL,
  PRIMARY KEY (`settingsKey`,`idUsers`),
  KEY `IDX_108FCAFA347E6F4` (`idUsers`),
  CONSTRAINT `FK_108FCAFA347E6F4` FOREIGN KEY (`idUsers`) REFERENCES `se_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_user_settings`
--

INSERT INTO `se_user_settings` VALUES ('\"de\"','sulu_admin.content_locale',1),('[]','sulu_admin.list_store.account_contacts.list.filter',1),('[]','sulu_admin.list_store.accounts.list.filter',1),('[]','sulu_admin.list_store.activities.list.filter',1),('\"a2071e02-5d37-4f3f-b4f1-9d6ecd6d3ff0\"','sulu_admin.list_store.analytics.list.active',1),('[]','sulu_admin.list_store.analytics.list.filter',1),('[]','sulu_admin.list_store.categories.list.filter',1),('\"title\"','sulu_admin.list_store.collections.media_overview.sort_column',1),('\"asc\"','sulu_admin.list_store.collections.media_overview.sort_order',1),('7','sulu_admin.list_store.collections.single_list_overlay.active',1),('[]','sulu_admin.list_store.contacts.list.filter',1),('\"a2071e02-5d37-4f3f-b4f1-9d6ecd6d3ff0\"','sulu_admin.list_store.custom_urls.list.active',1),('[]','sulu_admin.list_store.custom_urls.list.filter',1),('[]','sulu_admin.list_store.form_data.list.filter',1),('[]','sulu_admin.list_store.forms.list.filter',1),('[]','sulu_admin.list_store.media.contact_media.filter',1),('[]','sulu_admin.list_store.media.media_overview.filter',1),('\"a2071e02-5d37-4f3f-b4f1-9d6ecd6d3ff0\"','sulu_admin.list_store.pages.page_list_vitras.active',1),('\"86f3b23f-8f91-495b-a700-8cd0dc59c27b\"','sulu_admin.list_store.pages.single_list_overlay.active',1),('[]','sulu_admin.list_store.roles.list.filter',1),('[]','sulu_admin.list_store.snippets.list.filter',1);

--
-- Table structure for table `se_user_two_factors`
--

CREATE TABLE `se_user_two_factors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `method` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `options` longtext COLLATE utf8mb4_unicode_ci,
  `idUsers` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_732E8321347E6F4` (`idUsers`),
  CONSTRAINT `FK_732E8321347E6F4` FOREIGN KEY (`idUsers`) REFERENCES `se_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `se_user_two_factors`
--


--
-- Table structure for table `ta_tags`
--

CREATE TABLE `ta_tags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `changed` datetime NOT NULL,
  `idUsersCreator` int DEFAULT NULL,
  `idUsersChanger` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B258E4995E237E06` (`name`),
  KEY `IDX_B258E499DBF11E1D` (`idUsersCreator`),
  KEY `IDX_B258E49930D07CD5` (`idUsersChanger`),
  CONSTRAINT `FK_B258E49930D07CD5` FOREIGN KEY (`idUsersChanger`) REFERENCES `se_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_B258E499DBF11E1D` FOREIGN KEY (`idUsersCreator`) REFERENCES `se_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ta_tags`
--


--
-- Table structure for table `tr_trash_item_translations`
--

CREATE TABLE `tr_trash_item_translations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `trashItemId` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8264DAF45C8D7CA4180C698` (`trashItemId`,`locale`),
  KEY `IDX_8264DAF45C8D7CA` (`trashItemId`),
  CONSTRAINT `FK_8264DAF45C8D7CA` FOREIGN KEY (`trashItemId`) REFERENCES `tr_trash_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tr_trash_item_translations`
--

INSERT INTO `tr_trash_item_translations` VALUES (1,'de','ico-cog (1)',1);

--
-- Table structure for table `tr_trash_items`
--

CREATE TABLE `tr_trash_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `resourceKey` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resourceId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `restoreData` json NOT NULL,
  `restoreType` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `restoreOptions` json NOT NULL,
  `resourceSecurityContext` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resourceSecurityObjectType` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resourceSecurityObjectId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `storeTimestamp` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `defaultLocale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `userId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_102989B64B64DCC` (`userId`),
  KEY `IDX_102989B5DAEB55C8CF57CB1` (`resourceKey`,`resourceId`),
  CONSTRAINT `FK_102989B64B64DCC` FOREIGN KEY (`userId`) REFERENCES `se_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tr_trash_items`
--

INSERT INTO `tr_trash_items` VALUES (1,'media','29','{\"files\": [{\"created\": \"2023-10-06T12:00:28+02:00\", \"version\": 1, \"creatorId\": 1, \"fileVersions\": [{\"meta\": [{\"title\": \"ico-cog (1)\", \"locale\": \"de\", \"credits\": null, \"copyright\": null, \"description\": null}], \"name\": \"ico-cog (1).svg\", \"size\": 2678, \"tagIds\": [], \"created\": \"2023-10-06T12:00:28+02:00\", \"version\": 1, \"mimeType\": \"image/svg+xml\", \"creatorId\": 1, \"properties\": {\"width\": 28, \"height\": 32}, \"categoryIds\": [], \"focusPointX\": null, \"focusPointY\": null, \"formatOptions\": [], \"targetGroupIds\": [], \"downloadCounter\": 0, \"defaultMetaLocale\": \"de\", \"trashStorageOptions\": {\"segment\": \"02\", \"fileName\": \"ico-cog-1.svg\", \"directory\": \"trash\"}, \"contentLanguageLocales\": [], \"originalStorageOptions\": {\"segment\": \"02\", \"fileName\": \"ico-cog-1.svg\"}, \"publishLanguageLocales\": []}]}], \"typeId\": 2, \"created\": \"2023-10-06T12:00:28+02:00\", \"creatorId\": 1, \"collectionId\": 7, \"previewImageId\": null}',NULL,'[]','sulu.media.collections','Sulu\\Bundle\\MediaBundle\\Entity\\Collection','7','2023-10-06 12:00:58','de',1);

--
-- Table structure for table `we_analytics`
--

CREATE TABLE `we_analytics` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `webspace_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `all_domains` tinyint(1) NOT NULL,
  `content` json NOT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4E50BB8D1640EFD3` (`all_domains`),
  KEY `IDX_4E50BB8DAE248174` (`webspace_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `we_analytics`
--


--
-- Table structure for table `we_analytics_domains`
--

CREATE TABLE `we_analytics_domains` (
  `analytics` int NOT NULL,
  `domain` int NOT NULL,
  PRIMARY KEY (`analytics`,`domain`),
  KEY `IDX_F9323B6EEAC2E688` (`analytics`),
  KEY `IDX_F9323B6EA7A91E0B` (`domain`),
  CONSTRAINT `FK_F9323B6EA7A91E0B` FOREIGN KEY (`domain`) REFERENCES `we_domains` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F9323B6EEAC2E688` FOREIGN KEY (`analytics`) REFERENCES `we_analytics` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `we_analytics_domains`
--


--
-- Table structure for table `we_domains`
--

CREATE TABLE `we_domains` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `environment` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7CFAB3F5F47645AE` (`url`),
  KEY `IDX_7CFAB3F54626DE22` (`environment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `we_domains`
--



