2 rcs_id('$Id: PearDB_mysql.php,v 1.4 2004-03-24 19:39:03 rurban Exp $');
4 require_once('lib/WikiDB/backend/PearDB.php');
6 class WikiDB_backend_mysql
7 extends WikiDB_backend_PearDB
12 function WikiDB_backend_mysql($dbparams) {
13 $this->WikiDB_backend_PearDB($dbparams);
15 // Older MySQL's don't have CASE WHEN ... END
16 $this->_expressions['maxmajor'] = "MAX(IF(minor_edit=0,version,0))";
17 $this->_expressions['maxminor'] = "MAX(IF(minor_edit<>0,version,0))";
25 foreach ($this->_table_names as $table) {
26 $dbh->query("OPTIMIZE TABLE $table");
34 function _lock_tables($write_lock = true) {
35 $lock_type = $write_lock ? "WRITE" : "READ";
36 foreach ($this->_table_names as $table) {
37 $tables[] = "$table $lock_type";
39 $this->_dbh->query("LOCK TABLES " . join(",", $tables));
45 function _unlock_tables() {
46 $this->_dbh->query("UNLOCK TABLES");
50 // (c-file-style: "gnu")
55 // c-hanging-comment-ender-p: nil
56 // indent-tabs-mode: nil