Launchpad itself

Merge lp:~lifeless/launchpad/bugjob into lp:launchpad

  1. bugjob
  2. Merge into devel
Proposed by Robert Collins on 2012-03-05
Status: Merged
Approved by: Robert Collins on 2012-03-05
Approved revision: no longer in the source branch.
Merged at revision: 14902
Proposed branch: lp:~lifeless/launchpad/bugjob
Merge into: lp:launchpad
Diff against target: 45 lines (+5/-14)
3 files modified
database/sampledata/current-dev.sql (+0/-7)
database/sampledata/current.sql (+0/-7)
database/schema/patch-2209-14-0.sql (+5/-0)
To merge this branch: bzr merge lp:~lifeless/launchpad/bugjob
Reviewer Review Type Date Requested Status
Stuart Bishop db 2012-03-05 Approve on 2012-03-05
Robert Collins (community) Approve on 2012-03-05
Review via email: mp+95837@code.launchpad.net

Commit Message

[r=lifeless][bug=946164] Drop the unused bugjob table.

Description of the Change

Drop the unused bugjob table.

To post a comment you must log in.
Robert Collins (lifeless) wrote :

Clearly, I think this is ok.

review: Approve
Stuart Bishop (stub) :
review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/sampledata/current-dev.sql'
2--- database/sampledata/current-dev.sql 2012-02-20 12:49:17 +0000
3+++ database/sampledata/current-dev.sql 2012-03-05 04:05:22 +0000
4@@ -3219,13 +3219,6 @@
5 ALTER TABLE bugcve ENABLE TRIGGER ALL;
6
7
8-ALTER TABLE bugjob DISABLE TRIGGER ALL;
9-
10-
11-
12-ALTER TABLE bugjob ENABLE TRIGGER ALL;
13-
14-
15 ALTER TABLE bugwatch DISABLE TRIGGER ALL;
16
17 INSERT INTO bugwatch (id, bug, bugtracker, remotebug, remotestatus, lastchanged, lastchecked, datecreated, owner, last_error_type, remote_importance, remote_lp_bug_id, next_check) VALUES (1, 2, 1, '42', 'FUBAR', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', 12, NULL, 'BAZBAZ', NULL, NULL);
18
19=== modified file 'database/sampledata/current.sql'
20--- database/sampledata/current.sql 2012-02-20 12:49:17 +0000
21+++ database/sampledata/current.sql 2012-03-05 04:05:22 +0000
22@@ -3155,13 +3155,6 @@
23 ALTER TABLE bugcve ENABLE TRIGGER ALL;
24
25
26-ALTER TABLE bugjob DISABLE TRIGGER ALL;
27-
28-
29-
30-ALTER TABLE bugjob ENABLE TRIGGER ALL;
31-
32-
33 ALTER TABLE bugwatch DISABLE TRIGGER ALL;
34
35 INSERT INTO bugwatch (id, bug, bugtracker, remotebug, remotestatus, lastchanged, lastchecked, datecreated, owner, last_error_type, remote_importance, remote_lp_bug_id, next_check) VALUES (1, 2, 1, '42', 'FUBAR', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', 12, NULL, 'BAZBAZ', NULL, NULL);
36
37=== added file 'database/schema/patch-2209-14-0.sql'
38--- database/schema/patch-2209-14-0.sql 1970-01-01 00:00:00 +0000
39+++ database/schema/patch-2209-14-0.sql 2012-03-05 04:05:22 +0000
40@@ -0,0 +1,5 @@
41+SET client_min_messages=ERROR;
42+
43+ALTER TABLE BugJob SET SCHEMA todrop;
44+
45+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 14, 0);