From 38b012e072f808393f87f5cc3059fab7072fb8b7 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Fri, 08 Feb 2008 12:33:08 -0500 Subject: [PATCH] Added some charset aliases to fix typical mis-labelling (#1484565) --- SQL/mysql5.initial.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql index 0c0dcb1..1a6ef19 100644 --- a/SQL/mysql5.initial.sql +++ b/SQL/mysql5.initial.sql @@ -12,10 +12,10 @@ `sess_id` varchar(40) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `ip` varchar(15) NOT NULL, + `ip` varchar(40) NOT NULL, `vars` text NOT NULL, PRIMARY KEY(`sess_id`) -) TYPE=MYISAM CHARACTER SET ascii COLLATE ascii_general_ci; +) TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; -- Table structure for table `users` @@ -28,7 +28,7 @@ `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; -- Gitblit v1.9.1