From 9ce5edd59b68a3f3fe2549d26dd9e029c79bb480 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 31 Jul 2019 11:23:29 +0200 Subject: misc/database-layout.dump: enforce "NOT NULL" on several columns --- misc/database-layout.dump | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 709404f..fb793ac 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -635,8 +635,8 @@ dependencies CREATE TABLE `dependencies` ( `dependent` bigint(20) NOT NULL, `depending_on` bigint(20) NOT NULL, `dependency_type` smallint(6) NOT NULL, - `version` bigint(20) DEFAULT NULL, - `version_relation` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `version` bigint(20) NOT NULL, + `version_relation` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `content` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`), KEY `dependencies_ibfk_2` (`depending_on`), @@ -736,7 +736,7 @@ install_target_providers CREATE TABLE `install_target_providers` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci install_targets CREATE TABLE `install_targets` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, - `name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -881,7 +881,7 @@ todos CREATE TABLE `todos` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci toolchain_order CREATE TABLE `toolchain_order` ( `number` smallint(6) NOT NULL, - `pkgbase` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `pkgbase` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`number`), KEY `pkgbase` (`pkgbase`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -913,7 +913,7 @@ versions CREATE TABLE `versions` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order` bigint(20) DEFAULT NULL, `epoch` mediumint(9) NOT NULL, - `version` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `version` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `content` (`epoch`,`version`), KEY `order` (`order`), -- cgit v1.2.3-70-g09d2