--
-- Host: localhost    Database: sibifit
-- ------------------------------------------------------


--
-- Table structure for table `attendances`
--

CREATE TABLE `attendances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) unsigned DEFAULT NULL,
  `guest_name` varchar(255) DEFAULT NULL,
  `guest_phone` varchar(255) DEFAULT NULL,
  `type` enum('member','guest') NOT NULL DEFAULT 'member',
  `amount_paid` decimal(12,2) DEFAULT NULL,
  `checked_in_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendances_type_index` (`type`),
  KEY `attendances_checked_in_at_index` (`checked_in_at`),
  KEY `attendances_type_checked_in_at_index` (`type`,`checked_in_at`),
  KEY `attendances_member_id_checked_in_at_index` (`member_id`,`checked_in_at`),
  CONSTRAINT `attendances_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=314 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendances`
--

INSERT INTO `attendances` VALUES
(1,1,NULL,NULL,'member',NULL,'2026-05-14 00:40:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(2,3,NULL,NULL,'member',NULL,'2026-05-13 23:22:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(3,4,NULL,NULL,'member',NULL,'2026-05-13 23:53:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(4,5,NULL,NULL,'member',NULL,'2026-05-13 23:47:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(5,NULL,'Budi Santoso','082500897836','guest',50000.00,'2026-05-14 01:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(6,NULL,'Dewi Lestari','083990480662','guest',50000.00,'2026-05-14 01:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(7,NULL,'Andi Wijaya','089039047287','guest',50000.00,'2026-05-14 02:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(8,NULL,'Guest 75','087276184324','guest',50000.00,'2026-05-13 11:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(9,1,NULL,NULL,'member',NULL,'2026-05-13 08:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(10,7,NULL,NULL,'member',NULL,'2026-05-13 00:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(11,NULL,'Guest 38','085591380493','guest',50000.00,'2026-05-13 11:52:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(12,1,NULL,NULL,'member',NULL,'2026-05-13 08:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(13,1,NULL,NULL,'member',NULL,'2026-05-13 03:41:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(14,NULL,'Guest 68','082044346185','guest',50000.00,'2026-05-13 08:33:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(15,4,NULL,NULL,'member',NULL,'2026-05-11 23:08:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(16,4,NULL,NULL,'member',NULL,'2026-05-12 02:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(17,NULL,'Guest 9','082085139045','guest',50000.00,'2026-05-12 06:26:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(18,1,NULL,NULL,'member',NULL,'2026-05-12 06:55:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(19,3,NULL,NULL,'member',NULL,'2026-05-12 08:44:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(20,3,NULL,NULL,'member',NULL,'2026-05-12 12:20:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(21,1,NULL,NULL,'member',NULL,'2026-05-12 13:32:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(22,NULL,'Guest 55','088903818562','guest',50000.00,'2026-05-12 01:49:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(23,7,NULL,NULL,'member',NULL,'2026-05-12 11:53:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(24,8,NULL,NULL,'member',NULL,'2026-05-12 07:34:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(25,3,NULL,NULL,'member',NULL,'2026-05-12 01:53:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(26,NULL,'Guest 19','088277202799','guest',50000.00,'2026-05-11 12:51:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(27,8,NULL,NULL,'member',NULL,'2026-05-10 23:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(28,3,NULL,NULL,'member',NULL,'2026-05-11 06:51:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(29,5,NULL,NULL,'member',NULL,'2026-05-11 09:58:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(30,3,NULL,NULL,'member',NULL,'2026-05-11 12:45:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(31,8,NULL,NULL,'member',NULL,'2026-05-11 13:50:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(32,NULL,'Guest 25','082620525705','guest',50000.00,'2026-05-11 12:59:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(33,5,NULL,NULL,'member',NULL,'2026-05-11 10:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(34,NULL,'Guest 89','081426305446','guest',50000.00,'2026-05-11 09:08:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(35,8,NULL,NULL,'member',NULL,'2026-05-11 01:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(36,8,NULL,NULL,'member',NULL,'2026-05-11 09:29:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(37,5,NULL,NULL,'member',NULL,'2026-05-11 10:33:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(38,8,NULL,NULL,'member',NULL,'2026-05-11 09:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(39,7,NULL,NULL,'member',NULL,'2026-05-11 07:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(40,7,NULL,NULL,'member',NULL,'2026-05-11 07:29:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(41,3,NULL,NULL,'member',NULL,'2026-05-10 01:51:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(42,5,NULL,NULL,'member',NULL,'2026-05-10 13:36:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(43,7,NULL,NULL,'member',NULL,'2026-05-10 05:19:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(44,7,NULL,NULL,'member',NULL,'2026-05-10 00:19:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(45,NULL,'Guest 15','085241461194','guest',50000.00,'2026-05-10 06:43:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(46,NULL,'Guest 94','088209193625','guest',50000.00,'2026-05-10 08:15:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(47,4,NULL,NULL,'member',NULL,'2026-05-10 05:14:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(48,NULL,'Guest 30','089616049446','guest',50000.00,'2026-05-10 13:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(49,3,NULL,NULL,'member',NULL,'2026-05-10 08:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(50,4,NULL,NULL,'member',NULL,'2026-05-10 06:22:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(51,NULL,'Guest 71','088023652832','guest',50000.00,'2026-05-10 09:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(52,5,NULL,NULL,'member',NULL,'2026-05-09 03:47:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(53,NULL,'Guest 46','085362477391','guest',50000.00,'2026-05-09 06:11:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(54,NULL,'Guest 69','087061572860','guest',50000.00,'2026-05-09 07:03:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(55,5,NULL,NULL,'member',NULL,'2026-05-09 06:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(56,NULL,'Guest 57','084100708264','guest',50000.00,'2026-05-09 04:31:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(57,5,NULL,NULL,'member',NULL,'2026-05-09 13:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(58,1,NULL,NULL,'member',NULL,'2026-05-09 00:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(59,7,NULL,NULL,'member',NULL,'2026-05-09 07:57:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(60,8,NULL,NULL,'member',NULL,'2026-05-09 14:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(61,7,NULL,NULL,'member',NULL,'2026-05-09 06:34:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(62,3,NULL,NULL,'member',NULL,'2026-05-09 07:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(63,8,NULL,NULL,'member',NULL,'2026-05-09 11:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(64,NULL,'Guest 39','086801891969','guest',50000.00,'2026-05-09 11:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(65,7,NULL,NULL,'member',NULL,'2026-05-09 06:28:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(66,4,NULL,NULL,'member',NULL,'2026-05-09 10:53:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(67,3,NULL,NULL,'member',NULL,'2026-05-08 09:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(68,7,NULL,NULL,'member',NULL,'2026-05-08 02:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(69,5,NULL,NULL,'member',NULL,'2026-05-08 12:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(70,5,NULL,NULL,'member',NULL,'2026-05-08 13:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(71,5,NULL,NULL,'member',NULL,'2026-05-08 09:44:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(72,5,NULL,NULL,'member',NULL,'2026-05-08 12:27:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(73,NULL,'Guest 86','086495803810','guest',50000.00,'2026-05-08 05:00:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(74,8,NULL,NULL,'member',NULL,'2026-05-08 02:37:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(75,1,NULL,NULL,'member',NULL,'2026-05-07 03:27:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(76,4,NULL,NULL,'member',NULL,'2026-05-07 00:10:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(77,1,NULL,NULL,'member',NULL,'2026-05-07 04:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(78,4,NULL,NULL,'member',NULL,'2026-05-07 07:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(79,NULL,'Guest 100','081228395869','guest',50000.00,'2026-05-07 02:49:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(80,NULL,'Guest 13','084216116138','guest',50000.00,'2026-05-07 02:19:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(81,NULL,'Guest 68','089303576812','guest',50000.00,'2026-05-07 10:31:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(82,5,NULL,NULL,'member',NULL,'2026-05-05 23:49:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(83,4,NULL,NULL,'member',NULL,'2026-05-06 13:31:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(84,NULL,'Guest 10','081937175568','guest',50000.00,'2026-05-06 11:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(85,4,NULL,NULL,'member',NULL,'2026-05-06 00:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(86,5,NULL,NULL,'member',NULL,'2026-05-06 04:19:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(87,1,NULL,NULL,'member',NULL,'2026-05-06 12:19:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(88,4,NULL,NULL,'member',NULL,'2026-05-05 23:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(89,8,NULL,NULL,'member',NULL,'2026-05-06 07:26:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(90,8,NULL,NULL,'member',NULL,'2026-05-05 04:34:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(91,8,NULL,NULL,'member',NULL,'2026-05-05 12:04:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(92,1,NULL,NULL,'member',NULL,'2026-05-04 23:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(93,5,NULL,NULL,'member',NULL,'2026-05-05 07:44:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(94,5,NULL,NULL,'member',NULL,'2026-05-05 07:50:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(95,5,NULL,NULL,'member',NULL,'2026-05-05 07:53:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(96,8,NULL,NULL,'member',NULL,'2026-05-05 08:02:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(97,4,NULL,NULL,'member',NULL,'2026-05-05 06:42:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(98,3,NULL,NULL,'member',NULL,'2026-05-04 10:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(99,4,NULL,NULL,'member',NULL,'2026-05-04 12:26:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(100,5,NULL,NULL,'member',NULL,'2026-05-04 14:42:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(101,1,NULL,NULL,'member',NULL,'2026-05-04 13:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(102,4,NULL,NULL,'member',NULL,'2026-05-04 04:41:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(103,NULL,'Guest 48','089697011906','guest',50000.00,'2026-05-04 02:47:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(104,3,NULL,NULL,'member',NULL,'2026-05-04 02:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(105,NULL,'Guest 89','089738991527','guest',50000.00,'2026-05-04 11:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(106,5,NULL,NULL,'member',NULL,'2026-05-03 23:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(107,1,NULL,NULL,'member',NULL,'2026-05-04 01:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(108,NULL,'Guest 32','083738003674','guest',50000.00,'2026-05-04 11:39:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(109,1,NULL,NULL,'member',NULL,'2026-05-04 05:36:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(110,8,NULL,NULL,'member',NULL,'2026-05-04 07:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(111,NULL,'Guest 42','085705046061','guest',50000.00,'2026-05-04 10:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(112,3,NULL,NULL,'member',NULL,'2026-05-03 13:04:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(113,4,NULL,NULL,'member',NULL,'2026-05-03 10:39:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(114,NULL,'Guest 85','081661479950','guest',50000.00,'2026-05-03 04:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(115,NULL,'Guest 26','086489915088','guest',50000.00,'2026-05-03 12:12:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(116,5,NULL,NULL,'member',NULL,'2026-05-03 14:47:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(117,4,NULL,NULL,'member',NULL,'2026-05-03 10:08:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(118,7,NULL,NULL,'member',NULL,'2026-05-03 01:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(119,3,NULL,NULL,'member',NULL,'2026-05-03 02:32:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(120,NULL,'Guest 45','081963147897','guest',50000.00,'2026-05-03 12:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(121,8,NULL,NULL,'member',NULL,'2026-05-03 05:39:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(122,4,NULL,NULL,'member',NULL,'2026-05-03 14:52:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(123,NULL,'Guest 64','087296556825','guest',50000.00,'2026-05-03 11:22:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(124,5,NULL,NULL,'member',NULL,'2026-05-03 05:44:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(125,NULL,'Guest 49','084177201085','guest',50000.00,'2026-05-03 02:20:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(126,1,NULL,NULL,'member',NULL,'2026-05-03 07:11:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(127,1,NULL,NULL,'member',NULL,'2026-05-02 00:08:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(128,NULL,'Guest 3','083146710348','guest',50000.00,'2026-05-02 13:16:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(129,NULL,'Guest 58','088157544386','guest',50000.00,'2026-05-02 07:00:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(130,4,NULL,NULL,'member',NULL,'2026-05-02 13:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(131,1,NULL,NULL,'member',NULL,'2026-05-02 07:14:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(132,8,NULL,NULL,'member',NULL,'2026-05-02 05:52:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(133,8,NULL,NULL,'member',NULL,'2026-05-02 13:03:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(134,1,NULL,NULL,'member',NULL,'2026-05-02 04:49:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(135,5,NULL,NULL,'member',NULL,'2026-05-02 01:52:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(136,3,NULL,NULL,'member',NULL,'2026-05-02 11:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(137,7,NULL,NULL,'member',NULL,'2026-05-02 06:26:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(138,3,NULL,NULL,'member',NULL,'2026-05-02 07:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(139,5,NULL,NULL,'member',NULL,'2026-05-02 00:58:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(140,4,NULL,NULL,'member',NULL,'2026-05-01 02:26:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(141,3,NULL,NULL,'member',NULL,'2026-05-01 14:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(142,3,NULL,NULL,'member',NULL,'2026-05-01 09:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(143,NULL,'Guest 76','085743206746','guest',50000.00,'2026-05-01 04:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(144,NULL,'Guest 39','082967276099','guest',50000.00,'2026-05-01 07:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(145,4,NULL,NULL,'member',NULL,'2026-05-01 00:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(146,3,NULL,NULL,'member',NULL,'2026-05-01 09:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(147,NULL,'Guest 61','086263564594','guest',50000.00,'2026-05-01 07:36:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(148,NULL,'Guest 39','087163019947','guest',50000.00,'2026-05-01 05:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(149,NULL,'Guest 69','086776648051','guest',50000.00,'2026-05-01 06:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(150,1,NULL,NULL,'member',NULL,'2026-04-30 06:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(151,1,NULL,NULL,'member',NULL,'2026-04-30 03:40:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(152,4,NULL,NULL,'member',NULL,'2026-04-30 02:50:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(153,5,NULL,NULL,'member',NULL,'2026-04-30 00:12:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(154,8,NULL,NULL,'member',NULL,'2026-04-30 09:03:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(155,7,NULL,NULL,'member',NULL,'2026-04-30 07:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(156,3,NULL,NULL,'member',NULL,'2026-04-29 14:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(157,7,NULL,NULL,'member',NULL,'2026-04-29 11:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(158,NULL,'Guest 10','085790548551','guest',50000.00,'2026-04-29 12:30:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(159,1,NULL,NULL,'member',NULL,'2026-04-29 05:04:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(160,3,NULL,NULL,'member',NULL,'2026-04-29 04:20:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(161,NULL,'Guest 49','089226299852','guest',50000.00,'2026-04-28 10:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(162,7,NULL,NULL,'member',NULL,'2026-04-27 23:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(163,4,NULL,NULL,'member',NULL,'2026-04-28 12:37:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(164,NULL,'Guest 23','081440498944','guest',50000.00,'2026-04-28 11:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(165,7,NULL,NULL,'member',NULL,'2026-04-28 12:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(166,4,NULL,NULL,'member',NULL,'2026-04-28 00:42:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(167,NULL,'Guest 43','085079500463','guest',50000.00,'2026-04-28 07:29:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(168,NULL,'Guest 77','087744227442','guest',50000.00,'2026-04-27 01:37:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(169,1,NULL,NULL,'member',NULL,'2026-04-27 11:04:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(170,NULL,'Guest 9','089364678000','guest',50000.00,'2026-04-27 08:36:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(171,1,NULL,NULL,'member',NULL,'2026-04-27 12:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(172,4,NULL,NULL,'member',NULL,'2026-04-27 04:45:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(173,5,NULL,NULL,'member',NULL,'2026-04-27 06:33:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(174,7,NULL,NULL,'member',NULL,'2026-04-27 01:03:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(175,7,NULL,NULL,'member',NULL,'2026-04-27 05:56:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(176,5,NULL,NULL,'member',NULL,'2026-04-27 08:16:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(177,8,NULL,NULL,'member',NULL,'2026-04-27 04:43:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(178,1,NULL,NULL,'member',NULL,'2026-04-27 06:11:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(179,4,NULL,NULL,'member',NULL,'2026-04-27 12:32:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(180,1,NULL,NULL,'member',NULL,'2026-04-26 03:33:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(181,4,NULL,NULL,'member',NULL,'2026-04-26 12:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(182,5,NULL,NULL,'member',NULL,'2026-04-26 14:55:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(183,NULL,'Guest 12','086251220108','guest',50000.00,'2026-04-26 10:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(184,5,NULL,NULL,'member',NULL,'2026-04-26 12:50:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(185,8,NULL,NULL,'member',NULL,'2026-04-26 14:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(186,NULL,'Guest 40','087147095292','guest',50000.00,'2026-04-26 01:23:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(187,5,NULL,NULL,'member',NULL,'2026-04-26 12:47:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(188,NULL,'Guest 68','089448365077','guest',50000.00,'2026-04-26 08:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(189,1,NULL,NULL,'member',NULL,'2026-04-26 11:43:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(190,3,NULL,NULL,'member',NULL,'2026-04-26 03:42:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(191,4,NULL,NULL,'member',NULL,'2026-04-26 09:58:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(192,NULL,'Guest 26','088279290339','guest',50000.00,'2026-04-25 01:22:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(193,4,NULL,NULL,'member',NULL,'2026-04-25 02:47:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(194,5,NULL,NULL,'member',NULL,'2026-04-24 23:32:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(195,3,NULL,NULL,'member',NULL,'2026-04-24 23:27:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(196,1,NULL,NULL,'member',NULL,'2026-04-25 13:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(197,3,NULL,NULL,'member',NULL,'2026-04-25 09:33:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(198,7,NULL,NULL,'member',NULL,'2026-04-25 11:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(199,NULL,'Guest 39','087085642043','guest',50000.00,'2026-04-25 13:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(200,3,NULL,NULL,'member',NULL,'2026-04-25 10:23:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(201,NULL,'Guest 46','087030522572','guest',50000.00,'2026-04-25 05:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(202,3,NULL,NULL,'member',NULL,'2026-04-24 10:00:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(203,4,NULL,NULL,'member',NULL,'2026-04-24 00:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(204,7,NULL,NULL,'member',NULL,'2026-04-24 13:10:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(205,1,NULL,NULL,'member',NULL,'2026-04-24 12:59:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(206,4,NULL,NULL,'member',NULL,'2026-04-24 14:04:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(207,7,NULL,NULL,'member',NULL,'2026-04-24 05:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(208,NULL,'Guest 96','087608518603','guest',50000.00,'2026-04-24 11:43:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(209,4,NULL,NULL,'member',NULL,'2026-04-23 01:20:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(210,NULL,'Guest 29','087347161978','guest',50000.00,'2026-04-23 13:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(211,4,NULL,NULL,'member',NULL,'2026-04-23 12:03:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(212,7,NULL,NULL,'member',NULL,'2026-04-23 10:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(213,NULL,'Guest 71','087384631170','guest',50000.00,'2026-04-23 13:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(214,NULL,'Guest 22','089252930912','guest',50000.00,'2026-04-23 12:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(215,4,NULL,NULL,'member',NULL,'2026-04-23 10:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(216,8,NULL,NULL,'member',NULL,'2026-04-23 07:43:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(217,8,NULL,NULL,'member',NULL,'2026-04-23 05:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(218,3,NULL,NULL,'member',NULL,'2026-04-22 08:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(219,7,NULL,NULL,'member',NULL,'2026-04-22 07:24:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(220,4,NULL,NULL,'member',NULL,'2026-04-22 07:22:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(221,8,NULL,NULL,'member',NULL,'2026-04-22 10:22:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(222,3,NULL,NULL,'member',NULL,'2026-04-22 11:59:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(223,NULL,'Guest 24','086505217915','guest',50000.00,'2026-04-22 06:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(224,7,NULL,NULL,'member',NULL,'2026-04-22 11:28:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(225,4,NULL,NULL,'member',NULL,'2026-04-22 09:56:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(226,4,NULL,NULL,'member',NULL,'2026-04-22 00:37:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(227,7,NULL,NULL,'member',NULL,'2026-04-22 10:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(228,7,NULL,NULL,'member',NULL,'2026-04-22 09:08:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(229,3,NULL,NULL,'member',NULL,'2026-04-22 02:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(230,7,NULL,NULL,'member',NULL,'2026-04-21 11:31:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(231,1,NULL,NULL,'member',NULL,'2026-04-21 05:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(232,7,NULL,NULL,'member',NULL,'2026-04-21 12:36:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(233,5,NULL,NULL,'member',NULL,'2026-04-21 13:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(234,NULL,'Guest 36','088532935121','guest',50000.00,'2026-04-21 13:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(235,5,NULL,NULL,'member',NULL,'2026-04-21 11:03:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(236,NULL,'Guest 10','082107637711','guest',50000.00,'2026-04-21 13:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(237,1,NULL,NULL,'member',NULL,'2026-04-21 02:00:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(238,5,NULL,NULL,'member',NULL,'2026-04-21 04:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(239,4,NULL,NULL,'member',NULL,'2026-04-20 23:02:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(240,NULL,'Guest 95','089103502397','guest',50000.00,'2026-04-21 07:12:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(241,3,NULL,NULL,'member',NULL,'2026-04-20 13:01:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(242,4,NULL,NULL,'member',NULL,'2026-04-20 14:10:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(243,1,NULL,NULL,'member',NULL,'2026-04-20 11:45:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(244,8,NULL,NULL,'member',NULL,'2026-04-20 14:18:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(245,8,NULL,NULL,'member',NULL,'2026-04-20 13:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(246,NULL,'Guest 14','084756993832','guest',50000.00,'2026-04-20 09:32:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(247,1,NULL,NULL,'member',NULL,'2026-04-19 23:57:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(248,3,NULL,NULL,'member',NULL,'2026-04-20 02:54:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(249,NULL,'Guest 98','081908063571','guest',50000.00,'2026-04-20 03:45:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(250,3,NULL,NULL,'member',NULL,'2026-04-19 02:16:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(251,3,NULL,NULL,'member',NULL,'2026-04-19 05:55:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(252,4,NULL,NULL,'member',NULL,'2026-04-19 09:53:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(253,1,NULL,NULL,'member',NULL,'2026-04-19 05:46:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(254,1,NULL,NULL,'member',NULL,'2026-04-19 01:44:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(255,3,NULL,NULL,'member',NULL,'2026-04-19 02:44:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(256,8,NULL,NULL,'member',NULL,'2026-04-19 13:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(257,5,NULL,NULL,'member',NULL,'2026-04-19 12:14:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(258,4,NULL,NULL,'member',NULL,'2026-04-19 06:33:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(259,3,NULL,NULL,'member',NULL,'2026-04-19 09:07:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(260,5,NULL,NULL,'member',NULL,'2026-04-19 10:12:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(261,1,NULL,NULL,'member',NULL,'2026-04-19 03:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(262,1,NULL,NULL,'member',NULL,'2026-04-19 06:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(263,4,NULL,NULL,'member',NULL,'2026-04-19 03:41:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(264,1,NULL,NULL,'member',NULL,'2026-04-18 23:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(265,7,NULL,NULL,'member',NULL,'2026-04-18 08:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(266,5,NULL,NULL,'member',NULL,'2026-04-18 02:56:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(267,7,NULL,NULL,'member',NULL,'2026-04-18 04:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(268,5,NULL,NULL,'member',NULL,'2026-04-18 11:11:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(269,7,NULL,NULL,'member',NULL,'2026-04-18 13:25:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(270,8,NULL,NULL,'member',NULL,'2026-04-18 08:55:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(271,3,NULL,NULL,'member',NULL,'2026-04-18 14:41:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(272,4,NULL,NULL,'member',NULL,'2026-04-17 06:05:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(273,8,NULL,NULL,'member',NULL,'2026-04-17 10:45:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(274,1,NULL,NULL,'member',NULL,'2026-04-17 05:30:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(275,NULL,'Guest 81','082113841709','guest',50000.00,'2026-04-17 03:12:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(276,7,NULL,NULL,'member',NULL,'2026-04-17 12:48:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(277,4,NULL,NULL,'member',NULL,'2026-04-17 05:17:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(278,7,NULL,NULL,'member',NULL,'2026-04-17 05:15:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(279,5,NULL,NULL,'member',NULL,'2026-04-17 03:09:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(280,7,NULL,NULL,'member',NULL,'2026-04-17 07:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(281,3,NULL,NULL,'member',NULL,'2026-04-16 23:24:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(282,8,NULL,NULL,'member',NULL,'2026-04-17 11:02:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(283,7,NULL,NULL,'member',NULL,'2026-04-17 04:35:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(284,8,NULL,NULL,'member',NULL,'2026-04-17 00:52:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(285,4,NULL,NULL,'member',NULL,'2026-04-16 14:31:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(286,8,NULL,NULL,'member',NULL,'2026-04-15 23:02:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(287,3,NULL,NULL,'member',NULL,'2026-04-16 07:27:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(288,5,NULL,NULL,'member',NULL,'2026-04-16 13:20:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(289,1,NULL,NULL,'member',NULL,'2026-04-16 09:28:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(290,7,NULL,NULL,'member',NULL,'2026-04-16 08:55:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(291,1,NULL,NULL,'member',NULL,'2026-04-16 05:42:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(292,5,NULL,NULL,'member',NULL,'2026-04-16 03:21:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(293,5,NULL,NULL,'member',NULL,'2026-04-16 07:23:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(294,7,NULL,NULL,'member',NULL,'2026-04-16 04:12:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(295,NULL,'Guest 13','084138435503','guest',50000.00,'2026-04-16 04:31:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(296,3,NULL,NULL,'member',NULL,'2026-04-15 12:23:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(297,NULL,'Guest 84','081357127246','guest',50000.00,'2026-04-15 10:56:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(298,1,NULL,NULL,'member',NULL,'2026-04-15 14:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(299,7,NULL,NULL,'member',NULL,'2026-04-15 08:51:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(300,1,NULL,NULL,'member',NULL,'2026-04-15 11:13:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(301,NULL,'Guest 42','085525843765','guest',50000.00,'2026-04-14 04:51:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(302,NULL,'Guest 70','083249636379','guest',50000.00,'2026-04-14 07:41:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(303,5,NULL,NULL,'member',NULL,'2026-04-14 12:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(304,8,NULL,NULL,'member',NULL,'2026-04-13 23:36:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(305,1,NULL,NULL,'member',NULL,'2026-04-14 02:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(306,8,NULL,NULL,'member',NULL,'2026-04-14 07:38:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(307,NULL,'Guest 7','088300067190','guest',50000.00,'2026-04-14 03:43:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(308,4,NULL,NULL,'member',NULL,'2026-04-14 04:06:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(309,8,NULL,NULL,'member',NULL,'2026-04-14 05:11:00','2026-05-13 17:16:31','2026-05-13 17:16:31'),
(310,NULL,'adehud','083841476999','guest',50000.00,'2026-05-13 17:38:24','2026-05-13 17:38:24','2026-05-13 17:38:24'),
(311,NULL,'ted','11111111111','guest',50000.00,'2026-05-13 17:42:51','2026-05-13 17:42:51','2026-05-13 17:42:51'),
(312,9,NULL,NULL,'member',NULL,'2026-05-14 23:04:05','2026-05-14 23:04:05','2026-05-14 23:04:05'),
(313,NULL,'tes','08000000000','guest',50000.00,'2026-05-14 23:05:57','2026-05-14 23:05:57','2026-05-14 23:05:57');

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `expense_date` date NOT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` VALUES
(1,'Listrik & Air',300000.00,'2026-05-15','token listrik','2026-05-14 23:19:10','2026-05-14 23:19:10'),
(2,'Pemasaran',500000.00,'2026-05-15','pemasaran','2026-05-14 23:19:44','2026-05-14 23:19:44');

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

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

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


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

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) 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(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint(5) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) 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 `members`
--

CREATE TABLE `members` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `qr_code` varchar(255) NOT NULL,
  `status` enum('active','expired','frozen') NOT NULL DEFAULT 'active',
  `pt_sessions_remaining` int(11) NOT NULL DEFAULT 0,
  `trainer_id` bigint(20) unsigned DEFAULT NULL,
  `registered_at` date NOT NULL,
  `expired_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `members_phone_unique` (`phone`),
  UNIQUE KEY `members_qr_code_unique` (`qr_code`),
  KEY `members_status_index` (`status`),
  KEY `members_expired_at_index` (`expired_at`),
  KEY `members_status_expired_at_index` (`status`,`expired_at`),
  KEY `members_trainer_id_foreign` (`trainer_id`),
  CONSTRAINT `members_trainer_id_foreign` FOREIGN KEY (`trainer_id`) REFERENCES `trainers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` VALUES
(1,'Marcus Thompson','081234567890',NULL,'SF-6A05145F4AB43-8923','active',0,NULL,'2023-10-12','2026-06-28','2026-05-13 17:16:31','2026-05-13 17:16:31',NULL),
(2,'Sarah Chen','081199887766',NULL,'SF-6A05145F4B92D-6220','active',0,NULL,'2023-01-05','2026-06-13','2026-05-13 17:16:31','2026-05-13 17:38:57',NULL),
(3,'David Miller','085522331100',NULL,'SF-6A05145F4BE5E-8220','active',0,NULL,'2024-02-18','2026-09-11','2026-05-13 17:16:31','2026-05-13 17:16:31',NULL),
(4,'Elena Rodriguez','082211445566',NULL,'SF-6A05145F4C2E4-8255','active',0,NULL,'2023-11-30','2026-05-17','2026-05-13 17:16:31','2026-05-13 17:16:31',NULL),
(5,'Ahmad Fauzi','081398765432',NULL,'SF-6A05145F4C7D0-4468','active',0,NULL,'2024-03-01','2026-07-13','2026-05-13 17:16:31','2026-05-13 17:16:31',NULL),
(6,'Putri Handayani','087812345678',NULL,'SF-6A05145F4CBB7-9245','active',0,NULL,'2023-06-15','2026-06-13','2026-05-13 17:16:31','2026-05-13 17:42:23',NULL),
(7,'Rizky Pratama','081567890123',NULL,'SF-6A05145F4CFBE-6728','active',0,NULL,'2024-01-10','2026-11-30','2026-05-13 17:16:31','2026-05-13 17:16:31',NULL),
(8,'Siti Nurhaliza','082345678901',NULL,'SF-6A05145F4D429-4131','active',0,NULL,'2024-04-01','2026-05-19','2026-05-13 17:16:31','2026-05-13 17:16:31',NULL),
(9,'Ade Hudori','081329999170',NULL,'SF-6A05181B3BEA3-8866','active',4,1,'2026-05-14','2026-06-13','2026-05-13 17:32:27','2026-05-14 23:04:05',NULL),
(10,'tes','084444444444',NULL,'SF-PR2TOOL55UXC','active',0,NULL,'2026-05-15','2026-06-14','2026-05-14 23:06:34','2026-05-14 23:06:51',NULL);

--
-- Table structure for table `membership_packages`
--

CREATE TABLE `membership_packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `duration_days` int(11) NOT NULL,
  `price` decimal(12,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_packages`
--

INSERT INTO `membership_packages` VALUES
(1,'1 Bulan',30,250000.00,1,'2026-05-13 17:16:31','2026-05-14 15:28:48'),
(2,'3 Bulan',90,750000.00,1,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(3,'1 Tahun',365,2500000.00,1,'2026-05-13 17:16:31','2026-05-13 17:16:31');

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

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

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

INSERT INTO `migrations` VALUES
(1,'0001_01_01_000000_create_users_table',1),
(2,'0001_01_01_000001_create_cache_table',1),
(3,'0001_01_01_000002_create_jobs_table',1),
(4,'2024_01_01_000003_create_members_table',1),
(5,'2024_01_01_000004_create_membership_packages_table',1),
(6,'2024_01_01_000005_create_subscriptions_table',1),
(7,'2024_01_01_000006_create_attendances_table',1),
(8,'2024_01_01_000007_create_settings_table',1),
(9,'2026_05_14_001105_add_role_to_users_table',1),
(10,'2026_05_15_000001_add_performance_indexes',2),
(11,'2026_05_15_000002_change_role_to_enum',2),
(12,'2026_05_15_055153_create_pt_packages_table',3),
(13,'2026_05_15_055153_create_trainers_table',3),
(14,'2026_05_15_055154_add_pt_columns_to_members_table',3),
(15,'2026_05_15_055154_create_pt_sessions_table',3),
(16,'2026_05_15_061433_create_expenses_table',4);

--
-- Table structure for table `pt_packages`
--

CREATE TABLE `pt_packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `sessions_count` int(11) NOT NULL,
  `price` decimal(12,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pt_packages`
--

INSERT INTO `pt_packages` VALUES
(1,'Premium',5,500000.00,1,'2026-05-14 23:02:29','2026-05-14 23:02:29');

--
-- Table structure for table `pt_sessions`
--

CREATE TABLE `pt_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) unsigned NOT NULL,
  `trainer_id` bigint(20) unsigned DEFAULT NULL,
  `session_date` timestamp NOT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pt_sessions_member_id_foreign` (`member_id`),
  KEY `pt_sessions_trainer_id_foreign` (`trainer_id`),
  CONSTRAINT `pt_sessions_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pt_sessions_trainer_id_foreign` FOREIGN KEY (`trainer_id`) REFERENCES `trainers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pt_sessions`
--

INSERT INTO `pt_sessions` VALUES
(1,9,1,'2026-05-14 23:04:05',NULL,'2026-05-14 23:04:05','2026-05-14 23:04:05');

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) 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
('gQsNB1Azv5ywXC2a8IrNrAGwAQCwkZJePfWQoMyZ',1,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64; rv:150.0) Gecko/20100101 Firefox/150.0','eyJfdG9rZW4iOiI4YTBBTEdYQjZkWUFkVlNQcFF0bUFvbnhaSFlVYmJwQ2RXVWQ0S1NZIiwidXJsIjpbXSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAxXC9yZXBvcnRzIiwicm91dGUiOiJyZXBvcnRzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1778802080),
('J16uufOiEXmVrWjXAttr92wH9LyyKSohEcfOtyzN',1,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJjbk56Q0lUWjJId3hPNmFRRURVbHRpN0dTSkc4UUU0c3RQc0JZT24xIiwidXJsIjpbXSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAxXC9zZXR0aW5ncyIsInJvdXRlIjoic2V0dGluZ3MifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MX0=',1778802123);

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) unsigned NOT NULL,
  `membership_package_id` bigint(20) unsigned DEFAULT NULL,
  `package_name` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `payment_method` varchar(255) NOT NULL DEFAULT 'cash',
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscriptions_member_id_foreign` (`member_id`),
  KEY `subscriptions_membership_package_id_foreign` (`membership_package_id`),
  KEY `subscriptions_created_at_index` (`created_at`),
  CONSTRAINT `subscriptions_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subscriptions_membership_package_id_foreign` FOREIGN KEY (`membership_package_id`) REFERENCES `membership_packages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` VALUES
(1,1,2,'3 Bulan',750000.00,'2026-03-30','2026-06-28','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(2,2,1,'1 Bulan',300000.00,'2026-03-30','2026-04-29','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(3,3,3,'1 Tahun',2500000.00,'2025-09-11','2026-09-11','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(4,4,1,'1 Bulan',300000.00,'2026-04-17','2026-05-17','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(5,5,2,'3 Bulan',750000.00,'2026-04-14','2026-07-13','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(6,6,1,'1 Bulan',300000.00,'2026-03-15','2026-04-14','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(7,7,3,'1 Tahun',2500000.00,'2025-11-30','2026-11-30','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(8,8,1,'1 Bulan',300000.00,'2026-04-19','2026-05-19','cash',NULL,'2026-05-13 17:16:31','2026-05-13 17:16:31'),
(9,9,1,'1 Bulan',300000.00,'2026-05-14','2026-06-13','cash',NULL,'2026-05-13 17:32:27','2026-05-13 17:32:27'),
(10,2,1,'1 Bulan',300000.00,'2026-05-14','2026-06-13','cash',NULL,'2026-05-13 17:38:57','2026-05-13 17:38:57'),
(11,6,1,'1 Bulan',300000.00,'2026-05-14','2026-06-13','cash',NULL,'2026-05-13 17:42:23','2026-05-13 17:42:23'),
(12,9,NULL,'[PT] Premium (5 Sesi)',500000.00,'2026-05-15','2026-08-15','cash',NULL,'2026-05-14 23:03:33','2026-05-14 23:03:33'),
(13,10,1,'1 Bulan',250000.00,'2026-05-15','2026-06-14','cash',NULL,'2026-05-14 23:06:51','2026-05-14 23:06:51');

--
-- Table structure for table `trainers`
--

CREATE TABLE `trainers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `trainers_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trainers`
--

INSERT INTO `trainers` VALUES
(1,'Jon','08111111111','active','2026-05-14 23:01:38','2026-05-14 23:01:38',NULL),
(2,'Ade Ray','08333333333','active','2026-05-14 23:02:58','2026-05-14 23:02:58',NULL);


