[Building Sakai] SURROGATEKEY in MFR_OPEN_FORUM_T

[Bryan Holladay]

the surrogatekey is the ID for the level above it.

So, Forum's surrogate key is Area's ID.  Topic's surrogate key is forum's
ID (of=open forum, pf=private form).  Message's surrogate key is for
Topic's ID.

Correct, msgcntr doesn't delete anything, it just orphans the data.  The
best way to re-attach a deleted Forum/Topic/or Message is by looking at the
event history.  It will give you the ID of the Forum/Topic/or Message that
was deleted.  Then just look up that Forum/Topic/or Message and re-set it's
surrogate key to it's correct parent and it will be back in the UI

-Bryan


On Wed, Mar 20, 2013 at 4:16 PM, Zhen Qian <zqian at umich.edu> wrote:

> HI, Sakai Developers:
>
> Both MFR_OPEN_FORUM_T and MFR_MESSAGE_T contain a field called
> "surrogatekey". What is that field used for?
>
> When a forum or topic gets deleted, the surrogatekey is set to null. So if
> we want to recover the forum, how can we find out the original
> surrogatekey?
>
> Thanks,
>
> - Zhen
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130320/ad559271/attachment.html