aboutsummaryrefslogtreecommitdiff
path: root/sql/pg.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2022-02-18Optimize room_unused_* commandsPaweł Chmielowski1-0/+1
Previously to check if hibernated room was old enough we had to fetch info about all rooms from database. Now we repurpose created_at field in sql to store that info, that allow us to have more efficient query just for it.
2022-02-11Update copyright year to 2022Badlop1-1/+1
2021-12-14Handle user removal in mod_mucAlexey Shchepin1-0/+1
2021-05-18Add missing indexes to sql sr_group tablesPaweł Chmielowski1-0/+2
2021-01-27Update newest copyright year to 2021 (#3464)Badlop1-1/+1
2020-01-28Update copyright to 2020 (#3149)Badlop1-1/+1
2019-10-23Make PostgreSQL schema compatible with CockroachDBEvgeny Khramtsov1-1/+1
2019-10-03Check redirect_uri for OAUTH implicit grantAlexey Shchepin1-2/+2
2019-09-27Support OAUTH client authenticationAlexey Shchepin1-0/+7
2019-02-27Add SQL schemas for MQTT tablesEvgeny Khramtsov1-0/+16
2019-01-08Manually update 2017 copyright dates (#2756)Badlop1-1/+1
2018-12-05Update MIX code to reflect newest specificationEvgeny Khramtsov1-0/+53
Note that support for older specification is completely dropped, i.e. no backward compatibility is provided since the XEPs are still very experimental and being changed drastically
2018-12-01Keep info about carbons inside session tableEvgeny Khramtsov1-10/+0
Accordingly, Mnesia/SQL/Riak table 'carboncopy' is not used anymore and can be safely removed. As a consequence, the commit deprecates the following options of mod_carboncopy: - ram_db_type - use_cache - cache_size - cache_missed - cache_life_time Fixes #2663
2018-06-20Move mod_irc to ejabberd-contribEvgeniy Khramtsov1-9/+0
2018-04-24Pubsub creation/modification use varchar (#2397)Christophe Romain1-2/+2
2018-02-24sql/*: Add username to peer indexesHolger Weiss1-2/+2
The username is available for all MAM queries in question, and adding it to the indexes can improve the lookup performance significantly.
2017-11-16PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.pluginChristophe Romain1-1/+1
2017-10-31Optimize muc subscriptions handlingChristophe Romain1-0/+12
2017-10-27Update SQL archive index to match mysql.sqlAlexey Shchepin1-1/+1
2017-10-26Add SQL support for mod_pushEvgeniy Khramtsov1-0/+11
2017-05-17Clean up database code related to mod_vcard_xupdateEvgeniy Khramtsov1-6/+0
2017-03-31Add SQL as mod_proxy65 RAM backendEvgeniy Khramtsov1-0/+12
2017-03-30Add SQL as mod_carboncopy RAM backendEvgeniy Khramtsov1-0/+10
2017-03-29Add SQL as mod_muc RAM backendEvgeniy Khramtsov1-0/+21
2017-03-28Add SQL as mod_bosh RAM backendEvgeniy Khramtsov1-0/+8
2017-03-28Add SQL as router RAM backendEvgeniy Khramtsov1-0/+11
2017-02-22Add missing NOT NULL restrictionsChristophe Romain1-17/+17
2017-01-02Update copyright date automatically (#1442)Badlop1-1/+1
2016-12-27Cleanup file headersChristophe Romain1-1/+1
2016-08-01Add OAUTH SQL backendAlexey Shchepin1-0/+9
2016-03-29In SQL files create Users table with SCRAM support by default (#956)Badlop1-1/+4
2016-01-13Update copyright to 2016 (#901)Badlop1-1/+1
2015-08-08Add support for MUC MAMEvgeniy Khramtsov1-0/+2
2015-06-22Add MAM (XEP-0313) supportEvgeniy Khramtsov1-3/+26
2015-05-20Add missing sm table (thanks to Rasim Kalimullin)(EJAB-1740)Christophe Romain1-0/+14
2015-05-20Revert "added sm table to pg.sql"Evgeny Khramtsov1-15/+0
2015-05-17pg - added sm tableMatthias Rieber1-0/+15
2015-03-20Add SCRAM support to ejabberd_auth_odbcAlexey Shchepin1-0/+4
2015-03-20Add a missed SQL index on privacy_list_data tableAlexey Shchepin1-0/+2
2015-01-08Update copyright dates to 2015 (EJAB-1733)Badlop1-1/+1
2014-03-13Update copyright dates to 2014 (EJAB-1679)Badlop1-1/+1
2014-02-22Update FSF addressJamie Nguyen1-4/+3
2013-06-13Switch to rebar build toolEvgeniy Khramtsov1-0/+0
Use dynamic Rebar configuration Make iconv dependency optional Disable transient_supervisors compile option Add hipe compilation support Only compile ibrowse and lhttpc when needed Make it possible to generate an OTP application release Add --enable-debug compile option Add --enable-all compiler option Add --enable-tools configure option Add --with-erlang configure option. Add --enable-erlang-version-check configure option. Add lager support Improve the test suite
2013-03-14Accumulated patch to binarize and indent codeBadlop1-0/+9
2013-01-24Update copyright datesAlexey Shchepin1-1/+1
2012-04-04ODBC support for mod_shared_rosterEvgeniy Khramtsov1-0/+15
2012-04-03ODBC support for mod_ircEvgeniy Khramtsov1-0/+9
2012-04-02ODBC support for mod_vcard_xupdateEvgeniy Khramtsov1-0/+6
2012-04-02ODBC support for mod_announceEvgeniy Khramtsov1-0/+6
2012-03-31ODBC support for mod_mucEvgeniy Khramtsov1-0/+19