messages_people table does not exist

[smarou]

I try to populate apache db from step 0 https://github.com/collab-uniba/personality

I download all sql files and run every query in database from here https://mega.nz/#F!cJ0BiSrI!DYWcN7CbcHdSfqpuzSSmuw

I need this step in order to reproduce the step 3 and 4 from your project https://github.com/collab-uniba/Personality-Recognition-in-SD to extract the file mailcorpus.json

When I run the code from file get_mail_corpus.sql

SET group_concat_max_len=18446744073709547520;
SELECT 
CONCAT(
'[',
GROUP_CONCAT(
JSON_OBJECT(
'id',messages.message_id,
'mailing_list_url',messages.mailing_list_url,
'type_of_recipient',messages_people.type_of_recipient,
'email_address',messages_people.email_address,
'message_body',messages.message_body,
'is_response_of',messages.is_response_of
) SEPARATOR ',\r'),
']') AS list
FROM messages
LEFT JOIN messages_people
ON messages.message_id = messages_people.message_id
AND messages.mailing_list_url = messages_people.mailing_list_url
WHERE email_address IN ('dr@gorsvet.kz', 'mathews@uk2.net', 'd.jentsch@fu-berlin.de', 'atul.soman@microfocus.com', 'kkrugler_lists@transpac.com', 'hcorg@minions.org.pl', 'bruno.ronchetti@mac.com', 'christophe.thiebaud@sap.com', 'kc.baltz@copart.com', 'havanki4j@gmail.com', 'joseph.obernberger@ngc.com', 'goran@roseen.se', 'hboutemy@apache.org', 'johann@gyger.name', 'fredrik@jonson.org', 'jose-marcio.martins@mines-paristech.fr', 'dmytro.kostiuchenko@gmail.com', 'jochen.wiedmann@softwareag.com', 'guyskk@qq.com', 'alejandroscandroli@gmail.com', '1983-01-06@gmx.net', 'jstrayer@proofpoint.com', 'daniel@degu.cl', 'hontvari@flyordie.com', 'david@andl.org', 'gholmes@pinsightmedia.com', 'dennis.geurts@luminis.eu', 'carlspring@gmail.com', 'jozef.koval@protonmail.ch', 'gabriele.ctn@gmail.com', 'ashish.disawal@evivehealth.com', 'aarslan2@anadolu.edu.tr', 'kshukla@yahoo-inc.com', 'alex.huang@gmail.com', 'markus@openindex.io', 'marohn@sipgate.de', 'ea@apache.org', 'krzysztof.szalast@gmail.com', 'kfoskey@tpg.com.au', 'krauss@in.tum.de', 'kenhans@hotmail.co.uk', 'jokin.c@odeian.com', 'eitch@eitchnet.ch', 'm.kristian@web.de', 'bob.sandiford@sirsidynix.com', 'asandstrom2@eastlink.ca', 'kelly@apache.org', 'antony.blakey@linkuistics.com.au', 'ashawki@hotmail.com', 'h.klocker-mark@tsn.at');

The query doesn't be executed as the table messages_people doesn't exist in the database.

Please, can you ensure that messages_people exist in the sql files in step 0?