CREATE TABLE IF NOT EXISTS `koperz`.`logins` (
          `username` VARCHAR(50) NOT NULL,
          `user_id` INT NOT NULL,
          `salt` VARCHAR(100) NOT NULL,
          `password` VARCHAR(100) NOT NULL,
          `created_at` DATETIME NULL,
          `created_by` INT NULL,
          `modified_at` VARCHAR(45) NULL,
          `modified_by` INT NULL,
          `users_id` INT NOT NULL,
          PRIMARY KEY (`username`),
          INDEX `fk_logins_users_idx` (`users_id` ASC, `user_id` ASC),
          CONSTRAINT `fk_logins_users`
            FOREIGN KEY (`users_id` , `user_id`)
            REFERENCES `koperz`.`users` (`id` , `id`)
            ON DELETE RESTRICT
            ON UPDATE RESTRICT)
        ENGINE = InnoDB