WIP: Allow barring of users from VIzon

[irc/rizon/acid.git] / vizon / vizon.sql

diff --git a/vizon/vizon.sql b/vizon/vizon.sql
index c9ca4c0142770899bf75bd59a25790ab2e18d1dd..1e0dba27e020bb5690505b3f7d3f4ddd4674e1f1 100644 (file)
--- a/vizon/vizon.sql
+++ b/vizon/vizon.sql
@@ -82,6 +82,17 @@ CREATE TABLE IF NOT EXISTS `vizon`.`vizon_bets` (
     ON UPDATE CASCADE)
 ENGINE = InnoDB;
 
+-- -----------------------------------------------------
+-- Table `vizon`.`vizon_bans`
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS `vizon`.`vizon_bans` (
+`id` INT AUTO_INCREMENT,
+`nick` VARCHAR(64) not null,
+`oper` VARCHAR(64) not null,
+`reason` VARCHAR(128),
+PRIMARY KEY (id),
+UNIQUE INDEX `nick_UNIQUE` (`nick` ASC));
+
 
 SET SQL_MODE=@OLD_SQL_MODE;
 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;