mi viene un errore nel 2 passaggio... sapete dirmi cosa può essere'
SQL=Table \'my_banner\' already exists SQL=# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $\n\n# Table structure for table `my_banner`\n\nCREATE TABLE `my_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 \'my_bannerclient\' already exists SQL=# Table structure for table `my_bannerclient`\n\nCREATE TABLE `my_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 \'my_bannerfinish\' already exists SQL=# Table structure for table `my_bannerfinish`\n\nCREATE TABLE `my_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 \'my_categories\' already exists SQL=# Table structure for table `my_categories`\n\nCREATE TABLE `my_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 \'my_components\' already exists SQL=# Table structure for table `my_components`\n\nCREATE TABLE `my_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 `my_components`\n\nINSERT INTO `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 \'my_contact_details\' already exists SQL=# Table structure for table `my_contact_details`\n\nCREATE TABLE `my_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 \'my_content\' already exists SQL=# Table structure for table `my_content`\n\nCREATE TABLE `my_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 \'my_content_frontpage\' already exists SQL=# Table structure for table `my_content_frontpage`\n\nCREATE TABLE `my_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 \'my_content_rating\' already exists SQL=# Table structure for table `my_content_rating`\n\nCREATE TABLE `my_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 \'my_core_log_items\' already exists SQL=# Table structure for table `my_core_log_items`\n# To be implemented in Version 4.6\n\nCREATE TABLE `my_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 \'my_core_log_searches\' already exists SQL=# Table structure for table `my_core_log_searches`\n# To be implemented in Version 4.6\n\nCREATE TABLE `my_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 \'my_groups\' already exists SQL=# Table structure for table `my_groups`\n\nCREATE TABLE `my_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 `my_groups`\n\nINSERT INTO `my_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 `my_groups` VALUES (1, \'Registered\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (1, 'Registered')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `my_groups` VALUES (2, \'Special\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (2, 'Special')
= = = = = = = = = =
SQL=Table \'my_mambots\' already exists SQL=# Table structure for table `my_mambots`\n\nCREATE TABLE `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 `my_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 \'my_menu\' already exists SQL=# Table structure for table `my_menu`\n\nCREATE TABLE `my_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 `my_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 \'my_messages\' already exists SQL=# Table structure for table `my_messages`\n\nCREATE TABLE `my_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 \'my_messages_cfg\' already exists SQL=# Table structure for table `my_messages_cfg`\n\nCREATE TABLE `my_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 \'my_modules\' already exists SQL=# Table structure for table `my_modules`\n\nCREATE TABLE `my_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 \'my_modules_menu\' already exists SQL=# Table structure for table `my_modules_menu`\n\nCREATE TABLE `my_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 `my_modules_menu`\n\nINSERT INTO `my_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 `my_modules_menu` VALUES (2,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (2,0)
= = = = = = = = = =
SQL=Duplicate entry \'3-0\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (3,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (3,0)
= = = = = = = = = =
SQL=Duplicate entry \'4-1\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (4,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (4,1)
= = = = = = = = = =
SQL=Duplicate entry \'5-1\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (5,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (5,1)
= = = = = = = = = =
SQL=Duplicate entry \'6-1\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (6,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,1)
= = = = = = = = = =
SQL=Duplicate entry \'6-2\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (6,2):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,2)
= = = = = = = = = =
SQL=Duplicate entry \'6-4\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (6,4):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,4)
= = = = = = = = = =
SQL=Duplicate entry \'6-27\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (6,27):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,27)
= = = = = = = = = =
SQL=Duplicate entry \'6-36\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (6,36):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,36)
= = = = = = = = = =
SQL=Duplicate entry \'8-1\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (8,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (8,1)
= = = = = = = = = =
SQL=Duplicate entry \'9-1\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (9,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,1)
= = = = = = = = = =
SQL=Duplicate entry \'9-2\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (9,2):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,2)
= = = = = = = = = =
SQL=Duplicate entry \'9-4\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (9,4):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,4)
= = = = = = = = = =
SQL=Duplicate entry \'9-27\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (9,27):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,27)
= = = = = = = = = =
SQL=Duplicate entry \'9-36\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (9,36):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,36)
= = = = = = = = = =
SQL=Duplicate entry \'10-1\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (10,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (10,1)
= = = = = = = = = =
SQL=Duplicate entry \'13-0\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (13,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (13,0)
= = = = = = = = = =
SQL=Duplicate entry \'15-0\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (15,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (15,0)
= = = = = = = = = =
SQL=Duplicate entry \'17-0\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (17,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (17,0)
= = = = = = = = = =
SQL=Duplicate entry \'18-0\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (18,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (18,0)
= = = = = = = = = =
SQL=Duplicate entry \'30-0\' for key 1 SQL=INSERT INTO `my_modules_menu` VALUES (30,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (30,0)
= = = = = = = = = =
SQL=Table \'my_newsfeeds\' already exists SQL=# Table structure for table `my_newsfeeds`\n\nCREATE TABLE `my_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 \'my_poll_data\' already exists SQL=# Table structure for table `my_poll_data`\n\nCREATE TABLE `my_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 \'my_poll_date\' already exists SQL=# Table structure for table `my_poll_date`\n\nCREATE TABLE `my_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 \'my_polls\' already exists SQL=# Table structure for table `my_polls`\n\nCREATE TABLE `my_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 \'my_poll_menu\' already exists SQL=# Table structure for table `my_poll_menu`\n\nCREATE TABLE `my_poll_menu` (\n `pollid` int(11) NOT NULL default \'0\',\n `menuid` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`pollid`,`menuid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__poll_menu`
CREATE TABLE `#__poll_menu` (
`pollid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`pollid`,`menuid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'my_sections\' already exists SQL=# Table structure for table `my_sections`\n\nCREATE TABLE `my_sections` (\n `id` int(11) NOT NULL auto_increment,\n `title` varchar(50) NOT NULL default \'\',\n `name` varchar(255) NOT NULL default \'\',\n `image` varchar(100) NOT NULL default \'\',\n `scope` 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 `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 `idx_scope` (`scope`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__sections`
CREATE TABLE `#__sections` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`scope` 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',
`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 `idx_scope` (`scope`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'my_session\' already exists SQL=# Table structure for table `my_session`\n\nCREATE TABLE `my_sessio
