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

START TRANSACTION;



--
-- Database: `ebahrain_vote`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(255) NOT NULL,
  `adminid` varchar(300) NOT NULL,
  `username` varchar(300) NOT NULL,
  `password` varchar(300) NOT NULL,
  `name` varchar(300) NOT NULL,
  `email` text NOT NULL,
  `imagelocation` text NOT NULL,
  `tokencode` text NOT NULL,
  `joined` datetime NOT NULL,
  `user_type` int(11) NOT NULL,
  `mobile` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `adminid`, `username`, `password`, `name`, `email`, `imagelocation`, `tokencode`, `joined`, `user_type`, `mobile`) VALUES
(3, '1111111111', 'SysAdmin', '$2y$10$oPaNFJ8eXd5.7oIU2lq1gelpHl1dUzSHPoFTJPtsrgTzKeA9Zz2rq', 'System Administrator', 'mutaz.alhami@gmail.com', '', '', '2021-03-09 09:52:48', 99, 39999366),
(6, '197012357278', 'mutaz@alhami.com', '$2y$10$dAl.3gAIP8n4XVS5dKclFOMlXI6ug2EPvlmx9cgqhe0.2saJZVyfq', 'almutaz alhami', 'mutaz@alhami.com', '', '', '2021-04-24 16:34:41', 1, 39999366),
(7, '485202446818', 'reem@amchambahrain.org', '$2y$10$EdN6SXaFIPPOW2OvCbMMwu88GdTPFkBHMWX/hibUXTO.JR7Icwivy', 'AmCham Admin', 'reem@amchambahrain.org', '', '', '2021-05-25 16:43:16', 1, 33070044),
(8, '344814097747', 'name@name.na', '$2y$10$wuPpEafFF5UTdUEKi6X7wepZXOceoINtRQ52IjuNJrMfcySsX0PlK', 'n', 'name@name.na', '', '', '2021-06-02 21:41:39', 1, 39999366);

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

--
-- 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 `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `language` varchar(50) NOT NULL,
  `theme` varchar(50) NOT NULL,
  `sitename` varchar(300) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `analytics` longtext NOT NULL,
  `timezone` varchar(300) NOT NULL,
  `logo` varchar(300) NOT NULL,
  `favicon` varchar(300) NOT NULL,
  `contact_email` varchar(300) NOT NULL,
  `contact_phone` varchar(300) NOT NULL,
  `contact_location` varchar(300) NOT NULL,
  `smtp_host` varchar(300) NOT NULL,
  `smtp_username` varchar(300) NOT NULL,
  `smtp_password` varchar(300) NOT NULL,
  `smtp_encryption` varchar(300) NOT NULL,
  `smtp_port` varchar(300) NOT NULL,
  `home_bg` varchar(300) NOT NULL,
  `login_bg` varchar(300) NOT NULL,
  `hero_bg` varchar(300) NOT NULL,
  `show_votes` tinyint(4) NOT NULL,
  `instruction` text NOT NULL,
  `sms_key` varchar(155) NOT NULL,
  `sms_from` varchar(155) NOT NULL,
  `sms_country_code` int(5) NOT NULL,
  `allow_voter_reg` int(11) NOT NULL,
  `allow_cand_reg` int(11) NOT NULL,
  `sms_char_limit` int(11) NOT NULL,
  `cpr_char_limit` int(11) NOT NULL,
  `allow_email_reg` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `language`, `theme`, `sitename`, `title`, `description`, `keywords`, `analytics`, `timezone`, `logo`, `favicon`, `contact_email`, `contact_phone`, `contact_location`, `smtp_host`, `smtp_username`, `smtp_password`, `smtp_encryption`, `smtp_port`, `home_bg`, `login_bg`, `hero_bg`, `show_votes`, `instruction`, `sms_key`, `sms_from`, `sms_country_code`, `allow_voter_reg`, `allow_cand_reg`, `sms_char_limit`, `cpr_char_limit`, `allow_email_reg`) VALUES
(1, 'english', 'boxvote', 'AmCham', 'American Chamber of Commerce Elections', 'American Chamber of Commerce Elections', 'American Chamber of Commerce Elections', 'UA-79656468-7', 'Asia/Bahrain', 'jcfqIR0nzBafbX.png', 'cATd00k3IOf2XW.gif', 'themashabrand@gmail.com', '+4433556677', 'United States', 'smtp.hami.net', 'hami@hami.net', 'Whay007h+', 'tls', '587', 'ZNjbIxY4WIztL4.jpg', 'uNVBaI6lBfjNNv.jpg', 'nbOXIuplzo2yh5.jpg', 0, '    <h1><div class=\"el__leafmedia el__leafmedia--sourced-paragraph\"></div></h1><h1></h1>   ', 'iSZIKyblgRCwy3s7tFAj1FtQ9', 'AmCham', 973, 0, 0, 8, 9, 1);

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

--
-- 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 `user`
--

CREATE TABLE `user` (
  `id` int(255) NOT NULL,
  `userid` varchar(300) NOT NULL,
  `password` varchar(300) NOT NULL,
  `name` varchar(300) NOT NULL,
  `email` text NOT NULL,
  `imagelocation` text NOT NULL,
  `tokencode` text NOT NULL,
  `joined` datetime NOT NULL,
  `user_type` int(11) NOT NULL,
  `registercode` varchar(300) NOT NULL,
  `verified` tinyint(4) NOT NULL,
  `approved` tinyint(4) NOT NULL,
  `tag_line` varchar(300) NOT NULL,
  `category_id` varchar(300) NOT NULL,
  `background` longtext NOT NULL,
  `education` longtext NOT NULL,
  `career` longtext NOT NULL,
  `cpr` varchar(300) NOT NULL,
  `mobile` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `userid`, `password`, `name`, `email`, `imagelocation`, `tokencode`, `joined`, `user_type`, `registercode`, `verified`, `approved`, `tag_line`, `category_id`, `background`, `education`, `career`, `cpr`, `mobile`) VALUES
(348, '199753942157', '$2y$10$/4KFi3OaqqRX.W27GVhUTu/Ds2tHO2s25d6tDZljNElrn3hVzGR5G', 'Zahraa Taher', '14@ebahrain.live', '21.07.04.19.57-1625417837.7656-56167123.png', '', '2021-07-04 19:57:17', 2, '', 0, 1, 'Candidate ', '13', '<p>Zahraa	is	a	communications	and	events	strategist	focused	on	providing	FinMark’s	clients	with	high-level	\r\ncounsel	and	the	development	and	execution	of	marketing	and	communications	strategies,	campaigns and	\r\nevents.	She	has	more	than	20	years	of	experience	working	in	the	GCC	financial	services	industry	and	in	\r\nregional	communications	and	events	management.</p><p>	\r\nZahraa	is	a	native	of	the	GCC	region	and	an	Arab	speaker	giving	her	strong	insight	and	the	ability	to	add	\r\nvalue	to	her	clients’	efforts	to	navigate	the	Arab	media	and	business	and	investor	culture.	\r\nShe	began	her	career	in	the	insurance	sector	at	the	region’s	largest	insurer,	Arab	Insurance	Group	(ARIG)	\r\nafter	which	she	established	a	 full	service	events	agency	in	Bahrain,	EVENTSCOM,	where	 for	more	than	\r\nseven	 years	 she	 provided	 strategic	 marketing,	 communications	 and	 events	 support	 to	 numerous	\r\ngovernment	 bodies,	 regional	 companies	 and	 international	 firms	 seeking	 to	enhance	 their	 profiles	 and	\r\nmarket	positions	in	the	GCC.\r\n</p><p>Zahraa	 is	 very	 active	 with	 non-profit	 and	 professional	 organizations	 and	 has	 an	 extensive	 network	\r\nbenefiting	 her	 clients	 and	 supporting	 partnership	 building.	 She	 is	 among	 the	 Founders	 and	 a	 Board	\r\nMember	of	the	Bahrain	International	Federation of	Business	&amp;	Professional	Women	(BPW)	as	well	as	a	\r\nmember	of	the	Board	of	the	American	Chamber	of	Commerce	(AmCham),	Bahrain	and	a	senior	Committee	\r\nMember	at	the	BCCI	for	events	and	tourism.</p><p>Click here for Candidate video:&nbsp;https://amchambahrain-my.sharepoint.com/:v:/g/personal/reem_amchambahrain_org/EVwFkuYk3nFIj-iQgi2YyrgB8FnvwUAcGgorGpz5aak-xw?e=6sllmN&nbsp;</p>', '', '', '140000000', '14000000'),
(349, '353390735594', '$2y$10$xAhakOigfAKrZuL3drchJeu7ay5M3S8EHdBauOjYeJtNNpopLn5V.', 'Roger Blackall', '13@ebahrain.live', '21.07.04.20.07-1625418471.3543-34804099.png', '', '2021-07-04 20:07:51', 2, '', 0, 1, 'Candidate ', '11', '<p>Executive Director,&nbsp;<span style=\"background-color: transparent;\"><b>Investments\r\nPremier Group, W.L.L</b>., Manama, Bahrain\r\n</span></p><p><span style=\"background-color: transparent;\">Mr. Blackall is a current Board Member of the American Chamber of Commerce Board, serving\r\nsince 2017. Mr. Blackall joined Premier Group, W.L.L.in Bahrain, in 2008 where he is\r\nresponsible for the oversight of all real estate investment and asset management activities. Prior\r\nto Premier Group, he spent five years at Kingdom Hotel Investments as Senior Vice President\r\nAsset Management, based in Riyadh, Saudi Arabia and Dubai, UAE. Mr. Blackall has also held\r\nleadership positions at Shimizu Corporation of Japan, Four Seasons Hotels and Resorts, Marriott\r\nInternational and the Walt Disney Company. Mr. Blackall holds a Bachelor of Science degree\r\nfrom the Cornell University School of Hotel Administration and also attended graduate-level real\r\nestate classes at the American University in Washington, D.C.&nbsp;</span><br></p>', '', '', '130000000', '13000000'),
(350, '144597821782', '$2y$10$BGgL5QuKAh5kPhMiVOnZs.FYveJCFO8XaxMNRP/Tk/WG9zTn9Ld0W', 'almutaz alhami', 'mutaz@alhami.com', 'default.png', '', '2021-07-04 20:10:01', 1, '', 0, 1, '', '', '', '', '', '650328698', '39999366'),
(352, '278442139403', '$2y$10$6x8yUE22LmWAg3dFWfxLpeY7rTwBIRYBpCeIwoESJHqLmv.5MAOEq', 'Qays H. Zu\'bi', '11@EBAHRAIN.LIVE', '21.07.04.22.19-1625426359.8819-18756733.png', '', '2021-07-04 22:19:19', 2, '', 0, 1, 'Candidate ', '10', '<p><b>Qays H. Zu’bi</b>, a graduate of Duke University and the University of Cambridge in the United Kingdom. Qays commenced his legal career in Bahrain in 1981 as a Partner\r\nin Hatim S. Zu’bi Attorneys and Legal Consultants. He then set up his own legal\r\npractice and associated his office with the international law firms of White &amp; Case\r\nLLP, and Clifford Chance LLP. Today he is independent and is the Senior Partner of\r\nZu’bi &amp; Partners, Attorneys and Legal Consultants. He is a qualified litigator and\r\narbitrator.\r\nQays’ positions include: qualified litigator and arbitrator, Bahrain; Certified Arbitrator,\r\n</p><p>GCC Commercial Arbitration Centre; Legal Consultant, Dubai UAE; President,\r\nAmerican Chamber of Commerce in Bahrain (AmCham); Member, International Bar\r\nAssociation; Member, Law Society of England &amp; Wales (International Division); Board\r\nMember, Bahrain Japan Business &amp; Friendship Society; Board Member, Junior\r\nAchievement International (InJAz Bahrain); Board Member, AIESEC Bahrain;\r\nFounding member and Chairman, Oxford &amp; Cambridge Alumni of Bahrain and served\r\nas Honorary Consul of Canada to Bahrain for 15 years.\r\n</p><p>The fact that I am interested in a re-election for the position of President though I\r\nhave been at the helm since May 2013, is my belief that AmCham still needs to grow\r\nfurther in a different direction requiring my leadership to do so.\r\n</p><p>Today, AmCham Bahrain is a power house locally and internationally recognised. The\r\norganisation is well managed at board and administration levels, is audited, has a\r\nbalanced board of directors held between American and Bahraini members; has\r\nsuccessfully recruited new members; has successfully improved its funding\r\ncapabilities through fund raising and sponsorship; is constantly reassessing its\r\nmission and vision, has among its members well known business leaders from diverse\r\nsectors of the economy; has managed to gain the respect of the local Chamber of\r\nCommerce, government and semi government entities and officials; and has\r\nsuccessfully conducted advocacy sessions among other things.\r\n</p><p>Having with members of the board and admin team managed to create a solid\r\nplatform, it is still my belief that there are lots to be accomplished. I look forward to\r\nsteering AmCham further and join hands with those who are willing to actively\r\nexecute and support its objectives; help grow its membership and programs; and\r\nensure that AmCham remains financially viable, through active fund raising\r\nsponsorship and advocacy; in a position to effectively serve trade, investment and\r\ncommerce between Bahrain and the United States.&nbsp;<br></p>', '', '', '110000000', '16000000'),
(357, '647205061009', '$2y$10$n5E3HX5IfqSUN6HgNBTBQ.hLNOGX2CBa0E8.pxr4X18vf75Ru4gAS', 'Feras Fakhro', '6@EBAHRAIN.LIVE', '21.07.04.23.12-1625429573.5779-56297947.png', '', '2021-07-04 23:12:53', 2, '', 0, 1, 'Candidate ', '15', '<p>With over 15 years of experience at KPMG, Feras joined the firm in 2006 as part of the\r\naudit team for 10 years. As part of the audit team, he has worked on numerous number of\r\nclients spanning across financial services, manufacturing, retail and trade, telecom and\r\nhospitality. His main clients were predominately banks, government and insurance\r\ncompanies. In 2016 Feras was tasked to lead the business development and client\r\nrelationship team. As a manager in KPMG’s business development function, Feras is\r\nresponsible for ensuring that value is consistently added for our clients and that\r\nrelationships are mutually beneficial. As part of this role, Feras manages KPMG’s\r\nrelationships with several key clients in both the Public and Private sectors.\r\nFeras has proven ability to develop successful business relationships, lead teams and\r\ncollaborate with clients to translate project needs into well-defined business solutions.\r\nFeras is responsible for cultivating relationships and generating business across a broad\r\nspectrum of clients and sectors. Working in collaboration with lead partners, Feras has\r\nled numerous bids and possesses a deep understanding of KPMG’s services across audit,\r\nadvisory and tax. With an acknowledged reputation for professionalism, Feras has\r\nexcellent client-facing skills and possesses the energy to go the extra distance with\r\nKPMG’s staff and clients.\r\n</p><p>LinkedIn URL:\r\n</p><p>https://www.linkedin.com/in/feras-fakhro5125231b7?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3BtMbwAPQSRlCn\r\nJ3XxQSZlBQ%3D%3D<br></p>', '', '', '600000000', '60000000'),
(358, '138330422294', '$2y$10$mPgUjWvzRCTs5qPgcec/O.QOWbpIUbnpjkU.T.Cid/EOWsZAYtn3u', 'Susan E. Saxton', '5@EBAHRAIN.LIVE', '21.07.05.01.04-1625436265.0911-49812982.png', '', '2021-07-05 01:04:25', 2, '', 0, 1, 'Candidate ', '11', '<p>With over 25 years of leadership experience as an international executive in both industry\r\nand academia, Dr. Susan E. Saxton is the Founding President of the American University\r\nof Bahrain (AUBH). Dr. Saxton has held key leadership roles with Laureate Education (the\r\nworld’s largest private higher education network) including Chief Strategy Officer and\r\nChief Academic Officer, Global Products and Services. She has also served as the Chief\r\nStrategy &amp; Development Officer for the International Baccalaureate Organization (IB) in\r\nThe Hague.</p><p>\r\nDr. Saxton has played an integral role starting and transforming university campuses\r\nacross the world to higher levels of academic quality and fiscal sustainability. During her\r\ndistinguished career, Dr. Saxton served as Interim Chief Executive Officer and Senior Vice\r\nPresident, Innovation and Emerging Strategies, at the University of St. Augustine for\r\nHealth Sciences, part of Laureate Education. Prior to working with Laureate Education’s\r\nuniversities around the world, she held the roles of Vice President of Strategy &amp; Product\r\nDevelopment and the Dean of Students at Kaplan University, Founding Dean of the\r\nCollege of e-Learning at Lynn University, and Founding Dean of the School of Business\r\n&amp; Technology at Capella University.\r\nDr. Saxton has two Doctors of Philosophy (Ph.D.s), one in Organization and Management,\r\nand the other in Human Services/Psychology; a Master of Laws (LLM) in International\r\nBusiness from the University of Liverpool; a Master of Science in Business Administration\r\n(Ms.B.A.) in Finance from Boston University; and a Bachelor of Arts (B.A.) in Mathematics\r\nfrom Wellesley College.\r\nLink to bio on website: https://aubh.edu.bh/about/leadership/founding-president<br></p>', '', '', '500000000', '50000000'),
(359, '783554177793', '$2y$10$HuBOIHe6EZlFA4bTHHiO3us1HZpUAlS12zA974snpR4YhODvfruly', 'Daniel Taylor', '4@ebahrain.live', '21.07.05.01.08-1625436494.3736-70579455.png', '', '2021-07-05 01:08:14', 2, '', 0, 1, 'Candidate ', '14', '<p>FCMA, CGMA\r\nChief Financial Officer\r\n</p><p>An entrepreneur and professional management accountant with a wealth of operational\r\nmanagement experience, Mr. Taylor is the Chief Financial Officer at First Bahrain Real Estate\r\nDevelopment Co., serving on the company’s executive team since its founding in 2007.\r\nThroughout his tenure, First Bahrain has successfully developed properties in the industrial,\r\ncommercial, and residential sectors, including its most recent property, the El Balcón Mall,\r\nproducing good returns for stakeholders and maintaining strong banking relationships in the\r\nmidst of turbulent financial times.\r\n</p><p>Prior to joining First Bahrain, Mr. Taylor was General Manager of New York Coffee, and\r\nGeneral Manager of Mariner Technologies, where he was the chief architect of leading GCC\r\nbusiness news portal, TradeArabia.com.\r\n</p><p>Mr. Taylor is a veteran, having served as an officer in the United States Navy, participating in\r\nthe liberation of Kuwait in 1991.\r\n</p><p>Mr. Taylor serves as a Director on multiple boards, including those of the American Chamber\r\nof Commerce (AmCham) in Bahrain where he is the Treasurer and the Al Raja School where\r\nhe is the head of the Finance Committee.\r\n</p><p>Mr. Taylor earned a Master of Business Administration (MBA) with Distinction from the\r\nKellstadt Graduate School of Business at DePaul University, Chicago, USA along with a\r\nBachelor of Arts from the University of Virginia, USA. Mr. Taylor holds the designations\r\nFCMA and CGMA through the Chartered Institute of Management Accountants (CIMA) and\r\nthe Association of International Certified Professional Accountants (AICPA).<br></p>', '', '', '400000000', '40000000'),
(362, '207623193688', '$2y$10$Jt5Nd1jpCbZJys78qKH7J.S3Jb7cZ6Wn1wTcE0GGPdrxWHrK7lrLe', 'Ali Moosa', '1@ebahrain.live', '21.07.05.01.24-1625437470.4608-93306441.png', '', '2021-07-05 01:24:30', 2, '', 0, 1, 'Candidate ', '11', '<p>Vice Chairman\r\n&amp; Senior Country Officer\r\nJ.P. Morgan Chase Bank, Bahrain</p><p>Ali Moosa is a Vice Chairman within Corporate and Invesement Bank (CIB, and has an\r\nInternational Banking experience in multiple jurisdictions, diversity of banking products and\r\nservices, with 28 years of banking experience. Ali has Regional Business Executive role for\r\nWholesale Payments business providing senior clients connectivity and coverage, strategic\r\nbusiness expansion as well as Governance across the Central and Eastern Europe, Middle East &amp;\r\nAfrica “CEEMEA Regionâ€. In addition, Ali is the Chief Country Officer for Bahrain, Egypt,\r\nLebanon and Iraq across all line of business managing senior teams across Saudi Arabia, South\r\nAfrica, Russia covering Financial Institutions, Government and Large Corporates acorrs 40\r\ncountries.\r\n</p><p>Ali is accountable for developing and implementing growth strategies across J.P. Morgan’s lines\r\nof business, leading regional management teams and working in close partnership with senior\r\nleaders of the firm globally in building the firm’s expansion strategies, in-country client\r\nfranchises and product capabilities. Ali joined Chase Manhattan Bank in 1993 and held several\r\nleadership positions at the firm with direct responsibility of business agenda and regulatory\r\nobligation. Ali is also a board member of a number of companies in Bahrain including Economic\r\nDevelopment Board (EDB), Gulf Air Group of Companies and Bahrain Associations of Banks\r\nboard of Director.<br></p>', '', '', '100000000', '10000000'),
(363, '246261781184', '$2y$10$.VsDg7USXy7MPq6WmlrvWOks50i4T9TUYqkFyRByaU3OHQSptyQei', 'Reem Mohamed', 'Reem@amchambahrain.org', 'default.png', '', '2021-07-05 12:06:31', 1, '', 0, 2, '', '', '', '', '', '950211079', '33070044'),
(364, '161757279784', '$2y$10$7A/f5Vf9vFsUSdDXNonhuOWQNryNPvVOsV2Y.wGt9EI9.Uvr.GYTK', 'electroVoting', 'email@electrovoting.com', 'default.png', '', '2021-07-05 13:58:19', 1, '', 0, 2, '', '', '', '', '', '123456789', '37399933'),
(365, '162295920040', '$2y$10$u.b762cwLRyxe6X9hSLWL.t2Ce1CuSWM1tWrBrftm6N/5EM4IDEte', 'Nabeel Ajoor', 'ajoortex@batelco.com.bh ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '610117459', '39609939'),
(366, '727681406058', '$2y$10$/07XyqtONh7t6PJGFeCLbuQwSgh2DEWy2lq3lBhQuWJ8RiF83gqv2', 'Qays Zu\'bi', 'qzubi@zubipartners.com', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 1, '', '', '', '', '', '550133542', '39610105'),
(367, '269834586216', '$2y$10$urjJsJhvUYiK0Jf7cIyfz.AWKJYM3Jzel7xoFY0zUtsl9GyGLuiUK', 'Mazin Khoury', 'mazin.khoury@americanexpress.com.bh ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '671102320', '39696769'),
(368, '259991825939', '$2y$10$NU02ISwBovs54K9vVfmNTO87sZnEa6XkmCPHN8V3tDof3uRQ4ohn2', 'George Cheriyan', 'george.cheriyan@amh.org.bh ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '540623466', '39465864'),
(369, '139754069782', '$2y$10$ADdh4rJ8bTokBW8B6Cjrze1uLbY.6Nh5wNvrZRMQLCSwX0d1MCg4C', 'Dr. Susan Saxton', 'susan.saxton@aubh.edu.bh ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 1, '', '', '', '', '', '620559519', '33611177'),
(370, '127270720701', '$2y$10$V4Zy2taJ.0Qa52dVuLU60OF7uQw6VQyKSEkwYusOiu4m.jzj4/O4C', 'Fareed Bader', 'fareedbader@gmail.com', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '580113124', '39622155'),
(371, '290016616205', '$2y$10$lvsSJICLR7e8jTi98V/p4eniGtEUAU1jX.2PpM/beeTkuTZf3bnY.', 'Rawwaf Alhasan', 'raw007@gmail.com', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '710203942', '66622666'),
(372, '228796689584', '$2y$10$CApZwW1EnJfHUgbt9jBN3./AK7jCpOJLM8lkCgO/SKeoAT.x0AL4G', 'Abdulhasan AlDairi', 'bahrainsmes@gmail.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '700004270', '39952000'),
(373, '189850745855', '$2y$10$VTQDuO4LCkxoyjuqbs8UROfpc9iP4mkLeKKvn7Z6LpzdLNRSrw9F.', 'Samer Aljishi', 'samer@bfginternational.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '640101305', '39651165'),
(374, '142611217433', '$2y$10$CWVYS7P68yW376z3zFyTn.aKzFuFJ.l.0asd6FkiW5f3BEcieZq42', 'Bassem Battisha', 'battibr@chevron.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '740659650', '38880869'),
(375, '337155466796', '$2y$10$xC8rwSzrfhRyDG37NvOq4uKx98wyQsJcDixvhS7UBIDZK8pTSP5d2', 'Michel Sawaya', 'michel.sawaya@citi.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 1, '', '', '', '', '', '711411140', '38875888'),
(376, '135506824410', '$2y$10$pJAHq9jGWNFattJdK4nSSOMnHQOxqlGlpp2Fe6EupDQQlogv3tey2', 'Zahraa Taher', 'ztaher@finmarkcoms.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 1, '', '', '', '', '', '740010425', '39630997'),
(377, '197315578742', '$2y$10$6N.5tMbXBlffj1XFFnvbbu2WR/rSx3Ygabp0NJLxz1NISsBOoX.s2', 'Daniel Taylor', 'daniel@firstbahrain.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 1, '', '', '', '', '', '660917319', '33217799'),
(378, '409483847640', '$2y$10$G1O3ABNqXQfL7FochLs1MuKT7pxaQu5FR0tsuSUFGIX6hHOZhcf46', 'Ahmed Al Hujairy', 'ceo@gfbholdings.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '630101000', '39676999'),
(379, '256998756471', '$2y$10$P5V0tRuMRrAtLkhiGVkDs.bXivGR1SjeG/VR9rr6kkmNNBozcVCDK', 'Joseph Ghorayed', 'joseph.ghorayeb@hsbc.com', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '771057490', '66762875'),
(380, '314982680752', '$2y$10$eHfPYaDW5nW9cSgSM8sBEO/yb0qcn1iDfHcHcBrzapV6MOmhS7ZJe', 'Basim Al Saie', 'basim@alsaie.com', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '651000963', '66393939'),
(381, '104139949429', '$2y$10$vMV7/s1WA.T4gfcnvlQ1OetEzKzZt6JotiEJ4YQTTXpwMwVoAdRFa', 'Ali Moosa', 'ali.moosa@jpmorgan.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 1, '', '', '', '', '', '650400860', '39699337'),
(382, '165862946770', '$2y$10$RszgDlTznvU/A3S7gyMt9ebaUTq.h7K9YR7EgNGu9mENlV0MNshLi', 'Madhavan Kallath', 'madhavan@kallathandco.com ', 'default.png', '', '2021-07-05 15:21:19', 1, '', 0, 2, '', '', '', '', '', '480707472', '39953988'),
(383, '228734520185', '$2y$10$OVcjTFYSdzTfbQqSHUs.auNUpQtr5F7p5W5uvoQSEEivYOQ.NfmAO', 'Feras Fakhro', 'ffakhro@kpmg.com ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 1, '', '', '', '', '', '830502440', '39468080'),
(384, '213267598050', '$2y$10$OODnlxyeGq96Oz9UMiauI.pXOdOggBpT/tDwpgI9bm8iay1tthuO6', 'Hamad AlSaie', 'hamadal@microsoft.com', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 1, '', '', '', '', '', '760905550', '34314444'),
(385, '233507218918', '$2y$10$jRB6jbPkhxQqrWFJankOveqBWP59T.aVvUIj7WReZM60n6vVhMENG', 'Hesham AlAbbar', 'h.alabbar@muellerme.com ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 1, '', '', '', '', '', '901202371', '36664764'),
(386, '102512992860', '$2y$10$tC0/25gLRlG0LUWWNFqECOaXDJN3O.kGCZ5ORcZS1ZouUJOnardFO', 'Roger Blackall', 'blackall@pgc.com.bh ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 1, '', '', '', '', '', '670240079', '36044664'),
(387, '296970455930', '$2y$10$4Yn/Rg9.dHmNwiAN5n1BV.JotZmgnLvN5G4vnuk.Ix6vBWDsy0LzS', 'Tayyar Ufuk Ersoy', 'ufuk.ersoy@themerchanthouse.com ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 2, '', '', '', '', '', '890663246', '34018558'),
(388, '167189425280', '$2y$10$RsRWSX.yTUckXPTzyCNaeewCsJza4z7/VA9xJUnCvsQL47ji/BP9m', 'Ebrahim Zainal', 'ebrahim@maza.com ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 2, '', '', '', '', '', '440104955', '39632020'),
(389, '231784905651', '$2y$10$rISCG9zmconvt8lMrkujoeb3AqWE309E0CLLXj9iV9JZaPMH2kWUK', 'Vivian Jamal', 'vivian.jamal@tracktruenorth.com ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 2, '', '', '', '', '', '741103842', '39424337'),
(390, '797290340004', '$2y$10$ncOpIvi6I2pOOL3LB3EY2.amgPZeSfDszy.wY772TReO4Vfv.H5wa', 'Alok Gupta', 'alok@almoayyed.com ', 'default.png', '', '2021-07-05 15:21:20', 1, '', 0, 2, '', '', '', '', '', '750827289', '39528050'),
(391, '170373025435', '$2y$10$AtWlGNBl.CeWt0BLWs2dpeViqGFU/fmx.RCMf3ASay4V6K3atB3QK', 'Faisal Juma', 'juma.faisal@gmail.com', 'default.png', '', '2021-07-05 22:57:06', 1, '', 0, 2, '', '', '', '', '', '830402276', '38383322'),
(392, '295454025391', '$2y$10$0qlAX8k2QMYaaYyHLx2jSOMn4NBZVAAhz/8YSBOtmVrtCtroWY.2C', 'Ghizlane Rahali ', 'pi@pistrategica.com', 'default.png', '', '2021-07-05 22:58:35', 1, '', 0, 2, '', '', '', '', '', '780132564', '39300399'),
(393, '243646243596', '$2y$10$a62/W9ul5pCzz3QxMkMwk.k668986G.kVu4W4dSJCxif4w3hsmCm2', 'Foutoun  Hajjar', 'f.hajjar@tamimi.com', 'default.png', '', '2021-07-05 23:02:35', 1, '', 0, 2, '', '', '', '', '', '640726712', '36070909'),
(394, '225436634336', '$2y$10$T6CCKwHdGEzigsPSKwBZvuQQWL1QL28Z3sTmyaVoKEyqIDjVmGim.', 'Khalid Bin Hindi ', 'khalid@binhindi.com', 'default.png', '', '2021-07-05 23:03:47', 1, '', 0, 2, '', '', '', '', '', '700301305', '36006611'),
(395, '247941068426', '$2y$10$/JbTltK0urHdTjma1rpvGeDU7nWNj1eFCtgSOZmSH5RbJkd.opwAO', 'Khalid Harami', 'kharami@slb.com', 'default.png', '', '2021-07-05 23:05:34', 1, '', 0, 2, '', '', '', '', '', '720110610', '35588838'),
(396, '296043350094', '$2y$10$U0aDVjOaJFqmVFLPcA94yeKRwHJKqF1limTlpTjE64blxNm1HQTbi', 'Houda Nonoo', 'h.nonoo@yahoo.com', 'default.png', '', '2021-07-05 23:06:31', 1, '', 0, 1, '', '', '', '', '', '640902715', '39669379'),
(397, '599588230514', '$2y$10$Dw9yzsDW/4JgUZhN2Sj7AuCONLrEyrPxf6RqUGpjVcwGfM7u3nH8y', 'Raed Ahmed Omar Saleh', 'raed@ahmedomer.com', 'default.png', '', '2021-07-05 23:07:20', 1, '', 0, 2, '', '', '', '', '', '640121829', '39654789'),
(398, '152177581839', '$2y$10$9bAQMIkSZrDyMiPMM8ddse49dXUTcQYHpy720s81LqPMtbo2SR0a2', 'Khalid Turk', 'khalid@turk.bh', 'default.png', '', '2021-07-05 23:12:01', 1, '', 0, 2, '', '', '', '', '', '620401087', '39665521'),
(399, '155598295476', '$2y$10$L0/MOpsygqJWlp7N5rnmyeZTmtn45OL4MVZlhuLxwGq5i9kIGdsjm', 'Hussein AlSharif', 'husseinalsharif@gmail.com', 'default.png', '', '2021-07-06 09:14:02', 1, '', 0, 2, '', '', '', '', '', '770309666', '39601818'),
(400, '273364376457', '$2y$10$NWdd81E8taXKR0VBSFx7EeLEegJwKHn.JUeyx7jMQUT7LewPpKyo6', 'James Eastlack', 'jkeastlack@yahoo.com', 'default.png', '', '2021-07-06 09:14:45', 1, '', 0, 2, '', '', '', '', '', '500300607', '39399299'),
(401, '151323973420', '$2y$10$XNAJtKcO/50zI8LX0bxh2OC71UjHhedDHagddsl1/lv.06XPYsKRS', 'David Caston', 'davidgcaston@yahoo.com', 'default.png', '', '2021-07-06 09:15:37', 1, '', 0, 2, '', '', '', '', '', '541218379', '83298335'),
(402, '258374818435', '$2y$10$UVV5wGYSB6j6iIuFsFyRlu/WbZtg9RnTWMkDH6wGQi3raC4xkeXhW', 'Ingo Giesel ', 'ingo.giesel@shelfdrilling.com', 'default.png', '', '2021-07-06 10:09:06', 1, '', 0, 2, '', '', '', '', '', '570300452', '39527557'),
(403, '132326994375', '$2y$10$IZ/IE4xWQq6ziDu9ZBViT.isJRuK6sw7jWc7ix0pLmr43NSw1awZS', 'Ahmed Jawahery ', 'metee@meteebah.com', 'default.png', '', '2021-07-06 10:41:00', 1, '', 0, 2, '', '', '', '', '', '440103703', '39619000'),
(404, '430333560240', '$2y$10$GvD4HuvKQyg91HGVVNiDduoc3fujsxoIAptpcVsmySTmpLVYMJkAC', 'Amin Nasr ', 'amin@crescentbahrain.com', 'default.png', '', '2021-07-06 10:43:08', 1, '', 0, 2, '', '', '', '', '', '840732333', '66302020'),
(405, '164141538235', '$2y$10$n7V8SyQLeA7bcwrbulwIeeR/rylHnedUPeQHBSV9rrqhYYSGXwc/2', 'Ross Armbruster ', 'ross.armbruster@halliburton.com', 'default.png', '', '2021-07-06 10:46:06', 1, '', 0, 2, '', '', '', '', '', '473490940', '65552859'),
(406, '449083871014', '$2y$10$Kne7ZL/AFr1oeIYSVTKMOeILFos.nyp7HLN.AqXXmh9HoZsw/vrKK', 'Kunjan Choksi ', 'kunjanchoksi@jbfbah.com.bh', 'default.png', '', '2021-07-06 12:55:45', 1, '', 0, 2, '', '', '', '', '', '770857183', '39395285'),
(407, '318360221346', '$2y$10$lmYHNMXE6EWJ3eYSTqSoFOTflhWWF1BRyX.F6crL2UBM.8kLyVnum', 'M A  Sridhar ', 'mas@roshcomm.com', 'default.png', '', '2021-07-06 13:54:45', 1, '', 0, 2, '', '', '', '', '', '640412912', '39401122'),
(408, '187487008939', '$2y$10$9Vz6rUjKLchFuFcs0e2NiOj7QywmF8n/IiU6gbOHdcLYCJLyCd7pm', 'Fairooz AlAsfoor', 'fairooz.alasfoor@cigna.com', 'default.png', '', '2021-07-06 14:53:57', 1, '', 0, 2, '', '', '', '', '', '760906602', '39939927'),
(409, '303792834190', '$2y$10$xVXq7VkdbZ8get/PsRpaiO.mMynrnN.sf3C/kHZvbGXW2LX9Wy6CG', 'Nasser AlArayedh ', 'alarayedhgroup@gmail.com', 'default.png', '', '2021-07-06 15:03:41', 1, '', 0, 2, '', '', '', '', '', '651205611', '39617575'),
(410, '232053045517', '$2y$10$fLaapcmvzGf4ztp.5GaHJe4p2zyNcc4ismYNahhYxy80YMKM66kkO', 'Osama Almoayed ', 'o@ozi.me', 'default.png', '', '2021-07-06 15:26:29', 1, '', 0, 2, '', '', '', '', '', '731203275', '36924444'),
(411, '179213212439', '$2y$10$Get2iKKpT8AwYFnW3oXZIObJ9w3F2AkgNLpvmpqDOyZf5k2h4nV5a', 'Esmahan Bukhowa', 'esmahan@saarmallbahrain.com', 'default.png', '', '2021-07-06 16:57:41', 1, '', 0, 2, '', '', '', '', '', '710801165', '39977776'),
(412, '202054539823', '$2y$10$Q2pbf25/u0C6xzaTtr6AseflEen782zLZrDZFQc/TzyKbDttj0mg6', 'Mary', 'mary@amchambahrain.org', 'default.png', '', '2021-07-08 14:08:44', 1, '', 0, 1, '', '', '', '', '', '591103575', '35114696'),
(414, '344364810346', '$2y$10$Cw2kc5A.4i9XCgdkJDgyv.yLO9N2/KixxWyNdUT/w89cmDVYfkpYC', 'Tosin Arowojolu', '21@EBAHRAIN.LIVE', '21.07.13.17.08-1626185325.7623-62339325.png', '', '2021-07-13 17:08:45', 2, '', 0, 1, 'Candidate ', '13', '', '', '', '200000000', '20000000'),
(415, '203205574647', '$2y$10$rvc9z4BhXJqtrfQoXyN73.rb6l5gJnLVOwR.BAJdsFg12uUKGu.ni', 'Won by acclamation', 'alhami@yahoo.com', 'default.png', '', '2021-07-13 17:11:39', 1, '', 0, 1, '', '', '', '', '', '960000000', '37399933'),
(417, '313084214781', '$2y$10$VH7zsrFwIhhsMCM5DHYPrudSu6BRKJ/JwBmWhHUv79/eOzWq1mMqa', 'Tosin Arowojolu', 'tosinarowojolu@gmail.com', 'default.png', '', '2021-07-13 18:15:51', 1, '', 0, 1, '', '', '', '', '', '670583928', '36584499'),
(418, '257349198314', '$2y$10$EfxozgzHGlEjBzOMEV7KMu9jI8x3juernIS48p/kk1cT0CbkrLjfu', 'Susan E. Saxton', '40@ebahrain.live', '21.07.14.17.41-1626273666.3462-58470641.png', '', '2021-07-14 17:41:06', 2, '', 0, 1, 'VP2', '16', '', '', '', '400000000', '40404040'),
(419, '108507580016', '$2y$10$OmPje5m6gwVWXFWji9Q2P.CGH76v266iOYN/6cjufQ6yqbUPSF0QG', 'Ali Moosa', '44@EBAHRAIN.LIVE', '21.07.14.17.42-1626273758.495-7525208.png', '', '2021-07-14 17:42:38', 2, '', 0, 1, 'VP2', '16', '', '', '', '440000000', '44444444');

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

--
-- Table structure for table `users_session`
--

CREATE TABLE `users_session` (
  `id` int(11) NOT NULL,
  `user_id` varchar(300) NOT NULL,
  `hash` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 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 dumped tables
--

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  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 `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- 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 `user`
--
ALTER TABLE `user`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=420;

--
-- AUTO_INCREMENT for table `users_session`
--
ALTER TABLE `users_session`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

