Changeset b7677991e94fd33703d2990de9d86bbec38e4b2d

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

[0aa6793624f97be37428044935bdcb6bd6c700d2]

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

FK-Constraint fuer stats_user_cargo.user_id eingebaut

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • db/tables/stats_user_cargo.sql

    r425acaa rb767799  
    44  PRIMARY KEY  (`user_id`) 
    55) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die User-Cargo-Stats';  
     6 
     7ALTER TABLE stats_user_cargo ADD CONSTRAINT stats_user_cargo_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); 

  • db/updates.xml

    r0aa6793 rb767799  
    196196                ALTER TABLE skn ADD CONSTRAINT skn_fk_users FOREIGN KEY (userid) REFERENCES users(id); 
    197197                ALTER TABLE stats_module_locations ADD CONSTRAINT stats_module_locations_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); 
     198                ALTER TABLE stats_user_cargo ADD CONSTRAINT stats_user_cargo_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); 
    198199        ]]></update> 
    199200</updates> 

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

    r0aa6793 rb767799  
    255255                db.update("DELETE FROM stats_module_locations WHERE user_id="+userid); 
    256256                 
     257                echo.append("L&ouml;sche Statistik 'User-Cargo'...<br />\n"); 
     258                db.update("DELETE FROM stats_user_cargo WHERE user_id="+userid); 
     259                 
    257260                echo.append("L&ouml;sche Usereintrag...<br />\n"); 
    258261                db.update("DELETE FROM users WHERE id="+userid);