-- https://www.phpmyadmin.net/
--


--
-- Database: `Abubkar_24_sep_accounts`
--

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

--
-- Table structure for table `accountant_client`
--

CREATE TABLE `accountant_client` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `accountant_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT 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 `accountant_client`
--

INSERT INTO `accountant_client` (`id`, `client_id`, `accountant_id`, `status`, `created_at`, `updated_at`) VALUES
(8, 30, 22, 'active', '2024-10-31 06:33:35', '2024-10-31 06:33:35'),
(11, 35, 22, 'active', '2024-11-22 06:38:43', '2024-11-22 06:38:43'),
(12, 36, 22, 'active', '2024-11-22 07:56:40', '2024-11-22 07:56:40'),
(13, 37, 22, 'active', '2024-12-02 01:49:57', '2024-12-02 01:49:57'),
(15, 31, 22, 'active', '2024-12-02 03:46:14', '2024-12-02 04:01:09');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('Expense','Income') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `client_plans`
--

CREATE TABLE `client_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `paypal_subscription_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT 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 `client_plans`
--

INSERT INTO `client_plans` (`id`, `client_id`, `plan_id`, `paypal_subscription_id`, `created_at`, `updated_at`) VALUES
(1, 30, 15, '', '2024-10-31 23:47:07', '2024-10-31 23:47:07'),
(2, 30, 16, 'I-PYYT6SKAB8B4', '2024-11-01 00:00:27', '2024-11-01 00:00:27'),
(3, 30, 15, 'I-EWMUVUA833KY', '2024-12-02 04:03:22', '2024-12-02 04:03:22'),
(4, 30, 15, 'I-AYXH4RBDEUUF', '2024-12-02 04:04:18', '2024-12-02 04:04:18');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount_amount` int(11) NOT NULL,
  `discount_type` enum('fixed','percent') COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration_date` date 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 `coupons`
--

INSERT INTO `coupons` (`id`, `code`, `discount_amount`, `discount_type`, `expiration_date`, `created_at`, `updated_at`) VALUES
(1, 'test1', 50, 'fixed', '2024-10-31', '2024-10-04 06:48:51', '2024-10-04 06:48:51');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `uploaded_by` bigint(20) UNSIGNED DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` enum('Income','Expense','Deduction','Credit','Tax Return','Others') COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date 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 `files`
--

INSERT INTO `files` (`id`, `client_id`, `uploaded_by`, `file_name`, `category`, `comments`, `date`, `created_at`, `updated_at`) VALUES
(2, 31, 31, 'test', 'Income', 'Test', '2023-11-14', '2024-11-14 00:11:51', '2024-11-14 00:11:51'),
(5, 31, 31, 'Blaze Serrano', 'Deduction', NULL, '2024-03-17', '2024-11-22 08:12:36', '2024-12-01 02:52:00'),
(6, 31, 31, 'tet', 'Income', NULL, '2024-12-01', '2024-12-01 02:51:47', '2024-12-01 02:51:47'),
(7, 31, 31, 'Uma Ballard', 'Deduction', 'Ut dolorem labore ma', '2024-12-20', '2024-12-09 00:33:28', '2024-12-09 00:33:28');

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

--
-- Table structure for table `file_uploads`
--

CREATE TABLE `file_uploads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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 `file_uploads`
--

INSERT INTO `file_uploads` (`id`, `file_id`, `file_path`, `created_at`, `updated_at`) VALUES
(2, 2, '1731561111465196.png', '2024-11-14 00:11:51', '2024-11-14 00:11:51'),
(3, 7, 'uploads/1733722408426818.png', '2024-12-09 00:33:32', '2024-12-09 00:33:32'),
(4, 7, 'uploads/1733722412421153.png', '2024-12-09 00:33:40', '2024-12-09 00:33:40');

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

--
-- Table structure for table `f_a_q_s`
--

CREATE TABLE `f_a_q_s` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `question_fr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer_fr` text COLLATE utf8mb4_unicode_ci NOT 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 `f_a_q_s`
--

INSERT INTO `f_a_q_s` (`id`, `question`, `answer`, `question_fr`, `answer_fr`, `created_at`, `updated_at`) VALUES
(3, 'What is Stora Tax?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Stora Tax is a cloud-based platform designed to help individuals and businesses securely share tax documents with tax preparers and financial professionals. The platform is built with end-to-end encryption to ensure that sensitive tax data is protected from unauthorized access.<br>We do not offer tax filing or advisory services; instead, we provide a safe, easy-to-use platform to store and share your tax documents.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Qu\'est-ce que Stora Tax?', 'Stora Tax est une plateforme basée sur le cloud conçue pour aider les particuliers et les entreprises à partager en toute sécurité des documents fiscaux avec des préparateurs d\'impôts et des professionnels financiers. La plateforme est dotée d\'un chiffrement de bout en bout pour garantir que les données fiscales sensibles sont protégées contre tout accès non autorisé. Nous n\'offrons pas de services de déclaration ou de conseil fiscal ; nous fournissons plutôt une plateforme sécurisée et facile à utiliser pour stocker et partager vos documents fiscaux.', '2024-09-05 06:57:47', '2024-10-29 03:57:19'),
(4, 'How is Stora Tax different from using email or messaging apps?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Unlike traditional methods such as email or messaging apps, Stora Tax ensures that your documents are shared through a secure, encrypted platform. Emails and messaging apps can often be vulnerable to hacks, putting your sensitive financial information at risk.<br>With end-to-end encryption, Stora Tax protects your data from start to finish, guaranteeing only authorized parties can access your documents.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'En quoi Stora Tax est-il différent de l\'utilisation de l\'e-mail ou des applications de messagerie ?', 'Contrairement aux méthodes traditionnelles telles que les e-mails ou les applications de messagerie, Stora Tax garantit que vos documents sont partagés via une plateforme sécurisée et chiffrée. Les e-mails et les applications de messagerie sont souvent vulnérables aux piratages, ce qui met en danger vos informations financières sensibles. Avec le chiffrement de bout en bout, Stora Tax protège vos données de bout en bout, garantissant que seules les parties autorisées peuvent accéder à vos documents.', '2024-09-05 06:58:04', '2024-10-29 03:57:50'),
(5, 'How does Stora Tax ensure the security of my documents?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Security is our top priority. Stora Tax uses end-to-end encryption, meaning your documents are encrypted before they are uploaded and remain encrypted during storage and sharing. Only you and the people you authorize (such as your tax preparer) can access the files.<br>Our platform also includes two-factor authentication (2FA) to provide an additional layer of security for your account. We use secure cloud-based storage to ensure your documents are always safe from unauthorized access.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Comment Stora Tax garantit-il la sécurité de mes documents ?', 'La sécurité est notre priorité absolue. Stora Tax utilise un chiffrement de bout en bout, ce qui signifie que vos documents sont chiffrés avant d\'être téléchargés et restent chiffrés pendant le stockage et le partage. Seuls vous et les personnes que vous autorisez (comme votre préparateur d\'impôts) pouvez accéder aux fichiers. Notre plateforme inclut également l\'authentification à deux facteurs (2FA) pour fournir une couche de sécurité supplémentaire pour votre compte. Nous utilisons un stockage sécurisé basé sur le cloud pour garantir que vos documents sont toujours à l\'abri des accès non autorisés.', '2024-09-05 06:58:20', '2024-10-29 03:58:11'),
(6, 'Can my tax preparer request documents through Stora Tax?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Yes, your tax preparer or financial professional can request missing or additional documents directly through the Stora Tax platform. You’ll receive a notification and can upload the requested documents with just a few clicks, making it easy to stay organized and avoid any delays during tax season.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Mon préparateur d\'impôts peut-il demander des documents via Stora Tax ?', 'Oui, votre préparateur d\'impôts ou professionnel financier peut demander directement des documents manquants ou supplémentaires via la plateforme Stora Tax. Vous recevrez une notification et pourrez télécharger les documents demandés en quelques clics, facilitant ainsi l\'organisation et évitant tout retard pendant la saison des impôts.', '2024-09-12 21:53:23', '2024-10-29 03:58:29'),
(7, 'What types of files can I upload to Stora Tax?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Stora Tax supports a wide variety of common document formats, including PDF, Word, Excel, and image files (e.g., JPEG, PNG). This flexibility ensures you can upload and share all types of tax-related documents securely.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Quels types de fichiers puis-je télécharger sur Stora Tax ?', 'Stora Tax prend en charge une grande variété de formats de documents courants, notamment PDF, Word, Excel et des fichiers image (par exemple, JPEG, PNG). Cette flexibilité vous permet de télécharger et partager en toute sécurité tous les types de documents fiscaux.', '2024-09-12 21:53:41', '2024-10-29 03:58:45'),
(8, 'Is there a limit to the number of documents I can upload?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Our platform offers flexible storage options, allowing you to securely upload and manage your tax documents without any hassle. Depending on your subscription plan, storage limits may vary. Please refer to our pricing page for detailed information on storage options.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Y a-t-il une limite au nombre de documents que je peux télécharger ?', 'Notre plateforme offre des options de stockage flexibles, vous permettant de télécharger et de gérer vos documents fiscaux en toute sécurité. Selon votre plan d\'abonnement, les limites de stockage peuvent varier. Veuillez consulter notre page de tarification pour des informations détaillées sur les options de stockage.', '2024-09-12 21:53:57', '2024-09-12 21:53:57'),
(9, 'How do I share documents with my tax preparer?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Sharing documents with your tax preparer is simple. Once your documents are uploaded, you can share them securely by selecting your tax preparer from your contact list. They will receive a notification and access to the specific files you\'ve chosen to share. You have full control over who can view and download your documents.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Comment partager des documents avec mon préparateur d\'impôts ?', 'Partager des documents avec votre préparateur d\'impôts est simple. Une fois vos documents téléchargés, vous pouvez les partager en toute sécurité en sélectionnant votre préparateur d\'impôts dans votre liste de contacts. Il recevra une notification et l\'accès aux fichiers spécifiques que vous avez choisi de partager. Vous avez un contrôle total sur qui peut voir et télécharger vos documents.', '2024-09-12 21:54:12', '2024-09-12 21:54:12'),
(10, 'Can I access my tax documents from anywhere?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Yes! Stora Tax is a cloud-based platform, which means you can access and manage your documents from anywhere with an internet connection. Whether you\'re at home, in the office, or on the go, your documents are always available.<br>Additionally, we offer two-factor authentication (2FA) for enhanced security, ensuring only you can access your account and documents, no matter where you log in from.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Puis-je accéder à mes documents fiscaux de n\'importe où ?', 'Oui ! Stora Tax est une plateforme basée sur le cloud, ce qui signifie que vous pouvez accéder à vos documents et les gérer de n\'importe où, tant que vous avez une connexion Internet. Que vous soyez chez vous, au bureau ou en déplacement, vos documents sont toujours disponibles. De plus, nous offrons une authentification à deux facteurs (2FA) pour renforcer la sécurité, garantissant que vous seul pouvez accéder à votre compte et à vos documents, où que vous vous connectiez.', '2024-09-12 21:54:27', '2024-10-29 03:59:22'),
(11, 'Can I store documents throughout the year or only during tax season?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Yes, you can store your tax documents as you go throughout the year. This means no more last-minute stress trying to find documents during tax season—your records will be safely stored and organized for when you need them.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Puis-je stocker des documents tout au long de l\'année ou seulement pendant la saison des impôts ?', 'Oui, vous pouvez stocker vos documents fiscaux au fur et à mesure tout au long de l\'année. Cela signifie qu\'il n\'y a plus de stress de dernière minute pour retrouver vos documents pendant la saison des impôts—vos dossiers seront en sécurité et organisés pour le moment où vous en aurez besoin.', '2024-09-12 21:54:48', '2024-09-12 21:54:48'),
(12, 'Does Stora Tax provide tools for other tax needs?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">We are actively developing tools to address additional tax needs, such as managing rental income and other specialized tax requirements. These tools will make it even easier to organize your tax data for different income streams.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Stora Tax propose-t-il des outils pour d\'autres besoins fiscaux ?', 'Nous développons activement des outils pour répondre à des besoins fiscaux supplémentaires, tels que la gestion des revenus locatifs et d\'autres besoins fiscaux spécialisés. Ces outils rendront encore plus facile l\'organisation de vos données fiscales pour différents types de revenus.', '2024-09-12 21:55:03', '2024-10-29 03:59:35'),
(13, 'Can I archive my tax returns and previous year’s data?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Yes, Stora Tax allows you to securely store and archive copies of your tax returns, including data from previous years. This ensures that you always have easy access to your past filings, helping you stay organized and be ready for any income tax audits from the government.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Puis-je archiver mes déclarations de revenus et les données des années précédentes ?', 'Oui, Stora Tax vous permet de stocker et d\'archiver en toute sécurité des copies de vos déclarations de revenus, y compris les données des années précédentes. Cela vous permet d\'accéder facilement à vos déclarations passées, vous aidant ainsi à rester organisé et prêt pour tout audit fiscal du gouvernement.', '2024-09-12 21:55:18', '2024-10-29 04:00:11'),
(14, 'Does Stora Tax provide tax filing services?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">No, Stora Tax does not provide tax filing or advisory services. Our platform focuses solely on helping you securely store and share tax documents with your tax preparer or financial professionals. We aim to make the document management process as seamless as possible.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Stora Tax propose-t-il des services de déclaration fiscale ?', 'Non, Stora Tax ne fournit pas de services de déclaration ou de conseil fiscal. Notre plateforme se concentre uniquement sur le stockage et le partage sécurisé de vos documents fiscaux avec votre préparateur d\'impôts ou des professionnels financiers. Nous visons à rendre le processus de gestion des documents aussi fluide que possible.', '2024-09-12 21:55:34', '2024-10-29 04:00:25'),
(15, 'How do I cancel my account?', '<ol start=\"1\" type=\"1\" style=\"margin-bottom: 0cm; color: rgb(0, 0, 0); font-size: medium; margin-top: 0cm;\"><li class=\"MsoNormal\" style=\"margin: 12pt 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif;\"><span lang=\"EN\">If you wish to cancel your account, you can do so by navigating to the account settings section in your dashboard and selecting the option to delete your account. Please note that once your account is deleted, all stored documents will be permanently removed from our platform.</span></li><li class=\"MsoNormal\" style=\"margin: 12pt 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif;\"><span lang=\"EN\"><br></span>If you have any concerns or need assistance with cancellation, feel free to contact our support team.</li></ol>', 'Comment puis-je annuler mon compte ?', 'Si vous souhaitez annuler votre compte, vous pouvez le faire en accédant à la section des paramètres de votre compte dans votre tableau de bord et en sélectionnant l\'option pour supprimer votre compte. Veuillez noter qu\'une fois votre compte supprimé, tous les documents stockés seront définitivement supprimés de notre plateforme. Si vous avez des préoccupations ou besoin d\'assistance pour l\'annulation, n\'hésitez pas à contacter notre équipe de support.', '2024-09-12 21:56:11', '2024-09-12 21:56:11'),
(16, 'How do I sign up for Stora Tax?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">You can easily sign up by visiting our registration page. After signing up, you can begin uploading, managing, and sharing your tax documents with tax preparers and financial professionals. It’s quick and easy to get started.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Comment m\'inscrire à Stora Tax ?', 'Vous pouvez facilement vous inscrire en visitant notre page d\'inscription. Après votre inscription, vous pourrez commencer à télécharger, gérer et partager vos documents fiscaux avec vos préparateurs d\'impôts et professionnels financiers. C\'est simple et rapide de démarrer.', '2024-09-12 21:56:38', '2024-10-29 04:00:37'),
(17, 'What if I need help or have further questions?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Our support team is always here to help. If you have any questions or encounter any issues while using Stora Tax, feel free to contact us through our support page, and we’ll be happy to assist you.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Que faire si j\'ai besoin d\'aide ou si j\'ai d\'autres questions ?', 'Notre équipe de support est toujours là pour vous aider. Si vous avez des questions ou rencontrez des problèmes lors de l\'utilisation de Stora Tax, n\'hésitez pas à nous contacter via notre page de support, et nous serons heureux de vous aider.', '2024-09-12 21:56:54', '2024-10-29 04:00:53'),
(18, 'Can I try Stora Tax before committing to a subscription?', '<p><span lang=\"EN\" style=\"color: rgb(0, 0, 0); font-size: 11pt; line-height: 16.8667px; font-family: Arial, sans-serif;\">Yes, we offer a free trial so you can experience the features and benefits of Stora Tax before committing to a paid subscription. During the trial, you’ll have access to the full suite of features, including secure document sharing, storage, and collaboration with tax preparers.</span><span style=\"color: rgb(0, 0, 0); font-size: medium;\"></span><br></p>', 'Puis-je essayer Stora Tax avant de souscrire à un abonnement ?', 'Oui, nous offrons un essai gratuit pour vous permettre de découvrir les fonctionnalités et les avantages de Stora Tax avant de vous engager dans un abonnement payant. Pendant l\'essai, vous aurez accès à l\'ensemble des fonctionnalités, y compris le partage sécurisé de documents, le stockage et la collaboration avec les préparateurs d\'impôts.', '2024-09-12 21:57:31', '2024-10-29 04:01:06'),
(19, '- IRS Forms, Instructions and Publications', '<p><a href=\"https://www.irs.gov/forms-instructions\" target=\"_blank\">https://www.irs.gov/forms-instructions</a><br></p>', '- Formulaires, instructions et publications IRS', '<p><a href=\"https://www.irs.gov/forms-instructions\" target=\"_blank\">https://www.irs.gov/forms-instructions</a><br></p>', '2024-09-19 01:40:42', '2024-09-19 01:40:42'),
(20, '⁠Canada Tax Slips', '<p><a href=\"https://www.canada.ca/en/revenue-agency/services/tax/individuals/topics/about-your-tax-return/tax-return/completing-a-tax-return/tax-slips.html#toc1\" target=\"_blank\">https://www.canada.ca/en/revenue-agency/services/tax/individuals/topics/about-your-tax-return/tax-return/completing-a-tax-return/tax-slips.html#toc1</a><br></p>', 'Canada Feuillets d’impôt ', '<p><a href=\"https://www.canada.ca/fr/agence-revenu/services/impot/particuliers/sujets/tout-votre-declaration-revenus/declaration-revenus/remplir-declaration-revenus/feuillets-renseignements.html\" target=\"_blank\">https://www.canada.ca/fr/agence-revenu/services/impot/particuliers/sujets/tout-votre-declaration-revenus/declaration-revenus/remplir-declaration-revenus/feuillets-renseignements.html</a><br></p>', '2024-09-19 01:42:06', '2024-09-19 01:42:06'),
(21, 'Canada deductions, credits and expenses', '<p><a href=\"https://www.canada.ca/en/revenue-agency/services/tax/individuals/topics/about-your-tax-return/tax-return/completing-a-tax-return/deductions-credits-expenses/deductions-credits-expenses.html\" target=\"_blank\">https://www.canada.ca/en/revenue-agency/services/tax/individuals/topics/about-your-tax-return/tax-return/completing-a-tax-return/deductions-credits-expenses/deductions-credits-expenses.html</a><br></p>', 'Canada déductions, crédits et dépenses', '<p><a href=\"https://www.canada.ca/fr/agence-revenu/services/impot/particuliers/sujets/tout-votre-declaration-revenus/declaration-revenus/remplir-declaration-revenus/deductions-credits-depenses/toutes-deductions-tous-credits-toutes-depenses.html\" target=\"_blank\"> https://www.canada.ca/fr/agence-revenu/services/impot/particuliers/sujets/tout-votre-declaration-revenus/declaration-revenus/remplir-declaration-revenus/deductions-credits-depenses/toutes-deductions-tous-credits-toutes-depenses.html</a><br></p>', '2024-09-19 01:42:58', '2024-11-07 05:08:23'),
(25, '⁠Quebec Tax deductions', '<p><a href=\"https://www.revenuquebec.ca/en/citizens/deductions/\" target=\"_blank\">https://www.revenuquebec.ca/en/citizens/deductions/</a><br></p>', 'Québec deductions ', '<p><a href=\"https://www.revenuquebec.ca/fr/citoyens/deductions/\" target=\"_blank\">https://www.revenuquebec.ca/fr/citoyens/deductions/</a><br></p>', '2024-09-19 01:44:25', '2024-09-19 01:44:25'),
(26, 'Quebec tax slips', '<p><a href=\"https://www.revenuquebec.ca/en/businesses/rl-slips-and-summaries/rl-slips/\" target=\"_blank\">https://www.revenuquebec.ca/en/businesses/rl-slips-and-summaries/rl-slips/</a><br></p>', 'Québec feuillet d’impôt', '<p><a href=\"https://www.revenuquebec.ca/fr/entreprises/releves-et-sommaires/liste-des-releves\" target=\"_blank\">https://www.revenuquebec.ca/fr/entreprises/releves-et-sommaires/liste-des-releves/</a><br></p>', '2024-11-28 05:20:38', '2024-11-28 05:20:38'),
(27, 'Quebec Tax credits', '<p><a href=\"https://www.revenuquebec.ca/en/citizens/tax-credits\" target=\"_blank\">https://www.revenuquebec.ca/en/citizens/tax-credits</a><br></p>', 'Québec crédits d’impôt ', '<p><a href=\"https://www.revenuquebec.ca/fr/citoyens/credits-dimpot/\" target=\"_blank\">https://www.revenuquebec.ca/fr/citoyens/credits-dimpot/</a><br></p>', '2024-11-07 05:03:19', '2024-11-07 05:03:19');

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

--
-- Table structure for table `income_types`
--

CREATE TABLE `income_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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 `income_types`
--

INSERT INTO `income_types` (`id`, `user_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 31, 'Salary', '2024-11-05 01:46:07', '2024-11-05 01:46:07'),
(2, 31, 'Test 1', '2024-11-05 01:46:37', '2024-11-05 01:48:09'),
(3, 31, 'Test 2', '2024-11-05 01:48:22', '2024-11-05 01:48:22');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"8793e7a7-5b08-404c-85fe-2b18f5a3f6a2\",\"displayName\":\"App\\\\Notifications\\\\FileUploadedNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:3;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:42:\\\"App\\\\Notifications\\\\FileUploadedNotification\\\":2:{s:11:\\\"\\u0000*\\u0000userName\\\";s:20:\\\"1728047569667754.png\\\";s:2:\\\"id\\\";s:36:\\\"2c19cd7c-fa85-4f77-9ceb-65f238e3e986\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"}}', 0, NULL, 1728047569, 1728047569),
(2, 'default', '{\"uuid\":\"8b43a9fb-f3fd-41b3-bfee-efd21c942af7\",\"displayName\":\"App\\\\Notifications\\\\FileUploadedNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:3;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:42:\\\"App\\\\Notifications\\\\FileUploadedNotification\\\":2:{s:11:\\\"\\u0000*\\u0000userName\\\";s:20:\\\"1728047569667754.png\\\";s:2:\\\"id\\\";s:36:\\\"2c19cd7c-fa85-4f77-9ceb-65f238e3e986\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1728047569, 1728047569),
(3, 'default', '{\"uuid\":\"09825eba-48ee-42e0-a503-fd33cd800865\",\"displayName\":\"App\\\\Notifications\\\\FileUploadedNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:7;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:42:\\\"App\\\\Notifications\\\\FileUploadedNotification\\\":2:{s:11:\\\"\\u0000*\\u0000userName\\\";s:20:\\\"1728047827745185.png\\\";s:2:\\\"id\\\";s:36:\\\"f466ba40-0594-40b9-a1bb-cb899e465999\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"}}', 0, NULL, 1728047827, 1728047827),
(4, 'default', '{\"uuid\":\"260e08c3-e9d3-4cfe-9fcd-47474fb7565a\",\"displayName\":\"App\\\\Notifications\\\\FileUploadedNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:7;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:42:\\\"App\\\\Notifications\\\\FileUploadedNotification\\\":2:{s:11:\\\"\\u0000*\\u0000userName\\\";s:20:\\\"1728047827745185.png\\\";s:2:\\\"id\\\";s:36:\\\"f466ba40-0594-40b9-a1bb-cb899e465999\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1728047827, 1728047827);

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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
(8, '0001_01_01_000000_create_users_table', 1),
(9, '0001_01_01_000001_create_cache_table', 1),
(10, '0001_01_01_000002_create_jobs_table', 1),
(11, '2024_09_05_094405_create_plans_table', 1),
(12, '2024_09_05_113828_create_f_a_q_s_table', 2),
(13, '2024_09_05_124958_add_plan_info_to_users_table', 3),
(14, '2024_09_06_072900_create_accountant_client_table', 4),
(15, '2024_09_06_100506_create_user_account_settings_table', 5),
(16, '2024_09_06_102110_create_categories_table', 6),
(17, '2024_09_06_111306_create_files_table', 7),
(18, '2024_09_13_031758_add_soft_deletes_to_users_table', 8),
(19, '2024_09_26_045439_add_tutorial_completed_to_users_table', 9),
(20, '2024_09_26_051018_add_two_factor_fields_to_users_table', 10),
(21, '2024_09_26_055806_add_uploaded_by_to_files_table', 11),
(24, '2024_09_26_065618_create_coupons_table', 12),
(26, '2024_10_03_112616_create_quebecs_table', 13),
(27, '2024_10_04_121442_add_coupon_id_to_users_table', 14),
(28, '2024_10_04_133120_create_notifications_table', 15),
(29, '2024_10_31_104135_add_created_by_to_users_table', 16),
(30, '2024_11_01_041329_create_client_plans_table', 17),
(32, '2024_11_05_063347_create_income_types_table', 18),
(33, '2024_11_05_065216_create_regular_entries_table', 19);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL 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 `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('2fdcb382-dcd2-4c87-a558-68a811e55cae', 'App\\Notifications\\FileUploadedNotification', 'App\\Models\\User', 22, '{\"user_name\":\"Aleem Zada\",\"message\":\"New file \\\"tet\\\" has been uploaded by Aleem Developer.\",\"uploaded_by\":31}', NULL, '2024-12-01 02:51:49', '2024-12-01 02:51:49');

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_fr` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('monthly','yearly') COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` float NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_for` enum('client','accountant') COLLATE utf8mb4_unicode_ci NOT NULL,
  `include` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paypal_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cad_paypal_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `connect` enum('no','yes') COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_of_clients` int(11) 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 `plans`
--

INSERT INTO `plans` (`id`, `name`, `name_fr`, `type`, `price`, `details`, `plan_for`, `include`, `paypal_id`, `product_id`, `cad_paypal_id`, `connect`, `no_of_clients`, `created_at`, `updated_at`) VALUES
(14, 'TAX MANAGER', 'Gestionnaire d\'impôts', 'yearly', 59.99, '24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nSHARING TAX DOCUMENTS,\r\nSTORING TAX DOCUMENTS,\r\nCUSTOMERS SUPPORT', 'client', '[\"Text Documentation\"]', 'P-0F024736CE784172NM4RVLTI', 'PROD-17M65329SM791252K', 'P-2DL41626R2798031FM4VRDRI', 'yes', 0, '2024-10-31 05:02:48', '2024-11-06 01:50:42'),
(15, 'UBER GST/QST REPORTING (QUEBEC ONLY)', 'Déclarations TPS/TVQ UBER (Québec)', 'yearly', 29.99, '24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nSHARING TAX DOCUMENTS,\r\nSTORING TAX DOCUMENTS,\r\nCUSTOMERS SUPPORT', 'client', '[\"Quebec Reporting GST\\/PST\"]', 'P-5LX56178XC595113VM4RVMBQ', 'PROD-6AX6407440691205D', 'P-54D34403JY753490UM4VRDTA', 'yes', 0, '2024-10-31 05:03:48', '2024-11-06 01:50:49'),
(16, 'RENTAL  PROPERTY MANAGER', 'Gestionnaire de propriétés locatives', 'yearly', 69.99, '24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nSHARING TAX DOCUMENTS,\r\nSTORING TAX DOCUMENTS,\r\nCUSTOMERS SUPPORT', 'client', '[\"Rental Income Management\"]', 'P-9TG42734W9198773HM4RVM5Y', 'PROD-3PB62128LG719881V', 'P-4YA96088MJ0843811M4VRDUA', 'yes', 0, '2024-10-31 05:05:41', '2024-11-06 01:50:53'),
(17, 'TAX MANAGER & UBER GST/QST REPORTING (QUEBEC ONLY)', 'Gestionnaire d\'impôts et Déclarations TPS/TVQ UBER (Québec)\r\n\r\n', 'yearly', 79.99, '24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nSHARING TAX DOCUMENTS,\r\nSTORING TAX DOCUMENTS,\r\nCUSTOMERS SUPPORT', 'client', '[\"Text Documentation\",\"Quebec Reporting GST\\/PST\"]', 'P-6WK45299GK808663XM4RVNFY', 'PROD-08571773UB9230400', 'P-5KX225321A8095539M4VRDVQ', 'yes', 0, '2024-10-31 05:06:12', '2024-11-06 01:50:59'),
(18, 'TAX MANAGER & RENTAL  PROPERTY MANAGER', 'Gestionnaire d\'impôts et Gestionnaire de propriétés locatives', 'yearly', 99.99, '24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nSHARING TAX DOCUMENTS,\r\nSTORING TAX DOCUMENTS,\r\nCUSTOMERS SUPPORT', 'client', '[\"Text Documentation\",\"Rental Income Management\"]', 'P-1DC4116709033330DM4RVNQQ', 'PROD-4HR04190UH636393M', 'P-2C613432E75528253M4VRDWQ', 'yes', 0, '2024-10-31 05:06:55', '2024-11-06 01:51:04'),
(19, 'TAX MANAGER, UBER GST/QST REPORTING (QUEBEC ONLY) & RENTAL  PROPERTY MANAGER', 'Gestionnaire d\'impôts, Déclarations TPS/TVQ UBER (Québec) et Gestionnaire de propriétés locatives', 'yearly', 119.99, '24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nSHARING TAX DOCUMENTS,\r\nSTORING TAX DOCUMENTS,\r\nCUSTOMERS SUPPORT', 'client', '[\"Text Documentation\",\"Rental Income Management\",\"Quebec Reporting GST\\/PST\"]', 'P-5LV58311UU599980SM4RVN4I', 'PROD-9J77506976379022X', 'P-161029158K3617515M4VRDYI', 'yes', 0, '2024-10-31 05:07:42', '2024-11-06 01:51:10'),
(20, 'Plan I', 'Plan I', 'yearly', 199.99, 'CLIENTS ACCESS,\r\nWEBSITE LISTING,\r\n24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nDEDICATE CUSTOMERS SUPPORT', 'accountant', NULL, 'P-07C829686A0139426M4RVRNQ', 'PROD-6G795776KV627150V', 'P-66902963P2814333UM4VRCYI', 'yes', 0, '2024-10-31 05:15:14', '2024-11-28 05:27:29'),
(21, 'Plan II', 'Plan II', 'yearly', 1249.99, 'CLIENTS ACCESS,\r\nWEBSITE LISTING,\r\n24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nDEDICATE CUSTOMERS SUPPORT', 'accountant', NULL, 'P-4S299963V0839451FM4RVSXY', 'PROD-2DJ56903YL884441E', 'P-9L76527808722824NM4VRDFY', 'yes', 50, '2024-10-31 05:18:05', '2024-11-28 05:27:22'),
(22, 'Plan III', 'Plan III', 'yearly', 1999.99, 'CLIENTS ACCESS,\r\nWEBSITE LISTING,\r\n24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nDEDICATE CUSTOMERS SUPPORT', 'accountant', NULL, 'P-1H883195G05798529M4RVTDQ', 'PROD-0MS75705KS7678907', 'P-8SJ0194663381221RM4VRDEA', 'yes', 100, '2024-10-31 05:18:51', '2024-11-28 05:27:09'),
(23, 'Plan IV', 'Plan IV', 'yearly', 3499.99, 'CLIENTS ACCESS,\r\nWEBSITE LISTING,\r\n24/7 ACCESS,\r\nEMAIL NOTIFICATION,\r\nDEDICATE CUSTOMERS SUPPORT', 'accountant', NULL, 'P-63M57643PU808511DM4RVTOI', 'PROD-0GD32433364327705', 'P-6M630301WG719064LM4VRDCI', 'yes', 200, '2024-10-31 05:19:34', '2024-11-28 05:26:57');

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

--
-- Table structure for table `quebecs`
--

CREATE TABLE `quebecs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gross_uber_rides_fares` double(11,2) NOT NULL,
  `booking_fee` double(11,2) NOT NULL,
  `mtq_dues` double(11,2) NOT NULL,
  `airport_fee` double(11,2) NOT NULL,
  `split_fare` double(11,2) NOT NULL,
  `miscellaneous` double(11,2) NOT NULL,
  `tolls` double(11,2) NOT NULL,
  `tips` double(11,2) NOT NULL,
  `gst_collected_from_riders` double(11,2) NOT NULL,
  `qst_collected_from_riders` double(11,2) NOT NULL,
  `section_1_total` double(11,2) NOT NULL,
  `service_fee` double(11,2) NOT NULL,
  `other_amounts` double(11,2) NOT NULL,
  `fee_discount` double(11,2) NOT NULL,
  `gst_paid_to_uber` double(11,2) NOT NULL,
  `qst_paid_to_uber` double(11,2) NOT NULL,
  `section_2_total` double(11,2) NOT NULL,
  `uber_gst_registration_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uber_qst_registration_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `supplies_excluding_gst_qst` double(11,2) NOT NULL,
  `gst_remitted_by_uber` double(11,2) NOT NULL,
  `qst_remitted_by_uber` double(11,2) NOT NULL,
  `gst_collected_from_riders_sec3` double(11,2) NOT NULL,
  `qst_collected_from_riders_sec3` double(11,2) NOT NULL,
  `your_gst_number_sec3` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `your_qst_number_sec3` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gross_uber_eats_fare` double(11,2) NOT NULL,
  `eats_tips` double(11,2) NOT NULL,
  `gst_collected_from_uber` double(11,2) NOT NULL,
  `qst_collected_from_uber` double(11,2) NOT NULL,
  `section_4_total` double(11,2) NOT NULL,
  `your_gst_number_sec4` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `your_qst_number_sec4` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quick_accounting_method_6085` double(11,2) NOT NULL,
  `gst_collected_from_uber_sec5` double(11,2) NOT NULL,
  `qst_collected_from_uber_sec5` double(11,2) NOT NULL,
  `section_5_total` double(11,2) NOT NULL,
  `uber_gst_registration_number_sec5` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uber_qst_registration_number_sec5` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `on_trip_mileage` double(11,2) NOT NULL,
  `online_mileage` double(11,2) NOT NULL,
  `period_from` date DEFAULT NULL,
  `period_to` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `gst_hst_adjustments_104` double(11,2) DEFAULT NULL,
  `itc_adjustments_and_other_adjustments_107` double(11,2) DEFAULT NULL,
  `qst_adjustments_204` double(11,2) DEFAULT NULL,
  `itr_adjustments_and_other_adjustments_207` double(11,2) 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 `quebecs`
--

INSERT INTO `quebecs` (`id`, `user_id`, `name`, `year`, `gross_uber_rides_fares`, `booking_fee`, `mtq_dues`, `airport_fee`, `split_fare`, `miscellaneous`, `tolls`, `tips`, `gst_collected_from_riders`, `qst_collected_from_riders`, `section_1_total`, `service_fee`, `other_amounts`, `fee_discount`, `gst_paid_to_uber`, `qst_paid_to_uber`, `section_2_total`, `uber_gst_registration_number`, `uber_qst_registration_number`, `supplies_excluding_gst_qst`, `gst_remitted_by_uber`, `qst_remitted_by_uber`, `gst_collected_from_riders_sec3`, `qst_collected_from_riders_sec3`, `your_gst_number_sec3`, `your_qst_number_sec3`, `gross_uber_eats_fare`, `eats_tips`, `gst_collected_from_uber`, `qst_collected_from_uber`, `section_4_total`, `your_gst_number_sec4`, `your_qst_number_sec4`, `quick_accounting_method_6085`, `gst_collected_from_uber_sec5`, `qst_collected_from_uber_sec5`, `section_5_total`, `uber_gst_registration_number_sec5`, `uber_qst_registration_number_sec5`, `on_trip_mileage`, `online_mileage`, `period_from`, `period_to`, `due_date`, `gst_hst_adjustments_104`, `itc_adjustments_and_other_adjustments_107`, `qst_adjustments_204`, `itr_adjustments_and_other_adjustments_207`, `created_at`, `updated_at`) VALUES
(1, 31, 'Aleem Zada', '2022', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 0.00, 0.00, '2024-11-01', '2024-11-30', '2024-11-30', NULL, NULL, NULL, NULL, '2024-11-14 00:12:48', '2024-11-14 00:12:48'),
(3, 31, 'Barbara Whitaker', '2022', 16.00, 14.00, 96.00, 81.00, 41.00, 98.00, 56.00, 29.00, 39.00, 79.00, 549.00, 42.00, 25.00, 60.00, 76.00, 5.00, 88.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 68.00, 37.00, 74.00, 53.00, 53.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 88.00, 91.00, 18.00, 63.00, 260.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 26.00, 41.00, 21.00, 88.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 14.00, 83.00, '1984-08-19', '2019-09-11', '1980-04-16', NULL, NULL, NULL, NULL, '2024-11-15 04:21:16', '2024-11-15 04:21:16'),
(4, 35, 'Faith Richardson', '2020', 66.00, 70.00, 39.00, 3.00, 84.00, 45.00, 54.00, 76.00, 8.00, 25.00, 470.00, 65.00, 14.00, 58.00, 93.00, 81.00, 195.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 8.00, 82.00, 95.00, 10.00, 61.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 31.00, 45.00, 84.00, 3.00, 163.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 82.00, 93.00, 45.00, 220.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 49.00, 1.00, '2024-01-09', '1992-08-10', '1986-11-10', NULL, NULL, NULL, NULL, '2024-11-22 07:21:21', '2024-11-22 07:21:21'),
(6, 37, 'Buffy Scott', '2024', 35.00, 78.00, 33.00, 89.00, 5.00, 80.00, 82.00, 9.00, 68.00, 9.00, 488.00, 2.00, 75.00, 62.00, 74.00, 51.00, 140.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 97.00, 41.00, 44.00, 56.00, 38.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 45.00, 1.00, 34.00, 92.00, 172.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 17.00, 35.00, 85.00, 137.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 56.00, 77.00, '1970-04-14', '2008-01-06', '2022-10-21', NULL, NULL, NULL, NULL, '2024-12-02 01:50:31', '2024-12-02 01:50:31'),
(7, 31, 'Aleem Zada', '2024', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 28900.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 0.00, 0.00, '2024-12-04', '2024-12-04', '2024-12-04', NULL, NULL, NULL, NULL, '2024-12-04 01:00:42', '2024-12-05 02:35:15'),
(8, 31, 'Aleem Zada', '2023', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 31422.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXTQ0001', 0.00, 0.00, 0.00, 0.00, 'XXXXXXXXXRT0001', 'XXXXXXXXXTQ0001', 0.00, 0.00, '2024-12-04', '2024-12-04', '2024-12-04', NULL, NULL, NULL, NULL, '2024-12-04 01:14:26', '2024-12-04 01:14:26');

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

--
-- Table structure for table `regular_entries`
--

CREATE TABLE `regular_entries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `month` enum('January','February','March','April','May','June','July','August','September','October','November','December') COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('Expense','Income') COLLATE utf8mb4_unicode_ci NOT NULL,
  `expense_type` enum('Advertising','Insurance','Interest and bank charges','Office expenses','Professional fees','Management and administration fees','Repairs and maintenance','Salaries wages and benefits','Property taxes','Travel','Utilities','Motor vehicle expenses','Other expenses (BusAuto)','Other expenses','Other','Auto and travel (see instructions)','Cleaning and maintenance','Commissions','Legal and other professional fees','Management fees','Mortgage interest paid to banks, etc. (see instructions)','Other interest','Repairs','Supplies','Taxes','Depreciation expense or depletion','Other (list)') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_expense_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `income_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` float NOT NULL,
  `proof` varchar(255) COLLATE utf8mb4_unicode_ci 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 `regular_entries`
--

INSERT INTO `regular_entries` (`id`, `user_id`, `date`, `month`, `type`, `expense_type`, `other_expense_name`, `income_type_id`, `amount`, `proof`, `created_at`, `updated_at`) VALUES
(1, 31, '2023-11-05', 'November', 'Income', NULL, NULL, 1, 120, '1730791842.png', '2024-11-05 02:30:42', '2024-11-05 02:30:42'),
(4, 31, '2023-11-05', 'November', 'Expense', 'Advertising', NULL, NULL, 1300, NULL, '2024-11-05 02:44:40', '2024-11-05 02:44:40'),
(6, 31, '2024-11-15', 'November', 'Expense', 'Other (list)', 'Testing Other One', NULL, 5678, '1731668239.png', '2024-11-15 05:57:19', '2024-11-15 05:57:19'),
(7, 31, '2024-11-28', 'November', 'Expense', 'Other (list)', 'Testing Name', NULL, 55, '1732783162.png', '2024-11-28 03:39:22', '2024-11-28 03:39:22'),
(8, 31, '2024-12-04', 'December', 'Income', NULL, NULL, 1, 120, NULL, '2024-12-04 01:39:26', '2024-12-04 01:39:26'),
(9, 31, '2024-12-09', 'December', 'Expense', 'Advertising', NULL, NULL, 11, '1733722908avatar (1).png', '2024-12-09 00:41:50', '2024-12-09 00:41:50'),
(10, 31, '2024-12-09', 'December', 'Expense', 'Advertising', NULL, NULL, 122, 'https://storatax.s3.amazonaws.com/regular_entries/1733723220.png', '2024-12-09 00:47:02', '2024-12-09 00:47:02');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('BgRvC9ZLBYf26hEN5oqEvFxOxwfe3lLnjq35taYn', 31, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQkNSZEtERmhKdnF5RjBXSXpndVZzZHQxMFNObXprd1VCdVcyNjZ5ciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jbGllbnQvcmVndWxhci1lbnRyaWVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo0OiJhdXRoIjthOjE6e3M6MjE6InBhc3N3b3JkX2NvbmZpcm1lZF9hdCI7aToxNzMzNzIyMTQ0O31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozMTt9', 1733723485),
('otWYU06m319ttOB3MEVBaZpnT00XA7rHTRKHRzjI', 22, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVVdqaThrcXJTN2V1Z1FIbE50RVdzVGxCUkJUQ2k4QXVWMGt5TURkMSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hY2NvdW50YW50L2Rhc2hib2FyZCI7fXM6NDoiYXV0aCI7YToxOntzOjIxOiJwYXNzd29yZF9jb25maXJtZWRfYXQiO2k6MTczMzcyMjA1NDt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjI7fQ==', 1733723753);

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

--
-- Table structure for table `user_account_settings`
--

CREATE TABLE `user_account_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `province` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `postal_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `appartment_or_suit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `your_percentage` decimal(5,2) DEFAULT '0.00',
  `personal_use_percentage` decimal(5,2) DEFAULT '0.00',
  `number_of_units` int(11) NOT NULL DEFAULT '1',
  `type_of_property` enum('Single Family Residence','Multi-Family Residence','Vacation/Short-Term Rental','Commercial','Land','Royalties','Self-Rental','Other (describe)') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_describe` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fair_rental_days` int(11) DEFAULT NULL,
  `personal_use_days` int(11) 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 `user_account_settings`
--

INSERT INTO `user_account_settings` (`id`, `client_id`, `address`, `city`, `province`, `postal_code`, `appartment_or_suit`, `your_percentage`, `personal_use_percentage`, `number_of_units`, `type_of_property`, `other_describe`, `fair_rental_days`, `personal_use_days`, `created_at`, `updated_at`) VALUES
(2, 31, 'Somewhere in PK', 'Lahore', 'Punjab', '44000', '804', '10.00', '50.00', 10, 'Other (describe)', 'Other Testing', 26, 4, '2024-11-05 01:30:24', '2024-11-15 05:36:02');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accountant_client`
--
ALTER TABLE `accountant_client`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `accountant_client_client_id_unique` (`client_id`),
  ADD KEY `accountant_client_accountant_id_foreign` (`accountant_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_user_id_foreign` (`user_id`);

--
-- Indexes for table `client_plans`
--
ALTER TABLE `client_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `client_plans_client_id_foreign` (`client_id`),
  ADD KEY `client_plans_plan_id_foreign` (`plan_id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupons_code_unique` (`code`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `files_client_id_foreign` (`client_id`),
  ADD KEY `files_uploaded_by_foreign` (`uploaded_by`);

--
-- Indexes for table `file_uploads`
--
ALTER TABLE `file_uploads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_uploads_file_id_foreign` (`file_id`);

--
-- Indexes for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `income_types`
--
ALTER TABLE `income_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `income_types_user_id_foreign` (`user_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quebecs`
--
ALTER TABLE `quebecs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `quebecs_user_id_foreign` (`user_id`);

--
-- Indexes for table `regular_entries`
--
ALTER TABLE `regular_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `regular_entries_user_id_foreign` (`user_id`),
  ADD KEY `regular_entries_income_type_id_foreign` (`income_type_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `user_account_settings`
--
ALTER TABLE `user_account_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_account_settings_client_id_foreign` (`client_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accountant_client`
--
ALTER TABLE `accountant_client`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `client_plans`
--
ALTER TABLE `client_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `file_uploads`
--
ALTER TABLE `file_uploads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `f_a_q_s`
--
ALTER TABLE `f_a_q_s`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `income_types`
--
ALTER TABLE `income_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `quebecs`
--
ALTER TABLE `quebecs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `regular_entries`
--
ALTER TABLE `regular_entries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `user_account_settings`
--
ALTER TABLE `user_account_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accountant_client`
--
ALTER TABLE `accountant_client`
  ADD CONSTRAINT `accountant_client_accountant_id_foreign` FOREIGN KEY (`accountant_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accountant_client_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `client_plans`
--
ALTER TABLE `client_plans`
  ADD CONSTRAINT `client_plans_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `client_plans_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `files_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `file_uploads`
--
ALTER TABLE `file_uploads`
  ADD CONSTRAINT `file_uploads_file_id_foreign` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `income_types`
--
ALTER TABLE `income_types`
  ADD CONSTRAINT `income_types_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quebecs`
--
ALTER TABLE `quebecs`
  ADD CONSTRAINT `quebecs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `regular_entries`
--
ALTER TABLE `regular_entries`
  ADD CONSTRAINT `regular_entries_income_type_id_foreign` FOREIGN KEY (`income_type_id`) REFERENCES `income_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `regular_entries_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_account_settings`
--
ALTER TABLE `user_account_settings`
  ADD CONSTRAINT `user_account_settings_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
