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: threeeir_pos -- ------------------------------------------------------ -- 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 `attribute_terms` -- DROP TABLE IF EXISTS `attribute_terms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `attribute_terms` ( `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 `attribute_terms` -- LOCK TABLES `attribute_terms` WRITE; /*!40000 ALTER TABLE `attribute_terms` DISABLE KEYS */; /*!40000 ALTER TABLE `attribute_terms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attributes` -- DROP TABLE IF EXISTS `attributes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `attributes` ( `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 `attributes` -- LOCK TABLES `attributes` WRITE; /*!40000 ALTER TABLE `attributes` DISABLE KEYS */; /*!40000 ALTER TABLE `attributes` 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 = utf8mb4 */; CREATE TABLE `categories` ( `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 `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `certifications` -- DROP TABLE IF EXISTS `certifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `certifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` varchar(255) DEFAULT NULL, `line_item_id` varchar(255) DEFAULT NULL, `product_name` varchar(255) DEFAULT NULL, `serial` varchar(255) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `certification_date` varchar(255) DEFAULT NULL, `certificate_by` varchar(255) DEFAULT NULL, `module_model` varchar(255) DEFAULT NULL, `section` varchar(255) DEFAULT NULL, `option` varchar(255) DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `uniqueCode` 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `certifications` -- LOCK TABLES `certifications` WRITE; /*!40000 ALTER TABLE `certifications` DISABLE KEYS */; /*!40000 ALTER TABLE `certifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `compliances` -- DROP TABLE IF EXISTS `compliances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `compliances` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `product_number` varchar(255) DEFAULT NULL, `serial` varchar(255) DEFAULT NULL, `date` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `color` varchar(255) DEFAULT NULL, `result` varchar(255) DEFAULT NULL, `status_comment` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `compliances` -- LOCK TABLES `compliances` WRITE; /*!40000 ALTER TABLE `compliances` DISABLE KEYS */; /*!40000 ALTER TABLE `compliances` 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 `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=138 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 (121,'2014_10_12_000000_create_users_table',1),(122,'2014_10_12_100000_create_password_resets_table',1),(123,'2019_08_19_000000_create_failed_jobs_table',1),(124,'2019_12_14_000001_create_personal_access_tokens_table',1),(125,'2024_01_25_203543_create_roles_table',1),(126,'2024_01_30_124733_create_permissions_table',1),(127,'2024_01_30_125012_create_role_permissions_table',1),(128,'2024_02_16_193253_create_products_table',1),(129,'2024_02_22_205039_create_attributes_table',1),(130,'2024_02_23_163934_create_attribute_terms_table',1),(131,'2024_03_06_125129_create_serial_numbers_table',1),(132,'2024_03_07_125721_create_product_certifications_table',1),(133,'2024_03_08_191129_create_categories_table',1),(134,'2024_03_28_213643_create_certifications_table',1),(135,'2024_05_23_162140_create_reseller_inquiries_table',1),(136,'2024_05_23_162629_create_compliances_table',1),(137,'2024_08_16_163519_create_return_forms_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 `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=30 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-08-20 13:44:00','2024-08-20 13:44:00',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(9,'read-product','Read Product','Product Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(10,'update-product','Update Product','Product Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(11,'create-product','Create Product','Product Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(12,'read-variable','Read Variable','Variable Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(13,'update-variable','Update Variable','Variable Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(14,'create-variable','Create Variable','Variable Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(15,'read-attribute','Read Attribute','Attribute Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(16,'update-attribute','Update Attribute','Attribute Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(17,'create-attribute','Create Attribute','Attribute Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(18,'read-attribute-term','Read Attribute Term','Attribute Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(19,'update-attribute-term','Update Attribute Term','Attribute Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(20,'create-attribute-term','Create Attribute Term','Attribute Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(21,'read-serial','Read Serial','Serial Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(22,'update-serial','Update Serial','Serial Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(23,'create-serial','Create Serial','Serial Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(24,'read-category','Read Category','Category Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(25,'update-category','Update Category','Category Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(26,'create-category','Create Category','Category Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(27,'read-certification','Read Certification','Certification Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(28,'update-certification','Update Certification','Certification Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(29,'create-certification','Create Certification','Certification Management','1',NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',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 `product_certifications` -- DROP TABLE IF EXISTS `product_certifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `product_certifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `product_id` varchar(255) DEFAULT NULL, `product_name` varchar(255) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `certification_date` varchar(255) DEFAULT NULL, `certificate_by` varchar(255) DEFAULT NULL, `module_model` varchar(255) DEFAULT NULL, `section` varchar(255) DEFAULT NULL, `option` varchar(255) DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `user_id` varchar(255) DEFAULT NULL, `user_ip` 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`) ) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_certifications` -- LOCK TABLES `product_certifications` WRITE; /*!40000 ALTER TABLE `product_certifications` DISABLE KEYS */; INSERT INTO `product_certifications` VALUES (25,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'a','Protective housing sealed except at aperture','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(26,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'a','Emission indicator functonal and visible','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(27,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'a','Beam attenuator functions as designed','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(28,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'b','Certification label present','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(29,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'b','Explanatory label present','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(30,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'b','Hazard warning symbol present','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(31,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'b','Aperture label present','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(32,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'b','Manufacture ID label present','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(33,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'b','User Information Included','1',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(34,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'c','Visible laser power max <4.9mw','on',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(35,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'c','Invisible laser power max <3.0mw','on',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(36,'2437','3EIR-Home-Three lasers',NULL,NULL,NULL,NULL,'c','VCSEL Invisible laser power 7mm aperture at 100mm <35mW','on',NULL,'1','1','172.68.234.122',NULL,'2024-10-29 18:30:22','2024-10-29 18:30:22'),(37,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'a','Protective housing sealed except at aperture','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(38,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'a','Emission indicator functonal and visible','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(39,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'a','Beam attenuator functions as designed','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(40,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'b','Certification label present','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(41,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'b','Explanatory label present','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(42,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'b','Hazard warning symbol present','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(43,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'b','Aperture label present','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(44,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'b','Manufacture ID label present','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(45,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'b','User Information Included','1',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(46,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'c','Visible laser power max <4.9mw','on',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(47,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'c','Invisible laser power max <3.0mw','on',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(48,'2435','3EIR-DIR-V -1',NULL,NULL,NULL,NULL,'c','VCSEL Invisible laser power 7mm aperture at 100mm <35mW','on',NULL,'1','1','172.68.234.123',NULL,'2024-10-29 18:36:08','2024-10-29 18:36:08'),(109,'2649','Test Product',NULL,NULL,NULL,NULL,'a','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(110,'2649','Test Product',NULL,NULL,NULL,NULL,'a','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(111,'2649','Test Product',NULL,NULL,NULL,NULL,'a','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(112,'2649','Test Product',NULL,NULL,NULL,NULL,'b','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(113,'2649','Test Product',NULL,NULL,NULL,NULL,'b','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(114,'2649','Test Product',NULL,NULL,NULL,NULL,'b','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(115,'2649','Test Product',NULL,NULL,NULL,NULL,'b','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(116,'2649','Test Product',NULL,NULL,NULL,NULL,'b','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(117,'2649','Test Product',NULL,NULL,NULL,NULL,'b','Test Product','1',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(118,'2649','Test Product',NULL,NULL,NULL,NULL,'c','Test Product','on',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(119,'2649','Test Product',NULL,NULL,NULL,NULL,'c','Test Product','on',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(120,'2649','Test Product',NULL,NULL,NULL,NULL,'c','Test Product','on',NULL,'1','3','162.158.158.235',NULL,'2024-11-01 20:00:21','2024-11-01 20:00:21'),(121,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'a','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(122,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'a','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(123,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'a','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(124,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'b','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(125,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'b','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(126,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'b','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(127,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'b','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(128,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'b','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(129,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'b','DIR-one Vis. Green','1',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(130,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'c','DIR-one Vis. Green','on',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(131,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'c','DIR-one Vis. Green','on',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(132,'2553','DIR-one Vis. Green',NULL,NULL,NULL,NULL,'c','DIR-one Vis. Green','on',NULL,'1','3','172.70.111.87',NULL,'2024-11-01 20:05:19','2024-11-01 20:05:19'),(181,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'a','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(182,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'a','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(183,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'a','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(184,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'b','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(185,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'b','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(186,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'b','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(187,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'b','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(188,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'b','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(189,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'b','Vulcan VCSEL','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(190,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'c','Vulcan VCSEL','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(191,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'c','Vulcan VCSEL','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(192,'2661','Vulcan VCSEL',NULL,NULL,NULL,NULL,'c','Vulcan VCSEL','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:03:30','2025-01-12 19:03:30'),(217,'2746','Test prod',NULL,NULL,NULL,NULL,'a','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(218,'2746','Test prod',NULL,NULL,NULL,NULL,'a','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(219,'2746','Test prod',NULL,NULL,NULL,NULL,'a','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(220,'2746','Test prod',NULL,NULL,NULL,NULL,'b','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(221,'2746','Test prod',NULL,NULL,NULL,NULL,'b','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(222,'2746','Test prod',NULL,NULL,NULL,NULL,'b','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(223,'2746','Test prod',NULL,NULL,NULL,NULL,'b','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(224,'2746','Test prod',NULL,NULL,NULL,NULL,'b','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(225,'2746','Test prod',NULL,NULL,NULL,NULL,'b','Test prod','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(226,'2746','Test prod',NULL,NULL,NULL,NULL,'c','Test prod','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(227,'2746','Test prod',NULL,NULL,NULL,NULL,'c','Test prod','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(228,'2746','Test prod',NULL,NULL,NULL,NULL,'c','Test prod','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:27:48','2025-01-12 19:27:48'),(241,'432','DIR',NULL,NULL,NULL,NULL,'a','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(242,'432','DIR',NULL,NULL,NULL,NULL,'a','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(243,'432','DIR',NULL,NULL,NULL,NULL,'a','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(244,'432','DIR',NULL,NULL,NULL,NULL,'b','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(245,'432','DIR',NULL,NULL,NULL,NULL,'b','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(246,'432','DIR',NULL,NULL,NULL,NULL,'b','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(247,'432','DIR',NULL,NULL,NULL,NULL,'b','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(248,'432','DIR',NULL,NULL,NULL,NULL,'b','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(249,'432','DIR',NULL,NULL,NULL,NULL,'b','DIR','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(250,'432','DIR',NULL,NULL,NULL,NULL,'c','DIR','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(251,'432','DIR',NULL,NULL,NULL,NULL,'c','DIR','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(252,'432','DIR',NULL,NULL,NULL,NULL,'c','DIR','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-12 19:30:48','2025-01-12 19:30:48'),(265,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'a','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(266,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'a','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(267,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'a','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(268,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'b','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(269,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'b','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(270,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'b','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(271,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'b','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(272,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'b','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(273,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'b','Sentinel IRV - (BLK)','1',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(274,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'c','Sentinel IRV - (BLK)','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(275,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'c','Sentinel IRV - (BLK)','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'),(276,'2806','Sentinel IRV - (BLK)',NULL,NULL,NULL,NULL,'c','Sentinel IRV - (BLK)','on',NULL,'1','2','71.11.87.53',NULL,'2025-01-23 23:36:38','2025-01-23 23:36:38'); /*!40000 ALTER TABLE `product_certifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `products` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `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 `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reseller_inquiries` -- DROP TABLE IF EXISTS `reseller_inquiries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `reseller_inquiries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `status_comment` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reseller_inquiries` -- LOCK TABLES `reseller_inquiries` WRITE; /*!40000 ALTER TABLE `reseller_inquiries` DISABLE KEYS */; INSERT INTO `reseller_inquiries` VALUES (1,NULL,NULL,'dyvu@mailinator.com','Do temporibus invent',NULL,'pending',NULL,'103.244.179.4','2024-08-20 18:57:00','2024-08-20 18:57:00'),(2,NULL,NULL,'sales@highendarms.com','Hello,\r\nMy name is Aaron Kennedy. I run High End Arms/ HEAT Night Vision in Tulsa, OK. I am interested in carrying your lasers in the shop and wanted to inquire about being a dealer for 3EIR. I have sold your products previously under the US Night Vision name and I am familiar with them. Please let me know if and when we could discuss the possibility of HEAT carrying them. The shop number is 918-505-4867 or you can email me at the provided email address.',NULL,'pending',NULL,'184.188.17.122','2024-08-21 22:29:43','2024-08-21 22:29:43'),(3,NULL,NULL,'goodnitegearshop@gmail.com','Hello,\r\n\r\nGood Nite Gear sells digital night vision and related accessories and we are interested in exploring a reseller opportunity with you.\r\n\r\nHere is my information:\r\n\r\nKyle Moran\r\nFounder of Good Nite Gear, LLC.\r\nhttps://goodnitegearshop.com/\r\n(310)766-3669\r\ngoodnitegearshop@gmail.com',NULL,'pending',NULL,'172.114.139.219','2024-08-21 22:30:07','2024-08-21 22:30:07'),(4,NULL,NULL,'ericbarger@tyrannynotallowed.com','I am an 07/02 FFL and already engaged in the business of NV, thermal, and IR lasers and I was hoping to become a direct dealer. I currently have accounts with Wilcox, iRay, Infiray, Pard, and others in the space. If you are accepting new dealers, please let me know what you need from me.',NULL,'pending',NULL,'98.97.153.102','2024-08-22 04:24:23','2024-08-22 04:24:23'),(5,NULL,NULL,'civdefco@gmail.com','Hello, I\'m a FFL 07/02 located in central arkansas and I was looking for more information about becoming a dealer for your ir laser products. I currently only deal in some L3 and steiner products but have heard amazing things about yalls products. Thanks for your time.',NULL,'pending',NULL,'24.35.138.176','2024-09-02 13:03:49','2024-09-02 13:03:49'),(6,NULL,NULL,'test@designsfunnel.com','Test performed by Designs Funnel.',NULL,'pending',NULL,'103.244.179.4','2024-09-11 18:36:42','2024-09-11 18:36:42'),(7,NULL,NULL,'fatpandafirearms@gmail.com','Hello,\r\n\r\nI would be interested in what your dealer requirements are.\r\n\r\nThank You\r\nEric Walker',NULL,'pending',NULL,'74.143.65.74','2024-09-17 19:26:01','2024-09-17 19:26:01'),(8,NULL,NULL,'michael.barrow@clouddefensive.com','Hello, this is Mike over at Cloud Defensive. I met a couple of you guys during the recent East Coast Night Shoot event in Ohio and the rep was showing me some of your products, including an LEP head. I\'d like to get you in contact with our owners to discuss potential brand collaborations.\r\n\r\nThanks and have a great day!',NULL,'pending',NULL,'149.75.81.213','2024-11-15 16:06:37','2024-11-15 16:06:37'),(9,NULL,NULL,'kombatsolutionsllc@gmail.com','Hi my name is Jules owner of Kombat Solutions. Www.kombatsolutions.com I would like to open a dealer account. Thank you.',NULL,'pending',NULL,'104.28.50.162','2025-04-17 03:09:37','2025-04-17 03:09:37'),(10,NULL,NULL,'nightfall.armament@gmail.com','Good evening, I am looking to become a dealer for your LAMs. I deal heavily with LEO and SWAT, these could be great options for their applications. If you have any demo models for me to be able to show for LEO that would be great too and for marketing.',NULL,'pending',NULL,'192.230.212.110','2025-05-31 02:48:28','2025-05-31 02:48:28'); /*!40000 ALTER TABLE `reseller_inquiries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `return_forms` -- DROP TABLE IF EXISTS `return_forms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `return_forms` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `r_number_lookup` varchar(255) DEFAULT NULL, `date_received` varchar(255) DEFAULT NULL, `client_name` varchar(255) DEFAULT NULL, `client_address` varchar(255) DEFAULT NULL, `serial_number` varchar(255) DEFAULT NULL, `r_number` varchar(255) DEFAULT NULL, `problem_description_1` text DEFAULT NULL, `problem_description_2` text DEFAULT NULL, `tech_note` text DEFAULT NULL, `repair_performed` text DEFAULT NULL, `date_returned` varchar(255) DEFAULT NULL, `repaired_replaced` varchar(255) DEFAULT NULL, `replacement_serial_number` varchar(255) DEFAULT NULL, `technician_user_id` varchar(255) DEFAULT NULL, `note` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `return_forms` -- LOCK TABLES `return_forms` WRITE; /*!40000 ALTER TABLE `return_forms` DISABLE KEYS */; INSERT INTO `return_forms` VALUES (1,NULL,'20-Aug-2024','Alison','123 ft','SN0001','0001',NULL,NULL,NULL,NULL,'20-Aug-2024',NULL,NULL,NULL,NULL,'1',NULL,'162.158.148.191','2024-08-20 13:44:48','2024-08-20 13:44:48'),(2,NULL,'2024-08-16','Lara Whitfield','Veniam repudiandaeUllamco dolores corpEnim sequi corrupti29387Aruba','76','653','Veniam quia culpa nostrud odio voluptas numquam nemo culpa ut suscipit enim','Sequi aut debitis commodi qui accusamus ipsum sapiente consectetur Nam consequuntur aliquip do atque occaecat harum','test test Nihil quae fugiat sed illo qui necessitatibus vero accusantium sint magna facilis qui eu neque et iusto minim sed nemoNihil quae fugiat sed illo qui necessitatibus vero accusantium sint magna facilis qui eu neque et iusto minim sed nemoNihil quae fugiat sed illo qui necessitatibus vero accusantium sint magna facilis qui eu neque et iusto minim sed nemoNihil quae fugiat sed illo qui necessitatibus vero accusantium sint magna facilis qui eu neque et iusto minim sed nemoNihil quae fugiat sed illo qui necessitatibus vero accusantium sint magna facilis qui eu neque et iusto minim sed nemo','Nihil quae fugiat sed illo qui necessitatibus vero accusantium sint magna facilis qui eu neque et iusto minim sed nemo','2024-08-01','Replaced','165','5',NULL,'1',NULL,NULL,'2024-08-20 15:16:47','2024-08-20 15:23:11'),(3,NULL,'2024-07-01','Aaron Safir','10421 N 65th PL Paradise valley\n\n10421 n 65th place\nArizona\nParadise valley Arizona, 85253\nUnited States','9035,8111,8305, plus Mike’s DIRV.','9035,8111,8305, plus Mike’s DIRV.','If your able to swap the units out for 4 FDE (DIRV) units i would be very great full. 2 of the units we are sending back are not the DIRV models. If you dont mind doing that it would be solid. Thanks brother. All FDE Please and thank you.','Disengaging when firing laser will loose connection',NULL,'Called Dave and he told me to throw the piece of garbage away :) jk','2024-08-01','Replaced','Requesting 43 FDE DIRV - Juicing allowed.','4',NULL,'1',NULL,NULL,'2024-08-21 07:15:50','2024-08-21 07:15:50'),(4,NULL,'2024-07-26','Benjamin Wallace','1801 Willow Dr\n\nHudson\nWi\n54016\nUnited States','8149','8149','feels like whatever hidden nut inside the housing the mounting bolt attaches to is clicking and rolling, not allowing it to be fully tightened up. I have only mounted this once and moved it once. so it has only been torqued on twice. I have only hand','tightened it with the small allen key that came with it and even then only with the the small end in my hand. no excessive torque was used.',NULL,NULL,'2024-08-31','Replaced','unknown','4',NULL,'1',NULL,NULL,'2024-08-24 13:03:44','2024-08-24 13:03:44'),(5,NULL,'2024-08-25','Bret Warren','812 Kennedy Dr\n\nWinchester\nVA\n22601-2600\nUnited States','8037','8037','During recoil, unit shuts down. Have to re-press and hold for each shot. \r\n\r\nIssue Description from Dave Rhomburg: \"We found that during recoil one batch of brass, (battery compartments / caps), the conductivity was lost \"sometimes\" for a millisecond','Couldn\'t complete form without entering info I don\'t have, such as return date, and \"R\" number.',NULL,NULL,'2024-08-25','Repaired','8037','4',NULL,'1',NULL,NULL,'2024-08-25 19:29:13','2024-08-25 19:29:13'),(6,NULL,'2023-10-01','Jonathan Huebsch','3802 Saratoga Blvd, Apt 833\n\nCorpus Christi\nTX\n78415\nUnited States','00975','00975','Looking to add the flip down diffuser. The removable one had its lens bust out in my grip.\r\n\r\nThis form made me put in the technician info, I just made it up…',NULL,NULL,NULL,'2024-08-24','Repaired','00975','4',NULL,'1',NULL,NULL,'2024-08-25 19:35:15','2024-08-25 19:35:15'); /*!40000 ALTER TABLE `return_forms` 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=105 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,1,'create-user',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(2,1,'read-user',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(3,1,'update-user',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(4,1,'delete-user',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(5,1,'read-product',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(6,1,'update-product',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(7,1,'create-product',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(8,1,'read-variable',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(9,1,'update-variable',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(10,1,'create-variable',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(11,1,'read-attribute',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(12,1,'update-attribute',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(13,1,'create-attribute',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(14,1,'read-attribute-term',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(15,1,'update-attribute-term',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(16,1,'create-attribute-term',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(17,1,'read-serial',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(18,1,'update-serial',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(19,1,'create-serial',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(20,1,'read-category',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(21,1,'update-category',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(22,1,'create-category',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(23,1,'read-certification',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(24,1,'update-certification',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(25,1,'create-certification',1,'1','172.71.135.105','1','2024-08-21 12:45:04','2024-08-21 12:45:04',NULL),(55,3,'create-user',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(56,3,'read-user',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(57,3,'update-user',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(58,3,'delete-user',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(59,3,'read-product',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(60,3,'update-product',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(61,3,'create-product',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(62,3,'read-variable',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(63,3,'update-variable',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(64,3,'create-variable',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(65,3,'read-attribute',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(66,3,'update-attribute',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(67,3,'create-attribute',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(68,3,'read-attribute-term',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(69,3,'update-attribute-term',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(70,3,'create-attribute-term',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(71,3,'read-serial',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(72,3,'update-serial',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(73,3,'create-serial',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(74,3,'read-category',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(75,3,'update-category',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(76,3,'create-category',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(77,3,'read-certification',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(78,3,'update-certification',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(79,3,'create-certification',1,'1','172.71.122.227','1','2024-08-26 12:04:32','2024-08-26 12:04:32',NULL),(80,2,'create-user',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(81,2,'read-user',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(82,2,'update-user',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(83,2,'delete-user',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(84,2,'read-product',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(85,2,'update-product',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(86,2,'create-product',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(87,2,'read-variable',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(88,2,'update-variable',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(89,2,'create-variable',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(90,2,'read-attribute',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(91,2,'update-attribute',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(92,2,'create-attribute',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(93,2,'read-attribute-term',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(94,2,'update-attribute-term',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(95,2,'create-attribute-term',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(96,2,'read-serial',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(97,2,'update-serial',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(98,2,'create-serial',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(99,2,'read-category',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(100,2,'update-category',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(101,2,'create-category',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(102,2,'read-certification',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(103,2,'update-certification',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',NULL),(104,2,'create-certification',1,'1','172.71.122.227','1','2024-08-26 12:05:22','2024-08-26 12:05:22',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-08-20 13:44:00','2024-08-20 13:44:00',NULL),(2,'Admin',1,1,NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL),(3,'User',1,1,NULL,NULL,'2024-08-20 13:44:00','2024-08-20 13:44:00',NULL); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `serial_numbers` -- DROP TABLE IF EXISTS `serial_numbers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `serial_numbers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `product_id` varchar(255) DEFAULT NULL, `product_name` varchar(255) DEFAULT NULL, `serial_number` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `user_id` varchar(255) DEFAULT NULL, `user_ip` 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `serial_numbers` -- LOCK TABLES `serial_numbers` WRITE; /*!40000 ALTER TABLE `serial_numbers` DISABLE KEYS */; /*!40000 ALTER TABLE `serial_numbers` 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=9 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','designsfunnel@gmail.com',NULL,'$2y$10$W58cuiSqpIQ6i2NMy5imi.Vqq2yybzVLBtBSnJnnR1yxbY888A2vO',NULL,NULL,NULL,NULL,'1',NULL,'0','Z87o2YZM9wupBA9lUHO3tD7wMkh28rjISRUb7bG04F3NHJMEN5unqr7sYhBH','2024-08-20 13:44:01','2024-08-20 13:44:01'),(2,'Super','Admin','superadmin@3eir.com',NULL,'$2y$10$SKM8Y8Ueaex42KfJtm/f7eHX/f61mbXz0y/rYUTAwSrJ4tXBFV74a',NULL,NULL,NULL,NULL,'1',NULL,'1','A8k8F53bot37jzkXttcXgnSlXFPbJYOVgJH8J8n6FkwO5rS2xlg9snCFajfT','2024-08-20 13:44:01','2025-01-12 19:00:34'),(4,'Dave',NULL,'daver@3eir.com',NULL,'$2y$10$le4DKeBDMAz1sTgrRvUm9O00OSgNfH5NIsNhD9EDIvzjq2tFxWsm6',NULL,NULL,NULL,NULL,'1',NULL,'1','3eYJok9HTjLMUscLk1bUkVgJK62TnlJkRwXhF59jzddd7nPMEsrNdXDkgprx','2024-08-20 13:44:01','2025-01-12 19:04:19'),(5,'Rob',NULL,'rob@3eir.com',NULL,'$2y$10$bcxFmAIRXY0YUjU6ZX/t3.oN0di6w11NvK1wlDxu0K/4V4zSuac0W',NULL,NULL,NULL,NULL,'1',NULL,'3',NULL,'2024-08-20 13:44:01','2024-08-20 13:44:01'); /*!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:56:27