xpressengine /
xe-core
| @@ 612-629 (lines=18) @@ | ||
| 609 | * @param string $index_name index name |
|
| 610 | * @return boolean |
|
| 611 | */ |
|
| 612 | function isIndexExists($table_name, $index_name) |
|
| 613 | { |
|
| 614 | $query = sprintf("select \"index_name\" from \"db_index\" where " . "\"class_name\" = '%s%s' and (\"index_name\" = '%s' or \"index_name\" = '%s') ", $this->prefix, $table_name, $this->prefix . $index_name, $index_name); |
|
| 615 | $result = $this->_query($query); |
|
| 616 | ||
| 617 | if($this->isError()) |
|
| 618 | { |
|
| 619 | return FALSE; |
|
| 620 | } |
|
| 621 | ||
| 622 | $output = $this->_fetch($result); |
|
| 623 | ||
| 624 | if(!$output) |
|
| 625 | { |
|
| 626 | return FALSE; |
|
| 627 | } |
|
| 628 | return TRUE; |
|
| 629 | } |
|
| 630 | ||
| 631 | /** |
|
| 632 | * Delete duplicated index of the table |
|
| @@ 436-450 (lines=15) @@ | ||
| 433 | * @param string $column_name column name |
|
| 434 | * @return boolean |
|
| 435 | */ |
|
| 436 | function isColumnExists($table_name, $column_name) |
|
| 437 | { |
|
| 438 | $query = sprintf("select syscolumns.name as name from syscolumns, sysobjects where sysobjects.name = '%s%s' and sysobjects.id = syscolumns.id and syscolumns.name = '%s'", $this->prefix, $table_name, $column_name); |
|
| 439 | $result = $this->_query($query); |
|
| 440 | if($this->isError()) |
|
| 441 | { |
|
| 442 | return; |
|
| 443 | } |
|
| 444 | $tmp = $this->_fetch($result); |
|
| 445 | if(!$tmp->name) |
|
| 446 | { |
|
| 447 | return false; |
|
| 448 | } |
|
| 449 | return true; |
|
| 450 | } |
|
| 451 | ||
| 452 | /** |
|
| 453 | * Add an index to the table |
|
| @@ 500-516 (lines=17) @@ | ||
| 497 | * @param string $index_name index name |
|
| 498 | * @return boolean |
|
| 499 | */ |
|
| 500 | function isIndexExists($table_name, $index_name) |
|
| 501 | { |
|
| 502 | $query = sprintf("select sysindexes.name as name from sysindexes, sysobjects where sysobjects.name = '%s%s' and sysobjects.id = sysindexes.id and sysindexes.name = '%s'", $this->prefix, $table_name, $index_name); |
|
| 503 | ||
| 504 | $result = $this->_query($query); |
|
| 505 | if($this->isError()) |
|
| 506 | { |
|
| 507 | return; |
|
| 508 | } |
|
| 509 | $tmp = $this->_fetch($result); |
|
| 510 | ||
| 511 | if(!$tmp->name) |
|
| 512 | { |
|
| 513 | return false; |
|
| 514 | } |
|
| 515 | return true; |
|
| 516 | } |
|
| 517 | ||
| 518 | /** |
|
| 519 | * Creates a table by using xml contents |
|
