new table `command_log`

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,