aboutsummaryrefslogtreecommitdiff
path: root/sql/mysql.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2014-04-24added privacy_list_data index for mysql database.HAMANO Tsukasa1-0/+1
2014-03-13Update copyright dates to 2014 (EJAB-1679)Badlop1-1/+1
2014-02-22Update FSF addressJamie Nguyen1-4/+3
2013-10-23Get rid of deprecated MySQL variable 'table_type'Evgeniy Khramtsov1-29/+25
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/+5
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-11-17Use MEDIUMTEXT type for vcard avatars in MySQL schema (EJAB-1252)Evgeniy Khramtsov1-1/+1
2010-01-12Update year of ProcessOne copyright from 2009 to 2010 (EJAB-1159)Badlop1-1/+1
SVN Revision: 2891
2009-09-10Add a "created_at" column to some tables in the MySQL schema to storeJérôme Sautret1-6/+12
a timestamp (thanks to Pedro Melo, EJAB-376). SVN Revision: 2593
2009-09-10Fix pubsub tables constraints in MySQL schema creation script.Jérôme Sautret1-6/+6
SVN Revision: 2592
2009-08-07typo fix on subscriptionsChristophe Romain1-1/+1
SVN Revision: 2438
2009-08-07initial merge of pubsub odbc, compilation pass okChristophe Romain1-0/+55
SVN Revision: 2437
2009-08-06Support for roster versioning (EJAB-964)Pablo Polvorin1-0/+6
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-1/+1
* 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/+19
SVN Revision: 1113
2007-09-28Added some missing NOT NULL restrictionsChristophe Romain1-3/+3
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-202006-11-20 Mickael Remond <mickael.remond@process-one.net>Mickaël Rémond1-0/+27
* src/ejd2odbc.erl: Copy mod_private data from Mnesia to relational database. * src/odbc/odbc_queries.erl: Refactoring. * src/odbc/mssql.sql: Likewise. * doc/guide.tex: Update to mention mod_private_odbc. * src/odbc/mysql.sql: Started integration of mod_privacy_odbc for MySQL and MSSQL. * src/odbc/mssql.sql: Likewise. SVN Revision: 678
2006-11-05* src/odbc/mysql.sql: Fix database creation script.Mickaël Rémond1-2/+2
SVN Revision: 675
2006-11-05* src/mod_private_odbc.erl: Support for MySQL and MSSQL.Mickaël Rémond1-0/+9
* src/odbc/odbc_queries.erl: Likewise. * src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 674
2006-11-04* src/odbc/mysql: Database creation script should now be compliant withMickaël Rémond1-6/+6
MySQL 4.0.x. SVN Revision: 673
2006-11-04* src/odbc/pg.sql: Database scripts consistency.Mickaël Rémond1-8/+11
* src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 672
2006-05-23* src/mod_roster.erl: The subscribe request are now resend atMickaël Rémond1-0/+3
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-13* src/odbc/ejabberd_odbc.erl: underscore and percent are now onlyMickaël Rémond1-19/+16
escaped in like queries. MySQL where not escaping those escaped characters in other context (EJAB-24) * src/mod_vcard_odbc.erl: likewise. * src/odbc/mysql.sql: Fixed MySQL database creation script: Was not properly working with all MySQL version. SVN Revision: 484
2005-12-23Added missing file.Mickaël Rémond1-38/+37
SVN Revision: 480
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 2025-09-07 19:09:36 +0000