2012/4/16 Puneet Kishor <[email protected]>:
> I am experimenting with a home-grown versioning system where every
> "significant" modification to row would be performed on a copy of the row,
> the original being preserved.
> Any other suggestions to achieve a similar functionality would be welcome.
> --
> Puneet Kishor
1. Use Git or Mercurial
2. Try this:
CREATE TABLE instance (
filename TEXT,
version INT,
size INT,
md5sum TEXT,
creation_date TEXT,
last_write_time TEXT,
PRIMARY KEY(filename,version),
FOREIGN KEY (md5sum) REFERENCES resource (md5sum)
);
CREATE TABLE resource (
md5sum TEXT,
data BLOB,
primary key(md5sum)
);
--
Kit
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
