-- 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 */;