CREATE TABLE authors ( id INTEGER PRIMARY KEY, username TEXT NULL, email TEXT NULL, name TEXT NOT NULL, bio TEXT );