Warning: session_start(): Session cannot be started after headers have already been sent in /home/tvrreohg/public_html/manga.php on line 13
/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: devoskisystems_devoskiSystem -- ------------------------------------------------------ -- Server version 10.6.22-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `companies` -- DROP TABLE IF EXISTS `companies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `companies` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `zip_code` varchar(255) DEFAULT NULL, `comment` varchar(255) DEFAULT NULL, `recipient_name` varchar(255) DEFAULT NULL, `recipient_bank_name` varchar(255) DEFAULT NULL, `recipient_bank_address` varchar(255) DEFAULT NULL, `recipient_bank_routing` varchar(255) DEFAULT NULL, `recipients_account` varchar(255) DEFAULT NULL, `account_type` varchar(255) DEFAULT NULL, `swift` varchar(255) DEFAULT NULL, `additional_comment` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `companies` -- LOCK TABLES `companies` WRITE; /*!40000 ALTER TABLE `companies` DISABLE KEYS */; INSERT INTO `companies` VALUES (1,'Shelley Frederick','lato@mailinator.com','+1 (485) 928-5053','In eos assumenda qu','Molestiae eos tempor','Tenetur eum quis non','26207','Iusto sed quas dolor','Paloma Crosby','Prescott Gould',NULL,'Doloribus quibusdam','Et cillum quo et aut','Amet veniam nulla','Ut dolor aut non del','Voluptate deserunt e','1','1','103.244.179.4','1','2024-07-18 19:02:45','2024-10-16 20:03:16',NULL),(2,'Designs Funnel LLC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','207.135.194.232','1','2024-10-16 20:09:05','2024-10-16 20:09:05',NULL); /*!40000 ALTER TABLE `companies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company_merchants` -- DROP TABLE IF EXISTS `company_merchants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `company_merchants` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `company_id` varchar(255) DEFAULT NULL, `merchant_id` varchar(255) DEFAULT NULL, `merchant_type` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company_merchants` -- LOCK TABLES `company_merchants` WRITE; /*!40000 ALTER TABLE `company_merchants` DISABLE KEYS */; INSERT INTO `company_merchants` VALUES (6,'1','1','paypal',NULL,'1',NULL,NULL,'2024-10-16 20:03:16','2024-10-16 20:03:16'),(7,'1','1','stripe',NULL,'1',NULL,NULL,'2024-10-16 20:03:16','2024-10-16 20:03:16'),(8,'2','2','paypal',NULL,'1',NULL,NULL,'2024-10-17 19:59:33','2024-10-17 19:59:33'); /*!40000 ALTER TABLE `company_merchants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `merchants` -- DROP TABLE IF EXISTS `merchants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `merchants` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `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 `merchants` -- LOCK TABLES `merchants` WRITE; /*!40000 ALTER TABLE `merchants` DISABLE KEYS */; /*!40000 ALTER TABLE `merchants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=74 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 (59,'2014_10_12_000000_create_users_table',1),(60,'2014_10_12_100000_create_password_resets_table',1),(61,'2019_08_19_000000_create_failed_jobs_table',1),(62,'2019_12_14_000001_create_personal_access_tokens_table',1),(63,'2024_01_25_203543_create_roles_table',1),(64,'2024_01_30_124733_create_permissions_table',1),(65,'2024_01_30_125012_create_role_permissions_table',1),(66,'2024_02_02_113256_create_companies_table',1),(67,'2024_02_05_164905_create_merchants_table',1),(68,'2024_02_05_170259_create_stripes_table',1),(69,'2024_02_06_103432_create_company_merchants_table',1),(70,'2024_02_07_160040_create_payment_records_table',1),(71,'2024_07_10_151040_create_paypal_invoicers_table',1),(72,'2024_07_11_140819_create_paypals_table',1),(73,'2024_07_11_191749_create_paypal_payment_records_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_records` -- DROP TABLE IF EXISTS `payment_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) DEFAULT NULL, `stripe_id` varchar(255) DEFAULT NULL, `payment_stripe_id` varchar(255) DEFAULT NULL, `stripe_customer_id` varchar(255) DEFAULT NULL, `payment_url` text DEFAULT NULL, `invoice_url` text DEFAULT NULL, `charge_url` text DEFAULT NULL, `customer_email` text DEFAULT NULL, `description` text DEFAULT NULL, `type` text DEFAULT NULL, `amount` text DEFAULT NULL, `currency` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) 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 `payment_records` -- LOCK TABLES `payment_records` WRITE; /*!40000 ALTER TABLE `payment_records` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paypal_invoicers` -- DROP TABLE IF EXISTS `paypal_invoicers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `paypal_invoicers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) DEFAULT NULL, `given_name` varchar(255) DEFAULT NULL, `surname` varchar(255) DEFAULT NULL, `address_line_1` varchar(255) DEFAULT NULL, `address_line_2` varchar(255) DEFAULT NULL, `admin_area_2` varchar(255) DEFAULT NULL, `admin_area_1` varchar(255) DEFAULT NULL, `postal_code` varchar(255) DEFAULT NULL, `country_code` varchar(255) DEFAULT NULL, `phone_country_code` varchar(255) DEFAULT NULL, `national_number` varchar(255) DEFAULT NULL, `website` varchar(255) DEFAULT NULL, `logo_url` varchar(255) DEFAULT NULL, `additional_notes` longtext DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) 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 `paypal_invoicers` -- LOCK TABLES `paypal_invoicers` WRITE; /*!40000 ALTER TABLE `paypal_invoicers` DISABLE KEYS */; /*!40000 ALTER TABLE `paypal_invoicers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paypal_payment_records` -- DROP TABLE IF EXISTS `paypal_payment_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `paypal_payment_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) DEFAULT NULL, `paypal_id` varchar(255) DEFAULT NULL, `payment_paypal_id` varchar(255) DEFAULT NULL, `paypal_customer_id` varchar(255) DEFAULT NULL, `payment_url` text DEFAULT NULL, `invoice_url` text DEFAULT NULL, `charge_url` text DEFAULT NULL, `customer_email` text DEFAULT NULL, `description` text DEFAULT NULL, `type` text DEFAULT NULL, `amount` text DEFAULT NULL, `currency` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) 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 `paypal_payment_records` -- LOCK TABLES `paypal_payment_records` WRITE; /*!40000 ALTER TABLE `paypal_payment_records` DISABLE KEYS */; /*!40000 ALTER TABLE `paypal_payment_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paypals` -- DROP TABLE IF EXISTS `paypals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `paypals` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `given_name` varchar(255) DEFAULT NULL, `surname` varchar(255) DEFAULT NULL, `address_line_1` varchar(255) DEFAULT NULL, `address_line_2` varchar(255) DEFAULT NULL, `admin_area_2` varchar(255) DEFAULT NULL, `admin_area_1` varchar(255) DEFAULT NULL, `postal_code` varchar(255) DEFAULT NULL, `country_code` varchar(255) DEFAULT NULL, `phone_country_code` varchar(255) DEFAULT NULL, `national_number` varchar(255) DEFAULT NULL, `website` varchar(255) DEFAULT NULL, `logo_url` varchar(255) DEFAULT NULL, `additional_notes` longtext DEFAULT NULL, `publish_key` varchar(255) DEFAULT NULL, `secret_key` varchar(255) DEFAULT NULL, `saccess_url` varchar(255) DEFAULT NULL, `cancel_url` varchar(255) DEFAULT NULL, `allow_country` longtext DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT 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 `paypals` -- LOCK TABLES `paypals` WRITE; /*!40000 ALTER TABLE `paypals` DISABLE KEYS */; INSERT INTO `paypals` VALUES (1,'Felix Mayer','Fritz Camacho','Harrison','93 North Rocky Milton Extension',NULL,'Ut aut qui labore id','DE','Lorem deleniti nobis','FR','62','226',NULL,NULL,NULL,'AcyXplB0V_dmaXbUlTLHg6KxmtdUIevzeoWRZVBC3KdORje9hCnuKM5Am5PNE-q8HMZx34FK-4CwejGT','ECjQrH6TOOdcIQrjTbP4Dwyrwi_Q6UGrcWi8lm8xn7JCb_OP_sCHjQSZMgM9ujBAEQFcZIgArhPWtWez',NULL,NULL,'[\"GB\"]','1','1','103.244.179.4','1','2024-07-18 19:02:01','2024-10-17 19:50:18'),(2,'DF Studios UK','Areeb','Ghalib','15 Tall Elms Cl',NULL,'Bromley',NULL,'BR2 0TT','GB','44','1865522700',NULL,NULL,NULL,'AcQclr0whaAst0_90oNSrEI4800S-aSLid0rGc7eyoLvfuhTpuP6D1fLRD-HZcTxoMLsQLBxSviG3M2N','EI299QlSN1JHqbRiNn71Kzx615U3jhwzxjEn5xBYw0Sb4qXgxkW7FcJX4zYinIagyX-Clk5A80zCtq5b',NULL,NULL,'[\"GB\"]','1','1','46.151.225.22','1','2024-10-17 19:58:51','2024-10-17 20:16:53'); /*!40000 ALTER TABLE `paypals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `display_name` varchar(255) NOT NULL, `group` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'create-user','Create User','User Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(9,'read-company','Read Company','Company Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(10,'update-company','Update Company','Company Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(11,'delete-company','Delete Company','Company Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(12,'read-merchant','Read Merchant','Merchant Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(13,'create-merchant','Create Merchant','Merchant Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(14,'update-merchant','Update Merchant','Merchant Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(15,'read-stripe','Read Stripe','Stripe Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(16,'create-stripe','Create Stripe','Stripe Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(17,'update-stripe','Update Stripe','Stripe Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(18,'read-invoicer','Read Invoicer','Invoicer Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(19,'create-invoicer','Create Invoicer','Invoicer Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(20,'update-invoicer','Update Invoicer','Invoicer Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(21,'read-paypal','Read Paypal','Paypal Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(22,'create-paypal','Create Paypal','Paypal Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(23,'update-paypal','Update Paypal','Paypal Management','1',NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `role_permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `permission_id` varchar(255) NOT NULL, `user_id` int(11) NOT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` VALUES (1,3,'read-company',1,'1','207.135.194.232','1','2024-10-16 19:49:03','2024-10-16 19:49:03',NULL); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `status` int(11) NOT NULL DEFAULT 1, `user_id` int(11) NOT NULL DEFAULT 1, `author_ip` text DEFAULT NULL, `author_id` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 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,'Super Admin',1,1,NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(2,'Admin',1,1,NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL),(3,'User',1,1,NULL,NULL,'2024-07-18 17:03:35','2024-07-18 17:03:35',NULL); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stripes` -- DROP TABLE IF EXISTS `stripes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `stripes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `publish_key` varchar(255) DEFAULT NULL, `secret_key` varchar(255) DEFAULT NULL, `saccess_url` varchar(255) DEFAULT NULL, `cancel_url` varchar(255) DEFAULT NULL, `allow_country` text DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `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 `stripes` -- LOCK TABLES `stripes` WRITE; /*!40000 ALTER TABLE `stripes` DISABLE KEYS */; INSERT INTO `stripes` VALUES (1,'Zachary Mcintosh','Anim commodi autem q','Ullamco laudantium','Velit eligendi exerc','Voluptatum ut repudi','[\"All\"]','1','1','103.244.179.4','1','2024-07-18 19:02:18','2024-10-16 22:29:35'); /*!40000 ALTER TABLE `stripes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `mobile` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `CNIC` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `birth_date` varchar(255) DEFAULT NULL, `user_type` varchar(255) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) 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,'Super','Admin','devoski.system@gmail.com',NULL,'$2y$10$2zKohVmLhXaC6GtqIhhCv.h0Uo3Xxh1addNrQa5LI9GZCifIyj3Le',NULL,NULL,NULL,NULL,'1',NULL,'0','zF74Vr0XWZYEsWSEV0WKRawWGEz3T2yDdLfw5gstLvq5FgpGUOezpA5RFoVw','2024-07-18 17:03:35','2024-07-18 17:03:35'),(2,'Rocky','Williams','rockywilliam301@gmail.com',NULL,'$2y$10$YZ3qwf7Fq2JftD.m9ah2Oe98A8r/2VYKB6G79MGTLWFrAi6tjv80G','123456789',NULL,NULL,NULL,'1','2024-10-16','3',NULL,'2024-10-16 20:00:04','2024-10-16 20:00:04'); /*!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-06-18 21:55:55