How to create table in SQLite database

public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + TABLE + "(" + C_ID
                + " INTEGER PRIMARY KEY AUTOINCREMENT," + C_NAME + " text,"
                + C_SIDE + " text," + C_INVITE + " text," + C_COUNT + " text,"
                + C_ATTEND + " text," + C_ALCOHOL + " text )");
}