diff options
| author | Florian Pritz <bluewind@xinu.at> | 2017-04-15 20:31:37 +0200 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2017-04-16 10:35:42 +0200 |
| commit | 09cb61ab83af531a1b4ea43fd96313314d964726 (patch) | |
| tree | d15f6aa70729c199201ffc1a3e5df516865e6609 | |
| parent | 906a8f12cc3f0d9cfd595421c450bbcffde67c18 (diff) | |
| download | aur-09cb61ab83af531a1b4ea43fd96313314d964726.tar.gz aur-09cb61ab83af531a1b4ea43fd96313314d964726.tar.xz | |
schema: Remove invalid default values for TEXT columns
When running in strict mode, mysql throws an error upon encountering
these definitions since they are not supported.
References:
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
| -rw-r--r-- | schema/aur-schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index b42b45d1..b3e4ecbb 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -80,7 +80,7 @@ CREATE TABLE PackageBases ( NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, Popularity DECIMAL(10,6) UNSIGNED NOT NULL DEFAULT 0, OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL, - FlaggerComment TEXT NOT NULL DEFAULT '', + FlaggerComment TEXT NOT NULL, SubmittedTS BIGINT UNSIGNED NOT NULL, ModifiedTS BIGINT UNSIGNED NOT NULL, FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL, -- who flagged the package out-of-date? @@ -253,7 +253,7 @@ CREATE TABLE PackageComments ( ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, PackageBaseID INTEGER UNSIGNED NOT NULL, UsersID INTEGER UNSIGNED NULL DEFAULT NULL, - Comments TEXT NOT NULL DEFAULT '', + Comments TEXT NOT NULL, CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0, EditedTS BIGINT UNSIGNED NULL DEFAULT NULL, EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL, @@ -331,8 +331,8 @@ CREATE TABLE PackageRequests ( PackageBaseName VARCHAR(255) NOT NULL, MergeBaseName VARCHAR(255) NULL, UsersID INTEGER UNSIGNED NULL DEFAULT NULL, - Comments TEXT NOT NULL DEFAULT '', - ClosureComment TEXT NOT NULL DEFAULT '', + Comments TEXT NOT NULL, + ClosureComment TEXT NOT NULL, RequestTS BIGINT UNSIGNED NOT NULL DEFAULT 0, Status TINYINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), |