summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-07-31 11:23:29 +0200
committerErich Eckner <git@eckner.net>2019-07-31 11:23:29 +0200
commit9ce5edd59b68a3f3fe2549d26dd9e029c79bb480 (patch)
treea57770e6cec879402544c03e41627341ebbacdb8
parentc7bae48dc15921966450ea6a9fbf0d27ecf56834 (diff)
downloadbuilder-9ce5edd59b68a3f3fe2549d26dd9e029c79bb480.tar.xz
misc/database-layout.dump: enforce "NOT NULL" on several columns
-rw-r--r--misc/database-layout.dump10
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`),