mysql error

CREATE TABLE `[users]`(
  `id` INT(4) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`),
  `signup` DATETIME,
  `login` VARCHAR(16),
  UNIQUE KEY(`login`),
  `pass` VARCHAR(32),
  `level` INT(3) NOT NULL DEFAULT '1',
  `IP` VARCHAR(32),
  `email` VARCHAR(64),
  `type` INT(1),
  `url` VARCHAR(128) NOT NULL DEFAULT'images/blancomaffia.gif',
  `info` TEXT NOT NULL,
  `cash` INT(9) NOT NULL DEFAULT '500',
  `bank` INT(9) NOT NULL DEFAULT '500',
  `bankleft` INT(1) NOT NULL DEFAULT '5',
  `bankmax` INT(4) NOT NULL DEFAULT '2500',
  `clicks` INT(4) NOT NULL,
  `clickstoday` INT(3) NOT NULL,
  `attack` INT(6) NOT NULL,
  `defence` INT(6) NOT NULL,
  `attwins` INT(6) NOT NULL,
  `attlosses` INT(6) NOT NULL,
  `defwins` INT(6) NOT NULL,
  `deflosses` INT(6) NOT NULL,
  `clan` VARCHAR(26) NOT NULL,
  `clanlevel` INT(3) NOT NULL,
  `bonus` TEXT NOT NULL,
  `turns` INT(3) NOT NULL DEFAULT '100',
  `showonline` INT(1) NOT NULL DEFAULT '1',
  `online` DATETIME NOT NULL,
  `activated` INT(1) NOT NULL DEDAULT '1',
  `Mes` INT(5) NOT NULL,
  `Walter P99` INT(5) NOT NULL,
  `Uzi` INT(5) NOT NULL,
  `MP5k` INT(5) NOT NULL,
  `Flashbang` INT(5) NOT NULL,
  `Granaat` INT(5) NOT NULL,
  `Shotgun` INT(5) NOT NULL,
  `G36C` INT(5) NOT NULL,
  `SIG 552` INT(5) NOT NULL,
  `Ak47` INT(5) NOT NULL,
  `Ak Beta` INT(5) NOT NULL,
  `Scherpschut geweer` INT(5) NOT NULL,
  `M4` INT(5) NOT NULL,
  `Granaat Lanceerder` INT(5) NOT NULL,
  `Bazooka` INT(5) NOT NULL,
  `Kogelvrij vest` INT(5) NOT NULL,
  `Bulldog` INT(5) NOT NULL,
  `Camera` INT(5) NOT NULL,
  `Hek` INT(5) NOT NULL,
  `Muur` INT(5) NOT NULL,
  `Bunker` INT(5) NOT NULL,
  `Mobieltje` INT(1) NOT NULL,
  `FN P90` INT(5) NOT NULL,
  `Chip` INT(5) NOT NULL,
  `Helm` INT(5) NOT NULL,
  `Politie wagen` INT(5) NOT NULL,
  `IPs` TEXT NOT NULL,
  `blocklist` TEXT NOT NULL,
  `betaal` INT(5) NOT NULL DEFAULT '1',
  `lotery` INT(5) NOT NULL DEFAULT '1',
  `admin` INT(5) NOT NULL
);

CREATE TABLE `[users]`(
  `id` INT(4) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`),
  `signup` DATETIME,
  `login` VARCHAR(16),
  UNIQUE KEY(`login`),
  `pass` VARCHAR(32),
  `level` INT(3) NOT NULL DEFAULT '1',
  `IP` VARCHAR(32),
  `email` VARCHAR(64),
  `type` INT(1),
  `url` VARCHAR(128) NOT NULL DEFAULT'images/blancomaffia.gif',
  `info` TEXT NOT NULL,
  `cash` INT(9) NOT NULL DEFAULT '500',
  `bank` INT(9) NOT NULL DEFAULT '500',
  `bankleft` INT(1) NOT NULL DEFAULT '5',
  `bankmax` INT(4) NOT NULL DEFAULT '2500',
  `clicks` INT(4) NOT NULL,
  `clickstoday` INT(3) NOT NULL,
  `attack` INT(6) NOT NULL,
  `defence` INT(6) NOT NULL,
  `attwins` INT(6) NOT NULL,
  `attlosses` INT(6) NOT NULL,
  `defwins` INT(6) NOT NULL,
  `deflosses` INT(6) NOT NULL,
  `clan` VARCHAR(26) NOT NULL,
  `clanlevel` INT(3) NOT NULL,
  `bonus` TEXT NOT NULL,
  `turns` INT(3) NOT NULL DEFAULT '100',
  `showonline` INT(1) NOT NULL DEFAULT '1',
  `online` DATETIME NOT NULL,
  `activated` INT(1) NOT NULL DEDAULT '1',
  `Mes` INT(5) NOT NULL,
  `Walter P99` INT(5) NOT NULL,
  `Uzi` INT(5) NOT NULL,
  `MP5k` INT(5) NOT NULL,
  `Flashbang` INT(5) NOT NULL,
  `Granaat` INT(5) NOT NULL,
  `Shotgun` INT(5) NOT NULL,
  `G36C` INT(5) NOT NULL,
  `SIG 552` INT(5) NOT NULL,
  `Ak47` INT(5) NOT NULL,
  `Ak Beta` INT(5) NOT NULL,
  `Scherpschut geweer` INT(5) NOT NULL,
  `M4` INT(5) NOT NULL,
  `Granaat Lanceerder` INT(5) NOT NULL,
  `Bazooka` INT(5) NOT NULL,
  `Kogelvrij vest` INT(5) NOT NULL,
  `Bulldog` INT(5) NOT NULL,
  `Camera` INT(5) NOT NULL,
  `Hek` INT(5) NOT NULL,
  `Muur` INT(5) NOT NULL,
  `Bunker` INT(5) NOT NULL,
  `Mobieltje` INT(1) NOT NULL,
  `FN P90` INT(5) NOT NULL,
  `Chip` INT(5) NOT NULL,
  `Helm` INT(5) NOT NULL,
  `Politie wagen` INT(5) NOT NULL,
  `IPs` TEXT NOT NULL,
  `blocklist` TEXT NOT NULL,
  `betaal` INT(5) NOT NULL DEFAULT '1',
  `lotery` INT(5) NOT NULL DEFAULT '1',
  `admin` INT(5) NOT NULL
);