[Sql Issue]

Hello! Im a newbie here. And I experienced the same issue while importing the SQL file. 

I read your solution but I still don't understand which line of code specifically am i deleting/changing? 

If you would be kind enough to show me I would really appreciate it.

 

Thanks in advance.

 

CREATE TABLE `users` (

`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`type` ENUM('member','admin') NOT NULL DEFAULT 'member',

`username` VARCHAR(45) NOT NULL,

`email` VARCHAR(80) NOT NULL,

`pass` VARCHAR(255) NOT NULL,

`first_name` VARCHAR(45) NOT NULL,

`last_name` VARCHAR(45) NOT NULL,

`date_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

`date_expires` DATE NOT NULL,

`date_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

UNIQUE INDEX `username_UNIQUE` (`username` ASC),

UNIQUE INDEX `email_UNIQUE` (`email` ASC),

INDEX `login` (`email` ASC, `pass` ASC)

) ENGINE = InnoDB  DEFAULT CHARSET=utf8;