From b6a6f3a06ee585c17fb7fe8c7aa5dae80e8db5d6 Mon Sep 17 00:00:00 2001 From: Dylan Lloyd Date: Fri, 4 Oct 2013 07:18:01 +0000 Subject: [PATCH 1/1] fix record dependencies --- db.sql | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/db.sql b/db.sql index cbc8b3c..23ccd13 100644 --- a/db.sql +++ b/db.sql @@ -29,15 +29,17 @@ CREATE TABLE `messages` ( `source` int, `sent` timestamp default current_timestamp, PRIMARY KEY (`id`), - CONSTRAINT `origin` FOREIGN KEY (`source`) REFERENCES `players` (`id`), - CONSTRAINT `addressable` FOREIGN KEY (`destination`) REFERENCES `players` (`id`), + CONSTRAINT `origin` FOREIGN KEY (`source`) REFERENCES `players` (`id`) + ON DELETE CASCADE, + CONSTRAINT `addressable` FOREIGN KEY (`destination`) REFERENCES `players` (`id`) + ON DELETE CASCADE, CONSTRAINT `place` FOREIGN KEY (`room`) REFERENCES `rooms` (`id`) ); CREATE EVENT `purge_inactive_players` - ON SCHEDULE EVERY 1 MINUTE + ON SCHEDULE EVERY 1 MINUTE STARTS now() DO DELETE FROM `players` WHERE `last_active` < now() - interval 5 minute; CREATE EVENT `purge_old_messages` - ON SCHEDULE EVERY 1 MINUTE + ON SCHEDULE EVERY 1 MINUTE STARTS now() DO DELETE FROM `messages` WHERE `sent` < now() - interval 5 minute; -- 2.30.2