X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Fschema.php;h=94cde28f9d4692610a5b00cafd11c693ca61f1b5;hb=ebc8e2a0e7dde135aef73be7b3d96dff155fe091;hp=e188037e6837a1507ab8c0ac545e8f2a72eab9ae;hpb=3eaa3234f9bd7f6e2361b32c1dd481023398850e;p=quix0rs-gnu-social.git diff --git a/lib/schema.php b/lib/schema.php index e188037e68..94cde28f9d 100644 --- a/lib/schema.php +++ b/lib/schema.php @@ -345,9 +345,11 @@ class Schema public function dropTable($name) { + global $_PEAR; + $res = $this->conn->query("DROP TABLE $name"); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } @@ -372,6 +374,8 @@ class Schema public function createIndex($table, $columnNames, $name=null) { + global $_PEAR; + if (!is_array($columnNames)) { $columnNames = array($columnNames); } @@ -384,7 +388,7 @@ class Schema "ADD INDEX $name (". implode(",", $columnNames).")"); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } @@ -402,9 +406,11 @@ class Schema public function dropIndex($table, $name) { + global $_PEAR; + $res = $this->conn->query("ALTER TABLE $table DROP INDEX $name"); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } @@ -423,11 +429,13 @@ class Schema public function addColumn($table, $columndef) { + global $_PEAR; + $sql = "ALTER TABLE $table ADD COLUMN " . $this->_columnSql($columndef); $res = $this->conn->query($sql); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } @@ -447,12 +455,14 @@ class Schema public function modifyColumn($table, $columndef) { + global $_PEAR; + $sql = "ALTER TABLE $table MODIFY COLUMN " . $this->_columnSql($columndef); $res = $this->conn->query($sql); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } @@ -472,11 +482,13 @@ class Schema public function dropColumn($table, $columnName) { + global $_PEAR; + $sql = "ALTER TABLE $table DROP COLUMN $columnName"; $res = $this->conn->query($sql); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } @@ -513,6 +525,8 @@ class Schema */ function runSqlSet(array $statements) { + global $_PEAR; + $ok = true; foreach ($statements as $sql) { if (defined('DEBUG_INSTALLER')) { @@ -520,7 +534,7 @@ class Schema } $res = $this->conn->query($sql); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); } } @@ -630,6 +644,11 @@ class Schema $this->appendCreateIndex($statements, $tableName, $indexName, $def['indexes'][$indexName]); } + foreach ($fulltext['mod'] + $fulltext['add'] as $indexName) { + $colDef = $def['fulltext indexes'][$indexName]; + $this->appendCreateFulltextIndex($statements, $tableName, $indexName, $colDef); + } + return $statements; } @@ -1022,8 +1041,10 @@ class Schema */ protected function fetchQueryData($sql) { + global $_PEAR; + $res = $this->conn->query($sql); - if (PEAR::isError($res)) { + if ($_PEAR->isError($res)) { throw new Exception($res->getMessage()); }