Changeset 39cd21147f344ca0c9adfd5c445b7ade0279ea3d

Show
Ignore:
Timestamp:
03/17/07 14:46:25 (2 years ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1174139185 +0100
git-parent:

[b007e02f906b6f58e0262bf8e3af874f704ade67]

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

FK-Constraint jumps.shipid eingebaut

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • db/tables/jumps.sql

    r425acaa r39cd211  
    11CREATE TABLE `jumps` ( 
    22  `id` int(10) unsigned NOT NULL auto_increment, 
    3   `shipid` int(10) unsigned NOT NULL default '0', 
     3  `shipid` int(11) NOT NULL default '0', 
    44  `x` smallint(5) unsigned NOT NULL default '0', 
    55  `y` smallint(5) unsigned NOT NULL default '0', 
    …… 
    88  KEY `shipid` (`shipid`) 
    99) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ziele von Sprungschiffen';  
     10 
     11ALTER TABLE jumps ADD CONSTRAINT jumps_fk_ships FOREIGN KEY (shipid) REFERENCES ships(id); 

  • db/updates.xml

    rb007e02 r39cd211  
    177177                ALTER TABLE gtu_zwischenlager ADD CONSTRAINT gtu_zwischenlager_fk_users2 FOREIGN KEY (user2) REFERENCES users(id); 
    178178                ALTER TABLE handel ADD CONSTRAINT handel_fk_users FOREIGN KEY (who) REFERENCES users(id); 
     179                ALTER TABLE jumps CHANGE shipid shipid INT NOT NULL DEFAULT '0'; 
     180                ALTER TABLE jumps ADD CONSTRAINT jumps_fk_ships FOREIGN KEY (shipid) REFERENCES ships(id); 
    179181        ]]></update> 
    180182</updates> 

  • src/net/driftingsouls/ds2/server/ships/Ships.java

    rebb3395 r39cd211  
    23292329                // Und nun loeschen wir es... 
    23302330                db.update("DELETE FROM offiziere WHERE dest='s ",ship.getInt("id"),"'"); 
     2331                db.update("DELETE FROM jumps WHERE shipid=",ship.getInt("id")); 
    23312332                 
    23322333                db.update("DELETE FROM werften WHERE shipid=",ship.getInt("id"));