1 files changed, 10 insertions, 0 deletions
diff --git a/modules/notification/helpers/notification_installer.php b/modules/notification/helpers/notification_installer.php
index 473ae169..d3ea2582 100644
--- a/modules/notification/helpers/notification_installer.php
+++ b/modules/notification/helpers/notification_installer.php
@@ -1,3 +1,4 @@
+
 <?php defined("SYSPATH") or die("No direct script access.");
 /**
  * Gallery - a web based photo album viewer and editor
@@ -32,6 +33,14 @@ class notification_installer {
                  UNIQUE KEY (`user_id`, `item_id`))
                  ENGINE=InnoDB DEFAULT CHARSET=utf8;");
 
+      $db->query("CREATE TABLE IF NOT EXISTS {pending_notifications} (
+                 `id` int(9) NOT NULL auto_increment,
+                 `item_id` int(9) NOT NULL,
+                 `batch_id` int(9) NOT NULL,
+                 `time` int(9) NOT NULL,
+                 PRIMARY KEY (`id`),
+                 UNIQUE KEY (`batch_id`, `item_id`),
+                 ENGINE=InnoDB DEFAULT CHARSET=utf8;");
       module::set_version("notification", 1);
     }
   }
@@ -39,6 +48,7 @@ class notification_installer {
   static function uninstall() {
     $db = Database::instance();
     $db->query("DROP TABLE IF EXISTS {subscriptions};");
+    $db->query("DROP TABLE IF EXISTS {notification_queue};");
     
     module::delete("notification");
   }