misc/database-layout.dump: enforce "NOT NULL" on several columns

1 files 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`),