-
Welcome to DNForum.com - Domain Investor Forum, Free Domain Marketplace and a community for 45+ domain pros
If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the oldest global domain name community on the internet and continues to grow every day. There are over 45,000 domainers on DNForum doing everything from buying domains, selling domains, using our free in-house built tools, learning about domains and discussing domains. Take a minute and Register.
Any MySQL expert here?
- Thread starter Johnn
- Start date
- Status
- Joined
- Jul 9, 2005
- Messages
- 8,426
- Reaction score
- 1,292
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
