diff options
| author | Erich Eckner <git@eckner.net> | 2019-07-31 11:23:29 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2019-07-31 11:23:29 +0200 |
| commit | 9ce5edd59b68a3f3fe2549d26dd9e029c79bb480 (patch) | |
| tree | a57770e6cec879402544c03e41627341ebbacdb8 | |
| parent | c7bae48dc15921966450ea6a9fbf0d27ecf56834 (diff) | |
| download | builder-9ce5edd59b68a3f3fe2549d26dd9e029c79bb480.tar.xz | |
misc/database-layout.dump: enforce "NOT NULL" on several columns
| -rw-r--r-- | misc/database-layout.dump | 10 |
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`), |