Fix broken tests after migrating archive_id to enum
Also, fix typos in sql schema and data definition