--
-- Host: localhost    Database: ticketingadmin
-- ------------------------------------------------------


--
-- Table structure for table `attendees`
--

CREATE TABLE `attendees` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendees`
--


--
-- Table structure for table `clerk_event`
--

CREATE TABLE `clerk_event` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clerk_event_event_id_foreign` (`event_id`),
  KEY `clerk_event_user_id_foreign` (`user_id`),
  CONSTRAINT `clerk_event_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE,
  CONSTRAINT `clerk_event_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clerk_event`
--

INSERT INTO `clerk_event` VALUES (1,4,3,'2024-10-18 18:56:50','2024-10-18 18:56:50'),(2,4,5,'2024-10-22 08:16:30','2024-10-22 08:16:30'),(3,5,6,'2024-10-22 08:27:34','2024-10-22 08:27:34');

--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identification_number` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client`
--


--
-- Table structure for table `client_ticket`
--

CREATE TABLE `client_ticket` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `payment_id` bigint unsigned NOT NULL,
  `attended_at` datetime DEFAULT NULL,
  `ticket_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_ticket_ticket_id_foreign` (`ticket_id`),
  KEY `client_ticket_payment_id_foreign` (`payment_id`),
  CONSTRAINT `client_ticket_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payment` (`id`) ON DELETE CASCADE,
  CONSTRAINT `client_ticket_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_ticket`
--

INSERT INTO `client_ticket` VALUES (1,1,1,'2024-10-16 19:13:48','RFV56M','2024-10-16 19:13:48','2024-10-16 19:13:48'),(2,1,2,'2024-10-16 19:18:28','XJO60Y','2024-10-16 19:18:28','2024-10-16 19:18:28'),(3,1,3,'2024-10-16 19:24:11','O4TXEY','2024-10-16 19:24:11','2024-10-16 19:24:11'),(4,1,4,'2024-10-16 19:29:12','QVTY82','2024-10-16 19:29:12','2024-10-16 19:29:12'),(5,1,5,'2024-10-16 19:32:46','UZ2BE6','2024-10-16 19:32:46','2024-10-16 19:32:46'),(6,1,6,'2024-10-16 20:33:01','B0F5SU','2024-10-16 20:33:01','2024-10-16 20:33:01'),(7,2,7,'2024-10-16 20:41:33','RP9ADD','2024-10-16 20:41:33','2024-10-16 20:41:33'),(8,2,8,'2024-10-16 20:42:59','GIXDUU','2024-10-16 20:42:59','2024-10-16 20:42:59'),(9,1,9,'2024-10-16 20:58:30','NGYFPH','2024-10-16 20:58:30','2024-10-16 20:58:30'),(11,2,11,'2024-10-16 21:11:55','SQZBJG','2024-10-16 21:11:55','2024-10-16 21:11:55'),(12,5,12,'2024-10-16 22:26:49','23F0VA','2024-10-16 22:26:49','2024-10-16 22:26:49'),(13,7,13,'2024-10-16 23:09:37','FVY6QJ','2024-10-16 23:09:37','2024-10-16 23:09:37'),(14,7,14,'2024-10-16 23:22:30','3LL4OY','2024-10-16 23:22:30','2024-10-16 23:22:30'),(15,5,15,'2024-10-17 08:19:09','B82XDV','2024-10-17 08:19:09','2024-10-17 08:19:09'),(16,9,16,'2024-10-17 09:13:08','ZNM3VX','2024-10-17 09:13:08','2024-10-17 09:13:08'),(17,9,17,'2024-10-17 11:49:23','TJ2I6N','2024-10-17 11:49:23','2024-10-17 11:49:23'),(18,9,18,'2024-10-17 12:06:19','FSEAGD','2024-10-17 12:06:19','2024-10-17 12:06:19'),(19,9,19,'2024-10-17 12:07:08','IK66BA','2024-10-17 12:07:08','2024-10-17 12:07:08'),(20,9,20,'2024-10-17 12:07:55','JF97ZV','2024-10-17 12:07:55','2024-10-17 12:07:55'),(21,9,21,'2024-10-17 12:08:28','C4QSKK','2024-10-17 12:08:28','2024-10-17 12:08:28'),(22,9,22,'2024-10-17 12:25:51','QQBCZ6','2024-10-17 12:25:51','2024-10-17 12:25:51'),(23,9,23,'2024-10-17 12:27:56','BI10K4','2024-10-17 12:27:56','2024-10-17 12:27:56'),(24,9,24,'2024-10-17 12:29:59','WVJP4H','2024-10-17 12:29:59','2024-10-17 12:29:59'),(25,9,25,'2024-10-17 13:00:41','KQD4HL','2024-10-17 13:00:41','2024-10-17 13:00:41'),(26,9,26,'2024-10-17 13:01:29','LLFO9P','2024-10-17 13:01:29','2024-10-17 13:01:29'),(27,9,27,'2024-10-17 13:02:36','0XZI52','2024-10-17 13:02:36','2024-10-17 13:02:36'),(28,9,28,'2024-10-17 17:16:38','IMD09B','2024-10-17 17:16:38','2024-10-17 17:16:38'),(30,9,30,'2024-10-17 17:18:34','LS4OGB','2024-10-17 17:18:34','2024-10-17 17:18:34'),(31,9,31,'2024-10-17 18:21:36','Q2PS6W','2024-10-17 18:21:36','2024-10-17 18:21:36'),(32,9,32,'2024-10-17 18:26:55','7PMPEV','2024-10-17 18:26:55','2024-10-17 18:26:55'),(33,9,33,'2024-10-17 18:27:56','J06ZRE','2024-10-17 18:27:56','2024-10-17 18:27:56'),(34,9,34,'2024-10-17 18:30:34','YL4YTG','2024-10-17 18:30:34','2024-10-17 18:30:34'),(35,9,35,'2024-10-17 18:31:44','XACAVM','2024-10-17 18:31:44','2024-10-17 18:31:44'),(37,9,37,'2024-10-17 18:32:49','HC772L','2024-10-17 18:32:49','2024-10-17 18:32:49'),(38,9,38,'2024-10-17 18:38:34','7N9JX8','2024-10-17 18:38:34','2024-10-17 18:38:34'),(39,9,39,'2024-10-17 18:40:19','XYLV9C','2024-10-17 18:40:19','2024-10-17 18:40:19'),(40,9,40,'2024-10-17 18:40:57','PBI2WB','2024-10-17 18:40:57','2024-10-17 18:40:57'),(41,9,41,'2024-10-17 18:43:27','AQX9B4','2024-10-17 18:43:27','2024-10-17 18:43:27'),(42,9,42,'2024-10-17 18:49:21','BE2TGP','2024-10-17 18:49:21','2024-10-17 18:49:21'),(43,9,43,'2024-10-17 18:53:54','EYR94X','2024-10-17 18:53:54','2024-10-17 18:53:54'),(44,9,44,'2024-10-17 18:54:34','IE9JAN','2024-10-17 18:54:34','2024-10-17 18:54:34'),(45,9,45,'2024-10-17 18:57:11','I5G0YD','2024-10-17 18:57:11','2024-10-17 18:57:11'),(46,9,46,'2024-10-17 19:00:50','JJMUGJ','2024-10-17 19:00:50','2024-10-17 19:00:50'),(47,9,47,'2024-10-17 19:02:52','P4O2FY','2024-10-17 19:02:52','2024-10-17 19:02:52'),(48,9,48,'2024-10-17 19:04:19','JU82HL','2024-10-17 19:04:19','2024-10-17 19:04:19'),(49,9,49,'2024-10-17 19:04:37','1OD3V3','2024-10-17 19:04:37','2024-10-17 19:04:37'),(50,9,50,'2024-10-17 19:08:17','YET8WF','2024-10-17 19:08:17','2024-10-17 19:08:17'),(51,9,51,'2024-10-17 19:09:26','XR2WO9','2024-10-17 19:09:26','2024-10-17 19:09:26'),(52,9,52,'2024-10-18 09:35:57','KETYML','2024-10-18 09:35:57','2024-10-18 09:35:57'),(53,9,53,'2024-10-18 09:51:03','O00M8O','2024-10-18 09:51:03','2024-10-18 09:51:03'),(54,9,54,'2024-10-18 09:54:07','WDO8DG','2024-10-18 09:54:07','2024-10-18 09:54:07'),(55,9,55,'2024-10-18 09:56:14','2Z2VRW','2024-10-18 09:56:14','2024-10-18 09:56:14'),(56,9,56,'2024-10-18 10:03:30','SJE4UR','2024-10-18 10:03:30','2024-10-18 10:03:30'),(57,9,57,'2024-10-18 10:14:57','8EIUMN','2024-10-18 10:14:57','2024-10-18 10:14:57'),(58,9,58,'2024-10-18 10:25:12','Q0JZKP','2024-10-18 10:25:12','2024-10-18 10:25:12'),(59,9,59,'2024-10-18 10:28:58','VQDH3X','2024-10-18 10:28:58','2024-10-18 10:28:58'),(60,9,60,'2024-10-18 10:43:20','PNBE8E','2024-10-18 10:43:20','2024-10-18 10:43:20'),(61,9,61,'2024-10-18 10:45:37','DHBO03','2024-10-18 10:45:37','2024-10-18 10:45:37'),(62,9,62,'2024-10-18 10:56:04','1XWD7K','2024-10-18 10:56:04','2024-10-18 10:56:04'),(63,9,63,'2024-10-18 11:04:32','CQOH5X','2024-10-18 11:04:32','2024-10-18 11:04:32'),(64,9,64,'2024-10-18 11:07:22','IERR2W','2024-10-18 11:07:22','2024-10-18 11:07:22'),(65,9,65,'2024-10-18 11:28:38','TM5FHD','2024-10-18 11:28:38','2024-10-18 11:28:38'),(66,10,66,'2024-10-18 11:36:18','RT0DCN','2024-10-18 11:36:18','2024-10-18 11:36:18'),(67,9,67,'2024-10-18 13:01:57','RC5P7S','2024-10-18 13:01:57','2024-10-18 13:01:57'),(68,10,68,NULL,'LCXEGS','2024-10-18 13:31:38','2024-10-18 13:31:38'),(69,10,68,NULL,'BV7OYJ','2024-10-18 13:31:38','2024-10-18 13:31:38'),(70,10,68,NULL,'JOXWY5','2024-10-18 13:31:38','2024-10-18 13:31:38'),(71,10,68,NULL,'4MTSSB','2024-10-18 13:31:38','2024-10-18 13:31:38'),(72,10,68,NULL,'DK8M86','2024-10-18 13:31:38','2024-10-18 13:31:38'),(73,9,69,NULL,'PO0GB6','2024-10-18 13:42:10','2024-10-18 13:42:10'),(74,9,70,NULL,'V0PZKD','2024-10-18 13:46:28','2024-10-18 13:46:28'),(75,9,71,NULL,'27EZXP','2024-10-18 13:48:28','2024-10-18 13:48:28'),(76,9,72,NULL,'1X4CY7','2024-10-18 13:48:52','2024-10-18 13:48:52'),(77,9,73,NULL,'42W75F','2024-10-18 13:55:26','2024-10-18 13:55:26'),(78,9,74,NULL,'2K98KG','2024-10-18 13:57:16','2024-10-18 13:57:16'),(79,9,75,NULL,'9MCFGK','2024-10-18 14:02:37','2024-10-18 14:02:37'),(80,9,75,NULL,'Q3UEYD','2024-10-18 14:02:37','2024-10-18 14:02:37'),(81,9,75,NULL,'D1U7KT','2024-10-18 14:02:37','2024-10-18 14:02:37'),(82,9,75,NULL,'MULM5P','2024-10-18 14:02:37','2024-10-18 14:02:37'),(83,9,75,NULL,'OQ1NN3','2024-10-18 14:02:37','2024-10-18 14:02:37'),(84,9,76,NULL,'690ZN9','2024-10-18 14:46:13','2024-10-18 14:46:13'),(85,9,76,NULL,'F9QB96','2024-10-18 14:46:13','2024-10-18 14:46:13'),(86,9,76,NULL,'2URM61','2024-10-18 14:46:13','2024-10-18 14:46:13'),(87,9,76,NULL,'52ITC3','2024-10-18 14:46:13','2024-10-18 14:46:13'),(88,9,76,NULL,'4HMVBP','2024-10-18 14:46:13','2024-10-18 14:46:13'),(89,5,77,NULL,'12TKYP','2024-10-18 14:58:30','2024-10-18 14:58:30'),(90,7,78,NULL,'946K0V','2024-10-18 15:04:54','2024-10-18 15:04:54'),(91,9,79,NULL,'J0KD8A','2024-10-18 15:06:45','2024-10-18 15:06:45'),(92,10,80,NULL,'ANTK2Q','2024-10-18 15:24:41','2024-10-18 15:24:41'),(93,10,81,NULL,'TZRFIW','2024-10-18 15:26:00','2024-10-18 15:26:00'),(94,9,82,NULL,'7FJCY4','2024-10-18 15:30:02','2024-10-18 15:30:02'),(95,10,83,NULL,'7CNFW4','2024-10-18 15:36:04','2024-10-18 15:36:04'),(96,9,84,NULL,'4MISEY','2024-10-18 15:38:06','2024-10-18 15:38:06'),(97,9,85,NULL,'Z8VAX0','2024-10-18 15:41:23','2024-10-18 15:41:23'),(98,9,86,NULL,'FX922N','2024-10-18 15:45:29','2024-10-18 15:45:29'),(99,9,87,NULL,'3AUGPC','2024-10-18 15:47:45','2024-10-18 15:47:45'),(100,9,88,NULL,'K4WQQ2','2024-10-18 15:54:40','2024-10-18 15:54:40'),(101,9,88,NULL,'X77WZC','2024-10-18 15:54:40','2024-10-18 15:54:40'),(102,9,89,NULL,'PBJ9MZ','2024-10-18 15:56:03','2024-10-18 15:56:03'),(103,9,90,NULL,'4UMA2Y','2024-10-18 15:57:09','2024-10-18 15:57:09'),(104,9,91,NULL,'Q7WQMR','2024-10-18 15:57:36','2024-10-18 15:57:36'),(105,9,92,NULL,'TZ2RZJ','2024-10-18 18:07:12','2024-10-18 18:07:12'),(106,10,93,NULL,'1PDLA8','2024-10-18 18:07:35','2024-10-18 18:07:35'),(107,9,94,NULL,'FMO7GL','2024-10-18 18:10:03','2024-10-18 18:10:03'),(108,10,95,NULL,'RTSL03','2024-10-18 18:10:41','2024-10-18 18:10:41'),(109,10,96,NULL,'U2QSYQ','2024-10-18 18:35:17','2024-10-18 18:35:17'),(110,10,96,NULL,'URXGK2','2024-10-18 18:35:17','2024-10-18 18:35:17'),(111,9,97,NULL,'T0267E','2024-10-18 18:37:07','2024-10-18 18:37:07'),(112,9,97,NULL,'M5T3NC','2024-10-18 18:37:07','2024-10-18 18:37:07'),(113,9,97,NULL,'R5MVY6','2024-10-18 18:37:07','2024-10-18 18:37:07'),(114,9,97,NULL,'DO3YIJ','2024-10-18 18:37:07','2024-10-18 18:37:07'),(115,9,98,NULL,'PEEC16','2024-10-18 18:58:45','2024-10-18 18:58:45'),(116,9,98,NULL,'7MKNN1','2024-10-18 18:58:45','2024-10-18 18:58:45'),(117,9,99,'2024-10-18 19:01:53','7WEKUG','2024-10-18 19:01:36','2024-10-18 19:01:53'),(118,9,100,NULL,'QO7BRS','2024-10-19 16:52:39','2024-10-19 16:52:39'),(119,9,101,NULL,'EM994Z','2024-10-21 10:38:16','2024-10-21 10:38:16'),(120,9,102,NULL,'8TPTBF','2024-10-21 11:08:27','2024-10-21 11:08:27'),(121,9,103,NULL,'4GL2DU','2024-10-21 11:12:40','2024-10-21 11:12:40'),(122,9,104,NULL,'LUBS1F','2024-10-21 11:15:11','2024-10-21 11:15:11'),(123,9,105,NULL,'3YH4FS','2024-10-21 11:24:14','2024-10-21 11:24:14'),(124,9,106,NULL,'JOSJ2Z','2024-10-21 11:39:08','2024-10-21 11:39:08'),(125,9,107,NULL,'9SONDP','2024-10-21 11:43:44','2024-10-21 11:43:44'),(126,9,108,NULL,'87GFD1','2024-10-21 11:44:53','2024-10-21 11:44:53'),(127,10,109,NULL,'QEHL91','2024-10-21 11:47:12','2024-10-21 11:47:12'),(128,9,110,NULL,'6TZY4U','2024-10-21 13:07:49','2024-10-21 13:07:49'),(129,9,111,NULL,'SNLSUI','2024-10-21 13:08:03','2024-10-21 13:08:03'),(130,9,112,NULL,'R8CO2I','2024-10-21 13:08:55','2024-10-21 13:08:55'),(131,9,113,NULL,'95K21J','2024-10-21 13:09:39','2024-10-21 13:09:39'),(149,9,131,NULL,'9M40X5','2024-10-21 15:58:32','2024-10-21 15:58:32'),(150,9,131,NULL,'EGTFUM','2024-10-21 15:58:32','2024-10-21 15:58:32'),(151,9,131,NULL,'BAE65U','2024-10-21 15:58:32','2024-10-21 15:58:32'),(152,9,131,NULL,'M2H3OF','2024-10-21 15:58:32','2024-10-21 15:58:32'),(153,9,131,NULL,'0D5PAJ','2024-10-21 15:58:32','2024-10-21 15:58:32'),(154,9,132,NULL,'OBP2CQ','2024-10-21 16:00:54','2024-10-21 16:00:54'),(155,9,133,NULL,'GVEG98','2024-10-21 16:02:58','2024-10-21 16:02:58'),(162,9,136,NULL,'PQ3XTE','2024-10-21 16:05:32','2024-10-21 16:05:32'),(163,9,137,NULL,'PMCTXP','2024-10-21 16:06:25','2024-10-21 16:06:25'),(164,9,138,NULL,'RC548N','2024-10-21 16:06:31','2024-10-21 16:06:31'),(165,9,139,NULL,'9DC29Q','2024-10-21 16:07:02','2024-10-21 16:07:02'),(166,9,140,NULL,'86H8A1','2024-10-21 16:07:05','2024-10-21 16:07:05'),(167,9,141,NULL,'8ZT6FF','2024-10-21 16:07:47','2024-10-21 16:07:47'),(170,9,144,NULL,'SL5T8H','2024-10-21 16:08:33','2024-10-21 16:08:33'),(171,9,145,NULL,'9A7YZT','2024-10-21 16:08:46','2024-10-21 16:08:46'),(172,9,146,NULL,'7WCPUB','2024-10-21 16:08:56','2024-10-21 16:08:56'),(173,9,147,NULL,'ZPZLSE','2024-10-21 16:12:08','2024-10-21 16:12:08'),(176,9,150,NULL,'F56UMI','2024-10-21 16:12:53','2024-10-21 16:12:53'),(177,9,151,NULL,'Q4HL1H','2024-10-21 16:13:02','2024-10-21 16:13:02'),(178,9,152,NULL,'OG3VAJ','2024-10-21 16:13:07','2024-10-21 16:13:07'),(179,9,153,NULL,'4KXM1X','2024-10-21 16:13:12','2024-10-21 16:13:12'),(180,9,154,NULL,'2BXSS4','2024-10-21 16:17:14','2024-10-21 16:17:14'),(181,9,155,NULL,'KVAYQA','2024-10-21 16:17:21','2024-10-21 16:17:21'),(182,9,156,NULL,'7RETAP','2024-10-21 16:17:26','2024-10-21 16:17:26'),(183,9,157,NULL,'R08EQD','2024-10-21 16:20:37','2024-10-21 16:20:37'),(184,9,158,NULL,'8M36L8','2024-10-21 16:25:44','2024-10-21 16:25:44'),(185,9,159,NULL,'P5HNSU','2024-10-21 16:29:34','2024-10-21 16:29:34'),(186,9,160,NULL,'78JEZ1','2024-10-21 16:30:51','2024-10-21 16:30:51'),(187,9,161,NULL,'89RP0X','2024-10-21 16:31:41','2024-10-21 16:31:41'),(188,9,162,NULL,'GRUNKY','2024-10-21 16:34:55','2024-10-21 16:34:55'),(189,9,163,NULL,'HAS0UK','2024-10-21 16:38:31','2024-10-21 16:38:31'),(190,9,164,NULL,'S6S5YA','2024-10-21 16:39:21','2024-10-21 16:39:21'),(191,9,165,NULL,'2TD874','2024-10-21 16:41:34','2024-10-21 16:41:34'),(192,9,166,NULL,'IUCHZL','2024-10-21 16:44:09','2024-10-21 16:44:09'),(193,9,167,NULL,'TJED64','2024-10-21 16:46:21','2024-10-21 16:46:21'),(194,9,168,NULL,'MIN6FN','2024-10-21 16:46:47','2024-10-21 16:46:47'),(195,9,169,NULL,'TSMWB5','2024-10-21 16:49:51','2024-10-21 16:49:51'),(196,9,170,NULL,'ZRKXPX','2024-10-21 17:00:21','2024-10-21 17:00:21'),(197,9,171,NULL,'F24G11','2024-10-21 18:00:30','2024-10-21 18:00:30'),(198,11,172,NULL,'VWQPD9','2024-10-22 08:28:26','2024-10-22 08:28:26'),(199,11,173,NULL,'4BVAUF','2024-10-22 08:29:39','2024-10-22 08:29:39'),(200,11,174,NULL,'VFRH7B','2024-10-22 08:31:26','2024-10-22 08:31:26'),(201,11,175,'2024-10-22 08:32:55','P8X9Q2','2024-10-22 08:31:42','2024-10-22 08:32:55'),(202,11,176,NULL,'KBUFXX','2024-10-22 08:33:26','2024-10-22 08:33:26'),(203,11,177,NULL,'2XPMKY','2024-10-22 08:45:34','2024-10-22 08:45:34'),(204,11,178,NULL,'8FC9MF','2024-10-22 12:03:30','2024-10-22 12:03:30'),(205,11,179,NULL,'RT66Q4','2024-10-22 12:22:31','2024-10-22 12:22:31'),(206,11,180,'2024-10-23 08:22:19','DKA0OI','2024-10-23 08:20:00','2024-10-23 08:22:19'),(207,11,180,'2024-10-23 08:22:19','KW54PA','2024-10-23 08:20:00','2024-10-23 08:22:19'),(208,11,180,'2024-10-23 08:22:19','HX0ASO','2024-10-23 08:20:00','2024-10-23 08:22:19'),(209,11,180,'2024-10-23 08:22:19','AXASIG','2024-10-23 08:20:00','2024-10-23 08:22:19'),(210,11,180,'2024-10-23 08:22:19','8SSCH5','2024-10-23 08:20:00','2024-10-23 08:22:19'),(211,11,180,'2024-10-23 08:22:19','U9UM6N','2024-10-23 08:20:00','2024-10-23 08:22:19'),(212,11,180,'2024-10-23 08:22:19','N4XB4K','2024-10-23 08:20:00','2024-10-23 08:22:19'),(213,11,180,'2024-10-23 08:22:19','99FDFM','2024-10-23 08:20:00','2024-10-23 08:22:19'),(214,11,180,'2024-10-23 08:22:19','RGKSMP','2024-10-23 08:20:00','2024-10-23 08:22:19'),(215,11,180,'2024-10-23 08:22:19','2SF0I5','2024-10-23 08:20:00','2024-10-23 08:22:19'),(216,11,181,NULL,'AMCQWT','2024-10-23 08:26:09','2024-10-23 08:26:09'),(217,11,181,NULL,'A2AP5S','2024-10-23 08:26:09','2024-10-23 08:26:09'),(218,11,181,NULL,'NZ2WRY','2024-10-23 08:26:09','2024-10-23 08:26:09'),(223,11,184,NULL,'Y45OST','2024-10-23 08:30:28','2024-10-23 08:30:28'),(234,11,186,'2024-10-23 10:02:24','80OLW1','2024-10-23 08:37:00','2024-10-23 10:02:24'),(235,11,186,'2024-10-23 10:02:24','BV3NN2','2024-10-23 08:37:00','2024-10-23 10:02:24'),(236,11,186,'2024-10-23 10:02:24','PZG9LE','2024-10-23 08:37:00','2024-10-23 10:02:24'),(237,11,187,NULL,'ZTFO8N','2024-10-23 08:41:42','2024-10-23 08:41:42'),(238,11,188,NULL,'EXXYVC','2024-10-23 09:41:48','2024-10-23 09:41:48'),(239,11,189,NULL,'7KGTI5','2024-10-23 13:21:41','2024-10-23 13:21:41');

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `team_a` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `team_a_logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `team_b_logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `team_b` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `start_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` date NOT NULL,
  `created_by` bigint unsigned NOT NULL,
  `end_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_visibility` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_featured` tinyint(1) NOT NULL,
  `is_upcoming` tinyint(1) NOT NULL,
  `event_contact_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_created_by_foreign` (`created_by`),
  CONSTRAINT `event_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event`
--

INSERT INTO `event` VALUES (1,'Beatae velit consequ','team_logos/670fe628badfb_1729095208.jpg','team_logos/670fe628bae02_1729095208.jpg','Sit ex quo eos et as','2024-10-18','12:00 AM','2024-10-27',1,'12:15 AM','public','Noel Henson','Ad tempor saepe dign',0,1,'cusubawyci@mailinator.com','2024-10-16 19:13:28','2024-10-16 20:01:44'),(2,'Embu Supreme','team_logos/670ff178c4bc6_1729098104.jpg','team_logos/670ff178c4bcd_1729098104.jpg','3K FC','2024-10-27','12:00 PM','2024-10-27',1,'03:30 PM','public','Moi Stadium','Moi Stadium',0,1,'hs@gmail.com','2024-10-16 20:01:44','2024-10-16 22:26:05'),(3,'IShi','team_logos/6710134d7c5c7_1729106765.jpg','team_logos/6710134d7c5d3_1729106765.jpg','Quia et eius pariatu','2024-10-17','12:45 AM','2024-10-27',1,'12:15 AM','public','Linus Jordan','Aut eum temporibus n',0,1,'sago@mailinator.com','2024-10-16 22:26:05','2024-10-16 23:30:19'),(4,'Debitis laudantium','team_logos/6710225b406a1_1729110619.jpg','team_logos/6710225b406aa_1729110619.jpg','Quia voluptatibus vo','2024-10-19','12:15 AM','2024-10-26',1,'12:30 AM','public','Maggie Hooper','Voluptatem est nihi',0,1,'qejesipyko@mailinator.com','2024-10-16 23:30:19','2024-10-21 18:10:05'),(5,'3K FC','team_logos/67166ecd80aa1_1729523405.jpg','team_logos/67166ecd80aac_1729523405.jpeg','Naivas FC','2024-10-27','02:50 PM','2024-10-27',1,'05:00 PM','public','Embu Moi Stadium','Embu Moi Stadium',1,1,'test@example.com','2024-10-21 18:10:05','2024-10-21 20:26:49');

--
-- Table structure for table `event_image`
--

CREATE TABLE `event_image` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `event_meta_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_image_event_id_foreign` (`event_id`),
  CONSTRAINT `event_image_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_image`
--

INSERT INTO `event_image` VALUES (1,1,'event_meta_images/670fe63289fc0_football.jpg','2024-10-16 19:13:38','2024-10-16 19:13:38'),(2,1,'event_meta_images/670fe6329a33b_football1.jpg','2024-10-16 19:13:38','2024-10-16 19:13:38'),(3,1,'event_meta_images/670fe632b564d_football2.jpg','2024-10-16 19:13:38','2024-10-16 19:13:38'),(4,1,'event_meta_images/670fe632bbd93_football3.jpg','2024-10-16 19:13:38','2024-10-16 19:13:38'),(5,1,'event_meta_images/670fe632cce2e_football4.jpg','2024-10-16 19:13:38','2024-10-16 19:13:38'),(6,1,'event_meta_images/670fe632dfb8a_football5.jpg','2024-10-16 19:13:38','2024-10-16 19:13:38'),(7,2,'event_meta_images/670ff201c1d38_football.jpg','2024-10-16 20:04:01','2024-10-16 20:04:01'),(8,2,'event_meta_images/670ff201d1dab_football1.jpg','2024-10-16 20:04:01','2024-10-16 20:04:01'),(9,2,'event_meta_images/670ff201d2618_football2.jpg','2024-10-16 20:04:01','2024-10-16 20:04:01'),(10,2,'event_meta_images/670ff201e7f73_football3.jpg','2024-10-16 20:04:01','2024-10-16 20:04:01'),(11,2,'event_meta_images/670ff201e9a98_football4.jpg','2024-10-16 20:04:02','2024-10-16 20:04:02'),(12,2,'event_meta_images/670ff20215655_football5.jpg','2024-10-16 20:04:02','2024-10-16 20:04:02'),(13,3,'event_meta_images/67101359ca3d5_football.jpg','2024-10-16 22:26:17','2024-10-16 22:26:17'),(14,3,'event_meta_images/67101359d4f0f_football1.jpg','2024-10-16 22:26:17','2024-10-16 22:26:17'),(15,3,'event_meta_images/67101359e2db1_football2.jpg','2024-10-16 22:26:18','2024-10-16 22:26:18'),(16,3,'event_meta_images/6710135a0166e_football3.jpg','2024-10-16 22:26:18','2024-10-16 22:26:18'),(17,3,'event_meta_images/6710135a1aa61_football4.jpg','2024-10-16 22:26:18','2024-10-16 22:26:18'),(18,3,'event_meta_images/6710135a311ea_football5.jpg','2024-10-16 22:26:18','2024-10-16 22:26:18'),(19,4,'event_meta_images/671022c755e46_football.jpg','2024-10-16 23:32:07','2024-10-16 23:32:07'),(20,4,'event_meta_images/671022c76370d_football1.jpg','2024-10-16 23:32:07','2024-10-16 23:32:07'),(21,4,'event_meta_images/671022c781a0c_football2.jpg','2024-10-16 23:32:07','2024-10-16 23:32:07'),(22,4,'event_meta_images/671022c78e34a_football3.jpg','2024-10-16 23:32:07','2024-10-16 23:32:07'),(23,4,'event_meta_images/671022c7a40b0_football4.jpg','2024-10-16 23:32:07','2024-10-16 23:32:07'),(24,4,'event_meta_images/671022c80c03a_football5.jpg','2024-10-16 23:32:08','2024-10-16 23:32:08'),(25,5,'event_meta_images/67166f352d6b2_football.jpg','2024-10-21 18:11:49','2024-10-21 18:11:49'),(26,5,'event_meta_images/67166f35406a1_football1.jpg','2024-10-21 18:11:49','2024-10-21 18:11:49'),(27,5,'event_meta_images/67166f3547a71_football2.jpg','2024-10-21 18:11:49','2024-10-21 18:11:49'),(28,5,'event_meta_images/67166f3548af5_football3.jpg','2024-10-21 18:11:49','2024-10-21 18:11:49'),(29,5,'event_meta_images/67166f355cd34_football4.jpg','2024-10-21 18:11:49','2024-10-21 18:11:49'),(30,5,'event_meta_images/67166f357759a_football5.jpg','2024-10-21 18:11:49','2024-10-21 18:11:49');

--
-- Table structure for table `event_metadata`
--

CREATE TABLE `event_metadata` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `event_banner_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_desc` text COLLATE utf8mb4_unicode_ci,
  `dress_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_attendance` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_metadata_event_id_foreign` (`event_id`),
  CONSTRAINT `event_metadata_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_metadata`
--

INSERT INTO `event_metadata` VALUES (1,1,'event_banners/670fe63288982_1729095218.jpg','Et nihil ut natus om','Voluptatum architect',52,'2024-10-16 19:13:38','2024-10-16 19:13:38'),(2,2,'event_banners/670ff201b4d04_1729098241.png','MATCHDAY 5 OF 24/25 SEASON','TEAM JERSEYS',1000,'2024-10-16 20:04:01','2024-10-16 20:04:01'),(3,3,'event_banners/67101359c664a_1729106777.jpg','Asperiores aliquid m','Ipsum quos id in si',86,'2024-10-16 22:26:17','2024-10-16 23:08:52'),(4,4,'event_banners/671022c75370d_1729110727.png','Est ad excepturi mol','Omnis qui atque dolo',22,'2024-10-16 23:32:07','2024-10-18 10:54:35'),(5,5,'event_banners/67166f351ec25_1729523509.jpg','3K FC VS Naivas FC. Join us to witness history','Informal',5000,'2024-10-21 18:11:49','2024-10-22 08:31:11');

--
-- Table structure for table `event_state`
--

CREATE TABLE `event_state` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `is_draft` tinyint(1) NOT NULL DEFAULT '0',
  `is_ended` tinyint(1) NOT NULL DEFAULT '0',
  `is_archived` tinyint(1) NOT NULL DEFAULT '0',
  `is_open` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_state_event_id_foreign` (`event_id`),
  KEY `event_state_user_id_foreign` (`user_id`),
  CONSTRAINT `event_state_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE,
  CONSTRAINT `event_state_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_state`
--

INSERT INTO `event_state` VALUES (1,1,1,0,0,0,1,'2024-10-16 19:13:28','2024-10-16 19:13:39'),(2,2,1,0,0,0,1,'2024-10-16 20:01:44','2024-10-16 20:04:02'),(3,3,1,0,0,0,1,'2024-10-16 22:26:05','2024-10-16 22:26:18'),(4,4,1,0,0,0,1,'2024-10-16 23:30:19','2024-10-16 23:32:08'),(5,5,1,0,0,0,1,'2024-10-21 18:10:05','2024-10-21 18:11:49');

--
-- Table structure for table `event_tag`
--

CREATE TABLE `event_tag` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `tag_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_tag_event_id_foreign` (`event_id`),
  KEY `event_tag_tag_id_foreign` (`tag_id`),
  CONSTRAINT `event_tag_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE,
  CONSTRAINT `event_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_tag`
--

INSERT INTO `event_tag` VALUES (1,1,1,'2024-10-16 19:13:28','2024-10-16 19:13:28'),(2,2,1,'2024-10-16 20:01:44','2024-10-16 20:01:44'),(3,3,1,'2024-10-16 22:26:05','2024-10-16 22:26:05'),(4,4,1,'2024-10-16 23:30:19','2024-10-16 23:30:19'),(5,5,1,'2024-10-21 18:10:05','2024-10-21 18:10:05');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `guests`
--

CREATE TABLE `guests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guests`
--


--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_00_000000_create_person_table',1),(2,'0001_01_01_000000_create_user_table',1),(3,'0001_01_01_000001_create_cache_table',1),(4,'0001_01_01_000002_create_jobs_table',1),(5,'2024_09_19_124218_create_event_table',1),(6,'2024_09_19_161843_create_event_state_table',1),(7,'2024_09_19_192905_create_tag_table',1),(8,'2024_09_19_195940_create_event_tag_table',1),(9,'2024_09_20_035022_create_event_metadata_table',1),(10,'2024_09_24_034302_create_client_table',1),(11,'2024_09_24_055251_create_ticket_table',1),(12,'2024_09_24_121546_create_permission_tables',1),(13,'2024_09_27_062124_create_attendee_table',1),(14,'2024_09_27_081631_create_mpesa_table',1),(15,'2024_09_27_081642_create_payment_table',1),(16,'2024_09_27_095105_create_mpesa_payment_table',1),(17,'2024_09_27_202819_create_guest_table',1),(18,'2024_09_28_094557_create_attendee_event_table',1),(19,'2024_09_29_111654_create_event_image_table',1),(20,'2024_09_30_090352_create_client_ticket_table',1),(21,'2024_10_09_133648_create_personal_access_tokens_table',1),(22,'2024_10_23_075450_create_sms_table',2);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(3,'App\\Models\\User',3),(3,'App\\Models\\User',5),(3,'App\\Models\\User',6);

--
-- Table structure for table `mpesa`
--

CREATE TABLE `mpesa` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_time` timestamp NOT NULL,
  `transaction_amount` decimal(8,2) NOT NULL,
  `paid_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mpesa`
--

INSERT INTO `mpesa` VALUES (1,'SJG7C3KFQB','2024-10-16 19:33:02',1.00,'254795388886',1,'2024-10-16 19:33:02',NULL),(2,'SJG7CF2BFR','2024-10-16 20:33:17',1.00,'254716308459',1,'2024-10-16 20:33:17',NULL),(3,'SJG5CJ4I5R','2024-10-16 20:58:44',1.00,'254716308459',1,'2024-10-16 20:58:44',NULL),(4,'SJG7CVOTQZ','2024-10-16 23:09:50',1.00,'254716308459',1,'2024-10-16 23:09:50',NULL),(5,'SJG0CW8UQ2','2024-10-16 23:22:43',1.00,'254716308459',1,'2024-10-16 23:22:43',NULL),(6,'SJH3DDP7A5','2024-10-17 08:19:24',1.00,'254716308459',1,'2024-10-17 08:19:24',NULL),(7,'SJH7E5QZLV','2024-10-17 12:08:40',1.00,'254111882550',1,'2024-10-17 12:08:40',NULL),(8,'SJH0FOKQJQ','2024-10-17 18:21:51',1.00,'254111882550',1,'2024-10-17 18:21:51',NULL),(9,'SJI1HPONOX','2024-10-18 09:36:15',1.00,'254728831405',1,'2024-10-18 09:36:15',NULL),(10,'SJI6HRYW5Q','2024-10-18 09:54:17',1.00,'254111882550',1,'2024-10-18 09:54:17',NULL),(11,'SJI9HS8IHB','2024-10-18 09:56:22',1.00,'254111882550',1,'2024-10-18 09:56:22',NULL),(12,'SJI6HT5JYW','2024-10-18 10:03:41',1.00,'254111882550',1,'2024-10-18 10:03:41',NULL),(13,'SJI8IGKDKG','2024-10-18 13:02:14',1.00,'254111882550',1,'2024-10-18 13:02:14',NULL),(14,'SJI2IMBV6E','2024-10-18 13:42:27',1.00,'254111882550',1,'2024-10-18 13:42:27',NULL),(15,'SJI2INA0JM','2024-10-18 13:49:02',1.00,'254111882550',1,'2024-10-18 13:49:02',NULL),(16,'SJI6IO7ZKC','2024-10-18 13:55:38',1.00,'254111882550',1,'2024-10-18 13:55:38',NULL),(17,'SJI1IOHO0D','2024-10-18 13:57:27',1.00,'254111882550',1,'2024-10-18 13:57:27',NULL),(18,'SJI7IP8A5B','2024-10-18 14:02:49',1.00,'254111882550',1,'2024-10-18 14:02:49',NULL),(19,'SJI7IP8A5B','2024-10-18 14:02:49',1.00,'254111882550',1,'2024-10-18 14:02:49',NULL),(20,'SJI4IVCU1W','2024-10-18 14:46:27',1.00,'254728831405',1,'2024-10-18 14:46:27',NULL),(21,'SJI6IX345S','2024-10-18 14:58:48',1.00,'254713964404',1,'2024-10-18 14:58:48',NULL),(22,'SJI2IY7QAC','2024-10-18 15:06:58',1.00,'254722441353',1,'2024-10-18 15:06:58',NULL),(23,'SJI5J0WKV3','2024-10-18 15:26:08',1.00,'254111882550',1,'2024-10-18 15:26:08',NULL),(24,'SJI2J1H8AW','2024-10-18 15:30:11',1.00,'254111882550',1,'2024-10-18 15:30:11',NULL),(25,'SJI8J2CEEM','2024-10-18 15:36:16',1.00,'254111882550',1,'2024-10-18 15:36:16',NULL),(26,'SJI9J2N6NV','2024-10-18 15:38:14',1.00,'254111882550',1,'2024-10-18 15:38:14',NULL),(27,'SJI3J340A7','2024-10-18 15:41:33',1.00,'254111882550',1,'2024-10-18 15:41:33',NULL),(28,'SJI7J5G3PT','2024-10-18 15:57:33',1.00,'254722462531',1,'2024-10-18 15:57:33',NULL),(29,'SJI5JRSQWX','2024-10-18 18:07:43',1.00,'254111882550',1,'2024-10-18 18:07:43',NULL),(30,'SJI8JSEDZO','2024-10-18 18:10:48',1.00,'254111882550',1,'2024-10-18 18:10:48',NULL),(31,'SJI6K34UDG','2024-10-18 18:59:00',1.00,'254716308459',1,'2024-10-18 18:59:00',NULL),(32,'SJI6K34UDG','2024-10-18 18:59:00',1.00,'254716308459',1,'2024-10-18 18:59:00',NULL),(33,'SJI8K3RVKC','2024-10-18 19:01:47',1.00,'254111882550',1,'2024-10-18 19:01:47',NULL),(34,'SJJ6NM5X0S','2024-10-19 16:52:58',1.00,'254728831405',1,'2024-10-19 16:52:58',NULL),(35,'SJL8UK2E0M','2024-10-21 13:09:50',1.00,'254111882550',1,'2024-10-21 13:09:50',NULL),(36,'SJL8UK2E0M','2024-10-21 13:09:50',1.00,'254111882550',1,'2024-10-21 13:09:50',NULL),(37,'SJL7VELKS3','2024-10-21 16:50:01',1.00,'254111882550',1,'2024-10-21 16:50:01',NULL),(38,'SJL5VG724F','2024-10-21 17:00:39',1.00,'254111882550',1,'2024-10-21 17:00:39',NULL),(39,'SJL7VPX0GH','2024-10-21 18:00:40',1.00,'254111882550',1,'2024-10-21 18:00:40',NULL),(40,'SJM8XKYSY4','2024-10-22 08:31:52',1.00,'254111882550',1,'2024-10-22 08:31:52',NULL),(41,'SJM0YBG1JY','2024-10-22 12:03:58',1.00,'254718436332',1,'2024-10-22 12:03:58',NULL),(42,'SJN92NQQQV','2024-10-23 08:20:13',10.00,'254111882550',1,'2024-10-23 08:20:13',NULL),(43,'SJN92NQQQV','2024-10-23 08:20:13',10.00,'254111882550',1,'2024-10-23 08:20:13',NULL),(44,'SJN22PRSXM','2024-10-23 08:37:09',3.00,'254111882550',1,'2024-10-23 08:37:09',NULL),(45,'SJN22QCDK4','2024-10-23 08:41:53',1.00,'254111882550',1,'2024-10-23 08:41:53',NULL),(46,'SJN32Y2749','2024-10-23 09:42:08',1.00,'254728831405',1,'2024-10-23 09:42:08',NULL);

--
-- Table structure for table `mpesa_payment`
--

CREATE TABLE `mpesa_payment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `mpesa_id` bigint unsigned NOT NULL,
  `payment_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mpesa_payment_mpesa_id_foreign` (`mpesa_id`),
  KEY `mpesa_payment_payment_id_foreign` (`payment_id`),
  CONSTRAINT `mpesa_payment_mpesa_id_foreign` FOREIGN KEY (`mpesa_id`) REFERENCES `mpesa` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mpesa_payment_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mpesa_payment`
--

INSERT INTO `mpesa_payment` VALUES (1,1,5,'2024-10-16 19:33:02','2024-10-16 19:33:02'),(2,2,6,'2024-10-16 20:33:17','2024-10-16 20:33:17'),(3,3,9,'2024-10-16 20:58:44','2024-10-16 20:58:44'),(4,4,13,'2024-10-16 23:09:50','2024-10-16 23:09:50'),(5,5,14,'2024-10-16 23:22:43','2024-10-16 23:22:43'),(6,6,15,'2024-10-17 08:19:25','2024-10-17 08:19:25'),(7,7,21,'2024-10-17 12:08:40','2024-10-17 12:08:40'),(8,8,31,'2024-10-17 18:21:51','2024-10-17 18:21:51'),(9,9,52,'2024-10-18 09:36:15','2024-10-18 09:36:15'),(10,10,54,'2024-10-18 09:54:17','2024-10-18 09:54:17'),(11,11,55,'2024-10-18 09:56:22','2024-10-18 09:56:22'),(12,12,56,'2024-10-18 10:03:41','2024-10-18 10:03:41'),(13,13,67,'2024-10-18 13:02:15','2024-10-18 13:02:15'),(14,14,69,'2024-10-18 13:42:28','2024-10-18 13:42:28'),(15,15,72,'2024-10-18 13:49:02','2024-10-18 13:49:02'),(16,16,73,'2024-10-18 13:55:38','2024-10-18 13:55:38'),(17,17,74,'2024-10-18 13:57:27','2024-10-18 13:57:27'),(18,18,75,'2024-10-18 14:02:51','2024-10-18 14:02:51'),(19,19,75,'2024-10-18 14:03:06','2024-10-18 14:03:06'),(20,20,76,'2024-10-18 14:46:27','2024-10-18 14:46:27'),(21,21,77,'2024-10-18 14:58:48','2024-10-18 14:58:48'),(22,22,79,'2024-10-18 15:06:59','2024-10-18 15:06:59'),(23,23,81,'2024-10-18 15:26:08','2024-10-18 15:26:08'),(24,24,82,'2024-10-18 15:30:11','2024-10-18 15:30:11'),(25,25,83,'2024-10-18 15:36:16','2024-10-18 15:36:16'),(26,26,84,'2024-10-18 15:38:15','2024-10-18 15:38:15'),(27,27,85,'2024-10-18 15:41:33','2024-10-18 15:41:33'),(28,28,90,'2024-10-18 15:57:33','2024-10-18 15:57:33'),(29,29,93,'2024-10-18 18:07:43','2024-10-18 18:07:43'),(30,30,95,'2024-10-18 18:10:49','2024-10-18 18:10:49'),(31,31,98,'2024-10-18 18:59:01','2024-10-18 18:59:01'),(32,32,98,'2024-10-18 18:59:16','2024-10-18 18:59:16'),(33,33,99,'2024-10-18 19:01:48','2024-10-18 19:01:48'),(34,34,100,'2024-10-19 16:53:00','2024-10-19 16:53:00'),(35,35,113,'2024-10-21 13:09:51','2024-10-21 13:09:51'),(36,36,113,'2024-10-21 13:10:05','2024-10-21 13:10:05'),(37,37,169,'2024-10-21 16:50:01','2024-10-21 16:50:01'),(38,38,170,'2024-10-21 17:00:39','2024-10-21 17:00:39'),(39,39,171,'2024-10-21 18:00:40','2024-10-21 18:00:40'),(40,40,175,'2024-10-22 08:31:52','2024-10-22 08:31:52'),(41,41,178,'2024-10-22 12:03:58','2024-10-22 12:03:58'),(42,42,180,'2024-10-23 08:20:14','2024-10-23 08:20:14'),(43,43,180,'2024-10-23 08:20:21','2024-10-23 08:20:21'),(44,44,186,'2024-10-23 08:37:10','2024-10-23 08:37:10'),(45,45,187,'2024-10-23 08:41:53','2024-10-23 08:41:53'),(46,46,188,'2024-10-23 09:42:08','2024-10-23 09:42:08');

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ticket_id` bigint unsigned NOT NULL,
  `amount` double NOT NULL,
  `cash_amount` double DEFAULT '0',
  `mpesa_amount` double DEFAULT '0',
  `gross_amount` double NOT NULL,
  `payment_method` enum('CASH','MPESA','MPESA_CASH') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CASH',
  `is_attended` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_event_id_foreign` (`event_id`),
  KEY `payment_user_id_foreign` (`user_id`),
  KEY `payment_ticket_id_foreign` (`ticket_id`),
  CONSTRAINT `payment_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payment_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payment_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` VALUES (1,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 19:13:48','2024-10-16 19:13:48'),(2,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 19:18:28','2024-10-16 19:18:28'),(3,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 19:24:11','2024-10-16 19:24:11'),(4,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 19:29:12','2024-10-16 19:29:12'),(5,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 19:32:46','2024-10-16 19:32:46'),(6,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 20:33:01','2024-10-16 20:33:01'),(7,2,NULL,2,200,200,200,200,'MPESA',0,'2024-10-16 20:41:33','2024-10-16 20:41:33'),(8,2,NULL,2,200,200,200,200,'MPESA',0,'2024-10-16 20:42:59','2024-10-16 20:42:59'),(9,1,NULL,1,1,1,1,1,'MPESA',0,'2024-10-16 20:58:30','2024-10-16 20:58:30'),(11,2,NULL,2,200,200,200,200,'MPESA',0,'2024-10-16 21:11:55','2024-10-16 21:11:55'),(12,3,NULL,5,1,1,1,1,'MPESA',0,'2024-10-16 22:26:49','2024-10-16 22:26:49'),(13,3,NULL,7,1,1,1,1,'MPESA',0,'2024-10-16 23:09:37','2024-10-16 23:09:37'),(14,3,NULL,7,1,1,1,1,'MPESA',0,'2024-10-16 23:22:30','2024-10-16 23:22:30'),(15,3,NULL,5,1,1,1,1,'MPESA',0,'2024-10-17 08:19:09','2024-10-17 08:19:09'),(16,4,NULL,9,723,723,723,723,'MPESA',0,'2024-10-17 09:13:08','2024-10-17 09:13:08'),(17,4,NULL,9,723,723,723,723,'MPESA',0,'2024-10-17 11:49:23','2024-10-17 11:49:23'),(18,4,NULL,9,723,723,723,723,'MPESA',0,'2024-10-17 12:06:19','2024-10-17 12:06:19'),(19,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 12:07:08','2024-10-17 12:07:08'),(20,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 12:07:55','2024-10-17 12:07:55'),(21,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 12:08:28','2024-10-17 12:08:28'),(22,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 12:25:51','2024-10-17 12:25:51'),(23,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 12:27:56','2024-10-17 12:27:56'),(24,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 12:29:59','2024-10-17 12:29:59'),(25,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 13:00:41','2024-10-17 13:00:41'),(26,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 13:01:29','2024-10-17 13:01:29'),(27,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 13:02:36','2024-10-17 13:02:36'),(28,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 17:16:38','2024-10-17 17:16:38'),(30,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 17:18:34','2024-10-17 17:18:34'),(31,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:21:36','2024-10-17 18:21:36'),(32,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:26:55','2024-10-17 18:26:55'),(33,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:27:56','2024-10-17 18:27:56'),(34,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:30:34','2024-10-17 18:30:34'),(35,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:31:44','2024-10-17 18:31:44'),(37,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:32:49','2024-10-17 18:32:49'),(38,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:38:34','2024-10-17 18:38:34'),(39,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:40:19','2024-10-17 18:40:19'),(40,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:40:57','2024-10-17 18:40:57'),(41,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:43:27','2024-10-17 18:43:27'),(42,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:49:21','2024-10-17 18:49:21'),(43,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:53:54','2024-10-17 18:53:54'),(44,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:54:34','2024-10-17 18:54:34'),(45,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 18:57:11','2024-10-17 18:57:11'),(46,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 19:00:50','2024-10-17 19:00:50'),(47,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 19:02:52','2024-10-17 19:02:52'),(48,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 19:04:19','2024-10-17 19:04:19'),(49,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 19:04:37','2024-10-17 19:04:37'),(50,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 19:08:17','2024-10-17 19:08:17'),(51,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-17 19:09:26','2024-10-17 19:09:26'),(52,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 09:35:57','2024-10-18 09:35:57'),(53,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 09:51:03','2024-10-18 09:51:03'),(54,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 09:54:07','2024-10-18 09:54:07'),(55,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 09:56:14','2024-10-18 09:56:14'),(56,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:03:30','2024-10-18 10:03:30'),(57,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:14:57','2024-10-18 10:14:57'),(58,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:25:12','2024-10-18 10:25:12'),(59,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:28:58','2024-10-18 10:28:58'),(60,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:43:20','2024-10-18 10:43:20'),(61,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:45:37','2024-10-18 10:45:37'),(62,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 10:56:04','2024-10-18 10:56:04'),(63,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 11:04:32','2024-10-18 11:04:32'),(64,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 11:07:22','2024-10-18 11:07:22'),(65,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 11:28:38','2024-10-18 11:28:38'),(66,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 11:36:18','2024-10-18 11:36:18'),(67,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:01:57','2024-10-18 13:01:57'),(68,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 13:31:38','2024-10-18 13:31:38'),(69,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:42:10','2024-10-18 13:42:10'),(70,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:46:28','2024-10-18 13:46:28'),(71,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:48:28','2024-10-18 13:48:28'),(72,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:48:52','2024-10-18 13:48:52'),(73,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:55:26','2024-10-18 13:55:26'),(74,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 13:57:16','2024-10-18 13:57:16'),(75,4,NULL,9,5,5,5,5,'MPESA',0,'2024-10-18 14:02:37','2024-10-18 14:02:37'),(76,4,NULL,9,5,5,5,5,'MPESA',0,'2024-10-18 14:46:13','2024-10-18 14:46:13'),(77,3,NULL,5,1,1,1,1,'MPESA',0,'2024-10-18 14:58:30','2024-10-18 14:58:30'),(78,3,NULL,7,1,1,1,1,'MPESA',0,'2024-10-18 15:04:54','2024-10-18 15:04:54'),(79,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:06:45','2024-10-18 15:06:45'),(80,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 15:24:41','2024-10-18 15:24:41'),(81,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 15:26:00','2024-10-18 15:26:00'),(82,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:30:02','2024-10-18 15:30:02'),(83,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 15:36:04','2024-10-18 15:36:04'),(84,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:38:06','2024-10-18 15:38:06'),(85,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:41:23','2024-10-18 15:41:23'),(86,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:45:29','2024-10-18 15:45:29'),(87,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:47:45','2024-10-18 15:47:45'),(88,4,NULL,9,2,2,2,2,'MPESA',0,'2024-10-18 15:54:40','2024-10-18 15:54:40'),(89,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:56:03','2024-10-18 15:56:03'),(90,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:57:09','2024-10-18 15:57:09'),(91,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 15:57:36','2024-10-18 15:57:36'),(92,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 18:07:12','2024-10-18 18:07:12'),(93,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 18:07:35','2024-10-18 18:07:35'),(94,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-18 18:10:03','2024-10-18 18:10:03'),(95,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-18 18:10:41','2024-10-18 18:10:41'),(96,4,NULL,10,2,2,2,2,'MPESA',0,'2024-10-18 18:35:17','2024-10-18 18:35:17'),(97,4,NULL,9,4,4,4,4,'MPESA',0,'2024-10-18 18:37:07','2024-10-18 18:37:07'),(98,4,NULL,9,2,2,2,2,'MPESA',0,'2024-10-18 18:58:45','2024-10-18 18:58:45'),(99,4,NULL,9,1,1,1,1,'MPESA',1,'2024-10-18 19:01:36','2024-10-18 19:01:53'),(100,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-19 16:52:39','2024-10-19 16:52:39'),(101,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 10:38:16','2024-10-21 10:38:16'),(102,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:08:27','2024-10-21 11:08:27'),(103,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:12:40','2024-10-21 11:12:40'),(104,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:15:11','2024-10-21 11:15:11'),(105,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:24:14','2024-10-21 11:24:14'),(106,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:39:08','2024-10-21 11:39:08'),(107,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:43:44','2024-10-21 11:43:44'),(108,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 11:44:53','2024-10-21 11:44:53'),(109,4,NULL,10,1,1,1,1,'MPESA',0,'2024-10-21 11:47:12','2024-10-21 11:47:12'),(110,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 13:07:49','2024-10-21 13:07:49'),(111,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 13:08:03','2024-10-21 13:08:03'),(112,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 13:08:55','2024-10-21 13:08:55'),(113,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 13:09:39','2024-10-21 13:09:39'),(131,4,NULL,9,5,5,5,5,'MPESA',0,'2024-10-21 15:58:32','2024-10-21 15:58:32'),(132,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:00:54','2024-10-21 16:00:54'),(133,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:02:58','2024-10-21 16:02:58'),(136,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:05:32','2024-10-21 16:05:32'),(137,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:06:25','2024-10-21 16:06:25'),(138,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:06:31','2024-10-21 16:06:31'),(139,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:07:02','2024-10-21 16:07:02'),(140,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:07:05','2024-10-21 16:07:05'),(141,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:07:47','2024-10-21 16:07:47'),(144,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:08:33','2024-10-21 16:08:33'),(145,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:08:46','2024-10-21 16:08:46'),(146,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:08:56','2024-10-21 16:08:56'),(147,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:12:08','2024-10-21 16:12:08'),(150,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:12:53','2024-10-21 16:12:53'),(151,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:13:02','2024-10-21 16:13:02'),(152,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:13:07','2024-10-21 16:13:07'),(153,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:13:12','2024-10-21 16:13:12'),(154,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:17:14','2024-10-21 16:17:14'),(155,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:17:21','2024-10-21 16:17:21'),(156,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:17:25','2024-10-21 16:17:25'),(157,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:20:37','2024-10-21 16:20:37'),(158,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:25:44','2024-10-21 16:25:44'),(159,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:29:34','2024-10-21 16:29:34'),(160,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:30:51','2024-10-21 16:30:51'),(161,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:31:41','2024-10-21 16:31:41'),(162,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:34:55','2024-10-21 16:34:55'),(163,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:38:31','2024-10-21 16:38:31'),(164,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:39:21','2024-10-21 16:39:21'),(165,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:41:34','2024-10-21 16:41:34'),(166,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:44:09','2024-10-21 16:44:09'),(167,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:46:21','2024-10-21 16:46:21'),(168,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:46:47','2024-10-21 16:46:47'),(169,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 16:49:51','2024-10-21 16:49:51'),(170,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 17:00:21','2024-10-21 17:00:21'),(171,4,NULL,9,1,1,1,1,'MPESA',0,'2024-10-21 18:00:30','2024-10-21 18:00:30'),(172,5,NULL,11,100,100,100,100,'MPESA',0,'2024-10-22 08:28:26','2024-10-22 08:28:26'),(173,5,NULL,11,100,100,100,100,'MPESA',0,'2024-10-22 08:29:39','2024-10-22 08:29:39'),(174,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-22 08:31:26','2024-10-22 08:31:26'),(175,5,NULL,11,1,1,1,1,'MPESA',1,'2024-10-22 08:31:42','2024-10-22 08:32:56'),(176,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-22 08:33:26','2024-10-22 08:33:26'),(177,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-22 08:45:34','2024-10-22 08:45:34'),(178,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-22 12:03:30','2024-10-22 12:03:30'),(179,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-22 12:22:31','2024-10-22 12:22:31'),(180,5,NULL,11,10,10,10,10,'MPESA',1,'2024-10-23 08:20:00','2024-10-23 08:22:19'),(181,5,NULL,11,3,3,3,3,'MPESA',0,'2024-10-23 08:26:09','2024-10-23 08:26:09'),(184,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-23 08:30:28','2024-10-23 08:30:28'),(186,5,NULL,11,3,3,3,3,'MPESA',1,'2024-10-23 08:37:00','2024-10-23 09:22:51'),(187,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-23 08:41:42','2024-10-23 08:41:42'),(188,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-23 09:41:48','2024-10-23 09:41:48'),(189,5,NULL,11,1,1,1,1,'MPESA',0,'2024-10-23 13:21:41','2024-10-23 13:21:41');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'add_user','web','2024-10-16 19:11:50','2024-10-16 19:11:50');

--
-- Table structure for table `person`
--

CREATE TABLE `person` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phonenumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondaryphone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person`
--

INSERT INTO `person` VALUES (1,'wkirlin','Prof. Jaime Keeling','(973) 807-1823',NULL,'35','243','Male','2024-10-16 19:11:51','2024-10-16 19:11:51'),(2,'xcrist','Khalil Feil IV','940.718.6387',NULL,'35','71','Female','2024-10-16 19:11:51','2024-10-16 19:11:51'),(3,'yschinner','Elias Hudson','(757) 554-6391',NULL,'45','57','Female','2024-10-16 19:11:52','2024-10-16 19:11:52'),(4,'wohara','Pinkie O\'Hara','+1-843-434-3338',NULL,'42','4941268','Female','2024-10-16 19:11:52','2024-10-16 19:11:52'),(5,'goodwin.dedric','Fred Casper','832-975-4883',NULL,'37','5','Female','2024-10-16 19:11:52','2024-10-16 19:11:52'),(6,'carey12','Darion Bartell','734-734-1732',NULL,'39','40328','Male','2024-10-16 19:11:52','2024-10-16 19:11:52'),(7,NULL,'samuel m',NULL,NULL,NULL,NULL,NULL,'2024-10-18 09:41:13','2024-10-18 09:41:13'),(8,'bevohiji','Colton','+1 (247) 389-5141',NULL,'85','669','male','2024-10-18 18:56:50','2024-10-18 18:56:50'),(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-10-18 19:01:36','2024-10-18 19:01:36'),(10,'rutesa','Natalie','+1 (416) 679-2736',NULL,'22','884','male','2024-10-22 08:16:30','2024-10-22 08:16:30'),(11,'wenof','Bert','+1 (249) 322-5084',NULL,'100','32','male','2024-10-22 08:27:34','2024-10-22 08:27:34'),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-10-22 08:33:25','2024-10-22 08:33:25'),(13,NULL,'Mwaniki a',NULL,NULL,NULL,NULL,NULL,'2024-10-22 12:21:13','2024-10-22 12:21:13'),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-10-23 08:20:00','2024-10-23 08:20:00'),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-10-23 08:26:09','2024-10-23 08:26:09'),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-10-23 08:30:28','2024-10-23 08:30:28'),(20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-10-23 08:37:00','2024-10-23 08:37:00');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,2);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'super_admin','web','2024-10-16 19:11:49','2024-10-16 19:11:49'),(2,'admin','web','2024-10-16 19:11:49','2024-10-16 19:11:49'),(3,'clerk','web','2024-10-16 19:11:49','2024-10-16 19:11:49'),(4,'user','web','2024-10-16 19:11:49','2024-10-16 19:11:49');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('1aLJopvd75ojZZ1Ldvf6ikoWZCA2sffotEla7Xv3',NULL,'196.201.218.68','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWVldTd3YllmQVFYSVREZFZXa1Y4d1dvWnF0N1ZoM3VTaHlFQ0huZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvZ3Vlc3RfcHVyY2hhc2VfdGlja2V0LzExIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729678915),('BSP5PIy13iqOTrpnhl9z81hdCGMVTcKbY7a4qsWW',1,'102.219.209.138','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36 Edg/131.0.0.0','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiaktLZDFEcGhxd0htOXY4ckxkbVI3cDBRY2MyZk9jVzd1QlhSWlBjWSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvdGlja2V0aWVyL2V2ZW50L3Nob3cvNSI7fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6MzU6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvdGlja2V0aWVyIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjQ6ImF1dGgiO2E6MTp7czoyMToicGFzc3dvcmRfY29uZmlybWVkX2F0IjtpOjE3Mjk2Nzg3NDc7fX0=',1729680870),('bTN0yNtrfpF0r1zsvBXoP4TptK6wEqcChg4q6KvX',NULL,'102.219.209.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTkhpWXZpVlFJRDRXaUEzYlNQQlczMGdmTGIydWxWQnl4RGFGb3AxYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvZ3Vlc3RfcHVyY2hhc2VfdGlja2V0LzExIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729679794),('DAlvT6R0R1cJc1AUCiIR74S0ESVyddFj2qZytymU',NULL,'54.247.57.72','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.152 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoia2Y1UmRGcE9MZXBPYWxNR3kxM0loQnMxa21obEUwWlpYcDFsengwYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vdGlja2V0cy4za2ZjLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729669661),('EU7aI0I7oFOaRbPqT5BrNB31pwmesgcaEItANiIG',NULL,'34.76.133.13','Mozilla/5.0 (Windows NT 10.0; rv:78.0) Gecko/20100101 Firefox/78.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoibndBSU5YV09aV3pGa09wZ3FFUmFLemlIcnB0VFNrTFdvRDNiY0pGTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly8xMDIuMjEyLjI0NS4xMjkvdGlja2V0LWFkbWluL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1729687970),('f6VNUySJOSebNJ7d5JjjD2GdC3CCJpfM9ad09yCp',NULL,'102.219.209.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNkpwOFJwNWw1alZkNm1BSVBsVDUyNlNBZ0kyRmwxMnI1WDJJd3pHOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvZ3Vlc3RfcHVyY2hhc2VfdGlja2V0LzExIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729666294),('LituYq8zXQvhGIbp4LT19TvimwSCk70ybFcJlryr',NULL,'105.160.122.0','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWFNaGd2cWFxdnA0empYV2lxMDRyRjc5akJ3ZzRKREJ2UERRQ0I5ZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvZ3Vlc3QvZXZlbnQvNSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1729676967),('RFl8vygvsJTjvxRWeVFXQNMbEYjgrKtPLDqlLrc1',NULL,'54.247.57.72','Mozilla/5.0 (X11; Linux x86_64; rv:83.0) Gecko/20100101 Firefox/83.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT2hsSHQ1dUkyUXlYdU85UndIU3hWZTI5Q0hhS2pJOFR3WUh0UG5WYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vdGlja2V0cy4za2ZjLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729669656),('RhpZwgQhAua1yILOle3pjVbP7wpfQijWsgeYiuYy',NULL,'179.43.168.146','l9tcpid/v1.1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOGRRUE0yeXZ4SUFxSGlseFZtNnJXd1lLNUNmVmVoUDUxbTB5RWNlVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vMTAyLjIxMi4yNDUuMTI5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729665426),('uZpd2Z6pSZDGPuhz3T6znkTK0dULKQJtrlKBsgP5',NULL,'54.247.57.72','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMzJRbnhlZVBWYWhFNVB2U0VzVmpPSTNkdHRzM0ZNTzJuVU9hVUxKTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vdGlja2V0cy4za2ZjLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729669657),('vjGk3tWKCKrqG7CTIzlKcpor8xE48UihIJnPAfhk',NULL,'197.232.122.217','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYmhyZm5xcVI1cjRsVUNzZ216QkJqWjd6Vlp4a2NwYkhWallRaVBsMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vdGlja2V0cy4za2ZjLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1729667876),('ym9uzNmwsU1ruk4FCIfFhhSfU3OiIRiYubEAAGla',NULL,'197.232.122.217','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTzZQMjdqOGZnbnhCY0JreDhlaU5iU2JnZlJpMjdxTTFhbUx6cWJyRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vdGlja2V0Lm9oYXUuY28ua2UvZ3Vlc3QvZXZlbnQvNSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1729687942);

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` int NOT NULL,
  `sent_to` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sms` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `error` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms`
--


--
-- Table structure for table `tag`
--

CREATE TABLE `tag` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_by` bigint unsigned DEFAULT NULL,
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_created_by_foreign` (`created_by`),
  CONSTRAINT `tag_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tag`
--

INSERT INTO `tag` VALUES (1,NULL,'Football',NULL,NULL);

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int NOT NULL,
  `capacity` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_event_id_foreign` (`event_id`),
  CONSTRAINT `ticket_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` VALUES (1,1,'Carla Diaz',1,NULL,'2024-10-16 19:13:39','2024-10-16 19:13:39'),(2,2,'EARLY BIRD',200,NULL,'2024-10-16 20:04:02','2024-10-16 20:04:02'),(3,2,'REGULAR',300,NULL,'2024-10-16 20:04:02','2024-10-16 20:04:02'),(4,2,'VIP',500,NULL,'2024-10-16 20:04:02','2024-10-16 20:04:02'),(5,3,'VI',1,NULL,'2024-10-16 22:26:18','2024-10-16 22:54:17'),(7,3,'rr',1,NULL,'2024-10-16 23:06:38','2024-10-16 23:06:38'),(8,3,'test',1,NULL,'2024-10-16 23:08:52','2024-10-16 23:08:52'),(9,4,'Alfreda Madden',1,NULL,'2024-10-16 23:32:08','2024-10-17 12:06:50'),(10,4,'VIP',1,NULL,'2024-10-18 10:54:35','2024-10-18 10:54:35'),(11,5,'Regular',1,NULL,'2024-10-21 18:11:49','2024-10-22 08:31:11'),(12,5,'VIP',200,NULL,'2024-10-21 18:11:49','2024-10-21 18:11:49');


