diff --git a/sql/archiver/swh-archiver-data.sql b/sql/archiver/swh-archiver-data.sql
index a156bd37..d9703f90 100644
--- a/sql/archiver/swh-archiver-data.sql
+++ b/sql/archiver/swh-archiver-data.sql
@@ -1,2 +1,2 @@
-INSERT INTO archive(id, url)
-VALUES('Banco', 'http://banco.softwareheritage.org:5003/');
+gINSERT INTO archive(id, url)
+VALUES('banco', 'http://banco.softwareheritage.org:5003/');
diff --git a/sql/archiver/swh-archiver-schema.sql b/sql/archiver/swh-archiver-schema.sql
index 82d46b98..014bc3a2 100644
--- a/sql/archiver/swh-archiver-schema.sql
+++ b/sql/archiver/swh-archiver-schema.sql
@@ -1,50 +1,52 @@
 -- In order to archive the content of the object storage, add
 -- some tables to keep trace of what have already been archived.
 
 create table dbversion
 (
   version     int primary key,
   release     timestamptz,
   description text
 );
 
 comment on table dbversion is 'Schema update tracking';
 
 INSERT INTO dbversion(version, release, description)
 VALUES(1, now(), 'Work In Progress');
 
-CREATE DOMAIN archive_id AS TEXT;
+CREATE TYPE archive_id AS ENUM (
+  'banco'
+);
 
 CREATE TABLE archive (
   id   archive_id PRIMARY KEY,
   url  TEXT
 );
 
 comment on table archive is 'Possible archives';
 comment on column archive.id is 'Short identifier for the archive';
 comment on column archive.url is 'Url identifying the archiver api';
 
 CREATE TYPE archive_status AS ENUM (
   'missing',
   'ongoing',
   'present'
 );
 
 comment on type archive_status is 'Status of a given archive';
 
 -- a SHA1 checksum (not necessarily originating from Git)
 CREATE DOMAIN sha1 AS bytea CHECK (LENGTH(VALUE) = 20);
 
 CREATE TABLE content_archive (
   content_id  sha1,
-  archive_id  archive_id REFERENCES archive(id) DEFERRABLE,
+  archive_id  archive_id REFERENCES archive(id),
   status      archive_status,
-  mtime       timestamptz,
-  PRIMARY KEY (content_id, archive_id) DEFERRABLE
+  mtime       timestamptz
+  PRIMARY KEY (content_id, archive_id)
 );
 
 comment on table content_archive is 'Referencing the status and whereabouts of a content';
 comment on column content_archive.content_id is 'content identifier';
 comment on column content_archive.archive_id is 'content whereabouts';
 comment on column content_archive.status is 'content status';
 comment on column content_archive.mtime is 'last time the content was stored';