summaryrefslogtreecommitdiff
path: root/SQL
AgeCommit message (Collapse)Author
2010-04-15Always set changed date when marking a DB record as deleted + provide a ↵thomascube
cleanup script
2010-03-27- contactgroups DDL for postgresalecpl
2010-03-27- fix default datetimealecpl
2010-03-26Added basic contact groups featurethomascube
2010-03-09- fix add indexalecpl
2010-03-06- re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities tablealecpl
2010-02-24- Fix adding contacts SQL error on mysql (#1486459)alecpl
2010-02-06- typoalecpl
2010-02-06- Add workaround for MySQL bug [http://bugs.mysql.com/bug.php?id=46293] ↵alecpl
(#1486474)
2009-12-17- don't use TRUNCATE on sqlite (#1486374)alecpl
2009-12-11- move TRUNCATE before CREATE INDEX (#1486362)alecpl
2009-09-29- use better index for contacts tablealecpl
2009-09-17- Change MySQL data type to avoid problems with big session varsvbenincasa
2009-09-13- "TRUNCATE messages" is required to remove buggy cache entries alecpl
2009-09-07- added index in messages tablealecpl
2009-08-03- Fix MS SQL DDL (#1486020)alecpl
2009-05-14- remove version number from *.initial.sqlalecpl
2009-03-04- Fix datetime columns defaults in mysql's DDL (#1485641)alecpl
2008-12-03- added lost column in mssql DDLalecpl
2008-12-03- change few "boolean" columns type from integer to smallintalecpl
2008-11-29Simplify MYSQL database initialization instructionsthomascube
2008-11-29Add conditional comments to mysql initial script (#1485517); remove old ↵thomascube
mysql 4.0 init script
2008-11-25#1485420: remove default (and not null) for users.language column in DDLalecpl
2008-11-24- Added index on cache.created + small fixes in mssql DDL scriptalecpl
2008-11-22- fix r2076: removed cache.session_id column, removed DELETEs from cache in ↵alecpl
session_gc - trust DB server's time when "touching" cache and messages tables
2008-11-21- Increase speed of session destroy and garbage clean upalecpl
- Fix session timeout when DB server got clock skew (#1485490)
2008-11-21- Fix 'cache' table cleanup on session destroy (#1485516)alecpl
2008-06-12#1485125: added index on messages.createdalecpl
2008-06-12- #1485120 (text column can't have a default value)alecpl
2008-05-19-Fixed Mysql DDL for default identities creation (#1485070)alecpl
2008-04-05#1484962: typoalecpl
2008-04-03#1484854alecpl
2008-04-03fix: there's no ALTER TABLE ... ADD INDEX in postgresqlalecpl
2008-03-25Optimize database schema; get rid of unnecessary indexesthomascube
2007-11-25Fix Postgresql upgrade script (#1484668)thomascube
2007-10-10Set prefs field in user table to null (#1484386)thomascube
2007-09-19IPv6 Compatabilitythomascube
2007-09-11Truncate cache table before adding indexthomascube
2007-08-29# fixed: #1484456till
2007-05-24upgrade to TinyMCE v2.1.1.1svncommit
2007-05-17Fix default value problem for MySQL (#1483940)thomascube
2007-05-17Updated description files and version infothomascube
2007-05-17Changed sql scripts to allow non-ascii chars in user names (#1483959)thomascube
2007-04-28Set default value for col preferences; fix bug #1483978thomascube
2007-03-18Use user_id for unique key in messages table (closes #1484074)thomascube
2006-09-14Fixed quoting in MySQL update scriptthomascube
2006-09-14Initial TinyMCE editor support (still need to work on spellcheck and skins)svncommit
2006-08-30Added MSSQL supportthomascube
2006-08-25Finalized new message parsing. Attention: changes in database schemathomascube
2006-08-11Reverted files to r305thomascube