From c6e808e90c67f08a821907053a83013a9213a021 Mon Sep 17 00:00:00 2001 From: svncommit <devs@roundcube.net> Date: Tue, 24 Jan 2006 23:33:25 -0500 Subject: [PATCH] fixed mysql SQL scripts for new created column --- SQL/mysql.update.sql | 1 + SQL/mysql.initial.sql | 1 + 2 files changed, 2 insertions(+), 0 deletions(-) diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index eabc75e..acaac7b 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -106,6 +106,7 @@ `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 e93fc98..08ce920 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -31,6 +31,7 @@ `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 '', -- Gitblit v1.9.1