-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 28, 2025 at 11:30 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: `receipt_jar`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `token` text NOT NULL,
  `refresh_token` text NOT NULL,
  `proxy` varchar(255) NOT NULL,
  `status` enum('idle','running','paused','error','stop','stopped','Disable','Enable') DEFAULT 'idle',
  `last_updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `total_points` int(11) DEFAULT 0,
  `disabled` tinyint(1) DEFAULT 0,
  `images_uploaded` int(11) DEFAULT 0,
  `images_rejected` int(11) DEFAULT 0,
  `last_run_time` datetime DEFAULT NULL,
  `run_duration` int(11) DEFAULT NULL,
  `weekly_points` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `name`, `email`, `token`, `refresh_token`, `proxy`, `status`, `last_updated`, `total_points`, `disabled`, `images_uploaded`, `images_rejected`, `last_run_time`, `run_duration`, `weekly_points`) VALUES
(1, 'Fet9-recjar99', 'brianrsierra@gmail.com', 'eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IjJxYUN5ZE5IeHMifQ.eyJwZXJtaXNzaW9ucyI6eyJhY2NvdW50IjpbInVzZXIucmVmcmVzaF90b2tlbiJdLCJyZWNlaXB0IjpbInByb2R1Y3Quc2VhcmNoX2JhcmNvZGUiXX0sInVzZXJuYW1lIjoiYnJpYW5yc2llcnJhQGdtYWlsLmNvbSIsImZpcnN0TmFtZSI6ImJyaWFuIiwibGFzdE5hbWUiOiJzaWVycmEiLCJ1bmlxdWVJZCI6IjYyNTllNzExLTM0YzgtNDQ1OS1hYTkxLWEwMTFmYTM2ZjJmYSIsImNvdW50cnlDb2RlIjoiVVMiLCJ1c2VyQ3JlYXRlZERhdGUiOiIyMDI0LTExLTE1IiwidXNlckNyZWF0ZWRUaW1lIjoiMDE6MDk6NTIiLCJhcHBWZXJzaW9uIjoiOS43LjI3IiwidXNlckxvY2FsZSI6ImVuLVVTIiwiaWF0IjoxNzQwNjg4NzYxLCJleHAiOjE3NDA3NzUxNjEsImlzcyI6ImFjY291bnQtc2VydmljZSJ9.jhc7PK2AfYUZqcV1_iXLXPqlcDPhFNBIbPDGBMgd4ZnjR514vFwQ3YPaSfvfNqn_dghpXCD1ul4Yhy7NBJdh1ns4dbFyN59jCjdSRxNVhXTlgDAWcnZEziISgBmCDc1mBzhveQkv5Q0hKoXuFUkudzBo2u5yZi7Xw8xoyL4OMO8NdukNGfqkaRqQWwQ8bJF-PT5Va_Z12j9BwAsVlZTe6leaho5G6S7HQM-Kd2k7P1NZGLhk0LjofujEDPk_3mRao47CuIBfA8wjU5tTyxnbyyOr0cOFf_PAXsWDfFsWvTqZR5dUwHE1nDgjcuOspMw7NUTpGncNI6gZRGtIuerY5dvkbB8J5fe3QXFDk2McxenO7KpcJQNW5UsuuNNFDbk9SIO4l3yR8PLKZsMtSohZHBGm0fIuA53Emwvj17HqoDFphxMWDoXBahQ_ZhL6PL6NY_S1OZjGKUKKmOzoxJUpI0epHkGuGiFtveA1c9AIwUHONDv7TL1S-dYjnDJ8JBJOJ6Ab2BA9MZqorJ3eICgJUI2taOtUUcR2RVWyV5dd9JBBhq3Ru81NvoH0hHizgJuCcQ_qhO5EgV7ksBmJtyxXNpnUsKJVTGKGEd7nxcmvZX3F4xME5kJ9rei_uH0d52xUJEQrxO3F_S-bwCjgdIklgp6C9hAd-xaVxyqhbqEAUYg', 'eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IjJxYUN5ZE5IeHMifQ.eyJwZXJtaXNzaW9ucyI6e30sInVzZXJuYW1lIjoiYnJpYW5yc2llcnJhQGdtYWlsLmNvbSIsImZpcnN0TmFtZSI6ImJyaWFuIiwibGFzdE5hbWUiOiJzaWVycmEiLCJ1bmlxdWVJZCI6IjYyNTllNzExLTM0YzgtNDQ1OS1hYTkxLWEwMTFmYTM2ZjJmYSIsImNvdW50cnlDb2RlIjoiVVMiLCJ1c2VyQ3JlYXRlZERhdGUiOiIyMDI0LTExLTE1IiwidXNlckNyZWF0ZWRUaW1lIjoiMDE6MDk6NTIiLCJhcHBWZXJzaW9uIjoiOS43LjI3IiwidXNlckxvY2FsZSI6ImVuLVVTIiwiaWF0IjoxNzQwNjg4NzYxLCJleHAiOjE3NDg0NjQ3NjEsImlzcyI6ImFjY291bnQtc2VydmljZSJ9.TKltY1L4N4Ywp_rIqfdS0mj1YXTJkBDDU2Jt4nF0O0f5By8S6_63CTm2cAXpdhMuVlxlX9eD1lfsl1c0kgDsDojBrforvt77nUQaOgyMSAp_4YGq9VGKnkTSnYOCKmCRzDWDGf3EKn9HUYNM_KQzTK__zB_ob2EFE5AYGRYoNwa2jF1JFCCON8vNMJM-QBwkXRsIGU9obe99nxu1l8CBqMWIKeZPz7kQtyKGFme57Ep6l1RuyL-TFC2R-S8-fG6BsevcH1-GPbaCyxQGpSmO0Xis6DXXaLVoG-P7XHx6ovobEwYEzD9DzsJAoZHrP3UQX9Uf0Av6pST9CfdMTvxOorAF2Gpn1rHDc3ak1SSvtTZv-jrr-KaZw7Eptvs55QNi9eATPI5T9FmQx0b1d4nv_Wldgz3z3gPB399SXY7NPPAe0tthohERxDIZuLf7GrguUDowo5t_vBSNseWu8miy-lIpjsRKD9WtsfXT2cC7niTP42wBnYKgpRFPfp_cUT2ObgfiFN_RU916WndWELNqrjtCPhtGW6G-c1eA_mpyHI5Fqiqu_ukwcRsjG28Dz7tQzhvWVzNEikDWaAPHqnDRoQqXb3MQaH0hsq_6rJKT0_V4K7Ev1-kfFOW3XPKBJ-bOdNozMifyQD21o-qDajoF6DtuA7K2UWjvPXZQwFFcPhc', 'http://gfihpruh:onpynd1ceprk@23.94.138.75:6349', 'stopped', '2025-02-28 17:33:56', 2486, 0, 2, 0, '2025-02-28 06:50:43', NULL, 0),
(2, 'yasssssssss', 'test@example.com', 'sample_token', 'sample_refresh_token', 'http://user:pass@proxy.com:8080', 'error', '2025-02-28 22:19:06', 0, 1, 0, 0, NULL, NULL, 0);

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `log_message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `account_id`, `log_message`, `created_at`) VALUES
(1, 1, 'Starting batch upload...', '2025-02-28 11:02:35'),
(2, 1, 'Checking weekly limit before uploading...', '2025-02-28 11:02:35'),
(3, 1, 'Uploading image: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\COMPLETE-ZjY3ZjJlMi5qcGVn.jpg', '2025-02-28 11:02:37'),
(4, 1, 'Error uploading image: Request failed with status code 407', '2025-02-28 11:02:38'),
(5, 1, 'Error in batch upload: Request failed with status code 407', '2025-02-28 11:02:38'),
(6, 1, 'Starting batch upload...', '2025-02-28 11:05:50'),
(7, 1, 'Checking weekly limit before uploading...', '2025-02-28 11:05:50'),
(8, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 11:05:53'),
(9, 1, 'Checking and deleting rejected receipts...', '2025-02-28 11:05:53'),
(10, 1, 'No more rejected receipts left.', '2025-02-28 11:05:55'),
(11, 1, 'Finished processing rejected receipts.', '2025-02-28 11:05:55'),
(12, 1, 'Fetching account info...', '2025-02-28 11:05:56'),
(13, 1, 'Account Total Points: 2486', '2025-02-28 11:05:57'),
(48, 1, 'Starting batch upload...', '2025-02-28 11:47:26'),
(49, 1, 'Checking weekly limit before uploading...', '2025-02-28 11:47:26'),
(50, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 11:47:29'),
(51, 1, 'Checking and deleting rejected receipts...', '2025-02-28 11:47:29'),
(52, 1, 'No more rejected receipts left.', '2025-02-28 11:47:32'),
(53, 1, 'Finished processing rejected receipts.', '2025-02-28 11:47:32'),
(54, 1, 'Fetching account info...', '2025-02-28 11:47:33'),
(55, 1, 'Account Total Points: 2486', '2025-02-28 11:47:35'),
(56, 1, 'Starting batch upload...', '2025-02-28 11:49:34'),
(57, 1, 'Checking weekly limit before uploading...', '2025-02-28 11:49:34'),
(58, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 11:49:37'),
(59, 1, 'Checking and deleting rejected receipts...', '2025-02-28 11:49:37'),
(60, 1, 'No more rejected receipts left.', '2025-02-28 11:49:39'),
(61, 1, 'Finished processing rejected receipts.', '2025-02-28 11:49:39'),
(62, 1, 'Fetching account info...', '2025-02-28 11:49:40'),
(63, 1, 'Account Total Points: 2486', '2025-02-28 11:49:42'),
(64, 1, 'Starting batch upload...', '2025-02-28 11:53:14'),
(65, 1, 'Checking weekly limit before uploading...', '2025-02-28 11:53:14'),
(66, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 11:53:17'),
(67, 1, 'Checking and deleting rejected receipts...', '2025-02-28 11:53:17'),
(68, 1, 'No more rejected receipts left.', '2025-02-28 11:53:19'),
(69, 1, 'Finished processing rejected receipts.', '2025-02-28 11:53:19'),
(70, 1, 'Fetching account info...', '2025-02-28 11:53:20'),
(71, 1, 'Account Total Points: 2486', '2025-02-28 11:53:21'),
(72, 1, 'Starting batch upload...', '2025-02-28 12:10:21'),
(73, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:10:21'),
(74, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:10:25'),
(75, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:10:25'),
(76, 1, 'No more rejected receipts left.', '2025-02-28 12:10:31'),
(77, 1, 'Finished processing rejected receipts.', '2025-02-28 12:10:31'),
(78, 1, 'Fetching account info...', '2025-02-28 12:10:31'),
(79, 1, 'Account Total Points: 2486', '2025-02-28 12:10:33'),
(80, 1, 'Starting batch upload...', '2025-02-28 12:16:46'),
(81, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:16:46'),
(82, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:16:50'),
(83, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:16:50'),
(84, 1, 'No more rejected receipts left.', '2025-02-28 12:16:51'),
(85, 1, 'Finished processing rejected receipts.', '2025-02-28 12:16:51'),
(86, 1, 'Fetching account info...', '2025-02-28 12:16:52'),
(87, 1, 'Account Total Points: 2486', '2025-02-28 12:16:53'),
(88, 1, 'Starting batch upload...', '2025-02-28 12:17:10'),
(89, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:17:10'),
(90, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:17:14'),
(91, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:17:14'),
(92, 1, 'No more rejected receipts left.', '2025-02-28 12:17:17'),
(93, 1, 'Finished processing rejected receipts.', '2025-02-28 12:17:17'),
(94, 1, 'Fetching account info...', '2025-02-28 12:17:17'),
(95, 1, 'Account Total Points: 2486', '2025-02-28 12:17:18'),
(96, 1, 'Starting batch upload...', '2025-02-28 12:27:36'),
(97, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:27:36'),
(98, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:27:41'),
(99, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:27:41'),
(100, 1, 'No more rejected receipts left.', '2025-02-28 12:27:42'),
(101, 1, 'Finished processing rejected receipts.', '2025-02-28 12:27:42'),
(102, 1, 'Fetching account info...', '2025-02-28 12:27:43'),
(103, 1, 'Account Total Points: 2486', '2025-02-28 12:27:45'),
(104, 1, 'Starting batch upload...', '2025-02-28 12:27:52'),
(105, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:27:52'),
(106, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:27:57'),
(107, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:27:57'),
(108, 1, 'No more rejected receipts left.', '2025-02-28 12:27:59'),
(109, 1, 'Finished processing rejected receipts.', '2025-02-28 12:27:59'),
(110, 1, 'Fetching account info...', '2025-02-28 12:28:00'),
(111, 1, 'Account Total Points: 2486', '2025-02-28 12:28:01'),
(112, 1, 'Starting batch upload...', '2025-02-28 12:32:31'),
(113, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:32:31'),
(114, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:32:35'),
(115, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:32:35'),
(116, 1, 'No more rejected receipts left.', '2025-02-28 12:32:36'),
(117, 1, 'Finished processing rejected receipts.', '2025-02-28 12:32:36'),
(118, 1, 'Fetching account info...', '2025-02-28 12:32:37'),
(119, 1, 'Account Total Points: 2486', '2025-02-28 12:32:39'),
(120, 1, 'Starting batch upload...', '2025-02-28 12:33:12'),
(121, 1, 'Checking weekly limit before uploading...', '2025-02-28 12:33:12'),
(122, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 12:33:16'),
(123, 1, 'Checking and deleting rejected receipts...', '2025-02-28 12:33:16'),
(124, 1, 'No more rejected receipts left.', '2025-02-28 12:33:19'),
(125, 1, 'Finished processing rejected receipts.', '2025-02-28 12:33:19'),
(126, 1, 'Starting batch upload...', '2025-02-28 13:04:32'),
(127, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:04:32'),
(128, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:04:37'),
(129, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:04:37'),
(130, 1, 'No more rejected receipts left.', '2025-02-28 13:04:42'),
(131, 1, 'Finished processing rejected receipts.', '2025-02-28 13:04:42'),
(132, 1, 'Fetching account info...', '2025-02-28 13:04:43'),
(133, 1, 'Account Total Points: 2486', '2025-02-28 13:04:44'),
(134, 1, 'Starting batch upload...', '2025-02-28 13:07:46'),
(135, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:07:46'),
(136, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:07:52'),
(137, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:07:52'),
(138, 1, 'No more rejected receipts left.', '2025-02-28 13:07:54'),
(139, 1, 'Finished processing rejected receipts.', '2025-02-28 13:07:54'),
(140, 1, 'Fetching account info...', '2025-02-28 13:07:56'),
(141, 1, 'Account Total Points: 2486', '2025-02-28 13:07:57'),
(142, 1, 'Starting batch upload...', '2025-02-28 13:08:10'),
(143, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:08:10'),
(144, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:08:14'),
(145, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:08:14'),
(146, 1, 'No more rejected receipts left.', '2025-02-28 13:08:20'),
(147, 1, 'Finished processing rejected receipts.', '2025-02-28 13:08:20'),
(148, 1, 'Fetching account info...', '2025-02-28 13:08:22'),
(149, 1, 'Account Total Points: 2486', '2025-02-28 13:08:24'),
(150, 1, 'Starting batch upload...', '2025-02-28 13:08:27'),
(151, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:08:27'),
(152, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:08:30'),
(153, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:08:30'),
(154, 1, 'No more rejected receipts left.', '2025-02-28 13:08:37'),
(155, 1, 'Finished processing rejected receipts.', '2025-02-28 13:08:37'),
(156, 1, 'Fetching account info...', '2025-02-28 13:08:39'),
(157, 1, 'Account Total Points: 2486', '2025-02-28 13:08:41'),
(158, 1, 'Starting batch upload...', '2025-02-28 13:08:44'),
(159, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:08:44'),
(160, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:08:52'),
(161, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:08:52'),
(162, 1, 'No more rejected receipts left.', '2025-02-28 13:08:56'),
(163, 1, 'Finished processing rejected receipts.', '2025-02-28 13:08:56'),
(164, 1, 'Fetching account info...', '2025-02-28 13:08:58'),
(165, 1, 'Account Total Points: 2486', '2025-02-28 13:08:59'),
(166, 1, 'Starting batch upload...', '2025-02-28 13:12:20'),
(167, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:12:20'),
(168, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:12:24'),
(169, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:12:24'),
(170, 1, 'No more rejected receipts left.', '2025-02-28 13:12:26'),
(171, 1, 'Finished processing rejected receipts.', '2025-02-28 13:12:26'),
(172, 1, 'Fetching account info...', '2025-02-28 13:12:27'),
(173, 1, 'Account Total Points: 2486', '2025-02-28 13:12:28'),
(174, 1, 'Starting batch upload...', '2025-02-28 13:12:34'),
(175, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:12:34'),
(176, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:12:37'),
(177, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:12:37'),
(178, 1, 'No more rejected receipts left.', '2025-02-28 13:12:39'),
(179, 1, 'Finished processing rejected receipts.', '2025-02-28 13:12:39'),
(180, 1, 'Fetching account info...', '2025-02-28 13:12:39'),
(181, 1, 'Account Total Points: 2486', '2025-02-28 13:12:42'),
(182, 1, 'Starting batch upload...', '2025-02-28 13:12:54'),
(183, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:12:54'),
(184, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:12:57'),
(185, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:12:57'),
(186, 1, 'No more rejected receipts left.', '2025-02-28 13:12:59'),
(187, 1, 'Finished processing rejected receipts.', '2025-02-28 13:12:59'),
(188, 1, 'Fetching account info...', '2025-02-28 13:13:00'),
(189, 1, 'Account Total Points: 2486', '2025-02-28 13:13:01'),
(190, 1, 'Starting batch upload...', '2025-02-28 13:17:46'),
(191, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:17:46'),
(192, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:17:49'),
(193, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:17:49'),
(194, 1, 'No more rejected receipts left.', '2025-02-28 13:17:52'),
(195, 1, 'Finished processing rejected receipts.', '2025-02-28 13:17:52'),
(196, 1, 'Fetching account info...', '2025-02-28 13:17:52'),
(197, 1, 'Account Total Points: 2486', '2025-02-28 13:17:54'),
(198, 1, 'Starting batch upload...', '2025-02-28 13:18:46'),
(199, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:18:46'),
(200, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:18:49'),
(201, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:18:49'),
(202, 1, 'No more rejected receipts left.', '2025-02-28 13:18:51'),
(203, 1, 'Finished processing rejected receipts.', '2025-02-28 13:18:51'),
(204, 1, 'Fetching account info...', '2025-02-28 13:18:52'),
(205, 1, 'Account Total Points: 2486', '2025-02-28 13:18:53'),
(206, 1, 'Starting batch upload...', '2025-02-28 13:49:59'),
(207, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:49:59'),
(208, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:50:03'),
(209, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:50:03'),
(210, 1, 'No more rejected receipts left.', '2025-02-28 13:50:05'),
(211, 1, 'Finished processing rejected receipts.', '2025-02-28 13:50:05'),
(212, 1, 'Process aborted by user', '2025-02-28 13:50:05'),
(213, 1, 'Starting batch upload...', '2025-02-28 13:54:49'),
(214, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:54:49'),
(215, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:54:53'),
(216, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:54:53'),
(217, 1, 'No more rejected receipts left.', '2025-02-28 13:54:59'),
(218, 1, 'Finished processing rejected receipts.', '2025-02-28 13:54:59'),
(219, 1, 'Fetching account info...', '2025-02-28 13:54:59'),
(220, 1, 'Account Total Points: 2486', '2025-02-28 13:55:01'),
(221, 1, 'Starting batch upload...', '2025-02-28 13:56:14'),
(222, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:56:14'),
(223, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 13:56:19'),
(224, 1, 'Checking and deleting rejected receipts...', '2025-02-28 13:56:19'),
(225, 1, 'Process aborted by user', '2025-02-28 13:56:23'),
(226, 1, 'Starting batch upload...', '2025-02-28 13:58:31'),
(227, 1, 'Checking weekly limit before uploading...', '2025-02-28 13:58:31'),
(228, 1, 'Process aborted by user', '2025-02-28 13:58:36'),
(229, 1, 'Starting batch upload...', '2025-02-28 14:00:56'),
(230, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:00:56'),
(231, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 14:01:00'),
(232, 1, 'Checking and deleting rejected receipts...', '2025-02-28 14:01:00'),
(233, 1, 'No more rejected receipts left.', '2025-02-28 14:01:04'),
(234, 1, 'Finished processing rejected receipts.', '2025-02-28 14:01:04'),
(235, 1, 'Fetching account info...', '2025-02-28 14:01:05'),
(236, 1, 'Account Total Points: 2486', '2025-02-28 14:01:07'),
(237, 1, 'Starting batch upload...', '2025-02-28 14:08:38'),
(238, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:08:38'),
(239, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 14:08:43'),
(240, 1, 'Checking and deleting rejected receipts...', '2025-02-28 14:08:43'),
(241, 1, 'Process aborted by user', '2025-02-28 14:08:45'),
(242, 1, 'Starting batch upload...', '2025-02-28 14:11:07'),
(243, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:11:07'),
(244, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 14:11:10'),
(245, 1, 'Checking and deleting rejected receipts...', '2025-02-28 14:11:10'),
(246, 1, 'No more rejected receipts left.', '2025-02-28 14:11:15'),
(247, 1, 'Finished processing rejected receipts.', '2025-02-28 14:11:15'),
(248, 1, 'Fetching account info...', '2025-02-28 14:11:15'),
(249, 1, 'Account Total Points: 2486', '2025-02-28 14:11:17'),
(250, 1, 'Starting batch upload...', '2025-02-28 14:24:58'),
(251, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:24:58'),
(252, 1, 'Process aborted by user', '2025-02-28 14:25:02'),
(253, 1, 'Starting batch upload...', '2025-02-28 14:36:33'),
(254, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:36:33'),
(255, 1, 'Process aborted by user', '2025-02-28 14:36:38'),
(256, 1, 'Starting batch upload...', '2025-02-28 14:40:56'),
(257, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:40:56'),
(258, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 14:41:01'),
(259, 1, 'Checking and deleting rejected receipts...', '2025-02-28 14:41:01'),
(260, 1, 'No more rejected receipts left.', '2025-02-28 14:41:04'),
(261, 1, 'Finished processing rejected receipts.', '2025-02-28 14:41:04'),
(262, 1, 'Fetching account info...', '2025-02-28 14:41:05'),
(263, 1, 'Account Total Points: 2486', '2025-02-28 14:41:07'),
(264, 1, 'Starting batch upload...', '2025-02-28 14:46:01'),
(265, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:46:01'),
(266, 1, 'Process aborted by user', '2025-02-28 14:46:05'),
(267, 1, 'Starting batch upload...', '2025-02-28 14:49:31'),
(268, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:49:31'),
(269, 1, 'Process aborted by user', '2025-02-28 14:49:35'),
(270, 1, 'Starting batch upload...', '2025-02-28 14:49:57'),
(271, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:49:57'),
(272, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 14:50:01'),
(273, 1, 'Checking and deleting rejected receipts...', '2025-02-28 14:50:01'),
(274, 1, 'No more rejected receipts left.', '2025-02-28 14:50:05'),
(275, 1, 'Finished processing rejected receipts.', '2025-02-28 14:50:05'),
(276, 1, 'Fetching account info...', '2025-02-28 14:50:06'),
(277, 1, 'Account Total Points: 2486', '2025-02-28 14:50:08'),
(278, 1, 'Starting batch upload...', '2025-02-28 14:50:30'),
(279, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:50:30'),
(280, 1, 'Weekly limit reached (165 points). Skipping upload.', '2025-02-28 14:50:37'),
(281, 1, 'Checking and deleting rejected receipts...', '2025-02-28 14:50:37'),
(282, 1, 'No more rejected receipts left.', '2025-02-28 14:50:41'),
(283, 1, 'Finished processing rejected receipts.', '2025-02-28 14:50:41'),
(284, 1, 'Fetching account info...', '2025-02-28 14:50:41'),
(285, 1, 'Account Total Points: 2486', '2025-02-28 14:50:43'),
(286, 1, 'Starting batch upload...', '2025-02-28 14:50:57'),
(287, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:50:57'),
(288, 1, 'Process aborted by user', '2025-02-28 14:51:02'),
(289, 1, 'Starting batch upload...', '2025-02-28 14:51:04'),
(290, 1, 'Checking weekly limit before uploading...', '2025-02-28 14:51:04'),
(291, 1, 'Process aborted by user', '2025-02-28 14:51:08'),
(292, 1, 'Proxy http://gfihpruh:onpynd1ceprk@154.36.110.199:6853 assigned to account 1', '2025-02-28 17:26:46'),
(293, 1, 'Proxy http://gfihpruh:onpynd1ceprk@23.94.138.75:6349 assigned to account 1', '2025-02-28 17:27:23'),
(294, 1, 'Starting batch upload...', '2025-02-28 17:30:32'),
(295, 1, 'Checking weekly limit before uploading...', '2025-02-28 17:30:32'),
(296, 1, 'Process aborted by user', '2025-02-28 17:30:37'),
(297, 1, 'Starting batch upload...', '2025-02-28 17:30:48'),
(298, 1, 'Checking weekly limit before uploading...', '2025-02-28 17:30:48'),
(299, 1, 'Uploading image: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\COMPLETE-ZjY3ZjJlMi5qcGVn.jpg', '2025-02-28 17:30:55'),
(300, 1, 'Sending receipt data...', '2025-02-28 17:31:00'),
(301, 1, 'Receipt submitted successfully', '2025-02-28 17:31:01'),
(302, 1, 'Receipt uploaded successfully: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\COMPLETE-ZjY3ZjJlMi5qcGVn.jpg', '2025-02-28 17:31:01'),
(303, 1, 'Starting batch upload...', '2025-02-28 17:33:48'),
(304, 1, 'Checking weekly limit before uploading...', '2025-02-28 17:33:48'),
(305, 1, 'Uploading image: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\COMPLETE-ZmJiZmMwYi5qcGVn.jpg', '2025-02-28 17:33:51'),
(306, 1, 'Sending receipt data...', '2025-02-28 17:33:54'),
(307, 1, 'Receipt submitted successfully', '2025-02-28 17:33:55'),
(308, 1, 'Receipt uploaded successfully: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\COMPLETE-ZmJiZmMwYi5qcGVn.jpg', '2025-02-28 17:33:55'),
(309, 2, 'Starting batch upload...', '2025-02-28 21:19:34'),
(310, 2, 'Checking weekly limit before uploading...', '2025-02-28 21:19:34'),
(311, 2, 'Uploading image: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\FULL_PROCESS-NmQxYWE2MC5qcGVn.jpg', '2025-02-28 21:19:35'),
(312, 2, 'Error uploading image: Request failed with status code 500', '2025-02-28 21:19:36'),
(313, 2, 'Error in batch upload: Request failed with status code 500', '2025-02-28 21:19:36'),
(314, 2, 'Starting batch upload...', '2025-02-28 21:29:52'),
(315, 2, 'Checking weekly limit before uploading...', '2025-02-28 21:29:52'),
(316, 2, 'Uploading image: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\FULL_PROCESS-NmQxYWE2MC5qcGVn.jpg', '2025-02-28 21:29:53'),
(317, 2, 'Error uploading image: Request failed with status code 500', '2025-02-28 21:29:53'),
(318, 2, 'Error in batch upload: Request failed with status code 500', '2025-02-28 21:29:53'),
(319, 2, 'Starting batch upload...', '2025-02-28 21:37:27'),
(320, 2, 'Checking weekly limit before uploading...', '2025-02-28 21:37:27'),
(321, 2, 'Uploading image: C:\\Users\\Administrator\\Desktop\\receip-script\\image\\FULL_PROCESS-NmQxYWE2MC5qcGVn.jpg', '2025-02-28 21:37:27'),
(322, 2, 'Error uploading image: Request failed with status code 500', '2025-02-28 21:37:28'),
(323, 2, 'Error in batch upload: Request failed with status code 500', '2025-02-28 21:37:28');

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

--
-- Table structure for table `proxies`
--

CREATE TABLE `proxies` (
  `id` int(11) NOT NULL,
  `proxy` varchar(255) NOT NULL,
  `status` enum('unused','active','failed') DEFAULT 'unused',
  `last_used` timestamp NULL DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `retry_count` int(11) DEFAULT 0,
  `country` varchar(100) DEFAULT NULL,
  `check_status` enum('alive','dead') DEFAULT NULL,
  `last_checked` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `proxies`
--

INSERT INTO `proxies` (`id`, `proxy`, `status`, `last_used`, `assigned_to`, `retry_count`, `country`, `check_status`, `last_checked`) VALUES
(1, 'http://gfihpruh:onpynd1ceprk@23.94.138.75:6349', 'active', '2025-02-26 00:15:32', 1, 0, 'US', 'alive', '2025-02-28 22:30:14'),
(2, 'http://gfihpruh:onpynd1ceprk@154.36.110.199:6853', 'unused', '2025-02-26 00:17:13', NULL, 0, 'United States', 'alive', '2025-02-28 17:10:19'),
(6, 'http://nrqoodfm:pmymq2fepaw1@45.251.61.35:6753', 'unused', NULL, NULL, 0, 'LT', 'alive', '2025-02-28 17:26:20'),
(7, 'http://nrqoodfm:pmymq2fepaw1@193.168.223.238:6205', 'unused', NULL, NULL, 0, NULL, 'dead', '2025-02-28 21:29:00'),
(8, 'http://nrqoodfm:pmymq2fepaw1@171.22.249.180:5760', 'unused', NULL, NULL, 0, 'FR', 'alive', '2025-02-28 21:50:25');

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

--
-- Table structure for table `proxy_history`
--

CREATE TABLE `proxy_history` (
  `id` int(11) NOT NULL,
  `proxy` varchar(255) NOT NULL,
  `account_id` int(11) NOT NULL,
  `used_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `proxy_history`
--

INSERT INTO `proxy_history` (`id`, `proxy`, `account_id`, `used_at`) VALUES
(1, 'http://gfihpruh:onpynd1ceprk@154.36.110.199:6853', 1, '2025-02-28 17:26:46'),
(2, 'http://gfihpruh:onpynd1ceprk@23.94.138.75:6349', 1, '2025-02-28 17:27:23');

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

--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `image_url` text NOT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `points` int(11) DEFAULT 0,
  `uploaded_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Indexes for table `proxies`
--
ALTER TABLE `proxies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `proxy` (`proxy`);

--
-- Indexes for table `proxy_history`
--
ALTER TABLE `proxy_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Indexes for table `receipts`
--
ALTER TABLE `receipts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=324;

--
-- AUTO_INCREMENT for table `proxies`
--
ALTER TABLE `proxies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `proxy_history`
--
ALTER TABLE `proxy_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `receipts`
--
ALTER TABLE `receipts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `logs`
--
ALTER TABLE `logs`
  ADD CONSTRAINT `logs_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `proxy_history`
--
ALTER TABLE `proxy_history`
  ADD CONSTRAINT `proxy_history_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `receipts`
--
ALTER TABLE `receipts`
  ADD CONSTRAINT `receipts_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;
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 */;
