Re: [WWdevel] webwork: gateway merge/database

[P G. L. <gl...@um...>]

On Thu, 14 Jul 2005 at 12:11 John Jones wrote:
>
> By the way, I just discovered that the current CVS version of webwork is
> not backward compatible with courses created before the gateway stuff
> was merged in.  Is there a conversion tool yet, or will there be?

Oops.  I'm thinking this is because of the added set and set_user tables
in the database.

No conversion tool yet, but I think all that needs to be done is to add
the additional columns to the tables:

  alter table [classname]_set add column assignment_type text;
  alter table [classname]_set add column attempts_per_version integer;
  alter table [classname]_set add column time_interval integer;
  alter table [classname]_set add column versions_per_interval integer;
  alter table [classname]_set add column version_time_limit integer;
  alter table [classname]_set add column version_creation_time bigint;
  alter table [classname]_set add column problem_randorder integer;
  alter table [classname]_set add column version_last_attempt_time bigint;

and similarly for set_user.

Gavin

-- 
P. Gavin LaRose, Ph.D.  Program Manager (Instructional Tech.)
Math Dept., University of Michigan
gl...@um...                        "There's no use in trying," [Alice]
734.764.6454                             said. "One Can't believe impossible
http://www.math.lsa.umich.edu/~glarose/  things." "I daresay you haven't had
                                         much practice," said the Queen.
                                                              - Lewis Carrol