yhKy21s0

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2DROP TABLE IF EXISTS `usuarios`;
3CREATE TABLE IF NOT EXISTS `usuarios` (
4  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
5  `nome` varchar(50) NOT NULL,
6  `usuario` varchar(25) NOT NULL,
7  `senha` varchar(40) NOT NULL,
8  `email` varchar(100) NOT NULL,
9  `nivel` int(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Normal (1) e Administrador (2)',
10  `ativo` tinyint(1) NOT NULL DEFAULT '1',
11  `cadastro` datetime NOT NULL,
12  `ip` varchar(50),
13  PRIMARY KEY (`id`),
14  UNIQUE KEY `usuario` (`usuario`),
15  KEY `niveis` (`nivel`)
16) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;