File: /home/GemsPile/gemspile_init_database.sql
/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.6.21-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: GemsPile_k2lg1fh2RH0spDb0
-- ------------------------------------------------------
-- Server version 10.6.21-MariaDB-0ubuntu0.22.04.2
/*!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,
`name` varchar(50) NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts`
--
LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` VALUES (1,'Akaal Creatives',NULL,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL);
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `activity_log`
--
DROP TABLE IF EXISTS `activity_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`log_name` varchar(255) DEFAULT NULL,
`description` text NOT NULL,
`subject_type` varchar(255) DEFAULT NULL,
`event` varchar(255) DEFAULT NULL,
`subject_id` bigint(20) unsigned DEFAULT NULL,
`causer_type` varchar(255) DEFAULT NULL,
`causer_id` bigint(20) unsigned DEFAULT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`batch_uuid` char(36) DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `subject` (`subject_type`,`subject_id`),
KEY `causer` (`causer_type`,`causer_id`),
KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `activity_log`
--
LOCK TABLES `activity_log` WRITE;
/*!40000 ALTER TABLE `activity_log` DISABLE KEYS */;
INSERT INTO `activity_log` VALUES (1,'User','User has been created.','App\\Models\\User','created',1,NULL,NULL,'[]',NULL,1,'2024-07-05 10:41:13','2024-07-05 10:41:13'),(2,'Role','Role has been created.','App\\Models\\Role','created',1,NULL,NULL,'[]',NULL,1,'2024-07-05 10:41:13','2024-07-05 10:41:13'),(3,'Role','Role has been created.','App\\Models\\Role','created',2,NULL,NULL,'[]',NULL,1,'2024-07-05 10:41:13','2024-07-05 10:41:13'),(4,'Setting','Settings has been saved.','App\\Models\\User',NULL,1,'App\\Models\\User',1,'{\"name\":\"GemsPile Invoice Manager\",\"currency_code\":\"INR\",\"language\":\"en\",\"per_page\":\"10\",\"default_locale\":\"en-US\",\"fraction\":\"2\",\"item_units\":null,\"invoice_status\":\"badge\",\"initial_rows\":\"2\",\"reference\":\"ai\",\"hour12\":\"1\",\"timezone\":\"Asia\\/Kolkata\",\"show_tax\":\"0\",\"product_discount\":\"0\",\"create_user\":\"0\",\"impersonation\":\"0\",\"login_logo\":\"https:\\/\\/kh.gemspile.com\\/img\\/images\\/3ccAIMXU9GeQExqZGaMQp14jMSBBIH3I7cQu2am6.png\",\"invoice_logo\":\"https:\\/\\/kh.gemspile.com\\/img\\/images\\/QjXRHnnmkPZW3ZLmFuZk799k7e7NYvS2F4HdOTWy.png\",\"attachment_exts\":\"jpg,png,pdf,xlsx,docx,zip\",\"date_format\":\"js\",\"php_date_format\":\"Y-m-d\",\"prefer_company_email\":\"0\",\"mail_from_address\":\"[email protected]\",\"mail_from_name\":\"GemsPile Invoice Manager\",\"mail_default\":\"smtp\",\"mail_mailers_smtp_host\":\"127.0.0.1\",\"mail_mailers_smtp_port\":\"2525\",\"mail_mailers_smtp_username\":null,\"mail_mailers_smtp_password\":null,\"mail_mailers_smtp_encryption\":null,\"services_mailgun_domain\":null,\"services_mailgun_secret\":null,\"services_mailgun_endpoint\":null,\"services_sparkpost_secret\":null,\"services_sparkpost_endpoint\":null,\"services_ses_key\":null,\"services_ses_secret\":null,\"services_ses_region\":null,\"paypal\":{\"enabled\":\"0\"},\"stripe\":{\"enabled\":\"0\"}}',NULL,1,'2025-05-08 13:05:17','2025-05-08 13:05:17');
/*!40000 ALTER TABLE `activity_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attachments`
--
DROP TABLE IF EXISTS `attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attachments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(64) NOT NULL,
`disk` varchar(32) NOT NULL,
`filepath` varchar(512) NOT NULL,
`filename` varchar(255) NOT NULL,
`filetype` varchar(512) NOT NULL,
`filesize` int(10) unsigned NOT NULL,
`key` varchar(64) DEFAULT NULL,
`group` varchar(255) DEFAULT NULL,
`title` varchar(92) DEFAULT NULL,
`description` text DEFAULT NULL,
`preview_url` varchar(512) DEFAULT NULL,
`model_id` int(10) unsigned DEFAULT NULL,
`model_type` varchar(512) DEFAULT NULL,
`metadata` longtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `attachments_uuid_index` (`uuid`),
KEY `attachments_model_id_index` (`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attachments`
--
LOCK TABLES `attachments` WRITE;
/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `calendar`
--
DROP TABLE IF EXISTS `calendar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `calendar` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`start` datetime NOT NULL,
`end` datetime NOT NULL,
`color` varchar(7) NOT NULL,
`description` varchar(255) NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `calendar`
--
LOCK TABLES `calendar` WRITE;
/*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
/*!40000 ALTER TABLE `calendar` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `companies`
--
DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `companies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`contact_person` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`postal_code` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`ss_image` varchar(255) DEFAULT NULL,
`logo` varchar(255) DEFAULT NULL,
`active` tinyint(1) DEFAULT 1,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`show_name` tinyint(1) DEFAULT 1,
`logo_dark` varchar(255) DEFAULT NULL,
`show_address` tinyint(1) DEFAULT NULL,
`allow_transfer` tinyint(1) DEFAULT NULL,
`bank_account_details` varchar(255) DEFAULT NULL,
`qrcode` varchar(255) 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 `companies`
--
LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
/*!40000 ALTER TABLE `companies` 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,
`name` varchar(255) NOT NULL,
`company` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`postal_code` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`active` tinyint(1) DEFAULT 1,
`user_id` bigint(20) unsigned NOT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`balance` decimal(25,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (`id`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estimate_item_tax_rate`
--
DROP TABLE IF EXISTS `estimate_item_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_item_tax_rate` (
`estimate_item_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estimate_item_tax_rate`
--
LOCK TABLES `estimate_item_tax_rate` WRITE;
/*!40000 ALTER TABLE `estimate_item_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimate_item_tax_rate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estimate_items`
--
DROP TABLE IF EXISTS `estimate_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_items` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`estimate_id` bigint(20) unsigned NOT NULL,
`product_id` bigint(20) unsigned DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`quantity` decimal(20,2) NOT NULL,
`price` decimal(20,2) NOT NULL,
`net_price` decimal(20,2) NOT NULL,
`unit_price` decimal(20,2) NOT NULL,
`tax_amount` decimal(20,2) NOT NULL,
`total_tax_amount` decimal(20,2) DEFAULT NULL,
`discount` varchar(255) DEFAULT NULL,
`discount_amount` decimal(20,2) NOT NULL,
`total_discount_amount` decimal(20,2) DEFAULT NULL,
`tax_method` varchar(255) DEFAULT 'exclusive',
`total` decimal(20,2) NOT NULL,
`details` text DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`unit` text 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 `estimate_items`
--
LOCK TABLES `estimate_items` WRITE;
/*!40000 ALTER TABLE `estimate_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimate_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estimate_tax_rate`
--
DROP TABLE IF EXISTS `estimate_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_tax_rate` (
`estimate_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estimate_tax_rate`
--
LOCK TABLES `estimate_tax_rate` WRITE;
/*!40000 ALTER TABLE `estimate_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimate_tax_rate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estimates`
--
DROP TABLE IF EXISTS `estimates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimates` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`reference` varchar(255) NOT NULL,
`hash` varchar(255) NOT NULL,
`company_id` bigint(20) unsigned NOT NULL,
`customer_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`status` varchar(255) DEFAULT NULL,
`note` text DEFAULT NULL,
`total` decimal(20,2) DEFAULT NULL,
`total_tax` decimal(20,2) DEFAULT NULL,
`grand_total` decimal(20,2) DEFAULT NULL,
`shipping` decimal(20,2) DEFAULT NULL,
`tax_method` varchar(255) DEFAULT NULL,
`order_tax_amount` decimal(20,2) DEFAULT NULL,
`product_tax_amount` decimal(20,2) DEFAULT NULL,
`total_tax_amount` decimal(20,2) DEFAULT NULL,
`order_discount` varchar(255) DEFAULT NULL,
`order_discount_amount` decimal(20,2) DEFAULT NULL,
`product_discount_amount` decimal(20,2) DEFAULT NULL,
`total_discount_amount` decimal(20,2) DEFAULT NULL,
`attachment` varchar(255) DEFAULT NULL,
`paid` decimal(20,2) NOT NULL DEFAULT 0.00,
`recurring` tinyint(4) DEFAULT 0,
`repeat` varchar(255) DEFAULT NULL,
`create_before` tinyint(4) DEFAULT NULL,
`last_created_at` date DEFAULT NULL,
`next_create_date` date DEFAULT NULL,
`estimate_id` bigint(20) unsigned DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext DEFAULT NULL,
`due_date` date DEFAULT NULL,
`receipt` varchar(255) DEFAULT NULL,
`deleted_at` timestamp NULL 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 `estimates`
--
LOCK TABLES `estimates` WRITE;
/*!40000 ALTER TABLE `estimates` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimates` 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,
`uuid` varchar(255) NOT NULL,
`connection` text NOT NULL,
`queue` text NOT NULL,
`payload` longtext NOT NULL,
`exception` longtext NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) 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 `fields`
--
DROP TABLE IF EXISTS `fields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fields` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`models` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`slug` varchar(255) NOT NULL,
`order` varchar(255) DEFAULT NULL,
`options` varchar(255) DEFAULT NULL,
`show` tinyint(1) DEFAULT NULL,
`required` tinyint(1) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `fields_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fields`
--
LOCK TABLES `fields` WRITE;
/*!40000 ALTER TABLE `fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `fields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invoice_item_tax_rate`
--
DROP TABLE IF EXISTS `invoice_item_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_item_tax_rate` (
`invoice_item_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invoice_item_tax_rate`
--
LOCK TABLES `invoice_item_tax_rate` WRITE;
/*!40000 ALTER TABLE `invoice_item_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoice_item_tax_rate` 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 DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`quantity` decimal(20,2) NOT NULL,
`price` decimal(20,2) NOT NULL,
`net_price` decimal(20,2) NOT NULL,
`unit_price` decimal(20,2) NOT NULL,
`tax_amount` decimal(20,2) NOT NULL,
`total_tax_amount` decimal(20,2) DEFAULT NULL,
`discount` varchar(255) DEFAULT NULL,
`discount_amount` decimal(20,2) NOT NULL,
`total_discount_amount` decimal(20,2) DEFAULT NULL,
`tax_method` varchar(255) DEFAULT 'exclusive',
`total` decimal(20,2) NOT NULL,
`details` text DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`unit` text 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 `invoice_items`
--
LOCK TABLES `invoice_items` WRITE;
/*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `invoice_tax_rate`
--
DROP TABLE IF EXISTS `invoice_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_tax_rate` (
`invoice_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `invoice_tax_rate`
--
LOCK TABLES `invoice_tax_rate` WRITE;
/*!40000 ALTER TABLE `invoice_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoice_tax_rate` 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,
`date` date NOT NULL,
`reference` varchar(255) NOT NULL,
`hash` varchar(255) NOT NULL,
`company_id` bigint(20) unsigned NOT NULL,
`customer_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`status` varchar(255) DEFAULT NULL,
`note` text DEFAULT NULL,
`total` decimal(20,2) DEFAULT NULL,
`total_tax` decimal(20,2) DEFAULT NULL,
`grand_total` decimal(20,2) DEFAULT NULL,
`shipping` decimal(20,2) DEFAULT NULL,
`tax_method` varchar(255) DEFAULT NULL,
`order_tax_amount` decimal(20,2) DEFAULT NULL,
`product_tax_amount` decimal(20,2) DEFAULT NULL,
`total_tax_amount` decimal(20,2) DEFAULT NULL,
`order_discount` varchar(255) DEFAULT NULL,
`order_discount_amount` decimal(20,2) DEFAULT NULL,
`product_discount_amount` decimal(20,2) DEFAULT NULL,
`total_discount_amount` decimal(20,2) DEFAULT NULL,
`attachment` varchar(255) DEFAULT NULL,
`paid` decimal(20,2) NOT NULL DEFAULT 0.00,
`recurring` tinyint(1) DEFAULT 0,
`repeat` varchar(255) DEFAULT NULL,
`create_before` tinyint(4) DEFAULT NULL,
`last_created_at` date DEFAULT NULL,
`next_create_date` date DEFAULT NULL,
`invoice_id` bigint(20) unsigned DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`due_date` date DEFAULT NULL,
`receipt` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `invoices_date_index` (`date`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `invoices` 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(255) NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 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_01_01_000003_create_accounts_table',1),(2,'2014_10_12_000000_create_users_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2014_10_12_200000_add_two_factor_columns_to_users_table',1),(5,'2019_08_19_000000_create_failed_jobs_table',1),(6,'2019_12_14_000001_create_personal_access_tokens_table',1),(7,'2022_06_17_044135_create_products_table',1),(8,'2022_06_17_044736_create_calendar_table',1),(9,'2022_06_17_044736_create_companies_table',1),(10,'2022_06_17_044829_create_customers_table',1),(11,'2022_06_17_044918_create_invoices_table',1),(12,'2022_06_17_044927_create_quotations_table',1),(13,'2022_06_19_032931_create_settings_table',1),(14,'2022_07_01_081206_create_notes_table',1),(15,'2022_07_01_081206_create_payments_table',1),(16,'2022_07_01_081206_create_sessions_table',1),(17,'2022_07_01_081206_create_tax_rates_table',1),(18,'2022_09_06_070203_create_activity_log_table',1),(19,'2022_09_06_070204_add_event_column_to_activity_log_table',1),(20,'2022_09_06_070205_add_batch_uuid_column_to_activity_log_table',1),(21,'2022_09_08_094544_create_permission_tables',1),(22,'2022_09_09_142024_update_users_tables',1),(23,'2022_10_30_064241_create_fields_table',1),(24,'2022_11_01_083221_create_product_tax_table',1),(25,'2022_11_18_105251_create_transactions_table',1),(26,'2022_10_31_105524_create_attachments_table',2),(27,'2020_05_21_100000_create_teams_table',3),(28,'2020_05_21_200000_create_team_user_table',3),(29,'2020_05_21_300000_create_team_invitations_table',3),(30,'2023_09_11_034405_add_due_date_to_invoices_table',4),(31,'2023_09_11_035153_add_expiry_date_to_quotations_table',5),(32,'2024_02_04_032901_add_show_name_to_companies_table',6),(33,'2024_03_08_091313_add_logo_dark_to_companies_table',6),(35,'2024_04_05_065628_add_bank_fields_to_companies_table',7),(37,'2024_04_05_082244_add_receipt_to_invoices_table',8),(38,'2024_10_17_101509_create_schedules_table',9),(39,'2024_10_18_103934_add_estimate_tables',9),(40,'2024_11_03_082312_create_signatures_table',9),(41,'2025_04_03_071556_add_unit_column_to_all_items_tables',9);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `model_has_permissions`
--
DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
`permission_id` bigint(20) unsigned NOT NULL,
`model_type` varchar(255) NOT NULL,
`model_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`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 `model_has_permissions`
--
LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `model_has_roles`
--
DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
`role_id` bigint(20) unsigned NOT NULL,
`model_type` varchar(255) NOT NULL,
`model_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`role_id`,`model_id`,`model_type`),
KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `model_has_roles`
--
LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notes`
--
DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notes` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`details` text NOT NULL,
`default_sale` tinyint(1) DEFAULT 0,
`default_quote` tinyint(1) DEFAULT 0,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `notes_name_index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notes`
--
LOCK TABLES `notes` WRITE;
/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_resets`
--
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
`email` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_resets`
--
LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payments`
--
DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`reference` varchar(255) NOT NULL,
`hash` varchar(255) NOT NULL,
`amount` decimal(20,2) NOT NULL,
`method` varchar(255) DEFAULT NULL,
`company_id` bigint(20) unsigned NOT NULL,
`customer_id` bigint(20) unsigned NOT NULL,
`invoice_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`note` text DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`fees` varchar(20) DEFAULT NULL,
`transaction_id` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`receipt_url` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`estimate_id` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `payments_company_id_foreign` (`company_id`),
KEY `payments_customer_id_foreign` (`customer_id`),
KEY `payments_invoice_id_foreign` (`invoice_id`),
KEY `payments_user_id_foreign` (`user_id`),
KEY `payments_date_index` (`date`),
CONSTRAINT `payments_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `payments_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `payments_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payments`
--
LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `payments` 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,
`name` varchar(255) NOT NULL,
`guard_name` varchar(255) NOT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=50 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,'create-settings','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(2,'read-settings','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(3,'read-activity','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(4,'create-customers','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(5,'read-customers','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(6,'update-customers','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(7,'delete-customers','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(8,'import-customers','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(9,'create-invoices','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(10,'read-invoices','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(11,'update-invoices','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(12,'delete-invoices','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(13,'create-payments','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(14,'read-payments','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(15,'update-payments','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(16,'delete-payments','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(17,'create-quotations','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(18,'read-quotations','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(19,'update-quotations','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(20,'delete-quotations','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(21,'create-items','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(22,'read-items','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(23,'update-items','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(24,'delete-items','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(25,'import-items','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(26,'create-companies','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(27,'read-companies','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(28,'update-companies','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(29,'delete-companies','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(30,'create-tax-rates','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(31,'read-tax-rates','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(32,'update-tax-rates','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(33,'delete-tax-rates','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(34,'create-notes','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(35,'read-notes','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(36,'update-notes','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(37,'delete-notes','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(38,'create-fields','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(39,'read-fields','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(40,'update-fields','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(41,'delete-fields','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(42,'create-users','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(43,'read-users','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(44,'update-users','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(45,'delete-users','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(46,'create-roles','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(47,'read-roles','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(48,'update-roles','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL),(49,'delete-roles','web',1,'2024-07-05 10:41:14','2024-07-05 10:41:14',NULL);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `personal_access_tokens`
--
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(255) NOT NULL,
`tokenable_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`token` varchar(64) NOT NULL,
`abilities` text DEFAULT NULL,
`last_used_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `personal_access_tokens`
--
LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `product_tax_rate`
--
DROP TABLE IF EXISTS `product_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_tax_rate` (
`product_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product_tax_rate`
--
LOCK TABLES `product_tax_rate` WRITE;
/*!40000 ALTER TABLE `product_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_tax_rate` 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(255) NOT NULL,
`price` decimal(15,2) NOT NULL,
`photo` varchar(255) DEFAULT NULL,
`tax_rate_id` bigint(20) unsigned DEFAULT NULL,
`tax_method` varchar(255) DEFAULT NULL,
`details` text DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`unit` text DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `products_name_unique` (`name`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `quotation_item_tax_rate`
--
DROP TABLE IF EXISTS `quotation_item_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotation_item_tax_rate` (
`quotation_item_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quotation_item_tax_rate`
--
LOCK TABLES `quotation_item_tax_rate` WRITE;
/*!40000 ALTER TABLE `quotation_item_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `quotation_item_tax_rate` 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 DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`quantity` decimal(20,2) NOT NULL,
`price` decimal(20,2) NOT NULL,
`net_price` decimal(20,2) NOT NULL,
`unit_price` decimal(20,2) NOT NULL,
`tax_amount` decimal(20,2) NOT NULL,
`total_tax_amount` decimal(20,2) DEFAULT NULL,
`discount` varchar(255) DEFAULT NULL,
`discount_amount` decimal(20,2) NOT NULL,
`total_discount_amount` decimal(20,2) DEFAULT NULL,
`tax_method` varchar(255) DEFAULT 'exclusive',
`total` decimal(20,2) NOT NULL,
`details` text DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`unit` text 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 `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 `quotation_tax_rate`
--
DROP TABLE IF EXISTS `quotation_tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotation_tax_rate` (
`quotation_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quotation_tax_rate`
--
LOCK TABLES `quotation_tax_rate` WRITE;
/*!40000 ALTER TABLE `quotation_tax_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `quotation_tax_rate` 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,
`date` date NOT NULL,
`reference` varchar(255) NOT NULL,
`hash` varchar(255) NOT NULL,
`company_id` bigint(20) unsigned NOT NULL,
`customer_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`status` varchar(255) DEFAULT NULL,
`note` text DEFAULT NULL,
`total` decimal(20,2) DEFAULT NULL,
`total_tax` decimal(20,2) DEFAULT NULL,
`grand_total` decimal(20,2) DEFAULT NULL,
`shipping` decimal(20,2) DEFAULT NULL,
`tax_method` varchar(255) DEFAULT NULL,
`order_tax_amount` decimal(20,2) DEFAULT NULL,
`product_tax_amount` decimal(20,2) DEFAULT NULL,
`total_tax_amount` decimal(20,2) DEFAULT NULL,
`order_discount` varchar(255) DEFAULT NULL,
`order_discount_amount` decimal(20,2) DEFAULT NULL,
`product_discount_amount` decimal(20,2) DEFAULT NULL,
`total_discount_amount` decimal(20,2) DEFAULT NULL,
`attachment` varchar(255) DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`expiry_date` date DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `quotations_date_index` (`date`)
) 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 `role_has_permissions`
--
DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
`permission_id` bigint(20) unsigned NOT NULL,
`role_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`role_id`),
KEY `role_has_permissions_role_id_foreign` (`role_id`),
CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `role_has_permissions`
--
LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES (10,2),(14,2),(18,2);
/*!40000 ALTER TABLE `role_has_permissions` 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(255) NOT NULL,
`guard_name` varchar(255) NOT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 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,'admin','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL),(2,'customer','web',1,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL);
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `schedules`
--
DROP TABLE IF EXISTS `schedules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `schedules` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`note` varchar(255) DEFAULT NULL,
`model_type` varchar(255) DEFAULT NULL,
`model_id` bigint(20) unsigned DEFAULT NULL,
`remind_on` date NOT NULL,
`status` varchar(255) DEFAULT NULL,
`customer_id` bigint(20) unsigned DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `schedules_model_type_model_id_index` (`model_type`,`model_id`),
KEY `schedules_customer_id_foreign` (`customer_id`),
KEY `schedules_account_id_foreign` (`account_id`),
KEY `schedules_user_id_foreign` (`user_id`),
CONSTRAINT `schedules_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
CONSTRAINT `schedules_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
CONSTRAINT `schedules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `schedules`
--
LOCK TABLES `schedules` WRITE;
/*!40000 ALTER TABLE `schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
`id` varchar(255) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`ip_address` varchar(45) DEFAULT NULL,
`user_agent` text DEFAULT NULL,
`payload` longtext NOT NULL,
`last_activity` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_user_id_index` (`user_id`),
KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sessions`
--
LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('BmN1t7NECA127q6HxonmtzAHQ8emBMxwHxJX0wcm',NULL,'172.71.134.186','Links (2.22; Linux X86_64; GNU C; text)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidXR1WlhFWUc3NW4yUXFxSmRVNDJIeWtYV2lwSnRydmNOTFI1U0p6QSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxOToiaHR0cHM6Ly96LmFrYWFsLmJpeiI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI1OiJodHRwczovL3ouYWthYWwuYml6L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1720176203),('GiGWSelubhSqQfXJ9n0Gofy0AUzl2BQMdCBab0LE',1,'172.71.186.120','Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiSXh1N3VlQlpZRUhTODkyUE9vaTlxSWNzcDJTVFlpWTJxM0ZFVEpERSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI1OiJodHRwczovL3ouYWthYWwuYml6L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMCQzNG9QTW9EZmZGcjFPZGF2ejB5NllPeEQ4S2NBUHp1cWxOS2VTblBqRExIZmFtODhUUkRZNiI7fQ==',1720176415),('gkxeAtTRR1b4bvVPyRoXTHVvsxQutty1RWQRotZ1',NULL,'172.71.135.59','WhatsApp/2','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRlRLUWJ1TDlMdXZlbVc3YVlMZU8zY2NobHJEWVNUc2FkeEl0Vm1VdiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxOToiaHR0cHM6Ly96LmFrYWFsLmJpeiI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjE5OiJodHRwczovL3ouYWthYWwuYml6Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1720176220),('vj1L55W692CcTZoF29IxJST8FhYnfpKLz0DQy2xt',1,'188.114.102.107','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:127.0) Gecko/20100101 Firefox/127.0','YTo2OntzOjY6Il90b2tlbiI7czo0MDoicGxIVFBYUTYzWWJZY3J2c3hFSzF0MXZobm85dFlMTG5ZcFRQTlVHNyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI1OiJodHRwczovL3ouYWthYWwuYml6L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMCQzNG9QTW9EZmZGcjFPZGF2ejB5NllPeEQ4S2NBUHp1cWxOS2VTblBqRExIZmFtODhUUkRZNiI7fQ==',1720176723),('XhKts72gXQmz9QvRDN9JoLJfoFKAChpo7jtylkYm',NULL,'172.71.186.120','WhatsApp/2','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMEV3eUNMTGJGUHJOZVBuNWtvTVh4NnVkSU00OUN5bEFPbTNRRWhwMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vei5ha2FhbC5iaXovbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1720176221);
/*!40000 ALTER TABLE `sessions` 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,
`tec_key` varchar(255) NOT NULL,
`tec_value` text DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `settings_tec_key_index` (`tec_key`)
) ENGINE=InnoDB AUTO_INCREMENT=41 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,'name','GemsPile Invoice Manager',1),(2,'per_page','10',1),(3,'language','en',1),(4,'fraction','2',1),(5,'initial_rows','2',1),(6,'reference','ai',1),(7,'currency_code','INR',1),(8,'default_locale','en-US',1),(9,'hour12','1',1),(10,'invoice_status','badge',1),(11,'item_units',NULL,1),(12,'timezone','Asia/Kolkata',1),(13,'show_tax','0',1),(14,'product_discount','0',1),(15,'create_user','0',1),(16,'impersonation','0',1),(17,'login_logo','https://kh.gemspile.com/img/images/3ccAIMXU9GeQExqZGaMQp14jMSBBIH3I7cQu2am6.png',1),(18,'invoice_logo','https://kh.gemspile.com/img/images/QjXRHnnmkPZW3ZLmFuZk799k7e7NYvS2F4HdOTWy.png',1),(19,'attachment_exts','jpg,png,pdf,xlsx,docx,zip',1),(20,'date_format','js',1),(21,'php_date_format','Y-m-d',1),(22,'prefer_company_email','0',1),(23,'mail_from_address','[email protected]',1),(24,'mail_from_name','GemsPile Invoice Manager',1),(25,'mail_default','smtp',1),(26,'mail_mailers_smtp_host','127.0.0.1',1),(27,'mail_mailers_smtp_port','2525',1),(28,'mail_mailers_smtp_username',NULL,1),(29,'mail_mailers_smtp_password',NULL,1),(30,'mail_mailers_smtp_encryption',NULL,1),(31,'services_mailgun_domain',NULL,1),(32,'services_mailgun_secret',NULL,1),(33,'services_mailgun_endpoint',NULL,1),(34,'services_sparkpost_secret',NULL,1),(35,'services_sparkpost_endpoint',NULL,1),(36,'services_ses_key',NULL,1),(37,'services_ses_secret',NULL,1),(38,'services_ses_region',NULL,1),(39,'paypal','{\"enabled\":\"0\"}',1),(40,'stripe','{\"enabled\":\"0\"}',1);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `signatures`
--
DROP TABLE IF EXISTS `signatures`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `signatures` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`signable_type` varchar(255) NOT NULL,
`signable_id` bigint(20) unsigned NOT NULL,
`signed_at` timestamp NULL DEFAULT NULL,
`signee_name` text DEFAULT NULL,
`signee_ip` text DEFAULT NULL,
`signee_email` text DEFAULT NULL,
`signee_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
PRIMARY KEY (`id`),
KEY `signatures_signable_type_signable_id_index` (`signable_type`,`signable_id`),
KEY `signatures_signee_id_index` (`signee_id`),
CONSTRAINT `signatures_signee_id_foreign` FOREIGN KEY (`signee_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `signatures`
--
LOCK TABLES `signatures` WRITE;
/*!40000 ALTER TABLE `signatures` DISABLE KEYS */;
/*!40000 ALTER TABLE `signatures` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tax_rates`
--
DROP TABLE IF EXISTS `tax_rates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tax_rates` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`rate` decimal(20,4) NOT NULL,
`fixed` tinyint(1) DEFAULT 0,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_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 `tax_rates`
--
LOCK TABLES `tax_rates` WRITE;
/*!40000 ALTER TABLE `tax_rates` DISABLE KEYS */;
/*!40000 ALTER TABLE `tax_rates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team_invitations`
--
DROP TABLE IF EXISTS `team_invitations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_invitations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`team_id` bigint(20) unsigned NOT NULL,
`email` varchar(255) NOT NULL,
`role` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `team_invitations_team_id_email_unique` (`team_id`,`email`),
CONSTRAINT `team_invitations_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`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 `team_invitations`
--
LOCK TABLES `team_invitations` WRITE;
/*!40000 ALTER TABLE `team_invitations` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_invitations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team_user`
--
DROP TABLE IF EXISTS `team_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`team_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`role` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `team_user_team_id_user_id_unique` (`team_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `team_user`
--
LOCK TABLES `team_user` WRITE;
/*!40000 ALTER TABLE `team_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_user` 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,
`user_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`personal_team` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `teams_user_id_index` (`user_id`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `teams` 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,
`customer_id` bigint(20) unsigned NOT NULL,
`invoice_id` bigint(20) unsigned DEFAULT NULL,
`payment_id` bigint(20) unsigned DEFAULT NULL,
`amount` decimal(20,2) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`estimate_id` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `transactions_customer_id_foreign` (`customer_id`),
KEY `transactions_payment_id_foreign` (`payment_id`),
CONSTRAINT `transactions_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `transactions_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE ON UPDATE 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 `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(255) NOT NULL,
`email` varchar(255) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`two_factor_secret` text DEFAULT NULL,
`two_factor_recovery_codes` text DEFAULT NULL,
`two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`current_team_id` bigint(20) unsigned DEFAULT NULL,
`profile_photo_path` varchar(2048) DEFAULT NULL,
`account_id` bigint(20) unsigned NOT NULL,
`extra_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`view_all` tinyint(1) DEFAULT NULL,
`edit_all` tinyint(1) DEFAULT NULL,
`customer_id` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
KEY `users_customer_id_foreign` (`customer_id`),
CONSTRAINT `users_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE 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 `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Akaal Creatives','[email protected]','2024-07-05 10:41:13','$2y$10$34oPMoDffFr1Odavz0y6YOxD8KcAPzuqlNKeSnPjDLHfam88TRDY6',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'2024-07-05 10:41:13','2024-07-05 10:41:13',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-05-09 0:07:27