H18Pbai2

1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Oct 12, 2019 at 01:53 PM
7-- Server version: 5.7.26
8-- PHP Version: 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `mlan`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `request`
29--
30
31DROP TABLE IF EXISTS `request`;
32CREATE TABLE IF NOT EXISTS `request` (
33  `requestid` int(10) NOT NULL AUTO_INCREMENT,
34  `name` varchar(15) NOT NULL,
35  `hpnumber` varchar(13) NOT NULL,
36  `latitude` varchar(20) NOT NULL,
37  `longitude` varchar(20) NOT NULL,
38  `timeadded` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
39  `message` varchar(150) NOT NULL,
40  `prioritylevel` int(1) NOT NULL,
41  `status` int(1) NOT NULL DEFAULT '1',
42  PRIMARY KEY (`requestid`)
43) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
44
45--
46-- Dumping data for table `request`
47--
48
49INSERT INTO `request` (`requestid`, `name`, `hpnumber`, `latitude`, `longitude`, `timeadded`, `message`, `prioritylevel`, `status`) VALUES
50(1, 'asdf', '01234523213', '3.0548861919103056', '101.70040212684083', '2019-10-12 15:41:29', 'i wanna die', 3, 1),
51(2, ' dkjabsdk', '3123', '312312', '312312', '2019-10-12 21:12:53', 'ddasdas', 2, 0),
52(3, ' dkjabsdk', '3123', '312312', '312312', '2019-10-12 21:13:08', 'ddasdas', 1, 1),
53(4, 'fwefwe', '321312', '31231', '312312', '2019-10-12 21:16:48', 'dsfsd', 3, 1),
54(5, 'fwefwe', '321312', '31231', '312312', '2019-10-12 21:17:07', 'dsfsd', 2, 1),
55(6, 'fwevsdvsfwe', '321312', '31231', '312312', '2019-10-12 21:17:31', 'dsfsd', 2, 1);
56COMMIT;
57
58/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
59/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
60/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;