-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 05, 2024 at 06:18 PM
-- 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: `mediage`
--

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `title`, `link`, `image`, `time`) VALUES
(1, 'Sanlam', '#!', '1.png', '2024-01-05 16:35:09'),
(2, 'Centum', '#!', '2.png', '2024-01-05 16:35:09'),
(3, 'GSK GlaxoSmithKline', '#!', '3.png', '2024-01-05 16:35:09'),
(4, 'Coca Cola', '#!', '4.png', '2024-01-05 17:06:05'),
(5, 'Tuskys', '#!', '5.png', '2024-01-05 16:35:09'),
(6, 'Nakumatt', '#!', '6.png', '2024-01-05 16:35:09'),
(7, 'Britam', '#!', '7.png', '2024-01-05 16:35:09'),
(8, 'MUA', '#!', '8.png', '2024-01-05 16:35:09'),
(9, 'AON', '#!', '9.png', '2024-01-05 16:35:09'),
(10, 'Jambojet', '#!', '10.png', '2024-01-05 16:35:09'),
(11, 'DTB', '#!', '11.png', '2024-01-05 16:35:09'),
(12, 'G4S', '#!', '12.png', '2024-01-05 16:35:09'),
(13, 'ICEA Lion', '#!', '13.png', '2024-01-05 16:35:09'),
(14, 'KCB', '#!', '14.png', '2024-01-05 16:35:09'),
(15, 'Bamburi Rugby', '#!', '15.png', '2024-01-05 16:35:09'),
(16, 'Mukwano', '#!', '16.png', '2024-01-05 16:35:09'),
(17, 'Hima', '#!', '17.png', '2024-01-05 16:35:09'),
(18, 'AAR Insurance', '#!', '18.png', '2024-01-05 16:35:09'),
(19, 'Chartis', '#!', '19.png', '2024-01-05 16:35:09'),
(20, 'Zuku', '#!', '20.png', '2024-01-05 16:35:09'),
(21, 'MTN Uganda', '#!', '21.png', '2024-01-05 16:35:09'),
(22, 'UAP', '#!', '22.png', '2024-01-05 16:35:09'),
(23, 'Ariel', '#!', '23.png', '2024-01-05 16:35:09'),
(24, 'Bell', '#!', '24.png', '2024-01-05 16:35:09'),
(25, 'Procter & Gamble', '#!', '25.png', '2024-01-05 16:35:09'),
(26, 'Tusker Project Fame', '#!', '26.png', '2024-01-05 16:35:09'),
(27, 'eabl Foundation', '#!', '27.png', '2024-01-05 16:35:09'),
(28, 'Actionaid', '#!', '28.png', '2024-01-05 16:35:09'),
(29, 'AFCOA', '#!', '29.png', '2024-01-05 16:35:09'),
(30, 'ASARECA', '#!', '30.png', '2024-01-05 16:35:09'),
(31, 'Ministry Of Trade', '#!', '31.png', '2024-01-05 16:35:09'),
(32, 'Ministry Of Finance', '#!', '32.png', '2024-01-05 16:35:09'),
(33, 'Uganda Breweries', '#!', '33.png', '2024-01-05 16:35:09'),
(34, 'CMC Motors', '#!', '34.png', '2024-01-05 16:35:09'),
(35, 'Rift Valley Railways', '#!', '35.png', '2024-01-05 16:35:09'),
(36, 'Emirates', '#!', '36.png', '2024-01-05 16:35:09'),
(37, 'AIG', '#!', '37.png', '2024-01-05 16:35:09'),
(38, 'Western Union', '#!', '38.png', '2024-01-05 16:35:09'),
(39, 'Equity Bank', '#!', '39.png', '2024-01-05 16:35:09'),
(40, 'Actis', '#!', '40.png', '2024-01-05 16:35:09'),
(41, 'Barclays', '#!', '41.png', '2024-01-05 16:35:09'),
(42, 'AGGREY & CLIFFORD', 'https://aggreyclifford.com', '42.png', '2024-01-05 17:06:24');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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