	('', 'views.view.files', _binary 0x[encoded data, 56758 characters]),
	('', 'views.view.frontpage', _binary 0x[encoded data, 16650 characters]),
	('', 'views.view.glossary', _binary 0x[encoded data, 23986 characters]),
	('', 'views.view.newsletter_subscribers', _binary 0x[encoded data, 19734 characters]),
	('', 'views.view.taxonomy_term', _binary 0x[encoded data, 16648 characters]),
	('', 'views.view.user_admin_people', _binary 0x[encoded data, 47306 characters]),
	('', 'views.view.watchdog', _binary 0x[encoded data, 35540 characters]),
	('', 'views.view.who_s_new', _binary 0x[encoded data, 10326 characters]),
	('', 'views.view.who_s_online', _binary 0x[encoded data, 12418 characters]);

-- Dumping structure for table drupal10.culligan_companies
CREATE TABLE IF NOT EXISTS `culligan_companies` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_companies: ~2 rows (approximately)
INSERT INTO `culligan_companies` (`Id`, `Name`) VALUES
	(1, 'CI Design, Inc');

-- Dumping structure for table drupal10.culligan_locations
CREATE TABLE IF NOT EXISTS `culligan_locations` (
  `LocationId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL DEFAULT '0',
  `CompanyId` int(11) NOT NULL,
  `RegionId` int(11) DEFAULT NULL,
  `IsDeleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`LocationId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_locations: ~7 rows (approximately)
INSERT INTO `culligan_locations` (`LocationId`, `Name`, `CompanyId`, `RegionId`, `IsDeleted`) VALUES
	(1, 'Tampa', 1, NULL, 0),
	(2, 'Chicago', 2, NULL, 0),
	(3, 'Indianapolis', 2, NULL, 0),
	(4, 'Fort Myers', 1, NULL, 0),
	(5, 'A deletable location', 1, NULL, 1),
	(6, 'Sarasota', 1, NULL, 0),
	(7, 'Sebring', 1, NULL, 0);

-- Dumping structure for table drupal10.culligan_presentations
CREATE TABLE IF NOT EXISTS `culligan_presentations` (
  `PresentationId` int(11) NOT NULL AUTO_INCREMENT,
  `CompanyId` int(11) DEFAULT NULL,
  `SalesRepId` int(11) DEFAULT NULL,
  `Name` varchar(255) NOT NULL DEFAULT '0',
  `LastModified` datetime NOT NULL DEFAULT current_timestamp(),
  `IsDeleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`PresentationId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_presentations: ~3 rows (approximately)
INSERT INTO `culligan_presentations` (`PresentationId`, `CompanyId`, `SalesRepId`, `Name`, `LastModified`, `IsDeleted`) VALUES
	(1, NULL, NULL, 'Culligan Standard', '2023-10-11 13:43:22', 0),
	(2, 1, NULL, 'Company Standard', '2023-10-11 13:43:22', 0),
	(3, NULL, 2, 'Copy of Company Standard', '2023-10-11 17:28:13', 1),
	(4, NULL, 2, 'Travis\' Go-To Presentation', '2023-10-11 18:12:10', 0),
	(5, NULL, 2, 'Travis\' #2', '2023-10-11 19:23:58', 0),
	(6, NULL, 2, 'Copy of Travis\' #2', '2023-10-11 19:24:46', 0);

-- Dumping structure for table drupal10.culligan_questions
CREATE TABLE IF NOT EXISTS `culligan_questions` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryId` int(11) NOT NULL,
  `Subhead` varchar(50) DEFAULT NULL,
  `Title` text NOT NULL,
  `CompanyId` int(11) DEFAULT NULL,
  `LocationId` int(11) DEFAULT NULL,
  `QuestionTypeId` int(11) NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_questions: ~8 rows (approximately)
INSERT INTO `culligan_questions` (`Id`, `CategoryId`, `Subhead`, `Title`, `CompanyId`, `LocationId`, `QuestionTypeId`, `IsDeleted`) VALUES
	(1, 2, 'Culligan Water', 'Describe any issues with your water', NULL, NULL, 1, 0),
	(2, 3, 'Company Question', 'This is a company question', 1, NULL, 1, 1),
	(3, 5, 'Tampa Water', 'Is there anything you don\'t like about Tampa Water?', 1, 1, 1, 0),
	(4, 3, 'Company Question', 'This is a second company question', 1, NULL, 1, 1),
	(5, 3, 'Mast', 'Are you satisfied with your water?', 1, NULL, 2, 0),
	(6, 3, 'Mast', 'What is wrong with your water?', 1, NULL, 3, 0),
	(7, 2, 'Culligan Water', 'What is your primary source of drinking water?', NULL, NULL, 4, 0),
	(8, 5, 'Tampa Water', 'What brand of bottled water do you prefer?', 1, 1, 1, 0),
	(9, 12, 'Sarasota Water', 'Is your water tasty?', 1, 6, 1, 0),
	(10, 12, 'Sarasota Water', 'Is your water sparkly clear?', 1, 6, 1, 0);

-- Dumping structure for table drupal10.culligan_question_answers
CREATE TABLE IF NOT EXISTS `culligan_question_answers` (
  `AnswerId` int(11) NOT NULL AUTO_INCREMENT,
  `OptionId` int(11) DEFAULT NULL,
  `TextValue` text DEFAULT NULL,
  `QuestionId` int(11) DEFAULT NULL,
  `CustomerId` int(11) NOT NULL,
  PRIMARY KEY (`AnswerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_question_answers: ~0 rows (approximately)

-- Dumping structure for table drupal10.culligan_question_categories
CREATE TABLE IF NOT EXISTS `culligan_question_categories` (
  `QuestionCategoryId` int(11) NOT NULL AUTO_INCREMENT,
  `CompanyId` int(11) DEFAULT NULL,
  `LocationId` int(11) DEFAULT NULL,
  `CategoryName` varchar(255) NOT NULL DEFAULT '',
  `IsDeleted` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`QuestionCategoryId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_question_categories: ~10 rows (approximately)
INSERT INTO `culligan_question_categories` (`QuestionCategoryId`, `CompanyId`, `LocationId`, `CategoryName`, `IsDeleted`) VALUES
	(1, NULL, NULL, 'Culligan Category 1', b'1'),
	(2, NULL, NULL, 'Culligan General Water', b'0'),
	(3, 1, NULL, 'Mast General Water', b'0'),
	(4, 1, NULL, 'Company Category 2', b'1'),
	(5, 1, 1, 'Tampa General Water', b'0'),
	(8, 1, 1, 'Location Category 2', b'1'),
	(9, 1, NULL, 'Company Category 3', b'1'),
	(10, NULL, NULL, 'Culligan Water Issues', b'0'),
	(11, 1, NULL, 'Category Name', b'1'),
	(12, 1, 6, 'Sarasota General Water', b'0');

-- Dumping structure for table drupal10.culligan_question_options
CREATE TABLE IF NOT EXISTS `culligan_question_options` (
  `QuestionOptionId` int(11) NOT NULL AUTO_INCREMENT,
  `Label` text NOT NULL,
  `Value` varchar(50) NOT NULL DEFAULT '',
  `QuestionId` int(11) NOT NULL DEFAULT 0,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `SortIndex` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`QuestionOptionId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_question_options: ~12 rows (approximately)
INSERT INTO `culligan_question_options` (`QuestionOptionId`, `Label`, `Value`, `QuestionId`, `IsDeleted`, `SortIndex`) VALUES
	(1, 'Yes', 'yes', 5, 1, 1),
	(2, 'Somewhat', 'somewhat', 5, 1, 2),
	(3, 'No', 'no', 5, 1, 3),
	(4, 'Taste', 'taste', 6, 0, 1),
	(5, 'Smell', 'smell', 6, 0, 2),
	(6, 'Clarity', 'clarity', 6, 0, 3),
	(7, 'Tap/Faucet', 'tap', 7, 0, 1),
	(8, 'Fridge Filter', 'fridge', 7, 0, 2),
	(9, 'Bottled Water', 'bottle', 7, 0, 3),
	(10, 'Water Filtration System', 'system', 7, 0, 4),
	(11, 'Yes', 'yes', 5, 0, 1),
	(12, 'No', 'no', 5, 0, 2);

-- Dumping structure for table drupal10.culligan_question_types
CREATE TABLE IF NOT EXISTS `culligan_question_types` (
  `QuestionTypeId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`QuestionTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_question_types: ~4 rows (approximately)
INSERT INTO `culligan_question_types` (`QuestionTypeId`, `Name`) VALUES
	(1, 'Text'),
	(2, 'Radio'),
	(3, 'Checkbox'),
	(4, 'Dropdown');

-- Dumping structure for table drupal10.culligan_regions
CREATE TABLE IF NOT EXISTS `culligan_regions` (
  `RegionId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `CompanyId` int(11) DEFAULT NULL,
  `IsDeleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`RegionId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_regions: ~0 rows (approximately)
INSERT INTO `culligan_regions` (`RegionId`, `Name`, `CompanyId`, `IsDeleted`) VALUES
	(1, 'Test', 1, 0);

-- Dumping structure for table drupal10.culligan_selected_questions
CREATE TABLE IF NOT EXISTS `culligan_selected_questions` (
  `SelectionId` int(11) NOT NULL AUTO_INCREMENT,
  `QuestionId` int(11) NOT NULL,
  `CompanyId` int(11) NOT NULL,
  `LocationId` int(11) DEFAULT NULL,
  `SortIndex` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`SelectionId`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_selected_questions: ~8 rows (approximately)
INSERT INTO `culligan_selected_questions` (`SelectionId`, `QuestionId`, `CompanyId`, `LocationId`, `SortIndex`) VALUES
	(27, 5, 1, 1, 1),
	(28, 6, 1, 1, 1),
	(29, 3, 1, 1, 1),
	(30, 8, 1, 1, 1),
	(31, 9, 1, 6, 1),
	(32, 10, 1, 6, 1),
	(33, 6, 1, 6, 1),
	(35, 5, 1, 6, 1);

-- Dumping structure for table drupal10.culligan_selected_question_categories
CREATE TABLE IF NOT EXISTS `culligan_selected_question_categories` (
  `SelectionId` int(11) NOT NULL AUTO_INCREMENT,
  `QuestionCategoryId` int(11) NOT NULL,
  `CompanyId` int(11) NOT NULL,
  `LocationId` int(11) DEFAULT NULL,
  `SortIndex` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`SelectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_selected_question_categories: ~0 rows (approximately)

-- Dumping structure for table drupal10.culligan_slides
CREATE TABLE IF NOT EXISTS `culligan_slides` (
  `SlideId` int(11) NOT NULL AUTO_INCREMENT,
  `Description` varchar(255) NOT NULL,
  `CompanyId` int(11) DEFAULT NULL,
  `LocationId` int(11) DEFAULT NULL,
  `PresentationId` int(11) DEFAULT NULL,
  `TypeId` int(11) NOT NULL DEFAULT 0,
  `Headline` varchar(255) DEFAULT NULL,
  `Copy` text DEFAULT NULL,
  `ImageName` varchar(50) DEFAULT NULL,
  `CaptionText` varchar(255) DEFAULT NULL,
  `CaptionAttribution` varchar(255) DEFAULT NULL,
  `SortIndex` int(11) DEFAULT NULL,
  `SalesRepId` int(11) DEFAULT NULL,
  `IsDeleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`SlideId`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_slides: ~26 rows (approximately)
INSERT INTO `culligan_slides` (`SlideId`, `Description`, `CompanyId`, `LocationId`, `PresentationId`, `TypeId`, `Headline`, `Copy`, `ImageName`, `CaptionText`, `CaptionAttribution`, `SortIndex`, `SalesRepId`, `IsDeleted`) VALUES
	(1, 'Culligan Intro Slide', NULL, NULL, NULL, 1, 'Welcome to Culligan', 'Culligan will make your water better!', NULL, NULL, NULL, NULL, NULL, 0),
	(6, 'Culligan Image', NULL, NULL, NULL, 3, NULL, 'These are some culligan stats', NULL, NULL, NULL, NULL, NULL, 0),
	(11, 'Company Intro', 1, NULL, NULL, 1, 'Welcome to The Company', 'We work with Culligan to give you the best water', NULL, NULL, NULL, NULL, NULL, 0),
	(16, 'Testimonial', 1, NULL, NULL, 5, NULL, NULL, NULL, '"This company is so awesome, I wish I\'d have heard about them sooner."', 'John Smith', NULL, NULL, 0),
	(21, 'First Slide', NULL, NULL, 1, 1, 'Culligan Water First', 'This is the first slide in the Culligan default presentation', NULL, NULL, NULL, 0, NULL, 0),
	(26, 'First Slide', 1, NULL, 2, 1, 'Company First', 'This is the first slide in the QA Company Presentation', NULL, NULL, NULL, 0, NULL, 0),
	(31, 'Travis\' Go-To', 1, NULL, NULL, 1, 'Whiz Bang Sales Pitch', 'These are the water systems you are looking for', NULL, NULL, NULL, NULL, 2, 0),
	(32, 'First Slide', NULL, NULL, 3, 1, 'Company First', 'This is the first slide in the QA Company Presentation', NULL, NULL, NULL, 0, 2, 0),
	(33, 'Headline & Copy', 1, NULL, 3, 1, NULL, NULL, NULL, NULL, NULL, 1, 2, 0),
	(34, 'Travis\' Go-To', 1, NULL, 3, 1, 'Whiz Bang Sales Pitch', 'These are the water systems you are looking for', NULL, NULL, NULL, 2, 2, 0),
	(35, 'First Slide', NULL, NULL, 4, 1, 'Company First', 'This is the first slide in the QA Company Presentation', NULL, NULL, NULL, 0, 2, 0),
	(36, 'Travis\' Go-To', 1, NULL, 4, 1, 'Whiz Bang Sales Pitch', 'These are the water systems you are looking for', NULL, NULL, NULL, 1, 2, 0),
	(37, 'Testimonial', 1, NULL, 4, 5, NULL, NULL, NULL, '"This company is so awesome, I wish I\'d have heard about them sooner."', 'John Smith', 2, 2, 0),
	(38, 'Culligan Intro Slide', 1, NULL, 4, 1, 'Welcome to Culligan', 'Culligan will make your water better!', NULL, NULL, NULL, 3, 2, 0),
	(39, 'Image Left, Copy Right', 1, NULL, 4, 6, NULL, NULL, NULL, NULL, NULL, 4, 2, 0),
	(40, 'First Slide', NULL, NULL, 5, 1, 'Culligan Water First', 'This is the first slide in the Culligan default presentation', NULL, NULL, NULL, 0, 2, 0),
	(41, 'Travis\' Go-To', 1, NULL, 5, 1, 'Whiz Bang Sales Pitch', 'These are the water systems you are looking for', NULL, NULL, NULL, 1, 2, 0),
	(42, 'Image Left, Copy Right', 1, NULL, 5, 6, NULL, NULL, NULL, NULL, NULL, 2, 2, 0),
	(43, 'Testimonial', 1, NULL, 5, 5, NULL, NULL, NULL, '"This company is so awesome, I wish I\'d have heard about them sooner."', 'John Smith', 3, 2, 0),
	(44, 'First Slide', NULL, NULL, 6, 1, 'Culligan Water First', 'This is the first slide in the Culligan default presentation', NULL, NULL, NULL, 0, 2, 0),
	(45, 'Travis\' Go-To', NULL, NULL, 6, 1, 'Whiz Bang Sales Pitch', 'These are the water systems you are looking for', NULL, NULL, NULL, 1, 2, 0),
	(46, 'Image Left, Copy Right', NULL, NULL, 6, 6, NULL, NULL, NULL, NULL, NULL, 2, 2, 0),
	(47, 'Testimonial', NULL, NULL, 6, 5, NULL, NULL, NULL, '"This company is so awesome, I wish I\'d have heard about them sooner."', 'John Smith', 3, 2, 0),
	(48, 'Travis\' Go-To', 1, NULL, 6, 1, 'Whiz Bang Sales Pitch', 'These are the water systems you are looking for', NULL, NULL, NULL, 4, 2, 0);

-- Dumping structure for table drupal10.culligan_slide_types
CREATE TABLE IF NOT EXISTS `culligan_slide_types` (
  `SlideTypeId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`SlideTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_slide_types: ~6 rows (approximately)
INSERT INTO `culligan_slide_types` (`SlideTypeId`, `Name`) VALUES
	(1, 'Headline & Copy'),
	(2, 'Headline, Image, & Copy'),
	(3, 'Image & Copy'),
	(4, 'Image'),
	(5, 'Caption'),
	(6, 'Two-Column Image & Copy');

-- Dumping structure for table drupal10.culligan_users
CREATE TABLE IF NOT EXISTS `culligan_users` (
  `UserId` int(11) NOT NULL,
  `CompanyId` int(11) DEFAULT NULL,
  `SalesRepLocationId` int(11) DEFAULT NULL,
  `FirstName` varchar(255) NOT NULL,
  `LastName` varchar(255) NOT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `IsDeleted` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_users: ~11 rows (approximately)
INSERT INTO `culligan_users` (`UserId`, `CompanyId`, `SalesRepLocationId`, `FirstName`, `LastName`, `Title`, `IsDeleted`) VALUES
	(2, 1, 1, 'Travis (SR)', 'Jansen', 'Software Engineer', 0),
	(3, NULL, NULL, 'Mitch', 'Stone', 'Sales Maven', 0),
	(4, 1, NULL, 'Travis (LA)', 'Jansen', 'Location Admin', 0),
	(6, 1, NULL, 'Company', 'Admin2', 'Company Admin', 0),
	(7, 1, NULL, 'Travis (CA)', 'Company', 'Company Admin', 0),
	(8, 1, NULL, 'Carl', 'Condor', 'Company Admin', 0),
	(9, 1, NULL, 'Travis', 'Jansen', 'Marketing Manager', 0),
	(10, 1, NULL, 'New', 'User', 'New User', 1),
	(11, 1, NULL, 'New', 'Notnotified', 'Test', 1),
	(12, 1, NULL, 'Jane', 'Gibbet', 'New User', 0),
	(13, 1, 6, 'Trevor (SR)', 'Jensen', 'Sales Associate', 0),
	(14, 1, NULL, 'Travis1', 'Test', 'Test', 0),
	(15, 1, NULL, 'Travis1', 'Test', 'Company Admin', 0),
	(16, 1, NULL, 'travis4', 'test4', 'Test', 0);

-- Dumping structure for table drupal10.culligan_user_locations
CREATE TABLE IF NOT EXISTS `culligan_user_locations` (
  `UserId` int(11) NOT NULL,
  `LocationId` int(11) NOT NULL,
  PRIMARY KEY (`UserId`,`LocationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table drupal10.culligan_user_locations: ~0 rows (approximately)

-- Dumping structure for table drupal10.file_managed
CREATE TABLE IF NOT EXISTS `file_managed` (
  `fid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.',
  `filename` varchar(255) DEFAULT NULL,
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `filemime` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `filesize` bigint(20) unsigned DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` int(11) DEFAULT NULL,
  `changed` int(11) NOT NULL,
  PRIMARY KEY (`fid`),
  UNIQUE KEY `file_field__uuid__value` (`uuid`),
  KEY `file_field__uid__target_id` (`uid`),
  KEY `file_field__uri` (`uri`(191)),
  KEY `file_field__status` (`status`),
  KEY `file_field__changed` (`changed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for file entities.';

-- Dumping data for table drupal10.file_managed: ~0 rows (approximately)

-- Dumping structure for table drupal10.file_usage
CREATE TABLE IF NOT EXISTS `file_usage` (
  `fid` int(10) unsigned NOT NULL COMMENT 'File ID.',
  `module` varchar(50) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the module that is using the file.',
  `type` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the object type in which the file is used.',
  `id` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '0' COMMENT 'The primary key of the object using the file.',
  `count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The number of times this file is used by this object.',
  PRIMARY KEY (`fid`,`type`,`id`,`module`),
  KEY `type_id` (`type`,`id`),
  KEY `fid_count` (`fid`,`count`),
  KEY `fid_module` (`fid`,`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Track where a file is used.';

-- Dumping data for table drupal10.file_usage: ~0 rows (approximately)

-- Dumping structure for table drupal10.flood
CREATE TABLE IF NOT EXISTS `flood` (
  `fid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique flood event ID.',
  `event` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Name of event (e.g. contact).',
  `identifier` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Identifier of the visitor, such as an IP address or hostname.',
  `timestamp` int(11) NOT NULL DEFAULT 0 COMMENT 'Timestamp of the event.',
  `expiration` int(11) NOT NULL DEFAULT 0 COMMENT 'Expiration timestamp. Expired events are purged on cron run.',
  PRIMARY KEY (`fid`),
  KEY `allow` (`event`,`identifier`,`timestamp`),
  KEY `purge` (`expiration`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Flood controls the threshold of events, such as the number…';

-- Dumping data for table drupal10.flood: ~0 rows (approximately)

-- Dumping structure for table drupal10.history
CREATE TABLE IF NOT EXISTS `history` (
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT 'The "users".uid that read the "node" nid.',
  `nid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The "node".nid that was read.',
  `timestamp` int(11) NOT NULL DEFAULT 0 COMMENT 'The Unix timestamp at which the read occurred.',
  PRIMARY KEY (`uid`,`nid`),
  KEY `nid` (`nid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='A record of which "users" have read which "node"s.';

-- Dumping data for table drupal10.history: ~0 rows (approximately)

-- Dumping structure for table drupal10.key_value
CREATE TABLE IF NOT EXISTS `key_value` (
  `collection` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'A named collection of key and value pairs.',
  `name` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The key of the key-value pair. As KEY is a SQL reserved keyword, name was chosen instead.',
  `value` longblob NOT NULL COMMENT 'The value.',
  PRIMARY KEY (`collection`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Generic key-value storage table. See the state system for…';

