aboutsummaryrefslogtreecommitdiff
path: root/sql/mysql.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2016-08-01Add OAUTH SQL backendAlexey Shchepin1-0/+7
2016-05-02Use MEDIUMTEXT type for muc_room.opts in MySQL schemaJuan Pablo Carlino1-1/+1
2016-04-12Synchronizing master changesMickael Remond1-4/+4
2016-04-08Switch to varchar(64) in mysql user.server/salt as text can't have default ↵Paweł Chmielowski1-4/+4
values
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-12-11Use UTF8MB4 character set in MySQL tablesEvgeniy Khramtsov1-71/+71
2015-12-11Use BLOB instead of TEXT on mysql in stanza storagePablo Polvorin1-1/+1
Mysql 'utf8' do not support 4-bytes UTF8 chars. Characters like 'KISS MARK' (U+1F48B) causes mysql to cut the string at that point. There is utf8mb4 encoding available on newer mysql versions that do support 4-bytes utf8. But for storing stanzas, that doesn't need to be indexed or searched or inspected in any way, it was easier to use BLOB (the bytes stored are utf8 encoded anyway, like all XMPP), and avoids the need to redefine indexes (as allowed size is shorter on utf8mb4) or having mixed utf8 and utf8mb4 encodings on the same table.
2015-08-08Add support for MUC MAMEvgeniy Khramtsov1-0/+2
2015-06-22Add MAM (XEP-0313) supportEvgeniy Khramtsov1-0/+25
2015-03-21Remove duplicate CREATE INDEX in mysql.sqlAlexey Shchepin1-2/+1
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-03-20Added MySQL support for delete_old_messages (offline) command.Jerome Sautret1-0/+1
2015-03-09Make it possible to use SQL as an SM backendEvgeniy Khramtsov1-0/+14
2015-01-08Update copyright dates to 2015 (EJAB-1733)Badlop1-1/+1
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
generated by cgit v1.2.3 (git 2.25.1) at 2025-09-10 17:24:47 +0000