diff options
| author | thomascube <thomas@roundcube.net> | 2007-10-10 06:38:23 +0000 |
|---|---|---|
| committer | thomascube <thomas@roundcube.net> | 2007-10-10 06:38:23 +0000 |
| commit | 112bff6f1129de9966155f841bb0a6e855110886 (patch) | |
| tree | 394bcef1e74d7ce1885dd8904f1d106bc542585b /SQL | |
| parent | 732539598dbc7ef7c0d1c7d642f69dff5372d246 (diff) | |
Set prefs field in user table to null (#1484386)
Diffstat (limited to 'SQL')
| -rw-r--r-- | SQL/mysql.initial.sql | 2 | ||||
| -rw-r--r-- | SQL/mysql5.initial.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 4bba84c6a..926a83eab 100644 --- a/SQL/mysql.initial.sql +++ b/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/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql index 79817691e..1a6ef1990 100644 --- a/SQL/mysql5.initial.sql +++ b/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; |