-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 07, 2006 at 04:29 PM
-- Server version: 4.0.18
-- PHP Version: 4.3.6
-- 

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

-- 
-- Table structure for table `xzclf_adpics`
-- 

CREATE TABLE `xzclf_adpics` (
  `picid` int(10) unsigned NOT NULL auto_increment,
  `picfile` varchar(50) NOT NULL default '',
  `adid` int(10) unsigned NOT NULL default '0',
  `isevent` enum('0','1') NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`picid`),
  KEY `adid` (`adid`,`isevent`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_ads`
-- 

CREATE TABLE `xzclf_ads` (
  `adid` int(10) unsigned NOT NULL auto_increment,
  `adtitle` varchar(100) NOT NULL default '',
  `addesc` longtext NOT NULL,
  `area` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `showemail` enum('0','1','2') NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `code` varchar(35) NOT NULL default '',
  `cityid` smallint(5) unsigned NOT NULL default '0',
  `subcatid` smallint(5) unsigned NOT NULL default '0',
  `price` decimal(10,2) NOT NULL default '0.00',
  `othercontactok` enum('0','1') NOT NULL default '0',
  `hits` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `verified` enum('0','1') NOT NULL default '0',
  `abused` int(10) unsigned NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `createdon` datetime NOT NULL default '0000-00-00 00:00:00',
  `expireson` datetime NOT NULL default '0000-00-00 00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`adid`),
  KEY `subcatid` (`subcatid`),
  KEY `cityid` (`cityid`),
  KEY `verified` (`verified`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_adxfields`
-- 

CREATE TABLE `xzclf_adxfields` (
  `adid` int(10) unsigned NOT NULL default '0',
  `f1` varchar(255) NOT NULL default '',
  `f2` varchar(255) NOT NULL default '',
  `f3` varchar(255) NOT NULL default '',
  `f4` varchar(255) NOT NULL default '',
  `f5` varchar(255) NOT NULL default '',
  `f6` varchar(255) NOT NULL default '',
  `f7` varchar(255) NOT NULL default '',
  `f8` varchar(255) NOT NULL default '',
  `f9` varchar(255) NOT NULL default '',
  `f10` varchar(255) NOT NULL default '',
  `f11` varchar(255) NOT NULL default '',
  `f12` varchar(255) NOT NULL default '',
  `f13` varchar(255) NOT NULL default '',
  `f14` varchar(255) NOT NULL default '',
  `f15` varchar(255) NOT NULL default '',
  KEY `adid` (`adid`)
) TYPE=MyISAM;


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

-- 
-- Table structure for table `xzclf_areas`
-- 

CREATE TABLE `xzclf_areas` (
  `areaid` smallint(5) unsigned NOT NULL auto_increment,
  `areaname` varchar(50) NOT NULL default '',
  `cityid` smallint(5) unsigned NOT NULL default '0',
  `pos` smallint(5) unsigned NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`areaid`),
  KEY `pos` (`pos`),
  KEY `cityid` (`cityid`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_cats`
-- 

CREATE TABLE `xzclf_cats` (
  `catid` smallint(5) unsigned NOT NULL auto_increment,
  `catname` varchar(50) NOT NULL default '',
  `pos` smallint(5) unsigned NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`catid`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_cities`
-- 

CREATE TABLE `xzclf_cities` (
  `cityid` smallint(5) unsigned NOT NULL auto_increment,
  `cityname` varchar(50) NOT NULL default '',
  `countryid` smallint(5) unsigned NOT NULL default '0',
  `pos` smallint(5) unsigned NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`cityid`),
  KEY `countryid` (`countryid`),
  KEY `pos` (`pos`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_countries`
-- 

CREATE TABLE `xzclf_countries` (
  `countryid` smallint(5) unsigned NOT NULL auto_increment,
  `countryname` varchar(50) NOT NULL default '',
  `pos` smallint(5) unsigned NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`countryid`),
  KEY `pos` (`pos`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_events`
-- 

CREATE TABLE `xzclf_events` (
  `adid` int(10) unsigned NOT NULL auto_increment,
  `adtitle` varchar(100) NOT NULL default '',
  `addesc` longtext NOT NULL,
  `area` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `showemail` enum('0','1','2') NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `code` varchar(35) NOT NULL default '',
  `cityid` smallint(5) unsigned NOT NULL default '0',
  `starton` date NOT NULL default '0000-00-00',
  `endon` date NOT NULL default '0000-00-00',
  `othercontactok` enum('0','1') NOT NULL default '0',
  `hits` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `verified` enum('0','1') NOT NULL default '0',
  `abused` int(10) unsigned NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `createdon` datetime NOT NULL default '0000-00-00 00:00:00',
  `expireson` datetime NOT NULL default '0000-00-00 00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`adid`),
  KEY `cityid` (`cityid`),
  KEY `verified` (`verified`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_featured`
-- 

CREATE TABLE `xzclf_featured` (
  `featadid` int(10) unsigned NOT NULL auto_increment,
  `adid` int(10) unsigned NOT NULL default '0',
  `adtype` char(1) NOT NULL default '',
  `featuredtill` datetime NOT NULL default '0000-00-00 00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`featadid`),
  UNIQUE KEY `adid` (`adid`,`adtype`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_imgcomments`
-- 

CREATE TABLE `xzclf_imgcomments` (
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `imgid` int(10) unsigned NOT NULL default '0',
  `postername` varchar(100) NOT NULL default '',
  `comment` text NOT NULL,
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`commentid`),
  KEY `imgid` (`imgid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_imgs`
-- 

CREATE TABLE `xzclf_imgs` (
  `imgid` int(10) unsigned NOT NULL auto_increment,
  `imgtitle` varchar(255) NOT NULL default '',
  `imgfilename` varchar(50) NOT NULL default '',
  `imgdesc` text NOT NULL,
  `postername` varchar(100) NOT NULL default '',
  `posteremail` varchar(100) NOT NULL default '',
  `showemail` enum('0','1','2') NOT NULL default '0',
  `password` varchar(100) NOT NULL default '',
  `code` varchar(35) NOT NULL default '',
  `cityid` smallint(5) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `verified` enum('0','1') NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `createdon` datetime NOT NULL default '0000-00-00 00:00:00',
  `expireson` datetime NOT NULL default '0000-00-00 00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`imgid`),
  KEY `verified` (`verified`),
  KEY `enabled` (`enabled`),
  KEY `cityid` (`cityid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_ipblock`
-- 

CREATE TABLE `xzclf_ipblock` (
  `ip` varchar(15) NOT NULL default '',
  `blocks` int(11) NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`ip`)
) TYPE=MyISAM;


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

-- 
-- Table structure for table `xzclf_ipns`
-- 

CREATE TABLE `xzclf_ipns` (
  `ipnid` int(10) unsigned NOT NULL auto_increment,
  `txnid` varchar(50) NOT NULL default '',
  `result` varchar(50) NOT NULL default '',
  `itemname` varchar(50) NOT NULL default '',
  `itemnumber` varchar(25) NOT NULL default '',
  `amount` decimal(5,2) NOT NULL default '0.00',
  `currency` varchar(10) NOT NULL default '',
  `payeremail` varchar(50) NOT NULL default '',
  `receiveremail` varchar(50) NOT NULL default '',
  `paymenttype` varchar(25) NOT NULL default '',
  `verified` varchar(25) NOT NULL default '',
  `status` varchar(25) NOT NULL default '',
  `pendingreason` varchar(25) NOT NULL default '',
  `fullipn` text NOT NULL,
  `receivedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`ipnid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_options_extended`
-- 

CREATE TABLE `xzclf_options_extended` (
  `eoptid` smallint(5) unsigned NOT NULL auto_increment,
  `days` smallint(5) unsigned NOT NULL default '0',
  `price` decimal(5,2) NOT NULL default '0.00',
  PRIMARY KEY  (`eoptid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_options_featured`
-- 

CREATE TABLE `xzclf_options_featured` (
  `foptid` tinyint(3) unsigned NOT NULL auto_increment,
  `days` smallint(5) unsigned NOT NULL default '0',
  `price` decimal(5,2) NOT NULL default '0.00',
  PRIMARY KEY  (`foptid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_payments`
-- 

CREATE TABLE `xzclf_payments` (
  `paymentid` int(10) unsigned NOT NULL auto_increment,
  `txnid` varchar(50) NOT NULL default '',
  `adid` int(10) unsigned NOT NULL default '0',
  `adtype` char(1) NOT NULL default '',
  `itemname` varchar(50) NOT NULL default '',
  `itemnumber` varchar(25) NOT NULL default '',
  `amount` decimal(5,2) NOT NULL default '0.00',
  `currency` varchar(10) NOT NULL default '',
  `payeremail` varchar(50) NOT NULL default '',
  `paymenttype` varchar(25) NOT NULL default '',
  `verified` varchar(25) NOT NULL default '',
  `status` varchar(25) NOT NULL default '',
  `pendingreason` varchar(25) NOT NULL default '',
  `fullipn` text NOT NULL,
  `receivedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`paymentid`),
  UNIQUE KEY `txnid` (`txnid`),
  KEY `adid` (`adid`),
  KEY `adtype` (`adtype`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_promos_extended`
-- 

CREATE TABLE `xzclf_promos_extended` (
  `epromoid` int(10) unsigned NOT NULL auto_increment,
  `adid` int(10) unsigned NOT NULL default '0',
  `adtype` char(1) NOT NULL default '',
  `days` smallint(5) unsigned NOT NULL default '0',
  `amountpaid` decimal(5,2) NOT NULL default '0.00',
  `paymentid` int(10) unsigned NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`epromoid`),
  KEY `adid` (`adid`),
  KEY `adtype` (`adtype`),
  KEY `paymentid` (`paymentid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_promos_featured`
-- 

CREATE TABLE `xzclf_promos_featured` (
  `fpromoid` int(10) unsigned NOT NULL auto_increment,
  `adid` int(10) unsigned NOT NULL default '0',
  `adtype` char(1) NOT NULL default '',
  `days` smallint(5) unsigned NOT NULL default '0',
  `amountpaid` decimal(5,2) NOT NULL default '0.00',
  `paymentid` int(10) unsigned NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`fpromoid`),
  KEY `adid` (`adid`),
  KEY `adtype` (`adtype`),
  KEY `paymentid` (`paymentid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `xzclf_subcats`
-- 

CREATE TABLE `xzclf_subcats` (
  `subcatid` smallint(5) unsigned NOT NULL auto_increment,
  `subcatname` varchar(50) NOT NULL default '',
  `catid` smallint(5) unsigned NOT NULL default '0',
  `hasprice` enum('0','1') NOT NULL default '0',
  `pricelabel` varchar(25) NOT NULL default '',
  `expireafter` smallint(5) unsigned NOT NULL default '100',
  `enabled` enum('0','1') NOT NULL default '0',
  `pos` smallint(5) unsigned NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`subcatid`),
  KEY `catid` (`catid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



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

-- 
-- Table structure for table `xzclf_subcatxfields`
-- 

CREATE TABLE `xzclf_subcatxfields` (
  `subcatid` smallint(5) unsigned NOT NULL default '0',
  `fieldnum` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `type` enum('N','S','D','U','E') NOT NULL default 'S',
  `vals` varchar(255) NOT NULL default '',
  `required` enum('0','1') NOT NULL default '0',
  `showinlist` enum('0','1') NOT NULL default '1',
  `searchable` enum('0','1') NOT NULL default '0',
  `timestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`subcatid`,`fieldnum`)
) TYPE=MyISAM;