Issue with Create Table statement

[westmich]

I am not the MySQL guru so I used the dump command to get the syntax to re-create a table. When I ran the output I got a generic error and can't figure out why.

CREATE TABLE `purchase_orders` (
  `PO_ID` varchar(15) NOT NULL default '',
  `WorkOrderID` varchar(20) NOT NULL default '',
  `Vendor` varchar(50) NOT NULL default '',
  `Date_Created` date NOT NULL default '0000-00-00',
  `Requested_By` varchar(50) NOT NULL default '',
  `Description` longtext NOT NULL,
  `Quantity` int(11) NOT NULL default '0',
  `Net_Cost` decimal(10,2) NOT NULL default '0.00',
  `Net_Total` decimal(10,2) NOT NULL default '0.00',
  `Gross_Cost` decimal(10,2) NOT NULL default '0.00',
  `Gross_Total` decimal(10,2) NOT NULL default '0.00',
  `Active` tinyint(4) NOT NULL default '1',
  `DueDate` date default NULL,
  PRIMARY KEY  (`PO_ID`);

[Marc]

Add another closing parenthesis before the final semicolon. So like this:

 CREATE TABLE `purchase_orders` (
   `PO_ID` varchar(15) NOT NULL default '',
   `WorkOrderID` varchar(20) NOT NULL default '',
   `Vendor` varchar(50) NOT NULL default '',
   `Date_Created` date NOT NULL default '0000-00-00',
   `Requested_By` varchar(50) NOT NULL default '',
   `Description` longtext NOT NULL,
   `Quantity` int(11) NOT NULL default '0',
   `Net_Cost` decimal(10,2) NOT NULL default '0.00',
   `Net_Total` decimal(10,2) NOT NULL default '0.00',
   `Gross_Cost` decimal(10,2) NOT NULL default '0.00',
   `Gross_Total` decimal(10,2) NOT NULL default '0.00',
   `Active` tinyint(4) NOT NULL default '1',
   `DueDate` date default NULL,
   PRIMARY KEY  (`PO_ID`)
 ); 

[westmich]

Thank-you - that did the trick.