mrbs
(mysql): CREATE TABLE mdl_mrbs_area (
id BIGINT(11) unsigned NOT NULL auto_increment,
area_name VARCHAR(30) DEFAULT NULL,
area_admin_email TEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_mrbs_area COMMENT='mrbs_area table retrofitted from MySQL'
Success
(mysql): CREATE TABLE mdl_mrbs_entry (
id BIGINT(11) unsigned NOT NULL auto_increment,
start_time BIGINT(11) unsigned NOT NULL DEFAULT 0,
end_time BIGINT(11) unsigned NOT NULL DEFAULT 0,
entry_type BIGINT(11) unsigned NOT NULL DEFAULT 0,
repeat_id BIGINT(11) unsigned NOT NULL DEFAULT 0,
room_id BIGINT(11) unsigned NOT NULL DEFAULT 1,
timestamp BIGINT(10) unsigned NOT NULL DEFAULT 0,
create_by VARCHAR(80) NOT NULL DEFAULT '',
name VARCHAR(80) NOT NULL DEFAULT '',
type VARCHAR(1) NOT NULL DEFAULT 'E',
description TEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_mrbs_entry COMMENT='mrbs_entry table retrofitted from MySQL'
Success
(mysql): CREATE TABLE mdl_mrbs_repeat (
id BIGINT(11) unsigned NOT NULL auto_increment,
start_time BIGINT(11) unsigned NOT NULL DEFAULT 0,
end_time BIGINT(11) unsigned NOT NULL DEFAULT 0,
rep_type BIGINT(11) unsigned NOT NULL DEFAULT 0,
end_date BIGINT(11) unsigned NOT NULL DEFAULT 0,
rep_opt VARCHAR(32) NOT NULL DEFAULT '',
room_id BIGINT(11) unsigned NOT NULL DEFAULT 1,
timestamp BIGINT(10) unsigned NOT NULL DEFAULT 0,
create_by VARCHAR(80) NOT NULL DEFAULT '',
name VARCHAR(80) NOT NULL DEFAULT '',
type VARCHAR(1) NOT NULL DEFAULT 'E',
description TEXT,
rep_num_weeks MEDIUMINT(6) unsigned DEFAULT NULL,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_mrbs_repeat COMMENT='mrbs_repeat table retrofitted from MySQL'
Success
(mysql): CREATE TABLE mdl_mrbs_room (
id BIGINT(11) unsigned NOT NULL auto_increment,
area_id BIGINT(11) unsigned NOT NULL DEFAULT 0,
room_name VARCHAR(25) NOT NULL DEFAULT '',
description VARCHAR(60) DEFAULT NULL,
capacity BIGINT(11) unsigned NOT NULL DEFAULT 0,
room_admin_email TEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_mrbs_room COMMENT='mrbs_room table retrofitted from MySQL'
Success
Resource Scheduling tables have been set up correctly