apro la pag web con l'installazione, vado avanti e accetto le condizioni; inserisco i dati del database mysql e l'installazione mi da il seguente errore:
(non sò che fare
)
help
SQL=Table \'jos_akocomment\' already exists SQL=# $Id: joomla.sql 677 2007-01-27 02:13:29Z spacemonkey $\n\n# structure of table `jos_akocomment` ###\nCREATE TABLE `jos_akocomment` (\n `id` int(11) NOT NULL auto_increment,\n `parentid` int(11) NOT NULL default \'0\',\n `status` int(11) NOT NULL default \'0\',\n `contentid` int(11) NOT NULL default \'0\',\n `ip` varchar(15) NOT NULL default \'\',\n `name` varchar(30) NOT NULL default \'\',\n `web` varchar(255) NOT NULL default \'\',\n `email` varchar(255) NOT NULL default \'\',\n `title` varchar(40) NOT NULL default \'\',\n `comment` text NOT NULL,\n `date` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `published` tinyint(1) NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `iduser` int(11) NOT NULL default \'0\',\n `subscribe` tinyint(1) NOT NULL default \'0\',\n PRIMARY KEY (`id`)\n) TYPE=InnoDB:
- - - - - - - - - -
# $Id: joomla.sql 677 2007-01-27 02:13:29Z spacemonkey $
# structure of table `#__akocomment` ###
CREATE TABLE `#__akocomment` (
`id` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`contentid` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`name` varchar(30) NOT NULL default '',
`web` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`title` varchar(40) NOT NULL default '',
`comment` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`iduser` int(11) NOT NULL default '0',
`subscribe` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_akocomment_favoured\' already exists SQL=# structure of table `jos_akocomment_favoured` ###\nCREATE TABLE `jos_akocomment_favoured` (\n `id` int(11) NOT NULL auto_increment,\n `id_content` int(11) NOT NULL default \'0\',\n `id_user` int(11) NOT NULL default \'0\',\n `ip` varchar(15) NOT NULL default \'\',\n `date` datetime NOT NULL default \'0000-00-00 00:00:00\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# structure of table `#__akocomment_favoured` ###
CREATE TABLE `#__akocomment_favoured` (
`id` int(11) NOT NULL auto_increment,
`id_content` int(11) NOT NULL default '0',
`id_user` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_artbannersplus\' already exists SQL=# structure of table `jos_artbannersplus` ###\nCREATE TABLE `jos_artbannersplus` (\n `id` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `tid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'banner\',\n `name` varchar(50) NOT NULL default \'\',\n `imp_total` int(11) NOT NULL default \'0\',\n `imp_made` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `image_url` varchar(100) default \'\',\n `click_url` varchar(200) default \'\',\n `custom_banner_code` text ,\n `state` tinyint(1) NOT NULL default \'0\',\n `last_show` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `msec` int(11) NOT NULL default \'0\',\n `publish_up_date` date NOT NULL default \'0000-00-00\',\n `publish_up_time` time NOT NULL default \'00:00:00\',\n `publish_down_date` date NOT NULL default \'0000-00-00\',\n `publish_down_time` time NOT NULL default \'00:00:00\',\n `reccurtype` tinyint(1) NOT NULL default \'0\',\n `reccurweekdays` varchar(100) NOT NULL default \'\',\n `access` int(11) NOT NULL default \'0\',\n `target` varchar(15) NOT NULL default \'\',\n `border_value` int(11) NOT NULL default \'0\',\n `border_style` varchar(11) NOT NULL default \'\',\n `border_color` varchar(11) NOT NULL default \'\',\n `click_value` varchar(10) NOT NULL default \'\',\n `complete_clicks` int(11) NOT NULL default \'0\',\n `imp_value` varchar(10) NOT NULL default \'\',\n `dta_mod_clicks` date default NULL,\n `password` varchar(40) NOT NULL default \'\',\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 `alt` varchar(200) default \'\',\n `title` varchar(200) default \'\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# structure of table `#__artbannersplus` ###
CREATE TABLE `#__artbannersplus` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`tid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imp_total` int(11) NOT NULL default '0',
`imp_made` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`image_url` varchar(100) default '',
`click_url` varchar(200) default '',
`custom_banner_code` text ,
`state` tinyint(1) NOT NULL default '0',
`last_show` datetime NOT NULL default '0000-00-00 00:00:00',
`msec` int(11) NOT NULL default '0',
`publish_up_date` date NOT NULL default '0000-00-00',
`publish_up_time` time NOT NULL default '00:00:00',
`publish_down_date` date NOT NULL default '0000-00-00',
`publish_down_time` time NOT NULL default '00:00:00',
`reccurtype` tinyint(1) NOT NULL default '0',
`reccurweekdays` varchar(100) NOT NULL default '',
`access` int(11) NOT NULL default '0',
`target` varchar(15) NOT NULL default '',
`border_value` int(11) NOT NULL default '0',
`border_style` varchar(11) NOT NULL default '',
`border_color` varchar(11) NOT NULL default '',
`click_value` varchar(10) NOT NULL default '',
`complete_clicks` int(11) NOT NULL default '0',
`imp_value` varchar(10) NOT NULL default '',
`dta_mod_clicks` date default NULL,
`password` varchar(40) NOT NULL default '',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`alt` varchar(200) default '',
`title` varchar(200) default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_artbannersplus_categories\' already exists SQL=# structure of table `jos_artbannersplus_categories` ###\nCREATE TABLE `jos_artbannersplus_categories` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(255) 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 PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# structure of table `#__artbannersplus_categories` ###
CREATE TABLE `#__artbannersplus_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) 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',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_artbannersplus_clients\' already exists SQL=# structure of table `jos_artbannersplus_clients` ###\nCREATE TABLE `jos_artbannersplus_clients` (\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 `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 PRIMARY KEY (`cid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# structure of table `#__artbannersplus_clients` ###
CREATE TABLE `#__artbannersplus_clients` (
`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,
`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',
PRIMARY KEY (`cid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_categories\' already exists SQL=# structure of table `jos_categories` ###\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:
- - - - - - - - - -
# structure of 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`\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 \'7\' for key 1 SQL=# Dumping data for table `jos_components`\nINSERT INTO `jos_components` values (\'7\', \'Contatti\', \'option=com_contact\', \'0\', \'0\', \'\', \'Modifica dettagli contatti\', \'com_contact\', \'0\', \'js/ThemeOffice/user.png\', \'1\', \'\'):
- - - - - - - - - -
# Dumping data for table `#__components`
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\', \'Manage Syndication Settings\', \'com_syndicate\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'check=1\ncache=1\ncache_time=3600\ncount=5\ntitle=Powered by Joomla! 1.0.12\ndescription=Joomla site syndication\nimage_file=joomla_rss.png\nimage_alt=Powered by Joomla! 1.0.12\nlimit_text=1\ntext_length=20\nrss091=1\nrss10=1\nrss20=1\natom03=1\nopml=1\norderby=front\nlive_bookmark=0\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('17', 'Syndicate', '', '0', '0', 'option=com_syndicate', 'Manage Syndication Settings', 'com_syndicate', '0', 'js/ThemeOffice/component.png', '0', 'check=1\ncache=1\ncache_time=3600\ncount=5\ntitle=Powered by Joomla! 1.0.12\ndescription=Joomla site syndication\nimage_file=joomla_rss.png\nimage_alt=Powered by Joomla! 1.0.12\nlimit_text=1\ntext_length=20\nrss091=1\nrss10=1\nrss20=1\natom03=1\nopml=1\norderby=front\nlive_bookmark=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=Duplicate entry \'19\' for key 1 SQL=INSERT INTO `jos_components` values (\'19\', \'Eventi\', \'option=com_events&act=entries\', \'0\', \'0\', \'option=com_events&act=entries\', \'Eventi\', \'com_events\', \'0\', \'../administrator/components/com_events/images/events_ico.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('19', 'Eventi', 'option=com_events&act=entries', '0', '0', 'option=com_events&act=entries', 'Eventi', 'com_events', '0', '../administrator/components/com_events/images/events_ico.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'20\' for key 1 SQL=INSERT INTO `jos_components` values (\'20\', \'Gestione Eventi\', \'\', \'0\', \'19\', \'option=com_events&act=entries\', \'Gestione Eventi\', \'com_events\', \'0\', \'../administrator/components/com_events/images/events_ico.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('20', 'Gestione Eventi', '', '0', '19', 'option=com_events&act=entries', 'Gestione Eventi', 'com_events', '0', '../administrator/components/com_events/images/events_ico.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'21\' for key 1 SQL=INSERT INTO `jos_components` values (\'21\', \'Gestione Categorie\', \'\', \'0\', \'19\', \'option=com_events&act=categories\', \'Gestione Categorie\', \'com_events\', \'1\', \'js/ThemeOffice/categories.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('21', 'Gestione Categorie', '', '0', '19', 'option=com_events&act=categories', 'Gestione Categorie', 'com_events', '1', 'js/ThemeOffice/categories.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'22\' for key 1 SQL=INSERT INTO `jos_components` values (\'22\', \'Configurazione\', \'\', \'0\', \'19\', \'option=com_events&act=conf\', \'Configurazione\', \'com_events\', \'2\', \'js/ThemeOffice/config.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('22', 'Configurazione', '', '0', '19', 'option=com_events&act=conf', 'Configurazione', 'com_events', '2', 'js/ThemeOffice/config.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'23\' for key 1 SQL=INSERT INTO `jos_components` values (\'23\', \'Archivio\', \'\', \'0\', \'19\', \'option=com_events&task=viewarchiv\', \'Archivio\', \'com_events\', \'3\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('23', 'Archivio', '', '0', '19', 'option=com_events&task=viewarchiv', 'Archivio', 'com_events', '3', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'24\' for key 1 SQL=INSERT INTO `jos_components` values (\'24\', \'Guestbook\', \'option=com_easygb\', \'0\', \'0\', \'option=com_easygb\', \'Guestbook\', \'com_easygb\', \'0\', \'../administrator/components/com_easygb/icons/16x16_klipper.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('24', 'Guestbook', 'option=com_easygb', '0', '0', 'option=com_easygb', 'Guestbook', 'com_easygb', '0', '../administrator/components/com_easygb/icons/16x16_klipper.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'25\' for key 1 SQL=INSERT INTO `jos_components` values (\'25\', \'Configurazione\', \'\', \'0\', \'24\', \'option=com_easygb&act=configuration\', \'Configurazione\', \'com_easygb\', \'0\', \'js/ThemeOffice/config.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('25', 'Configurazione', '', '0', '24', 'option=com_easygb&act=configuration', 'Configurazione', 'com_easygb', '0', 'js/ThemeOffice/config.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'26\' for key 1 SQL=INSERT INTO `jos_components` values (\'26\', \'Gestione inserimenti\', \'\', \'0\', \'24\', \'option=com_easygb&act=entries\', \'Gestione inserimenti\', \'com_easygb\', \'1\', \'js/ThemeOffice/content.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('26', 'Gestione inserimenti', '', '0', '24', 'option=com_easygb&act=entries', 'Gestione inserimenti', 'com_easygb', '1', 'js/ThemeOffice/content.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'27\' for key 1 SQL=INSERT INTO `jos_components` values (\'27\', \'Help\', \'\', \'0\', \'24\', \'option=com_easygb&act=info\', \'Help\', \'com_easygb\', \'2\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('27', 'Help', '', '0', '24', 'option=com_easygb&act=info', 'Help', 'com_easygb', '2', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'28\' for key 1 SQL=INSERT INTO `jos_components` values (\'28\', \'FAQ\', \'option=com_easyfaq\', \'0\', \'0\', \'option=com_easyfaq\', \'FAQ\', \'com_easyfaq\', \'0\', \'../administrator/components/com_easyfaq/icons/16x16_help_index.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('28', 'FAQ', 'option=com_easyfaq', '0', '0', 'option=com_easyfaq', 'FAQ', 'com_easyfaq', '0', '../administrator/components/com_easyfaq/icons/16x16_help_index.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'29\' for key 1 SQL=INSERT INTO `jos_components` values (\'29\', \'Gestione Categorie\', \'\', \'0\', \'28\', \'option=com_easyfaq&act=categories\', \'Gestione Categorie\', \'com_easyfaq\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('29', 'Gestione Categorie', '', '0', '28', 'option=com_easyfaq&act=categories', 'Gestione Categorie', 'com_easyfaq', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'30\' for key 1 SQL=INSERT INTO `jos_components` values (\'30\', \'Gestione FAQ\', \'\', \'0\', \'28\', \'option=com_easyfaq&act=faq\', \'Gestione FAQ\', \'com_easyfaq\', \'1\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('30', 'Gestione FAQ', '', '0', '28', 'option=com_easyfaq&act=faq', 'Gestione FAQ', 'com_easyfaq', '1', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'31\' for key 1 SQL=INSERT INTO `jos_components` values (\'31\', \'Help\', \'\', \'0\', \'28\', \'option=com_easyfaq&act=info\', \'Help\', \'com_easyfaq\', \'2\', \'js/ThemeOffice/credits.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('31', 'Help', '', '0', '28', 'option=com_easyfaq&act=info', 'Help', 'com_easyfaq', '2', 'js/ThemeOffice/credits.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'32\' for key 1 SQL=INSERT INTO `jos_components` values (\'32\', \'Backup\', \'option=com_jpack\', \'0\', \'0\', \'option=com_jpack\', \'Backup\', \'com_jpack\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('32', 'Backup', 'option=com_jpack', '0', '0', 'option=com_jpack', 'Backup', 'com_jpack', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'33\' for key 1 SQL=INSERT INTO `jos_components` values (\'33\', \'Web link\', \'option=com_weblinksplus\', \'0\', \'0\', \'\', \'Web link\', \'com_weblinksplus\', \'0\', \'js/ThemeOffice/globe2.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('33', 'Web link', 'option=com_weblinksplus', '0', '0', '', 'Web link', 'com_weblinksplus', '0', 'js/ThemeOffice/globe2.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'34\' for key 1 SQL=INSERT INTO `jos_components` values (\'34\', \'Gestione collegamenti web\', \'\', \'0\', \'33\', \'option=com_weblinksplus\', \'Gestione collegamenti web\', \'com_weblinksplus\', \'0\', \'js/ThemeOffice/edit.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('34', 'Gestione collegamenti web', '', '0', '33', 'option=com_weblinksplus', 'Gestione collegamenti web', 'com_weblinksplus', '0', 'js/ThemeOffice/edit.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'35\' for key 1 SQL=INSERT INTO `jos_components` values (\'35\', \'Categorie collegamenti web\', \'\', \'0\', \'33\', \'option=categories§ion=com_weblinksplus\', \'Categorie collegamenti web\', \'com_weblinksplus\', \'1\', \'js/ThemeOffice/add_section.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('35', 'Categorie collegamenti web', '', '0', '33', 'option=categories§ion=com_weblinksplus', 'Categorie collegamenti web', 'com_weblinksplus', '1', 'js/ThemeOffice/add_section.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'36\' for key 1 SQL=INSERT INTO `jos_components` values (\'36\', \'Configurazione\', \'\', \'0\', \'33\', \'option=com_weblinksplus&task=settings\', \'Configurazione\', \'com_weblinksplus\', \'2\', \'js/ThemeOffice/config.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('36', 'Configurazione', '', '0', '33', 'option=com_weblinksplus&task=settings', 'Configurazione', 'com_weblinksplus', '2', 'js/ThemeOffice/config.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'43\' for key 1 SQL=INSERT INTO `jos_components` values (\'43\', \'Commenti\', \'option=com_commenti\', \'0\', \'0\', \'option=com_commenti\', \'Commenti\', \'com_commenti\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('43', 'Commenti', 'option=com_commenti', '0', '0', 'option=com_commenti', 'Commenti', 'com_commenti', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'44\' for key 1 SQL=INSERT INTO `jos_components` values (\'44\', \'Gestione Commenti\', \'\', \'0\', \'43\', \'option=com_commenti&task=comments\', \'Gestione Commenti\', \'com_commenti\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('44', 'Gestione Commenti', '', '0', '43', 'option=com_commenti&task=comments', 'Gestione Commenti', 'com_commenti', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'45\' for key 1 SQL=INSERT INTO `jos_components` values (\'45\', \'Modifica Impostazioni\', \'\', \'0\', \'43\', \'option=com_commenti&task=settings\', \'Modifica Impostazioni\', \'com_commenti\', \'1\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('45', 'Modifica Impostazioni', '', '0', '43', 'option=com_commenti&task=settings', 'Modifica Impostazioni', 'com_commenti', '1', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'46\' for key 1 SQL=INSERT INTO `jos_components` values (\'46\', \'Mappa del sito\', \'option=com_joomap\', \'0\', \'0\', \'option=com_joomap\', \'Mappa del sito\', \'com_joomap\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('46', 'Mappa del sito', 'option=com_joomap', '0', '0', 'option=com_joomap', 'Mappa del sito', 'com_joomap', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'47\' for key 1 SQL=INSERT INTO `jos_components` values (\'47\', \'ArtBannersPlus\', \'option=com_artbannersplus\', \'0\', \'0\', \'option=com_artbannersplus\', \'ArtBannersPlus\', \'com_artbannersplus\', \'0\', \'../administrator/components/com_artbannersplus/images/icon.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('47', 'ArtBannersPlus', 'option=com_artbannersplus', '0', '0', 'option=com_artbannersplus', 'ArtBannersPlus', 'com_artbannersplus', '0', '../administrator/components/com_artbannersplus/images/icon.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'48\' for key 1 SQL=INSERT INTO `jos_components` values (\'48\', \'Pannello di controllo\', \'\', \'0\', \'47\', \'option=com_artbannersplus\', \'Pannello di controllo\', \'com_artbannersplus\', \'0\', \'js/ThemeOffice/controlpanel.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('48', 'Pannello di controllo', '', '0', '47', 'option=com_artbannersplus', 'Pannello di controllo', 'com_artbannersplus', '0', 'js/ThemeOffice/controlpanel.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'49\' for key 1 SQL=INSERT INTO `jos_components` values (\'49\', \'Gestione Banner\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=banners\', \'Gestione Banner\', \'com_artbannersplus\', \'1\', \'js/ThemeOffice/edit.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('49', 'Gestione Banner', '', '0', '47', 'option=com_artbannersplus&task=banners', 'Gestione Banner', 'com_artbannersplus', '1', 'js/ThemeOffice/edit.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'50\' for key 1 SQL=INSERT INTO `jos_components` values (\'50\', \'Gestione Categorie\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=categories\', \'Gestione Categorie\', \'com_artbannersplus\', \'2\', \'js/ThemeOffice/categories.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('50', 'Gestione Categorie', '', '0', '47', 'option=com_artbannersplus&task=categories', 'Gestione Categorie', 'com_artbannersplus', '2', 'js/ThemeOffice/categories.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'51\' for key 1 SQL=INSERT INTO `jos_components` values (\'51\', \'Gestione Clienti\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=clients\', \'Gestione Clienti\', \'com_artbannersplus\', \'3\', \'js/ThemeOffice/user.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('51', 'Gestione Clienti', '', '0', '47', 'option=com_artbannersplus&task=clients', 'Gestione Clienti', 'com_artbannersplus', '3', 'js/ThemeOffice/user.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'52\' for key 1 SQL=INSERT INTO `jos_components` values (\'52\', \'Importa ArtBanner\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=importartbanners\', \'Importa ArtBanner\', \'com_artbannersplus\', \'4\', \'js/ThemeOffice/restore.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('52', 'Importa ArtBanner', '', '0', '47', 'option=com_artbannersplus&task=importartbanners', 'Importa ArtBanner', 'com_artbannersplus', '4', 'js/ThemeOffice/restore.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'53\' for key 1 SQL=INSERT INTO `jos_components` values (\'53\', \'Importa Joomla-Banner\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=importbanners\', \'Importa Joomla-Banner\', \'com_artbannersplus\', \'5\', \'js/ThemeOffice/restore.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('53', 'Importa Joomla-Banner', '', '0', '47', 'option=com_artbannersplus&task=importbanners', 'Importa Joomla-Banner', 'com_artbannersplus', '5', 'js/ThemeOffice/restore.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'54\' for key 1 SQL=INSERT INTO `jos_components` values (\'54\', \'Backup ArtBannersPlus\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=backup\', \'Backup ArtBannersPlus\', \'com_artbannersplus\', \'6\', \'js/ThemeOffice/backup.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('54', 'Backup ArtBannersPlus', '', '0', '47', 'option=com_artbannersplus&task=backup', 'Backup ArtBannersPlus', 'com_artbannersplus', '6', 'js/ThemeOffice/backup.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'55\' for key 1 SQL=INSERT INTO `jos_components` values (\'55\', \'Restore ArtBannersPlus\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=restore\', \'Restore ArtBannersPlus\', \'com_artbannersplus\', \'7\', \'js/ThemeOffice/restore.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('55', 'Restore ArtBannersPlus', '', '0', '47', 'option=com_artbannersplus&task=restore', 'Restore ArtBannersPlus', 'com_artbannersplus', '7', 'js/ThemeOffice/restore.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'56\' for key 1 SQL=INSERT INTO `jos_components` values (\'56\', \'Gestione lingue\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=langmanager\', \'Gestione lingue\', \'com_artbannersplus\', \'8\', \'js/ThemeOffice/language.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('56', 'Gestione lingue', '', '0', '47', 'option=com_artbannersplus&task=langmanager', 'Gestione lingue', 'com_artbannersplus', '8', 'js/ThemeOffice/language.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'57\' for key 1 SQL=INSERT INTO `jos_components` values (\'57\', \'Informazioni\', \'\', \'0\', \'47\', \'option=com_artbannersplus&task=information\', \'Informazioni\', \'com_artbannersplus\', \'9\', \'js/ThemeOffice/help.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('57', 'Informazioni', '', '0', '47', 'option=com_artbannersplus&task=information', 'Informazioni', 'com_artbannersplus', '9', 'js/ThemeOffice/help.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'58\' for key 1 SQL=INSERT INTO `jos_components` values (\'58\', \'AlphaContent\', \'option=com_alphacontent\', \'0\', \'0\', \'option=com_alphacontent\', \'AlphaContent\', \'com_alphacontent\', \'0\', \'../administrator/components/com_alphacontent/images/alpha_icon.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('58', 'AlphaContent', 'option=com_alphacontent', '0', '0', 'option=com_alphacontent', 'AlphaContent', 'com_alphacontent', '0', '../administrator/components/com_alphacontent/images/alpha_icon.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'59\' for key 1 SQL=INSERT INTO `jos_components` values (\'59\', \'Galleria fotografica\', \'option=com_easygallery\', \'0\', \'0\', \'option=com_easygallery\', \'Galleria fotografica\', \'com_easygallery\', \'0\', \'../administrator/components/com_easygallery/icons/16x16_kview.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('59', 'Galleria fotografica', 'option=com_easygallery', '0', '0', 'option=com_easygallery', 'Galleria fotografica', 'com_easygallery', '0', '../administrator/components/com_easygallery/icons/16x16_kview.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'60\' for key 1 SQL=INSERT INTO `jos_components` values (\'60\', \'Configurazione\', \'\', \'0\', \'59\', \'option=com_easygallery&act=configuration\', \'Configurazione\', \'com_easygallery\', \'0\', \'../administrator/components/com_easygallery/icons/16x16_configure.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('60', 'Configurazione', '', '0', '59', 'option=com_easygallery&act=configuration', 'Configurazione', 'com_easygallery', '0', '../administrator/components/com_easygallery/icons/16x16_configure.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'61\' for key 1 SQL=INSERT INTO `jos_components` values (\'61\', \'Gestione categorie\', \'\', \'0\', \'59\', \'option=com_easygallery&act=categories\', \'Gestione categorie\', \'com_easygallery\', \'1\', \'js/ThemeOffice/categories.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('61', 'Gestione categorie', '', '0', '59', 'option=com_easygallery&act=categories', 'Gestione categorie', 'com_easygallery', '1', 'js/ThemeOffice/categories.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'62\' for key 1 SQL=INSERT INTO `jos_components` values (\'62\', \'Gestione immagini\', \'\', \'0\', \'59\', \'option=com_easygallery&act=photos\', \'Gestione immagini\', \'com_easygallery\', \'2\', \'../administrator/components/com_easygallery/icons/16x16_image.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('62', 'Gestione immagini', '', '0', '59', 'option=com_easygallery&act=photos', 'Gestione immagini', 'com_easygallery', '2', '../administrator/components/com_easygallery/icons/16x16_image.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'63\' for key 1 SQL=INSERT INTO `jos_components` values (\'63\', \'LS Registrazione\', \'option=com_ls_registration\', \'0\', \'0\', \'option=com_ls_registration\', \'LS Registrazione\', \'com_ls_registration\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('63', 'LS Registrazione', 'option=com_ls_registration', '0', '0', 'option=com_ls_registration', 'LS Registrazione', 'com_ls_registration', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Duplicate entry \'64\' for key 1 SQL=INSERT INTO `jos_components` values (\'64\', \'Cerca nei contenuti\', \'option=com_backendcontentsearch\', \'0\', \'0\', \'option=com_backendcontentsearch\', \'Cerca nei contenuti\', \'com_backendcontentsearch\', \'0\', \'js/ThemeOffice/component.png\', \'0\', \'\'):
- - - - - - - - - -
INSERT INTO `#__components` values ('64', 'Cerca nei contenuti', 'option=com_backendcontentsearch', '0', '0', 'option=com_backendcontentsearch', 'Cerca nei contenuti', 'com_backendcontentsearch', '0', 'js/ThemeOffice/component.png', '0', '')
= = = = = = = = = =
SQL=Table \'jos_contact_details\' already exists SQL=# structure of table `jos_contact_details` ###\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:
- - - - - - - - - -
# structure of 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=# structure of table `jos_content` ###\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:
- - - - - - - - - -
# structure of 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=# structure of table `jos_content_frontpage` ###\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:
- - - - - - - - - -
# st
