File: //var/softaculous/noah/noah.sql
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: `soft_noah320`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category`
--
CREATE TABLE `[[dbprefix]]category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`up` int(11) NOT NULL DEFAULT '0',
`name` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`wholeName` text COLLATE utf8_unicode_ci NOT NULL,
`subCatNum` int(11) NOT NULL DEFAULT '0',
`directSubCatNum` int(11) NOT NULL DEFAULT '0',
`itemNum` int(11) NOT NULL DEFAULT '0',
`directItemNum` int(11) NOT NULL DEFAULT '0',
`creationtime` datetime NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`showDescription` int(11) NOT NULL DEFAULT '1',
`keywords` text COLLATE utf8_unicode_ci NOT NULL,
`picture` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`allowAd` int(11) NOT NULL DEFAULT '1',
`allowSubmitAdAdmin` int(11) NOT NULL DEFAULT '0',
`customAdListTitle` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`immediateAppear` int(11) NOT NULL DEFAULT '1',
`inactivateOnModify` int(11) NOT NULL DEFAULT '1',
`expirationEnabled` int(11) NOT NULL DEFAULT '0',
`expiration` int(11) NOT NULL DEFAULT '0',
`expirationOverride` int(11) NOT NULL DEFAULT '0',
`restartExpOnModify` int(11) NOT NULL DEFAULT '0',
`sortId` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
--
-- Dumping data for table `[[dbprefix]]category`
--
INSERT INTO `[[dbprefix]]category` VALUES
(1, 0, 'Cars', 'Cars', 2, 2, 5, 2, '[[regtime]]', 'A lot of cars, different classes, little and large ones, different manufacturers, you can check for the price as well...', 1, '', 'jpg', 1, 0, '', 1, 1, 0, 0, 0, 0, 100),
(2, 0, 'Hardware', 'Hardware', 2, 2, 3, 3, '[[regtime]]', 'Find hardware into your computer, from memory to CD-Rom, from hard disk to monitor, whatever you want...', 1, '', 'jpg', 1, 0, '', 1, 1, 0, 0, 0, 0, 200),
(3, 0, 'Cottages', 'Cottages', 0, 0, 6, 6, '[[regtime]]', 'Find a house for your family! Nice weekends, fishing in the lake, climbing to the mountains, near to your...', 1, '', 'jpg', 1, 0, '', 1, 1, 0, 0, 0, 0, 300),
(4, 0, 'Dating', 'Dating', 2, 2, 3, 0, '[[regtime]]', 'Are you searching for your partner for a long time? The search is over, thousands are looking for love here...', 1, '', 'jpg', 0, 0, '', 1, 1, 0, 0, 0, 0, 400),
(5, 1, 'Economy cars', 'Cars - Economy cars', 0, 0, 3, 3, '[[regtime]]', 'If you don''t want to pay much at your petrol station and you dont''t want problems during parking, search here.', 1, '', 'jpg', 1, 0, '', 1, 1, 0, 0, 0, 0, 100),
(6, 1, 'Pickups', 'Cars - Pickups', 0, 0, 0, 0, '[[regtime]]', 'You always have been dreaming about a nice picup? Check it out here...', 1, '', 'jpg', 1, 0, '', 1, 1, 0, 0, 0, 0, 200),
(7, 2, 'Hard disks', 'Hardware - Hard disks', 0, 0, 0, 0, '[[regtime]]', '', 1, '', '', 1, 0, '', 1, 1, 0, 0, 0, 0, 100),
(8, 2, 'Memory chips', 'Hardware - Memory chips', 0, 0, 0, 0, '[[regtime]]', '', 1, '', '', 1, 0, '', 1, 1, 0, 0, 0, 0, 200),
(9, 4, 'Men', 'Dating - Men', 0, 0, 2, 2, '[[regtime]]', '', 1, '', '', 1, 0, '', 1, 1, 0, 0, 0, 0, 100),
(10, 4, 'Women', 'Dating - Women', 0, 0, 1, 1, '[[regtime]]', '', 1, '', '', 1, 0, '', 1, 1, 0, 0, 0, 0, 200);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cronjob`
--
CREATE TABLE `[[dbprefix]]cronjob` (
`id` int(11) NOT NULL DEFAULT '0',
`title` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastExecutionTime` datetime NOT NULL,
`frequency` int(11) NOT NULL DEFAULT '0',
`active` int(11) NOT NULL DEFAULT '1',
`function` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]cronjob`
--
INSERT INTO `[[dbprefix]]cronjob` VALUES
(1, 'Check advertisement expirations', '0000-00-00 00:00:00', 24, 1, 'checkExpiration();'),
(2, 'Delete expired advertisements', '0000-00-00 00:00:00', 24, 1, 'deleteExpiredAds();'),
(3, 'Delete inactive guests', '0000-00-00 00:00:00', 24, 1, 'deleteInactiveGuests();');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customfield`
--
CREATE TABLE `[[dbprefix]]customfield` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`name` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`userField` int(11) NOT NULL DEFAULT '0',
`isCommon` int(11) NOT NULL DEFAULT '0',
`showInForm` int(11) NOT NULL DEFAULT '1',
`expl` text COLLATE utf8_unicode_ci NOT NULL,
`type` int(11) NOT NULL DEFAULT '1',
`subType` int(11) NOT NULL DEFAULT '1',
`values` text COLLATE utf8_unicode_ci NOT NULL,
`default_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`default_bool` int(11) NOT NULL DEFAULT '0',
`default_multiple` text COLLATE utf8_unicode_ci NOT NULL,
`checkboxCols` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '3',
`mandatory` int(11) NOT NULL DEFAULT '0',
`allowHtml` int(11) NOT NULL DEFAULT '0',
`useMarkitup` int(11) NOT NULL DEFAULT '0',
`dateDefaultNow` int(11) NOT NULL DEFAULT '0',
`fromyear` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'now',
`toyear` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'now',
`formatPrefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`formatPostfix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`precision` int(1) NOT NULL DEFAULT '2',
`precisionSeparator` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '.',
`thousandsSeparator` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT ',',
`format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`showInList` int(11) NOT NULL DEFAULT '0',
`innewline` int(11) NOT NULL DEFAULT '0',
`rowspan` int(11) NOT NULL DEFAULT '0',
`displaylength` int(5) NOT NULL DEFAULT '0',
`sortable` int(11) NOT NULL DEFAULT '0',
`mainPicture` int(11) NOT NULL DEFAULT '0',
`showInDetails` int(11) NOT NULL DEFAULT '1',
`displayLabel` int(11) NOT NULL DEFAULT '1',
`detailsPosition` int(11) NOT NULL DEFAULT '0',
`searchable` int(11) NOT NULL DEFAULT '0',
`rangeSearch` int(11) NOT NULL DEFAULT '0',
`seo` int(11) NOT NULL DEFAULT '0',
`columnIndex` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`oldColumnIndex` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`sortId` int(11) NOT NULL DEFAULT '0',
`fields` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=208 ;
--
-- Dumping data for table `[[dbprefix]]customfield`
--
INSERT INTO `[[dbprefix]]customfield` VALUES
(1, 0, 'ID', 0, 1, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(2, 0, 'Category', 0, 1, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(3, 0, 'Created', 0, 1, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(4, 0, 'Status', 0, 1, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 4, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(5, 0, 'Views', 0, 1, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 2, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(6, 0, 'Responses', 0, 1, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 4, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(7, 0, 'Owner', 0, 1, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(8, 0, 'Expiration', 0, 1, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 4, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(9, 0, 'Title', 0, 1, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 'title', '', 1800, 0),
(10, 0, 'Description', 0, 1, 1, '', 2, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'description', '', 1900, 0),
(11, 0, 'Name', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'name', '', 2000, 0),
(12, 0, 'Email', 0, 0, 4, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 4, 0, 0, 0, 1, 0, 4, 1, 0, 4, 0, 0, 'email', '', 2100, 0),
(13, 0, 'Change password', 0, 0, 1, '', 5, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 'changePassword', '', 2200, 0),
(14, 0, 'Password', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 'password', '', 2300, 0),
(15, 0, 'Repeat password', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 'passwordCopy', '', 2400, 0),
(16, 0, 'Remember password', 0, 0, 1, '', 3, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 'rememberPassword', '', 2500, 0),
(17, 0, 'Password reminder', 0, 0, 1, '', 9, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 'remindPasswordLink', '', 2600, 0),
(18, 0, 'First name', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'col_0', '', 2700, 0),
(19, 0, 'Last name', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'col_1', '', 2800, 0),
(20, 0, 'About me', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'col_2', '', 2900, 0),
(21, 0, 'Location', 0, 0, 1, '', 5, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_3', '', 3000, 0),
(22, 0, 'Street', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_4', '', 3100, 0),
(23, 0, 'Post code', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_5', '', 3200, 0),
(24, 0, 'City', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_6', '', 3300, 0),
(25, 0, 'State', 0, 0, 1, '', 4, 1, 'Other,Alabama,Alaska,Arizona,Arkansas,California,Colorado,Connecticut,District of Columbia,Delaware,Flordia,Georgia,Hawaii,Iowa,Idaho,Illinois,Indiana,Kansas,Kentucky,Louisiana,Maine,Maryland,Massachusetts,Michigan,Minnesota,Mississippi,Missouri,Montana,Nebraska,Nevada,New Hampshire,New Jersey,New Mexico,New York,North Carolina,North Dakota,Ohio,Oklahoma,Oregon,Pennsylvania,Rhode Island,South Carolina,South Dakota,Tennessee,Texas,Utah,Vermont,Virginia,Washington,West Virginia,Wisconsin,Wyoming', 'Other', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_7', '', 3400, 0),
(26, 0, 'Country', 0, 0, 1, '', 4, 1, 'Afghanistan,Albania,Algeria,American Samoa,Andorra,Angola,Anguilla,Antarctica,Antigua And Barbuda,Argentina,Armenia,Aruba,Australia,Austria,Azerbaijan,Bahamas,Bahrain,Bangladesh,Barbados,Belarus,Belgium,Belize,Benin,Bermuda,Bhutan,Bolivia,Bosnia And Herzegowina,Botswana,Bouvet Island,Brazil,British Indian Ocean Territory,Brunei Darussalam,Bulgaria,Burkina Faso,Burundi,Cambodia,Cameroon,Canada,Cape Verde,Cayman Islands,Central African Republic,Chad,Chile,China,Christmas Island,Cocos (Keeling) Islands,Colombia,Comoros,Congo,Cook Islands,Costa Rica,Cote D''Ivoire,Croatia (Local Name: Hrvatska),Cuba,Cyprus,Czech Republic,Denmark,Djibouti,Dominica,Dominican Republic,East Timor,Ecuador,Egypt,El Salvador,Equatorial Guinea,Eritrea,Estonia,Ethiopia,Falkland Islands (Malvinas),Faroe Islands,Fiji,Finland,France,French Guiana,French Polynesia,French Southern Territories,Gabon,Gambia,Georgia,Germany,Ghana,Gibraltar,Greece,Greenland,Grenada,Guadeloupe,Guam,Guatemala,Guinea,Guinea-Bissau,Guyana,Haiti,Heard And Mc Donald Islands,Holy See (Vatican City State),Honduras,Hong Kong,Hungary,Icel And,India,Indonesia,Iran (Islamic Republic Of),Iraq,Ireland,Israel,Italy,Jamaica,Japan,Jordan,Kazakhstan,Kenya,Kiribati,Korea - Dem People''S Republic,Korea - Republic Of,Kuwait,Kyrgyzstan,Lao People''S Dem Republic,Latvia,Lebanon,Lesotho,Liberia,Libyan Arab Jamahiriya,Liechtenstein,Lithuania,Luxembourg,Macau,Macedonia,Madagascar,Malawi,Malaysia,Maldives,Mali,Malta,Marshall Islands,Martinique,Mauritania,Mauritius,Mayotte,Mexico,Micronesia - Federated States,Moldova - Republic Of,Monaco,Mongolia,Montserrat,Morocco,Mozambique,Myanmar,Namibia,Nauru,Nepal,Netherlands,Netherlands Ant Illes,New Caledonia,New Zealand,Nicaragua,Niger,Nigeria,Niue,Norfolk Island,Northern Mariana Islands,Norway,Oman,Pakistan,Palau,Panama,Papua New Guinea,Paraguay,Peru,Philippines,Pitcairn,Poland,Portugal,Puerto Rico,Qatar,Reunion,Romania,Russian Federation,Rwanda,Saint K Itts And Nevis,Saint Lucia,Saint Vincent - The Grenadines,Samoa,San Marino,Sao Tome And Principe,Saudi Arabia,Senegal,Seychelles,Sierra Leone,Singapore,Slovakia (Slovak Republic),Slovenia,Solomon Islands,Somalia,South Africa,South Georgia - S Sandwich Is.,Spain,Sri Lanka,St. Helena,St. Pierre And Miquelon,Sudan,Suriname,Svalbard - Jan Mayen Islands,Sw Aziland,Sweden,Switzerland,Syrian Arab Republic,Taiwan,Tajikistan,Tanzania - United Republic Of,Thailand,Togo,Tokelau,Tonga,Trinidad And Tobago,Tunisia,Turkey,Turkmenistan,Turks And Caicos Islands,Tuvalu,Uganda,Ukraine,United Arab Emirates,United Kingdom,United States,United States Minor Is.,Uruguay,Uzbekistan,Vanuatu,Venezuela,Viet Nam,Virgin Islands (British),Virgin Islands (U.S.),Wallis And Futuna Islands,Western Sahara,Yemen,Yugoslavia,Zaire,Zambia,Zimbabwe', 'United States', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_8', '', 3500, 0),
(27, 0, 'Age', 0, 0, 1, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 1, 0, 'col_9', '', 3600, 0),
(28, 0, 'Married', 0, 0, 1, '', 3, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 0, 0, 'col_10', '', 3700, 0),
(29, 0, 'Date of birth', 0, 0, 1, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 2, 1, 0, 2, 1, 0, 'col_11', '', 3800, 0),
(30, 0, 'Picture', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_12', '', 3900, 0),
(31, 0, 'Picture 2', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_13', '', 4000, 0),
(32, 0, 'Picture 3', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_14', '', 4100, 0),
(33, 0, 'Other', 0, 0, 0, '', 5, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'col_15', '', 4200, 0),
(34, 0, 'Registration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 1, 0, 'creationtime', '', 4300, 0),
(35, 0, 'Last log in', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'lastClickTime', '', 4400, 0),
(36, 0, 'Ads of this user', 0, 0, 0, '', 9, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'viewAdsLink', '', 4500, 0),
(37, 1, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(38, 1, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(39, 1, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(40, 1, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(41, 1, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(42, 1, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(43, 1, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(44, 1, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(45, 1, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_0', '', 1800, 0),
(46, 1, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_1', '', 1900, 0),
(47, 1, 'Consumption', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', ' l/mile', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_2', '', 2000, 0),
(48, 1, 'Broken', 0, 0, 1, '', 3, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_3', '', 2100, 0),
(49, 1, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_4', '', 2200, 0),
(50, 1, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(51, 0, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(52, 1, 'Pic2', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_17', '', 2400, 0),
(53, 1, 'Pic3', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_18', '', 2500, 0),
(54, 1, 'Pic4', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_19', '', 2600, 0),
(55, 1, 'Pic5', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_20', '', 2700, 0),
(56, 1, 'Pic6', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_21', '', 2800, 0),
(57, 1, 'Pic7', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_22', '', 2900, 0),
(58, 1, 'Pic8', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_23', '', 3000, 0),
(59, 1, 'Pic9', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_24', '', 3100, 0),
(60, 2, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(61, 2, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(62, 2, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(63, 2, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(64, 2, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(65, 2, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(66, 2, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(67, 2, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(68, 2, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(69, 2, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(70, 2, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(71, 2, 'Type', 0, 0, 1, '', 4, 1, 'Pc, Mac', 'Pc', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(72, 2, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_20', '', 2700, 0),
(73, 3, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(74, 3, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(75, 3, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(76, 3, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(77, 3, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(78, 3, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(79, 3, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(80, 3, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(81, 3, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(82, 3, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(83, 3, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(84, 3, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(85, 4, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(86, 4, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(87, 4, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(88, 4, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(89, 4, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(90, 4, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(91, 4, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(92, 4, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(93, 4, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(94, 4, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(95, 4, 'About me', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(96, 4, 'Searching for a', 0, 0, 1, '', 4, 1, 'Man, Woman, Couple', 'Man', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(97, 4, 'About the partner', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'col_20', '', 2700, 0),
(98, 4, 'Purpose', 0, 0, 1, '', 4, 1, 'Friendship, Marriage, Sex', 'Friendship', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_21', '', 2800, 0),
(99, 5, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(100, 5, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(101, 5, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(102, 5, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(103, 5, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(104, 5, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(105, 5, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(106, 5, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(107, 5, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_0', '', 1800, 0),
(108, 5, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_1', '', 1900, 0),
(109, 5, 'Consumption', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', ' l/mile', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_2', '', 2000, 0),
(110, 5, 'Broken', 0, 0, 1, '', 3, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_3', '', 2100, 0),
(111, 5, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_4', '', 2200, 0),
(112, 5, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(113, 5, 'Pic2', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_17', '', 2400, 0),
(114, 5, 'Pic3', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_18', '', 2500, 0),
(115, 5, 'Pic4', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_19', '', 2600, 0),
(116, 5, 'Pic5', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_20', '', 2700, 0),
(117, 5, 'Pic6', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_21', '', 2800, 0),
(118, 5, 'Pic7', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_22', '', 2900, 0),
(119, 5, 'Pic8', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_23', '', 3000, 0),
(120, 5, 'Pic9', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_24', '', 3100, 0),
(121, 6, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(122, 6, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(123, 6, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(124, 6, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(125, 6, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(126, 6, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(127, 6, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(128, 6, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(129, 6, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_0', '', 1800, 0),
(130, 6, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_1', '', 1900, 0),
(131, 6, 'Consumption', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', ' l/mile', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_2', '', 2000, 0),
(132, 6, 'Broken', 0, 0, 1, '', 3, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_3', '', 2100, 0),
(133, 6, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_4', '', 2200, 0),
(134, 6, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(135, 6, 'Pic2', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_17', '', 2400, 0),
(136, 6, 'Pic3', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_18', '', 2500, 0),
(137, 6, 'Pic4', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_19', '', 2600, 0),
(138, 6, 'Pic5', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_20', '', 2700, 0),
(139, 6, 'Pic6', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_21', '', 2800, 0),
(140, 6, 'Pic7', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_22', '', 2900, 0),
(141, 6, 'Pic8', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_23', '', 3000, 0),
(142, 6, 'Pic9', 0, 0, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 'col_24', '', 3100, 0),
(143, 7, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(144, 7, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(145, 7, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(146, 7, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(147, 7, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(148, 7, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(149, 7, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(150, 7, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(151, 7, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(152, 7, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(153, 7, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(154, 7, 'Type', 0, 0, 1, '', 4, 1, 'Pc, Mac', 'Pc', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(155, 7, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_20', '', 2700, 0),
(156, 8, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(157, 8, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(158, 8, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(159, 8, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(160, 8, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(161, 8, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(162, 8, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(163, 8, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(164, 8, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(165, 8, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(166, 8, 'Description', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(167, 8, 'Type', 0, 0, 1, '', 4, 1, 'Pc, Mac', 'Pc', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(168, 8, 'Price', 0, 0, 1, '', 1, 3, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '$ ', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_20', '', 2700, 0),
(169, 9, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(170, 9, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(171, 9, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(172, 9, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(173, 9, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(174, 9, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(175, 9, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(176, 9, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(177, 9, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(178, 9, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(179, 9, 'About me', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(180, 9, 'Searching for a', 0, 0, 1, '', 4, 1, 'Man, Woman, Couple', 'Man', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(181, 9, 'About the partner', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'col_20', '', 2700, 0),
(182, 9, 'Purpose', 0, 0, 1, '', 4, 1, 'Friendship, Marriage, Sex', 'Friendship', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_21', '', 2800, 0),
(183, 10, 'ID', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 'id', '', 1000, 0),
(184, 10, 'Category', 0, 0, 0, '', 4, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'cName', '', 1100, 0),
(185, 10, 'Created', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 'creationtime', '', 1200, 0),
(186, 10, 'Status', 0, 0, 4, '', 4, 1, '0,1', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 4, 1, 0, 4, 0, 0, 'status', '', 1300, 0),
(187, 10, 'Views', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'clicked', '', 1400, 0),
(188, 10, 'Responses', 0, 0, 0, '', 1, 2, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'responded', '', 1500, 0),
(189, 10, 'Owner', 0, 0, 0, '', 6, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'ownerName', '', 1600, 0),
(190, 10, 'Expiration', 0, 0, 0, '', 11, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 3, 1, 0, 4, 1, 0, 'expirationTime', '', 1700, 0),
(191, 10, 'Picture', 0, 1, 1, '', 8, 1, '', '', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 'col_16', '', 2300, 0),
(192, 10, 'Title', 0, 0, 1, '', 1, 1, '', '', 0, '', '3', 1, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 'col_17', '', 2400, 0),
(193, 10, 'About me', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 2, 'col_18', '', 2500, 0),
(194, 10, 'Searching for a', 0, 0, 1, '', 4, 1, 'Man, Woman, Couple', 'Man', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_19', '', 2600, 0),
(195, 10, 'About the partner', 0, 0, 1, '', 2, 1, '', '', 0, '', '3', 0, 1, 1, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'col_20', '', 2700, 0),
(196, 10, 'Purpose', 0, 0, 1, '', 4, 1, 'Friendship, Marriage, Sex', 'Friendship', 0, '', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 'col_21', '', 2800, 0),
(197, 1, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 3200, 0),
(198, 0, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 3200, 0),
(199, 2, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2800, 0),
(200, 3, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2700, 0),
(201, 4, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2900, 0),
(202, 5, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 3200, 0),
(203, 6, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 3200, 0),
(204, 7, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2800, 0),
(205, 8, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2800, 0),
(206, 9, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2900, 0),
(207, 10, 'Promotion level', 0, 1, 4, 'This is an example common field that has been set up so that only admin can see and set it. It is used in the search conditions of the demo ''Featured ads'' custom lists to fill those lists with the Gold, Silver and Bronze level featured ads.', 6, 1, 'None,Gold,Silver,Bronze', '', 0, 'None', '3', 0, 0, 0, 0, 'now', 'now', '', '', 2, '.', ',', '', 0, 0, 0, 0, 0, 0, 1, 1, 0, 4, 0, 0, 'col_25', '', 2900, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]globalstat`
--
CREATE TABLE `[[dbprefix]]globalstat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`instver` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`congrat` int(11) NOT NULL DEFAULT '1',
`defPageConf` int(11) NOT NULL DEFAULT '1',
`creationtime` date NOT NULL,
`lastUpdate` date NOT NULL,
`reg` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`registered` int(11) NOT NULL DEFAULT '0',
`company` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`firstName` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastName` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastUpdateCheck` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]globalstat`
--
INSERT INTO `[[dbprefix]]globalstat` VALUES
(1, '3.2.0', 1, 1, '[[regdate]]', '0000-00-00', '', 0, '', '', '', '', '0000-00-00');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]item`
--
CREATE TABLE `[[dbprefix]]item` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`firstCid` int(11) NOT NULL DEFAULT '0',
`creationtime` datetime NOT NULL,
`status` int(11) NOT NULL DEFAULT '1',
`clicked` int(11) NOT NULL DEFAULT '0',
`responded` int(11) NOT NULL DEFAULT '0',
`ownerId` int(11) NOT NULL DEFAULT '0',
`expEmailSent` int(11) NOT NULL DEFAULT '0',
`expirationTime` datetime NOT NULL,
`renewalNum` int(11) NOT NULL DEFAULT '0',
`expiration` int(11) NOT NULL DEFAULT '0',
`col_0` text COLLATE utf8_unicode_ci NOT NULL,
`col_1` text COLLATE utf8_unicode_ci NOT NULL,
`col_2` text COLLATE utf8_unicode_ci NOT NULL,
`col_3` text COLLATE utf8_unicode_ci NOT NULL,
`col_4` text COLLATE utf8_unicode_ci NOT NULL,
`col_16` text COLLATE utf8_unicode_ci NOT NULL,
`col_17` text COLLATE utf8_unicode_ci NOT NULL,
`col_18` text COLLATE utf8_unicode_ci NOT NULL,
`col_19` text COLLATE utf8_unicode_ci NOT NULL,
`col_20` text COLLATE utf8_unicode_ci NOT NULL,
`col_21` text COLLATE utf8_unicode_ci NOT NULL,
`col_22` text COLLATE utf8_unicode_ci NOT NULL,
`col_23` text COLLATE utf8_unicode_ci NOT NULL,
`col_24` text COLLATE utf8_unicode_ci NOT NULL,
`col_25` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
--
-- Dumping data for table `[[dbprefix]]item`
--
INSERT INTO `[[dbprefix]]item` VALUES
(1, 5, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 'Susuki Swift', '4 wheelsssss, 4 seats, low consumpion car for sale, 4 years old, in good condition', '10', '1', '5000', '', '', '', '', '', '', '', '', '', '1,2,3'),
(2, 5, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 'Toyota Yaris', '3 wheels, 5 seats, high consumpion car for sale, 2 years old, broken', '20', '', '50000', '', '', '', '', '', '', '', '', '', '1,2,3'),
(3, 5, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 'Fiat', '3 seats, metalgreen, high consumpion car for sale, 2 years old, broken', '12', '1', '52000', '', '', '', '', '', '', '', '', '', '1,2,3'),
(4, 1, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 'Audi TT', '4 seats, metal, high consumpion car for sale, 4 years old, broken', '13', '', '6000', 'jpg', 'jpg', 'jpg', 'jpg', 'jpg', 'jpg', 'jpg', 'jpg', 'jpg', '1,2,3'),
(5, 1, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 'Ferrari 308', '2 seats, metalred, high consumpion car for sale, 10 years old, in good condition', '30', '', '54000', 'jpg', '', '', '', '', '', '', '', '', '1,2,3'),
(6, 2, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Asus motherboard', 'With Intel Pentium 4 processor and integrated sound card', '0', '4000', '', '', '', '', '1,2,3'),
(7, 2, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Matrox G400 video card', 'A very fast card for low price', '1', '2000', '', '', '', '', '1,2,3'),
(8, 2, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Olympus C2000 Zoom digital camera', '2.1 M, 1600x1200 maxiimal resolution, 3x optical zoom, aperture priority, shutter priority, and more', '0', '1000', '', '', '', '', '1,2,3'),
(9, 9, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', 'jpg', '30 years old engineer', 'I am a years old engineer', '1', 'I am searching for a wife who is good in bed and kitchen', '1', '', '', '', '1,2,3'),
(10, 9, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', 'jpg', 'Don''t live me alone!', 'I am very handsome, I have a good job, but I am very shy with women.', '1', 'I want a girl who chain my heart', '2', '', '', '', '1,2,3'),
(11, 10, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', 'jpg', '18 years old girl', 'I am a 18 years old girl with nice hair', '0', 'I am searching for a real men', '2', '', '', '', '1,2,3'),
(12, 3, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Unique Home for Sale by Owner', 'Wood Blinds, tiled main areas and wood floors in rooms. Crown moldings. 4 bedroom 3 bath. Upgraded master bath. Will accept offers.', '', '', '', '', '', '', '1,2,3'),
(13, 3, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Land for Sale by Owner', 'The home was designed and constructed in 1998 by the owner on a 150 x 160 landscaped lot to enjoy the panoramic view of the golf course\n<br>A 600s/f 12'' ceiling patio and a 400s/f sunroom were added in 2003 facing East and the golf course (Hidden from the evening sun) for a total of 3165s/f AC and 5600s/f under roof\n <br>Entertaining is a breeze with two large entertaining areas as the sunroom flows into the large living area, kitchen/dining and the outside patio\n <br>Gleaming hard wood floors, built-in bookshelves, gas fireplace and wet bar compliment the living areas\n <br>The master suite, complete with gas fireplace, has adjoining room to be use as an exercise area, study or additional sleeping area\n <br>A large walk in cedar lined closet adjoins the master bath\n <br>Three bedrooms with two and a half bathrooms. The third bedroom/study features a queen size Murphey bed and built-in book- shelves', '', '', '', '', '', '', '1,2,3'),
(14, 3, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Unique Home for Sale by Owner', 'The Oldest Summer Resort in Australia.\n<br><br>\nBuild your trophy home in Waterfall Bay on beautiful Lake Winnettou.\n190 feet of water frontage, boathouse with clear, deep water dock. Westerly exposure with million dollar breathtaking sunsets. 180 degree view of lake and mountains, premier location. Walking distance to all amenities. This property is a real gem!\n<br><br>\n3 million or best offer. For sale by owner. Serious inquiries only. ', '', '', '', '', '', '', '1,2,3'),
(15, 3, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Townhouse for Sale by Owner', 'This building has passed all city codes for occupancy for a day care center, 35 kids per shift ages infants to 12 yrs 6:00am to 11:00pm.1,000 sq. ft. of play area, w/new paved lot, five car parking in back, plus handicap stall Land has been added to this building for the parking.Inside 1,300 sq. ft. New air conditioning, heating system, and ventilation. The lower 1654 daycare center have been completely gutted and remodeled The upper 1656 Tenants have been there 10 yrs and is on rent assistant. Have all ten years of maintenance records ', '', '', '', '', '', '', '1,2,3'),
(16, 3, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Mix use/Commercial for Sale by Owner', 'WOW! Don''t miss this one! Beautiful new condo in a wonderful gated community with full amenities off US1 (Federal) . Close to the beach. Light and Bright. Partial water view. Split Bedrooms with Walk-In Closets. Master Bath with Roman Tub. Large Designer Kitchen with lots of counterspace and GE Appliances. Neutral carpet and tile. Washer/Dryer in unit. Low maintenance includes DSL and Direct TV. Bike to the beach or a short drive to XY Avenue. A great new home or investment property! ', '', '', '', '', '', '', '1,2,3'),
(17, 3, 0, '[[regtime]]', 1, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, '', '', '', '', '', '', 'Must See Home for Sale by Owner', 'New hardwood floors throughout 1st floor. Partially finished basement. Newly renovated kitchen and bath. Large wrap-around deck overlooking spacious backyard with Koi Pond! Adjacent subdivided lot for VALUABLE off-street parking and the ability to bulid on. Newer roof and hot water heater. Location close to local park, public transportation, and shopping. ', '', '', '', '', '', '', '1,2,3');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]notification`
--
CREATE TABLE `[[dbprefix]]notification` (
`id` int(11) NOT NULL DEFAULT '0',
`fixRecipent` int(11) NOT NULL DEFAULT '0',
`fixCC` int(11) NOT NULL DEFAULT '1',
`recipent` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`cc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`title` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`subject` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`variables` text COLLATE utf8_unicode_ci NOT NULL,
`body` text COLLATE utf8_unicode_ci NOT NULL,
`active` int(11) NOT NULL DEFAULT '1',
`langDependent` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]notification`
--
INSERT INTO `[[dbprefix]]notification` VALUES
(1, 0, 1, '', '', 'Sent to the user after the registration, contains the initial password', 'Initial password', 'uname, pwd, url', 'notifications/email_initial_password.html', 1, 1),
(2, 0, 1, '', '', 'Contains a new password if the user forgot the old one.', 'New password', 'name, pwd, url', 'notifications/email_remind_password.html', 1, 1),
(101, 0, 1, '', '', 'Sent to admin upon ad creation or modification', 'Ad creation, or modification', 'title', 'notifications/email_ad_created.html', 1, 0),
(102, 0, 1, '', '', 'Sent to the owner when his ad has been deleted', 'Ad expiration', 'category, title', 'notifications/email_ad_deleted.html', 1, 0),
(103, 0, 1, '', '', 'Sent to the owner when his ad is about to expire', 'Ad expiration warning', 'daysLeft, category, title', 'notifications/email_ad_expired.html', 1, 0),
(104, 0, 1, '', '', 'Sent to the owner when his ad have been approved', 'Ad approval', 'title', 'notifications/email_ad_approved.html', 1, 0),
(105, 0, 1, '', '', 'Reply to a posting', 'Reply to your posting', 'listing, url, name, email, message', 'notifications/email_ad_replied.html', 1, 1),
(106, 0, 1, '', '', 'Mail to a friend', 'Check this out', 'name, url, message', 'notifications/email_to_friend.html', 1, 1),
(109, 0, 1, '', '', 'Auto notify email', 'Auto notify: a new ad has been submitted', 'title, unsubUrl', 'notifications/email_subscription.html', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]search`
--
CREATE TABLE `[[dbprefix]]search` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`name` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`autoNotify` int(11) NOT NULL DEFAULT '0',
`query` text COLLATE utf8_unicode_ci NOT NULL,
`relationBetweenFields` int(11) NOT NULL DEFAULT '1',
`cid` int(11) NOT NULL DEFAULT '0',
`col_0` text COLLATE utf8_unicode_ci NOT NULL,
`col_1` text COLLATE utf8_unicode_ci NOT NULL,
`col_2` text COLLATE utf8_unicode_ci NOT NULL,
`col_3` text COLLATE utf8_unicode_ci NOT NULL,
`col_4` text COLLATE utf8_unicode_ci NOT NULL,
`col_16` text COLLATE utf8_unicode_ci NOT NULL,
`col_17` text COLLATE utf8_unicode_ci NOT NULL,
`col_18` text COLLATE utf8_unicode_ci NOT NULL,
`col_19` text COLLATE utf8_unicode_ci NOT NULL,
`col_20` text COLLATE utf8_unicode_ci NOT NULL,
`col_21` text COLLATE utf8_unicode_ci NOT NULL,
`col_22` text COLLATE utf8_unicode_ci NOT NULL,
`col_23` text COLLATE utf8_unicode_ci NOT NULL,
`col_24` text COLLATE utf8_unicode_ci NOT NULL,
`col_25` text COLLATE utf8_unicode_ci NOT NULL,
`listTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`listDescription` text COLLATE utf8_unicode_ci NOT NULL,
`iid` int(11) NOT NULL,
`creationtime` datetime NOT NULL,
`creationtime_from` datetime NOT NULL,
`creationtime_to` datetime NOT NULL,
`status` int(11) NOT NULL DEFAULT '-1',
`clicked` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`responded` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`ownerName` text COLLATE utf8_unicode_ci NOT NULL,
`expirationTime` datetime NOT NULL,
`expirationTime_from` datetime NOT NULL,
`expirationTime_to` datetime NOT NULL,
`primarySort` int(11) NOT NULL,
`primaryDir` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ASC',
`primaryPersistent` int(11) NOT NULL,
`secondarySort` int(11) NOT NULL,
`secondaryDir` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ASC',
`secondaryPersistent` int(11) NOT NULL,
`limit` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`columns` text COLLATE utf8_unicode_ci NOT NULL,
`displayedFor` int(11) NOT NULL DEFAULT '1',
`pages` text COLLATE utf8_unicode_ci NOT NULL,
`displayInMenu` int(11) NOT NULL,
`categorySpecific` int(11) NOT NULL,
`recursive` int(11) NOT NULL,
`listStyle` int(11) NOT NULL,
`loop` int(11) NOT NULL DEFAULT '0',
`autoScroll` int(11) NOT NULL DEFAULT '60',
`cache` int(11) NOT NULL DEFAULT '60',
`positionNormal` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`positionScrollable` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
--
-- Dumping data for table `[[dbprefix]]search`
--
INSERT INTO `[[dbprefix]]search` VALUES
(1, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND n.status=''1'' AND 0', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '', 'Search result list', 'This is a special custom list you can use to configure the columns of a non-category specific search result list.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', -1, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'ASC', 0, 0, 'ASC', 0, '', '9,2,10,7,51', 1, '', 0, 0, 0, 0, 0, 60, 60, '', ''),
(2, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.ownerId=#gorumuser#)', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '', 'My ads', 'The list of ads of a user. This means both the ''My ads'' list (the list of the currently logged in user), and the ''Advertisements of user XY'' lists.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', -1, '', '', '', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 'DESC', 0, 0, 'ASC', 0, '', '9,2,5,6,10', 2, '', 2, 0, 0, 0, 0, 60, 60, '', ''),
(3, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.status=''1'')', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '', 'Recent ads', 'List of 100 most recent ads', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 'DESC', 0, 0, 'ASC', 0, '100', '9,2,3,10,51', 1, '', 1, 0, 0, 0, 0, 60, 60, '', ''),
(4, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.status=''1'')', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '', 'Popular ads', 'List of 100 most viewed ads', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 'DESC', 0, 3, 'DESC', 0, '100', '9,2,5,6,10,51', 1, '', 1, 0, 0, 0, 0, 60, 60, '', ''),
(5, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.status=''0'')', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '', 'Pending ads', 'The list of ads that you haven''t approved yet.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 'ASC', 0, 0, 'ASC', 0, '', '9,2,3,7,10', 4, '', 3, 0, 0, 0, 0, 60, 60, '', ''),
(6, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.status=''1'' OR (FIND_IN_SET(''1'', n.col_25)!=0))', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '1', 'Featured ads: Gold level', 'This is a featured ad list that demonstrate a way you can set up the ''featured ads'' feature yourself. It contains all the ads where the ''Promotion level'' common custom field has been set to ''Gold''.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'ASC', 0, 0, 'ASC', 0, '10', '9,51,10', 4, '/', 0, 0, 0, 1, 0, 60, 60, '', '0'),
(7, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.status=''1'' OR (FIND_IN_SET(''2'', n.col_25)!=0))', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '2', 'Featured ads: Silver level', 'It contains all the ads where the ''Promotion level'' common custom field has been set to ''Silver''.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'ASC', 0, 0, 'ASC', 0, '10', '9,51,10', 4, '', 0, 0, 0, 1, 0, 60, 60, '', '4'),
(8, 0, '', 0, 'SELECT n.*, c.wholeName AS cName, c.immediateAppear AS immediateAppear \n FROM @item AS n, @category AS c , @user AS u\n WHERE n.ownerId=u.id AND c.id=n.cid AND (n.status=''1'' OR (FIND_IN_SET(''3'', n.col_25)!=0))', 1, 0, '', '', '', '', '', '-1', '', '', '', '', '', '', '', '', '3', 'Featured ads: Bronze level', 'It contains all the ads where the ''Promotion level'' common custom field has been set to ''Bronze''.', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'ASC', 0, 0, 'ASC', 0, '10', '9,51,10', 4, '', 0, 0, 0, 1, 0, 60, 60, '', '5');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]settings`
--
CREATE TABLE `[[dbprefix]]settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`expNoticeBefore` int(11) NOT NULL DEFAULT '5',
`renewal` int(11) NOT NULL DEFAULT '5',
`maxPicSize` int(11) NOT NULL DEFAULT '0',
`maxPicWidth` int(11) NOT NULL DEFAULT '0',
`maxPicHeight` int(11) NOT NULL DEFAULT '0',
`menuPoints` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`extraHead` text COLLATE utf8_unicode_ci NOT NULL,
`extraBody` text COLLATE utf8_unicode_ci NOT NULL,
`extraTopContent` text COLLATE utf8_unicode_ci NOT NULL,
`extraBottomContent` text COLLATE utf8_unicode_ci NOT NULL,
`extraFooter` text COLLATE utf8_unicode_ci NOT NULL,
`defaultTheme` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'modern',
`allowSelectTheme` int(11) NOT NULL DEFAULT '1',
`allowedThemes` text COLLATE utf8_unicode_ci NOT NULL,
`defaultLanguage` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`allowSelectLanguage` int(11) NOT NULL DEFAULT '0',
`allowedLanguages` text COLLATE utf8_unicode_ci NOT NULL,
`langDir` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ltr',
`adminEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`adminFromName` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`smtpServer` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`smtpUser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`smtpPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`fallBackNative` int(11) NOT NULL DEFAULT '0',
`titlePrefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`mainTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`mainDescription` text COLLATE utf8_unicode_ci NOT NULL,
`mainKeywords` text COLLATE utf8_unicode_ci NOT NULL,
`charLimit` int(11) NOT NULL DEFAULT '0',
`blockSize` int(5) NOT NULL DEFAULT '0',
`dateFormat` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`joomlaLink` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`helpLink` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`applyCaptcha` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`updateCheckInterval` int(5) NOT NULL DEFAULT '0',
`maxMediaSize` int(11) NOT NULL DEFAULT '50000',
`allowModify` int(11) NOT NULL DEFAULT '1',
`enableFavorities` int(11) NOT NULL DEFAULT '5',
`subscriptionType` int(11) NOT NULL DEFAULT '5',
`enableUserSearch` int(11) NOT NULL DEFAULT '1',
`showExplanation` tinyint(4) NOT NULL DEFAULT '0',
`versionFooter` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]settings`
--
INSERT INTO `[[dbprefix]]settings` VALUES
(1, 5, 5, 0, 0, 0, '1,2,3,4,5,6,7,8,9,10,11,12', '', '', '', '', '', 'modern', 1, 'classic,modern', 'en', 0, 'en', 'ltr', '', '', '', '', '', 0, '[Noah''s Classifieds]', '', '', '', 0, 20, 'Y-m-d', '', '', '', 7, 50000, 1, 5, 5, 1, 0, 'Powered by <a href=''http://noahsclassifieds.org''>Noah''s Classifieds</a> 3.2.0 - \n <a href=''http://noahsclassifieds.org'' >try Noah''s Classifieds V8 e-commerce enabled</a>');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]subscription`
--
CREATE TABLE `[[dbprefix]]subscription` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]user`
--
CREATE TABLE `[[dbprefix]]user` (
`id` int(11) NOT NULL DEFAULT '0',
`name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`newPassword` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`rememberPassword` int(11) NOT NULL DEFAULT '0',
`isAdm` int(11) NOT NULL DEFAULT '0',
`creationtime` datetime NOT NULL,
`lastClickTime` datetime NOT NULL,
`active` int(11) NOT NULL DEFAULT '0',
`favorities` text COLLATE utf8_unicode_ci NOT NULL,
`col_0` text COLLATE utf8_unicode_ci NOT NULL,
`col_1` text COLLATE utf8_unicode_ci NOT NULL,
`col_2` text COLLATE utf8_unicode_ci NOT NULL,
`col_4` text COLLATE utf8_unicode_ci NOT NULL,
`col_5` text COLLATE utf8_unicode_ci NOT NULL,
`col_6` text COLLATE utf8_unicode_ci NOT NULL,
`col_7` text COLLATE utf8_unicode_ci NOT NULL,
`col_8` text COLLATE utf8_unicode_ci NOT NULL,
`col_9` text COLLATE utf8_unicode_ci NOT NULL,
`col_10` text COLLATE utf8_unicode_ci NOT NULL,
`col_11` text COLLATE utf8_unicode_ci NOT NULL,
`col_12` text COLLATE utf8_unicode_ci NOT NULL,
`col_13` text COLLATE utf8_unicode_ci NOT NULL,
`col_14` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]user`
--
INSERT INTO `[[dbprefix]]user` VALUES
(553404153, '[[admin_username]]', '[[admin_email]]', OLD_PASSWORD('[[admin_pass]]'), '', 0, 1, '[[regtime]]', '[[regtime]]', 1, '', '', '', '', '', '', '', '0', '222', '', '0', '', '', '', ''),
(10, 'john', '', '60671c896665c3fa', '', 0, 0, '[[regtime]]', '0000-00-00 00:00:00', 1, '', 'John', 'Wayne', 'This is a test user only, whose sole purpose is to demonstrate the feature of adding and using user custom fields. It is supposed to be deleted from the live program.', 'Apple st. 15', '55555', 'Chicago', '3', '222', '77', '1', '1931-10-23 00:00:00', 'jpg', '', ''),
(20, 'jack', '', '60671c896665c3fa', '', 0, 0, '[[regtime]]', '0000-00-00 00:00:00', 1, '', 'Jack', 'Lemmon', 'This is a test user only, whose sole purpose is to demonstrate the feature of adding and using user custom fields. It is supposed to be deleted from the live program.', 'Orange st. 25', '55551', 'New York', '3', '222', '66', '1', '1942-11-12 23:00:00', 'jpg', '', ''),
(30, 'al', '', '60671c896665c3fa', '', 0, 0, '[[regtime]]', '0000-00-00 00:00:00', 1, '', 'Al', 'Pachino', 'This is a test user only, whose sole purpose is to demonstrate the feature of adding and using user custom fields. It is supposed to be deleted from the live program.', 'Peach st. 25', '45551', 'Chicago', '2', '222', '55', '', '1953-01-18 00:00:00', 'jpg', '', ''),
(40, 'mel', '', '60671c896665c3fa', '', 0, 0, '[[regtime]]', '0000-00-00 00:00:00', 1, '', 'Mel', 'Gibson', 'This is a test user only, whose sole purpose is to demonstrate the feature of adding and using user custom fields. It is supposed to be deleted from the live program.', 'Banana st. 25', '45551', 'Washington', '2', '222', '53', '', '1948-11-13 00:00:00', 'jpg', '', '');
/*!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 */;