· 8 years ago · Dec 11, 2017, 06:38 PM
1CREATE TABLE IF NOT EXISTS `usuario` (
2 `login` VARCHAR(15) NOT NULL,
3 `nome` VARCHAR(40) NOT NULL,
4 `senha` VARCHAR(10) NOT NULL,
5 PRIMARY KEY (`login`))
6ENGINE = InnoDB;
7
8
9CREATE TABLE IF NOT EXISTS `extras` (
10 `idFunc` INT NULL,
11 `login` VARCHAR(15) NOT NULL,
12 `data` DATETIME NULL,
13 `extra` TEXT NULL,
14 INDEX `fk_extras_usuario_idx` (`login` ASC),
15 CONSTRAINT `fk_extras_usuario`
16 FOREIGN KEY (`login`)
17 REFERENCES `usuario` (`login`)
18 ON DELETE NO ACTION
19 ON UPDATE NO ACTION)
20ENGINE = InnoDB;