Forum LAMS for Tech-Heads - General Forum: Re: Re: Deleting Course in public folder

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Gopinath, 

Here's how you can permanently delete a learning design from the public folder. 

1) Find out the workspace_folder_id for the Public Folder

mysql> select workspace_folder_id, name from lams_workspace_folder where name = 'Public Folder';
+---------------------+---------------+
| workspace_folder_id | name          |
+---------------------+---------------+
|                  46 | Public Folder |
+---------------------+---------------+
1 row in set (0.00 sec)

2) Find the learning_design_id of the sequence you want to delete in the Public folder (workspace_folder_id = 46)

mysql> select learning_design_id, title, user_id from lams_learning_design where workspace_folder_id = 46;
+--------------------+-------+---------+
| learning_design_id | title | user_id |
+--------------------+-------+---------+
|                  6 | Random sequence     |       5 |
+--------------------+-------+---------+
1 row in set (0.01 sec)


3) Start deleting the transitions

mysql> delete from lams_learning_transition where learning_design_id = 6; 
Query OK, 1 row affected (0.00 sec)

4) Then delete the activities

mysql> delete from lams_learning_activity where learning_design_id = 6; 
Query OK, 2 rows affected (0.04 sec)


5) And finally the design 

mysql> delete from lams_learning_design where learning_design_id = 6;
Query OK, 1 row affected (0.00 sec)


Sequence is now permanently gone. 

Ernie

Posted by Ernie Ghiglione