diff options
author | Erich Eckner <git@eckner.net> | 2019-03-07 13:19:11 +0100 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2019-03-07 13:19:11 +0100 |
commit | 9d89c00d7d345cc42b6aae814315a7a3e5f0b607 (patch) | |
tree | 1ef8809f40dd1e60fc31086c97d03fe2360bf704 /misc/database-layout.dump | |
parent | 5266bbc8bae99d09837027952793c00c857ef542 (diff) | |
download | builder-9d89c00d7d345cc42b6aae814315a7a3e5f0b607.tar.xz |
new table `upstream_packages`
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r-- | misc/database-layout.dump | 15 |
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, |