Membership is FREE – with unlimited access to all features, tools, and discussions. Premium accounts get benefits like banner ads and newsletter exposure. ✅ Signature links are now free for all. 🚫 No AI-generated (LLM) posts allowed. Share your own thoughts and experience — accounts may be terminated for violations.
Any MySQL expert here?
- Thread starter Johnn
- Start date
- Status
- Joined
- Jul 9, 2005
- Messages
- 8,427
- Reaction score
- 1,291
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:
If it works the remaining create table statements should be adapted too.
Try this:
Code:
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.
- Status
Similar threads
