rendered paste body-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 07-11-2007 a las 11:39:39
-- Versión del servidor: 5.0.32
-- Versión de PHP: 5.2.0-8+etch7
--
-- Base de datos: `MDFR_DB`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_banner`
--
CREATE TABLE `mos_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) collate latin1_spanish_ci NOT NULL default 'banner',
`name` varchar(50) collate latin1_spanish_ci 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) collate latin1_spanish_ci NOT NULL default '',
`clickurl` varchar(200) collate latin1_spanish_ci 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) collate latin1_spanish_ci default NULL,
`custombannercode` text collate latin1_spanish_ci,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=6 ;
--
-- Volcar la base de datos para la tabla `mos_banner`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_bannerclient`
--
CREATE TABLE `mos_bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) collate latin1_spanish_ci NOT NULL default '',
`contact` varchar(60) collate latin1_spanish_ci NOT NULL default '',
`email` varchar(60) collate latin1_spanish_ci NOT NULL default '',
`extrainfo` text collate latin1_spanish_ci NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) collate latin1_spanish_ci default NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=3 ;
--
-- Volcar la base de datos para la tabla `mos_bannerclient`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_bannerfinish`
--
CREATE TABLE `mos_bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) collate latin1_spanish_ci NOT NULL default '',
`name` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `mos_bannerfinish`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_categories`
--
CREATE TABLE `mos_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`name` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`image` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`section` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`image_position` varchar(10) collate latin1_spanish_ci NOT NULL default '',
`description` text collate latin1_spanish_ci 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) collate latin1_spanish_ci 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 collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=23 ;
--
-- Volcar la base de datos para la tabla `mos_categories`
--
INSERT INTO `mos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) 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, ''),
(20, 0, 'Categoria1', 'Categoria1', '', '6', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(21, 0, 'Productos de Belleza', 'Productos de Belleza', '', '7', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(22, 0, 'Circulación', 'Circulación', '', '7', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_comment`
--
CREATE TABLE `mos_comment` (
`id` int(11) NOT NULL auto_increment,
`articleid` int(11) NOT NULL default '0',
`ip` varchar(15) collate latin1_spanish_ci NOT NULL default '',
`name` varchar(30) collate latin1_spanish_ci NOT NULL default '',
`comments` text collate latin1_spanish_ci NOT NULL,
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `mos_comment`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_components`
--
CREATE TABLE `mos_components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`link` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`admin_menu_alt` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`option` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text collate latin1_spanish_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=29 ;
--
-- Volcar la base de datos para la tabla `mos_components`
--
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES
(1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, ''),
(2, 'Manage Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, ''),
(3, 'Manage Clients', '', 0, 1, 'option=com_banners&task=listclients', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, ''),
(4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Web Links', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, ''),
(5, 'Web Link Items', '', 0, 4, 'option=com_weblinks', 'View existing web links', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, ''),
(6, 'Web Link Categories', '', 0, 4, 'option=categories§ion=com_weblinks', 'Manage web link categories', '', 2, 'js/ThemeOffice/categories.png', 0, ''),
(7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, ''),
(8, 'Manage Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, ''),
(9, 'Contact Categories', '', 0, 7, 'option=categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, ''),
(10, 'FrontPage', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, ''),
(11, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, ''),
(12, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, ''),
(13, 'Manage News Feeds', '', 0, 12, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, ''),
(14, 'Manage Categories', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, ''),
(15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, ''),
(16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, ''),
(17, 'Syndicate', '', 0, 0, 'option=com_syndicate', 'Administrar distribución', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, 'cache=1\ncache_time=3600\ncount=5\ntitle=Medifarm\ndescription=Medifarm, productos medicos y cosmeticos en Venezuela\nimage_file=\nimage_alt=Medifarm\nlimit_text=1\ntext_length=20\norderby=front\nlive_bookmark=0\nbookmark_file='),
(18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Send Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, ''),
(19, 'MOStlyCE Admin', 'option=com_mostlyce', 0, 0, 'option=com_mostlyce', 'MOStlyCE Admin', 'com_mostlyce', 0, 'js/ThemeOffice/component.png', 0, ''),
(21, 'MOStlyDBAdmin DB Tools', 'option=com_mostlydbadmin', 0, 0, 'option=com_mostlydbadmin', 'MOStlyDBAdmin DB Tools', 'com_mostlydbadmin', 0, 'js/ThemeOffice/component.png', 0, ''),
(22, 'Backup Database', '', 0, 21, 'option=com_mostlydbadmin&act=option=com_mostlydbadmin&task=dbBackup', 'Backup Database', 'com_mostlydbadmin', 0, 'js/ThemeOffice/component.png', 0, ''),
(23, 'Restore Database', '', 0, 21, 'option=com_mostlydbadmin&act=option=com_mostlydbadmin&task=dbRestore', 'Restore Database', 'com_mostlydbadmin', 1, 'js/ThemeOffice/component.png', 0, ''),
(24, 'Query Database', '', 0, 21, 'option=com_mostlydbadmin&act=option=com_mostlydbadmin&task=xquery', 'Query Database', 'com_mostlydbadmin', 2, 'js/ThemeOffice/component.png', 0, ''),
(25, 'Comment', 'option=com_comment', 0, 0, 'option=com_comment', 'Comment', 'com_comment', 0, 'js/ThemeOffice/mainmenu.png', 0, ''),
(26, 'View Comments', '', 0, 25, 'option=com_comment&task=comments', 'View Comments', 'com_comment', 0, 'js/ThemeOffice/edit.png', 0, ''),
(27, 'Edit Settings', '', 0, 25, 'option=com_comment&task=settings', 'Edit Settings', 'com_comment', 1, 'js/ThemeOffice/config.png', 0, ''),
(28, 'swMenuFree', 'option=com_swmenufree', 0, 0, 'option=com_swmenufree', 'swMenuFree', 'com_swmenufree', 0, 'js/ThemeOffice/component.png', 0, '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_contact_details`
--
CREATE TABLE `mos_contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`con_position` varchar(50) collate latin1_spanish_ci default NULL,
`address` text collate latin1_spanish_ci,
`suburb` varchar(50) collate latin1_spanish_ci default NULL,
`state` varchar(20) collate latin1_spanish_ci default NULL,
`country` varchar(50) collate latin1_spanish_ci default NULL,
`postcode` varchar(10) collate latin1_spanish_ci default NULL,
`telephone` varchar(25) collate latin1_spanish_ci default NULL,
`fax` varchar(25) collate latin1_spanish_ci default NULL,
`misc` mediumtext collate latin1_spanish_ci,
`image` varchar(100) collate latin1_spanish_ci default NULL,
`imagepos` varchar(20) collate latin1_spanish_ci default NULL,
`email_to` varchar(100) collate latin1_spanish_ci 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 collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=3 ;
--
-- Volcar la base de datos para la tabla `mos_contact_details`
--
INSERT INTO `mos_contact_details` (`id`, `name`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`) VALUES
(2, 'Medifarm', '', '', 'Caracas', 'D.C.', 'Venezuela', '', '(0212) 7630568', '(0212) 7516691', '', '', NULL, 'info@medifarm.com', 0, 1, 0, '0000-00-00 00:00:00', 1, 'pageclass_sfx=\nprint=\nback_button=\nname=0\nposition=0\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nvcard=1\nimage=1\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=1\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=', 62, 12, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_containers`
--
CREATE TABLE `mos_containers` (
`id` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` smallint(6) NOT NULL default '0',
`childcount` int(11) NOT NULL default '0',
`name` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`title` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`windowtitle` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`keywords` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`icon` varchar(25) collate latin1_spanish_ci NOT NULL default '',
`description` text collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `mos_containers`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_content`
--
CREATE TABLE `mos_content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`title_alias` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`introtext` mediumtext collate latin1_spanish_ci NOT NULL,
`fulltext` mediumtext collate latin1_spanish_ci 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) collate latin1_spanish_ci 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 collate latin1_spanish_ci NOT NULL,
`urls` text collate latin1_spanish_ci NOT NULL,
`attribs` text collate latin1_spanish_ci 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 collate latin1_spanish_ci NOT NULL,
`metadesc` text collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=37 ;
--
-- Volcar la base de datos para la tabla `mos_content`
--
INSERT INTO `mos_content` (`id`, `title`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`) VALUES
(34, 'Cialis', 'Cialis', 'La información contenida en las siguientes secciones (artículo 15 de la\r\nley de garantías y uso<img src="images/stories/cialis10mg4comp2006.jpg" alt=" " width="120" height="120" align="right" /> racional de los medicamentos y productos\r\nsanitarios) está dirigida al profesional sanitario que ejerzan en\r\nEspaña y estén sometidos a la legislación española. Lilly no se hace\r\nresponsable del uso ilegal, indebido, o por la manipulación de los\r\ncontenidos e informaciones de esta página. Tanto el acceso a esta\r\ninformación como el uso que pueda hacerse de la información y\r\ncontenidos de la misma, será exlusivamente responsabilidad de quién lo\r\nrealice.\r\n', '', -2, 7, 0, 21, '2007-10-29 10:50:39', 62, '', '2007-10-29 10:51:27', 62, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 2, 0, 0, '', '', 0, 0),
(35, 'Zapao', '', 'kkkkk\r\n', '', -2, 7, 0, 21, '2007-10-29 10:55:00', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 0, '', '', 0, 0),
(36, 'Impotencia', 'Impotencia', '<img src="images/stories/cialis10mg4comp2006.jpg" alt=" " width="114" height="120" align="right" />Cialis contiene un ingrediente activo; Tadalafil que es una medicina utilizada \r\nen el tratamiento de la disfunción eréctil (impotencia). Tadalafil es un \r\ninhibidor que funciona previniendo la acción de un elemento químico del cuerpo \r\nllamado fosfodiesterasa-5 (PDE5). 5.<br />\r\nLa erección se produce a través de una \r\ncompleja cadena de sucesos, incluyendo señales del sistema nervioso y la \r\nliberación de mensajes químicos dentro de los tejidos del pene. Uno de estos \r\nmensajes químicos es denominado GMP cíclico.<br />\r\n<br />\r\nEl GMP cíclico causa que los \r\nvasos sanguíneos del pene se ensanchen y relajen, esto permite que entre más \r\nsangre en el pene con el resultado último de una erección.<br />\r\n<br />\r\n<br />\r\n', '', 1, 7, 0, 22, '2007-10-29 10:59:40', 62, '', '2007-10-29 11:02:15', 62, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 3, 0, 1, '', '', 0, 5),
(30, 'a', 'aa', '', '', -2, 6, 0, 20, '2007-10-29 08:54:10', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 0, '', '', 0, 0),
(31, 'Derma Tox', 'Derma Tox', '<p>\r\n<strong>This exciting revolutionary product temporarily achieves</strong> the radiant, young \r\nlooking skin you once<img src="images/stories/derma-tox.jpg" alt=" " width="188" height="205" align="right" /> had. Once applied Derma Tox immediately appears to tighten, \r\nsmooth lines as well as minimize the appearance of wrinkled skin on the neck and \r\nface. Use as often as you like, a non drying formula with miraculous results. \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\nThe cover up concealer helps give you long lasting coverage on the most stubborn \r\nskin imperfections. Simply apply to cover up freckles, blemishes, dark circles \r\nunder the eyes and any skin discoloration. The color is universal and will blend \r\nto match any skin pigmentation.\r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n', '', -2, 7, 0, 21, '2007-10-29 10:19:44', 62, '', '2007-10-29 10:42:17', 62, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 6, 0, 0, '', '', 0, 0),
(32, 'Medifarm', 'Medifarm', '<p>\r\n<img src="images/stories/565109376_ede344818f.jpg" alt=" " width="200" height="123" align="right" /><br />\r\n<font color="#000000"><strong>Misión:</strong> Atender y satisfacer las necesidades de salud de los consumidores venezolanos, mediante</font><font color="#000000"> productos farmacéuticos de calidad superior y excelentes precios</font><font color="#000000"> pensados específicamente para ellos, con la ayuda de un gran equipo de personas diligentes y enfocadas a lograrlo.</font><br />\r\n<br />\r\n<font color="#000000"><strong>Visión: </strong>Asegurarnos en la posición 36 del ranking farmacéutico de valores para diciembre del 2008, mediante la creación de mercados para afianzar los productos líderes, implementación de estrategias de impulso de nuevos productos tanto en la visita como en el punto de venta, la optimización del portafolio de productos y la consolidación de un excelente clima organizacional.</font>\r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<font color="#000000"></font>\r\n', '', 1, 7, 0, 21, '2007-10-29 10:40:31', 62, '', '2007-10-29 10:58:17', 62, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 8, 0, 2, '', '', 0, 0),
(33, 'Cialis', 'Cialis', '<p>\r\n<strong>This exciting revolutionary product temporarily achieves</strong> the radiant, young \r\nlooking skin you once<img src="images/stories/cialis10mg4comp2006.jpg" alt=" " width="110" height="120" align="right" /> had. Once applied Derma Tox immediately appears to tighten, \r\nsmooth lines as well as minimize the appearance of wrinkled skin on the neck and \r\nface. Use as often as you like, a non drying formula with miraculous results. \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\nThe cover up concealer helps give you long lasting coverage on the most stubborn \r\nskin imperfections. Simply apply to cover up freckles, blemishes, dark circles \r\nunder the eyes and any skin discoloration. The color is universal and will blend \r\nto match any skin pigmentation.\r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n<p>\r\n \r\n</p>\r\n', '', -2, 7, 0, 21, '2007-10-29 10:19:44', 62, '', '2007-10-29 10:47:10', 62, 0, '0000-00-00 00:00:00', '2007-10-29 04:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 3, 0, 0, '', '', 0, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_content_frontpage`
--
INSERT INTO `mos_content_frontpage` (`content_id`, `ordering`) VALUES
(35, 1),
(33, 3),
(32, 4),
(34, 2);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_content_rating`
--
CREATE TABLE `mos_content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '0',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) collate latin1_spanish_ci NOT NULL default '',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_content_rating`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_core_acl_aro`
--
CREATE TABLE `mos_core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) collate latin1_spanish_ci NOT NULL default '0',
`value` varchar(240) collate latin1_spanish_ci NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `mos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `mos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=11 ;
--
-- Volcar la base de datos para la tabla `mos_core_acl_aro`
--
INSERT INTO `mos_core_acl_aro` (`aro_id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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) collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=31 ;
--
-- Volcar la base de datos para la tabla `mos_core_acl_aro_groups`
--
INSERT INTO `mos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES
(17, 0, 'ROOT', 1, 22),
(28, 17, 'USERS', 2, 21),
(29, 28, 'Public Frontend', 3, 12),
(18, 29, 'Registered', 4, 11),
(19, 18, 'Author', 5, 10),
(20, 19, 'Editor', 6, 9),
(21, 20, 'Publisher', 7, 8),
(30, 28, 'Public Backend', 13, 20),
(23, 30, 'Manager', 14, 19),
(24, 23, 'Administrator', 15, 18),
(25, 24, 'Super Administrator', 16, 17);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_core_acl_aro_sections`
--
CREATE TABLE `mos_core_acl_aro_sections` (
`section_id` int(11) NOT NULL auto_increment,
`value` varchar(230) collate latin1_spanish_ci NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=11 ;
--
-- Volcar la base de datos para la tabla `mos_core_acl_aro_sections`
--
INSERT INTO `mos_core_acl_aro_sections` (`section_id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', 1, 'Users', 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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) collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_core_acl_groups_aro_map`
--
INSERT INTO `mos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(25, '', 10);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_core_log_items`
--
CREATE TABLE `mos_core_log_items` (
`time_stamp` date NOT NULL default '0000-00-00',
`item_table` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`item_id` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_core_log_items`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_core_log_searches`
--
CREATE TABLE `mos_core_log_searches` (
`search_term` varchar(128) collate latin1_spanish_ci NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_core_log_searches`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_groups`
--
CREATE TABLE `mos_groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) collate latin1_spanish_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_groups`
--
INSERT INTO `mos_groups` (`id`, `name`) VALUES
(0, 'Public'),
(1, 'Registered'),
(2, 'Special');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_mambots`
--
CREATE TABLE `mos_mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`element` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`folder` varchar(100) collate latin1_spanish_ci 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 collate latin1_spanish_ci,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=23 ;
--
-- Volcar la base de datos para la tabla `mos_mambots`
--
INSERT INTO `mos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'MOS Image', 'mosimage', 'content', 0, -10000, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(2, 'MOS Pagination', 'mospaging', 'content', 0, 10000, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(3, 'Legacy Mambot Includer', 'legacybots', 'content', 0, 1, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(4, 'SEF', 'mossef', 'content', 0, 3, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(5, 'MOS Rating', 'mosvote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(6, 'Search Content', 'content.searchbot', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(7, 'Search Web Links', 'weblinks.searchbot', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(8, 'Code support', 'moscode', 'content', 0, 2, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(9, 'No WYSIWYG Editor', 'none', 'editors', 0, 0, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(11, 'MOS Image Editor Button', 'mosimage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(12, 'MOS Pagebreak Editor Button', 'mospage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(13, 'Search Contacts', 'contacts.searchbot', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(14, 'Search Categories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(15, 'Search Sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(18, 'Search Newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(19, 'Load Module Positions', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(20, 'MOStlyCE', 'mostlyce', 'editors', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(21, 'User Authenticator', 'mosvaliduserbot', 'authenticator', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(22, 'MOS Comment', 'moscomment', 'content', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_menu`
--
CREATE TABLE `mos_menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) collate latin1_spanish_ci default NULL,
`name` varchar(100) collate latin1_spanish_ci default NULL,
`link` text collate latin1_spanish_ci,
`type` varchar(50) collate latin1_spanish_ci 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 collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=47 ;
--
-- Volcar la base de datos para la tabla `mos_menu`
--
INSERT INTO `mos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES
(1, 'mainmenu', 'Inicio', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 9, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nheader=\npage_title=0\nback_button=\nleading=1\nintro=2\ncolumns=2\nlink=3\norderby_pri=\norderby_sec=front\npagination=2\npagination_results=0\nimage=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0'),
(2, 'mainmenu', 'Busqueda Avanzada', 'index.php?option=com_search', 'components', 1, 0, 16, 0, 11, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=\npageclass_sfx=\nback_button=\npage_title=1\nheader='),
(3, 'mainmenu', 'Contactenos', 'index.php?option=com_contact', 'components', 1, 0, 7, 0, 12, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'pageclass_sfx=\nback_button=\npage_title=1\nheader=\nother_cat_section=1\nother_cat=1\ncat_description=1\ncat_items=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nheadings=1\nposition=1\nemail=0\ntelephone=1\nfax=1'),
(23, 'mainmenu', 'Links', 'index.php?option=com_weblinks', 'components', -2, 0, 4, 0, 8, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\nitem_description=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons='),
(5, 'mainmenu', 'Advanced Search', 'index.php?option=com_search', 'components', -2, 0, 16, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=\npageclass_sfx=\nback_button=\npage_title=1\nheader='),
(7, 'mainmenu', 'News Feeds', 'index.php?option=com_newsfeeds', 'components', -2, 0, 12, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=1\npage_title=1\nheader=\nother_cat_section=1\nother_cat=0\ncat_description=1\ncat_items=1\ndescription=1\ndescription_text=:: Explanatory Note -- This is a collection of RSS News Feeds, drawn into this site through use of the Newsfeed Component. ::\nimage=-1\nimage_align=right\nheadings=1\nname=1\narticles=1\nlink=0\nfeed_image=1\nfeed_descr=1\nitem_descr=1\nword_count=0'),
(8, 'mainmenu', 'Wrapper', 'index.php?option=com_wrapper', 'wrapper', -2, 0, 0, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=This uses a wrapper to include an HTML page from another domain.\nscrolling=auto\nwidth=100%\nheight=600\nheight_auto=1\nadd=1\nurl=www.dmoz.org'),
(9, 'mainmenu', 'Blog', 'index.php?option=com_content&task=blogsection&id=0', 'content_blog_section', -2, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=Blog - Content Section Layout\npage_title=1\nleading=0\nintro=5\ncolumns=1\nlink=5\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=1\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0\nsectionid='),
(36, 'othermenu', 'Mambo Foundation', 'http://mambo-foundation.org', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''),
(37, 'othermenu', 'Mambo Forums', 'http://forum.mambo-foundation.org', 'url', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''),
(38, 'othermenu', 'Mambo Docs Site', 'http://docs.mambo-foundation.org', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''),
(10, 'othermenu', 'The Source', 'http://source.mambo-foundation.org', 'url', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''),
(11, 'othermenu', 'Administrator', 'administrator/', 'url', 1, 0, 0, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1'),
(12, 'othermenu', 'MamboXchange', 'http://mamboxchange.com', 'url', 1, 0, 0, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''),
(21, 'usermenu', 'Your Details', 'index.php?option=com_user&task=UserDetails', 'url', 1, 0, 0, 0, 1, 0, '2000-00-00 00:00:00', 0, 0, 1, 3, ''),
(13, 'usermenu', 'Submit FAQ', 'index.php?option=com_content&task=new§ionid=3', 'url', 1, 0, 0, 0, 2, 0, '2000-00-00 00:00:00', 0, 0, 1, 2, ''),
(14, 'usermenu', 'Submit Web Link', 'index.php?option=com_weblinks&task=new', 'url', 1, 0, 0, 0, 4, 0, '2000-00-00 00:00:00', 0, 0, 1, 2, ''),
(15, 'usermenu', 'Check-In My Items', 'index.php?option=com_user&task=CheckIn', 'url', 1, 0, 0, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 2, ''),
(16, 'usermenu', 'Logout', 'index.php?option=com_login', 'components', 1, 0, 15, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, ''),
(32, 'mainmenu', 'Preguntas Frecuentes', 'index.php?option=com_content&task=section&id=3', 'content_section', -2, 0, 3, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=0\npageclass_sfx=\nback_button=\norderby=\nother_cat_section=1\ndescription=1\ndescription_image=0\nother_cat=0\nempty_cat=0\ncat_items=1\ncat_description=0\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=0\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title'),
(26, 'mainmenu', 'The Mambo License', 'index.php?option=com_content&task=view&id=5', 'content_typed', -2, 0, 5, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(27, 'mainmenu', 'Getting Started', 'index.php?option=com_content&task=category§ionid=4&id=16', 'content_category', -2, 0, 16, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=0\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=0\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1'),
(28, 'topmenu', 'Inicio', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nheader=\npage_title=1\nback_button=\nleading=1\nintro=2\ncolumns=2\nlink=3\norderby_pri=\norderby_sec=front\npagination=2\npagination_results=1\nimage=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0'),
(29, 'topmenu', 'Links', 'index.php?option=com_weblinks', 'components', 1, 0, 4, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\nitem_description=1\nother_cat_section=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons='),
(30, 'topmenu', 'Contact Us', 'index.php?option=com_contact&task=view&contact_id=1', 'contact_item_link', 1, 0, 1, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\npage_title=1\nheader='),
(33, 'mainmenu', 'Mambo and Security', 'index.php?option=com_content&task=category§ionid=3&id=18', 'content_category', -2, 32, 18, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=0\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=0\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=0\nempty_cat=0\ncat_items=1\ncat_description=0'),
(34, 'mainmenu', 'Managing Content', 'index.php?option=com_content&task=category§ionid=3&id=19', 'content_category', -2, 32, 19, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=0\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=0\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=0\nempty_cat=0\ncat_items=1\ncat_description=0'),
(35, 'mainmenu', 'Managing Users', 'index.php?option=com_content&task=category§ionid=3&id=17', 'content_category', -2, 32, 17, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=0\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=0\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=0\nempty_cat=0\ncat_items=1\ncat_description=0'),
(39, 'mainmenu', 'Enlace 1', 'index.php?option=com_frontpage&Itemid=1', 'component_item_link', 1, 1, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(40, 'mainmenu', 'Enlace 2', 'index.php?option=com_weblinks&Itemid=29', 'component_item_link', 1, 1, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(41, 'mainmenu', 'Enlace 3', 'index.php?option=com_search&Itemid=5', 'component_item_link', 1, 1, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(43, 'mainmenu', 'Productos', 'index.php?option=com_search&Itemid=2', 'component_item_link', 1, 0, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(42, 'mainmenu', 'Enlace 4', 'index.php?option=com_contact&Itemid=3', 'component_item_link', 1, 1, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(44, 'mainmenu', 'Productos 1', 'index.php?option=com_search&Itemid=2', 'component_item_link', -2, 43, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(45, 'mainmenu', 'Producto 2', 'index.php?option=com_search&Itemid=2', 'component_item_link', -2, 43, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(46, 'mainmenu', 'Circulacion', 'index.php?option=com_content&task=view&id=36', 'content_item_link', 1, 43, 36, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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) collate latin1_spanish_ci NOT NULL default '',
`message` text collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `mos_messages`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_messages_cfg`
--
CREATE TABLE `mos_messages_cfg` (
`user_id` int(10) unsigned NOT NULL default '0',
`cfg_name` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`cfg_value` varchar(255) collate latin1_spanish_ci NOT NULL default '',
UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_messages_cfg`
--
INSERT INTO `mos_messages_cfg` (`user_id`, `cfg_name`, `cfg_value`) VALUES
(62, 'lock', '0'),
(62, 'mail_on_new', '0');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_modules`
--
CREATE TABLE `mos_modules` (
`id` int(11) NOT NULL auto_increment,
`title` text collate latin1_spanish_ci NOT NULL,
`content` text collate latin1_spanish_ci NOT NULL,
`ordering` int(11) NOT NULL default '0',
`position` varchar(10) collate latin1_spanish_ci 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) collate latin1_spanish_ci 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 collate latin1_spanish_ci,
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=36 ;
--
-- Volcar la base de datos para la tabla `mos_modules`
--
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES
(1, 'Polls', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_poll', 0, 0, 0, 'cache=0\nmoduleclass_sfx=', 0, 0),
(2, 'User Menu', '', 3, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0),
(3, 'Main Menu', '', 2, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 0, 0, 'class_sfx=\nmoduleclass_sfx=\nmenutype=mainmenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0),
(4, 'Login Form', '', 5, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 0, 'moduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\nlogin_message=0\nlogout_message=0\ngreeting=1\nname=0', 1, 0),
(5, 'Syndicate', '', 6, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_rssfeed', 0, 0, 1, 'text=\ncache=0\nmoduleclass_sfx=\nrss091=1\nrss10=1\nrss20=1\natom=1\nopml=1\nrss091_image=\nrss10_image=\nrss20_image=\natom_image=\nopml_image=', 1, 0),
(6, 'Latest News', '', 1, 'user2', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, 'moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=', 1, 0),
(7, 'Statistics', '', 7, '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),
(8, 'Who''s Online', '', 3, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0),
(9, 'Popular', '', 1, 'user3', 0, '0000-00-00 00:00:00', 0, 'mod_mostread', 0, 0, 1, 'moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=\nhits=1', 0, 0),
(10, 'Template Chooser', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_templatechooser', 0, 0, 1, 'show_preview=1', 0, 0),
(11, 'Archive', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0),
(12, 'Sections', '', 10, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0),
(13, 'Newsflash', '', 1, 'newsflash', 0, '0000-00-00 00:00:00', 1, 'mod_newsflash', 0, 0, 0, 'catid=3\nstyle=random\nimage=0\nlink_titles=\nreadmore=0\nitem_title=0\nitems=\ncache=0\nmoduleclass_sfx=', 0, 0),
(14, 'Related Items', '', 11, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0),
(15, 'Busqueda', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nwidth=20\ntext=\nbutton=1\nbutton_pos=right\nbutton_text=', 0, 0),
(16, 'Random Image', '', 4, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_random_image', 0, 0, 1, '', 0, 0),
(17, 'Top Menu', '', 2, 'top', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 0, 0, 'class_sfx=-nav\nmoduleclass_sfx=\nmenutype=topmenu\nmenu_style=list_flat\ncache=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0),
(18, 'Banners', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0),
(19, 'Components', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_components', 0, 99, 1, '', 1, 1),
(20, 'Popular', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 99, 1, '', 0, 1),
(21, 'Latest Items', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 99, 1, '', 0, 1),
(22, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 99, 1, '', 0, 1),
(23, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 99, 1, '', 1, 1),
(24, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 99, 1, '', 1, 1),
(25, 'Full Menu', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_fullmenu', 0, 99, 1, '', 1, 1),
(26, 'Pathway', '', 1, 'pathway', 0, '0000-00-00 00:00:00', 1, 'mod_pathway', 0, 99, 1, '', 1, 1),
(27, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 99, 1, '', 1, 1),
(28, 'System Message', '', 1, 'inset', 0, '0000-00-00 00:00:00', 1, 'mod_mosmsg', 0, 99, 1, '', 1, 1),
(29, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 99, 1, '', 1, 1),
(31, 'Other Menu', '', 4, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 0, 1, '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),
(32, 'Wrapper', '', 12, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0),
(33, 'Logged', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 99, 1, '', 0, 1),
(34, 'Latest Content', '', 13, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_latestcontent', 0, 0, 1, '', 0, 0),
(35, 'menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_swmenufree', 0, 0, 0, 'menutype=mainmenu\nmenustyle=transmenu\nmoduleID=35\nlevels=0\nparentid=0\nparent_level=0\nhybrid=0\nactive_menu=0\ntables=0\ncssload=0\nsub_indicator=1\nselectbox_hack=0\nshow_shadow=1\ncache=0\ncache_time=1 hour\nmoduleclass_sfx=\neditor_hack=0\ntemplate=All\nlanguage=\ncomponent=All\n', 0, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_modules_menu`
--
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES
(1, 1),
(2, 0),
(3, 0),
(4, 1),
(5, 1),
(6, 1),
(6, 27),
(8, 1),
(9, 1),
(9, 27),
(10, 1),
(13, 0),
(15, 0),
(17, 0),
(18, 0),
(31, 0),
(35, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_newsfeeds`
--
CREATE TABLE `mos_newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text collate latin1_spanish_ci NOT NULL,
`link` text collate latin1_spanish_ci NOT NULL,
`filename` varchar(200) collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=23 ;
--
-- Volcar la base de datos para la tabla `mos_newsfeeds`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_parameters`
--
CREATE TABLE `mos_parameters` (
`id` int(11) NOT NULL auto_increment,
`param_name` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`param_file` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`param_version` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`params` text collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `names` (`param_name`,`param_version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `mos_parameters`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_poll_data`
--
CREATE TABLE `mos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text collate latin1_spanish_ci NOT NULL,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=25 ;
--
-- Volcar la base de datos para la tabla `mos_poll_data`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=2 ;
--
-- Volcar la base de datos para la tabla `mos_poll_date`
--
INSERT INTO `mos_poll_date` (`id`, `date`, `vote_id`, `poll_id`) VALUES
(1, '2005-11-19 09:30:51', 17, 15);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_poll_menu`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_polls`
--
CREATE TABLE `mos_polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) collate latin1_spanish_ci 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=16 ;
--
-- Volcar la base de datos para la tabla `mos_polls`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_sections`
--
CREATE TABLE `mos_sections` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`name` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`image` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`scope` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`image_position` varchar(10) collate latin1_spanish_ci NOT NULL default '',
`description` text collate latin1_spanish_ci 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 collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=8 ;
--
-- Volcar la base de datos para la tabla `mos_sections`
--
INSERT INTO `mos_sections` (`id`, `title`, `name`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES
(6, 'Seccion1', 'Seccion1', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 2, 0, 1, ''),
(7, 'Productos', 'Productos', 'opensource-110x95.png', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 1, 0, 2, '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_session`
--
CREATE TABLE `mos_session` (
`username` varchar(50) collate latin1_spanish_ci default '',
`time` varchar(14) collate latin1_spanish_ci default '',
`session_id` varchar(200) collate latin1_spanish_ci NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) collate latin1_spanish_ci default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_session`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_stats_agents`
--
CREATE TABLE `mos_stats_agents` (
`agent` varchar(255) collate latin1_spanish_ci NOT NULL default '',
`type` tinyint(1) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_stats_agents`
--
INSERT INTO `mos_stats_agents` (`agent`, `type`, `hits`) VALUES
('Mozilla 5.0', 0, 11),
('Debian', 1, 11),
('localhost', 2, 8),
('Mozilla 5.0', 0, 11),
('Mozilla 5.0', 0, 10),
('Mozilla 5.0', 0, 9),
('Mozilla 5.0', 0, 8),
('Mozilla 5.0', 0, 7),
('MS Internet Explorer 7.0', 0, 2),
('Windows Longhorn', 1, 2),
('Unknown', 2, 3),
('Mozilla 5.0', 0, 6),
('local', 2, 3),
('Mozilla 5.0', 0, 5),
('Mozilla 5.0', 0, 4),
('MS Internet Explorer 6.0', 0, 1),
('Windows XP', 1, 1),
('MS Internet Explorer 7.0', 0, 2),
('Mozilla 5.0', 0, 3),
('Mozilla 5.0', 0, 2);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_swmenufree_config`
--
CREATE TABLE `mos_swmenufree_config` (
`id` int(11) NOT NULL default '0',
`main_top` smallint(8) default '0',
`main_left` smallint(8) default '0',
`main_height` smallint(8) default '20',
`sub_border_over` varchar(30) collate latin1_spanish_ci default '0',
`main_width` smallint(8) default '100',
`sub_width` smallint(8) default '100',
`main_back` varchar(7) collate latin1_spanish_ci default '#4682B4',
`main_over` varchar(7) collate latin1_spanish_ci default '#5AA7E5',
`sub_back` varchar(7) collate latin1_spanish_ci default '#4682B4',
`sub_over` varchar(7) collate latin1_spanish_ci default '#5AA7E5',
`sub_border` varchar(30) collate latin1_spanish_ci default '#FFFFFF',
`main_font_size` smallint(8) default '0',
`sub_font_size` smallint(8) default '0',
`main_border_over` varchar(30) collate latin1_spanish_ci default '0',
`sub_font_color` varchar(7) collate latin1_spanish_ci default '#000000',
`main_border` varchar(30) collate latin1_spanish_ci default '#FFFFFF',
`main_font_color` varchar(7) collate latin1_spanish_ci default '#000000',
`sub_font_color_over` varchar(7) collate latin1_spanish_ci default '#FFFFFF',
`main_font_color_over` varchar(7) collate latin1_spanish_ci default '#FFFFFF',
`main_align` varchar(8) collate latin1_spanish_ci default 'left',
`sub_align` varchar(8) collate latin1_spanish_ci default 'left',
`sub_height` smallint(7) default '20',
`position` varchar(10) collate latin1_spanish_ci default 'absolute',
`orientation` varchar(20) collate latin1_spanish_ci default NULL,
`font_family` varchar(50) collate latin1_spanish_ci default 'Arial',
`font_weight` varchar(10) collate latin1_spanish_ci default 'normal',
`font_weight_over` varchar(10) collate latin1_spanish_ci default 'normal',
`level2_sub_top` int(11) default '0',
`level2_sub_left` int(11) default '0',
`level1_sub_top` int(11) NOT NULL default '0',
`level1_sub_left` int(11) NOT NULL default '0',
`main_back_image` varchar(100) collate latin1_spanish_ci default NULL,
`main_back_image_over` varchar(100) collate latin1_spanish_ci default NULL,
`sub_back_image` varchar(100) collate latin1_spanish_ci default NULL,
`sub_back_image_over` varchar(100) collate latin1_spanish_ci default NULL,
`specialA` varchar(50) collate latin1_spanish_ci default '80',
`main_padding` varchar(40) collate latin1_spanish_ci default '0px 0px 0px 0px',
`sub_padding` varchar(40) collate latin1_spanish_ci default '0px 0px 0px 0px',
`specialB` varchar(100) collate latin1_spanish_ci default '50',
`sub_font_family` varchar(50) collate latin1_spanish_ci default 'Arial',
`extra` mediumtext collate latin1_spanish_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_swmenufree_config`
--
INSERT INTO `mos_swmenufree_config` (`id`, `main_top`, `main_left`, `main_height`, `sub_border_over`, `main_width`, `sub_width`, `main_back`, `main_over`, `sub_back`, `sub_over`, `sub_border`, `main_font_size`, `sub_font_size`, `main_border_over`, `sub_font_color`, `main_border`, `main_font_color`, `sub_font_color_over`, `main_font_color_over`, `main_align`, `sub_align`, `sub_height`, `position`, `orientation`, `font_family`, `font_weight`, `font_weight_over`, `level2_sub_top`, `level2_sub_left`, `level1_sub_top`, `level1_sub_left`, `main_back_image`, `main_back_image_over`, `sub_back_image`, `sub_back_image_over`, `specialA`, `main_padding`, `sub_padding`, `specialB`, `sub_font_family`, `extra`) VALUES
(1, 0, 0, 22, '1px solid #FFFFFF', 160, 160, '#0C6D00', '#86c15f', '#0C6D00', '#86c15f', '0px solid #FFFFFF', 12, 12, '1px solid #FFFFFF', '#000000', '0px solid #FFFFFF', '#FFFFFF', '#000000', '#000000', 'left', 'left', 22, 'center', 'vertical/right', 'Arial, Helvetica, sans-serif', 'normal', 'bold', 0, 0, 0, 0, 'modules/mod_swmenufree/images', '', 'modules/mod_swmenufree/images', 'modules/mod_swmenufree/images', '100', '5px 5px 5px 5px', '5px 5px 5px 5px', '300', 'Arial, Helvetica, sans-serif', NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_template_positions`
--
CREATE TABLE `mos_template_positions` (
`id` int(11) NOT NULL auto_increment,
`position` varchar(10) collate latin1_spanish_ci NOT NULL default '',
`description` varchar(255) collate latin1_spanish_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=28 ;
--
-- Volcar la base de datos para la tabla `mos_template_positions`
--
INSERT INTO `mos_template_positions` (`id`, `position`, `description`) VALUES
(1, 'left', ''),
(2, 'right', ''),
(3, 'top', ''),
(4, 'bottom', ''),
(5, 'inset', ''),
(6, 'banner', ''),
(7, 'header', ''),
(8, 'footer', ''),
(9, 'newsflash', ''),
(10, 'legals', ''),
(11, 'pathway', ''),
(12, 'toolbar', ''),
(13, 'cpanel', ''),
(14, 'user1', ''),
(15, 'user2', ''),
(16, 'user3', ''),
(17, 'user4', ''),
(18, 'user5', ''),
(19, 'user6', ''),
(20, 'user7', ''),
(21, 'user8', ''),
(22, 'user9', ''),
(23, 'advert1', ''),
(24, 'advert2', ''),
(25, 'advert3', ''),
(26, 'icon', ''),
(27, 'debug', '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_templates_menu`
--
CREATE TABLE `mos_templates_menu` (
`template` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`menuid` int(11) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`template`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_templates_menu`
--
INSERT INTO `mos_templates_menu` (`template`, `menuid`, `client_id`) VALUES
('mambo_admin_blue', 0, 1),
('design3a', 0, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_users`
--
CREATE TABLE `mos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`username` varchar(25) collate latin1_spanish_ci NOT NULL default '',
`email` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`password` varchar(100) collate latin1_spanish_ci NOT NULL default '',
`usertype` varchar(25) collate latin1_spanish_ci 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) collate latin1_spanish_ci NOT NULL default '',
`params` text collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=63 ;
--
-- Volcar la base de datos para la tabla `mos_users`
--
INSERT INTO `mos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'admin', 'as@as.com', 'b5c5137faae8b393bde3f748bc09a546', 'Super Administrator', 0, 1, 25, '2007-09-30 10:32:06', '2007-10-29 10:30:58', '', '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `mos_usertypes`
--
CREATE TABLE `mos_usertypes` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) collate latin1_spanish_ci NOT NULL default '',
`mask` varchar(11) collate latin1_spanish_ci NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `mos_usertypes`
--
INSERT INTO `mos_usertypes` (`id`, `name`, `mask`) VALUES
(0, 'superadministrator', ''),
(1, 'administrator', ''),
(2, 'editor', ''),
(3, 'user', ''),
(4, 'author', ''),
(5, 'publisher', ''),
(6, 'manager', '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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) collate latin1_spanish_ci NOT NULL default '',
`url` varchar(250) collate latin1_spanish_ci NOT NULL default '',
`description` varchar(250) collate latin1_spanish_ci 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 collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=6 ;
--
-- Volcar la base de datos para la tabla `mos_weblinks`
--