4f9478825caf — Ted Unangst a month ago
update blobdb schema
1 files changed, 5 insertions(+), 6 deletions(-)

M backupdb.go
M backupdb.go +5 -6
@@ 186,21 186,20 @@ func svalbard(dirname string) {
 		elog.Fatalf("can't open backup blob database")
 	}
 	_, err = blob.Exec("PRAGMA journal_mode=WAL")
-	doordie(blob, "create table filedata (xid text, media text, hash text, content blob)")
+	doordie(blob, "create table filedata (xid text, content blob)")
 	doordie(blob, "create index idx_filexid on filedata(xid)")
-	doordie(blob, "create index idx_filehash on filedata(hash)")
 	tx, err = blob.Begin()
 	if err != nil {
 		elog.Fatalf("can't start transaction: %s", err)
 	}
 	origblob := openblobdb()
 	for x := range filexids {
-		rows = qordie(origblob, "select xid, media, hash, content from filedata where xid = ?", x)
+		rows = qordie(origblob, "select xid, content from filedata where xid = ?", x)
 		for rows.Next() {
-			var xid, media, hash string
+			var xid string
 			var content sql.RawBytes
-			scanordie(rows, &xid, &media, &hash, &content)
-			doordie(tx, "insert into filedata (xid, media, hash, content) values (?, ?, ?, ?)", xid, media, hash, content)
+			scanordie(rows, &xid, &content)
+			doordie(tx, "insert into filedata (xid, content) values (?, ?)", xid, content)
 		}
 		rows.Close()
 	}