-- ================================================================
-- MemHT Portal -

-- Copyright (C) 2007-2008 by Miltenovik Manojlo
-- http://www.memht.com

-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- (at your opinion) any later version.

-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.

-- You should have received a copy of the GNU General Public License along
-- with this program; if not, see <http://www.gnu.org/licenses/> (GPLv2)
-- or write to the Free Software Foundation, Inc., 51 Franklin Street,
-- Fifth Floor, Boston, MA02110-1301, USA.
-- ================================================================
-- Database structure
-- ================================================================

--
-- Struttura della tabella `memht_admin_notes`
--

CREATE TABLE `memht_admin_notes` (
  `id` int(10) NOT NULL auto_increment,
  `cat` int(10) NOT NULL default '0',
  `nome` varchar(255) NOT NULL default '',
  `testo` text NOT NULL,
  `autore` varchar(30) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_admin_notes_cat`
--

CREATE TABLE `memht_admin_notes_cat` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_admin_tools`
--

CREATE TABLE `memht_admin_tools` (
  `id` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_aggregator`
--

CREATE TABLE `memht_aggregator` (
  `id` int(1) NOT NULL auto_increment,
  `whr` int(1) NOT NULL,
  `argument` int(10) NOT NULL,
  `author` varchar(255) NOT NULL,
  `rssurl` varchar(255) NOT NULL,
  `numfeeds` int(2) NOT NULL default '10',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_argomenti`
--

CREATE TABLE `memht_argomenti` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(255) NOT NULL default '',
  `img` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_articoli`
--

CREATE TABLE `memht_articoli` (
  `id` int(10) NOT NULL auto_increment,
  `argomento` int(10) NOT NULL default '0',
  `nome` varchar(255) NOT NULL default '',
  `descrizione` text NOT NULL,
  `testo` text NOT NULL,
  `autore` varchar(30) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(10) NOT NULL default '0',
  `usecomments` int(1) NOT NULL default '1',
  `language` int(2) NOT NULL default '0',
  `waiting` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `nome` (`nome`,`descrizione`,`testo`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_banned`
--

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

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

--
-- Struttura della tabella `memht_banners_banner`
--

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

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

--
-- Struttura della tabella `memht_banners_clienti`
--

CREATE TABLE `memht_banners_clienti` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(50) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `sito` varchar(255) NOT NULL default '',
  `note` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_banners_posizioni`
--

CREATE TABLE `memht_banners_posizioni` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_blocks`
--

CREATE TABLE `memht_blocks` (
  `id` int(10) NOT NULL auto_increment,
  `titolo` varchar(255) NOT NULL default '',
  `titolo_on` int(1) NOT NULL default '1',
  `tipo` int(1) NOT NULL default '0',
  `zona` int(1) NOT NULL default '0',
  `posizione` int(10) NOT NULL default '0',
  `nomefile` varchar(255) NOT NULL default '',
  `contenuto` text NOT NULL,
  `flag` int(10) NOT NULL default '0',
  `rank` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_blog_categories`
--

CREATE TABLE `memht_blog_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_blog_configuration`
--

CREATE TABLE `memht_blog_configuration` (
  `numposts` int(11) NOT NULL default '15'
) ENGINE=MyISAM;

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

-- 
-- Dump dei dati per la tabella `memht_blog_configuration`
-- 

INSERT INTO `memht_blog_configuration` (`numposts`) VALUES 
(15);

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

--
-- Struttura della tabella `memht_blog_posts`
--

CREATE TABLE `memht_blog_posts` (
  `id` int(11) NOT NULL auto_increment,
  `category` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL,
  `home_text` text NOT NULL,
  `full_text` text NOT NULL,
  `author` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `hits` int(11) NOT NULL default '0',
  `usecomments` int(1) NOT NULL default '1',
  `language` int(2) NOT NULL default '0',
  `waiting` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `title` (`title`),
  FULLTEXT KEY `title_2` (`title`,`home_text`,`full_text`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_censorlist`
--

CREATE TABLE `memht_censorlist` (
  `cens` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`cens`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_comments`
--

CREATE TABLE `memht_comments` (
  `id` int(10) NOT NULL auto_increment,
  `whr` int(1) NOT NULL,
  `wid` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `guest` int(1) NOT NULL default '0',
  `date` datetime NOT NULL,
  `ip` varchar(15) NOT NULL,
  `moderate` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_config`
--

CREATE TABLE `memht_config` (
  `nome` varchar(255) NOT NULL default '',
  `site_url` varchar(255) NOT NULL default '',
  `descrizione` text NOT NULL,
  `metatags` text NOT NULL,
  `footmsg` text NOT NULL,
  `copyright` text NOT NULL,
  `site_open` int(1) NOT NULL default '1',
  `lingua` varchar(255) NOT NULL default '',
  `template` varchar(255) NOT NULL default 'memht',
  `num_news_home` int(10) NOT NULL default '5',
  `num_news_page` int(10) NOT NULL default '20',
  `email` varchar(255) NOT NULL default '',
  `guest_com` int(1) NOT NULL default '0',
  `guest_msgbox` int(1) NOT NULL default '0',
  `guest_download` int(1) NOT NULL default '0',
  `admin_ghosts` int(1) NOT NULL default '1',
  `user_max_lunghezza` int(10) NOT NULL default '20',
  `pass_max_lunghezza` int(10) NOT NULL default '20',
  `defpage` varchar(255) NOT NULL default 'news',
  `timestamp` varchar(30) NOT NULL default '%d/%m/%Y %H:%i',
  `timezone` int(2) NOT NULL default '0',
  `forumattachment` int(1) NOT NULL default '0',
  `forumattachmentfolder` varchar(255) NOT NULL default 'attachment',
  `avatar_max_w` int(10) NOT NULL default '100',
  `avatar_max_h` int(10) NOT NULL default '100',
  `informationbar` int(1) NOT NULL default '0',
  `graphic_check` int(1) NOT NULL default '1',
  `textarea_editor` int(1) NOT NULL default '1',
  `modrewrite` int(1) NOT NULL default '0',
  `searchengineinstat` int(1) NOT NULL default '1',
  `approve_users` int(1) NOT NULL default '0',
  `user_confirm_email` int(1) NOT NULL default '1',
  `ftp_server` varchar(255) NOT NULL,
  `ftp_user` varchar(30) NOT NULL,
  `ftp_pass` varchar(30) NOT NULL,
  `ftp_base` varchar(255) NOT NULL default '/',
  `usecomments` int(1) NOT NULL default '1',
  `moderate_comments` int(1) NOT NULL default '0',
  `moderate_comments_onspam` int(1) NOT NULL default '1',
  `comments_spam_words` text NOT NULL,
  `usecronjobs` int(1) NOT NULL default '0',
  `virtualpages` int(1) NOT NULL default '1',
  `welcome_pm` text NOT NULL,
  `welcome_pm_title` varchar(100) NOT NULL default '',
  `welcome_pm_author` varchar(30) NOT NULL default '',
  `separate_news_bylang` int(11) NOT NULL default '0',
  `offlinemsg` text NOT NULL,
  `mail_usesmtp` int(1) NOT NULL default '0',
  `mail_smtp` varchar(255) NOT NULL,
  `mail_smtpauth` int(1) NOT NULL default '0',
  `mail_smtpuser` varchar(255) NOT NULL,
  `mail_smtppass` varchar(255) NOT NULL,
  PRIMARY KEY  (`nome`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_download`
--

CREATE TABLE `memht_download` (
  `id` int(10) NOT NULL auto_increment,
  `cat` int(10) NOT NULL default '0',
  `nome` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `descrizione` text NOT NULL,
  `autore` varchar(30) NOT NULL default '',
  `demolink` varchar(255) NOT NULL default '',
  `version` varchar(255) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `dimensione` int(10) NOT NULL default '0',
  `visto` int(10) NOT NULL default '0',
  `scaricato` int(10) NOT NULL default '0',
  `flag` int(1) NOT NULL default '0',
  `pgroup` int(10) NOT NULL default '0',
  `usecomments` int(1) NOT NULL default '1',
  `waiting` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `nome` (`nome`,`descrizione`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_download_categorie`
--

CREATE TABLE `memht_download_categorie` (
  `id` int(10) NOT NULL auto_increment,
  `parent` int(10) NOT NULL default '0',
  `nome` varchar(255) NOT NULL default '',
  `descrizione` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_email_nodomain`
--

CREATE TABLE `memht_email_nodomain` (
  `id` int(10) NOT NULL auto_increment,
  `domain` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_faq`
--

CREATE TABLE `memht_faq` (
  `id` int(10) NOT NULL auto_increment,
  `argomento` int(10) NOT NULL default '0',
  `domanda` varchar(255) NOT NULL default '',
  `risposta` text NOT NULL,
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `domanda` (`domanda`,`risposta`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_faq_categorie`
--

CREATE TABLE `memht_faq_categorie` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_forum_categories`
--

CREATE TABLE `memht_forum_categories` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_forum_forums`
--

CREATE TABLE `memht_forum_forums` (
  `id` int(10) NOT NULL auto_increment,
  `parent` int(10) NOT NULL default '0',
  `category` int(10) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `position` int(10) NOT NULL default '0',
  `auth_view` int(1) NOT NULL default '0',
  `auth_read` int(1) NOT NULL default '0',
  `auth_write` int(1) NOT NULL default '1',
  `auth_delete` int(1) NOT NULL default '2',
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_forum_moderation`
--

CREATE TABLE `memht_forum_moderation` (
  `forum` int(10) NOT NULL default '0',
  `groupid` int(10) NOT NULL default '0',
  KEY `forum` (`forum`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_forum_notify`
--

CREATE TABLE `memht_forum_notify` (
  `id` int(10) NOT NULL auto_increment,
  `threadid` int(10) NOT NULL default '0',
  `user` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_forum_posts`
--

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

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

--
-- Struttura della tabella `memht_forum_titles`
--

CREATE TABLE `memht_forum_titles` (
  `min` int(10) NOT NULL default '0',
  `max` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_gallery_categories`
--

CREATE TABLE `memht_gallery_categories` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `imgfile` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `enabled` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_gallery_config`
--

CREATE TABLE `memht_gallery_config` (
  `rows` int(10) NOT NULL default '3',
  `cols` int(10) NOT NULL default '2',
  `cat_max_weight` int(10) NOT NULL default '102400',
  `cat_max_w` int(10) NOT NULL default '100',
  `cat_max_h` int(10) NOT NULL default '100',
  `thumb_max_weight` int(10) NOT NULL default '102400',
  `thumb_max_w` int(10) NOT NULL default '150',
  `thumb_max_h` int(10) NOT NULL default '150',
  `img_max_weight` int(10) NOT NULL default '307200',
  `img_max_w` int(10) NOT NULL default '3200',
  `img_max_h` int(10) NOT NULL default '1280'
) ENGINE=MyISAM;

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

-- 
-- Dump dei dati per la tabella `memht_gallery_config`
-- 

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);

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

--
-- Struttura della tabella `memht_gallery_images`
--

CREATE TABLE `memht_gallery_images` (
  `id` int(10) NOT NULL auto_increment,
  `category` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `imgfile` varchar(255) NOT NULL default '',
  `thumb` varchar(255) NOT NULL default '',
  `attachfile` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `waiting` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `title` (`title`,`description`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_groups`
--

CREATE TABLE `memht_groups` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `type` int(10) NOT NULL default '0',
  `amount` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_groups_blacklist`
--

CREATE TABLE `memht_groups_blacklist` (
  `id` int(10) NOT NULL auto_increment,
  `user` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user` (`user`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_groups_members`
--

CREATE TABLE `memht_groups_members` (
  `id` int(10) NOT NULL auto_increment,
  `groupid` int(10) NOT NULL default '0',
  `user` int(10) NOT NULL,
  `permanent` int(1) NOT NULL default '0',
  `joined` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` int(10) NOT NULL default '0',
  `standby` int(1) NOT NULL default '0',
  `note` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_groups_pages`
--

CREATE TABLE `memht_groups_pages` (
  `id` int(10) NOT NULL auto_increment,
  `groupid` int(10) NOT NULL default '0',
  `page` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_guide`
--

CREATE TABLE `memht_guide` (
  `id` int(10) NOT NULL auto_increment,
  `argomento` int(10) NOT NULL default '0',
  `nome` varchar(255) NOT NULL default '',
  `descrizione` text NOT NULL,
  `testo` text NOT NULL,
  `autore` varchar(30) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(10) NOT NULL default '0',
  `usecomments` int(1) NOT NULL default '1',
  `language` int(2) NOT NULL default '0',
  `waiting` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `nome` (`nome`,`descrizione`,`testo`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_info`
--

CREATE TABLE `memht_info` (
  `version` int(3) NOT NULL
) ENGINE=MyISAM;

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

--
-- Dump dei dati per la tabella `memht_info`
--

INSERT INTO `memht_info` (version) VALUES ('402');

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

--
-- Struttura della tabella `memht_iptocountry`
--

CREATE TABLE `memht_iptocountry` (
  `fromip` bigint(12) NOT NULL default '0',
  `toip` bigint(12) NOT NULL default '0',
  `ccode` char(2) NOT NULL default '',
  `cname` varchar(50) NOT NULL default ''
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_login_flood`
--

CREATE TABLE `memht_login_flood` (
  `ip` varchar(15) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `attempts` int(1) NOT NULL default '0',
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_maintenance`
--

CREATE TABLE `memht_maintenance` (
  `last` datetime NOT NULL default '2000-01-01 00:00:00',
  `maintenance` int(10) NOT NULL default '30',
  `maintenance_mesboxflood` int(10) NOT NULL default '60',
  `maintenance_waitusers` int(10) NOT NULL default '48',
  `maintenance_oldpm` int(10) NOT NULL default '90',
  `maintenance_failedlogin` int(10) NOT NULL default '30',
  `maintenance_standbygroup` int(10) NOT NULL default '90',
  `maintenance_loadtime` int(10) NOT NULL default '24',
  `maintenance_aggregator` datetime NOT NULL default '2000-01-01 00:00:00'
) ENGINE=MyISAM;

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

-- 
-- Dump dei dati per la tabella `memht_maintenance`
-- 

INSERT INTO `memht_maintenance` (`last`, `maintenance`, `maintenance_mesboxflood`, `maintenance_waitusers`, `maintenance_oldpm`, `maintenance_failedlogin`, `maintenance_standbygroup`, `maintenance_loadtime`, `maintenance_aggregator`) VALUES 
('2008-01-05 14:07:43', 30, 60, 48, 90, 30, 90, 24, '2000-01-01 00:00:00');

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

--
-- Struttura della tabella `memht_messagebox`
--

CREATE TABLE `memht_messagebox` (
  `id` int(10) NOT NULL auto_increment,
  `autore` varchar(50) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `testo` text NOT NULL,
  `ip` varchar(15) NOT NULL default '',
  `guest` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_messagebox_flood`
--

CREATE TABLE `memht_messagebox_flood` (
  `ip` varchar(15) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_messaggi`
--

CREATE TABLE `memht_messaggi` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(255) NOT NULL default '',
  `testo` text NOT NULL,
  `autore` varchar(30) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `rank` int(10) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_mylinks`
--

CREATE TABLE `memht_mylinks` (
  `id` int(10) NOT NULL auto_increment,
  `cat` int(10) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_mylinks_cat`
--

CREATE TABLE `memht_mylinks_cat` (
  `id` int(10) NOT NULL auto_increment,
  `parent` int(10) NOT NULL,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_mypage`
--

CREATE TABLE `memht_mypage` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `author` varchar(30) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(10) NOT NULL default '0',
  `public` int(1) NOT NULL default '0',
  `rank` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `title` (`title`),
  FULLTEXT KEY `title_2` (`title`,`text`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_navigator`
--

CREATE TABLE `memht_navigator` (
  `id` int(10) NOT NULL auto_increment,
  `position` int(10) NOT NULL default '0',
  `type` int(10) NOT NULL default '0',
  `content` varchar(255) NOT NULL default '',
  `html` text NOT NULL,
  `icon` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_news`
--

CREATE TABLE `memht_news` (
  `id` int(10) NOT NULL auto_increment,
  `argomento` int(10) NOT NULL default '0',
  `nome` varchar(255) NOT NULL default '',
  `testo_home` text NOT NULL,
  `testo` text NOT NULL,
  `autore` varchar(50) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(10) NOT NULL default '0',
  `usecomments` int(1) NOT NULL default '1',
  `language` varchar(2) NOT NULL default '0',
  `waiting` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `nome` (`nome`,`testo_home`,`testo`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_newsletter`
--

CREATE TABLE `memht_newsletter` (
  `id` int(10) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `sent` int(1) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_newsletter_busy`
--

CREATE TABLE `memht_newsletter_busy` (
  `busy` int(1) NOT NULL default '0',
  `date` datetime NOT NULL
) ENGINE=MyISAM;

INSERT INTO `memht_newsletter_busy` (`busy`,`date`) VALUES ('0', '2001-01-01 00:00:00');

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

--
-- Struttura della tabella `memht_newsletter_config`
--

CREATE TABLE `memht_newsletter_config` (
  `email_mittente` varchar(255) NOT NULL default '',
  `mailorsmtp` int(1) NOT NULL default '0',
  `smtp` varchar(255) NOT NULL default '',
  `useauth` int(1) NOT NULL default '0',
  `smtpuser` varchar(255) NOT NULL default '',
  `smtppass` varchar(255) NOT NULL default '',
  `aut_mailpersession` int(10) NOT NULL default '10',
  `aut_mailpause` int(10) NOT NULL default '1',
  PRIMARY KEY  (`email_mittente`)
) ENGINE=MyISAM;

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

-- 
-- Dump dei dati per la tabella `memht_newsletter_config`
-- 

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

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

--
-- Struttura della tabella `memht_newsletter_sent`
--

CREATE TABLE `memht_newsletter_sent` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `numemails` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_newsletter_status`
--

CREATE TABLE `memht_newsletter_status` (
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `emails` int(10) NOT NULL
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_online`
--

CREATE TABLE `memht_online` (
  `ip` bigint(12) NOT NULL,
  `user` varchar(30) NOT NULL default '',
  `guest` int(1) NOT NULL default '0',
  `mark` int(1) NOT NULL default '0',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_pagine`
--

CREATE TABLE `memht_pagine` (
  `id` int(10) NOT NULL auto_increment,
  `nome` varchar(255) NOT NULL default '',
  `titolo` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `keywords` text NOT NULL,
  `fullscreen` int(1) NOT NULL default '0',
  `rank` int(10) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_partners`
--

CREATE TABLE `memht_partners` (
  `id` int(10) NOT NULL auto_increment,
  `nome_sito` varchar(255) NOT NULL default '',
  `url_sito` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_privs`
--

CREATE TABLE `memht_privs` (
  `userid` int(10) NOT NULL,
  `page` varchar(255) NOT NULL
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_pvtmsg`
--

CREATE TABLE `memht_pvtmsg` (
  `id` int(10) NOT NULL auto_increment,
  `recipient` varchar(30) NOT NULL default '',
  `author` varchar(30) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `smiles` int(1) NOT NULL default '1',
  `new` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_pvtmsg_welcome`
--

CREATE TABLE `memht_pvtmsg_welcome` (
  `title` varchar(255) NOT NULL,
  `text` text NOT NULL
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_ratings`
--

CREATE TABLE `memht_ratings` (
  `id` int(10) NOT NULL auto_increment,
  `whr` int(1) NOT NULL,
  `wid` int(10) NOT NULL,
  `vote` int(10) NOT NULL,
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_rssreader_links`
--

CREATE TABLE `memht_rssreader_links` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `inblock` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_smiles`
--

CREATE TABLE `memht_smiles` (
  `title` varchar(255) NOT NULL default '',
  `img` varchar(255) NOT NULL default '',
  `code` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_spider_ranges`
--

CREATE TABLE `memht_spider_ranges` (
  `id` int(10) NOT NULL auto_increment,
  `spidname` varchar(255) NOT NULL default '',
  `fromip` bigint(12) NOT NULL default '0',
  `toip` bigint(12) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_administration`
--

CREATE TABLE `memht_statistics_administration` (
  `id` int(10) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `admin` varchar(40) NOT NULL,
  `page` varchar(255) NOT NULL default '',
  `agent` varchar(255) NOT NULL default '',
  `referer` varchar(255) NOT NULL default '',
  `requesturi` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_browsers`
--

CREATE TABLE `memht_statistics_browsers` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `browser` varchar(255) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_domains`
--

CREATE TABLE `memht_statistics_domains` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `domain` varchar(30) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_hits`
--

CREATE TABLE `memht_statistics_hits` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `pageviews` int(10) NOT NULL default '0',
  `uniquevisitors` int(10) NOT NULL default '0',
  `spiders` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_ignore`
--

CREATE TABLE `memht_statistics_ignore` (
  `id` int(10) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL default '',
  `user` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_livedata`
--

CREATE TABLE `memht_statistics_livedata` (
  `id` int(10) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `user` varchar(40) NOT NULL default '',
  `page` varchar(255) NOT NULL default '',
  `agent` varchar(255) NOT NULL default '',
  `referer` varchar(255) NOT NULL default '',
  `requesturi` varchar(255) NOT NULL default '',
  `isbot` int(1) NOT NULL default '0',
  `cookies` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_loadtime`
--

CREATE TABLE `memht_statistics_loadtime` (
  `time` varchar(10) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  `started` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`time`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_os`
--

CREATE TABLE `memht_statistics_os` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `os` varchar(255) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_pages`
--

CREATE TABLE `memht_statistics_pages` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `page` varchar(255) NOT NULL default '',

  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_screenres`
--

CREATE TABLE `memht_statistics_screenres` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `screenres` varchar(9) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_searchengines`
--

CREATE TABLE `memht_statistics_searchengines` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `engine` varchar(255) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_searchkeywords`
--

CREATE TABLE `memht_statistics_searchkeywords` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `keyword` varchar(255) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_spiders`
--

CREATE TABLE `memht_statistics_spiders` (
  `lastvisit` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `agent` varchar(255) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_statistics_users`
--

CREATE TABLE `memht_statistics_users` (
  `id` int(10) NOT NULL auto_increment,
  `day` date NOT NULL default '0000-00-00',
  `user` varchar(30) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_survey`
--

CREATE TABLE `memht_survey` (
  `id` int(10) NOT NULL auto_increment,
  `question` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `usecomments` int(1) NOT NULL default '1',
  `enabled` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_survey_data`
--

CREATE TABLE `memht_survey_data` (
  `id` int(10) NOT NULL auto_increment,
  `surveyid` int(10) NOT NULL default '0',
  `answer` varchar(255) NOT NULL default '',
  `votes` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_survey_log`
--

CREATE TABLE `memht_survey_log` (
  `surveyid` int(10) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default ''
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_tags`
--

CREATE TABLE `memht_tags` (
  `tag` varchar(255) NOT NULL default '',
  `cid` int(10) NOT NULL default '0',
  `whr` int(1) NOT NULL default '0'
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_utenti`
--

CREATE TABLE `memht_utenti` (
  `id` int(10) NOT NULL auto_increment,
  `user` varchar(30) NOT NULL default '',
  `pass` varchar(32) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `showemail` int(1) NOT NULL default '1',
  `regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `sito` varchar(255) NOT NULL default '',
  `icq` varchar(255) NOT NULL default '',
  `msn` varchar(255) NOT NULL default '',
  `aol` varchar(255) NOT NULL default '',
  `yahoo` varchar(255) NOT NULL default '',
  `avatar` varchar(255) NOT NULL default 'blank.png',
  `post` int(10) NOT NULL default '0',
  `notify_pvtmsg` int(1) NOT NULL default '1',
  `notify_forum` int(1) NOT NULL default '0',
  `contributes` int(10) NOT NULL default '0',
  `gender` int(1) NOT NULL default '0',
  `title_enabled` int(1) NOT NULL default '0',
  `title_text` varchar(255) NOT NULL default '',
  `signature` text NOT NULL,
  `feed` varchar(255) NOT NULL default 'http://www.memht.com/rss-news.xml',
  `rank` int(1) NOT NULL default '1',
  `lastip` varchar(15) NOT NULL default '',
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `code` varchar(10) NOT NULL default '',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user` (`user`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_utenti_attesa`
--

CREATE TABLE `memht_utenti_attesa` (
  `id` int(10) NOT NULL auto_increment,
  `user` varchar(30) NOT NULL default '',
  `pass` varchar(32) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `newsletter` int(1) NOT NULL default '0',
  `lastip` varchar(15) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  `codice` varchar(10) NOT NULL default '',
  `activated` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_utenti_profile`
--

CREATE TABLE `memht_utenti_profile` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` int(1) NOT NULL,
  `showinforum` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_utenti_profile_data`
--

CREATE TABLE `memht_utenti_profile_data` (
  `id` int(10) NOT NULL auto_increment,
  `uid` int(10) NOT NULL,
  `pid` int(10) NOT NULL,
  `content` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_utenti_vietati`
--

CREATE TABLE `memht_utenti_vietati` (
  `user` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`user`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_virtualpages`
--

CREATE TABLE `memht_virtualpages` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `description` text NOT NULL,
  `keywords` text NOT NULL,
  `version` int(10) NOT NULL default '0',
  `updatefrom` varchar(255) NOT NULL,
  `xmlfile` varchar(255) NOT NULL,
  `fullscreen` int(1) NOT NULL default '0',
  `rank` int(1) NOT NULL default '0',
  `enabled` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

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

--
-- Struttura della tabella `memht_content_languages`
--

CREATE TABLE IF NOT EXISTS `memht_content_languages` (
  `id` int(10) NOT NULL auto_increment,
  `language` varchar(255) NOT NULL,
  `def` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

--
-- Dump dei dati per la tabella `memht_content_languages`
--

INSERT INTO `memht_content_languages` (`id`, `language`, `def`) VALUES
(1, 'Italian', 0),
(2, 'Spanish', 0),
(4, 'French', 0),
(6, 'Portuguese', 0),
(7, 'Russian', 0),
(8, 'Arabic', 0),
(9, 'Turkish', 0),
(10, 'Polish', 0);