Da

✏️ Editing: thaiddcc_lnwcpuvat.sql

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

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

--
-- Current Database: `thaiddcc_lnwcpuvat`
--

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

USE `thaiddcc_lnwcpuvat`;

--
-- 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 = utf8 */;
CREATE TABLE `activity_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(160) DEFAULT NULL,
  `description` text NOT NULL,
  `subject_id` bigint(20) unsigned DEFAULT NULL,
  `subject_type` varchar(160) DEFAULT NULL,
  `event` varchar(191) DEFAULT NULL,
  `causer_id` bigint(20) unsigned DEFAULT NULL,
  `causer_type` varchar(160) DEFAULT NULL,
  `properties` text DEFAULT NULL,
  `batch_uuid` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_log_log_name_index` (`log_name`),
  KEY `subject` (`subject_id`,`subject_type`),
  KEY `causer` (`causer_id`,`causer_type`)
) ENGINE=InnoDB AUTO_INCREMENT=57 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,'default','default.setting has been Created',1,'Gainhq\\Installer\\App\\Models\\Setting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:23','2024-05-28 00:53:23'),(2,'default','User has been Created',1,'Gainhq\\Installer\\App\\Models\\Core\\User','created',NULL,NULL,'{\"attributes\":{\"first_name\":\"Phuttiphan\",\"last_name\":\"Kapang\",\"email\":\"phuttiphankapang@hotmail.com\"}}',NULL,'2024-05-28 00:53:23','2024-05-28 00:53:23'),(3,'default','default.notification_setting has been Created',1,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(4,'default','created',1,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(5,'default','default.notification_setting has been Created',2,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(6,'default','created',2,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(7,'default','default.notification_setting has been Created',3,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(8,'default','created',3,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(9,'default','default.notification_setting has been Created',4,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(10,'default','created',4,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(11,'default','default.notification_setting has been Created',5,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(12,'default','created',5,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(13,'default','default.notification_setting has been Created',6,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(14,'default','created',6,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(15,'default','default.notification_setting has been Created',7,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(16,'default','created',7,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(17,'default','default.notification_setting has been Created',8,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(18,'default','created',8,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(19,'default','default.notification_setting has been Created',9,'App\\Models\\Core\\Setting\\NotificationSetting','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(20,'default','created',9,'App\\Models\\Core\\Setting\\NotificationAudience','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(21,'default','Notification Template has been Created',1,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(22,'default','Notification Template has been Created',2,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(23,'default','Notification Template has been Created',3,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(24,'default','Notification Template has been Created',4,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(25,'default','Notification Template has been Created',5,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(26,'default','Notification Template has been Created',6,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(27,'default','Notification Template has been Created',7,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(28,'default','Notification Template has been Created',8,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(29,'default','Notification Template has been Created',9,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(30,'default','Notification Template has been Created',10,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(31,'default','Notification Template has been Created',11,'App\\Models\\Core\\Notification\\NotificationTemplate','created',NULL,NULL,'[]',NULL,'2024-05-28 00:53:24','2024-05-28 00:53:24'),(32,'default','default.setting has been updated',2,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(33,'default','default.setting has been updated',9,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(34,'default','default.setting has been updated',10,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(35,'default','default.setting has been updated',11,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(36,'default','default.setting has been Created',18,'App\\Models\\Core\\Setting\\Setting','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(37,'default','default.setting has been Created',19,'App\\Models\\Core\\Setting\\Setting','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(38,'default','default.setting has been Created',20,'App\\Models\\Core\\Setting\\Setting','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:08:20','2024-05-28 01:08:20'),(39,'default','default.setting has been updated',16,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:11:46','2024-05-28 01:11:46'),(40,'default','created',1,'App\\Models\\Billar\\Tax\\Tax','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:12:04','2024-05-28 01:12:04'),(41,'default','default.setting has been updated',3,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:13:27','2024-05-28 01:13:27'),(42,'default','default.setting has been updated',4,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:13:27','2024-05-28 01:13:27'),(43,'default','default.setting has been updated',18,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:15:21','2024-05-28 01:15:21'),(44,'default','default.setting has been updated',19,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:15:21','2024-05-28 01:15:21'),(45,'default','default.setting has been updated',4,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 01:15:21','2024-05-28 01:15:21'),(46,'default','User has been Created',2,'App\\Models\\Core\\Auth\\User','created',1,'App\\Models\\Core\\Auth\\User','{\"attributes\":{\"first_name\":\"\\u0e17\\u0e14\\u0e2a\\u0e2d\\u0e1a\\u0e0a\\u0e37\\u0e48\\u0e2d\",\"last_name\":\"\\u0e25\\u0e39\\u0e01\\u0e04\\u0e49\\u0e32\",\"email\":\"xpothaha@gmail.com\"}}',NULL,'2024-05-28 02:04:30','2024-05-28 02:04:30'),(47,'default','created',1,'App\\Models\\Billar\\Client\\Client','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:04:30','2024-05-28 02:04:30'),(48,'default','created',1,'App\\Models\\Billar\\Product\\Product','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:05:30','2024-05-28 02:05:30'),(49,'default','created',1,'App\\Models\\Core\\File\\File','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:05:30','2024-05-28 02:05:30'),(50,'default','created',1,'App\\Models\\Billar\\Invoice\\Invoice','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:08:48','2024-05-28 02:08:48'),(51,'default','created',1,'App\\Models\\Billar\\Invoice\\InvoiceDetail','created',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:08:48','2024-05-28 02:08:48'),(52,'default','User has been updated',1,'App\\Models\\Core\\Auth\\User','updated',1,'App\\Models\\Core\\Auth\\User','{\"attributes\":{\"first_name\":\"\\u0e1e\\u0e38\\u0e12\\u0e34\\u0e1e\\u0e31\\u0e19\\u0e18\\u0e38\\u0e4c\",\"last_name\":\"\\u0e01\\u0e30\\u0e1e\\u0e31\\u0e07\"},\"old\":{\"first_name\":\"Phuttiphan\",\"last_name\":\"Kapang\"}}',NULL,'2024-05-28 02:12:43','2024-05-28 02:12:43'),(53,'default','default.setting has been updated',6,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:20:33','2024-05-28 02:20:33'),(54,'default','default.setting has been updated',19,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-05-28 02:20:33','2024-05-28 02:20:33'),(55,'default','User has been updated',1,'App\\Models\\Core\\Auth\\User','updated',1,'App\\Models\\Core\\Auth\\User','{\"attributes\":[],\"old\":[]}',NULL,'2024-06-03 07:56:43','2024-06-03 07:56:43'),(56,'default','default.setting has been updated',3,'App\\Models\\Core\\Setting\\Setting','updated',1,'App\\Models\\Core\\Auth\\User','[]',NULL,'2024-06-06 06:39:49','2024-06-06 06:39:49');
/*!40000 ALTER TABLE `activity_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(120) NOT NULL,
  `value` text NOT NULL,
  `expiration` int(11) NOT NULL,
  UNIQUE KEY `cache_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

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

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_name_unique` (`name`),
  KEY `categories_created_by_foreign` (`created_by`),
  CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

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

--
-- Table structure for table `client_addresses`
--

DROP TABLE IF EXISTS `client_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(191) NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_addresses_client_id_foreign` (`client_id`),
  CONSTRAINT `client_addresses_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`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 `client_addresses`
--

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

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_number` varchar(191) NOT NULL,
  `state` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country_id` bigint(20) unsigned DEFAULT NULL,
  `website_url` varchar(191) DEFAULT NULL,
  `notes` longtext DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clients_client_number_unique` (`client_number`),
  KEY `clients_user_id_foreign` (`user_id`),
  KEY `clients_country_id_foreign` (`country_id`),
  CONSTRAINT `clients_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `clients_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 `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,2,'1','อุบลราชธานี','เดชอุดม','34160',NULL,NULL,NULL,NULL,'2024-05-28 02:04:30','2024-05-28 02:04:30');
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `countries`
--

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

--
-- Dumping data for table `countries`
--

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1,'AF','Afghanistan',NULL,NULL),(2,'AX','Åland Islands',NULL,NULL),(3,'AL','Albania',NULL,NULL),(4,'DZ','Algeria',NULL,NULL),(5,'AS','American Samoa',NULL,NULL),(6,'AD','AndorrA',NULL,NULL),(7,'AO','Angola',NULL,NULL),(8,'AI','Anguilla',NULL,NULL),(9,'AQ','Antarctica',NULL,NULL),(10,'AG','Antigua and Barbuda',NULL,NULL),(11,'AR','Argentina',NULL,NULL),(12,'AM','Armenia',NULL,NULL),(13,'AW','Aruba',NULL,NULL),(14,'AU','Australia',NULL,NULL),(15,'AT','Austria',NULL,NULL),(16,'AZ','Azerbaijan',NULL,NULL),(17,'BS','Bahamas',NULL,NULL),(18,'BH','Bahrain',NULL,NULL),(19,'BD','Bangladesh',NULL,NULL),(20,'BB','Barbados',NULL,NULL),(21,'BY','Belarus',NULL,NULL),(22,'BE','Belgium',NULL,NULL),(23,'BZ','Belize',NULL,NULL),(24,'BJ','Benin',NULL,NULL),(25,'BM','Bermuda',NULL,NULL),(26,'BT','Bhutan',NULL,NULL),(27,'BO','Bolivia',NULL,NULL),(28,'BA','Bosnia and Herzegovina',NULL,NULL),(29,'BW','Botswana',NULL,NULL),(30,'BV','Bouvet Island',NULL,NULL),(31,'BR','Brazil',NULL,NULL),(32,'IO','British Indian Ocean Territory',NULL,NULL),(33,'BN','Brunei Darussalam',NULL,NULL),(34,'BG','Bulgaria',NULL,NULL),(35,'BF','Burkina Faso',NULL,NULL),(36,'BI','Burundi',NULL,NULL),(37,'KH','Cambodia',NULL,NULL),(38,'CM','Cameroon',NULL,NULL),(39,'CA','Canada',NULL,NULL),(40,'CV','Cape Verde',NULL,NULL),(41,'KY','Cayman Islands',NULL,NULL),(42,'CF','Central African Republic',NULL,NULL),(43,'TD','Chad',NULL,NULL),(44,'CL','Chile',NULL,NULL),(45,'CN','China',NULL,NULL),(46,'CX','Christmas Island',NULL,NULL),(47,'CC','Cocos (Keeling) Islands',NULL,NULL),(48,'CO','Colombia',NULL,NULL),(49,'KM','Comoros',NULL,NULL),(50,'CG','Congo',NULL,NULL),(51,'CD','Congo, The Democratic Republic of the',NULL,NULL),(52,'CK','Cook Islands',NULL,NULL),(53,'CR','Costa Rica',NULL,NULL),(54,'CI','Cote D\'Ivoire',NULL,NULL),(55,'HR','Croatia',NULL,NULL),(56,'CU','Cuba',NULL,NULL),(57,'CY','Cyprus',NULL,NULL),(58,'CZ','Czech Republic',NULL,NULL),(59,'DK','Denmark',NULL,NULL),(60,'DJ','Djibouti',NULL,NULL),(61,'DM','Dominica',NULL,NULL),(62,'DO','Dominican Republic',NULL,NULL),(63,'EC','Ecuador',NULL,NULL),(64,'EG','Egypt',NULL,NULL),(65,'SV','El Salvador',NULL,NULL),(66,'GQ','Equatorial Guinea',NULL,NULL),(67,'ER','Eritrea',NULL,NULL),(68,'EE','Estonia',NULL,NULL),(69,'ET','Ethiopia',NULL,NULL),(70,'FK','Falkland Islands (Malvinas)',NULL,NULL),(71,'FO','Faroe Islands',NULL,NULL),(72,'FJ','Fiji',NULL,NULL),(73,'FI','Finland',NULL,NULL),(74,'FR','France',NULL,NULL),(75,'GF','French Guiana',NULL,NULL),(76,'PF','French Polynesia',NULL,NULL),(77,'TF','French Southern Territories',NULL,NULL),(78,'GA','Gabon',NULL,NULL),(79,'GM','Gambia',NULL,NULL),(80,'GE','Georgia',NULL,NULL),(81,'DE','Germany',NULL,NULL),(82,'GH','Ghana',NULL,NULL),(83,'GI','Gibraltar',NULL,NULL),(84,'GR','Greece',NULL,NULL),(85,'GL','Greenland',NULL,NULL),(86,'GD','Grenada',NULL,NULL),(87,'GP','Guadeloupe',NULL,NULL),(88,'GU','Guam',NULL,NULL),(89,'GT','Guatemala',NULL,NULL),(90,'GG','Guernsey',NULL,NULL),(91,'GN','Guinea',NULL,NULL),(92,'GW','Guinea-Bissau',NULL,NULL),(93,'GY','Guyana',NULL,NULL),(94,'HT','Haiti',NULL,NULL),(95,'HM','Heard Island and Mcdonald Islands',NULL,NULL),(96,'VA','Holy See (Vatican City State)',NULL,NULL),(97,'HN','Honduras',NULL,NULL),(98,'HK','Hong Kong',NULL,NULL),(99,'HU','Hungary',NULL,NULL),(100,'IS','Iceland',NULL,NULL),(101,'IN','India',NULL,NULL),(102,'ID','Indonesia',NULL,NULL),(103,'IR','Iran, Islamic Republic Of',NULL,NULL),(104,'IQ','Iraq',NULL,NULL),(105,'IE','Ireland',NULL,NULL),(106,'IM','Isle of Man',NULL,NULL),(107,'IL','Israel',NULL,NULL),(108,'IT','Italy',NULL,NULL),(109,'JM','Jamaica',NULL,NULL),(110,'JP','Japan',NULL,NULL),(111,'JE','Jersey',NULL,NULL),(112,'JO','Jordan',NULL,NULL),(113,'KZ','Kazakhstan',NULL,NULL),(114,'KE','Kenya',NULL,NULL),(115,'KI','Kiribati',NULL,NULL),(116,'KP','Korea, Democratic People\'S Republic of',NULL,NULL),(117,'KR','Korea, Republic of',NULL,NULL),(118,'KW','Kuwait',NULL,NULL),(119,'KG','Kyrgyzstan',NULL,NULL),(120,'LA','Lao People\'S Democratic Republic',NULL,NULL),(121,'LV','Latvia',NULL,NULL),(122,'LB','Lebanon',NULL,NULL),(123,'LS','Lesotho',NULL,NULL),(124,'LR','Liberia',NULL,NULL),(125,'LY','Libyan Arab Jamahiriya',NULL,NULL),(126,'LI','Liechtenstein',NULL,NULL),(127,'LT','Lithuania',NULL,NULL),(128,'LU','Luxembourg',NULL,NULL),(129,'MO','Macao',NULL,NULL),(130,'MK','Macedonia, The Former Yugoslav Republic of',NULL,NULL),(131,'MG','Madagascar',NULL,NULL),(132,'MW','Malawi',NULL,NULL),(133,'MY','Malaysia',NULL,NULL),(134,'MV','Maldives',NULL,NULL),(135,'ML','Mali',NULL,NULL),(136,'MT','Malta',NULL,NULL),(137,'MH','Marshall Islands',NULL,NULL),(138,'MQ','Martinique',NULL,NULL),(139,'MR','Mauritania',NULL,NULL),(140,'MU','Mauritius',NULL,NULL),(141,'YT','Mayotte',NULL,NULL),(142,'MX','Mexico',NULL,NULL),(143,'FM','Micronesia, Federated States of',NULL,NULL),(144,'MD','Moldova, Republic of',NULL,NULL),(145,'MC','Monaco',NULL,NULL),(146,'MN','Mongolia',NULL,NULL),(147,'MS','Montserrat',NULL,NULL),(148,'MA','Morocco',NULL,NULL),(149,'MZ','Mozambique',NULL,NULL),(150,'MM','Myanmar',NULL,NULL),(151,'NA','Namibia',NULL,NULL),(152,'NR','Nauru',NULL,NULL),(153,'NP','Nepal',NULL,NULL),(154,'NL','Netherlands',NULL,NULL),(155,'AN','Netherlands Antilles',NULL,NULL),(156,'NC','New Caledonia',NULL,NULL),(157,'NZ','New Zealand',NULL,NULL),(158,'NI','Nicaragua',NULL,NULL),(159,'NE','Niger',NULL,NULL),(160,'NG','Nigeria',NULL,NULL),(161,'NU','Niue',NULL,NULL),(162,'NF','Norfolk Island',NULL,NULL),(163,'MP','Northern Mariana Islands',NULL,NULL),(164,'NO','Norway',NULL,NULL),(165,'OM','Oman',NULL,NULL),(166,'PK','Pakistan',NULL,NULL),(167,'PW','Palau',NULL,NULL),(168,'PS','Palestinian Territory, Occupied',NULL,NULL),(169,'PA','Panama',NULL,NULL),(170,'PG','Papua New Guinea',NULL,NULL),(171,'PY','Paraguay',NULL,NULL),(172,'PE','Peru',NULL,NULL),(173,'PH','Philippines',NULL,NULL),(174,'PN','Pitcairn',NULL,NULL),(175,'PL','Poland',NULL,NULL),(176,'PT','Portugal',NULL,NULL),(177,'PR','Puerto Rico',NULL,NULL),(178,'QA','Qatar',NULL,NULL),(179,'RE','Reunion',NULL,NULL),(180,'RO','Romania',NULL,NULL),(181,'RU','Russian Federation',NULL,NULL),(182,'RW','RWANDA',NULL,NULL),(183,'SH','Saint Helena',NULL,NULL),(184,'KN','Saint Kitts and Nevis',NULL,NULL),(185,'LC','Saint Lucia',NULL,NULL),(186,'PM','Saint Pierre and Miquelon',NULL,NULL),(187,'VC','Saint Vincent and the Grenadines',NULL,NULL),(188,'WS','Samoa',NULL,NULL),(189,'SM','San Marino',NULL,NULL),(190,'ST','Sao Tome and Principe',NULL,NULL),(191,'SA','Saudi Arabia',NULL,NULL),(192,'SN','Senegal',NULL,NULL),(193,'CS','Serbia and Montenegro',NULL,NULL),(194,'SC','Seychelles',NULL,NULL),(195,'SL','Sierra Leone',NULL,NULL),(196,'SG','Singapore',NULL,NULL),(197,'SK','Slovakia',NULL,NULL),(198,'SI','Slovenia',NULL,NULL),(199,'SB','Solomon Islands',NULL,NULL),(200,'SO','Somalia',NULL,NULL),(201,'ZA','South Africa',NULL,NULL),(202,'GS','South Georgia and the South Sandwich Islands',NULL,NULL),(203,'ES','Spain',NULL,NULL),(204,'LK','Sri Lanka',NULL,NULL),(205,'SD','Sudan',NULL,NULL),(206,'SR','Suriname',NULL,NULL),(207,'SJ','Svalbard and Jan Mayen',NULL,NULL),(208,'SZ','Swaziland',NULL,NULL),(209,'SE','Sweden',NULL,NULL),(210,'CH','Switzerland',NULL,NULL),(211,'SY','Syrian Arab Republic',NULL,NULL),(212,'TW','Taiwan, Province of China',NULL,NULL),(213,'TJ','Tajikistan',NULL,NULL),(214,'TZ','Tanzania, United Republic of',NULL,NULL),(215,'TH','Thailand',NULL,NULL),(216,'TL','Timor-Leste',NULL,NULL),(217,'TG','Togo',NULL,NULL),(218,'TK','Tokelau',NULL,NULL),(219,'TO','Tonga',NULL,NULL),(220,'TT','Trinidad and Tobago',NULL,NULL),(221,'TN','Tunisia',NULL,NULL),(222,'TR','Turkey',NULL,NULL),(223,'TM','Turkmenistan',NULL,NULL),(224,'TC','Turks and Caicos Islands',NULL,NULL),(225,'TV','Tuvalu',NULL,NULL),(226,'UG','Uganda',NULL,NULL),(227,'UA','Ukraine',NULL,NULL),(228,'AE','United Arab Emirates',NULL,NULL),(229,'GB','United Kingdom',NULL,NULL),(230,'US','United States',NULL,NULL),(231,'UM','United States Minor Outlying Islands',NULL,NULL),(232,'UY','Uruguay',NULL,NULL),(233,'UZ','Uzbekistan',NULL,NULL),(234,'VU','Vanuatu',NULL,NULL),(235,'VE','Venezuela',NULL,NULL),(236,'VN','Viet Nam',NULL,NULL),(237,'VG','Virgin Islands, British',NULL,NULL),(238,'VI','Virgin Islands, U.S.',NULL,NULL),(239,'WF','Wallis and Futuna',NULL,NULL),(240,'EH','Western Sahara',NULL,NULL),(241,'YE','Yemen',NULL,NULL),(242,'ZM','Zambia',NULL,NULL),(243,'ZW','Zimbabwe',NULL,NULL);
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `currencies`
--

DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `currencies_created_by_foreign` (`created_by`),
  CONSTRAINT `currencies_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `currencies`
--

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
INSERT INTO `currencies` VALUES (1,'Euro','EUR',1,NULL,NULL),(2,'US Dollar','USD',1,NULL,NULL),(3,'Pound','GBP',1,NULL,NULL),(4,'Australian dollar','AUD',1,NULL,NULL),(5,'Canadian dollar','CAD',1,NULL,NULL);
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_field_types`
--

DROP TABLE IF EXISTS `custom_field_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_field_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT 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 `custom_field_types`
--

LOCK TABLES `custom_field_types` WRITE;
/*!40000 ALTER TABLE `custom_field_types` DISABLE KEYS */;
INSERT INTO `custom_field_types` VALUES (1,'text',NULL,NULL),(2,'textarea',NULL,NULL),(3,'radio',NULL,NULL),(4,'select',NULL,NULL),(5,'date',NULL,NULL),(6,'number',NULL,NULL);
/*!40000 ALTER TABLE `custom_field_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_field_values`
--

DROP TABLE IF EXISTS `custom_field_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_field_values` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `value` text NOT NULL,
  `contextable_type` varchar(191) NOT NULL,
  `contextable_id` varchar(191) NOT NULL,
  `custom_field_id` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_field_values_custom_field_id_foreign` (`custom_field_id`),
  KEY `custom_field_values_updated_by_foreign` (`updated_by`),
  CONSTRAINT `custom_field_values_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`),
  CONSTRAINT `custom_field_values_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_field_values`
--

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

--
-- Table structure for table `custom_fields`
--

DROP TABLE IF EXISTS `custom_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_fields` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_type_id` bigint(20) unsigned NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `context` varchar(191) NOT NULL,
  `meta` text DEFAULT NULL,
  `in_list` tinyint(1) NOT NULL DEFAULT 0,
  `is_for_admin` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_fields_custom_field_type_id_foreign` (`custom_field_type_id`),
  KEY `custom_fields_created_by_foreign` (`created_by`),
  CONSTRAINT `custom_fields_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `custom_fields_custom_field_type_id_foreign` FOREIGN KEY (`custom_field_type_id`) REFERENCES `custom_field_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_fields`
--

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

--
-- Table structure for table `emails`
--

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

--
-- Dumping data for table `emails`
--

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

--
-- Table structure for table `estimate_details`
--

DROP TABLE IF EXISTS `estimate_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estimate_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `estimate_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `quantity` double(16,2) NOT NULL,
  `price` double(16,2) NOT NULL,
  `tax_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `estimate_details_estimate_id_foreign` (`estimate_id`),
  KEY `estimate_details_product_id_foreign` (`product_id`),
  KEY `estimate_details_tax_id_foreign` (`tax_id`),
  CONSTRAINT `estimate_details_estimate_id_foreign` FOREIGN KEY (`estimate_id`) REFERENCES `estimates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `estimate_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `estimate_details_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estimate_details`
--

LOCK TABLES `estimate_details` WRITE;
/*!40000 ALTER TABLE `estimate_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimate_details` 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 = utf8 */;
CREATE TABLE `estimates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `is_clone` tinyint(1) NOT NULL DEFAULT 0,
  `client_id` bigint(20) unsigned NOT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `estimate_number` varchar(191) NOT NULL,
  `date` date NOT NULL,
  `status_id` bigint(20) unsigned NOT NULL,
  `sub_total` double(16,2) NOT NULL,
  `discount_type` enum('none','fixed','percentage') NOT NULL DEFAULT 'none',
  `discount` double(16,2) NOT NULL DEFAULT 0.00,
  `discount_amount` double(16,2) NOT NULL DEFAULT 0.00,
  `total` double(16,2) NOT NULL,
  `notes` longtext DEFAULT NULL,
  `terms` longtext DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `estimates_estimate_number_unique` (`estimate_number`),
  KEY `estimates_client_id_foreign` (`client_id`),
  KEY `estimates_currency_id_foreign` (`currency_id`),
  KEY `estimates_status_id_foreign` (`status_id`),
  KEY `estimates_created_by_foreign` (`created_by`),
  CONSTRAINT `estimates_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`),
  CONSTRAINT `estimates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `estimates_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  CONSTRAINT `estimates_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`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 `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `amount` double NOT NULL,
  `purpose_id` bigint(20) unsigned NOT NULL,
  `note` text DEFAULT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expenses_purpose_id_foreign` (`purpose_id`),
  CONSTRAINT `expenses_purpose_id_foreign` FOREIGN KEY (`purpose_id`) REFERENCES `purposes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses` 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 = utf8 */;
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 `files`
--

DROP TABLE IF EXISTS `files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `path` text NOT NULL,
  `fileable_type` varchar(160) NOT NULL,
  `fileable_id` bigint(20) unsigned NOT NULL,
  `type` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fileable_index` (`fileable_type`,`fileable_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 `files`
--

LOCK TABLES `files` WRITE;
/*!40000 ALTER TABLE `files` DISABLE KEYS */;
INSERT INTO `files` VALUES (1,'/storage/product/66559e5a45e96.jpg','App\\Models\\Billar\\Product\\Product',1,'product','2024-05-28 02:05:30','2024-05-28 02:05:30');
/*!40000 ALTER TABLE `files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gain`
--

DROP TABLE IF EXISTS `gain`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gain` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_code` varchar(191) NOT NULL,
  `app_id` varchar(191) NOT 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 `gain`
--

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

--
-- Table structure for table `invoice_details`
--

DROP TABLE IF EXISTS `invoice_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `quantity` double(16,2) NOT NULL,
  `price` double(16,2) NOT NULL,
  `tax_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_details_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_details_product_id_foreign` (`product_id`),
  KEY `invoice_details_tax_id_foreign` (`tax_id`),
  CONSTRAINT `invoice_details_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `invoice_details_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`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 `invoice_details`
--

LOCK TABLES `invoice_details` WRITE;
/*!40000 ALTER TABLE `invoice_details` DISABLE KEYS */;
INSERT INTO `invoice_details` VALUES (1,1,1,1.00,1000.00,1,'2024-05-28 02:08:48','2024-05-28 02:08:48');
/*!40000 ALTER TABLE `invoice_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice_recurrings`
--

DROP TABLE IF EXISTS `invoice_recurrings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_recurrings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `referance_invoice_id` bigint(20) unsigned NOT NULL,
  `recurring_date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_recurrings_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_recurrings_referance_invoice_id_foreign` (`referance_invoice_id`),
  CONSTRAINT `invoice_recurrings_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_recurrings_referance_invoice_id_foreign` FOREIGN KEY (`referance_invoice_id`) REFERENCES `invoices` (`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_recurrings`
--

LOCK TABLES `invoice_recurrings` WRITE;
/*!40000 ALTER TABLE `invoice_recurrings` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoice_recurrings` 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 = utf8 */;
CREATE TABLE `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `invoice_number` varchar(191) NOT NULL,
  `recurring` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `due_date` date NOT NULL,
  `status_id` bigint(20) unsigned NOT NULL,
  `recurring_cycle_id` bigint(20) unsigned DEFAULT NULL,
  `sub_total` double(16,2) NOT NULL,
  `discount_type` enum('none','fixed','percentage') NOT NULL DEFAULT 'none',
  `discount` double(16,2) NOT NULL DEFAULT 0.00,
  `total` double(16,2) NOT NULL,
  `received_amount` double(16,2) NOT NULL DEFAULT 0.00,
  `due_amount` double(16,2) NOT NULL,
  `notes` longtext DEFAULT NULL,
  `terms` longtext DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `discount_amount` double(8,2) NOT NULL DEFAULT 0.00,
  `is_from_estimate` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoices_invoice_number_unique` (`invoice_number`),
  KEY `invoices_client_id_foreign` (`client_id`),
  KEY `invoices_status_id_foreign` (`status_id`),
  KEY `invoices_recurring_cycle_id_foreign` (`recurring_cycle_id`),
  KEY `invoices_created_by_foreign` (`created_by`),
  CONSTRAINT `invoices_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`),
  CONSTRAINT `invoices_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `invoices_recurring_cycle_id_foreign` FOREIGN KEY (`recurring_cycle_id`) REFERENCES `recurring_cycles` (`id`),
  CONSTRAINT `invoices_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`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 `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES (1,2,'1',2,'2024-05-28','2024-05-28',6,NULL,1070.00,'none',0.00,1070.00,0.00,1070.00,NULL,NULL,1,NULL,'2024-05-28 02:08:48','2024-05-28 02:08:48',0.00,0);
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

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

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
INSERT INTO `jobs` VALUES (1,'high','{\"uuid\":\"85cb5340-86df-41cc-86bc-148c4123daf6\",\"displayName\":\"App\\\\Jobs\\\\InvoiceAttachmentJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\InvoiceAttachmentJob\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\InvoiceAttachmentJob\\\":2:{s:10:\\\"\\u0000*\\u0000invoice\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:33:\\\"App\\\\Models\\\\Billar\\\\Invoice\\\\Invoice\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:7:{i:0;s:14:\\\"invoiceDetails\\\";i:1;s:22:\\\"invoiceDetails.product\\\";i:2;s:18:\\\"invoiceDetails.tax\\\";i:3;s:6:\\\"client\\\";i:4;s:14:\\\"client.profile\\\";i:5;s:9:\\\"createdBy\\\";i:6;s:17:\\\"createdBy.profile\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:5:\\\"queue\\\";s:4:\\\"high\\\";}\"}}',0,NULL,1716887331,1716887331);
/*!40000 ALTER TABLE `jobs` 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 = utf8 */;
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=59 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,'2013_02_09_0000_create_types_table',1),(2,'2013_02_10_072424_create_statuses_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2017_09_03_144628_create_permission_tables',1),(6,'2017_09_04_064802_create_role_user_table',1),(7,'2017_09_26_140332_create_cache_table',1),(8,'2017_09_26_140528_create_sessions_table',1),(9,'2017_09_26_140609_create_jobs_table',1),(10,'2018_04_08_033256_create_password_histories_table',1),(11,'2019_08_19_000000_create_failed_jobs_table',1),(12,'2020_02_10_071640_create_settings_table',1),(13,'2020_02_11_083419_create_custom_field_types_table',1),(14,'2020_02_11_083437_create_custom_fields_table',1),(15,'2020_02_11_083711_create_custom_field_values_table',1),(16,'2020_02_12_123449_create_notification_events_table',1),(17,'2020_02_12_123727_create_notification_settings_table',1),(18,'2020_02_12_124416_create_notification_channels_table',1),(19,'2020_02_12_124533_create_notification_audiences_table',1),(20,'2020_02_18_141948_create_notifications_table',1),(21,'2020_02_19_092540_create_activity_log_table',1),(22,'2020_02_26_112625_create_files_table',1),(23,'2020_03_10_124422_create_notification_templates_table',1),(24,'2020_03_10_124437_create_notification_event_template_table',1),(25,'2020_05_03_091140_create_profile_table',1),(26,'2020_07_23_134030_create_social_links_table',1),(27,'2020_07_26_065825_create_user_social_link_table',1),(28,'2021_04_22_085303_create_payment_methods',1),(29,'2021_07_07_042542_create_recurring_cycles_table',1),(30,'2021_07_07_044822_create_currencies_table',1),(31,'2021_07_07_064726_create_taxes_table',1),(32,'2021_07_07_093816_create_categories_table',1),(33,'2021_07_08_053643_create_invoices_table',1),(34,'2021_07_08_054048_create_products_table',1),(35,'2021_07_08_055727_create_invoice_details_table',1),(36,'2021_07_11_073003_create_countries_table',1),(37,'2021_07_12_054453_create_clients_table',1),(38,'2021_07_12_064921_create_phones_table',1),(39,'2021_07_12_064949_create_emails_table',1),(40,'2021_07_12_112749_create_client_addresses_table',1),(41,'2021_07_15_122432_create_payment_histories_table',1),(42,'2021_08_25_091820_create_gain_table',1),(43,'2021_08_26_114714_add_alias_to_roles_table',1),(44,'2021_09_27_074710_update_invoices_table',1),(45,'2021_09_29_120525_add_row_to_permissions',1),(46,'2021_10_26_064018_create_table_filters_table',1),(47,'2021_11_29_113802_add_purchase_code_move_to_settings_table',1),(48,'2021_12_07_071305_create_purposes_table',1),(49,'2021_12_07_071439_create_expenses_table',1),(50,'2022_02_15_045723_create_invoice_recurrings_table',1),(51,'2022_08_29_130902_add_event_column_to_activity_log_table',1),(52,'2022_08_29_130903_add_batch_uuid_column_to_activity_log_table',1),(53,'2022_10_20_124947_add_vat_number_to_profiles_table',1),(54,'2023_01_18_132207_add_soft_deletes_to_products',1),(55,'2023_01_19_051709_add_discount_amount_to_invoices',1),(56,'2023_01_19_082136_create_estimates_table',1),(57,'2023_01_19_082146_create_estimate_details_table',1),(58,'2023_01_22_063227_add_is_from_eastimate_to_invoices',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_audiences`
--

DROP TABLE IF EXISTS `notification_audiences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_audiences` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_setting_id` bigint(20) unsigned NOT NULL,
  `audience_type` varchar(191) NOT NULL,
  `audiences` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_audiences_notification_setting_id_foreign` (`notification_setting_id`),
  CONSTRAINT `notification_audiences_notification_setting_id_foreign` FOREIGN KEY (`notification_setting_id`) REFERENCES `notification_settings` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_audiences`
--

LOCK TABLES `notification_audiences` WRITE;
/*!40000 ALTER TABLE `notification_audiences` DISABLE KEYS */;
INSERT INTO `notification_audiences` VALUES (1,1,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(2,2,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(3,3,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(4,4,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(5,5,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(6,6,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(7,7,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(8,8,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(9,9,'roles','[1]','2024-05-28 00:53:24','2024-05-28 00:53:24');
/*!40000 ALTER TABLE `notification_audiences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_channels`
--

DROP TABLE IF EXISTS `notification_channels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_channels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) 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 `notification_channels`
--

LOCK TABLES `notification_channels` WRITE;
/*!40000 ALTER TABLE `notification_channels` DISABLE KEYS */;
INSERT INTO `notification_channels` VALUES (1,'database',NULL,NULL),(2,'mail',NULL,NULL);
/*!40000 ALTER TABLE `notification_channels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_event_template`
--

DROP TABLE IF EXISTS `notification_event_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_event_template` (
  `notification_event_id` bigint(20) unsigned NOT NULL,
  `notification_template_id` bigint(20) unsigned NOT NULL,
  KEY `notification_event_template_notification_event_id_foreign` (`notification_event_id`),
  KEY `notification_event_template_notification_template_id_foreign` (`notification_template_id`),
  CONSTRAINT `notification_event_template_notification_event_id_foreign` FOREIGN KEY (`notification_event_id`) REFERENCES `notification_events` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notification_event_template_notification_template_id_foreign` FOREIGN KEY (`notification_template_id`) REFERENCES `notification_templates` (`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 `notification_event_template`
--

LOCK TABLES `notification_event_template` WRITE;
/*!40000 ALTER TABLE `notification_event_template` DISABLE KEYS */;
INSERT INTO `notification_event_template` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,7),(6,6),(7,8),(8,9),(9,10),(9,11),(9,10);
/*!40000 ALTER TABLE `notification_event_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_events`
--

DROP TABLE IF EXISTS `notification_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `type_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_events_type_id_foreign` (`type_id`),
  CONSTRAINT `notification_events_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_events`
--

LOCK TABLES `notification_events` WRITE;
/*!40000 ALTER TABLE `notification_events` DISABLE KEYS */;
INSERT INTO `notification_events` VALUES (1,'user_invitation',1,NULL,NULL),(2,'password_reset',1,NULL,NULL),(3,'client_credential',1,NULL,NULL),(4,'invoice_sending_attachment',1,NULL,NULL),(5,'invoice_payment_reminder',1,NULL,NULL),(6,'user_joined',1,NULL,NULL),(7,'payment_recived',1,NULL,NULL),(8,'estimate_sending_attachment',1,NULL,NULL),(9,'new_invoice_generate',1,NULL,NULL);
/*!40000 ALTER TABLE `notification_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_settings`
--

DROP TABLE IF EXISTS `notification_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_event_id` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `notify_by` varchar(191) NOT NULL COMMENT 'List of notification channels.',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_settings_notification_event_id_foreign` (`notification_event_id`),
  KEY `notification_settings_updated_by_foreign` (`updated_by`),
  CONSTRAINT `notification_settings_notification_event_id_foreign` FOREIGN KEY (`notification_event_id`) REFERENCES `notification_events` (`id`),
  CONSTRAINT `notification_settings_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_settings`
--

LOCK TABLES `notification_settings` WRITE;
/*!40000 ALTER TABLE `notification_settings` DISABLE KEYS */;
INSERT INTO `notification_settings` VALUES (1,1,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(2,2,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(3,3,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(4,4,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(5,5,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(6,6,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(7,7,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(8,8,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24'),(9,9,NULL,'[\"database\"]','2024-05-28 00:53:24','2024-05-28 00:53:24');
/*!40000 ALTER TABLE `notification_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_templates`
--

DROP TABLE IF EXISTS `notification_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` text DEFAULT NULL,
  `default_content` longtext DEFAULT NULL,
  `custom_content` longtext DEFAULT NULL,
  `type` enum('sms','mail','database') NOT NULL,
  `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 `notification_templates`
--

LOCK TABLES `notification_templates` WRITE;
/*!40000 ALTER TABLE `notification_templates` DISABLE KEYS */;
INSERT INTO `notification_templates` VALUES (1,'User invitation form {app_name}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHi {receiver_name} Hope this mail finds you well and healthy. We are informing you that you\'ve been invited to our application by {action_by}. It\'ll be a great opportunity to work with you. \n<a href=\"{invitation_url}\" target=\"_blank\" style=\"background: #4466F2;color: white;padding: 9px;border-radius: 4px;cursor: pointer; text-decoration: none; text-underline: none\">Accept Invitation</a> \n\nThanks &amp; Regards,\n{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(2,'Password reset link provided by {app_name}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHi {receiver_name} Your request for reset password has been approved from {app_name}. Press the button below to reset the password. \n<a href=\"{reset_password_url}\" style=\"background: #4466F2;color: white;padding: 9px;border-radius: 4px;cursor: pointer; text-decoration: none; text-underline: none\" target=\"_blank\">Reset password</a> \n\nWe are highly expecting you as soon as possible. Hope you\'ll join us.\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(3,'You have been invited to join {app_name} by {action_by}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHello {receiver_name} Your Login credentials are given, Email : {email} Password : {password} \nTo set up your account, please use these credentials and go to the following link.\n \n<a href=\"{resource_url}\" style=\"background: #4466F2;color: white;padding: 9px;border-radius: 4px;cursor: pointer; text-decoration: none; text-underline: none\" target=\"_blank\">Go to your account</a> \nYou can change your password from your account password settings.\n\nHope you will find useful!\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(4,'Invoice {invoice_number} for due {date}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHello {receiver_name} I hope you’re well!\n \nPlease see attached invoice {invoice_number}. \nDon’t hesitate to contact us if you have any questions.\n\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(5,'Payment reminder for invoice {invoice_number}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHi {receiver_name} We hope that you’re enjoying our service\n \nWe did want to quickly mention that we haven’t received payment from you yet. \nIf you have any questions don’t hesitate to reply to this email.\n\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(6,'A new user has been joined in {app_name}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHi {receiver_name} It\'s a piece of good news that a new user {name} has been joined in our application invited by {action_by}. Hope you will enjoy his work and collaborations. \n<a href=\"{resource_url}\" style=\"background: #4466F2;color: white;padding: 9px;border-radius: 4px;cursor: pointer; text-decoration: none; text-underline: none\" target=\"_blank\">View Resource</a> \n\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(7,NULL,'A new user has been joined in {app_name}',NULL,'database','2024-05-28 00:53:24','2024-05-28 00:53:24'),(8,'Payment received','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHello, {receiver_name} \nHope this mail finds you well and healthy. We received your payment.\nPlease see attached invoice {invoice_number}.\n \n\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(9,'Estimate for {date}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\nHello {receiver_name} I hope you’re well!\n \nPlease see attached estimate est-{estimate_number}. \nDon’t hesitate to contact us if you have any questions.\n\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(10,'New Invoice generated {invoice_number}','<img src=\"{app_logo}\" style=\"height: 75px\">\n\n\n\nHello {receiver_name} \n\n \nNew Invoice generated {invoice_number}\n\nThanks for being with us.\nRegards,{app_name}',NULL,'mail','2024-05-28 00:53:24','2024-05-28 00:53:24'),(11,'New Invoice generated {invoice_number}','New Invoice generated {invoice_number}',NULL,'database','2024-05-28 00:53:24','2024-05-28 00:53:24');
/*!40000 ALTER TABLE `notification_templates` 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 = utf8 */;
CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(160) 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`)
) 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 `password_histories`
--

DROP TABLE IF EXISTS `password_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `password` varchar(191) 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 `password_histories`
--

LOCK TABLES `password_histories` WRITE;
/*!40000 ALTER TABLE `password_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_histories` 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 = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(160) NOT NULL,
  `token` varchar(191) 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 `payment_histories`
--

DROP TABLE IF EXISTS `payment_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `payment_method_id` bigint(20) unsigned NOT NULL,
  `received_on` date NOT NULL,
  `amount` double(16,2) NOT NULL,
  `note` longtext DEFAULT NULL,
  `token` varchar(191) DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_histories_invoice_id_foreign` (`invoice_id`),
  KEY `payment_histories_payment_method_id_foreign` (`payment_method_id`),
  KEY `payment_histories_created_by_foreign` (`created_by`),
  CONSTRAINT `payment_histories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `payment_histories_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payment_histories_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_histories`
--

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

--
-- Table structure for table `payment_methods`
--

DROP TABLE IF EXISTS `payment_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `alias` varchar(191) NOT NULL,
  `client_key` varchar(191) DEFAULT NULL,
  `secret_key` varchar(191) DEFAULT NULL,
  `status_id` bigint(20) unsigned NOT NULL,
  `is_default` tinyint(4) NOT NULL,
  `mode` enum('production','sandbox') DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_methods_name_unique` (`name`),
  KEY `payment_methods_status_id_foreign` (`status_id`),
  KEY `payment_methods_created_by_foreign` (`created_by`),
  CONSTRAINT `payment_methods_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `payment_methods_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`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 `payment_methods`
--

LOCK TABLES `payment_methods` WRITE;
/*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */;
INSERT INTO `payment_methods` VALUES (1,'Cash','cash',NULL,NULL,4,1,NULL,1,NULL,NULL);
/*!40000 ALTER TABLE `payment_methods` 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 = utf8 */;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `group_name` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permissions_type_id_foreign` (`type_id`),
  CONSTRAINT `permissions_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=80 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,'show_all_data','show',NULL,NULL),(2,1,'view_dashboard','dashboard',NULL,NULL),(3,1,'dashboard_card','dashboard',NULL,NULL),(4,1,'payment_overview','dashboard',NULL,NULL),(5,1,'yearly_overview','dashboard',NULL,NULL),(6,1,'create_clients','clients',NULL,NULL),(7,1,'view_clients','clients',NULL,NULL),(8,1,'update_clients','clients',NULL,NULL),(9,1,'delete_clients','clients',NULL,NULL),(10,1,'client_invoice_details','clients',NULL,NULL),(11,1,'create_invoices','invoices',NULL,NULL),(12,1,'view_invoices','invoices',NULL,NULL),(13,1,'update_invoices','invoices',NULL,NULL),(14,1,'delete_invoices','invoices',NULL,NULL),(15,1,'invoice_download','invoices',NULL,NULL),(16,1,'invoice_checkout','invoices',NULL,NULL),(17,1,'invoice_send','invoices',NULL,NULL),(18,1,'invoice_resend','invoices',NULL,NULL),(19,1,'delete_invoice_details_product','invoices',NULL,NULL),(20,1,'create_payment_histories','payments',NULL,NULL),(21,1,'view_payment_histories','payments',NULL,NULL),(22,1,'update_payment_histories','payments',NULL,NULL),(23,1,'delete_payment_histories','payments',NULL,NULL),(24,1,'create_products','products',NULL,NULL),(25,1,'view_products','products',NULL,NULL),(26,1,'update_products','products',NULL,NULL),(27,1,'delete_products','products',NULL,NULL),(28,1,'create_categories','categories',NULL,NULL),(29,1,'view_categories','categories',NULL,NULL),(30,1,'update_categories','categories',NULL,NULL),(31,1,'delete_categories','categories',NULL,NULL),(32,1,'view_expenses','expense',NULL,NULL),(33,1,'create_expenses','expense',NULL,NULL),(34,1,'update_expenses','expense',NULL,NULL),(35,1,'delete_expenses','expense',NULL,NULL),(36,1,'view_purposes','expense',NULL,NULL),(37,1,'create_purposes','expense',NULL,NULL),(38,1,'update_purposes','expense',NULL,NULL),(39,1,'delete_purposes','expense',NULL,NULL),(40,1,'payment_summary_reports','reports',NULL,NULL),(41,1,'client_statement_report_reports','reports',NULL,NULL),(42,1,'invoice_report_reports','reports',NULL,NULL),(43,1,'view_users','user_and_roles',NULL,NULL),(44,1,'invite_user','user_and_roles',NULL,NULL),(45,1,'update_users','user_and_roles',NULL,NULL),(46,1,'delete_users','user_and_roles',NULL,NULL),(47,1,'attach_roles_users','user_and_roles',NULL,NULL),(48,1,'detach_roles_users','user_and_roles',NULL,NULL),(49,1,'view_roles','user_and_roles',NULL,NULL),(50,1,'create_roles','user_and_roles',NULL,NULL),(51,1,'update_roles','user_and_roles',NULL,NULL),(52,1,'delete_roles','user_and_roles',NULL,NULL),(53,1,'attach_users_to_roles','user_and_roles',NULL,NULL),(54,1,'view_settings','settings',NULL,NULL),(55,1,'update_settings','settings',NULL,NULL),(56,1,'view_delivery_settings','settings',NULL,NULL),(57,1,'update_delivery_settings','settings',NULL,NULL),(58,1,'create_payment_method','settings',NULL,NULL),(59,1,'view_payment_method','settings',NULL,NULL),(60,1,'update_payment_method','settings',NULL,NULL),(61,1,'delete_payment_method','settings',NULL,NULL),(62,1,'view_notification_settings','settings',NULL,NULL),(63,1,'update_notification_settings','settings',NULL,NULL),(64,1,'view_notification_templates','settings',NULL,NULL),(65,1,'update_notification_templates','settings',NULL,NULL),(66,1,'manage_invoice_setting','settings',NULL,NULL),(67,1,'create_taxes','settings',NULL,NULL),(68,1,'view_taxes','settings',NULL,NULL),(69,1,'update_taxes','settings',NULL,NULL),(70,1,'delete_taxes','settings',NULL,NULL),(71,1,'view_updates','updates',NULL,NULL),(72,1,'install_updates','updates',NULL,NULL),(73,1,'estimate_resend','estimates',NULL,NULL),(74,1,'view_estimates','estimates',NULL,NULL),(75,1,'create_estimates','estimates',NULL,NULL),(76,1,'update_estimates','estimates',NULL,NULL),(77,1,'delete_estimates','estimates',NULL,NULL),(78,1,'download_estimate','estimates',NULL,NULL),(79,1,'clone_invoice','estimates',NULL,NULL);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phones`
--

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

--
-- Dumping data for table `phones`
--

LOCK TABLES `phones` WRITE;
/*!40000 ALTER TABLE `phones` DISABLE KEYS */;
/*!40000 ALTER TABLE `phones` 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 = utf8 */;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `unit_price` double(8,2) NOT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_code_unique` (`code`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) 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,'ทดสอบสินค้า','N00000',NULL,1000.00,'ทดสอบคำอธิบาย','2024-05-28 02:05:30','2024-05-28 02:05:30',NULL);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profiles`
--

DROP TABLE IF EXISTS `profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `gender` enum('male','female','other') NOT NULL,
  `date_of_birth` date DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `contact` varchar(191) DEFAULT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `profiles_user_id_foreign` (`user_id`),
  CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_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 `profiles`
--

LOCK TABLES `profiles` WRITE;
/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
INSERT INTO `profiles` VALUES (1,2,'male',NULL,'00 m.0','+66 63 516 9036',NULL,'2024-05-28 02:04:30','2024-05-28 02:04:30'),(2,1,'male',NULL,'99 หมู่ 2 ตำบลนาส่วง อำเภอเดชอุดม จังหวัดอุบลราชธานี','+66 95 443 9307','1349900984060','2024-05-28 02:12:44','2024-05-28 02:12:44');
/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purposes`
--

DROP TABLE IF EXISTS `purposes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purposes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `type` enum('expense','income') NOT NULL,
  `description` 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 `purposes`
--

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

--
-- Table structure for table `recurring_cycles`
--

DROP TABLE IF EXISTS `recurring_cycles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recurring_cycles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT 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 `recurring_cycles`
--

LOCK TABLES `recurring_cycles` WRITE;
/*!40000 ALTER TABLE `recurring_cycles` DISABLE KEYS */;
INSERT INTO `recurring_cycles` VALUES (1,'Monthly',NULL,NULL),(2,'Quarterly',NULL,NULL),(3,'Semi annually',NULL,NULL),(4,'Annually',NULL,NULL);
/*!40000 ALTER TABLE `recurring_cycles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_permission`
--

DROP TABLE IF EXISTS `role_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_permission` (
  `role_id` bigint(20) unsigned NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `meta` text DEFAULT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_permission_role_id_foreign` (`role_id`),
  CONSTRAINT `role_permission_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_permission_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_permission`
--

LOCK TABLES `role_permission` WRITE;
/*!40000 ALTER TABLE `role_permission` DISABLE KEYS */;
INSERT INTO `role_permission` VALUES (2,2,NULL),(2,3,NULL),(2,12,NULL),(2,15,NULL),(2,16,NULL),(2,21,NULL),(2,40,NULL),(2,41,NULL),(2,42,NULL),(2,74,NULL),(2,78,NULL);
/*!40000 ALTER TABLE `role_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_user`
--

DROP TABLE IF EXISTS `role_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_user` (
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_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 `role_user`
--

LOCK TABLES `role_user` WRITE;
/*!40000 ALTER TABLE `role_user` DISABLE KEYS */;
INSERT INTO `role_user` VALUES (1,1),(2,2);
/*!40000 ALTER TABLE `role_user` 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 = utf8 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(160) NOT NULL,
  `alias` varchar(191) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `type_id` bigint(20) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roles_type_id_foreign` (`type_id`),
  KEY `roles_created_by_foreign` (`created_by`),
  KEY `roles_name_index` (`name`),
  CONSTRAINT `roles_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `roles_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE SET NULL
) 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,'App Admin',NULL,1,1,1,1,NULL,NULL),(2,'Client','client',0,0,1,1,NULL,NULL);
/*!40000 ALTER TABLE `roles` 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 = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(120) NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL,
  UNIQUE KEY `sessions_id_unique` (`id`)
) 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 */;
/*!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 = utf8 */;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `value` longtext DEFAULT NULL,
  `settingable_type` varchar(160) DEFAULT NULL,
  `settingable_id` bigint(20) unsigned DEFAULT NULL,
  `context` varchar(191) DEFAULT NULL,
  `autoload` tinyint(1) NOT NULL DEFAULT 0,
  `public` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settingable_index` (`settingable_type`,`settingable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 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,'purchase_code','1f979c72-1356-4968-ada2-306f5b96616a',NULL,NULL,'purchase_code',0,1,'2024-05-28 00:53:23','2024-05-28 00:53:23'),(2,'company_name','ร้านเทพซีพียู',NULL,NULL,'app',0,1,NULL,'2024-05-28 01:08:19'),(3,'company_logo','/storage/logo/6661bc2589251.jpg',NULL,NULL,'app',0,1,NULL,'2024-06-06 06:39:49'),(4,'company_icon','/storage/icon/66559299b129c.png',NULL,NULL,'app',0,1,NULL,'2024-05-28 01:15:21'),(5,'company_banner','/images/banner.png',NULL,NULL,'app',0,1,NULL,NULL),(6,'language','th',NULL,NULL,'app',0,1,NULL,'2024-05-28 02:20:33'),(7,'layout','ltr',NULL,NULL,'app',0,1,NULL,NULL),(8,'date_format','d-m-Y',NULL,NULL,'app',0,1,NULL,NULL),(9,'time_format','H',NULL,NULL,'app',0,1,NULL,'2024-05-28 01:08:20'),(10,'time_zone','Asia/Bangkok',NULL,NULL,'app',0,1,NULL,'2024-05-28 01:08:20'),(11,'currency_symbol','฿',NULL,NULL,'app',0,1,NULL,'2024-05-28 01:08:20'),(12,'decimal_separator','.',NULL,NULL,'app',0,1,NULL,NULL),(13,'thousand_separator',',',NULL,NULL,'app',0,1,NULL,NULL),(14,'number_of_decimal','2',NULL,NULL,'app',0,1,NULL,NULL),(15,'currency_position','prefix_with_space',NULL,NULL,'app',0,1,NULL,NULL),(16,'invoice_logo','/storage//665591c2d4bd2.png',NULL,NULL,'app',0,1,NULL,'2024-05-28 01:11:46'),(17,'invoice_starting_number','1',NULL,NULL,'app',0,1,NULL,NULL),(18,'logo','/storage/logo/66559227b6b66.jpg',NULL,NULL,'app',0,1,'2024-05-28 01:08:20','2024-05-28 01:15:21'),(19,'icon','/storage/icon/66559299b129c.png',NULL,NULL,'app',0,1,'2024-05-28 01:08:20','2024-05-28 02:20:33'),(20,'vat_number','1349900984060',NULL,NULL,'app',0,1,'2024-05-28 01:08:20','2024-05-28 01:08:20');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_links`
--

DROP TABLE IF EXISTS `social_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `social_links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `icon` 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 `social_links`
--

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

--
-- Table structure for table `statuses`
--

DROP TABLE IF EXISTS `statuses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `class` varchar(191) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `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 `statuses`
--

LOCK TABLES `statuses` WRITE;
/*!40000 ALTER TABLE `statuses` DISABLE KEYS */;
INSERT INTO `statuses` VALUES (1,'status_active','success','user',NULL,NULL),(2,'status_inactive','danger','user',NULL,NULL),(3,'status_invited','purple','user',NULL,NULL),(4,'status_active','success','payment_method',NULL,NULL),(5,'status_inactive','danger','payment_method',NULL,NULL),(6,'status_unpaid','secondary','invoice',NULL,NULL),(7,'status_partially_paid','primary','invoice',NULL,NULL),(8,'status_paid','success','invoice',NULL,NULL),(9,'status_overdue','danger','invoice',NULL,NULL),(10,'status_pending','warning','estimate',NULL,NULL),(11,'status_cloned','primary','estimate',NULL,NULL);
/*!40000 ALTER TABLE `statuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `table_filters`
--

DROP TABLE IF EXISTS `table_filters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table_filters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `table_id` varchar(191) NOT NULL,
  `filter_name` varchar(191) NOT NULL,
  `filter_value` varchar(191) 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 `table_filters_user_id_foreign` (`user_id`),
  CONSTRAINT `table_filters_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `table_filters`
--

LOCK TABLES `table_filters` WRITE;
/*!40000 ALTER TABLE `table_filters` DISABLE KEYS */;
/*!40000 ALTER TABLE `table_filters` 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 = utf8 */;
CREATE TABLE `taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `value` varchar(191) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `taxes`
--

LOCK TABLES `taxes` WRITE;
/*!40000 ALTER TABLE `taxes` DISABLE KEYS */;
INSERT INTO `taxes` VALUES (1,'ภาษีมูลค่าเพิ่ม','7',0,'2024-05-28 01:12:04','2024-05-28 01:12:04');
/*!40000 ALTER TABLE `taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `types`
--

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

--
-- Dumping data for table `types`
--

LOCK TABLES `types` WRITE;
/*!40000 ALTER TABLE `types` DISABLE KEYS */;
INSERT INTO `types` VALUES (1,'App','app',NULL,NULL),(2,'Brand','brand',NULL,NULL);
/*!40000 ALTER TABLE `types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_social_link`
--

DROP TABLE IF EXISTS `user_social_link`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_social_link` (
  `user_id` bigint(20) unsigned NOT NULL,
  `social_link_id` bigint(20) unsigned NOT NULL,
  `link` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`social_link_id`),
  KEY `user_social_link_social_link_id_foreign` (`social_link_id`),
  CONSTRAINT `user_social_link_social_link_id_foreign` FOREIGN KEY (`social_link_id`) REFERENCES `social_links` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_social_link_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 `user_social_link`
--

LOCK TABLES `user_social_link` WRITE;
/*!40000 ALTER TABLE `user_social_link` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_social_link` 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 = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(191) DEFAULT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `email` varchar(160) NOT NULL,
  `password` varchar(191) DEFAULT NULL,
  `last_login_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `status_id` bigint(20) unsigned NOT NULL,
  `invitation_token` varchar(191) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_status_id_foreign` (`status_id`),
  KEY `users_created_by_foreign` (`created_by`),
  CONSTRAINT `users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `users_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`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 `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'พุฒิพันธุ์','กะพัง','phuttiphankapang@hotmail.com','$2y$10$ziyMv6rnnPewHSsq4WyBnODvKGkXoLFY9Tdo2uu2vi3YqE3pfnw7G',NULL,NULL,1,NULL,NULL,'2024-05-28 00:53:23','2024-06-03 07:56:43',NULL),(2,'ทดสอบชื่อ','ลูกค้า','xpothaha@gmail.com','$2y$10$Sg5F/Lp5x0TNruzV9v9CGuXVPAuCOeCHQJhM/kJ2nyt9IxknVPqTm',NULL,1,1,NULL,NULL,'2024-05-28 02:04:30','2024-05-28 02:04:30',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-10-31 13:27:26

📁 Sid Gifari File Manager