/*
SQLyog Community Edition- MySQL GUI v6.05
Host - 5.0.24a-community-nt-log : Database - clasificados
*********************************************************************
Server version : 5.0.24a-community-nt-log
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `clasificados`;

USE `clasificados`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `cod_admin` decimal(3,0) NOT NULL default '0',
  `usuario` varchar(10) NOT NULL default '',
  `clave` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`cod_admin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`cod_admin`,`usuario`,`clave`) values ('1','juan','apache'),('2','php','admin');

/*Table structure for table `articulo` */

DROP TABLE IF EXISTS `articulo`;

CREATE TABLE `articulo` (
  `cod_articulo` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `descripcion` varchar(150) NOT NULL,
  `fecha_manufactura` varchar(10) NOT NULL,
  `precio` decimal(10,0) NOT NULL,
  `cod_subcategoria` decimal(10,0) NOT NULL,
  `cod_vendedor` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`cod_articulo`),
  KEY `subcategoria` (`cod_subcategoria`),
  KEY `vendedor` (`cod_vendedor`),
  CONSTRAINT `FK_articulo` FOREIGN KEY (`cod_subcategoria`) REFERENCES `subcategoria` (`cod_subcategoria`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_articulo2` FOREIGN KEY (`cod_vendedor`) REFERENCES `vendedor` (`cod_vendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `articulo` */

insert  into `articulo`(`cod_articulo`,`nombre`,`descripcion`,`fecha_manufactura`,`precio`,`cod_subcategoria`,`cod_vendedor`) values ('1','solo','solito','2008','100','1002','10'),('2','Juan','Por por.','2009','1030','1001','12'),('3','Biblia','Holy Bible','2007','10000','1001','11'),('4','Phanton','televisor.','2004','12000','1001','13');

/*Table structure for table `articulos` */

DROP TABLE IF EXISTS `articulos`;

/*!50001 DROP VIEW IF EXISTS `articulos` */;
/*!50001 DROP TABLE IF EXISTS `articulos` */;

/*!50001 CREATE TABLE `articulos` (
  `cod` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `descripcion` varchar(150) NOT NULL,
  `fecha_manufactura` varchar(10) NOT NULL,
  `precio` decimal(10,0) NOT NULL,
  `cod_subcategoria` decimal(10,0) NOT NULL,
  `cod_vendedor` decimal(10,0) NOT NULL,
  `cod_categoria` decimal(10,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `categoria` */

DROP TABLE IF EXISTS `categoria`;

CREATE TABLE `categoria` (
  `cod_categoria` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `descripcion` varchar(100) NOT NULL,
  PRIMARY KEY  (`cod_categoria`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `categoria` */

insert  into `categoria`(`cod_categoria`,`nombre`,`descripcion`) values ('101','Electrodomesticos','Productos Tecnologicos Del Hogar.'),('102','aseo','pa limpiarse'),('103','ropa','pa ponerse'),('104','Libros','Super libros libres.'),('105','Confiteria','Dulces'),('106','Categoria Ejemplo','Ejemplo de ingreso de categorias a la base de datos'),('107','cate de goria','otra mas..');

/*Table structure for table `categorias` */

DROP TABLE IF EXISTS `categorias`;

/*!50001 DROP VIEW IF EXISTS `categorias` */;
/*!50001 DROP TABLE IF EXISTS `categorias` */;

/*!50001 CREATE TABLE `categorias` (
  `cod_categoria` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `descripcion` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `correo` */

DROP TABLE IF EXISTS `correo`;

CREATE TABLE `correo` (
  `cod_correo` decimal(10,0) NOT NULL,
  `correo` varchar(30) NOT NULL,
  `cod_vendedor` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`cod_correo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `correo` */

insert  into `correo`(`cod_correo`,`correo`,`cod_vendedor`) values ('101','cristo@heaven.com','11'),('102','juancarlos.apache@gmail.com','12'),('103','heaven@heaven.net','10'),('104','zayda@gmail.com','20'),('105','zayda@gmail.com','21');

/*Table structure for table `correos` */

DROP TABLE IF EXISTS `correos`;

/*!50001 DROP VIEW IF EXISTS `correos` */;
/*!50001 DROP TABLE IF EXISTS `correos` */;

/*!50001 CREATE TABLE `correos` (
  `cod_correo` decimal(10,0) NOT NULL,
  `correo` varchar(30) NOT NULL,
  `cod_vendedor` decimal(10,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodarticulo` */

DROP TABLE IF EXISTS `maxcodarticulo`;

/*!50001 DROP VIEW IF EXISTS `maxcodarticulo` */;
/*!50001 DROP TABLE IF EXISTS `maxcodarticulo` */;

/*!50001 CREATE TABLE `maxcodarticulo` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodcategoria` */

DROP TABLE IF EXISTS `maxcodcategoria`;

/*!50001 DROP VIEW IF EXISTS `maxcodcategoria` */;
/*!50001 DROP TABLE IF EXISTS `maxcodcategoria` */;

/*!50001 CREATE TABLE `maxcodcategoria` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodcorreo` */

DROP TABLE IF EXISTS `maxcodcorreo`;

/*!50001 DROP VIEW IF EXISTS `maxcodcorreo` */;
/*!50001 DROP TABLE IF EXISTS `maxcodcorreo` */;

/*!50001 CREATE TABLE `maxcodcorreo` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodsubcategoria` */

DROP TABLE IF EXISTS `maxcodsubcategoria`;

/*!50001 DROP VIEW IF EXISTS `maxcodsubcategoria` */;
/*!50001 DROP TABLE IF EXISTS `maxcodsubcategoria` */;

/*!50001 CREATE TABLE `maxcodsubcategoria` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodtelefono` */

DROP TABLE IF EXISTS `maxcodtelefono`;

/*!50001 DROP VIEW IF EXISTS `maxcodtelefono` */;
/*!50001 DROP TABLE IF EXISTS `maxcodtelefono` */;

/*!50001 CREATE TABLE `maxcodtelefono` (
  `codtelefono` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodvendedor` */

DROP TABLE IF EXISTS `maxcodvendedor`;

/*!50001 DROP VIEW IF EXISTS `maxcodvendedor` */;
/*!50001 DROP TABLE IF EXISTS `maxcodvendedor` */;

/*!50001 CREATE TABLE `maxcodvendedor` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `phpbb_auth_access` */

DROP TABLE IF EXISTS `phpbb_auth_access`;

CREATE TABLE `phpbb_auth_access` (
  `group_id` mediumint(8) NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '0',
  `auth_read` tinyint(1) NOT NULL default '0',
  `auth_post` tinyint(1) NOT NULL default '0',
  `auth_reply` tinyint(1) NOT NULL default '0',
  `auth_edit` tinyint(1) NOT NULL default '0',
  `auth_delete` tinyint(1) NOT NULL default '0',
  `auth_sticky` tinyint(1) NOT NULL default '0',
  `auth_announce` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_pollcreate` tinyint(1) NOT NULL default '0',
  `auth_attachments` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_auth_access` */

/*Table structure for table `phpbb_banlist` */

DROP TABLE IF EXISTS `phpbb_banlist`;

CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL,
  `ban_ip` char(8) NOT NULL,
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_banlist` */

/*Table structure for table `phpbb_categories` */

DROP TABLE IF EXISTS `phpbb_categories`;

CREATE TABLE `phpbb_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_categories` */

insert  into `phpbb_categories`(`cat_id`,`cat_title`,`cat_order`) values (2,'Derecho',20),(3,'Contaduría',30);

/*Table structure for table `phpbb_config` */

DROP TABLE IF EXISTS `phpbb_config`;

CREATE TABLE `phpbb_config` (
  `config_name` varchar(255) NOT NULL,
  `config_value` varchar(255) NOT NULL,
  PRIMARY KEY  (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_config` */

insert  into `phpbb_config`(`config_name`,`config_value`) values ('config_id','1'),('board_disable','0'),('sitename','yourdomain.com'),('site_desc','A _little_ text to describe your forum'),('cookie_name','phpbb2mysql'),('cookie_path','/'),('cookie_domain',''),('cookie_secure','0'),('session_length','3600'),('allow_html','0'),('allow_html_tags','b,i,u,pre'),('allow_bbcode','1'),('allow_smilies','1'),('allow_sig','1'),('allow_namechange','0'),('allow_theme_create','0'),('allow_avatar_local','0'),('allow_avatar_remote','0'),('allow_avatar_upload','0'),('enable_confirm','1'),('allow_autologin','1'),('max_autologin_time','0'),('override_user_style','1'),('posts_per_page','15'),('topics_per_page','50'),('hot_threshold','25'),('max_poll_options','10'),('max_sig_chars','255'),('max_inbox_privmsgs','50'),('max_sentbox_privmsgs','25'),('max_savebox_privmsgs','50'),('board_email_sig','Thanks, The Management'),('board_email','ssssss'),('smtp_delivery','0'),('smtp_host',''),('smtp_username',''),('smtp_password',''),('sendmail_fix','0'),('require_activation','0'),('flood_interval','15'),('search_flood_interval','15'),('search_min_chars','3'),('max_login_attempts','5'),('login_reset_time','30'),('board_email_form','0'),('avatar_filesize','6144'),('avatar_max_width','80'),('avatar_max_height','80'),('avatar_path','images/avatars'),('avatar_gallery_path','images/avatars/gallery'),('smilies_path','images/smiles'),('default_style','3'),('default_dateformat','D M d, Y g:i a'),('board_timezone','0'),('prune_enable','1'),('privmsg_disable','0'),('gzip_compress','0'),('coppa_fax',''),('coppa_mail',''),('record_online_users','1'),('record_online_date','1169907249'),('server_name','localhost'),('server_port','80'),('script_path','/libre/phpBB2/'),('version','.0.21'),('rand_seed','1b74658dbe070a447394b85080e48e12'),('board_startdate','1169907060'),('default_lang','spanish');

/*Table structure for table `phpbb_confirm` */

DROP TABLE IF EXISTS `phpbb_confirm`;

CREATE TABLE `phpbb_confirm` (
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_confirm` */

/*Table structure for table `phpbb_disallow` */

DROP TABLE IF EXISTS `phpbb_disallow`;

CREATE TABLE `phpbb_disallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
  `disallow_username` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`disallow_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_disallow` */

/*Table structure for table `phpbb_forum_prune` */

DROP TABLE IF EXISTS `phpbb_forum_prune`;

CREATE TABLE `phpbb_forum_prune` (
  `prune_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(5) unsigned NOT NULL,
  `prune_days` smallint(5) unsigned NOT NULL,
  `prune_freq` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`prune_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_forum_prune` */

insert  into `phpbb_forum_prune`(`prune_id`,`forum_id`,`prune_days`,`prune_freq`) values (1,2,7,1),(2,3,7,1);

/*Table structure for table `phpbb_forums` */

DROP TABLE IF EXISTS `phpbb_forums`;

CREATE TABLE `phpbb_forums` (
  `forum_id` smallint(5) unsigned NOT NULL,
  `cat_id` mediumint(8) unsigned NOT NULL,
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_forums` */

insert  into `phpbb_forums`(`forum_id`,`cat_id`,`forum_name`,`forum_desc`,`forum_status`,`forum_order`,`forum_posts`,`forum_topics`,`forum_last_post_id`,`prune_next`,`prune_enable`,`auth_view`,`auth_read`,`auth_post`,`auth_reply`,`auth_edit`,`auth_delete`,`auth_sticky`,`auth_announce`,`auth_vote`,`auth_pollcreate`,`auth_attachments`) values (2,2,'Consultorio jurídico','En este foro se van a tratar temas importantes del consultorio jurídico.',0,10,0,0,0,NULL,1,0,0,1,1,1,1,3,3,1,1,0),(3,3,'Consultorio empresarial','En este foro se van a tratar temas importantes del consultorio empresarial.',0,10,0,0,0,NULL,1,0,0,1,1,1,1,3,3,1,1,0);

/*Table structure for table `phpbb_groups` */

DROP TABLE IF EXISTS `phpbb_groups`;

CREATE TABLE `phpbb_groups` (
  `group_id` mediumint(8) NOT NULL auto_increment,
  `group_type` tinyint(4) NOT NULL default '1',
  `group_name` varchar(40) NOT NULL,
  `group_description` varchar(255) NOT NULL,
  `group_moderator` mediumint(8) NOT NULL default '0',
  `group_single_user` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`),
  KEY `group_single_user` (`group_single_user`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_groups` */

insert  into `phpbb_groups`(`group_id`,`group_type`,`group_name`,`group_description`,`group_moderator`,`group_single_user`) values (1,1,'Anonymous','Personal User',0,1),(2,1,'Admin','Personal User',0,1);

/*Table structure for table `phpbb_posts` */

DROP TABLE IF EXISTS `phpbb_posts`;

CREATE TABLE `phpbb_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` char(8) NOT NULL,
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_posts` */

/*Table structure for table `phpbb_posts_text` */

DROP TABLE IF EXISTS `phpbb_posts_text`;

CREATE TABLE `phpbb_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` char(10) NOT NULL default '',
  `post_subject` char(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_posts_text` */

/*Table structure for table `phpbb_privmsgs` */

DROP TABLE IF EXISTS `phpbb_privmsgs`;

CREATE TABLE `phpbb_privmsgs` (
  `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
  `privmsgs_type` tinyint(4) NOT NULL default '0',
  `privmsgs_subject` varchar(255) NOT NULL default '0',
  `privmsgs_from_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_to_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_date` int(11) NOT NULL default '0',
  `privmsgs_ip` char(8) NOT NULL,
  `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
  `privmsgs_enable_html` tinyint(1) NOT NULL default '0',
  `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
  `privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`privmsgs_id`),
  KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
  KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_privmsgs` */

/*Table structure for table `phpbb_privmsgs_text` */

DROP TABLE IF EXISTS `phpbb_privmsgs_text`;

CREATE TABLE `phpbb_privmsgs_text` (
  `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
  `privmsgs_bbcode_uid` char(10) NOT NULL default '0',
  `privmsgs_text` text,
  PRIMARY KEY  (`privmsgs_text_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_privmsgs_text` */

/*Table structure for table `phpbb_ranks` */

DROP TABLE IF EXISTS `phpbb_ranks`;

CREATE TABLE `phpbb_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL,
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_ranks` */

insert  into `phpbb_ranks`(`rank_id`,`rank_title`,`rank_min`,`rank_special`,`rank_image`) values (1,'Site Admin',-1,1,NULL);

/*Table structure for table `phpbb_search_results` */

DROP TABLE IF EXISTS `phpbb_search_results`;

CREATE TABLE `phpbb_search_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` char(32) NOT NULL default '',
  `search_time` int(11) NOT NULL default '0',
  `search_array` text NOT NULL,
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_search_results` */

/*Table structure for table `phpbb_search_wordlist` */

DROP TABLE IF EXISTS `phpbb_search_wordlist`;

CREATE TABLE `phpbb_search_wordlist` (
  `word_text` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_search_wordlist` */

insert  into `phpbb_search_wordlist`(`word_text`,`word_id`,`word_common`) values ('phpbb',3,0);

/*Table structure for table `phpbb_search_wordmatch` */

DROP TABLE IF EXISTS `phpbb_search_wordmatch`;

CREATE TABLE `phpbb_search_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `word_id` (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_search_wordmatch` */

/*Table structure for table `phpbb_sessions` */

DROP TABLE IF EXISTS `phpbb_sessions`;

CREATE TABLE `phpbb_sessions` (
  `session_id` char(32) NOT NULL default '',
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_ip` char(8) NOT NULL default '0',
  `session_page` int(11) NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  `session_admin` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_sessions` */

insert  into `phpbb_sessions`(`session_id`,`session_user_id`,`session_start`,`session_time`,`session_ip`,`session_page`,`session_logged_in`,`session_admin`) values ('8bd3e7912d1e48bda433c99af1fdfcf1',2,1169907166,1169907768,'7f000001',0,1,1);

/*Table structure for table `phpbb_sessions_keys` */

DROP TABLE IF EXISTS `phpbb_sessions_keys`;

CREATE TABLE `phpbb_sessions_keys` (
  `key_id` varchar(32) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `last_ip` varchar(8) NOT NULL default '0',
  `last_login` int(11) NOT NULL default '0',
  PRIMARY KEY  (`key_id`,`user_id`),
  KEY `last_login` (`last_login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_sessions_keys` */

/*Table structure for table `phpbb_smilies` */

DROP TABLE IF EXISTS `phpbb_smilies`;

CREATE TABLE `phpbb_smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_smilies` */

insert  into `phpbb_smilies`(`smilies_id`,`code`,`smile_url`,`emoticon`) values (1,':D','icon_biggrin.gif','Very Happy'),(2,':-D','icon_biggrin.gif','Very Happy'),(3,':grin:','icon_biggrin.gif','Very Happy'),(4,':)','icon_smile.gif','Smile'),(5,':-)','icon_smile.gif','Smile'),(6,':smile:','icon_smile.gif','Smile'),(7,':(','icon_sad.gif','Sad'),(8,':-(','icon_sad.gif','Sad'),(9,':sad:','icon_sad.gif','Sad'),(10,':o','icon_surprised.gif','Surprised'),(11,':-o','icon_surprised.gif','Surprised'),(12,':eek:','icon_surprised.gif','Surprised'),(13,':shock:','icon_eek.gif','Shocked'),(14,':?','icon_confused.gif','Confused'),(15,':-?','icon_confused.gif','Confused'),(16,':???:','icon_confused.gif','Confused'),(17,'8)','icon_cool.gif','Cool'),(18,'8-)','icon_cool.gif','Cool'),(19,':cool:','icon_cool.gif','Cool'),(20,':lol:','icon_lol.gif','Laughing'),(21,':x','icon_mad.gif','Mad'),(22,':-x','icon_mad.gif','Mad'),(23,':mad:','icon_mad.gif','Mad'),(24,':P','icon_razz.gif','Razz'),(25,':-P','icon_razz.gif','Razz'),(26,':razz:','icon_razz.gif','Razz'),(27,':oops:','icon_redface.gif','Embarassed'),(28,':cry:','icon_cry.gif','Crying or Very sad'),(29,':evil:','icon_evil.gif','Evil or Very Mad'),(30,':twisted:','icon_twisted.gif','Twisted Evil'),(31,':roll:','icon_rolleyes.gif','Rolling Eyes'),(32,':wink:','icon_wink.gif','Wink'),(33,';)','icon_wink.gif','Wink'),(34,';-)','icon_wink.gif','Wink'),(35,':!:','icon_exclaim.gif','Exclamation'),(36,':?:','icon_question.gif','Question'),(37,':idea:','icon_idea.gif','Idea'),(38,':arrow:','icon_arrow.gif','Arrow'),(39,':|','icon_neutral.gif','Neutral'),(40,':-|','icon_neutral.gif','Neutral'),(41,':neutral:','icon_neutral.gif','Neutral'),(42,':mrgreen:','icon_mrgreen.gif','Mr. Green');

/*Table structure for table `phpbb_themes` */

DROP TABLE IF EXISTS `phpbb_themes`;

CREATE TABLE `phpbb_themes` (
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_themes` */

insert  into `phpbb_themes`(`themes_id`,`template_name`,`style_name`,`head_stylesheet`,`body_background`,`body_bgcolor`,`body_text`,`body_link`,`body_vlink`,`body_alink`,`body_hlink`,`tr_color1`,`tr_color2`,`tr_color3`,`tr_class1`,`tr_class2`,`tr_class3`,`th_color1`,`th_color2`,`th_color3`,`th_class1`,`th_class2`,`th_class3`,`td_color1`,`td_color2`,`td_color3`,`td_class1`,`td_class2`,`td_class3`,`fontface1`,`fontface2`,`fontface3`,`fontsize1`,`fontsize2`,`fontsize3`,`fontcolor1`,`fontcolor2`,`fontcolor3`,`span_class1`,`span_class2`,`span_class3`,`img_size_poll`,`img_size_privmsg`) values (1,'subSilver','subSilver','subSilver.css','','E5E5E5','000000','006699','5493B4','','DD6900','EFEFEF','DEE3E7','D1D7DC','','','','98AAB1','006699','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, \'Courier New\', sans-serif',10,11,12,'444444','006600','FFA34F','','','',NULL,NULL),(2,'RedSilver','RedSilver','RedSilver.css','','DED8C8','000000','646464','646464','','DD6900','F2F0E9','F2F0E9','F2F0E9','','','','98AAB1','8B0202','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, \'Courier New\', sans-serif',10,11,12,'444444','006600','F38918','','','',0,0),(3,'RedSilver_C','RedSilver_C','RedSilver_C.css','','DED8C8','000000','646464','646464','','DD6900','F2F0E9','F2F0E9','F2F0E9','','','','98AAB1','B50808','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, \'Courier New\', sans-serif',10,11,12,'444444','006600','F38918','','','',0,0);

/*Table structure for table `phpbb_themes_name` */

DROP TABLE IF EXISTS `phpbb_themes_name`;

CREATE TABLE `phpbb_themes_name` (
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_themes_name` */

insert  into `phpbb_themes_name`(`themes_id`,`tr_color1_name`,`tr_color2_name`,`tr_color3_name`,`tr_class1_name`,`tr_class2_name`,`tr_class3_name`,`th_color1_name`,`th_color2_name`,`th_color3_name`,`th_class1_name`,`th_class2_name`,`th_class3_name`,`td_color1_name`,`td_color2_name`,`td_color3_name`,`td_class1_name`,`td_class2_name`,`td_class3_name`,`fontface1_name`,`fontface2_name`,`fontface3_name`,`fontsize1_name`,`fontsize2_name`,`fontsize3_name`,`fontcolor1_name`,`fontcolor2_name`,`fontcolor3_name`,`span_class1_name`,`span_class2_name`,`span_class3_name`) values (1,'The lightest row colour','The medium row color','The darkest row colour','','','','Border round the whole page','Outer table border','Inner table border','Silver gradient picture','Blue gradient picture','Fade-out gradient on index','Background for quote boxes','All white areas','','Background for topic posts','2nd background for topic posts','','Main fonts','Additional topic title font','Form fonts','Smallest font size','Medium font size','Normal font size (post body etc)','Quote & copyright text','Code text colour','Main table header text colour','','','');

/*Table structure for table `phpbb_topics` */

DROP TABLE IF EXISTS `phpbb_topics`;

CREATE TABLE `phpbb_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) NOT NULL,
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_topics` */

/*Table structure for table `phpbb_topics_watch` */

DROP TABLE IF EXISTS `phpbb_topics_watch`;

CREATE TABLE `phpbb_topics_watch` (
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `notify_status` tinyint(1) NOT NULL default '0',
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_status` (`notify_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_topics_watch` */

/*Table structure for table `phpbb_user_group` */

DROP TABLE IF EXISTS `phpbb_user_group`;

CREATE TABLE `phpbb_user_group` (
  `group_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_pending` tinyint(1) default NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_user_group` */

insert  into `phpbb_user_group`(`group_id`,`user_id`,`user_pending`) values (1,-1,0),(2,2,0);

/*Table structure for table `phpbb_users` */

DROP TABLE IF EXISTS `phpbb_users`;

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL,
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL,
  `user_password` varchar(32) NOT NULL,
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_login_tries` smallint(5) unsigned NOT NULL default '0',
  `user_last_login_try` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` char(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_users` */

insert  into `phpbb_users`(`user_id`,`user_active`,`username`,`user_password`,`user_session_time`,`user_session_page`,`user_lastvisit`,`user_regdate`,`user_level`,`user_posts`,`user_timezone`,`user_style`,`user_lang`,`user_dateformat`,`user_new_privmsg`,`user_unread_privmsg`,`user_last_privmsg`,`user_login_tries`,`user_last_login_try`,`user_emailtime`,`user_viewemail`,`user_attachsig`,`user_allowhtml`,`user_allowbbcode`,`user_allowsmile`,`user_allowavatar`,`user_allow_pm`,`user_allow_viewonline`,`user_notify`,`user_notify_pm`,`user_popup_pm`,`user_rank`,`user_avatar`,`user_avatar_type`,`user_email`,`user_icq`,`user_website`,`user_from`,`user_sig`,`user_sig_bbcode_uid`,`user_aim`,`user_yim`,`user_msnm`,`user_occ`,`user_interests`,`user_actkey`,`user_newpasswd`) values (-1,0,'Anonymous','',0,0,0,1169907060,0,0,'0.00',NULL,'','',0,0,0,0,0,NULL,0,0,1,1,1,1,0,1,0,1,0,NULL,'',0,'','','','','',NULL,'','','','','','',''),(2,1,'Administrador','21232f297a57a5a743894a0e4a801fc3',1169907768,0,1169907165,1169907060,1,1,'0.00',1,'spanish','d M Y h:i a',0,0,0,0,0,NULL,1,0,0,1,1,1,1,1,0,1,1,1,'',0,'ssssss','','','','',NULL,'','','','','','','');

/*Table structure for table `phpbb_vote_desc` */

DROP TABLE IF EXISTS `phpbb_vote_desc`;

CREATE TABLE `phpbb_vote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_vote_desc` */

/*Table structure for table `phpbb_vote_results` */

DROP TABLE IF EXISTS `phpbb_vote_results`;

CREATE TABLE `phpbb_vote_results` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL,
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_vote_results` */

/*Table structure for table `phpbb_vote_voters` */

DROP TABLE IF EXISTS `phpbb_vote_voters`;

CREATE TABLE `phpbb_vote_voters` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL,
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_vote_voters` */

/*Table structure for table `phpbb_words` */

DROP TABLE IF EXISTS `phpbb_words`;

CREATE TABLE `phpbb_words` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL,
  `replacement` char(100) NOT NULL,
  PRIMARY KEY  (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phpbb_words` */

/*Table structure for table `sessions` */

DROP TABLE IF EXISTS `sessions`;

CREATE TABLE `sessions` (
  `session_id` varchar(100) NOT NULL default '',
  `session_data` text NOT NULL,
  `expires` int(11) NOT NULL default '0',
  `ip` varchar(12) NOT NULL,
  PRIMARY KEY  (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `sessions` */

/*Table structure for table `subcategoria` */

DROP TABLE IF EXISTS `subcategoria`;

CREATE TABLE `subcategoria` (
  `cod_subcategoria` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `descripcion` varchar(100) NOT NULL,
  `cod_categoria` decimal(10,0) NOT NULL,
  `cod_perte_subcate` decimal(10,0) default NULL,
  PRIMARY KEY  (`cod_subcategoria`),
  KEY `cod_categoria` (`cod_categoria`),
  KEY `perte_subcate` (`cod_perte_subcate`),
  CONSTRAINT `FK_pertesubcategoria` FOREIGN KEY (`cod_perte_subcate`) REFERENCES `subcategoria` (`cod_subcategoria`),
  CONSTRAINT `FK_subcategoria` FOREIGN KEY (`cod_categoria`) REFERENCES `categoria` (`cod_categoria`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `subcategoria` */

insert  into `subcategoria`(`cod_subcategoria`,`nombre`,`descripcion`,`cod_categoria`,`cod_perte_subcate`) values ('1001','Televisores','Pa ver TV','101',NULL),('1002','televisores LCD','pa ver mas bonito','101','1001'),('1003','jeans','pa ponerse rapido','103',NULL),('1004','Maquina de Afeitar','Maquina de Afeitar el vello facial.','102',NULL),('1005','Hackeado','los hackers','101',NULL),('1006','sub de cate','otra ca te','101',NULL);

/*Table structure for table `subcategorias` */

DROP TABLE IF EXISTS `subcategorias`;

/*!50001 DROP VIEW IF EXISTS `subcategorias` */;
/*!50001 DROP TABLE IF EXISTS `subcategorias` */;

/*!50001 CREATE TABLE `subcategorias` (
  `cod_subcategoria` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `descripcion` varchar(100) NOT NULL,
  `cod_categoria` decimal(10,0) NOT NULL,
  `cod_perte_subcate` decimal(10,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `telefono` */

DROP TABLE IF EXISTS `telefono`;

CREATE TABLE `telefono` (
  `cod_telefono` decimal(10,0) NOT NULL,
  `telefono` varchar(12) NOT NULL,
  `cod_vendedor` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`cod_telefono`),
  KEY `vendedor` (`cod_vendedor`),
  CONSTRAINT `FK_telefonos` FOREIGN KEY (`cod_vendedor`) REFERENCES `vendedor` (`cod_vendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `telefono` */

insert  into `telefono`(`cod_telefono`,`telefono`,`cod_vendedor`) values ('11','3157255657','11'),('12','5781917','12'),('13','0975753763','10'),('14','5846371','14'),('15','5781917','15'),('16','56238596','16'),('17','5846371','17'),('18','5783093','18'),('19','5783093','19'),('20','5783093','20'),('21','5783093','21');

/*Table structure for table `telefonos` */

DROP TABLE IF EXISTS `telefonos`;

/*!50001 DROP VIEW IF EXISTS `telefonos` */;
/*!50001 DROP TABLE IF EXISTS `telefonos` */;

/*!50001 CREATE TABLE `telefonos` (
  `cod_telefono` decimal(10,0) NOT NULL,
  `telefono` varchar(12) NOT NULL,
  `cod_vendedor` decimal(10,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `vendedor` */

DROP TABLE IF EXISTS `vendedor`;

CREATE TABLE `vendedor` (
  `cod_vendedor` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `apellidos` varchar(30) NOT NULL,
  `sexo` char(1) NOT NULL,
  `fecha_nacimiento` date NOT NULL,
  `cedula` decimal(12,0) NOT NULL,
  `clave` varchar(8) NOT NULL,
  PRIMARY KEY  (`cod_vendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `vendedor` */

insert  into `vendedor`(`cod_vendedor`,`nombre`,`apellidos`,`sexo`,`fecha_nacimiento`,`cedula`,`clave`) values ('10','Jesus','Santo','m','2007-08-25','88270','santo'),('11','Jesus','Cristo','H','2007-09-07','88270','cielo'),('12','Juan Carlos','Leon Jimenez','H','1982-11-16','88270418','myson'),('13','Yolima Del Pilar','Jiménez Carrillo','M','1984-03-06','37394816','22051906'),('14','Yolima','Jimenez','H','0000-00-00','3274252','yoli'),('15','Juan Carlos','Leon','H','0000-00-00','8827','leon'),('16','juan','leon','H','0000-00-00','764','jj'),('17','martha','jarta','H','0000-00-00','567','mm'),('18','fabian','Lizcano','H','1980-11-25','8867','rere'),('19','Zayda','Lizcano','H','2007-12-23','8879','za'),('20','Zayda','Lizcano','H','2007-12-23','8879','za'),('21','Zayda','Lizcano','H','2007-12-23','8879','za');

/*Table structure for table `vendedores` */

DROP TABLE IF EXISTS `vendedores`;

/*!50001 DROP VIEW IF EXISTS `vendedores` */;
/*!50001 DROP TABLE IF EXISTS `vendedores` */;

/*!50001 CREATE TABLE `vendedores` (
  `cod` decimal(10,0) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `apellidos` varchar(30) NOT NULL,
  `cedula` decimal(12,0) NOT NULL,
  `fecha` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*View structure for view articulos */

/*!50001 DROP TABLE IF EXISTS `articulos` */;
/*!50001 DROP VIEW IF EXISTS `articulos` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `articulos` AS (select `a`.`cod_articulo` AS `cod`,`a`.`nombre` AS `nombre`,`a`.`descripcion` AS `descripcion`,`a`.`fecha_manufactura` AS `fecha_manufactura`,`a`.`precio` AS `precio`,`a`.`cod_subcategoria` AS `cod_subcategoria`,`a`.`cod_vendedor` AS `cod_vendedor`,`s`.`cod_categoria` AS `cod_categoria` from (`articulo` `a` join `subcategoria` `s`) where (`a`.`cod_subcategoria` = `s`.`cod_subcategoria`)) */;

/*View structure for view categorias */

/*!50001 DROP TABLE IF EXISTS `categorias` */;
/*!50001 DROP VIEW IF EXISTS `categorias` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `categorias` AS (select `categoria`.`cod_categoria` AS `cod_categoria`,`categoria`.`nombre` AS `nombre`,`categoria`.`descripcion` AS `descripcion` from `categoria`) */;

/*View structure for view correos */

/*!50001 DROP TABLE IF EXISTS `correos` */;
/*!50001 DROP VIEW IF EXISTS `correos` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `correos` AS (select `correo`.`cod_correo` AS `cod_correo`,`correo`.`correo` AS `correo`,`correo`.`cod_vendedor` AS `cod_vendedor` from `correo`) */;

/*View structure for view maxcodarticulo */

/*!50001 DROP TABLE IF EXISTS `maxcodarticulo` */;
/*!50001 DROP VIEW IF EXISTS `maxcodarticulo` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodarticulo` AS (select max((`articulo`.`cod_articulo` + 1)) AS `cod` from `articulo`) */;

/*View structure for view maxcodcategoria */

/*!50001 DROP TABLE IF EXISTS `maxcodcategoria` */;
/*!50001 DROP VIEW IF EXISTS `maxcodcategoria` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodcategoria` AS (select max((`categoria`.`cod_categoria` + 1)) AS `cod` from `categoria`) */;

/*View structure for view maxcodcorreo */

/*!50001 DROP TABLE IF EXISTS `maxcodcorreo` */;
/*!50001 DROP VIEW IF EXISTS `maxcodcorreo` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodcorreo` AS (select max((`correo`.`cod_correo` + 1)) AS `cod` from `correo`) */;

/*View structure for view maxcodsubcategoria */

/*!50001 DROP TABLE IF EXISTS `maxcodsubcategoria` */;
/*!50001 DROP VIEW IF EXISTS `maxcodsubcategoria` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodsubcategoria` AS (select max((`subcategoria`.`cod_subcategoria` + 1)) AS `cod` from `subcategoria`) */;

/*View structure for view maxcodtelefono */

/*!50001 DROP TABLE IF EXISTS `maxcodtelefono` */;
/*!50001 DROP VIEW IF EXISTS `maxcodtelefono` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodtelefono` AS (select max((`telefono`.`cod_telefono` + 1)) AS `codtelefono` from `telefono`) */;

/*View structure for view maxcodvendedor */

/*!50001 DROP TABLE IF EXISTS `maxcodvendedor` */;
/*!50001 DROP VIEW IF EXISTS `maxcodvendedor` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodvendedor` AS (select max((`vendedor`.`cod_vendedor` + 1)) AS `cod` from `vendedor`) */;

/*View structure for view subcategorias */

/*!50001 DROP TABLE IF EXISTS `subcategorias` */;
/*!50001 DROP VIEW IF EXISTS `subcategorias` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `subcategorias` AS (select `subcategoria`.`cod_subcategoria` AS `cod_subcategoria`,`subcategoria`.`nombre` AS `nombre`,`subcategoria`.`descripcion` AS `descripcion`,`subcategoria`.`cod_categoria` AS `cod_categoria`,`subcategoria`.`cod_perte_subcate` AS `cod_perte_subcate` from `subcategoria`) */;

/*View structure for view telefonos */

/*!50001 DROP TABLE IF EXISTS `telefonos` */;
/*!50001 DROP VIEW IF EXISTS `telefonos` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `telefonos` AS (select `telefono`.`cod_telefono` AS `cod_telefono`,`telefono`.`telefono` AS `telefono`,`telefono`.`cod_vendedor` AS `cod_vendedor` from `telefono`) */;

/*View structure for view vendedores */

/*!50001 DROP TABLE IF EXISTS `vendedores` */;
/*!50001 DROP VIEW IF EXISTS `vendedores` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vendedores` AS (select `vendedor`.`cod_vendedor` AS `cod`,`vendedor`.`nombre` AS `nombre`,`vendedor`.`apellidos` AS `apellidos`,`vendedor`.`cedula` AS `cedula`,`vendedor`.`fecha_nacimiento` AS `fecha` from `vendedor`) */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;