Salve,
nel tentativo di importare questo:
CREATE TABLE jos_vm_waiting_list (
waiting_list_id int(11) NOT NULL auto_increment,
product_id int(11) NOT NULL default '0',
user_id int(11) NOT NULL default '0',
notify_email varchar(150) NOT NULL default '',
notified enum('0','1') default '0',
notify_date timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (waiting_list_id),
KEY product_id (product_id),
KEY notify_email (notify_email)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores notifications, users waiting f. products out of stock';
Mi restituisce questo:
You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (waiting_list_id)' at line 7
Cosa posso fare?