-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- 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;

