CREATE TABLE `site_news` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(64) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `time` INT(18) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

ALTER TABLE `players` ADD `created` INT(16) DEFAULT NULL;
ALTER TABLE `players` ADD `comment` text;
ALTER TABLE `guilds` ADD `logo` VARCHAR(100) NOT NULL;
ALTER TABLE `accounts` ADD `premium_points` INT(11) DEFAULT '0';
ALTER TABLE `players` MODIFY COLUMN `conditions` BLOB;
ALTER TABLE `guilds` MODIFY COLUMN checkdata INT(11) DEFAULT 0;
ALTER TABLE `guilds` MODIFY COLUMN logo VARCHAR(11) DEFAULT '';

delimiter //
CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds`
FOR EACH ROW BEGIN
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
END;//
delimiter ;