- if (_sqlite_is_version(2, '', $serveur)){
- /* simuler le IF EXISTS - version 2 */
+ $version = spip_sqlite_fetch(spip_sqlite_query("select sqlite_version() AS sqlite_version",$serveur),'',$serveur);
+ if (!function_exists('spip_version_compare')) include_spip('plugins/installer');
+
+ if ($version AND spip_version_compare($version['sqlite_version'],'3.3.0','>=')) {
+ $ifnotexists = ' IF NOT EXISTS';
+ } else {
+ /* simuler le IF EXISTS - version 2 et sqlite < 3.3a */