text: -- phpMyAdmin SQL Dump
  -- version 4.7.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Generation Time: Oct 25, 2017 at 03:48 PM
  -- Server version: 5.6.37
  -- PHP Version: 5.6.30
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `dslegypt_ticketing`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `categories`
  --
  
  INSERT INTO `categories` (`id`, `created_at`, `updated_at`, `name`, `status`) VALUES
  (1, '2017-09-11 17:57:17', '2017-09-11 17:57:17', 'nbn', 0),
  (2, '2017-09-11 20:47:24', '2017-09-11 20:47:24', 'ASDL', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `clients`
  --
  
  CREATE TABLE `clients` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `type` int(2) NOT NULL,
    `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `network_id` int(11) DEFAULT NULL,
    `start_date` timestamp NULL DEFAULT NULL,
    `mobile` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
    `packet_id` int(11) DEFAULT NULL,
    `account` int(11) DEFAULT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `order_status` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
    `user_name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `clients`
  --
  
  INSERT INTO `clients` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `type`, `address`, `phone`, `network_id`, `start_date`, `mobile`, `packet_id`, `account`, `customer_id`, `order_status`, `user_name`) VALUES
  (28, 'رجاء يحيى', 'nadasanad603@yahoo.com', '', NULL, '2017-09-28 22:33:53', '2017-09-28 22:36:52', 0, '', '23719151', 17, '0000-00-00 00:00:00', '', 0, 1172549171, 0, '', ''),
  (26, 'Areej Fouad', 'ArejjFouaad@yahoo.com', '', NULL, '2017-09-28 14:46:54', '2017-09-28 14:46:54', 0, 'حدائق حلوان', '23731195', 17, '0000-00-00 00:00:00', '1065520267', 0, 54, 0, '', ''),
  (27, 'محمد جمال', 'nadasanad306@yahoo.com', '', NULL, '2017-09-28 22:29:44', '2017-09-28 22:29:44', 0, '', '23712668', 17, '0000-00-00 00:00:00', '1228061983', 1, 1171362607, 0, '', ''),
  (25, 'kamal Rady Azmy ', ' 	Kamal@yahoo.com', '', NULL, '2017-09-27 21:08:47', '2017-09-27 21:11:03', 0, 'ح حلوان ', '23695674', 17, '0000-00-00 00:00:00', '01141283307 - 1140635346', 1, 3479, 0, '', ''),
  (23, 'walid Mahmoud', ' 	walidmahmoud@yahoo.c', '', NULL, '2017-09-27 20:26:55', '2017-09-27 20:26:55', 0, 'حدائق حلوان', '23724294', 17, '0000-00-00 00:00:00', '', 1, 1152, 0, '', ''),
  (24, 'Eman shafee Hamza', 'EmanElShafee@yahoo.c', '', NULL, '2017-09-27 20:41:09', '2017-09-27 20:41:09', 0, 'ح حلوان ', '23752099', 17, '0000-00-00 00:00:00', '1112631774', 1, 11, 0, '', ''),
  (29, 'moo.Test', 'moo5@dashboard.com', '', NULL, '2017-10-01 14:58:43', '2017-10-01 14:58:43', 0, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '023569874', 17, '0000-00-00 00:00:00', '0126478564', 1, 0, 0, '', ''),
  (30, 'mmmmmmmmmm', 'soha@sooooha.com', '', NULL, '2017-10-09 16:38:25', '2017-10-09 16:38:25', 0, 'cairo', '33333', 17, '2017-12-10 04:00:00', '5555555', 1, 555588, 0, '', ''),
  (31, 'mouyj', 'soha@so00ha.com', '', NULL, '2017-10-09 16:39:51', '2017-10-09 16:39:51', 0, 'cairouuu', '0098987', 17, '2017-12-10 04:00:00', '8777', 2, 0, 0, '', ''),
  (32, 'رجاء يحيى', 'nadasanad603@yahoo.com', '', NULL, NULL, NULL, 0, '', '23719151', 17, '0000-00-00 00:00:00', '', 0, 1172549171, 0, '', ''),
  (33, 'Areej Fouad', 'ArejjFouaad@yahoo.com', '', NULL, NULL, NULL, 0, 'حدائق حلوان', '23731195', 17, '0000-00-00 00:00:00', '1065520267', 0, 54, 0, '', ''),
  (34, 'محمد جمال', 'nadasanad306@yahoo.com', '', NULL, NULL, NULL, 0, '', '23712668', 17, '0000-00-00 00:00:00', '1228061983', 1, 1171362607, 0, '', ''),
  (35, 'kamal Rady Azmy ', ' 	Kamal@yahoo.com', '', NULL, NULL, NULL, 0, 'ح حلوان ', '23695674', 17, '0000-00-00 00:00:00', '01141283307 - 1140635346', 1, 3479, 0, '', ''),
  (36, 'walid Mahmoud', ' 	walidmahmoud@yahoo.c', '', NULL, NULL, NULL, 0, 'حدائق حلوان', '23724294', 17, '0000-00-00 00:00:00', '', 1, 1152, 0, '', ''),
  (37, 'Eman shafee Hamza', 'EmanElShafee@yahoo.c', '', NULL, NULL, NULL, 0, 'ح حلوان ', '23752099', 17, '0000-00-00 00:00:00', '1112631774', 1, 11, 0, '', ''),
  (38, 'moo.Test', 'moo5@dashboard.com', '', NULL, NULL, NULL, 0, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '023569874', 17, '0000-00-00 00:00:00', '0126478564', 1, 0, 0, '', ''),
  (39, 'mmmmmmmmmm', 'soha@sooooha.com', '', NULL, NULL, NULL, 0, 'cairo', '33333', 17, '2017-12-10 04:00:00', '5555555', 1, 555588, 0, '', ''),
  (40, 'mouyj', 'soha@so00ha.com', '', NULL, NULL, NULL, 0, 'cairouuu', '0098987', 17, '2017-12-10 04:00:00', '8777', 2, 0, 0, '', ''),
  (41, 'رجاء يحيى', 'nadasanad603@yahoo.com', '', NULL, NULL, NULL, 0, '', '23719151', 17, '0000-00-00 00:00:00', '', 0, 1172549171, 0, '', ''),
  (42, 'Areej Fouad', 'ArejjFouaad@yahoo.com', '', NULL, NULL, NULL, 0, 'حدائق حلوان', '23731195', 17, '0000-00-00 00:00:00', '1065520267', 0, 54, 0, '', ''),
  (43, 'محمد جمال', 'nadasanad306@yahoo.com', '', NULL, NULL, NULL, 0, '', '23712668', 17, '0000-00-00 00:00:00', '1228061983', 1, 1171362607, 0, '', ''),
  (44, 'kamal Rady Azmy ', ' 	Kamal@yahoo.com', '', NULL, NULL, NULL, 0, 'ح حلوان ', '23695674', 17, '0000-00-00 00:00:00', '01141283307 - 1140635346', 1, 3479, 0, '', ''),
  (45, 'walid Mahmoud', ' 	walidmahmoud@yahoo.c', '', NULL, NULL, NULL, 0, 'حدائق حلوان', '23724294', 17, '0000-00-00 00:00:00', '', 1, 1152, 0, '', ''),
  (46, 'Eman shafee Hamza', 'EmanElShafee@yahoo.c', '', NULL, NULL, NULL, 0, 'ح حلوان ', '23752099', 17, '0000-00-00 00:00:00', '1112631774', 1, 11, 0, '', ''),
  (47, 'moo.Test', 'moo5@dashboard.com', '', NULL, NULL, NULL, 0, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '023569874', 17, '0000-00-00 00:00:00', '0126478564', 1, 0, 0, '', ''),
  (48, 'mmmmmmmmmm', 'soha@sooooha.com', '', NULL, NULL, NULL, 0, 'cairo', '33333', 17, '2017-12-10 04:00:00', '5555555', 1, 555588, 0, '', ''),
  (49, 'mouyj', 'soha@so00ha.com', '', NULL, NULL, NULL, 0, 'cairouuu', '0098987', 17, '2017-12-10 04:00:00', '8777', 2, 0, 0, '', ''),
  (50, 'رجاء يحيى', 'nadasanad603@yahoo.com', '', NULL, NULL, NULL, 0, '', '23719151', 17, '0000-00-00 00:00:00', '', 0, 1172549171, 0, '', ''),
  (51, 'Areej Fouad', 'ArejjFouaad@yahoo.com', '', NULL, NULL, NULL, 0, 'حدائق حلوان', '23731195', 17, '0000-00-00 00:00:00', '1065520267', 0, 54, 0, '', ''),
  (52, 'محمد جمال', 'nadasanad306@yahoo.com', '', NULL, NULL, NULL, 0, '', '23712668', 17, '0000-00-00 00:00:00', '1228061983', 1, 1171362607, 0, '', ''),
  (53, 'kamal Rady Azmy ', ' 	Kamal@yahoo.com', '', NULL, NULL, NULL, 0, 'ح حلوان ', '23695674', 17, '0000-00-00 00:00:00', '01141283307 - 1140635346', 1, 3479, 0, '', ''),
  (54, 'walid Mahmoud', ' 	walidmahmoud@yahoo.c', '', NULL, NULL, NULL, 0, 'حدائق حلوان', '23724294', 17, '0000-00-00 00:00:00', '', 1, 1152, 0, '', ''),
  (55, 'Eman shafee Hamza', 'EmanElShafee@yahoo.c', '', NULL, NULL, NULL, 0, 'ح حلوان ', '23752099', 17, '0000-00-00 00:00:00', '1112631774', 1, 11, 0, '', ''),
  (56, 'moo.Test', 'moo5@dashboard.com', '', NULL, NULL, NULL, 0, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '023569874', 17, '0000-00-00 00:00:00', '0126478564', 1, 0, 0, '', ''),
  (57, 'mmmmmmmmmm', 'soha@sooooha.com', '', NULL, NULL, NULL, 0, 'cairo', '33333', 17, '2017-12-10 04:00:00', '5555555', 1, 555588, 0, '', ''),
  (58, 'mouyj', 'soha@so00ha.com', '', NULL, NULL, NULL, 0, 'cairouuu', '0098987', 17, '2017-12-10 04:00:00', '8777', 2, 0, 0, '', ''),
  (59, 'AhmedIbrahim Saber', 'eng_ahmed2002us2003@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '33 el hoda w el nour st. taseem farid zaki hadayik helwan', '23707152', 18, '2017-08-14 12:14:26', '1223539694', 1, 1008511599, 1530426, 'Enabled', '0223707152-salha'),
  (60, 'abdelnabykhalel ahmed', 'Aymanvision@gmail.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '18 Nasser  Gamal Eid  Helwan Gardens', '23740280', 17, '2017-08-13 15:13:47', '1223535202', 2, 1012162214, 1943117, 'Terminated', '0223740280-vision'),
  (61, 'fergasmaael mohamd', 'shikoo2011@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, 'hadayek helwan', '23700418', 18, '0000-00-00 00:00:00', '1112210065', 1, 1012333279, 1960087, 'Cancelled', '0223700418-vision'),
  (62, 'abd-el-slammohmed mohmoud', 'ayman_hassan1985@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '36 takseem el nasr llsearat  Zamzam compound gate', '23728555', 18, '0000-00-00 00:00:00', '1144168360', 2, 1012398132, 1966512, 'Terminated', '0223728555-vision'),
  (63, 'ahmed fayz amin', 'ahmed.gahen@gmail.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '255 elhosiny st  taksem fareed zaky  hadayek helwa', '23716122', 18, '0000-00-00 00:00:00', '1000166441', 2, 1012408473, 1967545, 'Terminated', '0223716122-vision'),
  (64, 'azatabdo khlil', 'ezatmezo@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '12 sha3rawy st  elma3sara  elmahata', '23702351', 18, '0000-00-00 00:00:00', '1206454228', 1, 1012408415, 1967539, 'Enabled', '0223702351-vision'),
  (65, 'Gorgehabeb boles', 'georgeboulos51@yhoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '13 street wady hoaf 35', '23741742', 18, '0000-00-00 00:00:00', '1225115241', 1, 1012422853, 1968976, 'Terminated', '0223741742-vision'),
  (66, 'MahmoudHatem Saifallah', 'mahmoudhatem409@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '40 Mahmod El Shami Street  Hadayek Helwan Helwan', '23697985', 18, '0000-00-00 00:00:00', '1149955057', 1, 1012422791, 1968969, 'Terminated', '0223697985-vision'),
  (67, 'sameh mohmed', 'mohamedsameh52031@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '36 Most Beautiful Street Gardens Helwan', '23708493', 18, '0000-00-00 00:00:00', '1225964815', 1, 1012471376, 1974053, 'Cancelled', '0223708493-vision'),
  (68, 'mohmedhessan mohmed', 'abdelrahman.2016@hotmail.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '40 el hoseney st  hadayek helwan', '23706382', 18, '0000-00-00 00:00:00', '1019871867', 1, 1012498648, 1977017, 'Terminated', '0223706382-vision'),
  (69, 'amr abd-el-star', 'donya.amr89@gmail.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '20 gmal abd el naser st', '23703523', 18, '0000-00-00 00:00:00', '1121047438', 1, 1110627490, 1991175, 'Enabled', '0223703523-vision'),
  (70, 'mohmedslah hassan', 'drhassan_aboali@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '82 lamaa el motaa st - hadayek helwan', '23700618', 18, '0000-00-00 00:00:00', '1005371804', 1, 1110627549, 1991180, 'Terminated', '0223700618-vision'),
  (71, 'hmodaamr ahmed', 'hmoda@link.net', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '15 mayo', '25522613', 18, '0000-00-00 00:00:00', '1283035908', 1, 1121339106, 2174985, 'Terminated', '0225522613-vision'),
  (72, 'TarikMohamed Mohamed Youssif', 'tarek1767@hotmail.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '9 faissal st - giza', '23704143', 18, '0000-00-00 00:00:00', '1001767646', 1, 1121469309, 2190779, 'Terminated', '0235824567-vision'),
  (73, 'islamtarek farok', 'islamucha@yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, 'Hadyk Helwan', '23731344', 18, '0000-00-00 00:00:00', '1147600926', 1, 1130002902, 2205780, 'Terminated', '0223731344-Tarik'),
  (74, 'Maher Faiz', 'M.faiz2013@Yahoo.com', '', NULL, '2017-10-11 13:56:15', '2017-10-11 13:56:15', 0, '6 شارع 12', '23723136', 18, '0000-00-00 00:00:00', '1282502727', 1, 1170577806, 2989728, 'Enabled', '0223723136-MSAN'),
  (75, 'Nasr Hassan', 'hamada4491@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'Helwan', '23719452', 18, '0000-00-00 00:00:00', NULL, 1, 1121458617, 2189621, 'Terminated', '0223719452-vision'),
  (76, 'abdokhaled abdelrahman', 'analooka@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'شارع السكه الحديد عزبة الوبده  القاهره', '23731415', 18, '0000-00-00 00:00:00', '1118551275', 1, 1012527306, 1980216, 'Enabled', '0223731415-vision'),
  (77, 'ahmedmohamed ahmed', 'scotsh-mido@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '19 شارع حسن بالى', '23702599', 18, '0000-00-00 00:00:00', '1285451457', 1, 1110581133, 1986047, 'Terminated', '0223702599-vision'),
  (78, 'salahmostafa gomaa', 'tito_sniper2@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '11 شارع لمعى المطيعى', '23702644', 18, '0000-00-00 00:00:00', '1112495276', 1, 1110581802, 1986113, 'Terminated', '0223702644-vision'),
  (79, 'خالدوجدى محمد كامل', 'khwagdy@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '10 أ شارع لمعى المطيعى حدائق حلوان', '23728561', 18, '0000-00-00 00:00:00', '1110909446', 1, 1110581493, 1986077, 'Terminated', '0223728561-vision'),
  (80, 'hosnyrabee3 hassan', 'Hosnymohamed389@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '7th elgam3 st elmasara elbalad', '23722761', 18, '0000-00-00 00:00:00', '1123729726', 1, 1120053645, 2005173, 'Suspended Due to B&C I', '0223722761-vision'),
  (81, 'tarekehab mohmed', 'tarek_salata@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '78 شارع تتنجى', '23692557', 18, '0000-00-00 00:00:00', '1127588205', 1, 1120137019, 2016297, 'Enabled', '0223708591-vision'),
  (82, 'YOSIFmohmed yosif', 'tatabody1978@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مساكن ناصر -منطقة 1 - مدخل 116 حلوان', '27653370', 18, '0000-00-00 00:00:00', '1010121948', 1, 1120230975, 2025796, 'Suspended Due to B&C I', '0227653370-vision'),
  (83, 'marianhabib arian', 'girges.magdy88@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '1 شارع على عارف', '23713681', 18, '0000-00-00 00:00:00', '1005670081', 1, 1120293569, 2032699, 'Enabled', '0223713681-vision'),
  (84, 'MostafaReda Sayed', 'tefa80075@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '1شارع سرحان عبد اللطيف -مدينة الهدي-حدائق حلوان', '23713828', 18, '0000-00-00 00:00:00', NULL, 1, 1120336723, 2038838, 'Terminated', '0223713828-vision'),
  (85, 'DAAMOSTFA GMAL', 'hanihani29@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '31 شارع الحسينى تقسيم فريد ذكى', '23693110', 18, '0000-00-00 00:00:00', '1064002184', 1, 1120350054, 2040356, 'Enabled', '0223693110-vision'),
  (86, 'ابراهيمعبد الوهاب العنانى', 'elenany.ebrahim@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '6 ش 19 وادى حوف حلوان', '23694112', 18, '0000-00-00 00:00:00', '1021064662', 1, 1120439056, 2052365, 'Enabled', '0223694112-vision'),
  (87, 'nesreen salah eldinsalah eldin kassam kassam fathalla', 'neso.heart@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '16 شارع 25تقسيم النصر للسيارات -حدايق حلوان', '23715995', 18, '0000-00-00 00:00:00', '1003733939', 1, 1120457003, 2054295, 'Enabled', '0223715995-vision'),
  (88, 'معتز باللهاحمد الصاوى', 'mtz_elsawy@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '63 شارع عبد الستار فودة عزبة خليل المعصرة حلوان القاهرة', '23736683', 18, '0000-00-00 00:00:00', '1062341310', 1, 1120476144, 2056304, 'Enabled', '0223736683-vision'),
  (89, 'atefmohamed MOHAMED', 'atefmegypt@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '25 شارع الحسينى', '23706826', 18, '0000-00-00 00:00:00', '1114009039', 1, 1120472668, 2055962, 'Enabled', '0223706826-vision'),
  (90, 'KARIMtarek abd elal', 'Kareem_tarek96@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '27 ش محمود الشامى', '23724028', 18, '0000-00-00 00:00:00', '1097942842', 1, 1120494448, 2058259, 'Enabled', '0223724028-vision'),
  (91, 'محمدمسعد سعد', 'mohamedmosed510@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '9 ش عمر بنالخطاب', '23719353', 18, '0000-00-00 00:00:00', '1221286250', 1, 1120509619, 2059816, 'Enabled', '0223719353-vision'),
  (92, 'ibrahimhamed salim', 'mzo333@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '6 عمارات منتصر', '23756122', 18, '0000-00-00 00:00:00', '1221619753', 1, 1120555331, 2064563, 'Enabled', '0223712825-vision'),
  (93, 'mohmedmagdi mohamed', 'toconnect2011@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المشروع الامريكى', '25571108', 18, '0000-00-00 00:00:00', '1152828567', 1, 1120579253, 2067077, 'Suspended Due to B&C I', '0225571108-vision'),
  (94, 'mohmoudmnsour mohmoud', 'amirafarouk21@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25500123', 18, '0000-00-00 00:00:00', '1005488589', 1, 1120575024, 2066635, 'Enabled', '0225500123-vision'),
  (95, 'fakhryramzy ayoub', 'magedfawzy16@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'امبابه', '33580298', 18, '0000-00-00 00:00:00', '1012555310', 1, 1120579828, 2067135, 'Enabled', '0233580298-vision'),
  (96, 'jehanglal frghli', 'hadermohamed479@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'شارع الغربى', '25580554', 18, '0000-00-00 00:00:00', '1111884224', 1, 1120587777, 2067288, 'Suspended Due to B&C I', '0225580554-vision'),
  (97, 'saadelden abeelwareth', 'dndra.mostafa@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25523694', 18, '0000-00-00 00:00:00', '1283560999', 1, 1120605912, 2069576, 'Terminated', '0225523694-vision'),
  (98, 'mohmedAHMED ELSAWE', 'mostafa_mohamed401@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'القطاميه', '27580252', 18, '0000-00-00 00:00:00', '1229217291', 1, 1120616993, 2071216, 'Suspended Due to B&C I', '0227580252-vision'),
  (99, 'bkhetasaid mgahed', 'mounirm41@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المعصرة', '23730209', 18, '0000-00-00 00:00:00', '1119782620', 1, 1120614273, 2070948, 'Suspended Due to B&C I', '0223711844-vision'),
  (100, 'Osamamohamed samir', 'osamamohamed816@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'شارع محمود الشامى', '23723963', 18, '0000-00-00 00:00:00', NULL, 1, 1120635576, 2073182, 'Terminated', '0223723963-vision'),
  (101, '3smatltfi ibrahim', 'sarah1990821@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25526010', 18, '0000-00-00 00:00:00', '1015659691', 1, 1120632100, 2072822, 'Enabled', '0225526010-vision'),
  (102, 'hassanmahmoud hassan', 'monymoza123@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23725761', 18, '0000-00-00 00:00:00', '1151167715', 1, 1120642633, 2074087, 'Terminated', '0223725761-vision'),
  (103, 'heshamkhalf fahme', 'heshamkhalaf92@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'شارع الجيش', '23745814', 18, '0000-00-00 00:00:00', '1212581458', 1, 1120659865, 2076011, 'Cancelled', '0223745814-vision'),
  (104, 'azzazabd elmohsen mohmed', 'enf_ahmed2002us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'طره', '27011100', 18, '0000-00-00 00:00:00', NULL, 1, 1120705931, 2081006, 'Terminated', '0227011100-vision'),
  (105, 'mohmedahmed elsaid', 'ahmed.mezo011@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25521607', 18, '0000-00-00 00:00:00', '1141423588', 1, 1120705973, 2081010, 'Suspended Due to B&C I', '0225521607-vision'),
  (106, 'abanobnabil milad', 'abanob.nabil91@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23692105', 18, '0000-00-00 00:00:00', '1273177711', 1, 1120841876, 2103967, 'Enabled', '0223692105-vision'),
  (107, 'hanymohmed abdelgfar', 'Medoo.zamalek.forever@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25523132', 18, '0000-00-00 00:00:00', '1004952054', 1, 1120935926, 2116941, 'Cancelled', '0225523132-visionn'),
  (108, 'mohmedatalh mohmoud', 'kareem.banda74@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23719296', 18, '0000-00-00 00:00:00', '1227440949', 1, 1120975328, 2121564, 'Cancelled', '0223712296-vision'),
  (109, 'smahabdl elhalim slomaa', 'bdela100@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الموسكى', '25899811', 18, '0000-00-00 00:00:00', '1127814726', 1, 1121032784, 2131476, 'Suspended Due to B&C I', '0225899811-vision'),
  (110, 'raadawad rezk', 'SAMY_9866@YAHOO.COM', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الموسكى', '25934518', 18, '0000-00-00 00:00:00', '1281140963', 1, 1121033985, 2131619, 'Enabled', '0225934518-vision'),
  (111, 'mostfakhlifa ahmed', 'helwan22@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23715551', 18, '0000-00-00 00:00:00', '1114623991', 1, 1121033930, 2131615, 'Terminated', '0223715551-vision'),
  (112, 'MOHMEDshawqe ahmed', 'RAWAN.el7op@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '25597038', 18, '0000-00-00 00:00:00', '1098111804', 1, 1121033761, 2131597, 'Terminated', '0225597038-vision'),
  (113, 'mohmedblal mohmed', 'belal201076@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23714132', 18, '0000-00-00 00:00:00', '1113759361', 1, 1121033245, 2131522, 'Enabled', '0223714132-vision'),
  (114, 'osamasaid abdelhafez', 'osamasayed20@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23724332', 18, '0000-00-00 00:00:00', '1114048076', 1, 1121052451, 2134639, 'Terminated', '0223724332-vision'),
  (115, 'اشرفحامد على', 'ashrafaly_67@hotmial.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '24شارع الظاهر بيبارس حدايق حلوان', '23693050', 18, '0000-00-00 00:00:00', '1069236770', 1, 1121105544, 2141984, 'Enabled', '0223693050-vision'),
  (116, 'mohamedrefaat maklad', 'mrefaat388@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '17street 7 wadi hof helwan', '23716195', 18, '0000-00-00 00:00:00', '1003061800', 1, 1121112643, 2143009, 'Terminated', '0223716195-vision'),
  (117, 'ahmedfathi taha', 'bobosabc@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25510051', 18, '0000-00-00 00:00:00', '1009295463', 1, 1121134296, 2145514, 'Enabled', '0225510051-vision'),
  (118, 'خالدالامير حسن', 'amir_75_79@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مدينه 15 مايو مجاوره 19 عماره 2 شقه 9', '25530357', 18, '0000-00-00 00:00:00', '1003595165', 1, 1121230239, 2158769, 'Terminated', '0225530357-vision'),
  (119, 'yassermohammed abdel-rahman', 'yasser7777g@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23695728', 18, '0000-00-00 00:00:00', '1229854114', 1, 1121230242, 2158770, 'Terminated', '0223695728-vision'),
  (120, 'mahmoedmahamed ellasy', 'ENG_AHMEDAHMED2002US2003@YAHOO.COM', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '73شارع تتنجى حدائق حلوان', '23721854', 18, '0000-00-00 00:00:00', '1281003507', 1, 1121242317, 2161006, 'Enabled', '0223721854-vision'),
  (121, 'hassan mohmed', 'eng_ahmed200us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'امبابه', '33536800', 18, '0000-00-00 00:00:00', '1126061376', 1, 1121330414, 2174491, 'Enabled', '0233536800-vision'),
  (122, 'MOHMEDSHABAN KHMES', 'hodaadel52@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23731874', 18, '0000-00-00 00:00:00', '1002812604', 1, 1121331342, 2173799, 'Enabled', '0223731874-VISSION'),
  (123, 'abasamr abdelate', 'eng_ahmed2002is2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المقطم', '26672550', 18, '0000-00-00 00:00:00', NULL, 1, 1121338752, 2174948, 'Terminated', '0226672550-vision'),
  (124, 'foudaahmed sobhi', 'fouda_sobhi@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'القطاميه', '27560471', 18, '0000-00-00 00:00:00', '1090129102', 1, 1121373480, 2179263, 'Terminated', '0227560471-vision'),
  (125, 'yaseradly razek', 'mostafad445@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الهرم', '33127945', 18, '0000-00-00 00:00:00', '1112026341', 1, 1121395215, 2181764, 'Terminated', '0233531444-vision'),
  (126, 'abdelazizahmed abdelaziz', 'zezokemo1882@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'صفت اللبن', '37781530', 18, '0000-00-00 00:00:00', '1005621882', 1, 1121391586, 2181381, 'Enabled', '0237781530-vision'),
  (127, 'amrmohmed ead', 'messam204@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الخانكه', '44647572', 18, '0000-00-00 00:00:00', '1280209593', 1, 1121416462, 2184451, 'Terminated', '0244647572-vision'),
  (128, 'Nbelmohmoud ahmed', 'veranabil33@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الفجاله', '25938931', 18, '0000-00-00 00:00:00', '1210970966', 1, 1121469010, 2190749, 'Terminated', '0225938931-vision'),
  (129, 'gabrabstawros beshay', 'gabra.beshay@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '364 شارع الترعه البولاقيه', '24301893', 18, '0000-00-00 00:00:00', '1001382966', 1, 1121487616, 2192808, 'Enabled', '0224301893-vision'),
  (130, 'ragabwagih mohmed', 'Nona_2010858@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق المعادى', '23696907', 18, '0000-00-00 00:00:00', '1200849265', 1, 1121522558, 2197148, 'Terminated', '0223696907-vision'),
  (131, 'MOHMEDHOSNY ELGHNOMY', 'bryatamer@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23704294', 18, '0000-00-00 00:00:00', '1284655513', 1, 1121544958, 2200584, 'Enabled', '0223704294-VISION'),
  (132, 'samehsaad hassanin', 'Samoosameh@gma.Com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المعصره', '23739348', 18, '0000-00-00 00:00:00', '1099155088', 1, 1130107637, 2225704, 'Enabled', '0223739348-vision'),
  (133, 'ehabsayed elngar', 'usamatravel@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الماظه', '26910192', 18, '0000-00-00 00:00:00', '1221034005', 1, 1130145695, 2230520, 'Suspended Due to B&C I', '226910192'),
  (134, 'hamdyabdelwahed ahmed', 'eng_ahmed2002us@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'التبين', '25015107', 18, '0000-00-00 00:00:00', NULL, 1, 1130148389, 2230838, 'Terminated', '0225015107-vision'),
  (135, 'mahmoudaraft ibrahim', 'mezo20025@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حلوان', '25582621', 18, '0000-00-00 00:00:00', '1285436323', 1, 1130185315, 2236154, 'Suspended Due to B&C I', '0225582621-vision'),
  (136, 'saidhmad ali', 'mohamed.haamaad@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23724398', 18, '0000-00-00 00:00:00', '1010001515', 1, 1130168390, 2233262, 'Enabled', '0223724398-vo'),
  (137, 'naserabdelrahman abdelrahman', 'eng_ahmed202us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المقطم', '25054420', 18, '0000-00-00 00:00:00', NULL, 1, 1130194725, 2237308, 'Cancelled', '0225054420-vision'),
  (138, 'mohmoudtaha mohammed', 'mohamed@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'امبابه', '33263297', 18, '0000-00-00 00:00:00', '1144955034', 1, 1130210542, 2239940, 'Terminated', '0233263297-vision'),
  (139, 'isalammohmed ali', 'eslam_eslam201273@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المعصره', '23710489', 18, '0000-00-00 00:00:00', '1273961361', 1, 1130265774, 2247667, 'Enabled', '0223710489-vision'),
  (140, 'ahmedabdelrhman eltobgi', 'ahmed_teta2008@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23716075', 18, '0000-00-00 00:00:00', '1223321311', 1, 1130303800, 2252136, 'Enabled', '0223716075-vision'),
  (141, 'ahmnedasam sobhi', 'mody2137@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23740224', 18, '0000-00-00 00:00:00', '1119629597', 1, 1130392981, 2263947, 'Terminated', '0223740224-vision'),
  (142, 'mohmedfathi zaki', 'mr.70da35@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23706393', 18, '0000-00-00 00:00:00', '1022326694', 1, 1130405130, 2265838, 'Enabled', '0223734986-vision'),
  (143, 'hosamrady mohmed', 'hoosam_anter@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23723322', 18, '0000-00-00 00:00:00', '1200822214', 1, 1130429143, 2268733, 'Enabled', '0223723322-vision'),
  (144, 'abdallahabo elwfa ibrahim', 'nanabebe330@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23713795', 18, '0000-00-00 00:00:00', '1006112952', 1, 1130434126, 2269362, 'Cancelled', '0223713795-vision'),
  (145, 'ahmedtarek mohmed', 'eng_ahmed2002us22003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23733598', 18, '0000-00-00 00:00:00', '1112002954', 1, 1130468237, 2273196, 'Terminated', '0223734220-vision'),
  (146, 'greangarden co', 'ebthag_ahmed@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23709449', 18, '0000-00-00 00:00:00', '1120041570', 1, 1130489436, 2276199, 'Terminated', '0223709449-vision'),
  (147, 'AhmedTarek Seyam', 'Ahmedtarekseyam@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23698806', 18, '0000-00-00 00:00:00', '1018324199', 1, 1130623034, 2291442, 'Enabled', '0223698806-vision'),
  (148, 'soheribrahim ibrahim', 'anosybody11@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23710992', 18, '0000-00-00 00:00:00', '1114312125', 1, 1130638124, 2293378, 'Enabled', '0223710992-vision'),
  (149, 'beterfrid shwqe', 'Roaaalrayek@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23718075', 18, '0000-00-00 00:00:00', '1274091386', 1, 1130710378, 2303586, 'Suspended Due to B&C I', '0223718075-vision'),
  (150, 'ahmedibrahim mohmed', 'Shadows12992@Gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23701854', 18, '0000-00-00 00:00:00', '1110687836', 1, 1130801130, 2314329, 'Enabled', '0223701854-vision'),
  (151, 'THROUATmlak yousig', 'Kiven1@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23703520', 18, '0000-00-00 00:00:00', '1203640629', 1, 1130835105, 2318275, 'Enabled', '0223703520-vision'),
  (152, 'alaaelden khalf', 'alaakgad@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'خدائق حلوان', '23703251', 18, '0000-00-00 00:00:00', '1223346630', 1, 1130849705, 2319982, 'Enabled', '0223703251-vision'),
  (153, 'islamosama mostfa', 'eslam.solom33@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23752099', 18, '0000-00-00 00:00:00', '1112631774', 1, 1130885316, 2323985, 'Enabled', '0223700590-vision'),
  (154, 'OmarMohamed Ashraf', 'Omar2013770@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23746820', 18, '0000-00-00 00:00:00', '1125150118', 1, 1130885754, 2324028, 'Suspended Due to B&C I', '0223746820-vision'),
  (155, 'kamalaziz andraos', 'kandraos@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '10 hassan baly  st hdaak hlwan', '23701955', 18, '0000-00-00 00:00:00', '1227695343', 1, 1130954281, 2331334, 'Enabled', '0223701955-vision'),
  (156, 'mohmedsand sand', 'nadasanad17@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23710441', 18, '0000-00-00 00:00:00', '1150113359', 1, 1131114194, 2348949, 'Terminated', '0223710441-vision'),
  (157, 'mohmedazelden abdelqader', 'Ruby_roro@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مدينة نصر', '24710126', 18, '0000-00-00 00:00:00', '1111919326', 1, 1131164610, 2354215, 'Terminated', '0224710126-vision'),
  (158, 'AHMEDHASSAN hesen', 'm_masterpiece66@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'شبرا', '24316966', 18, '0000-00-00 00:00:00', '1008232011', 1, 1131289989, 2367410, 'Enabled', '0224316966-vision'),
  (159, 'akhalid abdelmnam', 'ahmad.khalid77727@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23704145', 18, '0000-00-00 00:00:00', '1128282126', 1, 1131311886, 2369672, 'Enabled', '0223704145-vision'),
  (160, 'hosamabdalah said', 'hampopo48@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23728325', 18, '0000-00-00 00:00:00', '1127010930', 1, 1131249727, 2363004, 'Enabled', '0223728325-vision'),
  (161, 'sebaieeibrahem mohamed', 'ksebaiee@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23702910', 18, '0000-00-00 00:00:00', '1223593081', 1, 1131311604, 2369815, 'Cancelled', '0223702910-vision'),
  (162, 'ahmedsamir ali', 'ashrafsamer661@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23700531', 18, '0000-00-00 00:00:00', '1200977469', 1, 1131311737, 2370341, 'Terminated', '0223700531-vision'),
  (163, 'mostfaibrahim mohmed', 'mostafadarwishcom@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مدينة نصر', '22876991', 18, '0000-00-00 00:00:00', '1227462251', 1, 1131396023, 2378665, 'Enabled', '0222876991-vision'),
  (164, 'hibaasman mohmed', 'hoba.love@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23692519', 18, '0000-00-00 00:00:00', '1067018178', 1, 1131425525, 2382041, 'Enabled', '0223692519-vision'),
  (165, 'ramyabdelrahman yhya', 'Shoshone_roro_4@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23722967', 18, '0000-00-00 00:00:00', '1100119112', 1, 1131425129, 2382099, 'Enabled', '0223722967-vision'),
  (166, 'magdamtwali ali', 'memo_memo3118@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حداائق حلوان', '23756295', 18, '0000-00-00 00:00:00', '1008990728', 1, 1131431829, 2383061, 'Enabled', '0223727036-vision'),
  (167, 'NASERibrahim ahmed', 'naser_group2013@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الاوبرا', '27879808', 18, '0000-00-00 00:00:00', '1005850398', 1, 1131431329, 2382932, 'Cancelled', '0227879808-vision'),
  (168, 'mohmoudahmed slama', 'mailboy74@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23728219', 18, '0000-00-00 00:00:00', '1016339478', 1, 1131512385, 2391315, 'Enabled', '0223728219-vision'),
  (169, 'botrosbols eshak', 'Yossef_rona88@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '15 مايو', '25510146', 18, '0000-00-00 00:00:00', '1280633262', 1, 1131561548, 2396168, 'Enabled', '0225510146-visionn'),
  (170, 'ahmedshbel mohmed', 'sheblahmed78@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23706297', 18, '0000-00-00 00:00:00', '1126577631', 1, 1140056946, 2409108, 'Enabled', '223706297'),
  (171, 'mohmedragb mahmoud', 'mohmmed_ragb@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23698370', 18, '0000-00-00 00:00:00', '1272701464', 1, 1140081972, 2411765, 'Enabled', '0223698370-vision'),
  (172, 'MOHMEDGMAL MOHMED', 'eng_ahmd2002us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المعصره', '23712668', 18, '0000-00-00 00:00:00', NULL, 1, 1140133088, 2417171, 'Terminated', '223712668'),
  (173, 'MOHMEDmo2men mosbah', 'mohamedmoemen94@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23708172', 18, '0000-00-00 00:00:00', '1092122037', 1, 1140132689, 2417121, 'Terminated', '0223708172-vision'),
  (174, 'sadmohmed madboli', 'karim_atf98@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23730892', 18, '0000-00-00 00:00:00', '1203608059', 1, 1140152463, 2419200, 'Enabled', '0223730892-vision'),
  (175, 'asamabdelmged abdelhamed', 'ahmed_nser35@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23756113', 18, '0000-00-00 00:00:00', '1119581893', 1, 1140154521, 2419394, 'Enabled', '0223711171-vision'),
  (176, 'GHDAfatoh ibrahim', 'mohamed@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23713985', 18, '0000-00-00 00:00:00', '1223144617', 1, 1140168754, 2420892, 'Terminated', '0223713985-vision'),
  (177, 'mohmedhamed ali', 'fnarsky2004@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'السيده زينب', '27960885', 18, '0000-00-00 00:00:00', '1063201710', 1, 1140169413, 2420970, 'Terminated', '0227960885-vision'),
  (178, 'ahmedataf abdelftah', 'nadia.essam11@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حلوان', '23752091', 18, '0000-00-00 00:00:00', '1148169874', 1, 1140172432, 2421156, 'Enabled', '0227641290-vision'),
  (179, 'Afroditashraf philip', 'Afrodit.philip@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الهرم', '33882632', 18, '0000-00-00 00:00:00', '1009888000', 1, 1140195257, 2423702, 'Terminated', '0233842118-vision'),
  (180, 'asamfayzy hassn', 'messam53@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23752363', 18, '0000-00-00 00:00:00', '1113598032', 1, 1140216095, 2425832, 'Terminated', '0223719040-vision'),
  (181, 'ahmedsiliman amir', 'Boss_ahlawy74@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23705846', 18, '0000-00-00 00:00:00', '1122044144', 1, 1140418980, 2447221, 'Enabled', '0223705846-vision'),
  (182, 'Samirfekry labib', 'samirfikry@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23710443', 18, '0000-00-00 00:00:00', '1226855701', 1, 1140459898, 2451434, 'Enabled', '0223710443-vision'),
  (183, 'basembekhet snoda', 'bassemelmasry263@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23734059', 18, '0000-00-00 00:00:00', '1286764343', 1, 1140459554, 2451403, 'Terminated', '0223734059-vision'),
  (184, 'hibasaid ali', 'hhegazy611@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23699731', 18, '0000-00-00 00:00:00', '1008494512', 1, 1140470724, 2452683, 'Enabled', '0223699731-vision'),
  (185, 'mgdihbib bolas', 'arch.merna@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23702882', 18, '0000-00-00 00:00:00', '1003769334', 1, 1140473950, 2452989, 'Enabled', '0223702882-vision'),
  (186, 'islamalaa ahmed', 'eslam3laa14@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23697967', 18, '0000-00-00 00:00:00', '1288303737', 1, 1140490433, 2454703, 'Terminated', '0223697967-vision'),
  (187, 'rmdanhmaa hmada', 'ahmedhamaki76@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مدينة نصر', '24709821', 18, '0000-00-00 00:00:00', '1224046518', 1, 1140558301, 2461710, 'Enabled', '0224709821-vision'),
  (188, 'yaserahmed mahmoud', 'Loullayasser35@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مدينة نصر', '24716391', 18, '0000-00-00 00:00:00', '1226561715', 1, 1140568730, 2462766, 'Enabled', '0224716391-vision'),
  (189, 'basemfawzy hassn', 'nomi@Gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23714916', 18, '0000-00-00 00:00:00', '1152032178', 1, 1140570029, 2462918, 'Enabled', '0223714916-vision'),
  (190, 'abdelmohsenmohmed abdelmohsen', 'amrm_group@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23694034', 18, '0000-00-00 00:00:00', '1006068554', 1, 1140588478, 2464793, 'Enabled', '0223694034-vision'),
  (191, 'mohmedmahmoud mostfa', 'mahmoudmohamed23@gmali.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23691638', 18, '0000-00-00 00:00:00', '1157871945', 1, 1140624839, 2468521, 'Cancelled', '0223691638-vision'),
  (192, 'hnanayob said', 'Sadangil.nona@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'طره', '27009015', 18, '0000-00-00 00:00:00', '1146605292', 1, 1140671421, 2473337, 'Enabled', '0227009015-vision'),
  (193, 'WFAASAID MOHMED', 'mohsen_elmasry2010@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23733924', 18, '0000-00-00 00:00:00', '1150034489', 1, 1140696479, 2475910, 'Enabled', '0223733924-VISION'),
  (194, 'alisoliman hussen', 'nahlol_nona@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'hadaek helwan taksem el nasr ll sayrat number  13 street 39', '23724699', 18, '0000-00-00 00:00:00', '1229571070', 1, 1140711839, 2477504, 'Enabled', '0223724699-vision'),
  (195, 'MOHMEDAHMED HGAZY', 'mostafahegazy306@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23712751', 18, '0000-00-00 00:00:00', '1278787638', 1, 1140725137, 2478967, 'Enabled', '0223712751-vision'),
  (196, 'mohmedfadel khalid', 'memomessi96@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23729725', 18, '0000-00-00 00:00:00', '1157837106', 1, 1140741240, 2480633, 'Terminated', '0223729725-vision'),
  (197, 'YassmenMahmoud mohmmed', 'elkhashen94@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23717128', 18, '0000-00-00 00:00:00', '1118751467', 1, 1140778623, 2484509, 'Enabled', '0223717128-vision'),
  (198, 'YASERARAFAT ZAKI', 'arafatyasser73@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23731237', 18, '0000-00-00 00:00:00', '1114831561', 1, 1140778409, 2484486, 'Enabled', '0223731237-VISION'),
  (199, 'MarwanEmad eldon Abbas', 'Nermine84_elmasry@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '41 street 31 wadi hoof', '23703386', 18, '0000-00-00 00:00:00', '1225039112', 1, 1140831158, 2489856, 'Enabled', '0223703386-vision'),
  (200, 'ABDELRHAMASHRAF ABDELRASOL', 'abdelrahmansakr75@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدتائق حلوان', '23703081', 18, '0000-00-00 00:00:00', '1151796340', 1, 1140890711, 2496000, 'Enabled', '0223703081-VISION'),
  (201, 'nabilabdelhalim morsy', 'mohammednabil94@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23694896', 18, '0000-00-00 00:00:00', '1100992300', 1, 1140924490, 2499447, 'Enabled', '0223694896-vision'),
  (202, 'mostfawahid tawfiq', 'abdo.metwally.91@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23696962', 18, '0000-00-00 00:00:00', '1205264751', 1, 1140941600, 2501207, 'Enabled', '0223692924-vision'),
  (203, 'awatefshehata hassan', 'Amrfahim1997@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23745731', 18, '0000-00-00 00:00:00', '1128043043', 1, 1140961182, 2503218, 'Enabled', '0223745731-vision'),
  (204, 'HESSANabdelrahman abdo', 'Zienab.m.shabana@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23701372', 18, '0000-00-00 00:00:00', '1221270025', 1, 1141005596, 2507758, 'Enabled', '0223701372-vision'),
  (205, 'mostfamohmed abelaal', 'raouf-ramzy2010@link.net', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'التبين', '25011134', 18, '0000-00-00 00:00:00', NULL, 1, 1141062835, 2513472, 'Cancelled', '0225011134-vision'),
  (206, 'islammostfa abdelraze', 'elmsafers@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'h.helwan', '23701499', 18, '0000-00-00 00:00:00', '1224681860', 1, 1141073949, 2514654, 'Enabled', '0223701499-vision'),
  (207, 'SOMIAmohamed kamel', 'eng_ahmed220us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'h.hwlwan', '23732660', 18, '0000-00-00 00:00:00', NULL, 1, 1141074640, 2514726, 'Suspended Due to B&C I', '0223732660-vision'),
  (208, 'azizahassan ahmed', 'aaslama017@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23701179', 18, '0000-00-00 00:00:00', '1220310745', 1, 1141154856, 2522940, 'Enabled', '0223701179-vision'),
  (209, 'SEHAMhassan saer', 'Adhamek@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23703896', 18, '0000-00-00 00:00:00', '1157054903', 1, 1141236406, 2531372, 'Enabled', '0223703896-vision'),
  (210, 'basemahmed elgarf', 'basim.elgarf@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'ح.حلوان', '23737529', 18, '0000-00-00 00:00:00', '1114542656', 1, 1141245238, 2532285, 'Enabled', '0223737529-vision'),
  (211, 'samarabdelrhman ragab', 'smsmaabdosm21@gmai.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, NULL, '23720561', 18, '0000-00-00 00:00:00', '1004155112', 1, 1141245069, 2532270, 'Enabled', '0223720561-vision'),
  (212, 'radyabdelhamed yasen', 'basem_yassin@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23692526', 18, '0000-00-00 00:00:00', '1223333621', 1, 1141277976, 2535673, 'Enabled', '0223692526-vision'),
  (213, 'ahmedmohmed said', 'a7medmsayed77@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23754062', 18, '0000-00-00 00:00:00', '1149696739', 1, 1141327177, 2540853, 'Enabled', '0223708037-vision'),
  (214, 'michelmagdi fouad', 'mika_906@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23752224', 18, '0000-00-00 00:00:00', '1288578206', 1, 1141358289, 2544150, 'Enabled', '0223706718-vision'),
  (215, 'ahmedbadie hosny', 'ahmedbadie65@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23722367', 18, '0000-00-00 00:00:00', '1019664417', 1, 1141439852, 2552649, 'Enabled', '0223722367-vision'),
  (216, 'mohmedtarek mostfa', 'milo_music2000@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23752296', 18, '0000-00-00 00:00:00', '1114749301', 1, 1141479014, 2556709, 'Enabled', '0223713389-visionn'),
  (217, 'saidabdo abd el krim', 'emanfadala@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23697573', 18, '0000-00-00 00:00:00', '1006549184', 1, 1141535717, 2562364, 'Enabled', '0223697573-vision'),
  (218, 'ahmedmohmed elsaid', 'ahmedmoh.elsaid@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23739723', 18, '0000-00-00 00:00:00', '1285451457', 1, 1141560590, 2564971, 'Terminated', '0223739723-vision'),
  (219, 'ahmedali mohamed', 'fouda2010@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23701107', 18, '0000-00-00 00:00:00', '1145557123', 1, 1141709966, 2580136, 'Enabled', '0223701107-vision'),
  (220, 'rgaayahia kamel', 'ROGY_ALY2@GMAIL.COM', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23719151', 18, '0000-00-00 00:00:00', '1150112544', 1, 1150013441, 2585151, 'Enabled', '0223719151-vision'),
  (221, 'hbibaabdo ahmed', 'sarahjehadamin@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23740954', 18, '0000-00-00 00:00:00', '1009075209', 1, 1150035114, 2587405, 'Enabled', '0223740954-vision'),
  (222, 'ibtsamkhalifa mohmed', 'eng_ahmed2002us2oo3@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23726013', 18, '0000-00-00 00:00:00', NULL, 1, 1150088486, 2592848, 'Terminated', '0223726013-vision'),
  (223, 'mohamedsaleh fathi', 'omarsaleh201545@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23732390', 18, '0000-00-00 00:00:00', '1113060872', 1, 1150116076, 2595222, 'Enabled', '0223732390-vision'),
  (224, 'mahmoudabdelrady ahmed', 'sonson12345657@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23726779', 18, '0000-00-00 00:00:00', '1112177494', 1, 1150166089, 2600657, 'Enabled', '0223726779-vision'),
  (225, 'amalabdelwahed emam', 'Eman.hossni@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23740762', 18, '0000-00-00 00:00:00', '1227079906', 1, 1150195900, 2603693, 'Enabled', '0223740762-vision'),
  (226, 'antonyousgeorge henry', 'tosa_5550@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23752317', 18, '0000-00-00 00:00:00', '1220680762', 1, 1150228040, 2606960, 'Enabled', '0223715227-vision'),
  (227, 'tarekazat mahmoud', 'toty_638@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الاحمدين', '25761548', 18, '0000-00-00 00:00:00', '1222255102', 1, 1150227865, 2606941, 'Cancelled', '0225761548-vision'),
  (228, 'mohammedabdelgfar abd elnaby', 'Mohamed.abdelghafar@hcww.com.eg', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الجيزه', '38705304', 18, '0000-00-00 00:00:00', '1200080072', 1, 1150232682, 2607428, 'Enabled', '0238705304-vision'),
  (229, 'mohammedahmed ibraim', 'Mohammedosama320@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الجيزه', '23723963', 18, '0000-00-00 00:00:00', '1157055462', 1, 1150232702, 2607430, 'Enabled', '0233553935-vision'),
  (230, 'Sherifmohmmed mohmmed', 'eng_ahmed2002ous2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'الجهينى', '42159245', 18, '0000-00-00 00:00:00', NULL, 1, 1150237814, 2607967, 'Terminated', '0242153245-vision'),
  (231, 'mahmoussaid mohmed', 'Mohamed_alzamalk201157@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23704841', 18, '0000-00-00 00:00:00', '1150384612', 1, 1150242988, 2608501, 'Cancelled', '0223704841-vision'),
  (232, 'alaaahmed shehata', 'aalaaahmed2012@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مصر الجديده', '22404756', 18, '0000-00-00 00:00:00', '1222176147', 1, 1150233010, 2607463, 'Enabled', '0222404756-vision'),
  (233, 'blalabdelrahman mohamed', 'medo.memo421@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23715695', 18, '0000-00-00 00:00:00', '1154352278', 1, 1150288151, 2613079, 'Enabled', '0223715695-vision'),
  (234, 'mahermahmoud abdelwahab', 'koota_2014@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'دار السلام', '23696335', 18, '0000-00-00 00:00:00', '1223563600', 1, 1150300174, 2614276, 'Enabled', '0227187770-vision'),
  (235, 'ayahamdy abosreaa', 'sales@etsegypt.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'مدينة نصر', '26555195', 18, '0000-00-00 00:00:00', '1207902590', 1, 1150316543, 2615941, 'Suspended Due to B&C I', '0226555195-vision'),
  (236, 'gorgfawzy mansor', 'eng_ahmed2002us2003@yah00.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23741778', 18, '0000-00-00 00:00:00', NULL, 1, 1150341991, 2618523, 'Terminated', '0223741778-vision'),
  (237, 'mohamedahmed fathi', 'Muhamedfathi88@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23707311', 18, '0000-00-00 00:00:00', '1281575005', 1, 1150359155, 2620193, 'Enabled', '0223707311-vision'),
  (238, 'fatmaabdalnabi said', 'omhamada017@gamil.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'دار السلام', '23202372', 18, '0000-00-00 00:00:00', '1111750526', 1, 1150364914, 2620771, 'Enabled', '0223202372-vision'),
  (239, 'radwymohamed naser', 'eng_ahmed2002us2003@yahopo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23694426', 18, '0000-00-00 00:00:00', NULL, 1, 1150380189, 2622346, 'Enabled', '0223694426-vision'),
  (240, 'abd elrazikmahmoud hessan', 'a_elrazek2000@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23701908', 18, '0000-00-00 00:00:00', '1226160016', 1, 1150380043, 2622332, 'Enabled', '0223701908-vision');
  INSERT INTO `clients` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `type`, `address`, `phone`, `network_id`, `start_date`, `mobile`, `packet_id`, `account`, `customer_id`, `order_status`, `user_name`) VALUES
  (241, 'ahmedelsaid mobark', 'ahmedsayedmubarak@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'شبرا', '24958220', 18, '0000-00-00 00:00:00', '1113644475', 1, 1150380134, 2622341, 'Enabled', '0224958220-vision'),
  (242, 'ahmedmohamed abdelrahman', 'ahmedtota123099@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23732567', 18, '0000-00-00 00:00:00', '1152240684', 1, 1150609881, 2643674, 'Enabled', '0223732567-vision'),
  (243, 'amrmohamed mostfa', 'omar_mostafe@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23703164', 18, '0000-00-00 00:00:00', '1000468158', 1, 1150641812, 2646962, 'Enabled', '0223703164-vision'),
  (244, 'EslamMedian Abdelrahman', 'eslam.median@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23733294', 18, '0000-00-00 00:00:00', '1121077606', 1, 1150711751, 2653957, 'Enabled', '0223733294-visionn'),
  (245, 'ABD ELNABIIBRAHIM KHALIL', 'ames_ody@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23740280', 18, '0000-00-00 00:00:00', '1223535202', 1, 1150754363, 2658004, 'Enabled', '0223740280-visionn'),
  (246, 'AshrafMohameed Elsawy', 'elsawyashraf7@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23713298', 18, '0000-00-00 00:00:00', '1006800951', 1, 1150799322, 2662724, 'Enabled', '0223713298-vision'),
  (247, 'mostfagaber elgzar', 'eng_HMED2002US2003@YAHOO.COM', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'السيده زينب', '23629503', 18, '0000-00-00 00:00:00', NULL, 1, 1150815243, 2664285, 'Terminated', '0223629503-visionn'),
  (248, 'hodasad mohamed', 'eng_ahmed2002us203@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23730218', 18, '0000-00-00 00:00:00', NULL, 1, 1150848348, 2667622, 'Enabled', '0223730218-vision'),
  (249, 'mmadohmahmoud ibrahim', 'Mido.baroudy12345@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23692864', 18, '0000-00-00 00:00:00', '1003568849', 1, 1153104101, 2677532, 'Enabled', '0223692864-vision'),
  (250, 'asmaaabdelmnam abdelrahman', 'enfg_ahmed2002us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23741722', 18, '0000-00-00 00:00:00', NULL, 1, 1153194269, 2678135, 'Terminated', '0223741722-vision'),
  (251, 'soriaahmed ali', 'eng_ahmed2002u2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23711422', 18, '0000-00-00 00:00:00', NULL, 1, 1153375877, 2679336, 'Suspended Due to B&C I', '0223711422-vision'),
  (252, 'sherifbadr ismail', 'ROMUO_FOR_YOU@OUTLOOK.COM', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23693974', 18, '0000-00-00 00:00:00', '1285169061', 1, 1154054488, 2682791, 'Enabled', '0223693974-vision'),
  (253, 'mohamedatef mahmoud', 'Mohammed_atef3118@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23693704', 18, '0000-00-00 00:00:00', '1114727585', 1, 1156419792, 2695034, 'Enabled', '0223693704-vision'),
  (254, 'hanyshawqy sabet', 'meladanis88@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23713958', 18, '0000-00-00 00:00:00', '1200608608', 1, 1156753575, 2697057, 'Enabled', '0223713958-vision'),
  (255, 'ahmedamad taha', 'ahmed.emad2020010@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23717279', 18, '0000-00-00 00:00:00', '1158509250', 1, 1156917022, 2698208, 'Enabled', '0223717279-vision'),
  (256, 'ZayedMohamed Soliman', 'z.hail@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23714642', 18, '0000-00-00 00:00:00', '1288598459', 1, 1157818237, 2703465, 'Suspended Due to B&C I', '0223714642-vision'),
  (257, 'Osamamohamed hamed', 'usama_hamed@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23715077', 18, '0000-00-00 00:00:00', '1001819522', 1, 1157892760, 2710894, 'Enabled', '0223715077-vision'),
  (258, 'ashrafhamdy abdelhamed', 'aboammar3061975@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23715765', 18, '0000-00-00 00:00:00', '1150065883', 1, 1157916432, 2713259, 'Cancelled', '0223715765-vision'),
  (259, 'mohsenzoher ahmed', 'eng_ahmed2002us2003@uahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق  حلوان', '23715814', 18, '0000-00-00 00:00:00', NULL, 1, 1157999540, 2721472, 'Enabled', '0223715814-vision'),
  (260, 'mohamedali hassan', 'mohamedhassan58181@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '48271110', 18, '0000-00-00 00:00:00', '1142500107', 1, 1158081487, 2729346, 'Enabled', '0248271110-vision'),
  (261, 'samiraahmed ali', 'mtcharlii@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23700151', 18, '0000-00-00 00:00:00', '1066922995', 1, 1160345240, 2778358, 'Enabled', '0223700151-vision'),
  (262, 'MOHAMEDELBADRI ABOFADL', 'mido_mido27390@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23722708', 18, '0000-00-00 00:00:00', '1285442756', 1, 1160505039, 2794578, 'Enabled', '0223722708-VISION'),
  (263, 'twhidaahmed aid', 'eng_ahmed2002us2003@yhoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'المعادى', '25401995', 18, '0000-00-00 00:00:00', NULL, 1, 1160513631, 2795432, 'Enabled', '0225401995-vision'),
  (264, 'MichaelMaged Girgis', 'eng.michaelmaged@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23711418', 18, '0000-00-00 00:00:00', '1222999285', 1, 1160562469, 2800406, 'Enabled', '0223723345-VISION'),
  (265, 'ASMAAMOSTFA KMAL', 'asmaa.m.khedr@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'جدائق حلوان', '23722175', 18, '0000-00-00 00:00:00', '1220039752', 1, 1160585768, 2802833, 'Suspended Due to B&C I', '0223722175-VISION'),
  (266, 'gmalsaber bayomi', 'gamal_3aa@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'السيده زينب', '27418008', 18, '0000-00-00 00:00:00', '1280003549', 1, 1160762858, 2820711, 'Enabled', '0227418008-msan'),
  (267, 'mostfamohamed ibrahim', 'microrahma@Gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'لسيده زينب', '23636241', 18, '0000-00-00 00:00:00', '1149132349', 1, 1161097345, 2854050, 'Enabled', '0223636241-visionnn'),
  (268, 'MAGEDmohamed nabel', 'mmaan30@hotmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23693433', 18, '0000-00-00 00:00:00', '1006224082', 1, 1162114338, 2900030, 'Enabled', '0223693433-vision'),
  (269, 'ISLAMKMAL moawad', 'spaike2018@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23735849', 18, '0000-00-00 00:00:00', '1122496010', 1, 1164246366, 2931216, 'Enabled', '023735849-vision'),
  (270, 'hythamabdelmohsen ahmed', 'hytham.mohsen2012@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23736818', 18, '0000-00-00 00:00:00', '1008689676', 1, 1164344318, 2940104, 'Enabled', '0223736818-vision'),
  (271, 'TARIKZARIF ABDELHAKIM', 'eng_ahmed20002us2003@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23694742', 18, '0000-00-00 00:00:00', NULL, 1, 1170013863, 2947202, 'Enabled', '0223694742-VISION'),
  (272, 'حمودهعبد المعاطى حموده', 'eng_ahmed2002us2003@yahooo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '25522613', 18, '0000-00-00 00:00:00', NULL, 1, 1170126492, 2958214, 'Cancelled', '0225522613-visionnn'),
  (273, 'MOHMAEDSOBHI MOHAMED', 'mohamedsobhy08@gmail.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23739075', 18, '0000-00-00 00:00:00', '1002551363', 1, 1170209785, 2966275, 'Enabled', '0223739075-VISION'),
  (274, 'WFAAMOHAMED MAHMOUD', 'ENG_AHMED2992US2003@YAHOO.COM', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23739802', 18, '0000-00-00 00:00:00', NULL, 1, 1170279887, 2973024, 'Enabled', '0223739802-VISION'),
  (275, 'RAFFATALFI AYOUB', 'eng_ahmed2002us2002@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23752270', 18, '0000-00-00 00:00:00', NULL, 1, 1170407074, 2985041, 'Cancelled', '0223752270-raffat'),
  (276, 'FaridEl Ghonemy Kassem', 'fborham@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, 'حدائق حلوان', '23722611', 18, '0000-00-00 00:00:00', '1283030276', 1, 1172350292, 3037323, 'Enabled', '0223722611-visionnn'),
  (277, 'السيدمحمد عزوز', 'xfirst1@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '72 st hassan-mataria', '23718968', 18, '0000-00-00 00:00:00', '1110174749', 1, 1140982472, 2505351, 'Terminated', '0226505314-xfirst'),
  (278, 'mohmedhesen abdallah', 'MohmaedHU215@yahoo.com', '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, '3 Shimi Hussein -Hadayek Helwan-Floor1-Abt1', '23706077', 18, '0000-00-00 00:00:00', '1152879087', 1, 1120910936, 2113479, 'Terminated', '0223706077-vision'),
  (279, NULL, NULL, '', NULL, '2017-10-11 14:03:26', '2017-10-11 14:03:26', 0, NULL, NULL, NULL, '0000-00-00 00:00:00', NULL, 1, NULL, NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `comments`
  --
  
  CREATE TABLE `comments` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `ticket_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `comments`
  --
  
  INSERT INTO `comments` (`id`, `created_at`, `updated_at`, `comment`, `ticket_id`, `user_id`) VALUES
  (11, '2017-09-16 15:00:22', '2017-09-16 15:00:22', 'انا بفتح  التيكت  ده كمان', 2, 6),
  (10, '2017-09-16 14:57:47', '2017-09-16 14:57:47', 'سيبسيبسيب', 1, 6),
  (9, '2017-09-16 14:54:58', '2017-09-16 14:54:58', 'انا بفتح التيكت', 1, 6),
  (8, '2017-09-16 12:05:52', '2017-09-16 12:05:52', 'sdfdsfsdfsdfsdfsdf', 7, 8),
  (12, '2017-09-16 16:29:19', '2017-09-16 16:29:19', 'hgkkkk', 7, 7),
  (13, '2017-09-16 16:41:32', '2017-09-16 16:41:32', 'حلتها خلاص ', 2, 5),
  (14, '2017-09-16 16:42:09', '2017-09-16 16:42:09', 'ىىى', 2, 5),
  (15, '2017-09-16 17:32:09', '2017-09-16 17:32:09', 'برافو عليكم يا ولاد شرفتوني وانتو بتحلو التكت ', 2, 1),
  (16, '2017-09-16 17:33:22', '2017-09-16 17:33:22', 'hg', 2, 6),
  (17, '2017-09-17 05:19:07', '2017-09-17 05:19:07', 'حلتهاا ', 2, 5),
  (18, '2017-09-17 05:34:26', '2017-09-17 05:34:26', 'nnnnn', 6, 6),
  (19, '2017-09-17 05:54:48', '2017-09-17 05:54:48', 'المشكله دي ملهاش علاقه بقسمنا هي بتاعت ال سبورت ', 7, 6),
  (20, '2017-09-17 05:55:16', '2017-09-17 05:55:16', 'المشكله دي ملهاش علاقه بقسمنا هي بتاعت ال سبورت ', 7, 6),
  (21, '2017-09-17 06:00:37', '2017-09-17 06:00:37', 'يا ولا د التكت دي حلوها شطار خالص ', 4, 7),
  (22, '2017-09-17 06:02:10', '2017-09-17 06:02:10', 'انت يا ستاذ ابقي رةخ ادفع الافتولاه يا خويا قرفتو اهلينا ', 7, 5),
  (23, '2017-09-17 06:05:45', '2017-09-17 06:05:45', 'شرفتوني يا ولاااااااااد برافو ', 2, 1),
  (24, '2017-09-17 09:08:56', '2017-09-17 09:08:56', 'fdddddf', 14, 5),
  (25, '2017-09-19 07:42:21', '2017-09-19 07:42:21', 'nnnnn', 1, 1),
  (26, '2017-09-19 09:35:11', '2017-09-19 09:35:11', 'roiunnnnbjk;lbn  cgeh,j cfh.rbhrhrheb cen cbfe', 1, 1),
  (27, '2017-09-19 09:43:25', '2017-09-19 09:43:25', 'opppp', 1, 1),
  (28, '2017-09-19 21:35:41', '2017-09-19 21:35:41', 'sfdsfdsf', 5, 6),
  (29, '2017-09-19 21:37:03', '2017-09-19 21:37:03', 'sfdsfdsf', 5, 6),
  (30, '2017-09-19 21:39:09', '2017-09-19 21:39:09', 'sfdsfdsf', 5, 6),
  (31, '2017-09-19 21:40:05', '2017-09-19 21:40:05', 'sfdsfdsf', 5, 6),
  (32, '2017-09-19 21:41:56', '2017-09-19 21:41:56', 'sfdsfdsf', 5, 6),
  (33, '2017-09-19 21:43:07', '2017-09-19 21:43:07', 'sfdsfdsf', 5, 6),
  (34, '2017-09-19 21:43:59', '2017-09-19 21:43:59', 'sfdsfdsf', 5, 6),
  (35, '2017-09-19 22:01:23', '2017-09-19 22:01:23', 'adasdasdad', 4, 7),
  (36, '2017-09-19 22:03:11', '2017-09-19 22:03:11', 'adasdasdad', 4, 7),
  (37, '2017-09-19 22:04:19', '2017-09-19 22:04:19', 'adasdasdad', 4, 7),
  (38, '2017-09-19 22:05:23', '2017-09-19 22:05:23', 'adasdasdad', 4, 7),
  (39, '2017-09-19 22:39:38', '2017-09-19 22:39:38', 'mmmmmm', 11, 8),
  (40, '2017-09-19 22:47:25', '2017-09-19 22:47:25', 'nnnnnn', 7, 1),
  (41, '2017-09-20 08:42:08', '2017-09-20 08:42:08', 'ممكن تعمل رستارت للرواتر ', 19, 5),
  (42, '2017-09-20 09:19:58', '2017-09-20 09:19:58', 'mmmmmmmmmmmmm', 20, 6),
  (43, '2017-09-20 16:47:51', '2017-09-20 16:47:51', 'mmmmmmmmmmmmm', 22, 7),
  (44, '2017-09-23 14:23:20', '2017-09-23 14:23:20', 'ok inmgfdvnm', 22, 6),
  (45, '2017-09-23 14:32:10', '2017-09-23 14:32:10', 'ىلاىلالاىلالالاىىىى', 22, 5),
  (46, '2017-09-23 14:34:21', '2017-09-23 14:34:21', 'mmmmmmmbnu8jjnn', 24, 6),
  (47, '2017-09-23 15:37:03', '2017-09-23 15:37:03', 'nnnnn', 29, 6),
  (48, '2017-09-23 15:37:28', '2017-09-23 15:37:28', 'nnnnnn', 29, 5),
  (49, '2017-09-23 15:44:37', '2017-09-23 15:44:37', 'dgfdgdfgdfg', 29, 6),
  (50, '2017-09-23 15:46:43', '2017-09-23 15:46:43', 'dgdfgdfgdfgdfgd', 29, 6),
  (51, '2017-09-23 15:47:12', '2017-09-23 15:47:12', 'tyuytutyu', 29, 6),
  (52, '2017-09-23 15:50:20', '2017-09-23 15:50:20', 'sdfsdfsdfsdf', 29, 6),
  (53, '2017-09-23 16:16:50', '2017-09-23 16:16:50', 'fdgfdgdgdfgdg', 29, 6),
  (54, '2017-09-23 16:39:55', '2017-09-23 16:39:55', 'fgsdfsdfsdfdsfs', 29, 5),
  (55, '2017-09-23 16:50:42', '2017-09-23 16:50:42', 'erwerwe', 29, 6),
  (56, '2017-09-23 17:11:36', '2017-09-23 17:11:36', 'mmmmmmm', 20, 7),
  (57, '2017-09-23 18:03:20', '2017-09-23 18:03:20', 'mmm', 30, 7),
  (58, '2017-09-23 19:21:16', '2017-09-23 19:21:16', 'nnnnn', 31, 6),
  (59, '2017-09-24 09:08:00', '2017-09-24 09:08:00', 'check it', 33, 6),
  (60, '2017-09-24 18:06:18', '2017-09-24 18:06:18', 'mmmmmmmbnu8jjnn', 32, 6),
  (61, '2017-09-25 16:32:02', '2017-09-25 16:32:02', 'mmmmmmmmmmmmmmmm', 32, 6),
  (62, '2017-09-25 16:52:16', '2017-09-25 16:52:16', 'sfddsfsdf', 35, 6),
  (63, '2017-09-26 07:25:11', '2017-09-26 07:25:11', 'mmmkkkk', 38, 6),
  (64, '2017-09-26 08:49:13', '2017-09-26 08:49:13', 'mmmmmmmmmmmmmmmm', 25, 7),
  (65, '2017-09-26 08:53:39', '2017-09-26 08:53:39', 'bbbbbb', 39, 7),
  (66, '2017-09-26 09:15:08', '2017-09-26 09:15:08', 'dsdsccvfgggbbb', 37, 6),
  (67, '2017-09-26 09:25:23', '2017-09-26 09:25:23', 'this operation', 40, 6),
  (68, '2017-09-26 09:43:51', '2017-09-26 09:43:51', 'hhhhhhhhhhhhhhhhh', 42, 6),
  (69, '2017-09-26 10:50:52', '2017-09-26 10:50:52', 'tesdfff', 41, 7),
  (70, '2017-09-26 18:08:35', '2017-09-26 18:08:35', 'ddd', 37, 5),
  (71, '2017-09-26 18:12:09', '2017-09-26 18:12:09', 'sdfsdfs', 0, 8),
  (72, '2017-09-26 18:13:35', '2017-09-26 18:13:35', 'sdfsdfs', 0, 8),
  (73, '2017-09-26 18:13:54', '2017-09-26 18:13:54', 'sdfsdfs', 0, 8),
  (74, '2017-09-26 18:14:14', '2017-09-26 18:14:14', 'sdfsdfs', 0, 8),
  (75, '2017-09-26 18:16:35', '2017-09-26 18:16:35', 'sdfsdfs', 0, 8),
  (76, '2017-09-26 18:16:57', '2017-09-26 18:16:57', 'sdfsdfs', 41, 8),
  (77, '2017-09-26 18:31:22', '2017-09-26 18:31:22', 'sdffgsdfsdf', 41, 8),
  (78, '2017-09-28 00:25:37', '2017-09-28 00:25:37', 'سبسيسليلفا', 47, 17),
  (79, '2017-09-28 14:34:12', '2017-09-28 14:34:12', 'mmmmmmmmmmmmmmmm', 50, 19),
  (80, '2017-09-28 18:00:09', '2017-09-28 18:00:09', 'nnnnnnnnnnnnn', 52, 1),
  (81, '2017-10-01 13:42:14', '2017-10-01 13:42:14', 'aaaaaaaaaaaaaaaaaaaaaa', 54, 24);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2014_10_12_000000_create_users_table', 1),
  (2, '2014_10_12_100000_create_password_resets_table', 1),
  (3, '2017_09_11_081346_create_categories_table', 1),
  (4, '2017_09_11_081346_create_packets_table', 1),
  (5, '2017_07_26_100045_create_settings_table', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `networks`
  --
  
  CREATE TABLE `networks` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `networks`
  --
  
  INSERT INTO `networks` (`id`, `created_at`, `updated_at`, `name`) VALUES
  (17, '2017-09-19 06:38:20', '2017-09-19 06:38:20', 'Link Egypt'),
  (20, '2017-10-03 23:24:42', '2017-10-03 23:24:42', 'noor');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notitfaction`
  --
  
  CREATE TABLE `notitfaction` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `message` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
    `ticket_id` int(11) NOT NULL,
    `seen` int(11) NOT NULL,
    `user_id` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `notitfaction`
  --
  
  INSERT INTO `notitfaction` (`id`, `created_at`, `updated_at`, `message`, `ticket_id`, `seen`, `user_id`) VALUES
  (10, '2017-09-25 16:32:02', '2017-09-25 16:32:02', 'new ticketasads', 32, 0, 0),
  (11, '2017-09-25 16:52:16', '2017-09-25 16:58:30', 'new ticket : notify', 35, 1, 5),
  (12, '2017-09-26 07:25:11', '2017-09-26 07:25:39', 'new ticket : test 444', 38, 1, 5),
  (13, '2017-09-26 08:49:13', '2017-09-26 08:49:38', 'new ticket : inter bok', 25, 1, 8),
  (14, '2017-09-26 08:53:39', '2017-09-26 08:54:50', 'new ticket : test5', 39, 1, 8),
  (15, '2017-09-26 09:15:08', '2017-09-26 09:16:06', 'new ticket : test 45', 37, 1, 5),
  (16, '2017-09-26 09:25:23', '2017-09-26 09:25:52', 'new ticket : http interconnection', 40, 1, 5),
  (17, '2017-09-26 09:43:51', '2017-09-26 09:44:38', 'new ticket : mohamed ', 42, 1, 5),
  (18, '2017-09-26 10:50:52', '2017-09-26 10:51:18', 'new ticket : test 11', 41, 1, 8),
  (19, '2017-09-28 00:25:37', '2017-09-28 00:33:21', 'new ticket : 23724294', 47, 1, 13),
  (20, '2017-09-28 14:34:12', '2017-09-28 22:06:07', 'new ticket : test sales', 50, 1, 18),
  (21, '2017-10-01 13:42:14', '2017-10-01 13:42:50', 'new ticket : 23712668', 54, 1, 25),
  (22, '2017-10-01 13:43:08', '2017-10-01 14:59:00', 'ticket solved : 23712668', 54, 1, 1),
  (23, '2017-10-01 13:43:08', '2017-10-01 13:43:08', 'ticket solved : 23712668', 54, 0, 23),
  (24, '2017-10-01 13:43:08', '2017-10-01 13:43:08', 'ticket solved : 23712668', 54, 0, 19),
  (25, '2017-10-01 13:43:08', '2017-10-01 17:16:49', 'ticket solved : 23712668', 54, 1, 20),
  (26, '2017-10-01 13:43:08', '2017-10-01 13:43:26', 'ticket solved : 23712668', 54, 1, 24);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `packets`
  --
  
  CREATE TABLE `packets` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` int(11) NOT NULL,
    `cat_id` int(11) NOT NULL,
    `price` int(11) NOT NULL,
    `type` int(11) NOT NULL,
    `sale` int(11) NOT NULL,
    `limited` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `packets`
  --
  
  INSERT INTO `packets` (`id`, `created_at`, `updated_at`, `name`, `status`, `cat_id`, `price`, `type`, `sale`, `limited`) VALUES
  (1, '2017-09-11 19:38:06', '2017-09-11 19:38:06', '1GB', 0, 1, 90, 89, 1, 0),
  (2, '2017-09-11 20:49:06', '2017-09-11 20:49:06', '512', 0, 2, 12, 122, 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `permissions`
  --
  
  CREATE TABLE `permissions` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `permission_role`
  --
  
  CREATE TABLE `permission_role` (
    `permission_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `roles`
  --
  
  INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
  (1, 'salesManager', 'salesManager', NULL, NULL, NULL),
  (2, 'sales', 'sales', NULL, NULL, NULL),
  (3, 'supportManager', 'supportManager', NULL, NULL, NULL),
  (4, 'supports', 'supports', NULL, NULL, NULL),
  (5, 'admin', 'admin', NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `role_user`
  --
  
  CREATE TABLE `role_user` (
    `user_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `role_user`
  --
  
  INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
  (1, 5),
  (13, 2),
  (18, 2),
  (19, 1),
  (20, 3),
  (21, 2),
  (22, 4),
  (23, 1),
  (24, 3),
  (25, 4),
  (26, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE `settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `facebook` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `twiter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `instgram` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `google_plus` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `skype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `pinterest` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email_info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `website_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `logo_footer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `logo_footer_content` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `behance` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `meta_keyword` text COLLATE utf8_unicode_ci NOT NULL,
    `meta_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `meta_describtion` text COLLATE utf8_unicode_ci NOT NULL,
    `map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `blank_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `blank_content` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tickets`
  --
  
  CREATE TABLE `tickets` (
    `id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `client_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `type` int(11) NOT NULL,
    `status` int(11) NOT NULL,
    `periority` int(11) NOT NULL,
    `seen` int(11) NOT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `body` text COLLATE utf8_unicode_ci NOT NULL,
    `open_date` date DEFAULT NULL,
    `closed_date` date DEFAULT NULL,
    `views` int(11) NOT NULL,
    `employee_id` int(11) NOT NULL,
    `open_by` int(11) DEFAULT NULL,
    `close_by` int(11) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `tickets`
  --
  
  INSERT INTO `tickets` (`id`, `created_at`, `updated_at`, `client_id`, `user_id`, `type`, `status`, `periority`, `seen`, `title`, `body`, `open_date`, `closed_date`, `views`, `employee_id`, `open_by`, `close_by`) VALUES
  (54, '2017-09-28 22:53:52', '2017-10-17 16:58:14', 27, 18, 1, 2, 0, 0, '23712668', '<p>الانترنت والحراره فصلين ,dsl</p>\r\n', '2017-10-01', NULL, 28, 25, 25, NULL),
  (55, '2017-09-30 15:27:25', '2017-10-02 13:25:38', 25, 1, 0, 0, 0, 0, 'ertetet', '<p>ewrteter</p>\r\n', NULL, NULL, 4, 0, NULL, NULL),
  (53, '2017-09-28 15:05:09', '2017-10-01 17:17:43', 26, 13, 1, 0, 0, 0, '23731195', '<p><strong>كان ف مشكله فالتليفون الارضي و الحراره اتقطعغت و رجعت تاني بس التليفون بيرسل مش بيستقبل مكالمات و النت فاصل الـ Dsl &nbsp;مش ثابته ع طول و الانترنت مش ثابته</strong></p>\r\n\r\n<p><strong>Port :&nbsp;54<br />\r\nMoplie :&nbsp;1065520267</strong><br />\r\n&nbsp;</p>\r\n', NULL, NULL, 9, 0, NULL, NULL),
  (52, '2017-09-28 14:35:13', '2017-10-01 17:17:47', 25, 19, 1, 0, 0, 0, 'test sales 1', '<p>mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm</p>\r\n', NULL, NULL, 7, 0, NULL, NULL),
  (51, '2017-09-28 14:30:17', '2017-10-01 13:55:50', 24, 18, 1, 0, 0, 0, 'test support', '<p>popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsumpopularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsumpopularised in the 1960s with the release of Letraset sheets containing&nbsp;</p>\r\n', NULL, NULL, 2, 0, NULL, NULL),
  (50, '2017-09-28 14:29:53', '2017-09-28 22:06:07', 23, 18, 1, 0, 0, 0, 'test sales', '<p>popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsumpopularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsumpopularised in the 1960s with the release of Letraset sheets containing&nbsp;</p>\r\n', NULL, NULL, 5, 18, NULL, NULL),
  (47, '2017-09-27 20:34:36', '2017-10-01 17:17:55', 23, 13, 0, 0, 0, 0, '23724294', '<p>العميل الخدمه عنده بطيئه جدا&nbsp;<br />\r\n<span style=\"color:#8b4513\"><strong>Port Num : 1152</strong></span><br />\r\n&nbsp;</p>\r\n', NULL, NULL, 54, 0, NULL, NULL),
  (48, '2017-09-27 20:42:12', '2017-10-01 17:17:59', 24, 13, 1, 0, 0, 0, '23752099', '<p><strong>النت بطيئ جدا&nbsp;<br />\r\nPort Num : 11&nbsp;<br />\r\nMopile Num :&nbsp;1112631774</strong></p>\r\n', NULL, NULL, 10, 0, NULL, NULL),
  (49, '2017-09-27 21:10:24', '2017-10-01 17:21:22', 25, 13, 1, 0, 0, 0, '23695674', '<p>كمال راضي عزمي&nbsp;<br />\r\nال Dsl مش ثابته و الخدمه بتروح و تيجي&nbsp;<br />\r\nPort : 3479<br />\r\nMopile Num&nbsp; :&nbsp;1140635346&nbsp;<br />\r\n&nbsp;</p>\r\n', NULL, NULL, 13, 0, NULL, NULL),
  (57, '2017-10-01 13:58:11', '2017-10-01 15:28:46', 24, 1, 1, 0, 0, 0, 'test 11111', '<p>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaassssssssssssssssssvbgjmsfghjdsghsdghfdzshdzsndzaenaerbnaewrgbaewrvgbawesvawgfe</p>\r\n', NULL, NULL, 6, 0, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'admin', 'admin@dashboard.com', '$2y$10$PLIskfj7Tu1IWW.75WDznennC7lgx30NOePo.i0gRWGoCca.WRG9q', 'McesCG3IB71b2CLYqoTqjO6SUkPCmSYM96Xq2kaTPhYNH6yUOjA2DmwsuAWI', '2017-09-11 06:11:56', '2017-10-11 14:38:42'),
  (23, 'test sales m', 'moo@dashboard.com', '$2y$10$uEyg2XH1ftE./xibpBlzd.c145bwG8f/NtIF.6w0H7DPPx3e7i782', 'IrFqkWl84w19qiqR91are5QoPVwuhuQRxko9F8GD5Hu4OEBuUrOA3CGSVCle', '2017-10-01 13:19:42', '2017-10-01 17:47:23'),
  (22, 'mosab', 'mosab@dsl.com', '$2y$10$wt.z4imV..c14sfIN6p17eDyFZAw8vwablnharUHxWzmh7jOPVy0a', NULL, '2017-09-28 23:40:06', '2017-09-28 23:40:06'),
  (18, 'nada', 'nada@dsl-egypt.com', '$2y$10$2LkDJlB5cC/NrfhuC4S8x.QP2vTUJPKxAccYy3l3rKG8RZocJJOES', 'dWidYvV5sIebBdLLb1nF7nRlatTAhJuwjtD1WZUBHYtGOay1RsPOh07a0abg', '2017-09-28 00:30:18', '2017-09-28 14:38:03'),
  (19, 'ahmed', 's@dsl.com', '$2y$10$VhNdexlEqeRNKmmyMxxHjehnVLIW3TtHOzz8xMgVfX08BTS9mvwtu', 'G8ToqufLLZSrBBc4Z3fUbeEgag4UIvOADvllB3XhwHAtijQD7m1iiRnaT1ln', '2017-09-28 00:31:19', '2017-09-28 14:37:31'),
  (20, 'ahmed', 't@dsl.com', '$2y$10$OZDCG7TnEqWii74T452oteaShJV1vFNZ0z2mriXJ3jtW48Qvx7nUu', '09cMAJihFOSeQ2tCS4lOf2Bckbgr5lBHmTO8fW0eaQh8pAmSHkETMHzsRPYq', '2017-09-28 00:32:20', '2017-09-28 16:12:31'),
  (21, 'mahmoud', 'mahmoud@mahmoud.com', '$2y$10$LWX9cPJw46n0IrM.ubvvYOOrJ0MWG/6z6IrSZEyyui3/2guWbExv.', NULL, '2017-09-28 12:46:01', '2017-09-28 12:46:01'),
  (13, 'Omina', 'omnia@dsl-egypt.com', '$2y$10$WBrY/gqdVrL4U/TjJvavTOakBT.wgQX9FORbEjd6tdcRszW.5xijK', 'nd1w6cCrQTA5UaV87fz9sitGq423B3f1prK0qBOyINtU1CV8up5N5QKBBIgG', '2017-09-27 19:11:58', '2017-09-28 00:18:13'),
  (24, 'test Support  M', 'moo2@dashboard.com', '$2y$10$/9mk.elm.XtjQtPt42Pk/.Yo.145lU65RJ9yT8XOn1tyYbg0YV2T.', 'O1PGf1yZDpdWGeCpUZk3bwtIeczcr7588sURJPDjpSvKUHTnPjPYnVmGAtSP', '2017-10-01 13:25:26', '2017-10-01 14:06:37'),
  (25, 'test  S', 'moo3@dashboard.com', '$2y$10$Y4W9yQD5eAqWoc.PBZxDQeL4xKGUuRd4GLEhV3JoLoA00Z6Fa9la6', 'GAXn1JTx62lmdOhRlSVvKF6C1XyOLeKkMmMQlT5jvfoV21UOJeHb3JGm0KjO', '2017-10-01 13:30:01', '2017-10-02 13:30:04'),
  (26, 'test supprot', 'moo4@dashboard.com', '$2y$10$v0133ZDWcTH.o2./u4eKgu3ZH4k.qjydXWu/pxr25xtIYhiq/UKDS', 'cD2nAevv5B7AZilMm8DUnRnywIljwCqS0BSORnprMQhJdtASAQepSmp4AdsN', '2017-10-01 13:48:26', '2017-10-01 14:04:22');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `clients`
  --
  ALTER TABLE `clients`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `comments`
  --
  ALTER TABLE `comments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `networks`
  --
  ALTER TABLE `networks`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `notitfaction`
  --
  ALTER TABLE `notitfaction`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `packets`
  --
  ALTER TABLE `packets`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indexes for table `permissions`
  --
  ALTER TABLE `permissions`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `permissions_name_unique` (`name`);
  
  --
  -- Indexes for table `permission_role`
  --
  ALTER TABLE `permission_role`
    ADD PRIMARY KEY (`permission_id`,`role_id`),
    ADD KEY `permission_role_role_id_foreign` (`role_id`);
  
  --
  -- Indexes for table `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `roles_name_unique` (`name`);
  
  --
  -- Indexes for table `role_user`
  --
  ALTER TABLE `role_user`
    ADD PRIMARY KEY (`user_id`,`role_id`),
    ADD KEY `role_user_role_id_foreign` (`role_id`);
  
  --
  -- Indexes for table `settings`
  --
  ALTER TABLE `settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `tickets`
  --
  ALTER TABLE `tickets`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `clients`
  --
  ALTER TABLE `clients`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=280;
  --
  -- AUTO_INCREMENT for table `comments`
  --
  ALTER TABLE `comments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `networks`
  --
  ALTER TABLE `networks`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  --
  -- AUTO_INCREMENT for table `notitfaction`
  --
  ALTER TABLE `notitfaction`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  --
  -- AUTO_INCREMENT for table `packets`
  --
  ALTER TABLE `packets`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `permissions`
  --
  ALTER TABLE `permissions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `settings`
  --
  ALTER TABLE `settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `tickets`
  --
  ALTER TABLE `tickets`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  