Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `clubes` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `descricao` VARCHAR(100) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
- INSERT INTO `clubes` (`id`, `descricao`) VALUES
- (1, 'Real Madrid'),
- (2, 'Barcelona'),
- (3, 'Zenit');
- (4, 'FC PORTO'),
- CREATE TABLE IF NOT EXISTS `jogadores` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nome` VARCHAR(100) NOT NULL,
- `data_nascimento` DATE NOT NULL,
- `valor_estimado` FLOAT(11,2) NOT NULL,
- `foto` VARCHAR(100) DEFAULT NULL,
- `id_clube` INT(11) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
- INSERT INTO `jogadores` (`id`, `nome`, `data_nascimento`, `valor_estimado`, `foto`, `id_clube`) VALUES
- (1, 'Cristiano Ronaldo', '1985-02-15', 150000000.00, '1/ronaldo.jpg', 1),
- (2, 'Lionel Messi', '1987-06-24', 200000000.00, '2/messi.jpg', 2),
- (3, 'Hulk', '1986-07-25', 25000000.00, '3/hulk.jpg', 3),
- (4, 'Gareth Bale', '1989-07-16', 100000000.00, '6/gareth-bale-1.jpg', 1),
- (5, 'Iker Casillas', '1981-05-20', 10000000.00, '7/ikercasillas.jpg', 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement