· 10 years ago · Aug 10, 2016, 11:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jan 23, 2016 at 10:27 AM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
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 utf8 */;
18
19--
20-- Database: `lr`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `feedback`
27--
28
29CREATE TABLE IF NOT EXISTS `feedback` (
30 `id` int(11) NOT NULL,
31 `name` varchar(32) NOT NULL,
32 `email` varchar(32) NOT NULL,
33 `message` text NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `feedback`
38--
39
40INSERT INTO `feedback` (`id`, `name`, `email`, `message`) VALUES
41(1, 'bibek', 'bibek@gmail.com', 'nice'),
42(2, 'hari', 'hari@gmail.com', 'good'),
43(6, 'Sangita', 'sangitayadav2015@gmail.com', ' good job!!! '),
44(7, 'Bibek', 'bibek011@live.com', ' owsm! '),
45(15, 'Ahmad', 'armirazai@gmail.com', ' This is a very good website. '),
46(16, 'bibek', 'bibek011@live.com', 'nice one!!! '),
47(17, 'niru', 'sdfsf', ' \r\n nice ');
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `members`
53--
54
55CREATE TABLE IF NOT EXISTS `members` (
56 `flight_id` int(11) NOT NULL,
57 `flight_name` varchar(32) NOT NULL,
58 `leaving_from` varchar(32) NOT NULL,
59 `going_to` varchar(32) NOT NULL,
60 `depart_date` text NOT NULL,
61 `time` text NOT NULL,
62 `arrival_date` text NOT NULL,
63 `dest_time` time NOT NULL,
64 `fare` int(32) NOT NULL
65) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `members`
69--
70
71INSERT INTO `members` (`flight_id`, `flight_name`, `leaving_from`, `going_to`, `depart_date`, `time`, `arrival_date`, `dest_time`, `fare`) VALUES
72(1, 'an-001', 'Delhi', 'Bangalore', '2015-10-21', '20:00:00', '2015-10-21', '22:00:00', 6000),
73(2, 'an-002', 'Bangalore', 'Delhi', '2015-10-25', '10:00:00', '2015-09-25', '12:25:00', 6500),
74(3, 'an-003', 'Delhi', 'Bangalore', '2015-10-21', '14:45:00', '2015-10-21', '17:30:00', 7500),
75(4, 'an-004', 'Bangalore', 'Delhi', '2015-10-25', '20:30:00', '2015-10-21', '23:00:00', 8000),
76(7, 'an-007', 'Delhi', 'Paris', '2016-01-01', '15:00:00', '2016-01-01', '23:00:00', 50000),
77(8, 'an-008', 'Mumbai', 'New York', '2015-10-25', '10:00:00', '2015-10-25', '21:10:00', 45000),
78(9, 'an-009', 'Bangalore', 'Agra', '2015-10-21', '20:00:00', '2015-10-20', '23:30:00', 4500),
79(10, 'an-0010', 'kabul', 'kathmandu', '2015-10-26', '09:00:00', '2015-10-26', '18:00:00', 35000),
80(16, 'an-0016', 'Delhi', 'Bangalore', '2015:10:25', '12:30:00', '2015:10:25', '15:15:00', 7000);
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `passengers`
86--
87
88CREATE TABLE IF NOT EXISTS `passengers` (
89 `passenger_id` int(11) NOT NULL,
90 `first_name` text NOT NULL,
91 `last_name` text NOT NULL,
92 `passport` varchar(15) NOT NULL,
93 `visa` varchar(15) NOT NULL,
94 `country` varchar(15) NOT NULL,
95 `address1` text NOT NULL,
96 `address2` text NOT NULL,
97 `email` varchar(32) NOT NULL,
98 `contact` int(14) NOT NULL,
99 `pin` varchar(11) NOT NULL,
100 `leaving_from` varchar(32) NOT NULL,
101 `going_to` varchar(32) NOT NULL,
102 `depart_date` text NOT NULL,
103 `depart_time` text NOT NULL,
104 `arrival_time` text NOT NULL,
105 `grand_fare` int(10) NOT NULL,
106 `returning_from` varchar(32) NOT NULL DEFAULT '0',
107 `returning_to` varchar(32) NOT NULL DEFAULT '0',
108 `returning_date` text,
109 `returning_time` text NOT NULL,
110 `reaching_time` text NOT NULL,
111 `fare` int(32) NOT NULL DEFAULT '0'
112) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;
113
114--
115-- Dumping data for table `passengers`
116--
117
118INSERT INTO `passengers` (`passenger_id`, `first_name`, `last_name`, `passport`, `visa`, `country`, `address1`, `address2`, `email`, `contact`, `pin`, `leaving_from`, `going_to`, `depart_date`, `depart_time`, `arrival_time`, `grand_fare`, `returning_from`, `returning_to`, `returning_date`, `returning_time`, `reaching_time`, `fare`) VALUES
119(55, 'ahmad', 'reshad', '124563', '2548', '', 'kbl', 'afgan', 'ahmad@gmail.com', 58649754, '456', 'Delhi', 'Bangalore', '2015-10-21', '14:45:00', '17:30:00', 7500, 'Bangalore', 'Delhi', '2015-10-25', '14:45:00', '12:25:00', 6500),
120(57, 'Ankit', 'Kumar', 'IN-96', 'Aj-64', '', 'Acharya,bangalore', '', 'ankit@gmail.com', 2147483647, '123ANK', 'Delhi', 'Bangalore', '2015-10-21', '14:45:00', '17:30:00', 7500, 'Bangalore', 'Delhi', '2015-10-25', '14:45:00', '23:00:00', 8000),
121(58, 'fdgdfg', 'dffdg', 'dfgdfg', 'dfgdf', '', 'dfgdfg', 'dfgdf', 'dfdfgd', 2147483647, '123456', 'Delhi', 'Bangalore', '2015-10-21', '14:45:00', '17:30:00', 7500, '', '', '', '', '', 0);
122
123-- --------------------------------------------------------
124
125--
126-- Table structure for table `users`
127--
128
129CREATE TABLE IF NOT EXISTS `users` (
130 `user_id` int(11) NOT NULL,
131 `username` varchar(32) NOT NULL,
132 `password` varchar(32) NOT NULL,
133 `first_name` varchar(32) NOT NULL,
134 `last_name` varchar(32) NOT NULL,
135 `email` varchar(1024) NOT NULL,
136 `email_code` varchar(32) NOT NULL,
137 `active` int(11) NOT NULL DEFAULT '0',
138 `type` int(1) NOT NULL DEFAULT '0'
139) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
140
141--
142-- Dumping data for table `users`
143--
144
145INSERT INTO `users` (`user_id`, `username`, `password`, `first_name`, `last_name`, `email`, `email_code`, `active`, `type`) VALUES
146(7, 'reshad', '094638268ea83f2509f7153305d2136c', 'reshad', '', 'armirazai@gmail.com', '3ceb3d5f70a323e7db9b87881557eec3', 1, 1),
147(15, 'bibek', 'eebcda4a99f2885ac9fbeb39e9219a0c', 'Bibek', 'kumar', 'bibek@gmail.com', '46705ac3604e2be9b8c8ade03099677a', 1, 0),
148(17, 'bale', '9094eda074a49c7a1b8e6996c7edf4cc', 'Gareth', 'Bale', 'bale@gmail.com', '4e9b34fe0a28965aa93f86d486ed2d5f', 0, 1),
149(18, 'ankit', 'e10adc3949ba59abbe56e057f20f883e', 'Ankit', 'Verma', 'ankit1@gmail.com', '3984771972bd3bffe3263bca02dd446c', 1, 0),
150(19, 'abhinash', '2cf4777b9545d3b48afba69a498208de', 'abhi', 'shah', 'abhi@gmail.com', 'd51df33b7906dda9524b80b5ce94fc30', 1, 0),
151(20, 'sonam', 'bd31c2bfe53a8875ed8e86710958299d', 'sonam', 'sherpa', 'sonam@gmail.com', '8980e60647b9f165bc67a7f627c86130', 1, 0),
152(21, 'nikhil', '874a615557757055fb62712d3b0d0609', 'nikhil', 'kumar', 'nikhil@gmail.com', '3914a4fba5d7c1c1147f02c0f39c6d61', 1, 1),
153(22, 'Aditya', '0c6d4afa882f2b88efccc99d6acaea41', 'Aditya', 'deshak', 'Aditya@gmail.com', 'b409399e2019d3f29f9c4566fd161159', 1, 1),
154(23, 'Sanket', '482c811da5d5b4bc6d497ffa98491e38', 'Sanket', 'mahato', 'sanket@gmail.com', '0208e2df18e0643e76758ff4588d94f7', 1, 0),
155(24, 'test', '8b6fbf40bd229d2c3860be8a1587bd87', 'Bebi', 'kumar', 'kumar@gmail.com', '6880909efd071a0706b0b8bfa9805508', 0, 0),
156(25, 'niranjan', '5f4dcc3b5aa765d61d8327deb882cf99', 'naranjan', 'yadav', 'niranjan@gmail.com', 'a2dd30f09f57af42a623539a0f4c6af2', 1, 1);
157
158--
159-- Indexes for dumped tables
160--
161
162--
163-- Indexes for table `feedback`
164--
165ALTER TABLE `feedback`
166 ADD PRIMARY KEY (`id`);
167
168--
169-- Indexes for table `members`
170--
171ALTER TABLE `members`
172 ADD PRIMARY KEY (`flight_id`);
173
174--
175-- Indexes for table `passengers`
176--
177ALTER TABLE `passengers`
178 ADD PRIMARY KEY (`passenger_id`);
179
180--
181-- Indexes for table `users`
182--
183ALTER TABLE `users`
184 ADD PRIMARY KEY (`user_id`);
185
186--
187-- AUTO_INCREMENT for dumped tables
188--
189
190--
191-- AUTO_INCREMENT for table `feedback`
192--
193ALTER TABLE `feedback`
194 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
195--
196-- AUTO_INCREMENT for table `members`
197--
198ALTER TABLE `members`
199 MODIFY `flight_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
200--
201-- AUTO_INCREMENT for table `passengers`
202--
203ALTER TABLE `passengers`
204 MODIFY `passenger_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=59;
205--
206-- AUTO_INCREMENT for table `users`
207--
208ALTER TABLE `users`
209 MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
210/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
211/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
212/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;