Changeset 3c16034036f2f3605968cd0dfc91a1f8dc55e05a
- 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
| r425acaa |
r3c16034 |
|
| 6 | 6 | KEY `surveys_id` (`survey_id`) |
|---|
| 7 | 7 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| | 8 | |
|---|
| | 9 | ALTER TABLE survey_results ADD CONSTRAINT survey_results_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id); |
|---|
| r9c6654e |
r3c16034 |
|
| 198 | 198 | ALTER TABLE stats_user_cargo ADD CONSTRAINT stats_user_cargo_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); |
|---|
| 199 | 199 | 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); |
|---|
| 200 | 201 | ]]></update> |
|---|
| 201 | 202 | </updates> |
|---|