summaryrefslogtreecommitdiff
path: root/SQL
AgeCommit message (Collapse)Author
2013-04-27Add db_prefix configuration option in place of db_table_*/db_sequence_* optionsAleksander Machniak
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-03-28Add 'if not exists' to system table creation. Just in case some previous db ↵Thomas Bruederli
update routine was aborted or failed
2013-02-19Fix typo in DB version strings (there should be no .sql suffix)Aleksander Machniak
2013-01-17Bump version number in *.initial.sqlAleksander Machniak
2013-01-17Drop tmp_users table (#1488910)Aleksander Machniak
2013-01-09Added new database upgrade script, converted DDL scripts to new formatAleksander Machniak
2012-08-06Removed users.alias column, added option ('user_aliases')Aleksander Machniak
to use email address from identities as username (#1488581)
2012-08-06- Removed redundant cache.cache_id column (#1488528)Aleksander Machniak
2012-06-10Fix DDL update from 0.7 for MS SQL ServerAleksander Machniak
2012-06-08Fix operator incompat. in some queries on contacts table using MS SQL Server ↵Aleksander Machniak
(#1488505)
2012-02-07- Fix parse errors in DDL files for MS SQL Serveralecpl
2012-01-12- Fix failure on MySQL database upgrade from 0.7 - text column can't have ↵alecpl
default value (#1488300)
2012-01-11- Disable FOREIGN_KEY_CHECKS for update from 0.7alecpl
2012-01-05- Fix SQL Error when saving a contact with many email addresses (#1488286)alecpl
2011-12-19- Fix wrong postgres sequence name in upgrade from 0.6alecpl
2011-12-15- Disable FOREIGN_KEY_CHECKS in update from 0.6 (#1488209)alecpl
2011-12-14- Fix broken CREATE INDEX queries in SQLite DDL files (#1488255)alecpl
2011-11-23- Add version markersalecpl
2011-11-22- Fixed bug where session ID's length was limited to 40 characters. Since ↵alecpl
PHP5.3 it's possible to set session.hash_function to any hash algorithm that would produce strings up to 128 characters long (#1488196)
2011-09-29We're on the road towards 0.7 nowthomascube
2011-09-19- Add lost cache_index.valid column definitionalecpl
2011-09-18- Cache synchronization using QRESYNC/CONDSTOREalecpl
- Fixed message ID updates in cache - Changed message flags handling + some fixes (e.g. fixed messages listing after delete)
2011-09-07- Rewritten messages caching (merged devel-mcache branch):alecpl
Indexes are stored in a separate table, so there's no need to store all messages in a folder Added threads data caching Flags are stored separately, so flag change doesn't cause DELETE+INSERT, just UPDATE - Partial QRESYNC support - Improved FETCH response handling - Improvements in response tokenization method
2011-09-06- Fix username case-insensitivity issue in MySQL (#1488021)alecpl
2011-09-06- Merge devel-saved_search branch (Addressbook Saved Searches)alecpl
2011-09-06- Merge devel-spellcheck branch:alecpl
- Added spellchecker exceptions dictionary (shared or per-user) - Added possibility to ignore words containing caps, numbers, symbols (spellcheck_ignore_* options)
2011-08-14Fix automatic db updates; trigger contact indexing after upgradethomascube
2011-08-11- Change version number 0.5.2 -> 0.5.X to not confuse usersalecpl
2011-05-05- Fix problems with subfolders of INBOX folder on some IMAP servers ↵alecpl
(#1487725) - Fix handling of folders that doesn't belong to any namespace (#1487637)
2011-04-27Change vcard field to LONGTEXT to completely store vcards with embedded photosthomascube
2011-03-10- Force names of unique constraints in PostgreSQL DDL (postgres 9.x uses ↵alecpl
different naming convention than older versions)
2011-02-25Create interactive update script with improved DB schema check; udated ↵thomascube
installer with new features and styles
2011-02-23- Add index on contactgroupmembers.contact_id column.alecpl
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
2011-02-14Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\!thomascube
2011-01-26Clear message cache table when upgradingthomascube
2010-11-15- Fix error in MSSQL DDL scripts (#1487112): use trigger instead of foreign ↵alecpl
key constraint
2010-11-02- Support contact's email addresses up to 255 characters long (#1487095)alecpl
- Added email format checks when saving contacts data
2010-10-06- Add unique index on users.username+users.mail_hostalecpl
2010-09-25- s/RoundCube/Roundcube/alecpl
2010-09-14- Added warning about tables engine, per discussion in #1486794alecpl
2010-08-11- Fixes in SQL init script + added update script for MSSQL databasealecpl
2010-08-10- Fix upgrade script for SQLite (#1486903)alecpl
2010-06-15- Added ALTER TABLE .. ENGINE=InnoDB, per discussion in #1486794alecpl
2010-06-14- fix foreign keys defs unintentionally broken in r3333alecpl
2010-04-28- Set DEFAULT NULL for users.last_loginalecpl
2010-04-23- added foreign keys in mssql DDLalecpl
2010-04-23Updated mssql schema (I have no clue if this is correct)thomascube
2010-04-20Replace ALTER TABLE statement in Sqlite schema update script; more precise ↵thomascube
instructions for db updates and about new cleaning script
2010-04-15- Fix: postgres doens't support AFTER clausealecpl
2010-04-15Always set changed date when marking a DB record as deleted + provide a ↵thomascube
cleanup script