File: ooelitedump.sql

-- MySQL dump 10.11
--
-- Host: localhost    Database: unixmafia
-- ------------------------------------------------------
-- Server version	5.0.77-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `acs_exception`
--

DROP TABLE IF EXISTS `acs_exception`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `acs_exception` (
  `CD_EXCEPTION` smallint(5) unsigned NOT NULL,
  `DS_EXCEPTION` varchar(128) NOT NULL,
  PRIMARY KEY  (`CD_EXCEPTION`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `acs_exception`
--

LOCK TABLES `acs_exception` WRITE;
/*!40000 ALTER TABLE `acs_exception` DISABLE KEYS */;
INSERT INTO `acs_exception` VALUES (4001,'Chave de autenticação inválida'),(4002,'Login Inválido'),(4003,'Usuário Inativo'),(4004,'Número de tentativas excedido'),(4005,'Senha Inválida'),(4006,'Desconectado por Inatividade'),(4007,'Usuário sem permissões'),(4008,'Usuário sem estabelecimento definido'),(9000,'Usuário logado tentou acessar página sem permissão'),(9001,'Usuário fez logoff'),(9999,'Tentativa de acesso de usuário desconhecido');
/*!40000 ALTER TABLE `acs_exception` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `acs_log_acesso`
--

DROP TABLE IF EXISTS `acs_log_acesso`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `acs_log_acesso` (
  `DT_ACESSO` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `TX_IP` varchar(15) NOT NULL,
  `CD_USUARIO` smallint(5) unsigned NOT NULL,
  `CD_EXCEPTION` smallint(6) default NULL,
  `IN_AUT_OK` enum('S','N') NOT NULL,
  PRIMARY KEY  (`DT_ACESSO`,`TX_IP`,`CD_USUARIO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Log dos acessos dos Usuários do sistema';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `acs_log_acesso`
--

LOCK TABLES `acs_log_acesso` WRITE;
/*!40000 ALTER TABLE `acs_log_acesso` DISABLE KEYS */;
/*!40000 ALTER TABLE `acs_log_acesso` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `acs_sessao`
--

DROP TABLE IF EXISTS `acs_sessao`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `acs_sessao` (
  `ID_SESSION` int(10) unsigned NOT NULL auto_increment,
  `REMOTE_ADDR` bigint(20) unsigned NOT NULL,
  `KEYTIME` int(10) unsigned NOT NULL,
  `KEEPALIVE` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ID_SESSION`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1 COMMENT='Controle da Sessão de Login';
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `acs_usuarios`
--

DROP TABLE IF EXISTS `acs_usuarios`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `acs_usuarios` (
  `CD_USUARIO` smallint(5) unsigned NOT NULL,
  `NM_USUARIO` varchar(50) NOT NULL,
  `TX_EMAIL` varchar(60) default NULL,
  `DT_INC` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `DT_ALT` timestamp NULL default NULL,
  PRIMARY KEY  (`CD_USUARIO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Cadastro de Usuários do Sistema';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `acs_usuarios`
--

LOCK TABLES `acs_usuarios` WRITE;
/*!40000 ALTER TABLE `acs_usuarios` DISABLE KEYS */;
INSERT INTO `acs_usuarios` VALUES (1,'Marcelo Costa','phpmafia@yahoo.com.br','2009-07-03 19:28:06',NULL);
/*!40000 ALTER TABLE `acs_usuarios` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `acs_usuarios_login`
--

DROP TABLE IF EXISTS `acs_usuarios_login`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `acs_usuarios_login` (
  `CD_USUARIO` smallint(5) unsigned NOT NULL auto_increment,
  `TX_LOGIN` varchar(20) NOT NULL,
  `TX_SENHA_MD5` varchar(32) NOT NULL,
  `TX_SENHA_SHA1` varchar(40) NOT NULL,
  `QT_ACESSOS` smallint(5) unsigned NOT NULL,
  `QT_TENTATIVAS` tinyint(3) unsigned NOT NULL,
  `DT_TROCA_SENHA` timestamp NOT NULL default '0000-00-00 00:00:00',
  `DT_ULT_ACESSO` timestamp NULL default NULL,
  `DT_ACESSO` timestamp NULL default NULL,
  `TX_IP` varchar(15) default NULL,
  `ST_REG` enum('A','I') NOT NULL,
  PRIMARY KEY  (`CD_USUARIO`),
  UNIQUE KEY `UK_USU_LOGIN_01` (`TX_LOGIN`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Dados para Login do Usuário';
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `acs_usuarios_login`
--

LOCK TABLES `acs_usuarios_login` WRITE;
/*!40000 ALTER TABLE `acs_usuarios_login` DISABLE KEYS */;
INSERT INTO `acs_usuarios_login` VALUES (1,'mscbsd', MD5('root'),SHA1('root'),3,0,'0000-00-00 00:00:00','2009-07-06 20:08:06',NULL,'127001','A');
/*!40000 ALTER TABLE `acs_usuarios_login` ENABLE KEYS */;
UNLOCK TABLES;