android - 创建表句中的Sqlite异常

我有一张有两张桌子的桌子。最近，我插入了一个新行（database），得到如下消息：

android.database.sqlite.SQLiteException: near "text": syntax error: create table tasks (_id integer primary key autoincrement, title text not null,location text not null, body text not null ,  goaldate text not null ,  absolutedate text not null ,  currentdate text not null ,  prio text not null,  done text not null,  category text not null,  timespent text not null,  pososto text not null,  father text not null,  check text not null );

为了包含新行，我已经更改了方法，但是我真的找不到我做错了什么。
这是我的密码，提前谢谢

public static final String KEY_TITLE = "title";
public static final String KEY_BODY = "body";
public static final String KEY_ROWID = "_id";
public static final String KEY_FATHER="father";//father's id
public static final String KEY_location = "location";
public static final String KEY_GOAL_DATE = "goaldate";
public static final String KEY_ABSOLUTE_DATE = "absolutedate";
public static final String KEY_DATE_CURRENT = "currentdate";
public static final String KEY_PRIO= "prio";
public static final String KEY_DONE = "done";
public static final String KEY_CATEGORY = "category";
public static final String KEY_TIME_SPEND = "timespent";
public static final String KEY_POSOSTO = "pososto";
public static final String KEY_TODAY= "check";

public static final String KEY_STITLE = "atitle";
public static final String KEY_ROID = "_id";
public static final String KEY_SCOLOR = "color";


private static final String TAG = "ListDatabase";
/**
 * @uml.property  name="mDbHelper"
 * @uml.associationEnd
 */
private DatabaseHelper mDbHelper;
private SQLiteDatabase mDb;

/**
 * Creating   database tables
 */
private static final String DATABASE_CREATE =
    "create table tasks (_id integer primary key autoincrement, "

    + "title text not null,"
    +"location text not null, "
    + "body text not null , "
    +" goaldate text not null , "
    +" absolutedate text not null , "
    +" currentdate text not null , "
    +" prio text not null, "
    +" done text not null, "
    +" category text not null, "
    +" timespent text not null, "
    +" pososto text not null, "
    +" father text not null, "
    +" check text not null );";

最佳答案

Check是a reserved word in SQLite；请尝试重命名该列或将其放入SQL语句中的（转义）双引号中。