Add a timestamp column to the proxies table.

1 files changed, 4 insertions, 3 deletions

diff --git a/modules/digibug/helpers/digibug_installer.php b/modules/digibug/helpers/digibug_installer.php
index 0476e2cc..baff2075 100644
--- a/modules/digibug/helpers/digibug_installer.php
+++ b/modules/digibug/helpers/digibug_installer.php
@@ -23,9 +23,10 @@ class digibug_installer {
     if ($version == 0) {
       Database::instance()
         ->query("CREATE TABLE {proxies} (
-                   `id` int(9) NOT NULL auto_increment,
+                   `id` int(9) NOT NULL AUTO_INCREMENT,
                    `uuid` char(36) NOT NULL,
-                   `item_id` int(9),
+                   `request_date` TIMESTAMP NOT NULL DEFAULT current_timestamp,
+                   `item_id` int(9) NOT NULL,
                    PRIMARY KEY (`id`))
                  ENGINE=InnoDB DEFAULT CHARSET=utf8;");
 
@@ -38,7 +39,7 @@ class digibug_installer {
   }
 
   static function uninstall() {
-    Database::instance()->query("DROP TABLE IF EXISTS {proxys}");
+    Database::instance()->query("DROP TABLE IF EXISTS {proxies}");
     module::delete("digibug");
   }
 }