Differences

This shows you the differences between two versions of the page.

--- learnexa_content_update [2019/01/31 09:53]
182.72.26.6 [Database Changes]
+++ learnexa_content_update [2019/02/06 09:50] (current)
182.72.26.6 [Database Changes]
@@ Line 4: / Line 4: @@
 ) Admin/Instructor should be able to update the contents created by them.
 ) There should also be an option to auto publish the content based on time periods.
 ) Users enrolled to these updated contents should be notified and provided an option to refresh the content.
@@ Line 23: / Line 25: @@
 ==== Database Changes ====
-Add a new table to add multiple items for content
+) Add a new table to add multiple items for content
-Table name - content_items
+Table name - content_versions
-content_items belongs_to content
+content_versions belongs_to content
+content has_many content_versions
+Also remove contentable_id, contentable_type columns from content table.
 ^ Column_name       ^Type       ^ Description   ^
 | id | integer           | primary key   |
 | content_id | integer           | content id to which it belongs to |
-| content_type | string           | content type to which it belongs to |
 | contentable_id | integer           | contentable id to which it belongs to |
 | contentable_type | string           | contentable type to which it belongs to |
@@ Line 39: / Line 44: @@
 | created_at| date_time |created date |
 | updated_at| date_time|updated date |
+) Add a new table to save content version details to be viewed by enrolled users
+Table name - enrolled_contents
+enrolled_contents belongs_to enrollments
+content has_many enrolled_contents
+^ Column_name       ^Type       ^ Description   ^
+| id | integer           | primary key   |
+| enrollment_id | integer | enrollment id to which it belongs to |
+| content_id | integer           | content id  |
+| content_version_id | integer           | conten_version id |
+| created_at| date_time |created date |
+| updated_at| date_time|updated date |
+==== UI Template ====
+Following are the UI templates for updating video contents, the same will be applicable for documents, scorm and tincan contents. Web page and Quiz type contents UI stays the same no changes required.
+) On Clicking "Edit" link
+{{screen1.png}}
+) On clicking the slider icon, options to add new content versions will be shown
+{{screen2.png}}
+) Player lightbox UI, to notify user that the content has been updated
+{{screen3.png}}

DokuWiki

Site Tools

Differences

Page Tools