[ckan-dev] moderated edits c(r)ep. http://trac.ckan.org/ticket/1129

[David Raznick]

> Been meaning to do a longer post but looking short on time, so just to
> say yes, but I think that David's point about doing the queries using
> date ranges on revisions is spot on the money (and portable between
> databases).  It should allow for efficient querying of the state of
> entire object graphs and be portable between databases.
>
> Seb
>

I have made an editable schema diagram for the proposed revisioning system
change that fits this model.

https://docs.google.com/drawings/d/1Y7nMgVsrs081Pame2RdbZHlCAlV33ddTZ8VAsab1j-0/edit?hl=en_GB&authkey=CJfd8vsB

The package and resource tables are now deprecated to a single column (id).
This is just for foreign key constraints.

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20110517/4fd8cf3d/attachment-0001.html>