-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `lobby11shareacop_data`
--

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

--
-- Table structure for table `batch`
--

CREATE TABLE `batch` (
  `bid` int UNSIGNED NOT NULL COMMENT 'Primary Key: Unique batch ID.',
  `token` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'A string token generated against the current user''s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.',
  `timestamp` int NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.',
  `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores details about batches (processes that run in…';

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

--
-- Table structure for table `block_content`
--

CREATE TABLE `block_content` (
  `id` int UNSIGNED NOT NULL,
  `revision_id` int UNSIGNED DEFAULT NULL,
  `type` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for block_content entities.';

--
-- Dumping data for table `block_content`
--

INSERT INTO `block_content` (`id`, `revision_id`, `type`, `uuid`, `langcode`) VALUES
(1, 1, 'basic', 'b2d6bb36-929a-47df-813c-86d6ad9fbcfc', 'en'),
(2, 2, 'basic', '903fec91-2542-4f59-bacf-8f2e42f1b8e4', 'en'),
(3, 3, 'image_block', '96958e92-bf7b-4d2b-8b9c-7946b15b35e5', 'en'),
(4, 4, 'basic', '0efc5e5b-c2dc-4d6f-9224-392c48fb8fee', 'en');

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

--
-- Table structure for table `block_content_field_data`
--

CREATE TABLE `block_content_field_data` (
  `id` int UNSIGNED NOT NULL,
  `revision_id` int UNSIGNED NOT NULL,
  `type` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The ID of the target entity.',
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `status` tinyint NOT NULL,
  `info` varchar(255) DEFAULT NULL,
  `changed` int DEFAULT NULL,
  `reusable` tinyint DEFAULT NULL,
  `default_langcode` tinyint NOT NULL,
  `revision_translation_affected` tinyint DEFAULT NULL,
  `content_translation_source` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `content_translation_outdated` tinyint DEFAULT NULL,
  `content_translation_uid` int UNSIGNED DEFAULT NULL COMMENT 'The ID of the target entity.',
  `content_translation_created` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The data table for block_content entities.';

--
-- Dumping data for table `block_content_field_data`
--

INSERT INTO `block_content_field_data` (`id`, `revision_id`, `type`, `langcode`, `status`, `info`, `changed`, `reusable`, `default_langcode`, `revision_translation_affected`, `content_translation_source`, `content_translation_outdated`, `content_translation_uid`, `content_translation_created`) VALUES
(1, 1, 'basic', 'en', 1, 'Copyright', 1769896576, 1, 1, 1, 'und', 0, NULL, NULL),
(1, 1, 'basic', 'fr', 1, 'Droits d’auteur', 1773752248, 1, 0, 1, 'en', 0, 1, 1773752248),
(2, 2, 'basic', 'en', 1, 'Address', 1769897094, 1, 1, 1, 'und', 0, NULL, NULL),
(2, 2, 'basic', 'fr', 1, 'Address', 1773752450, 1, 0, 1, 'en', 0, 1, 1773752450),
(3, 3, 'image_block', 'en', 1, 'Homepage Image', 1773750811, 1, 1, 1, 'und', 0, 0, 1773749405),
(3, 3, 'image_block', 'fr', 1, 'Homepage Image', 1773750762, 1, 0, 1, 'en', 0, 1, 1773749235),
(4, 4, 'basic', 'en', 1, 'Homepage intro', 1773750396, 1, 1, 1, 'und', 0, 0, 1773749629),
(4, 4, 'basic', 'fr', 1, 'Homepage intro', 1773750440, 1, 0, 1, 'en', 0, 1, 1773750317);

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

--
-- Table structure for table `block_content_field_revision`
--

CREATE TABLE `block_content_field_revision` (
  `id` int UNSIGNED NOT NULL,
  `revision_id` int UNSIGNED NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `status` tinyint NOT NULL,
  `info` varchar(255) DEFAULT NULL,
  `changed` int DEFAULT NULL,
  `default_langcode` tinyint NOT NULL,
  `revision_translation_affected` tinyint DEFAULT NULL,
  `content_translation_source` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `content_translation_outdated` tinyint DEFAULT NULL,
  `content_translation_uid` int UNSIGNED DEFAULT NULL COMMENT 'The ID of the target entity.',
  `content_translation_created` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The revision data table for block_content entities.';

--
-- Dumping data for table `block_content_field_revision`
--

INSERT INTO `block_content_field_revision` (`id`, `revision_id`, `langcode`, `status`, `info`, `changed`, `default_langcode`, `revision_translation_affected`, `content_translation_source`, `content_translation_outdated`, `content_translation_uid`, `content_translation_created`) VALUES
(1, 1, 'en', 1, 'Copyright', 1769896576, 1, 1, 'und', 0, NULL, NULL),
(1, 1, 'fr', 1, 'Droits d’auteur', 1773752248, 0, 1, 'en', 0, 1, 1773752248),
(2, 2, 'en', 1, 'Address', 1769897094, 1, 1, 'und', 0, NULL, NULL),
(2, 2, 'fr', 1, 'Address', 1773752450, 0, 1, 'en', 0, 1, 1773752450),
(3, 3, 'en', 1, 'Homepage Image', 1773750811, 1, 1, 'und', 0, 0, 1773749405),
(3, 3, 'fr', 1, 'Homepage Image', 1773750762, 0, 1, 'en', 0, 1, 1773749235),
(4, 4, 'en', 1, 'Homepage intro', 1773750396, 1, 1, 'und', 0, 0, 1773749629),
(4, 4, 'fr', 1, 'Homepage intro', 1773750440, 0, 1, 'en', 0, 1, 1773750317);

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

--
-- Table structure for table `block_content_revision`
--

CREATE TABLE `block_content_revision` (
  `id` int UNSIGNED NOT NULL,
  `revision_id` int UNSIGNED NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `revision_user` int UNSIGNED DEFAULT NULL COMMENT 'The ID of the target entity.',
  `revision_created` int DEFAULT NULL,
  `revision_log` longtext,
  `revision_default` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The revision table for block_content entities.';

--
-- Dumping data for table `block_content_revision`
--

INSERT INTO `block_content_revision` (`id`, `revision_id`, `langcode`, `revision_user`, `revision_created`, `revision_log`, `revision_default`) VALUES
(1, 1, 'en', NULL, 1769896576, NULL, 1),
(2, 2, 'en', NULL, 1769897094, NULL, 1),
(3, 3, 'en', NULL, 1769897625, NULL, 1),
(4, 4, 'en', NULL, 1769897787, NULL, 1);

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

--
-- Table structure for table `block_content_revision__body`
--

CREATE TABLE `block_content_revision__body` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int UNSIGNED NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int UNSIGNED NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int UNSIGNED NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `body_value` longtext NOT NULL,
  `body_summary` longtext,
  `body_format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for block_content field body.';

--
-- Dumping data for table `block_content_revision__body`
--

INSERT INTO `block_content_revision__body` (`bundle`, `deleted`, `entity_id`, `revision_id`, `langcode`, `delta`, `body_value`, `body_summary`, `body_format`) VALUES
('basic', 0, 1, 1, 'en', 0, '<p>© Yukon Legislative Assembly<br><a href=\"/copyright\" hreflang=\"en\">Copyright</a> | <a href=\"/disclaimer\">Disclaimer</a> | <a href=\"/privacy-statement\">Privacy</a></p>', '', 'full_html'),
('basic', 0, 1, 1, 'fr', 0, '<p>© Assemblée législative du Yukon<br><a href=\"/fr/copyright\" hreflang=\"en\">Droits d’auteur</a> | <a href=\"/fr/disclaimer\">Avertissement</a>&nbsp;| <a href=\"/fr/privacy-statement\">Respect de la vie privée</a></p>', '', 'full_html'),
('basic', 0, 2, 2, 'en', 0, '<p>Yukon Legislative Assembly<br>Box 2703, A-9, Whitehorse, Yukon Canada Y1A 2C6<br><a href=\"mailto:info@yukonlobbyistregistry.ca\">info@yukonlobbyistregistry.ca</a> | 867-667-5618</p>', '', 'full_html'),
('basic', 0, 2, 2, 'fr', 0, '<p>Assemblée législative du Yukon<br>C.P 2703, A-9, Whitehorse, Yukon Canada Y1A 2C6<br><a href=\"mailto:info@yukonlobbyistregistry.ca\">info@yukonlobbyistregistry.ca</a> | 867-667-5618</p>', '', 'full_html'),
('image_block', 0, 3, 3, 'en', 0, '<div class=\"row\"><div class=\"col-xs-12 col-md-3 col-md-offset-3\"><div id=\"background-yellow-image\"><div><p><a href=\"/en/register-as-lobbyist\">Register as a lobbyist to report your lobbying activity</a></p></div></div></div><div class=\"col-xs-12 col-md-3\"><div id=\"background-yellow-image\"><div><p><a class=\"webform-dialog button modal-link-mobile\" href=\"/en/form/lobbyist-finder-modal\" data-dialog-options=\"{&quot;width&quot;:650,&quot;height&quot;:500}\">Take the quiz to find out if you\'re a lobbyist</a></p></div></div></div></div>', '', 'full_html'),
('image_block', 0, 3, 3, 'fr', 0, '<div class=\"row\"><div class=\"col-xs-12 col-md-3 col-md-offset-3\"><div id=\"background-yellow-image\"><div><p><a href=\"/fr/register-as-lobbyist\">Inscrivez-vous comme lobbyiste pour déclarer vos activités de lobbyisme</a></p></div></div></div><div class=\"col-xs-12 col-md-3\"><div id=\"background-yellow-image\"><div><p><a class=\"webform-dialog button modal-link-mobile\" href=\"/fr/form/lobbyist-finder-modal\" data-dialog-options=\"{&quot;width&quot;:650,&quot;height&quot;:500}\">Répondez à quelques questions pour savoir si vous êtes un lobbyiste</a></p></div></div></div></div>', '', 'full_html'),
('basic', 0, 4, 4, 'en', 0, '<div class=\"homepage-intro-container\"><div class=\"container\"><h3>Yukon Lobbyist Registry</h3><p>The lobbyist registry is for lobbyists to disclose their activities. Registration is mandatory. The criteria for registering are identified in the <em>Lobbyists Registration Act</em>. The public can also see who is lobbying the government by viewing&nbsp;the lobbyist registry.</p></div></div>', '', 'full_html'),
('basic', 0, 4, 4, 'fr', 0, '<div class=\"homepage-intro-container\"><div class=\"container\"><h3>Registre des lobbyistes du Yukon</h3><p>Le registre des lobbyistes du Yukon permet aux lobbyistes de déclarer leurs activités. L’inscription est obligatoire et les critères pour s’inscrire sont indiqués dans la Loi sur l’inscription des lobbyistes. Grâce à ce registre, la population peut savoir qui tente d’influencer le gouvernement.</p></div></div>', '', 'full_html');

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

--
-- Table structure for table `block_content_revision__field_image`
--

CREATE TABLE `block_content_revision__field_image` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int UNSIGNED NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int UNSIGNED NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int UNSIGNED NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_target_id` int UNSIGNED NOT NULL COMMENT 'The ID of the file entity.',
  `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image''s ''alt'' attribute.',
  `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image''s ''title'' attribute.',
  `field_image_width` int UNSIGNED DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int UNSIGNED DEFAULT NULL COMMENT 'The height of the image in pixels.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for block_content field field…';

--
-- Dumping data for table `block_content_revision__field_image`
--

INSERT INTO `block_content_revision__field_image` (`bundle`, `deleted`, `entity_id`, `revision_id`, `langcode`, `delta`, `field_image_target_id`, `field_image_alt`, `field_image_title`, `field_image_width`, `field_image_height`) VALUES
('image_block', 0, 3, 3, 'en', 0, 1, 'Yukon', '', 2048, 1365);

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

--
-- Table structure for table `block_content__body`
--

CREATE TABLE `block_content__body` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int UNSIGNED NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int UNSIGNED NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int UNSIGNED NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `body_value` longtext NOT NULL,
  `body_summary` longtext,
  `body_format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for block_content field body.';

--
-- Dumping data for table `block_content__body`
--

INSERT INTO `block_content__body` (`bundle`, `deleted`, `entity_id`, `revision_id`, `langcode`, `delta`, `body_value`, `body_summary`, `body_format`) VALUES
('basic', 0, 1, 1, 'en', 0, '<p>© Yukon Legislative Assembly<br><a href=\"/copyright\" hreflang=\"en\">Copyright</a> | <a href=\"/disclaimer\">Disclaimer</a> | <a href=\"/privacy-statement\">Privacy</a></p>', '', 'full_html'),
('basic', 0, 1, 1, 'fr', 0, '<p>© Assemblée législative du Yukon<br><a href=\"/fr/copyright\" hreflang=\"en\">Droits d’auteur</a> | <a href=\"/fr/disclaimer\">Avertissement</a>&nbsp;| <a href=\"/fr/privacy-statement\">Respect de la vie privée</a></p>', '', 'full_html'),
('basic', 0, 2, 2, 'en', 0, '<p>Yukon Legislative Assembly<br>Box 2703, A-9, Whitehorse, Yukon Canada Y1A 2C6<br><a href=\"mailto:info@yukonlobbyistregistry.ca\">info@yukonlobbyistregistry.ca</a> | 867-667-5618</p>', '', 'full_html'),
('basic', 0, 2, 2, 'fr', 0, '<p>Assemblée législative du Yukon<br>C.P 2703, A-9, Whitehorse, Yukon Canada Y1A 2C6<br><a href=\"mailto:info@yukonlobbyistregistry.ca\">info@yukonlobbyistregistry.ca</a> | 867-667-5618</p>', '', 'full_html'),
('image_block', 0, 3, 3, 'en', 0, '<div class=\"row\"><div class=\"col-xs-12 col-md-3 col-md-offset-3\"><div id=\"background-yellow-image\"><div><p><a href=\"/en/register-as-lobbyist\">Register as a lobbyist to report your lobbying activity</a></p></div></div></div><div class=\"col-xs-12 col-md-3\"><div id=\"background-yellow-image\"><div><p><a class=\"webform-dialog button modal-link-mobile\" href=\"/en/form/lobbyist-finder-modal\" data-dialog-options=\"{&quot;width&quot;:650,&quot;height&quot;:500}\">Take the quiz to find out if you\'re a lobbyist</a></p></div></div></div></div>', '', 'full_html'),
('image_block', 0, 3, 3, 'fr', 0, '<div class=\"row\"><div class=\"col-xs-12 col-md-3 col-md-offset-3\"><div id=\"background-yellow-image\"><div><p><a href=\"/fr/register-as-lobbyist\">Inscrivez-vous comme lobbyiste pour déclarer vos activités de lobbyisme</a></p></div></div></div><div class=\"col-xs-12 col-md-3\"><div id=\"background-yellow-image\"><div><p><a class=\"webform-dialog button modal-link-mobile\" href=\"/fr/form/lobbyist-finder-modal\" data-dialog-options=\"{&quot;width&quot;:650,&quot;height&quot;:500}\">Répondez à quelques questions pour savoir si vous êtes un lobbyiste</a></p></div></div></div></div>', '', 'full_html'),
('basic', 0, 4, 4, 'en', 0, '<div class=\"homepage-intro-container\"><div class=\"container\"><h3>Yukon Lobbyist Registry</h3><p>The lobbyist registry is for lobbyists to disclose their activities. Registration is mandatory. The criteria for registering are identified in the <em>Lobbyists Registration Act</em>. The public can also see who is lobbying the government by viewing&nbsp;the lobbyist registry.</p></div></div>', '', 'full_html'),
('basic', 0, 4, 4, 'fr', 0, '<div class=\"homepage-intro-container\"><div class=\"container\"><h3>Registre des lobbyistes du Yukon</h3><p>Le registre des lobbyistes du Yukon permet aux lobbyistes de déclarer leurs activités. L’inscription est obligatoire et les critères pour s’inscrire sont indiqués dans la Loi sur l’inscription des lobbyistes. Grâce à ce registre, la population peut savoir qui tente d’influencer le gouvernement.</p></div></div>', '', 'full_html');

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

--
-- Table structure for table `block_content__field_image`
--

CREATE TABLE `block_content__field_image` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int UNSIGNED NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int UNSIGNED NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int UNSIGNED NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_target_id` int UNSIGNED NOT NULL COMMENT 'The ID of the file entity.',
  `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image''s ''alt'' attribute.',
  `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image''s ''title'' attribute.',
  `field_image_width` int UNSIGNED DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int UNSIGNED DEFAULT NULL COMMENT 'The height of the image in pixels.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for block_content field field_image.';

--
-- Dumping data for table `block_content__field_image`
--

INSERT INTO `block_content__field_image` (`bundle`, `deleted`, `entity_id`, `revision_id`, `langcode`, `delta`, `field_image_target_id`, `field_image_alt`, `field_image_title`, `field_image_width`, `field_image_height`) VALUES
('image_block', 0, 3, 3, 'en', 0, 1, 'Yukon', '', 2048, 1365);

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

--
-- Table structure for table `cachetags`
--

CREATE TABLE `cachetags` (
  `tag` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Namespace-prefixed tag string.',
  `invalidations` int NOT NULL DEFAULT '0' COMMENT 'Number incremented when the tag is invalidated.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Cache table for tracking cache tag invalidations.';

--
-- Dumping data for table `cachetags`
--

INSERT INTO `cachetags` (`tag`, `invalidations`) VALUES
('4xx-response', 4),
('breakpoints', 1),
('config:system.menu.account', 1),
('config:system.menu.admin', 1),
('config:system.menu.footer', 1),
('config:system.menu.main', 1),
('config:system.menu.tools', 1),
('config:webform.webform.add_new_in_house_lobbyist', 1),
('config:webform_list', 1),
('entity_bundles', 1),
('entity_types', 1),
('http_response', 1),
('icon_pack_collector', 1),
('icon_pack_plugin', 1),
('local_task', 2),
('routes', 1),
('route_match', 1),
('user:393', 1),
('user:394', 1),
('user_list', 3),
('webform_submission_view', 1);

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

--
-- Table structure for table `cache_access_policy`
--

CREATE TABLE `cache_access_policy` (
  `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` bigint NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.',
  `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.',
  `serialized` smallint NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).',
  `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.',
  `checksum` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Storage for the cache API.';

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

--
-- Table structure for table `cache_bootstrap`
--

CREATE TABLE `cache_bootstrap` (
  `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` bigint NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.',
  `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.',
  `serialized` smallint NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).',
  `tags` longtext COMMENT 'Space-separated list of cache tags for this entry.',
  `checksum` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Storage for the cache API.';

--
-- Dumping data for table `cache_bootstrap`
--

INSERT INTO `cache_bootstrap` (`cid`, `data`, `expire`, `created`, `serialized`, `tags`, `checksum`) VALUES
('block_content_uuid', 0x613a343a7b733a33363a2239303366656339312d323534322d346635392d626163662d386632653432663162386534223b733a313a2232223b733a33363a2262326436626233362d393239612d343764662d383133632d383664366164396662636663223b733a313a2231223b733a33363a2239363935386539322d626637622d346432622d386239632d373934366231356233356535223b733a313a2233223b733a33363a2230656663356535622d633264632d346436662d393232342d333932633438666238666565223b733a313a2234223b7d, -1, 1773833907.315, 1, '', '0');
INSERT INTO `cache_bootstrap` (`cid`, `data`, `expire`, `created`, `serialized`, `tags`, `checksum`) VALUES
('core.extension.list.theme', 0x[encoded data, 59830 characters], -1, 1773833266.617, 1, '', '0');
INSERT INTO `cache_bootstrap` (`cid`, `data`, `expire`, `created`, `serialized`, `tags`, `checksum`) VALUES
('hook_data', 0x[encoded data, 206460 characters], -1, 1773833263.764, 1, '', '0');
INSERT INTO `cache_bootstrap` (`cid`, `data`, `expire`, `created`, `serialized`, `tags`, `checksum`) VALUES
('language_config_ids', 0x613a343a7b693a303b733a31383a226c616e67756167652e656e746974792e656e223b693a313b733a31383a226c616e67756167652e656e746974792e6672223b693a323b733a31393a226c616e67756167652e656e746974792e756e64223b693a333b733a31393a226c616e67756167652e656e746974792e7a7878223b7d, -1, 1773833263.750, 1, '', '0'),
('path_alias_prefix_list', 0x613a35303a7b733a353a2261646d696e223b623a303b733a383a2272756e2d63726f6e223b623a303b733a383a226269675f70697065223b623a303b733a32313a2262697a5f61637469766974795f6d65737361676573223b4e3b733a31363a2262697a5f626c6f636b5f706c7567696e223b4e3b733a31313a226765742d76657273696f6e223b4e3b733a31303a226765742d7265706f7274223b4e3b733a373a226578706f727473223b4e3b733a353a227061746368223b4e3b733a31343a22626c6f636b2d63617465676f7279223b4e3b733a353a22626c6f636b223b623a303b733a393a22636b656469746f7235223b4e3b733a373a22636f6d6d656e74223b4e3b733a383a22636f6d6d656e7473223b4e3b733a373a22636f6e74616374223b4e3b733a343a2275736572223b623a313b733a31303a22636f6e7465787475616c223b623a303b733a363a22656469746f72223b4e3b733a343a2266696c65223b4e3b733a363a2266696c746572223b4e3b733a373a22686973746f7279223b4e3b733a353a227369746573223b4e3b733a363a2273797374656d223b623a303b733a31343a226c61796f75745f6275696c646572223b4e3b733a363a226c696e6b6974223b4e3b733a353a226d65646961223b623a303b733a31333a226d656469612d6c696272617279223b4e3b733a343a226e6f6465223b623a313b733a393a22717569636b74616273223b623a303b733a363a22736561726368223b4e3b733a31313a22736974656d61702e786d6c223b4e3b733a383a22736974656d617073223b4e3b733a31373a22736974656d61705f67656e657261746f72223b4e3b733a343a2263726f6e223b4e3b733a303a22223b4e3b733a393a223c63757272656e743e223b4e3b733a353a226261746368223b4e3b733a31303a227570646174652e706870223b4e3b733a32393a22656e746974795f7265666572656e63655f6175746f636f6d706c657465223b623a303b733a373a2273657373696f6e223b4e3b733a383a227461786f6e6f6d79223b4e3b733a353a22746f6b656e223b4e3b733a373a22746f6f6c626172223b4e3b733a31313a222e77656c6c2d6b6e6f776e223b4e3b733a31313a22757365722d696d706f7274223b4e3b733a373a22776562666f726d223b623a313b733a373a227273732e786d6c223b623a303b733a353a227669657773223b4e3b733a363a22656e74697479223b4e3b733a31323a22776562666f726d5f72657374223b4e3b7d, -1, 1773833918.450, 1, '', '0');
INSERT INTO `cache_bootstrap` (`cid`, `data`, `expire`, `created`, `serialized`, `tags`, `checksum`) VALUES
('state', 0x[encoded data, 140958 characters], -1, 1773834322.478, 1, '', '0');
