Differential D74 Diff 246 sql/archiver/content_archive_initialize.sql

Changeset View

Standalone View

				/* Create the entry for the object storage Banco */
				INSERT INTO archives(id, url)
				VALUES('Banco', 'http://banco.softwareheritage.org:5003/');
				ardumontUnsubmitted Not Done Inline Actions Like i noted on T412, we need to change the identifier. Sorry i did not see it earlier. This text of 5 (for Banco) multiplied by the number of contents (one per row in content_archive), too much lost space. A simple integer should be enough. ardumont: Like i noted on T412, we need to change the identifier. Sorry i did not see it earlier. This…


				/* Fill the archive table with all the content as missing */
				INSERT INTO content_archive
				SELECT sha1, id, 'missing', now()
				FROM content, archives;
				ardumontUnsubmitted Not Done Inline Actions @olasd pointed me to the right file (concerning the backup-ed content in banco) so this is no longer true. Well, at least, when T412 is done, we'll be able to inject only what's really missing. Also, we'd be better off adding the status as enum (also to reduce storage size). ardumont: @olasd pointed me to the right file (concerning the backup-ed content in banco) so this is no…
				ardumontUnsubmitted Not Done Inline Actions status as enum (also to reduce storage size). which is already the case ^^ ardumont: > status as enum (also to reduce storage size). which is already the case ^^