X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=create_database.sql;h=3d5a1d4a4b8ab889e7d3d1eaf6f61127eae649b9;hp=71a6dfc2650c39a64232a26c781cd90f4d648393;hb=29c87287965ad3b88ffd49419d7a7423feda00fa;hpb=850378a3e2da48d387dc565cc6e3c2b47f12e34d;ds=sidebyside

diff --git a/create_database.sql b/create_database.sql
index 71a6dfc..3d5a1d4 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -1,4 +1,4 @@
-/* Copyright 2006, 2007, 2008, 2009, 2010 Arun Persaud <arun@nubati.net>
+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012 Arun Persaud <arun@nubati.net>
  *
  *   This file is part of e-DoKo.
  *
@@ -88,6 +88,7 @@ CREATE TABLE `Comment` (
   `id` int(11) NOT NULL auto_increment,
   `user_id` int(11) default NULL,
   `play_id` int(11) default NULL,
+  `game_id` int(11) default NULL,
   `comment` text,
   UNIQUE KEY `id` (`id`),
   KEY `play_id` (`play_id`)
@@ -491,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)