OK. I have two installations
Clean 1.8+
and
1.64+ -> 1.7 -> 1.8+
There are differences between these two installations and I'm wondering,
should I go and confirm the suggested changes in database structures,
so that my database would be synchronized with 1.8 clean installation.
#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 19.06.2007 15:43
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: moodle_moodle18new
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: moodle_moodle18clean
# --------------------------------------------------------
#
SET FOREIGN_KEY_CHECKS = 0;
#
# DDL START
#
ALTER TABLE adodb_logsql
ADD id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment FIRST,
MODIFY sql1 text NULL DEFAULT NULL COMMENT '',
MODIFY params text NULL DEFAULT NULL COMMENT '',
MODIFY tracer text NULL DEFAULT NULL COMMENT '',
ADD PRIMARY KEY (id),
COMMENT='to save some logs from ADOdb';
#
# Fieldformats of
# adodb_logsql.sql1 changed from text NOT NULL DEFAULT '' COMMENT '' to text NULL DEFAULT NULL COMMENT ''.
# adodb_logsql.params changed from text NOT NULL DEFAULT '' COMMENT '' to text NULL DEFAULT NULL COMMENT ''.
# adodb_logsql.tracer changed from text NOT NULL DEFAULT '' COMMENT '' to text NULL DEFAULT NULL COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_assignment
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY format smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY preventlate tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY emailteachers tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY var1 bigint(10) NULL DEFAULT '0' COMMENT '',
MODIFY var2 bigint(10) NULL DEFAULT '0' COMMENT '',
MODIFY var3 bigint(10) NULL DEFAULT '0' COMMENT '',
MODIFY var4 bigint(10) NULL DEFAULT '0' COMMENT '',
MODIFY var5 bigint(10) NULL DEFAULT '0' COMMENT '',
MODIFY maxbytes bigint(10) unsigned NOT NULL DEFAULT '100000' COMMENT '',
MODIFY timedue bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeavailable bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY grade bigint(10) NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX course,
ADD INDEX mdl_assi_cou_ix (course);
#
# Fieldformats of
# mdl_assignment.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_assignment.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.format changed from tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.preventlate changed from int(2) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.emailteachers changed from int(2) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.var1 changed from int(10) NULL DEFAULT '0' COMMENT '' to bigint(10) NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.var2 changed from int(10) NULL DEFAULT '0' COMMENT '' to bigint(10) NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.var3 changed from int(10) NULL DEFAULT '0' COMMENT '' to bigint(10) NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.var4 changed from int(10) NULL DEFAULT '0' COMMENT '' to bigint(10) NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.var5 changed from int(10) NULL DEFAULT '0' COMMENT '' to bigint(10) NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.maxbytes changed from int(10) unsigned NOT NULL DEFAULT '100000' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '100000' COMMENT ''.
# mdl_assignment.timedue changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.timeavailable changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.grade changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_assignment_submissions
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY assignment bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timecreated bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY numfiles bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY grade bigint(11) NOT NULL DEFAULT '0' COMMENT '',
MODIFY format smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY teacher bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemarked bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX assignment,
DROP INDEX userid,
DROP INDEX mailed,
DROP INDEX timemarked,
ADD INDEX mdl_assisubm_use_ix (userid),
ADD INDEX mdl_assisubm_mai_ix (mailed),
ADD INDEX mdl_assisubm_tim_ix (timemarked),
ADD INDEX mdl_assisubm_ass_ix (assignment);
#
# Fieldformats of
# mdl_assignment_submissions.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_assignment_submissions.assignment changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.userid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.timecreated changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.numfiles changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.grade changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to bigint(11) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.format changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.teacher changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_assignment_submissions.timemarked changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_backup_config
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
DROP INDEX name,
ADD UNIQUE mdl_backconf_nam_uix (name);
#
# Fieldformat of
# mdl_backup_config.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# Possibly data modifications needed!
#
ALTER TABLE mdl_backup_courses
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY courseid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY laststarttime bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY lastendtime bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
ALTER laststatus SET DEFAULT 0,
MODIFY nextstarttime bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX courseid,
ADD UNIQUE mdl_backcour_cou_uix (courseid);
#
# Fieldformats of
# mdl_backup_courses.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_backup_courses.courseid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_courses.laststarttime changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_courses.lastendtime changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_courses.nextstarttime changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_backup_files
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY backup_code bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY old_id bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY new_id bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX backup_files_uk,
ADD UNIQUE mdl_backfile_bacfilpat_uix (backup_code, file_type, path),
COMMENT='To store and recode ids to user and course files';
#
# Fieldformats of
# mdl_backup_files.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_backup_files.backup_code changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_files.old_id changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_files.new_id changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_backup_ids
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY backup_code bigint(12) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY old_id bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY new_id bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX backup_ids_uk,
ADD UNIQUE mdl_backids_bactabold_uix (backup_code, table_name, old_id);
#
# Fieldformats of
# mdl_backup_ids.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_backup_ids.backup_code changed from int(12) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(12) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_ids.old_id changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_ids.new_id changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_backup_log
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY courseid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY `time` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY laststarttime bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
ADD INDEX mdl_backlog_cou_ix (courseid);
#
# Fieldformats of
# mdl_backup_log.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_backup_log.courseid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_log.time changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_backup_log.laststarttime changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_block
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY version bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY cron bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY lastcron bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
COMMENT='to store installed blocks';
#
# Fieldformats of
# mdl_block.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_block.version changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_block.cron changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_block.lastcron changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_block_instance
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY blockid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY pageid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY weight smallint(3) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX pageid,
DROP INDEX pagetype,
ADD INDEX mdl_blocinst_pag_ix (pageid),
ADD INDEX mdl_blocinst_pag2_ix (pagetype),
ADD INDEX mdl_blocinst_blo_ix (blockid),
COMMENT='to store block instances in pages';
#
# Fieldformats of
# mdl_block_instance.id changed from int(10) NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_block_instance.blockid changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_block_instance.pageid changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_block_instance.weight changed from tinyint(3) NOT NULL DEFAULT '0' COMMENT '' to smallint(3) NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_block_pinned
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY blockid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY weight smallint(3) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX pagetype,
ADD INDEX mdl_blocpinn_pag_ix (pagetype),
ADD INDEX mdl_blocpinn_blo_ix (blockid),
COMMENT='to pin blocks';
#
# Fieldformats of
# mdl_block_pinned.id changed from int(10) NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_block_pinned.blockid changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_block_pinned.weight changed from tinyint(3) NOT NULL DEFAULT '0' COMMENT '' to smallint(3) NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_block_rss_client
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY shared tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '';
#
# Fieldformats of
# mdl_block_rss_client.id changed from int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_block_rss_client.userid changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_block_rss_client.shared changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_blog_tag_instance
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY entryid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY tagid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY groupid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY courseid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX bti_entryid_idx,
DROP INDEX bti_tagid_idx,
ADD INDEX mdl_blogtaginst_ent_ix (entryid),
ADD INDEX mdl_blogtaginst_tag_ix (tagid),
COMMENT='tag instance for blogs';
#
# Fieldformats of
# mdl_blog_tag_instance.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_blog_tag_instance.entryid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_blog_tag_instance.tagid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_blog_tag_instance.groupid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_blog_tag_instance.courseid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_blog_tag_instance.userid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_blog_tag_instance.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_book
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY summary mediumtext NOT NULL DEFAULT '' COMMENT '',
MODIFY numbering smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
ALTER disableprinting SET DEFAULT 2,
MODIFY timecreated bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '';
#
# Fieldformats of
# mdl_book.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_book.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book.summary changed from text NOT NULL DEFAULT '' COMMENT '' to mediumtext NOT NULL DEFAULT '' COMMENT ''.
# mdl_book.numbering changed from tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book.timecreated changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_book_chapters
MODIFY id bigint(10) NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY bookid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY pagenum bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY subchapter bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY content longtext NOT NULL DEFAULT '' COMMENT '',
MODIFY timecreated bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY importsrc bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '';
#
# Fieldformats of
# mdl_book_chapters.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_book_chapters.bookid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book_chapters.pagenum changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book_chapters.subchapter changed from tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book_chapters.content changed from text NOT NULL DEFAULT '' COMMENT '' to longtext NOT NULL DEFAULT '' COMMENT ''.
# mdl_book_chapters.timecreated changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book_chapters.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_book_chapters.importsrc changed from varchar(255) NOT NULL DEFAULT '' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_cache_filters
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY version bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX filtermd5key,
ADD INDEX mdl_cachfilt_filmd5_ix (filter, md5key);
#
# Fieldformats of
# mdl_cache_filters.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_cache_filters.version changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_cache_filters.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_cache_text
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX md5key,
ADD INDEX mdl_cachtext_md5_ix (md5key);
#
# Fieldformats of
# mdl_cache_text.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_cache_text.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_capabilities
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY contextlevel bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY riskbitmask bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX name,
ADD UNIQUE mdl_capa_nam_uix (name),
COMMENT='this defines all capabilities';
#
# Fieldformats of
# mdl_capabilities.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_capabilities.contextlevel changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_capabilities.riskbitmask changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_chat
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY keepdays bigint(11) NOT NULL DEFAULT '0' COMMENT '',
MODIFY studentlogs smallint(4) NOT NULL DEFAULT '0' COMMENT '',
MODIFY chattime bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY schedule smallint(4) NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX course,
ADD INDEX mdl_chat_cou_ix (course);
#
# Fieldformats of
# mdl_chat.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_chat.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat.keepdays changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to bigint(11) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat.studentlogs changed from int(4) NOT NULL DEFAULT '0' COMMENT '' to smallint(4) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat.chattime changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat.schedule changed from int(4) NOT NULL DEFAULT '0' COMMENT '' to smallint(4) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_chat_messages
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY chatid bigint(10) NOT NULL DEFAULT '0' COMMENT '',
MODIFY userid bigint(10) NOT NULL DEFAULT '0' COMMENT '',
MODIFY groupid bigint(10) NOT NULL DEFAULT '0' COMMENT '',
MODIFY system tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY `timestamp` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX timemodifiedchat,
DROP INDEX chatid,
DROP INDEX userid,
DROP INDEX groupid,
ADD INDEX mdl_chatmess_use_ix (userid),
ADD INDEX mdl_chatmess_gro_ix (groupid),
ADD INDEX mdl_chatmess_timcha_ix (`timestamp`, chatid),
ADD INDEX mdl_chatmess_cha_ix (chatid);
#
# Fieldformats of
# mdl_chat_messages.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_chat_messages.chatid changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_messages.userid changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_messages.groupid changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_messages.system changed from int(1) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_messages.timestamp changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_chat_users
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY chatid bigint(11) NOT NULL DEFAULT '0' COMMENT '',
MODIFY userid bigint(11) NOT NULL DEFAULT '0' COMMENT '',
MODIFY groupid bigint(11) NOT NULL DEFAULT '0' COMMENT '',
MODIFY firstping bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY lastping bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY lastmessageping bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX userid,
DROP INDEX lastping,
DROP INDEX chatid,
DROP INDEX groupid,
ADD INDEX mdl_chatuser_use_ix (userid),
ADD INDEX mdl_chatuser_las_ix (lastping),
ADD INDEX mdl_chatuser_gro_ix (groupid),
ADD INDEX mdl_chatuser_cha_ix (chatid);
#
# Fieldformats of
# mdl_chat_users.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_chat_users.chatid changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to bigint(11) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_users.userid changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to bigint(11) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_users.groupid changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to bigint(11) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_users.firstping changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_users.lastping changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_users.lastmessageping changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_chat_users.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_choice
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY showresults tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY display smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY allowupdate tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY limitanswers tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeopen bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeclose bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
DROP INDEX course,
ADD INDEX mdl_choi_cou_ix (course),
COMMENT='Available choices are stored here';
#
# Fieldformats of
# mdl_choice.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_choice.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.showresults changed from tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.display changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.allowupdate changed from int(2) unsigned NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.limitanswers changed from tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.timeopen changed from int(10) unsigned NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.timeclose changed from int(10) unsigned NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_choice_answers
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY choiceid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY optionid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
DROP INDEX choice,
DROP INDEX userid,
ADD INDEX mdl_choiansw_use_ix (userid),
ADD INDEX mdl_choiansw_cho_ix (choiceid),
ADD INDEX mdl_choiansw_opt_ix (optionid),
COMMENT='choices performed by users';
#
# Fieldformats of
# mdl_choice_answers.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_choice_answers.choiceid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice_answers.userid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice_answers.optionid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice_answers.timemodified changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_choice_options
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY choiceid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY `text` text NULL DEFAULT NULL COMMENT '',
MODIFY maxanswers bigint(10) unsigned NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
DROP INDEX choiceid,
ADD INDEX mdl_choiopti_cho_ix (choiceid),
COMMENT='available options to choice';
#
# Fieldformats of
# mdl_choice_options.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_choice_options.choiceid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_choice_options.text changed from text NOT NULL DEFAULT '' COMMENT '' to text NULL DEFAULT NULL COMMENT ''.
# mdl_choice_options.maxanswers changed from int(10) unsigned NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NULL DEFAULT '0' COMMENT ''.
# mdl_choice_options.timemodified changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_config
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
DROP INDEX name,
ADD UNIQUE mdl_conf_nam_uix (name);
#
# Fieldformat of
# mdl_config.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# Possibly data modifications needed!
#
ALTER TABLE mdl_config_plugins
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
DROP INDEX plugin_name,
ADD UNIQUE mdl_confplug_plunam_uix (plugin, name);
#
# Fieldformat of
# mdl_config_plugins.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# Possibly data modifications needed!
#
ALTER TABLE mdl_context
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY contextlevel bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY instanceid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX instanceid,
ADD INDEX mdl_cont_ins_ix (instanceid),
COMMENT='one of these must be set';
#
# Fieldformats of
# mdl_context.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_context.contextlevel changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_context.instanceid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_context_rel
COMMENT='context relations, c2 is a parent (or higher) of c1';
ALTER TABLE mdl_course
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY category bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY sortorder bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY showgrades tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '',
MODIFY newsitems mediumint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',
MODIFY startdate bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY enrolperiod bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY numsections mediumint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',
MODIFY marker bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY maxbytes bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY showreports smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY visible tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '',
MODIFY hiddensections tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY groupmode smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY groupmodeforce smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
ALTER currency SET DEFAULT 'USD',
MODIFY timecreated bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY metacourse tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY requested tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY restrictmodules tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY expirynotify tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY expirythreshold bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY notifystudents tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY enrollable tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '',
MODIFY enrolstartdate bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY enrolenddate bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY defaultrole bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX category_sortorder,
DROP INDEX shortname,
DROP INDEX idnumber,
ADD INDEX mdl_cour_cat_ix (category),
ADD INDEX mdl_cour_idn_ix (idnumber),
ADD INDEX mdl_cour_sho_ix (shortname),
COMMENT='Central course table';
#
# Fieldformats of
# mdl_course.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course.category changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.sortorder changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.showgrades changed from smallint(2) unsigned NOT NULL DEFAULT '1' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT ''.
# mdl_course.newsitems changed from smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '' to mediumint(5) unsigned NOT NULL DEFAULT '1' COMMENT ''.
# mdl_course.startdate changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.enrolperiod changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.numsections changed from smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '' to mediumint(5) unsigned NOT NULL DEFAULT '1' COMMENT ''.
# mdl_course.marker changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.maxbytes changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.showreports changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.visible changed from int(10) unsigned NOT NULL DEFAULT '1' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT ''.
# mdl_course.hiddensections changed from int(2) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.groupmode changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.groupmodeforce changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.timecreated changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.metacourse changed from int(1) NOT NULL DEFAULT '0' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.requested changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.restrictmodules changed from int(11) NOT NULL DEFAULT '0' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.expirynotify changed from tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.expirythreshold changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.notifystudents changed from tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.enrollable changed from tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '' to tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT ''.
# mdl_course.enrolstartdate changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.enrolenddate changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course.defaultrole changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_allowed_modules
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY module bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX course,
DROP INDEX module,
ADD INDEX mdl_courallomodu_cou_ix (course),
ADD INDEX mdl_courallomodu_mod_ix (module),
COMMENT='allowed modules foreach course';
#
# Fieldformats of
# mdl_course_allowed_modules.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_allowed_modules.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_allowed_modules.module changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_categories
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY parent bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY sortorder bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY coursecount bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY depth bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
ADD INDEX mdl_courcate_par_ix (parent);
#
# Fieldformats of
# mdl_course_categories.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_categories.parent changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_categories.sortorder changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_categories.coursecount changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_categories.timemodified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_categories.depth changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_display
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY display bigint(10) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
DROP INDEX courseuserid,
ADD INDEX mdl_courdisp_couuse_ix (course, userid);
#
# Fieldformats of
# mdl_course_display.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_display.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_display.userid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_display.display changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_meta
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY parent_course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY child_course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX parent_course,
DROP INDEX child_course,
ADD INDEX mdl_courmeta_par_ix (parent_course),
ADD INDEX mdl_courmeta_chi_ix (child_course),
COMMENT='to store meta-courses relations';
#
# Fieldformats of
# mdl_course_meta.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_meta.parent_course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_meta.child_course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_modules
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY module bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY instance bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY section bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY added bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY score smallint(4) NOT NULL DEFAULT '0' COMMENT '',
MODIFY indent mediumint(5) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY visibleold tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
MODIFY groupmode smallint(4) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
DROP INDEX visible,
DROP INDEX course,
DROP INDEX module,
DROP INDEX instance,
ADD INDEX mdl_courmodu_vis_ix (visible),
ADD INDEX mdl_courmodu_cou_ix (course),
ADD INDEX mdl_courmodu_mod_ix (module),
ADD INDEX mdl_courmodu_ins_ix (instance),
COMMENT='course_modules table retrofitted from MySQL';
#
# Fieldformats of
# mdl_course_modules.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_modules.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.module changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.instance changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.section changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.added changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.score changed from tinyint(4) NOT NULL DEFAULT '0' COMMENT '' to smallint(4) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.indent changed from int(5) unsigned NOT NULL DEFAULT '0' COMMENT '' to mediumint(5) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_modules.visibleold changed from int(1) unsigned NOT NULL DEFAULT '1' COMMENT '' to tinyint(1) NOT NULL DEFAULT '1' COMMENT ''.
# mdl_course_modules.groupmode changed from tinyint(4) NOT NULL DEFAULT '0' COMMENT '' to smallint(4) NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_request
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY requester bigint(10) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX shortname,
ADD INDEX mdl_courrequ_sho_ix (shortname),
COMMENT='course requests';
#
# Fieldformats of
# mdl_course_request.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_request.requester changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_course_sections
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY section bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX coursesection,
ADD INDEX mdl_coursect_cousec_ix (course, section),
COMMENT='to define the sections for each course';
#
# Fieldformats of
# mdl_course_sections.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_course_sections.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_course_sections.section changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_data
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY course bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY comments smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeavailablefrom bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeavailableto bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeviewfrom bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timeviewto bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY rssarticles smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY approval smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY scale bigint(10) NOT NULL DEFAULT '0' COMMENT '',
MODIFY assessed bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY defaultsort bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY defaultsortdir smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY editany smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
COMMENT='Removed ratings column';
#
# Fieldformats of
# mdl_data.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_data.course changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.comments changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.timeavailablefrom changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.timeavailableto changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.timeviewfrom changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.timeviewto changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.rssarticles changed from int(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.approval changed from tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.scale changed from int(10) NOT NULL DEFAULT '0' COMMENT '' to bigint(10) NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.assessed changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.defaultsort changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.defaultsortdir changed from tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data.editany changed from tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '' to smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_data_comments
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY recordid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY created bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY modified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
ADD INDEX mdl_datacomm_rec_ix (recordid),
COMMENT='to comment data records';
#
# Fieldformats of
# mdl_data_comments.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_data_comments.userid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data_comments.recordid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data_comments.created changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data_comments.modified changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_data_content
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY fieldid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY recordid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
ADD INDEX mdl_datacont_rec_ix (recordid),
ADD INDEX mdl_datacont_fie_ix (fieldid),
COMMENT='the content introduced in each record/fields';
#
# Fieldformats of
# mdl_data_content.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_data_content.fieldid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data_content.recordid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_data_fields
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY dataid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
ADD INDEX mdl_datafiel_dat_ix (dataid),
COMMENT='every field available';
#
# Fieldformats of
# mdl_data_fields.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_data_fields.dataid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_data_ratings
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY recordid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY rating bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
ADD INDEX mdl_datarati_rec_ix (recordid),
COMMENT='to rate data records';
#
# Fieldformats of
# mdl_data_ratings.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment.
# mdl_data_ratings.userid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data_ratings.recordid changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# mdl_data_ratings.rating changed from int(10) unsigned NOT NULL DEFAULT '0' COMMENT '' to bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
ALTER TABLE mdl_data_records
MODIFY id bigint(10) unsigned NOT NULL DEFAULT '' COMMENT '' auto_increment,
MODIFY userid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY groupid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY dataid bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timecreated bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY timemodified bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
MODIFY approved smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '',
ADD INDEX mdl_datareco_dat_ix (dataid),
COMMENT='every record introduced';
#
# Fieldformats of
# mdl_data_records.id changed from int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment to bigint(10) unsigned NOT NULL DEFAULT '' COMMENT
