CREATE TABLE `room_bans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL DEFAULT 0,
  `player_id` int(11) NOT NULL DEFAULT 0,
  `expire_timestamp` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='latin1_swedish_ci';

alter table `players` add column `time_muted` int(11) null default 0;

CREATE TABLE `permission_command_overrides` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`command_id` VARCHAR(255) NULL DEFAULT NULL,
	`player_id` INT(11) NULL DEFAULT NULL,
	`enabled` ENUM('1','0') NULL DEFAULT '1',
	PRIMARY KEY (`id`),
	INDEX `player_id` (`player_id`)
)
ENGINE=InnoDB
;

alter table `group_forum_messages` add column `moderator_id` int(11) not null default '0' AFTER `pinned`, add column `moderator_username` varchar(255) not null default '' AFTER `moderator_id`;

alter table `server_configuration` add column `group_chat_enabled` enum('true','false') NOT NULL DEFAULT 'false';

CREATE TABLE `logs_namechange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `new_name` varchar(50) NOT NULL DEFAULT '',
  `old_name` varchar(50) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='latin1_swedish_ci';
