Any MySQL expert here?

[Johnn]

solved

 

[katherine]

Do you have an error running this code ? Which version of mysql ?

 

[Johnn]

solved by katherine

 

[katherine]

It's the first statement that must be producing the error. Best is to execute statements one by one in phpMyAdmin for example in order to trace problems.

Try this:

CREATE TABLE  `dsp_purchases` (
  `ID` int(11) NOT NULL auto_increment,
  `domain` int(11) default NULL,
  `price` double(11,2) default NULL,
  `user` int(11) default NULL,
  `data` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

If it works the remaining create table statements should be adapted too.