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

START TRANSACTION;



--
-- Database: `nutrifik_diaa`
--

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `url` text COLLATE utf8_bin NOT NULL,
  `cat` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` (`id`, `name`, `name_en`, `notes`, `photo`, `start_date`, `end_date`, `url`, `cat`) VALUES
(7, 'solom', 'Drinks2', '', '../img/652d0eea3ab8a9afd8719cc584253a4c.64056762-frische-.jpg', '2018-09-08', '2018-09-08', '2dewcdedc', 2),
(8, 'solom', 'Drinks2', '', '../img/686097f2a317b132189254c8efc7ade4.12524123_773350686132591_2072248803036001107_n.png', '2018-10-17', '2018-10-17', '2dewcdedcxxxxxxxxx', 1),
(10, 'solom', 'Drinks2', '', '../img/39ac91f2a28396c0057f2677e2a8fda3.14055075_848538148613844_774274863360892098_n.jpg', '2018-10-27', '2018-10-27', '2dewcdedc', 1);

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

--
-- Table structure for table `app_settings`
--

CREATE TABLE `app_settings` (
  `id` int(11) NOT NULL,
  `appname` text COLLATE utf8_bin NOT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `share_link` text COLLATE utf8_bin NOT NULL,
  `invoice_header` text COLLATE utf8_bin NOT NULL,
  `invoice_footer` text COLLATE utf8_bin NOT NULL,
  `cat_photo` text COLLATE utf8_bin NOT NULL,
  `cat_photo_en` text COLLATE utf8_bin NOT NULL,
  `notifcation_appid` text COLLATE utf8_bin NOT NULL,
  `notifcation_icon` text COLLATE utf8_bin NOT NULL,
  `admin_lang` varchar(10) COLLATE utf8_bin NOT NULL,
  `d_c` int(11) NOT NULL,
  `s_c` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `app_settings`
--

INSERT INTO `app_settings` (`id`, `appname`, `name_en`, `share_link`, `invoice_header`, `invoice_footer`, `cat_photo`, `cat_photo_en`, `notifcation_appid`, `notifcation_icon`, `admin_lang`, `d_c`, `s_c`) VALUES
(1, '2تطبيق نترفكس    ', 'nutrifix app', 'sxxssssssssssssssssss2', 'ssssssssssss2', 'sssssssssssss2', '../img/6318d3c5f897f3bce7542a3e9236bdb6.download (1).jpg', '../img/83489af06c221ea5ab18edbe7cb56944.download (1).jpg', '', '../img/bfc90867b7ddedc512029d507bf633df.download (1).jpg', 'EN', 18, 19),
(3, 'Nutrifiks2', 'Nutrifiks2', 'Nutrifiks healthy lifestyle app\r\n\r\n', '', '', 'image2/b6aef86083b784fdf8a5418bb69d66a1.avatar-03.jpg', 'image3/c21721f351b4c39bf61f7d9a987615e5.avatar-05.jpg', '', 'image/22ee64535a462675b9066169a93091c8.avatar-02.jpg', 'EN', 18, 18);

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

--
-- Table structure for table `block_products`
--

CREATE TABLE `block_products` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_id` varchar(40) COLLATE utf8_bin NOT NULL,
  `item_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `type_plate` varchar(100) COLLATE utf8_bin NOT NULL,
  `extra_items` text COLLATE utf8_bin NOT NULL,
  `price` int(11) NOT NULL,
  `extra_total` int(11) NOT NULL,
  `sub_total` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `inv_id` text COLLATE utf8_bin NOT NULL,
  `status` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `comments` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `content` text COLLATE utf8_bin NOT NULL,
  `send_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` text COLLATE utf8_bin NOT NULL,
  `order_id` varchar(60) COLLATE utf8_bin NOT NULL,
  `c_date` date NOT NULL,
  `user_read` int(11) NOT NULL,
  `store_read` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `lat` text COLLATE utf8_bin NOT NULL,
  `lon` text COLLATE utf8_bin NOT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `country_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`id`, `name`, `lat`, `lon`, `name_en`, `country_id`) VALUES
(16, 'جده', '', '', 'Jeddah', 2),
(17, 'الدمام', '', '', 'Dammam', 2),
(18, 'الرياض', '', '', 'Riyadh', 2),
(19, 'المدينة المنورة ', '', '', 'Al Madina', 2),
(20, 'مكة المكرمة', '', '', 'Mekkah', 2);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `email` text COLLATE utf8_bin NOT NULL,
  `mobile` text COLLATE utf8_bin NOT NULL,
  `status` int(11) NOT NULL,
  `active` int(11) NOT NULL,
  `block` int(11) NOT NULL,
  `password` text COLLATE utf8_bin NOT NULL,
  `active_code` text COLLATE utf8_bin NOT NULL,
  `city` int(11) NOT NULL,
  `places` int(11) NOT NULL,
  `device_id` text COLLATE utf8_bin NOT NULL,
  `c_date` date NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL,
  `player_id` text COLLATE utf8_bin NOT NULL,
  `forget_key` text COLLATE utf8_bin NOT NULL,
  `facebook` text COLLATE utf8_bin NOT NULL,
  `twitter` text COLLATE utf8_bin NOT NULL,
  `instagram` text COLLATE utf8_bin NOT NULL,
  `trans_date` date NOT NULL,
  `type` varchar(255) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `name`, `email`, `mobile`, `status`, `active`, `block`, `password`, `active_code`, `city`, `places`, `device_id`, `c_date`, `photo`, `player_id`, `forget_key`, `facebook`, `twitter`, `instagram`, `trans_date`, `type`) VALUES
(14, 'Ahsan Nawaz', 'ahsan.nawa--z@gmail.com', '966507333162', 1, 0, 0, '123456', '3008', 0, 0, '', '2019-05-07', '', '', '', '', '', '', '0000-00-00', ''),
(18, 'gf fg', 'test@gmail.com', '966507333163', 1, 0, 0, '121212', '6595', 0, 0, '', '2019-05-12', '', '', '', '', '', '', '0000-00-00', '');

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

--
-- Table structure for table `clients_tans`
--

CREATE TABLE `clients_tans` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `type` varchar(10) COLLATE utf8_bin NOT NULL,
  `amount` int(11) NOT NULL,
  `client_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `client_details`
--

CREATE TABLE `client_details` (
  `id` int(11) UNSIGNED NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `age` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `height_unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight_unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` decimal(8,2) DEFAULT NULL,
  `how_active_you_are` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fitness_goal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_details`
--

INSERT INTO `client_details` (`id`, `client_id`, `age`, `gender`, `height_unit`, `height`, `weight_unit`, `weight`, `how_active_you_are`, `fitness_goal`, `created_at`, `updated_at`) VALUES
(1, 16, '19', 'Female', 'Centimeters', '19', '19', NULL, 'Moderate', 'Gain', NULL, '0000-00-00 00:00:00'),
(2, 18, '4', 'Male', 'Feet/Inches', '19', 'Pound', '19.00', 'Light', 'Gain', NULL, '0000-00-00 00:00:00');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `comment` text COLLATE utf8_bin NOT NULL,
  `c_date` datetime NOT NULL,
  `status` int(11) NOT NULL,
  `type` varchar(30) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `key` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `name`, `name_en`, `key`) VALUES
(2, 'السعودية', 'saudia arabia', 33);

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

--
-- Table structure for table `delivery_price`
--

CREATE TABLE `delivery_price` (
  `id` int(11) NOT NULL,
  `km` int(11) NOT NULL,
  `price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `delivery_price`
--

INSERT INTO `delivery_price` (`id`, `km`, `price`) VALUES
(1, 1, 1),
(2, 20, 603),
(5, 0, 0);

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL,
  `name` varchar(150) COLLATE utf8_bin NOT NULL,
  `cat` varchar(255) COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin,
  `photo` text COLLATE utf8_bin NOT NULL,
  `main` int(11) DEFAULT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `notes_en` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `cat`, `notes`, `photo`, `main`, `name_en`, `notes_en`) VALUES
(1, 'وجبات صحية', '0', '', 'image/f02544155742fe7bd2acdbefb5377558.12524123_773350686132591_2072248803036001107_n.png', 0, 'HEALTHY Meals', ''),
(2, 'العصائر', '0', '', 'image/0e80627b065f42ceda0f4464845f2c65.14055075_848538148613844_774274863360892098_n.jpg', 0, 'JUICES', ''),
(3, 'لياقة بدنية&ااضافات صحية', '0', '', 'image/9113d1fb04f713f1aeb47559f70d98d0.12524123_773350686132591_2072248803036001107_n.png', 0, 'FITNESS & HEALTH SUPPLEMENTS', ''),
(4, 'عضوى', '0', '', 'image/9113d1fb04f713f1aeb47559f70d98d0.12524123_773350686132591_2072248803036001107_n.png', 0, 'ORGANICS', '');

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

--
-- Table structure for table `drivers`
--

CREATE TABLE `drivers` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `email` text COLLATE utf8_bin NOT NULL,
  `mobile` text COLLATE utf8_bin NOT NULL,
  `password` text COLLATE utf8_bin NOT NULL,
  `active` int(11) NOT NULL,
  `active_code` text COLLATE utf8_bin NOT NULL,
  `block` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `places` int(11) NOT NULL,
  `device_id` text COLLATE utf8_bin NOT NULL,
  `c_date` date NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL,
  `licence_id` text COLLATE utf8_bin NOT NULL,
  `national_id` text COLLATE utf8_bin NOT NULL,
  `bank_account` text COLLATE utf8_bin NOT NULL,
  `vehicle` text COLLATE utf8_bin NOT NULL,
  `vehicle_no` text COLLATE utf8_bin NOT NULL,
  `trans_date` date NOT NULL,
  `mobile2` varchar(20) COLLATE utf8_bin NOT NULL,
  `lat` float NOT NULL,
  `lon` float NOT NULL,
  `online` int(11) NOT NULL,
  `rating` int(11) NOT NULL DEFAULT '5',
  `view` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `drivers`
--

INSERT INTO `drivers` (`id`, `name`, `email`, `mobile`, `password`, `active`, `active_code`, `block`, `city`, `places`, `device_id`, `c_date`, `photo`, `licence_id`, `national_id`, `bank_account`, `vehicle`, `vehicle_no`, `trans_date`, `mobile2`, `lat`, `lon`, `online`, `rating`, `view`) VALUES
(1, 'alaa ', 'diaataial@gmail.com', '123', '123123', 0, '', 1, 4, 0, '123', '2018-05-21', 'image/9b4450657b729805699f580026d3c119.download (1).jpg', 'image2/d4667ee8a72fe0f6700a7b985f9b8a97.download (2).jpg', 'image3/4a6691c609e4d04769c91b4b6f2d5358.download (3).jpg', '', '', '23423', '0000-00-00', '', 24.811, 46.7629, 1, 5, 1),
(2, 'amged', 'diaataial@gmail.com', '966123456789', '123123', 0, '', 0, 5, 0, '121', '2018-05-21', 'image/9b4450657b729805699f580026d3c119.download (1).jpg', 'image2/d4667ee8a72fe0f6700a7b985f9b8a97.download (2).jpg', 'image3/4a6691c609e4d04769c91b4b6f2d5358.download (3).jpg', '', '', '23423', '2018-09-17', '', 0, 0, 0, 5, 1),
(9, 'maged', 'admin@admin', '122', '123', 0, '', 0, 5, 1, '', '0000-00-00', '', '', '', '', '', '123', '0000-00-00', '', 0, 0, 0, 5, 0),
(10, 'nabil', 'admin@admin', '1111', '1222', 0, '', 0, 5, 5, '', '2018-10-27', '', '', '', '', '', '122', '0000-00-00', '', 0, 0, 0, 5, 0);

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

--
-- Table structure for table `drivers_trans`
--

CREATE TABLE `drivers_trans` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `type` varchar(10) COLLATE utf8_bin NOT NULL,
  `amount` int(11) NOT NULL,
  `driver` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `drivers_trans`
--

INSERT INTO `drivers_trans` (`id`, `date`, `type`, `amount`, `driver`) VALUES
(1, '2018-08-09', '1', 33, 1),
(2, '2018-08-16', '2', 36, 1);

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

--
-- Table structure for table `driver_invoice`
--

CREATE TABLE `driver_invoice` (
  `id` int(11) NOT NULL,
  `invoice_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `commision` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `total_sale` varchar(255) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `trans_date` date DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `t_status` int(11) NOT NULL,
  `confirm` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `driver_invoice`
--

INSERT INTO `driver_invoice` (`id`, `invoice_no`, `commision`, `total_sale`, `status`, `trans_date`, `name`, `t_status`, `confirm`) VALUES
(1, '1', '2', '21', 1, '2018-09-09', 'ماكدونالدز ', 1, 1),
(2, '2', '222', '22', 0, '2018-09-05', 'ماكدونالدز ', 0, 0),
(3, '3', '', '23', 1, '2018-09-08', 'كنتاكي ', 0, 0),
(4, '3', '0', '24', 1, '0000-00-00', 'كنتاكي 1', 0, 0),
(5, '2', '80.82', '25', 0, '2018-05-21', 'diaa tayle 2', 0, 0),
(6, '6', '0', '26', 0, '2018-06-27', 'solom', 0, 0),
(7, '2', '80.82', '27', 1, '2018-09-15', 'diaa tayle 2', 1, 1),
(8, '1', '3.78', '28', 1, '2018-07-09', 'diaa tayel ', 1, 1),
(9, '1', '3.78', '29', 1, '2018-07-09', 'diaa tayel ', 1, 1),
(10, '2', '80.82', '449', 0, '2018-05-21', 'diaa tayle 2', 0, 0),
(11, '1', '7.98', '42', 1, '2018-09-16', 'diaa tayel ', 1, 0),
(12, '1', '11.97', '63', 1, '0000-00-00', 'diaa tayel ', 1, 0),
(13, '1', '11.97', '63', 0, '0000-00-00', 'diaa tayel ', 0, 0);

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

--
-- Table structure for table `email`
--

CREATE TABLE `email` (
  `id` int(11) NOT NULL,
  `sender` text COLLATE utf8_bin NOT NULL,
  `reg_msg` text COLLATE utf8_bin NOT NULL,
  `forget_msg` text COLLATE utf8_bin NOT NULL,
  `store_order` text COLLATE utf8_bin,
  `user_order` text COLLATE utf8_bin,
  `order_status` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `email`
--

INSERT INTO `email` (`id`, `sender`, `reg_msg`, `forget_msg`, `store_order`, `user_order`, `order_status`) VALUES
(2, 'dogy3', '', 'pady22222222222222', '', 'pady1233333333333333333333333', 'pady12');

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

--
-- Table structure for table `fav_list`
--

CREATE TABLE `fav_list` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `type` varchar(30) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `meals_category`
--

CREATE TABLE `meals_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `name_en` varchar(255) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `meal_cart`
--

CREATE TABLE `meal_cart` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `ext_id` int(11) NOT NULL,
  `ext_price` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `sub_total` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `order_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `inv_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `store_id` int(11) NOT NULL,
  `user_order_id` varchar(255) COLLATE utf8_bin NOT NULL,
  `branch_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `content` text COLLATE utf8_bin NOT NULL,
  `status` int(11) NOT NULL,
  `c_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(30) COLLATE utf8_bin NOT NULL,
  `item_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `sub_total` int(11) NOT NULL,
  `total_vat` int(11) NOT NULL,
  `distance` int(11) NOT NULL,
  `delivery_change` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `c_date` date NOT NULL,
  `order_id` varchar(20) COLLATE utf8_bin NOT NULL,
  `order_date` date NOT NULL,
  `order_time` time NOT NULL,
  `device_id` varchar(20) COLLATE utf8_bin NOT NULL,
  `inv_id` text COLLATE utf8_bin NOT NULL,
  `lat` float NOT NULL,
  `lon` float NOT NULL,
  `address` text COLLATE utf8_bin NOT NULL,
  `instructions` text COLLATE utf8_bin NOT NULL,
  `branch_id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `checkout_type` varchar(255) COLLATE utf8_bin NOT NULL,
  `discount` varchar(100) COLLATE utf8_bin NOT NULL,
  `pickup_time` text COLLATE utf8_bin NOT NULL,
  `city` int(11) NOT NULL,
  `reason` text COLLATE utf8_bin NOT NULL,
  `reason_en` text COLLATE utf8_bin NOT NULL,
  `vat_number` int(11) NOT NULL,
  `time_picked_up` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_bin NOT NULL,
  `descr` text COLLATE utf8_bin NOT NULL,
  `type` varchar(40) COLLATE utf8_bin NOT NULL,
  `descr_en` text COLLATE utf8_bin NOT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `name`, `descr`, `type`, `descr_en`, `name_en`) VALUES
(2, 'bbbbbbb', '<b><h1>bbbbbbbbb</h1><br></b><u><small></small></u>', 'app', '<i><b><h1>nnnnnnnnnnnnn</h1></b></i><br><br>', 'nnnnnnnnnn'),
(3, 'sof', 'so1fff', 'app', '<b><i></i></b><b><u><h1></h1></u></b><h1><u><small></small></u><small><b><blockquote><ol><li><b><blockquote><b><blockquote>so3<img alt=\"\"><img alt=\"\"></blockquote></b></blockquote></b><br></li></ol></blockquote></b></small><u><small></small></u></h1><b><u><h1></h1></u></b><u><h1><b></b></h1></u><b><i></i></b><b></b>', 'so2');

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

--
-- Table structure for table `places`
--

CREATE TABLE `places` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `city_id` int(11) DEFAULT NULL,
  `country_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `places`
--

INSERT INTO `places` (`id`, `name`, `name_en`, `city_id`, `country_id`) VALUES
(13, 'العليه', 'Olaya', 18, 2),
(14, 'القرطبة', 'Quortoba', 18, 2),
(15, 'القرطبة', 'Ad Difa', 18, 2),
(16, 'القرطبة', 'Al Ammal', 18, 2),
(17, 'القرطبة', 'Al Andalus', 18, 2),
(18, 'القرطبة', 'Al Aqiq', 18, 2),
(19, 'القرطبة', 'Al Arid', 18, 2),
(20, 'القرطبة', 'Al Awali', 18, 2),
(21, 'القرطبة', 'Al Aziziyah', 18, 2),
(22, 'dsdfsdsdf', 'Al batha', 18, 2),
(23, 'dsdfsdsdf', 'Al Badiah', 18, 2),
(25, 'Al Baria', 'Al Baria', 18, 2),
(26, 'Al Bujairi Al Diriyah', 'Al Bujairi Al Diriyah', 18, 2),
(28, 'Al Bujairi Al Diriyah', 'Al Dar Al Baida', 18, 2),
(29, 'Al Bujairi Al Diriyah', 'AL Dhubbat', 18, 2),
(31, 'Al Bujairi Al Diriyah', 'AL Dirah', 18, 2),
(32, 'Al Bujairi Al Diriyah', 'AL Diriyah', 18, 2),
(33, 'Al Bujairi Al Diriyah', 'Al Diriyah Al Jadidah ', 18, 2),
(34, 'Al Bujairi Al Diriyah', 'Al Dubiyah', 18, 2),
(35, 'Al Bujairi Al Diriyah', 'Al Duraihimiyah', 18, 2),
(36, 'Al Bujairi Al Diriyah', 'Al Faiha', 18, 2),
(37, 'Al Bujairi Al Diriyah', 'Al Faisaliyah', 18, 2),
(38, 'Al Bujairi Al Diriyah', 'Al Faisaliyah Al Diriyah', 18, 2),
(39, 'Al Bujairi Al Diriyah', 'Al Fakhiriyah', 18, 2),
(40, 'Al Bujairi Al Diriyah', 'Al Falah', 18, 2),
(41, 'Al Bujairi Al Diriyah', 'Al Faruq', 18, 2),
(42, 'Al Bujairi Al Diriyah', 'Al Futah', 18, 2),
(43, 'Al Bujairi Al Diriyah', 'Al Ghadir', 18, 2);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `cat` int(11) NOT NULL,
  `sub_cat` text COLLATE utf8_bin NOT NULL,
  `details` text COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `store_id` int(11) NOT NULL,
  `meals_cat_id` int(11) NOT NULL,
  `c_date` date NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL,
  `city` int(11) NOT NULL,
  `name_en` text COLLATE utf8_bin NOT NULL,
  `notes_en` text COLLATE utf8_bin NOT NULL,
  `details_en` text COLLATE utf8_bin NOT NULL,
  `calories` text COLLATE utf8_bin NOT NULL,
  `carbs` text COLLATE utf8_bin NOT NULL,
  `proteins` text COLLATE utf8_bin NOT NULL,
  `fats` text COLLATE utf8_bin NOT NULL,
  `from_time` time NOT NULL,
  `to_time` time NOT NULL,
  `available` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `extra_price` varchar(255) COLLATE utf8_bin NOT NULL,
  `price_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `price_name_en` varchar(255) COLLATE utf8_bin NOT NULL,
  `extra_gram` varchar(255) COLLATE utf8_bin NOT NULL,
  `extra_protein` varchar(255) COLLATE utf8_bin NOT NULL,
  `extra_carbs` varchar(255) COLLATE utf8_bin NOT NULL,
  `extra_fats` varchar(255) COLLATE utf8_bin NOT NULL,
  `extra_calories` varchar(255) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `type`, `name`, `cat`, `sub_cat`, `details`, `notes`, `store_id`, `meals_cat_id`, `c_date`, `photo`, `city`, `name_en`, `notes_en`, `details_en`, `calories`, `carbs`, `proteins`, `fats`, `from_time`, `to_time`, `available`, `price`, `extra_price`, `price_name`, `price_name_en`, `extra_gram`, `extra_protein`, `extra_carbs`, `extra_fats`, `extra_calories`) VALUES
(1, 'product', 'freshness', 1, '1', 'cmbcvmbvmv', '', 3, 0, '2018-11-19', '../img/6ed304a98a445803aa668043a3373585.jpgcucumber apple mint.jpg', 4, 'freshness', '', 'kjkjkjv,v', '33', '44', '11', '33', '00:00:00', '00:10:00', 1, 13, ',2', 'HGDHDH', 'YDHD', '100,1,1', ',', ',', ',', ','),
(2, 'product', 'اسو بيور', 3, '2', 'Protein powder\r\nNo Fat, No Sugar', '', 6, 0, '2018-11-22', '../img/ed693584cf8dde810e89a4097437d0d2.jpg9_021e8f5d-9064-4547-ae34-48d6e0f8db8d_grande.jpg', 18, 'IsoPure', '', 'Protein powder\r\nNo Fat, No Sugar', '240', '2', '25', '1', '03:00:00', '03:00:00', 1, 240, '', '', '', '500,5', '', '', '', ''),
(3, 'product', 'Chicken Steak', 1, '3', 'Very tasty', '', 13, 0, '2018-12-05', '', 18, 'Chicken Steak', '', 'Very tasty', '450', '13', '27', '5', '15:16:00', '20:16:00', 1, 36, ',5', 'Tahini', 'Tahini', '500,,50', ',3', ',2', ',7', ',125');

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

--
-- Table structure for table `products_price`
--

CREATE TABLE `products_price` (
  `id` int(11) NOT NULL,
  `store_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `branch_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `item_id` int(11) NOT NULL,
  `price` text CHARACTER SET utf8 COLLATE utf8_bin,
  `available` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_price`
--

INSERT INTO `products_price` (`id`, `store_id`, `branch_id`, `item_id`, `price`, `available`) VALUES
(1, '3', '1', 1, '55', 0),
(2, '3', '1', 1, NULL, 1);

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

--
-- Table structure for table `promo_codes`
--

CREATE TABLE `promo_codes` (
  `id` int(11) NOT NULL,
  `code` varchar(30) COLLATE utf8_bin NOT NULL,
  `exp_h` int(11) NOT NULL,
  `to_client` int(11) NOT NULL,
  `discount` int(11) NOT NULL,
  `used` int(11) NOT NULL,
  `c_date` datetime NOT NULL,
  `u_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `promo_codes`
--

INSERT INTO `promo_codes` (`id`, `code`, `exp_h`, `to_client`, `discount`, `used`, `c_date`, `u_date`) VALUES
(18, 'HCfu2b', 12, 6, 12, 0, '0000-00-00 00:00:00', '2018-10-27 13:15:53');

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8_bin NOT NULL,
  `email` varchar(100) COLLATE utf8_bin NOT NULL,
  `logo` varchar(150) COLLATE utf8_bin NOT NULL,
  `phone` varchar(20) COLLATE utf8_bin NOT NULL,
  `mobile` varchar(20) COLLATE utf8_bin NOT NULL,
  `address` varchar(150) COLLATE utf8_bin NOT NULL,
  `adminkey` text COLLATE utf8_bin NOT NULL,
  `work_hours` int(11) NOT NULL,
  `splash` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `name`, `email`, `logo`, `phone`, `mobile`, `address`, `adminkey`, `work_hours`, `splash`) VALUES
(1, 'هات ', 'support@familiesproduct.com', '/images/Configuration/fa586d65b9c6606f4ca47f81ff1550d2.png', '0563835501', '0563835501', 'المملكة العربية السعودية', 'admin123', 0, '');

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

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `id` int(11) NOT NULL,
  `api` text COLLATE utf8_bin NOT NULL,
  `reg_msg` text COLLATE utf8_bin NOT NULL,
  `forget_msg` text COLLATE utf8_bin NOT NULL,
  `mobile_msg` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `sms`
--

INSERT INTO `sms` (`id`, `api`, `reg_msg`, `forget_msg`, `mobile_msg`) VALUES
(2, 'f73ebb1b5325ddd3be05785ec6381706', 'Your Activation Code Is #ACTIVE_CODE#', 'z1', '');

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

--
-- Table structure for table `sms_key`
--

CREATE TABLE `sms_key` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `code` text COLLATE utf8_bin NOT NULL,
  `key` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `sms_key`
--

INSERT INTO `sms_key` (`id`, `name`, `code`, `key`) VALUES
(8, 'السعودية', 'السعودية', 966),
(10, 'الكويت', 'الكويت', 965),
(11, 'الامارات', 'الامارات', 971),
(12, 'البحرين', 'البحرين', 973);

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

--
-- Table structure for table `social`
--

CREATE TABLE `social` (
  `id` int(11) NOT NULL,
  `name` varchar(150) COLLATE utf8_bin NOT NULL,
  `url` text COLLATE utf8_bin NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `social`
--

INSERT INTO `social` (`id`, `name`, `url`, `photo`) VALUES
(1, 'admin', 'sded\r\n', '../img/87e5625bee77ec20a105b2772091e28b.12524123_773350686132591_2072248803036001107_n.png'),
(3, 'soliman2', 'fvfvf', 'image/30735803a4019103091ac515dfd11330.download (6).jpg');

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

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

CREATE TABLE `start` (
  `id` int(11) NOT NULL,
  `name` text COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `photo` text COLLATE utf8_bin NOT NULL,
  `photo_en` text COLLATE utf8_bin NOT NULL,
  `sort` int(11) NOT NULL,
  `url` text COLLATE utf8_bin NOT NULL,
  `cat` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

INSERT INTO `start` (`id`, `name`, `notes`, `photo`, `photo_en`, `sort`, `url`, `cat`) VALUES
(13, '', '', '../img/76156affbdaee88e92d5a2f7b57ada1d.12524123_773350686132591_2072248803036001107_n.png', '../img/7370a4e2d543e24ccc7714f12f3d83a4.12524123_773350686132591_2072248803036001107_n.png', 0, '', 0),
(27, '', '', 'image/f0952a50474d97aafac39a918b3394ae.download (8).jpg', 'image2/0d25c734802cf768395634fa9673ac03.download (9).jpg', 0, '', 0),
(31, '', '', 'image/9438e0bf007d80dda384f1999e4e697a.download (7).jpg', 'image2/fc27a5d2206eccfecffc275ddbd9bac8.download (6).jpg', 0, '', 0),
(32, '', '', 'image/4333c597da355d04f6b313a15d146331.download (1).png', 'image2/fce40f257a6c2f9bcbd0b1f562a8e276.Desert.jpg', 0, '', 0),
(36, '', '', '../img/68209dc20595f15c48ddcfbe866ef7b1.12524123_773350686132591_2072248803036001107_n.png', '../img/79da9938d61a8bb4ddeead82d229441a.57febb445393d8e7fd5949182800a989.jpg', 0, '', 0);

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

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` int(11) NOT NULL,
  `name_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `company_photo` longtext COLLATE utf8_bin NOT NULL,
  `department` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_fname_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_lname_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_fname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_lname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `owner_mobile` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `commercial_no` int(11) DEFAULT NULL,
  `id_no` int(11) DEFAULT NULL,
  `crphoto` longtext COLLATE utf8_bin,
  `idphoto` longtext COLLATE utf8_bin,
  `bank_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `bank_account` text COLLATE utf8_bin,
  `iban` text COLLATE utf8_bin,
  `bank_photo` longtext COLLATE utf8_bin,
  `user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `password` text COLLATE utf8_bin,
  `c_password` text COLLATE utf8_bin,
  `lang` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `status` int(11) NOT NULL,
  `active` int(11) NOT NULL,
  `block` int(11) NOT NULL,
  `country` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `place` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `c_date` date NOT NULL,
  `commission` int(11) NOT NULL,
  `branches` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `stores`
--

INSERT INTO `stores` (`id`, `name_en`, `name`, `company_photo`, `department`, `owner_fname_en`, `owner_lname_en`, `owner_fname`, `owner_lname`, `owner_mobile`, `commercial_no`, `id_no`, `crphoto`, `idphoto`, `bank_name`, `customer_name`, `bank_account`, `iban`, `bank_photo`, `user_name`, `password`, `c_password`, `lang`, `status`, `active`, `block`, `country`, `city`, `place`, `branch_id`, `c_date`, `commission`, `branches`) VALUES
(5, 'Energy secrets', 'سر الطاقه', '', '1', 'Abdulrhman Mohamed عبد الرحمان محمد السحيباني', 'Alsaibany', 'عبد الرحمان محمد', 'لسحيباني', '9660548479226', 10704447, 1016495507, 'data:image/jpeg;base64,[encoded data, 297036 characters]', 'data:image/jpeg;base64,[encoded data, 118928 characters]', '', '', '', '', '', 'esecrets1', '123456', '123456', 'EN', 0, 0, 0, 2, 18, 0, 0, '2018-11-22', 14, 1);
