INSERT INTO `translate` (`id`, `language`, `group`, `name`, `payload`, `created_at`, `updated_at`) VALUES
(2222, 'en', 'profile', 'buyer.order-history.table.odeme-yontemi', 'null', '2024-06-07 14:55:02', '2024-06-07 14:55:02'),
(2223, 'en', 'profile', 'buyer.my-references.table.kazanc.info', 'null', '2024-06-07 14:55:02', '2024-06-07 14:55:02'),
(2224, 'en', 'profile', 'buyer.my-references.table.referansimin-kazanci.info', 'null', '2024-06-07 14:55:02', '2024-06-07 14:55:02'),
(2225, 'tr', 'profile_general', 'reference.commission.coin.message', '\"TR Coin %d\"', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2226, 'tr', 'profile_general', 'reference.commission.account.message', '\"TR Hesap %d\"', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2227, 'tr', 'profile_general', 'reference.commission.boost.message', '\"TR Boost %d\"', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2228, 'en', 'profile_general', 'profile_general.balance.table.id', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2229, 'en', 'profile_general', 'profile_general.balance.table.yuklenen', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2230, 'en', 'profile_general', 'profile_general.balance.table.tarih', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2231, 'en', 'profile_general', 'profile_general.balance.table.odeme-yontemi', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2232, 'en', 'profile_general', 'profile_general.balance.table.islem-durumu', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2233, 'en', 'profile_general', 'profile_general.balance.table.islem-turu', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2234, 'en', 'profile_general', 'profile_general.balance.table.hatali-bakiye', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2235, 'en', 'profile_general', 'profile_general.balance.table.data.balance.title', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2236, 'en', 'profile_general', 'profile_general.balance.table.data.withdraw.title', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2237, 'en', 'profile_general', 'profile_general.balance.table.data.state.success', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2238, 'en', 'profile_general', 'profile_general.balance.table.data.state.cancel', 'null', '2024-06-07 23:54:30', '2024-06-07 23:54:30'),
(2239, 'en', 'profile_general', 'profile_general.balance.table.data.state.admin-cancel', 'null', '2024-06-07 23:54:31', '2024-06-07 23:54:31'),
(2240, 'en', 'profile_general', 'profile_general.balance.table.data.state.pending', 'null', '2024-06-07 23:54:31', '2024-06-07 23:54:31'),
(2241, 'en', 'profile_general', 'reference.commission.coin.message', 'null', '2024-06-07 23:54:31', '2024-06-07 23:54:31'),
(2242, 'en', 'profile_general', 'reference.commission.account.message', 'null', '2024-06-07 23:54:31', '2024-06-07 23:54:31'),
(2243, 'en', 'profile_general', 'reference.commission.boost.message', 'null', '2024-06-07 23:54:31', '2024-06-07 23:54:31');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL,
  `parasut_id` varchar(255) DEFAULT NULL,
  `two_factor_secret` text DEFAULT NULL,
  `two_factor_recovery_codes` text DEFAULT NULL,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `current_team_id` bigint(20) UNSIGNED DEFAULT NULL,
  `profile_photo_path` varchar(2048) DEFAULT NULL,
  `tc_no` varchar(50) DEFAULT NULL,
  `birth_year` int(11) DEFAULT NULL,
  `publish` enum('Y','N','P') NOT NULL DEFAULT 'P',
  `avatar_type` varchar(50) NOT NULL DEFAULT 'avatar_select',
  `register_type` varchar(100) NOT NULL DEFAULT 'normal',
  `error_login` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `users`
--

INSERT INTO `users` (`id`, `name`, `username`, `email`, `email_verified_at`, `password`, `type`, `parasut_id`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `remember_token`, `current_team_id`, `profile_photo_path`, `tc_no`, `birth_year`, `publish`, `avatar_type`, `register_type`, `error_login`, `created_at`, `updated_at`) VALUES
(1, 'Mehmet HAKKIOĞLU', 'mehmethakkioglu', 'mehmethakkioglu@yandex.com', NULL, '$2y$10$og3dU4zVTQzCta/NIUn2NOLAVAJqCnow9qvqbANTfzOFCiGj/OSiC', 'employee', NULL, NULL, NULL, NULL, 'zzZDngMDlmnrCK3TGGCEXt6ldkCE9iUdk74lJB1uYSYNYERnI9foyDDCSaRP', 1, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 3, '2023-01-17 06:37:36', '2024-05-19 19:31:06'),
(2, 'Mehmet HAKKIOĞLU', 'testkullanicisi', 'testkullanicisi@futcoinbuy.com', NULL, '$2y$10$og3dU4zVTQzCta/NIUn2NOLAVAJqCnow9qvqbANTfzOFCiGj/OSiC', 'employee', NULL, NULL, NULL, NULL, NULL, 2, 'unk-man.png', NULL, NULL, 'Y', 'avatar_upload', 'normal', 0, '2023-01-18 14:33:10', '2023-09-17 21:08:53'),
(3, 'Normal Müşteri', 'deneme', 'deneme@deneme.com', NULL, '$2y$10$og3dU4zVTQzCta/NIUn2NOLAVAJqCnow9qvqbANTfzOFCiGj/OSiC', 'employee', NULL, NULL, NULL, NULL, NULL, 3, 'unk-man.png', NULL, NULL, 'N', '', 'normal', 0, '2023-01-25 19:21:01', '2023-04-18 11:12:30'),
(4, 'Asistan', 'asistan', 'asistan@deneme.com', NULL, '$2y$10$vHNkeOBf4eI.GDq4.l.d0.h3YIMVPyoXlzuwB03D2HGj2CwJb7d2e', 'customer', NULL, NULL, NULL, NULL, NULL, 4, 'unk-man.png', NULL, NULL, 'N', '', 'normal', 0, '2023-01-28 20:28:12', '2023-04-18 11:06:42'),
(5, 'Oğuzhan KIRAN', 'oguzhankiran', 'asdoguzhankiran@gmail.com', NULL, '$2y$10$vHNkeOBf4eI.GDq4.l.d0.h3YIMVPyoXlzuwB03D2HGj2CwJb7d2e', 'customer', NULL, NULL, NULL, NULL, NULL, 5, 'unk-man.png', NULL, NULL, 'P', '', 'normal', 0, '2023-02-02 19:45:04', '2023-02-02 19:45:10'),
(6, 'Normal Kullanıcı', 'normal-kullanici', 'normalkullanici@metha.com.tr', NULL, '$2y$10$PELXhBeWQFvWgwrhO71oku7L1Ps/jY4MVMDfezO0M0pK4ZzeI4Rb6', 'customer', NULL, NULL, NULL, NULL, NULL, 6, 'unk-man.png', NULL, NULL, 'P', '', 'normal', 0, '2023-02-13 05:09:55', '2023-02-13 05:09:55'),
(7, 'Referans Kullanıcı', 'referans-kullanici', 'referanskullanici@metha.com.tr', NULL, '$2y$10$ysX81Nze.F1IpLZl/.fhhe.zB2CdZM8X4Cv7bMFMtzSNNMBrdDiF.', 'customer', NULL, NULL, NULL, NULL, NULL, 7, 'unk-man.png', NULL, NULL, 'P', '', 'normal', 0, '2023-02-13 05:40:35', '2023-02-13 05:40:35'),
(8, 'Verify Kullanıcı', 'verify-deneme', 'verify@deneme.com', '2023-03-09 03:23:24', '$2y$10$axb2UC5VADAknBIRiu4Sd.UEZwLWlLuK5kKlsXMK..CPQ4gmQ1mQi', 'customer', NULL, NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', '', 'normal', 0, '2023-03-09 03:19:02', '2023-06-24 20:06:17'),
(11, 'Bayi Dealer', 'balance-kontrol', 'bayi@deneme.com', NULL, '$2y$10$vHNkeOBf4eI.GDq4.l.d0.h3YIMVPyoXlzuwB03D2HGj2CwJb7d2e', 'dealer', NULL, NULL, NULL, NULL, NULL, 9, 'unk-man.png', NULL, NULL, 'N', '', 'normal', 0, '2023-03-09 04:36:43', '2023-04-06 09:23:00'),
(13, 'Yayıncı Streamer', 'diger-balance', 'yayinci@deneme.com', NULL, '$2y$10$vHNkeOBf4eI.GDq4.l.d0.h3YIMVPyoXlzuwB03D2HGj2CwJb7d2e', 'customer', NULL, NULL, NULL, NULL, NULL, 10, 'unk-man.png', NULL, NULL, 'P', '', 'normal', 0, '2023-03-09 04:39:27', '2023-03-09 04:39:39'),
(14, 'SONER DENEME', 'soner-deneme', 'soner@deneme.com', NULL, '$2y$10$afy0u5Jq7v4uosrfG0U2buB3SuOVPA5jZI5ABeVL.abjVFeP5yuJq', 'customer', NULL, NULL, NULL, NULL, NULL, 11, 'unk-man.png', NULL, NULL, 'P', '', 'normal', 0, '2023-03-21 05:29:38', '2023-03-21 05:29:38'),
(16, 'Oğuzhan Kıran', 'oneoguzhan', 'oguzhankiraninfo@gmail.com', NULL, '$2y$10$YRFm60/t.yRFS4o/wz25se/sdHCTsRXJobpUWDVEQddKgwmCvYmey', 'customer', NULL, NULL, NULL, NULL, 'XaakVM7jKa2alSVfHoDKKdzLSxnGr2YownkKOV5zJfD8EwiZoPybpeGZIiAi', 12, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-04-05 10:13:21', '2023-10-10 14:18:58'),
(17, 'Oğuzhan Kıran', 'oneoguzhansat', 'oguzoyuncu.28@icloud.com', NULL, '$2y$10$f8DEgzh1D8JkpHqC1QIPP.Zp1Qcnqqb9XzugIcmxBUz3oRqoyUeKm', 'customer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'P', '', 'normal', 0, '2023-04-05 11:28:48', '2023-04-05 11:28:48'),
(18, 'Oğuzhan Kıran', 'oguzhankiraninfooooogmailcom', 'oguzhankiraninfooooo@gmail.com', NULL, '$2y$10$5yq1hxGui33.pHy8mzLf/uvx0L7LKIuYay7lhhU.c7jtkL4N4AqLS', 'customer', NULL, NULL, NULL, NULL, NULL, 14, NULL, NULL, NULL, 'P', '', 'normal', 0, '2023-04-05 11:39:30', '2023-04-05 11:39:32'),
(19, 'Oğuzhan Kıran', 'oneoguzhansatt', 'play2023uae3@gmail.com', NULL, '$2y$10$ayuw6nWYqfMh3T6jjgafCOm.eZ/L/qY0RsKSRqCScjgMCR8OS4BQ2', 'customer', NULL, NULL, NULL, NULL, NULL, 15, NULL, NULL, NULL, 'P', '', 'normal', 0, '2023-04-05 11:50:40', '2023-04-05 11:50:57'),
(20, 'reklamcı ahmet', 'reklamcı', '_mroneoguzhanproeslinfo@gmail.com', NULL, '$2y$10$V8fVwEsFNnoWMG3AQFImJuiu4m4C8/HBHXwZ3JChgJayfIwts6tr2', 'employee', NULL, NULL, NULL, NULL, NULL, 16, NULL, NULL, NULL, 'N', '', 'normal', 0, '2023-04-05 16:40:19', '2023-06-24 19:47:16'),
(21, 'Hasan Mahmut', 'hasan', 'vayekinadavet@gmail.com', NULL, '$2y$10$c1qQ9ZBJ48aN4T/kAEIfB.FJwewS1nGsNj.tVy2JYaDp5ovtLZzde', 'customer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'P', '', 'normal', 0, '2023-04-05 16:54:57', '2023-04-05 16:54:57'),
(22, 'Yusuf Akkurt', 'ttakkurt', 'ttakkurt@gmail.com', '2023-04-23 23:05:14', '$2y$10$LmH2qJv1NhxFo4G21Z8Xiu5881NQGPURSdBA0X5utPFtquTD/bgOi', 'customer', NULL, NULL, NULL, NULL, NULL, 18, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-04-23 10:17:28', '2023-11-03 15:46:26'),
(23, 'asdasd', 'ssssss', 'asdads@gmail.com', NULL, '$2y$10$og3dU4zVTQzCta/NIUn2NOLAVAJqCnow9qvqbANTfzOFCiGj/OSiC', 'customer', NULL, NULL, NULL, NULL, NULL, 19, 'avatar-f3f47ad950d0ac3738b84a3a28c3ea463f810103cfbb265c98b8a09556459d01.png', NULL, NULL, 'P', '', 'normal', 0, '2023-05-02 08:51:45', '2024-05-27 23:22:57'),
(29, 'asistan deneme', 'asistn denemesi', 'mehmet.hakkioglu@gmail.com222', NULL, '$2y$10$ebDUeDP145Q72utRKzfL5uto.vDnzY/WHHXhtYbm.uWc1ot4wd8Yu', 'employee', NULL, NULL, NULL, NULL, NULL, 20, NULL, NULL, NULL, 'Y', '', 'normal', 0, '2023-05-30 15:08:17', '2023-05-30 15:14:41'),
(30, 'Yusuf Hamamcı', 'Ceranimus', 'yusufhamamcii28@gmail.com', NULL, '$2y$10$.Oni9V0VagbeV6iZhN/xueqv.CHwwyms3AHeUNr44o3y2tELdO0Ne', 'employee', NULL, NULL, NULL, NULL, NULL, 21, 'avatar-f7b9e3e128f2ded76669f14157584d29e3970fc4508ccd3078c114d633aa46cc.png', NULL, NULL, 'Y', 'avatar_upload', 'normal', 0, '2023-06-24 19:46:52', '2023-11-21 22:09:09'),
(31, 'Yusuf Bey', 'YusufBey', 'aynenoyle@yandex.com', NULL, '$2y$10$ZT.yN0yu6hUzvAdu31SwKuMwrffMG27B4TrUyVBCMT8EOzCKBErMi', 'customer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'normal', 0, '2023-06-24 20:05:49', '2023-06-24 20:06:06'),
(34, 'Mehmet HAKKIOĞLU', 'mehmethakkiogluyandex222', 'mehmethakkioglu@yande2222x.com', NULL, '$2y$10$ObjOrTl8//xvAkVS2vOu8.ix0yFhRhvAQSKm8fcEl8zXpfzCj58TK', 'customer', NULL, NULL, NULL, NULL, NULL, 23, NULL, NULL, NULL, 'P', '', 'normal', 0, '2023-07-05 19:27:09', '2023-07-05 19:27:12'),
(35, 'Mehmet HAKKIOĞLU', 'mehmethakkiogluya__ndexcom', 'aasmehmethakkioglu@yandex.com', NULL, '$2y$10$ZILhJZWeqzKvFEawPmYbTePTzYPcdspHFiDBbL.gTWet5/PuSWOCm', 'customer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'P', '', 'normal', 0, '2023-07-05 19:29:08', '2023-07-05 19:29:08'),
(36, 'Mehmet HAKKIOĞLU', 'mehmethakkiogluyandexcom', 'mehmethakkioglu@yandex.com22', '2023-07-05 19:37:02', '$2y$10$ecBd8xp7JQJZadpnHbwrZewB2.BE048B9RM2TNfszZ6N.2Go1gIQ6', 'customer', NULL, NULL, NULL, NULL, NULL, 25, 'unk-man.png', NULL, NULL, 'Y', '', 'normal', 0, '2023-07-05 19:30:58', '2023-09-11 16:17:19'),
(37, 'efe', 'zeronimo', 'officialzeronimo@gmail.com', NULL, '$2y$10$ZjsPV0w52SFN.zmpEbJVpeu7NC5H9xlqQrFn7XPSeo/agSzG4719K', 'customer', NULL, NULL, NULL, NULL, NULL, 26, 'unk-man.png', NULL, NULL, 'Y', '', 'normal', 0, '2023-07-06 19:50:06', '2023-07-07 08:50:31'),
(38, 'Yusuf', 'zeronimo34', 'zeronimo@yandex.com', NULL, '$2y$10$Xrl1rncedqoocIHaUbdFvuV/K8re0L.X7NyKFzzil4CcjvyqR5DfC', 'customer', NULL, NULL, NULL, NULL, NULL, 27, NULL, NULL, NULL, 'Y', '', 'normal', 0, '2023-07-07 09:09:45', '2023-07-07 09:11:54'),
(39, 'Yusuf Batanoğulları', 'yusufus', 'gamepassdogrulama28@gmail.com', '2023-07-07 09:40:53', '$2y$10$dssiFQVcbFkIcqDYLyoWP.faFL/Up4b7IHeHMXZIxVSD2gWUBMIVy', 'customer', NULL, NULL, NULL, NULL, NULL, 28, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-07-07 09:40:19', '2023-10-25 15:45:16'),
(40, 'Yusuf', 'gamepassdogrulama228gmailcom', 'gamepassdogrulama228@gmail.com', NULL, '$2y$10$27/d1PgbkLnlw3qr4Q5rEujYfrtViRLGa6x0entK6P9A3idsrbyD2', 'employee', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'normal', 0, '2023-07-07 09:47:05', '2023-07-07 09:47:48'),
(41, 'sda', 'asd', 'myusufhamamci28@gmail.com', NULL, '$2y$10$eZJh/SGyJYu1H6QDRfs2yup2ygDBLAOAhes4fYDZPht5OD241bldO', 'customer', NULL, NULL, NULL, NULL, NULL, 30, 'unk-man.png', NULL, NULL, 'Y', '', 'normal', 0, '2023-07-07 10:09:03', '2023-07-07 10:12:08'),
(42, 'Yusuf Hamamcı', 'Mefenimuz', 'zirtopirto@gmail.com', NULL, '$2y$10$0WFCpO/i9yOVEhn.TWjIIun89cLOLYPzay8yn3zy7GCX0H1Ob.OCK', 'employee', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'normal', 0, '2023-07-28 00:22:44', '2023-07-28 00:22:44'),
(43, 'Yayıncı Test', 'yayincitest', 'yayincideneme@futcoin.com', NULL, '$2y$10$YRYTcPHj86oEQaQOlr6iweLQikr51bPnDU0tmwYmmD97ZUzszthaS', 'customer', NULL, NULL, NULL, NULL, NULL, 32, 'unk-man.png', NULL, NULL, 'Y', '', 'normal', 0, '2023-08-22 11:06:05', '2023-09-11 16:37:46'),
(44, 'bayi test', 'bayitest', 'bayideneme@futcoin.com', NULL, '$2y$10$jTZT.8eYXXpcWxMLdHZXKeEZBNsKSULGlLFaXCE5owOHYacNiI5t.', 'customer', NULL, NULL, NULL, NULL, NULL, 33, 'unk-man.png', NULL, NULL, 'Y', '', 'normal', 0, '2023-08-22 21:17:16', '2023-08-22 22:12:04'),
(47, 'Oğuzhan Deneme Hesabı', 'ogidenemeASDASD', '__oneoguzhantr@yandex.com', NULL, '$2y$10$TBTiuKp4i3lpBSlJmzqdFOHAzW0Hk4XABT2cUoXW6s3UT80b1v6C.', 'customer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-18 13:07:45', '2023-09-18 13:07:45'),
(48, 'SİLİNECEK', 'vaye-kina3333', 'vaye.org2@gmail.com', NULL, '$2y$10$7EkF5HLy8f/9rxs0rMISL.t2bkHTayoCgoNQGuLimI./bUolg3UG6', 'customer', NULL, NULL, NULL, NULL, NULL, 35, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-18 13:09:03', '2023-09-18 13:09:14'),
(67, 'Mehmet HAKKIOĞLU', 'mehmet-hakkioglu-deneme-hesabi', 'mehmet.hakkioglu@gmail.com', '2023-09-18 14:04:27', '$2y$10$n7gU9V6sQVtm3RVlTZfNCu6aUmxeHWAY5I2jmTL9HcJEtNOSJ9m/a', 'customer', '1007829061', NULL, NULL, NULL, NULL, 36, NULL, NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-09-18 14:01:35', '2023-09-18 14:04:27'),
(68, 'Berat', 'beratcadirci', 'beratcadirci@hotmail.com', NULL, '$2y$10$.rBblmvQD1JiyItmcE4px.eTh6cBkSw8s759zjfOGcJqmMMYcvxse', 'customer', '1007834848', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-18 17:44:06', '2023-09-18 17:44:07'),
(69, 'vaye', 'vaye', 'vaye.org@gmail.com', NULL, '$2y$10$bN7kZ/voZHyVm4USETjMmec58W/BrJbdw2atCHUgjHghZ6q3.MRzW', 'customer', '1007836372', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-18 19:33:25', '2023-09-18 19:33:25'),
(70, 'Mikail', 'miko', 'mikailaydin724@gmail.com', NULL, '$2y$10$s7MMn33J75rck9DRsutkoerTX9kj7oYoVw.qPBjR0oxQFGQDxnM7.', 'customer', '1007978664', NULL, NULL, NULL, NULL, 39, 'avatar-823fd91301a8e7802d9b1e77a8548f7a672a361a1eeff4ed3bedd910421a4467.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-22 19:04:00', '2023-09-22 19:04:41'),
(71, 'ERDAL NEFESOĞLU', 'ladre81', 'erdalnefes81@gmail.com', '2023-09-24 15:43:56', '$2y$10$GPMEEQ0ij5v6qYxITjOLZON3f9o4uQDPWbjeKKmrp5O5I7npx5tvC', 'customer', '1007989266', NULL, NULL, NULL, NULL, 40, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-09-23 08:58:05', '2023-09-24 15:43:56'),
(72, 'ahmet mehmetsi', 'ahmet-mehmetsi______', 'denememahmut@gmail.com_______', NULL, '$2y$10$Zuv2wUKPkmUVxiE4NnLl3.qOR03fEXCxkwv22FXWWClVAu9SNabTe', 'customer', '1008055974', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-26 06:32:34', '2023-09-26 06:32:35'),
(73, 'ahmet mehmetsi', 'ahmet-mehmetsi____', 'denememahmut@gmail.com____', NULL, '$2y$10$FWXcfm6MNJiLC0UjxpQjcetc3wedOkvRQLZ8vJRqnmZj88hKA83jq', 'customer', '1008056014', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-26 06:34:18', '2023-09-26 06:34:18'),
(74, 'ahmet mehmetsi', 'ahmet-mehmetsi____', 'denememahmut@gmail.com_____', NULL, '$2y$10$qKdGTL7sjgRwu01zlFO5HuaP.YvvlH9DEHABW35xe0DmLSexNdCpO', 'customer', '1008056048', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-26 06:36:11', '2023-09-26 06:36:12'),
(75, 'oğuzhan kıran', 'oguzhan-222kiran', 'oguzhan@gmail2.com', NULL, '$2y$10$M9OqZPGNoBVEW6eZ3QI6kOUSSYXfRSWCjqJLECk7R6Mo5wo79i8rC', 'customer', '1008056284', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-09-26 06:43:20', '2023-09-26 06:43:21'),
(76, 'Mehmet HAKKIOĞLU Test', 'mehmethakkioglutest', 'mehmethakkioglutesthesabi@deneme.com', NULL, '$2y$10$KQefCHfmVbpZiR5zvAokPudHDWQIi3w2E2nmdzVnReTDzryD2jNjq', 'employee', '1008314920', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'amount', 0, '2023-10-03 14:17:04', '2023-10-03 14:17:05'),
(77, 'oğuzhan kıran', 'oguzhantest', 'oguzhankirassssninfo@gmail.com', NULL, '$2y$10$LmH2qJv1NhxFo4G21Z8Xiu5881NQGPURSdBA0X5utPFtquTD/bgOi', 'employee', '1008314971', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'amount', 0, '2023-10-03 14:18:44', '2023-10-03 14:18:45'),
(79, 'oguzhan', 'oguzhan', 'grayson11060@gmail.com', NULL, '$2y$10$UJqhDT9SW0WDr8rZsXjrU.A8EFcVmBgkuFfiXHB5dx5mg9Xhb/W8q', 'customer', '1008773344', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 01:46:15', '2023-10-18 01:46:15'),
(80, 'oguzhan deneme', 'oguzhankiran123ASDASDASD', '____prod.by.okool@gmail.com', NULL, '$2y$10$l.MSSLFO4urTLPQ5BLZAvOaatZJeHk/I3hHZSspfJ.tGgWNHNq1JW', 'customer', '1008773360', NULL, NULL, NULL, NULL, 48, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 01:48:42', '2023-10-18 01:48:44'),
(81, 'umit', 'umitASDASD', 'prod.by.okool@gmail.comASDASDSASASAD', NULL, '$2y$10$s1i/TGux8xTNAVDcJcU9B.fbsoHHxJ8RJbTSJAV0cmNJMN3cl6D0G', 'customer', '1008773367', NULL, NULL, NULL, NULL, 49, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 01:58:47', '2023-10-18 01:58:49'),
(82, 'umit', 'umitAAA', 'prod.by.okool@gmail.comASDASD', NULL, '$2y$10$VKQ0L0LL0usSe59S1A5JpeMRHROTCB0kVlpZGViq4GDwI0IXLKeRG', 'customer', '1008773377', NULL, NULL, NULL, NULL, 50, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:02:10', '2023-10-18 02:02:12'),
(83, 'umit', 'umitASDASD', 'prod.by.okool@gmail.comASDASDASD', NULL, '$2y$10$9A05RxQ7LH6W70BfBn9uiOIz2RHynT6SvLC8ptLHCQ.lEyUg5VUfy', 'customer', '1008773379', NULL, NULL, NULL, NULL, 51, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:03:44', '2023-10-18 02:03:47'),
(84, 'umit', 'umitasdasdsad', 'prod.byasdasdsadokool@gmail.comasdasd', NULL, '$2y$10$cJ9XVDS7bWQ/76Mcs9uWueugevCjUOUBSrYMzguXn5gGKisdPLCom', 'customer', '1008773383', NULL, NULL, NULL, NULL, 52, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:06:11', '2023-10-18 02:06:14'),
(85, 'umit', 'ASD2D2D2D', 'prod.byASDAASD.okool@gmail.ASD', NULL, '$2y$10$kxQV.itYX2Ju36W1YBJPgu01nPhXYKy.D6I4PJRQ6eFAeUaH4z7Ka', 'customer', '1008773388', NULL, NULL, NULL, NULL, 53, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:11:44', '2023-10-18 02:11:46'),
(86, 'umit', 'umitASDASD', 'ASDASDASDASDASD213123123', NULL, '$2y$10$hs41oeE8WPmcACdiJtJKVuZ3Drt1sY4ZcQlFRT9JRozxSF4Vw95z6', 'customer', '1008773390', NULL, NULL, NULL, NULL, 54, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:14:00', '2023-10-18 02:14:02'),
(87, 'umit', 'umit12123', 'D233', NULL, '$2y$10$kQNYdFLnADpwsGeRViXtcecVjv2/W2UavCdAwr49gGTM2igZA1GrS', 'customer', '1008773393', NULL, NULL, NULL, NULL, 55, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:18:47', '2023-10-18 02:18:50'),
(88, 'umit', 'umit', 'prod.by.okool@gmail.com', NULL, '$2y$10$wroBI7P/6Df9tu8XSewJneFtwO1.y.ithG94n1/gJx.Mj3ehZV.R2', 'customer', '1008773413', NULL, NULL, NULL, NULL, 56, 'avatar-f3f47ad950d0ac3738b84a3a28c3ea463f810103cfbb265c98b8a09556459d01.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-18 02:28:11', '2023-10-18 02:28:46'),
(89, 'Yusuf Vuranoğulları', 'vurduatti', '28ysf1907@gmail.com', NULL, '$2y$10$vVwXD2nYyiVr.yjhwvzZuOa3wmry1jpt1Ev39EJDQhEn5IjudWy7G', 'customer', '1009054522', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-10-25 16:15:33', '2023-10-25 16:15:34'),
(90, 'Mehmet DENEME', 'mehmet-28ekim-2023', 'mehmetnetvis@gmail.com', '2023-10-26 23:42:45', '$2y$10$EKXe1GphgQxwywWOVnojmereKHpg.VT7XTHpXWq5X2l1ZntU3cmuu', 'customer', '1009074732', NULL, NULL, NULL, NULL, 58, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-26 06:55:43', '2023-10-26 23:42:45'),
(91, 'emir__', 'emir25__', 'emir.gfb.1907@gmail.com___', '2023-10-29 23:04:29', '$2y$10$m5fQFek8ZCRWFUEWG60SzupwYlSaPn6382xjABxNBLt8lK.eDkEDm', 'customer', '1009103854', NULL, NULL, NULL, NULL, 59, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-26 23:26:23', '2023-10-29 23:04:29'),
(93, 'emir___', 'emir1907___', 'emir.gfb.190725@gmail.com___', NULL, '$2y$10$1HtNL4v3vbzr5CZ/WY6M7um9nYS.0ZUcApCXGkFiQcA9fPwg1a1WO', 'customer', '1009103885', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-26 23:40:09', '2023-10-29 22:57:26'),
(94, 'emir', 'emir', 'emir.gfb.190725@gmail.com', '2023-10-29 23:11:31', '$2y$10$biBLPXL.Ut9h9RWYuELDT.RMUxGEFYNyOVBMeehyJRzHOWCz05dSK', 'customer', '1009160205', NULL, NULL, NULL, NULL, 61, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-29 23:07:54', '2023-10-29 23:11:31'),
(95, 'oğuzhan', 'denemeozi', 'mroneoguzhanproeslinfo@gmail.com', '2023-10-29 23:29:38', '$2y$10$MEg4Y6Y7ydipmkpLXY5wnOgZxf2kX2tDLDz5dd3C0i1Gjczf7AhHO', 'customer', '1009160220', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-29 23:14:05', '2023-10-29 23:29:38'),
(96, 'oğuzhan kıran', 'oguzhanyandex', 'oneoguzhantr@yandex.com', '2023-10-29 23:33:12', '$2y$10$L7IqA4lj0KHfkiXaGiwROOURJLb67v23i.RST1VIZmQh.pvpt6qw2', 'customer', '1009160267', NULL, NULL, NULL, NULL, 63, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-29 23:32:45', '2023-10-29 23:33:48'),
(99, 'emir tidim', 'emirasistan', 'denemeasd@gmail.com', NULL, '$2y$10$fEmVn5SKwKQySDbyU6waBOZAzveowb6HWpdx8WbzBqFVKPc7lsiHq', 'employee', '1009160518', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-10-30 01:04:07', '2023-10-30 01:04:07'),
(100, 'emir tidimdd', 'sgbsdgdsgdsgdsgs', 'fsdfsddfs@gmail.com', NULL, '$2y$10$hIwC/f9TKu5B9ALZMwbG.ekagd3WKeHImvy4R9pxV9Dt7g0gzhAre', 'employee', '1009338535', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-11-03 15:40:59', '2023-11-03 15:41:00'),
(101, 'oğuzhan kıran', '___mrone', '______MrOneTr@yandex.com', NULL, '$2y$10$1zU1jy7AdKgKdALm5gHbt.ECS8Iq0hP039Tcy492SNAukx3KH67C2', 'employee', '1009839712', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-11-18 23:01:21', '2023-11-18 23:01:21'),
(102, 'oğuzhan kıran', 'oguzhan-kiran__', '_MrOneTr@yandex.com', NULL, '$2y$10$3fNQkNZUziW0EGljTHF6ou5u2Wbc.RCwqoH3E1Ssb76CRmXMMqedK', 'employee', '1009839727', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-11-18 23:05:16', '2023-11-18 23:05:16'),
(103, 'oğuzhan kıran', 'ogzzzzzz1212', 'oguzoyuncu.28@gmail.com', NULL, '$2y$10$mV0McCGziP5HJ.h/F7V/Nu3yz3YHMok5R44NjTuQJyuUb.KpxSI8.', 'employee', '1009839735', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-11-18 23:11:15', '2023-11-18 23:11:15'),
(104, 'oğuzhan', 'mronetr__', 'MrOneTr@yandex.com___', NULL, '$2y$10$C9CCvGRUgIBd8ZhtZZHBfe/wP54nU55DpdTn.Xv2maezBq8TRrxca', 'employee', '1009839818', NULL, NULL, NULL, NULL, 69, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-11-18 23:52:41', '2023-11-19 00:29:36'),
(105, 'Oğuzhan', 'mronetr___', 'MrOneTr@yandex.com_____', '2023-12-20 11:34:44', '$2y$10$zSQYZ5TzZqqRVPj56IISOe.WqjuNgiloHibln8O7Kd5FlCVuwiIMG', 'employee', '1009839922', NULL, NULL, NULL, NULL, 70, 'avatar-f3f47ad950d0ac3738b84a3a28c3ea463f810103cfbb265c98b8a09556459d01.png', NULL, NULL, 'Y', 'avatar_select', 'normal', 0, '2023-11-19 00:38:15', '2023-12-20 11:34:44'),
(106, 'oğuzhan kıran', 'oguzhaaaaaaaaaan__', 'MrOneTr@yandex.com__', NULL, '$2y$10$8S93Z6q81OAeW2skUTwyquL9gOtVG0YQDaqJ8oR0ZkUzLiJGl996a', 'employee', '1011050759', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-12-20 11:31:58', '2023-12-20 11:31:59'),
(107, 'oğuzhan kıran', 'oguzhan-kirannnn__', 'MrOneTr@yandex.com___ASDASD', NULL, '$2y$10$kXsDL6p47qeBJP/U0NhYpOHiw8x0Hiwzk6kA/2MS7kjDE5MS5CKke', 'employee', '1011051251', NULL, NULL, NULL, NULL, NULL, 'unk-man.png', NULL, NULL, 'P', 'avatar_select', 'normal', 0, '2023-12-20 11:35:12', '2023-12-20 11:35:13'),
(108, 'oğuzhan kıran', 'mronetr', 'MrOneTr@yandex.com', NULL, '$2y$10$og3dU4zVTQzCta/NIUn2NOLAVAJqCnow9qvqbANTfzOFCiGj/OSiC', 'employee', '1011056290', NULL, NULL, NULL, NULL, 73, 'avatar-823fd91301a8e7802d9b1e77a8548f7a672a361a1eeff4ed3bedd910421a4467.png', '29503877360', 2001, 'P', 'avatar_select', 'normal', 1, '2023-12-20 12:57:19', '2024-05-06 01:32:56');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_accounts`
--

CREATE TABLE `user_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `account_code` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `currency_id` bigint(20) UNSIGNED NOT NULL,
  `status_code` varchar(255) NOT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_accounts`
--

INSERT INTO `user_accounts` (`id`, `user_id`, `account_code`, `price`, `currency_id`, `status_code`, `completed_at`, `created_at`, `updated_at`) VALUES
(1, 22, 'e3be0761', 90, 1, '4e2fdcb5', NULL, '2023-10-31 18:47:09', '2023-10-31 18:47:09');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_account_price_changes`
--

CREATE TABLE `user_account_price_changes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `account_code` varchar(255) NOT NULL,
  `account_type` varchar(50) NOT NULL DEFAULT 'account',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `price` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_account_price_changes`
--

INSERT INTO `user_account_price_changes` (`id`, `account_code`, `account_type`, `user_id`, `price`, `created_at`, `updated_at`) VALUES
(9, 'c68fb4cd', 'boost', 1, '7500', '2024-04-16 21:26:52', '2024-04-16 21:26:52');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_action_histories`
--

CREATE TABLE `user_action_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `route` varchar(255) NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `other` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`other`)),
  `activity_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_changes`
--

CREATE TABLE `user_changes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'username',
  `detail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`detail`)),
  `completed` varchar(3) NOT NULL DEFAULT 'P',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_changes`
--

INSERT INTO `user_changes` (`id`, `user_id`, `type`, `detail`, `completed`, `created_at`, `updated_at`) VALUES
(1, 108, 'username', '{\"username\":\"mronetrrr\",\"email\":\"MrOneTr@yandex.com\"}', 'P', '2024-01-29 23:40:25', '2024-01-29 23:40:25');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_commissions`
--

CREATE TABLE `user_commissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('reference','promotion','other') NOT NULL,
  `streamer_value` int(11) NOT NULL,
  `user_value` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_commissions`
--

INSERT INTO `user_commissions` (`id`, `user_id`, `type`, `streamer_value`, `user_value`, `created_at`, `updated_at`) VALUES
(5, 1, 'reference', 4, 1, '2023-09-08 13:12:24', '2023-09-15 03:32:03'),
(6, 1, 'promotion', 4, 3, '2023-09-08 13:12:24', '2023-09-10 11:50:39'),
(7, 3, 'promotion', 1, 9, '2023-09-10 11:50:07', '2023-09-10 11:50:07');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_country_change`
--

CREATE TABLE `user_country_change` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `country` int(11) NOT NULL,
  `document` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `status` enum('Y','N','P') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'P',
  `note` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Tablo döküm verisi `user_country_change`
--

INSERT INTO `user_country_change` (`id`, `user_id`, `admin_id`, `country`, `document`, `status`, `note`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 9, 'e080d1f7-fff1-4cf1-b8bd-472067db09e2.jpg', 'Y', NULL, '2023-09-20 02:14:51', '2023-09-20 02:15:45');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_draws`
--

CREATE TABLE `user_draws` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `result` tinyint(4) DEFAULT NULL,
  `draw_code` varchar(75) NOT NULL,
  `result_order` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_draws`
--

INSERT INTO `user_draws` (`id`, `user_id`, `result`, `draw_code`, `result_order`, `created_at`) VALUES
(1, 1, 1, 'eef9947f', 0, '2024-01-22 01:19:02'),
(2, 5, 1, 'eef9947f', 2, '2024-01-22 01:25:44'),
(3, 3, 1, 'eef9947f', 1, '2024-01-22 01:25:47'),
(4, 3, 1, 'eef9947f', 1, '2024-01-22 01:25:47'),
(5, 3, 1, 'eef9947f', 1, '2024-01-22 01:25:47'),
(6, 7, 1, 'eef9947f', 1, '2024-01-22 01:25:47'),
(7, 8, 1, 'eef9947f', 1, '2024-01-22 01:25:47'),
(8, 8, 1, 'eef9947f', 1, '2024-01-22 01:25:47');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_draw_settings`
--

CREATE TABLE `user_draw_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `streamer` bigint(20) UNSIGNED NOT NULL,
  `max_participation` int(11) NOT NULL,
  `winning_count` int(11) NOT NULL,
  `draw_buy_value` int(11) NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'all',
  `games` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`games`)),
  `day` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_info`
--

CREATE TABLE `user_info` (
  `reference_code` varchar(50) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `balance` varchar(11) DEFAULT NULL,
  `spending` varchar(50) DEFAULT NULL,
  `current_spending` varchar(50) DEFAULT NULL,
  `gsm` varchar(255) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `other` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_info`
--

INSERT INTO `user_info` (`reference_code`, `user_id`, `balance`, `spending`, `current_spending`, `gsm`, `country_id`, `bio`, `other`, `note`, `updated_at`, `id`) VALUES
('', 1, '45', NULL, '', NULL, 190, 'Hakkımızda yazısı burada yeralacktır.', '{\"username\":\"false\",\"penalty\":{\"action\":\"false\",\"code\":\"fb5ef16e\",\"description\":\"AAA\"}}', NULL, '2024-05-27 23:24:52', 1),
('', 2, '1250', NULL, '', '5425555555', 190, NULL, NULL, NULL, '2023-09-17 21:08:42', 2),
('ASD123', 3, '33', NULL, '', '1231111', 190, NULL, '{\"seller_verify\":\"active\"}', NULL, '2024-06-10 17:32:52', 3),
('', 4, '44', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:44:56', 4),
('', 5, '55', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 5),
('', 6, '1500', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 6),
('', 7, '66', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 7),
('', 13, '77', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 8),
('', 11, '88', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 9),
('e3dcb468', 14, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 10),
('7f62ed0a', 16, '49995', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-10-10 14:29:20', 11),
('85e0f7e3', 17, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 12),
('5484eb17', 18, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 13),
('d4efe472', 19, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 14),
('e5eebb6c', 20, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 15),
('37774e1f', 21, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 16),
('39769333', 22, '0', NULL, '', '+905342744502', 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-11-18 22:47:26', 17),
('194f3405', 23, NULL, NULL, '', NULL, 190, NULL, '[]', NULL, '2024-05-28 00:19:04', 18),
('4833fbe8', 29, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 19),
('9628759a', 30, '500', NULL, '', NULL, 190, 'aaaaaaaaa', NULL, NULL, '2023-11-21 22:09:09', 20),
('19b4671e', 31, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 21),
('3382f56b', 34, NULL, NULL, '', '5424721923', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 22),
('e393ded3', 35, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 23),
('ea7c1e1d', 36, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 24),
('ae53a621', 37, NULL, NULL, '', '5356386199', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 25),
('c9aaf5bf', 38, NULL, NULL, '', '5317106472', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 26),
('12f93cae', 39, '2750', NULL, '', '5436542987', 190, NULL, NULL, NULL, '2023-10-25 15:45:16', 27),
('2da14d1a', 40, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 28),
('92b29ddf', 41, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 29),
('a44af3a4', 42, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 30),
('36109fe6', 43, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 31),
('8c850cb1', 44, '1750', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 32),
('405b7763', 47, NULL, NULL, '', '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 33),
('f096207b', 48, NULL, NULL, '', '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 34),
('7c55da3a', 67, NULL, NULL, '', '5424721923', 190, NULL, NULL, NULL, '2023-09-18 21:38:16', 35),
('ba0575bb', 68, NULL, NULL, '', '05537360455', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 36),
('f0cdf277', 69, NULL, NULL, '', '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 37),
('ead2d887', 70, NULL, NULL, '', '+905443743098', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 38),
('5a3ee775', 71, NULL, NULL, '', '05308792681', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 39),
('0fb94a60', 72, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 40),
('f67809d9', 73, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 41),
('74e1e198', 74, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 42),
('a54caf5b', 75, NULL, NULL, '', NULL, 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 43),
('b477c607', 76, '-5', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-10-03 14:30:01', 44),
('0b5e4309', 77, '-25', NULL, '', NULL, 190, NULL, NULL, NULL, '2023-10-03 14:34:59', 45),
('8b4a8bbd', 79, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 46),
('0018b853', 80, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 47),
('5104bcc2', 81, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 48),
('ccfa3e86', 82, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 49),
('4112acce', 83, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 50),
('ebf7c3f0', 84, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 51),
('a9b8ef8a', 85, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 52),
('d23253d4', 86, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 53),
('37eca796', 87, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-11-22 01:49:24', 54),
('2988270f', 88, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-10-18 02:28:12', 55),
('3ccfe726', 89, NULL, NULL, NULL, '5446553336', 190, NULL, NULL, NULL, '2023-10-25 16:15:35', 56),
('801edde8', 90, NULL, NULL, NULL, '555996633', 190, NULL, NULL, NULL, '2023-10-26 06:55:44', 57),
('14867d99', 91, NULL, NULL, NULL, '05395853356', 190, NULL, NULL, NULL, '2023-10-26 23:26:24', 58),
('59895891', 93, NULL, NULL, NULL, '05395853356', 190, NULL, NULL, NULL, '2023-10-26 23:40:10', 60),
('8ee28aaa', 94, NULL, NULL, NULL, '5342744502', 190, NULL, NULL, NULL, '2023-10-29 23:07:55', 61),
('54bc39e2', 95, NULL, NULL, NULL, '53342744502', 190, NULL, NULL, NULL, '2023-10-29 23:14:05', 62),
('e180f8bb', 96, NULL, NULL, NULL, '+905342744502', 190, NULL, NULL, NULL, '2023-10-29 23:32:46', 63),
('30b757b6', 99, NULL, NULL, NULL, NULL, 190, NULL, NULL, NULL, '2023-10-30 01:04:08', 66),
('4bd12af4', 100, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, '2023-11-03 15:41:01', 67),
('fff060a7', 101, NULL, NULL, NULL, NULL, 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-11-22 01:49:24', 68),
('bb4c0b70', 102, NULL, NULL, NULL, NULL, 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-11-22 01:49:24', 69),
('cf16f921', 103, NULL, NULL, NULL, NULL, 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-11-22 01:49:24', 70),
('63bde2cf', 104, NULL, NULL, NULL, NULL, 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-11-22 01:49:24', 71),
('e7f9d8e4', 105, '1120', NULL, NULL, NULL, 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-11-22 02:48:10', 72),
('856cea57', 106, NULL, NULL, NULL, '0903253253535AAA', 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-12-20 12:54:32', 73),
('29926935', 107, NULL, NULL, NULL, '0905342744333AA', 190, NULL, '{\"seller_verify\":\"passive\"}', NULL, '2023-12-20 12:54:30', 74),
('e54a105d', 108, '1240.56685', NULL, NULL, '0905342744533', 190, NULL, '{\"seller_verify\":\"active\"}', 'AAAAAAAAA', '2024-05-27 23:14:07', 75);

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_invoice_address`
--

CREATE TABLE `user_invoice_address` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `city` int(11) DEFAULT NULL,
  `district` int(11) DEFAULT NULL,
  `other` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`other`)),
  `tax_number` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_invoice_address`
--

INSERT INTO `user_invoice_address` (`id`, `user_id`, `city`, `district`, `other`, `tax_number`, `created_at`, `updated_at`) VALUES
(1, 30, NULL, NULL, NULL, NULL, '2023-06-24 19:46:55', '2023-06-24 19:46:55'),
(2, 31, NULL, NULL, NULL, NULL, '2023-06-24 20:05:51', '2023-06-24 20:05:51'),
(3, 34, NULL, NULL, NULL, NULL, '2023-07-05 19:27:11', '2023-07-05 19:27:11'),
(4, 35, NULL, NULL, NULL, NULL, '2023-07-05 19:29:10', '2023-07-05 19:29:10'),
(5, 36, NULL, NULL, NULL, NULL, '2023-07-05 19:30:59', '2023-07-05 19:30:59'),
(6, 37, NULL, NULL, NULL, NULL, '2023-07-06 19:50:15', '2023-07-06 19:50:15'),
(7, 38, NULL, NULL, NULL, NULL, '2023-07-07 09:09:52', '2023-07-07 09:09:52'),
(8, 39, 34, 837, '{\"mahalle\":\"Pa\\u015fabah\\u00e7e mh.\",\"sokak\":\"Derin Sokak\",\"binano\":\"5\",\"daire\":\"1\",\"kat\":\"3\"}', '11221122331', '2023-07-07 09:40:22', '2023-09-26 17:54:51'),
(9, 40, NULL, NULL, NULL, NULL, '2023-07-07 09:47:07', '2023-07-07 09:47:07'),
(10, 41, NULL, NULL, NULL, NULL, '2023-07-07 10:09:05', '2023-07-07 10:09:05'),
(11, 42, NULL, NULL, NULL, NULL, '2023-07-28 00:22:47', '2023-07-28 00:22:47'),
(12, 43, NULL, NULL, NULL, NULL, '2023-08-22 11:06:14', '2023-08-22 11:06:14'),
(13, 44, NULL, NULL, NULL, NULL, '2023-08-22 21:17:21', '2023-08-22 21:17:21'),
(14, 2, 16, 186, '{\"mahalle\":\"Dumlup\\u0131nar111111 Mh.\",\"sokak\":\"Deneme 222222Sk.\",\"binano\":\"999\",\"daire\":\"555\",\"kat\":\"666\"}', '1111111', '2023-09-17 19:54:27', '2023-09-17 20:14:19'),
(15, 22, 5, 48, '{\"mahalle\":\"mahmutbey\",\"sokak\":\"sehit mahmut\",\"binano\":\"22\",\"daire\":\"16\",\"kat\":\"7\"}', '55566656476476', '2023-08-22 21:17:21', '2023-09-26 06:48:58'),
(16, 47, NULL, NULL, NULL, NULL, '2023-09-18 13:07:46', '2023-09-18 13:07:46'),
(17, 48, NULL, NULL, NULL, NULL, '2023-09-18 13:09:03', '2023-09-18 13:09:03'),
(18, 67, NULL, NULL, NULL, NULL, '2023-09-18 14:01:36', '2023-09-18 14:01:36'),
(19, 68, NULL, NULL, NULL, NULL, '2023-09-18 17:44:08', '2023-09-18 17:44:08'),
(20, 69, NULL, NULL, NULL, NULL, '2023-09-18 19:33:26', '2023-09-18 19:33:26'),
(21, 1, 3, 23, '{\"mahalle\":\"1\",\"sokak\":\"2\",\"binano\":\"3\",\"daire\":\"4\",\"kat\":\"5\"}', '4234324', NULL, '2023-09-20 02:20:54'),
(22, 70, NULL, NULL, NULL, NULL, '2023-09-22 19:04:02', '2023-09-22 19:04:02'),
(23, 71, NULL, NULL, NULL, NULL, '2023-09-23 08:58:06', '2023-09-23 08:58:06'),
(24, 72, NULL, NULL, NULL, NULL, '2023-09-26 06:32:35', '2023-09-26 06:32:35'),
(25, 73, NULL, NULL, NULL, NULL, '2023-09-26 06:34:18', '2023-09-26 06:34:18'),
(26, 74, NULL, NULL, NULL, NULL, '2023-09-26 06:36:12', '2023-09-26 06:36:12'),
(27, 75, NULL, NULL, NULL, NULL, '2023-09-26 06:43:21', '2023-09-26 06:43:21'),
(28, 76, NULL, NULL, NULL, NULL, '2023-10-03 14:17:06', '2023-10-03 14:17:06'),
(29, 77, NULL, NULL, NULL, NULL, '2023-10-03 14:18:45', '2023-10-03 14:18:45'),
(30, 0, 1, 1, NULL, NULL, NULL, NULL),
(31, 16, 1, 1, NULL, NULL, NULL, NULL),
(32, 79, 34, 834, NULL, NULL, '2023-10-18 01:46:15', '2023-10-18 01:46:15'),
(33, 80, 34, 834, NULL, NULL, '2023-10-18 01:48:43', '2023-10-18 01:48:43'),
(34, 81, 34, 834, NULL, NULL, '2023-10-18 01:58:48', '2023-10-18 01:58:48'),
(35, 82, 34, 834, NULL, NULL, '2023-10-18 02:02:11', '2023-10-18 02:02:11'),
(36, 83, 34, 834, NULL, NULL, '2023-10-18 02:03:45', '2023-10-18 02:03:45'),
(37, 84, 34, 834, NULL, NULL, '2023-10-18 02:06:12', '2023-10-18 02:06:12'),
(38, 85, 34, 834, NULL, NULL, '2023-10-18 02:11:44', '2023-10-18 02:11:44'),
(39, 86, 34, 834, NULL, NULL, '2023-10-18 02:14:01', '2023-10-18 02:14:01'),
(40, 87, 34, 834, NULL, NULL, '2023-10-18 02:18:48', '2023-10-18 02:18:48'),
(41, 88, 34, 834, NULL, NULL, '2023-10-18 02:28:12', '2023-10-18 02:28:12'),
(42, 89, 34, 834, NULL, NULL, '2023-10-25 16:15:35', '2023-10-25 16:15:35'),
(43, 90, 16, 185, NULL, NULL, '2023-10-26 06:55:44', '2023-10-26 06:55:44'),
(44, 91, 34, 834, NULL, NULL, '2023-10-26 23:26:24', '2023-10-26 23:26:24'),
(45, 93, 34, 834, NULL, NULL, '2023-10-26 23:40:10', '2023-10-26 23:40:10'),
(46, 94, 34, 834, NULL, NULL, '2023-10-29 23:07:55', '2023-10-29 23:07:55'),
(47, 95, 34, 834, NULL, NULL, '2023-10-29 23:14:05', '2023-10-29 23:14:05'),
(48, 96, 34, 834, NULL, NULL, '2023-10-29 23:32:46', '2023-10-29 23:32:46'),
(49, 99, 34, 834, NULL, NULL, '2023-10-30 01:04:08', '2023-10-30 01:04:08'),
(50, 100, 34, 834, NULL, NULL, '2023-11-03 15:41:01', '2023-11-03 15:41:01'),
(51, 101, 34, 834, NULL, NULL, '2023-11-18 23:01:22', '2023-11-18 23:01:22'),
(52, 102, 34, 834, NULL, NULL, '2023-11-18 23:05:17', '2023-11-18 23:05:17'),
(53, 103, 34, 834, NULL, NULL, '2023-11-18 23:11:16', '2023-11-18 23:11:16'),
(54, 104, 34, 834, NULL, NULL, '2023-11-18 23:52:41', '2023-11-18 23:52:41'),
(55, 105, 34, 834, NULL, NULL, '2023-11-19 00:38:15', '2023-11-19 00:38:15'),
(56, 106, 34, 834, NULL, NULL, '2023-12-20 11:31:59', '2023-12-20 11:31:59'),
(57, 107, 34, 834, NULL, NULL, '2023-12-20 11:35:13', '2023-12-20 11:35:13'),
(58, 108, 34, 844, '{\"mahalle\":\"mahmutbey\",\"sokak\":\"sehit mahmutttyyuuy\",\"binano\":\"22\",\"daire\":\"166\",\"kat\":\"7\"}', '3131', '2023-12-20 12:57:20', '2024-01-23 22:03:41');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_notifications`
--

CREATE TABLE `user_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reading` enum('F','R') NOT NULL DEFAULT 'F',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_notifications`
--

INSERT INTO `user_notifications` (`id`, `code`, `user_id`, `reading`, `created_at`, `updated_at`) VALUES
(1, 'f95d5698', 1, 'R', '2023-09-20 02:14:51', '2024-04-15 23:58:50'),
(2, 'db755d17', 1, 'R', '2023-09-20 02:15:38', '2024-04-15 23:58:50'),
(3, '5453b33f', 1, 'R', '2023-09-20 02:15:45', '2024-04-15 23:58:50'),
(4, 'dfb9e962', 1, 'R', '2023-09-21 16:30:42', '2024-04-15 23:58:50'),
(5, 'c41ff59f', 1, 'R', '2023-09-21 16:33:27', '2024-04-15 23:58:50'),
(6, 'febace26', 1, 'R', '2023-09-21 16:34:39', '2024-04-15 23:58:50'),
(7, '3a3668e9', 3, 'F', '2023-09-26 08:00:39', '2023-09-26 08:00:39'),
(8, 'aaddeef8', 3, 'F', '2023-09-26 08:00:49', '2023-09-26 08:00:49'),
(9, '6a707833', 3, 'F', '2023-09-26 08:01:38', '2023-09-26 08:01:38'),
(10, '78bc3d4e', 3, 'F', '2023-09-26 08:06:56', '2023-09-26 08:06:56'),
(11, '931d61d0', 3, 'F', '2023-09-26 08:21:01', '2023-09-26 08:21:01'),
(13, '8ddf327b', 3, 'F', '2023-09-26 08:24:21', '2023-09-26 08:24:21'),
(14, 'd973ec0f', 3, 'F', '2023-09-26 08:31:03', '2023-09-26 08:31:03'),
(15, 'cb12763a', 3, 'F', '2023-09-26 08:32:35', '2023-09-26 08:32:35'),
(17, 'e441e778', 3, 'F', '2023-09-26 08:37:25', '2023-09-26 08:37:25'),
(18, 'bc1802ea', 3, 'F', '2023-09-26 08:38:17', '2023-09-26 08:38:17'),
(19, '284a503a', 3, 'F', '2023-09-26 18:08:01', '2023-09-26 18:08:01'),
(21, '9c043b1e', 3, 'F', '2023-09-29 18:31:11', '2023-09-29 18:31:11'),
(22, '4eb35e27', 3, 'F', '2023-09-29 18:31:22', '2023-09-29 18:31:22'),
(23, 'e226eef1', 3, 'F', '2023-09-29 18:45:55', '2023-09-29 18:45:55'),
(24, 'd477a48c', 3, 'F', '2023-09-30 12:16:45', '2023-09-30 12:16:45'),
(25, '5cf00c76', 3, 'F', '2023-09-30 12:51:49', '2023-09-30 12:51:49'),
(26, 'd37ddc68', 3, 'F', '2023-09-30 14:09:07', '2023-09-30 14:09:07'),
(27, '1339f138', 3, 'F', '2023-09-30 14:09:13', '2023-09-30 14:09:13'),
(28, 'b38e9be0', 3, 'F', '2023-09-30 14:10:44', '2023-09-30 14:10:44'),
(29, '315980ea', 3, 'F', '2023-09-30 14:12:23', '2023-09-30 14:12:23'),
(30, 'a2421cae', 3, 'F', '2023-09-30 14:26:58', '2023-09-30 14:26:58'),
(31, '609bb042', 3, 'F', '2023-10-03 14:36:35', '2023-10-03 14:36:35'),
(32, '59f04a46', 3, 'F', '2023-10-08 22:31:12', '2023-10-08 22:31:12'),
(33, 'f3274fbc', 3, 'F', '2023-10-08 23:47:11', '2023-10-08 23:47:11'),
(34, 'c9893111', 3, 'F', '2023-10-09 23:09:27', '2023-10-09 23:09:27'),
(35, '3233845a', 3, 'F', '2023-10-09 23:09:45', '2023-10-09 23:09:45'),
(36, '54f89138', 3, 'F', '2023-10-09 23:10:39', '2023-10-09 23:10:39'),
(37, '5134d3df', 3, 'F', '2023-10-10 00:37:39', '2023-10-10 00:37:39'),
(38, 'c050de94', 3, 'F', '2023-10-10 00:40:11', '2023-10-10 00:40:11'),
(39, '644bdf15', 3, 'F', '2023-10-10 14:31:23', '2023-10-10 14:31:23'),
(40, '7adf3537', 3, 'F', '2023-10-10 14:31:29', '2023-10-10 14:31:29'),
(41, '77488e7b', 3, 'F', '2023-10-10 14:31:33', '2023-10-10 14:31:33'),
(42, '633f38b7', 3, 'F', '2023-10-10 14:31:36', '2023-10-10 14:31:36'),
(43, 'f89b0a00', 22, 'F', '2023-10-18 00:06:41', '2023-10-18 00:06:41'),
(45, 'c5021302', 77, 'F', '2023-10-18 00:18:22', '2023-10-18 00:18:22'),
(46, '782941fe', 77, 'F', '2023-10-18 00:22:28', '2023-10-18 00:22:28'),
(47, '588f4eb3', 3, 'F', '2023-10-21 21:56:33', '2023-10-21 21:56:33'),
(48, 'eaaae805', 39, 'F', '2023-10-25 16:24:22', '2023-10-25 16:24:22'),
(49, '69edec7d', 16, 'F', '2023-10-25 16:26:27', '2023-10-25 16:26:27'),
(50, '3fd611d5', 22, 'F', '2023-10-27 00:16:01', '2023-10-27 00:16:01'),
(51, 'a8e0f1d1', 16, 'F', '2023-10-27 00:16:30', '2023-10-27 00:16:30'),
(52, 'c0a7c037', 1, 'R', '2023-10-28 21:16:56', '2024-04-15 23:58:50'),
(53, '3446cea8', 1, 'R', '2023-10-28 21:17:59', '2024-04-15 23:58:50'),
(54, '4d6ff44a', 1, 'R', '2023-10-28 21:21:14', '2024-04-15 23:58:50'),
(55, '96c3d1df', 1, 'R', '2023-10-28 21:23:35', '2024-04-15 23:58:50'),
(56, '20408b73', 1, 'R', '2023-10-28 21:26:12', '2024-04-15 23:58:50'),
(57, '77bd770c', 1, 'R', '2023-10-28 21:29:31', '2024-04-15 23:58:50'),
(58, '8f6ff21a', 1, 'R', '2023-10-28 21:32:14', '2024-04-15 23:58:50'),
(59, 'f00bb692', 1, 'R', '2023-10-28 21:39:24', '2024-04-15 23:58:50'),
(60, 'acc2e8ee', 22, 'F', '2023-11-03 15:31:02', '2023-11-03 15:31:02'),
(61, '22a79f41', 16, 'F', '2023-11-03 15:33:25', '2023-11-03 15:33:25'),
(62, 'fd165d3a', 3, 'F', '2023-11-12 02:01:04', '2023-11-12 02:01:04'),
(63, 'aacee807', 3, 'F', '2023-11-12 02:01:38', '2023-11-12 02:01:38'),
(64, 'a7703490', 3, 'F', '2023-11-12 02:01:56', '2023-11-12 02:01:56'),
(65, '493b07b6', 3, 'F', '2023-11-12 02:16:15', '2023-11-12 02:16:15'),
(66, '9412c027', 3, 'F', '2023-11-12 02:16:31', '2023-11-12 02:16:31'),
(67, '6c92175b', 3, 'F', '2023-11-12 02:28:34', '2023-11-12 02:28:34'),
(68, '9faff974', 3, 'F', '2023-11-12 02:28:56', '2023-11-12 02:28:56'),
(69, '88a7676c', 3, 'F', '2023-11-12 02:30:22', '2023-11-12 02:30:22'),
(70, '797b8dc5', 3, 'F', '2023-11-13 22:35:04', '2023-11-13 22:35:04'),
(71, 'ab1dda8a', 3, 'F', '2023-11-13 22:35:12', '2023-11-13 22:35:12'),
(72, '4a85027b', 3, 'F', '2023-11-13 22:35:19', '2023-11-13 22:35:19'),
(73, '67b0dece', 105, 'F', '2023-11-19 01:57:06', '2023-11-19 01:57:06'),
(74, '26de3364', 105, 'F', '2023-11-19 02:01:22', '2023-11-19 02:01:22'),
(75, '7cc5e0a8', 105, 'F', '2023-11-19 02:15:08', '2023-11-19 02:15:08'),
(76, 'd8020731', 105, 'F', '2023-11-19 02:36:49', '2023-11-19 02:36:49'),
(77, '264d2835', 105, 'F', '2023-11-19 02:39:32', '2023-11-19 02:39:32'),
(78, '40b93016', 105, 'F', '2023-11-21 22:51:32', '2023-11-21 22:51:32'),
(79, '50e69edf', 105, 'F', '2023-11-21 23:16:49', '2023-11-21 23:16:49'),
(80, '3c788faa', 105, 'F', '2023-11-21 23:17:14', '2023-11-21 23:17:14'),
(81, 'bdac6465', 3, 'F', '2023-11-25 06:35:09', '2023-11-25 06:35:09'),
(82, '50b36df8', 3, 'F', '2023-11-25 09:21:03', '2023-11-25 09:21:03'),
(83, 'dd48822e', 3, 'F', '2023-11-25 09:21:14', '2023-11-25 09:21:14'),
(84, '406131b2', 3, 'F', '2023-11-25 09:22:27', '2023-11-25 09:22:27'),
(85, '33d92428', 3, 'F', '2023-11-26 14:10:51', '2023-11-26 14:10:51'),
(86, '58e799b0', 3, 'F', '2023-11-26 14:11:25', '2023-11-26 14:11:25'),
(87, '273a045d', 3, 'F', '2023-11-26 14:11:37', '2023-11-26 14:11:37'),
(88, '545a4579', 3, 'F', '2023-11-26 14:11:51', '2023-11-26 14:11:51'),
(89, '0d53ff36', 22, 'F', '2023-12-26 10:47:53', '2023-12-26 10:47:53'),
(90, '58bf3d62', 108, 'R', '2024-01-03 20:04:29', '2024-03-10 00:06:14'),
(91, 'b01cfc80', 108, 'R', '2024-01-03 20:12:14', '2024-03-10 00:06:14'),
(92, '283dc290', 108, 'R', '2024-01-03 22:43:26', '2024-03-10 00:06:14'),
(93, '36ac3cd3', 108, 'R', '2024-01-03 22:43:52', '2024-03-10 00:06:14'),
(94, '1bed229c', 108, 'R', '2024-01-03 22:44:25', '2024-03-10 00:06:14'),
(95, '31deb590', 108, 'R', '2024-01-03 22:45:45', '2024-03-10 00:06:14'),
(96, 'e1ea83c0', 16, 'F', '2024-01-03 22:46:22', '2024-01-03 22:46:22'),
(97, 'b59adcc1', 108, 'R', '2024-01-03 23:48:38', '2024-03-10 00:06:14'),
(98, 'a61d1d3d', 108, 'R', '2024-01-03 23:59:34', '2024-03-10 00:06:14'),
(99, '33ecf0b9', 108, 'R', '2024-01-07 00:35:28', '2024-03-10 00:06:14'),
(100, '715530e6', 108, 'R', '2024-01-07 00:37:58', '2024-03-10 00:06:14'),
(101, 'beac6769', 108, 'R', '2024-01-09 23:43:00', '2024-03-10 00:06:14'),
(102, 'c03ce2d6', 108, 'R', '2024-01-09 23:43:24', '2024-03-10 00:06:14'),
(103, 'c57a3c86', 108, 'R', '2024-01-10 00:01:26', '2024-03-10 00:06:14'),
(104, '0fce9a84', 108, 'R', '2024-01-10 00:01:50', '2024-03-10 00:06:14'),
(105, '2cabed89', 108, 'R', '2024-01-10 00:52:30', '2024-03-10 00:06:14'),
(106, 'c5c153eb', 108, 'R', '2024-01-10 05:10:43', '2024-03-10 00:06:14'),
(107, 'b5ef15fc', 108, 'R', '2024-01-12 11:39:57', '2024-03-10 00:06:14'),
(108, '498b9e43', 108, 'R', '2024-01-12 13:08:11', '2024-03-10 00:06:14'),
(109, '96a44f20', 108, 'R', '2024-01-12 13:25:57', '2024-03-10 00:06:14'),
(110, '9ed3176b', 108, 'R', '2024-01-12 13:26:34', '2024-03-10 00:06:14'),
(111, 'a0c92606', 108, 'R', '2024-01-12 13:27:40', '2024-03-10 00:06:14'),
(112, '5810d973', 108, 'R', '2024-01-12 13:44:26', '2024-03-10 00:06:14'),
(113, 'b138d60d', 108, 'R', '2024-01-12 13:45:40', '2024-03-10 00:06:14'),
(114, '03b8802d', 108, 'R', '2024-01-12 13:46:55', '2024-03-10 00:06:14'),
(115, 'a32d867e', 108, 'R', '2024-01-12 13:47:37', '2024-03-10 00:06:14'),
(116, '2fba85b3', 108, 'R', '2024-01-12 13:48:00', '2024-03-10 00:06:14'),
(117, 'a8eaed27', 108, 'R', '2024-01-12 13:50:08', '2024-03-10 00:06:14'),
(118, 'd26f13b5', 108, 'R', '2024-01-16 17:39:01', '2024-03-10 00:06:14'),
(119, '1f2d392b', 108, 'R', '2024-01-16 18:07:05', '2024-03-10 00:06:14'),
(120, '4b5e9423', 108, 'R', '2024-01-16 18:39:46', '2024-03-10 00:06:14'),
(121, 'd2489aa4', 108, 'R', '2024-01-16 18:41:52', '2024-03-10 00:06:14'),
(122, 'd1163667', 108, 'R', '2024-01-16 18:45:36', '2024-03-10 00:06:14'),
(123, 'abe6c881', 108, 'R', '2024-01-16 18:46:12', '2024-03-10 00:06:14'),
(124, 'dda73f84', 108, 'R', '2024-01-16 18:46:54', '2024-03-10 00:06:14'),
(125, 'c0dc5c2f', 108, 'R', '2024-01-19 22:42:09', '2024-03-10 00:06:14'),
(126, '1155fb72', 108, 'R', '2024-01-27 20:39:55', '2024-03-10 00:06:14'),
(127, '8061b986', 108, 'R', '2024-01-27 21:43:28', '2024-03-10 00:06:14'),
(128, '22632753', 108, 'R', '2024-01-27 22:07:13', '2024-03-10 00:06:14'),
(129, '5bf44ac4', 108, 'R', '2024-01-27 23:17:22', '2024-03-10 00:06:14'),
(130, '95fea6cd', 108, 'R', '2024-01-27 23:22:58', '2024-03-10 00:06:14'),
(131, '785c3fe1', 108, 'R', '2024-01-27 23:28:10', '2024-03-10 00:06:14'),
(132, '32066939', 108, 'R', '2024-01-28 04:01:09', '2024-03-10 00:06:14'),
(133, 'c5756acc', 108, 'R', '2024-01-28 21:25:31', '2024-03-10 00:06:14'),
(134, '94aa15df', 1, 'R', '2024-01-29 02:35:30', '2024-04-15 23:58:50'),
(135, 'a980ac20', 1, 'R', '2024-01-29 02:35:52', '2024-04-15 23:58:50'),
(136, '00b3cc99', 1, 'R', '2024-01-29 02:39:02', '2024-04-15 23:58:50'),
(137, '73449a3f', 1, 'R', '2024-01-29 02:39:21', '2024-04-15 23:58:50'),
(138, '499b7f86', 108, 'R', '2024-01-29 02:57:18', '2024-03-10 00:06:14'),
(139, '0068b8ed', 108, 'R', '2024-01-29 02:57:31', '2024-03-10 00:06:14'),
(140, '09b2d8fa', 1, 'R', '2024-01-29 02:57:54', '2024-04-15 23:58:50'),
(141, '14d148b7', 1, 'R', '2024-01-29 02:59:43', '2024-04-15 23:58:50'),
(142, 'd065c036', 108, 'R', '2024-01-29 02:59:43', '2024-03-10 00:06:14'),
(143, 'f18c6fb6', 1, 'R', '2024-01-29 03:00:01', '2024-04-15 23:58:50'),
(144, '164c4e97', 108, 'R', '2024-01-29 03:00:01', '2024-03-10 00:06:14'),
(145, 'b19c1594', 1, 'R', '2024-01-29 03:00:42', '2024-04-15 23:58:50'),
(146, '58dbbab3', 108, 'R', '2024-01-29 03:00:42', '2024-03-10 00:06:14'),
(147, 'a774788c', 1, 'R', '2024-01-29 03:02:01', '2024-04-15 23:58:50'),
(148, 'b5557ee2', 108, 'R', '2024-01-29 03:02:01', '2024-03-10 00:06:14'),
(149, '804f730a', 108, 'R', '2024-01-29 03:04:35', '2024-03-10 00:06:14'),
(150, '9b9b49d2', 108, 'R', '2024-01-29 03:08:51', '2024-03-10 00:06:14'),
(151, 'da6b044d', 108, 'R', '2024-01-29 03:09:18', '2024-03-10 00:06:14'),
(152, '400fb498', 108, 'R', '2024-01-29 03:16:58', '2024-03-10 00:06:14'),
(153, '46f2fadf', 108, 'R', '2024-01-29 17:25:59', '2024-03-10 00:06:14'),
(154, '5252fd47', 1, 'R', '2024-01-29 19:15:58', '2024-04-15 23:58:50'),
(155, '0d709d4f', 1, 'R', '2024-01-29 19:16:50', '2024-04-15 23:58:50'),
(156, 'e4ac07c3', 108, 'R', '2024-01-29 19:30:26', '2024-03-10 00:06:14'),
(157, '1e3eea38', 108, 'R', '2024-01-29 19:32:02', '2024-03-10 00:06:14'),
(158, 'da9cbc42', 108, 'R', '2024-01-29 22:19:25', '2024-03-10 00:06:14'),
(159, '2fc239d5', 108, 'R', '2024-01-29 22:20:02', '2024-03-10 00:06:14'),
(160, '57057ba5', 108, 'R', '2024-01-29 23:09:26', '2024-03-10 00:06:14'),
(161, 'd1f99a99', 108, 'R', '2024-01-29 23:15:23', '2024-03-10 00:06:14'),
(162, '9fdb73ce', 108, 'R', '2024-01-29 23:19:25', '2024-03-10 00:06:14'),
(163, '83f942e4', 108, 'R', '2024-01-31 23:51:02', '2024-03-10 00:06:14'),
(164, '240ab338', 108, 'R', '2024-02-01 01:08:59', '2024-03-10 00:06:14'),
(165, '85f9ed4c', 108, 'R', '2024-02-01 02:29:11', '2024-03-10 00:06:14'),
(166, 'e3d5362a', 108, 'R', '2024-02-01 02:29:24', '2024-03-10 00:06:14'),
(167, 'e490b749', 108, 'R', '2024-02-01 02:34:11', '2024-03-10 00:06:14'),
(168, '156bd67b', 108, 'R', '2024-02-02 00:41:30', '2024-03-10 00:06:14'),
(169, '2d664182', 108, 'R', '2024-02-02 00:41:37', '2024-03-10 00:06:14'),
(170, '874a5593', 108, 'R', '2024-02-02 00:41:45', '2024-03-10 00:06:14'),
(171, '9b4e8db8', 108, 'R', '2024-02-03 22:05:13', '2024-03-10 00:06:14'),
(172, '9b4e8db8', 108, 'R', '2024-02-03 22:05:13', '2024-03-10 00:06:14'),
(173, '55b5c1ac', 108, 'R', '2024-02-03 22:38:59', '2024-03-10 00:06:14'),
(174, '55b5c1ac', 108, 'R', '2024-02-03 22:38:59', '2024-03-10 00:06:14'),
(175, '5f954684', 108, 'R', '2024-02-03 22:46:08', '2024-03-10 00:06:14'),
(176, '5f954684', 108, 'R', '2024-02-03 22:46:08', '2024-03-10 00:06:14'),
(177, '6ab6db2e', 108, 'R', '2024-02-04 06:10:57', '2024-03-10 00:06:14'),
(178, 'e0b2c1ed', 108, 'R', '2024-02-04 06:31:34', '2024-03-10 00:06:14'),
(179, '6ef53408', 108, 'R', '2024-02-04 06:44:47', '2024-03-10 00:06:14'),
(180, '716cd658', 108, 'R', '2024-02-04 06:45:13', '2024-03-10 00:06:14'),
(181, '23942d6e', 108, 'R', '2024-02-04 06:56:36', '2024-03-10 00:06:14'),
(182, '9e1e8962', 108, 'R', '2024-02-04 06:57:22', '2024-03-10 00:06:14'),
(183, 'b6770934', 108, 'R', '2024-02-04 11:21:50', '2024-03-10 00:06:14'),
(184, '65c075dc', 108, 'R', '2024-02-04 11:23:36', '2024-03-10 00:06:14'),
(185, '2dd60a32', 108, 'R', '2024-02-04 11:25:54', '2024-03-10 00:06:14'),
(186, '61c8b8b1', 108, 'R', '2024-02-05 11:48:31', '2024-03-10 00:06:14'),
(187, '28ffab38', 108, 'R', '2024-02-05 12:00:30', '2024-03-10 00:06:14'),
(188, 'b9bbe170', 108, 'R', '2024-02-05 12:42:23', '2024-03-10 00:06:14'),
(189, '743da04d', 108, 'R', '2024-02-05 12:42:29', '2024-03-10 00:06:14'),
(190, 'e8247063', 108, 'R', '2024-02-05 12:42:34', '2024-03-10 00:06:14'),
(191, '95470f80', 108, 'R', '2024-02-05 13:36:54', '2024-03-10 00:06:14'),
(192, 'abfbcd43', 108, 'R', '2024-02-05 13:37:34', '2024-03-10 00:06:14'),
(193, '7c8fa7f2', 108, 'R', '2024-02-05 16:59:27', '2024-03-10 00:06:14'),
(194, '5ae445bc', 108, 'R', '2024-02-05 18:29:44', '2024-03-10 00:06:14'),
(195, 'b5a6ce7c', 108, 'R', '2024-02-08 18:11:58', '2024-03-10 00:06:14'),
(196, 'd26bc8c6', 108, 'R', '2024-02-08 18:12:05', '2024-03-10 00:06:14'),
(197, '951e5023', 108, 'R', '2024-02-08 18:12:13', '2024-03-10 00:06:14'),
(198, '7e158574', 108, 'R', '2024-02-09 07:56:00', '2024-03-10 00:06:14'),
(199, '7042ba42', 108, 'R', '2024-03-06 10:51:15', '2024-03-10 00:06:14'),
(200, '7042ba42', 108, 'R', '2024-03-06 10:51:16', '2024-03-10 00:06:14'),
(201, 'f2c2c3b4', 108, 'R', '2024-03-09 23:45:58', '2024-03-10 00:06:14'),
(202, 'f2c2c3b4', 108, 'R', '2024-03-09 23:45:58', '2024-03-10 00:06:14'),
(203, '99c7d284', 108, 'F', '2024-03-10 00:06:25', '2024-03-10 00:06:25'),
(204, '99c7d284', 108, 'F', '2024-03-10 00:06:25', '2024-03-10 00:06:25'),
(205, 'b4e66b5b', 108, 'F', '2024-04-27 14:38:58', '2024-04-27 14:38:58'),
(206, '5e2c7b6d', 108, 'F', '2024-05-27 22:02:56', '2024-05-27 22:02:56'),
(207, '5e2c7b6d', 108, 'F', '2024-05-27 22:02:57', '2024-05-27 22:02:57'),
(208, '57601022', 1, 'F', '2024-05-27 22:33:17', '2024-05-27 22:33:17'),
(209, '57601022', 1, 'F', '2024-05-27 22:33:18', '2024-05-27 22:33:18'),
(210, '0169b3a7', 108, 'F', '2024-05-27 22:52:46', '2024-05-27 22:52:46'),
(211, '0169b3a7', 108, 'F', '2024-05-27 22:52:46', '2024-05-27 22:52:46'),
(212, '76831c99', 108, 'F', '2024-05-27 23:01:03', '2024-05-27 23:01:03'),
(213, '76831c99', 108, 'F', '2024-05-27 23:01:03', '2024-05-27 23:01:03'),
(214, 'a9395412', 108, 'F', '2024-05-27 23:13:48', '2024-05-27 23:13:48'),
(215, 'a9395412', 108, 'F', '2024-05-27 23:13:49', '2024-05-27 23:13:49'),
(216, '282ff883', 23, 'F', '2024-05-27 23:23:40', '2024-05-27 23:23:40'),
(217, '282ff883', 23, 'F', '2024-05-27 23:23:40', '2024-05-27 23:23:40'),
(218, '4253e20c', 1, 'F', '2024-05-27 23:24:26', '2024-05-27 23:24:26'),
(219, '4253e20c', 1, 'F', '2024-05-27 23:24:26', '2024-05-27 23:24:26'),
(220, 'b7913bd9', 23, 'F', '2024-05-27 23:25:05', '2024-05-27 23:25:05'),
(221, 'b7913bd9', 23, 'F', '2024-05-27 23:25:06', '2024-05-27 23:25:06'),
(222, '94b838ab', 3, 'F', '2024-06-10 17:32:52', '2024-06-10 17:32:52'),
(223, '94b838ab', 3, 'F', '2024-06-10 17:32:52', '2024-06-10 17:32:52');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_payments`
--

CREATE TABLE `user_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`info`)),
  `type` enum('bank','papara','crypto','paypal') NOT NULL,
  `publish` enum('Y','N') NOT NULL DEFAULT 'Y',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_payments`
--

INSERT INTO `user_payments` (`id`, `user_id`, `title`, `info`, `type`, `publish`, `created_at`, `updated_at`) VALUES
(7, 2, NULL, '{\"type\":\"bank\",\"ex\":\"2\",\"info\":{\"fullname\":\"Mehmet HAKKIO\\u011eLU\",\"bank\":\"Ziraat Bankas\\u0131\",\"no\":\"TR90015641035\"}}', 'bank', 'N', '2023-09-17 20:14:31', '2023-09-17 20:15:03'),
(8, 2, NULL, '{\"type\":\"papara\",\"ex\":\"2\",\"info\":{\"fullname\":\"Mehmet HAKKIO\\u011eLU\",\"no\":\"PP1\"}}', 'papara', 'N', '2023-09-17 20:14:39', '2023-09-17 20:15:00'),
(9, 2, NULL, '{\"type\":\"crypto\",\"ex\":\"2\",\"info\":{\"address\":\"adresim\"}}', 'crypto', 'N', '2023-09-17 20:14:44', '2023-09-17 20:15:05'),
(10, 2, NULL, '{\"type\":\"paypal\",\"ex\":\"2\",\"info\":{\"fullname\":\"Mehmet HAKKIO\\u011eLU\",\"email\":\"mehmet@deneme.com\"}}', 'paypal', 'N', '2023-09-17 20:14:54', '2023-09-17 20:15:08'),
(11, 2, NULL, '{\"type\":\"bank\",\"ex\":\"2\",\"info\":{\"fullname\":\"Mehmet HAKKIO\\u011eLU\",\"bank\":\"Ziraat Bankas\\u0131\",\"no\":\"TR90015641035\"}}', 'bank', 'N', '2023-09-17 21:09:32', '2023-09-18 06:39:10'),
(12, 2, NULL, '{\"type\":\"crypto\",\"ex\":\"2\",\"info\":{\"address\":\"ASDASD\"}}', 'crypto', 'N', '2023-09-18 06:38:51', '2023-09-18 06:39:12'),
(13, 2, NULL, '{\"type\":\"bank\",\"ex\":\"2\",\"info\":{\"fullname\":\"Mehmet HAKKIO\\u011eLU\",\"bank\":\"Ziraat Bankas\\u0131\",\"no\":\"TR90015641035\"}}', 'bank', 'Y', '2023-09-18 06:40:30', '2023-09-18 06:40:30'),
(14, 22, NULL, '{\"type\":\"papara\",\"ex\":\"22\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"8789u\"}}', 'papara', 'Y', '2023-09-18 11:05:21', '2023-09-18 11:05:21'),
(15, 39, NULL, '{\"type\":\"papara\",\"ex\":\"39\",\"info\":{\"fullname\":\"Yusuf221\",\"no\":\"1125159845\"}}', 'papara', 'N', '2023-09-26 08:51:11', '2023-09-26 08:55:12'),
(16, 22, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"bank\",\"ex\":\"22\",\"info\":{\"fullname\":\"Yusuf Akkurt\",\"bank\":\"akbank\",\"no\":\"tr5849564648\"}}', 'bank', 'Y', '2023-10-27 00:05:26', '2023-10-27 00:05:26'),
(17, 22, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"22\",\"info\":{\"fullname\":\"Yusuf Akkurt\",\"no\":\"3373873783\"}}', 'papara', 'Y', '2023-10-27 00:05:49', '2023-10-27 00:05:49'),
(18, 22, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"crypto\",\"ex\":\"22\",\"info\":{\"address\":\"9utjhtpuhperhjp9eh\"}}', 'crypto', 'Y', '2023-10-27 00:06:09', '2023-10-27 00:06:09'),
(19, 22, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"paypal\",\"ex\":\"22\",\"info\":{\"fullname\":\"Yusuf Akkurt\",\"email\":\"43t444444444444444qtqt3tqt\"}}', 'paypal', 'Y', '2023-10-27 00:06:26', '2023-10-27 00:06:26'),
(20, 105, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"bank\",\"ex\":\"105\",\"info\":{\"fullname\":\"O\\u011fuzhan\",\"bank\":\"safasfasf\",\"no\":\"34234234333\"}}', 'bank', 'Y', '2023-11-20 22:58:30', '2023-11-20 22:58:30'),
(21, 105, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"bank\",\"ex\":\"105\",\"info\":{\"fullname\":\"O\\u011fuzhan\",\"bank\":\"safasfasf\",\"no\":\"34234234333\"}}', 'bank', 'N', '2023-11-20 22:58:32', '2023-11-20 22:59:51'),
(22, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"2342345235\"}}', 'papara', 'N', '2024-01-03 20:15:35', '2024-01-03 20:37:35'),
(23, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"2342345235\"}}', 'papara', 'N', '2024-01-03 20:15:36', '2024-01-03 20:37:40'),
(24, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"11111111\"}}', 'papara', 'N', '2024-01-03 20:37:24', '2024-01-03 20:37:43'),
(25, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"11111111\"}}', 'papara', 'N', '2024-01-03 20:37:25', '2024-01-03 20:37:46'),
(26, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"11111111\"}}', 'papara', 'N', '2024-01-03 20:37:25', '2024-01-03 20:37:49'),
(27, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"papara\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"no\":\"1111\"}}', 'papara', 'Y', '2024-01-03 20:39:34', '2024-01-03 20:39:34'),
(28, 108, NULL, '{\"action\":\"create\",\"action_id\":null,\"type\":\"bank\",\"ex\":\"108\",\"info\":{\"fullname\":\"o\\u011fuzhan k\\u0131ran\",\"bank\":\"ok\\u0131jk\",\"no\":\"tr12414212\"}}', 'bank', 'Y', '2024-01-03 23:42:00', '2024-01-03 23:42:00');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_promotions`
--

CREATE TABLE `user_promotions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action_code` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `promotion_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_reference_earnings`
--

CREATE TABLE `user_reference_earnings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reference_user_id` bigint(20) UNSIGNED NOT NULL,
  `earning` double NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `user_verify`
--

CREATE TABLE `user_verify` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `code` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`content`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `user_verify`
--

INSERT INTO `user_verify` (`id`, `user_id`, `code`, `type`, `content`, `created_at`) VALUES
(4, 11, 'd7cf69ee-ad49-44f2-a5f0-f238b553ced7', 'email', NULL, '2023-03-09 04:36:43'),
(6, 13, '7386a16b-0db7-4855-9d0e-b71f8003cd7f', 'email', NULL, '2023-03-09 04:39:27'),
(7, 14, '4dea025c-6d31-4668-be60-2debb03f70b7', 'email', NULL, '2023-03-21 05:29:38'),
(9, 16, 'a02af429-994a-4b79-963c-09cd690d551b', 'email', NULL, '2023-04-05 10:13:22'),
(10, 17, '6e5e4ffc-9dbb-44d4-8b40-8c121a20563b', 'email', NULL, '2023-04-05 11:28:50'),
(11, 18, '78942390-dca5-473d-be26-273c3c7a83bf', 'email', NULL, '2023-04-05 11:39:31'),
(12, 19, 'c9b172c2-5bcc-48b4-8274-e881a95f774f', 'email', NULL, '2023-04-05 11:50:42'),
(13, 20, 'de36e63f-24c2-49d3-b82c-f5791383c801', 'email', NULL, '2023-04-05 16:40:20'),
(14, 21, '5795da73-053f-4af3-beea-083af33c2fe2', 'email', NULL, '2023-04-05 16:54:57'),
(15, 23, '53694736-f9b5-49b1-8c65-7daf77fb7448', 'email', NULL, '2023-05-02 08:51:46'),
(21, 29, '5c63e51e-1873-4604-b280-d5ddc265ae01', 'email', '{\"email\": \"mehmet.hakkioglu@gmail.com\"}', '2023-05-30 15:12:35'),
(22, 30, 'd023e09c-1004-4e00-bb48-58cb794f4b05', 'email', '{\"email\": \"yusufhamamcii28@gmail.com\"}', '2023-06-24 19:46:53'),
(23, 31, '2cb190f3-3288-46ad-8eaa-58fd53e4a01d', 'email', '{\"email\": \"aynenoyle@yandex.com\"}', '2023-06-24 20:05:49'),
(26, 34, 'eb63c15e-d35e-4bfa-8b52-b3de947d5580', 'email', '{\"email\": \"mehmethakkioglu@yandex.com\"}', '2023-07-05 19:27:09'),
(27, 35, '739388aa-90a2-44b4-9b68-e136ee0230c3', 'email', '{\"email\": \"mehmethakkioglu@yandex.com\"}', '2023-07-05 19:29:08'),
(28, 37, '13417768-50ee-4e69-ba1e-bce486847517', 'email', '{\"email\": \"officialzeronio@gmail.com\"}', '2023-07-06 19:50:09'),
(29, 38, '1bc0c36e-b8c0-497f-8e88-7f58a7a34461', 'email', '{\"email\": \"zeronimo@yandex.com\"}', '2023-07-07 09:09:47'),
(31, 40, 'e199d8c9-53d9-4ca8-a42e-0af1a8c16a50', 'email', '{\"email\": \"gamepassdogrulama228@gmail.com\"}', '2023-07-07 09:47:05'),
(32, 41, '71bafae5-1f92-40a4-bd39-26ce2a0c4ccc', 'email', '{\"email\": \"myusufhamamci28@gmail.com\"}', '2023-07-07 10:09:03'),
(33, 42, '7a813e9c-fc71-4703-a0ee-e5576bbc57d8', 'email', '{\"email\": \"zirtopirto@gmail.com\"}', '2023-07-28 00:22:45'),
(34, 43, 'f436a591-a6ac-4268-8c81-8ade00adad77', 'email', '{\"email\": \"yayincideneme@futcoin.com\"}', '2023-08-22 11:06:08'),
(35, 44, '265b2836-a909-45e3-bf24-a3d2142075b5', 'email', '{\"email\": \"bayideneme@futcoin.com\"}', '2023-08-22 21:17:17'),
(38, 47, '3a8a0ec0-4fd1-4e36-a11a-76bd219ac0e3', 'email', '{\"email\":\"oneoguzhantr@yandex.com\"}', '2023-09-18 13:07:45'),
(39, 48, '5072b569-a4dd-4f01-bc59-42115ce62be6', 'email', '{\"email\":\"vaye.org@gmail.com\"}', '2023-09-18 13:09:03'),
(41, 68, '4d8a6681-9971-4b7b-a1ec-45ff48922f4a', 'email', '{\"email\":\"beratcadirci@hotmail.com\"}', '2023-09-18 17:44:07'),
(42, 69, 'f8c0f7c8-37a5-4d7f-9bdf-30c3cd84d808', 'email', '{\"email\":\"vaye.org@gmail.com\"}', '2023-09-18 19:33:25'),
(43, 70, '550530cc-158d-4df6-b9c0-43d3819881ff', 'email', '{\"email\":\"mikailaydin724@gmail.com\"}', '2023-09-22 19:04:01'),
(45, 72, '1cf41ae4-df09-47fe-a683-c331e56a2b13', 'email', '{\"email\":\"denememahmut@gmail.com\"}', '2023-09-26 06:32:35'),
(46, 73, '4b4b2fb6-8124-4ef4-8ff1-0f54111143d1', 'email', '{\"email\":\"denememahmut@gmail.com\"}', '2023-09-26 06:34:18'),
(47, 74, '0bf40ad2-e017-4306-9953-7cc40c164455', 'email', '{\"email\":\"denememahmut@gmail.com\"}', '2023-09-26 06:36:12'),
(48, 75, '339e55fe-97c7-4719-8231-c8295e75e316', 'email', '{\"email\":\"oguzhan@gmail2.com\"}', '2023-09-26 06:43:21'),
(49, 76, 'd8962a1d-9e0e-46d7-902d-985bf8f20b65', 'email', '{\"email\":\"mehmethakkioglutesthesabi@deneme.com\"}', '2023-10-03 14:17:05'),
(50, 77, '9bc64fa3-8a9a-4473-8eb9-9b73f04b76d2', 'email', '{\"email\":\"oguzhankirassssninfo@gmail.com\"}', '2023-10-03 14:18:45'),
(52, 79, '0dbc8bd2-b8ab-4528-ad66-e2d53d43bcd2', 'email', '{\"email\":\"grayson11060@gmail.com\"}', '2023-10-18 01:46:15'),
(53, 80, '29ffb11b-c60c-4a8d-9514-0fb2cfe4db6b', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 01:48:42'),
(54, 81, '9c7596ab-8ee2-42d3-8a95-b43ed2459d57', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 01:58:47'),
(55, 82, '24565806-4508-421a-8bfb-c2f9105c2735', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:02:10'),
(56, 83, 'c4ed9cb2-81dc-44e7-9068-41b43e1c9b5d', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:03:45'),
(57, 84, 'ebf16533-6b48-4285-9c9a-b5834cf41d73', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:06:12'),
(58, 85, '81531c77-febb-48cd-bbdf-71dcfc6ea471', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:11:44'),
(59, 86, '1d3aafe4-1cf8-4e98-a1b5-73905375ff17', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:14:00'),
(60, 87, 'b00def83-835b-4682-a5c2-ca3ef8b4ec02', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:18:48'),
(61, 88, 'e8f9dd51-5d1c-4c1d-8dd6-eeed339ec070', 'email', '{\"email\":\"prod.by.okool@gmail.com\"}', '2023-10-18 02:28:12'),
(62, 89, '21319bbe-2550-4706-a6aa-e27040bbdde9', 'email', '{\"email\":\"28ysf1907@gmail.com\"}', '2023-10-25 16:15:34'),
(73, 99, '6074d654-01e9-44ba-8e23-193d51879fd1', 'email', '{\"email\":\"denemeasd@gmail.com\"}', '2023-10-30 01:04:07'),
(74, 100, '4617e9d1-4579-4d26-9609-e4b50533825d', 'email', '{\"email\":\"fsdfsddfs@gmail.com\"}', '2023-11-03 15:41:00'),
(75, 101, 'b5e34f32-126f-4027-84e2-ed4c29173f9e', 'email', '{\"email\":\"MrOneTr@yandex.com\"}', '2023-11-18 23:01:21'),
(76, 102, '2828078b-285b-4473-b628-b8cd232b670e', 'email', '{\"email\":\"MrOneTr@yandex.com\"}', '2023-11-18 23:05:16'),
(77, 103, '63fd26cc-7f31-4528-95e8-a86cf4b7755d', 'email', '{\"email\":\"oguzoyuncu.28@gmail.com\"}', '2023-11-18 23:11:15'),
(78, 104, '29a98bd9-c421-4cba-969c-0f5497f413e2', 'email', '{\"email\":\"MrOneTr@yandex.com\"}', '2023-11-18 23:52:41'),
(80, 106, 'fa471eeb-189b-4aa6-b69b-5e035a10bcd2', 'email', '{\"email\":\"MrOneTr@yandex.com\"}', '2023-12-20 11:31:59'),
(81, 107, 'b497b467-cdac-4080-aada-75dd972015a9', 'email', '{\"email\":\"MrOneTr@yandex.com\"}', '2023-12-20 11:35:13'),
(82, 108, '193e9744-5d42-4fcc-a4ed-0983a23ab6ba', 'email', '{\"email\":\"MrOneTr@yandex.com\"}', '2023-12-20 12:57:20'),
(83, 108, '6e12cdcd-71ef-41bd-9a6b-c9b7c5ee546e', 'username', '{\"username\":\"mronetrr\",\"email\":\"MrOneTr@yandex.com\"}', '2024-01-03 23:34:20'),
(84, 108, '89c74bfe-56d2-4b39-843c-6d1e55022b72', 'username', '{\"username\":\"mronetrr\",\"email\":\"MrOneTr@yandex.com\"}', '2024-01-03 23:34:41');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `why_us`
--

CREATE TABLE `why_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `language` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`options`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `why_us`
--

INSERT INTO `why_us` (`id`, `code`, `language`, `title`, `description`, `icon`, `options`, `created_at`, `updated_at`) VALUES
(1, 'b4082a80', 'tr', 'KOLAY SİPARİŞ', 'Herhangi bir cihaz üzerinden FIFA coins satın almak çok hızlı ve basit. Birkaç tıklama senin için yeterli, kalan her şeyi biz hallederiz.', 'why-532e8a4d639d85e2779494f8f33e4954a4a4103cd1ab07395fa3106233bf2090.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-06-24 20:16:34', '2023-07-06 14:08:08'),
(2, 'b4082a80', 'en', 'EASY ORDER', 'Buying FIFA coins on any device is very fast and simple. A few clicks are enough for you, we\'ll take care of the rest.', 'why-532e8a4d639d85e2779494f8f33e4954a4a4103cd1ab07395fa3106233bf2090.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-06-24 20:16:34', '2023-07-06 14:08:08'),
(3, '42a2ae0f', 'tr', 'HIZLI TESLİMAT', 'Sistemimiz tamamen otomatik, bu sebeple FIFA coinlerini mümkün olan en kısa sürede sana teslim ediyoruz.', 'why-fb5685e6b3e306f911da2f888a6406c95d5410a38da65b692d10b87e8621562b.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:09:57', '2023-07-06 14:09:57'),
(4, '42a2ae0f', 'en', 'FAST DELIVERY', 'Our system is fully automated, so we deliver FIFA coins to you as soon as possible.', 'why-fb5685e6b3e306f911da2f888a6406c95d5410a38da65b692d10b87e8621562b.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:09:57', '2023-07-06 14:09:57'),
(5, 'fe88fddf', 'tr', 'GÜVENLİK', 'Coins transfer algoritmalarımız, sizin için kusursuz emniyet ve güvenilirlik elde etmemizi sağladı.', 'why-0dd099c09443a108ec3b4d2bb43aaa76a6e14166f9ec5555ab2cf0d185d1967a.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:12:08', '2023-07-06 14:12:08'),
(6, 'fe88fddf', 'en', 'SECURITY', 'Our coins transfer algorithms have enabled us to achieve impeccable safety and reliability for you.', 'why-0dd099c09443a108ec3b4d2bb43aaa76a6e14166f9ec5555ab2cf0d185d1967a.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:12:08', '2023-07-06 14:12:08'),
(7, '170869fe', 'tr', 'EN UCUZ FİYATLAR', 'Sen tam olarak ödediğin miktarın karşılığını alırsın, geri kalan tüm komisyon ücretleri biz öderiz. Buna ek olarak, her satın alma işleminde harika bir nakit para üstü alırsın.', 'why-836909367f3198188baad4f04df30c67a37983a27be6d29c336f42a7f0a5f457.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:25:42', '2023-07-06 14:25:42'),
(8, '170869fe', 'en', 'CHEAPEST PRICES', 'You get exactly what you pay for, we pay all the rest of the commission fees. In addition, you get a great cashback with every purchase.', 'why-836909367f3198188baad4f04df30c67a37983a27be6d29c336f42a7f0a5f457.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:25:42', '2023-07-06 14:25:42'),
(9, '00c03c66', 'tr', 'CANLI DESTEK', 'Müşteri temsilcilerimiz sana yardımcı olmak ve sorularınıza cevap vermek için her zaman hazır.', 'why-3e2a17a80e4f564c5c65d95d3e86145631f199ae996ad6f4d4cfd2e929561e44.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:28:11', '2023-07-06 14:28:11'),
(10, '00c03c66', 'en', 'LIVE SUPPORT', 'Our customer representatives are always ready to help you and answer your questions.', 'why-3e2a17a80e4f564c5c65d95d3e86145631f199ae996ad6f4d4cfd2e929561e44.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:28:11', '2023-07-06 14:28:11'),
(11, '6aa0f6ac', 'tr', 'GÜVENİLİRLİK', 'Senelerin verdiği tecrübeyle, sayısız memnun müşteri. Birçok farklı hizmetimiz için çok sayıda olumlu değerlendirme.', 'why-bc302c4b92202cc885362340a083cd536bd50350abd3039e9ff829e3fe47499d.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:31:32', '2023-07-06 14:31:32'),
(12, '6aa0f6ac', 'en', 'RELIABILITY', 'With years of experience, countless satisfied customers. Lots of positive reviews for our many different services.', 'why-bc302c4b92202cc885362340a083cd536bd50350abd3039e9ff829e3fe47499d.png', '{\"width\": \"50\", \"height\": \"50\"}', '2023-07-06 14:31:32', '2023-07-06 14:31:32');

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `wishlist`
--

CREATE TABLE `wishlist` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `account_code` varchar(255) NOT NULL,
  `wish_type` varchar(50) NOT NULL DEFAULT 'account',
  `old_price` double DEFAULT NULL,
  `current_price` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `withdraws`
--

CREATE TABLE `withdraws` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `balance` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `admin_note` text DEFAULT NULL,
  `action` enum('P','Y','N','AN') NOT NULL DEFAULT 'P',
  `type` varchar(50) NOT NULL DEFAULT 'balance',
  `payment_id` int(11) DEFAULT NULL,
  `currency_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `withdraws`
--

INSERT INTO `withdraws` (`id`, `uuid`, `user_id`, `admin_id`, `balance`, `description`, `admin_note`, `action`, `type`, `payment_id`, `currency_id`, `created_at`, `updated_at`) VALUES
(4, 'e1665123-2307-4ce6-8ac2-9faefd74b005', 108, 16, '100', 'tmmm', NULL, 'Y', 'balance', 27, 1, '2024-01-03 21:01:16', '2024-01-03 21:17:48');

--
-- Dökümü yapılmış tablolar için indeksler
--

--
-- Tablo için indeksler `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accounts_game_id_foreign` (`game_id`),
  ADD KEY `accounts_status_id_foreign` (`status_id`);

--
-- Tablo için indeksler `account_actions`
--
ALTER TABLE `account_actions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_actions_user_id_foreign` (`user_id`),
  ADD KEY `account_actions_admin_id_foreign` (`admin_id`);

--
-- Tablo için indeksler `account_features`
--
ALTER TABLE `account_features`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `account_images`
--
ALTER TABLE `account_images`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `account_orders`
--
ALTER TABLE `account_orders`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `answers`
--
ALTER TABLE `answers`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `apis`
--
ALTER TABLE `apis`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `applications_status_id_foreign` (`status_id`);

--
-- Tablo için indeksler `application_form_images`
--
ALTER TABLE `application_form_images`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `assistant_order_transfers`
--
ALTER TABLE `assistant_order_transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assistant_order_transfers_admin_id_foreign` (`admin_id`),
  ADD KEY `assistant_order_transfers_transfer_admin_id_foreign` (`transfer_admin_id`);

--
-- Tablo için indeksler `avatars`
--
ALTER TABLE `avatars`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `balances`
--
ALTER TABLE `balances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dealer_balances_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `balance_histories`
--
ALTER TABLE `balance_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Tablo için indeksler `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blogs_category_id_foreign` (`category_id`),
  ADD KEY `blogs_author_foreign` (`author`);

--
-- Tablo için indeksler `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_comments_user_id_foreign` (`user_id`),
  ADD KEY `blog_comments_comment_id_foreign` (`comment_id`);

--
-- Tablo için indeksler `boosts`
--
ALTER TABLE `boosts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `boosts_game_id_foreign` (`game_id`),
  ADD KEY `boosts_feature_group_id_foreign` (`feature_group_id`);

--
-- Tablo için indeksler `boost_items`
--
ALTER TABLE `boost_items`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `boost_item_features`
--
ALTER TABLE `boost_item_features`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `boost_item_images`
--
ALTER TABLE `boost_item_images`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Tablo için indeksler `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Tablo için indeksler `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaigns_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `cards`
--
ALTER TABLE `cards`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `carousels`
--
ALTER TABLE `carousels`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_parent_id_foreign` (`parent_id`);

--
-- Tablo için indeksler `channels`
--
ALTER TABLE `channels`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `city`
--
ALTER TABLE `city`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `commissions`
--
ALTER TABLE `commissions`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `conversations`
--
ALTER TABLE `conversations`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `country_evidence_docs`
--
ALTER TABLE `country_evidence_docs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `country_evidence_docs_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `country_groups`
--
ALTER TABLE `country_groups`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `courier_images`
--
ALTER TABLE `courier_images`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `currency`
--
ALTER TABLE `currency`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `customer_campaigns`
--
ALTER TABLE `customer_campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_campaigns_campaign_id_foreign` (`campaign_id`),
  ADD KEY `customer_campaigns_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `customer_draw_participations`
--
ALTER TABLE `customer_draw_participations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_draw_participations_draw_id_foreign` (`draw_id`),
  ADD KEY `customer_draw_participations_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `dealer_balances`
--
ALTER TABLE `dealer_balances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dealer_balances_user_id_foreign` (`user_id`),
  ADD KEY `dealer_balances_payment_id_foreign` (`payment_id`);

--
-- Tablo için indeksler `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departments_admin_id_foreign` (`admin_id`);

--
-- Tablo için indeksler `district`
--
ALTER TABLE `district`
  ADD PRIMARY KEY (`id`),
  ADD KEY `district_city_id_foreign` (`city_id`);

--
-- Tablo için indeksler `draws`
--
ALTER TABLE `draws`
  ADD PRIMARY KEY (`id`),
  ADD KEY `draws_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `email_verifies`
--
ALTER TABLE `email_verifies`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `empty_games`
--
ALTER TABLE `empty_games`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Tablo için indeksler `faq`
--
ALTER TABLE `faq`
  ADD PRIMARY KEY (`id`),
  ADD KEY `faq_category_id_foreign` (`category_id`);

--
-- Tablo için indeksler `faq_category`
--
ALTER TABLE `faq_category`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `features`
--
ALTER TABLE `features`
  ADD PRIMARY KEY (`id`),
  ADD KEY `features_feature_group_id_foreign` (`feature_group_id`);

--
-- Tablo için indeksler `feature_groups`
--
ALTER TABLE `feature_groups`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `games`
--
ALTER TABLE `games`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `game_methods`
--
ALTER TABLE `game_methods`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `game_prices`
--
ALTER TABLE `game_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `game_prices_game_id_foreign` (`game_id`),
  ADD KEY `game_prices_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `game_servers`
--
ALTER TABLE `game_servers`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `hata`
--
ALTER TABLE `hata`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `helpers`
--
ALTER TABLE `helpers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `helpers_helper_category_id_foreign` (`helper_category_id`);

--
-- Tablo için indeksler `helper_categories`
--
ALTER TABLE `helper_categories`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoices_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `live_messages`
--
ALTER TABLE `live_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `live_messages_conversation_id_foreign` (`conversation_id`),
  ADD KEY `live_messages_admin_id_foreign` (`admin_id`);

--
-- Tablo için indeksler `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `mail_templates`
--
ALTER TABLE `mail_templates`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `messages_conversation_id_foreign` (`conversation_id`),
  ADD KEY `messages_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Tablo için indeksler `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Tablo için indeksler `modules`
--
ALTER TABLE `modules`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `navigation`
--
ALTER TABLE `navigation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `navigation_parent_id_foreign` (`parent_id`),
  ADD KEY `navigation_group_id_foreign` (`group_id`);

--
-- Tablo için indeksler `navigation_group`
--
ALTER TABLE `navigation_group`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `notification_settings`
--
ALTER TABLE `notification_settings`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Tablo için indeksler `order_histories`
--
ALTER TABLE `order_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_histories_user_id_foreign` (`user_id`),
  ADD KEY `order_histories_assistant_id_foreign` (`assistant_id`);

--
-- Tablo için indeksler `order_notes`
--
ALTER TABLE `order_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_notes_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `order_parts`
--
ALTER TABLE `order_parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_parts_order_id_foreign` (`order_id`),
  ADD KEY `order_parts_dealer_id_foreign` (`dealer_id`),
  ADD KEY `order_parts_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `outside_orders`
--
ALTER TABLE `outside_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `outside_orders_admin_id_foreign` (`admin_id`),
  ADD KEY `outside_orders_game_id_foreign` (`game_id`),
  ADD KEY `outside_orders_platform_id_foreign` (`platform_id`),
  ADD KEY `outside_orders_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `page_widgets`
--
ALTER TABLE `page_widgets`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`email`);

--
-- Tablo için indeksler `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `payment_to_order`
--
ALTER TABLE `payment_to_order`
  ADD KEY `payment_to_order_order_id_foreign` (`order_id`);

--
-- Tablo için indeksler `penalties`
--
ALTER TABLE `penalties`
  ADD PRIMARY KEY (`id`),
  ADD KEY `penalties_user_id_foreign` (`user_id`),
  ADD KEY `penalties_admin_id_foreign` (`admin_id`);

--
-- Tablo için indeksler `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Tablo için indeksler `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Tablo için indeksler `platforms`
--
ALTER TABLE `platforms`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `platform_groups`
--
ALTER TABLE `platform_groups`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `pos_test`
--
ALTER TABLE `pos_test`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `price_list`
--
ALTER TABLE `price_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `price_list_platform_id_foreign` (`platform_id`),
  ADD KEY `price_list_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `price_list_history`
--
ALTER TABLE `price_list_history`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `price_orders`
--
ALTER TABLE `price_orders`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `problems`
--
ALTER TABLE `problems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `problems_user_id_foreign` (`user_id`),
  ADD KEY `problems_problem_user_foreign` (`problem_user`);

--
-- Tablo için indeksler `problem_history`
--
ALTER TABLE `problem_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `problem_history_problem_id_foreign` (`problem_id`),
  ADD KEY `problem_history_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `promotions`
--
ALTER TABLE `promotions`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `provisions`
--
ALTER TABLE `provisions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `provisions_stock_id_foreign` (`stock_id`);

--
-- Tablo için indeksler `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Tablo için indeksler `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Tablo için indeksler `role_price_list`
--
ALTER TABLE `role_price_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_price_list_platform_id_foreign` (`platform_id`),
  ADD KEY `role_price_list_currency_id_foreign` (`currency_id`),
  ADD KEY `role_price_list_game_id_foreign` (`game_id`);

--
-- Tablo için indeksler `role_to_module`
--
ALTER TABLE `role_to_module`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Tablo için indeksler `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `settings_group_index` (`group`);

--
-- Tablo için indeksler `sponsors`
--
ALTER TABLE `sponsors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sponsors_campaign_id_foreign` (`campaign_id`),
  ADD KEY `sponsors_draw_id_foreign` (`draw_id`),
  ADD KEY `sponsors_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `static_pages`
--
ALTER TABLE `static_pages`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `status`
--
ALTER TABLE `status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status_status_group_foreign` (`status_group`);

--
-- Tablo için indeksler `status_group`
--
ALTER TABLE `status_group`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `stocks`
--
ALTER TABLE `stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stocks_user_id_foreign` (`user_id`),
  ADD KEY `stocks_platform_id_foreign` (`platform_id`),
  ADD KEY `stocks_game_id_foreign` (`game_id`),
  ADD KEY `stocks_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `streamers`
--
ALTER TABLE `streamers`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `streamer_order_commissions`
--
ALTER TABLE `streamer_order_commissions`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `streamer_references`
--
ALTER TABLE `streamer_references`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teams_user_id_index` (`user_id`);

--
-- Tablo için indeksler `team_invitations`
--
ALTER TABLE `team_invitations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `team_invitations_team_id_email_unique` (`team_id`,`email`);

--
-- Tablo için indeksler `team_user`
--
ALTER TABLE `team_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `team_user_team_id_user_id_unique` (`team_id`,`user_id`);

--
-- Tablo için indeksler `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tickets_user_id_foreign` (`user_id`),
  ADD KEY `tickets_parent_id_foreign` (`parent_id`);

--
-- Tablo için indeksler `ticket_files`
--
ALTER TABLE `ticket_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_files_ticket_id_foreign` (`ticket_id`),
  ADD KEY `ticket_files_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `translate`
--
ALTER TABLE `translate`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Tablo için indeksler `user_accounts`
--
ALTER TABLE `user_accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_accounts_user_id_foreign` (`user_id`),
  ADD KEY `user_accounts_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `user_account_price_changes`
--
ALTER TABLE `user_account_price_changes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_account_price_changes_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `user_action_histories`
--
ALTER TABLE `user_action_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_action_histories_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `user_changes`
--
ALTER TABLE `user_changes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_changes_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `user_commissions`
--
ALTER TABLE `user_commissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_commissions_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `user_country_change`
--
ALTER TABLE `user_country_change`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `user_draws`
--
ALTER TABLE `user_draws`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `user_draw_settings`
--
ALTER TABLE `user_draw_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_draw_settings_streamer_foreign` (`streamer`);

--
-- Tablo için indeksler `user_info`
--
ALTER TABLE `user_info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_info_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `user_invoice_address`
--
ALTER TABLE `user_invoice_address`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `user_notifications`
--
ALTER TABLE `user_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_notifications_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `user_payments`
--
ALTER TABLE `user_payments`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `user_promotions`
--
ALTER TABLE `user_promotions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_promotions_user_id_foreign` (`user_id`),
  ADD KEY `user_promotions_promotion_id_foreign` (`promotion_id`),
  ADD KEY `id` (`id`);

--
-- Tablo için indeksler `user_reference_earnings`
--
ALTER TABLE `user_reference_earnings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_reference_earnings_user_id_foreign` (`user_id`),
  ADD KEY `user_reference_earnings_reference_user_id_foreign` (`reference_user_id`),
  ADD KEY `user_reference_earnings_currency_id_foreign` (`currency_id`);

--
-- Tablo için indeksler `user_verify`
--
ALTER TABLE `user_verify`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `why_us`
--
ALTER TABLE `why_us`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wishlist_user_id_foreign` (`user_id`);

--
-- Tablo için indeksler `withdraws`
--
ALTER TABLE `withdraws`
  ADD PRIMARY KEY (`id`),
  ADD KEY `withdraws_user_id_foreign` (`user_id`);

--
-- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri
--

--
-- Tablo için AUTO_INCREMENT değeri `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `account_actions`
--
ALTER TABLE `account_actions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `account_features`
--
ALTER TABLE `account_features`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- Tablo için AUTO_INCREMENT değeri `account_images`
--
ALTER TABLE `account_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Tablo için AUTO_INCREMENT değeri `account_orders`
--
ALTER TABLE `account_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `answers`
--
ALTER TABLE `answers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Tablo için AUTO_INCREMENT değeri `apis`
--
ALTER TABLE `apis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `applications`
--
ALTER TABLE `applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- Tablo için AUTO_INCREMENT değeri `application_form_images`
--
ALTER TABLE `application_form_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- Tablo için AUTO_INCREMENT değeri `assistant_order_transfers`
--
ALTER TABLE `assistant_order_transfers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `avatars`
--
ALTER TABLE `avatars`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `balances`
--
ALTER TABLE `balances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Tablo için AUTO_INCREMENT değeri `balance_histories`
--
ALTER TABLE `balance_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- Tablo için AUTO_INCREMENT değeri `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- Tablo için AUTO_INCREMENT değeri `boosts`
--
ALTER TABLE `boosts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `boost_items`
--
ALTER TABLE `boost_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `boost_item_features`
--
ALTER TABLE `boost_item_features`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Tablo için AUTO_INCREMENT değeri `boost_item_images`
--
ALTER TABLE `boost_item_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- Tablo için AUTO_INCREMENT değeri `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `cards`
--
ALTER TABLE `cards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `carousels`
--
ALTER TABLE `carousels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `category`
--
ALTER TABLE `category`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Tablo için AUTO_INCREMENT değeri `channels`
--
ALTER TABLE `channels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `city`
--
ALTER TABLE `city`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- Tablo için AUTO_INCREMENT değeri `commissions`
--
ALTER TABLE `commissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `conversations`
--
ALTER TABLE `conversations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `countries`
--
ALTER TABLE `countries`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=208;

--
-- Tablo için AUTO_INCREMENT değeri `country_evidence_docs`
--
ALTER TABLE `country_evidence_docs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `country_groups`
--
ALTER TABLE `country_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `courier_images`
--
ALTER TABLE `courier_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `currency`
--
ALTER TABLE `currency`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Tablo için AUTO_INCREMENT değeri `customer_campaigns`
--
ALTER TABLE `customer_campaigns`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `customer_draw_participations`
--
ALTER TABLE `customer_draw_participations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `dealer_balances`
--
ALTER TABLE `dealer_balances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `district`
--
ALTER TABLE `district`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=912;

--
-- Tablo için AUTO_INCREMENT değeri `draws`
--
ALTER TABLE `draws`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `email_verifies`
--
ALTER TABLE `email_verifies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- Tablo için AUTO_INCREMENT değeri `empty_games`
--
ALTER TABLE `empty_games`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `faq`
--
ALTER TABLE `faq`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Tablo için AUTO_INCREMENT değeri `faq_category`
--
ALTER TABLE `faq_category`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Tablo için AUTO_INCREMENT değeri `features`
--
ALTER TABLE `features`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Tablo için AUTO_INCREMENT değeri `feature_groups`
--
ALTER TABLE `feature_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `games`
--
ALTER TABLE `games`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Tablo için AUTO_INCREMENT değeri `game_methods`
--
ALTER TABLE `game_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `game_prices`
--
ALTER TABLE `game_prices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Tablo için AUTO_INCREMENT değeri `game_servers`
--
ALTER TABLE `game_servers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Tablo için AUTO_INCREMENT değeri `hata`
--
ALTER TABLE `hata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Tablo için AUTO_INCREMENT değeri `helpers`
--
ALTER TABLE `helpers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- Tablo için AUTO_INCREMENT değeri `helper_categories`
--
ALTER TABLE `helper_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- Tablo için AUTO_INCREMENT değeri `live_messages`
--
ALTER TABLE `live_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `logs`
--
ALTER TABLE `logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `mail_templates`
--
ALTER TABLE `mail_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;

--
-- Tablo için AUTO_INCREMENT değeri `modules`
--
ALTER TABLE `modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- Tablo için AUTO_INCREMENT değeri `navigation`
--
ALTER TABLE `navigation`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- Tablo için AUTO_INCREMENT değeri `navigation_group`
--
ALTER TABLE `navigation_group`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=282;

--
-- Tablo için AUTO_INCREMENT değeri `notification_settings`
--
ALTER TABLE `notification_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- Tablo için AUTO_INCREMENT değeri `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- Tablo için AUTO_INCREMENT değeri `order_histories`
--
ALTER TABLE `order_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `order_notes`
--
ALTER TABLE `order_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `order_parts`
--
ALTER TABLE `order_parts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `outside_orders`
--
ALTER TABLE `outside_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- Tablo için AUTO_INCREMENT değeri `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `page_widgets`
--
ALTER TABLE `page_widgets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `penalties`
--
ALTER TABLE `penalties`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Tablo için AUTO_INCREMENT değeri `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `platforms`
--
ALTER TABLE `platforms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- Tablo için AUTO_INCREMENT değeri `platform_groups`
--
ALTER TABLE `platform_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `pos_test`
--
ALTER TABLE `pos_test`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `price_list`
--
ALTER TABLE `price_list`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- Tablo için AUTO_INCREMENT değeri `price_list_history`
--
ALTER TABLE `price_list_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- Tablo için AUTO_INCREMENT değeri `price_orders`
--
ALTER TABLE `price_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- Tablo için AUTO_INCREMENT değeri `problems`
--
ALTER TABLE `problems`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `problem_history`
--
ALTER TABLE `problem_history`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `promotions`
--
ALTER TABLE `promotions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `provisions`
--
ALTER TABLE `provisions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `role_price_list`
--
ALTER TABLE `role_price_list`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `role_to_module`
--
ALTER TABLE `role_to_module`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- Tablo için AUTO_INCREMENT değeri `sponsors`
--
ALTER TABLE `sponsors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `static_pages`
--
ALTER TABLE `static_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Tablo için AUTO_INCREMENT değeri `status`
--
ALTER TABLE `status`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- Tablo için AUTO_INCREMENT değeri `status_group`
--
ALTER TABLE `status_group`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `stocks`
--
ALTER TABLE `stocks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `streamers`
--
ALTER TABLE `streamers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `streamer_order_commissions`
--
ALTER TABLE `streamer_order_commissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `streamer_references`
--
ALTER TABLE `streamer_references`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `tags`
--
ALTER TABLE `tags`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- Tablo için AUTO_INCREMENT değeri `teams`
--
ALTER TABLE `teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- Tablo için AUTO_INCREMENT değeri `team_invitations`
--
ALTER TABLE `team_invitations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `team_user`
--
ALTER TABLE `team_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- Tablo için AUTO_INCREMENT değeri `ticket_files`
--
ALTER TABLE `ticket_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- Tablo için AUTO_INCREMENT değeri `translate`
--
ALTER TABLE `translate`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2244;

--
-- Tablo için AUTO_INCREMENT değeri `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- Tablo için AUTO_INCREMENT değeri `user_accounts`
--
ALTER TABLE `user_accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `user_account_price_changes`
--
ALTER TABLE `user_account_price_changes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Tablo için AUTO_INCREMENT değeri `user_action_histories`
--
ALTER TABLE `user_action_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `user_changes`
--
ALTER TABLE `user_changes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `user_commissions`
--
ALTER TABLE `user_commissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Tablo için AUTO_INCREMENT değeri `user_country_change`
--
ALTER TABLE `user_country_change`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `user_draws`
--
ALTER TABLE `user_draws`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Tablo için AUTO_INCREMENT değeri `user_draw_settings`
--
ALTER TABLE `user_draw_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `user_info`
--
ALTER TABLE `user_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- Tablo için AUTO_INCREMENT değeri `user_invoice_address`
--
ALTER TABLE `user_invoice_address`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- Tablo için AUTO_INCREMENT değeri `user_notifications`
--
ALTER TABLE `user_notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=224;

--
-- Tablo için AUTO_INCREMENT değeri `user_payments`
--
ALTER TABLE `user_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- Tablo için AUTO_INCREMENT değeri `user_promotions`
--
ALTER TABLE `user_promotions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `user_reference_earnings`
--
ALTER TABLE `user_reference_earnings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `user_verify`
--
ALTER TABLE `user_verify`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- Tablo için AUTO_INCREMENT değeri `why_us`
--
ALTER TABLE `why_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Tablo için AUTO_INCREMENT değeri `wishlist`
--
ALTER TABLE `wishlist`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Tablo için AUTO_INCREMENT değeri `withdraws`
--
ALTER TABLE `withdraws`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Dökümü yapılmış tablolar için kısıtlamalar
--

--
-- Tablo kısıtlamaları `accounts`
--
ALTER TABLE `accounts`
  ADD CONSTRAINT `accounts_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`);

--
-- Tablo kısıtlamaları `account_actions`
--
ALTER TABLE `account_actions`
  ADD CONSTRAINT `account_actions_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `account_actions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `applications`
--
ALTER TABLE `applications`
  ADD CONSTRAINT `applications_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`);

--
-- Tablo kısıtlamaları `assistant_order_transfers`
--
ALTER TABLE `assistant_order_transfers`
  ADD CONSTRAINT `assistant_order_transfers_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `assistant_order_transfers_transfer_admin_id_foreign` FOREIGN KEY (`transfer_admin_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `blogs_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`);

--
-- Tablo kısıtlamaları `boosts`
--
ALTER TABLE `boosts`
  ADD CONSTRAINT `boosts_feature_group_id_foreign` FOREIGN KEY (`feature_group_id`) REFERENCES `feature_groups` (`id`),
  ADD CONSTRAINT `boosts_game_id_foreign` FOREIGN KEY (`game_id`) REFERENCES `games` (`id`);

--
-- Tablo kısıtlamaları `campaigns`
--
ALTER TABLE `campaigns`
  ADD CONSTRAINT `campaigns_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `category`
--
ALTER TABLE `category`
  ADD CONSTRAINT `category_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `category` (`id`);

--
-- Tablo kısıtlamaları `country_evidence_docs`
--
ALTER TABLE `country_evidence_docs`
  ADD CONSTRAINT `country_evidence_docs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `customer_campaigns`
--
ALTER TABLE `customer_campaigns`
  ADD CONSTRAINT `customer_campaigns_campaign_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`),
  ADD CONSTRAINT `customer_campaigns_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `customer_draw_participations`
--
ALTER TABLE `customer_draw_participations`
  ADD CONSTRAINT `customer_draw_participations_draw_id_foreign` FOREIGN KEY (`draw_id`) REFERENCES `draws` (`id`),
  ADD CONSTRAINT `customer_draw_participations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `dealer_balances`
--
ALTER TABLE `dealer_balances`
  ADD CONSTRAINT `dealer_balances_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`),
  ADD CONSTRAINT `dealer_balances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `departments`
--
ALTER TABLE `departments`
  ADD CONSTRAINT `departments_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `district`
--
ALTER TABLE `district`
  ADD CONSTRAINT `district_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`);

--
-- Tablo kısıtlamaları `draws`
--
ALTER TABLE `draws`
  ADD CONSTRAINT `draws_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `faq`
--
ALTER TABLE `faq`
  ADD CONSTRAINT `faq_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `faq_category` (`id`);

--
-- Tablo kısıtlamaları `features`
--
ALTER TABLE `features`
  ADD CONSTRAINT `features_feature_group_id_foreign` FOREIGN KEY (`feature_group_id`) REFERENCES `feature_groups` (`id`);

--
-- Tablo kısıtlamaları `helpers`
--
ALTER TABLE `helpers`
  ADD CONSTRAINT `helpers_helper_category_id_foreign` FOREIGN KEY (`helper_category_id`) REFERENCES `helper_categories` (`id`);

--
-- Tablo kısıtlamaları `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `live_messages`
--
ALTER TABLE `live_messages`
  ADD CONSTRAINT `live_messages_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `live_messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`);

--
-- Tablo kısıtlamaları `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`),
  ADD CONSTRAINT `messages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `navigation`
--
ALTER TABLE `navigation`
  ADD CONSTRAINT `navigation_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `navigation_group` (`id`),
  ADD CONSTRAINT `navigation_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `navigation` (`id`);

--
-- Tablo kısıtlamaları `order_histories`
--
ALTER TABLE `order_histories`
  ADD CONSTRAINT `order_histories_assistant_id_foreign` FOREIGN KEY (`assistant_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `order_notes`
--
ALTER TABLE `order_notes`
  ADD CONSTRAINT `order_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `penalties`
--
ALTER TABLE `penalties`
  ADD CONSTRAINT `penalties_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `penalties_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `provisions`
--
ALTER TABLE `provisions`
  ADD CONSTRAINT `provisions_stock_id_foreign` FOREIGN KEY (`stock_id`) REFERENCES `stocks` (`id`);

--
-- Tablo kısıtlamaları `stocks`
--
ALTER TABLE `stocks`
  ADD CONSTRAINT `stocks_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`id`),
  ADD CONSTRAINT `stocks_game_id_foreign` FOREIGN KEY (`game_id`) REFERENCES `games` (`id`),
  ADD CONSTRAINT `stocks_platform_id_foreign` FOREIGN KEY (`platform_id`) REFERENCES `platforms` (`id`),
  ADD CONSTRAINT `stocks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Tablo kısıtlamaları `user_draw_settings`
--
ALTER TABLE `user_draw_settings`
  ADD CONSTRAINT `user_draw_settings_streamer_foreign` FOREIGN KEY (`streamer`) REFERENCES `users` (`id`);
COMMIT;

