· 11 years ago · May 26, 2015, 11:00 AM
1/*
2Navicat MySQL Data Transfer
3Source Host : localhost:3306
4Source Database : sample_db
5Target Host : localhost:3306
6Target Database : sample_db
7Date: 2015-05-26 16:21:33
8*/
9
10SET FOREIGN_KEY_CHECKS=0;
11-- ----------------------------
12-- Table structure for message
13-- ----------------------------
14DROP TABLE IF EXISTS `message`;
15CREATE TABLE `message` (
16 `id` bigint(20) NOT NULL,
17 `subject` varchar(255) NOT NULL,
18 `message` varchar(2048) NOT NULL,
19 `unread` int(1) NOT NULL,
20 `datetime` datetime NOT NULL,
21 `user_id` bigint(20) NOT NULL,
22 PRIMARY KEY (`id`)
23) ENGINE=InnoDB DEFAULT CHARSET=latin1;
24
25-- ----------------------------
26-- Records of message
27-- ----------------------------
28
29-- ----------------------------
30-- Table structure for movie_theatre
31-- ----------------------------
32DROP TABLE IF EXISTS `movie_theatre`;
33CREATE TABLE `movie_theatre` (
34 `theatre_id` bigint(11) NOT NULL,
35 `theatre_name` varchar(255) NOT NULL,
36 `location` varchar(255) DEFAULT NULL,
37 `city` char(50) DEFAULT NULL,
38 `my_rating` smallint(11) DEFAULT NULL,
39 PRIMARY KEY (`theatre_id`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- ----------------------------
43-- Records of movie_theatre
44-- ----------------------------
45
46-- ----------------------------
47-- Table structure for movie_token
48-- ----------------------------
49DROP TABLE IF EXISTS `movie_token`;
50CREATE TABLE `movie_token` (
51 `token_id` bigint(11) NOT NULL,
52 `user_id` bigint(11) DEFAULT NULL,
53 `movie_datetime` datetime NOT NULL,
54 `shared_datetime` datetime NOT NULL,
55 `movie_name` varchar(255) NOT NULL,
56 `theatre_id` int(11) DEFAULT NULL,
57 `token_class_type` char(50) DEFAULT NULL,
58 `no_token` int(11) NOT NULL,
59 `price_per_token` float NOT NULL,
60 `seating_location` char(50) DEFAULT NULL,
61 `contact_emailid` char(50) NOT NULL,
62 `contact_mobileno` bigint(15) DEFAULT NULL,
63 `contact_emailid_showpublic` int(1) NOT NULL,
64 `contact_mobileno_showpublic` int(1) DEFAULT NULL,
65 `extra_info` varchar(255) DEFAULT NULL,
66 `token_request_ids` varchar(100) DEFAULT NULL,
67 `active_flag` int(1) NOT NULL,
68 PRIMARY KEY (`token_id`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71-- ----------------------------
72-- Records of movie_token
73-- ----------------------------
74
75-- ----------------------------
76-- Table structure for token_request
77-- ----------------------------
78DROP TABLE IF EXISTS `token_request`;
79CREATE TABLE `token_request` (
80 `request_id` bigint(11) NOT NULL,
81 `user_id` bigint(11) DEFAULT NULL,
82 `token_id` bigint(11) NOT NULL,
83 `token_type` char(25) NOT NULL,
84 `datetime` datetime NOT NULL,
85 `token_req_no` char(10) NOT NULL,
86 `extra_info` varchar(255) DEFAULT NULL,
87 `contact_emailid` char(50) NOT NULL,
88 `contact_mobileno` bigint(15) DEFAULT NULL,
89 `name` varchar(25) NOT NULL,
90 `active_flag` int(1) DEFAULT NULL,
91 PRIMARY KEY (`request_id`)
92) ENGINE=InnoDB DEFAULT CHARSET=latin1;
93
94-- ----------------------------
95-- Records of token_request
96-- ----------------------------
97
98-- ----------------------------
99-- Table structure for travel_place
100-- ----------------------------
101DROP TABLE IF EXISTS `travel_place`;
102CREATE TABLE `travel_place` (
103 `place_id` bigint(20) NOT NULL,
104 `place_name` varchar(50) NOT NULL,
105 `approved` int(1) NOT NULL,
106 PRIMARY KEY (`place_id`,`place_name`)
107) ENGINE=InnoDB DEFAULT CHARSET=latin1;
108
109-- ----------------------------
110-- Records of travel_place
111-- ----------------------------
112INSERT INTO `travel_place` VALUES ('1', 'bangalore', '1');
113INSERT INTO `travel_place` VALUES ('2', 'chennai', '1');
114INSERT INTO `travel_place` VALUES ('3', 'dharmapuri', '1');
115INSERT INTO `travel_place` VALUES ('4', 'vellore', '1');
116INSERT INTO `travel_place` VALUES ('5', 'erode', '1');
117INSERT INTO `travel_place` VALUES ('6', 'hyderabad', '1');
118INSERT INTO `travel_place` VALUES ('7', 'kurnool', '1');
119INSERT INTO `travel_place` VALUES ('8', 'srisailam', '1');
120INSERT INTO `travel_place` VALUES ('9', 'mumbai', '1');
121INSERT INTO `travel_place` VALUES ('10', 'coimbatore', '1');
122INSERT INTO `travel_place` VALUES ('11', 'madurai', '1');
123INSERT INTO `travel_place` VALUES ('12', 'thiruvarur', '1');
124INSERT INTO `travel_place` VALUES ('13', 'cochin', '1');
125INSERT INTO `travel_place` VALUES ('14', 'salem', '1');
126INSERT INTO `travel_place` VALUES ('15', 'banglore', '1');
127INSERT INTO `travel_place` VALUES ('16', 'palani', '0');
128
129-- ----------------------------
130-- Table structure for travel_token
131-- ----------------------------
132DROP TABLE IF EXISTS `travel_token`;
133CREATE TABLE `travel_token` (
134 `token_id` bigint(11) NOT NULL AUTO_INCREMENT,
135 `user_id` bigint(11) DEFAULT NULL,
136 `journey_datetime` datetime NOT NULL,
137 `shared_datetime` datetime NOT NULL,
138 `fromplace_id` int(11) NOT NULL,
139 `toplace_id` int(11) NOT NULL,
140 `boarding_place` char(50) DEFAULT NULL,
141 `travels_id` int(11) DEFAULT NULL,
142 `token_class_type` char(50) DEFAULT NULL,
143 `no_male_token` int(11) NOT NULL,
144 `no_female_token` int(11) NOT NULL,
145 `price_per_token` float NOT NULL,
146 `extra_info` varchar(255) DEFAULT NULL,
147 `contact_emailid` char(50) NOT NULL,
148 `contact_mobileno` bigint(15) DEFAULT NULL,
149 `contact_emailid_showpublic` int(1) NOT NULL,
150 `active_flag` int(1) NOT NULL,
151 `contact_mobileno_showpublic` int(1) NOT NULL,
152 `token_request_ids` varchar(100) DEFAULT NULL,
153 PRIMARY KEY (`token_id`)
154) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
155
156-- ----------------------------
157-- Records of travel_token
158-- ----------------------------
159INSERT INTO `travel_token` VALUES ('1', null, '2012-12-07 00:00:00', '2012-12-05 23:26:18', '2', '15', 'satheesh', null, null, '1', '0', '0', null, 'krishnasofts@gmail.com', null, '1', '0', '1', null);
160INSERT INTO `travel_token` VALUES ('2', null, '2012-12-14 00:00:00', '2012-12-05 23:27:56', '5', '16', 'rajeev nair', null, null, '2', '0', '0', null, 'krishnasofts@gmail.com', null, '1', '0', '1', null);
161INSERT INTO `travel_token` VALUES ('3', null, '2014-10-30 00:00:00', '2014-10-29 11:47:01', '5', '2', 'krishnakumar', null, null, '1', '0', '0', null, 'krishnasofts@gmail.com', '9789722162', '1', '0', '1', null);
162
163-- ----------------------------
164-- Table structure for travels
165-- ----------------------------
166DROP TABLE IF EXISTS `travels`;
167CREATE TABLE `travels` (
168 `travels_id` int(11) NOT NULL,
169 `travels_name` varchar(255) NOT NULL,
170 `website` char(50) DEFAULT NULL,
171 `my_rating` smallint(11) DEFAULT NULL,
172 PRIMARY KEY (`travels_id`)
173) ENGINE=InnoDB DEFAULT CHARSET=latin1;
174
175-- ----------------------------
176-- Records of travels
177-- ----------------------------
178
179-- ----------------------------
180-- Table structure for user
181-- ----------------------------
182DROP TABLE IF EXISTS `user`;
183CREATE TABLE `user` (
184 `email_id` char(50) NOT NULL,
185 `user_id` bigint(20) NOT NULL,
186 `password` char(50) NOT NULL,
187 `name` char(50) NOT NULL,
188 `mobile_no` bigint(20) DEFAULT NULL,
189 `active_flag` char(50) NOT NULL,
190 `notification_count` int(5) DEFAULT NULL,
191 PRIMARY KEY (`email_id`,`user_id`)
192) ENGINE=InnoDB DEFAULT CHARSET=latin1;
193
194-- ----------------------------
195-- Records of user
196-- ----------------------------
197INSERT INTO `user` VALUES ('cse1dinesh@gmail.com', '22', '375225', 'Dhinesh Kumar', null, '1', '1');
198INSERT INTO `user` VALUES ('dinesh.865@gmail.com', '7', '123456', 'dinu', '9952302372', '88dd975dba72459323b2463c65f7ea8d', null);
199INSERT INTO `user` VALUES ('frenz53@gmail.com', '5', '123456', 'sampath', '9629281244', '1', null);
200INSERT INTO `user` VALUES ('gnana2025@gmail.com', '25', 'indiap', 'gnana', '9345631030', '1', '1');
201INSERT INTO `user` VALUES ('kannanchand@gmail.com', '28', '1046565', 'P.c. Kannan', null, '1', '1');
202INSERT INTO `user` VALUES ('krishnakumar.becse@gmail.com', '30', 'success', 'krishna', null, '472dc73b354e49481645f3e78c956403', null);
203INSERT INTO `user` VALUES ('krishnasofts@gmail.com', '29', 'success', 'krishna', '9789722162', 'a177e03873b1aa32e4af2cff0be97b00', null);
204INSERT INTO `user` VALUES ('mailtopraveen.m@gmail.com', '6', 's05cse33', 'Praveen', '8939565456', '1', null);
205INSERT INTO `user` VALUES ('mailtoskdguru@gmail.com', '18', '296997', 'Guru Skd', null, '1', '1');
206INSERT INTO `user` VALUES ('mey.ananth1@gmail.com', '23', '662497', 'Meyananth Chellamuthu', null, '1', '1');
207INSERT INTO `user` VALUES ('mmnkndn@yahoo.com', '26', '666750', 'Manikandan Muthuchamy', null, '1', '1');
208INSERT INTO `user` VALUES ('nantha75@gmail.com', '27', '981060', 'Muruga Nantham', null, '1', '1');
209INSERT INTO `user` VALUES ('prakash12noon@gmail.com', '12', '181831', 'Prakash Hi', null, '1', null);
210INSERT INTO `user` VALUES ('raph78626@gmail.com', '10', 'iamand26', 'rafi', '9884706170', 'c0fdaaf90764042ecc06ae2540d34bc8', null);
211INSERT INTO `user` VALUES ('raphy.26.786@gmail.com', '9', 'iamand26', 'Meer', '9884706170', '1', null);
212INSERT INTO `user` VALUES ('raphy78626@gmail.com', '8', 'iamand26', 'rafi', '9884706170', '1', null);
213INSERT INTO `user` VALUES ('sprashanth03@gmail.com', '24', '380724', 'Prashanth Siva', null, '1', null);
214INSERT INTO `user` VALUES ('syedyusufs@yahoo.com', '17', 'syedrb', 'syed yusuf', null, '1', '1');
215
216-- ----------------------------
217-- Table structure for user_ext
218-- ----------------------------
219DROP TABLE IF EXISTS `user_ext`;
220CREATE TABLE `user_ext` (
221 `user_id` bigint(20) NOT NULL,
222 `sex` char(3) DEFAULT NULL,
223 `dob` date DEFAULT NULL,
224 `city` varchar(20) DEFAULT NULL,
225 `state` varchar(20) DEFAULT NULL,
226 `country` varchar(20) DEFAULT NULL,
227 `signup_channel` int(1) DEFAULT NULL,
228 PRIMARY KEY (`user_id`)
229) ENGINE=InnoDB DEFAULT CHARSET=latin1;
230
231-- ----------------------------
232-- Records of user_ext
233-- ----------------------------
234INSERT INTO `user_ext` VALUES ('5', null, null, null, null, null, null);
235INSERT INTO `user_ext` VALUES ('6', 'Mr', '1987-06-27', 'Thoothukudi', 'Tamil Nadu', null, null);
236INSERT INTO `user_ext` VALUES ('7', null, null, null, null, null, null);
237INSERT INTO `user_ext` VALUES ('8', 'Mr', '1986-09-26', 'Kurnool', 'Andhra Pradesh', null, null);
238INSERT INTO `user_ext` VALUES ('9', 'Mr', '1986-09-26', 'Kurnool', 'Andhra Pradesh', null, null);
239INSERT INTO `user_ext` VALUES ('10', null, null, null, null, null, null);
240INSERT INTO `user_ext` VALUES ('12', null, null, null, null, null, null);
241INSERT INTO `user_ext` VALUES ('17', null, null, null, null, null, '0');
242INSERT INTO `user_ext` VALUES ('18', null, null, null, null, null, '1');
243INSERT INTO `user_ext` VALUES ('22', null, null, null, null, null, '1');
244INSERT INTO `user_ext` VALUES ('23', null, null, null, null, null, '1');
245INSERT INTO `user_ext` VALUES ('24', null, null, null, null, null, '1');
246INSERT INTO `user_ext` VALUES ('25', null, null, null, null, null, '0');
247INSERT INTO `user_ext` VALUES ('26', null, null, null, null, null, '1');
248INSERT INTO `user_ext` VALUES ('27', null, null, null, null, null, '1');
249INSERT INTO `user_ext` VALUES ('28', 'Mr', '1988-06-25', 'Chennai', 'Tamilnadu', null, '1');
250INSERT INTO `user_ext` VALUES ('29', null, null, null, null, null, '0');
251INSERT INTO `user_ext` VALUES ('30', null, null, null, null, null, '0');
252