-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `snipeit_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `accessories`
--

CREATE TABLE `accessories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `qty` int(11) NOT NULL DEFAULT 0,
  `requestable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_cost` decimal(20,2) DEFAULT NULL,
  `order_number` varchar(191) DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `min_amt` int(11) DEFAULT NULL,
  `manufacturer_id` int(11) DEFAULT NULL,
  `model_number` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `accessories_checkout`
--

CREATE TABLE `accessories_checkout` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `accessory_id` int(11) DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `assigned_type` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `action_logs`
--

CREATE TABLE `action_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `action_type` varchar(191) NOT NULL,
  `target_id` int(11) DEFAULT NULL,
  `target_type` varchar(191) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `filename` text DEFAULT NULL,
  `item_type` varchar(191) NOT NULL,
  `item_id` int(11) NOT NULL,
  `expected_checkin` date DEFAULT NULL,
  `accepted_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `thread_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `accept_signature` varchar(100) DEFAULT NULL,
  `log_meta` text DEFAULT NULL,
  `action_date` datetime DEFAULT NULL,
  `stored_eula` text DEFAULT NULL,
  `action_source` varchar(191) DEFAULT NULL,
  `remote_ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `action_logs`
--

INSERT INTO `action_logs` (`id`, `created_by`, `action_type`, `target_id`, `target_type`, `location_id`, `note`, `filename`, `item_type`, `item_id`, `expected_checkin`, `accepted_id`, `created_at`, `updated_at`, `deleted_at`, `thread_id`, `company_id`, `accept_signature`, `log_meta`, `action_date`, `stored_eula`, `action_source`, `remote_ip`, `user_agent`) VALUES
(1, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 1, NULL, NULL, '2025-09-01 11:56:47', '2025-09-01 11:56:47', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:26:47', NULL, 'gui', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(2, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 2, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(3, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 3, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(4, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 4, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(5, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 5, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(6, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 6, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(7, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 7, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(8, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 8, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(9, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 9, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(10, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 10, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(11, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 11, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(12, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 12, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(13, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 13, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(14, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 14, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(15, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 15, NULL, NULL, '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:38', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(16, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 16, NULL, NULL, '2025-09-01 12:11:39', '2025-09-01 12:11:39', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:39', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(17, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 17, NULL, NULL, '2025-09-01 12:11:39', '2025-09-01 12:11:39', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:39', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(18, NULL, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 18, NULL, NULL, '2025-09-01 12:11:39', '2025-09-01 12:11:39', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:41:39', NULL, 'cli/unknown', '127.0.0.1', 'Symfony'),
(19, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 19, NULL, NULL, '2025-09-01 12:29:36', '2025-09-01 12:29:36', NULL, NULL, NULL, NULL, NULL, '2025-09-01 17:59:36', NULL, 'gui', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.108 Safari/537.36'),
(20, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 20, NULL, NULL, '2025-09-02 04:37:20', '2025-09-02 04:37:20', NULL, NULL, NULL, NULL, NULL, '2025-09-02 10:07:20', NULL, 'gui', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(21, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 21, NULL, NULL, '2025-09-02 04:40:44', '2025-09-02 04:40:44', NULL, NULL, NULL, NULL, NULL, '2025-09-02 10:10:44', NULL, 'gui', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(22, NULL, 'update', 21, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 21, NULL, NULL, '2025-09-02 04:43:24', '2025-09-02 04:43:24', NULL, NULL, NULL, NULL, '{\"password\":{\"old\":\"*************\",\"new\":\"*************\"}}', '2025-09-02 10:13:24', NULL, 'gui', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(23, 21, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 22, NULL, NULL, '2025-09-02 04:57:33', '2025-09-02 04:57:33', NULL, NULL, NULL, NULL, NULL, '2025-09-02 10:27:33', NULL, 'gui', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(24, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 23, NULL, NULL, '2025-09-05 11:08:30', '2025-09-05 11:08:30', NULL, NULL, NULL, NULL, NULL, '2025-09-05 16:38:30', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(25, 1, 'delete', 14, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 14, NULL, NULL, '2025-09-06 11:50:56', '2025-09-06 11:50:56', NULL, NULL, 13, NULL, NULL, '2025-09-06 17:20:56', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(26, 1, 'delete', 15, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 15, NULL, NULL, '2025-09-06 11:54:12', '2025-09-06 11:54:12', NULL, NULL, 14, NULL, NULL, '2025-09-06 17:24:12', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(27, 1, 'delete', 16, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 16, NULL, NULL, '2025-09-06 11:54:36', '2025-09-06 11:54:36', NULL, NULL, 15, NULL, NULL, '2025-09-06 17:24:36', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(28, 1, 'delete', 4, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 4, NULL, NULL, '2025-09-06 11:55:08', '2025-09-06 11:55:08', NULL, NULL, 3, NULL, NULL, '2025-09-06 17:25:08', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(29, 1, 'delete', 12, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 12, NULL, NULL, '2025-09-06 11:55:20', '2025-09-06 11:55:20', NULL, NULL, 11, NULL, NULL, '2025-09-06 17:25:20', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(30, 1, 'delete', 11, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 11, NULL, NULL, '2025-09-06 11:55:34', '2025-09-06 11:55:34', NULL, NULL, 10, NULL, NULL, '2025-09-06 17:25:34', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(31, 1, 'delete', 13, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 13, NULL, NULL, '2025-09-06 11:55:46', '2025-09-06 11:55:46', NULL, NULL, 12, NULL, NULL, '2025-09-06 17:25:46', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(32, 1, 'delete', 20, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 20, NULL, NULL, '2025-09-06 11:56:24', '2025-09-06 11:56:24', NULL, NULL, NULL, NULL, NULL, '2025-09-06 17:26:24', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(33, 1, 'delete', 5, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 5, NULL, NULL, '2025-09-06 11:56:38', '2025-09-06 11:56:38', NULL, NULL, 4, NULL, NULL, '2025-09-06 17:26:38', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(34, 1, 'delete', 7, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 7, NULL, NULL, '2025-09-06 11:56:52', '2025-09-06 11:56:52', NULL, NULL, 6, NULL, NULL, '2025-09-06 17:26:52', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(35, 1, 'delete', 6, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 6, NULL, NULL, '2025-09-06 11:57:16', '2025-09-06 11:57:16', NULL, NULL, 5, NULL, NULL, '2025-09-06 17:27:16', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(36, 1, 'delete', 9, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 9, NULL, NULL, '2025-09-06 11:57:30', '2025-09-06 11:57:30', NULL, NULL, 8, NULL, NULL, '2025-09-06 17:27:30', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(37, 1, 'delete', 2, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 2, NULL, NULL, '2025-09-06 11:57:44', '2025-09-06 11:57:44', NULL, NULL, 1, NULL, NULL, '2025-09-06 17:27:44', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(38, 1, 'delete', 10, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 10, NULL, NULL, '2025-09-06 11:58:02', '2025-09-06 11:58:02', NULL, NULL, 9, NULL, NULL, '2025-09-06 17:28:02', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(39, 1, 'delete', 3, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 3, NULL, NULL, '2025-09-06 11:58:19', '2025-09-06 11:58:19', NULL, NULL, 2, NULL, NULL, '2025-09-06 17:28:19', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(40, 1, 'delete', 17, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 17, NULL, NULL, '2025-09-06 11:58:30', '2025-09-06 11:58:30', NULL, NULL, 16, NULL, NULL, '2025-09-06 17:28:30', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(41, 1, 'delete', 8, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 8, NULL, NULL, '2025-09-06 11:58:54', '2025-09-06 11:58:54', NULL, NULL, 7, NULL, NULL, '2025-09-06 17:28:54', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(42, 1, 'delete', 18, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 18, NULL, NULL, '2025-09-06 11:59:05', '2025-09-06 11:59:05', NULL, NULL, 17, NULL, NULL, '2025-09-06 17:29:05', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(43, 1, 'update', 1, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 1, NULL, NULL, '2025-09-06 12:18:21', '2025-09-06 12:18:21', NULL, NULL, NULL, NULL, '{\"first_name\":{\"old\":\"admin\",\"new\":\"shivam\"}}', '2025-09-06 17:48:21', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(44, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\Asset', 1, NULL, NULL, '2025-09-06 12:22:47', '2025-09-06 12:22:47', NULL, NULL, 9, NULL, NULL, '2025-09-06 17:52:47', NULL, 'gui', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(45, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 24, NULL, NULL, '2025-09-09 06:58:53', '2025-09-09 06:58:53', NULL, NULL, 22, NULL, NULL, '2025-09-09 12:28:53', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(46, 24, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 25, NULL, NULL, '2025-09-09 07:15:24', '2025-09-09 07:15:24', NULL, NULL, 22, NULL, NULL, '2025-09-09 12:45:24', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(47, 24, 'update', 25, 'App\\Models\\User', NULL, NULL, NULL, 'App\\Models\\User', 25, NULL, NULL, '2025-09-09 07:18:23', '2025-09-09 07:18:23', NULL, NULL, 22, NULL, '{\"activated\":{\"old\":0,\"new\":\"1\"}}', '2025-09-09 12:48:23', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(48, 25, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\Asset', 2, NULL, NULL, '2025-09-09 09:01:38', '2025-09-09 09:01:38', NULL, NULL, 22, NULL, NULL, '2025-09-09 14:31:38', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0'),
(49, 25, 'update', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\Asset', 2, NULL, NULL, '2025-09-09 09:04:01', '2025-09-09 09:04:01', NULL, NULL, 22, NULL, '{\"status_id\":{\"old\":4,\"new\":\"2\"}}', '2025-09-09 14:34:01', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0'),
(50, 1, 'create', NULL, NULL, NULL, NULL, NULL, 'App\\Models\\User', 26, NULL, NULL, '2025-09-09 09:15:21', '2025-09-09 09:15:21', NULL, NULL, 21, NULL, NULL, '2025-09-09 14:45:21', NULL, 'gui', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36');

-- --------------------------------------------------------

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `asset_tag` varchar(191) DEFAULT NULL,
  `model_id` int(11) DEFAULT NULL,
  `serial` varchar(191) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `asset_eol_date` date DEFAULT NULL,
  `eol_explicit` tinyint(1) NOT NULL DEFAULT 0,
  `purchase_cost` decimal(20,2) DEFAULT NULL,
  `order_number` varchar(191) DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `physical` tinyint(1) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status_id` int(11) DEFAULT NULL,
  `archived` tinyint(1) DEFAULT 0,
  `warranty_months` int(11) DEFAULT NULL,
  `depreciate` tinyint(1) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `requestable` tinyint(4) NOT NULL DEFAULT 0,
  `rtd_location_id` int(11) DEFAULT NULL,
  `_snipeit_mac_address_1` varchar(191) DEFAULT NULL,
  `accepted` varchar(191) DEFAULT NULL,
  `last_checkout` datetime DEFAULT NULL,
  `last_checkin` datetime DEFAULT NULL,
  `expected_checkin` date DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `assigned_type` varchar(191) DEFAULT NULL,
  `last_audit_date` datetime DEFAULT NULL,
  `next_audit_date` date DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `checkin_counter` int(11) NOT NULL DEFAULT 0,
  `checkout_counter` int(11) NOT NULL DEFAULT 0,
  `requests_counter` int(11) NOT NULL DEFAULT 0,
  `byod` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assets`
--

INSERT INTO `assets` (`id`, `name`, `asset_tag`, `model_id`, `serial`, `purchase_date`, `asset_eol_date`, `eol_explicit`, `purchase_cost`, `order_number`, `assigned_to`, `notes`, `image`, `created_by`, `created_at`, `updated_at`, `physical`, `deleted_at`, `status_id`, `archived`, `warranty_months`, `depreciate`, `supplier_id`, `requestable`, `rtd_location_id`, `_snipeit_mac_address_1`, `accepted`, `last_checkout`, `last_checkin`, `expected_checkin`, `company_id`, `assigned_type`, `last_audit_date`, `next_audit_date`, `location_id`, `checkin_counter`, `checkout_counter`, `requests_counter`, `byod`) VALUES
(1, NULL, 'laptop', 10, 'laptopZ1c', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1, '2025-09-06 12:22:47', '2025-09-06 12:22:47', 1, NULL, 4, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 9, NULL, NULL, NULL, NULL, 0, 0, 0, 0),
(2, NULL, 'Mac m3', 19, 'M', '2025-09-09', NULL, 0, 100000.00, 'order101', NULL, NULL, 'Asset-image--1qG6KY2uIF.jpg', 25, '2025-09-09 09:01:37', '2025-09-09 09:04:01', 1, NULL, 2, 0, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, 22, NULL, NULL, NULL, 1, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `asset_logs`
--

CREATE TABLE `asset_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `action_type` varchar(191) NOT NULL,
  `asset_id` int(11) NOT NULL,
  `checkedout_to` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `asset_type` varchar(100) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `filename` text DEFAULT NULL,
  `requested_at` datetime DEFAULT NULL,
  `accepted_at` datetime DEFAULT NULL,
  `accessory_id` int(11) DEFAULT NULL,
  `accepted_id` int(11) DEFAULT NULL,
  `consumable_id` int(11) DEFAULT NULL,
  `expected_checkin` date DEFAULT NULL,
  `component_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `asset_uploads`
--

CREATE TABLE `asset_uploads` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `filename` varchar(191) NOT NULL,
  `asset_id` int(11) NOT NULL,
  `filenotes` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `eula_text` longtext DEFAULT NULL,
  `use_default_eula` tinyint(1) NOT NULL DEFAULT 0,
  `require_acceptance` tinyint(1) NOT NULL DEFAULT 0,
  `alert_on_response` tinyint(1) NOT NULL DEFAULT 0,
  `category_type` varchar(191) DEFAULT 'asset',
  `checkin_email` tinyint(1) NOT NULL DEFAULT 0,
  `image` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`, `created_by`, `deleted_at`, `eula_text`, `use_default_eula`, `require_acceptance`, `alert_on_response`, `category_type`, `checkin_email`, `image`, `notes`) VALUES
(1, 'Misc Software', '2025-09-01 11:44:40', '2025-09-01 11:44:40', NULL, NULL, NULL, 0, 0, 0, 'license', 0, NULL, NULL),
(2, 'Laptops', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 2, NULL, 'Minima dolor debitis numquam maiores distinctio corrupti labore. Aspernatur in saepe cum numquam aut quisquam.', 0, 1, 0, 'asset', 1, NULL, 'Created by DB seeder'),
(3, 'Desktops', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 10, NULL, 'Voluptatum dignissimos voluptas fugit aspernatur in. Quas aut aut mollitia adipisci eius ex. Quae voluptatum eum iusto qui. Exercitationem culpa iusto quia ipsam accusantium voluptates possimus.', 0, 1, 0, 'asset', 1, NULL, 'Created by DB seeder'),
(4, 'VOIP Phones', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 11, NULL, 'Vel necessitatibus non quae. Distinctio esse esse autem excepturi quis repudiandae vero. Et impedit tempora consequatur voluptates maiores.', 0, 0, 0, 'asset', 1, NULL, 'Created by DB seeder'),
(5, 'Tablets', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 13, NULL, 'Doloribus impedit at ipsum debitis. Qui ut qui harum aut placeat et atque.', 0, 0, 0, 'asset', 1, NULL, 'Created by DB seeder'),
(6, 'Mobile Phones', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 14, NULL, 'Quibusdam blanditiis quia voluptas rem numquam maxime. Qui porro reiciendis voluptatem qui est et.', 0, 0, 0, 'asset', 1, NULL, 'Created by DB seeder'),
(7, 'Displays', '2025-09-01 12:11:39', '2025-09-01 12:11:39', 16, NULL, 'Et aperiam accusantium voluptates sed in quibusdam temporibus. Ut ad et voluptatibus rem veniam ipsam. Distinctio eos mollitia cumque dolorem natus quos at. Rem tempore ratione et qui et perspiciatis molestiae. Sit dolor quidem voluptatem neque amet accusantium corrupti.', 0, 0, 0, 'asset', 1, NULL, 'Created by DB seeder');

-- --------------------------------------------------------

--
-- Table structure for table `checkout_acceptances`
--

CREATE TABLE `checkout_acceptances` (
  `id` int(10) UNSIGNED NOT NULL,
  `checkoutable_type` varchar(191) NOT NULL,
  `checkoutable_id` bigint(20) UNSIGNED NOT NULL,
  `assigned_to_id` int(11) DEFAULT NULL,
  `signature_filename` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `alert_on_response_id` bigint(20) UNSIGNED DEFAULT NULL,
  `accepted_at` timestamp NULL DEFAULT NULL,
  `declined_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `stored_eula` text DEFAULT NULL,
  `stored_eula_file` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `checkout_requests`
--

CREATE TABLE `checkout_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `requestable_id` int(11) NOT NULL,
  `requestable_type` varchar(191) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `canceled_at` datetime DEFAULT NULL,
  `fulfilled_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `name`, `fax`, `email`, `phone`, `created_at`, `updated_at`, `image`, `created_by`, `notes`) VALUES
(20, 'eProtect360', NULL, 'grc@eprotect360.com', NULL, '2025-09-09 06:01:31', '2025-09-09 06:01:31', 'Company-image--qS0ORd8kE4.png', 1, NULL),
(21, 'a company', NULL, 'a@example.com', NULL, '2025-09-09 06:16:38', '2025-09-09 06:16:38', 'Company-image--Cg2eGp2uQH.jpg', 1, NULL),
(22, 'b company', NULL, 'b@example.com', NULL, '2025-09-09 06:19:00', '2025-09-09 06:19:00', 'Company-image--pAc2emJlXB.png', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `components`
--

CREATE TABLE `components` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `qty` int(11) NOT NULL DEFAULT 1,
  `order_number` varchar(191) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_cost` decimal(20,2) DEFAULT NULL,
  `model_number` varchar(191) DEFAULT NULL,
  `manufacturer_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `min_amt` int(11) DEFAULT NULL,
  `serial` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `components_assets`
--

CREATE TABLE `components_assets` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `assigned_qty` int(11) DEFAULT 1,
  `component_id` int(11) DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `note` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `consumables`
--

CREATE TABLE `consumables` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `qty` int(11) NOT NULL DEFAULT 0,
  `requestable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_cost` decimal(20,2) DEFAULT NULL,
  `order_number` varchar(191) DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `min_amt` int(11) DEFAULT NULL,
  `model_number` varchar(191) DEFAULT NULL,
  `manufacturer_id` int(11) DEFAULT NULL,
  `item_no` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `consumables_users`
--

CREATE TABLE `consumables_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `consumable_id` int(11) DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `note` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `custom_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `format` varchar(191) NOT NULL,
  `element` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `field_values` text DEFAULT NULL,
  `field_encrypted` tinyint(1) NOT NULL DEFAULT 0,
  `db_column` varchar(191) DEFAULT NULL,
  `help_text` text DEFAULT NULL,
  `show_in_email` tinyint(1) NOT NULL DEFAULT 0,
  `show_in_requestable_list` tinyint(1) DEFAULT 0,
  `is_unique` tinyint(1) DEFAULT 0,
  `display_in_user_view` tinyint(1) DEFAULT 0,
  `auto_add_to_fieldsets` tinyint(1) DEFAULT 0,
  `show_in_listview` tinyint(1) DEFAULT 0,
  `display_checkin` tinyint(1) NOT NULL DEFAULT 0,
  `display_checkout` tinyint(1) NOT NULL DEFAULT 0,
  `display_audit` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `custom_fields` (`id`, `name`, `format`, `element`, `created_at`, `updated_at`, `created_by`, `field_values`, `field_encrypted`, `db_column`, `help_text`, `show_in_email`, `show_in_requestable_list`, `is_unique`, `display_in_user_view`, `auto_add_to_fieldsets`, `show_in_listview`, `display_checkin`, `display_checkout`, `display_audit`) VALUES
(1, 'MAC Address', 'regex:/^[a-fA-F0-9]{2}:[a-fA-F0-9]{2}:[a-fA-F0-9]{2}:[a-fA-F0-9]{2}:[a-fA-F0-9]{2}:[a-fA-F0-9]{2}$/', 'text', NULL, '2025-09-01 11:44:36', NULL, NULL, 0, '_snipeit_mac_address_1', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `custom_fieldsets`
--

CREATE TABLE `custom_fieldsets` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_fieldsets`
--

INSERT INTO `custom_fieldsets` (`id`, `name`, `created_at`, `updated_at`, `created_by`) VALUES
(1, 'Asset with MAC Address', NULL, NULL, NULL),
(2, 'Laptops and Desktops', '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL),
(3, 'Mobile Devices', '2025-09-01 12:11:38', '2025-09-01 12:11:38', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `custom_field_custom_fieldset`
--

CREATE TABLE `custom_field_custom_fieldset` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `custom_fieldset_id` int(11) NOT NULL,
  `order` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_field_custom_fieldset`
--

INSERT INTO `custom_field_custom_fieldset` (`id`, `custom_field_id`, `custom_fieldset_id`, `order`, `required`) VALUES
(1, 1, 1, 1, 0);

-- --------------------------------------------------------

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

CREATE TABLE `departments` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `manager_id` int(11) DEFAULT NULL,
  `notes` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `departments` (`id`, `name`, `fax`, `phone`, `created_by`, `company_id`, `location_id`, `manager_id`, `notes`, `created_at`, `updated_at`, `deleted_at`, `image`) VALUES
(1, 'Developer', NULL, NULL, 1, 22, 1, 1, NULL, '2025-09-09 06:49:42', '2025-09-09 06:49:42', NULL, NULL),
(2, 'Administrator', NULL, NULL, 1, 22, 1, NULL, NULL, '2025-09-09 06:52:19', '2025-09-09 06:52:19', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `depreciations`
--

CREATE TABLE `depreciations` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `months` int(11) NOT NULL,
  `depreciation_min` decimal(8,2) DEFAULT NULL,
  `depreciation_type` varchar(191) NOT NULL DEFAULT 'amount',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `depreciations`
--

INSERT INTO `depreciations` (`id`, `name`, `months`, `depreciation_min`, `depreciation_type`, `created_at`, `updated_at`, `created_by`) VALUES
(1, 'Computer Depreciation', 36, NULL, 'amount', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 3),
(2, 'Mobile Phone Depreciation', 24, NULL, 'amount', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 15),
(3, 'Display Depreciation', 12, NULL, 'amount', '2025-09-01 12:11:39', '2025-09-01 12:11:39', 18);

-- --------------------------------------------------------

--
-- Table structure for table `imports`
--

CREATE TABLE `imports` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `file_path` varchar(191) NOT NULL,
  `filesize` int(11) NOT NULL,
  `import_type` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `header_row` text DEFAULT NULL,
  `first_row` text DEFAULT NULL,
  `field_map` text DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `kits`
--

CREATE TABLE `kits` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `kits_accessories`
--

CREATE TABLE `kits_accessories` (
  `id` int(10) UNSIGNED NOT NULL,
  `kit_id` int(11) DEFAULT NULL,
  `accessory_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `kits_consumables`
--

CREATE TABLE `kits_consumables` (
  `id` int(10) UNSIGNED NOT NULL,
  `kit_id` int(11) DEFAULT NULL,
  `consumable_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `kits_licenses`
--

CREATE TABLE `kits_licenses` (
  `id` int(10) UNSIGNED NOT NULL,
  `kit_id` int(11) DEFAULT NULL,
  `license_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `kits_models`
--

CREATE TABLE `kits_models` (
  `id` int(10) UNSIGNED NOT NULL,
  `kit_id` int(11) DEFAULT NULL,
  `model_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `licenses`
--

CREATE TABLE `licenses` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `serial` text DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_cost` decimal(20,2) DEFAULT NULL,
  `order_number` varchar(50) DEFAULT NULL,
  `seats` int(11) NOT NULL DEFAULT 1,
  `notes` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `depreciation_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `license_name` varchar(120) DEFAULT NULL,
  `license_email` varchar(191) DEFAULT NULL,
  `depreciate` tinyint(1) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `purchase_order` varchar(191) DEFAULT NULL,
  `termination_date` date DEFAULT NULL,
  `maintained` tinyint(1) DEFAULT NULL,
  `reassignable` tinyint(1) NOT NULL DEFAULT 1,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `manufacturer_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `min_amt` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `license_seats`
--

CREATE TABLE `license_seats` (
  `id` int(10) UNSIGNED NOT NULL,
  `license_id` int(11) DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `address2` varchar(191) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `ldap_ou` varchar(191) DEFAULT NULL,
  `manager_id` int(11) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `city`, `state`, `country`, `created_at`, `updated_at`, `created_by`, `address`, `address2`, `zip`, `fax`, `phone`, `deleted_at`, `parent_id`, `currency`, `ldap_ou`, `manager_id`, `image`, `company_id`, `notes`) VALUES
(1, 'Andheri', 'Mumbai', NULL, 'IN', '2025-09-02 04:50:07', '2025-09-02 04:50:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(191) DEFAULT NULL,
  `remote_ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(191) DEFAULT NULL,
  `successful` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_attempts`
--

INSERT INTO `login_attempts` (`id`, `username`, `remote_ip`, `user_agent`, `successful`, `created_at`, `updated_at`) VALUES
(1, 'admin', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-01 11:56:47', NULL),
(2, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.108 Safari/537.36', 1, '2025-09-01 12:27:46', NULL),
(3, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-02 04:22:30', NULL),
(4, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-02 04:28:33', NULL),
(5, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-02 04:32:08', NULL),
(6, 'ashutosh', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-02 04:43:24', NULL),
(7, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 0, '2025-09-03 04:44:08', NULL),
(8, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 0, '2025-09-03 04:44:44', NULL),
(9, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 04:45:14', NULL),
(10, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 05:22:30', NULL),
(11, 'ajay', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 0, '2025-09-03 05:27:57', NULL),
(12, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 05:28:28', NULL),
(13, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 06:14:59', NULL),
(14, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 07:27:34', NULL),
(15, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 07:42:15', NULL),
(16, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 07:42:50', NULL),
(17, 'ajayladva', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 07:45:43', NULL),
(18, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 0, '2025-09-03 08:45:41', NULL),
(19, 'ajayladva', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 09:13:43', NULL),
(20, 'ajayladva', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-03 09:32:34', NULL),
(21, 'admin', '45.64.194.110', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-04 04:27:13', NULL),
(22, 'ajayladva', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-05 08:30:17', NULL),
(23, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-05 10:29:14', NULL),
(24, 'jagruti.desai@eprotect360.com', '49.206.134.22', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 0, '2025-09-05 11:11:25', NULL),
(25, 'jagruti.Desai@eprotect360.com', '49.206.134.22', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 0, '2025-09-05 11:12:06', NULL),
(26, 'jagruti', '49.206.134.22', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 0, '2025-09-05 11:12:46', NULL),
(27, 'jagruti', '49.206.134.22', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36 Edg/139.0.0.0', 1, '2025-09-05 11:13:12', NULL),
(28, 'admin', '223.228.143.192', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-06 05:27:39', NULL),
(29, 'admin', '223.228.143.192', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-06 09:04:36', NULL),
(30, 'admin', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-06 12:01:30', NULL),
(31, 'admin', '223.228.130.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-06 12:17:20', NULL),
(32, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-08 05:17:02', NULL),
(33, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-08 12:01:51', NULL),
(34, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-08 12:02:09', NULL),
(35, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 0, '2025-09-09 05:56:50', NULL),
(36, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-09 05:57:16', NULL),
(37, 'b', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-09 07:00:45', NULL),
(38, 'bemp1', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0', 0, '2025-09-09 07:17:20', NULL),
(39, 'bemp1', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0', 0, '2025-09-09 07:17:31', NULL),
(40, 'bemp1', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0', 0, '2025-09-09 07:17:51', NULL),
(41, 'bemp1', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0', 1, '2025-09-09 07:18:39', NULL),
(42, 'a', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0', 1, '2025-09-09 09:17:20', NULL),
(43, 'admin', '42.111.111.106', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-09 12:20:59', NULL),
(44, 'a', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-10 04:44:51', NULL),
(45, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 1, '2025-09-10 12:15:06', NULL),
(46, 'ajayladva', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-11 05:42:31', NULL),
(47, 'ajayladva', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-11 05:43:41', NULL),
(48, 'jagruti', '49.206.134.22', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36 Edg/139.0.0.0', 1, '2025-09-11 05:52:40', NULL),
(49, 'ashutosh', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-11 06:29:43', NULL),
(50, 'ajayladva', '42.108.75.208', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-12 07:22:55', NULL),
(51, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-15 04:50:26', NULL),
(52, 'ajayladva', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-15 10:40:06', NULL),
(53, 'ajayladva', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-15 11:10:52', NULL),
(54, 'ajayladva', '42.111.97.47', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-17 08:36:48', NULL),
(55, 'admin', '223.228.131.76', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-27 09:39:56', NULL),
(56, 'ajayladva', '103.216.71.74', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 1, '2025-09-27 10:40:15', NULL),
(57, 'ajayladva', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 1, '2025-10-10 05:08:44', NULL),
(58, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 1, '2025-10-27 12:27:56', NULL),
(59, 'admin', '110.172.20.168', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 1, '2025-10-27 12:27:56', NULL),
(60, 'ajayladva', '103.216.71.83', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 1, '2025-11-21 11:29:18', NULL),
(61, 'ajayladva', '103.216.71.83', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 1, '2025-11-22 04:53:10', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `maintenances`
--

CREATE TABLE `maintenances` (
  `id` int(10) UNSIGNED NOT NULL,
  `asset_id` int(10) UNSIGNED NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `asset_maintenance_type` varchar(191) NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_warranty` tinyint(1) NOT NULL,
  `start_date` date NOT NULL,
  `completion_date` date DEFAULT NULL,
  `asset_maintenance_time` int(11) DEFAULT NULL,
  `notes` longtext DEFAULT NULL,
  `image` text DEFAULT NULL,
  `cost` decimal(20,2) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `manufacturers`
--

CREATE TABLE `manufacturers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `url` varchar(191) DEFAULT NULL,
  `support_url` varchar(191) DEFAULT NULL,
  `warranty_lookup_url` varchar(191) DEFAULT NULL,
  `support_phone` varchar(191) DEFAULT NULL,
  `support_email` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manufacturers`
--

INSERT INTO `manufacturers` (`id`, `name`, `created_at`, `updated_at`, `created_by`, `deleted_at`, `url`, `support_url`, `warranty_lookup_url`, `support_phone`, `support_email`, `image`, `notes`) VALUES
(1, 'Apple', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 4, NULL, 'https://apple.com', 'https://support.apple.com', 'https://checkcoverage.apple.com', '(754) 462-5081', 'avolkman@example.org', 'apple.jpg', 'Created by DB seeder'),
(2, 'Microsoft', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 5, NULL, 'https://microsoft.com', 'https://support.microsoft.com', 'https://account.microsoft.com/devices', '1-530-446-4160', 'shanel.kerluke@example.org', 'microsoft.png', 'Created by DB seeder'),
(3, 'Dell', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 6, NULL, 'https://dell.com', 'https://support.dell.com', 'https://www.dell.com/support/home/en-us/Products/?app=warranty', '+1-413-716-2466', 'gdickinson@example.net', 'dell.png', 'Created by DB seeder'),
(4, 'HP', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 7, NULL, 'https://hp.com', 'https://support.hp.com', NULL, '458-323-4575', 'ekoelpin@example.com', 'hp.png', 'Created by DB seeder'),
(5, 'Asus', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 8, NULL, 'https://asus.com', 'https://support.asus.com', NULL, '(283) 553-8958', 'toy.leta@example.net', 'asus.png', 'Created by DB seeder'),
(6, 'Lenovo', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 9, NULL, 'https://lenovo.com', 'https://support.lenovo.com', NULL, '820-275-2179', 'stephany72@example.com', 'lenovo.jpg', 'Created by DB seeder'),
(7, 'Polycom', '2025-09-01 12:11:38', '2025-09-01 12:11:38', 12, NULL, 'https://polycom.com', 'https://support.polycom.com', NULL, '212-835-1274', 'darlene29@example.net', 'polycom.png', 'Created by DB seeder'),
(8, 'LG', '2025-09-01 12:11:39', '2025-09-01 12:11:39', 17, NULL, 'https://lg.com', 'https://support.lg.com', NULL, '1-774-870-9660', 'ilarson@example.net', 'lg.jpg', 'Created by DB seeder');

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2012_12_06_225921_migration_cartalyst_sentry_install_users', 1),
(2, '2012_12_06_225929_migration_cartalyst_sentry_install_groups', 1),
(3, '2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot', 1),
(4, '2012_12_06_225988_migration_cartalyst_sentry_install_throttle', 1),
(5, '2013_03_23_193214_update_users_table', 1),
(6, '2013_11_13_075318_create_models_table', 1),
(7, '2013_11_13_075335_create_categories_table', 1),
(8, '2013_11_13_075347_create_manufacturers_table', 1),
(9, '2013_11_15_015858_add_user_id_to_categories', 1),
(10, '2013_11_15_112701_add_user_id_to_manufacturers', 1),
(11, '2013_11_15_190327_create_assets_table', 1),
(12, '2013_11_15_190357_create_temp_licenses_table', 1),
(13, '2013_11_15_201848_add_license_name_to_licenses', 1),
(14, '2013_11_16_040323_create_depreciations_table', 1),
(15, '2013_11_16_042851_add_depreciation_id_to_models', 1),
(16, '2013_11_16_084923_add_user_id_to_models', 1),
(17, '2013_11_16_103258_create_locations_table', 1),
(18, '2013_11_16_103336_add_location_id_to_assets', 1),
(19, '2013_11_16_103407_add_checkedout_to_to_assets', 1),
(20, '2013_11_16_103425_create_history_table', 1),
(21, '2013_11_17_054359_drop_licenses_table', 1),
(22, '2013_11_17_054526_add_physical_to_assets', 1),
(23, '2013_11_17_055126_create_settings_table', 1),
(24, '2013_11_17_062634_add_license_to_assets', 1),
(25, '2013_11_18_134332_add_contacts_to_users', 1),
(26, '2013_11_18_142847_add_info_to_locations', 1),
(27, '2013_11_18_152942_remove_location_id_from_asset', 1),
(28, '2013_11_18_164423_set_nullvalues_for_user', 1),
(29, '2013_11_19_013337_create_asset_logs_table', 1),
(30, '2013_11_19_061409_edit_added_on_asset_logs_table', 1),
(31, '2013_11_19_062250_edit_location_id_asset_logs_table', 1),
(32, '2013_11_20_055822_add_soft_delete_on_assets', 1),
(33, '2013_11_20_121404_add_soft_delete_on_locations', 1),
(34, '2013_11_20_123137_add_soft_delete_on_manufacturers', 1),
(35, '2013_11_20_123725_add_soft_delete_on_categories', 1),
(36, '2013_11_20_130248_create_status_labels', 1),
(37, '2013_11_20_130830_add_status_id_on_assets_table', 1),
(38, '2013_11_20_131544_add_status_type_on_status_labels', 1),
(39, '2013_11_20_134103_add_archived_to_assets', 1),
(40, '2013_11_21_002321_add_uploads_table', 1),
(41, '2013_11_21_024531_remove_deployable_boolean_from_status_labels', 1),
(42, '2013_11_22_075308_add_option_label_to_settings_table', 1),
(43, '2013_11_22_213400_edits_to_settings_table', 1),
(44, '2013_11_25_013244_recreate_licenses_table', 1),
(45, '2013_11_25_031458_create_license_seats_table', 1),
(46, '2013_11_25_032022_add_type_to_actionlog_table', 1),
(47, '2013_11_25_033008_delete_bad_licenses_table', 1),
(48, '2013_11_25_033131_create_new_licenses_table', 1),
(49, '2013_11_25_033534_add_licensed_to_licenses_table', 1),
(50, '2013_11_25_101308_add_warrantee_to_assets_table', 1),
(51, '2013_11_25_104343_alter_warranty_column_on_assets', 1),
(52, '2013_11_25_150450_drop_parent_from_categories', 1),
(53, '2013_11_25_151920_add_depreciate_to_assets', 1),
(54, '2013_11_25_152903_add_depreciate_to_licenses_table', 1),
(55, '2013_11_26_211820_drop_license_from_assets_table', 1),
(56, '2013_11_27_062510_add_note_to_asset_logs_table', 1),
(57, '2013_12_01_113426_add_filename_to_asset_log', 1),
(58, '2013_12_06_094618_add_nullable_to_licenses_table', 1),
(59, '2013_12_10_084038_add_eol_on_models_table', 1),
(60, '2013_12_12_055218_add_manager_to_users_table', 1),
(61, '2014_01_28_031200_add_qr_code_to_settings_table', 1),
(62, '2014_02_13_183016_add_qr_text_to_settings_table', 1),
(63, '2014_05_24_093839_alter_default_license_depreciation_id', 1),
(64, '2014_05_27_231658_alter_default_values_licenses', 1),
(65, '2014_06_19_191508_add_asset_name_to_settings', 1),
(66, '2014_06_20_004847_make_asset_log_checkedout_to_nullable', 1),
(67, '2014_06_20_005050_make_asset_log_purchasedate_to_nullable', 1),
(68, '2014_06_24_003011_add_suppliers', 1),
(69, '2014_06_24_010742_add_supplier_id_to_asset', 1),
(70, '2014_06_24_012839_add_zip_to_supplier', 1),
(71, '2014_06_24_033908_add_url_to_supplier', 1),
(72, '2014_07_08_054116_add_employee_id_to_users', 1),
(73, '2014_07_09_134316_add_requestable_to_assets', 1),
(74, '2014_07_17_085822_add_asset_to_software', 1),
(75, '2014_07_17_161625_make_asset_id_in_logs_nullable', 1),
(76, '2014_08_12_053504_alpha_0_4_2_release', 1),
(77, '2014_08_17_083523_make_location_id_nullable', 1),
(78, '2014_10_16_200626_add_rtd_location_to_assets', 1),
(79, '2014_10_24_000417_alter_supplier_state_to_32', 1),
(80, '2014_10_24_015641_add_display_checkout_date', 1),
(81, '2014_10_28_222654_add_avatar_field_to_users_table', 1),
(82, '2014_10_29_045924_add_image_field_to_models_table', 1),
(83, '2014_11_01_214955_add_eol_display_to_settings', 1),
(84, '2014_11_04_231416_update_group_field_for_reporting', 1),
(85, '2014_11_05_212408_add_fields_to_licenses', 1),
(86, '2014_11_07_021042_add_image_to_supplier', 1),
(87, '2014_11_20_203007_add_username_to_user', 1),
(88, '2014_11_20_223947_add_auto_to_settings', 1),
(89, '2014_11_20_224421_add_prefix_to_settings', 1),
(90, '2014_11_21_104401_change_licence_type', 1),
(91, '2014_12_09_082500_add_fields_maintained_term_to_licenses', 1),
(92, '2015_02_04_155757_increase_user_field_lengths', 1),
(93, '2015_02_07_013537_add_soft_deleted_to_log', 1),
(94, '2015_02_10_040958_fix_bad_assigned_to_ids', 1),
(95, '2015_02_10_053310_migrate_data_to_new_statuses', 1),
(96, '2015_02_11_044104_migrate_make_license_assigned_null', 1),
(97, '2015_02_11_104406_migrate_create_requests_table', 1),
(98, '2015_02_12_001312_add_mac_address_to_asset', 1),
(99, '2015_02_12_024100_change_license_notes_type', 1),
(100, '2015_02_17_231020_add_localonly_to_settings', 1),
(101, '2015_02_19_222322_add_logo_and_colors_to_settings', 1),
(102, '2015_02_24_072043_add_alerts_to_settings', 1),
(103, '2015_02_25_022931_add_eula_fields', 1),
(104, '2015_02_25_204513_add_accessories_table', 1),
(105, '2015_02_26_091228_add_accessories_user_table', 1),
(106, '2015_02_26_115128_add_deleted_at_models', 1),
(107, '2015_02_26_233005_add_category_type', 1),
(108, '2015_03_01_231912_update_accepted_at_to_acceptance_id', 1),
(109, '2015_03_05_011929_add_qr_type_to_settings', 1),
(110, '2015_03_18_055327_add_note_to_user', 1),
(111, '2015_04_29_234704_add_slack_to_settings', 1),
(112, '2015_05_04_085151_add_parent_id_to_locations_table', 1),
(113, '2015_05_22_124421_add_reassignable_to_licenses', 1),
(114, '2015_06_10_003314_fix_default_for_user_notes', 1),
(115, '2015_06_10_003554_create_consumables', 1),
(116, '2015_06_15_183253_move_email_to_username', 1),
(117, '2015_06_23_070346_make_email_nullable', 1),
(118, '2015_06_26_213716_create_asset_maintenances_table', 1),
(119, '2015_07_04_212443_create_custom_fields_table', 1),
(120, '2015_07_09_014359_add_currency_to_settings_and_locations', 1),
(121, '2015_07_21_122022_add_expected_checkin_date_to_asset_logs', 1),
(122, '2015_07_24_093845_add_checkin_email_to_category_table', 1),
(123, '2015_07_25_055415_remove_email_unique_constraint', 1),
(124, '2015_07_29_230054_add_thread_id_to_asset_logs_table', 1),
(125, '2015_07_31_015430_add_accepted_to_assets', 1),
(126, '2015_09_09_195301_add_custom_css_to_settings', 1),
(127, '2015_09_21_235926_create_custom_field_custom_fieldset', 1),
(128, '2015_09_22_000104_create_custom_fieldsets', 1),
(129, '2015_09_22_003321_add_fieldset_id_to_assets', 1),
(130, '2015_09_22_003413_migrate_mac_address', 1),
(131, '2015_09_28_003314_fix_default_purchase_order', 1),
(132, '2015_10_01_024551_add_accessory_consumable_price_info', 1),
(133, '2015_10_12_192706_add_brand_to_settings', 1),
(134, '2015_10_22_003314_fix_defaults_accessories', 1),
(135, '2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets', 1),
(136, '2015_11_05_061015_create_companies_table', 1),
(137, '2015_11_05_061115_add_company_id_to_consumables_table', 1),
(138, '2015_11_05_183749_add_image_to_assets', 1),
(139, '2015_11_06_092038_add_company_id_to_accessories_table', 1),
(140, '2015_11_06_100045_add_company_id_to_users_table', 1),
(141, '2015_11_06_134742_add_company_id_to_licenses_table', 1),
(142, '2015_11_08_035832_add_company_id_to_assets_table', 1),
(143, '2015_11_08_222305_add_ldap_fields_to_settings', 1),
(144, '2015_11_15_151803_add_full_multiple_companies_support_to_settings_table', 1),
(145, '2015_11_26_195528_import_ldap_settings', 1),
(146, '2015_11_30_191504_remove_fk_company_id', 1),
(147, '2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table', 1),
(148, '2015_12_30_233509_add_timestamp_and_userId_to_custom_fields', 1),
(149, '2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets', 1),
(150, '2016_01_28_041048_add_notes_to_models', 1),
(151, '2016_02_19_070119_add_remember_token_to_users_table', 1),
(152, '2016_02_19_073625_create_password_resets_table', 1),
(153, '2016_03_02_193043_add_ldap_flag_to_users', 1),
(154, '2016_03_02_220517_update_ldap_filter_to_longer_field', 1),
(155, '2016_03_08_225351_create_components_table', 1),
(156, '2016_03_09_024038_add_min_stock_to_tables', 1),
(157, '2016_03_10_133849_add_locale_to_users', 1),
(158, '2016_03_10_135519_add_locale_to_settings', 1),
(159, '2016_03_11_185621_add_label_settings_to_settings', 1),
(160, '2016_03_22_125911_fix_custom_fields_regexes', 1),
(161, '2016_04_28_141554_add_show_to_users', 1),
(162, '2016_05_16_164733_add_model_mfg_to_consumable', 1),
(163, '2016_05_19_180351_add_alt_barcode_settings', 1),
(164, '2016_05_19_191146_add_alter_interval', 1),
(165, '2016_05_19_192226_add_inventory_threshold', 1),
(166, '2016_05_20_024859_remove_option_keys_from_settings_table', 1),
(167, '2016_05_20_143758_remove_option_value_from_settings_table', 1),
(168, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(169, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(170, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(171, '2016_06_01_000004_create_oauth_clients_table', 1),
(172, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(173, '2016_06_01_140218_add_email_domain_and_format_to_settings', 1),
(174, '2016_06_22_160725_add_user_id_to_maintenances', 1),
(175, '2016_07_13_150015_add_is_ad_to_settings', 1),
(176, '2016_07_14_153609_add_ad_domain_to_settings', 1),
(177, '2016_07_22_003348_fix_custom_fields_regex_stuff', 1),
(178, '2016_07_22_054850_one_more_mac_addr_fix', 1),
(179, '2016_07_22_143045_add_port_to_ldap_settings', 1),
(180, '2016_07_22_153432_add_tls_to_ldap_settings', 1),
(181, '2016_07_27_211034_add_zerofill_to_settings', 1),
(182, '2016_08_02_124944_add_color_to_statuslabel', 1),
(183, '2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings', 1),
(184, '2016_08_09_002225_add_manufacturer_to_licenses', 1),
(185, '2016_08_12_121613_add_manufacturer_to_accessories_table', 1),
(186, '2016_08_23_143353_add_new_fields_to_custom_fields', 1),
(187, '2016_08_23_145619_add_show_in_nav_to_status_labels', 1),
(188, '2016_08_30_084634_make_purchase_cost_nullable', 1),
(189, '2016_09_01_141051_add_requestable_to_asset_model', 1),
(190, '2016_09_02_001448_create_checkout_requests_table', 1),
(191, '2016_09_04_180400_create_actionlog_table', 1),
(192, '2016_09_04_182149_migrate_asset_log_to_action_log', 1),
(193, '2016_09_19_235935_fix_fieldtype_for_target_type', 1),
(194, '2016_09_23_140722_fix_modelno_in_consumables_to_string', 1),
(195, '2016_09_28_231359_add_company_to_logs', 1),
(196, '2016_10_14_130709_fix_order_number_to_varchar', 1),
(197, '2016_10_16_015024_rename_modelno_to_model_number', 1),
(198, '2016_10_16_015211_rename_consumable_modelno_to_model_number', 1),
(199, '2016_10_16_143235_rename_model_note_to_notes', 1),
(200, '2016_10_16_165052_rename_component_total_qty_to_qty', 1),
(201, '2016_10_19_145520_fix_order_number_in_components_to_string', 1),
(202, '2016_10_27_151715_add_serial_to_components', 1),
(203, '2016_10_27_213251_increase_serial_field_capacity', 1),
(204, '2016_10_29_002724_enable_2fa_fields', 1),
(205, '2016_10_29_082408_add_signature_to_acceptance', 1),
(206, '2016_11_01_030818_fix_forgotten_filename_in_action_logs', 1),
(207, '2016_11_13_020954_rename_component_serial_number_to_serial', 1),
(208, '2016_11_16_172119_increase_purchase_cost_size', 1),
(209, '2016_11_17_161317_longer_state_field_in_location', 1),
(210, '2016_11_17_193706_add_model_number_to_accessories', 1),
(211, '2016_11_24_160405_add_missing_target_type_to_logs_table', 1),
(212, '2016_12_07_173720_increase_size_of_state_in_suppliers', 1),
(213, '2016_12_19_004212_adjust_locale_length_to_10', 1),
(214, '2016_12_19_133936_extend_phone_lengths_in_supplier_and_elsewhere', 1),
(215, '2016_12_27_212631_make_asset_assigned_to_polymorphic', 1),
(216, '2017_01_09_040429_create_locations_ldap_query_field', 1),
(217, '2017_01_14_002418_create_imports_table', 1),
(218, '2017_01_25_063357_fix_utf8_custom_field_column_names', 1),
(219, '2017_03_03_154632_add_time_date_display_to_settings', 1),
(220, '2017_03_10_210807_add_fields_to_manufacturer', 1),
(221, '2017_05_08_195520_increase_size_of_field_values_in_custom_fields', 1),
(222, '2017_05_22_204422_create_departments', 1),
(223, '2017_05_22_233509_add_manager_to_locations_table', 1),
(224, '2017_06_14_122059_add_next_autoincrement_to_settings', 1),
(225, '2017_06_18_151753_add_header_and_first_row_to_importer_table', 1),
(226, '2017_07_07_191533_add_login_text', 1),
(227, '2017_07_25_130710_add_thumbsize_to_settings', 1),
(228, '2017_08_03_160105_set_asset_archived_to_zero_default', 1),
(229, '2017_08_22_180636_add_secure_password_options', 1),
(230, '2017_08_25_074822_add_auditing_tables', 1),
(231, '2017_08_25_101435_add_auditing_to_settings', 1),
(232, '2017_09_18_225619_fix_assigned_type_not_being_nulled', 1),
(233, '2017_10_03_015503_drop_foreign_keys', 1),
(234, '2017_10_10_123504_allow_nullable_depreciation_id_in_models', 1),
(235, '2017_10_17_133709_add_display_url_to_settings', 1),
(236, '2017_10_19_120002_add_custom_forgot_password_url', 1),
(237, '2017_10_19_130406_add_image_and_supplier_to_accessories', 1),
(238, '2017_10_20_234129_add_location_indices_to_assets', 1),
(239, '2017_10_25_202930_add_images_uploads_to_locations_manufacturers_etc', 1),
(240, '2017_10_27_180947_denorm_asset_locations', 1),
(241, '2017_10_27_192423_migrate_denormed_asset_locations', 1),
(242, '2017_10_30_182938_add_address_to_user', 1),
(243, '2017_11_08_025918_add_alert_menu_setting', 1),
(244, '2017_11_08_123942_labels_display_company_name', 1),
(245, '2017_12_12_010457_normalize_asset_last_audit_date', 1),
(246, '2017_12_12_033618_add_actionlog_meta', 1),
(247, '2017_12_26_170856_re_normalize_last_audit', 1),
(248, '2018_01_17_184354_add_archived_in_list_setting', 1),
(249, '2018_01_19_203121_add_dashboard_message_to_settings', 1),
(250, '2018_01_24_062633_add_footer_settings_to_settings', 1),
(251, '2018_01_24_093426_add_modellist_preferenc', 1),
(252, '2018_02_22_160436_add_remote_user_settings', 1),
(253, '2018_03_03_011032_add_theme_to_settings', 1),
(254, '2018_03_06_054937_add_default_flag_on_statuslabels', 1),
(255, '2018_03_23_212048_add_display_in_email_to_custom_fields', 1),
(256, '2018_03_24_030738_add_show_images_in_email_setting', 1),
(257, '2018_03_24_050108_add_cc_alerts', 1),
(258, '2018_03_29_053618_add_canceled_at_and_fulfilled_at_in_requests', 1),
(259, '2018_03_29_070121_add_drop_unique_requests', 1),
(260, '2018_03_29_070511_add_new_index_requestable', 1),
(261, '2018_04_02_150700_labels_display_model_name', 1),
(262, '2018_04_16_133902_create_custom_field_default_values_table', 1),
(263, '2018_05_04_073223_add_category_to_licenses', 1),
(264, '2018_05_04_075235_add_update_license_category', 1),
(265, '2018_05_08_031515_add_gdpr_privacy_footer', 1),
(266, '2018_05_14_215229_add_indexes', 1),
(267, '2018_05_14_223646_add_indexes_to_assets', 1),
(268, '2018_05_14_233638_denorm_counters_on_assets', 1),
(269, '2018_05_16_153409_add_first_counter_totals_to_assets', 1),
(270, '2018_06_21_134622_add_version_footer', 1),
(271, '2018_07_05_215440_add_unique_serial_option_to_settings', 1),
(272, '2018_07_17_005911_create_login_attempts_table', 1),
(273, '2018_07_24_154348_add_logo_to_print_assets', 1),
(274, '2018_07_28_023826_create_checkout_acceptances_table', 1),
(275, '2018_08_20_204842_add_depreciation_option_to_settings', 1),
(276, '2018_09_10_082212_create_checkout_acceptances_for_unaccepted_assets', 1),
(277, '2018_10_18_191228_add_kits_licenses_table', 1),
(278, '2018_10_19_153910_add_kits_table', 1),
(279, '2018_10_19_154013_add_kits_models_table', 1),
(280, '2018_12_05_211936_add_favicon_to_settings', 1),
(281, '2018_12_05_212119_add_email_logo_to_settings', 1),
(282, '2019_02_07_185953_add_kits_consumables_table', 1),
(283, '2019_02_07_190030_add_kits_accessories_table', 1),
(284, '2019_02_12_182750_add_actiondate_to_actionlog', 1),
(285, '2019_02_14_154310_change_auto_increment_prefix_to_nullable', 1),
(286, '2019_02_16_143518_auto_increment_back_to_string', 1),
(287, '2019_02_17_205048_add_label_logo_to_settings', 1),
(288, '2019_02_20_234421_make_serial_nullable', 1),
(289, '2019_02_21_224703_make_fields_nullable_for_integrity', 1),
(290, '2019_04_06_060145_add_user_skin_setting', 1),
(291, '2019_04_06_205355_add_setting_allow_user_skin', 1),
(292, '2019_06_12_184327_rename_groups_table', 1),
(293, '2019_07_23_140906_add_show_assigned_assets_to_settings', 1),
(294, '2019_08_20_084049_add_custom_remote_user_header', 1),
(295, '2019_12_04_223111_passport_upgrade', 1),
(296, '2020_02_04_172100_add_ad_append_domain_settings', 1),
(297, '2020_04_29_222305_add_saml_fields_to_settings', 1),
(298, '2020_08_11_200712_add_saml_key_rollover', 1),
(299, '2020_10_22_233743_move_accessory_checkout_note_to_join_table', 1),
(300, '2020_10_23_161736_fix_zero_values_for_locations', 1),
(301, '2020_11_18_214827_widen_license_serial_field', 1),
(302, '2020_12_14_233815_add_digit_separator_to_settings', 1),
(303, '2020_12_18_090026_swap_target_type_index_order', 1),
(304, '2020_12_21_153235_update_min_password', 1),
(305, '2020_12_21_210105_fix_bad_ldap_server_url_for_v5', 1),
(306, '2021_02_05_172502_add_provider_to_oauth_table', 1),
(307, '2021_03_18_184102_adds_several_ldap_fields', 1),
(308, '2021_04_07_001811_add_ldap_dept', 1),
(309, '2021_04_14_180125_add_ids_to_tables', 1),
(310, '2021_06_07_155421_add_serial_number_indexes', 1),
(311, '2021_06_07_155436_add_company_id_indexes', 1),
(312, '2021_07_28_031345_add_client_side_l_d_a_p_cert_to_settings', 1),
(313, '2021_07_28_040554_add_client_side_l_d_a_p_key_to_settings', 1),
(314, '2021_08_11_005206_add_depreciation_minimum_value', 1),
(315, '2021_08_24_124354_make_ldap_client_certs_nullable', 1),
(316, '2021_09_20_183216_change_default_label_to_nullable', 1),
(317, '2021_12_27_151849_change_supplier_address_length', 1),
(318, '2022_01_10_182548_add_license_id_index_to_license_seats', 1),
(319, '2022_02_03_214958_blank_out_ldap_active_flag', 1),
(320, '2022_02_10_110210_add_company_id_to_locations', 1),
(321, '2022_02_16_152431_add_unique_constraint_to_custom_field', 1),
(322, '2022_03_03_225655_add_notes_to_accessories', 1),
(323, '2022_03_03_225754_add_notes_to_components', 1),
(324, '2022_03_03_225824_add_notes_to_consumables', 1),
(325, '2022_03_04_080836_add_remote_to_user', 1),
(326, '2022_03_09_001334_add_eula_to_checkout_acceptance', 1),
(327, '2022_03_10_175740_add_eula_to_action_logs', 1),
(328, '2022_03_21_162724_adds_ldap_manager', 1),
(329, '2022_04_05_135340_add_primary_key_to_custom_fields_pivot', 1),
(330, '2022_05_16_235350_remove_stored_eula_field', 1),
(331, '2022_06_23_164407_add_user_id_to_users', 1),
(332, '2022_06_28_234539_add_username_index_to_users', 1),
(333, '2022_07_07_010406_add_indexes_to_license_seats', 1),
(334, '2022_08_10_141328_add_notes_denorm_to_consumables_users', 1),
(335, '2022_08_25_213308_adds_ldap_default_group_to_settings_table', 1),
(336, '2022_09_29_040231_add_chart_type_to_settings', 1),
(337, '2022_10_05_163044_add_start_termination_date_to_users', 1),
(338, '2022_10_25_193823_add_externalid_to_users', 1),
(339, '2022_10_25_215520_add_label2_settings', 1),
(340, '2022_11_07_134348_add_display_to_user_in_custom_fields', 1),
(341, '2022_11_15_232525_adds_should_autoassign_bool_to_users_table', 1),
(342, '2022_12_20_171851_fix_nullable_migration_for_settings', 1),
(343, '2023_01_18_122534_add_byod_to_assets', 1),
(344, '2023_01_21_225350_add_eol_date_on_assets_table', 1),
(345, '2023_01_23_232933_add_vip_to_users', 1),
(346, '2023_02_12_224353_fix_unescaped_customfields_format', 1),
(347, '2023_02_27_092130_add_scope_locations_setting', 1),
(348, '2023_02_28_173527_adds_webhook_option_to_settings_table', 1),
(349, '2023_03_21_215218_update_slack_setting', 1),
(350, '2023_04_12_135822_add_supplier_to_components', 1),
(351, '2023_04_25_085912_add_autoadd_to_customfields', 1),
(352, '2023_04_25_181817_adds_ldap_location_to_settings_table', 1),
(353, '2023_04_26_160235_add_warranty_url_to_manufacturers', 1),
(354, '2023_05_08_132921_increase_state_to_more_than_3', 1),
(355, '2023_05_10_001836_add_google_auth_to_settings', 1),
(356, '2023_07_05_092237_change_settings_table_increase_saml_idp_metadata_size', 1),
(357, '2023_07_06_092507_add_phone_fax_to_locations', 1),
(358, '2023_07_13_052204_denormalized_eol_and_add_column_for_explicit_date_to_assets', 1),
(359, '2023_07_14_004221_add_show_in_list_view_to_custom_fields', 1),
(360, '2023_08_01_174150_change_webhook_settings_variable_type', 1),
(361, '2023_08_13_172600_add_email_to_companies', 1),
(362, '2023_08_17_202638_add_last_checkin_to_assets', 1),
(363, '2023_08_21_064609_add_name_ordering_to_settings', 1),
(364, '2023_08_21_181742_add_min_amt_to_models_table', 1),
(365, '2023_08_23_232739_create_report_templates_table', 1),
(366, '2023_09_13_200913_fix_asset_model_min_qty_nullability', 1),
(367, '2023_10_25_064324_add_show_in_requestable_to_custom_fields', 1),
(368, '2023_12_14_032522_add_remote_ip_and_action_source_to_action_logs', 1),
(369, '2023_12_15_024643_add_indexes_to_new_activity_report_fields', 1),
(370, '2023_12_19_081112_fix_language_dirs', 1),
(371, '2024_01_24_145544_create_saml_nonce_table', 1),
(372, '2024_02_28_080016_add_created_by_to_permission_groups', 1),
(373, '2024_02_28_093807_add_min_qty_to_licenses', 1),
(374, '2024_03_18_164714_add_note_to_checkout_acceptance_table', 1),
(375, '2024_03_18_221612_update_legacy_locale', 1),
(376, '2024_05_27_143554_add_parent_id_index_to_locations', 1),
(377, '2024_06_24_130348_add_profile_edit_to_settings', 1),
(378, '2024_07_04_103729_add_default_avatar_to_settings', 1),
(379, '2024_07_16_184145_add_deprecitation_type_to_depreciations_table', 1),
(380, '2024_07_23_172032_change_no__n_o_to_nb__n_o', 1),
(381, '2024_07_26_143301_add_checkout_for_all_types_to_accessories', 1),
(382, '2024_08_01_201721_add_required_notes_setting', 1),
(383, '2024_08_06_175114_add_shortcuts_enabled_to_settings_table', 1),
(384, '2024_08_07_204014_add_play_sounds_to_profile', 1),
(385, '2024_08_15_111816_add_confetti_to_users', 1),
(386, '2024_08_16_104137_add_due_checkin_days_to_settings', 1),
(387, '2024_09_17_204302_change_user_id_to_created_by', 1),
(388, '2024_10_23_162301_add_manufacturer_id_model_number_to_consumables', 1),
(389, '2024_10_31_212512_update_new_and_drop_old_barcode_settings', 1),
(390, '2024_11_06_211457_add_manager_indexes_to_location_and_user', 1),
(391, '2024_11_07_113631_improve_manager_indexes_on_users_and_locations', 1),
(392, '2025_01_06_210534_change_report_templates_options_to_column_text_field', 1),
(393, '2025_01_07_172419_fix_label_types_on_settings_table', 1),
(394, '2025_02_10_230155_add_notes_to_locations_companies_categories_manufacturers_groups', 1),
(395, '2025_02_22_144518_add_checkin_checkout_to_customfields', 1),
(396, '2025_02_26_153413_add_ldap_invert_active_flag_to_setting_table', 1),
(397, '2025_03_04_231256_purge_action_logs_of_report_template_activity', 1),
(398, '2025_03_06_152922_copy_created_at_to_action_date_in_action_logs', 1),
(399, '2025_03_12_184851_purge_action_logs_table_of_consumable_checkin_entries', 1),
(400, '2025_04_02_113438_add_acceptance_pdf_logo_to_settings', 1),
(401, '2025_04_07_145418_add_custom_fields_to_audit', 1),
(402, '2025_04_22_170731_add_empty_row_count_to_settings_table', 1),
(403, '2025_05_20_190317_repopulate_webhook_selected_setting', 1),
(404, '2025_06_02_233556_add_admin_cc_always_to_settings_table', 1),
(405, '2025_06_03_000000_add_manager_view_enabled_to_settings_table', 1),
(406, '2025_06_03_053438_fix_assigned_type_without_assigned_to', 1),
(407, '2025_06_04_101736_add_deleted_at_index_to_action_logs', 1),
(408, '2025_06_05_200518_add_alert_on_response_id_to_checkout_acceptances_table', 1),
(409, '2025_06_05_204139_add_alert_on_response_to_categories_table', 1),
(410, '2025_06_06_155058_make_supplier_id_nullable', 1),
(411, '2025_07_16_142036_clean_checkout_acceptances', 1),
(412, '2025_08_06_192954_add_image_to_maintenances', 1),
(413, '2025_08_10_111553_rename_title_to_name_on_asset_maintenances', 1),
(414, '2025_08_10_113444_rename_asset_maintenances_to_maintenances', 1),
(415, '2025_08_10_114135_change_asset_maintenance_in_logs_to_maintenance', 1),
(416, '2025_08_11_181519_add_mobile_number_to_users_table', 1),
(417, '2025_08_19_114742_add_display_name_to_users', 1),
(418, '2025_08_19_122533_add_category_indexes', 1),
(419, '2025_08_19_174823_add_display_name_to_ldap_settings', 1),
(420, '2025_08_20_190617_add_created_at_index_to_models', 1);

-- --------------------------------------------------------

--
-- Table structure for table `models`
--

CREATE TABLE `models` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `model_number` varchar(191) DEFAULT NULL,
  `min_amt` int(11) DEFAULT NULL,
  `manufacturer_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `depreciation_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `eol` int(11) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `deprecated_mac_address` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `fieldset_id` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `requestable` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `models`
--

INSERT INTO `models` (`id`, `name`, `model_number`, `min_amt`, `manufacturer_id`, `category_id`, `created_at`, `updated_at`, `depreciation_id`, `created_by`, `eol`, `image`, `deprecated_mac_address`, `deleted_at`, `fieldset_id`, `notes`, `requestable`) VALUES
(1, 'Macbook Pro 13\"', '348533052513901', NULL, NULL, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'mbp.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(2, 'Macbook Air', '2632277688216221', NULL, 1, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'macbookair.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(3, 'Surface', '5482691414279762', NULL, 2, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'surface.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(4, 'XPS 13', '378661110349092', NULL, 3, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'xps.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(5, 'Spectre', '2342682937444683', NULL, 4, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'spectre.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(6, 'ZenBook UX310', '5512518523974146', NULL, 5, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'zenbook.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(7, 'Yoga 910', '2673590784747323', NULL, 6, 2, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 36, 'yoga.png', 0, NULL, 2, 'Created by demo seeder', 0),
(8, 'iMac Pro', '5326489070151890', NULL, 1, 3, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 24, 'imacpro.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(9, 'Lenovo Intel Core i5', '5585159071416933', NULL, 6, 3, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 24, 'lenovoi5.png', 0, NULL, 2, 'Created by demo seeder', 0),
(10, 'OptiPlex', '5040 (MRR81)', NULL, 3, 3, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 24, 'optiplex.jpg', 0, NULL, 2, 'Created by demo seeder', 0),
(11, 'SoundStation 2', '3528730635185993', NULL, 7, 4, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 12, 'soundstation.jpg', 0, NULL, NULL, 'Created by demo seeder', 0),
(12, 'Polycom CX3000 IP Conference Phone', '3589134593031743', NULL, 7, 4, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 12, 'cx3000.png', 0, NULL, NULL, 'Created by demo seeder', 0),
(13, 'iPad Pro', '6011380867586042', NULL, 1, 5, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 12, 'ipad.jpg', 0, NULL, NULL, 'Created by demo seeder', 0),
(14, 'Tab3', '5467414235453816', NULL, 6, 5, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 12, 'tab3.png', 0, NULL, NULL, 'Created by demo seeder', 0),
(15, 'iPhone 11', '5424531130647432', NULL, 1, 6, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 2, 1, 12, 'iphone11.jpeg', 0, NULL, 3, 'Created by demo seeder', 0),
(16, 'iPhone 12', '4929481136900786', NULL, 1, 6, '2025-09-01 12:11:38', '2025-09-01 12:11:38', 1, 1, 12, 'iphone12.jpeg', 0, NULL, 3, 'Created by demo seeder', 0),
(17, 'Ultrafine 4k', '3528982642110932', NULL, 8, 7, '2025-09-01 12:11:39', '2025-09-01 12:11:39', 3, 1, 12, 'ultrafine.jpg', 0, NULL, NULL, 'Created by demo seeder', 0),
(18, 'Ultrasharp U2415', '4532487889333108', NULL, 3, 7, '2025-09-01 12:11:39', '2025-09-01 12:11:39', 3, 1, 12, 'ultrasharp.jpg', 0, NULL, NULL, 'Created by demo seeder', 0),
(19, 'Mac M3', 'sm1211', NULL, 1, 2, '2025-09-09 08:55:02', '2025-09-09 08:55:02', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `models_custom_fields`
--

CREATE TABLE `models_custom_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `asset_model_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `default_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `permission_groups`
--

CREATE TABLE `permission_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `permissions` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `report_templates`
--

CREATE TABLE `report_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `options` text NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `requested_assets`
--

CREATE TABLE `requested_assets` (
  `id` int(10) UNSIGNED NOT NULL,
  `asset_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `accepted_at` datetime DEFAULT NULL,
  `denied_at` datetime DEFAULT NULL,
  `notes` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `requests`
--

CREATE TABLE `requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `asset_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `request_code` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `saml_nonces`
--

CREATE TABLE `saml_nonces` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nonce` varchar(191) NOT NULL,
  `not_valid_after` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `status_labels`
--

CREATE TABLE `status_labels` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deployable` tinyint(1) NOT NULL DEFAULT 0,
  `pending` tinyint(1) NOT NULL DEFAULT 0,
  `archived` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  `show_in_nav` tinyint(1) DEFAULT 0,
  `default_label` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_labels`
--

INSERT INTO `status_labels` (`id`, `name`, `created_by`, `created_at`, `updated_at`, `deleted_at`, `deployable`, `pending`, `archived`, `notes`, `color`, `show_in_nav`, `default_label`) VALUES
(1, 'Pending', 1, NULL, NULL, NULL, 0, 1, 0, 'These assets are not yet ready to be deployed, usually because of configuration or waiting on parts.', NULL, 0, 0),
(2, 'Ready to Deploy', 1, NULL, NULL, NULL, 1, 0, 0, 'These assets are ready to deploy.', NULL, 0, 0),
(3, 'Archived', 1, NULL, NULL, NULL, 0, 0, 1, 'These assets are no longer in circulation or viable.', NULL, 0, 0),
(4, 'Active', NULL, '2025-09-02 04:49:26', '2025-09-02 04:49:26', NULL, 0, 0, 0, NULL, NULL, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `address` varchar(250) DEFAULT NULL,
  `address2` varchar(250) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(2) DEFAULT NULL,
  `phone` varchar(35) DEFAULT NULL,
  `fax` varchar(35) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `contact` varchar(100) DEFAULT NULL,
  `notes` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `throttle`
--

CREATE TABLE `throttle` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(191) DEFAULT NULL,
  `attempts` int(11) NOT NULL DEFAULT 0,
  `suspended` tinyint(1) NOT NULL DEFAULT 0,
  `banned` tinyint(1) NOT NULL DEFAULT 0,
  `last_attempt_at` timestamp NULL DEFAULT NULL,
  `suspended_at` timestamp NULL DEFAULT NULL,
  `banned_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users_groups`
--

CREATE TABLE `users_groups` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `group_id` int(10) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accessories`
--
ALTER TABLE `accessories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accessories_company_id_index` (`company_id`),
  ADD KEY `accessories_deleted_at_category_id_index` (`deleted_at`,`category_id`);

--
-- Indexes for table `accessories_checkout`
--
ALTER TABLE `accessories_checkout`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `action_logs`
--
ALTER TABLE `action_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `action_logs_thread_id_index` (`thread_id`),
  ADD KEY `action_logs_created_at_index` (`created_at`),
  ADD KEY `action_logs_item_type_item_id_action_type_index` (`item_type`,`item_id`,`action_type`),
  ADD KEY `action_logs_target_type_target_id_action_type_index` (`target_type`,`target_id`,`action_type`),
  ADD KEY `action_logs_target_type_target_id_index` (`target_type`,`target_id`),
  ADD KEY `action_logs_company_id_index` (`company_id`),
  ADD KEY `action_logs_action_type_index` (`action_type`),
  ADD KEY `action_logs_remote_ip_index` (`remote_ip`),
  ADD KEY `action_logs_action_date_index` (`action_date`),
  ADD KEY `action_logs_deleted_at_index` (`deleted_at`);

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assets_rtd_location_id_index` (`rtd_location_id`),
  ADD KEY `assets_assigned_type_assigned_to_index` (`assigned_type`,`assigned_to`),
  ADD KEY `assets_created_at_index` (`created_at`),
  ADD KEY `assets_deleted_at_status_id_index` (`deleted_at`,`status_id`),
  ADD KEY `assets_deleted_at_model_id_index` (`deleted_at`,`model_id`),
  ADD KEY `assets_deleted_at_assigned_type_assigned_to_index` (`deleted_at`,`assigned_type`,`assigned_to`),
  ADD KEY `assets_deleted_at_supplier_id_index` (`deleted_at`,`supplier_id`),
  ADD KEY `assets_deleted_at_location_id_index` (`deleted_at`,`location_id`),
  ADD KEY `assets_deleted_at_rtd_location_id_index` (`deleted_at`,`rtd_location_id`),
  ADD KEY `assets_deleted_at_asset_tag_index` (`deleted_at`,`asset_tag`),
  ADD KEY `assets_deleted_at_name_index` (`deleted_at`,`name`),
  ADD KEY `assets_serial_index` (`serial`),
  ADD KEY `assets_company_id_index` (`company_id`);

--
-- Indexes for table `asset_logs`
--
ALTER TABLE `asset_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `asset_uploads`
--
ALTER TABLE `asset_uploads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_deleted_at_index` (`deleted_at`);

--
-- Indexes for table `checkout_acceptances`
--
ALTER TABLE `checkout_acceptances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `checkout_acceptances_checkoutable_type_checkoutable_id_index` (`checkoutable_type`,`checkoutable_id`);

--
-- Indexes for table `checkout_requests`
--
ALTER TABLE `checkout_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `checkout_requests_user_id_requestable_id_requestable_type` (`user_id`,`requestable_id`,`requestable_type`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `companies_name_unique` (`name`);

--
-- Indexes for table `components`
--
ALTER TABLE `components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `components_company_id_index` (`company_id`),
  ADD KEY `components_deleted_at_category_id_index` (`deleted_at`,`category_id`);

--
-- Indexes for table `components_assets`
--
ALTER TABLE `components_assets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `consumables`
--
ALTER TABLE `consumables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consumables_company_id_index` (`company_id`),
  ADD KEY `consumables_deleted_at_category_id_index` (`deleted_at`,`category_id`);

--
-- Indexes for table `consumables_users`
--
ALTER TABLE `consumables_users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_fields`
--
ALTER TABLE `custom_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_fieldsets`
--
ALTER TABLE `custom_fieldsets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_field_custom_fieldset`
--
ALTER TABLE `custom_field_custom_fieldset`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departments_company_id_index` (`company_id`);

--
-- Indexes for table `depreciations`
--
ALTER TABLE `depreciations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `imports`
--
ALTER TABLE `imports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kits`
--
ALTER TABLE `kits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kits_accessories`
--
ALTER TABLE `kits_accessories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kits_consumables`
--
ALTER TABLE `kits_consumables`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kits_licenses`
--
ALTER TABLE `kits_licenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kits_models`
--
ALTER TABLE `kits_models`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `licenses`
--
ALTER TABLE `licenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `licenses_company_id_index` (`company_id`),
  ADD KEY `licenses_deleted_at_category_id_index` (`deleted_at`,`category_id`);

--
-- Indexes for table `license_seats`
--
ALTER TABLE `license_seats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `license_seats_license_id_index` (`license_id`),
  ADD KEY `license_seats_assigned_to_license_id_index` (`assigned_to`,`license_id`),
  ADD KEY `license_seats_asset_id_license_id_index` (`asset_id`,`license_id`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `locations_company_id_index` (`company_id`),
  ADD KEY `locations_parent_id_index` (`parent_id`),
  ADD KEY `locations_manager_id_deleted_at_index` (`manager_id`,`deleted_at`);

--
-- Indexes for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `maintenances`
--
ALTER TABLE `maintenances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `manufacturers`
--
ALTER TABLE `manufacturers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `models`
--
ALTER TABLE `models`
  ADD PRIMARY KEY (`id`),
  ADD KEY `models_deleted_at_category_id_index` (`deleted_at`,`category_id`),
  ADD KEY `models_created_at_index` (`created_at`);

--
-- Indexes for table `models_custom_fields`
--
ALTER TABLE `models_custom_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permission_groups`
--
ALTER TABLE `permission_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `report_templates`
--
ALTER TABLE `report_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `report_templates_created_by_index` (`created_by`);

--
-- Indexes for table `requested_assets`
--
ALTER TABLE `requested_assets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `requests`
--
ALTER TABLE `requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `saml_nonces`
--
ALTER TABLE `saml_nonces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `saml_nonces_nonce_index` (`nonce`),
  ADD KEY `saml_nonces_not_valid_after_index` (`not_valid_after`);

--
-- Indexes for table `status_labels`
--
ALTER TABLE `status_labels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `throttle`
--
ALTER TABLE `throttle`
  ADD PRIMARY KEY (`id`),
  ADD KEY `throttle_user_id_index` (`user_id`);

--
-- Indexes for table `users_groups`
--
ALTER TABLE `users_groups`
  ADD PRIMARY KEY (`user_id`,`group_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accessories`
--
ALTER TABLE `accessories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `accessories_checkout`
--
ALTER TABLE `accessories_checkout`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `action_logs`
--
ALTER TABLE `action_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `asset_logs`
--
ALTER TABLE `asset_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_uploads`
--
ALTER TABLE `asset_uploads`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `checkout_acceptances`
--
ALTER TABLE `checkout_acceptances`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `checkout_requests`
--
ALTER TABLE `checkout_requests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `components`
--
ALTER TABLE `components`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `components_assets`
--
ALTER TABLE `components_assets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `consumables`
--
ALTER TABLE `consumables`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `consumables_users`
--
ALTER TABLE `consumables_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_fields`
--
ALTER TABLE `custom_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `custom_fieldsets`
--
ALTER TABLE `custom_fieldsets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `custom_field_custom_fieldset`
--
ALTER TABLE `custom_field_custom_fieldset`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `depreciations`
--
ALTER TABLE `depreciations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `imports`
--
ALTER TABLE `imports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kits`
--
ALTER TABLE `kits`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kits_accessories`
--
ALTER TABLE `kits_accessories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kits_consumables`
--
ALTER TABLE `kits_consumables`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kits_licenses`
--
ALTER TABLE `kits_licenses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kits_models`
--
ALTER TABLE `kits_models`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `licenses`
--
ALTER TABLE `licenses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `license_seats`
--
ALTER TABLE `license_seats`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `maintenances`
--
ALTER TABLE `maintenances`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `manufacturers`
--
ALTER TABLE `manufacturers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=421;

--
-- AUTO_INCREMENT for table `models`
--
ALTER TABLE `models`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `models_custom_fields`
--
ALTER TABLE `models_custom_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permission_groups`
--
ALTER TABLE `permission_groups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_templates`
--
ALTER TABLE `report_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requested_assets`
--
ALTER TABLE `requested_assets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requests`
--
ALTER TABLE `requests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `saml_nonces`
--
ALTER TABLE `saml_nonces`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `status_labels`
--
ALTER TABLE `status_labels`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `throttle`
--
ALTER TABLE `throttle`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

