# ************************************************************
# Antares - SQL Client
# Version 0.7.27
# 
# https://antares-sql.app/
# https://github.com/antares-sql/antares
# 
# Host: *****.***.*** (MySQL Community Server - GPL 8.0.39)
# Database: ********_********
# Generation time: 2024-08-20T14:02:55-03:00
# ************************************************************


/*!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 */;
SET NAMES utf8mb4;
/*!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 */;


# Dump of table area
# ------------------------------------------------------------

DROP TABLE IF EXISTS `area`;

CREATE TABLE `area` (
  `id` int NOT NULL AUTO_INCREMENT,
  `unidadeFK` int DEFAULT '1',
  `area` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `data` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ativo` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `unidadeFK` (`unidadeFK`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;

INSERT INTO `area` (`id`, `unidadeFK`, `area`, `ativo`) VALUES
	(1, 1, "Gerente", 1),
	(3, 1, "Diretor", 1),
	(4, 1, "Administrativo", 1),
	(5, 1, "Logística", 0),
	(6, 1, "Vendedor", 0),
	(7, 1, "Recepção", 0),
	(8, 1, "Financeiro", 1),
	(9, 1, "Classificação", 1),
	(10, 1, "Balança", 1),
	(11, 1, "Portaria", 1),
	(12, 1, "Faturamento", 1),
	(13, 1, "Qualidade", 1),
	(14, 1, "Contabilidade", 1),
	(15, 1, "Almoxarifado", 1),
	(16, 1, "Agendamento", 1),
	(17, 1, "Outros", 1),
	(18, 1, "RH", 1),
	(19, 1, "Segurança", 1),
	(20, 1, "Marketing", 1);

/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

# Dump completed on 2024-08-20T14:02:55-03:00