dopo aver inserito user.. nome database.. etc etc..
mi compare cio
[code]
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, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (5, 'Weblink Items', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '6' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (6, 'Weblink Categories', '', 0, 4, 'option=categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry '7' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (10, 'FrontPage', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '11' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '16' for key 1:
- - - - - - - - - -
INSERT INTO `mos_components` VALUES (16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry '17' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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 '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:
- - - - - - - - - -
# 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
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_mambots` VALUES (9,'No WYSIWYG Editor','none','editors',0,0,0,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry '10' for key 1:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
INSERT INTO `mos_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:
- - - - - - - - - -
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, 'Search 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, 'Load Module Positions', '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', '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')
= = = = = = = = = =
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, 'Polls', '', 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, 'User Menu', '', 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, 'Main Menu', '', 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, 'Login Form', '', 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, 'Syndicate', '', 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, 'Latest News', '', 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, 'Statistics', '', 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, 'Who\'s Online', '', 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, 'Popular', '', 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, 'Template Chooser','',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, 'Archive', '', 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, 'Sections', '', 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, 'Newsflash', '', 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, 'Related Items', '', 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, 'Search', '', 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, 'Random Image', '', 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, 'Top Menu', '', 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, 'Banners', '', 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, 'Other Menu', '', 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,'Logged','',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=Table 'mos_core_acl_aro' already exists:
- - - - - - - - - -
# 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);
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
# $Id: sample_data.sql,v 1.7 2005/02/16 15:44:24 stingrey Exp $
# Dumping data for table `mos_banner`
INSERT INTO `mos_banner` VALUES (1, 1, 'banner', 'Ka-Ching', 0, 42, 0, 'ka-chingBanner.gif', '
http://www.miro.com.au', '2004-07-07 15:31:29', 1, 0, '2000-00-00 00:00:00', NULL, NULL)
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_banner` VALUES (2, 1, 'banner', 'Oi!', 0, 48, 0, 'OiBanner.gif', '
http://www.miro.com.au', '2004-07-07 15:31:29', 1, 0, '2000-00-00 00:00:00', NULL, NULL)
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
# Dumping data for table `mos_bannerclient`
INSERT INTO `mos_bannerclient` VALUES (1, 'Miro International Pty.', 'Administrator', 'admin@miro.com.au', '', 0, '00:00:00', NULL)
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
# Dumping data for table `mos_categories`
INSERT INTO `mos_categories` VALUES (1, 0, 'Latest', 'Latest News', 'taking_notes.jpg', '1', 'left', 'The latest news from the Mambo Team', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 1, '')
= = = = = = = = = =
SQL=Duplicate entry '2' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (2, 0, 'Mambo', 'Mambo', 'clock.jpg', 'com_weblinks', 'left', 'A selection of links that are all related to the Mambo project.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '3' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (3, 0, 'Newsflash', 'Newsflash', '', '2', 'left', '', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '4' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (4, 0, 'Mambo', 'Mambo', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '5' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (5, 0, 'Business: general', 'Business: general', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '7' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (7, 0, 'Examples', 'Example FAQs', 'key.jpg', '3', 'left', 'Here you will find an example set of FAQs.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 2, '')
= = = = = = = = = =
SQL=Duplicate entry '9' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (9, 0, 'Finance', 'Finance', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '10' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (10, 0, 'Linux', 'Linux', '', 'com_newsfeeds', 'left', '
\r\n', 1, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '11' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (11, 0, 'Internet', 'Internet', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '12' for key 1:
- - - - - - - - - -
INSERT INTO `mos_categories` VALUES (12, 0, 'Contacts', 'Contacts', '', 'com_contact_details', 'left', 'Contact Details for this website', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '')
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
# Dumping data for table `mos_contact_details`
INSERT INTO `mos_contact_details` VALUES (1, 'Name', 'Position', 'Street', 'Suburb', 'State', 'Country', 'Zip Code', 'Telephone', 'Fax', 'Miscellanous info', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0)
= = = = = = = = = =
SQL=Duplicate entry '1' for key 1:
- - - - - - - - - -
# Dumping data for table `mos_content`
INSERT INTO `mos_content` VALUES (1, 'Welcome to Mambo', 'Welcome', 'If you''ve read anything at all about Content Management Systems (CMS), you''ll probably know at least three things: CMS are the most exciting way to do business, CMS can be really, I mean
really, complicated and lastly Portals are absolutely, outrageously, often
unaffordably expensive.
{mosimage}Mambo is set to change all that ... Mambo is different from the normal models for portal software. For a start, it''s not complicated. Mambo has been developed for the masses. It''s licensed under the GNU/GPL license, easy to install and administer and reliable. Mambo doesn''t even require the user or administrator of the system to know HTML to operate it once it''s up and running.', '<h4><font color="#ff6600">Mambo features:</font></h4>\r\n<ul>\r\n<li>Completely database driven site engins </li>\r\n<li>News, products or services sections fully editable and manageable</li> \r\n<li>Topics sections can be added to by contributing authors </li>\r\n<li>Fully customisable layouts including left, center and right menu boxes </li>\r\n<li>Browser upload of images to your own library for use anywhere in the site </li>\r\n<li>Dynamic Forum/Poll/Voting booth for on-the-spot results </li>\r\n<li>Runs on Linux, FreeBSD, MacOSX server, Solaris and AIX \r\n</li></ul>\r\n<h4>Extensive Administration:</h4>\r\n<ul>\r\n<li>Change order of objects including news, FAQs, articles etc. </li>\r\n<li>Random Newsflash generator </li>\r\n<li>Remote author submission module for News, Articles, FAQs and Links </li>\r\n<li>Object hierarchy - as many sections, departments, divisions and pages as you want </li>\r\n<li>Image library - store all your PNGs, PDFs, DOCs, XLSs, GIFs and JPEGs online for easy use </li>\r\n<li>Automatic Path-Finder. Place a picture and let Mambo fix the link </li>\r\n<li>News feed manager. Choose from over 360 news feeds from around the world </li>\r\n<li>Archive manager. Put your old articles into cold storage rather than throw them out </li>\r\n<li>Email-a-friend and Print-format for every story and article </li>\r\n<li>In-line Text editor similar to Word Pad </li>\r\n<li>User editable look and feel </li>\r\n<li>Polls/Surveys - Now put a different one on each page </li>\r\n<li>Custom Page Modules. Download custom page modules to spice up your site </li>\r\n<li>Template Manager. Download templates and implement them in seconds </li>\r\n<li>Layout preview. See how it looks before going live </li>\r\n<li>Banner manager. Make money out of your site</li></ul>', 1, 1, 0, 1, '2004-06-12 11:54:06', 62, 'Web Master', '2004-06-12 12:33:27', 62, 0, '0000-00-00 00:00:00'
