summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dump22
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`),