title: creating db table with foreign key ANDROID
body: <p>Im trying to created a db that (at the moment) has 4 tables <code>{USERS,TOPICS,GROUPS,CREATED_TOPICS}</code>. I keep getting this error when i try and run it...</p>
  
  <blockquote>
    <p>syntax error (code 1): , while compiling: create table
    created_topics_table (CREATED_TOPIC_ID INTEGER PRIMARY KEY
    AUTOINCREMENT, TOPIC_ID INTEGER,USER_ID INTEGER, FOREIGN KEY(TOPIC_ID)
    REFERENCES topics_table(_ID),FOREIGN KEY(USER_ID) REFERENCES
    users_table(_ID).</p>
  </blockquote>
  
  <p>heres the code...</p>
  
  <pre><code>public class databaseHelper extends SQLiteOpenHelper
  {
  //DATABASE NAME
  public static final String DATABASE_NAME = "users.db";
  //USERS TABLE
  public static final String TABLE_NAME_USERS = "users_table";
  public static final String COL_USER_ID = "_ID";
  public static final String COL_USER_NAME = "USER_NAME";
  public static final String COL_USER_EMAIL = "USER_EMAIL";
  public static final String COL_USER_PASSWORD = "USER_PASSWORD";
  //TOPICS TABLE
  public static final String TABLE_NAME_TOPICS = "topics_table";
  public static final String COL_TOPIC_ID = "_ID";
  public static final String COL_TOPIC_NAME = "TOPIC_NAME";
  
  
  //GROUPS TABLE
  public static final String TABLE_NAME_GROUPS = "groups_table";
  public static final String COL_GROUP_ID = "GROUP_ID";
  public static final String COL_GROUP_NAME = "GROUP_NAME";
  
  public static final String TABLE_NAME_CREATED_TOPICS =
  "created_topics_table";
  public static final String COL_CREATED_TOPIC_ID = "CREATED_TOPIC_ID";
  public static final String COL_FK_TOPIC_TOPIC_ID = "TOPIC_ID";
  public static final String COL_FK_TOPIC_USER_ID = "USER_ID";
  
  public void onCreate(SQLiteDatabase db) {
  db.execSQL("create table " + TABLE_NAME_USERS + " (_ID INTEGER PRIMARY KEY   
  AUTOINCREMENT,USER_NAME TEXT,USER_EMAIL TEXT,USER_PASSWORD TEXT)");
  db.execSQL("create table " + TABLE_NAME_TOPICS + " (_ID INTEGER PRIMARY KEY     
  AUTOINCREMENT,TOPIC_NAME TEXT)");
  db.execSQL("create table " + TABLE_NAME_GROUPS + " (GROUPS_ID INTEGER PRIMARY    
  KEY AUTOINCREMENT,GROUP_NAME TEXT)");
  db.execSQL("create table " + TABLE_NAME_CREATED_TOPICS + " (CREATED_TOPIC_ID 
  INTEGER PRIMARY KEY AUTOINCREMENT, TOPIC_ID INTEGER,USER_ID INTEGER, FOREIGN
  KEY(TOPIC_ID) REFERENCES " +TABLE_NAME_TOPICS + "(_ID)," +                                                                                                                                                            
  "FOREIGN KEY(USER_ID) REFERENCES " +TABLE_NAME_USERS + "(_ID)");
  }
  </code></pre>