-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 20, 2025 at 05:06 PM
-- Server version: 10.11.14-MariaDB-cll-lve
-- PHP Version: 8.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `arcncomb_migration`
--

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

--
-- Table structure for table `access`
--

CREATE TABLE `access` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `city` varchar(30) NOT NULL,
  `state` varchar(30) NOT NULL,
  `street` varchar(50) NOT NULL,
  `district` varchar(50) NOT NULL,
  `number` smallint(6) NOT NULL,
  `reference` varchar(50) NOT NULL,
  `zip_code` varchar(30) NOT NULL,
  `default_address` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `affiliated_balance`
--

CREATE TABLE `affiliated_balance` (
  `id` int(11) NOT NULL,
  `user_affiliated_id` int(11) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `transfer_requested` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `affiliated_report`
--

CREATE TABLE `affiliated_report` (
  `id` int(11) NOT NULL,
  `user_affiliated_id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `report` text NOT NULL,
  `type` tinyint(4) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `date_created` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `affiliated_setting`
--

CREATE TABLE `affiliated_setting` (
  `id` int(11) NOT NULL,
  `affiliated_id` int(11) NOT NULL,
  `setting` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `api_settings`
--

CREATE TABLE `api_settings` (
  `id` int(11) NOT NULL,
  `url_base` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `instance_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `api_system`
--

CREATE TABLE `api_system` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `access_token` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `img` varchar(100) NOT NULL,
  `link_type` tinyint(4) NOT NULL,
  `link` varchar(255) NOT NULL,
  `combo_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `bill`
--

CREATE TABLE `bill` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `cart` mediumtext NOT NULL,
  `price_total` decimal(10,2) NOT NULL,
  `calling` tinyint(4) NOT NULL,
  `call_reason` varchar(100) NOT NULL,
  `alert` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `bill_partial_payment`
--

CREATE TABLE `bill_partial_payment` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `method` tinyint(4) NOT NULL,
  `data` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `card`
--

CREATE TABLE `card` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `switch_rate` tinyint(4) NOT NULL,
  `rate_type` tinyint(4) NOT NULL,
  `rate_value` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `code` varchar(15) NOT NULL,
  `apply_coupon` text NOT NULL,
  `cart` mediumtext NOT NULL,
  `already_read` tinyint(4) NOT NULL,
  `date_created` date NOT NULL,
  `date_expiration` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cash_drawer`
--

CREATE TABLE `cash_drawer` (
  `id` int(11) NOT NULL,
  `related_cash_drawer_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `note` varchar(255) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(45) NOT NULL,
  `icon` varchar(50) NOT NULL,
  `icon_img` varchar(100) NOT NULL,
  `default_item_img` varchar(255) NOT NULL,
  `days_week` text NOT NULL,
  `hours` text NOT NULL,
  `hidden` tinyint(4) NOT NULL,
  `position` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `chatbot_responses`
--

CREATE TABLE `chatbot_responses` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `response_text` mediumtext NOT NULL,
  `has_media` tinyint(1) DEFAULT 0,
  `media_path` varchar(255) DEFAULT NULL,
  `original_filename` varchar(255) DEFAULT NULL,
  `active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(25) NOT NULL,
  `price_delivery` decimal(10,2) NOT NULL,
  `days_week` text NOT NULL,
  `hours` text NOT NULL,
  `show_pdv_only` tinyint(4) NOT NULL,
  `free_shipping` tinyint(4) NOT NULL DEFAULT 0,
  `free_shipping_above` decimal(10,2) NOT NULL DEFAULT 0.00,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `client_data`
--

CREATE TABLE `client_data` (
  `id` int(11) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `coin`
--

CREATE TABLE `coin` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `coin` decimal(10,2) NOT NULL,
  `coin_standby` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `coin_report`
--

CREATE TABLE `coin_report` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `coin` decimal(10,2) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `combo`
--

CREATE TABLE `combo` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `items_id` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `link` varchar(30) DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL,
  `receive_order_whatsapp` tinyint(4) NOT NULL DEFAULT 0,
  `document` text DEFAULT NULL,
  `img` varchar(100) DEFAULT NULL,
  `img_form` tinyint(4) NOT NULL DEFAULT 1,
  `switch_img_form_item` tinyint(4) NOT NULL DEFAULT 0,
  `img_header` varchar(100) DEFAULT NULL,
  `img_favicon` varchar(255) DEFAULT NULL,
  `switch_layer_fade` tinyint(4) NOT NULL DEFAULT 1,
  `switch_whatsapp_button` tinyint(4) NOT NULL DEFAULT 0,
  `switch_img_item` tinyint(4) NOT NULL DEFAULT 1,
  `template` varchar(4000) DEFAULT '{"color_menu":"#212529","color_menu_text":"#ffffff","color_footer":"#000000","color_footer_text":"#ffffff","background_color":"#ececec"}',
  `country` varchar(30) DEFAULT 'br',
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL,
  `street` varchar(50) DEFAULT NULL,
  `district` varchar(50) DEFAULT NULL,
  `number` smallint(6) DEFAULT NULL,
  `complement` varchar(30) DEFAULT NULL,
  `zip_code` varchar(30) DEFAULT NULL,
  `hours` varchar(1800) DEFAULT '[{"switch_sun":0,"sun_i":"00:00:00","sun_u":"00:00:00","switch_mon":0,"mon_i":"00:00","mon_u":"00:00","switch_tue":0,"tue_i":"00:00","tue_u":"00:00","switch_wed":0,"wed_i":"00:00:00","wed_u":"00:00:00","switch_thu":0,"thu_i":"00:00:00","thu_u":"00:00:00","switch_fri":0,"fri_i":"00:00","fri_u":"00:00","switch_sat":0,"sat_i":"00:00:00","sat_u":"00:00:00"},{"switch_sun":0,"sun_i":"00:00:00","sun_u":"00:00:00","switch_mon":0,"mon_i":"00:00","mon_u":"00:00","switch_tue":0,"tue_i":"00:00","tue_u":"00:00","switch_wed":0,"wed_i":"00:00:00","wed_u":"00:00:00","switch_thu":0,"thu_i":"00:00:00","thu_u":"00:00:00","switch_fri":0,"fri_i":"00:00","fri_u":"00:00","switch_sat":0,"sat_i":"00:00:00","sat_u":"00:00:00"},{"switch_sun":0,"sun_i":"00:00:00","sun_u":"00:00:00","switch_mon":0,"mon_i":"00:00","mon_u":"00:00","switch_tue":0,"tue_i":"00:00","tue_u":"00:00","switch_wed":0,"wed_i":"00:00:00","wed_u":"00:00:00","switch_thu":0,"thu_i":"00:00:00","thu_u":"00:00:00","switch_fri":0,"fri_i":"00:00","fri_u":"00:00","switch_sat":0,"sat_i":"00:00:00","sat_u":"00:00:00"}]',
  `estimated_delivery_time` varchar(50) DEFAULT NULL,
  `estimated_withdrawal_time` varchar(50) DEFAULT NULL,
  `estimated_table_time` varchar(50) DEFAULT NULL,
  `date_timezone` varchar(50) DEFAULT NULL,
  `price_order_min` decimal(10,2) NOT NULL DEFAULT 0.00,
  `payment_method` varchar(1000) DEFAULT '{"money":1,"card":0,"online":0,"online_methods":{"mp":0,"pix":0,"pagseguro":0}}',
  `switch_withdrawal` tinyint(4) NOT NULL DEFAULT 1,
  `switch_delivery` tinyint(4) NOT NULL DEFAULT 0,
  `switch_table` tinyint(4) NOT NULL DEFAULT 0,
  `switch_deliveryman_choose` tinyint(4) NOT NULL DEFAULT 0,
  `deliveryman_choose_type` tinyint(4) NOT NULL DEFAULT 0,
  `switch_automatically_deliveryman_choose` tinyint(4) NOT NULL DEFAULT 0,
  `automatically_deliveryman_choose_type` tinyint(4) NOT NULL DEFAULT 0,
  `switch_schedule_order` tinyint(4) NOT NULL DEFAULT 0,
  `switch_cashback` tinyint(4) NOT NULL DEFAULT 0,
  `cashback_rate` decimal(10,2) NOT NULL DEFAULT 0.00,
  `delivery_type` tinyint(4) NOT NULL DEFAULT 0,
  `price_delivery_type` tinyint(4) NOT NULL DEFAULT 0,
  `price_delivery` decimal(10,2) NOT NULL DEFAULT 0.00,
  `price_delivery_km_type` tinyint(4) NOT NULL DEFAULT 0,
  `price_delivery_km` decimal(10,2) NOT NULL DEFAULT 0.00,
  `price_delivery_km_min` decimal(10,2) NOT NULL DEFAULT 0.00,
  `max_radius_km` int(11) NOT NULL DEFAULT 10,
  `mp_state_code` varchar(50) DEFAULT NULL,
  `mp_public_key` varchar(100) DEFAULT NULL,
  `mp_access_token` varchar(255) DEFAULT NULL,
  `mp_refresh_token` varchar(50) DEFAULT NULL,
  `mp_expire` date NOT NULL DEFAULT '2021-01-01',
  `mp_settings` text DEFAULT NULL,
  `pix_type` tinyint(4) NOT NULL DEFAULT 0,
  `pix_client_id` varchar(100) DEFAULT NULL,
  `pix_client_secret` varchar(100) DEFAULT NULL,
  `pix_key` varchar(255) DEFAULT NULL,
  `pix_certificate` varchar(100) DEFAULT NULL,
  `pix_key_static` varchar(36) DEFAULT NULL,
  `pix_efi_account` varchar(10) DEFAULT NULL,
  `pix_efi_cpf` varchar(15) DEFAULT NULL,
  `switch_multihub` tinyint(4) NOT NULL DEFAULT 0,
  `pix_multihub_marketplace_id` varchar(100) DEFAULT NULL,
  `pix_multihub_seller_id` varchar(100) DEFAULT NULL,
  `pix_multihub_token` varchar(100) DEFAULT NULL,
  `pix_asaas_key` varchar(100) DEFAULT NULL,
  `pagseguro_email` varchar(100) DEFAULT NULL,
  `pagseguro_public_key` varchar(255) DEFAULT NULL,
  `pagseguro_settings` text DEFAULT NULL,
  `switch_stripe` tinyint(4) NOT NULL DEFAULT 0,
  `stripe_public_key` varchar(150) DEFAULT NULL,
  `stripe_secret_key` varchar(150) DEFAULT NULL,
  `stripe_endpoint_secret` varchar(150) DEFAULT NULL,
  `switch_asaas` int(11) NOT NULL DEFAULT 0,
  `asaas_access_token` varchar(255) DEFAULT NULL,
  `tags` varchar(100) DEFAULT NULL,
  `plan_id` int(11) NOT NULL,
  `plan_expire` date NOT NULL,
  `plan_subscribe_id` varchar(100) DEFAULT NULL,
  `fcm_token` varchar(255) DEFAULT NULL,
  `closed` tinyint(4) NOT NULL DEFAULT 0,
  `closed_reason` varchar(250) DEFAULT NULL,
  `closed_until` text DEFAULT NULL,
  `switch_self_print` tinyint(4) NOT NULL DEFAULT 0,
  `switch_print_resume` tinyint(4) NOT NULL DEFAULT 0,
  `switch_print_group_items` tinyint(4) NOT NULL DEFAULT 0,
  `switch_automatically_accept` tinyint(4) NOT NULL DEFAULT 0,
  `switch_display_after_payment` tinyint(4) NOT NULL DEFAULT 0,
  `type_automatically_accept` tinyint(4) NOT NULL DEFAULT 0,
  `type_bill_show` tinyint(4) NOT NULL DEFAULT 0,
  `social_media` varchar(1000) DEFAULT '{"facebook":{"switch":0,"profile":""},"instagram":{"switch":0,"profile":""},"twitter":{"switch":0,"profile":""}}',
  `switch_free_shipping` tinyint(4) NOT NULL DEFAULT 0,
  `free_shipping_above` decimal(10,2) NOT NULL DEFAULT 0.00,
  `miniature_og` varchar(255) DEFAULT NULL,
  `img_loading` varchar(255) DEFAULT NULL,
  `message_api` varchar(1000) DEFAULT '{"switch":"0","url":"","token":""}',
  `show_report` tinyint(4) NOT NULL DEFAULT 0,
  `segment_id` text DEFAULT NULL,
  `refresh_page_view_orders` smallint(6) NOT NULL DEFAULT 60,
  `show_orders_amount` smallint(6) NOT NULL DEFAULT 10,
  `hidden` tinyint(4) NOT NULL DEFAULT 0,
  `wapi_instance_id` varchar(100) DEFAULT NULL,
  `wapi_instance_secret` varchar(100) DEFAULT NULL,
  `cash_drawer_settings` text DEFAULT NULL,
  `custom_status_messages` text DEFAULT NULL,
  `custom_messages_api` mediumtext DEFAULT NULL,
  `switch_pixel_facebook` tinyint(4) NOT NULL DEFAULT 0,
  `file_code_pixel_facebook` varchar(50) DEFAULT NULL,
  `switch_automatically_apply_coupon` tinyint(4) NOT NULL DEFAULT 0,
  `switch_receive_orders_ifood` tinyint(4) NOT NULL DEFAULT 0,
  `auth_code_ifood` varchar(25) DEFAULT NULL,
  `auth_code_verifier_ifood` varchar(150) DEFAULT NULL,
  `access_token_ifood` varchar(2000) DEFAULT NULL,
  `refresh_token_ifood` varchar(600) DEFAULT NULL,
  `switch_widget_ifood` tinyint(4) NOT NULL DEFAULT 0,
  `widget_merchant_id_ifood` varchar(100) DEFAULT NULL,
  `lucky_roulette_settings` text DEFAULT NULL,
  `switch_charge_per_order` tinyint(4) NOT NULL DEFAULT 0,
  `block_delete_orders` tinyint(4) NOT NULL DEFAULT 0,
  `api` text DEFAULT NULL,
  `switch_console` tinyint(4) NOT NULL DEFAULT 1,
  `console_amount_records` smallint(6) NOT NULL DEFAULT 10,
  `id_code` varchar(16) DEFAULT NULL,
  `branch_store` text DEFAULT NULL,
  `show_item_hide_pdv` tinyint(4) NOT NULL DEFAULT 0,
  `switch_keep_store_open` tinyint(4) NOT NULL DEFAULT 0,
  `switch_pre_rate_waiter` tinyint(4) NOT NULL DEFAULT 0,
  `pre_rate_waiter_type` tinyint(4) NOT NULL DEFAULT 0,
  `pre_rate_waiter_value` decimal(10,2) NOT NULL DEFAULT 0.00,
  `header_hidden` tinyint(4) NOT NULL DEFAULT 0,
  `layout` text DEFAULT NULL,
  `geolocation_key` varchar(255) DEFAULT NULL,
  `doorbell_sound` varchar(255) DEFAULT NULL,
  `switch_plugnotas` tinyint(4) NOT NULL DEFAULT 0,
  `plugnotas_api_key` varchar(100) DEFAULT NULL,
  `plugnotas_cpfcnpj` varchar(30) DEFAULT NULL,
  `plugnotas_taxes` text DEFAULT NULL,
  `delivery_settings` text DEFAULT NULL,
  `switch_table_reservation` tinyint(4) NOT NULL DEFAULT 1,
  `table_reservation_interval` time DEFAULT '02:00:00',
  `switch_focusnfe` tinyint(4) NOT NULL DEFAULT 0,
  `focusnfe_token` varchar(100) DEFAULT NULL,
  `focusnfe_cnpj` varchar(45) DEFAULT NULL,
  `focusnfe_icms_origem` varchar(5) DEFAULT '0',
  `focusnfe_icms_situacao_tributaria` varchar(5) DEFAULT '102',
  `totem_settings` text DEFAULT NULL,
  `notification_settings` text DEFAULT NULL,
  `seo_settings` text DEFAULT NULL,
  `home_page` varchar(45) DEFAULT 'report',
  `lang` varchar(10) DEFAULT 'pt_BR',
  `currency` varchar(10) DEFAULT 'pt-br'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `user_company_id`, `name`, `description`, `link`, `phone_number`, `receive_order_whatsapp`, `document`, `img`, `img_form`, `switch_img_form_item`, `img_header`, `img_favicon`, `switch_layer_fade`, `switch_whatsapp_button`, `switch_img_item`, `template`, `country`, `city`, `state`, `street`, `district`, `number`, `complement`, `zip_code`, `hours`, `estimated_delivery_time`, `estimated_withdrawal_time`, `estimated_table_time`, `date_timezone`, `price_order_min`, `payment_method`, `switch_withdrawal`, `switch_delivery`, `switch_table`, `switch_deliveryman_choose`, `deliveryman_choose_type`, `switch_automatically_deliveryman_choose`, `automatically_deliveryman_choose_type`, `switch_schedule_order`, `switch_cashback`, `cashback_rate`, `delivery_type`, `price_delivery_type`, `price_delivery`, `price_delivery_km_type`, `price_delivery_km`, `price_delivery_km_min`, `max_radius_km`, `mp_state_code`, `mp_public_key`, `mp_access_token`, `mp_refresh_token`, `mp_expire`, `mp_settings`, `pix_type`, `pix_client_id`, `pix_client_secret`, `pix_key`, `pix_certificate`, `pix_key_static`, `pix_efi_account`, `pix_efi_cpf`, `switch_multihub`, `pix_multihub_marketplace_id`, `pix_multihub_seller_id`, `pix_multihub_token`, `pix_asaas_key`, `pagseguro_email`, `pagseguro_public_key`, `pagseguro_settings`, `switch_stripe`, `stripe_public_key`, `stripe_secret_key`, `stripe_endpoint_secret`, `switch_asaas`, `asaas_access_token`, `tags`, `plan_id`, `plan_expire`, `plan_subscribe_id`, `fcm_token`, `closed`, `closed_reason`, `closed_until`, `switch_self_print`, `switch_print_resume`, `switch_print_group_items`, `switch_automatically_accept`, `switch_display_after_payment`, `type_automatically_accept`, `type_bill_show`, `social_media`, `switch_free_shipping`, `free_shipping_above`, `miniature_og`, `img_loading`, `message_api`, `show_report`, `segment_id`, `refresh_page_view_orders`, `show_orders_amount`, `hidden`, `wapi_instance_id`, `wapi_instance_secret`, `cash_drawer_settings`, `custom_status_messages`, `custom_messages_api`, `switch_pixel_facebook`, `file_code_pixel_facebook`, `switch_automatically_apply_coupon`, `switch_receive_orders_ifood`, `auth_code_ifood`, `auth_code_verifier_ifood`, `access_token_ifood`, `refresh_token_ifood`, `switch_widget_ifood`, `widget_merchant_id_ifood`, `lucky_roulette_settings`, `switch_charge_per_order`, `block_delete_orders`, `api`, `switch_console`, `console_amount_records`, `id_code`, `branch_store`, `show_item_hide_pdv`, `switch_keep_store_open`, `switch_pre_rate_waiter`, `pre_rate_waiter_type`, `pre_rate_waiter_value`, `header_hidden`, `layout`, `geolocation_key`, `doorbell_sound`, `switch_plugnotas`, `plugnotas_api_key`, `plugnotas_cpfcnpj`, `plugnotas_taxes`, `delivery_settings`, `switch_table_reservation`, `table_reservation_interval`, `switch_focusnfe`, `focusnfe_token`, `focusnfe_cnpj`, `focusnfe_icms_origem`, `focusnfe_icms_situacao_tributaria`, `totem_settings`, `notification_settings`, `seo_settings`, `home_page`, `lang`, `currency`) VALUES
(1, 2, 'Demonstração', NULL, 'demo', '(15) 98117-2295', 1, NULL, NULL, 0, 0, '70168be0c771114b7085236ec9a116afcb2f01ad.jpg', NULL, 1, 1, 1, '{\"color_menu\":\"#212529\",\"color_menu_text\":\"#ffffff\",\"color_footer\":\"#000000\",\"color_footer_text\":\"#ffffff\",\"background_color\":\"#ececec\"}', 'br', 'Paranaguá', 'Paraná', 'Av. Bento Munhoz da Rocha Neto', 'Jardim América', 1698, 'Loja', '83212-000', '[{\"switch_sun\":0,\"sun_i\":\"00:00:00\",\"sun_u\":\"00:00:00\",\"switch_mon\":0,\"mon_i\":\"00:00\",\"mon_u\":\"00:00\",\"switch_tue\":0,\"tue_i\":\"00:00\",\"tue_u\":\"00:00\",\"switch_wed\":0,\"wed_i\":\"00:00:00\",\"wed_u\":\"00:00:00\",\"switch_thu\":0,\"thu_i\":\"00:00:00\",\"thu_u\":\"00:00:00\",\"switch_fri\":0,\"fri_i\":\"00:00\",\"fri_u\":\"00:00\",\"switch_sat\":0,\"sat_i\":\"00:00:00\",\"sat_u\":\"00:00:00\"},{\"switch_sun\":0,\"sun_i\":\"00:00:00\",\"sun_u\":\"00:00:00\",\"switch_mon\":0,\"mon_i\":\"00:00\",\"mon_u\":\"00:00\",\"switch_tue\":0,\"tue_i\":\"00:00\",\"tue_u\":\"00:00\",\"switch_wed\":0,\"wed_i\":\"00:00:00\",\"wed_u\":\"00:00:00\",\"switch_thu\":0,\"thu_i\":\"00:00:00\",\"thu_u\":\"00:00:00\",\"switch_fri\":0,\"fri_i\":\"00:00\",\"fri_u\":\"00:00\",\"switch_sat\":0,\"sat_i\":\"00:00:00\",\"sat_u\":\"00:00:00\"},{\"switch_sun\":0,\"sun_i\":\"00:00:00\",\"sun_u\":\"00:00:00\",\"switch_mon\":0,\"mon_i\":\"00:00\",\"mon_u\":\"00:00\",\"switch_tue\":0,\"tue_i\":\"00:00\",\"tue_u\":\"00:00\",\"switch_wed\":0,\"wed_i\":\"00:00:00\",\"wed_u\":\"00:00:00\",\"switch_thu\":0,\"thu_i\":\"00:00:00\",\"thu_u\":\"00:00:00\",\"switch_fri\":0,\"fri_i\":\"00:00\",\"fri_u\":\"00:00\",\"switch_sat\":0,\"sat_i\":\"00:00:00\",\"sat_u\":\"00:00:00\"}]', '40 minutos', '60 minutos', '0 minutos', 'America/Sao_Paulo', 15.00, '{\"money\":1,\"card\":1,\"online\":1}', 1, 1, 1, 1, 0, 0, 0, 0, 0, 0.00, 2, 3, 5.00, 0, 0.00, 0.00, 0, 'MP-FJDSIO35OIJO34', NULL, 'APP_USR-5507156311446112-110117-68be79e564d3a0283ac591aefb3c44cf-74707912', 'TG-61802a7b695f3b001aa4c7a0-74707912', '2022-04-30', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 'Pizzaria,Lanchonete,Hambúrgueria', 1, '2024-12-31', NULL, 'eMnhP-JvCFYseGfXwZYgjk:APA91bHZGUBT3APJYU9puctdOy7QPRh8TV2ZVWgVfw6lhPxvXgpME6Tcn-MH7jrzwegtA_MbwiJqayR02I1iEpiLFbualspDIWJDwAGLNcKvlwsHT-WYd5c', 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, '{\"facebook\":{\"switch\":0,\"profile\":\"\"},\"instagram\":{\"switch\":0,\"profile\":\"\"},\"twitter\":{\"switch\":0,\"profile\":\"\"}}', 0, 0.00, NULL, NULL, '{\"switch\":\"0\",\"url\":\"\",\"token\":\"\"}', 0, '0', 60, 10, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, 0, 0, 'b91fad6484141604', NULL, 0, 0, 0, 0, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, '02:00:00', 0, NULL, NULL, '0', '102', NULL, NULL, NULL, 'report', 'pt_BR', 'pt-br');

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

--
-- Table structure for table `company_debt`
--

CREATE TABLE `company_debt` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL DEFAULT -1,
  `type` tinyint(4) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `paid` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `company_rating`
--

CREATE TABLE `company_rating` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `rating` tinyint(4) NOT NULL,
  `reason` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `company_setting`
--

CREATE TABLE `company_setting` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `payment` text NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `console`
--

CREATE TABLE `console` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `message` varchar(200) NOT NULL,
  `date_created` datetime NOT NULL,
  `alert` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cost_km`
--

CREATE TABLE `cost_km` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `distance_until` int(11) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `rate_type` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL DEFAULT -1,
  `user_partner_id` int(11) NOT NULL DEFAULT -1,
  `category_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `code` varchar(25) NOT NULL,
  `amount` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `min_value` decimal(10,2) NOT NULL,
  `max_value` decimal(10,2) NOT NULL,
  `days_week` text NOT NULL,
  `daily_limit` text NOT NULL,
  `reuse` tinyint(4) NOT NULL,
  `alert_client` tinyint(4) NOT NULL,
  `show_in_list` tinyint(4) NOT NULL DEFAULT 1,
  `date_created` date NOT NULL,
  `date_expiration` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `coupon_admin`
--

CREATE TABLE `coupon_admin` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `code` varchar(25) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `date_created` date NOT NULL,
  `date_expiration` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `coupon_used`
--

CREATE TABLE `coupon_used` (
  `id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `date_created` date NOT NULL DEFAULT '2023-01-01'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cron_notify`
--

CREATE TABLE `cron_notify` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `fcm_token` varchar(255) NOT NULL,
  `fcm_token_android` varchar(255) DEFAULT NULL,
  `type` tinyint(4) NOT NULL,
  `item_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL DEFAULT -1,
  `notified_times` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `closed` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `deliveries`
--

CREATE TABLE `deliveries` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `user_deliveryman_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `rate` text NOT NULL,
  `date_created` datetime NOT NULL,
  `date_arrival` datetime NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `deliveryman`
--

CREATE TABLE `deliveryman` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_deliveryman_id` int(11) NOT NULL,
  `is_default` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `deliveryman_data`
--

CREATE TABLE `deliveryman_data` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_deliveryman_id` bigint(20) DEFAULT NULL,
  `mp_app_id` varchar(25) DEFAULT NULL,
  `mp_access_token` varchar(100) DEFAULT NULL,
  `available` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deliveryman_data`
--

INSERT INTO `deliveryman_data` (`id`, `user_deliveryman_id`, `mp_app_id`, `mp_access_token`, `available`, `created_at`, `updated_at`) VALUES
(1, 4, '', '', 1, '2025-09-20 23:03:51', '2025-09-20 23:03:51');

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

--
-- Table structure for table `deliveryman_tip`
--

CREATE TABLE `deliveryman_tip` (
  `id` int(11) NOT NULL,
  `user_deliveryman_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `value` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `district`
--

CREATE TABLE `district` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `price_delivery` decimal(10,2) NOT NULL,
  `days_week` text NOT NULL,
  `hours` text NOT NULL,
  `show_pdv_only` tinyint(4) NOT NULL,
  `free_shipping` tinyint(4) NOT NULL DEFAULT 0,
  `free_shipping_above` decimal(10,2) NOT NULL DEFAULT 0.00,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `fcm_tokens`
--

CREATE TABLE `fcm_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `token_android` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `fix_system`
--

CREATE TABLE `fix_system` (
  `id` int(11) NOT NULL,
  `version` varchar(50) NOT NULL,
  `package` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `function_permission`
--

CREATE TABLE `function_permission` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `settings` text NOT NULL,
  `home_page` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `geolocation`
--

CREATE TABLE `geolocation` (
  `id` int(11) NOT NULL,
  `account_type` tinyint(4) NOT NULL,
  `account_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `lat` varchar(30) NOT NULL,
  `lng` varchar(30) NOT NULL,
  `address` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `greeting_messages`
--

CREATE TABLE `greeting_messages` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `message` mediumtext NOT NULL,
  `off_hours_message` mediumtext DEFAULT NULL,
  `interval_time` int(11) NOT NULL DEFAULT 60,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `has_media` tinyint(1) DEFAULT 0,
  `media_path` varchar(255) DEFAULT NULL,
  `original_filename` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `header_slide`
--

CREATE TABLE `header_slide` (
  `id` int(11) NOT NULL,
  `img_slide` varchar(100) NOT NULL,
  `img_slide_mobile` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `subtitle` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `template_code` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `holiday`
--

CREATE TABLE `holiday` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item`
--

CREATE TABLE `item` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(35) NOT NULL,
  `description` varchar(1500) NOT NULL,
  `img` varchar(50) NOT NULL,
  `img_hidden` tinyint(4) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `price_cost` decimal(10,2) NOT NULL,
  `price_offer` decimal(10,2) NOT NULL,
  `img_offer` varchar(50) NOT NULL,
  `price_type` tinyint(4) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `flavor_amount_min` int(11) NOT NULL,
  `flavor_amount` int(11) NOT NULL,
  `days_week` text NOT NULL,
  `hours` text NOT NULL,
  `amount` int(11) NOT NULL,
  `free_shipping` tinyint(4) NOT NULL,
  `preparation_time` smallint(6) NOT NULL,
  `serve_people_amount` smallint(6) NOT NULL,
  `external_code` varchar(10) NOT NULL,
  `is_unavailable_delivery` tinyint(4) NOT NULL,
  `unit_measure_type` tinyint(4) NOT NULL,
  `cashback` tinyint(4) NOT NULL DEFAULT 1,
  `switch_up_selling` tinyint(4) NOT NULL,
  `up_selling` text NOT NULL,
  `ncm_code` varchar(15) NOT NULL,
  `hidden` tinyint(4) NOT NULL,
  `position` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_additionals`
--

CREATE TABLE `item_additionals` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `additional_category_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(1500) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `max` int(11) NOT NULL,
  `hide_free_name` tinyint(4) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT -1,
  `external_code` varchar(10) NOT NULL,
  `hidden` tinyint(4) NOT NULL,
  `position` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_additional_category`
--

CREATE TABLE `item_additional_category` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `description` varchar(1500) NOT NULL,
  `additional_max` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `required_quantity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_additional_group`
--

CREATE TABLE `item_additional_group` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `additional_category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_bank`
--

CREATE TABLE `item_bank` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `date_expiration` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_comment`
--

CREATE TABLE `item_comment` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_comment_allow`
--

CREATE TABLE `item_comment_allow` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_flavor`
--

CREATE TABLE `item_flavor` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `name` varchar(80) NOT NULL,
  `description` varchar(200) NOT NULL,
  `img` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `max` int(11) NOT NULL,
  `days_week` text NOT NULL,
  `hours` text NOT NULL,
  `amount` int(11) NOT NULL DEFAULT -1,
  `external_code` varchar(10) NOT NULL,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_purchased`
--

CREATE TABLE `item_purchased` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL DEFAULT -1,
  `company_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `price_unit` decimal(10,2) NOT NULL,
  `price_total` decimal(10,2) NOT NULL,
  `date` datetime NOT NULL,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_rating`
--

CREATE TABLE `item_rating` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `rating` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_size`
--

CREATE TABLE `item_size` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `name` varchar(80) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT -1,
  `subtract_amount` int(11) NOT NULL DEFAULT 1,
  `default_size` tinyint(4) NOT NULL,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_slide`
--

CREATE TABLE `item_slide` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `img` varchar(50) NOT NULL,
  `type` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_stamps`
--

CREATE TABLE `item_stamps` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `item_stamp_group`
--

CREATE TABLE `item_stamp_group` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `stamp_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `log_type` smallint(6) NOT NULL,
  `log` text NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '2023-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `logs` (`id`, `company_id`, `log_type`, `log`, `date_created`) VALUES
(1, -1, 1, 'Artisan view:clear executed!', '2025-09-20 17:04:52');

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

--
-- Table structure for table `lucky_roulette`
--

CREATE TABLE `lucky_roulette` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `color` varchar(10) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `coupon_settings` text NOT NULL,
  `item_settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `lucky_roulette_accumulated`
--

CREATE TABLE `lucky_roulette_accumulated` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `value` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `lucky_roulette_report`
--

CREATE TABLE `lucky_roulette_report` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `report` varchar(255) NOT NULL,
  `type` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `lucky_roulette_spin`
--

CREATE TABLE `lucky_roulette_spin` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `available_spins` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `menu_print_settings`
--

CREATE TABLE `menu_print_settings` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `message_api`
--

CREATE TABLE `message_api` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `type` tinyint(4) NOT NULL,
  `hot` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `nfce`
--

CREATE TABLE `nfce` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `message` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notification_popup`
--

CREATE TABLE `notification_popup` (
  `id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `message` varchar(255) NOT NULL,
  `date_expiration` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notification_popup_read`
--

CREATE TABLE `notification_popup_read` (
  `id` int(11) NOT NULL,
  `notification_popup_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notification_read`
--

CREATE TABLE `notification_read` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notification_scheduled`
--

CREATE TABLE `notification_scheduled` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `notification_option` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`notification_option`)),
  `type` tinyint(3) UNSIGNED NOT NULL COMMENT '0 = últimos clientes, 1 = entre datas, 2 = mais ativos, 3 = especifico, 4 = todos',
  `customers_quantity` int(10) UNSIGNED DEFAULT NULL,
  `customer_identifier_id` int(10) UNSIGNED DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `recurring` tinyint(1) NOT NULL DEFAULT 0,
  `recurring_day` tinyint(3) UNSIGNED DEFAULT NULL COMMENT '1 a 31 (dia fixo do mês)',
  `recurring_weekday` enum('monday','tuesday','wednesday','thursday','friday','saturday','sunday') DEFAULT NULL,
  `recurring_time` time DEFAULT NULL,
  `schedule_date` datetime DEFAULT NULL COMMENT 'Para notificações não recorrentes',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `user_company_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `user_client_phone_number` varchar(20) NOT NULL,
  `code` varchar(20) NOT NULL,
  `order_data` mediumtext NOT NULL,
  `delivery_type` tinyint(4) NOT NULL,
  `delivery_address` text NOT NULL,
  `delivery_table` text NOT NULL,
  `price_order` decimal(10,2) NOT NULL,
  `price_delivery` decimal(10,2) NOT NULL,
  `price_total` decimal(10,2) NOT NULL,
  `price_cost` decimal(10,2) NOT NULL,
  `payment_method` tinyint(4) NOT NULL,
  `online_method` tinyint(4) NOT NULL,
  `exchanged` tinyint(4) NOT NULL,
  `price_exchanged` decimal(10,2) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `is_schedule_order` tinyint(4) NOT NULL,
  `datetime_schedule_order` datetime NOT NULL DEFAULT '2023-01-01 00:00:00',
  `status` tinyint(4) NOT NULL,
  `paid` tinyint(4) NOT NULL,
  `mp_link` varchar(255) NOT NULL,
  `mp_preference_id` varchar(100) NOT NULL,
  `pix_payload` varchar(300) NOT NULL,
  `pix_txid` varchar(100) NOT NULL,
  `pix_mp` text NOT NULL,
  `pix_multihub` text NOT NULL,
  `pix_asaas` text NOT NULL,
  `pagseguro_link` varchar(255) NOT NULL,
  `stripe_link` varchar(500) NOT NULL,
  `multihub_link` varchar(255) NOT NULL,
  `asaas_link` varchar(255) NOT NULL,
  `is_split_payment` tinyint(4) NOT NULL,
  `ifood_event_id` varchar(100) NOT NULL,
  `ifood_order_id` varchar(100) NOT NULL,
  `log` text NOT NULL,
  `rate` text NOT NULL,
  `reason_cancel` varchar(500) NOT NULL,
  `source_type` tinyint(4) NOT NULL DEFAULT -1,
  `printed` tinyint(4) NOT NULL,
  `warned` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `orders_deleted`
--

CREATE TABLE `orders_deleted` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `order_info` text NOT NULL,
  `price_order` decimal(10,2) NOT NULL,
  `price_total` decimal(10,2) NOT NULL,
  `order_date_created` datetime NOT NULL,
  `date_deleted` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `orders_print_settings`
--

CREATE TABLE `orders_print_settings` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `orders_split_payment`
--

CREATE TABLE `orders_split_payment` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `order_code` varchar(20) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `method` tinyint(4) NOT NULL,
  `data` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `paid` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `orders_view_settings`
--

CREATE TABLE `orders_view_settings` (
  `id` int(11) NOT NULL,
  `company_id` int(50) NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `partner`
--

CREATE TABLE `partner` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_partner_id` int(11) NOT NULL,
  `commission_type` tinyint(4) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `request_confirm` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `partner_report`
--

CREATE TABLE `partner_report` (
  `id` int(11) NOT NULL,
  `user_partner_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `coupon_code` varchar(25) NOT NULL,
  `order_code` varchar(20) NOT NULL,
  `commission_type` tinyint(4) NOT NULL,
  `commission_value` decimal(10,2) NOT NULL,
  `paid` tinyint(4) NOT NULL,
  `request_code` varchar(45) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `partner_request`
--

CREATE TABLE `partner_request` (
  `id` int(11) NOT NULL,
  `user_partner_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `code` varchar(45) NOT NULL,
  `commission_total` decimal(10,2) NOT NULL,
  `paid` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `payment_settings`
--

CREATE TABLE `payment_settings` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `method` tinyint(4) NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `plans` (
  `id` int(11) NOT NULL,
  `title` varchar(30) NOT NULL,
  `days` int(11) NOT NULL,
  `months` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `limit_orders_month` smallint(6) NOT NULL,
  `limit_categorys` smallint(6) NOT NULL,
  `limit_items` smallint(6) NOT NULL,
  `limit_citys` smallint(6) NOT NULL,
  `limit_districts` smallint(6) NOT NULL,
  `limit_deliverymans` smallint(6) NOT NULL,
  `limit_coupons` smallint(6) NOT NULL,
  `limit_banners` smallint(6) NOT NULL DEFAULT 5,
  `banner` tinyint(4) NOT NULL,
  `geolocation` tinyint(4) NOT NULL,
  `support` tinyint(4) NOT NULL,
  `cashback` tinyint(4) NOT NULL,
  `self_print` tinyint(4) NOT NULL,
  `notification` tinyint(4) NOT NULL,
  `notification_day_amount` tinyint(4) NOT NULL,
  `message_api` tinyint(4) NOT NULL,
  `messages_amount` int(11) NOT NULL,
  `payment_methods` text NOT NULL,
  `lucky_roulette` tinyint(4) NOT NULL,
  `lucky_roulette_amount` tinyint(4) NOT NULL,
  `ifood` tinyint(4) NOT NULL,
  `widget_ifood` tinyint(4) NOT NULL,
  `charge_per_order` tinyint(4) NOT NULL,
  `price_per_order` decimal(10,2) NOT NULL,
  `free_plan` tinyint(4) NOT NULL,
  `price_max_free_plan` decimal(10,2) NOT NULL,
  `unlock_plan` tinyint(4) NOT NULL,
  `days_unlock_plan` tinyint(4) NOT NULL,
  `catalog` tinyint(4) NOT NULL DEFAULT 1,
  `pdv` tinyint(4) NOT NULL DEFAULT 1,
  `bill` tinyint(4) NOT NULL DEFAULT 1,
  `counter` tinyint(4) NOT NULL DEFAULT 1,
  `totem` tinyint(4) NOT NULL DEFAULT 1,
  `kds` tinyint(4) NOT NULL DEFAULT 1,
  `pwa` tinyint(4) NOT NULL DEFAULT 1,
  `single_use` tinyint(4) NOT NULL,
  `show_google_adsense` tinyint(4) NOT NULL DEFAULT 1,
  `plugnotas` tinyint(4) NOT NULL DEFAULT 1,
  `focusnfe` tinyint(4) NOT NULL DEFAULT 1,
  `reservation` tinyint(4) NOT NULL DEFAULT 1,
  `custom_options` text NOT NULL,
  `hidden` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `title`, `days`, `months`, `price`, `limit_orders_month`, `limit_categorys`, `limit_items`, `limit_citys`, `limit_districts`, `limit_deliverymans`, `limit_coupons`, `limit_banners`, `banner`, `geolocation`, `support`, `cashback`, `self_print`, `notification`, `notification_day_amount`, `message_api`, `messages_amount`, `payment_methods`, `lucky_roulette`, `lucky_roulette_amount`, `ifood`, `widget_ifood`, `charge_per_order`, `price_per_order`, `free_plan`, `price_max_free_plan`, `unlock_plan`, `days_unlock_plan`, `catalog`, `pdv`, `bill`, `counter`, `totem`, `kds`, `pwa`, `single_use`, `show_google_adsense`, `plugnotas`, `focusnfe`, `reservation`, `custom_options`, `hidden`) VALUES
(1, 'Básico', 30, 1, 30.00, -1, -1, -1, -1, -1, -1, -1, 5, 1, 0, 1, 0, 1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0.00, 0, 0.00, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, '', 1);

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

--
-- Table structure for table `plans_debts`
--

CREATE TABLE `plans_debts` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `paid` tinyint(4) NOT NULL,
  `paid_in` date NOT NULL,
  `plan_expire_in` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `plans_unlock`
--

CREATE TABLE `plans_unlock` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `plan_expire_old` date NOT NULL,
  `plan_expire_new` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `plans_used`
--

CREATE TABLE `plans_used` (
  `id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `printer`
--

CREATE TABLE `printer` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `font_name` varchar(50) NOT NULL,
  `font_size` int(11) NOT NULL,
  `font_color` varchar(7) NOT NULL,
  `spacing_type` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `pwa`
--

CREATE TABLE `pwa` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `settings` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `recover_access`
--

CREATE TABLE `recover_access` (
  `id` int(11) NOT NULL,
  `account_type` tinyint(4) NOT NULL,
  `account_id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `date_expiration` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `report_admin`
--

CREATE TABLE `report_admin` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_client_id` int(11) NOT NULL,
  `report` text NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `gain_value` decimal(10,2) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `type_icon` tinyint(4) NOT NULL,
  `date_created` date NOT NULL DEFAULT '2023-01-01'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `security_confirm_pn`
--

CREATE TABLE `security_confirm_pn` (
  `id` int(11) NOT NULL,
  `phone_number` varchar(30) NOT NULL,
  `code` varchar(15) NOT NULL,
  `confirm` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `segment`
--

CREATE TABLE `segment` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `img` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tables`
--

CREATE TABLE `tables` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `table_number` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tables_reservations`
--

CREATE TABLE `tables_reservations` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `table_reservation_group_id` int(11) NOT NULL,
  `table_id` int(11) NOT NULL,
  `code` varchar(45) NOT NULL,
  `data` text NOT NULL,
  `confirmed` tinyint(4) NOT NULL,
  `finished` tinyint(4) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tables_reservations_group`
--

CREATE TABLE `tables_reservations_group` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `tables_id` text NOT NULL,
  `title` varchar(45) NOT NULL,
  `description` varchar(255) NOT NULL,
  `switch_rate` tinyint(4) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `img` varchar(100) NOT NULL,
  `max_period` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `template_custom`
--

CREATE TABLE `template_custom` (
  `id` int(11) NOT NULL,
  `code` varchar(45) NOT NULL,
  `settings` text NOT NULL,
  `colors` text NOT NULL,
  `images` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `template_pages`
--

CREATE TABLE `template_pages` (
  `id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `setting` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `template_slide`
--

CREATE TABLE `template_slide` (
  `id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `img` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `section` varchar(70) NOT NULL,
  `subject` varchar(50) NOT NULL,
  `priority` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `ticket_message`
--

CREATE TABLE `ticket_message` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `message` text NOT NULL,
  `date_created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tutorial`
--

CREATE TABLE `tutorial` (
  `id` int(11) NOT NULL,
  `title` varchar(30) NOT NULL,
  `subtitle` varchar(100) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `link` varchar(255) NOT NULL,
  `text_html` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tutorial`
--

INSERT INTO `tutorial` (`id`, `title`, `subtitle`, `type`, `link`, `text_html`) VALUES
(1, 'Configurar Pix', 'Guia para configuração do meio de pagamento pix', 0, '', '&lt;p&gt;&lt;strong&gt;Criando conta e aplicativo&amp;nbsp;&lt;/strong&gt;&lt;/p&gt;\n\n&lt;ol&gt;\n	&lt;li&gt;Crie a sua conta na &lt;a href=&quot;https://gerencianet.com.br&quot;&gt;Gerencianet&lt;/a&gt;;&lt;/li&gt;\n	&lt;li&gt;Acesse sua conta e clique no item &amp;quot;API&amp;quot; no menu superior da conta Gerencianet;&lt;/li&gt;\n	&lt;li&gt;No menu &amp;agrave; esquerda, clique em &amp;quot;Minhas Aplica&amp;ccedil;&amp;otilde;es&amp;quot; e &amp;quot;Nova Aplica&amp;ccedil;&amp;atilde;o&amp;quot;;&lt;/li&gt;\n	&lt;li&gt;Habilite a API Pix e escolha os escopos que deseja liberar em ambiente de Produ&amp;ccedil;&amp;atilde;o e Homologa&amp;ccedil;&amp;atilde;o (voc&amp;ecirc; pode edit&amp;aacute;-los no futuro);&lt;/li&gt;\n	&lt;li&gt;Com os escopos selecionados, clique em &amp;quot;Criar nova aplica&amp;ccedil;&amp;atilde;o&amp;quot;.&lt;/li&gt;\n&lt;/ol&gt;\n\n&lt;p&gt;&lt;strong&gt;Gerando o certificado&lt;/strong&gt;&lt;/p&gt;\n\n&lt;ol&gt;\n	&lt;li&gt;Acesse o item &amp;quot;API&amp;quot; no menu superior da conta Gerencianet;&lt;/li&gt;\n	&lt;li&gt;No menu &amp;agrave; esquerda, clique em &amp;quot;Meus Certificados&amp;quot;;&lt;/li&gt;\n	&lt;li&gt;Na nova janela selecione o ambiente ao qual pertencer&amp;aacute; o certificado (Produ&amp;ccedil;&amp;atilde;o ou Homologa&amp;ccedil;&amp;atilde;o)&lt;/li&gt;\n	&lt;li&gt;Clique em &amp;quot;Novo Certificado&amp;quot; (bot&amp;atilde;o laranja);&lt;/li&gt;\n	&lt;li&gt;Atribua uma descri&amp;ccedil;&amp;atilde;o ao certificado para identific&amp;aacute;-lo no futuro;&lt;/li&gt;\n	&lt;li&gt;Confirme a cria&amp;ccedil;&amp;atilde;o do certificado;&lt;/li&gt;\n	&lt;li&gt;Por fim, baixe o certificado.&lt;/li&gt;\n&lt;/ol&gt;\n\n&lt;p&gt;&lt;strong&gt;Convers&amp;atilde;o de certificado P12 para o formato PEM&lt;/strong&gt;&lt;/p&gt;\n\n&lt;ol&gt;\n	&lt;li&gt;Abra o prompt de comando no mesmo diret&amp;oacute;rio do seu certificado e execute o seguinte c&amp;oacute;digo, alterando somente o nome do arquivo:&lt;/li&gt;\n	&lt;li&gt;\n	&lt;pre&gt;\n&lt;code&gt;openssl pkcs12 -in certificado.p12 -out certificado.pem -nodes&lt;/code&gt;&lt;/pre&gt;\n	&lt;/li&gt;\n&lt;/ol&gt;\n\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;\n\n&lt;p&gt;Feito estes procedimentos, basta acessar o menu &lt;strong&gt;Configura&amp;ccedil;&amp;otilde;es&lt;/strong&gt;, e preencher os campos de pix.&lt;/p&gt;\n\n&lt;p&gt;Para mais detalhes de como realizar os procedimentos acima, acesse a documenta&amp;ccedil;&amp;atilde;o oficial da &lt;a href=&quot;https://dev.gerencianet.com.br/docs/api-pix-autenticacao-e-seguranca&quot;&gt;Gerencianet&lt;/a&gt;.&lt;/p&gt;\n'),
(10, 'Configurar Pix', 'Guia para configuração do meio de pagamento pix', 0, '', '&lt;p&gt;&lt;strong&gt;Criando conta e aplicativo&amp;nbsp;&lt;/strong&gt;&lt;/p&gt;\n\n&lt;ol&gt;\n	&lt;li&gt;Crie a sua conta na &lt;a href=&quot;https://gerencianet.com.br&quot;&gt;Gerencianet&lt;/a&gt;;&lt;/li&gt;\n	&lt;li&gt;Acesse sua conta e clique no item &amp;quot;API&amp;quot; no menu superior da conta Gerencianet;&lt;/li&gt;\n	&lt;li&gt;No menu &amp;agrave; esquerda, clique em &amp;quot;Minhas Aplica&amp;ccedil;&amp;otilde;es&amp;quot; e &amp;quot;Nova Aplica&amp;ccedil;&amp;atilde;o&amp;quot;;&lt;/li&gt;\n	&lt;li&gt;Habilite a API Pix e escolha os escopos que deseja liberar em ambiente de Produ&amp;ccedil;&amp;atilde;o e Homologa&amp;ccedil;&amp;atilde;o (voc&amp;ecirc; pode edit&amp;aacute;-los no futuro);&lt;/li&gt;\n	&lt;li&gt;Com os escopos selecionados, clique em &amp;quot;Criar nova aplica&amp;ccedil;&amp;atilde;o&amp;quot;.&lt;/li&gt;\n&lt;/ol&gt;\n\n&lt;p&gt;&lt;strong&gt;Gerando o certificado&lt;/strong&gt;&lt;/p&gt;\n\n&lt;ol&gt;\n	&lt;li&gt;Acesse o item &amp;quot;API&amp;quot; no menu superior da conta Gerencianet;&lt;/li&gt;\n	&lt;li&gt;No menu &amp;agrave; esquerda, clique em &amp;quot;Meus Certificados&amp;quot;;&lt;/li&gt;\n	&lt;li&gt;Na nova janela selecione o ambiente ao qual pertencer&amp;aacute; o certificado (Produ&amp;ccedil;&amp;atilde;o ou Homologa&amp;ccedil;&amp;atilde;o)&lt;/li&gt;\n	&lt;li&gt;Clique em &amp;quot;Novo Certificado&amp;quot; (bot&amp;atilde;o laranja);&lt;/li&gt;\n	&lt;li&gt;Atribua uma descri&amp;ccedil;&amp;atilde;o ao certificado para identific&amp;aacute;-lo no futuro;&lt;/li&gt;\n	&lt;li&gt;Confirme a cria&amp;ccedil;&amp;atilde;o do certificado;&lt;/li&gt;\n	&lt;li&gt;Por fim, baixe o certificado.&lt;/li&gt;\n&lt;/ol&gt;\n\n&lt;p&gt;&lt;strong&gt;Convers&amp;atilde;o de certificado P12 para o formato PEM&lt;/strong&gt;&lt;/p&gt;\n\n&lt;ol&gt;\n	&lt;li&gt;Abra o prompt de comando no mesmo diret&amp;oacute;rio do seu certificado e execute o seguinte c&amp;oacute;digo, alterando somente o nome do arquivo:&lt;/li&gt;\n	&lt;li&gt;\n	&lt;pre&gt;\n&lt;code&gt;openssl pkcs12 -in certificado.p12 -out certificado.pem -nodes&lt;/code&gt;&lt;/pre&gt;\n	&lt;/li&gt;\n&lt;/ol&gt;\n\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;\n\n&lt;p&gt;Feito estes procedimentos, basta acessar o menu &lt;strong&gt;Configura&amp;ccedil;&amp;otilde;es&lt;/strong&gt;, e preencher os campos de pix.&lt;/p&gt;\n\n&lt;p&gt;Para mais detalhes de como realizar os procedimentos acima, acesse a documenta&amp;ccedil;&amp;atilde;o oficial da &lt;a href=&quot;https://dev.gerencianet.com.br/docs/api-pix-autenticacao-e-seguranca&quot;&gt;Gerencianet&lt;/a&gt;.&lt;/p&gt;\n'),
(11, 'Configurar Mercadopago', '', 0, '', '<p><strong>Criando conta e aplicativo&nbsp;</strong></p>\r\n\r\n<ol>\r\n	<li>V&aacute; no menu <strong>Configura&ccedil;&otilde;es</strong>;</li>\r\n	<li>Em <strong>Formas de Pagamento</strong>, clique em <strong>Configurar Mercadopago</strong>;</li>\r\n	<li>Na p&aacute;gina aberta do mercadopago, voc&ecirc; dar&aacute; permiss&atilde;o e pronto.</li>\r\n</ol>\r\n'),
(12, 'Configurar PagSeguro', '', 0, '', '<ol>\r\n	<li>V&aacute; no menu <strong>Configura&ccedil;&otilde;es</strong>;</li>\r\n	<li>Em <strong>Formas de Pagamento</strong>, clique em <strong>Configurar Pagseguro</strong>;</li>\r\n	<li>Na p&aacute;gina aberta do mercadopago, voc&ecirc; dar&aacute; permiss&atilde;o e pronto.</li>\r\n</ol>\r\n'),
(13, 'Habilitar Impressão Automática', '', 0, '', '<p><strong>Google Chrome&nbsp;</strong></p>\r\n\r\n<ol>\r\n	<li>Crie um atalho do Google Chrome;</li>\r\n	<li>Clique com o bot&atilde;o direito do mouse no atalho e v&aacute; em &quot;<strong>Propriedades</strong>&quot;;</li>\r\n	<li>Na aba &quot;<strong>Atalho</strong>&quot;, no campo &quot;<strong>Destino</strong>&quot;, logo depois das aspas, de um espa&ccedil;o e especifique o seguinte &quot;<strong>--kiosk-printing</strong>&quot;;</li>\r\n	<li>Ficando algo como: <strong>&quot;C:\\Program Files\\Google\\Chrome\\Application\\chrome.exe&quot; --kiosk-printing</strong></li>\r\n	<li>Feito isso, basta iniciar/reiniciar o navegador e seus pedidos ser&atilde;o imprimidos automaticamente.</li>\r\n</ol>\r\n\r\n<p><strong>Mozilla Firefox</strong></p>\r\n\r\n<ol>\r\n	<li>Abra o navegador e no campo de endere&ccedil;o (url), especifique &quot;<strong>about:config</strong>&quot; e acesse;</li>\r\n	<li>Clique em &quot;<strong>Aceitar o risco e continuar</strong>&quot;;</li>\r\n	<li>No campo de pesquisa, especifique &quot;<strong>print.always_print_silent</strong>&quot; e configure como &quot;<strong>true</strong>&quot;;</li>\r\n	<li>Feito isso, basta iniciar/reiniciar o navegador e seus pedidos ser&atilde;o imprimidos automaticamente.</li>\r\n</ol>\r\n');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `phone_number` varchar(25) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `street` varchar(50) DEFAULT NULL,
  `district` varchar(50) DEFAULT NULL,
  `number` smallint(6) DEFAULT NULL,
  `complement` varchar(50) DEFAULT NULL,
  `zip_code` varchar(50) DEFAULT NULL,
  `date_timezone` varchar(50) DEFAULT NULL,
  `user_type` tinyint(4) NOT NULL,
  `user_level` tinyint(4) DEFAULT NULL,
  `activated` varchar(100) DEFAULT NULL,
  `fcm_token` varchar(255) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `affiliated_id` bigint(20) DEFAULT NULL,
  `function_permission_id` int(11) DEFAULT NULL,
  `google_id` varchar(50) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `pix_key` varchar(255) DEFAULT NULL,
  `is_demo` tinyint(4) NOT NULL DEFAULT 0,
  `is_blocked` tinyint(4) NOT NULL DEFAULT 0,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `password`, `phone_number`, `city`, `state`, `street`, `district`, `number`, `complement`, `zip_code`, `date_timezone`, `user_type`, `user_level`, `activated`, `fcm_token`, `company_id`, `affiliated_id`, `function_permission_id`, `google_id`, `code`, `pix_key`, `is_demo`, `is_blocked`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@admin.com', '$argon2id$v=19$m=65536,t=2,p=2$RGVlbzNRYW12bG42aFZFOA$lAJAlydA4aKjlxloRTsTX4tooy34v7qX+kqjhWcdEoM', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, '2025-09-20 23:03:51', '2025-09-20 20:05:00'),
(2, 'Lojista', 'lojista@igodelivery.com', '$argon2id$v=19$m=65536,t=2,p=2$MjRCWkRSa1JnNlNKdFQ5SA$A8F+qBAjcc1HCSJsQbEwUw4UXsybCNZjGvTW1xwitR0', '(41) 99244-0825', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '1', NULL, NULL, -1, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-09-20 23:03:51', '2025-09-20 20:05:16'),
(3, 'Cliente', 'cliente@igodelivery.com', '$argon2id$v=19$m=65536,t=2,p=2$aDVGdm9PUXpqcmV2YnR1Qg$QWZeAki57QOP0C3xM/l/LNRMV2fgD1yY/b5lQdLvVNs', '(41) 25252-5254', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 1, NULL, '1', 'eMnhP-JvCFYseGfXwZYgjk:APA91bHZGUBT3APJYU9puctdOy7QPRh8TV2ZVWgVfw6lhPxvXgpME6Tcn-MH7jrzwegtA_MbwiJqayR02I1iEpiLFbualspDIWJDwAGLNcKvlwsHT-WYd5c', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-09-20 23:03:51', '2025-09-20 20:05:29'),
(4, 'Entregador', 'entregador@igodelivery.com', '$argon2id$v=19$m=65536,t=2,p=2$UkIwa1BQYTNYTmZKcXBEcg$ZDbtJLamFzapUhSiL25e/rlQp9C/9La7mA92sRZDQ8o', '(12) 31231-2313', 'Paranaguá', 'Paraná', 'Rua das Garças', 'Bairro', 10, '', '83218-280', 'America/Bahia', 2, NULL, '1', 'cINaWb1C7HQ:APA91bHCe1XOCMW30Nf-rlz71BwaeAn1XbypUbpacMmJkmYz7HVXOXT_Up7rg7jlpi88RKzJ96qWbPpZZHLJ9q3oZeiU0Q3X6rPqpwWUlxhDJvZ8UWiasBdemqwzQZOXvyB9jvdGOryx', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, '2025-09-20 23:03:51', '2025-09-20 20:05:43');

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

--
-- Table structure for table `web_setting`
--

CREATE TABLE `web_setting` (
  `id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `img_logo` varchar(255) NOT NULL,
  `img_logo_2` varchar(255) NOT NULL,
  `color_menu_1` varchar(10) NOT NULL,
  `color_menu_2` varchar(10) NOT NULL,
  `subtitle_1` varchar(100) NOT NULL,
  `subtitle_2` varchar(100) NOT NULL,
  `subtitle_3` varchar(100) NOT NULL,
  `header_type` tinyint(4) NOT NULL,
  `img_header_1` varchar(255) NOT NULL,
  `img_header_2` varchar(255) NOT NULL,
  `img_favicon` varchar(255) NOT NULL,
  `img_loading` varchar(255) NOT NULL,
  `landing_html` text NOT NULL,
  `link_google` varchar(100) NOT NULL,
  `link_apple` varchar(100) NOT NULL,
  `account_confirm` text NOT NULL,
  `date_timezone` varchar(50) NOT NULL,
  `terms` text NOT NULL,
  `payment_method` text NOT NULL,
  `mp_app_id` varchar(50) NOT NULL,
  `mp_access_token` varchar(255) NOT NULL,
  `mp_sponsor_id` varchar(20) NOT NULL,
  `mp_rate` decimal(10,2) NOT NULL,
  `mp_subscribe_public_key` varchar(100) NOT NULL,
  `mp_subscribe_access_token` varchar(100) NOT NULL,
  `fcm_config` text NOT NULL,
  `fcm_service_account_file` varchar(100) NOT NULL,
  `firebase_google_services_android` varchar(100) NOT NULL,
  `firebase_service_account_android` varchar(100) NOT NULL,
  `switch_geolocation` tinyint(4) NOT NULL,
  `geolocation_key` varchar(100) NOT NULL,
  `geolocation_radius` tinyint(4) NOT NULL,
  `geolocation_type` tinyint(4) NOT NULL,
  `geolocation_zip_code_key` varchar(100) NOT NULL,
  `switch_geolocation_individual_key` tinyint(4) NOT NULL,
  `pix_payload` varchar(300) NOT NULL,
  `switch_adsense` tinyint(4) NOT NULL,
  `adsense_client` varchar(50) NOT NULL,
  `loading_message` text NOT NULL,
  `pagseguro_appid` varchar(100) NOT NULL,
  `pagseguro_appkey` varchar(100) NOT NULL,
  `pagseguro_rate` decimal(10,2) NOT NULL,
  `pagseguro_email` varchar(100) NOT NULL,
  `pagseguro_token` varchar(100) NOT NULL,
  `pagseguro_payment_module_checkout_pro_allow` tinyint(4) NOT NULL,
  `initial_plan_id` int(11) NOT NULL,
  `account_register` text NOT NULL,
  `account_login` text NOT NULL,
  `api` text NOT NULL,
  `cashback_type` tinyint(4) NOT NULL,
  `cashback_rate` decimal(10,2) NOT NULL,
  `miniature_og` varchar(255) NOT NULL,
  `description_og` varchar(255) NOT NULL,
  `template_settings` text NOT NULL,
  `template_button_menu` text NOT NULL,
  `template_colors` text NOT NULL,
  `receive_type` tinyint(4) NOT NULL,
  `payment_plan_type` tinyint(4) NOT NULL,
  `description_seo_google` varchar(200) NOT NULL,
  `switch_wapi_native_sale` tinyint(4) NOT NULL,
  `whatsapp_endpoint` varchar(100) NOT NULL,
  `whatsapp_api_type` tinyint(4) NOT NULL,
  `wapi_instance_id` varchar(100) NOT NULL,
  `wapi_instance_secret` varchar(100) NOT NULL,
  `switch_recaptcha_google_v3` tinyint(4) NOT NULL,
  `recaptcha_google_v3_public_key` varchar(100) NOT NULL,
  `recaptcha_google_v3_secret_key` varchar(100) NOT NULL,
  `recaptcha_google_v3_score` double NOT NULL,
  `affiliated_commission_type` tinyint(4) NOT NULL,
  `affiliated_payment_type` tinyint(4) NOT NULL,
  `affiliated_value` decimal(10,2) NOT NULL,
  `switch_pixel_facebook` tinyint(4) NOT NULL,
  `file_code_pixel_facebook` varchar(50) NOT NULL,
  `switch_ifood` tinyint(4) NOT NULL,
  `client_id_ifood` varchar(100) NOT NULL,
  `client_secret_ifood` varchar(150) NOT NULL,
  `switch_widget_ifood` tinyint(4) NOT NULL,
  `widget_id_ifood` varchar(100) NOT NULL,
  `pix_efi_type` tinyint(4) NOT NULL,
  `pix_efi_client_id` varchar(100) NOT NULL,
  `pix_efi_client_secret` varchar(100) NOT NULL,
  `pix_efi_key` varchar(100) NOT NULL,
  `pix_efi_certificate` varchar(100) NOT NULL,
  `pix_efi_rate` decimal(10,2) NOT NULL,
  `pix_mp_type` tinyint(4) NOT NULL,
  `pix_mp_rate` decimal(10,2) NOT NULL,
  `asaas_access_token` varchar(255) NOT NULL,
  `asaas_wallet_id` varchar(255) NOT NULL,
  `asaas_rate` decimal(10,2) NOT NULL,
  `active_template_code` varchar(45) NOT NULL,
  `active_template_code_login` varchar(45) NOT NULL DEFAULT 'default',
  `lang` varchar(45) NOT NULL DEFAULT 'pt_BR',
  `switch_google_tag_manager` tinyint(4) NOT NULL,
  `google_tag_manager_settings` text NOT NULL,
  `jwt` varchar(500) NOT NULL,
  `switch_google_account` tinyint(4) NOT NULL,
  `google_account_client_id` varchar(255) NOT NULL,
  `google_account_client_secret` varchar(255) NOT NULL,
  `redirect_logout` text NOT NULL,
  `custom_messages_api` text NOT NULL,
  `preferences` text NOT NULL,
  `security_confirm_phone_number` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_setting`
--

INSERT INTO `web_setting` (`id`, `name`, `email`, `phone_number`, `img_logo`, `img_logo_2`, `color_menu_1`, `color_menu_2`, `subtitle_1`, `subtitle_2`, `subtitle_3`, `header_type`, `img_header_1`, `img_header_2`, `img_favicon`, `img_loading`, `landing_html`, `link_google`, `link_apple`, `account_confirm`, `date_timezone`, `terms`, `payment_method`, `mp_app_id`, `mp_access_token`, `mp_sponsor_id`, `mp_rate`, `mp_subscribe_public_key`, `mp_subscribe_access_token`, `fcm_config`, `fcm_service_account_file`, `firebase_google_services_android`, `firebase_service_account_android`, `switch_geolocation`, `geolocation_key`, `geolocation_radius`, `geolocation_type`, `geolocation_zip_code_key`, `switch_geolocation_individual_key`, `pix_payload`, `switch_adsense`, `adsense_client`, `loading_message`, `pagseguro_appid`, `pagseguro_appkey`, `pagseguro_rate`, `pagseguro_email`, `pagseguro_token`, `pagseguro_payment_module_checkout_pro_allow`, `initial_plan_id`, `account_register`, `account_login`, `api`, `cashback_type`, `cashback_rate`, `miniature_og`, `description_og`, `template_settings`, `template_button_menu`, `template_colors`, `receive_type`, `payment_plan_type`, `description_seo_google`, `switch_wapi_native_sale`, `whatsapp_endpoint`, `whatsapp_api_type`, `wapi_instance_id`, `wapi_instance_secret`, `switch_recaptcha_google_v3`, `recaptcha_google_v3_public_key`, `recaptcha_google_v3_secret_key`, `recaptcha_google_v3_score`, `affiliated_commission_type`, `affiliated_payment_type`, `affiliated_value`, `switch_pixel_facebook`, `file_code_pixel_facebook`, `switch_ifood`, `client_id_ifood`, `client_secret_ifood`, `switch_widget_ifood`, `widget_id_ifood`, `pix_efi_type`, `pix_efi_client_id`, `pix_efi_client_secret`, `pix_efi_key`, `pix_efi_certificate`, `pix_efi_rate`, `pix_mp_type`, `pix_mp_rate`, `asaas_access_token`, `asaas_wallet_id`, `asaas_rate`, `active_template_code`, `active_template_code_login`, `lang`, `switch_google_tag_manager`, `google_tag_manager_settings`, `jwt`, `switch_google_account`, `google_account_client_id`, `google_account_client_secret`, `redirect_logout`, `custom_messages_api`, `preferences`, `security_confirm_phone_number`) VALUES
(1, 'iGO Delivery', 'admin@admin.com', '', '4b27967a176c5237dd9ed95034895e4db42c0df7.png', '', '#000000', '#c33437', 'Os que mais matam a fome da galera.', 'Chegaram para ajudar a matar a fome da galera.', 'Os melhores estabelecimentos estão aqui.', 0, '1cc5d2293c50c99c13cd1f85621d5daf2a5f1bb3.png', '029af204a0081254bdf7ef68a29b26642f25ef30.png', '', 'loading.gif', '&lt;div class=&quot;p-4&quot; style=&quot;background-color: #f3f0ef; color: #797878;&quot;&gt; &lt;div class=&quot;mb-4 d-flex flex-column text-center&quot;&gt; &lt;h4 class=&quot;m-0 d-none d-md-block&quot;&gt;&lt;b&gt;Cadastre seu estabelecimento&lt;/b&gt;&lt;/h4&gt; &lt;h5 class=&quot;m-0 d-block d-md-none&quot;&gt;&lt;b&gt;Cadastre seu estabelecimento&lt;/b&gt;&lt;/h5&gt; &lt;small&gt;Tem uma galera esperando voc&ecirc; para matar a fome.&lt;/small&gt; &lt;/div&gt; &lt;div class=&quot;px-4 pt-4 d-flex position-relative&quot; style=&quot;border-radius: 15px; background: linear-gradient(110deg, #bc3337 0%, #bc3337 60%, #ffffff 26%); box-shadow: 0px 0px 10px #00000080;&quot;&gt; &lt;div class=&quot;d-block d-md-none position-absolute top-0 start-0 w-100 h-100&quot; style=&quot;border-radius: 15px; background-color: #bc3337; z-index: 0;&quot;&gt; &nbsp; &lt;/div&gt; &lt;div class=&quot;row&quot; style=&quot;z-index: 1;&quot;&gt; &lt;div class=&quot;col&quot;&gt; &lt;div class=&quot;d-flex flex-column text-white p-3&quot;&gt; &lt;h1 class=&quot;d-none d-lg-block&quot;&gt;&lt;b&gt;Card&aacute;pio Online&lt;/b&gt;&lt;/h1&gt; &lt;h4 class=&quot;d-block d-lg-none&quot;&gt;&lt;b&gt;Card&aacute;pio Online&lt;/b&gt;&lt;/h4&gt; &lt;span class=&quot;fs-5 d-none d-lg-block&quot;&gt;Seus clientes querem facilidade, praticidade e rapidez e n&oacute;s temos.&lt;/span&gt; &lt;span class=&quot;d-lg-none&quot; style=&quot;font-size: 0.8rem !important;&quot;&gt;Seus clientes querem facilidade, praticidade e rapidez e n&oacute;s temos.&lt;/span&gt; &lt;div class=&quot;mt-3&quot;&gt; &lt;button class=&quot;btn btn-white px-5&quot; onclick=&quot;window.location.href = &amp;#39;panel/company/register&amp;#39;;&quot;&gt;&lt;b&gt;Come&ccedil;ar&lt;/b&gt;&lt;/button&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class=&quot;col d-none d-md-block&quot;&gt; &lt;div class=&quot;d-none d-md-block&quot;&gt; &lt;img src=&quot;public/images/template/cell.png&quot; class=&quot;d-none d-lg-block&quot;&gt; &lt;img src=&quot;public/images/template/cell.png&quot; style=&quot;width: 430px; height: 270px;&quot; class=&quot;d-block d-lg-none&quot;&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class=&quot;mt-4 d-flex flex-column text-center&quot;&gt; &lt;h4 class=&quot;d-none d-md-block&quot;&gt;&lt;b&gt;D&uacute;vidas? Chama a gente no&lt;/b&gt;&lt;/h4&gt; &lt;h5 class=&quot;d-block d-md-none&quot;&gt;&lt;b&gt;D&uacute;vidas? Chama a gente no&lt;/b&gt;&lt;/h5&gt; &lt;div class=&quot;&quot;&gt; &lt;a href=&quot;https://api.whatsapp.com/send?phone=5515981172295&amp;text=Ol&aacute;! Estou entrando em contato para...&quot;&gt;&lt;img class=&quot;img-fluid&quot; src=&quot;public/images/template/whatsapp.png&quot;&gt;&lt;/a&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt;', '', '', '{\"company\":\"0\",\"client\":\"0\",\"deliveryman\":\"0\"}', 'America/Sao_Paulo', '<p><strong>Termos e Condi&ccedil;&otilde;es</strong></p>\n\n<p>Por favor, leia com aten&ccedil;&atilde;o os termos e condi&ccedil;&otilde;es. Ao se cadastrar no igo.delivery voc&ecirc; EST&Aacute; DE ACORDO COM AS CONDI&Ccedil;&Otilde;ES E TERMOS do Website. Note que a recusa destes Termos do Website impedir&aacute; que voc&ecirc; fa&ccedil;a pedidos de produtos do nosso Website.</p>\n\n<p><strong>1. SERVI&Ccedil;OS OFERECIDOS</strong><br />\n1.1 Este TERMO se aplica para regular o uso do servi&ccedil;o oferecido pelo igo.delivery aos USU&Aacute;RIOS, qual seja, possibilitar a escolha, pelos USU&Aacute;RIOS, de RESTAURANTES cadastrados e, via on-line, efetivar solicita&ccedil;&otilde;es para aquisi&ccedil;&atilde;o (e entrega em domic&iacute;lio e retirada no local) de g&ecirc;neros aliment&iacute;cios fornecidos pelos RESTAURANTES, de acordo com o card&aacute;pio disponibilizado, sendo poss&iacute;vel, igualmente, aos USU&Aacute;RIOS, a efetiva&ccedil;&atilde;o do pagamento do pre&ccedil;o dos produtos via on-line.</p>\n\n<p>1.2 O servi&ccedil;o do igo.delivery consiste, portanto, em aproximar, atrav&eacute;s do nosso site, os USU&Aacute;RIOS e os RESTAURANTES cadastrados, possibilitando que os USU&Aacute;RIOS encaminhem, aos RESTAURANTES, pedidos de entrega de g&ecirc;neros aliment&iacute;cios, bem como, sendo essa a op&ccedil;&atilde;o dos USU&Aacute;RIOS, receber on-line pagamento do pre&ccedil;o dos produtos entregues aos USU&Aacute;RIOS pelos RESTAURANTES.</p>\n\n<p>1.3 Desde logo fica esclarecido ao USU&Aacute;RIO - o qual se declara ciente - que o servi&ccedil;o oferecido pelo igo.delivery se relaciona apenas &agrave; intermedia&ccedil;&atilde;o (com op&ccedil;&atilde;o de pagamento on-line) para comercializa&ccedil;&atilde;o de produtos aliment&iacute;cios, n&atilde;o abarcando preparo, embalagem, disponibiliza&ccedil;&atilde;o e entrega f&iacute;sica (via motoboy ou outros meios) dos produtos, sendo esses quatro itens de responsabilidade integral do RESTAURANTE, a quem dever&atilde;o ser direcionados quaisquer reclamos acerca de problemas decorrentes de v&iacute;cio, defeito ou inexecu&ccedil;&atilde;o da feitura, preparo e entrega de produtos aliment&iacute;cios.</p>\n\n<p><strong>2. CADASTRO</strong><br />\n2.1 O USU&Aacute;RIO, para utilizar os servi&ccedil;os acima descritos, dever&aacute; ter capacidade jur&iacute;dica para atos civis e dever&aacute;, necessariamente, prestar as informa&ccedil;&otilde;es exigidas no CADASTRO, assumindo integralmente a responsabilidade (inclusive c&iacute;vel e criminal) pela exatid&atilde;o e veracidade das informa&ccedil;&otilde;es fornecidas no CADASTRO, que poder&aacute; ser verificado, a qualquer momento, pelo igo.delivery.</p>\n\n<p>2.1.1 Em caso de informa&ccedil;&otilde;es incorretas, inver&iacute;dicas ou n&atilde;o confirmadas, bem assim na hip&oacute;tese da negativa em corrigi-las ou enviar documenta&ccedil;&atilde;o que comprove a corre&ccedil;&atilde;o, o igo delivery se reserva o direito de n&atilde;o concluir o cadastramento em curso ou, ainda, de bloquear o cadastro j&aacute; existente, impedindo o USU&Aacute;RIO de utilizar os servi&ccedil;os on-line at&eacute; que, a crit&eacute;rio do igo.delivery , a situa&ccedil;&atilde;o de anomalia esteja regularizada. O igo.delivery se reserva o direito de impedir, a seu crit&eacute;rio, novos CADASTROS, ou cancelar os j&aacute; efetuados, em caso de ser detectada anomalia que, em sua an&aacute;lise, seja revestida de gravidade ou demonstre tentativa deliberada de burlar as regras aqui descritas, obrigat&oacute;rias para todos os USU&Aacute;RIOS. Tamb&eacute;m agir&aacute; o igo.delivery de tal forma caso verifique descumprimento, pelo USU&Aacute;RIO, de qualquer obriga&ccedil;&atilde;o prevista no presente TERMO.</p>\n\n<p>2.2 Efetuado, com sucesso, o CADASTRO, o USU&Aacute;RIO ter&aacute; acesso aos servi&ccedil;os por meio de login e senha, dados esses que se compromete a n&atilde;o divulgar a terceiros, ficando sob sua exclusiva responsabilidade qualquer solicita&ccedil;&atilde;o de servi&ccedil;o que seja feita com o uso de login e senha de sua titularidade.</p>\n\n<p><strong>3. OBRIGA&Ccedil;&Otilde;ES DO USU&Aacute;RIO</strong><br />\n3.1 Efetuado com sucesso o CADASTRO do USU&Aacute;RIO, este se obriga a n&atilde;o divulgar a terceiros login e senha de acesso, nem permitir o uso de tais informa&ccedil;&otilde;es por terceiros, responsabilizando-se pelas consequ&ecirc;ncias do uso de login e senha de sua titularidade.</p>\n\n<p>3.2 &Eacute; obriga&ccedil;&atilde;o do USU&Aacute;RIO fornecer informa&ccedil;&otilde;es cadastrais totalmente ver&iacute;dicas e exatas, responsabilizando-se exclusiva e integralmente (em todas as searas jur&iacute;dicas) por todo o conte&uacute;do por si informado no item CADASTRO, mantendo atualizado e confirmado o endere&ccedil;o para entrega dos produtos encomendados.</p>\n\n<p>3.3 O USU&Aacute;RIO se obriga, tamb&eacute;m, a pagar integralmente o pre&ccedil;o dos produtos por si solicitados ou encomendados ao RESTAURANTE e efetivamente a si entregues, seja pela modalidade on-line, seja por qualquer outra forma, diretamente ao portador dos produtos encomendados por meio deste site (dinheiro, cheque, tickets, etc.).</p>\n\n<p>3.4 O USU&Aacute;RIO que seja menor de 18 anos de idade est&aacute; ciente de que n&atilde;o poder&aacute; encomendar e adquirir, em qualquer hip&oacute;tese, produtos alco&oacute;licos, responsabilizando-se pela correta informa&ccedil;&atilde;o de sua idade no item CADASTRO.</p>\n\n<p>3.5 O USU&Aacute;RIO concorda com o uso das informa&ccedil;&otilde;es de avalia&ccedil;&otilde;es e feedbacks do servi&ccedil;os dos RESTAURANTES e do iGO, conforme descrito nos TERMOS DE PRIVACIDADE do iGO.</p>\n\n<p><strong>4. OBRIGA&Ccedil;&Otilde;ES DO igo.delivery</strong><br />\n4.1 Disponibilizar no site igo.delivery espa&ccedil;o virtual que permita ao USU&Aacute;RIO devidamente cadastrado efetivar pedidos de compra de g&ecirc;neros aliment&iacute;cios anunciados e comercializados pelos RESTAURANTES e, tamb&eacute;m, disponibilizar ao USU&Aacute;RIO meios de pagamento do pre&ccedil;o dos produtos on-line.</p>\n\n<p>4.2 Proteger, por meio de armazenamento em servidores ou quaisquer outros meios magn&eacute;ticos de alta seguran&ccedil;a, a confidencialidade de todas as informa&ccedil;&otilde;es e cadastros relativos aos USU&Aacute;RIOS, assim como valores atinentes &agrave;s opera&ccedil;&otilde;es financeiras advindas da operacionaliza&ccedil;&atilde;o dos servi&ccedil;os previstos no presente TERMO. Contudo, n&atilde;o responder&aacute; pela repara&ccedil;&atilde;o de preju&iacute;zos que possam ser derivados de apreens&atilde;o e coopta&ccedil;&atilde;o de dados por parte de terceiros que, rompendo os sistemas de seguran&ccedil;a, consigam acessar essas informa&ccedil;&otilde;es.</p>\n\n<p><strong>5. MODIFICA&Ccedil;&Otilde;ES DESTE TERMO</strong><br />\n5.1 O presente TERMO DE USO poder&aacute;, a qualquer tempo, ter seu conte&uacute;do, ou parte dele, modificados para adequa&ccedil;&otilde;es e inser&ccedil;&otilde;es, tudo com vistas ao aprimoramento dos servi&ccedil;os disponibilizados.</p>\n\n<p>5.2 As novas condi&ccedil;&otilde;es entrar&atilde;o em vig&ecirc;ncia assim que sua veiculada no site, sendo poss&iacute;vel ao USU&Aacute;RIO manifestar oposi&ccedil;&atilde;o a quaisquer dos termos modificados, desde que o fa&ccedil;a por escrito, atrav&eacute;s do site igo.delivery, o que gerar&aacute; o cancelamento de seu CADASTRO.</p>\n\n<p><strong>6. CANAL DE COMUNICA&Ccedil;&Atilde;O</strong><br />\n6.1 Para estabelecer contato entre igo.delivery e o USU&Aacute;RIO fica disponibilizado o endere&ccedil;o eletr&ocirc;nico deste link, sendo certo que o USU&Aacute;RIO se obriga, igualmente, a manter em seu cadastro endere&ccedil;o eletr&ocirc;nico atual por interm&eacute;dio do qual se far&atilde;o as comunica&ccedil;&otilde;es a ele dirigidas pelo igo.delivery, desde logo emprestando-se validade jur&iacute;dica e efetividade a esse meio eletr&ocirc;nico de troca de informa&ccedil;&otilde;es rec&iacute;procas.</p>\n\n<p><strong>7. ACEITA&Ccedil;&Atilde;O DO TERMO DE USO</strong><br />\n7.1 O USU&Aacute;RIO declara ter lido, entendido e que aceita todas as regras, condi&ccedil;&otilde;es e obriga&ccedil;&otilde;es estabelecidas no presente TERMO.</p>\n\n<p><strong>8. FORO DE ELEI&Ccedil;&Atilde;O</strong><br />\n8.1 As partes elegem como competente para dirimir eventuais controv&eacute;rsias que venham a surgir da interpreta&ccedil;&atilde;o e do cumprimento do presente TERMO o foro da Comarca do Paran&aacute; - PR</p>\n', '{\"mp\":0,\"pix\":0,\"pagseguro\":0}', '5507156311446112', 'APP_USR-5507156311446112-110117-f1505ad64d81ea204fede7f8e3f9e3ae-300305741', '', 4.00, '', '', '{\"apiKey\":\"AIzaSyD-ve0e3V9HuUJOZzkbk6TogZnsFuFcpdk\",\"authDomain\":\"igo-delivery-550b2.firebaseapp.com\",\"databaseURL\":\"https:\\/\\/igo-delivery-550b2-default-rtdb.firebaseio.com\",\"projectId\":\"igo-delivery-550b2\",\"storageBucket\":\"igo-delivery-550b2.appspot.com\",\"messagingSenderId\":\"134667659539\",\"appId\":\"1:134667659539:web:1c64dc3218c9c76998d2e6\",\"measurementId\":\"G-DFDH44EH38\"}', '', '', '', 1, 'AIzaSyCxGtlnv5KhFtSmTyJSDFBx3caRM4Y-xsU', 20, 1, '', 0, '', 0, '', 'Aquecendo nossos equipamentos.&;A vida é muito mais gostosa com um hambúrger completo cheio de queijo.&;Não deixe para amanhã o que você poder comer hoje!&;Dinheiro bem gasto, é dinheiro gasto com comida.&;Dinheiro não compra felicidade, mas compra comida que é quase a mesma coisa.', '', '', 0.00, '', '', 0, 0, '{\"company\":\"1\",\"client\":\"1\",\"deliveryman\":\"0\"}', '', '{\"switch_order\":\"0\",\"end_point_order\":\"\",\"switch_update_order\":0,\"end_point_update_order\":\"\"}', 0, 0.00, '', '', '{\"show_company_near\":\"1\",\"show_company_high\":\"1\",\"show_company_partner_new\":\"1\",\"show_segments\":\"1\",\"show_plans\":\"1\",\"img_loading_company_switch\":\"0\"}', '', '', 0, 0, 'Sistema de Delivery com tudo que você precisava para potencializar suas vendas na internet. Cresça seu estabelecimento com facilidade.', 1, '', 0, '', '', 0, '', '', 0.5, 0, 0, 0.00, 0, '', 0, '', '', 0, '', 0, '', '', '', '', 0.00, 0, 0.00, '', '', 0.00, 'default', 'default', 'pt_BR', 0, '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsaWNlbnNlX2RvbWFpbiI6ImxpY2Vuc2UuYXJjbi5jb20uYnIiLCJkb21haW4iOiJhcmNuLmNvbS5iciIsImlhdCI6MTc1ODM5ODY5MiwiZXhwIjoxNzU4NTcxNDkyfQ.CFpi5MOCe8nTp2V_lYH6OjxUyvH4wAV2XNNkeCWVe8g', 0, '', '', '', '', '', 0);

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

--
-- Table structure for table `whatsapp_messages`
--

CREATE TABLE `whatsapp_messages` (
  `id` int(11) NOT NULL,
  `instance_id` varchar(50) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `message` text DEFAULT NULL,
  `from_me` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `company_id` int(11) DEFAULT NULL,
  `message_id` varchar(100) DEFAULT NULL,
  `is_notification` tinyint(1) DEFAULT 0,
  `greeting_sent` tinyint(1) DEFAULT 0,
  `last_greeting_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
