-- https://www.phpmyadmin.net/
--




--
-- Database: `id317840_myiot`
--
CREATE DATABASE IF NOT EXISTS `id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id317840_myiot`;

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

--
-- Table structure for table `Sensorsvalue`
--

CREATE TABLE `Sensorsvalue` (
  `Updatedatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `Sensor1` int(11) NOT NULL,
  `Sensor2` int(11) NOT NULL,
  `Sensor3` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Sensorsvalue`
--

INSERT INTO `Sensorsvalue` (`Updatedatetime`, `Sensor1`, `Sensor2`, `Sensor3`, `userid`) VALUES
('2016-12-12 09:47:58', 50, 60, 80, 1),
('2016-12-13 11:15:22', 1, 2, 3, 1),
('2016-12-13 12:29:36', 100, 200, 300, 1);

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

--
-- Table structure for table `Switchstatus`
--

CREATE TABLE `Switchstatus` (
  `Currentstatus` int(11) NOT NULL,
  `lupdatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Switchstatus`
--

INSERT INTO `Switchstatus` (`Currentstatus`, `lupdatetime`, `userid`) VALUES
(50, '2016-12-13 12:15:46', 1);
-- Database: `id317840_myiot`
--
CREATE DATABASE IF NOT EXISTS `id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id317840_myiot`;

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

--
-- Table structure for table `Sensorsvalue`
--

CREATE TABLE `Sensorsvalue` (
  `Updatedatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `Sensor1` int(11) NOT NULL,
  `Sensor2` int(11) NOT NULL,
  `Sensor3` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Sensorsvalue`
--

INSERT INTO `Sensorsvalue` (`Updatedatetime`, `Sensor1`, `Sensor2`, `Sensor3`, `userid`) VALUES
('2016-12-12 09:47:58', 50, 60, 80, 1),
('2016-12-13 11:15:22', 1, 2, 3, 1),
('2016-12-13 12:29:36', 100, 200, 300, 1);

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

--
-- Table structure for table `Switchstatus`
--

CREATE TABLE `Switchstatus` (
  `Currentstatus` int(11) NOT NULL,
  `lupdatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Switchstatus`
--

INSERT INTO `Switchstatus` (`Currentstatus`, `lupdatetime`, `userid`) VALUES
(50, '2016-12-13 12:15:46', 1);
-- Database: `id317840_myiot`
--
CREATE DATABASE IF NOT EXISTS `id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id317840_myiot`;

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

--
-- Table structure for table `Sensorsvalue`
--

CREATE TABLE `Sensorsvalue` (
  `Updatedatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `Sensor1` int(11) NOT NULL,
  `Sensor2` int(11) NOT NULL,
  `Sensor3` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Sensorsvalue`
--

INSERT INTO `Sensorsvalue` (`Updatedatetime`, `Sensor1`, `Sensor2`, `Sensor3`, `userid`) VALUES
('2016-12-12 09:47:58', 50, 60, 80, 1),
('2016-12-13 11:15:22', 1, 2, 3, 1),
('2016-12-13 12:29:36', 100, 200, 300, 1);

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

--
-- Table structure for table `Switchstatus`
--

CREATE TABLE `Switchstatus` (
  `Currentstatus` int(11) NOT NULL,
  `lupdatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Switchstatus`
--

INSERT INTO `Switchstatus` (`Currentstatus`, `lupdatetime`, `userid`) VALUES
(50, '2016-12-13 12:15:46', 1);
-- Database: `id317840_myiot`
--
CREATE DATABASE IF NOT EXISTS `id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id317840_myiot`;

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

--
-- Table structure for table `Sensorsvalue`
--

CREATE TABLE `Sensorsvalue` (
  `Updatedatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `Sensor1` int(11) NOT NULL,
  `Sensor2` int(11) NOT NULL,
  `Sensor3` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Sensorsvalue`
--

INSERT INTO `Sensorsvalue` (`Updatedatetime`, `Sensor1`, `Sensor2`, `Sensor3`, `userid`) VALUES
('2016-12-12 09:47:58', 50, 60, 80, 1),
('2016-12-13 11:15:22', 1, 2, 3, 1),
('2016-12-13 12:29:36', 100, 200, 300, 1);

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

--
-- Table structure for table `Switchstatus`
--

CREATE TABLE `Switchstatus` (
  `Currentstatus` int(11) NOT NULL,
  `lupdatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Switchstatus`
--

INSERT INTO `Switchstatus` (`Currentstatus`, `lupdatetime`, `userid`) VALUES
(50, '2016-12-13 12:15:46', 1);
-- Database: `id317840_myiot`
--
CREATE DATABASE IF NOT EXISTS `id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id317840_myiot`;

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

--
-- Table structure for table `Sensorsvalue`
--

CREATE TABLE `Sensorsvalue` (
  `Updatedatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `Sensor1` int(11) NOT NULL,
  `Sensor2` int(11) NOT NULL,
  `Sensor3` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Sensorsvalue`
--

INSERT INTO `Sensorsvalue` (`Updatedatetime`, `Sensor1`, `Sensor2`, `Sensor3`, `userid`) VALUES
('2016-12-12 09:47:58', 50, 60, 80, 1),
('2016-12-13 11:15:22', 1, 2, 3, 1),
('2016-12-13 12:29:36', 100, 200, 300, 1);

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

--
-- Table structure for table `Switchstatus`
--

CREATE TABLE `Switchstatus` (
  `Currentstatus` int(11) NOT NULL,
  `lupdatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Switchstatus`
--

INSERT INTO `Switchstatus` (`Currentstatus`, `lupdatetime`, `userid`) VALUES
(50, '2016-12-13 12:15:46', 1);
-- Database: `id317840_myiot`
--
CREATE DATABASE IF NOT EXISTS `id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id317840_myiot`;

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

--
-- Table structure for table `Sensorsvalue`
--

CREATE TABLE `Sensorsvalue` (
  `Updatedatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `Sensor1` int(11) NOT NULL,
  `Sensor2` int(11) NOT NULL,
  `Sensor3` int(11) NOT NULL,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Sensorsvalue`
--

INSERT INTO `Sensorsvalue` (`Updatedatetime`, `Sensor1`, `Sensor2`, `Sensor3`, `userid`) VALUES
('2016-12-12 09:47:58', 50, 60, 80, 1),
('2016-12-13 11:15:22', 1, 2, 3, 1),
('2016-12-13 12:29:36', 100, 200, 300, 1);

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

--
-- Table structure for table `Switchstatus`
--

CREATE TABLE `Switchstatus` (
  `Currentstatus` int(11) NOT NULL,
  `lupdatetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Switchstatus`
--

INSERT INTO `Switchstatus` (`Currentstatus`, `lupdatetime`, `userid`) VALUES
(50, '2016-12-13 12:15:46', 1);
