-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 03, 2024 at 11:05 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`
--

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

--
-- Structure for view `view_posts_users`
--

CREATE VIEW `view_posts_users`  AS SELECT `posts`.`title` AS `title`, `posts`.`scammer_name` AS `scammer_name`, `posts`.`sc_phone` AS `sc_phone`, `posts`.`sc_email` AS `sc_email`, `posts`.`post_id` AS `post_id`, `posts`.`count_id` AS `count_id`, `posts`.`sc_username` AS `sc_username`, `posts`.`sc_bankacctname` AS `sc_bankacctname`, `posts`.`sc_bankacctnumber` AS `sc_bankacctnumber`, `posts`.`date_posted` AS `date_posted`, `posts`.`user_id` AS `user_id`, `users`.`user_name` AS `user_name`, `posts`.`category` AS `category`, `posts`.`status` AS `status` FROM (`posts` join `users` on(`posts`.`user_id` = `users`.`user_id`)) ;

--
-- VIEW `view_posts_users`
-- Data: None
--

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 */;
