Votre question

joomla URGENT !!

Tags :
  • Sql
  • Programmation
Dernière réponse : dans Programmation
16 Décembre 2007 11:53:48

Bonjour a tous, j'ai une erreur lorsque j'install Joomla a l'étape 2
Hier j'ai essayer et ca a marcher et la aujourd'hui ca ne marche plus
voici l'erreur :



SQL=Table \'jos_banner\' already exists SQL=# $Id: joomla.sql 6070 2006-12-20 02:09:09Z robs $\n\n# Table structure for table `jos_banner`\n\nCREATE TABLE `jos_banner` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'banner\',\n `name` varchar(50) NOT NULL default \'\',\n `imptotal` int(11) NOT NULL default \'0\',\n `impmade` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(100) NOT NULL default \'\',\n `clickurl` varchar(200) NOT NULL default \'\',\n `date` datetime default NULL,\n `showBanner` tinyint(1) NOT NULL default \'0\',\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `custombannercode` text,\n PRIMARY KEY (`bid`),\n KEY `viewbanner` (`showBanner`)\n) TYPE=MyISAM AUTO_INCREMENT=1:
- - - - - - - - - -
# $Id: joomla.sql 6070 2006-12-20 02:09:09Z robs $

# Table structure for table `#__banner`

CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM AUTO_INCREMENT=1
= = = = = = = = = =

SQL=Table \'jos_bannerclient\' already exists SQL=# Table structure for table `jos_bannerclient`\n\nCREATE TABLE `jos_bannerclient` (\n `cid` int(11) NOT NULL auto_increment,\n `name` varchar(60) NOT NULL default \'\',\n `contact` varchar(60) NOT NULL default \'\',\n `email` varchar(60) NOT NULL default \'\',\n `extrainfo` text NOT NULL,\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` time default NULL,\n `editor` varchar(50) default NULL,\n PRIMARY KEY (`cid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerclient`

CREATE TABLE `#__bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_bannerfinish\' already exists SQL=# Table structure for table `jos_bannerfinish`\n\nCREATE TABLE `jos_bannerfinish` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'\',\n `name` varchar(50) NOT NULL default \'\',\n `impressions` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(50) NOT NULL default \'\',\n `datestart` datetime default NULL,\n `dateend` datetime default NULL,\n PRIMARY KEY (`bid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerfinish`

CREATE TABLE `#__bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_categories\' already exists SQL=# Table structure for table `jos_categories`\n\nCREATE TABLE `jos_categories` (\n `id` int(11) NOT NULL auto_increment,\n `parent_id` int(11) NOT NULL default 0,\n `title` varchar(50) NOT NULL default \'\',\n `name` varchar(255) NOT NULL default \'\',\n `image` varchar(100) NOT NULL default \'\',\n `section` varchar(50) NOT NULL default \'\',\n `image_position` varchar(10) NOT NULL default \'\',\n `description` text NOT NULL,\n `published` tinyint(1) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `ordering` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `count` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `cat_idx` (`section`,`published`,`access`),\n KEY `idx_section` (`section`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__categories`

CREATE TABLE `#__categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_components\' already exists SQL=# Table structure for table `jos_components`\n\nCREATE TABLE `jos_components` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(50) NOT NULL default \'\',\n `link` varchar(255) NOT NULL default \'\',\n `menuid` int(11) unsigned NOT NULL default \'0\',\n `parent` int(11) unsigned NOT NULL default \'0\',\n `admin_menu_link` varchar(255) NOT NULL default \'\',\n `admin_menu_alt` varchar(255) NOT NULL default \'\',\n `option` varchar(50) NOT NULL default \'\',\n `ordering` int(11) NOT NULL default \'0\',\n `admin_menu_img` varchar(255) NOT NULL default \'\',\n `iscore` tinyint(4) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__components`

CREATE TABLE `#__components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'1\' for key 1 SQL=# Dumping data for table `jos_components`\n\nINSERT INTO `jos_components` VALUES (1, \'Bannières\', \'\', 0, 0, \'\', \'Gestion des bannières\', \'com_banners\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
# Dumping data for table `#__components`

INSERT INTO `#__components` VALUES (1, 'Bannières', '', 0, 0, '', 'Gestion des bannières', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_components` VALUES (2, \'Gérer les bannières\', \'\', 0, 1, \'option=com_banners\', \'Bannières actives\', \'com_banners\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (2, 'Gérer les bannières', '', 0, 1, 'option=com_banners', 'Bannières actives', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_components` VALUES (3, \'Gérer les clients\', \'\', 0, 1, \'option=com_banners&task=listclients\', \'Manage Clients\', \'com_banners\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (3, 'Gérer les clients', '', 0, 1, 'option=com_banners&task=listclients', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_components` VALUES (4, \'Liens web\', \'option=com_weblinks\', 0, 0, \'\', \'Gestion des liens web\', \'com_weblinks\', 0, \'js/ThemeOffice/globe2.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (4, 'Liens web', 'option=com_weblinks', 0, 0, '', 'Gestion des liens web', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_components` VALUES (5, \'Liens web\', \'\', 0, 4, \'option=com_weblinks\', \'Voir les liens web existantss\', \'com_weblinks\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (5, 'Liens web', '', 0, 4, 'option=com_weblinks', 'Voir les liens web existantss', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_components` VALUES (6, \'Catégories de liens web\', \'\', 0, 4, \'option=categories§ion=com_weblinks\', \'Gestion des catégories de liens web\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (6, 'Catégories de liens web', '', 0, 4, 'option=categories§ion=com_weblinks', 'Gestion des catégories de liens web', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_components` VALUES (7, \'Contacts\', \'option=com_contact\', 0, 0, \'\', \'Gestion des contacts\', \'com_contact\', 0, \'js/ThemeOffice/user.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (7, 'Contacts', 'option=com_contact', 0, 0, '', 'Gestion des contacts', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '')
= = = = = = = = = =

SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_components` VALUES (8, \'Gérer les contacts\', \'\', 0, 7, \'option=com_contact\', \'Editer les contacts\', \'com_contact\', 0, \'js/ThemeOffice/edit.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (8, 'Gérer les contacts', '', 0, 7, 'option=com_contact', 'Editer les contacts', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '')
= = = = = = = = = =

SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_components` VALUES (9, \'Catégories de contacts\', \'\', 0, 7, \'option=categories§ion=com_contact_details\', \'Gestion des catégories de contacts\', \'\', 2, \'js/ThemeOffice/categories.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (9, 'Catégories de contacts', '', 0, 7, 'option=categories§ion=com_contact_details', 'Gestion des catégories de contacts', '', 2, 'js/ThemeOffice/categories.png', 1, '')
= = = = = = = = = =

SQL=Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_components` VALUES (10, \'Page d’accueil\', \'option=com_frontpage\', 0, 0, \'\', \'Gestion des articles de la page d’accueil\', \'com_frontpage\', 0, \'js/ThemeOffice/component.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (10, 'Page d’accueil', 'option=com_frontpage', 0, 0, '', 'Gestion des articles de la page d’accueil', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =

SQL=Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_components` VALUES (11, \'Sondage\', \'option=com_poll\', 0, 0, \'option=com_poll\', \'Gestion des sondages\', \'com_poll\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (11, 'Sondage', 'option=com_poll', 0, 0, 'option=com_poll', 'Gestion des sondages', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_components` VALUES (12, \'Flux RSS\', \'option=com_newsfeeds\', 0, 0, \'\', \'Gestion des Flux RSS\', \'com_newsfeeds\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (12, 'Flux RSS', 'option=com_newsfeeds', 0, 0, '', 'Gestion des Flux RSS', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_components` VALUES (13, \'Gérer les flux RSS\', \'\', 0, 12, \'option=com_newsfeeds\', \'Gestion des Flux RSS\', \'com_newsfeeds\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (13, 'Gérer les flux RSS', '', 0, 12, 'option=com_newsfeeds', 'Gestion des Flux RSS', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_components` VALUES (14, \'Gérer les catégories\', \'\', 0, 12, \'option=com_categories§ion=com_newsfeeds\', \'Gestion des catégories\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (14, 'Gérer les catégories', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Gestion des catégories', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =

SQL=Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_components` VALUES (15, \'Identification\', \'option=com_login\', 0, 0, \'\', \'\', \'com_login\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (15, 'Identification', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '')
= = = = = = = = = =

SQL=Duplicate entry \'16\' for key 1 SQL=INSERT INTO `jos_components` VALUES (16, \'Recherche\', \'option=com_search\', 0, 0, \'\', \'\', \'com_search\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (16, 'Recherche', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '')
= = = = = = = = = =

SQL=Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_components` VALUES (17, \'Syndication\',\'\',0,0,\'option=com_syndicate&hidemainmenu=1\',\'Paramètres de syndication\',\'com_syndicate\',0,\'js/ThemeOffice/component.png\',0,\'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (17, 'Syndication','',0,0,'option=com_syndicate&hidemainmenu=1','Paramètres de syndication','com_syndicate',0,'js/ThemeOffice/component.png',0,'')
= = = = = = = = = =

SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_components` VALUES (18, \'Mailing\', \'\', 0, 0, \'option=com_massmail&hidemainmenu=1\', \'Envoyer un mailing\', \'com_massmail\', 0, \'js/ThemeOffice/mass_email.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (18, 'Mailing', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Envoyer un mailing', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, '')
= = = = = = = = = =

SQL=Table \'jos_contact_details\' already exists SQL=# Table structure for table `jos_contact_details`\n\nCREATE TABLE `jos_contact_details` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default \'\',\n `con_position` varchar(50) default NULL,\n `address` text,\n `suburb` varchar(50) default NULL,\n `state` varchar(20) default NULL,\n `country` varchar(50) default NULL,\n `postcode` varchar(10) default NULL,\n `telephone` varchar(25) default NULL,\n `fax` varchar(25) default NULL,\n `misc` mediumtext,\n `image` varchar(100) default NULL,\n `imagepos` varchar(20) default NULL,\n `email_to` varchar(100) default NULL,\n `default_con` tinyint(1) unsigned NOT NULL default \'0\',\n `published` tinyint(1) unsigned NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `ordering` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n `user_id` int(11) NOT NULL default \'0\',\n `catid` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__contact_details`

CREATE TABLE `#__contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_content\' already exists SQL=# Table structure for table `jos_content`\n\nCREATE TABLE `jos_content` (\n `id` int(11) unsigned NOT NULL auto_increment,\n `title` varchar(100) NOT NULL default \'\',\n `title_alias` varchar(100) NOT NULL default \'\',\n `introtext` mediumtext NOT NULL,\n `fulltext` mediumtext NOT NULL,\n `state` tinyint(3) NOT NULL default \'0\',\n `sectionid` int(11) unsigned NOT NULL default \'0\',\n `mask` int(11) unsigned NOT NULL default \'0\',\n `catid` int(11) unsigned NOT NULL default \'0\',\n `created` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `created_by` int(11) unsigned NOT NULL default \'0\',\n `created_by_alias` varchar(100) NOT NULL default \'\',\n `modified` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `modified_by` int(11) unsigned NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `publish_up` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `publish_down` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `images` text NOT NULL,\n `urls` text NOT NULL,\n `attribs` text NOT NULL,\n `version` int(11) unsigned NOT NULL default \'1\',\n `parentid` int(11) unsigned NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `metakey` text NOT NULL,\n `metadesc` text NOT NULL,\n `access` int(11) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `idx_section` (`sectionid`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`),\n KEY `idx_state` (`state`),\n KEY `idx_catid` (`catid`),\n KEY `idx_mask` (`mask`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content`

CREATE TABLE `#__content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_content_frontpage\' already exists SQL=# Table structure for table `jos_content_frontpage`\n\nCREATE TABLE `jos_content_frontpage` (\n `content_id` int(11) NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`content_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_frontpage`

CREATE TABLE `#__content_frontpage` (
`content_id` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_content_rating\' already exists SQL=# Table structure for table `jos_content_rating`\n\nCREATE TABLE `jos_content_rating` (\n `content_id` int(11) NOT NULL default \'0\',\n `rating_sum` int(11) unsigned NOT NULL default \'0\',\n `rating_count` int(11) unsigned NOT NULL default \'0\',\n `lastip` varchar(50) NOT NULL default \'\',\n PRIMARY KEY (`content_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_rating`

CREATE TABLE `#__content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '0',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_core_log_items\' already exists SQL=# Table structure for table `jos_core_log_items`\n# To be implemented\n\nCREATE TABLE `jos_core_log_items` (\n `time_stamp` date NOT NULL default \'0000-00-00\',\n `item_table` varchar(50) NOT NULL default \'\',\n `item_id` int(11) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'0\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_items`
# To be implemented

CREATE TABLE `#__core_log_items` (
`time_stamp` date NOT NULL default '0000-00-00',
`item_table` varchar(50) NOT NULL default '',
`item_id` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_core_log_searches\' already exists SQL=# Table structure for table `jos_core_log_searches`\n# To be implemented\n\nCREATE TABLE `jos_core_log_searches` (\n `search_term` varchar(128) NOT NULL default \'\',\n `hits` int(11) unsigned NOT NULL default \'0\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_searches`
# To be implemented

CREATE TABLE `#__core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_groups\' already exists SQL=# Table structure for table `jos_groups`\n\nCREATE TABLE `jos_groups` (\n `id` tinyint(3) unsigned NOT NULL default \'0\',\n `name` varchar(50) NOT NULL default \'\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__groups`

CREATE TABLE `#__groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'0\' for key 1 SQL=# Dumping data for table `jos_groups`\n\nINSERT INTO `jos_groups` VALUES (0, \'Public\'):
- - - - - - - - - -
# Dumping data for table `#__groups`

INSERT INTO `#__groups` VALUES (0, 'Public')
= = = = = = = = = =

SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (1, \'Membre\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (1, 'Membre')
= = = = = = = = = =

SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (2, \'Special\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (2, 'Special')
= = = = = = = = = =

SQL=Table \'jos_mambots\' already exists SQL=# Table structure for table `jos_mambots`\n\nCREATE TABLE `jos_mambots` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default \'\',\n `element` varchar(100) NOT NULL default \'\',\n `folder` varchar(100) NOT NULL default \'\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `published` tinyint(3) NOT NULL default \'0\',\n `iscore` tinyint(3) NOT NULL default \'0\',\n `client_id` tinyint(3) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__mambots`

CREATE TABLE `#__mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (1,\'MOS Image\',\'mosimage\',\'content\',0,-10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (2,\'MOS Pagination\',\'mospaging\',\'content\',0,10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (3,\'Legacy Mambot Includer\',\'legacybots\',\'content\',0,1,0,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (4,\'SEF\',\'mossef\',\'content\',0,3,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (5,\'MOS Rating\',\'mosvote\',\'content\',0,4,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (6,\'Recherche dans les articles\',\'content.searchbot\',\'search\',0,1,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (6,'Recherche dans les articles','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (7,\'Recherche dans les liens web\',\'weblinks.searchbot\',\'search\',0,2,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (7,'Recherche dans les liens web','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (8,\'Code support\',\'moscode\',\'content\',0,2,0,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (9,\'Aucun éditeur WYSIWYG\',\'none\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (9,'Aucun éditeur WYSIWYG','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (10,\'Editeur TinyMCE WYSIWYG\',\'tinymce\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'theme=advanced\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (10,'Editeur TinyMCE WYSIWYG','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced')
= = = = = = = = = =

SQL=Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (11,\'Bouton MOS Image éditeur\',\'mosimage.btn\',\'editors-xtd\',0,0,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (11,'Bouton MOS Image éditeur','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (12,\'Bouton MOS Pagebreak éditeur\',\'mospage.btn\',\'editors-xtd\',0,0,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (12,'Bouton MOS Pagebreak éditeur','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (13,\'Recherche dans les contacts\',\'contacts.searchbot\',\'search\',0,3,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (13,'Recherche dans les contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =

SQL=Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (14, \'Recherche dans les catégories\', \'categories.searchbot\', \'search\', 0, 4, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (14, 'Recherche dans les catégories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =

SQL=Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (15, \'Recherche dans les sections\', \'sections.searchbot\', \'search\', 0, 5, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (15, 'Recherche dans les sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =

SQL=Duplicate entry \'16\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (16, \'Email Cloaking\', \'mosemailcloak\', \'content\', 0, 5, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =

SQL=Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (17, \'GeSHi\', \'geshi\', \'content\', 0, 5, 0, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =

SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (18, \'Recherche dans les flux RSS\', \'newsfeeds.searchbot\', \'search\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (18, 'Recherche dans les flux RSS', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =

SQL=Duplicate entry \'19\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (19, \'Chargeur de positions de module\', \'mosloadposition\', \'content\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (19, 'Chargeur de positions de module', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =

SQL=Table \'jos_menu\' already exists SQL=# Table structure for table `jos_menu`\n\nCREATE TABLE `jos_menu` (\n `id` int(11) NOT NULL auto_increment,\n `menutype` varchar(25) default NULL,\n `name` varchar(100) default NULL,\n `link` text,\n `type` varchar(50) NOT NULL default \'\',\n `published` tinyint(1) NOT NULL default \'0\',\n `parent` int(11) unsigned NOT NULL default \'0\',\n `componentid` int(11) unsigned NOT NULL default \'0\',\n `sublevel` int(11) default \'0\',\n `ordering` int(11) default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `pollid` int(11) NOT NULL default \'0\',\n `browserNav` tinyint(4) default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `utaccess` tinyint(3) unsigned NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `componentid` (`componentid`,`menutype`,`published`,`access`),\n KEY `menutype` (`menutype`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__menu`

CREATE TABLE `#__menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`type` varchar(50) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`componentid` int(11) unsigned NOT NULL default '0',
`sublevel` int(11) default '0',
`ordering` int(11) default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL default '0',
`browserNav` tinyint(4) default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`utaccess` tinyint(3) unsigned NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_menu` VALUES (1, \'mainmenu\', \'Accueil\', \'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=Bienvenue sur la page d\\'accueil\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0\'):
- - - - - - - - - -
INSERT INTO `#__menu` VALUES (1, 'mainmenu', 'Accueil', '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=Bienvenue sur la page d\'accueil\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0')
= = = = = = = = = =

SQL=Table \'jos_messages\' already exists SQL=# Table structure for table `jos_messages`\n\nCREATE TABLE `jos_messages` (\n `message_id` int(10) unsigned NOT NULL auto_increment,\n `user_id_from` int(10) unsigned NOT NULL default \'0\',\n `user_id_to` int(10) unsigned NOT NULL default \'0\',\n `folder_id` int(10) unsigned NOT NULL default \'0\',\n `date_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `state` int(11) NOT NULL default \'0\',\n `priority` int(1) unsigned NOT NULL default \'0\',\n `subject` varchar(230) NOT NULL default \'\',\n `message` text NOT NULL,\n PRIMARY KEY (`message_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__messages`

CREATE TABLE `#__messages` (
`message_id` int(10) unsigned NOT NULL auto_increment,
`user_id_from` int(10) unsigned NOT NULL default '0',
`user_id_to` int(10) unsigned NOT NULL default '0',
`folder_id` int(10) unsigned NOT NULL default '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`state` int(11) NOT NULL default '0',
`priority` int(1) unsigned NOT NULL default '0',
`subject` varchar(230) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`message_id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_messages_cfg\' already exists SQL=# Table structure for table `jos_messages_cfg`\n\nCREATE TABLE `jos_messages_cfg` (\n `user_id` int(10) unsigned NOT NULL default \'0\',\n `cfg_name` varchar(100) NOT NULL default \'\',\n `cfg_value` varchar(255) NOT NULL default \'\',\n UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__messages_cfg`

CREATE TABLE `#__messages_cfg` (
`user_id` int(10) unsigned NOT NULL default '0',
`cfg_name` varchar(100) NOT NULL default '',
`cfg_value` varchar(255) NOT NULL default '',
UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_modules\' already exists SQL=# Table structure for table `jos_modules`\n\nCREATE TABLE `jos_modules` (\n `id` int(11) NOT NULL auto_increment,\n `title` text NOT NULL,\n `content` text NOT NULL,\n `ordering` int(11) NOT NULL default \'0\',\n `position` varchar(10) default NULL,\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `published` tinyint(1) NOT NULL default \'0\',\n `module` varchar(50) default NULL,\n `numnews` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `showtitle` tinyint(3) unsigned NOT NULL default \'1\',\n `params` text NOT NULL,\n `iscore` tinyint(4) NOT NULL default \'0\',\n `client_id` tinyint(4) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `published` (`published`,`access`),\n KEY `newsfeeds` (`module`,`published`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__modules`

CREATE TABLE `#__modules` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
`position` varchar(10) default NULL,
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`module` varchar(50) default NULL,
`numnews` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`showtitle` tinyint(3) unsigned NOT NULL default '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_modules_menu\' already exists SQL=# Table structure for table `jos_modules_menu`\n\nCREATE TABLE `jos_modules_menu` (\n `moduleid` int(11) NOT NULL default \'0\',\n `menuid` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`moduleid`,`menuid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__modules_menu`

CREATE TABLE `#__modules_menu` (
`moduleid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`moduleid`,`menuid`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'1-1\' for key 1 SQL=# Dumping data for table `jos_modules_menu`\n\nINSERT INTO `jos_modules_menu` VALUES (1,1):
- - - - - - - - - -
# Dumping data for table `#__modules_menu`

INSERT INTO `#__modules_menu` VALUES (1,1)
= = = = = = = = = =

SQL=Duplicate entry \'2-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (2,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (2,0)
= = = = = = = = = =

SQL=Duplicate entry \'3-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (3,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (3,0)
= = = = = = = = = =

SQL=Duplicate entry \'4-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (4,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (4,1)
= = = = = = = = = =

SQL=Duplicate entry \'5-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (5,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (5,1)
= = = = = = = = = =

SQL=Duplicate entry \'6-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,1)
= = = = = = = = = =

SQL=Duplicate entry \'6-2\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,2):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,2)
= = = = = = = = = =

SQL=Duplicate entry \'6-4\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,4):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,4)
= = = = = = = = = =

SQL=Duplicate entry \'6-27\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,27):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,27)
= = = = = = = = = =

SQL=Duplicate entry \'6-36\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (6,36):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (6,36)
= = = = = = = = = =

SQL=Duplicate entry \'8-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (8,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (8,1)
= = = = = = = = = =

SQL=Duplicate entry \'9-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,1)
= = = = = = = = = =

SQL=Duplicate entry \'9-2\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,2):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,2)
= = = = = = = = = =

SQL=Duplicate entry \'9-4\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,4):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,4)
= = = = = = = = = =

SQL=Duplicate entry \'9-27\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,27):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,27)
= = = = = = = = = =

SQL=Duplicate entry \'9-36\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (9,36):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (9,36)
= = = = = = = = = =

SQL=Duplicate entry \'10-1\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (10,1):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (10,1)
= = = = = = = = = =

SQL=Duplicate entry \'13-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (13,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (13,0)
= = = = = = = = = =

SQL=Duplicate entry \'15-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (15,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (15,0)
= = = = = = = = = =

SQL=Duplicate entry \'17-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (17,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (17,0)
= = = = = = = = = =

SQL=Duplicate entry \'18-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (18,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (18,0)
= = = = = = = = = =

SQL=Duplicate entry \'30-0\' for key 1 SQL=INSERT INTO `jos_modules_menu` VALUES (30,0):
- - - - - - - - - -
INSERT INTO `#__modules_menu` VALUES (30,0)
= = = = = = = = = =

SQL=Table \'jos_newsfeeds\' already exists SQL=# Table structure for table `jos_newsfeeds`\n\nCREATE TABLE `jos_newsfeeds` (\n `catid` int(11) NOT NULL default \'0\',\n `id` int(11) NOT NULL auto_increment,\n `name` text NOT NULL,\n `link` text NOT NULL,\n `filename` varchar(200) default NULL,\n `published` tinyint(1) NOT NULL default \'0\',\n `numarticles` int(11) unsigned NOT NULL default \'1\',\n `cache_time` int(11) unsigned NOT NULL default \'3600\',\n `checked_out` tinyint(3) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `ordering` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `published` (`published`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__newsfeeds`

CREATE TABLE `#__newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`link` text NOT NULL,
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` int(11) unsigned NOT NULL default '1',
`cache_time` int(11) unsigned NOT NULL default '3600',
`checked_out` tinyint(3) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_poll_data\' already exists SQL=# Table structure for table `jos_poll_data`\n\nCREATE TABLE `jos_poll_data` (\n `id` int(11) NOT NULL auto_increment,\n `pollid` int(4) NOT NULL default \'0\',\n `text` text NOT NULL,\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,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_poll_date\' already exists SQL=# Table structure for table `jos_poll_date`\n\nCREATE TABLE `jos_poll_date` (\n `id` bigint(20) NOT NULL auto_increment,\n `date` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `vote_id` int(11) NOT NULL default \'0\',\n `poll_id` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `poll_id` (`poll_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__poll_date`

CREATE TABLE `#__poll_date` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_polls\' already exists SQL=# Table structure for table `jos_polls`\n\nCREATE TABLE `jos_polls` (\n `id` int(11) unsigned NOT NULL auto_increment,\n `title` varchar(100) NOT NULL default \'\',\n `voters` int(9) NOT NULL default \'0\',\n `checked_out` int(11) NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `published` tinyint(1) NOT NULL default \'0\',\n `access` int(11) NOT NULL default \'0\',\n `lag` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__polls`

CREATE TABLE `#__polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`voters` int(9) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`lag` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_poll_menu\' already exists SQL=# Table structure for table `jos_poll_menu`\n\nCREATE TABLE `jos_poll_menu` (\n `pollid` int(11) NOT NULL default \'0\',\n `menuid` int(11) NOT NULL default \'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 \'jos_sections\' already exists SQL=# Table structure for table `jos_sections`\n\nCREATE TABLE `jos_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 \'jos_session\' already exists SQL=# Table structure for table `jos_session`\n\nCREATE TABLE `jos_session` (\n `username` varchar(50) default \'\',\n `time` varchar(14) default \'\',\n `session_id` varchar(200) NOT NULL default \'0\',\n `guest` tinyint(4) default \'1\',\n `userid` int(11) default \'0\',\n `usertype` varchar(50) default \'\',\n `gid` tinyint(3) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`session_id`),\n KEY `whosonline` (`guest`,`usertype`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__session`

CREATE TABLE `#__session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_stats_agents\' already exists SQL=# Table structure for table `jos_stats_agents`\n\nCREATE TABLE `jos_stats_agents` (\n `agent` varchar(255) NOT NULL default \'\',\n `type` tinyint(1) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'1\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__stats_agents`

CREATE TABLE `#__stats_agents` (
`agent` varchar(255) NOT NULL default '',
`type` tinyint(1) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '1'
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_templates_menu\' already exists SQL=# Table structure for table `jos_templates_menu`\n\nCREATE TABLE `jos_templates_menu` (\n `template` varchar(50) NOT NULL default \'\',\n `menuid` int(11) NOT NULL default \'0\',\n `client_id` tinyint(4) NOT NULL default \'0\',\n PRIMARY KEY (`template`,`menuid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__templates_menu`

CREATE TABLE `#__templates_menu` (
`template` varchar(50) NOT NULL default '',
`menuid` int(11) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`template`,`menuid`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'rhuk_solarflare_ii-0\' for key 1 SQL=INSERT INTO `jos_templates_menu` VALUES (\'rhuk_solarflare_ii\', \'0\', \'0\'):
- - - - - - - - - -
INSERT INTO `#__templates_menu` VALUES ('rhuk_solarflare_ii', '0', '0')
= = = = = = = = = =

SQL=Duplicate entry \'joomla_admin-0\' for key 1 SQL=INSERT INTO `jos_templates_menu` VALUES (\'joomla_admin\', \'0\', \'1\'):
- - - - - - - - - -
INSERT INTO `#__templates_menu` VALUES ('joomla_admin', '0', '1')
= = = = = = = = = =

SQL=Table \'jos_template_positions\' already exists SQL=# Table structure for table `jos_template_positions`\n\nCREATE TABLE `jos_template_positions` (\n `id` int(11) NOT NULL auto_increment,\n `position` varchar(10) NOT NULL default \'\',\n `description` varchar(255) NOT NULL default \'\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__template_positions`

CREATE TABLE `#__template_positions` (
`id` int(11) NOT NULL auto_increment,
`position` varchar(10) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_users\' already exists SQL=# Table structure for table `jos_users`\n\nCREATE TABLE `jos_users` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(50) NOT NULL default \'\',\n `username` varchar(25) NOT NULL default \'\',\n `email` varchar(100) NOT NULL default \'\',\n `password` varchar(100) NOT NULL default \'\',\n `usertype` varchar(25) NOT NULL default \'\',\n `block` tinyint(4) NOT NULL default \'0\',\n `sendEmail` tinyint(4) default \'0\',\n `gid` tinyint(3) unsigned NOT NULL default \'1\',\n `registerDate` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `lastvisitDate` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `activation` varchar(100) NOT NULL default \'\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `usertype` (`usertype`),\n KEY `idx_name` (`name`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__users`

CREATE TABLE `#__users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_usertypes\' already exists SQL=# Table structure for table `jos_usertypes`\n\nCREATE TABLE `jos_usertypes` (\n `id` tinyint(3) unsigned NOT NULL default \'0\',\n `name` varchar(50) NOT NULL default \'\',\n `mask` varchar(11) NOT NULL default \'\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__usertypes`

CREATE TABLE `#__usertypes` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`mask` varchar(11) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'0\' for key 1 SQL=# Dumping data for table `jos_usertypes`\n\nINSERT INTO `jos_usertypes` VALUES (0, \'superadministrator\', \'\'):
- - - - - - - - - -
# Dumping data for table `#__usertypes`

INSERT INTO `#__usertypes` VALUES (0, 'superadministrator', '')
= = = = = = = = = =

SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_usertypes` VALUES (1, \'administrator\', \'\'):
- - - - - - - - - -
INSERT INTO `#__usertypes` VALUES (1, 'administrator', '')
= = = = = = = = = =

SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_usertypes` VALUES (2, \'editor\', \'\'):
- - - - - - - - - -
INSERT INTO `#__usertypes` VALUES (2, 'editor', '')
= = = = = = = = = =

SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_usertypes` VALUES (3, \'user\', \'\'):
- - - - - - - - - -
INSERT INTO `#__usertypes` VALUES (3, 'user', '')
= = = = = = = = = =

SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_usertypes` VALUES (4, \'author\', \'\'):
- - - - - - - - - -
INSERT INTO `#__usertypes` VALUES (4, 'author', '')
= = = = = = = = = =

SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_usertypes` VALUES (5, \'publisher\', \'\'):
- - - - - - - - - -
INSERT INTO `#__usertypes` VALUES (5, 'publisher', '')
= = = = = = = = = =

SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_usertypes` VALUES (6, \'manager\', \'\'):
- - - - - - - - - -
INSERT INTO `#__usertypes` VALUES (6, 'manager', '')
= = = = = = = = = =

SQL=Table \'jos_weblinks\' already exists SQL=# Table structure for table `jos_weblinks`\n\nCREATE TABLE `jos_weblinks` (\n `id` int(11) unsigned NOT NULL auto_increment,\n `catid` int(11) NOT NULL default \'0\',\n `sid` int(11) NOT NULL default \'0\',\n `title` varchar(250) NOT NULL default \'\',\n `url` varchar(250) NOT NULL default \'\',\n `description` varchar(250) NOT NULL default \'\',\n `date` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `hits` int(11) NOT NULL default \'0\',\n `published` tinyint(1) 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 `ordering` int(11) NOT NULL default \'0\',\n `archived` tinyint(1) NOT NULL default \'0\',\n `approved` tinyint(1) NOT NULL default \'1\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `catid` (`catid`,`published`,`archived`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__weblinks`

CREATE TABLE `#__weblinks` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`url` varchar(250) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`published` tinyint(1) 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',
`ordering` int(11) NOT NULL default '0',
`archived` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '1',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`,`archived`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_core_acl_aro\' already exists SQL=# Table structure for table `jos_core_acl_aro`\n\nCREATE TABLE `jos_core_acl_aro` (\n `aro_id` int(11) NOT NULL auto_increment,\n `section_value` varchar(240) NOT NULL default \'0\',\n `value` varchar(240) NOT NULL default \'\',\n `order_value` int(11) NOT NULL default \'0\',\n `name` varchar(255) NOT NULL default \'\',\n `hidden` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`aro_id`),\n UNIQUE KEY `jos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)),\n KEY `jos_gacl_hidden_aro` (`hidden`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_acl_aro`

CREATE TABLE `#__core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `#__gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `#__gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'jos_core_acl_aro_groups\' already exists SQL=# Table structure for table `jos_core_acl_aro_groups`\nCREATE TABLE `jos_core_acl_aro_groups` (\n `group_id` int(11) NOT NULL auto_increment,\n `parent_id` int(11) NOT NULL default \'0\',\n `name` varchar(255) NOT NULL default \'\',\n `lft` int(11) NOT NULL default \'0\',\n `rgt` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`group_id`),\n KEY `parent_id_aro_groups` (`parent_id`),\n KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),\n KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_acl_aro_groups`
CREATE TABLE `#__core_acl_aro_groups` (
`group_id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`lft` int(11) NOT NULL default '0',
`rgt` int(11) NOT NULL default '0',
PRIMARY KEY (`group_id`),
KEY `parent_id_aro_groups` (`parent_id`),
KEY `#__gacl_parent_id_aro_groups` (`parent_id`),
KEY `#__gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=Duplicate entry \'17\' for key 1 SQL=# Dumping data for table `jos_core_acl_aro_groups`\nINSERT INTO `jos_core_acl_aro_groups` VALUES (17,0,\'ROOT\',1,22):
- - - - - - - - - -
# Dumping data for table `#__core_acl_aro_groups`
INSERT INTO `#__core_acl_aro_groups` VALUES (17,0,'ROOT',1,22)
= = = = = = = = = =

SQL=Duplicate entry \'28\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (28,17,\'USERS\',2,21):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (28,17,'USERS',2,21)
= = = = = = = = = =

SQL=Duplicate entry \'29\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (29,28,\'Public Frontend\',3,12):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (29,28,'Public Frontend',3,12)
= = = = = = = = = =

SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (18,29,\'Registered\',4,11):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (18,29,'Registered',4,11)
= = = = = = = = = =

SQL=Duplicate entry \'19\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (19,18,\'Author\',5,10):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (19,18,'Author',5,10)
= = = = = = = = = =

SQL=Duplicate entry \'20\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (20,19,\'Editor\',6,9):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (20,19,'Editor',6,9)
= = = = = = = = = =

SQL=Duplicate entry \'21\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (21,20,\'Publisher\',7,8):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (21,20,'Publisher',7,8)
= = = = = = = = = =

SQL=Duplicate entry \'30\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (30,28,\'Public Backend\',13,20):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (30,28,'Public Backend',13,20)
= = = = = = = = = =

SQL=Duplicate entry \'23\' for key 1 SQL=INSERT INTO `jos_core_acl_aro_groups` VALUES (23,30,\'Manager\',14,19):
- - - - - - - - - -
INSERT INTO `#__core_acl_aro_groups` VALUES (23,30,'Manager',14,19)
= = = = = = = = = =

SQL=Duplicate entry \'24\'

Autres pages sur : joomla urgent

Anonyme
16 Décembre 2007 12:01:18

Pourquoi tu veux l'installer deux fois ?
là l'installation a échoué parce que les tables existent déjà dans la base de donnée, vu que tu l'a installé hier..
Tom's guide dans le monde
  • Allemagne
  • Italie
  • Irlande
  • Royaume Uni
  • Etats Unis
Suivre Tom's Guide
Inscrivez-vous à la Newsletter
  • ajouter à twitter
  • ajouter à facebook
  • ajouter un flux RSS