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