# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : i_directorio

# --------------------------------------------------------
#
# Table structure for table 'familias'
#

CREATE TABLE familias (
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   familia tinytext NOT NULL,
   count int(11) DEFAULT '0' NOT NULL,
   UNIQUE id_2 (id)
);


# --------------------------------------------------------
#
# Table structure for table 'subfamilias'
#

CREATE TABLE subfamilias (
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   id_f int(11) DEFAULT '0' NOT NULL,
   subfamilia tinytext NOT NULL,
   count int(11) DEFAULT '0' NOT NULL,
   KEY id_f (id_f),
   UNIQUE id (id)
);


# --------------------------------------------------------
#
# Table structure for table 'urls'
#

CREATE TABLE urls (
   id_s tinyint(4) DEFAULT '0' NOT NULL,
   url tinytext NOT NULL,
   titulo tinytext NOT NULL,
   descripcion text NOT NULL,
   idioma tinytext NOT NULL,
   validado tinytext,
   recomendado tinyint(4) DEFAULT '0' NOT NULL,
   clicks bigint(20) DEFAULT '0' NOT NULL,
   incorporado tinytext NOT NULL,
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   KEY id_s (id_s),
   KEY id (id)
);