diff options
| author | Erich Eckner <git@eckner.net> | 2018-04-18 13:46:30 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-04-18 13:46:30 +0200 |
| commit | 51f204a4a030cd183388e25f276d5e36742943fd (patch) | |
| tree | c35caadee599ee3b8cc65e44a6ec74c23315464b | |
| parent | ae25c307af96c3078ed96d0f36de8d8e12e4db80 (diff) | |
| download | builder-51f204a4a030cd183388e25f276d5e36742943fd.tar.xz | |
misc/database-layout.dump: new default values, decomissioned `last_connection`
| -rw-r--r-- | misc/database-layout.dump | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 64cb5fd..e7b7f7a 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -123,7 +123,6 @@ build_slaves CREATE TABLE `build_slaves` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `currently_building` bigint(20) DEFAULT NULL, - `last_connection` datetime NOT NULL, `logged_lines` bigint(20) DEFAULT NULL, `last_action` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ssh_key` bigint(20) NOT NULL, @@ -163,7 +162,7 @@ email_actions CREATE TABLE `email_actions` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci email_log CREATE TABLE `email_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, - `date` datetime NOT NULL, + `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `success` bit(1) NOT NULL, `action` mediumint(9) DEFAULT NULL, `count` mediumint(9) DEFAULT NULL, @@ -304,7 +303,7 @@ ssh_keys CREATE TABLE `ssh_keys` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ssh_log CREATE TABLE `ssh_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, - `date` datetime NOT NULL, + `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `build_slave` mediumint(9) DEFAULT NULL, `action` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `parameters` text COLLATE utf8mb4_unicode_ci NOT NULL, @@ -314,7 +313,7 @@ ssh_log CREATE TABLE `ssh_log` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci statistics CREATE TABLE `statistics` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, - `date` datetime NOT NULL, + `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `stable_packages_count` mediumint(9) NOT NULL, `pending_tasks_count` mediumint(9) NOT NULL, `pending_packages_count` mediumint(9) NOT NULL, |