Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump15
1 files changed, 15 insertions, 0 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 4568bd9..89e558f 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -937,6 +937,21 @@ toolchain_order CREATE TABLE `toolchain_order` (
PRIMARY KEY (`number`),
KEY `pkgbase` (`pkgbase`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+upstream_packages CREATE TABLE `upstream_packages` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `pkgname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `epoch` mediumint(9) NOT NULL,
+ `pkgver` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `pkgrel` mediumint(9) NOT NULL,
+ `architecture` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `repository` smallint(6) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `content` (`pkgname`,`epoch`,`pkgver`,`pkgrel`),
+ UNIQUE KEY `location` (`pkgname`,`repository`),
+ KEY `architecture` (`architecture`),
+ KEY `upstream_packages_ibfk_1` (`repository`),
+ CONSTRAINT `upstream_packages_ibfk_1` FOREIGN KEY (`repository`) REFERENCES `upstream_repositories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
upstream_repositories CREATE TABLE `upstream_repositories` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,