(1620,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785928737,'web','0:0:0:0:0:0:0:1',NULL),(1621,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,2,1,NULL,0,'null',1785928740,'web','0:0:0:0:0:0:0:1',NULL),(1622,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785929186,'web','0:0:0:0:0:0:0:1',NULL),(1623,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785929188,'web','0:0:0:0:0:0:0:1',NULL),(1624,'\\core\\event\\draft_file_added','core','added','draft_file','files',186,'c',0,5,30,2,2,0,2,0,'{\"itemid\":831944426,\"filename\":\"block_miflora_student_1.0.0-beta1.zip\",\"filesize\":8613,\"filepath\":\"\\/\",\"contenthash\":\"42d24f2bbde6786c14b5ae9848e6c9d693d2ff6f\",\"avscantime\":0.0055119991302490234}',1785929212,'web','0:0:0:0:0:0:0:1',NULL),(1625,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785929303,'web','0:0:0:0:0:0:0:1',NULL),(1626,'\\core\\event\\user_loggedin','core','loggedin','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"username\":\"admin\",\"extrauserinfo\":[]}',1785929312,'web','0:0:0:0:0:0:0:1',NULL),(1627,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785929313,'web','0:0:0:0:0:0:0:1',NULL),(1628,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,2,1,NULL,0,'null',1785929322,'web','0:0:0:0:0:0:0:1',NULL),(1629,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785929323,'web','0:0:0:0:0:0:0:1',NULL),(1630,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785929331,'web','0:0:0:0:0:0:0:1',NULL),(1631,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785929333,'web','0:0:0:0:0:0:0:1',NULL),(1632,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,2,13,NULL,0,'null',1785929337,'web','0:0:0:0:0:0:0:1',NULL),(1633,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"1jbgaacvglhkf3itolsn5fbgk4\"}',1785929345,'web','0:0:0:0:0:0:0:1',NULL),(1634,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785929345,'web','0:0:0:0:0:0:0:1',NULL),(1635,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785929355,'web','0:0:0:0:0:0:0:1',NULL),(1636,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785929355,'web','0:0:0:0:0:0:0:1',NULL),(1637,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785929363,'web','0:0:0:0:0:0:0:1',NULL),(1638,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785929365,'web','0:0:0:0:0:0:0:1',NULL),(1639,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785929367,'web','0:0:0:0:0:0:0:1',NULL),(1640,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785929370,'web','0:0:0:0:0:0:0:1',NULL),(1641,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785929374,'web','0:0:0:0:0:0:0:1',NULL),(1642,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785947676,'web','0:0:0:0:0:0:0:1',NULL),(1643,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785947715,'web','0:0:0:0:0:0:0:1',NULL),(1644,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785947724,'web','0:0:0:0:0:0:0:1',NULL),(1645,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785947776,'web','0:0:0:0:0:0:0:1',NULL),(1646,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785947777,'web','0:0:0:0:0:0:0:1',NULL),(1647,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785947782,'web','0:0:0:0:0:0:0:1',NULL),(1648,'\\core\\event\\draft_file_added','core','added','draft_file','files',188,'c',0,5,30,2,2,0,2,0,'{\"itemid\":988847715,\"filename\":\"block_miflora_student_1.0.0-beta1 (1).zip\",\"filesize\":8613,\"filepath\":\"\\/\",\"contenthash\":\"42d24f2bbde6786c14b5ae9848e6c9d693d2ff6f\",\"avscantime\":0.037989139556884766}',1785948201,'web','0:0:0:0:0:0:0:1',NULL),(1649,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785948243,'web','0:0:0:0:0:0:0:1',NULL),(1650,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785948245,'web','0:0:0:0:0:0:0:1',NULL),(1651,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785948247,'web','0:0:0:0:0:0:0:1',NULL),(1652,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785948249,'web','0:0:0:0:0:0:0:1',NULL),(1653,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785948251,'web','0:0:0:0:0:0:0:1',NULL),(1654,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785948252,'web','0:0:0:0:0:0:0:1',NULL),(1655,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"5avk08laumfcd1vvmrps2415jl\"}',1785948255,'web','0:0:0:0:0:0:0:1',NULL),(1656,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785948255,'web','0:0:0:0:0:0:0:1',NULL),(1657,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785948263,'web','0:0:0:0:0:0:0:1',NULL),(1658,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785948264,'web','0:0:0:0:0:0:0:1',NULL),(1659,'\\core\\event\\draft_file_added','core','added','draft_file','files',190,'c',0,5,30,2,2,0,2,0,'{\"itemid\":936574029,\"filename\":\"mod_miflora_evidence_1.0.0-beta1.zip\",\"filesize\":14842,\"filepath\":\"\\/\",\"contenthash\":\"507eecdd0afd9d6679daf5da8e9bb4c6e551cce1\",\"avscantime\":0.014096975326538086}',1785951101,'web','0:0:0:0:0:0:0:1',NULL),(1660,'\\core\\event\\draft_file_added','core','added','draft_file','files',192,'c',0,5,30,2,2,0,2,0,'{\"itemid\":7451149,\"filename\":\"mod_miflora_evidence_1.0.0-beta1.zip\",\"filesize\":14842,\"filepath\":\"\\/\",\"contenthash\":\"507eecdd0afd9d6679daf5da8e9bb4c6e551cce1\",\"avscantime\":0.0005271434783935547}',1785951118,'web','0:0:0:0:0:0:0:1',NULL),(1661,'\\core\\event\\draft_file_added','core','added','draft_file','files',194,'c',0,5,30,2,2,0,2,0,'{\"itemid\":513822965,\"filename\":\"mod_miflora_evidence_1.0.0-beta1.zip\",\"filesize\":14842,\"filepath\":\"\\/\",\"contenthash\":\"507eecdd0afd9d6679daf5da8e9bb4c6e551cce1\",\"avscantime\":0.0003681182861328125}',1785951135,'web','0:0:0:0:0:0:0:1',NULL),(1662,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"j701ppcgagabvggan78v8j952o\"}',1785951143,'web','0:0:0:0:0:0:0:1',NULL),(1663,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785951143,'web','0:0:0:0:0:0:0:1',NULL),(1664,'\\core\\event\\user_loggedin','core','loggedin','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"username\":\"admin\",\"extrauserinfo\":[]}',1785951152,'web','0:0:0:0:0:0:0:1',NULL),(1665,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785951152,'web','0:0:0:0:0:0:0:1',NULL),(1666,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785951155,'web','0:0:0:0:0:0:0:1',NULL),(1667,'\\core\\event\\draft_file_added','core','added','draft_file','files',196,'c',0,5,30,2,2,0,2,0,'{\"itemid\":20035695,\"filename\":\"mod_miflora_evidence_1.0.0-beta1.zip\",\"filesize\":14842,\"filepath\":\"\\/\",\"contenthash\":\"507eecdd0afd9d6679daf5da8e9bb4c6e551cce1\",\"avscantime\":0.0003979206085205078}',1785951168,'web','0:0:0:0:0:0:0:1',NULL),(1668,'\\core\\event\\draft_file_added','core','added','draft_file','files',198,'c',0,5,30,2,2,0,2,0,'{\"itemid\":72697324,\"filename\":\"mod_miflora_evidence_1.0.0-beta1.zip\",\"filesize\":14842,\"filepath\":\"\\/\",\"contenthash\":\"507eecdd0afd9d6679daf5da8e9bb4c6e551cce1\",\"avscantime\":0.00023102760314941406}',1785951231,'web','0:0:0:0:0:0:0:1',NULL),(1669,'\\core\\event\\draft_file_added','core','added','draft_file','files',200,'c',0,5,30,2,2,0,2,0,'{\"itemid\":324285686,\"filename\":\"local_miflora_core_0.1.0-beta1.zip\",\"filesize\":7293,\"filepath\":\"\\/\",\"contenthash\":\"7886c72584c0d41ce09aa0b69a48c49e49d6226b\",\"avscantime\":0.0004849433898925781}',1785952091,'web','0:0:0:0:0:0:0:1',NULL),(1670,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785953133,'web','0:0:0:0:0:0:0:1',NULL),(1671,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"ghlolrtikj34cpn4ue5atrc117\"}',1785953136,'web','0:0:0:0:0:0:0:1',NULL),(1672,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785953136,'web','0:0:0:0:0:0:0:1',NULL),(1673,'\\core\\event\\user_loggedin','core','loggedin','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"username\":\"admin\",\"extrauserinfo\":[]}',1785953153,'web','0:0:0:0:0:0:0:1',NULL),(1674,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785953153,'web','0:0:0:0:0:0:0:1',NULL),(1675,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785953204,'web','0:0:0:0:0:0:0:1',NULL),(1676,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"22kb1o1217anr706uuf1jt86s7\"}',1785953209,'web','0:0:0:0:0:0:0:1',NULL),(1677,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785953209,'web','0:0:0:0:0:0:0:1',NULL),(1678,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785953228,'web','0:0:0:0:0:0:0:1',NULL),(1679,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785953228,'web','0:0:0:0:0:0:0:1',NULL),(1680,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785953231,'web','0:0:0:0:0:0:0:1',NULL),(1681,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785953234,'web','0:0:0:0:0:0:0:1',NULL),(1682,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',5,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_core:viewhub\",\"oldpermission\":0,\"permission\":1}',1785953431,'web','0:0:0:0:0:0:0:1',NULL),(1683,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',4,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_core:viewhub\",\"oldpermission\":0,\"permission\":1}',1785953432,'web','0:0:0:0:0:0:0:1',NULL),(1684,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',3,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_core:viewhub\",\"oldpermission\":0,\"permission\":1}',1785953432,'web','0:0:0:0:0:0:0:1',NULL),(1685,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_core:viewhub\",\"oldpermission\":0,\"permission\":1}',1785953432,'web','0:0:0:0:0:0:0:1',NULL),(1686,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_core:manage\",\"oldpermission\":0,\"permission\":1}',1785953432,'web','0:0:0:0:0:0:0:1',NULL),(1687,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785953466,'web','0:0:0:0:0:0:0:1',NULL),(1688,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785953494,'web','0:0:0:0:0:0:0:1',NULL),(1689,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785953497,'web','0:0:0:0:0:0:0:1',NULL),(1690,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785953499,'web','0:0:0:0:0:0:0:1',NULL),(1691,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785953501,'web','0:0:0:0:0:0:0:1',NULL),(1692,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785953504,'web','0:0:0:0:0:0:0:1',NULL),(1693,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785953509,'web','0:0:0:0:0:0:0:1',NULL),(1694,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"laaq45kg0hc689vm7s27uupip7\"}',1785953515,'web','0:0:0:0:0:0:0:1',NULL),(1695,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785953515,'web','0:0:0:0:0:0:0:1',NULL),(1696,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785953520,'web','0:0:0:0:0:0:0:1',NULL),(1697,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785953520,'web','0:0:0:0:0:0:0:1',NULL),(1698,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785953556,'web','0:0:0:0:0:0:0:1',NULL),(1699,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785953558,'web','0:0:0:0:0:0:0:1',NULL),(1700,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785953562,'web','0:0:0:0:0:0:0:1',NULL),(1701,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,2,13,NULL,0,'null',1785953907,'web','0:0:0:0:0:0:0:1',NULL),(1702,'\\core\\event\\user_profile_viewed','core','viewed','user_profile','user',2,'r',0,5,30,2,2,0,2,0,'null',1785953994,'web','0:0:0:0:0:0:0:1',NULL),(1703,'\\core\\event\\draft_file_added','core','added','draft_file','files',202,'c',0,5,30,2,2,0,2,0,'{\"itemid\":376699386,\"filename\":\"ChatGPT Image 5 ago 2026, 01_22_55 p.m..png\",\"filesize\":2096405,\"filepath\":\"\\/\",\"contenthash\":\"3708c77aaa4d3ae67f538cd3d6b8257e523c6738\",\"avscantime\":0.03593897819519043}',1785954194,'web','0:0:0:0:0:0:0:1',NULL),(1704,'\\core\\event\\user_updated','core','updated','user','user',2,'u',0,5,30,2,2,0,2,0,'null',1785954215,'web','0:0:0:0:0:0:0:1',NULL),(1705,'\\core\\event\\user_profile_viewed','core','viewed','user_profile','user',2,'r',0,5,30,2,2,0,2,0,'null',1785954215,'web','0:0:0:0:0:0:0:1',NULL),(1706,'\\core\\event\\draft_file_added','core','added','draft_file','files',211,'c',0,5,30,2,2,0,2,0,'{\"itemid\":735236180,\"filename\":\"local_miflora_portfolio_0.1.0-beta1.zip\",\"filesize\":16237,\"filepath\":\"\\/\",\"contenthash\":\"3d43fe10496e40f323a880c20bd130e2b80588ee\",\"avscantime\":0.03751802444458008}',1785955192,'web','0:0:0:0:0:0:0:1',NULL),(1707,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:reviewall\",\"oldpermission\":0,\"permission\":1}',1785955279,'web','0:0:0:0:0:0:0:1',NULL),(1708,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:manage\",\"oldpermission\":0,\"permission\":1}',1785955279,'web','0:0:0:0:0:0:0:1',NULL),(1709,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785955393,'web','0:0:0:0:0:0:0:1',NULL),(1710,'\\core\\event\\draft_file_added','core','added','draft_file','files',213,'c',0,5,30,2,2,0,2,0,'{\"itemid\":102217225,\"filename\":\"local_miflora_core_0.1.1-portfolio_integration.zip\",\"filesize\":7460,\"filepath\":\"\\/\",\"contenthash\":\"ac3b18e8db072016e5140fcf570eb2814c36371a\",\"avscantime\":0.005982160568237305}',1785955433,'web','0:0:0:0:0:0:0:1',NULL),(1711,'\\core\\event\\draft_file_added','core','added','draft_file','files',215,'c',0,5,30,2,2,0,2,0,'{\"itemid\":600127947,\"filename\":\"WhatsApp Image 2026-08-05 at 3.57.50 AM.jpeg\",\"filesize\":196831,\"filepath\":\"\\/\",\"contenthash\":\"ab3c28238d9c8747b98670a72893209683dfa541\",\"avscantime\":0.012044906616210938}',1785955611,'web','0:0:0:0:0:0:0:1',NULL),(1712,'\\core\\event\\draft_file_added','core','added','draft_file','files',218,'c',0,5,30,2,2,0,2,0,'{\"itemid\":301797999,\"filename\":\"plantilla_710.pdf\",\"filesize\":823494,\"filepath\":\"\\/\",\"contenthash\":\"9a51d68293da1d00a04d8c749948b57adfec23d2\",\"avscantime\":0.0005350112915039062}',1785955778,'web','0:0:0:0:0:0:0:1',NULL),(1713,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785956025,'web','0:0:0:0:0:0:0:1',NULL),(1714,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,2,1,NULL,0,'null',1785956026,'web','0:0:0:0:0:0:0:1',NULL),(1715,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785956035,'web','0:0:0:0:0:0:0:1',NULL),(1716,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785956373,'web','0:0:0:0:0:0:0:1',NULL),(1717,'\\core\\event\\draft_file_added','core','added','draft_file','files',224,'c',0,20,30,3,3,0,3,0,'{\"itemid\":10441271,\"filename\":\"WhatsApp Image 2026-08-05 at 3.57.50 AM (1).jpeg\",\"filesize\":180391,\"filepath\":\"\\/\",\"contenthash\":\"a697e307dd0539f07f0687fe17204d103348301f\",\"avscantime\":0.0020389556884765625}',1785956455,'web','0:0:0:0:0:0:0:1',NULL),(1718,'\\core\\event\\draft_file_added','core','added','draft_file','files',227,'c',0,20,30,3,3,0,3,0,'{\"itemid\":309150807,\"filename\":\"plantilla_710.pdf\",\"filesize\":823494,\"filepath\":\"\\/\",\"contenthash\":\"9a51d68293da1d00a04d8c749948b57adfec23d2\",\"avscantime\":0.0005309581756591797}',1785956464,'web','0:0:0:0:0:0:0:1',NULL),(1719,'\\core\\event\\draft_file_added','core','added','draft_file','files',233,'c',0,5,30,2,2,0,2,0,'{\"itemid\":683943780,\"filename\":\"local_miflora_portfolio_0.1.1-preview_media_hotfix.zip\",\"filesize\":18822,\"filepath\":\"\\/\",\"contenthash\":\"99c7960b58eab55fb969f3a3cf3c4dd2fc86fc2a\",\"avscantime\":0.0003910064697265625}',1785956699,'web','0:0:0:0:0:0:0:1',NULL),(1720,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785956785,'web','0:0:0:0:0:0:0:1',NULL),(1721,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785956788,'web','0:0:0:0:0:0:0:1',NULL),(1722,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,2,13,NULL,0,'null',1785956797,'web','0:0:0:0:0:0:0:1',NULL),(1723,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,5,30,2,2,0,2,0,'null',1785956804,'web','0:0:0:0:0:0:0:1',NULL),(1724,'\\core\\event\\draft_file_added','core','added','draft_file','files',239,'c',0,20,30,3,3,0,3,0,'{\"itemid\":2610453,\"filename\":\"patitofeo.pdf\",\"filesize\":3816881,\"filepath\":\"\\/\",\"contenthash\":\"2e4e23012b8943770dec9c5530fe3ebaa118a114\",\"avscantime\":0.005403041839599609}',1785957036,'web','0:0:0:0:0:0:0:1',NULL),(1725,'\\core\\event\\draft_file_added','core','added','draft_file','files',241,'c',0,20,30,3,3,0,3,0,'{\"itemid\":701640427,\"filename\":\"watermarked_img_11568773592298800954.jpg\",\"filesize\":144484,\"filepath\":\"\\/\",\"contenthash\":\"6f82f6988cb37aa3f823b8e4b75381a3884509bd\",\"avscantime\":0.0009708404541015625}',1785957261,'web','0:0:0:0:0:0:0:1',NULL),(1726,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"7gv1nkp30fre317gsg7iccck3d\"}',1785957900,'web','0:0:0:0:0:0:0:1',NULL),(1727,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785957900,'web','0:0:0:0:0:0:0:1',NULL),(1728,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785957905,'web','0:0:0:0:0:0:0:1',NULL),(1729,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785957905,'web','0:0:0:0:0:0:0:1',NULL),(1730,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785957943,'web','0:0:0:0:0:0:0:1',NULL),(1731,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785957945,'web','0:0:0:0:0:0:0:1',NULL),(1732,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785957946,'web','0:0:0:0:0:0:0:1',NULL),(1733,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785957949,'web','0:0:0:0:0:0:0:1',NULL),(1734,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785957951,'web','0:0:0:0:0:0:0:1',NULL),(1735,'\\core\\event\\section_viewed','core','viewed','section','course_sections',64,'r',2,41,50,13,3,13,NULL,0,'null',1785957957,'web','0:0:0:0:0:0:0:1',NULL),(1736,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785957964,'web','0:0:0:0:0:0:0:1',NULL),(1737,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785957983,'web','0:0:0:0:0:0:0:1',NULL),(1738,'\\core\\event\\section_viewed','core','viewed','section','course_sections',63,'r',2,41,50,13,3,13,NULL,0,'null',1785957997,'web','0:0:0:0:0:0:0:1',NULL),(1739,'\\core\\event\\section_viewed','core','viewed','section','course_sections',64,'r',2,41,50,13,3,13,NULL,0,'null',1785958001,'web','0:0:0:0:0:0:0:1',NULL),(1740,'\\core\\event\\section_viewed','core','viewed','section','course_sections',67,'r',2,41,50,13,3,13,NULL,0,'null',1785958002,'web','0:0:0:0:0:0:0:1',NULL),(1741,'\\core\\event\\section_viewed','core','viewed','section','course_sections',62,'r',2,41,50,13,3,13,NULL,0,'null',1785958010,'web','0:0:0:0:0:0:0:1',NULL),(1742,'\\core\\event\\section_viewed','core','viewed','section','course_sections',63,'r',2,41,50,13,3,13,NULL,0,'null',1785958012,'web','0:0:0:0:0:0:0:1',NULL),(1743,'\\mod_data\\event\\course_module_viewed','mod_data','viewed','course_module','data',1,'r',2,42,70,12,3,13,NULL,0,'null',1785958021,'web','0:0:0:0:0:0:0:1',NULL),(1744,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785958029,'web','0:0:0:0:0:0:0:1',NULL),(1745,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',13,'r',0,41,50,13,3,13,NULL,0,'{\"courseshortname\":\"PORTAFOLIO\",\"coursefullname\":\"Mi Portafolio Digital\"}',1785958030,'web','0:0:0:0:0:0:0:1',NULL),(1746,'\\gradereport_user\\event\\grade_report_viewed','gradereport_user','viewed','grade_report',NULL,NULL,'r',2,41,50,13,3,13,3,0,'null',1785958034,'web','0:0:0:0:0:0:0:1',NULL),(1747,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,3,1,NULL,0,'null',1785958035,'web','0:0:0:0:0:0:0:1',NULL),(1748,'\\core\\event\\dashboard_viewed','core','viewed','dashboard',NULL,NULL,'r',0,20,30,3,3,0,3,0,'null',1785958038,'web','0:0:0:0:0:0:0:1',NULL),(1749,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785958041,'web','0:0:0:0:0:0:0:1',NULL),(1750,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785958042,'web','0:0:0:0:0:0:0:1',NULL),(1751,'\\mod_data\\event\\course_module_viewed','mod_data','viewed','course_module','data',1,'r',2,42,70,12,3,13,NULL,0,'null',1785958045,'web','0:0:0:0:0:0:0:1',NULL),(1752,'\\core\\event\\section_viewed','core','viewed','section','course_sections',64,'r',2,41,50,13,3,13,NULL,0,'null',1785958050,'web','0:0:0:0:0:0:0:1',NULL),(1753,'\\core\\event\\section_viewed','core','viewed','section','course_sections',67,'r',2,41,50,13,3,13,NULL,0,'null',1785958051,'web','0:0:0:0:0:0:0:1',NULL),(1754,'\\core\\event\\section_viewed','core','viewed','section','course_sections',62,'r',2,41,50,13,3,13,NULL,0,'null',1785958053,'web','0:0:0:0:0:0:0:1',NULL),(1755,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785958054,'web','0:0:0:0:0:0:0:1',NULL),(1756,'\\core\\event\\draft_file_added','core','added','draft_file','files',248,'c',0,5,30,2,2,0,2,0,'{\"itemid\":91516053,\"filename\":\"local_miflora_core_0.1.2-home_redirect.zip\",\"filesize\":8504,\"filepath\":\"\\/\",\"contenthash\":\"74f5b7b699a6c2f530133771af79ac6f9171149a\",\"avscantime\":0.0005071163177490234}',1785958418,'web','0:0:0:0:0:0:0:1',NULL),(1757,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"cfrqqej5rs6d59f17ocrg12u12\"}',1785958509,'web','0:0:0:0:0:0:0:1',NULL),(1758,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785958509,'web','0:0:0:0:0:0:0:1',NULL),(1759,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785958518,'web','0:0:0:0:0:0:0:1',NULL),(1760,'\\core\\event\\user_profile_viewed','core','viewed','user_profile','user',3,'r',0,20,30,3,3,0,3,0,'null',1785958533,'web','0:0:0:0:0:0:0:1',NULL),(1761,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785958989,'web','0:0:0:0:0:0:0:1',NULL),(1762,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785959051,'web','0:0:0:0:0:0:0:1',NULL),(1763,'\\core\\event\\draft_file_added','core','added','draft_file','files',250,'c',0,5,30,2,2,0,2,0,'{\"itemid\":251806285,\"filename\":\"local_miflora_portfolio_0.2.0-history_teacher_controls.zip\",\"filesize\":22370,\"filepath\":\"\\/\",\"contenthash\":\"ff58dd76f8360a5d386245f2c9555ff685238b53\",\"avscantime\":0.005572080612182617}',1785960218,'web','0:0:0:0:0:0:0:1',NULL),(1764,'\\core\\event\\draft_file_added','core','added','draft_file','files',252,'c',0,5,30,2,2,0,2,0,'{\"itemid\":107693245,\"filename\":\"local_miflora_portfolio_0.2.1-upgrade_hotfix.zip\",\"filesize\":22770,\"filepath\":\"\\/\",\"contenthash\":\"b6f16f099e69c147a468557136e9801fd97be9b5\",\"avscantime\":0.005531787872314453}',1785960686,'web','0:0:0:0:0:0:0:1',NULL),(1765,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',4,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:reviewcourse\",\"oldpermission\":0,\"permission\":1}',1785960723,'web','0:0:0:0:0:0:0:1',NULL),(1766,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',3,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:reviewcourse\",\"oldpermission\":0,\"permission\":1}',1785960723,'web','0:0:0:0:0:0:0:1',NULL),(1767,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:reviewcourse\",\"oldpermission\":0,\"permission\":1}',1785960723,'web','0:0:0:0:0:0:0:1',NULL),(1768,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',4,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:deletecourse\",\"oldpermission\":0,\"permission\":1}',1785960723,'web','0:0:0:0:0:0:0:1',NULL),(1769,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',3,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:deletecourse\",\"oldpermission\":0,\"permission\":1}',1785960723,'web','0:0:0:0:0:0:0:1',NULL),(1770,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_portfolio:deletecourse\",\"oldpermission\":0,\"permission\":1}',1785960723,'web','0:0:0:0:0:0:0:1',NULL),(1771,'\\core\\event\\draft_file_added','core','added','draft_file','files',254,'c',0,5,30,2,2,0,2,0,'{\"itemid\":430194635,\"filename\":\"local_miflora_achievements_0.1.0.zip\",\"filesize\":6608,\"filepath\":\"\\/\",\"contenthash\":\"42a5cca8c3e9f59099c0fd11cdf338c94d250780\",\"avscantime\":0.004914045333862305}',1785960868,'web','0:0:0:0:0:0:0:1',NULL),(1772,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',4,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_achievements:awardcourse\",\"oldpermission\":0,\"permission\":1}',1785960933,'web','0:0:0:0:0:0:0:1',NULL),(1773,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',3,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_achievements:awardcourse\",\"oldpermission\":0,\"permission\":1}',1785960934,'web','0:0:0:0:0:0:0:1',NULL),(1774,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_achievements:awardcourse\",\"oldpermission\":0,\"permission\":1}',1785960934,'web','0:0:0:0:0:0:0:1',NULL),(1775,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_achievements:manageall\",\"oldpermission\":0,\"permission\":1}',1785960934,'web','0:0:0:0:0:0:0:1',NULL),(1776,'\\core\\event\\draft_file_added','core','added','draft_file','files',256,'c',0,5,30,2,2,0,2,0,'{\"itemid\":435543388,\"filename\":\"local_miflora_core_0.2.0-icons_history_achievements.zip\",\"filesize\":8717,\"filepath\":\"\\/\",\"contenthash\":\"448ef97ec2aab6093281041b7522b1342310daf9\",\"avscantime\":0.0056879520416259766}',1785961026,'web','0:0:0:0:0:0:0:1',NULL),(1777,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785961409,'web','0:0:0:0:0:0:0:1',NULL),(1778,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785961418,'web','0:0:0:0:0:0:0:1',NULL),(1779,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',2,'r',0,21,50,2,2,2,NULL,0,'{\"courseshortname\":\"COM-2026\",\"coursefullname\":\"Comunicaci\\u00f3n\"}',1785961421,'web','0:0:0:0:0:0:0:1',NULL),(1780,'\\core\\event\\user_enrolment_created','core','created','user_enrolment','user_enrolments',14,'c',0,21,50,2,2,2,3,0,'{\"enrol\":\"manual\"}',1785961432,'web','0:0:0:0:0:0:0:1',NULL),(1781,'\\core\\event\\email_failed','core','failed','email',NULL,NULL,'c',0,1,10,0,2,0,3,0,'{\"subject\":\"Bienvenido\\/a a Comunicaci\\u00f3n\",\"message\":\"Hola, Angel Manuel Aliaga Arevalo. Se le ha matriculado en el curso\\nComunicaci\\u00f3n.\",\"errorinfo\":\"Could not instantiate mail function.\"}',1785961436,'web','0:0:0:0:0:0:0:1',NULL),(1782,'\\core\\event\\role_assigned','core','assigned','role','role',5,'c',0,21,50,2,2,2,3,0,'{\"id\":14,\"component\":\"\",\"itemid\":0}',1785961436,'web','0:0:0:0:0:0:0:1',NULL),(1783,'\\core\\event\\draft_file_added','core','added','draft_file','files',258,'c',0,20,30,3,3,0,3,0,'{\"itemid\":314248644,\"filename\":\"watermarked_img_12500017812886286815.jpg\",\"filesize\":168013,\"filepath\":\"\\/\",\"contenthash\":\"3f854fe84bae16b602890c7213c4597a84c1f980\",\"avscantime\":0.006062984466552734}',1785961576,'web','0:0:0:0:0:0:0:1',NULL),(1784,'\\core\\event\\draft_file_added','core','added','draft_file','files',261,'c',0,20,30,3,3,0,3,0,'{\"itemid\":650478692,\"filename\":\"plantilla_710.pdf\",\"filesize\":823494,\"filepath\":\"\\/\",\"contenthash\":\"9a51d68293da1d00a04d8c749948b57adfec23d2\",\"avscantime\":0.00047206878662109375}',1785961595,'web','0:0:0:0:0:0:0:1',NULL),(1785,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',261,'d',0,20,30,3,3,0,3,0,'{\"itemid\":\"650478692\",\"filename\":\"plantilla_710.pdf\",\"filesize\":\"823494\",\"filepath\":\"\\/\",\"contenthash\":\"9a51d68293da1d00a04d8c749948b57adfec23d2\"}',1785961632,'web','0:0:0:0:0:0:0:1',NULL),(1786,'\\core\\event\\draft_file_added','core','added','draft_file','files',263,'c',0,20,30,3,3,0,3,0,'{\"itemid\":650478692,\"filename\":\"9788491425250_FR.pdf\",\"filesize\":453175,\"filepath\":\"\\/\",\"contenthash\":\"50ddd19cc8206f52e8d540ae2a0a90a0bd04ca6a\",\"avscantime\":0.0003719329833984375}',1785961638,'web','0:0:0:0:0:0:0:1',NULL),(1787,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,3,2,NULL,0,'null',1785962095,'web','0:0:0:0:0:0:0:1',NULL),(1788,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',2,'r',0,21,50,2,3,2,NULL,0,'{\"courseshortname\":\"COM-2026\",\"coursefullname\":\"Comunicaci\\u00f3n\"}',1785962100,'web','0:0:0:0:0:0:0:1',NULL),(1789,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785962112,'web','0:0:0:0:0:0:0:1',NULL),(1790,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',2,'r',0,21,50,2,2,2,NULL,0,'{\"courseshortname\":\"COM-2026\",\"coursefullname\":\"Comunicaci\\u00f3n\"}',1785962123,'web','0:0:0:0:0:0:0:1',NULL),(1791,'\\core\\event\\grade_item_created','core','created','grade_item','grade_items',2,'c',0,21,50,2,2,2,NULL,0,'{\"itemname\":null,\"itemtype\":\"course\",\"itemmodule\":null}',1785962128,'web','0:0:0:0:0:0:0:1',NULL),(1792,'\\core\\event\\grade_item_updated','core','updated','grade_item','grade_items',2,'u',0,21,50,2,2,2,NULL,0,'{\"itemname\":null,\"itemtype\":\"course\",\"itemmodule\":null}',1785962128,'web','0:0:0:0:0:0:0:1',NULL),(1793,'\\gradereport_grader\\event\\grade_report_viewed','gradereport_grader','viewed','grade_report',NULL,NULL,'r',1,21,50,2,2,2,NULL,0,'null',1785962129,'web','0:0:0:0:0:0:0:1',NULL),(1794,'\\core\\event\\course_overview_viewed','core','viewed','course_overview',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785962131,'web','0:0:0:0:0:0:0:1',NULL),(1795,'\\core\\event\\badge_listing_viewed','core','viewed','badge_listing',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'{\"badgetype\":2,\"courseid\":\"2\"}',1785962140,'web','0:0:0:0:0:0:0:1',NULL),(1796,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785962145,'web','0:0:0:0:0:0:0:1',NULL),(1797,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',2,'r',0,21,50,2,2,2,NULL,0,'{\"courseshortname\":\"COM-2026\",\"coursefullname\":\"Comunicaci\\u00f3n\"}',1785962154,'web','0:0:0:0:0:0:0:1',NULL),(1798,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785962160,'web','0:0:0:0:0:0:0:1',NULL),(1799,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',2,'r',0,21,50,2,2,2,NULL,0,'{\"courseshortname\":\"COM-2026\",\"coursefullname\":\"Comunicaci\\u00f3n\"}',1785962166,'web','0:0:0:0:0:0:0:1',NULL),(1800,'\\gradereport_grader\\event\\grade_report_viewed','gradereport_grader','viewed','grade_report',NULL,NULL,'r',1,21,50,2,2,2,NULL,0,'null',1785962171,'web','0:0:0:0:0:0:0:1',NULL),(1801,'\\core\\event\\course_overview_viewed','core','viewed','course_overview',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785962173,'web','0:0:0:0:0:0:0:1',NULL),(1802,'\\core\\event\\badge_listing_viewed','core','viewed','badge_listing',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'{\"badgetype\":2,\"courseid\":\"2\"}',1785962209,'web','0:0:0:0:0:0:0:1',NULL),(1803,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785962230,'web','0:0:0:0:0:0:0:1',NULL),(1804,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,3,2,NULL,0,'null',1785962258,'web','0:0:0:0:0:0:0:1',NULL),(1805,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,3,2,NULL,0,'null',1785962263,'web','0:0:0:0:0:0:0:1',NULL),(1806,'\\core\\event\\draft_file_added','core','added','draft_file','files',268,'c',0,5,30,2,2,0,2,0,'{\"itemid\":80928237,\"filename\":\"local_miflora_achievements_0.2.0-review_integration.zip\",\"filesize\":7092,\"filepath\":\"\\/\",\"contenthash\":\"a23dd25bc46c659050c968a2ac697bfe82a8e1aa\",\"avscantime\":0.0005550384521484375}',1785965377,'web','0:0:0:0:0:0:0:1',NULL),(1807,'\\core\\event\\draft_file_added','core','added','draft_file','files',270,'c',0,5,30,2,2,0,2,0,'{\"itemid\":106390733,\"filename\":\"local_miflora_portfolio_0.3.0-feedback_badges_autorouting.zip\",\"filesize\":25607,\"filepath\":\"\\/\",\"contenthash\":\"c0fa1b0d14038547c81c8b69a61d64e4546133ef\",\"avscantime\":0.01614093780517578}',1785965518,'web','0:0:0:0:0:0:0:1',NULL),(1808,'\\core\\event\\draft_file_added','core','added','draft_file','files',272,'c',0,5,30,2,2,0,2,0,'{\"itemid\":610974700,\"filename\":\"local_miflora_core_0.3.0-teacher_review_access.zip\",\"filesize\":9026,\"filepath\":\"\\/\",\"contenthash\":\"c52f2fe40442897e7789e97918dac6eff64d73fc\",\"avscantime\":0.005697965621948242}',1785965756,'web','0:0:0:0:0:0:0:1',NULL),(1809,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,3,2,NULL,0,'null',1785966032,'web','0:0:0:0:0:0:0:1',NULL),(1810,'\\core\\event\\draft_file_added','core','added','draft_file','files',274,'c',0,20,30,3,3,0,3,0,'{\"itemid\":94079728,\"filename\":\"WhatsApp Image 2026-08-05 at 3.57.50 AM.jpeg\",\"filesize\":196831,\"filepath\":\"\\/\",\"contenthash\":\"ab3c28238d9c8747b98670a72893209683dfa541\",\"avscantime\":0.00527191162109375}',1785966099,'web','0:0:0:0:0:0:0:1',NULL),(1811,'\\core\\event\\draft_file_added','core','added','draft_file','files',277,'c',0,20,30,3,3,0,3,0,'{\"itemid\":872072551,\"filename\":\"9788491425250_FR.pdf\",\"filesize\":453175,\"filepath\":\"\\/\",\"contenthash\":\"50ddd19cc8206f52e8d540ae2a0a90a0bd04ca6a\",\"avscantime\":0.0006148815155029297}',1785966106,'web','0:0:0:0:0:0:0:1',NULL),(1812,'\\core\\event\\draft_file_added','core','added','draft_file','files',283,'c',0,5,30,2,2,0,2,0,'{\"itemid\":350016450,\"filename\":\"local_miflora_achievements_0.3.0-custom_badges.zip\",\"filesize\":11638,\"filepath\":\"\\/\",\"contenthash\":\"6464e03ac96611f02a7096eaa10db0f1ec8f289b\",\"avscantime\":0.0003440380096435547}',1785968771,'web','0:0:0:0:0:0:0:1',NULL),(1813,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_achievements:managebadges\",\"oldpermission\":0,\"permission\":1}',1785968833,'web','0:0:0:0:0:0:0:1',NULL),(1814,'\\core\\event\\draft_file_added','core','added','draft_file','files',285,'c',0,5,30,2,2,0,2,0,'{\"itemid\":74771057,\"filename\":\"local_miflora_portfolio_0.3.1-custom_badge_selector.zip\",\"filesize\":25799,\"filepath\":\"\\/\",\"contenthash\":\"87ba7075dbf342c5c06a9e1f79d5a6615b7d068f\",\"avscantime\":0.004842042922973633}',1785968914,'web','0:0:0:0:0:0:0:1',NULL),(1815,'\\core\\event\\draft_file_added','core','added','draft_file','files',287,'c',0,5,30,2,2,0,2,0,'{\"itemid\":318826854,\"filename\":\"1 puntualidad.png\",\"filesize\":32470,\"filepath\":\"\\/\",\"contenthash\":\"96161565e6d7bcbc0e20bc9b274d77fb04025fed\",\"avscantime\":0.0070459842681884766}',1785970217,'web','0:0:0:0:0:0:0:1',NULL),(1816,'\\core\\event\\draft_file_added','core','added','draft_file','files',292,'c',0,5,30,2,2,0,2,0,'{\"itemid\":336588124,\"filename\":\"2. orden.png\",\"filesize\":26007,\"filepath\":\"\\/\",\"contenthash\":\"d2d7a7fb75906f1161ab8af4f0ff11687701d304\",\"avscantime\":0.0004630088806152344}',1785970247,'web','0:0:0:0:0:0:0:1',NULL),(1817,'\\core\\event\\draft_file_added','core','added','draft_file','files',297,'c',0,5,30,2,2,0,2,0,'{\"itemid\":877573795,\"filename\":\"3 creatividad.png\",\"filesize\":33176,\"filepath\":\"\\/\",\"contenthash\":\"b0eea40db3f9d7ac4e3846689b644f9ddf77a6b0\",\"avscantime\":0.00031185150146484375}',1785970273,'web','0:0:0:0:0:0:0:1',NULL),(1818,'\\core\\event\\draft_file_added','core','added','draft_file','files',302,'c',0,5,30,2,2,0,2,0,'{\"itemid\":768564818,\"filename\":\"4 esfuerzo.png\",\"filesize\":31468,\"filepath\":\"\\/\",\"contenthash\":\"d5ff5ba7828b6c8f26260423d55a91aa5edbc2fa\",\"avscantime\":0.0003230571746826172}',1785970292,'web','0:0:0:0:0:0:0:1',NULL),(1819,'\\core\\event\\draft_file_added','core','added','draft_file','files',307,'c',0,5,30,2,2,0,2,0,'{\"itemid\":414740123,\"filename\":\"5 sobresaliente.png\",\"filesize\":35464,\"filepath\":\"\\/\",\"contenthash\":\"ff86329255b1f9219e638806fa6829433525f544\",\"avscantime\":0.0003209114074707031}',1785970315,'web','0:0:0:0:0:0:0:1',NULL),(1820,'\\core\\event\\draft_file_added','core','added','draft_file','files',312,'c',0,5,30,2,2,0,2,0,'{\"itemid\":591358405,\"filename\":\"6 apoyo.png\",\"filesize\":29444,\"filepath\":\"\\/\",\"contenthash\":\"8141e87bf5a87fe49f1639d96b1c65a48a556e73\",\"avscantime\":0.0004589557647705078}',1785970331,'web','0:0:0:0:0:0:0:1',NULL),(1821,'\\core\\event\\draft_file_added','core','added','draft_file','files',319,'c',0,5,30,2,2,0,2,0,'{\"itemid\":599792634,\"filename\":\"7 ingenio.png\",\"filesize\":32234,\"filepath\":\"\\/\",\"contenthash\":\"e99c0ba95faa370c9333ed2f35476d0a70af09fe\",\"avscantime\":0.0004057884216308594}',1785970373,'web','0:0:0:0:0:0:0:1',NULL),(1822,'\\core\\event\\draft_file_added','core','added','draft_file','files',324,'c',0,5,30,2,2,0,2,0,'{\"itemid\":513011999,\"filename\":\"8 responsabilidad.png\",\"filesize\":33985,\"filepath\":\"\\/\",\"contenthash\":\"0f11730433dc1693dba83470dcd100e1a1da0883\",\"avscantime\":0.00033211708068847656}',1785970393,'web','0:0:0:0:0:0:0:1',NULL),(1823,'\\core\\event\\draft_file_added','core','added','draft_file','files',329,'c',0,5,30,2,2,0,2,0,'{\"itemid\":850332953,\"filename\":\"9 buen lector.png\",\"filesize\":29980,\"filepath\":\"\\/\",\"contenthash\":\"3cfbe4b8259e04dff99ca80158a85b02e9ab2e34\",\"avscantime\":0.00030517578125}',1785970416,'web','0:0:0:0:0:0:0:1',NULL),(1824,'\\core\\event\\draft_file_added','core','added','draft_file','files',338,'c',0,5,30,2,2,0,2,0,'{\"itemid\":926286329,\"filename\":\"10 investigador.png\",\"filesize\":31331,\"filepath\":\"\\/\",\"contenthash\":\"e5f1ee13fece7b635f54b27656ac6221018d8b32\",\"avscantime\":0.0003540515899658203}',1785970442,'web','0:0:0:0:0:0:0:1',NULL),(1825,'\\core\\event\\draft_file_added','core','added','draft_file','files',343,'c',0,5,30,2,2,0,2,0,'{\"itemid\":947622653,\"filename\":\"11 solidaridad.png\",\"filesize\":31572,\"filepath\":\"\\/\",\"contenthash\":\"fe78ff4553a67cb32774bb097a410faa1dd22aec\",\"avscantime\":0.0005059242248535156}',1785970459,'web','0:0:0:0:0:0:0:1',NULL),(1826,'\\core\\event\\draft_file_added','core','added','draft_file','files',348,'c',0,5,30,2,2,0,2,0,'{\"itemid\":222923168,\"filename\":\"12 liderazgo.png\",\"filesize\":37395,\"filepath\":\"\\/\",\"contenthash\":\"5935795e8885935b948aad3619db6cb8524f37f8\",\"avscantime\":0.00032210350036621094}',1785970474,'web','0:0:0:0:0:0:0:1',NULL),(1827,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785971002,'web','0:0:0:0:0:0:0:1',NULL),(1828,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785971009,'web','0:0:0:0:0:0:0:1',NULL),(1829,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,3,2,NULL,0,'null',1785971019,'web','0:0:0:0:0:0:0:1',NULL),(1830,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785971050,'web','0:0:0:0:0:0:0:1',NULL),(1831,'\\core\\event\\user_list_viewed','core','viewed','user_list','course',2,'r',0,21,50,2,2,2,NULL,0,'{\"courseshortname\":\"COM-2026\",\"coursefullname\":\"Comunicaci\\u00f3n\"}',1785971072,'web','0:0:0:0:0:0:0:1',NULL),(1832,'\\core\\event\\role_unassigned','core','unassigned','role','role',5,'d',0,21,50,2,2,2,3,0,'{\"id\":\"14\",\"component\":\"\",\"itemid\":\"0\"}',1785971077,'web','0:0:0:0:0:0:0:1',NULL),(1833,'\\core\\event\\user_enrolment_deleted','core','deleted','user_enrolment','user_enrolments',14,'d',0,21,50,2,2,2,3,0,'{\"userenrolment\":{\"id\":\"14\",\"status\":\"0\",\"enrolid\":\"1\",\"userid\":\"3\",\"timestart\":\"1785961399\",\"timeend\":\"0\",\"modifierid\":\"2\",\"timecreated\":\"1785961432\",\"timemodified\":\"1785961432\",\"courseid\":\"2\",\"enrol\":\"manual\",\"lastenrol\":true},\"enrol\":\"manual\"}',1785971077,'web','0:0:0:0:0:0:0:1',NULL),(1834,'\\core\\event\\course_overview_viewed','core','viewed','course_overview',NULL,NULL,'r',2,21,50,2,2,2,NULL,0,'null',1785971156,'web','0:0:0:0:0:0:0:1',NULL),(1835,'\\core\\event\\draft_file_added','core','added','draft_file','files',353,'c',0,5,30,2,2,0,2,0,'{\"itemid\":856319985,\"filename\":\"local_miflora_appearance_0.1.0.zip\",\"filesize\":8746,\"filepath\":\"\\/\",\"contenthash\":\"909d55752ece23ab414790a90e1fdc5d68eb1897\",\"avscantime\":0.0003540515899658203}',1785971180,'web','0:0:0:0:0:0:0:1',NULL),(1836,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',1,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_appearance:manage\",\"oldpermission\":0,\"permission\":1}',1785971235,'web','0:0:0:0:0:0:0:1',NULL),(1837,'\\core\\event\\draft_file_added','core','added','draft_file','files',355,'c',0,5,30,2,2,0,2,0,'{\"itemid\":941180612,\"filename\":\"local_miflora_core_0.4.0-appearance_integration.zip\",\"filesize\":9524,\"filepath\":\"\\/\",\"contenthash\":\"d06830894a4966597beef1b3ab067d9375e998ea\",\"avscantime\":0.0047321319580078125}',1785971398,'web','0:0:0:0:0:0:0:1',NULL),(1838,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785971701,'web','0:0:0:0:0:0:0:1',NULL),(1839,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,2,13,NULL,0,'null',1785971710,'web','0:0:0:0:0:0:0:1',NULL),(1840,'\\core\\event\\section_viewed','core','viewed','section','course_sections',64,'r',2,41,50,13,2,13,NULL,0,'null',1785971713,'web','0:0:0:0:0:0:0:1',NULL),(1841,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785971732,'web','0:0:0:0:0:0:0:1',NULL),(1842,'\\core\\event\\draft_file_added','core','added','draft_file','files',367,'c',0,5,30,2,2,0,2,0,'{\"itemid\":640424792,\"filename\":\"ChatGPT Image 5 ago 2026, 06_22_21 p.m..png\",\"filesize\":1270204,\"filepath\":\"\\/\",\"contenthash\":\"3d39cbe6db381094936b6e7047f64225b0e85e8e\",\"avscantime\":0.0059490203857421875}',1785972150,'web','0:0:0:0:0:0:0:1',NULL),(1843,'\\core\\event\\draft_file_added','core','added','draft_file','files',372,'c',0,5,30,2,2,0,2,0,'{\"itemid\":521142880,\"filename\":\"ChatGPT Image 5 ago 2026, 06_26_19 p.m..png\",\"filesize\":1407645,\"filepath\":\"\\/\",\"contenthash\":\"eb92af2acc05f8891fb08c9b9925fbda8e7f935e\",\"avscantime\":0.00044798851013183594}',1785972389,'web','0:0:0:0:0:0:0:1',NULL),(1844,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',377,'d',0,5,30,2,2,0,2,0,'{\"itemid\":\"541592789\",\"filename\":\"ChatGPT Image 5 ago 2026, 06_22_21 p.m..png\",\"filesize\":\"1270204\",\"filepath\":\"\\/\",\"contenthash\":\"3d39cbe6db381094936b6e7047f64225b0e85e8e\"}',1785973095,'web','0:0:0:0:0:0:0:1',NULL),(1845,'\\core\\event\\draft_file_added','core','added','draft_file','files',380,'c',0,5,30,2,2,0,2,0,'{\"itemid\":541592789,\"filename\":\"ChatGPT Image 5 ago 2026, 06_32_58 p.m..png\",\"filesize\":1397483,\"filepath\":\"\\/\",\"contenthash\":\"fa6fc11115323e4af88e2168b4a1c0ccffbc7058\",\"avscantime\":0.0003428459167480469}',1785973107,'web','0:0:0:0:0:0:0:1',NULL),(1846,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',383,'d',0,5,30,2,2,0,2,0,'{\"itemid\":\"342816985\",\"filename\":\"ChatGPT Image 5 ago 2026, 06_26_19 p.m..png\",\"filesize\":\"1407645\",\"filepath\":\"\\/\",\"contenthash\":\"eb92af2acc05f8891fb08c9b9925fbda8e7f935e\"}',1785973118,'web','0:0:0:0:0:0:0:1',NULL),(1847,'\\core\\event\\draft_file_added','core','added','draft_file','files',386,'c',0,5,30,2,2,0,2,0,'{\"itemid\":342816985,\"filename\":\"ChatGPT Image 5 ago 2026, 06_36_56 p.m..png\",\"filesize\":1253722,\"filepath\":\"\\/\",\"contenthash\":\"62627e11cfe61d9f971cda40f387f0f9eee196ca\",\"avscantime\":0.0003418922424316406}',1785973124,'web','0:0:0:0:0:0:0:1',NULL),(1848,'\\core\\event\\draft_file_added','core','added','draft_file','files',389,'c',0,5,30,2,2,0,2,0,'{\"itemid\":827602345,\"filename\":\"ChatGPT Image 5 ago 2026, 06_41_27 p.m..png\",\"filesize\":1340695,\"filepath\":\"\\/\",\"contenthash\":\"e861299c9f64962d2c709c9c6602a3b53fe0fe6c\",\"avscantime\":0.0003979206085205078}',1785973302,'web','0:0:0:0:0:0:0:1',NULL),(1849,'\\core\\event\\draft_file_added','core','added','draft_file','files',394,'c',0,5,30,2,2,0,2,0,'{\"itemid\":123059123,\"filename\":\"ChatGPT Image 5 ago 2026, 06_45_07 p.m..png\",\"filesize\":1369061,\"filepath\":\"\\/\",\"contenthash\":\"7945779994ba7424e1f71c749392cefa8274d653\",\"avscantime\":0.0003199577331542969}',1785973558,'web','0:0:0:0:0:0:0:1',NULL),(1850,'\\core\\event\\draft_file_added','core','added','draft_file','files',401,'c',0,5,30,2,2,0,2,0,'{\"itemid\":965937372,\"filename\":\"ChatGPT Image 5 ago 2026, 06_53_31 p.m..png\",\"filesize\":1636717,\"filepath\":\"\\/\",\"contenthash\":\"cb3a8b7d7b788dc949450d2d7ba7f1044b3de7a3\",\"avscantime\":0.00033593177795410156}',1785974063,'web','0:0:0:0:0:0:0:1',NULL),(1851,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',406,'d',0,5,30,2,2,0,2,0,'{\"itemid\":\"627088108\",\"filename\":\"ChatGPT Image 5 ago 2026, 06_53_31 p.m..png\",\"filesize\":\"1636717\",\"filepath\":\"\\/\",\"contenthash\":\"cb3a8b7d7b788dc949450d2d7ba7f1044b3de7a3\"}',1785974857,'web','0:0:0:0:0:0:0:1',NULL),(1852,'\\core\\event\\draft_file_added','core','added','draft_file','files',410,'c',0,5,30,2,2,0,2,0,'{\"itemid\":336413518,\"filename\":\"local_miflora_core_0.4.1-card_background_hotfix.zip\",\"filesize\":9848,\"filepath\":\"\\/\",\"contenthash\":\"2fb1c1e8e51144c352d9584179edb9f22fa2c3b6\",\"avscantime\":0.005570173263549805}',1785975188,'web','0:0:0:0:0:0:0:1',NULL),(1853,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785975747,'web','0:0:0:0:0:0:0:1',NULL),(1854,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"rmcba9hf85lcvairkeig5mkeh6\"}',1785975766,'web','0:0:0:0:0:0:0:1',NULL),(1855,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785975766,'web','0:0:0:0:0:0:0:1',NULL),(1856,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785975778,'web','0:0:0:0:0:0:0:1',NULL),(1857,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785975803,'web','0:0:0:0:0:0:0:1',NULL),(1858,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785975809,'web','0:0:0:0:0:0:0:1',NULL),(1859,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785975822,'web','0:0:0:0:0:0:0:1',NULL),(1860,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785975825,'web','0:0:0:0:0:0:0:1',NULL),(1861,'\\core\\event\\draft_file_added','core','added','draft_file','files',423,'c',0,5,30,2,2,0,2,0,'{\"itemid\":69033192,\"filename\":\"theme_miflora_3.3.1-beta6_dashboard_hero_controls.zip\",\"filesize\":37420,\"filepath\":\"\\/\",\"contenthash\":\"bd0b68afdc7bef2a6994ff5f1fb4a2a0adb51941\",\"avscantime\":0.017583847045898438}',1785975969,'web','0:0:0:0:0:0:0:1',NULL),(1862,'\\core\\event\\config_log_created','core','created','config_log','config_log',1852,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"dashboardherovisible\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785976060,'web','0:0:0:0:0:0:0:1',NULL),(1863,'\\core\\event\\config_log_created','core','created','config_log','config_log',1853,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"dashboardherooverlay\",\"oldvalue\":null,\"value\":\"55\",\"plugin\":\"theme_miflora\"}',1785976060,'web','0:0:0:0:0:0:0:1',NULL),(1864,'\\core\\event\\config_log_created','core','created','config_log','config_log',1854,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"dashboardheroposition\",\"oldvalue\":null,\"value\":\"center\",\"plugin\":\"theme_miflora\"}',1785976060,'web','0:0:0:0:0:0:0:1',NULL),(1865,'\\core\\event\\config_log_created','core','created','config_log','config_log',1855,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"dashboardheroheight\",\"oldvalue\":null,\"value\":\"180\",\"plugin\":\"theme_miflora\"}',1785976060,'web','0:0:0:0:0:0:0:1',NULL),(1866,'\\core\\event\\config_log_created','core','created','config_log','config_log',1856,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"dashboardherotextcolour\",\"oldvalue\":null,\"value\":\"#FFFFFF\",\"plugin\":\"theme_miflora\"}',1785976060,'web','0:0:0:0:0:0:0:1',NULL),(1867,'\\core\\event\\draft_file_added','core','added','draft_file','files',425,'c',0,5,30,2,2,0,2,0,'{\"itemid\":820925556,\"filename\":\"local_miflora_core_0.5.0-theme_dashboard_hero.zip\",\"filesize\":10806,\"filepath\":\"\\/\",\"contenthash\":\"44a81f2b8691d6ac6f3d72c3028cbd86f72ec4ba\",\"avscantime\":0.005410194396972656}',1785976118,'web','0:0:0:0:0:0:0:1',NULL),(1868,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,41,50,13,3,13,NULL,0,'null',1785976198,'web','0:0:0:0:0:0:0:1',NULL),(1869,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',439,'d',0,5,30,2,2,0,2,0,'{\"itemid\":\"510469322\",\"filename\":\"ChatGPT Image 5 ago 2026, 03_46_45 a.m..png\",\"filesize\":\"2332656\",\"filepath\":\"\\/\",\"contenthash\":\"19181a792b6794e4e24df78b45f7b211ee50dcdd\"}',1785976330,'web','0:0:0:0:0:0:0:1',NULL),(1870,'\\core\\event\\draft_file_added','core','added','draft_file','files',447,'c',0,5,30,2,2,0,2,0,'{\"itemid\":510469322,\"filename\":\"logon.png\",\"filesize\":968756,\"filepath\":\"\\/\",\"contenthash\":\"41c80a4947f38b668565961d49db4f95625e9465\",\"avscantime\":0.0013439655303955078}',1785976336,'web','0:0:0:0:0:0:0:1',NULL),(1871,'\\core\\event\\config_log_created','core','created','config_log','config_log',1857,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"loginlogo\",\"oldvalue\":\"\\/ChatGPT Image 5 ago 2026, 03_46_45 a.m..png\",\"value\":\"\\/logon.png\",\"plugin\":\"theme_miflora\"}',1785976342,'web','0:0:0:0:0:0:0:1',NULL),(1872,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',450,'d',0,5,30,2,2,0,2,0,'{\"itemid\":\"414697154\",\"filename\":\"ChatGPT Image 5 ago 2026, 03_46_45 a.m..png\",\"filesize\":\"2332656\",\"filepath\":\"\\/\",\"contenthash\":\"19181a792b6794e4e24df78b45f7b211ee50dcdd\"}',1785976349,'web','0:0:0:0:0:0:0:1',NULL),(1873,'\\core\\event\\draft_file_added','core','added','draft_file','files',460,'c',0,5,30,2,2,0,2,0,'{\"itemid\":414697154,\"filename\":\"logon.png\",\"filesize\":968756,\"filepath\":\"\\/\",\"contenthash\":\"41c80a4947f38b668565961d49db4f95625e9465\",\"avscantime\":0.0006840229034423828}',1785976355,'web','0:0:0:0:0:0:0:1',NULL),(1874,'\\core\\event\\config_log_created','core','created','config_log','config_log',1858,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"logo\",\"oldvalue\":\"\\/ChatGPT Image 5 ago 2026, 03_46_45 a.m..png\",\"value\":\"\\/logon.png\",\"plugin\":\"theme_miflora\"}',1785976357,'web','0:0:0:0:0:0:0:1',NULL),(1875,'\\core\\event\\draft_file_deleted','core','deleted','draft_file','files',468,'d',0,5,30,2,2,0,2,0,'{\"itemid\":\"302954548\",\"filename\":\"ChatGPT Image 5 ago 2026, 03_46_45 a.m..png\",\"filesize\":\"2332656\",\"filepath\":\"\\/\",\"contenthash\":\"19181a792b6794e4e24df78b45f7b211ee50dcdd\"}',1785976371,'web','0:0:0:0:0:0:0:1',NULL),(1876,'\\core\\event\\draft_file_added','core','added','draft_file','files',472,'c',0,5,30,2,2,0,2,0,'{\"itemid\":302954548,\"filename\":\"logon.png\",\"filesize\":968756,\"filepath\":\"\\/\",\"contenthash\":\"41c80a4947f38b668565961d49db4f95625e9465\",\"avscantime\":0.0004210472106933594}',1785976376,'web','0:0:0:0:0:0:0:1',NULL),(1877,'\\core\\event\\config_log_created','core','created','config_log','config_log',1859,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"footerlogo\",\"oldvalue\":\"\\/ChatGPT Image 5 ago 2026, 03_46_45 a.m..png\",\"value\":\"\\/logon.png\",\"plugin\":\"theme_miflora\"}',1785976380,'web','0:0:0:0:0:0:0:1',NULL),(1878,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"brfaiigespgvj4ootnq7dqgv1m\"}',1785976415,'web','0:0:0:0:0:0:0:1',NULL),(1879,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785976415,'web','0:0:0:0:0:0:0:1',NULL),(1880,'\\core\\event\\user_loggedin','core','loggedin','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"username\":\"admin\",\"extrauserinfo\":[]}',1785976481,'web','0:0:0:0:0:0:0:1',NULL),(1881,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"f7no9fac48nfdvbrg0ad8bb911\"}',1785976491,'web','0:0:0:0:0:0:0:1',NULL),(1882,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785976491,'web','0:0:0:0:0:0:0:1',NULL),(1883,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785976497,'web','0:0:0:0:0:0:0:1',NULL),(1884,'\\core\\event\\draft_file_added','core','added','draft_file','files',484,'c',0,5,30,2,2,0,2,0,'{\"itemid\":942280776,\"filename\":\"theme_miflora_3.3.2-beta7-unified_header_navigation.zip\",\"filesize\":38189,\"filepath\":\"\\/\",\"contenthash\":\"a9f1e45b22ad2b338b8f1bacc2bbe63b91aae1f2\",\"avscantime\":0.0050220489501953125}',1785976963,'web','0:0:0:0:0:0:0:1',NULL),(1885,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"r40gqp1pje9gt293inupl0mvrc\"}',1785977234,'web','0:0:0:0:0:0:0:1',NULL),(1886,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785977234,'web','0:0:0:0:0:0:0:1',NULL),(1887,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785977406,'web','0:0:0:0:0:0:0:1',NULL),(1888,'\\core\\event\\draft_file_added','core','added','draft_file','files',486,'c',0,5,30,2,2,0,2,0,'{\"itemid\":34523418,\"filename\":\"theme_miflora_3.3.3-beta8-brand_text_header.zip\",\"filesize\":38486,\"filepath\":\"\\/\",\"contenthash\":\"e2659c8be81176d031fb608ab77c61c42a6e820d\",\"avscantime\":0.0077741146087646484}',1785977579,'web','0:0:0:0:0:0:0:1',NULL),(1889,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"n9rr2lk1j7o2a1qg9sde9shipd\"}',1785977660,'web','0:0:0:0:0:0:0:1',NULL),(1890,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785977660,'web','0:0:0:0:0:0:0:1',NULL),(1891,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785977692,'web','0:0:0:0:0:0:0:1',NULL),(1892,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"f89t5dtddmesc41p0ib1m14boc\"}',1785977706,'web','0:0:0:0:0:0:0:1',NULL),(1893,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785977706,'web','0:0:0:0:0:0:0:1',NULL),(1894,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785977883,'web','0:0:0:0:0:0:0:1',NULL),(1895,'\\core\\event\\draft_file_added','core','added','draft_file','files',488,'c',0,5,30,2,2,0,2,0,'{\"itemid\":154616747,\"filename\":\"theme_miflora_3.3.4-beta9-style_logout_hotfix.zip\",\"filesize\":39013,\"filepath\":\"\\/\",\"contenthash\":\"8548099033c3620b39d858bee8c19f8d5cb14379\",\"avscantime\":0.005482196807861328}',1785978270,'web','0:0:0:0:0:0:0:1',NULL),(1896,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"2jbveau1krrbn8rm7ngpqhpu25\"}',1785978372,'web','0:0:0:0:0:0:0:1',NULL),(1897,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785978372,'web','0:0:0:0:0:0:0:1',NULL),(1898,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785978383,'web','0:0:0:0:0:0:0:1',NULL),(1899,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785978389,'web','0:0:0:0:0:0:0:1',NULL),(1900,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785978408,'web','0:0:0:0:0:0:0:1',NULL),(1901,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"a2n3cmtb7u7q43gsgkmeksfuiu\"}',1785978544,'web','0:0:0:0:0:0:0:1',NULL),(1902,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785978544,'web','0:0:0:0:0:0:0:1',NULL),(1903,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785978559,'web','0:0:0:0:0:0:0:1',NULL),(1904,'\\core\\event\\draft_file_added','core','added','draft_file','files',490,'c',0,5,30,2,2,0,2,0,'{\"itemid\":539945497,\"filename\":\"theme_miflora_3.3.5-beta10-authenticated_brand_hotfix.zip\",\"filesize\":39778,\"filepath\":\"\\/\",\"contenthash\":\"360b90d9a932df805fdd485a027f1e0b5ef66e68\",\"avscantime\":0.005319833755493164}',1785978656,'web','0:0:0:0:0:0:0:1',NULL),(1905,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"35ghoekt3oevjb9qmppsck0nmg\"}',1785978732,'web','0:0:0:0:0:0:0:1',NULL),(1906,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785978732,'web','0:0:0:0:0:0:0:1',NULL),(1907,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785978736,'web','0:0:0:0:0:0:0:1',NULL),(1908,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785978749,'web','0:0:0:0:0:0:0:1',NULL),(1909,'\\core\\event\\draft_file_added','core','added','draft_file','files',502,'c',0,5,30,2,2,0,2,0,'{\"itemid\":885097857,\"filename\":\"theme_miflora_3.3.6-beta11-navbar_logon_template.zip\",\"filesize\":45639,\"filepath\":\"\\/\",\"contenthash\":\"b324aaeaf610b16e0c03117cbb9310d248f72368\",\"avscantime\":0.005514860153198242}',1785979128,'web','0:0:0:0:0:0:0:1',NULL),(1910,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"djpgfmtjsb01u4j5svj5dj3ou9\"}',1785979214,'web','0:0:0:0:0:0:0:1',NULL),(1911,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785979214,'web','0:0:0:0:0:0:0:1',NULL),(1912,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785979220,'web','0:0:0:0:0:0:0:1',NULL),(1913,'\\core\\event\\draft_file_added','core','added','draft_file','files',504,'c',0,5,30,2,2,0,2,0,'{\"itemid\":380916844,\"filename\":\"theme_miflora_3.4.0-beta12-configurable_header.zip\",\"filesize\":43257,\"filepath\":\"\\/\",\"contenthash\":\"9e1690f7fe4db29109757ffadcdf5a494a803538\",\"avscantime\":0.0063970088958740234}',1785979322,'web','0:0:0:0:0:0:0:1',NULL),(1914,'\\core\\event\\draft_file_added','core','added','draft_file','files',506,'c',0,5,30,2,2,0,2,0,'{\"itemid\":145093815,\"filename\":\"logon.png\",\"filesize\":968756,\"filepath\":\"\\/\",\"contenthash\":\"41c80a4947f38b668565961d49db4f95625e9465\",\"avscantime\":0.0013380050659179688}',1785979349,'web','0:0:0:0:0:0:0:1',NULL),(1915,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"lq8dhfg47gtrc23vae1rsqiiqn\"}',1785979369,'web','0:0:0:0:0:0:0:1',NULL),(1916,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785979369,'web','0:0:0:0:0:0:0:1',NULL),(1917,'\\core\\event\\config_log_created','core','created','config_log','config_log',1860,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headerlogo\",\"oldvalue\":null,\"value\":\"\\/logon.png\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1918,'\\core\\event\\config_log_created','core','created','config_log','config_log',1861,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headertitle\",\"oldvalue\":null,\"value\":\"Mi Flora\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1919,'\\core\\event\\config_log_created','core','created','config_log','config_log',1862,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headersubtitle\",\"oldvalue\":null,\"value\":\"Campus Virtual Oficial\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1920,'\\core\\event\\config_log_created','core','created','config_log','config_log',1863,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headerphone\",\"oldvalue\":null,\"value\":\"+51 972 018 956\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1921,'\\core\\event\\config_log_created','core','created','config_log','config_log',1864,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headeremail\",\"oldvalue\":null,\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1922,'\\core\\event\\config_log_created','core','created','config_log','config_log',1865,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showpublicheader\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1923,'\\core\\event\\config_log_created','core','created','config_log','config_log',1866,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showauthheader\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1924,'\\core\\event\\config_log_created','core','created','config_log','config_log',1867,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showheaderphone\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1925,'\\core\\event\\config_log_created','core','created','config_log','config_log',1868,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showheaderemail\",\"oldvalue\":null,\"value\":\"0\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1926,'\\core\\event\\config_log_created','core','created','config_log','config_log',1869,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showloginlanguage\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1927,'\\core\\event\\config_log_created','core','created','config_log','config_log',1870,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showhomebutton\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1928,'\\core\\event\\config_log_created','core','created','config_log','config_log',1871,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showcoursesbutton\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1929,'\\core\\event\\config_log_created','core','created','config_log','config_log',1872,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showsiteadminbutton\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1930,'\\core\\event\\config_log_created','core','created','config_log','config_log',1873,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"shownotificationsbutton\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1931,'\\core\\event\\config_log_created','core','created','config_log','config_log',1874,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showmessagesbutton\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1932,'\\core\\event\\config_log_created','core','created','config_log','config_log',1875,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showcustomlink1\",\"oldvalue\":null,\"value\":\"0\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1933,'\\core\\event\\config_log_created','core','created','config_log','config_log',1876,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"customlink1label\",\"oldvalue\":null,\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1934,'\\core\\event\\config_log_created','core','created','config_log','config_log',1877,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"customlink1url\",\"oldvalue\":null,\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1935,'\\core\\event\\config_log_created','core','created','config_log','config_log',1878,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showcustomlink2\",\"oldvalue\":null,\"value\":\"0\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1936,'\\core\\event\\config_log_created','core','created','config_log','config_log',1879,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"customlink2label\",\"oldvalue\":null,\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1937,'\\core\\event\\config_log_created','core','created','config_log','config_log',1880,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"customlink2url\",\"oldvalue\":null,\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785979387,'web','0:0:0:0:0:0:0:1',NULL),(1938,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785979417,'web','0:0:0:0:0:0:0:1',NULL),(1939,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"hhqu6ivdbqcivl06mmgcj4sk3q\"}',1785979428,'web','0:0:0:0:0:0:0:1',NULL),(1940,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785979428,'web','0:0:0:0:0:0:0:1',NULL),(1941,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785979562,'web','0:0:0:0:0:0:0:1',NULL),(1942,'\\core\\event\\draft_file_added','core','added','draft_file','files',546,'c',0,5,30,2,2,0,2,0,'{\"itemid\":873235819,\"filename\":\"theme_miflora_3.4.1-beta13-identity_whatsapp_header.zip\",\"filesize\":974725,\"filepath\":\"\\/\",\"contenthash\":\"55f77ffc383683615bfc3235343908e074950ab7\",\"avscantime\":0.005049943923950195}',1785980101,'web','0:0:0:0:0:0:0:1',NULL),(1943,'\\core\\event\\config_log_created','core','created','config_log','config_log',1881,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headerwhatsappmessage\",\"oldvalue\":null,\"value\":\"Hola, deseo comunicarme con el Colegio Flora Trist\\u00e1n.\",\"plugin\":\"theme_miflora\"}',1785980178,'web','0:0:0:0:0:0:0:1',NULL),(1944,'\\core\\event\\config_log_created','core','created','config_log','config_log',1882,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headercentertext\",\"oldvalue\":null,\"value\":\"COLEGIO FLORA TRIST\\u00c1N\",\"plugin\":\"theme_miflora\"}',1785980178,'web','0:0:0:0:0:0:0:1',NULL),(1945,'\\core\\event\\config_log_created','core','created','config_log','config_log',1883,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"showcenteridentity\",\"oldvalue\":null,\"value\":\"1\",\"plugin\":\"theme_miflora\"}',1785980178,'web','0:0:0:0:0:0:0:1',NULL),(1946,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"tcfa68jqjqtlrb61shfvk3i8r6\"}',1785980236,'web','0:0:0:0:0:0:0:1',NULL),(1947,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785980236,'web','0:0:0:0:0:0:0:1',NULL),(1948,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785980251,'web','0:0:0:0:0:0:0:1',NULL),(1949,'\\core\\event\\config_log_created','core','created','config_log','config_log',1884,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headertitle\",\"oldvalue\":\"Mi Flora\",\"value\":\"Mi Flor\",\"plugin\":\"theme_miflora\"}',1785980350,'web','0:0:0:0:0:0:0:1',NULL),(1950,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"1860sgd4jsk6gjdq6ftkbqg458\"}',1785980362,'web','0:0:0:0:0:0:0:1',NULL),(1951,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785980362,'web','0:0:0:0:0:0:0:1',NULL),(1952,'\\core\\event\\config_log_created','core','created','config_log','config_log',1885,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"headertitle\",\"oldvalue\":\"Mi Flor\",\"value\":\"Mi Flora\",\"plugin\":\"theme_miflora\"}',1785980376,'web','0:0:0:0:0:0:0:1',NULL),(1953,'\\core\\event\\config_log_created','core','created','config_log','config_log',1886,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"logintitle\",\"oldvalue\":\"Mi Flora\",\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785980403,'web','0:0:0:0:0:0:0:1',NULL),(1954,'\\core\\event\\config_log_created','core','created','config_log','config_log',1887,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"loginsubtitle\",\"oldvalue\":\"Campus Virtual Oficial\",\"value\":\"\",\"plugin\":\"theme_miflora\"}',1785980403,'web','0:0:0:0:0:0:0:1',NULL),(1955,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785980424,'web','0:0:0:0:0:0:0:1',NULL),(1956,'\\core\\event\\draft_file_added','core','added','draft_file','files',596,'c',0,5,30,2,2,0,2,0,'{\"itemid\":382809155,\"filename\":\"theme_miflora_3.5.0-beta14-editable_navbar.zip\",\"filesize\":976815,\"filepath\":\"\\/\",\"contenthash\":\"9577bd70588a41c8f6d67276174a5e8a79fd04dc\",\"avscantime\":0.0056002140045166016}',1785980995,'web','0:0:0:0:0:0:0:1',NULL),(1957,'\\core\\event\\config_log_created','core','created','config_log','config_log',1888,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"homebuttonlabel\",\"oldvalue\":null,\"value\":\"P\\u00e1gina Principal\",\"plugin\":\"theme_miflora\"}',1785981053,'web','0:0:0:0:0:0:0:1',NULL),(1958,'\\core\\event\\config_log_created','core','created','config_log','config_log',1889,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"homebuttonurl\",\"oldvalue\":null,\"value\":\"\\/local\\/miflora_core\\/index.php\",\"plugin\":\"theme_miflora\"}',1785981054,'web','0:0:0:0:0:0:0:1',NULL),(1959,'\\core\\event\\config_log_created','core','created','config_log','config_log',1890,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"coursesbuttonlabel\",\"oldvalue\":null,\"value\":\"Mis cursos\",\"plugin\":\"theme_miflora\"}',1785981054,'web','0:0:0:0:0:0:0:1',NULL),(1960,'\\core\\event\\config_log_created','core','created','config_log','config_log',1891,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"coursesbuttonurl\",\"oldvalue\":null,\"value\":\"\\/my\\/courses.php\",\"plugin\":\"theme_miflora\"}',1785981054,'web','0:0:0:0:0:0:0:1',NULL),(1961,'\\core\\event\\config_log_created','core','created','config_log','config_log',1892,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"siteadminbuttonlabel\",\"oldvalue\":null,\"value\":\"Administraci\\u00f3n del sitio\",\"plugin\":\"theme_miflora\"}',1785981054,'web','0:0:0:0:0:0:0:1',NULL),(1962,'\\core\\event\\config_log_created','core','created','config_log','config_log',1893,'c',0,1,10,0,2,0,NULL,0,'{\"name\":\"siteadminbuttonurl\",\"oldvalue\":null,\"value\":\"\\/admin\\/search.php\",\"plugin\":\"theme_miflora\"}',1785981054,'web','0:0:0:0:0:0:0:1',NULL),(1963,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785981091,'web','0:0:0:0:0:0:0:1',NULL),(1964,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"9hpvchomivs5d6no78f089ako2\"}',1785981097,'web','0:0:0:0:0:0:0:1',NULL),(1965,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785981097,'web','0:0:0:0:0:0:0:1',NULL),(1966,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785981138,'web','0:0:0:0:0:0:0:1',NULL),(1967,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,3,0,NULL,0,'null',1785981151,'web','0:0:0:0:0:0:0:1',NULL),(1968,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785981333,'web','0:0:0:0:0:0:0:1',NULL),(1969,'\\core\\event\\mycourses_viewed','core','viewed','mycourses',NULL,NULL,'r',0,1,10,0,2,0,NULL,0,'null',1785981393,'web','0:0:0:0:0:0:0:1',NULL),(1970,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"466peadktraph6o4e84tdat184\"}',1785981697,'web','0:0:0:0:0:0:0:1',NULL),(1971,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785981697,'web','0:0:0:0:0:0:0:1',NULL),(1972,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1785981727,'web','0:0:0:0:0:0:0:1',NULL),(1973,'\\core\\event\\notification_viewed','core','viewed','notification','notifications',2,'u',0,20,30,3,3,0,2,0,'null',1785981741,'web','0:0:0:0:0:0:0:1',NULL),(1974,'\\core\\event\\notification_viewed','core','viewed','notification','notifications',1,'u',0,20,30,3,3,0,2,0,'null',1785981747,'web','0:0:0:0:0:0:0:1',NULL),(1975,'\\core\\event\\user_profile_viewed','core','viewed','user_profile','user',3,'r',0,41,50,13,3,13,3,0,'{\"courseid\":\"13\",\"courseshortname\":\"PORTAFOLIO\",\"coursefullname\":\"Mi Portafolio Digital\"}',1785981748,'web','0:0:0:0:0:0:0:1',NULL),(1976,'\\core\\event\\draft_file_added','core','added','draft_file','files',598,'c',0,5,30,2,2,0,2,0,'{\"itemid\":389318192,\"filename\":\"local_miflora_messages_0.1.0.zip\",\"filesize\":7582,\"filepath\":\"\\/\",\"contenthash\":\"a2298d3e56f960255a718a9ffff05ffbfa504ed2\",\"avscantime\":0.005234956741333008}',1785981818,'web','0:0:0:0:0:0:0:1',NULL),(1977,'\\core\\event\\capability_assigned','core','assigned','capability','role_capabilities',7,'u',0,1,10,0,2,0,NULL,0,'{\"capability\":\"local\\/miflora_messages:view\",\"oldpermission\":0,\"permission\":1}',1785981847,'web','0:0:0:0:0:0:0:1',NULL),(1978,'\\core\\event\\draft_file_added','core','added','draft_file','files',600,'c',0,5,30,2,2,0,2,0,'{\"itemid\":66932381,\"filename\":\"local_miflora_core_0.5.1-messages_integration.zip\",\"filesize\":11127,\"filepath\":\"\\/\",\"contenthash\":\"48989d5cbba92964776e679a3471b3324f1b74a7\",\"avscantime\":0.0012979507446289062}',1785981879,'web','0:0:0:0:0:0:0:1',NULL),(1979,'\\core\\event\\draft_file_added','core','added','draft_file','files',602,'c',0,5,30,2,2,0,2,0,'{\"itemid\":841758943,\"filename\":\"local_miflora_portfolio_0.3.2-premium_responsive_design.zip\",\"filesize\":27109,\"filepath\":\"\\/\",\"contenthash\":\"aa406b8f5345bd91c639689bdbef916288236ca9\",\"avscantime\":0.01665782928466797}',1785982850,'web','0:0:0:0:0:0:0:1',NULL),(1980,'\\core\\event\\draft_file_added','core','added','draft_file','files',604,'c',0,20,30,3,3,0,3,0,'{\"itemid\":929164965,\"filename\":\"52a8bc_acde0866eff2465cbc6b16411f179591~mv2_d_2200_2200_s_2.jpg\",\"filesize\":222150,\"filepath\":\"\\/\",\"contenthash\":\"05a210176b46e9c211ecb0250053b0b257b58e32\",\"avscantime\":0.006688117980957031}',1785983157,'web','0:0:0:0:0:0:0:1',NULL),(1981,'\\core\\event\\draft_file_added','core','added','draft_file','files',607,'c',0,20,30,3,3,0,3,0,'{\"itemid\":159392154,\"filename\":\"JUGUETES-RECICLADOS.pdf\",\"filesize\":1202721,\"filepath\":\"\\/\",\"contenthash\":\"ee36c04feb6f1b3bc83c4de3eb8e9eb7a1a0a146\",\"avscantime\":0.0004730224609375}',1785983225,'web','0:0:0:0:0:0:0:1',NULL),(1982,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"p0ngtsgsn14vo6uumt7853ps2i\"}',1785985370,'web','0:0:0:0:0:0:0:1',NULL),(1983,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1785985370,'web','0:0:0:0:0:0:0:1',NULL),(1984,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1786148251,'web','0:0:0:0:0:0:0:1',NULL),(1985,'\\core\\event\\user_loggedin','core','loggedin','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"username\":\"admin\",\"extrauserinfo\":[]}',1786148289,'web','0:0:0:0:0:0:0:1',NULL),(1986,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"boj26f3do4pp3v418ki3k1f6lt\"}',1786148308,'web','0:0:0:0:0:0:0:1',NULL),(1987,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1786148308,'web','0:0:0:0:0:0:0:1',NULL),(1988,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1786148322,'web','0:0:0:0:0:0:0:1',NULL),(1989,'\\core\\event\\user_profile_viewed','core','viewed','user_profile','user',3,'r',0,20,30,3,3,0,3,0,'null',1786148327,'web','0:0:0:0:0:0:0:1',NULL),(1990,'\\core\\event\\draft_file_added','core','added','draft_file','files',613,'c',0,20,30,3,3,0,3,0,'{\"itemid\":285430780,\"filename\":\"WhatsApp Image 2026-08-05 at 12.44.19 AM.jpeg\",\"filesize\":186806,\"filepath\":\"\\/\",\"contenthash\":\"ba0ee0e11ed4a3a53830eb72f6f2f1f941fbfd04\",\"avscantime\":0.04207205772399902}',1786148448,'web','0:0:0:0:0:0:0:1',NULL),(1991,'\\core\\event\\draft_file_added','core','added','draft_file','files',616,'c',0,20,30,3,3,0,3,0,'{\"itemid\":158593692,\"filename\":\"Nuevos ajustes _ Administraci\\u00f3n _ Mi Flora.pdf\",\"filesize\":120448,\"filepath\":\"\\/\",\"contenthash\":\"b8a354ea735e04845107c0cbc412516816843f0d\",\"avscantime\":0.0005519390106201172}',1786148468,'web','0:0:0:0:0:0:0:1',NULL),(1992,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"9t56fcgbd6jqvttt7ilmjv5k97\"}',1786148573,'web','0:0:0:0:0:0:0:1',NULL),(1993,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1786148574,'web','0:0:0:0:0:0:0:1',NULL),(1994,'\\core\\event\\user_loggedin','core','loggedin','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"username\":\"admin\",\"extrauserinfo\":[]}',1786148579,'web','0:0:0:0:0:0:0:1',NULL),(1995,'\\core\\event\\user_loggedout','core','loggedout','user','user',2,'r',0,1,10,0,2,0,NULL,0,'{\"sessionid\":\"f863u025g85c15kd4o7auaolc7\"}',1786148682,'web','0:0:0:0:0:0:0:1',NULL),(1996,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1786148682,'web','0:0:0:0:0:0:0:1',NULL),(1997,'\\core\\event\\user_loggedin','core','loggedin','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"username\":\"aaliaga\",\"extrauserinfo\":[]}',1786148685,'web','0:0:0:0:0:0:0:1',NULL),(1998,'\\core\\event\\user_loggedout','core','loggedout','user','user',3,'r',0,1,10,0,3,0,NULL,0,'{\"sessionid\":\"oetvd7h73ujtqstpcobchq6lbk\"}',1786148915,'web','0:0:0:0:0:0:0:1',NULL),(1999,'\\core\\event\\course_viewed','core','viewed','course',NULL,NULL,'r',2,2,50,1,0,1,NULL,0,'null',1786148915,'web','0:0:0:0:0:0:0:1',NULL);

--
-- Table structure for table `mdl_lti`
--

CREATE TABLE `mdl_lti` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `typeid` bigint(10) DEFAULT NULL,
  `toolurl` longtext NOT NULL,
  `securetoolurl` longtext DEFAULT NULL,
  `instructorchoicesendname` tinyint(1) DEFAULT NULL,
  `instructorchoicesendemailaddr` tinyint(1) DEFAULT NULL,
  `instructorchoiceallowroster` tinyint(1) DEFAULT NULL,
  `instructorchoiceallowsetting` tinyint(1) DEFAULT NULL,
  `instructorcustomparameters` longtext DEFAULT NULL,
  `instructorchoiceacceptgrades` tinyint(1) DEFAULT NULL,
  `grade` bigint(10) NOT NULL DEFAULT 100,
  `launchcontainer` tinyint(2) NOT NULL DEFAULT 1,
  `resourcekey` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `debuglaunch` tinyint(1) NOT NULL DEFAULT 0,
  `showtitlelaunch` tinyint(1) NOT NULL DEFAULT 0,
  `showdescriptionlaunch` tinyint(1) NOT NULL DEFAULT 0,
  `servicesalt` varchar(40) DEFAULT NULL,
  `icon` longtext DEFAULT NULL,
  `secureicon` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_lti_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table contains Basic LTI activities instances';

--
-- Dumping data for table `mdl_lti`
--


--
-- Table structure for table `mdl_lti_access_tokens`
--

CREATE TABLE `mdl_lti_access_tokens` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `typeid` bigint(10) NOT NULL,
  `scope` longtext NOT NULL,
  `token` varchar(128) NOT NULL DEFAULT '',
  `validuntil` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `lastaccess` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_ltiaccetoke_tok_uix` (`token`),
  KEY `mdl_ltiaccetoke_typ_ix` (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Security tokens for accessing of LTI services';

--
-- Dumping data for table `mdl_lti_access_tokens`
--


--
-- Table structure for table `mdl_lti_coursevisible`
--

CREATE TABLE `mdl_lti_coursevisible` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `typeid` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `coursevisible` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_lticour_cou_ix` (`courseid`),
  KEY `mdl_lticour_typ_ix` (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to store coursevisible setting for site tool on course';

--
-- Dumping data for table `mdl_lti_coursevisible`
--


--
-- Table structure for table `mdl_lti_submission`
--

CREATE TABLE `mdl_lti_submission` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `ltiid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `datesubmitted` bigint(10) NOT NULL,
  `dateupdated` bigint(10) NOT NULL,
  `gradepercent` decimal(10,5) NOT NULL,
  `originalgrade` decimal(10,5) NOT NULL,
  `launchid` bigint(10) NOT NULL,
  `state` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltisubm_lti_ix` (`ltiid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Keeps track of individual submissions for LTI activities.';

--
-- Dumping data for table `mdl_lti_submission`
--


--
-- Table structure for table `mdl_lti_tool_proxies`
--

CREATE TABLE `mdl_lti_tool_proxies` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'Tool Provider',
  `regurl` longtext DEFAULT NULL,
  `state` tinyint(2) NOT NULL DEFAULT 1,
  `guid` varchar(255) DEFAULT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `vendorcode` varchar(255) DEFAULT NULL,
  `capabilityoffered` longtext NOT NULL,
  `serviceoffered` longtext NOT NULL,
  `toolproxy` longtext DEFAULT NULL,
  `createdby` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_ltitoolprox_gui_uix` (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='LTI tool proxy registrations';

--
-- Dumping data for table `mdl_lti_tool_proxies`
--


--
-- Table structure for table `mdl_lti_tool_settings`
--

CREATE TABLE `mdl_lti_tool_settings` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `toolproxyid` bigint(10) NOT NULL,
  `typeid` bigint(10) DEFAULT NULL,
  `course` bigint(10) DEFAULT NULL,
  `coursemoduleid` bigint(10) DEFAULT NULL,
  `settings` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltitoolsett_too_ix` (`toolproxyid`),
  KEY `mdl_ltitoolsett_typ_ix` (`typeid`),
  KEY `mdl_ltitoolsett_cou_ix` (`course`),
  KEY `mdl_ltitoolsett_cou2_ix` (`coursemoduleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='LTI tool setting values';

--
-- Dumping data for table `mdl_lti_tool_settings`
--


--
-- Table structure for table `mdl_lti_types`
--

CREATE TABLE `mdl_lti_types` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'basiclti Activity',
  `baseurl` longtext NOT NULL,
  `tooldomain` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(2) NOT NULL DEFAULT 2,
  `course` bigint(10) NOT NULL,
  `coursevisible` tinyint(1) NOT NULL DEFAULT 0,
  `ltiversion` varchar(10) NOT NULL DEFAULT '',
  `clientid` varchar(255) DEFAULT NULL,
  `toolproxyid` bigint(10) DEFAULT NULL,
  `enabledcapability` longtext DEFAULT NULL,
  `parameter` longtext DEFAULT NULL,
  `icon` longtext DEFAULT NULL,
  `secureicon` longtext DEFAULT NULL,
  `createdby` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `description` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_ltitype_cli_uix` (`clientid`),
  KEY `mdl_ltitype_cou_ix` (`course`),
  KEY `mdl_ltitype_too_ix` (`tooldomain`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Basic LTI pre-configured activities';

--
-- Dumping data for table `mdl_lti_types`
--


--
-- Table structure for table `mdl_lti_types_categories`
--

CREATE TABLE `mdl_lti_types_categories` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `typeid` bigint(10) NOT NULL,
  `categoryid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltitypecate_typ_ix` (`typeid`),
  KEY `mdl_ltitypecate_cat_ix` (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Link LTI types to course categories';

--
-- Dumping data for table `mdl_lti_types_categories`
--


--
-- Table structure for table `mdl_lti_types_config`
--

CREATE TABLE `mdl_lti_types_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `typeid` bigint(10) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltitypeconf_typ_ix` (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Basic LTI types configuration';

--
-- Dumping data for table `mdl_lti_types_config`
--


--
-- Table structure for table `mdl_ltiservice_gradebookservices`
--

CREATE TABLE `mdl_ltiservice_gradebookservices` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `gradeitemid` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `toolproxyid` bigint(10) DEFAULT NULL,
  `typeid` bigint(10) DEFAULT NULL,
  `baseurl` longtext DEFAULT NULL,
  `ltilinkid` bigint(10) DEFAULT NULL,
  `resourceid` varchar(512) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `subreviewurl` longtext DEFAULT NULL,
  `subreviewparams` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltisgrad_lti_ix` (`ltilinkid`),
  KEY `mdl_ltisgrad_gracou_ix` (`gradeitemid`,`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This file records the grade items created by the LTI Gradebo';

--
-- Dumping data for table `mdl_ltiservice_gradebookservices`
--


--
-- Table structure for table `mdl_matrix_room`
--

CREATE TABLE `mdl_matrix_room` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `commid` bigint(10) NOT NULL,
  `roomid` varchar(255) DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_matrroom_com_ix` (`commid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the matrix room information associated with the commu';

--
-- Dumping data for table `mdl_matrix_room`
--


--
-- Table structure for table `mdl_message`
--

CREATE TABLE `mdl_message` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `useridfrom` bigint(10) NOT NULL DEFAULT 0,
  `useridto` bigint(10) NOT NULL DEFAULT 0,
  `subject` longtext DEFAULT NULL,
  `fullmessage` longtext DEFAULT NULL,
  `fullmessageformat` smallint(4) DEFAULT 0,
  `fullmessagehtml` longtext DEFAULT NULL,
  `smallmessage` longtext DEFAULT NULL,
  `notification` tinyint(1) DEFAULT 0,
  `contexturl` longtext DEFAULT NULL,
  `contexturlname` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timeuserfromdeleted` bigint(10) NOT NULL DEFAULT 0,
  `timeusertodeleted` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) DEFAULT NULL,
  `eventtype` varchar(100) DEFAULT NULL,
  `customdata` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_mess_useusetimtim_ix` (`useridfrom`,`useridto`,`timeuserfromdeleted`,`timeusertodeleted`),
  KEY `mdl_mess_usetimnot_ix` (`useridfrom`,`timeuserfromdeleted`,`notification`),
  KEY `mdl_mess_usetimnot2_ix` (`useridto`,`timeusertodeleted`,`notification`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all unread messages';

--
-- Dumping data for table `mdl_message`
--


--
-- Table structure for table `mdl_message_airnotifier_devices`
--

CREATE TABLE `mdl_message_airnotifier_devices` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userdeviceid` bigint(10) NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messairndevi_use_uix` (`userdeviceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Store information about the devices registered in Airnotifie';

--
-- Dumping data for table `mdl_message_airnotifier_devices`
--


--
-- Table structure for table `mdl_message_contact_requests`
--

CREATE TABLE `mdl_message_contact_requests` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `requesteduserid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messcontrequ_usereq_uix` (`userid`,`requesteduserid`),
  KEY `mdl_messcontrequ_use_ix` (`userid`),
  KEY `mdl_messcontrequ_req_ix` (`requesteduserid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Maintains list of contact requests between users';

--
-- Dumping data for table `mdl_message_contact_requests`
--


--
-- Table structure for table `mdl_message_contacts`
--

CREATE TABLE `mdl_message_contacts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `contactid` bigint(10) NOT NULL,
  `timecreated` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messcont_usecon_uix` (`userid`,`contactid`),
  KEY `mdl_messcont_use_ix` (`userid`),
  KEY `mdl_messcont_con_ix` (`contactid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Maintains lists of contacts between users';

--
-- Dumping data for table `mdl_message_contacts`
--


--
-- Table structure for table `mdl_message_conversation_actions`
--

CREATE TABLE `mdl_message_conversation_actions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `conversationid` bigint(10) NOT NULL,
  `action` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messconvacti_use_ix` (`userid`),
  KEY `mdl_messconvacti_con_ix` (`conversationid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all per-user actions on individual conversations';

--
-- Dumping data for table `mdl_message_conversation_actions`
--


--
-- Table structure for table `mdl_message_conversation_members`
--

CREATE TABLE `mdl_message_conversation_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `conversationid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messconvmemb_con_ix` (`conversationid`),
  KEY `mdl_messconvmemb_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all members in a conversations';

--
-- Dumping data for table `mdl_message_conversation_members`
--

INSERT INTO `mdl_message_conversation_members` VALUES (1,1,2,1785953925),(2,2,3,1785958982);

--
-- Table structure for table `mdl_message_conversations`
--

CREATE TABLE `mdl_message_conversations` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` bigint(10) NOT NULL DEFAULT 1,
  `name` varchar(255) DEFAULT NULL,
  `convhash` varchar(40) DEFAULT NULL,
  `component` varchar(100) DEFAULT NULL,
  `itemtype` varchar(100) DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messconv_typ_ix` (`type`),
  KEY `mdl_messconv_con_ix` (`convhash`),
  KEY `mdl_messconv_comiteitecon_ix` (`component`,`itemtype`,`itemid`,`contextid`),
  KEY `mdl_messconv_con2_ix` (`contextid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all message conversations';

--
-- Dumping data for table `mdl_message_conversations`
--

INSERT INTO `mdl_message_conversations` VALUES (1,3,NULL,'da4b9237bacccdf19c0760cab7aec4a8359010b0',NULL,NULL,NULL,NULL,1,1785953925,1785953925),(2,3,NULL,'77de68daecd823babbb58edb1c8e14d7106e83bb',NULL,NULL,NULL,NULL,1,1785958982,1785958982);

--
-- Table structure for table `mdl_message_email_messages`
--

CREATE TABLE `mdl_message_email_messages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `useridto` bigint(10) NOT NULL,
  `conversationid` bigint(10) NOT NULL,
  `messageid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messemaimess_use_ix` (`useridto`),
  KEY `mdl_messemaimess_con_ix` (`conversationid`),
  KEY `mdl_messemaimess_mes_ix` (`messageid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Keeps track of what emails to send in an email digest';

--
-- Dumping data for table `mdl_message_email_messages`
--


--
-- Table structure for table `mdl_message_popup`
--

CREATE TABLE `mdl_message_popup` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `messageid` bigint(10) NOT NULL,
  `isread` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messpopu_mesisr_uix` (`messageid`,`isread`),
  KEY `mdl_messpopu_isr_ix` (`isread`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Keep state of notifications for the popup message processor';

--
-- Dumping data for table `mdl_message_popup`
--


--
-- Table structure for table `mdl_message_popup_notifications`
--

CREATE TABLE `mdl_message_popup_notifications` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `notificationid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messpopunoti_not_ix` (`notificationid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of notifications to display in the message output popup';

--
-- Dumping data for table `mdl_message_popup_notifications`
--

INSERT INTO `mdl_message_popup_notifications` VALUES (1,1),(2,2);

--
-- Table structure for table `mdl_message_processors`
--

CREATE TABLE `mdl_message_processors` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(166) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of message output plugins';

--
-- Dumping data for table `mdl_message_processors`
--

INSERT INTO `mdl_message_processors` VALUES (1,'airnotifier',1),(2,'email',1),(3,'popup',1),(4,'sms',0);

--
-- Table structure for table `mdl_message_providers`
--

CREATE TABLE `mdl_message_providers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `component` varchar(200) NOT NULL DEFAULT '',
  `capability` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messprov_comnam_uix` (`component`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table stores the message providers (modules and core sy';

--
-- Dumping data for table `mdl_message_providers`
--

INSERT INTO `mdl_message_providers` VALUES (1,'newlogin','moodle',NULL),(2,'notices','moodle','moodle/site:config'),(3,'errors','moodle','moodle/site:config'),(4,'availableupdate','moodle','moodle/site:config'),(5,'instantmessage','moodle',NULL),(6,'backup','moodle','moodle/site:config'),(7,'courserequested','moodle','moodle/site:approvecourse'),(8,'courserequestapproved','moodle','moodle/course:request'),(9,'courserequestrejected','moodle','moodle/course:request'),(10,'coursecompleted','moodle',NULL),(11,'coursecontentupdated','moodle',NULL),(12,'badgerecipientnotice','moodle','moodle/badges:earnbadge'),(13,'badgecreatornotice','moodle',NULL),(14,'competencyplancomment','moodle',NULL),(15,'competencyusercompcomment','moodle',NULL),(16,'insights','moodle',NULL),(17,'messagecontactrequests','moodle',NULL),(18,'asyncbackupnotification','moodle',NULL),(19,'gradenotifications','moodle',NULL),(20,'infected','moodle','moodle/site:config'),(21,'reportbuilderschedule','moodle',NULL),(22,'failedtaskmaxdelay','moodle','moodle/site:config'),(23,'enrolcoursewelcomemessage','moodle',NULL),(24,'assign_notification','mod_assign',NULL),(25,'assign_due_soon','mod_assign',NULL),(26,'assign_overdue','mod_assign',NULL),(27,'assign_due_digest','mod_assign',NULL),(28,'recording_ready','mod_bigbluebuttonbn',NULL),(29,'instance_updated','mod_bigbluebuttonbn',NULL),(30,'submission','mod_feedback',NULL),(31,'message','mod_feedback',NULL),(32,'posts','mod_forum',NULL),(33,'digests','mod_forum',NULL),(34,'graded_essay','mod_lesson',NULL),(35,'submission','mod_quiz','mod/quiz:emailnotifysubmission'),(36,'confirmation','mod_quiz','mod/quiz:emailconfirmsubmission'),(37,'attempt_overdue','mod_quiz','mod/quiz:emailwarnoverdue'),(38,'attempt_grading_complete','mod_quiz','mod/quiz:emailnotifyattemptgraded'),(39,'quiz_open_soon','mod_quiz',NULL),(40,'flatfile_enrolment','enrol_flatfile',NULL),(41,'imsenterprise_enrolment','enrol_imsenterprise',NULL),(42,'expiry_notification','enrol_manual',NULL),(43,'paypal_enrolment','enrol_paypal',NULL),(44,'expiry_notification','enrol_self',NULL),(45,'contactdataprotectionofficer','tool_dataprivacy','tool/dataprivacy:managedatarequests'),(46,'datarequestprocessingresults','tool_dataprivacy',NULL),(47,'notifyexceptions','tool_dataprivacy','tool/dataprivacy:managedatarequests'),(48,'invalidrecipienthandler','tool_messageinbound',NULL),(49,'messageprocessingerror','tool_messageinbound',NULL),(50,'messageprocessingsuccess','tool_messageinbound',NULL),(51,'notification','tool_monitor','tool/monitor:subscribe');

--
-- Table structure for table `mdl_message_read`
--

CREATE TABLE `mdl_message_read` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `useridfrom` bigint(10) NOT NULL DEFAULT 0,
  `useridto` bigint(10) NOT NULL DEFAULT 0,
  `subject` longtext DEFAULT NULL,
  `fullmessage` longtext DEFAULT NULL,
  `fullmessageformat` smallint(4) DEFAULT 0,
  `fullmessagehtml` longtext DEFAULT NULL,
  `smallmessage` longtext DEFAULT NULL,
  `notification` tinyint(1) DEFAULT 0,
  `contexturl` longtext DEFAULT NULL,
  `contexturlname` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timeread` bigint(10) NOT NULL DEFAULT 0,
  `timeuserfromdeleted` bigint(10) NOT NULL DEFAULT 0,
  `timeusertodeleted` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) DEFAULT NULL,
  `eventtype` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messread_useusetimtim_ix` (`useridfrom`,`useridto`,`timeuserfromdeleted`,`timeusertodeleted`),
  KEY `mdl_messread_nottim_ix` (`notification`,`timeread`),
  KEY `mdl_messread_usetimnot_ix` (`useridfrom`,`timeuserfromdeleted`,`notification`),
  KEY `mdl_messread_usetimnot2_ix` (`useridto`,`timeusertodeleted`,`notification`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all messages that have been read';

--
-- Dumping data for table `mdl_message_read`
--


--
-- Table structure for table `mdl_message_user_actions`
--

CREATE TABLE `mdl_message_user_actions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `messageid` bigint(10) NOT NULL,
  `action` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messuseracti_usemesact_uix` (`userid`,`messageid`,`action`),
  KEY `mdl_messuseracti_use_ix` (`userid`),
  KEY `mdl_messuseracti_mes_ix` (`messageid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all per-user actions on individual messages';

--
-- Dumping data for table `mdl_message_user_actions`
--


--
-- Table structure for table `mdl_message_users_blocked`
--

CREATE TABLE `mdl_message_users_blocked` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `blockeduserid` bigint(10) NOT NULL,
  `timecreated` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messuserbloc_useblo_uix` (`userid`,`blockeduserid`),
  KEY `mdl_messuserbloc_use_ix` (`userid`),
  KEY `mdl_messuserbloc_blo_ix` (`blockeduserid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Maintains lists of blocked users';

--
-- Dumping data for table `mdl_message_users_blocked`
--


--
-- Table structure for table `mdl_messageinbound_datakeys`
--

CREATE TABLE `mdl_messageinbound_datakeys` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `handler` bigint(10) NOT NULL,
  `datavalue` bigint(10) NOT NULL,
  `datakey` varchar(64) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `expires` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messdata_handat_uix` (`handler`,`datavalue`),
  KEY `mdl_messdata_han_ix` (`handler`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Inbound Message data item secret keys.';

--
-- Dumping data for table `mdl_messageinbound_datakeys`
--


--
-- Table structure for table `mdl_messageinbound_handlers`
--

CREATE TABLE `mdl_messageinbound_handlers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(100) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `defaultexpiration` bigint(10) NOT NULL DEFAULT 86400,
  `validateaddress` tinyint(1) NOT NULL DEFAULT 1,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_messhand_cla_uix` (`classname`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Inbound Message Handler definitions.';

--
-- Dumping data for table `mdl_messageinbound_handlers`
--

INSERT INTO `mdl_messageinbound_handlers` VALUES (1,'core','\\core\\message\\inbound\\private_files_handler',0,1,0),(2,'mod_forum','\\mod_forum\\message\\inbound\\reply_handler',604800,1,0),(3,'tool_messageinbound','\\tool_messageinbound\\message\\inbound\\invalid_recipient_handler',604800,0,1);

--
-- Table structure for table `mdl_messageinbound_messagelist`
--

CREATE TABLE `mdl_messageinbound_messagelist` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `messageid` longtext NOT NULL,
  `userid` bigint(10) NOT NULL,
  `address` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_messmess_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='A list of message IDs for existing replies';

--
-- Dumping data for table `mdl_messageinbound_messagelist`
--


--
-- Table structure for table `mdl_messages`
--

CREATE TABLE `mdl_messages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `useridfrom` bigint(10) NOT NULL,
  `conversationid` bigint(10) NOT NULL,
  `subject` longtext DEFAULT NULL,
  `fullmessage` longtext DEFAULT NULL,
  `fullmessageformat` tinyint(1) NOT NULL DEFAULT 0,
  `fullmessagehtml` longtext DEFAULT NULL,
  `smallmessage` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `fullmessagetrust` tinyint(2) NOT NULL DEFAULT 0,
  `customdata` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_mess_contim_ix` (`conversationid`,`timecreated`),
  KEY `mdl_mess_use_ix` (`useridfrom`),
  KEY `mdl_mess_con_ix` (`conversationid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all messages';

--
-- Dumping data for table `mdl_messages`
--


--
-- Table structure for table `mdl_miflora_achievement_award`
--

CREATE TABLE `mdl_miflora_achievement_award` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `courseid` bigint(10) DEFAULT NULL,
  `evidenceid` bigint(10) DEFAULT NULL,
  `badgekey` varchar(50) NOT NULL DEFAULT '',
  `badgeid` bigint(10) DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `awardedby` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_miflachiawar_usetim_ix` (`userid`,`timecreated`),
  KEY `mdl_miflachiawar_use_ix` (`userid`),
  KEY `mdl_miflachiawar_cou_ix` (`courseid`),
  KEY `mdl_miflachiawar_awa_ix` (`awardedby`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Awards assigned to students';

--
-- Dumping data for table `mdl_miflora_achievement_award`
--

INSERT INTO `mdl_miflora_achievement_award` VALUES (1,3,2,5,'ingenuity',NULL,'Tu evidencia demuestra un desempeño destacado, autonomía y capacidad para aplicar lo aprendido de manera pertinente.',2,1785966172),(2,3,NULL,6,'custom',5,'Alcanzaste el aprendizaje esperado en esta evidencia. Continúa aplicando lo aprendido en nuevas situaciones.',2,1785983323),(3,3,NULL,7,'custom',10,'Buen Trabajo de investigación!',2,1786148678);

--
-- Table structure for table `mdl_miflora_achievement_badge`
--

CREATE TABLE `mdl_miflora_achievement_badge` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(120) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_miflachibadg_enasor_ix` (`enabled`,`sortorder`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `mdl_miflora_achievement_badge`
--

INSERT INTO `mdl_miflora_achievement_badge` VALUES (1,'puntualidad','',1,1,1785970230,1785970230),(2,'orden','',1,2,1785970256,1785970256),(3,'creatividad','',1,3,1785970277,1785970277),(4,'esfuerzo','',1,4,1785970299,1785970299),(5,'sobresaliente','',1,5,1785970318,1785970318),(6,'apoyo','',1,6,1785970333,1785970333),(7,'ingenio','',1,7,1785970376,1785970376),(8,'responsabilidad','',1,8,1785970397,1785970397),(9,'buen lector','',1,9,1785970419,1785970419),(10,'investigador','',1,10,1785970446,1785970446),(11,'solidaridad','',1,11,1785970462,1785970462),(12,'liderazgo','',1,12,1785970477,1785970477);

--
-- Table structure for table `mdl_miflora_appearance_card`
--

CREATE TABLE `mdl_miflora_appearance_card` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `cardkey` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(120) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `backgroundcolor` varchar(20) NOT NULL DEFAULT '#FFFFFF',
  `textcolor` varchar(20) NOT NULL DEFAULT '#0B2F55',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_miflappecard_car_uix` (`cardkey`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Visual configuration for Mi Flora cards';

--
-- Dumping data for table `mdl_miflora_appearance_card`
--

INSERT INTO `mdl_miflora_appearance_card` VALUES (1,'portfolio','Mi Portafolio','Accede a tu repositorio personal.','#FFFFFF','#0B2F55',1,1785974861),(2,'history','Mi Historia Escolar','Consulta tu recorrido de evidencias aprobadas.','#FFFFFF','#0B2F55',1,1785973125),(3,'achievements','Mis logros','Reconocimientos otorgados por tus docentes.','#FFFFFF','#0B2F55',1,1785973304),(4,'messages','Mensajes','Revisa tus conversaciones.','#FFFFFF','#0B2F55',1,1785973560);

--
-- Table structure for table `mdl_miflora_portfolio_evidence`
--

CREATE TABLE `mdl_miflora_portfolio_evidence` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `courseid` bigint(10) DEFAULT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `evidencetype` varchar(50) NOT NULL DEFAULT 'other',
  `area` varchar(100) NOT NULL DEFAULT 'other',
  `description` longtext DEFAULT NULL,
  `reflection` longtext DEFAULT NULL,
  `videourl` longtext DEFAULT NULL,
  `videodisplay` varchar(20) NOT NULL DEFAULT 'embed',
  `pdfdisplay` varchar(20) NOT NULL DEFAULT 'embed',
  `status` varchar(20) NOT NULL DEFAULT 'draft',
  `feedback` longtext DEFAULT NULL,
  `reviewerid` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `timesubmitted` bigint(10) DEFAULT NULL,
  `timereviewed` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_miflportevid_usesta_ix` (`userid`,`status`),
  KEY `mdl_miflportevid_statim_ix` (`status`,`timemodified`),
  KEY `mdl_miflportevid_use_ix` (`userid`),
  KEY `mdl_miflportevid_rev_ix` (`reviewerid`),
  KEY `mdl_miflportevid_cou_ix` (`courseid`),
  KEY `mdl_miflportevid_cousta_ix` (`courseid`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Student portfolio evidence';

--
-- Dumping data for table `mdl_miflora_portfolio_evidence`
--

INSERT INTO `mdl_miflora_portfolio_evidence` VALUES (2,3,NULL,'eureka 2026 - dia del logro JULIO','project','science','se trabajo en un proyecto para la comunidad educativa y de pachacutec','aprendi que la energia solar puede ser reutilizada atravez de componentes electronicos y asi ahorrariamos dinero en gastos de servico de luz privada. ','https://www.youtube.com/watch?v=vmh6YDBMwHI','embed','embed','approved','',2,1785956534,1785956576,1785956534,1785956576),(3,3,NULL,'reflexion','text','communication','reflexión porque era feo el patito, pensamiento critico','El pensamiento crítico es la poderosa habilidad de analizar, evaluar y cuestionar la información que nos rodea.\r\nNos permite ver más allá de lo evidente para formar opiniones propias y no aceptar las cosas ciegamente.\r\nSi aplicamos esta capacidad al cuento clásico, descubrimos el verdadero motivo por el que el patito era \"feo\".\r\nLa realidad es que nunca lo fue; simplemente era diferente a los demás porque en realidad era un cisne.\r\nNació en el nido equivocado y fue duramente juzgado por un grupo que no comprendía su verdadera naturaleza.\r\nLos patos lo evaluaron bajo sus propios estándares limitados, confundiendo lo desconocido con la fealdad.\r\nSu historia es un claro ejemplo de cómo la ignorancia y los prejuicios nos llevan a conclusiones equivocadas.\r\nAsí, pensar críticamente nos ayuda a valorar la diversidad y a no juzgar a nadie por simples apariencias.','https://www.youtube.com/watch?v=i-htv81L04g','embed','embed','approved','✅ Decisión y Calificación\r\nVeredicto: ¡Trabajo Sobresaliente! / Logro Destacado (AD) 🌟\r\n\r\nTu texto está muy bien estructurado, responde directamente a las preguntas planteadas y, lo más importante, deja un mensaje poderoso sobre la diversidad y los prejuicios. Demuestras una gran capacidad de análisis literario y social. ¡Sigue escribiendo con esta misma pasión!\r\n\r\n¿Te gustaría que trabajemos en algunas ideas sobre cómo podrías convertir esta misma reflexión en un pequeño discurso oral para presentarlo frente a tus compañeros?',2,1785957415,1785957588,1785957415,1785957588),(4,3,2,'porque el lobo es feroz?','text','communication','reflexión y pensamiento critico ','Aquí tienes la reflexión sobre lo aprendido, redactada en exactamente cinco líneas, con un estilo cautivador y profundo:\r\n\r\nAprendí que el pensamiento crítico es una lupa mágica que nos revela la asombrosa verdad oculta en cada relato.\r\nDescubrí que los personajes, al igual que las personas, jamás deben ser juzgados por sus simples apariencias o rumores.\r\nComprendí que detrás de cada ser diferente siempre hay una perspectiva profunda que merece ser escuchada con empatía.\r\nEntendí que cuestionar lo que todos repiten ciegamente nos enseña a ser mucho más justos y a no dejarnos engañar.\r\nFinalmente, me llevo la poderosa lección de que atrevernos a mirar más allá de lo evidente transforma nuestro mundo.','https://www.youtube.com/watch?v=Xbkep1tp9Hk','embed','embed','approved','muy bien, sobresaliente',2,1785961751,1785961813,1785961751,1785961813),(5,3,2,'prueba 5','reading','communication','preba 5 logros y retroalimentacion','prueba sin video','','embed','embed','approved','Tu evidencia demuestra un desempeño destacado, autonomía y capacidad para aplicar lo aprendido de manera pertinente.',2,1785966132,1785966172,1785966132,1785966172),(6,3,NULL,'prueba 5 aqui va el titulo ','reading','mathematics','elaboramos juegos lúdicos con material reciclado.','¿Qué es Lorem Ipsum?\r\nLorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta) desconocido usó una galería de textos y los mezcló de tal manera que logró hacer un libro de textos especimen. No sólo sobrevivió 500 años, sino que tambien ingresó como texto de relleno en documentos electrónicos, quedando esencialmente igual al original. Fue popularizado en los 60s con la creación de las hojas \"Letraset\", las cuales contenian pasajes de Lorem Ipsum, y más recientemente con software de autoedición, como por ejemplo Aldus PageMaker, el cual incluye versiones de Lorem Ipsum.','https://www.youtube.com/watch?v=LsHCVeczjqY','embed','embed','approved','Alcanzaste el aprendizaje esperado en esta evidencia. Continúa aplicando lo aprendido en nuevas situaciones.',2,1785983260,1785983323,1785983260,1785983323),(7,3,NULL,'Dia del Ogro ','presentation','science','Semaforo inteligente','','https://www.youtube.com/watch?v=E_M3lR2GDSs','embed','embed','approved','Buen Trabajo de investigación!',2,1786148541,1786148678,1786148541,1786148678);

--
-- Table structure for table `mdl_mnet_application`
--

CREATE TABLE `mdl_mnet_application` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `display_name` varchar(50) NOT NULL DEFAULT '',
  `xmlrpc_server_url` varchar(255) NOT NULL DEFAULT '',
  `sso_land_url` varchar(255) NOT NULL DEFAULT '',
  `sso_jump_url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Information about applications on remote hosts';

--
-- Dumping data for table `mdl_mnet_application`
--

INSERT INTO `mdl_mnet_application` VALUES (1,'moodle','Moodle','/mnet/xmlrpc/server.php','/auth/mnet/land.php','/auth/mnet/jump.php'),(2,'mahara','Mahara','/api/xmlrpc/server.php','/auth/xmlrpc/land.php','/auth/xmlrpc/jump.php');

--
-- Table structure for table `mdl_mnet_host`
--

CREATE TABLE `mdl_mnet_host` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  `wwwroot` varchar(255) NOT NULL DEFAULT '',
  `ip_address` varchar(45) NOT NULL DEFAULT '',
  `name` varchar(80) NOT NULL DEFAULT '',
  `public_key` longtext NOT NULL,
  `public_key_expires` bigint(10) NOT NULL DEFAULT 0,
  `transport` tinyint(2) NOT NULL DEFAULT 0,
  `portno` mediumint(5) NOT NULL DEFAULT 0,
  `last_connect_time` bigint(10) NOT NULL DEFAULT 0,
  `last_log_id` bigint(10) NOT NULL DEFAULT 0,
  `force_theme` tinyint(1) NOT NULL DEFAULT 0,
  `theme` varchar(100) DEFAULT NULL,
  `applicationid` bigint(10) NOT NULL DEFAULT 1,
  `sslverification` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_mnethost_las_ix` (`last_log_id`),
  KEY `mdl_mnethost_app_ix` (`applicationid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Information about the local and remote hosts for RPC';

--
-- Dumping data for table `mdl_mnet_host`
--

INSERT INTO `mdl_mnet_host` VALUES (1,0,'http://localhost','::1','','',0,0,0,0,0,0,NULL,1,0),(2,0,'','','All Hosts','',0,0,0,0,0,0,NULL,1,0);

--
-- Table structure for table `mdl_mnet_host2service`
--

CREATE TABLE `mdl_mnet_host2service` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `hostid` bigint(10) NOT NULL DEFAULT 0,
  `serviceid` bigint(10) NOT NULL DEFAULT 0,
  `publish` tinyint(1) NOT NULL DEFAULT 0,
  `subscribe` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_mnethost_hosser_uix` (`hostid`,`serviceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Information about the services for a given host';

--
-- Dumping data for table `mdl_mnet_host2service`
--


--
-- Table structure for table `mdl_mnet_log`
--

CREATE TABLE `mdl_mnet_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `hostid` bigint(10) NOT NULL DEFAULT 0,
  `remoteid` bigint(10) NOT NULL DEFAULT 0,
  `time` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `ip` varchar(45) NOT NULL DEFAULT '',
  `course` bigint(10) NOT NULL DEFAULT 0,
  `coursename` varchar(40) NOT NULL DEFAULT '',
  `module` varchar(20) NOT NULL DEFAULT '',
  `cmid` bigint(10) NOT NULL DEFAULT 0,
  `action` varchar(40) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  `info` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_mnetlog_hosusecou_ix` (`hostid`,`userid`,`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Store session data from users migrating to other sites';

--
-- Dumping data for table `mdl_mnet_log`
--


--
-- Table structure for table `mdl_mnet_remote_rpc`
--

CREATE TABLE `mdl_mnet_remote_rpc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `functionname` varchar(40) NOT NULL DEFAULT '',
  `xmlrpcpath` varchar(80) NOT NULL DEFAULT '',
  `plugintype` varchar(20) NOT NULL DEFAULT '',
  `pluginname` varchar(20) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table describes functions that might be called remotely';

--
-- Dumping data for table `mdl_mnet_remote_rpc`
--


--
-- Table structure for table `mdl_mnet_remote_service2rpc`
--

CREATE TABLE `mdl_mnet_remote_service2rpc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `serviceid` bigint(10) NOT NULL DEFAULT 0,
  `rpcid` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_mnetremoserv_rpcser_uix` (`rpcid`,`serviceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Group functions or methods under a service';

--
-- Dumping data for table `mdl_mnet_remote_service2rpc`
--


--
-- Table structure for table `mdl_mnet_rpc`
--

CREATE TABLE `mdl_mnet_rpc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `functionname` varchar(40) NOT NULL DEFAULT '',
  `xmlrpcpath` varchar(80) NOT NULL DEFAULT '',
  `plugintype` varchar(20) NOT NULL DEFAULT '',
  `pluginname` varchar(20) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  `help` longtext NOT NULL,
  `profile` longtext NOT NULL,
  `filename` varchar(100) NOT NULL DEFAULT '',
  `classname` varchar(150) DEFAULT NULL,
  `static` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_mnetrpc_enaxml_ix` (`enabled`,`xmlrpcpath`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Functions or methods that we may publish or subscribe to';

--
-- Dumping data for table `mdl_mnet_rpc`
--


--
-- Table structure for table `mdl_mnet_service`
--

CREATE TABLE `mdl_mnet_service` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT '',
  `description` varchar(40) NOT NULL DEFAULT '',
  `apiversion` varchar(10) NOT NULL DEFAULT '',
  `offer` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='A service is a group of functions';

--
-- Dumping data for table `mdl_mnet_service`
--


--
-- Table structure for table `mdl_mnet_service2rpc`
--

CREATE TABLE `mdl_mnet_service2rpc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `serviceid` bigint(10) NOT NULL DEFAULT 0,
  `rpcid` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_mnetserv_rpcser_uix` (`rpcid`,`serviceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Group functions or methods under a service';

--
-- Dumping data for table `mdl_mnet_service2rpc`
--


--
-- Table structure for table `mdl_mnet_session`
--

CREATE TABLE `mdl_mnet_session` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `username` varchar(100) NOT NULL DEFAULT '',
  `token` varchar(40) NOT NULL DEFAULT '',
  `mnethostid` bigint(10) NOT NULL DEFAULT 0,
  `useragent` varchar(40) NOT NULL DEFAULT '',
  `confirm_timeout` bigint(10) NOT NULL DEFAULT 0,
  `session_id` varchar(40) NOT NULL DEFAULT '',
  `expires` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_mnetsess_tok_uix` (`token`),
  KEY `mdl_mnetsess_use_ix` (`userid`),
  KEY `mdl_mnetsess_mne_ix` (`mnethostid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Store session data from users migrating to other sites';

--
-- Dumping data for table `mdl_mnet_session`
--


--
-- Table structure for table `mdl_mnet_sso_access_control`
--

CREATE TABLE `mdl_mnet_sso_access_control` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL DEFAULT '',
  `mnet_host_id` bigint(10) NOT NULL DEFAULT 0,
  `accessctrl` varchar(20) NOT NULL DEFAULT 'allow',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_mnetssoaccecont_mneuse_uix` (`mnet_host_id`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Users by host permitted (or not) to login from a remote prov';

--
-- Dumping data for table `mdl_mnet_sso_access_control`
--


--
-- Table structure for table `mdl_modules`
--

CREATE TABLE `mdl_modules` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `cron` bigint(10) NOT NULL DEFAULT 0,
  `lastcron` bigint(10) NOT NULL DEFAULT 0,
  `search` varchar(255) NOT NULL DEFAULT '',
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `mdl_modu_nam_ix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='modules available in the site';

--
-- Dumping data for table `mdl_modules`
--

INSERT INTO `mdl_modules` VALUES (1,'assign',0,0,'',1),(2,'bigbluebuttonbn',0,0,'',0),(3,'book',0,0,'',1),(4,'choice',0,0,'',1),(5,'data',0,0,'',1),(6,'feedback',0,0,'',1),(7,'folder',0,0,'',1),(8,'forum',0,0,'',1),(9,'glossary',0,0,'',1),(10,'h5pactivity',0,0,'',1),(11,'imscp',0,0,'',1),(12,'label',0,0,'',1),(13,'lesson',0,0,'',1),(14,'lti',0,0,'',1),(15,'page',0,0,'',1),(16,'qbank',0,0,'',1),(17,'quiz',0,0,'',1),(18,'resource',0,0,'',1),(19,'scorm',0,0,'',1),(20,'subsection',0,0,'',1),(21,'url',0,0,'',1),(22,'wiki',0,0,'',1),(23,'workshop',0,0,'',1);

--
-- Table structure for table `mdl_moodlenet_share_progress`
--

CREATE TABLE `mdl_moodlenet_share_progress` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `cmid` bigint(10) DEFAULT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `resourceurl` varchar(255) DEFAULT NULL,
  `status` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Records MoodleNet share progress';

--
-- Dumping data for table `mdl_moodlenet_share_progress`
--


--
-- Table structure for table `mdl_my_pages`
--

CREATE TABLE `mdl_my_pages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) DEFAULT 0,
  `name` varchar(200) NOT NULL DEFAULT '',
  `private` tinyint(1) NOT NULL DEFAULT 1,
  `sortorder` mediumint(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_mypage_usepri_ix` (`userid`,`private`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Extra user pages for the My Moodle system';

--
-- Dumping data for table `mdl_my_pages`
--

INSERT INTO `mdl_my_pages` VALUES (1,NULL,'__default',0,0),(2,NULL,'__default',1,0),(3,NULL,'__courses',0,0),(4,2,'__default',1,0),(5,3,'__default',0,0),(6,3,'__default',1,0),(7,2,'__default',0,0);

--
-- Table structure for table `mdl_notifications`
--

CREATE TABLE `mdl_notifications` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `useridfrom` bigint(10) NOT NULL,
  `useridto` bigint(10) NOT NULL,
  `subject` longtext DEFAULT NULL,
  `fullmessage` longtext DEFAULT NULL,
  `fullmessageformat` tinyint(1) NOT NULL DEFAULT 0,
  `fullmessagehtml` longtext DEFAULT NULL,
  `smallmessage` longtext DEFAULT NULL,
  `component` varchar(100) DEFAULT NULL,
  `eventtype` varchar(100) DEFAULT NULL,
  `contexturl` longtext DEFAULT NULL,
  `contexturlname` longtext DEFAULT NULL,
  `timeread` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `customdata` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_noti_use_ix` (`useridfrom`),
  KEY `mdl_noti_tim_ix` (`timecreated`),
  KEY `mdl_noti_tim2_ix` (`timeread`),
  KEY `mdl_noti_use2_ix` (`useridto`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all notifications';

--
-- Dumping data for table `mdl_notifications`
--

INSERT INTO `mdl_notifications` VALUES (1,2,3,'Bienvenido/a a Mi Portafolio Digital','Hola, Angel Manuel Aliaga Arevalo. Se le ha matriculado en el curso Mi Portafolio Digital.',4,'Hola, Angel Manuel Aliaga Arevalo. Se le ha matriculado en el curso Mi Portafolio Digital.',NULL,'moodle','enrolcoursewelcomemessage','http://localhost/user/view.php?id=3&amp;course=13','Mi Portafolio Digital',1785981747,1785898122,NULL),(2,2,3,'Bienvenido/a a Comunicación','Hola, Angel Manuel Aliaga Arevalo. Se le ha matriculado en el curso Comunicación.',4,'Hola, Angel Manuel Aliaga Arevalo. Se le ha matriculado en el curso Comunicación.',NULL,'moodle','enrolcoursewelcomemessage','http://localhost/user/view.php?id=3&amp;course=2','Comunicación',1785981740,1785961433,NULL);

--
-- Table structure for table `mdl_oauth2_access_token`
--

CREATE TABLE `mdl_oauth2_access_token` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `token` longtext NOT NULL,
  `expires` bigint(10) NOT NULL,
  `scope` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautaccetoke_iss_uix` (`issuerid`),
  KEY `mdl_oautaccetoke_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores access tokens for system accounts in order to be able';

--
-- Dumping data for table `mdl_oauth2_access_token`
--


--
-- Table structure for table `mdl_oauth2_endpoint`
--

CREATE TABLE `mdl_oauth2_endpoint` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `url` longtext NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_oautendp_iss_ix` (`issuerid`),
  KEY `mdl_oautendp_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Describes the named endpoint for an oauth2 service.';

--
-- Dumping data for table `mdl_oauth2_endpoint`
--


--
-- Table structure for table `mdl_oauth2_issuer`
--

CREATE TABLE `mdl_oauth2_issuer` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `image` longtext NOT NULL,
  `baseurl` longtext NOT NULL,
  `clientid` longtext NOT NULL,
  `clientsecret` longtext NOT NULL,
  `loginscopes` longtext NOT NULL,
  `loginscopesoffline` longtext NOT NULL,
  `loginparams` longtext NOT NULL,
  `loginparamsoffline` longtext NOT NULL,
  `alloweddomains` longtext NOT NULL,
  `scopessupported` longtext DEFAULT NULL,
  `enabled` tinyint(2) NOT NULL DEFAULT 1,
  `showonloginpage` tinyint(2) NOT NULL DEFAULT 1,
  `basicauth` tinyint(2) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL,
  `requireconfirmation` tinyint(2) NOT NULL DEFAULT 1,
  `servicetype` varchar(255) DEFAULT NULL,
  `loginpagename` varchar(255) DEFAULT NULL,
  `systememail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Details for an oauth 2 connect identity issuer.';

--
-- Dumping data for table `mdl_oauth2_issuer`
--


--
-- Table structure for table `mdl_oauth2_refresh_token`
--

CREATE TABLE `mdl_oauth2_refresh_token` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `token` longtext NOT NULL,
  `scopehash` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautrefrtoke_useisssco_uix` (`userid`,`issuerid`,`scopehash`),
  KEY `mdl_oautrefrtoke_iss_ix` (`issuerid`),
  KEY `mdl_oautrefrtoke_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores refresh tokens which can be exchanged for access toke';

--
-- Dumping data for table `mdl_oauth2_refresh_token`
--


--
-- Table structure for table `mdl_oauth2_system_account`
--

CREATE TABLE `mdl_oauth2_system_account` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `refreshtoken` longtext NOT NULL,
  `grantedscopes` longtext NOT NULL,
  `email` longtext DEFAULT NULL,
  `username` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautsystacco_iss_uix` (`issuerid`),
  KEY `mdl_oautsystacco_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stored details used to get an access token as a system user ';

--
-- Dumping data for table `mdl_oauth2_system_account`
--


--
-- Table structure for table `mdl_oauth2_user_field_mapping`
--

CREATE TABLE `mdl_oauth2_user_field_mapping` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timemodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `externalfield` varchar(500) NOT NULL DEFAULT '',
  `internalfield` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautuserfielmapp_issin_uix` (`issuerid`,`internalfield`),
  KEY `mdl_oautuserfielmapp_iss_ix` (`issuerid`),
  KEY `mdl_oautuserfielmapp_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Mapping of oauth user fields to moodle fields.';

--
-- Dumping data for table `mdl_oauth2_user_field_mapping`
--


--
-- Table structure for table `mdl_page`
--

CREATE TABLE `mdl_page` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `content` longtext DEFAULT NULL,
  `contentformat` smallint(4) NOT NULL DEFAULT 0,
  `legacyfiles` smallint(4) NOT NULL DEFAULT 0,
  `legacyfileslast` bigint(10) DEFAULT NULL,
  `display` smallint(4) NOT NULL DEFAULT 0,
  `displayoptions` longtext DEFAULT NULL,
  `revision` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_page_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each record is one page and its config data';

--
-- Dumping data for table `mdl_page`
--


--
-- Table structure for table `mdl_paygw_paypal`
--

CREATE TABLE `mdl_paygw_paypal` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `paymentid` bigint(10) NOT NULL,
  `pp_orderid` varchar(255) NOT NULL DEFAULT 'The ID of the order in PayPal',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_paygpayp_pay_uix` (`paymentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores PayPal related information';

--
-- Dumping data for table `mdl_paygw_paypal`
--


--
-- Table structure for table `mdl_payment_accounts`
--

CREATE TABLE `mdl_payment_accounts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `idnumber` varchar(100) DEFAULT NULL,
  `contextid` bigint(10) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  `archived` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_paymacco_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Payment accounts';

--
-- Dumping data for table `mdl_payment_accounts`
--


--
-- Table structure for table `mdl_payment_gateways`
--

CREATE TABLE `mdl_payment_gateways` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `accountid` bigint(10) NOT NULL,
  `gateway` varchar(100) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `config` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_paymgate_acc_ix` (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Configuration for one gateway for one payment account';

--
-- Dumping data for table `mdl_payment_gateways`
--


--
-- Table structure for table `mdl_payments`
--

CREATE TABLE `mdl_payments` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(100) NOT NULL DEFAULT '',
  `paymentarea` varchar(50) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `amount` varchar(20) NOT NULL DEFAULT '',
  `currency` varchar(3) NOT NULL DEFAULT '',
  `accountid` bigint(10) NOT NULL,
  `gateway` varchar(100) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_paym_gat_ix` (`gateway`),
  KEY `mdl_paym_compayite_ix` (`component`,`paymentarea`,`itemid`),
  KEY `mdl_paym_use_ix` (`userid`),
  KEY `mdl_paym_acc_ix` (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores information about payments';

--
-- Dumping data for table `mdl_payments`
--


--
-- Table structure for table `mdl_portfolio_instance`
--

CREATE TABLE `mdl_portfolio_instance` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='base table (not including config data) for instances of port';

--
-- Dumping data for table `mdl_portfolio_instance`
--


--
-- Table structure for table `mdl_portfolio_instance_config`
--

CREATE TABLE `mdl_portfolio_instance_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `instance` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_portinstconf_nam_ix` (`name`),
  KEY `mdl_portinstconf_ins_ix` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='config for portfolio plugin instances';

--
-- Dumping data for table `mdl_portfolio_instance_config`
--


--
-- Table structure for table `mdl_portfolio_instance_user`
--

CREATE TABLE `mdl_portfolio_instance_user` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `instance` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_portinstuser_ins_ix` (`instance`),
  KEY `mdl_portinstuser_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='user data for portfolio instances.';

--
-- Dumping data for table `mdl_portfolio_instance_user`
--


--
-- Table structure for table `mdl_portfolio_log`
--

CREATE TABLE `mdl_portfolio_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `time` bigint(10) NOT NULL,
  `portfolio` bigint(10) NOT NULL,
  `caller_class` varchar(150) NOT NULL DEFAULT '',
  `caller_file` varchar(255) NOT NULL DEFAULT '',
  `caller_component` varchar(255) DEFAULT NULL,
  `caller_sha1` varchar(255) NOT NULL DEFAULT '',
  `tempdataid` bigint(10) NOT NULL DEFAULT 0,
  `returnurl` varchar(255) NOT NULL DEFAULT '',
  `continueurl` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_portlog_use_ix` (`userid`),
  KEY `mdl_portlog_por_ix` (`portfolio`),
  KEY `mdl_portlog_tem_ix` (`tempdataid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='log of portfolio transfers (used to later check for duplicat';

--
-- Dumping data for table `mdl_portfolio_log`
--


--
-- Table structure for table `mdl_portfolio_tempdata`
--

CREATE TABLE `mdl_portfolio_tempdata` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `data` longtext DEFAULT NULL,
  `expirytime` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `instance` bigint(10) DEFAULT 0,
  `queued` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_porttemp_use_ix` (`userid`),
  KEY `mdl_porttemp_ins_ix` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='stores temporary data for portfolio exports. the id of this ';

--
-- Dumping data for table `mdl_portfolio_tempdata`
--


--
-- Table structure for table `mdl_post`
--

CREATE TABLE `mdl_post` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `module` varchar(20) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `courseid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `moduleid` bigint(10) NOT NULL DEFAULT 0,
  `coursemoduleid` bigint(10) NOT NULL DEFAULT 0,
  `subject` varchar(128) NOT NULL DEFAULT '',
  `summary` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `uniquehash` varchar(255) NOT NULL DEFAULT '',
  `rating` bigint(10) NOT NULL DEFAULT 0,
  `format` bigint(10) NOT NULL DEFAULT 0,
  `summaryformat` tinyint(2) NOT NULL DEFAULT 0,
  `attachment` varchar(100) DEFAULT NULL,
  `publishstate` varchar(20) NOT NULL DEFAULT 'draft',
  `lastmodified` bigint(10) NOT NULL DEFAULT 0,
  `created` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_post_iduse_uix` (`id`,`userid`),
  KEY `mdl_post_las_ix` (`lastmodified`),
  KEY `mdl_post_mod_ix` (`module`),
  KEY `mdl_post_sub_ix` (`subject`),
  KEY `mdl_post_use_ix` (`usermodified`),
  KEY `mdl_post_cou_ix` (`courseid`),
  KEY `mdl_post_cou2_ix` (`coursemoduleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Generic post table to hold data blog entries etc in differen';

--
-- Dumping data for table `mdl_post`
--


--
-- Table structure for table `mdl_profiling`
--

CREATE TABLE `mdl_profiling` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `runid` varchar(32) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `data` longtext NOT NULL,
  `totalexecutiontime` bigint(10) NOT NULL,
  `totalcputime` bigint(10) NOT NULL,
  `totalcalls` bigint(10) NOT NULL,
  `totalmemory` bigint(10) NOT NULL,
  `runreference` tinyint(2) NOT NULL DEFAULT 0,
  `runcomment` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_prof_run_uix` (`runid`),
  KEY `mdl_prof_urlrun_ix` (`url`,`runreference`),
  KEY `mdl_prof_timrun_ix` (`timecreated`,`runreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the results of all the profiling runs';

--
-- Dumping data for table `mdl_profiling`
--


--
-- Table structure for table `mdl_qbank`
--

CREATE TABLE `mdl_qbank` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `type` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_qban_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the qbank activity module instances.';

--
-- Dumping data for table `mdl_qbank`
--


--
-- Table structure for table `mdl_qtype_ddimageortext`
--

CREATE TABLE `mdl_qtype_ddimageortext` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  `dropzonevisibility` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_qtypddim_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines drag and drop (text or images onto a background imag';

--
-- Dumping data for table `mdl_qtype_ddimageortext`
--


--
-- Table structure for table `mdl_qtype_ddimageortext_drags`
--

CREATE TABLE `mdl_qtype_ddimageortext_drags` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `no` bigint(10) NOT NULL DEFAULT 0,
  `draggroup` bigint(10) NOT NULL DEFAULT 0,
  `infinite` smallint(4) NOT NULL DEFAULT 0,
  `label` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_qtypddimdrag_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Images to drag. Actual file names are not stored here we use';

--
-- Dumping data for table `mdl_qtype_ddimageortext_drags`
--


--
-- Table structure for table `mdl_qtype_ddimageortext_drops`
--

CREATE TABLE `mdl_qtype_ddimageortext_drops` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `no` bigint(10) NOT NULL DEFAULT 0,
  `xleft` bigint(10) NOT NULL DEFAULT 0,
  `ytop` bigint(10) NOT NULL DEFAULT 0,
  `choice` bigint(10) NOT NULL DEFAULT 0,
  `label` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_qtypddimdrop_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Drop boxes';

--
-- Dumping data for table `mdl_qtype_ddimageortext_drops`
--


--
-- Table structure for table `mdl_qtype_ddmarker`
--

CREATE TABLE `mdl_qtype_ddmarker` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  `showmisplaced` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_qtypddma_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines drag and drop (text or images onto a background imag';

--
-- Dumping data for table `mdl_qtype_ddmarker`
--


--
-- Table structure for table `mdl_qtype_ddmarker_drags`
--

CREATE TABLE `mdl_qtype_ddmarker_drags` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `no` bigint(10) NOT NULL DEFAULT 0,
  `label` longtext NOT NULL,
  `infinite` smallint(4) NOT NULL DEFAULT 0,
  `noofdrags` bigint(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `mdl_qtypddmadrag_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Labels for markers to drag.';

--
-- Dumping data for table `mdl_qtype_ddmarker_drags`
--


--
-- Table structure for table `mdl_qtype_ddmarker_drops`
--

CREATE TABLE `mdl_qtype_ddmarker_drops` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `no` bigint(10) NOT NULL DEFAULT 0,
  `shape` varchar(255) DEFAULT NULL,
  `coords` longtext NOT NULL,
  `choice` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_qtypddmadrop_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='drop regions';

--
-- Dumping data for table `mdl_qtype_ddmarker_drops`
--


--
-- Table structure for table `mdl_qtype_essay_options`
--

CREATE TABLE `mdl_qtype_essay_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL,
  `responseformat` varchar(16) NOT NULL DEFAULT 'editor',
  `responserequired` tinyint(2) NOT NULL DEFAULT 1,
  `responsefieldlines` smallint(4) NOT NULL DEFAULT 15,
  `minwordlimit` bigint(10) DEFAULT NULL,
  `maxwordlimit` bigint(10) DEFAULT NULL,
  `attachments` smallint(4) NOT NULL DEFAULT 0,
  `attachmentsrequired` smallint(4) NOT NULL DEFAULT 0,
  `graderinfo` longtext DEFAULT NULL,
  `graderinfoformat` smallint(4) NOT NULL DEFAULT 0,
  `responsetemplate` longtext DEFAULT NULL,
  `responsetemplateformat` smallint(4) NOT NULL DEFAULT 0,
  `maxbytes` bigint(10) NOT NULL DEFAULT 0,
  `filetypeslist` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_qtypessaopti_que_uix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Extra options for essay questions.';

--
-- Dumping data for table `mdl_qtype_essay_options`
--


--
-- Table structure for table `mdl_qtype_match_options`
--

CREATE TABLE `mdl_qtype_match_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_qtypmatcopti_que_uix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines the question-type specific options for matching ques';

--
-- Dumping data for table `mdl_qtype_match_options`
--


--
-- Table structure for table `mdl_qtype_match_subquestions`
--

CREATE TABLE `mdl_qtype_match_subquestions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `questiontext` longtext NOT NULL,
  `questiontextformat` tinyint(2) NOT NULL DEFAULT 0,
  `answertext` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_qtypmatcsubq_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The subquestions that make up a matching question';

--
-- Dumping data for table `mdl_qtype_match_subquestions`
--


--
-- Table structure for table `mdl_qtype_multichoice_options`
--

CREATE TABLE `mdl_qtype_multichoice_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `layout` smallint(4) NOT NULL DEFAULT 0,
  `single` smallint(4) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `answernumbering` varchar(10) NOT NULL DEFAULT 'abc',
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  `showstandardinstruction` tinyint(2) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_qtypmultopti_que_uix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for multiple choice questions';

--
-- Dumping data for table `mdl_qtype_multichoice_options`
--


--
-- Table structure for table `mdl_qtype_ordering_options`
--

CREATE TABLE `mdl_qtype_ordering_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `layouttype` tinyint(2) NOT NULL DEFAULT 0,
  `selecttype` tinyint(2) NOT NULL DEFAULT 0,
  `selectcount` smallint(4) NOT NULL DEFAULT 2,
  `gradingtype` tinyint(2) NOT NULL DEFAULT 0,
  `showgrading` tinyint(2) NOT NULL DEFAULT 0,
  `numberingstyle` varchar(10) NOT NULL DEFAULT 'none',
  `correctfeedback` longtext DEFAULT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext DEFAULT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext DEFAULT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_qtypordeopti_que_uix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for ordering questions';

--
-- Dumping data for table `mdl_qtype_ordering_options`
--


--
-- Table structure for table `mdl_qtype_randomsamatch_options`
--

CREATE TABLE `mdl_qtype_randomsamatch_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `choose` bigint(10) NOT NULL DEFAULT 4,
  `subcats` tinyint(2) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_qtyprandopti_que_uix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Info about a random short-answer matching question';

--
-- Dumping data for table `mdl_qtype_randomsamatch_options`
--


--
-- Table structure for table `mdl_qtype_shortanswer_options`
--

CREATE TABLE `mdl_qtype_shortanswer_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `usecase` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_qtypshoropti_que_uix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for short answer questions';

--
-- Dumping data for table `mdl_qtype_shortanswer_options`
--


--
-- Table structure for table `mdl_question`
--

CREATE TABLE `mdl_question` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `parent` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `questiontext` longtext NOT NULL,
  `questiontextformat` tinyint(2) NOT NULL DEFAULT 0,
  `generalfeedback` longtext NOT NULL,
  `generalfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `defaultmark` decimal(12,7) NOT NULL DEFAULT 1.0000000,
  `penalty` decimal(12,7) NOT NULL DEFAULT 0.3333333,
  `qtype` varchar(20) NOT NULL DEFAULT '',
  `length` bigint(10) NOT NULL DEFAULT 1,
  `stamp` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `createdby` bigint(10) DEFAULT NULL,
  `modifiedby` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ques_qty_ix` (`qtype`),
  KEY `mdl_ques_par_ix` (`parent`),
  KEY `mdl_ques_cre_ix` (`createdby`),
  KEY `mdl_ques_mod_ix` (`modifiedby`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table stores the definition of one version of a questio';

--
-- Dumping data for table `mdl_question`
--


--
-- Table structure for table `mdl_question_answers`
--

CREATE TABLE `mdl_question_answers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `answer` longtext NOT NULL,
  `answerformat` tinyint(2) NOT NULL DEFAULT 0,
  `fraction` decimal(12,7) NOT NULL DEFAULT 0.0000000,
  `feedback` longtext NOT NULL,
  `feedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quesansw_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Answers, with a fractional grade (0-1) and feedback';

--
-- Dumping data for table `mdl_question_answers`
--


--
-- Table structure for table `mdl_question_attempt_step_data`
--

CREATE TABLE `mdl_question_attempt_step_data` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `attemptstepid` bigint(10) NOT NULL,
  `name` varchar(32) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesattestepdata_att_ix` (`attemptstepid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each question_attempt_step has an associative array of the d';

--
-- Dumping data for table `mdl_question_attempt_step_data`
--


--
-- Table structure for table `mdl_question_attempt_steps`
--

CREATE TABLE `mdl_question_attempt_steps` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionattemptid` bigint(10) NOT NULL,
  `sequencenumber` bigint(10) NOT NULL,
  `state` varchar(13) NOT NULL DEFAULT '',
  `fraction` decimal(12,7) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `userid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quesattestep_queseq_uix` (`questionattemptid`,`sequencenumber`),
  KEY `mdl_quesattestep_que_ix` (`questionattemptid`),
  KEY `mdl_quesattestep_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores one step in in a question attempt. As well as the dat';

--
-- Dumping data for table `mdl_question_attempt_steps`
--


--
-- Table structure for table `mdl_question_attempts`
--

CREATE TABLE `mdl_question_attempts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionusageid` bigint(10) NOT NULL,
  `slot` bigint(10) NOT NULL,
  `behaviour` varchar(32) NOT NULL DEFAULT '',
  `questionid` bigint(10) NOT NULL,
  `variant` bigint(10) NOT NULL DEFAULT 1,
  `maxmark` decimal(12,7) NOT NULL,
  `minfraction` decimal(12,7) NOT NULL,
  `maxfraction` decimal(12,7) NOT NULL DEFAULT 1.0000000,
  `flagged` tinyint(1) NOT NULL DEFAULT 0,
  `questionsummary` longtext DEFAULT NULL,
  `rightanswer` longtext DEFAULT NULL,
  `responsesummary` longtext DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quesatte_queslo_uix` (`questionusageid`,`slot`),
  KEY `mdl_quesatte_beh_ix` (`behaviour`),
  KEY `mdl_quesatte_que_ix` (`questionid`),
  KEY `mdl_quesatte_que2_ix` (`questionusageid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each row here corresponds to an attempt at one question, as ';

--
-- Dumping data for table `mdl_question_attempts`
--


--
-- Table structure for table `mdl_question_bank_entries`
--

CREATE TABLE `mdl_question_bank_entries` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questioncategoryid` bigint(10) NOT NULL DEFAULT 0,
  `idnumber` varchar(100) DEFAULT NULL,
  `ownerid` bigint(10) DEFAULT NULL,
  `nextversion` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quesbankentr_queidn_uix` (`questioncategoryid`,`idnumber`),
  KEY `mdl_quesbankentr_que_ix` (`questioncategoryid`),
  KEY `mdl_quesbankentr_own_ix` (`ownerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each question bank entry. This table has one row for each qu';

--
-- Dumping data for table `mdl_question_bank_entries`
--


--
-- Table structure for table `mdl_question_calculated`
--

CREATE TABLE `mdl_question_calculated` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `answer` bigint(10) NOT NULL DEFAULT 0,
  `tolerance` varchar(20) NOT NULL DEFAULT '0.0',
  `tolerancetype` bigint(10) NOT NULL DEFAULT 1,
  `correctanswerlength` bigint(10) NOT NULL DEFAULT 2,
  `correctanswerformat` bigint(10) NOT NULL DEFAULT 2,
  PRIMARY KEY (`id`),
  KEY `mdl_quescalc_ans_ix` (`answer`),
  KEY `mdl_quescalc_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for questions of type calculated';

--
-- Dumping data for table `mdl_question_calculated`
--


--
-- Table structure for table `mdl_question_calculated_options`
--

CREATE TABLE `mdl_question_calculated_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `synchronize` tinyint(2) NOT NULL DEFAULT 0,
  `single` smallint(4) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 0,
  `correctfeedback` longtext DEFAULT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext DEFAULT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext DEFAULT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `answernumbering` varchar(10) NOT NULL DEFAULT 'abc',
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quescalcopti_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for questions of type calculated';

--
-- Dumping data for table `mdl_question_calculated_options`
--


--
-- Table structure for table `mdl_question_categories`
--

CREATE TABLE `mdl_question_categories` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `contextid` bigint(10) NOT NULL DEFAULT 0,
  `info` longtext NOT NULL,
  `infoformat` tinyint(2) NOT NULL DEFAULT 0,
  `stamp` varchar(255) NOT NULL DEFAULT '',
  `parent` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 999,
  `idnumber` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quescate_consta_uix` (`contextid`,`stamp`),
  UNIQUE KEY `mdl_quescate_conidn_uix` (`contextid`,`idnumber`),
  KEY `mdl_quescate_con_ix` (`contextid`),
  KEY `mdl_quescate_par_ix` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Categories are for grouping questions';

--
-- Dumping data for table `mdl_question_categories`
--


--
-- Table structure for table `mdl_question_dataset_definitions`
--

CREATE TABLE `mdl_question_dataset_definitions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `category` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` bigint(10) NOT NULL DEFAULT 0,
  `options` varchar(255) NOT NULL DEFAULT '',
  `itemcount` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quesdatadefi_cat_ix` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Organises and stores properties for dataset items';

--
-- Dumping data for table `mdl_question_dataset_definitions`
--


--
-- Table structure for table `mdl_question_dataset_items`
--

CREATE TABLE `mdl_question_dataset_items` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `definition` bigint(10) NOT NULL DEFAULT 0,
  `itemnumber` bigint(10) NOT NULL DEFAULT 0,
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_quesdataitem_def_ix` (`definition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Individual dataset items';

--
-- Dumping data for table `mdl_question_dataset_items`
--


--
-- Table structure for table `mdl_question_datasets`
--

CREATE TABLE `mdl_question_datasets` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `datasetdefinition` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quesdata_quedat_ix` (`question`,`datasetdefinition`),
  KEY `mdl_quesdata_que_ix` (`question`),
  KEY `mdl_quesdata_dat_ix` (`datasetdefinition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Many-many relation between questions and dataset definitions';

--
-- Dumping data for table `mdl_question_datasets`
--


--
-- Table structure for table `mdl_question_ddwtos`
--

CREATE TABLE `mdl_question_ddwtos` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quesddwt_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines drag and drop (words into sentences) questions';

--
-- Dumping data for table `mdl_question_ddwtos`
--


--
-- Table structure for table `mdl_question_gapselect`
--

CREATE TABLE `mdl_question_gapselect` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 1,
  `correctfeedback` longtext NOT NULL,
  `correctfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `partiallycorrectfeedback` longtext NOT NULL,
  `partiallycorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `incorrectfeedback` longtext NOT NULL,
  `incorrectfeedbackformat` tinyint(2) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quesgaps_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines select missing words questions';

--
-- Dumping data for table `mdl_question_gapselect`
--


--
-- Table structure for table `mdl_question_hints`
--

CREATE TABLE `mdl_question_hints` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL,
  `hint` longtext NOT NULL,
  `hintformat` smallint(4) NOT NULL DEFAULT 0,
  `shownumcorrect` tinyint(1) DEFAULT NULL,
  `clearwrong` tinyint(1) DEFAULT NULL,
  `options` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_queshint_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the the part of the question definition that gives di';

--
-- Dumping data for table `mdl_question_hints`
--


--
-- Table structure for table `mdl_question_multianswer`
--

CREATE TABLE `mdl_question_multianswer` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `sequence` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesmult_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for multianswer questions';

--
-- Dumping data for table `mdl_question_multianswer`
--


--
-- Table structure for table `mdl_question_numerical`
--

CREATE TABLE `mdl_question_numerical` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `answer` bigint(10) NOT NULL DEFAULT 0,
  `tolerance` varchar(255) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`id`),
  KEY `mdl_quesnume_ans_ix` (`answer`),
  KEY `mdl_quesnume_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for numerical questions.';

--
-- Dumping data for table `mdl_question_numerical`
--


--
-- Table structure for table `mdl_question_numerical_options`
--

CREATE TABLE `mdl_question_numerical_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `showunits` smallint(4) NOT NULL DEFAULT 0,
  `unitsleft` smallint(4) NOT NULL DEFAULT 0,
  `unitgradingtype` smallint(4) NOT NULL DEFAULT 0,
  `unitpenalty` decimal(12,7) NOT NULL DEFAULT 0.1000000,
  PRIMARY KEY (`id`),
  KEY `mdl_quesnumeopti_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for questions of type numerical This table is also u';

--
-- Dumping data for table `mdl_question_numerical_options`
--


--
-- Table structure for table `mdl_question_numerical_units`
--

CREATE TABLE `mdl_question_numerical_units` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `multiplier` decimal(38,19) NOT NULL DEFAULT 1.0000000000000000000,
  `unit` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quesnumeunit_queuni_uix` (`question`,`unit`),
  KEY `mdl_quesnumeunit_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Optional unit options for numerical questions. This table is';

--
-- Dumping data for table `mdl_question_numerical_units`
--


--
-- Table structure for table `mdl_question_references`
--

CREATE TABLE `mdl_question_references` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `usingcontextid` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) DEFAULT NULL,
  `questionarea` varchar(50) DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `questionbankentryid` bigint(10) NOT NULL DEFAULT 0,
  `version` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quesrefe_usicomqueite_uix` (`usingcontextid`,`component`,`questionarea`,`itemid`),
  KEY `mdl_quesrefe_usi_ix` (`usingcontextid`),
  KEY `mdl_quesrefe_que_ix` (`questionbankentryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Records where a specific question is used.';

--
-- Dumping data for table `mdl_question_references`
--


--
-- Table structure for table `mdl_question_response_analysis`
--

CREATE TABLE `mdl_question_response_analysis` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `hashcode` varchar(40) NOT NULL DEFAULT '',
  `whichtries` varchar(255) NOT NULL DEFAULT '',
  `timemodified` bigint(10) NOT NULL,
  `questionid` bigint(10) NOT NULL,
  `variant` bigint(10) DEFAULT NULL,
  `subqid` varchar(100) NOT NULL DEFAULT '',
  `aid` varchar(100) DEFAULT NULL,
  `response` longtext DEFAULT NULL,
  `credit` decimal(15,5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesrespanal_has_ix` (`hashcode`),
  KEY `mdl_quesrespanal_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Analysis of student responses given to questions.';

--
-- Dumping data for table `mdl_question_response_analysis`
--


--
-- Table structure for table `mdl_question_response_count`
--

CREATE TABLE `mdl_question_response_count` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `analysisid` bigint(10) NOT NULL,
  `try` bigint(10) NOT NULL,
  `rcount` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesrespcoun_ana_ix` (`analysisid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Count for each responses for each try at a question.';

--
-- Dumping data for table `mdl_question_response_count`
--


--
-- Table structure for table `mdl_question_set_references`
--

CREATE TABLE `mdl_question_set_references` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `usingcontextid` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) DEFAULT NULL,
  `questionarea` varchar(50) DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `questionscontextid` bigint(10) NOT NULL DEFAULT 0,
  `filtercondition` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quessetrefe_usicomquei_uix` (`usingcontextid`,`component`,`questionarea`,`itemid`),
  KEY `mdl_quessetrefe_usi_ix` (`usingcontextid`),
  KEY `mdl_quessetrefe_que_ix` (`questionscontextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Records where groups of questions are used.';

--
-- Dumping data for table `mdl_question_set_references`
--


--
-- Table structure for table `mdl_question_statistics`
--

CREATE TABLE `mdl_question_statistics` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `hashcode` varchar(40) NOT NULL DEFAULT '',
  `timemodified` bigint(10) NOT NULL,
  `questionid` bigint(10) NOT NULL,
  `slot` bigint(10) DEFAULT NULL,
  `subquestion` smallint(4) NOT NULL,
  `variant` bigint(10) DEFAULT NULL,
  `s` bigint(10) NOT NULL DEFAULT 0,
  `effectiveweight` decimal(15,5) DEFAULT NULL,
  `negcovar` tinyint(2) NOT NULL DEFAULT 0,
  `discriminationindex` decimal(15,5) DEFAULT NULL,
  `discriminativeefficiency` decimal(15,5) DEFAULT NULL,
  `sd` decimal(15,10) DEFAULT NULL,
  `facility` decimal(15,10) DEFAULT NULL,
  `subquestions` longtext DEFAULT NULL,
  `maxmark` decimal(12,7) DEFAULT NULL,
  `positions` longtext DEFAULT NULL,
  `randomguessscore` decimal(12,7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesstat_has_ix` (`hashcode`),
  KEY `mdl_quesstat_que_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Statistics for individual questions used in an activity.';

--
-- Dumping data for table `mdl_question_statistics`
--


--
-- Table structure for table `mdl_question_truefalse`
--

CREATE TABLE `mdl_question_truefalse` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `trueanswer` bigint(10) NOT NULL DEFAULT 0,
  `falseanswer` bigint(10) NOT NULL DEFAULT 0,
  `showstandardinstruction` tinyint(2) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `mdl_questrue_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Options for True-False questions';

--
-- Dumping data for table `mdl_question_truefalse`
--


--
-- Table structure for table `mdl_question_usages`
--

CREATE TABLE `mdl_question_usages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `component` varchar(255) NOT NULL DEFAULT '',
  `preferredbehaviour` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_quesusag_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table''s main purpose it to assign a unique id to each a';

--
-- Dumping data for table `mdl_question_usages`
--


--
-- Table structure for table `mdl_question_versions`
--

CREATE TABLE `mdl_question_versions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionbankentryid` bigint(10) NOT NULL DEFAULT 0,
  `version` bigint(10) NOT NULL DEFAULT 1,
  `questionid` bigint(10) NOT NULL DEFAULT 0,
  `status` varchar(10) NOT NULL DEFAULT 'ready',
  PRIMARY KEY (`id`),
  KEY `mdl_quesvers_que_ix` (`questionbankentryid`),
  KEY `mdl_quesvers_que2_ix` (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='A join table linking the different question version definiti';

--
-- Dumping data for table `mdl_question_versions`
--


--
-- Table structure for table `mdl_quiz`
--

CREATE TABLE `mdl_quiz` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `timeopen` bigint(10) NOT NULL DEFAULT 0,
  `timeclose` bigint(10) NOT NULL DEFAULT 0,
  `timelimit` bigint(10) NOT NULL DEFAULT 0,
  `overduehandling` varchar(16) NOT NULL DEFAULT 'autoabandon',
  `graceperiod` bigint(10) NOT NULL DEFAULT 0,
  `preferredbehaviour` varchar(32) NOT NULL DEFAULT '',
  `canredoquestions` smallint(4) NOT NULL DEFAULT 0,
  `attempts` mediumint(6) NOT NULL DEFAULT 0,
  `attemptonlast` smallint(4) NOT NULL DEFAULT 0,
  `grademethod` smallint(4) NOT NULL DEFAULT 1,
  `decimalpoints` smallint(4) NOT NULL DEFAULT 2,
  `questiondecimalpoints` smallint(4) NOT NULL DEFAULT -1,
  `reviewattempt` mediumint(6) NOT NULL DEFAULT 0,
  `reviewcorrectness` mediumint(6) NOT NULL DEFAULT 0,
  `reviewmaxmarks` mediumint(6) NOT NULL DEFAULT 0,
  `reviewmarks` mediumint(6) NOT NULL DEFAULT 0,
  `reviewspecificfeedback` mediumint(6) NOT NULL DEFAULT 0,
  `reviewgeneralfeedback` mediumint(6) NOT NULL DEFAULT 0,
  `reviewrightanswer` mediumint(6) NOT NULL DEFAULT 0,
  `reviewoverallfeedback` mediumint(6) NOT NULL DEFAULT 0,
  `questionsperpage` bigint(10) NOT NULL DEFAULT 0,
  `navmethod` varchar(16) NOT NULL DEFAULT 'free',
  `shuffleanswers` smallint(4) NOT NULL DEFAULT 0,
  `sumgrades` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `grade` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `password` varchar(255) NOT NULL DEFAULT '',
  `subnet` varchar(255) NOT NULL DEFAULT '',
  `browsersecurity` varchar(32) NOT NULL DEFAULT '',
  `delay1` bigint(10) NOT NULL DEFAULT 0,
  `delay2` bigint(10) NOT NULL DEFAULT 0,
  `showuserpicture` smallint(4) NOT NULL DEFAULT 0,
  `showblocks` smallint(4) NOT NULL DEFAULT 0,
  `completionattemptsexhausted` tinyint(1) DEFAULT 0,
  `completionminattempts` bigint(10) NOT NULL DEFAULT 0,
  `allowofflineattempts` tinyint(1) DEFAULT 0,
  `precreateattempts` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quiz_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The settings for each quiz.';

--
-- Dumping data for table `mdl_quiz`
--


--
-- Table structure for table `mdl_quiz_attempts`
--

CREATE TABLE `mdl_quiz_attempts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quiz` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `attempt` mediumint(6) NOT NULL DEFAULT 0,
  `uniqueid` bigint(10) NOT NULL DEFAULT 0,
  `layout` longtext NOT NULL,
  `currentpage` bigint(10) NOT NULL DEFAULT 0,
  `preview` smallint(3) NOT NULL DEFAULT 0,
  `state` varchar(16) NOT NULL DEFAULT 'inprogress',
  `timestart` bigint(10) NOT NULL DEFAULT 0,
  `timefinish` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `timemodifiedoffline` bigint(10) NOT NULL DEFAULT 0,
  `timecheckstate` bigint(10) DEFAULT 0,
  `sumgrades` decimal(10,5) DEFAULT NULL,
  `gradednotificationsenttime` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quizatte_quiuseatt_uix` (`quiz`,`userid`,`attempt`),
  UNIQUE KEY `mdl_quizatte_uni_uix` (`uniqueid`),
  KEY `mdl_quizatte_statim_ix` (`state`,`timecheckstate`),
  KEY `mdl_quizatte_qui_ix` (`quiz`),
  KEY `mdl_quizatte_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores users attempts at quizzes.';

--
-- Dumping data for table `mdl_quiz_attempts`
--


--
-- Table structure for table `mdl_quiz_feedback`
--

CREATE TABLE `mdl_quiz_feedback` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quizid` bigint(10) NOT NULL DEFAULT 0,
  `feedbacktext` longtext NOT NULL,
  `feedbacktextformat` tinyint(2) NOT NULL DEFAULT 0,
  `mingrade` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `maxgrade` decimal(10,5) NOT NULL DEFAULT 0.00000,
  PRIMARY KEY (`id`),
  KEY `mdl_quizfeed_qui_ix` (`quizid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Feedback given to students based on which grade band their o';

--
-- Dumping data for table `mdl_quiz_feedback`
--


--
-- Table structure for table `mdl_quiz_grade_items`
--

CREATE TABLE `mdl_quiz_grade_items` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quizid` bigint(10) NOT NULL,
  `sortorder` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quizgraditem_quisor_uix` (`quizid`,`sortorder`),
  KEY `mdl_quizgraditem_qui_ix` (`quizid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Where a quiz supports mulitple grades, this table stores wha';

--
-- Dumping data for table `mdl_quiz_grade_items`
--


--
-- Table structure for table `mdl_quiz_grades`
--

CREATE TABLE `mdl_quiz_grades` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quiz` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `grade` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quizgrad_use_ix` (`userid`),
  KEY `mdl_quizgrad_qui_ix` (`quiz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the overall grade for each user on the quiz, based on';

--
-- Dumping data for table `mdl_quiz_grades`
--


--
-- Table structure for table `mdl_quiz_overrides`
--

CREATE TABLE `mdl_quiz_overrides` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quiz` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) DEFAULT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `timeopen` bigint(10) DEFAULT NULL,
  `timeclose` bigint(10) DEFAULT NULL,
  `timelimit` bigint(10) DEFAULT NULL,
  `attempts` mediumint(6) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quizover_qui_ix` (`quiz`),
  KEY `mdl_quizover_gro_ix` (`groupid`),
  KEY `mdl_quizover_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The overrides to quiz settings on a per-user and per-group b';

--
-- Dumping data for table `mdl_quiz_overrides`
--


--
-- Table structure for table `mdl_quiz_overview_regrades`
--

CREATE TABLE `mdl_quiz_overview_regrades` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionusageid` bigint(10) NOT NULL,
  `slot` bigint(10) NOT NULL,
  `newfraction` decimal(12,7) DEFAULT NULL,
  `oldfraction` decimal(12,7) DEFAULT NULL,
  `regraded` smallint(4) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quizoverregr_queslo_ix` (`questionusageid`,`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table records which question attempts need regrading an';

--
-- Dumping data for table `mdl_quiz_overview_regrades`
--


--
-- Table structure for table `mdl_quiz_reports`
--

CREATE TABLE `mdl_quiz_reports` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `displayorder` bigint(10) NOT NULL,
  `capability` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quizrepo_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Lists all the installed quiz reports and their display order';

--
-- Dumping data for table `mdl_quiz_reports`
--

INSERT INTO `mdl_quiz_reports` VALUES (1,'grading',6000,'mod/quiz:grade'),(2,'overview',10000,NULL),(3,'responses',9000,NULL),(4,'statistics',8000,'quiz/statistics:view');

--
-- Table structure for table `mdl_quiz_sections`
--

CREATE TABLE `mdl_quiz_sections` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quizid` bigint(10) NOT NULL,
  `firstslot` bigint(10) NOT NULL,
  `heading` varchar(1333) DEFAULT NULL,
  `shufflequestions` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quizsect_quifir_uix` (`quizid`,`firstslot`),
  KEY `mdl_quizsect_qui_ix` (`quizid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores sections of a quiz with section name (heading), from ';

--
-- Dumping data for table `mdl_quiz_sections`
--


--
-- Table structure for table `mdl_quiz_slots`
--

CREATE TABLE `mdl_quiz_slots` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `slot` bigint(10) NOT NULL,
  `quizid` bigint(10) NOT NULL DEFAULT 0,
  `page` bigint(10) NOT NULL,
  `displaynumber` varchar(16) DEFAULT NULL,
  `requireprevious` smallint(4) NOT NULL DEFAULT 0,
  `maxmark` decimal(12,7) NOT NULL DEFAULT 0.0000000,
  `quizgradeitemid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quizslot_quislo_uix` (`quizid`,`slot`),
  KEY `mdl_quizslot_qui_ix` (`quizid`),
  KEY `mdl_quizslot_qui2_ix` (`quizgradeitemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the question used in a quiz, with the order, and for ';

--
-- Dumping data for table `mdl_quiz_slots`
--


--
-- Table structure for table `mdl_quiz_statistics`
--

CREATE TABLE `mdl_quiz_statistics` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `hashcode` varchar(40) NOT NULL DEFAULT '',
  `whichattempts` smallint(4) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `firstattemptscount` bigint(10) NOT NULL,
  `highestattemptscount` bigint(10) NOT NULL,
  `lastattemptscount` bigint(10) NOT NULL,
  `allattemptscount` bigint(10) NOT NULL,
  `firstattemptsavg` decimal(15,5) DEFAULT NULL,
  `highestattemptsavg` decimal(15,5) DEFAULT NULL,
  `lastattemptsavg` decimal(15,5) DEFAULT NULL,
  `allattemptsavg` decimal(15,5) DEFAULT NULL,
  `median` decimal(15,5) DEFAULT NULL,
  `standarddeviation` decimal(15,5) DEFAULT NULL,
  `skewness` decimal(15,10) DEFAULT NULL,
  `kurtosis` decimal(15,5) DEFAULT NULL,
  `cic` decimal(15,10) DEFAULT NULL,
  `errorratio` decimal(15,10) DEFAULT NULL,
  `standarderror` decimal(15,10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quizstat_has_ix` (`hashcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='table to cache results from analysis done in statistics repo';

--
-- Dumping data for table `mdl_quiz_statistics`
--


--
-- Table structure for table `mdl_quizaccess_seb_quizsettings`
--

CREATE TABLE `mdl_quizaccess_seb_quizsettings` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `quizid` bigint(10) NOT NULL,
  `cmid` bigint(10) NOT NULL,
  `templateid` bigint(10) NOT NULL,
  `requiresafeexambrowser` tinyint(1) NOT NULL,
  `showsebtaskbar` tinyint(1) DEFAULT NULL,
  `showwificontrol` tinyint(1) DEFAULT NULL,
  `showreloadbutton` tinyint(1) DEFAULT NULL,
  `showtime` tinyint(1) DEFAULT NULL,
  `showkeyboardlayout` tinyint(1) DEFAULT NULL,
  `allowuserquitseb` tinyint(1) DEFAULT NULL,
  `quitpassword` longtext DEFAULT NULL,
  `linkquitseb` longtext DEFAULT NULL,
  `userconfirmquit` tinyint(1) DEFAULT NULL,
  `enableaudiocontrol` tinyint(1) DEFAULT NULL,
  `muteonstartup` tinyint(1) DEFAULT NULL,
  `allowcapturecamera` tinyint(1) DEFAULT NULL,
  `allowcapturemicrophone` tinyint(1) DEFAULT NULL,
  `allowspellchecking` tinyint(1) DEFAULT NULL,
  `allowreloadinexam` tinyint(1) DEFAULT NULL,
  `activateurlfiltering` tinyint(1) DEFAULT NULL,
  `filterembeddedcontent` tinyint(1) DEFAULT NULL,
  `expressionsallowed` longtext DEFAULT NULL,
  `regexallowed` longtext DEFAULT NULL,
  `expressionsblocked` longtext DEFAULT NULL,
  `regexblocked` longtext DEFAULT NULL,
  `allowedbrowserexamkeys` longtext DEFAULT NULL,
  `showsebdownloadlink` tinyint(1) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quizsebquiz_qui_uix` (`quizid`),
  UNIQUE KEY `mdl_quizsebquiz_cmi_uix` (`cmid`),
  KEY `mdl_quizsebquiz_tem_ix` (`templateid`),
  KEY `mdl_quizsebquiz_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the quiz level Safe Exam Browser configuration.';

--
-- Dumping data for table `mdl_quizaccess_seb_quizsettings`
--


--
-- Table structure for table `mdl_quizaccess_seb_template`
--

CREATE TABLE `mdl_quizaccess_seb_template` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `content` longtext NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `sortorder` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_quizsebtemp_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Templates for Safe Exam Browser configuration.';

--
-- Dumping data for table `mdl_quizaccess_seb_template`
--


--
-- Table structure for table `mdl_rating`
--

CREATE TABLE `mdl_rating` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `ratingarea` varchar(50) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `scaleid` bigint(10) NOT NULL,
  `rating` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_rati_comratconite_ix` (`component`,`ratingarea`,`contextid`,`itemid`),
  KEY `mdl_rati_con_ix` (`contextid`),
  KEY `mdl_rati_use_ix` (`userid`),
  KEY `mdl_rati_sca_ix` (`scaleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='moodle ratings';

--
-- Dumping data for table `mdl_rating`
--


--
-- Table structure for table `mdl_registration_hubs`
--

CREATE TABLE `mdl_registration_hubs` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL DEFAULT '',
  `hubname` varchar(255) NOT NULL DEFAULT '',
  `huburl` varchar(255) NOT NULL DEFAULT '',
  `confirmed` tinyint(1) NOT NULL DEFAULT 0,
  `secret` varchar(255) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='hub where the site is registered on with their associated to';

--
-- Dumping data for table `mdl_registration_hubs`
--


--
-- Table structure for table `mdl_reportbuilder_audience`
--

CREATE TABLE `mdl_reportbuilder_audience` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `reportid` bigint(10) NOT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `classname` varchar(255) NOT NULL DEFAULT '',
  `configdata` longtext NOT NULL,
  `usercreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_repoaudi_rep_ix` (`reportid`),
  KEY `mdl_repoaudi_use_ix` (`usercreated`),
  KEY `mdl_repoaudi_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines report audience';

--
-- Dumping data for table `mdl_reportbuilder_audience`
--


--
-- Table structure for table `mdl_reportbuilder_column`
--

CREATE TABLE `mdl_reportbuilder_column` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `reportid` bigint(10) NOT NULL DEFAULT 0,
  `uniqueidentifier` varchar(255) NOT NULL DEFAULT '',
  `aggregation` varchar(32) DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `columnorder` bigint(10) NOT NULL,
  `sortenabled` tinyint(1) NOT NULL DEFAULT 0,
  `sortdirection` tinyint(1) NOT NULL,
  `sortorder` bigint(10) DEFAULT NULL,
  `usercreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_repocolu_rep_ix` (`reportid`),
  KEY `mdl_repocolu_use_ix` (`usercreated`),
  KEY `mdl_repocolu_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to represent a report column';

--
-- Dumping data for table `mdl_reportbuilder_column`
--


--
-- Table structure for table `mdl_reportbuilder_filter`
--

CREATE TABLE `mdl_reportbuilder_filter` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `reportid` bigint(10) NOT NULL DEFAULT 0,
  `uniqueidentifier` varchar(255) NOT NULL DEFAULT '',
  `heading` varchar(255) DEFAULT NULL,
  `iscondition` tinyint(1) NOT NULL DEFAULT 0,
  `filterorder` bigint(10) NOT NULL,
  `usercreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_repofilt_repuniisc_uix` (`reportid`,`uniqueidentifier`,`iscondition`),
  KEY `mdl_repofilt_rep_ix` (`reportid`),
  KEY `mdl_repofilt_use_ix` (`usercreated`),
  KEY `mdl_repofilt_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to represent a report filter/condition';

--
-- Dumping data for table `mdl_reportbuilder_filter`
--


--
-- Table structure for table `mdl_reportbuilder_report`
--

CREATE TABLE `mdl_reportbuilder_report` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `source` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(2) NOT NULL DEFAULT 0,
  `uniquerows` tinyint(1) NOT NULL DEFAULT 0,
  `conditiondata` longtext DEFAULT NULL,
  `settingsdata` longtext DEFAULT NULL,
  `contextid` bigint(10) NOT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `area` varchar(100) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL DEFAULT 0,
  `usercreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_reporepo_use_ix` (`usercreated`),
  KEY `mdl_reporepo_use2_ix` (`usermodified`),
  KEY `mdl_reporepo_con_ix` (`contextid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to represent a report';

--
-- Dumping data for table `mdl_reportbuilder_report`
--

INSERT INTO `mdl_reportbuilder_report` VALUES (1,NULL,'core_admin\\reportbuilder\\local\\systemreports\\users',1,0,NULL,NULL,1,'','',0,2,2,1785890094,1785890094),(2,NULL,'core_badges\\reportbuilder\\local\\systemreports\\badges',1,0,NULL,NULL,21,'','',0,2,2,1785962138,1785962138);

--
-- Table structure for table `mdl_reportbuilder_schedule`
--

CREATE TABLE `mdl_reportbuilder_schedule` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `reportid` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `audiences` longtext NOT NULL,
  `format` varchar(255) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `message` longtext NOT NULL,
  `messageformat` bigint(10) NOT NULL,
  `userviewas` bigint(10) NOT NULL DEFAULT 0,
  `timescheduled` bigint(10) NOT NULL DEFAULT 0,
  `recurrence` bigint(10) NOT NULL DEFAULT 0,
  `reportempty` bigint(10) NOT NULL DEFAULT 0,
  `timelastsent` bigint(10) NOT NULL DEFAULT 0,
  `timenextsend` bigint(10) NOT NULL DEFAULT 0,
  `usercreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_reposche_rep_ix` (`reportid`),
  KEY `mdl_reposche_use_ix` (`userviewas`),
  KEY `mdl_reposche_use2_ix` (`usercreated`),
  KEY `mdl_reposche_use3_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to represent a report schedule';

--
-- Dumping data for table `mdl_reportbuilder_schedule`
--


--
-- Table structure for table `mdl_reportbuilder_user_filter`
--

CREATE TABLE `mdl_reportbuilder_user_filter` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `reportid` bigint(10) NOT NULL DEFAULT 0,
  `filterdata` longtext NOT NULL,
  `usercreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_repouserfilt_repuse_uix` (`reportid`,`usercreated`),
  KEY `mdl_repouserfilt_rep_ix` (`reportid`),
  KEY `mdl_repouserfilt_use_ix` (`usercreated`),
  KEY `mdl_repouserfilt_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines user report filter';

--
-- Dumping data for table `mdl_reportbuilder_user_filter`
--


--
-- Table structure for table `mdl_repository`
--

CREATE TABLE `mdl_repository` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL DEFAULT '',
  `visible` tinyint(1) DEFAULT 1,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table contains one entry for every configured external ';

--
-- Dumping data for table `mdl_repository`
--

INSERT INTO `mdl_repository` VALUES (1,'areafiles',1,1),(2,'contentbank',1,2),(3,'local',1,3),(4,'recent',1,4),(5,'upload',1,5),(6,'url',1,6),(7,'user',1,7),(8,'wikimedia',1,8);

--
-- Table structure for table `mdl_repository_instance_config`
--

CREATE TABLE `mdl_repository_instance_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `instanceid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The config for intances';

--
-- Dumping data for table `mdl_repository_instance_config`
--


--
-- Table structure for table `mdl_repository_onedrive_access`
--

CREATE TABLE `mdl_repository_onedrive_access` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timemodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `permissionid` varchar(255) NOT NULL DEFAULT '',
  `itemid` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_repoonedacce_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of temporary access grants.';

--
-- Dumping data for table `mdl_repository_onedrive_access`
--


--
-- Table structure for table `mdl_resource`
--

CREATE TABLE `mdl_resource` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `tobemigrated` smallint(4) NOT NULL DEFAULT 0,
  `legacyfiles` smallint(4) NOT NULL DEFAULT 0,
  `legacyfileslast` bigint(10) DEFAULT NULL,
  `display` smallint(4) NOT NULL DEFAULT 0,
  `displayoptions` longtext DEFAULT NULL,
  `filterfiles` smallint(4) NOT NULL DEFAULT 0,
  `revision` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_reso_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each record is one resource and its config data';

--
-- Dumping data for table `mdl_resource`
--


--
-- Table structure for table `mdl_resource_old`
--

CREATE TABLE `mdl_resource_old` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(30) NOT NULL DEFAULT '',
  `reference` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `alltext` longtext NOT NULL,
  `popup` longtext NOT NULL,
  `options` varchar(255) NOT NULL DEFAULT '',
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `oldid` bigint(10) NOT NULL,
  `cmid` bigint(10) DEFAULT NULL,
  `newmodule` varchar(50) DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL,
  `migrated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_resoold_old_uix` (`oldid`),
  KEY `mdl_resoold_cmi_ix` (`cmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='backup of all old resource instances from 1.9';

--
-- Dumping data for table `mdl_resource_old`
--


--
-- Table structure for table `mdl_role`
--

CREATE TABLE `mdl_role` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `shortname` varchar(100) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `archetype` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_role_sor_uix` (`sortorder`),
  UNIQUE KEY `mdl_role_sho_uix` (`shortname`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='moodle roles';

--
-- Dumping data for table `mdl_role`
--

INSERT INTO `mdl_role` VALUES (1,'','manager','',1,'manager'),(2,'','coursecreator','',2,'coursecreator'),(3,'','editingteacher','',3,'editingteacher'),(4,'','teacher','',4,'teacher'),(5,'','student','',5,'student'),(6,'','guest','',6,'guest'),(7,'','user','',7,'user'),(8,'','frontpage','',8,'frontpage');

--
-- Table structure for table `mdl_role_allow_assign`
--

CREATE TABLE `mdl_role_allow_assign` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(10) NOT NULL DEFAULT 0,
  `allowassign` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_rolealloassi_rolall_uix` (`roleid`,`allowassign`),
  KEY `mdl_rolealloassi_rol_ix` (`roleid`),
  KEY `mdl_rolealloassi_all_ix` (`allowassign`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='this defines what role can assign what role';

--
-- Dumping data for table `mdl_role_allow_assign`
--

INSERT INTO `mdl_role_allow_assign` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,3,4),(7,3,5);

--
-- Table structure for table `mdl_role_allow_override`
--

CREATE TABLE `mdl_role_allow_override` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(10) NOT NULL DEFAULT 0,
  `allowoverride` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_rolealloover_rolall_uix` (`roleid`,`allowoverride`),
  KEY `mdl_rolealloover_rol_ix` (`roleid`),
  KEY `mdl_rolealloover_all_ix` (`allowoverride`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='this defines what role can override what role';

--
-- Dumping data for table `mdl_role_allow_override`
--

INSERT INTO `mdl_role_allow_override` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,3,4),(10,3,5),(11,3,6);

--
-- Table structure for table `mdl_role_allow_switch`
--

CREATE TABLE `mdl_role_allow_switch` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(10) NOT NULL,
  `allowswitch` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_rolealloswit_rolall_uix` (`roleid`,`allowswitch`),
  KEY `mdl_rolealloswit_rol_ix` (`roleid`),
  KEY `mdl_rolealloswit_all_ix` (`allowswitch`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table stores which which other roles a user is allowed ';

--
-- Dumping data for table `mdl_role_allow_switch`
--

INSERT INTO `mdl_role_allow_switch` VALUES (1,1,3),(2,1,4),(3,1,5),(4,1,6),(5,3,4),(6,3,5),(7,3,6),(8,4,5),(9,4,6);

--
-- Table structure for table `mdl_role_allow_view`
--

CREATE TABLE `mdl_role_allow_view` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(10) NOT NULL,
  `allowview` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_rolealloview_rolall_uix` (`roleid`,`allowview`),
  KEY `mdl_rolealloview_rol_ix` (`roleid`),
  KEY `mdl_rolealloview_all_ix` (`allowview`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table stores which which other roles a user is allowed ';

--
