-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 23, 2024 at 06:29 AM
-- Server version: 8.3.0
-- PHP Version: 8.2.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `user_db`
--

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

--
-- Table structure for table `uploaded_files`
--

DROP TABLE IF EXISTS `uploaded_files`;
CREATE TABLE IF NOT EXISTS `uploaded_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `upload_date` datetime NOT NULL,
  `file_url` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `file_title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `email` text COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password_hash`, `created_at`, `email`, `password`) VALUES
(1, 'admin3444', '$2b$12$HIGelHax4HuhBZ66ssNOIeWZaYLoNF6Redk.lhHytSd7Wv3GZjNSG', '2024-09-16 07:05:53', '', ''),
(2, 'admin3444x', '', '2024-09-16 15:19:17', 'admin3444x@gmail.com', 'pbkdf2:sha256:600000$6MWgJX1aMpvAglFr$ee46a47ac38065767efac6718b3f303ff472f903498cbd450d5ff17c0b0cb2d8'),
(3, 'admin12311@gmail.com', '', '2024-09-16 15:19:26', 'admin12311@gmail.com', 'pbkdf2:sha256:600000$mQftSS2umChuYbLR$e80d8289ea1e97bce6048e0bae39000f996ad5766968357b88225831e549aeeb'),
(4, 'admin3444zzzzz', '', '2024-09-16 15:41:28', 'admin3444zzzzz@gmail.com', 'pbkdf2:sha256:600000$9eXqHRBTvRSfdiud$ab35a11cf9a8cbe9106a8b902454f391146ff9ac31f1dc6a0a90fdd04f31b6d0'),
(5, '112268Abc1x', '', '2024-09-16 15:48:01', '112268Abc1x@gmail.com', 'pbkdf2:sha256:600000$G56CBymD4XGdnzBb$e59162a720bcac9ca638373d8d30dcd00d7452199ea947a806ce6c5e3dcc3d27'),
(6, 'admin1232', '', '2024-09-17 00:00:37', 'admin1232@gmail.com', 'pbkdf2:sha256:600000$QX4bIV49grezg9qm$beeafe7baa51951c46adc438e8146fcd3d097dfa0771d33310969d7d42c074e9'),
(7, 'admin123', '', '2024-09-17 16:43:45', 'admin123222222@gmail.com', 'pbkdf2:sha256:600000$Hm7kWECXZBXGwwQV$410f471b06008cdd918b09f58a32fb17e155fdc78fd4e8c3cdc71f89b87a9028'),
(8, 'admin3444xxx', '', '2024-09-18 00:11:09', 'admin3444xxx@gmail.com', 'pbkdf2:sha256:600000$CxCHj4Dwz00iBUpZ$34f65eeee63c13d531a5cb27195c5d40420ce4d35b53fa0b97f3a808f9bfc294'),
(9, 'admin3444xxxxx', '', '2024-09-18 00:54:06', 'admin3444xxxxx@admin3444xxxxx.com', 'pbkdf2:sha256:600000$PBXcZUugU7qSQwEA$5dca76f8ed1c34d215534aff1cd71c35dc20f80871646fd50aec700e27be5cf7'),
(10, 'abc1231111111', '', '2024-09-18 09:26:03', 'abc1231111111@abc1231111111.com', 'pbkdf2:sha256:600000$Y5cjKrmZUyN2UJV0$240ae141b403a2e603d07266de2ce4ee7902f35499480a82726085c309061498'),
(11, 'aeokok123', '', '2024-09-18 09:47:19', 'aeokok123@aeokok123.com', 'pbkdf2:sha256:600000$tfPtNmOahUgK3c6x$10eea2bdfe3d73cf2e9445b01d2626dd9b3e690872935de30a73f874186bcaeb'),
(12, 'admin', '', '2024-09-20 22:10:27', 'admin@gmail.com', 'pbkdf2:sha256:600000$qVgQRhtMa7KI4vLH$2ae69d563e352e942fe112f54f751589cce8dacdd2e5bf3a7c2b4637940461ec'),
(13, '123123123', '', '2024-09-22 07:58:19', '123123123@123123123.com', 'pbkdf2:sha256:600000$elmjRzL9TiFHHQ8v$e026a09d500feba5abc50841a9302f1e95f8d260e9ceb1e40a29a6ed5fdb0307');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
