CREATE TABLE `zdk_users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Internal User id',
`login_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`login_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`expiration_date` date NOT NULL COMMENT 'Expiration date of the password',
`user_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`user_surname` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci ,
`user_email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`full_menu_access` tinyint(1) NOT NULL COMMENT 'Does the user have access to the full menu?',
`user_enabled` tinyint(1) NOT NULL COMMENT 'Is user enabled ? enabled (true), disabled (false))',
PRIMARY KEY (`user_id`),
UNIQUE KEY `login_name` (`login_name`),
UNIQUE KEY `user_email` (`user_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table of users' AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `equipos` (
`id_equipo` int(11) NOT NULL AUTO_INCREMENT ,
`nombre_equipo` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`id_categoria` int(11) NOT NULL ,
`user_id` int(11) NOT NULL ,
`id_club` int(11) NOT NULL ,
PRIMARY KEY (`id_equipo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `jugadores` (
`id_jugador` int(11) NOT NULL AUTO_INCREMENT ,
`id_equipo` int(11) NOT NULL ,
`id_categoria` int(11) NOT NULL ,
`id_posicion` int(11) NOT NULL ,
`id_posicion_1` int(11) NOT NULL ,
`id_posicion_2` int(11) NOT NULL ,
`nombre_jugador` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`apellidos` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
PRIMARY KEY (`id_jugador`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `equipos`
ADD CONSTRAINT `zdk_equipo_entrenador` FOREIGN KEY (`user_id`) REFERENCES `zdk_users` (`user_id`),
ADD CONSTRAINT `zdk_equipo_categoria` FOREIGN KEY (`id_categoria`) REFERENCES `categorias` (`id_categoria`);
ALTER TABLE `jugadores`
ADD CONSTRAINT `zdk_jugador_equipo` FOREIGN KEY (`id_equipo`) REFERENCES `equipos` (`id_equipo`),
ADD CONSTRAINT `zdk_jugador_categoria` FOREIGN KEY (`id_categoria`) REFERENCES `categorias` (`id_categoria`);
Saludos