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 */;
--
-- База данных: `autovariant`
--
-- --------------------------------------------------------
--
-- Структура таблицы `jos_autobb_messages`
--
CREATE TABLE IF NOT EXISTS `jos_autobb_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`createDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modifyDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`expirationDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`sticked` tinyint(1) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`front` tinyint(1) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '1',
`name` varchar(100) NOT NULL DEFAULT '',
`company` varchar(100) NOT NULL DEFAULT '',
`phone1` varchar(100) NOT NULL DEFAULT '',
`since1` int(11) NOT NULL DEFAULT '0',
`till1` int(11) NOT NULL DEFAULT '0',
`phone2` varchar(100) NOT NULL DEFAULT '',
`since2` int(11) NOT NULL DEFAULT '0',
`till2` int(11) NOT NULL DEFAULT '0',
`phone3` varchar(100) NOT NULL DEFAULT '',
`since3` int(11) NOT NULL DEFAULT '0',
`till3` int(11) NOT NULL DEFAULT '0',
`email` varchar(255) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`city` int(11) NOT NULL DEFAULT '0',
`userid` int(11) NOT NULL DEFAULT '0',
`category` int(11) NOT NULL DEFAULT '0',
`vendor` int(11) NOT NULL DEFAULT '0',
`model` int(11) NOT NULL DEFAULT '0',
`modification` varchar(100) NOT NULL DEFAULT '',
`color` int(11) NOT NULL DEFAULT '0',
`year` int(11) NOT NULL DEFAULT '0',
`bodytype` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '0',
`currency` int(11) NOT NULL DEFAULT '0',
`engine` int(11) NOT NULL DEFAULT '0',
`fuelinputcity` decimal(4,1) NOT NULL DEFAULT '0.0',
`fuelinputcountry` decimal(4,1) NOT NULL DEFAULT '0.0',
`fuelinputboth` decimal(4,1) NOT NULL DEFAULT '0.0',
`mileage` int(11) NOT NULL DEFAULT '0',
`mileage_unit` int(11) NOT NULL DEFAULT '0',
`drive` int(11) NOT NULL DEFAULT '0',
`volume` int(11) NOT NULL DEFAULT '0',
`power` int(11) NOT NULL DEFAULT '0',
`speed` int(3) NOT NULL DEFAULT '0',
`transmission` int(11) NOT NULL DEFAULT '0',
`state` int(11) NOT NULL DEFAULT '1',
`steering_wheel` tinyint(1) NOT NULL DEFAULT '0',
`wrangle` tinyint(1) NOT NULL DEFAULT '0',
`vin` varchar(100) NOT NULL DEFAULT '',
`vin2` varchar(100) NOT NULL DEFAULT '',
`customs` tinyint(1) NOT NULL DEFAULT '0',
`additional` text,
`views` int(11) NOT NULL DEFAULT '0',
`en` tinyint(1) NOT NULL DEFAULT '0',
`cr` tinyint(1) NOT NULL DEFAULT '0',
`lastViewIP` varchar(20) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`banned` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `createDate` (`createDate`),
KEY `expirationDate` (`expirationDate`),
KEY `vendor` (`vendor`),
KEY `model` (`model`),
KEY `city` (`city`),
KEY `state` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4407 ;
--
-- Дамп данных таблицы `jos_autobb_messages`
--
INSERT INTO `jos_autobb_messages` (`id`, `createDate`, `modifyDate`, `expirationDate`, `sticked`, `ordering`, `front`, `published`, `name`, `company`, `phone1`, `since1`, `till1`, `phone2`, `since2`, `till2`, `phone3`, `since3`, `till3`, `email`, `password`, `city`, `userid`, `category`, `vendor`, `model`, `modification`, `color`, `year`, `bodytype`, `price`, `currency`, `engine`, `fuelinputcity`, `fuelinputcountry`, `fuelinputboth`, `mileage`, `mileage_unit`, `drive`, `volume`, `power`, `speed`, `transmission`, `state`, `steering_wheel`, `wrangle`, `vin`, `vin2`, `customs`, `additional`, `views`, `en`, `cr`, `lastViewIP`, `ip`, `banned`) VALUES
(2001, '2010-11-29 18:37:29', '2010-11-29 18:37:29', '2012-12-21 18:37:29', 0, 0, 1, 1, 'Анатолий', '', '048-7877986', 10, 21, '', 10, 21, '', 10, 21, '', '', 1132, 0, 601, 100, 1182, '', 25, 1989, 0, 2850, 2, 2, '0.0', '0.0', '0.0', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', '', 0, '', 32, 0, 0, '178.74.252.119', '109.108.239.167', 0),
(2002, '2010-11-29 18:37:29', '2010-11-29 18:37:29', '2012-12-21 18:37:29', 0, 0, 1, 1, 'Игорь', '', '0939598201', 10, 21, '', 10, 21, '', 10, 21, '', '', 1132, 0, 601, 33, 332, '', 15, 1985, 0, 1600, 2, 2, '0.0', '0.0', '0.0', 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', '', 0, 'Автомобиль в хорошем состоянии,нигде не ржавая,очень экономная,сигнализация,ксенон,хэчбек,магнитафон.', 40, 0, 0, '173.242.125.196', '109.108.239.167', 0),
(2003, '2010-12-23 18:37:29', '2010-12-23 18:37:29', '2012-12-21 18:37:29', 0, 0, 1, 1, '', '', '', 10, 21, '', 10, 21, '', 10, 21, '', '', 1132, 0, 601, 161, 5265, '', 9, 2003, 0, 2000, 0, 1, '0.0', '0.0', '0.0', 76, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', '', 0, '', 19, 0, 0, '178.74.252.119', '109.108.239.167', 0),
(2004, '2010-11-29 18:37:29', '2010-11-29 18:37:29', '2012-12-21 18:37:29', 0, 0, 1, 1, 'ЮРИЙ', '', '066 34 31 355', 10, 21, '', 10, 21, '', 10, 21, '', '', 1132, 0, 601, 161, 96792, '', 9, 2003, 0, 2000, 0, 1, '0.0', '0.0', '0.0', 76, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', '', 0, '', 27, 0, 0, '81.19.66.84', '109.108.239.167', 0);