title: sql error on key word "references"
body: <p>I'd like you guy to help me please. Here's some SQL code I'm trying to execute.</p>
  
  <pre><code>create table Personne (
  id_personne serial primary key, 
  nom text not null, 
  prenom text not null, 
  email text not null);
  
  create table Ressource (
  id_ressource serial primary key, 
  nom_r text not null, 
  url text not null,  
  id_personne int not null, foreign key references Personne(id_personne));
  </code></pre>
  
  <p>I get an error like "syntax error nearby 'references Personne(id_personne))' line 5.</p>
  
  <p>I don't know where it's from. I went to W3school.com and from what I understand, what I wrote is correct. But it just doesn't work.</p>
  
  <p>Any kind of help would be appreciated !</p>
  
  <p>PS : I tried on MySql and Postgresql, same result.</p>