misc/database-layout.dump: database version (and thus defaults) updated

1 files changed, 11 insertions, 11 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index b17ff13..0d05765 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -1,4 +1,4 @@
-blacklist_packages	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `blacklist_packages`()
+blacklist_packages	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `blacklist_packages`()
 blacklist_packages:BEGIN
 CREATE TEMPORARY TABLE `bl` (`arch` SMALLINT,`pkgbase` VARCHAR(64),UNIQUE KEY `content`(`arch`,`pkgbase`));
 CREATE TEMPORARY TABLE `bl_copy` (`arch` SMALLINT,`pkgbase` VARCHAR(64),UNIQUE KEY `content`(`arch`,`pkgbase`));
@@ -97,7 +97,7 @@ INSERT IGNORE INTO `relevant_binary_packages` (`id`)
 UNTIL ROW_COUNT()=0
 END REPEAT;
 END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci
-calculate_maximal_moveable_set	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `calculate_maximal_moveable_set`(IN `from_stability` MEDIUMINT)
+calculate_maximal_moveable_set	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `calculate_maximal_moveable_set`(IN `from_stability` MEDIUMINT)
 BEGIN
 DECLARE row_count_saved INT DEFAULT 0;
 DROP TEMPORARY TABLE IF EXISTS `moveable_bpir`;
@@ -410,7 +410,7 @@ DROP TEMPORARY TABLE `moveable_bpir_copy`;
 DROP TEMPORARY TABLE `replaced_bpir_copy`;
 DROP TEMPORARY TABLE `replaced_bpir_copy2`;
 END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci
-find_the_culprit	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `find_the_culprit`(IN `bpir` BIGINT)
+find_the_culprit	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `find_the_culprit`(IN `bpir` BIGINT)
 find_the_culprit:BEGIN
 DECLARE row_count_saved INT DEFAULT 0;
 UPDATE `knots` SET `knots`.`reason_length`=NULL, `knots`.`relevant`=NULL, `knots`.`active`=1;
@@ -638,7 +638,7 @@ binary_packages_in_repositories	CREATE TABLE `binary_packages_in_repositories` (
 	 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 	 `package` bigint(20) NOT NULL,
 	 `repository` mediumint(9) NOT NULL,
-	 `last_moved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	 `last_moved` timestamp NOT NULL DEFAULT current_timestamp(),
 	 `is_to_be_deleted` bit(1) NOT NULL,
 	 PRIMARY KEY (`id`),
 	 UNIQUE KEY `content` (`package`,`repository`),
@@ -653,7 +653,7 @@ build_assignments	CREATE TABLE `build_assignments` (
 	 `is_blocked` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 `is_broken` bit(1) NOT NULL,
 	 `priority` smallint(6) NOT NULL,
-	 `is_black_listed` text COLLATE utf8mb4_unicode_ci,
+	 `is_black_listed` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 `return_date` timestamp NULL DEFAULT NULL,
 	 PRIMARY KEY (`id`),
 	 UNIQUE KEY `content` (`package_source`,`architecture`),
@@ -719,12 +719,12 @@ 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` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	 `date` timestamp NOT NULL DEFAULT current_timestamp(),
 	 `success` bit(1) NOT NULL,
 	 `action` mediumint(9) DEFAULT NULL,
 	 `count` mediumint(9) DEFAULT NULL,
 	 `gpg_key` bigint(20) DEFAULT NULL,
-	 `comment` text COLLATE utf8mb4_unicode_ci,
+	 `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 PRIMARY KEY (`id`),
 	 KEY `action` (`action`),
 	 KEY `gpg_key` (`gpg_key`),
@@ -743,7 +743,7 @@ failed_builds	CREATE TABLE `failed_builds` (
 	 `id` mediumint(9) NOT NULL AUTO_INCREMENT,
 	 `build_slave` mediumint(9) NOT NULL,
 	 `build_assignment` bigint(20) NOT NULL,
-	 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	 `date` timestamp NOT NULL DEFAULT current_timestamp(),
 	 `reason` smallint(6) NOT NULL,
 	 `log_file` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
 	 `log_file_exists` bit(1) NOT NULL,
@@ -884,7 +884,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` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	 `date` timestamp 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,
@@ -895,7 +895,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` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+	 `date` timestamp 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,
@@ -908,7 +908,7 @@ statistics	CREATE TABLE `statistics` (
 	 `locked_tasks_count` mediumint(9) NOT NULL,
 	 `blocked_tasks_count` mediumint(9) NOT NULL,
 	 `next_tasks_count` mediumint(9) NOT NULL,
-	 `architecture` smallint(6) NOT NULL DEFAULT '1',
+	 `architecture` smallint(6) NOT NULL DEFAULT 1,
 	 PRIMARY KEY (`id`),
 	 UNIQUE KEY `date_architecture` (`date`,`architecture`),
 	 KEY `architecture` (`architecture`),