[Devel] r450 - trunk

[svn at agendadulibre.org]

Author: thomas
Date: Sun Aug  9 01:13:16 2009
New Revision: 450

Log:
Mise à jour de schema.sql

Signed-off-by: Thomas Petazzoni <thomas.petazzoni at free-electrons.com>

Modified:
   trunk/schema.sql

Modified: trunk/schema.sql
==============================================================================
--- trunk/schema.sql	Fri Aug  7 20:24:07 2009	(r449)
+++ trunk/schema.sql	Sun Aug  9 01:13:16 2009	(r450)
@@ -10,9 +10,13 @@
   `url` varchar(255) NOT NULL default '',
   `contact` varchar(255) NOT NULL default '',
   `submitter` varchar(255) NOT NULL default '',
+  `moderated` int(11) NOT NULL default '0',
   `tags` varchar(255) NOT NULL default '',
   `secret` varchar(255) NOT NULL default '',
-  `moderated` int(11) NOT NULL default '0',
+  `decision_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `submission_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `moderator_mail_id` varchar(32) default NULL,
+  `submitter_mail_id` varchar(32) default NULL,
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;