Various fixes to fix bug #226, comment #562, removed extension dependency register...

[mailer.git] / install / tables.sql

diff --git a/install/tables.sql b/install/tables.sql
index 0e8fea2963fe612f14776a0fd66df40ae3cfcafc..8bbafe0e8695d54c77f896ffc5d7c693103d81f7 100644 (file)
--- a/install/tables.sql
+++ b/install/tables.sql
@@ -174,7 +174,7 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_refsystem` (
 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,
+  `assigned_admin` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
   `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',