MySql Import problema
Hello:
I try to import the store.sql file in my database and this is the error i got:
*******************************
Error
SQL query:
CREATE TABLE IF NOT EXISTS `orders` (
`OrderID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`OrderUserID` int( 11 ) NOT NULL ,
`OrderAmount` float NOT NULL ,
`OrderShipName` varchar( 100 ) NOT NULL ,
`OrderShipAddress` varchar( 100 ) NOT NULL ,
`OrderShipAddress2` varchar( 100 ) NOT NULL ,
`OrderCity` varchar( 50 ) NOT NULL ,
`OrderState` varchar( 50 ) NOT NULL ,
`OrderZip` varchar( 20 ) NOT NULL ,
`OrderCountry` varchar( 50 ) NOT NULL ,
`OrderPhone` varchar( 20 ) NOT NULL ,
`OrderFax` varchar( 20 ) NOT NULL ,
`OrderShipping` float NOT NULL ,
`OrderTax` float NOT NULL ,
`OrderEmail` varchar( 100 ) NOT NULL ,
`OrderDate` timestamp NOT NULL default CURRENT_TIMESTAMP ,
`OrderShipped` tinyint( 1 ) NOT NULL default '0',
`OrderTrackingNumber` varchar( 80 ) default NULL ,
PRIMARY KEY ( `OrderID` )
);
MySQL said: Documentation
#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 'CURRENT_TIMESTAMP,
`OrderShipped` tinyint(1) NOT NULL defaul
**************************************
Please check for a solution and let me know... Thank you.