-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 28, 2018 at 10:24 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `onlinecaftria`
--

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

--
-- Table structure for table `awcontroll`
--

CREATE TABLE IF NOT EXISTS `awcontroll` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=24 ;

--
-- Dumping data for table `awcontroll`
--

INSERT INTO `awcontroll` (`id`, `label`, `name`) VALUES
(1, 'المجموعات', '_role'),
(2, 'القائمه', '_menu'),
(3, 'الاعضاء', '_member'),
(4, 'الكنترولات', '_controll'),
(18, 'بياناتى', '_myprofile'),
(19, 'الكافتريات', 'm_caftria'),
(20, 'الصفحات', 'm_page'),
(21, 'التصنيفات', 'm_category'),
(22, 'قائمة الطعام', 'm_products'),
(23, 'بيانات الادارة', 'm_details');

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

--
-- Table structure for table `awcontrollprop`
--

CREATE TABLE IF NOT EXISTS `awcontrollprop` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `proplabel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkval` tinyint(1) unsigned DEFAULT NULL,
  `awcontroll_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_awcontrollprop_awcontroll` (`awcontroll_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=144 ;

--
-- Dumping data for table `awcontrollprop`
--

INSERT INTO `awcontrollprop` (`id`, `proplabel`, `checkval`, `awcontroll_id`) VALUES
(1, 'index', 1, 1),
(2, 'addit', 1, 1),
(3, 'show', 1, 1),
(4, 'edit', 1, 1),
(5, 'updateit', 1, 1),
(6, 'del', 1, 1),
(7, 'setting', 1, 1),
(8, 'insetting', 1, 1),
(9, 'index', 1, 2),
(10, 'addit', 1, 2),
(11, 'show', 1, 2),
(12, 'edit', 1, 2),
(13, 'updateit', 1, 2),
(14, 'del', 1, 2),
(15, 'index', 0, 3),
(16, 'addit', 1, 3),
(17, 'show', 1, 3),
(18, 'edit', 1, 3),
(19, 'updateit', 1, 3),
(20, 'del', 1, 3),
(21, 'index', 1, 4),
(22, 'addit', 1, 4),
(23, 'show', 1, 4),
(24, 'edit', 1, 4),
(25, 'updateit', 1, 4),
(26, 'del', 1, 4),
(27, 'delprop', 1, 4),
(116, 'index', 1, 18),
(117, 'updateit', 1, 18),
(118, 'index', 1, 19),
(119, 'addit', 1, 19),
(120, 'show', 1, 19),
(121, 'edit', 1, 19),
(122, 'updateit', 1, 19),
(123, 'del', 1, 19),
(124, 'index', 1, 20),
(125, 'addit', 1, 20),
(126, 'show', 1, 20),
(127, 'edit', 1, 20),
(128, 'updateit', 1, 20),
(129, 'del', 1, 20),
(130, 'index', 1, 21),
(131, 'addit', 1, 21),
(132, 'show', 1, 21),
(133, 'edit', 1, 21),
(134, 'updateit', 1, 21),
(135, 'del', 1, 21),
(136, 'index', 1, 22),
(137, 'addit', 1, 22),
(138, 'show', 1, 22),
(139, 'edit', 1, 22),
(140, 'updateit', 1, 22),
(141, 'del', 1, 22),
(142, 'index', 1, 23),
(143, 'updateit', 1, 23);

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

--
-- Table structure for table `awmenu`
--

CREATE TABLE IF NOT EXISTS `awmenu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent` int(11) unsigned DEFAULT NULL,
  `sort` int(11) unsigned DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `awmenu`
--

INSERT INTO `awmenu` (`id`, `label`, `link`, `parent`, `sort`, `icon`, `active_name`) VALUES
(1, 'لوحه البيانات', 'index', 0, 1, 'icon-home', 'index'),
(2, 'اعدادات الاداره', 'managment', 0, 1, 'icon-settings', 'managment'),
(3, 'لوحه الاعضاء', '_member/show', 2, 1, 'icon-users', 'member'),
(6, 'لوحه المجموعات', '_role/show', 2, 1, 'icon-puzzle', 'role'),
(7, 'الكافتريات', 'm_caftria/show', 0, 1, 'icon-calendar', 'caftria'),
(8, 'الصفحات', 'm_page/show', 0, 1, 'icon-docs', 'page'),
(9, 'التصنيفات', 'm_category/show', 0, 1, 'icon-pencil', 'm_category'),
(10, 'قائمة الطعام', 'm_products/show', 0, 1, 'icon-present', 'm_products'),
(11, 'بيانات الادارة', 'm_details', 2, 1, 'icon-diamond', 'm_details');

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

--
-- Table structure for table `awrole`
--

CREATE TABLE IF NOT EXISTS `awrole` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `awrole`
--

INSERT INTO `awrole` (`id`, `name`) VALUES
(1, 'سوبر أدمن'),
(2, 'الادارة العامة'),
(3, 'أعضاء الكافتريا');

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

--
-- Table structure for table `awrolecontrollprop`
--

CREATE TABLE IF NOT EXISTS `awrolecontrollprop` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) unsigned DEFAULT NULL,
  `controllprop_id` int(11) unsigned DEFAULT NULL,
  `checkval` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_awrolecontrollprop_awrole` (`role_id`),
  KEY `index_foreignkey_awrolecontrollprop_awcontrollprop` (`controllprop_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=152 ;

--
-- Dumping data for table `awrolecontrollprop`
--

INSERT INTO `awrolecontrollprop` (`id`, `role_id`, `controllprop_id`, `checkval`) VALUES
(1, 1, 1, 1),
(2, 1, 2, 1),
(3, 1, 3, 1),
(4, 1, 4, 1),
(5, 1, 5, 1),
(6, 1, 6, 1),
(7, 1, 7, 1),
(8, 1, 8, 1),
(9, 1, 9, 1),
(10, 1, 10, 1),
(11, 1, 11, 1),
(12, 1, 12, 1),
(13, 1, 13, 1),
(14, 1, 14, 1),
(15, 1, 15, 1),
(16, 1, 16, 1),
(17, 1, 17, 1),
(18, 1, 18, 1),
(19, 1, 19, 1),
(20, 1, 20, 1),
(21, 1, 21, 1),
(22, 1, 22, 1),
(23, 1, 23, 1),
(24, 1, 24, 1),
(25, 1, 25, 1),
(26, 1, 26, 1),
(27, 1, 27, 1),
(28, 2, 1, 1),
(29, 2, 2, 1),
(30, 2, 3, 1),
(31, 2, 4, 1),
(32, 2, 5, 1),
(33, 2, 6, 1),
(34, 2, 7, 1),
(35, 2, 8, 1),
(36, 2, 9, 1),
(37, 2, 10, 1),
(38, 2, 11, 1),
(39, 2, 12, 1),
(40, 2, 13, 1),
(41, 2, 14, 1),
(42, 2, 15, 1),
(43, 2, 16, 1),
(44, 2, 17, 1),
(45, 2, 18, 1),
(46, 2, 19, 1),
(47, 2, 20, 1),
(48, 2, 21, 1),
(49, 2, 22, 1),
(50, 2, 23, 1),
(51, 2, 24, 1),
(52, 1, 116, 1),
(53, 1, 117, 1),
(54, 1, 118, 1),
(55, 1, 119, 1),
(56, 1, 120, 1),
(57, 1, 121, 1),
(58, 1, 122, 1),
(59, 1, 123, 1),
(60, 1, 124, 1),
(61, 1, 125, 1),
(62, 1, 126, 1),
(63, 1, 127, 1),
(64, 1, 128, 1),
(65, 1, 129, 1),
(66, 2, 25, 1),
(67, 2, 26, 1),
(68, 2, 27, 1),
(69, 2, 116, 1),
(70, 2, 117, 1),
(71, 2, 118, 1),
(72, 2, 119, 1),
(73, 2, 120, 1),
(74, 2, 121, 1),
(75, 2, 122, 1),
(76, 2, 123, 1),
(77, 2, 124, 1),
(78, 2, 125, 1),
(79, 2, 126, 1),
(80, 2, 127, 1),
(81, 2, 128, 1),
(82, 2, 129, 1),
(83, 3, 1, 1),
(84, 3, 2, 1),
(85, 3, 3, 1),
(86, 3, 4, 1),
(87, 3, 5, 1),
(88, 3, 6, 1),
(89, 3, 7, 1),
(90, 3, 8, 1),
(91, 3, 9, 1),
(92, 3, 10, 1),
(93, 3, 11, 1),
(94, 3, 12, 1),
(95, 3, 13, 1),
(96, 3, 14, 1),
(97, 3, 15, 0),
(98, 3, 16, 1),
(99, 3, 17, 1),
(100, 3, 18, 1),
(101, 3, 19, 1),
(102, 3, 20, 1),
(103, 3, 21, 1),
(104, 3, 22, 1),
(105, 3, 23, 1),
(106, 3, 24, 1),
(107, 3, 25, 1),
(108, 3, 26, 1),
(109, 3, 27, 1),
(110, 3, 116, 1),
(111, 3, 117, 1),
(112, 3, 118, 1),
(113, 3, 119, 1),
(114, 3, 120, 1),
(115, 3, 121, 1),
(116, 3, 122, 1),
(117, 3, 123, 1),
(118, 3, 124, 1),
(119, 3, 125, 1),
(120, 3, 126, 1),
(121, 3, 127, 1),
(122, 3, 128, 1),
(123, 3, 129, 1),
(124, 1, 130, 1),
(125, 1, 131, 1),
(126, 1, 132, 1),
(127, 1, 133, 1),
(128, 1, 134, 1),
(129, 1, 135, 1),
(130, 1, 136, 1),
(131, 1, 137, 1),
(132, 1, 138, 1),
(133, 1, 139, 1),
(134, 1, 140, 1),
(135, 1, 141, 1),
(136, 3, 130, 1),
(137, 3, 131, 1),
(138, 3, 132, 1),
(139, 3, 133, 1),
(140, 3, 134, 1),
(141, 3, 135, 1),
(142, 3, 136, 1),
(143, 3, 137, 1),
(144, 3, 138, 1),
(145, 3, 139, 1),
(146, 3, 140, 1),
(147, 3, 141, 1),
(148, 1, 142, 1),
(149, 1, 143, 1),
(150, 3, 142, 1),
(151, 3, 143, 1);

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

--
-- Table structure for table `awrolemenu`
--

CREATE TABLE IF NOT EXISTS `awrolemenu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) unsigned DEFAULT NULL,
  `menu_id` int(11) unsigned DEFAULT NULL,
  `checkval` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_awrolemenu_awrole` (`role_id`),
  KEY `index_foreignkey_awrolemenu_awmenu` (`menu_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=27 ;

--
-- Dumping data for table `awrolemenu`
--

INSERT INTO `awrolemenu` (`id`, `role_id`, `menu_id`, `checkval`) VALUES
(1, 1, 1, 1),
(2, 1, 2, 1),
(3, 1, 3, 1),
(6, 1, 6, 1),
(7, 1, 7, 1),
(8, 1, 8, 1),
(9, 2, 1, 0),
(10, 2, 2, 1),
(11, 2, 3, 1),
(12, 2, 6, 0),
(13, 2, 7, 1),
(14, 2, 8, 1),
(15, 3, 1, 0),
(16, 3, 2, 0),
(17, 3, 3, 0),
(18, 3, 6, 0),
(19, 3, 7, 0),
(20, 3, 8, 0),
(21, 1, 9, 1),
(22, 1, 10, 1),
(23, 3, 9, 0),
(24, 3, 10, 1),
(25, 1, 11, 1),
(26, 3, 11, 0);

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

--
-- Table structure for table `awusers`
--

CREATE TABLE IF NOT EXISTS `awusers` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto incrementing user_id of each user, unique index',
  `user_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s name, unique',
  `user_password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s password in salted and hashed format',
  `user_email` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s email, unique',
  `user_active` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'user''s activation status',
  `user_activation_hash` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'user''s email verification hash string',
  `user_password_reset_hash` char(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'user''s password reset code',
  `user_password_reset_timestamp` bigint(20) DEFAULT NULL COMMENT 'timestamp of the password reset request',
  `user_rememberme_token` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'user''s remember-me cookie token',
  `user_failed_logins` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'user''s failed login attemps',
  `user_last_failed_login` int(10) DEFAULT NULL COMMENT 'unix timestamp of last failed login attempt',
  `user_registration_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_registration_ip` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0.0.0',
  `role_id` int(11) NOT NULL,
  `name` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `caftria_id` int(11) DEFAULT '0' COMMENT '0=> no caftria ',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user data' AUTO_INCREMENT=5 ;

--
-- Dumping data for table `awusers`
--

INSERT INTO `awusers` (`user_id`, `user_name`, `user_password_hash`, `user_email`, `user_active`, `user_activation_hash`, `user_password_reset_hash`, `user_password_reset_timestamp`, `user_rememberme_token`, `user_failed_logins`, `user_last_failed_login`, `user_registration_datetime`, `user_registration_ip`, `role_id`, `name`, `caftria_id`) VALUES
(1, 'manager', '$2y$10$O/NGCcl0D7V6sNx9z2E0JeMfhS1MXoIe1GxYg0gK/v.n7gxKUugq.', 'manager@anoud.com', 1, '1ebf1664a5d6077504fcb60caccefc2d88b964e4', '36e688b8ef85a659b3ec39646df92a809f2d6a28', 1422433469, NULL, 0, NULL, '2015-01-25 12:41:59', '127.0.0.1', 1, 'مدير عام', 0),
(2, 'wafaa', '$2y$10$QFrVFGKRlfi0e2sV7a/3W.uKVmuZMYBjgd5THcBsSr9lsIrNJWWIi', 'wafaa@yahoo.com', 1, 'e6f952f0a1fb3886f842dc46c1810a429360a8f6', NULL, NULL, NULL, 0, NULL, '2018-02-16 21:22:05', '::1', 3, 'wafaa', 0),
(3, 'tarek', '$2y$10$/qEVuIzhL88Ja6NvcUT.M.ZvlksvVcUHYFmhVSJBJGhi8tMwzZ0a6', 'motarek5392@gmail.com', 1, '347526f9094aad68f7ac8f0fa45f797a43f6e91f', NULL, NULL, NULL, 0, NULL, '2018-02-17 23:23:31', '::1', 3, 'tarek', 0),
(4, 'mo', '$2y$10$YNSCAargP00QD2vVVKaWQesAGpwcUxZfTxNEzJ/E4ukHS2fIdJHoe', 'xx@xx.com', 1, '001e8540b6e3325229ce49cb88482a20f4e4b738', NULL, NULL, NULL, 0, NULL, '2018-02-22 17:56:43', '::1', 3, 'عضو بكفاتريا', 11);

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

--
-- Table structure for table `caftria`
--

CREATE TABLE IF NOT EXISTS `caftria` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `img` varchar(191) DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `facebook` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `twitter` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `linked` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `caftria`
--

INSERT INTO `caftria` (`id`, `name`, `img`, `email`, `address`, `phone`, `facebook`, `twitter`, `linked`) VALUES
(9, 'كافتريا 1', '126f026bffab858e145c5e9c76da0ef2.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
(11, 'كافتريا دونات', '9895ec0ec006d720bd73de7da61b2a4f.jpg', '', '', '', '', '', ''),
(12, 'qweq', '75440e9d44e17eb1b06b6e18f01a31b6.jpg', 'xx@xx.comwwwwwwwwwww', '1111111111', '2222222222', '3333333333', '444444444444', '5555555555555555');

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `caftria_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_category_caftria` (`caftria_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`, `caftria_id`) VALUES
(6, 'مأكولات', 11),
(7, 'مشروبات', 11);

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

--
-- Table structure for table `details`
--

CREATE TABLE IF NOT EXISTS `details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `facebook` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `twitter` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `linked` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `details`
--

INSERT INTO `details` (`id`, `email`, `address`, `phone`, `facebook`, `twitter`, `linked`) VALUES
(1, 'wafaa@yahoo.com', 'مكة المكرمة', '123456789', 'sara@yahoo.com', 'moroj@yahoo.com', 'www.linkedin.com');

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

--
-- Table structure for table `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caftria_id` int(11) unsigned DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_page_caftria` (`caftria_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id`, `name`, `content`, `img`, `caftria_id`, `number`) VALUES
(1, 'مرحبا بكم فى كافتريا 1', '<p>من رئيس حقول كلّ, إذ وبدون المحيط العالمي أخذ. تعد كل سابق وبداية واتّجه, مع ويكيبيديا، واندونيسيا، ذلك. هو بحق مليون لأداء.</p>\r\n', 'a1db77b3388afe0b6f0d967cfd654f76.jpg', 9, 0),
(2, 'معلومات عنا', '<p>من يبق مسرح الصينية, ثم تاريخ للصين بريطانيا-فرنسا هذه, بل المارق استدعى أسر. كل موالية الجنود بحق, مارد وقامت الخارجية إيو كل. إيو قدما الإنزال ما. كل حتى المحيط انتصارهم, أمام الآلاف ما بلا. الى ويتّفق ماليزيا، عن. حيث الغالي الإطلاق المجتمع أن, لها دفّة سليمان، الدنمارك مع.</p>\r\n', '7b814fca98e77d125ad31da4f4c83a5a.jpg', 9, 1),
(5, 'مرحبا بكم فى كافتريا دونات 2018', '<p>شسيشسيسسسسسسسسسسسسسسسسسسسس</p>\r\n', 'ee356103b386ba7b665d14554b18bb36.jpg', 11, 0),
(6, 'معلومات عنا', '<p>هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام &quot;هنا يوجد محتوى نصي، هنا يوجد محتوى نصي&quot; فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء</p>\r\n', 'no image', 11, 1),
(7, 'مرحبا بكم', NULL, NULL, 12, 0),
(8, 'معلومات عنا', NULL, NULL, 12, 1);

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

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

CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caf_id` int(11) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `period` float DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `content` varchar(191) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

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

INSERT INTO `products` (`id`, `caf_id`, `cat_id`, `name`, `img`, `amount`, `price`, `period`, `description`, `content`) VALUES
(10, 11, 6, 'دونات شوكلاته جديدة', 'b4e1ab809e5472bcb8b5aae20c4d96fa.jpg', 100, 5, 15, NULL, '<p>لبليبليبليبل</p>\r\n'),
(11, 11, 7, 'بيبسى', 'a2bbfa111877fac1087bfd270ec80619.jpg', 70, 11, 5, NULL, '<p>ئئئئئئئئئئئئئئئئئئئئئئئئئئئ</p>\r\n');

/*!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 */;
