Da

✏️ Editing: phraphay_akau2135.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: phraphay_akau2135
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `phraphay_akau2135`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phraphay_akau2135` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `phraphay_akau2135`;

--
-- Table structure for table `32j_accounts`
--

DROP TABLE IF EXISTS `32j_accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `number` varchar(191) NOT NULL,
  `currency_code` varchar(191) NOT NULL,
  `opening_balance` double(15,4) NOT NULL DEFAULT 0.0000,
  `bank_name` varchar(191) DEFAULT NULL,
  `bank_phone` varchar(191) DEFAULT NULL,
  `bank_address` text DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_accounts_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_accounts`
--

LOCK TABLES `32j_accounts` WRITE;
/*!40000 ALTER TABLE `32j_accounts` DISABLE KEYS */;
INSERT INTO `32j_accounts` VALUES (1,1,'Cash','1','USD',0.0000,'Cash',NULL,NULL,1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL);
/*!40000 ALTER TABLE `32j_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_bill_histories`
--

DROP TABLE IF EXISTS `32j_bill_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_bill_histories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `status` varchar(191) NOT NULL,
  `notify` tinyint(1) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_bill_histories_company_id_index` (`company_id`),
  KEY `32j_bill_histories_bill_id_index` (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_bill_histories`
--

LOCK TABLES `32j_bill_histories` WRITE;
/*!40000 ALTER TABLE `32j_bill_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_bill_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_bill_item_taxes`
--

DROP TABLE IF EXISTS `32j_bill_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_bill_item_taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `bill_item_id` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `amount` double(15,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_bill_item_taxes_company_id_index` (`company_id`),
  KEY `32j_bill_item_taxes_bill_id_index` (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_bill_item_taxes`
--

LOCK TABLES `32j_bill_item_taxes` WRITE;
/*!40000 ALTER TABLE `32j_bill_item_taxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_bill_item_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_bill_items`
--

DROP TABLE IF EXISTS `32j_bill_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_bill_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `quantity` double(7,2) NOT NULL,
  `price` double(15,4) NOT NULL,
  `total` double(15,4) NOT NULL,
  `tax` double(15,4) NOT NULL DEFAULT 0.0000,
  `discount_rate` double(15,4) NOT NULL DEFAULT 0.0000,
  `discount_type` varchar(191) NOT NULL DEFAULT 'normal',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_bill_items_company_id_index` (`company_id`),
  KEY `32j_bill_items_bill_id_index` (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_bill_items`
--

LOCK TABLES `32j_bill_items` WRITE;
/*!40000 ALTER TABLE `32j_bill_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_bill_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_bill_totals`
--

DROP TABLE IF EXISTS `32j_bill_totals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_bill_totals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `amount` double(15,4) NOT NULL,
  `sort_order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_bill_totals_company_id_index` (`company_id`),
  KEY `32j_bill_totals_bill_id_index` (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_bill_totals`
--

LOCK TABLES `32j_bill_totals` WRITE;
/*!40000 ALTER TABLE `32j_bill_totals` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_bill_totals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_bills`
--

DROP TABLE IF EXISTS `32j_bills`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_bills` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `bill_number` varchar(191) NOT NULL,
  `order_number` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `billed_at` datetime NOT NULL,
  `due_at` datetime NOT NULL,
  `amount` double(15,4) NOT NULL,
  `currency_code` varchar(191) NOT NULL,
  `currency_rate` double(15,8) NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `contact_id` int(11) NOT NULL,
  `contact_name` varchar(191) NOT NULL,
  `contact_email` varchar(191) DEFAULT NULL,
  `contact_tax_number` varchar(191) DEFAULT NULL,
  `contact_phone` varchar(191) DEFAULT NULL,
  `contact_address` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_bills_company_id_bill_number_deleted_at_unique` (`company_id`,`bill_number`,`deleted_at`),
  KEY `32j_bills_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_bills`
--

LOCK TABLES `32j_bills` WRITE;
/*!40000 ALTER TABLE `32j_bills` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_bills` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_categories`
--

DROP TABLE IF EXISTS `32j_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `color` varchar(191) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_categories_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_categories`
--

LOCK TABLES `32j_categories` WRITE;
/*!40000 ALTER TABLE `32j_categories` DISABLE KEYS */;
INSERT INTO `32j_categories` VALUES (1,1,'Transfer','other','#3c3f72',1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(2,1,'Deposit','income','#efad32',1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(3,1,'Sales','income','#6da252',1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(4,1,'Other','expense','#e5e5e5',1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(5,1,'General','item','#328aef',1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL);
/*!40000 ALTER TABLE `32j_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_companies`
--

DROP TABLE IF EXISTS `32j_companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(191) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_companies`
--

LOCK TABLES `32j_companies` WRITE;
/*!40000 ALTER TABLE `32j_companies` DISABLE KEYS */;
INSERT INTO `32j_companies` VALUES (1,'',1,'core::ui',NULL,'2023-01-12 03:03:11','2023-01-12 03:03:11',NULL);
/*!40000 ALTER TABLE `32j_companies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_contacts`
--

DROP TABLE IF EXISTS `32j_contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `type` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `tax_number` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `zip_code` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `currency_code` varchar(191) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `reference` varchar(191) DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_contacts_company_id_type_email_deleted_at_unique` (`company_id`,`type`,`email`,`deleted_at`),
  KEY `32j_contacts_company_id_type_index` (`company_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_contacts`
--

LOCK TABLES `32j_contacts` WRITE;
/*!40000 ALTER TABLE `32j_contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_currencies`
--

DROP TABLE IF EXISTS `32j_currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_currencies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `rate` double(15,8) NOT NULL,
  `precision` varchar(191) DEFAULT NULL,
  `symbol` varchar(191) DEFAULT NULL,
  `symbol_first` int(11) NOT NULL DEFAULT 1,
  `decimal_mark` varchar(191) DEFAULT NULL,
  `thousands_separator` varchar(191) DEFAULT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_currencies_company_id_code_deleted_at_unique` (`company_id`,`code`,`deleted_at`),
  KEY `32j_currencies_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_currencies`
--

LOCK TABLES `32j_currencies` WRITE;
/*!40000 ALTER TABLE `32j_currencies` DISABLE KEYS */;
INSERT INTO `32j_currencies` VALUES (1,1,'US Dollar','USD',1.00000000,'2','$',1,'.',',',1,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(2,1,'Euro','EUR',1.25000000,'2','€',1,',','.',0,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:06:19',NULL),(3,1,'British Pound','GBP',1.60000000,'2','£',1,'.',',',0,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:06:19',NULL),(4,1,'Turkish Lira','TRY',0.80000000,'2','₺',1,',','.',0,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:06:10',NULL),(5,1,'Thai Baht','THB',33.00000000,NULL,NULL,1,NULL,NULL,1,'core::ui',1,'2023-01-12 03:06:41','2023-01-12 03:06:41',NULL);
/*!40000 ALTER TABLE `32j_currencies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_dashboards`
--

DROP TABLE IF EXISTS `32j_dashboards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_dashboards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_dashboards_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_dashboards`
--

LOCK TABLES `32j_dashboards` WRITE;
/*!40000 ALTER TABLE `32j_dashboards` DISABLE KEYS */;
INSERT INTO `32j_dashboards` VALUES (1,1,'Dashboard',1,'core::seed',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL);
/*!40000 ALTER TABLE `32j_dashboards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_document_histories`
--

DROP TABLE IF EXISTS `32j_document_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_document_histories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `type` varchar(191) NOT NULL,
  `document_id` int(10) unsigned NOT NULL,
  `status` varchar(191) NOT NULL,
  `notify` tinyint(1) NOT NULL,
  `description` text DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_document_histories_company_id_index` (`company_id`),
  KEY `32j_document_histories_type_index` (`type`),
  KEY `32j_document_histories_document_id_index` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_document_histories`
--

LOCK TABLES `32j_document_histories` WRITE;
/*!40000 ALTER TABLE `32j_document_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_document_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_document_item_taxes`
--

DROP TABLE IF EXISTS `32j_document_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_document_item_taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `type` varchar(191) NOT NULL,
  `document_id` int(10) unsigned NOT NULL,
  `document_item_id` int(10) unsigned NOT NULL,
  `tax_id` int(10) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `amount` double(15,4) NOT NULL DEFAULT 0.0000,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_document_item_taxes_company_id_index` (`company_id`),
  KEY `32j_document_item_taxes_type_index` (`type`),
  KEY `32j_document_item_taxes_document_id_index` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_document_item_taxes`
--

LOCK TABLES `32j_document_item_taxes` WRITE;
/*!40000 ALTER TABLE `32j_document_item_taxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_document_item_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_document_items`
--

DROP TABLE IF EXISTS `32j_document_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_document_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `type` varchar(191) NOT NULL,
  `document_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `quantity` double(7,2) NOT NULL,
  `price` double(15,4) NOT NULL,
  `tax` double(15,4) NOT NULL DEFAULT 0.0000,
  `discount_type` varchar(191) NOT NULL DEFAULT 'normal',
  `discount_rate` double(15,4) NOT NULL DEFAULT 0.0000,
  `total` double(15,4) NOT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_document_items_company_id_index` (`company_id`),
  KEY `32j_document_items_type_index` (`type`),
  KEY `32j_document_items_document_id_index` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_document_items`
--

LOCK TABLES `32j_document_items` WRITE;
/*!40000 ALTER TABLE `32j_document_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_document_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_document_totals`
--

DROP TABLE IF EXISTS `32j_document_totals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_document_totals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `type` varchar(191) NOT NULL,
  `document_id` int(10) unsigned NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `amount` double(15,4) NOT NULL,
  `sort_order` int(11) NOT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_document_totals_company_id_index` (`company_id`),
  KEY `32j_document_totals_type_index` (`type`),
  KEY `32j_document_totals_document_id_index` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_document_totals`
--

LOCK TABLES `32j_document_totals` WRITE;
/*!40000 ALTER TABLE `32j_document_totals` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_document_totals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_documents`
--

DROP TABLE IF EXISTS `32j_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `type` varchar(191) NOT NULL,
  `document_number` varchar(191) NOT NULL,
  `order_number` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `issued_at` datetime NOT NULL,
  `due_at` datetime NOT NULL,
  `amount` double(15,4) NOT NULL,
  `currency_code` varchar(191) NOT NULL,
  `currency_rate` double(15,8) NOT NULL,
  `category_id` int(10) unsigned NOT NULL DEFAULT 1,
  `contact_id` int(10) unsigned NOT NULL,
  `contact_name` varchar(191) NOT NULL,
  `contact_email` varchar(191) DEFAULT NULL,
  `contact_tax_number` varchar(191) DEFAULT NULL,
  `contact_phone` varchar(191) DEFAULT NULL,
  `contact_address` text DEFAULT NULL,
  `contact_city` varchar(191) DEFAULT NULL,
  `contact_zip_code` varchar(191) DEFAULT NULL,
  `contact_state` varchar(191) DEFAULT NULL,
  `contact_country` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_documents_document_number_deleted_at_company_id_type_unique` (`document_number`,`deleted_at`,`company_id`,`type`),
  KEY `32j_documents_company_id_index` (`company_id`),
  KEY `32j_documents_type_index` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_documents`
--

LOCK TABLES `32j_documents` WRITE;
/*!40000 ALTER TABLE `32j_documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_documents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_email_templates`
--

DROP TABLE IF EXISTS `32j_email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_email_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `alias` varchar(191) NOT NULL,
  `class` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `body` text NOT NULL,
  `params` text DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_email_templates_company_id_alias_deleted_at_unique` (`company_id`,`alias`,`deleted_at`),
  KEY `32j_email_templates_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_email_templates`
--

LOCK TABLES `32j_email_templates` WRITE;
/*!40000 ALTER TABLE `32j_email_templates` DISABLE KEYS */;
INSERT INTO `32j_email_templates` VALUES (1,1,'invoice_new_customer','App\\Notifications\\Sale\\Invoice','settings.email.templates.invoice_new_customer','{invoice_number} invoice created','Dear {customer_name}, We have prepared the following invoice for you: {invoice_number}. You can see the invoice details and proceed with the payment from the following link: <a href=\"{invoice_guest_link}\">{invoice_number}</a>. Feel free to contact us with any questions. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(2,1,'invoice_remind_customer','App\\Notifications\\Sale\\Invoice','settings.email.templates.invoice_remind_customer','{invoice_number} invoice overdue notice','Dear {customer_name}, This is an overdue notice for {invoice_number} invoice. The invoice total is {invoice_total} and was due {invoice_due_date}. You can see the invoice details and proceed with the payment from the following link: <a href=\"{invoice_guest_link}\">{invoice_number}</a>. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(3,1,'invoice_remind_admin','App\\Notifications\\Sale\\Invoice','settings.email.templates.invoice_remind_admin','{invoice_number} invoice overdue notice','Hello, {customer_name} has received an overdue notice for {invoice_number} invoice. The invoice total is {invoice_total} and was due {invoice_due_date}. You can see the invoice details from the following link: <a href=\"{invoice_admin_link}\">{invoice_number}</a>. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(4,1,'invoice_recur_customer','App\\Notifications\\Sale\\Invoice','settings.email.templates.invoice_recur_customer','{invoice_number} recurring invoice created','Dear {customer_name}, Based on your recurring circle, we have prepared the following invoice for you: {invoice_number}. You can see the invoice details and proceed with the payment from the following link: <a href=\"{invoice_guest_link}\">{invoice_number}</a>. Feel free to contact us with any questions. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(5,1,'invoice_recur_admin','App\\Notifications\\Sale\\Invoice','settings.email.templates.invoice_recur_admin','{invoice_number} recurring invoice created','Hello, Based on {customer_name} recurring circle, {invoice_number} invoice has been automatically created. You can see the invoice details from the following link: <a href=\"{invoice_admin_link}\">{invoice_number}</a>. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(6,1,'invoice_payment_customer','App\\Notifications\\Portal\\PaymentReceived','settings.email.templates.invoice_payment_customer','Payment received for {invoice_number} invoice','Dear {customer_name}, Thank you for the payment. Find the payment details below: ------------------------------------------------- Amount: {transaction_total} Date: {transaction_paid_date} Invoice Number: {invoice_number} ------------------------------------------------- You can always see the invoice details from the following link: <a href=\"{invoice_guest_link}\">{invoice_number}</a>. Feel free to contact us with any questions. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(7,1,'invoice_payment_admin','App\\Notifications\\Portal\\PaymentReceived','settings.email.templates.invoice_payment_admin','Payment received for {invoice_number} invoice','Hello, {customer_name} recorded a payment for {invoice_number} invoice. You can see the invoice details from the following link: <a href=\"{invoice_admin_link}\">{invoice_number}</a>. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(8,1,'bill_remind_admin','App\\Notifications\\Purchase\\Bill','settings.email.templates.bill_remind_admin','{bill_number} bill reminding notice','Hello, This is a reminding notice for {bill_number} bill to {vendor_name}. The bill total is {bill_total} and is due {bill_due_date}. You can see the bill details from the following link: <a href=\"{bill_admin_link}\">{bill_number}</a>. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:18','2023-01-12 03:03:18',NULL),(9,1,'bill_recur_admin','App\\Notifications\\Purchase\\Bill','settings.email.templates.bill_recur_admin','{bill_number} recurring bill created','Hello, Based on {vendor_name} recurring circle, {bill_number} bill has been automatically created. You can see the bill details from the following link: <a href=\"{bill_admin_link}\">{bill_number}</a>. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL),(10,1,'revenue_new_customer','App\\Notifications\\Sale\\Revenue','settings.email.templates.revenue_new_customer','{revenue_date} payment created','Dear {customer_name}, We have prepared the following payment. You can see the payment details from the following link: <a href=\"{revenue_guest_link}\">{revenue_date}</a>. Feel free to contact us with any questions.. Best Regards, {company_name}',NULL,'core::seed',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL);
/*!40000 ALTER TABLE `32j_email_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_failed_jobs`
--

DROP TABLE IF EXISTS `32j_failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) DEFAULT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_failed_jobs`
--

LOCK TABLES `32j_failed_jobs` WRITE;
/*!40000 ALTER TABLE `32j_failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_firewall_ips`
--

DROP TABLE IF EXISTS `32j_firewall_ips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_firewall_ips` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(191) NOT NULL,
  `log_id` int(11) DEFAULT NULL,
  `blocked` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_firewall_ips_ip_deleted_at_unique` (`ip`,`deleted_at`),
  KEY `32j_firewall_ips_ip_index` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_firewall_ips`
--

LOCK TABLES `32j_firewall_ips` WRITE;
/*!40000 ALTER TABLE `32j_firewall_ips` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_firewall_ips` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_firewall_logs`
--

DROP TABLE IF EXISTS `32j_firewall_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_firewall_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(191) NOT NULL,
  `level` varchar(191) NOT NULL DEFAULT 'medium',
  `middleware` varchar(191) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `url` varchar(191) DEFAULT NULL,
  `referrer` varchar(191) DEFAULT NULL,
  `request` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_firewall_logs_ip_index` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_firewall_logs`
--

LOCK TABLES `32j_firewall_logs` WRITE;
/*!40000 ALTER TABLE `32j_firewall_logs` DISABLE KEYS */;
INSERT INTO `32j_firewall_logs` VALUES (1,'51.158.98.24','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-02-25 08:00:05','2023-02-25 08:00:05',NULL),(2,'205.210.31.27','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-03-25 13:58:18','2023-03-25 13:58:18',NULL),(3,'51.158.118.231','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-03-30 01:00:24','2023-03-30 01:00:24',NULL),(4,'51.158.66.83','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-05-03 15:35:30','2023-05-03 15:35:30',NULL),(5,'205.210.31.155','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-05-19 13:22:45','2023-05-19 13:22:45',NULL),(6,'198.235.24.185','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-05-20 13:36:14','2023-05-20 13:36:14',NULL),(7,'159.223.108.26','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-07-13 00:15:10','2023-07-13 00:15:10',NULL),(8,'198.235.24.152','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-07-21 17:44:20','2023-07-21 17:44:20',NULL),(9,'205.210.31.134','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-07-22 01:00:14','2023-07-22 01:00:14',NULL),(10,'205.210.31.181','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-07-29 10:30:18','2023-07-29 10:30:18',NULL),(11,'198.235.24.46','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-08-06 03:18:59','2023-08-06 03:18:59',NULL),(12,'198.235.24.43','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-09-03 11:40:29','2023-09-03 11:40:29',NULL),(13,'49.229.195.137','medium','login',0,'https://akaunting-2-1-35.phraphay.com/auth/login','https://akaunting-2-1-35.phraphay.com/auth/login','_token=aYsJDiNizVQIIwzCSIkapd8bTNRxHj9DGXrZJnzW&email=chaiwat@phraphay.com&password=******','2023-09-20 02:38:06','2023-09-20 02:38:06',NULL),(14,'49.229.195.137','medium','login',0,'https://akaunting-2-1-35.phraphay.com/auth/login','https://akaunting-2-1-35.phraphay.com/auth/login','_token=aYsJDiNizVQIIwzCSIkapd8bTNRxHj9DGXrZJnzW&email=admin@phraphay.com&password=******','2023-09-20 02:38:10','2023-09-20 02:38:10',NULL),(15,'49.229.195.137','medium','login',0,'https://akaunting-2-1-35.phraphay.com/auth/login','https://akaunting-2-1-35.phraphay.com/auth/login','_token=aYsJDiNizVQIIwzCSIkapd8bTNRxHj9DGXrZJnzW&email=admin@phraphay.com&password=******','2023-09-20 02:38:28','2023-09-20 02:38:28',NULL),(16,'49.229.195.137','medium','login',0,'https://akaunting-2-1-35.phraphay.com/auth/login','https://akaunting-2-1-35.phraphay.com/auth/login','_token=aYsJDiNizVQIIwzCSIkapd8bTNRxHj9DGXrZJnzW&email=admin@phraphay.com&password=******','2023-09-20 02:40:23','2023-09-20 02:40:23',NULL),(17,'198.235.24.31','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-09-23 16:18:09','2023-09-23 16:18:09',NULL),(18,'205.210.31.137','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-09-25 00:16:44','2023-09-25 00:16:44',NULL),(19,'8.217.111.169','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-09-27 11:40:16','2023-09-27 11:40:16',NULL),(20,'147.139.212.190','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-09-27 17:23:37','2023-09-27 17:23:37',NULL),(21,'205.210.31.9','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-09-29 19:30:33','2023-09-29 19:30:33',NULL),(22,'198.235.24.135','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-10-06 13:24:50','2023-10-06 13:24:50',NULL),(23,'205.210.31.170','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-10-09 06:05:00','2023-10-09 06:05:00',NULL),(24,'205.210.31.28','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','http://114.119.173.151:80/','','2023-10-21 08:47:31','2023-10-21 08:47:31',NULL),(25,'198.235.24.178','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-10-23 12:38:51','2023-10-23 12:38:51',NULL),(26,'15.204.183.219','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-11-30 08:40:08','2023-11-30 08:40:08',NULL),(27,'135.148.100.196','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2023-12-31 00:35:20','2023-12-31 00:35:20',NULL),(28,'212.224.93.60','medium','agent',0,'https://akaunting-2-1-35.phraphay.com','NULL','','2024-01-14 02:15:56','2024-01-14 02:15:56',NULL);
/*!40000 ALTER TABLE `32j_firewall_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_invoice_histories`
--

DROP TABLE IF EXISTS `32j_invoice_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_invoice_histories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `status` varchar(191) NOT NULL,
  `notify` tinyint(1) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_invoice_histories_company_id_index` (`company_id`),
  KEY `32j_invoice_histories_invoice_id_index` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_invoice_histories`
--

LOCK TABLES `32j_invoice_histories` WRITE;
/*!40000 ALTER TABLE `32j_invoice_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_invoice_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_invoice_item_taxes`
--

DROP TABLE IF EXISTS `32j_invoice_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_invoice_item_taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `invoice_item_id` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `amount` double(15,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_invoice_item_taxes_company_id_index` (`company_id`),
  KEY `32j_invoice_item_taxes_invoice_id_index` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_invoice_item_taxes`
--

LOCK TABLES `32j_invoice_item_taxes` WRITE;
/*!40000 ALTER TABLE `32j_invoice_item_taxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_invoice_item_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_invoice_items`
--

DROP TABLE IF EXISTS `32j_invoice_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_invoice_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `quantity` double(7,2) NOT NULL,
  `price` double(15,4) NOT NULL,
  `total` double(15,4) NOT NULL,
  `tax` double(15,4) NOT NULL DEFAULT 0.0000,
  `discount_rate` double(15,4) NOT NULL DEFAULT 0.0000,
  `discount_type` varchar(191) NOT NULL DEFAULT 'normal',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_invoice_items_company_id_index` (`company_id`),
  KEY `32j_invoice_items_invoice_id_index` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_invoice_items`
--

LOCK TABLES `32j_invoice_items` WRITE;
/*!40000 ALTER TABLE `32j_invoice_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_invoice_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_invoice_totals`
--

DROP TABLE IF EXISTS `32j_invoice_totals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_invoice_totals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `amount` double(15,4) NOT NULL,
  `sort_order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_invoice_totals_company_id_index` (`company_id`),
  KEY `32j_invoice_totals_invoice_id_index` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_invoice_totals`
--

LOCK TABLES `32j_invoice_totals` WRITE;
/*!40000 ALTER TABLE `32j_invoice_totals` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_invoice_totals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_invoices`
--

DROP TABLE IF EXISTS `32j_invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `invoice_number` varchar(191) NOT NULL,
  `order_number` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `invoiced_at` datetime NOT NULL,
  `due_at` datetime NOT NULL,
  `amount` double(15,4) NOT NULL,
  `currency_code` varchar(191) NOT NULL,
  `currency_rate` double(15,8) NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `contact_id` int(11) NOT NULL,
  `contact_name` varchar(191) NOT NULL,
  `contact_email` varchar(191) DEFAULT NULL,
  `contact_tax_number` varchar(191) DEFAULT NULL,
  `contact_phone` varchar(191) DEFAULT NULL,
  `contact_address` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_invoices_company_id_invoice_number_deleted_at_unique` (`company_id`,`invoice_number`,`deleted_at`),
  KEY `32j_invoices_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_invoices`
--

LOCK TABLES `32j_invoices` WRITE;
/*!40000 ALTER TABLE `32j_invoices` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_item_taxes`
--

DROP TABLE IF EXISTS `32j_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_item_taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_item_taxes_company_id_item_id_index` (`company_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_item_taxes`
--

LOCK TABLES `32j_item_taxes` WRITE;
/*!40000 ALTER TABLE `32j_item_taxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_item_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_items`
--

DROP TABLE IF EXISTS `32j_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `sale_price` double(15,4) NOT NULL,
  `purchase_price` double(15,4) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `category_id` int(11) DEFAULT NULL,
  `tax_id` int(11) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_items_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_items`
--

LOCK TABLES `32j_items` WRITE;
/*!40000 ALTER TABLE `32j_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_jobs`
--

DROP TABLE IF EXISTS `32j_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_jobs`
--

LOCK TABLES `32j_jobs` WRITE;
/*!40000 ALTER TABLE `32j_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_media`
--

DROP TABLE IF EXISTS `32j_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL DEFAULT 0,
  `disk` varchar(32) NOT NULL,
  `directory` varchar(191) NOT NULL,
  `filename` varchar(191) NOT NULL,
  `extension` varchar(32) NOT NULL,
  `mime_type` varchar(128) NOT NULL,
  `aggregate_type` varchar(32) NOT NULL,
  `size` int(10) unsigned NOT NULL,
  `variant_name` varchar(255) DEFAULT NULL,
  `original_media_id` int(10) unsigned DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_media_disk_directory_filename_extension_unique` (`disk`,`directory`,`filename`,`extension`),
  UNIQUE KEY `32j_media_disk_directory_filename_extension_deleted_at_unique` (`disk`,`directory`,`filename`,`extension`,`deleted_at`),
  KEY `32j_media_aggregate_type_index` (`aggregate_type`),
  KEY `32j_media_disk_directory_index` (`disk`,`directory`),
  KEY `original_media_id` (`original_media_id`),
  KEY `32j_media_company_id_index` (`company_id`),
  CONSTRAINT `original_media_id` FOREIGN KEY (`original_media_id`) REFERENCES `32j_media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_media`
--

LOCK TABLES `32j_media` WRITE;
/*!40000 ALTER TABLE `32j_media` DISABLE KEYS */;
INSERT INTO `32j_media` VALUES (1,1,'uploads','2023/01/12/1/settings','testlogo','png','image/png','image',5466,NULL,NULL,'::ui','1','2023-01-12 03:06:04','2023-01-12 03:06:04',NULL);
/*!40000 ALTER TABLE `32j_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_mediables`
--

DROP TABLE IF EXISTS `32j_mediables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_mediables` (
  `media_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL DEFAULT 0,
  `mediable_type` varchar(191) NOT NULL,
  `mediable_id` int(10) unsigned NOT NULL,
  `tag` varchar(191) NOT NULL,
  `order` int(10) unsigned NOT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`media_id`,`mediable_type`,`mediable_id`,`tag`),
  KEY `32j_mediables_mediable_id_mediable_type_index` (`mediable_id`,`mediable_type`),
  KEY `32j_mediables_tag_index` (`tag`),
  KEY `32j_mediables_order_index` (`order`),
  KEY `32j_mediables_company_id_index` (`company_id`),
  CONSTRAINT `32j_mediables_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `32j_media` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_mediables`
--

LOCK TABLES `32j_mediables` WRITE;
/*!40000 ALTER TABLE `32j_mediables` DISABLE KEYS */;
INSERT INTO `32j_mediables` VALUES (1,1,'App\\Models\\Common\\Company',1,'company.logo',1,'::ui','1');
/*!40000 ALTER TABLE `32j_mediables` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_migrations`
--

DROP TABLE IF EXISTS `32j_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_migrations`
--

LOCK TABLES `32j_migrations` WRITE;
/*!40000 ALTER TABLE `32j_migrations` DISABLE KEYS */;
INSERT INTO `32j_migrations` VALUES (1,'2016_06_27_000000_create_mediable_tables',1),(2,'2017_09_14_000000_core_v1',1),(3,'2020_01_08_000000_core_v200',1),(4,'2020_03_20_183732_core_v208',1),(5,'2020_06_09_000000_core_v2014',1),(6,'2020_07_20_000000_core_v2017',1),(7,'2020_10_12_000000_add_variants_to_media',1),(8,'2020_10_13_000000_core_v210',1),(9,'2021_04_01_000000_core_v219',1),(10,'2021_05_17_000000_core_v2114',1),(11,'2021_06_17_000000_core_v2117',1),(12,'2021_09_01_000000_core_v2124',1),(13,'2021_09_10_000000_core_v2125',1),(14,'2021_09_10_000000_core_v2126',1),(15,'2021_09_10_000000_core_v2127',1),(16,'2022_03_02_000000_core_v2133',1),(17,'2022_03_23_000000_core_v2134',1);
/*!40000 ALTER TABLE `32j_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_module_histories`
--

DROP TABLE IF EXISTS `32j_module_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_module_histories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `version` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_module_histories_company_id_module_id_index` (`company_id`,`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_module_histories`
--

LOCK TABLES `32j_module_histories` WRITE;
/*!40000 ALTER TABLE `32j_module_histories` DISABLE KEYS */;
INSERT INTO `32j_module_histories` VALUES (1,1,1,'2.0.3','offline-payments installed','::ui',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL),(2,1,2,'2.0.0','paypal-standard installed','::ui',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL);
/*!40000 ALTER TABLE `32j_module_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_modules`
--

DROP TABLE IF EXISTS `32j_modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `alias` varchar(191) NOT NULL,
  `enabled` int(11) NOT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_modules_company_id_alias_deleted_at_unique` (`company_id`,`alias`,`deleted_at`),
  KEY `32j_modules_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_modules`
--

LOCK TABLES `32j_modules` WRITE;
/*!40000 ALTER TABLE `32j_modules` DISABLE KEYS */;
INSERT INTO `32j_modules` VALUES (1,1,'offline-payments',1,'::ui',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL),(2,1,'paypal-standard',1,'::ui',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL);
/*!40000 ALTER TABLE `32j_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_notifications`
--

DROP TABLE IF EXISTS `32j_notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_notifications`
--

LOCK TABLES `32j_notifications` WRITE;
/*!40000 ALTER TABLE `32j_notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_password_resets`
--

DROP TABLE IF EXISTS `32j_password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `32j_password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_password_resets`
--

LOCK TABLES `32j_password_resets` WRITE;
/*!40000 ALTER TABLE `32j_password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_permissions`
--

DROP TABLE IF EXISTS `32j_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `display_name` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_permissions`
--

LOCK TABLES `32j_permissions` WRITE;
/*!40000 ALTER TABLE `32j_permissions` DISABLE KEYS */;
INSERT INTO `32j_permissions` VALUES (1,'read-admin-panel','Read Admin Panel','Read Admin Panel','2023-01-12 03:01:19','2023-01-12 03:01:19'),(2,'read-api','Read Api','Read Api','2023-01-12 03:01:20','2023-01-12 03:01:20'),(3,'create-auth-permissions','Create Auth Permissions','Create Auth Permissions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(4,'read-auth-permissions','Read Auth Permissions','Read Auth Permissions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(5,'update-auth-permissions','Update Auth Permissions','Update Auth Permissions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(6,'delete-auth-permissions','Delete Auth Permissions','Delete Auth Permissions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(7,'read-auth-profile','Read Auth Profile','Read Auth Profile','2023-01-12 03:01:20','2023-01-12 03:01:20'),(8,'update-auth-profile','Update Auth Profile','Update Auth Profile','2023-01-12 03:01:20','2023-01-12 03:01:20'),(9,'create-auth-roles','Create Auth Roles','Create Auth Roles','2023-01-12 03:01:20','2023-01-12 03:01:20'),(10,'read-auth-roles','Read Auth Roles','Read Auth Roles','2023-01-12 03:01:20','2023-01-12 03:01:20'),(11,'update-auth-roles','Update Auth Roles','Update Auth Roles','2023-01-12 03:01:20','2023-01-12 03:01:20'),(12,'delete-auth-roles','Delete Auth Roles','Delete Auth Roles','2023-01-12 03:01:20','2023-01-12 03:01:20'),(13,'create-auth-users','Create Auth Users','Create Auth Users','2023-01-12 03:01:20','2023-01-12 03:01:20'),(14,'read-auth-users','Read Auth Users','Read Auth Users','2023-01-12 03:01:20','2023-01-12 03:01:20'),(15,'update-auth-users','Update Auth Users','Update Auth Users','2023-01-12 03:01:20','2023-01-12 03:01:20'),(16,'delete-auth-users','Delete Auth Users','Delete Auth Users','2023-01-12 03:01:20','2023-01-12 03:01:20'),(17,'create-banking-accounts','Create Banking Accounts','Create Banking Accounts','2023-01-12 03:01:20','2023-01-12 03:01:20'),(18,'read-banking-accounts','Read Banking Accounts','Read Banking Accounts','2023-01-12 03:01:20','2023-01-12 03:01:20'),(19,'update-banking-accounts','Update Banking Accounts','Update Banking Accounts','2023-01-12 03:01:20','2023-01-12 03:01:20'),(20,'delete-banking-accounts','Delete Banking Accounts','Delete Banking Accounts','2023-01-12 03:01:20','2023-01-12 03:01:20'),(21,'create-banking-reconciliations','Create Banking Reconciliations','Create Banking Reconciliations','2023-01-12 03:01:20','2023-01-12 03:01:20'),(22,'read-banking-reconciliations','Read Banking Reconciliations','Read Banking Reconciliations','2023-01-12 03:01:20','2023-01-12 03:01:20'),(23,'update-banking-reconciliations','Update Banking Reconciliations','Update Banking Reconciliations','2023-01-12 03:01:20','2023-01-12 03:01:20'),(24,'delete-banking-reconciliations','Delete Banking Reconciliations','Delete Banking Reconciliations','2023-01-12 03:01:20','2023-01-12 03:01:20'),(25,'create-banking-transactions','Create Banking Transactions','Create Banking Transactions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(26,'read-banking-transactions','Read Banking Transactions','Read Banking Transactions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(27,'update-banking-transactions','Update Banking Transactions','Update Banking Transactions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(28,'delete-banking-transactions','Delete Banking Transactions','Delete Banking Transactions','2023-01-12 03:01:20','2023-01-12 03:01:20'),(29,'create-banking-transfers','Create Banking Transfers','Create Banking Transfers','2023-01-12 03:01:20','2023-01-12 03:01:20'),(30,'read-banking-transfers','Read Banking Transfers','Read Banking Transfers','2023-01-12 03:01:20','2023-01-12 03:01:20'),(31,'update-banking-transfers','Update Banking Transfers','Update Banking Transfers','2023-01-12 03:01:20','2023-01-12 03:01:20'),(32,'delete-banking-transfers','Delete Banking Transfers','Delete Banking Transfers','2023-01-12 03:01:20','2023-01-12 03:01:20'),(33,'create-common-companies','Create Common Companies','Create Common Companies','2023-01-12 03:01:20','2023-01-12 03:01:20'),(34,'read-common-companies','Read Common Companies','Read Common Companies','2023-01-12 03:01:20','2023-01-12 03:01:20'),(35,'update-common-companies','Update Common Companies','Update Common Companies','2023-01-12 03:01:20','2023-01-12 03:01:20'),(36,'delete-common-companies','Delete Common Companies','Delete Common Companies','2023-01-12 03:01:20','2023-01-12 03:01:20'),(37,'create-common-dashboards','Create Common Dashboards','Create Common Dashboards','2023-01-12 03:01:20','2023-01-12 03:01:20'),(38,'read-common-dashboards','Read Common Dashboards','Read Common Dashboards','2023-01-12 03:01:20','2023-01-12 03:01:20'),(39,'update-common-dashboards','Update Common Dashboards','Update Common Dashboards','2023-01-12 03:01:20','2023-01-12 03:01:20'),(40,'delete-common-dashboards','Delete Common Dashboards','Delete Common Dashboards','2023-01-12 03:01:21','2023-01-12 03:01:21'),(41,'create-common-import','Create Common Import','Create Common Import','2023-01-12 03:01:21','2023-01-12 03:01:21'),(42,'create-common-items','Create Common Items','Create Common Items','2023-01-12 03:01:21','2023-01-12 03:01:21'),(43,'read-common-items','Read Common Items','Read Common Items','2023-01-12 03:01:21','2023-01-12 03:01:21'),(44,'update-common-items','Update Common Items','Update Common Items','2023-01-12 03:01:21','2023-01-12 03:01:21'),(45,'delete-common-items','Delete Common Items','Delete Common Items','2023-01-12 03:01:21','2023-01-12 03:01:21'),(46,'create-common-notifications','Create Common Notifications','Create Common Notifications','2023-01-12 03:01:21','2023-01-12 03:01:21'),(47,'read-common-notifications','Read Common Notifications','Read Common Notifications','2023-01-12 03:01:21','2023-01-12 03:01:21'),(48,'update-common-notifications','Update Common Notifications','Update Common Notifications','2023-01-12 03:01:21','2023-01-12 03:01:21'),(49,'delete-common-notifications','Delete Common Notifications','Delete Common Notifications','2023-01-12 03:01:21','2023-01-12 03:01:21'),(50,'create-common-reports','Create Common Reports','Create Common Reports','2023-01-12 03:01:21','2023-01-12 03:01:21'),(51,'read-common-reports','Read Common Reports','Read Common Reports','2023-01-12 03:01:21','2023-01-12 03:01:21'),(52,'update-common-reports','Update Common Reports','Update Common Reports','2023-01-12 03:01:21','2023-01-12 03:01:21'),(53,'delete-common-reports','Delete Common Reports','Delete Common Reports','2023-01-12 03:01:21','2023-01-12 03:01:21'),(54,'read-common-search','Read Common Search','Read Common Search','2023-01-12 03:01:21','2023-01-12 03:01:21'),(55,'read-common-uploads','Read Common Uploads','Read Common Uploads','2023-01-12 03:01:21','2023-01-12 03:01:21'),(56,'delete-common-uploads','Delete Common Uploads','Delete Common Uploads','2023-01-12 03:01:21','2023-01-12 03:01:21'),(57,'create-common-widgets','Create Common Widgets','Create Common Widgets','2023-01-12 03:01:21','2023-01-12 03:01:21'),(58,'read-common-widgets','Read Common Widgets','Read Common Widgets','2023-01-12 03:01:21','2023-01-12 03:01:21'),(59,'update-common-widgets','Update Common Widgets','Update Common Widgets','2023-01-12 03:01:21','2023-01-12 03:01:21'),(60,'delete-common-widgets','Delete Common Widgets','Delete Common Widgets','2023-01-12 03:01:21','2023-01-12 03:01:21'),(61,'create-purchases-bills','Create Purchases Bills','Create Purchases Bills','2023-01-12 03:01:21','2023-01-12 03:01:21'),(62,'read-purchases-bills','Read Purchases Bills','Read Purchases Bills','2023-01-12 03:01:21','2023-01-12 03:01:21'),(63,'update-purchases-bills','Update Purchases Bills','Update Purchases Bills','2023-01-12 03:01:21','2023-01-12 03:01:21'),(64,'delete-purchases-bills','Delete Purchases Bills','Delete Purchases Bills','2023-01-12 03:01:21','2023-01-12 03:01:21'),(65,'create-purchases-payments','Create Purchases Payments','Create Purchases Payments','2023-01-12 03:01:21','2023-01-12 03:01:21'),(66,'read-purchases-payments','Read Purchases Payments','Read Purchases Payments','2023-01-12 03:01:21','2023-01-12 03:01:21'),(67,'update-purchases-payments','Update Purchases Payments','Update Purchases Payments','2023-01-12 03:01:21','2023-01-12 03:01:21'),(68,'delete-purchases-payments','Delete Purchases Payments','Delete Purchases Payments','2023-01-12 03:01:21','2023-01-12 03:01:21'),(69,'create-purchases-vendors','Create Purchases Vendors','Create Purchases Vendors','2023-01-12 03:01:22','2023-01-12 03:01:22'),(70,'read-purchases-vendors','Read Purchases Vendors','Read Purchases Vendors','2023-01-12 03:01:22','2023-01-12 03:01:22'),(71,'update-purchases-vendors','Update Purchases Vendors','Update Purchases Vendors','2023-01-12 03:01:22','2023-01-12 03:01:22'),(72,'delete-purchases-vendors','Delete Purchases Vendors','Delete Purchases Vendors','2023-01-12 03:01:22','2023-01-12 03:01:22'),(73,'create-sales-customers','Create Sales Customers','Create Sales Customers','2023-01-12 03:01:22','2023-01-12 03:01:22'),(74,'read-sales-customers','Read Sales Customers','Read Sales Customers','2023-01-12 03:01:22','2023-01-12 03:01:22'),(75,'update-sales-customers','Update Sales Customers','Update Sales Customers','2023-01-12 03:01:22','2023-01-12 03:01:22'),(76,'delete-sales-customers','Delete Sales Customers','Delete Sales Customers','2023-01-12 03:01:22','2023-01-12 03:01:22'),(77,'create-sales-invoices','Create Sales Invoices','Create Sales Invoices','2023-01-12 03:01:22','2023-01-12 03:01:22'),(78,'read-sales-invoices','Read Sales Invoices','Read Sales Invoices','2023-01-12 03:01:22','2023-01-12 03:01:22'),(79,'update-sales-invoices','Update Sales Invoices','Update Sales Invoices','2023-01-12 03:01:22','2023-01-12 03:01:22'),(80,'delete-sales-invoices','Delete Sales Invoices','Delete Sales Invoices','2023-01-12 03:01:22','2023-01-12 03:01:22'),(81,'create-sales-revenues','Create Sales Revenues','Create Sales Revenues','2023-01-12 03:01:22','2023-01-12 03:01:22'),(82,'read-sales-revenues','Read Sales Revenues','Read Sales Revenues','2023-01-12 03:01:22','2023-01-12 03:01:22'),(83,'update-sales-revenues','Update Sales Revenues','Update Sales Revenues','2023-01-12 03:01:22','2023-01-12 03:01:22'),(84,'delete-sales-revenues','Delete Sales Revenues','Delete Sales Revenues','2023-01-12 03:01:22','2023-01-12 03:01:22'),(85,'read-install-updates','Read Install Updates','Read Install Updates','2023-01-12 03:01:22','2023-01-12 03:01:22'),(86,'update-install-updates','Update Install Updates','Update Install Updates','2023-01-12 03:01:22','2023-01-12 03:01:22'),(87,'create-modules-api-key','Create Modules Api Key','Create Modules Api Key','2023-01-12 03:01:22','2023-01-12 03:01:22'),(88,'update-modules-api-key','Update Modules Api Key','Update Modules Api Key','2023-01-12 03:01:23','2023-01-12 03:01:23'),(89,'read-modules-home','Read Modules Home','Read Modules Home','2023-01-12 03:01:23','2023-01-12 03:01:23'),(90,'create-modules-item','Create Modules Item','Create Modules Item','2023-01-12 03:01:23','2023-01-12 03:01:23'),(91,'read-modules-item','Read Modules Item','Read Modules Item','2023-01-12 03:01:23','2023-01-12 03:01:23'),(92,'update-modules-item','Update Modules Item','Update Modules Item','2023-01-12 03:01:23','2023-01-12 03:01:23'),(93,'delete-modules-item','Delete Modules Item','Delete Modules Item','2023-01-12 03:01:23','2023-01-12 03:01:23'),(94,'read-modules-my','Read Modules My','Read Modules My','2023-01-12 03:01:23','2023-01-12 03:01:23'),(95,'read-modules-tiles','Read Modules Tiles','Read Modules Tiles','2023-01-12 03:01:23','2023-01-12 03:01:23'),(96,'read-notifications','Read Notifications','Read Notifications','2023-01-12 03:01:23','2023-01-12 03:01:23'),(97,'update-notifications','Update Notifications','Update Notifications','2023-01-12 03:01:23','2023-01-12 03:01:23'),(98,'read-reports-expense-summary','Read Reports Expense Summary','Read Reports Expense Summary','2023-01-12 03:01:23','2023-01-12 03:01:23'),(99,'read-reports-income-summary','Read Reports Income Summary','Read Reports Income Summary','2023-01-12 03:01:23','2023-01-12 03:01:23'),(100,'read-reports-income-expense-summary','Read Reports Income Expense Summary','Read Reports Income Expense Summary','2023-01-12 03:01:23','2023-01-12 03:01:23'),(101,'read-reports-profit-loss','Read Reports Profit Loss','Read Reports Profit Loss','2023-01-12 03:01:23','2023-01-12 03:01:23'),(102,'read-reports-tax-summary','Read Reports Tax Summary','Read Reports Tax Summary','2023-01-12 03:01:23','2023-01-12 03:01:23'),(103,'create-settings-categories','Create Settings Categories','Create Settings Categories','2023-01-12 03:01:23','2023-01-12 03:01:23'),(104,'read-settings-categories','Read Settings Categories','Read Settings Categories','2023-01-12 03:01:23','2023-01-12 03:01:23'),(105,'update-settings-categories','Update Settings Categories','Update Settings Categories','2023-01-12 03:01:23','2023-01-12 03:01:23'),(106,'delete-settings-categories','Delete Settings Categories','Delete Settings Categories','2023-01-12 03:01:23','2023-01-12 03:01:23'),(107,'read-settings-company','Read Settings Company','Read Settings Company','2023-01-12 03:01:23','2023-01-12 03:01:23'),(108,'create-settings-currencies','Create Settings Currencies','Create Settings Currencies','2023-01-12 03:01:23','2023-01-12 03:01:23'),(109,'read-settings-currencies','Read Settings Currencies','Read Settings Currencies','2023-01-12 03:01:24','2023-01-12 03:01:24'),(110,'update-settings-currencies','Update Settings Currencies','Update Settings Currencies','2023-01-12 03:01:24','2023-01-12 03:01:24'),(111,'delete-settings-currencies','Delete Settings Currencies','Delete Settings Currencies','2023-01-12 03:01:24','2023-01-12 03:01:24'),(112,'read-settings-defaults','Read Settings Defaults','Read Settings Defaults','2023-01-12 03:01:24','2023-01-12 03:01:24'),(113,'read-settings-email','Read Settings Email','Read Settings Email','2023-01-12 03:01:24','2023-01-12 03:01:24'),(114,'read-settings-invoice','Read Settings Invoice','Read Settings Invoice','2023-01-12 03:01:24','2023-01-12 03:01:24'),(115,'read-settings-localisation','Read Settings Localisation','Read Settings Localisation','2023-01-12 03:01:24','2023-01-12 03:01:24'),(116,'read-settings-modules','Read Settings Modules','Read Settings Modules','2023-01-12 03:01:24','2023-01-12 03:01:24'),(117,'update-settings-modules','Update Settings Modules','Update Settings Modules','2023-01-12 03:01:24','2023-01-12 03:01:24'),(118,'read-settings-settings','Read Settings Settings','Read Settings Settings','2023-01-12 03:01:24','2023-01-12 03:01:24'),(119,'update-settings-settings','Update Settings Settings','Update Settings Settings','2023-01-12 03:01:24','2023-01-12 03:01:24'),(120,'read-settings-schedule','Read Settings Schedule','Read Settings Schedule','2023-01-12 03:01:24','2023-01-12 03:01:24'),(121,'create-settings-taxes','Create Settings Taxes','Create Settings Taxes','2023-01-12 03:01:24','2023-01-12 03:01:24'),(122,'read-settings-taxes','Read Settings Taxes','Read Settings Taxes','2023-01-12 03:01:24','2023-01-12 03:01:24'),(123,'update-settings-taxes','Update Settings Taxes','Update Settings Taxes','2023-01-12 03:01:24','2023-01-12 03:01:24'),(124,'delete-settings-taxes','Delete Settings Taxes','Delete Settings Taxes','2023-01-12 03:01:24','2023-01-12 03:01:24'),(125,'read-widgets-account-balance','Read Widgets Account Balance','Read Widgets Account Balance','2023-01-12 03:01:25','2023-01-12 03:01:25'),(126,'read-widgets-cash-flow','Read Widgets Cash Flow','Read Widgets Cash Flow','2023-01-12 03:01:25','2023-01-12 03:01:25'),(127,'read-widgets-expenses-by-category','Read Widgets Expenses By Category','Read Widgets Expenses By Category','2023-01-12 03:01:25','2023-01-12 03:01:25'),(128,'read-widgets-income-by-category','Read Widgets Income By Category','Read Widgets Income By Category','2023-01-12 03:01:25','2023-01-12 03:01:25'),(129,'read-widgets-latest-expenses','Read Widgets Latest Expenses','Read Widgets Latest Expenses','2023-01-12 03:01:25','2023-01-12 03:01:25'),(130,'read-widgets-latest-income','Read Widgets Latest Income','Read Widgets Latest Income','2023-01-12 03:01:25','2023-01-12 03:01:25'),(131,'read-widgets-total-expenses','Read Widgets Total Expenses','Read Widgets Total Expenses','2023-01-12 03:01:25','2023-01-12 03:01:25'),(132,'read-widgets-total-income','Read Widgets Total Income','Read Widgets Total Income','2023-01-12 03:01:25','2023-01-12 03:01:25'),(133,'read-widgets-total-profit','Read Widgets Total Profit','Read Widgets Total Profit','2023-01-12 03:01:25','2023-01-12 03:01:25'),(134,'read-widgets-currencies','Read Widgets Currencies','Read Widgets Currencies','2023-01-12 03:01:25','2023-01-12 03:01:25'),(135,'read-client-portal','Read Client Portal','Read Client Portal','2023-01-12 03:01:29','2023-01-12 03:01:29'),(136,'read-portal-invoices','Read Portal Invoices','Read Portal Invoices','2023-01-12 03:01:29','2023-01-12 03:01:29'),(137,'update-portal-invoices','Update Portal Invoices','Update Portal Invoices','2023-01-12 03:01:29','2023-01-12 03:01:29'),(138,'read-portal-payments','Read Portal Payments','Read Portal Payments','2023-01-12 03:01:29','2023-01-12 03:01:29'),(139,'update-portal-payments','Update Portal Payments','Update Portal Payments','2023-01-12 03:01:29','2023-01-12 03:01:29'),(140,'read-portal-profile','Read Portal Profile','Read Portal Profile','2023-01-12 03:01:29','2023-01-12 03:01:29'),(141,'update-portal-profile','Update Portal Profile','Update Portal Profile','2023-01-12 03:01:29','2023-01-12 03:01:29'),(142,'read-offline-payments-settings','Read Offline Payments Settings','Read Offline Payments Settings','2023-01-12 03:03:19','2023-01-12 03:03:19'),(143,'update-offline-payments-settings','Update Offline Payments Settings','Update Offline Payments Settings','2023-01-12 03:03:19','2023-01-12 03:03:19'),(144,'delete-offline-payments-settings','Delete Offline Payments Settings','Delete Offline Payments Settings','2023-01-12 03:03:19','2023-01-12 03:03:19'),(145,'read-paypal-standard-settings','Read PayPal Standard Settings','Read PayPal Standard Settings','2023-01-12 03:03:19','2023-01-12 03:03:19'),(146,'update-paypal-standard-settings','Update PayPal Standard Settings','Update PayPal Standard Settings','2023-01-12 03:03:19','2023-01-12 03:03:19');
/*!40000 ALTER TABLE `32j_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_reconciliations`
--

DROP TABLE IF EXISTS `32j_reconciliations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_reconciliations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `started_at` datetime NOT NULL,
  `ended_at` datetime NOT NULL,
  `closing_balance` double(15,4) NOT NULL DEFAULT 0.0000,
  `reconciled` tinyint(1) NOT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_reconciliations_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_reconciliations`
--

LOCK TABLES `32j_reconciliations` WRITE;
/*!40000 ALTER TABLE `32j_reconciliations` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_reconciliations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_recurring`
--

DROP TABLE IF EXISTS `32j_recurring`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_recurring` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `recurable_type` varchar(191) NOT NULL,
  `recurable_id` bigint(20) unsigned NOT NULL,
  `frequency` varchar(191) NOT NULL,
  `interval` int(11) NOT NULL DEFAULT 1,
  `started_at` datetime NOT NULL,
  `count` int(11) NOT NULL DEFAULT 0,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_recurring_recurable_type_recurable_id_index` (`recurable_type`,`recurable_id`),
  KEY `32j_recurring_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_recurring`
--

LOCK TABLES `32j_recurring` WRITE;
/*!40000 ALTER TABLE `32j_recurring` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_recurring` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_reports`
--

DROP TABLE IF EXISTS `32j_reports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `class` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `settings` text DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_reports_company_id_index` (`company_id`),
  KEY `32j_reports_class_index` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_reports`
--

LOCK TABLES `32j_reports` WRITE;
/*!40000 ALTER TABLE `32j_reports` DISABLE KEYS */;
INSERT INTO `32j_reports` VALUES (1,1,'App\\Reports\\IncomeSummary','Income Summary','Monthly income summary by category.','{\"group\":\"category\",\"period\":\"monthly\",\"basis\":\"accrual\",\"chart\":\"line\"}','core::seed',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL),(2,1,'App\\Reports\\ExpenseSummary','Expense Summary','Monthly expense summary by category.','{\"group\":\"category\",\"period\":\"monthly\",\"basis\":\"accrual\",\"chart\":\"line\"}','core::seed',NULL,'2023-01-12 03:03:19','2023-01-12 03:03:19',NULL),(3,1,'App\\Reports\\IncomeExpenseSummary','Income vs Expense','Monthly income vs expense by category.','{\"group\":\"category\",\"period\":\"monthly\",\"basis\":\"accrual\",\"chart\":\"line\"}','core::seed',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(4,1,'App\\Reports\\ProfitLoss','Profit & Loss','Quarterly profit & loss by category.','{\"group\":\"category\",\"period\":\"quarterly\",\"basis\":\"accrual\"}','core::seed',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(5,1,'App\\Reports\\TaxSummary','Tax Summary','Quarterly tax summary.','{\"period\":\"quarterly\",\"basis\":\"accrual\"}','core::seed',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL);
/*!40000 ALTER TABLE `32j_reports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_role_permissions`
--

DROP TABLE IF EXISTS `32j_role_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_role_permissions` (
  `role_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`permission_id`),
  KEY `32j_role_permissions_permission_id_foreign` (`permission_id`),
  CONSTRAINT `32j_role_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `32j_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `32j_role_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `32j_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_role_permissions`
--

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

--
-- Table structure for table `32j_roles`
--

DROP TABLE IF EXISTS `32j_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `display_name` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_roles`
--

LOCK TABLES `32j_roles` WRITE;
/*!40000 ALTER TABLE `32j_roles` DISABLE KEYS */;
INSERT INTO `32j_roles` VALUES (1,'admin','Admin','Admin',NULL,NULL,'2023-01-12 03:01:19','2023-01-12 03:01:19'),(2,'manager','Manager','Manager',NULL,NULL,'2023-01-12 03:01:25','2023-01-12 03:01:25'),(3,'customer','Customer','Customer',NULL,NULL,'2023-01-12 03:01:29','2023-01-12 03:01:29');
/*!40000 ALTER TABLE `32j_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_sessions`
--

DROP TABLE IF EXISTS `32j_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_sessions` (
  `id` varchar(191) NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL,
  UNIQUE KEY `32j_sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_sessions`
--

LOCK TABLES `32j_sessions` WRITE;
/*!40000 ALTER TABLE `32j_sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_settings`
--

DROP TABLE IF EXISTS `32j_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `key` varchar(191) NOT NULL,
  `value` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_settings_company_id_key_unique` (`company_id`,`key`),
  KEY `32j_settings_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_settings`
--

LOCK TABLES `32j_settings` WRITE;
/*!40000 ALTER TABLE `32j_settings` DISABLE KEYS */;
INSERT INTO `32j_settings` VALUES (1,1,'invoice.title','Invoice',NULL),(2,1,'default.account','1',NULL),(3,1,'default.income_category','2',NULL),(4,1,'default.expense_category','4',NULL),(5,1,'wizard.completed','1',NULL),(6,1,'offline-payments.methods','[{\"code\":\"offline-payments.cash.1\",\"name\":\"Cash\",\"customer\":\"0\",\"order\":\"1\",\"description\":null},{\"code\":\"offline-payments.bank_transfer.2\",\"name\":\"Bank Transfer\",\"customer\":\"0\",\"order\":\"2\",\"description\":null}]',NULL),(7,1,'company.name','Phraphay Dot Com',NULL),(8,1,'company.email','info@phraphay.com',NULL),(9,1,'company.tax_number','10000000001',NULL),(10,1,'company.address','1 Silom Road, Bangrak, Bangkok',NULL),(11,1,'company.country','TH',NULL),(12,1,'company.logo','1',NULL);
/*!40000 ALTER TABLE `32j_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_taxes`
--

DROP TABLE IF EXISTS `32j_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `rate` double(15,4) NOT NULL,
  `type` varchar(191) NOT NULL DEFAULT 'normal',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_taxes_company_id_index` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_taxes`
--

LOCK TABLES `32j_taxes` WRITE;
/*!40000 ALTER TABLE `32j_taxes` DISABLE KEYS */;
INSERT INTO `32j_taxes` VALUES (1,1,'VAT',7.0000,'normal',1,'core::ui',1,'2023-01-12 03:07:06','2023-01-12 03:07:06',NULL),(2,1,'VAT',7.0000,'normal',1,'core::ui',1,'2023-01-12 03:07:08','2023-01-12 03:07:08',NULL);
/*!40000 ALTER TABLE `32j_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_transactions`
--

DROP TABLE IF EXISTS `32j_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_transactions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `type` varchar(191) NOT NULL,
  `paid_at` datetime NOT NULL,
  `amount` double(15,4) NOT NULL,
  `currency_code` varchar(191) NOT NULL,
  `currency_rate` double(15,8) NOT NULL,
  `account_id` int(11) NOT NULL,
  `document_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `description` text DEFAULT NULL,
  `payment_method` varchar(191) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `reconciled` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_transactions_company_id_type_index` (`company_id`,`type`),
  KEY `32j_transactions_account_id_index` (`account_id`),
  KEY `32j_transactions_category_id_index` (`category_id`),
  KEY `32j_transactions_contact_id_index` (`contact_id`),
  KEY `32j_transactions_document_id_index` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_transactions`
--

LOCK TABLES `32j_transactions` WRITE;
/*!40000 ALTER TABLE `32j_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_transfers`
--

DROP TABLE IF EXISTS `32j_transfers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_transfers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `expense_transaction_id` int(11) NOT NULL,
  `income_transaction_id` int(11) NOT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_transfers_company_id_index` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_transfers`
--

LOCK TABLES `32j_transfers` WRITE;
/*!40000 ALTER TABLE `32j_transfers` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_transfers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_user_companies`
--

DROP TABLE IF EXISTS `32j_user_companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_user_companies` (
  `user_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_user_companies`
--

LOCK TABLES `32j_user_companies` WRITE;
/*!40000 ALTER TABLE `32j_user_companies` DISABLE KEYS */;
INSERT INTO `32j_user_companies` VALUES (1,1);
/*!40000 ALTER TABLE `32j_user_companies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_user_dashboards`
--

DROP TABLE IF EXISTS `32j_user_dashboards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_user_dashboards` (
  `user_id` int(10) unsigned NOT NULL,
  `dashboard_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`dashboard_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_user_dashboards`
--

LOCK TABLES `32j_user_dashboards` WRITE;
/*!40000 ALTER TABLE `32j_user_dashboards` DISABLE KEYS */;
INSERT INTO `32j_user_dashboards` VALUES (1,1);
/*!40000 ALTER TABLE `32j_user_dashboards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_user_permissions`
--

DROP TABLE IF EXISTS `32j_user_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_user_permissions` (
  `user_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  `user_type` varchar(191) NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  KEY `32j_user_permissions_permission_id_foreign` (`permission_id`),
  CONSTRAINT `32j_user_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `32j_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_user_permissions`
--

LOCK TABLES `32j_user_permissions` WRITE;
/*!40000 ALTER TABLE `32j_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `32j_user_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_user_roles`
--

DROP TABLE IF EXISTS `32j_user_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_user_roles` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `user_type` varchar(191) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `32j_user_roles_role_id_foreign` (`role_id`),
  CONSTRAINT `32j_user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `32j_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_user_roles`
--

LOCK TABLES `32j_user_roles` WRITE;
/*!40000 ALTER TABLE `32j_user_roles` DISABLE KEYS */;
INSERT INTO `32j_user_roles` VALUES (1,1,'users');
/*!40000 ALTER TABLE `32j_user_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_users`
--

DROP TABLE IF EXISTS `32j_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `last_logged_in_at` timestamp NULL DEFAULT NULL,
  `locale` varchar(191) NOT NULL DEFAULT 'en-GB',
  `landing_page` varchar(70) DEFAULT 'dashboard',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `32j_users_email_deleted_at_unique` (`email`,`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_users`
--

LOCK TABLES `32j_users` WRITE;
/*!40000 ALTER TABLE `32j_users` DISABLE KEYS */;
INSERT INTO `32j_users` VALUES (1,'','admin@phraphay.com','$2y$10$34VVlSUJPV/c9MfjLVME/.YMTzsEb9XxZ8iKgoBcw4At/WSMg8Wxa','nvqOQqmmDW9GXGPFx1AJsupcmtCr2132U56UIO1s0qlucaxLPzYcgSMiV9Rt','2023-10-24 23:59:26','en-GB','dashboard',1,'core::ui',NULL,'2023-01-12 03:03:20','2023-10-24 23:59:26',NULL);
/*!40000 ALTER TABLE `32j_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `32j_widgets`
--

DROP TABLE IF EXISTS `32j_widgets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `32j_widgets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL,
  `dashboard_id` int(11) NOT NULL,
  `class` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT 0,
  `settings` text DEFAULT NULL,
  `created_from` varchar(100) DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `32j_widgets_company_id_dashboard_id_index` (`company_id`,`dashboard_id`),
  KEY `32j_widgets_class_index` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `32j_widgets`
--

LOCK TABLES `32j_widgets` WRITE;
/*!40000 ALTER TABLE `32j_widgets` DISABLE KEYS */;
INSERT INTO `32j_widgets` VALUES (1,1,1,'App\\Widgets\\TotalIncome','Total Income',1,'{\"width\":\"col-md-4\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(2,1,1,'App\\Widgets\\TotalExpenses','Total Expenses',2,'{\"width\":\"col-md-4\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(3,1,1,'App\\Widgets\\TotalProfit','Total Profit',3,'{\"width\":\"col-md-4\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(4,1,1,'App\\Widgets\\CashFlow','Cash Flow',4,'{\"width\":\"col-md-12\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(5,1,1,'App\\Widgets\\IncomeByCategory','Income By Category',5,'{\"width\":\"col-md-6\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(6,1,1,'App\\Widgets\\ExpensesByCategory','Expenses By Category',6,'{\"width\":\"col-md-6\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(7,1,1,'App\\Widgets\\AccountBalance','Account Balance',7,'{\"width\":\"col-md-4\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(8,1,1,'App\\Widgets\\LatestIncome','Latest Income',8,'{\"width\":\"col-md-4\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL),(9,1,1,'App\\Widgets\\LatestExpenses','Latest Expenses',9,'{\"width\":\"col-md-4\"}','core::ui',NULL,'2023-01-12 03:03:20','2023-01-12 03:03:20',NULL);
/*!40000 ALTER TABLE `32j_widgets` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-22 16:54:17

📁 Sid Gifari File Manager