chamilo-lms icon indicating copy to clipboard operation
chamilo-lms copied to clipboard

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

Open ywarnier opened this issue 4 years ago • 1 comments

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
);

ywarnier avatar Jul 27 '20 14:07 ywarnier

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

christianbeeznest avatar Jun 23 '22 10:06 christianbeeznest

This issue is solved with PR #4747

NicoDucou avatar Jun 15 '23 11:06 NicoDucou