combine ticket notification scrips, #15353

[freeside.git] / rt / etc / schema.mysql-4.1

diff --git a/rt/etc/schema.mysql-4.1 b/rt/etc/schema.mysql-4.1
index 172e477..edd3ded 100755 (executable)
--- a/rt/etc/schema.mysql-4.1
+++ b/rt/etc/schema.mysql-4.1
@@ -289,6 +289,7 @@ CREATE TABLE Tickets (
   Due DATETIME NULL  ,
   Resolved DATETIME NULL  ,
 
+  WillResolve DATETIME NULL  ,
 
   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
   LastUpdated DATETIME NULL  ,
@@ -386,6 +387,7 @@ CREATE TABLE CustomFields (
   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
   LastUpdated DATETIME NULL  ,
   Disabled int2 NOT NULL DEFAULT 0 ,
+  Required int2 NOT NULL DEFAULT 0 ,
   PRIMARY KEY (id)
 ) TYPE=InnoDB CHARACTER SET utf8;