-- CleanMate (Laravel + MySQL) database: every table, empty.
-- Import in cPanel → phpMyAdmin → your database → Import. See DEPLOY_CPANEL.md.
-- Made from schema 1.3.34 (2026-11-19).
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE IF NOT EXISTS `account_links` (
  `business_id` char(36) NOT NULL,
  `token` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`token`),
  UNIQUE KEY `ux_0_business_id_customer_id` (`business_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `account_pay` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `session` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `accounts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `grp` mediumtext DEFAULT NULL,
  `key` varchar(191) DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `activity_log` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `who` varchar(191) DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `path` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `admin_reminders` (
  `id` varchar(191) NOT NULL,
  `title` text NOT NULL,
  `notes` text DEFAULT NULL,
  `at` bigint(20) NOT NULL,
  `before_min` int(11) NOT NULL DEFAULT 0,
  `channels` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `whatsapp` varchar(191) DEFAULT NULL,
  `wa_account_id` varchar(191) DEFAULT NULL,
  `repeat` varchar(16) NOT NULL DEFAULT 'none',
  `status` varchar(16) NOT NULL DEFAULT 'pending',
  `sent_at` bigint(20) DEFAULT NULL,
  `send_log` text DEFAULT NULL,
  `popup_until` bigint(20) DEFAULT NULL,
  `done` int(11) NOT NULL DEFAULT 0,
  `created_by` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `tz_offset` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `ix_0_at` (`at`),
  KEY `ix_1_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `aggregator_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `business_id` char(36) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `event` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `api_keys` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `label` varchar(191) DEFAULT NULL,
  `hash` varchar(191) DEFAULT NULL,
  `tail` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `last_used` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_hash` (`hash`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `approvals` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(32) DEFAULT NULL,
  `status` varchar(32) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `summary` mediumtext DEFAULT NULL,
  `payload` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `employee_name` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `decided_by` varchar(191) DEFAULT NULL,
  `decided_name` mediumtext DEFAULT NULL,
  `decided_at` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `result_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_status_at` (`business_id`,`status`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `asset_events` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `asset_id` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `by` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_asset_id` (`business_id`,`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `attendance` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `clock_in` bigint(20) DEFAULT NULL,
  `clock_out` bigint(20) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `selfie` mediumtext DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `approval` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_employee_id_clock_in` (`business_id`,`employee_id`,`clock_in`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `budgets` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `account` varchar(191) DEFAULT NULL,
  `month` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `business_addons` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `key` varchar(64) NOT NULL,
  `qty` bigint(20) DEFAULT 1,
  `starts_at` bigint(20) DEFAULT NULL,
  `expires_at` bigint(20) DEFAULT NULL,
  `price` bigint(20) DEFAULT 0,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `businesses` (
  `id` char(36) NOT NULL,
  `name` varchar(191) NOT NULL,
  `owner_email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'pending',
  `package_id` varchar(191) DEFAULT NULL,
  `valid_until` bigint(20) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `activated_at` bigint(20) DEFAULT NULL,
  `parent_id` char(36) DEFAULT NULL,
  `referral_code` varchar(191) DEFAULT NULL,
  `referred_by` char(36) DEFAULT NULL,
  `modules_off` mediumtext DEFAULT NULL,
  `modules_extra` mediumtext DEFAULT NULL,
  `storage_mb` bigint(20) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `demo_password` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_parent_id` (`parent_id`),
  KEY `ix_1_created_at` (`created_at`),
  KEY `ix_2_referral_code` (`referral_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE IF NOT EXISTS `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE IF NOT EXISTS `calls` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `handled_by` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `camera_events` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `camera_id` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `image` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `terminal_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `cameras` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `brand` mediumtext DEFAULT NULL,
  `host` mediumtext DEFAULT NULL,
  `http_port` bigint(20) DEFAULT NULL,
  `rtsp_port` bigint(20) DEFAULT NULL,
  `channel` bigint(20) DEFAULT NULL,
  `username` mediumtext DEFAULT NULL,
  `password` mediumtext DEFAULT NULL,
  `snapshot_url` mediumtext DEFAULT NULL,
  `rtsp_url` mediumtext DEFAULT NULL,
  `terminal_id` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `campaigns` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `channel` mediumtext DEFAULT NULL,
  `segment` mediumtext DEFAULT NULL,
  `customer_ids` mediumtext DEFAULT NULL,
  `template` mediumtext DEFAULT NULL,
  `subject` mediumtext DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `image` mediumtext DEFAULT NULL,
  `offer_code` mediumtext DEFAULT NULL,
  `link` mediumtext DEFAULT NULL,
  `wa_template` mediumtext DEFAULT NULL,
  `wa_language` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `send_at` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `recipients` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `card_links` (
  `code` varchar(191) NOT NULL,
  `business_id` char(36) NOT NULL,
  `customer_id` varchar(191) NOT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`code`),
  KEY `ix_0_business_id_customer_id` (`business_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_alerts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `seen` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_bot_log` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `dir` varchar(191) DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_bot_sessions` (
  `business_id` char(36) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `lang` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `data` mediumtext DEFAULT NULL,
  `count` bigint(20) DEFAULT NULL,
  `window_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_costs` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `chemicals` bigint(20) DEFAULT NULL,
  `packaging` bigint(20) DEFAULT NULL,
  `utilities` bigint(20) DEFAULT NULL,
  `labour_min` double DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_handoffs` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `reply` mediumtext DEFAULT NULL,
  `replied_at` bigint(20) DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_messages` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `step` bigint(20) DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `error` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `came_back_at` bigint(20) DEFAULT NULL,
  `coupon` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_kind_at` (`business_id`,`kind`,`at`),
  KEY `ix_1_business_id_receipt_id` (`business_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_ratings` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` varchar(191) DEFAULT NULL,
  `staff_id` varchar(191) DEFAULT NULL,
  `staff_name` mediumtext DEFAULT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `driver_name` mediumtext DEFAULT NULL,
  `services` mediumtext DEFAULT NULL,
  `rating` bigint(20) DEFAULT NULL,
  `comment` mediumtext DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `rated_at` bigint(20) DEFAULT NULL,
  `alerted` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_receipt_id` (`business_id`,`receipt_id`),
  KEY `ix_1_business_id_rated_at` (`business_id`,`rated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `care_storage` (
  `business_id` char(36) NOT NULL,
  `receipt_id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `days` bigint(20) DEFAULT NULL,
  `fee` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `sale_id` varchar(191) DEFAULT NULL,
  `dispose_status` varchar(191) DEFAULT NULL,
  `dispose_reason` mediumtext DEFAULT NULL,
  `dispose_by` mediumtext DEFAULT NULL,
  `dispose_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `cash_moves` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `shift_id` varchar(191) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `categories` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `color` bigint(20) DEFAULT NULL,
  `name_ar` mediumtext DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `featured` bigint(20) DEFAULT NULL,
  `color2` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `change_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `business_id` char(36) NOT NULL,
  `at` bigint(20) NOT NULL,
  `actor_type` varchar(191) DEFAULT NULL,
  `actor_id` varchar(191) DEFAULT NULL,
  `actor_name` mediumtext DEFAULT NULL,
  `actor_role` varchar(191) DEFAULT NULL,
  `action` varchar(191) DEFAULT NULL,
  `table_name` varchar(191) DEFAULT NULL,
  `record_id` varchar(191) DEFAULT NULL,
  `label` mediumtext DEFAULT NULL,
  `old_values` mediumtext DEFAULT NULL,
  `new_values` mediumtext DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `device` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`),
  KEY `ix_1_business_id_table_name_record_id` (`business_id`,`table_name`,`record_id`),
  KEY `ix_2_business_id_actor_id_at` (`business_id`,`actor_id`,`at`),
  KEY `ix_3_at` (`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `chat_messages` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `thread` mediumtext DEFAULT NULL,
  `sender_type` mediumtext DEFAULT NULL,
  `sender_id` varchar(191) DEFAULT NULL,
  `sender_name` mediumtext DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `seen_staff` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `cheques` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `contact_type` mediumtext DEFAULT NULL,
  `contact_id` varchar(191) DEFAULT NULL,
  `contact_name` mediumtext DEFAULT NULL,
  `cheque_number` mediumtext DEFAULT NULL,
  `bank_name` mediumtext DEFAULT NULL,
  `branch_name` mediumtext DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `cheque_date` bigint(20) DEFAULT NULL,
  `due_date` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `cleared_at` bigint(20) DEFAULT NULL,
  `cleared_notes` mediumtext DEFAULT NULL,
  `bounced_at` bigint(20) DEFAULT NULL,
  `bounced_reason` mediumtext DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `receipt_number` mediumtext DEFAULT NULL,
  `alert_step` bigint(20) DEFAULT NULL,
  `alert_date` bigint(20) DEFAULT NULL,
  `cleared_told` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `commission_agents` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `phone` mediumtext DEFAULT NULL,
  `email` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `percent` double DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `company_documents` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `category` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `employee_name` mediumtext DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `doc_type` mediumtext DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `file_path` mediumtext DEFAULT NULL,
  `start_date` bigint(20) DEFAULT NULL,
  `expiry_date` bigint(20) DEFAULT NULL,
  `remind_days` bigint(20) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `reminded_step` bigint(20) DEFAULT NULL,
  `reminded_expiry` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_activities` (
  `id` varchar(191) NOT NULL,
  `lead_id` varchar(191) DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `text` mediumtext DEFAULT NULL,
  `by` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_lead_id_at` (`lead_id`,`at`),
  KEY `ix_1_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_catalog` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `kind` varchar(16) DEFAULT 'item',
  `price` bigint(20) DEFAULT 0,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_events` (
  `id` varchar(191) NOT NULL,
  `lead_id` varchar(191) DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `title` mediumtext NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `start_at` bigint(20) DEFAULT NULL,
  `end_at` bigint(20) DEFAULT NULL,
  `link` mediumtext DEFAULT NULL,
  `location` mediumtext DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `done` bigint(20) DEFAULT 0,
  `created_by` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_start_at` (`start_at`),
  KEY `ix_1_lead_id` (`lead_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_leads` (
  `id` varchar(191) NOT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `site_lead_id` bigint(20) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `business` mediumtext DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `outlets` varchar(191) DEFAULT NULL,
  `outlet_type` varchar(191) DEFAULT NULL,
  `stage` varchar(32) NOT NULL DEFAULT 'new',
  `value` bigint(20) DEFAULT 0,
  `owner` varchar(191) DEFAULT NULL,
  `next_at` bigint(20) DEFAULT NULL,
  `next_note` mediumtext DEFAULT NULL,
  `lost_reason` mediumtext DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_site_lead_id` (`site_lead_id`),
  KEY `ix_0_next_at` (`next_at`),
  KEY `ix_1_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_message_log` (
  `id` varchar(191) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  `channel` varchar(191) DEFAULT NULL,
  `to_addr` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `template` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `error` mediumtext DEFAULT NULL,
  `lead_id` varchar(191) DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `auto_key` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_auto_key` (`auto_key`),
  KEY `ix_1_at` (`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_quotes` (
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `token` varchar(191) DEFAULT NULL,
  `lead_id` varchar(191) DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `customer` mediumtext DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `template` varchar(32) DEFAULT 'classic',
  `lines` mediumtext DEFAULT NULL,
  `discount` bigint(20) DEFAULT 0,
  `tax_rate` double DEFAULT 5,
  `notes` mediumtext DEFAULT NULL,
  `terms` mediumtext DEFAULT NULL,
  `valid_until` bigint(20) DEFAULT NULL,
  `status` varchar(16) DEFAULT 'draft',
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) DEFAULT NULL,
  `accepted_at` bigint(20) DEFAULT NULL,
  `invoice_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_token` (`token`),
  KEY `ix_0_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_scoring_rules` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `field` mediumtext DEFAULT NULL,
  `operator` mediumtext DEFAULT NULL,
  `value` mediumtext DEFAULT NULL,
  `score` bigint(20) DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `crm_templates` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `channel` varchar(16) NOT NULL,
  `subject` mediumtext DEFAULT NULL,
  `body` mediumtext NOT NULL,
  `auto` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `customer_documents` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `doc_type` mediumtext DEFAULT NULL,
  `file_path` mediumtext DEFAULT NULL,
  `start_date` bigint(20) DEFAULT NULL,
  `expiry_date` bigint(20) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `customer_otps` (
  `business_id` char(36) NOT NULL,
  `k` varchar(191) NOT NULL,
  `hash` varchar(191) DEFAULT NULL,
  `expires` bigint(20) DEFAULT NULL,
  `tries` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `customer_push` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `endpoint` mediumtext DEFAULT NULL,
  `phone` mediumtext DEFAULT NULL,
  `last_text` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `customer_sessions` (
  `business_id` char(36) NOT NULL,
  `token_hash` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `expires` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`token_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `customers` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `phone` mediumtext DEFAULT NULL,
  `email` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `address` mediumtext DEFAULT NULL,
  `birthday` mediumtext DEFAULT NULL,
  `anniversary` mediumtext DEFAULT NULL,
  `area` mediumtext DEFAULT NULL,
  `tags` mediumtext DEFAULT NULL,
  `opt_out` bigint(20) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `tier` mediumtext DEFAULT NULL,
  `referred_by` mediumtext DEFAULT NULL,
  `vat_number` mediumtext DEFAULT NULL,
  `customer_type` mediumtext DEFAULT NULL,
  `contact_person` mediumtext DEFAULT NULL,
  `credit_limit` bigint(20) DEFAULT NULL,
  `credit_days` bigint(20) DEFAULT NULL,
  `billing` mediumtext DEFAULT NULL,
  `price_list_id` varchar(191) DEFAULT NULL,
  `customer_group` mediumtext DEFAULT NULL,
  `opening_balance` bigint(20) DEFAULT NULL,
  `opening_balance_date` bigint(20) DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `visibility` mediumtext DEFAULT NULL,
  `created_by` mediumtext DEFAULT NULL,
  `visible_to` mediumtext DEFAULT NULL,
  `custom1` mediumtext DEFAULT NULL,
  `custom2` mediumtext DEFAULT NULL,
  `custom3` mediumtext DEFAULT NULL,
  `custom4` mediumtext DEFAULT NULL,
  `prefs` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `day_closes` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `day` varchar(191) DEFAULT NULL,
  `day_no` bigint(20) DEFAULT NULL,
  `closed_at` bigint(20) DEFAULT NULL,
  `closed_by` mediumtext DEFAULT NULL,
  `counted_cash` bigint(20) DEFAULT NULL,
  `expected_cash` bigint(20) DEFAULT NULL,
  `sales` bigint(20) DEFAULT NULL,
  `denominations` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `shift_ids` mediumtext DEFAULT NULL,
  `device_name` mediumtext DEFAULT NULL,
  `device_ip` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `delivery_jobs` (
  `business_id` char(36) NOT NULL,
  `key` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `job_id` varchar(191) DEFAULT NULL,
  `slot_day` varchar(10) DEFAULT NULL,
  `slot` varchar(16) DEFAULT NULL,
  `area` varchar(191) DEFAULT NULL,
  `seq` bigint(20) DEFAULT NULL,
  `otp` varchar(8) DEFAULT NULL,
  `started_at` bigint(20) DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  `pod_name` mediumtext DEFAULT NULL,
  `pod_signature` mediumtext DEFAULT NULL,
  `failed_reason` mediumtext DEFAULT NULL,
  `failed_at` bigint(20) DEFAULT NULL,
  `attempts` bigint(20) DEFAULT NULL,
  `late_alerted` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`key`),
  KEY `ix_0_business_id_slot_day` (`business_id`,`slot_day`),
  KEY `ix_1_business_id_failed_at` (`business_id`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `delivery_notes` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `address` mediumtext DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `delivered_at` bigint(20) DEFAULT NULL,
  `received_by` mediumtext DEFAULT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `devices` (
  `business_id` char(36) NOT NULL,
  `device_id` varchar(191) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `first_seen` bigint(20) DEFAULT NULL,
  `last_seen` bigint(20) DEFAULT NULL,
  `blocked` bigint(20) DEFAULT 0,
  PRIMARY KEY (`business_id`,`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `discounts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `value` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `displays` (
  `code` varchar(191) NOT NULL,
  `business_id` char(36) NOT NULL,
  `state` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `driver_locations` (
  `business_id` char(36) NOT NULL,
  `driver_id` varchar(191) NOT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `accuracy` double DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `heading` double DEFAULT NULL,
  `speed` double DEFAULT NULL,
  PRIMARY KEY (`business_id`,`driver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `driver_settlements` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `driver_name` mediumtext DEFAULT NULL,
  `expected` bigint(20) DEFAULT NULL,
  `counted` bigint(20) DEFAULT NULL,
  `items` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `driver_trail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `business_id` char(36) NOT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `job_key` varchar(191) DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `accuracy` double DEFAULT NULL,
  `heading` double DEFAULT NULL,
  `speed` double DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_driver_id_at` (`business_id`,`driver_id`,`at`),
  KEY `ix_1_business_id_job_key` (`business_id`,`job_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `email_codes` (
  `email` varchar(191) NOT NULL,
  `code_hash` varchar(191) DEFAULT NULL,
  `expires` bigint(20) DEFAULT NULL,
  `tries` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `employees` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `role` varchar(191) DEFAULT NULL,
  `pin_hash` mediumtext DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `phone` mediumtext DEFAULT NULL,
  `branches` mediumtext DEFAULT NULL,
  `commission_pct` double DEFAULT NULL,
  `extra_roles` mediumtext DEFAULT NULL,
  `perm_overrides` mediumtext DEFAULT NULL,
  `email` mediumtext DEFAULT NULL,
  `photo` mediumtext DEFAULT NULL,
  `branch_roles` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `expenses` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `date` bigint(20) DEFAULT NULL,
  `category` mediumtext DEFAULT NULL,
  `subcategory` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `supplier` mediumtext DEFAULT NULL,
  `supplier_trn` mediumtext DEFAULT NULL,
  `reference` mediumtext DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `tax_category` varchar(191) DEFAULT NULL,
  `payment_method` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `attachment` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `approved_by` mediumtext DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `payments` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_date` (`business_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `fixed_assets` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `category` mediumtext DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `salvage` bigint(20) DEFAULT NULL,
  `life_months` bigint(20) DEFAULT NULL,
  `paid_from` mediumtext DEFAULT NULL,
  `disposed_at` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `follow_ups` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `lead_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `title` mediumtext DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `starts_at` bigint(20) DEFAULT NULL,
  `assigned_to` mediumtext DEFAULT NULL,
  `assigned_name` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `repeat` mediumtext DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  `outcome` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `gateway_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `business_id` char(36) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `event` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `hr_alerts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `document` varchar(191) DEFAULT NULL,
  `expiry` bigint(20) DEFAULT NULL,
  `step` bigint(20) DEFAULT NULL,
  `days_left` bigint(20) DEFAULT NULL,
  `sent_to` varchar(191) DEFAULT NULL,
  `error` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `hr_kudos` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `title` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `given_by` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `hr_leaves` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `date_from` varchar(191) DEFAULT NULL,
  `date_to` varchar(191) DEFAULT NULL,
  `days` bigint(20) DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `decided_by` varchar(191) DEFAULT NULL,
  `decided_at` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `hr_overtime` (
  `business_id` char(36) NOT NULL,
  `employee_id` varchar(191) NOT NULL,
  `day` varchar(10) NOT NULL,
  `hours` double DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `by` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`employee_id`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `hr_profiles` (
  `business_id` char(36) NOT NULL,
  `employee_id` varchar(191) NOT NULL,
  `data` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `hr_reviews` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `period` varchar(191) DEFAULT NULL,
  `scores` mediumtext DEFAULT NULL,
  `overall` double DEFAULT NULL,
  `strengths` mediumtext DEFAULT NULL,
  `improve` mediumtext DEFAULT NULL,
  `goals` mediumtext DEFAULT NULL,
  `reviewer` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `items` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `category_id` varchar(191) DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `sku` mediumtext DEFAULT NULL,
  `barcode` varchar(191) DEFAULT NULL,
  `track_stock` bigint(20) DEFAULT NULL,
  `low_stock` double DEFAULT NULL,
  `color` bigint(20) DEFAULT NULL,
  `image` mediumtext DEFAULT NULL,
  `variants` mediumtext DEFAULT NULL,
  `tax_category` varchar(191) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `name_ar` mediumtext DEFAULT NULL,
  `addons` mediumtext DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `featured` bigint(20) DEFAULT NULL,
  `combo` mediumtext DEFAULT NULL,
  `tax_rate` double DEFAULT NULL,
  `hsn` mediumtext DEFAULT NULL,
  `unit` varchar(191) DEFAULT NULL,
  `by_weight` bigint(20) DEFAULT NULL,
  `commission` mediumtext DEFAULT NULL,
  `parent_id` varchar(191) DEFAULT NULL,
  `attrs` mediumtext DEFAULT NULL,
  `matrix` mediumtext DEFAULT NULL,
  `barcodes` mediumtext DEFAULT NULL,
  `units` mediumtext DEFAULT NULL,
  `track_batch` bigint(20) DEFAULT NULL,
  `track_serial` bigint(20) DEFAULT NULL,
  `reorder_qty` double DEFAULT NULL,
  `supplier_id` varchar(191) DEFAULT NULL,
  `brand` mediumtext DEFAULT NULL,
  `warranty_months` bigint(20) DEFAULT NULL,
  `express_price` bigint(20) DEFAULT NULL,
  `custom1` mediumtext DEFAULT NULL,
  `custom2` mediumtext DEFAULT NULL,
  `custom3` mediumtext DEFAULT NULL,
  `custom4` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_parent_id` (`business_id`,`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `kiosk_collects` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` varchar(191) DEFAULT NULL,
  `receipt_ids` mediumtext DEFAULT NULL,
  `numbers` mediumtext DEFAULT NULL,
  `racks` mediumtext DEFAULT NULL,
  `due` bigint(20) DEFAULT NULL,
  `fee` bigint(20) DEFAULT NULL,
  `pay` varchar(191) DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `pay_session` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_status` (`business_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `kiosk_drops` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `token` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `bag` bigint(20) DEFAULT NULL,
  `bags` bigint(20) DEFAULT NULL,
  `pieces` bigint(20) DEFAULT NULL,
  `estimate` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `prefs_text` mediumtext DEFAULT NULL,
  `ready_at` bigint(20) DEFAULT NULL,
  `delivery` bigint(20) DEFAULT NULL,
  `slot_day` varchar(191) DEFAULT NULL,
  `slot` varchar(191) DEFAULT NULL,
  `address` mediumtext DEFAULT NULL,
  `payment` varchar(191) DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `pay_session` mediumtext DEFAULT NULL,
  `plan_id` varchar(191) DEFAULT NULL,
  `bin` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `receipt_number` varchar(191) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `counted_pieces` bigint(20) DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `counted_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_status_created_at` (`business_id`,`status`,`created_at`),
  KEY `ix_1_business_id_number` (`business_id`,`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `kiosk_otps` (
  `business_id` char(36) NOT NULL,
  `k` varchar(191) NOT NULL,
  `hash` varchar(191) DEFAULT NULL,
  `expires` bigint(20) DEFAULT NULL,
  `tries` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `kiosk_sessions` (
  `business_id` char(36) NOT NULL,
  `token_hash` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `drop_id` varchar(191) DEFAULT NULL,
  `photos` mediumtext DEFAULT NULL,
  `via` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `expires` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`token_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `laundry_bags` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` mediumtext DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `laundry_transfers` (
  `id` varchar(191) NOT NULL,
  `root_id` char(36) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `from_id` char(36) DEFAULT NULL,
  `to_id` char(36) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `orders` mediumtext DEFAULT NULL,
  `pieces` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `sent_by` varchar(191) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `received_by` varchar(191) DEFAULT NULL,
  `received_at` bigint(20) DEFAULT NULL,
  `receive_note` mediumtext DEFAULT NULL,
  `receiver_name` varchar(191) DEFAULT NULL,
  `receiver_phone` varchar(191) DEFAULT NULL,
  `approved_by` varchar(191) DEFAULT NULL,
  `approved_at` bigint(20) DEFAULT NULL,
  `completed_at` bigint(20) DEFAULT NULL,
  `log` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_root_id` (`root_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `leads` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `company` mediumtext DEFAULT NULL,
  `phone` mediumtext DEFAULT NULL,
  `email` mediumtext DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `stage` mediumtext DEFAULT NULL,
  `value` bigint(20) DEFAULT NULL,
  `owner_id` varchar(191) DEFAULT NULL,
  `owner_name` mediumtext DEFAULT NULL,
  `next_date` bigint(20) DEFAULT NULL,
  `next_action` mediumtext DEFAULT NULL,
  `rating` mediumtext DEFAULT NULL,
  `score` bigint(20) DEFAULT NULL,
  `tags` mediumtext DEFAULT NULL,
  `lost_reason` mediumtext DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `won_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `library` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `arabic` mediumtext DEFAULT NULL,
  `aliases` mediumtext DEFAULT NULL,
  `category` varchar(191) DEFAULT NULL,
  `path` varchar(191) NOT NULL,
  `source` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_codes` (
  `business_id` char(36) NOT NULL,
  `hash` varchar(191) NOT NULL,
  `site_id` varchar(191) DEFAULT NULL,
  `door_number` bigint(20) DEFAULT NULL,
  `role` varchar(191) DEFAULT NULL,
  `purpose` varchar(191) DEFAULT NULL,
  `drop_id` varchar(191) DEFAULT NULL,
  `who` mediumtext DEFAULT NULL,
  `expires` bigint(20) DEFAULT NULL,
  `used_at` bigint(20) DEFAULT NULL,
  `used_via` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`hash`),
  KEY `ix_0_business_id_drop_id` (`business_id`,`drop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_commands` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `site_id` varchar(191) DEFAULT NULL,
  `door_number` bigint(20) DEFAULT NULL,
  `cmd` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `who` mediumtext DEFAULT NULL,
  `via` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_site_id_status` (`business_id`,`site_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_doors` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `site_id` varchar(191) DEFAULT NULL,
  `number` bigint(20) DEFAULT NULL,
  `size` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `open` bigint(20) DEFAULT 0,
  `fault` mediumtext DEFAULT NULL,
  `renter_id` varchar(191) DEFAULT NULL,
  `share_pct` double DEFAULT NULL,
  `drop_id` varchar(191) DEFAULT NULL,
  `pending` varchar(191) DEFAULT NULL,
  `pending_drop` varchar(191) DEFAULT NULL,
  `pending_until` bigint(20) DEFAULT NULL,
  `opened_at` bigint(20) DEFAULT NULL,
  `open_alerted` bigint(20) DEFAULT 0,
  `updated_at` bigint(20) DEFAULT NULL,
  `deleted` bigint(20) DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_site_id_number` (`business_id`,`site_id`,`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_drops` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `site_id` varchar(191) DEFAULT NULL,
  `door_id` varchar(191) DEFAULT NULL,
  `door_number` bigint(20) DEFAULT NULL,
  `laundry_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` varchar(191) DEFAULT NULL,
  `bag` bigint(20) DEFAULT NULL,
  `size` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `pieces` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `payment` varchar(191) DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `pay_session` mediumtext DEFAULT NULL,
  `plan_id` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `receipt_number` varchar(191) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `tag` varchar(191) DEFAULT NULL,
  `return_door_id` varchar(191) DEFAULT NULL,
  `return_door_number` bigint(20) DEFAULT NULL,
  `reminded` mediumtext DEFAULT NULL,
  `fee` bigint(20) DEFAULT NULL,
  `fee_paid` bigint(20) DEFAULT NULL,
  `fee_session` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `opens` bigint(20) DEFAULT 0,
  `by_name` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `dropped_at` bigint(20) DEFAULT NULL,
  `collected_at` bigint(20) DEFAULT NULL,
  `ready_at` bigint(20) DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_site_id_status` (`business_id`,`site_id`,`status`),
  KEY `ix_1_business_id_laundry_id_status` (`business_id`,`laundry_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_events` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `site_id` varchar(191) DEFAULT NULL,
  `door_number` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `who` mediumtext DEFAULT NULL,
  `via` varchar(191) DEFAULT NULL,
  `drop_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_site_id_at` (`business_id`,`site_id`,`at`),
  KEY `ix_1_business_id_drop_id` (`business_id`,`drop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_index` (
  `site_id` varchar(32) NOT NULL,
  `business_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`site_id`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_nonces` (
  `business_id` char(36) NOT NULL,
  `site_id` varchar(32) NOT NULL,
  `nonce` varchar(80) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`site_id`,`nonce`),
  KEY `ix_0_at` (`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_rentals` (
  `door_id` varchar(191) NOT NULL,
  `owner_id` varchar(191) DEFAULT NULL,
  `site_id` varchar(191) DEFAULT NULL,
  `renter_id` varchar(191) DEFAULT NULL,
  `share_pct` double DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`door_id`),
  KEY `ix_0_renter_id` (`renter_id`),
  KEY `ix_1_site_id` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `locker_sites` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `address` mediumtext DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `hours` mediumtext DEFAULT NULL,
  `controller_id` varchar(191) DEFAULT NULL,
  `secret` varchar(191) DEFAULT NULL,
  `transport` varchar(191) DEFAULT NULL,
  `last_seen` bigint(20) DEFAULT NULL,
  `offline_alerted` bigint(20) DEFAULT 0,
  `firmware` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `deleted` bigint(20) DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `login_history` (
  `id` varchar(191) NOT NULL,
  `business_id` varchar(64) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `who` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `ok` bigint(20) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `device` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `mail_accounts` (
  `id` varchar(191) NOT NULL,
  `business_id` varchar(64) NOT NULL,
  `email` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `username` varchar(191) DEFAULT NULL,
  `password` text DEFAULT NULL,
  `imap_host` varchar(191) DEFAULT NULL,
  `imap_port` int(11) DEFAULT NULL,
  `imap_security` varchar(8) DEFAULT NULL,
  `smtp_host` varchar(191) DEFAULT NULL,
  `smtp_port` int(11) DEFAULT NULL,
  `smtp_security` varchar(8) DEFAULT NULL,
  `signature` text DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `meta` (
  `business_id` char(36) NOT NULL,
  `key` varchar(191) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  PRIMARY KEY (`business_id`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE IF NOT EXISTS `mk_auto` (
  `business_id` char(36) NOT NULL,
  `order_id` varchar(191) NOT NULL,
  `event` varchar(191) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`order_id`,`event`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `mk_links` (
  `token` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `message_id` varchar(191) DEFAULT NULL,
  `url` mediumtext DEFAULT NULL,
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `mk_messages` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `campaign_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `to_addr` varchar(191) DEFAULT NULL,
  `channel` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `wamid` varchar(191) DEFAULT NULL,
  `error` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `delivered_at` bigint(20) DEFAULT NULL,
  `read_at` bigint(20) DEFAULT NULL,
  `clicked_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_campaign_id` (`business_id`,`campaign_id`),
  KEY `ix_1_wamid` (`wamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `oauth_states` (
  `state` varchar(191) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `offline_licences` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `machine` varchar(191) NOT NULL,
  `customer` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `expires` varchar(191) DEFAULT NULL,
  `licence_key` varchar(191) NOT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) DEFAULT NULL,
  `revoked_at` bigint(20) DEFAULT NULL,
  `plan` bigint(20) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `old_balances` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `branch_id` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `amount` bigint(20) NOT NULL DEFAULT 0,
  `owed_at` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `status` varchar(16) NOT NULL DEFAULT 'open',
  `customer_id` varchar(191) DEFAULT NULL,
  `moved_at` bigint(20) DEFAULT NULL,
  `moved_by` varchar(191) DEFAULT NULL,
  `collected` bigint(20) NOT NULL DEFAULT 0,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  `deleted` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_deleted_status` (`business_id`,`deleted`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `om_einv` (
  `business_id` char(36) NOT NULL,
  `receipt_id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `asp_ref` varchar(191) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `tries` bigint(20) DEFAULT 0,
  PRIMARY KEY (`business_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `online_orders` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `order_type` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` mediumtext DEFAULT NULL,
  `customer_address` mediumtext DEFAULT NULL,
  `payment` mediumtext DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `stripe_session` mediumtext DEFAULT NULL,
  `customer_lat` double DEFAULT NULL,
  `customer_lng` double DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `ticket_id` varchar(191) DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `accepted_at` bigint(20) DEFAULT NULL,
  `ready_at` bigint(20) DEFAULT NULL,
  `completed_at` bigint(20) DEFAULT NULL,
  `rejected_at` bigint(20) DEFAULT NULL,
  `verify_code` mediumtext DEFAULT NULL,
  `verified_at` bigint(20) DEFAULT NULL,
  `verified_by` mediumtext DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_email` mediumtext DEFAULT NULL,
  `rating` bigint(20) DEFAULT NULL,
  `review` mediumtext DEFAULT NULL,
  `reviewed_at` bigint(20) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `external_id` varchar(191) DEFAULT NULL,
  `pickup_at` bigint(20) DEFAULT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `assigned_at` bigint(20) DEFAULT NULL,
  `picked_at` bigint(20) DEFAULT NULL,
  `coming_at` bigint(20) DEFAULT NULL,
  `dropped_at` bigint(20) DEFAULT NULL,
  `dropped_to` mediumtext DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_created_at` (`business_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `order_links` (
  `code` varchar(191) NOT NULL,
  `business_id` char(36) NOT NULL,
  PRIMARY KEY (`code`),
  UNIQUE KEY `ux_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `packages` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `price` bigint(20) DEFAULT 0,
  `duration_days` bigint(20) DEFAULT 365,
  `max_devices` bigint(20) DEFAULT 3,
  `features` mediumtext DEFAULT NULL,
  `active` bigint(20) DEFAULT 1,
  `created_at` bigint(20) DEFAULT NULL,
  `max_branches` bigint(20) DEFAULT 1,
  `product` varchar(191) DEFAULT 'CleanMate',
  `single_module` varchar(191) DEFAULT NULL,
  `custom_for` char(36) DEFAULT NULL,
  `features_off` mediumtext DEFAULT NULL,
  `storage_mb` bigint(20) DEFAULT NULL,
  `reseller_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `payment_audit` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `ref_id` varchar(191) DEFAULT NULL,
  `payment_id` varchar(191) DEFAULT NULL,
  `action` mediumtext DEFAULT NULL,
  `before` mediumtext DEFAULT NULL,
  `after` mediumtext DEFAULT NULL,
  `amount_before` bigint(20) DEFAULT NULL,
  `amount_after` bigint(20) DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `payments` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `payment_type` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `shift_id` varchar(191) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `cheque_no` mediumtext DEFAULT NULL,
  `cheque_bank` mediumtext DEFAULT NULL,
  `cheque_date` mediumtext DEFAULT NULL,
  `collection_id` varchar(191) DEFAULT NULL,
  `van_id` varchar(191) DEFAULT NULL,
  `visit_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_receipt_id` (`business_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `payroll_runs` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `month` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `approved_at` bigint(20) DEFAULT NULL,
  `paid_at` bigint(20) DEFAULT NULL,
  `voucher_id` varchar(191) DEFAULT NULL,
  `paid_voucher_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `pc_links` (
  `machine` varchar(191) NOT NULL,
  `business_id` char(36) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `last_seen` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`machine`,`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `perm_changes` (
  `id` varchar(191) NOT NULL,
  `business_id` varchar(64) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `who` varchar(191) DEFAULT NULL,
  `target` varchar(191) DEFAULT NULL,
  `what` mediumtext DEFAULT NULL,
  `before` mediumtext DEFAULT NULL,
  `after` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `pin_codes` (
  `code` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`code`),
  UNIQUE KEY `ux_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `pin_devices` (
  `key` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`key`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `pin_fails` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_key_at` (`key`,`at`),
  KEY `ix_1_at` (`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `plan_subscriptions` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` mediumtext DEFAULT NULL,
  `plan_id` varchar(191) DEFAULT NULL,
  `plan_name` mediumtext DEFAULT NULL,
  `limit_type` mediumtext DEFAULT NULL,
  `limit_total` double DEFAULT NULL,
  `used` double DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `starts_at` bigint(20) DEFAULT NULL,
  `ends_at` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `services` mediumtext DEFAULT NULL,
  `rollover_qty` double DEFAULT NULL,
  `pickups_total` bigint(20) DEFAULT NULL,
  `pickups_used` bigint(20) DEFAULT NULL,
  `renewed_from` mediumtext DEFAULT NULL,
  `reminded_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `plan_usage` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `subscription_id` varchar(191) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `platform_alerts_sent` (
  `alert_key` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `ok` bigint(20) DEFAULT NULL,
  `error` mediumtext DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`alert_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `platform_invoices` (
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `customer` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `amount` bigint(20) NOT NULL,
  `status` varchar(16) NOT NULL DEFAULT 'unpaid',
  `due_at` bigint(20) DEFAULT NULL,
  `paid_at` bigint(20) DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `package_id` varchar(191) DEFAULT NULL,
  `extend_days` bigint(20) DEFAULT NULL,
  `period` bigint(20) DEFAULT NULL,
  `auto` bigint(20) DEFAULT 0,
  `created_at` bigint(20) DEFAULT NULL,
  `created_by` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_period` (`business_id`,`period`),
  KEY `ix_1_status_due_at` (`status`,`due_at`),
  KEY `ix_2_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `platform_settings` (
  `key` varchar(191) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `price_list_items` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `list_id` varchar(191) DEFAULT NULL,
  `item_id` varchar(191) DEFAULT NULL,
  `unit` varchar(191) DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `price_lists` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `markup_pct` double DEFAULT NULL,
  `groups` mediumtext DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `print_jobs` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `printed_at` bigint(20) DEFAULT NULL,
  `device` varchar(191) DEFAULT NULL,
  `by_device` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_created_at` (`business_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `proposals` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `lead_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `to_name` mediumtext DEFAULT NULL,
  `to_phone` mediumtext DEFAULT NULL,
  `to_email` mediumtext DEFAULT NULL,
  `subject` mediumtext DEFAULT NULL,
  `body` mediumtext DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `via` mediumtext DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `purchase_orders` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `supplier_id` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `expected_at` bigint(20) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `subtotal` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `purchases` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `supplier_id` varchar(191) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `subtotal` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `paid` bigint(20) DEFAULT NULL,
  `payment_type` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `po_id` varchar(191) DEFAULT NULL,
  `grn_no` mediumtext DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `quotations` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` mediumtext DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `valid_until` bigint(20) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `subtotal` bigint(20) DEFAULT NULL,
  `discount` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `terms` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `rate_hits` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key` varchar(191) NOT NULL,
  `at` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_key_at` (`key`,`at`),
  KEY `ix_1_at` (`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `receipt_lines` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `item_id` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `variant` varchar(191) DEFAULT NULL,
  `category_name` mediumtext DEFAULT NULL,
  `discount` bigint(20) DEFAULT NULL,
  `net` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `tax_category` varchar(191) DEFAULT NULL,
  `tax_rate` double DEFAULT NULL,
  `hsn` mediumtext DEFAULT NULL,
  `commission` bigint(20) DEFAULT NULL,
  `unit` varchar(191) DEFAULT NULL,
  `factor` double DEFAULT NULL,
  `serials` mediumtext DEFAULT NULL,
  `batch` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `pack` mediumtext DEFAULT NULL,
  `photos` bigint(20) DEFAULT NULL,
  `staff_id` varchar(191) DEFAULT NULL,
  `staff_name` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_receipt_id` (`business_id`,`receipt_id`),
  KEY `ix_2_business_id_item_id` (`business_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `receipts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `discount_id` varchar(191) DEFAULT NULL,
  `terminal_id` varchar(191) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `refund_of` mediumtext DEFAULT NULL,
  `zatca_uuid` mediumtext DEFAULT NULL,
  `zatca_icv` bigint(20) DEFAULT NULL,
  `zatca_hash` mediumtext DEFAULT NULL,
  `zatca_qr` mediumtext DEFAULT NULL,
  `zatca_status` mediumtext DEFAULT NULL,
  `zatca_message` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `shift_id` varchar(191) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `subtotal` bigint(20) DEFAULT NULL,
  `discount` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `payment_type` varchar(191) DEFAULT NULL,
  `tendered` bigint(20) DEFAULT NULL,
  `points_earned` bigint(20) DEFAULT NULL,
  `points_redeemed` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `net` bigint(20) DEFAULT NULL,
  `order_type` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` mediumtext DEFAULT NULL,
  `ticket_id` varchar(191) DEFAULT NULL,
  `customer_address` mediumtext DEFAULT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `delivery_status` mediumtext DEFAULT NULL,
  `delivered_at` bigint(20) DEFAULT NULL,
  `collected_at` bigint(20) DEFAULT NULL,
  `delivery_issue` mediumtext DEFAULT NULL,
  `delivery_partner` mediumtext DEFAULT NULL,
  `delivery_photo` mediumtext DEFAULT NULL,
  `handed_at` bigint(20) DEFAULT NULL,
  `handed_by` mediumtext DEFAULT NULL,
  `refund_reason` mediumtext DEFAULT NULL,
  `voided_at` bigint(20) DEFAULT NULL,
  `void_reason` mediumtext DEFAULT NULL,
  `voided_by` mediumtext DEFAULT NULL,
  `partner_commission` bigint(20) DEFAULT NULL,
  `tip` bigint(20) DEFAULT NULL,
  `server_id` varchar(191) DEFAULT NULL,
  `promotion` mediumtext DEFAULT NULL,
  `customer_tax_id` varchar(191) DEFAULT NULL,
  `coupon_code` mediumtext DEFAULT NULL,
  `exchange_of` mediumtext DEFAULT NULL,
  `quotation_id` varchar(191) DEFAULT NULL,
  `due_at` bigint(20) DEFAULT NULL,
  `customer_ref` mediumtext DEFAULT NULL,
  `price_list` mediumtext DEFAULT NULL,
  `van_id` varchar(191) DEFAULT NULL,
  `visit_id` varchar(191) DEFAULT NULL,
  `stage` mediumtext DEFAULT NULL,
  `stage_at` bigint(20) DEFAULT NULL,
  `ready_at` bigint(20) DEFAULT NULL,
  `rack` mediumtext DEFAULT NULL,
  `sales_note` mediumtext DEFAULT NULL,
  `reminded_at` bigint(20) DEFAULT NULL,
  `reminders` bigint(20) DEFAULT NULL,
  `salesman_id` varchar(191) DEFAULT NULL,
  `salesman_name` mediumtext DEFAULT NULL,
  `staff_note` mediumtext DEFAULT NULL,
  `pieces` bigint(20) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `plant_id` varchar(191) DEFAULT NULL,
  `express` bigint(20) DEFAULT NULL,
  `pickup_id` varchar(191) DEFAULT NULL,
  `self_collect` bigint(20) DEFAULT NULL,
  `notified_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_created_at` (`business_id`,`created_at`),
  KEY `ix_2_business_id_customer_id` (`business_id`,`customer_id`),
  KEY `ix_3_business_id_shift_id` (`business_id`,`shift_id`),
  KEY `ix_4_business_id_van_id_created_at` (`business_id`,`van_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `recon` (
  `business_id` char(36) NOT NULL,
  `entry_id` varchar(191) NOT NULL,
  `account` varchar(191) NOT NULL,
  `cleared_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`entry_id`,`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `records` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `list` mediumtext DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `data` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `referrals` (
  `id` varchar(191) NOT NULL,
  `referrer_id` char(36) NOT NULL,
  `referred_id` char(36) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'signed_up',
  `discount` bigint(20) DEFAULT 0,
  `discount_invoice` varchar(191) DEFAULT NULL,
  `reward_kind` varchar(191) DEFAULT NULL,
  `reward_days` bigint(20) DEFAULT NULL,
  `commission` bigint(20) DEFAULT NULL,
  `commission_paid_at` bigint(20) DEFAULT NULL,
  `commission_ref` varchar(191) DEFAULT NULL,
  `invoice_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `rewarded_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_referred_id` (`referred_id`),
  KEY `ix_0_referrer_id` (`referrer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `requisitions` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `requested_by` mediumtext DEFAULT NULL,
  `approved_by` mediumtext DEFAULT NULL,
  `po_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `reseller_audit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `at` bigint(20) DEFAULT NULL,
  `actor` varchar(191) DEFAULT NULL,
  `action` varchar(191) DEFAULT NULL,
  `reseller_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `detail` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_reseller_id` (`reseller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `reseller_charges` (
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `reseller_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `package_id` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `term` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `sale_price` bigint(20) DEFAULT 0,
  `status` varchar(32) DEFAULT 'unpaid',
  `method` varchar(191) DEFAULT NULL,
  `stripe_session` varchar(191) DEFAULT NULL,
  `reference` mediumtext DEFAULT NULL,
  `receipt_file` mediumtext DEFAULT NULL,
  `remarks` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `submitted_at` bigint(20) DEFAULT NULL,
  `paid_at` bigint(20) DEFAULT NULL,
  `decided_by` varchar(191) DEFAULT NULL,
  `customer_price` bigint(20) DEFAULT NULL,
  `rate` bigint(20) DEFAULT NULL,
  `period` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_reseller_id` (`reseller_id`),
  KEY `ix_1_customer_id` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `reseller_customers` (
  `id` varchar(191) NOT NULL,
  `reseller_id` varchar(191) NOT NULL,
  `product` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `contact_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `package_id` varchar(191) DEFAULT NULL,
  `term` varchar(32) DEFAULT 'yearly',
  `sale_price` bigint(20) DEFAULT 0,
  `trial_until` bigint(20) DEFAULT NULL,
  `valid_until` bigint(20) DEFAULT NULL,
  `paid_terms` bigint(20) DEFAULT 0,
  `suspended` bigint(20) DEFAULT 0,
  `notes` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_reseller_id` (`reseller_id`),
  KEY `ix_1_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `reseller_earnings` (
  `id` varchar(191) NOT NULL,
  `reseller_id` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `business_id` varchar(191) DEFAULT NULL,
  `licence_id` varchar(191) DEFAULT NULL,
  `package_id` varchar(191) DEFAULT NULL,
  `kind` varchar(32) NOT NULL,
  `period` varchar(191) DEFAULT NULL,
  `term` varchar(191) DEFAULT NULL,
  `customer_price` bigint(20) DEFAULT NULL,
  `reseller_price` bigint(20) DEFAULT NULL,
  `earning` bigint(20) DEFAULT NULL,
  `rate` bigint(20) DEFAULT NULL,
  `charge_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_reseller_id_created_at` (`reseller_id`,`created_at`),
  KEY `ix_1_customer_id` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `reseller_offline` (
  `id` varchar(191) NOT NULL,
  `reseller_id` varchar(191) NOT NULL,
  `package_id` varchar(191) DEFAULT NULL,
  `package_name` varchar(191) DEFAULT NULL,
  `machine` varchar(191) NOT NULL,
  `customer` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `status` varchar(32) DEFAULT 'requested',
  `licence_key` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `decided_at` bigint(20) DEFAULT NULL,
  `customer_price` bigint(20) DEFAULT NULL,
  `rate` bigint(20) DEFAULT NULL,
  `period` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_reseller_id` (`reseller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `reseller_prices` (
  `package_id` varchar(191) NOT NULL,
  `monthly` bigint(20) DEFAULT NULL,
  `yearly` bigint(20) DEFAULT NULL,
  `retail_monthly` bigint(20) DEFAULT NULL,
  `retail_yearly` bigint(20) DEFAULT NULL,
  `offline` bigint(20) DEFAULT NULL,
  `retail_offline` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `resellers` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `company` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'pending',
  `discount_pct` double DEFAULT 0,
  `notes` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `approved_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `restaurant_assets` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `category` varchar(191) DEFAULT NULL,
  `location` mediumtext DEFAULT NULL,
  `serial` varchar(191) DEFAULT NULL,
  `brand` varchar(191) DEFAULT NULL,
  `supplier` varchar(191) DEFAULT NULL,
  `purchase_date` bigint(20) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `warranty_until` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `assigned_to` varchar(191) DEFAULT NULL,
  `service_every_days` bigint(20) DEFAULT NULL,
  `last_service` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `photo` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `routes` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `van_id` varchar(191) DEFAULT NULL,
  `days` mediumtext DEFAULT NULL,
  `customers` mediumtext DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `serials` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `item_id` varchar(191) DEFAULT NULL,
  `serial` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `purchase_id` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `sold_at` bigint(20) DEFAULT NULL,
  `cost` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_item_id_status` (`business_id`,`item_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `server_events` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `at` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `method` varchar(191) DEFAULT NULL,
  `path` mediumtext DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `ms` bigint(20) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `stack` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_kind_at` (`kind`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `settings` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `shifts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `terminal_id` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `opened_at` bigint(20) DEFAULT NULL,
  `closed_at` bigint(20) DEFAULT NULL,
  `opening_cash` bigint(20) DEFAULT NULL,
  `counted_cash` bigint(20) DEFAULT NULL,
  `expected_cash` bigint(20) DEFAULT NULL,
  `z_no` bigint(20) DEFAULT NULL,
  `closed_by` mediumtext DEFAULT NULL,
  `denominations` mediumtext DEFAULT NULL,
  `cash_in` bigint(20) DEFAULT NULL,
  `cash_out` bigint(20) DEFAULT NULL,
  `close_note` mediumtext DEFAULT NULL,
  `device_name` mediumtext DEFAULT NULL,
  `device_ip` mediumtext DEFAULT NULL,
  `report_note` mediumtext DEFAULT NULL,
  `handed_to` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `site_leads` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `created_at` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `name` mediumtext DEFAULT NULL,
  `business` mediumtext DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `outlets` varchar(191) DEFAULT NULL,
  `outlet_type` varchar(191) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `page` mediumtext DEFAULT NULL,
  `status` varchar(32) DEFAULT 'new',
  `notes` mediumtext DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `demo_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `site_posts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) DEFAULT NULL,
  `title` mediumtext DEFAULT NULL,
  `excerpt` mediumtext DEFAULT NULL,
  `body` mediumtext DEFAULT NULL,
  `cover` mediumtext DEFAULT NULL,
  `tags` mediumtext DEFAULT NULL,
  `author` varchar(191) DEFAULT NULL,
  `seo_title` mediumtext DEFAULT NULL,
  `seo_description` mediumtext DEFAULT NULL,
  `published` bigint(20) DEFAULT 1,
  `published_at` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  `lang` varchar(8) DEFAULT 'en',
  PRIMARY KEY (`id`),
  KEY `ix_0_slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `site_visitor_messages` (
  `id` varchar(191) NOT NULL,
  `visitor_id` varchar(64) NOT NULL,
  `sender` varchar(32) NOT NULL,
  `body` mediumtext DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_visitor_id_sent_at` (`visitor_id`,`sent_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `site_visitors` (
  `id` varchar(64) NOT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `time_zone` varchar(191) DEFAULT NULL,
  `page` varchar(320) DEFAULT NULL,
  `referrer` varchar(320) DEFAULT NULL,
  `agent` varchar(320) DEFAULT NULL,
  `lang` varchar(191) DEFAULT NULL,
  `pages` bigint(20) DEFAULT 1,
  `unread` bigint(20) DEFAULT 0,
  `last_text` mediumtext DEFAULT NULL,
  `first_at` bigint(20) DEFAULT NULL,
  `last_at` bigint(20) DEFAULT NULL,
  `last_message_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_last_at` (`last_at`),
  KEY `ix_1_ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `social_posts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `message` mediumtext DEFAULT NULL,
  `image` mediumtext DEFAULT NULL,
  `networks` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `send_at` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `results` mediumtext DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `staff_accounts` (
  `username` varchar(64) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `salt` varchar(191) DEFAULT NULL,
  `hash` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `pw_changed_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`username`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `staff_advances` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `paid_from` varchar(191) DEFAULT NULL,
  `run_id` varchar(191) DEFAULT NULL,
  `voucher_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `staff_phones` (
  `token` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `employee_name` varchar(191) DEFAULT NULL,
  `device_name` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `last_used` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`token`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `staff_tokens` (
  `token` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `device` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `last_used` bigint(20) DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `agent` mediumtext DEFAULT NULL,
  PRIMARY KEY (`token`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stamp_tx` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `program_id` varchar(191) DEFAULT NULL,
  `qty` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_customer_id` (`business_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stock_count_lines` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `count_id` varchar(191) DEFAULT NULL,
  `item_id` varchar(191) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `counted_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_count_id` (`business_id`,`count_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stock_counts` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `category_ids` mediumtext DEFAULT NULL,
  `started_at` bigint(20) DEFAULT NULL,
  `started_by` mediumtext DEFAULT NULL,
  `posted_at` bigint(20) DEFAULT NULL,
  `posted_by` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stock_movements` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `item_id` varchar(191) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `ref_id` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `batch` varchar(191) DEFAULT NULL,
  `expiry` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_item_id` (`business_id`,`item_id`),
  KEY `ix_2_business_id_location_item_id` (`business_id`,`location`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stock_transfers` (
  `id` varchar(191) NOT NULL,
  `root_id` char(36) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `from_id` char(36) DEFAULT NULL,
  `to_id` char(36) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `sent_by` varchar(191) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `received_by` varchar(191) DEFAULT NULL,
  `received_at` bigint(20) DEFAULT NULL,
  `receive_note` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_root_id` (`root_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stripe_events` (
  `id` varchar(191) NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `session` varchar(191) DEFAULT NULL,
  `charge_id` varchar(191) DEFAULT NULL,
  `result` varchar(191) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `supplier_returns` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `supplier_id` varchar(191) DEFAULT NULL,
  `purchase_id` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `subtotal` bigint(20) DEFAULT NULL,
  `tax` bigint(20) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `suppliers` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `contact` mediumtext DEFAULT NULL,
  `phone` mediumtext DEFAULT NULL,
  `email` mediumtext DEFAULT NULL,
  `trn` mediumtext DEFAULT NULL,
  `address` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `visibility` mediumtext DEFAULT NULL,
  `created_by` mediumtext DEFAULT NULL,
  `visible_to` mediumtext DEFAULT NULL,
  `pay_term` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `support_chat` (
  `id` varchar(191) NOT NULL,
  `business_id` varchar(191) NOT NULL,
  `sender` varchar(32) NOT NULL,
  `sender_name` varchar(191) DEFAULT NULL,
  `body` mediumtext NOT NULL,
  `sent_at` bigint(20) NOT NULL,
  `read_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_sent_at` (`business_id`,`sent_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `support_messages` (
  `id` varchar(191) NOT NULL,
  `ticket_id` varchar(191) NOT NULL,
  `author` varchar(191) NOT NULL,
  `author_name` varchar(191) DEFAULT NULL,
  `body` mediumtext NOT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `support_tickets` (
  `id` varchar(191) NOT NULL,
  `number` bigint(20) DEFAULT NULL,
  `business_id` char(36) DEFAULT NULL,
  `business_name` varchar(191) DEFAULT NULL,
  `created_by` varchar(191) DEFAULT NULL,
  `subject` mediumtext NOT NULL,
  `category` varchar(191) DEFAULT NULL,
  `priority` varchar(191) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'open',
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  `unread_admin` bigint(20) DEFAULT 1,
  `unread_business` bigint(20) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `sync_seq` (
  `business_id` char(36) NOT NULL,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tasks` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `title` mediumtext DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `assigned_to` mediumtext DEFAULT NULL,
  `assigned_name` mediumtext DEFAULT NULL,
  `created_by` mediumtext DEFAULT NULL,
  `created_by_name` mediumtext DEFAULT NULL,
  `due_date` bigint(20) DEFAULT NULL,
  `priority` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `photos` mediumtext DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_access` (
  `business_id` char(36) NOT NULL,
  `enabled` bigint(20) DEFAULT 0,
  `branches` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_client_filings` (
  `id` varchar(191) NOT NULL,
  `client_id` varchar(191) NOT NULL,
  `kind` varchar(16) NOT NULL,
  `period_start` varchar(10) NOT NULL,
  `period_end` varchar(10) NOT NULL,
  `label` varchar(191) DEFAULT NULL,
  `due_date` varchar(10) NOT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'open',
  `filed_date` varchar(10) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `submitted_by` varchar(191) DEFAULT NULL,
  `last_reminder` varchar(10) DEFAULT NULL,
  `reminders_sent` bigint(20) DEFAULT 0,
  `notes` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_client_id` (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_clients` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `entity` varchar(191) DEFAULT NULL,
  `emirate` varchar(191) DEFAULT NULL,
  `vat_trn` varchar(191) DEFAULT NULL,
  `ct_trn` varchar(191) DEFAULT NULL,
  `contact_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `managed` bigint(20) DEFAULT 0,
  `notes` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_cycles` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) NOT NULL,
  `kind` varchar(16) NOT NULL,
  `period_start` varchar(10) NOT NULL,
  `period_end` varchar(10) NOT NULL,
  `label` varchar(191) DEFAULT NULL,
  `due_date` varchar(10) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'upcoming',
  `draft` mediumtext DEFAULT NULL,
  `draft_at` bigint(20) DEFAULT NULL,
  `filed_date` varchar(10) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `receipt` varchar(191) DEFAULT NULL,
  `submitted_at` bigint(20) DEFAULT NULL,
  `submitted_by` varchar(191) DEFAULT NULL,
  `last_reminder` varchar(10) DEFAULT NULL,
  `reminders_sent` bigint(20) DEFAULT 0,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_business_id_kind_period_start` (`business_id`,`kind`,`period_start`),
  KEY `ix_0_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_notifications` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `cycle_id` char(36) DEFAULT NULL,
  `priority` varchar(191) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `is_read` bigint(20) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_is_read` (`business_id`,`is_read`),
  KEY `ix_1_cycle_id` (`cycle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_profiles` (
  `business_id` char(36) NOT NULL,
  `entity` varchar(191) DEFAULT NULL,
  `emirate` varchar(191) DEFAULT NULL,
  `vat_registered` bigint(20) DEFAULT NULL,
  `vat_trn` varchar(191) DEFAULT NULL,
  `vat_stagger` varchar(191) DEFAULT NULL,
  `vat_due_day` bigint(20) DEFAULT 28,
  `ct_registered` bigint(20) DEFAULT NULL,
  `ct_trn` varchar(191) DEFAULT NULL,
  `fy_from` varchar(191) DEFAULT NULL,
  `fy_to` varchar(191) DEFAULT NULL,
  `managed` bigint(20) DEFAULT 0,
  `setup_status` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_reminders` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `client_id` varchar(191) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `message` text DEFAULT NULL,
  `due_date` varchar(10) DEFAULT NULL,
  `start_on` varchar(10) NOT NULL,
  `every_days` bigint(20) DEFAULT 0,
  `to_client` bigint(20) DEFAULT 1,
  `to_team` bigint(20) DEFAULT 0,
  `team_email` varchar(191) DEFAULT NULL,
  `status` varchar(16) NOT NULL DEFAULT 'open',
  `last_sent` varchar(10) DEFAULT NULL,
  `created_by` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tax_requests` (
  `id` varchar(191) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `stage` varchar(32) NOT NULL DEFAULT 'new',
  `consultant` varchar(191) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `message` text DEFAULT NULL,
  `contact_name` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) DEFAULT NULL,
  `client_id` varchar(191) DEFAULT NULL,
  `company` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `terminals` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `prefix` mediumtext DEFAULT NULL,
  `employees` mediumtext DEFAULT NULL,
  `receipt_printer` mediumtext DEFAULT NULL,
  `kot_printer` mediumtext DEFAULT NULL,
  `drawer` bigint(20) DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tickets` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `order_type` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `customer_phone` mediumtext DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `customer_address` mediumtext DEFAULT NULL,
  `discount_id` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `opened_at` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `driver_id` varchar(191) DEFAULT NULL,
  `delivery_status` mediumtext DEFAULT NULL,
  `delivered_at` bigint(20) DEFAULT NULL,
  `collected_at` bigint(20) DEFAULT NULL,
  `delivery_issue` mediumtext DEFAULT NULL,
  `delivery_partner` mediumtext DEFAULT NULL,
  `delivery_photo` mediumtext DEFAULT NULL,
  `handed_at` bigint(20) DEFAULT NULL,
  `handed_by` mediumtext DEFAULT NULL,
  `cancelled_at` bigint(20) DEFAULT NULL,
  `cancel_reason` mediumtext DEFAULT NULL,
  `cancelled_by` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_status` (`business_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `tokens` (
  `token` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `last_used` bigint(20) DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `agent` mediumtext DEFAULT NULL,
  PRIMARY KEY (`token`),
  KEY `ix_0_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `track_links` (
  `code` varchar(16) NOT NULL,
  `business_id` varchar(191) DEFAULT NULL,
  `job_key` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `expires_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`code`),
  KEY `ix_0_business_id_job_key` (`business_id`,`job_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `uae_einv` (
  `business_id` char(36) NOT NULL,
  `receipt_id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `asp_ref` varchar(191) DEFAULT NULL,
  `message` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `tries` bigint(20) DEFAULT 0,
  PRIMARY KEY (`business_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `users` (
  `email` varchar(191) NOT NULL,
  `salt` varchar(191) DEFAULT NULL,
  `hash` varchar(191) DEFAULT NULL,
  `role` varchar(32) NOT NULL,
  `business_id` char(36) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `reseller_id` varchar(191) DEFAULT NULL,
  `totp_secret` varchar(191) DEFAULT NULL,
  `totp_pending` varchar(191) DEFAULT NULL,
  `totp_recovery` text DEFAULT NULL,
  `totp_last` bigint(20) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `branches` text DEFAULT NULL,
  `admin_role` varchar(191) DEFAULT NULL,
  `pw_changed_at` bigint(20) DEFAULT NULL,
  `disabled` bigint(20) DEFAULT 0,
  PRIMARY KEY (`email`),
  KEY `ix_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `van_days` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `van_id` varchar(191) DEFAULT NULL,
  `day` varchar(191) DEFAULT NULL,
  `route_id` varchar(191) DEFAULT NULL,
  `salesman_id` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `opened_at` bigint(20) DEFAULT NULL,
  `opening_cash` bigint(20) DEFAULT NULL,
  `submitted_at` bigint(20) DEFAULT NULL,
  `expected_cash` bigint(20) DEFAULT NULL,
  `counted_cash` bigint(20) DEFAULT NULL,
  `cheques` mediumtext DEFAULT NULL,
  `stock` mediumtext DEFAULT NULL,
  `summary` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `approved_by` mediumtext DEFAULT NULL,
  `approved_at` bigint(20) DEFAULT NULL,
  `decision_note` mediumtext DEFAULT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `van_transfers` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `van_id` varchar(191) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `approved_by` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `vans` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `plate` mediumtext DEFAULT NULL,
  `salesman_id` varchar(191) DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `payment_account` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `visits` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `van_id` varchar(191) DEFAULT NULL,
  `day` varchar(191) DEFAULT NULL,
  `route_id` varchar(191) DEFAULT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `stop_no` bigint(20) DEFAULT NULL,
  `planned` bigint(20) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `checked_in_at` bigint(20) DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `distance_m` double DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `salesman_id` varchar(191) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_van_id_day` (`business_id`,`van_id`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `vouchers` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `date` bigint(20) DEFAULT NULL,
  `narration` mediumtext DEFAULT NULL,
  `lines` mediumtext DEFAULT NULL,
  `attachment` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `approved_by` mediumtext DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_date` (`business_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `wa_accounts` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `phone_id` varchar(191) DEFAULT NULL,
  `waba_id` varchar(191) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `token` text DEFAULT NULL,
  `app_secret` text DEFAULT NULL,
  `verify_token` varchar(191) DEFAULT NULL,
  `hook` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_hook` (`hook`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `wa_chats` (
  `id` varchar(191) NOT NULL,
  `account_id` varchar(191) NOT NULL,
  `wa_id` varchar(64) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `last_text` text DEFAULT NULL,
  `last_at` bigint(20) DEFAULT NULL,
  `last_in_at` bigint(20) DEFAULT NULL,
  `unread` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_account_id_wa_id` (`account_id`,`wa_id`),
  KEY `ix_0_last_at` (`last_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `wa_hooks` (
  `hook` varchar(191) NOT NULL,
  `business_id` char(36) NOT NULL,
  PRIMARY KEY (`hook`),
  UNIQUE KEY `ux_0_business_id` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `wa_msgs` (
  `id` varchar(191) NOT NULL,
  `account_id` varchar(191) DEFAULT NULL,
  `chat_id` varchar(191) NOT NULL,
  `wa_msg_id` varchar(191) DEFAULT NULL,
  `dir` varchar(8) DEFAULT NULL,
  `kind` varchar(32) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `media_id` varchar(191) DEFAULT NULL,
  `mime` varchar(191) DEFAULT NULL,
  `file_name` varchar(191) DEFAULT NULL,
  `status` varchar(32) DEFAULT NULL,
  `error` text DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_0_wa_msg_id` (`wa_msg_id`),
  KEY `ix_0_chat_id_at` (`chat_id`,`at`),
  KEY `ix_1_account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `wallet_tx` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `customer_id` varchar(191) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`),
  KEY `ix_1_business_id_customer_id` (`business_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `wash_plans` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `name_ar` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `days` bigint(20) DEFAULT NULL,
  `limit_type` mediumtext DEFAULT NULL,
  `limit_qty` double DEFAULT NULL,
  `show_on_site` bigint(20) DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `services` mediumtext DEFAULT NULL,
  `rollover` bigint(20) DEFAULT NULL,
  `pickups` bigint(20) DEFAULT NULL,
  `updated_at` bigint(20) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_seq` (`business_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `ws_loads` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `day` varchar(10) DEFAULT NULL,
  `machine_id` varchar(191) DEFAULT NULL,
  `machine_name` mediumtext DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `grp` mediumtext DEFAULT NULL,
  `service` mediumtext DEFAULT NULL,
  `kg` double DEFAULT NULL,
  `pieces` bigint(20) DEFAULT NULL,
  `items` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `started_at` bigint(20) DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_day` (`business_id`,`day`),
  KEY `ix_1_business_id_status` (`business_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `ws_machines` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` mediumtext DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `capacity_kg` double DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `ws_packing` (
  `business_id` char(36) NOT NULL,
  `receipt_id` varchar(191) NOT NULL,
  `number` varchar(191) DEFAULT NULL,
  `expected` bigint(20) DEFAULT NULL,
  `counted` bigint(20) DEFAULT NULL,
  `ticked` mediumtext DEFAULT NULL,
  `missing` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `override_by` mediumtext DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `ws_packing_log` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `number` varchar(191) DEFAULT NULL,
  `customer_name` mediumtext DEFAULT NULL,
  `expected` bigint(20) DEFAULT NULL,
  `counted` bigint(20) DEFAULT NULL,
  `missing` mediumtext DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `override_by` mediumtext DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `ws_photos` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `receipt_id` varchar(191) DEFAULT NULL,
  `line_id` varchar(191) DEFAULT NULL,
  `piece` bigint(20) DEFAULT NULL,
  `kind` varchar(191) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `path` mediumtext DEFAULT NULL,
  `by_name` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_receipt_id` (`business_id`,`receipt_id`),
  KEY `ix_1_business_id_created_at` (`business_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `ws_slots` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `area` mediumtext DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `active` bigint(20) DEFAULT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `zk_commands` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `business_id` char(36) NOT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `cmd` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `sent_at` bigint(20) DEFAULT NULL,
  `done_at` bigint(20) DEFAULT NULL,
  `result` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_0_business_id_device_id` (`business_id`,`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `zk_device_users` (
  `business_id` char(36) NOT NULL,
  `device_id` varchar(191) NOT NULL,
  `pin` varchar(191) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `card` varchar(191) DEFAULT NULL,
  `privilege` bigint(20) DEFAULT NULL,
  `seen_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`device_id`,`pin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `zk_devices` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `serial` varchar(191) DEFAULT NULL,
  `mode` varchar(191) DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `port` bigint(20) DEFAULT NULL,
  `comm_key` bigint(20) DEFAULT NULL,
  `last_seen` bigint(20) DEFAULT NULL,
  `last_sync` bigint(20) DEFAULT NULL,
  `last_error` mediumtext DEFAULT NULL,
  `users` bigint(20) DEFAULT NULL,
  `logs` bigint(20) DEFAULT NULL,
  `info` mediumtext DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_serial` (`serial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `zk_logs` (
  `business_id` char(36) NOT NULL,
  `id` varchar(191) NOT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `pin` varchar(191) DEFAULT NULL,
  `at` bigint(20) DEFAULT NULL,
  `state` bigint(20) DEFAULT NULL,
  `verify` bigint(20) DEFAULT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  `applied` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`id`),
  KEY `ix_0_business_id_at` (`business_id`,`at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `zk_map` (
  `business_id` char(36) NOT NULL,
  `pin` varchar(191) NOT NULL,
  `employee_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`business_id`,`pin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
/*M!999999\- enable the sandbox mode */ 
SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
INSERT IGNORE INTO `migrations` VALUES (1,'0001_01_01_000001_create_cache_table',1);
INSERT IGNORE INTO `migrations` VALUES (2,'2026_10_26_000001_create_dinepad_tables',1);
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;
SET FOREIGN_KEY_CHECKS=1;
