![]() |
|
| Home | Downloads | Activate | Contact | Forum | Faq | Links |
Posted by Dan Wilson 76.182.39.190 on March 27 2008 19:23:44
The following table SQL was generated using batch mode and going from Access to mySQL. The column definitions are correct but the primary keys are not. I can provide additional details if necessary.
CREATE TABLE `DeveloperResourcesByProject` (
`projectID` int(11),
`month` int(11),
`year` int(11),
`tKey` varchar(255),
`DeveloperFTE` double,
`projectName` varchar(50),
PRIMARY KEY(AssignmentID,submittalID,BUID)
);