Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Right now, when Demonstration Site is restoring a database, it uses "CREATE TABLE IF NOT EXISTS". This is fine if the tables don't already exist, but it isn't fine if the tables already exist and have the incorrect schema, or already existing data. This patch moves from "CREATE TABLE IF NOT EXISTS" to "DROP TABLE IF EXISTS", followed by a "CREATE TABLE". This ensures that the correct schema is in place, as well empty start data.
| Comment | File | Size | Author |
|---|---|---|---|
| droptablebeforecreate.patch | 835 bytes | robloach |
Comments
Comment #1
robloachAs a side note, this allows Demonstration Site Install Profile to install a site over an already existing database, which is good when restoring from a fresh settings.php.
Comment #2
sunHm. I'm not really sure we want to do (force) this. How about an option?
Comment #3
robloachCorrection to my statement at #1. When you try to install on top of an existing Demo site, it tells you that Drupal is already installed. This is not Demo doing it, but Drupal. An alternative solution will have to do.