fixed online status reporting, updated CREATE.sql