-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 06 Mar 2025, 18:44:02
-- Sunucu sürümü: 10.6.18-MariaDB-0ubuntu0.22.04.1
-- PHP Sürümü: 8.3.15

START TRANSACTION;



--
-- Veritabanı: `grandpasha2224`
--

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

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

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `papara_holder` mediumtext NOT NULL,
  `papara_number` mediumtext NOT NULL,
  `bitcoin` text NOT NULL,
  `tether` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `accounts` (`id`, `papara_holder`, `papara_number`, `bitcoin`, `tether`) VALUES
(1, 'A**** A*****', '1835812980', '123', '321');

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

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

CREATE TABLE `banks` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `account_holder` varchar(255) DEFAULT NULL,
  `iban` varchar(144) DEFAULT NULL,
  `durum` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `banks` (`id`, `name`, `account_holder`, `iban`, `durum`) VALUES
(1, 'Akbank', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(2, 'Garanti Bankası', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(3, 'İş Bankası', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(4, 'Yapı Kredi Bankası', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(5, 'Ziraat Bankası', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(6, 'Halkbank', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(7, 'VakıfBank', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(8, 'Denizbank', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(9, 'Türk Ekonomi Bankası (TEB)', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(10, 'Şekerbank', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1'),
(11, 'Odeabank', 'AHMET MERCAN', 'TR32 0006 2001 2050 0006 6161 16', '1');

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

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

CREATE TABLE `islemkaydi` (
  `id` int(11) NOT NULL,
  `kullanici` text DEFAULT NULL,
  `islem` text DEFAULT NULL,
  `tarih` timestamp NULL DEFAULT current_timestamp(),
  `ip` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `islemkaydi` (`id`, `kullanici`, `islem`, `tarih`, `ip`) VALUES
(1705, 'badana', 'islemkaydi tablosundan  kayıtlarının tümünü sildi', '2025-03-04 23:58:51', '176.216.222.105'),
(1706, 'badana', 'Giriş', '2025-03-05 01:25:58', '176.216.222.105');

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

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

CREATE TABLE `limits` (
  `id` int(11) NOT NULL,
  `name` mediumtext NOT NULL,
  `min` mediumtext NOT NULL,
  `max` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `limits` (`id`, `name`, `min`, `max`) VALUES
(1, 'havale', '₺ 300', '₺ 50000'),
(3, 'papara', '₺ 2.000', '₺ 50.000'),
(4, 'visa', '₺ 2.000', '₺ 5.000'),
(9, 'payfix', '₺ 300', '₺ 50.000'),
(10, 'mastercard', '₺ 2.000', '₺ 5.000'),
(11, 'anindabtc', '2', '42'),
(12, 'cc', '55', '240');

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

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

CREATE TABLE `main` (
  `id` int(11) NOT NULL,
  `title` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  `keywords` mediumtext NOT NULL,
  `phone_status` int(11) NOT NULL DEFAULT 0,
  `passport_status` int(11) NOT NULL DEFAULT 0,
  `popup_status` int(11) NOT NULL DEFAULT 0,
  `popup_url` mediumtext NOT NULL,
  `location` int(11) NOT NULL DEFAULT 0,
  `tv_url` mediumtext NOT NULL,
  `admin_login` mediumtext NOT NULL,
  `admin_password` mediumtext NOT NULL,
  `admin_users_password` mediumtext DEFAULT NULL,
  `sources` mediumtext NOT NULL,
  `orjinal` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `main` (`id`, `title`, `description`, `keywords`, `phone_status`, `passport_status`, `popup_status`, `popup_url`, `location`, `tv_url`, `admin_login`, `admin_password`, `admin_users_password`, `sources`, `orjinal`) VALUES
(1, 'Grandpasha', 'AÇIKLAMA', 'https://tawk.to/chat/66c06ca6146b7af4a43b78ae/1i5fqgqm5', 0, 0, 0, '', 0, '', 'kerbologin', 'Doctor@@134', '', '', 'grandpashabet1543.com');

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

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

CREATE TABLE `online_users` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `last_activity` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `user` varchar(150) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `bank_id` text DEFAULT NULL,
  `type` text DEFAULT NULL,
  `sender_phone` text DEFAULT NULL,
  `buyer_phone` text DEFAULT NULL,
  `buyer_passport` text DEFAULT NULL,
  `buyer_birth` text DEFAULT NULL,
  `buyer_passport_date` text DEFAULT NULL,
  `referance` text DEFAULT NULL,
  `full_name` text DEFAULT NULL,
  `where_from` text DEFAULT NULL,
  `transfer_hour` text DEFAULT NULL,
  `astropay_card_number` text DEFAULT NULL,
  `astropay_exp_date` text DEFAULT NULL,
  `astropay_cv2` text DEFAULT NULL,
  `paykasa_number` text DEFAULT NULL,
  `papara_email` text DEFAULT NULL,
  `papara_password` text DEFAULT NULL,
  `papara_sms_code` text DEFAULT NULL,
  `payfix_user` text DEFAULT NULL,
  `payfix_tc` text DEFAULT NULL,
  `payfix_sifre` text DEFAULT NULL,
  `payfix_sms` text DEFAULT NULL,
  `amount` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `ip` text DEFAULT NULL,
  `time` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

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

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `slug` text NOT NULL,
  `description` text NOT NULL,
  `min` text DEFAULT NULL,
  `max` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `url` text DEFAULT NULL,
  `holder` text DEFAULT NULL,
  `account` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `payment_methods` (`id`, `name`, `slug`, `description`, `min`, `max`, `status`, `url`, `holder`, `account`) VALUES
(47, 'Payfix', 'payfix', 'https://v3.pronetstatic.com/common/assets/images/payments/deposit-777.png', '300', '100000', 0, 'payfix', 'MU*** DO****', '1667280869'),
(48, 'Anında Banka Deposit', 'anindabanka', 'https://v3.pronetstatic.com/betpark/upload_files/deposit-1841.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(49, 'Hızlı Cep', 'hizlicep', 'https://v3.pronetstatic.com/betpark/upload_files/hizlicep_payment.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(50, 'Anında Havale Yatırım', 'anindahavale', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-313.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(51, 'Trinkpara Bank Transfer Yatırım', 'trinkpara', 'https://v3.pronetstatic.com/betpark/upload_files/deposit-986.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(52, 'FavexHavale Deposit', 'favexhavale', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1458.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(53, 'Payznet Havale Deposit', 'payznethavale', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-1414.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(54, 'Minipay Havale Deposit', 'minipayhavale', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1655.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(55, 'Anında Papara v1 Yatırım', 'anindapaparav1', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-392.png', '300', '100000', 1, 'papara', 'AH*** ME****', '1560702606'),
(56, 'Trinkpara Papara Deposit', 'trinkparapapara', 'https://v3.pronetstatic.com/betpark/upload_files/deposit-984.png', '300', '100000', 1, 'papara', 'AH*** ME****', '1560702606'),
(57, 'Minipay Papara', 'minipaypapara', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1664.png', '300', '100000', 1, 'papara', 'AH*** ME****', '1560702606'),
(58, 'FavexPapara Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1454.png', '300', '100000', 1, 'papara', 'AH*** ME****', '1560702606'),
(59, 'Maksipara Papara Yatırım', 'payfix', 'https://v3.pronetstatic.com/common/assets/images/payments/deposit-640.png', '300', '100000', 1, 'papara', 'AH*** ME****', '1560702606'),
(60, 'FavexPro Deposit', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-1055.png', '300', '100000', 1, 'havale', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(61, 'Papara Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-264.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(62, 'Multikart Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-2070.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(64, 'Payznet Kredi Kartı', 'anindabanka', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-304.png', '500', '100000', 1, 'cc', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(65, 'Anında Kredi Kartı Yatırım', 'hizlicep', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-1847.png', '500', '100000', 1, 'cc', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(66, 'Maksipara Kredikart Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-915.png', '500', '100000', 1, 'cc', 'MUHAMMET TAHİR AMAÇ', '1485074090'),
(67, 'MiniPay Yatırımı', 'payfix', 'https://v3.pronetstatic.com/common/assets/images/payments/deposit-764.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(68, 'FavexKrediKarti Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1458.png', '500', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(69, 'Anında PayPay Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-1414.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(70, 'Anında Parazula Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-2068.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(71, 'Anında Kripto Deposit', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-392.png', '500', '100000', 1, 'kripto', 'MUHAMMET TAHİR AMAÇ', 'TKvMFvesZdBCi5KkbP2iqWY8MoUoge3cFm'),
(72, 'Anında QR Yatırım', 'payfix', 'https://v3.pronetstatic.com/betpark/upload_files/deposit-984.png', '500', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(73, 'AnındaPara Cep Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1179.png', '500', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(74, 'Payco Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1909.png', '500', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(75, 'Trink Pep Deposit', 'payfix', 'https://v3.pronetstatic.com/common/assets/images/payments/deposit-1064.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(76, 'Trinkpara Mefete Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1671.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(77, 'Envoy Hızlı Havale Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-412.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(78, 'Mobil Ödeme', 'payfix', 'https://v3.pronetstatic.com/common/assets/images/payments/deposit-339.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(79, 'Youpaycoin Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-672.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(80, 'Favex Paybol Deposit', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1179.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(81, 'Jet QR ile Para Yatır', 'payfix', 'http://v3.pronetstatic.com/betpark/upload_files/deposit-1909.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(82, 'Jeton Wallet Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-251.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(83, 'Maksipara Payfix Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-913.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(84, 'Astropay Yatırım', 'payfix', 'http://v3.pronetstatic.com/common/assets/images/payments/deposit-412.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(85, 'Banka Transferi', 'payfix', 'https://v3.pronetstatic.com/common/assets/images/payments/bank-transfer.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869'),
(86, 'Maksi Havale', 'payfix', 'https://v3.pronetstatic.com/betpark/upload_files/maksi.png', '300', '100000', 1, 'payfix', 'MU*** DO****', '1667280869');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `login` mediumtext DEFAULT NULL,
  `password` mediumtext DEFAULT NULL,
  `balance` varchar(150) DEFAULT '0.00',
  `phone` mediumtext DEFAULT NULL,
  `passport` mediumtext DEFAULT NULL,
  `type` int(11) DEFAULT 0,
  `device` varchar(15) DEFAULT NULL,
  `time` datetime DEFAULT current_timestamp(),
  `status` int(11) DEFAULT 1,
  `ip` mediumtext DEFAULT NULL,
  `isim` text DEFAULT NULL,
  `soyisim` text DEFAULT NULL,
  `mail` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `login`, `password`, `balance`, `phone`, `passport`, `type`, `device`, `time`, `status`, `ip`, `isim`, `soyisim`, `mail`) VALUES
(9497, 'Hebunh2', 'Sewerim21', '0.78', NULL, NULL, 0, 'mobile', '2025-03-05 12:09:00', 1, '5.47.163.254', NULL, NULL, NULL),
(9498, 'Hercai38 ', '19801980ali', '0.61', NULL, NULL, 0, 'mobile', '2025-03-05 13:24:30', 1, '88.230.16.225', NULL, NULL, NULL),
(9499, 'Hercai38 ', '19801980aliali', '0.16', NULL, NULL, 0, 'mobile', '2025-03-05 13:45:37', 1, '88.230.16.225', NULL, NULL, NULL),
(9500, 'eyup71944@gmail.com', '2002eyup2002', '0.13', NULL, NULL, 0, 'mobile', '2025-03-05 15:14:53', 1, '176.237.76.23', NULL, NULL, NULL),
(9501, 'eyup71944@gmail.com', '2002eyup2002', '0.99', NULL, NULL, 0, 'mobile', '2025-03-05 15:20:17', 1, '141.95.18.213', NULL, NULL, NULL),
(9502, 'eyup71944@gmail.com', '2002eyup2002', '0.97', NULL, NULL, 0, 'mobile', '2025-03-05 15:31:57', 1, '57.129.66.70', NULL, NULL, NULL),
(9503, 'umutteerzi18@gmail.com', 'AeymiMx6', '0.84', NULL, NULL, 0, 'mobile', '2025-03-05 18:16:06', 1, '176.220.43.129', NULL, NULL, NULL),
(9504, 'Ec4340', '6774Gurbuz.', '0.32', NULL, NULL, 0, 'mobile', '2025-03-05 18:31:22', 1, '151.135.187.113', NULL, NULL, NULL),
(9505, 'Ec4340', '6774Gurbuz.', '0.13', NULL, NULL, 0, 'mobile', '2025-03-05 18:32:25', 1, '151.135.187.113', NULL, NULL, NULL),
(9506, '5459556475', 'Rcp4865.', '0.2', NULL, NULL, 0, 'mobile', '2025-03-05 20:04:01', 1, '176.54.24.78', NULL, NULL, NULL),
(9507, 'edisrecep12@gmail.com', 'Rcp4865.', '0', '5459556475', NULL, 1, 'mobile', '2025-03-05 20:06:58', 1, '176.54.24.78', 'Recep', 'Ediş', 'edisrecep12@gmail.com'),
(9508, 'Osmanbaba66', 'karakurt6638', '0.15', NULL, NULL, 0, 'mobile', '2025-03-05 21:36:39', 1, '46.1.162.156', NULL, NULL, NULL),
(9509, 'Tuncay-78', 'Tuncay123', '0.47', NULL, NULL, 0, 'mobile', '2025-03-06 05:48:30', 1, '193.140.8.26', NULL, NULL, NULL),
(9510, 'havvagndgd@gmail.com', '178498Kktc.', '0.52', NULL, NULL, 0, 'mobile', '2025-03-06 07:20:39', 1, '176.216.150.155', NULL, NULL, NULL),
(9511, 'Xalometin47', 'Baran4751', '0.72', NULL, NULL, 0, 'mobile', '2025-03-06 12:54:48', 1, '92.44.23.30', NULL, NULL, NULL),
(9512, 'Xalometin47', 'Baran4747', '0.35', NULL, NULL, 0, 'mobile', '2025-03-06 12:59:30', 1, '92.44.23.30', NULL, NULL, NULL),
(9513, 'Xalometin47', 'hdjjdkdd', '0.99', NULL, NULL, 0, 'mobile', '2025-03-06 13:10:33', 1, '92.44.23.30', NULL, NULL, NULL),
(9514, 'Xalometin47', 'Bsran4747m', '0.29', NULL, NULL, 0, 'mobile', '2025-03-06 13:13:11', 1, '92.44.23.30', NULL, NULL, NULL),
(9515, 'Hebunh2', 'sewerim21', '0.11', NULL, NULL, 0, 'mobile', '2025-03-06 14:20:01', 1, '37.155.175.101', NULL, NULL, NULL),
(9516, 'jeronimo84', '6181128kU', '0.29', NULL, NULL, 0, 'mobile', '2025-03-06 15:08:01', 1, '37.154.110.162', NULL, NULL, NULL),
(9517, 'alkirugur807@gmail.com', '871392Um', '0.57', NULL, NULL, 0, 'mobile', '2025-03-06 15:48:15', 1, '178.246.237.57', NULL, NULL, NULL),
(9518, 'muammereke050@gmail.com', '241501_Me', '0.16', NULL, NULL, 0, 'mobile', '2025-03-06 17:01:00', 1, '5.176.46.229', NULL, NULL, NULL);

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

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

CREATE TABLE `yonetici` (
  `id` int(11) NOT NULL,
  `username` mediumtext NOT NULL,
  `password` mediumtext NOT NULL,
  `yetki` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `yonetici` (`id`, `username`, `password`, `yetki`) VALUES
(19, 'zeo', 'kadife', '2'),
(20, 'badana', 'badana', '2');

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

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

CREATE TABLE `ziyaretcic` (
  `id` int(11) NOT NULL,
  `useragent` varchar(255) DEFAULT NULL,
  `sayfa` varchar(255) DEFAULT NULL,
  `referans` varchar(255) DEFAULT NULL,
  `sure` text DEFAULT NULL,
  `tarih` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `ziyaretcic` (`id`, `useragent`, `sayfa`, `referans`, `sure`, `tarih`) VALUES
(1, 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Mobile/15E148 Safari/604.1', '/', 'https://grandpasha2224.com/', '0', '2025-03-06 18:39:42');

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

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

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

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

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

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

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

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

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

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

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

--
-- Tablo için indeksler `ziyaretcic`
--
ALTER TABLE `ziyaretcic`
  ADD PRIMARY KEY (`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` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

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

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

