-- MySQL dump 10.17  Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cill
-- ------------------------------------------------------
-- Server version	10.3.23-MariaDB-0+deb10u1

/*!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 utf8mb4 */;
/*!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 `det_versao`
--

DROP TABLE IF EXISTS `det_versao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `det_versao` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `id_versao` int(5) NOT NULL,
  `det_versao` varchar(95) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `det_versao`
--

LOCK TABLES `det_versao` WRITE;
/*!40000 ALTER TABLE `det_versao` DISABLE KEYS */;
INSERT INTO `det_versao` VALUES (1,1,'Conserto de bugs e melhorias'),(2,1,'Adicionado o alerta de nova versão no sistema'),(3,2,'Incremento de verificador de atualizacções'),(4,2,'Bugs e Correções'),(5,3,'Adicionado o botão de \"Change log\"'),(6,3,'Diminuição da largura da tabela'),(7,4,'Trocado o usuário \"1206 - Luciano\" para \"1206 - Gabriel\"'),(8,5,'Ajustes e Alterações nos ramais'),(9,6,'Conserto dos ramais duplicados e inativos.');
/*!40000 ALTER TABLE `det_versao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ramais`
--

DROP TABLE IF EXISTS `ramais`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramais` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `ramal` int(5) NOT NULL,
  `label` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `categoria` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ramais`
--

LOCK TABLES `ramais` WRITE;
/*!40000 ALTER TABLE `ramais` DISABLE KEYS */;
INSERT INTO `ramais` VALUES (1,1000,'TODOS','NOC',1),(2,1001,'WILSON','NOC',1),(3,1002,'ANDREY','NOC',1),(4,1003,'NATANAEL','NOC',1),(5,1100,'TODOS','FINANCEIRO',1),(6,1101,'VERONICA','ADMINISTRAÇÃO',1),(7,1102,'CAMILA','FINANCEIRO',1),(8,1200,'TODOS','SUPORTE',1),(9,1201,'THIAGO DINIZ','SUPORTE',1),(10,1202,'ATENDENTE','SUPORTE',0),(11,1203,'VIVIAN','SUPORTE',1),(12,1204,'THIAGO POLI','SUPORTE',1),(13,1206,'GABRIEL','SUPORTE',1),(14,1300,'TODOS','COMERCIAL',1),(15,1301,'MATHEUS','COMERCIAL',1),(16,1302,'STEFANY','COMERCIAL',1),(17,1303,'ROMARIO','COMERCIAL',1),(18,1400,'TODOS','ADMINISTRAÇÃO',1),(19,1402,'HOLGER','ADMINISTRAÇÃO',1),(20,1403,'CAIO','ADMINISTRAÇÃO',1),(21,1404,'WALTER','ADMINISTRAÇÃO',1),(22,1406,'RAFAEL','ADMINISTRAÇÃO',1),(23,1407,'LARISSA','ADMINISTRAÇÃO',1),(24,1408,'SUPERVISOR','ADMINISTRAÇÃO',1),(25,1900,'TODOS','CELULAR',1),(26,1904,'WALTER CEL','CELULAR',1),(27,1905,'ANTUNES CEL','CELULAR',1),(28,1999,'DOUGLAS CEL','CELULAR',1),(29,1004,'ANTUNES','NOC',1),(30,1004,'DAPHINE','FINANCEIRO',1),(31,1502,'RENATO','CORPORATIVO',1),(32,1409,'EDUARDO','ADMINISTRAÇÃO',1),(33,1903,'EDUARDO','CELULAR',1),(35,1500,'TODOS','CORPORATIVO',1);
/*!40000 ALTER TABLE `ramais` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `versao`
--

DROP TABLE IF EXISTS `versao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `versao` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `versao` varchar(9) COLLATE utf8_unicode_ci NOT NULL,
  `dt_versao` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `versao`
--

LOCK TABLES `versao` WRITE;
/*!40000 ALTER TABLE `versao` DISABLE KEYS */;
INSERT INTO `versao` VALUES (1,'1.0.12','2018-11-30 16:19:09'),(2,'1.0.13','2018-11-30 17:20:39'),(3,'1.0.14','2018-12-03 10:44:34'),(4,'1.0.15','2019-02-04 11:08:18'),(5,'1.0.16','2019-05-22 19:13:13'),(6,'1.0.17','2019-05-22 19:23:12');
/*!40000 ALTER TABLE `versao` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-01-20 14:23:03
