|
@@ 512-516 (lines=5) @@
|
| 509 |
|
if ($exist) $exist =" IF EXISTS"; |
| 510 |
|
|
| 511 |
|
/* simuler le IF EXISTS - version 2 */ |
| 512 |
|
if ($exist && _sqlite_is_version(2, '', $serveur)){ |
| 513 |
|
$a = spip_sqlite_showtable($table, $serveur); |
| 514 |
|
if (!$a) return true; |
| 515 |
|
$exist = ''; |
| 516 |
|
} |
| 517 |
|
if (spip_sqlite_query("DROP TABLE$exist $table", $serveur, $requeter)) |
| 518 |
|
return true; |
| 519 |
|
else |
|
@@ 529-533 (lines=5) @@
|
| 526 |
|
if ($exist) $exist =" IF EXISTS"; |
| 527 |
|
|
| 528 |
|
/* simuler le IF EXISTS - version 2 */ |
| 529 |
|
if ($exist && _sqlite_is_version(2, '', $serveur)){ |
| 530 |
|
$a = spip_sqlite_showtable($view, $serveur); |
| 531 |
|
if (!$a) return true; |
| 532 |
|
$exist = ''; |
| 533 |
|
} |
| 534 |
|
|
| 535 |
|
return spip_sqlite_query("DROP VIEW$exist $view", $serveur, $requeter); |
| 536 |
|
} |
|
@@ 1571-1581 (lines=11) @@
|
| 1568 |
|
} |
| 1569 |
|
|
| 1570 |
|
$ifnotexists = ""; |
| 1571 |
|
if ($_ifnotexists) { |
| 1572 |
|
// simuler le IF NOT EXISTS - version 2 |
| 1573 |
|
if (_sqlite_is_version(2, '', $serveur)){ |
| 1574 |
|
$a = spip_sqlite_showtable($nom, $serveur); |
| 1575 |
|
if ($a) return false; |
| 1576 |
|
} |
| 1577 |
|
// sinon l'ajouter en version 3 |
| 1578 |
|
else { |
| 1579 |
|
$ifnotexists = ' IF NOT EXISTS'; |
| 1580 |
|
} |
| 1581 |
|
} |
| 1582 |
|
|
| 1583 |
|
$temporary = $temporary ? ' TEMPORARY':''; |
| 1584 |
|
$q = "CREATE$temporary TABLE$ifnotexists $nom ($query" . ($keys ? ",$keys" : '') . ")\n"; |