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

START TRANSACTION;



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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(255) NOT NULL,
  `title` varchar(300) NOT NULL,
  `slug` varchar(300) NOT NULL,
  `candidate_to_vote` int(11) NOT NULL,
  `candidate_to_vote_max` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_to_start` varchar(55) NOT NULL,
  `date_to_end` varchar(55) NOT NULL,
  `end` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `title`, `slug`, `candidate_to_vote`, `candidate_to_vote_max`, `date_added`, `date_to_start`, `date_to_end`, `end`) VALUES
(10, 'The President', '332846205550', 1, 1, '2021-07-07 04:12:23', '2021-07-11 17:00:00', '2021-07-13 16:24:00', 0),
(11, 'The Vice President', '132541595397', 1, 1, '2021-07-07 04:13:42', '2021-07-14 16:30:00', '2021-07-14 18:00:00', 0),
(13, 'The Secretary', '168578953933', 1, 1, '2021-07-07 04:15:46', '2021-07-14 16:30:00', '2021-07-14 18:00:00', 0),
(14, 'The Treasurer', '181169059205', 1, 1, '2021-07-08 14:37:43', '2021-07-11 17:20:00', '2021-07-13 18:24:00', 0),
(15, 'The Membership', '288630234855', 1, 1, '2021-07-08 14:38:31', '2021-07-14 17:30:00', '2021-07-14 18:00:00', 0),
(16, 'Vice President 2', '830363875133', 1, 1, '2021-07-14 17:39:40', '2021-07-14 17:20:00', '2021-07-14 18:00:00', 0);

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

--
-- Table structure for table `sms_logs`
--

CREATE TABLE `sms_logs` (
  `id` int(11) NOT NULL,
  `mobile_number` varchar(50) DEFAULT NULL,
  `message` text,
  `status` int(11) DEFAULT NULL,
  `date_added` varchar(45) DEFAULT NULL,
  `visible` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sms_logs`
--

INSERT INTO `sms_logs` (`id`, `mobile_number`, `message`, `status`, `date_added`, `visible`) VALUES
(1, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-04 21:42:12', 1),
(2, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-04 22:01:09', 1),
(3, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 00:59:30', 1),
(4, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 01:34:42', 1),
(5, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 03:32:51', 1),
(6, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 03:39:08', 1),
(7, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 04:15:11', 1),
(8, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 09:28:54', 1),
(9, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 09:31:28', 1),
(10, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 09:32:55', 1),
(11, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 12:07:04', 1),
(12, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 12:08:17', 1),
(13, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 13:30:12', 1),
(14, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 13:56:06', 1),
(15, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 13:58:15', 1),
(16, '97337399933', 'Access Code Successfully Sent', 1, '2021-07-05 13:59:57', 1),
(17, '97337399933', 'Voted Successfully', 1, '2021-07-05 14:26:49', 1),
(18, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 15:15:27', 1),
(19, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 15:16:23', 1),
(20, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 15:17:11', 1),
(21, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 15:57:46', 1),
(22, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-05 21:40:17', 1),
(23, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-05 22:55:41', 1),
(24, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-06 09:12:06', 1),
(25, '97339468080', 'Access Code Successfully Sent', 1, '2021-07-06 09:52:19', 1),
(26, '97336006611', 'Access Code Successfully Sent', 1, '2021-07-06 10:23:52', 1),
(27, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-06 12:28:42', 1),
(28, '97339424337', 'Access Code Successfully Sent', 1, '2021-07-06 12:45:27', 1),
(29, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-06 14:51:53', 1),
(30, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-06 15:14:00', 1),
(31, '97336664764', 'Access Code Successfully Sent', 1, '2021-07-06 15:20:02', 1),
(32, '97366302020', 'Access Code Successfully Sent', 1, '2021-07-06 15:37:38', 1),
(33, '97339622155', 'Access Code Successfully Sent', 1, '2021-07-06 15:42:58', 1),
(34, '97339696769', 'Access Code Successfully Sent', 1, '2021-07-06 15:47:30', 1),
(35, '97339528050', 'Access Code Successfully Sent', 1, '2021-07-06 16:03:35', 1),
(36, '97339617575', 'Access Code Successfully Sent', 1, '2021-07-06 16:10:18', 1),
(37, '97334018558', 'Access Code Successfully Sent', 1, '2021-07-06 16:16:25', 1),
(38, '97339622155', 'Access Code Successfully Sent', 1, '2021-07-06 16:19:02', 1),
(39, '97339601818', 'Access Code Successfully Sent', 1, '2021-07-06 16:20:31', 1),
(40, '97339619000', 'Access Code Successfully Sent', 1, '2021-07-06 16:22:01', 1),
(41, '97339401122', 'Access Code Successfully Sent', 1, '2021-07-06 16:22:34', 1),
(42, '97383298335', 'Access Code Successfully Sent', 1, '2021-07-06 16:23:01', 1),
(43, '97366302020', 'Access Code Successfully Sent', 1, '2021-07-06 16:23:02', 1),
(44, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-06 16:23:29', 1),
(45, '97383298335', 'Access Code Successfully Sent', 1, '2021-07-06 16:24:30', 1),
(46, '97338383322', 'Access Code Successfully Sent', 1, '2021-07-06 16:27:43', 1),
(47, '97338875888', 'Access Code Successfully Sent', 1, '2021-07-06 16:27:45', 1),
(48, '97339468080', 'Access Code Successfully Sent', 1, '2021-07-06 16:28:53', 1),
(49, '97339676999', 'Access Code Successfully Sent', 1, '2021-07-06 16:29:00', 1),
(50, '97336664764', 'Access Code Successfully Sent', 1, '2021-07-06 16:30:39', 1),
(51, '97334314444', 'Access Code Successfully Sent', 1, '2021-07-06 16:31:17', 1),
(52, '97339696769', 'Voted Successfully', 1, '2021-07-06 16:31:43', 1),
(53, '97339399299', 'Access Code Successfully Sent', 1, '2021-07-06 16:32:11', 1),
(54, '97336664764', 'Voted Successfully', 1, '2021-07-06 16:32:12', 1),
(55, '97339939927', 'Access Code Successfully Sent', 1, '2021-07-06 16:33:12', 1),
(56, '97336006611', 'Access Code Successfully Sent', 1, '2021-07-06 16:33:34', 1),
(57, '97339952000', 'Access Code Successfully Sent', 1, '2021-07-06 16:34:03', 1),
(58, '97339401122', 'Voted Successfully', 1, '2021-07-06 16:34:57', 1),
(59, '97336006611', 'Voted Successfully', 1, '2021-07-06 16:35:07', 1),
(60, '97366302020', 'Voted Successfully', 1, '2021-07-06 16:36:51', 1),
(61, '97366622666', 'Access Code Successfully Sent', 1, '2021-07-06 16:43:09', 1),
(62, '97366622666', 'Access Code Successfully Sent', 1, '2021-07-06 16:53:08', 1),
(63, '97366622666', 'Voted Successfully', 1, '2021-07-06 16:55:57', 1),
(64, '97334314444', 'Voted Successfully', 1, '2021-07-06 17:06:14', 1),
(65, '97339300399', 'Access Code Successfully Sent', 1, '2021-07-06 17:08:45', 1),
(66, '97333217799', 'Access Code Successfully Sent', 1, '2021-07-06 17:10:29', 1),
(67, '97339300399', 'Access Code Successfully Sent', 1, '2021-07-06 17:11:22', 1),
(68, '97339651165', 'Access Code Successfully Sent', 1, '2021-07-06 17:11:32', 1),
(69, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-06 17:11:36', 1),
(70, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:01', 1),
(71, '97336924444', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:06', 1),
(72, '97339632020', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:14', 1),
(73, '97339632020', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:16', 1),
(74, '97339632020', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:16', 1),
(75, '97333217799', 'Voted Successfully', 1, '2021-07-06 17:12:22', 1),
(76, '97339528050', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:44', 1),
(77, '97339401122', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:53', 1),
(78, '97339617575', 'Access Code Successfully Sent', 1, '2021-07-06 17:12:53', 1),
(79, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:04', 1),
(80, '97335588838', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:04', 1),
(81, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:13', 1),
(82, '97383298335', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:13', 1),
(83, '97334018558', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:17', 1),
(84, '97339468080', 'Voted Successfully', 1, '2021-07-06 17:13:33', 1),
(85, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:36', 1),
(86, '97383298335', 'Access Code Successfully Sent', 1, '2021-07-06 17:13:39', 1),
(87, '97339953988', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:12', 1),
(88, '97336664764', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:20', 1),
(89, '97339424337', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:29', 1),
(90, '97339610105', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:32', 1),
(91, '97339939927', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:34', 1),
(92, '97338880869', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:47', 1),
(93, '97339527557', 'Access Code Successfully Sent', 1, '2021-07-06 17:14:47', 1),
(94, '97339630997', 'Voted Successfully', 1, '2021-07-06 17:15:03', 1),
(95, '97365552859', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:05', 1),
(96, '97334018558', 'Voted Successfully', 1, '2021-07-06 17:15:29', 1),
(97, '97333611177', 'Voted Successfully', 1, '2021-07-06 17:15:33', 1),
(98, '97338383322', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:33', 1),
(99, '97339528050', 'Voted Successfully', 1, '2021-07-06 17:15:37', 1),
(100, '97339622155', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:48', 1),
(101, '97339617575', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:49', 1),
(102, '97339601818', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:52', 1),
(103, '97339527557', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:55', 1),
(104, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:15:57', 1),
(105, '97339977776', 'Access Code Successfully Sent', 1, '2021-07-06 17:16:08', 1),
(106, '97383298335', 'Voted Successfully', 1, '2021-07-06 17:16:19', 1),
(107, '97339939927', 'Voted Successfully', 1, '2021-07-06 17:16:20', 1),
(108, '97339699337', 'Voted Successfully', 1, '2021-07-06 17:16:23', 1),
(109, '97339952000', 'Access Code Successfully Sent', 1, '2021-07-06 17:16:40', 1),
(110, '97339528050', 'Access Code Successfully Sent', 1, '2021-07-06 17:16:40', 1),
(111, '97336924444', 'Voted Successfully', 1, '2021-07-06 17:16:42', 1),
(112, '97339622155', 'Voted Successfully', 1, '2021-07-06 17:16:52', 1),
(113, '97339610105', 'Voted Successfully', 1, '2021-07-06 17:16:56', 1),
(114, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:17:10', 1),
(115, '97339953988', 'Voted Successfully', 1, '2021-07-06 17:17:11', 1),
(116, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-06 17:17:18', 1),
(117, '97339632020', 'Voted Successfully', 1, '2021-07-06 17:17:21', 1),
(118, '97365552859', 'Access Code Successfully Sent', 1, '2021-07-06 17:17:24', 1),
(119, '97335588838', 'Access Code Successfully Sent', 1, '2021-07-06 17:17:26', 1),
(120, '97339424337', 'Voted Successfully', 1, '2021-07-06 17:17:33', 1),
(121, '97338880869', 'Voted Successfully', 1, '2021-07-06 17:17:36', 1),
(122, '97339617575', 'Voted Successfully', 1, '2021-07-06 17:17:46', 1),
(123, '97339399299', 'Voted Successfully', 1, '2021-07-06 17:17:50', 1),
(124, '97339601818', 'Voted Successfully', 1, '2021-07-06 17:17:53', 1),
(125, '97339977776', 'Access Code Successfully Sent', 1, '2021-07-06 17:18:05', 1),
(126, '97339665521', 'Access Code Successfully Sent', 1, '2021-07-06 17:18:18', 1),
(127, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:18:48', 1),
(128, '97338383322', 'Voted Successfully', 1, '2021-07-06 17:18:55', 1),
(129, '97339300399', 'Voted Successfully', 1, '2021-07-06 17:19:02', 1),
(130, '97365552859', 'Voted Successfully', 1, '2021-07-06 17:19:34', 1),
(131, '97339977776', 'Voted Successfully', 1, '2021-07-06 17:20:00', 1),
(132, '97339665521', 'Voted Successfully', 1, '2021-07-06 17:20:14', 1),
(133, '97339952000', 'Voted Successfully', 1, '2021-07-06 17:21:08', 1),
(134, '97335588838', 'Access Code Successfully Sent', 1, '2021-07-06 17:22:44', 1),
(135, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-06 17:23:57', 1),
(136, '97339669379', 'Voted Successfully', 1, '2021-07-06 17:26:05', 1),
(137, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:27:19', 1),
(138, '97336070909', 'Access Code Successfully Sent', 1, '2021-07-06 17:27:37', 1),
(139, '97336070909', 'Access Code Successfully Sent', 1, '2021-07-06 17:28:52', 1),
(140, '97335588838', 'Access Code Successfully Sent', 1, '2021-07-06 17:29:27', 1),
(141, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:30:13', 1),
(142, '97335588838', 'Access Code Successfully Sent', 1, '2021-07-06 17:30:45', 1),
(143, '97336070909', 'Voted Successfully', 1, '2021-07-06 17:30:47', 1),
(144, '97336044664', 'Access Code Successfully Sent', 1, '2021-07-06 17:31:18', 1),
(145, '97335588838', 'Voted Successfully', 1, '2021-07-06 17:33:05', 1),
(146, '97339651165', 'Access Code Successfully Sent', 1, '2021-07-06 17:38:48', 1),
(147, '97339651165', 'Voted Successfully', 1, '2021-07-06 17:44:40', 1),
(148, '97366393939', 'Access Code Successfully Sent', 1, '2021-07-06 19:17:46', 1),
(149, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-06 20:53:14', 1),
(150, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 04:07:53', 1),
(151, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 04:38:22', 1),
(152, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 05:04:00', 1),
(153, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 05:07:50', 1),
(154, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 05:08:20', 1),
(155, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 05:10:00', 1),
(156, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-07 09:46:11', 1),
(157, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-07 21:24:01', 1),
(158, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-08 14:06:01', 1),
(159, '97335114696', 'Access Code Successfully Sent', 1, '2021-07-08 14:09:22', 1),
(160, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-08 14:09:32', 1),
(161, '97335114696', 'Access Code Successfully Sent', 1, '2021-07-08 14:11:22', 1),
(162, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-08 16:00:43', 1),
(163, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-13 16:39:45', 1),
(164, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-13 17:06:42', 1),
(165, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-13 17:18:31', 1),
(166, '97339999366', 'Voted Successfully', 1, '2021-07-13 17:19:13', 1),
(167, '97339999366', 'Voted Successfully', 1, '2021-07-13 17:19:28', 1),
(168, '97337399933', 'Access Code Successfully Sent', 1, '2021-07-13 17:43:51', 1),
(169, '97337399933', 'Voted Successfully', 1, '2021-07-13 17:45:05', 1),
(170, '97337399933', 'Voted Successfully', 1, '2021-07-13 17:45:24', 1),
(171, '97335114696', 'Access Code Successfully Sent', 1, '2021-07-13 18:45:02', 1),
(172, '97335114696', 'Access Code Successfully Sent', 1, '2021-07-13 19:40:36', 1),
(173, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-14 05:31:53', 1),
(174, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-14 08:47:24', 1),
(175, '97333070044', 'Access Code Successfully Sent', 1, '2021-07-14 12:35:10', 1),
(176, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-14 16:32:37', 1),
(177, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-14 16:51:42', 1),
(178, '97336664764', 'Access Code Successfully Sent', 1, '2021-07-14 17:18:48', 1),
(179, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:18:49', 1),
(180, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:19:11', 1),
(181, '97338875888', 'Access Code Successfully Sent', 1, '2021-07-14 17:19:22', 1),
(182, '97336584499', 'Access Code Successfully Sent', 1, '2021-07-14 17:19:26', 1),
(183, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:19:29', 1),
(184, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:19:30', 1),
(185, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:20:02', 1),
(186, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:20:11', 1),
(187, '97336664764', 'Voted Successfully', 1, '2021-07-14 17:20:19', 1),
(188, '97338875888', 'Voted Successfully', 1, '2021-07-14 17:20:20', 1),
(189, '97339669379', 'Voted Successfully', 1, '2021-07-14 17:20:49', 1),
(190, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:00', 1),
(191, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:26', 1),
(192, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:29', 1),
(193, '97336664764', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:35', 1),
(194, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:42', 1),
(195, '97338875888', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:44', 1),
(196, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:45', 1),
(197, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:53', 1),
(198, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:21:55', 1),
(199, '97339669379', 'Voted Successfully', 1, '2021-07-14 17:22:07', 1),
(200, '97336664764', 'Voted Successfully', 1, '2021-07-14 17:22:14', 1),
(201, '97336584499', 'Voted Successfully', 1, '2021-07-14 17:22:14', 1),
(202, '97339630997', 'Voted Successfully', 1, '2021-07-14 17:22:21', 1),
(203, '97333611177', 'Voted Successfully', 1, '2021-07-14 17:22:25', 1),
(204, '97339699337', 'Voted Successfully', 1, '2021-07-14 17:22:38', 1),
(205, '97336584499', 'Voted Successfully', 1, '2021-07-14 17:22:43', 1),
(206, '97339630997', 'Voted Successfully', 1, '2021-07-14 17:22:43', 1),
(207, '97338875888', 'Access Code Successfully Sent', 1, '2021-07-14 17:22:48', 1),
(208, '97338875888', 'Access Code Successfully Sent', 1, '2021-07-14 17:22:49', 1),
(209, '97339699337', 'Voted Successfully', 1, '2021-07-14 17:23:01', 1),
(210, '97338875888', 'Voted Successfully', 1, '2021-07-14 17:23:24', 1),
(211, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:23:35', 1),
(212, '97333611177', 'Voted Successfully', 1, '2021-07-14 17:24:09', 1),
(213, '97339468080', 'Access Code Successfully Sent', 1, '2021-07-14 17:25:03', 1),
(214, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:25:08', 1),
(215, '97339468080', 'Voted Successfully', 1, '2021-07-14 17:25:50', 1),
(216, '97339468080', 'Voted Successfully', 1, '2021-07-14 17:26:08', 1),
(217, '97339610105', 'Access Code Successfully Sent', 1, '2021-07-14 17:28:09', 1),
(218, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:30:09', 1),
(219, '97339610105', 'Access Code Successfully Sent', 1, '2021-07-14 17:31:03', 1),
(220, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:31:04', 1),
(221, '97333611177', 'Voted Successfully', 1, '2021-07-14 17:31:44', 1),
(222, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:32:35', 1),
(223, '97339610105', 'Voted Successfully', 1, '2021-07-14 17:32:53', 1),
(224, '97339610105', 'Voted Successfully', 1, '2021-07-14 17:34:09', 1),
(225, '97339610105', 'Voted Successfully', 1, '2021-07-14 17:34:29', 1),
(226, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:44:51', 1),
(227, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:44:59', 1),
(228, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:45:00', 1),
(229, '97338875888', 'Access Code Successfully Sent', 1, '2021-07-14 17:45:01', 1),
(230, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-14 17:45:04', 1),
(231, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-14 17:45:51', 1),
(232, '97339468080', 'Voted Successfully', 1, '2021-07-14 17:46:21', 1),
(233, '97338875888', 'Voted Successfully', 1, '2021-07-14 17:46:21', 1),
(234, '97333611177', 'Voted Successfully', 1, '2021-07-14 17:46:25', 1),
(235, '97336664764', 'Access Code Successfully Sent', 1, '2021-07-14 17:46:32', 1),
(236, '97339669379', 'Access Code Successfully Sent', 1, '2021-07-14 17:46:43', 1),
(237, '97339630997', 'Access Code Successfully Sent', 1, '2021-07-14 17:46:49', 1),
(238, '97339610105', 'Access Code Successfully Sent', 1, '2021-07-14 17:46:50', 1),
(239, '97336584499', 'Access Code Successfully Sent', 1, '2021-07-14 17:47:02', 1),
(240, '97339699337', 'Access Code Successfully Sent', 1, '2021-07-14 17:47:03', 1),
(241, '97336664764', 'Voted Successfully', 1, '2021-07-14 17:47:04', 1),
(242, '97339669379', 'Voted Successfully', 1, '2021-07-14 17:47:14', 1),
(243, '97339630997', 'Voted Successfully', 1, '2021-07-14 17:47:18', 1),
(244, '97339699337', 'Voted Successfully', 1, '2021-07-14 17:47:30', 1),
(245, '97339630997', 'Voted Successfully', 1, '2021-07-14 17:47:38', 1),
(246, '97336584499', 'Voted Successfully', 1, '2021-07-14 17:47:55', 1),
(247, '97339610105', 'Access Code Successfully Sent', 1, '2021-07-14 17:49:44', 1),
(248, '97333611177', 'Access Code Successfully Sent', 1, '2021-07-14 17:49:54', 1),
(249, '97339610105', 'Voted Successfully', 1, '2021-07-14 17:51:11', 1),
(250, '97334314444', 'Access Code Successfully Sent', 1, '2021-07-14 18:06:06', 1),
(251, '97334314444', 'Access Code Successfully Sent', 1, '2021-07-14 18:06:07', 1),
(252, '97339999366', 'Access Code Successfully Sent', 1, '2021-07-16 04:35:26', 1);

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

--
-- Table structure for table `start`
--

CREATE TABLE `start` (
  `id` int(255) NOT NULL,
  `title` varchar(300) NOT NULL,
  `date_to_start` varchar(100) NOT NULL,
  `date_to_end` varchar(100) NOT NULL,
  `en_date_to_start` varchar(55) NOT NULL,
  `en_date_to_end` varchar(55) NOT NULL,
  `description` mediumtext NOT NULL,
  `end` tinyint(4) NOT NULL,
  `date_ended` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `start`
--

INSERT INTO `start` (`id`, `title`, `date_to_start`, `date_to_end`, `en_date_to_start`, `en_date_to_end`, `description`, `end`, `date_ended`) VALUES
(12, 'American Chamber of Commerce Board Officer Elections 2021 - 2023', '2021-07-14 16:30:00', '2021-07-14 18:30:00', '2021-07-14 16:30:00', '2021-07-14 18:30:00', 'American Chamber of Commerce in Bahrain (AmCham) Board Officer Elections', 0, '0000-00-00');

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

--
-- Table structure for table `theme`
--

CREATE TABLE `theme` (
  `id` int(255) NOT NULL,
  `name` varchar(300) NOT NULL,
  `title` varchar(300) NOT NULL,
  `sub_title` varchar(300) NOT NULL,
  `bg_image_one` varchar(300) NOT NULL,
  `bg_image_two` varchar(300) NOT NULL,
  `hero_image_one` varchar(300) NOT NULL,
  `hero_link_one` varchar(300) NOT NULL,
  `hero_image_two` varchar(300) NOT NULL,
  `hero_link_two` varchar(300) NOT NULL,
  `login_image` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `theme`
--

INSERT INTO `theme` (`id`, `name`, `title`, `sub_title`, `bg_image_one`, `bg_image_two`, `hero_image_one`, `hero_link_one`, `hero_image_two`, `hero_link_two`, `login_image`) VALUES
(1, 'boxvote', 'Build an Outstanding Digital Marketplace', 'Build a Great Business with our Wordpress Themes, Bootstrap Themes & PHP Scripts + Our other Services.', 'ajuccauzKM8xJD.jpg', 'N4gxm3K4LCrCdL.jpg', '8dD0jOiKcLgNA0.jpg', 'http://localhost/projects/codefir/digital/product/186219922775/fluffs-ultimate-bootstrap-social-network-ui-kit', 'ooR7TS5rDMeCeW.png', 'http://localhost/projects/codefir/digital/product/186219922775/fluffs-ultimate-bootstrap-social-network-ui-kit', '');

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

--
-- Table structure for table `votes`
--

CREATE TABLE `votes` (
  `id` int(255) NOT NULL,
  `userid` varchar(300) NOT NULL,
  `candidate` int(50) NOT NULL,
  `category_id` int(50) NOT NULL,
  `date_voted` varchar(55) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `votes`
--

INSERT INTO `votes` (`id`, `userid`, `candidate`, `category_id`, `date_voted`) VALUES
(1, '203205574647', 352, 10, '2021-07-13 17:45:05'),
(2, '203205574647', 359, 14, '2021-07-13 17:45:23'),
(3, '233507218918', 348, 13, '2021-07-14 17:20:18'),
(4, '337155466796', 414, 13, '2021-07-14 17:20:20'),
(5, '296043350094', 348, 13, '2021-07-14 17:20:49'),
(6, '296043350094', 358, 11, '2021-07-14 17:22:07'),
(7, '233507218918', 349, 11, '2021-07-14 17:22:14'),
(8, '313084214781', 358, 11, '2021-07-14 17:22:14'),
(9, '135506824410', 362, 11, '2021-07-14 17:22:20'),
(10, '139754069782', 358, 11, '2021-07-14 17:22:25'),
(11, '104139949429', 348, 13, '2021-07-14 17:22:38'),
(12, '135506824410', 348, 13, '2021-07-14 17:22:42'),
(13, '313084214781', 414, 13, '2021-07-14 17:22:42'),
(14, '104139949429', 362, 11, '2021-07-14 17:23:01'),
(15, '337155466796', 358, 11, '2021-07-14 17:23:24'),
(16, '139754069782', 348, 13, '2021-07-14 17:24:09'),
(17, '228734520185', 362, 11, '2021-07-14 17:25:50'),
(18, '228734520185', 348, 13, '2021-07-14 17:26:08'),
(19, '139754069782', 357, 15, '2021-07-14 17:31:44'),
(20, '727681406058', 357, 15, '2021-07-14 17:32:53'),
(21, '727681406058', 362, 11, '2021-07-14 17:34:08'),
(22, '727681406058', 414, 13, '2021-07-14 17:34:29'),
(23, '228734520185', 419, 16, '2021-07-14 17:46:21'),
(24, '337155466796', 418, 16, '2021-07-14 17:46:21'),
(25, '139754069782', 418, 16, '2021-07-14 17:46:25'),
(26, '233507218918', 419, 16, '2021-07-14 17:47:04'),
(27, '296043350094', 418, 16, '2021-07-14 17:47:14'),
(28, '135506824410', 419, 16, '2021-07-14 17:47:17'),
(29, '104139949429', 419, 16, '2021-07-14 17:47:30'),
(30, '135506824410', 357, 15, '2021-07-14 17:47:38'),
(31, '313084214781', 418, 16, '2021-07-14 17:47:55'),
(32, '727681406058', 419, 16, '2021-07-14 17:51:11');

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

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

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

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

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `start`
--
ALTER TABLE `start`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `theme`
--
ALTER TABLE `theme`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `votes`
--
ALTER TABLE `votes`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
COMMIT;

