|
7675.1041.1
by Julian Edwards
Schema changes to make debversion_sort_key a real column to improve r/o performance. |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
DROP INDEX binarypackagerelease_version_sort; |
|
4 |
DROP INDEX sourcepackagerelease_version_sort; |
|
5 |
||
|
7675.1042.1
by Stuart Bishop
Simplify and streamline debversion db schema update |
6 |
ALTER TABLE SourcePackageRelease ALTER COLUMN version TYPE debversion; |
7 |
ALTER TABLE BinaryPackageRelease ALTER COLUMN version TYPE debversion; |
|
8 |
||
9 |
CREATE INDEX SourcePackageRelease__version__idx |
|
10 |
ON SourcePackageRelease(version); |
|
11 |
CREATE INDEX BinaryPackageRelease__version__idx |
|
12 |
ON BinaryPackageRelease(version); |
|
|
7675.1041.5
by Julian Edwards
Modify schema change to turn version into a debversion column |
13 |
|
|
7675.1041.7
by Julian Edwards
patch 99 -> 40 |
14 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 40, 0); |