Код:
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