diff --git a/sql/archiver/content_archive_initialize.sql b/sql/archiver/content_archive_initialize.sql new file mode 100644 --- /dev/null +++ b/sql/archiver/content_archive_initialize.sql @@ -0,0 +1,9 @@ +/* Create the entry for the object storage Banco */ +INSERT INTO archives(id, url) +VALUES('Banco', 'http://banco.softwareheritage.org:5003/'); + + +/* Fill the archive table with all the content as missing */ +INSERT INTO content_archive +SELECT sha1, id, 'missing', now() +FROM content, archives;