Untitled

ALTER TABLE `pricing`.`prices` ADD CONSTRAINT `fk_project_id` FOREIGN KEY (`Project ID`)    REFERENCES `projects` (`Project ID`)    ON DELETE CASCADE    ON UPDATE CASCADE;table def:CREATE TABLE `projects` (  `Project ID` mediumint(8) unsigned zerofill NOT NULL auto_increment,  `Last Name` varchar(20) default NULL,  `First Name` varchar(20) default NULL,  `Invoice` varchar(30) default NULL,  `Title` text,  `Description` text,  `Status` enum('notstarted','inprogress','deferred','completed') NOT NULL default 'notstarted',  PRIMARY KEY  (`Project ID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8