aboutsummaryrefslogtreecommitdiff
path: root/sql/pg.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2005-10-19* src/odbc/pg.sql: Added spool.seq field for offline messagesAlexey Shchepin1-1/+8
sorting * src/mod_offline_odbc.erl: Likewise SVN Revision: 424
2005-10-06* src/ejd2odbc.erl: Added vCard converterAlexey Shchepin1-46/+47
* src/mod_vcard_odbc.erl: vCard support via ODBC * src/odbc/pg.sql: Updated SVN Revision: 414
2004-12-13* src/odbc/pg.sql: DB creation script for postgresAlexey Shchepin1-0/+89
* src/odbc/ejabberd_odbc.erl: Experimental support for ODBC * src/mod_last_odbc.erl: Likewise * src/mod_offline_odbc.erl: Likewise * src/ejabberd_auth_odbc.erl: Likewise * src/ejabberd_auth.erl: Likewise SVN Revision: 292
generated by cgit v1.2.3 (git 2.25.1) at 2024-12-05 02:27:25 +0000