chamilo / chamilo-lms

Chamilo is a learning management system focused on ease of use and accessibility
https://chamilo.org
GNU General Public License v3.0
798 stars 480 forks source link

Migrate user subscription to learning path from c_item_property to a c_lp_rel_user table #3411

Closed ywarnier closed 1 year ago

ywarnier commented 4 years ago

The implementation of the subscription of users to a learning path has been made a bit quickly in 1.*, so the state of subscription is stored in c_item_property.lastedit_type = 'usersubscribe'. Now that we're changing the c_item_property model, make sure this type or records is stored in a c_lp_rel_user table. Something like

CREATE TABLE c_lp_rel_user (
    iid int primary key auto_increment,
    lp_id int,
    user_id int,
    c_id int,
    session_id int,
    created_at datetime,
    creator_id int
);
christianbeeznest commented 2 years ago

It is implemented in this PR https://github.com/chamilo/chamilo-lms/pull/4333 , checking the migration from 1.11 to 2.0

NicoDucou commented 1 year ago

This issue is solved with PR #4747