· 6 years ago · Jul 18, 2019, 05:20 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.10
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jul 16, 2019 at 06:14 PM
7-- Server version: 5.5.60-MariaDB
8-- PHP Version: 7.0.33
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `carpanion`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `bookings`
27--
28
29CREATE TABLE IF NOT EXISTS `bookings` (
30 `id` bigint(20) NOT NULL,
31 `customer_id` bigint(20) NOT NULL,
32 `leaving_from` varchar(255) NOT NULL,
33 `destination` varchar(255) NOT NULL,
34 `leaving_date` date NOT NULL,
35 `leaving_time` time NOT NULL,
36 `seats` tinyint(4) NOT NULL,
37 `ride_id` bigint(20) NOT NULL,
38 `leaving_longitude` varchar(50) NOT NULL,
39 `leaving_latitude` varchar(50) NOT NULL,
40 `destination_longitude` varchar(50) NOT NULL,
41 `destination_latitude` varchar(50) NOT NULL,
42 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
43 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
44) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `customer`
50--
51
52CREATE TABLE IF NOT EXISTS `customer` (
53 `id` bigint(20) NOT NULL,
54 `name` varchar(255) NOT NULL,
55 `phone` varchar(25) NOT NULL,
56 `email` varchar(255) NOT NULL,
57 `gender` enum('Male','Female') DEFAULT NULL,
58 `password` text NOT NULL,
59 `licence` text NOT NULL,
60 `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
61 `created_at` timestamp NULL DEFAULT NULL,
62 `updated_at` timestamp NULL DEFAULT NULL
63) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
64
65--
66-- Dumping data for table `customer`
67--
68
69INSERT INTO `customer` (`id`, `name`, `phone`, `email`, `gender`, `password`, `licence`, `status`, `created_at`, `updated_at`) VALUES
70(1, 'Adarsh', '8447777683', 'adarsh@illinois.edu', 'Male', '13415123', '', 'Active', '2019-07-06 23:11:54', '2019-07-06 23:11:54'),
71(2, 'Sam', '5999422375', 'sid@illinois.edu', 'Male', '12345', '1sd134', 'Active', '2019-07-10 13:19:15', '2019-08-12 03:49:12'),
72(3, 'Bob', '1435820492', 'bob5@illinois.edu', 'Male', '123456789', '5gsb23f', 'Active', '2018-02-04 20:01:24', '2019-03-01 22:41:14'),
73(4, 'Janette', '9348471583', 'jnet3@illinois.edu', 'Female', 'asdw123', '1dbd21', 'Active', '2019-03-15 06:07:34', '2019-03-20 14:41:14'),
74(5, 'Danielle', '4859246847', 'dani2@illinois.edu', 'Female', 'password', '', 'Active', '2019-05-23 18:34:45', '2019-09-23 21:31:07');
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `rides`
80--
81
82CREATE TABLE IF NOT EXISTS `rides` (
83 `id` bigint(20) NOT NULL,
84 `customer_id` bigint(20) NOT NULL,
85 `leaving_from` varchar(255) NOT NULL,
86 `destination` varchar(255) NOT NULL,
87 `leaving_date` date NOT NULL,
88 `leaving_time` time NOT NULL,
89 `seats` tinyint(4) NOT NULL,
90 `leaving_longitude` varchar(50) NOT NULL,
91 `leaving_latitude` varchar(50) NOT NULL,
92 `destination_longitude` varchar(50) NOT NULL,
93 `destination_latitude` varchar(50) NOT NULL,
94 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
95 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
96) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
97
98--
99-- Dumping data for table `rides`
100--
101
102INSERT INTO `rides` (`id`, `customer_id`, `leaving_from`, `destination`, `leaving_date`, `leaving_time`, `seats`, `leaving_longitude`, `leaving_latitude`, `destination_longitude`, `destination_latitude`,
103 `created_at`, `updated_at`) VALUES
104(1, 1, 'Champaign','OHARE', '2019-07-12', '17:00:00', 1, '40.116330', '-88.243520', '41.976190', '-87.888010', '2019-07-12 09:41:31', '2019-07-12 09:41:31'),
105(2, 3, 'Champaign','OHARE', '2019-07-12', '18:00:00', 3, '40.116330', '-88.243520', '41.976190', '-87.888010', '2019-07-12 12:10:05', '2019-07-12 12:10:05'),
106(3, 2, 'Champaign','Downtown Chicago', '2019-07-12', '15:30:00', 4, '40.116330', '-88.243520', '41.877140', '-87.622040', '2019-07-12 06:05:32', '2019-07-12 06:05:32'),
107(4, 4, 'Champaign','Chicago', '2019-07-12', '18:00:00', 2, '40.116330', '-88.243520', '41.883230', '-87.622040', '2019-07-12 13:51:53', '2019-07-12 13:51:53'),
108(5, 1, 'OHARE','Champaign', '2019-07-12', '07:00:00', 1, '41.976190', '-87.888010', '40.116330', '-88.243520', '2019-07-11 15:28:16', '2019-07-11 15:28:16'),
109(6, 2, 'Champaign','Midway', '2019-07-15', '12:00:00', 1, '40.116330', '-88.243520', '40.1020', '-88.2272', '2019-07-11 16:49:18', '2019-07-11 16:49:18'),
110(7, 5, 'Champaign','Downtown Chicago', '2019-07-17', '09:30:00', 2, '40.116330', '-88.243520', '41.877140', '-87.622040', '2019-07-11 21:11:56', '2019-07-11 21:11:56'),
111(8, 1, 'Downtown Chicago','Champaign', '2019-07-12', '18:30:00', 2, '41.877140', '-87.622040', '40.116330', '-88.243520', '2019-07-10 14:37:25', '2019-07-10 14:37:25'),
112(9, 2, 'Chicago Suburbs','Champaign', '2019-07-12', '11:00:00', 3, '41.552170', '-88.121700', '40.116330', '-88.243520', '2019-07-10 05:54:19', '2019-07-10 05:54:19'),
113(10, 5, 'Champaign','Purdue', '2019-07-12', '20:00:00', 1, '40.116330', '-88.243520', '40.4237', '-86.9212', '2019-07-10 10:33:25', '2019-07-10 10:33:25'),
114(11, 3, 'OHARE','Champaign', '2019-07-13', '22:00:00', 3, '41.976190', '-87.888010', '40.116330', '-88.243520', '2019-07-10 08:32:31', '2019-07-10 08:32:31'),
115(12, 5, 'Champaign','Orange Line Train Station', '2019-07-12', '06:00:00', 4, '40.116330', '-88.243520', '41.804236', '-87.704406', '2019-07-10 18:34:45', '2019-07-10 21:31:07'),
116(13, 1, 'OHARE','Champaign', '2019-07-12', '10:00:00', 1, '41.976190', '-87.888010', '40.116330', '-88.243520', '2019-07-09 08:14:29', '2019-07-09 08:14:29'),
117(14, 3, 'OHARE','Champaign', '2019-07-12', '18:00:00', 1, '41.976190', '-87.888010', '40.116330', '-88.243520', '2019-07-09 13:54:21', '2019-07-09 13:54:21'),
118(15, 4, 'Champaign','OHARE', '2019-07-16', '12:00:00', 2, '40.116330', '-88.243520', '41.976190', '-87.888010', '2019-07-08 14:34:57', '2019-07-08 14:34:57'),
119(16, 2, 'Champaign','OHARE', '2019-07-08', '23:00:00', 1, '40.116330', '-88.243520', '41.976190', '-87.888010', '2019-07-08 21:31:07', '2019-07-08 21:31:07'),
120(17, 5, 'Champaign','OHARE', '2019-07-08', '14:00:00', 2, '40.116330', '-88.243520', '41.976190', '-87.888010', '2019-07-07 18:34:45', '2019-07-07 18:34:45'),
121(18, 5, 'OHARE','Champaign', '2019-07-07', '14:30:00', 1, '41.976190', '-87.888010', '40.116330', '-88.243520', '2019-07-07 09:34:45', '2019-07-07 09:34:45'),
122(19, 4, 'OHARE','Champaign', '2019-07-08', '11:00:00', 1, '41.976190', '-87.888010', '40.116330', '-88.243520', '2019-07-07 10:27:29', '2019-07-07 10:32:57'),
123(20, 2, 'Chicago','Champaign', '2019-07-08', '19:00:00', 1, '41.883230', '-87.622040', '40.116330', '-88.243520', '2019-07-07 17:34:45', '2019-07-07 17:34:45'),
124(21, 1, 'Chicago','Champaign', '2019-07-07', '12:30:00', 2, '41.883230', '-87.622040', '40.116330', '-88.243520', '2019-07-07 08:54:45', '2019-07-07 08:54:45'),
125(22, 3, 'Chicago','Champaign', '2019-07-06', '15:00:00', 1, '41.883230', '-87.622040', '40.116330', '-88.243520', '2019-07-06 09:14:25', '2019-07-06 09:14:25'),
126(23, 5, 'Champaign','Downtown Chicago', '2019-07-07', '17:00:00', 1, '40.116330', '-88.243520', '41.877140', '-87.622040', '2019-07-06 18:34:45', '2019-07-06 21:31:07'),
127(24, 3, 'Chicago','Champaign', '2019-07-07', '12:00:00', 1, '41.883230', '-87.622040', '40.116330', '-88.243520', '2019-07-06 13:31:15', '2019-07-06 15:25:17'),
128(25, 1, 'Champaign','Chicago', '2019-07-06', '12:30:00', 3, '40.116330', '-88.243520', '41.883230', '-87.622040', '2019-07-06 08:24:55', '2019-07-06 10:21:27');
129--
130-- Indexes for dumped tables
131--
132
133--
134-- Indexes for table `bookings`
135--
136ALTER TABLE `bookings`
137 ADD PRIMARY KEY (`id`);
138
139--
140-- Indexes for table `customer`
141--
142ALTER TABLE `customer`
143 ADD PRIMARY KEY (`id`);
144
145--
146-- Indexes for table `rides`
147--
148ALTER TABLE `rides`
149 ADD PRIMARY KEY (`id`);
150
151--
152-- AUTO_INCREMENT for dumped tables
153--
154
155--
156-- AUTO_INCREMENT for table `bookings`
157--
158ALTER TABLE `bookings`
159 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
160--
161-- AUTO_INCREMENT for table `customer`
162--
163ALTER TABLE `customer`
164 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
165--
166-- AUTO_INCREMENT for table `rides`
167--
168ALTER TABLE `rides`
169 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
170/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
171/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
172/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;