diff options
Diffstat (limited to 'misc')
| -rw-r--r-- | misc/database-layout.dump | 22 |
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`), |