bachelorthesis_applied_info.../database/sql/mysql/3_createRelationshipData.sql
2020-03-10 15:55:49 +01:00

257 lines
12 KiB
SQL

insert into relationships (personId) values (0);
insert into relationships (personId) values (1);
insert into relationships (personId) values (2);
insert into relationships (personId) values (3);
insert into relationships values (4, 1);
insert into relationships (personId) values (5);
insert into relationships (personId) values (6);
insert into relationships values (7, 26);
insert into relationships values (8, 20);
insert into relationships (personId) values (9);
insert into relationships (personId) values (10);
insert into relationships (personId) values (11);
insert into relationships (personId) values (12);
insert into relationships (personId) values (13);
insert into relationships (personId) values (14);
insert into relationships (personId) values (15);
insert into relationships (personId) values (16);
insert into relationships (personId) values (17);
insert into relationships (personId) values (18);
insert into relationships values (19, 57);
insert into relationships (personId) values (20);
insert into relationships values (21, 28);
insert into relationships values (22, 59);
insert into relationships values (23, 79);
insert into relationships values (24, 39);
insert into relationships (personId) values (25);
insert into relationships values (26, 65);
insert into relationships (personId) values (27);
insert into relationships (personId) values (28);
insert into relationships values (29, 35);
insert into relationships (personId) values (30);
insert into relationships (personId) values (31);
insert into relationships (personId) values (32);
insert into relationships (personId) values (33);
insert into relationships values (34, 49);
insert into relationships (personId) values (35);
insert into relationships (personId) values (36);
insert into relationships (personId) values (37);
insert into relationships (personId) values (38);
insert into relationships (personId) values (39);
insert into relationships (personId) values (40);
insert into relationships (personId) values (41);
insert into relationships (personId) values (42);
insert into relationships values (43, 14);
insert into relationships (personId) values (44);
insert into relationships (personId) values (45);
insert into relationships values (46, 49);
insert into relationships values (47, 28);
insert into relationships (personId) values (48);
insert into relationships (personId) values (49);
insert into relationships (personId) values (50);
insert into relationships (personId) values (51);
insert into relationships (personId) values (52);
insert into relationships (personId) values (53);
insert into relationships values (54, 87);
insert into relationships (personId) values (55);
insert into relationships (personId) values (56);
insert into relationships (personId) values (57);
insert into relationships values (58, 74);
insert into relationships (personId) values (59);
insert into relationships values (60, 24);
insert into relationships values (61, 61);
insert into relationships (personId) values (62);
insert into relationships (personId) values (63);
insert into relationships (personId) values (64);
insert into relationships (personId) values (65);
insert into relationships (personId) values (66);
insert into relationships values (67, 88);
insert into relationships (personId) values (68);
insert into relationships values (69, 55);
insert into relationships (personId) values (70);
insert into relationships values (71, 51);
insert into relationships values (72, 43);
insert into relationships (personId) values (73);
insert into relationships (personId) values (74);
insert into relationships values (75, 67);
insert into relationships values (76, 24);
insert into relationships (personId) values (77);
insert into relationships values (78, 87);
insert into relationships (personId) values (79);
insert into relationships (personId) values (80);
insert into relationships (personId) values (81);
insert into relationships (personId) values (82);
insert into relationships (personId) values (83);
insert into relationships (personId) values (84);
insert into relationships (personId) values (85);
insert into relationships values (86, 64);
insert into relationships (personId) values (87);
insert into relationships (personId) values (88);
insert into relationships values (89, 98);
insert into relationships values (90, 45);
insert into relationships values (91, 93);
insert into relationships (personId) values (92);
insert into relationships values (93, 4);
insert into relationships values (94, 62);
insert into relationships values (95, 37);
insert into relationships (personId) values (96);
insert into relationships (personId) values (97);
insert into relationships (personId) values (98);
insert into relationships (personId) values (99);
insert into relationships (personId) values (100);
insert into relationships values (101, 86);
insert into relationships values (102, 11);
insert into relationships (personId) values (103);
insert into relationships values (104, 38);
insert into relationships (personId) values (105);
insert into relationships (personId) values (106);
insert into relationships values (107, 11);
insert into relationships (personId) values (108);
insert into relationships values (109, 51);
insert into relationships values (110, 61);
insert into relationships (personId) values (111);
insert into relationships (personId) values (112);
insert into relationships (personId) values (113);
insert into relationships (personId) values (114);
insert into relationships (personId) values (115);
insert into relationships (personId) values (116);
insert into relationships (personId) values (117);
insert into relationships (personId) values (118);
insert into relationships (personId) values (119);
insert into relationships values (120, 84);
insert into relationships (personId) values (121);
insert into relationships (personId) values (122);
insert into relationships (personId) values (123);
insert into relationships (personId) values (124);
insert into relationships values (125, 56);
insert into relationships values (126, 96);
insert into relationships (personId) values (127);
insert into relationships values (128, 98);
insert into relationships values (129, 25);
insert into relationships (personId) values (130);
insert into relationships (personId) values (131);
insert into relationships (personId) values (132);
insert into relationships (personId) values (133);
insert into relationships (personId) values (134);
insert into relationships values (135, 96);
insert into relationships (personId) values (136);
insert into relationships (personId) values (137);
insert into relationships (personId) values (138);
insert into relationships (personId) values (139);
insert into relationships values (140, 92);
insert into relationships values (141, 10);
insert into relationships (personId) values (142);
insert into relationships values (143, 83);
insert into relationships (personId) values (144);
insert into relationships values (145, 34);
insert into relationships (personId) values (146);
insert into relationships (personId) values (147);
insert into relationships (personId) values (148);
insert into relationships (personId) values (149);
insert into relationships values (150, 79);
insert into relationships (personId) values (151);
insert into relationships values (152, 45);
insert into relationships (personId) values (153);
insert into relationships (personId) values (154);
insert into relationships (personId) values (155);
insert into relationships (personId) values (156);
insert into relationships values (157, 57);
insert into relationships (personId) values (158);
insert into relationships (personId) values (159);
insert into relationships values (160, 69);
insert into relationships values (161, 77);
insert into relationships (personId) values (162);
insert into relationships values (163, 51);
insert into relationships values (164, 17);
insert into relationships (personId) values (165);
insert into relationships (personId) values (166);
insert into relationships (personId) values (167);
insert into relationships (personId) values (168);
insert into relationships (personId) values (169);
insert into relationships (personId) values (170);
insert into relationships values (171, 97);
insert into relationships values (172, 19);
insert into relationships (personId) values (173);
insert into relationships values (174, 61);
insert into relationships (personId) values (175);
insert into relationships (personId) values (176);
insert into relationships (personId) values (177);
insert into relationships (personId) values (178);
insert into relationships values (179, 67);
insert into relationships (personId) values (180);
insert into relationships (personId) values (181);
insert into relationships values (182, 82);
insert into relationships values (183, 5);
insert into relationships (personId) values (184);
insert into relationships (personId) values (185);
insert into relationships (personId) values (186);
insert into relationships (personId) values (187);
insert into relationships (personId) values (188);
insert into relationships (personId) values (189);
insert into relationships values (190, 59);
insert into relationships (personId) values (191);
insert into relationships (personId) values (192);
insert into relationships values (193, 17);
insert into relationships (personId) values (194);
insert into relationships values (195, 85);
insert into relationships values (196, 14);
insert into relationships (personId) values (197);
insert into relationships (personId) values (198);
insert into relationships (personId) values (199);
insert into relationships values (200, 56);
insert into relationships values (201, 25);
insert into relationships (personId) values (202);
insert into relationships (personId) values (203);
insert into relationships (personId) values (204);
insert into relationships (personId) values (205);
insert into relationships values (206, 88);
insert into relationships (personId) values (207);
insert into relationships (personId) values (208);
insert into relationships (personId) values (209);
insert into relationships (personId) values (210);
insert into relationships (personId) values (211);
insert into relationships (personId) values (212);
insert into relationships values (213, 35);
insert into relationships (personId) values (214);
insert into relationships (personId) values (215);
insert into relationships (personId) values (216);
insert into relationships (personId) values (217);
insert into relationships (personId) values (218);
insert into relationships (personId) values (219);
insert into relationships (personId) values (220);
insert into relationships (personId) values (221);
insert into relationships (personId) values (222);
insert into relationships values (223, 17);
insert into relationships (personId) values (224);
insert into relationships (personId) values (225);
insert into relationships (personId) values (226);
insert into relationships values (227, 25);
insert into relationships values (228, 56);
insert into relationships (personId) values (229);
insert into relationships values (230, 73);
insert into relationships (personId) values (231);
insert into relationships values (232, 54);
insert into relationships (personId) values (233);
insert into relationships (personId) values (234);
insert into relationships (personId) values (235);
insert into relationships values (236, 95);
insert into relationships (personId) values (237);
insert into relationships (personId) values (238);
insert into relationships (personId) values (239);
insert into relationships (personId) values (240);
insert into relationships (personId) values (241);
insert into relationships (personId) values (242);
insert into relationships (personId) values (243);
insert into relationships (personId) values (244);
insert into relationships values (245, 11);
insert into relationships (personId) values (246);
insert into relationships (personId) values (247);
insert into relationships (personId) values (248);
insert into relationships (personId) values (249);
insert into relationships values (250, 79);
insert into relationships (personId) values (251);
insert into relationships values (252, 16);
insert into relationships (personId) values (253);
insert into relationships (personId) values (254);
insert into relationships (personId) values (255);