From 5d1647f138763213a32e3e1ba426e3f86157f018 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sat, 9 Jun 2012 08:53:39 -0700
Subject: Remove games from digest where the player already moved

---
 create_database.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'create_database.sql')

diff --git a/create_database.sql b/create_database.sql
index f7eb458..3d5a1d4 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -492,6 +492,8 @@ create table digest_email (
   `id` int(11) NOT NULL auto_increment,
   `email` varchar(255) default null,
   `create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `type` enum('misc','your_turn') NOT NULL default 'misc',
+  `game_id` int(11) default NULL,
   `content` text,
   UNIQUE KEY `id` (`id`),
   index (email)
-- 
cgit v1.2.3-18-g5258

