-- https://www.phpmyadmin.net/
--
-- Anamakine: 127.0.0.1
-- Üretim Zamanı: 13 Haz 2025, 00:41:30
-- Sunucu sürümü: 10.4.32-MariaDB
-- PHP Sürümü: 8.1.25

START TRANSACTION;



--
-- Veritabanı: `instabot`
--

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

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

CREATE TABLE `instagram_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(255) NOT NULL,
  `enc_password` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) NOT NULL,
  `cookies` text DEFAULT NULL,
  `sessionid` varchar(255) DEFAULT NULL,
  `csrftoken` varchar(128) DEFAULT NULL,
  `ig_did` varchar(64) DEFAULT NULL,
  `device_id` varchar(128) DEFAULT NULL,
  `datr` varchar(128) DEFAULT NULL,
  `mid` varchar(128) DEFAULT NULL,
  `login_ip` varchar(45) DEFAULT NULL,
  `login_time` datetime NOT NULL DEFAULT current_timestamp(),
  `last_used` datetime DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `login_status` varchar(32) DEFAULT NULL,
  `error_message` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `instagram_accounts` (`id`, `username`, `password`, `enc_password`, `user_agent`, `cookies`, `sessionid`, `csrftoken`, `ig_did`, `device_id`, `datr`, `mid`, `login_ip`, `login_time`, `last_used`, `is_active`, `login_status`, `error_message`) VALUES
(1, 'birkutupirlanta', '6231232+m', '#PWD_INSTAGRAM_BROWSER:0:1749766594:6231232+m', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Mobile Safari/537.36', '{\"csrftoken\":\"w8UzzuGFBgFcSGqY1zSH65LqctFIjlKL\",\"rur\":\"\\\"CLN\\\\05474886537469\\\\0541781302598:01fe0f1924ff9fd2be4dbffac2b3b46f47ff2c32d87a1912c26ef28da7d4ffaf72f4751f\\\"\",\"mid\":\"aEtRwQABAAFItHVDwZrVOb8u3ar2\",\"ds_user_id\":\"74886537469\",\"th_eu_pref\":\"\\\"\\\"\",\"ig_did\":\"7EC6F211-EF0A-40E9-BB78-305BF4BAFF32\",\"sessionid\":\"74886537469:wWF7S85ZtUyfUd:22:AYdJtJ4RGsQanj6AGc66CbCacupmO27hG-cYkBgJRg\"}', '74886537469:wWF7S85ZtUyfUd:22:AYdJtJ4RGsQanj6AGc66CbCacupmO27hG-cYkBgJRg', 'w8UzzuGFBgFcSGqY1zSH65LqctFIjlKL', '7EC6F211-EF0A-40E9-BB78-305BF4BAFF32', '1810616de5e0e960f4aac7e20e0c4ede', '', 'aEtRwQABAAFItHVDwZrVOb8u3ar2', '::1', '2025-06-13 01:16:39', NULL, 1, 'success', NULL),
(2, 'trmediam', '6231232+++', '#PWD_INSTAGRAM_BROWSER:0:1749766699:6231232+++', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Mobile Safari/537.36', '{\"csrftoken\":\"hX853ahdXOl3VVvYyGCbYLKNSRon9j1C\",\"rur\":\"\\\"CLN\\\\05445372869256\\\\0541781302705:01fea0fcfc9305ace7168ae2a180380d3903454df1eda009131cdedce892a0632186eb3e\\\"\",\"mid\":\"aEtSKgABAAHMiJMvgnjzSDyBj_DX\",\"ds_user_id\":\"45372869256\",\"th_eu_pref\":\"\\\"\\\"\",\"ig_did\":\"67FA0224-2F82-4374-A711-C6DDDFCF2A84\",\"sessionid\":\"45372869256:zc98MdUCvAuFeM:21:AYfe64bnV9ueE7jHVo_HRjhMlDNgR1eK7vSWUz0cyA\"}', '45372869256:zc98MdUCvAuFeM:21:AYfe64bnV9ueE7jHVo_HRjhMlDNgR1eK7vSWUz0cyA', 'hX853ahdXOl3VVvYyGCbYLKNSRon9j1C', '67FA0224-2F82-4374-A711-C6DDDFCF2A84', 'e8365647ec76301da5570e78ddeebbfd', '', 'aEtSKgABAAHMiJMvgnjzSDyBj_DX', '::1', '2025-06-13 01:18:26', NULL, 1, 'success', NULL);

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

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

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

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

