Commit Graph

166 Commits

Author SHA1 Message Date
Michael Voříšek
28c778b7a0
Modernize more CS III (#9270)
* fix "single_trait_insert_per_statement"

* fix "empty_loop_condition"

* fix "backtick_to_shell_exec"

* fix "phpdoc_to_comment"

* fix "no_empty_statement"

* fix "heredoc_to_nowdoc"

* fix "class_reference_name_casing"

* fix "align_multiline_comment"

* fix "heredoc_indentation"

* fix "constant_case"

* fix "single_line_comment_style"

* fix "no_null_property_initialization"

* fix "standardize_increment"

* fix "no_unneeded_control_parentheses"

* fix missing NL after "<?php"

* fix php in *.sh files too

* fix trailing spaces from all text files

* fix "explicit_indirect_variable"

* Revert "fix "align_multiline_comment""

This reverts commit 42e584f8e3.

* fix "align_multiline_comment" properly

* Revert "fix trailing spaces from all text files" - diff files only

* Revert "Revert "fix trailing spaces from all text files" - diff files only"

This reverts commit 2101c2a3a3.

* rm useless "setup-php" config
2023-12-18 07:46:51 +01:00
Aleksander Machniak
c81c27e924 Move inline comment 2023-04-01 08:52:42 +02:00
Aleksander Machniak
80404a8674 Store uploads metadata in a separate sql database table instead of a session (#8415) 2022-10-09 11:35:14 +02:00
Aleksander Machniak
019801a430 Removed support for MS SQL Server and Oracle (#7854) 2022-09-11 11:01:03 +02:00
Aleksander Machniak
c56d7342fe Fix bug where it wasn't possible to create more than one response record on SQLite and Postgres (#8664) 2022-08-12 19:45:40 +02:00
Interduo
4f887f65ea
Don't declare default statement for MySQL columns in initial schema (#8485) 2022-04-10 12:06:58 +02:00
Interduo
71e5b26ea1
Don't declare default statement for postgres columns in initial schema (#8464) 2022-03-20 11:00:30 +01:00
iRedMail
3c5547195f
Fix incorrect (comment) syntax (#8416) 2022-01-25 07:52:16 +01:00
Aleksander Machniak
0c42af132e Fix installation/upgrade on MySQL 5.5 - Index column size too large (#8231) 2021-10-26 10:55:16 +02:00
Aleksander Machniak
48fbf110af SQLite: Use foreign keys, require SQLite >= 3.6.19 (#8159) 2021-10-03 12:10:14 +02:00
Aleksander Machniak
cb37d14c5c Support responses (snippets) in HTML format (#5315) 2021-08-28 19:17:19 +02:00
Josh Soref
203f456620
Spelling (#8001) 2021-04-18 08:43:18 +02:00
Marco Miltenburg
0278245653
Fixed errors in MSSQL database update scripts (#7853)
* If a column is dropped the constraint that uses that column must be dropped first.
* Removed trailing comma
* Fixed invalid SQL syntax
* Fixed syntax mistakes in MSSQL initial database script
2021-02-08 13:39:19 +01:00
Aleksander Machniak
6cddb27456 Allow NULL in users.preferences column in postgres and sqlite db, the same as for other engines (#7767) 2020-12-29 16:21:14 +01:00
Gianluca Giacometti
53f6e31cc5
Missing sequence in SQL update file (#7707) 2020-11-06 09:52:44 +01:00
Aleksander Machniak
f2e0b23a06 Fix typo 2020-09-20 10:06:41 +02:00
Aleksander Machniak
9713ce364c Automatically collected recipients and trusted senders (#6904)
Added configurable Collected Recipients addressbook source (#4971)
Added configurable Trusted Senders addressbook source (#5046)
Added 'contact_exists' hook
2020-09-20 10:00:08 +02:00
Aleksander Machniak
9d9901ee51 Fix sqlite/2020020100.sql (#7516) 2020-07-29 07:43:59 +02:00
Aleksander Machniak
cd2ec14b36 Fix MySQL DDL update 2020020101.sql (#7277) 2020-07-18 14:14:33 +02:00
Aleksander Machniak
dc1ce546b9 Fix sql syntax error introduced in last commit 2020-03-14 11:27:55 +01:00
Aleksander Machniak
2c1a22d283 Bring back BINARY for some columns after switch to utf8mb4 charset (#7277) 2020-03-14 08:31:28 +01:00
Aleksander Machniak
b606d81cdf MySQL: Use utf8mb4 charset and utf8mb4_unicode_ci collation (#6535, #7113)
Fixes support for utf8 emoji in html signature.
2020-02-01 17:19:04 +01:00
Aleksander Machniak
50d6ea30e0 Support for language codes up to 16 chars long (e.g. es-419) in database schema (#6851) 2020-02-01 09:40:11 +01:00
Aleksander Machniak
3841f63fbd Make cache keys case-sensitive on MySQL/MSSQL (#6942) 2019-09-29 13:18:46 +02:00
Aleksander Machniak
0e640e95c9 Enigma: Fixed multi-host syncronization of private and deleted keys and pubring.kbx file
Added context column to filestore table for easier listing of stored files.
2018-12-23 13:51:39 +01:00
Aleksander Machniak
72a3fb764b Fix compatibility with MySQL 8 - error on 'system' table use 2018-08-25 18:26:31 +02:00
Aleksander Machniak
656f979831 Fix column type (#6200) 2018-03-01 10:13:08 +01:00
Aleksander Machniak
7b1f0f020b Enigma: Multi-host support 2018-02-28 09:36:25 +01:00
Aleksander Machniak
75f9c103ee Fix syntax error in mssql.initial.sql (#6097) 2017-12-19 08:45:18 +01:00
Aleksander Machniak
cc0defce86 Fix failing database schema check in all engines except mysql (#5730) 2017-04-21 09:48:46 +02:00
Aleksander Machniak
a1f679adca Fixed redundancy in sql caching system and compatibility with Galera Cluster (#5439)
- Removed redundant 'created' column from cache and cache_shared tables
- Removed use of redundant data records
- Added missing primary keys (dictionary, cache, cache_shared tables)
2016-11-26 09:14:16 +01:00
Aleksander Machniak
32ffc4e637 Bump database version 2016-10-12 09:07:01 +02:00
Sylvain Rochet
492b181d51 SQL, upgrade: increase session table ip field size for IPv6 addresses
Commit 84d06edb06 introduced IPv6 support on SQL session table but
failed at providing upgrade SQL scripts, this commit fixes it.

Fixes: 84d06edb06 ("IPv6 Compatability")
Signed-off-by: Sylvain Rochet <gradator@gradator.net>
2016-10-09 19:47:42 +02:00
Aleksander Machniak
0836b213db Removed useless 'created' column from 'session' table (#5389) 2016-08-12 13:02:39 +02:00
Aleksander Machniak
a15d877ba8 Added brute-force attack prevention via login rate limit (#1490566) 2015-11-11 18:53:43 +01:00
Aleksander Machniak
f06f4b8424 Fix storing signatures with big images in MySQL database (#1490306) 2015-03-08 12:49:36 +01:00
Aleksander Machniak
9aa55d5a50 Fix so DDL script for Oracle can be executed in SQLPlus 2014-10-27 12:09:47 +01:00
Aleksander Machniak
ff767a14ff Merge branch 'oracle' 2014-09-22 09:31:11 +02:00
Aleksander Machniak
abc00f27c5 Initial DDL for Oracle 2014-09-15 12:20:20 +02:00
Marco Miltenburg
f63ff72a45 Index IX_contactgroups_user_id was created on the wrong table. 2014-09-05 12:17:27 +02:00
Aleksander Machniak
030ebec02f Fix error in MSSQL update script 2013061000.sql (#1490061) 2014-09-04 13:26:10 +02:00
Aleksander Machniak
b6f7304d69 Fix too small length of users.preferences column data type on MySQL 2014-04-29 12:12:26 +02:00
Aleksander Machniak
90f7aa9e39 Fix varius db_prefix issues (#1489839)
- Move DDL script execution code to rcube_db class(es).
- Improve prefix replacement code, so index names are also modified
2014-04-29 11:34:43 +02:00
Aleksander Machniak
8483de8bdf Fix typo 2013-07-08 08:21:20 +02:00
Aleksander Machniak
60b6d7c389 Fix database cache expunge issues (#1489149) - added 'expires' column 2013-06-09 11:07:46 +02:00
Aleksander Machniak
50abd55718 Added shared (cross-user) cache 2013-05-25 15:37:46 +02:00
Aleksander Machniak
311e82652a Add lost files for "db_prefix related changes" commit 2013-04-28 14:30:34 +02:00
Aleksander Machniak
399db1b647 Add db_prefix configuration option in place of db_table_*/db_sequence_* options
Make possible to use db_prefix for schema initialization in Installer (#1489067)
Fix updatedb.sh script so it recognizes also table prefix for external DDL files
2013-04-27 18:31:40 +02:00
Thomas Bruederli
bcfdac6660 Add 'if not exists' to system table creation. Just in case some previous db update routine was aborted or failed 2013-03-28 17:42:09 +01:00
Aleksander Machniak
9e46fb535d Fix typo in DB version strings (there should be no .sql suffix) 2013-02-19 14:27:26 +01:00