Add timestamp columns to concerts and venues.

To keep track of creation and modification times for each record.

1 files changed, 17 insertions, 2 deletions

diff --git a/includes/admin/register_db_tables.php b/includes/admin/register_db_tables.php
index 64123d9..8c6dc98 100644
--- a/includes/admin/register_db_tables.php
+++ b/includes/admin/register_db_tables.php
@@ -260,7 +260,7 @@ if ( !function_exists( "giglog_register_db_tables") )
     function giglog_register_db_tables()
     {
         $db_version = get_option('giglogadmin_db_version');
-        if ($db_version == 6) {
+        if ($db_version == 8) {
             return;
         }
 
@@ -459,7 +459,22 @@ if ( !function_exists( "giglog_register_db_tables") )
                     wpgconcert_roles JSON CHECK (JSON_VALID(wpgconcert_roles)))");
         }
 
-        update_option("giglogadmin_db_version", 6);
+        if ($db_version == NULL || $db_version < 8)
+        {
+            // Add automatically updated `created` and `updated` colomns to keep
+            // track of creation time and modification times for a record.
+            $wpdb->query(
+                "ALTER TABLE `wpg_concerts` ADD COLUMN IF NOT ExISTS (
+                    created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+                    updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)");
+
+            $wpdb->query(
+                "ALTER TABLE `wpg_venues` ADD COLUMN IF NOT ExISTS (
+                    created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+                    updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)");
+        }
+
+        update_option("giglogadmin_db_version", 8);
     }
 
     giglog_register_db_tables();