Skip to content

Instantly share code, notes, and snippets.

@raareyes
Forked from claizelcoubeili/import.sql
Last active April 14, 2017 23:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save raareyes/dbc134ad85ce9d466e89b7cca6ee681c to your computer and use it in GitHub Desktop.
Save raareyes/dbc134ad85ce9d466e89b7cca6ee681c to your computer and use it in GitHub Desktop.
Mock data for us
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment