College_details.sql

SET search_path TO sports;

---------------------------------------------------------------
insert into college Values('101','IIT Gandhinagar','Gandhinagar','Gujarat');
insert into college Values('102','IIIT Vadodara','Gandhinagar','Gujarat');
insert into college Values('120','Motilal Nehru Institute of Technology','Jaipur','Rajasthan');
insert into college Values('143','IIIT Kota','Kota','Rajasthan');
insert into college Values('132','IIIT Allahabad','Allahabad','Uttar Pradesh');
insert into college Values('125','Dhirubhai Ambani Institute of Information of Technology','Gandhinagar','Gujarat');
insert into college Values('130','National Institute of Technology,Allahabad','Allahabad','Uttar Pradesh');
insert into college Values('119','Indian Institute of Technology,Jodhpur','Jodhpur','Rajasthan');

------------------------------------------------------------------------------------------------------------------------------------------------------

insert into games Values('Cricket','15');
insert into games Values('Basketball','5');
insert into games Values('Chess','5');
---------------------------------------------------------------------

insert into teams Values('20071101','101','The Master Batters','cricket','20071101005','10111');
insert into teams Values('20071102','119','Ball Busters','cricket','20071102007','11902');
insert into teams Values('20071103','120','Screw Balls','cricket','20071103009','12032');
insert into teams Values('20071104','143','Crazed Wombats','cricket','20071104013','143101');



insert into teams Values('20072101','101','Blue Balls of Destiny','basketball','20072101003','10112');
insert into teams Values('20072102','120','Soup-A-Stars','basketball','20072102004','12031');
insert into teams Values('20072103','102','Basket Brawlers','basketball','20072103001','102111');
insert into teams Values('20072104','130','The FlyBallers','basketball','20072104007','130132');


insert into teams Values('20073101','132','The Chess Nuts','chess','20073101002','132171');
insert into teams Values('20073102','119','Powerfull Minds','chess','20073102003','11901');
insert into teams Values('20073103','130','Chess Fans','chess','20073103001','130131');
insert into teams Values('20073104','125','The King Stompers','chess','20073104005','12551');

-------------------------------------------------------------------------

insert into mentor Values('10111','Mr. Harish','7575053163','101');
insert into mentor Values('10112','Mr. Ranjeet','7792005762','101');
insert into mentor Values('11901','Mr. Sonal','8460557570','119');
insert into mentor Values('11902','Mr. Suresh','9974340522','119');
insert into mentor Values('12031','Mr. Ravikishan','7891115503','120');
insert into mentor Values('12032','Mr. Mukesh','7567775696','120');
insert into mentor Values('143101','Mr. Navneet','9636384125','143');
insert into mentor Values('102111','Mr. Hada','8829913245','102');
insert into mentor Values('130131','Mr. Rajeev','7891635410','130');
insert into mentor Values('130132','Mr. Pandey','9429452824',''130);
insert into mentor Values('12551','Mr. Sain','9429452480','125');
insert into mentor Values('132171','Mr. Nigam','7567775852','132');