From 771a917aed2ca46fac22ca6fc79af2364dffa499 Mon Sep 17 00:00:00 2001
From: Dylan Hardison <dylan@mozilla.com>
Date: Tue, 19 Jul 2016 09:10:02 -0400
Subject: Bug 1254882 - develop a nightly script to revoke access to legal bugs
 from ex-employees

---
 extensions/BMO/Extension.pm | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)

(limited to 'extensions')

diff --git a/extensions/BMO/Extension.pm b/extensions/BMO/Extension.pm
index 082dcc606..06dbe7c0f 100644
--- a/extensions/BMO/Extension.pm
+++ b/extensions/BMO/Extension.pm
@@ -1216,6 +1216,29 @@ sub db_schema_abstract_schema {
             },
         ],
     };
+    $args->{schema}->{job_last_run} = {
+        FIELDS => [
+            id => {
+                TYPE       => 'INTSERIAL',
+                NOTNULL    => 1,
+                PRIMARYKEY => 1,
+            },
+            name => {
+                TYPE => 'VARCHAR(100)',
+                NOTNULL => 1,
+            },
+            last_run => {
+                TYPE => 'DATETIME',
+                NOTNULL => 1,
+            },
+        ],
+        INDEXES => [
+            job_last_run_name_idx => {
+                FIELDS => [ 'name' ],
+                TYPE   => 'UNIQUE',
+            },
+        ],
+    };
 }
 
 sub install_update_db {
-- 
cgit v1.2.3-24-g4f1b