From 9ec94e507ffde2b21b95b1107d6812f83bebc104 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 17 Oct 2019 09:54:21 +0200 Subject: `compressions` and `binary_packages`.`compression` new --- misc/database-layout.dump | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) (limited to 'misc/database-layout.dump') 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'), -- cgit v1.2.3-54-g00ecf