/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: sibifit -- ------------------------------------------------------ -- Server version 10.11.14-MariaDB-0ubuntu0.24.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `attendances` -- DROP TABLE IF EXISTS `attendances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendances` -- LOCK TABLES `attendances` WRITE; /*!40000 ALTER TABLE `attendances` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `attendances` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expenses` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `members` -- DROP TABLE IF EXISTS `members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `members` -- LOCK TABLES `members` WRITE; /*!40000 ALTER TABLE `members` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `membership_packages` -- DROP TABLE IF EXISTS `membership_packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `membership_packages` -- LOCK TABLES `membership_packages` WRITE; /*!40000 ALTER TABLE `membership_packages` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `membership_packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pt_packages` -- DROP TABLE IF EXISTS `pt_packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pt_packages` -- LOCK TABLES `pt_packages` WRITE; /*!40000 ALTER TABLE `pt_packages` DISABLE KEYS */; INSERT INTO `pt_packages` VALUES (1,'Premium',5,500000.00,1,'2026-05-14 23:02:29','2026-05-14 23:02:29'); /*!40000 ALTER TABLE `pt_packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pt_sessions` -- DROP TABLE IF EXISTS `pt_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pt_sessions` -- LOCK TABLES `pt_sessions` WRITE; /*!40000 ALTER TABLE `pt_sessions` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `pt_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(255) NOT NULL, `value` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_key_unique` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'gym_name','SibiFit Gym','2026-05-13 17:16:31','2026-05-13 17:16:31'), (2,'gym_address','Jl. Fitness No. 1, Jakarta','2026-05-13 17:16:31','2026-05-13 17:16:31'), (3,'daily_visit_price','50000','2026-05-13 17:16:31','2026-05-13 17:16:31'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscriptions` -- DROP TABLE IF EXISTS `subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscriptions` -- LOCK TABLES `subscriptions` WRITE; /*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `trainers` -- DROP TABLE IF EXISTS `trainers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `trainers` -- LOCK TABLES `trainers` WRITE; /*!40000 ALTER TABLE `trainers` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `trainers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `role` enum('owner','cashier') NOT NULL DEFAULT 'owner', `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Owner SibiFit','owner@sibifit.com','owner',NULL,'$2y$12$GaDAafVjsOS0YFt2ZW2auuMB0ZABrli.D83YSft5I69.9.m/MkzTO',NULL,'2026-05-13 17:16:31','2026-05-14 15:27:02'), (2,'Kasir SibiFit','kasir@sibifit.com','cashier',NULL,'$2y$12$A8L5kIjdIgZFdlD035/OEOTW288UUckovezIoDvnb6kry5mN9Je/y',NULL,'2026-05-13 17:16:31','2026-05-14 15:28:08'), (3,'kasir','kasir1@sibifit.com','cashier',NULL,'$2y$12$/tJXXb8eANFDK.z88aaWhOYAjjG2k0WcwKRGYg5CgdojK89tltPmO',NULL,'2026-05-14 15:27:53','2026-05-14 15:27:53'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-05-15 6:44:34