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.dump11
1 files changed, 11 insertions, 0 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 2ae42c4..b2f1c7f 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -611,6 +611,17 @@ build_slaves CREATE TABLE `build_slaves` (
CONSTRAINT `build_slaves_ibfk_1` FOREIGN KEY (`currently_building`) REFERENCES `build_assignments` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `build_slaves_ibfk_2` FOREIGN KEY (`ssh_key`) REFERENCES `ssh_keys` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+command_log CREATE TABLE `command_log` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `date` timestamp NOT NULL DEFAULT current_timestamp(),
+ `command` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `parameters` text COLLATE utf8mb4_unicode_ci NOT NULL,
+ `shell` bit(1) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `date` (`date`),
+ KEY `command` (`command`),
+ KEY `shell` (`shell`)
+) 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,