Changeset 0dde3284defcb54d9a1e1cdba693040f9cfe061f
- Timestamp:
- 03/17/07 15:13:57
(1 year ago)
- Author:
- Christopher Jung <bktheg@web.de>
- git-committer:
- Christopher Jung <bktheg@web.de> 1174140837 +0100
- git-parent:
[b139234cf2a598a50ef3e155a6841059837cf2a7]
- git-author:
- Christopher Jung <bktheg@web.de> 1174140837 +0100
- Message:
FK-Constraints fuer ship_loot eingebaut
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r425acaa |
r0dde328 |
|
| 12 | 12 | KEY `owner` (`owner`) |
|---|
| 13 | 13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die Schiff-Loot-Table'; |
|---|
| | 14 | |
|---|
| | 15 | ALTER TABLE ship_loot ADD CONSTRAINT ship_loot_fk_users1 FOREIGN KEY (owner) REFERENCES users(id); |
|---|
| | 16 | ALTER TABLE ship_loot ADD CONSTRAINT ship_loot_fk_users2 FOREIGN KEY (targetuser) REFERENCES users(id); |
|---|
| rb139234 |
r0dde328 |
|
| 189 | 189 | ALTER TABLE quests_running ADD CONSTRAINT quests_running_fk_quests FOREIGN KEY (questid) REFERENCES quests(id); |
|---|
| 190 | 190 | ALTER TABLE sessions ADD CONSTRAINT sessions_fk_users FOREIGN KEY (id) REFERENCES users(id); |
|---|
| | 191 | ALTER TABLE ship_loot ADD CONSTRAINT ship_loot_fk_users1 FOREIGN KEY (owner) REFERENCES users(id); |
|---|
| | 192 | ALTER TABLE ship_loot ADD CONSTRAINT ship_loot_fk_users2 FOREIGN KEY (targetuser) REFERENCES users(id); |
|---|
| 191 | 193 | ]]></update> |
|---|
| 192 | 194 | </updates> |
|---|
