Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_moojla/sql/install.mysql.utf8.sql

Назад
CREATE TABLE IF NOT EXISTS `#__moojla_course` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `addcontrols` TINYINT(1) NOT NULL DEFAULT 1, `alias` CHAR(64) NOT NULL DEFAULT '', `alterurl` VARCHAR(255) NULL DEFAULT '', `autoplay` TINYINT(1) NOT NULL DEFAULT 0, `autoplayaudio` TINYINT(1) NOT NULL DEFAULT 0, `availabilityinfolink` TINYINT(1) NOT NULL DEFAULT 2, `buylbl` VARCHAR(50) NULL DEFAULT '', `cangotomoodle` TINYINT(1) NOT NULL DEFAULT 2, `cat_id` INT(10) NOT NULL DEFAULT 0, `cat_name` CHAR(255) NOT NULL DEFAULT '', `catid` INT(64) NULL DEFAULT 0, `cost` INT(50) NOT NULL DEFAULT 0, `course_detail_layout` VARCHAR(255) NOT NULL DEFAULT '', `course_templatestyle_forcourseconfig` INT(10) NOT NULL DEFAULT 0, `currency` VARCHAR(10) NOT NULL DEFAULT 0, `enddate` VARCHAR(255) NULL DEFAULT '0000-00-00 00:00:00', `enrollbl` VARCHAR(50) NULL DEFAULT '', `enterlbl` VARCHAR(50) NULL DEFAULT '', `freeenterlbl` VARCHAR(50) NULL DEFAULT '', `fullname` VARCHAR(255) NOT NULL DEFAULT '', `guest` INT(10) NOT NULL DEFAULT 0, `in_enrol_date` VARCHAR(10) NOT NULL DEFAULT '', `loginlbl` VARCHAR(50) NULL DEFAULT '', `loginurl` VARCHAR(255) NULL DEFAULT '', `muted` TINYINT(1) NOT NULL DEFAULT 0, `permanent_fields` VARCHAR(64) NOT NULL DEFAULT '', `popupbutton` TINYINT(1) NOT NULL DEFAULT 2, `preloadaudio` TINYINT(1) NOT NULL DEFAULT 0, `preloadvideo` TINYINT(1) NOT NULL DEFAULT 0, `preventdownload` TINYINT(1) NOT NULL DEFAULT 0, `preventdownloadaudio` TINYINT(1) NOT NULL DEFAULT 0, `redirect_after_enrol` TINYINT(1) NOT NULL DEFAULT 2, `registrationurl` VARCHAR(255) NULL DEFAULT '', `remoteid` INT(10) NOT NULL DEFAULT 0, `self_enrolment` VARCHAR(10) NOT NULL DEFAULT '', `shortname` VARCHAR(255) NOT NULL DEFAULT '', `showlogintab` TINYINT(1) NOT NULL DEFAULT 2, `showregtab` TINYINT(1) NOT NULL DEFAULT 2, `startdate` VARCHAR(255) NULL DEFAULT '0000-00-00 00:00:00', `summary` TEXT NOT NULL, `summary_files` MEDIUMTEXT NOT NULL, `teachers` TEXT NOT NULL, `useglobalaudio` TINYINT(1) NOT NULL DEFAULT 1, `useglobalvideo` TINYINT(1) NOT NULL DEFAULT 1, `videotype` TINYINT(1) NOT NULL DEFAULT 1, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, `metakey` TEXT NOT NULL, `metadesc` TEXT NOT NULL, `metadata` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_remoteid` (`remoteid`), KEY `idx_shortname` (`shortname`), KEY `idx_catid` (`catid`), KEY `idx_alias` (`alias`), KEY `idx_permanent_fields` (`permanent_fields`), KEY `idx_course_templatestyle_forcourseconfig` (`course_templatestyle_forcourseconfig`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_course_field_mapper` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `coursefield` INT(10) NOT NULL DEFAULT 0, `field_icon` VARCHAR(255) NOT NULL DEFAULT '', `mcoursefields` VARCHAR(64) NOT NULL DEFAULT '', `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `access` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_coursefield` (`coursefield`), KEY `idx_mcoursefields` (`mcoursefields`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_user_map` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `debug` VARCHAR(10) NULL DEFAULT '', `jid` INT(11) NOT NULL DEFAULT 0, `mid` INT(64) NOT NULL DEFAULT 0, `updatetype` TINYINT(3) NOT NULL DEFAULT 1, `userimage` VARCHAR(1024) NOT NULL DEFAULT '', `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_jid` (`jid`), KEY `idx_mid` (`mid`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_user_field_map` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `iscv` TINYINT(1) NOT NULL DEFAULT 0, `juserfields` VARCHAR(64) NOT NULL DEFAULT '', `muserfields` VARCHAR(64) NOT NULL DEFAULT '', `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_juserfields` (`juserfields`), KEY `idx_muserfields` (`muserfields`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_course_group_map` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `course_group` INT(11) NOT NULL DEFAULT 0, `moojlacourse` INT(11) NOT NULL DEFAULT 0, `role` INT(7) NOT NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_moojlacourse` (`moojlacourse`), KEY `idx_course_group` (`course_group`), KEY `idx_role` (`role`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_enrolment` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `enrolldate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `jid` INT(11) NOT NULL DEFAULT 0, `moojlacourse` INT(11) NOT NULL DEFAULT 0, `role` VARCHAR(64) NOT NULL DEFAULT '', `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_role` (`role`), KEY `idx_moojlacourse` (`moojlacourse`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_tag` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `isstandard` TINYINT(1) NOT NULL DEFAULT 0, `tagid` INT(10) NOT NULL DEFAULT 0, `tagname` VARCHAR(64) NOT NULL DEFAULT '', `tags` INT(255) NOT NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `access` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `idx_tagid` (`tagid`), KEY `idx_tagname` (`tagname`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_tag_instance` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `moodletag` INT(10) NOT NULL DEFAULT 0, `moojlacourse` INT(11) NOT NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `access` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_moojlacourse` (`moojlacourse`), KEY `idx_moodletag` (`moodletag`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_section` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `courseid` INT(10) NOT NULL DEFAULT 0, `name` VARCHAR(255) NOT NULL DEFAULT '', `section_id` INT(10) NULL DEFAULT 0, `summary` TEXT NOT NULL, `uservisible` TINYINT(1) NOT NULL DEFAULT 0, `visible` TINYINT(1) NOT NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `idx_section_id` (`section_id`), KEY `idx_courseid` (`courseid`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_module` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `description` TEXT NOT NULL, `modicon` TEXT NOT NULL, `modname` VARCHAR(255) NOT NULL DEFAULT '', `module_id` INT(10) NOT NULL DEFAULT 0, `module_section_id` INT(10) NOT NULL DEFAULT 0, `name` VARCHAR(255) NOT NULL DEFAULT '', `url` VARCHAR(255) NOT NULL DEFAULT '', `uservisible` TINYINT(1) NOT NULL DEFAULT 0, `visible` TINYINT(1) NOT NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `idx_module_id` (`module_id`), KEY `idx_module_section_id` (`module_section_id`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_content` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `contents_module_id` INT(10) NOT NULL DEFAULT 0, `file` VARCHAR(255) NOT NULL DEFAULT '', `filename` VARCHAR(255) NOT NULL DEFAULT '', `filesize` INT(64) NOT NULL DEFAULT 0, `fileurl` VARCHAR(255) NOT NULL DEFAULT '', `mimetype` VARCHAR(64) NOT NULL DEFAULT '', `type` VARCHAR(64) NOT NULL DEFAULT '', `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_contents_module_id` (`contents_module_id`), KEY `idx_type` (`type`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_category_map` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `jcatid` INT(64) NULL DEFAULT 0, `mcatid` INT(64) NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_cohort` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `course_group` INT(11) NOT NULL DEFAULT 0, `mcohort` INT(11) NOT NULL DEFAULT 0, `params` text NOT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_mcohort` (`mcohort`), KEY `idx_course_group` (`course_group`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_favorite` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `userid` INT(11) NOT NULL DEFAULT 0, `courseid` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; CREATE TABLE IF NOT EXISTS `#__moojla_rate` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `userid` INT(11) NOT NULL DEFAULT 0, `courseid` INT(11) NOT NULL DEFAULT 0, `rate` INT(4) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; -- -- Always insure this column rules is large enough for all the access control values. -- ALTER TABLE `#__assets` CHANGE `rules` `rules` TEXT NOT NULL COMMENT 'JSON encoded access control. Enlarged to TEXT by JCB';

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка