From 9ec9a1ebe631a8c8f9a9a37a9177b4d3b909f595 Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Tue, 21 Jun 2016 12:21:39 -0400 Subject: [PATCH] Cleaned up some database work --- .../examples/drop_database_V0.0.1.sql | 12 ++++++++++++ setup/databaseScripts/examples/readme.txt | 6 +++++- 2 files changed, 17 insertions(+), 1 deletion(-) create mode 100644 setup/databaseScripts/examples/drop_database_V0.0.1.sql diff --git a/setup/databaseScripts/examples/drop_database_V0.0.1.sql b/setup/databaseScripts/examples/drop_database_V0.0.1.sql new file mode 100644 index 0000000..f04ce11 --- /dev/null +++ b/setup/databaseScripts/examples/drop_database_V0.0.1.sql @@ -0,0 +1,12 @@ +-- Gaslight Media Members Database +-- File Created: 12/09/14 15:27:15 +-- Database Version: 1.1.5 +-- Database Deletion Script +-- Note: Tables with DELETE CASCADE must appear before referenced table +-- +-- Multiple tables may be separated by ",". + +DROP TABLE IF EXISTS + {prefix}sometablename +; + diff --git a/setup/databaseScripts/examples/readme.txt b/setup/databaseScripts/examples/readme.txt index f4f3b48..eeecde4 100644 --- a/setup/databaseScripts/examples/readme.txt +++ b/setup/databaseScripts/examples/readme.txt @@ -17,5 +17,9 @@ There is also an entry in the dbVersions.php file that describes the update. Note that the number of tables needs to be set to the updated number for each update. -Also note taht the SQL update scripts are run before the PHP update scripts. +Also note that the SQL update scripts are run before the PHP update scripts. + +NOTE: When doing a database version update be sure to update the version numbers +on the "create_database_V..." and "drop_database_V..." files. Also the drop_database +file must reference all off the tables in the create_database file. -- 2.17.1