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

START TRANSACTION;



--
-- Database: `test`
--

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

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

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `user_role` varchar(255) DEFAULT 'user',
  `user_name` varchar(255) NOT NULL,
  `firstmid_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `birthday` date NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` int(11) NOT NULL,
  `country` varchar(255) NOT NULL,
  `id_image` varchar(255) NOT NULL,
  `date_registered` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(255) DEFAULT 'unverified',
  `no_posts` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`user_id`, `user_role`, `user_name`, `firstmid_name`, `last_name`, `birthday`, `password`, `email`, `phone`, `country`, `id_image`, `date_registered`, `status`, `no_posts`) VALUES
(1, 'admin', 'ar02', 'Ar Pam', 'Tangente', '0000-00-00', '$2y$10$rXIkaMwvNH4qgL4xxnCmdemP8e52FvQPzpWLxxV0kYoLalUAhasWq', 'ar@gmail.com', 1211241241, 'ph', '', '2024-05-18 07:09:46', 'verified', 0),
(2, 'user', 'faustine00', 'Faustine', 'Gaines', '0000-00-00', '$2y$10$IunT0JcIgQClM0F4tD9t/uAeTH8qCXx5wFRjLBFkr9.8oW5rzOIrm', 'faus@gmail.com', 2141241, 'us', '', '2024-05-18 07:09:41', 'verified', 0),
(3, 'admin', 'john00', 'John', 'Wall', '2014-05-15', '$2y$10$u4eUUKgi7SekOil8PI6FoeteU0iXgqbTN.S.aXDK.zIEBlOJYPEIW', 'john00@gmail.com', 1211241241, 'sg', '', '2024-05-19 17:33:01', 'blocked', 0),
(11, 'user', 'Luka20', 'Luka', 'Doncic', '2015-05-19', '$2y$10$OdEfHtmfXoLTbVA7cTNw6O0ueeTSLS/GizYWT0xpP2oZQiqQ2pGYS', 'luka2@gmail.com', 124114, 'ph', 'id3.jpeg', '2024-05-23 18:27:12', 'verified', 0),
(12, 'admin', 'Deuce01', 'Jayson', 'Tangente', '2001-07-18', '$2y$10$oOP6UkAzq8jUlrfPjnzshuqzILNl6eviQ6rGPVQ6AvUKdfZv8RLeG', 'jayson00@gmail.com', 89698987, 'ph', 'checkmark.png', '2024-05-20 18:19:45', 'verified', 0),
(13, 'admin', 'Jaylen3', 'Jaylen', 'Brown', '2007-06-18', '$2y$10$IogiHyUTxUoEiEY8vs9vD.cgGaYKwy4KNALdIwRZLmRar9Z.RVHFe', 'jaylen@gmail.com', 12412412, 'ph', 'anti-scammer-icon-vector-21079689.jpg', '2024-05-18 16:56:25', 'blocked', 0),
(14, 'admin', 'jrue02', 'Jrue', 'Holiday', '2002-02-18', '$2y$10$09DoE5syA3C13quhntzC4eYaIdFqh9NCdTUZZ4z7VOYzbvhalW0Ym', 'jrue@gmail.com', 892842, 'Philippines', '23569861-sample-grunge-red-round-stamp.jpg', '2024-05-20 17:21:10', 'verified', 0),
(15, 'user', 'faustine22', 'Faustine', 'Tangente', '2007-06-20', '$2y$10$BwK/4pWi0hnoGfCiigXl0eWMix1HAwD2oiOkwkqGO5LTlqo6C24OG', 'artangente00@gmail.com', 124719847, 'Philippines', '23569861-sample-grunge-red-round-stamp.jpg', '2024-06-02 18:20:42', 'verified', 0),
(16, 'user', 'ant23', 'Anthony', 'Carmelo', '2004-06-20', '$2y$10$ek29OEk1O8Eo0ud4nQvdCuCJ0l3znoIx4MR9/4oxyT/LOU1vN.tou', 'ant@gmail.com', 309230952, 'United States', 'image6.jpeg', '2024-05-20 18:40:55', 'verified', 0),
(17, 'user', 'landry00', 'Landry', 'Fields', '1993-06-15', '$2y$10$4dRPi7HubgRT/kwF2Mgdfujh/SskaKlzbAyf2aKfrdsKrFlo7aLWq', 'faustinetangente00@gmail.com', 21412412, 'Philippines', 'landry.jpg', '2024-06-02 17:24:50', 'verified', 0),
(18, 'user', 'derick23', 'Derick', 'White', '2009-05-29', '$2y$10$Sc2H13tJghgEvYpNE1eip.ITl6Q/cQDOJDypCtqsUPTa.qxSGAFW2', 'faustinetangente00@gmail.com', 124121, 'Philippines', 'id2.jpeg', '2024-06-02 17:20:19', 'verified', 0),
(19, 'user', 'Oldman Al', 'Al', 'Horford', '1993-11-03', '$2y$10$iIBSyyJk5QZy1ONbwEcuCuMYtZgwe3V.psZD2JsQ145f9iJtmHwO6', 'artangente00@gmail.com', 124121, 'Philippines', 'id3.jpeg', '2024-06-02 17:31:10', 'verified', 0),
(20, 'user', 'Sam3', 'Sam ', 'Hauser', '1984-10-31', '$2y$10$Pu/Y419/dWE0wwYEVihINO6yW64Li/67QbAdBZpofAzyJaMHojyx6', 'artangente00@gmail.com', 214141, 'Singapore', 'id4.jpeg', '2024-06-03 01:54:59', 'verified', 0),
(21, 'user', 'Austin00', 'Austin', 'Rivers', '1973-04-13', '$2y$10$1zWROEE6bgVUoTXXULdrl.TCoK/CazLdnyHPtqoj92kzTw7mjg1Fe', 'austin@gmail.com', 1241, 'United States', 'vaild_id_img.jpeg', '2024-06-02 18:04:48', 'unverified', 0),
(22, 'user', 'kmart', 'Kenyon', 'Martin', '1973-03-22', '$2y$10$.uFUBNYTW6conC1DaWBieO.hTgDFMnEeSJ/zJPrC2kOjCS9.0RVVK', 'kmart@gmail.com', 12412, 'Philippines', 'id3.jpeg', '2024-06-02 18:04:54', 'unverified', 0),
(23, 'user', 'brad23', 'Brad', 'Stevens', '1973-02-11', '$2y$10$OWAyxi6uerdJ3KPLBQuN1.5hcHBVpDyX7Nk/uE8fWFhCuzDWKaP2G', 'brad@gmail.com', 12411241, 'Philippines', 'id3.jpeg', '2024-06-02 18:05:02', 'unverified', 0),
(24, 'user', 'Sam00', 'Sam', 'Cassell', '1988-02-11', '$2y$10$XeP9MuO/86RqWdLycSk3JOlRyI2mbklAOdbldSyrD4.Aw6sM0Pc/C', 'sam@gmail.com', 1212412, 'Philippines', 'id4.jpeg', '2024-06-02 18:05:08', 'unverified', 0),
(25, 'user', 'Boyet22', 'Boyet', 'Cruz', '1973-11-23', '$2y$10$BmQc.MJoN.bgXULDsSWIjeI7bjf.nNO1X937TuJwRuj5TlNxdGNjO', 'boyet@gmail.com', 1234534, 'Philippines', 'id3.jpeg', '2024-06-02 18:05:13', 'unverified', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
COMMIT;

