편집 기록

final public String CREATE_FAVORITE_SONG_TABLE_QUERY =
        "CREATE TABLE " + FAVORITE_SONG_TABLE_NAME + " (" +
                "ID INTEGER PRIMARY KEY," +
                "favorite_id int(10)," +
                "sound_res char(30)," +
                "sound_name char(30)," +
                "volume int(10)," +
                "ismute int(1)," +
                "check int(1)" +
                ");";

소스가 이런대

near "int": syntax error (code 1): , while compiling: CREATE TABLE FAVORITESONG (ID INTEGER PRIMARY KEY,favorite_id int(10),sound_res char(30),sound_name char(30),volume int(10),ismute int(1),check int(1));

이렇게 에러가 나네요..

final public String CREATE_FAVORITE_SONG_TABLE_QUERY =
        "CREATE TABLE " + FAVORITE_SONG_TABLE_NAME + " (" +
                "ID INTEGER PRIMARY KEY," +
                "favorite_id int(10)," +
                "sound_res char(30)," +
                "sound_name char(30)," +
                "volume int(10)," +
                "ismute int(1)," +
                "check int(1)" +
                ");";

소스가 이런대

near "int": syntax error (code 1): , while compiling: CREATE TABLE FAVORITESONG (ID INTEGER PRIMARY KEY,favorite_id int(10),sound_res char(30),sound_name char(30),volume int(10),ismute int(1),check int(1));

이렇게 에러가 나네요..