In my mailbox's Drafts folder is a collection of small fossil repos i kept
when i left a job in May, 2010 (they just held my own utility scripts, not
Corporate Property). To save them, i'd just attached them to a mail and
never sent them, preserving them as draft mails. Today, on a whim, i
unattached them and tried to open them...
[stephan@lapdog:~/tmp]$ f rebuild McTool.fsl
SQLITE_ERROR: table config has no column named mtime
f: table config has no column named mtime: {REPLACE INTO
config(name,value,mtime) VALUES('hash-policy',1,now())}
Not terribly surprising, but let's see if it's really that easy to get them
back up and running...
[stephan@lapdog:~/tmp]$ sqlite3 McTool.fsl
SQLite version 3.24.0 2018-05-12 23:56:22
...
sqlite> alter table config add column mtime integer;
sqlite>
[stephan@lapdog:~/tmp]$ f rebuild McTool.fsl
100.0% complete...
Yup!
i was expecting to have to do more schema surgery than that.
:)
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
