INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(224, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 23362 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834675),
(225, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '487', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view?id=487', '', '116.72.200.52', 1773834687),
(226, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10754 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view?id=487', '', '116.72.200.52', 1773834687),
(227, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '\"[@\\\"org_name\\\":\\\"w3C New\\\",\\\"address_line1\\\":\\\"test\\\",\\\"administrative_area\\\":\\\"AB\\\",\\\"locality\\\":\\\"test\\\",\\\"postal_code\\\":\\\"T3K 4J3\\\",\\\"webform_submission_value_17\\\":\\\"CA\\\",\\\"e_mail_address\\\":\\\"contact2@w3creatives.com\\\",\\\"custom_telephone\\\":\\\"(224) 342-3423\\\",\\\"start_date\\\":\\\"2026-03-01\\\",\\\"end_date\\\":\\\"2026-03-31\\\",\\\"title\\\":\\\"Test title\\\",\\\"topics\\\":\\\"Regional development, Industry, Conservation \\\",\\\"add_detail\\\":\\\"Test\\\",\\\"who_are_you_lobbying_or_plan_to_lobby_\\\":\\\"280, 279\\\",\\\"how_do_you_want_to_lobby_\\\":\\\"By letter and email\\\",\\\"has_your_organization_received_a_grant_from_the_government_of_yu\\\":\\\"Yes\\\",\\\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\\\":\\\"Yes\\\",\\\"sid\\\":\\\"487\\\",\\\"uuid\\\":\\\"66f32813-4e90-4e27-b44f-57972654cc31\\\",\\\"last_updated\\\":\\\"\\\\u003Ctime datetime=\\\\u00222026-03-18T11:51:13+00:00\\\\u0022 title=\\\\u0022Wednesday, 18 March 2026 - 11:51\\\\u0022\\\\u003E2026\\\\\\/03\\\\\\/18 11:51\\\\u003C\\\\\\/time\\\\u003E\\\\n\\\",\\\"status\\\":\\\"Pending\\\",\\\"display_end_date\\\":\\\"2026\\\\\\/03\\\\\\/31\\\",\\\"country\\\":\\\" \\\\n \\\\n \\\\n\\\\nCanada\\\",\\\"display_start_date\\\":\\\"2026\\\\\\/03\\\\\\/01\\\",\\\"mail\\\":\\\"contact2@w3creatives.com\\\",\\\"other\\\":\\\"\\\",\\\"which_topic_do_you_want_to_lobby_government_about_\\\":\\\"101, 88, 65\\\",\\\"webform_id\\\":\\\"add_a_lobbying_activity_consulta\\\",\\\"who_you_lobbying\\\":\\\"Cabinet or Caucus, MLA - Copperbelt North (Currie Dixon)\\\",\\\"uid\\\":\\\"305\\\",\\\"country_code\\\":\\\"CA\\\"]\"', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view?id=487', '', '116.72.200.52', 1773834687),
(228, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '487', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', '', '116.72.200.52', 1773834702),
(229, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10754 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', '', '116.72.200.52', 1773834702);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(230, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '\"[@\\\"org_name\\\":\\\"w3C New\\\",\\\"address_line1\\\":\\\"test\\\",\\\"administrative_area\\\":\\\"AB\\\",\\\"locality\\\":\\\"test\\\",\\\"postal_code\\\":\\\"T3K 4J3\\\",\\\"webform_submission_value_17\\\":\\\"CA\\\",\\\"e_mail_address\\\":\\\"contact2@w3creatives.com\\\",\\\"custom_telephone\\\":\\\"(224) 342-3423\\\",\\\"start_date\\\":\\\"2026-03-01\\\",\\\"end_date\\\":\\\"2026-03-31\\\",\\\"title\\\":\\\"Test title\\\",\\\"topics\\\":\\\"Regional development, Industry, Conservation \\\",\\\"add_detail\\\":\\\"Test\\\",\\\"who_are_you_lobbying_or_plan_to_lobby_\\\":\\\"280, 279\\\",\\\"how_do_you_want_to_lobby_\\\":\\\"By letter and email\\\",\\\"has_your_organization_received_a_grant_from_the_government_of_yu\\\":\\\"Yes\\\",\\\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\\\":\\\"Yes\\\",\\\"sid\\\":\\\"487\\\",\\\"uuid\\\":\\\"66f32813-4e90-4e27-b44f-57972654cc31\\\",\\\"last_updated\\\":\\\"\\\\u003Ctime datetime=\\\\u00222026-03-18T11:51:13+00:00\\\\u0022 title=\\\\u0022Wednesday, 18 March 2026 - 11:51\\\\u0022\\\\u003E2026\\\\\\/03\\\\\\/18 11:51\\\\u003C\\\\\\/time\\\\u003E\\\\n\\\",\\\"status\\\":\\\"Pending\\\",\\\"display_end_date\\\":\\\"2026\\\\\\/03\\\\\\/31\\\",\\\"country\\\":\\\" \\\\n \\\\n \\\\n\\\\nCanada\\\",\\\"display_start_date\\\":\\\"2026\\\\\\/03\\\\\\/01\\\",\\\"mail\\\":\\\"contact2@w3creatives.com\\\",\\\"other\\\":\\\"\\\",\\\"which_topic_do_you_want_to_lobby_government_about_\\\":\\\"101, 88, 65\\\",\\\"webform_id\\\":\\\"add_a_lobbying_activity_consulta\\\",\\\"who_you_lobbying\\\":\\\"Cabinet or Caucus, MLA - Copperbelt North (Currie Dixon)\\\",\\\"uid\\\":\\\"305\\\",\\\"country_code\\\":\\\"CA\\\"]\"', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', '', '116.72.200.52', 1773834702),
(231, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '487', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834717),
(232, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10754 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834717),
(233, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '\"[@\\\"org_name\\\":\\\"w3C New\\\",\\\"address_line1\\\":\\\"test\\\",\\\"administrative_area\\\":\\\"AB\\\",\\\"locality\\\":\\\"test\\\",\\\"postal_code\\\":\\\"T3K 4J3\\\",\\\"webform_submission_value_17\\\":\\\"CA\\\",\\\"e_mail_address\\\":\\\"contact2@w3creatives.com\\\",\\\"custom_telephone\\\":\\\"(224) 342-3423\\\",\\\"start_date\\\":\\\"2026-03-01\\\",\\\"end_date\\\":\\\"2026-03-31\\\",\\\"title\\\":\\\"Test title\\\",\\\"topics\\\":\\\"Regional development, Industry, Conservation \\\",\\\"add_detail\\\":\\\"Test\\\",\\\"who_are_you_lobbying_or_plan_to_lobby_\\\":\\\"280, 279\\\",\\\"how_do_you_want_to_lobby_\\\":\\\"By letter and email\\\",\\\"has_your_organization_received_a_grant_from_the_government_of_yu\\\":\\\"Yes\\\",\\\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\\\":\\\"Yes\\\",\\\"sid\\\":\\\"487\\\",\\\"uuid\\\":\\\"66f32813-4e90-4e27-b44f-57972654cc31\\\",\\\"last_updated\\\":\\\"\\\\u003Ctime datetime=\\\\u00222026-03-18T11:51:13+00:00\\\\u0022 title=\\\\u0022Wednesday, 18 March 2026 - 11:51\\\\u0022\\\\u003E2026\\\\\\/03\\\\\\/18 11:51\\\\u003C\\\\\\/time\\\\u003E\\\\n\\\",\\\"status\\\":\\\"Pending\\\",\\\"display_end_date\\\":\\\"2026\\\\\\/03\\\\\\/31\\\",\\\"country\\\":\\\" \\\\n \\\\n \\\\n\\\\nCanada\\\",\\\"display_start_date\\\":\\\"2026\\\\\\/03\\\\\\/01\\\",\\\"mail\\\":\\\"contact2@w3creatives.com\\\",\\\"other\\\":\\\"\\\",\\\"which_topic_do_you_want_to_lobby_government_about_\\\":\\\"101, 88, 65\\\",\\\"webform_id\\\":\\\"add_a_lobbying_activity_consulta\\\",\\\"who_you_lobbying\\\":\\\"Cabinet or Caucus, MLA - Copperbelt North (Currie Dixon)\\\",\\\"uid\\\":\\\"305\\\",\\\"country_code\\\":\\\"CA\\\"]\"', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834717),
(234, 394, 'biz_webforms', '{\"org_name\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Org. Name\",\"#format_items\":\"comma\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--org_name\",\"#webform_key\":\"org_name\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"org_name\"],\"#admin_title\":\"Org. Name\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"w3C New\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"custom_address\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"address\",\"#title\":\"Address\",\"#required\":true,\"#default_value\":@\"country_code\":\"CA\",\"langcode\":\"\",\"address_line1\":\"\",\"locality\":\"\",\"administrative_area\":\"\",\"postal_code\":\"\",\"given_name\":null,\"additional_name\":null,\"family_name\":null,\"organization\":null,\"address_line2\":null,\"sorting_code\":null,\"dependent_locality\":null,\"#format_items\":\"ol\",\"#field_overrides\":@\"givenName\":\"hidden\",\"additionalName\":\"hidden\",\"familyName\":\"hidden\",\"organization\":\"hidden\",\"addressLine1\":\"required\",\"addressLine2\":\"hidden\",\"postalCode\":\"required\",\"sortingCode\":\"hidden\",\"dependentLocality\":\"hidden\",\"locality\":\"required\",\"administrativeArea\":\"required\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--custom_address\",\"#webform_key\":\"custom_address\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":true,\"#webform_parents\":[\"custom_address\"],\"#admin_title\":\"Address\",\"#webform_plugin_id\":\"address\",\"#webform_composite_elements\":{\"given_name\":@\"#title\":\"Given name\",\"#type\":\"textfield\",\"#maxlength\":255,\"family_name\":@\"#title\":\"Family name\",\"#type\":\"textfield\",\"#maxlength\":255,\"additional_name\":@\"#title\":\"Additional name\",\"#type\":\"textfield\",\"#maxlength\":255,\"organization\":@\"#title\":\"Organization\",\"#type\":\"textfield\",\"#maxlength\":255,\"address_line1\":@\"#title\":\"Address line 1\",\"#type\":\"textfield\",\"#maxlength\":255,\"address_line2\":@\"#title\":\"Address line 2\",\"#type\":\"textfield\",\"#maxlength\":255,\"postal_code\":@\"#title\":\"Postal code\",\"#type\":\"textfield\",\"#maxlength\":255,\"locality\":@\"#title\":\"Locality\",\"#type\":\"textfield\",\"#maxlength\":255,\"dependent_locality\":@\"#title\":\"Dependent_locality\",\"#type\":\"textfield\",\"#maxlength\":255,\"administrative_area\":@\"#title\":\"Administrative area\",\"#type\":\"textfield\",\"#maxlength\":255,\"country_code\":@\"#title\":\"Country code\",\"#type\":\"textfield\",\"#maxlength\":2,\"langcode\":@\"#title\":\"Language code\",\"#type\":\"textfield\",\"#maxlength\":32,\"sorting_code\":@\"#title\":\"Sorting code\",\"#type\":\"textfield\",\"#maxlength\":255}},\"#value\":{\"#prefix\":\"<div class=\\\"address\\\" translate=\\\"no\\\">\",\"#suffix\":\"<\\/div>\",\"#post_render\":[[\"\\\\Drupal\\\\address\\\\Plugin\\\\Field\\\\FieldFormatter\\\\AddressDefaultFormatter\",\"postRender\"]],\"#cache\":@\"contexts\":[\"languages:language_interface\"],\"#address_format\":@,\"#locale\":\"und\",\"country\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"country\"],\"#value\":\"Canada\",\"#placeholder\":\"%country\"},\"administrative_area\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"administrative-area\"],\"#value\":\"AB\",\"#placeholder\":\"%administrativeArea\"},\"locality\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"locality\"],\"#value\":\"test\",\"#placeholder\":\"%locality\"},\"postal_code\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"postal-code\"],\"#value\":\"T3K 4J3\",\"#placeholder\":\"%postalCode\"},\"address_line1\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"address-line1\"],\"#value\":\"test\",\"#placeholder\":\"%addressLine1\"},\"address_line2\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"address-line2\"],\"#value\":\"\",\"#placeholder\":\"%addressLine2\"},\"address_line3\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"address-line3\"],\"#value\":\"\",\"#placeholder\":\"%addressLine3\"},\"organization\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"organization\"],\"#value\":\"\",\"#placeholder\":\"%organization\"},\"given_name\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"given-name\"],\"#value\":\"\",\"#placeholder\":\"%givenName\"},\"family_name\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"family-name\"],\"#value\":\"\",\"#placeholder\":\"%familyName\"}},\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"e_mail_address\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Email\",\"#format_items\":\"comma\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--e_mail_address\",\"#webform_key\":\"e_mail_address\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"e_mail_address\"],\"#admin_title\":\"Email\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"contact2@w3creatives.com\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"custom_telephone\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Telephone\",\"#input_mask\":\"(999) 999-9999\",\"#format_items\":\"comma\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--custom_telephone\",\"#webform_key\":\"custom_telephone\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"custom_telephone\"],\"#admin_title\":\"Telephone\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"(224) 342-3423\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"container_dates\":{\"#theme\":\"webform_container_base_html\",\"#element\":{\"#type\":\"container\",\"start_date\":@\"#type\":\"date\",\"#title\":\"Start date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--start_date\",\"#webform_key\":\"start_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"start_date\"],\"#admin_title\":\"Start date\",\"#webform_plugin_id\":\"date\",\"end_date\":@\"#type\":\"date\",\"#title\":\"End date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--end_date\",\"#webform_key\":\"end_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"end_date\"],\"#admin_title\":\"End date\",\"#webform_plugin_id\":\"date\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--container_dates\",\"#webform_key\":\"container_dates\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\"],\"#title\":null,\"#admin_title\":null,\"#webform_plugin_id\":\"container\"},\"#value\":{\"#type\":\"webform_section\",\"#id\":\"add_a_lobbying_activity_consedit--container_dates\",\"#title\":null,\"#title_tag\":\"h2\",\"#attributes\":@\"class\":[],\"start_date\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"date\",\"#title\":\"Start date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--start_date\",\"#webform_key\":\"start_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"start_date\"],\"#admin_title\":\"Start date\",\"#webform_plugin_id\":\"date\",\"#value\":@\"#plain_text\":\"2026-03-01\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"end_date\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"date\",\"#title\":\"End date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--end_date\",\"#webform_key\":\"end_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"end_date\"],\"#admin_title\":\"End date\",\"#webform_plugin_id\":\"date\",\"#value\":@\"#plain_text\":\"2026-03-31\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false,\"last\":true}},\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false},\"title\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Project title\",\"#description\":\"This is an internal title, you should use a short description of the contract.\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--title\",\"#webform_key\":\"title\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"title\"],\"#admin_title\":\"Project title\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"Test title\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"which_topic_do_you_want_to_lobby_government_about_\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"webform_term_select\",\"#title\":\"Which topic do you want to lobby the government about?\",\"#multiple\":true,\"#select2\":true,\"#required\":true,\"#format\":\"text\",\"#vocabulary\":\"lobby_s_topics\",\"#breadcrumb_delimiter\":\"\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--which_topic_do_you_want_to_lobby_government_about_\",\"#webform_key\":\"which_topic_do_you_want_to_lobby_government_about_\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":true,\"#webform_composite\":false,\"#webform_parents\":[\"which_topic_do_you_want_to_lobby_government_about_\"],\"#admin_title\":\"Which topic do you want to lobby the government about?\",\"#webform_plugin_id\":\"webform_term_select\",\"#value\":[@\"#markup\":\"French Language Services Directorate (101)\",@\"#markup\":\", \",@\"#markup\":\"Officer or Employee of a Yukon Crown Corporation (88)\",@\"#markup\":\", \",@\"#markup\":\"Deputy Minister of Health and Social Services (Tiffany Boyd) (65)\"],\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"add_detail\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textarea\",\"#title\":\"Add details about your lobbying activity (optional)\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--add_detail\",\"#webform_key\":\"add_detail\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"add_detail\"],\"#admin_title\":\"Add details about your lobbying activity (optional)\",\"#webform_plugin_id\":\"textarea\",\"#value\":@\"#markup\":\"Test\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"who_are_you_lobbying_or_plan_to_lobby_\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"webform_term_select\",\"#title\":\"Who are you lobbying or plan to lobby?\",\"#multiple\":true,\"#select2\":true,\"#format\":\"label\",\"#vocabulary\":\"lobbyist_s_portfolios\",\"#breadcrumb_delimiter\":\"\",\"#tree_delimiter\":\"\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--who_are_you_lobbying_or_plan_to_lobby_\",\"#webform_key\":\"who_are_you_lobbying_or_plan_to_lobby_\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":true,\"#webform_composite\":false,\"#webform_parents\":[\"who_are_you_lobbying_or_plan_to_lobby_\"],\"#admin_title\":\"Who are you lobbying or plan to lobby?\",\"#webform_plugin_id\":\"webform_term_select\",\"#value\":[@\"#markup\":\"Cabinet or Caucus\",@\"#markup\":\", \",@\"#markup\":\"Member of the Legislative Assembly\",@\"#markup\":\", \",@\"#markup\":\"MLA - Copperbelt North (Currie Dixon)\",@\"#markup\":\", \",@\"#markup\":\"Finance\"],\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"how_do_you_want_to_lobby_\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"webform_checkboxes_other\",\"#title\":\"How do you want to lobby?\",\"#description\":\"See <a href=\\\"\\/start-reporting\\\" target=\\\"_blank\\\">more details<\\/a> about activities that qualify as lobbying\",\"#options\":@\"By letter and email\":\"By letter and email\",\"By phone call\":\"By phone call\",\"In-person conversation\":\"In-person conversation\",\"By petition\":\"By petition\",\"Social media campaign\":\"Social media campaign\",\"#options_display\":\"two_columns\",\"#other__option_label\":\"Other\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--how_do_you_want_to_lobby_\",\"#webform_key\":\"how_do_you_want_to_lobby_\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":true,\"#webform_composite\":false,\"#webform_parents\":[\"how_do_you_want_to_lobby_\"],\"#admin_title\":\"How do you want to lobby?\",\"#webform_plugin_id\":\"webform_checkboxes_other\"},\"#value\":[@\"#markup\":\"By letter and email\"],\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"has_your_organization_received_a_grant_from_the_government_of_yu\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"radios\",\"#title\":\"Has your client received a grant from the Government of Yukon within the last year?\",\"#options\":@\"Yes\":\"Yes\",\"No\":\"No\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--has_your_organization_received_a_grant_from_the_government_of_yu\",\"#webform_key\":\"has_your_organization_received_a_grant_from_the_government_of_yu\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"has_your_organization_received_a_grant_from_the_government_of_yu\"],\"#admin_title\":\"Has your client received a grant from the Government of Yukon within the last year?\",\"#webform_plugin_id\":\"radios\"},\"#value\":@\"#markup\":\"Yes\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"radios\",\"#title\":\"Was the grant awarded related to the lobbying that has been, or will be, undertaken?\",\"#options\":@\"Yes\":\"Yes\",\"No\":\"No\",\"I don\\u2019t know\":\"I don\\u2019t know\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\",\"#webform_key\":\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\"],\"#admin_title\":\"Was the grant awarded related to the lobbying that has been, or will be, undertaken?\",\"#webform_plugin_id\":\"radios\"},\"#value\":@\"#markup\":\"Yes\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"status\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"select\",\"#title\":\"Status\",\"#options\":@\"Active\":\"Active\",\"Inactive\":\"Inactive\",\"Pending\":\"Pending\",\"Non-compliant\":\"Non-compliant\",\"About to be Not in compliance\":\"About to be Not in compliance\",\"#default_value\":\"Pending\",\"#wrapper_attributes\":@\"class\":[\"no-display\"],\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--status\",\"#webform_key\":\"status\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"status\"],\"#admin_title\":\"Status\",\"#webform_plugin_id\":\"select\"},\"#value\":@\"#markup\":\"Pending\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false}}', 0x613a303a7b7d, 3, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834719);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(235, 394, 'biz_webforms', '{\"org_name\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Org. Name\",\"#format_items\":\"comma\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--org_name\",\"#webform_key\":\"org_name\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"org_name\"],\"#admin_title\":\"Org. Name\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"w3C New\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"custom_address\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"address\",\"#title\":\"Address\",\"#required\":true,\"#default_value\":@\"country_code\":\"CA\",\"langcode\":\"\",\"address_line1\":\"\",\"locality\":\"\",\"administrative_area\":\"\",\"postal_code\":\"\",\"given_name\":null,\"additional_name\":null,\"family_name\":null,\"organization\":null,\"address_line2\":null,\"sorting_code\":null,\"dependent_locality\":null,\"#format_items\":\"ol\",\"#field_overrides\":@\"givenName\":\"hidden\",\"additionalName\":\"hidden\",\"familyName\":\"hidden\",\"organization\":\"hidden\",\"addressLine1\":\"required\",\"addressLine2\":\"hidden\",\"postalCode\":\"required\",\"sortingCode\":\"hidden\",\"dependentLocality\":\"hidden\",\"locality\":\"required\",\"administrativeArea\":\"required\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--custom_address\",\"#webform_key\":\"custom_address\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":true,\"#webform_parents\":[\"custom_address\"],\"#admin_title\":\"Address\",\"#webform_plugin_id\":\"address\",\"#webform_composite_elements\":{\"given_name\":@\"#title\":\"Given name\",\"#type\":\"textfield\",\"#maxlength\":255,\"family_name\":@\"#title\":\"Family name\",\"#type\":\"textfield\",\"#maxlength\":255,\"additional_name\":@\"#title\":\"Additional name\",\"#type\":\"textfield\",\"#maxlength\":255,\"organization\":@\"#title\":\"Organization\",\"#type\":\"textfield\",\"#maxlength\":255,\"address_line1\":@\"#title\":\"Address line 1\",\"#type\":\"textfield\",\"#maxlength\":255,\"address_line2\":@\"#title\":\"Address line 2\",\"#type\":\"textfield\",\"#maxlength\":255,\"postal_code\":@\"#title\":\"Postal code\",\"#type\":\"textfield\",\"#maxlength\":255,\"locality\":@\"#title\":\"Locality\",\"#type\":\"textfield\",\"#maxlength\":255,\"dependent_locality\":@\"#title\":\"Dependent_locality\",\"#type\":\"textfield\",\"#maxlength\":255,\"administrative_area\":@\"#title\":\"Administrative area\",\"#type\":\"textfield\",\"#maxlength\":255,\"country_code\":@\"#title\":\"Country code\",\"#type\":\"textfield\",\"#maxlength\":2,\"langcode\":@\"#title\":\"Language code\",\"#type\":\"textfield\",\"#maxlength\":32,\"sorting_code\":@\"#title\":\"Sorting code\",\"#type\":\"textfield\",\"#maxlength\":255}},\"#value\":{\"#prefix\":\"<div class=\\\"address\\\" translate=\\\"no\\\">\",\"#suffix\":\"<\\/div>\",\"#post_render\":[[\"\\\\Drupal\\\\address\\\\Plugin\\\\Field\\\\FieldFormatter\\\\AddressDefaultFormatter\",\"postRender\"]],\"#cache\":@\"contexts\":[\"languages:language_interface\"],\"#address_format\":@,\"#locale\":\"und\",\"country\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"country\"],\"#value\":\"Canada\",\"#placeholder\":\"%country\"},\"administrative_area\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"administrative-area\"],\"#value\":\"AB\",\"#placeholder\":\"%administrativeArea\"},\"locality\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"locality\"],\"#value\":\"test\",\"#placeholder\":\"%locality\"},\"postal_code\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"postal-code\"],\"#value\":\"T3K 4J3\",\"#placeholder\":\"%postalCode\"},\"address_line1\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"address-line1\"],\"#value\":\"test\",\"#placeholder\":\"%addressLine1\"},\"address_line2\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"address-line2\"],\"#value\":\"\",\"#placeholder\":\"%addressLine2\"},\"address_line3\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"address-line3\"],\"#value\":\"\",\"#placeholder\":\"%addressLine3\"},\"organization\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"organization\"],\"#value\":\"\",\"#placeholder\":\"%organization\"},\"given_name\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"given-name\"],\"#value\":\"\",\"#placeholder\":\"%givenName\"},\"family_name\":{\"#type\":\"html_tag\",\"#tag\":\"span\",\"#attributes\":@\"class\":[\"family-name\"],\"#value\":\"\",\"#placeholder\":\"%familyName\"}},\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"e_mail_address\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Email\",\"#format_items\":\"comma\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--e_mail_address\",\"#webform_key\":\"e_mail_address\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"e_mail_address\"],\"#admin_title\":\"Email\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"contact2@w3creatives.com\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"custom_telephone\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Telephone\",\"#input_mask\":\"(999) 999-9999\",\"#format_items\":\"comma\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--custom_telephone\",\"#webform_key\":\"custom_telephone\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"custom_telephone\"],\"#admin_title\":\"Telephone\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"(224) 342-3423\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"container_dates\":{\"#theme\":\"webform_container_base_html\",\"#element\":{\"#type\":\"container\",\"start_date\":@\"#type\":\"date\",\"#title\":\"Start date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--start_date\",\"#webform_key\":\"start_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"start_date\"],\"#admin_title\":\"Start date\",\"#webform_plugin_id\":\"date\",\"end_date\":@\"#type\":\"date\",\"#title\":\"End date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--end_date\",\"#webform_key\":\"end_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"end_date\"],\"#admin_title\":\"End date\",\"#webform_plugin_id\":\"date\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--container_dates\",\"#webform_key\":\"container_dates\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\"],\"#title\":null,\"#admin_title\":null,\"#webform_plugin_id\":\"container\"},\"#value\":{\"#type\":\"webform_section\",\"#id\":\"add_a_lobbying_activity_consedit--container_dates\",\"#title\":null,\"#title_tag\":\"h2\",\"#attributes\":@\"class\":[],\"start_date\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"date\",\"#title\":\"Start date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--start_date\",\"#webform_key\":\"start_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"start_date\"],\"#admin_title\":\"Start date\",\"#webform_plugin_id\":\"date\",\"#value\":@\"#plain_text\":\"2026-03-01\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"end_date\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"date\",\"#title\":\"End date\",\"#format_items\":\"comma\",\"#datepicker\":true,\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--end_date\",\"#webform_key\":\"end_date\",\"#webform_parent_key\":\"container_dates\",\"#webform_parent_flexbox\":false,\"#webform_depth\":1,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"container_dates\",\"end_date\"],\"#admin_title\":\"End date\",\"#webform_plugin_id\":\"date\",\"#value\":@\"#plain_text\":\"2026-03-31\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false,\"last\":true}},\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false},\"title\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textfield\",\"#title\":\"Project title\",\"#description\":\"This is an internal title, you should use a short description of the contract.\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--title\",\"#webform_key\":\"title\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"title\"],\"#admin_title\":\"Project title\",\"#webform_plugin_id\":\"textfield\",\"#value\":@\"#plain_text\":\"Test title\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"which_topic_do_you_want_to_lobby_government_about_\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"webform_term_select\",\"#title\":\"Which topic do you want to lobby the government about?\",\"#multiple\":true,\"#select2\":true,\"#required\":true,\"#format\":\"text\",\"#vocabulary\":\"lobby_s_topics\",\"#breadcrumb_delimiter\":\"\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--which_topic_do_you_want_to_lobby_government_about_\",\"#webform_key\":\"which_topic_do_you_want_to_lobby_government_about_\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":true,\"#webform_composite\":false,\"#webform_parents\":[\"which_topic_do_you_want_to_lobby_government_about_\"],\"#admin_title\":\"Which topic do you want to lobby the government about?\",\"#webform_plugin_id\":\"webform_term_select\",\"#value\":[@\"#markup\":\"French Language Services Directorate (101)\",@\"#markup\":\", \",@\"#markup\":\"Officer or Employee of a Yukon Crown Corporation (88)\",@\"#markup\":\", \",@\"#markup\":\"Deputy Minister of Health and Social Services (Tiffany Boyd) (65)\"],\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"add_detail\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"textarea\",\"#title\":\"Add details about your lobbying activity (optional)\",\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--add_detail\",\"#webform_key\":\"add_detail\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"add_detail\"],\"#admin_title\":\"Add details about your lobbying activity (optional)\",\"#webform_plugin_id\":\"textarea\",\"#value\":@\"#markup\":\"Test\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"who_are_you_lobbying_or_plan_to_lobby_\":{\"#theme\":\"webform_element_base_html\",\"#element\":@\"#type\":\"webform_term_select\",\"#title\":\"Who are you lobbying or plan to lobby?\",\"#multiple\":true,\"#select2\":true,\"#format\":\"label\",\"#vocabulary\":\"lobbyist_s_portfolios\",\"#breadcrumb_delimiter\":\"\",\"#tree_delimiter\":\"\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--who_are_you_lobbying_or_plan_to_lobby_\",\"#webform_key\":\"who_are_you_lobbying_or_plan_to_lobby_\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":true,\"#webform_composite\":false,\"#webform_parents\":[\"who_are_you_lobbying_or_plan_to_lobby_\"],\"#admin_title\":\"Who are you lobbying or plan to lobby?\",\"#webform_plugin_id\":\"webform_term_select\",\"#value\":[@\"#markup\":\"Cabinet or Caucus\",@\"#markup\":\", \",@\"#markup\":\"Member of the Legislative Assembly\",@\"#markup\":\", \",@\"#markup\":\"MLA - Copperbelt North (Currie Dixon)\",@\"#markup\":\", \",@\"#markup\":\"Finance\"],\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":true},\"how_do_you_want_to_lobby_\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"webform_checkboxes_other\",\"#title\":\"How do you want to lobby?\",\"#description\":\"See <a href=\\\"\\/start-reporting\\\" target=\\\"_blank\\\">more details<\\/a> about activities that qualify as lobbying\",\"#options\":@\"By letter and email\":\"By letter and email\",\"By phone call\":\"By phone call\",\"In-person conversation\":\"In-person conversation\",\"By petition\":\"By petition\",\"Social media campaign\":\"Social media campaign\",\"#options_display\":\"two_columns\",\"#other__option_label\":\"Other\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--how_do_you_want_to_lobby_\",\"#webform_key\":\"how_do_you_want_to_lobby_\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":true,\"#webform_composite\":false,\"#webform_parents\":[\"how_do_you_want_to_lobby_\"],\"#admin_title\":\"How do you want to lobby?\",\"#webform_plugin_id\":\"webform_checkboxes_other\"},\"#value\":[@\"#markup\":\"By letter and email\"],\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"has_your_organization_received_a_grant_from_the_government_of_yu\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"radios\",\"#title\":\"Has your client received a grant from the Government of Yukon within the last year?\",\"#options\":@\"Yes\":\"Yes\",\"No\":\"No\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--has_your_organization_received_a_grant_from_the_government_of_yu\",\"#webform_key\":\"has_your_organization_received_a_grant_from_the_government_of_yu\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"has_your_organization_received_a_grant_from_the_government_of_yu\"],\"#admin_title\":\"Has your client received a grant from the Government of Yukon within the last year?\",\"#webform_plugin_id\":\"radios\"},\"#value\":@\"#markup\":\"Yes\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"radios\",\"#title\":\"Was the grant awarded related to the lobbying that has been, or will be, undertaken?\",\"#options\":@\"Yes\":\"Yes\",\"No\":\"No\",\"I don\\u2019t know\":\"I don\\u2019t know\",\"#required\":true,\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\",\"#webform_key\":\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\"],\"#admin_title\":\"Was the grant awarded related to the lobbying that has been, or will be, undertaken?\",\"#webform_plugin_id\":\"radios\"},\"#value\":@\"#markup\":\"Yes\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false},\"status\":{\"#theme\":\"webform_element_base_html\",\"#element\":{\"#type\":\"select\",\"#title\":\"Status\",\"#options\":@\"Active\":\"Active\",\"Inactive\":\"Inactive\",\"Pending\":\"Pending\",\"Non-compliant\":\"Non-compliant\",\"About to be Not in compliance\":\"About to be Not in compliance\",\"#default_value\":\"Pending\",\"#wrapper_attributes\":@\"class\":[\"no-display\"],\"#webform\":\"add_a_lobbying_activity_consedit\",\"#webform_id\":\"add_a_lobbying_activity_consedit--status\",\"#webform_key\":\"status\",\"#webform_parent_key\":\"\",\"#webform_parent_flexbox\":false,\"#webform_depth\":0,\"#webform_children\":[],\"#webform_multiple\":false,\"#webform_composite\":false,\"#webform_parents\":[\"status\"],\"#admin_title\":\"Status\",\"#webform_plugin_id\":\"select\"},\"#value\":@\"#markup\":\"Pending\",\"#webform_submission\":@,\"#options\":@\"view_mode\":\"preview\",\"excluded_elements\":[],\"exclude_empty\":true,\"exclude_empty_checkbox\":false,\"multiline\":false}}', 0x613a303a7b7d, 3, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834719),
(236, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '487', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834727),
(237, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10754 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834727),
(238, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '\"[@\\\"org_name\\\":\\\"w3C New\\\",\\\"address_line1\\\":\\\"test\\\",\\\"administrative_area\\\":\\\"AB\\\",\\\"locality\\\":\\\"test\\\",\\\"postal_code\\\":\\\"T3K 4J3\\\",\\\"webform_submission_value_17\\\":\\\"CA\\\",\\\"e_mail_address\\\":\\\"contact2@w3creatives.com\\\",\\\"custom_telephone\\\":\\\"(224) 342-3423\\\",\\\"start_date\\\":\\\"2026-03-01\\\",\\\"end_date\\\":\\\"2026-03-31\\\",\\\"title\\\":\\\"Test title\\\",\\\"topics\\\":\\\"Regional development, Industry, Conservation \\\",\\\"add_detail\\\":\\\"Test\\\",\\\"who_are_you_lobbying_or_plan_to_lobby_\\\":\\\"280, 279\\\",\\\"how_do_you_want_to_lobby_\\\":\\\"By letter and email\\\",\\\"has_your_organization_received_a_grant_from_the_government_of_yu\\\":\\\"Yes\\\",\\\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\\\":\\\"Yes\\\",\\\"sid\\\":\\\"487\\\",\\\"uuid\\\":\\\"66f32813-4e90-4e27-b44f-57972654cc31\\\",\\\"last_updated\\\":\\\"\\\\u003Ctime datetime=\\\\u00222026-03-18T11:51:13+00:00\\\\u0022 title=\\\\u0022Wednesday, 18 March 2026 - 11:51\\\\u0022\\\\u003E2026\\\\\\/03\\\\\\/18 11:51\\\\u003C\\\\\\/time\\\\u003E\\\\n\\\",\\\"status\\\":\\\"Pending\\\",\\\"display_end_date\\\":\\\"2026\\\\\\/03\\\\\\/31\\\",\\\"country\\\":\\\" \\\\n \\\\n \\\\n\\\\nCanada\\\",\\\"display_start_date\\\":\\\"2026\\\\\\/03\\\\\\/01\\\",\\\"mail\\\":\\\"contact2@w3creatives.com\\\",\\\"other\\\":\\\"\\\",\\\"which_topic_do_you_want_to_lobby_government_about_\\\":\\\"101, 88, 65\\\",\\\"webform_id\\\":\\\"add_a_lobbying_activity_consulta\\\",\\\"who_you_lobbying\\\":\\\"Cabinet or Caucus, MLA - Copperbelt North (Currie Dixon)\\\",\\\"uid\\\":\\\"305\\\",\\\"country_code\\\":\\\"CA\\\"]\"', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834727);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(239, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 21798 characters], 4, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834727),
(240, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 21822 characters], 4, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834727);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(241, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 21846 characters], 4, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&org=487&webform_id=add_a_lobbying_activity_consulta', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834727),
(242, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 23362 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view/consultant-add-activity-edit-fr?id=487&webform_id=add_a_lobbying_activity_consulta&org=487', '116.72.200.52', 1773834730),
(243, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '487', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view?id=487', '', '116.72.200.52', 1773834740);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(244, 394, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10754 characters], 7, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view?id=487', '', '116.72.200.52', 1773834740),
(245, 394, 'BizWebformsSubscriber::validateOwnerConsultantActivity', '\"[@\\\"org_name\\\":\\\"w3C New\\\",\\\"address_line1\\\":\\\"test\\\",\\\"administrative_area\\\":\\\"AB\\\",\\\"locality\\\":\\\"test\\\",\\\"postal_code\\\":\\\"T3K 4J3\\\",\\\"webform_submission_value_17\\\":\\\"CA\\\",\\\"e_mail_address\\\":\\\"contact2@w3creatives.com\\\",\\\"custom_telephone\\\":\\\"(224) 342-3423\\\",\\\"start_date\\\":\\\"2026-03-01\\\",\\\"end_date\\\":\\\"2026-03-31\\\",\\\"title\\\":\\\"Test title\\\",\\\"topics\\\":\\\"Regional development, Industry, Conservation \\\",\\\"add_detail\\\":\\\"Test\\\",\\\"who_are_you_lobbying_or_plan_to_lobby_\\\":\\\"280, 254, 279, 284\\\",\\\"how_do_you_want_to_lobby_\\\":\\\"By letter and email\\\",\\\"has_your_organization_received_a_grant_from_the_government_of_yu\\\":\\\"Yes\\\",\\\"was_the_grant_awarded_related_to_the_matter_the_lobbying_has_bee\\\":\\\"Yes\\\",\\\"sid\\\":\\\"487\\\",\\\"uuid\\\":\\\"66f32813-4e90-4e27-b44f-57972654cc31\\\",\\\"last_updated\\\":\\\"\\\\u003Ctime datetime=\\\\u00222026-03-18T11:52:08+00:00\\\\u0022 title=\\\\u0022Wednesday, 18 March 2026 - 11:52\\\\u0022\\\\u003E2026\\\\\\/03\\\\\\/18 11:52\\\\u003C\\\\\\/time\\\\u003E\\\\n\\\",\\\"status\\\":\\\"Pending\\\",\\\"display_end_date\\\":\\\"2026\\\\\\/03\\\\\\/31\\\",\\\"country\\\":\\\" \\\\n \\\\n \\\\n\\\\nCanada\\\",\\\"display_start_date\\\":\\\"2026\\\\\\/03\\\\\\/01\\\",\\\"mail\\\":\\\"contact2@w3creatives.com\\\",\\\"other\\\":\\\"\\\",\\\"which_topic_do_you_want_to_lobby_government_about_\\\":\\\"101, 88, 65\\\",\\\"webform_id\\\":\\\"add_a_lobbying_activity_consulta\\\",\\\"who_you_lobbying\\\":\\\"Cabinet or Caucus, Member of the Legislative Assembly, MLA - Copperbelt North (Currie Dixon), Finance\\\",\\\"uid\\\":\\\"305\\\",\\\"country_code\\\":\\\"CA\\\"]\"', 0x613a303a7b7d, 5, '', 'https://lobby11.shareacopy.com/web/en/consultant-account-home/consultant-activity-view?id=487', '', '116.72.200.52', 1773834740);

-- --------------------------------------------------------

--
-- Table structure for table `webform`
--

CREATE TABLE `webform` (
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.',
  `next_serial` int UNSIGNED NOT NULL DEFAULT '1' COMMENT 'The serial number to give to the next submission to this webform.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores all webform data.';

--
-- Dumping data for table `webform`
--

INSERT INTO `webform` (`webform_id`, `next_serial`) VALUES
('add_a_lobbying_activity', 1),
('add_a_lobbying_activity_consedit', 1),
('add_a_lobbying_activity_consulta', 1),
('add_a_lobbying_activity_edit', 1),
('add_an_in_house_lobbyist_to_your', 1),
('add_new_in_house_lobbyist', 1),
('contact', 1),
('example_options_custom', 1),
('feedback_form', 3),
('lobbyist_finder_modal', 1),
('template_contact', 1),
('template_employee_evaluation', 1),
('template_feedback', 1),
('template_issue', 1),
('template_job_application', 1),
('template_job_seeker_profile', 1),
('template_medical_appointment', 1),
('template_registration', 1),
('template_session_evaluation', 1),
('template_subscribe', 1),
('template_user_profile', 1);

-- --------------------------------------------------------

--
-- Table structure for table `webform_access_group_admin`
--

CREATE TABLE `webform_access_group_admin` (
  `group_id` varchar(32) NOT NULL COMMENT 'The webform access group id.',
  `uid` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The admin user id.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores admin associated with a webform access group.';

-- --------------------------------------------------------

--
-- Table structure for table `webform_access_group_entity`
--

CREATE TABLE `webform_access_group_entity` (
  `group_id` varchar(32) NOT NULL COMMENT 'The webform access group id.',
  `entity_type` varchar(32) NOT NULL COMMENT 'The source entity type.',
  `entity_id` varchar(32) NOT NULL COMMENT 'The source entity id.',
  `field_name` varchar(32) NOT NULL COMMENT 'The webform field name.',
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores users associated with a webform access group.';

-- --------------------------------------------------------

--
-- Table structure for table `webform_access_group_user`
--

CREATE TABLE `webform_access_group_user` (
  `group_id` varchar(32) NOT NULL COMMENT 'The webform access group id.',
  `uid` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The user id.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores users associated with a webform access group.';

-- --------------------------------------------------------

--
-- Table structure for table `webform_scheduled_email`
--

CREATE TABLE `webform_scheduled_email` (
  `eid` int NOT NULL COMMENT 'Primary Key: Scheduled email ID.',
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.',
  `entity_type` varchar(32) DEFAULT NULL COMMENT 'The entity type to which this submission was submitted from.',
  `entity_id` varchar(255) DEFAULT NULL COMMENT 'The ID of the entity of which this webform submission was submitted from.',
  `sid` int UNSIGNED NOT NULL COMMENT 'The webform submission id.',
  `handler_id` varchar(64) DEFAULT NULL COMMENT 'The webform handler id.',
  `state` varchar(32) DEFAULT NULL COMMENT 'The state of the scheduled email. (schedule, reschedule, unschedule, or send)',
  `send` int DEFAULT '0' COMMENT 'Unix timestamp of when email should be sent.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Table that contains Webform scheduled emails.';

-- --------------------------------------------------------

--
-- Table structure for table `webform_submission`
--

CREATE TABLE `webform_submission` (
  `sid` int NOT NULL,
  `webform_id` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The ID of the target entity.',
  `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `serial` int DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `uri` varchar(2000) DEFAULT NULL,
  `created` int DEFAULT NULL,
  `completed` int DEFAULT NULL,
  `changed` int DEFAULT NULL,
  `in_draft` tinyint DEFAULT NULL,
  `current_page` varchar(128) DEFAULT NULL,
  `remote_addr` varchar(128) DEFAULT NULL,
  `uid` int UNSIGNED DEFAULT NULL COMMENT 'The ID of the target entity.',
  `entity_type` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `entity_id` varchar(255) DEFAULT NULL,
  `locked` tinyint DEFAULT NULL,
  `sticky` tinyint DEFAULT NULL,
  `notes` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for webform_submission entities.';

--
-- Dumping data for table `webform_submission`
--

INSERT INTO `webform_submission` (`sid`, `webform_id`, `uuid`, `langcode`, `serial`, `token`, `uri`, `created`, `completed`, `changed`, `in_draft`, `current_page`, `remote_addr`, `uid`, `entity_type`, `entity_id`, `locked`, `sticky`, `notes`) VALUES
(1, 'feedback_form', '9127a07e-a736-4d44-a27b-70837e65dfac', 'en', 1, '0rCZe7SzSEDkCcG8iEMFTGBUSREKualx0WR-E9Ujv8s', '/en/directives', 1770238820, 1770238820, 1770238820, 0, NULL, '106.219.84.187', 1, 'node', '1', 0, 0, NULL),
(2, 'feedback_form', '863cb00b-638d-45b0-b73e-30bd2bb2c1fc', 'en', 2, 'gQ5FktzbLvO1tPWqTnfxu_ePcTYW0-3g6GlHV2MVbrE', '/en/directives', 1770239185, 1770239185, 1770239185, 0, NULL, '106.219.84.187', 0, 'node', '1', 0, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `webform_submission_data`
--

CREATE TABLE `webform_submission_data` (
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.',
  `sid` int NOT NULL COMMENT 'The unique identifier for this submission.',
  `name` varchar(128) NOT NULL COMMENT 'The name of the element.',
  `property` varchar(128) NOT NULL DEFAULT '' COMMENT 'The property of the element''s value.',
  `delta` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The delta of the element''s value.',
  `value` mediumtext NOT NULL COMMENT 'The element''s value.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores all submitted data for webform submissions.';

--
-- Dumping data for table `webform_submission_data`
--

INSERT INTO `webform_submission_data` (`webform_id`, `sid`, `name`, `property`, `delta`, `value`) VALUES
('feedback_form', 1, 'how_can_we_improve_this_page_', '', 0, ''),
('feedback_form', 1, 'how_did_this_page_help_you_', '', 0, 'Test'),
('feedback_form', 1, 'was_this_page_helpful_', '', 0, 'Yes'),
('feedback_form', 2, 'how_can_we_improve_this_page_', '', 0, ''),
('feedback_form', 2, 'how_did_this_page_help_you_', '', 0, 'test'),
('feedback_form', 2, 'was_this_page_helpful_', '', 0, 'Yes');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `batch`
--
ALTER TABLE `batch`
  ADD PRIMARY KEY (`bid`),
  ADD KEY `token` (`token`);

--
-- Indexes for table `block_content`
--
ALTER TABLE `block_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `block_content_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `block_content__revision_id` (`revision_id`),
  ADD KEY `block_content_field__type__target_id` (`type`);

--
-- Indexes for table `block_content_field_data`
--
ALTER TABLE `block_content_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `block_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `block_content__revision_id` (`revision_id`),
  ADD KEY `block_content_field__type__target_id` (`type`),
  ADD KEY `block_content_field__reusable` (`reusable`),
  ADD KEY `block_content__status_type` (`status`,`type`,`id`),
  ADD KEY `block_content__a2de77f2fa` (`content_translation_uid`);

--
-- Indexes for table `block_content_field_revision`
--
ALTER TABLE `block_content_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `block_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `block_content__a2de77f2fa` (`content_translation_uid`);

--
-- Indexes for table `block_content_revision`
--
ALTER TABLE `block_content_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `block_content__id` (`id`),
  ADD KEY `block_content_field__revision_user__target_id` (`revision_user`);

--
-- Indexes for table `block_content_revision__body`
--
ALTER TABLE `block_content_revision__body`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `block_content_revision__field_image`
--
ALTER TABLE `block_content_revision__field_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_target_id` (`field_image_target_id`);

--
-- Indexes for table `block_content__body`
--
ALTER TABLE `block_content__body`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `block_content__field_image`
--
ALTER TABLE `block_content__field_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_target_id` (`field_image_target_id`);

--
-- Indexes for table `cachetags`
--
ALTER TABLE `cachetags`
  ADD PRIMARY KEY (`tag`);

--
-- Indexes for table `cache_access_policy`
--
ALTER TABLE `cache_access_policy`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_bootstrap`
--
ALTER TABLE `cache_bootstrap`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_config`
--
ALTER TABLE `cache_config`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_container`
--
ALTER TABLE `cache_container`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_data`
--
ALTER TABLE `cache_data`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_default`
--
ALTER TABLE `cache_default`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_discovery`
--
ALTER TABLE `cache_discovery`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_discovery_migration`
--
ALTER TABLE `cache_discovery_migration`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_dynamic_page_cache`
--
ALTER TABLE `cache_dynamic_page_cache`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_entity`
--
ALTER TABLE `cache_entity`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_menu`
--
ALTER TABLE `cache_menu`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_migrate`
--
ALTER TABLE `cache_migrate`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_page`
--
ALTER TABLE `cache_page`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_render`
--
ALTER TABLE `cache_render`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_rest`
--
ALTER TABLE `cache_rest`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_toolbar`
--
ALTER TABLE `cache_toolbar`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `comment`
--
ALTER TABLE `comment`
  ADD PRIMARY KEY (`cid`),
  ADD UNIQUE KEY `comment_field__uuid__value` (`uuid`),
  ADD KEY `comment_field__comment_type__target_id` (`comment_type`);

--
-- Indexes for table `comment_entity_statistics`
--
ALTER TABLE `comment_entity_statistics`
  ADD PRIMARY KEY (`entity_id`,`entity_type`,`field_name`),
  ADD KEY `last_comment_timestamp` (`last_comment_timestamp`),
  ADD KEY `comment_count` (`comment_count`),
  ADD KEY `last_comment_uid` (`last_comment_uid`);

--
-- Indexes for table `comment_field_data`
--
ALTER TABLE `comment_field_data`
  ADD PRIMARY KEY (`cid`,`langcode`),
  ADD KEY `comment__id__default_langcode__langcode` (`cid`,`default_langcode`,`langcode`),
  ADD KEY `comment_field__comment_type__target_id` (`comment_type`),
  ADD KEY `comment_field__uid__target_id` (`uid`),
  ADD KEY `comment_field__created` (`created`),
  ADD KEY `comment__status_comment_type` (`status`,`comment_type`,`cid`),
  ADD KEY `comment__status_pid` (`pid`,`status`),
  ADD KEY `comment__num_new` (`entity_id`,`entity_type`,`comment_type`,`status`,`created`,`cid`,`thread`(191)),
  ADD KEY `comment__entity_langcode` (`entity_id`,`entity_type`,`comment_type`,`default_langcode`);

--
-- Indexes for table `comment__comment_body`
--
ALTER TABLE `comment__comment_body`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `comment_body_format` (`comment_body_format`);

--
-- Indexes for table `config`
--
ALTER TABLE `config`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `config_snapshot`
--
ALTER TABLE `config_snapshot`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `content_moderation_state`
--
ALTER TABLE `content_moderation_state`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_moderation_state_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `content_moderation_state__revision_id` (`revision_id`);

--
-- Indexes for table `content_moderation_state_field_data`
--
ALTER TABLE `content_moderation_state_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD UNIQUE KEY `content_moderation_state__lookup` (`content_entity_type_id`,`content_entity_id`,`content_entity_revision_id`,`workflow`,`langcode`),
  ADD KEY `content_moderation_state__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `content_moderation_state__revision_id` (`revision_id`),
  ADD KEY `content_moderation_state_field__uid__target_id` (`uid`),
  ADD KEY `content_moderation_state__09628d8dbc` (`workflow`),
  ADD KEY `content_moderation_state__moderation_state` (`moderation_state`(191));

--
-- Indexes for table `content_moderation_state_field_revision`
--
ALTER TABLE `content_moderation_state_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD UNIQUE KEY `content_moderation_state__lookup` (`content_entity_type_id`,`content_entity_id`,`content_entity_revision_id`,`workflow`,`langcode`),
  ADD KEY `content_moderation_state__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `content_moderation_state_field__uid__target_id` (`uid`),
  ADD KEY `content_moderation_state__09628d8dbc` (`workflow`),
  ADD KEY `content_moderation_state__moderation_state` (`moderation_state`(191));

--
-- Indexes for table `content_moderation_state_revision`
--
ALTER TABLE `content_moderation_state_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `content_moderation_state__id` (`id`);

--
-- Indexes for table `file_managed`
--
ALTER TABLE `file_managed`
  ADD PRIMARY KEY (`fid`),
  ADD UNIQUE KEY `file_field__uuid__value` (`uuid`),
  ADD KEY `file_field__uid__target_id` (`uid`),
  ADD KEY `file_field__uri` (`uri`(191)),
  ADD KEY `file_field__status` (`status`),
  ADD KEY `file_field__changed` (`changed`);

--
-- Indexes for table `file_usage`
--
ALTER TABLE `file_usage`
  ADD PRIMARY KEY (`fid`,`type`,`id`,`module`),
  ADD KEY `type_id` (`type`,`id`),
  ADD KEY `fid_count` (`fid`,`count`),
  ADD KEY `fid_module` (`fid`,`module`);

--
-- Indexes for table `flood`
--
ALTER TABLE `flood`
  ADD PRIMARY KEY (`fid`),
  ADD KEY `allow` (`event`,`identifier`,`timestamp`),
  ADD KEY `purge` (`expiration`);

--
-- Indexes for table `help_search_items`
--
ALTER TABLE `help_search_items`
  ADD PRIMARY KEY (`sid`),
  ADD KEY `section_plugin_id` (`section_plugin_id`),
  ADD KEY `topic_id` (`topic_id`);

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`uid`,`nid`),
  ADD KEY `nid` (`nid`);

--
-- Indexes for table `inline_block_usage`
--
ALTER TABLE `inline_block_usage`
  ADD PRIMARY KEY (`block_content_id`),
  ADD KEY `type_id` (`layout_entity_type`,`layout_entity_id`);

--
-- Indexes for table `key_value`
--
ALTER TABLE `key_value`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `key_value_expire`
--
ALTER TABLE `key_value_expire`
  ADD PRIMARY KEY (`collection`,`name`),
  ADD KEY `expire` (`expire`);

--
-- Indexes for table `locales_location`
--
ALTER TABLE `locales_location`
  ADD PRIMARY KEY (`lid`),
  ADD KEY `string_type` (`sid`,`type`),
  ADD KEY `type_name` (`type`,`name`(191));

--
-- Indexes for table `locales_source`
--
ALTER TABLE `locales_source`
  ADD PRIMARY KEY (`lid`),
  ADD KEY `source_context` (`source`(30),`context`);

--
-- Indexes for table `locales_target`
--
ALTER TABLE `locales_target`
  ADD PRIMARY KEY (`language`,`lid`),
  ADD KEY `lid` (`lid`);

--
-- Indexes for table `locale_file`
--
ALTER TABLE `locale_file`
  ADD PRIMARY KEY (`project`,`langcode`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`mid`),
  ADD UNIQUE KEY `media_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `media__vid` (`vid`),
  ADD KEY `media_field__bundle__target_id` (`bundle`);

--
-- Indexes for table `media_field_data`
--
ALTER TABLE `media_field_data`
  ADD PRIMARY KEY (`mid`,`langcode`),
  ADD KEY `media__id__default_langcode__langcode` (`mid`,`default_langcode`,`langcode`),
  ADD KEY `media__vid` (`vid`),
  ADD KEY `media_field__bundle__target_id` (`bundle`),
  ADD KEY `media_field__uid__target_id` (`uid`),
  ADD KEY `media_field__thumbnail__target_id` (`thumbnail__target_id`),
  ADD KEY `media__status_bundle` (`status`,`bundle`,`mid`);

--
-- Indexes for table `media_field_revision`
--
ALTER TABLE `media_field_revision`
  ADD PRIMARY KEY (`vid`,`langcode`),
  ADD KEY `media__id__default_langcode__langcode` (`mid`,`default_langcode`,`langcode`),
  ADD KEY `media_field__uid__target_id` (`uid`),
  ADD KEY `media_field__thumbnail__target_id` (`thumbnail__target_id`);

--
-- Indexes for table `media_revision`
--
ALTER TABLE `media_revision`
  ADD PRIMARY KEY (`vid`),
  ADD KEY `media__mid` (`mid`),
  ADD KEY `media_field__revision_user__target_id` (`revision_user`);

--
-- Indexes for table `media_revision__field_media_audio_file`
--
ALTER TABLE `media_revision__field_media_audio_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_audio_file_target_id` (`field_media_audio_file_target_id`);

--
-- Indexes for table `media_revision__field_media_document`
--
ALTER TABLE `media_revision__field_media_document`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_document_target_id` (`field_media_document_target_id`);

--
-- Indexes for table `media_revision__field_media_image`
--
ALTER TABLE `media_revision__field_media_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_image_target_id` (`field_media_image_target_id`);

--
-- Indexes for table `media_revision__field_media_oembed_video`
--
ALTER TABLE `media_revision__field_media_oembed_video`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media_revision__field_media_video_file`
--
ALTER TABLE `media_revision__field_media_video_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_video_file_target_id` (`field_media_video_file_target_id`);

--
-- Indexes for table `media__field_media_audio_file`
--
ALTER TABLE `media__field_media_audio_file`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_audio_file_target_id` (`field_media_audio_file_target_id`);

--
-- Indexes for table `media__field_media_document`
--
ALTER TABLE `media__field_media_document`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_document_target_id` (`field_media_document_target_id`);

--
-- Indexes for table `media__field_media_image`
--
ALTER TABLE `media__field_media_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_image_target_id` (`field_media_image_target_id`);

--
-- Indexes for table `media__field_media_oembed_video`
--
ALTER TABLE `media__field_media_oembed_video`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media__field_media_video_file`
--
ALTER TABLE `media__field_media_video_file`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_video_file_target_id` (`field_media_video_file_target_id`);

--
-- Indexes for table `menu_link_content`
--
ALTER TABLE `menu_link_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menu_link_content_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `menu_link_content__revision_id` (`revision_id`);

--
-- Indexes for table `menu_link_content_data`
--
ALTER TABLE `menu_link_content_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `menu_link_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `menu_link_content__revision_id` (`revision_id`),
  ADD KEY `menu_link_content_field__link__uri` (`link__uri`(30)),
  ADD KEY `menu_link_content__enabled_bundle` (`enabled`,`bundle`,`id`),
  ADD KEY `menu_link_content__c97403a52f` (`content_translation_uid`);

--
-- Indexes for table `menu_link_content_field_revision`
--
ALTER TABLE `menu_link_content_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `menu_link_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `menu_link_content_field__link__uri` (`link__uri`(30)),
  ADD KEY `menu_link_content__c97403a52f` (`content_translation_uid`);

--
-- Indexes for table `menu_link_content_revision`
--
ALTER TABLE `menu_link_content_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `menu_link_content__id` (`id`),
  ADD KEY `menu_link_content__ef029a1897` (`revision_user`);

--
-- Indexes for table `menu_tree`
--
ALTER TABLE `menu_tree`
  ADD PRIMARY KEY (`mlid`),
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`),
  ADD KEY `menu_parent_expand_child` (`menu_name`,`expanded`,`has_children`,`parent`(16)),
  ADD KEY `route_values` (`route_name`(32),`route_param_key`(16));

--
-- Indexes for table `multiple_registration`
--
ALTER TABLE `multiple_registration`
  ADD PRIMARY KEY (`uid`);

--
-- Indexes for table `node`
--
ALTER TABLE `node`
  ADD PRIMARY KEY (`nid`),
  ADD UNIQUE KEY `node_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `node__vid` (`vid`),
  ADD KEY `node_field__type__target_id` (`type`);

--
-- Indexes for table `node_access`
--
ALTER TABLE `node_access`
  ADD PRIMARY KEY (`nid`,`gid`,`realm`,`langcode`);

--
-- Indexes for table `node_field_data`
--
ALTER TABLE `node_field_data`
  ADD PRIMARY KEY (`nid`,`langcode`),
  ADD KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`),
  ADD KEY `node__vid` (`vid`),
  ADD KEY `node_field__type__target_id` (`type`),
  ADD KEY `node_field__uid__target_id` (`uid`),
  ADD KEY `node_field__created` (`created`),
  ADD KEY `node_field__changed` (`changed`),
  ADD KEY `node__status_type` (`status`,`type`,`nid`),
  ADD KEY `node__frontpage` (`promote`,`status`,`sticky`,`created`),
  ADD KEY `node__title_type` (`title`(191),`type`(4));

--
-- Indexes for table `node_field_revision`
--
ALTER TABLE `node_field_revision`
  ADD PRIMARY KEY (`vid`,`langcode`),
  ADD KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`),
  ADD KEY `node_field__uid__target_id` (`uid`);

--
-- Indexes for table `node_revision`
--
ALTER TABLE `node_revision`
  ADD PRIMARY KEY (`vid`),
  ADD KEY `node__nid` (`nid`),
  ADD KEY `node_field__langcode` (`langcode`),
  ADD KEY `node_field__revision_uid__target_id` (`revision_uid`);

--
-- Indexes for table `node_revision__body`
--
ALTER TABLE `node_revision__body`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `node_revision__comment`
--
ALTER TABLE `node_revision__comment`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_image`
--
ALTER TABLE `node_revision__field_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_target_id` (`field_image_target_id`);

--
-- Indexes for table `node_revision__field_tags`
--
ALTER TABLE `node_revision__field_tags`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tags_target_id` (`field_tags_target_id`);

--
-- Indexes for table `node_revision__webform`
--
ALTER TABLE `node_revision__webform`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `webform_target_id` (`webform_target_id`);

--
-- Indexes for table `node__body`
--
ALTER TABLE `node__body`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `node__comment`
--
ALTER TABLE `node__comment`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_image`
--
ALTER TABLE `node__field_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_target_id` (`field_image_target_id`);

--
-- Indexes for table `node__field_tags`
--
ALTER TABLE `node__field_tags`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tags_target_id` (`field_tags_target_id`);

--
-- Indexes for table `node__webform`
--
ALTER TABLE `node__webform`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `webform_target_id` (`webform_target_id`);

--
-- Indexes for table `paragraphs_item`
--
ALTER TABLE `paragraphs_item`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `paragraph_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `paragraph__revision_id` (`revision_id`),
  ADD KEY `paragraph_field__type__target_id` (`type`);

--
-- Indexes for table `paragraphs_item_field_data`
--
ALTER TABLE `paragraphs_item_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `paragraph__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `paragraph__revision_id` (`revision_id`),
  ADD KEY `paragraph_field__type__target_id` (`type`),
  ADD KEY `paragraph__status_type` (`status`,`type`,`id`),
  ADD KEY `paragraphs__parent_fields` (`parent_type`,`parent_id`,`parent_field_name`);

--
-- Indexes for table `paragraphs_item_revision`
--
ALTER TABLE `paragraphs_item_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `paragraph__id` (`id`);

--
-- Indexes for table `paragraphs_item_revision_field_data`
--
ALTER TABLE `paragraphs_item_revision_field_data`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `paragraph__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `paragraphs__parent_fields` (`parent_type`,`parent_id`,`parent_field_name`);

--
-- Indexes for table `path_alias`
--
ALTER TABLE `path_alias`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `path_alias_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `path_alias__revision_id` (`revision_id`),
  ADD KEY `path_alias__alias_langcode_id_status` (`alias`(191),`langcode`,`id`,`status`),
  ADD KEY `path_alias__path_langcode_id_status` (`path`(191),`langcode`,`id`,`status`);

--
-- Indexes for table `path_alias_revision`
--
ALTER TABLE `path_alias_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `path_alias__id` (`id`),
  ADD KEY `path_alias_revision__alias_langcode_id_status` (`alias`(191),`langcode`,`id`,`status`),
  ADD KEY `path_alias_revision__path_langcode_id_status` (`path`(191),`langcode`,`id`,`status`);

--
-- Indexes for table `queue`
--
ALTER TABLE `queue`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `name_created` (`name`,`created`),
  ADD KEY `expire` (`expire`);

--
-- Indexes for table `redirect`
--
ALTER TABLE `redirect`
  ADD PRIMARY KEY (`rid`),
  ADD UNIQUE KEY `redirect_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `hash` (`hash`),
  ADD KEY `redirect_field__uid__target_id` (`uid`),
  ADD KEY `redirect_field__redirect_source__path` (`redirect_source__path`(50)),
  ADD KEY `redirect_field__redirect_redirect__uri` (`redirect_redirect__uri`(30)),
  ADD KEY `redirect__enabled_type` (`enabled`,`type`(191),`rid`),
  ADD KEY `source_language` (`redirect_source__path`(191),`language`);

--
-- Indexes for table `router`
--
ALTER TABLE `router`
  ADD PRIMARY KEY (`name`),
  ADD KEY `pattern_outline_parts` (`pattern_outline`(191),`number_parts`),
  ADD KEY `alias` (`alias`);

--
-- Indexes for table `search_dataset`
--
ALTER TABLE `search_dataset`
  ADD PRIMARY KEY (`sid`,`langcode`,`type`);

--
-- Indexes for table `search_index`
--
ALTER TABLE `search_index`
  ADD PRIMARY KEY (`word`,`sid`,`langcode`,`type`),
  ADD KEY `sid_type` (`sid`,`langcode`,`type`);

--
-- Indexes for table `search_total`
--
ALTER TABLE `search_total`
  ADD PRIMARY KEY (`word`);

--
-- Indexes for table `semaphore`
--
ALTER TABLE `semaphore`
  ADD PRIMARY KEY (`name`),
  ADD KEY `value` (`value`),
  ADD KEY `expire` (`expire`);

--
-- Indexes for table `sequences`
--
ALTER TABLE `sequences`
  ADD PRIMARY KEY (`value`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`sid`),
  ADD KEY `timestamp` (`timestamp`),
  ADD KEY `uid` (`uid`);

--
-- Indexes for table `shortcut`
--
ALTER TABLE `shortcut`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shortcut_field__uuid__value` (`uuid`),
  ADD KEY `shortcut_field__shortcut_set__target_id` (`shortcut_set`);

--
-- Indexes for table `shortcut_field_data`
--
ALTER TABLE `shortcut_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `shortcut__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `shortcut_field__shortcut_set__target_id` (`shortcut_set`),
  ADD KEY `shortcut_field__link__uri` (`link__uri`(30));

--
-- Indexes for table `shortcut_set_users`
--
ALTER TABLE `shortcut_set_users`
  ADD PRIMARY KEY (`uid`),
  ADD KEY `set_name` (`set_name`);

--
-- Indexes for table `simple_sitemap`
--
ALTER TABLE `simple_sitemap`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_status_delta` (`type`,`status`,`delta`);

--
-- Indexes for table `simple_sitemap_entity_overrides`
--
ALTER TABLE `simple_sitemap_entity_overrides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `entity_key` (`type`,`entity_type`,`entity_id`);

--
-- Indexes for table `taxonomy_index`
--
ALTER TABLE `taxonomy_index`
  ADD PRIMARY KEY (`nid`,`tid`),
  ADD KEY `term_node` (`tid`,`status`,`sticky`,`created`);

--
-- Indexes for table `taxonomy_term_data`
--
ALTER TABLE `taxonomy_term_data`
  ADD PRIMARY KEY (`tid`),
  ADD UNIQUE KEY `taxonomy_term_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `taxonomy_term__revision_id` (`revision_id`),
  ADD KEY `taxonomy_term_field__vid__target_id` (`vid`);

--
-- Indexes for table `taxonomy_term_field_data`
--
ALTER TABLE `taxonomy_term_field_data`
  ADD PRIMARY KEY (`tid`,`langcode`),
  ADD KEY `taxonomy_term__id__default_langcode__langcode` (`tid`,`default_langcode`,`langcode`),
  ADD KEY `taxonomy_term__revision_id` (`revision_id`),
  ADD KEY `taxonomy_term_field__name` (`name`(191)),
  ADD KEY `taxonomy_term__status_vid` (`status`,`vid`,`tid`),
  ADD KEY `taxonomy_term__tree` (`vid`,`weight`,`name`(191)),
  ADD KEY `taxonomy_term__vid_name` (`vid`,`name`(191)),
  ADD KEY `taxonomy_term__1a0c187e9a` (`content_translation_uid`);

--
-- Indexes for table `taxonomy_term_field_revision`
--
ALTER TABLE `taxonomy_term_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `taxonomy_term__id__default_langcode__langcode` (`tid`,`default_langcode`,`langcode`),
  ADD KEY `taxonomy_term_field__description__format` (`description__format`),
  ADD KEY `taxonomy_term__1a0c187e9a` (`content_translation_uid`);

--
-- Indexes for table `taxonomy_term_revision`
--
ALTER TABLE `taxonomy_term_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `taxonomy_term__tid` (`tid`),
  ADD KEY `taxonomy_term_field__revision_user__target_id` (`revision_user`);

--
-- Indexes for table `taxonomy_term_revision__parent`
--
ALTER TABLE `taxonomy_term_revision__parent`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `parent_target_id` (`parent_target_id`);

--
-- Indexes for table `taxonomy_term__parent`
--
ALTER TABLE `taxonomy_term__parent`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `parent_target_id` (`parent_target_id`),
  ADD KEY `bundle_delta_target_id` (`bundle`,`delta`,`parent_target_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`uid`),
  ADD UNIQUE KEY `user_field__uuid__value` (`uuid`);

--
-- Indexes for table `users_data`
--
ALTER TABLE `users_data`
  ADD PRIMARY KEY (`uid`,`module`,`name`),
  ADD KEY `module` (`module`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `users_field_data`
--
ALTER TABLE `users_field_data`
  ADD PRIMARY KEY (`uid`,`langcode`),
  ADD UNIQUE KEY `user__name` (`name`,`langcode`),
  ADD KEY `user__id__default_langcode__langcode` (`uid`,`default_langcode`,`langcode`),
  ADD KEY `user_field__mail` (`mail`(191)),
  ADD KEY `user_field__created` (`created`),
  ADD KEY `user_field__access` (`access`);

--
-- Indexes for table `user__field_business_name`
--
ALTER TABLE `user__field_business_name`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_first_name`
--
ALTER TABLE `user__field_first_name`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_first_name_consultant_`
--
ALTER TABLE `user__field_first_name_consultant_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_i_aggre_to_terms`
--
ALTER TABLE `user__field_i_aggre_to_terms`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_last_name`
--
ALTER TABLE `user__field_last_name`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_last_name_consultant_`
--
ALTER TABLE `user__field_last_name_consultant_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_legal_organization`
--
ALTER TABLE `user__field_legal_organization`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_operating_organization`
--
ALTER TABLE `user__field_operating_organization`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_position`
--
ALTER TABLE `user__field_position`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_street_address`
--
ALTER TABLE `user__field_street_address`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_telephone`
--
ALTER TABLE `user__field_telephone`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_token_auth_`
--
ALTER TABLE `user__field_token_auth_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__field_updated_by_system`
--
ALTER TABLE `user__field_updated_by_system`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__roles`
--
ALTER TABLE `user__roles`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `roles_target_id` (`roles_target_id`);

--
-- Indexes for table `user__user_picture`
--
ALTER TABLE `user__user_picture`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `user_picture_target_id` (`user_picture_target_id`);

--
-- Indexes for table `watchdog`
--
ALTER TABLE `watchdog`
  ADD PRIMARY KEY (`wid`),
  ADD KEY `type` (`type`),
  ADD KEY `uid` (`uid`),
  ADD KEY `severity` (`severity`);

--
-- Indexes for table `webform`
--
ALTER TABLE `webform`
  ADD PRIMARY KEY (`webform_id`,`next_serial`);

--
-- Indexes for table `webform_access_group_admin`
--
ALTER TABLE `webform_access_group_admin`
  ADD PRIMARY KEY (`group_id`,`uid`),
  ADD KEY `indexing` (`group_id`,`uid`);

--
-- Indexes for table `webform_access_group_entity`
--
ALTER TABLE `webform_access_group_entity`
  ADD PRIMARY KEY (`group_id`,`webform_id`,`entity_type`,`entity_id`,`field_name`),
  ADD KEY `source_entity` (`entity_type`,`entity_id`,`field_name`,`webform_id`);

--
-- Indexes for table `webform_access_group_user`
--
ALTER TABLE `webform_access_group_user`
  ADD PRIMARY KEY (`group_id`,`uid`),
  ADD KEY `indexing` (`group_id`,`uid`);

--
-- Indexes for table `webform_scheduled_email`
--
ALTER TABLE `webform_scheduled_email`
  ADD PRIMARY KEY (`eid`),
  ADD KEY `webform_id` (`webform_id`),
  ADD KEY `sid` (`sid`),
  ADD KEY `scheduled` (`webform_id`,`handler_id`,`send`);

--
-- Indexes for table `webform_submission`
--
ALTER TABLE `webform_submission`
  ADD PRIMARY KEY (`sid`),
  ADD UNIQUE KEY `webform_submission_field__uuid__value` (`uuid`),
  ADD KEY `webform_submission_field__webform_id__target_id` (`webform_id`),
  ADD KEY `webform_submission_field__uid__target_id` (`uid`),
  ADD KEY `webform_submission_field__token` (`token`(191));

--
-- Indexes for table `webform_submission_data`
--
ALTER TABLE `webform_submission_data`
  ADD PRIMARY KEY (`sid`,`name`,`property`,`delta`),
  ADD KEY `webform_id` (`webform_id`),
  ADD KEY `sid_webform_id` (`sid`,`webform_id`),
  ADD KEY `name_webform_id` (`name`,`webform_id`),
  ADD KEY `name_property` (`name`,`property`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `batch`
--
ALTER TABLE `batch`
  MODIFY `bid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique batch ID.', AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `block_content`
--
ALTER TABLE `block_content`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `block_content_revision`
--
ALTER TABLE `block_content_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `cid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_moderation_state`
--
ALTER TABLE `content_moderation_state`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_moderation_state_revision`
--
ALTER TABLE `content_moderation_state_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `file_managed`
--
ALTER TABLE `file_managed`
  MODIFY `fid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `flood`
--
ALTER TABLE `flood`
  MODIFY `fid` int NOT NULL AUTO_INCREMENT COMMENT 'Unique flood event ID.', AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `help_search_items`
--
ALTER TABLE `help_search_items`
  MODIFY `sid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Numeric index of this item in the search index', AUTO_INCREMENT=104;

--
-- AUTO_INCREMENT for table `locales_location`
--
ALTER TABLE `locales_location`
  MODIFY `lid` int NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of this location.', AUTO_INCREMENT=3776;

--
-- AUTO_INCREMENT for table `locales_source`
--
ALTER TABLE `locales_source`
  MODIFY `lid` int NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of this string.', AUTO_INCREMENT=4902;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `mid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media_revision`
--
ALTER TABLE `media_revision`
  MODIFY `vid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_link_content`
--
ALTER TABLE `menu_link_content`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `menu_link_content_revision`
--
ALTER TABLE `menu_link_content_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `menu_tree`
--
ALTER TABLE `menu_tree`
  MODIFY `mlid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The menu link ID (mlid) is the integer primary key.', AUTO_INCREMENT=366;

--
-- AUTO_INCREMENT for table `node`
--
ALTER TABLE `node`
  MODIFY `nid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `node_revision`
--
ALTER TABLE `node_revision`
  MODIFY `vid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT for table `paragraphs_item`
--
ALTER TABLE `paragraphs_item`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `paragraphs_item_revision`
--
ALTER TABLE `paragraphs_item_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `path_alias`
--
ALTER TABLE `path_alias`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;

--
-- AUTO_INCREMENT for table `path_alias_revision`
--
ALTER TABLE `path_alias_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;

--
-- AUTO_INCREMENT for table `queue`
--
ALTER TABLE `queue`
  MODIFY `item_id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique item ID.', AUTO_INCREMENT=2138;

--
-- AUTO_INCREMENT for table `redirect`
--
ALTER TABLE `redirect`
  MODIFY `rid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `sequences`
--
ALTER TABLE `sequences`
  MODIFY `value` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence.';

--
-- AUTO_INCREMENT for table `shortcut`
--
ALTER TABLE `shortcut`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `simple_sitemap`
--
ALTER TABLE `simple_sitemap`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Sitemap chunk unique identifier.', AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `simple_sitemap_entity_overrides`
--
ALTER TABLE `simple_sitemap_entity_overrides`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Override unique identifier.';

--
-- AUTO_INCREMENT for table `taxonomy_term_data`
--
ALTER TABLE `taxonomy_term_data`
  MODIFY `tid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=183;

--
-- AUTO_INCREMENT for table `taxonomy_term_revision`
--
ALTER TABLE `taxonomy_term_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=183;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `uid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=395;

--
-- AUTO_INCREMENT for table `watchdog`
--
ALTER TABLE `watchdog`
  MODIFY `wid` bigint NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.', AUTO_INCREMENT=246;

--
-- AUTO_INCREMENT for table `webform_scheduled_email`
--
ALTER TABLE `webform_scheduled_email`
  MODIFY `eid` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Scheduled email ID.';

--
-- AUTO_INCREMENT for table `webform_submission`
--
ALTER TABLE `webform_submission`
  MODIFY `sid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

