-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 27 Giu, 2008 at 02:35 AM
-- Versione MySQL: 4.1.22
-- Versione PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `united2_clooner2`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_banner`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_banner`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_bannerclient`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_bannerclient`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_bannerfinish`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_bannerfinish`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_categories`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dump dei dati per la tabella `jos_categories`
--
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES
(1, 0, 'Home', 'Home', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, 'imagefolders=*2*'),
(2, 0, 'Form Contatto', 'Form Contatto', '', 'com_contact_details', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_components`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
--
-- Dump dei dati per la tabella `jos_components`
--
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES
(1, 'Banner', '', 0, 0, '', 'Gestione banner', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, ''),
(2, 'Gestione banner', '', 0, 1, 'option=com_banners', 'Banner attivi', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, ''),
(3, 'Gestione clienti', '', 0, 1, 'option=com_banners&task=listclients', 'Gestione clienti', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, ''),
(38, 'FacileForms', 'option=com_facileforms', 0, 0, 'option=com_facileforms', 'FacileForms', 'com_facileforms', 0, 'js/ThemeOffice/component.png', 0, ''),
(39, 'Manage Records', '', 0, 38, 'option=com_facileforms&act=managerecs', 'Manage Records', 'com_facileforms', 0, 'js/ThemeOffice/component.png', 0, ''),
(40, 'Manage Backend Menus', '', 0, 38, 'option=com_facileforms&act=managemenus', 'Manage Backend Menus', 'com_facileforms', 1, 'js/ThemeOffice/component.png', 0, ''),
(7, 'Contatti', 'option=com_contact', 0, 0, '', 'Modifica dettagli contatti', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, ''),
(8, 'Gestione Contatti', '', 0, 7, 'option=com_contact', 'Modifica dettagli contatti', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, ''),
(9, 'Categorie contatti', '', 0, 7, 'option=categories§ion=com_contact_details', 'Gestione categorie contatti', '', 2, 'js/ThemeOffice/categories.png', 1, ''),
(10, 'Prima pagina', 'option=com_frontpage', 0, 0, '', 'Gestione prima pagina', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, ''),
(11, 'Sondaggi', 'option=com_poll', 0, 0, 'option=com_poll', 'Gestione sondaggi', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, ''),
(12, 'News feed', 'option=com_newsfeeds', 0, 0, '', 'Gestione news feed', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, ''),
(13, 'Gestione News feed', '', 0, 12, 'option=com_newsfeeds', 'Gestione news feed', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, ''),
(14, 'Gestione categorie', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Gestione categorie', '', 2, 'js/ThemeOffice/categories.png', 0, ''),
(15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, ''),
(16, 'Cerca', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, ''),
(17, 'Syndicate', '', 0, 0, 'option=com_syndicate&hidemainmenu=1', 'Configurazione syndication', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, ''),
(18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Invia Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, ''),
(19, '.JoomlaCloner.', 'option=com_cloner', 0, 0, 'option=com_cloner', '.JoomlaCloner.', 'com_cloner', 0, '../administrator/components/com_cloner/images/logo.gif', 0, ''),
(20, 'Xmap', 'option=com_xmap', 0, 0, 'option=com_xmap', 'Xmap', 'com_xmap', 0, 'js/ThemeOffice/component.png', 0, ''),
(21, '. SEF Advance .', 'option=com_sef', 0, 0, 'option=com_sef', '. SEF Advance .', 'com_sef', 0, '../components/com_sef/images/icon_sef.png', 0, ''),
(22, 'Configuration', '', 0, 21, 'option=com_sef&task=config', 'Configuration', 'com_sef', 0, 'js/ThemeOffice/config.png', 0, ''),
(23, 'Alias & Meta', '', 0, 21, 'option=com_sef&task=alias', 'Alias & Meta', 'com_sef', 1, 'js/ThemeOffice/edit.png', 0, ''),
(24, 'Redirects', '', 0, 21, 'option=com_sef&task=redirects', 'Redirects', 'com_sef', 2, 'js/ThemeOffice/search_text.png', 0, ''),
(25, 'Logs', '', 0, 21, 'option=com_sef&task=logs', 'Logs', 'com_sef', 3, 'js/ThemeOffice/query.png', 0, ''),
(26, 'Backup', '', 0, 21, 'option=com_sef&task=backup', 'Backup', 'com_sef', 4, 'js/ThemeOffice/backup.png', 0, ''),
(27, 'Info', '', 0, 21, 'option=com_sef&task=info', 'Info', 'com_sef', 5, 'js/ThemeOffice/document.png', 0, ''),
(28, 'About', '', 0, 21, 'option=com_sef&task=about', 'About', 'com_sef', 6, 'js/ThemeOffice/credits.png', 0, ''),
(29, 'JCE Admin', 'option=com_jce', 0, 0, 'option=com_jce', 'JCE Admin', 'com_jce', 0, 'js/ThemeOffice/component.png', 0, ''),
(30, 'JCE Configurazione', '', 0, 29, 'option=com_jce&task=config', 'JCE Configurazione', 'com_jce', 0, 'js/ThemeOffice/controlpanel.png', 0, ''),
(31, 'JCE Lingue', '', 0, 29, 'option=com_jce&task=lang', 'JCE Lingue', 'com_jce', 1, 'js/ThemeOffice/language.png', 0, ''),
(32, 'JCE Plugin', '', 0, 29, 'option=com_jce&task=showplugins', 'JCE Plugin', 'com_jce', 2, 'js/ThemeOffice/add_section.png', 0, ''),
(33, 'JCE Disposizione', '', 0, 29, 'option=com_jce&task=editlayout', 'JCE Disposizione', 'com_jce', 3, 'js/ThemeOffice/content.png', 0, ''),
(34, 'LinX', 'option=com_linx', 0, 0, 'option=com_linx', 'LinX', 'com_linx', 0, 'js/ThemeOffice/globe4.png', 0, ''),
(35, 'Manage Links', '', 0, 34, 'option=com_linx', 'Manage Links', 'com_linx', 0, 'js/ThemeOffice/globe4.png', 0, ''),
(36, 'Categories', '', 0, 34, 'option=com_linx&task=list_categories', 'Categories', 'com_linx', 1, 'js/ThemeOffice/sections.png', 0, ''),
(37, 'Settings', '', 0, 34, 'option=com_linx&task=edit_settings', 'Settings', 'com_linx', 2, 'js/ThemeOffice/controlpanel.png', 0, ''),
(41, 'Manage Forms', '', 0, 38, 'option=com_facileforms&act=manageforms', 'Manage Forms', 'com_facileforms', 2, 'js/ThemeOffice/component.png', 0, ''),
(42, 'Manage Scripts', '', 0, 38, 'option=com_facileforms&act=managescripts', 'Manage Scripts', 'com_facileforms', 3, 'js/ThemeOffice/component.png', 0, ''),
(43, 'Manage Pieces', '', 0, 38, 'option=com_facileforms&act=managepieces', 'Manage Pieces', 'com_facileforms', 4, 'js/ThemeOffice/component.png', 0, ''),
(44, 'Configuration', '', 0, 38, 'option=com_facileforms&act=configuration', 'Configuration', 'com_facileforms', 5, 'js/ThemeOffice/component.png', 0, '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_contact_details`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_contact_details`
--
INSERT INTO `jos_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
(1, 'BEGHELLI POINT', '', 'V.le Anicio Gallo, 78', 'Roma', '', '', '00174', '06.83083886', '', 'Orari:\r\nlunedì: 16:00/19:30\r\nda martedì a sabato: 09:00-13:00/16:00-19:30', '', NULL, 'bprm10@sicurweb.com', 0, 1, 0, '0000-00-00 00:00:00', 1, 'menu_image=-1\npageclass_sfx=\nprint=0\nback_button=0\nname=1\nposition=0\nemail=0\nstreet_address=1\nsuburb=1\nstate=0\ncountry=0\npostcode=1\ntelephone=1\nfax=0\nmisc=1\nimage=0\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=1\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=', 62, 2, 0);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_content`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dump dei dati per la tabella `jos_content`
--
INSERT INTO `jos_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
(1, 'Dove Siamo', 'Dove Siamo', '
\r\n \r\n \r\n | \r\n \r\n \r\n \r\n \r\n BEGHELLI POINT\r\n \r\n \r\n \r\n \r\n V.le Anicio Gallo, 78\r\n \r\n \r\n \r\n \r\n 00174 ROMA \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n clicca sulla mappa per ottenere indicazioni stradali \r\n \r\n | \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-04-30 08:40:16', 62, '', '2008-06-25 10:01:58', 62, 0, '0000-00-00 00:00:00', '2008-04-30 08:38:02', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=0\nrating=0\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Dove siamo', 'Dove siamo', 0, 24),
(2, 'Prodotti', 'Prodotti', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. \r\n Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. \r\n Donec eget sapien sit amet ligula tristique iaculis. Proin et leo quis ligula convallis tempus. Quisque non mauris et pede lacinia ultrices. \r\n Etiam rutrum nibh id sapien. In felis. Pellentesque vel sem sed mauris semper aliquam. Sed id ante. Donec risus. Phasellus in augue. Donec tempus ultricies diam. Maecenas massa urna, egestas a, commodo\r\n eu, varius at, risus. Donec cursus blandit nisi. Aliquam tempus, est id\r\n vehicula eleifend, felis justo gravida mi, in mollis nisi diam sit amet\r\n dui. Donec id nisl. Ut ac nunc. \r\n Nam massa felis, mollis vel, pellentesque id, sodales ultrices, leo. \r\n Vivamus sodales feugiat nulla. Nam enim elit, ullamcorper id, elementum\r\n non, gravida non, mauris. Nam non risus eu elit nonummy laoreet. \r\n \r\n | \r\n \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-04-30 08:40:41', 62, '', '2008-06-25 07:23:02', 62, 0, '0000-00-00 00:00:00', '2008-04-30 08:40:22', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=0\nrating=0\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Prodotti', 'Prodotti', 0, 38),
(3, 'Servizi', 'Servizi', '\r\n \r\n \r\n | \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n \r\n \r\n Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. \r\n Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n Proin et leo quis ligula convallis tempus. Quisque non mauris et pede lacinia ultrices. Etiam rutrum nibh id sapien. In felis. Pellentesque vel sem sed mauris semper aliquam. Sed id ante. Donec risus. Phasellus in augue.\r\n \r\n \r\n \r\n \r\n Donec tempus ultricies diam. Maecenas massa urna, egestas a, commodo\r\n eu, varius at, risus. Donec cursus blandit nisi. \r\n Aliquam tempus, est id vehicula eleifend, felis justo gravida mi, in mollis nisi diam sit amet dui. \r\n Donec id nisl. Ut ac nunc. Nam massa felis, mollis vel, pellentesque\r\n id, sodales ultrices, leo. Vivamus sodales feugiat nulla. Nam enim\r\n elit, ullamcorper id, elementum non, gravida non, mauris. Nam non risus\r\n eu elit nonummy laoreet. \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-04-30 08:41:04', 62, '', '2008-06-25 09:00:16', 62, 0, '0000-00-00 00:00:00', '2008-04-30 08:40:45', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=0\nrating=0\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Servizi', 'Servizi', 0, 24),
(4, 'Pagina Landing 1', 'Pagina Landing 1', 'Pagina Landing 1', '', 1, 0, 0, 0, '2008-04-30 08:45:29', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-04-30 08:45:08', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Pagina Landing 1', 'Pagina Landing 1', 0, 9),
(5, 'Pagina Landing 2', 'Pagina Landing 2', 'Pagina Landing 2', '', 1, 0, 0, 0, '2008-04-30 08:46:13', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-04-30 08:45:49', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Pagina Landing 2', 'Pagina Landing 2', 0, 9),
(6, 'Pagina Landing 3', 'Pagina Landing 3', 'Pagina Landing 3', '', 1, 0, 0, 0, '2008-04-30 08:47:38', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-04-30 08:47:17', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Pagina Landing 3', 'Pagina Landing 3', 0, 10),
(7, 'Pagina Landing 4', 'Pagina Landing 4', 'Pagina Landing 4', '', 1, 0, 0, 0, '2008-04-30 08:48:06', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-04-30 08:47:45', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Pagina Landing 4', 'Pagina Landing 4', 0, 9),
(8, 'Pagina Landing 5', 'Pagina Landing 5', 'Pagina Landing 5', '', 1, 0, 0, 0, '2008-04-30 08:48:36', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-04-30 08:48:21', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, 'Pagina Landing 5', 'Pagina Landing 5', 0, 11),
(9, 'Chi Siamo', 'Chi Siamo', '\r\n \r\n \r\n | \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n \r\n \r\n Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n \r\n \r\n \r\n \r\n Mauris in tortor. Aenean ut diam. Curabitur a dui. Sed varius accumsan est. Aliquam euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo, iaculis sed, aliquam ac, viverra eget, neque. Aenean dictum malesuada dui. Fusce placerat. Pellentesque tellus tortor, pharetra vitae, pharetra vel, pretium non, odio. Nunc vehicula egestas dui. Vivamus blandit nibh et tellus. Pellentesque dignissim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n  | \r\n \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 1, 0, 1, '2008-04-30 08:53:52', 62, '', '2008-06-25 10:07:05', 62, 62, '2008-06-25 10:07:05', '2008-04-30 08:52:42', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=0\nitem_title=1\nlink_titles=0\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=0\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0\nkeyref=\ndocbook_type=', 15, 0, 1, 'Chi Siamo', 'Chi Siamo', 0, 5),
(10, 'Consumer', 'Consumer', '\r\n \r\n \r\n  | \r\n \r\n \r\n Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. \r\n Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo\r\n lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis\r\n commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet\r\n ligula tristique iaculis. \r\n Proin et leo quis ligula convallis tempus. Quisque non mauris et pede\r\n lacinia ultrices. Etiam rutrum nibh id sapien. In felis. Pellentesque\r\n vel sem sed mauris semper aliquam. Sed id ante. Donec risus. Phasellus\r\n in augue. \r\n \r\n \r\n Donec tempus ultricies diam. Maecenas massa urna, egestas a, commodo\r\n eu, varius at, risus. Donec cursus blandit nisi. \r\n Aliquam tempus, est id vehicula eleifend, felis justo gravida mi, in mollis nisi diam sit amet dui. \r\n \r\n \r\n Donec id nisl. Ut ac nunc. Nam massa felis, mollis vel, pellentesque\r\n id, sodales ultrices, leo. Vivamus sodales feugiat nulla. Nam enim\r\n elit, ullamcorper id, elementum non, gravida non, mauris. Nam non risus\r\n eu elit nonummy laoreet. \r\n \r\n \r\n Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. \r\n Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo\r\n lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis\r\n commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet\r\n ligula tristique iaculis. \r\n Proin et leo quis ligula convallis tempus. Quisque non mauris et pede\r\n lacinia ultrices. Etiam rutrum nibh id sapien. In felis. Pellentesque\r\n vel sem sed mauris semper aliquam. Sed id ante. Donec risus. Phasellus\r\n in augue. \r\n \r\n \r\n Donec tempus ultricies diam. Maecenas massa urna, egestas a, commodo\r\n eu, varius at, risus. Donec cursus blandit nisi. \r\n Aliquam tempus, est id vehicula eleifend, felis justo gravida mi, in mollis nisi diam sit amet dui. \r\n \r\n \r\n Donec id nisl. Ut ac nunc. Nam massa felis, mollis vel, pellentesque\r\n id, sodales ultrices, leo. Vivamus sodales feugiat nulla. Nam enim\r\n elit, ullamcorper id, elementum non, gravida non, mauris. Nam non risus\r\n eu elit nonummy laoreet. \r\n \r\n \r\n Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. \r\n Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo\r\n lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis\r\n commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet\r\n ligula tristique iaculis. \r\n Proin et leo quis ligula convallis tempus. Quisque non mauris et pede\r\n lacinia ultrices. Etiam rutrum nibh id sapien. In felis. Pellentesque\r\n vel sem sed mauris semper aliquam. Sed id ante. Donec risus. Phasellus\r\n in augue. \r\n \r\n \r\n Donec tempus ultricies diam. Maecenas massa urna, egestas a, commodo\r\n eu, varius at, risus. Donec cursus blandit nisi. \r\n Aliquam tempus, est id vehicula eleifend, felis justo gravida mi, in mollis nisi diam sit amet dui. \r\n \r\n | \r\n
\r\n \r\n | imbo sicuro Beghelli \r\n | \r\n
\r\n \r\n  | \r\n
\r\n \r\n | \r\n Lampada portatile Maya \r\n | \r\n
\r\n \r\n  | \r\n
\r\n \r\n | \r\n Tele allarme vita \r\n | \r\n
\r\n \r\n  | \r\n
\r\n \r\n | Tele salvalavita | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-06-25 05:36:49', 62, '', '2008-06-26 09:35:31', 62, 0, '0000-00-00 00:00:00', '2008-06-25 05:36:19', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, '', '', 0, 14),
(11, 'Intelligent', 'Intelligent', '\r\n \r\n \r\n | \r\n \r\n Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. \r\n \r\n \r\n Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo\r\n lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis\r\n commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet\r\n ligula tristique iaculis. \r\n Proin et leo quis ligula convallis tempus. Quisque non mauris et pede\r\n lacinia ultrices. Etiam rutrum nibh id sapien. In felis. Pellentesque\r\n vel sem sed mauris semper aliquam. Sed id ante. Donec risus. Phasellus\r\n in augue. \r\n \r\n \r\n Donec tempus ultricies diam. Maecenas massa urna, egestas a, commodo\r\n eu, varius at, risus. Donec cursus blandit nisi. \r\n Aliquam tempus, est id vehicula eleifend, felis justo gravida mi, in mollis nisi diam sit amet dui. \r\n Donec id nisl. Ut ac nunc. Nam massa felis, mollis vel, pellentesque\r\n id, sodales ultrices, leo. Vivamus sodales feugiat nulla. Nam enim\r\n elit, ullamcorper id, elementum non, gravida non, mauris. Nam non risus\r\n eu elit nonummy laoreet. \r\n \r\n | \r\n
\r\n \r\n | \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n Centrale radio con combinatore \r\n \r\n | \r\n \r\n \r\n \r\n \r\n \r\n \r\n Sirena per esterni \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-06-25 05:37:22', 62, '', '2008-06-26 08:56:22', 62, 0, '0000-00-00 00:00:00', '2008-06-25 05:37:01', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, '', '', 0, 13),
(12, 'Fotovoltaico', 'Fotovoltaico', '\r\n \r\n \r\n | \r\n \r\n \r\n \r\n Lorem\r\n ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo,\r\n accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere\r\n purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam\r\n justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam\r\n facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien\r\n sit amet ligula tristique iaculis. \r\n \r\n Mauris in tortor. Aenean ut diam. Curabitur a dui. Sed varius accumsan\r\n est. Aliquam euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo,\r\n iaculis sed, aliquam ac, viverra eget, neque. Aenean dictum malesuada\r\n dui. Fusce placerat. Pellentesque tellus tortor, pharetra vitae,\r\n pharetra vel, pretium non, odio. Nunc vehicula egestas dui. Vivamus\r\n blandit nibh et tellus. Pellentesque dignissim. Lorem ipsum dolor sit\r\n amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id,\r\n placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac\r\n velit. Vestibulum elementum scelerisque libero. Nullam justo lorem,\r\n rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo\r\n sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula\r\n tristique iaculis. \r\n \r\n \r\n \r\n \r\n Lorem\r\n ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo,\r\n accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere\r\n purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam\r\n justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam\r\n facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien\r\n sit amet ligula tristique iaculis. \r\n \r\n \r\n \r\n Mauris in tortor.\r\n Aenean ut diam. Curabitur a dui. Sed varius accumsan est. Aliquam\r\n euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo, iaculis sed,\r\n aliquam ac, viverra eget, neque. Aenean dictum malesuada dui. Fusce\r\n placerat. Pellentesque tellus tortor, pharetra vitae, pharetra vel,\r\n pretium non, odio. Nunc vehicula egestas dui. Vivamus blandit nibh et\r\n tellus. Pellentesque dignissim. Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit.\r\n Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum\r\n eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem.\r\n Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula\r\n tristique iaculis. \r\n \r\n | \r\n
\r\n \r\n  | \r\n  | \r\n  | \r\n
\r\n \r\n Albero dell''energia Beghelli \r\n \r\n | \r\n Pannello solare a 3 moduli \r\n \r\n | \r\n Modulo fotovoltaico singolo \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-06-25 05:37:59', 62, '', '2008-06-26 08:15:10', 62, 0, '0000-00-00 00:00:00', '2008-06-25 05:37:35', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, '', '', 0, 15),
(13, 'Progetto Luce', 'Progetto Luce', '\r\n \r\n \r\n | \r\n \r\n \r\n \r\n Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n \r\n Mauris in tortor. Aenean ut diam. Curabitur a dui. Sed varius accumsan est. Aliquam euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo, iaculis sed, aliquam ac, viverra eget, neque. Aenean dictum malesuada dui. Fusce placerat. Pellentesque tellus tortor, pharetra vitae, pharetra vel, pretium non, odio. Nunc vehicula egestas dui. Vivamus blandit nibh et tellus. Pellentesque dignissim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n \r\n \r\n \r\n \r\n Lorem\r\n ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo,\r\n accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere\r\n purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam\r\n justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam\r\n facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien\r\n sit amet ligula tristique iaculis. \r\n \r\n Mauris in tortor.\r\n Aenean ut diam. Curabitur a dui. Sed varius accumsan est. Aliquam\r\n euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo, iaculis sed,\r\n aliquam ac, viverra eget, neque. Aenean dictum malesuada dui. Fusce\r\n placerat. Pellentesque tellus tortor, pharetra vitae, pharetra vel,\r\n pretium non, odio. Nunc vehicula egestas dui. Vivamus blandit nibh et\r\n tellus. Pellentesque dignissim. Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit.\r\n Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum\r\n eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem.\r\n Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula\r\n tristique iaculis. \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-06-25 05:38:30', 62, '', '2008-06-26 07:02:31', 62, 0, '0000-00-00 00:00:00', '2008-06-25 05:38:14', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, '', '', 0, 17),
(14, 'Climatizzazione', 'Climatizzazione', '\r\n \r\n \r\n | \r\n \r\n \r\n \r\n \r\n Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n \r\n Mauris in tortor. Aenean ut diam. Curabitur a dui. Sed varius accumsan est. Aliquam euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo, iaculis sed, aliquam ac, viverra eget, neque. Aenean dictum malesuada dui. Fusce placerat. Pellentesque tellus tortor, pharetra vitae, pharetra vel, pretium non, odio. Nunc vehicula egestas dui. Vivamus blandit nibh et tellus. Pellentesque dignissim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula tristique iaculis. \r\n \r\n \r\n \r\n \r\n Lorem\r\n ipsum dolor sit amet, consectetuer adipiscing elit. Duis lorem justo,\r\n accumsan id, placerat eget, gravida nec, justo. Ut aliquet posuere\r\n purus. Donec ac velit. Vestibulum elementum scelerisque libero. Nullam\r\n justo lorem, rutrum eget, ultrices ac, ullamcorper in, quam. Etiam\r\n facilisis commodo sem. Nullam vestibulum cursus pede. Donec eget sapien\r\n sit amet ligula tristique iaculis. \r\n \r\n Mauris in tortor.\r\n Aenean ut diam. Curabitur a dui. Sed varius accumsan est. Aliquam\r\n euismod. Fusce nisl. Ut ut enim. Suspendisse purus leo, iaculis sed,\r\n aliquam ac, viverra eget, neque. Aenean dictum malesuada dui. Fusce\r\n placerat. Pellentesque tellus tortor, pharetra vitae, pharetra vel,\r\n pretium non, odio. Nunc vehicula egestas dui. Vivamus blandit nibh et\r\n tellus. Pellentesque dignissim. Lorem ipsum dolor sit amet,\r\n consectetuer adipiscing elit. Duis lorem justo, accumsan id, placerat\r\n eget, gravida nec, justo. Ut aliquet posuere purus. Donec ac velit.\r\n Vestibulum elementum scelerisque libero. Nullam justo lorem, rutrum\r\n eget, ultrices ac, ullamcorper in, quam. Etiam facilisis commodo sem.\r\n Nullam vestibulum cursus pede. Donec eget sapien sit amet ligula\r\n tristique iaculis. \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n', '', 1, 0, 0, 0, '2008-06-25 05:40:01', 62, '', '2008-06-26 08:19:45', 62, 0, '0000-00-00 00:00:00', '2008-06-25 05:38:43', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0', 1, 0, 0, '', '', 0, 25);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_content_frontpage`
--
CREATE TABLE IF NOT EXISTS `jos_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;
--
-- Dump dei dati per la tabella `jos_content_frontpage`
--
INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES
(9, 1);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_content_rating`
--
CREATE TABLE IF NOT EXISTS `jos_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) NOT NULL default '',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_content_rating`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_core_acl_aro`
--
CREATE TABLE IF NOT EXISTS `jos_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 `jos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dump dei dati per la tabella `jos_core_acl_aro`
--
INSERT INTO `jos_core_acl_aro` (`aro_id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0),
(11, 'users', '63', 0, 'Arcibold', 0);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_core_acl_aro_groups`
--
CREATE TABLE IF NOT EXISTS `jos_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 `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dump dei dati per la tabella `jos_core_acl_aro_groups`
--
INSERT INTO `jos_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);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_core_acl_aro_sections`
--
CREATE TABLE IF NOT EXISTS `jos_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 `jos_gacl_value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`),
KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dump dei dati per la tabella `jos_core_acl_aro_sections`
--
INSERT INTO `jos_core_acl_aro_sections` (`section_id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', 1, 'Users', 0);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_core_acl_groups_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_core_acl_groups_aro_map`
--
INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(24, '', 11),
(25, '', 10);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_core_log_items`
--
CREATE TABLE IF NOT EXISTS `jos_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_core_log_items`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_core_log_searches`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_core_log_searches`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_groups`
--
CREATE TABLE IF NOT EXISTS `jos_groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_groups`
--
INSERT INTO `jos_groups` (`id`, `name`) VALUES
(0, 'Public'),
(1, 'Registered'),
(2, 'Special');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_jce_langs`
--
CREATE TABLE IF NOT EXISTS `jos_jce_langs` (
`id` int(11) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL default '',
`lang` varchar(100) NOT NULL default '',
`published` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dump dei dati per la tabella `jos_jce_langs`
--
INSERT INTO `jos_jce_langs` (`id`, `Name`, `lang`, `published`) VALUES
(1, 'English', 'en', 0),
(2, 'Italian', 'it', 1);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_jce_plugins`
--
CREATE TABLE IF NOT EXISTS `jos_jce_plugins` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`plugin` varchar(100) NOT NULL default '',
`type` varchar(100) NOT NULL default 'plugin',
`icon` varchar(255) NOT NULL default '',
`layout_icon` varchar(255) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '18',
`row` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`editable` tinyint(3) NOT NULL default '0',
`elements` varchar(255) NOT NULL default '',
`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`),
UNIQUE KEY `plugin` (`plugin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
--
-- Dump dei dati per la tabella `jos_jce_plugins`
--
INSERT INTO `jos_jce_plugins` (`id`, `name`, `plugin`, `type`, `icon`, `layout_icon`, `access`, `row`, `ordering`, `published`, `editable`, `elements`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'Menu Contestuale', 'contextmenu', 'plugin', '', '', 18, 0, 0, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(2, 'Direzione Testo', 'directionality', 'plugin', 'ltr,rtl', 'directionality', 18, 3, 8, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(3, 'Emoticons', 'emotions', 'plugin', 'emotions', 'emotions', 18, 4, 12, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(4, 'Schermo Intero', 'fullscreen', 'plugin', 'fullscreen', 'fullscreen', 18, 4, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(5, 'Incolla', 'paste', 'plugin', 'pasteword,pastetext', 'paste', 18, 1, 16, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(6, 'Anteprima', 'preview', 'plugin', 'preview', 'preview', 18, 4, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(7, 'Tabelle', 'table', 'plugin', 'tablecontrols', 'buttons', 18, 2, 8, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(8, 'Stampa', 'print', 'plugin', 'print', 'print', 18, 4, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(9, 'Cerca Sostituisci', 'searchreplace', 'plugin', 'search,replace', 'searchreplace', 18, 1, 17, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(10, 'Stili', 'style', 'plugin', 'styleprops', 'styleprops', 18, 4, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(11, 'Anti-Spaziatura', 'nonbreaking', 'plugin', 'nonbreaking', 'nonbreaking', 18, 4, 8, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(12, 'Caratteri Visuali', 'visualchars', 'plugin', 'visualchars', 'visualchars', 18, 4, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(13, 'XHTML Xtras', 'xhtmlxtras', 'plugin', 'cite,abbr,acronym,del,ins,attribs', 'xhtmlxtras', 18, 4, 10, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(14, 'Gestore Immagini', 'imgmanager', 'plugin', '', 'imgmanager', 18, 4, 13, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(15, 'Collegamento Avanzato', 'advlink', 'plugin', '', 'advlink', 18, 4, 14, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(16, 'Controllo Ortografico', 'spellchecker', 'plugin', 'spellchecker', 'spellchecker', 18, 4, 15, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(17, 'Livelli', 'layer', 'plugin', 'insertlayer,moveforward,movebackward,absolute', 'layer', 18, 4, 11, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(18, 'Colore Carattere', 'forecolor', 'command', 'forecolor', 'forecolor', 18, 3, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(19, 'Grassetto', 'bold', 'command', 'bold', 'bold', 18, 1, 5, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(20, 'Corsivo', 'italic', 'command', 'italic', 'italic', 18, 1, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(21, 'Sottolineato', 'underline', 'command', 'underline', 'underline', 18, 1, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(22, 'Colore Sfondo', 'backcolor', 'command', 'backcolor', 'backcolor', 18, 3, 5, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(23, 'Rimuovi Collegamento', 'unlink', 'command', 'unlink', 'unlink', 18, 2, 11, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(24, 'Seleziona Tipo di Carattere', 'fontselect', 'command', 'fontselect', 'fontselect', 18, 3, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(25, 'Seleziona Dimensione Carattere', 'fontsizeselect', 'command', 'fontsizeselect', 'fontsizeselect', 18, 3, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(26, 'Seleziona Stile', 'styleselect', 'command', 'styleselect', 'styleselect', 18, 3, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(27, 'Nuovo Documento', 'newdocument', 'command', 'newdocument', 'newdocument', 18, 1, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(28, 'Aiuto', 'help', 'command', 'help', 'help', 18, 1, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(29, 'Barrato', 'strikethrough', 'command', 'strikethrough', 'strikethrough', 18, 1, 12, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(30, 'Rientra Destra', 'indent', 'command', 'indent', 'indent', 18, 1, 11, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(31, 'Rientra Sinistra', 'outdent', 'command', 'outdent', 'outdent', 18, 1, 10, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(32, 'Annulla', 'undo', 'command', 'undo', 'undo', 18, 1, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(33, 'Ripristina', 'redo', 'command', 'redo', 'redo', 18, 1, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(34, 'Riga Orizzontale', 'hr', 'command', 'hr', 'hr', 18, 2, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(35, 'HTML', 'html', 'command', 'code', 'code', 18, 1, 13, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(36, 'Elenco Numerato', 'numlist', 'command', 'numlist', 'numlist', 18, 1, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(37, 'Elenco Puntato', 'bullist', 'command', 'bullist', 'bullist', 18, 1, 8, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(38, 'Azioni Appunti', 'clipboard', 'command', 'cut,copy,paste', 'clipboard', 18, 1, 16, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(39, 'Pedice', 'sub', 'command', 'sub', 'sub', 18, 2, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(40, 'Apice', 'sup', 'command', 'sup', 'sup', 18, 2, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(41, 'Aiuto Visuale', 'visualaid', 'command', 'visualaid', 'visualaid', 18, 3, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(42, 'Mappa Caratteri', 'charmap', 'command', 'charmap', 'charmap', 18, 3, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(43, 'Allinea Giustificato', 'full', 'command', 'justifyfull', 'justifyfull', 18, 2, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(44, 'Allinea Centro', 'center', 'command', 'justifycenter', 'justifycenter', 18, 2, 5, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(45, 'Allinea Sinistra', 'left', 'command', 'justifyleft', 'justifyleft', 18, 2, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(46, 'Allinea Destra', 'right', 'command', 'justifyright', 'justifyright', 18, 2, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(47, 'Rimuovi Formato', 'removeformat', 'command', 'removeformat', 'removeformat', 18, 1, 15, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(48, 'Ancora', 'anchor', 'command', 'anchor', 'anchor', 18, 2, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(49, 'Seleziona Formato', 'formatselect', 'command', 'formatselect', 'formatselect', 18, 3, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(50, 'Immagine', 'image', 'command', 'image', 'image', 18, 4, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''),
(51, 'Collegamento', 'link', 'command', 'link', 'link', 18, 4, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_linx`
--
CREATE TABLE IF NOT EXISTS `jos_linx` (
`id` int(11) NOT NULL auto_increment,
`url` text NOT NULL,
`link_name` text NOT NULL,
`link_description` text NOT NULL,
`submitters_name` varchar(250) NOT NULL default '',
`submitters_email` varchar(250) NOT NULL default '',
`link_status` tinyint(4) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`recip_url` varchar(250) NOT NULL default '',
`date_added` varchar(20) NOT NULL default '0',
`email_confirmation_code` varchar(10) NOT NULL default '',
`show_in_admin` tinyint(4) NOT NULL default '1',
`email_confirmed` tinyint(1) NOT NULL default '0',
`recip_link_date_check` varchar(20) NOT NULL default '0',
`recip_link_status` tinyint(1) NOT NULL default '1',
`activation_code` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dump dei dati per la tabella `jos_linx`
--
INSERT INTO `jos_linx` (`id`, `url`, `link_name`, `link_description`, `submitters_name`, `submitters_email`, `link_status`, `cat_id`, `recip_url`, `date_added`, `email_confirmation_code`, `show_in_admin`, `email_confirmed`, `recip_link_date_check`, `recip_link_status`, `activation_code`) VALUES
(1, 'http://www.unitedcomunication.eu', 'Web marketing', 'United Comunication è una web agency che propone campagne di web marketing ed indicizzazioni sui principali motori di ricerca.', 'Soren Beck', 'soren@notwebdesign.com', 1, 1, '', '0', '', 1, 1, '0', 1, '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_linx_cats`
--
CREATE TABLE IF NOT EXISTS `jos_linx_cats` (
`id` int(11) NOT NULL auto_increment,
`cat_name` varchar(150) NOT NULL default '',
`cat_published` tinyint(4) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`allow_submit` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_linx_cats`
--
INSERT INTO `jos_linx_cats` (`id`, `cat_name`, `cat_published`, `ordering`, `allow_submit`) VALUES
(1, 'Link', 1, 1, 1);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_linx_settings`
--
CREATE TABLE IF NOT EXISTS `jos_linx_settings` (
`id` int(11) NOT NULL auto_increment,
`use_cats` tinyint(4) NOT NULL default '1',
`cat_display_columns` tinyint(4) NOT NULL default '1',
`require_recip_link` tinyint(4) NOT NULL default '1',
`my_url` varchar(250) NOT NULL default '',
`my_link_name` varchar(250) NOT NULL default '',
`my_link_description` text NOT NULL,
`use_description` tinyint(4) NOT NULL default '1',
`description_maxlength` int(4) NOT NULL default '250',
`recip_link_timeout_secconds` varchar(20) NOT NULL default '7776000',
`links_per_page` tinyint(4) NOT NULL default '20',
`use_curl` tinyint(4) NOT NULL default '0',
`debug` tinyint(4) NOT NULL default '0',
`enable_email_accept_links` tinyint(4) NOT NULL default '1',
`recieve_link_emails` tinyint(4) NOT NULL default '1',
`require_email_verification` tinyint(4) NOT NULL default '1',
`send_link_accepted_emails` tinyint(4) NOT NULL default '1',
`links_sort_order` varchar(6) NOT NULL default 'ASC',
`links_sort_row` varchar(20) NOT NULL default 'date_added',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_linx_settings`
--
INSERT INTO `jos_linx_settings` (`id`, `use_cats`, `cat_display_columns`, `require_recip_link`, `my_url`, `my_link_name`, `my_link_description`, `use_description`, `description_maxlength`, `recip_link_timeout_secconds`, `links_per_page`, `use_curl`, `debug`, `enable_email_accept_links`, `recieve_link_emails`, `require_email_verification`, `send_link_accepted_emails`, `links_sort_order`, `links_sort_row`) VALUES
(1, 0, 2, 0, 'http://www.ucgrafica2.com', '', 'Joomla - the dynamic portal engine and content management system', 1, 400, '7776000', 10, 0, 0, 0, 0, 0, 0, 'ASC', 'date_added');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_mambots`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
--
-- Dump dei dati per la tabella `jos_mambots`
--
INSERT INTO `jos_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, 2, 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, 'Ricerca nei contenuti', 'content.searchbot', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(7, 'Ricerca nei collegamenti web', 'weblinks.searchbot', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(8, 'Supporto codice', 'moscode', 'content', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(9, 'Nessun editor WYSIWYG', 'none', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(10, 'Editor TinyMCE WYSIWYG', 'tinymce', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', 'theme=advanced'),
(11, 'Bottone editor MOS Image', 'mosimage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(12, 'Bottone editor MOS Pagebreak', 'mospage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(13, 'Ricerca nei contati', 'contacts.searchbot', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(14, 'Ricerca nelle categorie', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(15, 'Ricerca nelle sezioni', '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, 6, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(18, 'Ricerca nei newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(19, 'Carica posizione moduli', 'mosloadposition', 'content', 0, 7, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(20, 'JCE Editor Mambot', 'jce', 'editors', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_menu`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Dump dei dati per la tabella `jos_menu`
--
INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES
(1, 'mainmenu', 'Home', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'leading=1\r\nintro=2\r\ncolumns=1\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Benvenuto in prima pagina\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0'),
(2, 'mainmenu', 'Prodotti', 'index.php?option=com_content&task=view&id=2', 'content_typed', 1, 0, 2, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(3, 'mainmenu', 'Servizi', 'index.php?option=com_content&task=view&id=3', 'content_typed', 1, 0, 3, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(4, 'mainmenu', 'Contatti', 'index.php?option=com_contact', 'components', -2, 0, 7, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(5, 'mainmenu', 'Contatti', 'index.php?option=com_contact&task=view&contact_id=1', 'contact_item_link', 1, 0, 1, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\npage_title=1\nheader=\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1'),
(6, 'othermenu', 'Landing1', 'index.php?option=com_content&task=view&id=4', 'content_typed', 1, 0, 4, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(7, 'othermenu', 'Landing2', 'index.php?option=com_content&task=view&id=5', 'content_typed', 1, 0, 5, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(8, 'othermenu', 'Landing3', 'index.php?option=com_content&task=view&id=6', 'content_typed', 1, 0, 6, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(9, 'othermenu', 'Landing4', 'index.php?option=com_content&task=view&id=7', 'content_typed', 1, 0, 7, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(10, 'othermenu', 'Landing5', 'index.php?option=com_content&task=view&id=8', 'content_typed', 1, 0, 8, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'),
(11, 'othermenu', 'Mappa', 'Mappa.html', 'url', 1, 0, 0, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1'),
(12, 'othermenu', 'Link', 'index.php?option=com_linx', 'components', 1, 0, 34, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(13, 'mainmenu', 'Dove Siamo', 'index.php?option=com_content&task=view&id=1', 'content_typed', 1, 0, 1, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(14, 'topmenu', 'Consumer', 'index.php?option=com_content&task=view&id=10', 'content_typed', 1, 0, 10, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(15, 'topmenu', 'Intelligent', 'index.php?option=com_content&task=view&id=11', 'content_typed', 1, 0, 11, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(16, 'topmenu', 'Fotovoltaico', 'index.php?option=com_content&task=view&id=12', 'content_typed', 1, 0, 12, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(17, 'topmenu', 'Progetto Luce', 'index.php?option=com_content&task=view&id=13', 'content_typed', 1, 0, 13, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''),
(18, 'topmenu', 'Climatizzazione', 'index.php?option=com_content&task=view&id=14', 'content_typed', 1, 0, 14, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_messages`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_messages`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_messages_cfg`
--
CREATE TABLE IF NOT EXISTS `jos_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 KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_messages_cfg`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_modules`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
--
-- Dump dei dati per la tabella `jos_modules`
--
INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES
(1, 'Sondaggi', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_poll', 0, 0, 1, '', 0, 0),
(2, 'Menu utente', '', 3, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0),
(3, 'Menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'class_sfx=\nmoduleclass_sfx=\nmenutype=mainmenu\nmenu_style=vert_indent\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=|\nend_spacer=|', 1, 0),
(4, 'Login Form', '', 4, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_login', 0, 0, 1, '', 1, 0),
(5, 'Syndication', '', 5, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_rssfeed', 0, 0, 1, '', 1, 0),
(6, 'Ultime notizie', '', 4, 'user1', 0, '0000-00-00 00:00:00', 0, 'mod_latestnews', 0, 0, 1, '', 1, 0),
(7, 'Statistiche', '', 6, '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, 'Chi e'' online', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0),
(9, 'I piu'' letti', '', 6, 'user2', 0, '0000-00-00 00:00:00', 0, 'mod_mostread', 0, 0, 1, '', 0, 0),
(10, 'Scelta template', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_templatechooser', 0, 0, 1, 'show_preview=1', 0, 0),
(11, 'Archivio', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0),
(12, 'Sezioni', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0),
(13, 'Annunci', '', 2, 'top', 0, '0000-00-00 00:00:00', 0, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0),
(14, 'Articoli correlati', '', 10, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0),
(15, 'Cerca', '', 1, 'user4', 0, '0000-00-00 00:00:00', 0, 'mod_search', 0, 0, 0, '', 0, 0),
(16, 'Immagine casuale', '', 9, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_random_image', 0, 0, 1, '', 0, 0),
(17, 'Other Menu', '', 1, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=-nav\nmoduleclass_sfx=\nmenutype=othermenu\nmenu_style=horiz_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=|\nend_spacer=|', 1, 0),
(18, 'Banner', '', 1, 'banner', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0),
(19, 'Componenti', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_components', 0, 99, 1, '', 1, 1),
(20, 'I piu'' letti', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 99, 1, '', 0, 1),
(21, 'Articoli recenti', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 99, 1, '', 0, 1),
(22, 'Stato menu', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 99, 1, '', 0, 1),
(23, 'Messaggi non letti', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 99, 1, '', 1, 1),
(24, 'Utenti connessi', '', 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, 'Messaggi di sistema', '', 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),
(30, 'Top Menu', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=\nmoduleclass_sfx=\nmenutype=topmenu\nmenu_style=list_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=|\nend_spacer=|', 0, 0),
(31, 'Wrapper', '', 11, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0),
(32, 'Connessi', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 99, 1, '', 0, 1);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_modules_menu`
--
CREATE TABLE IF NOT EXISTS `jos_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;
--
-- Dump dei dati per la tabella `jos_modules_menu`
--
INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES
(1, 1),
(2, 0),
(3, 0),
(4, 1),
(5, 1),
(6, 1),
(6, 2),
(6, 4),
(6, 27),
(6, 36),
(8, 1),
(9, 1),
(9, 2),
(9, 4),
(9, 27),
(9, 36),
(10, 1),
(13, 0),
(15, 0),
(17, 0),
(18, 0),
(30, 2),
(30, 14),
(30, 15),
(30, 16),
(30, 17),
(30, 18);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_newsfeeds`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_newsfeeds`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_polls`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_polls`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_poll_data`
--
CREATE TABLE IF NOT EXISTS `jos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_poll_data`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_poll_date`
--
CREATE TABLE IF NOT EXISTS `jos_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 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_poll_date`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_poll_menu`
--
CREATE TABLE IF NOT EXISTS `jos_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;
--
-- Dump dei dati per la tabella `jos_poll_menu`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_sections`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_sections`
--
INSERT INTO `jos_sections` (`id`, `title`, `name`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES
(1, 'Home', 'Home', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'imagefolders=*1*');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_sef_alias`
--
CREATE TABLE IF NOT EXISTS `jos_sef_alias` (
`id` int(11) NOT NULL auto_increment,
`non_sef_url` text NOT NULL,
`alias` text NOT NULL,
`title` text NOT NULL,
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `non_sef_url` (`non_sef_url`(255)),
KEY `alias` (`alias`(255)),
KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dump dei dati per la tabella `jos_sef_alias`
--
INSERT INTO `jos_sef_alias` (`id`, `non_sef_url`, `alias`, `title`, `metakey`, `metadesc`, `published`) VALUES
(2, 'index.php?option=com_xmap&sitemap=1', 'Mappa', 'Mappa', 'Mappa del sito', 'Mappa del sito', 1),
(3, 'index.php?option=com_linx&Itemid=12', 'Link', 'Qui va messo un titolo appropriato alla categoria', '', '', 1);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_sef_config`
--
CREATE TABLE IF NOT EXISTS `jos_sef_config` (
`id` tinyint(1) NOT NULL auto_increment,
`blogsection` varchar(50) NOT NULL default 'blogsection',
`blogcategory` varchar(50) NOT NULL default 'blogcategory',
`archivesection` varchar(50) NOT NULL default 'archivesection',
`archivecategory` varchar(50) NOT NULL default 'archivecategory',
`frontpage` varchar(50) NOT NULL default 'frontpage',
`weblinks` varchar(50) NOT NULL default 'weblinks',
`poll` varchar(50) NOT NULL default 'poll',
`banners` varchar(50) NOT NULL default 'banners',
`contact` varchar(50) NOT NULL default 'contact',
`login` varchar(50) NOT NULL default 'login',
`registration` varchar(50) NOT NULL default 'registration',
`search` varchar(50) NOT NULL default 'search',
`newsfeeds` varchar(50) NOT NULL default 'newsfeeds',
`wrapper` varchar(50) NOT NULL default 'wrapper',
`custom_comp` text NOT NULL,
`enabled` tinyint(1) NOT NULL default '1',
`space` varchar(10) NOT NULL default '-',
`sufix` varchar(10) NOT NULL default '',
`longurl` tinyint(1) NOT NULL default '1',
`lowercase` tinyint(1) NOT NULL default '1',
`homeroot` tinyint(1) NOT NULL default '1',
`uniqitem` tinyint(1) NOT NULL default '0',
`fish` tinyint(1) NOT NULL default '0',
`bird` tinyint(1) NOT NULL default '1',
`nsrd` tinyint(1) NOT NULL default '0',
`www_redirect` tinyint(1) NOT NULL default '1',
`debug` tinyint(1) NOT NULL default '0',
`debugip` varchar(20) NOT NULL default '',
`custom404` varchar(255) NOT NULL default '',
`url_replace` text NOT NULL,
`url_exception` text NOT NULL,
`com_exception` text NOT NULL,
`cache` tinyint(1) NOT NULL default '0',
`cachetime` int(11) NOT NULL default '0',
`log404` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_sef_config`
--
INSERT INTO `jos_sef_config` (`id`, `blogsection`, `blogcategory`, `archivesection`, `archivecategory`, `frontpage`, `weblinks`, `poll`, `banners`, `contact`, `login`, `registration`, `search`, `newsfeeds`, `wrapper`, `custom_comp`, `enabled`, `space`, `sufix`, `longurl`, `lowercase`, `homeroot`, `uniqitem`, `fish`, `bird`, `nsrd`, `www_redirect`, `debug`, `debugip`, `custom404`, `url_replace`, `url_exception`, `com_exception`, `cache`, `cachetime`, `log404`) VALUES
(1, 'blogsection', 'blogcategory', 'archivesection', 'archivecategory', 'frontpage', 'linx', 'poll', 'banners', 'contact', 'login', 'registration', 'search', 'newsfeeds', 'wrapper', 'customcomp=>cc', 1, '-', '.html', 1, 1, 1, 0, 0, 1, 0, 1, 0, '', '', 'Ã¥=>aa', '?|!|,|;', 'com_linx', 0, 86400, 0);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_sef_log`
--
CREATE TABLE IF NOT EXISTS `jos_sef_log` (
`id` int(11) NOT NULL auto_increment,
`url` text NOT NULL,
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(15) NOT NULL default '',
`referer` text NOT NULL,
PRIMARY KEY (`id`),
KEY `url` (`url`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_sef_log`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_sef_redirect`
--
CREATE TABLE IF NOT EXISTS `jos_sef_redirect` (
`id` int(11) NOT NULL auto_increment,
`source` text NOT NULL,
`target` text NOT NULL,
`type` varchar(50) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `source` (`source`(255)),
KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_sef_redirect`
--
INSERT INTO `jos_sef_redirect` (`id`, `source`, `target`, `type`, `published`) VALUES
(1, 'some/url/', 'animals/pets/cat/', '301 Moved Permanently', 0);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_session`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_session`
--
INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`) VALUES
('', '1214551570', '1efe0771768f68722676c0d5502ee92b', 1, 0, '', 0);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_stats_agents`
--
CREATE TABLE IF NOT EXISTS `jos_stats_agents` (
`agent` varchar(255) NOT NULL default '',
`type` tinyint(1) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_stats_agents`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_templates_menu`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_templates_menu`
--
INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES
('formell', 0, 0),
('joomla_admin', 0, 1);
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_template_positions`
--
CREATE TABLE IF NOT EXISTS `jos_template_positions` (
`id` int(11) NOT NULL auto_increment,
`position` varchar(10) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
--
-- Dump dei dati per la tabella `jos_template_positions`
--
INSERT INTO `jos_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', '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_users`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;
--
-- Dump dei dati per la tabella `jos_users`
--
INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'admin', 'a.panella@unitedcomunication.it', '411752561428c642ad17bfff442f7d2d:sO5PxL5mHtPZuSh5', 'Super Administrator', 0, 1, 25, '2008-04-30 07:59:44', '2008-06-27 02:26:08', '', 'editor=\nexpired=\nexpired_time='),
(63, 'Arcibold', 'arcibold', 'advertising@unitedcomunication.it', '5e95a295c016ce66b535caf10b5472ea:bI8ydQ1qQIVqq5fX', 'Administrator', 0, 0, 24, '2008-05-17 10:55:02', '0000-00-00 00:00:00', '', 'editor=');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_usertypes`
--
CREATE TABLE IF NOT EXISTS `jos_usertypes` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`mask` varchar(11) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_usertypes`
--
INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES
(0, 'superadministrator', ''),
(1, 'administrator', ''),
(2, 'editor', ''),
(3, 'user', ''),
(4, 'author', ''),
(5, 'publisher', ''),
(6, 'manager', '');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_weblinks`
--
CREATE TABLE IF NOT EXISTS `jos_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dump dei dati per la tabella `jos_weblinks`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_xmap`
--
CREATE TABLE IF NOT EXISTS `jos_xmap` (
`name` varchar(30) NOT NULL default '',
`value` varchar(100) default NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `jos_xmap`
--
INSERT INTO `jos_xmap` (`name`, `value`) VALUES
('version', '1.0'),
('classname', 'sitemap'),
('expand_category', '1'),
('expand_section', '1'),
('show_menutitle', '1'),
('columns', '1'),
('exlinks', '1'),
('ext_image', 'img_grey.gif'),
('exclmenus', ''),
('includelink', '1'),
('sitemap_default', '1');
-- --------------------------------------------------------
--
-- Struttura della tabella `jos_xmap_sitemap`
--
CREATE TABLE IF NOT EXISTS `jos_xmap_sitemap` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`expand_category` int(11) default NULL,
`expand_section` int(11) default NULL,
`show_menutitle` int(11) default NULL,
`columns` int(11) default NULL,
`exlinks` int(11) default NULL,
`ext_image` varchar(255) default NULL,
`menus` text,
`exclmenus` varchar(255) default NULL,
`includelink` int(11) default NULL,
`usecache` int(11) default NULL,
`cachelifetime` int(11) default NULL,
`classname` varchar(255) default NULL,
`count_xml` int(11) default NULL,
`count_html` int(11) default NULL,
`views_xml` int(11) default NULL,
`views_html` int(11) default NULL,
`lastvisit_xml` int(11) default NULL,
`lastvisit_html` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dump dei dati per la tabella `jos_xmap_sitemap`
--
INSERT INTO `jos_xmap_sitemap` (`id`, `name`, `expand_category`, `expand_section`, `show_menutitle`, `columns`, `exlinks`, `ext_image`, `menus`, `exclmenus`, `includelink`, `usecache`, `cachelifetime`, `classname`, `count_xml`, `count_html`, `views_xml`, `views_html`, `lastvisit_xml`, `lastvisit_html`) VALUES
(1, 'Nuova Sitemap', 1, 1, 1, 1, 1, 'img_grey.gif', 'mainmenu,0,1,1,0.5,monthly\ntopmenu,1,1,1,0.5,daily', '', 1, 0, 900, 'xmap', 0, 5, 0, 10, 0, 1213922192);