Changeset 6dcf12c6a27972f29c47010aa4f5ed6cc162f54a

Timestamp:

03/17/07 15:32:52 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

Christopher Jung <bktheg@web.de> 1174141972 +0100

git-parent:

[3c16034036f2f3605968cd0dfc91a1f8dc55e05a]

git-author:

Christopher Jung <bktheg@web.de> 1174141972 +0100

Message:

FK-Constraints fuer survey_voted eingebaut

Files:

• db/tables/survey_voted.sql (modified) (1 diff)
• db/updates.xml (modified) (1 diff)
• src/net/driftingsouls/ds2/server/modules/admin/PlayerDelete.java (modified) (1 diff)

db/tables/survey_voted.sql

@@ -4 +4 @@
-  KEY `survey_id` (`survey_id`,`user_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
+
+ALTER TABLE survey_voted ADD CONSTRAINT survey_voted_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id);
+ALTER TABLE survey_voted ADD CONSTRAINT survey_voted_fk_users FOREIGN KEY (user_id) REFERENCES users(id);

db/updates.xml

@@ -199 +199 @@
-                ALTER TABLE survey_entries ADD CONSTRAINT survey_entries_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id);
-                ALTER TABLE survey_results ADD CONSTRAINT survey_results_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id);
+                ALTER TABLE survey_voted ADD CONSTRAINT survey_voted_fk_surveys FOREIGN KEY (survey_id) REFERENCES surveys(id);
+                ALTER TABLE survey_voted ADD CONSTRAINT survey_voted_fk_users FOREIGN KEY (user_id) REFERENCES users(id);
-        ]]></update>
-</updates>

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

@@ -258 +258 @@
-                db.update("DELETE FROM stats_user_cargo WHERE user_id="+userid);
-                
+                echo.append("L&ouml;sche Umfrageeintraege...<br />\n");
+                db.update("DELETE FROM survey_voted WHERE user_id="+userid);
+                
-                echo.append("L&ouml;sche Usereintrag...<br />\n");
-                db.update("DELETE FROM users WHERE id="+userid);