-/* Copyright 2006, 2007, 2008, 2009, 2010 Arun Persaud <arun@nubati.net>
+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 Arun Persaud <arun@nubati.net>
*
* This file is part of e-DoKo.
*
DROP TABLE IF EXISTS `Version`;
CREATE TABLE `Version` (
- `version` int NOT NULL default '0'
+ `version` int NOT NULL default '5'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
`id` int(11) NOT NULL auto_increment,
`fullname` varchar(64) default NULL,
`email` varchar(64) default NULL,
- `password` varchar(32) default NULL,
+ `password` varchar(62) default NULL,
`timezone` varchar(64) default 'Europe/London',
`last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
`create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
`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)