summaryrefslogtreecommitdiff
path: root/db/statusnet.sql
diff options
context:
space:
mode:
authorBrion Vibber <brion@pobox.com>2010-03-24 14:18:06 -0700
committerBrion Vibber <brion@pobox.com>2010-03-24 14:18:06 -0700
commit64b5ea2e6238017fba5ad53274d26d53ed2b5fb3 (patch)
treea9b8edc9bac66efbff48922d9c305eb54e60fb42 /db/statusnet.sql
parentc3ceaa893fa878d531b0af05a3a8ed367177848c (diff)
Use InnoDB and UTF-8 options when creating user_im_prefs table, to match others
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r--db/statusnet.sql2
1 files changed, 1 insertions, 1 deletions
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',