@@ -153,8 +153,8 @@ |
||
153 | 153 | { |
154 | 154 | $map = []; |
155 | 155 | |
156 | - $conn = $this->context()->db( 'db-locale' ); |
|
157 | - $tconn = $this->context()->db( 'db-locale', true ); |
|
156 | + $conn = $this->context()->db( 'db-locale' ); |
|
157 | + $tconn = $this->context()->db( 'db-locale', true ); |
|
158 | 158 | |
159 | 159 | $type = \Aimeos\Base\DB\Statement\Base::PARAM_INT; |
160 | 160 | $roots = $conn->create( 'SELECT id, nleft, nright FROM mshop_locale_site WHERE level = 0' )->execute(); |
@@ -39,9 +39,12 @@ |
||
39 | 39 | { |
40 | 40 | $db->for( 'mysql', 'CREATE FULLTEXT INDEX `idx_msindte_content` ON `mshop_index_text` (`content`)' ); |
41 | 41 | |
42 | - try { |
|
42 | + try |
|
43 | + { |
|
43 | 44 | $db->for( 'postgresql', 'CREATE INDEX "idx_msindte_content" ON "mshop_index_text" USING GIN (to_tsvector(\'english\', "content"))' ); |
44 | - } catch( \Exception $e ) { |
|
45 | + } |
|
46 | + catch( \Exception $e ) |
|
47 | + { |
|
45 | 48 | // Doctrine DBAL bug: https://github.com/doctrine/dbal/issues/5351 |
46 | 49 | } |
47 | 50 | } |
@@ -307,8 +307,7 @@ |
||
307 | 307 | */ |
308 | 308 | $path = 'madmin/job/manager/insert'; |
309 | 309 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
310 | - } |
|
311 | - else |
|
310 | + } else |
|
312 | 311 | { |
313 | 312 | /** madmin/job/manager/update/mysql |
314 | 313 | * Updates an existing job record in the database |
@@ -434,8 +434,7 @@ |
||
434 | 434 | */ |
435 | 435 | $path = 'mshop/subscription/manager/insert'; |
436 | 436 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
437 | - } |
|
438 | - else |
|
437 | + } else |
|
439 | 438 | { |
440 | 439 | /** mshop/subscription/manager/update/mysql |
441 | 440 | * Updates an existing subscription record in the database |
@@ -451,8 +451,7 @@ |
||
451 | 451 | */ |
452 | 452 | $path = 'mshop/plugin/manager/insert'; |
453 | 453 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
454 | - } |
|
455 | - else |
|
454 | + } else |
|
456 | 455 | { |
457 | 456 | /** mshop/plugin/manager/update/mysql |
458 | 457 | * Updates an existing plugin record in the database |
@@ -484,8 +484,7 @@ |
||
484 | 484 | */ |
485 | 485 | $path = 'mshop/rule/manager/insert'; |
486 | 486 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
487 | - } |
|
488 | - else |
|
487 | + } else |
|
489 | 488 | { |
490 | 489 | /** mshop/rule/manager/update/mysql |
491 | 490 | * Updates an existing rule record in the database |
@@ -548,8 +548,7 @@ |
||
548 | 548 | */ |
549 | 549 | $path = 'mshop/price/manager/insert'; |
550 | 550 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
551 | - } |
|
552 | - else |
|
551 | + } else |
|
553 | 552 | { |
554 | 553 | /** mshop/price/manager/update/mysql |
555 | 554 | * Updates an existing price record in the database |
@@ -314,8 +314,7 @@ |
||
314 | 314 | */ |
315 | 315 | $path = 'mshop/stock/manager/insert'; |
316 | 316 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
317 | - } |
|
318 | - else |
|
317 | + } else |
|
319 | 318 | { |
320 | 319 | /** mshop/stock/manager/update/mysql |
321 | 320 | * Updates an existing product stock record in the database |
@@ -496,8 +496,7 @@ |
||
496 | 496 | */ |
497 | 497 | $path = 'mshop/service/manager/insert'; |
498 | 498 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
499 | - } |
|
500 | - else |
|
499 | + } else |
|
501 | 500 | { |
502 | 501 | /** mshop/service/manager/update/mysql |
503 | 502 | * Updates an existing service record in the database |