Summary
Published August 19, 2018 © GPL3+
Smart Door Lock

It's a simulated door lock using cloud services and IoT.
IntermediateFull instructions provided3 days4,043
Things used in this project

Hardware components

Raspberry Pi 3 Model B
RFID reader (generic)
Buzzer
PIR Motion Sensor (generic)
Raspberry Pi Camera Module
LED (generic)
DHT11 Temperature & Humidity Sensor (4 pins)
Adafruit Standard LCD - 16x2 White on Blue
Resistor 10k ohm
Jumper wires (generic)
Software apps and online services

MQTT
Amazon Web Services AWS RDS
Flask
Amazon Web Services AWS S3
Amazon Web Services AWS IoT
Story

Summary

This application is a simple smart door lock that grants access or denies access using an RFID card and an RFID card reader.
The flow is simple: The motion sensor detects motion and prompts for the user to tap their RFID card. At the same time, an image is taken and stored in AWS S3. Should the application detect and successfully identify the RFID card, the buzzer will sound and access will be granted.
This application also allows a new user to be added to the database so that more users can be granted access. It's a simple but functional way of being able to scale up.
The application also has a Web UI to view historical and real time data from the data sent by the door lock. All of such information are stored in AWS RDS (Relational Database Service).
An MQTT service also exists and it's supposed to send the card ID to the registered email whenever someone taps the card and access is granted.
Code

-- phpMyAdmin SQL Dump
-- version 4.2.12deb2+deb8u2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 19, 2018 at 12:04 PM
-- Server version: 5.5.54-0+deb8u1
-- PHP Version: 5.6.29-0+deb8u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00: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 */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `CA1db`
--

-- --------------------------------------------------------

--
-- Table structure for table `cards`
--

CREATE TABLE IF NOT EXISTS `cards` (
`id` int(11) unsigned NOT NULL,
  `userId` varchar(50) DEFAULT NULL,
  `tagId` bigint(18) unsigned NOT NULL,
  `permission` int(10) NOT NULL,
  `added` varchar(50) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cards`
--

INSERT INTO `cards` (`id`, `userId`, `tagId`, `permission`, `added`) VALUES
(5, 'Alvin', 136486164126, 1, '23-06-2018 04:33:51'),
(7, 'Mandfred', 1364341751, 2, '26-06-2018 13:22:53');

-- --------------------------------------------------------

--
-- Table structure for table `readings`
--

CREATE TABLE IF NOT EXISTS `readings` (
`id` bigint(11) unsigned NOT NULL,
  `tagId` bigint(18) unsigned NOT NULL,
  `time` varchar(50) DEFAULT NULL,
  `action` int(2) unsigned NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `readings`
--

INSERT INTO `readings` (`id`, `tagId`, `time`, `action`) VALUES
(61, 136486164126, '23-06-2018 04:33:58', 1),
(62, 136486164126, '23-06-2018 04:35:20', 2),
(63, 136486164126, '24-06-2018 00:43:33', 1),
(64, 136486164126, '24-06-2018 00:49:29', 1),
(65, 136486164126, '24-06-2018 00:55:20', 1),
(66, 136486164126, '24-06-2018 03:04:01', 2),
(67, 136486164126, '24-06-2018 03:38:33', 1),
(68, 136486164126, '24-06-2018 04:09:13', 2),
(69, 136486164126, '24-06-2018 15:04:56', 1),
(70, 136486164126, '24-06-2018 15:08:23', 2),
(71, 136486164126, '24-06-2018 15:12:04', 1),
(72, 136486164126, '24-06-2018 15:12:51', 2),
(73, 136486164126, '24-06-2018 15:14:51', 1),
(74, 136486164126, '24-06-2018 23:07:56', 1),
(75, 136486164126, '25-06-2018 00:32:30', 1),
(76, 136486164126, '26-06-2018 13:06:33', 1),
(77, 136486164126, '26-06-2018 13:07:02', 2),
(78, 136486164126, '26-06-2018 13:07:30', 1),
(79, 136486164126, '26-06-2018 13:08:15', 2),
(80, 136486164126, '26-06-2018 13:12:02', 1),
(81, 136486164126, '26-06-2018 13:13:03', 2),
(82, 136486164126, '26-06-2018 13:15:36', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tempdata`
--

CREATE TABLE IF NOT EXISTS `tempdata` (
`id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `temperature` int(11) NOT NULL,
  `humidity` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=530 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tempdata`
--

INSERT INTO `tempdata` (`id`, `date`, `temperature`, `humidity`) VALUES
(9, '2018-06-24 08:41:15', 26, 65),
(10, '2018-06-24 08:42:12', 26, 65),
(11, '2018-06-24 08:43:37', 26, 65),
(12, '2018-06-24 08:45:43', 26, 65),
(13, '2018-06-24 08:58:43', 26, 67),
(14, '2018-06-24 08:58:48', 26, 65),
(15, '2018-06-24 08:58:49', 26, 67),
(16, '2018-06-24 08:58:57', 26, 66),
(17, '2018-06-24 08:58:57', 26, 66),
(18, '2018-06-24 08:58:58', 26, 65),
(19, '2018-06-24 08:58:59', 26, 65),
(20, '2018-06-24 08:59:10', 26, 66),
(21, '2018-06-24 08:59:20', 26, 66),
(22, '2018-06-24 08:59:23', 26, 65),
(23, '2018-06-24 09:19:13', 26, 68),
(24, '2018-06-24 09:19:14', 27, 66),
(25, '2018-06-24 09:20:48', 26, 68),
(26, '2018-06-24 09:22:45', 26, 68),
(27, '2018-06-24 09:22:51', 26, 68),
(28, '2018-06-24 09:22:56', 26, 68),
(29, '2018-06-24 09:23:02', 27, 67),
(30, '2018-06-24 09:23:07', 26, 68),
(31, '2018-06-24 09:23:15', 26, 68),
(32, '2018-06-24 09:23:23', 26, 68),
(33, '2018-06-24 09:23:31', 27, 66),
(34, '2018-06-24 09:23:40', 26, 66),
(35, '2018-06-24 09:23:45', 26, 68),
(36, '2018-06-24 09:23:54', 26, 68),
(37, '2018-06-24 09:24:02', 26, 68),
(38, '2018-06-24 09:24:07', 26, 68),
(39, '2018-06-24 09:24:13', 26, 68),
(40, '2018-06-24 09:24:26', 26, 68),
(41, '2018-06-24 09:24:31', 26, 68),
(42, '2018-06-24 09:24:37', 26, 69),
(43, '2018-06-24 09:24:42', 26, 69),
(44, '2018-06-24 09:24:48', 26, 69),
(45, '2018-06-24 09:24:54', 26, 68),
(46, '2018-06-24 09:25:02', 26, 69),
(47, '2018-06-24 09:25:07', 26, 69),
(48, '2018-06-24 09:25:13', 26, 69),
(49, '2018-06-24 09:25:21', 26, 69),
(50, '2018-06-24 09:25:26', 26, 69),
(51, '2018-06-24 09:25:35', 26, 69),
(52, '2018-06-24 09:25:43', 26, 68),
(53, '2018-06-24 09:25:48', 26, 69),
(54, '2018-06-24 09:25:54', 26, 69),
(55, '2018-06-24 09:26:02', 26, 69),
(56, '2018-06-24 09:26:07', 27, 68),
(57, '2018-06-24 09:26:15', 26, 69),
(58, '2018-06-24 09:26:21', 27, 68),
(59, '2018-06-24 09:26:34', 27, 68),
(60, '2018-06-24 09:26:40', 26, 69),
(61, '2018-06-24 09:26:50', 26, 69),
(62, '2018-06-24 09:26:56', 26, 69),
(63, '2018-06-24 09:27:01', 26, 69),
(64, '2018-06-24 09:27:07', 26, 69),
(65, '2018-06-24 09:27:13', 27, 68),
(66, '2018-06-24 09:27:18', 26, 69),
(67, '2018-06-24 09:27:26', 26, 69),
(68, '2018-06-24 09:27:42', 26, 69),
(69, '2018-06-24 09:27:50', 26, 69),
(70, '2018-06-24 09:27:58', 26, 69),
(71, '2018-06-24 09:28:09', 26, 69),
(72, '2018-06-24 09:28:14', 27, 67),
(73, '2018-06-24 09:28:25', 26, 69),
(74, '2018-06-24 09:28:35', 26, 69),
(75, '2018-06-24 09:28:41', 26, 69),
(76, '2018-06-24 09:28:47', 27, 69),
(77, '2018-06-24 09:32:10', 26, 71),
(78, '2018-06-24 09:32:15', 26, 70),
(79, '2018-06-24 09:32:21', 26, 71),
(80, '2018-06-24 10:34:48', 26, 70),
(81, '2018-06-24 10:34:54', 26, 70),
(82, '2018-06-24 10:34:59', 26, 70),
(83, '2018-06-24 10:35:10', 26, 70),
(84, '2018-06-24 10:35:18', 26, 70),
(85, '2018-06-24 10:35:50', 26, 70),
(86, '2018-06-24 10:35:56', 26, 70),
(87, '2018-06-24 10:36:02', 26, 70),
(88, '2018-06-24 10:36:07', 26, 70),
(89, '2018-06-24 10:36:13', 26, 70),
(90, '2018-06-24 10:36:18', 26, 70),
(91, '2018-06-24 10:36:24', 26, 69),
(92, '2018-06-24 10:36:29', 26, 68),
(93, '2018-06-24 10:36:40', 26, 69),
(94, '2018-06-24 10:36:58', 26, 69),
(95, '2018-06-24 10:37:45', 26, 68),
(96, '2018-06-24 10:37:51', 26, 68),
(97, '2018-06-24 10:39:25', 26, 67),
(98, '2018-06-24 10:39:35', 26, 66),
(99, '2018-06-24 10:39:41', 26, 66),
(100, '2018-06-24 10:39:46', 26, 66),
(101, '2018-06-24 10:39:52', 26, 66),
(102, '2018-06-24 10:40:00', 26, 66),
(103, '2018-06-24 10:40:05', 26, 66),
(104, '2018-06-24 10:40:11', 26, 67),
(105, '2018-06-24 10:40:17', 26, 67),
(106, '2018-06-24 10:40:22', 26, 67),
(107, '2018-06-24 10:42:26', 26, 66),
(108, '2018-06-24 10:42:32', 26, 67),
(109, '2018-06-24 10:42:37', 26, 67),
(110, '2018-06-24 10:42:43', 26, 67),
(111, '2018-06-24 10:42:48', 26, 67),
(112, '2018-06-24 10:42:59', 26, 67),
(113, '2018-06-24 10:43:07', 26, 67),
(114, '2018-06-24 10:43:12', 26, 67),
(115, '2018-06-24 10:43:21', 26, 68),
(116, '2018-06-24 10:43:26', 26, 67),
(117, '2018-06-24 10:43:32', 26, 67),
(118, '2018-06-24 10:43:40', 26, 67),
(119, '2018-06-24 10:43:45', 18, 67),
(120, '2018-06-24 10:43:51', 26, 68),
(121, '2018-06-24 10:43:56', 26, 68),
(122, '2018-06-24 10:44:02', 26, 68),
(123, '2018-06-24 10:44:07', 26, 68),
(124, '2018-06-24 10:44:13', 26, 68),
(125, '2018-06-24 10:44:24', 26, 66),
(126, '2018-06-24 10:44:29', 26, 67),
(127, '2018-06-24 10:44:35', 26, 68),
(128, '2018-06-24 10:44:43', 26, 68),
(129, '2018-06-24 10:44:51', 26, 68),
(130, '2018-06-24 10:44:59', 26, 68),
(131, '2018-06-24 10:45:14', 26, 68),
(132, '2018-06-24 10:45:22', 26, 68),
(133, '2018-06-24 10:45:29', 26, 67),
(134, '2018-06-24 10:46:08', 26, 68),
(135, '2018-06-24 10:46:14', 26, 69),
(136, '2018-06-24 10:46:22', 26, 69),
(137, '2018-06-24 10:46:33', 26, 68),
(138, '2018-06-24 10:46:41', 26, 68),
(139, '2018-06-24 10:46:49', 26, 69),
(140, '2018-06-24 10:46:57', 26, 69),
(141, '2018-06-24 10:52:09', 26, 69),
(142, '2018-06-24 10:52:19', 26, 77),
(143, '2018-06-24 10:52:27', 26, 74),
(144, '2018-06-24 10:52:33', 26, 73),
(145, '2018-06-24 10:52:38', 26, 71),
(146, '2018-06-24 10:52:59', 26, 70),
(147, '2018-06-24 10:53:04', 26, 69),
(148, '2018-06-24 10:58:46', 26, 69),
(149, '2018-06-24 10:58:59', 26, 69),
(150, '2018-06-24 10:59:05', 26, 69),
(151, '2018-06-24 10:59:13', 26, 69),
(152, '2018-06-24 10:59:19', 26, 69),
(153, '2018-06-24 10:59:32', 26, 69),
(154, '2018-06-24 10:59:37', 26, 69),
(155, '2018-06-24 11:01:26', 26, 68),
(156, '2018-06-24 11:01:32', 26, 69),
(157, '2018-06-24 11:15:33', 27, 69),
(158, '2018-06-24 11:15:39', 26, 70),
(159, '2018-06-24 11:15:47', 26, 70),
(160, '2018-06-24 11:15:52', 26, 69),
(161, '2018-06-24 11:16:15', 26, 69),
(162, '2018-06-24 11:18:22', 26, 70),
(163, '2018-06-24 11:18:30', 26, 69),
(164, '2018-06-24 11:51:30', 26, 69),
(165, '2018-06-24 11:51:35', 26, 69),
(166, '2018-06-24 11:51:41', 26, 69),
(167, '2018-06-24 12:19:54', 26, 70),
(168, '2018-06-24 12:20:02', 26, 70),
(169, '2018-06-24 12:20:07', 26, 70),
(170, '2018-06-24 13:55:26', 27, 72),
(171, '2018-06-24 13:55:32', 26, 73),
(172, '2018-06-24 13:55:37', 26, 73),
(173, '2018-06-24 13:55:45', 26, 73),
(174, '2018-06-24 13:55:56', 26, 73),
(175, '2018-06-24 13:56:01', 26, 73),
(176, '2018-06-24 13:59:26', 26, 73),
(177, '2018-06-24 13:59:32', 26, 73),
(178, '2018-06-24 13:59:38', 26, 73),
(179, '2018-06-24 13:59:43', 26, 73),
(180, '2018-06-24 13:59:49', 26, 71),
(181, '2018-06-24 13:59:54', 26, 73),
(182, '2018-06-24 14:00:00', 26, 73),
(183, '2018-06-24 14:00:05', 26, 73),
(184, '2018-06-24 14:00:13', 26, 73),
(185, '2018-06-24 14:00:21', 26, 73),
(186, '2018-06-24 14:00:27', 26, 73),
(187, '2018-06-24 14:00:38', 26, 73),
(188, '2018-06-24 14:00:43', 26, 73),
(189, '2018-06-24 14:00:51', 26, 73),
(190, '2018-06-24 14:00:57', 26, 73),
(191, '2018-06-24 14:01:05', 26, 74),
(192, '2018-06-24 14:01:10', 26, 73),
(193, '2018-06-24 14:01:16', 26, 71),
(194, '2018-06-24 14:01:21', 26, 74),
(195, '2018-06-24 14:01:27', 26, 74),
(196, '2018-06-24 14:01:37', 26, 72),
(197, '2018-06-24 14:01:46', 26, 73),
(198, '2018-06-24 14:01:54', 26, 74),
(199, '2018-06-24 14:01:59', 26, 74),
(200, '2018-06-24 14:02:12', 26, 73),
(201, '2018-06-24 14:02:20', 26, 74),
(202, '2018-06-24 14:02:26', 26, 74),
(203, '2018-06-24 14:02:34', 26, 74),
(204, '2018-06-24 14:02:39', 26, 73),
(205, '2018-06-24 14:02:45', 26, 74),
(206, '2018-06-24 14:02:51', 26, 74),
(207, '2018-06-24 14:02:56', 26, 74),
(208, '2018-06-24 14:03:02', 26, 74),
(209, '2018-06-24 15:05:52', 26, 74),
(210, '2018-06-24 15:05:57', 26, 74),
(211, '2018-06-24 15:06:06', 26, 74),
(212, '2018-06-24 15:06:31', 26, 74),
(213, '2018-06-24 15:06:37', 26, 74),
(214, '2018-06-24 15:06:42', 26, 74),
(215, '2018-06-24 15:06:48', 26, 74),
(216, '2018-06-24 15:07:11', 26, 74),
(217, '2018-06-24 15:07:32', 26, 74),
(218, '2018-06-24 15:07:37', 26, 74),
(219, '2018-06-24 15:07:43', 26, 74),
(220, '2018-06-24 15:07:51', 26, 74),
(221, '2018-06-24 15:07:57', 26, 75),
(222, '2018-06-24 15:08:02', 26, 74),
(223, '2018-06-24 15:08:08', 26, 74),
(224, '2018-06-24 15:08:13', 26, 74),
(225, '2018-06-24 15:08:26', 26, 74),
(226, '2018-06-24 15:08:32', 26, 74),
(227, '2018-06-24 15:08:37', 26, 74),
(228, '2018-06-24 15:08:43', 26, 74),
(229, '2018-06-24 15:08:51', 26, 74),
(230, '2018-06-24 15:08:56', 26, 75),
(231, '2018-06-24 15:09:02', 26, 75),
(232, '2018-06-24 15:09:08', 26, 75),
(233, '2018-06-24 15:09:16', 26, 75),
(234, '2018-06-24 15:09:26', 26, 74),
(235, '2018-06-24 17:25:51', 0, 0),
(236, '2018-06-24 17:26:34', 0, 0),
(237, '2018-06-26 05:06:15', 22, 48),
(238, '2018-06-26 05:06:28', 22, 48),
(239, '2018-06-26 05:06:33', 22, 48),
(240, '2018-06-26 05:06:39', 22, 48),
(241, '2018-06-26 05:06:47', 22, 49),
(242, '2018-06-26 05:06:53', 22, 48),
(243, '2018-06-26 05:06:58', 22, 48),
(244, '2018-06-26 05:07:04', 22, 48),
(245, '2018-06-26 05:07:09', 22, 48),
(246, '2018-06-26 05:07:17', 22, 49),
(247, '2018-06-26 05:07:23', 22, 48),
(248, '2018-06-26 05:07:28', 22, 49),
(249, '2018-06-26 05:07:34', 22, 49),
(250, '2018-06-26 05:07:39', 22, 49),
(251, '2018-06-26 05:07:47', 22, 49),
(252, '2018-06-26 05:07:56', 23, 48),
(253, '2018-06-26 05:08:04', 23, 52),
(254, '2018-06-26 05:08:12', 23, 49),
(255, '2018-06-26 05:08:22', 23, 48),
(256, '2018-06-26 05:08:33', 23, 47),
(257, '2018-06-26 05:08:38', 23, 47),
(258, '2018-06-26 05:08:44', 23, 46),
(259, '2018-06-26 05:13:29', 23, 47),
(260, '2018-06-26 05:13:34', 23, 45),
(261, '2018-06-26 05:13:40', 23, 46),
(262, '2018-06-26 05:13:48', 23, 47),
(263, '2018-06-26 05:13:53', 23, 46),
(264, '2018-06-26 05:14:02', 23, 47),
(265, '2018-06-26 05:14:10', 23, 47),
(266, '2018-06-26 05:14:18', 23, 47),
(267, '2018-06-26 05:14:23', 23, 47),
(268, '2018-06-26 05:14:34', 23, 47),
(269, '2018-06-26 05:14:39', 23, 47),
(270, '2018-06-26 05:14:47', 23, 47),
(271, '2018-06-26 05:14:53', 23, 47),
(272, '2018-06-26 05:14:58', 23, 46),
(273, '2018-06-26 05:15:04', 23, 46),
(274, '2018-06-26 05:15:10', 23, 47),
(275, '2018-06-26 05:15:23', 23, 46),
(276, '2018-06-26 05:15:28', 23, 46),
(277, '2018-06-26 05:15:34', 23, 47),
(278, '2018-06-26 05:15:39', 23, 47),
(279, '2018-06-26 05:15:47', 23, 48),
(280, '2018-06-26 05:15:53', 23, 46),
(281, '2018-06-26 05:15:58', 23, 48),
(282, '2018-06-26 05:16:17', 23, 47),
(283, '2018-06-26 05:16:22', 23, 46),
(284, '2018-06-26 05:16:28', 23, 47),
(285, '2018-06-26 05:16:33', 23, 47),
(286, '2018-06-26 05:16:46', 23, 47),
(287, '2018-06-26 05:16:54', 23, 47),
(288, '2018-06-26 05:17:00', 23, 46),
(289, '2018-06-26 05:17:05', 23, 47),
(290, '2018-06-26 05:17:16', 23, 46),
(291, '2018-06-26 05:17:24', 23, 46),
(292, '2018-06-26 05:17:30', 23, 47),
(293, '2018-06-26 05:17:35', 23, 46),
(294, '2018-06-26 05:17:48', 23, 46),
(295, '2018-06-26 05:17:54', 23, 46),
(296, '2018-06-26 05:18:02', 23, 47),
(297, '2018-06-26 05:18:07', 23, 46),
(298, '2018-06-26 05:18:13', 23, 47),
(299, '2018-06-26 05:18:19', 23, 47),
(300, '2018-06-26 05:18:24', 23, 47),
(301, '2018-06-26 05:18:35', 23, 46),
(302, '2018-06-26 05:18:48', 23, 46),
(303, '2018-06-26 05:18:58', 23, 46),
(304, '2018-06-26 05:19:09', 23, 46),
(305, '2018-06-26 05:19:14', 23, 46),
(306, '2018-06-26 05:19:33', 23, 47),
(307, '2018-06-26 05:19:38', 23, 46),
(308, '2018-06-26 05:19:44', 23, 47),
(309, '2018-06-26 05:19:54', 23, 46),
(310, '2018-06-26 05:20:00', 23, 46),
(311, '2018-06-26 05:20:09', 23, 47),
(312, '2018-06-26 05:20:14', 23, 47),
(313, '2018-06-26 05:20:20', 23, 47),
(314, '2018-06-26 05:20:25', 23, 47),
(315, '2018-06-26 05:20:31', 23, 47),
(316, '2018-06-26 05:20:44', 23, 46),
(317, '2018-06-26 05:20:50', 23, 45),
(318, '2018-06-26 05:20:58', 23, 46),
(319, '2018-06-26 05:21:03', 23, 45),
(320, '2018-06-26 05:21:09', 23, 46),
(321, '2018-06-26 05:21:14', 23, 47),
(322, '2018-06-26 05:21:20', 23, 47),
(323, '2018-06-26 05:21:30', 23, 45),
(324, '2018-06-26 05:21:36', 23, 45),
(325, '2018-06-26 05:21:41', 23, 46),
(326, '2018-06-26 05:21:47', 23, 45),
(327, '2018-06-26 05:21:55', 23, 45),
(328, '2018-06-26 05:22:03', 23, 45),
(329, '2018-06-26 05:22:11', 23, 45),
(330, '2018-06-26 05:22:17', 23, 45),
(331, '2018-06-26 05:22:27', 23, 46),
(332, '2018-06-26 05:22:38', 23, 45),
(333, '2018-06-26 05:22:43', 23, 46),
(334, '2018-06-26 05:22:49', 23, 45),
(335, '2018-06-26 05:22:55', 23, 46),
(336, '2018-06-26 05:23:03', 23, 47),
(337, '2018-06-26 05:23:11', 23, 47),
(338, '2018-06-26 05:23:19', 23, 47),
(339, '2018-06-26 05:23:24', 23, 46),
(340, '2018-06-26 05:23:30', 23, 48),
(341, '2018-06-26 05:23:35', 23, 47),
(342, '2018-06-26 05:23:41', 23, 47),
(343, '2018-06-26 05:23:46', 23, 47),
(344, '2018-06-26 05:23:57', 23, 48),
(345, '2018-06-26 05:24:03', 23, 47),
(346, '2018-06-26 05:24:08', 23, 44),
(347, '2018-06-26 05:24:14', 23, 48),
(348, '2018-06-26 05:24:19', 23, 48),
(349, '2018-06-26 05:24:25', 23, 48),
(350, '2018-06-26 05:24:33', 23, 48),
(351, '2018-06-26 05:24:38', 23, 47),
(352, '2018-06-26 05:24:44', 23, 48),
(353, '2018-06-26 05:24:49', 23, 48),
(354, '2018-06-26 05:24:55', 23, 48),
(355, '2018-08-18 12:41:00', 0, 0),
(356, '2018-08-18 12:41:43', 0, 0),
(357, '2018-08-18 12:42:26', 0, 0),
(358, '2018-08-18 12:43:09', 0, 0),
(359, '2018-08-18 12:43:51', 0, 0),
(360, '2018-08-18 12:44:34', 0, 0),
(361, '2018-08-18 12:45:17', 0, 0),
(362, '2018-08-18 12:46:00', 0, 0),
(363, '2018-08-18 12:46:43', 0, 0),
(364, '2018-08-18 12:47:26', 0, 0),
(365, '2018-08-18 12:48:09', 0, 0),
(366, '2018-08-18 12:48:52', 0, 0),
(367, '2018-08-18 12:49:35', 0, 0),
(368, '2018-08-18 12:50:18', 0, 0),
(369, '2018-08-18 12:51:01', 0, 0),
(370, '2018-08-18 12:51:43', 0, 0),
(371, '2018-08-18 12:52:26', 0, 0),
(372, '2018-08-18 12:53:09', 0, 0),
(373, '2018-08-18 12:53:52', 0, 0),
(374, '2018-08-18 12:54:35', 0, 0),
(375, '2018-08-18 12:55:18', 0, 0),
(376, '2018-08-18 12:56:01', 0, 0),
(377, '2018-08-18 12:56:44', 0, 0),
(378, '2018-08-18 12:57:27', 0, 0),
(379, '2018-08-18 12:58:10', 0, 0),
(380, '2018-08-18 12:58:53', 0, 0),
(381, '2018-08-18 12:59:36', 0, 0),
(382, '2018-08-18 13:00:18', 0, 0),
(383, '2018-08-18 13:01:01', 0, 0),
(384, '2018-08-18 13:01:44', 0, 0),
(385, '2018-08-18 13:02:27', 0, 0),
(386, '2018-08-18 13:03:10', 0, 0),
(387, '2018-08-18 13:03:53', 0, 0),
(388, '2018-08-18 13:04:36', 0, 0),
(389, '2018-08-18 13:05:19', 0, 0),
(390, '2018-08-18 13:06:02', 0, 0),
(391, '2018-08-18 13:06:45', 0, 0),
(392, '2018-08-18 13:07:28', 0, 0),
(393, '2018-08-18 13:08:11', 0, 0),
(394, '2018-08-18 13:08:53', 0, 0),
(395, '2018-08-18 13:09:36', 0, 0),
(396, '2018-08-18 13:10:19', 0, 0),
(397, '2018-08-18 13:11:02', 0, 0),
(398, '2018-08-18 13:11:45', 0, 0),
(399, '2018-08-18 13:12:28', 0, 0),
(400, '2018-08-18 13:13:11', 0, 0),
(401, '2018-08-18 13:13:54', 0, 0),
(402, '2018-08-18 13:14:37', 0, 0),
(403, '2018-08-18 13:15:20', 0, 0),
(404, '2018-08-18 13:16:03', 0, 0),
(405, '2018-08-18 13:16:45', 0, 0),
(406, '2018-08-18 13:17:28', 0, 0),
(407, '2018-08-18 13:18:11', 0, 0),
(408, '2018-08-18 13:18:54', 0, 0),
(409, '2018-08-18 13:19:37', 0, 0),
(410, '2018-08-18 13:20:20', 0, 0),
(411, '2018-08-18 13:21:03', 0, 0),
(412, '2018-08-18 13:21:46', 0, 0),
(413, '2018-08-18 13:22:29', 0, 0),
(414, '2018-08-18 13:23:12', 0, 0),
(415, '2018-08-18 13:23:55', 0, 0),
(416, '2018-08-18 13:24:38', 0, 0),
(417, '2018-08-18 13:25:20', 0, 0),
(418, '2018-08-18 13:26:03', 0, 0),
(419, '2018-08-18 13:26:46', 0, 0),
(420, '2018-08-18 13:27:29', 0, 0),
(421, '2018-08-18 13:28:12', 0, 0),
(422, '2018-08-18 13:28:55', 0, 0),
(423, '2018-08-18 13:29:38', 0, 0),
(424, '2018-08-18 13:30:21', 0, 0),
(425, '2018-08-18 13:31:04', 0, 0),
(426, '2018-08-18 13:31:47', 0, 0),
(427, '2018-08-18 13:32:30', 0, 0),
(428, '2018-08-18 13:33:13', 0, 0),
(429, '2018-08-18 13:33:55', 0, 0),
(430, '2018-08-18 13:34:38', 0, 0),
(431, '2018-08-18 13:35:21', 0, 0),
(432, '2018-08-18 13:36:04', 0, 0),
(433, '2018-08-18 13:36:47', 0, 0),
(434, '2018-08-18 13:37:30', 0, 0),
(435, '2018-08-18 13:38:13', 0, 0),
(436, '2018-08-18 13:38:56', 0, 0),
(437, '2018-08-18 13:39:39', 0, 0),
(438, '2018-08-18 13:40:22', 0, 0),
(439, '2018-08-18 13:41:05', 0, 0),
(440, '2018-08-18 13:41:48', 0, 0),
(441, '2018-08-18 13:42:30', 0, 0),
(442, '2018-08-18 13:43:13', 0, 0),
(443, '2018-08-18 13:43:56', 0, 0),
(444, '2018-08-18 13:44:39', 0, 0),
(445, '2018-08-18 13:45:22', 0, 0),
(446, '2018-08-18 13:46:05', 0, 0),
(447, '2018-08-18 13:46:48', 0, 0),
(448, '2018-08-18 13:47:31', 0, 0),
(449, '2018-08-18 13:48:14', 0, 0),
(450, '2018-08-18 13:48:57', 0, 0),
(451, '2018-08-18 13:49:40', 0, 0),
(452, '2018-08-18 13:50:23', 0, 0),
(453, '2018-08-18 13:51:05', 0, 0),
(454, '2018-08-18 13:51:48', 0, 0),
(455, '2018-08-18 13:52:31', 0, 0),
(456, '2018-08-18 13:53:14', 0, 0),
(457, '2018-08-18 13:53:57', 0, 0),
(458, '2018-08-18 13:54:40', 0, 0),
(459, '2018-08-18 13:55:23', 0, 0),
(460, '2018-08-18 13:56:06', 0, 0),
(461, '2018-08-18 13:56:49', 0, 0),
(462, '2018-08-18 13:57:32', 0, 0),
(463, '2018-08-18 13:58:15', 0, 0),
(464, '2018-08-18 13:58:57', 0, 0),
(465, '2018-08-18 13:59:40', 0, 0),
(466, '2018-08-18 14:00:23', 0, 0),
(467, '2018-08-18 14:01:06', 0, 0),
(468, '2018-08-18 14:01:49', 0, 0),
(469, '2018-08-18 14:02:32', 0, 0),
(470, '2018-08-18 14:03:15', 0, 0),
(471, '2018-08-18 14:03:58', 0, 0),
(472, '2018-08-18 14:04:41', 0, 0),
(473, '2018-08-18 14:05:24', 0, 0),
(474, '2018-08-18 14:06:07', 0, 0),
(475, '2018-08-18 14:06:50', 0, 0),
(476, '2018-08-18 14:07:32', 0, 0),
(477, '2018-08-18 14:08:15', 0, 0),
(478, '2018-08-18 14:08:58', 0, 0),
(479, '2018-08-18 14:09:41', 0, 0),
(480, '2018-08-18 14:10:24', 0, 0),
(481, '2018-08-18 14:11:07', 0, 0),
(482, '2018-08-18 14:11:50', 0, 0),
(483, '2018-08-18 14:12:33', 0, 0),
(484, '2018-08-18 14:13:16', 0, 0),
(485, '2018-08-18 14:13:59', 0, 0),
(486, '2018-08-18 14:14:42', 0, 0),
(487, '2018-08-18 14:15:25', 0, 0),
(488, '2018-08-18 14:16:07', 0, 0),
(489, '2018-08-18 14:16:50', 0, 0),
(490, '2018-08-18 14:17:33', 0, 0),
(491, '2018-08-18 14:18:16', 0, 0),
(492, '2018-08-18 14:18:59', 0, 0),
(493, '2018-08-18 14:19:42', 0, 0),
(494, '2018-08-18 14:20:25', 0, 0),
(495, '2018-08-18 14:21:08', 0, 0),
(496, '2018-08-18 14:21:51', 0, 0),
(497, '2018-08-18 14:22:34', 0, 0),
(498, '2018-08-18 14:23:17', 0, 0),
(499, '2018-08-18 14:24:00', 0, 0),
(500, '2018-08-18 14:24:42', 0, 0),
(501, '2018-08-18 14:25:25', 0, 0),
(502, '2018-08-18 14:26:08', 0, 0),
(503, '2018-08-18 14:26:51', 0, 0),
(504, '2018-08-18 14:27:34', 0, 0),
(505, '2018-08-18 14:28:17', 0, 0),
(506, '2018-08-18 14:29:00', 0, 0),
(507, '2018-08-18 14:29:43', 0, 0),
(508, '2018-08-18 14:30:26', 0, 0),
(509, '2018-08-18 14:31:09', 0, 0),
(510, '2018-08-18 14:31:52', 0, 0),
(511, '2018-08-18 14:32:35', 0, 0),
(512, '2018-08-18 14:33:17', 0, 0),
(513, '2018-08-18 14:34:00', 0, 0),
(514, '2018-08-18 14:34:43', 0, 0),
(515, '2018-08-18 14:35:26', 0, 0),
(516, '2018-08-18 17:48:44', 0, 0),
(517, '2018-08-18 17:49:27', 0, 0),
(518, '2018-08-18 17:50:18', 0, 0),
(519, '2018-08-18 17:51:01', 0, 0),
(520, '2018-08-18 17:51:44', 0, 0),
(521, '2018-08-18 17:53:45', 0, 0),
(522, '2018-08-18 17:54:28', 0, 0),
(523, '2018-08-18 18:06:57', 0, 0),
(524, '2018-08-18 18:08:54', 0, 0),
(525, '2018-08-18 18:12:36', 0, 0),
(526, '2018-08-18 18:13:19', 0, 0),
(527, '2018-08-18 18:16:25', 0, 0),
(528, '2018-08-18 18:17:07', 0, 0),
(529, '2018-08-18 18:17:50', 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cards`
--
ALTER TABLE `cards`
 ADD PRIMARY KEY (`id`), ADD KEY `ix_cardId` (`id`);

--
-- Indexes for table `readings`
--
ALTER TABLE `readings`
 ADD PRIMARY KEY (`id`), ADD KEY `ix_id` (`id`);

--
-- Indexes for table `tempdata`
--
ALTER TABLE `tempdata`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cards`
--
ALTER TABLE `cards`
MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `readings`
--
ALTER TABLE `readings`
MODIFY `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=83;
--
-- AUTO_INCREMENT for table `tempdata`
--
ALTER TABLE `tempdata`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=530;
/*!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 */;
Credits

Int.Elligence

1 project • 0 followers
Smart Door Lock

Things used in this project

Hardware components

Software apps and online services

Story

Summary

Schematics

Full Fritzing Diagram

Full tutorial

Code

SQL File

Full Source Code

Credits

Int.Elligence

Comments

Embed the widget on your own site

Smart Door Lock

Smart Door Lock

Things used in this project

Hardware components

Software apps and online services

Story

Summary

Schematics

Full Fritzing Diagram

Full tutorial

Code

SQL File

Full Source Code

Credits

Int.Elligence

Comments

Related channels and tags
