`compressions` and `binary_packages`.`compression` new

1 files changed, 19 insertions, 1 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index f67fcc3..3d00aac 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -484,6 +484,7 @@ binary_packages	CREATE TABLE `binary_packages` (
 	 `architecture` smallint(6) NOT NULL,
 	 `sha512sum` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 `sub_pkgrel_omitted` bit(1) NOT NULL DEFAULT b'0',
+	 `compression` smallint(6) DEFAULT NULL,
 	 PRIMARY KEY (`id`),
 	 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`),
@@ -491,8 +492,10 @@ binary_packages	CREATE TABLE `binary_packages` (
 	 KEY `epoch` (`epoch`),
 	 KEY `pkgver` (`pkgver`),
 	 KEY `pkgname` (`pkgname`),
+	 KEY `compression` (`compression`),
 	 CONSTRAINT `binary_packages_ibfk_1` FOREIGN KEY (`architecture`) REFERENCES `architectures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-	 CONSTRAINT `binary_packages_ibfk_2` FOREIGN KEY (`build_assignment`) REFERENCES `build_assignments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+	 CONSTRAINT `binary_packages_ibfk_2` FOREIGN KEY (`build_assignment`) REFERENCES `build_assignments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+	 CONSTRAINT `binary_packages_ibfk_3` FOREIGN KEY (`compression`) REFERENCES `compressions` (`id`) ON DELETE SET NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 binary_packages_in_repositories	CREATE TABLE `binary_packages_in_repositories` (
 	 `id` bigint(20) NOT NULL AUTO_INCREMENT,
@@ -559,6 +562,12 @@ command_log	CREATE TABLE `command_log` (
 	 KEY `command` (`command`),
 	 KEY `shell` (`shell`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+compressions	CREATE TABLE `compressions` (
+	 `id` smallint(6) NOT NULL AUTO_INCREMENT,
+	 `suffix` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
+	 PRIMARY KEY (`id`),
+	 UNIQUE KEY `suffix` (`suffix`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 dependencies	CREATE TABLE `dependencies` (
 	 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 	 `dependent` bigint(20) NOT NULL,
@@ -868,6 +877,15 @@ INSERT INTO `architecture_compatibilities` VALUES
   (8,4,4,'1','1'),
   (9,2,4,'\0','1'),
   (10,3,4,'\0','\0');
+INSERT INTO `compressions` VALUES
+  (1,'tar'),
+  (3,'tar.bz2'),
+  (2,'tar.gz'),
+  (5,'tar.lzo'),
+  (6,'tar.lzr'),
+  (4,'tar.xz'),
+  (7,'tar.Z'),
+  (8,'tar.zst');
 INSERT INTO `dependency_types` VALUES
   (2,'run','1','1'),
   (3,'check','\0','\0'),