That first row, I just typed in the information manually to see what it would look like.
Don't know if this helps:
PHP Code:
CREATE TABLE 'loot' (account TEXT DEFAULT '' PRIMARY KEY, class TEXT DEFAULT '', name_en TEXT DEFAULT '', loc TEXT DEFAULT '', x INTEGER DEFAULT 0, y INTEGER DEFAULT 0)