CREATE  TABLE IF NOT EXISTS `CrackersGame`.`tbl_usersSettings` (
  `users_settings_id` INT(11) NOT NULL AUTO_INCREMENT ,
  `users_id` INT(11) NULL ,
  `usersAccountLevel` INT(1) NULL ,
  `usersPremiumAccount` INT(1) NULL ,
  `usersPremiumPoints` INT(11) NULL ,
  `usersPrivateProfile` INT(1) NULL ,
  `usersPrivateHalfProfile` INT(1) NULL ,
  `usersProfileLink` TEXT NULL ,
  `usersActive` INT(1) NULL ,
  `usersActiovationCode` TEXT NULL ,
  `usersBanned` INT(1) NULL ,
  `usersDeactivated` INT(1) NULL ,
  `usersWarned` INT(1) NULL ,
  `usersBannedReason` TEXT NULL ,
  `usersWarnedReason` TEXT NULL ,
  `usersDeactivatedReason` TEXT NULL ,
  `usersBannedByWho` VARCHAR(45) NULL ,
  `usersWarnedByWho` VARCHAR(45) NULL ,
  `usersDeactivatedByWho` VARCHAR(45) NULL ,
  `usersBannedDate` DATE NULL ,
  `usersWarnedDate` DATE NULL ,
  `usersDeactivateDate` DATE NULL ,
  `usersRemoveBannedDate` DATE NULL ,
  `usersRemoveWarnedDate` DATE NULL ,
  `usersDeleteAccountDate` DATE NULL ,
  `usersWarnCount` INT(5) NULL ,
  `usersPendingDeactivate` INT(1) NULL ,
  `usersPendingAccountDelete` INT(1) NULL ,
  `usersOnline` INT(1) NULL ,
  `usersOnlineFromTo` DATE NULL ,
  `usersLastLogin` DATE NULL ,
  `usersRegistrationDate` DATE NULL ,
  `usersLastIp` VARCHAR(45) NULL ,
  PRIMARY KEY (`users_settings_id`) ,
  INDEX `fk_tbl_usersSettings_tbl_usersCharacterSystem` (`usersPremiumPoints` ASC) ,
  CONSTRAINT `fk_tbl_usersSettings_tbl_usersCharacterSystem`
    FOREIGN KEY (`usersPremiumPoints` )
    REFERENCES `CrackersGame`.`tbl_usersCharacterSystem` (`charactersPremiumPoints` )
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci