diff options
author | Alexey Shchepin <alexey@process-one.net> | 2015-03-18 18:46:46 +0300 |
---|---|---|
committer | Christophe Romain <christophe.romain@process-one.net> | 2015-03-20 10:40:25 +0100 |
commit | 0eb6b942fff9d7cf3b5046ea71825d0897277d06 (patch) | |
tree | ce82807d83fefc9a740b2818a95766b59fab5363 /sql/mysql.sql | |
parent | Added MySQL support for delete_old_messages (offline) command. (diff) |
Add a missed SQL index on privacy_list_data table
Diffstat (limited to '')
-rw-r--r-- | sql/mysql.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 8557d0804..e591092f7 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -161,6 +161,8 @@ CREATE TABLE privacy_list_data ( ) ENGINE=InnoDB CHARACTER SET utf8; CREATE INDEX i_privacy_list_data_id ON privacy_list_data(id); +CREATE INDEX i_privacy_list_data_id USING BTREE ON privacy_list_data(id); + CREATE TABLE private_storage ( username varchar(250) NOT NULL, namespace varchar(250) NOT NULL, |