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

CREATE TABLE `editpage` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT 'None',
  `status` varchar(255) NOT NULL DEFAULT 'disabled',
  `content` text NOT NULL DEFAULT 'None',
  `last_update` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `editpage`
--

INSERT INTO `editpage` (`id`, `title`, `description`, `status`, `content`, `last_update`) VALUES
(1, 'About Us', 'NONE', 'enabled', 'Welcome to ScamSecure! We are dedicated to providing a safe and secure platform for finding accommodations and avoiding scams. Our mission is to empower users with reliable information to make informed decisions.\r\n\r\nOur Story\r\nFounded in 2020, ScamSecure was born out of a passion for travel and a desire to protect fellow travelers from fraudulent activities. Over the years, we have built a community-driven platform that prioritizes transparency and accountability.\r\n\r\nOur Team\r\nMeet the dedicated team behind ScamSecure:\r\n\r\nJohn Doe - Founder & CEO\r\nJane Smith - Chief Operations Officer\r\nMichael Johnson - Lead Developer\r\nOur Vision\r\nAt ScamSecure, our vision is to create a world where everyone can travel and explore with confidence, knowing that they are protected from scams and fraudulent activities.', '2024-06-02 18:12:22'),
(2, 'Contact Us', 'NONE', 'enabled', 'None', '2024-06-02 18:12:22'),
(3, 'Privacy Policy', 'NONE', 'enabled', 'None', '2024-06-02 18:12:22'),
(4, 'Terms and Conditions', 'NONE', 'enabled', 'None', '2024-06-02 18:12:22');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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