Dong Shin 11.04.2010

  • added project_comments table with DELETE constraints
  • converted all contacts tables to innoDB
    • got #1071 – Specified key was too long; max key length is 767 bytes because login field is too large?
    • reduce PRIMARY KEY size to 100
    • automatically deletes contracts relational data on project delete
    • ALTER TABLE `_projects_portfolio_admins` ADD CONSTRAINT FK_projects_portfolio_admins_project_id FOREIGN    KEY (project_id) REFERENCES projects(uid) on DELETE CASCADE