Replacing the courseware_studentmodulehistory Table

This section describes a change to the courseware_studentmodulehistory database table.

Note

The changes described in this section are a part of the upgrade to the Open edX Eucalyptus release.

The change to the courseware_studentmodulehistory database table requires a new database configuration, and offers an optional data migration. This change will be released to the edx-platform repository on 5 May 2016, and will affect all Open edX installations that follow master on that date.

Important

If you are responsible for maintaining an Open edX instance, including a devstack, fullstack, or production installation, you must prepare for this change before you upgrade to the 5 May 2016 version of master.

This section presents an overview of the change followed by options for completing the required and optional procedures. EdX recommends that you review all of the topics in this section before you choose an option for your Open edX installation.

• Overview of the courseware_studentmodulehistory Changes
  • What Is the courseware_studentmodulehistory Table?
  • What Is the Issue?
  • What Is the Replacement Table?
  • Why Is A New Database Needed?
• Options for Updating courseware_studentmodulehistory
  • Keep, and Query, Both Tables
  • Reprovision or Reinstall Your Devstack
  • Migrate All Data to One Table
• Procedures for Replacing courseware_studentmodulehistory
  • Step 1: Create the Database
  • Use the Playbook to Create the Database
  • Create the Database Manually
  • Step 2: Configure the Database
  • Update DATABASES Manually
  • Step 3: Enable Writes to the New Table
  • Step 4: Create the Table
  • Run Migrations Manually
  • Optional Step 5: Migrate All Data to the New Table
  • Run the Script for Separate Database Servers
  • Run the Script for A Single Database Server

---

Feedback