/* TODO for v3 */
/* "CREATE TABLE IF NOT EXISTS room_members (" */
/* "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, " */
/* "room_id INTEGER NOT NULL REFERENCES rooms(id) ON DELETE CASCADE, " */
/* "user_id INTEGER NOT NULL REFERENCES users(id), " */
/* joined, invited, left (we set left instead of deleting as past messages may refer to user id */
/* "user_state INTEGER NOT NULL DEFAULT 0, " */
/* /\* A user can have different name and avatar in rooms *\/ */
/* "display_name TEXT, " */
/* "avatar_url TEXT, " */
/* "json_data TEXT, " */
/* "UNIQUE (room_id, user_id));" */
/* Update rooms */
/* on account_id DELETE CASCADE */
/* TODO for v3 */
/* "CREATE TABLE IF NOT EXISTS room_events (" */
/* "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, " */
/* "room_id INTEGER NOT NULL REFERENCES rooms(id) ON DELETE CASCADE, " */
/* "sender_id INTEGER NOT NULL REFERENCES room_members(id), " */
/* "event_type INTEGER NOT NULL, " */
/* "event_uid TEXT NOT NULL, " */
/* txnid require for redactions, to resend failed, etc */
/* txnid TEXT, */
/* "replaces_event_id INTEGER REFERENCES room_events(id), " */
/* "reply_to_id INTEGER REFERENCES room_events(id), " */
/* sending, sent, sending failed,
/* event_state INTEGER, */
/* "state_key TEXT UNIQUE, " */
/* "origin_server_ts INTEGER NOT NULL, " */
/* direction int, encrypted int, verified int */
/* "json_data TEXT, " */
/* "UNIQUE (room_id, event_uid));" */