Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.3
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:8889
- -- Generation Time: Dec 11, 2018 at 11:16 AM
- -- Server version: 5.6.35
- -- PHP Version: 7.1.8
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `project3`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `packets`
- --
- CREATE TABLE `packets` (
- `id` int(10) NOT NULL,
- `status` varchar(255) NOT NULL DEFAULT 'idle',
- `courier_id` int(11) NOT NULL,
- `to_address` varchar(512) NOT NULL,
- `lat` double NOT NULL,
- `lon` double NOT NULL,
- `node` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `packets`
- --
- INSERT INTO `packets` (`id`, `status`, `courier_id`, `to_address`, `lat`, `lon`, `node`) VALUES
- (1, 'idle', 0, 'Karel van Hulthemstraat 12, 9000 Gent', 51.0446757, 3.721016, 0),
- (3, 'idle', 0, 'Sint-Pietersnieuwstraat 45, 9000 Gent', 51.0455901, 3.7251713, 0),
- (4, 'idle', 0, 'Nederkouter 110, 9000 Gent', 51.0470121, 3.7197398, 0),
- (5, 'idle', 0, 'Blandijnberg 5, 9000 Gent', 51.0439686, 3.7227525, 0),
- (6, 'idle', 0, 'Overpoortstraat 34, 9000 Gent', 51.0400931, 3.7233923, 0),
- (297, 'idle', 0, '', 51.043485, 3.723932, 0),
- (298, 'idle', 0, '', 51.047977, 3.728863, 0),
- (299, 'idle', 0, '', 51.042019, 3.728698, 0),
- (300, 'idle', 0, '', 51.042555, 3.720357, 0),
- (301, 'idle', 0, '', 51.042561, 3.722045, 0),
- (302, 'idle', 0, '', 51.043134, 3.724323, 0),
- (303, 'idle', 0, '', 51.047334, 3.724708, 0),
- (304, 'idle', 0, '', 51.041777, 3.727336, 0),
- (305, 'idle', 0, '', 51.048438, 3.730352, 0),
- (306, 'idle', 0, '', 51.044337, 3.720382, 0),
- (307, 'idle', 0, '', 51.042627, 3.728537, 0),
- (308, 'idle', 0, '', 51.045282, 3.722672, 0),
- (309, 'idle', 0, '', 51.041258, 3.722188, 0),
- (310, 'idle', 0, '', 51.046707, 3.725604, 0),
- (311, 'idle', 0, '', 51.048924, 3.719109, 0),
- (312, 'idle', 0, '', 51.042441, 3.730275, 0),
- (313, 'idle', 0, '', 51.042952, 3.725846, 0),
- (314, 'idle', 0, '', 51.048458, 3.722301, 0),
- (315, 'idle', 0, '', 51.043038, 3.725113, 0),
- (316, 'idle', 0, '', 51.047256, 3.722539, 0),
- (317, 'idle', 0, '', 51.043845, 3.726641, 0),
- (318, 'idle', 0, '', 51.041062, 3.729263, 0),
- (319, 'idle', 0, '', 51.045854, 3.727826, 0),
- (320, 'idle', 0, '', 51.043658, 3.723671, 0),
- (321, 'idle', 0, '', 51.047447, 3.728643, 0),
- (322, 'idle', 0, '', 51.042654, 3.723493, 0),
- (323, 'idle', 0, '', 51.043264, 3.730123, 0),
- (324, 'idle', 0, '', 51.04754, 3.721685, 0),
- (325, 'idle', 0, '', 51.044362, 3.721624, 0),
- (326, 'idle', 0, '', 51.042615, 3.723114, 0);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `packets`
- --
- ALTER TABLE `packets`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `packets`
- --
- ALTER TABLE `packets`
- MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=327;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement