[Building Sakai] External users and properties

[Aaron Zeckoski]

The file you are referring to has not changed since 2008.
/sakai-kernel-impl/src/main/sql/mysql/sakai_user.sql

It also appears that constraint exists in 2.7 and 2.8 so I don't think
this is anything new. I might be that you removed the constraint
previously in your DB or something like that. If that worked for you
before then you should be safe to continue doing this probably.

-AZ


On Thu, Mar 28, 2013 at 6:01 PM, Joshua Swink <joshua.swink at gmail.com> wrote:
> We store properties for external users in the SAKAI_USER_PROPERTY table.
> With Sakai 2.9.1, there is a constraint that prevents these properties from
> being saved. It only allows user properties for users who are in the
> SAKAI_USER table.
>
> kernel/kernel-impl/src/main/sql/mysql/sakai_user.sql:
>
> ALTER TABLE SAKAI_USER_PROPERTY
>        ADD  ( FOREIGN KEY (USER_ID)
>                              REFERENCES SAKAI_USER (USER_ID) ) ;
>
> I expect that this will be dealt with by removing the constraint, rather
> than adding all external users to SAKAI_USER, or going without saving these
> properties.
>
> These properties will be an important part of our workflow for the
> foreseeable future. I hope there aren't any serious repercussions to
> removing the constraint.
>
> Josh
>
>
>
> _______________________________________________
> 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"



-- 
Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile