kACL3H7i

1`competicao`
2
3
4CREATE TABLE IF NOT EXISTS `competicao` (
5  `id` int(5) NOT NULL AUTO_INCREMENT,
6  `nome` varchar(70) CHARACTER SET latin1 NOT NULL,
7  `equipe_campea` varchar(25) CHARACTER SET latin1 NOT NULL,
8  `vice_campea` varchar(25) CHARACTER SET latin1 NOT NULL,
9  `artilheiro` varchar(25) CHARACTER SET latin1 NOT NULL,
10  `goleiro` varchar(25) CHARACTER SET latin1 NOT NULL,
11  `inicio` varchar(15) CHARACTER SET latin1 NOT NULL,
12  `termino` varchar(15) CHARACTER SET latin1 NOT NULL,
13  `status_competicao` varchar(100) CHARACTER SET latin1 NOT NULL,
14  `jogadores_competicao` int(11) NOT NULL,
15  `data` datetime NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=30 ;