summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorsvncommit <devs@roundcube.net>2006-01-25 04:33:25 +0000
committersvncommit <devs@roundcube.net>2006-01-25 04:33:25 +0000
commitc6e808e90c67f08a821907053a83013a9213a021 (patch)
tree1a1ce97f1028a79b829177b2d12e5434a57fc6e0
parent9d04c24ffa1e3ba541333d1d405857aa016ccde8 (diff)
fixed mysql SQL scripts for new created column
-rw-r--r--SQL/mysql.initial.sql1
-rw-r--r--SQL/mysql.update.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql
index eabc75e1f..acaac7bdf 100644
--- a/SQL/mysql.initial.sql
+++ b/SQL/mysql.initial.sql
@@ -106,6 +106,7 @@ CREATE TABLE `messages` (
`user_id` int(11) unsigned NOT NULL default '0',
`del` tinyint(1) NOT NULL default '0',
`cache_key` varchar(128) NOT NULL default '',
+ `created` datetime NOT NULL default '0000-00-00 00:00:00',
`idx` int(11) unsigned NOT NULL default '0',
`uid` int(11) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index e93fc980f..08ce92019 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -31,6 +31,7 @@ CREATE TABLE `messages` (
`user_id` int(11) unsigned NOT NULL default '0',
`del` tinyint(1) NOT NULL default '0',
`cache_key` varchar(128) NOT NULL default '',
+ `created` datetime NOT NULL default '0000-00-00 00:00:00',
`idx` int(11) unsigned NOT NULL default '0',
`uid` int(11) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',