Skip to content

Instantly share code, notes, and snippets.

@edvaldoszy
Created January 26, 2016 12:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save edvaldoszy/d571f09ad54ff19c0a8e to your computer and use it in GitHub Desktop.
Save edvaldoszy/d571f09ad54ff19c0a8e to your computer and use it in GitHub Desktop.
CREATE TABLE IF NOT EXISTS `usuarios` (
`codigo` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`nome` VARCHAR(50) NOT NULL,
`email` VARCHAR(100) NOT NULL,
`senha` VARCHAR(70) NOT NULL,
`ativo` CHAR(1) NOT NULL DEFAULT '1',
`cadastro` DATETIME NOT NULL
) ENGINE = MyISAN
DEFAULT CHARACTER SET = utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment