From c3da6d79ec37bb8c800beaa451cd1ed87d619c99 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Mon, 28 Sep 2009 09:04:38 +0000
Subject: [PATCH] =?utf8?q?Bug=20519032:=20Remove=20the=20unused=20"last=5F?=
 =?utf8?q?viewed"=20column=20from=20the=20"series"=20DB=20table=20-=20Patc?=
 =?utf8?q?h=20by=20Fr=C3=83=C2=A9d=C3=83=C2=A9ric=20Buclin=20<LpSolit@gmai?=
 =?utf8?q?l.com>=20r/a=3Dmkanat?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 Bugzilla/DB/Schema.pm  | 1 -
 Bugzilla/Install/DB.pm | 3 +++
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 5e8c49ccf5..2bd95d5012 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1259,7 +1259,6 @@ use constant ABSTRACT_SCHEMA => {
                                            DELETE => 'CASCADE'}},
             name        => {TYPE => 'varchar(64)', NOTNULL => 1},
             frequency   => {TYPE => 'INT2', NOTNULL => 1},
-            last_viewed => {TYPE => 'DATETIME'},
             query       => {TYPE => 'MEDIUMTEXT', NOTNULL => 1},
             is_public   => {TYPE => 'BOOLEAN', NOTNULL => 1,
                             DEFAULT => 'FALSE'},
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 99e5b98957..e6b577526c 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -577,6 +577,9 @@ sub update_table_definitions {
         { TYPE => 'varchar(255)' });
     $dbh->bz_add_index('bugs_activity', 'bugs_activity_added_idx', ['added']);
 
+    # 2009-09-28 LpSolit@gmail.com - Bug 519032
+    $dbh->bz_drop_column('series', 'last_viewed');
+
     ################################################################
     # New --TABLE-- changes should go *** A B O V E *** this point #
     ################################################################
-- 
2.47.2