aboutsummaryrefslogtreecommitdiff
path: root/src/odbc/mysql.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Update year of ProcessOne copyright from 2009 to 2010 (EJAB-1159)Badlop2010-01-121-1/+1
| | | | SVN Revision: 2891
* Add a "created_at" column to some tables in the MySQL schema to storeJérôme Sautret2009-09-101-6/+12
| | | | | | a timestamp (thanks to Pedro Melo, EJAB-376). SVN Revision: 2593
* Fix pubsub tables constraints in MySQL schema creation script.Jérôme Sautret2009-09-101-6/+6
| | | | SVN Revision: 2592
* typo fix on subscriptionsChristophe Romain2009-08-071-1/+1
| | | | SVN Revision: 2438
* initial merge of pubsub odbc, compilation pass okChristophe Romain2009-08-071-0/+55
| | | | SVN Revision: 2437
* Support for roster versioning (EJAB-964)Pablo Polvorin2009-08-061-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
* * src/odbc/mysql.sql: Fix complain about comment syntaxBadlop2009-01-231-1/+1
| | | | | | * src/odbc/pg.sql: Likewise SVN Revision: 1850
* * doc/guide.tex: Update copyright date 2008 to 2009 (EJAB-842)Badlop2009-01-121-1/+1
| | | | | | | | * doc/guide.html: Likewise * src/*/*.erl: Likewise * src/*/*.erl: Remove unneeded blankspaces in license text SVN Revision: 1804
* * doc/guide.tex: Update Process-one name to ProcessOne (EJAB-708)Badlop2008-07-311-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
* * doc/guide.tex: Updated copyright dates to 2008Badlop2008-01-151-1/+1
| | | | | | * src/*: Likewise SVN Revision: 1153
* * Applied copyright patch 3.Mickaël Rémond2007-12-241-0/+19
| | | | SVN Revision: 1113
* Added some missing NOT NULL restrictionsChristophe Romain2007-09-281-3/+3
| | | | SVN Revision: 952
* * src/odbc/mssql.sql: Nickname cannot be null in rosterusers table (MSSQL)Mickaël Rémond2007-07-091-1/+1
| | | | | | | * src/odbc/mysql.sql: Likewise * src/odbc/pg.sql: Likewise SVN Revision: 809
* * src/odbc/pg.sql: last table, state column cannot be NULL (EJAB-191).Mickaël Rémond2007-02-191-1/+1
| | | | | | | * src/odbc/mysql.sql: likewise. * src/odbc/mssql.sql. likewise. SVN Revision: 732
* 2006-11-20 Mickael Remond <mickael.remond@process-one.net>Mickaël Rémond2006-11-201-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
* * src/odbc/mysql.sql: Fix database creation script.Mickaël Rémond2006-11-051-2/+2
| | | | SVN Revision: 675
* * src/mod_private_odbc.erl: Support for MySQL and MSSQL.Mickaël Rémond2006-11-051-0/+9
| | | | | | | | * src/odbc/odbc_queries.erl: Likewise. * src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 674
* * src/odbc/mysql: Database creation script should now be compliant withMickaël Rémond2006-11-041-6/+6
| | | | | | MySQL 4.0.x. SVN Revision: 673
* * src/odbc/pg.sql: Database scripts consistency.Mickaël Rémond2006-11-041-8/+11
| | | | | | | * src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 672
* * src/mod_roster.erl: The subscribe request are now resend atMickaël Rémond2006-05-231-0/+3
| | | | | | | | | | | | | | | | login as long as they have not been answered. mod_roster do no more depends on mod_offline. * src/ejabberd_sm.erl: Likewise. * src/ejabberd_c2s.erl: Likewise. * src/mod_roster_odbc.erl: Likewise (The ODBC/relational support has not yet been tested). * src/mod_roster.hrl: Likewise. * src/mod_offline.erl: Likewise. * src/mod_offline_odbc.erl: Likewise. * odbc/pg.sql: Likewise. * odbc/mysql.sql: Likewise. SVN Revision: 569
* * src/odbc/ejabberd_odbc.erl: underscore and percent are now onlyMickaël Rémond2006-01-131-19/+16
| | | | | | | | | | escaped in like queries. MySQL where not escaping those escaped characters in other context (EJAB-24) * src/mod_vcard_odbc.erl: likewise. * src/odbc/mysql.sql: Fixed MySQL database creation script: Was not properly working with all MySQL version. SVN Revision: 484
* Added missing file.Mickaël Rémond2005-12-231-0/+96
SVN Revision: 480
generated by cgit v1.2.3 (git 2.25.1) at 2025-09-10 10:42:05 +0000