Changeset d912d44645998a2066916946fa396cce03bc69ee
- Timestamp:
- 03/17/07 14:51:33
(2 years ago)
- Author:
- Christopher Jung <bktheg@web.de>
- git-committer:
- Christopher Jung <bktheg@web.de> 1174139493 +0100
- git-parent:
[b85fb0675ca2e9641de4fa18b81f6c32d71c2fb1]
- git-author:
- Christopher Jung <bktheg@web.de> 1174139493 +0100
- Message:
FK-Constraint ordner.playerid eingebaut
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r425acaa |
rd912d44 |
|
| 8 | 8 | KEY `playerid` (`playerid`) |
|---|
| 9 | 9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| | 10 | |
|---|
| | 11 | ALTER TABLE ordner ADD CONSTRAINT ordner_fk_users FOREIGN KEY (playerid) REFERENCES users(id); |
|---|
| r60cbaf0 |
rd912d44 |
|
| 182 | 182 | ALTER TABLE offiziere ADD CONSTRAINT offiziere_fk_users FOREIGN KEY (userid) REFERENCES users(id); |
|---|
| 183 | 183 | ALTER TABLE orders_ships ADD CONSTRAINT orders_ships_fk_ship_types FOREIGN KEY (type) REFERENCES ship_types(id); |
|---|
| | 184 | ALTER TABLE ordner ADD CONSTRAINT ordner_fk_users FOREIGN KEY (playerid) REFERENCES users(id); |
|---|
| 184 | 185 | ]]></update> |
|---|
| 185 | 186 | </updates> |
|---|