Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.5.2
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Feb 11, 2016 at 04:01 PM
- -- Server version: 10.1.9-MariaDB
- -- PHP Version: 5.6.15
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `iot`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `logs`
- --
- CREATE TABLE `logs` (
- `id` int(11) NOT NULL,
- `device` varchar(300) NOT NULL,
- `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `value` double(10,2) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `sections`
- --
- CREATE TABLE `sections` (
- `id` int(11) NOT NULL,
- `name` varchar(300) NOT NULL,
- `text` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE `users` (
- `id` int(10) UNSIGNED NOT NULL,
- `name` varchar(300) NOT NULL,
- `username` varchar(10) DEFAULT NULL,
- `password` varchar(255) DEFAULT NULL,
- `email` varchar(300) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `users`
- --
- INSERT INTO `users` (`id`, `name`, `username`, `password`, `email`) VALUES
- (1, 'Santiago', 'admin', '8665dedf24c124090cb3fea4f348d4ae4044464d', 'srestrepo@premexcorp.com');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `logs`
- --
- ALTER TABLE `logs`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `sections`
- --
- ALTER TABLE `sections`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `users`
- --
- ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `logs`
- --
- ALTER TABLE `logs`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `sections`
- --
- ALTER TABLE `sections`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement