Moodle

DB upgrade

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.7
  • Fix Version/s: 1.9
  • Component/s: SCORM
  • Labels:
    None
  • Affected Branches:
    MOODLE_17_STABLE
  • Fixed Branches:
    MOODLE_19_STABLE

Description

The SCORM 2004 introduce sequencing with a complex definition in the manifest and this causes a lot of new needed for store all the things in the DB.
Moreover to have a more flexible scoes attributes storing, every SCORM/AICC type has some different attributes, the scorm_scoes table must be changed and an attribute table is needed so the global sco informations are stored in the classic scorm_scoes table and all the type variable attributes will be stored in a new table.
Attached you will find an idea of MySQL table definition I think is needed, please check if it's the right idea.
All the related files (XMLDB, other DBs, backup and restore) must be updated and several part in the library code needs to be changed.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Roberto Pinna added a comment -

First step done.

Now new scorm version with different manifest data can be managed without no more db changes.

Bobo.

Show
Roberto Pinna added a comment - First step done. Now new scorm version with different manifest data can be managed without no more db changes. Bobo.
Hide
Permalink
Roberto Pinna added a comment -

Next step add all the tables needed for sequencing.

Show
Roberto Pinna added a comment - Next step add all the tables needed for sequencing.
Hide
Permalink
Roberto Pinna added a comment -

Sequencing tables ok.

Commit in CVS today.

Bobo.

Show
Roberto Pinna added a comment - Sequencing tables ok. Commit in CVS today. Bobo.
Hide
Permalink
Martin Dougiamas added a comment -

Another version delay

Show
Martin Dougiamas added a comment - Another version delay
Hide
Permalink
Martin Dougiamas added a comment -

Assigning to Sadiel for prioritising and fixing.

Show
Martin Dougiamas added a comment - Assigning to Sadiel for prioritising and fixing.
Hide
Permalink
Martin Dougiamas added a comment -

Assigning to Jesús Rincón to organise and start working on.

Show
Martin Dougiamas added a comment - Assigning to Jesús Rincón to organise and start working on.
Hide
Permalink
Roberto Pinna added a comment -

The only thing that must be done is to update backuplib.php and restorelib.php to current DB schema.

Show
Roberto Pinna added a comment - The only thing that must be done is to update backuplib.php and restorelib.php to current DB schema.
Hide
Permalink
Jesús Rincón added a comment -

We have already updated backuplib.php, but we haven't committed the changes in CVS yet because we need to know if the right schema is the one we can see in the mysql.sql attached file or we should do everything according to the database in moodle 1.8, meaning which are the names of the tables we have to use and if we have to include the table mdl_scorm_seq_mapinfo (since this one is not in the mysql.sql file).

Show
Jesús Rincón added a comment - We have already updated backuplib.php, but we haven't committed the changes in CVS yet because we need to know if the right schema is the one we can see in the mysql.sql attached file or we should do everything according to the database in moodle 1.8, meaning which are the names of the tables we have to use and if we have to include the table mdl_scorm_seq_mapinfo (since this one is not in the mysql.sql file).
Hide
Permalink
Martin Dougiamas added a comment -

mysql.sql (and postgres.sql files) is obsolete ... you should be using install.xml. This is the only authoritative schema.

Don't edit it by hand, you can view and change the database definition using the XMLdb editor (look in the Moodle admin menus).

Show
Martin Dougiamas added a comment - mysql.sql (and postgres.sql files) is obsolete ... you should be using install.xml. This is the only authoritative schema. Don't edit it by hand, you can view and change the database definition using the XMLdb editor (look in the Moodle admin menus).
Hide
Permalink
Jesús Rincón added a comment -

We have updated the restorelib.php and the backuplb.php files adding the functions which were necessary for the new database schema of the scorm module

Show
Jesús Rincón added a comment - We have updated the restorelib.php and the backuplb.php files adding the functions which were necessary for the new database schema of the scorm module
Hide
Permalink
Mayank Gupta added a comment -

SCORM 2004 Packages can have objectiveID's as text/string type and not necessary int. Thus, objectivieid field in prefix_scorm_seq_objective needs to be changed from type bigint(10) to type varchar or text.
More details here - MDL-28493

Show
Mayank Gupta added a comment - SCORM 2004 Packages can have objectiveID's as text/string type and not necessary int. Thus, objectivieid field in prefix_scorm_seq_objective needs to be changed from type bigint(10) to type varchar or text. More details here - MDL-28493

People

Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.