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

START TRANSACTION;



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

--
-- Table structure for table `affiliates`
--

CREATE TABLE `affiliates` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slogan` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `approve` varchar(255) NOT NULL,
  `decline` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `affiliates`
--

INSERT INTO `affiliates` (`id`, `title`, `slogan`, `link`, `approve`, `decline`, `image`, `timestamp`) VALUES
(1, 'Custom Assist Inc.', 'Branding & Marketing', 'customassistinc.com', '1', '2', 'Custom Assist Icon.png', '2023-07-15 14:05:47'),
(2, 'Custom Webs', 'A Custom Assist Corporation', 'webs.customassistinc.com', '1', '2', 'webs.jpg', '2022-11-11 02:27:09'),
(3, 'Custom Assist Monitor', 'Work In Progress', 'monitor.customassistinc.com', '', '', 'monitor.gif', '2022-11-11 01:03:07'),
(4, 'C.A.G.E', 'Custom Assist Games & Entertainment', 'games.customassistinc.com', '1', '2', 'cage.png', '2023-07-15 14:32:27'),
(5, 'MOBI', 'Online Ticketing', 'mobi.customassistinc.com', '1', '2', 'MOBI.png', '2023-07-15 14:15:53');

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

--
-- Table structure for table `web_clients`
--

CREATE TABLE `web_clients` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slogan` varchar(255) NOT NULL,
  `progress` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `instagram` varchar(255) NOT NULL,
  `linkedin` varchar(255) NOT NULL,
  `whatsapp` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `fee` varchar(255) NOT NULL,
  `approve` varchar(255) NOT NULL,
  `decline` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `web_clients`
--

INSERT INTO `web_clients` (`id`, `title`, `slogan`, `progress`, `action`, `link`, `facebook`, `twitter`, `instagram`, `linkedin`, `whatsapp`, `image`, `start_date`, `end_date`, `fee`, `approve`, `decline`, `timestamp`) VALUES
(1, 'Trustnet Investments', '', '100', '2', 'trustnet', '', '', '', '', '', 'trustnet1.png', '2021-02-07', '2021-03-07', '350000', '1', '2', '2022-11-07 09:04:53'),
(2, 'Maryl House', 'Wines & Liqor', '90', '1', 'marylhouse', '', '', '', '', '', 'maryl.png', '0000-00-00', '0000-00-00', '750000', '1', '2', '2022-11-07 09:18:06'),
(3, 'Pilau City', '', '70', '3', 'pilau', '', '', '', '', '', 'pilau.png', '0000-00-00', '0000-00-00', '850000', '1', '2', '2022-11-07 09:19:28'),
(4, 'Nina Interiors', '', '20', '1', 'nina', '', '', '', '', '', 'nina3.png', '0000-00-00', '0000-00-00', '5000000', '1', '2', '2022-11-07 09:24:41'),
(5, 'Hotel 49', '', '35', '3', 'hotel49', '', '', '', '', '', '49.png', '0000-00-00', '0000-00-00', '750000', '1', '2', '2022-11-07 09:27:20'),
(6, 'Kerris Kid Care', '', '100', '2', 'kerris', '', '', '', '', '', 'kerris.png', '0000-00-00', '0000-00-00', '550000', '1', '2', '2023-07-15 13:20:31'),
(7, 'Vian Medical center', 'A service full of life', '100', '2', 'vian', '', '', '', '', '', 'vian.png', '0000-00-00', '0000-00-00', '450000', '1', '2', '2022-11-07 09:32:50'),
(8, '45 Degrees', '', '100', '2', '45degrees', '', '', '', '', '', '45.png', '0000-00-00', '0000-00-00', '300000', '1', '2', '2022-11-07 09:34:14'),
(9, 'Youth Times', '', '5', '4', 'youthtimes', '', '', '', '', '', 'youth.png', '0000-00-00', '0000-00-00', '5000000', '1', '2', '2022-11-07 09:37:02'),
(10, 'Media Age PR', 'Corporate & Brand Reputation Management', '100', '2', 'mediage', '', '', '', '', '', 'mediage.png', '0000-00-00', '0000-00-00', '850000', '1', '2', '2023-07-15 13:17:49'),
(11, 'Scoris International Junior School', '', '100', '2', 'scoris', '', '', '', '', '', 'scoris.png', '0000-00-00', '0000-00-00', '1200000', '1', '2', '2023-07-15 13:18:15'),
(12, 'Heshima Creatives', '', '100', '2', 'heshima', '', '', '', '', '', 'heshima.png', '0000-00-00', '0000-00-00', '250000', '1', '2', '2022-11-07 09:42:51'),
(13, 'Irungi Kitchen', 'Fresh Natural Goodness', '100', '2', 'Irungi', '', '', '', '', '', 'irungi-potrait-1.png', '2023-06-15', '2023-07-15', '750000', '', '', '2023-07-15 13:47:39');

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

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

--
-- AUTO_INCREMENT for table `affiliates`
--
ALTER TABLE `affiliates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `web_clients`
--
ALTER TABLE `web_clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

