ptc

-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Oct 08, 2025 at 12:36 AM -- Server version: 10.3.39-MariaDB -- PHP Version: 8.1.31 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: `freezeroco_v2` -- -- -------------------------------------------------------- -- -- Table structure for table `banned_address` -- CREATE TABLE `banned_address` ( `id` int(32) UNSIGNED NOT NULL, `address` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `banned_ip` -- CREATE TABLE `banned_ip` ( `id` int(32) UNSIGNED NOT NULL, `ip_address` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `bonus_history` -- CREATE TABLE `bonus_history` ( `id` int(32) UNSIGNED NOT NULL, `user_id` int(32) UNSIGNED NOT NULL, `bonus_id` int(32) UNSIGNED NOT NULL, `bonus_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `referralearn` -- CREATE TABLE `referralearn` ( `id` int(32) UNSIGNED NOT NULL, `userid` int(32) NOT NULL, `amount` decimal(10,8) NOT NULL, `timestamp` int(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(32) UNSIGNED NOT NULL, `name` varchar(50) NOT NULL, `value` varchar(400) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `name`, `value`) VALUES (6, 'vpn_shield', 'no'), (8, 'reverse_proxy', 'no'), (9, 'iphub_api_key', ''), (13, 'faucet_currency', 'Zerocoin'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` int(32) UNSIGNED NOT NULL, `userid` int(32) NOT NULL, `type` varchar(50) NOT NULL, `amount` decimal(10,8) NOT NULL, `timestamp` int(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(32) UNSIGNED NOT NULL, `address` varchar(75) NOT NULL, `ip_address` varchar(50) NOT NULL, `balance` decimal(10,8) NOT NULL DEFAULT 0.00000000, `tokens` int(32) NOT NULL DEFAULT 0, `total_earn` decimal(10,8) NOT NULL, `ptc_earn` decimal(10,8) NOT NULL DEFAULT 0.00000000, `payoutstime` tinyint(4) NOT NULL DEFAULT 0, `joined` int(32) NOT NULL, `referringsite` text NOT NULL, `level` smallint(3) DEFAULT 0, `xp` mediumint(10) DEFAULT 0, `last_activity` int(32) NOT NULL, `referred_by` int(32) NOT NULL, `last_claim` int(32) NOT NULL, `claim_cryptokey` varchar(75) NOT NULL, `bot` tinyint(4) NOT NULL DEFAULT 0, `nextcap` tinyint(4) NOT NULL DEFAULT 0, `cap_appear` tinyint(4) NOT NULL DEFAULT 0, `cap_tappear` mediumint(9) NOT NULL DEFAULT 0, `nextmcap` tinyint(4) NOT NULL DEFAULT 2, `captcha` text NOT NULL, `last_autoclaim` int(32) NOT NULL, `claims_total` int(32) NOT NULL DEFAULT 0, `claims_today` mediumint(10) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `withdraw_history` -- CREATE TABLE `withdraw_history` ( `id` int(32) UNSIGNED NOT NULL, `userid` int(32) NOT NULL, `address` varchar(100) NOT NULL, `amount` decimal(10,8) NOT NULL, `txid` text NOT NULL, `timestamp` int(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `banned_address` -- ALTER TABLE `banned_address` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banned_ip` -- ALTER TABLE `banned_ip` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bonus_history` -- ALTER TABLE `bonus_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referralearn` -- ALTER TABLE `referralearn` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdraw_history` -- ALTER TABLE `withdraw_history` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `banned_address` -- ALTER TABLE `banned_address` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `banned_ip` -- ALTER TABLE `banned_ip` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bonus_history` -- ALTER TABLE `bonus_history` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `referralearn` -- ALTER TABLE `referralearn` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `withdraw_history` -- ALTER TABLE `withdraw_history` MODIFY `id` int(32) UNSIGNED NOT NULL AUTO_INCREMENT; 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 */;