(2498,'default','{\"uuid\":\"f0638220-d01a-40c0-9ee0-3fdda2fae318\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714665155,1714665155),(2499,'default','{\"uuid\":\"3f0255e2-4b3d-4aba-b460-6d4b69e62980\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714665155,1714665155),(2500,'default','{\"uuid\":\"377c584f-b3de-4270-afb3-5f35d75f6de7\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714665155,1714665155),(2501,'default','{\"uuid\":\"09a500d0-3b0a-4d8d-a4f9-72ee2d459277\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714665219,1714665219),(2502,'default','{\"uuid\":\"006bd1c2-8e0f-457b-ad6c-0e52d68eb891\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714665219,1714665219),(2503,'default','{\"uuid\":\"cc2e7f4c-8054-4b3e-9806-b03aea055838\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714665219,1714665219),(2504,'default','{\"uuid\":\"730f8f7d-1a10-4cd5-93f8-3646824e2db4\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714665226,1714665226),(2505,'default','{\"uuid\":\"f638c2b8-62cd-43fd-b3fb-7b3905597bf0\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714665226,1714665226),(2506,'default','{\"uuid\":\"00c3668a-4aef-4056-b868-51d1b02192ba\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714665226,1714665226),(2507,'default','{\"uuid\":\"6557095c-fb87-4b43-9edc-85b610becf80\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714742140,1714742140),(2508,'default','{\"uuid\":\"61d93081-d0c5-43f5-9fca-1abc6af5bcdf\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714742140,1714742140),(2509,'default','{\"uuid\":\"9180710a-82ae-4be5-863a-17d009686f87\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714742140,1714742140),(2510,'default','{\"uuid\":\"cb8574c2-50ca-4d4d-ad27-8e980330537e\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714742165,1714742165),(2511,'default','{\"uuid\":\"6c827c2e-65ad-48e8-83b2-cdcc427a6726\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714742165,1714742165),(2512,'default','{\"uuid\":\"a49c31d0-ce91-4572-89bc-148b4ff37961\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714742165,1714742165),(2513,'default','{\"uuid\":\"76fc75e7-d7c2-4fda-b2b4-0988138152ba\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743623,1714743623),(2514,'default','{\"uuid\":\"f8056fd6-dda1-4acb-8806-019815755dba\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743623,1714743623),(2515,'default','{\"uuid\":\"d3fffc48-f852-4290-8712-4a041a9f2e30\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743623,1714743623),(2516,'default','{\"uuid\":\"2d9c550c-5965-4b1b-acfb-ee86e75c82ef\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743740,1714743740),(2517,'default','{\"uuid\":\"44a2c143-623d-4e5f-860e-b22bdf52ccf8\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743740,1714743740),(2518,'default','{\"uuid\":\"ae842a60-d918-4b9a-b78c-d9e917d923a1\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743740,1714743740),(2519,'default','{\"uuid\":\"1d0ecc68-8b92-47b8-9feb-17a212ef63bb\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743745,1714743745),(2520,'default','{\"uuid\":\"b093c2da-002b-4e7a-b9f5-10db4267e957\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743745,1714743745),(2521,'default','{\"uuid\":\"04abfa7a-359f-41aa-80b4-95843f536847\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743745,1714743745),(2522,'default','{\"uuid\":\"46baa8c7-8e54-4092-9217-240d79b7ac22\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743794,1714743794),(2523,'default','{\"uuid\":\"c87fcf21-76cb-4f47-8292-a67365529dc5\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743794,1714743794),(2524,'default','{\"uuid\":\"c19c9553-6211-4f99-a8ec-115a003cf4d6\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743794,1714743794),(2525,'default','{\"uuid\":\"ddfe9164-78e5-4cf4-b581-085ddb39a36f\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743821,1714743821),(2526,'default','{\"uuid\":\"3610e886-6e93-45c5-b2c0-65d6b93582ee\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743821,1714743821),(2527,'default','{\"uuid\":\"d7ac5231-01c0-4f1e-b725-b0867fd4bfd4\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743821,1714743821),(2528,'default','{\"uuid\":\"8eed386d-8ec0-4b68-8f20-c3f97604bf2c\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743837,1714743837),(2529,'default','{\"uuid\":\"3ce7afe2-5c76-41a2-b680-34f32b9d9e23\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743837,1714743837),(2530,'default','{\"uuid\":\"6cd1ca24-ce0c-4047-964e-6cea07fe6b8f\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743837,1714743837),(2531,'default','{\"uuid\":\"fa5925a7-a2f7-42bb-b792-e130b8468e16\",\"displayName\":\"App\\\\Jobs\\\\ComputeCategoryProductsJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\ComputeCategoryProductsJob\",\"command\":\"O:35:\\\"App\\\\Jobs\\\\ComputeCategoryProductsJob\\\":12:{s:15:\\\"productCategory\\\";O:26:\\\"App\\\\Models\\\\ProductCategory\\\":31:{s:13:\\\"\\u0000*\\u0000connection\\\";s:5:\\\"mysql\\\";s:8:\\\"\\u0000*\\u0000table\\\";s:27:\\\"nexopos_products_categories\\\";s:13:\\\"\\u0000*\\u0000primaryKey\\\";s:2:\\\"id\\\";s:10:\\\"\\u0000*\\u0000keyType\\\";s:3:\\\"int\\\";s:12:\\\"incrementing\\\";b:1;s:7:\\\"\\u0000*\\u0000with\\\";a:0:{}s:12:\\\"\\u0000*\\u0000withCount\\\";a:0:{}s:19:\\\"preventsLazyLoading\\\";b:0;s:10:\\\"\\u0000*\\u0000perPage\\\";i:15;s:6:\\\"exists\\\";b:1;s:18:\\\"wasRecentlyCreated\\\";b:0;s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;s:13:\\\"\\u0000*\\u0000attributes\\\";a:12:{s:2:\\\"id\\\";i:21;s:4:\\\"name\\\";s:11:\\\"Soft Drinks\\\";s:9:\\\"parent_id\\\";N;s:8:\\\"media_id\\\";i:0;s:11:\\\"preview_url\\\";s:58:\\\"https:\\/\\/pos.momentpay.live\\/storage\\/2024\\/05\\/softdrinks.jpeg\\\";s:15:\\\"displays_on_pos\\\";i:1;s:11:\\\"total_items\\\";i:0;s:11:\\\"description\\\";N;s:6:\\\"author\\\";i:8;s:4:\\\"uuid\\\";N;s:10:\\\"created_at\\\";s:19:\\\"2024-05-02 04:40:17\\\";s:10:\\\"updated_at\\\";s:19:\\\"2024-05-02 04:40:17\\\";}s:11:\\\"\\u0000*\\u0000original\\\";a:12:{s:2:\\\"id\\\";i:21;s:4:\\\"name\\\";s:11:\\\"Soft Drinks\\\";s:9:\\\"parent_id\\\";N;s:8:\\\"media_id\\\";i:0;s:11:\\\"preview_url\\\";s:58:\\\"https:\\/\\/pos.momentpay.live\\/storage\\/2024\\/05\\/softdrinks.jpeg\\\";s:15:\\\"displays_on_pos\\\";i:1;s:11:\\\"total_items\\\";i:0;s:11:\\\"description\\\";N;s:6:\\\"author\\\";i:8;s:4:\\\"uuid\\\";N;s:10:\\\"created_at\\\";s:19:\\\"2024-05-02 04:40:17\\\";s:10:\\\"updated_at\\\";s:19:\\\"2024-05-02 04:40:17\\\";}s:10:\\\"\\u0000*\\u0000changes\\\";a:0:{}s:8:\\\"\\u0000*\\u0000casts\\\";a:0:{}s:17:\\\"\\u0000*\\u0000classCastCache\\\";a:0:{}s:21:\\\"\\u0000*\\u0000attributeCastCache\\\";a:0:{}s:13:\\\"\\u0000*\\u0000dateFormat\\\";N;s:10:\\\"\\u0000*\\u0000appends\\\";a:0:{}s:19:\\\"\\u0000*\\u0000dispatchesEvents\\\";a:0:{}s:14:\\\"\\u0000*\\u0000observables\\\";a:0:{}s:12:\\\"\\u0000*\\u0000relations\\\";a:0:{}s:10:\\\"\\u0000*\\u0000touches\\\";a:0:{}s:10:\\\"timestamps\\\";b:1;s:13:\\\"usesUniqueIds\\\";b:0;s:9:\\\"\\u0000*\\u0000hidden\\\";a:0:{}s:10:\\\"\\u0000*\\u0000visible\\\";a:0:{}s:11:\\\"\\u0000*\\u0000fillable\\\";a:0:{}s:10:\\\"\\u0000*\\u0000guarded\\\";a:0:{}s:18:\\\"\\u0000*\\u0000isDependencyFor\\\";a:2:{s:18:\\\"App\\\\Models\\\\Product\\\";a:4:{s:11:\\\"local_index\\\";s:2:\\\"id\\\";s:10:\\\"local_name\\\";s:4:\\\"name\\\";s:13:\\\"foreign_index\\\";s:11:\\\"category_id\\\";s:12:\\\"foreign_name\\\";s:4:\\\"name\\\";}s:26:\\\"App\\\\Models\\\\ProductCategory\\\";a:4:{s:11:\\\"local_index\\\";s:2:\\\"id\\\";s:10:\\\"local_name\\\";s:4:\\\"name\\\";s:13:\\\"foreign_index\\\";s:9:\\\"parent_id\\\";s:12:\\\"foreign_name\\\";s:4:\\\"name\\\";}}}s:3:\\\"job\\\";N;s:10:\\\"attributes\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743904,1714743904),(2532,'default','{\"uuid\":\"8ae4aebc-75e2-4623-8226-e116f2aaedc5\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743911,1714743911),(2533,'default','{\"uuid\":\"4126822e-ef3b-4ddd-a9ac-55ac10bca86e\",\"displayName\":\"App\\\\Events\\\\NotificationDispatchedEvent\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":14:{s:5:\\\"event\\\";O:38:\\\"App\\\\Events\\\\NotificationDispatchedEvent\\\":1:{s:12:\\\"notification\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:23:\\\"App\\\\Models\\\\Notification\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}',0,NULL,1714743911,1714743911),(2534,'default','{\"uuid\":\"2c6711d7-b5f4-438b-8577-78f73bd5d209\",\"displayName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\",\"command\":\"O:44:\\\"App\\\\Jobs\\\\CheckTaskSchedulingConfigurationJob\\\":0:{}\"}}',0,NULL,1714743911,1714743911);

--
-- Table structure for table `ns_migrations`
--

CREATE TABLE `ns_migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_migrations`
--

INSERT INTO `ns_migrations` VALUES (1,'2018_08_08_100000_create_telescope_entries_table',1,NULL),(2,'2022_10_28_123458_setup_migration_table',1,NULL),(3,'2014_10_13_000000_create_users_table',0,'core'),(4,'2017_07_28_130434_create_roles_table',0,'core'),(5,'2017_07_28_130610_create_permissions_table',0,'core'),(6,'2018_08_08_100000_create_telescope_entries_table',0,'core'),(7,'2019_08_19_000000_create_failed_jobs_table',0,'core'),(8,'2020_06_20_000000_create_permissions',0,'core'),(9,'2020_06_20_000000_create_roles',0,'core'),(10,'2020_10_11_122857_create_jobs_table',0,'core'),(11,'2020_11_04_124040_add_new_customers_permission_nov4',0,'core'),(12,'2020_11_11_151614_nov11_create_nexopos_users_attributes_table',0,'core'),(13,'2020_11_12_205243_nov12_create_order_permission',0,'core'),(14,'2020_11_25_203531_nov25_fix_report_permissions_attribution',0,'core'),(15,'2020_12_08_210001_dec8add_new_permissions',0,'core'),(16,'2020_12_19_221434_create_nexopos_modules_migrations_table',0,'core'),(17,'2021_01_07_143635_add_new_customer_permission_janv7_21',0,'core'),(18,'2021_03_09_165538_create_new_permissions_march_9',0,'core'),(19,'2021_05_25_175424_update_add_payment_type_permissions',0,'core'),(20,'2021_05_28_114827_create_new_report_permissions_may28',0,'core'),(21,'2021_06_24_053134_update_permissions_jun24',0,'core'),(22,'2021_07_31_153029_update_dashboard_days_report_jul31',0,'core'),(23,'0000_00_00_000000_create_websockets_statistics_entries_table',0,'create'),(24,'2014_10_12_000000_create_medias_table',0,'create'),(25,'2017_12_29_174613_create_options_table',0,'create'),(26,'2020_06_20_000000_create_customers_groups_table',0,'create'),(27,'2020_06_20_000000_create_customers_table',0,'create'),(28,'2020_06_20_000000_create_expenses_categories_table',0,'create'),(29,'2020_06_20_000000_create_expenses_table',0,'create'),(30,'2020_06_20_000000_create_orders_addresses_table',0,'create'),(31,'2020_06_20_000000_create_orders_coupons_table',0,'create'),(32,'2020_06_20_000000_create_orders_metas_table',0,'create'),(33,'2020_06_20_000000_create_orders_payment_table',0,'create'),(34,'2020_06_20_000000_create_orders_products_table',0,'create'),(35,'2020_06_20_000000_create_orders_table',0,'create'),(36,'2020_06_20_000000_create_procurements_products_table',0,'create'),(37,'2020_06_20_000000_create_procurements_table',0,'create'),(38,'2020_06_20_000000_create_products_categories_table',0,'create'),(39,'2020_06_20_000000_create_products_gallery_table',0,'create'),(40,'2020_06_20_000000_create_products_history_table',0,'create'),(41,'2020_06_20_000000_create_products_metas_table',0,'create'),(42,'2020_06_20_000000_create_products_table',0,'create'),(43,'2020_06_20_000000_create_products_taxes_table',0,'create'),(44,'2020_06_20_000000_create_products_unit_quantities',0,'create'),(45,'2020_06_20_000000_create_providers_table',0,'create'),(46,'2020_06_20_000000_create_registers_history_table',0,'create'),(47,'2020_06_20_000000_create_registers_table',0,'create'),(48,'2020_06_20_000000_create_rewards_system_rules_table',0,'create'),(49,'2020_06_20_000000_create_rewards_system_table',0,'create'),(50,'2020_06_20_000000_create_taxes_table',0,'create'),(51,'2020_06_20_000000_create_units_group_table',0,'create'),(52,'2020_06_20_000000_create_units_table',0,'create'),(53,'2020_08_01_143801_create_customers_coupons_table',0,'create'),(54,'2020_10_10_224639_create_dashboard_table',0,'create'),(55,'2020_10_11_074631_create_nexopos_notifications_table',0,'create'),(56,'2020_10_17_231628_create_nexopos_orders_storage',0,'create'),(57,'2020_10_29_150642_create_nexopos_expenses_history_table',0,'create'),(58,'2020_11_17_120204_nov17_add_fields_to_nexopos_orders_products_table',0,'create'),(59,'2020_12_11_210734_create_nexopos_dashboard_months_table',0,'create'),(60,'2021_01_23_225101_create_coupons_table',0,'create'),(61,'2021_01_23_225713_create_customers_rewards_table',0,'create'),(62,'2021_02_21_144532_create_orders_instalments_table',0,'create'),(63,'2021_02_23_004748_create_new_instalments_permissions',0,'create'),(64,'2021_05_25_131104_create_nexopos_payments_types_table',0,'create'),(65,'2022_01_20_202253_create_user_role_relations_table',0,'create'),(66,'2022_05_13_142039_create_products_group_items_table',0,'create'),(67,'2022_10_12_083552_update_register_history_oct12_22',0,'create'),(68,'2022_10_28_093041_update_expense_table28_oct22',0,'create'),(69,'2022_11_25_071626_create_users_widgets_table',0,'create'),(70,'2023_10_31_120602_stock_history_detailed',0,'create'),(71,'2022_11_28_000259_v5x_general_database_update',0,'update'),(72,'2022_11_30_224820_update_orders_coupon_table',0,'update'),(73,'2023_02_14_123130_update_product_history_table14_fev23',0,'update'),(74,'2023_03_16_214039_update_expense_table',0,'update'),(75,'2023_07_30_235454_fix_wrong_purchase_price_32_jul_23',0,'update'),(76,'2024_01_26_075544_update_expenses_and_accounts',0,'update'),(77,'2024_01_26_165001_update_transaction_histories',0,'update'),(79,'2019_12_14_000001_create_personal_access_tokens_table',2,NULL),(80,'2024_04_24_175400_create_jobs_table',2,NULL);

--
-- Table structure for table `ns_nexopos_coupons`
--

CREATE TABLE `ns_nexopos_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'discount',
  `discount_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `valid_until` datetime DEFAULT NULL,
  `minimum_cart_value` double(18,5) DEFAULT '0.00000',
  `maximum_cart_value` double(18,5) DEFAULT '0.00000',
  `valid_hours_start` datetime DEFAULT NULL,
  `valid_hours_end` datetime DEFAULT NULL,
  `limit_usage` double(18,5) NOT NULL DEFAULT '0.00000',
  `groups_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customers_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons`
--


--
-- Table structure for table `ns_nexopos_coupons_categories`
--

CREATE TABLE `ns_nexopos_coupons_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_categories`
--


--
-- Table structure for table `ns_nexopos_coupons_customers`
--

CREATE TABLE `ns_nexopos_coupons_customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_customers`
--


--
-- Table structure for table `ns_nexopos_coupons_customers_groups`
--

CREATE TABLE `ns_nexopos_coupons_customers_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_customers_groups`
--


--
-- Table structure for table `ns_nexopos_coupons_products`
--

CREATE TABLE `ns_nexopos_coupons_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_coupons_products`
--


--
-- Table structure for table `ns_nexopos_customers_account_history`
--

CREATE TABLE `ns_nexopos_customers_account_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `previous_amount` double(8,2) NOT NULL DEFAULT '0.00',
  `amount` double(8,2) NOT NULL DEFAULT '0.00',
  `next_amount` double(8,2) NOT NULL DEFAULT '0.00',
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` int(11) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_account_history`
--


--
-- Table structure for table `ns_nexopos_customers_addresses`
--

CREATE TABLE `ns_nexopos_customers_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pobox` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_addresses`
--

INSERT INTO `ns_nexopos_customers_addresses` VALUES (1,7,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,'2024-04-24 16:37:14','2024-04-24 16:37:14'),(2,7,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,'2024-04-24 16:37:14','2024-04-24 16:37:14'),(3,8,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,'2024-04-30 08:09:55','2024-04-30 08:09:55'),(4,8,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,'2024-04-30 08:09:55','2024-04-30 10:13:51');

--
-- Table structure for table `ns_nexopos_customers_coupons`
--

CREATE TABLE `ns_nexopos_customers_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `usage` int(11) NOT NULL DEFAULT '0',
  `limit_usage` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_coupons`
--


--
-- Table structure for table `ns_nexopos_customers_groups`
--

CREATE TABLE `ns_nexopos_customers_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `reward_system_id` int(11) DEFAULT '0',
  `minimal_credit_payment` int(11) NOT NULL DEFAULT '0',
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_groups`
--

INSERT INTO `ns_nexopos_customers_groups` VALUES (1,'High Frequency',NULL,NULL,1000,5,NULL,'2024-04-24 16:36:22','2024-04-24 16:36:22');

--
-- Table structure for table `ns_nexopos_customers_rewards`
--

CREATE TABLE `ns_nexopos_customers_rewards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `reward_id` int(11) NOT NULL,
  `reward_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `points` double(18,5) NOT NULL,
  `target` double(18,5) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_customers_rewards`
--


--
-- Table structure for table `ns_nexopos_dashboard_days`
--

CREATE TABLE `ns_nexopos_dashboard_days` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `total_unpaid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_unpaid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_unpaid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_unpaid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_partially_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_partially_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_partially_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_partially_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_income` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_income` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_discounts` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_discounts` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_taxes` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_taxes` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_wasted_goods_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_wasted_goods_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_wasted_goods` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_wasted_goods` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_expenses` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_expenses` double(18,5) NOT NULL DEFAULT '0.00000',
  `day_of_year` int(11) NOT NULL DEFAULT '0',
  `range_starts` datetime DEFAULT NULL,
  `range_ends` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_dashboard_days`
--


--
-- Table structure for table `ns_nexopos_dashboard_months`
--

CREATE TABLE `ns_nexopos_dashboard_months` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `month_taxes` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_unpaid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_unpaid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_partially_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_partially_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_income` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_discounts` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_wasted_goods_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_wasted_goods` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_expenses` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_wasted_goods` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_unpaid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_unpaid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_partially_paid_orders` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_partially_paid_orders_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_income` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_discounts` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_taxes` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_wasted_goods_count` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_expenses` double(18,5) NOT NULL DEFAULT '0.00000',
  `month_of_year` int(11) NOT NULL DEFAULT '0',
  `range_starts` datetime NOT NULL,
  `range_ends` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_dashboard_months`
--


--
-- Table structure for table `ns_nexopos_dashboard_weeks`
--

CREATE TABLE `ns_nexopos_dashboard_weeks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `total_gross_income` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_taxes` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_expenses` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_net_income` double(18,5) NOT NULL DEFAULT '0.00000',
  `week_number` int(11) NOT NULL DEFAULT '0',
  `range_starts` datetime DEFAULT NULL,
  `range_ends` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_dashboard_weeks`
--


--
-- Table structure for table `ns_nexopos_gastro_areas`
--

CREATE TABLE `ns_nexopos_gastro_areas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_areas`
--

INSERT INTO `ns_nexopos_gastro_areas` VALUES (1,'Lobby North',NULL,5,'2024-04-24 16:29:11','2024-04-24 16:29:11'),(2,'Indoor',NULL,5,'2024-04-25 00:44:39','2024-04-25 00:44:39');

--
-- Table structure for table `ns_nexopos_gastro_kitchens`
--

CREATE TABLE `ns_nexopos_gastro_kitchens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `notification_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enabled',
  `notification_sound` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unavailable',
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_kitchens`
--

INSERT INTO `ns_nexopos_gastro_kitchens` VALUES (1,'Main Kitchen South',NULL,'enabled','https://pos.momentpay.live/modules/nsgastro/mp3/bell.mp3','enabled',5,'2024-04-24 16:28:33','2024-04-24 16:28:33'),(2,'Ground Floor','Only Day time','enabled','https://pos.momentpay.live/modules/nsgastro/mp3/bell.mp3','enabled',5,'2024-04-25 00:43:58','2024-04-25 00:43:58');

--
-- Table structure for table `ns_nexopos_gastro_kitchens_categories`
--

CREATE TABLE `ns_nexopos_gastro_kitchens_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kitchen_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_kitchens_categories`
--

INSERT INTO `ns_nexopos_gastro_kitchens_categories` VALUES (1,1,1,'2024-04-24 16:28:33','2024-04-24 16:28:33'),(2,2,1,'2024-04-25 00:43:58','2024-04-25 00:43:58');

--
-- Table structure for table `ns_nexopos_gastro_kitchens_printers`
--

CREATE TABLE `ns_nexopos_gastro_kitchens_printers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kitchen_id` int(11) NOT NULL,
  `printer_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `printer_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_kitchens_printers`
--


--
-- Table structure for table `ns_nexopos_gastro_modifiers_groups`
--

CREATE TABLE `ns_nexopos_gastro_modifiers_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `forced` tinyint(1) NOT NULL DEFAULT '0',
  `multiselect` tinyint(1) NOT NULL DEFAULT '0',
  `countable` tinyint(1) NOT NULL DEFAULT '0',
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_modifiers_groups`
--

INSERT INTO `ns_nexopos_gastro_modifiers_groups` VALUES (1,'Side Dish','This is extra mandatory side dish',1,1,1,8,'2024-05-03 09:13:14','2024-05-03 09:13:14');

--
-- Table structure for table `ns_nexopos_gastro_products_modifiers_groups`
--

CREATE TABLE `ns_nexopos_gastro_products_modifiers_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `modifier_group_id` int(10) unsigned NOT NULL,
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_products_modifiers_groups`
--

INSERT INTO `ns_nexopos_gastro_products_modifiers_groups` VALUES (1,41,1,0,'2024-05-03 09:15:04','2024-05-03 09:15:04');

--
-- Table structure for table `ns_nexopos_gastro_tables`
--

CREATE TABLE `ns_nexopos_gastro_tables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `preview` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unavailable',
  `allow_multi_clients` tinyint(1) NOT NULL DEFAULT '0',
  `seats` int(11) NOT NULL DEFAULT '0',
  `author` int(11) NOT NULL,
  `area_id` int(11) DEFAULT NULL,
  `booking_starts_at` datetime DEFAULT NULL,
  `booking_ends_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `busy` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_tables`
--

INSERT INTO `ns_nexopos_gastro_tables` VALUES (1,'First Floor Table-1',NULL,'https://pos.momentpay.live/storage/2024/04/chair.png','available',0,4,5,NULL,NULL,NULL,'2024-04-30 09:16:44','2024-04-30 10:02:10',0),(2,'First Floor Table-2',NULL,'https://pos.momentpay.live/storage/2024/04/chair.png','available',0,4,5,NULL,NULL,NULL,'2024-04-30 09:29:12','2024-04-30 11:36:40',1);

--
-- Table structure for table `ns_nexopos_gastro_tables_assigned_waiters`
--

CREATE TABLE `ns_nexopos_gastro_tables_assigned_waiters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `table_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_tables_assigned_waiters`
--

INSERT INTO `ns_nexopos_gastro_tables_assigned_waiters` VALUES (15,7,1,'2024-04-30 09:55:47','2024-04-30 09:55:47'),(16,5,1,'2024-04-30 09:55:47','2024-04-30 09:55:47'),(17,8,1,'2024-04-30 09:55:47','2024-04-30 09:55:47'),(19,7,2,'2024-04-30 09:57:23','2024-04-30 09:57:23'),(20,5,2,'2024-04-30 09:57:23','2024-04-30 09:57:23'),(21,8,2,'2024-04-30 09:57:23','2024-04-30 09:57:23');

--
-- Table structure for table `ns_nexopos_gastro_tables_booking_history`
--

CREATE TABLE `ns_nexopos_gastro_tables_booking_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `table_id` int(11) NOT NULL,
  `booking_time` datetime NOT NULL,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_tables_booking_history`
--


--
-- Table structure for table `ns_nexopos_gastro_tables_history`
--

CREATE TABLE `ns_nexopos_gastro_tables_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `table_id` int(11) NOT NULL,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_tables_history`
--


--
-- Table structure for table `ns_nexopos_gastro_tables_sessions`
--

CREATE TABLE `ns_nexopos_gastro_tables_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `table_id` int(11) NOT NULL,
  `session_starts` datetime DEFAULT NULL,
  `session_ends` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `session_minutes_duration` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_gastro_tables_sessions`
--

INSERT INTO `ns_nexopos_gastro_tables_sessions` VALUES (1,NULL,1,'2024-04-30 15:15:51','2024-04-30 15:32:10',0,16),(2,NULL,2,'2024-04-30 17:06:40',NULL,1,0);

--
-- Table structure for table `ns_nexopos_medias`
--

CREATE TABLE `ns_nexopos_medias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_medias_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=293 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_medias`
--

INSERT INTO `ns_nexopos_medias` VALUES (1,'logo','png','2024/04/logo',5,'2024-04-24 14:09:17','2024-04-24 14:09:17'),(2,'icon','png','2024/04/icon',5,'2024-04-24 14:12:03','2024-04-24 14:12:03'),(3,'combo-2','jpg','2024/04/combo-2',5,'2024-04-24 14:47:13','2024-04-24 14:47:13'),(4,'logo630650','png','2024/04/logo630650',5,'2024-04-24 16:24:41','2024-04-24 16:24:41'),(5,'logo-1','png','2024/04/logo-1',5,'2024-04-24 16:29:58','2024-04-24 16:29:58'),(7,'momentpos-removebg-preview','png','2024/04/momentpos-removebg-preview',5,'2024-04-30 08:17:55','2024-04-30 08:17:55'),(10,'chair','png','2024/04/chair',5,'2024-04-30 09:55:37','2024-04-30 09:55:37'),(11,'oldfox-logo','jpg','2024/05/oldfox-logo',8,'2024-05-01 22:17:38','2024-05-01 22:17:38'),(187,'americano-small','jpeg','2024/05/americano-small',8,'2024-05-02 02:07:29','2024-05-02 02:07:29'),(188,'add-chips-small572969','jpeg','2024/05/add-chips-small572969',8,'2024-05-02 02:07:29','2024-05-02 02:07:29'),(190,'baked-ham-english-mustard-small','jpeg','2024/05/baked-ham-english-mustard-small',8,'2024-05-02 02:08:18','2024-05-02 02:08:18'),(193,'dessert-of-the-day-ask-your-server-small','jpeg','2024/05/dessert-of-the-day-ask-your-server-small',8,'2024-05-02 02:08:26','2024-05-02 02:08:26'),(194,'add-chips-small','jpeg','2024/05/add-chips-small',8,'2024-05-02 02:12:50','2024-05-02 02:12:50'),(195,'americano-small651204','jpeg','2024/05/americano-small651204',8,'2024-05-02 02:12:52','2024-05-02 02:12:52'),(196,'baked-ham-english-mustard-small259341','jpeg','2024/05/baked-ham-english-mustard-small259341',8,'2024-05-02 02:12:59','2024-05-02 02:12:59'),(197,'breaded-scampi-small','jpeg','2024/05/breaded-scampi-small',8,'2024-05-02 02:13:01','2024-05-02 02:13:01'),(198,'cumberland-sausages-small','jpeg','2024/05/cumberland-sausages-small',8,'2024-05-02 02:13:03','2024-05-02 02:13:03'),(199,'dessert-of-the-day-ask-your-server-small129693','jpeg','2024/05/dessert-of-the-day-ask-your-server-small129693',8,'2024-05-02 02:13:05','2024-05-02 02:13:05'),(200,'english-breakfast-tea-small','jpeg','2024/05/english-breakfast-tea-small',8,'2024-05-02 02:13:07','2024-05-02 02:13:07'),(201,'free-range-fried-egg-small','jpeg','2024/05/free-range-fried-egg-small',8,'2024-05-02 02:13:14','2024-05-02 02:13:14'),(202,'house-salad-v-salads-small','jpeg','2024/05/house-salad-v-salads-small',8,'2024-05-02 02:13:19','2024-05-02 02:13:19'),(203,'ice-cream-bowl-small','jpeg','2024/05/ice-cream-bowl-small',8,'2024-05-02 02:13:23','2024-05-02 02:13:23'),(204,'mature-cheddar-red-onion-sun-dried-tomato-v-sandwiches-small','jpeg','2024/05/mature-cheddar-red-onion-sun-dried-tomato-v-sandwiches-small',8,'2024-05-02 02:13:29','2024-05-02 02:13:29'),(205,'ploughmans-lunch-salads-small','jpeg','2024/05/ploughmans-lunch-salads-small',8,'2024-05-02 02:13:34','2024-05-02 02:13:34'),(206,'sandwiches-spicy-chicken-strips-peppers-mixed-leafs-sweet-chilli-9aqx6-small','jpeg','2024/05/sandwiches-spicy-chicken-strips-peppers-mixed-leafs-sweet-chilli-9aqx6-small',8,'2024-05-02 02:13:37','2024-05-02 02:13:37'),(207,'soothing-mint-tea-small','jpeg','2024/05/soothing-mint-tea-small',8,'2024-05-02 02:13:40','2024-05-02 02:13:40'),(208,'spicy-chicken-strips-salads-small','jpeg','2024/05/spicy-chicken-strips-salads-small',8,'2024-05-02 02:13:43','2024-05-02 02:13:43'),(209,'sticky-toffee-pudding-ice-cream-small','jpeg','2024/05/sticky-toffee-pudding-ice-cream-small',8,'2024-05-02 02:13:46','2024-05-02 02:13:46'),(210,'veg-burgerv-breaded-vegetable-burger-sundried-tomato-peppers-ship-burgers-small','jpeg','2024/05/veg-burgerv-breaded-vegetable-burger-sundried-tomato-peppers-ship-burgers-small',8,'2024-05-02 02:13:50','2024-05-02 02:13:50'),(211,'wee-mini-beef-bun-burger-small','jpeg','2024/05/wee-mini-beef-bun-burger-small',8,'2024-05-02 02:13:54','2024-05-02 02:13:54'),(212,'apple-cinnamon-crumble-with-custard-small','jpeg','2024/05/apple-cinnamon-crumble-with-custard-small',8,'2024-05-02 02:20:39','2024-05-02 02:20:39'),(213,'spicy-bean-burger-v-cheddar-cheese-tomato-relish-ship-burgers-small','jpeg','2024/05/spicy-bean-burger-v-cheddar-cheese-tomato-relish-ship-burgers-small',8,'2024-05-02 02:26:06','2024-05-02 02:26:06'),(214,'shiraz','jpeg','2024/05/shiraz',8,'2024-05-02 02:40:40','2024-05-02 02:40:40'),(215,'prosecco','jpeg','2024/05/prosecco',8,'2024-05-02 02:40:43','2024-05-02 02:40:43'),(216,'pepsi','jpeg','2024/05/pepsi',8,'2024-05-02 02:40:46','2024-05-02 02:40:46'),(217,'lemonade','jpeg','2024/05/lemonade',8,'2024-05-02 02:40:49','2024-05-02 02:40:49'),(218,'orange-juice','jpeg','2024/05/orange-juice',8,'2024-05-02 02:40:52','2024-05-02 02:40:52'),(219,'tonic-water','jpeg','2024/05/tonic-water',8,'2024-05-02 02:40:56','2024-05-02 02:40:56'),(220,'soda-water','jpeg','2024/05/soda-water',8,'2024-05-02 02:40:58','2024-05-02 02:40:58'),(221,'ginger-beer','jpeg','2024/05/ginger-beer',8,'2024-05-02 02:41:01','2024-05-02 02:41:01'),(222,'chunky-chips-v-bbq-sauce','jpeg','2024/05/chunky-chips-v-bbq-sauce',8,'2024-05-02 02:41:05','2024-05-02 02:41:05'),(223,'ginger-beer924347','jpeg','2024/05/ginger-beer924347',8,'2024-05-02 02:41:47','2024-05-02 02:41:47'),(224,'cheesy-garlic-bread-v','jpeg','2024/05/cheesy-garlic-bread-v',8,'2024-05-02 02:41:57','2024-05-02 02:41:57'),(225,'home-made-sausage-roll','jpeg','2024/05/home-made-sausage-roll',8,'2024-05-02 02:41:59','2024-05-02 02:41:59'),(226,'laroe-onion-ringsv-garlic-mayo','jpeg','2024/05/laroe-onion-ringsv-garlic-mayo',8,'2024-05-02 02:42:07','2024-05-02 02:42:07'),(227,'english-ham-double-egg-chips','jpeg','2024/05/english-ham-double-egg-chips',8,'2024-05-02 02:42:21','2024-05-02 02:42:21'),(228,'beer-battered-fish-chips-garden-peas-tartare-sauce','jpeg','2024/05/beer-battered-fish-chips-garden-peas-tartare-sauce',8,'2024-05-02 02:42:32','2024-05-02 02:42:32'),(229,'english-pork-sausages-mash-potatoes-onion-gravy','jpeg','2024/05/english-pork-sausages-mash-potatoes-onion-gravy',8,'2024-05-02 02:42:38','2024-05-02 02:42:38'),(230,'breaded-scampi-chips-peas-tartare-sauce','jpeg','2024/05/breaded-scampi-chips-peas-tartare-sauce',8,'2024-05-02 02:42:42','2024-05-02 02:42:42'),(231,'13oz-sirloin-steak-chips-pass-lomato-onion-nines','jpeg','2024/05/13oz-sirloin-steak-chips-pass-lomato-onion-nines',8,'2024-05-02 02:42:47','2024-05-02 02:42:47'),(232,'classic-burger','jpeg','2024/05/classic-burger',8,'2024-05-02 02:42:50','2024-05-02 02:42:50'),(233,'marinated-free-range-chicken-breast','jpeg','2024/05/marinated-free-range-chicken-breast',8,'2024-05-02 02:42:53','2024-05-02 02:42:53'),(234,'black-blue-burger','jpeg','2024/05/black-blue-burger',8,'2024-05-02 02:42:56','2024-05-02 02:42:56'),(235,'shiraz137414','jpeg','2024/05/shiraz137414',8,'2024-05-02 02:54:43','2024-05-02 02:54:43'),(236,'snacks','jpeg','2024/05/snacks',8,'2024-05-02 03:05:18','2024-05-02 03:05:18'),(237,'sharing-platters','jpeg','2024/05/sharing-platters',8,'2024-05-02 03:05:21','2024-05-02 03:05:21'),(238,'british-pub-classics','jpeg','2024/05/british-pub-classics',8,'2024-05-02 03:05:24','2024-05-02 03:05:24'),(239,'ship-burgers','jpeg','2024/05/ship-burgers',8,'2024-05-02 03:05:26','2024-05-02 03:05:26'),(240,'salads','jpeg','2024/05/salads',8,'2024-05-02 03:05:29','2024-05-02 03:05:29'),(241,'sandwiches','jpeg','2024/05/sandwiches',8,'2024-05-02 03:05:31','2024-05-02 03:05:31'),(242,'childrens-choice','jpeg','2024/05/childrens-choice',8,'2024-05-02 03:05:34','2024-05-02 03:05:34'),(243,'dessert-menu','jpeg','2024/05/dessert-menu',8,'2024-05-02 03:05:36','2024-05-02 03:05:36'),(244,'hot-beverages','jpeg','2024/05/hot-beverages',8,'2024-05-02 03:05:39','2024-05-02 03:05:39'),(245,'bar-menu','jpeg','2024/05/bar-menu',8,'2024-05-02 03:05:42','2024-05-02 03:05:42'),(246,'vodka','jpeg','2024/05/vodka',8,'2024-05-02 03:05:44','2024-05-02 03:05:44'),(247,'whiskey','jpeg','2024/05/whiskey',8,'2024-05-02 03:05:47','2024-05-02 03:05:47'),(248,'bottles-and-craft-cans','jpeg','2024/05/bottles-and-craft-cans',8,'2024-05-02 03:05:50','2024-05-02 03:05:50'),(249,'gin','jpeg','2024/05/gin',8,'2024-05-02 03:05:52','2024-05-02 03:05:52'),(250,'on-tap','jpeg','2024/05/on-tap',8,'2024-05-02 03:05:57','2024-05-02 03:05:57'),(251,'shots','jpeg','2024/05/shots',8,'2024-05-02 03:06:00','2024-05-02 03:06:00'),(252,'rum','jpeg','2024/05/rum',8,'2024-05-02 03:06:03','2024-05-02 03:06:03'),(253,'wine-fizz','jpeg','2024/05/wine-fizz',8,'2024-05-02 03:06:06','2024-05-02 03:06:06'),(254,'other-liqueurs','jpeg','2024/05/other-liqueurs',8,'2024-05-02 03:06:10','2024-05-02 03:06:10'),(255,'malibu','jpeg','2024/05/malibu',8,'2024-05-02 03:26:59','2024-05-02 03:26:59'),(256,'amaretto','jpeg','2024/05/amaretto',8,'2024-05-02 03:27:01','2024-05-02 03:27:01'),(257,'archers','jpeg','2024/05/archers',8,'2024-05-02 03:27:03','2024-05-02 03:27:03'),(258,'baileys','jpeg','2024/05/baileys',8,'2024-05-02 03:27:04','2024-05-02 03:27:04'),(259,'brandy','jpeg','2024/05/brandy',8,'2024-05-02 03:27:10','2024-05-02 03:27:10'),(260,'pinot-grigio','jpeg','2024/05/pinot-grigio',8,'2024-05-02 03:27:12','2024-05-02 03:27:12'),(261,'chardonnay','jpeg','2024/05/chardonnay',8,'2024-05-02 03:27:14','2024-05-02 03:27:14'),(262,'pinot-blush','jpeg','2024/05/pinot-blush',8,'2024-05-02 03:27:16','2024-05-02 03:27:16'),(263,'bacardi','jpeg','2024/05/bacardi',8,'2024-05-02 03:27:18','2024-05-02 03:27:18'),(264,'captain-morgans','jpeg','2024/05/captain-morgans',8,'2024-05-02 03:27:21','2024-05-02 03:27:21'),(265,'dark-morgans','jpeg','2024/05/dark-morgans',8,'2024-05-02 03:27:23','2024-05-02 03:27:23'),(266,'krakken-spiced','jpeg','2024/05/krakken-spiced',8,'2024-05-02 03:27:25','2024-05-02 03:27:25'),(267,'cafe-patron','jpeg','2024/05/cafe-patron',8,'2024-05-02 03:27:26','2024-05-02 03:27:26'),(268,'tequila','jpeg','2024/05/tequila',8,'2024-05-02 03:27:28','2024-05-02 03:27:28'),(269,'tequila517437','jpeg','2024/05/tequila517437',8,'2024-05-02 03:27:31','2024-05-02 03:27:31'),(270,'jagermeister','jpeg','2024/05/jagermeister',8,'2024-05-02 03:27:33','2024-05-02 03:27:33'),(271,'sambucca','jpeg','2024/05/sambucca',8,'2024-05-02 05:55:08','2024-05-02 05:55:08'),(272,'bombay-sapphire','jpeg','2024/05/bombay-sapphire',8,'2024-05-02 05:55:09','2024-05-02 05:55:09'),(273,'tanqueray','jpeg','2024/05/tanqueray',8,'2024-05-02 05:55:12','2024-05-02 05:55:12'),(274,'hendricks','jpeg','2024/05/hendricks',8,'2024-05-02 05:55:15','2024-05-02 05:55:15'),(275,'plymouth','jpeg','2024/05/plymouth',8,'2024-05-02 05:55:18','2024-05-02 05:55:18'),(276,'whitely-neil-rhubarb','jpeg','2024/05/whitely-neil-rhubarb',8,'2024-05-02 05:55:20','2024-05-02 05:55:20'),(277,'peroni','jpeg','2024/05/peroni',8,'2024-05-02 05:55:23','2024-05-02 05:55:23'),(278,'corona','jpeg','2024/05/corona',8,'2024-05-02 05:55:26','2024-05-02 05:55:26'),(279,'guinness','jpeg','2024/05/guinness',8,'2024-05-02 05:55:28','2024-05-02 05:55:28'),(280,'bulmers','jpeg','2024/05/bulmers',8,'2024-05-02 05:55:31','2024-05-02 05:55:31'),(281,'thatchers-haze','jpeg','2024/05/thatchers-haze',8,'2024-05-02 05:55:33','2024-05-02 05:55:33'),(282,'kopparberg-mixed-fruit','jpeg','2024/05/kopparberg-mixed-fruit',8,'2024-05-02 05:55:36','2024-05-02 05:55:36'),(283,'jim-beam','jpeg','2024/05/jim-beam',8,'2024-05-02 05:55:38','2024-05-02 05:55:38'),(284,'jack-daniels','jpeg','2024/05/jack-daniels',8,'2024-05-02 05:55:42','2024-05-02 05:55:42'),(285,'johnny-walker','jpeg','2024/05/johnny-walker',8,'2024-05-02 05:55:44','2024-05-02 05:55:44'),(286,'glen-morray','jpeg','2024/05/glen-morray',8,'2024-05-02 05:55:50','2024-05-02 05:55:50'),(287,'smirnoff','jpeg','2024/05/smirnoff',8,'2024-05-02 05:55:53','2024-05-02 05:55:53'),(288,'absolute-vodka','jpeg','2024/05/absolute-vodka',8,'2024-05-02 05:55:56','2024-05-02 05:55:56'),(289,'ciroc','jpeg','2024/05/ciroc',8,'2024-05-02 05:55:58','2024-05-02 05:55:58'),(290,'grey-goose','jpeg','2024/05/grey-goose',8,'2024-05-02 05:56:00','2024-05-02 05:56:00'),(291,'beer-small','jpeg','2024/05/beer-small',8,'2024-05-02 06:13:33','2024-05-02 06:13:33'),(292,'softdrinks','jpeg','2024/05/softdrinks',8,'2024-05-02 06:15:15','2024-05-02 06:15:15');

--
-- Table structure for table `ns_nexopos_modules_migrations`
--

CREATE TABLE `ns_nexopos_modules_migrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_modules_migrations`
--

INSERT INTO `ns_nexopos_modules_migrations` VALUES (1,'NsGastro','NsGastro/Migrations/CreateAreasForTables.php'),(2,'NsGastro','NsGastro/Migrations/CreateKitchensForRestaurant.php'),(3,'NsGastro','NsGastro/Migrations/CreateModifiersGroupTables.php'),(4,'NsGastro','NsGastro/Migrations/CreateOrdersProductsModifiers.php'),(5,'NsGastro','NsGastro/Migrations/CreateOrdersProductsModifiersGroups.php'),(6,'NsGastro','NsGastro/Migrations/CreatePermissionsAndRolesForRestaurant.php'),(7,'NsGastro','NsGastro/Migrations/CreateProductModifierGroupTable.php'),(8,'NsGastro','NsGastro/Migrations/CreateTableAssignedWaitersTable.php'),(9,'NsGastro','NsGastro/Migrations/CreateTableSessionTable.php'),(10,'NsGastro','NsGastro/Migrations/CreateTablesForRestaurant.php'),(11,'NsGastro','NsGastro/Migrations/UpdateAddCanceledPrintedToOrdersProduct.php'),(12,'NsGastro','NsGastro/Migrations/UpdateAddConversionToProcurementProduct.php'),(13,'NsGastro','NsGastro/Migrations/UpdateCreateTimeStampOnAreasTable.php'),(14,'NsGastro','NsGastro/Migrations/UpdateDescriptionOnRestaurantTable.php'),(15,'NsGastro','NsGastro/Migrations/UpdateGastroKitchenTable.php'),(16,'NsGastro','NsGastro/Migrations/UpdateKitchenTable10Apr22.php'),(17,'NsGastro','NsGastro/Migrations/UpdateNexoposOrdersProductsModifiersTableMay21.php'),(18,'NsGastro','NsGastro/Migrations/UpdateOrderProductTableApr10.php'),(19,'NsGastro','NsGastro/Migrations/UpdateOrderProductTableApr5.php'),(20,'NsGastro','NsGastro/Migrations/UpdateOrderProductTableMar3.php'),(21,'NsGastro','NsGastro/Migrations/UpdateOrderProductTableMar32.php'),(22,'NsGastro','NsGastro/Migrations/UpdateOrderProductsMar28.php'),(23,'NsGastro','NsGastro/Migrations/UpdateOrderProductsModifiersApr11.php'),(24,'NsGastro','NsGastro/Migrations/UpdateOrderTableJul20.php'),(25,'NsGastro','NsGastro/Migrations/UpdateOrderTableJun7.php'),(26,'NsGastro','NsGastro/Migrations/UpdateOrderTableMar8.php'),(27,'NsGastro','NsGastro/Migrations/UpdateOrdersProductsTableMay22.php'),(28,'NsGastro','NsGastro/Migrations/UpdatePermissionsJul0422.php'),(29,'NsGastro','NsGastro/Migrations/UpdateProductTable20Dec21.php'),(30,'NsGastro','NsGastro/Migrations/UpdateProductTableFeb16.php'),(31,'NsGastro','NsGastro/Migrations/UpdateTableAddStatusMay29.php'),(32,'NsGastro','NsGastro/Migrations/UpdateToV5Migration.php');

--
-- Table structure for table `ns_nexopos_notifications`
--

CREATE TABLE `ns_nexopos_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#',
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system',
  `dismissable` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_notifications`
--

INSERT INTO `ns_nexopos_notifications` VALUES (8,5,'ns.notifications.workers-disabled','Task Scheduling Disabled','NexoPOS is unable to schedule background tasks. This might restrict necessary features. Click here to learn how to fix it.','https://my.nexopos.com/en/documentation/troubleshooting/workers-or-async-requests-disabled?utm_source=nexopos&utm_campaign=warning&utm_medium=app','system',1,'2024-04-30 09:37:45','2024-05-03 09:15:11'),(11,8,'ns.notifications.workers-disabled','Task Scheduling Disabled','NexoPOS is unable to schedule background tasks. This might restrict necessary features. Click here to learn how to fix it.','https://my.nexopos.com/en/documentation/troubleshooting/workers-or-async-requests-disabled?utm_source=nexopos&utm_campaign=warning&utm_medium=app','system',1,'2024-05-01 22:53:44','2024-05-03 09:15:11');

--
-- Table structure for table `ns_nexopos_orders_addresses`
--

CREATE TABLE `ns_nexopos_orders_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pobox` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_addresses`
--

INSERT INTO `ns_nexopos_orders_addresses` VALUES (1,1,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-24 16:37:50','2024-04-24 16:37:50'),(2,1,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-24 16:37:50','2024-04-24 16:37:50'),(3,2,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-25 00:47:53','2024-04-25 00:47:53'),(4,2,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-25 00:47:53','2024-04-25 00:47:53'),(5,2,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-25 00:53:17','2024-04-25 00:53:17'),(6,3,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-25 01:22:08','2024-04-25 01:22:08'),(7,3,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-25 01:22:08','2024-04-25 01:22:08'),(8,4,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 09:45:51','2024-04-30 09:45:51'),(9,4,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 09:45:51','2024-04-30 09:45:51'),(10,5,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 09:53:47','2024-04-30 09:53:47'),(11,5,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 09:53:47','2024-04-30 09:53:47'),(12,5,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 10:01:28','2024-04-30 10:01:28'),(13,4,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 10:02:10','2024-04-30 10:02:10'),(14,6,'shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 11:36:40','2024-04-30 11:36:40'),(15,6,'billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,'2024-04-30 11:36:40','2024-04-30 11:36:40');

--
-- Table structure for table `ns_nexopos_orders_count`
--

CREATE TABLE `ns_nexopos_orders_count` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `count` int(11) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_count`
--

INSERT INTO `ns_nexopos_orders_count` VALUES (1,2,'2024-04-24 00:00:00'),(2,3,'2024-04-25 00:00:00'),(3,4,'2024-04-30 00:00:00');

--
-- Table structure for table `ns_nexopos_orders_coupons`
--

CREATE TABLE `ns_nexopos_orders_coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_coupon_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount_value` double(18,5) NOT NULL,
  `minimum_cart_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `maximum_cart_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `limit_usage` int(11) NOT NULL DEFAULT '0',
  `value` double(18,5) NOT NULL DEFAULT '0.00000',
  `author` int(11) NOT NULL,
  `counted` tinyint(1) NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_coupons`
--


--
-- Table structure for table `ns_nexopos_orders_instalments`
--

CREATE TABLE `ns_nexopos_orders_instalments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` double(18,5) NOT NULL DEFAULT '0.00000',
  `order_id` int(11) DEFAULT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT '0',
  `payment_id` int(11) DEFAULT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_instalments`
--


--
-- Table structure for table `ns_nexopos_orders_payments`
--

CREATE TABLE `ns_nexopos_orders_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `value` double(18,5) NOT NULL DEFAULT '0.00000',
  `author` int(11) NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_payments`
--

INSERT INTO `ns_nexopos_orders_payments` VALUES (1,2,50.00000,5,'cash-payment',NULL,'2024-04-25 00:53:17','2024-04-25 00:53:17'),(2,5,25.00000,5,'Card',NULL,'2024-04-30 10:01:28','2024-04-30 10:01:28'),(3,4,100.00000,5,'cash-payment',NULL,'2024-04-30 10:02:10','2024-04-30 10:02:10');

--
-- Table structure for table `ns_nexopos_orders_products`
--

CREATE TABLE `ns_nexopos_orders_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal',
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'product',
  `product_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `unit_quantity_id` int(11) NOT NULL,
  `product_category_id` int(11) NOT NULL,
  `procurement_product_id` int(11) DEFAULT NULL,
  `tax_group_id` int(11) NOT NULL DEFAULT '0',
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sold',
  `return_observations` text COLLATE utf8mb4_unicode_ci,
  `return_condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none',
  `discount` double(18,5) NOT NULL DEFAULT '0.00000',
  `quantity` double(18,5) NOT NULL,
  `discount_percentage` double(18,5) NOT NULL DEFAULT '0.00000',
  `unit_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `price_with_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `price_without_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `wholesale_tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `sale_tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `rate` double(8,2) NOT NULL DEFAULT '0.00',
  `total_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_price_with_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_price_without_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_purchase_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `meal_cancelation_printed` tinyint(1) NOT NULL DEFAULT '0',
  `meal_cancelation_quantity` tinyint(1) NOT NULL DEFAULT '0',
  `order_product_id` int(11) DEFAULT NULL,
  `modifier_id` int(11) DEFAULT NULL,
  `meal_placed_by` int(11) DEFAULT NULL,
  `meal_placed_by_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_served_by` int(11) DEFAULT NULL,
  `meal_served_by_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_canceled_by` int(11) DEFAULT NULL,
  `meal_canceled_by_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_printed` tinyint(1) NOT NULL DEFAULT '0',
  `cooking_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `cooking_note` text COLLATE utf8mb4_unicode_ci,
  `cooking_cancelation_note` text COLLATE utf8mb4_unicode_ci,
  `modifiers_gross_total` double(8,2) NOT NULL DEFAULT '0.00',
  `modifiers_net_total` double(8,2) NOT NULL DEFAULT '0.00',
  `modifiers_total` double(8,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_products`
--

INSERT INTO `ns_nexopos_orders_products` VALUES (1,'Combo-1','qty','normal','product',1,1,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,75.00000,75.00000,75.00000,0.00000,0.00000,0.00000,0.00,75.00000,75.00000,75.00000,0.00000,'2024-04-24 16:37:50','2024-04-24 16:37:50',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'pending','',NULL,0.00,0.00,0.00),(2,'Burger','qty','normal','product',2,2,1,2,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,25.00000,25.00000,25.00000,0.00000,0.00000,0.00000,0.00,25.00000,25.00000,25.00000,0.00000,'2024-04-25 00:47:53','2024-04-25 00:51:54',0,0,NULL,NULL,5,'super_admin',5,'super_admin',NULL,NULL,0,'served','',NULL,0.00,0.00,0.00),(3,'Burger','qty','normal','product',2,2,1,2,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,25.00000,25.00000,25.00000,0.00000,0.00000,0.00000,0.00,25.00000,25.00000,25.00000,0.00000,'2024-04-25 00:47:53','2024-04-25 00:47:53',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'pending','',NULL,0.00,0.00,0.00),(4,'Combo-1','qty','normal','product',1,3,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,75.00000,75.00000,75.00000,0.00000,0.00000,0.00000,0.00,75.00000,75.00000,75.00000,0.00000,'2024-04-25 01:22:08','2024-05-02 03:39:07',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'served','',NULL,0.00,0.00,0.00),(5,'Burger','qty','normal','product',2,3,1,2,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,25.00000,25.00000,25.00000,0.00000,0.00000,0.00000,0.00,25.00000,25.00000,25.00000,0.00000,'2024-04-25 01:22:08','2024-05-02 03:39:07',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'served','',NULL,0.00,0.00,0.00),(6,'Combo-1','qty','normal','product',1,4,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,75.00000,75.00000,75.00000,0.00000,0.00000,0.00000,0.00,75.00000,75.00000,75.00000,0.00000,'2024-04-30 09:45:51','2024-05-02 03:39:07',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'served','',NULL,0.00,0.00,0.00),(7,'Burger','qty','normal','product',2,4,1,2,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,25.00000,25.00000,25.00000,0.00000,0.00000,0.00000,0.00,25.00000,25.00000,25.00000,0.00000,'2024-04-30 09:45:51','2024-05-02 03:39:05',0,0,NULL,NULL,5,'super_admin',8,'krishnap',NULL,NULL,0,'served','',NULL,0.00,0.00,0.00),(8,'Burger','qty','normal','product',2,5,1,2,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,25.00000,25.00000,25.00000,0.00000,0.00000,0.00000,0.00,25.00000,25.00000,25.00000,0.00000,'2024-04-30 09:53:47','2024-05-02 03:39:07',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'served','',NULL,0.00,0.00,0.00),(9,'Combo-1','qty','normal','product',1,6,1,1,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,75.00000,75.00000,75.00000,0.00000,0.00000,0.00000,0.00,75.00000,75.00000,75.00000,0.00000,'2024-04-30 11:36:40','2024-04-30 11:36:40',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'pending','',NULL,0.00,0.00,0.00),(10,'Burger','qty','normal','product',2,6,1,2,1,NULL,0,'disabled',NULL,'sold',NULL,NULL,'percentage',0.00000,1.00000,0.00000,25.00000,25.00000,25.00000,0.00000,0.00000,0.00000,0.00,25.00000,25.00000,25.00000,0.00000,'2024-04-30 11:36:40','2024-04-30 11:36:40',0,0,NULL,NULL,5,'super_admin',NULL,NULL,NULL,NULL,0,'pending','',NULL,0.00,0.00,0.00);

--
-- Table structure for table `ns_nexopos_orders_products_modifiers`
--

CREATE TABLE `ns_nexopos_orders_products_modifiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_product_id` int(11) NOT NULL,
  `modifier_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_product_modifier_group_id` int(11) NOT NULL,
  `unit_price` double(8,2) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `quantity` double(8,2) NOT NULL,
  `total_price` double(8,2) NOT NULL,
  `tax_value` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `unit_quantity_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_products_modifiers`
--


--
-- Table structure for table `ns_nexopos_orders_products_modifiers_groups`
--

CREATE TABLE `ns_nexopos_orders_products_modifiers_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_product_id` int(11) NOT NULL,
  `modifier_group_id` int(11) NOT NULL,
  `multiselect` tinyint(1) NOT NULL,
  `countable` tinyint(1) NOT NULL,
  `forced` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_products_modifiers_groups`
--


--
-- Table structure for table `ns_nexopos_orders_products_refunds`
--

CREATE TABLE `ns_nexopos_orders_products_refunds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `order_refund_id` int(11) NOT NULL,
  `order_product_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `unit_price` double(18,5) NOT NULL,
  `tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `quantity` double(18,5) NOT NULL,
  `total_price` double(18,5) NOT NULL,
  `condition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_products_refunds`
--


--
-- Table structure for table `ns_nexopos_orders_refunds`
--

CREATE TABLE `ns_nexopos_orders_refunds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `author` int(11) NOT NULL,
  `total` double(18,5) NOT NULL,
  `tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `shipping` double(18,5) NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_refunds`
--


--
-- Table structure for table `ns_nexopos_orders_storage`
--

CREATE TABLE `ns_nexopos_orders_storage` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `unit_quantity_id` int(11) DEFAULT NULL,
  `unit_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `session_identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_storage`
--


--
-- Table structure for table `ns_nexopos_orders_taxes`
--

CREATE TABLE `ns_nexopos_orders_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `rate` double(8,2) NOT NULL,
  `tax_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_value` double(8,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_orders_taxes`
--


--
-- Table structure for table `ns_nexopos_payments_types`
--

CREATE TABLE `ns_nexopos_payments_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `readonly` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_payments_types`
--

INSERT INTO `ns_nexopos_payments_types` VALUES (1,'Cash','cash-payment',0,NULL,5,1,1,'2024-04-24 12:09:15','2024-04-24 12:09:15'),(2,'Bank Payment','bank-payment',0,NULL,5,1,1,'2024-04-24 12:09:15','2024-04-24 12:09:15'),(3,'Customer Account','account-payment',0,NULL,5,1,1,'2024-04-24 12:09:15','2024-04-24 12:09:15'),(4,'Card','Card',1,'Credit /Debit Cards',5,1,0,'2024-04-30 08:03:18','2024-04-30 08:03:18');

--
-- Table structure for table `ns_nexopos_permissions`
--

CREATE TABLE `ns_nexopos_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_permissions_name_unique` (`name`),
  UNIQUE KEY `ns_nexopos_permissions_namespace_unique` (`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_permissions`
--

INSERT INTO `ns_nexopos_permissions` VALUES (1,'Create Users','create.users','Can create users','2024-04-24 12:09:07','2024-04-24 12:09:07'),(2,'Read Users','read.users','Can read users','2024-04-24 12:09:07','2024-04-24 12:09:07'),(3,'Update Users','update.users','Can update users','2024-04-24 12:09:07','2024-04-24 12:09:07'),(4,'Delete Users','delete.users','Can delete users','2024-04-24 12:09:07','2024-04-24 12:09:07'),(5,'Create Roles','create.roles','Can create roles','2024-04-24 12:09:07','2024-04-24 12:09:07'),(6,'Read Roles','read.roles','Can read roles','2024-04-24 12:09:07','2024-04-24 12:09:07'),(7,'Update Roles','update.roles','Can update roles','2024-04-24 12:09:07','2024-04-24 12:09:07'),(8,'Delete Roles','delete.roles','Can delete roles','2024-04-24 12:09:07','2024-04-24 12:09:07'),(9,'Update Core','update.core','Can update core','2024-04-24 12:09:07','2024-04-24 12:09:07'),(10,'Manage Profile','manage.profile','Can manage profile','2024-04-24 12:09:07','2024-04-24 12:09:07'),(11,'Manage Modules','manage.modules','Can manage module : install, delete, update, migrate, enable, disable','2024-04-24 12:09:07','2024-04-24 12:09:07'),(12,'Manage Options','manage.options','Can manage options : read, update','2024-04-24 12:09:07','2024-04-24 12:09:07'),(13,'View Dashboard','read.dashboard','Can access the dashboard and see metrics','2024-04-24 12:09:07','2024-04-24 12:09:07'),(14,'Upload Medias','nexopos.upload.medias','Let the user upload medias.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(15,'See Medias','nexopos.see.medias','Let the user see medias.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(16,'Delete Medias','nexopos.delete.medias','Let the user delete medias.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(17,'Update Medias','nexopos.update.medias','Let the user update uploaded medias.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(18,'Create Categories','nexopos.create.categories','Let the user create products categories.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(19,'Delete Categories','nexopos.delete.categories','Let the user delete products categories.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(20,'Update Categories','nexopos.update.categories','Let the user update products categories.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(21,'Read Categories','nexopos.read.categories','Let the user read products categories.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(22,'Create Customers','nexopos.create.customers','Let the user create customers.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(23,'Delete Customers','nexopos.delete.customers','Let the user delete customers.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(24,'Update Customers','nexopos.update.customers','Let the user update customers.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(25,'Read Customers','nexopos.read.customers','Let the user read customers.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(26,'Import Customers','nexopos.import.customers','Let the user import customers.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(27,'Manage Customer Account History','nexopos.customers.manage-account-history','Can add, deduct amount from each customers account.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(28,'Create Customers Groups','nexopos.create.customers-groups','Let the user create Customers Groups','2024-04-24 12:09:07','2024-04-24 12:09:07'),(29,'Delete Customers Groups','nexopos.delete.customers-groups','Let the user delete Customers Groups','2024-04-24 12:09:07','2024-04-24 12:09:07'),(30,'Update Customers Groups','nexopos.update.customers-groups','Let the user update Customers Groups','2024-04-24 12:09:07','2024-04-24 12:09:07'),(31,'Read Customers Groups','nexopos.read.customers-groups','Let the user read Customers Groups','2024-04-24 12:09:07','2024-04-24 12:09:07'),(32,'Create Coupons','nexopos.create.coupons','Let the user create coupons','2024-04-24 12:09:07','2024-04-24 12:09:07'),(33,'Delete Coupons','nexopos.delete.coupons','Let the user delete coupons','2024-04-24 12:09:07','2024-04-24 12:09:07'),(34,'Update Coupons','nexopos.update.coupons','Let the user update coupons','2024-04-24 12:09:07','2024-04-24 12:09:07'),(35,'Read Coupons','nexopos.read.coupons','Let the user read coupons','2024-04-24 12:09:07','2024-04-24 12:09:07'),(36,'Create Transaction Account','nexopos.create.transactions-account','Let the user create transactions account','2024-04-24 12:09:07','2024-04-24 12:09:07'),(37,'Delete Transactions Account','nexopos.delete.transactions-account','Let the user delete Transaction Account','2024-04-24 12:09:07','2024-04-24 12:09:07'),(38,'Update Transactions Account','nexopos.update.transactions-account','Let the user update Transaction Account','2024-04-24 12:09:07','2024-04-24 12:09:07'),(39,'Read Transactions Account','nexopos.read.transactions-account','Let the user read Transaction Account','2024-04-24 12:09:07','2024-04-24 12:09:07'),(40,'Create Transaction','nexopos.create.transactions','Let the user create transactions','2024-04-24 12:09:07','2024-04-24 12:09:07'),(41,'Delete Transaction','nexopos.delete.transactions','Let the user delete transactions','2024-04-24 12:09:07','2024-04-24 12:09:07'),(42,'Update Transaction','nexopos.update.transactions','Let the user update transactions','2024-04-24 12:09:07','2024-04-24 12:09:07'),(43,'Read Transaction','nexopos.read.transactions','Let the user read transactions','2024-04-24 12:09:07','2024-04-24 12:09:07'),(44,'Read Transactions History','nexopos.read.transactions-history','Give access to the transactions history.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(45,'Delete Transactions History','nexopos.delete.transactions-history','Allow to delete an Transactions History.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(46,'Update Transactions History','nexopos.update.transactions-history','Allow to the Transactions History.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(47,'Create Transactions History','nexopos.create.transactions-history','Allow to create a Transactions History.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(48,'Create Orders','nexopos.create.orders','Let the user create orders','2024-04-24 12:09:07','2024-04-24 12:09:07'),(49,'Delete Orders','nexopos.delete.orders','Let the user delete orders','2024-04-24 12:09:07','2024-04-24 12:09:07'),(50,'Update Orders','nexopos.update.orders','Let the user update orders','2024-04-24 12:09:07','2024-04-24 12:09:07'),(51,'Read Orders','nexopos.read.orders','Let the user read orders','2024-04-24 12:09:07','2024-04-24 12:09:07'),(52,'Void Order','nexopos.void.orders','Let the user void orders','2024-04-24 12:09:07','2024-04-24 12:09:07'),(53,'Refund Order','nexopos.refund.orders','Let the user refund orders','2024-04-24 12:09:07','2024-04-24 12:09:07'),(54,'Make Payment To orders','nexopos.make-payment.orders','Allow the user to make payments to orders.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(55,'Create Procurements','nexopos.create.procurements','Let the user create procurements','2024-04-24 12:09:07','2024-04-24 12:09:07'),(56,'Delete Procurements','nexopos.delete.procurements','Let the user delete procurements','2024-04-24 12:09:07','2024-04-24 12:09:07'),(57,'Update Procurements','nexopos.update.procurements','Let the user update procurements','2024-04-24 12:09:07','2024-04-24 12:09:07'),(58,'Read Procurements','nexopos.read.procurements','Let the user read procurements','2024-04-24 12:09:07','2024-04-24 12:09:07'),(59,'Create Providers','nexopos.create.providers','Let the user create providers','2024-04-24 12:09:07','2024-04-24 12:09:07'),(60,'Delete Providers','nexopos.delete.providers','Let the user delete providers','2024-04-24 12:09:07','2024-04-24 12:09:07'),(61,'Update Providers','nexopos.update.providers','Let the user update providers','2024-04-24 12:09:07','2024-04-24 12:09:07'),(62,'Read Providers','nexopos.read.providers','Let the user read providers','2024-04-24 12:09:07','2024-04-24 12:09:07'),(63,'Create Products','nexopos.create.products','Let the user create products','2024-04-24 12:09:07','2024-04-24 12:09:07'),(64,'Delete Products','nexopos.delete.products','Let the user delete products','2024-04-24 12:09:07','2024-04-24 12:09:07'),(65,'Update Products','nexopos.update.products','Let the user update products','2024-04-24 12:09:07','2024-04-24 12:09:07'),(66,'Read Products','nexopos.read.products','Let the user read products','2024-04-24 12:09:07','2024-04-24 12:09:07'),(67,'Read Product History','nexopos.read.products-history','Let the user read products history','2024-04-24 12:09:07','2024-04-24 12:09:07'),(68,'Adjust Product Stock','nexopos.make.products-adjustments','Let the user adjust product stock.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(69,'Create Product Units/Unit Group','nexopos.create.products-units','Let the user create products units.','2024-04-24 12:09:07','2024-04-24 12:09:07'),(70,'Read Product Units/Unit Group','nexopos.read.products-units','Let the user read products units.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(71,'Update Product Units/Unit Group','nexopos.update.products-units','Let the user update products units.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(72,'Delete Product Units/Unit Group','nexopos.delete.products-units','Let the user delete products units.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(73,'Create Registers','nexopos.create.registers','Let the user create registers','2024-04-24 12:09:08','2024-04-24 12:09:08'),(74,'Delete Registers','nexopos.delete.registers','Let the user delete registers','2024-04-24 12:09:08','2024-04-24 12:09:08'),(75,'Update Registers','nexopos.update.registers','Let the user update registers','2024-04-24 12:09:08','2024-04-24 12:09:08'),(76,'Read Registers','nexopos.read.registers','Let the user read registers','2024-04-24 12:09:08','2024-04-24 12:09:08'),(77,'Read Registers History','nexopos.read.registers-history','Let the user read registers history','2024-04-24 12:09:08','2024-04-24 12:09:08'),(78,'Read Use Registers','nexopos.use.registers','Let the user use registers','2024-04-24 12:09:08','2024-04-24 12:09:08'),(79,'Create Rewards','nexopos.create.rewards','Let the user create Rewards','2024-04-24 12:09:08','2024-04-24 12:09:08'),(80,'Delete Rewards','nexopos.delete.rewards','Let the user delete Rewards','2024-04-24 12:09:08','2024-04-24 12:09:08'),(81,'Update Rewards','nexopos.update.rewards','Let the user update Rewards','2024-04-24 12:09:08','2024-04-24 12:09:08'),(82,'Read Rewards','nexopos.read.rewards','Let the user read Rewards','2024-04-24 12:09:08','2024-04-24 12:09:08'),(83,'Create Taxes','nexopos.create.taxes','Let the user create taxes','2024-04-24 12:09:08','2024-04-24 12:09:08'),(84,'Delete Taxes','nexopos.delete.taxes','Let the user delete taxes','2024-04-24 12:09:08','2024-04-24 12:09:08'),(85,'Update Taxes','nexopos.update.taxes','Let the user update taxes','2024-04-24 12:09:08','2024-04-24 12:09:08'),(86,'Read Taxes','nexopos.read.taxes','Let the user read taxes','2024-04-24 12:09:08','2024-04-24 12:09:08'),(87,'See Sale Report','nexopos.reports.sales','Let you see the sales report','2024-04-24 12:09:08','2024-04-24 12:09:08'),(88,'See Products Report','nexopos.reports.products-report','Let you see the Products report','2024-04-24 12:09:08','2024-04-24 12:09:08'),(89,'See Best Report','nexopos.reports.best_sales','Let you see the best_sales report','2024-04-24 12:09:08','2024-04-24 12:09:08'),(90,'See Transaction Report','nexopos.reports.transactions','Let you see the transactions report','2024-04-24 12:09:08','2024-04-24 12:09:08'),(91,'See Yearly Sales','nexopos.reports.yearly','Allow to see the yearly sales.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(92,'See Customers','nexopos.reports.customers','Allow to see the customers','2024-04-24 12:09:08','2024-04-24 12:09:08'),(93,'See Inventory Tracking','nexopos.reports.inventory','Allow to see the inventory','2024-04-24 12:09:08','2024-04-24 12:09:08'),(94,'See Customers Statement','nexopos.reports.customers-statement','Allow to see the customers statement.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(95,'Read Sales by Payment Types','nexopos.reports.payment-types','Let the user read the report that shows sales by payment types.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(96,'Read Low Stock Report','nexopos.reports.low-stock','Let the user read the report that shows low stock.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(97,'Read Stock History','nexopos.reports.stock-history','Let the user read the stock history report.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(98,'Manage Order Payments','nexopos.manage-payments-types','Allow to create, update and delete payments type.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(99,'Edit Purchase Price','nexopos.pos.edit-purchase-price','Let the user edit the purchase price of products.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(100,'Edit Order Settings','nexopos.pos.edit-settings','Let the user edit the order settings.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(101,'Edit Product Discounts','nexopos.pos.products-discount','Let the user add discount on products.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(102,'Edit Cart Discounts','nexopos.pos.cart-discount','Let the user add discount on cart.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(103,'Widget: Incomplete Sale Card Widget','nexopos.see.incomplete-sale-card-widget','Will display a card of current and overall incomplete sales.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(104,'Widget: Expense Card Widget','nexopos.see.expense-card-widget','Will display a card of current and overwall expenses.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(105,'Widget: Sale Card Widget','nexopos.see.sale-card-widget','Will display current and overall sales.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(106,'Widget: Best Customers','nexopos.see.best-customers-widget','Will display all customers with the highest purchases.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(107,'Widget: Profile','nexopos.see.profile-widget','Will display a profile widget with user stats.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(108,'Widget: Orders Chart','nexopos.see.orders-chart-widget','Will display a chart of weekly sales.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(109,'Widget: Orders Summary','nexopos.see.orders-summary-widget','Will display a summary of recent sales.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(110,'Widget: Best Cashiers','nexopos.see.best-cashier-widget','Will display all cashiers who performs well.','2024-04-24 12:09:08','2024-04-24 12:09:08'),(111,'Read Cash Flow History','nexopos.read.cash-flow-history','Allow to the Cash Flow History.','2024-04-24 12:09:10','2024-04-24 12:09:10'),(112,'Delete Expense History','nexopos.delete.cash-flow-history','Allow to delete an expense history.','2024-04-24 12:09:10','2024-04-24 12:09:10'),(113,'Manage Customers Account','nexopos.customers.manage-account','Allow to manage customer virtual deposit account.','2024-04-24 12:09:10','2024-04-24 12:09:10'),(114,'Create Products Labels','nexopos.create.products-labels','Allow the user to create products labels','2024-04-24 12:09:10','2024-04-24 12:09:10'),(115,'Create Instalment','nexopos.create.orders-instalments','Allow the user to create instalments.','2024-04-24 12:09:14','2024-04-24 12:09:14'),(116,'Update Instalment','nexopos.update.orders-instalments','Allow the user to update instalments.','2024-04-24 12:09:14','2024-04-24 12:09:14'),(117,'Read Instalment','nexopos.read.orders-instalments','Allow the user to read instalments.','2024-04-24 12:09:14','2024-04-24 12:09:14'),(118,'Delete Instalment','nexopos.delete.orders-instalments','Allow the user to delete instalments.','2024-04-24 12:09:14','2024-04-24 12:09:14'),(119,'Create Restaurant Table','gastro.create.table','Allow the user to create a restaurant table.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(120,'Read Restaurant Table','gastro.read.table','Allow the user to read a restaurant table.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(121,'Update Restaurant Table','gastro.update.table','Allow the user to update a restaurant table.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(122,'Delete Restaurant Table','gastro.delete.table','Allow the user to delete a restaurant table.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(123,'Create Restaurant Kitchens','gastro.create.kitchens','Allow the user to create a restaurant kitchens.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(124,'Read Restaurant Kitchens','gastro.read.kitchens','Allow the user to read a restaurant kitchens.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(125,'Update Restaurant Kitchens','gastro.update.kitchens','Allow the user to update a restaurant kitchens.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(126,'Delete Restaurant Kitchens','gastro.delete.kitchens','Allow the user to delete a restaurant kitchens.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(127,'Use Restaurant Kitchens','gastro.use.kitchens','Allow the user to delete a restaurant kitchens.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(128,'Cancel Meals','gastro.cancel.meals','Allow the user to cancel the meal.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(129,'Serve Meals','gastro.serve.meals','Allow the user to serve the meal.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(130,'Update Meals Note','gastro.update.meals-note','Allow the user to update meal note.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(131,'Create Restaurant Modifiers Groups','gastro.create.modifiers-groups','Allow the user to create a restaurant modifiers groups.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(132,'Read Restaurant Modifiers Groups','gastro.read.modifiers-groups','Allow the user to read a restaurant modifiers groups.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(133,'Update Restaurant Modifiers Groups','gastro.update.modifiers-groups','Allow the user to update a restaurant modifiers groups.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(134,'Delete Restaurant Modifiers Groups','gastro.delete.modifiers-groups','Allow the user to delete a restaurant modifiers groups.','2024-04-24 12:40:37','2024-04-24 12:40:37'),(137,'Manage Activity Logs','gastro.manage.logs','Allow the user to manage the activity logs.','2024-04-24 13:39:12','2024-04-24 13:39:12'),(138,'Allow Order Edition','gastro.edit.orders','Allow the user to edit saved orders.','2024-04-24 13:39:12','2024-04-24 13:39:12');

--
-- Table structure for table `ns_nexopos_procurements`
--

CREATE TABLE `ns_nexopos_procurements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_id` int(11) NOT NULL,
  `value` double(18,5) NOT NULL DEFAULT '0.00000',
  `cost` double(18,5) NOT NULL DEFAULT '0.00000',
  `tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `invoice_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `automatic_approval` tinyint(1) DEFAULT '0',
  `delivery_time` datetime DEFAULT NULL,
  `invoice_date` datetime DEFAULT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid',
  `delivery_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `total_items` int(11) NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_procurements`
--

INSERT INTO `ns_nexopos_procurements` VALUES (1,'GreyGoose-Vendor',1,0.00000,0.00000,0.00000,'90909',1,'2024-05-02 00:00:00','2024-05-02 00:00:00','paid','delivered',0,NULL,8,NULL,'2024-05-02 11:09:23','2024-05-02 11:09:23'),(2,'GreyGoose-Vendor',1,0.00000,0.00000,0.00000,'90909',1,'2024-05-02 00:00:00','2024-05-02 00:00:00','paid','delivered',0,NULL,8,NULL,'2024-05-02 11:09:33','2024-05-02 11:09:33'),(3,'GreyGoose-Vendor-2',1,0.00000,0.00000,0.00000,'90902',1,'2024-05-02 00:00:00','2024-05-02 00:00:00','paid','delivered',0,NULL,8,NULL,'2024-05-02 11:12:55','2024-05-02 11:12:55'),(4,'GreyGoose-Vendor-2',1,43500.00000,0.00000,0.00000,'90902',1,'2024-05-02 00:00:00','2024-05-02 00:00:00','paid','delivered',2,NULL,8,NULL,'2024-05-02 11:13:42','2024-05-02 11:13:42'),(5,'GreyGoose-Vendor-2',1,43500.00000,355000.00000,59166.66667,'90902',1,'2024-05-02 00:00:00','2024-05-02 00:00:00','paid','delivered',2,NULL,8,NULL,'2024-05-02 11:14:26','2024-05-02 11:14:26');

--
-- Table structure for table `ns_nexopos_procurements_products`
--

CREATE TABLE `ns_nexopos_procurements_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gross_purchase_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `net_purchase_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `procurement_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `purchase_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `quantity` double(18,5) NOT NULL,
  `available_quantity` double(18,5) NOT NULL,
  `tax_group_id` int(11) NOT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `total_purchase_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `unit_id` int(11) NOT NULL,
  `convert_unit_id` int(11) DEFAULT NULL,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_procurements_products`
--

INSERT INTO `ns_nexopos_procurements_products` VALUES (1,'Grey Goose',0.00000,0.00000,4,6,0.00000,5000.00000,5000.00000,1,'gbTBefTEQS-001-001',NULL,'inclusive',0.00000,0.00000,1,NULL,8,NULL,'2024-05-02 11:13:42','2024-05-02 11:13:42'),(2,'Smirnoff',0.00000,0.00000,4,3,0.00000,5000.00000,5000.00000,1,'18OnUHHOVy-001-002',NULL,'exclusive',0.00000,0.00000,1,1,8,NULL,'2024-05-02 11:13:42','2024-05-02 11:13:42'),(3,'Grey Goose',5.00000,4.16667,5,6,5.00000,5000.00000,5000.00000,1,'gbTBefTEQS-001-003',NULL,'inclusive',4166.66667,25000.00000,1,NULL,8,NULL,'2024-05-02 11:14:26','2024-05-02 11:14:26'),(4,'Smirnoff',66.00000,55.00000,5,3,66.00000,5000.00000,5000.00000,1,'18OnUHHOVy-001-004',NULL,'exclusive',55000.00000,330000.00000,1,1,8,NULL,'2024-05-02 11:14:26','2024-05-02 11:14:26');

--
-- Table structure for table `ns_nexopos_products`
--

CREATE TABLE `ns_nexopos_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_group_id` int(11) DEFAULT NULL,
  `tax_value` double(18,5) NOT NULL DEFAULT '0.00000',
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'product',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tangible',
  `accurate_tracking` tinyint(1) NOT NULL DEFAULT '0',
  `auto_cogs` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `stock_management` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enabled',
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `barcode_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `thumbnail_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `unit_group` int(11) NOT NULL,
  `on_expiration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'prevent_sales',
  `expires` tinyint(1) NOT NULL DEFAULT '0',
  `searchable` tinyint(1) NOT NULL DEFAULT '1',
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `skip_cooking` tinyint(1) NOT NULL DEFAULT '0',
  `modifiers_group_id` int(11) DEFAULT NULL,
  `modifiers_groups` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gastro_item_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products`
--

INSERT INTO `ns_nexopos_products` VALUES (1,'Combo-1','inclusive',NULL,0.00000,'product','materialized',0,1,'unavailable','disabled','987657890','code128','9876',NULL,NULL,1,0,1,'prevent-sales',0,1,5,NULL,'2024-04-24 14:50:57','2024-05-02 03:14:11',0,0,'','product'),(2,'Burger','inclusive',NULL,0.00000,'product','materialized',0,1,'unavailable','disabled','987654678','code128','9878',NULL,NULL,1,0,1,'prevent-sales',0,1,5,NULL,'2024-04-25 00:46:40','2024-05-02 03:14:11',0,0,'','product'),(3,'Smirnoff','exclusive',1,0.00000,'product','materialized',0,1,'available','enabled','18OnUHHOVy','code128','vodka--smirnoff--4rakf',NULL,NULL,12,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:42:16','2024-05-02 11:08:45',1,0,'','product'),(4,'Absolute Vodka','inclusive',NULL,0.00000,'product','materialized',0,1,'available','disabled','iaWGL7Kcv8','code128','vodka--absolute-vodka--ZwSC2',NULL,NULL,12,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:43:38','2024-05-02 09:19:58',0,0,'','product'),(5,'Ciroc','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','RokNpdvDwL','code128','vodka--ciroc--wiyuR',NULL,NULL,12,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:44:22','2024-05-02 06:11:03',0,0,'','product'),(6,'Grey Goose','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','gbTBefTEQS','code128','vodka--grey-goose--dIECF',NULL,NULL,12,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:45:00','2024-05-02 06:11:19',0,0,'','product'),(7,'Jim Beam','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','mpmEDyB4c2','code128','whiskey--jim-beam--aJZCL',NULL,NULL,13,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:45:38','2024-05-02 06:07:31',0,0,'','product'),(8,'Jack Daniels','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','BcWfm1KoKf','code128','whiskey--jack-daniels--YGQZS',NULL,NULL,13,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:46:35','2024-05-02 06:07:52',0,0,'','product'),(9,'Johnny Walker','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','VCx9PFvqWK','code128','whiskey--johnny-walker--R5t4b',NULL,NULL,13,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:47:04','2024-05-02 06:08:24',0,0,'','product'),(10,'Glen Morray','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','h5qNNpvalQ','code128','whiskey--glen-morray--sg2Xj',NULL,NULL,13,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:47:45','2024-05-02 06:08:41',0,0,'','product'),(11,'Peroni','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','rKGKQhfny6','code128','bottles-and-craft-cans--peroni--oc0Ri',NULL,NULL,14,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:50:44','2024-05-02 06:02:35',0,0,'','product'),(12,'Corona','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','dlefnEChl3','code128','bottles-and-craft-cans--corona--bImqy',NULL,NULL,14,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:51:15','2024-05-02 06:03:05',0,0,'','product'),(13,'Guinness','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','LvGDQfEvOk','code128','bottles-and-craft-cans--guinness--fmYqC',NULL,NULL,14,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:52:18','2024-05-02 06:03:29',0,0,'','product'),(14,'Bulmers','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','tcyE9VY3IJ','code128','bottles-and-craft-cans--bulmers--zn23k',NULL,NULL,14,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:53:31','2024-05-02 06:03:52',0,0,'','product'),(15,'Thatcher\'s Haze','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','DpLfMLgP0H','code128','bottles-and-craft-cans--thatchers-haze--1scIg',NULL,NULL,14,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:54:37','2024-05-02 06:04:36',0,0,'','product'),(16,'Kopparberg Mixed Fruit','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','cNG4ykA28x','code128','bottles-and-craft-cans--kopparberg-mixed-fruit--SGncS',NULL,NULL,14,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:55:35','2024-05-02 06:04:58',0,0,'','product'),(17,'Bombay Sapphire','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','x94rfdCLue','code128','gin--bombay-sapphire--dNsqc',NULL,NULL,15,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:56:08','2024-05-02 05:58:36',0,0,'','product'),(18,'Tanqueray','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','Ln4N9levpc','code128','gin--tanqueray--7jeTx',NULL,NULL,15,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:56:46','2024-05-02 05:59:01',0,0,'','product'),(19,'Hendrick\'s','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','3gQ3Ta8J5j','code128','gin--hendricks--7DYn2',NULL,NULL,15,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:57:12','2024-05-02 05:59:29',0,0,'','product'),(20,'Plymouth','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','n1CjFM3fa0','code128','gin--plymouth--L039K',NULL,NULL,15,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:57:43','2024-05-02 05:59:52',0,0,'','product'),(21,'Whitely Neil Rhubarb','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','9cfmsjzod1','code128','gin--whitely-neil-rhubarb--JUMFk',NULL,NULL,15,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:58:15','2024-05-02 06:00:14',0,0,'','product'),(22,'Cafe Patron','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','acvnfyyoX5','code128','shots--cafe-patron--RVMUK',NULL,NULL,17,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:58:41','2024-05-02 06:00:51',0,0,'','product'),(23,'Tequila','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','0KetaPgXZO','code128','shots--tequila--hqXYy',NULL,NULL,17,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:59:14','2024-05-02 06:01:26',0,0,'','product'),(24,'Jagermeister','inclusive',NULL,0.00000,'product','materialized',0,1,'available','disabled','dVszsJEhiU','code128','shots--jagermeister--apjV8',NULL,NULL,17,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 22:59:47','2024-05-02 09:20:26',0,0,'','product'),(25,'Sambucca','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','gQwNpzK5hy','code128','shots--sambucca--W80hB',NULL,NULL,17,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:00:15','2024-05-02 05:57:06',0,0,'','product'),(26,'Malibu','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','1iwydwtwDE','code128','other-liqueurs--malibu--OoNTs',NULL,NULL,20,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:00:51','2024-05-02 03:28:09',0,0,'','product'),(27,'Amaretto','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','pR9VEY0486','code128','other-liqueurs--amaretto--kwq9o',NULL,NULL,20,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:01:23','2024-05-02 03:27:49',0,0,'','product'),(28,'Archer\'s','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','4FvUxHkOgy','code128','other-liqueurs--archers--Q8JTo',NULL,NULL,20,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:01:51','2024-05-02 03:28:29',0,0,'','product'),(29,'Bailey\'s','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','HHLXvd5RPr','code128','other-liqueurs--baileys--WJERg',NULL,NULL,20,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:02:29','2024-05-02 03:28:48',0,0,'','product'),(30,'Brandy','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','og3S3nNExJ','code128','other-liqueurs--brandy--BPhTO',NULL,NULL,20,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:02:56','2024-05-02 03:29:07',0,0,'','product'),(31,'Bacardi','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','YHyxsHNZGJ','code128','rum--bacardi--cBa8T',NULL,NULL,18,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:03:27','2024-05-02 03:29:32',0,0,'','product'),(32,'Captain Morgan\'s','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','14mm7sqJHp','code128','rum--captain-morgans--20dzv',NULL,NULL,18,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:03:58','2024-05-02 03:29:51',0,0,'','product'),(33,'Dark Morgan\'s','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','FQXr58QQ2G','code128','rum--dark-morgans--X1ezm',NULL,NULL,18,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:04:32','2024-05-02 03:30:09',0,0,'','product'),(34,'Krakken Spiced','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','FW2XzWEHTI','code128','rum--krakken-spiced--i7FnC',NULL,NULL,18,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:04:59','2024-05-02 03:30:31',0,0,'','product'),(35,'Krakken Spiced','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','H3AxPxYvOc','code128','rum--krakken-spiced--NIEOn',NULL,NULL,18,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:05:26','2024-05-02 03:31:21',0,0,'','product'),(36,'Pinot Grigio','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','Qph5ByABry','code128','wine-fizz--pinot-grigio--WNFbn',NULL,NULL,19,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:05:58','2024-05-02 03:31:57',0,0,'','product'),(37,'Chardonnay','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','Mf77kkUPZt','code128','wine-fizz--chardonnay--W5f72',NULL,NULL,19,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:06:24','2024-05-02 03:32:27',0,0,'','product'),(38,'Pinot Blush','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','dJcNSQKhEh','code128','wine-fizz--pinot-blush--keEil',NULL,NULL,19,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:07:31','2024-05-02 03:32:50',0,0,'','product'),(39,'Shiraz','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','G93xFhWskv','code128','wine-fizz--shiraz--XDwpu',NULL,NULL,19,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:08:14','2024-05-02 03:33:16',0,0,'','product'),(40,'Prosecco','inclusive',NULL,0.00000,'product','materialized',0,1,'available','disabled','UoQIEedufr','code128','wine-fizz--prosecco--FSFyB',NULL,NULL,19,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:09:15','2024-05-02 09:20:46',0,0,'','product'),(41,'Pepsi','inclusive',NULL,0.00000,'product','materialized',0,1,'available','disabled','20rWR8EYby','code128','soft-drinks--pepsi--0A17W',NULL,NULL,21,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:11:01','2024-05-03 09:15:04',1,0,'[1]','product'),(42,'lemonade','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','DBHRfxcP8T','code128','soft-drinks--lemonade--jWfEl',NULL,NULL,21,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:11:38','2024-05-02 06:15:22',0,0,'','product'),(43,'Orange Juice','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','8E9IDugYyp','code128','soft-drinks--orange-juice--UXzE3',NULL,NULL,21,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:12:09','2024-05-02 06:15:22',0,0,'','product'),(44,'Tonic Water','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','5PoUZ9oJuY','code128','soft-drinks--tonic-water--BWU8s',NULL,NULL,21,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:12:49','2024-05-02 06:15:22',0,0,'','product'),(45,'Soda Water','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','NEwGqg6MAU','code128','soft-drinks--soda-water--kCDT8',NULL,NULL,21,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:13:19','2024-05-02 06:15:22',0,0,'','product'),(46,'Ginger Beer','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','lhYh3ziAq3','code128','soft-drinks--ginger-beer--GRpiI',NULL,NULL,21,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:13:49','2024-05-02 06:15:22',0,0,'','product'),(47,'Chunky Chips (v) BBQ sauce','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','eDjLgrOdz3','code128','snacks--chunky-chips-v-bbq-sauce--dIH4E',NULL,NULL,2,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:14:39','2024-05-02 03:06:29',0,0,'','product'),(48,'Cheesy Garlic Bread (v)','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','XMu4Glwz6w','code128','snacks--cheesy-garlic-bread-v--5zlth',NULL,NULL,2,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:15:35','2024-05-02 03:06:29',0,0,'','product'),(49,'Home Made Sausage Roll','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','M82x1HM3Lk','code128','snacks--home-made-sausage-roll--MSePp',NULL,NULL,2,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:16:38','2024-05-02 03:06:29',0,0,'','product'),(50,'Large Onion Rings(v) garlic mayo','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','oV1zCPHavd','code128','snacks--laroe-onion-ringsv-garlic-mayo--lLXKR',NULL,NULL,2,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:17:23','2024-05-02 03:06:29',0,0,'','product'),(51,'English Ham, double Egg & Chips','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','WqmSlWuahG','code128','british-pub-classics--english-ham-double-egg-chips--52aAM',NULL,NULL,4,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:20:10','2024-05-02 03:07:21',0,0,'','product'),(52,'Beer Battered Fish & Chips, garden Peas & Tartare sauce','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','xfNOIT3BQG','code128','british-pub-classics--beer-battered-fish-chips-garden-peas-tartare-sauce--90cUZ',NULL,NULL,4,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:20:49','2024-05-02 03:07:21',0,0,'','product'),(53,'English Pork Sausages & Mash potatoes & onion Gravy','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','rpJA3jJML6','code128','british-pub-classics--english-pork-sausages-mash-potatoes-onion-gravy--2dzDy',NULL,NULL,4,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:21:17','2024-05-02 03:07:21',0,0,'','product'),(54,'Breaded Scampi, Chips, Peas & Tartare Sauce','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','NETkz8ATSb','code128','british-pub-classics--breaded-scampi-chips-peas-tartare-sauce--jc5Kh',NULL,NULL,4,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:21:52','2024-05-02 03:07:21',0,0,'','product'),(55,'13oz Sirloin steak. Chips Pass Lomato & onion nines','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','rwRs93yBLk','code128','british-pub-classics--13oz-sirloin-steak-chips-pass-lomato-onion-nines--VYJ1T',NULL,NULL,4,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:22:22','2024-05-02 03:07:21',0,0,'','product'),(56,'Classic Burger','inclusive',NULL,0.00000,'product','materialized',0,1,'available','disabled','dqu7s0RIv8','code128','ship-burgers--classic-burger--RswIJ',NULL,NULL,5,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:23:48','2024-05-02 09:19:08',0,0,'','product'),(57,'Marinated Free-Range Chicken Breast','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','R9hejyy0Qp','code128','ship-burgers--marinated-free-range-chicken-breast--Aj0nX',NULL,NULL,5,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:24:43','2024-05-02 06:18:30',0,0,'','product'),(58,'Black & Blue Burger','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','Q8dJul0icr','code128','ship-burgers--black-blue-burger--ldTkf',NULL,NULL,5,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:25:33','2024-05-02 06:18:30',0,0,'','product'),(59,'Veg Burger(v) - Breaded Vegetable Burger, Sundried Tomato, Peppers','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','nwIRwpGKjF','code128','ship-burgers--veg-burgerv-breaded-vegetable-burger-sundried-tomato-peppers--kwWTP',NULL,NULL,5,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:26:19','2024-05-02 06:18:30',0,0,'','product'),(60,'Spicy Bean Burger (v) Cheddar Cheese, Tomato Relish','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','iRfgc5WJQn','code128','ship-burgers--spicy-bean-burger-v-cheddar-cheese-tomato-relish--dXu2c',NULL,NULL,5,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:27:11','2024-05-02 06:18:30',0,0,'','product'),(61,'Spicy Chicken Strips','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','hOTwsqYdji','code128','salads--spicy-chicken-strips--wl4bI','Spicy Chicken Strips on a bed of Lettuce, Tomatoes, red Onion\n& mixed Peppers with Garlic Mayo dressing',NULL,6,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:28:03','2024-05-02 03:07:57',0,0,'','product'),(62,'Ploughman\'s Lunch','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','6UxfUyzaag','code128','salads--ploughmans-lunch--AUQQf','Ploughman\'s Lunch\nMature\nCheddar & Baked Ham,\nPiccalilli, Pickles, Lettuce, Tomato & crusty Bread',NULL,6,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:28:37','2024-05-02 03:07:57',0,0,'','product'),(63,'House Salad (v)','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','Y2XIacICyz','code128','salads--house-salad-v--7Q3xF','House Salad (v) - Sundried Tomato, Lettuce leafs,\nCucumber, Red Onion, Peppers, Pumpkin Seeds &\n1Balsamic Dressing',NULL,6,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:29:13','2024-05-02 03:07:57',0,0,'','product'),(64,'Mature Cheddar, red onion, Sun dried tomato (v)','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','ZIadTtq5lx','code128','sandwiches--mature-cheddar-red-onion-sun-dried-tomato-v--S47MZ',NULL,NULL,7,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:32:03','2024-05-02 03:08:12',0,0,'','product'),(65,'Spicy chicken strips, peppers, mixed leafs, sweet chilli','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','2QJlZpp6jJ','code128','sandwiches--spicy-chicken-strips-peppers-mixed-leafs-sweet-chilli--9aqx6',NULL,NULL,7,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:32:37','2024-05-02 03:08:12',0,0,'','product'),(66,'Baked ham, English mustard','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','1GXtl6nqtS','code128','sandwiches--baked-ham-english-mustard--DrUf4',NULL,NULL,7,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:33:16','2024-05-02 03:08:12',0,0,'','product'),(67,'Add Chips','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','Pj4dNX5D1j','code128','sandwiches--add-chips--M7HU9',NULL,NULL,7,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:33:41','2024-05-02 03:08:12',0,0,'','product'),(68,'Breaded Scampi','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','SeWPMtzjvU','code128','childrens-choice--breaded-scampi--Jitac',NULL,NULL,8,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:34:22','2024-05-02 03:08:33',0,0,'','product'),(69,'Cumberland Sausages','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','if7RxZ0P4n','code128','childrens-choice--cumberland-sausages--kP7cF',NULL,NULL,8,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:34:58','2024-05-02 03:08:33',0,0,'','product'),(70,'Free Range fried Egg','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','qxYmhxURKo','code128','childrens-choice--free-range-fried-egg--paBFa',NULL,NULL,8,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:35:26','2024-05-02 03:08:33',0,0,'','product'),(71,'Wee Mini Beef & Bun Burger','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','bZrcb67tno','code128','childrens-choice--wee-mini-beef-bun-burger--seYxu',NULL,NULL,8,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:35:59','2024-05-02 03:08:33',0,0,'','product'),(72,'Sticky Toffee Pudding & Ice-Cream','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','JGorTBUq2q','code128','dessert-menu--sticky-toffee-pudding-ice-cream--F7Uvb',NULL,NULL,9,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:36:40','2024-05-02 03:08:53',0,0,'','product'),(73,'Apple & Cinnamon Crumble with Custard','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','6td4yH3j9E','code128','dessert-menu--apple-cinnamon-crumble-with-custard--WVLNL',NULL,NULL,9,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:37:06','2024-05-02 03:08:53',0,0,'','product'),(74,'Dessert of the Day (ask your server)','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','o7WRLxyNqm','code128','dessert-menu--dessert-of-the-day-ask-your-server--aJGeR',NULL,NULL,9,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:37:42','2024-05-02 03:08:53',0,0,'','product'),(75,'Ice Cream Bowl','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','4daFytJB3t','code128','dessert-menu--ice-cream-bowl--TPK9z',NULL,NULL,9,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:38:12','2024-05-02 03:08:53',0,0,'','product'),(76,'English Breakfast Tea','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','grV4cDcVrt','code128','hot-beverages--english-breakfast-tea--XMkHA',NULL,NULL,10,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:39:46','2024-05-02 03:09:12',0,0,'','product'),(77,'Soothing Mint Tea','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','rUiXhoe3HH','code128','hot-beverages--soothing-mint-tea--eDtrB',NULL,NULL,10,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:40:16','2024-05-02 03:09:12',0,0,'','product'),(78,'Americano','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','wHcDlrpZeI','code128','hot-beverages--americano--T5KyG',NULL,NULL,10,0,1,'prevent-sales',0,1,8,NULL,'2024-05-01 23:40:50','2024-05-02 03:09:12',0,0,'','product'),(79,'Beer','inclusive',NULL,0.00000,'product','materialized',0,1,'available','enabled','5EyrxMCBMK','code128','on-tap--beer--9o92V',NULL,NULL,16,0,1,'prevent-sales',0,1,8,NULL,'2024-05-02 06:12:35','2024-05-02 06:13:43',0,0,'','product');

--
-- Table structure for table `ns_nexopos_products_categories`
--

CREATE TABLE `ns_nexopos_products_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT '0',
  `media_id` int(11) NOT NULL DEFAULT '0',
  `preview_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `displays_on_pos` tinyint(1) NOT NULL DEFAULT '1',
  `total_items` int(11) NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_categories`
--

INSERT INTO `ns_nexopos_products_categories` VALUES (1,'Beverage',NULL,0,NULL,0,2,NULL,8,NULL,'2024-04-24 14:42:15','2024-05-02 03:15:08'),(2,'Snacks',NULL,0,'https://pos.momentpay.live/storage/2024/05/snacks.jpeg',1,4,NULL,8,NULL,'2024-05-01 22:22:08','2024-05-02 03:15:17'),(3,'Sharing Platters',NULL,0,'https://pos.momentpay.live/storage/2024/05/sharing-platters.jpeg',0,0,NULL,8,NULL,'2024-05-01 22:23:11','2024-05-01 22:23:11'),(4,'British Pub Classics',NULL,0,'https://pos.momentpay.live/storage/2024/05/british-pub-classics.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:23:23','2024-05-01 22:23:23'),(5,'FOX Burgers',NULL,0,'https://pos.momentpay.live/storage/2024/05/ship-burgers.jpeg',1,0,'Served in a Sesame Seed Bap with Lettuce leaves, beef tomato, onion &amp; gherkin, chunky chips and home made coleslaw on the side.&nbsp;100% beef steak Patty from award winning buchers',8,NULL,'2024-05-01 22:23:34','2024-05-01 22:23:34'),(6,'Salads',NULL,0,'https://pos.momentpay.live/storage/2024/05/salads.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:23:52','2024-05-01 22:23:52'),(7,'Sandwiches',NULL,0,'https://pos.momentpay.live/storage/2024/05/sandwiches.jpeg',1,0,'Available on a fresh ciabatta or seeded brown bread with home-made colesow cornist',8,NULL,'2024-05-01 22:24:06','2024-05-01 22:24:06'),(8,'Children\'s Choice',NULL,0,'https://pos.momentpay.live/storage/2024/05/childrens-choice.jpeg',1,0,'Served with a choice of two&nbsp; Mash potato&nbsp; Chunky Chips&nbsp; &nbsp;Salad&nbsp; Baked Beans&nbsp; Garden Peas and Sweetcorn',8,NULL,'2024-05-01 22:25:28','2024-05-01 22:25:28'),(9,'Dessert Menu',NULL,0,'https://pos.momentpay.live/storage/2024/05/dessert-menu.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:25:40','2024-05-01 22:25:40'),(10,'Hot Beverages',NULL,0,'https://pos.momentpay.live/storage/2024/05/hot-beverages.jpeg',1,0,'Served with a sweet biscuit',8,NULL,'2024-05-01 22:26:03','2024-05-01 22:26:03'),(11,'Bar Menu',NULL,0,'https://pos.momentpay.live/storage/2024/05/bar-menu.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:29:33','2024-05-01 22:29:33'),(12,'Vodka',11,0,'https://pos.momentpay.live/storage/2024/05/vodka.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:30:26','2024-05-01 22:30:26'),(13,'Whiskey',11,0,'https://pos.momentpay.live/storage/2024/05/whiskey.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:30:44','2024-05-01 22:30:44'),(14,'Bottles and Craft Cans',11,0,'https://pos.momentpay.live/storage/2024/05/bottles-and-craft-cans.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:31:04','2024-05-01 22:31:04'),(15,'Gin',11,0,'https://pos.momentpay.live/storage/2024/05/gin.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:31:37','2024-05-01 22:31:37'),(16,'On Tap',11,0,'https://pos.momentpay.live/storage/2024/05/on-tap.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:31:53','2024-05-01 22:31:53'),(17,'Shots',11,0,'https://pos.momentpay.live/storage/2024/05/shots.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:32:07','2024-05-01 22:32:07'),(18,'Rum',11,0,'https://pos.momentpay.live/storage/2024/05/rum.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:32:24','2024-05-01 22:32:24'),(19,'Wine & Fizz',11,0,'https://pos.momentpay.live/storage/2024/05/wine-fizz.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:32:42','2024-05-01 22:32:42'),(20,'Other Liqueurs',11,0,'https://pos.momentpay.live/storage/2024/05/other-liqueurs.jpeg',1,0,NULL,8,NULL,'2024-05-01 22:33:28','2024-05-01 22:33:28'),(21,'Soft Drinks',NULL,0,'https://pos.momentpay.live/storage/2024/05/softdrinks.jpeg',1,0,NULL,8,NULL,'2024-05-01 23:10:17','2024-05-01 23:10:17');

--
-- Table structure for table `ns_nexopos_products_galleries`
--

CREATE TABLE `ns_nexopos_products_galleries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` int(11) NOT NULL,
  `media_id` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_galleries`
--

INSERT INTO `ns_nexopos_products_galleries` VALUES (1,NULL,1,NULL,'https://pos.momentpay.live/storage/2024/04/combo-2.jpg',0,1,5,NULL,'2024-04-24 14:50:57','2024-04-24 14:50:57'),(2,NULL,2,NULL,'https://pos.momentpay.live/storage/2024/04/combo-2.jpg',0,1,5,NULL,'2024-04-25 00:46:41','2024-04-25 00:46:41'),(3,NULL,78,NULL,'https://pos.momentpay.live/storage/2024/05/americano-small651204.jpeg',0,1,8,NULL,'2024-05-02 02:16:25','2024-05-02 02:16:25'),(5,NULL,77,NULL,'https://pos.momentpay.live/storage/2024/05/soothing-mint-tea-small.jpeg',0,0,8,NULL,'2024-05-02 02:17:33','2024-05-02 02:17:33'),(6,NULL,76,NULL,'https://pos.momentpay.live/storage/2024/05/english-breakfast-tea-small.jpeg',0,1,8,NULL,'2024-05-02 02:17:58','2024-05-02 02:17:58'),(7,NULL,75,NULL,'https://pos.momentpay.live/storage/2024/05/ice-cream-bowl-small.jpeg',0,0,8,NULL,'2024-05-02 02:18:37','2024-05-02 02:18:37'),(8,NULL,74,NULL,'https://pos.momentpay.live/storage/2024/05/dessert-of-the-day-ask-your-server-small.jpeg',0,1,8,NULL,'2024-05-02 02:19:17','2024-05-02 02:19:17'),(9,NULL,73,NULL,'https://pos.momentpay.live/storage/2024/05/apple-cinnamon-crumble-with-custard-small.jpeg',0,1,8,NULL,'2024-05-02 02:20:48','2024-05-02 02:20:48'),(10,NULL,72,NULL,'https://pos.momentpay.live/storage/2024/05/sticky-toffee-pudding-ice-cream-small.jpeg',0,1,8,NULL,'2024-05-02 02:21:16','2024-05-02 02:21:16'),(11,NULL,71,NULL,'https://pos.momentpay.live/storage/2024/05/wee-mini-beef-bun-burger-small.jpeg',0,1,8,NULL,'2024-05-02 02:21:41','2024-05-02 02:21:41'),(12,NULL,70,NULL,'https://pos.momentpay.live/storage/2024/05/free-range-fried-egg-small.jpeg',0,0,8,NULL,'2024-05-02 02:22:08','2024-05-02 02:22:08'),(13,NULL,69,NULL,'https://pos.momentpay.live/storage/2024/05/cumberland-sausages-small.jpeg',0,0,8,NULL,'2024-05-02 02:22:32','2024-05-02 02:22:32'),(14,NULL,68,NULL,'https://pos.momentpay.live/storage/2024/05/breaded-scampi-small.jpeg',0,1,8,NULL,'2024-05-02 02:23:02','2024-05-02 02:23:02'),(15,NULL,67,NULL,'https://pos.momentpay.live/storage/2024/05/add-chips-small.jpeg',0,1,8,NULL,'2024-05-02 02:23:29','2024-05-02 02:23:29'),(16,NULL,66,NULL,'https://pos.momentpay.live/storage/2024/05/baked-ham-english-mustard-small259341.jpeg',0,1,8,NULL,'2024-05-02 02:24:17','2024-05-02 02:24:17'),(17,NULL,65,NULL,'https://pos.momentpay.live/storage/2024/05/spicy-chicken-strips-salads-small.jpeg',0,0,8,NULL,'2024-05-02 02:25:04','2024-05-02 02:25:04'),(18,NULL,60,NULL,'https://pos.momentpay.live/storage/2024/05/spicy-bean-burger-v-cheddar-cheese-tomato-relish-ship-burgers-small.jpeg',0,1,8,NULL,'2024-05-02 02:26:14','2024-05-02 02:26:14'),(19,NULL,64,NULL,'https://pos.momentpay.live/storage/2024/05/mature-cheddar-red-onion-sun-dried-tomato-v-sandwiches-small.jpeg',0,1,8,NULL,'2024-05-02 02:27:02','2024-05-02 02:27:02'),(20,NULL,63,NULL,'https://pos.momentpay.live/storage/2024/05/house-salad-v-salads-small.jpeg',0,1,8,NULL,'2024-05-02 02:27:31','2024-05-02 02:27:31'),(21,NULL,62,NULL,'https://pos.momentpay.live/storage/2024/05/ploughmans-lunch-salads-small.jpeg',0,1,8,NULL,'2024-05-02 02:28:04','2024-05-02 02:28:04'),(22,NULL,61,NULL,'https://pos.momentpay.live/storage/2024/05/spicy-chicken-strips-salads-small.jpeg',0,0,8,NULL,'2024-05-02 02:29:09','2024-05-02 02:29:09'),(23,NULL,59,NULL,'https://pos.momentpay.live/storage/2024/05/veg-burgerv-breaded-vegetable-burger-sundried-tomato-peppers-ship-burgers-small.jpeg',0,0,8,NULL,'2024-05-02 02:29:44','2024-05-02 02:29:44'),(24,NULL,58,NULL,'https://pos.momentpay.live/storage/2024/05/black-blue-burger.jpeg',0,1,8,NULL,'2024-05-02 02:45:38','2024-05-02 02:45:38'),(25,NULL,57,NULL,'https://pos.momentpay.live/storage/2024/05/marinated-free-range-chicken-breast.jpeg',0,1,8,NULL,'2024-05-02 02:46:19','2024-05-02 02:46:19'),(28,NULL,55,NULL,'https://pos.momentpay.live/storage/2024/05/13oz-sirloin-steak-chips-pass-lomato-onion-nines.jpeg',0,1,8,NULL,'2024-05-02 02:47:11','2024-05-02 02:47:11'),(29,NULL,54,NULL,'https://pos.momentpay.live/storage/2024/05/breaded-scampi-chips-peas-tartare-sauce.jpeg',0,0,8,NULL,'2024-05-02 02:47:36','2024-05-02 02:47:36'),(30,NULL,53,NULL,'https://pos.momentpay.live/storage/2024/05/english-pork-sausages-mash-potatoes-onion-gravy.jpeg',0,0,8,NULL,'2024-05-02 02:48:19','2024-05-02 02:48:19'),(31,NULL,52,NULL,'https://pos.momentpay.live/storage/2024/05/beer-battered-fish-chips-garden-peas-tartare-sauce.jpeg',0,1,8,NULL,'2024-05-02 02:48:43','2024-05-02 02:48:43'),(32,NULL,51,NULL,'https://pos.momentpay.live/storage/2024/05/english-ham-double-egg-chips.jpeg',0,0,8,NULL,'2024-05-02 02:49:07','2024-05-02 02:49:07'),(33,NULL,50,NULL,'https://pos.momentpay.live/storage/2024/05/laroe-onion-ringsv-garlic-mayo.jpeg',0,0,8,NULL,'2024-05-02 02:49:41','2024-05-02 02:49:41'),(34,NULL,49,NULL,'https://pos.momentpay.live/storage/2024/05/home-made-sausage-roll.jpeg',0,0,8,NULL,'2024-05-02 02:50:04','2024-05-02 02:50:04'),(35,NULL,48,NULL,'https://pos.momentpay.live/storage/2024/05/cheesy-garlic-bread-v.jpeg',0,0,8,NULL,'2024-05-02 02:50:28','2024-05-02 02:50:28'),(36,NULL,47,NULL,'https://pos.momentpay.live/storage/2024/05/chunky-chips-v-bbq-sauce.jpeg',0,0,8,NULL,'2024-05-02 02:50:53','2024-05-02 02:50:53'),(37,NULL,46,NULL,'https://pos.momentpay.live/storage/2024/05/ginger-beer.jpeg',0,1,8,NULL,'2024-05-02 02:51:19','2024-05-02 02:51:19'),(38,NULL,45,NULL,'https://pos.momentpay.live/storage/2024/05/soda-water.jpeg',0,0,8,NULL,'2024-05-02 02:51:44','2024-05-02 02:51:44'),(39,NULL,44,NULL,'https://pos.momentpay.live/storage/2024/05/tonic-water.jpeg',0,0,8,NULL,'2024-05-02 02:52:21','2024-05-02 02:52:21'),(40,NULL,43,NULL,'https://pos.momentpay.live/storage/2024/05/orange-juice.jpeg',0,0,8,NULL,'2024-05-02 02:53:06','2024-05-02 02:53:06'),(41,NULL,42,NULL,'https://pos.momentpay.live/storage/2024/05/lemonade.jpeg',0,0,8,NULL,'2024-05-02 02:53:24','2024-05-02 02:53:24'),(45,NULL,27,NULL,'https://pos.momentpay.live/storage/2024/05/amaretto.jpeg',0,0,8,NULL,'2024-05-02 03:27:49','2024-05-02 03:27:49'),(46,NULL,26,NULL,'https://pos.momentpay.live/storage/2024/05/malibu.jpeg',0,0,8,NULL,'2024-05-02 03:28:09','2024-05-02 03:28:09'),(47,NULL,28,NULL,'https://pos.momentpay.live/storage/2024/05/archers.jpeg',0,0,8,NULL,'2024-05-02 03:28:29','2024-05-02 03:28:29'),(48,NULL,29,NULL,'https://pos.momentpay.live/storage/2024/05/baileys.jpeg',0,0,8,NULL,'2024-05-02 03:28:48','2024-05-02 03:28:48'),(49,NULL,30,NULL,'https://pos.momentpay.live/storage/2024/05/brandy.jpeg',0,0,8,NULL,'2024-05-02 03:29:07','2024-05-02 03:29:07'),(50,NULL,31,NULL,'https://pos.momentpay.live/storage/2024/05/bacardi.jpeg',0,0,8,NULL,'2024-05-02 03:29:32','2024-05-02 03:29:32'),(52,NULL,32,NULL,'https://pos.momentpay.live/storage/2024/05/captain-morgans.jpeg',0,0,8,NULL,'2024-05-02 03:29:51','2024-05-02 03:29:51'),(53,NULL,33,NULL,'https://pos.momentpay.live/storage/2024/05/dark-morgans.jpeg',0,0,8,NULL,'2024-05-02 03:30:09','2024-05-02 03:30:09'),(54,NULL,34,NULL,'https://pos.momentpay.live/storage/2024/05/krakken-spiced.jpeg',0,0,8,NULL,'2024-05-02 03:30:31','2024-05-02 03:30:31'),(55,NULL,35,NULL,'https://pos.momentpay.live/storage/2024/05/krakken-spiced.jpeg',0,0,8,NULL,'2024-05-02 03:31:21','2024-05-02 03:31:21'),(56,NULL,36,NULL,'https://pos.momentpay.live/storage/2024/05/pinot-grigio.jpeg',0,0,8,NULL,'2024-05-02 03:31:57','2024-05-02 03:31:57'),(57,NULL,37,NULL,'https://pos.momentpay.live/storage/2024/05/chardonnay.jpeg',0,0,8,NULL,'2024-05-02 03:32:27','2024-05-02 03:32:27'),(58,NULL,38,NULL,'https://pos.momentpay.live/storage/2024/05/pinot-blush.jpeg',0,0,8,NULL,'2024-05-02 03:32:50','2024-05-02 03:32:50'),(59,NULL,39,NULL,'https://pos.momentpay.live/storage/2024/05/shiraz137414.jpeg',0,0,8,NULL,'2024-05-02 03:33:16','2024-05-02 03:33:16'),(60,NULL,25,NULL,'https://pos.momentpay.live/storage/2024/05/sambucca.jpeg',0,0,8,NULL,'2024-05-02 05:57:06','2024-05-02 05:57:06'),(61,NULL,17,NULL,'https://pos.momentpay.live/storage/2024/05/bombay-sapphire.jpeg',0,0,8,NULL,'2024-05-02 05:58:36','2024-05-02 05:58:36'),(62,NULL,18,NULL,'https://pos.momentpay.live/storage/2024/05/tanqueray.jpeg',0,0,8,NULL,'2024-05-02 05:59:01','2024-05-02 05:59:01'),(63,NULL,19,NULL,'https://pos.momentpay.live/storage/2024/05/hendricks.jpeg',0,0,8,NULL,'2024-05-02 05:59:29','2024-05-02 05:59:29'),(64,NULL,20,NULL,'https://pos.momentpay.live/storage/2024/05/plymouth.jpeg',0,0,8,NULL,'2024-05-02 05:59:52','2024-05-02 05:59:52'),(65,NULL,21,NULL,'https://pos.momentpay.live/storage/2024/05/whitely-neil-rhubarb.jpeg',0,0,8,NULL,'2024-05-02 06:00:14','2024-05-02 06:00:14'),(66,NULL,22,NULL,'https://pos.momentpay.live/storage/2024/05/cafe-patron.jpeg',0,0,8,NULL,'2024-05-02 06:00:51','2024-05-02 06:00:51'),(67,NULL,23,NULL,'https://pos.momentpay.live/storage/2024/05/tequila.jpeg',0,0,8,NULL,'2024-05-02 06:01:26','2024-05-02 06:01:26'),(68,NULL,11,NULL,'https://pos.momentpay.live/storage/2024/05/peroni.jpeg',0,0,8,NULL,'2024-05-02 06:02:35','2024-05-02 06:02:35'),(69,NULL,12,NULL,'https://pos.momentpay.live/storage/2024/05/corona.jpeg',0,0,8,NULL,'2024-05-02 06:03:05','2024-05-02 06:03:05'),(70,NULL,13,NULL,'https://pos.momentpay.live/storage/2024/05/guinness.jpeg',0,0,8,NULL,'2024-05-02 06:03:29','2024-05-02 06:03:29'),(71,NULL,14,NULL,'https://pos.momentpay.live/storage/2024/05/bulmers.jpeg',0,0,8,NULL,'2024-05-02 06:03:52','2024-05-02 06:03:52'),(72,NULL,15,NULL,'https://pos.momentpay.live/storage/2024/05/thatchers-haze.jpeg',0,0,8,NULL,'2024-05-02 06:04:36','2024-05-02 06:04:36'),(73,NULL,16,NULL,'https://pos.momentpay.live/storage/2024/05/kopparberg-mixed-fruit.jpeg',0,0,8,NULL,'2024-05-02 06:04:58','2024-05-02 06:04:58'),(75,NULL,7,NULL,'https://pos.momentpay.live/storage/2024/05/jim-beam.jpeg',0,0,8,NULL,'2024-05-02 06:07:31','2024-05-02 06:07:31'),(76,NULL,8,NULL,'https://pos.momentpay.live/storage/2024/05/jack-daniels.jpeg',0,0,8,NULL,'2024-05-02 06:07:52','2024-05-02 06:07:52'),(77,NULL,9,NULL,'https://pos.momentpay.live/storage/2024/05/johnny-walker.jpeg',0,0,8,NULL,'2024-05-02 06:08:24','2024-05-02 06:08:24'),(78,NULL,10,NULL,'https://pos.momentpay.live/storage/2024/05/glen-morray.jpeg',0,0,8,NULL,'2024-05-02 06:08:41','2024-05-02 06:08:41'),(81,NULL,5,NULL,'https://pos.momentpay.live/storage/2024/05/ciroc.jpeg',0,0,8,NULL,'2024-05-02 06:11:03','2024-05-02 06:11:03'),(82,NULL,6,NULL,'https://pos.momentpay.live/storage/2024/05/grey-goose.jpeg',0,0,8,NULL,'2024-05-02 06:11:19','2024-05-02 06:11:19'),(83,NULL,79,NULL,'https://pos.momentpay.live/storage/2024/05/beer-small.jpeg',0,0,8,NULL,'2024-05-02 06:13:43','2024-05-02 06:13:43'),(84,NULL,56,NULL,'https://pos.momentpay.live/storage/2024/05/classic-burger.jpeg',0,1,8,NULL,'2024-05-02 09:19:08','2024-05-02 09:19:08'),(85,NULL,4,NULL,'https://pos.momentpay.live/storage/2024/05/absolute-vodka.jpeg',0,0,8,NULL,'2024-05-02 09:19:58','2024-05-02 09:19:58'),(87,NULL,24,NULL,'https://pos.momentpay.live/storage/2024/05/jagermeister.jpeg',0,0,8,NULL,'2024-05-02 09:20:26','2024-05-02 09:20:26'),(88,NULL,40,NULL,'https://pos.momentpay.live/storage/2024/05/prosecco.jpeg',0,0,8,NULL,'2024-05-02 09:20:46','2024-05-02 09:20:46'),(91,NULL,3,NULL,'https://pos.momentpay.live/storage/2024/05/smirnoff.jpeg',0,0,8,NULL,'2024-05-02 11:08:45','2024-05-02 11:08:45'),(92,NULL,41,NULL,'https://pos.momentpay.live/storage/2024/05/pepsi.jpeg',0,0,8,NULL,'2024-05-03 09:15:04','2024-05-03 09:15:04');

--
-- Table structure for table `ns_nexopos_products_histories`
--

CREATE TABLE `ns_nexopos_products_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `procurement_id` int(11) DEFAULT NULL,
  `procurement_product_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `order_product_id` int(11) DEFAULT NULL,
  `operation_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_id` int(11) NOT NULL,
  `before_quantity` double(18,5) DEFAULT NULL,
  `quantity` double(18,5) NOT NULL,
  `after_quantity` double(18,5) DEFAULT NULL,
  `unit_price` double(18,5) NOT NULL,
  `total_price` double(18,5) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_histories`
--

INSERT INTO `ns_nexopos_products_histories` VALUES (1,6,4,1,NULL,NULL,'procured',1,0.00000,5000.00000,5000.00000,0.00000,0.00000,NULL,8,NULL,'2024-05-02 11:13:42','2024-05-02 11:13:42'),(2,3,4,2,NULL,NULL,'procured',1,0.00000,5000.00000,5000.00000,0.00000,0.00000,NULL,8,NULL,'2024-05-02 11:13:42','2024-05-02 11:13:42'),(3,6,5,3,NULL,NULL,'procured',1,5000.00000,5000.00000,10000.00000,5.00000,25000.00000,NULL,8,NULL,'2024-05-02 11:14:26','2024-05-02 11:14:26'),(4,3,5,4,NULL,NULL,'procured',1,5000.00000,5000.00000,10000.00000,66.00000,330000.00000,NULL,8,NULL,'2024-05-02 11:14:26','2024-05-02 11:14:26');

--
-- Table structure for table `ns_nexopos_products_histories_combined`
--

CREATE TABLE `ns_nexopos_products_histories_combined` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `product_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `initial_quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `sold_quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `procured_quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `defective_quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `final_quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_histories_combined`
--

INSERT INTO `ns_nexopos_products_histories_combined` VALUES (1,'Grey Goose','2024-05-02',6,1,0.00,0.00,10000.00,0.00,10000.00,NULL,'2024-05-02 10:13:42','2024-05-02 10:14:26'),(2,'Smirnoff','2024-05-02',3,1,0.00,0.00,10000.00,0.00,10000.00,NULL,'2024-05-02 10:13:42','2024-05-02 10:14:26');

--
-- Table structure for table `ns_nexopos_products_subitems`
--

CREATE TABLE `ns_nexopos_products_subitems` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `unit_quantity_id` int(11) NOT NULL,
  `sale_price` double(8,2) NOT NULL DEFAULT '0.00',
  `quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `total_price` double(8,2) NOT NULL DEFAULT '0.00',
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_subitems`
--


--
-- Table structure for table `ns_nexopos_products_taxes`
--

CREATE TABLE `ns_nexopos_products_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `unit_quantity_id` int(11) NOT NULL,
  `tax_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` double(18,5) NOT NULL,
  `value` double(18,5) NOT NULL,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_taxes`
--


--
-- Table structure for table `ns_nexopos_products_unit_quantities`
--

CREATE TABLE `ns_nexopos_products_unit_quantities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'product',
  `preview_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `unit_id` int(11) NOT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double(18,5) NOT NULL,
  `low_quantity` double(18,5) NOT NULL DEFAULT '0.00000',
  `stock_alert_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `sale_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `sale_price_edit` double(18,5) NOT NULL DEFAULT '0.00000',
  `sale_price_without_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `sale_price_with_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `sale_price_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `wholesale_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `wholesale_price_edit` double(18,5) NOT NULL DEFAULT '0.00000',
  `wholesale_price_with_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `wholesale_price_without_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `wholesale_price_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `custom_price` double(18,5) NOT NULL DEFAULT '0.00000',
  `custom_price_edit` double(18,5) NOT NULL DEFAULT '0.00000',
  `custom_price_with_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `custom_price_without_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `custom_price_tax` double(18,5) NOT NULL DEFAULT '0.00000',
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  `convert_unit_id` int(11) DEFAULT NULL,
  `cogs` double(8,2) NOT NULL DEFAULT '0.00',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_products_unit_quantities`
--

INSERT INTO `ns_nexopos_products_unit_quantities` VALUES (1,1,'product','',NULL,1,'987657890-1',0.00000,0.00000,0,75.00000,75.00000,75.00000,75.00000,0.00000,65.00000,65.00000,65.00000,65.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-04-24 14:50:57','2024-04-24 14:50:57'),(2,2,'product','',NULL,1,'987654678-2',0.00000,0.00000,0,25.00000,25.00000,25.00000,25.00000,0.00000,20.00000,20.00000,20.00000,20.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0,NULL,0.00,NULL,'2024-04-25 00:46:40','2024-04-25 00:46:41'),(3,3,'product','',NULL,1,'18OnUHHOVy-3',10000.00000,0.00000,0,4.20000,3.50000,3.50000,4.20000,0.70000,3.50000,3.50000,4.20000,3.50000,0.70000,0.00000,0.00000,0.00000,0.00000,0.00000,1,1,33.00,NULL,'2024-05-01 22:42:16','2024-05-02 11:14:26'),(4,4,'product','',NULL,1,'iaWGL7Kcv8-4',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:43:38','2024-05-01 22:43:38'),(5,5,'product','',NULL,1,'RokNpdvDwL-5',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:44:22','2024-05-01 22:44:22'),(6,6,'product','',NULL,1,'gbTBefTEQS-6',10000.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,2.50,NULL,'2024-05-01 22:45:00','2024-05-02 11:14:26'),(7,7,'product','',NULL,1,'mpmEDyB4c2-7',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:45:38','2024-05-01 22:45:38'),(8,8,'product','',NULL,1,'BcWfm1KoKf-8',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:46:35','2024-05-01 22:46:35'),(9,9,'product','',NULL,1,'VCx9PFvqWK-9',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:47:04','2024-05-01 22:47:04'),(10,10,'product','',NULL,1,'h5qNNpvalQ-10',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:47:45','2024-05-01 22:47:45'),(11,11,'product','',NULL,1,'rKGKQhfny6-11',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:50:44','2024-05-01 22:50:44'),(12,12,'product','',NULL,1,'dlefnEChl3-12',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:51:15','2024-05-01 22:51:15'),(13,13,'product','',NULL,1,'LvGDQfEvOk-13',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:52:19','2024-05-01 22:52:19'),(14,14,'product','',NULL,1,'tcyE9VY3IJ-14',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:53:31','2024-05-01 22:53:31'),(15,15,'product','',NULL,1,'DpLfMLgP0H-15',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:54:37','2024-05-01 22:54:37'),(16,16,'product','',NULL,1,'cNG4ykA28x-16',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:55:35','2024-05-01 22:55:35'),(17,17,'product','',NULL,1,'x94rfdCLue-17',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:56:08','2024-05-01 22:56:08'),(18,18,'product','',NULL,1,'Ln4N9levpc-18',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:56:46','2024-05-01 22:56:46'),(19,19,'product','',NULL,1,'3gQ3Ta8J5j-19',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:57:12','2024-05-01 22:57:12'),(20,20,'product','',NULL,1,'n1CjFM3fa0-20',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:57:43','2024-05-01 22:57:43'),(21,21,'product','',NULL,1,'9cfmsjzod1-21',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:58:15','2024-05-01 22:58:15'),(22,22,'product','',NULL,1,'acvnfyyoX5-22',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:58:41','2024-05-01 22:58:41'),(23,23,'product','',NULL,1,'0KetaPgXZO-23',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:59:14','2024-05-01 22:59:14'),(24,24,'product','',NULL,1,'dVszsJEhiU-24',0.00000,0.00000,0,3.00000,3.00000,3.00000,3.00000,0.00000,3.00000,3.00000,3.00000,3.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 22:59:47','2024-05-01 22:59:47'),(25,25,'product','',NULL,1,'gQwNpzK5hy-25',0.00000,0.00000,0,3.00000,3.00000,3.00000,3.00000,0.00000,3.00000,3.00000,3.00000,3.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:00:15','2024-05-01 23:00:15'),(26,26,'product','',NULL,1,'1iwydwtwDE-26',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:00:51','2024-05-01 23:00:51'),(27,27,'product','',NULL,1,'pR9VEY0486-27',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:01:23','2024-05-01 23:01:23'),(28,28,'product','',NULL,1,'4FvUxHkOgy-28',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:01:51','2024-05-01 23:01:51'),(29,29,'product','',NULL,1,'HHLXvd5RPr-29',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:02:29','2024-05-01 23:02:29'),(30,30,'product','',NULL,1,'og3S3nNExJ-30',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:02:56','2024-05-01 23:02:56'),(31,31,'product','',NULL,1,'YHyxsHNZGJ-31',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:03:27','2024-05-01 23:03:27'),(32,32,'product','',NULL,1,'14mm7sqJHp-32',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:03:58','2024-05-01 23:03:58'),(33,33,'product','',NULL,1,'FQXr58QQ2G-33',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:04:32','2024-05-01 23:04:32'),(34,34,'product','',NULL,1,'FW2XzWEHTI-34',0.00000,0.00000,0,4.00000,4.00000,4.00000,4.00000,0.00000,4.00000,4.00000,4.00000,4.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:04:59','2024-05-01 23:04:59'),(35,35,'product','',NULL,1,'H3AxPxYvOc-35',0.00000,0.00000,0,4.25000,4.25000,4.25000,4.25000,0.00000,4.25000,4.25000,4.25000,4.25000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:05:26','2024-05-01 23:05:26'),(36,36,'product','',NULL,1,'Qph5ByABry-36',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:05:58','2024-05-01 23:05:58'),(37,37,'product','',NULL,1,'Mf77kkUPZt-37',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:06:24','2024-05-01 23:06:24'),(38,38,'product','',NULL,1,'dJcNSQKhEh-38',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:07:31','2024-05-01 23:07:31'),(39,39,'product','',NULL,1,'G93xFhWskv-39',0.00000,0.00000,0,3.50000,3.50000,3.50000,3.50000,0.00000,3.50000,3.50000,3.50000,3.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:08:14','2024-05-01 23:08:14'),(40,40,'product','',NULL,1,'UoQIEedufr-40',0.00000,0.00000,0,4.50000,4.50000,4.50000,4.50000,0.00000,4.50000,4.50000,4.50000,4.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:09:15','2024-05-01 23:09:15'),(41,41,'product','',NULL,1,'20rWR8EYby-41',0.00000,0.00000,0,1.50000,1.50000,1.50000,1.50000,0.00000,1.50000,1.50000,1.50000,1.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:11:01','2024-05-01 23:11:01'),(42,42,'product','',NULL,1,'DBHRfxcP8T-42',0.00000,0.00000,0,1.50000,1.50000,1.50000,1.50000,0.00000,1.50000,1.50000,1.50000,1.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:11:38','2024-05-01 23:11:38'),(43,43,'product','',NULL,1,'8E9IDugYyp-43',0.00000,0.00000,0,1.00000,1.00000,1.00000,1.00000,0.00000,1.00000,1.00000,1.00000,1.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:12:09','2024-05-01 23:12:09'),(44,44,'product','',NULL,1,'5PoUZ9oJuY-44',0.00000,0.00000,0,1.00000,1.00000,1.00000,1.00000,0.00000,1.00000,1.00000,1.00000,1.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:12:49','2024-05-01 23:12:49'),(45,45,'product','',NULL,1,'NEwGqg6MAU-45',0.00000,0.00000,0,1.00000,1.00000,1.00000,1.00000,0.00000,1.00000,1.00000,1.00000,1.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:13:19','2024-05-01 23:13:19'),(46,46,'product','',NULL,1,'lhYh3ziAq3-46',0.00000,0.00000,0,1.00000,1.00000,1.00000,1.00000,0.00000,1.00000,1.00000,1.00000,1.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:13:49','2024-05-01 23:13:49'),(47,47,'product','',NULL,1,'eDjLgrOdz3-47',0.00000,0.00000,0,2.50000,2.50000,2.50000,2.50000,0.00000,2.50000,2.50000,2.50000,2.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:14:39','2024-05-01 23:14:39'),(48,48,'product','',NULL,1,'XMu4Glwz6w-48',0.00000,0.00000,0,3.00000,3.00000,3.00000,3.00000,0.00000,3.00000,3.00000,3.00000,3.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:15:35','2024-05-01 23:15:35'),(49,49,'product','',NULL,1,'M82x1HM3Lk-49',0.00000,0.00000,0,2.50000,2.50000,2.50000,2.50000,0.00000,2.50000,2.50000,2.50000,2.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:16:38','2024-05-01 23:16:38'),(50,50,'product','',NULL,1,'oV1zCPHavd-50',0.00000,0.00000,0,2.50000,2.50000,2.50000,2.50000,0.00000,2.50000,2.50000,2.50000,2.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:17:23','2024-05-01 23:17:23'),(51,51,'product','',NULL,1,'WqmSlWuahG-51',0.00000,0.00000,0,7.20000,7.20000,7.20000,7.20000,0.00000,7.20000,7.20000,7.20000,7.20000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:20:10','2024-05-01 23:20:10'),(52,52,'product','',NULL,1,'xfNOIT3BQG-52',0.00000,0.00000,0,8.45000,8.45000,8.45000,8.45000,0.00000,8.45000,8.45000,8.45000,8.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:20:49','2024-05-01 23:20:49'),(53,53,'product','',NULL,1,'rpJA3jJML6-53',0.00000,0.00000,0,8.10000,8.10000,8.10000,8.10000,0.00000,8.10000,8.10000,8.10000,8.10000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:21:17','2024-05-01 23:21:17'),(54,54,'product','',NULL,1,'NETkz8ATSb-54',0.00000,0.00000,0,8.10000,8.10000,8.10000,8.10000,0.00000,8.10000,8.10000,8.10000,8.10000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:21:52','2024-05-01 23:21:52'),(55,55,'product','',NULL,1,'rwRs93yBLk-55',0.00000,0.00000,0,12.45000,12.45000,12.45000,12.45000,0.00000,12.45000,12.45000,12.45000,12.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:22:22','2024-05-01 23:22:22'),(56,56,'product','',NULL,1,'dqu7s0RIv8-56',0.00000,0.00000,0,8.45000,8.45000,8.45000,8.45000,0.00000,8.45000,8.45000,8.45000,8.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:23:48','2024-05-01 23:23:48'),(57,57,'product','',NULL,1,'R9hejyy0Qp-57',0.00000,0.00000,0,8.95000,8.95000,8.95000,8.95000,0.00000,8.95000,8.95000,8.95000,8.95000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:24:43','2024-05-01 23:24:43'),(58,58,'product','',NULL,1,'Q8dJul0icr-58',0.00000,0.00000,0,8.95000,8.95000,8.95000,8.95000,0.00000,8.95000,8.95000,8.95000,8.95000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:25:33','2024-05-01 23:25:33'),(59,59,'product','',NULL,1,'nwIRwpGKjF-59',0.00000,0.00000,0,8.35000,8.35000,8.35000,8.35000,0.00000,8.35000,8.35000,8.35000,8.35000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:26:19','2024-05-01 23:26:19'),(60,60,'product','',NULL,1,'iRfgc5WJQn-60',0.00000,0.00000,0,8.35000,8.35000,8.35000,8.35000,0.00000,8.35000,8.35000,8.35000,8.35000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:27:11','2024-05-01 23:27:11'),(61,61,'product','',NULL,1,'hOTwsqYdji-61',0.00000,0.00000,0,7.95000,7.95000,7.95000,7.95000,0.00000,7.95000,7.95000,7.95000,7.95000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:28:03','2024-05-01 23:28:03'),(62,62,'product','',NULL,1,'6UxfUyzaag-62',0.00000,0.00000,0,7.95000,7.95000,7.95000,7.95000,0.00000,7.95000,7.95000,7.95000,7.95000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:28:37','2024-05-01 23:28:37'),(63,63,'product','',NULL,1,'Y2XIacICyz-63',0.00000,0.00000,0,7.95000,7.95000,7.95000,7.95000,0.00000,7.95000,7.95000,7.95000,7.95000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:29:13','2024-05-01 23:29:13'),(64,64,'product','',NULL,1,'ZIadTtq5lx-64',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:32:03','2024-05-01 23:32:03'),(65,65,'product','',NULL,1,'2QJlZpp6jJ-65',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:32:37','2024-05-01 23:32:37'),(66,66,'product','',NULL,1,'1GXtl6nqtS-66',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:33:16','2024-05-01 23:33:16'),(67,67,'product','',NULL,1,'Pj4dNX5D1j-67',0.00000,0.00000,0,1.00000,1.00000,1.00000,1.00000,0.00000,1.00000,1.00000,1.00000,1.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:33:41','2024-05-01 23:33:41'),(68,68,'product','',NULL,1,'SeWPMtzjvU-68',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:34:22','2024-05-01 23:34:22'),(69,69,'product','',NULL,1,'if7RxZ0P4n-69',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:34:58','2024-05-01 23:34:58'),(70,70,'product','',NULL,1,'qxYmhxURKo-70',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:35:26','2024-05-01 23:35:26'),(71,71,'product','',NULL,1,'bZrcb67tno-71',0.00000,0.00000,0,4.45000,4.45000,4.45000,4.45000,0.00000,4.45000,4.45000,4.45000,4.45000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:35:59','2024-05-01 23:35:59'),(72,72,'product','',NULL,1,'JGorTBUq2q-72',0.00000,0.00000,0,3.25000,3.25000,3.25000,3.25000,0.00000,3.25000,3.25000,3.25000,3.25000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:36:40','2024-05-01 23:36:40'),(73,73,'product','',NULL,1,'6td4yH3j9E-73',0.00000,0.00000,0,3.25000,3.25000,3.25000,3.25000,0.00000,3.25000,3.25000,3.25000,3.25000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:37:06','2024-05-01 23:37:06'),(74,74,'product','',NULL,1,'o7WRLxyNqm-74',0.00000,0.00000,0,3.25000,3.25000,3.25000,3.25000,0.00000,3.25000,3.25000,3.25000,3.25000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:37:42','2024-05-01 23:37:42'),(75,75,'product','',NULL,1,'4daFytJB3t-75',0.00000,0.00000,0,1.50000,1.50000,1.50000,1.50000,0.00000,1.50000,1.50000,1.50000,1.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:38:12','2024-05-01 23:38:12'),(76,76,'product','',NULL,1,'grV4cDcVrt-76',0.00000,0.00000,0,1.50000,1.50000,1.50000,1.50000,0.00000,1.50000,1.50000,1.50000,1.50000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:39:46','2024-05-01 23:39:46'),(77,77,'product','',NULL,1,'rUiXhoe3HH-77',0.00000,0.00000,0,2.00000,2.00000,2.00000,2.00000,0.00000,2.00000,2.00000,2.00000,2.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:40:16','2024-05-01 23:40:16'),(78,78,'product','',NULL,1,'wHcDlrpZeI-78',0.00000,0.00000,0,1.90000,1.90000,1.90000,1.90000,0.00000,1.90000,1.90000,1.90000,1.90000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-01 23:40:50','2024-05-01 23:40:50'),(79,79,'product','',NULL,1,'5EyrxMCBMK-79',0.00000,0.00000,0,3.00000,3.00000,3.00000,3.00000,0.00000,3.00000,3.00000,3.00000,3.00000,0.00000,0.00000,0.00000,0.00000,0.00000,0.00000,1,NULL,0.00,NULL,'2024-05-02 06:12:35','2024-05-02 06:12:35');

--
-- Table structure for table `ns_nexopos_providers`
--

CREATE TABLE `ns_nexopos_providers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int(11) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `amount_due` double(18,5) NOT NULL DEFAULT '0.00000',
  `amount_paid` double(18,5) NOT NULL DEFAULT '0.00000',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_providers_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_providers`
--

INSERT INTO `ns_nexopos_providers` VALUES (1,'p2p','Prem','newsletter@momentpay.in','+919343712136','Bangalore Bangalore',NULL,8,NULL,0.00000,87000.00000,NULL,'2024-05-02 11:08:09','2024-05-02 11:14:26');

--
-- Table structure for table `ns_nexopos_registers`
--

CREATE TABLE `ns_nexopos_registers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'closed',
  `description` text COLLATE utf8mb4_unicode_ci,
  `used_by` int(11) DEFAULT NULL,
  `author` int(11) NOT NULL,
  `balance` double(18,5) NOT NULL DEFAULT '0.00000',
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_registers`
--


--
-- Table structure for table `ns_nexopos_registers_history`
--

CREATE TABLE `ns_nexopos_registers_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `register_id` int(11) NOT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `payment_type_id` int(11) NOT NULL DEFAULT '0',
  `order_id` int(11) DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` int(11) NOT NULL,
  `value` double(18,5) NOT NULL DEFAULT '0.00000',
  `description` text COLLATE utf8mb4_unicode_ci,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance_before` double(18,5) NOT NULL DEFAULT '0.00000',
  `transaction_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance_after` double(18,5) NOT NULL DEFAULT '0.00000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_registers_history`
--


--
-- Table structure for table `ns_nexopos_rewards_system`
--

CREATE TABLE `ns_nexopos_rewards_system` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `author` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` double(18,5) NOT NULL DEFAULT '0.00000',
  `description` text COLLATE utf8mb4_unicode_ci,
  `coupon_id` int(11) DEFAULT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_rewards_system`
--


--
-- Table structure for table `ns_nexopos_rewards_system_rules`
--

CREATE TABLE `ns_nexopos_rewards_system_rules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from` double(18,5) NOT NULL,
  `to` double(18,5) NOT NULL,
  `reward` double(18,5) NOT NULL,
  `reward_id` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_rewards_system_rules`
--


--
-- Table structure for table `ns_nexopos_role_permission`
--

CREATE TABLE `ns_nexopos_role_permission` (
  `permission_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_role_permission`
--

INSERT INTO `ns_nexopos_role_permission` VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,1),(10,2),(10,3),(10,4),(10,5),(11,2),(12,2),(13,2),(13,3),(13,4),(13,5),(14,2),(15,2),(16,2),(17,2),(18,2),(18,3),(19,2),(19,3),(20,2),(20,3),(21,2),(21,3),(22,2),(22,3),(23,2),(23,3),(24,2),(24,3),(25,2),(25,3),(26,2),(26,3),(27,2),(27,3),(27,4),(28,2),(28,3),(29,2),(29,3),(30,2),(30,3),(31,2),(31,3),(32,2),(32,3),(33,2),(33,3),(34,2),(34,3),(35,2),(35,3),(36,2),(36,3),(37,2),(37,3),(38,2),(38,3),(39,2),(39,3),(40,2),(40,3),(41,2),(41,3),(42,2),(42,3),(43,2),(43,3),(44,2),(44,3),(45,2),(45,3),(46,2),(46,3),(47,2),(47,3),(48,2),(48,3),(48,4),(49,2),(49,3),(50,2),(50,3),(50,4),(51,2),(51,3),(51,4),(52,2),(52,3),(52,4),(53,2),(53,3),(53,4),(54,2),(54,3),(54,4),(55,2),(55,3),(56,2),(56,3),(57,2),(57,3),(58,2),(58,3),(59,2),(59,3),(60,2),(60,3),(61,2),(61,3),(62,2),(62,3),(63,2),(63,3),(64,2),(64,3),(65,2),(65,3),(66,2),(66,3),(67,2),(67,3),(68,2),(68,3),(69,2),(69,3),(70,2),(70,3),(71,2),(71,3),(72,2),(72,3),(73,2),(73,3),(74,2),(74,3),(75,2),(75,3),(76,2),(76,3),(77,2),(77,3),(78,2),(78,3),(79,2),(79,3),(80,2),(80,3),(81,2),(81,3),(82,2),(82,3),(83,2),(83,3),(84,2),(84,3),(85,2),(85,3),(86,2),(86,3),(87,2),(87,3),(88,2),(88,3),(89,2),(89,3),(90,2),(90,3),(91,2),(91,3),(92,2),(92,3),(93,2),(93,3),(94,2),(94,3),(95,2),(95,3),(96,2),(96,3),(97,2),(97,3),(98,2),(98,3),(99,2),(99,3),(99,4),(100,2),(100,3),(100,4),(101,2),(101,3),(101,4),(102,2),(102,3),(102,4),(103,2),(103,3),(104,2),(104,3),(105,2),(105,3),(106,2),(106,3),(107,1),(107,2),(107,3),(107,4),(107,5),(108,2),(108,3),(109,2),(109,3),(110,2),(110,3),(111,2),(111,3),(112,2),(112,3),(113,2),(113,3),(114,2),(114,3),(115,2),(115,3),(116,2),(116,3),(117,2),(117,3),(118,2),(118,3),(119,2),(119,3),(120,2),(120,3),(121,2),(121,3),(122,2),(122,3),(123,2),(123,3),(124,2),(124,3),(125,2),(125,3),(126,2),(126,3),(127,2),(127,3),(127,9),(128,2),(128,3),(128,8),(128,9),(129,2),(129,3),(129,8),(130,2),(130,3),(130,8),(130,9),(131,2),(131,3),(132,2),(132,3),(133,2),(133,3),(134,2),(134,3),(137,2),(137,3),(138,2),(138,3);

--
-- Table structure for table `ns_nexopos_roles`
--

CREATE TABLE `ns_nexopos_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `reward_system_id` int(11) DEFAULT NULL,
  `minimal_credit_payment` double(8,2) NOT NULL DEFAULT '0.00',
  `author` int(11) DEFAULT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_roles_name_unique` (`name`),
  UNIQUE KEY `ns_nexopos_roles_namespace_unique` (`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_roles`
--

INSERT INTO `ns_nexopos_roles` VALUES (1,'User','user','Basic user role.',NULL,0.00,NULL,1,'2024-04-24 12:09:08','2024-04-24 12:09:08'),(2,'Administrator','admin','Master role which can perform all actions like create users, install/update/delete modules and much more.',NULL,0.00,NULL,1,'2024-04-24 12:09:08','2024-04-24 12:09:08'),(3,'Store Administrator','nexopos.store.administrator','Has a control over an entire store of NexoPOS.',NULL,0.00,NULL,1,'2024-04-24 12:09:09','2024-04-24 12:09:09'),(4,'Store Cashier','nexopos.store.cashier','Has a control over the sale process.',NULL,0.00,NULL,1,'2024-04-24 12:09:10','2024-04-24 12:09:10'),(5,'Store Customer','nexopos.store.customer','Can purchase orders and manage his profile.',NULL,0.00,NULL,1,'2024-04-24 12:09:10','2024-04-24 12:09:10'),(8,'Waiter','gastro.waiter','The waiter is responsible of welcoming customers and placing orders.',NULL,0.00,NULL,1,'2024-04-24 14:39:09','2024-04-24 14:39:09'),(9,'Chef','gastro.chef','The chef is responsible cooking meals and handling materials.',NULL,0.00,NULL,1,'2024-04-24 14:39:09','2024-04-24 14:39:09');

--
-- Table structure for table `ns_nexopos_taxes`
--

CREATE TABLE `ns_nexopos_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `rate` double(18,5) NOT NULL,
  `tax_group_id` int(11) NOT NULL,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_taxes`
--

INSERT INTO `ns_nexopos_taxes` VALUES (1,'VAT',NULL,20.00000,1,8,NULL,'2024-05-02 09:25:56','2024-05-02 09:25:56');

--
-- Table structure for table `ns_nexopos_taxes_groups`
--

CREATE TABLE `ns_nexopos_taxes_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_taxes_groups`
--

INSERT INTO `ns_nexopos_taxes_groups` VALUES (1,'UK Tax',NULL,8,NULL,'2024-05-02 09:25:26','2024-05-02 09:25:26');

--
-- Table structure for table `ns_nexopos_transactions`
--

CREATE TABLE `ns_nexopos_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `media_id` int(11) NOT NULL DEFAULT '0',
  `value` double(18,5) NOT NULL DEFAULT '0.00000',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `group_id` int(11) DEFAULT NULL,
  `occurrence` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occurrence_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scheduled_date` datetime DEFAULT NULL,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_transactions`
--


--
-- Table structure for table `ns_nexopos_transactions_accounts`
--

CREATE TABLE `ns_nexopos_transactions_accounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'debit',
  `account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_transactions_accounts`
--


--
-- Table structure for table `ns_nexopos_transactions_histories`
--

CREATE TABLE `ns_nexopos_transactions_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) DEFAULT NULL,
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_account_id` int(11) DEFAULT NULL,
  `procurement_id` int(11) DEFAULT NULL,
  `order_refund_id` int(11) DEFAULT NULL,
  `order_refund_product_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `order_product_id` int(11) DEFAULT NULL,
  `register_history_id` int(11) DEFAULT NULL,
  `customer_account_history_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `value` double(18,5) NOT NULL DEFAULT '0.00000',
  `author` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_transactions_histories`
--


--
-- Table structure for table `ns_nexopos_units`
--

CREATE TABLE `ns_nexopos_units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `value` double(18,5) NOT NULL,
  `preview_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_unit` tinyint(1) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ns_nexopos_units_identifier_unique` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_units`
--

INSERT INTO `ns_nexopos_units` VALUES (1,'qty','qty',NULL,5,1,1.00000,NULL,0,NULL,'2024-04-24 14:49:08','2024-04-24 14:49:08');

--
-- Table structure for table `ns_nexopos_units_groups`
--

CREATE TABLE `ns_nexopos_units_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `author` int(11) NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_units_groups`
--

INSERT INTO `ns_nexopos_units_groups` VALUES (1,'qty','Quantity',5,NULL,'2024-04-24 14:48:31','2024-04-24 14:48:31');

--
-- Table structure for table `ns_nexopos_users_attributes`
--

CREATE TABLE `ns_nexopos_users_attributes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `avatar_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_users_attributes`
--

INSERT INTO `ns_nexopos_users_attributes` VALUES (1,5,NULL,NULL,'en'),(2,8,NULL,NULL,'en');

--
-- Table structure for table `ns_nexopos_users_roles_relations`
--

CREATE TABLE `ns_nexopos_users_roles_relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_users_roles_relations`
--

INSERT INTO `ns_nexopos_users_roles_relations` VALUES (1,2,5,'2024-04-24 12:09:14','2024-04-24 12:09:14'),(2,5,7,'2024-04-24 15:37:14','2024-04-24 15:37:14'),(7,2,8,'2024-04-30 09:17:09','2024-04-30 09:17:09');

--
-- Table structure for table `ns_nexopos_users_widgets`
--

CREATE TABLE `ns_nexopos_users_widgets` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_nexopos_users_widgets`
--

INSERT INTO `ns_nexopos_users_widgets` VALUES ('9be2b705-5712-468d-855b-902b10b3a12d','nsIncompleteSaleCardWidget','first-column','App\\Widgets\\IncompleteSaleCardWidget',0,5,'2024-04-24 12:09:14','2024-04-24 12:09:14'),('9be2b705-580c-4031-ae15-d78ff09b32aa','nsBestCustomers','first-column','App\\Widgets\\BestCustomersWidget',1,5,'2024-04-24 12:09:14','2024-04-24 12:09:14'),('9be2b706-d519-42f4-a482-e91b1f7227c1','nsOrdersSummary','first-column','App\\Widgets\\OrdersSummaryWidget',2,5,'2024-04-24 12:09:15','2024-04-24 12:09:15'),('9be2b706-db9e-46ea-837f-ca5a5dc536bb','nsExpenseCardWidget','second-column','App\\Widgets\\ExpenseCardWidget',0,5,'2024-04-24 12:09:15','2024-04-24 12:09:15'),('9be2b706-dec6-406d-bba7-2c402157463e','nsProfileWidget','second-column','App\\Widgets\\ProfileWidget',1,5,'2024-04-24 12:09:15','2024-04-24 12:09:15'),('9be2b706-e222-4ae5-829f-5f54c4f9fe79','nsBestCashiers','second-column','App\\Widgets\\BestCashiersWidget',2,5,'2024-04-24 12:09:15','2024-04-24 12:09:15'),('9be2b706-e58f-402b-bbea-fa6f1e74903f','nsSaleCardWidget','third-column','App\\Widgets\\SaleCardWidget',0,5,'2024-04-24 12:09:15','2024-04-24 12:09:15'),('9be2b706-e8ad-40f6-b6df-4869f8103d9b','nsOrdersChart','third-column','App\\Widgets\\OrdersChartWidget',1,5,'2024-04-24 12:09:15','2024-04-24 12:09:15'),('9bee8b61-9a1a-47a0-9160-204403f42ee3','nsIncompleteSaleCardWidget','first-column','App\\Widgets\\IncompleteSaleCardWidget',0,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-9e8c-4295-a710-b42edff69afc','nsBestCustomers','first-column','App\\Widgets\\BestCustomersWidget',1,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-a1c7-4044-b185-d0a05072c206','nsOrdersSummary','first-column','App\\Widgets\\OrdersSummaryWidget',2,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-a51f-4554-9a52-6ab94eb0607f','nsExpenseCardWidget','second-column','App\\Widgets\\ExpenseCardWidget',0,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-ab91-46fa-a664-fc1a2a5d47b8','nsProfileWidget','second-column','App\\Widgets\\ProfileWidget',1,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-b1fc-4691-9350-4afa5baab9b6','nsBestCashiers','second-column','App\\Widgets\\BestCashiersWidget',2,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-b558-4948-b0e4-52d7028d1fea','nsSaleCardWidget','third-column','App\\Widgets\\SaleCardWidget',0,8,'2024-04-30 09:17:09','2024-04-30 09:17:09'),('9bee8b61-b883-43a4-bf95-fbf1d1fe1a27','nsOrdersChart','third-column','App\\Widgets\\OrdersChartWidget',1,8,'2024-04-30 09:17:09','2024-04-30 09:17:09');

--
-- Table structure for table `ns_telescope_entries`
--

CREATE TABLE `ns_telescope_entries` (
  `sequence` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `ns_telescope_entries_uuid_unique` (`uuid`),
  KEY `ns_telescope_entries_batch_id_index` (`batch_id`),
  KEY `ns_telescope_entries_family_hash_index` (`family_hash`),
  KEY `ns_telescope_entries_created_at_index` (`created_at`),
  KEY `ns_telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_telescope_entries`
--


--
-- Table structure for table `ns_telescope_entries_tags`
--

CREATE TABLE `ns_telescope_entries_tags` (
  `entry_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `ns_telescope_entries_tags_entry_uuid_tag_index` (`entry_uuid`,`tag`),
  KEY `ns_telescope_entries_tags_tag_index` (`tag`),
  CONSTRAINT `ns_telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `ns_telescope_entries` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_telescope_entries_tags`
--


--
-- Table structure for table `ns_telescope_monitoring`
--

CREATE TABLE `ns_telescope_monitoring` (
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_telescope_monitoring`
--


--
-- Table structure for table `ns_websockets_statistics_entries`
--

CREATE TABLE `ns_websockets_statistics_entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `peak_connection_count` int(11) NOT NULL,
  `websocket_message_count` int(11) NOT NULL,
  `api_message_count` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ns_websockets_statistics_entries`
--



