Changeset 0aa6793624f97be37428044935bdcb6bd6c700d2

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

[ade629dcb7905221b363d55bd44a2d174b6feac2]

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

FK-Constraint fuer stats_module_locations.user_id eingebaut

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • db/tables/stats_module_locations.sql

    r425acaa r0aa6793  
    77  KEY `user_id` (`user_id`) 
    88) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
     9 
     10ALTER TABLE stats_module_locations ADD CONSTRAINT stats_module_locations_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); 

  • db/updates.xml

    rade629d r0aa6793  
    195195                ALTER TABLE skn ADD CONSTRAINT skn_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id); 
    196196                ALTER TABLE skn ADD CONSTRAINT skn_fk_users FOREIGN KEY (userid) REFERENCES users(id); 
     197                ALTER TABLE stats_module_locations ADD CONSTRAINT stats_module_locations_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); 
    197198        ]]></update> 
    198199</updates> 

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

    rade629d r0aa6793  
    252252                db.update("DELETE FROM sessions WHERE id="+userid); 
    253253                 
     254                echo.append("L&ouml;sche Statistik 'Item-Locations'...<br />\n"); 
     255                db.update("DELETE FROM stats_module_locations WHERE user_id="+userid); 
     256                 
    254257                echo.append("L&ouml;sche Usereintrag...<br />\n"); 
    255258                db.update("DELETE FROM users WHERE id="+userid);