Adding upstream version 0.85.6.upstream/0.85.6

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

11 files changed, 976 insertions, 0 deletions

diff --git a/db/.gitignore b/db/.gitignore
new file mode 100644
index 0000000..2d546fe
--- /dev/null
+++ b/db/.gitignore
@@ -0,0 +1 @@
+db.sql
diff --git a/db/Makefile.am b/db/Makefile.am
new file mode 100644
index 0000000..4466a3d
--- /dev/null
+++ b/db/Makefile.am
@@ -0,0 +1,50 @@
+# sbuild Makefile template
+#
+#
+# Copyright © 2004-2009  Roger Leigh <rleigh@debian.org>
+#
+# sbuild is free software: you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# sbuild is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program.  If not, see
+# <http://www.gnu.org/licenses/>.
+#
+#####################################################################
+
+include $(top_srcdir)/scripts/global.mk
+
+sqldir = $(datadir)/wanna-build/postgresql/install
+
+SQL =				\
+	archive-data.sql	\
+	archive.sql		\
+	build-data.sql		\
+	build.sql		\
+	functions.sql		\
+	install.sql		\
+	language.sql		\
+	schema.sql
+
+sql_DATA =			\
+	$(SQL)			\
+	db.sql
+
+db.sql: db.sql.in
+	sqlpath=$$(echo "$(sqldir)"); \
+	sqlpath=$$(echo "$$sqlpath" | sed -e 's/\//\\\//g'); \
+	sed "s,SQL_PATHNAME,$$sqlpath,g" $< >$@
+
+CLEANFILES =	\
+	db.sql
+
+EXTRA_DIST =	\
+	$(SQL)	\
+	db.sql.in
diff --git a/db/archive-data.sql b/db/archive-data.sql
new file mode 100644
index 0000000..0e9a03b
--- /dev/null
+++ b/db/archive-data.sql
@@ -0,0 +1,121 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+INSERT INTO architectures (arch) VALUES
+  ('alpha'),
+  ('amd64'),
+  ('arm'),
+  ('armel'),
+  ('hppa'),
+  ('hurd-i386'),
+  ('i386'),
+  ('ia64'),
+  ('m68k'),
+  ('mips'),
+  ('mipsel'),
+  ('powerpc'),
+  ('s390'),
+  ('sparc');
+
+INSERT INTO suites (suite, priority) VALUES
+  ('oldstable', 1),
+  ('stable', 1),
+  ('testing', 2),
+  ('unstable', 3),
+  ('experimental', 4);
+
+INSERT INTO suites (suite, priority, depwait, hidden) VALUES
+  ('oldstable-security', 1, 'f', 't'),
+  ('stable-security', 1, 'f', 't'),
+  ('testing-security', 2, 'f', 't');
+
+INSERT INTO suite_arches (suite, arch) VALUES
+  ('oldstable', 'alpha'),
+  ('oldstable', 'amd64'),
+  ('oldstable', 'arm'),
+  ('oldstable', 'hppa'),
+  ('oldstable', 'i386'),
+  ('oldstable', 'ia64'),
+  ('oldstable', 'mips'),
+  ('oldstable', 'mipsel'),
+  ('oldstable', 'powerpc'),
+  ('oldstable', 's390'),
+  ('oldstable', 'sparc'),
+  ('stable', 'alpha'),
+  ('stable', 'amd64'),
+  ('stable', 'arm'),
+  ('stable', 'armel'),
+  ('stable', 'hppa'),
+  ('stable', 'i386'),
+  ('stable', 'ia64'),
+  ('stable', 'mips'),
+  ('stable', 'mipsel'),
+  ('stable', 'powerpc'),
+  ('stable', 's390'),
+  ('stable', 'sparc'),
+  ('testing', 'alpha'),
+  ('testing', 'amd64'),
+  ('testing', 'armel'),
+  ('testing', 'hppa'),
+  ('testing', 'i386'),
+  ('testing', 'ia64'),
+  ('testing', 'mips'),
+  ('testing', 'mipsel'),
+  ('testing', 'powerpc'),
+  ('testing', 's390'),
+  ('testing', 'sparc'),
+  ('unstable', 'alpha'),
+  ('unstable', 'amd64'),
+  ('unstable', 'armel'),
+  ('unstable', 'hppa'),
+  ('unstable', 'i386'),
+  ('unstable', 'ia64'),
+  ('unstable', 'mips'),
+  ('unstable', 'mipsel'),
+  ('unstable', 'powerpc'),
+  ('unstable', 's390'),
+  ('unstable', 'sparc'),
+  ('experimental', 'alpha'),
+  ('experimental', 'amd64'),
+  ('experimental', 'armel'),
+  ('experimental', 'hppa'),
+  ('experimental', 'i386'),
+  ('experimental', 'ia64'),
+  ('experimental', 'mips'),
+  ('experimental', 'mipsel'),
+  ('experimental', 'powerpc'),
+  ('experimental', 's390'),
+  ('experimental', 'sparc');
+
+INSERT INTO components (component) VALUES
+  ('main'),
+  ('contrib'),
+  ('non-free');
+
+INSERT INTO package_types (type) VALUES
+  ('deb'),
+  ('udeb');
+
+INSERT INTO package_priorities (pkg_prio, prio_val) VALUES
+ ('required', 1),
+ ('standard', 2),
+ ('important', 3),
+ ('optional', 4),
+ ('extra', 5);
diff --git a/db/archive.sql b/db/archive.sql
new file mode 100644
index 0000000..5c3d8f9
--- /dev/null
+++ b/db/archive.sql
@@ -0,0 +1,266 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+CREATE TABLE architectures (
+	arch text
+	  CONSTRAINT arch_pkey PRIMARY KEY
+);
+
+COMMENT ON TABLE architectures IS 'Architectures known by this wanna-build instance';
+COMMENT ON COLUMN architectures.arch IS 'Architecture name';
+
+CREATE TABLE suites (
+	suite text
+	  CONSTRAINT suite_pkey PRIMARY KEY,
+	priority integer,
+	depwait boolean
+	  DEFAULT 't',
+	hidden boolean
+	  DEFAULT 'f'
+);
+
+COMMENT ON TABLE suites IS 'Valid suites';
+COMMENT ON COLUMN suites.suite IS 'Suite name';
+COMMENT ON COLUMN suites.priority IS 'Sorting order (lower is higher priority)';
+COMMENT ON COLUMN suites.depwait IS 'Automatically wait on dependencies?';
+COMMENT ON COLUMN suites.hidden IS 'Hide suite from public view (e.g. for -security)?';
+
+CREATE TABLE suite_arches (
+	suite text
+	  NOT NULL
+	  CONSTRAINT suite_arches_suite_fkey REFERENCES suites(suite),
+	arch text
+	  NOT NULL
+	  CONSTRAINT suite_arches_arch_fkey REFERENCES architectures(arch),
+	CONSTRAINT suite_arches_pkey PRIMARY KEY (suite, arch)
+);
+
+COMMENT ON TABLE suite_arches IS 'List of architectures in each suite';
+COMMENT ON COLUMN suite_arches.suite IS 'Suite name';
+COMMENT ON COLUMN suite_arches.arch IS 'Architecture name';
+
+CREATE TABLE components (
+	component text
+	  CONSTRAINT component_pkey PRIMARY KEY
+);
+
+COMMENT ON TABLE components IS 'Valid archive components';
+COMMENT ON COLUMN components.component IS 'Component name';
+
+CREATE TABLE package_types (
+	type text
+	  CONSTRAINT pkg_tpe_pkey PRIMARY KEY
+);
+
+COMMENT ON TABLE package_types IS 'Valid types for binary packages';
+COMMENT ON COLUMN package_types.type IS 'Type name';
+
+CREATE TABLE package_architectures (
+	arch text
+	  CONSTRAINT pkg_arch_pkey PRIMARY KEY
+);
+
+COMMENT ON TABLE package_architectures IS 'Possible values for the Architecture field';
+COMMENT ON COLUMN package_architectures.arch IS 'Architecture name';
+
+CREATE TABLE package_priorities (
+	pkg_prio text
+	  CONSTRAINT pkg_pri_pkey PRIMARY KEY,
+	prio_val integer
+	  DEFAULT 0
+);
+
+COMMENT ON TABLE package_priorities IS 'Valid package priorities';
+COMMENT ON COLUMN package_priorities.pkg_prio IS 'Priority name';
+COMMENT ON COLUMN package_priorities.prio_val IS 'Integer value for sorting priorities';
+
+CREATE TABLE package_sections (
+        section text
+          CONSTRAINT pkg_sect_pkey PRIMARY KEY
+);
+
+COMMENT ON TABLE package_sections IS 'Valid package sections';
+COMMENT ON COLUMN package_sections.section IS 'Section name';
+
+CREATE TABLE sources (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	component text
+	  CONSTRAINT source_comp_fkey REFERENCES components(component)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	section text
+	  CONSTRAINT source_section_fkey REFERENCES package_sections(section)
+	  NOT NULL,
+	pkg_prio text
+	  CONSTRAINT source_pkg_prio_fkey REFERENCES package_priorities(pkg_prio)
+	  NOT NULL,
+	maintainer text NOT NULL,
+	build_dep text,
+	build_dep_indep text,
+	build_confl text,
+	build_confl_indep text,
+	stdver text,
+	CONSTRAINT sources_pkey PRIMARY KEY (source, source_version)
+);
+
+CREATE INDEX sources_pkg_idx ON sources (source);
+
+COMMENT ON TABLE sources IS 'Source packages common to all architectures (from Sources)';
+COMMENT ON COLUMN sources.source IS 'Package name';
+COMMENT ON COLUMN sources.source_version IS 'Package version number';
+COMMENT ON COLUMN sources.component IS 'Archive component';
+COMMENT ON COLUMN sources.section IS 'Package section';
+COMMENT ON COLUMN sources.pkg_prio IS 'Package priority';
+COMMENT ON COLUMN sources.maintainer IS 'Package maintainer name';
+COMMENT ON COLUMN sources.build_dep IS 'Package build dependencies (architecture dependent)';
+COMMENT ON COLUMN sources.build_dep_indep IS 'Package build dependencies (architecture independent)';
+COMMENT ON COLUMN sources.build_confl IS 'Package build conflicts (architecture dependent)';
+COMMENT ON COLUMN sources.build_confl_indep IS 'Package build conflicts (architecture independent)';
+COMMENT ON COLUMN sources.stdver IS 'Debian Standards (policy) version number';
+
+CREATE TABLE source_architectures (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	arch text
+	  CONSTRAINT source_arch_arch_fkey
+	  REFERENCES package_architectures(arch)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	UNIQUE (source, source_version, arch),
+	CONSTRAINT source_arch_source_fkey FOREIGN KEY (source, source_version)
+	  REFERENCES sources (source, source_version)
+	  ON DELETE CASCADE
+);
+
+COMMENT ON TABLE source_architectures IS 'Source package architectures (from Sources)';
+COMMENT ON COLUMN source_architectures.source IS 'Package name';
+COMMENT ON COLUMN source_architectures.source_version IS 'Package version number';
+COMMENT ON COLUMN source_architectures.arch IS 'Architecture name';
+
+CREATE TABLE uploaders (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	uploader text
+	  NOT NULL,
+	UNIQUE (source, source_version, uploader),
+	CONSTRAINT uploader_source_fkey FOREIGN KEY (source, source_version)
+	  REFERENCES sources (source, source_version)
+	  ON DELETE CASCADE
+);
+
+COMMENT ON TABLE uploaders IS 'Uploader names for source packages';
+COMMENT ON COLUMN uploaders.source IS 'Package name';
+COMMENT ON COLUMN uploaders.source_version IS 'Package version number';
+COMMENT ON COLUMN uploaders.uploader IS 'Uploader name and address';
+
+CREATE TABLE binaries (
+	-- PostgreSQL won't allow "binary" as column name
+	package text NOT NULL,
+	version debversion NOT NULL,
+	arch text
+	  CONSTRAINT bin_arch_fkey REFERENCES package_architectures(arch)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	section text
+	  CONSTRAINT bin_section_fkey REFERENCES package_sections(section)
+	  NOT NULL,
+	type text
+	  CONSTRAINT bin_pkg_type_fkey REFERENCES package_types(type)
+	  NOT NULL,
+	pkg_prio text
+	  CONSTRAINT bin_pkg_prio_fkey REFERENCES package_priorities(pkg_prio)
+	  NOT NULL,
+	CONSTRAINT bin_pkey PRIMARY KEY (package, version, arch),
+	CONSTRAINT bin_src_fkey FOREIGN KEY (source, source_version)
+	  REFERENCES sources (source, source_version)
+	  ON DELETE CASCADE
+);
+
+COMMENT ON TABLE binaries IS 'Binary packages specific to single architectures (from Packages)';
+COMMENT ON COLUMN binaries.package IS 'Binary package name';
+COMMENT ON COLUMN binaries.version IS 'Binary package version number';
+COMMENT ON COLUMN binaries.arch IS 'Architecture name';
+COMMENT ON COLUMN binaries.source IS 'Source package name';
+COMMENT ON COLUMN binaries.source_version IS 'Source package version number';
+COMMENT ON COLUMN binaries.section IS 'Package section';
+COMMENT ON COLUMN binaries.pkg_prio IS 'Package priority';
+
+CREATE TABLE suite_sources (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	suite text
+	  CONSTRAINT suite_sources_suite_fkey REFERENCES suites(suite)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	CONSTRAINT suite_sources_pkey PRIMARY KEY (source, suite),
+	CONSTRAINT suite_sources_src_fkey FOREIGN KEY (source, source_version)
+	  REFERENCES sources (source, source_version)
+	  ON DELETE CASCADE
+);
+
+CREATE INDEX suite_sources_src_ver_idx ON suite_sources (source, source_version);
+
+COMMENT ON TABLE suite_sources IS 'Source packages contained within a suite';
+COMMENT ON COLUMN suite_sources.source IS 'Source package name';
+COMMENT ON COLUMN suite_sources.source_version IS 'Source package version number';
+COMMENT ON COLUMN suite_sources.suite IS 'Suite name';
+
+CREATE TABLE suite_binaries (
+	package text
+	  NOT NULL,
+	version debversion
+	  NOT NULL,
+	arch text
+	  CONSTRAINT suite_bin_arch_fkey REFERENCES package_architectures(arch)
+          ON DELETE CASCADE
+	  NOT NULL,
+	suite text
+	  CONSTRAINT suite_bin_suite_fkey REFERENCES suites(suite)
+          ON DELETE CASCADE
+	  NOT NULL,
+	CONSTRAINT suite_bin_pkey PRIMARY KEY (package, arch, suite),
+	CONSTRAINT suite_bin_bin_fkey FOREIGN KEY (package, version, arch)
+	  REFERENCES binaries (package, version, arch)
+	  ON DELETE CASCADE,
+	CONSTRAINT suite_bin_suite_arch_fkey FOREIGN KEY (suite, arch)
+	  REFERENCES suite_arches (suite, arch)
+	  ON DELETE CASCADE
+);
+
+CREATE INDEX suite_binaries_pkg_ver_idx ON suite_binaries (package, version);
+
+COMMENT ON TABLE suite_binaries IS 'Binary packages contained within a suite';
+COMMENT ON COLUMN suite_binaries.package IS 'Binary package name';
+COMMENT ON COLUMN suite_binaries.version IS 'Binary package version number';
+COMMENT ON COLUMN suite_binaries.arch IS 'Architecture name';
+COMMENT ON COLUMN suite_binaries.suite IS 'Suite name';
diff --git a/db/build-data.sql b/db/build-data.sql
new file mode 100644
index 0000000..6b78bc6
--- /dev/null
+++ b/db/build-data.sql
@@ -0,0 +1,41 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+INSERT INTO package_states (name) VALUES
+  ('build-attempted'),
+  ('building'),
+  ('built'),
+  ('dep-wait'),
+  ('dep-wait-removed'),
+  ('failed'),
+  ('failed-removed'),
+  ('install-wait'),
+  ('installed'),
+  ('needs-build'),
+  ('not-for-us'),
+  ('old-failed'),
+  ('reupload-wait'),
+  ('state'),
+  ('uploaded');
+
+INSERT INTO build_log_result (result, is_success) VALUES
+  ('maybe-failed', 'f'),
+  ('maybe-successful', 't'),
+  ('skipped', 'f');
diff --git a/db/build.sql b/db/build.sql
new file mode 100644
index 0000000..0aa204c
--- /dev/null
+++ b/db/build.sql
@@ -0,0 +1,245 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+CREATE TABLE builders (
+	builder text
+	  CONSTRAINT builder_pkey PRIMARY KEY,
+	arch text
+	  CONSTRAINT builder_arch_fkey REFERENCES architectures(arch)
+	  NOT NULL,
+	address text
+	  NOT NULL
+);
+
+COMMENT ON TABLE builders IS 'buildd usernames (database users from _userinfo in old MLDBM db format)';
+COMMENT ON COLUMN builders.builder IS 'Username';
+COMMENT ON COLUMN builders.arch IS 'Buildd architecture';
+COMMENT ON COLUMN builders.address IS 'Remote e-mail address of the buildd user';
+
+CREATE TABLE package_states (
+	name text
+	  CONSTRAINT state_pkey PRIMARY KEY
+);
+
+COMMENT ON TABLE package_states IS 'Package states';
+COMMENT ON COLUMN package_states.name IS 'State name';
+
+CREATE TABLE build_status (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	arch text
+	  CONSTRAINT build_status_arch_fkey REFERENCES architectures(arch)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	suite text
+	  CONSTRAINT build_status_suite_fkey REFERENCES suites(suite)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	bin_nmu integer,
+	user_name text
+	  NOT NULL
+	  DEFAULT CURRENT_USER,
+	builder text
+	  -- Can be NULL in case of states set up manually by people.
+	  CONSTRAINT build_status_builder_fkey REFERENCES builders(builder),
+	status text
+	  CONSTRAINT build_status_status_fkey REFERENCES package_states(name)
+	  NOT NULL,
+	ctime timestamp with time zone
+	  NOT NULL
+	  DEFAULT 'epoch'::timestamp,
+	CONSTRAINT build_status_pkey PRIMARY KEY (source, arch, suite),
+	CONSTRAINT build_status_src_fkey FOREIGN KEY(source, source_version)
+	  REFERENCES sources(source, source_version)
+	  ON DELETE CASCADE,
+	CONSTRAINT suite_bin_suite_arch_fkey FOREIGN KEY (suite, arch)
+	  REFERENCES suite_arches (suite, arch)
+	  ON DELETE CASCADE
+);
+
+CREATE INDEX build_status_source ON build_status (source);
+
+COMMENT ON TABLE build_status IS 'Build status for each package';
+COMMENT ON COLUMN build_status.source IS 'Source package name';
+COMMENT ON COLUMN build_status.source_version IS 'Source package version number';
+COMMENT ON COLUMN build_status.arch IS 'Architecture name';
+COMMENT ON COLUMN build_status.suite IS 'Suite name';
+COMMENT ON COLUMN build_status.bin_nmu IS 'Scheduled binary NMU version, if any';
+COMMENT ON COLUMN build_status.user_name IS 'User making this change (username)';
+COMMENT ON COLUMN build_status.builder IS 'Build dæmon making this change (username)';
+COMMENT ON COLUMN build_status.status IS 'Status name';
+COMMENT ON COLUMN build_status.ctime IS 'Stage change time';
+
+CREATE TABLE build_status_history (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	arch text
+	  CONSTRAINT build_status_history_arch_fkey REFERENCES architectures(arch)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	suite text
+	  CONSTRAINT build_status_history_suite_fkey REFERENCES suites(suite)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	bin_nmu integer,
+	user_name text
+	  NOT NULL
+	  DEFAULT CURRENT_USER,
+	builder text
+	  CONSTRAINT build_status_history_builder_fkey REFERENCES builders(builder),
+	status text
+	  CONSTRAINT build_status_history_status_fkey REFERENCES package_states(name)
+	  NOT NULL,
+	ctime timestamp with time zone
+	  NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE INDEX build_status_history_source ON build_status_history (source);
+CREATE INDEX build_status_history_ctime ON build_status_history (ctime);
+
+COMMENT ON TABLE build_status_history IS 'Build status history for each package';
+COMMENT ON COLUMN build_status_history.source IS 'Source package name';
+COMMENT ON COLUMN build_status_history.source_version IS 'Source package version number';
+COMMENT ON COLUMN build_status_history.arch IS 'Architecture name';
+COMMENT ON COLUMN build_status_history.suite IS 'Suite name';
+COMMENT ON COLUMN build_status_history.bin_nmu IS 'Scheduled binary NMU version, if any';
+COMMENT ON COLUMN build_status_history.user_name IS 'User making this change (username)';
+COMMENT ON COLUMN build_status_history.builder IS 'Build dæmon making this change (username)';
+COMMENT ON COLUMN build_status_history.status IS 'Status name';
+COMMENT ON COLUMN build_status_history.ctime IS 'Stage change time';
+
+CREATE TABLE build_status_properties (
+	source text NOT NULL,
+	arch text NOT NULL,
+	source suite NOT NULL,
+	prop_name text NOT NULL,
+	prop_value text NOT NULL,
+	CONSTRAINT build_status_properties_fkey
+	  FOREIGN KEY(source, arch)
+	  REFERENCES build_status(id)
+	  ON DELETE CASCADE,
+	CONSTRAINT build_status_properties_unique
+	  UNIQUE (source, arch, prop_name)
+);
+
+COMMENT ON TABLE build_status_properties IS 'Additional package-specific properties (e.g. For PermBuildPri/BuildPri/Binary-NMU-(Version|ChangeLog)/Notes)';
+COMMENT ON COLUMN build_status_properties.source IS 'Source package name';
+COMMENT ON COLUMN build_status_properties.arch IS 'Architecture name';
+COMMENT ON COLUMN build_status_properties.suite IS 'Suite name';
+COMMENT ON COLUMN build_status_properties.prop_name IS 'Property name';
+COMMENT ON COLUMN build_status_properties.prop_value IS 'Property value';
+
+-- Make this a table because in the future we may have more fine-grained
+-- result states.
+CREATE TABLE build_log_result (
+	result text
+	  CONSTRAINT build_log_result_pkey PRIMARY KEY,
+	is_success boolean
+	  DEFAULT 'f'
+);
+
+COMMENT ON TABLE build_log_result IS 'Possible results states of a build log';
+COMMENT ON COLUMN build_log_result.result IS 'Meaningful and short name for the result';
+COMMENT ON COLUMN build_log_result.is_success IS 'Whether the result of the build is successful';
+
+CREATE TABLE build_logs (
+	source text
+	  NOT NULL,
+	source_version debversion
+	  NOT NULL,
+	arch text
+	  CONSTRAINT build_logs_arch_fkey REFERENCES architectures(arch)
+	  NOT NULL,
+	suite text
+	  CONSTRAINT build_logs_suite_fkey REFERENCES suites(suite)
+	  NOT NULL,
+	date timestamp with time zone
+	  NOT NULL,
+	result text
+	  CONSTRAINT build_logs_result_fkey REFERENCES build_log_result(result)
+	  NOT NULL,
+	build_time interval,
+	used_space integer,
+	path text
+	  CONSTRAINT build_logs_pkey PRIMARY KEY
+);
+CREATE INDEX build_logs_source_idx ON build_logs (source);
+
+COMMENT ON TABLE build_logs IS 'Available build logs';
+COMMENT ON COLUMN build_logs.source IS 'Source package name';
+COMMENT ON COLUMN build_logs.source_version IS 'Source package version';
+COMMENT ON COLUMN build_logs.arch IS 'Architecture name';
+COMMENT ON COLUMN build_logs.suite IS 'Suite name';
+COMMENT ON COLUMN build_logs.date IS 'Date of the log';
+COMMENT ON COLUMN build_logs.result IS 'Result state';
+COMMENT ON COLUMN build_logs.build_time IS 'Time needed by the build';
+COMMENT ON COLUMN build_logs.used_space IS 'Space needed by the build';
+COMMENT ON COLUMN build_logs.path IS 'Relative path to the log file';
+
+CREATE TABLE log (
+	time timestamp with time zone
+	  NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	username text NOT NULL DEFAULT CURRENT_USER,
+	message text NOT NULL
+);
+
+CREATE INDEX log_idx ON log (time);
+
+COMMENT ON TABLE log IS 'Log messages';
+COMMENT ON COLUMN log.time IS 'Log entry time';
+COMMENT ON COLUMN log.username IS 'Log user name';
+COMMENT ON COLUMN log.message IS 'Log entry message';
+
+CREATE TABLE people (
+	login text
+	  CONSTRAINT people_pkey PRIMARY KEY,
+	full_name text
+	  NOT NULL,
+	address text
+	  NOT NULL
+);
+
+COMMENT ON TABLE people IS 'People wanna-build should know about';
+COMMENT ON COLUMN people.login IS 'Debian login';
+COMMENT ON COLUMN people.full_name IS 'Full name';
+COMMENT ON COLUMN people.address IS 'E-mail address';
+
+CREATE TABLE buildd_admins (
+	builder text
+	  CONSTRAINT buildd_admin_builder_fkey REFERENCES builders(builder)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	admin text
+	  CONSTRAINT buildd_admin_admin_fkey REFERENCES people(login)
+	  ON DELETE CASCADE
+	  NOT NULL,
+	backup boolean
+	  DEFAULT 'f',
+	UNIQUE (builder, admin)
+);
+
+COMMENT ON TABLE buildd_admins IS 'Admins for each buildd';
+COMMENT ON COLUMN buildd_admins.builder IS 'The buildd';
+COMMENT ON COLUMN buildd_admins.admin IS 'The admin login';
+COMMENT ON COLUMN buildd_admins.backup IS 'Whether this is only a backup admin';
diff --git a/db/db.sql.in b/db/db.sql.in
new file mode 100644
index 0000000..3ad6dd4
--- /dev/null
+++ b/db/db.sql.in
@@ -0,0 +1,32 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+\i /usr/share/postgresql/8.3/contrib/debversion.sql
+
+SET search_path = public;
+
+\i SQL_PATHNAME/language.sql
+\i SQL_PATHNAME/schema.sql
+\i SQL_PATHNAME/archive.sql
+\i SQL_PATHNAME/build.sql
+\i SQL_PATHNAME/functions.sql
+
+\i SQL_PATHNAME/archive-data.sql
+\i SQL_PATHNAME/build-data.sql
diff --git a/db/functions.sql b/db/functions.sql
new file mode 100644
index 0000000..7334bb0
--- /dev/null
+++ b/db/functions.sql
@@ -0,0 +1,129 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+--
+-- Triggers to insert missing sections and priorities
+--
+
+CREATE OR REPLACE FUNCTION package_checkrel() RETURNS trigger AS $package_checkrel$
+BEGIN
+  PERFORM section FROM package_sections WHERE (section = NEW.section);
+  IF FOUND = 'f' THEN
+    INSERT INTO package_sections (section) VALUES (NEW.section);
+  END IF;
+  PERFORM pkg_prio FROM package_priorities WHERE (pkg_prio = NEW.pkg_prio);
+  IF FOUND = 'f' THEN
+    INSERT INTO package_priorities (pkg_prio) VALUES (NEW.pkg_prio);
+  END IF;
+  RETURN NEW;
+END;
+$package_checkrel$ LANGUAGE plpgsql;
+COMMENT ON FUNCTION package_checkrel ()
+  IS 'Check foreign key references (package sections and priorities) exist';
+
+CREATE TRIGGER checkrel BEFORE INSERT OR UPDATE ON sources
+  FOR EACH ROW EXECUTE PROCEDURE package_checkrel();
+COMMENT ON TRIGGER checkrel ON sources
+  IS 'Check foreign key references (package sections and priorities) exist';
+
+CREATE TRIGGER checkrel BEFORE INSERT OR UPDATE ON binaries
+  FOR EACH ROW EXECUTE PROCEDURE package_checkrel();
+COMMENT ON TRIGGER checkrel ON binaries
+  IS 'Check foreign key references (package sections and priorities) exist';
+
+--
+-- Triggers to insert missing package architectures
+--
+
+CREATE OR REPLACE FUNCTION package_check_arch() RETURNS trigger AS $package_check_arch$
+BEGIN
+  PERFORM arch FROM package_architectures WHERE (arch = NEW.arch);
+  IF FOUND = 'f' THEN
+    INSERT INTO package_architectures (arch) VALUES (NEW.arch);
+  END IF;
+  RETURN NEW;
+END;
+$package_check_arch$ LANGUAGE plpgsql;
+
+COMMENT ON FUNCTION package_check_arch ()
+  IS 'Insert missing values into package_architectures (from NEW.arch)';
+
+CREATE TRIGGER check_arch BEFORE INSERT OR UPDATE ON source_architectures
+  FOR EACH ROW EXECUTE PROCEDURE package_check_arch();
+COMMENT ON TRIGGER check_arch ON source_architectures
+  IS 'Ensure foreign key references (arch) exist';
+
+CREATE TRIGGER check_arch BEFORE INSERT OR UPDATE ON binaries
+  FOR EACH ROW EXECUTE PROCEDURE package_check_arch();
+COMMENT ON TRIGGER check_arch ON binaries
+  IS 'Ensure foreign key references (arch) exist';
+
+-- Triggers on build_status:
+--   - unconditionally update ctime
+--   - verify bin_nmu is a positive integer (and change 0 to NULL)
+--   - insert a record into status_history for every change in build_status
+
+CREATE OR REPLACE FUNCTION set_ctime()
+RETURNS trigger AS $set_ctime$
+BEGIN
+  NEW.ctime = CURRENT_TIMESTAMP;
+  RETURN NEW;
+END;
+$set_ctime$ LANGUAGE plpgsql;
+
+CREATE OR REPLACE FUNCTION check_bin_nmu_number()
+RETURNS trigger AS $check_bin_nmu_number$
+BEGIN
+  IF NEW.bin_nmu = 0 THEN
+    NEW.bin_nmu = NULL; -- Avoid two values with same meaning
+  ELSIF NEW.bin_nmu < 0 THEN
+    RAISE EXCEPTION 'Invalid value for "bin_nmu" column: %', NEW.bin_nmu;
+  END IF;
+  RETURN NEW;
+END;
+$check_bin_nmu_number$ LANGUAGE plpgsql;
+
+CREATE TRIGGER check_bin_nmu BEFORE INSERT OR UPDATE ON build_status
+  FOR EACH ROW EXECUTE PROCEDURE check_bin_nmu_number();
+COMMENT ON TRIGGER check_bin_nmu ON build_status
+  IS 'Ensure "bin_nmu" is a positive integer, or set it to NULL if 0';
+
+CREATE TRIGGER set_or_update_ctime BEFORE INSERT OR UPDATE ON build_status
+  FOR EACH ROW EXECUTE PROCEDURE set_ctime();
+COMMENT ON TRIGGER set_or_update_ctime ON build_status
+  IS 'Set or update the "ctime" column to now()';
+
+CREATE OR REPLACE FUNCTION update_status_history()
+RETURNS trigger AS $update_status_history$
+BEGIN
+  INSERT INTO build_status_history
+    (source, source_version, arch, suite,
+     bin_nmu, user_name, builder, status, ctime)
+    VALUES
+      (NEW.source, NEW.source_version, NEW.arch, NEW.suite,
+       NEW.bin_nmu, NEW.user_name, NEW.builder, NEW.status, NEW.ctime);
+  RETURN NULL;
+END;
+$update_status_history$ LANGUAGE plpgsql;
+
+CREATE TRIGGER update_history AFTER INSERT OR UPDATE ON build_status
+  FOR EACH ROW EXECUTE PROCEDURE update_status_history();
+COMMENT ON TRIGGER update_history ON build_status
+  IS 'Insert a record of the status change into build_status_history';
diff --git a/db/install.sql b/db/install.sql
new file mode 100644
index 0000000..203c418
--- /dev/null
+++ b/db/install.sql
@@ -0,0 +1,26 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+CREATE DATABASE "sbuild-packages" ENCODING 'UTF8';
+COMMENT ON DATABASE "sbuild-packages"
+  IS 'Debian source builder package state management';
+\c "sbuild-packages"
+
+\i db.sql
diff --git a/db/language.sql b/db/language.sql
new file mode 100644
index 0000000..e961ac7
--- /dev/null
+++ b/db/language.sql
@@ -0,0 +1,38 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2008-2009 Roger Leigh <rleigh@debian.org>
+--- Copyright © 2008-2009 Marc 'HE' Brockschmidt <he@debian.org>
+--- Copyright © 2008-2009 Adeodato Simó <adeodato@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+CREATE OR REPLACE FUNCTION create_plpgsql_language ()
+  RETURNS TEXT AS $$
+    CREATE LANGUAGE plpgsql;
+    SELECT 'language plpgsql created'::TEXT;
+$$
+LANGUAGE SQL;
+
+SELECT CASE WHEN
+ (SELECT 't'::boolean
+    FROM pg_language
+      WHERE lanname='plpgsql')
+  THEN
+    (SELECT 'language plpgsql already installed'::TEXT)
+  ELSE
+    (SELECT create_plpgsql_language())
+END;
+
+DROP FUNCTION create_plpgsql_language();
diff --git a/db/schema.sql b/db/schema.sql
new file mode 100644
index 0000000..ff51d39
--- /dev/null
+++ b/db/schema.sql
@@ -0,0 +1,27 @@
+--- Debian Source Builder: Database Schema for PostgreSQL            -*- sql -*-
+---
+--- Copyright © 2009 Roger Leigh <rleigh@debian.org>
+---
+--- This program is free software: you can redistribute it and/or modify
+--- it under the terms of the GNU General Public License as published by
+--- the Free Software Foundation, either version 2 of the License, or
+--- (at your option) any later version.
+---
+--- This program is distributed in the hope that it will be useful, but
+--- WITHOUT ANY WARRANTY; without even the implied warranty of
+--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+--- General Public License for more details.
+---
+--- You should have received a copy of the GNU General Public License
+--- along with this program.  If not, see
+--- <http://www.gnu.org/licenses/>.
+
+CREATE TABLE schema (
+	version integer
+	  CONSTRAINT schema_pkey PRIMARY KEY,
+	description text NOT NULL
+);
+
+COMMENT ON TABLE schema IS 'Schema revision history';
+COMMENT ON COLUMN schema.version IS 'Schema version';
+COMMENT ON COLUMN schema.description IS 'Schema change description';