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

START TRANSACTION;



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

--
-- Table structure for table `image_managers`
--

CREATE TABLE `image_managers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_path` text NOT NULL,
  `thumb_image` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `purpose` varchar(255) NOT NULL,
  `tags` longtext NOT 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 `image_managers`
--

INSERT INTO `image_managers` (`id`, `file_path`, `thumb_image`, `name`, `title`, `uploaded_by`, `description`, `purpose`, `tags`, `created_at`, `updated_at`) VALUES
(1, 'uploads/airport_details (1) (1) (2) (1)_TkQAY.csv|uploads/airport_details (1) (1) (2) (1)_k7S9Z.csv', 'thumbnails/PIPhJ7IgPJnkP0NNV3UrsHZtiVfjsJwTtoKUJWh2.png', 'assdff', 'assdff', 2, 'sd ffdzg  fg dfg', 'sd fds', '[\"hgg\"]', '2024-03-01 04:32:38', '2025-03-13 06:52:17'),
(2, 'uploads/1797609in.stp', NULL, 'd fdsfg dg', 'd fdsfg dg', 1, 'dffs gdf s', 'df gdh', '[{\"value\":\"image\"},{\"value\":\"laravel\"}]', '2025-03-01 04:34:44', '2025-03-01 04:34:44'),
(3, 'uploads/uploads/uploads/2827056 (2).stp', 'thumbnails/ugslXUkHVDJlDBvTT05VdtXaGEJfGSjvWaJDlmht.jpg', 'Data Entry Manager Job Description Template', 'Data Entry Manager Job Description Template', 2, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.nbn', 'Purpose Purpose Purpose Purpose Purpose Purpose Purpose', '[\"Purpose\",\"lessimpt\",\"moreimpt\",\"mostimpt\"]', '2025-03-01 05:42:47', '2025-03-05 06:50:15'),
(5, 'uploads/uploads/airport_details (1) (1) (1) (1).csv', 'thumbnails/vBwiNpJ6cHwd7zv5f5OFLiowgBnemQ55Ycl429ZX.jpg', 'cbvg', 'cbvg', 2, 'vbvc', 'nbn', '[\"laravel\"]', '2025-03-03 00:13:24', '2025-03-05 06:49:57'),
(12, 'uploads/eMG-100-G60 (3) (1).stp', NULL, 'new data', 'new data', 2, 'vgfcg fchhcvm, nbvfdsa,m', 'xcvnm', '[{\"value\":\"lessimpt\"}]', '2025-03-04 02:45:44', '2025-03-04 02:45:44'),
(13, 'uploads/eMG-100-G60 (5).stp', NULL, 'xcv cb v', 'xcv cb v', 2, 'xf', 'fdc vgf nbvcx vnmhjbv cxc vcv bgfdgcxvxcxzvf fvghguhdjshuh jhsjhdukhdsjcd sdxhsgdhsgdhsgd hgjuszgdugsgcdhygf hgcdsudsudhsgdsdg gcusdus', '[{\"value\":\"moreimpt\"}]', '2025-03-04 02:49:17', '2025-03-04 02:49:17'),
(14, 'uploads/eMG-100-G60 (5).stp', NULL, 'data', 'data', 2, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.nbn', 'xz', '[{\"value\":\"cvc\"}]', '2025-03-04 02:53:55', '2025-03-04 02:53:55'),
(16, 'uploads/uploads/uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/K1Qtn2twdJKdo6I4GHyQqX13zhmvNi3bq0G3umqv.png', 'xszx', 'xszx', 2, 'xzzx', 'zxz', '[\"xz\"]', '2025-03-05 01:14:41', '2025-03-05 02:21:07'),
(17, 'uploads/uploads/uploads/eMG-100-G60 (3) (1) (1).stp', 'thumbnails/Bb8ruLcfAOTbkRY2ikeRsZLflKaNiqolQAIoj3xV.png', 'vfd', 'vfd', 2, 'cxscxz', 'xcxd', '[\"fd\"]', '2025-03-05 01:39:12', '2025-03-11 01:08:10'),
(18, 'uploads/uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/RzhP5ccAIAEERc2EMcNTKjD04vXe0LHMiWXzDwYg.png', 'cvvc', 'cvvc', 2, 'ccvv', 'cvc', '[\"lessimpt\"]', '2025-03-05 06:34:10', '2025-03-05 06:49:31'),
(19, 'uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/nNTUno5CsoAW9i2JjSuK72ZaBDRZ2I1c8EVtRpxo.png', 'xcxc', 'xcxc', 2, 'cxcx', 'c', '[{\"value\":\"x\"}]', '2025-03-05 07:08:12', '2025-03-05 07:08:12'),
(20, 'uploads/airport_details (1) (1) (2).csv', 'thumbnails/AfUzajyCJwyRyTxGkHtxFDj1AYGZjkxn3lEP2Ufn.png', 'vbb', 'vbb', 2, 'vbvb', 'vvb', '[{\"value\":\"laravel\"}]', '2025-03-05 07:09:55', '2025-03-05 07:09:55'),
(21, 'aaaaaa/17bbff1f-4511-42b2-a00c-a03d1c67eb9f.png,aaaaaa/2857a2cc-d7fc-4bc3-b707-8d12925323b9.png,aaaaaa/e0b992f6-15c8-4193-bc33-7920066748c6.png,aaaaaa/661d39f8-2029-492e-aaf3-ef52c087108c.png,aaaaaa/3186bb17-e4b4-4b5a-b494-b3fbddf9607c.png,aaaaaa/14839835-9637-4d98-a04b-e9e97b616c10.png', 'thumbnails/SnbkhqN7tBa7NXTodLpt72DSIbVqejCWByx5bt5t.png', 'asdfasd', 'asdfasd', 2, 'asdsad', 'asdsad', '[{\"value\":\"lessimpt\"},{\"value\":\"image\"},{\"value\":\"moreimpt\"}]', '2025-03-05 08:23:18', '2025-03-05 08:23:18'),
(22, '', 'thumbnails/cMNXc9GRnTjnnF120xWHglZM8TgruD4Kwv5dzric.png', 'cxvc', 'cxvc', 2, 'cbvcnbv', 'bv', '[{\"value\":\"mostimpt\"}]', '2025-03-05 08:27:06', '2025-03-05 08:27:06'),
(23, 'aaaaaa/f4348270-ee55-4238-bc31-dcb859bc65a8.octet-stream,aaaaaa/12ac2df7-0814-4f8c-a541-d4c46551795f.png,aaaaaa/272cf7d0-6e9f-4f6e-ac70-5deb13056cc2.octet-stream,aaaaaa/cfa8b22c-0627-4fc6-a31c-7bdb8fdfa75a.octet-stream', 'thumbnails/HjLlVMDDCKX0aCkxqP5kB6DGFiHG4lHrhVKOcP1E.png', 'cvbv', 'cvbv', 2, 'bvb v', 'vbv', '[{\"value\":\"laravel\"}]', '2025-03-06 23:11:13', '2025-03-06 23:11:13'),
(24, 'uploads/eMG-100-G60 (3) (1) (1).stp', NULL, 'vccv', 'vccv', 1, 'xxvc', 'vcxv', '[{\"value\":\"vc\"}]', '2025-03-07 00:33:27', '2025-03-07 00:33:27'),
(25, 'uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/8aWAjOQZjfxcTTot0GYthPgpPue4xxUqJPGihj6l.png', 'fdg', 'fdg', 1, 'dgf', 'dcgd', '[{\"value\":\"laravel\"}]', '2025-03-07 00:41:54', '2025-03-07 00:41:54'),
(32, 'uploads/airport_details (1) (1) (2).csv|uploads/airport_details (1) (1) (1).csv', 'thumbnails/lsxi7LZRlV6WZ7xrdQxUGO8BMGeXmb3ZFzJrnhtb.png', 'cb', 'cb', 1, 'c vcv', 'vcv', '[{\"value\":\"image\"}]', '2025-03-07 01:45:45', '2025-03-07 01:45:45'),
(33, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/g1Fm2xvnYlo8xAr8V3QjxKy3rSMdY7qoBZpRopl3.png', 'gbnh', 'gbnh', 1, 'nb nb', 'ngn', '[{\"value\":\"hgg\"}]', '2025-03-07 02:35:30', '2025-03-07 02:35:30'),
(34, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/YqodddTjuMZ3vPnqzb3S8zrqxyrCmuoCnpAbxXtw.png', 'gbnh', 'gbnh', 1, 'nb nb', 'ngn', '[{\"value\":\"hgg\"}]', '2025-03-07 02:35:32', '2025-03-07 02:35:32'),
(35, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/NfQGxNHewEouuYrj4Ey7N5Y3IhbEI5UIU1c7z2q3.png', 'gbnh', 'gbnh', 1, 'nb nb', 'ngn', '[{\"value\":\"hgg\"}]', '2025-03-07 02:35:33', '2025-03-07 02:35:33'),
(36, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/VpwXt2NLPC38AwuRT9f8wMTtuKYy5D8x8PGPHP04.png', 'gbnh', 'gbnh', 1, 'nb nb', 'ngn', '[{\"value\":\"hgg\"}]', '2025-03-07 02:35:33', '2025-03-07 02:35:33'),
(37, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/XZMDPA252lfRlImJAMmIcJfu5yVOOAVQZRtYaaQc.png', 'gbnh', 'gbnh', 1, 'nb nb', 'ngn', '[{\"value\":\"hgg\"}]', '2025-03-07 02:35:33', '2025-03-07 02:35:33'),
(38, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/08o3t1AFSeDhcw1JdpcHVyyEt6iSlkcBjVGtcenD.png', 'gbnh', 'gbnh', 1, 'nb nb', 'ngn', '[{\"value\":\"hgg\"}]', '2025-03-07 02:37:15', '2025-03-07 02:37:15'),
(39, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/E4sGH7cZs11x03cD0TFXCFimbXulu8reQJzj1Eyj.png', 'gc bg', 'gc bg', 1, 'g cbg', 'cb', '[{\"value\":\"php\"}]', '2025-03-07 02:37:35', '2025-03-07 02:37:35'),
(40, 'uploads/eMG-100-G60 (5) (1) - Copy.stp|uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/IBRoeMrzAiwvG3awWIHZGKW9qtdm8qLXBdc3YG0T.png', 'gc bg', 'gc bg', 1, 'g cbg', 'cb', '[{\"value\":\"php\"}]', '2025-03-07 02:37:37', '2025-03-07 02:37:37'),
(41, 'uploads/eMG-100-G60 (5) (1).stp', 'thumbnails/qZj9nXcfsF4Nigau1gAvbERzvXc0ZDjwn1qaDnLO.png', 'cvc', 'cvc', 1, 'cvc', 'cv', '[{\"value\":\"image\"}]', '2025-03-07 02:39:01', '2025-03-07 02:39:01'),
(43, 'uploads/eMG-100-G60 (5) (1) (1).stp', 'thumbnails/wKqhfmwiKWBTOdL4sxUs3IQ0PWYcf2YpjZysXywo.png', 'juj', 'juj', 1, 'jjj', 'uu', '[{\"value\":\"uu\"}]', '2025-03-13 02:07:19', '2025-03-13 02:07:19'),
(44, 'uploads/login_ss.png', 'userThumbnails/pKasytvzW2oQjnuYIpUobj9EqcduWSQb4HOsZZKY.png', 'dxcfvgb', 'dxcfvgb', 2, 'xc gffgh', 'fgg', '[{\"value\":\"lessimpt\"}]', '2025-03-13 05:30:04', '2025-03-13 05:30:04'),
(45, 'uploads/login_ss.png|uploads/Screenshot 2025-02-12 132249.png|uploads/Screenshot 2025-02-12 132544.png|uploads/Screenshot 2025-02-12 133058.png|uploads/Screenshot 2025-02-12 153146.png|uploads/Screenshot 2025-02-12 153606.png', 'userThumbnails/zOh31hvdAsvxPJsPnQ7LzIBX23C8CnfsLaOPm3gj.png', 'dgtu', 'dgtu', 2, 'gj', 'gh', '[{\"value\":\"laravel\"},{\"value\":\"gug\"}]', '2025-03-13 06:25:13', '2025-03-13 06:25:13'),
(46, 'uploads/eMG-100-G60 (5) (2).stp|uploads/eMG-100-G60 (3) (1) (3).stp', 'thumbnails/egq4LtluDERQ6vOXw1dpXAZDD5PDEl5UbWDD4oSr.png', 'abcd', 'abcd', 1, 'tyuhg', 'tfryty', '[{\"value\":\"ae\"}]', '2025-03-16 23:55:29', '2025-03-16 23:55:29'),
(47, 'uploads/all_files_2025-03-17_lf8nZ.xls|uploads/all_files_2025-03-17_Ub75V.xls', 'userThumbnails/KkEU8gnHG19OFYMKXdE9qWthZG6h0f2APv4XpMrl.png', 'vcdf', 'vcdf', 9, 'dxf', 'fdf', '[{\"value\":\"lessimpt\"}]', '2025-03-17 00:38:13', '2025-03-17 01:01:59'),
(48, 'uploads/eMG-100-G60 (3) (1) (4).stp|uploads/eMG-100-G60 (5) (2).stp|uploads/eMG-100-G60 (3) (1) (3).stp', 'userThumbnails/dcotHESHyE3JMi6k1d7KTZx4yziqirBFyBYRbOsF.png', 'fdf', 'fdf', 9, 'ffg', 'vbv', '[{\"value\":\"lessimpt\"}]', '2025-03-17 00:41:33', '2025-03-17 00:41:33'),
(49, 'uploads/eMG-100-G60 (5) (1) (2)_tOWFT.stp|uploads/eMG-100-G60 (5) (1) (2)_7YziP.stp', 'userThumbnails/bvG6Xb8ahu67El3qzVYHYIhhOcFkhVvo4V8OIk92.png', 'jyykjkj', 'jyykjkj', 9, 'hkjkjk', 'muiuj', '[{\"value\":\"laravel\"}]', '2025-03-17 01:12:59', '2025-03-17 01:17:02'),
(50, 'uploads/eMG-100-G60 (5) (1) (2)_Rxrsk.stp', 'userThumbnails/H7ks56HnwwtFHGsrrYvWEevxEU0Smx6N9J7ykfqJ.png', 'rtyhjukl', 'rtyhjukl', 9, 'hujbn hvh', 'vbvc', '[{\"value\":\"mostimpt\"}]', '2025-03-17 05:56:18', '2025-03-17 05:57:16');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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
(14, '0001_01_01_000002_create_jobs_table', 1),
(19, '0001_01_01_000000_create_users_table', 2),
(20, '0001_01_01_000001_create_cache_table', 2),
(21, '2025_02_14_051537_image_managers', 2),
(22, '2025_02_14_073538_user_types', 3),
(23, '2025_02_19_062902_tags_management', 3),
(24, '2025_02_27_082944_create_user_download_log_table', 4),
(25, '2025_02_27_083759_create_user_searched_log_table', 5),
(26, '2025_03_03_101846_add_last_login_to_users_table', 6),
(27, '2025_03_05_052801_create_password_request_table', 7),
(28, '2025_03_11_071810_user_view_counts', 7);

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

--
-- Table structure for table `password_request`
--

CREATE TABLE `password_request` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `requested_date` timestamp NULL DEFAULT NULL,
  `status` tinyint(100) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `password_request`
--

INSERT INTO `password_request` (`id`, `email`, `requested_date`, `status`) VALUES
(1, 'user@gmail.com', '2025-03-04 06:03:34', 0),
(2, 'user@gmail.com', '2025-03-04 06:57:57', 0),
(3, 'user@gmail.com', '2025-03-04 07:56:44', 0),
(4, 'user@gmail.com', '2025-03-04 07:58:41', 0),
(5, 'user@gmail.com', '2025-03-04 23:54:07', 0),
(6, 'user@gmail.com', '2025-03-04 23:55:45', 0),
(7, 'user@gmail.com', '2025-03-11 00:20:30', 1),
(8, 'hri@gmail.com', '2025-03-18 02:01:20', 0),
(9, 'sr@gmail.com', '2025-03-18 02:12:32', 0);

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

--
-- Table structure for table `password_requests`
--

CREATE TABLE `password_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `requested_date` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('d7ji21OuQJ26uzVDHN6AA36aCqWSsXbpzs5OMn0S', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiOTRUa3JjSWJYb0E2SE9GRkZ5YmQ0UENFdjJ3S1JrVmRMWXhGTXJiNCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NzoidXNlcl9pZCI7aTo5O3M6OToidXNlcl90eXBlIjtpOjI7czoxMToidXNlcl9zdGF0dXMiO3M6MToiMSI7fQ==', 1742285264),
('fH1DlZCk9bfoued5szIWawWTYxdFwtZPmlEh8gb7', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiNWFrT3RWZDhLYlU2eTZMMDN2NlJnUTdjSmxITThLV2dONzhPMTAxbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9wYXNzd29yZC1yZXF1ZXN0cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTI6ImxvZ2luX2FkbWluXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjg6ImFkbWluX2lkIjtpOjE7czo5OiJ1c2VyX3R5cGUiO3M6MToiMSI7fQ==', 1742285486);

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

--
-- Table structure for table `tags_management`
--

CREATE TABLE `tags_management` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tag_name` varchar(255) 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 `user_download_log`
--

CREATE TABLE `user_download_log` (
  `udl_id` bigint(20) UNSIGNED NOT NULL,
  `udl_user_id` bigint(20) UNSIGNED NOT NULL,
  `udl_file_id` bigint(20) UNSIGNED NOT NULL,
  `udl_download_date` varchar(100) NOT NULL,
  `udl_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_download_log`
--

INSERT INTO `user_download_log` (`udl_id`, `udl_user_id`, `udl_file_id`, `udl_download_date`, `udl_created_at`, `updated_at`, `created_at`) VALUES
(1, 2, 6, '2025-03-03 06:13:16', '2025-03-03 00:43:16', NULL, NULL),
(2, 2, 6, '2025-03-03 06:15:32', '2025-03-03 00:45:32', NULL, NULL),
(3, 2, 6, '2025-03-03 06:18:46', '2025-03-03 00:48:46', NULL, NULL),
(4, 2, 10, '2025-03-03 11:59:18', '2025-03-03 06:29:18', NULL, NULL),
(5, 2, 12, '2025-03-04 08:20:29', '2025-03-04 02:50:29', NULL, NULL),
(6, 2, 14, '2025-03-04 08:24:09', '2025-03-04 02:54:09', NULL, NULL),
(7, 9, 14, '2025-03-17 11:21:32', '2025-03-17 05:51:32', '2025-03-17 05:51:32', '2025-03-17 05:51:32'),
(8, 9, 14, '2025-03-17 11:21:36', '2025-03-17 05:51:36', '2025-03-17 05:51:36', '2025-03-17 05:51:36'),
(9, 9, 49, '2025-03-17 11:22:03', '2025-03-17 05:52:03', '2025-03-17 05:52:03', '2025-03-17 05:52:03');

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

--
-- Table structure for table `user_searched_log`
--

CREATE TABLE `user_searched_log` (
  `usl_id` bigint(20) UNSIGNED NOT NULL,
  `usl_user_id` bigint(20) UNSIGNED NOT NULL,
  `usl_system_details` longtext DEFAULT NULL,
  `usl_file_id` bigint(20) UNSIGNED NOT NULL,
  `usl_searched_date` varchar(100) NOT NULL,
  `usl_created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_searched_log`
--

INSERT INTO `user_searched_log` (`usl_id`, `usl_user_id`, `usl_system_details`, `usl_file_id`, `usl_searched_date`, `usl_created_at`) VALUES
(1, 2, '', 1, '2025-03-01 10:41:45', '2025-03-01 05:11:45'),
(2, 2, '', 1, '2025-03-01 10:44:49', '2025-03-01 05:14:49'),
(3, 2, '', 1, '2025-03-01 10:46:10', '2025-03-01 05:16:10'),
(4, 2, '', 1, '2025-03-01 10:47:09', '2025-03-01 05:17:09'),
(5, 2, '', 1, '2025-03-01 10:47:41', '2025-03-01 05:17:41'),
(6, 2, '', 1, '2025-03-01 10:48:47', '2025-03-01 05:18:47'),
(7, 2, '', 1, '2025-03-01 10:49:12', '2025-03-01 05:19:12'),
(8, 2, '', 1, '2025-03-01 10:49:46', '2025-03-01 05:19:46'),
(9, 2, '', 1, '2025-03-01 10:51:01', '2025-03-01 05:21:01'),
(10, 2, '', 1, '2025-03-01 10:51:54', '2025-03-01 05:21:54'),
(11, 2, '', 1, '2025-03-01 10:52:32', '2025-03-01 05:22:32'),
(12, 2, '', 1, '2025-03-01 10:52:46', '2025-03-01 05:22:46'),
(13, 2, '', 1, '2025-03-01 10:53:50', '2025-03-01 05:23:50'),
(14, 2, '', 1, '2025-03-01 10:54:55', '2025-03-01 05:24:55'),
(15, 2, '', 1, '2025-03-01 10:56:13', '2025-03-01 05:26:13'),
(16, 2, '', 1, '2025-03-01 10:56:51', '2025-03-01 05:26:51'),
(17, 2, '', 1, '2025-03-01 10:57:31', '2025-03-01 05:27:31'),
(18, 2, '', 1, '2025-03-01 10:58:38', '2025-03-01 05:28:38'),
(19, 2, '', 1, '2025-03-01 10:59:56', '2025-03-01 05:29:56'),
(20, 2, '', 1, '2025-03-01 11:00:40', '2025-03-01 05:30:40'),
(21, 2, '', 1, '2025-03-01 11:11:48', '2025-03-01 05:41:48'),
(22, 2, '', 1, '2025-03-01 11:12:00', '2025-03-01 05:42:00'),
(23, 2, '', 1, '2025-03-01 11:12:52', '2025-03-01 05:42:52'),
(24, 2, '', 3, '2025-03-01 11:12:52', '2025-03-01 05:42:52'),
(25, 2, '', 1, '2025-03-01 11:14:13', '2025-03-01 05:44:13'),
(26, 2, '', 3, '2025-03-01 11:14:13', '2025-03-01 05:44:13'),
(27, 2, '', 3, '2025-03-01 11:14:24', '2025-03-01 05:44:24'),
(28, 2, '', 3, '2025-03-01 11:15:06', '2025-03-01 05:45:06'),
(29, 2, '', 3, '2025-03-01 11:16:20', '2025-03-01 05:46:20'),
(30, 2, '', 3, '2025-03-01 11:17:29', '2025-03-01 05:47:29'),
(31, 2, '', 1, '2025-03-03 05:38:54', '2025-03-03 00:08:54'),
(32, 2, '', 6, '2025-03-03 05:54:49', '2025-03-03 00:24:49'),
(33, 2, '', 6, '2025-03-03 06:18:43', '2025-03-03 00:48:43'),
(34, 2, '', 6, '2025-03-03 06:35:16', '2025-03-03 01:05:16'),
(35, 2, '', 5, '2025-03-03 06:37:45', '2025-03-03 01:07:45'),
(36, 2, '', 3, '2025-03-03 06:38:07', '2025-03-03 01:08:07'),
(37, 2, '', 3, '2025-03-03 11:58:55', '2025-03-03 06:28:55'),
(38, 2, '', 10, '2025-03-03 11:59:15', '2025-03-03 06:29:15'),
(39, 2, '', 6, '2025-03-03 13:17:45', '2025-03-03 07:47:45'),
(40, 2, '', 6, '2025-03-03 13:17:58', '2025-03-03 07:47:58'),
(41, 2, '', 6, '2025-03-04 04:29:13', '2025-03-03 22:59:13'),
(42, 2, '', 3, '2025-03-04 04:29:49', '2025-03-03 22:59:49'),
(43, 2, '', 12, '2025-03-04 08:20:25', '2025-03-04 02:50:25'),
(44, 2, '', 3, '2025-03-04 08:22:44', '2025-03-04 02:52:44'),
(45, 2, '', 12, '2025-03-04 08:22:44', '2025-03-04 02:52:44'),
(46, 2, '', 3, '2025-03-04 08:23:03', '2025-03-04 02:53:03'),
(47, 2, '', 12, '2025-03-04 08:23:03', '2025-03-04 02:53:03'),
(48, 2, '', 3, '2025-03-04 08:24:04', '2025-03-04 02:54:04'),
(49, 2, '', 12, '2025-03-04 08:24:04', '2025-03-04 02:54:04'),
(50, 2, '', 14, '2025-03-04 08:24:04', '2025-03-04 02:54:04'),
(51, 2, '', 12, '2025-03-05 12:34:54', '2025-03-05 07:04:54'),
(52, 2, '', 13, '2025-03-05 12:34:54', '2025-03-05 07:04:54'),
(53, 2, '', 17, '2025-03-05 12:34:54', '2025-03-05 07:04:54'),
(54, 2, '', 3, '2025-03-07 04:42:09', '2025-03-06 23:12:09'),
(55, 2, '', 12, '2025-03-07 04:42:09', '2025-03-06 23:12:09'),
(56, 2, '', 14, '2025-03-07 04:42:09', '2025-03-06 23:12:09'),
(57, 2, '', 3, '2025-03-07 05:07:03', '2025-03-06 23:37:03'),
(58, 2, '', 12, '2025-03-07 05:07:03', '2025-03-06 23:37:03'),
(59, 2, '', 14, '2025-03-07 05:07:03', '2025-03-06 23:37:03'),
(60, 2, '', 3, '2025-03-07 05:09:58', '2025-03-06 23:39:58'),
(61, 2, '', 12, '2025-03-07 05:09:58', '2025-03-06 23:39:58'),
(62, 2, '', 14, '2025-03-07 05:09:58', '2025-03-06 23:39:58'),
(63, 2, '', 23, '2025-03-07 05:49:06', '2025-03-07 00:19:06'),
(64, 2, '', 23, '2025-03-07 05:50:45', '2025-03-07 00:20:45'),
(65, 2, '', 23, '2025-03-07 05:55:02', '2025-03-07 00:25:02'),
(66, 2, '', 23, '2025-03-07 05:55:05', '2025-03-07 00:25:05'),
(67, 2, '', 23, '2025-03-07 05:55:12', '2025-03-07 00:25:12'),
(68, 2, '', 14, '2025-03-07 05:55:19', '2025-03-07 00:25:19'),
(69, 2, '', 18, '2025-03-07 05:55:19', '2025-03-07 00:25:19'),
(70, 2, '', 14, '2025-03-07 05:57:15', '2025-03-07 00:27:15'),
(71, 2, '', 18, '2025-03-07 05:57:15', '2025-03-07 00:27:15'),
(72, 2, '', 22, '2025-03-07 05:57:58', '2025-03-07 00:27:58'),
(73, 2, '', 14, '2025-03-07 06:52:15', '2025-03-07 01:22:15'),
(74, 2, '', 18, '2025-03-07 06:52:15', '2025-03-07 01:22:15'),
(75, 2, '', 13, '2025-03-07 07:52:08', '2025-03-07 02:22:08'),
(76, 2, '', 32, '2025-03-07 07:52:08', '2025-03-07 02:22:08'),
(77, 2, '', 20, '2025-03-07 07:52:34', '2025-03-07 02:22:34'),
(78, 2, '', 14, '2025-03-07 07:56:37', '2025-03-07 02:26:37'),
(79, 2, '', 18, '2025-03-07 07:56:37', '2025-03-07 02:26:37'),
(80, 2, '', 1, '2025-03-11 05:43:14', '2025-03-11 00:13:14'),
(81, 3, NULL, 1, '2025-03-11 10:49:49', '2025-03-11 05:19:49'),
(82, 5, NULL, 1, '2025-03-11 10:54:47', '2025-03-11 05:24:47'),
(83, 5, NULL, 2, '2025-03-11 11:02:56', '2025-03-11 05:32:56'),
(84, 5, NULL, 2, '2025-03-11 11:03:07', '2025-03-11 05:33:07'),
(85, 2, NULL, 1, '2025-03-11 11:04:10', '2025-03-11 05:34:10'),
(86, 2, NULL, 1, '2025-03-11 11:06:48', '2025-03-11 05:36:48'),
(87, 5, NULL, 33, '2025-03-11 11:08:25', '2025-03-11 05:38:25'),
(88, 5, NULL, 34, '2025-03-11 11:08:25', '2025-03-11 05:38:25'),
(89, 5, NULL, 35, '2025-03-11 11:08:25', '2025-03-11 05:38:25'),
(90, 5, NULL, 36, '2025-03-11 11:08:25', '2025-03-11 05:38:25'),
(91, 5, NULL, 37, '2025-03-11 11:08:25', '2025-03-11 05:38:25'),
(92, 5, NULL, 38, '2025-03-11 11:08:25', '2025-03-11 05:38:25'),
(93, 5, NULL, 33, '2025-03-11 11:08:42', '2025-03-11 05:38:42'),
(94, 5, NULL, 34, '2025-03-11 11:08:42', '2025-03-11 05:38:42'),
(95, 5, NULL, 35, '2025-03-11 11:08:42', '2025-03-11 05:38:42'),
(96, 5, NULL, 36, '2025-03-11 11:08:42', '2025-03-11 05:38:42'),
(97, 5, NULL, 37, '2025-03-11 11:08:42', '2025-03-11 05:38:42'),
(98, 5, NULL, 38, '2025-03-11 11:08:42', '2025-03-11 05:38:42'),
(99, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 14, '2025-03-11 13:18:00', '2025-03-11 07:48:00'),
(100, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 18, '2025-03-11 13:18:00', '2025-03-11 07:48:00'),
(101, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 41, '2025-03-11 13:18:00', '2025-03-11 07:48:00'),
(102, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 14, '2025-03-11 13:25:35', '2025-03-11 07:55:35'),
(103, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 18, '2025-03-11 13:25:35', '2025-03-11 07:55:35'),
(104, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 41, '2025-03-11 13:25:35', '2025-03-11 07:55:35'),
(105, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 14, '2025-03-11 13:25:38', '2025-03-11 07:55:38'),
(106, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 18, '2025-03-11 13:25:38', '2025-03-11 07:55:38'),
(107, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 41, '2025-03-11 13:25:38', '2025-03-11 07:55:38'),
(108, 1, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 1, '2025-03-11 13:28:49', '2025-03-11 07:58:49'),
(109, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 14, '2025-03-11 13:30:44', '2025-03-11 08:00:44'),
(110, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 18, '2025-03-11 13:30:44', '2025-03-11 08:00:44'),
(111, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 41, '2025-03-11 13:30:44', '2025-03-11 08:00:44'),
(112, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 14, '2025-03-11 13:35:17', '2025-03-11 08:05:17'),
(113, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 18, '2025-03-11 13:35:17', '2025-03-11 08:05:17'),
(114, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 41, '2025-03-11 13:35:17', '2025-03-11 08:05:17'),
(115, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 14, '2025-03-11 13:35:20', '2025-03-11 08:05:20'),
(116, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 18, '2025-03-11 13:35:20', '2025-03-11 08:05:20'),
(117, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 41, '2025-03-11 13:35:20', '2025-03-11 08:05:20'),
(118, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 3, '2025-03-11 13:35:30', '2025-03-11 08:05:30'),
(119, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 3, '2025-03-11 13:40:08', '2025-03-11 08:10:08'),
(120, 2, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 3, '2025-03-11 13:40:57', '2025-03-11 08:10:57'),
(121, 9, '{\"ip\":\"127.0.0.1\",\"browser\":\"Chrome\",\"platform\":\"Windows\",\"device\":\"WebKit\",\"is_mobile\":false,\"is_desktop\":true}', 1, '2025-03-17 07:20:55', '2025-03-17 01:50:55');

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

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `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 `user_types`
--

INSERT INTO `user_types` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Supper Admin', 1, '2025-02-18 00:53:16', '2025-02-18 00:53:16'),
(2, 'Sub Admin', 1, '2025-02-18 00:53:16', '2025-02-18 00:53:16'),
(3, 'Normal User', 1, '2025-02-18 00:53:16', '2025-02-18 00:53:16');

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

--
-- Table structure for table `user_view_counts`
--

CREATE TABLE `user_view_counts` (
  `uvc_id` bigint(20) UNSIGNED NOT NULL,
  `uvc_user_id` bigint(20) UNSIGNED NOT NULL,
  `uvc_file_id` bigint(20) UNSIGNED NOT NULL,
  `view_count` int(11) NOT NULL DEFAULT 0,
  `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 `user_view_counts`
--

INSERT INTO `user_view_counts` (`uvc_id`, `uvc_user_id`, `uvc_file_id`, `view_count`, `created_at`, `updated_at`) VALUES
(1, 2, 5, 3, '2025-03-12 23:24:04', '2025-03-13 04:37:20'),
(2, 2, 17, 1, '2025-03-12 23:24:10', '2025-03-12 23:24:10'),
(3, 2, 20, 1, '2025-03-12 23:24:15', '2025-03-12 23:24:15'),
(4, 2, 1, 1, '2025-03-12 23:38:22', '2025-03-12 23:38:22'),
(5, 2, 2, 1, '2025-03-12 23:38:34', '2025-03-12 23:38:34'),
(6, 2, 19, 1, '2025-03-12 23:47:49', '2025-03-12 23:47:49'),
(7, 2, 3, 1, '2025-03-13 01:40:53', '2025-03-13 01:40:53'),
(8, 2, 40, 1, '2025-03-13 01:41:02', '2025-03-13 01:41:02'),
(9, 2, 12, 4, '2025-03-13 04:37:29', '2025-03-13 06:25:55'),
(10, 10, 16, 1, '2025-03-17 01:47:44', '2025-03-17 01:47:44'),
(11, 10, 19, 1, '2025-03-17 01:47:52', '2025-03-17 01:47:52'),
(12, 9, 1, 1, '2025-03-17 02:21:23', '2025-03-17 02:21:23'),
(13, 9, 14, 6, '2025-03-17 02:21:40', '2025-03-17 05:51:36'),
(14, 9, 12, 1, '2025-03-17 05:38:42', '2025-03-17 05:38:42'),
(15, 9, 49, 1, '2025-03-17 05:51:59', '2025-03-17 05:51:59');

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

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `tags_management`
--
ALTER TABLE `tags_management`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tags_management_tag_name_unique` (`tag_name`);

--
-- Indexes for table `user_download_log`
--
ALTER TABLE `user_download_log`
  ADD PRIMARY KEY (`udl_id`),
  ADD KEY `user_download_log_udl_user_id_index` (`udl_user_id`),
  ADD KEY `user_download_log_udl_file_id_index` (`udl_file_id`);

--
-- Indexes for table `user_searched_log`
--
ALTER TABLE `user_searched_log`
  ADD PRIMARY KEY (`usl_id`),
  ADD KEY `user_searched_log_usl_user_id_index` (`usl_user_id`),
  ADD KEY `user_searched_log_usl_file_id_index` (`usl_file_id`);

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

--
-- Indexes for table `user_view_counts`
--
ALTER TABLE `user_view_counts`
  ADD PRIMARY KEY (`uvc_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `password_request`
--
ALTER TABLE `password_request`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

--
-- AUTO_INCREMENT for table `user_download_log`
--
ALTER TABLE `user_download_log`
  MODIFY `udl_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `user_searched_log`
--
ALTER TABLE `user_searched_log`
  MODIFY `usl_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;

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

--
-- AUTO_INCREMENT for table `user_view_counts`
--
ALTER TABLE `user_view_counts`
  MODIFY `uvc_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `user_download_log`
--
ALTER TABLE `user_download_log`
  ADD CONSTRAINT `user_download_log_udl_user_id_foreign` FOREIGN KEY (`udl_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

