-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 22, 2018 at 04:58 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 `advs`
--

CREATE TABLE IF NOT EXISTS `advs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `advs`
--

INSERT INTO `advs` (`id`, `img`, `link`) VALUES
(2, 'a7bd01e1ef12439d80d1fa1ae6d04dd8.jpg', 'gdfgdfg');

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

--
-- Table structure for table `articals`
--

CREATE TABLE IF NOT EXISTS `articals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `artical_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `artical_cat` int(11) DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `main_txt` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `main_txt_content` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `audio_talker` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `audio_voice` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `main_txt2` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `main_txt_content2` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `articals`
--

INSERT INTO `articals` (`id`, `artical_name`, `artical_cat`, `img`, `main_txt`, `main_txt_content`, `audio_talker`, `audio_voice`, `main_txt2`, `main_txt_content2`) VALUES
(1, 'مقال رقم 1', 2, '3b6b952e6274247630c498d520ba6aef.jpg', 'كان لوريم إيبسوم ولايزال المعيار للنص الشكلي منذ القرن الخامس عشر عندما قامت مطبعة مجهولة برص مجموعة من الأحرف بشكل عشوائي أخذتها من نص، لتكوّن كتيّب بمثابة دليل أو مرجع شكلي لهذه الأحرف.', NULL, 'محمد طارق', '0e91f0b8c1facc6944b68daf2e53889c.mp3', NULL, NULL),
(6, 'يشسيشسي', 4, '553e612048f0d8d2616e77a7187b0654.jpg', 'شسييييييييي يشسي شسي شسيشسي شسي ؤئءؤئء صثضصث ضصثضصث تتتتتتتتتتتتتتتتتت فففففففففففففففففف صصصصصصصصصصصصصص ووووووووووو', NULL, 'شسيشسي', 'no image', 'شسيشس شسيشس شسرءؤرءؤ ؤر ءؤءرءؤرءؤر', '<p><span style="color:#AB0000">شسيشس</span> <span style="color:#AB2567">شسيشس</span> <span style="color:#AB6927">شسرءؤرءؤ</span> <span style="color:#0094AB">ؤر</span> <span style="color:#AB0000">ءؤءرءؤرءؤر</span></p>\r\n'),
(7, '', 4, '2491cee052e6bd618497c1c01ec8a206.jpg', 'شسيشسي', NULL, '', 'no image', 'ىىىىىىىىىىىىىىىىى', '<p><span style="color:#AB0000">ىىىىىىىىىىىىىىىىى</span></p>\r\n'),
(8, 'ؤؤؤؤؤؤؤؤؤؤؤؤؤ', 4, 'bf6cb54cc59dd5351ab660a98e04010d.jpg', 'ءءءءءءءءءءءءءءء لالالالالالالالالالالالالالالالالا فففففففففففففففففففف', '<p><span style="color:#AB0000">ءءءءءءءءءءءءءءء</span> <span style="color:#AB2567">لالالالالالالالالالالالالالالالالا</span> <span style="color:#AB6927">فففففففففففففففففففف</span></p>\r\n', '', 'no image', 'سيب سيبسي شيشسي عههههههههههههههههههههههه', '<p><span style="color:#AB0000">سيب</span> <span style="color:#AB2567">سيبسي</span> <span style="color:#AB6927">شيشسي</span> <span style="color:#0094AB">عههههههههههههههههههههههه</span></p>\r\n');

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

--
-- 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=30 ;

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

INSERT INTO `awcontroll` (`id`, `label`, `name`) VALUES
(1, 'المجموعات', '_role'),
(2, 'القائمه', '_menu'),
(3, 'الاعضاء', '_member'),
(4, 'الكنترولات', '_controll'),
(18, 'بياناتى', '_myprofile'),
(19, 'التصنيفات', 'm_cats'),
(20, 'المقالات', 'm_articals'),
(28, 'الالوان', 'm_colors'),
(29, 'الاعلانات', 'm_advs');

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

--
-- 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=169 ;

--
-- 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),
(144, 'index', 1, 24),
(145, 'show', 1, 24),
(146, 'del', 1, 24),
(147, 'index', 1, 25),
(148, 'addit', 1, 25),
(149, 'show', 1, 25),
(150, 'edit', 1, 25),
(151, 'updateit', 1, 25),
(152, 'del', 1, 25),
(153, 'index', 1, 26),
(154, 'show', 1, 26),
(155, 'edit', 1, 26),
(156, 'del', 1, 26),
(157, 'orderApprove', 1, 26),
(158, 'index', 1, 27),
(159, 'show', 1, 27),
(160, 'del', 1, 27),
(161, 'index', 1, 28),
(162, 'updateit', 1, 28),
(163, 'index', 1, 29),
(164, 'addit', 1, 29),
(165, 'show', 1, 29),
(166, 'edit', 1, 29),
(167, 'updateit', 1, 29),
(168, 'del', 1, 29);

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

--
-- 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=18 ;

--
-- 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_cats/show', 0, 1, 'icon-calendar', 'cats'),
(8, 'المقالات', 'm_articals/show', 0, 1, 'icon-docs', 'articals'),
(16, 'الالوان', 'm_colors', 0, 1, 'icon-pencil', 'colors'),
(17, 'الاعلانات', 'm_advs/show', 0, 1, 'icon-speech', 'advs');

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

--
-- 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=225 ;

--
-- 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, 0),
(78, 2, 125, 0),
(79, 2, 126, 1),
(80, 2, 127, 0),
(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, 1),
(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),
(152, 1, 144, 1),
(153, 1, 145, 1),
(154, 1, 146, 1),
(155, 3, 144, 1),
(156, 3, 145, 1),
(157, 3, 146, 1),
(158, 1, 147, 1),
(159, 1, 148, 1),
(160, 1, 149, 1),
(161, 1, 150, 1),
(162, 1, 151, 1),
(163, 1, 152, 1),
(164, 3, 147, 1),
(165, 3, 148, 1),
(166, 3, 149, 1),
(167, 3, 150, 1),
(168, 3, 151, 1),
(169, 3, 152, 1),
(170, 1, 153, 1),
(171, 1, 154, 1),
(172, 1, 155, 1),
(173, 1, 156, 1),
(174, 3, 153, 1),
(175, 3, 154, 1),
(176, 3, 155, 1),
(177, 3, 156, 1),
(178, 1, 157, 1),
(179, 1, 158, 1),
(180, 1, 159, 1),
(181, 1, 160, 1),
(182, 2, 130, 1),
(183, 2, 131, 1),
(184, 2, 132, 1),
(185, 2, 133, 1),
(186, 2, 134, 1),
(187, 2, 135, 1),
(188, 2, 136, 1),
(189, 2, 137, 1),
(190, 2, 138, 1),
(191, 2, 139, 1),
(192, 2, 140, 1),
(193, 2, 141, 1),
(194, 2, 142, 1),
(195, 2, 143, 1),
(196, 2, 144, 1),
(197, 2, 145, 1),
(198, 2, 146, 1),
(199, 2, 147, 1),
(200, 2, 148, 1),
(201, 2, 149, 1),
(202, 2, 150, 1),
(203, 2, 151, 1),
(204, 2, 152, 1),
(205, 2, 153, 1),
(206, 2, 154, 1),
(207, 2, 155, 1),
(208, 2, 156, 1),
(209, 2, 157, 1),
(210, 2, 158, 1),
(211, 2, 159, 1),
(212, 2, 160, 1),
(213, 3, 157, 1),
(214, 3, 158, 1),
(215, 3, 159, 1),
(216, 3, 160, 1),
(217, 1, 161, 1),
(218, 1, 162, 1),
(219, 1, 163, 1),
(220, 1, 164, 1),
(221, 1, 165, 1),
(222, 1, 166, 1),
(223, 1, 167, 1),
(224, 1, 168, 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=44 ;

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

INSERT INTO `awrolemenu` (`id`, `role_id`, `menu_id`, `checkval`) VALUES
(1, 1, 1, 0),
(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, 0),
(11, 2, 3, 0),
(12, 2, 6, 0),
(13, 2, 7, 0),
(14, 2, 8, 0),
(15, 3, 1, 0),
(16, 3, 2, 0),
(17, 3, 3, 0),
(18, 3, 6, 0),
(19, 3, 7, 0),
(20, 3, 8, 0),
(42, 1, 16, 1),
(43, 1, 17, 1);

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

--
-- 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=11 ;

--
-- 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),
(6, 'sara', '$2y$10$7G2hiGC5uX26/UDmffpn8etlbhqeWnzrAZSXvXRFFk2LpolIA0zOi', 'sa__120@hotmail.com', 1, '0e5e31ef2df6d7693254e247c9da34adcce32df4', NULL, NULL, NULL, 0, NULL, '2018-04-03 23:59:24', '::1', 2, 'sara', 0),
(7, 'sro', '$2y$10$pjor1yGQD./0HwSq4gsU.Oh/SGoDarIb1PmPUvG5ELkuz.bmdY0aC', 'saoo@hotmail.com', 1, '267e859400913e6c04adc8c6e942a1322b26eb7d', NULL, NULL, NULL, 0, NULL, '2018-04-04 01:32:41', '::1', 3, 'sro', 2),
(8, 'moTa', '$2y$10$OlbUxwT1eEnAEm6uREqLfecUiOH5dwa4v/DyNbqnqQ.c7oPnkWTDm', 'moTa@asd.com', 1, '608091f883d20cbb998f3f888f099588ca129d0c', NULL, NULL, NULL, 0, NULL, '2018-04-15 00:02:34', '::1', 2, 'طارق', 2),
(9, 'bibo', '$2y$10$LUVx.bq3niD0V/Q8t2m3SeUsUv01Y715DXKRtNjggKWncok.fHIle', 'bibo@asd.com', 1, '5481ed87dd9feedce9cf17c54b4f37ec5eae53eb', NULL, NULL, NULL, 0, NULL, '2018-04-15 00:06:02', '::1', 2, 'Bibo', 0),
(10, 'aml', '$2y$10$YCgeMtGeihDfCDCpbDT7K.v7NubMoxCBcj3JC7P0fk7xQdUUmUa/S', 'aml@aml.com', 1, '6e29b4eaaf6c42a9d0365b097b7fa6cb7d280c75', NULL, NULL, NULL, 0, NULL, '2018-04-17 22:57:43', '::1', 3, 'Aml', 0);

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

--
-- Table structure for table `cats`
--

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

--
-- Dumping data for table `cats`
--

INSERT INTO `cats` (`id`, `name`) VALUES
(2, 'مقالات انجليزى'),
(3, 'مقالات عربى'),
(4, 'مقالات فرنسى ');

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

--
-- Table structure for table `colors`
--

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

--
-- Dumping data for table `colors`
--

INSERT INTO `colors` (`id`, `name`) VALUES
(19, 'AB0000'),
(20, 'AB2567'),
(21, 'AB6927'),
(22, '0094AB');

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