API tools faq
paste
Advertisement
Guest User

SwitchData

a guest
Jul 10th, 2018
396
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.45 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Host:                         ***
  3. -- Server version:               5.5.54-0+deb8u1 - (Raspbian)
  4. -- Server OS:                    debian-linux-gnu
  5. -- HeidiSQL Version:             9.5.0.5279
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14.  
  15. -- Dumping database structure for automation
  16. CREATE DATABASE IF NOT EXISTS `automation` /*!40100 DEFAULT CHARACTER SET utf8 */;
  17. USE `automation`;
  18.  
  19. -- Dumping structure for table automation.feedsdata
  20. CREATE TABLE IF NOT EXISTS `feedsdata` (
  21.   `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  22.   `FeedId` int(11) NOT NULL,
  23.   `DateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  24.   `Value` varchar(512) NOT NULL,
  25.   PRIMARY KEY (`Id`),
  26.   KEY `IX_feedsdata_FeedId` (`FeedId`),
  27.   KEY `IX_DateTime` (`DateTime`)  
  28. ) ENGINE=InnoDB AUTO_INCREMENT=425588 DEFAULT CHARSET=utf8;
  29.  
  30. -- Dumping data for table automation.feedsdata
  31. /*!40000 ALTER TABLE `feedsdata` DISABLE KEYS */;
  32. INSERT INTO `feedsdata` (`Id`, `FeedId`, `DateTime`, `Value`) VALUES
  33.     (424334, 27, '2018-07-10 13:44:13', 'off'),
  34.     (424366, 27, '2018-07-10 13:47:27', 'on'),
  35.     (424400, 27, '2018-07-10 13:57:27', 'on'),
  36.     (424414, 27, '2018-07-10 14:02:09', 'on'),
  37.     (424427, 27, '2018-07-10 14:07:27', 'on'),
  38.     (424434, 27, '2018-07-10 14:09:09', 'on'),
  39.     (424437, 27, '2018-07-10 14:11:09', 'on'),
  40.     (424459, 27, '2018-07-10 14:17:27', 'on'),
  41.     (424462, 27, '2018-07-10 14:19:10', 'on'),
  42.     (424475, 27, '2018-07-10 14:27:27', 'on'),
  43.     (424495, 27, '2018-07-10 14:34:48', 'off'),
  44.     (424510, 27, '2018-07-10 14:44:47', 'off'),
  45.     (424524, 27, '2018-07-10 14:54:48', 'off'),
  46.     (424540, 27, '2018-07-10 15:04:47', 'off'),
  47.     (424551, 27, '2018-07-10 15:14:47', 'off'),
  48.     (424567, 27, '2018-07-10 15:24:48', 'off'),
  49.     (424583, 27, '2018-07-10 15:34:48', 'off'),
  50.     (424588, 27, '2018-07-10 15:44:48', 'off'),
  51.     (424600, 27, '2018-07-10 15:48:52', 'on'),
  52.     (424603, 27, '2018-07-10 15:49:08', 'off'),
  53.     (424606, 27, '2018-07-10 15:59:07', 'off'),
  54.     (424618, 27, '2018-07-10 16:05:09', 'off'),
  55.     (424621, 27, '2018-07-10 16:09:07', 'off'),
  56.     (424635, 27, '2018-07-10 16:19:07', 'off'),
  57.     (424666, 27, '2018-07-10 16:29:07', 'off'),
  58.     (424786, 27, '2018-07-10 16:39:07', 'off'),
  59.     (424801, 27, '2018-07-10 16:41:09', 'off'),
  60.     (424851, 27, '2018-07-10 16:46:09', 'off'),
  61.     (424854, 27, '2018-07-10 16:49:07', 'off'),
  62.     (424857, 27, '2018-07-10 16:59:07', 'off'),
  63.     (424869, 27, '2018-07-10 17:00:14', 'on'),
  64.     (424882, 27, '2018-07-10 17:10:08', 'on'),
  65.     (424889, 27, '2018-07-10 17:12:09', 'on'),
  66.     (424899, 27, '2018-07-10 17:14:15', 'off'),
  67.     (424911, 27, '2018-07-10 17:16:10', 'off'),
  68.     (424916, 27, '2018-07-10 17:20:09', 'off'),
  69.     (424919, 27, '2018-07-10 17:24:15', 'off'),
  70.     (424933, 27, '2018-07-10 17:34:15', 'off'),
  71.     (424938, 27, '2018-07-10 17:44:15', 'off'),
  72.     (424952, 27, '2018-07-10 17:52:10', 'off'),
  73.     (424957, 27, '2018-07-10 17:54:15', 'off'),
  74.     (424960, 27, '2018-07-10 17:55:03', 'on'),
  75.     (424978, 27, '2018-07-10 18:05:03', 'on'),
  76.     (424981, 27, '2018-07-10 18:05:09', 'on'),
  77.     (425011, 27, '2018-07-10 18:15:03', 'on'),
  78.     (425016, 27, '2018-07-10 18:15:43', 'off'),
  79.     (425021, 27, '2018-07-10 18:25:43', 'off'),
  80.     (425033, 27, '2018-07-10 18:35:43', 'off'),
  81.     (425047, 27, '2018-07-10 18:45:43', 'off'),
  82.     (425050, 27, '2018-07-10 18:55:43', 'off'),
  83.     (425062, 27, '2018-07-10 19:05:43', 'off'),
  84.     (425076, 27, '2018-07-10 19:15:43', 'off'),
  85.     (425079, 27, '2018-07-10 19:16:09', 'off'),
  86.     (425082, 27, '2018-07-10 19:21:09', 'off'),
  87.     (425089, 27, '2018-07-10 19:25:43', 'off'),
  88.     (425110, 27, '2018-07-10 19:35:43', 'off'),
  89.     (425128, 27, '2018-07-10 19:45:44', 'off'),
  90.     (425133, 27, '2018-07-10 19:50:09', 'off'),
  91.     (425137, 27, '2018-07-10 19:53:09', 'off'),
  92.     (425142, 27, '2018-07-10 19:55:43', 'off'),
  93.     (425158, 27, '2018-07-10 20:05:43', 'off'),
  94.     (425176, 27, '2018-07-10 20:15:43', 'off'),
  95.     (425180, 27, '2018-07-10 20:20:09', 'off'),
  96.     (425185, 27, '2018-07-10 20:25:43', 'off'),
  97.     (425203, 27, '2018-07-10 20:35:43', 'off'),
  98.     (425207, 27, '2018-07-10 20:39:09', 'off'),
  99.     (425223, 27, '2018-07-10 20:45:43', 'off'),
  100.     (425228, 27, '2018-07-10 20:50:09', 'off'),
  101.     (425233, 27, '2018-07-10 20:55:43', 'off'),
  102.     (425247, 27, '2018-07-10 21:00:15', 'off'),
  103.     (425252, 27, '2018-07-10 21:05:43', 'off'),
  104.     (425270, 27, '2018-07-10 21:15:43', 'off'),
  105.     (425276, 27, '2018-07-10 21:24:09', 'off'),
  106.     (425279, 27, '2018-07-10 21:25:43', 'off'),
  107.     (425295, 27, '2018-07-10 21:35:43', 'off'),
  108.     (425312, 27, '2018-07-10 21:45:43', 'off'),
  109.     (425325, 27, '2018-07-10 21:55:43', 'off'),
  110.     (425328, 27, '2018-07-10 21:58:09', 'off'),
  111.     (425342, 27, '2018-07-10 22:01:09', 'off'),
  112.     (425346, 27, '2018-07-10 22:05:43', 'off'),
  113.     (425364, 27, '2018-07-10 22:15:43', 'off'),
  114.     (425367, 27, '2018-07-10 22:16:09', 'off'),
  115.     (425370, 27, '2018-07-10 22:17:09', 'off'),
  116.     (425374, 27, '2018-07-10 22:20:09', 'off'),
  117.     (425379, 27, '2018-07-10 22:25:43', 'off'),
  118.     (425382, 27, '2018-07-10 22:26:09', 'off'),
  119.     (425386, 27, '2018-07-10 22:28:09', 'off'),
  120.     (425408, 27, '2018-07-10 22:35:43', 'off'),
  121.     (425426, 27, '2018-07-10 22:45:43', 'off'),
  122.     (425429, 27, '2018-07-10 22:52:09', 'off'),
  123.     (425432, 27, '2018-07-10 22:55:43', 'off'),
  124.     (425444, 27, '2018-07-10 23:00:44', 'on'),
  125.     (425447, 27, '2018-07-10 23:01:09', 'on'),
  126.     (425450, 27, '2018-07-10 23:02:09', 'on'),
  127.     (425471, 27, '2018-07-10 23:10:44', 'on'),
  128.     (425487, 27, '2018-07-10 23:20:45', 'on'),
  129.     (425505, 27, '2018-07-10 23:30:15', 'off'),
  130.     (425510, 27, '2018-07-10 23:40:07', 'off'),
  131.     (425524, 27, '2018-07-10 23:50:07', 'off'),
  132.     (425527, 27, '2018-07-10 23:50:09', 'off'),
  133.     (425532, 27, '2018-07-10 23:53:09', 'off'),
  134.     (425535, 27, '2018-07-10 23:55:09', 'off'),
  135.     (425555, 27, '2018-07-11 00:00:07', 'off'),
  136.     (425559, 27, '2018-07-11 00:01:09', 'off'),
  137.     (425565, 27, '2018-07-11 00:10:07', 'off'),
  138.     (425581, 27, '2018-07-11 00:20:07', 'off'),
  139.     (425584, 27, '2018-07-11 00:21:09', 'off'),
  140.     (425587, 27, '2018-07-11 00:25:09', 'off');
  141. /*!40000 ALTER TABLE `feedsdata` ENABLE KEYS */;
  142.  
  143. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  144. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  145. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!