75 Commits (20.03)

Author	SHA1	Message	Date
Mickaël Rémond	3947e64524	Merge pull request #3127 from area-42/allow_emojis_with_mssql ... allow storage of emojis in archive on mssql	3 years ago
Paweł Chmielowski	87ea71c3c9	Add missing oauth_client table declaration in lite.new.sql	3 years ago
Badlop	2d32c66fd7	Update copyright to 2020 (#3149)	3 years ago
Christoph Scholz	00ccb119ea	allow storage of emojis in archive on mssql	3 years ago
Evgeny Khramtsov	86bb77bfc2	Make PostgreSQL schema compatible with CockroachDB	3 years ago
Alexey Shchepin	5d549dca96	Check redirect_uri for OAUTH implicit grant	4 years ago
Alexey Shchepin	8f7fa38949	Support OAUTH client authentication	4 years ago
Paweł Chmielowski	a2fa52a192	Change type of server_host column in mysql.new.sql ... Indexes are done only on 191 byte slice of that (to fit in index limits), and since server_host could theoretically be bigger this causes mysql engine don't use indexes in full potential.	4 years ago
Evgeny Khramtsov	7511da0f26	Add SQL schemas for MQTT tables	4 years ago
Holger Weiss	90dc8ea1e5	MySQL: Increase index prefix length for PEP nodes ... For PEP nodes, the "host" column holds the user JID, where the first 20 characters may well not be unique.	4 years ago
Evgeny Khramtsov	1684436bfe	Merge branch 'mix'	4 years ago
Badlop	f0cf63de15	Manually update 2017 copyright dates (#2756)	4 years ago
Evgeny Khramtsov	d5e4da54cf	Update MIX code to reflect newest specification ... 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	4 years ago
Evgeny Khramtsov	109ed8f2f6	Keep info about carbons inside session table ... 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	4 years ago
Holger Weiss	5dcf2cde9c	MySQL: Use MEDIUMTEXT for PubSub payload ... Let MySQL/MariaDB accept PubSub payloads with a size of up to 16 MiB, rather than truncating at 64 KiB.	5 years ago
Holger Weiss	3367c5b120	MySQL: Use MEDIUMTEXT for MAM/offline messages ... Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB, rather than truncating at 64 KiB.	5 years ago
rouen-sk	b199b68380	Update mssql.sql ... Fixed: - conflicting clustered indexes on 2 tables - semicolon type - Azure SQL incompatibility	5 years ago
Evgeniy Khramtsov	3a5d2dbed8	Move mod_irc to ejabberd-contrib	5 years ago
Christophe Romain	61dee97738	Pubsub creation/modification use varchar (#2397)	5 years ago
Paweł Chmielowski	5912c573ea	Use length on fields in mysql indexes	5 years ago
Holger Weiss	f7566bd00e	sql/*: Add username to peer indexes ... The username is available for all MAM queries in question, and adding it to the indexes can improve the lookup performance significantly.	5 years ago
phejman	bef7d1ba66	Fix MySQL error server_host used in key specification without a key length	5 years ago
Alexey Shchepin	34d09018a7	Add new schemas for SQLite and MySQL	5 years ago
Alexey Shchepin	cf67b9ec54	Add missed server_host column in pg.new.sql	5 years ago
Christophe Romain	44700d91ba	PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.plugin	5 years ago
Alexey Shchepin	78dfb832b8	Add SQL_INSERT macro and update SQL queries to use server_host field	5 years ago
Paweł Chmielowski	ce98843dd4	Fix sql syntax error in lite.sql	5 years ago
Christophe Romain	0452ffc1df	Optimize muc subscriptions handling	5 years ago
Alexey Shchepin	e1c8e88d87	Update SQL archive index to match mysql.sql	5 years ago
Evgeniy Khramtsov	db57394399	Add SQL support for mod_push	5 years ago
Holger Weiss	1c6aa5e84e	mysql.sql: Use multi-column index on username/ID	6 years ago
Evgeniy Khramtsov	6691c59a7a	Clean up database code related to mod_vcard_xupdate	6 years ago
Evgeniy Khramtsov	f449df161a	Add SQL as mod_proxy65 RAM backend	6 years ago
Evgeniy Khramtsov	31fd83b2ae	Add SQL as mod_carboncopy RAM backend	6 years ago
Evgeniy Khramtsov	12e01a5119	Add SQL as mod_muc RAM backend	6 years ago
Evgeniy Khramtsov	e5815553cb	Add SQL as mod_bosh RAM backend	6 years ago
Evgeniy Khramtsov	117f31125d	Add SQL as router RAM backend	6 years ago
Jerome Sautret	bc9f178b6d	Fix pubsub MySQL schema	6 years ago
Christophe Romain	56df6e7ba8	Add missing NOT NULL restrictions	6 years ago
Christophe Romain	c0b346e0b8	Move archive tables into lite.sql for better comparison with other schemas	6 years ago
Badlop	5fdd1c39fe	Update copyright date automatically (#1442)	6 years ago
Christophe Romain	ed679279fd	Cleanup file headers	6 years ago
Alexey Shchepin	4add262090	Add OAUTH SQL backend	7 years ago
Juan Pablo Carlino	671bc4e573	Use MEDIUMTEXT type for muc_room.opts in MySQL schema	7 years ago
Paweł Chmielowski	b4739396ec	Switch to varchar(64) in mysql user.server/salt as text can't have default values	7 years ago
Evgeniy Khramtsov	c5dbdfc71a	'serverkey' and 'salt' should have empty string as default	7 years ago
Badlop	e386bf6b58	In SQL files create Users table with SCRAM support by default (#956)	7 years ago
Evgeniy Khramtsov	b0ef3e66a8	Update MSSQL schema	7 years ago
Evgeniy Khramtsov	4b0860e7de	Make it possible to define 'sm_db_type' per virtual host	7 years ago
Badlop	f448ff608a	Update copyright to 2016 (#901)	7 years ago