summaryrefslogtreecommitdiffstats
path: root/db/build-data.sql
blob: 6b78bc6508fabaf639e906a6433cba9ba08d8035 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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');