· 7 years ago · Sep 18, 2018, 02:58 PM
1CREATE TABLE IF NOT EXISTS `horus`.`alunos` (
2 `id` INT(11) NOT NULL AUTO_INCREMENT,
3 `nome` VARCHAR(100) NOT NULL,
4 `cpf` VARCHAR(15) NOT NULL,
5 `rg` VARCHAR(15) NOT NULL,
6 `nascimento` VARCHAR(50) NOT NULL,
7 `sexo` VARCHAR(100) NOT NULL,
8 `fone` VARCHAR(15) NOT NULL,
9 `email` VARCHAR(100) NOT NULL,
10 `endereco` VARCHAR(100) NOT NULL,
11 `bairro` VARCHAR(100) NOT NULL,
12 `cep` VARCHAR(10) NOT NULL,
13 `estado` VARCHAR(50) NOT NULL,
14 `cidade` VARCHAR(100) NOT NULL,
15 PRIMARY KEY (`id`),
16 UNIQUE INDEX `cpf` (`cpf` ASC),
17 UNIQUE INDEX `rg` (`rg` ASC))
18 ENGINE = InnoDB
19 AUTO_INCREMENT = 2
20 DEFAULT CHARACTER SET = latin1;