Use InnoDB and UTF-8 options when creating user_im_prefs table, to match others

[quix0rs-gnu-social.git] / db / statusnet.sql

diff --git a/db/statusnet.sql b/db/statusnet.sql
index d1cd67075091c3f83083991f4481ec8383bc0a5e..16d09a11f762a8264df1cdbb90a82da2bdc2b287 100644 (file)
--- 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',