@@ 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()
}