Mock Data

import.sql

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

INSERT INTO user VALUES (11,'beili','$2a$10$hv9kLyC28lE27H7llCL0L.LZczdXcEGQskmqzttCcMGwTX6RzgBn2','cccepe@up.edu.ph','(577)399-7885','C',1);
INSERT INTO user VALUES (12,'ralph','$2a$10$BiEvhLgGfAm9fPVtUYaX8OTJfZs7vQGj4Q8forLRROo1vbWrUqQ72','rareyes@up.edu.ph','(160)503-6933','C',1);
INSERT INTO user VALUES (13,'adrian','$2a$10$b0MJcS4SZFY3pSOX7CbAR.WGGtaK4SSqxqsp7o3ttPakEO2hY0SOq','amnoel1@up.edu.ph','(430)228-8448','C',0);
INSERT INTO user VALUES (14,'paula','$2a$10$fB00WaILw7CpGnUjRPQzYejd9xir5IkLPLu7O4htvCBvj9SX1c5p6','pvtan@up.edu.ph','(560)849-2974','C',0);
INSERT INTO user VALUES (15,'jc','$2a$10$XJHfgc7D0Qj0L0iYq1rA5OioPOBn0wwJXwXjsw9yiAU6FzYU79XJ2','jgricablanca@up.edu.ph','(363)197-8873','C',1);
INSERT INTO user VALUES (16,'emy','$2a$10$wVCpssLiDmR6O9NYK9mCUeBVjIsuDlOppUUkoGJos1caIWbeBlDoW','ejcabalares@up.edu.ph','(469)532-8744','C',0);
INSERT INTO user VALUES (17,'clark','$2a$10$tqzSnPlNRoyo/05qU.K5KuFHEb7BRrCb8jr7jWtjpiTcW0cQqVysy','cpalmazan@up.edu.ph','(366)499-5858','C',1);
INSERT INTO user VALUES (18,'melbex','$2a$10$fkJBUl5KKN0QU4CdnxcnRuORraC.hVaoRq17fS2qS2mtOi84ZiUKu','adean7@tumblr.com','(777)683-0986','C',0);
INSERT INTO user VALUES (19,'brixter','$2a$10$rccqtU9TZmRmzFPQfzdMb.glQlHXupXg9KYJCHFVl1cyzJY5jNKM6','brlumabi@up.edu.ph','(801)260-9465','C',1);
INSERT INTO user VALUES (20,'aleck','$2a$10$Zfvuu3QHRvD9cRChxQ0AQePDXG28DxdIRAy0Wsk3kCKYXZr6FZUBq','aimenguito1@up.edu.ph','(327)123-3269','C',0);
INSERT INTO user VALUES (21,'yssel','$2a$10$4oIlIUm7CH/sDwXQFdXsYe0QrfG4SCqTepPzi9zCRYA5mHJHkBo1y','bpsalvania@up.edu.ph','(577)399-7885','C',0);
INSERT INTO user VALUES (22,'kenichii','$2a$10$Q/WWdOaQ0HKmfm7KUNtTOuLE5iKM.c6nEz.egL3jHtsq/imc/NwN6','kaana@up.edu.ph','(160)503-6933','C',0);
INSERT INTO user VALUES (23,'caroline','$2a$10$YhoftMCct7I55twvrWfbm.bUdRbFDleirKkGDom.xWTT2YP8nu3Xi','cbtolentino1 @up.edu.ph','(430)228-8448','C',0);
INSERT INTO user VALUES (24,'jourish','$2a$10$QI0ydEGLZE8010qH7R1tF.frQetiyA8cT.CXmzFhwkBoPS..Vqjeu','jdabasolo2@up.edu.ph','(560)849-2974','C',0);
INSERT INTO user VALUES (25,'meika','$2a$10$OS11GlbHMVfYzpn4vlF5y.9umtXKHUD03/.JSfJ2a87bNdNJZZKvG','mddane@up.edu.ph','(363)197-8873','C',1);
INSERT INTO user VALUES (26,'anton','$2a$10$LsUi2fe9DCv5V//ZpRsmaepeUtq9eMNRN9BYv5UkH9fYIZBlVDYUK','mprufino@up.edu.ph','(469)532-8744','C',0);
INSERT INTO user VALUES (27,'jlo','$2a$10$0rm1t3D5sD1fXM11V/Fv2.yDpmzSSIKgfIv0Hock2OcUq1oAB8IvG','jlgosgolan@up.edu.ph','(366)499-5858','C',0);
INSERT INTO user VALUES (28,'migui','$2a$10$3KLRuhNERTaq4u6RSzHFs.0z9oMDsRiCvyXbuDZIVwggx9KhvFq8O','jfcastillo@up.edu.ph','(777)683-0986','C',0);
INSERT INTO user VALUES (29,'patty','$2a$10$Nf2dWkodBLooVNsXxV/BS.oYd2/zHfhj2lK5xeMw.MPO6nzFQl2Ci','pmcalata@up.edu.ph','(801)260-9465','C',1);
INSERT INTO user VALUES (30,'paul','$2a$10$2h1ML/H3DfphvciX4vgI5e/noKdHrrtGRgO07nqRm.dHTOXNQeot.','pgvillaro@up.edu.ph','(327)123-3269','C',0);
INSERT INTO user VALUES (31,'betel','$2a$10$RduwtrBYi.8LOwX83TA/O.1lNWarT5DV0E3pft3Z2SZhaOmOtneMS','mabderobles@up.edu.ph','(577)399-7885','C',1);
INSERT INTO user VALUES (32,'manong_guard','$2a$10$JGesVPYS3imyB.YPnsSuAuPAFVBzMV.e2bvgwmm4lcmEDuRSBqiom','manguard@gmail.com','(160)503-6933','C',0);
INSERT INTO user VALUES (33,'unicorn_princess','$2a$10$PVlexQOcGEedjiLmB1ku4uvGdfOJcXoibYxSBzrr3kLvHNFrD1JPW','unicornprin@gmail.com','(430)228-8448','C',0);
INSERT INTO user VALUES (34,'hermione','$2a$10$U2yNbDrKLEjDRghPyyMGgOW07rVu34XaFJpD/w/MkJQlgK1yDjMSq','hjgranger@hsww.edu.uk','(560)849-2974','C',1);
INSERT INTO user VALUES (35,'harry','$2a$10$uO42EnoO3WVvmBGfGUpCdOB3x8rNoiYsVLOnVrnxTfSPx73atewlK','hjpotter@hsww.edu.uk','(363)197-8873','C',1);
INSERT INTO user VALUES (36,'ron','$2a$10$ATh0biJthPFPt7M2aPamQOes9oQAiGO/Ue81GnolOKM6k0pww8DZm','rbweasley@hsww.edu.uk','(469)532-8744','C',0);
INSERT INTO user VALUES (37,'draco','$2a$10$VaJjwCiSS/xvx0vfelNj0OODR2z.PPRhGz2Spxsgq6abbK502k0iW','dlmalfoy@hsww.edu.uk','(366)499-5858','C',1);
INSERT INTO user VALUES (38,'snape','$2a$10$aTG1qbUMqvVwii9uOvlKNOEz7C2MAc0fKER3NrUKnZN3z2VCy9ZIO','ssnape@hsww.edu.uk','(777)683-0986','C',0);
INSERT INTO user VALUES (39,'dumbledore','$2a$10$VPWpCmeyQ8jdM.0uA82XJOFSebRszM9664OQ6wkGNCFaYzEPj177W','adumbledore@hsww.edu.uk','(801)260-9465','C',0);
INSERT INTO user VALUES (40,'hedwig','$2a$10$5OgzvnO/kcrVH69ZQOi.dOEeugtmfd33BwbsQwy4AcyvbU.uck2Be','hedwig@hsww.edu.uk','(327)123-3269','C',0);

INSERT INTO user VALUES (41,'cas','$2a$10$mQYsU8J.eGmu5YeHMXbqHOPoi0g5ytid/qI1C85SOgE5HHOKHzYyy','colartssci@up.edu.ph','(327)123-3269','O',1);
INSERT INTO user VALUES (42,'che','$2a$10$rCBgovpUKXu/gBc.JDgJB.U3N9btXkwBaFYQxYkfGbvt5H.QPObFy','colhumeco@up.edu.ph','(577)399-7885','O',1);
INSERT INTO user VALUES (43,'ceat','$2a$10$m13mAstG.h2zlKOH2.GHUOsKCuAUl.ocv7VY40oP5/CNbO2wBmOlC','colengargtech@up.edu.ph','(160)503-6933','O',0);
INSERT INTO user VALUES (44,'uhs','$2a$10$8bNaS32dp9fPDBiDOe4UvODXakWRr2Kosssg.ib59M9/afoU9z5su','unihealthserv@up.edu.ph','(430)228-8448','O',0);
INSERT INTO user VALUES (45,'uho','$2a$10$1eKX/CclQfnuGO4Ee4LcNuWBgPdnu.qC/PGdSQ8DPAP5DgxYVICMm','unihousing@up.edu.ph','(560)849-2974','O',0);
INSERT INTO user VALUES (46,'cdc','$2a$10$dPWwA4DTMPSzRZPrKd0KR.8zKLpvm/DRnu.ncnvxd9/uXbTqqvv2q','coldevcom@up.edu.ph','(363)197-8873','O',1);
INSERT INTO user VALUES (47,'cfnr','$2a$10$Cn8.y1QlalR3mKUBoagmW.aULOCQ9898oV8FVVRBHRQuMyAF4V/yy','colfornatres@up.edu.ph','(469)532-8744','O',1);
INSERT INTO user VALUES (48,'cvm','$2a$10$gyFHIQZBPZ/C2Sg5R7J/c.iQi07R6/52Uj4vhDMFwOHFJUzMolCM6','colvetmed@up.edu.ph','(366)499-5858','O',1);
INSERT INTO user VALUES (49,'ca','$2a$10$29IdnI9WyfHtrdkGTtvpNuBvwQYQe/Vtx56KJsMWPN/uYE4G/qGGG','colagr@up.edu.ph','(777)683-0986','O',0);
INSERT INTO user VALUES (50,'sesam','$2a$10$q24vwizj2C9RKMA1YubL2ufX3AygEQYWIEKbUkC/Snwn6nSk8efby','schenvscimgt@up.edu.ph','(801)260-9465','O',0);
INSERT INTO user VALUES (51,'ics','$2a$10$TQM96kOyw2COG1rzj/SxRe0vONeIiBxlCzmar6N0QEx3SdNNiyKRG','instcomsci@up.edu.ph','(327)123-3269','O',0);
INSERT INTO user VALUES (52,'mainlib','$2a$10$lgEsDVS5j42NjwraMO22qeHVOxc.n4FhD0ypryryVXR1qeYNCLuWO','elib@up.edu.ph','(469)532-8744','O',0);
INSERT INTO user VALUES (53,'chancy','$2a$10$sA3lCqpyuztBTulSvOif3OEfgGmbPbAMztEvNrL3F9zoRwDyexzk.','fcsanchez@up.edu.ph','(366)499-5858','O',0);
INSERT INTO user VALUES (54,'dean','$2a$10$7vXAaE5EtzFFvtCy1FXE1OKACB/GGbhihaMQJENpNN8cmDIZG50j6','fplansigan@up.edu.ph','(777)683-0986','O',1);
INSERT INTO user VALUES (55,'sir_jimmy','$2a$10$184HZGZX/z5HDOMdcH5Gxu41AVOfaNNnmJLgrmvH55V.landd7lWu','jmsamaniego@up.edu.ph','(801)260-9465','O',0);


insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(11, '1997-02-22', 'Coubeili', 'Cepe', 'Beili', 'F','coubeili cepe competitor | free spirit');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(12, '1997-08-22', 'Ralph', 'Reyes', 'Ralphy', 'M', 'ralph reyes competitor | Penguin | BSCS | BattleCity');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(13, '1997-09-30', 'Adrian', 'Noel', 'Adre', 'M', 'adrian noel competitor | Do I look like I know what Im doing? BSCS | WX1');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(14, '1998-04-28', 'Paula', 'Tan', 'Pola', 'F', 'paula tan competitor | BSCS | Batch "14 ');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(15, '1996-02-28', 'John Carlo', 'Ricablanca', 'JC', 'M', 'jc ricablanca competitor | whatever, I dont give a damn');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(16, '1997-10-24', 'Emy Jane', 'Cabarles', 'Emy', 'F', 'emy cabarles competitor | not an important person');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(17, '1997-11-24', 'Clark', 'Almazan', 'Clarkie', 'M', 'clark almazan competitor | circle clicker. well not now lol. pretty much some ordinary guy');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(18, '1997-04-11', 'Melbex', 'De Leon', 'Bex', 'M', 'melbex de leon competitor | Take this sinking boat and point it home');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(19, '1998-05-09', 'Brixter', 'Lumabi', 'Brix', 'M', 'brixter lumabi competitor | A tech enthusiast | Connected to the latest happenings in Computer and Mobile Technology!');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(20, '1998-09-13', 'Aleck', 'Menguito', 'Vinock', 'M', 'aleck menguito competitor | Just your average socially akward weeaboo | Im very fond of dogs and dreams');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(21, '1997-08-20', 'Yssel', 'Salvania', 'Blessy', 'F', 'yssel salvania competitor | Im very fond of dogs and dreams');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(22, '1997-04-11', 'Kenichii', 'Ana', 'Ken', 'M', 'kenichii ana competitor | **');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(23, '1998-05-12', 'Caroline', 'Tolentino', 'Carol', 'F', 'caroline tolentino competitor | BSCS | Batch "14');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(24, '1998-08-19', 'Jourish', 'Abasolo', 'Jou', 'M', 'jourish abasolo competitor | Ang gwapo ko nakakainis');
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 | * Official A.R.M.Y 3 * Tinkerbell * Aroha * Carat');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(26, '1997-11-25', 'Anton', 'Rufino', 'Anton', 'M', 'anton rufino competitor | // TODO: Insert self-flattery here');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(27, '1997-11-21', 'John Louis', 'Gosgolan', 'JLo', 'M', 'john louis gosgolan competitor | Lost, finding self.');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(28, '1997-12-31', 'Miguel', 'Castillo', 'Migui', 'M', 'miguel castillo competitor | Forever curious');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(29, '1997-10-31', 'Patricia', 'Calata', 'Patty', 'F', 'patricia calata competitor | 2015. tidsoptimist. space cadet. tunay, palaban, makabayan.');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(30, '1998-02-13', 'Paul', 'Villaro', 'Paul', 'M', 'paul villaro competitor | Isko. 19. Kusgan na programmer. Dara-sexual.');
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 | "Never be discouraged. Never hold back. Give everything you got. And when you fall throughout life, remember this: FALL FORWARD."');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(32, '1995-04-27', 'Manong', 'Guard', 'M.Guard', 'M', 'manong guard competitor | Here to "guard" your hearts');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(33, '1998-05-30', 'Unicorn', 'Princess', 'Unicorn', 'F', 'unicorn princess competitor | Im just a thin rhino');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(34, '1999-10-29', 'Hermione', 'Granger', 'Hermi', 'F', 'hermione competitor | Its Le-VIYO-sah ');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(35, '1996-11-12', 'Harry', 'Potter', 'Azkaban', 'M', 'harry potter competitor | Im the chosen one');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(36, '1997-12-13', 'Ron', 'Weasley','Ronner', 'M', 'ron competitor | Im not Ed Sheeran');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(37, '1998-09-14', 'Draco', 'Malfoy', 'Cola', 'M', 'draco competitor | My father will hear about that');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(38, '1999-08-01', 'Severus', 'Snape', 'Snape', 'M', 'snape competitor | "Its not a phase"');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(39, '1996-09-06', 'Albus', 'Dumbledore', 'Dumbledore', 'M', 'dumbledore competitor | Ten points to dumbledore');
insert into competitor(id, birthday, first_name, last_name, nickname, sex, bio) values(40, '1995-07-14', 'Hedwig', 'The Owl', 'Hedwig', 'M', 'hedwig competitor | Soaring in the Heavens');

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 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-21', '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 ang 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-21', '2021-04-03', 8, 'Round Robin', 20);


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


INSERT INTO organization VALUES(1, "College of Sciences"); 
INSERT INTO organization VALUES(2, "College of Arts"); 
INSERT INTO organization VALUES(3, "College of Music"); 
INSERT INTO organization VALUES(4, "Young Software Scientists");
INSERT INTO organization VALUES(5, "Angulords");
INSERT INTO organization VALUES(6, "Some Scientists");
INSERT INTO organization VALUES(7, "Young Geeks");
INSERT INTO organization VALUES(8, "College of Biology");

INSERT INTO organization_in_game VALUES(1,1);
INSERT INTO organization_in_game VALUES(2,1);
INSERT INTO organization_in_game VALUES(3,1);
INSERT INTO organization_in_game VALUES(4,1);
INSERT INTO organization_in_game VALUES(5,1);
INSERT INTO organization_in_game VALUES(1,2);
INSERT INTO organization_in_game VALUES(2,2);
INSERT INTO organization_in_game VALUES(3,2);
INSERT INTO organization_in_game VALUES(1,3);
INSERT INTO organization_in_game VALUES(2,4);
INSERT INTO organization_in_game VALUES(3,4);
INSERT INTO organization_in_game VALUES(2,5);
INSERT INTO organization_in_game VALUES(3,5);
INSERT INTO organization_in_game VALUES(1,6);
INSERT INTO organization_in_game VALUES(2,7);
INSERT INTO organization_in_game VALUES(3,7);
INSERT INTO organization_in_game VALUES(4,7);
INSERT INTO organization_in_game VALUES(2,8);
INSERT INTO organization_in_game VALUES(3,8);
INSERT INTO organization_in_game VALUES(4,8);

INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 1 ,'Team Avengers', 11, 1, 1, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 2 ,'Team Avengers', 11, 2, 1, 0, 3);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 3 ,'Team Avengers', 11, 3, 1, 0, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 4 ,'Team Avengers', 11, 4, 1, 1, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 5 ,'Team Avengers', 11, 5, 1, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 6 ,'Team Justice League', 32, 1, 2, 0, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 7 ,'Team Justice League', 32, 2, 2, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 8 ,'Team Justice League', 32, 3, 2, 0, 5);	
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 9 ,'Team KrustyKrew', 23, 1, 3, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 10 ,'Team Bang', 24, 2, 4, 0, 3);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 11 ,'Team Bang', 24, 3, 4, 0, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 12 ,'Team Bog', 24, 2, 5, 1, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 13 ,'Team Bog', 15, 3, 5, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 14 ,'Team Bangan', 21, 1, 6, 0, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 15 ,'Team Secret', 16, 2, 7, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 16 ,'Team Secret', 20, 3, 7, 0, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 17 ,'Team Secret', 15, 4, 7, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 18 ,'Team Phoenix', 21, 2, 8, 0, 5);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 19 ,'Team Phoenix', 16, 3, 8, 1, 15);
INSERT INTO team(team_id, team_name, id, sport_id, team_organization, pending_participation, max_members) values( 20 ,'Team Phoenix', 20, 4, 8, 0, 5);


INSERT INTO competitor_joins_team(id, team_id, is_member) values(22, 1, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(12, 1, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(13, 1, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(14, 1, 0);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(25, 1, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(26, 2, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(17, 2, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(18, 4, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(19, 4, 0);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(12, 5, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(13, 5, 0);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(12, 6, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(13, 7, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(14, 7, 0);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(13, 8, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(14, 8, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(17, 9, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(18, 9, 1);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(19, 10, 0);
INSERT INTO competitor_joins_team(id, team_id, is_member) values(19, 15, 1);	

insert into team_in_match (match_id, team_id) values (1, 1);
insert into team_in_match (match_id, team_id) values (1, 6);
insert into team_in_match (match_id, team_id) values (2, 2);
insert into team_in_match (match_id, team_id) values (2, 7);
insert into team_in_match (match_id, team_id) values (3, 3);
insert into team_in_match (match_id, team_id) values (3, 8);
insert into team_in_match (match_id, team_id) values (4, 4);
insert into team_in_match (match_id, team_id) values (4, 17);
insert into team_in_match (match_id, team_id) values (5, 5);
insert into team_in_match (match_id, team_id) values (5, 12);
insert into team_in_match (match_id, team_id) values (6, 9);
insert into team_in_match (match_id, team_id) values (6, 14);
insert into team_in_match (match_id, team_id) values (7, 10);
insert into team_in_match (match_id, team_id) values (7, 15);
insert into team_in_match (match_id, team_id) values (8, 11);
insert into team_in_match (match_id, team_id) values (8, 13);
insert into team_in_match (match_id, team_id) values (11, 16);
insert into team_in_match (match_id, team_id) values (11, 19);