From faaff687c71809101943840bb0115e7000e6f606 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 28 Jun 2019 09:05:03 +0200 Subject: new table `command_log` --- misc/database-layout.dump | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'misc/database-layout.dump') 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, -- cgit v1.2.3-54-g00ecf