← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2109-53-0.sql

Merge db-devel.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2109-53-0.sql
1
 
 
2
 
SET client_min_messages=ERROR;
3
 
 
4
 
CREATE VIEW HWDriverPackageNames AS
5
 
    SELECT DISTINCT ON (package_name) id, package_name from HWDriver
6
 
        ORDER BY package_name, id;
7
 
 
8
 
CREATE VIEW HWDriverNames AS
9
 
    SELECT DISTINCT ON (name) id, name from HWDriver
10
 
        ORDER BY name, id;
11
 
 
12
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2109, 53, 0);