~abrody/+junk/launchpad-dbpatches

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
Database Patch Number Archive
=============================

DB patches from previous baselines.

========= ============= =====================================================
 Patch #  Who Allocated Comment
========= ============= =====================================================
2208-01-0 stub          milestone sorting functional index
2208-01-1 stub          LaunchpadDatabaseRevision update
2208-01-2 danilo        Drop POTMsgSet.sequence column
2208-01-3 stub          LaunchpadDatabaseRevision bzr details
2208-02-0 stub          OpenIDIdentifier
2208-03-0 stub          SuggestivePOTemplate foreign key reference
2208-04-0 stub          Builder.failure_count
2208-05-0 stub          *PackageRelease.homepage
2208-06-0 stub          CodeImport.failure_bug
2208-07-0 stub          DistroSeriesDifference
2208-08-0 stub          search subscriptions
2208-09-0 stub          BugTrackerComponent
2208-10-0 stub          DistributionJob
2208-11-0 stub          Drop BranchRevision.id
2208-12-0 stub          DistroSeriesDifference.source_version
2208-13-0 stub          TranslationTemplatesBuild
2208-14-0 stub          BugMessage.id
2208-15-0 stub          Drop redundant BugTask.date_closed index
2208-16-0 stub          SourcePacakgeRecipeBuildJob.sprb NOT NULL
2208-17-0 stub          IncrementalDiff table
2208-18-0 stub          HWSubmissionDevice.parent index
2208-19-0 stub          BugTrackerComponent constraint fix
2208-20-0 stub          BugTrackerComponent* remote_name
2208-21-0 stub          lp_OpenIdIdentifier
2208-22-0 stub          tarmac changes
2208-23-0 stub          Drop translationmessage.pofile
2208-24-0 stub          DistroSeriesDifference.base_version
2208-25-0 stub          Registry job schema
2208-26-0 stub          ???
2208-27-0 stub          SourcePackageRecipeDataInstruction.source_directory
2208-28-0 stub          SPRB.recipe DROP NOT NULL
2208-28-1 stub          TranslationMessage new indexes
2208-29-0 stub          Drop TranslationMessage.variant 
2208-30-0 stub          TranslationMessage, TranslationImportQEntry renames
2208-31-0 stub          Product/DistroSourcePackage enable bug dupe search
2208-32-0 stub          ParsedApacheLog.bytes_read to bigint
2208-33-0 stub          Subunit stream table
2208-34-0 stub          SPPH.ancestor
2208-35-0 stub          Drop Distro*.lucilleconfig
2208-36-0 stub          PillarName.admin
2208-37-0 stub          StructuralSubscriptionFilter.notificationlevel
2208-38-0 stub          PersonSettings
2208-38-1 stub          Populate PersonSettings
2208-39-0 stub          StructuralSubscription.blueprint_notification_level
2208-40-0 stub          SourcePackageRelease.debversion
2208-42-0 stub          Indexes & fillfactor
2208-43-0 stub          DatabaseDiskUtilization
2208-44-0 stub          Twiddle selfgenerated_bugnotifications default
2208-45-0 stub          BugNotification.status
2208-46-0 stub          BugNotification.activity
2208-47-0 stub          PackagingJob
2208-48-0 stub          FeatureFlagChangelogEntry
2208-49-0 stub          SourcePackageRecipe.description nullable
2208-50-0 stub          BugNotificationFilter
2208-51-0 stub          Message.visible
2208-52-0 stub          PublisherConfig
2208-53-0 stub          Distribution.registrant
2208-54-0 stub          valid_name(architecture_tag)
2208-55-0 stub          DistroSeriesDifference version type and indexes
2208-56-0 stub          Distroseries.registrant
2208-57-0 stub          Distroseries automatic backports
2208-57-1 stub          PackageUpload index
2208-58-0 stub          BugSubscriptionFilterMute
2208-59-0 stub          Bug.heat -> BugTask.heat
2208-59-1 stub          Drop bugtask heat index
2208-59-2 stub          Add new bugtask heat indexes
2208-60-0 stub          (lifeless)
2208-61-0 stub          DistroSeriesParent
2208-62-0 stub          Drop BranchRevision.id
2208-63-0 stub          (lifeless)
2208-64-0 stub          DistroSeriesDifference.parent_series
2208-65-0 stub          StructuralSubscription constraints
2208-66-0 stub          TRANSIENT schema
2208-67-0 stub          DistroSeriesDifference index fix
2208-68-0 stub          PackageCopyJob
2208-69-0 stub          QuestionMessage.owner
2208-70-0 stub          BugMute
2208-71-0 stub          DistroSeriesParent.component, pocket, is_overlay
2208-72-0 stub          DistroSeriesParent.ordering
2208-73-0 stub          PackageCopyJob package_name copy_policy
2208-73-1 stub          Missing index
2208-72-2 stub          HWSubmission indexes
2208-74-0 stub          (Moved to 2208-72-2 - this number can be reused)
2208-75-0 stub          BugSummary cleanups
2208-76-0 stub          BinaryPackageContents
2208-76-1 stub          Drop a translationmessage index per Bug #534203
2208-76-2 jtv           Index Message.datecreated
2208-76-3 stub          Remove crud from production per Bug #813761
2208-76-4 stub          Speed up bugsummary rollup, Bug #810104
2208-77-0 wgrant        Drop OAuthNonce.id
2208-78-0 stub          Drop BugTask.priority
2208-78-1 stub          BugMessage.owner NOT NULL
2208-78-2 stub          Drop dud temporary index
2208-79-0 wgrant        DistroSeries.split_long_descriptions (cjwatson)
2208-79-1 danilo        Add PackagingJob.potemplate (bug #814580)
2208-80-0 bigjools      Add distribution.package_derivatives_email(#820941)
2208-81-1 stevenk       Denormalise BPN and SPN into BPPH and SPPH
2208-82-1 rvba          Add SPPH.creator
2208-83-1 wgrant        Dropping 36 tables (foreign keys)
2208-83-2 wgrant        Dropping 36 tables (actual tables)
2208-84-1 nigelb        Deleting the statusexplanation column
2208-85-1 wallyworld    Add transitively_private column to Branch table
2208-86-1 jml           Add tables for a package symbol database
2208-87-1 wallyworld    Add a trigger to update branch privacy information
2208-87-2 stevenk       Indicies for {B,S}PPH denormalisation.
2208-88-1 wgrant        libraryfilealias__expires_content_not_null_idx
2208-89-1 wallyworld    branch__transitively_private_idx
2208-90-1 nigelb        Add description column to merge columns
2208-91-1 wallyworld    Add not null constraint to Branch transitively_private column
2208-92-1 stevenk       Index for PackageUpload.archive
2208-92-2 stevenk       Drop old index for PackageUpload.
2208-93-0 benji         POFileStatsJob
2208-93-1 wgrant        Access policies
2208-93-2 wgrant        Access policies -- person foreign keys
2208-94-1 adeuring      New column bug.latest_attachment_uploaded