[Building Sakai] Does anyone have good DB-Diagrams for Sakai 2.x?

[Sam Ottenhoff]

Sakai has explicit foreign keys; I'm not sure what Chuck's problem was.
 Using DbVisualizer on a proper Sakai database will show lots of foreign
key relationships.

Using MySQL *without* InnoDB enabled means that your database was probably
created using MyISAM tables.  MyISAM tables do not support foreign keys.

--Sam


On Wed, Jan 9, 2013 at 6:50 AM, Jean-Francois Leveque <
jean-francois.leveque at upmc.fr> wrote:

> Hi Chuck,
>
> Do you mean foreign keys are handled by the app instead of being part of
> the DDL, when writing about "lack of explicit foreign keys"?
>
> If it's the case, shouldn't we improve the DDL?
>
> Thanks,
>
> J-F
>
> On 22/03/2012 13:23, csev wrote:
> > Thanks to everyone with the db visualizer help.
> >
> > Of course I dumped Sakai in and the lack of explicit foreign keys kept
> > the model quite boring.
> >
> > So I did it by hand in Keynote for my lecture.
> >
> > Lecture went well.
> >
> > Again, thanks.
> >
> > /Chuck
> _______________________________________________
> 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/20130109/b3d31cc5/attachment.html