diff options
| author | Paweł Chmielowski <pchmielowski@process-one.net> | 2017-10-31 14:43:36 +0100 |
|---|---|---|
| committer | Paweł Chmielowski <pchmielowski@process-one.net> | 2017-10-31 14:43:36 +0100 |
| commit | ce98843dd4d303969845fceba22c0f81e2163224 (patch) | |
| tree | f871e47e36550d4691953d1a6a3e1bc34637bb87 /sql | |
| parent | Don't use depraced functions (diff) | |
Fix sql syntax error in lite.sql
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, |