Bugfix: 1.5.38 Upgrade SQL syntax error (<=MySQL 5.7)

GaryAllan · GaryAllan · commit 104b3ddc19cd · 2021-11-03T13:44:13.000Z
diff --git a/db/SCHEMA.sql b/db/SCHEMA.sql
@@ -93,7 +93,7 @@ CREATE TABLE `logs` (
   `date` varchar(32) DEFAULT NULL,
   `username` varchar(255) DEFAULT NULL,
   `ipaddr` varchar(64) DEFAULT NULL,
-  `command` text DEFAULT '0',
+  `command` text DEFAULT NULL,
   `details` text DEFAULT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
