-- phpMyAdmin SQL Dump
-- version 2.11.9.4
--
http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 04-11-2009 a las 08:57:23
-- Versión del servidor: 4.1.22
-- Versión de PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de datos: `av1sos`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `avisos_ad`
--
CREATE TABLE IF NOT EXISTS `phpclass_ad` (
`ad_id` int(11) NOT NULL auto_increment,
`ad_owner` int(11) default '0',
`ad_cat_id` int(11) default '0',
`ad_title` varchar(255) collate utf8_unicode_ci default '0',
`ad_description` text collate utf8_unicode_ci,
`ad_date` int(11) default '0',
`ad_date_expire` int(11) default '0',
`ad_date_updated` int(11) default '0',
`ad_expires_after_days` int(11) default '0',
`ad_owner_notified` tinyint(1) default '0',
`ad_has_video` tinyint(1) default '0',
`ad_has_picture` tinyint(1) default '0',
`ad_has_doc` int(11) default '0',
`ad_views` int(11) default '0',
`ad_votes` double(6,2) default '0.00',
`ad_voters` int(11) default '0',
`ad_totalscore` double(6,2) default '0.00',
`ad_last_vote_ip` varchar(20) collate utf8_unicode_ci default '0',
`ad_is_validated` tinyint(1) default '0',
`ad_is_sold` tinyint(1) default '0',
`ad_is_special` tinyint(1) default '0',
`ad_is_premium` tinyint(1) default '0',
`ad_region` int(11) default '0',
PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;