-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 11 Oca 2026, 18:56:50
-- Sunucu sürümü: 10.6.19-MariaDB
-- PHP Sürümü: 8.1.34

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ı: `wanywebc_nothtech`
--

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

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

CREATE TABLE `tahta_boards` (
  `id` int(10) UNSIGNED NOT NULL,
  `board_id` varchar(64) NOT NULL,
  `device_key_hash` char(64) DEFAULT NULL,
  `owner_user_id` int(11) DEFAULT NULL,
  `pin_code` varchar(10) NOT NULL,
  `pairing_nonce` varchar(32) NOT NULL DEFAULT '',
  `pairing_expires_at` datetime NOT NULL,
  `unlock_code` varchar(6) DEFAULT NULL,
  `unlock_nonce` varchar(32) DEFAULT NULL,
  `unlock_expires_at` datetime DEFAULT NULL,
  `is_frozen` tinyint(1) NOT NULL DEFAULT 1,
  `paired_token_hash` char(64) DEFAULT NULL,
  `paired_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `tahta_boards` (`id`, `board_id`, `device_key_hash`, `owner_user_id`, `pin_code`, `pairing_nonce`, `pairing_expires_at`, `unlock_code`, `unlock_nonce`, `unlock_expires_at`, `is_frozen`, `paired_token_hash`, `paired_at`, `created_at`, `updated_at`) VALUES
(1, 'B5abcbfc2eed40296ef34', NULL, NULL, '365299', '', '0000-00-00 00:00:00', NULL, NULL, NULL, 0, NULL, NULL, '2026-01-10 11:05:11', '2026-01-10 11:06:13'),
(2, 'B0519a30943a3f9b6d0a4', NULL, NULL, '296817', '', '0000-00-00 00:00:00', NULL, NULL, NULL, 1, NULL, NULL, '2026-01-10 11:06:36', '2026-01-10 11:06:36'),
(3, 'B09cf1ab9d32cde903878', '98f403674639089b29e9e90279f866c0da090cb9f547d4d7cfebd8173bbb55ee', NULL, '041697', '', '0000-00-00 00:00:00', NULL, NULL, NULL, 1, '', '2026-01-10 16:23:43', '2026-01-10 16:14:52', '2026-01-10 17:06:14'),
(4, 'Bd653e91762282a3a8a45', 'd556d54e20fc21d56c684242ca04e8825490714b70a2aebc773469842e12e944', 0, '678973', '', '0000-00-00 00:00:00', NULL, NULL, NULL, 0, '1178fda8411b2534d9a83547066d474c341e26a1f3d0d4f9725b0307795fb33d', '2026-01-10 17:21:40', '2026-01-10 17:15:43', '2026-01-11 18:55:07'),
(5, 'Bd083a0d9556f75f64dc9', '5788d94ef82d89192405985ce40d21a7e98a42234199207fa6607377e71f6d6b', 2, '808316', '', '0000-00-00 00:00:00', NULL, NULL, NULL, 0, '6508eb60b65275831befcdf336adcfceb3a181c8f6147608e68b0e4cc8cf664c', NULL, '2026-01-11 18:12:28', '2026-01-11 18:55:13');

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

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

CREATE TABLE `tahta_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `board_id` varchar(64) NOT NULL,
  `action` varchar(32) NOT NULL,
  `ip` varchar(64) DEFAULT NULL,
  `ua` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `tahta_logs` (`id`, `board_id`, `action`, `ip`, `ua`, `created_at`) VALUES
(1, 'B5abcbfc2eed40296ef34', 'register', '45.11.43.79', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 OPR/125.0.0.0 (Edition Yx GX TR 2)', '2026-01-10 11:05:11'),
(2, 'B5abcbfc2eed40296ef34', 'register', '45.11.43.79', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 OPR/125.0.0.0 (Edition Yx GX TR 2)', '2026-01-10 11:06:13'),
(3, 'B0519a30943a3f9b6d0a4', 'register', '45.11.43.79', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36 OPR/125.0.0.0 (Edition Yx GX TR 2)', '2026-01-10 11:06:36');

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

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

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(60) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `username`, `password_hash`, `created_at`) VALUES
(1, 'admin@noth.com.tr', '$2y$10$yPSEDkUWARzTnTbZZHKop.J5nEj2pF0kzuWuXkC88QqqofDNXyS8W', '2026-01-10 12:21:57'),
(2, 'demo@demo.com', '$2y$10$gav/GjzKSencXODlBJpfkeXuTeBQRVDLc5z9nczkyeZo2SWVJ1wQS', '2026-01-10 14:01:07'),
(3, 'selim@wanyweb.com', '$2y$10$uhcsaCzjY7Cpl0d.QJKXNeIpjYQFddVcOzPjrwsraWInVfScmx72q', '2026-01-11 15:09:41');

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

--
-- Tablo için indeksler `tahta_boards`
--
ALTER TABLE `tahta_boards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_board_id` (`board_id`),
  ADD KEY `idx_owner_user_id` (`owner_user_id`);

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

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

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

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

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

--
-- Tablo için AUTO_INCREMENT değeri `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
