-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 24, 2011 at 07:21 PM
-- Server version: 5.0.92
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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: `ptreal_vehicle`
--

-- --------------------------------------------------------

--
-- Table structure for table `company`
--

CREATE TABLE IF NOT EXISTS `company` (
  `id` int(10) NOT NULL auto_increment,
  `module` int(10) NOT NULL default '0',
  `name` varchar(100) default '',
  `phone1` varchar(30) default '',
  `phone2` varchar(30) default '',
  `fax` varchar(30) default '',
  `address1` varchar(50) default '',
  `address2` varchar(50) default '',
  `city` varchar(30) default '',
  `state` varchar(30) default '',
  `zip` varchar(11) default '',
  `primaryUrl` varchar(255) default '',
  `owner` int(11) NOT NULL default '0',
  `companyDesc` text NOT NULL,
  `type` int(3) NOT NULL default '0',
  `email` varchar(255) default NULL,
  `custom` longtext,
  PRIMARY KEY  (`id`),
  KEY `idx_cpy1` (`owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `module`, `name`, `phone1`, `phone2`, `fax`, `address1`, `address2`, `city`, `state`, `zip`, `primaryUrl`, `owner`, `companyDesc`, `type`, `email`, `custom`) VALUES
(1, 0, 'Trivus', '244837817', '244 837 817', '244837817', 'Rua Cidade Tokushima n. 17 1 F', '', 'Capuchos Leiria', '', '2400-119', 'www.trivus-si.com', 1, '<p>Empesa respons&aacute;vel</p>', 2, 'infor@trivus.com', NULL),
(4, 0, 'AUTO PTREAL', '244837817', '', '244837817', 'Rua Cidade de Tokushima Lt 17 1? F - Leiria', '', 'Leiria', '', '2400-119', '', 0, '', 2, 'infor@trivus.com', NULL),
(3, 0, 'Auto Exemplo - Filial 2', '000000000', '', '000000000', 'Marqu?s de Pombal - Lisboa', '', 'Lisboa', '', '2400-000', '', 0, '<p>bb</p>', 2, 'infor@trivus.com', NULL),
(5, 0, 'AUTO Stand - exemplo do seu terceiro stand', '000000000', '', '', 'Rua de Braga - Faro virtual - Porto', '', 'Porto', '', '2625-065', '', 0, '', 2, 'infor@trivus.com', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `cGroup` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `nameConfig` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`id`, `name`, `value`, `type`, `cGroup`) VALUES
(65, 'local', 'pt', 'text', 'sys'),
(66, 'style', 'default', 'text', 'sys'),
(67, 'company', 'AUTO PTREAL', 'text', 'sys'),
(68, 'title', 'Concessionária Multi Marcas', 'text', 'user'),
(69, 'site', 'trivus-si.com', 'text', 'sys'),
(70, 'email_prefix', '[trivus-si]', 'text', 'sys'),
(71, 'admin_username', 'admin', 'text', 'sys'),
(72, 'username_min_len', '4', 'text', 'sys'),
(73, 'password_min_len', '4', 'text', 'sys'),
(74, 'log_changes', 'false', 'checkbox', 'sys'),
(75, 'locale_warn', 'false', 'checkbox', 'sys'),
(76, 'numero_menus', '4', 'text', 'sys'),
(77, 'logo', 'logo.jpg', 'fileUpload', 'user'),
(78, 'numero_submenus', '4', 'text', 'sys'),
(79, 'default_m', 'vehicle', 'text', 'sys'),
(80, 'default_a', 'index', 'text', 'sys'),
(81, 'default_ma', 'vehicle', 'text', 'sys'),
(82, 'default_aa', 'index', 'text', 'sys'),
(113, 'background', '#000000', 'color', 'user');

-- --------------------------------------------------------

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL auto_increment,
  `firstName` varchar(30) default NULL,
  `lastName` varchar(30) default NULL,
  `orderBy` varchar(30) NOT NULL default '',
  `title` varchar(50) default NULL,
  `birthday` date default NULL,
  `job` varchar(255) default NULL,
  `company` varchar(100) NOT NULL default '',
  `department` tinytext,
  `type` varchar(20) default NULL,
  `email` varchar(255) default NULL,
  `email2` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `phone` varchar(30) default NULL,
  `phone2` varchar(30) default NULL,
  `fax` varchar(30) default NULL,
  `mobile` varchar(30) default NULL,
  `address1` varchar(60) default NULL,
  `address2` varchar(60) default NULL,
  `city` varchar(30) default NULL,
  `state` varchar(30) default NULL,
  `zip` varchar(11) default NULL,
  `country` varchar(30) default NULL,
  `jabber` varchar(255) default NULL,
  `icq` varchar(20) default NULL,
  `msn` varchar(255) default NULL,
  `yahoo` varchar(255) default NULL,
  `aol` varchar(30) default NULL,
  `notes` text,
  `icon` varchar(20) default 'obj/contact',
  `owner` int(10) unsigned default '0',
  `private` tinyint(3) unsigned default '0',
  PRIMARY KEY  (`id`),
  KEY `idx_oby` (`orderBy`),
  KEY `idx_co` (`company`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `firstName`, `lastName`, `orderBy`, `title`, `birthday`, `job`, `company`, `department`, `type`, `email`, `email2`, `url`, `phone`, `phone2`, `fax`, `mobile`, `address1`, `address2`, `city`, `state`, `zip`, `country`, `jabber`, `icq`, `msn`, `yahoo`, `aol`, `notes`, `icon`, `owner`, `private`) VALUES
(1, 'Luciano', 'Letra', '', NULL, '0000-00-00', NULL, '0', NULL, '2', 'admin@localhost', NULL, NULL, '', '', NULL, '', '', '', '', '', '', '', NULL, '', NULL, NULL, '', NULL, 'obj/contact', 0, 0),
(2, 'Pedro', 'Domingues', '', '-------', NULL, NULL, '', NULL, 'proprietario', NULL, NULL, NULL, '111111111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 0, 0),
(3, 'Gestor', 'website', '', NULL, '0000-00-00', NULL, '1', NULL, NULL, 'suporte@trivus.coms', NULL, NULL, '', '', NULL, '', '', '', '', '', '', '', NULL, '', NULL, NULL, '', NULL, 'obj/contact', 0, 0),
(4, 'Utilizador', 'Convidado', '', NULL, '0000-00-00', NULL, '5', NULL, NULL, 'infor@trivus.com', NULL, NULL, '', '', NULL, '', '', '', '', '', '', '', NULL, '', NULL, NULL, '', NULL, 'obj/contact', 0, 0),
(5, 'cliente', 'utilizador', '', NULL, NULL, NULL, '1', NULL, NULL, 'trivus.si@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(6, 'stand', 'sucesso', '', NULL, NULL, NULL, '0', NULL, '2', 'trivus.si@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(7, 'auto', 'teste', '', NULL, NULL, NULL, '1', NULL, '2', 'infor@trivus.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(8, '123', '123', '', NULL, NULL, NULL, '1', NULL, '2', 'infor@trivus.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 7, 0),
(9, 'Auto', 'Testes', '', NULL, NULL, NULL, '4', NULL, '2', 'infor@trivus.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `emailmessages`
--

CREATE TABLE IF NOT EXISTS `emailmessages` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(100) default '',
  `sectionId` varchar(30) default '',
  `message` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `favorite`
--

CREATE TABLE IF NOT EXISTS `favorite` (
  `userId` int(11) NOT NULL default '0',
  `vehicleId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userId`,`vehicleId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `id` int(19) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `title` varchar(128) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `owner` int(11) default '0',
  `date` varchar(50) default NULL,
  `size` int(11) default '0',
  `parentId` int(11) NOT NULL default '0',
  `moduleId` int(11) NOT NULL default '0',
  `category` int(11) default '0',
  `ext` varchar(128) NOT NULL,
  `url` varchar(254) NOT NULL default '',
  `thumbUrl` varchar(254) default NULL,
  `published` tinyint(1) NOT NULL default '0',
  `firstimage` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_file_parentId` (`parentId`),
  KEY `idx_file_moduleId` (`moduleId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=665 ;

--
-- Dumping data for table `file`
--

INSERT INTO `file` (`id`, `name`, `title`, `description`, `owner`, `date`, `size`, `parentId`, `moduleId`, `category`, `ext`, `url`, `thumbUrl`, `published`, `firstimage`) VALUES
(371, '00e2c410-17f7-4365-87e5-a761c4b39c26h320w427.jpg', '', '', 0, NULL, 28, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/00e2c410-17f7-4365-87e5-a761c4b39c26h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/00e2c410-17f7-4365-87e5-a761c4b39c26h320w427.jpg', 0, 0),
(372, '2eb5c2a0-a179-4cf7-8f16-985cd3b72b40h320w427.jpg', '', '', 0, NULL, 29, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/2eb5c2a0-a179-4cf7-8f16-985cd3b72b40h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/2eb5c2a0-a179-4cf7-8f16-985cd3b72b40h320w427.jpg', 0, 0),
(373, '3e93ec58-7481-4c7f-b823-19153027b877h320w427.jpg', '', '', 0, NULL, 28, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/3e93ec58-7481-4c7f-b823-19153027b877h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/3e93ec58-7481-4c7f-b823-19153027b877h320w427.jpg', 0, 0),
(374, '86fd3595-624d-40a1-b209-43183d310ecbh320w427.jpg', '', '', 0, NULL, 20, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/86fd3595-624d-40a1-b209-43183d310ecbh320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/86fd3595-624d-40a1-b209-43183d310ecbh320w427.jpg', 0, 0),
(375, '889c72c4-4ffe-4bc6-acc1-0ffd99ccfbc1h320w427.jpg', '', '', 0, NULL, 30, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/889c72c4-4ffe-4bc6-acc1-0ffd99ccfbc1h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/889c72c4-4ffe-4bc6-acc1-0ffd99ccfbc1h320w427.jpg', 0, 0),
(590, '23047219947ac52037ebf6.jpg', '', '', 0, '01/01/1970,01:00', 8, 589, 0, 0, 'jpg', 'http://auto.ptreal.com/media/img//headlines/23047219947ac52037ebf6.jpg', 'http://auto.ptreal.com/media/img//headlines/thumbs/23047219947ac52037ebf6.jpg', 0, NULL),
(664, '16186384164ea5984394656.jpg', '', '', 0, NULL, 32, 139, 18, 0, 'jpg', 'http://auto.ptreal.com/media/img/headline/16186384164ea5984394656.jpg', 'http://auto.ptreal.com/media/img/headline/thumbs/16186384164ea5984394656.jpg', 0, 0),
(307, 'ws_2005_aeromax_1920x1440.jpg', '', '', 0, NULL, 8, 36, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/36/ws_2005_aeromax_1920x1440.jpg', 'http://auto.ptreal.com/media/img/vehicle/36/thumbs/ws_2005_aeromax_1920x1440.jpg', 0, 0),
(591, '20482891747ac5378dc232.jpg', '', '', 0, '08/02/2008,14:04', 8, 590, 0, 0, 'jpg', 'http://auto.ptreal.com/media/img//headlines/20482891747ac5378dc232.jpg', 'http://auto.ptreal.com/media/img//headlines/thumbs/20482891747ac5378dc232.jpg', 0, NULL),
(634, 'ford ss 1-1.jpg', '', '', 0, NULL, 133, 52, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/52/ford ss 1-1.jpg', 'http://auto.ptreal.com/media/img/vehicle/52/thumbs/ford ss 1-1.jpg', 0, 0),
(301, 'alfa-romeo-8c-competzione.jpg', '', '', 0, NULL, 14, 36, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/36/alfa-romeo-8c-competzione.jpg', 'http://auto.ptreal.com/media/img/vehicle/36/thumbs/alfa-romeo-8c-competzione.jpg', 0, 0),
(632, 'a129a6c9-49a2-41da-be83-1e939e3a9690h320w427.jpg', '', '', 0, NULL, 25, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/a129a6c9-49a2-41da-be83-1e939e3a9690h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/a129a6c9-49a2-41da-be83-1e939e3a9690h320w427.jpg', 0, 0),
(311, 'ws_bufori_blue_cream_1920x1440.jpg', '', '', 0, NULL, 8, 36, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/36/ws_bufori_blue_cream_1920x1440.jpg', 'http://auto.ptreal.com/media/img/vehicle/36/thumbs/ws_bufori_blue_cream_1920x1440.jpg', 0, 0),
(309, 'ws_alfa_romeo_spix_1920x1440.jpg', '', '', 0, NULL, 12, 36, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/36/ws_alfa_romeo_spix_1920x1440.jpg', 'http://auto.ptreal.com/media/img/vehicle/36/thumbs/ws_alfa_romeo_spix_1920x1440.jpg', 0, 1),
(635, 'lamborghini3-1.jpg', '', '', 0, NULL, 115, 52, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/52/lamborghini3-1.jpg', 'http://auto.ptreal.com/media/img/vehicle/52/thumbs/lamborghini3-1.jpg', 0, 0),
(308, 'ws_2006_aeromax_1920x1440.jpg', '', '', 0, NULL, 10, 36, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/36/ws_2006_aeromax_1920x1440.jpg', 'http://auto.ptreal.com/media/img/vehicle/36/thumbs/ws_2006_aeromax_1920x1440.jpg', 0, 0),
(386, 'retroconcept-vinci-sport-4-lg.jpg', '', '', 0, NULL, 82, 49, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/49/retroconcept-vinci-sport-4-lg.jpg', 'http://auto.ptreal.com/media/img/vehicle/49/thumbs/retroconcept-vinci-sport-4-lg.jpg', 0, 0),
(368, 'f103fd95-a979-4a3d-9b8f-036f58204b28h320w427-1.jpg', '', '', 0, NULL, 17, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/f103fd95-a979-4a3d-9b8f-036f58204b28h320w427-1.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/f103fd95-a979-4a3d-9b8f-036f58204b28h320w427-1.jpg', 0, 0),
(364, '1681d207-e681-4ad5-aad8-c9a7873d9b8bh320w427.jpg', '', '', 0, NULL, 13, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/1681d207-e681-4ad5-aad8-c9a7873d9b8bh320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/1681d207-e681-4ad5-aad8-c9a7873d9b8bh320w427.jpg', 0, 0),
(365, 'aaa.jpg', '', '', 0, NULL, 24, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/aaa.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/aaa.jpg', 0, 0),
(367, 'd7fab68b-8b63-4df2-b1f6-ddbed249e6ceh320w427.jpg', '', '', 0, NULL, 26, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/d7fab68b-8b63-4df2-b1f6-ddbed249e6ceh320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/d7fab68b-8b63-4df2-b1f6-ddbed249e6ceh320w427.jpg', 0, 0),
(361, '18e97215-54ed-4086-a2b7-9ff3e032cd90h320w427.jpg', '', '', 0, NULL, 20, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/18e97215-54ed-4086-a2b7-9ff3e032cd90h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/18e97215-54ed-4086-a2b7-9ff3e032cd90h320w427.jpg', 0, 1),
(362, '69c9386f-1284-471e-ab50-ce7b52de2359h320w427-1.jpg', '', '', 0, NULL, 25, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/69c9386f-1284-471e-ab50-ce7b52de2359h320w427-1.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/69c9386f-1284-471e-ab50-ce7b52de2359h320w427-1.jpg', 0, 0),
(363, '102a52c1-6134-48f0-b9ac-bd070a5c01b0h320w427.jpg', '', '', 0, NULL, 22, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/102a52c1-6134-48f0-b9ac-bd070a5c01b0h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/102a52c1-6134-48f0-b9ac-bd070a5c01b0h320w427.jpg', 0, 0),
(384, 'retroconcept-vinci-sport-2-lg.jpg', '', '', 0, NULL, 115, 49, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/49/retroconcept-vinci-sport-2-lg.jpg', 'http://auto.ptreal.com/media/img/vehicle/49/thumbs/retroconcept-vinci-sport-2-lg.jpg', 0, 0),
(385, 'retroconcept-vinci-sport-3-lg.jpg', '', '', 0, NULL, 97, 49, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/49/retroconcept-vinci-sport-3-lg.jpg', 'http://auto.ptreal.com/media/img/vehicle/49/thumbs/retroconcept-vinci-sport-3-lg.jpg', 0, 0),
(376, 'a129a6c9-49a2-41da-be83-1e939e3a9690h320w427.jpg', '', '', 0, NULL, 25, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/a129a6c9-49a2-41da-be83-1e939e3a9690h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/a129a6c9-49a2-41da-be83-1e939e3a9690h320w427.jpg', 0, 0),
(377, 'eb510672-b101-4045-b9e2-e0c89126beaah320w427.jpg', '', '', 0, NULL, 26, 51, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/51/eb510672-b101-4045-b9e2-e0c89126beaah320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/51/thumbs/eb510672-b101-4045-b9e2-e0c89126beaah320w427.jpg', 0, 0),
(378, 'lexus.jpg', '', '', 0, NULL, 444, 34, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/34/lexus.jpg', 'http://auto.ptreal.com/media/img/vehicle/34/thumbs/lexus.jpg', 0, 0),
(379, 'lexus_gs_450-1-copy-1.jpg', '', '', 0, NULL, 482, 34, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/34/lexus_gs_450-1-copy-1.jpg', 'http://auto.ptreal.com/media/img/vehicle/34/thumbs/lexus_gs_450-1-copy-1.jpg', 0, 1),
(387, 'retroconcept-vinci-sport-5-lg.jpg', '', '', 0, NULL, 73, 49, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/49/retroconcept-vinci-sport-5-lg.jpg', 'http://auto.ptreal.com/media/img/vehicle/49/thumbs/retroconcept-vinci-sport-5-lg.jpg', 0, 0),
(388, 'retroconcept-vinci-sport-6-lg.jpg', '', '', 0, NULL, 107, 49, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/49/retroconcept-vinci-sport-6-lg.jpg', 'http://auto.ptreal.com/media/img/vehicle/49/thumbs/retroconcept-vinci-sport-6-lg.jpg', 0, 0),
(641, '235346327_a01b559e4b_b.jpg', '', '', 0, NULL, 330, 53, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/53/235346327_a01b559e4b_b.jpg', 'http://auto.ptreal.com/media/img/vehicle/53/thumbs/235346327_a01b559e4b_b.jpg', 0, 0),
(631, '00e2c410-17f7-4365-87e5-a761c4b39c26h320w427.jpg', '', '', 0, NULL, 28, 50, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/50/00e2c410-17f7-4365-87e5-a761c4b39c26h320w427.jpg', 'http://auto.ptreal.com/media/img/vehicle/50/thumbs/00e2c410-17f7-4365-87e5-a761c4b39c26h320w427.jpg', 0, 0),
(588, '190354206847ac51af41ae7.jpg', '', '', 0, '01/01/1970,01:00', 8, 587, 0, 0, 'jpg', 'http://auto.ptreal.com/media/img//headlines/190354206847ac51af41ae7.jpg', 'http://auto.ptreal.com/media/img//headlines/thumbs/190354206847ac51af41ae7.jpg', 0, NULL),
(636, 'ws_chevrolet_corvette_1920x1440.jpg', '', '', 0, NULL, 532, 52, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/52/ws_chevrolet_corvette_1920x1440.jpg', 'http://auto.ptreal.com/media/img/vehicle/52/thumbs/ws_chevrolet_corvette_1920x1440.jpg', 0, 1),
(455, '5819~american-eagle-and-flag-ii-posters.jpg', '', '', 0, NULL, 44, 36, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/36/5819~american-eagle-and-flag-ii-posters.jpg', 'http://auto.ptreal.com/media/img/vehicle/36/thumbs/5819~american-eagle-and-flag-ii-posters.jpg', 0, 0),
(638, '29 2.jpg', '', '', 0, NULL, 17, 53, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/53/29 2.jpg', 'http://auto.ptreal.com/media/img/vehicle/53/thumbs/29 2.jpg', 0, 0),
(639, '28 2.jpg', '', '', 0, NULL, 30, 53, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/53/28 2.jpg', 'http://auto.ptreal.com/media/img/vehicle/53/thumbs/28 2.jpg', 0, 0),
(640, '', '', '', 0, NULL, 0, 53, 9, 0, '', 'http://auto.ptreal.com/media/img/vehicle/53/', 'http://auto.ptreal.com/media/img/vehicle/53/thumbs/', 0, 0),
(658, '2066025735483f0c6a357f4.jpg', '', '', 0, NULL, 69, 35, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/35/2066025735483f0c6a357f4.jpg', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/2066025735483f0c6a357f4.jpg', 0, 1),
(650, '1072041216483f0c12f4182.jpg', '', '', 0, NULL, 73, 35, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/35/1072041216483f0c12f4182.jpg', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/1072041216483f0c12f4182.jpg', 0, 0),
(651, '1606681603483f0c132ed40.jpg', '', '', 0, NULL, 89, 35, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/35/1606681603483f0c132ed40.jpg', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/1606681603483f0c132ed40.jpg', 0, 0),
(659, '1243035513497b694339895.jpg', '', '', 0, NULL, 18, 34, 9, 0, 'jpg', 'http://auto.ptreal.com/media/img/vehicle/34/1243035513497b694339895.jpg', 'http://auto.ptreal.com/media/img/vehicle/34/thumbs/1243035513497b694339895.jpg', 0, 0),
(653, '911113424483f0c139175f.', '', '', 0, NULL, 0, 35, 9, 0, '', 'http://auto.ptreal.com/media/img/vehicle/35/911113424483f0c139175f.', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/911113424483f0c139175f.', 0, 0),
(654, '173344550483f0c13936a1.', '', '', 0, NULL, 0, 35, 9, 0, '', 'http://auto.ptreal.com/media/img/vehicle/35/173344550483f0c13936a1.', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/173344550483f0c13936a1.', 0, 0),
(655, '672864186483f0c13955e0.', '', '', 0, NULL, 0, 35, 9, 0, '', 'http://auto.ptreal.com/media/img/vehicle/35/672864186483f0c13955e0.', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/672864186483f0c13955e0.', 0, 0),
(656, '1787772448483f0c139751f.', '', '', 0, NULL, 0, 35, 9, 0, '', 'http://auto.ptreal.com/media/img/vehicle/35/1787772448483f0c139751f.', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/1787772448483f0c139751f.', 0, 0),
(657, '54976051483f0c1399460.', '', '', 0, NULL, 0, 35, 9, 0, '', 'http://auto.ptreal.com/media/img/vehicle/35/54976051483f0c1399460.', 'http://auto.ptreal.com/media/img/vehicle/35/thumbs/54976051483f0c1399460.', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `headline`
--

CREATE TABLE IF NOT EXISTS `headline` (
  `id` int(5) NOT NULL auto_increment,
  `image` varchar(100) NOT NULL default '',
  `name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `active` int(1) unsigned NOT NULL default '0',
  `startDate` date NOT NULL default '0000-00-00',
  `endDate` date NOT NULL default '0000-00-00',
  `link` varchar(120) default NULL,
  `ordered` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=167 ;

--
-- Dumping data for table `headline`
--

INSERT INTO `headline` (`id`, `image`, `name`, `description`, `active`, `startDate`, `endDate`, `link`, `ordered`) VALUES
(139, 'Array', 'Auto PT REAL chega ao Brasil!', 'Após o sucesso obtido em Portugal o site AUTO PT REAL pretende alcançar uma posição de destaque no estado da BAHIA,Brasil!', 1, '0000-00-00', '0000-00-00', NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `mark`
--

CREATE TABLE IF NOT EXISTS `mark` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=79 ;

--
-- Dumping data for table `mark`
--

INSERT INTO `mark` (`id`, `name`) VALUES
(1, 'Peugeot'),
(2, 'teste2'),
(3, 'renault'),
(4, 'audi'),
(44, 'Citroen'),
(43, 'BMW'),
(40, 'Mustang'),
(39, 'Porche'),
(41, 'Aston Martin'),
(42, 'Bentley'),
(31, 'alfa romeo'),
(76, 'Vinci'),
(46, 'FIAT'),
(47, 'Ford'),
(48, 'Honda'),
(49, 'Hummer'),
(50, 'Jaguar'),
(51, 'Lamborghini'),
(52, 'Lexus'),
(53, 'Maserati'),
(54, 'Mazda'),
(55, 'Mercedes'),
(56, 'Mini'),
(57, 'Noble'),
(58, 'Nissan'),
(59, 'Porsche'),
(75, 'MG'),
(61, 'Rover'),
(62, 'Seat'),
(63, 'Suzuki'),
(64, 'Subaru'),
(65, 'Toyota'),
(66, 'TVR'),
(67, 'Vauxhall'),
(68, 'Volkswagen '),
(69, 'AC'),
(70, 'Lancia'),
(71, 'Chrysler'),
(72, 'Daewoo'),
(73, 'Jeep'),
(74, 'Kia'),
(77, 'Trivus'),
(78, 'marcax');

-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL auto_increment,
  `menuType` varchar(25) default NULL,
  `name` varchar(100) default NULL,
  `menuDesc` text NOT NULL,
  `link` text,
  `type` varchar(50) NOT NULL default '',
  `published` tinyint(1) NOT NULL default '0',
  `parent` int(11) unsigned NOT NULL default '0',
  `moduleId` int(11) unsigned NOT NULL default '0',
  `parentId` int(11) default '0',
  `ordered` 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 `moduleId` (`moduleId`,`menuType`,`published`,`access`),
  KEY `type` (`menuType`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id`, `menuType`, `name`, `menuDesc`, `link`, `type`, `published`, `parent`, `moduleId`, `parentId`, `ordered`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES
(63, '16', 'Oficinas e pintura', '<p><span style="font-size: xx-large;"><span style="color: #ff6600; font-size: x-large;"><span style="color: #0000ff;">S<span style="font-size: large;">ervi</span>&ccedil;os A</span></span></span></p>\r\n<p><span style="color: #ff6600; font-size: x-large;"><span style="font-size: small;">IVA &ndash; Comiss&atilde;o inicia processos por infrac&ccedil;&atilde;ocontra a Pol&oacute;nia e Portugal</span></span></p>\r\n<div>\r\n<p align="left"><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">(<strong><em>texto de exemplo</em></strong>)<br />A Comiss&atilde;o Europeia solicitou formalmente &agrave; Pol&oacute;nia e a Portugal quealterassem as legisla&ccedil;&otilde;es respectivas no que respeita &agrave; inclus&atilde;o domontante do imposto nacional de matr&iacute;cula autom&oacute;vel no valor tribut&aacute;vel ara efeitos de IVA no caso do fornecimento de ve&iacute;culos autom&oacute;veis. AComiss&atilde;o considera que o imposto de matr&iacute;cula n&atilde;o deve ser inclu&iacute;do nesse alor tribut&aacute;vel. As dilig&ecirc;ncias assumem a forma de um parecerfundamentado (segunda etapa do processo por infrac&ccedil;&atilde;o, prevista no rtigo 226.&ordm; do Tratado CE). Se as legisla&ccedil;&otilde;es nacionais n&atilde;o forem alteradasde modo a dar cumprimento aos pareceres fundamentados, a Comiss&atilde;o ode decidir instaurar uma ac&ccedil;&atilde;o no Tribunal de Justi&ccedil;a das ComunidadesEuropeias.</span></p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">No caso do fornecimento de ve&iacute;culos autom&oacute;veis, tanto a Pol&oacute;nia como Portugal ncluem o montante do imposto aplicado aos ve&iacute;culos (o oplata rejestracyjna e oimposto autom&oacute;vel) no valor tribut&aacute;vel do IVA. No processo C-98/05, o Tribunal de usti&ccedil;a das Comunidades Europeias analisou se, no caso do fornecimento de meiosde transporte, aquele valor tribut&aacute;vel deve ou n&atilde;o incluir o montante do imposto de atr&iacute;cula, que normalmente o fornecedor paga &agrave;s autoridades fiscais e o compradorpaga depois ao fornecedor, juntamente com o pre&ccedil;o do ve&iacute;culo. No processo eferido, o imposto de matr&iacute;cula em causa era o aplicado na Dinamarca. </span></div>\r\n<p align="justify">&nbsp;</p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">Segundo o ac&oacute;rd&atilde;o do Tribunal, no quadro de um contrato de venda que preveja ue o distribuidor entregue um ve&iacute;culo j&aacute; matriculado por um pre&ccedil;o que englobe oimposto de matr&iacute;cula que pagou antes da entrega do ve&iacute;culo, o montante desse mposto n&atilde;o pode ser inclu&iacute;do no valor tribut&aacute;vel do IVA a aplicar &agrave; venda dove&iacute;culo. Tal encontra justifica&ccedil;&atilde;o, em primeiro lugar, no facto de o imposto de atr&iacute;cula ser aplicado a t&iacute;tulo da matr&iacute;cula do ve&iacute;culo e n&atilde;o do fornecimento domesmo e, em segundo lugar, na circunst&acirc;ncia de o referido imposto ser pago pelo ornecedor do ve&iacute;culo por conta do adquirente. </span></div>\r\n<p align="justify">&nbsp;</p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">A Comiss&atilde;o entende que, apesar de algumas diferen&ccedil;as menores ou acess&oacute;rias, os mpostos autom&oacute;veis aplicados na Pol&oacute;nia e em Portugal s&atilde;o praticamente id&ecirc;nticosao imposto dinamarqu&ecirc;s analisado pelo Tribunal. Trata-se, nos tr&ecirc;s casos, de um mposto de presta&ccedil;&atilde;o &uacute;nica que &eacute; devido no momento da aquisi&ccedil;&atilde;o do ve&iacute;culo amotor ou que constitui condi&ccedil;&atilde;o para que este possa ser colocado em circula&ccedil;&atilde;o no errit&oacute;rio do Estado-Membro. </span></div>\r\n<p align="justify">&nbsp;</p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">As regras relativas ao valor tribut&aacute;vel do IVA foram harmonizadas a n&iacute;vel omunit&aacute;rio e a aplica&ccedil;&atilde;o uniforme das mesmas &eacute; condi&ccedil;&atilde;o essencial para o bomfuncionamento do regime do IVA. A Comiss&atilde;o considera, portanto, que h&aacute; que plicar aos impostos autom&oacute;veis existentes na Pol&oacute;nia e em Portugal crit&eacute;rioid&ecirc;ntico ao do Tribunal de Justi&ccedil;a no processo C-98/05. Foi dado a ambos os stados-Membros um prazo de dois meses para alinharem as legisla&ccedil;&otilde;esrespectivas com o direito comunit&aacute;rio. </span></div>\r\n<p align="justify">&nbsp;</p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">Os processos da Comiss&atilde;o t&ecirc;m os n&uacute;meros de refer&ecirc;ncia 2006/2216 (Pol&oacute;nia) e 006/4398 (Portugal). </span></div>\r\n<p align="justify">&nbsp;</p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">Os comunicados de imprensa sobre processos por infrac&ccedil;&atilde;o no dom&iacute;nio fiscal ou duaneiro podem ser consultadosem: <br /><a href="http://ec.europa.eu/taxation_customs/common/infringements/infringement_cases/index_en.htm" target="_blank"><span style="font-size: 8pt">http://ec.europa.eu/taxation_customs/common/infringements/infringement_cases/index_en.htm</span></a> </span></div>\r\n<p align="justify">&nbsp;</p>\r\n<div><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">Para obten&ccedil;&atilde;o das &uacute;ltimas informa&ccedil;&otilde;es gerais sobre medidas por infrac&ccedil;&atilde;o tomadas contra os Estados-Membros, consultar:</span><br /></div>\r\n<p align="left"><a href="http://ec.europa.eu/community_law/index_en.htm" target="_blank"><span style="font-size: 8pt; font-family: tahoma,arial,helvetica,sans-serif">http://ec.europa.eu/community_law/eulaw/index_en.htm </span></a></p>\r\n</div>', '?m=vehicle&a=infoUtil&id=63', 'topmenu_item_link', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, '2'),
(64, '16', 'Concessionária Multi Marcas', '<div class="main">\r\n<div class="header"><span style="font-size: xx-large;"><span style="font-family: arial,helvetica,sans-serif; font-size: medium;"><strong><span style="color: #800000; font-size: medium;"><span style="font-size: xx-large;">B</span><span style="font-size: xx-large;">em vindo ao site de demonstra&ccedil;&atilde;o para o seu stand autom&oacute;vel<img title="logotipo-trivus_400" src="http://www.auto.ptreal.com/media/img/ibrowser/logotipo-trivus_400.jpg" alt="logotipo-trivus_400" width="400" height="232" /></span>.</span></strong></span></span>\r\n<p style="margin: 0cm"><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><em><strong>Este &eacute; um </strong></em><strong><em>Texto de exemplo</em></strong></span></p>\r\n<p style="margin: 0cm">&nbsp;</p>\r\n<p style="margin: 0cm"><span style="color: #cc3300"><strong>O que &eacute; o </strong></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><strong><em><span style="color: #cc3300">AUTO</span> </em>PTREAL</strong></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><span style="color: #cc3300"><strong>?</strong></span><br />O <strong><em><span style="color: #cc3300">AUTO</span> </em>PTREAL</strong>, tal como o nome indica &eacute; um stand online vocacionado para a venda autom&oacute;vel. Este &eacute; seguramente um dos melhores softwares online para a venda do seu parque autom&oacute;vel.<br />Uma aplica&ccedil;&atilde;o desenvolvida sobre a plataforma ptreal, criada de raiz pela <a href="http://www.trivus-si.com/" target="_blank">Trivus</a></span><a href="http://www.trivus-si.com/" target="_blank"><sup><span style="font-size: 8pt; font-family: Tahoma">&reg;</span></sup><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"> Sistemas de Informa&ccedil;&atilde;o</span></a><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif">.<br /><br /><span style="color: #cc3300"><strong>Como funciona o </strong></span></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><strong><em><span style="color: #cc3300">AUTO</span> </em>PTREAL</strong></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><span style="color: #cc3300"><strong>?</strong></span><br />O </span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><strong><em><span style="color: #cc3300">AUTO</span> </em>PTREAL</strong></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"> funciona de forma simples.<br />Com uma navega&ccedil;&atilde;o cuidada na qual foram tidas em conta as normas de usabilidade.<br />O layout foi devidamente desenhado para que o seu stand seja uma refer&ecirc;ncia visual na internet.<br />Oferecemos-lhe ferramentas para que possa personalizar a imagem do seu stand sempre que necess&aacute;rio.<br /><br /><strong><span style="color: #cc3300">Vantagens em adquirir o </span></strong></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><strong><em><span style="color: #cc3300">AUTO</span> </em>PTREAL</strong></span><span style="font-size: 10pt; font-family: tahoma,arial,helvetica,sans-serif"><br />Tem o seu stand 24h por dia, 7 dias por semana como montra digital;<br />O site &eacute; um dos instrumentos de publicidade mais eficientes que existem. Serve de apoio a campanhas de publicidade de outros meios de comunica&ccedil;&atilde;o como o r&aacute;dio, televis&atilde;o, jornal, placas, panfletos, etc., pode constituir completa ou parcialmente o seu volume de neg&oacute;cios na presta&ccedil;&atilde;o de servi&ccedil;os, venda de produtos ou simplesmente informar com custos reduzidos em rela&ccedil;&atilde;o ao neg&oacute;cio "n&atilde;o virtual";<br />Aplicativo assente numa plataforma potente e s&oacute;lida;<br />Voc&ecirc; mesmo faz a gest&atilde;o de todo o site atrav&eacute;s de uma &aacute;rea de administra&ccedil;&atilde;o protegida por palavra passe.</span></p>\r\n</div>\r\n</div>', '?m=vehicle&a=infoUtil&id=64', 'topmenu_item_link', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, '2');

-- --------------------------------------------------------

--
-- Table structure for table `model`
--

CREATE TABLE IF NOT EXISTS `model` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `markId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;

--
-- Dumping data for table `model`
--

INSERT INTO `model` (`id`, `name`, `markId`) VALUES
(1, '206', 1),
(2, '159', 2),
(3, 'megane', 3),
(4, 'clio', 3),
(5, 'A 4', 4),
(23, 'Brera Coupe', 31),
(22, 'Cobra Replica', 69),
(21, '428 Frua', 69),
(24, 'Brera Sports Coupe', 31),
(25, 'Spyder ', 31),
(26, 'Bond Car', 41),
(27, 'DB7 Nose and Alloy Wheel', 41),
(28, 'M6 Coupe ', 43),
(29, 'Mini Cooper S', 43),
(30, 'Fox', 68),
(31, 'Golf MK5', 68),
(32, 'Beetle', 68),
(54, 'Lupo', 68),
(56, 'Varadero', 48),
(36, '4WD', 64),
(37, 'WRX STi Turbo', 64),
(38, 'WRX STi Turbo Alloy Wheel', 64),
(39, 'WRX STi Rear Spoiler', 64),
(40, 'Forester 2.0XT', 64),
(41, 'WRX STi Type UK', 64),
(42, 'WRX STi Headlight', 64),
(43, 'Alloy Wheel', 64),
(44, 'Legacy', 64),
(45, 'Outback 4X4', 64),
(46, 'Impreza Turbo', 64),
(47, 'LS-430', 52),
(48, 'GS-430', 52),
(49, 'LF', 52),
(50, 'GT', 76),
(51, 'Sport', 76),
(55, 'A3', 4),
(53, 'A6', 4),
(57, 'ABB', 77),
(58, 'xptoa', 42),
(59, 'modelo td', 78),
(60, '159', 31),
(61, '127', 46),
(62, 'shelby cobra', 69);

-- --------------------------------------------------------

--
-- Table structure for table `module`
--

CREATE TABLE IF NOT EXISTS `module` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `directory` varchar(64) NOT NULL default '',
  `version` varchar(10) NOT NULL default '',
  `setup` varchar(64) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  `active` int(1) unsigned NOT NULL default '0',
  `uiActive` int(1) unsigned NOT NULL default '0',
  `uiName` varchar(20) NOT NULL default '',
  `icon` varchar(64) NOT NULL default '',
  `ordered` tinyint(3) NOT NULL default '0',
  `position` varchar(5) default 'left',
  `description` varchar(255) NOT NULL default '',
  `frame` tinyint(1) default '0',
  PRIMARY KEY  (`id`,`directory`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `module`
--

INSERT INTO `module` (`id`, `name`, `directory`, `version`, `setup`, `type`, `active`, `uiActive`, `uiName`, `icon`, `ordered`, `position`, `description`, `frame`) VALUES
(1, 'User Administration', 'user', '1.0.0', '', 'core', 1, 0, 'User Admin', 'helix-setup-users.png', 2, '', '', 0),
(2, 'System Administration', 'system', '1.0.0', '', 'core', 1, 0, 'System Admin', '48_my_computer.png', 3, '', '', 0),
(5, 'Help', 'help', '1.00', 'Setup.php', 'core', 0, 0, 'Help', '', 6, '', '', 0),
(6, 'Files', 'file', '1.0.0', 'Setup', 'user', 1, 0, 'Files', 'file.gif', 7, 'left', 'module que permite fazer o upload de ficheiros', 1),
(7, 'Contact', 'contact', '1.0.0', 'Setup', 'user', 1, 0, 'Contacts', '.gif', 9, 'left', 'module que guarda contactos', 1),
(8, 'Company', 'company', '1.0.0', 'Setup', 'user', 1, 0, 'Contacts of company', 'companies.gif', 8, 'left', 'module que guarda empresas', 0),
(9, 'vehicle', 'vehicle', '1.0.0', 'Setup', 'user', 1, 0, 'Administration', 'store.png', 1, 'left', 'module text', 1),
(4, 'vehicle', 'vehicle&a=view', '1.0.0', '', 'user', 1, 0, 'vehicle', 'store.png', 4, 'left', 'module text', 1),
(15, 'Menu', 'menu', '1.0.0', 'Setup', 'user', 1, 0, 'Content', 'menu.gif', 12, 'left', 'module que permite adicionar um menu.', 1),
(16, 'Top menu', '', '', '', 'topmenu', 1, 0, '', '', 9, 'left', '', 0),
(18, 'headline', 'headline', '1.0.0', 'Setup', 'user', 1, 0, 'headlines', 'headline.png', 11, 'left', 'module que permite destacar algo de importante', 1);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(11) NOT NULL auto_increment,
  `permission_user` int(11) NOT NULL default '0',
  `permission_grant_on` varchar(12) NOT NULL default '',
  `permission_item` int(11) NOT NULL default '0',
  `permission_value` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_pgrant_on` (`permission_grant_on`,`permission_item`,`permission_user`),
  KEY `idx_puser` (`permission_user`),
  KEY `idx_pvalue` (`permission_value`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `permission_user`, `permission_grant_on`, `permission_item`, `permission_value`) VALUES
(1, 1, 'all', -1, -1);

-- --------------------------------------------------------

--
-- Table structure for table `syskeys`
--

CREATE TABLE IF NOT EXISTS `syskeys` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(48) NOT NULL default '',
  `label` varchar(255) NOT NULL default '',
  `type` int(1) unsigned NOT NULL default '0',
  `sep1` char(2) default '\n',
  `sep2` char(2) NOT NULL default '|',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `idx_syskey_name` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `syskeys`
--

INSERT INTO `syskeys` (`id`, `name`, `label`, `type`, `sep1`, `sep2`) VALUES
(1, 'SelectList', 'Enter values for list', 0, '\n', '|'),
(2, 'CustomField', 'Serialized array in the following format:\r\n<KEY>|<SERIALIZED ARRAY>\r\n\r\nSerialized Array:\r\n[type] => text | checkbox | select | textarea | label\r\n[name] => <Field''s name>\r\n[options] => <html capture options>\r\n[selects] => <options for select and checkbox>', 0, '\n', '|'),
(3, 'ColorSelection', 'Hex color values for type=>color association.', 0, '\n', '|');

-- --------------------------------------------------------

--
-- Table structure for table `sysvals`
--

CREATE TABLE IF NOT EXISTS `sysvals` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyId` int(10) unsigned NOT NULL default '0',
  `title` varchar(48) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;

--
-- Dumping data for table `sysvals`
--

INSERT INTO `sysvals` (`id`, `keyId`, `title`, `value`) VALUES
(1, 1, 'typeOfVehicle', '0|-- Seleccionar Tipo Veiculo --\r\n1|Novo\r\n2|Usado\r\n3|Semi-novo\r\n4|Acidentado\r\n5|Como novo\r\n'),
(2, 1, 'fuel', '0|-- Seleccionar Combustível --\r\n1|Diesel\r\n2|Gasolina\r\n3|Híbrido\r\n4|outro\r\n'),
(3, 1, 'category', '0|-- Seleccionar Categoria --\r\n1|ligeiro de passageiros\r\n2|barcos\r\n3|citadinos\r\n4|clássicos\r\n5|comerciais\r\n6|coupés\r\n7|desportivos\r\n8|descapotáveis\r\n9|familiares médios\r\n10|grandes familiares\r\n11|luxo\r\n12|monovolume\r\n13|pequenos familiares\r\n14|pesados\r\n15|todo-o-terreno\r\n16|utilitários\r\n17|autocaravana\r\n18|ciclomotor\r\n19|moto\r\n'),
(4, 1, 'inicialShowType', '0|Nenhum\r\n1|Destaque\r\n2|Ocasião\r\n3|Vendido\r\n'),
(5, 1, 'title', '0|Sr.\r\n1|Sra.\r\n2|Srta.\r\n3|Dr.\r\n4|Dra.\r\n5|Arq.\r\n6|Arqa.\r\n7|Mestre\r\n8|Eng.\r\n9|Enga.\r\n10|Prof.\r\n11|Prof Dr.\r\n12|Prof Dra.\r\n'),
(76, 1, 'typeOfCompany', '0|none\r\n1|company\r\n2|stand\r\n');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL auto_increment,
  `contactId` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `parent` int(11) NOT NULL default '0',
  `type` tinyint(3) NOT NULL default '0',
  `companyId` int(11) default '0',
  `owner` int(11) NOT NULL default '0',
  `signature` text,
  PRIMARY KEY  (`id`),
  KEY `idx_uid` (`username`),
  KEY `idx_pwd` (`password`),
  KEY `idx_user_parent` (`parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `user`
--

#INSERT INTO `user` (`id`, `contactId`, `username`, `password`, `parent`, `type`, `companyId`, `owner`, `signature`) VALUES
#(1, 1, 'admin', 'c1d0aa5e1a575c77caa967fde8b12a7d', 0, 1, 0, 0, ''),
#(9, 9, 'cliente', '698dc19d489c4e4db73e28a713eab07b', 0, 2, 0, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `user_access_log`
--

CREATE TABLE IF NOT EXISTS `user_access_log` (
  `user_access_log_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  `user_ip` varchar(15) NOT NULL,
  `date_time_in` datetime default '0000-00-00 00:00:00',
  `date_time_out` datetime default '0000-00-00 00:00:00',
  `date_time_last_action` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_access_log_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=732 ;

--
-- Dumping data for table `user_access_log`
--

INSERT INTO `user_access_log` (`user_access_log_id`, `user_id`, `user_ip`, `date_time_in`, `date_time_out`, `date_time_last_action`) VALUES
(181, 1, '89.181.177.60', '2007-08-26 02:30:22', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(182, 1, '83.132.236.9', '2007-08-27 20:41:05', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(183, 1, '83.132.236.9', '2007-08-28 12:45:25', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(184, 1, '83.132.236.9', '2007-08-28 17:54:33', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(185, 1, '83.132.236.9', '2007-08-28 18:48:20', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(186, 1, '85.240.174.252', '2007-08-30 00:16:33', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(187, 1, '83.132.236.9', '2007-09-04 14:39:26', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(188, 1, '83.132.236.9', '2007-09-04 17:25:19', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(189, 1, '83.132.236.9', '2007-09-04 18:33:45', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(190, 1, '83.132.236.9', '2007-09-04 18:49:55', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(191, 1, '83.132.236.9', '2007-09-04 20:20:29', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(192, 1, '83.132.236.9', '2007-09-06 17:00:41', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(193, 1, '83.132.236.9', '2007-09-06 18:18:35', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(194, 1, '83.132.236.9', '2007-09-06 21:32:47', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(195, 1, '83.132.236.9', '2007-09-07 11:17:15', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(196, 1, '83.132.236.9', '2007-09-07 11:39:31', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(197, 1, '83.132.236.9', '2007-09-07 17:45:23', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(198, 1, '83.132.236.9', '2007-09-07 20:30:46', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(199, 1, '83.132.236.9', '2007-09-08 13:31:38', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(200, 1, '83.132.236.9', '2007-09-08 18:44:00', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(201, 1, '83.132.236.9', '2007-09-08 19:46:38', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(202, 1, '85.240.111.17', '2007-09-10 02:50:35', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(203, 1, '85.138.114.49', '2007-09-10 16:51:44', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(204, 1, '85.138.114.49', '2007-09-10 19:38:07', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(205, 1, '85.240.167.35', '2007-09-10 23:14:58', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(206, 1, '85.138.114.49', '2007-09-11 10:34:52', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(207, 1, '85.138.114.49', '2007-09-11 12:18:00', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(208, 1, '85.138.114.49', '2007-09-11 18:28:14', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(209, 1, '85.138.114.49', '2007-09-11 18:28:15', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(210, 1, '85.240.161.98', '2007-09-12 02:21:29', '2007-09-20 18:40:21', '0000-00-00 00:00:00'),
(673, 1, '85.240.164.188', '2009-01-30 18:18:56', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(672, 5, '85.243.36.202', '2009-01-24 20:16:17', '2009-09-25 19:33:10', '0000-00-00 00:00:00'),
(671, 5, '85.243.36.202', '2009-01-24 20:14:00', '2009-09-25 19:33:10', '0000-00-00 00:00:00'),
(670, 1, '85.240.111.74', '2009-01-09 18:24:36', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(669, 1, '85.240.172.121', '2008-12-17 17:13:47', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(668, 1, '85.240.172.121', '2008-12-17 16:57:02', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(667, 1, '85.240.170.140', '2008-12-13 12:37:55', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(666, 1, '85.240.167.119', '2008-11-25 20:35:23', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(665, 5, '85.241.248.55', '2008-10-27 08:57:32', '2009-09-25 19:33:10', '0000-00-00 00:00:00'),
(664, 5, '85.240.189.230', '2008-10-27 02:26:25', '2009-09-25 19:33:10', '0000-00-00 00:00:00'),
(663, 5, '85.240.174.32', '2008-10-22 19:57:09', '2008-10-22 19:58:26', '0000-00-00 00:00:00'),
(662, 5, '85.240.174.32', '2008-10-22 19:56:47', '2008-10-22 19:56:50', '0000-00-00 00:00:00'),
(661, 5, '85.240.174.32', '2008-10-22 19:55:00', '2008-10-22 19:56:28', '0000-00-00 00:00:00'),
(660, 1, '85.240.175.139', '2008-10-16 21:06:49', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(659, 1, '85.240.175.139', '2008-10-16 17:57:36', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(658, 1, '89.152.66.233', '2008-08-01 20:57:03', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(657, 5, '85.240.162.231', '2008-07-30 16:01:59', '2008-07-30 16:03:36', '0000-00-00 00:00:00'),
(656, 5, '82.154.249.237', '2008-07-24 11:51:32', '2008-07-30 16:03:36', '0000-00-00 00:00:00'),
(655, 5, '82.154.249.237', '2008-07-23 18:01:22', '2008-07-23 18:06:28', '0000-00-00 00:00:00'),
(649, 1, '81.84.123.32', '2008-06-09 19:21:28', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(648, 5, '195.23.100.70', '2008-06-09 17:16:18', '2008-06-09 17:16:38', '0000-00-00 00:00:00'),
(647, 5, '195.23.100.70', '2008-06-09 16:33:36', '2008-06-09 17:15:38', '0000-00-00 00:00:00'),
(645, 5, '201.50.119.77', '2008-06-05 20:40:48', '2008-06-09 16:33:24', '0000-00-00 00:00:00'),
(654, 5, '89.152.66.233', '2008-07-23 17:46:59', '2008-07-23 18:06:28', '0000-00-00 00:00:00'),
(653, 5, '195.23.28.62', '2008-07-01 16:56:13', '2008-07-23 18:06:28', '0000-00-00 00:00:00'),
(652, 1, '81.84.123.32', '2008-06-19 16:36:22', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(651, 5, '85.243.64.182', '2008-06-14 00:40:17', '2008-07-23 18:06:28', '0000-00-00 00:00:00'),
(650, 1, '81.84.123.32', '2008-06-09 21:31:12', '2009-09-25 19:28:18', '0000-00-00 00:00:00'),
(646, 5, '195.23.100.70', '2008-06-09 16:21:07', '2008-06-09 16:33:24', '0000-00-00 00:00:00'),
(644, 5, '88.157.252.65', '2008-06-01 13:58:22', '2008-06-01 13:59:06', '0000-00-00 00:00:00'),
(643, 5, '81.84.123.32', '2008-05-31 20:29:06', '2008-06-01 13:59:06', '0000-00-00 00:00:00'),
(642, 5, '81.84.123.32', '2008-05-30 16:45:05', '2008-05-30 17:03:39', '0000-00-00 00:00:00'),
(641, 1, '81.84.123.32', '2008-05-30 16:44:50', '2008-05-30 16:44:59', '0000-00-00 00:00:00'),
(640, 5, '81.84.123.32', '2008-05-30 16:42:37', '2008-05-30 16:44:43', '0000-00-00 00:00:00'),
(639, 1, '81.84.123.32', '2008-05-30 16:39:10', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(638, 1, '81.84.123.32', '2008-05-29 19:23:03', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(637, 1, '81.84.123.32', '2008-05-20 19:41:54', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(636, 1, '81.84.123.32', '2008-05-15 18:36:48', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(635, 1, '81.84.123.32', '2008-05-10 19:55:31', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(634, 1, '81.84.123.32', '2008-05-10 19:53:32', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(633, 1, '81.84.123.32', '2008-05-09 21:02:44', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(632, 1, '81.84.123.32', '2008-05-09 19:08:04', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(631, 1, '81.84.123.32', '2008-05-09 18:36:18', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(630, 1, '81.84.123.32', '2008-05-09 18:08:44', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(629, 1, '81.84.123.32', '2008-05-08 21:25:30', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(628, 1, '81.84.123.32', '2008-05-08 21:21:05', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(627, 1, '81.84.123.32', '2008-05-05 20:08:18', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(626, 1, '81.84.123.32', '2008-05-05 18:55:05', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(625, 1, '81.84.123.32', '2008-05-05 18:48:47', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(624, 1, '81.84.123.32', '2008-05-05 17:03:21', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(623, 1, '81.84.123.32', '2008-05-05 16:48:52', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(612, 1, '85.138.208.177', '2008-03-20 21:39:10', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(622, 1, '81.84.123.32', '2008-05-03 18:15:49', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(621, 1, '81.84.123.32', '2008-05-02 17:55:47', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(620, 1, '81.84.123.32', '2008-04-30 18:55:27', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(619, 1, '81.84.123.32', '2008-04-30 18:54:14', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(618, 1, '81.84.123.32', '2008-04-30 18:52:51', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(617, 1, '89.181.44.136', '2008-04-30 16:54:18', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(616, 1, '81.84.123.32', '2008-04-16 17:45:52', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(615, 1, '81.84.123.32', '2008-04-11 16:57:48', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(614, 1, '85.138.208.177', '2008-03-24 18:32:35', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(613, 1, '85.138.208.177', '2008-03-24 18:17:30', '2008-05-30 16:41:25', '0000-00-00 00:00:00'),
(611, 1, '85.243.37.42', '2008-03-13 01:09:29', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(610, 1, '85.138.208.177', '2008-02-29 17:07:40', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(609, 1, '85.138.208.177', '2008-02-28 12:55:31', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(608, 1, '85.138.208.177', '2008-02-28 12:53:10', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(607, 1, '85.138.208.177', '2008-02-25 16:00:05', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(606, 1, '85.138.208.177', '2008-02-22 15:37:32', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(605, 1, '85.138.208.177', '2008-02-22 15:12:22', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(604, 1, '85.138.208.177', '2008-02-22 12:42:47', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(603, 1, '85.240.169.207', '2008-02-21 22:13:14', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(602, 1, '85.138.208.177', '2008-02-20 18:39:52', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(601, 1, '85.138.208.177', '2008-02-20 18:38:34', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(600, 1, '85.138.208.177', '2008-02-20 17:09:18', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(599, 1, '85.138.208.177', '2008-02-20 17:06:52', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(598, 1, '85.138.208.177', '2008-02-20 17:05:18', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(597, 1, '85.138.208.177', '2008-02-20 17:04:05', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(596, 1, '85.138.208.177', '2008-02-20 14:56:09', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(595, 1, '85.138.208.177', '2008-02-20 14:47:18', '2008-03-13 01:10:56', '0000-00-00 00:00:00'),
(674, 1, '85.241.44.194', '2009-09-25 19:28:35', '2009-09-25 19:28:58', '0000-00-00 00:00:00'),
(675, 1, '85.241.44.194', '2009-09-25 19:29:08', '2009-09-25 19:31:10', '0000-00-00 00:00:00'),
(676, 1, '85.241.44.194', '2009-09-25 19:31:17', '2009-09-25 19:32:22', '0000-00-00 00:00:00'),
(677, 5, '85.241.44.194', '2009-09-25 19:32:33', '2009-09-25 19:33:10', '0000-00-00 00:00:00'),
(678, 1, '85.241.44.194', '2009-09-25 19:33:27', '2009-09-25 19:33:38', '0000-00-00 00:00:00'),
(679, 1, '85.241.44.194', '2009-09-25 19:33:45', '2009-09-25 19:38:49', '0000-00-00 00:00:00'),
(680, 1, '85.241.44.194', '2009-09-25 19:42:01', '2009-09-25 19:46:42', '0000-00-00 00:00:00'),
(681, 7, '85.241.44.194', '2009-09-25 19:46:51', '2009-09-25 19:50:55', '0000-00-00 00:00:00'),
(682, 1, '85.241.44.194', '2009-09-25 20:07:47', '2009-10-12 17:55:53', '0000-00-00 00:00:00'),
(683, 1, '85.241.44.194', '2009-09-26 18:46:23', '2009-10-12 17:55:53', '0000-00-00 00:00:00'),
(684, 1, '85.241.44.194', '2009-09-26 18:51:28', '2009-10-12 17:55:53', '0000-00-00 00:00:00'),
(685, 7, '85.241.250.1', '2009-09-30 16:37:26', '2009-09-30 16:45:33', '0000-00-00 00:00:00'),
(686, 7, '85.241.246.16', '2009-09-30 16:44:28', '2009-09-30 16:45:33', '0000-00-00 00:00:00'),
(687, 1, '85.241.250.181', '2009-10-08 17:49:59', '2009-10-12 17:55:53', '0000-00-00 00:00:00'),
(688, 1, '85.241.250.181', '2009-10-08 17:51:00', '2009-10-12 17:55:53', '0000-00-00 00:00:00'),
(689, 1, '85.242.126.218', '2009-10-12 17:52:46', '2009-10-12 17:55:53', '0000-00-00 00:00:00'),
(690, 7, '85.242.126.218', '2009-10-12 17:56:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(691, 1, '85.241.44.171', '2009-10-20 19:34:37', '2010-06-12 21:13:22', '0000-00-00 00:00:00'),
(692, 1, '85.241.44.171', '2009-10-20 19:46:05', '2010-06-12 21:13:22', '0000-00-00 00:00:00'),
(693, 1, '85.241.248.105', '2009-10-28 16:25:58', '2010-06-12 21:13:22', '0000-00-00 00:00:00'),
(694, 7, '93.102.81.234', '2009-11-20 13:42:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(695, 1, '85.241.244.152', '2009-11-22 17:26:53', '2010-06-12 21:13:22', '0000-00-00 00:00:00'),
(696, 1, '85.243.211.210', '2010-06-12 21:11:39', '2010-06-12 21:13:22', '0000-00-00 00:00:00'),
(697, 9, '85.243.211.210', '2010-06-12 21:13:29', '2011-10-21 02:35:17', '0000-00-00 00:00:00'),
(698, 1, '82.154.236.99', '2010-08-26 20:05:01', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(699, 1, '85.241.254.124', '2010-08-30 03:52:53', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(700, 1, '2.83.56.25', '2010-10-18 20:19:55', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(701, 1, '2.83.56.25', '2010-10-18 20:20:35', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(702, 1, '2.83.33.2', '2011-04-01 04:20:11', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(703, 1, '2.83.33.2', '2011-04-01 04:21:37', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(704, 1, '2.83.33.2', '2011-04-01 16:51:36', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(705, 1, '2.83.33.2', '2011-04-01 17:51:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(706, 1, '2.83.33.2', '2011-04-01 19:12:32', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(707, 1, '2.83.33.2', '2011-04-01 19:38:05', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(708, 1, '2.83.159.239', '2011-07-21 01:40:17', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(709, 1, '2.83.159.239', '2011-07-21 01:42:58', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(710, 1, '2.83.159.239', '2011-07-21 01:43:52', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(711, 1, '2.83.159.239', '2011-07-21 02:13:54', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(712, 1, '2.83.159.239', '2011-07-21 02:15:20', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(713, 1, '2.83.159.239', '2011-07-21 02:17:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(714, 1, '2.83.28.243', '2011-07-28 05:17:02', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(715, 1, '2.83.18.98', '2011-07-29 01:16:58', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(716, 1, '188.82.224.231', '2011-08-06 14:34:03', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(717, 1, '188.82.224.231', '2011-08-06 14:35:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(718, 1, '188.82.225.248', '2011-10-10 03:31:54', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(719, 9, '2.83.9.236', '2011-10-21 02:31:09', '2011-10-21 02:35:17', '0000-00-00 00:00:00'),
(720, 9, '2.83.9.236', '2011-10-21 02:35:25', '2011-10-21 02:36:26', '0000-00-00 00:00:00'),
(721, 9, '2.83.9.236', '2011-10-21 02:36:50', '2011-10-21 02:38:13', '0000-00-00 00:00:00'),
(722, 9, '2.83.9.236', '2011-10-21 02:38:19', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(723, 9, '2.83.9.236', '2011-10-21 02:40:13', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(724, 9, '2.83.9.236', '2011-10-21 02:40:47', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(725, 9, '2.83.9.236', '2011-10-21 02:41:09', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(726, 9, '2.83.9.236', '2011-10-21 02:41:31', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(727, 9, '2.83.9.236', '2011-10-21 02:41:47', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(728, 1, '2.83.9.236', '2011-10-21 02:42:10', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(729, 9, '2.83.9.236', '2011-10-21 02:42:26', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(730, 9, '2.83.155.68', '2011-10-24 18:49:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(731, 9, '189.93.240.170', '2011-10-24 18:50:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `user_preferences`
--

CREATE TABLE IF NOT EXISTS `user_preferences` (
  `pref_user` varchar(12) NOT NULL default '',
  `pref_name` varchar(72) NOT NULL default '',
  `pref_value` varchar(32) NOT NULL default '',
  KEY `pref_user` (`pref_user`,`pref_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_preferences`
--

INSERT INTO `user_preferences` (`pref_user`, `pref_name`, `pref_value`) VALUES
('1', 'LOCALE', 'pt'),
('1', 'SHDATEFORMAT', '%d/%m/%Y'),
('1', 'TIMEFORMAT', '%I:%M %p'),
('1', 'UISTYLE', 'default'),
('', 'UISTYLE', 'system');

-- --------------------------------------------------------

--
-- Table structure for table `user_roles`
--

CREATE TABLE IF NOT EXISTS `user_roles` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `role_id` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `vehicle`
--

CREATE TABLE IF NOT EXISTS `vehicle` (
  `id` int(11) NOT NULL auto_increment,
  `userId` int(11) NOT NULL default '0',
  `version` varchar(150) default NULL,
  `year` decimal(4,0) NOT NULL default '0',
  `price` decimal(10,2) NOT NULL default '0.00',
  `typeOfVehicle` varchar(100) NOT NULL default '',
  `inspection` int(1) NOT NULL default '1',
  `availability` varchar(20) default NULL,
  `nacionality` varchar(150) default 'Portuguesa',
  `guarantee` varchar(20) default NULL,
  `comment` varchar(255) default NULL,
  `localization` varchar(50) default NULL,
  `fuel` varchar(200) NOT NULL default '',
  `miles` int(11) NOT NULL default '0',
  `pistonDisplacement` int(11) NOT NULL default '0',
  `power` decimal(10,2) default NULL,
  `nRegistry` int(11) NOT NULL default '0',
  `color` varchar(100) NOT NULL default '',
  `nDoors` int(11) default NULL,
  `nPlaces` int(11) default NULL,
  `vehicleWeight` int(11) default NULL,
  `chassis` varchar(150) default NULL,
  `imports` int(1) NOT NULL default '0',
  `conditionalAir` int(1) default '0',
  `electricalGlasses` int(1) default '0',
  `skinUpholsteries` int(1) default '0',
  `warmBank` int(1) default '0',
  `electricalBank` int(1) default '0',
  `radioCDreader` int(1) default '0',
  `CDbox` int(1) default '0',
  `steeringWheelMultifunction` int(1) default '0',
  `skinSteeringWheel` int(1) default '0',
  `openRoof` int(1) default '0',
  `centralClosed` int(1) default '0',
  `airbag` int(1) default '0',
  `ABS` int(1) default '0',
  `ESP` int(1) default '0',
  `alarm` int(1) default '0',
  `fogLighthouses` int(1) default '0',
  `sensorParking` int(1) default '0',
  `reaviewMirrorElectricalWarm` int(1) default '0',
  `refrigerator` int(1) default '0',
  `metallicPainting` int(1) default '0',
  `especialJantes` int(1) default '0',
  `automaticBox` int(1) default '0',
  `television` int(1) default '0',
  `DVD` int(1) default '0',
  `amplifier` int(1) default '0',
  `cruiseControl` int(1) default '0',
  `GPS` int(1) default '0',
  `edgeComputer` int(1) default '0',
  `directionWatched` int(1) default '0',
  `bookRevision` int(1) default '0',
  `kitFreeHand` int(1) default '0',
  `sportBanks` int(1) default '0',
  `ballOfTowing` int(1) default '0',
  `electronicImobilizator` int(1) default '0',
  `contactId` int(11) NOT NULL default '0',
  `companyId` int(11) NOT NULL default '0',
  `modelId` int(11) NOT NULL default '0',
  `orderBy` int(11) default NULL,
  `category` varchar(100) NOT NULL default '',
  `date` date default NULL,
  `mediumConsume` varchar(50) default NULL,
  `inicialShowType` varchar(50) default 'nenhum',
  `reference` varchar(255) NOT NULL,
  `markId` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

--
-- Dumping data for table `vehicle`
--

INSERT INTO `vehicle` (`id`, `userId`, `version`, `year`, `price`, `typeOfVehicle`, `inspection`, `availability`, `nacionality`, `guarantee`, `comment`, `localization`, `fuel`, `miles`, `pistonDisplacement`, `power`, `nRegistry`, `color`, `nDoors`, `nPlaces`, `vehicleWeight`, `chassis`, `imports`, `conditionalAir`, `electricalGlasses`, `skinUpholsteries`, `warmBank`, `electricalBank`, `radioCDreader`, `CDbox`, `steeringWheelMultifunction`, `skinSteeringWheel`, `openRoof`, `centralClosed`, `airbag`, `ABS`, `ESP`, `alarm`, `fogLighthouses`, `sensorParking`, `reaviewMirrorElectricalWarm`, `refrigerator`, `metallicPainting`, `especialJantes`, `automaticBox`, `television`, `DVD`, `amplifier`, `cruiseControl`, `GPS`, `edgeComputer`, `directionWatched`, `bookRevision`, `kitFreeHand`, `sportBanks`, `ballOfTowing`, `electronicImobilizator`, `contactId`, `companyId`, `modelId`, `orderBy`, `category`, `date`, `mediumConsume`, `inicialShowType`, `reference`, `markId`) VALUES
(34, 5, '1', 0, 50000.00, '1', 1, '', 'Portuguesa', '', '', '', '2', 0, 0, 0.00, 0, '', 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 1, 2, 1, 49, NULL, '5', NULL, '', '2', 'LF', 52),
(35, 1, '1.5', 0, 10.00, '1', 1, '', 'Portuguesa', '', '', '', '2', 0, 0, 0.00, 0, '', 0, 0, 0, '', 0, 1, 0, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 2, 1, 28, NULL, '5', NULL, '', '1', 'CM6', 43),
(36, 1, '2.0 V6 T', 0, 38000.00, '1', 1, '', 'Portuguesa', '', '', '', '2', 0, 0, 0.00, 0, '', 0, 0, 0, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 23, NULL, '6', NULL, '', '2', 'estgfsdfsdf', 31),
(49, 1, 'V8', 0, 85000.00, '1', 1, '', 'Portuguesa', '', 'Como parece pelas ultimas noticias que o projecto da vinci ? serio e ambicioso (pelo menos isso esperamos) e sendo na actualidade ou isso creio o unico constructor de automoveis portugues acho que merece um espa?o.', '', '2', 0, 0, 0.00, 0, '', 0, 0, 0, '', 0, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 4, 51, NULL, '5', NULL, '', '2', 'V8x', 76),
(50, 1, 'TDI SW 130 CV', 1998, 23.98, '2', 1, '20 dias', 'pt', '6 meses', 'Este ? o campo onde posso adicionar um coment?rio. Este campo deve ter um espa?o maior para que possa ver o que tenho escrito. ', '', '1', 110573, 1896, 130.00, 0, 'Azul', 5, 5, 1230, '', 0, 1, 1, 0, 1, 0, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 2, 5, 5, NULL, '1', NULL, '6', '2', 'AS23', 4),
(51, 1, '1000', 2003, 8500.00, '5', 1, '', 'Portuguesa', '1 ano', 'Trav?es Disco Frente, Trav?es Disco Atr?s e Para-Brisas.', '', '2', 4500, 1000, 100.00, 1, 'Tricolor', 0, 2, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 5, 56, NULL, '18', NULL, '9', '3', 'motoHV', 48),
(52, 1, '5.0', 0, 222222.00, '1', 1, '', 'Portuguesa', '', '', '', '1', 0, 0, 0.00, 0, 'ss', 0, 0, 0, '', 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 58, NULL, '16', NULL, '', '3', 'aaaasas', 42),
(53, 1, 'as', 2005, 6666.00, '5', 1, '', 'Portuguesa', '', 'coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio coment?rio co', '', '1', 0, 0, 0.00, 2, '', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 59, NULL, '16', NULL, '', '2', 'a1', 78);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
