Changeset d912d44645998a2066916946fa396cce03bc69ee

Show
Ignore:
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
  • db/tables/ordner.sql

    r425acaa rd912d44  
    88  KEY `playerid` (`playerid`) 
    99) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
     10 
     11ALTER TABLE ordner ADD CONSTRAINT ordner_fk_users FOREIGN KEY (playerid) REFERENCES users(id); 
  • db/updates.xml

    r60cbaf0 rd912d44  
    182182                ALTER TABLE offiziere ADD CONSTRAINT offiziere_fk_users FOREIGN KEY (userid) REFERENCES users(id); 
    183183                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); 
    184185        ]]></update> 
    185186</updates>