From 137bf73aa007dde8f60ac072acefdb3d986c2311 Mon Sep 17 00:00:00 2001 From: justinrandell Date: Wed, 25 Jan 2006 04:33:25 +0000 Subject: fixed mysql SQL scripts for new created column git-svn-id: https://svn.roundcube.net/trunk@124 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/SQL/mysql.initial.sql | 1 + roundcubemail/SQL/mysql.update.sql | 1 + 2 files changed, 2 insertions(+) diff --git a/roundcubemail/SQL/mysql.initial.sql b/roundcubemail/SQL/mysql.initial.sql index eabc75e1f..acaac7bdf 100644 --- a/roundcubemail/SQL/mysql.initial.sql +++ b/roundcubemail/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/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql index e93fc980f..08ce92019 100644 --- a/roundcubemail/SQL/mysql.update.sql +++ b/roundcubemail/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 '', -- cgit v1.2.3