-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 07, 2026 at 08:34 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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 */; -- -- Database: `lichange` -- -- -------------------------------------------------------- -- -- Table structure for table `activations` -- CREATE TABLE `activations` ( `id` bigint(20) UNSIGNED NOT NULL, `license_id` bigint(20) UNSIGNED NOT NULL, `tool_id` bigint(20) UNSIGNED NOT NULL, `device_hash` varchar(64) NOT NULL, `device_token_hash` varchar(64) NOT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` varchar(500) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `activations` -- INSERT INTO `activations` (`id`, `license_id`, `tool_id`, `device_hash`, `device_token_hash`, `last_used_at`, `ip_address`, `user_agent`, `created_at`, `updated_at`) VALUES (1, 2, 1, '4a5e73f7e169054c6f20596cc392230b5ace3e6b6c9d06b9ae30c4fa74753ff8', '9ec3ed6cb9c9935b5da5f329cbed00edd44319f822db6930f2d985090e36c26c', '2026-08-07 12:30:48', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '2026-08-07 12:30:07', '2026-08-07 12:30:48'); -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `name`, `email`, `password`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Main Admin', 'admin@example.com', '$2y$12$b.gTAxJr3ssF.QOJxLsmKOMvOepJX7kU22AExPXQBjnXWhV3wa...', 1, '2026-08-07 12:11:21', '2026-08-07 12:11:21'); -- -------------------------------------------------------- -- -- Table structure for table `licenses` -- CREATE TABLE `licenses` ( `id` bigint(20) UNSIGNED NOT NULL, `tool_id` bigint(20) UNSIGNED DEFAULT NULL, `key_hash` varchar(64) NOT NULL, `key_last4` varchar(4) NOT NULL, `status` enum('active','disabled') NOT NULL DEFAULT 'active', `expires_at` timestamp NULL DEFAULT NULL, `max_devices` int(10) UNSIGNED NOT NULL DEFAULT 1, `notes` varchar(500) DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `licenses` -- INSERT INTO `licenses` (`id`, `tool_id`, `key_hash`, `key_last4`, `status`, `expires_at`, `max_devices`, `notes`, `created_by`, `created_at`, `updated_at`) VALUES (2, 1, 'a3aa9c71c18f7ec87b7096d9720a3e4c3f9b6ff8a998d9c319cace5ecaec3e4d', 'PZLL', 'active', '2026-08-20 18:00:00', 1, 'fgg', 1, '2026-08-07 12:18:15', '2026-08-07 12:18:15'), (3, 1, '204270012e444745542f9f1af929a9dce8b004e91cf8a5d8ff886a2bcd5c01e2', 'T8EV', 'active', '2026-08-27 18:00:00', 1, 'qr', 1, '2026-08-07 12:32:06', '2026-08-07 12:32:06'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2026_01_01_000001_create_admins_table', 1), (2, '2026_01_01_000002_create_tools_table', 1), (3, '2026_01_01_000003_create_tool_versions_table', 1), (4, '2026_01_01_000004_create_licenses_table', 1), (5, '2026_01_01_000005_create_activations_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `tools` -- CREATE TABLE `tools` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `description` varchar(500) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tools` -- INSERT INTO `tools` (`id`, `name`, `slug`, `description`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Facebook', 'free', 'new', 1, '2026-08-07 12:14:47', '2026-08-07 12:14:47'); -- -------------------------------------------------------- -- -- Table structure for table `tool_versions` -- CREATE TABLE `tool_versions` ( `id` bigint(20) UNSIGNED NOT NULL, `tool_id` bigint(20) UNSIGNED NOT NULL, `version` int(10) UNSIGNED NOT NULL, `file_path` varchar(255) NOT NULL, `checksum` varchar(64) NOT NULL, `notes` varchar(500) DEFAULT NULL, `uploaded_by` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tool_versions` -- INSERT INTO `tool_versions` (`id`, `tool_id`, `version`, `file_path`, `checksum`, `notes`, `uploaded_by`, `created_at`, `updated_at`) VALUES (1, 1, 1, 'tools/free/v1.js', '37389b42dcd73dcf0ebe31018fec6e515e9e828a3479e0a6401ef3cdda5de30f', '1.1.1', 1, '2026-08-07 12:14:47', '2026-08-07 12:14:47'); -- -- Indexes for dumped tables -- -- -- Indexes for table `activations` -- ALTER TABLE `activations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `activations_license_id_tool_id_device_hash_unique` (`license_id`,`tool_id`,`device_hash`), ADD KEY `activations_tool_id_device_hash_index` (`tool_id`,`device_hash`); -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indexes for table `licenses` -- ALTER TABLE `licenses` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `licenses_key_hash_unique` (`key_hash`), ADD KEY `licenses_tool_id_foreign` (`tool_id`), ADD KEY `licenses_created_by_foreign` (`created_by`), ADD KEY `licenses_status_expires_at_index` (`status`,`expires_at`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tools` -- ALTER TABLE `tools` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tools_slug_unique` (`slug`); -- -- Indexes for table `tool_versions` -- ALTER TABLE `tool_versions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tool_versions_tool_id_version_unique` (`tool_id`,`version`), ADD KEY `tool_versions_uploaded_by_foreign` (`uploaded_by`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `activations` -- ALTER TABLE `activations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `licenses` -- ALTER TABLE `licenses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tools` -- ALTER TABLE `tools` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tool_versions` -- ALTER TABLE `tool_versions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `activations` -- ALTER TABLE `activations` ADD CONSTRAINT `activations_license_id_foreign` FOREIGN KEY (`license_id`) REFERENCES `licenses` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `activations_tool_id_foreign` FOREIGN KEY (`tool_id`) REFERENCES `tools` (`id`) ON DELETE CASCADE; -- -- Constraints for table `licenses` -- ALTER TABLE `licenses` ADD CONSTRAINT `licenses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `licenses_tool_id_foreign` FOREIGN KEY (`tool_id`) REFERENCES `tools` (`id`) ON DELETE SET NULL; -- -- Constraints for table `tool_versions` -- ALTER TABLE `tool_versions` ADD CONSTRAINT `tool_versions_tool_id_foreign` FOREIGN KEY (`tool_id`) REFERENCES `tools` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `tool_versions_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL; 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 */;