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

START TRANSACTION;



--
-- Database: `jpa.com.ng`
--

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `ID` int(100) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `des` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `dp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`ID`, `name`, `des`, `dp`, `date`, `user`, `type`) VALUES
(14, 'Here is a new post', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Aspernatur \r\n\r\nlaborum recusandae quibusdam vero asperiores enim veniam fuga nesciunt non error, repellendus at molestias tempora accusamus dignissimos quo dolores nemo? Ipsa nihil laudantium asperiores debitis earum perferendis dolores quaerat animi reprehenderit, impedit doloremque ipsum velit, corrupti sunt repellat harum odit amet ea veniam, nulla quia molestiae. Possimus corrupti iste earum modi facere quisquam nemo repellendus iure nostrum at in doloremque \r\n\r\nporro, minus eligendi eum doloribus facilis rerum reiciendis quaerat explicabo excepturi pariatur! Dignissimos ad itaque obcaecati doloremque recusandae illum consequatur nisi illo dolorem?', 'download (1).jpg', '2024-02-14 13:55:59.246897', '4', 'branch'),
(15, 'This is the story of a time longago ', 'Here is the way Lorem ipsum dolor sit amet consectetur adipisicing elit. Aspernatur esse maiores commodi earum reprehenderit similique delectus totam laborum recusandae quibusdam vero asperiores enim veniam fuga nesciunt non error, repellendus at molestias tempora accusamus dignissimos quo dolores nemo? Ipsa nihil laudantium asperiores debitis earum perferendis dolores quaerat animi reprehenderit, impedit doloremque ipsum velit, corrupti sunt repellat harum odit amet ea veniam, nulla quia molestiae. Possimus corrupti iste earum modi facere quisquam nemo repellendus iure nostrum at in doloremque porro, minus eligendi eum \r\n\r\ndoloribus facilis rerum reiciendis quaerat explicabo excepturi pariatur! Dignissimos ad itaque obcaecati doloremque recusandae illum consequatur nisi illo dolorem?', 'amily.jpg', '2024-02-14 13:57:41.904639', '4', 'branch'),
(16, 'This is the story of a time longago  ssddf', 'Here is the way Lorem ipsum dolor sit amet consectetur adipisicing elit. Aspernatur esse maiores commodi earum reprehenderit similique delectus totam laborum recusandae quibusdam vero asperiores enim veniam fuga nesciunt non error, repellendus at molestias tempora accusamus dignissimos quo dolores nemo? Ipsa nihil laudantium asperiores debitis earum perferendis dolores quaerat animi reprehenderit, impedit doloremque ipsum velit, corrupti sunt repellat harum odit amet ea veniam, nulla quia molestiae. Possimus corrupti iste earum modi facere quisquam nemo repellendus iure nostrum at in doloremque porro, minus eligendi eum \r\n\r\ndoloribus facilis rerum reiciendis quaerat explicabo excepturi pariatur! Dignissimos ad itaque obcaecati doloremque recusandae illum consequatur nisi illo dolorem?', 'gettyimages-498323251-612x612.jpg', '2024-02-14 13:58:50.508265', '4', 'branch');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `ID` int(100) NOT NULL,
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `post_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `reply_to` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'none',
  `date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`ID`, `user`, `name`, `email`, `body`, `post_id`, `reply_to`, `date`) VALUES
(1, '1', '', '', 'fnkdnnjvndjnfnf', '1', 'none', '2023-12-28 15:25:45.266797'),
(2, '1', '', '', 'mvnbcnncbcbbvg', '0', '1', '2023-12-28 15:25:57.983635'),
(3, '4', '', '', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Iure aspernatur autem expedita sunt consequuntur rem quibusdam nam asperiores eos, quas nostrum ipsa atque obcaecati, mollitia aliquam ab, unde quod accusamus similique! At assumenda a omnis incidunt, eos numquam tempore repellendus cupiditate nobis excepturi mollitia. Culpa dolore perspiciatis fuga ad iste?', '16', 'none', '2024-02-15 07:15:12.269180'),
(4, '4', '', '', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Iure aspernatur autem expedita sunt consequuntur rem quibusdam nam asperiores eos, quas nostrum ipsa atque obcaecati, mollitia aliquam ab, unde quod accusamus similique! At assumenda a omnis incidunt, eos numquam tempore repellendus cupiditate nobis excepturi mollitia. Culpa dolore perspiciatis fuga ad iste?', '16', 'none', '2024-02-15 07:18:25.631712'),
(5, '4', 'Dan', 'dan@gmail.comd', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Iure aspernatur autem expedita sunt consequuntur rem quibusdam nam asperiores eos, quas nostrum ipsa atque obcaecati, mollitia aliquam ab, unde quod accusamus similique! At assumenda a omnis incidunt, eos numquam tempore repellendus cupiditate nobis excepturi mollitia. Culpa dolore perspiciatis fuga ad iste?', '16', 'none', '2024-02-15 07:20:43.477889'),
(6, '4', 'Angela', 'anointed@gmail.com', 'ahahahahahahah ahahah Adonai', '16', 'none', '2024-02-19 01:41:12.949874'),
(7, '4', '', '', '', '16', 'none', '2024-02-19 02:20:23.468859');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `ID` int(100) NOT NULL,
  `under` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `des` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `dp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`ID`, `under`, `title`, `des`, `dp`, `date`, `user`) VALUES
(1, '', 'Here is our event', 'This is my testament and this is what i want tot do ', 'download (25).jpg', '2024-02-05', '22'),
(2, '6', 'Todays Event', '', 'download (27).jpg', '2024-02-06', '22');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `ID` int(100) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`ID`, `name`, `email`, `msg`, `type`, `date`) VALUES
(1, 'dan', 'franklinprodigy25@gmail.com', 'Hello Thanks for the website', 'contact_msg', '2024-02-05 21:28:15.375861'),
(2, 'images', 'Email@server.com', 'Hello This is our message', 'contact_msg', '2024-02-07 19:51:45.040532'),
(3, '', 'franklinprodigy25@gmail.com', 'I want you to insure my properties in port harcourt ', 'contact_msg', '2024-02-12 16:08:49.891362'),
(4, '', 'dan@gmail.comd', 'We are soo glad we got you to come and stay with us in south Africa we will be glad to receive you again.', 'contact_msg', '2024-02-12 16:12:51.361655'),
(5, '', '', '', 'contact_msg', '2024-02-12 20:32:51.067668'),
(6, '', 'Email@server.com', 'encorage those who have been discourage ', 'contact_msg', '2024-02-14 16:54:39.473168'),
(7, '', '', 'it\'s my namde dksjls:\'skdkj\' jskkd\'', 'contact_msg', '2024-02-26 14:38:55.471437');

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `ID` int(100) NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `newsletter`
--

INSERT INTO `newsletter` (`ID`, `email`) VALUES
(1, 'franklinprodigy25@gmail.com'),
(2, 'dan@gmail.comd');

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `ID` int(100) NOT NULL,
  `4who` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `msg` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `note_status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'not_seen',
  `link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `program`
--

CREATE TABLE `program` (
  `ID` int(100) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `traf_start`
--

CREATE TABLE `traf_start` (
  `ID` int(100) NOT NULL,
  `page` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `src` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `total` varchar(100) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `traf_start`
--

INSERT INTO `traf_start` (`ID`, `page`, `src`, `total`) VALUES
(4, 'index.php', '', '1'),
(5, 'index.php', '', '2'),
(6, 'index.php', '', '2'),
(7, 'index.php', '', '2'),
(8, 'index.php', '', '2'),
(9, 'index.php', '', '2'),
(10, 'index.php', '', '2'),
(11, 'index.php', '', '2'),
(12, 'index.php', '', '2'),
(13, 'index.php', '', '2'),
(14, 'index.php', '', '2'),
(15, 'index.php', '', '2'),
(16, 'index.php', '', '2'),
(17, 'index.php', '', '2'),
(18, 'index.php', '', '2'),
(19, 'index.php', '', '2'),
(20, 'index.php', '', '2'),
(21, 'index.php', '', '2'),
(22, 'index.php', '', '2'),
(23, 'index.php', '', '2'),
(24, 'index.php', '', '2'),
(25, 'index.php', '', '2'),
(26, 'index.php', '', '2'),
(27, 'index.php', '', '2'),
(28, 'index.php', '', '2'),
(29, 'index.php', '', '2'),
(30, 'index.php', '', '2'),
(31, 'index.php', '', '2'),
(32, 'index.php', '', '2'),
(33, 'index.php', '', '2'),
(34, 'index.php', '', '2'),
(35, 'index.php', '', '2'),
(36, 'index.php', '', '2'),
(37, 'index.php', '', '2'),
(38, 'index.php', '', '2'),
(39, 'index.php', '', '2'),
(40, 'index.php', '', '2'),
(41, 'index.php', '', '2');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `ID` int(100) NOT NULL,
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `amount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `trans_type` varchar(100) DEFAULT NULL,
  `trans_status` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `newsletter`
--
ALTER TABLE `newsletter`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `notes`
--
ALTER TABLE `notes`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `program`
--
ALTER TABLE `program`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `traf_start`
--
ALTER TABLE `traf_start`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `newsletter`
--
ALTER TABLE `newsletter`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `program`
--
ALTER TABLE `program`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `traf_start`
--
ALTER TABLE `traf_start`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
COMMIT;

