-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 26, 2018 at 09:06 AM
-- Server version: 5.7.14
-- PHP Version: 7.0.10

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

--
-- Database: `barakeh_cms`
--

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

--
-- Table structure for table `album`
--

CREATE TABLE `album` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `image` varchar(45) NOT NULL COMMENT 'Conver Image',
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `album_has_category`
--

CREATE TABLE `album_has_category` (
  `album_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `album_image`
--

CREATE TABLE `album_image` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `image` varchar(45) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `album_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `language` char(2) NOT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `image` varchar(20) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `create_user_id` int(11) NOT NULL,
  `update_user_id` int(11) NOT NULL,
  `attachment_url` varchar(100) DEFAULT NULL,
  `attachment_title` varchar(100) DEFAULT NULL,
  `background` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `article`
--

INSERT INTO `article` (`id`, `title`, `slug`, `content`, `create_datetime`, `update_datetime`, `language`, `hits`, `status`, `image`, `featured`, `create_user_id`, `update_user_id`, `attachment_url`, `attachment_title`, `background`) VALUES
(1, 'بنك البركة سورية يطلق خدمة تسديد فواتير شركات الخليوي من خلال خدمة " تم "', 'بنك-البركة-سورية-يطلق-خدمة-تسديد-فواتير-شركات-الخليوي-من-خلال-خدمة-تم', '<span style="font-size: medium;"><span style="font-family: &quot;Times New Roman&quot;;"><span lang="AR-SA">ستكمالاً لريادته في مواكبة الصيرفة الالكترونية، وتأكيداً على موقعه الريادي في تطوير خدماته ومنتجاته بما يتلاءم مع حاجة السوق المحلية، أطلق بنك البركة ولأول مرة في سورية خدمة تسديد جميع فواتير الموبايل و </span><span dir="LTR">3G</span><span lang="AR-SA"> و خط إنترنت لأي رقم ضمن شركات الخليوي، وذلك لمتعاملي بنك البركة سورية المشتركين بخدمة &quot; <b>تم </b>&quot;.</span></span></span>\r\n<p dir="RTL" style="margin: 0in 0in 0.0001pt; text-align: right; direction: rtl; unicode-bidi: embed;"><span style="font-size: medium;"><span style="font-family: &quot;Times New Roman&quot;;"><span lang="AR-SA">وقد صرّح الأستاذ محمد عبد الله حلبي الرئيس التنفيذي لبنك البركة سورية: &quot; إن حرص البنك على تقديم أفضل الخدمات المصرفية الذكية، شجعنا على إطلاق هذه الخدمة، حيث تأتِ هذه الخطوة على طريق استكمال &nbsp;الخدمات المصرفية الالكترونية في ظل تزايد اعتماد العملاء على الخدمات المتنقلة في إدارة حساباتهم المصرفية&quot;. </span></span></span></p>\r\n\r\n<p dir="RTL" style="text-align: right; direction: rtl; unicode-bidi: embed;"><span style="font-size: medium;"><span style="font-family: &quot;Times New Roman&quot;;"><span lang="AR-SA">واستطرد قائلاً: &quot;إننا نسعى دائماً لإيجاد الحلول المبتكرة في عمليات السداد الالكتروني والاستفادة من التطور التكنولوجي من خلال تسخير التكنولوجيا والخدمات الالكترونية في تعزيز التنافسية في السوق المصرفية السورية&quot;.</span></span></span></p>\r\n\r\n<p dir="RTL" style="text-align: right; direction: rtl; unicode-bidi: embed;"><span style="font-size: medium;"><span style="font-family: &quot;Times New Roman&quot;;"><span lang="AR-SA">يذكر أن بنك البركة قد أطلق خدمة &quot; <b>تم </b>&quot;للتحويل بين الحسابات بدون إنترنت في شهر أيار من 2015 وذلك كأول مصرف خاص في سورية.</span></span></span></p>\r\n', 1519509600, 1519509600, 'ar', 2, 1, '5a926c321bace.jpg', 0, 1, 1, 'C:\\wamp64\\www\\flexcms\\protected/../uploads/Article/files/attachment5a926c03c9f39.pdf', 'attachment5a926c03c9f39.pdf', NULL),
(2, 'للعام الثاني على التوالي بنك البركة سورية يستحق تصنيف ائتماني قوي من IIRA', 'للعام-الثاني-على-التوالي-بنك-البركة-سورية-يستحق-تصنيف-ائتماني-قوي-من-iira', '<div dir="rtl">استحق بنك البركة سورية للعام الثاني درجة تصنيف ائتماني من الدرجة الاستثمارية <span dir="LTR">BBB</span>، والذي منحته الوكالة الدولية الإسلامية للتصنيف (<span dir="LTR">IIRA</span>) وفقاً لمعيار <span dir="LTR">DFRA</span>.&nbsp;واعتمد قرار التصنيف على البيئة التشغيلية لبنك البركة وذلك في سياق الاقتصاد الكلي والظروف الاجتماعية والسياسية, وهذا ما يضع البنك في موقع متفوق في القطاع المصرفي المحلي، لاحتفاظه بنسبة كبيرة من أصوله بالعملة الأجنبية، مما يمكنه من تغطية مخاطر المستوى السيادي إلى حد كبير.<br />\r\nواستحق بنك البركة سورية أيضاً قدرة ائتمانية كافية، بتقييمه في نطاق (71-75) كدرجة ائتمانية إجمالية. كما استحق صفة ائتمانية قوية، بتقييمه في نطاق (76-80) لدرجة &quot;إدارة جودة الأصول&quot; الأمر الذي يعكس مستوى الحيطة لدى البنك وقدرته العالية على الوفاء بالمسؤولية الائتمانية تجاه المستثمرين.<br />\r\nواعتبرت الوكالة ممارسات الحوكمة والشريعة في البنك مناسبة، مع تمثيل قوي لمجلس الإدارة، ومستويات عالية من الإفصاحات المالية وغير المالية. إذ تم تقييم حوكمة الشركات لدى البنك في نطاق (66-70)، وتقييم الحوكمة الشرعية في نطاق (71-75).<br />\r\nوفي هذه المناسبة صرّح رئيس مجلس إدارة بنك البركة سورية الأستاذ عدنان أحمد يوسف قائلاً: &laquo;إن حصول البنك للعام الثاني على هذا التقييم يعزز صحة المعايير المتبعة لنهج التخطيط والإدارة والتنفيذ في بنك البركة سورية، وعاملاً لتحديد الأهداف الجديدة للبنك في السوق المصرفية السورية&raquo;.<br />\r\n&nbsp;<br />\r\nبدوره صرح السيد محمد عبد الله حلبي الرئيس التنفيذي لبنك البركة سورية : &quot;إن هذه النتيجة تؤكد دقّة الاستراتيجية المتبعة للبنك، والأداء عالي الجودة لفريق العمل الملتزم والقادر على تنفيذ هذه الاستراتيجية بمنتهى المهنية&quot;.<br />\r\n&nbsp;<br />\r\nيشار إلى أن &laquo;بنك البركة سورية&raquo; حصد جائزتي مؤسسة<span dir="LTR"> CPI Financial </span>كأفضل مصرف إسلامي في سورية وأفضل مؤسسة مالية ملتزمة في المسؤولية الاجتماعية للمصارف الإسلامية لعام2017 في سورية.<br />\r\nوالجدير بالذكر أن الوكالة الدولية الإسلامية للتصنيف هي شركة مستقلة تتخذ من مملكة البحرين مقراً لها وتقوم بعمليات التصنيف الائتماني للمصارف والمؤسسات المالية حول العالم ، وهي مملوكة من مجموعة مشهورة من مؤسسات التصنيف العالمية ومجموعة من البنوك المرموقة مثل كابيتال انتيلجنس (<span dir="LTR">Capital Intelligence</span>) والبنك الإسلامي للتنمية .</div>\r\n', 1519509600, 1519509600, 'ar', 2, 1, NULL, 0, 1, 1, 'C:\\wamp64\\www\\flexcms\\protected/../uploads/Article/files/attachment5a926c6bc47e2.pdf', 'attachment5a926c6bc47e2.pdf', NULL),
(3, 'إطلاق بنك التمويل والإنماء، BTI Bank، كثمرة للشراكة بين مجموعة البركة المصرفية والبنك المغربي للتجارة الخارجية لإفريقيا', 'bti-bank', '<div dir="rtl">أعلنت اليوم كل من مجموعة البركة المصرفية، المجموعة المصرفية الإسلامية الرائدة التي تتخذ من البحرين مقراً لعملياتها، والبنك المغربي للتجارة الخارجية لإفريقيا، وهو واحد من المجموعات البنكية الإفريقية الرئيسية على الصعيد الدولي، عن إطلاق البنك التشاركي الجديد، بنك التمويل والإنماء BTI Bank وافتتاح أول مقر له بالدار البيضاء.<br />\r\n<br />\r\nويأتي تأسيس هذا البنك التشاركي في سياق تلبية احتياجات السوق المغربي وليضع متطلبات زبائنه من أفراد ومؤسسات في قلب اهتماماته وأولوياته عبر المشاركة في إنجاح مشاريعهم وفقا لعلاقة شراكة متساوية ومربحة للطرفين، ملتزماً في الوقت نفسه بأعلى القيم المهنية والشرعية.<br />\r\n<br />\r\nوفي إطار سعيه ليكون الشريك الحقيقي لكافة فئات العملاء من الأفراد والشركات والمهنيين والأعمال على حد سواء، سيعتمد BTI Bank على الخبرات المتكاملة لمؤسسيه. وبهذا، يكون قد استفاد من التجربة الدولية لمجموعة البركة المصرفية، التي تمتلك وحدات مصرفية تابعة ومكاتب تمثيلية في 15 بلدا ولها خبرة عريقة لأكثر من 40 سنة في العمل المصرفي التشاركي، إلى جانب خبرة البنك المغربي للتجارة الخارجية لإفريقيا، الذي يمتلك نموذج مصرفي شمولي يغطي كافة مجالات وأنشطة الصيرفة والمالية.<br />\r\n<br />\r\nوفي هذه المناسبة صرح الأستاذ عدنان أحمد يوسف عضو مجلس الإدارة والرئيس التنفيذي لمجموعة البركة المصرفية &quot;نحن سعداء اليوم بإطلاق بنكنا التشاركي، BTI Bank في المغرب الشقيق، والذي يعد ثمرة شراكة متينة مع مجموعة البنك المغربي للتجارة الخارجية لإفريقيا. ونحن واثقون من الفرص الكبيرة لنجاح هذا البنك نظراً لما يتمتع به المغرب من إمكانات تنموية مهمة وواعدة في مجال البنوك التشاركية. وقد بينت الدراسات المنجزة الفرص الاستثمارية والتمويلية الواعدة التي تنتظر خدمات ومنتجات هذا البنك. ونحن نسعى اليوم إلى وضع تجربتنا وخبرتنا رهن إشارة السوق المغربي من خلال BTI Bank، وبالتالي المساهمة في نمو هذا البلد الشقيق وازدهاره&quot;.<br />\r\n<br />\r\nوأضاف الأستاذ عدنان: لقد قمنا من جانبنا بدراسة الشراكة ما بين مجموعة البركة المصرفية ومجموعة البنك المغربي للتجارة الخارجية لإفريقيا بكل تمعن وتدقيق للخلوص إلى صيغة تكاملية للعمل بين المؤسستين تجمع ما بين الخبرات والاستفادة على أكمل وجه من نقاط القوة الموجودة لدى كلا الطرفين، وكل هذا في إطار صيغة الصيرفة التشاركية وعلى أسس سليمة ومستدامة. فالهدف يتلخص في السعي إلى إحداث منظومة للتعاون تتيح تبادل المهارات وخلق بنك متفرد بالمغرب، واستشراف مستقبل واعد له على الصعيد المغاربي والإفريقي. من جهته قال الأستاذ إبراهيم بنجلون التويمي، المتصرف المدير العام التنفيذي لمجموعة البنك المغربي للتجارة الخارجية لأفريقيا ورئيس بنك أفريقيا: إن إطلاق BTI Bank هو بمثابة تتويج لأشهر عديدة من العمل والتعاون الوثيق مع شريكنا مجموعة البركة المصرفية، والتي نتقاسم معها العديد من القيم والرؤى المستقبلية الطموحة. ونحن مقتنعون بأن التئام الخبرة التأريخية لشريكنا ودرايته القوية للسوق، سيمكننا من جعلBTI Bank بنكا تشاركيا مرجعيا بالمغرب&quot;. وقال الأستاذ محمد معروف المدير العام لبنك BTI Bank : لقد سعت كل من مجموعة البركة المصرفية والبنك المغربي للتجارة الخارجية لإفريقيا لتأسيس نموذج جديد للبنك التشاركي في السوق المغربي، والذي يشهد هيكلة تدريجية، تتزامن مع وضع وتطوير المنظومات التشريعية التي ستضمن تطوره. ونحن نطمح بأن نصبح بسرعة شريكا بنكيا حقيقيا وموثوقا للأفراد والمهنيين والأعمال لاسيما من خلال علاقة متكافئة، علاقة تسودها القيم والمنفعة المتبادلة للطرفين. كما نطمح من خلال ذلك إلى المساهمة في خلق نظام مالي يكافئ المجهود ويساهم في تنمية المجتمع&quot;. ويلتزمBTI Bank بتطوير حلول ملموسة و عملية للاحتياجات التمويلية والاستثمارية للسوق المغربي. وتقديم تشكيلة متنوعة من المنتجات والخدمات الملائمة لحاجيات ومتطلبات الجميع. وبهذا، سيستفيد الأفراد من تشكيلة واسعة من الحسابات والبطاقات البنكية، إلى جانب حلول تمويل شراء العقارات، والسيارات والتجهيزات، وحسابات التوفير والودائع. أما فيما يخص المهنيين والمقاولات والشركات والأعمال، فسوف تستفيد من خدمات مصممة بعناية لتلبية احتياجاتها بكل يسر ومرونة، إلى جانب ما يملكه البنك من خبرات لترتيب العمليات التمويلية الاعتيادية والإشراف على ترتيب التمويلات للمشاريع المركبة والأكثر تعقيدا. علاوة على كل ذلك، هناك العديد من الخدمات سوف يتعرف عليها الزبائن لدى زيارتهم مقر البنك، والذي سوف يتم تدشينه اليوم على العنوان التالي: 161، محج الحسن الثاني بالدار البيضاء. ومن المنتظر أن يكون هذ المقر هو باكورة تأسيس شبكة واسعة من الفروع التي ستضم بحلول 2022 الى مجموعه 37 فرعاً في مختلف المدن المغربية، مدعمة بخدمات مصرفية آليه وقنوات الشبكة الإلكترونية. ويطمح بنك BTI Bank من خلال ذلك خلق شراكات حقيقية مع زبائنه تفسح المجال أمام البنك وكل واحد من عملائه للمساهمة في تنمية الجميع، وأيضا لكي يكون البنك شريكا في تحقيق النجاح والطموحات لكل واحد منهم.</div>\r\n', 1519509600, 1519509600, 'ar', 34, 1, '5a9274c6b6601.jpg', 0, 1, 1, 'C:\\wamp64\\www\\flexcms\\protected/../uploads/Article/files/attachment5a9274c6833e4.pdf', 'attachment5a9274c6833e4.pdf', NULL);

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

--
-- Table structure for table `article_album`
--

CREATE TABLE `article_album` (
  `id` int(11) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `image` varchar(45) NOT NULL,
  `article_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `article_has_category`
--

CREATE TABLE `article_has_category` (
  `article_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `article_has_category`
--

INSERT INTO `article_has_category` (`article_id`, `category_id`) VALUES
(1, 2),
(2, 2),
(3, 2),
(3, 3);

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

--
-- Table structure for table `authassignment`
--

CREATE TABLE `authassignment` (
  `itemname` varchar(64) NOT NULL,
  `userid` varchar(64) NOT NULL,
  `bizrule` text,
  `data` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authassignment`
--

INSERT INTO `authassignment` (`itemname`, `userid`, `bizrule`, `data`) VALUES
('Admin', '1', NULL, 'N;'),
('Authenticated', '1', NULL, 'N;');

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

--
-- Table structure for table `authitem`
--

CREATE TABLE `authitem` (
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `description` text,
  `bizrule` text,
  `data` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authitem`
--

INSERT INTO `authitem` (`name`, `type`, `description`, `bizrule`, `data`) VALUES
('Admin', 2, NULL, NULL, 'N;'),
('Admin.Article.*', 1, NULL, NULL, 'N;'),
('Admin.ArticleAlbum.*', 1, NULL, NULL, 'N;'),
('Admin.Category.*', 1, NULL, NULL, 'N;'),
('Admin.Comment.*', 1, NULL, NULL, 'N;'),
('Admin.Default.*', 1, NULL, NULL, 'N;'),
('Admin.Htmlblock.*', 1, NULL, NULL, 'N;'),
('Admin.Newsletter.*', 1, NULL, NULL, 'N;'),
('Admin.NewsletterSubscriber.*', 1, NULL, NULL, 'N;'),
('Admin.Option.*', 1, NULL, NULL, 'N;'),
('Admin.OptionGroup.*', 1, NULL, NULL, 'N;'),
('Admin.Page.*', 1, NULL, NULL, 'N;'),
('Authenticated', 2, 'Authenticated user', NULL, 'N;'),
('Career.Career.*', 1, NULL, NULL, 'N;'),
('Employee.Employee.*', 1, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.*', 1, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.Admin', 0, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.Create', 0, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.Delete', 0, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.Index', 0, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.Update', 0, NULL, NULL, 'N;'),
('EmploymentApplication.EmploymentApplication.View', 0, NULL, NULL, 'N;'),
('Falbums.Album.*', 1, NULL, NULL, 'N;'),
('Falbums.AlbumImage.*', 1, NULL, NULL, 'N;'),
('FAQ.Faq.*', 1, NULL, NULL, 'N;'),
('FAQ.Faq.Admin', 0, NULL, NULL, 'N;'),
('FAQ.Faq.Create', 0, NULL, NULL, 'N;'),
('FAQ.Faq.Delete', 0, NULL, NULL, 'N;'),
('FAQ.Faq.Index', 0, NULL, NULL, 'N;'),
('FAQ.Faq.Update', 0, NULL, NULL, 'N;'),
('FAQ.Faq.View', 0, NULL, NULL, 'N;'),
('Fmenu.Menu.*', 1, NULL, NULL, 'N;'),
('Fmenu.MenuItem.*', 1, NULL, NULL, 'N;'),
('Fmessage.Locale.*', 1, NULL, NULL, 'N;'),
('Fmessage.Message.*', 1, NULL, NULL, 'N;'),
('Fmessage.SourceMessage.*', 1, NULL, NULL, 'N;'),
('Fnewsletter.Default.*', 1, NULL, NULL, 'N;'),
('Fnewsletter.Newsletter.*', 1, NULL, NULL, 'N;'),
('Fnewsletter.NewsletterSubscriber.*', 1, NULL, NULL, 'N;'),
('FormBuilder.Default.*', 1, NULL, NULL, 'N;'),
('FormBuilder.Form.*', 1, NULL, NULL, 'N;'),
('FormBuilder.FormButton.*', 1, NULL, NULL, 'N;'),
('FormBuilder.FormElement.*', 1, NULL, NULL, 'N;'),
('FormBuilder.FormElementValidator.*', 1, NULL, NULL, 'N;'),
('FormBuilder.FormValidator.*', 1, NULL, NULL, 'N;'),
('Fslider.Slider.*', 1, NULL, NULL, 'N;'),
('Fslider.SliderImages.*', 1, NULL, NULL, 'N;'),
('Ftabber.Tabber.*', 1, NULL, NULL, 'N;'),
('Ftabber.TabberTab.*', 1, NULL, NULL, 'N;'),
('GoogleMaps.GoogleMap.*', 1, NULL, NULL, 'N;'),
('GoogleMaps.GoogleMapMarker.*', 1, NULL, NULL, 'N;'),
('Guest', 2, 'Guest user', NULL, 'N;'),
('NewsletterSubscriber.Create', 0, NULL, NULL, 'N;'),
('Poll.Poll.*', 1, NULL, NULL, 'N;'),
('Poll.Pollchoice.*', 1, NULL, NULL, 'N;'),
('Poll.Pollvote.*', 1, NULL, NULL, 'N;'),
('Questionnaire.Questionnaire.*', 1, NULL, NULL, 'N;'),
('Questionnaire.QuestionnaireAnswer.*', 1, NULL, NULL, 'N;'),
('Questionnaire.QuestionnaireQuestion.*', 1, NULL, NULL, 'N;'),
('Site.*', 1, NULL, NULL, 'N;'),
('Site.Index', 0, NULL, NULL, 'N;'),
('User.Activation.*', 1, NULL, NULL, 'N;'),
('User.Admin.*', 1, NULL, NULL, 'N;'),
('User.Default.*', 1, NULL, NULL, 'N;'),
('User.Login.*', 1, NULL, NULL, 'N;'),
('User.Logout.*', 1, NULL, NULL, 'N;'),
('User.Profile.*', 1, NULL, NULL, 'N;'),
('User.ProfileField.*', 1, NULL, NULL, 'N;'),
('User.Recovery.*', 1, NULL, NULL, 'N;'),
('User.Registration.*', 1, NULL, NULL, 'N;'),
('User.User.*', 1, NULL, NULL, 'N;'),
('Widgets.Default.*', 1, NULL, NULL, 'N;'),
('Widgets.Widget.*', 1, NULL, NULL, 'N;'),
('Widgets.WidgetInstance.*', 1, NULL, NULL, 'N;');

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

--
-- Table structure for table `authitemchild`
--

CREATE TABLE `authitemchild` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authitemchild`
--

INSERT INTO `authitemchild` (`parent`, `child`) VALUES
('Admin', 'Admin.Article.*'),
('Admin', 'Admin.ArticleAlbum.*'),
('Admin', 'Admin.Category.*'),
('Admin', 'Admin.Comment.*'),
('Admin', 'Admin.Default.*'),
('Admin', 'Admin.Htmlblock.*'),
('Admin', 'Admin.Newsletter.*'),
('Admin', 'Admin.NewsletterSubscriber.*'),
('Admin', 'Admin.Option.*'),
('Admin', 'Admin.OptionGroup.*'),
('Admin', 'Admin.Page.*'),
('Admin', 'Career.Career.*'),
('Admin', 'Employee.Employee.*'),
('Admin', 'EmploymentApplication.EmploymentApplication.Admin'),
('Admin', 'EmploymentApplication.EmploymentApplication.Create'),
('Admin', 'EmploymentApplication.EmploymentApplication.Delete'),
('Admin', 'EmploymentApplication.EmploymentApplication.Index'),
('Admin', 'EmploymentApplication.EmploymentApplication.Update'),
('Admin', 'EmploymentApplication.EmploymentApplication.View'),
('Admin', 'Falbums.Album.*'),
('Admin', 'Falbums.AlbumImage.*'),
('Admin', 'FAQ.Faq.*'),
('Admin', 'FAQ.Faq.Admin'),
('Authenticated', 'FAQ.Faq.Admin'),
('Guest', 'FAQ.Faq.Admin'),
('Admin', 'FAQ.Faq.Create'),
('Authenticated', 'FAQ.Faq.Create'),
('Guest', 'FAQ.Faq.Create'),
('Admin', 'FAQ.Faq.Delete'),
('Authenticated', 'FAQ.Faq.Delete'),
('Guest', 'FAQ.Faq.Delete'),
('Admin', 'FAQ.Faq.Index'),
('Authenticated', 'FAQ.Faq.Index'),
('Guest', 'FAQ.Faq.Index'),
('Admin', 'FAQ.Faq.Update'),
('Authenticated', 'FAQ.Faq.Update'),
('Guest', 'FAQ.Faq.Update'),
('Admin', 'FAQ.Faq.View'),
('Authenticated', 'FAQ.Faq.View'),
('Guest', 'FAQ.Faq.View'),
('Admin', 'Fmenu.Menu.*'),
('Admin', 'Fmenu.MenuItem.*'),
('Admin', 'Fmessage.Locale.*'),
('Admin', 'Fmessage.Message.*'),
('Admin', 'Fmessage.SourceMessage.*'),
('Admin', 'Fnewsletter.Default.*'),
('Admin', 'Fnewsletter.Newsletter.*'),
('Admin', 'Fnewsletter.NewsletterSubscriber.*'),
('Admin', 'FormBuilder.Default.*'),
('Admin', 'FormBuilder.Form.*'),
('Admin', 'FormBuilder.FormButton.*'),
('Admin', 'FormBuilder.FormElement.*'),
('Admin', 'FormBuilder.FormElementValidator.*'),
('Admin', 'FormBuilder.FormValidator.*'),
('Admin', 'Fslider.Slider.*'),
('Admin', 'Fslider.SliderImages.*'),
('Admin', 'Ftabber.Tabber.*'),
('Admin', 'Ftabber.TabberTab.*'),
('Admin', 'GoogleMaps.GoogleMap.*'),
('Admin', 'GoogleMaps.GoogleMapMarker.*'),
('Admin', 'NewsletterSubscriber.Create'),
('Admin', 'Poll.Poll.*'),
('Admin', 'Poll.Pollchoice.*'),
('Admin', 'Poll.Pollvote.*'),
('Admin', 'Questionnaire.Questionnaire.*'),
('Admin', 'Questionnaire.QuestionnaireAnswer.*'),
('Admin', 'Questionnaire.QuestionnaireQuestion.*'),
('Admin', 'Site.Index'),
('Authenticated', 'Site.Index'),
('Guest', 'Site.Index'),
('Admin', 'User.Activation.*'),
('Admin', 'User.Admin.*'),
('Admin', 'User.Default.*'),
('Admin', 'User.Login.*'),
('Admin', 'User.Logout.*'),
('Admin', 'User.Profile.*'),
('Admin', 'User.ProfileField.*'),
('Admin', 'User.Recovery.*'),
('Admin', 'User.Registration.*'),
('Admin', 'User.User.*'),
('Admin', 'Widgets.Default.*'),
('Admin', 'Widgets.Widget.*'),
('Admin', 'Widgets.WidgetInstance.*');

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

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

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `language` char(2) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `category` (`id`, `title`, `slug`, `language`, `create_datetime`, `update_datetime`, `parent_id`) VALUES
(1, 'الأخبار', 'news', 'ar', 1519211312, 1519211312, NULL),
(2, 'أخبار بنك البركة', 'albarakeh-bank-news', 'ar', 1519211359, 1519211404, 1),
(3, 'أخبار مجموعة البركة', 'albarakeh-group-news', 'ar', 1519211396, 1519211396, 1),
(4, 'أخبار المسؤولية الاجتماعية لبنك البركة سورية', 'albarakeh-social-news', 'ar', 1519211436, 1519211436, 1),
(5, 'الخدمات', 'services', 'ar', 1519632615, 1519632615, NULL);

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

--
-- Table structure for table `category_feature`
--

CREATE TABLE `category_feature` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `feature_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `id` int(11) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `sender_email` varchar(100) DEFAULT NULL,
  `sender_homepage` varchar(100) DEFAULT NULL,
  `body` text NOT NULL,
  `ip_address` int(11) NOT NULL,
  `country` char(2) NOT NULL,
  `user_agent` varchar(300) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `owner_route` varchar(100) NOT NULL,
  `owner_params` varchar(300) NOT NULL,
  `parent_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `fname` varchar(60) NOT NULL,
  `lname` varchar(60) NOT NULL,
  `position` varchar(100) DEFAULT NULL,
  `tel` int(11) NOT NULL,
  `mob` int(11) NOT NULL,
  `email` varchar(60) NOT NULL,
  `alternative_email` varchar(60) DEFAULT NULL,
  `address` varchar(100) NOT NULL,
  `notes` text,
  `arabic_notes` text NOT NULL,
  `account_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int(11) NOT NULL,
  `answer` text NOT NULL,
  `question` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fmessage_locale`
--

CREATE TABLE `fmessage_locale` (
  `id` int(11) NOT NULL,
  `locale` varchar(13) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `default` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fmessage_locale`
--

INSERT INTO `fmessage_locale` (`id`, `locale`, `active`, `default`) VALUES
(1, 'zu_za', 0, 1),
(2, 'zu', 0, 0),
(3, 'zh_tw', 0, 0),
(4, 'zh_sg', 0, 0),
(5, 'aa', 0, 0),
(6, 'aa_dj', 0, 0),
(7, 'aa_er', 0, 0),
(8, 'aa_et', 0, 0),
(9, 'af', 0, 0),
(10, 'af_na', 0, 0),
(11, 'af_za', 0, 0),
(12, 'agq', 0, 0),
(13, 'agq_cm', 0, 0),
(14, 'ak', 0, 0),
(15, 'ak_gh', 0, 0),
(16, 'am', 0, 0),
(17, 'am_et', 0, 0),
(18, 'ar', 1, 0),
(19, 'ar_001', 0, 0),
(20, 'ar_ae', 0, 0),
(21, 'ar_bh', 0, 0),
(22, 'ar_dz', 0, 0),
(23, 'ar_eg', 0, 0),
(24, 'ar_iq', 0, 0),
(25, 'ar_jo', 0, 0),
(26, 'ar_kw', 0, 0),
(27, 'ar_lb', 0, 0),
(28, 'ar_ly', 0, 0),
(29, 'ar_ma', 0, 0),
(30, 'ar_om', 0, 0),
(31, 'ar_qa', 0, 0),
(32, 'ar_sa', 0, 0),
(33, 'ar_sd', 0, 0),
(34, 'ar_sy', 0, 0),
(35, 'ar_tn', 0, 0),
(36, 'ar_ye', 0, 0),
(37, 'as', 0, 0),
(38, 'as_in', 0, 0),
(39, 'asa', 0, 0),
(40, 'asa_tz', 0, 0),
(41, 'az', 0, 0),
(42, 'az_arab', 0, 0),
(43, 'az_arab_ir', 0, 0),
(44, 'az_az', 0, 0),
(45, 'az_cyrl', 0, 0),
(46, 'az_cyrl_az', 0, 0),
(47, 'az_ir', 0, 0),
(48, 'az_latn', 0, 0),
(49, 'az_latn_az', 0, 0),
(50, 'bas', 0, 0),
(51, 'bas_cm', 0, 0),
(52, 'be', 0, 0),
(53, 'be_by', 0, 0),
(54, 'bem', 0, 0),
(55, 'bem_zm', 0, 0),
(56, 'bez', 0, 0),
(57, 'bez_tz', 0, 0),
(58, 'bg', 0, 0),
(59, 'bg_bg', 0, 0),
(60, 'bm', 0, 0),
(61, 'bm_ml', 0, 0),
(62, 'bn', 0, 0),
(63, 'bn_bd', 0, 0),
(64, 'bn_in', 0, 0),
(65, 'bo', 0, 0),
(66, 'bo_cn', 0, 0),
(67, 'bo_in', 0, 0),
(68, 'br', 0, 0),
(69, 'br_fr', 0, 0),
(70, 'brx', 0, 0),
(71, 'brx_in', 0, 0),
(72, 'bs', 0, 0),
(73, 'bs_ba', 0, 0),
(74, 'byn', 0, 0),
(75, 'byn_er', 0, 0),
(76, 'ca', 0, 0),
(77, 'ca_es', 0, 0),
(78, 'cch', 0, 0),
(79, 'cch_ng', 0, 0),
(80, 'cgg', 0, 0),
(81, 'cgg_ug', 0, 0),
(82, 'chr', 0, 0),
(83, 'chr_us', 0, 0),
(84, 'cs', 0, 0),
(85, 'cs_cz', 0, 0),
(86, 'cy', 0, 0),
(87, 'cy_gb', 0, 0),
(88, 'da', 0, 0),
(89, 'da_dk', 0, 0),
(90, 'dav', 0, 0),
(91, 'dav_ke', 0, 0),
(92, 'de', 1, 0),
(93, 'de_at', 0, 0),
(94, 'de_be', 0, 0),
(95, 'de_ch', 0, 0),
(96, 'de_de', 0, 0),
(97, 'de_li', 0, 0),
(98, 'de_lu', 0, 0),
(99, 'dje', 0, 0),
(100, 'dje_ne', 0, 0),
(101, 'dua', 0, 0),
(102, 'dua_cm', 0, 0),
(103, 'dv', 0, 0),
(104, 'dv_mv', 0, 0),
(105, 'dyo', 0, 0),
(106, 'dyo_sn', 0, 0),
(107, 'dz', 0, 0),
(108, 'dz_bt', 0, 0),
(109, 'ebu', 0, 0),
(110, 'ebu_ke', 0, 0),
(111, 'ee', 0, 0),
(112, 'ee_gh', 0, 0),
(113, 'ee_tg', 0, 0),
(114, 'el', 0, 0),
(115, 'el_cy', 0, 0),
(116, 'el_gr', 0, 0),
(117, 'el_polyton', 0, 0),
(118, 'en', 1, 1),
(119, 'en_as', 0, 0),
(120, 'en_au', 0, 0),
(121, 'en_bb', 0, 0),
(122, 'en_be', 0, 0),
(123, 'en_bm', 0, 0),
(124, 'en_bw', 0, 0),
(125, 'en_bz', 0, 0),
(126, 'en_ca', 0, 0),
(127, 'en_dsrt', 0, 0),
(128, 'en_dsrt_us', 0, 0),
(129, 'en_gb', 0, 0),
(130, 'en_gu', 0, 0),
(131, 'en_gy', 0, 0),
(132, 'en_hk', 0, 0),
(133, 'en_ie', 0, 0),
(134, 'en_in', 0, 0),
(135, 'en_jm', 0, 0),
(136, 'en_mh', 0, 0),
(137, 'en_mp', 0, 0),
(138, 'en_mt', 0, 0),
(139, 'en_mu', 0, 0),
(140, 'en_na', 0, 0),
(141, 'en_nz', 0, 0),
(142, 'en_ph', 0, 0),
(143, 'en_pk', 0, 0),
(144, 'en_sg', 0, 0),
(145, 'en_shaw', 0, 0),
(146, 'en_tt', 0, 0),
(147, 'en_um', 0, 0),
(148, 'en_us', 0, 0),
(149, 'en_us_posix', 0, 0),
(150, 'en_vi', 0, 0),
(151, 'en_za', 0, 0),
(152, 'en_zw', 0, 0),
(153, 'en_zz', 0, 0),
(154, 'eo', 0, 0),
(155, 'es', 0, 0),
(156, 'es_419', 0, 0),
(157, 'es_ar', 0, 0),
(158, 'es_bo', 0, 0),
(159, 'es_cl', 0, 0),
(160, 'es_co', 0, 0),
(161, 'es_cr', 0, 0),
(162, 'es_do', 0, 0),
(163, 'es_ec', 0, 0),
(164, 'es_es', 0, 0),
(165, 'es_gq', 0, 0),
(166, 'es_gt', 0, 0),
(167, 'es_hn', 0, 0),
(168, 'es_mx', 0, 0),
(169, 'es_ni', 0, 0),
(170, 'es_pa', 0, 0),
(171, 'es_pe', 0, 0),
(172, 'es_pr', 0, 0),
(173, 'es_py', 0, 0),
(174, 'es_sv', 0, 0),
(175, 'es_us', 0, 0),
(176, 'es_uy', 0, 0),
(177, 'es_ve', 0, 0),
(178, 'et', 0, 0),
(179, 'et_ee', 0, 0),
(180, 'eu', 0, 0),
(181, 'eu_es', 0, 0),
(182, 'ewo', 0, 0),
(183, 'ewo_cm', 0, 0),
(184, 'fa', 0, 0),
(185, 'fa_af', 0, 0),
(186, 'fa_ir', 0, 0),
(187, 'ff', 0, 0),
(188, 'ff_sn', 0, 0),
(189, 'fi', 0, 0),
(190, 'fi_fi', 0, 0),
(191, 'fil', 0, 0),
(192, 'fil_ph', 0, 0),
(193, 'fo', 0, 0),
(194, 'fo_fo', 0, 0),
(195, 'fr', 0, 0),
(196, 'fr_be', 0, 0),
(197, 'fr_bf', 0, 0),
(198, 'fr_bi', 0, 0),
(199, 'fr_bj', 0, 0),
(200, 'fr_bl', 0, 0),
(201, 'fr_ca', 0, 0),
(202, 'fr_cd', 0, 0),
(203, 'fr_cf', 0, 0),
(204, 'fr_cg', 0, 0),
(205, 'fr_ch', 0, 0),
(206, 'fr_ci', 0, 0),
(207, 'fr_cm', 0, 0),
(208, 'fr_dj', 0, 0),
(209, 'fr_fr', 0, 0),
(210, 'fr_ga', 0, 0),
(211, 'fr_gf', 0, 0),
(212, 'fr_gn', 0, 0),
(213, 'fr_gp', 0, 0),
(214, 'fr_gq', 0, 0),
(215, 'fr_km', 0, 0),
(216, 'fr_lu', 0, 0),
(217, 'fr_mc', 0, 0),
(218, 'fr_mf', 0, 0),
(219, 'fr_mg', 0, 0),
(220, 'fr_ml', 0, 0),
(221, 'fr_mq', 0, 0),
(222, 'fr_ne', 0, 0),
(223, 'fr_re', 0, 0),
(224, 'fr_rw', 0, 0),
(225, 'fr_sn', 0, 0),
(226, 'fr_td', 0, 0),
(227, 'fr_tg', 0, 0),
(228, 'fr_yt', 0, 0),
(229, 'fur', 0, 0),
(230, 'fur_it', 0, 0),
(231, 'ga', 0, 0),
(232, 'ga_ie', 0, 0),
(233, 'gaa', 0, 0),
(234, 'gaa_gh', 0, 0),
(235, 'gd', 0, 0),
(236, 'gd_gb', 0, 0),
(237, 'gez', 0, 0),
(238, 'gez_er', 0, 0),
(239, 'gez_et', 0, 0),
(240, 'gl', 0, 0),
(241, 'gl_es', 0, 0),
(242, 'gsw', 0, 0),
(243, 'gsw_ch', 0, 0),
(244, 'gu', 0, 0),
(245, 'gu_in', 0, 0),
(246, 'guz', 0, 0),
(247, 'guz_ke', 0, 0),
(248, 'gv', 0, 0),
(249, 'gv_gb', 0, 0),
(250, 'ha', 0, 0),
(251, 'ha_arab', 0, 0),
(252, 'ha_arab_ng', 0, 0),
(253, 'ha_arab_sd', 0, 0),
(254, 'ha_gh', 0, 0),
(255, 'ha_latn', 0, 0),
(256, 'ha_latn_gh', 0, 0),
(257, 'ha_latn_ne', 0, 0),
(258, 'ha_latn_ng', 0, 0),
(259, 'ha_ne', 0, 0),
(260, 'ha_ng', 0, 0),
(261, 'ha_sd', 0, 0),
(262, 'haw', 0, 0),
(263, 'haw_us', 0, 0),
(264, 'he', 0, 0),
(265, 'he_il', 0, 0),
(266, 'hi', 0, 0),
(267, 'hi_in', 0, 0),
(268, 'hr', 0, 0),
(269, 'hr_hr', 0, 0),
(270, 'hu', 0, 0),
(271, 'hu_hu', 0, 0),
(272, 'hy', 0, 0),
(273, 'hy_am', 0, 0),
(274, 'ia', 0, 0),
(275, 'id', 0, 0),
(276, 'id_id', 0, 0),
(277, 'ig', 0, 0),
(278, 'ig_ng', 0, 0),
(279, 'ii', 0, 0),
(280, 'ii_cn', 0, 0),
(281, 'in', 0, 0),
(282, 'is', 0, 0),
(283, 'is_is', 0, 0),
(284, 'it', 0, 0),
(285, 'it_ch', 0, 0),
(286, 'it_it', 0, 0),
(287, 'iu', 0, 0),
(288, 'iw', 0, 0),
(289, 'ja', 0, 0),
(290, 'ja_jp', 0, 0),
(291, 'jmc', 0, 0),
(292, 'jmc_tz', 0, 0),
(293, 'ka', 0, 0),
(294, 'ka_ge', 0, 0),
(295, 'kab', 0, 0),
(296, 'kab_dz', 0, 0),
(297, 'kaj', 0, 0),
(298, 'kaj_ng', 0, 0),
(299, 'kam', 0, 0),
(300, 'kam_ke', 0, 0),
(301, 'kcg', 0, 0),
(302, 'kcg_ng', 0, 0),
(303, 'kde', 0, 0),
(304, 'kde_tz', 0, 0),
(305, 'kea', 0, 0),
(306, 'kea_cv', 0, 0),
(307, 'kfo', 0, 0),
(308, 'kfo_ci', 0, 0),
(309, 'khq', 0, 0),
(310, 'khq_ml', 0, 0),
(311, 'ki', 0, 0),
(312, 'ki_ke', 0, 0),
(313, 'kk', 0, 0),
(314, 'kk_cyrl', 0, 0),
(315, 'kk_cyrl_kz', 0, 0),
(316, 'kk_kz', 0, 0),
(317, 'kl', 0, 0),
(318, 'kl_gl', 0, 0),
(319, 'kln', 0, 0),
(320, 'kln_ke', 0, 0),
(321, 'km', 0, 0),
(322, 'km_kh', 0, 0),
(323, 'kn', 0, 0),
(324, 'kn_in', 0, 0),
(325, 'ko', 0, 0),
(326, 'ko_kr', 0, 0),
(327, 'kok', 0, 0),
(328, 'kok_in', 0, 0),
(329, 'kpe', 0, 0),
(330, 'kpe_gn', 0, 0),
(331, 'kpe_lr', 0, 0),
(332, 'ksb', 0, 0),
(333, 'ksb_tz', 0, 0),
(334, 'ksf', 0, 0),
(335, 'ksf_cm', 0, 0),
(336, 'ksh', 0, 0),
(337, 'ksh_de', 0, 0),
(338, 'ku', 0, 0),
(339, 'ku_arab', 0, 0),
(340, 'ku_arab_iq', 0, 0),
(341, 'ku_arab_ir', 0, 0),
(342, 'ku_iq', 0, 0),
(343, 'ku_ir', 0, 0),
(344, 'ku_latn', 0, 0),
(345, 'ku_latn_sy', 0, 0),
(346, 'ku_latn_tr', 0, 0),
(347, 'ku_sy', 0, 0),
(348, 'ku_tr', 0, 0),
(349, 'kw', 0, 0),
(350, 'kw_gb', 0, 0),
(351, 'ky', 0, 0),
(352, 'ky_kg', 0, 0),
(353, 'lag', 0, 0),
(354, 'lag_tz', 0, 0),
(355, 'lg', 0, 0),
(356, 'lg_ug', 0, 0),
(357, 'ln', 0, 0),
(358, 'ln_cd', 0, 0),
(359, 'ln_cg', 0, 0),
(360, 'lo', 0, 0),
(361, 'lo_la', 0, 0),
(362, 'lt', 0, 0),
(363, 'lt_lt', 0, 0),
(364, 'lu', 0, 0),
(365, 'lu_cd', 0, 0),
(366, 'luo', 0, 0),
(367, 'luo_ke', 0, 0),
(368, 'luy', 0, 0),
(369, 'luy_ke', 0, 0),
(370, 'lv', 0, 0),
(371, 'lv_lv', 0, 0),
(372, 'mas', 0, 0),
(373, 'mas_ke', 0, 0),
(374, 'mas_tz', 0, 0),
(375, 'mer', 0, 0),
(376, 'mer_ke', 0, 0),
(377, 'mfe', 0, 0),
(378, 'mfe_mu', 0, 0),
(379, 'mg', 0, 0),
(380, 'mg_mg', 0, 0),
(381, 'mgh', 0, 0),
(382, 'mgh_mz', 0, 0),
(383, 'mi', 0, 0),
(384, 'mi_nz', 0, 0),
(385, 'mk', 0, 0),
(386, 'mk_mk', 0, 0),
(387, 'ml', 0, 0),
(388, 'ml_in', 0, 0),
(389, 'mn', 0, 0),
(390, 'mn_cn', 0, 0),
(391, 'mn_cyrl', 0, 0),
(392, 'mn_cyrl_mn', 0, 0),
(393, 'mn_mn', 0, 0),
(394, 'mn_mong', 0, 0),
(395, 'mn_mong_cn', 0, 0),
(396, 'mo', 0, 0),
(397, 'mr', 0, 0),
(398, 'mr_in', 0, 0),
(399, 'ms', 0, 0),
(400, 'ms_bn', 0, 0),
(401, 'ms_my', 0, 0),
(402, 'mt', 0, 0),
(403, 'mt_mt', 0, 0),
(404, 'mua', 0, 0),
(405, 'mua_cm', 0, 0),
(406, 'my', 0, 0),
(407, 'my_mm', 0, 0),
(408, 'naq', 0, 0),
(409, 'naq_na', 0, 0),
(410, 'nb', 0, 0),
(411, 'nb_no', 0, 0),
(412, 'nd', 0, 0),
(413, 'nd_zw', 0, 0),
(414, 'nds', 0, 0),
(415, 'nds_de', 0, 0),
(416, 'ne', 0, 0),
(417, 'ne_in', 0, 0),
(418, 'ne_np', 0, 0),
(419, 'nl', 0, 0),
(420, 'nl_aw', 0, 0),
(421, 'nl_be', 0, 0),
(422, 'nl_cw', 0, 0),
(423, 'nl_nl', 0, 0),
(424, 'nl_sx', 0, 0),
(425, 'nmg', 0, 0),
(426, 'nmg_cm', 0, 0),
(427, 'nn', 0, 0),
(428, 'nn_no', 0, 0),
(429, 'no', 0, 0),
(430, 'nr', 0, 0),
(431, 'nr_za', 0, 0),
(432, 'nso', 0, 0),
(433, 'nso_za', 0, 0),
(434, 'nus', 0, 0),
(435, 'nus_sd', 0, 0),
(436, 'ny', 0, 0),
(437, 'ny_mw', 0, 0),
(438, 'nyn', 0, 0),
(439, 'nyn_ug', 0, 0),
(440, 'oc', 0, 0),
(441, 'oc_fr', 0, 0),
(442, 'om', 0, 0),
(443, 'om_et', 0, 0),
(444, 'om_ke', 0, 0),
(445, 'or', 0, 0),
(446, 'or_in', 0, 0),
(447, 'pa', 0, 0),
(448, 'pa_arab', 0, 0),
(449, 'pa_arab_pk', 0, 0),
(450, 'pa_guru', 0, 0),
(451, 'pa_guru_in', 0, 0),
(452, 'pa_in', 0, 0),
(453, 'pa_pk', 0, 0),
(454, 'pl', 0, 0),
(455, 'pl_pl', 0, 0),
(456, 'ps', 0, 0),
(457, 'ps_af', 0, 0),
(458, 'pt', 0, 0),
(459, 'pt_ao', 0, 0),
(460, 'pt_br', 0, 0),
(461, 'pt_gw', 0, 0),
(462, 'pt_mz', 0, 0),
(463, 'pt_pt', 0, 0),
(464, 'pt_st', 0, 0),
(465, 'rm', 0, 0),
(466, 'rm_ch', 0, 0),
(467, 'rn', 0, 0),
(468, 'rn_bi', 0, 0),
(469, 'ro', 0, 0),
(470, 'ro_md', 0, 0),
(471, 'ro_ro', 0, 0),
(472, 'rof', 0, 0),
(473, 'rof_tz', 0, 0),
(474, 'root', 0, 0),
(475, 'ru', 0, 0),
(476, 'ru_md', 0, 0),
(477, 'ru_ru', 0, 0),
(478, 'ru_ua', 0, 0),
(479, 'rw', 0, 0),
(480, 'rw_rw', 0, 0),
(481, 'rwk', 0, 0),
(482, 'rwk_tz', 0, 0),
(483, 'sa', 0, 0),
(484, 'sa_in', 0, 0),
(485, 'sah', 0, 0),
(486, 'sah_ru', 0, 0),
(487, 'saq', 0, 0),
(488, 'saq_ke', 0, 0),
(489, 'sbp', 0, 0),
(490, 'sbp_tz', 0, 0),
(491, 'se', 0, 0),
(492, 'se_fi', 0, 0),
(493, 'se_no', 0, 0),
(494, 'seh', 0, 0),
(495, 'seh_mz', 0, 0),
(496, 'ses', 0, 0),
(497, 'ses_ml', 0, 0),
(498, 'sg', 0, 0),
(499, 'sg_cf', 0, 0),
(500, 'sh', 0, 0),
(501, 'sh_ba', 0, 0),
(502, 'sh_cs', 0, 0),
(503, 'sh_yu', 0, 0),
(504, 'shi', 0, 0),
(505, 'shi_latn', 0, 0),
(506, 'shi_latn_ma', 0, 0),
(507, 'shi_ma', 0, 0),
(508, 'shi_tfng', 0, 0),
(509, 'shi_tfng_ma', 0, 0),
(510, 'si', 0, 0),
(511, 'si_lk', 0, 0),
(512, 'sid', 0, 0),
(513, 'sid_et', 0, 0),
(514, 'sk', 0, 0),
(515, 'sk_sk', 0, 0),
(516, 'sl', 0, 0),
(517, 'sl_si', 0, 0),
(518, 'sn', 0, 0),
(519, 'sn_zw', 0, 0),
(520, 'so', 0, 0),
(521, 'so_dj', 0, 0),
(522, 'so_et', 0, 0),
(523, 'so_ke', 0, 0),
(524, 'so_so', 0, 0),
(525, 'sq', 0, 0),
(526, 'sq_al', 0, 0),
(527, 'sr', 0, 0),
(528, 'sr_ba', 0, 0),
(529, 'sr_cs', 0, 0),
(530, 'sr_cyrl', 0, 0),
(531, 'sr_cyrl_ba', 0, 0),
(532, 'sr_cyrl_cs', 0, 0),
(533, 'sr_cyrl_me', 0, 0),
(534, 'sr_cyrl_rs', 0, 0),
(535, 'sr_cyrl_yu', 0, 0),
(536, 'sr_latn', 0, 0),
(537, 'sr_latn_ba', 0, 0),
(538, 'sr_latn_cs', 0, 0),
(539, 'sr_latn_me', 0, 0),
(540, 'sr_latn_rs', 0, 0),
(541, 'sr_latn_yu', 0, 0),
(542, 'sr_me', 0, 0),
(543, 'sr_rs', 0, 0),
(544, 'sr_yu', 0, 0),
(545, 'ss', 0, 0),
(546, 'ss_sz', 0, 0),
(547, 'ss_za', 0, 0),
(548, 'ssy', 0, 0),
(549, 'ssy_er', 0, 0),
(550, 'st', 0, 0),
(551, 'st_ls', 0, 0),
(552, 'st_za', 0, 0),
(553, 'sv', 0, 0),
(554, 'sv_fi', 0, 0),
(555, 'sv_se', 0, 0),
(556, 'sw', 0, 0),
(557, 'sw_ke', 0, 0),
(558, 'sw_tz', 0, 0),
(559, 'swc', 0, 0),
(560, 'swc_cd', 0, 0),
(561, 'syr', 0, 0),
(562, 'syr_sy', 0, 0),
(563, 'ta', 0, 0),
(564, 'ta_in', 0, 0),
(565, 'ta_lk', 0, 0),
(566, 'te', 0, 0),
(567, 'te_in', 0, 0),
(568, 'teo', 0, 0),
(569, 'teo_ke', 0, 0),
(570, 'teo_ug', 0, 0),
(571, 'tg', 0, 0),
(572, 'tg_cyrl', 0, 0),
(573, 'tg_cyrl_tj', 0, 0),
(574, 'tg_tj', 0, 0),
(575, 'th', 0, 0),
(576, 'th_th', 0, 0),
(577, 'ti', 0, 0),
(578, 'ti_er', 0, 0),
(579, 'ti_et', 0, 0),
(580, 'tig', 0, 0),
(581, 'tig_er', 0, 0),
(582, 'tl', 0, 0),
(583, 'tl_ph', 0, 0),
(584, 'tn', 0, 0),
(585, 'tn_za', 0, 0),
(586, 'to', 0, 0),
(587, 'to_to', 0, 0),
(588, 'tr', 0, 0),
(589, 'tr_tr', 0, 0),
(590, 'trv', 0, 0),
(591, 'trv_tw', 0, 0),
(592, 'ts', 0, 0),
(593, 'ts_za', 0, 0),
(594, 'tt', 0, 0),
(595, 'tt_ru', 0, 0),
(596, 'twq', 0, 0),
(597, 'twq_ne', 0, 0),
(598, 'tzm', 0, 0),
(599, 'tzm_latn', 0, 0),
(600, 'tzm_latn_ma', 0, 0),
(601, 'tzm_ma', 0, 0),
(602, 'ug', 0, 0),
(603, 'ug_arab', 0, 0),
(604, 'ug_arab_cn', 0, 0),
(605, 'ug_cn', 0, 0),
(606, 'uk', 0, 0),
(607, 'uk_ua', 0, 0),
(608, 'ur', 0, 0),
(609, 'ur_in', 0, 0),
(610, 'ur_pk', 0, 0),
(611, 'uz', 0, 0),
(612, 'uz_af', 0, 0),
(613, 'uz_arab', 0, 0),
(614, 'uz_arab_af', 0, 0),
(615, 'uz_cyrl', 0, 0),
(616, 'uz_cyrl_uz', 0, 0),
(617, 'uz_latn', 0, 0),
(618, 'uz_latn_uz', 0, 0),
(619, 'uz_uz', 0, 0),
(620, 'vai', 0, 0),
(621, 'vai_latn', 0, 0),
(622, 'vai_latn_lr', 0, 0),
(623, 'vai_vaii', 0, 0),
(624, 'vai_vaii_lr', 0, 0),
(625, 've', 0, 0),
(626, 've_za', 0, 0),
(627, 'vi', 0, 0),
(628, 'vi_vn', 0, 0),
(629, 'vun', 0, 0),
(630, 'vun_tz', 0, 0),
(631, 'wae', 0, 0),
(632, 'wae_ch', 0, 0),
(633, 'wal', 0, 0),
(634, 'wal_et', 0, 0),
(635, 'wo', 0, 0),
(636, 'wo_latn', 0, 0),
(637, 'wo_latn_sn', 0, 0),
(638, 'wo_sn', 0, 0),
(639, 'xh', 0, 0),
(640, 'xh_za', 0, 0),
(641, 'xog', 0, 0),
(642, 'xog_ug', 0, 0),
(643, 'yav', 0, 0),
(644, 'yav_cm', 0, 0),
(645, 'yo', 0, 0),
(646, 'yo_ng', 0, 0),
(647, 'zh', 0, 0),
(648, 'zh_cn', 0, 0),
(649, 'zh_hans', 0, 0),
(650, 'zh_hans_cn', 0, 0),
(651, 'zh_hans_hk', 0, 0),
(652, 'zh_hans_mo', 0, 0),
(653, 'zh_hans_sg', 0, 0),
(654, 'zh_hant', 0, 0),
(655, 'zh_hant_hk', 0, 0),
(656, 'zh_hant_mo', 0, 0),
(657, 'zh_hant_tw', 0, 0),
(658, 'zh_hk', 0, 0),
(659, 'zh_mo', 0, 0);

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

--
-- Table structure for table `fmessage_message`
--

CREATE TABLE `fmessage_message` (
  `id` int(11) NOT NULL DEFAULT '0',
  `language` varchar(16) NOT NULL DEFAULT '',
  `translation` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fmessage_message`
--

INSERT INTO `fmessage_message` (`id`, `language`, `translation`) VALUES
(1051, 'ar', 'Profile'),
(1051, 'en', 'Profile'),
(1053, 'ar', 'Logout'),
(1053, 'en', 'Logout'),
(1188, 'ar', 'FACEBOOK_PAGE'),
(1188, 'en', 'FACEBOOK_PAGE'),
(1209, 'ar', 'TWITTER_PAGE'),
(1209, 'en', 'TWITTER_PAGE'),
(1234, 'ar', 'ابحث'),
(1234, 'en', 'Search'),
(1248, 'ar', 'home_page_title'),
(1249, 'ar', 'الإسم'),
(1251, 'ar', 'البريد الإلكتروني'),
(1253, 'ar', 'عنوان الرسالة'),
(1254, 'ar', 'الرسالة'),
(1255, 'ar', 'Verification Code'),
(1263, 'ar', '&lt;&lt; First'),
(1263, 'en', '&lt;&lt; First'),
(1264, 'ar', 'Last &gt;&gt;'),
(1264, 'en', 'Last &gt;&gt;'),
(1266, 'ar', 'View'),
(1266, 'en', 'View'),
(1267, 'ar', 'Update'),
(1267, 'en', 'Update'),
(1268, 'ar', 'Delete'),
(1268, 'en', 'Delete'),
(1269, 'ar', 'Are you sure you want to delete this item?'),
(1269, 'en', 'Are you sure you want to delete this item?'),
(1270, 'ar', 'Displaying {start}-{end} of 1 result.|Displaying {start}-{end} of {count} results.'),
(1270, 'en', 'Displaying {start}-{end} of 1 result.|Displaying {start}-{end} of {count} results.'),
(1271, 'ar', 'التالي &gt;'),
(1271, 'en', 'Next &gt;'),
(1272, 'ar', 'السابق &lt;'),
(1272, 'en', '&lt; Previous'),
(1273, 'ar', '{attribute} يجب أن لا يكون فارغ.'),
(1273, 'en', '{attribute} cannot be blank.'),
(1299, 'ar', 'Enter'),
(1299, 'en', 'Enter'),
(1307, 'ar', 'Login'),
(1397, 'en', 'Failed to set unsafe attribute "{attribute}" of "{class}".'),
(1413, 'en', 'Login Required'),
(1421, 'en', 'Please fix the following input errors:'),
(1503, 'en', 'Unable to resolve the request "{route}".'),
(1571, 'ar', 'لا يوجد نتائج.'),
(1600, 'ar', 'password'),
(1615, 'en', 'Source Message:'),
(1617, 'ar', 'ID'),
(1617, 'en', 'ID'),
(1618, 'en', 'Language'),
(1619, 'ar', 'Translation'),
(1619, 'en', 'Translation'),
(1620, 'ar', 'Welcome,'),
(1620, 'en', 'Welcome,'),
(1621, 'ar', 'Home'),
(1621, 'en', 'Home'),
(1622, 'ar', 'Options'),
(1622, 'en', 'Options'),
(1623, 'ar', 'Manage Options'),
(1623, 'en', 'Manage Options'),
(1624, 'ar', 'Create Option'),
(1624, 'en', 'Create Option'),
(1625, 'ar', 'Sliders'),
(1625, 'en', 'Sliders'),
(1626, 'ar', 'Manage Sliders'),
(1626, 'en', 'Manage Sliders'),
(1627, 'ar', 'Create Slider'),
(1627, 'en', 'Create Slider'),
(1628, 'ar', 'Categories'),
(1628, 'en', 'Categories'),
(1629, 'ar', 'Manage Categories'),
(1629, 'en', 'Manage Categories'),
(1630, 'ar', 'Create Category'),
(1630, 'en', 'Create Category'),
(1631, 'ar', 'Menus'),
(1631, 'en', 'Menus'),
(1632, 'ar', 'Manage Menus'),
(1632, 'en', 'Manage Menus'),
(1633, 'ar', 'Create Menu'),
(1633, 'en', 'Create Menu'),
(1634, 'ar', 'Albums'),
(1634, 'en', 'Albums'),
(1635, 'ar', 'Manage Albums'),
(1635, 'en', 'Manage Albums'),
(1636, 'ar', 'Create Album'),
(1636, 'en', 'Create Album'),
(1637, 'ar', 'Tabbers'),
(1637, 'en', 'Tabbers'),
(1638, 'ar', 'Manage Tabbers'),
(1638, 'en', 'Manage Tabbers'),
(1639, 'ar', 'Create Tabber'),
(1639, 'en', 'Create Tabber'),
(1640, 'ar', 'Pages'),
(1640, 'en', 'Pages'),
(1641, 'ar', 'Manage Pages'),
(1641, 'en', 'Manage Pages'),
(1642, 'ar', 'Create Page'),
(1642, 'en', 'Create Page'),
(1643, 'ar', 'Content Blocks'),
(1643, 'en', 'Content Blocks'),
(1644, 'ar', 'Manage Content Blocks'),
(1644, 'en', 'Manage Content Blocks'),
(1645, 'ar', 'Create Content Block'),
(1645, 'en', 'Create Content Block'),
(1649, 'ar', 'Newsletter'),
(1649, 'en', 'Newsletter'),
(1650, 'ar', 'Manage Newsletter'),
(1650, 'en', 'Manage Newsletter'),
(1651, 'ar', 'Create Newsletter'),
(1651, 'en', 'Create Newsletter'),
(1652, 'ar', 'Manage Newsletter Subscribers'),
(1652, 'en', 'Manage Newsletter Subscribers'),
(1653, 'ar', 'Add Newsletter Subscriber'),
(1653, 'en', 'Add Newsletter Subscriber'),
(1654, 'ar', 'Rights'),
(1654, 'en', 'Rights'),
(1655, 'ar', 'Assignments'),
(1655, 'en', 'Assignments'),
(1656, 'ar', 'Roles'),
(1656, 'en', 'Roles'),
(1657, 'ar', 'Create Role'),
(1657, 'en', 'Create Role'),
(1658, 'ar', 'Permissions'),
(1658, 'en', 'Permissions'),
(1659, 'ar', 'Tasks'),
(1659, 'en', 'Tasks'),
(1660, 'ar', 'Create Task'),
(1660, 'en', 'Create Task'),
(1661, 'ar', 'Operations'),
(1661, 'en', 'Operations'),
(1662, 'ar', 'Create Operation'),
(1662, 'en', 'Create Operation'),
(1663, 'ar', 'Generate items for controller actions'),
(1663, 'en', 'Generate items for controller actions'),
(1664, 'ar', 'Users'),
(1664, 'en', 'Users'),
(1665, 'ar', 'Manage Users'),
(1665, 'en', 'Manage Users'),
(1666, 'ar', 'Create User'),
(1666, 'en', 'Create User'),
(1667, 'ar', 'Manage Profile Fields'),
(1667, 'en', 'Manage Profile Fields'),
(1668, 'ar', 'Create Profile Field'),
(1668, 'en', 'Create Profile Field'),
(1669, 'ar', 'Manage Translation'),
(1669, 'en', 'Manage Translation'),
(1670, 'ar', 'Create Message'),
(1670, 'en', 'Create Message'),
(1671, 'ar', 'Translated Messages'),
(1671, 'en', 'Translated Messages'),
(1672, 'ar', 'New Translation Language'),
(1672, 'en', 'New Translation Language'),
(1673, 'ar', 'Site Languages'),
(1673, 'en', 'Site Languages'),
(1674, 'ar', 'Widgets'),
(1674, 'en', 'Widgets'),
(1675, 'ar', 'Manage Widgets'),
(1675, 'en', 'Manage Widgets'),
(1676, 'ar', 'Create Widget'),
(1676, 'en', 'Create Widget'),
(1677, 'ar', 'Manage Widgets Instances'),
(1677, 'en', 'Manage Widgets Instances'),
(1678, 'ar', 'Create Widget Instance'),
(1678, 'en', 'Create Widget Instance'),
(1679, 'en', 'Category'),
(1680, 'en', 'Message'),
(1681, 'en', 'Translate'),
(1682, 'en', 'Manage Translates'),
(1683, 'ar', 'Key'),
(1683, 'en', 'Key'),
(1684, 'ar', 'Value'),
(1684, 'en', 'Value'),
(1685, 'ar', 'Group'),
(1685, 'en', 'Group'),
(1686, 'ar', 'FACEBOOK_PAGE'),
(1686, 'en', 'FACEBOOK_PAGE'),
(1687, 'ar', 'GOOGLE_ANALYTICS_TRACKING_ID'),
(1687, 'en', 'GOOGLE_ANALYTICS_TRACKING_ID'),
(1688, 'ar', 'GPLUS_PAGE'),
(1689, 'ar', 'I18N_DEFAULT_LANGUAGE'),
(1689, 'en', 'I18N_DEFAULT_LANGUAGE'),
(1690, 'ar', 'I18N_MULTILINGUAL'),
(1690, 'en', 'I18N_MULTILINGUAL'),
(1691, 'ar', 'I18N_TIMEZONE'),
(1691, 'en', 'I18N_TIMEZONE'),
(1692, 'ar', 'INFO_EMAIL'),
(1692, 'en', 'INFO_EMAIL'),
(1693, 'ar', 'SITE_TITLE'),
(1693, 'en', 'SITE_TITLE'),
(1694, 'ar', 'SMTP-FROM-EMAIL'),
(1694, 'en', 'SMTP-FROM-EMAIL'),
(1695, 'ar', 'SMTP-FROM-NAME'),
(1695, 'en', 'SMTP-FROM-NAME'),
(1696, 'ar', 'SMTP-HOST'),
(1696, 'en', 'SMTP-HOST'),
(1697, 'ar', 'SMTP-PASSWORD'),
(1697, 'en', 'SMTP-PASSWORD'),
(1698, 'ar', 'SMTP-PORT'),
(1698, 'en', 'SMTP-PORT'),
(1699, 'ar', 'SMTP-SECURE'),
(1699, 'en', 'SMTP-SECURE'),
(1700, 'ar', 'SMTP-USERNAME'),
(1700, 'en', 'SMTP-USERNAME'),
(1701, 'ar', 'TWITTER_PAGE'),
(1701, 'en', 'TWITTER_PAGE'),
(1703, 'ar', 'Email'),
(1703, 'en', 'Email'),
(1704, 'en', 'NO'),
(1705, 'en', 'YES'),
(1706, 'en', 'Title'),
(1707, 'en', 'Slug'),
(1709, 'ar', 'Create Datetime'),
(1709, 'en', 'Create Datetime'),
(1710, 'en', 'Update Datetime'),
(1711, 'en', 'Active Css Class'),
(1712, 'en', 'Encode Label'),
(1713, 'en', 'First Item Css Class'),
(1714, 'en', 'Last Item Css Class'),
(1715, 'en', 'Hide Empty Items'),
(1716, 'en', 'Item Css Class'),
(1717, 'en', 'Item Template'),
(1718, 'en', 'Link Label Wrapper'),
(1719, 'en', 'Add Items to Menu'),
(1720, 'en', 'Manage Menu Items'),
(1721, 'ar', 'You are not authorized to perform this action.'),
(1721, 'en', 'You are not authorized to perform this action.'),
(1722, 'ar', 'Login'),
(1723, 'ar', 'Remember me'),
(1724, 'ar', 'username or email'),
(1726, 'en', 'Manage'),
(1727, 'en', 'Parent'),
(1728, 'en', 'Search'),
(1730, 'en', 'Create'),
(1731, 'en', 'Reset'),
(1732, 'en', 'Advanced Settings'),
(1733, 'en', 'Conver Image'),
(1734, 'en', 'Images Count'),
(1735, 'en', 'Menu: {menutitle}'),
(1736, 'en', 'Create Menu Item'),
(1737, 'en', 'Add To Menu:'),
(1738, 'en', 'Link Title'),
(1739, 'en', 'Link'),
(1740, 'en', 'Link Target'),
(1741, 'en', 'Order'),
(1742, 'en', 'Visible'),
(1743, 'en', 'Menu'),
(1744, 'en', 'Parent Link'),
(1745, 'en', 'Select'),
(1746, 'en', 'Select Link Source:'),
(1747, 'en', 'Select Category'),
(1748, 'en', 'Select Page'),
(1749, 'en', 'Dynamic Page'),
(1750, 'en', 'Static Page'),
(1751, 'en', 'Preview:'),
(1754, 'en', 'Select Widget'),
(1755, 'en', 'Insert Widget'),
(1777, 'ar', 'Manage Comments'),
(1777, 'en', 'Manage Comments'),
(1785, 'en', 'Status'),
(1789, 'en', 'Content'),
(1791, 'en', 'Item has been successfully created.'),
(1792, 'en', 'Upload Images'),
(1793, 'en', 'Manage Images'),
(1794, 'en', 'Album'),
(1795, 'en', 'Remove'),
(1796, 'en', 'Manage Album Images'),
(1809, 'en', 'Update Menu Item'),
(1810, 'en', 'MenuItem has been successfully updated.'),
(1811, 'en', 'Item has been successfully updated.'),
(1812, 'en', 'Description'),
(1813, 'en', 'Class'),
(1814, 'en', 'Short Code'),
(1815, 'en', 'Widget'),
(1816, 'en', 'Loading Widget Options...'),
(1817, 'en', 'Widget Options'),
(1820, 'en', 'Save'),
(1831, 'en', 'Draft'),
(1832, 'en', 'Published'),
(1833, 'en', 'Select'),
(1835, 'ar', 'أصوات'),
(1841, 'ar', 'Polls'),
(1841, 'en', 'Polls'),
(1842, 'ar', 'Manage Polls'),
(1842, 'en', 'Manage Polls'),
(1843, 'ar', 'Create Poll'),
(1843, 'en', 'Create Poll'),
(1844, 'ar', 'Comments'),
(1844, 'en', 'Comments'),
(1847, 'ar', 'صوت'),
(1847, 'en', 'Vote'),
(1848, 'ar', 'إرسال'),
(1849, 'ar', 'نتائج البحث عن:'),
(1855, 'en', 'Update Menu'),
(1856, 'en', 'Menu has been successfully updated.'),
(1867, 'ar', 'Manage Google Maps'),
(1867, 'en', 'Manage Google Maps'),
(1900, 'en', 'DEFAULT'),
(1948, 'ar', 'Articles'),
(1948, 'en', 'Articles'),
(1949, 'ar', 'Manage Articles'),
(1949, 'en', 'Manage Articles'),
(1950, 'ar', 'Create Article'),
(1950, 'en', 'Create Article'),
(1959, 'ar', 'Create Google Map'),
(1959, 'en', 'Create Google Map'),
(1963, 'ar', 'Do you have any previous experience in volunteering field?'),
(1963, 'en', 'Do you have any previous experience in volunteering field?'),
(1964, 'ar', 'If Yes, can you tell us more?'),
(1964, 'en', 'If Yes, can you tell us more?'),
(1965, 'ar', 'Phone Number'),
(1965, 'en', 'Phone Number'),
(1966, 'ar', 'Complete Subscription'),
(1966, 'en', 'Complete Subscription'),
(1967, 'ar', 'Full Name'),
(1967, 'en', 'Full Name'),
(1970, 'ar', 'Google Maps'),
(1970, 'en', 'Google Maps'),
(1980, 'en', 'Delete'),
(1981, 'en', 'Approve'),
(1982, 'en', 'Draft'),
(1983, 'en', 'Are you sure you want to perform this action?'),
(1993, 'en', 'No results match'),
(1995, 'en', 'Please select at least one item to delete.'),
(1997, 'ar', 'SEO_AUTHOR'),
(1997, 'en', 'SEO_AUTHOR'),
(1999, 'ar', 'SEO_DESCRIPTION'),
(1999, 'en', 'SEO_DESCRIPTION'),
(2000, 'ar', 'SEO_KEYWORDS'),
(2000, 'en', 'SEO_KEYWORDS'),
(2006, 'en', 'Article'),
(2007, 'en', 'Type Article Title'),
(2045, 'en', 'MenuItem has been successfully created.'),
(2046, 'ar', 'SHOW_AUTHOR'),
(2046, 'en', 'SHOW_AUTHOR'),
(2047, 'en', 'Set Default Language'),
(2048, 'en', 'Language Name'),
(2049, 'en', 'Language Code'),
(2050, 'en', 'Locale'),
(2051, 'en', 'Active'),
(2052, 'en', 'Select Locale:'),
(2053, 'en', 'Menu has been successfully created.'),
(2054, 'en', 'Converting ideas into reality'),
(2055, 'ar', 'الكتب'),
(2056, 'ar', 'المجلات'),
(2057, 'ar', 'الكتيبات التعريفية'),
(2058, 'ar', 'المطبوعات التسويقية'),
(2059, 'ar', 'المفكرات المكتبية'),
(2060, 'ar', 'الحقائب الجلدية'),
(2061, 'ar', 'الحقائب الجلدية'),
(2062, 'ar', 'القرطاسية<br/>الجلدية\n'),
(2063, 'ar', 'بطاقات الدعوة'),
(2064, 'ar', 'المواد الإعلانية'),
(2065, 'ar', 'عبوات المنتجات'),
(2066, 'ar', 'القرطاسية'),
(2067, 'ar', 'أخبار التيار'),
(2067, 'en', 'Al-CAI News'),
(2068, 'ar', 'آخر البيانات'),
(2068, 'en', 'Latest Statments'),
(2069, 'ar', 'كُن على اطلاع'),
(2069, 'en', 'Be Informed'),
(2070, 'ar', 'انضم لقائمتنا البريدية'),
(2070, 'en', 'Subscribe to our mailing list'),
(2071, 'ar', 'مقالات'),
(2071, 'en', 'Articles'),
(2072, 'ar', 'جميع الحقوق محفوظة | تيار بناء الدولة السورية'),
(2072, 'en', 'All rights reserverd | CAI'),
(2073, 'ar', 'عن التيار'),
(2073, 'en', 'About The CAI'),
(2074, 'ar', 'الأصدقاء'),
(2074, 'en', 'Al CAI Friends'),
(2075, 'ar', 'مؤسسات التيار'),
(2075, 'en', 'Al CAI Institutions'),
(2076, 'ar', 'التصويت'),
(2076, 'en', 'Voting'),
(2077, 'ar', 'صوت'),
(2078, 'ar', 'Media'),
(2078, 'en', 'Media'),
(2079, 'en', 'Questionnaires'),
(2080, 'en', 'Manage Questionnaires'),
(2081, 'en', 'Create Questionnaire'),
(2082, 'en', 'LINKEDIN_PAGE'),
(2083, 'ar', 'YOUTUBE_PAGE'),
(2083, 'en', 'YOUTUBE_PAGE'),
(2084, 'ar', 'LINKEDIN_PAGE'),
(2084, 'en', 'LINKEDIN_PAGE'),
(2085, 'ar', 'الإستبيانات'),
(2086, 'ar', 'شركة لمحة لخدمات الشحن تشكركم على رغبتكم بالحصول على خدماتها و سيعمل فريقنا على الرد على طلبكم خلال مدة 24 ساعة كحد أقصى'),
(2086, 'en', 'Blink company for shipping services thanks you for interested in their services and our team will respond to your request within a period of 24 hours max'),
(2087, 'ar', 'يرجى إعادة تصحيح الأخطاء ثم المحاولة من جديد'),
(2087, 'en', 'Please fix your errors and try again.'),
(2088, 'ar', 'الجوال');

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

--
-- Table structure for table `fmessage_sourcemessage`
--

CREATE TABLE `fmessage_sourcemessage` (
  `id` int(11) NOT NULL,
  `category` varchar(45) NOT NULL,
  `message` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fmessage_sourcemessage`
--

INSERT INTO `fmessage_sourcemessage` (`id`, `category`, `message`) VALUES
(1051, 'UserModule', 'Profile'),
(1053, 'UserModule', 'Logout'),
(1117, 'site', 'Powered By:'),
(1134, 'widget', 'Slider ID'),
(1141, 'widget', 'News Order'),
(1142, 'widget', 'Number Of Items to Display'),
(1143, 'widget', 'Missing Input Element Label'),
(1144, 'widget', 'Specify sets like: \'fold,fade,sliceDown\''),
(1145, 'widget', 'For slice animations'),
(1146, 'widget', 'For box animations'),
(1147, 'widget', 'Slide transition speed'),
(1148, 'widget', 'How long each slide will show'),
(1149, 'widget', 'Set starting Slide (0 index)'),
(1150, 'widget', 'Next & Prev navigation'),
(1151, 'widget', '1,2,3... navigation'),
(1152, 'widget', 'Use thumbnails for Control Nav'),
(1153, 'widget', 'Stop animation while hovering'),
(1154, 'widget', 'Force manual transitions'),
(1155, 'widget', 'Prev directionNav text'),
(1156, 'widget', 'Next directionNav text'),
(1157, 'widget', 'Start on a random slide'),
(1158, 'widget', 'Triggers before a slide transition'),
(1159, 'widget', 'Triggers after a slide transition'),
(1160, 'widget', 'Triggers after all slides have been shown'),
(1161, 'widget', 'Triggers when last slide is shown'),
(1162, 'widget', 'Triggers when slider has loaded'),
(1180, 'widget', 'Widget Layout File'),
(1181, 'widget', 'Tabber ID'),
(1182, 'widget', 'Tabber Direction'),
(1187, 'site', 'INSTAGRAM_PAGE'),
(1188, 'site', 'FACEBOOK_PAGE'),
(1208, 'site', 'GPLUS_PAGE'),
(1209, 'site', 'TWITTER_PAGE'),
(1234, 'site', 'Search'),
(1242, 'site', 'Continue Reading'),
(1243, 'site', 'News'),
(1248, 'site', 'home_page_title'),
(1249, 'site', 'Name'),
(1250, 'site', 'Company'),
(1251, 'site', 'E-mail'),
(1252, 'site', 'Phone'),
(1253, 'site', 'Subject'),
(1254, 'site', 'Message'),
(1255, 'site', 'Verification Code'),
(1256, 'site', 'Put your email and you will receive all news'),
(1257, 'site', 'THANK YOU FOR SHARING YOUR EMAIL. STAY TUNED FOR OUR NEWS!'),
(1259, 'site', 'Subscribe'),
(1261, 'site', 'Subscribe to the mailing list to receive CAI news'),
(1262, 'site', 'Your email here'),
(1263, 'yii', '&lt;&lt; First'),
(1264, 'yii', 'Last &gt;&gt;'),
(1265, 'yii', '{attribute} "{value}" has already been taken.'),
(1266, 'zii', 'View'),
(1267, 'zii', 'Update'),
(1268, 'zii', 'Delete'),
(1269, 'zii', 'Are you sure you want to delete this item?'),
(1270, 'zii', 'Displaying {start}-{end} of 1 result.|Displaying {start}-{end} of {count} results.'),
(1271, 'yii', 'Next &gt;'),
(1272, 'yii', '&lt; Previous'),
(1273, 'yii', '{attribute} cannot be blank.'),
(1274, 'yii', 'The system is unable to find the requested action "{action}".'),
(1299, 'editable', 'Enter'),
(1300, 'editable', 'Error while saving record!'),
(1301, 'editable', 'Model {class} not found by primary key "{pk}"'),
(1302, 'editable', 'Model {class} rules do not allow to update attribute "{attr}"'),
(1303, 'editable', 'Property "attribute" should be defined.'),
(1304, 'editable', 'Property "primaryKey" should be defined.'),
(1305, 'editable', 'You should provide modelClass in constructor of EditableSaver.'),
(1306, 'editable', 'x clear'),
(1307, 'site', 'Login'),
(1308, 'site', 'Search Results'),
(1309, 'site', 'Site Map'),
(1310, 'site', '____________Sender Info____________<br/>\nName: {name}<br/>\nCompany: {company}<br/>\nE-mail: {email}<br/>\nPhone: {phone}<br/>\n____________Message:____________<br/><br/>\n'),
(1313, 'yii', '"{path}" is not a valid directory.'),
(1314, 'yii', 'A PHP extension stopped the file upload.'),
(1315, 'yii', 'Action class {class} must implement the "run" method.'),
(1316, 'yii', 'Active Record requires a "db" CDbConnection application component.'),
(1317, 'yii', 'Active record "{class}" has an invalid configuration for relation "{relation}". It must specify the relation type, the related active record class and the foreign key.'),
(1318, 'yii', 'Active record "{class}" is trying to select an invalid column "{column}". Note, the column must exist in the table or be an expression with alias.'),
(1319, 'yii', 'Adding a foreign key constraint to an existing table is not supported by SQLite.'),
(1320, 'yii', 'Adding a primary key after table has been created is not supported by SQLite.'),
(1321, 'yii', 'Alias "{alias}" is invalid. Make sure it points to an existing PHP file and the file is readable.'),
(1322, 'yii', 'Alias "{alias}" is invalid. Make sure it points to an existing directory or file.'),
(1323, 'yii', 'Altering a DB column is not supported by SQLite.'),
(1324, 'yii', 'Application Log'),
(1325, 'yii', 'Application base path "{path}" is not a valid directory.'),
(1326, 'yii', 'Application runtime path "{path}" is not valid. Please make sure it is a directory writable by the Web server process.'),
(1327, 'yii', 'Authorization item "{item}" has already been assigned to user "{user}".'),
(1328, 'yii', 'Base path "{path}" is not a valid directory.'),
(1329, 'yii', 'CApcCache requires PHP apc extension to be loaded.'),
(1330, 'yii', 'CAssetManager.basePath "{path}" is invalid. Please make sure the directory exists and is writable by the Web server process.'),
(1331, 'yii', 'CCacheHttpSession.cacheID is invalid. Please make sure "{id}" refers to a valid cache application component.'),
(1332, 'yii', 'CCaptchaValidator.action "{id}" is invalid. Unable to find such an action in the current controller.'),
(1333, 'yii', 'CDbAuthManager.connectionID "{id}" is invalid. Please make sure it refers to the ID of a CDbConnection application component.'),
(1334, 'yii', 'CDbCache.connectionID "{id}" is invalid. Please make sure it refers to the ID of a CDbConnection application component.'),
(1335, 'yii', 'CDbCacheDependency.connectionID "{id}" is invalid. Please make sure it refers to the ID of a CDbConnection application component.'),
(1336, 'yii', 'CDbCacheDependency.sql cannot be empty.'),
(1337, 'yii', 'CDbCommand failed to execute the SQL statement: {error}'),
(1338, 'yii', 'CDbCommand failed to prepare the SQL statement: {error}'),
(1339, 'yii', 'CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.'),
(1340, 'yii', 'CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.'),
(1341, 'yii', 'CDbConnection does not support reading schema for {driver} database.'),
(1342, 'yii', 'CDbConnection failed to open the DB connection.'),
(1343, 'yii', 'CDbConnection is unable to find PDO class "{className}". Make sure PDO is installed correctly.'),
(1344, 'yii', 'CDbDataReader cannot rewind. It is a forward-only reader.'),
(1345, 'yii', 'CDbHttpSession.connectionID "{id}" is invalid. Please make sure it refers to the ID of a CDbConnection application component.'),
(1346, 'yii', 'CDbLogRoute.connectionID "{id}" does not point to a valid CDbConnection application component.'),
(1347, 'yii', 'CDbMessageSource.connectionID is invalid. Please make sure "{id}" refers to a valid database application component.'),
(1348, 'yii', 'CDbTestFixture.connectionID "{id}" is invalid. Please make sure it refers to the ID of a CDbConnection application component.'),
(1349, 'yii', 'CDbTransaction is inactive and cannot perform commit or roll back operations.'),
(1350, 'yii', 'CDirectoryCacheDependency.directory cannot be empty.'),
(1351, 'yii', 'CEAcceleratorCache requires PHP eAccelerator extension to be loaded, enabled or compiled with the "--with-eaccelerator-shared-memory" option.'),
(1352, 'yii', 'CFileCacheDependency.fileName cannot be empty.'),
(1353, 'yii', 'CFileLogRoute.logPath "{path}" does not point to a valid directory. Make sure the directory exists and is writable by the Web server process.'),
(1354, 'yii', 'CFilterChain can only take objects implementing the IFilter interface.'),
(1355, 'yii', 'CFlexWidget.baseUrl cannot be empty.'),
(1356, 'yii', 'CFlexWidget.name cannot be empty.'),
(1357, 'yii', 'CGlobalStateCacheDependency.stateName cannot be empty.'),
(1358, 'yii', 'CHttpCacheFilter.lastModified contained a value that could not be understood by strtotime()'),
(1359, 'yii', 'CHttpCookieCollection can only hold CHttpCookie objects.'),
(1360, 'yii', 'CHttpRequest is unable to determine the entry script URL.'),
(1361, 'yii', 'CHttpRequest is unable to determine the path info of the request.'),
(1362, 'yii', 'CHttpRequest is unable to determine the request URI.'),
(1363, 'yii', 'CHttpSession.cookieMode can only be "none", "allow" or "only".'),
(1364, 'yii', 'CHttpSession.gcProbability "{value}" is invalid. It must be a float between 0 and 100.'),
(1365, 'yii', 'CHttpSession.savePath "{path}" is not a valid directory.'),
(1366, 'yii', 'CMemCache requires PHP {extension} extension to be loaded.'),
(1367, 'yii', 'CMemCache server configuration must be an array.'),
(1368, 'yii', 'CMemCache server configuration must have "host" value.'),
(1369, 'yii', 'CProfileLogRoute found a mismatching code block "{token}". Make sure the calls to Yii::beginProfile() and Yii::endProfile() be properly nested.'),
(1370, 'yii', 'CProfileLogRoute.report "{report}" is invalid. Valid values include "summary" and "callstack".'),
(1371, 'yii', 'CSecurityManager requires PHP mcrypt extension to be loaded in order to use data encryption feature.'),
(1372, 'yii', 'CSecurityManager.encryptionKey cannot be empty.'),
(1373, 'yii', 'CSecurityManager.validationKey cannot be empty.'),
(1374, 'yii', 'CSecurityManager::generateRandomString() cannot generate random string in the current environment.'),
(1375, 'yii', 'CTypedList<{type}> can only hold objects of {type} class.'),
(1376, 'yii', 'CTypedMap<{type}> can only hold objects of {type} class.'),
(1377, 'yii', 'CUrlManager.UrlFormat must be either "path" or "get".'),
(1378, 'yii', 'CWinCache requires PHP wincache extension to be loaded.'),
(1379, 'yii', 'CWinCache user cache is disabled. Please set wincache.ucenabled to On in your php.ini.'),
(1380, 'yii', 'CXCache requires PHP XCache extension to be loaded.'),
(1381, 'yii', 'CZendDataCache requires PHP Zend Data Cache extension to be loaded.'),
(1382, 'yii', 'Cannot add "{child}" as a child of "{name}". A loop has been detected.'),
(1383, 'yii', 'Cannot add "{child}" as a child of "{parent}". A loop has been detected.'),
(1384, 'yii', 'Cannot add "{name}" as a child of itself.'),
(1385, 'yii', 'Cannot add an item of type "{child}" to an item of type "{parent}".'),
(1386, 'yii', 'Class name "{class}" does not match class file "{file}".'),
(1387, 'yii', 'Column name must be either a string or an array.'),
(1388, 'yii', 'Dropping DB column is not supported by SQLite.'),
(1389, 'yii', 'Dropping a foreign key constraint is not supported by SQLite.'),
(1390, 'yii', 'Either "{parent}" or "{child}" does not exist.'),
(1391, 'yii', 'Error: Table "{table}" does not have a primary key.'),
(1392, 'yii', 'Error: Table "{table}" has a composite primary key which is not supported by crud command.'),
(1393, 'yii', 'Event "{class}.{event}" is attached with an invalid handler "{handler}".'),
(1394, 'yii', 'Event "{class}.{event}" is not defined.'),
(1395, 'yii', 'Extension path "{path}" does not exist.'),
(1396, 'yii', 'Failed to initialize the mcrypt module.'),
(1397, 'yii', 'Failed to set unsafe attribute "{attribute}" of "{class}".'),
(1398, 'yii', 'Failed to start session.'),
(1399, 'yii', 'Failed to write the uploaded file "{file}" to disk.'),
(1400, 'yii', 'Filter "{filter}" is invalid. Controller "{class}" does not have the filter method "filter{filter}".'),
(1401, 'yii', 'GD with FreeType or ImageMagick PHP extensions are required.'),
(1402, 'yii', 'Get a new code'),
(1403, 'yii', 'Go to page: '),
(1404, 'yii', 'In order to use MIME-type validation provided by CFileValidator fileinfo PECL extension should be installed.'),
(1405, 'yii', 'Internal error while generating hash.'),
(1406, 'yii', 'Invalid MO file revision: {revision}.'),
(1407, 'yii', 'Invalid MO file: {file} (magic: {magic}).'),
(1408, 'yii', 'Invalid enumerable value "{value}". Please make sure it is among ({enum}).'),
(1409, 'yii', 'Invalid expression for CHttpCacheFilter.lastModifiedExpression: The evaluation result "{value}" could not be understood by strtotime()'),
(1410, 'yii', 'Invalid operator "{operator}".'),
(1411, 'yii', 'List data must be an array or an object implementing Traversable.'),
(1412, 'yii', 'List index "{index}" is out of bound.'),
(1413, 'yii', 'Login Required'),
(1414, 'yii', 'Map data must be an array or an object implementing Traversable.'),
(1415, 'yii', 'Missing the temporary folder to store the uploaded file "{file}".'),
(1416, 'yii', 'No'),
(1417, 'yii', 'No columns are being updated for table "{table}".'),
(1418, 'yii', 'No counter columns are being updated for table "{table}".'),
(1419, 'yii', 'Object configuration must be an array containing a "class" element.'),
(1420, 'yii', 'Only SHA1 and MD5 hashing algorithms are supported when using PHP 5.1.1 or below.'),
(1421, 'yii', 'Please fix the following input errors:'),
(1422, 'yii', 'Powered by {yii}.'),
(1423, 'yii', 'Property "{class}.{property}" is not defined.'),
(1424, 'yii', 'Property "{class}.{property}" is read only.'),
(1425, 'yii', 'Property CMaskedTextField.mask cannot be empty.'),
(1426, 'yii', 'Queue data must be an array or an object implementing Traversable.'),
(1427, 'yii', 'Relation "{name}" is not defined in active record class "{class}".'),
(1428, 'yii', 'Removing a primary key after table has been created is not supported by SQLite.'),
(1429, 'yii', 'Renaming a DB column is not supported by SQLite.'),
(1430, 'yii', 'Script HTML options are not allowed for "CClientScript::POS_LOAD" and "CClientScript::POS_READY".'),
(1431, 'yii', 'Stack data must be an array or an object implementing Traversable.'),
(1432, 'yii', 'Table "{table}" does not exist.'),
(1433, 'yii', 'Table "{table}" does not have a column named "{column}".'),
(1434, 'yii', 'The "db" application component must be configured to be a CDbConnection object.'),
(1435, 'yii', 'The "filter" property must be specified with a valid callback.'),
(1436, 'yii', 'The "forceCopy" and "linkAssets" cannot be both true.'),
(1437, 'yii', 'The "pattern" property must be specified with a valid regular expression.'),
(1438, 'yii', 'The "range" property must be specified with a list of values.'),
(1439, 'yii', 'The $converter argument must be a valid callback or null.'),
(1440, 'yii', 'The CSRF token could not be verified.'),
(1441, 'yii', 'The STAT relation "{name}" cannot have child relations.'),
(1442, 'yii', 'The URL pattern "{pattern}" for route "{route}" is not a valid regular expression.'),
(1443, 'yii', 'The active record cannot be deleted because it is new.'),
(1444, 'yii', 'The active record cannot be inserted to database because it is not new.'),
(1445, 'yii', 'The active record cannot be updated because it is new.'),
(1446, 'yii', 'The asset "{asset}" to be published does not exist.'),
(1447, 'yii', 'The command path "{path}" is not a valid directory.'),
(1448, 'yii', 'The controller path "{path}" is not a valid directory.'),
(1449, 'yii', 'The file "{file}" cannot be uploaded. Only files of these MIME-types are allowed: {mimeTypes}.'),
(1450, 'yii', 'The file "{file}" cannot be uploaded. Only files with these extensions are allowed: {extensions}.'),
(1451, 'yii', 'The file "{file}" is too large. Its size cannot exceed {limit} bytes.'),
(1452, 'yii', 'The file "{file}" is too small. Its size cannot be smaller than {limit} bytes.'),
(1453, 'yii', 'The file "{file}" was only partially uploaded.'),
(1454, 'yii', 'The first element in a filter configuration must be the filter class.'),
(1455, 'yii', 'The format of {attribute} is invalid.'),
(1456, 'yii', 'The item "{name}" does not exist.'),
(1457, 'yii', 'The item "{parent}" already has a child "{child}".'),
(1458, 'yii', 'The layout path "{path}" is not a valid directory.'),
(1459, 'yii', 'The list is read only.'),
(1460, 'yii', 'The map is read only.'),
(1461, 'yii', 'The module path "{path}" is not a valid directory.'),
(1462, 'yii', 'The pattern for 12 hour format must be "h" or "hh".'),
(1463, 'yii', 'The pattern for 24 hour format must be "H" or "HH".'),
(1464, 'yii', 'The pattern for AM/PM marker must be "a".'),
(1465, 'yii', 'The pattern for day in month must be "F".'),
(1466, 'yii', 'The pattern for day in year must be "D", "DD" or "DDD".'),
(1467, 'yii', 'The pattern for day of the month must be "d" or "dd".'),
(1468, 'yii', 'The pattern for day of the week must be "E", "EE", "EEE", "EEEE", "EEEEE", "e", "ee", "eee", "eeee", "eeeee", "c", "cccc" or "ccccc".'),
(1469, 'yii', 'The pattern for era must be "G", "GG", "GGG", "GGGG" or "GGGGG".'),
(1470, 'yii', 'The pattern for hour in AM/PM must be "K" or "KK".'),
(1471, 'yii', 'The pattern for hour in day must be "k" or "kk".'),
(1472, 'yii', 'The pattern for minutes must be "m" or "mm".'),
(1473, 'yii', 'The pattern for month must be "M", "MM", "MMM", "MMMM", "L", "LL", "LLL" or "LLLL".'),
(1474, 'yii', 'The pattern for seconds must be "s" or "ss".'),
(1475, 'yii', 'The pattern for time zone must be "z" or "v".'),
(1476, 'yii', 'The pattern for week in month must be "W".'),
(1477, 'yii', 'The pattern for week in year must be "w".'),
(1478, 'yii', 'The queue is empty.'),
(1479, 'yii', 'The relation "{relation}" in active record class "{class}" is not specified correctly: the join table "{joinTable}" given in the foreign key cannot be found in the database.'),
(1480, 'yii', 'The relation "{relation}" in active record class "{class}" is specified with a foreign key "{key}" that does not point to the parent table "{table}".'),
(1481, 'yii', 'The relation "{relation}" in active record class "{class}" is specified with an incomplete foreign key. The foreign key must consist of columns referencing both joining tables.'),
(1482, 'yii', 'The relation "{relation}" in active record class "{class}" is specified with an invalid foreign key "{key}". There is no such column in the table "{table}".'),
(1483, 'yii', 'The relation "{relation}" in active record class "{class}" is specified with an invalid foreign key. The columns in the key must match the primary keys of the table "{table}".'),
(1484, 'yii', 'The relation "{relation}" in active record class "{class}" is specified with an invalid foreign key. The format of the foreign key must be "joinTable(fk1,fk2,...)".'),
(1485, 'yii', 'The requested view "{name}" was not found.'),
(1486, 'yii', 'The stack is empty.'),
(1487, 'yii', 'The system view path "{path}" is not a valid directory.'),
(1488, 'yii', 'The table "{table}" for active record class "{class}" cannot be found in the database.'),
(1489, 'yii', 'The value for the column "{column}" is not supplied when querying the table "{table}".'),
(1490, 'yii', 'The verification code is incorrect.'),
(1491, 'yii', 'The view path "{path}" is not a valid directory.'),
(1492, 'yii', 'Theme directory "{directory}" does not exist.'),
(1493, 'yii', 'This content requires the <a href="http://www.adobe.com/go/getflash/">Adobe Flash Player</a>.'),
(1494, 'yii', 'Unable to add an item whose name is the same as an existing item.'),
(1495, 'yii', 'Unable to change the item name. The name "{name}" is already used by another item.'),
(1496, 'yii', 'Unable to create application state file "{file}". Make sure the directory containing the file exists and is writable by the Web server process.'),
(1497, 'yii', 'Unable to find "{column}" in table "{table}".'),
(1498, 'yii', 'Unable to generate random string.'),
(1499, 'yii', 'Unable to lock file "{file}" for reading.'),
(1500, 'yii', 'Unable to lock file "{file}" for writing.'),
(1501, 'yii', 'Unable to read file "{file}".'),
(1502, 'yii', 'Unable to replay the action "{object}.{method}". The method does not exist.'),
(1503, 'yii', 'Unable to resolve the request "{route}".'),
(1504, 'yii', 'Unable to upload the file "{file}" because of an unrecognized error.'),
(1505, 'yii', 'Unable to write file "{file}".'),
(1506, 'yii', 'Unknown authorization item "{name}".'),
(1507, 'yii', 'Unknown operator "{operator}".'),
(1508, 'yii', 'Unknown type "{type}".'),
(1509, 'yii', 'Unrecognized locale "{locale}".'),
(1510, 'yii', 'View file "{file}" does not exist.'),
(1511, 'yii', 'Yes'),
(1512, 'yii', 'Yii application can only be created once.'),
(1513, 'yii', 'You are not authorized to perform this action.'),
(1514, 'yii', 'Your request is invalid.'),
(1515, 'yii', '{attribute} "{value}" is invalid.'),
(1516, 'yii', '{attribute} cannot accept more than {limit} files.'),
(1517, 'yii', '{attribute} is in the list.'),
(1518, 'yii', '{attribute} is invalid.'),
(1519, 'yii', '{attribute} is not a valid URL.'),
(1520, 'yii', '{attribute} is not a valid email address.'),
(1521, 'yii', '{attribute} is not in the list.'),
(1522, 'yii', '{attribute} is of the wrong length (should be {length} characters).'),
(1523, 'yii', '{attribute} is too big (maximum is {max}).'),
(1524, 'yii', '{attribute} is too long (maximum is {max} characters).'),
(1525, 'yii', '{attribute} is too short (minimum is {min} characters).'),
(1526, 'yii', '{attribute} is too small (minimum is {min}).'),
(1527, 'yii', '{attribute} must be a number.'),
(1528, 'yii', '{attribute} must be an integer.'),
(1529, 'yii', '{attribute} must be either {true} or {false}.'),
(1530, 'yii', '{attribute} must be greater than "{compareValue}".'),
(1531, 'yii', '{attribute} must be greater than or equal to "{compareValue}".'),
(1532, 'yii', '{attribute} must be less than "{compareValue}".'),
(1533, 'yii', '{attribute} must be less than or equal to "{compareValue}".'),
(1534, 'yii', '{attribute} must be repeated exactly.'),
(1535, 'yii', '{attribute} must be {type}.'),
(1536, 'yii', '{attribute} must be {value}.'),
(1537, 'yii', '{attribute} must not be equal to "{compareValue}".'),
(1538, 'yii', '{className} does not support add() functionality.'),
(1539, 'yii', '{className} does not support delete() functionality.'),
(1540, 'yii', '{className} does not support flushValues() functionality.'),
(1541, 'yii', '{className} does not support get() functionality.'),
(1542, 'yii', '{className} does not support set() functionality.'),
(1543, 'yii', '{class} and its behaviors do not have a method or closure named "{name}".'),
(1544, 'yii', '{class} does not have attribute "{attribute}".'),
(1545, 'yii', '{class} does not have relation "{name}".'),
(1546, 'yii', '{class} does not support fetching all table names.'),
(1547, 'yii', '{class} has an invalid validation rule. The rule must specify attributes to be validated and the validator name.'),
(1548, 'yii', '{class} must specify "model" and "attribute" or "name" property values.'),
(1549, 'yii', '{class} requires the Blowfish option of the PHP crypt() function. This system does not have it.'),
(1550, 'yii', '{class} requires the PHP crypt() function. This system does not have it.'),
(1551, 'yii', '{class}.allowAutoLogin must be set true in order to use cookie-based authentication.'),
(1552, 'yii', '{class}::$cost must be a number.'),
(1553, 'yii', '{class}::$cost must be between 4 and 31.'),
(1554, 'yii', '{class}::authenticate() must be implemented.'),
(1555, 'yii', '{controller} cannot find the requested view "{view}".'),
(1556, 'yii', '{controller} contains improperly nested widget tags in its view "{view}". A {widget} widget does not have an endWidget() call.'),
(1557, 'yii', '{controller} has an extra endWidget({id}) call in its view.'),
(1558, 'yii', '{n} B'),
(1559, 'yii', '{n} GB'),
(1560, 'yii', '{n} KB'),
(1561, 'yii', '{n} MB'),
(1562, 'yii', '{n} TB'),
(1563, 'yii', '{n} byte|{n} bytes'),
(1564, 'yii', '{n} gigabyte|{n} gigabytes'),
(1565, 'yii', '{n} kilobyte|{n} kilobytes'),
(1566, 'yii', '{n} megabyte|{n} megabytes'),
(1567, 'yii', '{n} terabyte|{n} terabytes'),
(1568, 'yii', '{widget} cannot find the view "{view}".'),
(1569, 'zii', 'Either "name" or "value" must be specified for CDataColumn.'),
(1570, 'zii', 'Home'),
(1571, 'zii', 'No results found.'),
(1572, 'zii', 'Not set'),
(1573, 'zii', 'Please specify the "attributes" property.'),
(1574, 'zii', 'Please specify the "data" property.'),
(1575, 'zii', 'Sort by: '),
(1576, 'zii', 'The "dataProvider" property cannot be empty.'),
(1577, 'zii', 'The attribute must be specified in the format of "Name:Type:Label", where "Type" and "Label" are optional.'),
(1578, 'zii', 'The button type "{type}" is not supported.'),
(1579, 'zii', 'The column must be specified in the format of "Name:Type:Label", where "Type" and "Label" are optional.'),
(1580, 'zii', 'The property "itemView" cannot be empty.'),
(1581, 'zii', 'The property filterSelector should be defined.'),
(1582, 'zii', 'The property updateSelector should be defined.'),
(1583, 'zii', 'Total 1 result.|Total {count} results.'),
(1584, 'zii', '{class} must specify "model" and "{attribute}" or "{name}" property values.'),
(1586, 'UserModule', 'Users'),
(1587, 'UserModule', 'Manage'),
(1588, 'UserModule', 'Create User'),
(1589, 'UserModule', 'Manage Users'),
(1590, 'UserModule', 'Manage Profile Field'),
(1591, 'UserModule', 'List User'),
(1592, 'UserModule', 'Advanced Search'),
(1593, 'UserModule', 'Incorrect username (length between 3 and 20 characters).'),
(1594, 'UserModule', 'Incorrect password (minimal length 4 symbols).'),
(1595, 'UserModule', 'This user\'s name already exists.'),
(1596, 'UserModule', 'This user\'s email address already exists.'),
(1597, 'UserModule', 'Incorrect symbols (A-z0-9).'),
(1598, 'UserModule', 'Id'),
(1599, 'UserModule', 'username'),
(1600, 'UserModule', 'password'),
(1601, 'UserModule', 'Retype Password'),
(1602, 'UserModule', 'E-mail'),
(1603, 'UserModule', 'Verification Code'),
(1604, 'UserModule', 'activation key'),
(1605, 'UserModule', 'Registration date'),
(1606, 'UserModule', 'Last visit'),
(1607, 'UserModule', 'Superuser'),
(1608, 'UserModule', 'Status'),
(1609, 'UserModule', 'Not active'),
(1610, 'UserModule', 'Active'),
(1611, 'UserModule', 'Banned'),
(1612, 'UserModule', 'No'),
(1613, 'UserModule', 'Yes'),
(1614, 'UserModule', 'Search'),
(1615, 'admin', 'Source Message:'),
(1616, 'admin', 'This Message has already been translated to this language.'),
(1617, 'admin', 'ID'),
(1618, 'admin', 'Language'),
(1619, 'admin', 'Translation'),
(1620, 'admin', 'Welcome,'),
(1621, 'admin', 'Home'),
(1622, 'admin', 'Options'),
(1623, 'admin', 'Manage Options'),
(1624, 'admin', 'Create Option'),
(1625, 'admin', 'Sliders'),
(1626, 'admin', 'Manage Sliders'),
(1627, 'admin', 'Create Slider'),
(1628, 'admin', 'Categories'),
(1629, 'admin', 'Manage Categories'),
(1630, 'admin', 'Create Category'),
(1631, 'admin', 'Menus'),
(1632, 'admin', 'Manage Menus'),
(1633, 'admin', 'Create Menu'),
(1634, 'admin', 'Albums'),
(1635, 'admin', 'Manage Albums'),
(1636, 'admin', 'Create Album'),
(1637, 'admin', 'Tabbers'),
(1638, 'admin', 'Manage Tabbers'),
(1639, 'admin', 'Create Tabber'),
(1640, 'admin', 'Pages'),
(1641, 'admin', 'Manage Pages'),
(1642, 'admin', 'Create Page'),
(1643, 'admin', 'Content Blocks'),
(1644, 'admin', 'Manage Content Blocks'),
(1645, 'admin', 'Create Content Block'),
(1646, 'admin', 'News'),
(1647, 'admin', 'Manage News'),
(1648, 'admin', 'Create News'),
(1649, 'admin', 'Newsletter'),
(1650, 'admin', 'Manage Newsletter'),
(1651, 'admin', 'Create Newsletter'),
(1652, 'admin', 'Manage Newsletter Subscribers'),
(1653, 'admin', 'Add Newsletter Subscriber'),
(1654, 'admin', 'Rights'),
(1655, 'admin', 'Assignments'),
(1656, 'admin', 'Roles'),
(1657, 'admin', 'Create Role'),
(1658, 'admin', 'Permissions'),
(1659, 'admin', 'Tasks'),
(1660, 'admin', 'Create Task'),
(1661, 'admin', 'Operations'),
(1662, 'admin', 'Create Operation'),
(1663, 'admin', 'Generate items for controller actions'),
(1664, 'admin', 'Users'),
(1665, 'admin', 'Manage Users'),
(1666, 'admin', 'Create User'),
(1667, 'admin', 'Manage Profile Fields'),
(1668, 'admin', 'Create Profile Field'),
(1669, 'admin', 'Manage Translation'),
(1670, 'admin', 'Create Message'),
(1671, 'admin', 'Translated Messages'),
(1672, 'admin', 'New Translation Language'),
(1673, 'admin', 'Site Languages'),
(1674, 'admin', 'Widgets'),
(1675, 'admin', 'Manage Widgets'),
(1676, 'admin', 'Create Widget'),
(1677, 'admin', 'Manage Widgets Instances'),
(1678, 'admin', 'Create Widget Instance'),
(1679, 'admin', 'Category'),
(1680, 'admin', 'Message'),
(1681, 'admin', 'Translate'),
(1682, 'admin', 'Manage Translates'),
(1683, 'admin', 'Key'),
(1684, 'admin', 'Value'),
(1685, 'admin', 'Group'),
(1686, 'admin', 'FACEBOOK_PAGE'),
(1687, 'admin', 'GOOGLE_ANALYTICS_TRACKING_ID'),
(1688, 'admin', 'GPLUS_PAGE'),
(1689, 'admin', 'I18N_DEFAULT_LANGUAGE'),
(1690, 'admin', 'I18N_MULTILINGUAL'),
(1691, 'admin', 'I18N_TIMEZONE'),
(1692, 'admin', 'INFO_EMAIL'),
(1693, 'admin', 'SITE_TITLE'),
(1694, 'admin', 'SMTP-FROM-EMAIL'),
(1695, 'admin', 'SMTP-FROM-NAME'),
(1696, 'admin', 'SMTP-HOST'),
(1697, 'admin', 'SMTP-PASSWORD'),
(1698, 'admin', 'SMTP-PORT'),
(1699, 'admin', 'SMTP-SECURE'),
(1700, 'admin', 'SMTP-USERNAME'),
(1701, 'admin', 'TWITTER_PAGE'),
(1702, 'admin', 'VIEW MORE'),
(1703, 'admin', 'Email'),
(1704, 'admin', 'NO'),
(1705, 'admin', 'YES'),
(1706, 'admin', 'Title'),
(1707, 'admin', 'Slug'),
(1708, 'admin', 'Ispublished'),
(1709, 'admin', 'Create Datetime'),
(1710, 'admin', 'Update Datetime'),
(1711, 'admin', 'Active Css Class'),
(1712, 'admin', 'Encode Label'),
(1713, 'admin', 'First Item Css Class'),
(1714, 'admin', 'Last Item Css Class'),
(1715, 'admin', 'Hide Empty Items'),
(1716, 'admin', 'Item Css Class'),
(1717, 'admin', 'Item Template'),
(1718, 'admin', 'Link Label Wrapper'),
(1719, 'admin', 'Add Items to Menu'),
(1720, 'admin', 'Manage Menu Items'),
(1721, 'RightsModule.core', 'You are not authorized to perform this action.'),
(1722, 'UserModule', 'Login'),
(1723, 'UserModule', 'Remember me'),
(1724, 'UserModule', 'username or email'),
(1726, 'admin', 'Manage'),
(1727, 'admin', 'Parent'),
(1728, 'admin', 'Search'),
(1729, 'admin', 'Page Link'),
(1730, 'admin', 'Create'),
(1731, 'admin', 'Reset'),
(1732, 'admin', 'Advanced Settings'),
(1733, 'admin', 'Conver Image'),
(1734, 'admin', 'Images Count'),
(1735, 'admin', 'Menu: {menutitle}'),
(1736, 'admin', 'Create Menu Item'),
(1737, 'admin', 'Add To Menu:'),
(1738, 'admin', 'Link Title'),
(1739, 'admin', 'Link'),
(1740, 'admin', 'Link Target'),
(1741, 'admin', 'Order'),
(1742, 'admin', 'Visible'),
(1743, 'admin', 'Menu'),
(1744, 'admin', 'Parent Link'),
(1745, 'admin', 'Select'),
(1746, 'admin', 'Select Link Source:'),
(1747, 'admin', 'Select Category'),
(1748, 'admin', 'Select Page'),
(1749, 'admin', 'Dynamic Page'),
(1750, 'admin', 'Static Page'),
(1751, 'admin', 'Preview:'),
(1752, 'admin', 'Choose Language'),
(1753, 'admin', 'You have successfully subscribed to the newsletter.'),
(1754, 'admin', 'Select Widget'),
(1755, 'admin', 'Insert Widget'),
(1756, 'RightsModule.core', 'Generate items'),
(1757, 'RightsModule.core', 'Please select which items you wish to generate.'),
(1758, 'RightsModule.core', 'Application'),
(1759, 'RightsModule.core', 'Modules'),
(1760, 'RightsModule.core', 'Select all'),
(1761, 'RightsModule.core', 'Select none'),
(1762, 'RightsModule.core', 'Generate'),
(1763, 'RightsModule.core', 'Authorization items created.'),
(1764, 'RightsModule.core', 'Revoke'),
(1765, 'RightsModule.core', 'Assign'),
(1766, 'RightsModule.core', 'Item'),
(1767, 'RightsModule.core', 'Permissions'),
(1768, 'RightsModule.core', 'Here you can view and manage the permissions assigned to each role.'),
(1769, 'RightsModule.core', 'Roles'),
(1770, 'RightsModule.core', 'Tasks'),
(1771, 'RightsModule.core', 'Operations'),
(1772, 'RightsModule.core', 'Authorization items can be managed under {roleLink}, {taskLink} and {operationLink}.'),
(1773, 'RightsModule.core', 'Generate items for controller actions'),
(1774, 'RightsModule.core', 'No authorization items found.'),
(1775, 'RightsModule.core', 'Hover to see from where the permission is inherited.'),
(1776, 'RightsModule.core', 'Source'),
(1777, 'admin', 'Manage Comments'),
(1778, 'admin', 'Create Comment'),
(1779, 'admin', 'Sender Name'),
(1780, 'admin', 'Sender Email'),
(1781, 'admin', 'Sender Homepage'),
(1782, 'admin', 'Body'),
(1783, 'admin', 'Ip Address'),
(1784, 'admin', 'User Agent'),
(1785, 'admin', 'Status'),
(1786, 'admin', 'Owner Route'),
(1787, 'admin', 'Owner Params'),
(1788, 'admin', 'Country'),
(1789, 'admin', 'Content'),
(1790, 'admin', 'Hits'),
(1791, 'admin', 'Item has been successfully created.'),
(1792, 'admin', 'Upload Images'),
(1793, 'admin', 'Manage Images'),
(1794, 'admin', 'Album'),
(1795, 'admin', 'Remove'),
(1796, 'admin', 'Manage Album Images'),
(1808, 'admin', 'Send Datetime'),
(1809, 'admin', 'Update Menu Item'),
(1810, 'admin', 'MenuItem has been successfully updated.'),
(1811, 'admin', 'Item has been successfully updated.'),
(1812, 'admin', 'Description'),
(1813, 'admin', 'Class'),
(1814, 'admin', 'Short Code'),
(1815, 'admin', 'Widget'),
(1816, 'admin', 'Loading Widget Options...'),
(1817, 'admin', 'Widget Options'),
(1818, 'widget', 'Model Class'),
(1819, 'admin', 'Tabber'),
(1820, 'admin', 'Save'),
(1821, 'admin', 'Click "Save" After reordering the tabs inside this Tabber.'),
(1822, 'admin', 'Create Tabs'),
(1823, 'admin', 'Manage Tabs'),
(1824, 'admin', 'Reorder Tabs'),
(1825, 'admin', 'Tabs has been successfully reordered.'),
(1826, 'admin', 'Comment Body'),
(1827, 'site', 'Post Comment'),
(1828, 'admin', 'Your comment posted successfully, it will appear after reviewing.'),
(1829, 'admin', 'Sendre Informations'),
(1830, 'admin', 'Sender Informations'),
(1831, 'admin', 'Draft'),
(1832, 'admin', 'Published'),
(1833, 'editable', 'Select'),
(1834, 'admin', 'Choices'),
(1835, 'admin', 'Votes'),
(1836, 'admin', 'You voted:'),
(1837, 'admin', 'Are you sure you want to cancel your vote?'),
(1838, 'admin', 'Cancel Vote'),
(1839, 'admin', 'Closed'),
(1840, 'admin', 'Open'),
(1841, 'admin', 'Polls'),
(1842, 'admin', 'Manage Polls'),
(1843, 'admin', 'Create Poll'),
(1844, 'admin', 'Comments'),
(1845, 'site', 'Polls'),
(1846, 'admin', 'Choice'),
(1847, 'admin', 'Vote'),
(1848, 'admin', 'Send'),
(1849, 'admin', 'Search results for:'),
(1850, 'admin', 'Option'),
(1851, 'admin', 'Create Images'),
(1852, 'admin', 'Image'),
(1853, 'admin', 'Slider'),
(1854, 'admin', 'Click "Save" After reordering the images inside this album.'),
(1855, 'admin', 'Update Menu'),
(1856, 'admin', 'Menu has been successfully updated.'),
(1857, 'admin', 'Animation'),
(1858, 'admin', 'Clickable'),
(1859, 'admin', 'Cursor'),
(1860, 'admin', 'Draggable'),
(1861, 'admin', 'Icon'),
(1862, 'admin', 'Latitude'),
(1863, 'admin', 'Longitude'),
(1864, 'admin', 'Map'),
(1865, 'admin', 'Manage Google Map Markers'),
(1866, 'admin', 'Create GoogleMapMarker'),
(1867, 'admin', 'Manage Google Maps'),
(1868, 'admin', 'Create GoogleMap'),
(1869, 'admin', 'Background Color'),
(1870, 'admin', 'Center Latitude'),
(1871, 'admin', 'Center Longitude'),
(1872, 'admin', 'Disable Double Click Zoom'),
(1873, 'admin', 'Maptype Control'),
(1874, 'admin', 'Maptype Control Ids'),
(1875, 'admin', 'Maptype Control Style'),
(1876, 'admin', 'Maptype Control Position'),
(1877, 'admin', 'Maptype'),
(1878, 'admin', 'Overview Control'),
(1879, 'admin', 'Overview Control Opened'),
(1880, 'admin', 'Pan Control'),
(1881, 'admin', 'Pan Control Position'),
(1882, 'admin', 'Rotate Control'),
(1883, 'admin', 'Rotate Control Position'),
(1884, 'admin', 'Scale Control'),
(1885, 'admin', 'Scale Control Position'),
(1886, 'admin', 'Scrollwheel'),
(1887, 'admin', 'Zoom'),
(1888, 'admin', 'Zoom Control'),
(1889, 'admin', 'Zoom Control Position'),
(1890, 'admin', 'Zoom Control Style'),
(1891, 'admin', 'Width'),
(1892, 'admin', 'Height'),
(1893, 'admin', 'Html'),
(1894, 'admin', 'Html Class'),
(1895, 'admin', 'Fit Markers Into View'),
(1896, 'admin', 'HYBRID'),
(1897, 'admin', 'ROADMAP'),
(1898, 'admin', 'SATELLITE'),
(1899, 'admin', 'TERRAIN'),
(1900, 'admin', 'DEFAULT'),
(1901, 'admin', 'DROPDOWN_MENU'),
(1902, 'admin', 'HORIZONTAL_BAR'),
(1903, 'admin', 'BOTTOM_CENTER'),
(1904, 'admin', 'BOTTOM_LEFT'),
(1905, 'admin', 'BOTTOM_RIGHT'),
(1906, 'admin', 'LEFT_BOTTOM'),
(1907, 'admin', 'LEFT_CENTER'),
(1908, 'admin', 'LEFT_TOP'),
(1909, 'admin', 'RIGHT_BOTTOM'),
(1910, 'admin', 'RIGHT_CENTER'),
(1911, 'admin', 'RIGHT_TOP'),
(1912, 'admin', 'TOP_CENTER'),
(1913, 'admin', 'TOP_LEFT'),
(1914, 'admin', 'TOP_RIGHT'),
(1915, 'admin', 'BOTTOM CENTER'),
(1916, 'admin', 'BOTTOM LEFT'),
(1917, 'admin', 'BOTTOM RIGHT'),
(1918, 'admin', 'LEFT BOTTOM'),
(1919, 'admin', 'LEFT CENTER'),
(1920, 'admin', 'LEFT TOP'),
(1921, 'admin', 'RIGHT BOTTOM'),
(1922, 'admin', 'RIGHT CENTER'),
(1923, 'admin', 'RIGHT TOP'),
(1924, 'admin', 'TOP CENTER'),
(1925, 'admin', 'TOP LEFT'),
(1926, 'admin', 'TOP RIGHT'),
(1927, 'admin', 'DROPDOWN MENU'),
(1928, 'admin', 'HORIZONTAL BAR'),
(1929, 'admin', 'Road Map'),
(1930, 'admin', 'Map Type Control'),
(1931, 'admin', 'Control Ids'),
(1932, 'admin', 'Control Style'),
(1933, 'admin', 'Control Position'),
(1934, 'admin', 'Enable?'),
(1935, 'admin', 'Opened'),
(1936, 'admin', 'Position'),
(1937, 'admin', 'Rorate Control'),
(1938, 'admin', 'Scroll Wheel'),
(1939, 'admin', 'Style'),
(1940, 'admin', 'Large'),
(1941, 'admin', 'Small'),
(1942, 'admin', 'Ids'),
(1943, 'admin', 'Html ID'),
(1944, 'admin', 'Map Center Latitude'),
(1945, 'admin', 'Map Center Longitude'),
(1946, 'admin', 'Background'),
(1947, 'admin', 'Types'),
(1948, 'admin', 'Articles'),
(1949, 'admin', 'Manage Articles'),
(1950, 'admin', 'Create Article'),
(1951, 'admin', 'Create Markers'),
(1952, 'admin', 'Manage Markers'),
(1953, 'admin', 'Reorder Markers'),
(1954, 'admin', 'Bounce'),
(1955, 'admin', 'Drop'),
(1956, 'admin', 'Create Google Map Marker'),
(1957, 'admin', 'Upload'),
(1958, 'widget', 'Map ID'),
(1959, 'admin', 'Create Google Map'),
(1960, 'admin', 'Have Previous Experience'),
(1961, 'admin', 'Previous Experience Role'),
(1962, 'admin', 'Phonenumber'),
(1963, 'admin', 'Do you have any previous experience in volunteering field?'),
(1964, 'admin', 'If Yes, can you tell us more?'),
(1965, 'admin', 'Phone Number'),
(1966, 'site', 'Complete Subscription'),
(1967, 'admin', 'Full Name'),
(1968, 'admin', 'googleMaps'),
(1969, 'admin', 'Manage googleMaps'),
(1970, 'admin', 'Google Maps'),
(1971, 'admin', 'Incorrect username or password.'),
(1972, 'widget', 'Order'),
(1973, 'widget', 'Exclude Category'),
(1974, 'widget', 'Excluded Categories'),
(1975, 'widget', 'Page Size'),
(1976, 'site', 'Delete all selected Comments.'),
(1977, 'site', 'Please select at least one comment to delete.'),
(1978, 'site', 'Delete Selected.'),
(1979, 'site', 'Delete Selected'),
(1980, 'site', 'Delete'),
(1981, 'site', 'Approve'),
(1982, 'site', 'Draft'),
(1983, 'zii', 'Are you sure you want to perform this action?'),
(1984, 'admin', 'Apprive'),
(1985, 'admin', 'Approve'),
(1992, 'Chosen.main', 'Select an Option'),
(1993, 'Chosen.main', 'No results match'),
(1994, 'Chosen.main', 'Select Some Options'),
(1995, 'site', 'Please select at least one item to delete.'),
(1996, 'admin', 'Desc'),
(1997, 'admin', 'SEO_AUTHOR'),
(1998, 'admin', 'SEO_DEFAULT_KEYWORDS'),
(1999, 'admin', 'SEO_DESCRIPTION'),
(2000, 'admin', 'SEO_KEYWORDS'),
(2001, 'admin', 'Export'),
(2002, 'site', 'CSV File'),
(2003, 'site', 'Excel File'),
(2004, 'site', 'JSON Format'),
(2005, 'admin', 'Article s'),
(2006, 'admin', 'Article'),
(2007, 'admin', 'Type Article Title'),
(2008, 'admin', 'Facebook Comments'),
(2009, 'admin', 'Featured'),
(2010, 'admin', 'Order Images'),
(2011, 'admin', 'Reorder Images'),
(2012, 'admin', 'Update User'),
(2013, 'UserModule', 'Create'),
(2014, 'UserModule', 'Fields with <span class="required">*</span> are required.'),
(2015, 'UserModule', 'Incorrect First Name (length between 3 and 50 characters).'),
(2016, 'UserModule', 'Incorrect Last Name (length between 3 and 50 characters).'),
(2017, 'UserModule', 'User ID'),
(2018, 'UserModule', 'First Name'),
(2019, 'UserModule', 'Last Name'),
(2020, 'UserModule', 'Update'),
(2021, 'UserModule', 'View User'),
(2022, 'UserModule', 'Update User'),
(2023, 'admin', 'Author: '),
(2024, 'UserModule', 'Delete User'),
(2025, 'UserModule', 'Are you sure to delete this item?'),
(2026, 'admin', 'Insert Gallery'),
(2027, 'xupload.widget', 'File is too big'),
(2028, 'xupload.widget', 'File is too small'),
(2029, 'xupload.widget', 'Filetype not allowed'),
(2030, 'xupload.widget', 'Max number of files exceeded'),
(2031, 'xupload.widget', 'Uploaded bytes exceed file size'),
(2032, 'xupload.widget', 'Empty file upload result'),
(2033, 'xupload.widget', 'Error'),
(2034, 'xupload.widget', 'Start'),
(2035, 'xupload.widget', 'Cancel'),
(2036, 'xupload.widget', 'Delete'),
(2037, 'xupload.widget', '1#Add files|0#Choose file'),
(2038, 'RightsModule.core', 'Assignments'),
(2039, 'RightsModule.core', 'Here you can view which permissions has been assigned to each user.'),
(2040, 'RightsModule.core', 'No users found.'),
(2041, 'RightsModule.core', 'Name'),
(2042, 'admin', 'Manage Article Albums'),
(2043, 'admin', 'Create ArticleAlbum'),
(2044, 'admin', 'Author:'),
(2045, 'admin', 'MenuItem has been successfully created.'),
(2046, 'admin', 'SHOW_AUTHOR'),
(2047, 'admin', 'Set Default Language'),
(2048, 'admin', 'Language Name'),
(2049, 'admin', 'Language Code'),
(2050, 'admin', 'Locale'),
(2051, 'admin', 'Active'),
(2052, 'admin', 'Select Locale:'),
(2053, 'admin', 'Menu has been successfully created.'),
(2054, 'site', 'Converting ideas into reality'),
(2055, 'site', 'Books'),
(2056, 'site', 'Magazines'),
(2057, 'site', 'Profiles'),
(2058, 'site', 'Posters & Flyers'),
(2059, 'site', 'Desk planners'),
(2060, 'site', 'Desk diary'),
(2061, 'site', 'Leather Bags'),
(2062, 'site', 'Leather<br/>stationary'),
(2063, 'site', 'Invitation cards'),
(2064, 'site', 'Promotional<br/>items'),
(2065, 'site', 'Packaging'),
(2066, 'site', 'Stationary'),
(2067, 'site', 'Al-CAI News'),
(2068, 'site', 'Latest Statments'),
(2069, 'site', 'Be Informed'),
(2070, 'site', 'Subscribe to our mailing list'),
(2071, 'site', 'Articles'),
(2072, 'site', 'All rights reserverd | CAI'),
(2073, 'site', 'About The CAI'),
(2074, 'site', 'Al CAI Friends'),
(2075, 'site', 'Al CAI Institutions'),
(2076, 'site', 'Voting'),
(2077, 'site', 'Vote'),
(2078, 'site', 'Media'),
(2079, 'admin', 'Questionnaires'),
(2080, 'admin', 'Manage Questionnaires'),
(2081, 'admin', 'Create Questionnaire'),
(2082, 'admin', 'LINKEDIN_PAGE'),
(2083, 'site', 'YOUTUBE_PAGE'),
(2084, 'site', 'LINKEDIN_PAGE'),
(2085, 'site', 'Questionnaires'),
(2086, 'site', 'success_msg'),
(2087, 'site', 'error_msg'),
(2088, 'site', 'mobile');

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

--
-- Table structure for table `googlemaps_map`
--

CREATE TABLE `googlemaps_map` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `background_color` char(7) NOT NULL DEFAULT '#E5E3DF',
  `center_latitude` float(10,6) NOT NULL,
  `center_longitude` float(10,6) NOT NULL,
  `disable_double_click_zoom` tinyint(1) NOT NULL DEFAULT '0',
  `draggable` tinyint(1) NOT NULL DEFAULT '1',
  `maptype_control` tinyint(1) NOT NULL DEFAULT '1',
  `maptype_control_ids` varchar(35) NOT NULL DEFAULT 'HYBRID,ROADMAP,SATELLITE,TERRAIN',
  `maptype_control_style` varchar(15) NOT NULL DEFAULT 'DEFAULT',
  `maptype_control_position` varchar(15) NOT NULL DEFAULT 'TOP_RIGHT',
  `maptype_id` varchar(10) NOT NULL DEFAULT 'ROADMAP',
  `overview_control` tinyint(1) NOT NULL DEFAULT '1',
  `overview_control_opened` tinyint(1) NOT NULL DEFAULT '0',
  `pan_control` tinyint(1) NOT NULL DEFAULT '1',
  `pan_control_position` varchar(15) NOT NULL DEFAULT 'TOP_LEFT',
  `rotate_control` tinyint(1) NOT NULL DEFAULT '1',
  `rotate_control_position` varchar(15) NOT NULL DEFAULT 'TOP_LEFT',
  `scale_control` tinyint(1) NOT NULL DEFAULT '1',
  `scale_control_position` varchar(15) NOT NULL DEFAULT 'BOTTOM_LEFT',
  `scrollwheel` tinyint(1) NOT NULL DEFAULT '1',
  `zoom` tinyint(2) NOT NULL DEFAULT '10',
  `zoom_control` tinyint(1) NOT NULL DEFAULT '1',
  `zoom_control_position` varchar(15) NOT NULL DEFAULT 'TOP_LEFT',
  `zoom_control_style` varchar(7) NOT NULL DEFAULT 'DEFAULT',
  `width` varchar(20) NOT NULL,
  `height` varchar(20) NOT NULL,
  `html_id` varchar(45) DEFAULT NULL,
  `html_class` varchar(45) DEFAULT NULL,
  `fit_markers_into_view` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `googlemaps_marker`
--

CREATE TABLE `googlemaps_marker` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `animation` varchar(7) DEFAULT NULL,
  `clickable` tinyint(1) NOT NULL DEFAULT '1',
  `cursor` varchar(20) DEFAULT NULL,
  `draggable` tinyint(1) DEFAULT '0',
  `icon` varchar(200) NOT NULL,
  `latitude` float(10,6) NOT NULL,
  `longitude` float(10,6) NOT NULL,
  `map_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `htmlblock`
--

CREATE TABLE `htmlblock` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `language` char(2) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `slug` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `language` char(2) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `active_css_class` varchar(45) NOT NULL DEFAULT 'active',
  `encode_label` tinyint(1) NOT NULL DEFAULT '1',
  `first_item_css_class` varchar(45) NOT NULL DEFAULT 'first-item',
  `last_item_css_class` varchar(45) NOT NULL DEFAULT 'last-item',
  `hide_empty_items` tinyint(1) NOT NULL DEFAULT '1',
  `item_css_class` varchar(45) NOT NULL,
  `item_template` varchar(200) NOT NULL DEFAULT '{menu}',
  `link_label_wrapper` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id`, `title`, `slug`, `status`, `language`, `create_datetime`, `update_datetime`, `active_css_class`, `encode_label`, `first_item_css_class`, `last_item_css_class`, `hide_empty_items`, `item_css_class`, `item_template`, `link_label_wrapper`) VALUES
(1, 'header', 'header', 1, 'ar', 1518959085, 1518959085, 'active', 1, 'first-item', 'last-item', 1, '', '{menu}', NULL),
(2, 'main', 'main', 1, 'ar', 1518959099, 1518959099, 'active', 1, 'first-item', 'last-item', 1, '', '{menu}', NULL),
(3, 'footer', 'footer', 1, 'ar', 1518959111, 1518959111, 'active', 1, 'first-item', 'last-item', 1, '', '{menu}', NULL),
(4, 'footer2', 'footer2', 1, 'ar', 1519205654, 1519205654, 'active', 1, 'first-item', 'last-item', 1, '', '{menu}', NULL),
(5, 'footer3', 'footer3', 1, 'ar', 1519205670, 1519205670, 'active', 1, 'first-item', 'last-item', 1, '', '{menu}', NULL);

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

--
-- Table structure for table `menu_item`
--

CREATE TABLE `menu_item` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `link` varchar(250) NOT NULL,
  `link_target` varchar(8) NOT NULL DEFAULT '0',
  `order` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `visible` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `menu_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `language` char(2) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `template` varchar(300) NOT NULL DEFAULT '{menu}',
  `link_options` text NOT NULL,
  `item_options` text NOT NULL,
  `submenu_options` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menu_item`
--

INSERT INTO `menu_item` (`id`, `title`, `link`, `link_target`, `order`, `visible`, `menu_id`, `parent_id`, `language`, `create_datetime`, `update_datetime`, `template`, `link_options`, `item_options`, `submenu_options`) VALUES
(1, 'مجموعة البركة', '/page/view/Al-Baraka-Group?lang=ar', '', 0, 1, 1, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(2, 'أسعار العملا', '/page/view/currency?lang=ar', '', 0, 1, 1, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(3, 'الإنترنت البنكي', '/page/view/Al-Baraka-Group?lang=ar', '', 0, 1, 1, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(4, 'المسؤولية الاجتماعية', '/page/view/Al-Baraka-Group?lang=ar', '', 0, 1, 1, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(5, 'انضم إلينا', 'http://www.albarakasyria.com/joinus/index.php', '', 0, 1, 1, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(6, 'عن البنك', '', '', 0, 1, 2, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(7, 'المنتجات و الخدمات المصرفية', '', '', 0, 1, 2, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(8, 'علاقة المساهمين و البيانات المالية', '', '', 0, 1, 2, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(9, 'المركز الإعلامي', '', '', 0, 1, 2, NULL, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(10, 'نشأة البنك', '/page/view/about-bank?lang=ar', '', 0, 1, 2, 6, 'ar', 2018, 1519633511, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(11, 'كلمة رئيس مجلس الإدارة', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(12, 'كلمة الرئيس التنفيذي', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(13, 'الامتثال', '#', '', 0, 1, 2, 6, 'ar', 2018, 1519635461, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(14, 'أعضاء مجلس الإدارة', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(15, 'أعضاء هيئة الرقابة الشرعية', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(16, 'الرؤية و الرسالة و القيم', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(17, 'الإدارة التنفيذية', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(18, ' مدققوا الحسابات', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(19, ' المؤسسون في بنك البركة سورية', '', '', 0, 1, 2, 6, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(20, 'الحكومة المؤسساتية', '', '', 0, 1, 2, 13, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(21, 'دليل الحكومة', '', '', 0, 1, 2, 20, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(22, 'بيان الحكومة', '', '', 0, 1, 2, 20, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(23, ' مكافحة غسيل الأموال و تمويل الإرهاب', '', '', 0, 1, 2, 13, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(24, 'سياسة مكافحة غسيل الأموال و تمويل الإرهاب', '', '', 0, 1, 2, 23, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(25, 'استمارة مكافحة غسيل الأموال و تمويل الإرهاب', '', '', 0, 1, 2, 23, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(26, 'قانون الامتثال الضريبي للحسابات الخارجية FATCA', '', '', 0, 1, 2, 13, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(27, 'رسالة المتعاملين', '', '', 0, 1, 2, 26, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(28, 'الأسئلة الأكثر شيوعا', '', '', 0, 1, 2, 26, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(29, 'رقم وسيط التعريف العالمي الخاص ببنك البركة GIN', '', '', 0, 1, 2, 26, 'ar', 2018, 2018, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(30, 'أسئلة متكررة', '#', '', 0, 1, 3, NULL, 'ar', 1519205606, 1519205606, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(31, 'زكاة الأسهم و فتاوي مجموعة البركة', '#', '', 0, 1, 3, NULL, 'ar', 1519205620, 1519205620, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(32, 'تعليمات الحماية', '#', '', 0, 1, 3, NULL, 'ar', 1519205630, 1519205630, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(33, 'الجودة في بنك البركة', '#', '', 0, 1, 4, NULL, 'ar', 1519205683, 1519205683, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(34, 'جوائز و شهادات', '#', '', 0, 1, 4, NULL, 'ar', 1519205693, 1519205693, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(35, 'مركز رضا المتعاملين شكاوي و مقترحات', '#', '', 0, 1, 4, NULL, 'ar', 1519205703, 1519205703, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(36, 'خريطة الموقع', '#', '', 0, 1, 5, NULL, 'ar', 1519205722, 1519205722, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(37, 'خدمة تكوين لريادة الأعمال', '#', '', 0, 1, 5, NULL, 'ar', 1519205732, 1519205732, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(38, 'انضم إلينا', 'http://www.albarakasyria.com/joinus/index.php', '', 0, 1, 5, NULL, 'ar', 1519205744, 1519205744, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(39, ' الحسابات', '#', '', 0, 1, 2, 7, 'ar', 1519206405, 1519206405, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(40, 'التسهيلات المصرفية و التمويلية', '$', '', 0, 1, 2, 7, 'ar', 1519206436, 1519206436, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(41, 'خدمات مصرفية', '#', '', 0, 1, 2, 7, 'ar', 1519206451, 1519206451, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(42, 'خدمات البركة الالكترونية', '#', '', 0, 1, 2, 7, 'ar', 1519206468, 1519206468, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(43, ' الخزينة و الاستثمار', '#', '', 0, 1, 2, 7, 'ar', 1519206478, 1519206478, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(44, 'الحساب الجاري', '/page/view/about-bank?lang=ar', '', 0, 1, 2, 39, 'ar', 1519206511, 1519633887, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(45, 'حساب توطين الرواتب', '#', '', 0, 1, 2, 39, 'ar', 1519206525, 1519206525, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(46, ' حساب الادخار الاستثماري (التوفير)', '#', '', 0, 1, 2, 39, 'ar', 1519206540, 1519206540, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(47, ' الحسابات الاستثمارية لأجل معين', '#', '', 0, 1, 2, 39, 'ar', 1519206583, 1519206583, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(48, ' وديعة الدخل الشهري', '#', '', 0, 1, 2, 39, 'ar', 1519206597, 1519206597, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(49, ' خدمة تسهيلات التجارة الدولية', '#', '', 0, 1, 2, 40, 'ar', 1519206620, 1519206620, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(50, 'خدمة تمويل البضائع المحلية', '#', '', 0, 1, 2, 40, 'ar', 1519206633, 1519206633, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(51, 'خدمة تمويل المشاريع ', '#', '', 0, 1, 2, 40, 'ar', 1519206647, 1519206647, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(52, 'خدمة تمويل التجزئة', '#', '', 0, 1, 2, 40, 'ar', 1519206667, 1519206667, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(53, ' الاعتمادات و الكفالات', '#', '', 0, 1, 2, 40, 'ar', 1519206689, 1519206689, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(54, '  حوالات و بوالص', '#', '', 0, 1, 2, 41, 'ar', 1519206743, 1519206743, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(55, 'صندوق الزكاة', '#', '', 0, 1, 2, 41, 'ar', 1519206757, 1519206757, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(56, ' تحصيل الشيكات', '#', '', 0, 1, 2, 41, 'ar', 1519206774, 1519206774, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(57, ' إصدار شيكات بنكية / شيكات مصدقة', '#', '', 0, 1, 2, 41, 'ar', 1519206789, 1519206789, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(58, ' لائحة عمولات البنك', '#', '', 0, 1, 2, 41, 'ar', 1519206805, 1519206805, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(59, ' تطبيق البركة بموبايلك', '#', '', 0, 1, 2, 42, 'ar', 1519210338, 1519210338, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(60, 'الانترنت البنكي', '#', '', 0, 1, 2, 42, 'ar', 1519210351, 1519210351, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(61, 'خدمة تم', '#', '', 0, 1, 2, 42, 'ar', 1519210368, 1519210368, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(62, 'خدمة الرسائل النصية', '#', '', 0, 1, 2, 42, 'ar', 1519210380, 1519210380, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(63, 'بطاقات الصراف الآلي', '#', '', 0, 1, 2, 42, 'ar', 1519210392, 1519210392, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(64, 'توطين الفواتير', '#', '', 0, 1, 2, 42, 'ar', 1519210404, 1519210404, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(65, 'التقرير السنوي التفاعلي', '#', '', 0, 1, 2, 8, 'ar', 1519210490, 1519210490, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(66, 'التقارير السنوية', '#', '', 0, 1, 2, 8, 'ar', 1519210506, 1519210506, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(67, 'التقرير السنوي لعام 2016', '#', '', 0, 1, 2, 66, 'ar', 1519210529, 1519210529, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(68, 'التقرير السنوي لعام 2015', '#', '', 0, 1, 2, 66, 'ar', 1519210547, 1519210547, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(69, 'التقرير السنوي لعام 2014', '#', '', 0, 1, 2, 66, 'ar', 1519210563, 1519210563, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(70, 'التقرير السنوي لعام 2013', '#', '', 0, 1, 2, 66, 'ar', 1519210585, 1519210585, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(71, 'التقرير السنوي لعام 2012', '#', '', 0, 1, 2, 66, 'ar', 1519210599, 1519210599, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(72, 'البيانات المالية', '#', '', 0, 1, 2, 8, 'ar', 1519210618, 1519210618, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(73, 'البيانات المالية المرحلية المراجعة للربيع الأول 2017', '#', '', 0, 1, 2, 72, 'ar', 1519210678, 1519210678, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(74, 'البيانات المالية المرحلية المراجعة للربع الثاني 2017', '#', '', 0, 1, 2, 72, 'ar', 1519210714, 1519210714, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(75, 'البيانات المالية الختامية المدققة في 31-12-2016', '#', '', 0, 1, 2, 72, 'ar', 1519210809, 1519210809, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(76, 'البيانات المالية المرحلية المراجعة للربع الثالث 2016', '#', '', 0, 1, 2, 72, 'ar', 1519210840, 1519210840, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(77, 'البيانات المالية المرحلية المراجعة للربع الثاني 2016', '#', '', 0, 1, 2, 72, 'ar', 1519210895, 1519210895, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(78, 'إفصاحات', '#', '', 0, 1, 2, 8, 'ar', 1519210920, 1519210920, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(79, '‘فصاح رقم 1', '#', '', 0, 1, 2, 78, 'ar', 1519210944, 1519210944, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(80, 'إفصاح رقم 2', '#', '', 0, 1, 2, 78, 'ar', 1519211002, 1519211002, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(81, 'أخبار مجموعة البركة', '#', '', 0, 1, 2, 9, 'ar', 1519211023, 1519211023, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(82, 'أخبار بنك البركة', '#', '', 0, 1, 2, 9, 'ar', 1519211044, 1519211044, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]'),
(83, 'أخبار المسؤولية الاجتماعية لبنك البركة سورية', '', '', 0, 1, 2, 9, 'ar', 1519211080, 1519211080, '{menu}', '{"key":["","","","",""],"value":["","","","",""]}', '[]', '[]');

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL,
  `send_datetime` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `newsletter_subscriber`
--

CREATE TABLE `newsletter_subscriber` (
  `id` int(11) NOT NULL,
  `email` varchar(50) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `fullname` varchar(50) DEFAULT NULL,
  `have_previous_experience` tinyint(1) DEFAULT NULL,
  `previous_experience_role` varchar(300) DEFAULT NULL,
  `phonenumber` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `key` varchar(45) NOT NULL,
  `value` varchar(450) NOT NULL,
  `group` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` (`key`, `value`, `group`) VALUES
('allowing_multiple_participations', '0', 'questionnaire'),
('CONTACT_EMAIL', 'info@flexsolution.biz', 'contact-info'),
('FACEBOOK_PAGE', 'https://www.facebook.com', 'social-media'),
('GOOGLE_ANALYTICS_TRACKING_ID', 'UA-000000-01', 'google-analytics'),
('GOOGLE_PAGE', 'http://plus.google.com', 'social-media'),
('I18N_DEFAULT_LANGUAGE', 'en', 'language'),
('I18N_MULTILINGUAL', '1', 'language'),
('I18N_TIMEZONE', 'Africa/Cairo', 'language'),
('INFO_EMAIL', 'info@flexsolution.com', 'contact-info'),
('INSTGRAM_PAGE', 'www.instagram.com/flexsolution', 'social-media'),
('ip_maximum_daily_participations', '20', 'questionnaire'),
('LINKEDIN_PAGE', 'https://www.linkedin.com/flexsolution', 'social-media'),
('SEO_AUTHOR', 'flexsolution', 'seo-defaults'),
('SEO_DESCRIPTION', 'flexsolution', 'seo-defaults'),
('SEO_KEYWORDS', 'flexsolution', 'seo-defaults'),
('SHOW_AUTHOR', '0', 'global-info'),
('SITE_TITLE', 'Flex Solution CMS', 'global-info'),
('SMTP-FROM-EMAIL', 'flexsolution@gmail.com', 'smtp-configuration'),
('SMTP-FROM-NAME', 'flexsolution', 'smtp-configuration'),
('SMTP-HOST', 'smtp.gmail.com', 'smtp-configuration'),
('SMTP-PASSWORD', '1234', 'smtp-configuration'),
('SMTP-PORT', '465', 'smtp-configuration'),
('SMTP-SECURE', 'ssl', 'smtp-configuration'),
('SMTP-USERNAME', 'flexsolution@gmail.com', 'smtp-configuration'),
('TWITTER_PAGE', 'https://www.twitter.com/flexsolution', 'social-media'),
('YOUTUBE_PAGE', 'https://www.youtube.com/flexsolution', 'social-media');

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

--
-- Table structure for table `option_group`
--

CREATE TABLE `option_group` (
  `key` varchar(45) NOT NULL,
  `title` varchar(100) NOT NULL,
  `desc` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option_group`
--

INSERT INTO `option_group` (`key`, `title`, `desc`) VALUES
('contact-info', 'Contact Info', NULL),
('global-info', 'Global Info', NULL),
('google-analytics', 'Google Analtics', NULL),
('language', 'Language & I18n', 'Language & Internationalization'),
('questionnaire', 'Questionnaire', ''),
('seo-defaults', 'SEO', ''),
('smtp-configuration', 'SMTP Configuration', ''),
('social-media', 'Social Media', NULL);

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

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

CREATE TABLE `page` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `slug` varchar(80) NOT NULL,
  `content` text NOT NULL,
  `language` char(2) NOT NULL,
  `layout` varchar(45) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `page` (`id`, `title`, `slug`, `content`, `language`, `layout`, `create_datetime`, `update_datetime`) VALUES
(1, 'مجموعة البركة', 'Al-Baraka-Group', 'مجموعة البركة', 'ar', 'main', 2018, 2018),
(2, 'أسعار العملات', 'currency', 'currency', 'ar', 'main', 2018, 2018),
(3, 'نشأة البنك', 'about-bank', 'test', 'ar', 'main', 2018, 2018);

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

--
-- Table structure for table `poll`
--

CREATE TABLE `poll` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `poll_choice`
--

CREATE TABLE `poll_choice` (
  `id` int(11) UNSIGNED NOT NULL,
  `poll_id` int(11) UNSIGNED NOT NULL,
  `label` varchar(255) NOT NULL DEFAULT '',
  `votes` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `weight` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `poll_vote`
--

CREATE TABLE `poll_vote` (
  `id` int(11) UNSIGNED NOT NULL,
  `choice_id` int(11) UNSIGNED NOT NULL,
  `poll_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ip_address` varchar(16) NOT NULL DEFAULT '',
  `timestamp` int(11) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `user_id` int(11) NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`user_id`, `first_name`, `last_name`) VALUES
(1, 'إسم ', 'الكاتب');

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

--
-- Table structure for table `questionnaire`
--

CREATE TABLE `questionnaire` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `intro` text,
  `create_datetime` datetime NOT NULL,
  `update_datetime` datetime NOT NULL,
  `publish_datetime` datetime NOT NULL,
  `end_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `questionnaire_answer`
--

CREATE TABLE `questionnaire_answer` (
  `id` int(11) NOT NULL,
  `data` text NOT NULL,
  `question_id` int(11) NOT NULL,
  `ip_address` int(11) NOT NULL,
  `create_datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `questionnaire_question`
--

CREATE TABLE `questionnaire_question` (
  `id` int(11) NOT NULL,
  `type` tinyint(2) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `title` varchar(200) NOT NULL,
  `options` text NOT NULL,
  `questionnaire_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `rights`
--

CREATE TABLE `rights` (
  `itemname` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `weight` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rights`
--

INSERT INTO `rights` (`itemname`, `type`, `weight`) VALUES
('Authenticated', 2, 1),
('Guest', 2, 2);

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `title` varchar(90) NOT NULL,
  `options` varchar(450) NOT NULL DEFAULT '',
  `language` char(2) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `title`, `options`, `language`, `create_datetime`, `update_datetime`) VALUES
(1, 'main', '', 'ar', 0, 0);

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

--
-- Table structure for table `slider_images`
--

CREATE TABLE `slider_images` (
  `id` int(11) NOT NULL,
  `image` varchar(45) NOT NULL,
  `slider_id` int(11) NOT NULL,
  `order` int(4) NOT NULL DEFAULT '0',
  `link` varchar(200) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `description` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slider_images`
--

INSERT INTO `slider_images` (`id`, `image`, `slider_id`, `order`, `link`, `title`, `description`) VALUES
(1, '5a93c2024d6fd.jpg', 1, 0, NULL, NULL, NULL),
(2, '5a93c2027b77b.jpg', 1, 0, NULL, NULL, NULL);

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

--
-- Table structure for table `tabber`
--

CREATE TABLE `tabber` (
  `id` int(11) NOT NULL,
  `title` varchar(90) NOT NULL,
  `language` char(2) NOT NULL,
  `create_datetime` int(11) NOT NULL,
  `update_datetime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tabber_tab`
--

CREATE TABLE `tabber_tab` (
  `id` int(11) NOT NULL,
  `title` varchar(400) NOT NULL,
  `content` text NOT NULL,
  `tabber_id` int(11) NOT NULL,
  `order` int(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(128) NOT NULL DEFAULT '',
  `email` varchar(128) NOT NULL DEFAULT '',
  `activkey` varchar(128) NOT NULL DEFAULT '',
  `superuser` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '0',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastvisit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`, `activkey`, `superuser`, `status`, `create_at`, `lastvisit_at`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'infi@flexsolution.biz', '765bd477b6cbe2e7db431fa74e6e1451', 1, 1, '2014-02-24 09:45:43', '2014-02-26 14:10:25');

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

--
-- Table structure for table `widget`
--

CREATE TABLE `widget` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL COMMENT 'Widget Title',
  `description` text,
  `class` varchar(100) NOT NULL COMMENT 'YII Widget Class Name',
  `shortcode` varchar(50) NOT NULL COMMENT 'the short code used to call this widget'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `widget`
--

INSERT INTO `widget` (`id`, `title`, `description`, `class`, `shortcode`) VALUES
(6, 'Tabber Widget', '', 'FtabberWidget', 'ftabber'),
(8, 'Slider Widget', '', 'FsliderWidget', 'fslider'),
(9, 'New List Widget', '', 'NewsListWidget', 'newslist'),
(10, 'Twitter Bootstrap Carousel Widget', '', 'BootstrapCarouselWidget', 'bootstrapcarousel'),
(11, 'NivoSlider Widget', '', 'NivoSliderWidget', 'nivoslider'),
(12, 'Newsletter Subscribe Widget', '', 'NewsletterSubscribeWidget', 'newsletter'),
(13, 'RoyalSlider Widget', '', 'RoyalSliderWidget', 'royalslider'),
(14, 'Google Map Widget', '', 'GoogleMapWidget', 'googlemap'),
(15, 'Data Provider Widget', '', 'DataProviderWidget', 'dataprovider'),
(16, 'JQueryStepsWidget', '', 'JQueryStepsWidget', 'jquerysteps');

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

--
-- Table structure for table `widget_instance`
--

CREATE TABLE `widget_instance` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `options` text NOT NULL,
  `widget_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `album`
--
ALTER TABLE `album`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slug` (`slug`);

--
-- Indexes for table `album_has_category`
--
ALTER TABLE `album_has_category`
  ADD PRIMARY KEY (`album_id`,`category_id`),
  ADD KEY `fk_album_has_category_category1_idx` (`category_id`),
  ADD KEY `fk_album_has_category_album1_idx` (`album_id`);

--
-- Indexes for table `album_image`
--
ALTER TABLE `album_image`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_album_image_album1_idx` (`album_id`),
  ADD KEY `slug` (`slug`);

--
-- Indexes for table `article`
--
ALTER TABLE `article`
  ADD PRIMARY KEY (`id`),
  ADD KEY `language` (`language`),
  ADD KEY `fk_article_users1_idx` (`create_user_id`),
  ADD KEY `fk_article_users2_idx` (`update_user_id`);

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

--
-- Indexes for table `article_has_category`
--
ALTER TABLE `article_has_category`
  ADD PRIMARY KEY (`article_id`,`category_id`),
  ADD KEY `fk_article_has_category_category1_idx` (`category_id`),
  ADD KEY `fk_article_has_category_article1_idx` (`article_id`);

--
-- Indexes for table `authassignment`
--
ALTER TABLE `authassignment`
  ADD PRIMARY KEY (`itemname`,`userid`);

--
-- Indexes for table `authitem`
--
ALTER TABLE `authitem`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `authitemchild`
--
ALTER TABLE `authitemchild`
  ADD PRIMARY KEY (`parent`,`child`),
  ADD KEY `child` (`child`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_category_category1_idx` (`parent_id`),
  ADD KEY `slug` (`slug`),
  ADD KEY `language` (`language`);

--
-- Indexes for table `category_feature`
--
ALTER TABLE `category_feature`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `feature_id` (`feature_id`);

--
-- Indexes for table `comment`
--
ALTER TABLE `comment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_comment_comment1_idx` (`parent_id`),
  ADD KEY `status` (`status`),
  ADD KEY `owner_params` (`owner_params`(255)),
  ADD KEY `owner_route` (`owner_route`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`),
  ADD KEY `account_id_2` (`account_id`);

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

--
-- Indexes for table `fmessage_locale`
--
ALTER TABLE `fmessage_locale`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `key_UNIQUE` (`locale`),
  ADD KEY `active` (`active`),
  ADD KEY `default` (`default`),
  ADD KEY `locale` (`locale`);

--
-- Indexes for table `fmessage_message`
--
ALTER TABLE `fmessage_message`
  ADD PRIMARY KEY (`id`,`language`);

--
-- Indexes for table `fmessage_sourcemessage`
--
ALTER TABLE `fmessage_sourcemessage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category` (`category`);

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

--
-- Indexes for table `googlemaps_marker`
--
ALTER TABLE `googlemaps_marker`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_googlemaps_marker_googlemaps_map1_idx` (`map_id`);

--
-- Indexes for table `htmlblock`
--
ALTER TABLE `htmlblock`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slug` (`slug`),
  ADD KEY `language` (`language`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `language` (`language`),
  ADD KEY `ispublished` (`status`),
  ADD KEY `slug` (`slug`);

--
-- Indexes for table `menu_item`
--
ALTER TABLE `menu_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_menu_item_menu1_idx` (`menu_id`),
  ADD KEY `fk_menu_item_menu_item1_idx` (`parent_id`),
  ADD KEY `ispublished` (`visible`),
  ADD KEY `language` (`language`);

--
-- Indexes for table `newsletter`
--
ALTER TABLE `newsletter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `newsletter_subscriber`
--
ALTER TABLE `newsletter_subscriber`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_UNIQUE` (`email`);

--
-- Indexes for table `option`
--
ALTER TABLE `option`
  ADD PRIMARY KEY (`key`),
  ADD UNIQUE KEY `key_UNIQUE` (`key`),
  ADD KEY `fk_options_option_group1_idx` (`group`);

--
-- Indexes for table `option_group`
--
ALTER TABLE `option_group`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `page`
--
ALTER TABLE `page`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`,`language`);

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

--
-- Indexes for table `poll_choice`
--
ALTER TABLE `poll_choice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `choice_poll` (`poll_id`);

--
-- Indexes for table `poll_vote`
--
ALTER TABLE `poll_vote`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vote_poll` (`poll_id`),
  ADD KEY `vote_choice` (`choice_id`),
  ADD KEY `vote_user` (`user_id`);

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`user_id`);

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

--
-- Indexes for table `questionnaire_answer`
--
ALTER TABLE `questionnaire_answer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_questionnaire_answer_questionnaire_question1_idx` (`question_id`);

--
-- Indexes for table `questionnaire_question`
--
ALTER TABLE `questionnaire_question`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_questionnaire_question_questionnaire1_idx` (`questionnaire_id`);

--
-- Indexes for table `rights`
--
ALTER TABLE `rights`
  ADD PRIMARY KEY (`itemname`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`id`),
  ADD KEY `language` (`language`);

--
-- Indexes for table `slider_images`
--
ALTER TABLE `slider_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_slider_images_slider_idx` (`slider_id`);

--
-- Indexes for table `tabber`
--
ALTER TABLE `tabber`
  ADD PRIMARY KEY (`id`),
  ADD KEY `language` (`language`);

--
-- Indexes for table `tabber_tab`
--
ALTER TABLE `tabber_tab`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_tab_content_tabber1_idx` (`tabber_id`),
  ADD KEY `order` (`order`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_username` (`username`),
  ADD UNIQUE KEY `user_email` (`email`);

--
-- Indexes for table `widget`
--
ALTER TABLE `widget`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shortcode_UNIQUE` (`shortcode`),
  ADD UNIQUE KEY `class_UNIQUE` (`class`);

--
-- Indexes for table `widget_instance`
--
ALTER TABLE `widget_instance`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_widget_instance_widget1_idx` (`widget_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `album`
--
ALTER TABLE `album`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `album_image`
--
ALTER TABLE `album_image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `article`
--
ALTER TABLE `article`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `article_album`
--
ALTER TABLE `article_album`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `category_feature`
--
ALTER TABLE `category_feature`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fmessage_locale`
--
ALTER TABLE `fmessage_locale`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=660;
--
-- AUTO_INCREMENT for table `fmessage_sourcemessage`
--
ALTER TABLE `fmessage_sourcemessage`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2089;
--
-- AUTO_INCREMENT for table `googlemaps_map`
--
ALTER TABLE `googlemaps_map`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `googlemaps_marker`
--
ALTER TABLE `googlemaps_marker`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `htmlblock`
--
ALTER TABLE `htmlblock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `menu_item`
--
ALTER TABLE `menu_item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;
--
-- AUTO_INCREMENT for table `newsletter`
--
ALTER TABLE `newsletter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `newsletter_subscriber`
--
ALTER TABLE `newsletter_subscriber`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `page`
--
ALTER TABLE `page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `poll`
--
ALTER TABLE `poll`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `poll_choice`
--
ALTER TABLE `poll_choice`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `poll_vote`
--
ALTER TABLE `poll_vote`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `profiles`
--
ALTER TABLE `profiles`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `questionnaire`
--
ALTER TABLE `questionnaire`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `questionnaire_answer`
--
ALTER TABLE `questionnaire_answer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `questionnaire_question`
--
ALTER TABLE `questionnaire_question`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `slider_images`
--
ALTER TABLE `slider_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tabber`
--
ALTER TABLE `tabber`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tabber_tab`
--
ALTER TABLE `tabber_tab`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `widget`
--
ALTER TABLE `widget`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `widget_instance`
--
ALTER TABLE `widget_instance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `album_has_category`
--
ALTER TABLE `album_has_category`
  ADD CONSTRAINT `fk_album_has_category_album1` FOREIGN KEY (`album_id`) REFERENCES `album` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_album_has_category_category1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `album_image`
--
ALTER TABLE `album_image`
  ADD CONSTRAINT `fk_album_image_album1` FOREIGN KEY (`album_id`) REFERENCES `album` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `article`
--
ALTER TABLE `article`
  ADD CONSTRAINT `fk_article_users1` FOREIGN KEY (`create_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_article_users2` FOREIGN KEY (`update_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `article_has_category`
--
ALTER TABLE `article_has_category`
  ADD CONSTRAINT `fk_article_has_category_article1` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_article_has_category_category1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `authassignment`
--
ALTER TABLE `authassignment`
  ADD CONSTRAINT `authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `authitemchild`
--
ALTER TABLE `authitemchild`
  ADD CONSTRAINT `authitemchild_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `authitemchild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `category`
--
ALTER TABLE `category`
  ADD CONSTRAINT `fk_category_category1` FOREIGN KEY (`parent_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE;

--
-- Constraints for table `category_feature`
--
ALTER TABLE `category_feature`
  ADD CONSTRAINT `category_categoryfeature_fk` FOREIGN KEY (`category_id`) REFERENCES `estate_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `feature_categoryfeature_fk` FOREIGN KEY (`feature_id`) REFERENCES `feature` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `comment`
--
ALTER TABLE `comment`
  ADD CONSTRAINT `fk_comment_comment1` FOREIGN KEY (`parent_id`) REFERENCES `comment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `contact`
--
ALTER TABLE `contact`
  ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `fmessage_message`
--
ALTER TABLE `fmessage_message`
  ADD CONSTRAINT `FK_message_fmessage_sourcemessage` FOREIGN KEY (`id`) REFERENCES `fmessage_sourcemessage` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `googlemaps_marker`
--
ALTER TABLE `googlemaps_marker`
  ADD CONSTRAINT `fk_googlemaps_marker_googlemaps_map1` FOREIGN KEY (`map_id`) REFERENCES `googlemaps_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `menu_item`
--
ALTER TABLE `menu_item`
  ADD CONSTRAINT `fk_menu_item_menu1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_menu_item_menu_item1` FOREIGN KEY (`parent_id`) REFERENCES `menu_item` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `option`
--
ALTER TABLE `option`
  ADD CONSTRAINT `fk_options_option_group1` FOREIGN KEY (`group`) REFERENCES `option_group` (`key`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `poll_choice`
--
ALTER TABLE `poll_choice`
  ADD CONSTRAINT `choice_poll` FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `poll_vote`
--
ALTER TABLE `poll_vote`
  ADD CONSTRAINT `vote_choice` FOREIGN KEY (`choice_id`) REFERENCES `poll_choice` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `vote_poll` FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `questionnaire_answer`
--
ALTER TABLE `questionnaire_answer`
  ADD CONSTRAINT `fk_questionnaire_answer_questionnaire_question1` FOREIGN KEY (`question_id`) REFERENCES `questionnaire_question` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `questionnaire_question`
--
ALTER TABLE `questionnaire_question`
  ADD CONSTRAINT `fk_questionnaire_question_questionnaire1` FOREIGN KEY (`questionnaire_id`) REFERENCES `questionnaire` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `rights`
--
ALTER TABLE `rights`
  ADD CONSTRAINT `rights_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `slider_images`
--
ALTER TABLE `slider_images`
  ADD CONSTRAINT `fk_slider_images_slider` FOREIGN KEY (`slider_id`) REFERENCES `slider` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tabber_tab`
--
ALTER TABLE `tabber_tab`
  ADD CONSTRAINT `fk_tab_content_tabber1` FOREIGN KEY (`tabber_id`) REFERENCES `tabber` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `widget_instance`
--
ALTER TABLE `widget_instance`
  ADD CONSTRAINT `fk_widget_instance_widget1` FOREIGN KEY (`widget_id`) REFERENCES `widget` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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