Directory:~$ /home/lmsyaran/www/administrator/components/com_moojla/sql/

Upload File

[Home] [System Details] [Kill Me]

DROP TABLE IF EXISTS `#__moojla_course`;
DROP TABLE IF EXISTS `#__moojla_course_field_mapper`;
DROP TABLE IF EXISTS `#__moojla_user_map`;
DROP TABLE IF EXISTS `#__moojla_user_field_map`;
DROP TABLE IF EXISTS `#__moojla_course_group_map`;
DROP TABLE IF EXISTS `#__moojla_enrolment`;
DROP TABLE IF EXISTS `#__moojla_tag`;
DROP TABLE IF EXISTS `#__moojla_tag_instance`;
DROP TABLE IF EXISTS `#__moojla_section`;
DROP TABLE IF EXISTS `#__moojla_module`;
DROP TABLE IF EXISTS `#__moojla_content`;
DROP TABLE IF EXISTS `#__moojla_category_map`;
DROP TABLE IF EXISTS `#__moojla_cohort`;
DROP TABLE IF EXISTS `#__moojla_favorite`;
DROP TABLE IF EXISTS `#__moojla_rate`;


--
-- Always insure this column rules is reversed to Joomla defaults on
uninstall. (as on 1st Dec 2020)
--
ALTER TABLE `#__assets` CHANGE `rules` `rules` varchar(5120) NOT NULL
COMMENT 'JSON encoded access control.';