/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_newinvoicesaas
-- ------------------------------------------------------
-- Server version	10.11.16-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 */;

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account_name` varchar(50) NOT NULL,
  `opening_date` date NOT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `currency` varchar(3) NOT NULL,
  `opening_balance` decimal(28,8) NOT NULL,
  `description` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `accounts_user_id_foreign` (`user_id`),
  KEY `accounts_business_id_foreign` (`business_id`),
  CONSTRAINT `accounts_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accounts`
--

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

--
-- Table structure for table `affiliate_payout_methods`
--

DROP TABLE IF EXISTS `affiliate_payout_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `affiliate_payout_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `parameters` text DEFAULT NULL,
  `fixed_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `charge_in_percentage` decimal(10,2) NOT NULL DEFAULT 0.00,
  `instructions` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `affiliate_payout_methods`
--

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

--
-- Table structure for table `attendance`
--

DROP TABLE IF EXISTS `attendance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attendance` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `status` tinyint(4) NOT NULL COMMENT '0 = Absent | 1 = Present | 2 = Leave',
  `leave_type` varchar(50) DEFAULT NULL,
  `leave_duration` varchar(20) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attendance_employee_id_date_user_id_business_id_unique` (`employee_id`,`date`,`user_id`,`business_id`),
  KEY `attendance_user_id_foreign` (`user_id`),
  KEY `attendance_business_id_foreign` (`business_id`),
  CONSTRAINT `attendance_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attendance_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attendance_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attendance`
--

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

--
-- Table structure for table `awards`
--

DROP TABLE IF EXISTS `awards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `awards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `award_date` date NOT NULL,
  `award_name` varchar(191) NOT NULL,
  `award` varchar(191) NOT NULL,
  `details` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `awards_employee_id_foreign` (`employee_id`),
  KEY `awards_user_id_foreign` (`user_id`),
  KEY `awards_business_id_foreign` (`business_id`),
  CONSTRAINT `awards_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `awards_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `awards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `awards`
--

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

--
-- Table structure for table `brands`
--

DROP TABLE IF EXISTS `brands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `brands` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `logo` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brands`
--

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

--
-- Table structure for table `business`
--

DROP TABLE IF EXISTS `business`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `business` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `reg_no` varchar(191) DEFAULT NULL,
  `vat_id` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_type_id` bigint(20) unsigned DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `country` varchar(50) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `address` text DEFAULT NULL,
  `logo` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `default` tinyint(4) NOT NULL DEFAULT 0,
  `custom_fields` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_user_id_foreign` (`user_id`),
  KEY `business_business_type_id_foreign` (`business_type_id`),
  CONSTRAINT `business_business_type_id_foreign` FOREIGN KEY (`business_type_id`) REFERENCES `business_types` (`id`) ON DELETE SET NULL,
  CONSTRAINT `business_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business`
--

LOCK TABLES `business` WRITE;
/*!40000 ALTER TABLE `business` DISABLE KEYS */;
INSERT INTO `business` VALUES
(1,'Enrich-Accounts',NULL,NULL,2,2,NULL,NULL,'Bangladesh','BDT',NULL,'1725863847logo1.png.png',1,0,NULL,'2024-09-09 06:29:11','2024-09-09 06:37:27');
/*!40000 ALTER TABLE `business` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `business_settings`
--

DROP TABLE IF EXISTS `business_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `business_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `value` text DEFAULT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_settings_business_id_foreign` (`business_id`),
  CONSTRAINT `business_settings_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business_settings`
--

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

--
-- Table structure for table `business_types`
--

DROP TABLE IF EXISTS `business_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `business_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business_types`
--

LOCK TABLES `business_types` WRITE;
/*!40000 ALTER TABLE `business_types` DISABLE KEYS */;
INSERT INTO `business_types` VALUES
(1,'Others',1,'2024-09-09 06:29:11','2024-09-09 06:29:11'),
(2,'Software',1,'2024-09-09 06:31:42','2024-09-09 06:31:42');
/*!40000 ALTER TABLE `business_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `business_users`
--

DROP TABLE IF EXISTS `business_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `business_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `owner_id` bigint(20) unsigned NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_users_user_id_foreign` (`user_id`),
  KEY `business_users_business_id_foreign` (`business_id`),
  KEY `business_users_role_id_foreign` (`role_id`),
  CONSTRAINT `business_users_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `business_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `business_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business_users`
--

LOCK TABLES `business_users` WRITE;
/*!40000 ALTER TABLE `business_users` DISABLE KEYS */;
INSERT INTO `business_users` VALUES
(1,1,2,NULL,2,1,'2024-09-09 06:29:11','2024-09-09 06:29:11');
/*!40000 ALTER TABLE `business_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_messages`
--

DROP TABLE IF EXISTS `contact_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = unread | 1 = read',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact_messages`
--

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

--
-- Table structure for table `currency`
--

DROP TABLE IF EXISTS `currency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `currency` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(3) NOT NULL,
  `exchange_rate` decimal(10,6) NOT NULL,
  `base_currency` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currency`
--

LOCK TABLES `currency` WRITE;
/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
INSERT INTO `currency` VALUES
(1,'AED',3.672504,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(2,'AFN',87.000368,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(3,'ALL',101.280403,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(4,'AMD',386.350403,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(5,'ANG',1.802185,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(6,'AOA',509.000367,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(7,'ARS',222.340722,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(8,'AUD',1.479050,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(9,'AWG',1.802500,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(10,'AZN',1.703970,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(11,'BAM',1.773984,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(12,'BBD',2.019075,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(13,'BDT',106.485744,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(14,'BGN',1.777044,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(15,'BHD',0.376968,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(16,'BIF',2088.000000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(17,'BMD',1.000000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(18,'BND',1.324450,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(19,'BOB',6.908811,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(20,'BRL',4.953104,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(21,'BSD',1.000014,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(22,'BTC',0.000035,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(23,'BTN',81.675283,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(24,'BWP',13.210097,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(25,'BYN',2.524093,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(26,'BYR',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(27,'BZD',2.015692,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(28,'CAD',1.347550,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(29,'CDF',2045.726604,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(30,'CHF',0.897381,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(31,'CLF',0.028776,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(32,'CLP',794.030396,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(33,'CNY',6.910604,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(34,'COP',4527.050000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(35,'CRC',542.601914,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(36,'CUC',1.000000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(37,'CUP',26.500000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(38,'CVE',100.350394,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(39,'CZK',21.224040,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(40,'DJF',177.720394,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(41,'DKK',6.762204,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(42,'DOP',54.420393,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(43,'DZD',135.223014,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(44,'EGP',30.271596,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(45,'ERN',15.000000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(46,'ETB',54.210392,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(47,'EUR',0.892040,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(48,'FJD',2.201250,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(49,'FKP',0.790702,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(50,'GBP',0.791202,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(51,'GEL',2.485040,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(52,'GGP',0.790702,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(53,'GHS',11.803858,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(54,'GIP',0.790702,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(55,'GMD',60.203853,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(56,'GNF',8655.000355,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(57,'GTQ',7.805024,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(58,'GYD',211.492063,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(59,'HKD',7.849950,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(60,'HNL',24.660389,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(61,'HRK',6.816133,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(62,'HTG',150.495696,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(63,'HUF',337.560388,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(64,'IDR',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(65,'ILS',3.636190,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(66,'IMP',0.790702,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(67,'INR',81.729750,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(68,'IQD',1310.000000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(69,'IRR',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(70,'ISK',136.203816,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(71,'JEP',0.790702,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(72,'JMD',153.978721,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(73,'JOD',0.709504,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(74,'JPY',134.835040,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(75,'KES',136.503804,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(76,'KGS',87.306040,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(77,'KHR',4128.000351,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(78,'KMF',446.950384,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(79,'KPW',899.911942,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(80,'KRW',1317.955039,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(81,'KWD',0.306320,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(82,'KYD',0.833386,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(83,'KZT',443.260256,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(84,'LAK',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(85,'LBP',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(86,'LKR',320.021043,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(87,'LRD',165.903775,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(88,'LSL',18.410382,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(89,'LTL',2.952740,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(90,'LVL',0.604890,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(91,'LYD',4.745039,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(92,'MAD',9.992039,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(93,'MDL',17.839456,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(94,'MGA',4412.503758,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(95,'MKD',55.882340,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(96,'MMK',2099.964172,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(97,'MNT',3487.813217,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(98,'MOP',8.083900,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(99,'MRO',356.999828,0,1,'2023-03-31 09:23:24','2023-03-31 09:23:24'),
(100,'MUR',45.250379,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(101,'MVR',15.350378,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(102,'MWK',1022.503739,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(103,'MXN',17.762504,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(104,'MYR',4.437039,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(105,'MZN',63.250377,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(106,'NAD',18.410377,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(107,'NGN',461.503727,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(108,'NIO',36.550377,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(109,'NOK',10.569604,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(110,'NPR',130.680865,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(111,'NZD',1.593626,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(112,'OMR',0.385010,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(113,'PAB',1.000000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(114,'PEN',3.700250,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(115,'PGK',3.520375,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(116,'PHP',55.346039,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(117,'PKR',283.503704,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(118,'PLN',4.153071,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(119,'PYG',7168.318987,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(120,'QAR',3.641038,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(121,'RON',4.472204,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(122,'RSD',105.705530,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(123,'RUB',77.815038,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(124,'RWF',1118.500000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(125,'SAR',3.751078,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(126,'SBD',8.299327,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(127,'SCR',13.929365,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(128,'SDG',598.503678,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(129,'SEK',10.219050,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(130,'SGD',1.326104,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(131,'SHP',1.216750,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(132,'SLE',22.562222,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(133,'SLL',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(134,'SOS',569.503664,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(135,'SRD',37.297038,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(136,'STD',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(137,'SVC',8.750153,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(138,'SYP',2512.370381,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(139,'SZL',18.395038,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(140,'THB',33.720369,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(141,'TJS',10.919876,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(142,'TMT',3.500000,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(143,'TND',3.031750,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(144,'TOP',2.348950,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(145,'TRY',19.516704,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(146,'TTD',6.780937,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(147,'TWD',30.593104,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(148,'TZS',2355.000335,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(149,'UAH',36.937310,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(150,'UGX',3719.778500,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(151,'USD',1.000000,1,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(152,'UYU',39.093325,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(153,'UZS',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(154,'VEF',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(155,'VES',25.026391,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(156,'VND',9999.999999,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(157,'VUV',118.540791,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(158,'WST',2.712426,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(159,'XAF',595.016735,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(160,'XAG',0.038956,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(161,'XAU',0.000496,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(162,'XCD',2.702550,0,1,'2023-03-31 09:23:24','2023-05-06 11:26:13'),
(163,'XDR',0.739504,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(164,'XOF',594.503597,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(165,'XPF',108.750364,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(166,'YER',250.350363,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(167,'ZAR',18.221455,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(169,'ZMW',17.997551,0,1,'2023-03-31 09:23:24','2023-05-06 11:24:02'),
(170,'ZWL',321.999592,0,1,'2023-03-31 09:23:24','2023-03-31 09:23:24'),
(171,'ZMK',9001.203589,0,1,'2023-03-31 09:51:49','2023-05-06 11:24:02');
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  `company_name` varchar(100) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `currency` varchar(10) NOT NULL,
  `vat_id` varchar(191) DEFAULT NULL,
  `reg_no` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `zip` varchar(191) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `profile_picture` varchar(191) DEFAULT NULL,
  `balance` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `custom_fields` text DEFAULT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customers_user_id_foreign` (`user_id`),
  KEY `customers_business_id_foreign` (`business_id`),
  CONSTRAINT `customers_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` VALUES
(1,2,1,'weblink','Enrichcoder','kafi@weblinkltd.com',NULL,'01727135737','Bangladesh','USD',NULL,NULL,'dhaka','dhaka','1230','house 154,road 8, bashundhara residential area',NULL,'default.png',0.00000000,NULL,2,NULL,'2024-12-29 10:25:58','2024-12-29 10:25:58');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `database_backups`
--

DROP TABLE IF EXISTS `database_backups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `database_backups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `file` varchar(191) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `database_backups`
--

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

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `descriptions` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `departments_user_id_foreign` (`user_id`),
  KEY `departments_business_id_foreign` (`business_id`),
  CONSTRAINT `departments_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `departments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departments`
--

LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` VALUES
(1,'Shop Management',NULL,2,1,'2024-09-09 08:19:29','2024-09-09 08:19:29');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `designations`
--

DROP TABLE IF EXISTS `designations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `designations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `descriptions` text DEFAULT NULL,
  `department_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `designations_department_id_foreign` (`department_id`),
  KEY `designations_user_id_foreign` (`user_id`),
  KEY `designations_business_id_foreign` (`business_id`),
  CONSTRAINT `designations_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `designations_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `designations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `designations`
--

LOCK TABLES `designations` WRITE;
/*!40000 ALTER TABLE `designations` DISABLE KEYS */;
INSERT INTO `designations` VALUES
(1,'Manager',NULL,1,2,1,'2024-09-09 08:20:05','2024-09-09 08:20:05');
/*!40000 ALTER TABLE `designations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_subscribers`
--

DROP TABLE IF EXISTS `email_subscribers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_subscribers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email_address` varchar(191) NOT NULL,
  `ip_address` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_subscribers_email_address_unique` (`email_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_subscribers`
--

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

--
-- Table structure for table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `slug` varchar(50) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `email_body` text DEFAULT NULL,
  `sms_body` text DEFAULT NULL,
  `notification_body` text DEFAULT NULL,
  `shortcode` text DEFAULT NULL,
  `email_status` tinyint(4) NOT NULL DEFAULT 0,
  `sms_status` tinyint(4) NOT NULL DEFAULT 0,
  `notification_status` tinyint(4) NOT NULL DEFAULT 0,
  `template_mode` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = all, 1 = email, 2 = sms, 3 = notification',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_templates`
--

LOCK TABLES `email_templates` WRITE;
/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
INSERT INTO `email_templates` VALUES
(1,'Invite User','INVITE_USER','You\'ve been invited to collaborate','<h2>Invitation to collaborate</h2><p>{{businessName}} has invited you to collaborate as {{roleName}}</p><p>{{message}}</p><p>Accept the invitation by clicking the button below.</p><p><a href=\'{{actionUrl}}\' style=\'box-sizing: border-box; position: relative; -webkit-text-size-adjust: none; border-radius: 4px; color: #fff; display: inline-block; overflow: hidden; text-decoration: none; background-color: #2d3748; border-bottom: 8px solid #2d3748; border-left: 18px solid #2d3748; border-right: 18px solid #2d3748; border-top: 8px solid #2d3748;\'>Accept Invitation</a></p><p class=\'subcopy\' style=\'word-break: break-all; font-size: 14px;\'>If you\'re having trouble clicking the \'Accept Invitation\' button, copy and paste the URL below into your web browser: <a href=\'{{actionUrl}}\'>{{actionUrl}}</a></p>','','','{{businessName}} {{roleName}} {{message}} {{actionUrl}}',0,0,0,1,NULL,NULL),
(2,'New Invoice Created','NEW_INVOICE_CREATED','New Invoice Created','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>New Invoice Created</h2> <p>Dear {{customerName}},</p> <p>I am writing to let you know that a new invoice has been created for the Product/Service you ordered. The details of the invoice are as follows:</p> <ul> <li>Invoice number: <strong>{{invoiceNumber}}</strong></li> <li>Invoice date: <strong>{{invoiceDate}}</strong></li> <li>Due date: <strong>{{dueDate}}</strong></li> <li>Total amount due: <strong>{{dueAmount}}</strong></li> </ul> <p>To make the payment, please use the following details:</p> <p>{{invoiceLink}}</p> <p>Thank you for your business. We appreciate your prompt payment.</p> </div>','','','{{customerName}} {{invoiceNumber}} {{invoiceDate}} {{dueDate}} {{dueAmount}} {{invoiceLink}}',0,0,0,1,NULL,NULL),
(3,'New Quotation Created','NEW_QUOTATION_CREATED','New Quotation Created','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>New Quotation Created</h2> <p>Dear {{customerName}},</p> <p>I am pleased to inform you that we have created a new quotation for the Product/Service you requested. The details of the quotation are as follows:</p> <ul> <li>Quotation number: <strong>{{quotationNumber}}</strong></li> <li>Quotation date: <strong>{{quotationDate}}</strong></li> <li>Quotation expiry date: <strong>{{expiryDate}}</strong></li> <li>Total amount: <strong>{{amount}}</strong></li> </ul> <p>Please note that this quotation is valid until <strong>{{expiryDate}}</strong>. If you have any questions regarding the quotation, please do not hesitate to contact us.</p> <p><a href=\'{{quotationLink}}\'>View Quotation</a></p> <p>To proceed with the order, please confirm your acceptance of the quotation by replying to this email. Once we receive your confirmation, we will proceed with the order and send you the invoice.</p> <p>Thank you for your interest in our products/services. We look forward to doing business with you.</p> </div>','','','{{customerName}} {{quotationDate}} {{expiryDate}} {{amount}} {{quotationNumber}} {{quotationLink}}',0,0,0,1,NULL,NULL),
(4,'Invoice Payment Reminder','INVOICE_PAYMENT_REMINDER','Invoice Payment Reminder','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>Invoice Payment Reminder</h2> <p>Dear {{customerName}},</p> <p>I hope this email finds you well. This message is to remind you that the payment for invoice <strong>{{invoiceNumber}}</strong> is now due.</p> <p>The total amount due is <strong>{{dueAmount}}</strong>. Please ensure that the payment is made promptly to avoid any late fees or penalties.</p> <p>To make the payment, kindly use the following details:</p> <p>{{invoiceLink}}</p> <p>If you have already made the payment, please disregard this email.</p> <p>Thank you for your prompt attention to this matter. If you have any questions or concerns, please do not hesitate to contact me.</p></div>','','','{{customerName}} {{invoiceNumber}} {{invoiceDate}} {{dueDate}} {{dueAmount}} {{invoiceLink}}',0,0,0,1,NULL,NULL),
(5,'Invoice Payment Received','INVOICE_PAYMENT_RECEIVED','Invoice Payment Received','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>Invoice Payment Received</h2> <p>Dear {{customerName}},</p> <p>I am writing to confirm that we have received your payment for invoice <strong>{{invoiceNumber}}</strong>.</p> <p>The total amount received is <strong>{{amount}}</strong>.</p> <p>Thank you for your prompt payment. We value your business and look forward to working with you again in the future.</p> <p>If you have any questions or concerns, please do not hesitate to contact us.</p></div>','','','{{customerName}} {{amount}} {{invoiceDate}} {{paymentMethod}} {{invoiceNumber}} {{invoiceLink}}',0,0,0,1,NULL,NULL),
(6,'Trial Period Ended','TRIAL_PERIOD_ENDED','Dot Accounts Trial Ended','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>Dot Accounts Trial Ended</h2> <p>Dear {{customerName}},</p> <p>We hope this email finds you well. We wanted to remind you that your trial period has ended as of {{trialEndDate}}.</p> <p>We hope you found our service useful during the trial period. If you would like to continue using our service, please pay for subscription.</p> <p>If you have any questions or concerns, please do not hesitate to contact us. We are always here to help.</p> <p>Thank you for your interest in our service. We hope to continue serving you in the future.</p> </div>','','','{{customerName}} {{trialEndDate}} {{packageName}}',0,0,0,1,NULL,NULL),
(7,'Subscription Reminder','SUBSCRIPTION_REMINDER','Subscription Reminder','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>Dot Accounts Renewal Reminder </h2> <p>Dear {{customerName}},</p> <p>We hope this email finds you well. We wanted to remind you that your subscription is expiring on {{expiryDate}}.</p> <p>If you want to continue using our service, please renew your subscription by visiting our website and selecting a subscription plan that suits your needs.</p> <p>If you have already renewed your subscription, please disregard this email. Otherwise, please renew your subscription before the expiry date to avoid any interruption in your service.</p> <p>If you have any questions or concerns, please do not hesitate to contact us. We are always here to help.</p> <p>Thank you for choosing our service. We appreciate your business and look forward to continuing to serve you.</p> </div>','','','{{customerName}} {{expiryDate}} {{packageName}}',0,0,0,1,NULL,NULL),
(8,'Subscription Payment Confirmation','SUBSCRIPTION_PAYMENT_CONFIRMATION','Subscription Payment Confirmation','<div style=\'font-family: Arial, sans-serif; font-size: 14px;\'> <h2 style=\'color: #333333;\'>Dot Accounts Payment Confirmation</h2> <p>Dear {{customerName}},</p> <p>Thank you for renewing your subscription to (Package Name: {{packageName}}). Your payment has been received and your subscription has been renewed until {{expiryDate}}.</p> <p>You can now continue using our service without any interruption. If you have any questions or concerns, please do not hesitate to contact us. We are always here to help.</p> <p>Thank you for choosing our service. We appreciate your business and look forward to continuing to serve you.</p> </div>','','','{{customerName}} {{expiryDate}} {{packageName}}',0,0,0,1,NULL,NULL),
(9,'Referral Commission','REFERRAL_COMISSION','Congratulations! You\'ve Earned a Referral Commission','<p>Dear {{name}},</p> <p>I hope this email finds you well.</p> <p>We are thrilled to inform you that you have successfully earned a referral commission through our program! We deeply appreciate your support and your help in spreading the word about our Dot Accounts Soultion.</p> <h3>Commission Details:</h3> <ul> <li><strong>Referral Name:</strong> {{ReferredUserName}}</li> <li><strong>Date of Referral:</strong> {{ReferredDate}}</li> <li><strong>Commission Amount:</strong> {{commissionAmount}}</li> </ul> <p>We are always looking to improve our services and the experience we provide. If you have any feedback or suggestions, we would love to hear from you.</p>','','','{{name}} {{ReferredUserName}} {{ReferredDate}} {{commissionAmount}}',0,0,0,1,NULL,NULL),
(10,'Approve Referral Payout','REFERRAL_PAYOUT_APPROVED','Your Payout Request has been approved','<p>Dear <strong>{{name}}</strong>,</p> <p>We are pleased to inform you that a payout of <strong>{{amount}}</strong> has been successfully processed via your nominated payment method.</p> <p><strong>Details of the Transaction:</strong></p> <ul> <li><strong>Payout Amount:</strong> {{amount}}</li> <li><strong>Transaction Date:</strong> {{date}}</li> <li><strong>Payment Method:</strong> {{paymentMethod}}</li></ul><p>Thank you for your continued trust and cooperation.</p>','','','{{name}} {{amount}} {{date}} {{paymentMethod}}',0,0,0,1,NULL,NULL),
(11,'Reject Referral Payout','REFERRAL_PAYOUT_REJECTED','Your Payout Request has been rejected','<p>Dear <strong>{{name}}</strong>,</p> <p>We regret to inform you that your payment request for the amount of <strong>{{amount}}</strong>, submitted on <strong>{{requestDate}}</strong>, has been rejected.</p> <p><strong>Reason for Rejection:</strong></p> <p>{{rejectionReason}}</p> <p>We apologize for any inconvenience this may have caused and appreciate your understanding.</p>','','','{{name}} {{amount}} {{requestDate}} {{rejectionReason}}',0,0,0,1,NULL,NULL);
/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_department_histories`
--

DROP TABLE IF EXISTS `employee_department_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_department_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `details` text NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_department_histories_employee_id_foreign` (`employee_id`),
  KEY `employee_department_histories_user_id_foreign` (`user_id`),
  KEY `employee_department_histories_business_id_foreign` (`business_id`),
  CONSTRAINT `employee_department_histories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employee_department_histories_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employee_department_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_department_histories`
--

LOCK TABLES `employee_department_histories` WRITE;
/*!40000 ALTER TABLE `employee_department_histories` DISABLE KEYS */;
INSERT INTO `employee_department_histories` VALUES
(1,1,'{\"employee_id\":\"1\",\"department\":{\"id\":1,\"name\":\"Shop Management\",\"descriptions\":null,\"user_id\":2,\"business_id\":1,\"created_at\":\"2024-09-09T08:19:29.000000Z\",\"updated_at\":\"2024-09-09T08:19:29.000000Z\"},\"designation\":{\"id\":1,\"name\":\"Manager\",\"descriptions\":null,\"department_id\":1,\"user_id\":2,\"business_id\":1,\"created_at\":\"2024-09-09T08:20:05.000000Z\",\"updated_at\":\"2024-09-09T08:20:05.000000Z\"},\"salary_scale\":{\"id\":1,\"department_id\":1,\"designation_id\":1,\"grade_number\":3,\"basic_salary\":\"40000.00\",\"full_day_absence_fine\":\"1818.00\",\"half_day_absence_fine\":\"909.00\",\"user_id\":2,\"business_id\":1,\"created_at\":\"2024-09-09T08:26:17.000000Z\",\"updated_at\":\"2024-09-09T08:26:17.000000Z\",\"salary_grade\":\"Grade 3\"},\"joining_date\":\"2023-09-01\",\"end_date\":\"2025-09-01\"}',2,1,'2024-09-09 08:29:11','2024-09-09 08:29:11');
/*!40000 ALTER TABLE `employee_department_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_documents`
--

DROP TABLE IF EXISTS `employee_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `document` varchar(191) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_documents_employee_id_foreign` (`employee_id`),
  KEY `employee_documents_user_id_foreign` (`user_id`),
  KEY `employee_documents_business_id_foreign` (`business_id`),
  CONSTRAINT `employee_documents_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employee_documents_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employee_documents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_documents`
--

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

--
-- Table structure for table `employee_expenses`
--

DROP TABLE IF EXISTS `employee_expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trans_date` datetime NOT NULL,
  `employee_id` bigint(20) unsigned NOT NULL,
  `bill_no` varchar(191) DEFAULT NULL,
  `expense_type` varchar(191) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `description` text DEFAULT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_expenses_user_id_foreign` (`user_id`),
  KEY `employee_expenses_business_id_foreign` (`business_id`),
  CONSTRAINT `employee_expenses_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employee_expenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_expenses`
--

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

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(100) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `fathers_name` varchar(100) DEFAULT NULL,
  `mothers_name` varchar(100) DEFAULT NULL,
  `date_of_birth` date NOT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `zip` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `designation_id` bigint(20) unsigned DEFAULT NULL,
  `salary_scale_id` bigint(20) unsigned DEFAULT NULL,
  `joining_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `bank_name` varchar(191) DEFAULT NULL,
  `branch_name` varchar(191) DEFAULT NULL,
  `account_name` varchar(191) DEFAULT NULL,
  `account_number` varchar(30) DEFAULT NULL,
  `swift_code` varchar(50) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `custom_fields` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employees_department_id_foreign` (`department_id`),
  KEY `employees_designation_id_foreign` (`designation_id`),
  KEY `employees_salary_scale_id_foreign` (`salary_scale_id`),
  KEY `employees_user_id_foreign` (`user_id`),
  KEY `employees_business_id_foreign` (`business_id`),
  CONSTRAINT `employees_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employees_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `employees_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  CONSTRAINT `employees_salary_scale_id_foreign` FOREIGN KEY (`salary_scale_id`) REFERENCES `salary_scales` (`id`),
  CONSTRAINT `employees_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES
(1,'1','Baki','Billah','Saki Billah','naki Billah','2000-09-01','baki@gmail.com',NULL,NULL,NULL,NULL,'Bangladesh',1,1,1,'2023-09-01','2025-09-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,1,'2024-09-09 08:29:11','2024-09-09 08:29:11');
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

--
-- Table structure for table `faq_translations`
--

DROP TABLE IF EXISTS `faq_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `faq_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `faq_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `faq_translations_faq_id_locale_unique` (`faq_id`,`locale`),
  CONSTRAINT `faq_translations_faq_id_foreign` FOREIGN KEY (`faq_id`) REFERENCES `faqs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faq_translations`
--

LOCK TABLES `faq_translations` WRITE;
/*!40000 ALTER TABLE `faq_translations` DISABLE KEYS */;
INSERT INTO `faq_translations` VALUES
(1,2,'English---us','What is a SaaS system?','SaaS stands for Software as a Service, which is a cloud computing model where software is provided over the internet, and users access it through a web browser without having to install or maintain any software locally.','2023-04-21 04:24:52','2023-04-21 04:24:52'),
(2,3,'English---us','How do I sign up for a SaaS system?','To sign up for a SaaS system, simply visit our website and click on the \"Sign Up\" or \"Get Started\" button. Follow the prompts to create an account, choose a subscription plan, and provide payment information.','2023-04-21 04:25:15','2023-04-21 04:25:15');
/*!40000 ALTER TABLE `faq_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faqs`
--

DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `order` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faqs`
--

LOCK TABLES `faqs` WRITE;
/*!40000 ALTER TABLE `faqs` DISABLE KEYS */;
INSERT INTO `faqs` VALUES
(2,1,NULL,'2023-04-21 04:24:52','2023-04-21 04:24:52'),
(3,1,NULL,'2023-04-21 04:25:15','2023-04-21 04:25:15');
/*!40000 ALTER TABLE `faqs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feature_translations`
--

DROP TABLE IF EXISTS `feature_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `feature_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feature_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `content` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `feature_translations_feature_id_locale_unique` (`feature_id`,`locale`),
  CONSTRAINT `feature_translations_feature_id_foreign` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feature_translations`
--

LOCK TABLES `feature_translations` WRITE;
/*!40000 ALTER TABLE `feature_translations` DISABLE KEYS */;
INSERT INTO `feature_translations` VALUES
(2,2,'English---us','Invoice','Paragraph of text beneath the heading to explain the heading. Here is just a bit more text.','2023-04-21 05:40:57','2023-04-24 00:59:41'),
(3,3,'English---us','Online Payment','Paragraph of text beneath the heading to explain the heading. Here is just a bit more text.','2023-04-24 00:54:38','2023-04-24 00:54:38'),
(4,4,'English---us','Estimate','Paragraph of text beneath the heading to explain the heading. Here is just a bit more text.','2023-04-24 00:55:12','2023-04-24 00:55:12'),
(5,5,'English---us','Purchase','Paragraph of text beneath the heading to explain the heading. Here is just a bit more text.','2023-04-24 00:55:34','2023-04-24 00:55:34'),
(6,6,'English---us','Invoice Templates','Paragraph of text beneath the heading to explain the heading. Here is just a bit more text.','2023-04-24 00:56:29','2023-04-24 01:00:15'),
(7,7,'English---us','Reports','Paragraph of text beneath the heading to explain the heading. Here is just a bit more text.','2023-04-24 00:56:55','2023-04-24 00:56:55');
/*!40000 ALTER TABLE `feature_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `features`
--

DROP TABLE IF EXISTS `features`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(191) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `order` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `features`
--

LOCK TABLES `features` WRITE;
/*!40000 ALTER TABLE `features` DISABLE KEYS */;
INSERT INTO `features` VALUES
(2,'<i class=\"bi bi-receipt\"></i>',1,NULL,'2023-04-21 05:40:57','2023-04-24 00:51:57'),
(3,'<i class=\"bi bi-stripe\"></i>',1,NULL,'2023-04-24 00:54:38','2023-04-24 01:01:23'),
(4,'<i class=\"bi bi-receipt-cutoff\"></i>',1,NULL,'2023-04-24 00:55:12','2023-04-24 00:55:12'),
(5,'<i class=\"bi bi-bag\"></i>',1,NULL,'2023-04-24 00:55:34','2023-04-24 00:55:34'),
(6,'<i class=\"bi bi-palette\"></i>',1,NULL,'2023-04-24 00:56:29','2023-04-24 00:56:29'),
(7,'<i class=\"bi bi-bar-chart\"></i>',1,NULL,'2023-04-24 00:56:55','2023-04-24 00:56:55');
/*!40000 ALTER TABLE `features` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `holidays`
--

DROP TABLE IF EXISTS `holidays`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `holidays` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `holidays_user_id_foreign` (`user_id`),
  KEY `holidays_business_id_foreign` (`business_id`),
  CONSTRAINT `holidays_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `holidays_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `holidays`
--

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

--
-- Table structure for table `invoice_item_taxes`
--

DROP TABLE IF EXISTS `invoice_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_item_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `invoice_item_id` bigint(20) unsigned NOT NULL,
  `tax_id` bigint(20) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_item_taxes_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_item_taxes_invoice_item_id_foreign` (`invoice_item_id`),
  KEY `invoice_item_taxes_user_id_foreign` (`user_id`),
  KEY `invoice_item_taxes_business_id_foreign` (`business_id`),
  CONSTRAINT `invoice_item_taxes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_item_taxes_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_item_taxes_invoice_item_id_foreign` FOREIGN KEY (`invoice_item_id`) REFERENCES `invoice_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_item_taxes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_item_taxes`
--

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

--
-- Table structure for table `invoice_items`
--

DROP TABLE IF EXISTS `invoice_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `product_name` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `unit_cost` decimal(28,8) NOT NULL,
  `sub_total` decimal(28,8) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_items_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_items_product_id_foreign` (`product_id`),
  KEY `invoice_items_user_id_foreign` (`user_id`),
  KEY `invoice_items_business_id_foreign` (`business_id`),
  CONSTRAINT `invoice_items_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_items_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_items`
--

LOCK TABLES `invoice_items` WRITE;
/*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */;
INSERT INTO `invoice_items` VALUES
(1,1,1,'telecom',NULL,1.00,10.00000000,10.00000000,2,1,'2024-12-29 10:38:19','2024-12-29 10:38:19'),
(2,1,1,'telecom',NULL,1.00,10.00000000,10.00000000,2,1,'2024-12-29 10:38:19','2024-12-29 10:38:19');
/*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice_templates`
--

DROP TABLE IF EXISTS `invoice_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `body` longtext NOT NULL,
  `editor` longtext NOT NULL,
  `custom_css` text DEFAULT NULL,
  `type` varchar(20) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `business_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_templates_user_id_foreign` (`user_id`),
  KEY `invoice_templates_business_id_foreign` (`business_id`),
  CONSTRAINT `invoice_templates_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_templates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_templates`
--

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

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

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `invoice_number` varchar(100) DEFAULT NULL,
  `order_number` varchar(100) DEFAULT NULL,
  `invoice_date` date NOT NULL,
  `due_date` date NOT NULL,
  `sub_total` decimal(28,8) NOT NULL,
  `grand_total` decimal(28,8) NOT NULL,
  `converted_total` decimal(28,8) DEFAULT NULL,
  `paid` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `discount` decimal(28,8) DEFAULT NULL,
  `discount_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Percentage | 1 = Fixed',
  `discount_value` decimal(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `template_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Predefined | 1 = Dynamic',
  `template` varchar(50) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `short_code` varchar(191) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `email_send` tinyint(4) NOT NULL DEFAULT 0,
  `email_send_at` datetime DEFAULT NULL,
  `is_recurring` tinyint(4) NOT NULL DEFAULT 0,
  `recurring_completed` int(11) NOT NULL DEFAULT 0,
  `recurring_start` date DEFAULT NULL,
  `recurring_end` date DEFAULT NULL,
  `recurring_value` int(11) DEFAULT NULL,
  `recurring_type` varchar(20) DEFAULT NULL,
  `recurring_invoice_date` date DEFAULT NULL,
  `recurring_due_date` varchar(20) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoices_customer_id_foreign` (`customer_id`),
  KEY `invoices_user_id_foreign` (`user_id`),
  KEY `invoices_business_id_foreign` (`business_id`),
  CONSTRAINT `invoices_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES
(1,1,'Invoice','001',NULL,'2024-12-29','2024-12-29',20.00000000,20.00000000,0.18781857,0.00000000,0.00000000,0,0.00,0,0,'default',NULL,NULL,'74084686771269b078d9',NULL,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,2,1,'2024-12-29 10:38:19','2024-12-29 10:38:19');
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leave_types`
--

DROP TABLE IF EXISTS `leave_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leave_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `leave_types_user_id_foreign` (`user_id`),
  KEY `leave_types_business_id_foreign` (`business_id`),
  CONSTRAINT `leave_types_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `leave_types_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leave_types`
--

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

--
-- Table structure for table `leaves`
--

DROP TABLE IF EXISTS `leaves`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `leave_type` varchar(50) NOT NULL,
  `leave_duration` varchar(20) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_days` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `leaves_employee_id_foreign` (`employee_id`),
  KEY `leaves_user_id_foreign` (`user_id`),
  KEY `leaves_business_id_foreign` (`business_id`),
  CONSTRAINT `leaves_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `leaves_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leaves`
--

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

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `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=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_reset_tokens_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2019_09_01_080940_create_settings_table',1),
(5,'2019_09_01_080941_create_setting_translations',1),
(6,'2020_07_02_145857_create_database_backups_table',1),
(7,'2021_07_02_145504_create_pages_table',1),
(8,'2021_07_02_145952_create_page_translations_table',1),
(9,'2021_08_07_111236_create_currency_table',1),
(10,'2021_08_08_132702_create_payment_gateways_table',1),
(11,'2021_10_22_070458_create_email_templates_table',1),
(12,'2022_08_09_160105_create_notifications_table',1),
(13,'2023_03_16_070314_create_packages_table',1),
(14,'2023_03_16_165256_create_subscription_payments_table',1),
(15,'2023_03_16_175321_create_business_types_table',1),
(16,'2023_03_17_141421_create_business_table',1),
(17,'2023_03_17_142542_create_business_settings_table',1),
(18,'2023_03_19_082601_create_roles_table',1),
(19,'2023_03_19_082603_create_business_users_table',1),
(20,'2023_03_19_143240_create_permissions_table',1),
(21,'2023_03_20_155534_create_user_invitations_table',1),
(22,'2023_03_24_082007_create_customers_table',1),
(23,'2023_03_24_144435_create_vendors_table',1),
(24,'2023_03_24_153805_create_product_units_table',1),
(25,'2023_03_24_164804_create_transaction_categories_table',1),
(26,'2023_03_24_165807_create_products_table',1),
(27,'2023_03_25_104515_create_taxes_table',1),
(28,'2023_03_25_142805_create_invoices_table',1),
(29,'2023_03_25_142811_create_invoice_items_table',1),
(30,'2023_03_25_142828_create_invoice_item_taxes_table',1),
(31,'2023_03_29_074346_create_quotations_table',1),
(32,'2023_03_29_074359_create_quotation_items_table',1),
(33,'2023_03_29_074418_create_quotation_item_taxes_table',1),
(34,'2023_03_29_171700_create_invoice_templates_table',1),
(35,'2023_04_06_111313_create_purchases_table',1),
(36,'2023_04_06_111323_create_purchase_items_table',1),
(37,'2023_04_06_111333_create_purchase_item_taxes_table',1),
(38,'2023_04_06_111434_create_accounts_table',1),
(39,'2023_04_07_080205_create_transaction_methods_table',1),
(40,'2023_04_07_080306_create_transactions_table',1),
(41,'2023_04_18_010306_create_faqs_table',1),
(42,'2023_04_18_020307_create_faq_translations_table',1),
(43,'2023_04_21_111229_create_features_table',1),
(44,'2023_04_21_111241_create_feature_translations_table',1),
(45,'2023_04_21_151904_create_testimonials_table',1),
(46,'2023_04_21_151921_create_testimonial_translations_table',1),
(47,'2023_04_21_154002_create_teams_table',1),
(48,'2023_04_21_154010_create_team_translations_table',1),
(49,'2023_04_21_160041_create_posts_table',1),
(50,'2023_04_21_160048_create_post_translations_table',1),
(51,'2023_04_21_163645_create_brands_table',1),
(52,'2023_04_24_142555_create_post_comments_table',1),
(53,'2023_05_02_144104_create_email_subscribers_table',1),
(54,'2023_05_25_083601_update_business_table',1),
(55,'2023_05_29_170209_update_products_and_transactions_table',1),
(56,'2023_08_15_080150_add_hr_payroll_field_to_packages_table',1),
(57,'2023_08_16_105725_create_departments_table',1),
(58,'2023_08_16_105813_create_designations_table',1),
(59,'2023_08_16_105820_create_salary_scales_table',1),
(60,'2023_08_16_105822_create_salary_benefits_table',1),
(61,'2023_08_16_105842_create_employees_table',1),
(62,'2023_09_14_072058_create_employee_documents_table',1),
(63,'2023_09_14_082533_create_employee_department_histories_table',1),
(64,'2023_09_14_095954_create_holidays_table',1),
(65,'2023_09_14_152308_create_leave_types_table',1),
(66,'2023_09_14_152508_create_leaves_table',1),
(67,'2023_09_14_175356_create_attendance_table',1),
(68,'2023_09_15_101849_create_awards_table',1),
(69,'2023_09_16_080833_create_payslips_table',1),
(70,'2023_09_16_082058_create_payslip_benefits_table',1),
(71,'2024_05_17_170945_create_contact_messages_table',1),
(72,'2024_07_27_215146_create_affiliate_payout_methods',1),
(73,'2024_07_28_165114_add_referrer_id_to_users_table',1),
(74,'2024_07_30_200722_create_referral_earnings_table',1),
(75,'2024_07_31_205630_create_referral_payouts_table',1),
(76,'2024_08_02_171835_create_employee_expenses_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

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

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

--
-- Dumping data for table `notifications`
--

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

--
-- Table structure for table `packages`
--

DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `package_type` varchar(30) NOT NULL,
  `cost` decimal(10,2) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `is_popular` tinyint(4) NOT NULL DEFAULT 0,
  `discount` decimal(10,2) DEFAULT NULL,
  `trial_days` int(11) NOT NULL DEFAULT 0,
  `user_limit` varchar(191) DEFAULT NULL,
  `invoice_limit` varchar(191) DEFAULT NULL,
  `quotation_limit` varchar(191) DEFAULT NULL,
  `recurring_invoice` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Yes | 0 = No',
  `customer_limit` varchar(191) DEFAULT NULL,
  `business_limit` varchar(191) DEFAULT NULL,
  `invoice_builder` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Yes | 0 = No',
  `online_invoice_payment` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Yes | 0 = No',
  `payroll_module` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Yes | 0 = No',
  `others` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packages`
--

LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
INSERT INTO `packages` VALUES
(1,'Starter','monthly',10.00,1,0,10.00,7,'2','50','50',0,'20','2',0,0,0,NULL,'2023-03-16 08:19:59','2023-05-05 02:29:09'),
(2,'Standard','monthly',20.00,1,1,10.00,0,'5','100','100',1,'50','3',0,1,0,NULL,'2023-03-16 08:30:29','2023-05-04 04:08:35'),
(3,'Professional','monthly',30.00,1,0,5.00,0,'10','500','500',1,'100','10',1,1,0,NULL,'2023-03-16 08:33:39','2023-03-16 08:33:39'),
(4,'Starter','yearly',100.00,1,0,0.00,0,'5','1000','1000',0,'100','5',0,0,0,NULL,'2023-03-16 08:40:50','2023-03-16 08:40:50'),
(5,'Standard','yearly',210.00,1,1,5.00,0,'10','2000','200',1,'200','20',1,1,0,NULL,'2023-03-16 08:46:19','2023-03-16 08:50:49'),
(6,'Professional','yearly',300.00,1,0,0.00,0,'20','-1','-1',1,'-1','20',1,1,0,NULL,'2023-03-16 08:48:56','2023-03-16 08:48:56'),
(7,'Lifetime Gold','lifetime',499.00,1,0,0.00,0,'10','-1','-1',1,'-1','-1',1,1,0,NULL,'2023-04-24 01:15:56','2023-04-24 01:15:56'),
(8,'Custom','lifetime',0.00,1,1,0.00,0,'-1','-1','-1',1,'-1','-1',1,1,1,NULL,'2024-09-09 06:26:47','2024-09-09 06:26:47');
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `page_translations`
--

DROP TABLE IF EXISTS `page_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` text NOT NULL,
  `body` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_translations_page_id_locale_unique` (`page_id`,`locale`),
  CONSTRAINT `page_translations_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `page_translations`
--

LOCK TABLES `page_translations` WRITE;
/*!40000 ALTER TABLE `page_translations` DISABLE KEYS */;
INSERT INTO `page_translations` VALUES
(4,3,'English---us','Terms & Condition','<h2>Terms and Conditions</h2>\r\n<p>Welcome to our website. By accessing and using our website, you agree to comply with and be bound by the following terms and conditions:</p>\r\n<p> </p>\r\n<h3>1. Intellectual Property</h3>\r\n<p>All content on this website, including but not limited to text, graphics, logos, images, and software, is the property of our company and is protected by intellectual property laws.</p>\r\n<p> </p>\r\n<h3>2. Use of Website</h3>\r\n<p>You may use our website for personal and non-commercial purposes only. You may not use our website for any illegal or unauthorized purpose, including but not limited to transmitting harmful code or attempting to gain unauthorized access to our systems.</p>\r\n<p> </p>\r\n<h3>3. Privacy</h3>\r\n<p>We respect your privacy and will handle your personal information in accordance with our Privacy Policy. By using our website, you consent to the collection, use, and disclosure of your personal information as described in our Privacy Policy.</p>\r\n<p> </p>\r\n<h3>4. Links to Third-Party Websites</h3>\r\n<p>Our website may contain links to third-party websites. We do not endorse or control the content or policies of these websites, and your use of such websites is at your own risk.</p>\r\n<p> </p>\r\n<h3>5. Disclaimer of Warranties</h3>\r\n<p>Our website is provided on an \"as is\" and \"as available\" basis, without warranties of any kind, including but not limited to implied warranties of merchantability, fitness for a particular purpose, and non-infringement. We do not guarantee that our website will be uninterrupted, error-free, or free from harmful code.</p>\r\n<p> </p>\r\n<h3>6. Limitation of Liability</h3>\r\n<p>In no event shall our company be liable for any direct, indirect, incidental, consequential, special, or exemplary damages arising out of or in connection with your use of our website, even if we have been advised of the possibility of such damages.</p>\r\n<p> </p>\r\n<h3>7. Governing Law</h3>\r\n<p>These terms and conditions shall be governed by and construed in accordance with the laws of [insert applicable jurisdiction].</p>\r\n<p> </p>\r\n<h3>8. Changes to Terms and Conditions</h3>\r\n<p>We reserve the right to modify or update these terms and conditions at any time, without prior notice. Your continued use of our website after any changes to these terms and conditions will constitute your acceptance of such changes.</p>\r\n<p> </p>\r\n<h3>9. Contact Us</h3>\r\n<p>If you have any questions or concerns about these terms and conditions, please contact us at [insert contact information].</p>','2023-04-24 02:53:24','2023-04-24 04:07:21'),
(5,4,'English---us','Privacy Policy','<h2>Privacy Policy</h2>\r\n<p>We are committed to protecting your privacy. This privacy policy explains how we collect, use, and disclose your personal information when you use our website:</p>\r\n<p> </p>\r\n<h3>1. Information We Collect</h3>\r\n<p>We may collect various types of information from you, including but not limited to:</p>\r\n<ul>\r\n<li>Personal information such as your name, email address, and contact details.</li>\r\n<li>Usage information such as your IP address, browser type, and pages visited on our website.</li>\r\n<li>Cookies and other tracking technologies that may be used to collect information about your browsing behavior on our website.</li>\r\n</ul>\r\n<h3> </h3>\r\n<h3>2. Use of Information</h3>\r\n<p>We may use your personal information for the following purposes:</p>\r\n<ul>\r\n<li>To provide and improve our services, products, and website.</li>\r\n<li>To communicate with you and respond to your inquiries.</li>\r\n<li>To send you promotional offers and updates with your consent, which you may opt out of at any time.</li>\r\n<li>To comply with legal and regulatory requirements.</li>\r\n</ul>\r\n<h3> </h3>\r\n<h3>3. Disclosure of Information</h3>\r\n<p>We may disclose your personal information to third parties in the following circumstances:</p>\r\n<ul>\r\n<li>To service providers who assist us in operating our website and conducting our business.</li>\r\n<li>To comply with legal and regulatory requirements, or to protect our rights and property.</li>\r\n<li>With your consent, or as otherwise required or permitted by law.</li>\r\n</ul>\r\n<h3> </h3>\r\n<h3>4. Security</h3>\r\n<p>We take appropriate measures to protect the security of your personal information, but please be aware that no method of transmission over the internet or electronic storage is completely secure.</p>\r\n<h3> </h3>\r\n<h3>5. Links to Third-Party Websites</h3>\r\n<p>Our website may contain links to third-party websites. We do not endorse or control the content or policies of these websites, and our privacy policy does not apply to them. Please review the privacy policies of these third-party websites before providing them with any personal information.</p>\r\n<h3> </h3>\r\n<h3>6. Children\'s Privacy</h3>\r\n<p>Our website is not intended for children under the age of 13. We do not knowingly collect personal information from children under the age of 13. If we become aware that we have collected personal information from a child under the age of 13, we will take steps to delete such information.</p>\r\n<h3> </h3>\r\n<h3>7. Changes to Privacy Policy</h3>\r\n<p>We reserve the right to modify or update this privacy policy at any time, without prior notice. Your continued use of our website after any changes to this privacy policy will constitute your acceptance of such changes.</p>\r\n<h3> </h3>\r\n<h3>8. Contact Us</h3>\r\n<p>If you have any questions or concerns about our privacy policy, please contact us at [insert contact information].</p>','2023-04-24 02:54:30','2023-04-24 04:09:16');
/*!40000 ALTER TABLE `page_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES
(3,'terms-condition',1,'2023-04-24 02:53:24','2023-04-24 02:53:24'),
(4,'privacy-policy',1,'2023-04-24 02:54:30','2023-04-24 02:54:30');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

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

--
-- Dumping data for table `password_reset_tokens`
--

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

--
-- Table structure for table `payment_gateways`
--

DROP TABLE IF EXISTS `payment_gateways`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_gateways` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `slug` varchar(30) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `is_crypto` tinyint(4) NOT NULL DEFAULT 0,
  `parameters` text DEFAULT NULL,
  `extra` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_gateways`
--

LOCK TABLES `payment_gateways` WRITE;
/*!40000 ALTER TABLE `payment_gateways` DISABLE KEYS */;
INSERT INTO `payment_gateways` VALUES
(1,'PayPal','PayPal','paypal.png',0,0,'{\"client_id\":\"\",\"client_secret\":\"\",\"environment\":\"sandbox\"}',NULL,NULL,NULL),
(2,'Stripe','Stripe','stripe.png',0,0,'{\"secret_key\":\"\",\"publishable_key\":\"\"}',NULL,NULL,NULL),
(3,'Razorpay','Razorpay','razorpay.png',0,0,'{\"razorpay_key_id\":\"\",\"razorpay_key_secret\":\"\"}',NULL,NULL,NULL),
(4,'Paystack','Paystack','paystack.png',0,0,'{\"paystack_public_key\":\"\",\"paystack_secret_key\":\"\"}',NULL,NULL,NULL),
(5,'Flutterwave','Flutterwave','flutterwave.png',0,0,'{\"public_key\":\"\",\"secret_key\":\"\",\"encryption_key\":\"\",\"environment\":\"sandbox\"}',NULL,NULL,NULL),
(6,'Mollie','Mollie','Mollie.png',0,0,'{\"api_key\":\"\"}',NULL,NULL,NULL),
(7,'Instamojo','Instamojo','instamojo.png',0,0,'{\"api_key\":\"\",\"auth_token\":\"\",\"salt\":\"\",\"environment\":\"sandbox\"}',NULL,NULL,NULL);
/*!40000 ALTER TABLE `payment_gateways` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payslip_benefits`
--

DROP TABLE IF EXISTS `payslip_benefits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payslip_benefits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payslip_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `type` varchar(20) NOT NULL COMMENT 'add | deduct',
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payslip_benefits_payslip_id_foreign` (`payslip_id`),
  KEY `payslip_benefits_user_id_foreign` (`user_id`),
  KEY `payslip_benefits_business_id_foreign` (`business_id`),
  CONSTRAINT `payslip_benefits_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payslip_benefits_payslip_id_foreign` FOREIGN KEY (`payslip_id`) REFERENCES `payslips` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payslip_benefits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payslip_benefits`
--

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

--
-- Table structure for table `payslips`
--

DROP TABLE IF EXISTS `payslips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payslips` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `transaction_id` bigint(20) unsigned DEFAULT NULL,
  `month` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `current_salary` decimal(28,8) NOT NULL,
  `expense` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `absence_fine` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `net_salary` decimal(8,2) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payslips_transaction_id_foreign` (`transaction_id`),
  KEY `payslips_employee_id_foreign` (`employee_id`),
  KEY `payslips_user_id_foreign` (`user_id`),
  KEY `payslips_business_id_foreign` (`business_id`),
  CONSTRAINT `payslips_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payslips_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payslips_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `payslips_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payslips`
--

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NOT NULL,
  `permission` varchar(191) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permissions_user_id_foreign` (`user_id`),
  CONSTRAINT `permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES
(1,1,'dashboard.current_month_income_widget',2,'2024-09-09 08:34:09','2024-09-09 08:34:09'),
(2,1,'dashboard.current_month_expense_widget',2,'2024-09-09 08:34:09','2024-09-09 08:34:09'),
(3,1,'dashboard.due_invoice_amount_widget',2,'2024-09-09 08:34:09','2024-09-09 08:34:09'),
(4,1,'dashboard.due_purchase_amount_widget',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(5,1,'customers.index',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(6,1,'customers.create',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(7,1,'customers.show',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(8,1,'customers.edit',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(9,1,'customers.destroy',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(10,1,'vendors.index',2,'2024-09-09 08:34:10','2024-09-09 08:34:10'),
(11,1,'vendors.create',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(12,1,'vendors.show',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(13,1,'vendors.edit',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(14,1,'vendors.destroy',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(15,1,'product_units.index',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(16,1,'product_units.create',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(17,1,'product_units.edit',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(18,1,'product_units.destroy',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(19,1,'products.index',2,'2024-09-09 08:34:11','2024-09-09 08:34:11'),
(20,1,'products.create',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(21,1,'products.show',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(22,1,'products.edit',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(23,1,'products.destroy',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(24,1,'invoices.send_email',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(25,1,'invoices.add_payment',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(26,1,'invoices.mark_as_cancelled',2,'2024-09-09 08:34:12','2024-09-09 08:34:12'),
(27,1,'invoices.duplicate',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(28,1,'invoices.export_pdf',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(29,1,'invoices.approve',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(30,1,'invoices.index',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(31,1,'invoices.create',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(32,1,'invoices.show',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(33,1,'invoices.edit',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(34,1,'invoices.destroy',2,'2024-09-09 08:34:13','2024-09-09 08:34:13'),
(35,1,'recurring_invoices.convert_recurring',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(36,1,'recurring_invoices.end_recurring',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(37,1,'recurring_invoices.duplicate',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(38,1,'recurring_invoices.approve',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(39,1,'recurring_invoices.index',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(40,1,'recurring_invoices.create',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(41,1,'recurring_invoices.edit',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(42,1,'recurring_invoices.destroy',2,'2024-09-09 08:34:14','2024-09-09 08:34:14'),
(43,1,'quotations.send_email',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(44,1,'quotations.convert_to_invoice',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(45,1,'quotations.duplicate',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(46,1,'quotations.export_pdf',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(47,1,'quotations.index',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(48,1,'quotations.create',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(49,1,'quotations.show',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(50,1,'quotations.edit',2,'2024-09-09 08:34:15','2024-09-09 08:34:15'),
(51,1,'quotations.destroy',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(52,1,'purchases.add_payment',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(53,1,'purchases.duplicate',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(54,1,'purchases.index',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(55,1,'purchases.create',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(56,1,'purchases.show',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(57,1,'purchases.edit',2,'2024-09-09 08:34:16','2024-09-09 08:34:16'),
(58,1,'purchases.destroy',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(59,1,'accounts.index',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(60,1,'accounts.create',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(61,1,'accounts.show',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(62,1,'accounts.edit',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(63,1,'accounts.destroy',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(64,1,'leaves.index',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(65,1,'leaves.create',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(66,1,'leaves.show',2,'2024-09-09 08:34:17','2024-09-09 08:34:17'),
(67,1,'leaves.edit',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(68,1,'leaves.destroy',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(69,1,'taxes.index',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(70,1,'taxes.create',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(71,1,'taxes.edit',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(72,1,'taxes.destroy',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(73,1,'reports.transactions_report',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(74,1,'reports.income_by_customer',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(75,1,'reports.purchase_by_vendor',2,'2024-09-09 08:34:18','2024-09-09 08:34:18'),
(76,1,'reports.attendance_report',2,'2024-09-09 08:34:19','2024-09-09 08:34:19'),
(77,1,'reports.tax_report',2,'2024-09-09 08:34:19','2024-09-09 08:34:19');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `post_comments`
--

DROP TABLE IF EXISTS `post_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `post_comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `post_id` bigint(20) unsigned NOT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(191) NOT NULL,
  `comment` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `post_comments_user_id_foreign` (`user_id`),
  KEY `post_comments_post_id_foreign` (`post_id`),
  KEY `post_comments_parent_id_foreign` (`parent_id`),
  CONSTRAINT `post_comments_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `post_comments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `post_comments_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `post_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `post_comments`
--

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

--
-- Table structure for table `post_translations`
--

DROP TABLE IF EXISTS `post_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `post_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `short_description` text NOT NULL,
  `content` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `post_translations_post_id_locale_unique` (`post_id`,`locale`),
  CONSTRAINT `post_translations_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `post_translations`
--

LOCK TABLES `post_translations` WRITE;
/*!40000 ALTER TABLE `post_translations` DISABLE KEYS */;
INSERT INTO `post_translations` VALUES
(4,3,'English---us','There are many variations of passages of Lorem Ipsum available','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.','<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</p>\r\n<p>It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>','2023-04-24 02:05:19','2023-04-24 02:05:19'),
(5,4,'English---us','It is a long established fact that a reader will be distracted','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here','<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n<p> </p>\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable.</p>','2023-04-24 02:06:20','2023-04-24 02:06:20'),
(6,5,'English---us','Where does it come from?','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur','<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>\r\n<p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>','2023-04-24 02:06:46','2023-04-24 02:06:46');
/*!40000 ALTER TABLE `post_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` VALUES
(3,'there-are-many-variations-of-passages-of-lorem-ipsum-available','default.png',1,1,'2023-04-24 02:05:19','2023-04-24 02:05:19'),
(4,'it-is-a-long-established-fact-that-a-reader-will-be-distracted','default.png',1,1,'2023-04-24 02:06:20','2023-04-24 02:06:20'),
(5,'where-does-it-come-from-','default.png',1,1,'2023-04-24 02:06:46','2023-04-24 02:06:46');
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_units`
--

DROP TABLE IF EXISTS `product_units`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unit` varchar(30) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_units_user_id_foreign` (`user_id`),
  KEY `product_units_business_id_foreign` (`business_id`),
  CONSTRAINT `product_units_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_units_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_units`
--

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

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `type` varchar(10) NOT NULL COMMENT 'product || service',
  `product_unit_id` bigint(20) unsigned DEFAULT NULL,
  `purchase_cost` decimal(28,8) DEFAULT NULL,
  `selling_price` decimal(28,8) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `descriptions` text DEFAULT NULL,
  `stock_management` tinyint(4) NOT NULL DEFAULT 0,
  `stock` decimal(10,2) DEFAULT NULL,
  `allow_for_selling` tinyint(4) NOT NULL DEFAULT 0,
  `allow_for_purchasing` tinyint(4) NOT NULL DEFAULT 0,
  `income_category_id` bigint(20) unsigned DEFAULT NULL,
  `expense_category_id` bigint(20) unsigned DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_product_unit_id_foreign` (`product_unit_id`),
  KEY `products_user_id_foreign` (`user_id`),
  KEY `products_business_id_foreign` (`business_id`),
  KEY `products_income_category_id_foreign` (`income_category_id`),
  KEY `products_expense_category_id_foreign` (`expense_category_id`),
  CONSTRAINT `products_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `products_expense_category_id_foreign` FOREIGN KEY (`expense_category_id`) REFERENCES `transaction_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `products_income_category_id_foreign` FOREIGN KEY (`income_category_id`) REFERENCES `transaction_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `products_product_unit_id_foreign` FOREIGN KEY (`product_unit_id`) REFERENCES `product_units` (`id`) ON DELETE SET NULL,
  CONSTRAINT `products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES
(1,'telecom','service',NULL,NULL,10.00000000,'default.png',NULL,1,1.00,1,0,1,NULL,1,2,1,2,NULL,'2024-12-29 10:35:21','2024-12-29 10:35:21');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_item_taxes`
--

DROP TABLE IF EXISTS `purchase_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchase_item_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` bigint(20) unsigned NOT NULL,
  `purchase_item_id` bigint(20) unsigned NOT NULL,
  `tax_id` bigint(20) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_item_taxes_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_item_taxes_purchase_item_id_foreign` (`purchase_item_id`),
  KEY `purchase_item_taxes_user_id_foreign` (`user_id`),
  KEY `purchase_item_taxes_business_id_foreign` (`business_id`),
  CONSTRAINT `purchase_item_taxes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_item_taxes_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_item_taxes_purchase_item_id_foreign` FOREIGN KEY (`purchase_item_id`) REFERENCES `purchase_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_item_taxes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_item_taxes`
--

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

--
-- Table structure for table `purchase_items`
--

DROP TABLE IF EXISTS `purchase_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchase_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `product_name` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `unit_cost` decimal(28,8) NOT NULL,
  `sub_total` decimal(28,8) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_items_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_items_product_id_foreign` (`product_id`),
  KEY `purchase_items_user_id_foreign` (`user_id`),
  KEY `purchase_items_business_id_foreign` (`business_id`),
  CONSTRAINT `purchase_items_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_items_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_items`
--

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

--
-- Table structure for table `purchases`
--

DROP TABLE IF EXISTS `purchases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` bigint(20) unsigned NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `bill_no` varchar(100) DEFAULT NULL,
  `po_so_number` varchar(100) DEFAULT NULL,
  `purchase_date` date NOT NULL,
  `due_date` date NOT NULL,
  `sub_total` decimal(28,8) NOT NULL,
  `grand_total` decimal(28,8) NOT NULL,
  `converted_total` decimal(28,8) DEFAULT NULL,
  `paid` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `discount` decimal(28,8) DEFAULT NULL,
  `discount_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Percentage | 1 = Fixed',
  `discount_value` decimal(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `template_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Predefined | 1 = Dynamic',
  `template` varchar(50) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `short_code` varchar(191) DEFAULT NULL,
  `email_send` tinyint(4) NOT NULL DEFAULT 0,
  `email_send_at` datetime DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchases_vendor_id_foreign` (`vendor_id`),
  KEY `purchases_user_id_foreign` (`user_id`),
  KEY `purchases_business_id_foreign` (`business_id`),
  CONSTRAINT `purchases_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchases_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchases_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchases`
--

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

--
-- Table structure for table `quotation_item_taxes`
--

DROP TABLE IF EXISTS `quotation_item_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotation_item_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotation_id` bigint(20) unsigned NOT NULL,
  `quotation_item_id` bigint(20) unsigned NOT NULL,
  `tax_id` bigint(20) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotation_item_taxes_quotation_id_foreign` (`quotation_id`),
  KEY `quotation_item_taxes_quotation_item_id_foreign` (`quotation_item_id`),
  KEY `quotation_item_taxes_user_id_foreign` (`user_id`),
  KEY `quotation_item_taxes_business_id_foreign` (`business_id`),
  CONSTRAINT `quotation_item_taxes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_item_taxes_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_item_taxes_quotation_item_id_foreign` FOREIGN KEY (`quotation_item_id`) REFERENCES `quotation_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_item_taxes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quotation_item_taxes`
--

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

--
-- Table structure for table `quotation_items`
--

DROP TABLE IF EXISTS `quotation_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotation_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotation_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `product_name` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `unit_cost` decimal(28,8) NOT NULL,
  `sub_total` decimal(28,8) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotation_items_quotation_id_foreign` (`quotation_id`),
  KEY `quotation_items_product_id_foreign` (`product_id`),
  KEY `quotation_items_user_id_foreign` (`user_id`),
  KEY `quotation_items_business_id_foreign` (`business_id`),
  CONSTRAINT `quotation_items_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_items_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotation_items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quotation_items`
--

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

--
-- Table structure for table `quotations`
--

DROP TABLE IF EXISTS `quotations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) unsigned NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `quotation_number` varchar(100) NOT NULL,
  `po_so_number` varchar(100) DEFAULT NULL,
  `quotation_date` date NOT NULL,
  `expired_date` date NOT NULL,
  `sub_total` decimal(28,8) NOT NULL,
  `grand_total` decimal(28,8) NOT NULL,
  `converted_total` decimal(28,8) DEFAULT NULL,
  `discount` decimal(28,8) DEFAULT NULL,
  `discount_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Percentage | 1 = Fixed',
  `discount_value` decimal(10,2) DEFAULT NULL,
  `template_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Predefined | 1 = Dynamic',
  `template` varchar(50) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `short_code` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotations_customer_id_foreign` (`customer_id`),
  KEY `quotations_user_id_foreign` (`user_id`),
  KEY `quotations_business_id_foreign` (`business_id`),
  CONSTRAINT `quotations_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotations_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quotations`
--

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

--
-- Table structure for table `referral_earnings`
--

DROP TABLE IF EXISTS `referral_earnings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `referral_earnings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `subscription_payment_id` bigint(20) unsigned NOT NULL,
  `reffered_user_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `commission_percentage` decimal(8,2) NOT NULL,
  `commission_amount` decimal(28,8) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `referral_earnings_user_id_foreign` (`user_id`),
  KEY `referral_earnings_subscription_payment_id_foreign` (`subscription_payment_id`),
  CONSTRAINT `referral_earnings_subscription_payment_id_foreign` FOREIGN KEY (`subscription_payment_id`) REFERENCES `subscription_payments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `referral_earnings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referral_earnings`
--

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

--
-- Table structure for table `referral_payouts`
--

DROP TABLE IF EXISTS `referral_payouts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `referral_payouts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `affiliate_payout_method_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `final_amount` decimal(28,8) NOT NULL,
  `requirements` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = Pending | 1 = Completed | 99 = Cancelled',
  `admin_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referral_payouts`
--

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

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roles_user_id_foreign` (`user_id`),
  CONSTRAINT `roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES
(1,'Shop manager',NULL,2,'2024-09-09 08:30:01','2024-09-09 08:30:01');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salary_benefits`
--

DROP TABLE IF EXISTS `salary_benefits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `salary_benefits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `salary_scale_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `amount` decimal(28,8) NOT NULL,
  `type` varchar(20) NOT NULL COMMENT 'add | deduct',
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salary_benefits_salary_scale_id_foreign` (`salary_scale_id`),
  KEY `salary_benefits_user_id_foreign` (`user_id`),
  KEY `salary_benefits_business_id_foreign` (`business_id`),
  CONSTRAINT `salary_benefits_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `salary_benefits_salary_scale_id_foreign` FOREIGN KEY (`salary_scale_id`) REFERENCES `salary_scales` (`id`) ON DELETE CASCADE,
  CONSTRAINT `salary_benefits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salary_benefits`
--

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

--
-- Table structure for table `salary_scales`
--

DROP TABLE IF EXISTS `salary_scales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `salary_scales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `department_id` bigint(20) unsigned NOT NULL,
  `designation_id` bigint(20) unsigned NOT NULL,
  `grade_number` int(11) NOT NULL,
  `basic_salary` decimal(28,8) NOT NULL,
  `full_day_absence_fine` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `half_day_absence_fine` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salary_scales_department_id_foreign` (`department_id`),
  KEY `salary_scales_designation_id_foreign` (`designation_id`),
  KEY `salary_scales_user_id_foreign` (`user_id`),
  KEY `salary_scales_business_id_foreign` (`business_id`),
  CONSTRAINT `salary_scales_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `salary_scales_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `salary_scales_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `salary_scales_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salary_scales`
--

LOCK TABLES `salary_scales` WRITE;
/*!40000 ALTER TABLE `salary_scales` DISABLE KEYS */;
INSERT INTO `salary_scales` VALUES
(1,1,1,3,40000.00000000,1818.00000000,909.00000000,2,1,'2024-09-09 08:26:17','2024-09-09 08:26:17');
/*!40000 ALTER TABLE `salary_scales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `setting_translations`
--

DROP TABLE IF EXISTS `setting_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `setting_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `setting_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `value` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_translations_setting_id_locale_unique` (`setting_id`,`locale`),
  CONSTRAINT `setting_translations_setting_id_foreign` FOREIGN KEY (`setting_id`) REFERENCES `settings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `setting_translations`
--

LOCK TABLES `setting_translations` WRITE;
/*!40000 ALTER TABLE `setting_translations` DISABLE KEYS */;
INSERT INTO `setting_translations` VALUES
(3,27,'English---us','{\"title\":\"Home - Dot Accounts\",\"hero_heading\":\"Start Your Business & Manage Business With Dot Accounts\",\"hero_sub_heading\":\"It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.\",\"get_started_text\":\"Get Started\",\"get_started_link\":\"\",\"features_status\":\"1\",\"features_heading\":\"Explore Our Features\",\"features_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"pricing_status\":\"1\",\"pricing_heading\":\"Check Our Pricing\",\"pricing_sub_heading\":\"Best pricing plan for all level of customers. Choose the best one for your business.\",\"blog_status\":\"1\",\"blog_heading\":\"Recent posts form our Blog\",\"blog_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"testimonials_status\":\"1\",\"testimonials_heading\":\"What Customers Say About Us\",\"testimonials_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"newsletter_status\":\"1\",\"newsletter_heading\":\"Subscribe Our Newsletter\",\"newsletter_sub_heading\":\"We care about privacy, and will never share your data.\"}','2023-04-22 04:50:19','2023-05-19 11:03:23'),
(5,35,'English---us','{\"title\":\"About Us\",\"section_1_heading\":\"What is Dot Accounts?\",\"section_1_content\":\"<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.<\\/p>\\r\\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.<\\/p>\",\"section_2_heading\":\"Who We Are?\",\"section_2_content\":\"<p class=\\\"lead\\\">Insight loan advisors is completely independent loan advising service and our directory of lenders gives you all the information lorem ipsums sitamets.<\\/p>\\r\\n<div class=\\\"content\\\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Consv peent esque urna. Ac eu fringilla intea dger egadv estas ut. Sed vulutate aenean nunc quis a urna morbi id vitae. Vulpuate nisl<\\/div>\",\"section_3_heading\":\"What We Offer?\",\"section_3_content\":\"<p class=\\\"lead\\\">Our loan sanction is one of the quicke with eas documentation and doorstep lorem ipsum serviceullam dolor sitisi.<\\/p>\\r\\n<div class=\\\"content\\\">\\r\\n<ul>\\r\\n<li>Habit building in essential steps choose habit<\\/li>\\r\\n<li>Get an overview of Habit Calendars Latest Posts<\\/li>\\r\\n<li>Start building habit with Habitify on platform<\\/li>\\r\\n<\\/ul>\\r\\n<\\/div>\",\"team_status\":\"1\",\"team_heading\":\"People Behind Us\",\"team_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 08:51:55','2023-04-23 08:51:55'),
(6,37,'English---us','{\"title\":\"Pricing\",\"pricing_heading\":\"Check Our Pricing\",\"pricing_sub_heading\":\"Best pricing plan for all level of customers. Choose the best one for your business.\"}','2023-04-23 09:03:41','2023-04-24 04:49:49'),
(7,38,'English---us','{\"title\":\"Features\",\"features_status\":\"1\",\"features_heading\":\"Explore Our Features\",\"features_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:04:16','2023-04-23 09:04:16'),
(8,39,'English---us','{\"title\":\"Blogs\",\"blogs_status\":\"1\",\"blogs_heading\":\"Recent posts form our Blog\",\"blogs_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:06:31','2023-04-23 09:06:31'),
(9,40,'English---us','{\"title\":\"FAQ\",\"features_status\":\"1\",\"features_heading\":\"Frequently Asked Questions\",\"features_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:08:17','2023-04-23 09:08:17'),
(10,41,'English---us','{\"title\":\"FAQ\",\"faq_status\":\"1\",\"faq_heading\":\"Frequently Asked Questions\",\"faq_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:10:21','2023-04-23 09:10:21'),
(11,42,'English---us','{\"title\":\"Get in touch\",\"contact_form_heading\":\"Let\\u2019s get connected\",\"contact_form_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"contact_info_heading\":[\"Still Have Questions?\",\"Opening hours\",\"Office Address\"],\"contact_info_content\":[\" <span>Call Us We Will Be Happy To Help\\r\\n<br><a href=\\\"tel:+3301563965\\\">+3301563965<\\/a><\\/span>\",\"<span>Monday - Friday\\r\\n<br>9AM - 8PM (Eastern Time)<\\/span>\",\"<span>\\r\\n34 Balonne Street<br>\\r\\nDeauville, New South Wales<br>\\r\\nCountry  Australia\\r\\n<\\/span>\"],\"facebook_link\":\"#\",\"linkedin_link\":\"#\",\"twitter_link\":\"#\",\"youtube_link\":\"#\"}','2023-04-23 09:15:58','2023-04-23 09:59:36'),
(12,43,'English---us','{\"top_header_color\":\"#5034fc\",\"footer_color\":\"#061E5C\",\"widget_1_heading\":\"About Us\",\"widget_1_content\":\"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.\",\"widget_2_heading\":\"Customer Service\",\"widget_2_menus\":[\"faq\",\"contact\",\"terms-condition\",\"privacy-policy\"],\"widget_3_heading\":\"Quick Explore\",\"widget_3_menus\":[\"home\",\"about\",\"features\",\"pricing\",\"blogs\"],\"copyright_text\":\"<p>Copyright \\u00a9 2023 <a href=\\\"#\\\" target=\\\"_blank\\\">Hobby Tech<\\/a>  -  All Rights Reserved.<\\/p>\",\"custom_css\":\"\"}','2023-04-23 11:27:32','2023-04-24 05:42:29'),
(13,55,'Spanish---es','{\"cookie_message\":\"Usamos cookies para mejorar su experiencia de navegaci\\u00f3n, mostrar anuncios o contenido personalizados y analizar nuestro tr\\u00e1fico. Al hacer clic en \\\"Aceptar\\\", acepta nuestro uso de cookies.\"}','2023-05-18 02:26:05','2023-05-18 02:26:48'),
(14,55,'English---us','{\"cookie_consent_status\":\"1\",\"cookie_message\":\"We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking \\\"Accept\\\", you consent to our use of cookies.\"}','2023-05-18 02:26:10','2023-05-19 11:10:12');
/*!40000 ALTER TABLE `setting_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `value` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
(1,'mail_type','smtp',NULL,NULL),
(2,'backend_direction','ltr',NULL,'2024-09-10 05:20:13'),
(3,'email_verification','0',NULL,'2024-09-10 05:20:13'),
(4,'member_signup','1',NULL,'2024-09-10 05:20:13'),
(5,'language','English---us',NULL,'2024-09-09 06:23:20'),
(6,'currency','BDT',NULL,'2024-09-10 05:20:13'),
(7,'company_name','WCL Accounts','2024-09-09 00:21:48','2024-09-09 06:23:20'),
(8,'site_title','WCL-SAAS','2024-09-09 00:21:48','2024-09-09 06:23:20'),
(9,'phone','01300432338','2024-09-09 00:21:48','2024-09-09 06:23:20'),
(10,'email','kafi@weblinkltd.com','2024-09-09 00:21:48','2024-09-09 06:23:20'),
(11,'timezone','Asia/Dhaka','2024-09-09 00:21:48','2024-09-09 06:23:20'),
(27,'home_page','{\"title\":\"Home - Dot Accounts\",\"hero_heading\":\"Start Your Business & Manage Business With Dot Accounts\",\"hero_sub_heading\":\"It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.\",\"get_started_text\":\"Get Started\",\"get_started_link\":\"\",\"features_status\":\"1\",\"features_heading\":\"Explore Our Features\",\"features_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"pricing_status\":\"1\",\"pricing_heading\":\"Check Our Pricing\",\"pricing_sub_heading\":\"Best pricing plan for all level of customers. Choose the best one for your business.\",\"blog_status\":\"1\",\"blog_heading\":\"Recent posts form our Blog\",\"blog_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"testimonials_status\":\"1\",\"testimonials_heading\":\"What Customers Say About Us\",\"testimonials_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"newsletter_status\":\"1\",\"newsletter_heading\":\"Subscribe Our Newsletter\",\"newsletter_sub_heading\":\"We care about privacy, and will never share your data.\"}','2023-04-22 04:50:19','2023-05-19 11:03:23'),
(35,'about_page','{\"title\":\"About Us\",\"section_1_heading\":\"What is Dot Accounts?\",\"section_1_content\":\"<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.<\\/p>\\r\\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.<\\/p>\",\"section_2_heading\":\"Who We Are?\",\"section_2_content\":\"<p class=\\\"lead\\\">Insight loan advisors is completely independent loan advising service and our directory of lenders gives you all the information lorem ipsums sitamets.<\\/p>\\r\\n<div class=\\\"content\\\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Consv peent esque urna. Ac eu fringilla intea dger egadv estas ut. Sed vulutate aenean nunc quis a urna morbi id vitae. Vulpuate nisl<\\/div>\",\"section_3_heading\":\"What We Offer?\",\"section_3_content\":\"<p class=\\\"lead\\\">Our loan sanction is one of the quicke with eas documentation and doorstep lorem ipsum serviceullam dolor sitisi.<\\/p>\\r\\n<div class=\\\"content\\\">\\r\\n<ul>\\r\\n<li>Habit building in essential steps choose habit<\\/li>\\r\\n<li>Get an overview of Habit Calendars Latest Posts<\\/li>\\r\\n<li>Start building habit with Habitify on platform<\\/li>\\r\\n<\\/ul>\\r\\n<\\/div>\",\"team_status\":\"1\",\"team_heading\":\"People Behind Us\",\"team_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 08:51:55','2023-04-23 08:59:05'),
(37,'pricing_page','{\"title\":\"Pricing\",\"pricing_heading\":\"Check Our Pricing\",\"pricing_sub_heading\":\"Best pricing plan for all level of customers. Choose the best one for your business.\"}','2023-04-23 09:03:41','2023-04-24 04:49:49'),
(38,'features_page','{\"title\":\"Features\",\"features_status\":\"1\",\"features_heading\":\"Explore Our Features\",\"features_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:04:16','2023-04-23 09:04:16'),
(39,'blogs_page','{\"title\":\"Blogs\",\"blogs_status\":\"1\",\"blogs_heading\":\"Recent posts form our Blog\",\"blogs_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:06:31','2023-04-23 09:06:31'),
(40,'feq_page','{\"title\":\"FAQ\",\"features_status\":\"1\",\"features_heading\":\"Frequently Asked Questions\",\"features_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:08:17','2023-04-23 09:08:17'),
(41,'faq_page','{\"title\":\"FAQ\",\"faq_status\":\"1\",\"faq_heading\":\"Frequently Asked Questions\",\"faq_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\"}','2023-04-23 09:10:21','2023-04-23 09:10:21'),
(42,'contact_page','{\"title\":\"Get in touch\",\"contact_form_heading\":\"Let\\u2019s get connected\",\"contact_form_sub_heading\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form.\",\"contact_info_heading\":[\"Still Have Questions?\",\"Opening hours\",\"Office Address\"],\"contact_info_content\":[\" <span>Call Us We Will Be Happy To Help\\r\\n<br><a href=\\\"tel:+3301563965\\\">+3301563965<\\/a><\\/span>\",\"<span>Monday - Friday\\r\\n<br>9AM - 8PM (Eastern Time)<\\/span>\",\"<span>\\r\\n34 Balonne Street<br>\\r\\nDeauville, New South Wales<br>\\r\\nCountry  Australia\\r\\n<\\/span>\"],\"facebook_link\":\"#\",\"linkedin_link\":\"#\",\"twitter_link\":\"#\",\"youtube_link\":\"#\"}','2023-04-23 09:15:58','2023-04-23 09:59:36'),
(43,'header_footer_page','{\"top_header_color\":\"#5034fc\",\"footer_color\":\"#061E5C\",\"widget_1_heading\":\"About Us\",\"widget_1_content\":\"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.\",\"widget_2_heading\":\"Customer Service\",\"widget_2_menus\":[\"faq\",\"contact\",\"terms-condition\",\"privacy-policy\"],\"widget_3_heading\":\"Quick Explore\",\"widget_3_menus\":[\"home\",\"about\",\"features\",\"pricing\",\"blogs\"],\"copyright_text\":\"<p>Copyright \\u00a9 2023 <a href=\\\"#\\\" target=\\\"_blank\\\">Hobby Tech<\\/a>  -  All Rights Reserved.<\\/p>\",\"custom_css\":\"\"}','2023-04-23 11:27:32','2023-04-24 05:42:29'),
(55,'gdpr_cookie_consent_page','{\"cookie_consent_status\":\"1\",\"cookie_message\":\"We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking \\\"Accept\\\", you consent to our use of cookies.\"}','2023-05-18 02:26:05','2023-05-19 11:10:12'),
(56,'address','Banani, Dhaka.','2024-09-09 06:23:20','2024-09-09 06:23:20'),
(57,'logo','logo.png','2024-09-09 06:24:53','2024-09-09 06:24:53'),
(58,'country','Bangladesh','2024-09-09 08:42:44','2024-09-10 05:20:13'),
(59,'date_format','d-m-Y','2024-09-09 08:42:44','2024-09-10 05:20:13'),
(60,'time_format','12','2024-09-09 08:42:44','2024-09-10 05:20:13'),
(61,'website_enable','1','2024-09-09 08:42:44','2024-09-10 05:20:13');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_payments`
--

DROP TABLE IF EXISTS `subscription_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subscription_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `order_id` varchar(191) NOT NULL,
  `payment_method` varchar(20) NOT NULL,
  `package_id` bigint(20) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_user_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscription_payments_user_id_foreign` (`user_id`),
  CONSTRAINT `subscription_payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_payments`
--

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

--
-- Table structure for table `taxes`
--

DROP TABLE IF EXISTS `taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `tax_number` varchar(50) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `taxes_user_id_foreign` (`user_id`),
  KEY `taxes_business_id_foreign` (`business_id`),
  CONSTRAINT `taxes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `taxes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taxes`
--

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

--
-- Table structure for table `team_translations`
--

DROP TABLE IF EXISTS `team_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `role` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `team_translations_team_id_locale_unique` (`team_id`,`locale`),
  CONSTRAINT `team_translations_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `team_translations`
--

LOCK TABLES `team_translations` WRITE;
/*!40000 ALTER TABLE `team_translations` DISABLE KEYS */;
INSERT INTO `team_translations` VALUES
(1,1,'English---us','Jhon Doe','Founder & CEO','Serial angel investor and entrepreneur, Jack has founded multiple successful startups prior to Sigma.','2023-04-21 09:51:25','2023-04-24 04:41:11'),
(5,5,'English---us','Robert Costa','Technical Director','Serial angel investor and entrepreneur, Jack has founded multiple successful startups prior to Sigma.','2023-04-24 04:43:54','2023-04-24 04:43:54'),
(6,6,'English---us','Holly Lee','Support Enginner','Serial angel investor and entrepreneur, Jack has founded multiple successful startups prior to Sigma.','2023-04-24 04:44:15','2023-04-24 04:44:15');
/*!40000 ALTER TABLE `team_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teams`
--

DROP TABLE IF EXISTS `teams`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `teams`
--

LOCK TABLES `teams` WRITE;
/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
INSERT INTO `teams` VALUES
(1,'default/client-placeholder.png','2023-04-21 09:51:25','2023-04-24 04:43:04'),
(5,'default/client-placeholder.png','2023-04-24 04:43:54','2023-04-24 04:43:54'),
(6,'default/client-placeholder.png','2023-04-24 04:44:15','2023-04-24 04:44:15');
/*!40000 ALTER TABLE `teams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `testimonial_translations`
--

DROP TABLE IF EXISTS `testimonial_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimonial_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `testimonial_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `testimonial` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `testimonial_translations_testimonial_id_locale_unique` (`testimonial_id`,`locale`),
  CONSTRAINT `testimonial_translations_testimonial_id_foreign` FOREIGN KEY (`testimonial_id`) REFERENCES `testimonials` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testimonial_translations`
--

LOCK TABLES `testimonial_translations` WRITE;
/*!40000 ALTER TABLE `testimonial_translations` DISABLE KEYS */;
INSERT INTO `testimonial_translations` VALUES
(1,1,'English---us','Jhon Doe','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','2023-04-21 09:26:57','2023-04-21 09:26:57'),
(2,1,'Spanish---es','Jhon Doe','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','2023-04-21 09:36:25','2023-04-21 09:36:25'),
(3,2,'English---us','Jack Johnston','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','2023-04-24 02:24:31','2023-04-24 02:24:31'),
(4,3,'English---us','Axar Patel','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','2023-04-24 02:25:20','2023-04-24 02:25:20'),
(5,4,'English---us','Kathrina','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','2023-04-24 02:29:09','2023-04-24 02:29:09');
/*!40000 ALTER TABLE `testimonial_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `testimonials`
--

DROP TABLE IF EXISTS `testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimonials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testimonials`
--

LOCK TABLES `testimonials` WRITE;
/*!40000 ALTER TABLE `testimonials` DISABLE KEYS */;
INSERT INTO `testimonials` VALUES
(1,'default/client-placeholder.png','2023-04-21 09:26:57','2023-04-24 02:30:51'),
(2,'default/client-placeholder.png','2023-04-24 02:24:31','2023-04-24 02:31:06'),
(3,'default/client-placeholder.png','2023-04-24 02:25:20','2023-04-24 02:31:13'),
(4,'default/client-placeholder.png','2023-04-24 02:29:09','2023-04-24 02:31:21');
/*!40000 ALTER TABLE `testimonials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transaction_categories`
--

DROP TABLE IF EXISTS `transaction_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transaction_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `color` varchar(20) NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(15) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transaction_categories_user_id_foreign` (`user_id`),
  KEY `transaction_categories_business_id_foreign` (`business_id`),
  CONSTRAINT `transaction_categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transaction_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction_categories`
--

LOCK TABLES `transaction_categories` WRITE;
/*!40000 ALTER TABLE `transaction_categories` DISABLE KEYS */;
INSERT INTO `transaction_categories` VALUES
(1,'telecom','#895555',NULL,'income',2,1,2,NULL,'2024-12-29 10:33:41','2024-12-29 10:33:41');
/*!40000 ALTER TABLE `transaction_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transaction_methods`
--

DROP TABLE IF EXISTS `transaction_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transaction_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction_methods`
--

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

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trans_date` datetime NOT NULL,
  `account_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_category_id` bigint(20) unsigned DEFAULT NULL,
  `dr_cr` varchar(2) NOT NULL,
  `type` varchar(20) NOT NULL COMMENT 'income|expense|transfer|others',
  `amount` decimal(28,8) NOT NULL,
  `currency_rate` decimal(28,8) NOT NULL,
  `ref_amount` decimal(28,8) DEFAULT NULL,
  `method` varchar(100) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `ref_id` bigint(20) DEFAULT NULL,
  `ref_type` varchar(191) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `vendor_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactions_user_id_foreign` (`user_id`),
  KEY `transactions_business_id_foreign` (`business_id`),
  KEY `transactions_account_id_foreign` (`account_id`),
  KEY `transactions_transaction_category_id_foreign` (`transaction_category_id`),
  CONSTRAINT `transactions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_transaction_category_id_foreign` FOREIGN KEY (`transaction_category_id`) REFERENCES `transaction_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

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

--
-- Table structure for table `user_invitations`
--

DROP TABLE IF EXISTS `user_invitations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_invitations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) NOT NULL,
  `sender_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_invitations`
--

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

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `user_type` varchar(20) NOT NULL COMMENT 'admin | user',
  `membership_type` varchar(50) DEFAULT NULL COMMENT 'trial | member',
  `package_id` bigint(20) DEFAULT NULL,
  `subscription_date` date DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `profile_picture` varchar(191) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `zip` varchar(30) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `t_email_send_at` timestamp NULL DEFAULT NULL,
  `s_email_send_at` timestamp NULL DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `provider_id` varchar(191) DEFAULT NULL,
  `custom_fields` text DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `referrer_id` bigint(20) unsigned DEFAULT NULL,
  `referral_status` tinyint(4) NOT NULL DEFAULT 0,
  `referral_token` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_referral_token_unique` (`referral_token`),
  KEY `users_referrer_id_foreign` (`referrer_id`),
  CONSTRAINT `users_referrer_id_foreign` FOREIGN KEY (`referrer_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Abdullah Al Kafi','kafi@weblinkltd.com','admin',NULL,NULL,NULL,1,'default.png','2024-09-09 00:20:36','$2y$10$FFspplSUbyG59HmLVCElouitGiYHX6HRu1auX9QxCrK5kyFeT/BuO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vE3bZcjiMQdfEUlMSQM7Y7BiQXvM5E50dxXKzjGDZ78Vx5X20jvi7FKVxuDo',NULL,0,NULL,'2024-09-09 00:20:36','2024-09-09 00:20:36'),
(2,'Enrich Coder','kafi@enrich.com','user','member',8,'2024-09-09',1,'default.png',NULL,'$2y$10$rWmXijEj3Mv3nvaGb7pIYOVmGiPq/of/bvowmxEUW1qCGrCi1USxq',NULL,NULL,NULL,NULL,NULL,'2049-09-09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'j6niiaXeaHvS05u','2024-09-09 06:28:08','2024-09-09 06:28:08');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `business_id` bigint(20) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `registration_no` varchar(191) DEFAULT NULL,
  `vat_id` varchar(191) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `currency` varchar(10) NOT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `zip` varchar(191) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `profile_picture` varchar(191) DEFAULT NULL,
  `custom_fields` text DEFAULT NULL,
  `created_user_id` bigint(20) DEFAULT NULL,
  `updated_user_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendors_user_id_foreign` (`user_id`),
  KEY `vendors_business_id_foreign` (`business_id`),
  CONSTRAINT `vendors_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE,
  CONSTRAINT `vendors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendors`
--

LOCK TABLES `vendors` WRITE;
/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendors` 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 2026-05-05 15:36:33
