# --------------------------------------------------------
# DATABASE DUMP
# Host: sql104.hostwq.net
# Time: 11. May 2008 um 15:58
# Running on: Linux cp1.byetcluster.com. 2.6.18-fza-028stab053.5-686 #1 SMP Sat Mar 1 10:53:11 CET 2008 i686
# MySQL-Version: 5.0.51a-5-log
# PHP-Version: 5.2.5
# Database: `hq_1550805_mk`
# --------------------------------------------------------

#
# Data for table `memht_admin_notes`
#

DROP TABLE IF EXISTS memht_admin_notes;
CREATE TABLE memht_admin_notes (
    id int(10) NOT NULL auto_increment,
    cat int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    testo text NOT NULL,
    autore varchar(30) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_admin_notes (id,cat,nome,testo,autore,data) VALUES ('1','1','غداً  يجب  أن  ...','<div>تكتب مقال  :)</div>','admin','2007-02-07 17:15:00');

#
# Data for table `memht_admin_notes_cat`
#

DROP TABLE IF EXISTS memht_admin_notes_cat;
CREATE TABLE memht_admin_notes_cat (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_admin_notes_cat (id,nome) VALUES ('1','To Do');

#
# Data for table `memht_amministratori`
#

DROP TABLE IF EXISTS memht_amministratori;
CREATE TABLE memht_amministratori (
    id int(10) NOT NULL auto_increment,
    user varchar(30) NOT NULL,
    pass varchar(32) NOT NULL,
    email varchar(255) NOT NULL,
    lastip varchar(15) NOT NULL,
    lastlogin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    superadmin int(1) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_amministratori (id,user,pass,email,lastip,lastlogin,superadmin,enabled) VALUES ('1','casper','bfd59291e825b5f2bbf1eb76569f8fe7','aw50033@hotmail.com','','0000-00-00 00:00:00','1','1');

#
# Data for table `memht_amministratori_privs`
#

DROP TABLE IF EXISTS memht_amministratori_privs;
CREATE TABLE memht_amministratori_privs (
    admin int(1) DEFAULT '0' NOT NULL,
    superadmin int(1) DEFAULT '0' NOT NULL,
    administrators int(1) DEFAULT '0' NOT NULL,
    arguments int(1) DEFAULT '0' NOT NULL,
    articles int(1) DEFAULT '0' NOT NULL,
    banners int(1) DEFAULT '0' NOT NULL,
    blocks int(1) DEFAULT '0' NOT NULL,
    configuration int(1) DEFAULT '0' NOT NULL,
    database_p int(1) DEFAULT '0' NOT NULL,
    download int(1) DEFAULT '0' NOT NULL,
    faq int(1) DEFAULT '0' NOT NULL,
    forum int(1) DEFAULT '0' NOT NULL,
    gallery int(1) DEFAULT '0' NOT NULL,
    groups int(1) DEFAULT '0' NOT NULL,
    guide int(1) DEFAULT '0' NOT NULL,
    imageup int(1) DEFAULT '0' NOT NULL,
    messagebox int(1) DEFAULT '0' NOT NULL,
    messages int(1) DEFAULT '0' NOT NULL,
    mylinks int(1) DEFAULT '0' NOT NULL,
    mypage int(1) DEFAULT '0' NOT NULL,
    news int(1) DEFAULT '0' NOT NULL,
    newsletter int(1) DEFAULT '0' NOT NULL,
    notes int(1) DEFAULT '0' NOT NULL,
    pages int(1) DEFAULT '0' NOT NULL,
    partners int(1) DEFAULT '0' NOT NULL,
    security int(1) DEFAULT '0' NOT NULL,
    statistics int(1) DEFAULT '0' NOT NULL,
    surveys int(1) DEFAULT '0' NOT NULL,
    users int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (admin)
);

INSERT INTO memht_amministratori_privs (admin,superadmin,administrators,arguments,articles,banners,blocks,configuration,database_p,download,faq,forum,gallery,groups,guide,imageup,messagebox,messages,mylinks,mypage,news,newsletter,notes,pages,partners,security,statistics,surveys,users) VALUES ('1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');

#
# Data for table `memht_approve`
#

DROP TABLE IF EXISTS memht_approve;
CREATE TABLE memht_approve (
    id int(10) NOT NULL auto_increment,
    approve int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_approve (id,approve) VALUES ('1','1');

#
# Data for table `memht_argomenti`
#

DROP TABLE IF EXISTS memht_argomenti;
CREATE TABLE memht_argomenti (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    img varchar(255) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_argomenti (id,nome,img) VALUES ('1','مجلة MemHT','memht');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('2','PHP','php');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('3','CSS','css');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('4','Fix','fix');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('5','أخبار','news');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('6','إضافات','addons');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('7','Blocks','blocks');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('8','قوالب','templates');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('9','أكواد','code');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('10','ارشاد','guide');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('11','Javascript','javascript');
INSERT INTO memht_argomenti (id,nome,img) VALUES ('12','حماية','security');

#
# Data for table `memht_articoli`
#

DROP TABLE IF EXISTS memht_articoli;
CREATE TABLE memht_articoli (
    id int(10) NOT NULL auto_increment,
    argomento int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    descrizione text NOT NULL,
    testo text NOT NULL,
    autore varchar(30) NOT NULL,
    email varchar(255) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    tot_votes int(10) DEFAULT '0' NOT NULL,
    num_votes int(10) DEFAULT '0' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY nome (nome, descrizione, testo)
);

INSERT INTO memht_articoli (id,argomento,nome,descrizione,testo,autore,email,data,tot_votes,num_votes,hits,enabled) VALUES ('1','1','مثال على المقال','هذا مثال على وصف المقال.<br />
<strong>عريض</strong>  . <em>مائل </em>.<u> اسفله خط</u> . <strike>يتوسطه خط</strike> . <font color="#ff9900">الالوان</font>','<strong>هذه الصفحة الاولى من المقال<br />
( باستطاعتك تقسيم المقال باستخدام الكود </strong>[-pagebreak -] )<br />
<br />
<strong>عريض </strong>. <em>مائل</em> . <u>اسفله خط</u> . <strike>يتوسطه خط</strike> . <font color="#ff6600">الالوان</font> <br />
[-pagebreak-]<br />
<font color="#800000">هذه الصفحة الثانية من المقال</font>','casper','aw50033@hotmail.com','2007-02-07 16:40:00','0','0','32','1');

#
# Data for table `memht_articoli_commenti`
#

DROP TABLE IF EXISTS memht_articoli_commenti;
CREATE TABLE memht_articoli_commenti (
    id int(10) NOT NULL auto_increment,
    aid int(10) DEFAULT '0' NOT NULL,
    nome varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    testo text NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    ip varchar(15) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_articoli_commenti (id,aid,nome,email,testo,data,ip) VALUES ('2','1','casper','aw50033@hotmail.com','مثال على التعليقات','2007-10-09 19:21:55','127.0.0.1');

#
# Data for table `memht_banned`
#

DROP TABLE IF EXISTS memht_banned;
CREATE TABLE memht_banned (
    id int(10) NOT NULL auto_increment,
    ip bigint(12) DEFAULT '0' NOT NULL,
    fip bigint(12) DEFAULT '0' NOT NULL,
    user varchar(30) NOT NULL,
    range int(1) DEFAULT '0' NOT NULL,
    permanent int(1) DEFAULT '1' NOT NULL,
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    reason text NOT NULL,
    author varchar(30) NOT NULL,
    bandate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_banners_banner`
#

DROP TABLE IF EXISTS memht_banners_banner;
CREATE TABLE memht_banners_banner (
    id int(10) NOT NULL auto_increment,
    cliente int(10) DEFAULT '0' NOT NULL,
    posizione int(10) DEFAULT '0' NOT NULL,
    titolo varchar(255) NOT NULL,
    tipo int(11) DEFAULT '0' NOT NULL,
    contenuto text NOT NULL,
    url varchar(255) NOT NULL,
    dim_x int(10) DEFAULT '0' NOT NULL,
    dim_y int(10) DEFAULT '0' NOT NULL,
    link_click int(1) DEFAULT '0' NOT NULL,
    imp_done int(20) DEFAULT '0' NOT NULL,
    imp_target int(20) DEFAULT '0' NOT NULL,
    click_done int(20) DEFAULT '0' NOT NULL,
    click_target int(20) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_banners_banner (id,cliente,posizione,titolo,tipo,contenuto,url,dim_x,dim_y,link_click,imp_done,imp_target,click_done,click_target,enabled) VALUES ('1','1','4','MemHT Portal','0','banners/memht_110_32_sta_1.gif','http://www.memht.com','110','32','0','9','1000000','0','0','1');

#
# Data for table `memht_banners_clienti`
#

DROP TABLE IF EXISTS memht_banners_clienti;
CREATE TABLE memht_banners_clienti (
    id int(10) NOT NULL auto_increment,
    nome varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    sito varchar(255) NOT NULL,
    note text NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_banners_clienti (id,nome,email,sito,note) VALUES ('1','MemHT.com','webmaster@memht.com','http://www.memht.com','');

#
# Data for table `memht_banners_posizioni`
#

DROP TABLE IF EXISTS memht_banners_posizioni;
CREATE TABLE memht_banners_posizioni (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_banners_posizioni (id,nome) VALUES ('1','رأس الصفحه');
INSERT INTO memht_banners_posizioni (id,nome) VALUES ('2','تذييل الصفحة');
INSERT INTO memht_banners_posizioni (id,nome) VALUES ('3','البلوك الايسر');
INSERT INTO memht_banners_posizioni (id,nome) VALUES ('4','البلوك الايمن');
INSERT INTO memht_banners_posizioni (id,nome) VALUES ('5','صفحة الارشادات');

#
# Data for table `memht_blocks`
#

DROP TABLE IF EXISTS memht_blocks;
CREATE TABLE memht_blocks (
    id int(10) NOT NULL auto_increment,
    titolo varchar(255) NOT NULL,
    titolo_on int(1) DEFAULT '1' NOT NULL,
    tipo int(1) DEFAULT '0' NOT NULL,
    zona int(1) DEFAULT '0' NOT NULL,
    posizione int(10) DEFAULT '0' NOT NULL,
    nomefile varchar(255) NOT NULL,
    contenuto text NOT NULL,
    rank int(1) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('1','القائمة الرئيسية','1','0','0','1','navigator','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('2','المتواجدين','1','0','0','2','online','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('3','بحث','1','0','0','3','search','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('4','إختر اللغة','1','0','0','4','language','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('5','المنتدى','1','0','2','1','forum_main','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('7','أكثر الملفات تحميلاً','1','0','1','1','download_lat_top','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('8','آخر الأخبار','1','0','1','2','news','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('9','الرسائل','1','0','1','3','messages','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('10','مواقع صديقة','1','0','0','5','partners','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('11','اعلانات','1','0','1','4','extra_advertising','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('12','إستفتاء','1','0','1','5','surveys','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('13','مركز التحميل','1','0','2','2','download_main_top','','0','1');
INSERT INTO memht_blocks (id,titolo,titolo_on,tipo,zona,posizione,nomefile,contenuto,rank,enabled) VALUES ('14','الستايلات','1','0','0','6','templates','','0','1');

#
# Data for table `memht_censorlist`
#

DROP TABLE IF EXISTS memht_censorlist;
CREATE TABLE memht_censorlist (
    cens varchar(255) NOT NULL,
    PRIMARY KEY (cens)
);


#
# Data for table `memht_config`
#

DROP TABLE IF EXISTS memht_config;
CREATE TABLE memht_config (
    nome varchar(255) NOT NULL,
    site_url varchar(255) NOT NULL,
    descrizione text NOT NULL,
    metatags text NOT NULL,
    footmsg text NOT NULL,
    copyright text NOT NULL,
    site_open int(1) DEFAULT '1' NOT NULL,
    lingua varchar(255) NOT NULL,
    template varchar(255) DEFAULT 'simple_red' NOT NULL,
    num_news_home int(10) DEFAULT '5' NOT NULL,
    num_news_page int(10) DEFAULT '20' NOT NULL,
    num_news_view_home int(10) DEFAULT '5' NOT NULL,
    num_news_view_page int(10) DEFAULT '0' NOT NULL,
    email varchar(255) NOT NULL,
    guest_com int(1) DEFAULT '0' NOT NULL,
    guest_msgbox int(1) DEFAULT '0' NOT NULL,
    guest_download int(1) DEFAULT '0' NOT NULL,
    admin_ghosts int(1) DEFAULT '1' NOT NULL,
    user_max_lunghezza int(10) DEFAULT '20' NOT NULL,
    pass_max_lunghezza int(10) DEFAULT '20' NOT NULL,
    defpage varchar(255) DEFAULT 'news' NOT NULL,
    timestamp varchar(30) DEFAULT '%d/%m/%Y %H:%i' NOT NULL,
    timezone int(2) DEFAULT '0' NOT NULL,
    forumattachment int(1) DEFAULT '0' NOT NULL,
    forumattachmentfolder varchar(255) DEFAULT 'attachment' NOT NULL,
    avatar_max_w int(10) DEFAULT '100' NOT NULL,
    avatar_max_h int(10) DEFAULT '100' NOT NULL,
    informationbar int(1) DEFAULT '0' NOT NULL,
    graphic_check int(1) DEFAULT '1' NOT NULL,
    textarea_editor int(1) DEFAULT '1' NOT NULL,
    modrewrite int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (nome)
);

INSERT INTO memht_config (nome,site_url,descrizione,metatags,footmsg,copyright,site_open,lingua,template,num_news_home,num_news_page,num_news_view_home,num_news_view_page,email,guest_com,guest_msgbox,guest_download,admin_ghosts,user_max_lunghezza,pass_max_lunghezza,defpage,timestamp,timezone,forumattachment,forumattachmentfolder,avatar_max_w,avatar_max_h,informationbar,graphic_check,textarea_editor,modrewrite) VALUES ('مجلة MemHT','www.afif.hostwq.net/nuk','MemHT Portal is a Free Content Management System featuring an online management of a complete and advanced portal, even for those that don\'t know anything about programming languages.','memht portal free opensource php cms','','','1','english','simple_red','5','20','5','0','aw50033@hotmail.com','0','0','0','1','20','20','news','%d/%m/%Y %H:%i','0','0','attachment','100','100','0','1','1','0');

#
# Data for table `memht_download`
#

DROP TABLE IF EXISTS memht_download;
CREATE TABLE memht_download (
    id int(10) NOT NULL auto_increment,
    cat int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    url varchar(255) NOT NULL,
    descrizione text NOT NULL,
    autore varchar(30) NOT NULL,
    demolink varchar(255) NOT NULL,
    version varchar(255) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    dimensione int(10) DEFAULT '0' NOT NULL,
    visto int(10) DEFAULT '0' NOT NULL,
    scaricato int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY nome (nome, descrizione)
);

INSERT INTO memht_download (id,cat,nome,url,descrizione,autore,demolink,version,data,dimensione,visto,scaricato) VALUES ('1','2','الاصدار الاخير من مجلة    MemHT ','http://www.memht.com/index.php?page=download&op=getFile&id=130','<div>تحميل النسخة مجانا مجرد الانتقال للرابط وتحميلها</div>','casper','http://www.memht.com','3.2','2007-08-04 00:00:00','0','0','0');

#
# Data for table `memht_download_categorie`
#

DROP TABLE IF EXISTS memht_download_categorie;
CREATE TABLE memht_download_categorie (
    id int(10) NOT NULL auto_increment,
    parent int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    descrizione text NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_download_categorie (id,parent,nome,descrizione) VALUES ('1','0','مجلة  MemHT','');
INSERT INTO memht_download_categorie (id,parent,nome,descrizione) VALUES ('2','1','نسخ المجلة','');

#
# Data for table `memht_download_comments`
#

DROP TABLE IF EXISTS memht_download_comments;
CREATE TABLE memht_download_comments (
    id int(10) NOT NULL auto_increment,
    fileid int(10) DEFAULT '0' NOT NULL,
    name varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    text text NOT NULL,
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    ip varchar(15) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_download_waiting`
#

DROP TABLE IF EXISTS memht_download_waiting;
CREATE TABLE memht_download_waiting (
    id int(10) NOT NULL auto_increment,
    cat int(10) DEFAULT '0' NOT NULL,
    name varchar(255) NOT NULL,
    url varchar(255) NOT NULL,
    description text NOT NULL,
    author varchar(30) NOT NULL,
    demolink varchar(255) NOT NULL,
    version varchar(255) NOT NULL,
    email varchar(255) NOT NULL,
    ip varchar(15) NOT NULL,
    size int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_faq`
#

DROP TABLE IF EXISTS memht_faq;
CREATE TABLE memht_faq (
    id int(10) NOT NULL auto_increment,
    argomento int(10) DEFAULT '0' NOT NULL,
    domanda varchar(255) NOT NULL,
    risposta text NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY domanda (domanda, risposta)
);

INSERT INTO memht_faq (id,argomento,domanda,risposta,enabled) VALUES ('1','1','ما هو  نظام ادارة المحتوى ؟','<p><strong>نظم إدارة المحتوى</strong> هي<strong> نظم معلوماتية</strong> تستخدم لأتمتة عملية النشر الإلكتروني، و تسهيل إدارة دورة النشر و التحرير و الإخراج الفني، و ذلك سواء على الشبكات الخاصة إنترانت أو على إنترنت. <strong>يقوم نظام إدارة المحتويات</strong> بعدة مهام منها تمكين التعديل و الإضافة على المحتوى بسهولة، و إضفاء شكل عام على الموقع من خلال استخدام القوالب، و يمكن كذلك من متابعة التغيرات الواقعة على كم معين من المحتوى عبر الزمن خلال دورات التحرير المتعاقبة عن طريق تسجيل التغيرات ما بين الإصدارات المتعاقبة، و كذلك ينظم صلاحيات المستخدمين المختلفين في استخدام إمكاناته المختلفة. و هو في هذا يحجب عن المستخدمين التعقيدات الداخلية المتعلقة بعملية حفظ البيانات، سواء النصوص أو الصور أو الوسائط الأخرى، و يسهل على غير المتخصصين في تقنيات إنترنت إدارة المواقع.<br />
<br />
<em>Wikipedia</em></p>','1');

#
# Data for table `memht_faq_categorie`
#

DROP TABLE IF EXISTS memht_faq_categorie;
CREATE TABLE memht_faq_categorie (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_faq_categorie (id,nome) VALUES ('1','المحتوى');

#
# Data for table `memht_forum_categories`
#

DROP TABLE IF EXISTS memht_forum_categories;
CREATE TABLE memht_forum_categories (
    id int(10) NOT NULL auto_increment,
    name varchar(255) NOT NULL,
    description text NOT NULL,
    position int(11) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_forum_categories (id,name,description,position) VALUES ('1','القسم العام','','1');

#
# Data for table `memht_forum_forums`
#

DROP TABLE IF EXISTS memht_forum_forums;
CREATE TABLE memht_forum_forums (
    id int(10) NOT NULL auto_increment,
    category int(10) DEFAULT '0' NOT NULL,
    name varchar(255) NOT NULL,
    description text NOT NULL,
    position int(10) DEFAULT '0' NOT NULL,
    auth_view int(1) DEFAULT '0' NOT NULL,
    auth_read int(1) DEFAULT '0' NOT NULL,
    auth_write int(1) DEFAULT '1' NOT NULL,
    auth_delete int(1) DEFAULT '2' NOT NULL,
    status int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_forum_forums (id,category,name,description,position,auth_view,auth_read,auth_write,auth_delete,status) VALUES ('1','1','قسم فرعي','','1','0','0','1','2','1');

#
# Data for table `memht_forum_moderation`
#

DROP TABLE IF EXISTS memht_forum_moderation;
CREATE TABLE memht_forum_moderation (
    forum int(10) DEFAULT '0' NOT NULL,
    user varchar(30) NOT NULL,
    KEY forum (forum)
);

INSERT INTO memht_forum_moderation (forum,user) VALUES ('1','casper');

#
# Data for table `memht_forum_notify`
#

DROP TABLE IF EXISTS memht_forum_notify;
CREATE TABLE memht_forum_notify (
    id int(10) NOT NULL auto_increment,
    threadid int(10) DEFAULT '0' NOT NULL,
    user varchar(30) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_forum_posts`
#

DROP TABLE IF EXISTS memht_forum_posts;
CREATE TABLE memht_forum_posts (
    id int(10) NOT NULL auto_increment,
    parent int(10) DEFAULT '0' NOT NULL,
    forum int(10) DEFAULT '0' NOT NULL,
    name varchar(255) NOT NULL,
    text text NOT NULL,
    author varchar(255) NOT NULL,
    email varchar(255) NOT NULL,
    guest int(1) DEFAULT '0' NOT NULL,
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    edited datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    reason text NOT NULL,
    attachment varchar(255) NOT NULL,
    attachmentmime varchar(255) NOT NULL,
    ip varchar(15) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    smiles int(1) DEFAULT '1' NOT NULL,
    status int(1) DEFAULT '1' NOT NULL,
    flag int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY name (name, text)
);

INSERT INTO memht_forum_posts (id,parent,forum,name,text,author,email,guest,date,edited,reason,attachment,attachmentmime,ip,hits,smiles,status,flag) VALUES ('4','0','2','مثال على موضوع في المنتدى','[color=#FF0000]السلام[/color] [u]عليكم  [/u][i]ورحمة  [/i]الله  [b]وبركاته[/b]    :)','casper','','0','2007-10-09 02:06:48','0000-00-00 00:00:00','','','','127.0.0.1','7','1','1','0');

#
# Data for table `memht_forum_titles`
#

DROP TABLE IF EXISTS memht_forum_titles;
CREATE TABLE memht_forum_titles (
    min int(10) DEFAULT '0' NOT NULL,
    max int(10) DEFAULT '0' NOT NULL,
    title varchar(255) NOT NULL,
    PRIMARY KEY (title)
);

INSERT INTO memht_forum_titles (min,max,title) VALUES ('0','10','Just arrived');
INSERT INTO memht_forum_titles (min,max,title) VALUES ('11','100','Junior Member');
INSERT INTO memht_forum_titles (min,max,title) VALUES ('101','500','Senior Member');
INSERT INTO memht_forum_titles (min,max,title) VALUES ('501','1000','Exalted Member');
INSERT INTO memht_forum_titles (min,max,title) VALUES ('1001','1000000','Crazy Member');

#
# Data for table `memht_gallery_categories`
#

DROP TABLE IF EXISTS memht_gallery_categories;
CREATE TABLE memht_gallery_categories (
    id int(10) NOT NULL auto_increment,
    name varchar(255) NOT NULL,
    imgfile varchar(255) NOT NULL,
    description text NOT NULL,
    enabled int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_gallery_config`
#

DROP TABLE IF EXISTS memht_gallery_config;
CREATE TABLE memht_gallery_config (
    rows int(10) DEFAULT '3' NOT NULL,
    cols int(10) DEFAULT '2' NOT NULL,
    cat_max_weight int(10) DEFAULT '102400' NOT NULL,
    cat_max_w int(10) DEFAULT '100' NOT NULL,
    cat_max_h int(10) DEFAULT '100' NOT NULL,
    thumb_max_weight int(10) DEFAULT '102400' NOT NULL,
    thumb_max_w int(10) DEFAULT '150' NOT NULL,
    thumb_max_h int(10) DEFAULT '150' NOT NULL,
    img_max_weight int(10) DEFAULT '307200' NOT NULL,
    img_max_w int(10) DEFAULT '3200' NOT NULL,
    img_max_h int(10) DEFAULT '1280' NOT NULL
);

INSERT INTO memht_gallery_config (rows,cols,cat_max_weight,cat_max_w,cat_max_h,thumb_max_weight,thumb_max_w,thumb_max_h,img_max_weight,img_max_w,img_max_h) VALUES ('3','2','102400','100','100','102400','150','150','307200','3200','1280');

#
# Data for table `memht_gallery_images`
#

DROP TABLE IF EXISTS memht_gallery_images;
CREATE TABLE memht_gallery_images (
    id int(10) NOT NULL auto_increment,
    category int(10) DEFAULT '0' NOT NULL,
    title varchar(255) NOT NULL,
    imgfile varchar(255) NOT NULL,
    thumb varchar(255) NOT NULL,
    attachfile varchar(255) NOT NULL,
    description text NOT NULL,
    downloaded int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY title (title, description)
);


#
# Data for table `memht_groups`
#

DROP TABLE IF EXISTS memht_groups;
CREATE TABLE memht_groups (
    id int(10) NOT NULL auto_increment,
    name varchar(255) NOT NULL,
    type int(10) DEFAULT '0' NOT NULL,
    amount int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_groups_blacklist`
#

DROP TABLE IF EXISTS memht_groups_blacklist;
CREATE TABLE memht_groups_blacklist (
    id int(10) NOT NULL auto_increment,
    user varchar(255) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_groups_members`
#

DROP TABLE IF EXISTS memht_groups_members;
CREATE TABLE memht_groups_members (
    id int(10) NOT NULL auto_increment,
    groupid int(10) DEFAULT '0' NOT NULL,
    user varchar(30) NOT NULL,
    permanent int(1) DEFAULT '0' NOT NULL,
    joined datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    expire datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    type int(10) DEFAULT '0' NOT NULL,
    standby int(1) DEFAULT '0' NOT NULL,
    note text NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_groups_pages`
#

DROP TABLE IF EXISTS memht_groups_pages;
CREATE TABLE memht_groups_pages (
    id int(10) NOT NULL auto_increment,
    groupid int(10) DEFAULT '0' NOT NULL,
    page varchar(255) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_guide`
#

DROP TABLE IF EXISTS memht_guide;
CREATE TABLE memht_guide (
    id int(10) NOT NULL auto_increment,
    argomento int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    descrizione text NOT NULL,
    testo text NOT NULL,
    autore varchar(30) NOT NULL,
    email varchar(255) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    tot_votes int(10) DEFAULT '0' NOT NULL,
    num_votes int(10) DEFAULT '0' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY nome (nome, descrizione, testo)
);

INSERT INTO memht_guide (id,argomento,nome,descrizione,testo,autore,email,data,tot_votes,num_votes,hits,enabled) VALUES ('1','1','مثال على الارشادات','<div>هذا وصف الارشاد</div>','هذه الصفحة الاولى للارشادات<br />
بامكانك استخدام خاصية تعدد الصفحات في الارشادات باستخدم الكود [- pagebreak-]<br />
<br />
<font color="#ffcc00"><font color="#000000"><strong>عريض</strong> . <em>مائل</em> . <u>اسفله خط</u> . <strike>يتوسطه خط</strike> . </font><font color="#ff6600">الالوان</font> </font><br />
[-pagebreak-]<br />
هذه الصفحة الثانية للارشادات','casper','aw50033@hotmail.com','2007-02-07 16:54:00','0','0','8','1');

#
# Data for table `memht_iptocountry`
#

DROP TABLE IF EXISTS memht_iptocountry;
CREATE TABLE memht_iptocountry (
    fromip bigint(12) DEFAULT '0' NOT NULL,
    toip bigint(12) DEFAULT '0' NOT NULL,
    ccode char(2) NOT NULL,
    cname varchar(50) NOT NULL
);


#
# Data for table `memht_login_flood`
#

DROP TABLE IF EXISTS memht_login_flood;
CREATE TABLE memht_login_flood (
    ip varchar(15) NOT NULL,
    time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    attempts int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (ip)
);


#
# Data for table `memht_maintenance`
#

DROP TABLE IF EXISTS memht_maintenance;
CREATE TABLE memht_maintenance (
    last datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    maintenance int(10) DEFAULT '30' NOT NULL,
    maintenance_mesboxflood int(10) DEFAULT '60' NOT NULL,
    maintenance_waitusers int(10) DEFAULT '48' NOT NULL,
    maintenance_oldtrackip int(10) DEFAULT '7' NOT NULL,
    maintenance_oldpm int(10) DEFAULT '90' NOT NULL,
    maintenance_failedlogin int(10) DEFAULT '30' NOT NULL,
    maintenance_standbygroup int(10) DEFAULT '90' NOT NULL,
    maintenance_loadtime int(10) DEFAULT '24' NOT NULL,
    maintenance_referals int(10) DEFAULT '1000' NOT NULL
);


#
# Data for table `memht_messagebox`
#

DROP TABLE IF EXISTS memht_messagebox;
CREATE TABLE memht_messagebox (
    id int(10) NOT NULL auto_increment,
    autore varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    testo text NOT NULL,
    ip varchar(15) NOT NULL,
    guest int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_messagebox (id,autore,email,data,testo,ip,guest) VALUES ('3','admin','admin@admin.com','2007-10-09 23:09:39','مرحبا بكم :)','127.0.0.1','0');

#
# Data for table `memht_messagebox_flood`
#

DROP TABLE IF EXISTS memht_messagebox_flood;
CREATE TABLE memht_messagebox_flood (
    ip varchar(15) NOT NULL,
    time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (ip)
);


#
# Data for table `memht_messaggi`
#

DROP TABLE IF EXISTS memht_messaggi;
CREATE TABLE memht_messaggi (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    testo text NOT NULL,
    autore varchar(30) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    rank int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_messaggi (id,nome,testo,autore,data,rank,enabled) VALUES ('2','مجلة MemHT','<div><a href="http://www.memht.com">مجلة MemHT</a>  هي نظام دارة محتوى متكامل ومجاني بعرض مميز ومتقدم .<br />
حتى واذا كانت ليست لديك الخبرة كافية للبرمجة . <br />
<font color="#800000">هناك الكثير من المميزات</font> :</div>
<ul>
    <li>منتديات</li>
    <li>مركز تحميل ملفات</li>
    <li>برامج</li>
    <li>البوم صور</li>
    <li>اخبار</li>
    <li>نشرة اخبارية</li>
    <li>اسئلة متكررة</li>
    <li>دليل مواقع</li>
    <li>مقالات</li>
    <li>احصائيات</li>
    <li>استفتاءات</li>
    <li>حماية متكاملة</li>
</ul>
والعديد من المميزات استكشفها بنفسك .','casper','2007-02-07 17:54:00','0','1');
INSERT INTO memht_messaggi (id,nome,testo,autore,data,rank,enabled) VALUES ('1','بحوث ونماذج MemHT','<strong>- <a href="http://www.memht.com/faq-argument-11.html">تطوير الاضافات  و البلوكات</a> <br />
- <a href="http://www.memht.com/guide-read-2.html">تطوير القوالب</a> <br />
- <a href="http://www.memht.com/functions-list-2.html">وظائف MemHT حسب الطلب</a><br />
- <a href="http://www.memht.com/download-files-45.html">قوالب مجلة MemHT</a></strong>','casper','2007-05-20 10:47:15','0','1');
INSERT INTO memht_messaggi (id,nome,testo,autore,data,rank,enabled) VALUES ('3','دخول مدير الموقع','<div>المدراء بامكانهم  الدخول من <a href="admin.php">هــــنـــا</a></div>','casper','2007-05-20 11:51:15','0','1');

#
# Data for table `memht_mylinks`
#

DROP TABLE IF EXISTS memht_mylinks;
CREATE TABLE memht_mylinks (
    id int(10) NOT NULL auto_increment,
    cat int(10) DEFAULT '0' NOT NULL,
    name varchar(255) NOT NULL,
    url varchar(255) NOT NULL,
    email varchar(255) NOT NULL,
    description text NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_mylinks (id,cat,name,url,email,description,hits) VALUES ('1','1','مجلة MemHT','http://www.memht.com','webmaster@memht.com','مجلة MemHT -  تدعم لغات جديدة  بلغة PHP  مفتوحة المصدر  . تحتويات على :<br />
دعم كامل للاضافات . البلوكات . قوالب . احصائيات . منتديات . والعديد من لخدمات الجميلة','2');

#
# Data for table `memht_mylinks_cat`
#

DROP TABLE IF EXISTS memht_mylinks_cat;
CREATE TABLE memht_mylinks_cat (
    id int(10) NOT NULL auto_increment,
    name varchar(255) NOT NULL,
    description text NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_mylinks_cat (id,name,description) VALUES ('1','مجموعة مجلة MemHT','');

#
# Data for table `memht_mypage`
#

DROP TABLE IF EXISTS memht_mypage;
CREATE TABLE memht_mypage (
    id int(10) NOT NULL auto_increment,
    title varchar(255) NOT NULL,
    text text NOT NULL,
    author varchar(30) NOT NULL,
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id),
    UNIQUE title (title)
);

INSERT INTO memht_mypage (id,title,text,author,date,hits,enabled) VALUES ('1','هذه صفحتي الشخصية ','<div>بهذه الاضافة يمكن ان تنشيء صفحات خاصة بك</div>','casper','2007-02-07 17:12:00','1','1');

#
# Data for table `memht_navigator`
#

DROP TABLE IF EXISTS memht_navigator;
CREATE TABLE memht_navigator (
    id int(10) NOT NULL auto_increment,
    position int(10) DEFAULT '0' NOT NULL,
    type int(10) DEFAULT '0' NOT NULL,
    content varchar(255) NOT NULL,
    html text NOT NULL,
    icon varchar(255) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('1','1','0','articles','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('2','2','0','contact','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('3','3','0','download','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('4','4','0','faq','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('5','5','0','forum','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('6','6','0','gallery','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('7','7','0','guide','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('8','8','0','mylinks','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('9','9','0','news','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('10','10','0','newsletter','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('11','11','0','partners','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('12','12','0','poisoner','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('13','13','0','pvtmsg','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('14','14','0','rss','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('15','15','0','search','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('16','16','0','sendfile','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('17','17','0','sendnews','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('18','18','0','sitemap','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('19','19','0','staff','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('20','20','0','surveys','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('21','21','0','topics','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('22','22','0','users','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('23','23','2','','','');
INSERT INTO memht_navigator (id,position,type,content,html,icon) VALUES ('24','24','1','http://www.memht.com|مجلة MemHT|_blank','','');

#
# Data for table `memht_news`
#

DROP TABLE IF EXISTS memht_news;
CREATE TABLE memht_news (
    id int(10) NOT NULL auto_increment,
    argomento int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    testo_home text NOT NULL,
    testo text NOT NULL,
    autore varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    FULLTEXT KEY nome (nome, testo_home, testo)
);

INSERT INTO memht_news (id,argomento,nome,testo_home,testo,autore,email,data,hits,enabled) VALUES ('1','1','مرحباً بك في مجلة MemHT','<div>هذا مثال على الاخبار . <font color="#ff0000">هذا النص الذي سيظهر في الصفحة الرئيسية للموقع</font> .</div>','<div>أكتب هنا النص الذي سيظهر بعد الضغط على<font color="#ff0000"> اقراء المزيد</font></div>','casper','aw50033@hotmail.com','2007-02-07 17:13:00','4','1');

#
# Data for table `memht_news_commenti`
#

DROP TABLE IF EXISTS memht_news_commenti;
CREATE TABLE memht_news_commenti (
    id int(10) NOT NULL auto_increment,
    newsid int(10) DEFAULT '0' NOT NULL,
    nome varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    testo text NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    ip varchar(15) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_news_commenti (id,newsid,nome,email,testo,data,ip) VALUES ('3','1','casper','aw50033@hotmail.com','مثال على التعليقات','2007-10-09 22:14:54','127.0.0.1');

#
# Data for table `memht_news_waiting`
#

DROP TABLE IF EXISTS memht_news_waiting;
CREATE TABLE memht_news_waiting (
    id int(10) NOT NULL auto_increment,
    argomento int(10) DEFAULT '0' NOT NULL,
    nome varchar(255) NOT NULL,
    testo_home text NOT NULL,
    testo text NOT NULL,
    autore varchar(50) NOT NULL,
    email varchar(255) NOT NULL,
    ip varchar(15) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_newsletter`
#

DROP TABLE IF EXISTS memht_newsletter;
CREATE TABLE memht_newsletter (
    id int(10) NOT NULL auto_increment,
    email varchar(255) NOT NULL,
    ip varchar(15) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_newsletter_busy`
#

DROP TABLE IF EXISTS memht_newsletter_busy;
CREATE TABLE memht_newsletter_busy (
    busy int(1) DEFAULT '0' NOT NULL,
    time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL
);

INSERT INTO memht_newsletter_busy (busy,time) VALUES ('0','0000-00-00 00:00:00');

#
# Data for table `memht_newsletter_config`
#

DROP TABLE IF EXISTS memht_newsletter_config;
CREATE TABLE memht_newsletter_config (
    email_mittente varchar(255) NOT NULL,
    mailorsmtp int(1) DEFAULT '0' NOT NULL,
    smtp varchar(255) NOT NULL,
    useauth int(1) DEFAULT '0' NOT NULL,
    smtpuser varchar(255) NOT NULL,
    smtppass varchar(255) NOT NULL,
    mailfirstsession int(10) DEFAULT '100' NOT NULL,
    mailpause int(10) DEFAULT '5' NOT NULL,
    aut_mailpersession int(10) DEFAULT '10' NOT NULL,
    aut_mailpause int(10) DEFAULT '1' NOT NULL,
    PRIMARY KEY (email_mittente)
);

INSERT INTO memht_newsletter_config (email_mittente,mailorsmtp,smtp,useauth,smtpuser,smtppass,mailfirstsession,mailpause,aut_mailpersession,aut_mailpause) VALUES ('','0','','0','','','100','5','10','1');

#
# Data for table `memht_newsletter_inviate`
#

DROP TABLE IF EXISTS memht_newsletter_inviate;
CREATE TABLE memht_newsletter_inviate (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    contenuto text NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_newsletter_status`
#

DROP TABLE IF EXISTS memht_newsletter_status;
CREATE TABLE memht_newsletter_status (
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    last_id int(10) DEFAULT '0' NOT NULL,
    name varchar(255) NOT NULL,
    content text NOT NULL,
    first int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (date)
);


#
# Data for table `memht_online`
#

DROP TABLE IF EXISTS memht_online;
CREATE TABLE memht_online (
    ip varchar(15) NOT NULL,
    user varchar(30) NOT NULL,
    guest int(1) DEFAULT '0' NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (ip)
);

INSERT INTO memht_online (ip,user,guest,data) VALUES ('89.5.205.198','Guest','1','2008-02-14 06:01:47');

#
# Data for table `memht_pagine`
#

DROP TABLE IF EXISTS memht_pagine;
CREATE TABLE memht_pagine (
    id int(10) NOT NULL auto_increment,
    nome varchar(255) NOT NULL,
    titolo varchar(255) NOT NULL,
    fullscreen int(1) DEFAULT '0' NOT NULL,
    rank int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('1','articles','المقالات','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('2','banners','الاعلانات','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('3','contact','اتصل بنا','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('4','download','مركز التحميل','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('5','error','خطأ','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('6','faq','الاسئلة المكررة','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('7','forum','المنتدى','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('8','guide','الارشادات','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('9','messages','الرسائل','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('10','mylinks','دليل المواقع','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('11','mypage','الصفحات الداخليه','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('12','news','الاخبار','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('13','newsletter','النشرة الاخبارية','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('14','partners','مواقع صديقة','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('15','pvtmsg','الرسائل الخاصة','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('16','rss','مغذي RSS','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('17','search','بحث','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('18','sendnews','أرسل خبر','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('19','sitemap','خريطة الموقع','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('20','staff','فريق الموقع','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('21','surveys','الاستفتاءات','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('22','topics','المواضيع','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('23','users','لوحة التحكم','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('24','gallery','البوم الصور','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('25','sendfile','أرسل ملف','1','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('26','poisoner','Poisoner','0','0','1');
INSERT INTO memht_pagine (id,nome,titolo,fullscreen,rank,enabled) VALUES ('28','tags','Tags','0','0','1');

#
# Data for table `memht_partners`
#

DROP TABLE IF EXISTS memht_partners;
CREATE TABLE memht_partners (
    id int(10) NOT NULL auto_increment,
    nome_sito varchar(255) NOT NULL,
    url_sito varchar(255) NOT NULL,
    email varchar(255) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_partners (id,nome_sito,url_sito,email) VALUES ('1','MemHT.com Portal','http://www.memht.com','webmaster@memht.com');

#
# Data for table `memht_pvtmsg`
#

DROP TABLE IF EXISTS memht_pvtmsg;
CREATE TABLE memht_pvtmsg (
    id int(10) NOT NULL auto_increment,
    recipient varchar(30) NOT NULL,
    author varchar(30) NOT NULL,
    name varchar(255) NOT NULL,
    text text NOT NULL,
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    smiles int(1) DEFAULT '1' NOT NULL,
    new int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_smiles`
#

DROP TABLE IF EXISTS memht_smiles;
CREATE TABLE memht_smiles (
    title varchar(255) NOT NULL,
    img varchar(255) NOT NULL,
    code varchar(255) NOT NULL,
    PRIMARY KEY (title)
);

INSERT INTO memht_smiles (title,img,code) VALUES ('Smile','smile_smile.gif',':)');
INSERT INTO memht_smiles (title,img,code) VALUES ('BigGrin','smile_biggrin.gif',':D');
INSERT INTO memht_smiles (title,img,code) VALUES ('Sad','smile_sad.gif',':(');
INSERT INTO memht_smiles (title,img,code) VALUES ('Wink','smile_wink.gif',';)');
INSERT INTO memht_smiles (title,img,code) VALUES ('Razz','smile_razz.gif',':P');
INSERT INTO memht_smiles (title,img,code) VALUES ('Evil','smile_evil.gif',':evil:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Surprised','smile_eek.gif','O_O');
INSERT INTO memht_smiles (title,img,code) VALUES ('Ops','smile_redface.gif',':ops:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Boss','smile_boss.gif',':boss:');
INSERT INTO memht_smiles (title,img,code) VALUES (':|','smile_wtf.gif',':|');
INSERT INTO memht_smiles (title,img,code) VALUES ('InLove','smile_inlove.gif',':inlove:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Kiss','smile_kiss.gif',':kiss:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Nerd','smile_nerd.gif',':nerd:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Angry','smile_angry.gif',':angry:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Bad','smile_bad.gif',':bad:');
INSERT INTO memht_smiles (title,img,code) VALUES ('NoComment','smile_nocomment.gif',':nc:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Sick','smile_sick.gif',':sick:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Uhm','smile_uhm.gif',':uhm:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Ciao','word_ciao.gif',':ciao:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Hello','word_hello.gif',':hello:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Hi','word_hi.gif',':hi:');
INSERT INTO memht_smiles (title,img,code) VALUES ('help','word_help.gif',':help:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Code','word_code.gif',':code:');
INSERT INTO memht_smiles (title,img,code) VALUES ('Quote','word_quote.gif',':quote:');

#
# Data for table `memht_sondaggi`
#

DROP TABLE IF EXISTS memht_sondaggi;
CREATE TABLE memht_sondaggi (
    id int(1) NOT NULL auto_increment,
    titolo varchar(255) NOT NULL,
    campo_1 varchar(255) NOT NULL,
    voti_1 int(10) DEFAULT '0' NOT NULL,
    campo_2 varchar(255) NOT NULL,
    voti_2 int(10) DEFAULT '0' NOT NULL,
    campo_3 varchar(255) NOT NULL,
    voti_3 int(10) DEFAULT '0' NOT NULL,
    campo_4 varchar(255) NOT NULL,
    voti_4 int(10) DEFAULT '0' NOT NULL,
    campo_5 varchar(255) NOT NULL,
    voti_5 int(10) DEFAULT '0' NOT NULL,
    campo_6 varchar(255) NOT NULL,
    voti_6 int(10) DEFAULT '0' NOT NULL,
    campo_7 varchar(255) NOT NULL,
    voti_7 mediumint(10) DEFAULT '0' NOT NULL,
    campo_8 varchar(255) NOT NULL,
    voti_8 int(10) DEFAULT '0' NOT NULL,
    campo_9 varchar(255) NOT NULL,
    voti_9 int(10) DEFAULT '0' NOT NULL,
    campo_10 varchar(255) NOT NULL,
    voti_10 int(10) DEFAULT '0' NOT NULL,
    enabled int(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_sondaggi (id,titolo,campo_1,voti_1,campo_2,voti_2,campo_3,voti_3,campo_4,voti_4,campo_5,voti_5,campo_6,voti_6,campo_7,voti_7,campo_8,voti_8,campo_9,voti_9,campo_10,voti_10,enabled) VALUES ('1','ما رأيك في هذه المجلة ؟','ممتازة','0','متوسطة','0','غير جيدة','0','صعب التعامل معها ','0','لا تعجبني','0','','0','','0','','0','','0','','0','1');

#
# Data for table `memht_spider_ranges`
#

DROP TABLE IF EXISTS memht_spider_ranges;
CREATE TABLE memht_spider_ranges (
    id int(10) NOT NULL auto_increment,
    spidname varchar(255) NOT NULL,
    fromip bigint(12) DEFAULT '0' NOT NULL,
    toip bigint(12) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('1','Google','64233160000','64233191255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('2','Google','66249064000','66249095255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('3','MSN','207046000255','207046255255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('4','Google','72014192000','72014255255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('5','MSN','65052000000','65055255255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('6','MSN','64004000000','64004063255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('7','Yahoo','68142192000','68142255255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('8','Yahoo','72030000000','72030255255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('9','Yahoo','74006000000','74006255255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('10','Yahoo','66228160000','66228191255');
INSERT INTO memht_spider_ranges (id,spidname,fromip,toip) VALUES ('11','Archive.org','208070024255','208070031255');

#
# Data for table `memht_statistiche_browsers`
#

DROP TABLE IF EXISTS memht_statistiche_browsers;
CREATE TABLE memht_statistiche_browsers (
    browser varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (browser)
);

INSERT INTO memht_statistiche_browsers (browser,hits) VALUES ('MSIE 7.0','7');

#
# Data for table `memht_statistiche_date`
#

DROP TABLE IF EXISTS memht_statistiche_date;
CREATE TABLE memht_statistiche_date (
    id int(10) NOT NULL auto_increment,
    anno int(4) DEFAULT '0' NOT NULL,
    mese int(2) DEFAULT '0' NOT NULL,
    giorno int(2) DEFAULT '0' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO memht_statistiche_date (id,anno,mese,giorno,hits) VALUES ('1','2008','2','14','7');

#
# Data for table `memht_statistiche_domains`
#

DROP TABLE IF EXISTS memht_statistiche_domains;
CREATE TABLE memht_statistiche_domains (
    domain varchar(10) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (domain)
);

INSERT INTO memht_statistiche_domains (domain,hits) VALUES ('00','7');

#
# Data for table `memht_statistiche_hour`
#

DROP TABLE IF EXISTS memht_statistiche_hour;
CREATE TABLE memht_statistiche_hour (
    ora int(2) DEFAULT '0' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (ora)
);

INSERT INTO memht_statistiche_hour (ora,hits) VALUES ('5','6');
INSERT INTO memht_statistiche_hour (ora,hits) VALUES ('6','1');

#
# Data for table `memht_statistiche_ignora`
#

DROP TABLE IF EXISTS memht_statistiche_ignora;
CREATE TABLE memht_statistiche_ignora (
    id int(10) NOT NULL auto_increment,
    ip varchar(15) NOT NULL,
    user varchar(30) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_statistiche_iptrack`
#

DROP TABLE IF EXISTS memht_statistiche_iptrack;
CREATE TABLE memht_statistiche_iptrack (
    ip varchar(15) NOT NULL,
    last_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    last_browser varchar(255) NOT NULL,
    last_os varchar(255) NOT NULL,
    last_page varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (ip)
);

INSERT INTO memht_statistiche_iptrack (ip,last_date,last_browser,last_os,last_page,hits) VALUES ('212.71.37.75','2008-02-14 05:38:18','MSIE 7.0','Windows XP','','2');
INSERT INTO memht_statistiche_iptrack (ip,last_date,last_browser,last_os,last_page,hits) VALUES ('89.5.205.198','2008-02-14 06:01:47','MSIE 7.0','Windows XP','','5');

#
# Data for table `memht_statistiche_loadtime`
#

DROP TABLE IF EXISTS memht_statistiche_loadtime;
CREATE TABLE memht_statistiche_loadtime (
    time varchar(10) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    started datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    PRIMARY KEY (time)
);


#
# Data for table `memht_statistiche_os`
#

DROP TABLE IF EXISTS memht_statistiche_os;
CREATE TABLE memht_statistiche_os (
    os varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (os)
);

INSERT INTO memht_statistiche_os (os,hits) VALUES ('Windows XP','7');

#
# Data for table `memht_statistiche_pages`
#

DROP TABLE IF EXISTS memht_statistiche_pages;
CREATE TABLE memht_statistiche_pages (
    page varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (page)
);


#
# Data for table `memht_statistiche_ref`
#

DROP TABLE IF EXISTS memht_statistiche_ref;
CREATE TABLE memht_statistiche_ref (
    id int(10) NOT NULL auto_increment,
    sito varchar(255) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_statistiche_ref_host`
#

DROP TABLE IF EXISTS memht_statistiche_ref_host;
CREATE TABLE memht_statistiche_ref_host (
    id int(10) NOT NULL auto_increment,
    host varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_statistiche_res`
#

DROP TABLE IF EXISTS memht_statistiche_res;
CREATE TABLE memht_statistiche_res (
    res varchar(9) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (res)
);


#
# Data for table `memht_statistiche_searchengines`
#

DROP TABLE IF EXISTS memht_statistiche_searchengines;
CREATE TABLE memht_statistiche_searchengines (
    engine varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (engine)
);


#
# Data for table `memht_statistiche_unique`
#

DROP TABLE IF EXISTS memht_statistiche_unique;
CREATE TABLE memht_statistiche_unique (
    id int(10) NOT NULL auto_increment,
    anno int(4) DEFAULT '0' NOT NULL,
    mese int(2) DEFAULT '0' NOT NULL,
    giorno int(2) DEFAULT '0' NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    KEY hits (hits)
);

INSERT INTO memht_statistiche_unique (id,anno,mese,giorno,hits) VALUES ('1','2008','2','14','2');

#
# Data for table `memht_statistiche_users`
#

DROP TABLE IF EXISTS memht_statistiche_users;
CREATE TABLE memht_statistiche_users (
    user varchar(30) NOT NULL,
    last_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    last_browser varchar(255) NOT NULL,
    last_os varchar(255) NOT NULL,
    last_page varchar(255) NOT NULL,
    hits int(10) DEFAULT '0' NOT NULL,
    PRIMARY KEY (user)
);

INSERT INTO memht_statistiche_users (user,last_date,last_browser,last_os,last_page,hits) VALUES ('Guest','2008-02-14 06:01:47','MSIE 7.0','Windows XP','home','7');

#
# Data for table `memht_tags`
#

DROP TABLE IF EXISTS memht_tags;
CREATE TABLE memht_tags (
    tag varchar(255) NOT NULL,
    cid int(10) DEFAULT '0' NOT NULL,
    whr int(1) DEFAULT '0' NOT NULL
);


#
# Data for table `memht_utenti`
#

DROP TABLE IF EXISTS memht_utenti;
CREATE TABLE memht_utenti (
    id int(10) NOT NULL auto_increment,
    user varchar(30) NOT NULL,
    pass varchar(32) NOT NULL,
    email varchar(255) NOT NULL,
    regdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    sito varchar(255) NOT NULL,
    icq varchar(255) NOT NULL,
    msn varchar(255) NOT NULL,
    aol varchar(255) NOT NULL,
    yahoo varchar(255) NOT NULL,
    avatar varchar(255) DEFAULT 'blank.png' NOT NULL,
    post int(10) DEFAULT '0' NOT NULL,
    notify_pvtmsg int(1) DEFAULT '1' NOT NULL,
    notify_forum int(1) DEFAULT '0' NOT NULL,
    contributes int(10) DEFAULT '0' NOT NULL,
    gender int(1) DEFAULT '0' NOT NULL,
    title_enabled int(1) DEFAULT '0' NOT NULL,
    title_text varchar(255) NOT NULL,
    signature text NOT NULL,
    lastip varchar(15) NOT NULL,
    lastlogin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    code varchar(10) NOT NULL,
    enabled int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id),
    UNIQUE user (user),
    UNIQUE email (email)
);

INSERT INTO memht_utenti (id,user,pass,email,regdate,sito,icq,msn,aol,yahoo,avatar,post,notify_pvtmsg,notify_forum,contributes,gender,title_enabled,title_text,signature,lastip,lastlogin,code,enabled) VALUES ('1','casper','bfd59291e825b5f2bbf1eb76569f8fe7','aw50033@hotmail.com','2008-02-14 05:31:31','','','','','','blank.png','1','1','0','0','0','1','Administrator','','','0000-00-00 00:00:00','','1');

#
# Data for table `memht_utenti_attesa`
#

DROP TABLE IF EXISTS memht_utenti_attesa;
CREATE TABLE memht_utenti_attesa (
    id int(10) NOT NULL auto_increment,
    user varchar(30) NOT NULL,
    pass varchar(32) NOT NULL,
    email varchar(255) NOT NULL,
    newsletter int(1) DEFAULT '0' NOT NULL,
    lastip varchar(15) NOT NULL,
    data datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    codice varchar(10) NOT NULL,
    approve int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `memht_utenti_vietati`
#

DROP TABLE IF EXISTS memht_utenti_vietati;
CREATE TABLE memht_utenti_vietati (
    user varchar(30) NOT NULL,
    PRIMARY KEY (user)
);