[aur-dev] [PATCH 1/2] 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 --- schema/aur-schema.sql | 8 1 file

[aur-dev] [PATCH 2/2] schema: Fix invalid NULL on primary key

>From the mysql 5.7 breaking change page: Columns in a PRIMARY KEY must be NOT NULL, but if declared explicitly as NULL produced no error. Now an error occurs. For example, a statement such as CREATE TABLE t (i INT NULL PRIMARY KEY) is rejected. The same occurs for similar ALTER TABLE statements.