Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.5.3.1
- -- http://www.phpmyadmin.net
- --
- -- Host: 31.24.128.142:3306
- -- Generation Time: 15. Apr, 2018 04:02 AM
- -- Server-versjon: 5.7.19
- -- PHP Version: 5.6.31
- 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: `74354_tools`
- --
- -- --------------------------------------------------------
- --
- -- Tabellstruktur for tabell `tools_reservations`
- --
- CREATE TABLE `tools_reservations` (
- `id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `tool_id` int(11) NOT NULL,
- `reservedFrom` datetime NOT NULL,
- `reservedTo` datetime NOT NULL,
- `reservedDate` datetime NOT NULL,
- `comment` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dataark for tabell `tools_reservations`
- --
- INSERT INTO `tools_reservations` (`id`, `user_id`, `tool_id`, `reservedFrom`, `reservedTo`, `reservedDate`, `comment`) VALUES
- (1, 2, 1, '2018-04-10 00:00:00', '2018-04-10 00:00:00', '2018-04-09 23:33:29', 'test'),
- (2, 2, 2, '2018-04-16 00:00:00', '2018-04-20 00:00:00', '2018-04-09 23:33:52', 'test');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `tools_reservations`
- --
- ALTER TABLE `tools_reservations`
- ADD PRIMARY KEY (`id`),
- ADD KEY `tool_id` (`tool_id`),
- ADD KEY `user_id` (`user_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `tools_reservations`
- --
- ALTER TABLE `tools_reservations`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- Begrensninger for dumpede tabeller
- --
- --
- -- Begrensninger for tabell `tools_reservations`
- --
- ALTER TABLE `tools_reservations`
- ADD CONSTRAINT `tools_reservations_ibfk_1` FOREIGN KEY (`tool_id`) REFERENCES `tools` (`id`),
- ADD CONSTRAINT `tools_reservations_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement