-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathhackathon.sql
More file actions
100 lines (85 loc) · 6.22 KB
/
hackathon.sql
File metadata and controls
100 lines (85 loc) · 6.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 27, 2015 at 12:15 AM
-- Server version: 5.6.16
-- PHP Version: 5.5.9
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 utf8 */;
--
-- Database: `hackathon`
--
CREATE DATABASE IF NOT EXISTS `hackathon` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `hackathon`;
-- --------------------------------------------------------
--
-- Table structure for table `reports`
--
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plate_number` varchar(10) NOT NULL,
`vehicle_type` varchar(256) NOT NULL,
`date_incident` datetime NOT NULL,
`date_submitted` datetime NOT NULL,
`incident_type` varchar(100) NOT NULL,
`location` varchar(100) NOT NULL,
`lat` double NOT NULL,
`lon` double NOT NULL,
`description` mediumtext NOT NULL,
`image` varchar(100) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
--
-- Dumping data for table `reports`
--
INSERT INTO `reports` (`id`, `plate_number`, `vehicle_type`, `date_incident`, `date_submitted`, `incident_type`, `location`, `lat`, `lon`, `description`, `image`, `score`) VALUES
(1, 'ABC-123', 'Taxi', '2015-04-01 00:00:00', '0000-00-00 00:00:00', 'Theft', 'Quezon City', 14.63, 121.03, 'Black hair', 'report1.jpg', 1),
(2, 'AAA-1234', 'Jeep', '2015-04-15 00:00:00', '0000-00-00 00:00:00', 'Bullying', 'Quezon City', 14.58, 121, 'Taxi', 'report2.png', -2),
(5, 'ABC-123', 'Taxi', '2015-04-24 00:00:00', '2015-04-24 00:00:00', 'Bullying', 'Quezon City', 14.67, 121.05, 'asdf', 'asdf', 2),
(6, 'JKL-234', 'Jeep', '2015-04-25 00:00:00', '2015-04-24 00:00:00', 'Overcharging', 'UP Sunken Garden, Roxas Avenue, Quezon City, Metro Manila, Philippines', 14.655216, 121.07184800000005, 'Toki jeep is like shizz', 'asdf', 0),
(7, 'KLO-456', 'Jeep', '2015-04-11 00:00:00', '2015-04-24 00:00:00', 'Overcharging', 'UP Sunken Garden, Roxas Avenue, Quezon City, Metro Manila, Philippines', 14.655216, 121.07184800000005, 'hello', 'asdf', 0),
(8, 'QWE-123', 'Taxi', '2015-04-03 00:00:00', '2015-04-24 00:00:00', 'Violation of Traffic Laws', 'U.P. Village, Quezon City, Metro Manila, Philippines', 14.648611, 121.05611099999999, 'oye', 'asdf', 0),
(9, 'FGH-456', 'Jeep', '2015-04-25 00:00:00', '2015-04-24 00:00:00', 'Overcharging', 'Krus na Ligas, Quezon City, Metro Manila, Philippines', 14.641984, 121.06289140000001, 'adsfhjkl', 'asdf', 0),
(10, 'FGH-455', 'Jeep', '2015-04-25 00:00:00', '2015-04-24 00:00:00', 'Overcharging', 'Krus na Ligas, Quezon City, Metro Manila, Philippines', 14.641984, 121.06289140000001, 'adsfhjkl', 'asdf', 0),
(12, 'FGH-415', 'Jeep', '2015-04-25 00:00:00', '2015-04-24 00:00:00', 'Overcharging', 'Krus na Ligas, Quezon City, Metro Manila, Philippines', 14.641984, 121.06289140000001, 'adsfhjkl', 'asdf', 0),
(13, 'GJL-789', 'Jeep', '2015-04-25 00:00:00', '2015-04-24 00:00:00', 'Violation of Traffic Laws', 'UP Diliman Monorail, Quezon City, Metro Manila, Philippines', 14.6537054, 121.0604525, 'ashdaslfj', 'asdf', 0),
(14, 'GJL-789', 'Jeep', '2015-04-25 00:00:00', '2015-04-24 00:00:00', 'Violation of Traffic Laws', 'UP Diliman Monorail, Quezon City, Metro Manila, Philippines', 14.6537054, 121.0604525, 'ashdaslfj', 'asdf', 0),
(15, 'GDF-567', 'Jeep', '2015-04-25 00:00:00', '2015-04-25 00:00:00', 'Overcharging', 'Krus na Ligas, Quezon City, Metro Manila, Philippines', 14.641984, 121.06289140000001, 'Overcharging si kuya ikot driver', 'asdf', 0),
(16, 'ABC-124', 'Jeep', '2015-04-25 00:00:00', '2015-04-25 00:00:00', 'Overcharging', 'Pantranco Jeepney Stop, Quezon City, Metro Manila, Philippines', 14.654326, 121.07307200000002, 'overcharging si kuya ng 1cent', 'asdf', 0),
(17, 'AZX-543', 'Taxi', '2015-04-25 00:00:00', '2015-04-25 00:00:00', 'Harassment', 'University of the Philippines Diliman, Quezon City, Metro Manila, Philippines', 14.6526624, 121.06504100000006, 'ouch', 'asdf', 0),
(18, 'FJK-432', 'Bus', '2015-04-25 00:00:00', '2015-04-25 00:00:00', 'Violation of Traffic Laws', 'Litex, Quezon City, Metro Manila, Philippines', 14.69906, 121.08708999999999, 'Sobrang bilis', 'asdf', 0),
(19, 'ABC-123', 'Bus', '2015-04-25 00:00:00', '2015-04-25 00:00:00', 'Violation of Traffic Laws', 'Delta Drive, Quezon City, Metro Manila, Philippines', 14.6656659, 121.0809236, 'Mahal tiket', 'asdf', 0),
(20, 'ABC-123', 'Taxi', '2015-12-31 00:00:00', '2015-04-25 00:00:00', 'Theft', 'U.P. Lagoon, Quezon City, Metro Manila, Philippines', 14.6549401, 121.06741439999996, 'asf', 'asdf', 0),
(21, 'ABC-123', 'Taxi', '2015-12-31 00:00:00', '2015-04-25 00:00:00', 'Theft', 'UP Bonsai Garden, I. Delos Reyes Street, Quezon City, Metro Manila, Philippines', 14.650034, 121.06477199999995, 'adf', 'asdf', 0),
(22, 'ABC-123', 'Taxi', '0000-00-00 00:00:00', '2015-04-25 00:00:00', 'Theft', 'Litex, Quezon City, Metro Manila, Philippines', 0, 0, '', 'asdf', 0),
(23, 'ABC-123', 'Taxi', '2015-12-31 00:00:00', '2015-04-25 00:00:00', 'Theft', 'UP Bonsai Garden, I. Delos Reyes Street, Quezon City, Metro Manila, Philippines', 14.650034, 121.06477199999995, 'asdf', 'asdf', 0);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`facebook_id` varchar(100) NOT NULL,
`username` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`password` mediumtext NOT NULL,
`credibility` int(11) NOT NULL,
`date_created` date NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `facebook_id` (`facebook_id`,`username`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `facebook_id`, `username`, `email`, `password`, `credibility`, `date_created`) VALUES
(1, 'heyandieeee', 'andie', 'andie_rabino@yahoo.com', 'aaa', 2, '2015-04-08');
/*!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 */;