commit;

--
-- Table structure for table `node`
--

CREATE TABLE `node` (
  `nid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vid` int(10) 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,
  PRIMARY KEY (`nid`),
  UNIQUE KEY `node_field__uuid__value` (`uuid`),
  UNIQUE KEY `node__vid` (`vid`),
  KEY `node_field__type__target_id` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for node entities.';

--
-- Dumping data for table `node`
--

set autocommit=0;
INSERT INTO `node` VALUES (1,128,'article','01425a15-b1dc-417b-81cd-5b00fa84cba6','en'),(2,87,'page','2ad21c82-f03f-4423-b6c6-a45c0c04ebaa','en'),(3,111,'page','a1dec79e-0b8e-4f57-81f3-312ce36f1aa8','en'),(4,131,'page','82d390ea-2bae-466a-b8c9-ea50cb20701a','en'),(5,130,'page','de3909d0-765b-40de-8aaf-1d11cc54f1b8','en'),(6,71,'page','21da657b-4d1d-47ea-8ba7-b44c279fec88','en'),(7,27,'product','9135b3e6-ea28-46b9-984e-2899a1f1569d','en'),(8,28,'product','b5148d0e-875c-4758-90d4-fa780ab12849','en'),(9,105,'product','791c0241-746d-4990-bbf9-979a39b481ad','en'),(10,94,'product','385c0926-3829-4a2d-a3b0-742cba481ca5','en'),(11,104,'product','ea5e7ffd-66bc-4457-87d5-ac91f892d13b','en'),(12,106,'product','f848f8d1-1368-4ea1-bca7-0ce1e5894fba','en'),(13,107,'product','1b57977e-6e4a-4f84-8aa2-dd7d7f8b8e9e','en'),(14,82,'product','b4da07da-695c-4b7c-b886-58c24edd3454','en'),(15,93,'data_scheme','b07a31ca-0230-47d0-ac7b-ad7cc36d6c1d','en'),(16,142,'page','bbbd29ef-e283-47e0-a646-6993119cce41','en'),(17,143,'page','a10dca00-b60b-449e-a602-1f72361f0433','en'),(18,97,'page','cf338364-10ed-43fa-b9ba-b02a4bdcd14b','en'),(19,141,'page','db9fa2d8-19e8-4902-86b1-51e25fa2263b','en'),(20,140,'page','b5a832df-77e7-4004-a4d0-9c3939cb29ed','en'),(21,108,'data_scheme','2b1d75af-dd5f-4474-a214-52e1db782062','en'),(22,109,'data_scheme','da4c7451-57a3-4cda-b190-0ff9edcf7dfc','en'),(23,133,'marketing','2b43b1b4-3e37-43e1-8f48-bf64a8f7df9e','en'),(28,138,'data_scheme','7b52bb21-c48d-4172-82ad-8f6fe5be9c41','en'),(29,139,'data_scheme','9f82143a-692f-4d0c-8d6c-23e9a76477f7','en');
commit;

--
-- Table structure for table `node__body`
--

CREATE TABLE `node__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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `body_value` longtext NOT NULL,
  `body_summary` longtext DEFAULT NULL,
  `body_format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `body_format` (`body_format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field body.';

--
-- Dumping data for table `node__body`
--

set autocommit=0;
INSERT INTO `node__body` VALUES ('article',0,1,128,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>ERC - Cognito/hr-logics</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p><p>&nbsp;</p><p>&nbsp;</p><p>ERC - 8base client</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p><p>&nbsp;</p><p>ERC - hr-logics w/auth0 redirect</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize</a></p>','','basic_html'),('page',0,3,111,'en',0,'<p>Overview of Key Compliance Metrics</p>','','basic_html'),('page',0,4,131,'en',0,'<p>Integrations</p>','','basic_html'),('page',0,6,71,'en',0,'<p>Marketplace</p>','','basic_html');
commit;

--
-- Table structure for table `node__comment`
--

CREATE TABLE `node__comment` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `comment_status` int(11) NOT NULL DEFAULT 0 COMMENT 'Whether comments are allowed on this entity: 0 = no, 1 = closed (read only), 2 = open (read/write).',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field comment.';

--
-- Dumping data for table `node__comment`
--

set autocommit=0;
INSERT INTO `node__comment` VALUES ('article',0,1,128,'en',0,2);
commit;

--
-- Table structure for table `node__field_base_pay`
--

CREATE TABLE `node__field_base_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_base_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_base_pay.';

--
-- Dumping data for table `node__field_base_pay`
--

set autocommit=0;
INSERT INTO `node__field_base_pay` VALUES ('data_scheme',0,28,138,'en',0,'Base pay');
commit;

--
-- Table structure for table `node__field_bonus_pay`
--

CREATE TABLE `node__field_bonus_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_bonus_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_bonus_pay.';

--
-- Dumping data for table `node__field_bonus_pay`
--

set autocommit=0;
INSERT INTO `node__field_bonus_pay` VALUES ('data_scheme',0,28,138,'en',0,'Bonus pay');
commit;

--
-- Table structure for table `node__field_commission_pay`
--

CREATE TABLE `node__field_commission_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_commission_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_commission_pay.';

--
-- Dumping data for table `node__field_commission_pay`
--

set autocommit=0;
INSERT INTO `node__field_commission_pay` VALUES ('data_scheme',0,28,138,'en',0,'Commission pay');
commit;

--
-- Table structure for table `node__field_content`
--

CREATE TABLE `node__field_content` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_content_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `field_content_target_revision_id` int(10) unsigned NOT NULL COMMENT 'The revision ID of the target entity.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_content_target_id` (`field_content_target_id`),
  KEY `field_content_target_revision_id` (`field_content_target_revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_content.';

--
-- Dumping data for table `node__field_content`
--

set autocommit=0;
INSERT INTO `node__field_content` VALUES ('page',0,2,87,'en',0,15,51);
commit;

--
-- Table structure for table `node__field_demo_link`
--

CREATE TABLE `node__field_demo_link` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_demo_link_uri` varchar(2048) DEFAULT NULL COMMENT 'The URI of the link.',
  `field_demo_link_title` varchar(255) DEFAULT NULL COMMENT 'The link text.',
  `field_demo_link_options` longblob DEFAULT NULL COMMENT 'Serialized array of options for the link.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_demo_link_uri` (`field_demo_link_uri`(30))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_demo_link.';

--
-- Dumping data for table `node__field_demo_link`
--

set autocommit=0;
INSERT INTO `node__field_demo_link` VALUES ('product',0,9,105,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,10,94,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,11,104,'en',0,'https://www.clearverify.com/call','','a:0:{}'),('product',0,12,106,'en',0,'https://www.cleari9.com/contact','','a:0:{}'),('product',0,13,107,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,14,82,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('marketing',0,23,133,'en',0,'https://www.oncentive.com/','','a:0:{}');
commit;

--
-- Table structure for table `node__field_department`
--

CREATE TABLE `node__field_department` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_department_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_department.';

--
-- Dumping data for table `node__field_department`
--

set autocommit=0;
INSERT INTO `node__field_department` VALUES ('data_scheme',0,28,138,'en',0,'Department');
commit;

--
-- Table structure for table `node__field_division`
--

CREATE TABLE `node__field_division` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_division_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_division.';

--
-- Dumping data for table `node__field_division`
--

set autocommit=0;
INSERT INTO `node__field_division` VALUES ('data_scheme',0,28,138,'en',0,'Division');
commit;

--
-- Table structure for table `node__field_employee_id`
--

CREATE TABLE `node__field_employee_id` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employee_id_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_employee_id.';

--
-- Dumping data for table `node__field_employee_id`
--

set autocommit=0;
INSERT INTO `node__field_employee_id` VALUES ('data_scheme',0,15,93,'en',0,'eid'),('data_scheme',0,21,108,'en',0,'eidfield'),('data_scheme',0,22,109,'en',0,'test2'),('data_scheme',0,28,138,'en',0,'Employee ID'),('data_scheme',0,29,139,'en',0,'Employee ID');
commit;

--
-- Table structure for table `node__field_employee_status`
--

CREATE TABLE `node__field_employee_status` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employee_status_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_employee_status.';

--
-- Dumping data for table `node__field_employee_status`
--

set autocommit=0;
INSERT INTO `node__field_employee_status` VALUES ('data_scheme',0,28,138,'en',0,'Employee status');
commit;

--
-- Table structure for table `node__field_employment_city`
--

CREATE TABLE `node__field_employment_city` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employment_city_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_employment_city.';

--
-- Dumping data for table `node__field_employment_city`
--

set autocommit=0;
INSERT INTO `node__field_employment_city` VALUES ('data_scheme',0,28,138,'en',0,'Employment city');
commit;

--
-- Table structure for table `node__field_employment_state`
--

CREATE TABLE `node__field_employment_state` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employment_state_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_employment_state.';

--
-- Dumping data for table `node__field_employment_state`
--

set autocommit=0;
INSERT INTO `node__field_employment_state` VALUES ('data_scheme',0,28,138,'en',0,'Employment state');
commit;

--
-- Table structure for table `node__field_federal_withholding`
--

CREATE TABLE `node__field_federal_withholding` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_federal_withholding_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_federal_withholding.';

--
-- Dumping data for table `node__field_federal_withholding`
--

set autocommit=0;
INSERT INTO `node__field_federal_withholding` VALUES ('data_scheme',0,28,138,'en',0,'Federal Witholding');
commit;

--
-- Table structure for table `node__field_first_name`
--

CREATE TABLE `node__field_first_name` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_first_name_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_first_name.';

--
-- Dumping data for table `node__field_first_name`
--

set autocommit=0;
INSERT INTO `node__field_first_name` VALUES ('data_scheme',0,28,138,'en',0,'First name');
commit;

--
-- Table structure for table `node__field_gross_hours`
--

CREATE TABLE `node__field_gross_hours` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_gross_hours_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_gross_hours.';

--
-- Dumping data for table `node__field_gross_hours`
--

set autocommit=0;
INSERT INTO `node__field_gross_hours` VALUES ('data_scheme',0,28,138,'en',0,'Gross hours');
commit;

--
-- Table structure for table `node__field_gross_pay`
--

CREATE TABLE `node__field_gross_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_gross_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_gross_pay.';

--
-- Dumping data for table `node__field_gross_pay`
--

set autocommit=0;
INSERT INTO `node__field_gross_pay` VALUES ('data_scheme',0,28,138,'en',0,'Gross pay');
commit;

--
-- Table structure for table `node__field_icon`
--

CREATE TABLE `node__field_icon` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_icon_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_icon_display` tinyint(3) unsigned DEFAULT 1 COMMENT 'Flag to control whether this file should be displayed when viewing content.',
  `field_icon_description` text DEFAULT NULL COMMENT 'A description of the file.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_icon_target_id` (`field_icon_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_icon.';

--
-- Dumping data for table `node__field_icon`
--

set autocommit=0;
INSERT INTO `node__field_icon` VALUES ('product',0,9,105,'en',0,5,1,''),('product',0,10,94,'en',0,7,1,''),('product',0,11,104,'en',0,6,1,''),('product',0,12,106,'en',0,4,1,''),('product',0,13,107,'en',0,9,1,''),('product',0,14,82,'en',0,8,1,'');
commit;

--
-- Table structure for table `node__field_image`
--

CREATE TABLE `node__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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_target_id` int(10) 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(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_image_target_id` (`field_image_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_image.';

--
-- Dumping data for table `node__field_image`
--

set autocommit=0;
INSERT INTO `node__field_image` VALUES ('marketing',0,23,133,'en',0,31,'HRlogics logo','',194,54);
commit;

--
-- Table structure for table `node__field_last_name`
--

CREATE TABLE `node__field_last_name` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_last_name_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_last_name.';

--
-- Dumping data for table `node__field_last_name`
--

set autocommit=0;
INSERT INTO `node__field_last_name` VALUES ('data_scheme',0,28,138,'en',0,'Last name');
commit;

--
-- Table structure for table `node__field_location_identifier_column`
--

CREATE TABLE `node__field_location_identifier_column` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_location_identifier_column_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_location_identifier…';

--
-- Dumping data for table `node__field_location_identifier_column`
--

set autocommit=0;
INSERT INTO `node__field_location_identifier_column` VALUES ('data_scheme',0,28,138,'en',0,'Location Identifier Column');
commit;

--
-- Table structure for table `node__field_logo`
--

CREATE TABLE `node__field_logo` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_logo_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_logo_display` tinyint(3) unsigned DEFAULT 1 COMMENT 'Flag to control whether this file should be displayed when viewing content.',
  `field_logo_description` text DEFAULT NULL COMMENT 'A description of the file.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_logo_target_id` (`field_logo_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_logo.';

--
-- Dumping data for table `node__field_logo`
--

set autocommit=0;
INSERT INTO `node__field_logo` VALUES ('product',0,9,105,'en',0,20,1,''),('product',0,10,94,'en',0,14,1,''),('product',0,11,104,'en',0,19,1,''),('product',0,12,106,'en',0,21,1,''),('product',0,13,107,'en',0,22,1,'');
commit;

--
-- Table structure for table `node__field_middle_name`
--

CREATE TABLE `node__field_middle_name` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_middle_name_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_middle_name.';

--
-- Dumping data for table `node__field_middle_name`
--

set autocommit=0;
INSERT INTO `node__field_middle_name` VALUES ('data_scheme',0,28,138,'en',0,'Middle name');
commit;

--
-- Table structure for table `node__field_modal_content`
--

CREATE TABLE `node__field_modal_content` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_modal_content_value` longtext NOT NULL,
  `field_modal_content_format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_modal_content_format` (`field_modal_content_format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_modal_content.';

--
-- Dumping data for table `node__field_modal_content`
--

set autocommit=0;
INSERT INTO `node__field_modal_content` VALUES ('marketing',0,23,133,'en',0,'<p>Directly integrate with HR Logics through SFTP. SFTP (Secure File Transfer Protocol) provides a secure and encrypted way to transfer files between two systems. SFTP ensures that data is protected from unauthorized access or interception during transmission, reducing the risk of data breaches and increasing data privacy. By using SFTP to connect, organizations can improve their data security and increase the reliability and efficiency of their data transfers. We will create a server for you and a login and password. Use the application FileZilla to send your files to your personal server, or request files! Ask your Compliance Champion for More information!</p>','basic_html');
commit;

--
-- Table structure for table `node__field_modal_image`
--

CREATE TABLE `node__field_modal_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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_modal_image_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_modal_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image''s ''alt'' attribute.',
  `field_modal_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image''s ''title'' attribute.',
  `field_modal_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_modal_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_modal_image_target_id` (`field_modal_image_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_modal_image.';

--
-- Dumping data for table `node__field_modal_image`
--

set autocommit=0;
INSERT INTO `node__field_modal_image` VALUES ('marketing',0,23,133,'en',0,30,'HRlogics logo','',888,319);
commit;

--
-- Table structure for table `node__field_modal_title`
--

CREATE TABLE `node__field_modal_title` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_modal_title_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_modal_title.';

--
-- Dumping data for table `node__field_modal_title`
--

set autocommit=0;
INSERT INTO `node__field_modal_title` VALUES ('marketing',0,23,133,'en',0,'Directly integrate with HR Logics through “SFTP”');
commit;

--
-- Table structure for table `node__field_most_recent_hire_date`
--

CREATE TABLE `node__field_most_recent_hire_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_most_recent_hire_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_most_recent_hire_date.';

--
-- Dumping data for table `node__field_most_recent_hire_date`
--

set autocommit=0;
INSERT INTO `node__field_most_recent_hire_date` VALUES ('data_scheme',0,28,138,'en',0,'Most recent hire date');
commit;

--
-- Table structure for table `node__field_original_hire_date`
--

CREATE TABLE `node__field_original_hire_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_original_hire_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_original_hire_date.';

--
-- Dumping data for table `node__field_original_hire_date`
--

set autocommit=0;
INSERT INTO `node__field_original_hire_date` VALUES ('data_scheme',0,28,138,'en',0,'Original hire date');
commit;

--
-- Table structure for table `node__field_other_payments`
--

CREATE TABLE `node__field_other_payments` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_other_payments_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_other_payments.';

--
-- Dumping data for table `node__field_other_payments`
--

set autocommit=0;
INSERT INTO `node__field_other_payments` VALUES ('data_scheme',0,28,138,'en',0,'Other payments');
commit;

--
-- Table structure for table `node__field_overtime_hours`
--

CREATE TABLE `node__field_overtime_hours` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_overtime_hours_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_overtime_hours.';

--
-- Dumping data for table `node__field_overtime_hours`
--

set autocommit=0;
INSERT INTO `node__field_overtime_hours` VALUES ('data_scheme',0,28,138,'en',0,'Overtime hours');
commit;

--
-- Table structure for table `node__field_overtime_pay`
--

CREATE TABLE `node__field_overtime_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_overtime_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_overtime_pay.';

--
-- Dumping data for table `node__field_overtime_pay`
--

set autocommit=0;
INSERT INTO `node__field_overtime_pay` VALUES ('data_scheme',0,28,138,'en',0,'Overtime pay');
commit;

--
-- Table structure for table `node__field_pay_date`
--

CREATE TABLE `node__field_pay_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pay_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_pay_date.';

--
-- Dumping data for table `node__field_pay_date`
--

set autocommit=0;
INSERT INTO `node__field_pay_date` VALUES ('data_scheme',0,28,138,'en',0,'Pay date'),('data_scheme',0,29,139,'en',0,'Period start date');
commit;

--
-- Table structure for table `node__field_pay_frequency`
--

CREATE TABLE `node__field_pay_frequency` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pay_frequency_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_pay_frequency.';

--
-- Dumping data for table `node__field_pay_frequency`
--

set autocommit=0;
INSERT INTO `node__field_pay_frequency` VALUES ('data_scheme',0,28,138,'en',0,'Pay frequency');
commit;

--
-- Table structure for table `node__field_pay_type`
--

CREATE TABLE `node__field_pay_type` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pay_type_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_pay_type.';

--
-- Dumping data for table `node__field_pay_type`
--

set autocommit=0;
INSERT INTO `node__field_pay_type` VALUES ('data_scheme',0,28,138,'en',0,'Pay type');
commit;

--
-- Table structure for table `node__field_paycheck_id`
--

CREATE TABLE `node__field_paycheck_id` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_paycheck_id_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_paycheck_id.';

--
-- Dumping data for table `node__field_paycheck_id`
--

set autocommit=0;
INSERT INTO `node__field_paycheck_id` VALUES ('data_scheme',0,15,93,'en',0,'pid'),('data_scheme',0,21,108,'en',0,'payidfield'),('data_scheme',0,22,109,'en',0,'test3'),('data_scheme',0,28,138,'en',0,'Paycheck ID'),('data_scheme',0,29,139,'en',0,'Paycheck ID');
commit;

--
-- Table structure for table `node__field_pension`
--

CREATE TABLE `node__field_pension` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pension_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_pension.';

--
-- Dumping data for table `node__field_pension`
--

set autocommit=0;
INSERT INTO `node__field_pension` VALUES ('data_scheme',0,28,138,'en',0,'Pension');
commit;

--
-- Table structure for table `node__field_period_end_date`
--

CREATE TABLE `node__field_period_end_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_period_end_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_period_end_date.';

--
-- Dumping data for table `node__field_period_end_date`
--

set autocommit=0;
INSERT INTO `node__field_period_end_date` VALUES ('data_scheme',0,28,138,'en',0,'Period end date'),('data_scheme',0,29,139,'en',0,'Period end date');
commit;

--
-- Table structure for table `node__field_period_start_date`
--

CREATE TABLE `node__field_period_start_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_period_start_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_period_start_date.';

--
-- Dumping data for table `node__field_period_start_date`
--

set autocommit=0;
INSERT INTO `node__field_period_start_date` VALUES ('data_scheme',0,28,138,'en',0,'Period start date'),('data_scheme',0,29,139,'en',0,'Period start date');
commit;

--
-- Table structure for table `node__field_position_fein`
--

CREATE TABLE `node__field_position_fein` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_fein_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_position_fein.';

--
-- Dumping data for table `node__field_position_fein`
--

set autocommit=0;
INSERT INTO `node__field_position_fein` VALUES ('data_scheme',0,28,138,'en',0,'Position FEIN');
commit;

--
-- Table structure for table `node__field_position_title`
--

CREATE TABLE `node__field_position_title` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_title_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_position_title.';

--
-- Dumping data for table `node__field_position_title`
--

set autocommit=0;
INSERT INTO `node__field_position_title` VALUES ('data_scheme',0,28,138,'en',0,'Position title');
commit;

--
-- Table structure for table `node__field_position_work_city`
--

CREATE TABLE `node__field_position_work_city` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_work_city_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_position_work_city.';

--
-- Dumping data for table `node__field_position_work_city`
--

set autocommit=0;
INSERT INTO `node__field_position_work_city` VALUES ('data_scheme',0,28,138,'en',0,'Position work city');
commit;

--
-- Table structure for table `node__field_position_work_state`
--

CREATE TABLE `node__field_position_work_state` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_work_state_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_position_work_state.';

--
-- Dumping data for table `node__field_position_work_state`
--

set autocommit=0;
INSERT INTO `node__field_position_work_state` VALUES ('data_scheme',0,28,138,'en',0,'Position work state');
commit;

--
-- Table structure for table `node__field_position_zip`
--

CREATE TABLE `node__field_position_zip` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_zip_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_position_zip.';

--
-- Dumping data for table `node__field_position_zip`
--

set autocommit=0;
INSERT INTO `node__field_position_zip` VALUES ('data_scheme',0,28,138,'en',0,'Position zip');
commit;

--
-- Table structure for table `node__field_rate_of_pay`
--

CREATE TABLE `node__field_rate_of_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_rate_of_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_rate_of_pay.';

--
-- Dumping data for table `node__field_rate_of_pay`
--

set autocommit=0;
INSERT INTO `node__field_rate_of_pay` VALUES ('data_scheme',0,28,138,'en',0,'Rate of pay');
commit;

--
-- Table structure for table `node__field_report_link`
--

CREATE TABLE `node__field_report_link` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_report_link_uri` varchar(2048) DEFAULT NULL COMMENT 'The URI of the link.',
  `field_report_link_title` varchar(255) DEFAULT NULL COMMENT 'The link text.',
  `field_report_link_options` longblob DEFAULT NULL COMMENT 'Serialized array of options for the link.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_report_link_uri` (`field_report_link_uri`(30))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_report_link.';

--
-- Dumping data for table `node__field_report_link`
--

set autocommit=0;
INSERT INTO `node__field_report_link` VALUES ('product',0,7,27,'en',0,'internal:/','Report Link','a:0:{}'),('product',0,8,28,'en',0,'internal:/','Report Link','a:0:{}'),('product',0,9,105,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,10,94,'en',0,'http://staging2.unemploymenttracker.com/sso?redirect=reports','','a:0:{}'),('product',0,11,104,'en',0,'https://staging-dev.clearverify.com/reports','','a:0:{}'),('product',0,12,106,'en',0,'https://www.cleari9.com/','','a:0:{}'),('product',0,13,107,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,14,82,'en',0,'https://wlcclient1.staging.refundd.com/reports','','a:0:{}');
commit;

--
-- Table structure for table `node__field_scheme_map`
--

CREATE TABLE `node__field_scheme_map` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_scheme_map_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_scheme_map_display` tinyint(3) unsigned DEFAULT 1 COMMENT 'Flag to control whether this file should be displayed when viewing content.',
  `field_scheme_map_description` text DEFAULT NULL COMMENT 'A description of the file.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_scheme_map_target_id` (`field_scheme_map_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_scheme_map.';

--
-- Dumping data for table `node__field_scheme_map`
--

set autocommit=0;
INSERT INTO `node__field_scheme_map` VALUES ('data_scheme',0,28,138,'en',0,35,1,''),('data_scheme',0,29,139,'en',0,36,1,'');
commit;

--
-- Table structure for table `node__field_severance`
--

CREATE TABLE `node__field_severance` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_severance_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_severance.';

--
-- Dumping data for table `node__field_severance`
--

set autocommit=0;
INSERT INTO `node__field_severance` VALUES ('data_scheme',0,28,138,'en',0,'Severance');
commit;

--
-- Table structure for table `node__field_shift_differential`
--

CREATE TABLE `node__field_shift_differential` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_shift_differential_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_shift_differential.';

--
-- Dumping data for table `node__field_shift_differential`
--

set autocommit=0;
INSERT INTO `node__field_shift_differential` VALUES ('data_scheme',0,28,138,'en',0,'Shift differential');
commit;

--
-- Table structure for table `node__field_sick_pay`
--

CREATE TABLE `node__field_sick_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_sick_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_sick_pay.';

--
-- Dumping data for table `node__field_sick_pay`
--

set autocommit=0;
INSERT INTO `node__field_sick_pay` VALUES ('data_scheme',0,28,138,'en',0,'Sick Pay');
commit;

--
-- Table structure for table `node__field_ssn`
--

CREATE TABLE `node__field_ssn` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_ssn_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_ssn.';

--
-- Dumping data for table `node__field_ssn`
--

set autocommit=0;
INSERT INTO `node__field_ssn` VALUES ('data_scheme',0,15,93,'en',0,'ssn'),('data_scheme',0,21,108,'en',0,'ssnfield'),('data_scheme',0,22,109,'en',0,'test'),('data_scheme',0,28,138,'en',0,'SSN'),('data_scheme',0,29,139,'en',0,'SSN');
commit;

--
-- Table structure for table `node__field_sso_link`
--

CREATE TABLE `node__field_sso_link` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_sso_link_uri` varchar(2048) DEFAULT NULL COMMENT 'The URI of the link.',
  `field_sso_link_title` varchar(255) DEFAULT NULL COMMENT 'The link text.',
  `field_sso_link_options` longblob DEFAULT NULL COMMENT 'Serialized array of options for the link.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_sso_link_uri` (`field_sso_link_uri`(30))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_sso_link.';

--
-- Dumping data for table `node__field_sso_link`
--

set autocommit=0;
INSERT INTO `node__field_sso_link` VALUES ('product',0,7,27,'en',0,'internal:/','SSO Link','a:0:{}'),('product',0,8,28,'en',0,'internal:/','SSO Link','a:0:{}'),('product',0,9,105,'en',0,'https://sstest.dashaca.com/SGAccount/redirect','','a:0:{}'),('product',0,10,94,'en',0,'https://staging2.unemploymenttracker.com/sso','','a:0:{}'),('product',0,11,104,'en',0,'https://api.8base.com/cl9fry8ht00e609iccsbz3vxk_devShadi/webhook/redirect','','a:0:{}'),('product',0,12,106,'en',0,'https://stage-admin.gryphonhr.com/ci9ssotest','','a:0:{}'),('product',0,13,107,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,14,82,'en',0,'https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect','','a:0:{}');
commit;

--
-- Table structure for table `node__field_state_withholding`
--

CREATE TABLE `node__field_state_withholding` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_state_withholding_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_state_withholding.';

--
-- Dumping data for table `node__field_state_withholding`
--

set autocommit=0;
INSERT INTO `node__field_state_withholding` VALUES ('data_scheme',0,28,138,'en',0,'State witholding');
commit;

--
-- Table structure for table `node__field_stock`
--

CREATE TABLE `node__field_stock` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_stock_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_stock.';

--
-- Dumping data for table `node__field_stock`
--

set autocommit=0;
INSERT INTO `node__field_stock` VALUES ('data_scheme',0,28,138,'en',0,'Stock');
commit;

--
-- Table structure for table `node__field_tags`
--

CREATE TABLE `node__field_tags` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_tags_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_tags_target_id` (`field_tags_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_tags.';

--
-- Dumping data for table `node__field_tags`
--

set autocommit=0;
commit;

--
-- Table structure for table `node__field_teaser_statement`
--

CREATE TABLE `node__field_teaser_statement` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_teaser_statement_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_teaser_statement.';

--
-- Dumping data for table `node__field_teaser_statement`
--

set autocommit=0;
INSERT INTO `node__field_teaser_statement` VALUES ('marketing',0,23,133,'en',0,'Integrate with HR Logics via our SFTP Server, allowing for automations and alleviated data upload burden');
commit;

--
-- Table structure for table `node__field_termination_date`
--

CREATE TABLE `node__field_termination_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_termination_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_termination_date.';

--
-- Dumping data for table `node__field_termination_date`
--

set autocommit=0;
INSERT INTO `node__field_termination_date` VALUES ('data_scheme',0,28,138,'en',0,'Termination date');
commit;

--
-- Table structure for table `node__field_tips`
--

CREATE TABLE `node__field_tips` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_tips_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_tips.';

--
-- Dumping data for table `node__field_tips`
--

set autocommit=0;
INSERT INTO `node__field_tips` VALUES ('data_scheme',0,28,138,'en',0,'Tips');
commit;

--
-- Table structure for table `node__field_vacation_pay`
--

CREATE TABLE `node__field_vacation_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_vacation_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for node field field_vacation_pay.';

--
-- Dumping data for table `node__field_vacation_pay`
--

set autocommit=0;
INSERT INTO `node__field_vacation_pay` VALUES ('data_scheme',0,28,138,'en',0,'Vacation pay');
commit;

--
-- Table structure for table `node_access`
--

CREATE TABLE `node_access` (
  `nid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The "node".nid this record affects.',
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The "language".langcode of this node.',
  `fallback` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT 'Boolean indicating whether this record should be used as a fallback if a language condition is not provided.',
  `gid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The grant ID a user must possess in the specified realm to gain this row''s privileges on the node.',
  `realm` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The realm in which the user must possess the grant ID. Modules can define one or more realms by implementing hook_node_grants().',
  `grant_view` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether a user with the realm/grant pair can view this node.',
  `grant_update` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether a user with the realm/grant pair can edit this node.',
  `grant_delete` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether a user with the realm/grant pair can delete this node.',
  PRIMARY KEY (`nid`,`gid`,`realm`,`langcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Identifies which realm/grant pairs a user must possess in…';

--
-- Dumping data for table `node_access`
--

set autocommit=0;
INSERT INTO `node_access` VALUES (0,'',1,0,'all',1,0,0);
commit;

--
-- Table structure for table `node_field_data`
--

CREATE TABLE `node_field_data` (
  `nid` int(10) unsigned NOT NULL,
  `vid` int(10) 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(4) NOT NULL,
  `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `title` varchar(255) NOT NULL,
  `created` int(11) NOT NULL,
  `changed` int(11) NOT NULL,
  `promote` tinyint(4) NOT NULL,
  `sticky` tinyint(4) NOT NULL,
  `default_langcode` tinyint(4) NOT NULL,
  `revision_translation_affected` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`nid`,`langcode`),
  KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`),
  KEY `node__vid` (`vid`),
  KEY `node_field__type__target_id` (`type`),
  KEY `node_field__uid__target_id` (`uid`),
  KEY `node_field__created` (`created`),
  KEY `node_field__changed` (`changed`),
  KEY `node__status_type` (`status`,`type`,`nid`),
  KEY `node__frontpage` (`promote`,`status`,`sticky`,`created`),
  KEY `node__title_type` (`title`(191),`type`(4))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The data table for node entities.';

--
-- Dumping data for table `node_field_data`
--

set autocommit=0;
INSERT INTO `node_field_data` VALUES (1,128,'article','en',1,1,'Test',1677855298,1682523287,1,0,1,1),(2,87,'page','en',1,1,'HR Logics',1678731238,1681408489,0,0,1,NULL),(3,111,'page','en',1,1,'Reporting',1678731274,1682444840,0,0,1,NULL),(4,131,'page','en',1,1,'Integrations',1678731292,1683224964,0,0,1,1),(5,130,'page','en',1,1,'Settings',1678731307,1682524618,0,0,1,1),(6,71,'page','en',1,1,'Marketplace',1678731323,1680196334,0,0,1,1),(7,27,'product','en',1,5,'Product 1',1679425000,1679425083,1,0,1,1),(8,28,'product','en',1,5,'Product 2',1679425090,1679425116,1,0,1,1),(9,105,'product','en',1,1,'SyncStream',1679505620,1682022282,1,0,1,1),(10,94,'product','en',1,1,'Unemployment Tracker',1679505643,1681912715,1,0,1,1),(11,104,'product','en',1,1,'Clear Verify',1679505669,1682022269,1,0,1,1),(12,106,'product','en',1,1,'Clear I9',1679505680,1682022289,1,0,1,1),(13,107,'product','en',1,1,'OnCentive Credit Connect',1679505712,1682022298,1,0,1,1),(14,82,'product','en',1,1,'ERC Connect',1679505739,1681317217,1,0,1,1),(15,93,'data_scheme','en',1,5,'Test Scheme',1681850650,1681850681,1,0,1,1),(16,142,'page','en',0,5,'Manage Users',1682005899,1685563198,0,0,1,NULL),(17,143,'page','en',0,5,'Data Schemes',1682005931,1685563209,0,0,1,NULL),(18,97,'page','en',0,5,'Clients',1682005951,1682006386,0,0,1,1),(19,141,'page','en',1,5,'Company Information',1682006430,1685563186,0,0,1,NULL),(20,140,'page','en',1,5,'Profile Information',1682006469,1685563170,0,0,1,NULL),(21,108,'data_scheme','en',1,1,'Test Scheme Alpha',1682355417,1682355447,1,0,1,1),(22,109,'data_scheme','en',1,1,'Test Scheme Beta',1682358195,1682358225,1,0,1,1),(23,133,'marketing','en',1,1,'HR Logics',1683654917,1683728693,0,0,1,NULL),(28,138,'data_scheme','en',1,35,'test',1684490660,1684490660,0,0,1,1),(29,139,'data_scheme','en',1,35,'test2',1684491189,1684491189,0,0,1,1);
commit;

--
-- Table structure for table `node_field_revision`
--

CREATE TABLE `node_field_revision` (
  `nid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `status` tinyint(4) NOT NULL,
  `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `title` varchar(255) DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `changed` int(11) DEFAULT NULL,
  `promote` tinyint(4) DEFAULT NULL,
  `sticky` tinyint(4) DEFAULT NULL,
  `default_langcode` tinyint(4) NOT NULL,
  `revision_translation_affected` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`vid`,`langcode`),
  KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`),
  KEY `node_field__uid__target_id` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The revision data table for node entities.';

--
-- Dumping data for table `node_field_revision`
--

set autocommit=0;
INSERT INTO `node_field_revision` VALUES (1,1,'en',1,1,'Test',1677855298,1677855320,1,0,1,1),(1,2,'en',1,1,'Test',1677855298,1678113507,1,0,1,1),(1,3,'en',1,1,'Test',1677855298,1678195991,1,0,1,1),(1,4,'en',1,1,'Test',1677855298,1678196098,1,0,1,1),(2,5,'en',1,1,'Tools',1678731238,1678731261,0,0,1,1),(3,6,'en',1,1,'Unified Reporting',1678731274,1678731287,0,0,1,1),(4,7,'en',1,1,'Integrations',1678731292,1678731303,0,0,1,1),(5,8,'en',1,1,'Settings',1678731307,1678731317,0,0,1,1),(6,9,'en',1,1,'Marketplace',1678731323,1678731331,0,0,1,1),(5,10,'en',1,1,'Settings',1678731307,1678731434,0,0,1,NULL),(6,11,'en',1,1,'Marketplace',1678731323,1678731442,0,0,1,NULL),(1,12,'en',1,1,'Test',1677855298,1678797628,1,0,1,1),(1,13,'en',1,1,'Test',1677855298,1678797636,1,0,1,1),(1,14,'en',1,1,'Test',1677855298,1678817724,1,0,1,1),(1,15,'en',1,1,'Test',1677855298,1678817903,1,0,1,1),(1,16,'en',1,1,'Test',1677855298,1678985008,1,0,1,1),(4,17,'en',1,1,'Integrations',1678731292,1679317948,0,0,1,NULL),(5,18,'en',0,1,'Settings',1678731307,1679317965,0,0,1,1),(5,19,'en',0,1,'Settings',1678731307,1679317975,0,0,1,NULL),(4,20,'en',0,1,'Integrations',1678731292,1679317983,0,0,1,1),(6,21,'en',0,1,'Marketplace',1678731323,1679317990,0,0,1,1),(2,22,'en',1,1,'Tools',1678731238,1679344480,0,0,1,1),(2,23,'en',1,1,'Tools',1678731238,1679344624,0,0,1,1),(2,24,'en',1,1,'HR Logics',1678731238,1679345608,0,0,1,1),(2,25,'en',1,1,'HR Logics',1678731238,1679419022,0,0,1,1),(3,26,'en',1,1,'Unified Reporting',1678731274,1679421471,0,0,1,1),(7,27,'en',1,5,'Product 1',1679425000,1679425083,1,0,1,1),(8,28,'en',1,5,'Product 2',1679425090,1679425116,1,0,1,1),(9,29,'en',1,1,'SyncStream',1679505620,1679505632,1,0,1,1),(10,30,'en',1,1,'Unemployment Traker',1679505643,1679505655,1,0,1,1),(11,31,'en',1,1,'Clear Verify',1679505669,1679505673,1,0,1,1),(12,32,'en',1,1,'Clear I9',1679505680,1679505689,1,0,1,1),(13,33,'en',1,1,'OnCentive Credit Connect',1679505712,1679505720,1,0,1,1),(14,34,'en',1,1,'ERC Connect',1679505739,1679505742,1,0,1,1),(2,35,'en',1,1,'HR Logics',1678731238,1679510696,0,0,1,1),(1,36,'en',1,1,'Test',1677855298,1679517096,1,0,1,1),(12,37,'en',1,1,'Clear I9',1679505680,1679691600,1,0,1,1),(12,38,'en',1,1,'Clear I9',1679505680,1679691618,1,0,1,1),(14,39,'en',1,1,'ERC Connect',1679505739,1679691636,1,0,1,1),(13,40,'en',1,1,'OnCentive Credit Connect',1679505712,1679691651,1,0,1,1),(9,41,'en',1,1,'SyncStream',1679505620,1679691661,1,0,1,1),(10,42,'en',1,1,'Unemployment Traker',1679505643,1679691672,1,0,1,1),(11,43,'en',1,1,'Clear Verify',1679505669,1679691684,1,0,1,1),(11,44,'en',1,1,'Clear Verify',1679505669,1679952243,1,0,1,1),(14,45,'en',1,1,'ERC Connect',1679505739,1679952270,1,0,1,1),(10,46,'en',1,1,'Unemployment Traker',1679505643,1679952295,1,0,1,1),(1,47,'en',1,1,'Test',1677855298,1680101316,1,0,1,1),(1,48,'en',1,1,'Test',1677855298,1680105278,1,0,1,1),(1,49,'en',1,1,'Test',1677855298,1680105348,1,0,1,1),(14,50,'en',1,1,'ERC Connect',1679505739,1680184815,1,0,1,1),(12,51,'en',1,1,'Clear I9',1679505680,1680184903,1,0,1,1),(10,52,'en',1,1,'Unemployment Traker',1679505643,1680184907,1,0,1,1),(12,53,'en',1,1,'Clear I9',1679505680,1680185194,1,0,1,1),(9,54,'en',1,1,'SyncStream',1679505620,1680185413,1,0,1,1),(14,55,'en',1,1,'ERC Connect',1679505739,1680185610,1,0,1,1),(14,56,'en',1,1,'ERC Connect',1679505739,1680185643,1,0,1,1),(14,57,'en',1,1,'ERC Connect',1679505739,1680185790,1,0,1,1),(10,58,'en',1,1,'Unemployment Tracker',1679505643,1680185816,1,0,1,1),(2,59,'en',1,1,'HR Logics',1678731238,1680190108,0,0,1,1),(2,60,'en',1,1,'HR Logics',1678731238,1680190283,0,0,1,1),(2,61,'en',1,1,'HR Logics',1678731238,1680190378,0,0,1,1),(2,62,'en',1,1,'HR Logics',1678731238,1680191087,0,0,1,1),(11,63,'en',1,1,'Clear Verify',1679505669,1680191878,1,0,1,1),(10,64,'en',1,1,'Unemployment Tracker',1679505643,1680192793,1,0,1,1),(10,65,'en',1,1,'Unemployment Tracker',1679505643,1680193334,1,0,1,NULL),(11,66,'en',1,1,'Clear Verify',1679505669,1680194342,1,0,1,1),(3,67,'en',1,1,'Reporting',1678731274,1680194777,0,0,1,1),(3,68,'en',1,1,'Reporting',1678731274,1680194807,0,0,1,1),(3,69,'en',1,1,'Reporting',1678731274,1680195406,0,0,1,1),(10,70,'en',1,1,'Unemployment Tracker',1679505643,1680195657,1,0,1,1),(6,71,'en',1,1,'Marketplace',1678731323,1680196334,0,0,1,1),(1,72,'en',1,1,'Test',1677855298,1680279565,1,0,1,1),(1,73,'en',1,1,'Test',1677855298,1680280454,1,0,1,1),(1,74,'en',1,1,'Test',1677855298,1680446065,1,0,1,1),(1,75,'en',1,1,'Test',1677855298,1680605512,1,0,1,1),(1,76,'en',1,1,'Test',1677855298,1680791854,1,0,1,1),(1,77,'en',1,1,'Test',1677855298,1680791878,1,0,1,1),(12,78,'en',1,1,'Clear I9',1679505680,1681150465,1,0,1,1),(9,79,'en',1,1,'SyncStream',1679505620,1681150477,1,0,1,1),(11,80,'en',1,1,'Clear Verify',1679505669,1681150489,1,0,1,1),(10,81,'en',1,1,'Unemployment Tracker',1679505643,1681150498,1,0,1,1),(14,82,'en',1,1,'ERC Connect',1679505739,1681317217,1,0,1,1),(13,83,'en',1,1,'OnCentive Credit Connect',1679505712,1681317242,1,0,1,1),(1,84,'en',1,1,'Test',1677855298,1681398150,1,0,1,1),(1,85,'en',1,1,'Test',1677855298,1681402776,1,0,1,1),(1,86,'en',1,1,'Test',1677855298,1681402830,1,0,1,1),(2,87,'en',1,1,'HR Logics',1678731238,1681408489,0,0,1,NULL),(3,88,'en',1,1,'Reporting',1678731274,1681475182,0,0,1,1),(11,89,'en',1,1,'Clear Verify',1679505669,1681838487,1,0,1,1),(9,90,'en',1,1,'SyncStream',1679505620,1681838502,1,0,1,1),(12,91,'en',1,1,'Clear I9',1679505680,1681838523,1,0,1,1),(13,92,'en',1,1,'OnCentive Credit Connect',1679505712,1681838595,1,0,1,1),(15,93,'en',1,5,'Test Scheme',1681850650,1681850681,1,0,1,1),(10,94,'en',1,1,'Unemployment Tracker',1679505643,1681912715,1,0,1,1),(16,95,'en',0,5,'Manage Users',1682005899,1682005926,0,0,1,1),(17,96,'en',0,5,'Data Schemes',1682005931,1682005941,0,0,1,1),(18,97,'en',0,5,'Clients',1682005951,1682006386,0,0,1,1),(19,98,'en',0,5,'Company Information',1682006430,1682006465,0,0,1,1),(20,99,'en',0,5,'Profile Information',1682006469,1682006482,0,0,1,1),(13,100,'en',1,1,'OnCentive Credit Connect',1679505712,1682022165,1,0,1,1),(12,101,'en',1,1,'Clear I9',1679505680,1682022167,1,0,1,1),(9,102,'en',1,1,'SyncStream',1679505620,1682022170,1,0,1,1),(11,103,'en',1,1,'Clear Verify',1679505669,1682022172,1,0,1,1),(11,104,'en',1,1,'Clear Verify',1679505669,1682022269,1,0,1,1),(9,105,'en',1,1,'SyncStream',1679505620,1682022282,1,0,1,1),(12,106,'en',1,1,'Clear I9',1679505680,1682022289,1,0,1,1),(13,107,'en',1,1,'OnCentive Credit Connect',1679505712,1682022298,1,0,1,1),(21,108,'en',1,1,'Test Scheme Alpha',1682355417,1682355447,1,0,1,1),(22,109,'en',1,1,'Test Scheme Beta',1682358195,1682358225,1,0,1,1),(5,110,'en',1,1,'Settings',1678731307,1682444764,0,0,1,1),(3,111,'en',1,1,'Reporting',1678731274,1682444840,0,0,1,NULL),(20,112,'en',1,5,'Profile Information',1682006469,1682455177,0,0,1,1),(1,113,'en',1,1,'Test',1677855298,1682514597,1,0,1,1),(1,114,'en',1,1,'Test',1677855298,1682514870,1,0,1,1),(19,115,'en',1,5,'Company Information',1682006430,1682517000,0,0,1,1),(1,116,'en',1,1,'Test',1677855298,1682518372,1,0,1,1),(1,117,'en',1,1,'Test',1677855298,1682518406,1,0,1,1),(1,118,'en',1,1,'Test',1677855298,1682519081,1,0,1,1),(1,119,'en',1,1,'Test',1677855298,1682519610,1,0,1,1),(1,120,'en',1,1,'Test',1677855298,1682519651,1,0,1,1),(1,121,'en',1,1,'Test',1677855298,1682519738,1,0,1,1),(1,122,'en',1,1,'Test',1677855298,1682520467,1,0,1,1),(1,123,'en',1,1,'Test',1677855298,1682520495,1,0,1,1),(1,124,'en',1,1,'Test',1677855298,1682521063,1,0,1,1),(1,125,'en',1,1,'Test',1677855298,1682521224,1,0,1,1),(1,126,'en',1,1,'Test',1677855298,1682522577,1,0,1,1),(1,127,'en',1,1,'Test',1677855298,1682523227,1,0,1,1),(1,128,'en',1,1,'Test',1677855298,1682523287,1,0,1,1),(20,129,'en',1,5,'Profile Information',1682006469,1682524602,0,0,1,NULL),(5,130,'en',1,1,'Settings',1678731307,1682524618,0,0,1,1),(4,131,'en',1,1,'Integrations',1678731292,1683224964,0,0,1,1),(23,132,'en',1,1,'HR Logics',1683654917,1683655100,0,0,1,1),(23,133,'en',1,1,'HR Logics',1683654917,1683728693,0,0,1,NULL),(28,138,'en',1,35,'test',1684490660,1684490660,0,0,1,1),(29,139,'en',1,35,'test2',1684491189,1684491189,0,0,1,1),(20,140,'en',1,5,'Profile Information',1682006469,1685563170,0,0,1,NULL),(19,141,'en',1,5,'Company Information',1682006430,1685563186,0,0,1,NULL),(16,142,'en',0,5,'Manage Users',1682005899,1685563198,0,0,1,NULL),(17,143,'en',0,5,'Data Schemes',1682005931,1685563209,0,0,1,NULL);
commit;

--
-- Table structure for table `node_revision`
--

CREATE TABLE `node_revision` (
  `nid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `revision_uid` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.',
  `revision_timestamp` int(11) DEFAULT NULL,
  `revision_log` longtext DEFAULT NULL,
  `revision_default` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`vid`),
  KEY `node__nid` (`nid`),
  KEY `node_field__langcode` (`langcode`),
  KEY `node_field__revision_uid__target_id` (`revision_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The revision table for node entities.';

--
-- Dumping data for table `node_revision`
--

set autocommit=0;
INSERT INTO `node_revision` VALUES (1,1,'en',1,1677855320,NULL,1),(1,2,'en',3,1678113507,NULL,1),(1,3,'en',3,1678195991,NULL,1),(1,4,'en',3,1678196098,NULL,1),(2,5,'en',1,1678731261,NULL,1),(3,6,'en',1,1678731287,NULL,1),(4,7,'en',1,1678731303,NULL,1),(5,8,'en',1,1678731317,NULL,1),(6,9,'en',1,1678731331,NULL,1),(5,10,'en',1,1678731434,NULL,1),(6,11,'en',1,1678731442,NULL,1),(1,12,'en',3,1678797628,NULL,1),(1,13,'en',3,1678797636,NULL,1),(1,14,'en',3,1678817724,NULL,1),(1,15,'en',3,1678817903,NULL,1),(1,16,'en',3,1678985008,NULL,1),(4,17,'en',1,1679317948,NULL,1),(5,18,'en',1,1679317965,NULL,1),(5,19,'en',1,1679317975,NULL,1),(4,20,'en',1,1679317983,NULL,1),(6,21,'en',1,1679317990,NULL,1),(2,22,'en',1,1679344480,NULL,1),(2,23,'en',1,1679344624,NULL,1),(2,24,'en',1,1679345608,NULL,1),(2,25,'en',1,1679419022,NULL,1),(3,26,'en',1,1679421471,NULL,1),(7,27,'en',5,1679425083,NULL,1),(8,28,'en',5,1679425116,NULL,1),(9,29,'en',1,1679505632,NULL,1),(10,30,'en',1,1679505655,NULL,1),(11,31,'en',1,1679505673,NULL,1),(12,32,'en',1,1679505689,NULL,1),(13,33,'en',1,1679505720,NULL,1),(14,34,'en',1,1679505742,NULL,1),(2,35,'en',1,1679510696,NULL,1),(1,36,'en',3,1679517096,NULL,1),(12,37,'en',1,1679691600,NULL,1),(12,38,'en',1,1679691618,NULL,1),(14,39,'en',1,1679691636,NULL,1),(13,40,'en',1,1679691651,NULL,1),(9,41,'en',1,1679691661,NULL,1),(10,42,'en',1,1679691672,NULL,1),(11,43,'en',1,1679691684,NULL,1),(11,44,'en',1,1679952243,NULL,1),(14,45,'en',1,1679952270,NULL,1),(10,46,'en',1,1679952295,NULL,1),(1,47,'en',3,1680101316,NULL,1),(1,48,'en',1,1680105278,NULL,1),(1,49,'en',1,1680105348,NULL,1),(14,50,'en',17,1680184815,NULL,1),(12,51,'en',4,1680184903,NULL,1),(10,52,'en',17,1680184907,NULL,1),(12,53,'en',4,1680185194,NULL,1),(9,54,'en',17,1680185413,NULL,1),(14,55,'en',17,1680185610,NULL,1),(14,56,'en',17,1680185643,NULL,1),(14,57,'en',17,1680185790,NULL,1),(10,58,'en',4,1680185816,NULL,1),(2,59,'en',4,1680190108,NULL,1),(2,60,'en',4,1680190283,NULL,1),(2,61,'en',4,1680190378,NULL,1),(2,62,'en',4,1680191087,NULL,1),(11,63,'en',17,1680191878,NULL,1),(10,64,'en',4,1680192793,NULL,1),(10,65,'en',4,1680193334,NULL,1),(11,66,'en',4,1680194342,NULL,1),(3,67,'en',18,1680194777,NULL,1),(3,68,'en',18,1680194807,NULL,1),(3,69,'en',18,1680195406,NULL,1),(10,70,'en',18,1680195657,NULL,1),(6,71,'en',18,1680196334,'Copy of the revision from <em class=\"placeholder\">Mon, 03/13/2023 - 14:15</em>.',1),(1,72,'en',3,1680279565,NULL,1),(1,73,'en',3,1680280454,NULL,1),(1,74,'en',3,1680446065,NULL,1),(1,75,'en',3,1680605512,NULL,1),(1,76,'en',3,1680791854,NULL,1),(1,77,'en',3,1680791878,NULL,1),(12,78,'en',1,1681150465,NULL,1),(9,79,'en',1,1681150477,NULL,1),(11,80,'en',1,1681150489,NULL,1),(10,81,'en',1,1681150498,NULL,1),(14,82,'en',1,1681317217,NULL,1),(13,83,'en',1,1681317242,NULL,1),(1,84,'en',3,1681398150,NULL,1),(1,85,'en',3,1681402776,NULL,1),(1,86,'en',3,1681402830,NULL,1),(2,87,'en',1,1681408489,NULL,1),(3,88,'en',1,1681475182,NULL,1),(11,89,'en',1,1681838487,NULL,1),(9,90,'en',1,1681838502,NULL,1),(12,91,'en',1,1681838523,NULL,1),(13,92,'en',1,1681838595,NULL,1),(15,93,'en',5,1681850681,NULL,1),(10,94,'en',1,1681912715,NULL,1),(16,95,'en',5,1682005926,NULL,1),(17,96,'en',5,1682005941,NULL,1),(18,97,'en',5,1682006386,NULL,1),(19,98,'en',5,1682006465,NULL,1),(20,99,'en',5,1682006482,NULL,1),(13,100,'en',1,1682022165,NULL,1),(12,101,'en',1,1682022167,NULL,1),(9,102,'en',1,1682022170,NULL,1),(11,103,'en',1,1682022172,NULL,1),(11,104,'en',1,1682022269,NULL,1),(9,105,'en',1,1682022282,NULL,1),(12,106,'en',1,1682022289,NULL,1),(13,107,'en',1,1682022298,NULL,1),(21,108,'en',1,1682355447,NULL,1),(22,109,'en',1,1682358225,NULL,1),(5,110,'en',1,1682444764,NULL,1),(3,111,'en',1,1682444840,NULL,1),(20,112,'en',1,1682455177,NULL,1),(1,113,'en',3,1682514597,NULL,1),(1,114,'en',3,1682514870,NULL,1),(19,115,'en',1,1682517000,NULL,1),(1,116,'en',3,1682518372,NULL,1),(1,117,'en',3,1682518406,NULL,1),(1,118,'en',3,1682519081,NULL,1),(1,119,'en',3,1682519610,NULL,1),(1,120,'en',3,1682519651,NULL,1),(1,121,'en',3,1682519738,NULL,1),(1,122,'en',3,1682520467,NULL,1),(1,123,'en',3,1682520495,NULL,1),(1,124,'en',3,1682521063,NULL,1),(1,125,'en',3,1682521224,NULL,1),(1,126,'en',3,1682522577,NULL,1),(1,127,'en',3,1682523227,NULL,1),(1,128,'en',3,1682523287,NULL,1),(20,129,'en',1,1682524602,NULL,1),(5,130,'en',1,1682524618,NULL,1),(4,131,'en',1,1683224964,NULL,1),(23,132,'en',1,1683655100,NULL,1),(23,133,'en',1,1683728693,NULL,1),(28,138,'en',35,1684490660,NULL,1),(29,139,'en',35,1684491189,NULL,1),(20,140,'en',1,1685563170,NULL,1),(19,141,'en',1,1685563186,NULL,1),(16,142,'en',1,1685563198,NULL,1),(17,143,'en',1,1685563209,NULL,1);
commit;

--
-- Table structure for table `node_revision__body`
--

CREATE TABLE `node_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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `body_value` longtext NOT NULL,
  `body_summary` longtext DEFAULT NULL,
  `body_format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `body_format` (`body_format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field body.';

--
-- Dumping data for table `node_revision__body`
--

set autocommit=0;
INSERT INTO `node_revision__body` VALUES ('article',0,1,1,'en',0,'<p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p>','','basic_html'),('article',0,1,2,'en',0,'<p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p><a href=\"http://localhost:46794/SGAccount/SSLogin\">http://localhost:46794/SGAccount/SSLogin</a></p>','','basic_html'),('article',0,1,3,'en',0,'<p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p><a href=\"http://localhost:46794/SGAccount/SSLogin\">http://localhost:46794/SGAccount/</a>redirect</p>','','basic_html'),('article',0,1,4,'en',0,'<p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p><a href=\"http://localhost:46794/SGAccount/redirect\">http://localhost:46794/SGAccount/redirect</a></p>','','basic_html'),('article',0,1,12,'en',0,'<p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream</strong></p><p><a href=\"http://localhost:46794/SGAccount/redirect\">http://localhost:46794/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"http://localhost:3000/dashboard\">http://localhost:3000/dashboard</a></p>','','basic_html'),('article',0,1,13,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream</strong></p><p><a href=\"http://localhost:46794/SGAccount/redirect\">http://localhost:46794/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"http://localhost:3000/dashboard\">http://localhost:3000/dashboard</a></p>','','basic_html'),('article',0,1,14,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream</strong></p><p><a href=\"http://localhost:46794/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"http://localhost:3000/dashboard\">http://localhost:3000/dashboard</a></p>','','basic_html'),('article',0,1,15,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"http://localhost:3000/dashboard\">http://localhost:3000/dashboard</a></p>','','basic_html'),('article',0,1,16,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"http://localhost:3000/auth/login\">http://localhost:3000/auth/login</a></p>','','basic_html'),('article',0,1,36,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com\">https://qa3-dev-erc.oncentive.com</a></p>','','basic_html'),('article',0,1,47,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/redirect\">https://staging2.unemploymenttracker.com/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.comSGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com\">https://qa3-dev-erc.oncentive.com</a></p>','','basic_html'),('article',0,1,48,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.comSGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com\">https://qa3-dev-erc.oncentive.com</a></p>','','basic_html'),('article',0,1,49,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.comSGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com\">https://qa3-dev-erc.oncentive.com</a></p>','','basic_html'),('article',0,1,72,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.comSGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>ERC</strong></p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\">Take me to ERC</a></p>','','basic_html'),('article',0,1,73,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.comSGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>Take me to ERC</strong></a></p>','','basic_html'),('article',0,1,74,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.comSGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,75,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,76,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:5709/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,77,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local</strong></p><p><a href=\"http://localhost:5709/SGAccount/redirect\">http://localhost:5709/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,84,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><strong>SyncStream local -new</strong></p><p><a href=\"http://localhost:5709/SGAccount/redirect\">http://localhost:5709/SGAccount/redirect</a></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>SyncStream local -old</strong></p><p><a href=\"http://localhost:46795/SGAccount/redirect\">http://localhost:46795/SGAccount/redirect</a></p><p>&nbsp;</p><p><strong>SyncStream UAT</strong></p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\">https://sstest.dashaca.com/redirect</a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,85,'en',0,'<p>&nbsp;</p><p><strong>Unemployment Tracker</strong></p><p><a href=\"https://staging2.unemploymenttracker.com/sso\">https://staging2.unemploymenttracker.com/sso</a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>SyncStream local -new</strong></p><p><a href=\"http://localhost:5709/SGAccount/redirect\">http://localhost:5709/SGAccount/redirect</a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,86,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,113,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https%3A%2F%2Fdrupal.unemploymenttracker.com%2F\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,114,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,116,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://Fhrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,117,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,118,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,119,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC)</strong></p>','','basic_html'),('article',0,1,120,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC)</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC)</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC)</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/</strong></p>','','basic_html'),('article',0,1,121,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC) &nbsp;hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC) - hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - 8base client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/</strong></p>','','basic_html'),('article',0,1,122,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC) &nbsp;hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC) - hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - 8base client</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/</strong></a></p><p>&nbsp;</p><p>&nbsp;</p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - Straight to ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>https://qa3-dev-erc.oncentive.com/auth/login</strong></a></p>','','basic_html'),('article',0,1,123,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:46795/SGAccount/redirect\"><strong>SyncStream local -old</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC) &nbsp;hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC) - hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - 8base client</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/</strong></a></p><p>&nbsp;</p><p>&nbsp;</p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - Straight to ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>https://qa3-dev-erc.oncentive.com</strong></a></p>','','basic_html'),('article',0,1,124,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC) &nbsp;hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC) - hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong> (using Cognito OIDC) - 8base client</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/</strong></a></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize\"><strong>ERC</strong></a><strong> (using Cognito OIDC) - Redirect through Cognito</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://</strong></a><strong>hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize</strong></p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - Straight to ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>https://qa3-dev-erc.oncentive.com</strong></a></p>','','basic_html'),('article',0,1,125,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com\"><strong>ERC</strong></a><strong> (using Cognito OIDC) &nbsp;hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/\"><strong>ERC</strong></a><strong>2 (using Cognito OIDC) - hr-logics client</strong></p><p><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://qa3-dev-erc.oncentive.com/</strong></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>ERC</strong></a><strong> (using Cognito OIDC) - 8base client</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/</strong></a></p><p>&nbsp;</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize\"><strong>ERC</strong></a><strong> (using Cognito OIDC) - Redirect through Cognito</strong></p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hrlogics.us.auth0.com/\"><strong>https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://</strong></a><strong>hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize</strong></p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>ERC</strong></a><strong>3 (using Cognito OIDC) - Straight to ERC</strong></p><p><a href=\"https://qa3-dev-erc.oncentive.com/auth/login\"><strong>https://qa3-dev-erc.oncentive.com</strong></a></p>','','basic_html'),('article',0,1,126,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>ERC - Cognito/hr-logics</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p>','','basic_html'),('article',0,1,127,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>ERC - Cognito/hr-logics</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p><p>&nbsp;</p><p>&nbsp;</p><p>ERC - 8base client</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p>','','basic_html'),('article',0,1,128,'en',0,'<p>&nbsp;</p><p><a href=\"https://staging2.unemploymenttracker.com/sso\"><strong>Unemployment Tracker</strong></a></p><p>&nbsp;</p><p><a href=\"https://sstest.dashaca.com/SGAccount/redirect\"><strong>SyncStream UAT</strong></a></p><p>&nbsp;</p><p><a href=\"http://localhost:5709/SGAccount/redirect\"><strong>SyncStream local -new</strong></a></p><p>&nbsp;</p><p><a href=\"https://api.8base.com/cl797ro65013809l71adq1itm_qa3/webhook/redirect\"><strong>ERC</strong></a><strong> (using custom endpoints)</strong></p><p>ERC - Cognito/hr-logics</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p><p>&nbsp;</p><p>&nbsp;</p><p>ERC - 8base client</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=4kgn1bh9ghi73h7cbonq8rsd3f&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/idpresponse</a></p><p>&nbsp;</p><p>ERC - hr-logics w/auth0 redirect</p><p><a href=\"https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize\">https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize?client_id=2g1d1thqqofpoe5tq3kbaof3pa&amp;response_type=code&amp;scope=email+openid&amp;redirect_uri=https://hr-logics-test.auth.us-east-1.amazoncognito.com/oauth2/authorize</a></p>','','basic_html'),('page',0,2,5,'en',0,'<p>Tools</p>','','basic_html'),('page',0,2,22,'en',0,'<p>Tools</p>','','basic_html'),('page',0,2,23,'en',0,'<p>Tools</p>','','basic_html'),('page',0,2,24,'en',0,'<p>HR Logics</p>','','basic_html'),('page',0,2,25,'en',0,'<p>HR Logics</p>','','basic_html'),('page',0,3,6,'en',0,'<p>Unified Reporting</p>','','basic_html'),('page',0,3,26,'en',0,'<p>Connecting best-in-class compliance technologies</p>','','basic_html'),('page',0,3,67,'en',0,'<p>Connecting best-in-class compliance technologies</p>','','basic_html'),('page',0,3,68,'en',0,'<p>Access All Your Reporting in One Place</p>','','basic_html'),('page',0,3,69,'en',0,'<p>Unified Reporting</p>','','basic_html'),('page',0,3,88,'en',0,'<p>Overview of Key Compliance Metrics</p>','','basic_html'),('page',0,3,111,'en',0,'<p>Overview of Key Compliance Metrics</p>','','basic_html'),('page',0,4,7,'en',0,'<p>Integrations</p>','','basic_html'),('page',0,4,17,'en',0,'<p>Integrations</p>','','basic_html'),('page',0,4,20,'en',0,'<p>Integrations</p>','','basic_html'),('page',0,4,131,'en',0,'<p>Integrations</p>','','basic_html'),('page',0,5,8,'en',0,'<p>Settings</p>','','basic_html'),('page',0,5,10,'en',0,'<p>Settings</p>','','basic_html'),('page',0,5,18,'en',0,'<p>Settings</p>','','basic_html'),('page',0,5,19,'en',0,'<p>Settings</p>','','basic_html'),('page',0,5,110,'en',0,'<p>Settings</p>','','basic_html'),('page',0,6,9,'en',0,'<p>Marketplace</p>','','basic_html'),('page',0,6,11,'en',0,'<p>Marketplace</p>','','basic_html'),('page',0,6,21,'en',0,'<p>Marketplace</p>','','basic_html'),('page',0,6,71,'en',0,'<p>Marketplace</p>','','basic_html');
commit;

--
-- Table structure for table `node_revision__comment`
--

CREATE TABLE `node_revision__comment` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `comment_status` int(11) NOT NULL DEFAULT 0 COMMENT 'Whether comments are allowed on this entity: 0 = no, 1 = closed (read only), 2 = open (read/write).',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field comment.';

--
-- Dumping data for table `node_revision__comment`
--

set autocommit=0;
INSERT INTO `node_revision__comment` VALUES ('article',0,1,1,'en',0,2),('article',0,1,2,'en',0,2),('article',0,1,3,'en',0,2),('article',0,1,4,'en',0,2),('article',0,1,12,'en',0,2),('article',0,1,13,'en',0,2),('article',0,1,14,'en',0,2),('article',0,1,15,'en',0,2),('article',0,1,16,'en',0,2),('article',0,1,36,'en',0,2),('article',0,1,47,'en',0,2),('article',0,1,48,'en',0,2),('article',0,1,49,'en',0,2),('article',0,1,72,'en',0,2),('article',0,1,73,'en',0,2),('article',0,1,74,'en',0,2),('article',0,1,75,'en',0,2),('article',0,1,76,'en',0,2),('article',0,1,77,'en',0,2),('article',0,1,84,'en',0,2),('article',0,1,85,'en',0,2),('article',0,1,86,'en',0,2),('article',0,1,113,'en',0,2),('article',0,1,114,'en',0,2),('article',0,1,116,'en',0,2),('article',0,1,117,'en',0,2),('article',0,1,118,'en',0,2),('article',0,1,119,'en',0,2),('article',0,1,120,'en',0,2),('article',0,1,121,'en',0,2),('article',0,1,122,'en',0,2),('article',0,1,123,'en',0,2),('article',0,1,124,'en',0,2),('article',0,1,125,'en',0,2),('article',0,1,126,'en',0,2),('article',0,1,127,'en',0,2),('article',0,1,128,'en',0,2);
commit;

--
-- Table structure for table `node_revision__field_base_pay`
--

CREATE TABLE `node_revision__field_base_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_base_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_base_pay.';

--
-- Dumping data for table `node_revision__field_base_pay`
--

set autocommit=0;
INSERT INTO `node_revision__field_base_pay` VALUES ('data_scheme',0,28,138,'en',0,'Base pay');
commit;

--
-- Table structure for table `node_revision__field_bonus_pay`
--

CREATE TABLE `node_revision__field_bonus_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_bonus_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_bonus_pay.';

--
-- Dumping data for table `node_revision__field_bonus_pay`
--

set autocommit=0;
INSERT INTO `node_revision__field_bonus_pay` VALUES ('data_scheme',0,28,138,'en',0,'Bonus pay');
commit;

--
-- Table structure for table `node_revision__field_commission_pay`
--

CREATE TABLE `node_revision__field_commission_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_commission_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_commission…';

--
-- Dumping data for table `node_revision__field_commission_pay`
--

set autocommit=0;
INSERT INTO `node_revision__field_commission_pay` VALUES ('data_scheme',0,28,138,'en',0,'Commission pay');
commit;

--
-- Table structure for table `node_revision__field_content`
--

CREATE TABLE `node_revision__field_content` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_content_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `field_content_target_revision_id` int(10) unsigned NOT NULL COMMENT 'The revision ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_content_target_id` (`field_content_target_id`),
  KEY `field_content_target_revision_id` (`field_content_target_revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_content.';

--
-- Dumping data for table `node_revision__field_content`
--

set autocommit=0;
INSERT INTO `node_revision__field_content` VALUES ('page',0,2,22,'en',0,15,15),('page',0,2,23,'en',0,15,19),('page',0,2,24,'en',0,15,23),('page',0,2,25,'en',0,15,27),('page',0,2,35,'en',0,15,31),('page',0,2,59,'en',0,15,35),('page',0,2,60,'en',0,15,39),('page',0,2,61,'en',0,15,43),('page',0,2,62,'en',0,15,47),('page',0,2,87,'en',0,15,51);
commit;

--
-- Table structure for table `node_revision__field_demo_link`
--

CREATE TABLE `node_revision__field_demo_link` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_demo_link_uri` varchar(2048) DEFAULT NULL COMMENT 'The URI of the link.',
  `field_demo_link_title` varchar(255) DEFAULT NULL COMMENT 'The link text.',
  `field_demo_link_options` longblob DEFAULT NULL COMMENT 'Serialized array of options for the link.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_demo_link_uri` (`field_demo_link_uri`(30))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_demo_link.';

--
-- Dumping data for table `node_revision__field_demo_link`
--

set autocommit=0;
INSERT INTO `node_revision__field_demo_link` VALUES ('product',0,9,41,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,9,54,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,9,79,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,9,90,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,9,102,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,9,105,'en',0,'https://www.sync-stream.com/aca-dashboard','','a:0:{}'),('product',0,10,42,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,46,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,52,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,58,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,64,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,65,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,70,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,81,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,10,94,'en',0,'https://www.unemploymenttracker.com/','','a:0:{}'),('product',0,11,43,'en',0,'https://www.clearverify.com/','','a:0:{}'),('product',0,11,44,'en',0,'https://www.clearverify.com/','','a:0:{}'),('product',0,11,63,'en',0,'https://www.clearverify.com/','','a:0:{}'),('product',0,11,66,'en',0,'https://www.clearverify.com/call','','a:0:{}'),('product',0,11,80,'en',0,'https://www.clearverify.com/call','','a:0:{}'),('product',0,11,89,'en',0,'https://www.clearverify.com/call','','a:0:{}'),('product',0,11,103,'en',0,'https://www.clearverify.com/call','','a:0:{}'),('product',0,11,104,'en',0,'https://www.clearverify.com/call','','a:0:{}'),('product',0,12,37,'en',0,'https://www.cleari9.com/','','a:0:{}'),('product',0,12,38,'en',0,'https://www.cleari9.com/','','a:0:{}'),('product',0,12,51,'en',0,'https://www.cleari9.com/','','a:0:{}'),('product',0,12,53,'en',0,'https://www.cleari9.com/contact','','a:0:{}'),('product',0,12,78,'en',0,'https://www.cleari9.com/contact','','a:0:{}'),('product',0,12,91,'en',0,'https://www.cleari9.com/contact','','a:0:{}'),('product',0,12,101,'en',0,'https://www.cleari9.com/contact','','a:0:{}'),('product',0,12,106,'en',0,'https://www.cleari9.com/contact','','a:0:{}'),('product',0,13,40,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,13,83,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,13,92,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,13,100,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,13,107,'en',0,'https://www.oncentive.com/work-opportunity-tax-credit','','a:0:{}'),('product',0,14,39,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('product',0,14,45,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('product',0,14,50,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('product',0,14,55,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('product',0,14,56,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('product',0,14,57,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('product',0,14,82,'en',0,'https://www.oncentive.com/employee-retention-tax-credit','','a:0:{}'),('marketing',0,23,132,'en',0,'https://www.oncentive.com/','','a:0:{}'),('marketing',0,23,133,'en',0,'https://www.oncentive.com/','','a:0:{}');
commit;

--
-- Table structure for table `node_revision__field_department`
--

CREATE TABLE `node_revision__field_department` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_department_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_department.';

--
-- Dumping data for table `node_revision__field_department`
--

set autocommit=0;
INSERT INTO `node_revision__field_department` VALUES ('data_scheme',0,28,138,'en',0,'Department');
commit;

--
-- Table structure for table `node_revision__field_division`
--

CREATE TABLE `node_revision__field_division` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_division_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_division.';

--
-- Dumping data for table `node_revision__field_division`
--

set autocommit=0;
INSERT INTO `node_revision__field_division` VALUES ('data_scheme',0,28,138,'en',0,'Division');
commit;

--
-- Table structure for table `node_revision__field_employee_id`
--

CREATE TABLE `node_revision__field_employee_id` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employee_id_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_employee_id.';

--
-- Dumping data for table `node_revision__field_employee_id`
--

set autocommit=0;
INSERT INTO `node_revision__field_employee_id` VALUES ('data_scheme',0,15,93,'en',0,'eid'),('data_scheme',0,21,108,'en',0,'eidfield'),('data_scheme',0,22,109,'en',0,'test2'),('data_scheme',0,28,138,'en',0,'Employee ID'),('data_scheme',0,29,139,'en',0,'Employee ID');
commit;

--
-- Table structure for table `node_revision__field_employee_status`
--

CREATE TABLE `node_revision__field_employee_status` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employee_status_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_employee…';

--
-- Dumping data for table `node_revision__field_employee_status`
--

set autocommit=0;
INSERT INTO `node_revision__field_employee_status` VALUES ('data_scheme',0,28,138,'en',0,'Employee status');
commit;

--
-- Table structure for table `node_revision__field_employment_city`
--

CREATE TABLE `node_revision__field_employment_city` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employment_city_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_employment…';

--
-- Dumping data for table `node_revision__field_employment_city`
--

set autocommit=0;
INSERT INTO `node_revision__field_employment_city` VALUES ('data_scheme',0,28,138,'en',0,'Employment city');
commit;

--
-- Table structure for table `node_revision__field_employment_state`
--

CREATE TABLE `node_revision__field_employment_state` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_employment_state_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_employment…';

--
-- Dumping data for table `node_revision__field_employment_state`
--

set autocommit=0;
INSERT INTO `node_revision__field_employment_state` VALUES ('data_scheme',0,28,138,'en',0,'Employment state');
commit;

--
-- Table structure for table `node_revision__field_federal_withholding`
--

CREATE TABLE `node_revision__field_federal_withholding` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_federal_withholding_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_federal…';

--
-- Dumping data for table `node_revision__field_federal_withholding`
--

set autocommit=0;
INSERT INTO `node_revision__field_federal_withholding` VALUES ('data_scheme',0,28,138,'en',0,'Federal Witholding');
commit;

--
-- Table structure for table `node_revision__field_first_name`
--

CREATE TABLE `node_revision__field_first_name` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_first_name_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_first_name.';

--
-- Dumping data for table `node_revision__field_first_name`
--

set autocommit=0;
INSERT INTO `node_revision__field_first_name` VALUES ('data_scheme',0,28,138,'en',0,'First name');
commit;

--
-- Table structure for table `node_revision__field_gross_hours`
--

CREATE TABLE `node_revision__field_gross_hours` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_gross_hours_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_gross_hours.';

--
-- Dumping data for table `node_revision__field_gross_hours`
--

set autocommit=0;
INSERT INTO `node_revision__field_gross_hours` VALUES ('data_scheme',0,28,138,'en',0,'Gross hours');
commit;

--
-- Table structure for table `node_revision__field_gross_pay`
--

CREATE TABLE `node_revision__field_gross_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_gross_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_gross_pay.';

--
-- Dumping data for table `node_revision__field_gross_pay`
--

set autocommit=0;
INSERT INTO `node_revision__field_gross_pay` VALUES ('data_scheme',0,28,138,'en',0,'Gross pay');
commit;

--
-- Table structure for table `node_revision__field_icon`
--

CREATE TABLE `node_revision__field_icon` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_icon_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_icon_display` tinyint(3) unsigned DEFAULT 1 COMMENT 'Flag to control whether this file should be displayed when viewing content.',
  `field_icon_description` text DEFAULT NULL COMMENT 'A description of the file.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_icon_target_id` (`field_icon_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_icon.';

--
-- Dumping data for table `node_revision__field_icon`
--

set autocommit=0;
INSERT INTO `node_revision__field_icon` VALUES ('product',0,9,79,'en',0,5,1,''),('product',0,9,90,'en',0,5,1,''),('product',0,9,102,'en',0,5,1,''),('product',0,9,105,'en',0,5,1,''),('product',0,10,81,'en',0,7,1,''),('product',0,10,94,'en',0,7,1,''),('product',0,11,80,'en',0,6,1,''),('product',0,11,89,'en',0,6,1,''),('product',0,11,103,'en',0,6,1,''),('product',0,11,104,'en',0,6,1,''),('product',0,12,78,'en',0,4,1,''),('product',0,12,91,'en',0,4,1,''),('product',0,12,101,'en',0,4,1,''),('product',0,12,106,'en',0,4,1,''),('product',0,13,83,'en',0,9,1,''),('product',0,13,92,'en',0,9,1,''),('product',0,13,100,'en',0,9,1,''),('product',0,13,107,'en',0,9,1,''),('product',0,14,82,'en',0,8,1,'');
commit;

--
-- Table structure for table `node_revision__field_image`
--

CREATE TABLE `node_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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_target_id` int(10) 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(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_image_target_id` (`field_image_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_image.';

--
-- Dumping data for table `node_revision__field_image`
--

set autocommit=0;
INSERT INTO `node_revision__field_image` VALUES ('marketing',0,23,132,'en',0,31,'HRlogics logo','',194,54),('marketing',0,23,133,'en',0,31,'HRlogics logo','',194,54);
commit;

--
-- Table structure for table `node_revision__field_last_name`
--

CREATE TABLE `node_revision__field_last_name` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_last_name_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_last_name.';

--
-- Dumping data for table `node_revision__field_last_name`
--

set autocommit=0;
INSERT INTO `node_revision__field_last_name` VALUES ('data_scheme',0,28,138,'en',0,'Last name');
commit;

--
-- Table structure for table `node_revision__field_location_identifier_column`
--

CREATE TABLE `node_revision__field_location_identifier_column` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_location_identifier_column_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_location…';

--
-- Dumping data for table `node_revision__field_location_identifier_column`
--

set autocommit=0;
INSERT INTO `node_revision__field_location_identifier_column` VALUES ('data_scheme',0,28,138,'en',0,'Location Identifier Column');
commit;

--
-- Table structure for table `node_revision__field_logo`
--

CREATE TABLE `node_revision__field_logo` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_logo_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_logo_display` tinyint(3) unsigned DEFAULT 1 COMMENT 'Flag to control whether this file should be displayed when viewing content.',
  `field_logo_description` text DEFAULT NULL COMMENT 'A description of the file.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_logo_target_id` (`field_logo_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_logo.';

--
-- Dumping data for table `node_revision__field_logo`
--

set autocommit=0;
INSERT INTO `node_revision__field_logo` VALUES ('product',0,9,90,'en',0,11,1,''),('product',0,9,105,'en',0,20,1,''),('product',0,10,94,'en',0,14,1,''),('product',0,11,89,'en',0,10,1,''),('product',0,11,104,'en',0,19,1,''),('product',0,12,91,'en',0,12,1,''),('product',0,12,106,'en',0,21,1,''),('product',0,13,92,'en',0,13,1,''),('product',0,13,107,'en',0,22,1,'');
commit;

--
-- Table structure for table `node_revision__field_middle_name`
--

CREATE TABLE `node_revision__field_middle_name` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_middle_name_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_middle_name.';

--
-- Dumping data for table `node_revision__field_middle_name`
--

set autocommit=0;
INSERT INTO `node_revision__field_middle_name` VALUES ('data_scheme',0,28,138,'en',0,'Middle name');
commit;

--
-- Table structure for table `node_revision__field_modal_content`
--

CREATE TABLE `node_revision__field_modal_content` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_modal_content_value` longtext NOT NULL,
  `field_modal_content_format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_modal_content_format` (`field_modal_content_format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_modal_content.';

--
-- Dumping data for table `node_revision__field_modal_content`
--

set autocommit=0;
INSERT INTO `node_revision__field_modal_content` VALUES ('marketing',0,23,132,'en',0,'<p>Directly integrate with HR Logics through SFTP. SFTP (Secure File Transfer Protocol) provides a secure and encrypted way to transfer files between two systems. SFTP ensures that data is protected from unauthorized access or interception during transmission, reducing the risk of data breaches and increasing data privacy. By using SFTP to connect, organizations can improve their data security and increase the reliability and efficiency of their data transfers. We will create a server for you and a login and password. Use the application FileZilla to send your files to your personal server, or request files! Ask your Compliance Champion for More information!</p>','basic_html'),('marketing',0,23,133,'en',0,'<p>Directly integrate with HR Logics through SFTP. SFTP (Secure File Transfer Protocol) provides a secure and encrypted way to transfer files between two systems. SFTP ensures that data is protected from unauthorized access or interception during transmission, reducing the risk of data breaches and increasing data privacy. By using SFTP to connect, organizations can improve their data security and increase the reliability and efficiency of their data transfers. We will create a server for you and a login and password. Use the application FileZilla to send your files to your personal server, or request files! Ask your Compliance Champion for More information!</p>','basic_html');
commit;

--
-- Table structure for table `node_revision__field_modal_image`
--

CREATE TABLE `node_revision__field_modal_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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_modal_image_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_modal_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image''s ''alt'' attribute.',
  `field_modal_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image''s ''title'' attribute.',
  `field_modal_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_modal_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_modal_image_target_id` (`field_modal_image_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_modal_image.';

--
-- Dumping data for table `node_revision__field_modal_image`
--

set autocommit=0;
INSERT INTO `node_revision__field_modal_image` VALUES ('marketing',0,23,132,'en',0,30,'HRlogics logo','',888,319),('marketing',0,23,133,'en',0,30,'HRlogics logo','',888,319);
commit;

--
-- Table structure for table `node_revision__field_modal_title`
--

CREATE TABLE `node_revision__field_modal_title` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_modal_title_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_modal_title.';

--
-- Dumping data for table `node_revision__field_modal_title`
--

set autocommit=0;
INSERT INTO `node_revision__field_modal_title` VALUES ('marketing',0,23,132,'en',0,'Directly integrate with HR Logics through “SFTP”'),('marketing',0,23,133,'en',0,'Directly integrate with HR Logics through “SFTP”');
commit;

--
-- Table structure for table `node_revision__field_most_recent_hire_date`
--

CREATE TABLE `node_revision__field_most_recent_hire_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_most_recent_hire_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_most_recent…';

--
-- Dumping data for table `node_revision__field_most_recent_hire_date`
--

set autocommit=0;
INSERT INTO `node_revision__field_most_recent_hire_date` VALUES ('data_scheme',0,28,138,'en',0,'Most recent hire date');
commit;

--
-- Table structure for table `node_revision__field_original_hire_date`
--

CREATE TABLE `node_revision__field_original_hire_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_original_hire_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_original_hire…';

--
-- Dumping data for table `node_revision__field_original_hire_date`
--

set autocommit=0;
INSERT INTO `node_revision__field_original_hire_date` VALUES ('data_scheme',0,28,138,'en',0,'Original hire date');
commit;

--
-- Table structure for table `node_revision__field_other_payments`
--

CREATE TABLE `node_revision__field_other_payments` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_other_payments_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_other…';

--
-- Dumping data for table `node_revision__field_other_payments`
--

set autocommit=0;
INSERT INTO `node_revision__field_other_payments` VALUES ('data_scheme',0,28,138,'en',0,'Other payments');
commit;

--
-- Table structure for table `node_revision__field_overtime_hours`
--

CREATE TABLE `node_revision__field_overtime_hours` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_overtime_hours_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_overtime…';

--
-- Dumping data for table `node_revision__field_overtime_hours`
--

set autocommit=0;
INSERT INTO `node_revision__field_overtime_hours` VALUES ('data_scheme',0,28,138,'en',0,'Overtime hours');
commit;

--
-- Table structure for table `node_revision__field_overtime_pay`
--

CREATE TABLE `node_revision__field_overtime_pay` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_overtime_pay_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_overtime_pay.';

--
-- Dumping data for table `node_revision__field_overtime_pay`
--

set autocommit=0;
INSERT INTO `node_revision__field_overtime_pay` VALUES ('data_scheme',0,28,138,'en',0,'Overtime pay');
commit;

--
-- Table structure for table `node_revision__field_pay_date`
--

CREATE TABLE `node_revision__field_pay_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pay_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_pay_date.';

--
-- Dumping data for table `node_revision__field_pay_date`
--

set autocommit=0;
INSERT INTO `node_revision__field_pay_date` VALUES ('data_scheme',0,28,138,'en',0,'Pay date'),('data_scheme',0,29,139,'en',0,'Period start date');
commit;

--
-- Table structure for table `node_revision__field_pay_frequency`
--

CREATE TABLE `node_revision__field_pay_frequency` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pay_frequency_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_pay_frequency.';

--
-- Dumping data for table `node_revision__field_pay_frequency`
--

set autocommit=0;
INSERT INTO `node_revision__field_pay_frequency` VALUES ('data_scheme',0,28,138,'en',0,'Pay frequency');
commit;

--
-- Table structure for table `node_revision__field_pay_type`
--

CREATE TABLE `node_revision__field_pay_type` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pay_type_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_pay_type.';

--
-- Dumping data for table `node_revision__field_pay_type`
--

set autocommit=0;
INSERT INTO `node_revision__field_pay_type` VALUES ('data_scheme',0,28,138,'en',0,'Pay type');
commit;

--
-- Table structure for table `node_revision__field_paycheck_id`
--

CREATE TABLE `node_revision__field_paycheck_id` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_paycheck_id_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_paycheck_id.';

--
-- Dumping data for table `node_revision__field_paycheck_id`
--

set autocommit=0;
INSERT INTO `node_revision__field_paycheck_id` VALUES ('data_scheme',0,15,93,'en',0,'pid'),('data_scheme',0,21,108,'en',0,'payidfield'),('data_scheme',0,22,109,'en',0,'test3'),('data_scheme',0,28,138,'en',0,'Paycheck ID'),('data_scheme',0,29,139,'en',0,'Paycheck ID');
commit;

--
-- Table structure for table `node_revision__field_pension`
--

CREATE TABLE `node_revision__field_pension` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_pension_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_pension.';

--
-- Dumping data for table `node_revision__field_pension`
--

set autocommit=0;
INSERT INTO `node_revision__field_pension` VALUES ('data_scheme',0,28,138,'en',0,'Pension');
commit;

--
-- Table structure for table `node_revision__field_period_end_date`
--

CREATE TABLE `node_revision__field_period_end_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_period_end_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_period_end…';

--
-- Dumping data for table `node_revision__field_period_end_date`
--

set autocommit=0;
INSERT INTO `node_revision__field_period_end_date` VALUES ('data_scheme',0,28,138,'en',0,'Period end date'),('data_scheme',0,29,139,'en',0,'Period end date');
commit;

--
-- Table structure for table `node_revision__field_period_start_date`
--

CREATE TABLE `node_revision__field_period_start_date` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_period_start_date_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_period_start…';

--
-- Dumping data for table `node_revision__field_period_start_date`
--

set autocommit=0;
INSERT INTO `node_revision__field_period_start_date` VALUES ('data_scheme',0,28,138,'en',0,'Period start date'),('data_scheme',0,29,139,'en',0,'Period start date');
commit;

--
-- Table structure for table `node_revision__field_position_fein`
--

CREATE TABLE `node_revision__field_position_fein` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_fein_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_position_fein.';

--
-- Dumping data for table `node_revision__field_position_fein`
--

set autocommit=0;
INSERT INTO `node_revision__field_position_fein` VALUES ('data_scheme',0,28,138,'en',0,'Position FEIN');
commit;

--
-- Table structure for table `node_revision__field_position_title`
--

CREATE TABLE `node_revision__field_position_title` (
  `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(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) 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(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_position_title_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Revision archive storage for node field field_position…';

--
