All pastes #557960 Raw Edit

Someone

public text v1 · immutable
·published 2007-06-11 05:41 UTC
rendered paste body
 CREATE TABLE `grupos_genteya` (
  `id_grupo` int(6) unsigned NOT NULL auto_increment,
  `id_fundador` int(6) unsigned NOT NULL,
  `activo` enum('0','1') NOT NULL default '0',
  `tiene_foto` enum('0','1') NOT NULL default '0',
  `tiene_foto_top` enum('0','1') NOT NULL default '0',
  `foto` enum('','gif','jpe','jpeg','jpg') default NULL,
  `foto_top` enum('','gif','jpe','jpeg','jpg') default NULL,
  `nombre_grupo` varchar(20) default NULL,
  `nick_grupo` varchar(20) NOT NULL,
  `descripcion` varchar(150) default NULL,
  `numero_usuarios` int(4) unsigned NOT NULL default '0',
  `veces_ganador` int(3) NOT NULL default '0',
  `puntos_semanales` int(6) unsigned NOT NULL default '0',
  `puntos_totales` int(6) unsigned NOT NULL default '0',
  `fecha_creacion` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_grupo`),
  UNIQUE KEY `nombre_grupo` (`nombre_grupo`),
  KEY `id_fundador` (`id_fundador`),
  KEY `activo` (`activo`,`puntos_semanales`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 


mysql> explain SELECT * FROM `grupos_genteya`  ORDER BY `id_grupo` DESC;
+----+-------------+----------------+------+---------------+------+---------+------+------+----------------+
| id | select_type | table          | type | possible_keys | key  | key_len | ref  | rows | Extra          |
+----+-------------+----------------+------+---------------+------+---------+------+------+----------------+
|  1 | SIMPLE      | grupos_genteya | ALL  | NULL          | NULL | NULL    | NULL |   19 | Using filesort |
+----+-------------+----------------+------+---------------+------+---------+------+------+----------------+
1 row in set (0.00 sec)