Changeset 45b342c3a66ff0fde23d5d3aabbd9ca8b2cc2b51

Show
Ignore:
Timestamp:
03/17/07 15:36:34 (2 years ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1174142194 +0100
git-parent:

[6dcf12c6a27972f29c47010aa4f5ed6cc162f54a]

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

FK-Constraints fuer transmissionen eingebaut

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • db/tables/transmissionen.sql

    r90c3305 r45b342c  
    1313  KEY `empfaenger` (`empfaenger`,`gelesen`) 
    1414) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
     15 
     16ALTER TABLE transmissionen ADD CONSTRAINT transmissionen_fk_users1 FOREIGN KEY (sender) REFERENCES users(id); 
     17ALTER TABLE transmissionen ADD CONSTRAINT transmissionen_fk_users2 FOREIGN KEY (empfaenger) REFERENCES users(id); 

  • db/updates.xml

    r6dcf12c r45b342c  
    201201                ALTER TABLE survey_voted ADD CONSTRAINT survey_voted_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id); 
    202202                ALTER TABLE survey_voted ADD CONSTRAINT survey_voted_fk_users FOREIGN KEY (user_id) REFERENCES users(id); 
     203                ALTER TABLE transmissionen ADD CONSTRAINT transmissionen_fk_users1 FOREIGN KEY (sender) REFERENCES users(id); 
     204                ALTER TABLE transmissionen ADD CONSTRAINT transmissionen_fk_users2 FOREIGN KEY (empfaenger) REFERENCES users(id); 
    203205        ]]></update> 
    204206</updates> 

  • src/net/driftingsouls/ds2/server/modules/admin/PlayerDelete.java

    r6dcf12c r45b342c  
    225225                db.update("UPDATE versteigerungen SET bieter=-2 WHERE bieter="+userid); 
    226226                db.update("UPDATE versteigerungen_pakete SET bieter=-2 WHERE bieter="+userid); 
    227  
    228                 echo.append("L&ouml;sche PM-Ordner...<br />\n"); 
    229                 db.update("DELETE FROM ordner WHERE playerid="+userid); 
    230227                 
    231228                echo.append("L&ouml;sche PM's...\n"); 
    …… 
    233230                echo.append(db.affectedRows()+" gel&ouml;scht<br />\n"); 
    234231                db.update("UPDATE transmissionen SET sender=0 WHERE sender="+userid); 
     232                 
     233                echo.append("L&ouml;sche PM-Ordner...<br />\n"); 
     234                db.update("DELETE FROM ordner WHERE playerid="+userid); 
    235235 
    236236                echo.append("L&ouml;sche Diplomatieeintr&auml;ge...<br />\n");