ejcabarles/import.sql

## import.sql
INSERT INTO user VALUES (1,'asmith0','$2a$10$lwsdMs1oR3xqKtz0lVTIIOd7H/1t8TpZuVmYPwcjtS067HnZiIzxy','jhawkins0@tuttocitta.it','62-(577)399-7885','A',0);
INSERT INTO user VALUES (2,'jramirez1','$2a$10$TsvjLdfO.NnDul03QKy.8uppWDR.8L5hmfWFIbFbpPvJwEq304Os.','tjenkins1@amazon.co.uk','358-(160)503-6933','A',1);
INSERT INTO user VALUES (3,'mwillis2','$2a$10$jmoDlpASfAZzNddnK0u8T.wCHJACaeoC2WlzY6Cv.Yud6BWEadK3e','adean2@1688.com','48-(430)228-8448','A',0);
INSERT INTO user VALUES (4,'ehawkins3','$2a$10$p1LjciDnvKkzRQim2ZzLmOK5gqC3YgtIsyfs2iXssswenKDyf9GN2','alawson3@nih.gov','86-(560)849-2974','A',0);
INSERT INTO user VALUES (5,'wfox4','$2a$10$kOv6fuMZ3SjLLXh6QmP4Yu5qDlQ3E6BtMvRodXGvbUu.uKpa4VMg.','jmurphy4@vistaprint.com','62-(363)197-8873','A',1);
INSERT INTO user VALUES (6,'rkelley5','$2a$10$Axk3jgfsYL.zx1ejWS4AquwK6Q9yA6hBkrNPwfB32h.ONrSrnTDDy','jreyes5@cloudflare.com','63-(469)532-8744','A',1);
INSERT INTO user VALUES (7,'acampbell6','$2a$10$ns3v7Ta7UZNYVLWZt/17Ku1O431a3ibz6Qk62vDsOKKKmRcAn24T6','mharrison6@cargocollective.com','52-(366)499-5858','A',1);
INSERT INTO user VALUES (8,'dmason7','$2a$10$IUiomL979RhNUX.EGaKMrO0t9hvKKC1DMWStJU.0AMFQhqqmQJZkO','calvarez7@wp.com','64-(777)683-0986','A',0);
INSERT INTO user VALUES (9,'pfoster8','$2a$10$wNIGLmsS5sIhChVQR5v3P.cZ9hF9ocacAcv8mmx14q.JLctJRtZn6','abradley8@51.la','504-(801)260-9465','A',1);
INSERT INTO user VALUES (10,'rward9','$2a$10$cLki4Zj0TT.LLeWsfF465u/GBSBl2IFN4dGAma8Hs3e/MpEk6kyIC','jgraham9@bing.com','62-(327)123-3269','A',0);

INSERT INTO user VALUES (11,'beili','$2a$10$hv9kLyC28lE27H7llCL0L.LZczdXcEGQskmqzttCcMGwTX6RzgBn2','kberry0@shutterfly.com','62-(577)399-7885','C',1);
INSERT INTO user VALUES (12,'ralph','$2a$10$BiEvhLgGfAm9fPVtUYaX8OTJfZs7vQGj4Q8forLRROo1vbWrUqQ72','hwatson1@ezinearticles.com','358-(160)503-6933','C',1);
INSERT INTO user VALUES (13,'adrian','$2a$10$b0MJcS4SZFY3pSOX7CbAR.WGGtaK4SSqxqsp7o3ttPakEO2hY0SOq','plewis2@home.pl','48-(430)228-8448','C',0);
INSERT INTO user VALUES (14,'paula','$2a$10$fB00WaILw7CpGnUjRPQzYejd9xir5IkLPLu7O4htvCBvj9SX1c5p6','aknight3@washington.edu','86-(560)849-2974','C',0);
INSERT INTO user VALUES (15,'jc','$2a$10$XJHfgc7D0Qj0L0iYq1rA5OioPOBn0wwJXwXjsw9yiAU6FzYU79XJ2','mlee4@earthlink.net','62-(363)197-8873','C',1);
INSERT INTO user VALUES (16,'emy','$2a$10$wVCpssLiDmR6O9NYK9mCUeBVjIsuDlOppUUkoGJos1caIWbeBlDoW','cfranklin5@opensource.org','63-(469)532-8744','C',0);
INSERT INTO user VALUES (17,'clark','$2a$10$tqzSnPlNRoyo/05qU.K5KuFHEb7BRrCb8jr7jWtjpiTcW0cQqVysy','dwatkins6@cornell.edu','52-(366)499-5858','C',1);
INSERT INTO user VALUES (18,'melbex','$2a$10$fkJBUl5KKN0QU4CdnxcnRuORraC.hVaoRq17fS2qS2mtOi84ZiUKu','adean7@tumblr.com','64-(777)683-0986','C',0);
INSERT INTO user VALUES (19,'brixter','$2a$10$rccqtU9TZmRmzFPQfzdMb.glQlHXupXg9KYJCHFVl1cyzJY5jNKM6','aromero8@facebook.com','504-(801)260-9465','C',1);
INSERT INTO user VALUES (20,'aleck','$2a$10$Zfvuu3QHRvD9cRChxQ0AQePDXG28DxdIRAy0Wsk3kCKYXZr6FZUBq','hmyers9@miibeian.gov.cn','62-(327)123-3269','C',0);
INSERT INTO user VALUES (21,'yssel','$2a$10$4oIlIUm7CH/sDwXQFdXsYe0QrfG4SCqTepPzi9zCRYA5mHJHkBo1y','aharrisa@reverbnation.com','62-(577)399-7885','C',0);
INSERT INTO user VALUES (22,'kenichii','$2a$10$Q/WWdOaQ0HKmfm7KUNtTOuLE5iKM.c6nEz.egL3jHtsq/imc/NwN6','sfrazierb@shop-pro.jp','358-(160)503-6933','C',0);
INSERT INTO user VALUES (23,'caroline','$2a$10$YhoftMCct7I55twvrWfbm.bUdRbFDleirKkGDom.xWTT2YP8nu3Xi','mgordonc@plala.or.jp','48-(430)228-8448','C',0);
INSERT INTO user VALUES (24,'jourish','$2a$10$QI0ydEGLZE8010qH7R1tF.frQetiyA8cT.CXmzFhwkBoPS..Vqjeu','flawrenced@prlog.org','86-(560)849-2974','C',0);
INSERT INTO user VALUES (25,'meika','$2a$10$OS11GlbHMVfYzpn4vlF5y.9umtXKHUD03/.JSfJ2a87bNdNJZZKvG','eelliotte@irs.gov','62-(363)197-8873','C',1);
INSERT INTO user VALUES (26,'anton','$2a$10$LsUi2fe9DCv5V//ZpRsmaepeUtq9eMNRN9BYv5UkH9fYIZBlVDYUK','aporterf@wsj.com','63-(469)532-8744','C',0);
INSERT INTO user VALUES (27,'jlo','$2a$10$0rm1t3D5sD1fXM11V/Fv2.yDpmzSSIKgfIv0Hock2OcUq1oAB8IvG','jrussellg@irs.gov','52-(366)499-5858','C',0);
INSERT INTO user VALUES (28,'migui','$2a$10$3KLRuhNERTaq4u6RSzHFs.0z9oMDsRiCvyXbuDZIVwggx9KhvFq8O','sgardnerh@arstechnica.com','64-(777)683-0986','C',0);
INSERT INTO user VALUES (29,'patty','$2a$10$Nf2dWkodBLooVNsXxV/BS.oYd2/zHfhj2lK5xeMw.MPO6nzFQl2Ci','stuckeri@cnn.com','504-(801)260-9465','C',1);
INSERT INTO user VALUES (30,'paul','$2a$10$2h1ML/H3DfphvciX4vgI5e/noKdHrrtGRgO07nqRm.dHTOXNQeot.','jwalkerj@zimbio.com','62-(327)123-3269','C',0);
INSERT INTO user VALUES (31,'betel','$2a$10$RduwtrBYi.8LOwX83TA/O.1lNWarT5DV0E3pft3Z2SZhaOmOtneMS','gwoodsk@smh.com.au','62-(577)399-7885','C',1);
INSERT INTO user VALUES (32,'manong_guard','$2a$10$JGesVPYS3imyB.YPnsSuAuPAFVBzMV.e2bvgwmm4lcmEDuRSBqiom','smoralesl@thetimes.co.uk','358-(160)503-6933','C',0);
INSERT INTO user VALUES (33,'unicorn_princess','$2a$10$PVlexQOcGEedjiLmB1ku4uvGdfOJcXoibYxSBzrr3kLvHNFrD1JPW','acolem@dell.com','48-(430)228-8448','C',0);
INSERT INTO user VALUES (34,'hermione','$2a$10$U2yNbDrKLEjDRghPyyMGgOW07rVu34XaFJpD/w/MkJQlgK1yDjMSq','wcolen@vimeo.com','86-(560)849-2974','C',1);
INSERT INTO user VALUES (35,'harry','$2a$10$uO42EnoO3WVvmBGfGUpCdOB3x8rNoiYsVLOnVrnxTfSPx73atewlK','mhanseno@bloomberg.com','62-(363)197-8873','C',1);
INSERT INTO user VALUES (36,'ron','$2a$10$ATh0biJthPFPt7M2aPamQOes9oQAiGO/Ue81GnolOKM6k0pww8DZm','rmartinp@paginegialle.it','63-(469)532-8744','C',0);
INSERT INTO user VALUES (37,'draco','$2a$10$VaJjwCiSS/xvx0vfelNj0OODR2z.PPRhGz2Spxsgq6abbK502k0iW','stuckerq@mapquest.com','52-(366)499-5858','C',1);
INSERT INTO user VALUES (38,'snape','$2a$10$aTG1qbUMqvVwii9uOvlKNOEz7C2MAc0fKER3NrUKnZN3z2VCy9ZIO','tgilbertr@artisteer.com','64-(777)683-0986','C',0);
INSERT INTO user VALUES (39,'dumbledore','$2a$10$VPWpCmeyQ8jdM.0uA82XJOFSebRszM9664OQ6wkGNCFaYzEPj177W','tlarsons@aboutads.info','504-(801)260-9465','C',0);
INSERT INTO user VALUES (40,'hedwig','$2a$10$5OgzvnO/kcrVH69ZQOi.dOEeugtmfd33BwbsQwy4AcyvbU.uck2Be','wrobertst@goo.gl','62-(327)123-3269','C',0);

INSERT INTO user VALUES (41,'cas','$2a$10$mQYsU8J.eGmu5YeHMXbqHOPoi0g5ytid/qI1C85SOgE5HHOKHzYyy','wnichols0@nymag.com','62-(327)123-3269','O',1);
INSERT INTO user VALUES (42,'che','$2a$10$rCBgovpUKXu/gBc.JDgJB.U3N9btXkwBaFYQxYkfGbvt5H.QPObFy','jbrooks1@wp.com','62-(577)399-7885','O',1);
INSERT INTO user VALUES (43,'ceat','$2a$10$m13mAstG.h2zlKOH2.GHUOsKCuAUl.ocv7VY40oP5/CNbO2wBmOlC','swoods2@reverbnation.com','358-(160)503-6933','O',0);
INSERT INTO user VALUES (44,'uhs','$2a$10$8bNaS32dp9fPDBiDOe4UvODXakWRr2Kosssg.ib59M9/afoU9z5su','cmatthews3@weebly.com','48-(430)228-8448','O',0);
INSERT INTO user VALUES (45,'uho','$2a$10$1eKX/CclQfnuGO4Ee4LcNuWBgPdnu.qC/PGdSQ8DPAP5DgxYVICMm','rreyes4@ftc.gov','86-(560)849-2974','O',0);
INSERT INTO user VALUES (46,'cdc','$2a$10$dPWwA4DTMPSzRZPrKd0KR.8zKLpvm/DRnu.ncnvxd9/uXbTqqvv2q','tsanders5@de.vu','62-(363)197-8873','O',1);
INSERT INTO user VALUES (47,'cfnr','$2a$10$Cn8.y1QlalR3mKUBoagmW.aULOCQ9898oV8FVVRBHRQuMyAF4V/yy','dmoore6@reddit.com','63-(469)532-8744','O',1);
INSERT INTO user VALUES (48,'cvm','$2a$10$gyFHIQZBPZ/C2Sg5R7J/c.iQi07R6/52Uj4vhDMFwOHFJUzMolCM6','kjones7@sciencedaily.com','52-(366)499-5858','O',1);
INSERT INTO user VALUES (49,'ca','$2a$10$29IdnI9WyfHtrdkGTtvpNuBvwQYQe/Vtx56KJsMWPN/uYE4G/qGGG','tfreeman8@ed.gov','64-(777)683-0986','O',0);
INSERT INTO user VALUES (50,'sesam','$2a$10$q24vwizj2C9RKMA1YubL2ufX3AygEQYWIEKbUkC/Snwn6nSk8efby','jhill9@angelfire.com','504-(801)260-9465','O',0);
INSERT INTO user VALUES (51,'ics','$2a$10$TQM96kOyw2COG1rzj/SxRe0vONeIiBxlCzmar6N0QEx3SdNNiyKRG','rreynoldsa@intel.com','62-(327)123-3269','O',0);
INSERT INTO user VALUES (52,'mainlib','$2a$10$lgEsDVS5j42NjwraMO22qeHVOxc.n4FhD0ypryryVXR1qeYNCLuWO','ljenkinsb@cbslocal.com','63-(469)532-8744','O',0);
INSERT INTO user VALUES (53,'chancy','$2a$10$sA3lCqpyuztBTulSvOif3OEfgGmbPbAMztEvNrL3F9zoRwDyexzk.','mrobinsonc@zdnet.com','52-(366)499-5858','O',0);
INSERT INTO user VALUES (54,'dean','$2a$10$7vXAaE5EtzFFvtCy1FXE1OKACB/GGbhihaMQJENpNN8cmDIZG50j6','bwillisd@marketwatch.com','64-(777)683-0986','O',1);
INSERT INTO user VALUES (55,'sir_jimmy','$2a$10$184HZGZX/z5HDOMdcH5Gxu41AVOfaNNnmJLgrmvH55V.landd7lWu','bharveye@intel.com','504-(801)260-9465','O',0);


insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(11, '1998-12-23', 'Coubeili', 'Cepe', 'Beili', 'F','coubeili cepe competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(12, '1997-03-13', 'Ralph', 'Reyes', 'Ralphy', 'M', 'ralph reyes competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(13, '1996-11-30', 'Adrian', 'Noel', 'Aids', 'M', 'adrian noel competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(14, '1997-12-29', 'Paula', 'Tan', 'Pola', 'F', 'paula tan competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(15, '1998-11-13', 'John Carlo', 'Ricablanca', 'JC', 'M', 'jc ricablanca competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(16, '1999-03-01', 'Emy Jane', 'Cabarles', 'Emy', 'F', 'emy cabarles competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(17, '1996-08-04', 'Clark', 'Almazan', 'Clarkie', 'M', 'clark almazan competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(18, '1995-04-08', 'Melbex', 'De Leon', 'Bex', 'M', 'melbex de leon competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(19, '1998-05-09', 'Brixter', 'Lumabi', 'Brix', 'M', 'brixter lumabi competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(20, '1999-06-10', 'Aleck', 'Menguito', 'Vinock', 'M', 'aleck menguito competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(21, '1996-01-21', 'Yssel', 'Salvania', 'Blessy', 'F', 'yssel salvania competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(22, '1997-10-28', 'Kenichii', 'Ana', 'Ken', 'M', 'kenichii ana competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(23, '1997-09-20', 'Caroline', 'Tolentino', 'Carol', 'F', 'caroline tolentino competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(24, '1998-08-19', 'Jourish', 'Abasolo', 'Jou', 'M', 'jourish abasolo competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(25, '1999-07-17', 'Meika Lei', 'Dane', 'Meika', 'F', 'meika dane competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(26, '1996-05-09', 'Anton', 'Rufino', 'Anton', 'M', 'anton rufino competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(27, '1997-04-07', 'John Louis', 'Gosgolan', 'JLo', 'M', 'john louis gosgolan competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(28, '1997-06-04', 'Miguel', 'Castillo', 'Migui', 'M', 'miguel castillo competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(29, '1999-03-09', 'Patricia', 'Calata', 'Patty', 'F', 'patricia calata competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(30, '1998-02-13', 'Paul', 'Villaro', 'Paul', 'M', 'paul villaro competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(31, '1994-03-19', 'Marie Betel', 'de Robles', 'Betel', 'F', 'betel de robles competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(32, '1995-04-27', 'Manong', 'Guard', 'Manong Guard', 'M', 'manong guard competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(33, '1998-05-30', 'Unicorn', 'Princes', 'Unicorn Princes', 'F', 'unicorn princes competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(34, '1999-10-29', 'Hermione', 'Potter', 'Hermi', 'F', 'hermione competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(35, '1996-11-12', 'Harry', 'Potter', 'Azkaban', 'M', 'harry potter competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(36, '1997-12-13', 'Ron', 'Potter', 'M', 'ron competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(37, '1998-09-14', 'Draco', 'Dracola', 'Cola', 'M', 'draco competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(38, '1999-08-01', 'Snape', 'Snape', 'Snape', 'M', 'snape competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(39, '1996-09-06', 'Dumble', 'Dore', 'Dumbledore', 'M', 'dumbledore competitor');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(40, '1995-07-14', 'Hedwig', 'Hedwig', 'Hedwig', 'M', 'hedwig competitor');

insert into organizer (name,description,id) VALUES('College of Arts and Sciences','To serve as a center of excellence in the basic sciences, as a cradle of humanities .',41);
insert into organizer (name,description,id) VALUES('College of Human Ecology','The College of Human Ecology advocates and uses interdisciplinary, holistic, and integrative.',42);
insert into organizer (name,description,id) VALUES('College of Engineering and Agro-Industrial Technology','Excellence in engineering education, research and extension.', 43);
insert into organizer (name,description,id) VALUES('University Health Services','As a model of quality service management and a leader in sustainable natural resource.', 44);
insert into organizer (name,description,id) VALUES('University Housing Office','Shall manage the University’s housing facilities and residence halls with efficiency.', 45);
insert into organizer (name,description,id) VALUES('College of Development Communication','UPLB CDC envisions a stable, progressive, committed and responsive cooperative.',46);
insert into organizer (name,description,id) VALUES('College of Forestry and Natural Resources','Developing globally competitive and locally-adaptive human resources imbued.',47);
insert into organizer (name,description,id) VALUES('College of Veterinary Medicine', 'The premier veterinary institution in Asia Pacific recognized for producing world-class.',48);
insert into organizer (name,description,id) VALUES('College of Agriculture','A premier institution of higher learning in agriculture and food sciences promoting the development.',49);
insert into organizer (name,description,id) VALUES('School of Environmental Science and Management', 'A center of excellence in the fields of environmental science and management.',50);
insert into organizer (name,description,id) VALUES('Institute of Computer Science','The ICS aims to produce the needed quality manpower for the software industry of the Philippines.',51);
insert into organizer (name,description,id) VALUES('UP Los Baños Main Library','Composed of the Main Library, 8 College and 2 Special libraries, and a High School Library.',52);
insert into organizer (name,description,id) VALUES('Chancellor Fernando C. Sanchez, Jr','Current University of the Philippines Los Baños Chancellor',53);
insert into organizer (name,description,id) VALUES('Dr. Felino P. Lansigan','Current University of the Philippines Los Baños CAS Dean',54);
insert into organizer (name,description,id) VALUES('Jaime M. Samaniego','Senior ICS Faculty Member',55);

insert into game (game_id, organizer_id, name, start_date, end_date, location) values (1, 53, 'Palarong UPLB 2015', '2015-03-16', '2015-03-27', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (2, 51, 'PalICSihan 2015', '2015-03-29', '2015-03-29', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (3, 51, 'PalICSihan 2016', '2016-02-22', '2016-02-22', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (4, 43, 'Engineering Meet 2016', '2016-03-26', '2016-05-29', 'Freedom Park Lower Ground');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (5, 53, 'Palarong UPLB 2016', '2016-03-28', '2016-04-08', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (6, 41, 'PalaCASan 2016', '2016-10-01', '2016-10-15', 'Freedom Park Upper Ground');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (7, 43, 'Engineering Meet 2017', '2017-02-15', '2017-04-20', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (8, 53, 'Palarong UPLB 2017', '2017-03-27', '2017-04-07', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (9, 51, 'PalICSihan 2017', '2017-03-13', '2017-08-13', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (10, 45, 'PasADAhan 2017', '2017-06-15', '2017-06-18', 'To Be Announced');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (11, 41, 'PalaCASan 2017', '2017-10-03', '2017-10-17', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (12, 43, 'Engineering Meet 2018', '2018-03-01', '2018-05-06', 'Copeland Gymnasium');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (13, 45, 'PasADAhan 2018', '2018-06-27', '2018-07-01', ' Freedom Park Lower Ground');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (14, 41, 'PalaCASan 2018', '2018-10-01', '2018-10-15', 'Baker Hall');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (15, 43, 'Engineering Meet 2019', '2019-02-22', '2019-04-27', 'Freedom Park Lower Ground');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (16, 51, 'PalICSihan 2019', '2019-03-18', '2019-03-18', 'To Be Announced');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (17, 45, 'PasADAhan 2019', '2019-06-23', '2019-06-25', 'To Be Announced');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (18, 41, 'PalaCASan 2019', '2019-06-24', '2019-07-08', 'To Be Announced');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (19, 41, 'PalaCASan 2020', '2020-06-04', '2020-06-18', 'To Be Announced');
insert into game (game_id, organizer_id, name, start_date, end_date, location) values (20, 43, 'Engineering Meet 2020', '2020-02-30', '2021-04-03', 'To Be Announced');

insert into sponsor_institution(sponsor_id, name, description) values(1, 'Angels Burger', 'Dito sa Angels Burger.. Ang unang kagat, tinapay lahat');
insert into sponsor_institution(sponsor_id, name, description) values(2, 'High Ground Gourmet Comfort Food', 'A casual neighborhood restaurant that specializes in international and local comfort food');
insert into sponsor_institution(sponsor_id, name, description) values(3, 'Big Ds', 'Ramenan of UPLB');
insert into sponsor_institution(sponsor_id, name, description) values(4, 'Chooks to Go', 'Masarap Kahit Walang Sauce');
insert into sponsor_institution(sponsor_id, name, description) values(5, 'Reyal Litson Manok', 'Mas masarap pag may sauce');
insert into sponsor_institution(sponsor_id, name, description) values(6, 'Andoks Litson', 'Pambansang Litsong Manok');
insert into sponsor_institution(sponsor_id, name, description) values(7, 'Bank of the Philippine Islangs(BPI)', 'We ll take you farther');
insert into sponsor_institution(sponsor_id, name, description) values(8, 'Boysen', 'The Quality You can Trust');
insert into sponsor_institution(sponsor_id, name, description) values(9, 'Chowking', 'Tikman and tagumpay');
insert into sponsor_institution(sponsor_id, name, description) values(10, 'Fita Biscuits', 'Parang Life');
insert into sponsor_institution(sponsor_id, name, description) values(11, 'Goldilocks', 'How thoughtful, How Goldilocks');
insert into sponsor_institution(sponsor_id, name, description) values(12, 'Jollibee', 'Bida ang saya!');
insert into sponsor_institution(sponsor_id, name, description) values(13, 'Mercury Drug Store', 'Nakasisigurong gamot ay laging bago');
insert into sponsor_institution(sponsor_id, name, description) values(14, 'Philippine Long Distance Company', 'Were changing lives');
insert into sponsor_institution(sponsor_id, name, description) values(15, 'Pop Cola', 'Always tama ang timpla');
insert into sponsor_institution(sponsor_id, name, description) values(16, 'Mikasa Sports', 'Produces best athletics balls money can buy');
insert into sponsor_institution(sponsor_id, name, description) values(17, 'Smart Telecommunications', 'Connecting people');
insert into sponsor_institution(sponsor_id, name, description) values(18, 'Gatorade', 'Fueling the future');
insert into sponsor_institution(sponsor_id, name, description) values(19, 'Nike', 'Just Do It');
insert into sponsor_institution(sponsor_id, name, description) values(20, 'Spalding', 'True to the Game');

insert into sponsor_games(sponsor_id, game_id) values (1, 1);
insert into sponsor_games(sponsor_id, game_id) values (1, 2);
insert into sponsor_games(sponsor_id, game_id) values (2, 1);
insert into sponsor_games(sponsor_id, game_id) values (2, 5);
insert into sponsor_games(sponsor_id, game_id) values (2, 7);
insert into sponsor_games(sponsor_id, game_id) values (2, 15);
insert into sponsor_games(sponsor_id, game_id) values (3, 1);
insert into sponsor_games(sponsor_id, game_id) values (3, 20);
insert into sponsor_games(sponsor_id, game_id) values (5, 8);
insert into sponsor_games(sponsor_id, game_id) values (6, 1);
insert into sponsor_games(sponsor_id, game_id) values (6, 8);
insert into sponsor_games(sponsor_id, game_id) values (8, 1);
insert into sponsor_games(sponsor_id, game_id) values (10, 7);
insert into sponsor_games(sponsor_id, game_id) values (10, 8);
insert into sponsor_games(sponsor_id, game_id) values (10, 15);
insert into sponsor_games(sponsor_id, game_id) values (11, 1);
insert into sponsor_games(sponsor_id, game_id) values (12, 1);
insert into sponsor_games(sponsor_id, game_id) values (14, 8);
insert into sponsor_games(sponsor_id, game_id) values (15, 8);
insert into sponsor_games(sponsor_id, game_id) values (17, 8);

INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(1, 'Basketball', 'kill all you want','09:00','11:00','2015-03-16', '2015-03-27', 8, 'Round Robin', 1);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(2, 'VolleyBall', 'kill all you want','12:00','14:00','2015-03-29', '2015-03-29', 16, 'Single Elimination', 2);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(3, 'Baseball', 'kill all you want','08:00','11:00','2016-02-22', '2016-02-22', 4, 'Single Elimination', 3);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(4, '100 meter dash', 'kill all you want','10:00','10:30','2016-03-26', '2016-05-29', 10, 'Single Elimination', 4);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(5, 'Tug of war', 'kill all you want','07:00','10:00','2016-03-28', '2016-04-08', 8, 'Round Robin', 5);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(6, 'Chess', 'kill all you want','08:00','19:00','2016-10-01', '2016-10-15', 8, 'Round Robin', 6);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(7, 'Basketball', 'kill all you want','09:00','11:00','2017-02-15', '2017-04-20', 8, 'Round Robin', 7);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(8, 'Chess', 'kill all you want','10:00','22:00','2017-03-27', '2017-04-07', 30, 'Swedish', 8);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(9, 'Javelin throw', 'kill all you want','08:00','11:00','2017-03-13', '2017-08-13', 8, 'Single Elimination', 9);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(10, '3km Run', 'run all you can','09:00','11:00','2017-06-15', '2017-06-18', 40, 'Single Elimination', 10);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(11, 'Taekwondo', 'kick all you can','09:00','11:00','2017-10-03', '2017-10-17', 8, 'Single Elimination', 11);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(12, 'Volleyball', 'Spike all you want','11:00','15:00','2018-03-01', '2018-05-06', 8, 'Single Elimination', 12);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(13, '100 meter dash', 'run all you want','09:00','11:00','2018-06-27', '2018-07-01', 8, 'Single Elimination', 13);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(14, 'Basketball', 'kill all you want','09:00','11:00','2018-10-01', '2018-10-15', 8, 'Round Robin', 14);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(15, 'Tennis', 'kill all you want','08:00','12:00','2019-02-22', '2019-04-27', 8, 'Single Elimination', 15);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(16, 'Basketball', 'kill all you want','09:00','11:00','2019-03-18', '2019-03-18', 8, 'Round Robin', 16);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(17, 'Chess', 'kill all you want','08:00','20:00','2019-06-23', '2019-06-25', 8, 'Round Robin', 17);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(18, 'Basketball', 'kill all you want','09:00','11:00','2019-06-24', '2019-07-08', 8, 'Round Robin', 18);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(19, 'Dance sport', 'kill all you want','08:00','12:00','2020-06-04', '2020-06-18', 8, 'Single Elimination', 19);
INSERT INTO sport(sport_id, sport_name, mechanics, time_start, time_end, start_date, end_date, max_teams, scoring_system, game_id) values(20, 'Basketball', 'kill all you want','09:00','11:00','2020-02-30', '2021-04-03', 8, 'Round Robin', 20);


insert into sport_match(time_start, time_end, sport_id, match_date) values ("10:00", "12:00", 1, "2015-3-17");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("12:00", "14:00", 2, "2015-3-29");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("08:00", "11:00", 3, "2016-2-22");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("10:00", "10:30", 4, "2016-3-30");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("07:00", "10:00", 5, "2016-4-05");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("08:00", "19:00", 6, "2016-10-14");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 7, "2017-2-16");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("10:00", "12:00", 8, "2017-3-27");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("08:00", "11:00", 9, "2017-3-13");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 10, "2017-6-15");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 11, "2017-10-13");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("11:00", "15:00", 12, "2018-3-01");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 13, "2018-6-27");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 14, "2018-10-01");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("10:00", "12:00", 15, "2019-2-22");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 16, "2019-3-18");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("08:00", "20:00", 17, "2019-6-23");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 18, "2019-6-24");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("08:00", "12:00", 19, "2019-6-04");
insert into sport_match(time_start, time_end, sport_id, match_date) values ("09:00", "11:00", 20, "2020-2-30");