userid shall be NULL by default everywhere possible

[mailer.git] / install / tables.sql

diff --git a/install/tables.sql b/install/tables.sql
index 9a177b93d37e1b031418b9dfdadfa9340fd0167f..ee3a53a11ec65cc5200342a8812aa073bde21eda 100644 (file)
--- a/install/tables.sql
+++ b/install/tables.sql
@@ -175,7 +175,7 @@ DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_task_system`;
 CREATE TABLE `{?_MYSQL_PREFIX?}_task_system` (
   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
   `assigned_admin` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-  `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+  `userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
   `status` ENUM('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL DEFAULT 'NEW',
   `task_type` VARCHAR(255)  NOT NULL DEFAULT 'FIRST_USER',
   `subject` VARCHAR(255) NOT NULL DEFAULT '',