[问题]安装出现错误 帮我解决下
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=Invalid default value for 'rating_sum':
- - - - - - - - - -
# 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
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (1,'Mambo图片','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (2,'Mambo分页','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '3' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (3,'原有触发器置入','legacybots','content',0,1,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '4' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (4,'搜索引擎优化链接','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '5' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (5,'Mambo文章评级','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '6' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (6,'搜索内容','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '7' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (7,'搜索网站链接','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '8' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (8,'代码支持','moscode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '9' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (9,'非所见即所得编辑器','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '10' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (10,'TinyMCE所见即所得编辑器','tinymce','editors',0,0,0,0,0,0,'0000-00-00 00:00:00','theme=default')
= = = = = = = = = =
SQL=Duplicate entry '11' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (11,'Mambo图片编辑器按钮','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '12' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (12,'Mambo分页编辑器按钮','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '13' for key 1:
- - - - - - - - - -
INSERT INTO mos_mambots VALUES (13,'搜索联系人','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '14' for key 1:
- - - - - - - - - -
INSERT INTO `mos_mambots` VALUES (14, '搜索分类', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry '15' for key 1:
- - - - - - - - - -
INSERT INTO `mos_mambots` VALUES (15, '搜索单元', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry '16' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_mambots` VALUES (18, '搜索Newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Duplicate entry '19' for key 1:
- - - - - - - - - -
INSERT INTO `mos_mambots` VALUES (19, '读取模块位置', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '')
= = = = = = = = = =
SQL=Table 'mos_menu' already exists:
- - - - - - - - - -
# Table structure for table `mos_menu`
CREATE TABLE `mos_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:
- - - - - - - - - -
INSERT INTO `mos_menu` VALUES (1, 'mainmenu', '首页', '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=欢迎光临Mambo\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0')
= = = = = = = = = =
SQL=Table 'mos_messages' already exists:
- - - - - - - - - -
# Table structure for table `mos_messages`
CREATE TABLE `mos_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 'mos_messages_cfg' already exists:
- - - - - - - - - -
# Table structure for table `mos_messages_cfg`
CREATE TABLE `mos_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 'mos_modules' already exists:
- - - - - - - - - -
# Table structure for table `mos_modules`
CREATE TABLE `mos_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=Duplicate entry '1' for key 1:
- - - - - - - - - -
# Dumping data for table `mos_modules`
INSERT INTO `mos_modules` VALUES (1, '在线调查', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_poll', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (2, '用户菜单', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '3' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (3, '主菜单', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '4' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (4, '用户登录', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '5' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (5, '新闻联合', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_rssfeed', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '6' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (6, '最新文章', '', 4, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '7' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (7, '站点统计', '', 4, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_stats', 0, 0, 1, 'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '8' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (8, '在线情况', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '9' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (9, '热门文章', '', 6, 'user2', 0, '0000-00-00 00:00:00', 1, 'mod_mostread', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '10' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (10, '模版选择器','',6,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser', 0, 0, 1, 'show_preview=1', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '11' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (11, '文章存档', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '12' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (12, '文章单元', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '13' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (13, '新闻快讯', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '14' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (14, '相关文章', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '15' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (15, '站内搜索', '', 1, 'user4', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, '', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '16' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (16, '随机图片', '', 9, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '17' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (17, '顶部菜单', '', 1, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '18' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (18, '横幅广告', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0)
= = = = = = = = = =
SQL=Duplicate entry '31' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (31, '其它菜单', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=othermenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=', 0, 0)
= = = = = = = = = =
SQL=Duplicate entry '33' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules` VALUES (33,'记录','',0,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,99,1,'',0,1)
= = = = = = = = = =
SQL=Table 'mos_modules_menu' already exists:
- - - - - - - - - -
# Table structure for table `mos_modules_menu`
CREATE TABLE `mos_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:
- - - - - - - - - -
# Dumping data for table `mos_modules_menu`
INSERT INTO `mos_modules_menu` VALUES (1,1)
= = = = = = = = = =
SQL=Duplicate entry '2-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (2,0)
= = = = = = = = = =
SQL=Duplicate entry '3-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (3,0)
= = = = = = = = = =
SQL=Duplicate entry '4-1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (4,1)
= = = = = = = = = =
SQL=Duplicate entry '5-1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (5,1)
= = = = = = = = = =
SQL=Duplicate entry '6-1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (6,1)
= = = = = = = = = =
SQL=Duplicate entry '6-2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (6,2)
= = = = = = = = = =
SQL=Duplicate entry '6-4' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (6,4)
= = = = = = = = = =
SQL=Duplicate entry '6-27' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (6,27)
= = = = = = = = = =
SQL=Duplicate entry '6-36' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (6,36)
= = = = = = = = = =
SQL=Duplicate entry '8-1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (8,1)
= = = = = = = = = =
SQL=Duplicate entry '9-1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (9,1)
= = = = = = = = = =
SQL=Duplicate entry '9-2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (9,2)
= = = = = = = = = =
SQL=Duplicate entry '9-4' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (9,4)
= = = = = = = = = =
SQL=Duplicate entry '9-27' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (9,27)
= = = = = = = = = =
SQL=Duplicate entry '9-36' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (9,36)
= = = = = = = = = =
SQL=Duplicate entry '10-1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (10,1)
= = = = = = = = = =
SQL=Duplicate entry '13-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (13,0)
= = = = = = = = = =
SQL=Duplicate entry '15-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (15,0)
= = = = = = = = = =
SQL=Duplicate entry '17-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (17,0)
= = = = = = = = = =
SQL=Duplicate entry '18-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (18,0)
= = = = = = = = = =
SQL=Duplicate entry '31-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_modules_menu` VALUES (31, 0)
= = = = = = = = = =
SQL=Table 'mos_newsfeeds' already exists:
- - - - - - - - - -
# Table structure for table `mos_newsfeeds`
CREATE TABLE `mos_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 'mos_poll_data' already exists:
- - - - - - - - - -
# Table structure for table `mos_poll_data`
CREATE TABLE `mos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL default '',
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mos_poll_date' already exists:
- - - - - - - - - -
# Table structure for table `mos_poll_date`
CREATE TABLE `mos_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 'mos_polls' already exists:
- - - - - - - - - -
# Table structure for table `mos_polls`
CREATE TABLE `mos_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 'mos_poll_menu' already exists:
- - - - - - - - - -
# Table structure for table `mos_poll_menu`
CREATE TABLE `mos_poll_menu` (
`pollid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`pollid`,`menuid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mos_sections' already exists:
- - - - - - - - - -
# Table structure for table `mos_sections`
CREATE TABLE `mos_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 'mos_session' already exists:
- - - - - - - - - -
# Table structure for table `mos_session`
CREATE TABLE `mos_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 'mos_stats_agents' already exists:
- - - - - - - - - -
# Table structure for table `mos_stats_agents`
CREATE TABLE `mos_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 'mos_templates_menu' already exists:
- - - - - - - - - -
# Table structure for table `mos_templates_menu`
CREATE TABLE `mos_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:
- - - - - - - - - -
INSERT INTO `mos_templates_menu` VALUES ('rhuk_solarflare_ii', '0', '0')
= = = = = = = = = =
SQL=Duplicate entry 'mambo_admin_blue-0' for key 1:
- - - - - - - - - -
INSERT INTO `mos_templates_menu` VALUES ('mambo_admin_blue', '0', '1')
= = = = = = = = = =
SQL=Table 'mos_template_positions' already exists:
- - - - - - - - - -
# Table structure for table `mos_template_positions`
CREATE TABLE `mos_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 'mos_users' already exists:
- - - - - - - - - -
# Table structure for table `mos_users`
CREATE TABLE `mos_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 'mos_usertypes' already exists:
- - - - - - - - - -
# Table structure for table `mos_usertypes`
CREATE TABLE `mos_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:
- - - - - - - - - -
# Dumping data for table `mos_usertypes`
INSERT INTO `mos_usertypes` VALUES (0, 'superadministrator', '')
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_usertypes` VALUES (1, 'administrator', '')
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_usertypes` VALUES (2, 'editor', '')
= = = = = = = = = =
SQL=Duplicate entry '3' for key 1:
- - - - - - - - - -
INSERT INTO `mos_usertypes` VALUES (3, 'user', '')
= = = = = = = = = =
SQL=Duplicate entry '4' for key 1:
- - - - - - - - - -
INSERT INTO `mos_usertypes` VALUES (4, 'author', '')
= = = = = = = = = =
SQL=Duplicate entry '5' for key 1:
- - - - - - - - - -
INSERT INTO `mos_usertypes` VALUES (5, 'publisher', '')
= = = = = = = = = =
SQL=Duplicate entry '6' for key 1:
- - - - - - - - - -
INSERT INTO `mos_usertypes` VALUES (6, 'manager', '')
= = = = = = = = = =
SQL=Table 'mos_weblinks' already exists:
- - - - - - - - - -
# Table structure for table `mos_weblinks`
CREATE TABLE `mos_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=Specified key was too long; max key length is 1000 bytes:
- - - - - - - - - -
# Table structure for table `mos_core_acl_aro`
CREATE TABLE `mos_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 `section_value_value_aro` (`section_value`,`value`),
UNIQUE KEY `mos_gacl_section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`),
KEY `mos_gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mos_core_acl_aro_groups' already exists:
- - - - - - - - - -
# Table structure for table `mos_core_acl_aro_groups`
CREATE TABLE `mos_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 `mos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `mos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry '17' for key 1:
- - - - - - - - - -
# Dumping data for table `mos_core_acl_aro_groups`
INSERT INTO `mos_core_acl_aro_groups` VALUES (17,0,'ROOT',1,22)
= = = = = = = = = =
SQL=Duplicate entry '28' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (28,17,'USERS',2,21)
= = = = = = = = = =
SQL=Duplicate entry '29' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (29,28,'Public Frontend',3,12)
= = = = = = = = = =
SQL=Duplicate entry '18' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (18,29,'Registered',4,11)
= = = = = = = = = =
SQL=Duplicate entry '19' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (19,18,'Author',5,10)
= = = = = = = = = =
SQL=Duplicate entry '20' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (20,19,'Editor',6,9)
= = = = = = = = = =
SQL=Duplicate entry '21' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (21,20,'Publisher',7,8)
= = = = = = = = = =
SQL=Duplicate entry '30' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (30,28,'Public Backend',13,20)
= = = = = = = = = =
SQL=Duplicate entry '23' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (23,30,'Manager',14,19)
= = = = = = = = = =
SQL=Duplicate entry '24' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (24,23,'Administrator',15,18)
= = = = = = = = = =
SQL=Duplicate entry '25' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_groups` VALUES (25,24,'Super Administrator',16,17)
= = = = = = = = = =
SQL=Table 'mos_core_acl_groups_aro_map' already exists:
- - - - - - - - - -
# Table structure for table `mos_core_acl_groups_aro_map`
CREATE TABLE `mos_core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL default '0',
`section_value` varchar(240) NOT NULL default '',
`aro_id` int(11) NOT NULL default '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mos_core_acl_aro_sections' already exists:
- - - - - - - - - -
# Table structure for table `mos_core_acl_aro_sections`
CREATE TABLE `mos_core_acl_aro_sections` (
`section_id` int(11) NOT NULL auto_increment,
`value` varchar(230) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`section_id`),
UNIQUE KEY `value_aro_sections` (`value`),
UNIQUE KEY `mos_gacl_value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`),
KEY `mos_gacl_hidden_aro_sections` (`hidden`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry '10' for key 1:
- - - - - - - - - -
INSERT INTO `mos_core_acl_aro_sections` VALUES (10,'users',1,'Users',0);
= = = = = = = = = =
