From cf3c20ce7b9afefac53980bb1741af4031125c2e Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 23 Aug 2019 11:01:13 +0200
Subject: misc/database-layout: `toolchain_order` has a new column
 `requires_all_dependencies_built` and a new key

---
 misc/database-layout.dump | 27 ++++++++++++++++-----------
 1 file changed, 16 insertions(+), 11 deletions(-)

(limited to 'misc/database-layout.dump')

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 538f63f..2cd009e 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -485,8 +485,8 @@ binary_packages	CREATE TABLE `binary_packages` (
 	 `sha512sum` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 `sub_pkgrel_omitted` bit(1) NOT NULL DEFAULT b'0',
 	 PRIMARY KEY (`id`),
-	 UNIQUE KEY `file_name` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`),
-	 UNIQUE KEY `content` (`build_assignment`,`sub_pkgrel`,`pkgname`,`architecture`),
+	 UNIQUE KEY `file_name` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`sub_pkgrel_omitted`),
+	 UNIQUE KEY `content` (`build_assignment`,`sub_pkgrel`,`pkgname`,`architecture`,`sub_pkgrel_omitted`),
 	 KEY `architecture` (`architecture`),
 	 KEY `epoch` (`epoch`),
 	 KEY `pkgver` (`pkgver`),
@@ -811,7 +811,9 @@ todos	CREATE TABLE `todos` (
 toolchain_order	CREATE TABLE `toolchain_order` (
 	 `number` smallint(6) NOT NULL,
 	 `pkgbase` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+	 `requires_all_dependencies_built` bit(1) NOT NULL,
 	 PRIMARY KEY (`number`),
+	 UNIQUE KEY `content` (`pkgbase`,`requires_all_dependencies_built`),
 	 KEY `pkgbase` (`pkgbase`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 upstream_packages	CREATE TABLE `upstream_packages` (
@@ -881,7 +883,7 @@ INSERT INTO `email_actions` VALUES
   (3,'unblock');
 INSERT INTO `fail_reasons` VALUES
   (1,'build()','==> ERROR: A failure occurred in build()\\.',1),
-  (2,'source','==> ERROR: Could not download sources\\.',2),
+  (2,'source','==> ERROR: Could not download sources\\.\\|==> ERROR: Failure while downloading .*',2),
   (3,'package-cache','.*error: failed to commit transaction (invalid or corrupted package (PGP signature))',3),
   (4,'prepare()','==> ERROR: A failure occurred in prepare()\\.',3),
   (5,'package()','==> ERROR: A failure occurred in package\\(_\\S\\+\\)\\?()\\.',4),
@@ -890,13 +892,16 @@ INSERT INTO `fail_reasons` VALUES
   (8,'run-as-root','==> ERROR: Running makepkg as root is not allowed as it can cause permanent,',2),
   (9,'unknown','.*',101),
   (10,'pacman','==> ERROR: Failed to install all packages',6),
-  (11,'unclean-chroot','==> ERROR: \'.*\' does not appear to be an Arch chroot\\.|==> ERROR: Working directory \'.*\' already exists',6),
+  (11,'unclean-chroot','==> ERROR: \'.*\' does not appear to be an Arch chroot\\.\\|==> ERROR: Working directory \'.*\' already exists',6),
   (12,'vcs-source','==> ERROR: Failure while creating working copy of .*',6),
   (14,'pacman-sync','error: failed to synchronize all databases',6),
   (15,'broken-slave:missing-programs','sudo: .*: command not found',7),
   (16,'broken-slave:systemd-hangup','Failed to attach [0-9]\\+ to compat systemd cgroup /\\S\\+: No such file or directory',7),
   (17,'build():broken-haskell-source','.*mismatched interface file versions (.*)',0),
-  (18,'out-of-space','.*No space left on device',0);
+  (18,'out-of-space','.*No space left on device',0),
+  (19,'validity','==> ERROR: One or more files did not pass the validity check!',2),
+  (20,'pgp-verify','==> ERROR: One or more PGP signatures could not be verified!',2),
+  (21,'checksum-verify','==> ERROR: Integrity checks (.*) differ in size from the source array.',2);
 INSERT INTO `repositories` VALUES
   (1,'core',1,'1',2),
   (2,'extra',1,'1',2),
@@ -999,12 +1004,12 @@ INSERT INTO `repository_stability_relations` VALUES
   (23,4,4),
   (4,5,6);
 INSERT INTO `toolchain_order` VALUES
-  (2,'binutils'),
-  (4,'binutils'),
-  (3,'gcc'),
-  (1,'glibc'),
-  (5,'glibc'),
-  (0,'linux-api-headers');
+  (2,'binutils','\0'),
+  (4,'binutils','1'),
+  (3,'gcc','1'),
+  (1,'glibc','\0'),
+  (5,'glibc','1'),
+  (0,'linux-api-headers','\0');
 INSERT INTO `upstream_repositories` VALUES
   (4,'community',2),
   (1,'core',1),
-- 
cgit v1.2.3-54-g00ecf