错误记录写的是：
SQL=Table 'mos_banner' already exists:
- - - - - - - - - -
# $Id:
mambo.sql,v 1.19 2005/02/16 15:44:24 stingrey Exp $
# Table structure for table `mos_banner`
CREATE TABLE `mos_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 'mos_bannerclient' already exists:
- - - - - - - - - -
# Table structure for table `mos_bannerclient`
CREATE TABLE `mos_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 'mos_bannerfinish' already exists:
- - - - - - - - - -
# Table structure for table `mos_bannerfinish`
CREATE TABLE `mos_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 'mos_categories' already exists:
- - - - - - - - - -
# Table structure for table `mos_categories`
CREATE TABLE `mos_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 'mos_components' already exists:
- - - - - - - - - -
# Table structure for table `mos_components`
CREATE TABLE `mos_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:
- - - - - - - - - -
# Dumping data for table `mos_components`
INSERT INTO `mos_components` VALUES (1, '横幅广告', '', 0, 0, '', '横幅广告管理', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (2, '管理横幅广告', '', 0, 1, 'option=com_banners', '活路的横幅广告', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '3' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (3, '管理广告客户', '', 0, 1, 'option=com_banners&task=listclients', '管理广告客户', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '4' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (4, '网站链接', 'option=com_weblinks', 0, 0, '', '管理网站链接', 'com_weblinks', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '5' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (5, '网站链接条目', '', 0, 4, 'option=com_weblinks', '查看已有链接', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '6' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (6, '网站链接分类', '', 0, 4, 'option=categories§ion=com_weblinks', '管理网站链接分类', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '7' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (7, '
联系人', 'option=com_contact', 0, 0, '', '编辑
联系人资料', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '8' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (8, '管理联系人', '', 0, 7, 'option=com_contact', '编辑联系人资料', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '9' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (9, '联系人分类', '', 0, 7, 'option=categories§ion=com_contact_details', '管理联系人分类', '', 2, 'js/ThemeOffice/categories.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '10' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (10, '首页', 'option=com_frontpage', 0, 0, '', '管理首页显示条目', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '11' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (11, '在线调查', 'option=com_poll', 0, 0, 'option=com_poll', '管理在线调查', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '12' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (12, '新闻导入', 'option=com_newsfeeds', 0, 0, '', '新闻导入管理', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '13' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (13, '管理新闻导入', '', 0, 12, 'option=com_newsfeeds', '管理新闻导入', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '14' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (14, '管理新闻导入分类', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', '管理新闻导入分类', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '15' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (15, '登录', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '16' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (16, '站内搜索', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '17' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (17, '新闻联合','',0,0,'option=com_syndicate','管理网站新闻联合','com_syndicate',0,'js/ThemeOffice/component.png',0,'')
= = = = = = = = = =
SQL=Duplicate entry '18' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (18, '群发邮件', '', 0, 0, 'option=com_massmail&hidemainmenu=1', '群发邮件', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, '')
= = = = = = = = = =
SQL=Table 'mos_contact_details' already exists:
- - - - - - - - - -
# Table structure for table `mos_contact_details`
CREATE TABLE `mos_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 'mos_content' already exists:
- - - - - - - - - -
# Dumping data for table `mos_contact_details`
# Table structure for table `mos_content`
CREATE TABLE `mos_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 'mos_content_frontpage' already exists:
- - - - - - - - - -
# Table structure for table `mos_content_frontpage`
CREATE TABLE `mos_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 'mos_content_rating' already exists:
- - - - - - - - - -
# Table structure for table `mos_content_rating`
CREATE TABLE `mos_content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mos_core_log_items' already exists:
- - - - - - - - - -
# Table structure for table `mos_core_log_items`
# To be implemented in Version 4.6
CREATE TABLE `mos_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 'mos_core_log_searches' already exists:
- - - - - - - - - -
# Table structure for table `mos_core_log_searches`
# To be implemented in Version 4.6
CREATE TABLE `mos_core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mos_groups' already exists:
- - - - - - - - - -
# Table structure for table `mos_groups`
CREATE TABLE `mos_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:
- - - - - - - - - -
# Dumping data for table `mos_groups`
INSERT INTO `mos_groups` VALUES (0, 'Public')
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_groups` VALUES (1, 'Registered')
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_groups` VALUES (2, 'Special')
= = = = = = = = = =
SQL=Table 'mos_mambots' already exists:
- - - - - - - - - -
# Table structure for table `mos_mambots`
CREATE TABLE `mos_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
= = = = = = = = = =
