-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 22, 2020 at 10:00 AM
-- Server version: 5.7.14
-- PHP Version: 5.6.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `gami3ea`
--

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `failed_jobs`
--

INSERT INTO `failed_jobs` (`id`, `connection`, `queue`, `payload`, `exception`, `failed_at`) VALUES
(1, 'database', 'default', '{"uuid":"2a5ccd26-bdc1-4213-81c7-07048a270231","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:7:{s:5:\\"email\\";s:13:\\"test@test.com\\";s:13:\\"loop_group_id\\";i:151;s:5:\\"share\\";s:3:\\"100\\";s:6:\\"period\\";i:3;s:16:\\"encashment_month\\";i:8;s:10:\\"monthIndex\\";i:2;s:4:\\"code\\";i:8450;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 'ErrorException: Undefined index: user in D:\\wamp64\\www\\gam3iea\\storage\\framework\\views\\9346485c20e0951cbe4ad7a6f83a7a2355b6eba7.php:5\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\storage\\framework\\views\\9346485c20e0951cbe4ad7a6f83a7a2355b6eba7.php(5): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'Undefined index...\', \'D:\\\\wamp64\\\\www\\\\g...\', 5, Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(41): include(\'D:\\\\wamp64\\\\www\\\\g...\')\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\facade\\ignition\\src\\Views\\Engines\\CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(122): Illuminate\\View\\View->getContents()\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(91): Illuminate\\View\\View->renderContents()\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Markdown.php(64): Illuminate\\View\\View->render()\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(288): Illuminate\\Mail\\Markdown->render(\'web.verificatio...\', Array)\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(258): Illuminate\\Mail\\Mailable->buildMarkdownView()\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(164): Illuminate\\Mail\\Mailable->buildView()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\VerifyCodeMail))\n#15 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\VerifyCodeMail))\n#16 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\VerifyCodeJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\VerifyCodeMail))\n#17 [internal function]: App\\Jobs\\VerifyCodeJob->handle()\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\VerifyCodeJob), false)\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\VerifyCodeJob))\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#38 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#53 {main}\n\nNext Facade\\Ignition\\Exceptions\\ViewException: Undefined index: user (View: D:\\wamp64\\www\\gam3iea\\resources\\views\\web\\verification\\email.blade.php) in D:\\wamp64\\www\\gam3iea\\resources\\views/web/verification/email.blade.php:5\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\resources\\views/web/verification/email.blade.php(5): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'Undefined index...\', \'D:\\\\wamp64\\\\www\\\\g...\', 5, Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(41): include(\'D:\\\\wamp64\\\\www\\\\g...\')\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\facade\\ignition\\src\\Views\\Engines\\CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(122): Illuminate\\View\\View->getContents()\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(91): Illuminate\\View\\View->renderContents()\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Markdown.php(64): Illuminate\\View\\View->render()\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(288): Illuminate\\Mail\\Markdown->render(\'web.verificatio...\', Array)\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(258): Illuminate\\Mail\\Mailable->buildMarkdownView()\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(164): Illuminate\\Mail\\Mailable->buildView()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\VerifyCodeMail))\n#15 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\VerifyCodeMail))\n#16 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\VerifyCodeJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\VerifyCodeMail))\n#17 [internal function]: App\\Jobs\\VerifyCodeJob->handle()\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\VerifyCodeJob), false)\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\VerifyCodeJob))\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#38 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#53 {main}', '2020-06-19 10:00:25'),
(2, 'database', 'default', '{"uuid":"32228828-1d1b-47a2-a5ab-d479e7cbe691","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:7:{s:5:\\"email\\";s:13:\\"test@test.com\\";s:13:\\"loop_group_id\\";i:151;s:5:\\"share\\";s:4:\\"1200\\";s:6:\\"period\\";i:3;s:16:\\"encashment_month\\";i:8;s:10:\\"monthIndex\\";i:2;s:4:\\"code\\";i:3444;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 'ErrorException: Undefined index: user in D:\\wamp64\\www\\gam3iea\\storage\\framework\\views\\9346485c20e0951cbe4ad7a6f83a7a2355b6eba7.php:5\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\storage\\framework\\views\\9346485c20e0951cbe4ad7a6f83a7a2355b6eba7.php(5): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'Undefined index...\', \'D:\\\\wamp64\\\\www\\\\g...\', 5, Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(41): include(\'D:\\\\wamp64\\\\www\\\\g...\')\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\facade\\ignition\\src\\Views\\Engines\\CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(122): Illuminate\\View\\View->getContents()\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(91): Illuminate\\View\\View->renderContents()\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Markdown.php(64): Illuminate\\View\\View->render()\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(288): Illuminate\\Mail\\Markdown->render(\'web.verificatio...\', Array)\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(258): Illuminate\\Mail\\Mailable->buildMarkdownView()\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(164): Illuminate\\Mail\\Mailable->buildView()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\VerifyCodeMail))\n#15 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\VerifyCodeMail))\n#16 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\VerifyCodeJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\VerifyCodeMail))\n#17 [internal function]: App\\Jobs\\VerifyCodeJob->handle()\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\VerifyCodeJob), false)\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\VerifyCodeJob))\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#38 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#53 {main}\n\nNext Facade\\Ignition\\Exceptions\\ViewException: Undefined index: user (View: D:\\wamp64\\www\\gam3iea\\resources\\views\\web\\verification\\email.blade.php) in D:\\wamp64\\www\\gam3iea\\resources\\views/web/verification/email.blade.php:5\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\resources\\views/web/verification/email.blade.php(5): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'Undefined index...\', \'D:\\\\wamp64\\\\www\\\\g...\', 5, Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(41): include(\'D:\\\\wamp64\\\\www\\\\g...\')\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\facade\\ignition\\src\\Views\\Engines\\CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(122): Illuminate\\View\\View->getContents()\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(91): Illuminate\\View\\View->renderContents()\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Markdown.php(64): Illuminate\\View\\View->render()\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(288): Illuminate\\Mail\\Markdown->render(\'web.verificatio...\', Array)\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(258): Illuminate\\Mail\\Mailable->buildMarkdownView()\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(164): Illuminate\\Mail\\Mailable->buildView()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\VerifyCodeMail))\n#15 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\VerifyCodeMail))\n#16 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\VerifyCodeJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\VerifyCodeMail))\n#17 [internal function]: App\\Jobs\\VerifyCodeJob->handle()\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\VerifyCodeJob), false)\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\VerifyCodeJob))\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#38 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#53 {main}', '2020-06-19 10:00:25');
INSERT INTO `failed_jobs` (`id`, `connection`, `queue`, `payload`, `exception`, `failed_at`) VALUES
(3, 'database', 'default', '{"uuid":"4966790f-bd80-4825-b149-e16546661831","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:7:{s:5:\\"email\\";s:13:\\"test@test.com\\";s:13:\\"loop_group_id\\";i:151;s:5:\\"share\\";s:3:\\"100\\";s:6:\\"period\\";i:3;s:16:\\"encashment_month\\";i:8;s:10:\\"monthIndex\\";i:2;s:4:\\"code\\";i:2498;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 'ErrorException: Undefined index: user in D:\\wamp64\\www\\gam3iea\\storage\\framework\\views\\9346485c20e0951cbe4ad7a6f83a7a2355b6eba7.php:5\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\storage\\framework\\views\\9346485c20e0951cbe4ad7a6f83a7a2355b6eba7.php(5): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'Undefined index...\', \'D:\\\\wamp64\\\\www\\\\g...\', 5, Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(41): include(\'D:\\\\wamp64\\\\www\\\\g...\')\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\facade\\ignition\\src\\Views\\Engines\\CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(122): Illuminate\\View\\View->getContents()\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(91): Illuminate\\View\\View->renderContents()\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Markdown.php(64): Illuminate\\View\\View->render()\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(288): Illuminate\\Mail\\Markdown->render(\'web.verificatio...\', Array)\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(258): Illuminate\\Mail\\Mailable->buildMarkdownView()\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(164): Illuminate\\Mail\\Mailable->buildView()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\VerifyCodeMail))\n#15 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\VerifyCodeMail))\n#16 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\VerifyCodeJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\VerifyCodeMail))\n#17 [internal function]: App\\Jobs\\VerifyCodeJob->handle()\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\VerifyCodeJob), false)\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\VerifyCodeJob))\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#38 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#53 {main}\n\nNext Facade\\Ignition\\Exceptions\\ViewException: Undefined index: user (View: D:\\wamp64\\www\\gam3iea\\resources\\views\\web\\verification\\email.blade.php) in D:\\wamp64\\www\\gam3iea\\resources\\views/web/verification/email.blade.php:5\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\resources\\views/web/verification/email.blade.php(5): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'Undefined index...\', \'D:\\\\wamp64\\\\www\\\\g...\', 5, Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(41): include(\'D:\\\\wamp64\\\\www\\\\g...\')\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\facade\\ignition\\src\\Views\\Engines\\CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get(\'D:\\\\wamp64\\\\www\\\\g...\', Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(122): Illuminate\\View\\View->getContents()\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(91): Illuminate\\View\\View->renderContents()\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Markdown.php(64): Illuminate\\View\\View->render()\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(288): Illuminate\\Mail\\Markdown->render(\'web.verificatio...\', Array)\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(258): Illuminate\\Mail\\Mailable->buildMarkdownView()\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(164): Illuminate\\Mail\\Mailable->buildView()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\VerifyCodeMail))\n#15 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\VerifyCodeMail))\n#16 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\VerifyCodeJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\VerifyCodeMail))\n#17 [internal function]: App\\Jobs\\VerifyCodeJob->handle()\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\VerifyCodeJob), false)\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\VerifyCodeJob))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\VerifyCodeJob))\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#38 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#53 {main}', '2020-06-19 10:00:25'),
(4, 'database', 'default', '{"uuid":"34c6ba30-ca33-4a3a-93d4-45678ca510a2","displayName":"App\\\\Jobs\\\\ForgetPasswordJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\ForgetPasswordJob","command":"O:26:\\"App\\\\Jobs\\\\ForgetPasswordJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1224\\";}s:7:\\"\\u0000*\\u0000view\\";s:31:\\"web.users.forget_password_email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 'Swift_TransportException: Expected response code 354 but got code "550", with message "550 5.7.0 Requested action not taken: too many emails per second\r\n" in D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\AbstractSmtpTransport.php:457\nStack trace:\n#0 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\AbstractSmtpTransport.php(341): Swift_Transport_AbstractSmtpTransport->assertResponseCode(\'550 5.7.0 Reque...\', Array)\n#1 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\EsmtpTransport.php(305): Swift_Transport_AbstractSmtpTransport->executeCommand(\'DATA\\r\\n\', Array, Array, false, NULL)\n#2 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\AbstractSmtpTransport.php(390): Swift_Transport_EsmtpTransport->executeCommand(\'DATA\\r\\n\', Array, Array)\n#3 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\AbstractSmtpTransport.php(497): Swift_Transport_AbstractSmtpTransport->doDataCommand(Array)\n#4 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\AbstractSmtpTransport.php(516): Swift_Transport_AbstractSmtpTransport->doMailTransaction(Object(Swift_Message), \'info@example.co...\', Array, Array)\n#5 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Transport\\AbstractSmtpTransport.php(206): Swift_Transport_AbstractSmtpTransport->sendTo(Object(Swift_Message), \'info@example.co...\', Array, Array)\n#6 D:\\wamp64\\www\\gam3iea\\vendor\\swiftmailer\\swiftmailer\\lib\\classes\\Swift\\Mailer.php(71): Swift_Transport_AbstractSmtpTransport->send(Object(Swift_Message), Array)\n#7 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(519): Swift_Mailer->send(Object(Swift_Message), Array)\n#8 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(288): Illuminate\\Mail\\Mailer->sendSwiftMessage(Object(Swift_Message))\n#9 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(170): Illuminate\\Mail\\Mailer->send(Object(Illuminate\\Support\\HtmlString), Array, Object(Closure))\n#10 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Traits\\Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#11 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailable.php(171): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#12 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(304): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#13 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\Mailer.php(258): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\ForgetPasswordMail))\n#14 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Mail\\PendingMail.php(122): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\ForgetPasswordMail))\n#15 D:\\wamp64\\www\\gam3iea\\app\\Jobs\\ForgetPasswordJob.php(39): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\ForgetPasswordMail))\n#16 [internal function]: App\\Jobs\\ForgetPasswordJob->handle()\n#17 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#18 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#19 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#20 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#21 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#22 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(94): Illuminate\\Container\\Container->call(Array)\n#23 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\ForgetPasswordJob))\n#24 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ForgetPasswordJob))\n#25 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Bus\\Dispatcher.php(98): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#26 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(83): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\ForgetPasswordJob), false)\n#27 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\ForgetPasswordJob))\n#28 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ForgetPasswordJob))\n#29 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(85): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#30 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\CallQueuedHandler.php(59): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\ForgetPasswordJob))\n#31 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Jobs\\Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#32 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(356): Illuminate\\Queue\\Jobs\\Job->fire()\n#33 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(306): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#34 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(132): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#35 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(112): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#36 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(96): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#37 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()\n#38 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(32): call_user_func_array(Array, Array)\n#39 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#40 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#41 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#42 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(592): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#43 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(134): Illuminate\\Container\\Container->call(Array)\n#44 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Command\\Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#45 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(912): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#47 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(264): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 D:\\wamp64\\www\\gam3iea\\vendor\\symfony\\console\\Application.php(140): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 D:\\wamp64\\www\\gam3iea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(130): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 D:\\wamp64\\www\\gam3iea\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 {main}', '2020-06-19 10:00:28');

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loop_group_user_id` bigint(20) UNSIGNED NOT NULL,
  `code` char(14) NOT NULL,
  `meta` json NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`id`, `loop_group_user_id`, `code`, `meta`, `created_at`, `updated_at`) VALUES
(1, 37, '30159258169533', '{"type": "subscribe", "total": 285.99}', '2020-06-19 13:48:15', '2020-06-19 13:48:15'),
(4, 43, '61159258256344', '{"type": "subscribe", "total": "1000"}', '2020-06-19 14:02:43', '2020-06-19 14:02:43'),
(5, 44, '27159258262966', '{"type": "subscribe", "total": 2481.53}', '2020-06-19 14:03:50', '2020-06-19 14:03:50'),
(6, 45, '36159258263296', '{"type": "decrease", "total": 327963.35}', '2020-06-19 14:03:52', '2020-06-19 14:03:52'),
(7, 46, '96159258263330', '{"type": "decrease", "total": 7298989.99}', '2020-06-19 14:03:54', '2020-06-19 14:03:54'),
(8, 47, '37159258263551', '{"type": "increase", "total": 6399.98}', '2020-06-19 14:03:55', '2020-06-19 14:03:55'),
(11, 50, '79159281584695', '{"type": "subscribe", "total": "200"}', '2020-06-22 06:50:46', '2020-06-22 06:50:46');

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(191) NOT NULL,
  `payload` longtext 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=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(19, 'default', '{"uuid":"3ee286e7-62d4-4c4d-bc2e-9fd9022f6b4a","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:5:\\"login\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592759862, 1592759862),
(18, 'default', '{"uuid":"abce4223-c41a-4e66-81b9-8ca43d803ba5","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:5:\\"login\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592759705, 1592759705),
(17, 'default', '{"uuid":"6977e32f-fe7a-4c2f-871d-7edd34e85046","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1234\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592759570, 1592759570),
(16, 'default', '{"uuid":"36e64610-2871-40f9-b1ab-4c2bd9d935cd","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1234\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592759542, 1592759542),
(15, 'default', '{"uuid":"c0194865-6285-4b97-a3a0-6a794c2e61a2","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1234\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592757596, 1592757596),
(14, 'default', '{"uuid":"64299542-d38c-466b-b8e3-685e2503eaaa","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1234\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592756824, 1592756824),
(12, 'default', '{"uuid":"e60fa23c-4e79-4db9-b245-ab47acbbaf8e","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"8728\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592732847, 1592732847),
(13, 'default', '{"uuid":"f1fb3ff7-6a02-441f-86dd-7e3922980c8e","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1234\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592756801, 1592756801),
(11, 'default', '{"uuid":"d49be1bb-0fab-462f-8c34-38185e176f7b","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"1300\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592578600, 1592578600),
(10, 'default', '{"uuid":"ad1f395f-a9fb-4f2a-9acf-765ea254f91a","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:4:\\"user\\";s:7:\\"mahmoud\\";s:5:\\"email\\";s:13:\\"test@test.com\\";s:4:\\"code\\";s:4:\\"5509\\";}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592571433, 1592571433),
(20, 'default', '{"uuid":"19fd47cd-f655-4673-a239-7bbdd986ac26","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:5:\\"login\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592759882, 1592759882),
(21, 'default', '{"uuid":"b8bb22af-3c6b-4cbb-aac6-b80929127bf7","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:5:\\"login\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592759989, 1592759989),
(22, 'default', '{"uuid":"9d18e05f-89f2-48b4-ac03-cbf9634f0634","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:8:\\"password\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592760094, 1592760094),
(23, 'default', '{"uuid":"2314d293-6993-414f-9025-b20ac250401c","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:5:\\"login\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592760272, 1592760272),
(24, 'default', '{"uuid":"94c07371-aa6e-4c14-becc-c12ab5298892","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:8:\\"password\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592760295, 1592760295),
(25, 'default', '{"uuid":"cdb8f9d9-fc7c-45df-beb4-2612b38e574b","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:59;s:4:\\"type\\";s:5:\\"login\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592760408, 1592760408),
(26, 'default', '{"uuid":"0d720f10-cd98-4100-9b29-5286cf562765","displayName":"App\\\\Jobs\\\\VerifyCodeJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\\\Jobs\\\\VerifyCodeJob","command":"O:22:\\"App\\\\Jobs\\\\VerifyCodeJob\\":10:{s:7:\\"\\u0000*\\u0000data\\";a:3:{s:7:\\"user_id\\";i:70;s:4:\\"type\\";s:8:\\"register\\";s:4:\\"code\\";i:1234;}s:7:\\"\\u0000*\\u0000view\\";s:22:\\"web.verification.email\\";s:6:\\"\\u0000*\\u0000job\\";N;s:10:\\"connection\\";N;s:5:\\"queue\\";N;s:15:\\"chainConnection\\";N;s:10:\\"chainQueue\\";N;s:5:\\"delay\\";N;s:10:\\"middleware\\";a:0:{}s:7:\\"chained\\";a:0:{}}"}}', 0, NULL, 1592761691, 1592761691);

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `local` char(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'whether the language is active in the website or not, 1-> is active',
  `admin_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'whether the language is active in the dashboard or not, 1-> is active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `local`, `name`, `status`, `admin_status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'ar', 'Arabic', 1, 1, NULL, NULL, NULL),
(2, 'en', 'English', 1, 1, NULL, NULL, NULL);

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

--
-- Table structure for table `loops`
--

CREATE TABLE `loops` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loops`
--

INSERT INTO `loops` (`id`, `date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '2020-06-01', '2020-06-10 16:04:57', '2020-06-10 16:04:57', NULL),
(2, '2020-07-01', NULL, NULL, NULL),
(3, '2002-01-08', '2020-06-19 13:43:56', '2020-06-19 13:43:56', NULL),
(4, '1995-09-16', '2020-06-19 13:44:27', '2020-06-19 13:44:27', NULL),
(5, '1987-08-21', '2020-06-19 13:45:31', '2020-06-19 13:45:31', NULL),
(6, '2013-06-11', '2020-06-19 13:48:15', '2020-06-19 13:48:15', NULL),
(7, '2006-08-16', '2020-06-19 14:03:49', '2020-06-19 14:03:49', NULL),
(8, '2014-12-14', '2020-06-19 14:03:52', '2020-06-19 14:03:52', NULL),
(9, '1995-10-14', '2020-06-19 14:03:53', '2020-06-19 14:03:53', NULL),
(10, '1970-08-27', '2020-06-19 14:03:55', '2020-06-19 14:03:55', NULL),
(11, '1989-10-26', '2020-06-21 10:23:07', '2020-06-21 10:23:07', NULL);

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

--
-- Table structure for table `loop_groups`
--

CREATE TABLE `loop_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loop_id` bigint(20) UNSIGNED NOT NULL,
  `setting` json NOT NULL,
  `period` tinyint(4) GENERATED ALWAYS AS (json_extract(`setting`,'$.period')) VIRTUAL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loop_groups`
--

INSERT INTO `loop_groups` (`id`, `loop_id`, `setting`, `period`, `created_at`, `updated_at`) VALUES
(151, 1, '{"months": [{"tax": 10, "hold": 83.59, "paid": 0, "credit": 0, "remain": 300, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": 2400, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": 0, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 3, "max_budget": 12000, "max_period": 176, "real_budget": 0, "months[*].tax": 10, "months[0].remain": -3601, "months[2].remain": 3000}', 3, NULL, NULL),
(152, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": 4000, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": 11600, "release": 62.82}], "period": 4, "max_budget": 16000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 4, NULL, NULL),
(153, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 5, "max_budget": 20000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 5, NULL, NULL),
(154, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 6, "max_budget": 24000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 6, NULL, NULL),
(155, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 7, "max_budget": 28000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 7, NULL, NULL),
(156, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 8, "max_budget": 32000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 8, NULL, NULL),
(157, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": 31500, "release": 62.82}], "period": 9, "max_budget": 36000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 9, NULL, NULL),
(158, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 10, "max_budget": 40000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 10, NULL, NULL),
(159, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 11, "max_budget": 44000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 11, NULL, NULL),
(160, 1, '{"months": [{"tax": 8795348.4, "hold": 83.59, "paid": 0, "credit": 0, "remain": -1, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": -1, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": -1, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 12, "max_budget": 48000, "max_period": 176, "real_budget": 0, "months[*].tax": 10}', 12, NULL, NULL),
(161, 2, '{"months": [{"tax": 10, "hold": 83.59, "paid": 0, "credit": 0, "remain": 300, "release": 87.32}, {"tax": 20, "hold": 29.5, "paid": 0, "credit": 0, "remain": 3000, "release": 15.27}, {"tax": 20, "hold": 93.05, "paid": 0, "credit": 0, "remain": 2100, "release": 68.73}, {"tax": 20, "hold": 27.76, "paid": 0, "credit": 0, "remain": -1, "release": 62.82}], "period": 3, "max_budget": 12000, "max_period": 176, "real_budget": 0, "months[*].tax": 10, "months[0].remain": -3601, "months[2].remain": 3000}', 3, NULL, NULL),
(162, 3, '{"months": [{"tax": 75473.45, "hold": 84.28, "paid": 0, "credit": 0, "remain": 0, "release": 74.7}, {"tax": 66.33, "hold": 90.67, "paid": 0, "credit": 0, "remain": 0, "release": 53.69}, {"tax": 50.41, "hold": 70.38, "paid": 0, "credit": 0, "remain": 0, "release": 98.72000000000001}, {"tax": 418.16, "hold": 82.62, "paid": 0, "credit": 0, "remain": 0, "release": 49.67}], "period": 7, "max_budget": 59683379.03, "real_budget": 358072429.33}', 7, NULL, NULL),
(163, 4, '{"months": [{"tax": 131541442.51, "hold": 8.66, "paid": 0, "credit": 0, "remain": 0, "release": 49.2}, {"tax": 45576283.43, "hold": 1.94, "paid": 0, "credit": 0, "remain": 0, "release": 26.02}, {"tax": 3026.07, "hold": 86.11, "paid": 0, "credit": 0, "remain": 0, "release": 29.06}, {"tax": 584326.39, "hold": 33.51, "paid": 0, "credit": 0, "remain": 0, "release": 64.86}], "period": 4, "max_budget": 5874586.16, "real_budget": 140969.11}', 4, NULL, NULL),
(164, 5, '{"months": [{"tax": 127.97, "hold": 72.43, "paid": 0, "credit": 0, "remain": 0, "release": 36.61}, {"tax": 312963.73, "hold": 44.51, "paid": 0, "credit": 0, "remain": 0, "release": 54.48}, {"tax": 1630.18, "hold": 6.68, "paid": 0, "credit": 0, "remain": 0, "release": 22.36}, {"tax": 31530.9, "hold": 23.84, "paid": 0, "credit": 0, "remain": 0, "release": 79.77}], "period": 4, "max_budget": 409466, "real_budget": 22.86}', 4, NULL, NULL),
(165, 6, '{"months": [{"tax": 158905333.08, "hold": 16.56, "paid": 0, "credit": 0, "remain": 0, "release": 91.85}, {"tax": 60450858.02, "hold": 28.15, "paid": 0, "credit": 0, "remain": 0, "release": 53.06}, {"tax": 3.33, "hold": 82.61, "paid": 0, "credit": 0, "remain": 0, "release": 81.27}, {"tax": 763783.55, "hold": 0.67, "paid": 0, "credit": 0, "remain": 0, "release": 11}], "period": 5, "max_budget": 87760.64, "real_budget": 4059.2}', 5, NULL, NULL),
(166, 7, '{"months": [{"tax": 4462.4, "hold": 62.59, "paid": 0, "credit": 0, "remain": 0, "release": 89.73}, {"tax": 0.72, "hold": 59.09, "paid": 0, "credit": 0, "remain": 0, "release": 19.35}, {"tax": 107.8, "hold": 56.69, "paid": 0, "credit": 0, "remain": 0, "release": 97.34}, {"tax": 77.77, "hold": 71.87, "paid": 0, "credit": 0, "remain": 0, "release": 59.63}], "period": 12, "max_budget": 1323518.69, "real_budget": 2540754.13}', 12, NULL, NULL),
(167, 8, '{"months": [{"tax": 1085364.41, "hold": 86.4, "paid": 0, "credit": 0, "remain": 0, "release": 91.31}, {"tax": 22070523.49, "hold": 25.82, "paid": 0, "credit": 0, "remain": 0, "release": 44.18}, {"tax": 301.35, "hold": 75.11, "paid": 0, "credit": 0, "remain": 0, "release": 83.26}, {"tax": 1039.9, "hold": 59.03, "paid": 0, "credit": 0, "remain": 0, "release": 52.81}], "period": 4, "max_budget": 46754957.35, "real_budget": 6718.95}', 4, NULL, NULL),
(168, 9, '{"months": [{"tax": 50348.67, "hold": 30.05, "paid": 0, "credit": 0, "remain": 0, "release": 82.57}, {"tax": 849850.05, "hold": 67.61, "paid": 0, "credit": 0, "remain": 0, "release": 24.56}, {"tax": 51.75, "hold": 81.9, "paid": 0, "credit": 0, "remain": 0, "release": 82.46}, {"tax": 648238.57, "hold": 52, "paid": 0, "credit": 0, "remain": 0, "release": 58.44}], "period": 10, "max_budget": 6.56, "real_budget": 35347.38}', 10, NULL, NULL),
(169, 10, '{"months": [{"tax": 1.59, "hold": 26.13, "paid": 0, "credit": 0, "remain": 0, "release": 96.7}, {"tax": 4.59, "hold": 5.95, "paid": 0, "credit": 0, "remain": 0, "release": 61.67}, {"tax": 168729500.66, "hold": 26.4, "paid": 0, "credit": 0, "remain": 0, "release": 54.6}, {"tax": 4791.11, "hold": 23.96, "paid": 0, "credit": 0, "remain": 0, "release": 4.82}], "period": 12, "max_budget": 301.25, "real_budget": 671394.02}', 12, NULL, NULL),
(170, 11, '{"months": [{"tax": 6032.46, "hold": 36.08, "paid": 0, "credit": 0, "remain": 0, "release": 11.86}, {"tax": 1244.54, "hold": 44.86, "paid": 0, "credit": 0, "remain": 0, "release": 95.89}, {"tax": 17842.41, "hold": 42.85, "paid": 0, "credit": 0, "remain": 0, "release": 81.91}, {"tax": 22.74, "hold": 76.26, "paid": 0, "credit": 0, "remain": 0, "release": 9.19}], "period": 11, "max_budget": 4658.89, "real_budget": 62302.51}', 11, NULL, NULL);

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

--
-- Table structure for table `loop_group_users`
--

CREATE TABLE `loop_group_users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loop_group_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `share` double(8,2) NOT NULL COMMENT 'amount the user will pay every month',
  `period` tinyint(4) NOT NULL,
  `encashment_month` date NOT NULL COMMENT 'The month he will get paid in it',
  `get_paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'whether the user got paid or not',
  `status` enum('active','cancelled') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loop_group_users`
--

INSERT INTO `loop_group_users` (`id`, `loop_group_id`, `user_id`, `share`, `period`, `encashment_month`, `get_paid`, `status`, `created_at`, `updated_at`) VALUES
(33, 160, 1, 200.00, 3, '2020-08-12', 0, 'active', '2020-06-16 09:48:48', '2020-06-16 09:48:48'),
(37, 165, 63, 2759.96, 3, '2020-09-12', 0, 'cancelled', '2020-06-19 13:48:15', '2020-06-19 13:48:15'),
(43, 152, 59, 1000.00, 4, '2020-10-12', 0, 'active', '2020-06-19 14:02:43', '2020-06-19 14:02:43'),
(44, 166, 64, 1566.18, 6, '2020-12-12', 0, 'active', '2020-06-19 14:03:50', '2020-06-19 14:03:50'),
(45, 167, 65, 728.70, 7, '2020-06-12', 0, 'active', '2020-06-19 14:03:52', '2020-06-19 14:03:52'),
(46, 168, 66, 381.84, 6, '2020-07-12', 0, 'active', '2020-06-19 14:03:54', '2020-06-19 14:03:54'),
(47, 169, 67, 766.04, 5, '2020-11-12', 0, 'cancelled', '2020-06-19 14:03:55', '2020-06-19 14:03:55'),
(50, 151, 70, 200.00, 3, '2020-07-01', 0, 'active', '2020-06-22 06:50:46', '2020-06-22 06:50:46');

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

--
-- Table structure for table `loop_group_user_paids`
--

CREATE TABLE `loop_group_user_paids` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `loop_group_user_id` bigint(20) UNSIGNED NOT NULL,
  `month` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `loop_group_user_paids`
--

INSERT INTO `loop_group_user_paids` (`id`, `loop_group_user_id`, `month`, `created_at`) VALUES
(37, 43, 6, '2020-06-19 14:02:43'),
(38, 33, 6, '2020-06-21 16:08:55'),
(40, 50, 6, '2020-06-22 06:50:46');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2020_03_23_152956_create_modules_table', 1),
(4, '2020_03_24_152330_create_user_modules_table', 1),
(5, '2020_03_26_123015_create_notifications_table', 1),
(6, '2020_03_28_090214_create_languages_table', 1),
(7, '2020_04_11_162749_create_pages_table', 1),
(8, '2020_04_15_174353_create_page_description_table', 1),
(9, '2020_05_18_084100_create_jobs_table', 1),
(10, '2020_05_18_103912_create_failed_jobs_table', 1),
(11, '2020_06_01_181915_create_setting_table', 1),
(12, '2020_06_08_153822_create_loops_table', 1),
(13, '2020_06_09_115921_create_loop_groups_table', 1),
(15, '2020_06_09_164832_create_loop_group_users_table', 2),
(20, '2020_06_10_095526_create_loop_group_user_paids_table', 3),
(21, '2020_06_14_100018_create_table_verifications', 4),
(22, '2020_06_15_163816_update_users_table', 5),
(23, '2020_06_17_112509_add_forign_keys', 6),
(24, '2020_06_19_151244_create_invoices_table', 7),
(25, '2020_06_06_155249_create_website_visitors_table', 8);

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `path` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `name`, `path`, `created_at`, `updated_at`) VALUES
(1, 'Pages', 'pages', NULL, NULL),
(2, 'Users', 'users', NULL, NULL),
(3, 'Settings', 'settings', NULL, NULL),
(4, 'Loops', 'loops', '2020-06-16 22:00:00', '2020-06-16 22:00:00');

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

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

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(200) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, NULL, 1, NULL, NULL, NULL),
(2, NULL, 1, NULL, NULL, NULL);

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

--
-- Table structure for table `page_descriptions`
--

CREATE TABLE `page_descriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(50) NOT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `keywords` varchar(250) NOT NULL,
  `description` varchar(250) NOT NULL,
  `page_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_descriptions`
--

INSERT INTO `page_descriptions` (`id`, `title`, `slug`, `meta_description`, `keywords`, `description`, `page_id`, `language_id`) VALUES
(1, 'الأحكام والشروط', 'الأحكام والشروط', 'الأحكام والشروط', 'الأحكام والشروط', '<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.<br class="line-break" />إذا كنت تحتاج إلى عدد ', 1, 1),
(2, 'Terms And Condition', 'Terms And Condition', 'Terms And Condition', 'Terms And Condition', '<p>Lorem Ipsum Dolor Sit, Amet Consectetur Adipisicing Elit. Qui Labore, Repudiandae Non Ea Numquam Delectus Quaerat Dolor A Deserunt Optio Accusamus Reprehenderit Fuga Temporibus Perferendis Corrupti, Tenetur Cupiditate Explicabo Culpa.</p>\r\n       ', 1, 2),
(3, 'الدورة المالية', 'الدورة المالية', 'الدورة المالية', 'الدورة المالية', '<p>تعرف على كيفية التفكير التصميمي ، وبحوث المستخدم ، ورؤية الأعمال والتسويق ، وأخيرًا.</p>', 2, 1),
(4, 'Money Loop', 'Money Loop', 'Money Loop', 'Money Loop', '<p>Learn How Design Thinking, User Research, Business Vision And Marketing, And Finally.</p>', 2, 2);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(100) NOT NULL,
  `value` longtext,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'website_name', 'Money Loop', NULL, '2020-06-18 10:52:03'),
(2, 'keywords', 'CE5OTsho9o5HOG2z', NULL, '2020-06-18 10:52:03'),
(3, 'meta_description', 'Mhb2zfKm9F3m6F6O', NULL, '2020-06-18 10:52:03'),
(4, 'site_email', 'info@example.com', NULL, '2020-06-18 10:52:03'),
(5, 'site_address', '6S9fG6viymyocey4', NULL, '2020-06-18 10:52:03'),
(6, 'site_phone', '123456789', NULL, '2020-06-18 10:52:03'),
(7, 'mail_driver', 'smtp', NULL, '2020-06-18 10:52:03'),
(8, 'mail_host', 'smtp.mailtrap.io', NULL, '2020-06-18 10:52:03'),
(9, 'mail_port', '2525', NULL, '2020-06-18 10:52:03'),
(10, 'mail_username', '759b99df94f0be', NULL, '2020-06-18 10:52:03'),
(11, 'mail_password', 'e4c5c123acd614', NULL, '2020-06-18 10:52:03'),
(12, 'mail_encryption', 'tls', NULL, '2020-06-18 10:52:03'),
(13, 'mail_from_address', 'info@example.com', NULL, '2020-06-18 10:52:03'),
(14, 'mail_from_name', 'EXAMPLE', NULL, '2020-06-18 10:52:03'),
(15, 'website_logo', '/uploads/images//5eeb636233fec.png', NULL, '2020-06-18 10:52:03'),
(16, 'fees', '{"government_fees":40,"VAT":"30%"}', NULL, NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(300) DEFAULT NULL,
  `email` varchar(250) NOT NULL,
  `phone` varchar(14) DEFAULT NULL,
  `id_number` varchar(100) DEFAULT NULL,
  `photo` varchar(300) DEFAULT NULL,
  `id_photo` varchar(300) DEFAULT NULL,
  `bank_account_statement` varchar(300) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `admin_token` varchar(1000) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `role` enum('admin','sub_admin','user') NOT NULL DEFAULT 'user',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `id_number`, `photo`, `id_photo`, `bank_account_statement`, `birth_date`, `admin_token`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Super Admin', 'admin@admin.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-09 15:12:28', '$2y$10$UEXn5p2und8p4F6rDWluteezZR/Pn5UySGfNGG8TbtBlnoS7/wwuS', 'admin', '4jV8F0yhdOtpDUgtRMkVOmR2hO7sRIxxF8y8jouoHtXhpe8gxygkVQXB7slI', '2020-06-09 15:12:28', '2020-06-09 15:12:28', NULL),
(59, 'mahmoud', 'test@test.com', '+9965612345678', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$CMxky0wpe6KJXvEtf4ajneAObzxvdAevsntSPcOZNTt0FwLhOHD7C', 'user', 'p1t9VDccSIcE32GW0gJv9sxbBop1u2SOYCN6i2uIhre4LMrikEUjMEl36vo5', NULL, '2020-06-21 15:26:34', NULL),
(60, 'Mr. Dustin Marquardt IV', 'roberts.greta@example.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 13:43:56', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'ZPDWoZhYjF', '2020-06-19 13:43:56', '2020-06-19 13:43:56', NULL),
(61, 'Avis Dibbert IV', 'hobart54@example.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 13:44:27', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'OUpmXsFrJh', '2020-06-19 13:44:27', '2020-06-19 13:44:27', NULL),
(62, 'Ms. Talia Hammes PhD', 'angelita.crist@example.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 13:45:31', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'MFyWOJuQuC', '2020-06-19 13:45:31', '2020-06-19 13:45:31', NULL),
(63, 'Dr. Jaleel Schowalter', 'lincoln.bartoletti@example.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 13:48:15', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'WSgsg9AAGy', '2020-06-19 13:48:15', '2020-06-19 13:48:15', NULL),
(64, 'Prof. Keshawn Wilderman', 'quitzon.shany@example.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 14:03:50', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'A12wnPgRAr', '2020-06-19 14:03:50', '2020-06-19 14:03:50', NULL),
(65, 'Prof. Bertrand Haley', 'shyatt@example.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 14:03:52', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'D4El1xmZlS', '2020-06-19 14:03:52', '2020-06-19 14:03:52', NULL),
(66, 'Prof. Ashley Rice V', 'burnice72@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 14:03:54', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'IjI8dNfNWq', '2020-06-19 14:03:54', '2020-06-19 14:03:54', NULL),
(67, 'Mr. Aidan Anderson', 'boyd48@example.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 14:03:55', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'JCiJwf7V76', '2020-06-19 14:03:55', '2020-06-19 14:03:55', NULL),
(69, 'Dr. Adaline Botsford', 'jessika81@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-21 10:23:07', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', 'FW30jyfn2i', '2020-06-21 10:23:07', '2020-06-21 10:23:07', NULL),
(70, 'test2', 'test2@test2.com', '05612345678', '123456789', NULL, '/uploads/images/1592761690.IqDtSHlJYb4keBF0.png', '/uploads/images/1592761690.8BDw0xKWpCQfmjIw.png', NULL, NULL, NULL, '$2y$10$P9qEjGeaVOGaIwbl0kKqS.PvgRjaWKpyRDxMVAWJPbR1p0M6vTA9q', 'user', 'EmvwuP5kaFaQhNdXp8aNtMe9UUKwtQQhQSq2dz5SSYIaHxS9wd1LWKkjZNYc', '2020-06-21 15:48:10', '2020-06-21 15:48:10', NULL);

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

--
-- Table structure for table `user_modules`
--

CREATE TABLE `user_modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `module_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_modules`
--

INSERT INTO `user_modules` (`id`, `user_id`, `module_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 1, 2, NULL, NULL),
(3, 1, 3, NULL, NULL);

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

--
-- Table structure for table `verifications`
--

CREATE TABLE `verifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `metadata` text,
  `code` varchar(5) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `verifications`
--

INSERT INTO `verifications` (`id`, `user_id`, `type`, `metadata`, `code`, `created_at`, `updated_at`) VALUES
(1, 59, 'reset_password', NULL, '1224', NULL, NULL);

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

--
-- Table structure for table `website_visitors`
--

CREATE TABLE `website_visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `created_at` timestamp NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `website_visitors`
--

INSERT INTO `website_visitors` (`id`, `ip`, `created_at`) VALUES
(1, '16.203.248.140', '2020-06-16 10:27:41'),
(2, '80.40.66.209', '2020-06-18 10:27:43'),
(3, '108.148.181.146', '2020-06-21 10:27:44'),
(4, '127.0.0.1', '2020-06-21 10:49:59'),
(5, '127.0.0.1', '2020-06-21 11:01:44'),
(6, '127.0.0.1', '2020-06-21 14:13:02'),
(7, '127.0.0.1', '2020-06-21 15:19:38'),
(8, '127.0.0.1', '2020-06-21 15:21:01'),
(9, '127.0.0.1', '2020-06-21 15:32:25'),
(10, '127.0.0.1', '2020-06-22 06:39:54');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoices_loop_group_user_id_index` (`loop_group_user_id`),
  ADD KEY `invoices_code_index` (`code`);

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

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_local_unique` (`local`),
  ADD KEY `languages_status_index` (`status`),
  ADD KEY `languages_admin_status_index` (`admin_status`);

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

--
-- Indexes for table `loop_groups`
--
ALTER TABLE `loop_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loop_groups_loop_id_index` (`loop_id`),
  ADD KEY `loop_groups_period_index` (`period`);

--
-- Indexes for table `loop_group_users`
--
ALTER TABLE `loop_group_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loop_group_users_loop_group_id_index` (`loop_group_id`),
  ADD KEY `loop_group_users_user_id_index` (`user_id`),
  ADD KEY `loop_group_users_share_index` (`share`),
  ADD KEY `loop_group_users_period_index` (`period`),
  ADD KEY `loop_group_users_encashment_month_index` (`encashment_month`);

--
-- Indexes for table `loop_group_user_paids`
--
ALTER TABLE `loop_group_user_paids`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loop_group_user_paids_loop_group_user_id_index` (`loop_group_user_id`),
  ADD KEY `loop_group_user_paids_month_index` (`month`);

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

--
-- Indexes for table `modules`
--
ALTER TABLE `modules`
  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 `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `page_descriptions`
--
ALTER TABLE `page_descriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `page_descriptions_language_id_foreign` (`language_id`),
  ADD KEY `page_descriptions_page_id_language_id_index` (`page_id`,`language_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `settings_key_index` (`key`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_phone_unique` (`phone`),
  ADD UNIQUE KEY `users_id_number_unique` (`id_number`);

--
-- Indexes for table `user_modules`
--
ALTER TABLE `user_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_modules_module_id_foreign` (`module_id`),
  ADD KEY `user_modules_user_id_module_id_index` (`user_id`,`module_id`);

--
-- Indexes for table `verifications`
--
ALTER TABLE `verifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `verifications_user_id_code_index` (`user_id`,`code`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `loops`
--
ALTER TABLE `loops`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `loop_groups`
--
ALTER TABLE `loop_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;
--
-- AUTO_INCREMENT for table `loop_group_users`
--
ALTER TABLE `loop_group_users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT for table `loop_group_user_paids`
--
ALTER TABLE `loop_group_user_paids`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `modules`
--
ALTER TABLE `modules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `page_descriptions`
--
ALTER TABLE `page_descriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT for table `user_modules`
--
ALTER TABLE `user_modules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `verifications`
--
ALTER TABLE `verifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `website_visitors`
--
ALTER TABLE `website_visitors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_loop_group_user_id_foreign` FOREIGN KEY (`loop_group_user_id`) REFERENCES `loop_group_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `loop_groups`
--
ALTER TABLE `loop_groups`
  ADD CONSTRAINT `loop_groups_loop_id_foreign` FOREIGN KEY (`loop_id`) REFERENCES `loops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `loop_group_users`
--
ALTER TABLE `loop_group_users`
  ADD CONSTRAINT `loop_group_users_loop_group_id_foreign` FOREIGN KEY (`loop_group_id`) REFERENCES `loop_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `loop_group_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `loop_group_user_paids`
--
ALTER TABLE `loop_group_user_paids`
  ADD CONSTRAINT `loop_group_user_paids_loop_group_user_id_foreign` FOREIGN KEY (`loop_group_user_id`) REFERENCES `loop_group_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `page_descriptions`
--
ALTER TABLE `page_descriptions`
  ADD CONSTRAINT `page_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `page_descriptions_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_modules`
--
ALTER TABLE `user_modules`
  ADD CONSTRAINT `user_modules_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_modules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

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