--
-- Host: localhost    Database: squiant_clss1
-- ------------------------------------------------------


--
-- Table structure for table `classifieds_category`
--

CREATE TABLE `classifieds_category` (
  `id` int(11) NOT NULL auto_increment,
  `up` int(11) NOT NULL,
  `name` varchar(250) collate utf8_unicode_ci NOT NULL default '',
  `wholeName` text collate utf8_unicode_ci NOT NULL,
  `subCatNum` int(11) NOT NULL,
  `directSubCatNum` int(11) NOT NULL,
  `itemNum` int(11) NOT NULL,
  `directItemNum` int(11) NOT NULL,
  `allowAd` int(11) NOT NULL default '1',
  `allowSubmitAdAdmin` int(11) NOT NULL default '0',
  `description` text collate utf8_unicode_ci NOT NULL,
  `keywords` text collate utf8_unicode_ci NOT NULL,
  `picture` varchar(250) collate utf8_unicode_ci NOT NULL default '',
  `creationtime` datetime NOT NULL,
  `expiration` int(11) NOT NULL default '0',
  `expirationEnabled` int(11) NOT NULL default '0',
  `expirationOverride` int(11) NOT NULL default '0',
  `immediateAppear` int(11) NOT NULL default '1',
  `customAdListTitle` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sortId` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classifieds_category`
--

INSERT INTO `classifieds_category` VALUES (1,0,'Automotores','Automotores',2,2,0,0,1,0,'autos, camionetas, motocicletas y todo tipo de automotores','','gif','0000-00-00 00:00:00',30,0,0,1,'',0),(2,0,'Electrónicos','Electrónicos',2,2,0,0,1,0,'Hardware, teléfonos, PDAs, y todo tipo de electrónicos','','gif','0000-00-00 00:00:00',30,0,0,1,'',0),(3,0,'Inmobiliario','Inmobiliario',5,5,0,0,1,0,'Casas, departamentos, terrenos, venta y renta','','gif','0000-00-00 00:00:00',30,0,0,1,'',0),(4,0,'Empleos','Empleos',2,2,0,0,1,0,'Empresas buscan empleados temporales y permanentes','','gif','0000-00-00 00:00:00',30,0,0,1,'',0),(13,3,'Terrenos','Inmobiliario - Terrenos',0,0,0,0,1,0,'','','','2008-09-22 04:45:56',30,0,0,1,'',0),(5,1,'Economy cars','Automotores - Economy cars',0,0,0,0,1,0,'If you don\'t want to pay much at your petrol station and you dont\'t want problems during parking, search here.','','jpg','0000-00-00 00:00:00',0,0,0,0,'',0),(6,1,'Pickups','Automotores - Pickups',0,0,0,0,1,0,'You always have been dreaming about a nice picup? Check it out here...','','jpg','0000-00-00 00:00:00',0,0,0,0,'',0),(7,2,'Hard disks','Electrónicos - Hard disks',0,0,0,0,1,0,'','','','0000-00-00 00:00:00',0,0,0,0,'',0),(8,2,'Memory chips','Electrónicos - Memory chips',0,0,0,0,1,0,'','','','0000-00-00 00:00:00',0,0,0,0,'',0),(9,4,'Men','Empleos - Men',0,0,0,0,1,0,'','','','0000-00-00 00:00:00',0,0,0,0,'',0),(10,4,'Women','Empleos - Women',0,0,0,0,1,0,'','','','0000-00-00 00:00:00',0,0,0,0,'',0),(14,3,'Casas','Inmobiliario - Casas',0,0,0,0,1,0,'','','','2008-09-22 04:46:25',30,0,0,1,'',0),(15,3,'Departamentos','Inmobiliario - Departamentos',0,0,0,0,1,0,'','','','2008-09-22 04:46:50',30,0,0,1,'',0),(16,3,'Oficinas','Inmobiliario - Oficinas',0,0,0,0,1,0,'','','','2008-09-22 04:47:36',30,0,0,1,'',0),(17,3,'Bodegas','Inmobiliario - Bodegas',0,0,0,0,1,0,'','','','2008-09-22 04:47:55',30,0,0,1,'',0);

--
-- Table structure for table `classifieds_cronjob`
--

CREATE TABLE `classifieds_cronjob` (
  `id` int(11) NOT NULL,
  `title` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `lastExecutionTime` datetime NOT NULL,
  `frequency` int(11) NOT NULL,
  `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 `classifieds_cronjob`
--

INSERT INTO `classifieds_cronjob` VALUES (1,'Check advertisement expirations','2010-07-14 22:43:58',24,1,'checkExpiration();'),(2,'Delete expired advertisements','2010-07-14 22:43:58',24,1,'deleteExpiredAds();'),(3,'Delete inactive guests','2010-07-14 22:43:58',24,1,'deleteInactiveGuests();');

--
-- Table structure for table `classifieds_customfield`
--

CREATE TABLE `classifieds_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 '',
  `expl` text collate utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL default '1',
  `subType` int(11) NOT NULL default '1',
  `rangeSearch` int(11) NOT NULL default '0',
  `formatPrefix` varchar(255) collate utf8_unicode_ci NOT NULL,
  `formatPostfix` varchar(255) collate utf8_unicode_ci NOT NULL,
  `precision` int(11) NOT NULL default '2',
  `precisionSeparator` varchar(1) collate utf8_unicode_ci NOT NULL default '.',
  `thousandsSeparator` varchar(1) collate utf8_unicode_ci NOT NULL default ',',
  `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,
  `mandatory` int(11) NOT NULL default '0',
  `showInList` int(11) NOT NULL default '0',
  `innewline` int(11) NOT NULL default '0',
  `displayLabel` int(11) NOT NULL default '1',
  `detailsPosition` int(11) NOT NULL default '0',
  `rowspan` int(11) NOT NULL default '0',
  `displaylength` int(5) NOT NULL default '0',
  `allowHtml` int(11) NOT NULL default '0',
  `useMarkitup` int(11) NOT NULL default '0',
  `searchable` int(11) NOT NULL default '0',
  `format` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `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',
  `sortable` int(11) NOT NULL default '0',
  `seo` int(11) NOT NULL default '0',
  `mainPicture` int(11) NOT NULL default '0',
  `columnIndex` int(11) NOT NULL default '0',
  `oldColumnIndex` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sortId` int(11) NOT NULL default '0',
  `fields` int(11) NOT NULL default '0',
  `showInDetails` int(11) NOT NULL default '1',
  `hideFromForm` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classifieds_customfield`
--

INSERT INTO `classifieds_customfield` VALUES (1,1,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(2,1,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(3,1,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(4,1,'Consumption','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(5,1,'Broken','',3,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(6,1,'Price','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,5,'col_3',1500,0,1,0),(7,2,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(8,2,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(9,2,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(10,2,'Type','',4,1,0,'','',2,'.',',','Pc, Mac','Pc',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(11,2,'Price','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(12,3,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(13,3,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(14,3,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(15,4,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(16,4,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(17,4,'About me','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(18,4,'About the partner','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(19,4,'Searching for a','',4,1,0,'','',2,'.',',','Man, Woman, Couple','Man',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(20,4,'Purpose','',4,1,0,'','',2,'.',',','Friendship, Marriage, Sex','Friendship',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,5,'col_3',1500,0,1,0),(21,5,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(22,5,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(23,5,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(24,5,'Consumption','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(25,5,'Broken','',3,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(26,5,'Price','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,5,'col_3',1500,0,1,0),(27,6,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(28,6,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(29,6,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(30,6,'Consumption','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(31,6,'Broken','',3,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(32,6,'Price','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,5,'col_3',1500,0,1,0),(33,7,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(34,7,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(35,7,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(36,7,'Type','',4,1,0,'','',2,'.',',','Pc, Mac','Pc',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(37,7,'Price','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(38,8,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(39,8,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(40,8,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(41,8,'Type','',4,1,0,'','',2,'.',',','Pc, Mac','Pc',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(42,8,'Price','',1,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(43,9,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(44,9,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(45,9,'About me','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(46,9,'About the partner','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(47,9,'Searching for a','',4,1,0,'','',2,'.',',','Man, Woman, Couple','Man',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(48,9,'Purpose','',4,1,0,'','',2,'.',',','Friendship, Marriage, Sex','Friendship',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,5,'col_3',1500,0,1,0),(49,10,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(50,10,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(51,10,'About me','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(52,10,'About the partner','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,3,'col_1',1300,0,1,0),(53,10,'Searching for a','',4,1,0,'','',2,'.',',','Man, Woman, Couple','Man',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'col_2',1400,0,1,0),(54,10,'Purpose','',4,1,0,'','',2,'.',',','Friendship, Marriage, Sex','Friendship',0,'',0,1,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,5,'col_3',1500,0,1,0),(68,14,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(67,14,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(66,13,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1098,0,1,0),(64,13,'Título','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(65,13,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1099,0,1,0),(69,14,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(70,15,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(71,15,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(72,15,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(73,16,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(74,16,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(75,16,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(76,17,'Title','',1,1,0,'','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,1,0,0,'title',1000,0,1,0),(77,17,'Picture','',8,1,0,'','',2,'.',',','','',0,'',0,1,0,1,0,1,0,0,0,0,'',0,'now','now',0,0,1,1,'picture',1100,0,1,0),(78,17,'Description','',2,1,0,'','',2,'.',',','','',0,'',0,1,1,1,0,0,0,0,0,1,'',0,'now','now',0,0,0,2,'col_0',1200,0,1,0),(79,13,'Ubicación','Dirección donde se encuentra el terreno',2,1,0,'','',2,'.',',','','',0,'',1,0,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,3,'',1098,0,1,0),(80,13,'m2','Extensión del terreno en metros cuadrados',1,2,0,'','',2,'.',',','','',0,'',1,0,0,1,0,0,0,0,0,0,'',0,'now','now',0,0,0,4,'',1097,0,1,0),(81,13,'Precio','Precio del m2 o del terreno en su totalidad',1,2,1,'$','',2,'.',',','','',0,'',1,1,0,1,0,0,0,0,0,1,'',0,'now','now',1,0,0,5,'',1097,0,1,0);

--
-- Table structure for table `classifieds_globalstat`
--

CREATE TABLE `classifieds_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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classifieds_globalstat`
--

INSERT INTO `classifieds_globalstat` VALUES (1,'2.4.1',0,0,'2008-09-22','2008-09-22','',0,'','','','','2008-09-22');

--
-- Table structure for table `classifieds_item`
--

CREATE TABLE `classifieds_item` (
  `id` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL,
  `firstCid` int(11) NOT NULL,
  `creationtime` datetime NOT NULL,
  `status` int(11) NOT NULL default '1',
  `clicked` int(11) NOT NULL,
  `responded` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `expEmailSent` int(11) NOT NULL default '0',
  `expirationTime` datetime NOT NULL,
  `expiration` int(11) NOT NULL default '0',
  `renewalNum` int(11) 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_3` 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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classifieds_item`
--


--
-- Table structure for table `classifieds_notification`
--

CREATE TABLE `classifieds_notification` (
  `id` int(11) NOT NULL,
  `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 `classifieds_notification`
--



--
-- Table structure for table `classifieds_rss`
--

CREATE TABLE `classifieds_rss` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `language` varchar(10) NOT NULL default 'en-us',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `classifieds_rss`
--

INSERT INTO `classifieds_rss` VALUES (1,'Noah\'s Classifieds RSS feed','Latest ads from Noah\'s Classifieds','en-us');

--
-- Table structure for table `classifieds_search`
--

CREATE TABLE `classifieds_search` (
  `id` int(11) NOT NULL,
  `name` varchar(250) collate utf8_unicode_ci NOT NULL default '',
  `autoNotify` int(11) NOT NULL,
  `query` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classifieds_search`
--


--
-- Table structure for table `classifieds_subscription`
--

CREATE TABLE `classifieds_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;

--
-- Dumping data for table `classifieds_subscription`
--


--
-- Table structure for table `classifieds_varfields`
--

CREATE TABLE `classifieds_varfields` (
  `id` int(11) NOT NULL,
  `showCreationTime` int(11) NOT NULL default '0',
  `showExpirationTime` int(11) NOT NULL default '0',
  `name_0` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_0` int(11) NOT NULL default '1',
  `active_0` int(11) NOT NULL default '0',
  `everActivated_0` int(11) NOT NULL default '0',
  `values_0` text collate utf8_unicode_ci NOT NULL,
  `default_0` text collate utf8_unicode_ci NOT NULL,
  `mandatory_0` int(11) NOT NULL,
  `list_0` int(11) NOT NULL,
  `innewline_0` int(11) NOT NULL,
  `searchable_0` int(11) NOT NULL,
  `badwords_0` int(11) NOT NULL,
  `allowHtml_0` int(11) NOT NULL,
  `private_0` int(11) NOT NULL,
  `hidden_0` int(11) NOT NULL,
  `format_0` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_1` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_1` int(11) NOT NULL default '1',
  `active_1` int(11) NOT NULL default '0',
  `everActivated_1` int(11) NOT NULL default '0',
  `values_1` text collate utf8_unicode_ci NOT NULL,
  `default_1` text collate utf8_unicode_ci NOT NULL,
  `mandatory_1` int(11) NOT NULL,
  `list_1` int(11) NOT NULL,
  `innewline_1` int(11) NOT NULL,
  `searchable_1` int(11) NOT NULL,
  `badwords_1` int(11) NOT NULL,
  `allowHtml_1` int(11) NOT NULL,
  `private_1` int(11) NOT NULL,
  `hidden_1` int(11) NOT NULL,
  `format_1` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_2` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_2` int(11) NOT NULL default '1',
  `active_2` int(11) NOT NULL default '0',
  `everActivated_2` int(11) NOT NULL default '0',
  `values_2` text collate utf8_unicode_ci NOT NULL,
  `default_2` text collate utf8_unicode_ci NOT NULL,
  `mandatory_2` int(11) NOT NULL,
  `list_2` int(11) NOT NULL,
  `innewline_2` int(11) NOT NULL,
  `searchable_2` int(11) NOT NULL,
  `badwords_2` int(11) NOT NULL,
  `allowHtml_2` int(11) NOT NULL,
  `private_2` int(11) NOT NULL,
  `hidden_2` int(11) NOT NULL,
  `format_2` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_3` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_3` int(11) NOT NULL default '1',
  `active_3` int(11) NOT NULL default '0',
  `everActivated_3` int(11) NOT NULL default '0',
  `values_3` text collate utf8_unicode_ci NOT NULL,
  `default_3` text collate utf8_unicode_ci NOT NULL,
  `mandatory_3` int(11) NOT NULL,
  `list_3` int(11) NOT NULL,
  `innewline_3` int(11) NOT NULL,
  `searchable_3` int(11) NOT NULL,
  `badwords_3` int(11) NOT NULL,
  `allowHtml_3` int(11) NOT NULL,
  `private_3` int(11) NOT NULL,
  `hidden_3` int(11) NOT NULL,
  `format_3` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_4` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_4` int(11) NOT NULL default '1',
  `active_4` int(11) NOT NULL default '0',
  `everActivated_4` int(11) NOT NULL default '0',
  `values_4` text collate utf8_unicode_ci NOT NULL,
  `default_4` text collate utf8_unicode_ci NOT NULL,
  `mandatory_4` int(11) NOT NULL,
  `list_4` int(11) NOT NULL,
  `innewline_4` int(11) NOT NULL,
  `searchable_4` int(11) NOT NULL,
  `badwords_4` int(11) NOT NULL,
  `allowHtml_4` int(11) NOT NULL,
  `private_4` int(11) NOT NULL,
  `hidden_4` int(11) NOT NULL,
  `format_4` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_5` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_5` int(11) NOT NULL default '1',
  `active_5` int(11) NOT NULL default '0',
  `everActivated_5` int(11) NOT NULL default '0',
  `values_5` text collate utf8_unicode_ci NOT NULL,
  `default_5` text collate utf8_unicode_ci NOT NULL,
  `mandatory_5` int(11) NOT NULL,
  `list_5` int(11) NOT NULL,
  `innewline_5` int(11) NOT NULL,
  `searchable_5` int(11) NOT NULL,
  `badwords_5` int(11) NOT NULL,
  `allowHtml_5` int(11) NOT NULL,
  `private_5` int(11) NOT NULL,
  `hidden_5` int(11) NOT NULL,
  `format_5` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_6` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_6` int(11) NOT NULL default '1',
  `active_6` int(11) NOT NULL default '0',
  `everActivated_6` int(11) NOT NULL default '0',
  `values_6` text collate utf8_unicode_ci NOT NULL,
  `default_6` text collate utf8_unicode_ci NOT NULL,
  `mandatory_6` int(11) NOT NULL,
  `list_6` int(11) NOT NULL,
  `innewline_6` int(11) NOT NULL,
  `searchable_6` int(11) NOT NULL,
  `badwords_6` int(11) NOT NULL,
  `allowHtml_6` int(11) NOT NULL,
  `private_6` int(11) NOT NULL,
  `hidden_6` int(11) NOT NULL,
  `format_6` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_7` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_7` int(11) NOT NULL default '1',
  `active_7` int(11) NOT NULL default '0',
  `everActivated_7` int(11) NOT NULL default '0',
  `values_7` text collate utf8_unicode_ci NOT NULL,
  `default_7` text collate utf8_unicode_ci NOT NULL,
  `mandatory_7` int(11) NOT NULL,
  `list_7` int(11) NOT NULL,
  `innewline_7` int(11) NOT NULL,
  `searchable_7` int(11) NOT NULL,
  `badwords_7` int(11) NOT NULL,
  `allowHtml_7` int(11) NOT NULL,
  `private_7` int(11) NOT NULL,
  `hidden_7` int(11) NOT NULL,
  `format_7` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_8` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_8` int(11) NOT NULL default '1',
  `active_8` int(11) NOT NULL default '0',
  `everActivated_8` int(11) NOT NULL default '0',
  `values_8` text collate utf8_unicode_ci NOT NULL,
  `default_8` text collate utf8_unicode_ci NOT NULL,
  `mandatory_8` int(11) NOT NULL,
  `list_8` int(11) NOT NULL,
  `innewline_8` int(11) NOT NULL,
  `searchable_8` int(11) NOT NULL,
  `badwords_8` int(11) NOT NULL,
  `allowHtml_8` int(11) NOT NULL,
  `private_8` int(11) NOT NULL,
  `hidden_8` int(11) NOT NULL,
  `format_8` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_9` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `type_9` int(11) NOT NULL default '1',
  `active_9` int(11) NOT NULL default '0',
  `everActivated_9` int(11) NOT NULL default '0',
  `values_9` text collate utf8_unicode_ci NOT NULL,
  `default_9` text collate utf8_unicode_ci NOT NULL,
  `mandatory_9` int(11) NOT NULL,
  `list_9` int(11) NOT NULL,
  `innewline_9` int(11) NOT NULL,
  `searchable_9` int(11) NOT NULL,
  `badwords_9` int(11) NOT NULL,
  `allowHtml_9` int(11) NOT NULL,
  `private_9` int(11) NOT NULL,
  `hidden_9` int(11) NOT NULL,
  `format_9` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classifieds_varfields`
--

INSERT INTO `classifieds_varfields` VALUES (1,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','Consumption',1,1,1,'','',0,1,0,0,0,0,0,0,'','Broken',3,1,1,'','',0,1,0,0,0,0,0,0,'','Price',1,1,1,'','',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(2,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','Type',4,1,1,'Pc, Mac','Pc',0,1,0,0,0,0,0,0,'','Price',1,1,1,'','',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(3,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(4,0,0,'About me',2,1,1,'','',0,1,1,1,1,0,0,0,'','About the partner',2,1,1,'','',0,1,1,1,1,0,0,0,'','Searching for a',4,1,1,'Man, Woman, Couple','Man',0,1,0,0,0,0,0,0,'','Purpose',4,1,1,'Friendship, Marriage, Sex','Friendship',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(5,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','Consumption',1,1,1,'','',0,1,0,0,0,0,0,0,'','Broken',3,1,1,'','',0,1,0,0,0,0,0,0,'','Price',1,1,1,'','',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(6,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','Consumption',1,1,1,'','',0,1,0,0,0,0,0,0,'','Broken',3,1,1,'','',0,1,0,0,0,0,0,0,'','Price',1,1,1,'','',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(7,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','Type',4,1,1,'Pc, Mac','Pc',0,1,0,0,0,0,0,0,'','Price',1,1,1,'','',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(8,0,0,'Description',2,1,1,'','',0,1,1,1,1,0,0,0,'','Type',4,1,1,'Pc, Mac','Pc',0,1,0,0,0,0,0,0,'','Price',1,1,1,'','',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(9,0,0,'About me',2,1,1,'','',0,1,1,1,1,0,0,0,'','About the partner',2,1,1,'','',0,1,1,1,1,0,0,0,'','Searching for a',4,1,1,'Man, Woman, Couple','Man',0,1,0,0,0,0,0,0,'','Purpose',4,1,1,'Friendship, Marriage, Sex','Friendship',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,''),(10,0,0,'About me',2,1,1,'','',0,1,1,1,1,0,0,0,'','About the partner',2,1,1,'','',0,1,1,1,1,0,0,0,'','Searching for a',4,1,1,'Man, Woman, Couple','Man',0,1,0,0,0,0,0,0,'','Purpose',4,1,1,'Friendship, Marriage, Sex','Friendship',0,1,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'','',1,0,0,'','',0,0,0,0,0,0,0,0,'');


