Грешка в MYSQL

sh1z0bg

Registered
Код:
CREATE TABLE `devise_user_details` (
									`user_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
                                                                                                                                                `user_firstname` VARCHAR( 30 ) NOT NULL,
 									`user_lastname` VARCHAR( 30 ) NOT NULL,
									`user_name` VARCHAR( 30 ) NOT NULL,
									`user_email` VARCHAR( 30 ) NOT NULL,
									`user_password` VARCHAR( 30 ) NOT NULL,
									'user_ipaddress' varchar(20) DEFAULT NULL,
									'signin_count' int(11) DEFAULT 0,
									'signin_time' datetime DEFAULT NULL,
									'token' varchar(50) DEFAULT NULL
								)";
	 
		mysql_query($devise_user_details) or die(mysql_error());
		
		
		
		//Table for storing the failure login attempts
		$loginattempts = "CREATE TABLE `loginattempts` (
									`IP` varchar(20),
									`Attempts` int(11),
									`LastLogin` DATETIME,
									`blocked_time` DATETIME default NULL
								)";

Дава ми тази грешка -->
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user_ipaddress' varchar(20) DEFAULT NULL, 'signin_count' int(11) DEFA' at line 8
 
Привет,
когато създаваш полета във mysql база се използва '`'(апостроф) не ''(единични кавички)

[sql]
CREATE TABLE `devise_user_details` (
`user_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`user_firstname` VARCHAR( 30 ) NOT NULL,
`user_lastname` VARCHAR( 30 ) NOT NULL,
`user_name` VARCHAR( 30 ) NOT NULL,
`user_email` VARCHAR( 30 ) NOT NULL,
`user_password` VARCHAR( 30 ) NOT NULL,
`user_ipaddress` varchar(20) DEFAULT NULL,
`signin_count` int(11) DEFAULT 0,
`signin_time` datetime DEFAULT NULL,
`token` varchar(50) DEFAULT NULL
);

mysql_query($devise_user_details) or die(mysql_error());



//Table for storing the failure login attempts
$loginattempts = "CREATE TABLE `loginattempts` (
`IP` varchar(20),
`Attempts` int(11),
`LastLogin` DATETIME,
`blocked_time` DATETIME default NULL
)";



[/sql]

Мисля че така би трябвало да е ок ?
 

Горе