projects
/
e-DoKo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
reuse random number: test select distinct
[e-DoKo.git]
/
create_database.sql
diff --git
a/create_database.sql
b/create_database.sql
index 9db587a37ec52f9c5e36949a39b0e40a98858406..795dfe110000964b4c92d4fa545e2bdc7a6482ef 100644
(file)
--- 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, 2013, 2014
Arun Persaud <arun@nubati.net>
*
* This file is part of e-DoKo.
*
*
* This file is part of e-DoKo.
*
@@
-38,7
+38,7
@@
DROP TABLE IF EXISTS `Version`;
CREATE TABLE `Version` (
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;
--
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
@@
-360,7
+360,7
@@
CREATE TABLE `User` (
`id` int(11) NOT NULL auto_increment,
`fullname` varchar(64) default NULL,
`email` varchar(64) default NULL,
`id` int(11) NOT NULL auto_increment,
`fullname` varchar(64) default NULL,
`email` varchar(64) default NULL,
- `password` varchar(
3
2) default NULL,
+ `password` varchar(
6
2) 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',
`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',
@@
-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',
`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)
`content` text,
UNIQUE KEY `id` (`id`),
index (email)