-- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
--
-- Host: us-cdbr-iron-east-04.cleardb.net    Database: heroku_b8c95babb9ee949
-- ------------------------------------------------------
-- Server version	5.5.56-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 `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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 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 (2,'2020_02_04_102236_create_users_table',1),(12,'2020_02_04_103522_create_password_resets_table',1),(22,'2020_02_04_105532_create_sensor_table',1),(32,'2020_02_04_135340_create_sensor_data_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(65) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

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

--
-- Table structure for table `sensor_data`
--

DROP TABLE IF EXISTS `sensor_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sensor_data` (
  `sensor_data_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sensor_id` bigint(20) unsigned NOT NULL,
  `rainfall_mm` int(11) NOT NULL,
  `datetime_recorded` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sensor_data_id`),
  KEY `sensor_data_sensor_id_foreign` (`sensor_id`),
  CONSTRAINT `sensor_data_sensor_id_foreign` FOREIGN KEY (`sensor_id`) REFERENCES `sensors` (`sensor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2332 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sensor_data`
--

LOCK TABLES `sensor_data` WRITE;
/*!40000 ALTER TABLE `sensor_data` DISABLE KEYS */;
INSERT INTO `sensor_data` VALUES (2,1,7,'2019-12-14 14:15:51','2020-02-24 10:12:04',NULL),(12,1,7,'2019-12-14 16:15:51','2020-02-24 10:12:04',NULL),(22,1,6,'2019-12-14 18:15:51','2020-02-24 10:12:04',NULL),(32,1,0,'2019-12-14 20:15:51','2020-02-24 10:12:04',NULL),(42,1,0,'2019-12-14 22:15:51','2020-02-24 10:12:04',NULL),(52,1,0,'2019-12-15 00:15:51','2020-02-24 10:12:04',NULL),(62,1,0,'2019-12-15 02:15:51','2020-02-24 10:12:04',NULL),(72,1,0,'2019-12-15 04:15:51','2020-02-24 10:12:04',NULL),(82,1,0,'2019-12-15 06:15:51','2020-02-24 10:12:04',NULL),(92,1,2,'2019-12-15 08:15:51','2020-02-24 10:12:04',NULL),(102,1,2,'2019-12-15 10:15:51','2020-02-24 10:12:04',NULL),(112,1,3,'2019-12-15 12:15:51','2020-02-24 10:12:04',NULL),(122,1,3,'2019-12-15 14:15:51','2020-02-24 10:12:04',NULL),(132,1,3,'2019-12-15 16:15:51','2020-02-24 10:12:04',NULL),(142,1,0,'2019-12-15 18:15:51','2020-02-24 10:12:04',NULL),(152,1,10,'2019-12-15 20:15:51','2020-02-24 10:12:04',NULL),(162,1,16,'2019-12-15 22:15:51','2020-02-24 10:12:04',NULL),(172,1,10,'2019-12-16 00:15:51','2020-02-24 10:12:04',NULL),(182,1,4,'2019-12-16 02:15:51','2020-02-24 10:12:04',NULL),(192,1,4,'2019-12-16 04:15:51','2020-02-24 10:12:04',NULL),(202,1,4,'2019-12-16 06:15:51','2020-02-24 10:12:04',NULL),(212,1,0,'2019-12-16 08:15:51','2020-02-24 10:12:04',NULL),(222,1,0,'2019-12-16 10:15:51','2020-02-24 10:12:04',NULL),(232,1,0,'2019-12-16 12:15:51','2020-02-24 10:12:04',NULL),(242,1,0,'2019-12-16 14:15:51','2020-02-24 10:12:04',NULL),(252,1,0,'2019-12-16 16:15:51','2020-02-24 10:12:04',NULL),(262,1,0,'2019-12-16 18:15:51','2020-02-24 10:12:04',NULL),(272,1,0,'2019-12-16 20:15:51','2020-02-24 10:12:04',NULL),(282,2,0,'2019-12-14 14:15:51','2020-02-24 13:12:45',NULL),(292,2,7,'2019-12-14 16:15:51','2020-02-24 13:12:45',NULL),(302,2,7,'2019-12-14 18:15:51','2020-02-24 13:12:45',NULL),(312,2,6,'2019-12-14 20:15:51','2020-02-24 13:12:45',NULL),(322,2,0,'2019-12-14 22:15:51','2020-02-24 13:12:45',NULL),(332,2,0,'2019-12-15 00:15:51','2020-02-24 13:12:45',NULL),(342,2,0,'2019-12-15 02:15:51','2020-02-24 13:12:45',NULL),(352,2,0,'2019-12-15 04:15:51','2020-02-24 13:12:45',NULL),(362,2,2,'2019-12-15 06:15:51','2020-02-24 13:12:45',NULL),(372,2,2,'2019-12-15 08:15:51','2020-02-24 13:12:45',NULL),(382,2,3,'2019-12-15 10:15:51','2020-02-24 13:12:45',NULL),(392,2,3,'2019-12-15 12:15:51','2020-02-24 13:12:45',NULL),(402,2,6,'2019-12-15 14:15:51','2020-02-24 13:12:45',NULL),(412,2,5,'2019-12-15 16:15:51','2020-02-24 13:12:45',NULL),(422,2,0,'2019-12-15 18:15:51','2020-02-24 13:12:45',NULL),(432,2,10,'2019-12-15 20:15:51','2020-02-24 13:12:45',NULL),(442,2,16,'2019-12-15 22:15:51','2020-02-24 13:12:45',NULL),(452,2,10,'2019-12-16 00:15:51','2020-02-24 13:12:45',NULL),(462,2,4,'2019-12-16 02:15:51','2020-02-24 13:12:45',NULL),(472,2,4,'2019-12-16 04:15:51','2020-02-24 13:12:45',NULL),(482,2,4,'2019-12-16 06:15:51','2020-02-24 13:12:45',NULL),(492,2,0,'2019-12-16 08:15:51','2020-02-24 13:12:45',NULL),(502,2,0,'2019-12-16 10:15:51','2020-02-24 13:12:45',NULL),(512,2,3,'2019-12-16 12:15:51','2020-02-24 13:12:45',NULL),(522,2,3,'2019-12-16 14:15:51','2020-02-24 13:12:45',NULL),(532,2,3,'2019-12-16 16:15:51','2020-02-24 13:12:45',NULL),(542,2,0,'2019-12-16 18:15:51','2020-02-24 13:12:45',NULL),(552,2,0,'2019-12-16 20:15:51','2020-02-24 13:12:45',NULL),(2032,3,12,'2019-12-14 14:15:51','2020-02-25 18:08:30',NULL),(2042,3,12,'2019-12-14 16:15:51','2020-02-25 18:08:31',NULL),(2052,3,0,'2019-12-14 18:15:51','2020-02-25 18:08:31',NULL),(2062,3,12,'2019-12-14 20:15:51','2020-02-25 18:08:31',NULL),(2072,3,4,'2019-12-14 22:15:51','2020-02-25 18:08:31',NULL),(2082,3,4,'2019-12-15 00:15:51','2020-02-25 18:08:31',NULL),(2092,3,4,'2019-12-15 02:15:51','2020-02-25 18:08:32',NULL),(2102,3,2,'2019-12-15 04:15:51','2020-02-25 18:08:32',NULL),(2112,3,2,'2019-12-15 06:15:51','2020-02-25 18:08:32',NULL),(2122,3,2,'2019-12-15 08:15:51','2020-02-25 18:08:32',NULL),(2132,3,0,'2019-12-15 10:15:51','2020-02-25 18:08:32',NULL),(2142,3,0,'2019-12-15 12:15:51','2020-02-25 18:08:32',NULL),(2152,3,0,'2019-12-15 14:15:51','2020-02-25 18:08:33',NULL),(2162,3,0,'2019-12-15 16:15:51','2020-02-25 18:08:33',NULL),(2172,3,0,'2019-12-15 18:15:51','2020-02-25 18:08:33',NULL),(2182,3,4,'2019-12-15 20:15:51','2020-02-25 18:08:33',NULL),(2192,3,4,'2019-12-15 22:15:51','2020-02-25 18:08:33',NULL),(2202,3,4,'2019-12-16 00:15:51','2020-02-25 18:08:33',NULL),(2212,3,0,'2019-12-16 02:15:51','2020-02-25 18:08:34',NULL),(2222,3,0,'2019-12-16 04:15:51','2020-02-25 18:08:34',NULL),(2232,3,1,'2019-12-16 06:15:51','2020-02-25 18:08:34',NULL),(2242,3,2,'2019-12-16 08:15:51','2020-02-25 18:08:34',NULL),(2252,3,2,'2019-12-16 10:15:51','2020-02-25 18:08:35',NULL),(2262,3,1,'2019-12-16 12:15:51','2020-02-25 18:08:35',NULL),(2272,3,2,'2019-12-16 14:15:51','2020-02-25 18:08:35',NULL),(2282,3,2,'2019-12-16 16:15:51','2020-02-25 18:08:35',NULL),(2292,3,0,'2019-12-16 18:15:51','2020-02-25 18:08:35',NULL),(2302,3,2,'2019-12-16 20:15:51','2020-02-25 18:08:35',NULL);
/*!40000 ALTER TABLE `sensor_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sensors`
--

DROP TABLE IF EXISTS `sensors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sensors` (
  `sensor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_latitude` double(10,8) NOT NULL,
  `location_longitude` double(11,8) NOT NULL,
  `date_installed` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sensor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sensors`
--

LOCK TABLES `sensors` WRITE;
/*!40000 ALTER TABLE `sensors` DISABLE KEYS */;
INSERT INTO `sensors` VALUES (1,51.61588900,-3.92793900,'2019-10-05','2020-02-21 18:21:25','2020-02-25 18:04:29'),(2,51.46246300,-3.16648100,'2019-11-22','2020-02-21 18:21:25','2020-02-24 14:11:55'),(3,51.85159500,-4.30590000,'2019-12-01','2020-02-21 18:21:25','2020-02-25 11:45:55'),(4,51.85666800,-4.31698300,'2020-02-02','2020-02-23 11:54:21','2020-02-25 18:21:25'),(142,52.34555000,-3.44545000,'2020-02-20','2020-02-25 18:05:31','2020-02-25 18:05:31');
/*!40000 ALTER TABLE `sensors` 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` (
  `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `forename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `surname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=42 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 (2,'siobhan','stephens','siobhan.k.stephens@gmail.com','2020-02-24 16:17:35','$2y$10$Q3W03zW.mFKuG5xvIWeJRuEmYsiACW60uohcmwIsQolMT/p6tv5re',1,'2HUAcrNHQvoSNJwGFloyia0oGG6WuqMm0gnTcFzLgQtkFWRtawxnZsGEET6D','2020-02-18 10:34:55','2020-02-24 16:17:35'),(32,'ally','jones','alyonatoa@gmail.com','2020-02-25 18:14:09','$2y$10$3lPQfL.bFZZHJWS2A5qW4eBtpE1vRD9btLS1kZ6eS.LHONeGJjtHK',0,NULL,'2020-02-25 18:13:54','2020-02-25 18:14:09');
/*!40000 ALTER TABLE `users` 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 2020-02-27 14:11:08
