-- Adminer 4.3.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

INSERT INTO `contact` (`id_contact`, `id_person`, `id_contact_type`, `contact`) VALUES
(1,	1,	4,	'ethyl.herren@gmail.com'),
(2,	2,	4,	'temple.gumbs@outlook.com'),
(3,	3,	4,	'tuan.brauer@gmail.com'),
(4,	4,	4,	'everett.hilbert@live.com'),
(5,	5,	4,	'karl.oshiro@gmail.com'),
(6,	6,	4,	'glennie.hottinger@gmail.com'),
(7,	7,	4,	'maddierankins@gmail.com'),
(8,	8,	4,	'toledo.earlie@gmail.com'),
(9,	9,	4,	'crandall@outlook.com'),
(10,	10,	4,	'colangelo@live.com'),
(11,	11,	4,	'barrientos@yahoo.com'),
(12,	12,	4,	'edmann@hotmail.com'),
(13,	13,	4,	'callender.jessica@gmail.com'),
(14,	14,	4,	'rolando.lung@gmail.com'),
(15,	15,	4,	'tommygun@yahoo.com'),
(16,	16,	4,	'fucha@gmail.com'),
(17,	17,	4,	'oshiro.karl@outlook.com'),
(18,	18,	4,	'maglione.twyla@live.com'),
(19,	19,	4,	'woodford@hotmail.com'),
(20,	20,	4,	'mckay.bess@gmail.com'),
(21,	21,	4,	'lona@gmail.com'),
(22,	22,	4,	'axeman5@gmail.com'),
(23,	23,	4,	'clockMaster1@gmail.com'),
(24,	24,	4,	'petal.nisbet@yahoo.com'),
(25,	25,	4,	'knowsy@gmail.com'),
(26,	26,	4,	'spacey.nisbet@outlook.com'),
(27,	27,	4,	'slonaker@yahoo.com'),
(28,	28,	4,	'summers54@gmail.com'),
(29,	29,	4,	'hilary.deen@gmail.com'),
(30,	30,	4,	'siqueiros@hotmail.com'),
(31,	31,	4,	'householder@gmail.com'),
(32,	32,	4,	'leclaire@outlook.com'),
(33,	33,	4,	'gene.dion@gmail.com'),
(34,	34,	4,	'kiiny.ericka.kreiner@gmail.com'),
(35,	8,	3,	'724548217'),
(36,	9,	3,	'725852711'),
(37,	10,	3,	'773525542'),
(38,	11,	3,	'776828485'),
(39,	12,	3,	'723258369'),
(40,	13,	3,	'774123475'),
(41,	14,	3,	'735252756'),
(42,	15,	3,	'728424666'),
(43,	16,	3,	'726587663'),
(44,	17,	3,	'726548723'),
(45,	18,	3,	'724963797'),
(46,	19,	3,	'774564320'),
(47,	20,	3,	'775545965'),
(48,	21,	3,	'772264852'),
(49,	22,	3,	'721253542'),
(50,	23,	3,	'722654752'),
(51,	24,	3,	'731765214'),
(52,	25,	3,	'774251714'),
(53,	26,	3,	'774954246'),
(54,	27,	3,	'732725825'),
(55,	28,	3,	'734821462'),
(56,	29,	3,	'732654654'),
(57,	30,	3,	'775828254'),
(58,	31,	3,	'774741524'),
(59,	32,	3,	'775595419'),
(60,	33,	3,	'723654179'),
(61,	34,	3,	'776853578'),
(62,	1,	2,	'ethy12'),
(63,	2,	2,	'temple.gumbs'),
(64,	3,	2,	'hilbert3'),
(65,	4,	2,	'everett'),
(66,	5,	2,	'teague'),
(67,	6,	2,	'kaneshiro'),
(68,	7,	2,	'maddie.rankins'),
(69,	8,	2,	'toledo3'),
(70,	9,	2,	'bigbill'),
(71,	10,	2,	'roderick'),
(72,	21,	2,	'lona.sonny'),
(73,	22,	2,	'tristan.axeman'),
(74,	23,	2,	'clock-master'),
(75,	24,	2,	'nisbet.petal'),
(76,	25,	2,	'knowsy'),
(77,	26,	2,	'spacey52'),
(78,	27,	2,	'emiii4x4'),
(79,	28,	2,	'gilda.summer'),
(80,	29,	2,	'hilary.4'),
(81,	30,	2,	'igneess'),
(82,	31,	2,	'householder.alisha'),
(83,	32,	2,	'marcel.miranda'),
(84,	33,	2,	'gene.dion'),
(85,	34,	2,	'kreiner'),
(86,	8,	1,	'earlie.toledo.1'),
(87,	9,	1,	'bill.crandall.3'),
(88,	10,	1,	'roderick.colangelo.1'),
(89,	11,	1,	'alycia.barrientos'),
(90,	12,	1,	'julissa.erdmann'),
(91,	13,	1,	'jesica.callender.3'),
(92,	14,	1,	'rolando.lung.4'),
(93,	15,	1,	'thomas.dowdle.1'),
(94,	16,	1,	'fuchs.tuan'),
(95,	17,	1,	'karl.oshi.1'),
(96,	20,	1,	'bess.mckay'),
(97,	21,	1,	'sonny.sonny'),
(98,	22,	1,	'tristan.axeman'),
(99,	23,	1,	'clockmaster.wingert'),
(100,	24,	1,	'petal.leonora'),
(101,	28,	1,	'summers.gilda'),
(102,	29,	1,	'remona.deen.3'),
(103,	30,	1,	'lisette.igneess'),
(104,	32,	1,	'marcel.miranda.5'),
(105,	33,	1,	'dion.leclaire.4'),
(106,	34,	1,	'ericka.kreiner.1'),
(108,	47,	4,	'frfr@gmail.com'),
(109,	47,	4,	'francis.francoise@gmail.com'),
(110,	47,	4,	'francoise.wood@gmail.com');

INSERT INTO `contact_type` (`id_contact_type`, `name`, `validation_regexp`) VALUES
(1,	'facebook',	''),
(2,	'skype',	''),
(3,	'tel',	'+?([0-9]{3})?s*[0-9]{3}s*[0-9]{3}s*[0-9]{3}'),
(4,	'email',	''),
(5,	'jabber',	''),
(6,	'web',	'');

INSERT INTO `location` (`id_location`, `city`, `street_name`, `street_number`, `zip`, `country`, `name`, `latitude`, `longitude`) VALUES
(1,	'Holice',	'Nad Splavem',	315,	'534 01',	NULL,	NULL,	NULL,	NULL),
(2,	'Castletown-Bearhaven',	'The Square',	NULL,	NULL,	'Ireland',	'Ring of Beara',	52,	-10),
(3,	'Stirling',	'Fountain Rd',	27,	'FK9 4AT',	'United Kingdom',	NULL,	56,	-4),
(4,	'Bridge of Allan',	'Henderson St',	15,	'FK9 4HN',	'United Kingdom',	'The Allanwater Cafe',	56,	-4),
(5,	'Vsetín',	'Sedličky',	6,	'755 01',	NULL,	NULL,	NULL,	NULL),
(6,	'Muir of Ord',	'Old Rd',	182,	'IV6 7UJ',	'United Kingdom',	'Glen Ord Distillery',	57,	-4),
(7,	'Linz',	'Promenade',	39,	'4010',	'Austria',	'Landestheater Linz',	48,	14),
(8,	'Bremen',	'Doventorsteinweg',	48,	'281 95',	'Germany',	'Agentur Für Arbeit',	53,	9),
(9,	'Linz',	'Mozartstraße',	33,	'4020',	'Austria',	NULL,	48,	14),
(10,	'Holice',	'Husova',	NULL,	'534 01',	NULL,	NULL,	NULL,	NULL),
(11,	'Inverness',	'Dochfour Drive',	4,	'IV3 5EF',	'United Kingdom',	NULL,	57,	-4),
(12,	'Budišov nad Budišovkou',	'Halaškovo náměstí',	178,	'747 87',	NULL,	NULL,	50,	18),
(13,	'Nowa Wieś Wrocławska',	'Ulica Nowa',	9,	'55-080',	'Poland',	NULL,	51,	17),
(14,	'Samopše - Mrchojedy',	NULL,	4,	'285 06',	NULL,	'Auto Body Shop',	50,	15),
(15,	'Přišimasy',	NULL,	119,	'282 01',	NULL,	NULL,	50,	15),
(16,	'Znojmo',	'Kuchařovická',	1,	'669 02',	NULL,	NULL,	49,	16),
(17,	'Bad Zell',	'Linzer Straße',	19,	'4283',	'Austria',	NULL,	48,	15),
(18,	'Meziměstí',	'Školní',	NULL,	'549 81',	NULL,	NULL,	51,	16),
(19,	'Hradec Králové',	'Rokitanského',	62,	'500 03',	NULL,	'Univerzita Hradec Králové',	50,	16),
(20,	'Plzeň',	'Kollárova ',	6,	'301 00 ',	NULL,	NULL,	50,	13),
(21,	'Portishead',	'Rodmoor Rd',	NULL,	'BS20 7HZ',	'United Kingdom',	'Portishead Bowling Club',	51,	-3),
(22,	'Sharpness',	'The Docks',	NULL,	'GL13 9UN',	'United Kingdom',	'Sharpness Dockers Club',	NULL,	NULL),
(23,	'Hradec Králové',	'Nový Hradec',	754,	'500 06',	NULL,	NULL,	NULL,	NULL),
(24,	'Bolton',	'Davenport Street',	12,	'BL1 2LT',	'United Kingdom',	NULL,	54,	-2),
(25,	'Hradec Králové',	'Govorova',	628,	'500 06',	NULL,	NULL,	NULL,	NULL),
(26,	'Hradec Králové',	'Rokycanova',	159,	'500 06',	NULL,	NULL,	NULL,	NULL),
(27,	'Llanfairpwllgwyngyll',	'Ffordd Penmynydd',	5,	'LL61 6UX',	'United Kingdom',	NULL,	53,	-4),
(28,	'Lanškroun',	'Pražské předměstí',	154,	'563 01',	NULL,	NULL,	NULL,	NULL),
(29,	'Lanškroun',	'Zámecká',	419,	'563 01',	NULL,	NULL,	NULL,	NULL),
(30,	'Luton',	'University Square',	NULL,	'LU1 3JU',	'United Kingdom',	'University of Bedfordshire, Luton Campus',	52,	-1),
(31,	'Pardubice',	'Mahonova',	1530,	'532 01',	NULL,	NULL,	NULL,	NULL),
(32,	'Pardubice',	'Přemyslova',	1284,	'532 01',	NULL,	NULL,	NULL,	NULL),
(33,	'Pardubice',	'Albertova',	485,	' ',	NULL,	NULL,	NULL,	NULL),
(34,	'Bremen',	'Katrepeler Straße',	48,	'282 15',	'Germany',	NULL,	53,	9),
(35,	'Maastricht',	'Fort Willemweg',	47,	'6219 PA',	'Netherlands',	NULL,	51,	6),
(36,	'Prachatice',	'Pražská',	103,	'383 01',	NULL,	NULL,	NULL,	NULL),
(37,	'Llanbedr Dyffryn Clwyd',	'Troed Y Fenlli',	3,	'LL15 1BQ',	'United Kingdom',	NULL,	53,	-3),
(38,	'Düsseldorf',	'Elisabethstraße',	40,	'40 217',	'Germany',	NULL,	51,	7),
(39,	'Antwerpen',	'Jan van Rijswijcklaan',	191,	'2020',	'Belgium',	'Antwerp Expo',	51,	4),
(40,	'Albrechtice nad Orlicí',	'T. G. Masaryka',	128,	'517 22',	NULL,	NULL,	NULL,	NULL),
(41,	'Brno',	'Zemědělská',	1,	'613 00',	NULL,	'school',	49,	17),
(42,	'Brno',	'Kotlářská',	10,	'602 00',	NULL,	'Rybářské potřeby U Sumce',	49,	17),
(43,	NULL,	NULL,	NULL,	NULL,	NULL,	'Home',	NULL,	NULL),
(44,	'Brno',	'Vodova',	336,	'612 00',	NULL,	'Hala Vodova',	49,	17),
(45,	'Brno',	'Gorkého',	96,	'602 00',	NULL,	'U Bláhovky',	49,	17),
(46,	'Brno',	NULL,	NULL,	NULL,	NULL,	'under the clock',	NULL,	NULL),
(47,	'Brno',	NULL,	NULL,	NULL,	NULL,	'in the park',	NULL,	NULL),
(48,	'Praha',	'Aviatická',	2,	'161 00',	NULL,	'Terminal 1',	50,	14),
(49,	'Hradec Králové',	'Velké náměstí',	26,	'500 03',	NULL,	'Kavárna U Knihomola',	50,	16),
(51,	'Paris',	'Avenue Gustave Eiffel',	NULL,	NULL,	NULL,	'La Tour Eiffel',	NULL,	NULL);

INSERT INTO `meeting` (`id_meeting`, `start`, `description`, `duration`, `id_location`) VALUES
(1,	'2016-12-25 15:00:00',	'books',	NULL,	41),
(2,	'2016-09-17 11:30:00',	'',	NULL,	42),
(3,	'2016-09-06 09:30:00',	'electrician',	'01:30:00',	43),
(4,	'2016-08-31 12:00:00',	'',	NULL,	45),
(5,	'2016-09-15 19:30:00',	'flowers!',	NULL,	46),
(6,	'2016-09-17 11:30:00',	'',	NULL,	28),
(7,	'2016-10-18 09:30:00',	'fishing eqp',	NULL,	31),
(8,	'2016-09-21 13:30:00',	'lunch',	'02:00:00',	49),
(9,	'2016-12-05 14:00:00',	'',	NULL,	41),
(10,	'2016-09-24 16:30:00',	'',	NULL,	47),
(11,	'2016-10-26 18:00:00',	'window cleaners',	NULL,	43),
(12,	'2016-08-18 13:30:00',	'',	'00:30:00',	47),
(13,	'2016-12-05 09:30:00',	'fishing eqp',	NULL,	12),
(14,	'2016-12-07 17:00:00',	'',	NULL,	45),
(15,	'2016-09-24 12:30:00',	'lunch',	NULL,	43),
(16,	'2016-12-05 20:30:00',	'',	NULL,	47),
(17,	'2016-09-06 15:00:00',	'pickup',	NULL,	48),
(18,	'2016-08-22 19:00:00',	'',	'02:30:00',	44);

INSERT INTO `person` (`id_person`, `nickname`, `first_name`, `last_name`, `id_location`, `birth_day`, `height`, `gender`) VALUES
(1,	'Ethy',	'Ethyl',	'Herren',	34,	'1968-09-06',	164,	'female'),
(2,	'Gumby',	'Temple ',	'Gumbs',	2,	NULL,	184,	'female'),
(3,	'Tungsten',	'Tuan',	'Brauer',	3,	'1982-01-20',	180,	'male'),
(4,	'Bertie',	'Everett',	'Hilbert',	4,	'1983-05-25',	172,	'male'),
(5,	'Teague',	'Karl',	'Oshiro',	5,	'1980-03-09',	NULL,	'male'),
(6,	'Kaneshiro',	'Glennie',	'Hottinger',	6,	'1982-10-20',	161,	'female'),
(7,	'mara',	'Maddie',	'Rankins',	7,	'1979-10-11',	185,	'female'),
(8,	'Toledo',	'Earlie',	'Toledo',	8,	'1986-04-29',	194,	'female'),
(9,	'BigBill',	'Bill',	'Crandall',	9,	'1982-02-24',	175,	'male'),
(10,	'Usher',	'Roderick',	'Colangelo',	10,	'1981-05-13',	NULL,	'male'),
(11,	'Alice',	'Alycia',	'Barrientos',	11,	'1984-06-14',	180,	'female'),
(12,	'Julerd',	'Julissa',	'Erdmann',	10,	'1985-07-27',	173,	'female'),
(13,	'january',	'Jesica',	'Callender',	12,	'1964-10-09',	174,	'female'),
(14,	'Lungs',	'Rolando',	'Lung',	13,	'1974-11-29',	178,	'male'),
(15,	'TommyGun',	'Thomas',	'Dowdle',	14,	'1989-12-01',	162,	'male'),
(16,	'Fucha',	'Tuan',	'Fuchs',	20,	'1952-11-02',	168,	'male'),
(17,	'Oshi',	'Karl',	'Oshiro',	16,	'1980-12-20',	177,	'male'),
(18,	'Magnolia',	'Twyla',	'Maglione',	17,	'1942-07-16',	180,	'female'),
(19,	'Arlene',	'Arlette',	'Woodford',	18,	'1946-01-15',	NULL,	'female'),
(20,	'Bessie',	'Bess',	'Mckay',	19,	'1979-09-30',	159,	'female'),
(21,	'Sony',	'Sonny',	'Lona',	19,	'1982-06-19',	160,	'male'),
(22,	'axeMan',	'Tristan',	'Gory',	20,	'1968-08-21',	194,	'male'),
(23,	'Clock-Master',	'Lincoln',	'Wingert',	21,	'1975-11-18',	185,	'male'),
(24,	'Petal',	'Leonora',	'Nisbet',	21,	'1978-05-26',	172,	'female'),
(25,	'Know$y',	'Janey',	'Knowlton',	22,	'1985-11-09',	165,	'female'),
(26,	'Spacey',	'Leonora',	'Nisbet',	NULL,	'1971-01-12',	185,	'female'),
(27,	'Emiii4x4',	'Barton',	'Slonaker',	24,	'1972-02-15',	177,	'male'),
(28,	'Summers',	'Gilda',	'Summer',	24,	'1973-03-18',	168,	'female'),
(29,	'hilary',	'Remona',	'Deen',	25,	NULL,	170,	'female'),
(30,	'Igneess',	'Lisette',	'Siqueiros',	26,	NULL,	170,	'female'),
(31,	'hali',	'Alisha',	'Householder',	27,	'1981-10-24',	168,	'female'),
(32,	'Leclaire',	'Marcel',	'Miranda',	28,	'1976-11-28',	NULL,	'male'),
(33,	'Gene',	'Dion',	'Leclaire',	29,	'1977-12-21',	163,	'male'),
(34,	'Kiiny',	'Ericka',	'Kreiner',	30,	'1978-06-30',	182,	'female'),
(35,	'fox',	'Meagan',	'Holst',	31,	'1979-12-31',	176,	'female'),
(36,	'pPhil',	'Phyliss',	'Metheny',	32,	'1980-05-16',	166,	'female'),
(37,	'cutty',	'Nelia',	'Cutter',	33,	'1965-02-12',	169,	'female'),
(38,	'8al',	'Florentino',	'Balfour',	34,	'1966-03-16',	173,	'male'),
(39,	'Swordy',	'Justin',	'Wess',	35,	'1967-09-08',	178,	'male'),
(40,	'LouReed',	'Reed',	'Judah',	36,	'1986-05-11',	190,	'male'),
(41,	'zachy',	'Zachery',	'Figueiredo',	37,	'1982-07-07',	175,	'male'),
(42,	'Tanaka',	'Goldie',	'Steen',	39,	'1985-01-13',	181,	'female'),
(43,	'homa',	'Hong',	'Maday',	40,	'1980-05-16',	164,	'male'),
(45,	'Kami',	'Dexter',	'Pagano',	NULL,	NULL,	NULL,	'male'),
(46,	'Agan',	'Opal',	'Bagg',	NULL,	NULL,	183,	'female'),
(47,	'Francis',	'Francoise',	'Wood',	NULL,	'1980-03-12',	NULL,	'female'),
(49,	'hiromi',	'Carl',	'Oshiro',	NULL,	NULL,	NULL,	'male');

INSERT INTO `person_meeting` (`id_person`, `id_meeting`) VALUES
(1,	1),
(1,	11),
(2,	1),
(2,	2),
(3,	1),
(3,	2),
(3,	8),
(3,	15),
(4,	1),
(4,	3),
(4,	8),
(4,	13),
(5,	1),
(5,	4),
(5,	8),
(5,	16),
(5,	17),
(6,	5),
(6,	8),
(6,	17),
(7,	5),
(7,	8),
(8,	6),
(8,	8),
(10,	6),
(10,	8),
(11,	18),
(12,	6),
(13,	7),
(13,	12),
(14,	6),
(14,	17),
(15,	9),
(15,	11),
(15,	14),
(15,	17),
(16,	10),
(16,	14),
(17,	7),
(17,	12),
(18,	18),
(19,	18),
(20,	7),
(21,	14),
(22,	7),
(22,	12),
(23,	18),
(24,	6),
(24,	14),
(25,	6),
(26,	7),
(27,	18),
(28,	7),
(29,	4),
(29,	6),
(30,	16),
(30,	17),
(31,	7),
(31,	17),
(32,	3),
(32,	7),
(32,	14),
(32,	17),
(33,	7),
(33,	13),
(33,	14),
(33,	18),
(34,	6),
(34,	10),
(34,	12),
(34,	14),
(35,	6),
(35,	12),
(35,	14),
(36,	6),
(36,	12),
(36,	14),
(37,	15),
(38,	6),
(39,	11),
(39,	17),
(40,	11),
(41,	11),
(41,	14);

INSERT INTO `relation` (`id_relation`, `id_person1`, `id_person2`, `description`, `id_relation_type`) VALUES
(1,	20,	21,	'',	8),
(2,	23,	24,	'',	8),
(3,	1,	39,	'23.5.2016',	8),
(4,	3,	37,	'12.3.2015',	8),
(5,	5,	36,	'',	8),
(6,	6,	3,	'4.9.2014',	8),
(7,	20,	12,	'',	7),
(8,	18,	16,	'',	7),
(9,	10,	29,	'',	7),
(10,	11,	30,	'',	7),
(11,	11,	35,	'',	7),
(12,	14,	24,	'',	7),
(13,	3,	25,	'',	7),
(14,	1,	24,	'',	4),
(15,	1,	25,	'',	4),
(16,	2,	26,	'',	4),
(17,	2,	30,	'',	4),
(18,	2,	35,	'',	4),
(19,	2,	6,	'school',	4),
(20,	2,	8,	'school',	4),
(21,	3,	16,	'',	4),
(22,	3,	24,	'',	4),
(23,	3,	32,	'',	4),
(24,	3,	36,	'',	4),
(25,	4,	15,	'',	4),
(26,	4,	21,	'',	4),
(27,	4,	23,	'',	4),
(28,	4,	12,	'',	4),
(29,	5,	17,	'',	4),
(30,	5,	19,	'',	4),
(31,	5,	22,	'school',	4),
(32,	5,	29,	'',	4),
(33,	5,	32,	'',	4),
(34,	5,	34,	'',	4),
(35,	6,	17,	'',	4),
(36,	6,	19,	'',	4),
(37,	8,	22,	'',	4),
(38,	11,	35,	'',	6),
(39,	11,	36,	'',	6),
(40,	5,	34,	'not sure',	6),
(41,	6,	36,	'',	6),
(42,	1,	30,	'',	6),
(43,	15,	29,	'',	6),
(44,	2,	32,	'',	1),
(45,	9,	21,	'',	1),
(46,	10,	21,	'',	1),
(47,	15,	21,	'',	1),
(48,	2,	25,	'',	1),
(49,	2,	27,	'',	1),
(50,	10,	27,	'',	1),
(51,	11,	26,	'',	1),
(52,	12,	25,	'',	1),
(53,	12,	27,	'',	1),
(54,	12,	28,	'',	1),
(55,	13,	31,	'',	1),
(56,	14,	33,	'',	1),
(57,	16,	22,	'',	1),
(58,	17,	31,	'',	1),
(59,	17,	34,	'',	1),
(60,	18,	37,	'',	1),
(61,	18,	22,	'',	1),
(62,	18,	29,	'',	1),
(63,	19,	31,	'',	1),
(64,	19,	38,	'',	1),
(65,	20,	27,	'',	1),
(66,	21,	27,	'hiking',	1),
(67,	31,	34,	'hiking',	1),
(68,	35,	36,	'',	1),
(69,	30,	31,	'',	1),
(70,	21,	34,	'',	1),
(71,	21,	35,	'',	1),
(72,	22,	23,	'',	1),
(73,	17,	34,	'',	5),
(74,	18,	37,	'',	5),
(75,	18,	22,	'hiking',	5),
(76,	18,	29,	'',	5),
(77,	19,	31,	'',	5),
(78,	19,	38,	'',	5),
(79,	20,	27,	'',	5),
(80,	21,	27,	'',	5),
(81,	31,	34,	'',	5),
(82,	1,	21,	'',	2),
(83,	3,	23,	'',	2),
(84,	5,	24,	'',	2),
(85,	6,	28,	'owes 15k',	2),
(86,	7,	32,	'',	2),
(87,	7,	34,	'',	2),
(88,	6,	34,	'owes 54k',	2),
(89,	5,	34,	'',	2),
(90,	1,	24,	'',	2);

INSERT INTO `relation_type` (`id_relation_type`, `name`) VALUES
(1,	'friend'),
(2,	'enemy'),
(3,	'partner'),
(4,	'colleague'),
(5,	'acquaintance'),
(6,	'lover'),
(7,	'family'),
(8,	'spouse');

-- 2017-09-27 12:13:29
