외부키 참조 테이블 만들기 (쿼리)

// java에서 테이블 생성 시

 

public boolean CreateTables() {

boolean Flag = true; 

 

try {

  mDB.execSQL("CREATE TABLE IF NOT EXISTS alarm_info (" +

"info_code INTEGER PRIMARY KEY AUTOINCREMENT, " +

      "title TEXT, " +

      "sun_repeat INTEGER, " +

      "mon_repeat INTEGER, " +

      "tue_repeat INTEGER, " +

      "wen_repeat INTEGER, " +

      "thu_repeat INTEGER, " +

      "fri_repeat INTEGER, " +

      "sat_repeat INTEGER " +

      "); ");

 

mDB.execSQL("CREATE TABLE IF NOT EXISTS alarm_list (" +

     "list_code INTEGER PRIMARY KEY AUTOINCREMENT, " +

                     "info_code INTEGER references alarm_info(info_code) on delete restrict deferrable initially deferred, " +

       "alarm_time TEXT, " +

        "wifi_action INTEGER " +

        "); ");

 

} catch(SQLException e) {

msgBox(e.toString());

// Toast.makeText(null, e.toString(), Toast.LENGTH_SHORT).show(); 

Flag = false;

}

 

return Flag;

}