Tema: Problema con INNER JOIN
Ver Mensaje Individual
  #24 (permalink)  
Antiguo 30/05/2013, 03:01
dankko
Invitado
  
Mensajes: n/a
Puntos:
Respuesta: Problema con INNER JOIN
Okey.


Volcado

torneos_partidos:

Código SQL: 
Ver original
  1. CREATE TABLE `torneos_partidos` (
  2.  `id_partido` INT(7) NOT NULL AUTO_INCREMENT,
  3.  `id_torneo` INT(7) NOT NULL,
  4.  `id_ronda` INT(7) NOT NULL,
  5.  `user_id_1` INT(7) NOT NULL,
  6.  `user_id_2` INT(7) NOT NULL,
  7.  `partido_jugado` VARCHAR(250) NOT NULL DEFAULT 'NO',
  8.  `ganador` INT(4) NOT NULL DEFAULT '0',
  9.  PRIMARY KEY (`id_partido`)
  10. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

usuarios:

Código SQL: 
Ver original
  1. CREATE TABLE `foro_users` (
  2.  `user_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.  `user_type` tinyint(2) NOT NULL DEFAULT '0',
  4.  `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '3',
  5.  `user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
  6.  `user_perm_from` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  7.  `user_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  8.  `user_regdate` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  9.  `username` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  10.  `username_clean` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  11.  `name1` VARCHAR(35) COLLATE utf8_bin NOT NULL,
  12.  `name2` VARCHAR(35) COLLATE utf8_bin NOT NULL,
  13.  `team_id` INT(7) NOT NULL,
  14.  `twitter_user` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  15.  `user_password` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  16.  `user_passchg` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  17.  `user_pass_convert` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  18.  `user_email` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  19.  `user_email_hash` BIGINT(20) NOT NULL DEFAULT '0',
  20.  `user_birthday` VARCHAR(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  21.  `user_lastvisit` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  22.  `user_lastmark` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  23.  `user_lastpost_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  24.  `user_lastpage` VARCHAR(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  25.  `user_last_confirm_key` VARCHAR(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  26.  `user_last_search` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  27.  `user_warnings` tinyint(4) NOT NULL DEFAULT '0',
  28.  `user_last_warning` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  29.  `user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
  30.  `user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
  31.  `user_inactive_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  32.  `user_posts` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  33.  `user_lang` VARCHAR(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  34.  `user_timezone` DECIMAL(5,2) NOT NULL DEFAULT '0.00',
  35.  `user_dst` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  36.  `user_dateformat` VARCHAR(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
  37.  `user_style` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  38.  `user_rank` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  39.  `user_colour` VARCHAR(6) COLLATE utf8_bin NOT NULL DEFAULT '',
  40.  `user_new_privmsg` INT(4) NOT NULL DEFAULT '0',
  41.  `user_unread_privmsg` INT(4) NOT NULL DEFAULT '0',
  42.  `user_last_privmsg` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  43.  `user_message_rules` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  44.  `user_full_folder` INT(11) NOT NULL DEFAULT '-3',
  45.  `user_emailtime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  46.  `user_topic_show_days` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  47.  `user_topic_sortby_type` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
  48.  `user_topic_sortby_dir` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
  49.  `user_post_show_days` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  50.  `user_post_sortby_type` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
  51.  `user_post_sortby_dir` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
  52.  `user_notify` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  53.  `user_notify_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  54.  `user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
  55.  `user_allow_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  56.  `user_allow_viewonline` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  57.  `user_allow_viewemail` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  58.  `user_allow_massemail` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  59.  `user_options` INT(11) UNSIGNED NOT NULL DEFAULT '230271',
  60.  `user_avatar` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  61.  `user_avatar_type` tinyint(2) NOT NULL DEFAULT '0',
  62.  `user_avatar_width` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  63.  `user_avatar_height` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  64.  `user_sig` mediumtext COLLATE utf8_bin NOT NULL,
  65.  `user_sig_bbcode_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  66.  `user_sig_bbcode_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  67.  `user_from` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  68.  `user_icq` VARCHAR(15) COLLATE utf8_bin NOT NULL DEFAULT '',
  69.  `user_aim` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  70.  `user_yim` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  71.  `user_msnm` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  72.  `user_jabber` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  73.  `user_website` VARCHAR(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  74.  `user_occ` text COLLATE utf8_bin NOT NULL,
  75.  `user_interests` text COLLATE utf8_bin NOT NULL,
  76.  `user_actkey` VARCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  77.  `user_newpasswd` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  78.  `user_form_salt` VARCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  79.  `user_new` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  80.  `user_reminded` tinyint(4) NOT NULL DEFAULT '0',
  81.  `user_reminded_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  82.  PRIMARY KEY (`user_id`),
  83.  UNIQUE KEY `username_clean` (`username_clean`),
  84.  KEY `user_birthday` (`user_birthday`),
  85.  KEY `user_email_hash` (`user_email_hash`),
  86.  KEY `user_type` (`user_type`)
  87. ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

torneos_rondas:

Código SQL: 
Ver original
  1. CREATE TABLE `torneos_rondas` (
  2.  `id_ronda` INT(7) NOT NULL AUTO_INCREMENT,
  3.  `nombre_ronda` VARCHAR(250) NOT NULL,
  4.  PRIMARY KEY (`id_ronda`)
  5. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1

torneos_inscripcion:

Código SQL: 
Ver original
  1. CREATE TABLE `torneos_inscripcion` (
  2.  `id` INT(7) NOT NULL AUTO_INCREMENT,
  3.  `user_id` INT(7) NOT NULL,
  4.  `username` VARCHAR(250) NOT NULL,
  5.  `nombrereal` VARCHAR(100) NOT NULL,
  6.  `apellidos` VARCHAR(250) NOT NULL,
  7.  `email` VARCHAR(250) NOT NULL,
  8.  `estado` VARCHAR(250) NOT NULL DEFAULT 'SP',
  9.  `fecha` DATE NOT NULL,
  10.  `id_torneo` INT(7) NOT NULL,
  11.  PRIMARY KEY (`id`)
  12. ) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=latin1


A la tabla de usuarios le tengo de nombre "foro_users"
Última edición por dankko; 30/05/2013 a las 03:07