447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
|
$create = array_merge($create, $create_keys);
$create = 'CREATE TABLE membres_tmp (' . "\n\t" . implode("\n\t", $create) . "\n);";
$copy = 'INSERT INTO membres_tmp (' . implode(', ', $copy) . ') SELECT ' . implode(', ', $copy) . ' FROM membres;';
$db->exec('PRAGMA foreign_keys = OFF;');
$db->exec('BEGIN;');
$db->exec($create);
if ($enable_copy) {
$db->exec($copy);
}
$db->exec('DROP TABLE IF EXISTS membres;');
|
|
|
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
|
$create = array_merge($create, $create_keys);
$create = 'CREATE TABLE membres_tmp (' . "\n\t" . implode("\n\t", $create) . "\n);";
$copy = 'INSERT INTO membres_tmp (' . implode(', ', $copy) . ') SELECT ' . implode(', ', $copy) . ' FROM membres;';
$db->exec('PRAGMA foreign_keys = OFF;');
$db->begin();
$db->exec($create);
if ($enable_copy) {
$db->exec($copy);
}
$db->exec('DROP TABLE IF EXISTS membres;');
|
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
|
// Il y a déjà un index
continue;
}
$db->exec('CREATE INDEX membres_liste_' . $field . ' ON membres (' . $field . ');');
}
$db->exec('END;');
$db->exec('PRAGMA foreign_keys = ON;');
$config->set('champs_membres', $this);
$config->save();
return true;
}
}
|
|
|
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
|
// Il y a déjà un index
continue;
}
$db->exec('CREATE INDEX membres_liste_' . $field . ' ON membres (' . $field . ');');
}
$db->commit();
$db->exec('PRAGMA foreign_keys = ON;');
$config->set('champs_membres', $this);
$config->save();
return true;
}
}
|