-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 03, 2024 at 10:10 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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: `test`
--

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `post_id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `sub_category` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `scammer_name` varchar(255) NOT NULL,
  `fb_link` varchar(255) NOT NULL,
  `sc_phone` int(11) NOT NULL,
  `sc_email` varchar(255) NOT NULL,
  `sc_username` varchar(255) NOT NULL,
  `sc_bankname` varchar(255) NOT NULL,
  `sc_bankacctname` varchar(255) NOT NULL,
  `sc_bankacctnumber` int(11) NOT NULL,
  `qr_img` varchar(255) NOT NULL,
  `description` varchar(1020) NOT NULL,
  `agreed_terms` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `count_id` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'unpublished',
  `date_posted` date NOT NULL DEFAULT current_timestamp(),
  `date_updated` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`post_id`, `category`, `sub_category`, `title`, `scammer_name`, `fb_link`, `sc_phone`, `sc_email`, `sc_username`, `sc_bankname`, `sc_bankacctname`, `sc_bankacctnumber`, `qr_img`, `description`, `agreed_terms`, `user_id`, `count_id`, `status`, `date_posted`, `date_updated`) VALUES
(6, 'ELECTRONICS', 'Accessories', 'Watch Scam', 'Jiji', 'jiji.com', 12141, 'jiji@gmail.com', 'Jiji3322', 'Landbank', 'Jiji Hadid', 121251, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Watch Scam', 'agreed', 11, 'id_z11yd1v1t', 'published', '2024-05-23', '2024-05-23'),
(7, 'ELECTRONICS', 'Video Games', '2k SCam', 'lebron', 'lebron.com', 2411241, 'lebron@gmail.com', 'lebron23', 'BDO', 'Lebron James', 15121412, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Nba 2k', 'agreed', 11, 'id_mboejb2s6', 'published', '2024-05-23', '2024-05-23'),
(8, 'HOBBIES', 'Cars for sale', 'Scammed Car', 'Kris', 'kris.com', 241421, 'kris@gmail.com', 'Kris00', 'BPI', 'Kris Jay', 1247148, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Scammed Mitsubshi lancer', 'agreed', 11, 'id_yfjxu7nku', 'published', '2024-05-23', '2024-05-23'),
(9, 'ENTERTAINMENT', 'Music, Books, Movies', 'Movie Ticket Scam', 'Kobe', 'kobe.com', 12097, 'kobe@gmail.com', 'kobe24', 'Landbank', 'Kobe Bean Bryant', 7213813, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Didnt get a ticket I paid.', 'agreed', 11, 'id_w6xn5rzg9', 'unpublished', '2024-05-23', '2024-05-23'),
(10, 'FAMILY', '', 'Watch Scam', 'Carmelo Anthony', 'Carmelo.com', 1241241, 'carmelo@gmail.com', 'melo15', 'BPI', 'Carmelo Anthony', 1271294817, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Didnt give me the watch', 'agreed', 11, 'id_qq4bcjv94', 'unpublished', '2024-05-23', '2024-05-23'),
(11, 'ENTERTAINMENT', 'Event Tickets', 'Brunno Ticket Scam', 'Jay Barea', 'jay.com', 124124, 'jar@gmail.com', 'jayjay22', 'BPI', 'Jay Jay Barea', 1241212, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Got scammed by him', 'agreed', 11, 'id_ysdn51su6', 'unpublished', '2024-05-23', '2024-05-23'),
(12, 'HOME & GARDEN', 'Food', 'Scammed Canned Goods', 'Jj Rideck', 'Jj.com', 124112, 'jj@gmail.com', 'JJ00', 'BDO', 'JJ Redick', 124112, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Got Scammed!', 'agreed', 11, 'id_uygkvq5uh', 'unpublished', '2024-05-23', '2024-05-23'),
(15, 'ENTERTAINMENT', 'Sing/Dance Competition', 'Scammed Dance', 'Karl Towns', 'karl.com', 1241412, 'karl@gmail.com', 'kat00', 'BPI', 'Karl Towns', 1241412, '/App/uploads/qrcode1.png', 'Didn\'t Dance', 'agreed', 16, 'id_uo2y64mpb', 'unpublished', '2024-05-24', '2024-05-24'),
(16, 'ELECTRONICS', 'Phone', 'Scammed Phone', 'Kyrie Irving', 'kyrie.com', 1241241, 'kyrie@gmail.com', 'kyrie2', 'BPI', 'Kyrie Irving', 12412141, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Scammed buying a phone', 'agreed', 15, 'id_sqx4743zs', 'published', '2024-05-28', '2024-05-28'),
(17, 'FAMILY', 'Jewelry', 'Scammed Jewelry', 'CJ Ingram', 'ingram.com', 124141, 'ingram@gmail.com', 'ingram32', 'BPI', 'CJ Ingram', 12414124, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Scammed Jewelry ring', 'agreed', 15, 'id_qdtqzmffg', 'unpublished', '2024-05-28', '2024-05-28'),
(18, 'HOBBIES', 'Musical Instrument', 'Instrument Scam', 'Jason', 'jason.cm', 1241241, 'jason@gmail.com', 'Jason00', 'BPI', 'Jason Kidd', 2141412, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Scammed instrument guitar', 'agreed', 11, 'id_yw7o8bygf', 'unpublished', '2024-05-30', '2024-05-30'),
(19, 'BUSINESS', 'Investment', 'Investment Scam', 'Pascal Siakam', 'pascalfb.com', 1241241, 'pascal@gmail.com', 'spicyP', 'BPI', 'Pascal Siakam', 12412412, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Investment scam', 'agreed', 12, 'id_091wbpmlp', 'published', '2024-06-02', '2024-06-02'),
(20, 'HOME & GARDEN', 'Kitchenware', 'Scammed Kitchenware', 'Tyres Halbirton', 'tyres.com', 21412141, 'tyres@gmail.com', 'Dimes', 'Landbank', 'Tyres Halbirton', 214141, '/Applications/XAMPP/htdocs/App/uploads/qrcode1.png', 'Cooking pan Scammed.', 'agreed', 12, 'id_yue1oiudt', 'published', '2024-06-02', '2024-06-02');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`post_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
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 */;
