forked from dia42r/BlueSheepProject
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfixture_data_activity.sql
More file actions
10 lines (10 loc) · 16.1 KB
/
fixture_data_activity.sql
File metadata and controls
10 lines (10 loc) · 16.1 KB
1
2
3
4
5
6
7
8
9
10
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (1,7,1,1,0,1,0,"vitae, erat. Vivamus","9573 Sed St.","1816CN","Sunshine Coast Regional District","Lorem ipsum dolor sit","2017-04-20"),(2,2,9,1,1,1,0,"aliquet. Phasellus fermentum","P.O. Box 481, 5125 A Road","K9S 4Y1","Lens","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-05-06"),(3,9,5,1,0,1,0,"a, arcu. Sed","349-2369 Id, Street","606195","Sasaram","Lorem ipsum dolor sit amet,","2016-06-04"),(4,1,10,1,0,0,0,"enim commodo hendrerit.","730-8615 Nec Rd.","7689LN","Suxy","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-05-16"),(5,3,8,1,0,0,0,"vehicula et, rutrum","P.O. Box 128, 4124 Quis Avenue","28934","Hannche","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-03-24"),(6,5,5,1,0,1,0,"tellus. Phasellus elit","2087 Mi Rd.","00-506","Itter","Lorem ipsum dolor","2016-03-15"),(7,1,9,0,0,1,1,"tristique ac, eleifend","Ap #804-8917 Sapien. Rd.","1911","Coaldale","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2017-12-29"),(8,8,7,0,0,0,1,"eu, eleifend nec,","2008 Semper Av.","58376","Crewe","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2017-08-31"),(9,5,5,1,1,1,0,"orci, adipiscing non,","P.O. Box 526, 467 Eget St.","V7A 1Y4","Lidingo","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2017-07-13"),(10,6,4,1,0,1,0,"mi lorem, vehicula","7933 Erat St.","48439","Gaggio Montano","Lorem ipsum dolor sit amet, consectetuer","2017-03-23");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (11,2,6,0,1,0,1,"eros. Nam consequat","9587 Libero. Avenue","78-169","Leonding","Lorem","2017-10-22"),(12,2,3,0,0,1,0,"neque vitae semper","243-2355 Dictum Avenue","74-603","Emblem","Lorem ipsum dolor sit amet, consectetuer","2017-07-29"),(13,8,5,1,0,0,1,"Duis risus odio,","P.O. Box 934, 4110 Cursus St.","92-788","Ambleside","Lorem ipsum dolor sit","2016-03-20"),(14,10,9,1,1,0,0,"dapibus id, blandit","Ap #745-4328 Dignissim Rd.","71153","Tiruvottiyur","Lorem ipsum dolor","2016-03-22"),(15,2,10,0,0,1,0,"ornare, lectus ante","P.O. Box 712, 1443 Gravida. Av.","35064","Amberloup","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-06-25"),(16,1,9,1,1,0,0,"metus urna convallis","384-7592 Dignissim Rd.","62010","Muridke","Lorem ipsum dolor sit amet, consectetuer adipiscing","2016-06-27"),(17,5,7,1,1,1,0,"Nulla tempor augue","Ap #615-4712 Lectus Rd.","QB4 5BA","Melton","Lorem ipsum dolor sit amet,","2017-01-13"),(18,1,8,0,0,0,1,"sem ut cursus","P.O. Box 476, 8622 Per Av.","1202","Pathankot","Lorem ipsum dolor sit amet, consectetuer","2017-09-26"),(19,5,1,0,0,1,0,"Etiam gravida molestie","Ap #430-4844 Tempus Av.","62750","Drancy","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-09-28"),(20,9,2,1,0,1,1,"consectetuer adipiscing elit.","P.O. Box 271, 962 Tortor Rd.","75465","San Pedro de Atacama","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-01-28");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (21,1,1,0,1,1,1,"pellentesque eget, dictum","688-2410 Donec Avenue","87495-501","Rishra","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-08-09"),(22,8,1,0,1,0,1,"elit erat vitae","1878 Augue Road","50711","Candidoni","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-02-07"),(23,2,10,0,1,0,1,"lobortis mauris. Suspendisse","Ap #983-7107 Sed St.","107870","Timaru","Lorem ipsum dolor sit amet, consectetuer adipiscing","2016-12-21"),(24,9,8,0,0,0,0,"arcu vel quam","493-1726 Lectus. Street","4190","Boneffe","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2017-08-18"),(25,10,2,0,1,0,1,"Quisque varius. Nam","Ap #800-1923 Integer St.","7197","Ways","Lorem ipsum dolor sit","2017-07-26"),(26,2,10,1,1,1,0,"dui. Suspendisse ac","P.O. Box 449, 9957 Suspendisse Rd.","209716","Forge-Philippe","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-01-27"),(27,5,9,0,0,0,0,"nunc sed pede.","2362 Porttitor Ave","30412","Palayankottai","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2017-12-07"),(28,7,10,1,1,0,0,"magna. Suspendisse tristique","3981 Phasellus Ave","68032","San Isidro","Lorem ipsum dolor sit","2016-04-13"),(29,6,7,1,1,1,1,"accumsan interdum libero","P.O. Box 866, 3786 At Avenue","402802","Wrigley","Lorem ipsum dolor sit amet, consectetuer","2017-05-24"),(30,9,3,0,0,1,1,"Nunc mauris sapien,","Ap #814-6951 Molestie St.","60815","Malle","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-04-13");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (31,5,5,0,1,0,0,"auctor, velit eget","Ap #727-6304 Augue St.","19694","Tomaszów Mazowiecki","Lorem ipsum dolor sit amet, consectetuer adipiscing","2017-12-04"),(32,5,4,0,0,1,0,"orci quis lectus.","Ap #483-9232 Eleifend, Street","9463","Campbeltown","Lorem ipsum dolor sit amet,","2017-08-25"),(33,8,7,1,1,1,1,"Quisque varius. Nam","7538 Dui St.","V96 4VS","Belvedere Ostrense","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-08-11"),(34,1,9,0,0,1,0,"Phasellus elit pede,","Ap #936-3643 Augue St.","13940","Strombeek-Bever","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2017-02-04"),(35,7,3,0,1,0,0,"Vestibulum ante ipsum","Ap #872-8012 Scelerisque, Street","57256-907","Le Petit-Quevilly","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-09-15"),(36,8,9,0,1,0,0,"sem. Nulla interdum.","276-9667 Mollis. Rd.","671834","Richmond","Lorem","2017-10-02"),(37,3,10,0,0,0,0,"montes, nascetur ridiculus","501 Tempus Av.","04978","Laramie","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2016-11-29"),(38,2,8,0,1,0,0,"vehicula risus. Nulla","P.O. Box 465, 2848 Placerat Rd.","601527","Penco","Lorem ipsum dolor","2017-01-04"),(39,4,9,0,0,1,0,"nibh lacinia orci,","7388 Pharetra. Street","91-634","Diyarbakır","Lorem ipsum dolor sit amet,","2017-06-17"),(40,9,9,0,1,0,0,"Sed molestie. Sed","Ap #214-9206 Vitae Road","58820","Butte","Lorem ipsum dolor sit amet, consectetuer","2016-10-31");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (41,2,2,1,1,0,0,"neque. Nullam nisl.","P.O. Box 733, 4978 Consequat Rd.","52972","Fontaine-l'Evque","Lorem ipsum dolor","2017-04-23"),(42,10,7,0,0,1,0,"tristique neque venenatis","Ap #922-3525 Porttitor Street","15602","Santander","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-02-18"),(43,6,8,1,0,1,1,"est. Mauris eu","P.O. Box 204, 2143 Proin Av.","37611","Oakham","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-03-07"),(44,9,4,0,1,0,1,"aptent taciti sociosqu","P.O. Box 218, 2288 Orci Street","91636","Fauvillers","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-10-20"),(45,3,7,0,1,0,0,"augue malesuada malesuada.","Ap #334-9210 Eu, Avenue","0406NT","Ceyhan","Lorem ipsum dolor sit amet,","2017-01-31"),(46,8,10,0,1,0,1,"dui nec urna","8886 A Ave","90731","Treglio","Lorem ipsum","2016-04-06"),(47,2,2,0,0,1,1,"Maecenas libero est,","Ap #209-2067 Vitae Rd.","HM94 5LP","Pointe-aux-Trembles","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-04-04"),(48,2,4,0,1,1,1,"Nulla interdum. Curabitur","8094 Et Street","2071","Inverbervie","Lorem ipsum","2016-10-01"),(49,3,6,0,1,0,1,"eros turpis non","2839 Eget, Av.","21507","Beaumont","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-01-10"),(50,9,4,0,1,1,0,"orci quis lectus.","Ap #153-5958 Ultricies Street","43536","Swan Hill","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-05-25");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (51,4,1,1,0,1,0,"montes, nascetur ridiculus","8180 Elit, St.","76966","Roosendaal","Lorem ipsum","2016-06-26"),(52,8,5,0,1,0,1,"malesuada malesuada. Integer","Ap #487-5387 Scelerisque St.","60614","Louth","Lorem ipsum dolor sit amet, consectetuer","2017-06-29"),(53,10,1,0,0,0,0,"diam at pretium","P.O. Box 803, 6760 Aliquet Road","56954","Maria","Lorem ipsum dolor sit amet, consectetuer","2017-10-29"),(54,1,7,0,1,1,0,"congue. In scelerisque","P.O. Box 463, 5659 Praesent Ave","5196","Armungia","Lorem","2017-09-30"),(55,8,9,1,1,0,1,"nec enim. Nunc","1167 Congue St.","25505","Zellik","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-10-13"),(56,3,9,1,1,0,1,"hendrerit. Donec porttitor","977-3519 Nunc Ave","8454","Cockburn","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-05-31"),(57,8,6,0,1,1,0,"diam vel arcu.","784-5271 Duis Avenue","20661","Padre las Casas","Lorem ipsum dolor sit","2017-12-15"),(58,1,8,0,0,1,0,"vulputate velit eu","445-8348 Est Rd.","86515","Rotheux-RimiŽre","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2016-11-07"),(59,2,10,0,0,0,1,"ridiculus mus. Proin","P.O. Box 921, 7114 Arcu Street","11016","Coronel","Lorem ipsum dolor sit amet,","2016-07-23"),(60,3,1,0,0,1,1,"tempus scelerisque, lorem","2806 Nec, Rd.","79739","Vitrolles","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-01-11");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (61,3,2,1,1,1,0,"consequat purus. Maecenas","800-805 Nisi. Road","34831","Gijzegem","Lorem ipsum dolor sit","2016-06-21"),(62,7,7,1,1,1,1,"Quisque varius. Nam","3593 Malesuada Ave","778928","Bolsward","Lorem ipsum dolor sit amet,","2016-08-24"),(63,10,3,1,1,0,0,"risus. Quisque libero","Ap #204-5846 Erat. Av.","808904","Thuillies","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-03-28"),(64,6,6,0,1,1,0,"elit. Curabitur sed","189-3398 Pharetra, Rd.","I44 8DC","Tribogna","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-12-09"),(65,3,1,1,1,0,1,"Nullam enim. Sed","854-4084 Et Rd.","64433","Velaine-sur-Sambre","Lorem ipsum dolor","2017-04-06"),(66,2,9,1,0,1,0,"risus a ultricies","121-661 Mus. Ave","51501","Springfield","Lorem ipsum dolor sit amet,","2017-09-01"),(67,6,3,0,1,0,0,"rutrum, justo. Praesent","P.O. Box 147, 4096 Ridiculus Road","26289","Meerut Cantonment","Lorem ipsum dolor","2016-02-17"),(68,8,8,0,1,0,1,"ligula elit, pretium","Ap #391-7868 Enim. Av.","15945","Flint","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-11-03"),(69,7,6,1,1,1,1,"magnis dis parturient","Ap #838-1680 Urna. Street","S2W 6J1","Milena","Lorem ipsum dolor","2017-10-20"),(70,10,7,1,1,0,1,"tortor. Nunc commodo","6569 Justo Av.","17184","Carleton","Lorem","2016-07-19");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (71,3,9,0,1,0,1,"urna. Nullam lobortis","Ap #421-3517 Enim. St.","21-025","Sunshine Coast Regional District","Lorem ipsum dolor sit amet,","2017-03-08"),(72,7,5,0,0,0,0,"pulvinar arcu et","207-9603 Eu, Road","6668AX","Rocourt","Lorem ipsum dolor","2016-02-10"),(73,8,3,0,0,0,1,"libero mauris, aliquam","Ap #793-2253 Eu Av.","66583","Mumbai","Lorem ipsum dolor sit","2016-01-24"),(74,10,1,1,0,1,1,"et libero. Proin","P.O. Box 846, 4700 Suspendisse Street","466077","Nordhorn","Lorem","2016-06-12"),(75,10,9,1,1,1,0,"sit amet lorem","3009 Vel Ave","5641","Assiniboia","Lorem ipsum dolor sit amet, consectetuer adipiscing","2016-02-09"),(76,8,6,0,0,0,0,"volutpat ornare, facilisis","570-4698 Nunc Avenue","323235","Manukau","Lorem ipsum dolor sit","2016-06-06"),(77,8,5,1,1,1,1,"Aliquam nec enim.","P.O. Box 145, 2833 Mauris Street","39885","Offenburg","Lorem ipsum dolor","2017-09-03"),(78,7,4,1,0,0,0,"Phasellus fermentum convallis","Ap #245-171 Lobortis, Street","811771","Sovizzo","Lorem ipsum dolor sit","2017-09-22"),(79,2,7,0,1,0,1,"erat nonummy ultricies","3779 Nisi Road","62100","Grantham","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-03-09"),(80,4,4,1,1,1,1,"morbi tristique senectus","9005 Auctor, St.","71605","Pirna","Lorem ipsum","2017-12-20");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (81,2,8,0,0,1,0,"mi enim, condimentum","2824 Nullam Avenue","583721","Greifswald","Lorem ipsum dolor sit amet, consectetuer adipiscing","2017-12-31"),(82,1,5,0,0,1,1,"Vivamus nisi. Mauris","P.O. Box 578, 6927 Ipsum Street","43857-501","Glabais","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2016-06-23"),(83,10,1,1,0,1,1,"est ac facilisis","P.O. Box 920, 7845 Accumsan St.","611676","Workum","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-02-04"),(84,3,2,1,1,0,1,"fringilla mi lacinia","570-1997 Feugiat Rd.","8420","Bottrop","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2017-01-22"),(85,1,3,0,1,0,1,"augue ut lacus.","Ap #270-7139 Tellus, Rd.","11-990","Hijuelas","Lorem","2016-03-10"),(86,5,9,0,0,0,1,"pede sagittis augue,","P.O. Box 204, 4487 Nulla Avenue","76345","Folkestone","Lorem","2017-09-12"),(87,1,4,1,0,1,1,"tincidunt vehicula risus.","Ap #469-1083 Placerat, Rd.","699971","Itterbeek","Lorem ipsum dolor sit","2016-02-18"),(88,5,1,1,1,1,1,"sed, est. Nunc","Ap #679-5864 Elit. Ave","35130","Susegana","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2016-12-23"),(89,10,7,1,1,1,0,"sollicitudin adipiscing ligula.","948-2461 Sed Road","128823","Remscheid","Lorem ipsum dolor sit amet, consectetuer adipiscing elit.","2017-03-02"),(90,2,5,1,1,1,1,"et magnis dis","255-7316 Nec Rd.","04704","Bournemouth","Lorem ipsum dolor sit amet, consectetuer","2016-05-02");
INSERT INTO `activity` (`id`,`category_id`,`partner_id`,`participant_solo`,`participant_duo`,`participant_family`,`participant_friend`,`title`,`address`,`zip`,`city`,`description`,`recording_date`) VALUES (91,2,4,1,1,0,0,"dictum augue malesuada","879-7544 Egestas Ave","6646","La Roche-sur-Yon","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2016-09-26"),(92,6,3,1,0,0,0,"iaculis enim, sit","P.O. Box 197, 1691 In St.","280599","Eastbourne","Lorem ipsum","2016-11-19"),(93,3,6,1,0,0,1,"vel, faucibus id,","P.O. Box 461, 7875 Pretium Road","Q4G 7HB","North Vancouver","Lorem ipsum dolor sit amet, consectetuer","2016-09-01"),(94,8,1,0,1,0,1,"non, sollicitudin a,","123-8024 Odio Avenue","26096-431","Bokaro Steel City","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur sed","2017-03-10"),(95,4,1,0,1,0,1,"tortor. Nunc commodo","597-6694 Lacinia Avenue","94944-491","Zerkegem","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2017-07-07"),(96,3,10,1,1,0,1,"Nunc ut erat.","8858 Molestie St.","35894","Sint-Lambrechts-Woluwe","Lorem ipsum","2016-04-03"),(97,7,3,0,0,0,1,"nunc. Quisque ornare","Ap #842-448 Magna. Road","6292","Poppel","Lorem ipsum","2016-07-19"),(98,4,10,0,0,1,0,"enim nisl elementum","153-1573 Molestie Avenue","965045","Ternitz","Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur","2016-02-28"),(99,8,8,0,0,1,1,"Aenean euismod mauris","P.O. Box 877, 1307 Sit St.","42452","Waterbury","Lorem ipsum dolor sit amet, consectetuer adipiscing","2017-11-28"),(100,9,1,0,1,1,1,"quis diam. Pellentesque","8898 Arcu. Avenue","8165","Freirina","Lorem","2016-03-15");