HTML-Code:
SQL=Table \'jos_banner\' already exists SQL=# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $\n\n# Table structure for table `jos_banner`\n\nCREATE TABLE `jos_banner` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'banner\',\n `name` varchar(50) NOT NULL default \'\',\n `imptotal` int(11) NOT NULL default \'0\',\n `impmade` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(100) NOT NULL default \'\',\n `clickurl` varchar(200) NOT NULL default \'\',\n `date` datetime default NULL,\n `showBanner` tinyint(1) NOT NULL default \'0\',\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `custombannercode` text,\n PRIMARY KEY (`bid`),\n KEY `viewbanner` (`showBanner`)\n) TYPE=MyISAM AUTO_INCREMENT=1:
- - - - - - - - - -
# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $
# Table structure for table `#__banner`
CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM AUTO_INCREMENT=1
= = = = = = = = = =
SQL=Table \'jos_bannerclient\' already exists SQL=# Table structure for table `jos_bannerclient`\n\nCREATE TABLE `jos_bannerclient` (\n `cid` int(11) NOT NULL auto_increment,\n `name` varchar(60) NOT NULL default \'\',\n `contact` varchar(60) NOT NULL default \'\',\n `email` varchar(60) NOT NULL default \'\',\n `extrainfo` text NOT NULL,\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` time default NULL,\n `editor` varchar(50) default NULL,\n PRIMARY KEY (`cid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerclient`
CREATE TABLE `#__bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_bannerfinish\' already exists SQL=# Table structure for table `jos_bannerfinish`\n\nCREATE TABLE `jos_bannerfinish` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'\',\n `name` varchar(50) NOT NULL default \'\',\n `impressions` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(50) NOT NULL default \'\',\n `datestart` datetime default NULL,\n `dateend` datetime default NULL,\n PRIMARY KEY (`bid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerfinish`
CREATE TABLE `#__bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_categories\' already exists SQL=# Table structure for table `jos_categories`\n\nCREATE TABLE `jos_categories` (\n `id` int(11) NOT NULL auto_increment,\n `parent_id` int(11) NOT NULL default 0,\n `title` varchar(50) NOT NULL default \'\',\n `name` varchar(255) NOT NULL default \'\',\n `image` varchar(100) NOT NULL default \'\',\n `section` varchar(50) NOT NULL default \'\',\n `image_position` varchar(10) NOT NULL default \'\',\n `description` text NOT NULL,\n `published` tinyint(1) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `ordering` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `count` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `cat_idx` (`section`,`published`,`access`),\n KEY `idx_section` (`section`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__categories`
CREATE TABLE `#__categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_components\' already exists SQL=# Table structure for table `jos_components`\n\nCREATE TABLE `jos_components` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(50) NOT NULL default \'\',\n `link` varchar(255) NOT NULL default \'\',\n `menuid` int(11) unsigned NOT NULL default \'0\',\n `parent` int(11) unsigned NOT NULL default \'0\',\n `admin_menu_link` varchar(255) NOT NULL default \'\',\n `admin_menu_alt` varchar(255) NOT NULL default \'\',\n `option` varchar(50) NOT NULL default \'\',\n `ordering` int(11) NOT NULL default \'0\',\n `admin_menu_img` varchar(255) NOT NULL default \'\',\n `iscore` tinyint(4) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__components`
CREATE TABLE `#__components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=# Dumping data for table `jos_components`\n\nINSERT INTO `jos_components` VALUES (1, \'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, \'\'):
[B].... Ich mach hier mal Stopp ich denke ihr wisst wie es weitergeht oder was mein Fehler ist?[/B]
ich wäre euch sehr dankbar, wenn ihr mir helfen könntet
Lesezeichen