summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-04-18 13:46:30 +0200
committerErich Eckner <git@eckner.net>2018-04-18 13:46:30 +0200
commit51f204a4a030cd183388e25f276d5e36742943fd (patch)
treec35caadee599ee3b8cc65e44a6ec74c23315464b
parentae25c307af96c3078ed96d0f36de8d8e12e4db80 (diff)
downloadbuilder-51f204a4a030cd183388e25f276d5e36742943fd.tar.xz
misc/database-layout.dump: new default values, decomissioned `last_connection`
-rw-r--r--misc/database-layout.dump7
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,