summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-09-03 09:47:48 +0200
committerErich Eckner <git@eckner.net>2018-09-03 09:54:11 +0200
commit00ec890ca7e2aaf5fc1c8c48eefe2ac3b1327493 (patch)
treeb73ce7e44a8abd79fe80d2c15b57c5c9a308fc99 /misc/database-layout.dump
parent75076807c4aa6a5dcc82f222b8fbe700464947b9 (diff)
downloadbuilder-00ec890ca7e2aaf5fc1c8c48eefe2ac3b1327493.tar.xz
misc/database-layout.dump, misc/database-layout.dmf: new table `versions` - not yet in FOREIGN KEYs
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump22
1 files changed, 17 insertions, 5 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 61c78be..c8fedbb 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -675,10 +675,12 @@ dependencies CREATE TABLE `dependencies` (
`dependent` bigint(20) NOT NULL,
`depending_on` bigint(20) NOT NULL,
`dependency_type` smallint(6) NOT NULL,
+ `version` bigint(20) DEFAULT NULL,
+ `version_relation` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `content` (`dependent`,`depending_on`,`dependency_type`),
- KEY `depending_on` (`depending_on`),
- KEY `dependency_type` (`dependency_type`),
+ UNIQUE KEY `content` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`),
+ KEY `dependencies_ibfk_2` (`depending_on`),
+ KEY `dependencies_ibfk_3` (`dependency_type`),
CONSTRAINT `dependencies_ibfk_1` FOREIGN KEY (`dependent`) REFERENCES `binary_packages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dependencies_ibfk_2` FOREIGN KEY (`depending_on`) REFERENCES `install_targets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dependencies_ibfk_3` FOREIGN KEY (`dependency_type`) REFERENCES `dependency_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
@@ -759,9 +761,10 @@ install_target_providers CREATE TABLE `install_target_providers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`package` bigint(20) NOT NULL,
`install_target` bigint(20) NOT NULL,
+ `version` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `content` (`package`,`install_target`),
- KEY `install_target` (`install_target`),
+ UNIQUE KEY `content` (`package`,`install_target`,`version`),
+ KEY `install_target_providers_ibfk_2` (`install_target`),
CONSTRAINT `install_target_providers_ibfk_1` FOREIGN KEY (`package`) REFERENCES `binary_packages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `install_target_providers_ibfk_2` FOREIGN KEY (`install_target`) REFERENCES `install_targets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -912,6 +915,15 @@ upstream_repositories CREATE TABLE `upstream_repositories` (
KEY `git_repository` (`git_repository`),
CONSTRAINT `upstream_repositories_ibfk_1` FOREIGN KEY (`git_repository`) REFERENCES `git_repositories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+versions CREATE TABLE `versions` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `order` bigint(20) DEFAULT NULL,
+ `epoch` mediumint(9) NOT NULL,
+ `version` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `content` (`epoch`,`version`),
+ KEY `order` (`order`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
INSERT INTO `architectures` VALUES
(1,'any'),
(2,'i686');