MYSQL -> How to add bans table

[Czaku]

What i have to write in MYSQL to add table bans? Ty. :blink:


Need it fast!!!

 

[Onizuka]

CREATE TABLE `bans`
(
        `id` INT UNSIGNED NOT NULL auto_increment,
        `type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
        `value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
        `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
        `active` TINYINT(1) NOT NULL DEFAULT TRUE,
        `expires` INT NOT NULL,
        `added` INT UNSIGNED NOT NULL,
        `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
        `comment` TEXT NOT NULL,
        `reason` INT UNSIGNED NOT NULL DEFAULT 0,
        `action` INT UNSIGNED NOT NULL DEFAULT 0,
        `statement` VARCHAR(255) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`),
        KEY `type` (`type`, `value`),
        KEY `active` (`active`)
) ENGINE = InnoDB;

 

[Czaku]

Server have to be offline?

 

[Boski Roman]

No.
Server need not be offline...

#Przeczytałeś PW ?
Bo naprawdę potrzebuje

 

[Czaku]

#1005 - Can't create table 'xx_war.bans' (errno: 121)


;// ?

 

[hanser]

i have the same problem :S