diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/lite.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/lite.sql b/sql/lite.sql index c2bc126fc..b0c8675f5 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -299,8 +299,8 @@ CREATE TABLE muc_room_subscribers ( created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); -CREATE INDEX i_muc_room_subscribers_host_jid USING BTREE ON muc_room_subscribers(host, jid); -CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid USING BTREE ON muc_room_subscribers(host, room, jid); +CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers(host, jid); +CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers(host, room, jid); CREATE TABLE irc_custom ( jid text NOT NULL, |