The SQL file that came with the exile server files was meant to create a database from scratch but with a NFO web host that isn't possible since databases have to be created through the cpanel. I had an error that stated access denied because it was trying to create a database but because of security reasons it's not allowed to do so. I quickly fixed this error by deleting the code that was trying to create this database and just have it import the tables from the SQL file. Unfortunately it came back with an error stating ...
#1215 - Cannot add foreign key constraint
I cannot figure this out for anything. I am quite new to SQL so help would be much appreciated.
here's a dropbox link to the file
It is the year 2039. After the resource depleting conflict in Greece, Europe suffers from a new deflation crisis, leading the crime rate to a new peak in history. Members of the North Atlantic Treaty Organization Security Council are forced to react. Being a desperate alternative to overcrowded and prohibitive prisons, offenders are now being sent to EXILE.