fehler bei homepagetitel unter joomla
lima-city → Forum → Die eigene Homepage → Homepage Allgemein
banner
date
detail
dumping
editor
email
front
hit
image
item
management
modul
not
null
option
page
position
text
type
weben
-
Bei der joomla installation kommt folgender fehler
nach dem man die datenbank sachen angegeben hat, muss man den namen eingaben und dan kommt dann die fehler meldung in einem kasten:
ausdem kommt das keine datein in die datenbank gschriben werden können
SQL=Table \\\'jos_banner\\\' already exists SQL=# $Id: joomla.sql 6072 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 6072 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, \\\'Banners\\\', \\\'\\\', 0, 0, \\\'\\\', \\\'Banner Management\\\', \\\'com_banners\\\', 0, \\\'js/ThemeOffice/component.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
# Dumping data for table `#__components`
INSERT INTO `#__components` VALUES (1, \'Banners\', \'\', 0, 0, \'\', \'Banner Management\', \'com_banners\', 0, \'js/ThemeOffice/component.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'2\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (2, \\\'Manage Banners\\\', \\\'\\\', 0, 1, \\\'option=com_banners\\\', \\\'Active Banners\\\', \\\'com_banners\\\', 1, \\\'js/ThemeOffice/edit.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (2, \'Manage Banners\', \'\', 0, 1, \'option=com_banners\', \'Active Banners\', \'com_banners\', 1, \'js/ThemeOffice/edit.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'3\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (3, \\\'Manage Clients\\\', \\\'\\\', 0, 1, \\\'option=com_banners&task=listclients\\\', \\\'Manage Clients\\\', \\\'com_banners\\\', 2, \\\'js/ThemeOffice/categories.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (3, \'Manage 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, \\\'Web Links\\\', \\\'option=com_weblinks\\\', 0, 0, \\\'\\\', \\\'Manage Weblinks\\\', \\\'com_weblinks\\\', 0, \\\'js/ThemeOffice/globe2.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (4, \'Web Links\', \'option=com_weblinks\', 0, 0, \'\', \'Manage Weblinks\', \'com_weblinks\', 0, \'js/ThemeOffice/globe2.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'5\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (5, \\\'Web Link Items\\\', \\\'\\\', 0, 4, \\\'option=com_weblinks\\\', \\\'View existing weblinks\\\', \\\'com_weblinks\\\', 1, \\\'js/ThemeOffice/edit.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (5, \'Web Link Items\', \'\', 0, 4, \'option=com_weblinks\', \'View existing weblinks\', \'com_weblinks\', 1, \'js/ThemeOffice/edit.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'6\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (6, \\\'Web Link Categories\\\', \\\'\\\', 0, 4, \\\'option=categories§ion=com_weblinks\\\', \\\'Manage weblink categories\\\', \\\'\\\', 2, \\\'js/ThemeOffice/categories.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (6, \'Web Link Categories\', \'\', 0, 4, \'option=categories§ion=com_weblinks\', \'Manage weblink categories\', \'\', 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, \\\'\\\', \\\'Edit contact details\\\', \\\'com_contact\\\', 0, \\\'js/ThemeOffice/user.png\\\', 1, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (7, \'Contacts\', \'option=com_contact\', 0, 0, \'\', \'Edit contact details\', \'com_contact\', 0, \'js/ThemeOffice/user.png\', 1, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'8\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (8, \\\'Manage Contacts\\\', \\\'\\\', 0, 7, \\\'option=com_contact\\\', \\\'Edit contact details\\\', \\\'com_contact\\\', 0, \\\'js/ThemeOffice/edit.png\\\', 1, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (8, \'Manage Contacts\', \'\', 0, 7, \'option=com_contact\', \'Edit contact details\', \'com_contact\', 0, \'js/ThemeOffice/edit.png\', 1, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'9\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (9, \\\'Contact Categories\\\', \\\'\\\', 0, 7, \\\'option=categories§ion=com_contact_details\\\', \\\'Manage contact categories\\\', \\\'\\\', 2, \\\'js/ThemeOffice/categories.png\\\', 1, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (9, \'Contact Categories\', \'\', 0, 7, \'option=categories§ion=com_contact_details\', \'Manage contact categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 1, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'10\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (10, \\\'Front Page\\\', \\\'option=com_frontpage\\\', 0, 0, \\\'\\\', \\\'Manage Front Page Items\\\', \\\'com_frontpage\\\', 0, \\\'js/ThemeOffice/component.png\\\', 1, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (10, \'Front Page\', \'option=com_frontpage\', 0, 0, \'\', \'Manage Front Page Items\', \'com_frontpage\', 0, \'js/ThemeOffice/component.png\', 1, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'11\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (11, \\\'Polls\\\', \\\'option=com_poll\\\', 0, 0, \\\'option=com_poll\\\', \\\'Manage Polls\\\', \\\'com_poll\\\', 0, \\\'js/ThemeOffice/component.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (11, \'Polls\', \'option=com_poll\', 0, 0, \'option=com_poll\', \'Manage Polls\', \'com_poll\', 0, \'js/ThemeOffice/component.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'12\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (12, \\\'News Feeds\\\', \\\'option=com_newsfeeds\\\', 0, 0, \\\'\\\', \\\'News Feeds Management\\\', \\\'com_newsfeeds\\\', 0, \\\'js/ThemeOffice/component.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (12, \'News Feeds\', \'option=com_newsfeeds\', 0, 0, \'\', \'News Feeds Management\', \'com_newsfeeds\', 0, \'js/ThemeOffice/component.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'13\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (13, \\\'Manage News Feeds\\\', \\\'\\\', 0, 12, \\\'option=com_newsfeeds\\\', \\\'Manage News Feeds\\\', \\\'com_newsfeeds\\\', 1, \\\'js/ThemeOffice/edit.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (13, \'Manage News Feeds\', \'\', 0, 12, \'option=com_newsfeeds\', \'Manage News Feeds\', \'com_newsfeeds\', 1, \'js/ThemeOffice/edit.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'14\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (14, \\\'Manage Categories\\\', \\\'\\\', 0, 12, \\\'option=com_categories§ion=com_newsfeeds\\\', \\\'Manage Categories\\\', \\\'\\\', 2, \\\'js/ThemeOffice/categories.png\\\', 0, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (14, \'Manage Categories\', \'\', 0, 12, \'option=com_categories§ion=com_newsfeeds\', \'Manage Categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'15\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (15, \\\'Login\\\', \\\'option=com_login\\\', 0, 0, \\\'\\\', \\\'\\\', \\\'com_login\\\', 0, \\\'\\\', 1, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (15, \'Login\', \'option=com_login\', 0, 0, \'\', \'\', \'com_login\', 0, \'\', 1, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'16\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (16, \\\'Search\\\', \\\'option=com_search\\\', 0, 0, \\\'\\\', \\\'\\\', \\\'com_search\\\', 0, \\\'\\\', 1, \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (16, \'Search\', \'option=com_search\', 0, 0, \'\', \'\', \'com_search\', 0, \'\', 1, \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'17\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (17, \\\'Syndicate\\\',\\\'\\\',0,0,\\\'option=com_syndicate&hidemainmenu=1\\\',\\\'Manage Syndication Settings\\\',\\\'com_syndicate\\\',0,\\\'js/ThemeOffice/component.png\\\',0,\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (17, \'Syndicate\',\'\',0,0,\'option=com_syndicate&hidemainmenu=1\',\'Manage Syndication Settings\',\'com_syndicate\',0,\'js/ThemeOffice/component.png\',0,\'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'18\\\' for key 1 SQL=INSERT INTO `jos_components` VALUES (18, \\\'Mass Mail\\\', \\\'\\\', 0, 0, \\\'option=com_massmail&hidemainmenu=1\\\', \\\'Send 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\', \'Send Mass Mail\', \'com_massmail\', 0, \'js/ThemeOffice/mass_email.png\', 0, \'\')
= = = = = = = = = =
SQL=Table \\\'jos_contact_details\\\' already exists SQL=# Table structure for table `jos_contact_details`\\n\\nCREATE TABLE `jos_contact_details` (\\n `id` int(11) NOT NULL auto_increment,\\n `name` varchar(100) NOT NULL default \\\'\\\',\\n `con_position` varchar(50) default NULL,\\n `address` text,\\n `suburb` varchar(50) default NULL,\\n `state` varchar(20) default NULL,\\n `country` varchar(50) default NULL,\\n `postcode` varchar(10) default NULL,\\n `telephone` varchar(25) default NULL,\\n `fax` varchar(25) default NULL,\\n `misc` mediumtext,\\n `image` varchar(100) default NULL,\\n `imagepos` varchar(20) default NULL,\\n `email_to` varchar(100) default NULL,\\n `default_con` tinyint(1) unsigned NOT NULL default \\\'0\\\',\\n `published` tinyint(1) unsigned NOT NULL default \\\'0\\\',\\n `checked_out` int(11) unsigned NOT NULL default \\\'0\\\',\\n `checked_out_time` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `ordering` int(11) NOT NULL default \\\'0\\\',\\n `params` text NOT NULL,\\n `user_id` int(11) NOT NULL default \\\'0\\\',\\n `catid` int(11) NOT NULL default \\\'0\\\',\\n `access` tinyint(3) unsigned NOT NULL default \\\'0\\\',\\n PRIMARY KEY (`id`)\\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__contact_details`
CREATE TABLE `#__contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default \'\',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default \'0\',
`published` tinyint(1) unsigned NOT NULL default \'0\',
`checked_out` int(11) unsigned NOT NULL default \'0\',
`checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
`ordering` int(11) NOT NULL default \'0\',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default \'0\',
`catid` int(11) NOT NULL default \'0\',
`access` tinyint(3) unsigned NOT NULL default \'0\',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \\\'jos_content\\\' already exists SQL=# Table structure for table `jos_content`\\n\\nCREATE TABLE `jos_content` (\\n `id` int(11) unsigned NOT NULL auto_increment,\\n `title` varchar(100) NOT NULL default \\\'\\\',\\n `title_alias` varchar(100) NOT NULL default \\\'\\\',\\n `introtext` mediumtext NOT NULL,\\n `fulltext` mediumtext NOT NULL,\\n `state` tinyint(3) NOT NULL default \\\'0\\\',\\n `sectionid` int(11) unsigned NOT NULL default \\\'0\\\',\\n `mask` int(11) unsigned NOT NULL default \\\'0\\\',\\n `catid` int(11) unsigned NOT NULL default \\\'0\\\',\\n `created` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `created_by` int(11) unsigned NOT NULL default \\\'0\\\',\\n `created_by_alias` varchar(100) NOT NULL default \\\'\\\',\\n `modified` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `modified_by` int(11) unsigned NOT NULL default \\\'0\\\',\\n `checked_out` int(11) unsigned NOT NULL default \\\'0\\\',\\n `checked_out_time` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `publish_up` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `publish_down` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `images` text NOT NULL,\\n `urls` text NOT NULL,\\n `attribs` text NOT NULL,\\n `version` int(11) unsigned NOT NULL default \\\'1\\\',\\n `parentid` int(11) unsigned NOT NULL default \\\'0\\\',\\n `ordering` int(11) NOT NULL default \\\'0\\\',\\n `metakey` text NOT NULL,\\n `metadesc` text NOT NULL,\\n `access` int(11) unsigned NOT NULL default \\\'0\\\',\\n `hits` int(11) unsigned NOT NULL default \\\'0\\\',\\n PRIMARY KEY (`id`),\\n KEY `idx_section` (`sectionid`),\\n KEY `idx_access` (`access`),\\n KEY `idx_checkout` (`checked_out`),\\n KEY `idx_state` (`state`),\\n KEY `idx_catid` (`catid`),\\n KEY `idx_mask` (`mask`)\\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content`
CREATE TABLE `#__content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default \'\',
`title_alias` varchar(100) NOT NULL default \'\',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default \'0\',
`sectionid` int(11) unsigned NOT NULL default \'0\',
`mask` int(11) unsigned NOT NULL default \'0\',
`catid` int(11) unsigned NOT NULL default \'0\',
`created` datetime NOT NULL default \'0000-00-00 00:00:00\',
`created_by` int(11) unsigned NOT NULL default \'0\',
`created_by_alias` varchar(100) NOT NULL default \'\',
`modified` datetime NOT NULL default \'0000-00-00 00:00:00\',
`modified_by` int(11) unsigned NOT NULL default \'0\',
`checked_out` int(11) unsigned NOT NULL default \'0\',
`checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
`publish_up` datetime NOT NULL default \'0000-00-00 00:00:00\',
`publish_down` datetime NOT NULL default \'0000-00-00 00:00:00\',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default \'1\',
`parentid` int(11) unsigned NOT NULL default \'0\',
`ordering` int(11) NOT NULL default \'0\',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default \'0\',
`hits` int(11) unsigned NOT NULL default \'0\',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \\\'jos_content_frontpage\\\' already exists SQL=# Table structure for table `jos_content_frontpage`\\n\\nCREATE TABLE `jos_content_frontpage` (\\n `content_id` int(11) NOT NULL default \\\'0\\\',\\n `ordering` int(11) NOT NULL default \\\'0\\\',\\n PRIMARY KEY (`content_id`)\\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_frontpage`
CREATE TABLE `#__content_frontpage` (
`content_id` int(11) NOT NULL default \'0\',
`ordering` int(11) NOT NULL default \'0\',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \\\'jos_content_rating\\\' already exists SQL=# Table structure for table `jos_content_rating`\\n\\nCREATE TABLE `jos_content_rating` (\\n `content_id` int(11) NOT NULL default \\\'0\\\',\\n `rating_sum` int(11) unsigned NOT NULL default \\\'0\\\',\\n `rating_count` int(11) unsigned NOT NULL default \\\'0\\\',\\n `lastip` varchar(50) NOT NULL default \\\'\\\',\\n PRIMARY KEY (`content_id`)\\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_rating`
CREATE TABLE `#__content_rating` (
`content_id` int(11) NOT NULL default \'0\',
`rating_sum` int(11) unsigned NOT NULL default \'0\',
`rating_count` int(11) unsigned NOT NULL default \'0\',
`lastip` varchar(50) NOT NULL default \'\',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \\\'jos_core_log_items\\\' already exists SQL=# Table structure for table `jos_core_log_items`\\n# To be implemented\\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, \\\'Registered\\\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (1, \'Registered\')
= = = = = = = = = =
SQL=Duplicate entry \\\'2\\\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (2, \\\'Special\\\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (2, \'Special\')
= = = = = = = = = =
SQL=Table \\\'jos_mambots\\\' already exists SQL=# Table structure for table `jos_mambots`\\n\\nCREATE TABLE `jos_mambots` (\\n `id` int(11) NOT NULL auto_increment,\\n `name` varchar(100) NOT NULL default \\\'\\\',\\n `element` varchar(100) NOT NULL default \\\'\\\',\\n `folder` varchar(100) NOT NULL default \\\'\\\',\\n `access` tinyint(3) unsigned NOT NULL default \\\'0\\\',\\n `ordering` int(11) NOT NULL default \\\'0\\\',\\n `published` tinyint(3) NOT NULL default \\\'0\\\',\\n `iscore` tinyint(3) NOT NULL default \\\'0\\\',\\n `client_id` tinyint(3) NOT NULL default \\\'0\\\',\\n `checked_out` int(11) unsigned NOT NULL default \\\'0\\\',\\n `checked_out_time` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `params` text NOT NULL,\\n PRIMARY KEY (`id`),\\n KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)\\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__mambots`
CREATE TABLE `#__mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default \'\',
`element` varchar(100) NOT NULL default \'\',
`folder` varchar(100) NOT NULL default \'\',
`access` tinyint(3) unsigned NOT NULL default \'0\',
`ordering` int(11) NOT NULL default \'0\',
`published` tinyint(3) NOT NULL default \'0\',
`iscore` tinyint(3) NOT NULL default \'0\',
`client_id` tinyint(3) NOT NULL default \'0\',
`checked_out` int(11) unsigned NOT NULL default \'0\',
`checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \\\'1\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (1,\\\'MOS Image\\\',\\\'mosimage\\\',\\\'content\\\',0,-10000,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (1,\'MOS Image\',\'mosimage\',\'content\',0,-10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'2\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (2,\\\'MOS Pagination\\\',\\\'mospaging\\\',\\\'content\\\',0,10000,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (2,\'MOS Pagination\',\'mospaging\',\'content\',0,10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'3\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (3,\\\'Legacy Mambot Includer\\\',\\\'legacybots\\\',\\\'content\\\',0,1,0,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (3,\'Legacy Mambot Includer\',\'legacybots\',\'content\',0,1,0,1,0,0,\'0000-00-00 00:00:00\',\'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'4\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (4,\\\'SEF\\\',\\\'mossef\\\',\\\'content\\\',0,3,1,0,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (4,\'SEF\',\'mossef\',\'content\',0,3,1,0,0,0,\'0000-00-00 00:00:00\',\'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'5\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (5,\\\'MOS Rating\\\',\\\'mosvote\\\',\\\'content\\\',0,4,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (5,\'MOS Rating\',\'mosvote\',\'content\',0,4,1,1,0,0,\'0000-00-00 00:00:00\',\'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'6\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (6,\\\'Search Content\\\',\\\'content.searchbot\\\',\\\'search\\\',0,1,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (6,\'Search Content\',\'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,\\\'Search Weblinks\\\',\\\'weblinks.searchbot\\\',\\\'search\\\',0,2,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (7,\'Search Weblinks\',\'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,\\\'No WYSIWYG Editor\\\',\\\'none\\\',\\\'editors\\\',0,0,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (9,\'No WYSIWYG Editor\',\'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,\\\'TinyMCE WYSIWYG Editor\\\',\\\'tinymce\\\',\\\'editors\\\',0,0,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'theme=advanced\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (10,\'TinyMCE WYSIWYG Editor\',\'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,\\\'MOS Image Editor Button\\\',\\\'mosimage.btn\\\',\\\'editors-xtd\\\',0,0,1,0,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (11,\'MOS Image Editor Button\',\'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,\\\'MOS Pagebreak Editor Button\\\',\\\'mospage.btn\\\',\\\'editors-xtd\\\',0,0,1,0,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (12,\'MOS Pagebreak Editor Button\',\'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,\\\'Search Contacts\\\',\\\'contacts.searchbot\\\',\\\'search\\\',0,3,1,1,0,0,\\\'0000-00-00 00:00:00\\\',\\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (13,\'Search 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, \\\'Search Categories\\\', \\\'categories.searchbot\\\', \\\'search\\\', 0, 4, 1, 0, 0, 0, \\\'0000-00-00 00:00:00\\\', \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (14, \'Search Categories\', \'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, \\\'Search Sections\\\', \\\'sections.searchbot\\\', \\\'search\\\', 0, 5, 1, 0, 0, 0, \\\'0000-00-00 00:00:00\\\', \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (15, \'Search 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, \\\'Search Newsfeeds\\\', \\\'newsfeeds.searchbot\\\', \\\'search\\\', 0, 6, 1, 0, 0, 0, \\\'0000-00-00 00:00:00\\\', \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (18, \'Search Newsfeeds\', \'newsfeeds.searchbot\', \'search\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\')
= = = = = = = = = =
SQL=Duplicate entry \\\'19\\\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (19, \\\'Load Module Positions\\\', \\\'mosloadposition\\\', \\\'content\\\', 0, 6, 1, 0, 0, 0, \\\'0000-00-00 00:00:00\\\', \\\'\\\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (19, \'Load Module Positions\', \'mosloadposition\', \'content\', 0, 6, 1, 0, 0, 0, \'0000-00-00 00:00:00\', \'\')
= = = = = = = = = =
SQL=Table \\\'jos_menu\\\' already exists SQL=# Table structure for table `jos_menu`\\n\\nCREATE TABLE `jos_menu` (\\n `id` int(11) NOT NULL auto_increment,\\n `menutype` varchar(25) default NULL,\\n `name` varchar(100) default NULL,\\n `link` text,\\n `type` varchar(50) NOT NULL default \\\'\\\',\\n `published` tinyint(1) NOT NULL default \\\'0\\\',\\n `parent` int(11) unsigned NOT NULL default \\\'0\\\',\\n `componentid` int(11) unsigned NOT NULL default \\\'0\\\',\\n `sublevel` int(11) default \\\'0\\\',\\n `ordering` int(11) default \\\'0\\\',\\n `checked_out` int(11) unsigned NOT NULL default \\\'0\\\',\\n `checked_out_time` datetime NOT NULL default \\\'0000-00-00 00:00:00\\\',\\n `pollid` int(11) NOT NULL default \\\'0\\\',\\n `browserNav` tinyint(4) default \\\'0\\\',\\n `access` tinyint(3) unsigned NOT NULL default \\\'0\\\',\\n `utaccess` tinyint(3) unsigned NOT NULL default \\\'0\\\',\\n `params` text NOT NULL,\\n PRIMARY KEY (`id`),\\n KEY `componentid` (`componentid`,`menutype`,`published`,`access`),\\n KEY `menutype` (`menutype`)\\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__menu`
CREATE TABLE `#__menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`type` varchar(50) NOT NULL default \'\',
`published` tinyint(1) NOT NULL default \'0\',
`parent` int(11) unsigned NOT NULL default \'0\',
`componentid` int(11) unsigned NOT NULL default \'0\',
`sublevel` int(11) default \'0\',
`ordering` int(11) default \'0\',
`checked_out` int(11) unsigned NOT NULL default \'0\',
`checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',
`pollid` int(11) NOT NULL default \'0\',
`browserNav` tinyint(4) default \'0\',
`access` tinyint(3) unsigned NOT NULL default \'0\',
`utaccess` tinyint(3) unsigned NOT NULL default \'0\',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \\\'1\\\' for key 1 SQL=INSERT INTO `jos_menu` VALUES (1, \\\'mainmenu\\\', \\\'Home\\\', \\\'index.php?option=com_frontpage\\\', \\\'components\\\', 1, 0, 10, 0, 1, 0, \\\'0000-00-00 00:00:00\\\', 0, 0, 0, 3, \\\'leading=1\\r\\nintro=2\\r\\nlink=1\\r\\nimage=1\\r\\npage_title=0\\r\\nheader=Welcome to the Frontpage\\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=Welcome to the Frontpage\\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 -
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!
lima-city: Gratis werbefreier Webspace für deine eigene Homepage