— phpMyAdmin SQL Dump
— version 4.6.5.1
— https://www.phpmyadmin.net/

— Host: localhost
— Generation Time: Jan 03, 2017 at 06:36 AM
— Server version: 10.1.18-MariaDB
— PHP Version: 7.0.8

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


— Database: `ruralk5_id317840_myiot`

— CREATE DATABASE IF NOT EXISTS `ruralk5_id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `ruralk5_id317840_myiot`;

— ——————————————————–


— Table structure for table `Security`

CREATE TABLE `Security` (
`userid` int(11) NOT NULL,
`Username` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`Password` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


— Dumping data for table `Security`

INSERT INTO `Security` (`userid`, `Username`, `Password`) VALUES
(1, ‘sivam’, ‘siva’);

— ——————————————————–


— 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);


— Indexes for dumped tables


— Indexes for table `Security`

ALTER TABLE `Security`
ADD PRIMARY KEY (`userid`),
ADD UNIQUE KEY `Username` (`Username`);


— AUTO_INCREMENT for dumped tables


— AUTO_INCREMENT for table `Security`

ALTER TABLE `Security`
MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;–
— Database: `ruralk5_id317840_myiot`

— CREATE DATABASE IF NOT EXISTS `ruralk5_id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `ruralk5_id317840_myiot`;

— ——————————————————–


— Table structure for table `Security`

CREATE TABLE `Security` (
`userid` int(11) NOT NULL,
`Username` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`Password` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


— Dumping data for table `Security`

INSERT INTO `Security` (`userid`, `Username`, `Password`) VALUES
(1, ‘sivam’, ‘siva’);

— ——————————————————–


— 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);


— Indexes for dumped tables


— Indexes for table `Security`

ALTER TABLE `Security`
ADD PRIMARY KEY (`userid`),
ADD UNIQUE KEY `Username` (`GreenSync`);


— AUTO_INCREMENT for dumped tables


— AUTO_INCREMENT for table `Security`

ALTER TABLE `Security`
MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;–
— Database: `ruralk5_id317840_myiot`

— CREATE DATABASE IF NOT EXISTS `ruralk5_id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `ruralk5_id317840_myiot`;

— ——————————————————–


— Table structure for table `Security`

CREATE TABLE `Security` (
`userid` int(11) NOT NULL,
`Username` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`Password` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


— Dumping data for table `Security`

INSERT INTO `Security` (`userid`, `Username`, `Password`) VALUES
(1, ‘ruralk5_GreenSync’, ‘greensync123#’);

— ——————————————————–


— 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);


— Indexes for dumped tables


— Indexes for table `Security`

ALTER TABLE `Security`
ADD PRIMARY KEY (`userid`),
ADD UNIQUE KEY `Username` (`Username`);


— AUTO_INCREMENT for dumped tables


— AUTO_INCREMENT for table `Security`

ALTER TABLE `Security`
MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;–
— Database: `ruralk5_id317840_myiot`

— CREATE DATABASE IF NOT EXISTS `ruralk5_id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `ruralk5_id317840_myiot`;

— ——————————————————–


— Table structure for table `Security`

CREATE TABLE `Security` (
`userid` int(11) NOT NULL,
`Username` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`Password` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


— Dumping data for table `Security`

INSERT INTO `Security` (`userid`, `Username`, `Password`) VALUES
(1, ‘GreenSync’, ‘greensync123@’);

— ——————————————————–


— 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);


— Indexes for dumped tables


— Indexes for table `Security`

ALTER TABLE `Security`
ADD PRIMARY KEY (`userid`),
ADD UNIQUE KEY `Username` (`Username`);


— AUTO_INCREMENT for dumped tables


— AUTO_INCREMENT for table `Security`

ALTER TABLE `Security`
MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;–
— Database: `ruralk5_id317840_myiot`

— CREATE DATABASE IF NOT EXISTS `ruralk5_id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `ruralk5_id317840_myiot`;

— ——————————————————–


— Table structure for table `Security`

CREATE TABLE `Security` (
`userid` int(11) NOT NULL,
`Username` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`Password` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


— Dumping data for table `Security`

INSERT INTO `Security` (`userid`, `Username`, `Password`) VALUES
(1, ‘ruralk5_GreenSync’, ‘ruralk5_greensync123#’);

— ——————————————————–


— 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);


— Indexes for dumped tables


— Indexes for table `Security`

ALTER TABLE `Security`
ADD PRIMARY KEY (`userid`),
ADD UNIQUE KEY `Username` (`Username`);


— AUTO_INCREMENT for dumped tables


— AUTO_INCREMENT for table `Security`

ALTER TABLE `Security`
MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;–
— Database: `ruralk5_id317840_myiot`

— CREATE DATABASE IF NOT EXISTS `ruralk5_id317840_myiot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `ruralk5_id317840_myiot`;

— ——————————————————–


— Table structure for table `Security`

CREATE TABLE `Security` (
`userid` int(11) NOT NULL,
`Username` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`Password` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


— Dumping data for table `Security`

INSERT INTO `Security` (`userid`, `Username`, `Password`) VALUES
(1, ‘ruralk5_GreenSync’, ‘greensync123@’);

— ——————————————————–


— 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);


— Indexes for dumped tables


— Indexes for table `Security`

ALTER TABLE `Security`
ADD PRIMARY KEY (`userid`),
ADD UNIQUE KEY `Username` (`Username`);


— AUTO_INCREMENT for dumped tables


— AUTO_INCREMENT for table `Security`

ALTER TABLE `Security`
MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!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 */;