summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-09-13 12:30:33 +0200
committerErich Eckner <git@eckner.net>2018-09-13 12:30:33 +0200
commit5b18b6f2cfe011660f2c49b69caf91092b32b0fb (patch)
tree5caa0592430cf1ad30ff9321897258685b9f4aa6 /misc/database-layout.dump
parentce4e7ee115389aa5e646abdeb8af1764d182542d (diff)
downloadbuilder-5b18b6f2cfe011660f2c49b69caf91092b32b0fb.tar.xz
misc/database-layout.dump, misc/database-layout.dmf: represent toolchain_order correctly
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump14
1 files changed, 14 insertions, 0 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 7862557..0db5f96 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -910,6 +910,13 @@ todos CREATE TABLE `todos` (
`importance` smallint(6) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+toolchain_order CREATE TABLE `toolchain_order` (
+ `number` smallint(6) NOT NULL,
+ `pkgbase` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`number`),
+ KEY `pkgbase` (`pkgbase`),
+ CONSTRAINT `pkgbase` FOREIGN KEY (`pkgbase`) REFERENCES `package_sources` (`pkgbase`) 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,
@@ -1047,6 +1054,13 @@ INSERT INTO `repository_stability_relations` VALUES
(2,3,6),
(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');
INSERT INTO `upstream_repositories` VALUES
(4,'community',2),
(1,'core',1),