-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathKitabGhar.sql
170 lines (147 loc) · 50.9 KB
/
KitabGhar.sql
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
--
-- Host: localhost Database: kitabghar
-- ------------------------------------------------------
-- Server version 5.7.21-0ubuntu0.16.04.1
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `books`
--
DROP TABLE IF EXISTS `books`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `books` (
`bookid` varchar(20) NOT NULL,
`name` varchar(100) NOT NULL,
`author` varchar(100) NOT NULL,
`publication` varchar(100) DEFAULT 'Self Published',
`category` varchar(20) DEFAULT NULL,
`subcategory` varchar(20) DEFAULT NULL,
`queryid` int(11) NOT NULL,
`price` int(11) NOT NULL,
`coverimage` varchar(100) DEFAULT 'default.jpg',
`downloadpath` varchar(50) DEFAULT NULL,
PRIMARY KEY (`bookid`),
UNIQUE KEY `queryid` (`queryid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `books`
--
LOCK TABLES `books` WRITE;
/*!40000 ALTER TABLE `books` DISABLE KEYS */;
INSERT INTO `books` VALUES ('ACAD1000','Compilers - Dragon Book','Aho Ullman','Addison Wesley','Academic','TOC',136484,40,'AhoCOMPILER.png','Sorry.jsp'),('ACAD1001','Electronic Devices and Circuit Theory','Robert Boylestad','Prentice Hall','Academic','NonCSE',180150,40,'BoylestadECE.png','Sorry.jsp'),('ACAD1002','Introduction to Algorithms','Thomas Cormen','MIT Press','Academic','DSAlgo',127542,50,'CormenALGO.png','Sorry.jsp'),('ACAD1003','Principles of Soft Computing','S N Deepa','Wiley','Academic','ML',113419,20,'DeepaSC.png','Sorry.jsp'),('ACAD1004','Graph Theory','Narsimon Deo','Prentice Hall','Academic','DSAlgo',130905,30,'DeoGRAPH.png','Sorry.jsp'),('ACAD1005','Data Communications and Networking','Behrouz Forouzan','Prentice Hall','Academic','CN',125616,30,'ForouzanCN.png','Sorry.jsp'),('ACAD1006','Cryptography & Network Security','Behrouz Forouzan','McGraw Hill','Academic','Crypto',199941,40,'ForouzanCRYPTO.png','Sorry.jsp'),('ACAD1007','Network Security Hacks','Andrew Lockhart','OReilly','Academic','Crypto',111040,10,'HackerCN.png','Sorry.jsp'),('ACAD1008','Machine Learning for Hackers','Drew Conway','OReilly','Academic','ML',126064,20,'HackerML.png','Sorry.jsp'),('ACAD1009','Hacking Exposed','Joel Scambey','','Academic','Crypto',146210,10,'HackerNOR.png','Sorry.jsp'),('ACAD1010','Data Mining','Jiawei Han','MK Press','Academic','ML',110264,40,'HanDM.png','Sorry.jsp'),('ACAD1011','Head First Networking','Al Anderson','OReilly','Academic','CN',108693,30,'HeadFirstCN.png','Sorry.jsp'),('ACAD1012','Computer Graphics','Hearn Baker','Prentice Hall','Academic','CG',131124,20,'HearnBakerCG.png','Sorry.jsp'),('ACAD1013','Introduction to MATLAB','Boss L. Spencer','MIT Press','Academic','NonCSE',130026,30,'IntroMLAB.png','Sorry.jsp'),('ACAD1014','Introduction to Software Engineering','Pankaj Jalote','Springer','Academic','SE',100048,30,'JaloteSE.png','Sorry.jsp'),('ACAD1015','Modern Digital and Analog Communication','B P Lathi','Oxford','Academic','NonCSE',172982,30,'LathiCOMM.png','Sorry.jsp'),('ACAD1016','Simulation Modelling & Analysis','Law Kelton','McGraw Hill','Academic','Sim',136788,20,'LawSIMULATION.png','Sorry.jsp'),('ACAD1017','Computer System Architecture','Morris Mano','Pearson Press','Academic','CO',138374,20,'ManoCO.png','Sorry.jsp'),('ACAD1018','Digital Design','Morris Mano','Pearson Press','Academic','NonCSE',105576,30,'ManoDD.png','Sorry.jsp'),('ACAD1019','Theory of Computer Science','KLP Mishra','Prentice Hall','Academic','TOC',123313,30,'MishraTOC.png','Sorry.jsp'),('ACAD1020','Computer Organization and Design','Patterson Hennessy','MK Press','Academic','CO',195359,30,'PattersonCO.png','Sorry.jsp'),('ACAD1021','Digital Image Processing','William Pratt','Wiley','Academic','CG',141762,10,'PratDIP.png','Sorry.jsp'),('ACAD1022','Software Engineering','Roger Pressman','McGraw Hill','Academic','SE',103844,20,'PressmanSE.png','Sorry.jsp'),('ACAD1023','Engineering Optimization','S S Rao','Wiley','Academic','NonCSE',174884,30,'RaoOPTI.png','Sorry.jsp'),('ACAD1024','OpenGL Programming Guide','Dave Shreiner','Addison Wesley','Academic','CG',167667,20,'RedbookOPENGL.png','Sorry.jsp'),('ACAD1025','Artificial Intelligence','Rich Knight','McGraw Hill','Academic','ML',126599,20,'RichKnightAI.png','Sorry.jsp'),('ACAD1026','Discrete Mathematics','Kenneth Rosen','McGraw Hill','Academic','DS',106030,30,'RosenDS.png','Sorry.jsp'),('ACAD1027','Computer Networking','Kurose Ross','Pearson Press','Academic','CN',149033,30,'RossCN.png','Sorry.jsp'),('ACAD1028','Probability','Sheldon Ross','Pearson Press','Academic','Maths',151540,20,'RossPROB.png','Sorry.jsp'),('ACAD1029','Artificial Intelligence','Russel Norvig','Prentice Hall','Academic','ML',195899,40,'RusselAI.png','Sorry.jsp'),('ACAD1030','Computer Algorithms','Sartaj Sahni','Orient Black Swan','Academic','DSAlgo',196373,20,'SahniALGO.png','Sorry.jsp'),('ACAD1031','CUDA By Example','Jason Sanders','NVIDIA','Academic','CG',130925,0,'SandersCUDA.png','Sorry.jsp'),('ACAD1032','Discrete Mathematics','Lipschutz','Schaum Outlines','Academic','Maths',126481,20,'SchaumDISCRETE.png','Sorry.jsp'),('ACAD1033','Linear Algebra','Lipschutz','Schaum Outlines','Academic','Maths',172771,10,'SchaumLA.png','Sorry.jsp'),('ACAD1034','Algorithms','Robert Sedgewick','Addison Wesley','Academic','DSAlgo',180388,30,'SedgewickALGO.png','Sorry.jsp'),('ACAD1035','Database System Concepts','Henry Korth','McGraw Hill','Academic','DBMS',117943,40,'SilberchatzDBMS.png','Sorry.jsp'),('ACAD1036','Operating System Concepts','Silberschatz','Wiley','Academic','OS',179877,20,'SilberchatzOS.png','Sorry.jsp'),('ACAD1037','Computer Organization and Architecture - Eighth Edition','William Stallings','Pearson Press','Academic','CO',110211,30,'StallingsCO.png','Sorry.jsp'),('ACAD1038','Cryptography & Network Security - Fifth Edition','William Stallings','Prentice Hall','Academic','Crypto',124647,30,'StallingsCrypto5.png','Sorry.jsp'),('ACAD1039','Cryptography & Network Security - Fourth Edition','William Stallings','Prentice Hall','Academic','Crypto',164861,20,'StallingsCRYPTO4.png','Sorry.jsp'),('ACAD1040','Cryptography & Network Security - Sixth Edition','William Stallings','Prentice Hall','Academic','Crypto',109500,30,'StallingsCRYPTO6.png','Sorry.jsp'),('ACAD1041','Operating System Principles','William Stallings','Macmillan USA','Academic','OS',102302,30,'StallingsOS.png','Sorry.jsp'),('ACAD1042','Discrete Mathematics with Applications','Susanna S. Epp','Cengage Learning','Academic','DS',171887,30,'SusanneDISCRETE.png','Sorry.jsp'),('ACAD1043','Computer Networks','Tanenbaum','Prentice Hall','Academic','CN',199071,30,'TanenbaumCN.png','Sorry.jsp'),('ACAD1044','Electrical Technology','B L Theraja','S. Chand','Academic','NonCSE',142585,30,'TharejaEE.png','Sorry.jsp'),('ACAD1045','Modern Engineering Physics','AS Vasudeva','S. Chand','Academic','NonCSE',155725,30,'VasudevPHY.png','Sorry.jsp'),('NOV1000','The 3 Mistakes of My Life','Chetan Bhagat','Rupa Publications','Novel','InNew',149147,30,'3Mistakes.png','Sorry.jsp'),('NOV1001','Allegiant','Veronika Roth','','Novel','Foreign',103487,30,'Allegiant.jpg','Sorry.jsp'),('NOV1003','Anything For You Maam','Tushar Raheja','','Novel','InNew',135424,20,'AnthingMam.jpg','Sorry.jsp'),('NOV1004','World Best Boyfriend','Durjoy Datta','Penguin Books','Novel','InNew',186968,30,'BestBoyfriend.jpg','Sorry.jsp'),('NOV1005','The Bro Code','Barney Stinson','','Novel','Foreign',118320,10,'BroCode.png','Sorry.jsp'),('NOV1006','One Night at the Call Centre','Chetan Bhagat','Rupa Publications','Novel','InNew',126393,20,'CallCenter.png','Sorry.jsp'),('NOV1007','Insight of Just Friends','Sumrit Shahi','Rupa Publications','Novel','InNew',185363,30,'CanJustFriends.jpg','Sorry.jsp'),('NOV1008','An Abundance of Katherines','John Green','','Novel','Foreign',129086,10,'Catherines.png','Sorry.jsp'),('NOV1009','Divergent','Veronika Roth','','Novel','Foreign',118753,30,'Divergent.jpg','Sorry.jsp'),('NOV1010','Your Dreams are Mine Now','Ravinder Singh','Penguin Books','Novel','InNew',166052,30,'DreamsMine.jpg','Sorry.jsp'),('NOV1011','The Fault in our Stars','John Green','Dutton Books','Novel','Foreign',103023,60,'FaultStars.png','Sorry.jsp'),('NOV1012','This Love that feels Right','Ravinder Singh','Penguin Books','Novel','InNew',172997,20,'FeelsRight.jpg','Sorry.jsp'),('NOV1013','At First Sight','Nicolas Sparks','Grand Central Publishing','Novel','Foreign',103810,20,'Firstsight.png','Sorry.jsp'),('NOV1014','5 Points Someone','Chetan Bhagat','Rupa Publications','Novel','InNew',181444,30,'FivePoint.png','Sorry.jsp'),('NOV1015','I Too Had a Love Story','Ravinder Singh','Penguin Books','Novel','InNew',195506,30,'HadLoveStory.png','Sorry.jsp'),('NOV1016','Half Girlfriend','Chetan Bhagat','Rupa Publications','Novel','InNew',130019,20,'HalfGirlfriend.png','Sorry.jsp'),('NOV1017','The Hobbit','J R R Tolkein','Allen & Unwin','Novel','Foreign',155442,60,'Hobbit.png','Sorry.jsp'),('NOV1018','Hold My Hand','Durjoy Datta','Penguin Books','Novel','InNew',111370,20,'HoldHand.jpg','Sorry.jsp'),('NOV1019','Will You Still Love Me?','Ravinder Singh','Penguin Books','Novel','InNew',111845,20,'HoldMyHands.jpg','Sorry.jsp'),('NOV1020','Harry Potter and The Prisoner of Azkaban','JK Rowling','Bloomsbury','Novel','Foreign',165856,50,'HPAzkaban.jpeg','Sorry.jsp'),('NOV1021','Harry Potter and The Chamber of Secrets','JK Rowling','Bloomsbury','Novel','Foreign',170037,50,'HPChamber.jpg','Sorry.jsp'),('NOV1022','Harry Potter and The Deathly Hallows','JK Rowling','Bloomsbury','Novel','Foreign',163373,50,'HPDeathly.png','Sorry.jsp'),('NOV1023','Harry Potter and The Philosopher Stone','JK Rowling','Bloomsbury','Novel','Foreign',184586,50,'HPPhilosopher.jpg','Sorry.jsp'),('NOV1024','Harry Potter and The Order of the Phoenix','JK Rowling','Bloomsbury','Novel','Foreign',130329,50,'HPPhoenix.jpg','Sorry.jsp'),('NOV1025','Harry Potter and The Half Blood Prince','JK Rowling','Bloomsbury','Novel','Foreign',100849,50,'HPPrince.jpg','Sorry.jsp'),('NOV1026','Harry Potter and The Sorcerer Stone','JK Rowling','Bloomsbury','Novel','Foreign',190391,50,'HPSorcerer.jpg','Sorry.jsp'),('NOV1027','The Hunger Games','Suzanne Collins','Stochalistic Publications','Novel','Foreign',136805,20,'HungerGames.png','Sorry.jsp'),('NOV1028','Our Impossible Love','Durjoy Datta','Penguin Books','Novel','InNew',171294,30,'ImpossibleLove.jpg','Sorry.jsp'),('NOV1029','Insurgent','Veronika Roth','HarperCollins','Novel','Foreign',134096,30,'Insurgent.jpg','Sorry.jsp'),('NOV1030','Just Friends','Sumrit Shahi','Mahaveer Publications','Novel','InNew',105239,30,'JustFriends.jpg','Sorry.jsp'),('NOV1031','Never Kiss Your Best Friend','Sumrit Shahi','Rupa Publications','Novel','InNew',109885,20,'KissBestFriend.jpg','Sorry.jsp'),('NOV1032','Till the Last Breath','Durjoy Datta','Penguin Books','Novel','InNew',196616,20,'LastBreadth.jpg','Sorry.jsp'),('NOV1033','The Road Less Travelled','Scott Peck','Simon & Schuster','Novel','Foreign',117165,10,'LessTravelled.jpg','Sorry.jsp'),('NOV1034','A Lot like Love','Sumrit Shahi','Penguin Books','Novel','InNew',195353,20,'LilChocolate.jpg','Sorry.jsp'),('NOV1035','When Only Love Remains','Durjoy Datta','Penguin Books','Novel','InNew',106769,20,'LoveRemains.jpg','Sorry.jsp'),('NOV1036','The Immortals of Meluha','Amish Tripathi','Westland Press','Novel','InOld',111234,40,'Meluha.jpg','Sorry.jsp'),('NOV1037','To Kill A Mockingbird','Harper Lee','J B Lippincott','Novel','Foreign',182300,40,'Mockingbird.png','Sorry.jsp'),('NOV1038','The Secrets of the Nagas','Amish Tripathi','Westland Press','Novel','InOld',159702,40,'Nagas.jpg','Sorry.jsp'),('NOV1039','If its not forever..','Durjoy Datta','Penguin Books','Novel','InNew',134138,20,'NotForever.jpg','Sorry.jsp'),('NOV1040','Now That You Are Rich','Durjoy Datta','Grapevine Publishers','Novel','InNew',119285,20,'NowYouRich.jpg','Sorry.jsp'),('NOV1041','Of Course I Love You','Durjoy Datta','Grapevine Publishers','Novel','InNew',103969,20,'OfCourse.jpg','Sorry.jsp'),('NOV1042','Paper Towns','John Green','Dutton Books','Novel','Foreign',101609,10,'PaperTowns.png','Sorry.jsp'),('NOV1043','Pride & Prejudice','Jane Austen','Thomas Egerton','Novel','Foreign',107070,10,'PridePrejudice.jpg','Sorry.jsp'),('NOV1044','Revolution 2020','Chetan Bhagat','Rupa Publications','Novel','InNew',196402,30,'Revolution2020.png','Sorry.jsp'),('NOV1045','She Broke Up','Durjoy Datta','Penguin Books','Novel','InNew',160783,20,'SheBrokeUp.jpg','Sorry.jsp'),('NOV1046','Train To Pakistan','Khushwant Singh','Penguin Books','Novel','InOld',146640,20,'TrainToPakistan.jpg','Sorry.jsp'),('NOV1047','The Oath of the Vayuputras','Amish Tripathi','Westland Press','Novel','InOld',122815,40,'Vayuputras.jpg','Sorry.jsp'),('NOV1048','Like it Happened Yesterday','Ravinder Singh','Penguin Books','Novel','InNew',155389,20,'Yesterday.jpg','Sorry.jsp'),('NOV1049','You Were My Crush!','Durjoy Datta','Penguin Books','Novel','InNew',142087,20,'YouCrush.jpg','Sorry.jsp'),('PROG1000','Beginning PHP, Apache and MySQL','Timothy Boronczyk','Wrox','Programming','PHP',154427,60,'BegAMP.png','Sorry.jsp'),('PROG1001','Beginning CSS','Ian Pouncey','Wrox','Programming','UI',187898,40,'BegCSS.png','Sorry.jsp'),('PROG1002','Beginning Python','James Payne','Wrox','Programming','Python',170802,30,'BegPy.png','Sorry.jsp'),('PROG1003','Beginning HTML and CSS','Rob Larsen','Wrox','Programming','UI',157910,30,'BegWD.png','Sorry.jsp'),('PROG1004','Java The Complete Reference','Herbert Schildt','Oracle Press','Programming','Java',168702,20,'CompRefJ.png','Sorry.jsp'),('PROG1005','Javascript Cookbook','Shelley Powers','OReilly','Programming','JS',173504,10,'CookbookJS.png','Sorry.jsp'),('PROG1006','Python Web Development with Django','Jeff Forceir','','Programming','Python',185954,20,'DjangoWD.png','Sorry.jsp'),('PROG1007','HTML & CSS for dummies','Jeff Noble','','Programming','UI',108399,20,'DummiesHC.png','Sorry.jsp'),('PROG1008','Effective JavaScript','David Herman','Prentice Hall','Programming','JS',176996,20,'EffectiveJS.png','Sorry.jsp'),('PROG1009','Flask Web Development','Miguel Grinberg','OReilly','Programming','Python',192761,20,'FlaskWD.png','Sorry.jsp'),('PROG1010','CSS3 Foundations','Ian Lunn','treehouse','Programming','UI',147841,10,'FoundCSS.png','Sorry.jsp'),('PROG1011','Android Programming','Bill Phillips','Big Nerd Ranch','Programming','Android',132992,20,'GuideAD.png','Sorry.jsp'),('PROG1012','The Linux Command Line','William Shotts','No Starch Press','Programming','Linux',116460,0,'GuideLINUX.png','Sorry.jsp'),('PROG1013','Programming Ruby','Dave Thomas','Facets','Programming','Ruby',134458,30,'GuideRAILS.png','Sorry.jsp'),('PROG1014','Head First HTML with CSS','Elisabeth Freeman','OReilly','Programming','UI',105258,10,'HeadFirstHTML.png','Sorry.jsp'),('PROG1015','Head First Servlets & JSP','Bryan Basham','OReilly','Programming','Java',177414,30,'HeadFirstJSP.png','Sorry.jsp'),('PROG1016','Head First PHP & MySQL','Lynn Beighley','OReilly','Programming','PHP',194471,20,'HeadFirstMP.png','Sorry.jsp'),('PROG1017','Head First Python','Paul Barry','OReilly','Programming','Python',151012,30,'HeadFirstPY.png','Sorry.jsp'),('PROG1018','Learning Python','Mark Lutz','OReilly','Programming','Python',198798,30,'LearnPY.png','Sorry.jsp'),('PROG1019','Getting MEAN','Simon Holmes','Hanning','Programming','JS',105205,40,'MEANStackWE.png','Sorry.jsp'),('PROG1020','CSS The Missing Manual','David Sawyer','OReilly','Programming','UI',138343,10,'MissManualCSS.png','Sorry.jsp'),('PROG1021','JQuery Novice to Ninja','Earle Castledine','Sitepoint','Programming','JS',179283,0,'NinjaJQY.png','Sorry.jsp'),('PROG1022','Secrets of the JavaScript Ninja','John Resig','Hanning','Programming','JS',115230,20,'NinjaJS.png','Sorry.jsp'),('PROG1023','The Official Ubuntu Book','Matthew Helmke','','Programming','Linux',124498,0,'OfficialLINUX.png','Sorry.jsp'),('PROG1024','The Principles of Object Oriented JavaScript','Nicholas Zakas','No Starch Press','Programming','JS',102029,20,'OOPS.png','Sorry.jsp'),('PROG1025','Learning PHP, JS & CSS','Robin Nixon','OReilly','Programming','PHP',105007,20,'PM-JS-C.png','Sorry.jsp'),('PROG1026','Learning PHP, JS, CSS & HTML','Robin Nixon','OReilly','Programming','PHP',103283,0,'PM-JS-CH.png','Sorry.jsp'),('PROG1027','Understanding C Pointers','Richard Reese','OReilly','Programming','CPP',144640,10,'PointersC.png','Sorry.jsp'),('PROG1028','Professional JavaScript','Nicholas Zakas','Wrox','Programming','JS',154531,20,'ProfJS.png','Sorry.jsp'),('PROG1029','Python Programming','Michael Dauson','','Programming','Python',105324,0,'ProgPY.png','Sorry.jsp'),('PROG1030','Agile Web Development with Rails','RailsWD.png','Facets','Programming','Ruby',186692,10,'RailsWD.png','Sorry.jsp'),('PROG1031','Beginning Web Design','Jonathan Fielding','APress','Programming','UI',145572,20,'ResponsiveWD.png','Sorry.jsp'),('PROG1032','C Programming Guide','Dennis Ritchie','Prentice Hall','Programming','CPP',128718,30,'RichieC.png','Sorry.jsp'),('PROG1033','Web Scraping with Python','Ryan Mitchell','OReilly','Programming','Python',143767,20,'ScrapingPY.png','Sorry.jsp'),('PROG1034','Think Python','Allen B. Downey','OReilly','Programming','Python',198947,30,'ThinkPY.png','Sorry.jsp');
/*!40000 ALTER TABLE `books` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `connections`
--
DROP TABLE IF EXISTS `connections`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `connections` (
`cid` int(11) NOT NULL,
`follower_id` varchar(20) DEFAULT NULL,
`follow_id` varchar(20) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `connections`
--
LOCK TABLES `connections` WRITE;
/*!40000 ALTER TABLE `connections` DISABLE KEYS */;
/*!40000 ALTER TABLE `connections` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reviews`
--
DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews` (
`reviewid` varchar(50) NOT NULL,
`bookid` varchar(20) NOT NULL,
`userid` varchar(20) NOT NULL,
`review` varchar(1000) DEFAULT NULL,
`rating` int(11) NOT NULL,
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`reviewid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reviews`
--
LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
INSERT INTO `reviews` VALUES ('bimal.lauhneyACAD1002','ACAD1002','bimal.lauhney','',5,'2018-10-03 11:29:35'),('bimal.lauhneyACAD1004','ACAD1004','bimal.lauhney','',5,'2018-10-03 11:29:43'),('bimal.lauhneyACAD1007','ACAD1007','bimal.lauhney','',2,'2018-10-03 11:29:55'),('bimal.lauhneyACAD1014','ACAD1014','bimal.lauhney','',4,'2018-10-03 11:30:05'),('bimal.lauhneyACAD1019','ACAD1019','bimal.lauhney','',4,'2018-10-03 11:30:18'),('bimal.lauhneyACAD1023','ACAD1023','bimal.lauhney','',5,'2018-10-03 11:30:25'),('bimal.lauhneyACAD1025','ACAD1025','bimal.lauhney','',4,'2018-10-03 11:30:33'),('bimal.lauhneyACAD1026','ACAD1026','bimal.lauhney','',4,'2018-10-03 11:30:39'),('bimal.lauhneyACAD1029','ACAD1029','bimal.lauhney','',5,'2018-10-03 11:30:46'),('bimal.lauhneyACAD1030','ACAD1030','bimal.lauhney','',2,'2018-10-03 11:30:54'),('bimal.lauhneyACAD1035','ACAD1035','bimal.lauhney','',4,'2018-10-03 11:31:31'),('bimal.lauhneyACAD1036','ACAD1036','bimal.lauhney','',4,'2018-10-03 11:31:37'),('bimal.lauhneyACAD1037','ACAD1037','bimal.lauhney','',3,'2018-10-03 11:31:44'),('bimal.lauhneyACAD1038','ACAD1038','bimal.lauhney','',2,'2018-10-03 11:31:51'),('bimal.lauhneyACAD1039','ACAD1039','bimal.lauhney','',4,'2018-10-03 11:31:56'),('bimal.lauhneyACAD1040','ACAD1040','bimal.lauhney','',3,'2018-10-03 11:32:02'),('bimal.lauhneyACAD1041','ACAD1041','bimal.lauhney','',2,'2018-10-03 11:32:08'),('bimal.lauhneyACAD1042','ACAD1042','bimal.lauhney','',1,'2018-10-03 11:32:15'),('bimal.lauhneyACAD1043','ACAD1043','bimal.lauhney','',2,'2018-10-03 11:32:37'),('bimal.lauhneyACAD1044','ACAD1044','bimal.lauhney','',4,'2018-10-03 11:32:44'),('bimal.lauhneyACAD1045','ACAD1045','bimal.lauhney','',1,'2018-10-03 11:32:50'),('bimal.lauhneyNOV1000','NOV1000','bimal.lauhney','',4,'2018-10-03 11:32:58'),('bimal.lauhneyNOV1005','NOV1005','bimal.lauhney','',3,'2018-10-03 11:33:05'),('bimal.lauhneyNOV1006','NOV1006','bimal.lauhney','',2,'2018-10-03 11:33:15'),('bimal.lauhneyNOV1011','NOV1011','bimal.lauhney','',4,'2018-10-03 11:33:23'),('bimal.lauhneyNOV1017','NOV1017','bimal.lauhney','',4,'2018-10-03 11:33:32'),('bimal.lauhneyNOV1023','NOV1023','bimal.lauhney','',5,'2018-10-03 11:33:39'),('bimal.lauhneyNOV1026','NOV1026','bimal.lauhney','',4,'2018-10-03 11:33:46'),('bimal.lauhneyNOV1027','NOV1027','bimal.lauhney','',4,'2018-10-03 11:33:58'),('bimal.lauhneyNOV1036','NOV1036','bimal.lauhney','',5,'2018-10-03 11:34:10'),('bimal.lauhneyNOV1038','NOV1038','bimal.lauhney','',4,'2018-10-03 11:34:16'),('bimal.lauhneyNOV1039','NOV1039','bimal.lauhney','',1,'2018-10-03 11:34:28'),('bimal.lauhneyNOV1040','NOV1040','bimal.lauhney','',1,'2018-10-03 11:34:34'),('bimal.lauhneyNOV1041','NOV1041','bimal.lauhney','',2,'2018-10-03 11:34:40'),('bimal.lauhneyNOV1045','NOV1045','bimal.lauhney','',1,'2018-10-03 11:34:48'),('bimal.lauhneyNOV1046','NOV1046','bimal.lauhney','',4,'2018-10-03 11:34:55'),('bimal.lauhneyNOV1047','NOV1047','bimal.lauhney','',5,'2018-10-03 11:35:02'),('bimal.lauhneyPROG1002','PROG1002','bimal.lauhney','',4,'2018-10-03 11:35:11'),('bimal.lauhneyPROG1004','PROG1004','bimal.lauhney','',1,'2018-10-03 11:35:22'),('bimal.lauhneyPROG1006','PROG1006','bimal.lauhney','',4,'2018-10-03 11:35:28'),('bimal.lauhneyPROG1008','PROG1008','bimal.lauhney','',4,'2018-10-03 11:35:35'),('bimal.lauhneyPROG1011','PROG1011','bimal.lauhney','',1,'2018-10-03 11:35:42'),('bimal.lauhneyPROG1012','PROG1012','bimal.lauhney','',5,'2018-10-03 11:37:54'),('bimal.lauhneyPROG1017','PROG1017','bimal.lauhney','',4,'2018-10-03 11:38:03'),('bimal.lauhneyPROG1018','PROG1018','bimal.lauhney','',4,'2018-10-03 11:38:10'),('bimal.lauhneyPROG1019','PROG1019','bimal.lauhney','',4,'2018-10-03 11:38:17'),('bimal.lauhneyPROG1022','PROG1022','bimal.lauhney','',3,'2018-10-03 11:38:25'),('bimal.lauhneyPROG1024','PROG1024','bimal.lauhney','',3,'2018-10-03 11:38:36'),('bimal.lauhneyPROG1028','PROG1028','bimal.lauhney','',4,'2018-10-03 11:38:44'),('bimal.lauhneyPROG1030','PROG1030','bimal.lauhney','',1,'2018-10-03 11:38:57'),('bimal.lauhneyPROG1032','PROG1032','bimal.lauhney','',4,'2018-10-03 11:39:03'),('bimal.lauhneyPROG1033','PROG1033','bimal.lauhney','',5,'2018-10-03 11:39:09'),('jalaz.kumarACAD1000','ACAD1000','jalaz.kumar','Really Good Book, for Academic Purposes.',4,'2018-09-30 02:53:28'),('jalaz.kumarACAD1001','ACAD1001','jalaz.kumar','Too Hard to grasp up.',2,'2018-09-30 02:53:49'),('jalaz.kumarACAD1002','ACAD1002','jalaz.kumar','Wonderful Book, for basic of Data Structures & Algorithms. Good for Advanced level as well.',5,'2018-09-30 02:54:34'),('jalaz.kumarACAD1003','ACAD1003','jalaz.kumar','Nice Book, on Soft Computing. Indian Writers always Rocks.',4,'2018-09-30 02:55:06'),('jalaz.kumarACAD1004','ACAD1004','jalaz.kumar','Your Review Here, ',4,'2018-09-30 02:55:18'),('jalaz.kumarACAD1005','ACAD1005','jalaz.kumar','',2,'2018-09-30 02:55:30'),('jalaz.kumarACAD1008','ACAD1008','jalaz.kumar','Not good for learners. Highly recommended for experts.',1,'2018-09-30 02:56:01'),('jalaz.kumarACAD1010','ACAD1010','jalaz.kumar','Excellent book on Data Mining & AI. Used for the course curriculum of NITH',4,'2018-09-30 02:57:17'),('jalaz.kumarACAD1011','ACAD1011','jalaz.kumar','Good Book',2,'2018-10-02 22:05:34'),('jalaz.kumarACAD1012','ACAD1012','jalaz.kumar','',2,'2018-10-02 22:06:44'),('jalaz.kumarACAD1013','ACAD1013','jalaz.kumar','',1,'2018-10-02 22:07:24'),('jalaz.kumarACAD1014','ACAD1014','jalaz.kumar','',4,'2018-10-02 22:07:33'),('jalaz.kumarACAD1015','ACAD1015','jalaz.kumar','',4,'2018-10-02 22:07:41'),('jalaz.kumarACAD1016','ACAD1016','jalaz.kumar','',1,'2018-10-02 22:07:52'),('jalaz.kumarACAD1017','ACAD1017','jalaz.kumar','',2,'2018-10-02 22:08:00'),('jalaz.kumarACAD1018','ACAD1018','jalaz.kumar','',2,'2018-10-02 22:08:10'),('jalaz.kumarACAD1019','ACAD1019','jalaz.kumar','',4,'2018-10-02 22:08:20'),('jalaz.kumarACAD1022','ACAD1022','jalaz.kumar','',1,'2018-10-02 22:08:39'),('jalaz.kumarACAD1023','ACAD1023','jalaz.kumar','',4,'2018-10-02 22:09:08'),('jalaz.kumarACAD1024','ACAD1024','jalaz.kumar','',2,'2018-10-02 22:09:14'),('jalaz.kumarACAD1025','ACAD1025','jalaz.kumar','',4,'2018-10-02 22:09:23'),('jalaz.kumarACAD1028','ACAD1028','jalaz.kumar','',1,'2018-10-02 23:05:35'),('jalaz.kumarACAD1029','ACAD1029','jalaz.kumar','',5,'2018-10-02 23:05:43'),('jalaz.kumarACAD1030','ACAD1030','jalaz.kumar','',2,'2018-10-02 23:05:55'),('jalaz.kumarACAD1031','ACAD1031','jalaz.kumar','',3,'2018-10-02 23:06:02'),('jalaz.kumarACAD1034','ACAD1034','jalaz.kumar','',2,'2018-10-02 23:06:11'),('jalaz.kumarACAD1035','ACAD1035','jalaz.kumar','',5,'2018-10-02 23:06:18'),('jalaz.kumarACAD1036','ACAD1036','jalaz.kumar','',4,'2018-10-02 23:06:25'),('jalaz.kumarACAD1037','ACAD1037','jalaz.kumar','',4,'2018-10-02 23:06:33'),('jalaz.kumarACAD1040','ACAD1040','jalaz.kumar','',3,'2018-10-02 23:06:44'),('jalaz.kumarACAD1041','ACAD1041','jalaz.kumar','',2,'2018-10-02 23:06:53'),('jalaz.kumarACAD1042','ACAD1042','jalaz.kumar','',1,'2018-10-02 23:07:00'),('jalaz.kumarACAD1044','ACAD1044','jalaz.kumar','',4,'2018-10-02 23:07:10'),('jalaz.kumarACAD1045','ACAD1045','jalaz.kumar','',2,'2018-10-02 23:07:21'),('jalaz.kumarNOV1000','NOV1000','jalaz.kumar','',4,'2018-10-02 23:07:28'),('jalaz.kumarNOV1001','NOV1001','jalaz.kumar','',3,'2018-10-02 23:07:36'),('jalaz.kumarNOV1003','NOV1003','jalaz.kumar','',4,'2018-10-02 23:07:44'),('jalaz.kumarNOV1004','NOV1004','jalaz.kumar','',3,'2018-10-02 23:08:01'),('jalaz.kumarNOV1005','NOV1005','jalaz.kumar','',2,'2018-10-02 23:08:09'),('jalaz.kumarNOV1006','NOV1006','jalaz.kumar','',1,'2018-10-02 23:08:16'),('jalaz.kumarNOV1007','NOV1007','jalaz.kumar','',4,'2018-10-02 23:08:24'),('jalaz.kumarNOV1010','NOV1010','jalaz.kumar','',3,'2018-10-02 23:08:33'),('jalaz.kumarNOV1011','NOV1011','jalaz.kumar','',5,'2018-10-02 23:08:39'),('jalaz.kumarNOV1012','NOV1012','jalaz.kumar','',2,'2018-10-02 23:08:51'),('jalaz.kumarNOV1014','NOV1014','jalaz.kumar','',4,'2018-10-02 23:08:59'),('jalaz.kumarNOV1015','NOV1015','jalaz.kumar','',5,'2018-10-02 23:09:09'),('jalaz.kumarNOV1016','NOV1016','jalaz.kumar','',3,'2018-10-02 23:09:16'),('jalaz.kumarNOV1018','NOV1018','jalaz.kumar','',2,'2018-10-02 23:12:41'),('jalaz.kumarNOV1019','NOV1019','jalaz.kumar','',3,'2018-10-02 23:12:52'),('jalaz.kumarNOV1020','NOV1020','jalaz.kumar','',4,'2018-10-02 23:13:00'),('jalaz.kumarNOV1022','NOV1022','jalaz.kumar','',5,'2018-10-02 23:13:09'),('jalaz.kumarNOV1024','NOV1024','jalaz.kumar','',4,'2018-10-02 23:13:17'),('jalaz.kumarNOV1025','NOV1025','jalaz.kumar','',4,'2018-10-02 23:13:25'),('jalaz.kumarNOV1028','NOV1028','jalaz.kumar','',2,'2018-10-02 23:13:36'),('jalaz.kumarNOV1029','NOV1029','jalaz.kumar','',3,'2018-10-02 23:13:49'),('jalaz.kumarNOV1032','NOV1032','jalaz.kumar','',2,'2018-10-02 23:13:56'),('jalaz.kumarNOV1034','NOV1034','jalaz.kumar','',2,'2018-10-02 23:14:07'),('jalaz.kumarNOV1036','NOV1036','jalaz.kumar','',4,'2018-10-02 23:14:22'),('jalaz.kumarNOV1037','NOV1037','jalaz.kumar','',5,'2018-10-02 23:14:29'),('jalaz.kumarNOV1038','NOV1038','jalaz.kumar','',3,'2018-10-02 23:14:38'),('jalaz.kumarNOV1040','NOV1040','jalaz.kumar','',2,'2018-10-02 23:14:50'),('jalaz.kumarNOV1041','NOV1041','jalaz.kumar','',3,'2018-10-02 23:15:00'),('jalaz.kumarNOV1043','NOV1043','jalaz.kumar','',4,'2018-10-02 23:16:47'),('jalaz.kumarNOV1044','NOV1044','jalaz.kumar','',4,'2018-10-02 23:16:54'),('jalaz.kumarNOV1046','NOV1046','jalaz.kumar','',4,'2018-10-02 23:17:03'),('jalaz.kumarNOV1047','NOV1047','jalaz.kumar','',5,'2018-10-02 23:17:11'),('jalaz.kumarNOV1048','NOV1048','jalaz.kumar','',2,'2018-10-02 23:17:19'),('jalaz.kumarPROG1000','PROG1000','jalaz.kumar','',2,'2018-10-02 23:17:58'),('jalaz.kumarPROG1001','PROG1001','jalaz.kumar','',2,'2018-10-02 23:18:05'),('jalaz.kumarPROG1002','PROG1002','jalaz.kumar','',4,'2018-10-02 23:18:13'),('jalaz.kumarPROG1003','PROG1003','jalaz.kumar','',2,'2018-10-02 23:18:19'),('jalaz.kumarPROG1004','PROG1004','jalaz.kumar','',3,'2018-10-02 23:18:25'),('jalaz.kumarPROG1005','PROG1005','jalaz.kumar','',2,'2018-10-02 23:18:33'),('jalaz.kumarPROG1006','PROG1006','jalaz.kumar','',4,'2018-10-02 23:18:39'),('jalaz.kumarPROG1009','PROG1009','jalaz.kumar','',4,'2018-10-02 23:18:50'),('jalaz.kumarPROG1010','PROG1010','jalaz.kumar','',1,'2018-10-02 23:18:58'),('jalaz.kumarPROG1011','PROG1011','jalaz.kumar','',3,'2018-10-02 23:19:06'),('jalaz.kumarPROG1012','PROG1012','jalaz.kumar','',4,'2018-10-02 23:20:19'),('jalaz.kumarPROG1013','PROG1013','jalaz.kumar','',1,'2018-10-02 23:20:26'),('jalaz.kumarPROG1014','PROG1014','jalaz.kumar','',2,'2018-10-02 23:20:32'),('jalaz.kumarPROG1015','PROG1015','jalaz.kumar','',4,'2018-10-02 23:20:38'),('jalaz.kumarPROG1016','PROG1016','jalaz.kumar','',2,'2018-10-02 23:20:44'),('jalaz.kumarPROG1017','PROG1017','jalaz.kumar','',4,'2018-10-02 23:20:52'),('jalaz.kumarPROG1018','PROG1018','jalaz.kumar','',4,'2018-10-02 23:20:59'),('jalaz.kumarPROG1019','PROG1019','jalaz.kumar','',4,'2018-10-02 23:21:09'),('jalaz.kumarPROG1021','PROG1021','jalaz.kumar','',2,'2018-10-02 23:21:20'),('jalaz.kumarPROG1023','PROG1023','jalaz.kumar','',5,'2018-10-02 23:21:29'),('jalaz.kumarPROG1025','PROG1025','jalaz.kumar','',1,'2018-10-02 23:21:45'),('jalaz.kumarPROG1026','PROG1026','jalaz.kumar','',2,'2018-10-02 23:21:51'),('jalaz.kumarPROG1028','PROG1028','jalaz.kumar','',4,'2018-10-02 23:21:57'),('jalaz.kumarPROG1029','PROG1029','jalaz.kumar','',3,'2018-10-02 23:22:04'),('jalaz.kumarPROG1030','PROG1030','jalaz.kumar','',2,'2018-10-02 23:22:11'),('jalaz.kumarPROG1032','PROG1032','jalaz.kumar','',4,'2018-10-02 23:22:25'),('jalaz.kumarPROG1033','PROG1033','jalaz.kumar','',4,'2018-10-02 23:22:32'),('jalaz.kumarPROG1034','PROG1034','jalaz.kumar','',4,'2018-10-02 23:23:06'),('narendra.dodwariaACAD1000','ACAD1000','narendra.dodwaria','',4,'2018-10-03 00:11:21'),('narendra.dodwariaACAD1001','ACAD1001','narendra.dodwaria','',1,'2018-10-03 00:11:26'),('narendra.dodwariaACAD1002','ACAD1002','narendra.dodwaria','',4,'2018-10-03 00:11:32'),('narendra.dodwariaACAD1004','ACAD1004','narendra.dodwaria','',4,'2018-10-03 00:11:37'),('narendra.dodwariaACAD1005','ACAD1005','narendra.dodwaria','',2,'2018-10-03 00:11:45'),('narendra.dodwariaACAD1006','ACAD1006','narendra.dodwaria','',2,'2018-10-03 00:11:55'),('narendra.dodwariaACAD1008','ACAD1008','narendra.dodwaria','',3,'2018-10-03 00:12:04'),('narendra.dodwariaACAD1010','ACAD1010','narendra.dodwaria','',4,'2018-10-03 00:12:11'),('narendra.dodwariaACAD1013','ACAD1013','narendra.dodwaria','',2,'2018-10-03 00:12:19'),('narendra.dodwariaACAD1014','ACAD1014','narendra.dodwaria','',5,'2018-10-03 00:12:25'),('narendra.dodwariaACAD1016','ACAD1016','narendra.dodwaria','',2,'2018-10-03 00:12:31'),('narendra.dodwariaACAD1018','ACAD1018','narendra.dodwaria','',1,'2018-10-03 00:12:39'),('narendra.dodwariaACAD1019','ACAD1019','narendra.dodwaria','',2,'2018-10-03 00:12:46'),('narendra.dodwariaACAD1021','ACAD1021','narendra.dodwaria','',1,'2018-10-03 00:12:52'),('narendra.dodwariaACAD1023','ACAD1023','narendra.dodwaria','',4,'2018-10-03 00:13:02'),('narendra.dodwariaACAD1024','ACAD1024','narendra.dodwaria','',4,'2018-10-03 00:13:13'),('narendra.dodwariaACAD1025','ACAD1025','narendra.dodwaria','',3,'2018-10-03 00:13:20'),('narendra.dodwariaACAD1027','ACAD1027','narendra.dodwaria','',2,'2018-10-03 00:13:49'),('narendra.dodwariaACAD1029','ACAD1029','narendra.dodwaria','',4,'2018-10-03 00:13:26'),('narendra.dodwariaACAD1034','ACAD1034','narendra.dodwaria','',4,'2018-10-03 00:13:58'),('narendra.dodwariaACAD1035','ACAD1035','narendra.dodwaria','',5,'2018-10-03 00:14:04'),('narendra.dodwariaACAD1036','ACAD1036','narendra.dodwaria','',3,'2018-10-03 00:14:11'),('narendra.dodwariaACAD1037','ACAD1037','narendra.dodwaria','',3,'2018-10-03 00:14:17'),('narendra.dodwariaACAD1039','ACAD1039','narendra.dodwaria','',2,'2018-10-03 00:14:24'),('narendra.dodwariaACAD1040','ACAD1040','narendra.dodwaria','',1,'2018-10-03 00:14:30'),('narendra.dodwariaACAD1041','ACAD1041','narendra.dodwaria','',2,'2018-10-03 00:14:38'),('narendra.dodwariaACAD1042','ACAD1042','narendra.dodwaria','',3,'2018-10-03 00:14:45'),('narendra.dodwariaACAD1044','ACAD1044','narendra.dodwaria','',4,'2018-10-03 00:15:13'),('narendra.dodwariaNOV1000','NOV1000','narendra.dodwaria','',5,'2018-10-03 00:15:20'),('narendra.dodwariaNOV1004','NOV1004','narendra.dodwaria','',3,'2018-10-03 00:15:29'),('narendra.dodwariaNOV1006','NOV1006','narendra.dodwaria','',2,'2018-10-03 00:15:36'),('narendra.dodwariaNOV1012','NOV1012','narendra.dodwaria','',3,'2018-10-03 00:15:49'),('narendra.dodwariaNOV1014','NOV1014','narendra.dodwaria','',5,'2018-10-03 00:15:56'),('narendra.dodwariaNOV1015','NOV1015','narendra.dodwaria','',4,'2018-10-03 00:16:04'),('narendra.dodwariaNOV1022','NOV1022','narendra.dodwaria','',1,'2018-10-03 00:16:14'),('narendra.dodwariaNOV1025','NOV1025','narendra.dodwaria','',2,'2018-10-03 00:16:22'),('narendra.dodwariaNOV1027','NOV1027','narendra.dodwaria','',2,'2018-10-03 00:16:30'),('narendra.dodwariaNOV1030','NOV1030','narendra.dodwaria','',4,'2018-10-03 00:16:37'),('narendra.dodwariaNOV1034','NOV1034','narendra.dodwaria','',2,'2018-10-03 00:16:50'),('narendra.dodwariaNOV1036','NOV1036','narendra.dodwaria','',4,'2018-10-03 00:16:58'),('narendra.dodwariaNOV1038','NOV1038','narendra.dodwaria','',4,'2018-10-03 00:17:07'),('narendra.dodwariaNOV1039','NOV1039','narendra.dodwaria','',1,'2018-10-03 00:17:18'),('narendra.dodwariaNOV1041','NOV1041','narendra.dodwaria','',2,'2018-10-03 00:17:26'),('narendra.dodwariaNOV1042','NOV1042','narendra.dodwaria','',2,'2018-10-03 00:17:33'),('narendra.dodwariaNOV1049','NOV1049','narendra.dodwaria','',1,'2018-10-03 00:17:42'),('narendra.dodwariaPROG1000','PROG1000','narendra.dodwaria','',5,'2018-10-03 00:17:48'),('narendra.dodwariaPROG1001','PROG1001','narendra.dodwaria','',4,'2018-10-03 00:17:55'),('narendra.dodwariaPROG1002','PROG1002','narendra.dodwaria','',4,'2018-10-03 00:18:03'),('narendra.dodwariaPROG1004','PROG1004','narendra.dodwaria','',3,'2018-10-03 00:18:09'),('narendra.dodwariaPROG1006','PROG1006','narendra.dodwaria','',5,'2018-10-03 00:18:16'),('narendra.dodwariaPROG1007','PROG1007','narendra.dodwaria','',3,'2018-10-03 00:18:24'),('narendra.dodwariaPROG1009','PROG1009','narendra.dodwaria','',4,'2018-10-03 00:18:31'),('narendra.dodwariaPROG1010','PROG1010','narendra.dodwaria','',4,'2018-10-03 00:18:37'),('narendra.dodwariaPROG1011','PROG1011','narendra.dodwaria','',3,'2018-10-03 00:18:42'),('narendra.dodwariaPROG1013','PROG1013','narendra.dodwaria','',1,'2018-10-03 00:18:51'),('narendra.dodwariaPROG1015','PROG1015','narendra.dodwaria','',2,'2018-10-03 00:18:58'),('narendra.dodwariaPROG1016','PROG1016','narendra.dodwaria','',5,'2018-10-03 00:19:03'),('narendra.dodwariaPROG1017','PROG1017','narendra.dodwaria','',4,'2018-10-03 00:19:09'),('narendra.dodwariaPROG1019','PROG1019','narendra.dodwaria','',3,'2018-10-03 00:19:16'),('narendra.dodwariaPROG1021','PROG1021','narendra.dodwaria','',2,'2018-10-03 00:19:25'),('narendra.dodwariaPROG1023','PROG1023','narendra.dodwaria','',4,'2018-10-03 00:19:32'),('narendra.dodwariaPROG1025','PROG1025','narendra.dodwaria','',4,'2018-10-03 00:19:42'),('narendra.dodwariaPROG1027','PROG1027','narendra.dodwaria','',4,'2018-10-03 00:19:49'),('narendra.dodwariaPROG1028','PROG1028','narendra.dodwaria','',3,'2018-10-03 00:19:55'),('narendra.dodwariaPROG1030','PROG1030','narendra.dodwaria','',1,'2018-10-03 00:20:02'),('narendra.dodwariaPROG1033','PROG1033','narendra.dodwaria','',3,'2018-10-03 00:20:16'),('saurabh.kumarACAD1000','ACAD1000','saurabh.kumar','',4,'2018-10-02 23:52:54'),('saurabh.kumarACAD1002','ACAD1002','saurabh.kumar','',5,'2018-10-02 23:53:01'),('saurabh.kumarACAD1003','ACAD1003','saurabh.kumar','',3,'2018-10-02 23:53:07'),('saurabh.kumarACAD1009','ACAD1009','saurabh.kumar','',1,'2018-10-02 23:53:17'),('saurabh.kumarACAD1010','ACAD1010','saurabh.kumar','',4,'2018-10-02 23:53:23'),('saurabh.kumarACAD1012','ACAD1012','saurabh.kumar','',2,'2018-10-02 23:53:33'),('saurabh.kumarACAD1013','ACAD1013','saurabh.kumar','',1,'2018-10-02 23:53:41'),('saurabh.kumarACAD1014','ACAD1014','saurabh.kumar','',3,'2018-10-02 23:53:48'),('saurabh.kumarACAD1015','ACAD1015','saurabh.kumar','',4,'2018-10-02 23:53:57'),('saurabh.kumarACAD1017','ACAD1017','saurabh.kumar','',3,'2018-10-02 23:54:14'),('saurabh.kumarACAD1019','ACAD1019','saurabh.kumar','',4,'2018-10-02 23:54:21'),('saurabh.kumarACAD1022','ACAD1022','saurabh.kumar','',1,'2018-10-02 23:54:28'),('saurabh.kumarACAD1025','ACAD1025','saurabh.kumar','',4,'2018-10-02 23:54:35'),('saurabh.kumarACAD1026','ACAD1026','saurabh.kumar','',3,'2018-10-02 23:54:43'),('saurabh.kumarACAD1029','ACAD1029','saurabh.kumar','',5,'2018-10-02 23:54:49'),('saurabh.kumarACAD1032','ACAD1032','saurabh.kumar','',4,'2018-10-02 23:54:56'),('saurabh.kumarACAD1033','ACAD1033','saurabh.kumar','',3,'2018-10-02 23:55:03'),('saurabh.kumarACAD1034','ACAD1034','saurabh.kumar','',1,'2018-10-02 23:55:10'),('saurabh.kumarACAD1035','ACAD1035','saurabh.kumar','',5,'2018-10-02 23:55:15'),('saurabh.kumarACAD1036','ACAD1036','saurabh.kumar','',4,'2018-10-02 23:55:22'),('saurabh.kumarACAD1037','ACAD1037','saurabh.kumar','',2,'2018-10-02 23:55:44'),('saurabh.kumarACAD1042','ACAD1042','saurabh.kumar','',2,'2018-10-02 23:55:53'),('saurabh.kumarACAD1044','ACAD1044','saurabh.kumar','',4,'2018-10-02 23:56:07'),('saurabh.kumarNOV1000','NOV1000','saurabh.kumar','',4,'2018-10-02 23:33:24'),('saurabh.kumarNOV1001','NOV1001','saurabh.kumar','',4,'2018-10-02 23:33:29'),('saurabh.kumarNOV1003','NOV1003','saurabh.kumar','',1,'2018-10-02 23:33:35'),('saurabh.kumarNOV1004','NOV1004','saurabh.kumar','',1,'2018-10-02 23:33:43'),('saurabh.kumarNOV1006','NOV1006','saurabh.kumar','',1,'2018-10-02 23:33:51'),('saurabh.kumarNOV1007','NOV1007','saurabh.kumar','',2,'2018-10-02 23:34:03'),('saurabh.kumarNOV1009','NOV1009','saurabh.kumar','',4,'2018-10-02 23:34:13'),('saurabh.kumarNOV1011','NOV1011','saurabh.kumar','',4,'2018-10-02 23:34:20'),('saurabh.kumarNOV1012','NOV1012','saurabh.kumar','',1,'2018-10-02 23:34:26'),('saurabh.kumarNOV1013','NOV1013','saurabh.kumar','',5,'2018-10-02 23:34:32'),('saurabh.kumarNOV1014','NOV1014','saurabh.kumar','',3,'2018-10-02 23:34:38'),('saurabh.kumarNOV1015','NOV1015','saurabh.kumar','',4,'2018-10-02 23:34:45'),('saurabh.kumarNOV1016','NOV1016','saurabh.kumar','',2,'2018-10-02 23:34:52'),('saurabh.kumarNOV1018','NOV1018','saurabh.kumar','',2,'2018-10-02 23:35:03'),('saurabh.kumarNOV1019','NOV1019','saurabh.kumar','',1,'2018-10-02 23:35:09'),('saurabh.kumarNOV1020','NOV1020','saurabh.kumar','',4,'2018-10-02 23:35:16'),('saurabh.kumarNOV1021','NOV1021','saurabh.kumar','',5,'2018-10-02 23:35:22'),('saurabh.kumarNOV1022','NOV1022','saurabh.kumar','',4,'2018-10-02 23:35:29'),('saurabh.kumarNOV1025','NOV1025','saurabh.kumar','',4,'2018-10-02 23:35:36'),('saurabh.kumarNOV1028','NOV1028','saurabh.kumar','',1,'2018-10-02 23:35:43'),('saurabh.kumarNOV1029','NOV1029','saurabh.kumar','',5,'2018-10-02 23:35:50'),('saurabh.kumarNOV1030','NOV1030','saurabh.kumar','',4,'2018-10-02 23:36:22'),('saurabh.kumarNOV1031','NOV1031','saurabh.kumar','',1,'2018-10-02 23:36:27'),('saurabh.kumarNOV1032','NOV1032','saurabh.kumar','',1,'2018-10-02 23:36:35'),('saurabh.kumarNOV1033','NOV1033','saurabh.kumar','',4,'2018-10-02 23:36:43'),('saurabh.kumarNOV1034','NOV1034','saurabh.kumar','',1,'2018-10-02 23:36:49'),('saurabh.kumarNOV1036','NOV1036','saurabh.kumar','',4,'2018-10-02 23:36:55'),('saurabh.kumarNOV1037','NOV1037','saurabh.kumar','',5,'2018-10-02 23:37:02'),('saurabh.kumarNOV1038','NOV1038','saurabh.kumar','',5,'2018-10-02 23:37:08'),('saurabh.kumarNOV1039','NOV1039','saurabh.kumar','',1,'2018-10-02 23:37:23'),('saurabh.kumarNOV1040','NOV1040','saurabh.kumar','',1,'2018-10-02 23:37:29'),('saurabh.kumarNOV1043','NOV1043','saurabh.kumar','',4,'2018-10-02 23:37:47'),('saurabh.kumarNOV1046','NOV1046','saurabh.kumar','',3,'2018-10-02 23:37:56'),('saurabh.kumarNOV1047','NOV1047','saurabh.kumar','',4,'2018-10-02 23:38:19'),('saurabh.kumarNOV1048','NOV1048','saurabh.kumar','',2,'2018-10-02 23:38:26'),('saurabh.kumarPROG1001','PROG1001','saurabh.kumar','',5,'2018-10-02 23:51:43'),('saurabh.kumarPROG1002','PROG1002','saurabh.kumar','',3,'2018-10-02 23:51:56'),('saurabh.kumarPROG1003','PROG1003','saurabh.kumar','',4,'2018-10-02 23:51:49'),('saurabh.kumarPROG1004','PROG1004','saurabh.kumar','',1,'2018-10-02 23:52:02'),('saurabh.kumarPROG1005','PROG1005','saurabh.kumar','',4,'2018-10-02 23:52:12'),('saurabh.kumarPROG1008','PROG1008','saurabh.kumar','',4,'2018-10-02 23:51:35'),('saurabh.kumarPROG1009','PROG1009','saurabh.kumar','',2,'2018-10-02 23:51:27'),('saurabh.kumarPROG1010','PROG1010','saurabh.kumar','',4,'2018-10-02 23:51:21'),('saurabh.kumarPROG1011','PROG1011','saurabh.kumar','',1,'2018-10-02 23:51:08'),('saurabh.kumarPROG1014','PROG1014','saurabh.kumar','',4,'2018-10-02 23:51:00'),('saurabh.kumarPROG1016','PROG1016','saurabh.kumar','',1,'2018-10-02 23:50:52'),('saurabh.kumarPROG1017','PROG1017','saurabh.kumar','',1,'2018-10-02 23:50:45'),('saurabh.kumarPROG1018','PROG1018','saurabh.kumar','',2,'2018-10-02 23:50:39'),('saurabh.kumarPROG1019','PROG1019','saurabh.kumar','',5,'2018-10-02 23:50:09'),('saurabh.kumarPROG1020','PROG1020','saurabh.kumar','',4,'2018-10-02 23:50:16'),('saurabh.kumarPROG1022','PROG1022','saurabh.kumar','',4,'2018-10-02 23:50:25'),('saurabh.kumarPROG1023','PROG1023','saurabh.kumar','',4,'2018-10-02 23:50:32'),('saurabh.kumarPROG1026','PROG1026','saurabh.kumar','',1,'2018-10-02 23:50:02'),('saurabh.kumarPROG1027','PROG1027','saurabh.kumar','',4,'2018-10-02 23:49:57'),('saurabh.kumarPROG1028','PROG1028','saurabh.kumar','',5,'2018-10-02 23:49:50'),('saurabh.kumarPROG1030','PROG1030','saurabh.kumar','',1,'2018-10-02 23:49:43'),('saurabh.kumarPROG1031','PROG1031','saurabh.kumar','',5,'2018-10-02 23:49:37'),('saurabh.kumarPROG1032','PROG1032','saurabh.kumar','',4,'2018-10-02 23:49:29'),('saurabh.kumarPROG1033','PROG1033','saurabh.kumar','',2,'2018-10-02 23:49:21'),('saurabh.kumarPROG1034','PROG1034','saurabh.kumar','',1,'2018-10-02 23:48:53'),('sukhbir.singhACAD1002','ACAD1002','sukhbir.singh','',4,'2018-10-02 23:56:45'),('sukhbir.singhACAD1003','ACAD1003','sukhbir.singh','',5,'2018-10-02 23:56:38'),('sukhbir.singhACAD1004','ACAD1004','sukhbir.singh','',4,'2018-10-02 23:56:52'),('sukhbir.singhACAD1006','ACAD1006','sukhbir.singh','',2,'2018-10-02 23:57:05'),('sukhbir.singhACAD1015','ACAD1015','sukhbir.singh','',4,'2018-10-02 23:57:21'),('sukhbir.singhACAD1018','ACAD1018','sukhbir.singh','',3,'2018-10-02 23:57:35'),('sukhbir.singhACAD1020','ACAD1020','sukhbir.singh','',1,'2018-10-02 23:57:42'),('sukhbir.singhACAD1023','ACAD1023','sukhbir.singh','',4,'2018-10-02 23:57:50'),('sukhbir.singhACAD1024','ACAD1024','sukhbir.singh','',5,'2018-10-02 23:57:56'),('sukhbir.singhACAD1025','ACAD1025','sukhbir.singh','',4,'2018-10-02 23:58:04'),('sukhbir.singhACAD1026','ACAD1026','sukhbir.singh','',3,'2018-10-02 23:58:11'),('sukhbir.singhACAD1029','ACAD1029','sukhbir.singh','',5,'2018-10-02 23:58:17'),('sukhbir.singhACAD1030','ACAD1030','sukhbir.singh','',2,'2018-10-02 23:58:25'),('sukhbir.singhACAD1032','ACAD1032','sukhbir.singh','',5,'2018-10-02 23:58:32'),('sukhbir.singhACAD1034','ACAD1034','sukhbir.singh','',3,'2018-10-02 23:58:38'),('sukhbir.singhACAD1035','ACAD1035','sukhbir.singh','',4,'2018-10-02 23:58:44'),('sukhbir.singhACAD1036','ACAD1036','sukhbir.singh','',4,'2018-10-02 23:59:02'),('sukhbir.singhACAD1042','ACAD1042','sukhbir.singh','',1,'2018-10-02 23:59:35'),('sukhbir.singhACAD1043','ACAD1043','sukhbir.singh','',1,'2018-10-02 23:59:43'),('sukhbir.singhACAD1045','ACAD1045','sukhbir.singh','',1,'2018-10-02 23:59:50'),('sukhbir.singhNOV1011','NOV1011','sukhbir.singh','',4,'2018-10-03 00:00:06'),('sukhbir.singhNOV1014','NOV1014','sukhbir.singh','',5,'2018-10-03 00:00:21'),('sukhbir.singhNOV1017','NOV1017','sukhbir.singh','',4,'2018-10-03 00:00:30'),('sukhbir.singhNOV1020','NOV1020','sukhbir.singh','',4,'2018-10-03 00:00:36'),('sukhbir.singhNOV1022','NOV1022','sukhbir.singh','',5,'2018-10-03 00:00:43'),('sukhbir.singhNOV1023','NOV1023','sukhbir.singh','',4,'2018-10-03 00:00:49'),('sukhbir.singhNOV1024','NOV1024','sukhbir.singh','',5,'2018-10-03 00:00:55'),('sukhbir.singhNOV1025','NOV1025','sukhbir.singh','',4,'2018-10-03 00:01:01'),('sukhbir.singhNOV1037','NOV1037','sukhbir.singh','',4,'2018-10-03 00:01:14'),('sukhbir.singhNOV1041','NOV1041','sukhbir.singh','',3,'2018-10-03 00:01:26'),('sukhbir.singhNOV1048','NOV1048','sukhbir.singh','',2,'2018-10-03 00:01:37'),('sukhbir.singhPROG1000','PROG1000','sukhbir.singh','',1,'2018-10-03 00:01:43'),('sukhbir.singhPROG1001','PROG1001','sukhbir.singh','',3,'2018-10-03 00:01:51'),('sukhbir.singhPROG1002','PROG1002','sukhbir.singh','',3,'2018-10-03 00:02:00'),('sukhbir.singhPROG1004','PROG1004','sukhbir.singh','',5,'2018-10-03 00:02:06'),('sukhbir.singhPROG1005','PROG1005','sukhbir.singh','',3,'2018-10-03 00:02:15'),('sukhbir.singhPROG1008','PROG1008','sukhbir.singh','',4,'2018-10-03 00:02:24'),('sukhbir.singhPROG1011','PROG1011','sukhbir.singh','',5,'2018-10-03 00:02:44'),('sukhbir.singhPROG1013','PROG1013','sukhbir.singh','',4,'2018-10-03 00:02:55'),('sukhbir.singhPROG1014','PROG1014','sukhbir.singh','',2,'2018-10-03 00:03:02'),('sukhbir.singhPROG1015','PROG1015','sukhbir.singh','',5,'2018-10-03 00:03:11'),('sukhbir.singhPROG1016','PROG1016','sukhbir.singh','',1,'2018-10-03 00:03:21'),('sukhbir.singhPROG1017','PROG1017','sukhbir.singh','',2,'2018-10-03 00:08:39'),('sukhbir.singhPROG1021','PROG1021','sukhbir.singh','',2,'2018-10-03 00:08:51'),('sukhbir.singhPROG1023','PROG1023','sukhbir.singh','',4,'2018-10-03 00:08:57'),('sukhbir.singhPROG1025','PROG1025','sukhbir.singh','',1,'2018-10-03 00:09:05'),('sukhbir.singhPROG1028','PROG1028','sukhbir.singh','',3,'2018-10-03 00:09:45'),('sukhbir.singhPROG1030','PROG1030','sukhbir.singh','',5,'2018-10-03 00:09:53'),('sukhbir.singhPROG1032','PROG1032','sukhbir.singh','',5,'2018-10-03 00:10:00'),('sukhbir.singhPROG1034','PROG1034','sukhbir.singh','',3,'2018-10-03 00:10:10');
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shelfs`
--
DROP TABLE IF EXISTS `shelfs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shelfs` (
`tid` int(11) NOT NULL DEFAULT '0',
`bookid` varchar(20) NOT NULL,
`userid` varchar(20) NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shelfs`
--
LOCK TABLES `shelfs` WRITE;
/*!40000 ALTER TABLE `shelfs` DISABLE KEYS */;
INSERT INTO `shelfs` VALUES (100576,'PROG1005','saurabh.kumar'),(102946,'NOV1015','jalaz.kumar'),(107677,'PROG1009','jalaz.kumar'),(123131,'ACAD1030','bimal.lauhney'),(125633,'PROG1023','jalaz.kumar'),(130490,'PROG1030','sukhbir.singh'),(132247,'PROG1003','saurabh.kumar'),(146188,'ACAD1009','sukhbir.singh'),(151886,'PROG1012','bimal.lauhney'),(156265,'ACAD1004','bimal.lauhney'),(167179,'NOV1046','bimal.lauhney'),(168023,'PROG1004','sukhbir.singh'),(170811,'NOV1033','sukhbir.singh'),(171297,'NOV1046','jalaz.kumar'),(177939,'ACAD1042','bimal.lauhney'),(184311,'PROG1013','sukhbir.singh'),(187625,'PROG1011','sukhbir.singh'),(188858,'PROG1023','bimal.lauhney'),(189088,'PROG1023','sukhbir.singh'),(189923,'NOV1017','saurabh.kumar');
/*!40000 ALTER TABLE `shelfs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`userid` varchar(20) NOT NULL,
`name` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`contact` varchar(20) NOT NULL,
`city` varchar(20) DEFAULT NULL,
`queryid` int(11) NOT NULL,
`tokens` int(11) DEFAULT NULL,
`profilepic` varchar(50) DEFAULT 'default.png',
PRIMARY KEY (`userid`),
UNIQUE KEY `queryid` (`queryid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('akhilesh.kumar','Akhilesh Kumar','[email protected]','8ff16144547abc3939f0d11cce7dc887','9878767676','Banda',167416,500,'akhilesh.jpeg'),('anita.rani','Anita Rani','[email protected]','35063f67991237a06dcf7185f5587e1e','9887654321','Saharanpur',181283,500,'anita.jpg'),('atul.kumar','Atul Kumar','[email protected]','f4ab7eddbdd73c2cc291b330e9a69f11','9882238075','Kanpur',118522,500,'atulkumar.jpeg'),('bimal.lauhney','Bimalkant Lauhney','[email protected]','aae73747721e64d4da79e177dcb38507','9878987894','Rudraprayag',149432,400,'bimal.jpeg'),('deep.shikha','Deepshikha','[email protected]','db29735f9989709d33778dc58168ff0a','9876543210','Saharanpur',191211,500,'Deepu.jpg'),('deshpal.aec','Deshpal Singh','[email protected]','a3043d6e0a3beb5bc0899ac0baf7a8bb','8755944473','Meerut',151232,500,'deshpal.jpg'),('govind.bisht','Govind Bisht','[email protected]','f708f892d765e4adcaf2902f5eb066e6','8767876563','Almora',198330,500,'govind.jpeg'),('jalaz.kumar','Jalaz Kumar','[email protected]','bfedb108f5ef51906c4b577bba590776','9882552289','Saharanpur',110157,430,'jalaz.jpg'),('mukesh.kharita','Mukesh Kharita','[email protected]','d35f6c6a31fdf45e5ee4058b1adb534c','6787678789','Jaipur',151208,500,'mukesh.jpeg'),('narendra.dodwaria','Narendra Dodwaria','[email protected]','7bebef290f4b69b1b6595c98e84e98da','7898779898','Sikar',182628,500,'narendra.jpeg'),('pavan.bansal','Pavan Bansal','[email protected]','28bae51670dbd54d1a504de101708d4a','8787865543','Gwalior',131210,500,'pavan.jpeg'),('saurabh.kumar','Saurabh Kumar','[email protected]','1160c2b751f657eb21965860f81b7fd9','9882552389','Patna',116437,400,'saurabh.jpeg'),('shubham.bhatt','Shubham Bhatt','[email protected]','4cdd4687f830775cbab329e5e1289604','9759947092','Almora',144412,500,'shubham.jpeg'),('sukhbir.singh','Sukhbir Singh','[email protected]','3773fd7f1041e30689b978b90ba6eb6c','9882546092','Jaipur',135030,400,'sukhbir.jpeg');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2018-10-14 0:21:41