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

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

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

INSERT INTO `webform` VALUES ('application_form',1),('contact',1),('get_valuable_strategy_culture_an',29),('register_now',1),('staffing_services_enquiry_form',2);

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

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

--
-- Dumping data for table `webform_access_group_admin`
--


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

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

--
-- Dumping data for table `webform_access_group_entity`
--


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

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

--
-- Dumping data for table `webform_access_group_user`
--


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

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

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

INSERT INTO `webform_submission` VALUES (1,'get_valuable_strategy_culture_an','d602b7fa-c107-4f21-814f-025bc6abaaf0','en',1,'cLAq_8JrPvHErlpfx2KUSwpyUxaGMKiwT3FSbp1VoyQ','/',1763728066,1763728066,1763728066,0,NULL,'157.51.133.97',0,'node','1',0,0,NULL),(2,'get_valuable_strategy_culture_an','63433bac-37f4-4d02-85c5-6427ffde0fe1','en',2,'P3OpOIotmw5N2HXWUS3ladVAJ8efGoukxblMePXoa4o','/who-we-serve',1763994494,1763994494,1763994494,0,NULL,'157.51.28.125',0,'node','23',0,0,NULL),(3,'get_valuable_strategy_culture_an','192cc745-109a-4462-a4e5-2707ca459286','en',3,'EmIZp08d__TUooOAjWuTUdDrXo-xx2EQZqXLW1Ku2AY','/form/get-valuable-strategy-culture-an/confirmation?token=P3OpOIotmw5N2HXWUS3ladVAJ8efGoukxblMePXoa4o',1763994821,1763994821,1763994821,0,NULL,'157.51.28.125',0,NULL,NULL,0,0,NULL),(4,'get_valuable_strategy_culture_an','525e02b5-57c1-4765-a51e-08f65e6f4e39','en',4,'Gc9zz4GCDh3F0_agzBwULXMqWBQIFiLexvqxqUM9tWk','/who-we-serve',1764597717,1764597717,1764597717,0,NULL,'106.197.112.35',0,'node','23',0,0,NULL),(5,'get_valuable_strategy_culture_an','3352ea7d-a844-477e-bce5-ea40b71560d6','en',5,'LlclAFXG-KI9slFL95oJSG55l1gbR0bskACiqCAKJwg','/',1764597965,1764597965,1764597965,0,NULL,'106.197.112.35',0,'node','1',0,0,NULL),(6,'get_valuable_strategy_culture_an','84435ca3-3a45-44eb-a78d-082bea8c9509','en',6,'Eh7GHvo2Up43tgXM9u1pcpKGDTsZOiq55CO84v-M4ZU','/',1764597965,1764597965,1764597965,0,NULL,'106.197.112.35',0,'node','1',0,0,NULL),(7,'get_valuable_strategy_culture_an','7d59dcba-f396-4a21-bf92-35610f1f8429','en',7,'xIWWmakU011D5c-AOjw99eFnnetHypNqmHws9rDfPuk','/',1764598071,1764598071,1764598071,0,NULL,'106.197.112.35',0,'node','1',0,0,NULL),(8,'get_valuable_strategy_culture_an','0c7fca11-ce29-484b-983c-9a0bfc484434','en',8,'FnQsPSsYS0ehK5IcyBvxMLsvmpXPIrFxni0BSSuI8bg','/',1764598071,1764598071,1764598071,0,NULL,'106.197.112.35',0,'node','1',0,0,NULL),(9,'get_valuable_strategy_culture_an','f0936499-314f-4b86-b548-155703775605','en',9,'-ju4mkJIz6QwgGxhI6StfCEX0D4xRfGi5z7UFbRQkPU','/',1764769650,1764769650,1764769650,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(10,'get_valuable_strategy_culture_an','60e40f6c-f918-474d-86ee-6651e923cc0d','en',10,'etFaYncOy2ddYRE9DHlAde9C--fqhssyDCUwYxaTNWU','/',1764769650,1764769650,1764769650,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(11,'get_valuable_strategy_culture_an','47dee6a7-2137-4e9f-a56c-1f903cc3ab2f','en',11,'eE88dkxzPGpg_xQovZ_5Gk85PPcZsBT84ndx-rlEJTM','/',1764769955,1764769955,1764769955,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(12,'get_valuable_strategy_culture_an','d62011f5-a317-457c-bc34-2a27282b7d3c','en',12,'0-nNSSKVpBMa3Afe7lcJRuEVn0QJl0nfDiYW9OLp99E','/',1764769955,1764769955,1764769955,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(13,'get_valuable_strategy_culture_an','8e87fec0-e24d-482e-9e36-cc8bf00fd99a','en',13,'6ngjQRMLT_ISS_n-fEnthxe_aEBUkX6GrqmofXhRKlo','/',1764769975,1764769975,1764769975,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(14,'get_valuable_strategy_culture_an','c7448465-dc81-488c-964f-3ba5d78233af','en',14,'FAXdHlRzdC5lnd9wuELIE5hYwVLlq7GROYLjEYHQ08E','/',1764769975,1764769975,1764769975,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(15,'get_valuable_strategy_culture_an','2ba367ca-4c7e-4858-9eb8-0f4e1b01d2e5','en',15,'els8lNIh2vg-obyEDkreCgsHggRm4UyazyfO9bs0Kfk','/',1764770213,1764770213,1764770213,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(16,'get_valuable_strategy_culture_an','a53b295c-94e1-4c06-b8a5-093c54f91ee2','en',16,'Q501VWkZkcJa6sww6BjmfkbWPY-hsPoSsFLKVMX60GY','/',1764770213,1764770213,1764770213,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(17,'get_valuable_strategy_culture_an','43071911-4424-426f-a3ee-7ca0beb92001','en',17,'kWoi2elsqvkg3cjMeA1uXrswJWKKSN8BJc-qSWbZD2A','/',1764770226,1764770226,1764770226,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(18,'get_valuable_strategy_culture_an','cbe8e5b7-f2c6-4c89-af9a-2a0aa5f17b69','en',18,'bGPpEQjlnsqFKOqxiHp4emU-MKsEMhWqR7dX9VRiUeQ','/',1764770226,1764770226,1764770226,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(19,'get_valuable_strategy_culture_an','23c876c6-4e27-4a09-a98e-3416f2f3add3','en',19,'Dq985b-_FvjZmaG7dzAOTQI6b3bP9GaaOmzt4kk0kRs','/',1764770273,1764770273,1764770273,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(20,'get_valuable_strategy_culture_an','075e3d36-efba-4b45-9bca-bee47f1d40ba','en',20,'NlJTRWXWBrXTMASx6Y2M4Tm4LFmjS7E0JnyosOemdig','/',1764770273,1764770273,1764770273,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(21,'get_valuable_strategy_culture_an','383a7f5a-6441-49db-a27a-ad6eff01019b','en',21,'41WR4a89HT8qqPkZXM0z1YzTY0ueZ-qWsLF2PUFMic0','/',1764770634,1764770634,1764770634,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(22,'get_valuable_strategy_culture_an','38cea3e7-98c2-4cc3-b704-c11e22bcfc8c','en',22,'bKNWEYvJ5x5Lq2QtAc-KAX2L7gUH7H8nLkHh4pyhZQA','/',1764770634,1764770634,1764770634,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(23,'get_valuable_strategy_culture_an','b97d5e9d-81f7-4113-b97b-065355ee9742','en',23,'n_pewdrYbV9LOF9SpkS0Wm4umyWtTafSNVVQUXviWug','/',1764770939,1764770939,1764770939,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(24,'get_valuable_strategy_culture_an','12938b09-f852-4b31-8c66-850539ee9991','en',24,'JSTGLTX0y7nGidvBWI-IMtMZKB6JxVJ4KnlJBf9SrAQ','/',1764770939,1764770939,1764770939,0,NULL,'152.57.92.189',0,'node','1',0,0,NULL),(25,'get_valuable_strategy_culture_an','017516f0-fc2f-45ed-8915-8cd48f0d6265','en',25,'FPPSX6yOIgeSH6Wr9JnW7bOR1uhypwSLjExhfsYTKj4','/',1764772922,1764772922,1764772922,0,NULL,'49.47.217.177',0,'node','1',0,0,NULL),(26,'get_valuable_strategy_culture_an','1b0ab4e2-a842-4994-8e2d-9196610a06d6','en',26,'2_d7Q6M9MRhi0wpVxCVL88j_Q3k2axhTg2OLV81AqXM','/',1764772922,1764772922,1764772922,0,NULL,'49.47.217.177',0,'node','1',0,0,NULL),(27,'get_valuable_strategy_culture_an','2c80e614-b76b-491c-9f31-8b3582d2a73d','en',27,'YbQJ_fUhO02NL2eG-gw8IhnYVZQALqT-eOYkMWjNDv4','/what-we-do/specializations/enterprise-architecture',1764773370,1764773370,1764773370,0,NULL,'152.57.92.189',0,'node','121',0,0,NULL),(28,'get_valuable_strategy_culture_an','35fda4b8-1e86-4b20-bce8-27a7a8bbaaa6','en',28,'Ab9MjJy1ekeVeQ22Ho8slg72NvgbFU-QcGKKiX0WQrM','/what-we-do/specializations/enterprise-architecture',1764773370,1764773370,1764773370,0,NULL,'152.57.92.189',0,'node','121',0,0,NULL),(29,'staffing_services_enquiry_form','85cca9c0-ecea-4b4a-bf9b-6a47d57b535c','en',1,'AHQb8fX2SDcGoLNM0xYlv9tIzr9x_qVxvFBUe9Pg7w0','/what-we-do/services/talent-mobilization',1764864507,1764864507,1764864507,0,NULL,'36.255.17.178',0,'node','120',0,0,NULL);

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

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

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

INSERT INTO `webform_submission_data` VALUES ('get_valuable_strategy_culture_an',1,'your_email_id_here','',0,'testtest@gmail.com'),('get_valuable_strategy_culture_an',2,'your_email_id_here','',0,'sprakash@divihn.com'),('get_valuable_strategy_culture_an',3,'your_email_id_here','',0,'test@abc.com'),('get_valuable_strategy_culture_an',4,'your_email_id_here','',0,'test@abc.com'),('get_valuable_strategy_culture_an',5,'your_email_id_here','',0,'test@abc.com'),('get_valuable_strategy_culture_an',6,'your_email_id_here','',0,'test@abc.com'),('get_valuable_strategy_culture_an',7,'your_email_id_here','',0,'test@email.com'),('get_valuable_strategy_culture_an',8,'your_email_id_here','',0,'test@email.com'),('get_valuable_strategy_culture_an',9,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',10,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',11,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',12,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',13,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',14,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',15,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',16,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',17,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',18,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',19,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',20,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',21,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',22,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',23,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',24,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',25,'your_email_id_here','',0,'viknesh234@gmail.com'),('get_valuable_strategy_culture_an',26,'your_email_id_here','',0,'viknesh234@gmail.com'),('get_valuable_strategy_culture_an',27,'your_email_id_here','',0,'swathipswati@gmail.com'),('get_valuable_strategy_culture_an',28,'your_email_id_here','',0,'swathipswati@gmail.com'),('staffing_services_enquiry_form',29,'business_email_address','',0,''),('staffing_services_enquiry_form',29,'company_nam','',0,''),('staffing_services_enquiry_form',29,'how_can_we_help','',0,''),('staffing_services_enquiry_form',29,'job_title','',0,'');


