From 64b5ea2e6238017fba5ad53274d26d53ed2b5fb3 Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@pobox.com>
Date: Wed, 24 Mar 2010 14:18:06 -0700
Subject: Use InnoDB and UTF-8 options when creating user_im_prefs table, to
 match others

---
 db/statusnet.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'db/statusnet.sql')

diff --git a/db/statusnet.sql b/db/statusnet.sql
index d1cd67075..16d09a11f 100644
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -647,7 +647,7 @@ create table user_im_prefs (
 
     constraint primary key (user_id, transport),
     constraint unique key `transport_screenname_key` ( `transport` , `screenname` )
-);
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
 
 create table conversation (
     id integer auto_increment primary key comment 'unique identifier',
-- 
cgit v1.2.3-54-g00ecf

