text: -- MariaDB dump 10.17  Distrib 10.4.11-MariaDB, for Win64 (AMD64)
  --
  -- Host: localhost    Database: devcond2
  -- ------------------------------------------------------
  -- Server version	10.4.11-MariaDB
  
  /*!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 `areadisableddays`
  --
  
  DROP TABLE IF EXISTS `areadisableddays`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `areadisableddays` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_area` int(11) NOT NULL,
    `day` date NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `areadisableddays`
  --
  
  LOCK TABLES `areadisableddays` WRITE;
  /*!40000 ALTER TABLE `areadisableddays` DISABLE KEYS */;
  /*!40000 ALTER TABLE `areadisableddays` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `areas`
  --
  
  DROP TABLE IF EXISTS `areas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `areas` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `allowed` tinyint(4) NOT NULL DEFAULT 1,
    `cover` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `days` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `start_time` time NOT NULL,
    `end_time` time NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `areas`
  --
  
  LOCK TABLES `areas` WRITE;
  /*!40000 ALTER TABLE `areas` DISABLE KEYS */;
  INSERT INTO `areas` VALUES (1,'Academia',1,'academia.jpg','1,3,5','07:00:00','23:00:00'),(2,'Churrasqueira',1,'churras.jpg','1,2,3,4,5,6','07:00:00','23:00:00'),(3,'Piscina',1,'piscina.jpg','1,2,3,4,5,6','08:00:00','23:00:00');
  /*!40000 ALTER TABLE `areas` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `billets`
  --
  
  DROP TABLE IF EXISTS `billets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `billets` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_unit` int(11) NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `file_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `billets`
  --
  
  LOCK TABLES `billets` WRITE;
  /*!40000 ALTER TABLE `billets` DISABLE KEYS */;
  INSERT INTO `billets` VALUES (1,1,'Luz','luz.png'),(2,1,'Água','água.png');
  /*!40000 ALTER TABLE `billets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `docs`
  --
  
  DROP TABLE IF EXISTS `docs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `docs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `file_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `docs`
  --
  
  LOCK TABLES `docs` WRITE;
  /*!40000 ALTER TABLE `docs` DISABLE KEYS */;
  INSERT INTO `docs` VALUES (1,'Avisos gerais','avisos.jpg');
  /*!40000 ALTER TABLE `docs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `foundandlost`
  --
  
  DROP TABLE IF EXISTS `foundandlost`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `foundandlost` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'lost',
    `date_created` date NOT NULL,
    `where` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `photo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `foundandlost`
  --
  
  LOCK TABLES `foundandlost` WRITE;
  /*!40000 ALTER TABLE `foundandlost` DISABLE KEYS */;
  INSERT INTO `foundandlost` VALUES (1,'Carteira','Carteira preta','lost','2021-02-04','Piscina','carteira.png'),(2,'Camiseta','Camiseta do gremio','found','2021-02-04','Academia','camiseta.png'),(3,'Carteira API','Carteira preta','lost','2021-02-04','Churrasqueira','hZakNA9gSdWsMD9aVQXPw04O0g7Ssf82r9spONd9.png');
  /*!40000 ALTER TABLE `foundandlost` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migrations`
  --
  
  LOCK TABLES `migrations` WRITE;
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` VALUES (1,'2021_01_30_184528_create_all_tables',1);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `reservations`
  --
  
  DROP TABLE IF EXISTS `reservations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `reservations` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_area` int(11) NOT NULL,
    `id_unit` int(11) NOT NULL,
    `reservation_date` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `reservations`
  --
  
  LOCK TABLES `reservations` WRITE;
  /*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
  INSERT INTO `reservations` VALUES (1,1,1,'2021-07-15 09:00:00'),(2,2,1,'2021-02-06 11:00:00'),(4,1,1,'2021-02-06 09:00:00');
  /*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `unitpeoples`
  --
  
  DROP TABLE IF EXISTS `unitpeoples`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `unitpeoples` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_unit` int(11) NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `birthdate` date NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `unitpeoples`
  --
  
  LOCK TABLES `unitpeoples` WRITE;
  /*!40000 ALTER TABLE `unitpeoples` DISABLE KEYS */;
  /*!40000 ALTER TABLE `unitpeoples` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `unitpets`
  --
  
  DROP TABLE IF EXISTS `unitpets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `unitpets` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_unit` int(11) NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `race` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `unitpets`
  --
  
  LOCK TABLES `unitpets` WRITE;
  /*!40000 ALTER TABLE `unitpets` DISABLE KEYS */;
  INSERT INTO `unitpets` VALUES (1,1,'Nina','Linguiça'),(2,1,'Mel','Vira-lata');
  /*!40000 ALTER TABLE `unitpets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `units`
  --
  
  DROP TABLE IF EXISTS `units`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `units` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_owner` int(11) NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `units`
  --
  
  LOCK TABLES `units` WRITE;
  /*!40000 ALTER TABLE `units` DISABLE KEYS */;
  INSERT INTO `units` VALUES (1,1,'AP_101'),(2,2,'AP_102');
  /*!40000 ALTER TABLE `units` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `unitvehicles`
  --
  
  DROP TABLE IF EXISTS `unitvehicles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `unitvehicles` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_unit` int(11) NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `plate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `unitvehicles`
  --
  
  LOCK TABLES `unitvehicles` WRITE;
  /*!40000 ALTER TABLE `unitvehicles` DISABLE KEYS */;
  INSERT INTO `unitvehicles` VALUES (1,1,'KIA Cerato','KZXY99','Preto');
  /*!40000 ALTER TABLE `unitvehicles` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `cpf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`),
    UNIQUE KEY `users_cpf_unique` (`cpf`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES (1,'renanrodrigues_cb_@hotmail.com','04634157012','Renan Rodrigues','$2y$10$gdMwJq1E.Kw7aaUOT.y2xO5X668GGDjIxKKtl3VqQvM951a57PUpS');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `walllikes`
  --
  
  DROP TABLE IF EXISTS `walllikes`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `walllikes` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_wall` int(11) NOT NULL,
    `id_user` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `walllikes`
  --
  
  LOCK TABLES `walllikes` WRITE;
  /*!40000 ALTER TABLE `walllikes` DISABLE KEYS */;
  INSERT INTO `walllikes` VALUES (2,1,2),(10,1,1);
  /*!40000 ALTER TABLE `walllikes` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `walls`
  --
  
  DROP TABLE IF EXISTS `walls`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `walls` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `body` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `date_created` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `walls`
  --
  
  LOCK TABLES `walls` WRITE;
  /*!40000 ALTER TABLE `walls` DISABLE KEYS */;
  INSERT INTO `walls` VALUES (1,'Primeiro aviso','Aviso numero 1 da API','2021-02-02 16:13:05'),(2,'Segundo','Teste num 2 da API','2021-02-02 16:14:41');
  /*!40000 ALTER TABLE `walls` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `warnings`
  --
  
  DROP TABLE IF EXISTS `warnings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `warnings` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_unit` int(11) NOT NULL,
    `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'in_review',
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `date_created` datetime NOT NULL,
    `photos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `warnings`
  --
  
  LOCK TABLES `warnings` WRITE;
  /*!40000 ALTER TABLE `warnings` DISABLE KEYS */;
  INSERT INTO `warnings` VALUES (9,1,'in_review','Aviso com foto','2021-02-03 00:00:00',''),(10,1,'in_review','Aviso com foto','2021-02-03 00:00:00','KI7UHBUHrkTG81ttM0XGLW6LNmh42M9c4Ba9yfcn.png');
  /*!40000 ALTER TABLE `warnings` 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-02-10 17:10:00
  