Salve a tutti.
Ragazzi sto installando joomla su altervista, senza successo.
la pagina di preinstallazione mi segnala 2 voci in rosso.
la prima e': session server path /tmp_r, non scrivibile
la seconda e':register global on anziche' off.
proseguo ignorandoli, come ho letto su altri topic, ma al passo 3 si blocca dicendomi :attenzione e' avvenuto un errore durante l' inserimento dei dati nel database! impossibile continuare.
vi ringrazio in anticipo dell'aiuto che spero mi darete,
Grazie.
Se puo' esservi d'aiuto di seguito incollo il log di errore.
[code]SQL=Table \'jos_banner\' already exists SQL=# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $
\n
\n# Table structure for table `jos_banner`
\n
\nCREATE TABLE `jos_banner` (
\n `bid` int(11) NOT NULL auto_increment,
\n `cid` int(11) NOT NULL default \'0\',
\n `type` varchar(10) NOT NULL default \'banner\',
\n `name` varchar(50) NOT NULL default \'\',
\n `imptotal` int(11) NOT NULL default \'0\',
\n `impmade` int(11) NOT NULL default \'0\',
\n `clicks` int(11) NOT NULL default \'0\',
\n `imageurl` varchar(100) NOT NULL default \'\',
\n `clickurl` varchar(200) NOT NULL default \'\',
\n `date` datetime default NULL,
\n `showBanner` tinyint(1) NOT NULL default \'0\',
\n `checked_out` tinyint(1) NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `editor` varchar(50) default NULL,
\n `custombannercode` text,
\n PRIMARY KEY (`bid`),
\n KEY `viewbanner` (`showBanner`)
\n) TYPE=InnoDB AUTO_INCREMENT=1:
- - - - - - - - - -
# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $
# Table structure for table `#__banner`
CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM AUTO_INCREMENT=1
= = = = = = = = = =
SQL=Table \'jos_bannerclient\' already exists SQL=# Table structure for table `jos_bannerclient`
\n
\nCREATE TABLE `jos_bannerclient` (
\n `cid` int(11) NOT NULL auto_increment,
\n `name` varchar(60) NOT NULL default \'\',
\n `contact` varchar(60) NOT NULL default \'\',
\n `email` varchar(60) NOT NULL default \'\',
\n `extrainfo` text NOT NULL,
\n `checked_out` tinyint(1) NOT NULL default \'0\',
\n `checked_out_time` time default NULL,
\n `editor` varchar(50) default NULL,
\n PRIMARY KEY (`cid`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerclient`
CREATE TABLE `#__bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_bannerfinish\' already exists SQL=# Table structure for table `jos_bannerfinish`
\n
\nCREATE TABLE `jos_bannerfinish` (
\n `bid` int(11) NOT NULL auto_increment,
\n `cid` int(11) NOT NULL default \'0\',
\n `type` varchar(10) NOT NULL default \'\',
\n `name` varchar(50) NOT NULL default \'\',
\n `impressions` int(11) NOT NULL default \'0\',
\n `clicks` int(11) NOT NULL default \'0\',
\n `imageurl` varchar(50) NOT NULL default \'\',
\n `datestart` datetime default NULL,
\n `dateend` datetime default NULL,
\n PRIMARY KEY (`bid`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerfinish`
CREATE TABLE `#__bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_categories\' already exists SQL=# Table structure for table `jos_categories`
\n
\nCREATE TABLE `jos_categories` (
\n `id` int(11) NOT NULL auto_increment,
\n `parent_id` int(11) NOT NULL default 0,
\n `title` varchar(50) NOT NULL default \'\',
\n `name` varchar(255) NOT NULL default \'\',
\n `image` varchar(100) NOT NULL default \'\',
\n `section` varchar(50) NOT NULL default \'\',
\n `image_position` varchar(10) NOT NULL default \'\',
\n `description` text NOT NULL,
\n `published` tinyint(1) NOT NULL default \'0\',
\n `checked_out` int(11) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `editor` varchar(50) default NULL,
\n `ordering` int(11) NOT NULL default \'0\',
\n `access` tinyint(3) unsigned NOT NULL default \'0\',
\n `count` int(11) NOT NULL default \'0\',
\n `params` text NOT NULL,
\n PRIMARY KEY (`id`),
\n KEY `cat_idx` (`section`,`published`,`access`),
\n KEY `idx_section` (`section`),
\n KEY `idx_access` (`access`),
\n KEY `idx_checkout` (`checked_out`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__categories`
CREATE TABLE `#__categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_components\' already exists SQL=# Table structure for table `jos_components`
\n
\nCREATE TABLE `jos_components` (
\n `id` int(11) NOT NULL auto_increment,
\n `name` varchar(50) NOT NULL default \'\',
\n `link` varchar(255) NOT NULL default \'\',
\n `menuid` int(11) unsigned NOT NULL default \'0\',
\n `parent` int(11) unsigned NOT NULL default \'0\',
\n `admin_menu_link` varchar(255) NOT NULL default \'\',
\n `admin_menu_alt` varchar(255) NOT NULL default \'\',
\n `option` varchar(50) NOT NULL default \'\',
\n `ordering` int(11) NOT NULL default \'0\',
\n `admin_menu_img` varchar(255) NOT NULL default \'\',
\n `iscore` tinyint(4) NOT NULL default \'0\',
\n `params` text NOT NULL,
\n PRIMARY KEY (`id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__components`
CREATE TABLE `#__components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=# Dumping data for table `jos_components`
\n
\nINSERT INTO `jos_components` VALUES (1, \'Banner\', \'\', 0, 0, \'\', \'Gestione banner\', \'com_banners\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
# Dumping data for table `#__components`
INSERT INTO `#__components` VALUES (1, 'Banner', '', 0, 0, '', 'Gestione banner', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_components` VALUES (2, \'Gestione banner\', \'\', 0, 1, \'option=com_banners\', \'Banner attivi\', \'com_banners\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (2, 'Gestione banner', '', 0, 1, 'option=com_banners', 'Banner attivi', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_components` VALUES (3, \'Gestione clienti\', \'\', 0, 1, \'option=com_banners&task=listclients\', \'Gestione clienti\', \'com_banners\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (3, 'Gestione clienti', '', 0, 1, 'option=com_banners&task=listclients', 'Gestione clienti', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_components` VALUES (4, \'Collegamenti web\', \'option=com_weblinks\', 0, 0, \'\', \'Gestione collegamenti web\', \'com_weblinks\', 0, \'js/ThemeOffice/globe2.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (4, 'Collegamenti web', 'option=com_weblinks', 0, 0, '', 'Gestione collegamenti web', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_components` VALUES (5, \'Gestione collegamenti web\', \'\', 0, 4, \'option=com_weblinks\', \'Vedi collegamenti web esistenti\', \'com_weblinks\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (5, 'Gestione collegamenti web', '', 0, 4, 'option=com_weblinks', 'Vedi collegamenti web esistenti', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_components` VALUES (6, \'Categorie collegamenti web\', \'\', 0, 4, \'option=categories§ion=com_weblinks\', \'Gestione categorie collegamenti web\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (6, 'Categorie collegamenti web', '', 0, 4, 'option=categories§ion=com_weblinks', 'Gestione categorie collegamenti web', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_components` VALUES (7, \'Contatti\', \'option=com_contact\', 0, 0, \'\', \'Modifica dettagli contatti\', \'com_contact\', 0, \'js/ThemeOffice/user.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (7, 'Contatti', 'option=com_contact', 0, 0, '', 'Modifica dettagli contatti', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_components` VALUES (8, \'Gestione Contatti\', \'\', 0, 7, \'option=com_contact\', \'Modifica dettagli contatti\', \'com_contact\', 0, \'js/ThemeOffice/edit.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (8, 'Gestione Contatti', '', 0, 7, 'option=com_contact', 'Modifica dettagli contatti', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_components` VALUES (9, \'Categorie contatti\', \'\', 0, 7, \'option=categories§ion=com_contact_details\', \'Gestione categorie contatti\', \'\', 2, \'js/ThemeOffice/categories.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (9, 'Categorie contatti', '', 0, 7, 'option=categories§ion=com_contact_details', 'Gestione categorie contatti', '', 2, 'js/ThemeOffice/categories.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_components` VALUES (10, \'Prima pagina\', \'option=com_frontpage\', 0, 0, \'\', \'Gestione prima pagina\', \'com_frontpage\', 0, \'js/ThemeOffice/component.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (10, 'Prima pagina', 'option=com_frontpage', 0, 0, '', 'Gestione prima pagina', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_components` VALUES (11, \'Sondaggi\', \'option=com_poll\', 0, 0, \'option=com_poll\', \'Gestione sondaggi\', \'com_poll\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (11, 'Sondaggi', 'option=com_poll', 0, 0, 'option=com_poll', 'Gestione sondaggi', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_components` VALUES (12, \'News feed\', \'option=com_newsfeeds\', 0, 0, \'\', \'Gestione news feed\', \'com_newsfeeds\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (12, 'News feed', 'option=com_newsfeeds', 0, 0, '', 'Gestione news feed', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_components` VALUES (13, \'Gestione News feed\', \'\', 0, 12, \'option=com_newsfeeds\', \'Gestione news feed\', \'com_newsfeeds\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (13, 'Gestione News feed', '', 0, 12, 'option=com_newsfeeds', 'Gestione news feed', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_components` VALUES (14, \'Gestione categorie\', \'\', 0, 12, \'option=com_categories§ion=com_newsfeeds\', \'Gestione categorie\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (14, 'Gestione categorie', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Gestione categorie', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_components` VALUES (15, \'Login\', \'option=com_login\', 0, 0, \'\', \'\', \'com_login\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'16\' for key 1 SQL=INSERT INTO `jos_components` VALUES (16, \'Cerca\', \'option=com_search\', 0, 0, \'\', \'\', \'com_search\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (16, 'Cerca', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_components` VALUES (17, \'Syndicate\',\'\',0,0,\'option=com_syndicate&hidemainmenu=1\',\'Configurazione syndication\',\'com_syndicate\',0,\'js/ThemeOffice/component.png\',0,\'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (17, 'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Configurazione syndication','com_syndicate',0,'js/ThemeOffice/component.png',0,'')
= = = = = = = = = =
SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_components` VALUES (18, \'Mass Mail\', \'\', 0, 0, \'option=com_massmail&hidemainmenu=1\', \'Invia Mass Mail\', \'com_massmail\', 0, \'js/ThemeOffice/mass_email.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Invia Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, '')
= = = = = = = = = =
SQL=Table \'jos_contact_details\' already exists SQL=# Table structure for table `jos_contact_details`
\n
\nCREATE TABLE `jos_contact_details` (
\n `id` int(11) NOT NULL auto_increment,
\n `name` varchar(100) NOT NULL default \'\',
\n `con_position` varchar(50) default NULL,
\n `address` text,
\n `suburb` varchar(50) default NULL,
\n `state` varchar(20) default NULL,
\n `country` varchar(50) default NULL,
\n `postcode` varchar(10) default NULL,
\n `telephone` varchar(25) default NULL,
\n `fax` varchar(25) default NULL,
\n `misc` mediumtext,
\n `image` varchar(100) default NULL,
\n `imagepos` varchar(20) default NULL,
\n `email_to` varchar(100) default NULL,
\n `default_con` tinyint(1) unsigned NOT NULL default \'0\',
\n `published` tinyint(1) unsigned NOT NULL default \'0\',
\n `checked_out` int(11) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `ordering` int(11) NOT NULL default \'0\',
\n `params` text NOT NULL,
\n `user_id` int(11) NOT NULL default \'0\',
\n `catid` int(11) NOT NULL default \'0\',
\n `access` tinyint(3) unsigned NOT NULL default \'0\',
\n PRIMARY KEY (`id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__contact_details`
CREATE TABLE `#__contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content\' already exists SQL=# Table structure for table `jos_content`
\n
\nCREATE TABLE `jos_content` (
\n `id` int(11) unsigned NOT NULL auto_increment,
\n `title` varchar(100) NOT NULL default \'\',
\n `title_alias` varchar(100) NOT NULL default \'\',
\n `introtext` mediumtext NOT NULL,
\n `fulltext` mediumtext NOT NULL,
\n `state` tinyint(3) NOT NULL default \'0\',
\n `sectionid` int(11) unsigned NOT NULL default \'0\',
\n `mask` int(11) unsigned NOT NULL default \'0\',
\n `catid` int(11) unsigned NOT NULL default \'0\',
\n `created` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `created_by` int(11) unsigned NOT NULL default \'0\',
\n `created_by_alias` varchar(100) NOT NULL default \'\',
\n `modified` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `modified_by` int(11) unsigned NOT NULL default \'0\',
\n `checked_out` int(11) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `publish_up` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `publish_down` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `images` text NOT NULL,
\n `urls` text NOT NULL,
\n `attribs` text NOT NULL,
\n `version` int(11) unsigned NOT NULL default \'1\',
\n `parentid` int(11) unsigned NOT NULL default \'0\',
\n `ordering` int(11) NOT NULL default \'0\',
\n `metakey` text NOT NULL,
\n `metadesc` text NOT NULL,
\n `access` int(11) unsigned NOT NULL default \'0\',
\n `hits` int(11) unsigned NOT NULL default \'0\',
\n PRIMARY KEY (`id`),
\n KEY `idx_section` (`sectionid`),
\n KEY `idx_access` (`access`),
\n KEY `idx_checkout` (`checked_out`),
\n KEY `idx_state` (`state`),
\n KEY `idx_catid` (`catid`),
\n KEY `idx_mask` (`mask`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content`
CREATE TABLE `#__content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content_frontpage\' already exists SQL=# Table structure for table `jos_content_frontpage`
\n
\nCREATE TABLE `jos_content_frontpage` (
\n `content_id` int(11) NOT NULL default \'0\',
\n `ordering` int(11) NOT NULL default \'0\',
\n PRIMARY KEY (`content_id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_frontpage`
CREATE TABLE `#__content_frontpage` (
`content_id` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content_rating\' already exists SQL=# Table structure for table `jos_content_rating`
\n
\nCREATE TABLE `jos_content_rating` (
\n `content_id` int(11) NOT NULL default \'0\',
\n `rating_sum` int(11) unsigned NOT NULL default \'0\',
\n `rating_count` int(11) unsigned NOT NULL default \'0\',
\n `lastip` varchar(50) NOT NULL default \'\',
\n PRIMARY KEY (`content_id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_rating`
CREATE TABLE `#__content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '0',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_core_log_items\' already exists SQL=# Table structure for table `jos_core_log_items`
\n# To be implemented in Version 4.6
\n
\nCREATE TABLE `jos_core_log_items` (
\n `time_stamp` date NOT NULL default \'0000-00-00\',
\n `item_table` varchar(50) NOT NULL default \'\',
\n `item_id` int(11) unsigned NOT NULL default \'0\',
\n `hits` int(11) unsigned NOT NULL default \'0\'
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_items`
# To be implemented in Version 4.6
CREATE TABLE `#__core_log_items` (
`time_stamp` date NOT NULL default '0000-00-00',
`item_table` varchar(50) NOT NULL default '',
`item_id` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_core_log_searches\' already exists SQL=# Table structure for table `jos_core_log_searches`
\n# To be implemented in Version 4.6
\n
\nCREATE TABLE `jos_core_log_searches` (
\n `search_term` varchar(128) NOT NULL default \'\',
\n `hits` int(11) unsigned NOT NULL default \'0\'
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_searches`
# To be implemented in Version 4.6
CREATE TABLE `#__core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_groups\' already exists SQL=# Table structure for table `jos_groups`
\n
\nCREATE TABLE `jos_groups` (
\n `id` tinyint(3) unsigned NOT NULL default \'0\',
\n `name` varchar(50) NOT NULL default \'\',
\n PRIMARY KEY (`id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__groups`
CREATE TABLE `#__groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'0\' for key 1 SQL=# Dumping data for table `jos_groups`
\n
\nINSERT INTO `jos_groups` VALUES (0, \'Public\'):
- - - - - - - - - -
# Dumping data for table `#__groups`
INSERT INTO `#__groups` VALUES (0, 'Public')
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (1, \'Registered\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (1, 'Registered')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (2, \'Special\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (2, 'Special')
= = = = = = = = = =
SQL=Table \'jos_mambots\' already exists SQL=# Table structure for table `jos_mambots`
\n
\nCREATE TABLE `jos_mambots` (
\n `id` int(11) NOT NULL auto_increment,
\n `name` varchar(100) NOT NULL default \'\',
\n `element` varchar(100) NOT NULL default \'\',
\n `folder` varchar(100) NOT NULL default \'\',
\n `access` tinyint(3) unsigned NOT NULL default \'0\',
\n `ordering` int(11) NOT NULL default \'0\',
\n `published` tinyint(3) NOT NULL default \'0\',
\n `iscore` tinyint(3) NOT NULL default \'0\',
\n `client_id` tinyint(3) NOT NULL default \'0\',
\n `checked_out` int(11) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `params` text NOT NULL,
\n PRIMARY KEY (`id`),
\n KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__mambots`
CREATE TABLE `#__mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (1,\'MOS Image\',\'mosimage\',\'content\',0,-10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (2,\'MOS Pagination\',\'mospaging\',\'content\',0,10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (3,\'Legacy Mambot Includer\',\'legacybots\',\'content\',0,1,0,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (4,\'SEF\',\'mossef\',\'content\',0,3,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (5,\'MOS Rating\',\'mosvote\',\'content\',0,4,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (6,\'Ricerca nei contenuti\',\'content.searchbot\',\'search\',0,1,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (6,'Ricerca nei contenuti','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (7,\'Ricerca nei collegamenti web\',\'weblinks.searchbot\',\'search\',0,2,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (7,'Ricerca nei collegamenti web','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (8,\'Supporto codice\',\'moscode\',\'content\',0,2,0,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (8,'Supporto codice','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (9,\'Nessun editor WYSIWYG\',\'none\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (9,'Nessun editor WYSIWYG','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (10,\'Editor TinyMCE WYSIWYG\',\'tinymce\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'theme=advanced\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (10,'Editor TinyMCE WYSIWYG','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced')
= = = = = = = = = =
SQL=Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (11,\'Bottone editor MOS Image\',\'mosimage.btn\',\'editors-xtd\',0,0,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (11,'Bottone editor MOS Image','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (12,\'Bottone editor MOS Pagebreak\',\'mospage.btn\',\'editors-xtd\',0,0,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (12,'Bottone editor MOS Pagebreak','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (13,\'Ricerca nei contati\',\'contacts.searchbot\',\'search\',0,3,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (13,'Ricerca nei contati','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (14, \'Ricerca nelle categorie\', \'categories.searchbot\', \'search\', 0, 4, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (14, 'Ricerca nelle categorie', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (15, \'Ricerca nelle sezioni\', \'sections.searchbot\', \'search\', 0, 5, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (15, 'Ricerca nelle sezioni', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'16\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (16, \'Email Cloaking\', \'mosemailcloak\', \'content\', 0, 5, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (17, \'GeSHi\', \'geshi\', \'content\', 0, 5, 0, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (18, \'Ricerca nei newsfeeds\', \'newsfeeds.searchbot\', \'search\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (18, 'Ricerca nei newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry \'19\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (19, \'Carica posizione moduli\', \'mosloadposition\', \'content\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (19, 'Carica posizione moduli', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Table \'jos_menu\' already exists SQL=# Table structure for table `jos_menu`
\n
\nCREATE TABLE `jos_menu` (
\n `id` int(11) NOT NULL auto_increment,
\n `menutype` varchar(25) default NULL,
\n `name` varchar(100) default NULL,
\n `link` text,
\n `type` varchar(50) NOT NULL default \'\',
\n `published` tinyint(1) NOT NULL default \'0\',
\n `parent` int(11) unsigned NOT NULL default \'0\',
\n `componentid` int(11) unsigned NOT NULL default \'0\',
\n `sublevel` int(11) default \'0\',
\n `ordering` int(11) default \'0\',
\n `checked_out` int(11) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `pollid` int(11) NOT NULL default \'0\',
\n `browserNav` tinyint(4) default \'0\',
\n `access` tinyint(3) unsigned NOT NULL default \'0\',
\n `utaccess` tinyint(3) unsigned NOT NULL default \'0\',
\n `params` text NOT NULL,
\n PRIMARY KEY (`id`),
\n KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
\n KEY `menutype` (`menutype`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__menu`
CREATE TABLE `#__menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`type` varchar(50) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`componentid` int(11) unsigned NOT NULL default '0',
`sublevel` int(11) default '0',
`ordering` int(11) default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL default '0',
`browserNav` tinyint(4) default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`utaccess` tinyint(3) unsigned NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_menu` VALUES (1, \'mainmenu\', \'Home\', \'index.php?option=com_frontpage\', \'components\', 1, 0, 10, 0, 1, 0, \'0000-00-00 00:00:00\', 0, 0, 0, 3, \'leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Benvenuto in prima pagina\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0\'):
- - - - - - - - - -
INSERT INTO `#__menu` VALUES (1, 'mainmenu', 'Home', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Benvenuto in prima pagina\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0')
= = = = = = = = = =
SQL=Table \'jos_messages\' already exists SQL=# Table structure for table `jos_messages`
\n
\nCREATE TABLE `jos_messages` (
\n `message_id` int(10) unsigned NOT NULL auto_increment,
\n `user_id_from` int(10) unsigned NOT NULL default \'0\',
\n `user_id_to` int(10) unsigned NOT NULL default \'0\',
\n `folder_id` int(10) unsigned NOT NULL default \'0\',
\n `date_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `state` int(11) NOT NULL default \'0\',
\n `priority` int(1) unsigned NOT NULL default \'0\',
\n `subject` varchar(230) NOT NULL default \'\',
\n `message` text NOT NULL,
\n PRIMARY KEY (`message_id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__messages`
CREATE TABLE `#__messages` (
`message_id` int(10) unsigned NOT NULL auto_increment,
`user_id_from` int(10) unsigned NOT NULL default '0',
`user_id_to` int(10) unsigned NOT NULL default '0',
`folder_id` int(10) unsigned NOT NULL default '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`state` int(11) NOT NULL default '0',
`priority` int(1) unsigned NOT NULL default '0',
`subject` varchar(230) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`message_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_messages_cfg\' already exists SQL=# Table structure for table `jos_messages_cfg`
\n
\nCREATE TABLE `jos_messages_cfg` (
\n `user_id` int(10) unsigned NOT NULL default \'0\',
\n `cfg_name` varchar(100) NOT NULL default \'\',
\n `cfg_value` varchar(255) NOT NULL default \'\',
\n UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__messages_cfg`
CREATE TABLE `#__messages_cfg` (
`user_id` int(10) unsigned NOT NULL default '0',
`cfg_name` varchar(100) NOT NULL default '',
`cfg_value` varchar(255) NOT NULL default '',
UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_modules\' already exists SQL=# Table structure for table `jos_modules`
\n
\nCREATE TABLE `jos_modules` (
\n `id` int(11) NOT NULL auto_increment,
\n `title` text NOT NULL,
\n `content` text NOT NULL,
\n `ordering` int(11) NOT NULL default \'0\',
\n `position` varchar(10) default NULL,
\n `checked_out` int(11) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `published` tinyint(1) NOT NULL default \'0\',
\n `module` varchar(50) default NULL,
\n `numnews` int(11) NOT NULL default \'0\',
\n `access` tinyint(3) unsigned NOT NULL default \'0\',
\n `showtitle` tinyint(3) unsigned NOT NULL default \'1\',
\n `params` text NOT NULL,
\n `iscore` tinyint(4) NOT NULL default \'0\',
\n `client_id` tinyint(4) NOT NULL default \'0\',
\n PRIMARY KEY (`id`),
\n KEY `published` (`published`,`access`),
\n KEY `newsfeeds` (`module`,`published`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__modules`
CREATE TABLE `#__modules` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
`position` varchar(10) default NULL,
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`module` varchar(50) default NULL,
`numnews` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`showtitle` tinyint(3) unsigned NOT NULL default '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_modules_menu\' already exists SQL=# Table structure for table `jos_modules_menu`
\n
\nCREATE TABLE `jos_modules_menu` (
\n `moduleid` int(11) NOT NULL default \'0\',
\n `menuid` int(11) NOT NULL default \'0\',
\n PRIMARY KEY (`moduleid`,`menuid`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__modules_menu`
CREATE TABLE `#__modules_menu` (
`moduleid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`moduleid`,`menuid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1-1\' for key 1 SQL=# Dumping data for table `jos_modules_menu`
\n
\nINSERT INTO `jos_modules_menu` VALUES (1,1):
- - - - - - - - - -
# Dumping data for table `#__modules_menu`
INSERT INTO `#__modules_menu` VALUES (1,1)
= = = = = = = = = =
SQL=Duplicate entry \'2-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (2,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (2,0)
= = = = = = = = = =
SQL=Duplicate entry \'3-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (3,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (3,0)
= = = = = = = = = =
SQL=Duplicate entry \'4-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (4,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (4,1)
= = = = = = = = = =
SQL=Duplicate entry \'5-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (5,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (5,1)
= = = = = = = = = =
SQL=Duplicate entry \'6-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,1)
= = = = = = = = = =
SQL=Duplicate entry \'6-2\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,2):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,2)
= = = = = = = = = =
SQL=Duplicate entry \'6-4\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,4):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,4)
= = = = = = = = = =
SQL=Duplicate entry \'6-27\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,27):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,27)
= = = = = = = = = =
SQL=Duplicate entry \'6-36\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,36):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,36)
= = = = = = = = = =
SQL=Duplicate entry \'8-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (8,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (8,1)
= = = = = = = = = =
SQL=Duplicate entry \'9-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,1)
= = = = = = = = = =
SQL=Duplicate entry \'9-2\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,2):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,2)
= = = = = = = = = =
SQL=Duplicate entry \'9-4\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,4):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,4)
= = = = = = = = = =
SQL=Duplicate entry \'9-27\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,27):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,27)
= = = = = = = = = =
SQL=Duplicate entry \'9-36\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,36):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,36)
= = = = = = = = = =
SQL=Duplicate entry \'10-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (10,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (10,1)
= = = = = = = = = =
SQL=Duplicate entry \'13-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (13,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (13,0)
= = = = = = = = = =
SQL=Duplicate entry \'15-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (15,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (15,0)
= = = = = = = = = =
SQL=Duplicate entry \'17-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (17,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (17,0)
= = = = = = = = = =
SQL=Duplicate entry \'18-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (18,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (18,0)
= = = = = = = = = =
SQL=Duplicate entry \'30-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (30,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (30,0)
= = = = = = = = = =
SQL=Table \'jos_newsfeeds\' already exists SQL=# Table structure for table `jos_newsfeeds`
\n
\nCREATE TABLE `jos_newsfeeds` (
\n `catid` int(11) NOT NULL default \'0\',
\n `id` int(11) NOT NULL auto_increment,
\n `name` text NOT NULL,
\n `link` text NOT NULL,
\n `filename` varchar(200) default NULL,
\n `published` tinyint(1) NOT NULL default \'0\',
\n `numarticles` int(11) unsigned NOT NULL default \'1\',
\n `cache_time` int(11) unsigned NOT NULL default \'3600\',
\n `checked_out` tinyint(3) unsigned NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `ordering` int(11) NOT NULL default \'0\',
\n PRIMARY KEY (`id`),
\n KEY `published` (`published`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__newsfeeds`
CREATE TABLE `#__newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`link` text NOT NULL,
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` int(11) unsigned NOT NULL default '1',
`cache_time` int(11) unsigned NOT NULL default '3600',
`checked_out` tinyint(3) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_poll_data\' already exists SQL=# Table structure for table `jos_poll_data`
\n
\nCREATE TABLE `jos_poll_data` (
\n `id` int(11) NOT NULL auto_increment,
\n `pollid` int(4) NOT NULL default \'0\',
\n `text` text NOT NULL default \'\',
\n `hits` int(11) NOT NULL default \'0\',
\n PRIMARY KEY (`id`),
\n KEY `pollid` (`pollid`,`text`(1))
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__poll_data`
CREATE TABLE `#__poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL default '',
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_poll_date\' already exists SQL=# Table structure for table `jos_poll_date`
\n
\nCREATE TABLE `jos_poll_date` (
\n `id` bigint(20) NOT NULL auto_increment,
\n `date` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `vote_id` int(11) NOT NULL default \'0\',
\n `poll_id` int(11) NOT NULL default \'0\',
\n PRIMARY KEY (`id`),
\n KEY `poll_id` (`poll_id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__poll_date`
CREATE TABLE `#__poll_date` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_polls\' already exists SQL=# Table structure for table `jos_polls`
\n
\nCREATE TABLE `jos_polls` (
\n `id` int(11) unsigned NOT NULL auto_increment,
\n `title` varchar(100) NOT NULL default \'\',
\n `voters` int(9) NOT NULL default \'0\',
\n `checked_out` int(11) NOT NULL default \'0\',
\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
\n `published` tinyint(1) NOT NULL default \'0\',
\n `access` int(11) NOT NULL default \'0\',
\n `lag` int(11) NOT NULL default \'0\',
\n PRIMARY KEY (`id`)
\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__polls`
CREATE TABLE `#__polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`voters` int(9) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`lag` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_poll_menu\' already exists SQL=# Table structure for table `jos_poll_menu`
\n
\nCREATE TABLE `jos_poll_menu` (
\n `pollid` int(11) NOT NULL default \'0\',
\n `menuid` int(11) NOT NULL default \'
