-- phpMyAdmin SQL Dump -- version 3.1.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 06, 2009 at 03:31 PM -- Server version: 5.0.51 -- PHP Version: 5.2.4-2ubuntu5.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `aikidev` -- -- -------------------------------------------------------- -- -- Table structure for table `aiki_config` -- CREATE TABLE IF NOT EXISTS `aiki_config` ( `config_id` int(11) unsigned NOT NULL auto_increment, `config_type` varchar(255) default NULL, `config_scope` varchar(40) default NULL, `config_data` mediumtext, PRIMARY KEY (`config_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Dumping data for table `aiki_config` -- INSERT INTO `aiki_config` (`config_id`, `config_type`, `config_scope`, `config_data`) VALUES (1, 'global_settings', NULL, 'a:9:{s:4:"site";s:7:"aikicms";s:3:"url";s:25:"http://localhost/aikidev/";s:13:"cookie_domain";s:0:"";s:13:"default_chmod";s:4:"0777";s:11:"pretty_urls";s:1:"1";s:16:"default_language";s:7:"english";s:19:"default_time_format";s:9:"d - m - Y";s:8:"site_dir";s:3:"ltr";s:19:"language_short_name";s:2:"en";}'), (2, 'database_settings', NULL, 'a:6:{s:7:"db_type";s:5:"mysql";s:10:"disk_cashe";s:1:"1";s:13:"cache_timeout";s:2:"24";s:9:"cache_dir";s:7:"somedir";s:13:"cache_queries";s:1:"1";s:16:"charset_encoding";s:4:"utf8";}'), (3, 'paths_settings', NULL, 'a:1:{s:10:"top_folder";s:32:"/home/bassel/public_html/aikidev";}'), (4, 'metatags_settings', NULL, 'a:5:{s:10:"site_title";s:11:"[[AikiCms]]";s:13:"dynamic_metas";s:1:"1";s:13:"static_author";s:7:"Aikicms";s:15:"static_keywords";s:0:"";s:18:"static_description";s:0:"";}'), (5, 'feed_settings', NULL, 'a:10:{s:10:"feed_title";s:18:"[[discover_syria]]";s:16:"feed_description";s:0:"";s:9:"feed_link";s:29:"http://www.discover-syria.com";s:13:"feed_language";s:2:"ar";s:16:"feed_image_title";s:14:"Discover Syria";s:14:"feed_image_url";s:41:"images/skins/discover_syria/watermark.png";s:15:"feed_image_link";s:29:"http://www.discover-syria.com";s:16:"feed_image_width";s:3:"144";s:17:"feed_image_height";s:2:"50";s:15:"feed_def_module";s:8:"articles";}'), (6, 'images_settings', NULL, 'a:4:{s:7:"max_res";s:3:"650";s:20:"default_photo_module";s:21:"modules_photo_archive";s:23:"store_native_extensions";s:4:"true";s:13:"new_extension";s:5:".news";}'), (7, 'admin_settings', NULL, 'a:1:{s:17:"show_edit_widgets";s:1:"1";}'); -- -------------------------------------------------------- -- -- Table structure for table `aiki_css` -- CREATE TABLE IF NOT EXISTS `aiki_css` ( `id` int(11) NOT NULL auto_increment, `css_name` varchar(255) NOT NULL, `css_group` varchar(255) NOT NULL, `css_folder` varchar(128) NOT NULL, `style_sheet` text NOT NULL, `is_active` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ; -- -- Dumping data for table `aiki_css` -- INSERT INTO `aiki_css` (`id`, `css_name`, `css_group`, `css_folder`, `style_sheet`, `is_active`) VALUES (1, '.clearfix:after', 'aiki_shared_style', 'aiki_style_fix', 'content: "."; \ndisplay: block;\nclear: both;\nvisibility: hidden;\nline-height: 0;\nheight: 0;', 1), (2, '.clearfix', 'aiki_shared_style', 'aiki_style_fix', 'display: inline-block;', 1), (3, 'html[xmlns] .clearfix', 'aiki_shared_style', 'aiki_style_fix', 'display: block;', 1), (4, '* html .clearfix', 'aiki_shared_style', 'aiki_style_fix', 'height: 1%;', 1), (5, 'th.table-sortable', 'aiki_shared_style', 'toolboxsortable', 'cursor:pointer;\nbackground-image:url("images/skins/shared/sortable.gif");\nbackground-position:center left;\nbackground-repeat:no-repeat;\npadding-left:12px;', 1), (6, 'tr.alternate', 'aiki_shared_style', 'toolboxsortable', 'background-color:#ffffcc;', 1), (7, 'table.toolboxsortable a.currentpage', 'aiki_shared_style', 'toolboxsortable', 'background-color:yellow;', 1), (8, 'table.toolboxsortable a.pagelink', 'aiki_shared_style', 'toolboxsortable', 'padding-left:5px;\r\npadding-right:5px;\r\nborder:1px solid #666666;\r\nmargin:0px 5px 0px 5px;', 1), (9, 'table.toolboxsortable tr.tbody_header', 'aiki_shared_style', 'toolboxsortable', 'font-weight:bold;\r\ntext-align:center;\r\nbackground-color:#dddddd;', 1), (10, 'p', 'aiki_shared_style', '', 'margin-bottom: 0;\r\nmargin-top: 0;\r\nmargin-right: 5px;', 1), (11, 'a:link\r\n', 'aiki_shared_style', '', 'BACKGROUND: none; color: #970f00; TEXT-DECORATION: none', 1), (12, 'a:active', 'aiki_shared_style', '', 'BACKGROUND: none; color:#575656; TEXT-DECORATION: none', 1), (13, 'a:visited', 'aiki_shared_style', '', 'BACKGROUND: none; color: #970f00; TEXT-DECORATION: none', 1), (14, 'a:hover', 'aiki_shared_style', '', 'BACKGROUND: none; color:#575656; TEXT-DECORATION: none underline', 1), (15, '#dhtmltooltip', 'aiki_shared_style', 'dhtmltooltip', 'position: absolute;\r\nwidth: 300px;\r\nborder: 2px solid black;\r\npadding: 2px;\r\nbackground-color: lightyellow;\r\nvisibility: hidden;\r\nz-index: 1000000;\r\n/*Remove below line to remove shadow. Below line should always appear last within this CSS*/\r\n filter: progid : DXImageTransform . Microsoft .\r\n Shadow(color = gray, direction = 135);', 1), (16, 'h1', 'aiki_shared_style', '', 'font-size: 15pt;\nfont-family: arial;\ncolor: #970f00;', 1), (17, 'table.toolboxsortable tfoot td', 'aiki_shared_style', 'toolboxsortable', 'background-color:#ffccff;', 1), (18, 'table.toolboxsortable thead th', 'aiki_shared_style', 'toolboxsortable', 'background-color:#ccccff;', 1), (19, 'table.toolboxsortable th, table.toolboxsortable td', 'aiki_shared_style', 'toolboxsortable', 'border:1px solid #aaaaaa;\r\npadding: 2px 15px 2px 15px;', 1), (20, 'table.toolboxsortable', 'aiki_shared_style', 'toolboxsortable', 'border:1px solid black;\nborder-collapse:collapse;\nbackground-color: #FFFFFF;', 1), (21, '#edit_widget', 'aiki_shared_style', 'admin_panel', 'position: absolute;\r\ntop: 0px;\r\nleft: 0px;\r\ndirection: ltr;\r\noverflow: auto;\r\nwidth: 100%;\r\nheight: 100%;\r\nz-index: 100000;', 1), (22, '#edit_css', 'aiki_shared_style', 'admin_panel', 'position: absolute;\ntop: 0px;\nleft: 0px;\ndirection: ltr;\noverflow: auto;\nwidth: 100%;\nheight: 100%;\nz-index: 10000000;', 1), (23, '#content', 'aiki_shared_style', 'admin_panel', 'overflow: auto;\nwidth: 100%;\nheight: 100%;\ndirection: ltr;\n', 1), (24, '#debug', 'aiki_shared_style', '', 'width: 400px;\r\ntext-align: left;\r\ndirection: ltr;\r\nmargin-left: auto;\r\nmargin-right: auto;', 1), (25, 'table.sortable', 'aiki_shared_style', 'admin_panel', 'border-spacing: 0;\r\nborder: 1px solid #000;\r\nborder-collapse: collapse;', 1), (26, 'table.sortable th, table.sortable td', 'aiki_shared_style', 'admin_panel', 'text-align: left;\r\npadding: 2px 4px 2px 4px;\r\nwidth: 100;\r\nborder-style: solid;\r\nborder-color: #444;', 1), (27, 'table.sortable th', 'aiki_shared_style', 'admin_panel', 'border-width: 0px 1px 1px 1px;\r\nbackground-color: #ccc;', 1), (28, 'table.sortable td', 'aiki_shared_style', 'admin_panel', 'border-width: 0px 1px 0px 1px;', 1), (29, 'table.sortable tr.odd td', 'aiki_shared_style', 'admin_panel', 'background-color: #ddd;', 1), (30, 'table.sortable tr.even td', 'aiki_shared_style', 'admin_panel', 'background-color: #fff;', 1), (31, 'table.sortable tr.sortbottom td', 'aiki_shared_style', 'admin_panel', 'border-top: 1px solid #444;\r\nbackground-color: #ccc;\r\nfont-weight: bold;', 1), (32, 'th.table-sorted-asc', 'aiki_shared_style', 'toolboxsortable', 'background-image:url("images/skins/shared/sorted_up.gif");\nbackground-position:center left;\nbackground-repeat:no-repeat;', 1), (33, 'th.table-sorted-desc', 'aiki_shared_style', 'toolboxsortable', 'background-image:url("images/skins/shared/sorted_down.gif");\nbackground-position:center left;\nbackground-repeat:no-repeat;', 1), (34, 'th.table-filtered', 'aiki_shared_style', 'toolboxsortable', 'background-image:url("images/skins/shared/filter.gif");\nbackground-position:center left;\nbackground-repeat:no-repeat;', 1), (35, 'select.table-autofilter', 'aiki_shared_style', 'toolboxsortable', 'font-size:smaller;', 1), (36, 'table.altstripe tr.alternate2', 'aiki_shared_style', 'toolboxsortable', 'background-color:#ccffff;', 1), (37, '#admin_contents', 'aiki_shared_style', 'admin_panel', 'background-color: #fff;\noverflow: auto;\nwidth: 100%;\nheight: 100%;\ndirection: rtl;\n', 1), (38, '#edit_templates', 'aiki_shared_style', 'admin_panel', '\ndirection: ltr;\noverflow: auto;\nwidth: 100%;\nheight: 100%;\nz-index: 100000;', 1), (39, '#admin_container', 'aiki_shared_style', 'admin_panel', ' ', 1), (40, '.hidden_widget', 'aiki_shared_style', '', 'display:none;', 1), (41, '#black_bar', 'aiki_shared_style', 'admin_panel', 'height: 33px;\nwidth: 100%;\nbackground-color: #000000;\npadding: 0px 10px 0px 0px;\n', 1), (42, '#orange_icons', 'aiki_shared_style', 'admin_panel', 'text-align: center;\nmargin-left: auto;\nmargin-right: auto;\nbackground-color: #f15929;\nwidth: 400px;\nheight: 20px;\n-moz-border-radius-bottomleft: 10px;\n-webkit-border-bottom-left-radiu: 10px;\n-moz-border-radius-bottomright: 10px;\n-webkit-border-bottom-right-radiu: 10px;\n', 1), (43, '#logo_bar', 'aiki_shared_style', 'admin_panel', 'height: 85px;\nwidth: 100%;\nbackground: url("images/skins/admin/logo_bar_bg.gif");\npadding: 0px 10px 0px 0px;\ntext-align:center;\nfloat: right;', 1), (44, '#right_container', 'aiki_shared_style', 'admin_panel', ' ', 1), (45, '#right_menu', 'aiki_shared_style', 'admin_panel', 'direction: ltr;\ntext-align: left;', 1), (46, '#left_container', 'aiki_shared_style', 'admin_panel', ' ', 1), (47, '#nav_bar', 'aiki_shared_style', 'admin_panel', 'background-color: #f15929;', 1), (48, '#content', 'aiki_shared_style', 'admin_panel', 'background-color: #f7f7f7;\nheight: 100%;\n', 1), (49, '#login_form', 'aiki_shared_style', 'admin_panel', '', 1), (50, '#hello_logout', 'aiki_shared_style', 'admin_panel', 'text-align: center;\ndirection: ltr;\nbackground-color: #FFFFFF;\n-moz-border-radius-topleft: 10px;\n-webkit-border-top-left-radiu: 10px;\n-moz-border-radius-topright: 10px;\n-webkit-border-top-right-radiu: 10px;\nwidth: 200px;\nfloat: right;\n', 1), (51, 'h2', 'aiki_shared_style', '', 'font-size: 14pt;\nfont-family: arial;\ncolor: #970f00;\npadding: 5px;\nposition: relative;\nborder-bottom: 1px solid #ff7f00;\nborder-left: 0;\nborder-right: 0;\nborder-top: 0;\ntext-align: right;\nfloat: center;\nwidth: 99%;\nclear: left;\nclear: right;\nz-index: -1000;', 1), (52, 'h3', 'aiki_shared_style', '', 'color: #000000;\n font-size: 12pt;\n font-family: arial;', 1), (53, 'h4', 'aiki_shared_style', '', 'color: #000000;\n font-size: 10pt;\n font-family: Tahoma;', 1), (54, 'h5', 'aiki_shared_style', '', 'color: #000000;\n font-size: 10pt;\n font-family: Tahoma;', 1), (55, 'h6', 'aiki_shared_style', '', 'color: #000000;\n font-size: 10pt;\n font-family: Tahoma;', 1), (56, 'textarea#bigfont', 'aiki_shared_style', '', 'font-size: 16pt;\r\nfont-family: arial;\r\nline-height: 130%; ', 1), (57, '#toc', 'aiki_shared_style', '', 'border: 1px solid #ccc;\nbackground-color: #f9f9f9;\nfont-size: 95%;\ntext-align: right;\noverflow: hidden;\nclear: left;\nclear: right;\npadding: 10px;\nwidth: 40%;', 1), (58, 'p.firstbigletter:first-child:first-letter', 'aiki_shared_style', '', 'font-family: arial;\ndisplay: block;\n float: right;\n font-size: 3em;\n font-style: italic;\n line-height: .7em;\n text-indent: .2em;\n text-shadow: 4px 4px 3px #000;\npadding: 7px 7px 7px 15px;\n width: 1px;\n', 1), (59, 'p.firstbigletter', 'aiki_shared_style', '', ' clear: both;\n margin: 1em;\n', 1), (60, '#edit_java', 'aiki_shared_style', 'admin_panel', 'position: absolute;\r\ntop: 0px;\r\nleft: 0px;\r\ndirection: ltr;\r\noverflow: auto;\r\nwidth: 100%;\r\nheight: 100%;\r\nz-index: 100000;', 1), (61, 'a img', 'aiki_shared_style', '', 'BACKGROUND: none; \nborder:0px;', 1), (62, 'label', 'aiki_shared_style', '', 'line-height:215%;', 1), (63, 'button', 'aiki_shared_style', '', 'line-height:215%;', 1), (64, 'body', 'aiki_shared_style', '', 'font-family: Tahoma;\r\nfont-size: 10pt;\r\nmargin-top: 0;\r\nmargin-left: 0;\r\nmargin-right: 0;\r\nbackground-color: #FFFFFF;', 1), (65, '#container', 'aiki_shared_style', '', 'width: 988px;\r\nmargin-left: auto;\r\nmargin-right: auto;', 1), (66, '.right_container', 'aiki_shared_style', '', 'width: 223px;\r\nheight: 100%;\r\nfloat: right;', 1), (67, '.left_container', 'aiki_shared_style', '', 'width: 755px;\r\nheight: 100%;\r\nfloat: left;', 1); -- -------------------------------------------------------- -- -- Table structure for table `aiki_dictionary` -- CREATE TABLE IF NOT EXISTS `aiki_dictionary` ( `term_id` int(11) NOT NULL auto_increment, `short_term` varchar(255) NOT NULL, `lang_english` text NOT NULL, `lang_arabic` text NOT NULL, `lang_german` text NOT NULL, PRIMARY KEY (`term_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `aiki_dictionary` -- -- -------------------------------------------------------- -- -- Table structure for table `aiki_forms` -- CREATE TABLE IF NOT EXISTS `aiki_forms` ( `id` int(11) NOT NULL auto_increment, `form_method` varchar(5) NOT NULL, `form_action` varchar(255) NOT NULL, `form_name` varchar(255) NOT NULL, `form_array` text NOT NULL, `form_fields` text NOT NULL, `form_query` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- Dumping data for table `aiki_forms` -- INSERT INTO `aiki_forms` (`id`, `form_method`, `form_action`, `form_name`, `form_array`, `form_fields`, `form_query`) VALUES (1, '', '', 'new_user', 'a:16:{s:9:"tablename";s:10:"aiki_users";s:4:"pkey";s:6:"userid";s:10:"send_email";s:315:"[email]|اكتشف سورية |أهلاً بك في اكتشف سورية|شكراً لك يا [full_name]
وأهلاً بك في اكتشف سورية
الرجاء تفعيل الحساب بالضغط على الوصلة:
http://www.discover-syria.com/activate/[randkey]";s:16:"unique_textinput";s:45:"username||true:اسم المستخدم:unique";s:9:"password1";s:47:"password:كلمة المرور:password:md5|md5";s:10:"textinput1";s:39:"full_name||true:الاسم الكامل";s:10:"textinput2";s:20:"country:الدولة";s:13:"staticselect3";s:94:"sex:الجنس:custome:بدون تحديد>بدون تحديد&ذكر>ذكر&أنثى>أنثى";s:10:"textinput4";s:14:"job:العمل";s:13:"static_input1";s:36:"usergroup:الصلاحيات:value:5";s:19:"textinput_if_valid1";s:51:"email||true:البريد الإلكتروني:email";s:19:"textinput_if_valid2";s:46:"homepage:الموقع الإلكتروني:url";s:10:"autofiled1";s:25:"first_ip:الآي بي:ip";s:10:"autofiled2";s:48:"first_login:تاريخ التسجيل:uploaddate";s:13:"staticselect5";s:83:"maillist:الاشتراك بالقائمة البريدية:custome:نعم>1&لا>0";s:10:"rand_value";s:38:"randkey:مفتاح التفعيل:rand";}', '', ''), (2, '', '', 'new_to_bank', 'a:11:{s:9:"tablename";s:18:"dsyria_bank_riched";s:4:"pkey";s:2:"id";s:7:"hidden1";s:47:"original_bank_id:رقم المقال الأصل";s:11:"textinput10";s:26:"name:اسمك الكامل";s:19:"textinput_if_valid1";s:45:"email:البريد الإلكتروني:email";s:10:"textinput1";s:33:"title:عنوان المشاركة";s:16:"normaltextblock1";s:13:"text:النص";s:10:"textinput3";s:52:"source:المصدر ( في حال الاقتباس )";s:10:"autofiled4";s:53:"full_name:تم الإدخال بواسطة:insertedby";s:10:"autofiled5";s:62:"insert_by:تم الإدخال بواسطة:insertedby_username";s:10:"autofiled2";s:48:"insert_date:تاريخ الإدخال:uploaddate";}', '', ''), (3, '', '', 'add_comment', 'a:7:{s:9:"tablename";s:24:"dsyria_articles_comments";s:4:"pkey";s:2:"id";s:7:"hidden2";s:29:"categorie:رقم المقال";s:10:"textinput2";s:17:"username:اسمك";s:10:"textinput4";s:37:"email:بريدك الإلكتروني";s:10:"textinput5";s:20:"country:الدولة";s:14:"aikitextblock1";s:22:"comment:مشاركتك";}', '', ''), (4, '', '', 'opinion', 'a:5:{s:9:"tablename";s:7:"opinoin";s:4:"pkey";s:2:"id";s:10:"textinput2";s:17:"username:اسمك";s:10:"textinput4";s:39:"country:بريدك الإلكتروني";s:14:"aikitextblock1";s:22:"comment:مشاركتك";}', '', ''), (5, '', '', '', 'a:21:{s:9:"tablename";s:20:"dsyria_articles_text";s:4:"pkey";s:2:"id";s:10:"textinput1";s:52:"first_title|employees|true:العنوان الأول";s:10:"textinput2";s:50:"second_title|employees:العنوان الثاني";s:11:"textinput11";s:39:"writers|employees:كتاب المقال";s:10:"selection1";s:82:"categories1|employees:التصنيف الأول:dsyria_articles_categories:id:name";s:10:"selection2";s:84:"categories2|employees:التصنيف الثاني:dsyria_articles_categories:id:name";s:12:"staticselect";s:66:"maintype|employees:نوع المقال:custome:خبر>2&مقال>1";s:16:"normaltextblock5";s:41:"bodytext|employees|true:نص المقال";s:10:"textinput3";s:32:"sources|employees:المصادر";s:10:"textinput4";s:44:"extras|employees:ملاحظات إضافية";s:16:"normaltextblock1";s:52:"keywords|employees:الكلمات المفتاحية";s:11:"textinput22";s:40:"filename|employees:صورة المقال";s:10:"autofiled1";s:56:"publish_date|employees:تاريخ النشر:publishdate";s:10:"autofiled2";s:48:"insert_date:تاريخ الإدخال:uploaddate";s:10:"autofiled3";s:52:"order_by|SystemGOD:ترتيب الإظهار:orderby";s:10:"autofiled4";s:53:"insert_by:تم الإدخال بواسطة:insertedby";s:13:"staticselect2";s:110:"publish_cond|SystemGOD:حالة المقال:custome:عدم النشر>0&مقال مدقق>1&نشر فورا>2";s:13:"staticselect3";s:82:"allow_comments|SystemGOD:السماح بالتعليقات:custome:نعم>1&لا>0";s:10:"autofiled6";s:72:"edit_by:تاريخ التعديلات:EditingHistory:Users&Dates&changes";s:13:"staticselect5";s:61:"is_sticky|SystemGOD:مقال مثبت:custome:نعم>1&لا>0";}', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `aiki_guests` -- CREATE TABLE IF NOT EXISTS `aiki_guests` ( `userid` int(9) unsigned NOT NULL auto_increment, `first_login` datetime NOT NULL, `last_hit` datetime NOT NULL, `last_hit_unix` int(11) NOT NULL, `ip` varchar(40) NOT NULL, `last_ip` varchar(40) NOT NULL, `username` varchar(255) NOT NULL, `guest_session` varchar(255) NOT NULL, `hits` int(11) NOT NULL, `is_online` int(11) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `aiki_guests` -- INSERT INTO `aiki_guests` (`userid`, `first_login`, `last_hit`, `last_hit_unix`, `ip`, `last_ip`, `username`, `guest_session`, `hits`, `is_online`) VALUES (1, '2009-05-05 21:16:56', '2009-05-05 21:20:48', 1241547648, '127.0.0.1', '127.0.0.1', 'guest', '1c6f764381242ebd1b9b75e145581e7', 5, 0), (2, '2009-05-05 23:11:41', '2009-05-05 23:17:30', 1241554650, '127.0.0.1', '127.0.0.1', 'guest', '72b8577f0a35459fb43195e3e9920da', 6, 0), (3, '2009-05-05 23:17:34', '2009-05-05 23:49:10', 1241556550, '127.0.0.1', '127.0.0.1', 'admin', 'bcabf9448eba4da408cf499d7536c86', 135, 1); -- -------------------------------------------------------- -- -- Table structure for table `aiki_javascript` -- CREATE TABLE IF NOT EXISTS `aiki_javascript` ( `id` int(11) NOT NULL auto_increment, `script_name` varchar(255) NOT NULL, `script_group` varchar(128) NOT NULL, `script_folder` varchar(255) NOT NULL, `script` text NOT NULL, `father` int(11) NOT NULL, `global_use` int(1) NOT NULL, `is_active` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=102 ; -- -- Dumping data for table `aiki_javascript` -- INSERT INTO `aiki_javascript` (`id`, `script_name`, `script_group`, `script_folder`, `script`, `father`, `global_use`, `is_active`) VALUES (1, 'jquery', '', 'jQuery', ' \r\n\r\n ', 0, 0, 1), (8, 'ajaxify', '', 'jQuery>ajaxify', '', 1, 0, 1), (9, 'jqueryslidemenu', '', 'jQuery>Dynamic_Drive>jqueryslidemenu', '', 1, 0, 1), (12, 'edit_in_place', '', '', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', 1, 0, 1), (20, 'showHide', '', '', '', 0, 0, 1), (2, 'jquery datepicker', '', 'jquery ui 1.7.1', ' \r\n\r\n\r\n setting[url]/plugins/timeline_2.3.0/styles.css'' type=''text/css'' /> \r\n \r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n ', 0, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `aiki_languages` -- CREATE TABLE IF NOT EXISTS `aiki_languages` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `sys_name` varchar(255) NOT NULL, `short_name` varchar(9) NOT NULL, `dir` varchar(9) NOT NULL, `is_default` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- Dumping data for table `aiki_languages` -- INSERT INTO `aiki_languages` (`id`, `name`, `sys_name`, `short_name`, `dir`, `is_default`) VALUES (1, 'عربي', 'arabic', 'ar', 'rtl', 0), (2, 'English', 'english', 'en', 'ltr', 1), (5, 'German', 'german', 'de', 'ltr', 0); -- -------------------------------------------------------- -- -- Table structure for table `aiki_linker_tags` -- CREATE TABLE IF NOT EXISTS `aiki_linker_tags` ( `name` varchar(250) NOT NULL default '', `tagstart` varchar(250) NOT NULL default '', `tagend` varchar(250) NOT NULL default '', `parlset` varchar(250) NOT NULL default '', `linkexample` varchar(250) NOT NULL default '', `dbtable` varchar(250) NOT NULL default '', `namecolumn` varchar(250) NOT NULL default '', `idcolumn` varchar(250) NOT NULL default '', `extrasql` varchar(255) NOT NULL default '', `is_extrasql_loop` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- -- Dumping data for table `aiki_linker_tags` -- INSERT INTO `aiki_linker_tags` (`name`, `tagstart`, `tagend`, `parlset`, `linkexample`, `dbtable`, `namecolumn`, `idcolumn`, `extrasql`, `is_extrasql_loop`) VALUES ('databank', '(+(', ')+)', 'بنك:', 'bank', 'dsyria_bank_text', 'title', 'id', 'or title_tashkeel LIKE ''[tag_equivalent]''', 0), ('news', '(+(', ')+)', 'خبر:', 'news', 'dsyria_articles_text', 'id', 'id', '', 0); -- -------------------------------------------------------- -- -- Table structure for table `aiki_modifiers` -- CREATE TABLE IF NOT EXISTS `aiki_modifiers` ( `id` int(11) NOT NULL auto_increment, `modifiers_name` varchar(255) NOT NULL, `modifiers_group` varchar(255) NOT NULL, `modifiers_type` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- Dumping data for table `aiki_modifiers` -- INSERT INTO `aiki_modifiers` (`id`, `modifiers_name`, `modifiers_group`, `modifiers_type`) VALUES (1, 'linkTags', 'aiki_defaults', 'output_modifier'), (2, 'doImages', 'aiki_defaults', 'output_modifier'), (10, 'doQuotes', 'wikipedia_markup', 'output_modifier'), (4, 'external_links', 'aiki_defaults', 'output_modifier'), (5, 'getRemotePages', 'aiki_defaults', 'output_modifier'); -- -------------------------------------------------------- -- -- Table structure for table `aiki_modules` -- CREATE TABLE IF NOT EXISTS `aiki_modules` ( `id` int(3) NOT NULL auto_increment, `module_array` text NOT NULL, `module_group` varchar(255) NOT NULL, `module_name` varchar(255) NOT NULL, `display_name` varchar(255) NOT NULL, `module_link` varchar(255) NOT NULL, `keywords_type` int(11) NOT NULL, `allow_insert_multi_records` int(1) NOT NULL, `allow_edit_in_place` int(1) NOT NULL, `alow_edit_multi_records` int(1) NOT NULL, `father_module` int(11) NOT NULL, `is_father` int(1) NOT NULL, `rss` text NOT NULL, `system_module` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- Dumping data for table `aiki_modules` -- INSERT INTO `aiki_modules` (`id`, `module_array`, `module_group`, `module_name`, `display_name`, `module_link`, `keywords_type`, `allow_insert_multi_records`, `allow_edit_in_place`, `alow_edit_multi_records`, `father_module`, `is_father`, `rss`, `system_module`) VALUES (1, '', 'aiki_shared', 'admin', '', 'admin', 0, 0, 0, 0, 0, 0, '0', 0), (2, '', 'aiki_shared', 'home', '', 'home', 0, 0, 0, 0, 0, 0, '0', 0), (3, '', 'system', 'Config', 'Config Editor', 'aiki_config', 0, 0, 0, 0, 0, 0, '0', 1), (4, '', 'system', 'Css', 'Css Editor', 'aiki_css', 0, 0, 0, 0, 0, 0, '0', 1), (5, '', 'system', 'Forms', 'Forms Editor', 'aiki_forms', 0, 0, 0, 0, 0, 0, '0', 1), (6, '', 'system', 'javascript', 'Javascript Editor', 'aiki_javascript', 0, 0, 0, 0, 0, 0, '0', 1), (7, '', 'system', 'Modules', 'Modules Editor', 'aiki_modules', 0, 0, 0, 0, 0, 0, '0', 1), (8, 'a:31:{s:9:"tablename";s:12:"aiki_widgets";s:4:"pkey";s:2:"id";s:10:"textinput1";s:38:"widget_name|SystemGOD||ltr:Widget Name";s:10:"selection1";s:79:"widget_group|SystemGOD||ltr:Widget Group:aiki_sites:site_shortcut:site_shortcut";s:10:"textinput2";s:42:"widget_folder|SystemGOD||ltr:Widget Folder";s:10:"textinput3";s:42:"display_order|SystemGOD||ltr:Display Order";s:10:"textinput4";s:33:"style_id|SystemGOD||ltr:CSS Class";s:13:"staticselect1";s:61:"is_father|SystemGOD||ltr:is father widget?:custome:No>0&Yes>1";s:10:"selection2";s:70:"father_widget|SystemGOD||ltr:Father Widget:aiki_widgets:id:widget_name";s:16:"normaltextblock1";s:43:"father_module|SystemGOD||ltr:Father Modules";s:13:"staticselect2";s:61:"global_use|SystemGOD||ltr:Display Globally:custome:No>0&Yes>1";s:10:"textinput5";s:46:"dis_operators|SystemGOD||ltr:Display Operators";s:10:"textinput6";s:44:"kill_operators|SystemGOD||ltr:Kill Operators";s:16:"normaltextblock2";s:39:"aiki_select|SystemGOD||ltr:SQL statment";s:16:"normaltextblock3";s:48:"if_no_results|SystemGOD||ltr:No results messages";s:13:"bigtextblock1";s:26:"widget|SystemGOD||ltr:HTML";s:16:"normaltextblock4";s:39:"nogui_widget|SystemGOD||ltr:No GUI HTML";s:10:"textinput7";s:50:"display_in_row_of|SystemGOD||ltr:Display in row of";s:10:"textinput8";s:46:"records_in_page|SystemGOD||ltr:Records in page";s:10:"textinput9";s:40:"link_example|SystemGOD||ltr:Link example";s:11:"textinput10";s:46:"operators_order|SystemGOD||ltr:Operators order";s:13:"staticselect5";s:71:"dynamic_pagetitle|SystemGOD||ltr:Dynamic Page title:custome:No>&Yes>yes";s:16:"normaltextblock8";s:35:"pagetitle|SystemGOD||ltr:Page title";s:16:"normaltextblock9";s:48:"output_modifiers|SystemGOD||ltr:Output modifiers";s:13:"staticselect8";s:66:"edit_in_place|SystemGOD||ltr:Allow edit in place:custome:No>&Yes>1";s:14:"staticselect21";s:61:"is_admin|SystemGOD||ltr:require permission:custome:No>0&Yes>1";s:13:"bigtextblock2";s:52:"if_authorized|SystemGOD||ltr:Authorized members html";s:11:"textinput12";s:47:"permissions|SystemGOD||ltr:Targeted users group";s:11:"textinput14";s:49:"widget_cache_timeout|SystemGOD||ltr:cache timeout";s:10:"selection6";s:74:"javascript|SystemGOD||ltr:call a javascript:aiki_javascript:id:script_name";s:14:"staticselect20";s:52:"is_active|SystemGOD||ltr:Activate:custome:No>0&Yes>1";}', 'system', 'Widgets', 'Widgets Editor', 'aiki_widgets', 0, 0, 0, 0, 0, 0, '0', 1); -- -------------------------------------------------------- -- -- Table structure for table `aiki_redirects` -- CREATE TABLE IF NOT EXISTS `aiki_redirects` ( `url` varchar(255) NOT NULL, `redirect` varchar(255) NOT NULL, `hits` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `aiki_redirects` -- INSERT INTO `aiki_redirects` (`url`, `redirect`, `hits`) VALUES ('/aikidev/favicon.ico', '', 3); -- -------------------------------------------------------- -- -- Table structure for table `aiki_sites` -- CREATE TABLE IF NOT EXISTS `aiki_sites` ( `site_id` int(11) NOT NULL auto_increment, `site_name` varchar(255) NOT NULL, `site_shortcut` varchar(255) NOT NULL, `home_module` int(11) NOT NULL, `is_active` int(1) NOT NULL, `if_closed_output` text NOT NULL, PRIMARY KEY (`site_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `aiki_sites` -- INSERT INTO `aiki_sites` (`site_id`, `site_name`, `site_shortcut`, `home_module`, `is_active`, `if_closed_output`) VALUES (1, '', 'aiki_shared', 0, 0, ''), (2, 'AikiCMS', 'aikicms', 2, 1, ''); -- -------------------------------------------------------- -- -- Table structure for table `aiki_synchronization` -- CREATE TABLE IF NOT EXISTS `aiki_synchronization` ( `id` int(11) NOT NULL auto_increment, `table_name` varchar(255) NOT NULL, `record_id` int(11) NOT NULL, `server_id` int(11) NOT NULL, `date_and_time` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `aiki_synchronization` -- -- -------------------------------------------------------- -- -- Table structure for table `aiki_template` -- CREATE TABLE IF NOT EXISTS `aiki_template` ( `id` int(11) NOT NULL auto_increment, `template_name` varchar(255) NOT NULL, `template_input` text NOT NULL, `template_output` text NOT NULL, PRIMARY KEY (`id`), KEY `template_name` (`template_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- Dumping data for table `aiki_template` -- INSERT INTO `aiki_template` (`id`, `template_name`, `template_input`, `template_output`) VALUES (1, 'Coin image box 2 singles', '{{Coin image box 2 singles\n| header =\n| image_left =\n| image_right =\n| caption_left =\n| caption_right =\n| width_left =\n| width_right =\n| footer =\n| position =\n| margin =\n| background =\n}}', '\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
(header)
\n \n \n
(caption_left)(caption_right)
(footer)
'), (3, 'redirect', '{{redirect\r\n| url = http://www.discover-syria.com/results/538}}\r\n', '(#(header:(url))#)\r\n

\r\n المحتوى المطلوب انتقل إلى الرابط التالي:
\r\n(url)
\r\nاذا لم يتم تحويلك تلقائياً خلال 3 ثوان
\r\nالرجاء اضغط هنا\r\n

'), (4, 'Bank Titles', '{{Bank Titles\r\n|title = معلومات عن دمشق\r\n|position = right\r\n|term = دمشق\r\n}}', '
\r\n
\r\n

(title)

\r\n
    \r\n\r\n(@(select id, title from dsyria_bank_text where title RLIKE "(term)"||
  • (+(2)+)
    • )@)\r\n\r\n
\r\n
\r\n
'), (9, 'box', '{{box\r\n| contents =\r\n| position =\r\n}}', '\r\n \r\n \r\n \r\n \r\n \r\n
\r\n (contents)\r\n
'), (11, 'refresh', '{{refresh\r\n| url = http://www.discover-syria.com/results/538}}\r\n', '

\r\n المحتوى المطلوب انتقل إلى الرابط التالي:
\r\n(url)
\r\nاذا لم يتم تحويلك تلقائياً خلال 3 ثوان
\r\nالرجاء اضغط هنا\r\n

\r\n'), (12, 'inline', '{{inline\r\n| id = 538\r\n}}\r\n', '(#(inline:aikicore->setting[url]/mini_articles/news|(id)?noheaders=1&nogui=1)#)'); -- -------------------------------------------------------- -- -- Table structure for table `aiki_users` -- CREATE TABLE IF NOT EXISTS `aiki_users` ( `userid` int(9) unsigned NOT NULL auto_increment, `username` varchar(100) NOT NULL default '', `full_name` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `sex` varchar(25) NOT NULL, `job` varchar(255) NOT NULL, `password` varchar(100) NOT NULL default '', `usergroup` int(10) NOT NULL default '0', `email` varchar(100) NOT NULL default '', `avatar` varchar(255) NOT NULL, `homepage` varchar(100) NOT NULL default '', `first_ip` varchar(40) NOT NULL default '0', `first_login` datetime NOT NULL, `last_login` datetime NOT NULL, `last_ip` varchar(40) NOT NULL, `user_permissions` text NOT NULL, `maillist` int(1) NOT NULL, `logins_number` int(11) NOT NULL, `randkey` varchar(255) NOT NULL, `is_active` int(5) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `aiki_users` -- INSERT INTO `aiki_users` (`userid`, `username`, `full_name`, `country`, `sex`, `job`, `password`, `usergroup`, `email`, `avatar`, `homepage`, `first_ip`, `first_login`, `last_login`, `last_ip`, `user_permissions`, `maillist`, `logins_number`, `randkey`, `is_active`) VALUES (1, 'guest', 'guest', '', '', '', '', 3, '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 0, 0, '', 0), (2, 'admin', 'System admin', '', '', '', 'c3284d0f94606de1fd2af172aba15bf3', 1, '', '', '', '', '0000-00-00 00:00:00', '2009-05-05 23:17:34', '127.0.0.1', '', 0, 2, '', 0); -- -------------------------------------------------------- -- -- Table structure for table `aiki_users_groups` -- CREATE TABLE IF NOT EXISTS `aiki_users_groups` ( `id` int(3) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `group_permissions` varchar(255) NOT NULL, `group_level` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `aiki_users_groups` -- INSERT INTO `aiki_users_groups` (`id`, `name`, `group_permissions`, `group_level`) VALUES (1, 'System Administrators', 'SystemGOD', 1), (2, 'Modules Administrators', 'ModulesGOD', 2), (3, 'Guests', 'ViewPublished', 100), (4, 'Banned users', 'ViewPublished', 101), (5, 'Normal User', 'normal', 4), (6, 'employees', 'employees', 3); -- -------------------------------------------------------- -- -- Table structure for table `aiki_users_sessions` -- CREATE TABLE IF NOT EXISTS `aiki_users_sessions` ( `session_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL, `user_name` varchar(255) NOT NULL, `session_date` datetime NOT NULL, `user_session` varchar(255) NOT NULL, `user_ip` varchar(100) NOT NULL, PRIMARY KEY (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `aiki_users_sessions` -- INSERT INTO `aiki_users_sessions` (`session_id`, `user_id`, `user_name`, `session_date`, `user_session`, `user_ip`) VALUES (2, 2, 'admin', '2009-05-05 23:17:34', 'bcabf9448eba4da408cf499d7536c86', '127.0.0.1'); -- -------------------------------------------------------- -- -- Table structure for table `aiki_widgets` -- CREATE TABLE IF NOT EXISTS `aiki_widgets` ( `id` int(11) NOT NULL auto_increment, `widget_name` varchar(128) NOT NULL, `widget_group` varchar(255) NOT NULL, `widget_folder` varchar(128) NOT NULL, `display_order` int(11) NOT NULL, `style_id` varchar(255) NOT NULL, `is_father` varchar(3) NOT NULL, `father_widget` int(11) NOT NULL, `father_module` varchar(255) NOT NULL, `global_use` int(11) NOT NULL, `dis_operators` varchar(255) NOT NULL, `kill_operators` varchar(255) NOT NULL, `aiki_select` text NOT NULL, `if_no_results` text NOT NULL, `widget` text NOT NULL, `nogui_widget` text NOT NULL, `display_in_row_of` int(11) NOT NULL, `records_in_page` int(11) NOT NULL, `link_example` varchar(255) NOT NULL, `operators_order` varchar(255) NOT NULL, `dynamic_pagetitle` varchar(3) NOT NULL, `pagetitle` text NOT NULL, `output_modifiers` text NOT NULL, `is_admin` tinyint(1) NOT NULL, `if_authorized` text NOT NULL, `permissions` text NOT NULL, `edit_in_place` varchar(3) NOT NULL, `widget_cache_timeout` int(11) NOT NULL, `is_active` int(1) NOT NULL, `javascript` int(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ; -- -- Dumping data for table `aiki_widgets` -- INSERT INTO `aiki_widgets` (`id`, `widget_name`, `widget_group`, `widget_folder`, `display_order`, `style_id`, `is_father`, `father_widget`, `father_module`, `global_use`, `dis_operators`, `kill_operators`, `aiki_select`, `if_no_results`, `widget`, `nogui_widget`, `display_in_row_of`, `records_in_page`, `link_example`, `operators_order`, `dynamic_pagetitle`, `pagetitle`, `output_modifiers`, `is_admin`, `if_authorized`, `permissions`, `edit_in_place`, `widget_cache_timeout`, `is_active`, `javascript`) VALUES (1, 'hello_logout', 'aiki_shared', 'admin', 2, 'hello_logout', '', 11, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, 'Hello %usernname% (logout)', 'employees', '', 0, 1, 0), (2, 'right_menu', 'aiki_shared', 'admin', 0, 'right_menu', '0', 15, '1', 0, '', '', 'select id, module_name, module_link, display_name from aiki_modules where module_array!="" and module_group = ''aikicore->setting[site]'' order by id', '', '', '', 0, 0, '', '', '', '', '', 1, '

((display_name)): (إدخال - تعديل)

', 'employees', '', 0, 1, 0), (3, 'login_form', 'aiki_shared', 'admin', 0, 'login_form', '0', 19, '1', 0, 'noop', '', '', '', '\r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n \r\n
\r\n
', '', 0, 0, '', '', '', 'Administration Panel', '[all]', 1, 'Welcome to aikicms', 'employees', '', 0, 1, 0), (4, 'admin_logout', 'aiki_shared', 'admin', 0, 'admin_contents', '', 19, '1', 0, 'logout', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, 'Bye Bye !!\r\n{#{LogOut}#}', 'employees', '', 0, 1, 0), (5, 'insert_new_record', 'aiki_shared', 'admin', 0, 'admin_contents', '', 19, '1', 0, 'module|*|new', '', '', '', '', '', 0, 0, '', '', '', 'Administration Panel', '[all]', 1, '{#{insert_new_record_to_module}#}', 'employees', '', 0, 1, 0), (6, 'edit_record', 'aiki_shared', 'admin', 0, 'admin_contents', '0', 19, '1', 0, 'module|*|edit', '', '', '', '', '', 0, 0, '', '', '', 'Administration Panel', '', 1, '{#{edit_record_in_module}#}', 'ModulesGOD', '', 0, 1, 0), (7, 'widgets_setup', 'aiki_shared', 'admin', 0, 'admin_contents', '', 19, '1', 0, 'widgets_setup', '', '', '', '', '', 0, 0, '', '', '', 'Widgets setup - Administration Panel', '[all]', 1, '{#{widgets_setup}#}', 'SystemGOD', '', 0, 1, 0), (8, 'edit_css', 'aiki_shared', 'admin', 0, 'edit_css', '', 19, '1', 0, 'edit_css', '', '', '', '', '', 0, 0, '', '', '', 'edit css - Administration Panel', '[all]', 1, '{#{edit_css}#}', 'SystemGOD', '', 0, 1, 12), (9, 'admin_container', 'aiki_shared', 'admin', 1, 'admin_container', '1', 0, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (10, 'header_container', 'aiki_shared', 'admin', 1, 'header_container', '1', 9, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (11, 'black_bar', 'aiki_shared', 'admin', 1, 'black_bar', '1', 10, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (12, 'orange_icons', 'aiki_shared', 'admin', 0, 'orange_icons', '0', 11, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, 'Widgets editor - CSS editor - Modules editor - Configuration editor', 'SystemGOD', '', 0, 1, 0), (13, 'spacer', 'aiki_shared', 'admin', 2, 'spacer', '0', 9, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (14, 'content_container', 'aiki_shared', 'admin', 3, 'content_container', '1', 9, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (15, 'right_container', 'aiki_shared', 'admin', 1, 'right_container', '1', 14, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (16, 'left_container', 'aiki_shared', 'admin', 2, 'left_container', '1', 14, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (17, 'nav_bar', 'aiki_shared', 'admin', 1, 'nav_bar', '0', 16, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (18, 'spacer', 'aiki_shared', 'admin', 2, 'spacer', '0', 16, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (19, 'content', 'aiki_shared', 'admin', 3, 'content', '1', 16, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '', 'SystemGOD', '', 0, 1, 0), (20, 'edit_widget', 'aiki_shared', 'admin', 0, 'edit_widget', '', 19, '1', 0, 'edit_widget', '', '', '', '', '', 0, 0, '', '', '', 'edit widget- Administration Panel', '[all]', 1, '{#{edit_widget}#}', 'SystemGOD', '', 0, 1, 12), (21, 'modules_editor', 'aiki_shared', 'admin', 0, 'modules_editor', '0', 19, '1', 0, 'modules_editor', '', '', '', '', '', 0, 0, '', '', '', 'modules editor - Administration Panel', '[all]', 1, '{#{modules_editor}#}', 'SystemGOD', '', 0, 1, 12), (22, 'not_published', 'aiki_shared', 'admin', 0, 'show_article', '0', 19, '1', 0, 'not_published', '', '', '', '\r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n \r\n
\r\n
', '', 0, 0, '', '', '', 'المقالات غير المنشورة', '[all]', 1, '
\r\n

مراجعة المقالات غير المنشورة

\r\n\r\n
', 'ModulesGOD', '', 0, 1, 0), (23, 'comments', 'aiki_shared', 'admin', 0, 'show_article', '0', 19, '1', 0, 'comments', '', '', '', '\r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n \r\n
\r\n
', '', 0, 0, '', '', '', 'التعليقات غير المنشورة', '[all]', 1, '
\r\n

مراجعة التعليقات

\r\n\r\n
', 'ModulesGOD', '', 0, 1, 0), (24, 'config_editor', 'aiki_shared', 'admin', 0, 'config_editor', '0', 19, '1', 0, 'config_editor', '', '', '', '', '', 0, 0, '', '', '', 'Configuration Editor - Administration Panel', '[all]', 1, '{#{config_editor}#}', 'SystemGOD', '', 0, 1, 12), (25, 'logo_bar', 'aiki_shared', 'admin', 2, 'logo_bar', '0', 10, '1', 0, '', '', '', '', '', '', 0, 0, '', '', '', '', '[all]', 1, '\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n(#(permissions:SystemGOD:Widgets Add - Edit)#)\r\n\r\n
', 'SystemGOD', '', 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `modules_pages` -- CREATE TABLE IF NOT EXISTS `modules_pages` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `text` text NOT NULL, `keyword` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `modules_pages` -- -- -------------------------------------------------------- -- -- Table structure for table `modules_photo_archive` -- CREATE TABLE IF NOT EXISTS `modules_photo_archive` ( `id` int(11) NOT NULL auto_increment, `categorie` int(11) NOT NULL, `mime_type` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `colored_label` varchar(10) NOT NULL, `rating` float NOT NULL, `ratings_num` int(11) NOT NULL, `upload_file_name` varchar(255) NOT NULL, `upload_file_size` varchar(255) NOT NULL, `checksum_sha1` varchar(255) NOT NULL, `checksum_md5` varchar(255) NOT NULL, `width` int(11) NOT NULL, `height` int(11) NOT NULL, `alt_text` varchar(255) NOT NULL, `keywords` text NOT NULL, `date_of_shot` int(11) NOT NULL, `copyright` text NOT NULL, `description` text NOT NULL, `current_owner` varchar(255) NOT NULL, `photographer` varchar(255) NOT NULL, `original_artist_id` int(11) NOT NULL, `original_artist_name` varchar(255) NOT NULL, `original_width` int(11) NOT NULL, `original_height` int(11) NOT NULL, `article_title` varchar(255) NOT NULL, `article_keywords` text NOT NULL, `article_source` varchar(255) NOT NULL, `article_pubdate` int(11) NOT NULL, `article_writer` varchar(255) NOT NULL, `article_id` int(11) NOT NULL, `event` varchar(255) NOT NULL, `event_date` int(11) NOT NULL, `published_by` varchar(255) NOT NULL, `right_term` varchar(255) NOT NULL, `people_in_photo` varchar(255) NOT NULL, `scene` varchar(255) NOT NULL, `full_path` varchar(255) NOT NULL default 'upload/dsyria/', `resolution` varchar(255) NOT NULL, `depth` varchar(255) NOT NULL, `color_space` varchar(255) NOT NULL, `compression` varchar(255) NOT NULL, `source_url` varchar(255) NOT NULL, `source_device` varchar(255) NOT NULL, `exif_data` text NOT NULL, `capture_date` int(11) NOT NULL, `aperture` varchar(255) NOT NULL, `shutter_speed` varchar(255) NOT NULL, `focal_length` varchar(255) NOT NULL, `iso_speed` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `longitude` varchar(255) NOT NULL, `altitude` varchar(255) NOT NULL, `available_sizes` varchar(255) NOT NULL, `watermark` varchar(255) NOT NULL, `no_watermark_under` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `is_missing` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -- Dumping data for table `modules_photo_archive` --