-- phpMyAdmin SQL Dump -- version 6.0.0-dev+20260725.fe4be26eeb -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 26, 2026 at 02:24 PM -- Server version: 8.4.3 -- PHP Version: 8.3.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `eventamikom_3182_db` -- -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES (1, 'Seminar IT', 'seminar-it', '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (2, 'Entertainment', 'entertainment', '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (3, 'Bisnis', 'bisnis', '2026-07-24 13:10:00', '2026-07-24 13:10:00'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` bigint UNSIGNED NOT NULL, `category_id` bigint UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `date` datetime NOT NULL, `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` int NOT NULL, `stock` int NOT NULL, `poster_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `partner_id` bigint UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `category_id`, `title`, `description`, `date`, `location`, `price`, `stock`, `poster_path`, `created_at`, `updated_at`, `partner_id`) VALUES (1, 1, 'UI/UX Masterclass', 'Belajar desain UI/UX dari dasar hingga mahir.', '2026-05-01 10:00:00', 'Lab Komputer', 50000, 95, 'posters/event-1.png', '2026-07-24 13:10:00', '2026-07-25 23:30:10', 2), (2, 1, 'Web Development Bootcamp', 'Pelatihan membuat website modern.', '2026-05-02 10:00:00', 'Lab Programming', 50000, 100, 'posters/event-2.png', '2026-07-24 13:10:00', '2026-07-24 13:10:00', 2), (3, 2, 'E-Sport U-Champ', 'Turnamen e-sport antar mahasiswa.', '2026-05-03 10:00:00', 'Auditorium', 50000, 100, 'posters/event-3.png', '2026-07-24 13:10:00', '2026-07-25 23:47:40', 3), (4, 2, 'Music Festival', 'Festival musik meriah dengan berbagai band.', '2026-05-04 18:00:00', 'Lapangan Kampus', 50000, 100, 'posters/event-4.png', '2026-07-24 13:10:00', '2026-07-24 13:10:00', 1), (5, 3, 'Digital Marketing Seminar', 'Strategi marketing di era digital.', '2026-05-05 13:00:00', 'Ruang Seminar', 50000, 100, 'posters/event-5.png', '2026-07-24 13:10:00', '2026-07-25 23:44:09', 1), (6, 3, 'Startup Pitching Day', 'Presentasi ide bisnis startup.', '2026-05-06 13:00:00', 'Inkubator Bisnis', 50000, 100, 'posters/event-6.png', '2026-07-24 13:10:00', '2026-07-24 13:10:00', 3); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint UNSIGNED NOT NULL, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint UNSIGNED NOT NULL, `reserved_at` int UNSIGNED DEFAULT NULL, `available_at` int UNSIGNED NOT NULL, `created_at` int UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `jobs` -- INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES (12, 'default', '{\"uuid\":\"72f7d648-77df-4b9b-8c5f-90bebab9cd9e\",\"displayName\":\"App\\\\Jobs\\\\ReleaseExpiredTicket\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\ReleaseExpiredTicket\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\ReleaseExpiredTicket\\\":2:{s:14:\\\"\\u0000*\\u0000transaction\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Transaction\\\";s:2:\\\"id\\\";i:25;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2026-07-26 04:30:05.174629\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\",\"batchId\":null},\"createdAt\":1785039305,\"delay\":900}', 0, NULL, 1785040205, 1785039305); -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int NOT NULL, `pending_jobs` int NOT NULL, `failed_jobs` int NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int DEFAULT NULL, `created_at` int NOT NULL, `finished_at` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) 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, '2026_04_24_133938_create_categories_table', 1), (5, '2026_04_24_133939_create_events_table', 1), (6, '2026_04_24_133939_create_transactions_table', 1), (7, '2026_04_24_134650_add_role_to_users_table', 1), (8, '2026_05_19_142753_create_partners_table', 1), (9, '2026_07_23_043954_create_reviews_table', 1), (10, '2026_07_23_055834_add_user_id_and_status_to_partners_table', 1), (11, '2026_07_23_055915_add_phone_and_description_to_partners_table', 1), (12, '2026_07_24_000001_add_google_id_to_users_table', 1), (13, '2026_08_01_000001_add_partner_id_to_events_table', 1), (14, '2026_07_26_061418_add_attendance_to_transactions_table', 2); -- -------------------------------------------------------- -- -- Table structure for table `partners` -- CREATE TABLE `partners` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` bigint UNSIGNED DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'pending, active, suspended', `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `partners` -- INSERT INTO `partners` (`id`, `name`, `logo_url`, `created_at`, `updated_at`, `user_id`, `status`, `phone`, `description`, `email`) VALUES (1, 'ABP Productions', NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00', 2, 'active', '081234567890', 'Penyelenggara event musik dan festival profesional.', 'abp@productions.com'), (2, 'TechEvent Indonesia', NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00', 3, 'active', '081234567891', 'Penyelenggara seminar dan workshop teknologi.', 'techevent@indonesia.com'), (3, 'Kreativa Studio', NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00', 4, 'pending', '081234567892', 'Studio kreatif yang menyelenggarakan event seni dan kompetisi.', 'kreativa@studio.com'); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` bigint UNSIGNED NOT NULL, `event_id` bigint UNSIGNED NOT NULL, `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `rating` tinyint UNSIGNED NOT NULL COMMENT 'Rating 1-5', `review` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint UNSIGNED DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` bigint UNSIGNED NOT NULL, `event_id` bigint UNSIGNED NOT NULL, `order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_price` int NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending', `is_attended` tinyint(1) NOT NULL DEFAULT '0', `snap_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `event_id`, `order_id`, `customer_name`, `customer_email`, `customer_phone`, `total_price`, `status`, `is_attended`, `snap_token`, `created_at`, `updated_at`) VALUES (1, 1, 'TRX-99210', 'Donni Prabowo', 'donni.prabowo@gmail.com', '081234567890', 50000, 'success', 0, NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (2, 2, 'TRX-99211', 'Ragisha Hanny', 'ragisha@amikom.ac.id', '089876543210', 50000, 'success', 0, NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (3, 3, 'TRX-99212', 'Budi Setiawan', 'budi@gmail.com', '085612345678', 50000, 'pending', 0, NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (4, 1, 'TRX-1784924458-iaZJV', 'dqasd', 'ragishahanny@students.amikom.ac.id', '1234567890', 55000, 'Pending', 0, NULL, '2026-07-24 13:20:58', '2026-07-24 13:20:58'), (5, 1, 'TRX-1784924459-DBY2g', 'dqasd', 'ragishahanny@students.amikom.ac.id', '1234567890', 55000, 'Pending', 0, NULL, '2026-07-24 13:20:59', '2026-07-24 13:20:59'), (6, 1, 'TRX-1784976878-rGno4', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 03:54:38', '2026-07-25 03:54:38'), (7, 1, 'TRX-1784977051-48P2m', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 03:57:31', '2026-07-25 03:57:31'), (8, 1, 'TRX-1784977099-imJ6I', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 03:58:19', '2026-07-25 03:58:19'), (9, 1, 'TRX-1784977319-sTTyF', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 04:01:59', '2026-07-25 04:01:59'), (10, 1, 'TRX-1784977404-sU07Q', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 04:03:24', '2026-07-25 04:03:24'), (11, 1, 'TRX-1784977477-nqiwm', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 04:04:37', '2026-07-25 04:04:37'), (12, 1, 'TRX-1784977743-TOMP1', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 04:09:03', '2026-07-25 04:09:04'), (13, 1, 'TRX-1784977830-77mFT', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Failed', 0, NULL, '2026-07-25 04:10:30', '2026-07-25 04:10:31'), (14, 1, 'TRX-1784978362-520PQ', 'seyla', 'seyla@gmail.com', '1234567890', 55000, 'Expired', 0, 'abd3bb20-9de5-4f9f-961a-e5ef580247d5', '2026-07-25 04:19:22', '2026-07-25 04:34:25'), (15, 1, 'TRX-1784983643-DiX8S', 'seyla', 'seysey@gmail.com', '08123456789', 55000, 'Expired', 0, 'bad24d85-7d52-453d-af0a-b26ec69da8a8', '2026-07-25 05:47:23', '2026-07-25 06:02:25'), (16, 1, 'TRX-1784983708-boVwo', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '12345678', 55000, 'Expired', 0, '20663e17-a6e4-416e-85d8-ac3e8456fdd1', '2026-07-25 05:48:28', '2026-07-25 06:03:31'), (17, 1, 'TRX-1784984259-mXh23', 'asdfghjk', 'sdfgh@gmail.com', '123456789', 55000, 'Expired', 0, '9b693584-6472-4491-8b6a-58185689170a', '2026-07-25 05:57:39', '2026-07-25 06:12:40'), (18, 1, 'TRX-1784990368-75eDc', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '123456789', 55000, 'Expired', 0, 'f6766715-af1d-4551-b83c-908d1037acac', '2026-07-25 07:39:28', '2026-07-25 07:54:30'), (19, 1, 'TRX-1784991037-cOypj', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '123456789', 55000, 'used', 0, '5cc5b425-73b4-41df-9701-17b92ddbb348', '2026-07-25 07:50:37', '2026-07-25 08:48:27'), (20, 1, 'TRX-1784995225-k0Dz1', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '123456789', 55000, 'success', 0, '7c0234a0-818f-45d6-ae11-b847d6872945', '2026-07-25 09:00:25', '2026-07-25 09:01:35'), (21, 1, 'TRX-1784995989-IInuC', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '12345678', 55000, 'Expired', 0, '283a6fcc-3ab4-4551-8fba-ac6192db98a4', '2026-07-25 09:13:09', '2026-07-25 09:28:10'), (22, 1, 'TRX-1784996311-eGw7O', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '12345678', 55000, 'success', 0, '5dd23fe6-178e-4294-ab27-c8655b2f8ec5', '2026-07-25 09:18:31', '2026-07-25 09:20:45'), (23, 1, 'TRX-1784996485-5GMaL', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '123456789', 55000, 'success', 0, '71643db4-8105-4460-a5f1-b63719e672ec', '2026-07-25 09:21:25', '2026-07-25 09:22:06'), (24, 1, 'TRX-1784997286-eCbmS', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '9032345678', 55000, 'used', 0, '74c93c0f-8c2e-4cb9-a3d2-396ba7ce3ac8', '2026-07-25 09:34:46', '2026-07-25 09:36:09'), (25, 1, 'TRX-1785039304-xGidI', 'seyla', 'ragishahanny@students.amikom.ac.id', '1234567890', 55000, 'success', 0, 'e5f75188-1b10-471e-a3a7-5007fff1f3fb', '2026-07-25 21:15:04', '2026-07-25 21:15:15'), (26, 1, 'TRX-1785040598-XzzgK', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '12345678', 55000, 'Expired', 0, 'f0fe6238-cfdc-4aa3-b711-2e57cc0b65cd', '2026-07-25 21:36:38', '2026-07-25 21:36:38'), (27, 1, 'TRX-1785043104-XYxKw', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '1234567890', 55000, 'success', 0, '2fdcbb9e-0142-4e44-8382-f8d042efb2b8', '2026-07-25 22:18:24', '2026-07-25 22:20:34'), (28, 1, 'TRX-1785043580-7ZJCK', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '1234567890', 55000, 'success', 0, 'aab49f8a-2ace-4055-80c8-ead6fed6be11', '2026-07-25 22:26:20', '2026-07-25 22:26:25'), (29, 1, 'TRX-1785043800-45owD', 'gisha', 'ragishahannyy12@gmail.com', '1234567890', 55000, 'success', 0, '11e248e9-b437-4536-aa41-455342593188', '2026-07-25 22:30:00', '2026-07-25 22:30:06'), (30, 1, 'TRX-1785044030-Ug9Nw', 'gisha', 'ragishahannyy12@gmail.com', '1234567890', 55000, 'success', 0, 'c7f2e445-569c-4b58-8f19-e2e3b4874709', '2026-07-25 22:33:50', '2026-07-25 22:33:56'), (31, 1, 'TRX-1785046072-kxpyP', 'gisa', 'ragishahannyy12@gmail.com', '1234567890', 55000, 'used', 0, '141d6c27-8be1-4fe3-aebc-6f069b4e68c4', '2026-07-25 23:07:52', '2026-07-25 23:09:24'), (32, 1, 'TRX-1785046915-8uTyS', 'sasa', 'ragishahannyy12@gmail.com', '1234567890', 55000, 'used', 0, '61288a27-12d6-478e-b149-570b4d2e8a3b', '2026-07-25 23:21:55', '2026-07-25 23:22:35'), (33, 1, 'TRX-1785047305-LdD9p', 'seyla', 'ragishahannyy12@gmail.com', '1234567890', 55000, 'used', 1, '6fb8ac72-924e-443f-bc03-d8dfc6a0b8b2', '2026-07-25 23:28:25', '2026-07-25 23:29:06'), (34, 1, 'TRX-1785047409-DJQan', 'seyla', 'ragishahannyy12@gmail.com', '1234567890', 55000, 'used', 1, '28f57c89-96e1-4d2f-b46a-711bca5dd6aa', '2026-07-25 23:30:09', '2026-07-25 23:30:36'), (35, 5, 'TRX-1785048248-P6654', 'gisha', 'ragishahannyy12@gmail.com', '1234567890876521', 55000, 'used', 1, '66796ed2-5c1e-4fb4-a4fe-8b02a9598ad2', '2026-07-25 23:44:08', '2026-07-25 23:45:04'), (36, 3, 'TRX-1785048459-v9lCz', '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '12345678', 55000, 'used', 1, 'e98c098b-9157-4b29-858c-1ed57deee746', '2026-07-25 23:47:39', '2026-07-25 23:48:29'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `google_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `google_id`, `avatar`, `phone`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin Amikom', 'admin@amikom.ac.id', NULL, NULL, NULL, NULL, '$2y$12$ha385jNB/MzQAqNZt1LSXOX1fA9CYBRYFydHXZNVsn.IiXzITzEKK', 'admin', NULL, '2026-07-24 13:09:59', '2026-07-24 13:09:59'), (2, 'ABP Productions', 'abp@productions.com', NULL, NULL, NULL, NULL, '$2y$12$/Ju0hTC.AUF1xSBgRM9T9eOslaskfz8cd.Uzco8qO9gdtQojhfU3u', 'partner', NULL, '2026-07-24 13:09:59', '2026-07-24 13:09:59'), (3, 'TechEvent Indonesia', 'techevent@indonesia.com', NULL, NULL, NULL, NULL, '$2y$12$XMtzrI2eHmguyxJxbGPlb.OmZQD30vaiO5vSjZj9SsZrKXOHgHZDS', 'partner', NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (4, 'Kreativa Studio', 'kreativa@studio.com', NULL, NULL, NULL, NULL, '$2y$12$ja8Xe5NQ5MZIgUcqxaKwc.1Y9K2pK0SziTJyUf4ixK8vl3RS8ic6C', 'partner', NULL, '2026-07-24 13:10:00', '2026-07-24 13:10:00'), (5, 'Ragisha Hanny', 'ragishahannyy2@gmail.com', '105497392767161029162', 'https://lh3.googleusercontent.com/a/ACg8ocL41hp5eTIGbxuHJr6Mh-of5jYK3Fx5PKE0gSU-tAjU-93EWA=s96-c', NULL, NULL, '$2y$12$LorkUgmvsANiJ6XvhvbyDuzFXLuVEE4p0LjxVqGQW8mCVCTNpVkd.', 'user', NULL, '2026-07-26 00:35:40', '2026-07-26 00:35:40'), (6, '3182_RAGISHA HANNY AZALIA PUTRI', 'ragishahanny@students.amikom.ac.id', '113143046285418268255', 'https://lh3.googleusercontent.com/a/ACg8ocLPBjEVPbn7pXYq_d6K-CQy6Hvrh51ixZjmmPyAEvV4Ky_ZOQ=s96-c', NULL, NULL, '$2y$12$dt9epoFUWUjEh/ijy4gpF.fomel5XfUpyYpCY.9g15AViJEU/vl7O', 'user', NULL, '2026-07-26 00:36:06', '2026-07-26 00:36:06'); -- -- Indexes for dumped tables -- -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`), ADD KEY `cache_expiration_index` (`expiration`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`), ADD KEY `cache_locks_expiration_index` (`expiration`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `categories_slug_unique` (`slug`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`), ADD KEY `events_category_id_foreign` (`category_id`), ADD KEY `events_partner_id_foreign` (`partner_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `partners` -- ALTER TABLE `partners` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `partners_email_unique` (`email`), ADD KEY `partners_user_id_foreign` (`user_id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`), ADD KEY `reviews_event_id_foreign` (`event_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `transactions_order_id_unique` (`order_id`), ADD KEY `transactions_event_id_foreign` (`event_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_google_id_unique` (`google_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `partners` -- ALTER TABLE `partners` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- Constraints for dumped tables -- -- -- Constraints for table `events` -- ALTER TABLE `events` ADD CONSTRAINT `events_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `events_partner_id_foreign` FOREIGN KEY (`partner_id`) REFERENCES `partners` (`id`) ON DELETE CASCADE; -- -- Constraints for table `partners` -- ALTER TABLE `partners` ADD CONSTRAINT `partners_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `reviews` -- ALTER TABLE `reviews` ADD CONSTRAINT `reviews_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;