-
-
Save ClarkAlmazan/4c1848ada7fb581e9dadf95150aee75c to your computer and use it in GitHub Desktop.
Mock data for us
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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"); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment