[cle-release-team] Lesson Builder SQL scripts

[Sam Ottenhoff]

MySQL allows the addition of IF NOT EXISTS to the table creation syntax.
 Many people use Lesson Builder in 2.8.

  http://dev.mysql.com/doc/refman/5.1/en/create-table.html

create table IF NOT EXISTS lesson_builder_comments (


On Tue, Jan 3, 2012 at 10:10 AM, Beth Kirschner <bkirschn at umich.edu> wrote:

> Happy New Year everyone!
>
>   Chuck has created some SQL scripts for Lesson Builder table/index
> creation (see below) -- I can add these to the 2.9 conversion scripts later
> today, but thought it worth mentioning to others who might have an opinion
> (especially Seth, who's worked with conversion scripts in the past with
> Anthony).
>
> - Beth
>
> Begin forwarded message:
>
> > From: Charles Hedrick <hedrick at rutgers.edu>
> > Date: January 3, 2012 9:48:30 AM EST
> > To: Beth Kirschner <bkirschn at umich.edu>
> > Subject: Re: sql file
> >
> > Since I can edit library, could you add
> >
> >
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x//hbm/src/ddl/mysql/lessonbuilder.sql
> >
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x/hbm/src/ddl/oracle/lessonbuilder.sql
> >
> >
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x/components/src/ddl/mysql/simplepage.sql
> >
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x/components/src/ddl/oracle/simplepage.sql
> >
> > to the appropriate scripts? All the dialects are there if you want
> others.
> >
> > The first create the tables. The second add the indices. Because of
> hibernate problems I can't depend upon hibernate to add indices. The files
> to create indices are maintained by hand.
> >
> > The table creation files were generated using
> >
> > hibernate.dialect=org.hibernate.dialect.MySQLDialect
> > hibernate.dialect=org.hibernate.dialect.OracleDialect
> >
> > We actually use MySQL5Dialect in production, and I'm guessing Oracle
> sites use the appropriate version, but I don't think we want that many
> different scripts. I compared the mysql file with my test system and the
> differences looked OK.
> >
> > ---------
> >
> > I have updated SAK-21069 with two items for the release notes. I've also
> checked my installation notes to see whether there is anything that someone
> might have to do with the 2.9 version. I believe all of these are going to
> be in 2.9, but if any is not, I'll need to add something for the release
> notes. I'll be checking them shortly and updating the comment appropriately:
> >
> > 1) permissions set
> >
> > 2)
> portal.pda.bypass.sakai.lessonbuildertool=linktracker$|/uvbview$|\.jpg$|\.gif$|\.js$|\.png$|\.jepg$|\.css$|\.zip$|\.pdf\.mov$|\.json$|\.jsonp$\.xml$|\.ajax$|\.xls|\.xlsx|\.doc|\.docx
> >
> > 3) .neoPortletTitleWrap added to tool.css
> >
> >
> >
> > On Jan 3, 2012, at 9:23 AM, Beth Kirschner wrote:
> >
> >> On Jan 3, 2012, at 9:16 AM, Charles Hedrick wrote:
> >>
> >>> Do you consider this conversion? For most sites it's going to be a new
> tool.
> >> I consider this a conversion for 2.9 -- this is a new tool for the
> official 2.9 release. I
> >>
> >>> For sites that have it already they have a strange conglomeration of
> existing versions. I think enabling auto.ddl at least temporarily is the
> safest thing for them.
> >>>
> >> I'd write something up to the release notes for
> https://jira.sakaiproject.org/browse/SAK-21069 (the "Release Notes" tab
> is visible when you select "Edit"), so it doesn't get forgotten.
> >>
> >>> I was responding to a comment from someone that a core tool needed to
> provide a script to create the database tables initially.
> >>>
> >> Right -- not all sites use auto.ddl.
> >>
> >> Thanks!
> >> - Beth
> >>
> >>>
> >>> On Jan 3, 2012, at 8:45 AM, Beth Kirschner wrote:
> >>>
> >>>> Hi Chuck -- happy new year!
> >>>>
> >>>> The standard place for SQL conversion files is in
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion:
> >>>>    sakai_2_9_0_mysql_conversion.sql
> >>>>    sakai_2_9_0_oracle_conversion.sql
> >>>>
> >>>> Thanks!
> >>>> - Beth
> >>>>
> >>>> On Jan 2, 2012, at 9:26 PM, Hedrick Charles wrote:
> >>>>
> >>>>> FYI, trunk and 1.4.x of lessonbuilder now have a working DDL
> generator. I have build .sql files to create the database tables.
> >>>>>
> >>>>> The README documents this. Is there any standard place that the
> files go?
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>
> >>>
> >>>
> >>
> >
> >
> >
>
> _______________________________________________
> cle-release-team mailing list
> cle-release-team at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/cle-release-team
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/cle-release-team/attachments/20120103/1f83b3a6/attachment-0006.html