Changeset 3c16034036f2f3605968cd0dfc91a1f8dc55e05a

Show
Ignore:
Timestamp:
03/17/07 15:30:17 (1 year ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1174141817 +0100
git-parent:

[9c6654ecbd940b2a63c2f93c5a7ea660a4c2bda4]

git-author:
Christopher Jung <bktheg@web.de> 1174141817 +0100
Message:

FK-Constraint fuer survey_results.survey_id eingebaut

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • db/tables/survey_results.sql

    r425acaa r3c16034  
    66  KEY `surveys_id` (`survey_id`) 
    77) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
     8 
     9ALTER TABLE survey_results ADD CONSTRAINT survey_results_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id); 
  • db/updates.xml

    r9c6654e r3c16034  
    198198                ALTER TABLE stats_user_cargo ADD CONSTRAINT stats_user_cargo_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); 
    199199                ALTER TABLE survey_entries ADD CONSTRAINT survey_entries_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id); 
     200                ALTER TABLE survey_results ADD CONSTRAINT survey_results_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id); 
    200201        ]]></update> 
    201202</updates>