From c9daa3c8fa7687c853e9ad760a310084baffba26 Mon Sep 17 00:00:00 2001 From: thomasb Date: Wed, 10 Oct 2007 06:38:23 +0000 Subject: Set prefs field in user table to null (#1484386) git-svn-id: https://svn.roundcube.net/trunk@861 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/SQL/mysql.initial.sql | 2 +- roundcubemail/SQL/mysql5.initial.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'roundcubemail/SQL') diff --git a/roundcubemail/SQL/mysql.initial.sql b/roundcubemail/SQL/mysql.initial.sql index 4bba84c6a..926a83eab 100644 --- a/roundcubemail/SQL/mysql.initial.sql +++ b/roundcubemail/SQL/mysql.initial.sql @@ -92,7 +92,7 @@ CREATE TABLE `users` ( `created` datetime NOT NULL default '0000-00-00 00:00:00', `last_login` datetime NOT NULL default '0000-00-00 00:00:00', `language` varchar(5) NOT NULL default 'en', - `preferences` text NOT NULL default '', + `preferences` text, PRIMARY KEY (`user_id`) ); diff --git a/roundcubemail/SQL/mysql5.initial.sql b/roundcubemail/SQL/mysql5.initial.sql index 79817691e..1a6ef1990 100644 --- a/roundcubemail/SQL/mysql5.initial.sql +++ b/roundcubemail/SQL/mysql5.initial.sql @@ -28,7 +28,7 @@ CREATE TABLE `users` ( `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `language` varchar(5) NOT NULL DEFAULT 'en', - `preferences` text NOT NULL DEFAULT '', + `preferences` text, PRIMARY KEY(`user_id`) ) TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; -- cgit v1.2.3