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
|
SET client_min_messages=ERROR;
DROP VIEW SourcePackagePublishingHistory;
DROP VIEW BinaryPackagePublishingHistory;
ALTER TABLE SecureSourcePackagePublishingHistory
RENAME TO SourcePackagePublishingHistory;
ALTER TABLE SecureBinaryPackagePublishingHistory
RENAME TO BinaryPackagePublishingHistory;
ALTER SEQUENCE securesourcepackagepublishinghistory_id_seq
RENAME TO sourcepackagepublishinghistory_id_seq;
ALTER SEQUENCE securebinarypackagepublishinghistory_id_seq
RENAME TO binarypackagepublishinghistory_id_seq;
ALTER TABLE SourcePackagePublishingHistory
DROP COLUMN embargolifted;
ALTER TABLE SourcePackagePublishingHistory
DROP COLUMN embargo;
ALTER TABLE BinaryPackagePublishingHistory
DROP COLUMN embargolifted;
ALTER TABLE BinaryPackagePublishingHistory
DROP COLUMN embargo;
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 31, 0);
|