aboutsummaryrefslogtreecommitdiff
path: root/sql/lite.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
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-02-22Move archive tables into lite.sql for better comparison with other schemasChristophe Romain1-26/+25
2017-01-02Update copyright date automatically (#1442)Badlop1-1/+1
2016-08-01Add OAUTH SQL backendAlexey Shchepin1-0/+7
2016-03-29In SQL files create Users table with SCRAM support by default (#956)Badlop1-0/+3
2016-02-19Make it possible to define 'sm_db_type' per virtual hostEvgeniy Khramtsov1-0/+14
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-0/+24
2015-03-27Fix lite.sql and convert binary to integerSergey Abramyan1-4/+4
2015-03-20Add SQLite supportSergey Abramyan1-58/+46
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
2012-02-23Update copyright datesAlexey Shchepin1-1/+1
2011-02-14update copyright up to 2011Christophe Romain1-1/+1
2010-05-26Add created_at column also to PostgreSQL schema (thanks to Mathias ↵Badlop1-6/+12
Ertl)(EJAB-1240)
2010-01-12Update year of ProcessOne copyright from 2009 to 2010 (EJAB-1159)Badlop1-1/+1
SVN Revision: 2891
2009-08-07typo fix on subscriptionsChristophe Romain1-1/+1
SVN Revision: 2438
2009-08-07initial merge of pubsub odbc, compilation pass okChristophe Romain1-0/+51
SVN Revision: 2437
2009-08-06Support for roster versioning (EJAB-964)Pablo Polvorin1-0/+5
Introduces two options for mod_roster and mod_roster_odbc: - {versioning, true | false} Enable or disable roster versioning on ejabberd. - {store_current_id, true | false} If true, the current roster version is stored on DB (internal or odbc). Otherwise it is calculated on the fly each time. Performance: Setting store_current_id to true should help in reducing the load for both ejabberd and the DB. Details: If store_current_id is false, the roster version is a hash of the entire roster. If store_current_id is true, the roster version is a hash, but of the current time (this has to do with transactional semantics; we need to perform both the roster update and the version update on the same transaction, but we don't have the entire roster when we are changing a single item on DB. Loading it there requires significant changes to be introduced, so I opted for this simpler approach). In either case, there is no difference for the clients, the roster version ID is opaque. IMPORTANT: mod_shared_roster is not compatible with the option 'store_current_id'. Shared roster and roster versioning can be both enabled, but store_current_id MUST be set to false. SVN Revision: 2428
2009-01-23* src/odbc/mysql.sql: Fix complain about comment syntaxBadlop1-2/+2
* src/odbc/pg.sql: Likewise SVN Revision: 1850
2009-01-12* doc/guide.tex: Update copyright date 2008 to 2009 (EJAB-842)Badlop1-1/+1
* doc/guide.html: Likewise * src/*/*.erl: Likewise * src/*/*.erl: Remove unneeded blankspaces in license text SVN Revision: 1804
2008-07-31* doc/guide.tex: Update Process-one name to ProcessOne (EJAB-708)Badlop1-1/+1
* doc/guide.html: Likewise * doc/api/overview.edoc: Likewise * src/*/*.erl: Likewise * src/*/*.hrl: Likewise * src/*/*.c: Likewise * src/odbc/*.sql: Likewise SVN Revision: 1499
2008-01-15* doc/guide.tex: Updated copyright dates to 2008Badlop1-1/+1
* src/*: Likewise SVN Revision: 1153
2007-12-24* Applied copyright patch 3.Mickaël Rémond1-0/+18
SVN Revision: 1113
2007-09-28Added some missing NOT NULL restrictionsChristophe Romain1-1/+1
SVN Revision: 952
2007-07-09* src/odbc/mssql.sql: Nickname cannot be null in rosterusers table (MSSQL)Mickaël Rémond1-1/+1
* src/odbc/mysql.sql: Likewise * src/odbc/pg.sql: Likewise SVN Revision: 809
2007-02-19* src/odbc/pg.sql: last table, state column cannot be NULL (EJAB-191).Mickaël Rémond1-1/+1
* src/odbc/mysql.sql: likewise. * src/odbc/mssql.sql. likewise. SVN Revision: 732
2006-11-04* src/odbc/pg.sql: Database scripts consistency.Mickaël Rémond1-1/+1
* src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 672
2006-10-19* src/ejabberd_socket.erl: Added sockname/1 and peername/1Alexey Shchepin1-0/+8
functions * src/ejabberd_frontend_socket.erl: Likewise * src/tls/tls.erl: Likewise * src/ejabberd_zlib/ejabberd_zlib.erl: Likewise * src/mod_private_odbc.erl: Private storage support using odbc * src/odbc/pg.sql: Likewise SVN Revision: 663
2006-10-09* src/mod_privacy_odbc.erl: Privacy rules support using odbcAlexey Shchepin1-2/+9
* src/odbc/pg.sql: Likewise * src/web/ejabberd_http_poll.erl: Bugfix SVN Revision: 660
2006-10-05* src/mod_privacy.erl: Use hooks instead of direct function callsAlexey Shchepin1-0/+22
* src/ejabberd_c2s.erl: Updated SVN Revision: 659
2006-09-03* src/odbc/odbc_queries.erl: Support for Microsoft SQL Server asMickaël Rémond1-1/+1
a database backend (via ODBC). * src/odbc/ejabberd_odbc.erl: Likewise. * src/odbc/mssql.sql: Likewise. * src/odbc/Makefile.in: Likewise. * src/ejabberd_auth_odbc.erl: Likewise. * src/mod_offline_odbc.erl: Likewise. * src/mod_roster_odbc.erl: Likewise. * src/mod_last_odbc.erl: Likewise. * src/configure.ac: Likewise * doc/guide.tex: Likewise. * doc/introduction.tex: Likewise. * src/odbc/pg.sql: Minor fix. SVN Revision: 598
2006-05-26* src/odbc/pg.sql: UpdatedAlexey Shchepin1-2/+4
* src/mod_shared_roster.erl: Updated * src/ejabberd_sm.erl: Bugfix * src/mod_roster.erl: Bugfix * src/mod_roster_odbc.erl: Likewise SVN Revision: 570
2006-05-23* src/mod_roster.erl: The subscribe request are now resend atMickaël Rémond1-6/+11
login as long as they have not been answered. mod_roster do no more depends on mod_offline. * src/ejabberd_sm.erl: Likewise. * src/ejabberd_c2s.erl: Likewise. * src/mod_roster_odbc.erl: Likewise (The ODBC/relational support has not yet been tested). * src/mod_roster.hrl: Likewise. * src/mod_offline.erl: Likewise. * src/mod_offline_odbc.erl: Likewise. * odbc/pg.sql: Likewise. * odbc/mysql.sql: Likewise. SVN Revision: 569
2006-01-29* src/odbc/pg.sql: Fixed syntax errorAlexey Shchepin1-6/+6
* src/ejabberd_router.erl: Updated to use gen_server behaviour * src/ejabberd_sm.erl: Likewise * src/ejabberd_s2s.erl: Likewise * src/gen_iq_handler.erl: Likewise * src/ejabberd_sup.erl: Added supervisor for ejabberd_receiver * src/ejabberd_receiver.erl: Updated SVN Revision: 495