DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'alpha'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'amd64'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'arm'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'armel'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'hppa'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'hurd-i386'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'i386'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'ia64'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'kfreebsd-amd64'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'kfreebsd-i386'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'mips'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'mipsel'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'powerpc'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 's390'::text;
DROP VIEW pkg_history;
CREATE OR REPLACE VIEW pkg_history AS
- SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
+ SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
FROM pkg_history
NATURAL JOIN distributions
WHERE distributions.public = true AND pkg_history.architecture::text = 'sparc'::text;