|
7675.997.1
by Steve Kowalik
First shot at adding SPPH.ancestor |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
ALTER TABLE SourcePackagePublishingHistory |
|
4 |
ADD COLUMN ancestor INTEGER REFERENCES SourcePackagePublishingHistory; |
|
|
7675.997.8
by Steve Kowalik
Jump from 99 to 34 and add an index, both per db review. |
5 |
CREATE INDEX sourcepackagepublishinghistory__ancestor__idx ON sourcepackagepublishinghistory(ancestor); |
|
7675.997.1
by Steve Kowalik
First shot at adding SPPH.ancestor |
6 |
|
|
7675.997.8
by Steve Kowalik
Jump from 99 to 34 and add an index, both per db review. |
7 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 34, 0); |
|
7675.997.1
by Steve Kowalik
First shot at adding SPPH.ancestor |
8 |