|
@@ 518-524 (lines=7) @@
|
| 515 |
|
$version = spip_sqlite_fetch(spip_sqlite_query("select sqlite_version() AS sqlite_version",$serveur),'',$serveur); |
| 516 |
|
if (!function_exists('spip_version_compare')) include_spip('plugins/installer'); |
| 517 |
|
|
| 518 |
|
if ($version AND spip_version_compare($version['sqlite_version'],'3.3.0','>=')) { |
| 519 |
|
$ifnotexists = ' IF NOT EXISTS'; |
| 520 |
|
} else { |
| 521 |
|
/* simuler le IF EXISTS - version 2 et sqlite < 3.3a */ |
| 522 |
|
$a = spip_sqlite_showtable($table, $serveur); |
| 523 |
|
if (isset($a['key']['KEY '.$nom])) return true; |
| 524 |
|
} |
| 525 |
|
|
| 526 |
|
$query = "CREATE ".($unique?"UNIQUE ":"")."INDEX$ifnotexists $nom ON $table (".join(',', $champs).")"; |
| 527 |
|
$res = spip_sqlite_query($query, $serveur, $requeter); |
|
@@ 1968-1974 (lines=7) @@
|
| 1965 |
|
$version = spip_sqlite_fetch(spip_sqlite_query("select sqlite_version() AS sqlite_version",$serveur),'',$serveur); |
| 1966 |
|
if (!function_exists('spip_version_compare')) include_spip('plugins/installer'); |
| 1967 |
|
|
| 1968 |
|
if ($version AND spip_version_compare($version['sqlite_version'],'3.3.0','>=')) { |
| 1969 |
|
$ifnotexists = ' IF NOT EXISTS'; |
| 1970 |
|
} else { |
| 1971 |
|
/* simuler le IF EXISTS - version 2 et sqlite < 3.3a */ |
| 1972 |
|
$a = spip_sqlite_showtable($table, $serveur); |
| 1973 |
|
if (isset($a['key']['KEY '.$nom])) return true; |
| 1974 |
|
} |
| 1975 |
|
|
| 1976 |
|
} |
| 1977 |
|
|
spip /
SPIP
